Determining Angle on Bow - reliable mathematical approach found - Page 2

Davidorado · 07-14-23, 09:12 AM

Okay, I managed to translate it as good as I could.
The coloumns A-AG are just general conversion tables I use on my patrols. I group these together with the little "-" sign above the coloumns.
AH-AU is where the AoB part lives in. Lines 1-30 is a conversion table of the calculator you find in AI42-AJ46 (origin is from DonL1978´s AgruFront-Lehrmaterialien) in case you don´t like calculating.
Generally: Every cell, where you have to enter data, is coloured gold. All of the others aren´t intended to get touched.

AI33-AS40 is the first AoB calc approach using the mast height, ship length and apparent ship length/height. The screenshots should guide you what is actually needed. The worksheet is protected, but you can click "unprotect sheet" (no password).

The second calc AI42-AJ46 is using the distance and the ship length in meter and now you need the difference of the bearing from bow to aft of the ship. DonL1978´s screenshots should assist you.
You measure the bearing to the bow of the enemy ship, the bearing to the aft, subtract it from the first bearing, divide it by to and enter it in the bearingdifference field.

The third uses a different method where you have to enter your speed, your course, the bearing and distance to target once, take the stopwatch, wait 5-15 min and take bearing and target distance a second time. You get the enemy course, speed and the AoB.

I used all three of these a few times but got mixed results. Please test it and say if I made any mistakes or you have something to criticize.

https://www.mediafire.com/file/w3oxe...-eng.xlsx/file

07-14-23, 09:12 AM	#16
Davidorado Swabbie Join Date: Jun 2011 Posts: 6 Downloads: 27 Uploads: 0	Okay, I managed to translate it as good as I could. The coloumns A-AG are just general conversion tables I use on my patrols. I group these together with the little "-" sign above the coloumns. AH-AU is where the AoB part lives in. Lines 1-30 is a conversion table of the calculator you find in AI42-AJ46 (origin is from DonL1978´s AgruFront-Lehrmaterialien) in case you don´t like calculating. Generally: Every cell, where you have to enter data, is coloured gold. All of the others aren´t intended to get touched. AI33-AS40 is the first AoB calc approach using the mast height, ship length and apparent ship length/height. The screenshots should guide you what is actually needed. The worksheet is protected, but you can click "unprotect sheet" (no password). The second calc AI42-AJ46 is using the distance and the ship length in meter and now you need the difference of the bearing from bow to aft of the ship. DonL1978´s screenshots should assist you. You measure the bearing to the bow of the enemy ship, the bearing to the aft, subtract it from the first bearing, divide it by to and enter it in the bearingdifference field. The third uses a different method where you have to enter your speed, your course, the bearing and distance to target once, take the stopwatch, wait 5-15 min and take bearing and target distance a second time. You get the enemy course, speed and the AoB. I used all three of these a few times but got mixed results. Please test it and say if I made any mistakes or you have something to criticize. https://www.mediafire.com/file/w3oxe...-eng.xlsx/file Last edited by Davidorado; 07-14-23 at 09:48 AM.