ࡱ>   !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~Root EntryF@ 9XBook CompObjjSummaryInformation(; FMicrosoft Excel 5.0 WorksheetBiff5Excel.Sheet.59q_Oh+'Oh+'0;H:::::;;Gp: ] "   6'  ' 6-  "-&    !       /           *  /  -   "    $ '  H  @ ! ( #         / # #    ! $ %   ) %     "  # % ! * *  !   # !  '       #    $ ' H ' KCVCO2PF l  $_?IFfq}  dMbP?_*+%&Q?'?(p= ף?)ffffff?MHP LaserJet 5P/5MP (HP)&X&6 l \ MCB B=X/8X=xx$g9X@"1tCourier1t MS Sans Serif1t MS Sans Serif1t MS Sans Serif1t MS Sans Serif1tArial1 tArial1 tArial1tArial1tArial1 tArial1$tArial1$tArial1tArial1 tArial1&tArial1 tArial1tArial1 tArial1 tArial1tArial1tArial1tArial1 tArial1tArial1tArial1tArial1tArial1tArial1tCourier1 tCourier1 tArial1 tArial1tArial1tArial1 tArial1 tCourier1tArial1tArial1 tArial1 t MS Sans Serif1tArial"$"#,##0_);\("$"#,##0\)"$"#,##0_);[Red]\("$"#,##0\) "$"#,##0.00_);\("$"#,##0.00\)%""$"#,##0.00_);[Red]\("$"#,##0.00\)5*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_),))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)=,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)4+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_) 0.00000.000.000.000.0 0.00000                   !   ' "    '!  ! # ! "       !   !       !  !  ! !   H ! # !  ! ! ! !      ! ! !   .   .  . # #     .  . #. # #   # * " /   ! # ! #  H  ! ! %    /  /       #     !   ! !.    .          !  # * " /  /     ә@X"d??U} }  } }  }  } } `} } } }  } } } } } } } }  } } !!} ""} ##} $$} %  %#####?" ##gK##  #  #y @ # # ##D#!#<0@#e0#Xc#(0@###y*#gK# #'#####gK( ###WDRAG PREDICTION PROGRAM FOR NARROW HULLS (as short as 8' long--23 to 100 lb. wt.range -- and up to 30' long -- for 1200 to 5200 lb. wt.range)(in Cv*1000 range .7 to 3.0, best for Cv*1000=1 to 2, see G2 or J19)(for 300 lb displacement 11.5 to 19' EWL)*W$Copyright 1999 by Matt BrozeXCv*1000=Y4?DQZI<<< (G2)should be between .7 & 3.0 or results are more suspect than usual[[[\ZZZ#Insert boat name & data on line 9. Results display on line 15 for glass & wood--line 17 for soft poly or fabric boats. (Cp range:.48 to .64, if Cp is larger results for .64 will display, if less than .48--#N/A displays--use .48)(See S10--How to measure) *#]If meas. unknown, enter known data on line 9, then enter the calc. values from line 10 (or P11, Q11, or R12) or--next best--values from line 11 (programs estimate based on other data from line 9) onto line 9 or make your own best estimate*]TIn Q9 estimate midship flare (little to none=0, moderate=1, extreme=2), In V9 & W9 estimate the fineness of the bow &stern ( from -2=very fine, 0=avg. to +2=v. blunt)&^ Little or Est. or measbow (U9), stern (V9) WLLWL=Waterline length (ft), BWL=WL beam (ft), H=draft (ft), W.S.=Wetted surface (sq.ft), Cp=Prismatic coef., Disp.=Displacement (lb.), le=Bow half-angle (degrees), lx=Stern half-angle (not important at this time)&[^ No flare=0 overhang @ finer = -1, -2bfill in as many yellow shaded items as you can and calculations will be made on line 10 (& R12) or suggestions will be made on line 11 for the unknown dimensions, transfer them to line 9 and use the results to transfer more calculated or estimated dataLCB=Longitudinal center of buoyancy, At/Ax=Area of immersed transom divided by area of immersed midship, LOA & BOA=Overall Length & Beam, Cx=midship coef., Cb=block coef.&_`^Flare=1 bow (R9) & average = 0 BOAT NAME PLWL EWL PBWL PH  W.S. PCpP Disp.lb.  le  Ix  PLCB  At/Ax  PLOA  PBOAPAt--ft^2 PCx PCba V.flare=2stern (S9)(in inches)blunter = 1, 2Mariner XL EWL 4@@|?5^?0*?E6@_L?*s@@"@K@@  S?T@D@@$#@$@$$?) c!Calculated if related dims. known4 *0@D@DDDDO G?use LWL or estimate it based on LWL, Cp, & le (or fineness of the bow)4 02? D@DDDD4 :>? D@DDDDk 6@&UQ?S?DD?DD@D4 Ti? D@DDDD2 ⟟WH s@ @DDDDD ?use 10 unnecessary d?use .5* DDDD measure measure measure4 d ? D@DDDD/ bv>5'? D  k? D  >C.2? D  k3? D  k0aw? D  k\@ D  >@ D  kU@ D  >MF1 @ D  >*U)g;&@ D  >9^+@ D  >ޅn.@ D  Cx=Cb/Cp (=P11)--or measure it (see directions @ S10)--or estimate it--it ranges from 0 to 1, (flat-V=.5, semi-circle=.785 & rectangular=1), "" Rf (frictional resistance) Epm"? D! /i<'? D! >J;? D! / ѽ? D! >p@ D! /uj @ D! /Û@ D! /ya @ D! >DUre@ D!  /S?@ D!  >7uq@ D!  > 5!@ D!  > $@ D!  >L$}V&@ D!  jCalculate EWL by plotting the curve of areas and adding the bow WL curve to it. A line from the peak of the curve tangent to the "belly" in the bow curve crosses the baseline. Remove the distance between the bow WL & this intersection from LWL.& "5Rt (total resistance)?见? D"lqwkZz? D"?o!N?$D"lm8J%?D"?+Y@D"lNش @D"l!wI@D"l̮$<@D" ?!/%@D"  l4׋.*@ D"  ?货 /@ D"  ?+43@ D"  ?j?7@ D" ?O:@ D".mmm"mmnnnnnnnnnnnnnn"$;Rfp (friction w/poly factor)@ 7?D$,YL?D$? i\?D$, 8,?D$?@b@D$,5oP] @D$,+7Z@D$,`S@D$ ?5ͱ@D$  ,B@ D$  ?@] @ D$  ??ű(c"@ D$  ?;$@ D$ ?FHά'@ D$MoE(.99525 factor removed from this poly friction formula intentionally) o`ZValues for EWL, BWL, W.S, Cp., Disp.lb., le, LCB, & At/Ax are required. Those before "le" have the most effect, if no clue: for "le" use 10, for LCB .5, for At/Ax use 0. Other values on line 9 only help calculate or estimate needed ones (see line 11). &````````````````"(< Rtp (total for plastic & fabric)?K0|q?D%:*?D%?_9p?D%:!0{@$D%@ē@$D%:U:Ԗ @$D%:f@$D%:j5#,L@$D% @&@$D%  :fu'*@$ D%  @ƫ-H0@$ D%  @GO4@$ D%  @{d8@$ D% @gb6;@$ D%oF10 is WS formula used in Gerritsma's SNAME paper of 1/28/93, F10 is WS formula I try to match Nautilus numbers with, neither appears better than the other but both average the same over 90 kayaks as Nautilus,```````````````````"`B?F?C@D@C@D @C@C@C@D@C@D@D@D@D @Speed in Knots,p"nI^DMariner XL EWL J=,,,,,,,,,````````````````````````" qC4rƑ?]DCrƑ?VDCrM#?RDCrHu?DCrYwK8?DCr-WN?DCr:?DCrL+J?DC r? DC  r`7z3? DC  rG? DC  rG? DC  rG?] DC rG?]DC."HDispl. in long tons =HI__? DsEff.Cp=0Jrl?V DDDDDEff.Cv =D/L^3 =(1S? D@D)La?e!DMbP?$ K7̐`?DMbP? t <{ R^!fP>:7O5 #!#"#!##$#?" %#'&#gK''#(# )# *#y @+#,#-##D.#!/#<0@0#e01#Xc2#(0@3##4#y*5#gK6# 7#'8#9#:#;#<#gK( =#>#?# jRr (residual resistance) rʧ՗?    DLLDLLLLLL@ffffff? L@? B$$ 8L@? L@ B$$ "B rCD;?  r>5'?  r?  rC.2?  r3?  r0aw?  r\@  r@  rU@   rMF1 @   r*U)g;&@   r9^+@   rޅn.@DDDDDDDDDD@ffffff? D@? B$$ 8D@? D@ B$$ "Bu pmNotice the if arguement, this is to bend the curve back at S/L^.5 above 1.4 to follow Gertler's curves better, p""!Rf (frictional resistance)!pm"?"!&!! +?LDL!i<'?"!!J;?"!! ѽ?"!!p@"!!uj @"!!Û@"!!ya @"!! DUre@" !! S?@" !! 7uq@" !!  5!@" !!  $@" !!L$}V&@"!!pI suspect friction drops as the wetted area drops as the s/l ratio goes beyond 2.0, but nothing here reflects that since wetted surface is fixed.,!p""5Rt (total resistance)"}见?""" LL"}qwkZz?""}o!N?""" LL"}m8J%?""}+Y@""}Nش @""}!wI@""}̮$<@"" }!/%@ "" }4׋.*@ "" }货 /@ "" }+43@ "" }j?7@ ""}O:@"."nnnnnnnnnnnnnnnnnnnn"$#Cfp (poly coef. of friction)#եin?$#%##333333?LBm# W+`l?$#6# M%Rpl? 333333?DBmD#z;Èk?#*## 333333?LBmD#<ªj?##1j?##yTi?##Mպ[9i?## iÉh?## q#ҽxh? ## *Z&h? ## Xmg? ## Wg? ##؈rZg? #!#p.0001 added above 2 knots,#p"$$Rfp (friction w/poly factor)$ 7?%$$$LDL$YL?%$$ i\?%$$$ LDL$ 8,?%$$@b@%$$5oP] @%$$+7Z@%$$`S@%$$ 5ͱ@% $$ B@% $$ @] @% $$ ?ű(c"@% $$ ;$@% $$FHά'@%$M$pE(.99525 factor removed from this poly friction formula intentionally),$p"(%< Rtp (total for plastic & fabric)%9K0|q?%%% LL%9*?%%9_9p?%%% LL%9!0{@%%9ē@%%9U:Ԗ @%%9f@%%9j5#,L@%% 9&@ %% 9fu'*@ %% 9ƫ-H0@ %% 9GO4@ %% 9{d8@ %%9gb6;@%.%~~~~~~~~~~~~~~~~~~~~"&N^DMariner XL EWL J&((((((([&~~~~~~~~~~~~~~~~~~~~~~~~"R'JTable 3 (Table 2 interpolated for actual speed/length ratios of the hull)*'1')Table 1A (for 1.0x10^-3 Cv @ B/H=3.75)$'"(fR?D(Q,?D(fR?D(3%?D(Q,?D(2P 4?D(fR?D(в|={!?D(3%? D( SL(? D ( Q,? D ( %\0? D ( 2P 4? D ( Zzf7?D (fR@+D((Speed/Length Ratio (0.4 (0.5 (0.6 (0.7 (0.8 (0.9 (1 (1.1 (1.2 (1.3(a@?d@@e@!("#)Proper column/Less than----)S/L<.4)S/L<.5)S/L<.6)S/L<.7)S/L<.8)S/L<.9)S/L<1.0)S/L<1.1) S/L<1.2) S/L<1.3) S/L<1.4) S/L<1.5) S/L<1.6)S/L<1.7) ).48Z)????@Y@@Z@@Z@@\@@d@ d@`c@@c@c@c@!)"%*but equal to or more than----`*>@D@?N@Q@T@V@?[@^@@`@a@?d@@e@*~ *f@* *).49Z**Z@*Z@*Z@*@Z@*?*Y@*Y@*\@*c@*b@*b@*`b@* b@* b@!*"+3Speed/Length^.5 ratios+4Q,?,+++L-Be+4Q,?,++4fR?,++43%?,++4Q,?,++42P 4?,++42P 4?,++4fR?,++ 4в|={!?, ++ 43%?, ++ 4SL(?, ++ 4SL(?, ++ 4Q,?, ++4%\0?,+*+42P 4?,D*%((Be +4 +.50Z+[@[@[@[@Z@Z@Y@\@ b@a@a@a@a@a@!+"&,6Cp (down)-interp. factor>>>>>>,j5?A,,,LL ,d X)̿.,,̙?.,,X ?.,,3k?.,,!g?.,,Hxcǿ.,,̙?.,, p{A;?. ,, X ?. ,, xY4o2?. ,, %.C6ÿ. ,,  ?=?. ,,5{?.,,CΤ?,,,pinterpolation factor, ,.51Z,\@\@\@]@Z@Y@Z@Z@a@`@a@a@`@`@!,"~ -7H@-A?ND--?h- -6L7L7L,@L7-?h--?h--p?h--n?h--qF(?h--`5(W?h-- n?h-- zlJ@?h-- ʏx|?h-- 4_?h-- @.s:?h--M}"?h!-- -.52Z-@]@@]@@]@\@@Z@??Z@?`@`@@`@ `@ `@!-"~ .8H@.A ny?@D.. ny?d-. ny?d-. :?d-.>.V?d-.$ S;?d-.1,?d-.3gyyr?d-. l*e?d-. @Iy?d-. &~r?d-. [o?d-. OID"?d-.C"?d!-. ..53Z.????@Z@@Y@@Y@Z@^@^@_@_@^@^@!."~ /8?/A ?0D// ?i-/ ?i-/\re?i-/O;?i-/Pzm?i-/YD?i-/BY6?i-/ p]њ?i-/ yQ?i-/ *~tv?i-/ =w ?i-/ V.?i-/s ?i!-/ /.54Z/^@^@^@^@?Y@Y@@Y@]@]@]@]@]@]@!/"~ 07I@0A{xP]?.D00{xP]?s-0{xP]?s-0_?s-08 +?s-0 r?s-064>?s-0X?s-0 ls@}?s-0 .?s-0 U?s-0 )zY?s-0 p[?s-0B&?s!-0 0.55Z0_@_@_@?@Y@Y@Y@??@[@@\@@\@@\@@\@!0"~ 17J@1A?/D11?g-1?g-1 8Ҏ?g-1/m?g-1fsW!?g-1?g-1z?( ?g-1 甍?g-1 QF%?g-1 Dh?g-1 ?g-1 y3?g-1`aDV?g!-1 1.56Z1`@`@`@``@@Z@Y@[@Y@[@Z@@[@@[@@[@@[@!1"~ 27J@2ATIg?@D22TIg?o-2TIg?o-2 c/?o-2'W0?o-2d6H?o-2(/?o-2AD?o-2 lE?o-2 p:0?o-2 zRݍ?o-2 ~$ّ?o-2 /b?o-2Uth?o!-2 2.57Z2`@`@`@`@@Z@[@\@Z@[@Z@Z@Z@Z@Z@!2"~ 37K@3AGz?9D33Gz?m-3Gz?m-3 ?m-3X?m-3HW?m-3g?t7: V?t7: <^u6?t7: ;z&?t7: y?t7:1;r?t!7:1:)Table 1B (for 1.5x10^-3 Cv @ B/H=3.75)$:"~ ;7O@;A6gm?2D;;6gm?>7;6gm?>7;ȋ `?>7;k]rE?>7;a|5?>7;VO?>7; E?>7; D,c?> 7; A^ȜB?> 7; ?> 7; ?> 7; 0DM?> 7;1;r?>7;; Speed/Length ;0.4~ ;? ;0.6 ;0.7 ;0.8 ;0.9 ;1 ;1.1 ;1.2 ;1.3;a@?d@@e@!;"p~ <7O@<AD ڢO?3D<<D ڢO?p7<D ڢO?p7<C F*?p7<:[Z?p7<H??p7<H?p7<il?p7< ĭw?p7<  ?p7<  )r?p7< -O?p7< G{,?p7<g(1oEI?p!7< <.48*<?????[@<y 5?0<^@ b@b@a@a@a@a@!<"~ =7P@=A9"?<D==9"??7=9"??7=Yo??7=;;??7= ߕ??7=Ԭa<%??7=BL??7= Ġc?? 7= 2~߉QH?? 7= S?? 7= ?? 7= ?? 7=??7= =+.49=,@Z@,@Z@,@Z@=,ى؉?B=,?,Z@,@Y@,]@,`@,@a@,a@, a@,`@,`@!="*>RQ?@D%-=Bf>{xP]?>>>>D-Bf*>{xP]?>D%-=Bf*>{xP]?D%-=Bf*>_?;D%-=Bf*>8 +?rD%-=Bf*> r?rD%-=Bf*>64>?rD%-=Bf*>X?rD%-= Bf*> ls@}?rD%-= Bf*> .?rD%-= Bf*> U?rD%-= Bf*> )zY?rD%-= Bf*> p[?rD%-=Bf*>B&?rD%-=Bf> >.50Z>@[@@[@@[@[@@Y@Z@Y@[@_@ `@@`@@`@`@`@!>"4?p= ף?rD{Gz?%-=Bf????(??D{Gz?%-=Bf????4??eD{Gz?%-=Bf4? 8Ҏ?eD{Gz?%-=Bf4?/m?eD{Gz?%-=Bf4?fsW!?eD{Gz?%-=Bf4??PD{Gz?%-=Bf4?z?( ?eD{Gz?%-= Bf4? 甍?eD{Gz?%-= Bf4? QF%?eD{Gz?%-= Bf4? Dh?eD{Gz?%-= Bf4? ?eD{Gz?%-= Bf4? y3?eD{Gz?%-=Bf4?`aDV?eD{Gz?%-=Bf? ?.51Z?\@\@\@[@Y@Y@Y@@[@@]@_@_@?_@_@!?"DMl3>&lHHHHHHHH?c??.^^N@#A#B#!C#D#?" E#'F#gK'G#H# I# J#y @K#L#M##DN#!O#<0@P#e0Q#XcR#(0@S##T#y*U#gKV# W#'X#Y#Z#[#\#gK( ]#^#_#@_L?D@Ƒ?_@)@@LLDD>dL@Ƒ?@@Ƒ?@@@M#?B@@Hu?@@@YwK8?B@@8l?@@@-WN?@@@ :?@@@ L+J?@ @@ ?@ @@ gf]=?B@@ `7z3?B@@G?B @@ @.52Z@\@\@\@@\@Y@??@Y@\@]@^@^@^@^@!@"A-Speed/Length RatioA"Q,?CA/AA%L,@ ,+@Q@BA"Q@@AA"fR?BAA"3%?BAA"Q,?@ AA"2P 4?B AA"Q@B AA"fR?@AA "в|={!?A AA "3%?A AA "SL(?A AA "Q@A AA "Q,?AAA"%\0?B AA A.53ZA@^@@^@@^@@]@@Y@Y@Y@@Y@Z@\@]@]@\@\@!A"B1Speed/Length^.5 ratioB2Q,?CD@B2fR?+D@B23%?AD@B2Q,?AD@B22P 4?AD@B2fR?BD@B2в|={!?@ D@B23%?@ D@B 2SL(?AD@ B 2Q,?AD@ B 2%\0?AD@ B 22P 4?AD@ B 2Zzf7?A D@ B2fR@CD@B B.54ZB^@^@^@@]@?@Z@Z@@Y@@Y@[@\@@\@@\@@\@!B"(C autom. transfers to line 20 (C4)CƑ?DB? $@DBDA $@DBDA $@bDBDA $@EDBDA $@(DBDA $@ $C"""""BCƑ?CDB? $@DBDA $@DBDA $@DBDA $@bDBDA $@EDBDA $@(DBDA $@ $C""""""BCM#?CCCCLL ,LL ,LL ,LL ,LL ,bLL ,ELL ,(LL , ,"""""""BCHu?CCCYwK8?CCC-WN?CCC:?CCCL+J?C CC ?C C CC LL ,LL ,LL ,LL ,LL ,bLL ,ELL ,(LL , ,"""""""BC `7z3?C C C G?C C C G?C DB DA $@DB DA $@ DB DA $@ DB DA $@ DB DA $@ bDB DA $@ EDB DA $@(DB DB $A $C """""""BC G? DB DA $@ DB DA $@ DB DA $@ DB DA $@ DB DA $@ bDB DA $@EDB DB $A(DB DB $A $C """""""BCG?DBDA $@ DBDA $@ DBDA $@ DBDA $@ DBDA $@bDBDB $AEDBDB $A(DBDB $A $C """""""BCp In this line the IF formulas differ by background color--don't change them globally across the line--by splitting them I widened the range of lengths covered C` C.55ZC???]@?Z@\@??[@[@@[@[@[@!C"DeD In the above line the IF formulas differ by background color--don't change them globally across the line--by splitting them I widened the range of lengths covered(D D.56ZD `@ `@ `@@^@@Y@Z@@^@Z@?Z@Z@Z@Z@Z@!D"ETable 4*E E.57ZE@`@@`@@`@_@Y@@\@ `@[@@Y@@Z@Z@Z@Z@Z@!E"FTransom Sterns*F`` F.58ZF `@ `@ `@_@Y@\@`@^@Y@Y@Z@Z@@Z@@Z@!F"GSpeed/Length^.5 ratio~ G>@ G0.4 G0.5 G0.6 G0.7 G0.8 G0.9 G1 G 1.1 G 1.2 G 1.3G a@?d@G G.59ZG`@`@`@_@Y@@]@?``@Z@?Y@Z@Z@Z@!G"H0% of midship section`H??????????????@e@ H H.60ZH@a@@a@@a@``@@Z@_@c@`a@Z@Y@Y@Y@Y@Y@!H"I1% of midship sectionI|A?I|A?Ih)M7B?IʡE?~ IpY@I QI?IH?IʡE?I sh|??I ߾3?~ I ?I a4?I W@@W@? I`I.N@@a@@a@@a@`@@[@`@e@c@\@Y@Y@Y@Y@Y@!I"J2% of midship sectionJbX9H?JbX9H?J}?5^I?JK?JM?JM?JM?JM?J }?5^I?~ J `Y@J ho?J ;M O?J W@@W@@W@ J`J.O@a@a@a@`@@Z@@`@`g@d@\@@Y@@Y@@Y@Y@Y@!J"K3% of midship sectionKY@Y@K r?KX9v?KY@Y@Y@Y@K ;On?K |?5^?~ K 0Y@K ٬\m?K  X@W@@W@ K`K.O@b@b@b@a@@\@`a@i@e@^@Y@?@Y@@Y@@Y@!K"L4% of midship sectionLܺ?Lܺ?LW?LX9v?LC?Ln?L#~j?LNbX9?L S㥛?L "~?L T㥛 ?L X@@X@X@W@ L`L.P@ b@ b@ b@a@]@a@ k@g@ `@Z@????!L"$M~ MX@ M0M(Table 1C (for 2.0x10^-3 Cv @ B/H=3.75)$M"NSpeed/Length^.5 ratioNQ,?+D@NfR?D@N3%?ND@NQ,?ND@N2P 4?ND@NfR?ND@Nв|={!?ND@N3%?ND@N SL(?ND@ N Q,?N D@ N %\0?N D@ N 2P 4?N D@ N Zzf7?N D@ NfR@N D@NN Speed/Length N0.4~ N? N0.6 N0.7 N0.8 N0.9 N1 N1.1 N1.2 N1.3Na@?d@@e@!N"OOS/L<.4OS/L<.5OS/L<.6OS/L<.7OS/L<.8OS/L<.9OS/L<1.0OS/L<1.1O S/L<1.2O S/L<1.3O S/L<1.4O S/L<1.5O S/L<1.6OS/L<1.7O O.48ZO????@Y@[@Z@_@a@b@@a@`a@a@a@!O"*P"Table 4 (Transon stern multiplier)*P P+.49PZ@Z@Z@@Y@P?ePkPPaD  LLL<D  , LLDL"B<P@Z@Y@^@``@`@`@`@``@``@!P"QZQ>@D@?N@Q@T@V@?[@^@@`@a@?d@Q Q.50ZQ@[@@[@@[@Z@Y@@Z@Y@@\@^@``@ `@`@ `@ `@!Q"R-Speed/Length RatioR"Q,?SD+R"Q,?SD+R"fR?SD+R"3%?SD+R"Q,?SD+R"2P 4?SD+R"2P 4?SD+R"fR?SD+R "в|={!?S D+ R "3%?S D+ R "SL(?S D+ R "SL(?S D+ R "Q,?S D+ R"%\0?SD+R R.51ZR\@\@\@Z@Y@Y@?[@]@?^@^@^@^@!R"STransom ExtrapolationSj5?USSSLL Sd X)̿USS̙?USSX ?USS3k?USS!g?USSHxcǿUSS̙?USS p{A;?U SS X ?U SS xY4o2?U SS %.C6ÿU SS  ?=?U SS5{?USS S.52ZS]@]@]@@[@@Y@?Y@?[@]@^@]@]@]@!S"~ TOT?YTTU LLLLT?WTT?WTT?WTT?WTT?WTT?WTT?WTT ?W TT ?W TT ?W TT ?W TT ?W TT?VTTXLLLLT T.53ZT^@^@^@[@?@Y@Z@@Y@Z@\@\@\@\@\@!T"~ UO?U|A?ZTU‚sA?XTU9Ƥ8B?XTU3C7E?XTUڽF?XTUEpQJ?XTUm{G?XTUw@F?XTU W%)mC?X TU "]R?X TU 8>UV?X TU }t?X TU dAx?X TU(\?TTU U.54ZU^@^@^@[@?Z@\@Y@@Z@\@\@\@\@\@!U"~ VO@VbX9H?XVVXLLLLV\H?ZVVV  LLLLVRI?V VV]f+K?VVVM?VVVM?VVVM?VVVI!N?VVV rM?VVV  _?V VV {S?VVV ?",?V VV dAx?V VV(\?XTV V.55ZV^@^@^@\@?Z@^@Z@?[@[@@[@[@[@!V"~ WO@Wq= ףp?VWghq?YWWW  LLLLWr?YWWR&u?YWW{Gz?YWW{Gz?YWW{Gz?YWW{?YWW yDt?Y WW e޷?Y WW T1$w?Y WW CnVX?Y WW (-?Y WWffffff?YTW W.56ZW `@ `@ `@\@?[@`@@[@@Y@@Z@Z@Z@[@[@!W"~ XO@Xܺ?WVXj1!?ZXXX  LLLLXl?ZXXB?ZXXL&?ZXXP+?ZXXԉ?ZXX:5z?ZXX `(?Z XX u袶?Z XX 5- "h?Z XX je%?Z XX +?Z XXQ?ZTX X.57ZX@`@@`@@`@]@Y@\@a@]@@Y@Y@Z@Z@[@[@!X"*Y[D %TXBf*Y?[D %TXBf*Y?[D %TXBf*Y?[D %TXBf*Y?[D %TXBf*Y?[D %TXBf*Y?[D %TXBf*Y?[D %TXBf*Y?[D %TX Bf*Y ?[ D %TX Bf*Y ?[ D %TX Bf*Y ?[ D %TX Bf*Y ?[ D %TX Bf*Y ?[ D %TXBf*Y?YD %TXBfY Y.58ZY_@_@_@]@?]@b@ `@?@Y@Z@@Z@Z@Z@!Y"4Z{Gz?[D {Gz?%TXBf4Z|A?TD {Gz?%TXBf4Z‚sA?TD {Gz?%TXBf4Z9Ƥ8B?TD {Gz?%TXBf4Z3C7E?TD {Gz?%TXBf4ZڽF?TD {Gz?%TXBf4ZEpQJ?TD {Gz?%TXBf4Zm{G?TD {Gz?%TXBf4Zw@F?TD {Gz?%TX Bf4Z W%)mC?T D {Gz?%TX Bf4Z "]R?T D {Gz?%TX Bf4Z 8>UV?T D {Gz?%TX Bf4Z }t?T D {Gz?%TX Bf4Z dAx?T D {Gz?%TXBf4Z(\?WD {Gz?%TXBfZ Z.59ZZa@a@a@^@Y@@^@d@a@Z@?Y@Z@Z@Z@!Z"[G:D [?\[)[[LLD DYdL[?[[?R[[?][[?R[[?][[?R[[?R[[ ?R[[ ?R [[ ?R [[ ?][[ ?][[?] [[ [.60Z[ a@ a@ a@_@@Z@ `@`f@c@[@Y@Y@Y@Y@Y@!["\-Speed/Length Ratio\"Q,?^\/\\%L,@ ,+@Q@B\"Q@R\\"fR?]\\"3%?]\\"Q,?R \\"2P 4?] \\"Q@] \\"fR?R\\ "в|={!?\ \\ "3%?\ \\ "SL(?\ \\ "Q@\ \\ "Q,?\\\"%\0?] \\`\.N@a@a@a@`@@[@`@h@d@\@@Y@?Y@Y@Y@!\"]MSpeed/Length^.5 ratio]NQ,?^D@]NfR?RD@]N3%?\D@]NQ,?\D@]N2P 4?\D@]NfR?]D@]Nв|={!?R D@]N3%?R D@] NSL(?\D@ ] NQ,?\D@ ] N%\0?\D@ ] N2P 4?\D@ ] NZzf7?\ D@ ]NfR@^D@]`].O@@a@@a@@a@?Z@@a@j@d@^@@Y@?@Y@@Y@@Y@!]"(^] autom. transfers to line 26 (C6)^?D]? $[D]D\ $[D]D\ $[bD]D\ $[ED]D\ $[(D]D\ $[ $^"""""B^?^D]? $[D]D\ $[D]D\ $[D]D\ $[bD]D\ $[ED]D\ $[(D]D\ $[ $^""""""B^?^^^^LL ,LL ,LL ,LL ,LL ,bLL ,ELL ,(LL , ,"""""""B^?^^^?^^^?^^^?^^^?^ ^^ ?^ ^ ^^ LL ,LL ,LL ,LL ,LL ,bLL ,ELL ,(LL , ,"""""""B^ ?^ ^ ^ ?^ ^ ^ ?^ D] D\ $[D] D\ $[ D] D\ $[ D] D\ $[ D] D\ $[ bD] D\ $[ ED] D\ $[(D] D] $\ $^ """""""B^ ? D] D\ $[ D] D\ $[ D] D\ $[ D] D\ $[ D] D\ $[ bD] D\ $[ED] D] $\(D] D] $\ $^ """""""B^?D]D\ $[ D]D\ $[ D]D\ $[ D]D\ $[ D]D\ $[bD]D] $\ED]D] $\(D]D] $\ $^ """""""B^`^.O@b@b@b@`@\@@b@@m@g@?Y@??@Y@@Y@!^"__ In the above line the IF formulas differ by background color--don't change them globally across the line--by splitting them I widened the range of lengths covered(_H_.P@`b@`b@`b@`@@]@b@n@j@`@Z@w_?r!aD  DLD9D9<D  $9 DLD9DD9"B_???!_"DQOlN9 ]h [eKxIll;E`#a#b#!c#d#?" e#'f#gK'g#h# i# j#y @k#l#m##Dn#!o#<0@p#e0q#Xcr#(0@s##t#y*u#gKv# w#'x#y#z#{#|#gK( }# ~##`To add to the measurement & results archive (below) copy & paste line 9 and then copy line 15 (17 for plastic or fabric) click on the first cell of the line & from EDIT menu click "paste special" & "paste values" then "paste special" & "paste formatting" J`[[[[[[[[[[[[[[["a BOAT NAME aPLWL aEWL aBWL aPH  aW.S. aPCpaP Disp.lb.  ale a Ix a PLCB a At/Ax a PLOA a PBOAaPAt--ft^2 aPCx aPCbaa V.Flare=2aastern (S9)(in inches)aablunter = 1, 2 a"bfSpeed in KnotsZbg?h@i@h@i @h@h@h@i@h@i@i@i@i @bQbITable 2 (Tables 1A, 1B, & 1C interpolated for the actual Cv of the hull)$b"cAquaterra Chinook EWLc@-@c<,Ԛ@c_LJ?crh|6@BcH@ps@@.@J@\@i@@R@c~ ccc Speed/Length c0.4~ c? c0.6 c0.7 c0.8 c0.9 c1 c1.1 c1.2 c1.3ca@?d@@e@!c"d<Rtp (total for plastic)d?ǜt>?d:b_%?d?>xp?d:t5ø@d@?6@d:@d:R5@d:2?!@d @YK(@d :й*.@d @Zm2@d @o7@d @Ѿ2X:@d@'@=@d[[[ d.48d?-D  D ? B$D<D)DD)gD ? D  B$DOD<DD<'D  $O $)""Bd?-dds!РD  D ? B$LLDLgD ? D  B$LLDL'D  , ,""Bd?-dd?-dd>̡O ?-dd|?-dd 6At?-ddzQ?- ddP}X?- dd'gb/?- dd}]\?- ddAD?- dd M}"?-dd!M}"?d dd"eNimbus Puffin EWLe/@@eho?eׁ?eʡ6@e(~k ?*et@`@@I@\@ e Aǘ?e?e~ e?e e+.49e ny?+eet!D  D ? B$LLDLgD ? D  B$LLDL'D  , ,""Be ny?+de ny?+deH?+de?+de'Tdy?+deg(1oEI?+de'/X?+ de|7?+ de9 ?+ deT` f?+ deVL ݡ.?+ de C"?de!C"?e de"f<Rtp (total for plastic)f?H qE4?f:!6?f? (C?f:Un|H@f@I벚j@f:C2o@f:^s@f:8!@f @ !VV%@f :@x+@f @T0@f @Cr4@f @Y 8@f@x?j;@f f.50f ?/ef ?/df ?/dfymM?/dft?/dfz6#?/df1;r?/df|Zb~#?/ dfߎ?/ df!'?/ df7?/ dfu790?/ df s ?/df!s ?f df"gHydra Sea Runner EWL Ng/@.@g@D@,@H@s@(@$@I@1@ g Fx?g@T@g~ gg g.51g{xP]?0eg{xP]?0dg{xP]?0dgQd?0dg5yM?0dg=H Z?0dgGy?0dg}0?0 dgPG;?0 dgjdv:?0 dg6UZ?0 dgjlc?0 dg B&?0dg!B&?g dg"h<Rtp (total for plastic)h?W-?h:r m'?h?-,ou?h:zF؞ @h@y @h:6a0@h:WcL@h:0Q!@h @孧Z'@h :_(.@h @ YlT2@h @n6@h @\:@h@j=@h h.52h?1eh?1dh?1dhF:U?1dh ڲ?1dh?1dh?1dht?1 dh␏?1 dh7T -?1 dhv;?1 dhtM`?1 dh `aDV?1dh!`aDV?h dh"aiYWind Dancer EWL (this program uses actual Cp rather than eff. Cp, but Eff. Cv)iGrW/@~ i@i 0@itV?iS8@$iK@s@@2@I@ i Mb?~ i |@i 0@i rh?~ iS@i~ iiQ i.53iTIg?2eiTIg?2diTIg?2diPϺ?2di!u4?2di|؛1?2di{jA:?2di_Y!?2 di ?2 di,l??2 di~$ّ?2 di~$ّ?2 di Uth?2di!Uth?i di"j5Rt (total resistance)j?Mo?jl?j?CJ?jl|O@j?+)@jlGD@jlFcj@jlg', @j ?\P%@j l^ln++@j ?w[0@j ?Λ>4@j ?Vƨ:7@j?a5DE:@j j.54jGz?3ejGz?3djGz?3dj+O/z?3dj?3djhk?3dj)}?3dj)\(?3 djS ?3 djQd?3 djs?3 djwX?3 dj Jp@ ?3dj!Jp@ ?j dj"kMariner XL EWL k4@@k|?5^?k0*?kE6@k_L?*ks@@"@K@@ k S?kT@k~ k@k k.55k|CY@?4ek|CY@?4dk|CY@?4dk}n|?4dk>̡O ?4dk܃t?4dk# ?4dk?4 dk?4 dkg?4 dk}ޣs:?7dn|?7dnXb?7 dnΖt?7 dn ڲ?7 dn<߶&?7 dnp= ף?7 dn ?7dn!?n dn"OoGNavigator EWL@real trim with Chris's #'s & final EWL & LWL from Winterso9m4-@o:-@oAc]K?o?5^I ?o r5@oJ +?o'1s@osh|?$@o @H@ o V0@o /$?~ oo鷯?o~ o@o o.59oN]?8eoN]?8doN]?8doΖt?8doJ7*?8doɼvԵ?8do* \y?8do. ѥ?8 doKoT?8 dod`?8 do{Gz?8 dof]?8 do p= ף?8do!p= ף?o do"p5Rt (total resistance)p?B9?pl0kh?p?~m?pl[x?p? R@plxmAhZ@pl_?4@plj@p ?*#@p l$)@p ?{ /@p ?3@p ?d3366@p?H‘8@p p.60pF:U?9epF:U?9dpF:U?9dpAV?9dp1һ-?9dp.|ҝs?9dp]|ĭ?9dpC8?9 dp/W_?9 dpRQ?9 dpA?9 dpA?9 dp =H Z?9dp!=H Z?p dp"qShearwater 860qMSt.@~ q@q?q+ݓ?q/$5@qc]F?$qr@@X@I@ q 1*/@q 0*?~ qqܵ|?q~ qq~ q.N@q Γ?:eq Γ?:dq Γ?:dq}ޣsZ@v?3|!@vl ;9d @vl~v-@vl>S @v ?R $@v l5ɑf(@v ?xsٔ.@v ?Pֵ2@v ?\" w6@v?\=#O9@.v"w Hop on Topw h"lx:+@wh*@wz,C@w&S?wI +4@wBfj?w㥛 r@w@@ w ~jt?w 0@ w 6@~ ww?w~ w@x5Rt (total resistance)x?Q A?xlZǀ`?x?BN4m?xlIm#"?x?C<ǎ@xl*Y='@xlզb@xlȍT$@x ?I\|)@x l:A0@x ?.4@x ?(2_}8@x ?oEj2;@x?2>P<@ xy Dawn Trakkery,C%@ysh| @y6@y$(~k?y!rh4@y{/L ?y9vs@yI +,@~ y @y B`"?~ y y JY8V&@y ^I +@~ yy6?z?T]@2?z:X@z@Wn@z:A #@z:F>7"*@z:]iq1@z @@<0{6@z :pk9@z @ :@z @iCBc;@z @4 I@@z@7H@ z{Orca by Pyranha{?U*@{eXW)@{ y?{K46?~ {ğ@{r鷯?{Onr@{Ȓ@ؔ@? { h|?.@{ Pg@{K7A`?{~ {|5Rt (total resistance)|?C|R?|lY,$?|? 9?|l7W?|?`@|l/E@|l{K *@|l`jTL!@| ?tM:(<='@| l{ -@| ?$A2@| ?&|qq5@| ?xc47@|? >EV18@ | }Alvik}tF_/@}d`T-@}㥛 ?}[W[?~ <Rtp (total for plastic)?,*>x?:&Ç?? wk$?:h@@V@:ѽ'u@:о @:!nʩ!@ @g'@ :"=І.,@ @(1@ @"l5@ @xaٻ*8@@G;9@  Eskimo 19N@a1@~jt0@fj+?y):?/$7@n?~ @+ @~ x@ NbX9?~  h|?U2@ ?X?~ 5Rt (total resistance)?<.?luO7??)gs ;?l`W@?#U@lzc@lRZpv3@l b @ ?_c"@ l-'@ ?Lsq-@ ?X1@ ?:s4@?F7@ mmm Falcon 18~ @ʡE/@?m4@?~ K@/L F?sh|r@Zd#@ 0@I@  v1@ Zd;?~ \ Ac?~ ? QQQ5Rt (total resistance)?e=U?l(r??/\?l!tC?? L@l @lfI=`>@lr@ ?/$@ lZa(@ ?:[t-@ ?tk 2@ ?>6@?Rv9@.mmmmmmnnnnnnnnnnnnnn"PursuitZd.@ OE.@A`"?ec]?~ ޠ@[Ӽ?uVPs@v@ <@J@  lq1@ L7A`?~ t?~ ? QQQ5Rt (total resistance)? 3ߤb?l{ԥ"??ҷoO?l"g??@l߹T @lV@l߮@ ?Z7;$@ l4wj*@ ?베 /@ ?u63@ ?D|˃7@?D.M9@.mmmnnnnnnnnnnnnnn"Boreal Beluga (double)HP(3@|?5^2@&†@;On?9v@@yX5;?'1~@@X@H@  n4@ m@Ԛ?~ ?5Rt (total resistance)?2[?l=A??Os\5mX@lfI@?9a( @lk@lV @lp`0h!@ ?p[A'@ lHف<0@ ?ҏ2@ ?hA,6@ ?xii;@?ai9@@ mmmFutura II, Spt.T. 250lb;pΈ^2@~ ^@Gr?x#?B`"{8@ cZB>?ˡEr@X9!@~ (@ K7A?~  !lV2@ _?~ jt?~  QQQ5Rt (total resistance)?AA?ll-??8)Rb?lC@?G# +c@l#R, @ltu;@l0@ ?[!@ l/¯n'@ ?]6f,@ ?xV0@ ?CQ4@?H,d7@.mmmmmmnnnnnnnnnnnnnn"Yukon Eski 250D,@c=y,@3?|?5^?|?54@h|?5?~ @;On#@~ `@ +?~  -g0@ 0*?~ |Pk?ec]?~ @b@@??5Rt (total resistance)?{?lR ??Ⱦ?lDm ??$k@l){X @l.?͗R@l9i̚@ ?jL$@ lt0H*(@ ?%ƃ/@ ?TS3@ ?h2U5@?RYf7@.nnnnnnnnnnnn"Pygmy Coho Expeditionڬ\m0@46\/@|a2U0?{?B`"5@46j;'@ l̲q+@ ?0"1@ ?Y5@ ?D9@?ĎL<@ PWS Intrepidj+ 0@Q2.@ˡE?sA?Mb6@TN?A`r@7A`P@~ @ "~j?~  s1@ g?~ 47?fc]F?~ 㥛 $@؃@5Rt (total resistance)?c .?lJ7??SUJ?l3@?ʻ@l*@ٽ @lZ w@lb&" @ ?i]%@ lb_,@ ?䷯\D1@ ?eqh5@ ?=!9@?R٬?|Pk??5^I,7@??s@NbX94 @ @@I@  -'1@ 0*?~ 2w-!?X2ı.?~ ?+&@<Rtp (total for plastic)?Ĺm?:k:???:R@@АI@:N4@:E&N@:Pą@ @dS%@ :ݍ6d )@ @ 4/@ @˰L3@ @JY}6@@NN9@.[[[[[nnnnnnnnnnnn" Gulfstream~ 7@p_-@h"lxz?+?M"5@Bfj?h|?s@?5^I@~ x@ }?5^I? 0@  |a2U?~ iq?鷯?~ V-0@5Rt (total resistance)?fԳ=?lSn??}`4F?l2s ??m@l_ a @lZmu@lM3@ ?-$@ l/*@ ?or40@ ?_Xo3@ ?%196@?0}SGp-9@[[[[[ Kap Farvel~ ז@W2)@V/?s?^I 3@~ H@mr@@~ x@ sh|?? T@  |a2U?~ I.!?_vO?~ @5Rt (total resistance)?I,>?l (??/(E?l]p??ا@l$} X~@l-@l8[NO#@ ?BC*@ lF /}0@ ?L\i4@ ?qL0k8@ ?h5:@?U];@Endeavorxz,C.@x&1-@ioT?u?~ e@W2ı?ʡE7s@K7A`@~ @ K?~  NbX9t1@ Af?~ ~:?K7A`?~ -'2@?5Rt (total resistance)?ʊ?l<&??AX?lmH]??)@lAN @l,WJ@l&'@ ?\%@ lb Ģ+@ ?0 0@ ?, 54@ ?k 7@?{3:@ Elan ,@~ ƕ@?ܵ?48EG?~ \@s?V-r@H@@  S㥛?~  Cl0@ &䃞ͪ?~ 4@?0*?~ ?P@ s@??5Rt (total resistance)?֧N?l[??9e?lrֈ??V^h=@l톌 @l q@l5*˭@ ?%ĺIC%@ l}LH)@ ?.Sۜ)0@ ?2t3@ ?J?P6@?v8@ Chesapeake 17ɥ/@Dli/@C6?N@?K76@I@Ap@؍@@  8m4?~  -0@ h@ʡE?Aǘ?~ ?X@q@5Rt (total resistance)?K} H*?l߿??dϑ]F?l1n.@?̭@lP& @lg@l"zLN@ ?]UW3&@ lH¼*@ ?GY0@ ?.i4@ ?RtBZ;8@?U\_;K;@Odyssee0' ,@Mb,@jt@>yX5?|?5^z:@vOjM?A`@@@1@   c?~  /@ _L@~ :pΈ?vq -?~ ?^I +(@V-@@@D*l- /!-%O'O-IOdOo7rOXQb7R7j7L7;7!?"  gK! ! y @ <Rtp (total for plastic)?^AzC?:v??Z#6 ?:@@d3Fb @:P;@:p!ݗ@:(xY$@ @=+@ :,}y1@ @Bpe*g5@ @`93:@ @ПF>@@rJ>4@@Passat<@ 4@ +@DJ? rhA@H.!?@h@h@  K?~  v5@ n@~ X5;N?Zd;?~ ?~ ڢ@V-@??5Rt (total resistance)??l@Nautiraid GreenlandV.@~ @猨@ŏ1w-?Zd;9@jMS?~ @s@Dl) @~ $@ mV}b?~  !lV0@ x&@~ C6?sF?~ @?5^I "@@??<Rtp (total for plastic)?o{ƾ"?:`bh +??i?:?:B?>]^@@"K&@:5?B@:t![@:r; @ @PĻ&%@ :*@ @3=b0@ @ EyR'4@ @d7@@.:@#%Symetrical Shell (Bearboat)$9@$9@e@P@@jt?6$D@$z@$z@?$$9@$g@UV r?VH@V$$$$5Rt (total resistance)?Y~s?l&q9@?Y@lHQ@?5Q.!@lwL&@lzT#\+@lB0@ ?ݥ3@ lm};7@ ?8n5;@ ?k-jk?@ ?$NsUAB@?d_UE@ BOAT NAME PLWL EWL PBWL PH  W.S. PCpP Disp.lb.  le Ix PLCB At/Ax LOA PBOAPAt--ft^2 PCx PCb^ Little or Est. or measbow (U9), stern (V9) WL 2 knots3 knots4 knots 4.5 knots5 knots  6 knots ^ No flare=0 overhang @ finer = -1, -2^Flare=1 bow (R9) & average = 0a V.Flare=2bstern (S9)(in inches)blunter = 1, 2To add to the measurement & results archive (above) copy & paste line 9 and then copy line 15 (17 for plastic or fabric) click on the first cell of the line & from EDIT menu click "paste special" & "paste values" then "paste special" & "paste formatting"  9P7q9{^n]>-S@A@t&G]n  l &APage &PMHP LaserJet 5P/5MP (HP)&X&6ә@X"d??3J33QQ;R Q;R3     4E43QQ;R!!Q;S3     4E43QQ;S""Q;3      4E4D FA< v 3Op 3 43*N#! 4523  43" $%3O&Q4444 ! P>   > ????mqq    q+ " ! ! ! ! !G !I ![ !] ! ! ! ! ! ! !! !# !I !K !n !p ! ! ! ! ! ! ! ! !) !+ !O !Q 2 &DRAG PREDICTION PROGRAM FOR NARROW HULLS (as short as 8' long--23 to 100 lb. wt.range -- and up to 30' long -- for 1200 to 5200 lb. wt.range)(in Cv*1000 range .7 to 3.0, best for Cv*1000=1 to 2, see G2 or J19)(for 300 lb displacement 11.5 to 19' EWL)                  Arial-   !" !" 12 "&Copyright 1999 by Matt Broze   Arial-    !3 !3 !3 !3 !34 !36 !3i !3k !3 !3 !3 !3 !3  !3 !3A !3C !3v !3x !3 !3 !3 !3 !_Oh+'Oh+'0;H:::::;;Gp: ] "   6'  ' 6-  "-## "- !#-!!$- !$!-22$- !$2-CC$- !$C-TT$- !$T-ee$- !$e-vv$- !$v-$- !$-$- !$-$- !$-$- !$-$- !$-6- !6-- !-- !-55- !5-'- 6$-   "-!$!6- !!$-2$26- !2$-C$C6- !C$-T$T6- !T$-e$e6- !e$-v$v6- !v$-$6- !$-$6- !$-$6- !$-$6- !$-$6- !$-- !-- !-55- !5-  !2 !65-  !$-  !2-  !6-  !65-'- 6Courier-   2 '# -  "-#- !!-""- ! "-#- ! -!!- ! !--  2  #!1 2 $ ##22 2 5 4#C3 2 F E#T4 2 W V#e5 2 h g#v6 2 y x#7 2 #8 2 #9 2 #10 2 #11 2 u%A 2 B 2 5C "Systemn-'- 6$Courier0- Arial- -   ! ! ! ! !4 !6 !i !k ! ! ! ! !  ! !A !C !v !x ! ! ! ! ! ! !J !L ! ! ! ! 3 !3 !3J !3L !3 !3 !3 !3 !3 !3 !3 !3 !3G !3I !3[ !3] !3 !3 !3 !3 !3 !3 !3! !3# !3I !3K !3n !3p !3 !3 2 3&Insert boat name & data on line 9. Results display on line 15 for glass & wood--line 17 for soft poly or fabric boats. (Cp range:.48 to .64, if Cp is larger results for .64 will display, if less than .48--#N/A displays--use .48)(See S10--How to measure)                  Arial-    !D !D !D !D !D4 !D6 !Di !Dk !D !D !D !D !D  !D !DA !DC !Dv !Dx !D !D !D !D !D !D !DJ !DL !D !D !D !D !D !D !D !D !DG !DI !D[ !D] !D !D !D !D !D !D !D! !D# !DI !DK !Dn !Dp l2 D&If meas. unknown, enter known data on line 9, then enter the calc. values from line 10 (or P11, Q11, or R12) or--next best--values from line 11 (programs estimate based on other data from line 9) onto line 9 or make your own best estimate                 !U !U !U !U !U4 !U6 !Ui !Uk !U !U !U !U !U  !U !UA !UC !Uv !Ux !U !U !U !U !U !U !UJ !UL !U !U !U !U--'- - e6U$  2 U&In Q9 estimate midship flare (little to none=0, moderate=1, extreme=2), In V9 & W9 estimate the fineness of the bow &stern ( from -2=very fine, 0=avg. to +2=v. blunt)             --'- - 6$ Arial-   !f !f !f !f !f4 !f6 !fi !fk !f !f !f !f !f  !f !fA !fC !fv !fx !f !f !f !f !f !f !fJ !fL !f !f !f !f !f !f--'-- v6f$  D2 f&LWL=Waterline length (ft), BWL=WL beam (ft), H=draft (ft), W.S.=Wetted surface (sq.ft), Cp=Prismatic coef., Disp.=Displacement (lb.), le=Bow half-angle (degrees), lx=Stern half-angle (not important at this time)                    --'-- 6$   !w !w !w !w !w4 !w6 !wi !wk !w !w !w !w !w  !w !wA !wC !wv !wx !w !w !w !w !w !w !wJ !wL !w !w !w !w !w !w--'-- 6w$  2 w&LCB=Longitudinal center of buoyancy, At/Ax=Area of immersed transom divided by area of immersed midship, LOA & BOA=Overall Length & Beam, Cx=midship coef., Cb=block coef.                  --'-- 6$-  2 & BOAT NAME  Arial - 2 LWL  2 EWL Arial- !2 &Mariner XL EWL    Arial-2 16.13-2 15.77 -  --'- - $ 92 &!Calculated if related dims. known   --'- - 6$ 2 16.09- --'- - 5 r2 G?use LWL or estimate it based on LWL, Cp, & le (or fineness of the bow)       --'- - 6$-  --'- - $ 12 &Suggestions if meas. unknown   --'- - 6$ 2 16.132 14.72 -6$-'-  6-  "-6- !6-- !-'ults display on line 15 for MCBRemoved b/d ratio effect from KCVCOMCH.XLS to try to mirror what John Winters wants to do. Also changed C3 formula and reynold's # modified by .9 as per Winters. RMicrosoft Excel