> 32 \puser Ba==E<"8@"1Arial1Arial1Arial1Arial1Arial10Arial10Arial1Arial1
Arial1
Arial1
Arial1
Arial1=Arial1=Arial1Arial1Arial1$Arial14Arial1
Arial1=Arial1
Arial10Arial1>Arial"$"#,##0_);\("$"#,##0\)!"$"#,##0_);[Red]\("$"#,##0\)""$"#,##0.00_);\("$"#,##0.00\)'""$"#,##0.00_);[Red]\("$"#,##0.00\)7*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_).))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)?,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)6+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)""#,##0;\-""#,##0""#,##0;[Red]\-""#,##0""#,##0.00;\-""#,##0.00#""#,##0.00;[Red]\-""#,##0.0050_-""* #,##0_-;\-""* #,##0_-;_-""* "-"_-;_-@_-,'_-* #,##0_-;\-* #,##0_-;_-* "-"_-;_-@_-=8_-""* #,##0.00_-;\-""* #,##0.00_-;_-""* "-"??_-;_-@_-4/_-* #,##0.00_-;\-* #,##0.00_-;_-* "-"??_-;_-@_-
0.0000.0
""#,##0 @* D* l!@ + @
D+ D* D*
l!@ ) D* l!@ + D+ D D+ D/ L/ D+ L+ @/
`@ @ * `@ @ + `@ @ / Q
@) L) H) L
L $ ` l l` + l@+ ` How To!&Torque & Shaft Horsepower,Power Requiredq3
Prop Pitch67
3 Bladed prop;2 & 4 Bladed propsG?Bollard thrust & Notes"SQEngine HorsepowerEngine Torque ft/lbPEnter your data in the green boxes and the answer will appear in the yellow box.)SHP - Shaft Horsepower at gearbox output.>Enter number of bearings between gearbox output and propeller.,Percentage power loss due to shaft bearings. Shaft Horsepower at propeller.&Enter Gearbox reduction ratio. Eg. 1.5
Propeller RPMPropeller Torque ft/lbEngine R.P.M. (max) NB Max engine RPM should not be more than 85% of manufacturers stated max RPM unless a continuous-duty heavy marine diesel is used!@This will calculate the Displacement Speed Formula for the hull.#Waterline Length of vessel in feet. Required maximum speed in knots.lNB This excludes power required by ancilliaries driven by the engine, such as hydraulic pumps or generators.Knots)Maximum Displacement of vessel in pounds._Speed:Length Ratio up to 1.6=displacement, from 1.6 to 2.8=semi-displacement, over 2.8=planing.BSuggested max practical displacement hull speed for LWL input --->Speed:Length Ratio.OApprox maximum speed attainable with motor data from "Torque & Shaft HP" sheet.4Shaft HP required for speed required at top of page.Enter "C" for your hull.IFor planing hulls, where C= 150 for runabout, 190 for fast, 210 for race.,Speed in knots required from Power Reqd page)Max prop shaft rpm from Torque & SHP page1Indicates a result generated by this spreadsheet.*Indicates data carried from another sheet.@This was created by Surfbaud, and we fully retain the copyright.QYou may distribute this with a commercial product, but you may not charge for it.9This spreadsheet may not be altered by any third parties.GIf you wish additional functionality just ask us and we will see to it.http://www.surfbaud.co.uk/wave/Website and download.Contact.jb@surfbaud.co.uk@Welcome to the Surfbaud Freeware Propeller Calculator for Excel.KEY>This spreadsheet is freeware. No charge may made for using it.80% of max prop shaft rpm+desired speed expressed as feet per minute.*Theoretical required prop pitch in inches.All units used are imperial.*Estimated prop slip at required top speed."Required prop pitch for top speed.WThis is an automatic calculation from shaft horsepower and rpm at prop on Torque sheet.Propeller Diameter in inches.Propeller Pitch in inches.Rules of thumb.)One inch diameter = 2.5 inches of pitch. 2Two inches extra pitch will cut engine rpm by 450.]If you can't fit the indicated diameter due to clearance, or have plenty room left, the rules'of thumb above will be a useful guide. &The alternatives in light blue squaresFour blade propeller.Two blade propeller.diameter in inches.pitch in inches.7Only minor variations on this figure for 2 or 4 blades.Ymany variables, such as water salinity or temperature, all of which affect the equations.propellers are swapped.pIt will even be found that two identical vessels will perform slightly differently if their apparently identicaljEven an apparently precise specification will leave room for significant variations from one manufacturer Mto the next. So there is no such animal as a pair of perfectly matched props& cThe purpose of this spreadsheet is to take the guesswork out and produce a spec that is as close asAIndicates data requiring input by you. Demo data already entered.'INB Each extra gearbox or vee-drive will reduce power by an additional 3%.:Pounds per Shaft Horsepower available (power/weight ratio)%%Pounds per shaft horsepower required.&Shaft Horsepower required at propellerIdesired speed divided by max prop shaft rpm to give prop feet per minute.W0.33 mean-width ratio blades. (This means 33% of the "disc" area of prop dia is blades)aIf you find yourself way off, you have either entered bad data or have a badly configured vessel!kIt should be noted that it is physically impossible to do an exact calculation, simply because there are so2is practical to the approximate theoretical ideal.YHave fun calculating the numbers for installation of your engine in a 10,000 ton coaster!NShaft Horsepower available at propeller from "Torque & Shaft Horsepower" sheetFor three bladed propellor.9This will calculate engine torque from input BHP and RPM., Maximum Static or Bollard thrust in pounds.Z5p8U u
E
R cc
!%
dMbP?_*+%"??Uh
0%
=&1
B3
2
=4444 44444
=
444444444
='4444
44444
=4444
= 4444444444
=#444
44
5$
44445444
="444
44
5!
446
7+,|
& (*(*>@
7tyKyK@http://www.surfbaud.co.uk/wave/fyKyK2mailto:jb@surfbaud.co.uk
(,,
dMbP?_*+%MPEPSON Stylus COLOR 600Pz 4dhh0B EPSON Stylus COLOR 600LPT1:" d??U
O
~
2@
~
@@
&M7@H9DD
%)(\u1@D
ףp=
?
~
?
~
@
%Q?Q?D
~
2@
!@DD
&{GM@DD
C$-,877
38 C>@7
.2
dMbP?_*+%MPEPSON Stylus COLOR 600Pz 4dhh0B EPSON Stylus COLOR 600LPT1:" d??U}m
A
&~
!@
~
5@
~
$@
%%+F!E3U@ DD
>E
D>
BC
.(.(~
a@
$,1?@9DDA
/Sr
^2@DDAQD
(T7I/3C3"6 >@7
-46
dMbP?_*+%"??U}I
/@Z
*@Z
%)@D?
(%)fffff@D33333SY@
)!'p=
c?
DD
G
'zG@ D
*2Z4"?ffffff?D=
ףp=?AQ
,&7W$!@,9D
D
-8t/97731D8 - 9>@ 7
7:
dMbP?_*+%" ??U
".J-ܗ2*@4Ń@Z?AQZ333333?AQ
/:ܗ2(@ D+7W$!@Z
0%:7W$&@9D@?
H
1
2
3
4
5
;6999
"I \#/)
$ I 9 >@
7
$=>
dMbP?_*+%MPEPSON Stylus COLOR 600Pz 4dhh0B EPSON Stylus COLOR 600LPT1:" d??U
8'<څ[P,@ Z?
9'<V9P!@
Z)\(?
:
7' <wEzY)@ZGz?
9'
<A @9Z\(\?
:x9999$ 9
\>@
7
@RB
dMbP?_*+%"
??U
NA<1d}@9+\(\O@ZZq=
ףp?AQ
P
;
J
<
>
=
?
@
A
K
@L"7S
L>@
7
Oh+'0 PX
Freeware Propeller CalculatorMarine EngineeringJ BuntuserMicrosoft Excel@Lxֽ@KJ՜.+,D՜.+,P PXlt|
+SurfbaudHow ToTorque & Shaft HorsepowerPower RequiredProp Pitch3 Bladed prop2 & 4 Bladed propsBollard thrust & NotesWorksheets( 8@_PID_HLINKSA
xmailto:jb@surfbaud.co.uka" http://www.surfbaud.co.uk/wave/
!#$%&'()+,-./01Root Entry F ̗lWorkbookBSummaryInformation("DocumentSummaryInformation8*