-
Difficulty:
-
-
Terrain:
-
Size: 
(not chosen)
Please note Use of geocaching.com services is subject to the terms and conditions
in our disclaimer.
The spreadsheet is here: Click here to download spreadsheet
Email to georapper the modified spreadsheet to:cacher03@yahoo.com
This cache is a GPS Location test. I want to plot on an Easting/Northing Grid, the UTM coordinates of each cacher that finds this location. The location is a large light pole in a large parking lot that cannot be missed. the nearest light pole is over 100ft radius away.
If you want to log this cache, find the light pole location, sign the log book, obtain the password in the rock bed next to the light pole, unprotect the document, then download and edit the spreadsheet contents, input your UTM coordinates that you have for this location into a spreadsheet.
The purpose is to provide a fixed location for each cacher to input the UTM coordinates into an spreadsheet for graphing to show the variation and distribution of UTM coordinates for a fixed location. You cannot edit the excel spreadsheet unless you have the password. you can read the spreadsheet prior to finding the lightpole to find out what information you need to gather, once you find the lightpole, and get the password, you can edit and input your own information.
This is not a GPS ACCURACY test. I simply want to see the variation and distribution of UTM coordinate for different gpsr's, and other parameters as listed below and in the excel spreadsheet.
The parameters listed in the spreadsheet and to be inputted by each cacher are:
columns A and B: Last 3 digits of northing and easting coordinates, (i.e. should not be off more than 100m),
column C: EPE in ft, if applicable,(i.e. if WAAS is not used.)
column D: Geocaching ID,
column E: Make/Model of GPS,
column F: was WAAS accuracy on, (i.e. yes or no, I don't use WAAS on my Merigreen, I turned it off)
column G: weather, (i.e. sunny,partly cloudy (pc), overcast,)
column H: military time of day,
column I: day of week.
Each cacher should input their own data on a new row, then upload the excel spreadsheet for the next cacher to download and add their new data. As each successive cacher inputs their own data, I want to see if there are clusters of data around specific parameters or if the data is randomly distributed.
I realize this is not a scientific test and not as exhaustive as it could be but I want to see if the data clusters around some parameters in southeast idaho area. This is just an interesting and easy test, that is all.
I realize some cachers may not have excel spreadsheet, if not, put the coordinates and other parameters as listed above in your log and the I will put the data in the spreadsheet. As more and more cachers put the coordinates in the spreadsheet, it will be interesting to see if there are any trends emerging with different parameters.
To Summarize:
1. download the excel spreadsheet from the most recent log, (i.e. click on the most recent log gps-location-excel-spreadsheat icon in the log, then click on the "NOT AN IMAGE" icon to download the excel spreadsheet),
2. note the parameters to be entered before you find the site,
3. to input your own data, unprotect the worksheet with the password obtained from the cache site, otherwise the spreadsheet is read-only, (i.e. go to Tools, Protection in the drop down menu and unprotect the sheet only),
4. once you have obtained your coordinates at the light pole and have the other data,
5. enter the data in the spreadsheet or put the data in a log for the cacher owner to enter the data,
6. protect the worksheet again using the same password,
7. upload the excel spreadsheet for the next cacher to do the same and see the variation and distribution.
I have been to the location 2 times, different days and times, and was within 1 meter in both the easting and northing coordinates with different epe as observed on the spreadsheet. I will try at a later time to see the difference in my own gpsr.
If you have any questions or don't understand this, please email the owner who will attempt further explanation.
Additional Hints
(No hints available.)