My excel sheet is way too messy to be presentable, but here's a step-by-step guide to making your own:
Inputs:
UTM N
UTM E
Distance to next WPT (in meters)
Bearing to next WPT (in degrees)
Magnetic declination - in either decimal degrees (e.g. 6.216°) or in degrees and arc minutes (6° 13' etc.).
Calculation:
First of all, if your magnetic declination is in degrees + arc min, convert to decimal degrees. Let's use the example above (6° 13'):
Decimal degrees = 6° + (13'/60) = 6,216°All angles need to be in radians (at least by default in Excel):
Radians = angle*PI()/180You then calculate the UTM coordinates of your next waypoint:
New UTM N = cos(bearing+mag decl.)*(distance/10)+UTM N New UTM E = sin(bearing+mag decl.)*(distance/10)+UTM E