{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["CSV","MyCanoe","MyCanoe Basic Calcs"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":2,"defined_names":3,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"CSV","index":0,"n_rows":27,"n_cols":7,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["Stations",5,"Chines",5]
["Station","Chine","X","Y","Z","Break","Colour"]
[1,1,35,0,260,true,5]
[1,2,35,0,260,true,4]
[1,3,35,0,260,true,3]
[1,4,35,0,260,true,2]
[1,5,35,0,260,true,1]
[2,1,200,0,-50,true,5]
[2,2,200,0,-50,true,4]
[2,3,200,52,250,false,3]
[2,4,200,0,250,true,2]
[2,5,200,0,250,true,1]
[3,1,2000,0,-75,false,5]
[3,2,2000,275,-75,false,4]
[3,3,2000,325,200,false,3]
[3,4,2000,275,200,false,2]
[3,5,2000,275,250,false,1]
[4,1,3800,0,-50,true,5]
[4,2,3800,0,-50,true,4]
[4,3,3800,52,250,false,3]
[4,4,3800,0,250,true,2]
[4,5,3800,0,250,true,1]
[5,1,3965,0,260,true,0]
[5,2,3965,0,260,true,0]
[5,3,3965,0,260,true,0]
[5,4,3965,0,260,true,0]
[5,5,3965,0,260,true,0]

{"sheet":"MyCanoe","index":1,"n_rows":21,"n_cols":36,"rows_kept":21,"cut":false,"hidden":false,"merged":[[14,26,14,30],[14,31,14,35],[7,12,7,15],[14,1,14,5],[14,6,14,10],[14,11,14,15],[14,16,14,20],[14,21,14,25],[8,12,8,15],[8,18,8,20],[9,12,9,15],[9,18,9,20],[5,18,5,20],[6,12,6,15],[6,18,6,20],[0,0,0,1],[1,12,1,20],[2,12,2,15],[2,18,2,20],[3,3,5,5],[3,12,3,15],[3,18,3,20],[4,12,4,15],[4,18,4,20],[5,12,5,15]]}
["MyCanoe"]
["Find Offet Table at row",17,null,null,null,null,null,null,null,null,null,null,"MyCanoe Basic Design Statistics"]
["Stations",5,null,null,null,null,null,null,null,null,null,null,"Length Overall (LOA)",null,null,null,{"$f":"(V19-B19)/1000","v":3.93},"m"]
["Chines",5,null,null,null,null,null,null,null,null,null,null,"Beam Overall (BOA)",null,null,null,{"$f":"M19/500","v":0.65},"m"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Length Water Line (LWL)",null,null,null,{"$f":"(Q19-G19)/1000","v":3.6},"m"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Beam Water Line (BWL)",null,null,null,{"$f":"M20/500","v":0.55000000000000004},"m","Actually the bottom width"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Depth Water Line (DWL)",null,null,null,{"$f":"-N20/1000","v":7.4999999999999997E-2},"m"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Amidships Freeboard",null,null,null,{"$f":"N17/1000","v":0.25},"m"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Forward Freeboard",null,null,null,{"$f":"D17/1000","v":0.26},"m"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Rear Freeboard",null,null,null,{"$f":"X17/1000","v":0.26},"m"]
[]
[]
[]
[]
["Station",1,null,null,null,null,2,null,null,null,null,3,null,null,null,null,4,null,null,null,null,5,null,null,null,null,6,null,null,null,null,7]
["Chine","X","Y","Z","Break","Colour","X","Y","Z","Break","Colour","X","Y","Z","Break","Colour","X","Y","Z","Break","Colour","X","Y","Z","Break","Colour","X","Y","Z","Break","Colour","X","Y","Z","Break","Colour"]
["Coaming",35,0,260,true,1,200,0,250,true,1,2000,275,250,false,1,3800,0,250,true,1,3965,0,260,true,0]
["Deck",35,0,260,true,2,200,0,250,true,2,2000,275,200,false,2,3800,0,250,true,2,3965,0,260,true,0]
["Sheer",35,0,260,true,3,200,52,250,false,3,2000,325,200,false,3,3800,52,250,false,3,3965,0,260,true,0]
["Chine",35,0,260,true,4,200,0,-50,true,4,2000,275,-75,false,4,3800,0,-50,true,4,3965,0,260,true,0]
["Centreline",35,0,260,true,5,200,0,-50,true,5,2000,0,-75,false,5,3800,0,-50,true,5,3965,0,260,true,0]

{"sheet":"MyCanoe Basic Calcs","index":2,"n_rows":56,"n_cols":5,"rows_kept":56,"cut":false,"hidden":false,"merged":[[1,1,1,4],[11,1,11,4],[22,1,22,4],[35,1,35,4],[55,1,55,4]]}
[]
[null,"MyCanoe Basic Metrics"]
[null,"Length Overall (LOA)",{"$f":"MyCanoe!Q3","v":3.93},"m"]
[null,"Beam Overall (BOA)",{"$f":"MyCanoe!Q4","v":0.65},"m"]
[null,"Length Water Line (LWL)",{"$f":"MyCanoe!Q5","v":3.6},"m"]
[null,"Beam Water Line (BWL)",{"$f":"MyCanoe!Q6","v":0.55000000000000004},"m","Actually the bottom width"]
[null,"Depth Water Line (DWL)",{"$f":"MyCanoe!Q7","v":7.4999999999999997E-2},"m"]
[null,"Amidships Freeboard",{"$f":"MyCanoe!Q8","v":0.25},"m"]
[null,"Forward Freeboard",{"$f":"MyCanoe!Q9","v":0.26},"m"]
[null,"Rear Freeboard",{"$f":"MyCanoe!Q10","v":0.26},"m"]
[]
[null,"Basic Calculations (approximate)"]
[null,"Mid-Section Area",{"$f":"C6*C7","v":4.1250000000000002E-2},"m^2"]
[null,"Plan Water Line Area",{"$f":"C6*C5*2/3","v":1.32},"m^2"]
[null,"Displacement Volume",{"$f":"C5*C6*C7*2/3","v":9.9000000000000019E-2},"m^3"]
[null,"Displacement Weight",{"$f":"C15*1025","v":101.47500000000002},"kg"]
[null,"Prismatic Coefficient (cp)",{"$f":"C15/(C5*C6*C7)","v":0.66666666666666674}]
[null,"Displacement Length Ratio (DLR)",{"$f":"C16/(C3/3.048)^3","v":47.339786708634144}]
[null,"Hull Speed",{"$f":"1.34*(C5*3.28)^0.5","v":4.6046112539496757},"kt"]
[null,"Design G Force",3.5,"g"]
[null,"Design Pressure",{"$f":"C20*C16*9.81/1000/C14","v":2.6395031250000009},"kPa"]
[]
[null,"Bottom Plank Design"]
[null,"Design Pressure (P)",{"$f":"C21","v":2.6395031250000009},"kPa"]
[null,"Span (L)",{"$f":"C6*1000","v":550},"mm","BWL"]
[null,"Allowable Stress (S)",14000,"kPa","F14 Plywood"]
[null,"Plank Thickness (t)",{"$f":"(C24*C25*C25/C26/2)^0.5","v":5.340043122192462},"mm","t^2=P*L^2/2/S, ~fixed sides"]
[null,"Design Plank Thickness (t)",6,"mm"]
[null,"Modulus of Elasticity (E)",10500000,"kPa"]
[null,"Moment of Inertia (I)",{"$f":"1000*C28^3/12","v":18000},"mm^4"]
[null,"Deflection (d)",{"$f":"C24*C25^4/384/C29/C30*1000","v":3.3279738871256526},"mm","d=P*L^4/384EI (2% max)"]
[null,"Deflection Ratio",{"$f":"C25/C31","v":165.26571982060565}]
[null,"Maximum Concentrated Load",{"$f":"C26*C28*C28/1000000","v":0.504},"kN","=S*t*t"]
[]
[]
[null,"Hull Centre Reinforcement"]
[null,"T-Section Modulus"]
[null,"Maximum Rib Spacing (Flange Width)",{"$f":"36*C40+C41","v":296},"mm","Fw<36t+w"]
[null,"Design Rib Spacing",200,"mm"]
[null,"Plank Thickness  (Flange Thickness) ",{"$f":"C28","v":6},"mm"]
[null,"Rib Width (Web Thickness)",80,"mm"]
[null,"Rib Thickness (Web Height)",4,"mm"]
[null,"A",{"$f":"C38*C40+C42*C41","v":2096},"mm^2"]
[null,"cy",{"$f":"(C38*C40*C40/2+C42*C41*(C40+C42/2))/(C38*C40+C42*C41)","v":3.7633587786259541},"mm","From top of T"]
[null,"cx",{"$f":"(C38*C40*0/2+C42*C41*0/2)/(C38*C40+C42*C41)","v":0},"mm","From centre line of T"]
[null,"Ixx",{"$f":"C39*C40^3/12+C39*C40*(C44-C40/2)^2+C41*C42^3/12+C41*C42*(C44-C40-C42/2)^2","v":10469.647844919682},"mm^4"]
[null,"Iyy",{"$f":"C38*C38*C38*C40/12+C41*C41*C41*C42/12","v":13137834.666666666},"mm^4"]
[null,"Design Point Load",1,"kN","~100kg"]
[null,"Span",{"$f":"C25","v":550},"mm"]
[null,"Allowable Stress",{"$f":"C26","v":14000},"kPa","F14 Plywood"]
[null,"Bending Moment",{"$f":"C48*C49/8","v":68.75},"Nm"]
[null,"Section Modulus",{"$f":"C46/C44","v":2781.9956748163863},"mm^3"]
[null,"Working Stress (per rib)",{"$f":"C51/C52*1000000","v":24712.475516173312},"kN"]
[null,"Distribute Load (over two ribs)",{"$f":"C53/2","v":12356.237758086656},"kN"]
[null,"Safety Factor",{"$f":"C50/C54","v":1.133030965743401}]
[null,"Note: May be easier to either double plank thickness or reinforce with one layers of 4 oz/sq_yd fibre-glass on both sides"]