{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["CSV","Pontoon","Pontoon 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":26,"n_cols":7,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["Stations",7,"Chines",4]
["Station","Chine","X","Y","Z","Break","Colour"]
[1,1,20,0.2362305417879273,146.94655749012799,true,1]
[1,2,20,0.2362305417879273,146.94655749012799,true,2]
[1,3,20,0.2362305417879273,146.94655749012799,true,3]
[1,4,20,0.2362305417879273,146.94655749012799,true,4]
[2,1,135,0.2362305417879273,0,true,1]
[2,2,135,0.2362305417879273,0,true,2]
[3,1,604,0.2362305417879273,-48.362158161307953,false,1]
[3,2,604,132.06589344049479,-24.181079080653976,false,2]
[3,3,604,157.17701402425084,106.02473135363667,false,3]
[3,4,604,0,144.15643298082179,false,4]
[4,1,1200,0,-69.753112732655694,false,1]
[4,2,1200,184.14821761421103,-45.572033652001714,false,2]
[4,3,1200,208.32929669486504,92.074108807105517,false,3]
[4,4,1200,0,142.29634997461764,false,4]
[5,1,1777,0,-51.152282670614177,false,1]
[5,2,1777,132.06589344049479,-26.971203589960204,false,2]
[5,3,1777,157.17701402425084,92.074108807105517,false,3]
[5,4,1777,0,112.53502187535119,false,4]
[6,1,2332,0,0,true,1]
[6,2,2332,0,0,true,2]
[7,1,2364,0,92.074108807105517,true,0]
[7,2,2364,0,92.074108807105517,true,0]
[7,3,2364,0,92.074108807105517,true,0]
[7,4,2364,0,92.074108807105517,true,0]

{"sheet":"Pontoon","index":1,"n_rows":20,"n_cols":36,"rows_kept":20,"cut":false,"hidden":false,"merged":[[14,16,14,20],[14,21,14,25],[14,26,14,30],[14,31,14,35],[10,12,10,15],[10,18,10,20],[11,12,11,15],[11,18,11,20],[14,1,14,5],[14,6,14,10],[14,11,14,15],[12,0,12,10],[11,0,11,10],[10,0,10,10],[7,12,7,15],[7,18,7,20],[8,12,8,15],[8,18,8,20],[9,12,9,15],[9,18,9,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,12,3,15],[3,18,3,20],[3,3,5,5],[4,12,4,15],[4,18,4,20],[5,12,5,15],[5,18,5,20]]}
["Pontoon"]
["Find Offet Table at row",17,null,null,null,null,null,null,null,null,null,null,"Pontoon Basic Design Statistics"]
["Stations",7,null,null,null,null,null,null,null,null,null,null,"Length Overall (LOA)",null,null,null,{"$f":"(AF17-B17)/1000","v":2.3439999999999999},"m"]
["Chines",4,null,null,null,null,null,null,null,null,null,null,"Beam Overall (BOA)",null,null,null,{"$f":"R18/500","v":0.41665859338973005},"m"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Length Water Line (LWL)",null,null,null,{"$f":"(AA19-G19)/1000","v":2.1970000000000001},"m"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Beam Water Line (BWL)",null,null,null,{"$f":"M19/500","v":0.26413178688098959},"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":"-S20/1000","v":6.9753112732655692E-2},"m"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Rocker",null,null,null,{"$f":"(I20-S20)/1000","v":6.9753112732655692E-2},"m"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Amidships Deadrise",null,null,null,{"$f":"DEGREES(ATAN2(R19-R20,S19-S20))","v":7.4808861795236794},"Degrees"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Amidships Freeboard",null,null,null,{"$f":"S17/1000","v":0.14229634997461765},"m"]
["This design is based on work by:",null,null,null,null,null,null,null,null,null,null,null,"Forward Freeboard",null,null,null,{"$f":"I17/1000","v":0},"m"]
["Bruce C. Anderson",null,null,null,null,null,null,null,null,null,null,null,"Rear Freeboard",null,null,null,{"$f":"X17/1000","v":0.11253502187535119},"m"]
["http://buckwheat-anderson.com/bcanderson/Boatz/OSKayak/OSKbuild.html"]
[]
["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"]
["Deck",20,0.2362305417879273,146.94655749012799,true,3.7914691943127963,null,null,null,null,null,604,0,144.15643298082179,false,3.7914691943127963,1200,0,142.29634997461764,false,3.7914691943127963,1777,0,112.53502187535119,false,3.7914691943127963,null,null,null,null,null,2364,0,92.074108807105517,true,0]
["Sheer",20,0.2362305417879273,146.94655749012799,true,2.8436018957345972,null,null,null,null,null,604,157.17701402425084,106.02473135363667,false,2.8436018957345972,1200,208.32929669486504,92.074108807105517,false,2.8436018957345972,1777,157.17701402425084,92.074108807105517,false,2.8436018957345972,null,null,null,null,null,2364,0,92.074108807105517,true,0]
["Chine",20,0.2362305417879273,146.94655749012799,true,1.8957345971563981,135,0.2362305417879273,0,true,1.8957345971563981,604,132.06589344049479,-24.181079080653976,false,1.8957345971563981,1200,184.14821761421103,-45.572033652001714,false,1.8957345971563981,1777,132.06589344049479,-26.971203589960204,false,1.8957345971563981,2332,0,0,true,1.8957345971563981,2364,0,92.074108807105517,true,0]
["Centreline",20,0.2362305417879273,146.94655749012799,true,0.94786729857819907,135,0.2362305417879273,0,true,0.94786729857819907,604,0.2362305417879273,-48.362158161307953,false,0.94786729857819907,1200,0,-69.753112732655694,false,0.94786729857819907,1777,0,-51.152282670614177,false,0.94786729857819907,2332,0,0,true,0.94786729857819907,2364,0,92.074108807105517,true,0]

{"sheet":"Pontoon Basic Calcs","index":2,"n_rows":35,"n_cols":5,"rows_kept":35,"cut":false,"hidden":false,"merged":[[1,1,1,4],[13,1,13,4],[24,1,24,4]]}
[]
[null,"Pontoon Basic Metrics"]
[null,"Length Overall (LOA)",{"$f":"Pontoon!Q3","v":2.3439999999999999},"m"]
[null,"Beam Overall (BOA)",{"$f":"Pontoon!Q4","v":0.41665859338973005},"m"]
[null,"Length Water Line (LWL)",{"$f":"Pontoon!Q5","v":2.1970000000000001},"m"]
[null,"Beam Water Line (BWL)",{"$f":"Pontoon!Q6","v":0.26413178688098959},"m","Actually the bottom width"]
[null,"Depth Water Line (DWL)",{"$f":"Pontoon!Q7","v":6.9753112732655692E-2},"m"]
[null,"Rocker",{"$f":"Pontoon!Q8","v":6.9753112732655692E-2},"m"]
[null,"Amidships Deadrise",{"$f":"Pontoon!Q9","v":7.4808861795236794},"Degrees"]
[null,"Amidships Freeboard",{"$f":"Pontoon!Q10","v":0.14229634997461765},"m"]
[null,"Forward Freeboard",{"$f":"Pontoon!Q11","v":0},"m"]
[null,"Rear Freeboard",{"$f":"Pontoon!Q12","v":0.11253502187535119},"m"]
[]
[null,"Basic Calculations (approximate)"]
[null,"Mid-Section Area",{"$f":"C6*C7","v":1.8424014306587456E-2},"m^2"]
[null,"Plan Water Line Area",{"$f":"C6*C5*2/3","v":0.38686502385168947},"m^2"]
[null,"Displacement Volume",{"$f":"C5*C6*(C7-C8/3)*2/3","v":1.7990026414032283E-2},"m^3"]
[null,"Displacement Weight",{"$f":"C17*1025","v":18.439777074383091},"kg"]
[null,"Prismatic Coefficient (cp)",{"$f":"C17/(C5*C6*C7)","v":0.44444444444444442}]
[null,"Displacement Length Ratio (DLR)",{"$f":"C18/(C3/3.048)^3","v":40.54410634720746}]
[null,"Hull Speed",{"$f":"1.34*(C5*3.28)^0.5","v":3.597135095600386},"kt"]
[null,"Design G Force",3.5,"g"]
[null,"Design Pressure",{"$f":"C22*C18*9.81/1000/C16","v":1.6365649692117508},"kPa"]
[]
[null,"Bottom Plank Design"]
[null,"Design Pressure (P)",{"$f":"C23","v":1.6365649692117508},"kPa"]
[null,"Span (L)",{"$f":"C6*1000","v":264.13178688098958},"mm","BWL"]
[null,"Allowable Stress (S)",14000,"kPa","F14 Plywood"]
[null,"Plank Thickness (t)",{"$f":"(C26*C27*C27/C28/2)^0.5","v":2.0193345650087982},"mm","t^2=P*L^2/2/S, ~fixed sides"]
[null,"Design Plank Thickness (t)",6,"mm"]
[null,"Modulus of Elasticity (E)",{"$f":"10500000","v":10500000},"kPa"]
[null,"Moment of Inertia (I)",{"$f":"1000*C30^3/12","v":18000},"mm^4"]
[null,"Deflection (d)",{"$f":"C26*C27^4/384/C31/C32*1000","v":0.10975464263003537},"mm","d=P*L^4/384EI (2% max)"]
[null,"Deflection Ratio",{"$f":"C27/C33","v":2406.5659597775179}]
[null,"Maximum Concentrated Load",{"$f":"C28*C30*C30/1000000","v":0.504},"kN","=S*t*t"]