Desperately Need Excel Expert

robj250 · 07-15-06, 06:37 PM

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

07-15-06, 06:37 PM	#10
robj250 Sea Lord Join Date: Mar 2006 Location: Port Hardy, BC, Canada 75 yo with M.S. & C.O.P.D. & heart problems Posts: 1,930 Downloads: 1 Uploads: 0	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 Last edited by robj250; 07-15-06 at 09:06 PM.