March 15, 2009 22:39
Hi
thanks for the plotter, I have modified your excel sheet and script to add some instruments as well as create tacking angles on port and starboard as well as header and lift info. Basically your 1 min graph is on top followed by a readout of instruments, the last column is MWA - Median Wind Angle and can be increased or decreased by the two macro buttons just below it, the number to the left of PORT and STARBOARD is your upwind tacking angle and the number to the right is your downwind jibing angle for spinnaker, the number to the top is just dead run for downwind main and jib. The sailing angles are based on Windspeed, so there are three conditions LIGHT AIR <10kts MED AIR 10-14 Kts HEAVY AIR >14kts, you can change the boat data values (off to the right of the spreadsheet) to suite your boat. Once you set your MEDIAN WIND ANGLE it will display if you are on a HEADER, AVERAGE, LIFT and will display the amount of the header or lift in degrees. Thanks for figuring out how to do the chart strip using applescript and excel. I'm looking forward to trying this out on the race course once my boat goes back in the water. I've enclosed my changes in the interest of sharing!!
cheers
Darren
thanks for the plotter, I have modified your excel sheet and script to add some instruments as well as create tacking angles on port and starboard as well as header and lift info. Basically your 1 min graph is on top followed by a readout of instruments, the last column is MWA - Median Wind Angle and can be increased or decreased by the two macro buttons just below it, the number to the left of PORT and STARBOARD is your upwind tacking angle and the number to the right is your downwind jibing angle for spinnaker, the number to the top is just dead run for downwind main and jib. The sailing angles are based on Windspeed, so there are three conditions LIGHT AIR <10kts MED AIR 10-14 Kts HEAVY AIR >14kts, you can change the boat data values (off to the right of the spreadsheet) to suite your boat. Once you set your MEDIAN WIND ANGLE it will display if you are on a HEADER, AVERAGE, LIFT and will display the amount of the header or lift in degrees. Thanks for figuring out how to do the chart strip using applescript and excel. I'm looking forward to trying this out on the race course once my boat goes back in the water. I've enclosed my changes in the interest of sharing!!
cheers
Darren