World Magnetic Model Google spreadsheet Application
The WMM Google spreadsheet allows user to calculate declination values for mutiple points. The user may upload a file with location, altitude and date information to this
spreadsheet. The user needs only a google account and a browser to use this application and it works on any operating systems. You do not have to install any extensions and
the technique will work just fine in the web and mobile version of Google Drive. The multithread processing of spreadsheet calculations
are very fast.
Setting the Stage
If you would like to set it up for your Google Drive, all you need is a minute. Just follow these easy steps:
- Assuming that you are logged in to your Google account, create a copy of this sheet in your Google Docs (now Google Drive).
- Open the sheet and you should see example worksheet. Start by changing the input fields. You should see the declination values get automatically updated.
- You may import your data on to the work sheet. The required inputs are altitude, latitude, longitude and year.
- Altitude (km) - Height above the WGS84 ellipsoid. For most uses, it is safe to use the height above mean sea level (MSL)
- Latitude (decimal degrees) - Positive for northern hemisphere, negative of southern hemisphere. 40 degree 30 minutes = 40 degrees + (30/60) minutes = 40.5 decimal degrees
- Longitude (decimal degrees) - Positive for eastern hemisphere, negative for western hemisphere. 105 degrees 15 minutes west = 105 + (15/60) minutes West = -105.25 degrees
- Year - Year or decimal fraction of year for which to compute the declination. This must be within the range of the current model, at present the WMM2010 is valid for 2010.0 to 2014.9. An Excel or Google spreadsheet date entry (example: 12/31/2012), may be converted to decimal year by = YEAR(A1)+(A1-DATE(YEAR(A1),1,1))/(DATE(YEAR(A1),12,31)-DATE(YEAR(A1),1,0)). Here A1 is the date cell.
- Calculate the declination for the first row by typing =GetWMM(A2, B2, C2, D2) on cell E2. You may re-arrange the data in any form you like - but feed the GetWMM function with the all four parameters in the above described order.
- Drag the E2 cell all the way down to calculate the declination values for the other rows - or just by double clicking E2.
Behind the Scene
the calculator (for example calculate the other components of the magnetic field) by tweaking the script. The program runs on Google servers - not on your computer. We have not noticed any daily limit on the calculations - but you might hit a limit if you calculate millions of points per day!
Wednesday, 12-Dec-2014 10:22:11 MST