Desperately Need Excel Expert

[robj250]

Well, I just entered the data to intercept the large convoy and the intercept time was 1 hr 3 min ahead of the calculated time when we got our first sound contact. Now the weather was really bad, we had waves 10 metres high and our conning tower was underwater 1/3 of the time on the trip.

However, I believe the time error is directly caused by the fact that plotting on a printed 8 1/2 x 11 page for a 50 scale map is not that accurate and only an approximation.:hmm:

So, it's not likely that I will post the spreadsheet on my web site for downloading.

Hmm, it is now 7:51 and they are just about here so the time intercept was pretty good. as we're supposed to intercept at 8:06

[robj250]

Originally Posted by robj250

Well, I just entered the data to intercept the large convoy and the intercept time was 1 hr 3 min ahead of the calculated time when we got our first sound contact. Now the weather was really bad, we had waves 10 metres high and our conning tower was underwater 1/3 of the time on the trip.

However, I believe the time error is directly caused by the fact that plotting on a printed 8 1/2 x 11 page for a 50 scale map is not that accurate and only an approximation.:hmm:

So, it's not likely that I will post the spreadsheet on my web site for downloading.

Hmm, it is now 7:51 and they are just about here so the time intercept was pretty good. as we're supposed to intercept at 8:06

I re-calculated everything, checked my measurements and it predicted the intercept to be 8:02 and at that time I was right in the middle of the convoy and the distance I could see was only about 300 m because of the heavy fog, but I picked up a passenger liner and sent a salvo of 4 tubes and sunk it.

So instead of travelling all that way to my patrol zone, I'm going to hang around AM76 and see what I can pick off with my three remaining torpedoes. I'm not going to bother to go to my patrol zone.