PCSail - Excel sheet to make VPP for Sailing yachts

[jonasaberg]

Some time ago I promised to look through my archive to find PCSail, an Excel sheet that go through the calculations from the Delft reports and Larson's book about yacht design to calculate the boat speed as a function of true wind speed, true wind angle and the hull and sail characteristics of a boat.

Unfortunately I can't find the thread...silly...I know.
I hope those interested in this will find this...was it maybe rgleason?

Anyway, the problem with the excel sheet, developed by a student and presented at the Chesapeak Sailing Yacht Symposium about ten years ago is that it was made in Excel2000, making heavy use of macros for that particular version of Excel. I have never used it in newer versions of Excel than that, and have not used Excel2000 for several years now.

If anyone can make it work in a new version (preferably OpenOffice or LibreOffice) please post it somewhere again!

To unpack the files, remove the .doc ending and unpack with some unzipping software.

Regards
Jonas
(VPP in this context stands for "velocity prediction plot")

A nice paper that investigates the accuracy of PCsail can be found here. It is really quite good. The authors have compared the calculations with simulations with model yachts in a water tank testing facility.
http://www.usna.edu/Users/naome/phmiller/MTcombo.pdf