![]() |
SUBSIM: The Web's #1 resource for all submarine & naval simulations since 1997 |
|
![]() |
#1 | |
Grey Wolf
![]() Join Date: Sep 2011
Posts: 979
Downloads: 256
Uploads: 0
|
![]() Quote:
Easiest method beside eyeballing it is to plot. Range, bearing mark. Wait 3:15. Then range, bearing mark. You now have speed and course. With course, you can draw AoB. U don't have to be all that accurate on range and bearing. The key is to get the speed. The two plotted points get you course. If you do it early enough, you can get at least 3 points. The more points you plot, the more your error goes down. As long as you aren't trying for a shot from over 5 km away, AoB within a few degrees is fine. The key is accurate speed. |
|
![]() |
![]() |
![]() |
#2 | |
Swabbie
![]() Join Date: Jun 2011
Posts: 6
Downloads: 29
Uploads: 0
|
![]() Quote:
Yeah, you are right. To me itīs more about the theory and "how it COULD be done". I was just curious because I read about it and wanted to test it. Anyway, I found the solution to my problems: 1. In the "Agru-Front Lehrmaterialien" the formula contained a "tan^-1". The photo math app I used interpreted it as 1/x, which would be normally correct, but in this case itīs just a sign for arctan. But even with Excel I couldnīt solve this. Which leads me to number 2. Excel uses Radian. I wasnīt aware of this and never came it across in school. So I had to convert it. I built a simple Excel calculator around these formulas and I now have 2 approaches of solving this. 1. The approach with Length, Distance and the apparent length 2. Own Course, own speed and two measurements of the enemy bearing+distance. Usually you would wait 5-15min between these. Benefit of this approach is, you get target speed and and course too! You just enter the data and Excel calculates the AoB magically. Of course you would still use your brain. So if anybody needs this Excel sheet, I probably could upload it somewhere. ![]() |
|
![]() |
![]() |
![]() |
#3 |
Grey Wolf
![]() |
![]() |
![]() |
![]() |
![]() |
#4 |
Swabbie
![]() Join Date: Jun 2011
Posts: 6
Downloads: 29
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. |
![]() |
![]() |
![]() |
Thread Tools | |
Display Modes | |
|
|