[Able72]

Okay. I'm working with excel.

I am trying to build an excel spreadsheet to help with the timing of my torpedo shots in U-boat (although this would work equally well with SH3-5).

Assuming you know the following:
Range to target at torpedo launch
Speed of target at torpedo launch
AOB at torpedo launch
Speed of torpedo

I am trying to calculate the run time of the torpedo to impact with the target.

I can't seem to find the formulas I need. Anyone have links or helpful information? Thanks.

I know I need to solve the torpedo triangle problem, but I can't seem to figure out the angles and distances involved or find formulas to help me do this. Can someone help?