Saturday, February 6, 2010

[Electric Boats] Tide planner

 

Sailing in SF Bay with an electric boat has proven that planning around the tides is essential. So I wrote a little script that parses the current tables from http://wolfweb.unr.edu/homepage/edc/tides/2010/sfbe_fr10.html (itself a useful resource) and turns it into a file you can load into excel - and if you know how to use filters can spit out the answer to "what weekend days have an ebb occurring in the morning". Which means I can get to cityfront and back without killing my batteries.

[This is somewhat tedious to do using the tidebooks].

Here's a sample of the output from that exact query:

Month Day Dayname Event Time Speed
1 23 Sa Ebb 948 3.5
1 24 Su Ebb 1045 3.8
2 6 Sa Ebb 959 3.7
2 7 Su Ebb 1109 3.7 << +weather = why Keith is sailing tomorrow...
2 20 Sa Ebb 814 3.5
2 21 Su Ebb 912 3.6
3 6 Sa Ebb 817 3.8
3 7 Su Ebb 921 3.5
3 21 Su Ebb 843 3.9
4 4 Su Ebb 841 3.8
6 5 Sa Ebb 1108 2.2
6 19 Sa Ebb 1035 2.8
7 3 Sa Ebb 926 2.5
7 4 Su Ebb 1020 2
7 17 Sa Ebb 910 3.2
7 18 Su Ebb 1010 2.3
7 31 Sa Ebb 805 3
8 1 Su Ebb 851 2.4
8 15 Su Ebb 849 2.7
10 30 Sa Ebb 1041 2.1
11 13 Sa Ebb 942 1.9
11 14 Su Ebb 1039 2.2
11 27 Sa Ebb 821 2.4
11 28 Su Ebb 919 2.8
12 11 Sa Ebb 801 2.1
12 12 Su Ebb 852 2.3

I have uploaded the raw CSV file to the files section, you'll have to do your own filter. I hope at least some of you find this useful. If there is some interest I may go ahead and create a web page around it in which you can enter your current/time offsets (in the back of the books) and your own filter criteria. If I can find the data, it's easy to adapt for Puget, Chesapeake, etc. as well.

-Keith

__._,_.___
.

__,_._,___

No comments:

Post a Comment