View Single Post
Old 03-31-24, 06:23 PM   #4
Able72
Captain
 
Able72's Avatar
 
Join Date: Mar 2008
Location: Somewhere in the North Atlantic
Posts: 343
Downloads: 299
Uploads: 0
Default

So...It took some digging and more frustration that I care to consider, but I finally figured out the answer to my problem. So I'm putting it here in case anyone else needs it or in case I delete the spreadsheet I made (again, don't ask).

If you know:
Range to Target
Target Speed
AOB
Torpedo Speed

The frustrating part about excel is that it calculates Sin, Cosin, Tan, etc, based on Radians, not Degrees. Therefore you have to employ the Radians and Degrees convertor in the right location to make the formulas work out. Using the values from the video below allowed me to check my formulas for accuracy.
Then you can calculate the following (formulas are for Excel):

Angle at Impact=180-(AOB + Lead Angle)

Lead Angle=DEGREES(ASIN(Target Speed*SIN(RADIANS(AOB))/Torpedo Speed))

Target Travel Distance to Impact=Range to Target*SIN(RADIANS(Lead Angle))/SIN(RADIANS(Angle at Impact))

Range to Impact=Range to Target*SIN(RADIANS(AOB))/SIN(RADIANS(Angle at Impact))

Time to Impact=Range to Impact/(Torpedo Speed*0.514444)

Mind you, these formulas are only useful for calculating the time to impact from torpedo launch (not gyro angles etc. and are closer to accurate the smaller your gyro angle).

These formulas also assume you are using the following units of measurement: Speed is in Knots and Distance is in Meters.

I found this video helpful in calculating this:

And this page helpful for solving the rest of the triangle: https://www.calculator.net/triangle-calculator.html
__________________
"Some ships are designed to sink, others require our assistance." Nathan Zelk
Able72 is offline   Reply With Quote