WMM2015 Spreadsheet Application
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
Still loading...
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Altitude (km). Height above the WGS84 ellipsoid. For most uses, it is safe to use the height above mean sea level (MSL). Latitude - in decimal degrees, positive for northern hemisphere, negative of southern hemisphere. 40 degree 30 minutes = 40 degrees + (30/60) minutes = 40.5 decimal degreesLongitude - in decimal degrees, positive for eastern hemisphere, negative for western hemisphere. 105 degrees 15 minutes west = 105 + (15/60) minutes West = -105.25 degreesYear - 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 WMM2015 is valid for 2015.0 to 2020.0
The if a cell contains a date in the format mm/dd/yyyy, it may be converted to decimal year by using the spreadsheet formula =YEAR(A1)+(A1-DATE(YEAR(A1),1,1))/(DATE(YEAR(A1),12,31)-DATE(YEAR(A1),1,0))
Declination (Magnetic Variation) - Calculated angle, in decimal degrees, between true and magnetic north, positive for east and negative for west declination. 10.5 degrees = 10 degrees + (.5*60) minutes = 10 degrees 30 minutes . Any error in the input is indicated by -999.000Declination - Test Values.
2
102801202015.10.410.41
3
1020-102015.1-9.33-9.33
4
102-801202015.1-143.05-143.05
5
95801202015.70.230.23
6
950-102015.7-9.26-9.26
7
95-801202015.7-143.16-143.16
8
188801202016.30.350.35
9
1880-102016.3-9.21-9.21
10
188-801202016.3-143.73-143.73
11
19801202016.9-0.39-0.39
12
190-102016.9-9.10-9.1
13
19-801202016.9-143.11-143.11
14
104801202017.5-0.24-0.24
15
1040-102017.5-9.05-9.05
16
104-801202017.5-143.64-143.64
17
242801202018.10.040.04
18
2420-102018.1-9.01-9.01
19
242-801202018.1-144.40-144.4
20
268801202018.7-0.05-0.05
21
2680-102018.7-8.94-8.94
22
268-801202018.7-144.65-144.65
23
23801202019.3-1.09-1.09
24
230-102019.3-8.82-8.82
25
23-801202019.3-143.72-143.72
26
62801202019.9-1.10-1.1
27
620-102019.9-8.76-8.76
28
62-801202019.9-144.04-144.04
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...
 
 
 
Sheet1