Jaesen: Once again you have come to my rescue.
I will test this spread sheet on several missions before I post the spread sheet on my website for downloading in the event others like to plan their own interceptions with convoys or task forces the same way I do it.
I originally started this spreadsheet for my own purposes as I find it very difficult for me to do all my plotting using the map tools. So I do all my plotting by pen and paper, just like the Kaleun had to do in the old days. Now because I have thinking problem as you know, I had trouble with the spreadsheet - it wasn't working. Another person who was in the navy gave me a little help, but I didn't know how to use his information to determine intercept times. So, because of you, it looks like the spreadsheet will work.
However, as we all know, when I take a snap of the situation and print out the map, there is some distortion in the map, so there is a little room for error.