View Single Post
Old 07-12-23, 09:08 AM   #2
Davidorado
Swabbie
 
Join Date: Jun 2011
Posts: 6
Downloads: 30
Uploads: 0
Default

Quote:
Originally Posted by 3catcircus View Post
I wouldn't put much stock in this method. No one is going to thumb through a book of trig tables.

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.
Davidorado is offline   Reply With Quote