A “bearing” is a direction in navigation. Bearings are given for one point in relation to another. The bearing of point A relative to point B is expressed as an angle with respect to true north or magnetic north the unit of measure for the bearing is degrees. You can calculate the bearing of one point from another in Excel.
- Skill level:
- Moderately Easy
Open Excel with a new spreadsheet. You will create a model that will enable you to find the bearing between any two given points.
Stretch column A by clicking on the border between the “A” label and “B” label at the top of the spreadsheet. Drag the column across to give it the width of three standard Excel columns.
Click in A1 and type “Bearings Calculator.” Click on the “1” label for the row and increase the font size in the “Home” tab to 18. Click on the label again and press the “B” button in the “Home” tab, to make the text bold.
Type “Enter base point” in cell A3 and “Enter remote point” In A5. Type “Lat” in B3 and B5 and “Long” in D3 and D5.
Type “Bearing Calculation” in A7. Click on the “7” label of the row, press the “B” button in the “Home” tab and set the font size to 14.
Enter the following formula in B7: =MOD(ATAN2(COS(C3)SIN(C5)-SIN(C3)COS(C5)COS(E5-E3),SIN(E5-E3)COS(C5))+360,360). Enter values in lines 3 and 5 to get results from the formula.
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for