|
|
|
|
|
|
|
|
|
|
|
|
|
Read Me First |
How To |
Do not work with your only saved
version of this sheet, make a copy! |
|
|
|
|
|
Denotes a cell for user data input. |
|
|
|
Denotes a cell that has carried data forward from another area. |
|
|
|
Denotes a cell that has produced a result from a formula. |
|
|
|
Do NOT attempt to
enter data anywhere except a
green cell! |
|
|
|
|
|
This is a freeware
product knocked up in my spare time. It is not meant to be a commercial
product and |
|
so it is possible to get
stupid answers by using bad data. While some attempt has been made to track
this |
|
a small dose of common
sense when using this sheet will work wonders! |
|
|
|
Numerical Conventions and
Units used. |
|
|
|
This
spreadsheet is exclusively based upon the Imperial system of measurement. |
|
|
This
spreadsheet works internally to a high degree of precision, but input and
displayed |
|
|
data is limited to a level of
precision that is considered both meaningful and practical |
|
|
for the end user. |
|
|
A Metric to Imperial conversion
utility is included. |
|
|
|
General Overview. |
|
|
|
The
calculation of propeller data can soon become an immensely complex task. The
user |
|
|
will understand that winter waters
near the outflow of a large river will be denser |
|
|
than
summer waters in the med. Add in hull fouling over the season, sea state,
hull profiles and |
|
|
coatings, and it can soon be seen
that there is no nice mathematical solution to be had. |
|
|
|
Due
to these variables propeller selection has always been a bit of a black art,
in |
|
|
that it is practically impossible
for the average sailor to determine whether his |
|
|
vessel
is fitted with the ideal prop. Even a prop that just absorbs full motor power
may well |
|
|
be less than ideal, as there is more
than one pitch/diameter/area/profile that will absorb any |
|
|
given amount of power. |
|
|
|
The object of this spreadsheet is to
allow the user to enter a few items of readily obtainable |
|
|
data, data which is of a concrete
nature, such as waterline length, and for the spreadsheet |
|
|
to do all the complex calculations
and produce a set of simple figures which the user |
|
|
can then comprehend easily and use
as a shopping list spec. |
|
|
|
By the nature of the medium, the
results produced will indicate a "best match" solution. |
|
|
Bear in mind that there is no unique
solution, as every change in each variable such as |
|
|
water
salinity (density) will alter the ideal prop spec. Only high budget powerboat
racers |
|
|
have the luxury of selecting from 10
or 20 different props according to the conditions at |
|
|
the time of the race. |
|
|
|
Weird Results. |
|
|
|
There is an old saying in computers,
Garbage In, Garbage Out. So check your data |
|
|
carefully, particularly if the
results generated are off what you would expect. |
|
|
|
It is quite possible, even likely,
that owners of production vessels will find that the results |
|
|
generated indicate a different set
of figures to the actual specification of their vessel. This |
|
|
is due to the fact that the boat
manufacturer has to juggle many other items in the equation, |
|
|
such as engine power versus
accommodation volume, etceteras. This is even true of very expensive |
|
yachts, so do not assume that the
results produced are wrong just because they do not match |
|
|
the original spec of your quarter of
a million pound yacht! |
|
|
|
This sheet has been thoroughly
checked against actual real world figures on a very wide sample |
|
|
of vessels (3 figure sample) and it
produces excellent results. It does produce better data for true |
|
|
displacement
hulls than any other form, but data produced for semi-displacement hulls is
still |
|
|
extremely good. Data produced for
planing hulls is good, but should be treated as an "expert |
|
|
guide" rather than a rule of
law. Exotica such as surface propellers and hydrofoils are not |
|
|
modelled very well. Note that all
hull types, even racing hydrofoils, fit the numbers well when |
|
|
off the plane and acting as
displacement hulls. |
|
|
|
What this isn't. |
|
|
|
This sheet does not attempt to be a
learning resource, there are enough textbooks |
|
|
already out there on the subject, so
you won't be gaining enlightenment through the use |
|
|
of this sheet. What you will be
doing is inputting a few figures and getting good answers. |
|
|
Very useful when planning the
re-engine project in the winter evenings, or impressing the |
|
|
Commodore
of the local yacht club, or just maximising fuel economy and
"oomph" from your |
|
|
existing set-up. |
|
|
User are also asked to
note that the bulk of the individual sheets are there merely for |
|
|
those that wish to see
"under the bonnet". The data generated is used and collated |
|
|
into the same sheet as
Data Input. So results are immediately presented next |
|
|
to input without the need
to click through the whole spreadsheet. |
|
|
|
|
|
Some Notes. |
|
|
|
|
|
Many sailors worry about
the drag of a "big" three bladed prop. This can be dramatically reduced |
|
|
if the prop and shaft
are allowed to rotate freely in the wake. Check your gearbox design before |
|
|
doing this as it may result in damage. Fit a
"de-coupler" if needed. |
|
|
Lower shaft RPM = higher
prop pitch and less drag when sailing, but also = larger prop diameter |
|
|
when motoring. Large
prop dia = efficient thrust = less effects of short seas or windage
"braking" |
|
|
EVERY
prop represents a trade-off somewhere in the equation, personally I would
recommend a |
|
|
motor / gearbox / prop
spec that will drive your hull at hull speed and create a reasonable bow wave |
|
|
with an
"ideal" 33% DAR 3 blade prop. This will always get you off lee
shores, tow, be economical etc. |
|
Use of any other
configuration will restrict the maximum performance of your vessel when |
|
|
motoring. This could have serious safety repercussions in adverse
conditions. |
|
|
|
|
|
Copyright and
Distribution. |
|
|
|
|
This product is exclusive Copyright
of Surfbaud 1998 / 1999 / 2000 |
|
|
Surfbaud
acknowledge copyright of Microsoft for Excel and Windows95, on which this |
|
|
spreadsheet was created. |
|
|
Surfbaud produce this work as freeware. |
|
|
Freeware may be freely distributed
and copied, but NO CHARGE
whatsoever may be made. |
|
|
Surfbaud EXPRESSLY
PROHIBIT any and all alterations of whatever form of
any part of this work. |
|
|
|
If you wish, you may examine the
formulae contained, and re-use them in another product or |
|
|
application, but you must NOT copy
and paste to do so. If you do reverse engineer this work |
|
|
to create an new and different work,
Surfbaud would appreciate an acknowledgement. |
|
|
|
No
responsobility is accepted for any loss or injury, financial or otherwise,
arising out of use |
|
|
of this work. It is meant
as a guide, not a bible. |
|
|
|
|
|
|
|
|
|
|
|
|
|