Hello.
As my title states I am trying to build a route card that automatically works out back bearings, time and pace.
I have filed out the form with some examples on how I would like this to be done.
1. I would like the grid bearing column (E) to automatically input into the Mag bearing column (F). What goes in the MAG column depend on the GMA input (calculations page) C2. For example if I put 3200 in Grid (column E) 3204 should appear in MAG (F), as it does. I would not want the GMA figure to appear in the MAG column unless a Grid figure has ben entered. As you can see it says 4 all the way down the MAG column.
2. I would like the Back (G) column to auto work out the 180 degree opposite to the mag (F) bearing. The military work n MILS not Degrees 360 deg = 6400 Mils. Therefore I need a formula where if the mg (F) is more than 3200 the opposite is -3200 and if F is less than 3200 then you add 3200.
E.g A mag (F) of 600 would give a BACK (G) result of 3800.
E.g A mag (F) of 3800 would give a BACK (G) result of 600.
3. My pace is 70 paces per 100m see (calculations E2). I would like it to automatically work this out.
eg if 200 is put in Dist. (H) then 140 will automatically be inputted in Pace (I)
4. In the Time (K) column I would like this the be automatically worked out. This will be worked out by using dist. (H) x calc G2 + Elev. (J)
eg. if I walk 100m at 4kph it will take me 1.5 mins. However if I have an elevation of 1 then I will add another min on to my time.
I have tried to have a crack at this but as you can imagine Royal Marine training barely allows much time to sleep, let alone embellish excel spreadsheets. Any assistance will be greatly appreciated. An example of how I would like it to look has been attached
Bookmarks