rod_stewart
Outstanding Contributor
"<center><table border=1><tr><
"<center><table border=1><tr><td>http://www.marineengine.com/discus/icons/mime_msexcel.gif""" align=left alt=""application/vnd.ms-excel"">Boat Speed Finder
[url=""][b]Boat Speed Finder.xls[/b][/url] (22.5 k)</td></tr></table></center>
"How fast will my boat go?" or "What prop should I use?" seem to be common questions. You can use the attached spreadsheet if you have Excel to find the answers to both.
Just put in the data in aqua, and the sheet will do the rest. It is based on the Merc website method, but allows you to find your performance at different elevations and air temps, if you are not at sea level. It also enables you to quickly find the best prop pitch for your particular case.
You should find the predicted speed closely matches what your boat can do. To fine tune, adjust the slip % to match. Then you can quickly check the effect of increasing horsepower. You can also easily see the effects of adding more people, higher air temp, etc.
This is a work-in-progress to please feel free to ask any questions, or offer any suggestions. I will try to post any new improved versions that develop.
Rod"
"<center><table border=1><tr><td>http://www.marineengine.com/discus/icons/mime_msexcel.gif""" align=left alt=""application/vnd.ms-excel"">Boat Speed Finder
[url=""][b]Boat Speed Finder.xls[/b][/url] (22.5 k)</td></tr></table></center>
"How fast will my boat go?" or "What prop should I use?" seem to be common questions. You can use the attached spreadsheet if you have Excel to find the answers to both.
Just put in the data in aqua, and the sheet will do the rest. It is based on the Merc website method, but allows you to find your performance at different elevations and air temps, if you are not at sea level. It also enables you to quickly find the best prop pitch for your particular case.
You should find the predicted speed closely matches what your boat can do. To fine tune, adjust the slip % to match. Then you can quickly check the effect of increasing horsepower. You can also easily see the effects of adding more people, higher air temp, etc.
This is a work-in-progress to please feel free to ask any questions, or offer any suggestions. I will try to post any new improved versions that develop.
Rod"