Stuff you need to make your gravity contour map (2005)

 

Pre-2004 gravity data (text file)

Spreadsheet that calculates UTM from Latitude/Longitude

Below are 3 stations occupied on 9/9/2004 that might not have been added to the data table you download from the link above.  Please add these stations, along with new 2005 stations, to the data file and export a single file that includes all information for all available stations.  NOTE: the table (below) taken from the first draft of a student report lacks information regarding which international formula was used and the value of the Bouguer reduction value.  As such, I would recalculate the simple Bouguer anomaly (SBA - should also be explained in the table caption!) before adding these stations to my data set.
----------------------------------------

Station

g observed (mgals)

Elevation (m)

Latitude (degrees)

Longitude (degrees)

UTM_N

UTM_E

SBA

g46101

980225.672

188.549

41.649

-83.622

4613931

281607.6

-64.8649

g46102

980226.920

181.051

41.651

-83.638

4614196

280334.8

-65.2352

g46103

980225.132

188.275

41.650

-83.646

4614053

279690.3

-65.4949

 

 

 

Table 1- g observed was calculated from the base station gravity and the change in dial units from the base station at each location. With elevation, latitude, and rock density the Simple Bouger Anomaly was calculated. Latitude and Longitude were measured with a GPS.
---------------------------------------------

Save the spreadsheet used to prepare the new stations and also the spreadsheet after the new stations have been appended.  I suggest setting up another worksheet (page) to which you copy X and Y coordinates, along with SBA and elevation, the file you will use to make Surfer maps.

Hint - reducing the need to rewrite.  Make certain that your captions do not lack elements I have pointed as missing in your earlier reports or elements I note are missing in the above section copied from a first draft from last year.

Return to Schedule

Hit Counter