{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["CSV","MyCanoe700","MyCanoe700 Basic Calcs","MyCanoe700S","MyCanoe700S Basic Calcs"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":2,"defined_names":5,"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":47,"n_cols":7,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
["Stations",9,"Chines",5]
["Station","Chine","X","Y","Z","Break","Colour"]
[1,1,0,0,300,true,5]
[1,2,0,0,300,true,4]
[1,3,0,0,300,true,3]
[1,4,0,0,300,true,2]
[1,5,0,0,300,true,1]
[2,1,280.43478260869568,0,-75,true,5]
[2,2,280.43478260869568,0,-75,true,4]
[2,3,280.43478260869568,120.43644378114851,247.99028023137961,false,3]
[2,4,280.43478260869568,60.96408317580341,276.35921828699071,false,2]
[2,5,280.43478260869568,0,276.35921828699071,false,1]
[3,1,841.21086956521742,0,-75,false,5]
[3,2,841.21086956521742,101.98599949999998,-75,false,4]
[3,3,841.21086956521742,271.73709183814333,155.61093042155548,false,3]
[3,4,841.21086956521742,157.35916776937617,234.36860473707068,false,2]
[3,5,841.21086956521742,0,234.36860473707068,false,1]
[4,1,1215.217391304348,0,-75,false,5]
[4,2,1215.217391304348,150,-75,false,4]
[4,3,1215.217391304348,321.65356317294277,103.83896964514844,false,3]
[4,4,1215.217391304348,202.74102079395087,210.83589529324928,false,2]
[4,5,1215.217391304348,0,210.83589529324928,false,1]
[5,1,2150,0,-75,false,5]
[5,2,2150,200,-75,false,4]
[5,3,2150,350,25,false,3]
[5,4,2150,250,175,false,2]
[5,5,2150,0,175,false,1]
[6,1,3084.7826086956525,0,-75,false,5]
[6,2,3084.7826086956525,149.99999999999997,-75,false,4]
[6,3,3084.7826086956525,321.65356317294277,103.83896964514844,false,3]
[6,4,3084.7826086956525,202.74102079395081,210.83589529324928,false,2]
[6,5,3084.7826086956525,0,210.83589529324928,false,1]
[7,1,3458.6021739130438,0,-75,false,5]
[7,2,3458.6021739130438,102.01399949999997,-75,false,4]
[7,3,3458.6021739130438,271.77082319603949,155.58294536349521,false,3]
[7,4,3458.6021739130438,157.38563279773155,234.35588425613417,false,2]
[7,5,3458.6021739130438,0,234.35588425613417,false,1]
[8,1,4019.5652173913045,0,-75,true,5]
[8,2,4019.5652173913045,0,-75,true,4]
[8,3,4019.5652173913045,120.43644378114851,247.99028023137961,false,3]
[8,4,4019.5652173913045,60.964083175803353,276.35921828699071,false,2]
[8,5,4019.5652173913045,0,276.35921828699071,false,1]
[9,1,4300,0,300,true,0]
[9,2,4300,0,300,true,0]
[9,3,4300,0,300,true,0]
[9,4,4300,0,300,true,0]
[9,5,4300,0,300,true,0]

{"sheet":"MyCanoe700","index":1,"n_rows":21,"n_cols":46,"rows_kept":21,"cut":false,"hidden":false,"merged":[[14,21,14,25],[14,26,14,30],[14,31,14,35],[14,36,14,40],[14,41,14,45],[9,12,9,15],[9,18,9,20],[14,1,14,5],[14,6,14,10],[14,11,14,15],[14,16,14,20],[6,12,6,15],[6,18,6,20],[7,12,7,15],[8,12,8,15],[8,18,8,20],[7,18,7,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],[5,18,5,20]]}
["MyCanoe"]
["Find Offet Table at row",17,null,null,null,null,null,null,null,null,null,null,"MyCanoe Basic Design Statistics"]
["Stations",9,null,null,null,null,null,null,null,null,null,null,"Length Overall (LOA)",null,null,null,{"$f":"(AP17-B17)/1000","v":4.5999999999999996},"m"]
["Chines",5,null,null,null,null,null,null,null,null,null,null,"Beam Overall (BOA)",null,null,null,{"$f":"W19/500","v":0.7},"m"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Length Water Line (LWL)",null,null,null,{"$f":"(AK20-G20)/1000","v":4},"m"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Beam Water Line (BWL)",null,null,null,{"$f":"TREND(W19:W20,X19:X20,0)/500","v":0.625},"m"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Depth Water Line (DWL)",null,null,null,{"$f":"-X21/1000","v":7.4999999999999997E-2},"m"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Amidships Freeboard",null,null,null,{"$f":"X17/1000","v":0.17499999999999999},"m"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Forward Freeboard",null,null,null,{"$f":"D17/1000","v":0.3},"m"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Rear Freeboard",null,null,null,{"$f":"AR17/1000","v":0.3},"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,null,null,null,null,8,null,null,null,null,9]
["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","X","Y","Z","Break","Colour","X","Y","Z","Break","Colour"]
["Deck",0,0,300,true,1,300,0,276,false,1,900,0,234,false,1,1300,0,211,false,1,2300,0,175,false,1,3300,0,211,false,1,3700,0,234,false,1,4300,0,276,false,1,4600,0,300,true,0]
["Sheer",0,0,300,true,2,300,61,276,false,2,900,157,234,false,2,1300,203,211,false,2,2300,250,175,false,2,3300,203,211,false,2,3700,157,234,false,2,4300,61,276,false,2,4600,0,300,true,0]
["Chine",0,0,300,true,3,300,120,248,false,3,900,272,156,false,3,1300,322,104,false,3,2300,350,25,false,3,3300,322,104,false,3,3700,272,156,false,3,4300,120,248,false,3,4600,0,300,true,0]
["Rabbet",0,0,300,true,4,300,0,-75,true,4,900,102,-75,false,4,1300,150,-75,false,4,2300,200,-75,false,4,3300,150,-75,false,4,3700,102,-75,false,4,4300,0,-75,true,4,4600,0,300,true,0]
["Centreline",0,0,300,true,5,300,0,-75,true,5,900,0,-75,false,5,1300,0,-75,false,5,2300,0,-75,false,5,3300,0,-75,false,5,3700,0,-75,false,5,4300,0,-75,true,5,4600,0,300,true,0]

{"sheet":"MyCanoe700 Basic Calcs","index":2,"n_rows":34,"n_cols":5,"rows_kept":34,"cut":false,"hidden":false,"merged":[[1,1,1,4],[11,1,11,4],[22,1,22,4]]}
[]
[null,"MyCanoe Basic Metrics"]
[null,"Length Overall (LOA)",{"$f":"MyCanoe700!Q3","v":4.5999999999999996},"m"]
[null,"Beam Overall (BOA)",{"$f":"MyCanoe700!Q4","v":0.7},"m"]
[null,"Length Water Line (LWL)",{"$f":"MyCanoe700!Q5","v":4},"m"]
[null,"Beam Water Line (BWL)",{"$f":"MyCanoe700!Q6","v":0.625},"m"]
[null,"Depth Water Line (DWL)",{"$f":"MyCanoe700!Q7","v":7.4999999999999997E-2},"m"]
[null,"Amidships Freeboard",{"$f":"MyCanoe700!Q8","v":0.17499999999999999},"m"]
[null,"Forward Freeboard",{"$f":"MyCanoe700!Q9","v":0.3},"m"]
[null,"Rear Freeboard",{"$f":"MyCanoe700!Q10","v":0.3},"m"]
[]
[null,"Basic Calculations (approximate)"]
[null,"Mid-Section Area",{"$f":"C6*C7","v":4.6875E-2},"m^2"]
[null,"Plan Water Line Area",{"$f":"C6*C5*2/3","v":1.6666666666666667},"m^2"]
[null,"Displacement Volume",{"$f":"C5*C6*C7*2/3","v":0.125},"m^3"]
[null,"Displacement Weight",{"$f":"C15*1025","v":128.125},"kg"]
[null,"Prismatic Coefficient (cp)",{"$f":"C15/(C5*C6*C7)","v":0.66666666666666663}]
[null,"Displacement Length Ratio (DLR)",{"$f":"C16/(C3/3.048)^3","v":37.273937388016776}]
[null,"Hull Speed",{"$f":"1.34*(C5*3.28)^0.5","v":4.8536864340416557},"kt"]
[null,"Design G Force",3.5,"g"]
[null,"Design Pressure",{"$f":"C20*C16*9.81/1000/C14","v":2.6395031250000001},"kPa"]
[]
[null,"Bottom Plank Design"]
[null,"Design Pressure (P)",{"$f":"C21","v":2.6395031250000001},"kPa"]
[null,"Span (L)",{"$f":"C6*1000*0+MyCanoe700!W20*2","v":400},"mm","Sole"]
[null,"Allowable Stress (S)",14000,"kPa","F14 Plywood"]
[null,"Plank Thickness (t)",{"$f":"(C24*C25*C25/C26/2)^0.5","v":3.8836677252308802},"mm","t^2=P*L^2/2/S, ~fixed sides"]
[null,"Design Plank Thickness (t)",4,"mm"]
[null,"Modulus of Elasticity (E)",10700000,"kPa"]
[null,"Moment of Inertia (I)",{"$f":"1000*C28^3/12","v":5333.333333333333},"mm^4"]
[null,"Deflection (d)",{"$f":"C24*C25^4/384/C29/C30*1000","v":3.0835316880841122},"mm","d=P*L^4/384EI (2% max)"]
[null,"Deflection Ratio",{"$f":"C25/C31","v":129.72138458824517}]
[null,"Maximum Concentrated Load",{"$f":"C26*C28*C28/1000000","v":0.224},"kN","=S*t*t"]
[null,"* Floor will need to be reinforced"]

{"sheet":"MyCanoe700S","index":3,"n_rows":21,"n_cols":46,"rows_kept":21,"cut":false,"hidden":false,"merged":[[8,12,8,15],[8,18,8,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],[5,18,5,20],[6,12,6,15],[6,18,6,20],[7,12,7,15],[7,18,7,20],[9,12,9,15],[9,18,9,20],[14,1,14,5],[14,6,14,10],[14,11,14,15],[14,16,14,20],[14,21,14,25],[14,26,14,30],[14,31,14,35],[14,36,14,40],[14,41,14,45]]}
["MyCanoe (shortened)"]
["Find Offet Table at row",17,null,null,null,null,null,null,null,null,null,null,"MyCanoe (shortened) Basic Design Statistics"]
["Stations",9,null,null,null,null,null,null,null,null,null,null,"Length Overall (LOA)",null,null,null,{"$f":"(AP17-B17)/1000","v":4.3},"m"]
["Chines",5,null,null,null,null,null,null,null,null,null,null,"Beam Overall (BOA)",null,null,null,{"$f":"W19/500","v":0.7},"m"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Length Water Line (LWL)",null,null,null,{"$f":"(AK20-G20)/1000","v":3.7391304347826089},"m"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Beam Water Line (BWL)",null,null,null,{"$f":"TREND(W19:W20,X19:X20,0)/500","v":0.625},"m"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Depth Water Line (DWL)",null,null,null,{"$f":"-X21/1000","v":7.4999999999999997E-2},"m"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Amidships Freeboard",null,null,null,{"$f":"X17/1000","v":0.17499999999999999},"m"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Forward Freeboard",null,null,null,{"$f":"D17/1000","v":0.3},"m"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Rear Freeboard",null,null,null,{"$f":"AR17/1000","v":0.3},"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,null,null,null,null,8,null,null,null,null,9]
["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","X","Y","Z","Break","Colour","X","Y","Z","Break","Colour"]
["Deck",0,0,300,true,1,280.43478260869568,0,276.35921828699071,false,1,841.21086956521742,0,234.36860473707068,false,1,1215.217391304348,0,210.83589529324928,false,1,2150,0,175,false,1,3084.7826086956525,0,210.83589529324928,false,1,3458.6021739130438,0,234.35588425613417,false,1,4019.5652173913045,0,276.35921828699071,false,1,4300,0,300,true,0]
["Sheer",0,0,300,true,2,280.43478260869568,60.96408317580341,276.35921828699071,false,2,841.21086956521742,157.35916776937617,234.36860473707068,false,2,1215.217391304348,202.74102079395087,210.83589529324928,false,2,2150,250,175,false,2,3084.7826086956525,202.74102079395081,210.83589529324928,false,2,3458.6021739130438,157.38563279773155,234.35588425613417,false,2,4019.5652173913045,60.964083175803353,276.35921828699071,false,2,4300,0,300,true,0]
["Chine",0,0,300,true,3,280.43478260869568,120.43644378114851,247.99028023137961,false,3,841.21086956521742,271.73709183814333,155.61093042155548,false,3,1215.217391304348,321.65356317294277,103.83896964514844,false,3,2150,350,25,false,3,3084.7826086956525,321.65356317294277,103.83896964514844,false,3,3458.6021739130438,271.77082319603949,155.58294536349521,false,3,4019.5652173913045,120.43644378114851,247.99028023137961,false,3,4300,0,300,true,0]
["Rabbet",0,0,300,true,4,280.43478260869568,0,-75,true,4,841.21086956521742,101.98599949999998,-75,false,4,1215.217391304348,150,-75,false,4,2150,200,-75,false,4,3084.7826086956525,149.99999999999997,-75,false,4,3458.6021739130438,102.01399949999997,-75,false,4,4019.5652173913045,0,-75,true,4,4300,0,300,true,0]
["Centreline",0,0,300,true,5,280.43478260869568,0,-75,true,5,841.21086956521742,0,-75,false,5,1215.217391304348,0,-75,false,5,2150,0,-75,false,5,3084.7826086956525,0,-75,false,5,3458.6021739130438,0,-75,false,5,4019.5652173913045,0,-75,true,5,4300,0,300,true,0]

{"sheet":"MyCanoe700S Basic Calcs","index":4,"n_rows":34,"n_cols":5,"rows_kept":34,"cut":false,"hidden":false,"merged":[[1,1,1,4],[11,1,11,4],[22,1,22,4]]}
[]
[null,"MyCanoe (shortened) Basic Metrics"]
[null,"Length Overall (LOA)",{"$f":"MyCanoe700S!Q3","v":4.3},"m"]
[null,"Beam Overall (BOA)",{"$f":"MyCanoe700S!Q4","v":0.7},"m"]
[null,"Length Water Line (LWL)",{"$f":"MyCanoe700S!Q5","v":3.7391304347826089},"m"]
[null,"Beam Water Line (BWL)",{"$f":"MyCanoe700S!Q6","v":0.625},"m"]
[null,"Depth Water Line (DWL)",{"$f":"MyCanoe700S!Q7","v":7.4999999999999997E-2},"m"]
[null,"Amidships Freeboard",{"$f":"MyCanoe700S!Q8","v":0.17499999999999999},"m"]
[null,"Forward Freeboard",{"$f":"MyCanoe700S!Q9","v":0.3},"m"]
[null,"Rear Freeboard",{"$f":"MyCanoe700S!Q10","v":0.3},"m"]
[]
[null,"Basic Calculations (approximate)"]
[null,"Mid-Section Area",{"$f":"C6*C7","v":4.6875E-2},"m^2"]
[null,"Plan Water Line Area",{"$f":"C6*C5*2/3","v":1.5579710144927537},"m^2"]
[null,"Displacement Volume",{"$f":"C5*C6*C7*2/3","v":0.11684782608695653},"m^3"]
[null,"Displacement Weight",{"$f":"C15*1025","v":119.76902173913044},"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":42.656382646318825}]
[null,"Hull Speed",{"$f":"1.34*(C5*3.28)^0.5","v":4.6927457800867227},"kt"]
[null,"Design G Force",3.5,"g"]
[null,"Design Pressure",{"$f":"C20*C16*9.81/1000/C14","v":2.6395031249999996},"kPa"]
[]
[null,"Bottom Plank Design"]
[null,"Design Pressure (P)",{"$f":"C21","v":2.6395031249999996},"kPa"]
[null,"Span (L)",{"$f":"C6*1000*0+MyCanoe700!W20*2","v":400},"mm","Sole"]
[null,"Allowable Stress (S)",14000,"kPa","F14 Plywood"]
[null,"Plank Thickness (t)",{"$f":"(C24*C25*C25/C26/2)^0.5","v":3.8836677252308798},"mm","t^2=P*L^2/2/S, ~fixed sides"]
[null,"Design Plank Thickness (t)",4,"mm"]
[null,"Modulus of Elasticity (E)",10700000,"kPa"]
[null,"Moment of Inertia (I)",{"$f":"1000*C28^3/12","v":5333.333333333333},"mm^4"]
[null,"Deflection (d)",{"$f":"C24*C25^4/384/C29/C30*1000","v":3.0835316880841117},"mm","d=P*L^4/384EI (2% max)"]
[null,"Deflection Ratio",{"$f":"C25/C31","v":129.7213845882452}]
[null,"Maximum Concentrated Load",{"$f":"C26*C28*C28/1000000","v":0.224},"kN","=S*t*t"]
[null,"* Floor will need to be reinforced"]