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.