{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Raft","Decking","Poles","Ropes and Barrels","Raft Load","Data"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Raft","index":0,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Recommended Minimum No. of barrels to use:",{"$f":"IF(B9=0,\"\",IF('Ropes and Barrels'!D3 = \"\", \"Specify barrel type\",CEILING($B$9/'Ropes and Barrels'!$E$3,1)))","v":6}]
["Planned no of Barrels",{"$f":"'Ropes and Barrels'!E4","v":15}]
["The planned barrels will be",{"$f":"$B$9/'Ropes and Barrels'!$E$3/'Ropes and Barrels'!E4*Data!O2","v":0.17388546478220041},"submerged"]
["Depth of Planned Barrels in water",331,"mm"]
[{"$f":"Poles!I2","v":"Total Mass of poles (kg)"},{"$f":"Poles!$I$3","v":310.33086824093044}]
[{"$f":"Decking!G2","v":"Total Mass of Decking (kg)"},{"$f":"Decking!$G$3","v":97.914432000000005}]
[{"$f":"'Ropes and Barrels'!B2","v":"Total Mass of Ropes (kg)"},{"$f":"'Ropes and Barrels'!$B$3","v":46.8}]
["Total Load Mass (kg)",{"$f":"'Raft Load'!$C$1","v":630}]
["Total Raft mass (kg)",{"$f":"SUM(B5:B8)","v":1085.0453002409304}]

{"sheet":"Decking","index":1,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Decking"]
["Type","Length (m)","Width (m)","No of Boards","Density","Mass (kg)","Total Mass of Decking (kg)"]
["Ply",2.4,1.4,4,{"$f":"IF(A3=\"\",\"\",VLOOKUP(A3,Data!$E$2:$F$4,2,FALSE))","v":7.2853000000000003},{"$f":"IF(AND(E3<>\"\",B3<>\"\",C3<>\"\",D3<>\"\"),D3*C3*B3*E3,\"\")","v":97.914432000000005},{"$f":"SUM(F3:F15)","v":97.914432000000005}]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]

{"sheet":"Poles","index":2,"n_rows":30,"n_cols":9,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["Poles"]
["Pole Age","Length (m)","Average Diameter (cm)","No of Poles","Density","Diameter","Mass (kg)","Mass (kg)","Total Mass of poles (kg)"]
["Old Poles",6,"11 to 15",6,{"$f":"IF(A3=\"\",\"\",VLOOKUP(A3,Data!$A$2:$B$4,2,FALSE))","v":427.08368189999999},{"$f":"IF(C3=\"\",\"\",VLOOKUP(C3,Data!$C$2:$D$9,2,FALSE))","v":13},{"$f":"IF(F3=\"\",\"\",((PI()*(F3/200)^2)*B3*E3))","v":34.012676973261804},{"$f":"IF(D3=\"\",\"\",D3*G3)","v":204.07606183957083},{"$f":"SUM(H3:H30)","v":310.33086824093044}]
["Old Poles",4,"8 to 13",5,{"$f":"IF(A4=\"\",\"\",VLOOKUP(A4,Data!$A$2:$B$4,2,FALSE))","v":427.08368189999999},{"$f":"IF(C4=\"\",\"\",VLOOKUP(C4,Data!$C$2:$D$9,2,FALSE))","v":10.5},14.792495606714448,73.962478033572239]
["New Poles",2.5,"6 to 10",4,{"$f":"IF(A5=\"\",\"\",VLOOKUP(A5,Data!$A$2:$B$4,2,FALSE))","v":471.6019877},{"$f":"IF(C5=\"\",\"\",VLOOKUP(C5,Data!$C$2:$D$9,2,FALSE))","v":8},5.926325359906655,23.70530143962662]
["Old Poles",2,"6 to 10",2,{"$f":"IF(A6=\"\",\"\",VLOOKUP(A6,Data!$A$2:$B$4,2,FALSE))","v":427.08368189999999},{"$f":"IF(C6=\"\",\"\",VLOOKUP(C6,Data!$C$2:$D$9,2,FALSE))","v":8},4.2935134640803838,8.5870269281607676]
[null,null,null,null,{"$f":"IF(A7=\"\",\"\",VLOOKUP(A7,Data!$A$2:$B$4,2,FALSE))","v":""},{"$f":"IF(C7=\"\",\"\",VLOOKUP(C7,Data!$C$2:$D$9,2,FALSE))","v":""},"",""]
[null,null,null,null,{"$f":"IF(A8=\"\",\"\",VLOOKUP(A8,Data!$A$2:$B$4,2,FALSE))","v":""},{"$f":"IF(C8=\"\",\"\",VLOOKUP(C8,Data!$C$2:$D$9,2,FALSE))","v":""},"",""]
[null,null,null,null,{"$f":"IF(A9=\"\",\"\",VLOOKUP(A9,Data!$A$2:$B$4,2,FALSE))","v":""},{"$f":"IF(C9=\"\",\"\",VLOOKUP(C9,Data!$C$2:$D$9,2,FALSE))","v":""},"",""]
[null,null,null,null,{"$f":"IF(A10=\"\",\"\",VLOOKUP(A10,Data!$A$2:$B$4,2,FALSE))","v":""},{"$f":"IF(C10=\"\",\"\",VLOOKUP(C10,Data!$C$2:$D$9,2,FALSE))","v":""},"",""]
[null,null,null,null,{"$f":"IF(A11=\"\",\"\",VLOOKUP(A11,Data!$A$2:$B$4,2,FALSE))","v":""},{"$f":"IF(C11=\"\",\"\",VLOOKUP(C11,Data!$C$2:$D$9,2,FALSE))","v":""},"",""]
[null,null,null,null,{"$f":"IF(A12=\"\",\"\",VLOOKUP(A12,Data!$A$2:$B$4,2,FALSE))","v":""},{"$f":"IF(C12=\"\",\"\",VLOOKUP(C12,Data!$C$2:$D$9,2,FALSE))","v":""},"",""]
[null,null,null,null,{"$f":"IF(A13=\"\",\"\",VLOOKUP(A13,Data!$A$2:$B$4,2,FALSE))","v":""},{"$f":"IF(C13=\"\",\"\",VLOOKUP(C13,Data!$C$2:$D$9,2,FALSE))","v":""},"",""]
[null,null,null,null,{"$f":"IF(A14=\"\",\"\",VLOOKUP(A14,Data!$A$2:$B$4,2,FALSE))","v":""},{"$f":"IF(C14=\"\",\"\",VLOOKUP(C14,Data!$C$2:$D$9,2,FALSE))","v":""},"",""]
[null,null,null,null,{"$f":"IF(A15=\"\",\"\",VLOOKUP(A15,Data!$A$2:$B$4,2,FALSE))","v":""},{"$f":"IF(C15=\"\",\"\",VLOOKUP(C15,Data!$C$2:$D$9,2,FALSE))","v":""},"",""]
[null,null,null,null,{"$f":"IF(A16=\"\",\"\",VLOOKUP(A16,Data!$A$2:$B$4,2,FALSE))","v":""},{"$f":"IF(C16=\"\",\"\",VLOOKUP(C16,Data!$C$2:$D$9,2,FALSE))","v":""},"",""]
[null,null,null,null,{"$f":"IF(A17=\"\",\"\",VLOOKUP(A17,Data!$A$2:$B$4,2,FALSE))","v":""},{"$f":"IF(C17=\"\",\"\",VLOOKUP(C17,Data!$C$2:$D$9,2,FALSE))","v":""},"",""]
[null,null,null,null,{"$f":"IF(A18=\"\",\"\",VLOOKUP(A18,Data!$A$2:$B$4,2,FALSE))","v":""},{"$f":"IF(C18=\"\",\"\",VLOOKUP(C18,Data!$C$2:$D$9,2,FALSE))","v":""},"",""]
[null,null,null,null,{"$f":"IF(A19=\"\",\"\",VLOOKUP(A19,Data!$A$2:$B$4,2,FALSE))","v":""},{"$f":"IF(C19=\"\",\"\",VLOOKUP(C19,Data!$C$2:$D$9,2,FALSE))","v":""},"",""]
[null,null,null,null,{"$f":"IF(A20=\"\",\"\",VLOOKUP(A20,Data!$A$2:$B$4,2,FALSE))","v":""},{"$f":"IF(C20=\"\",\"\",VLOOKUP(C20,Data!$C$2:$D$9,2,FALSE))","v":""},"",""]
[]
[]
[null,null,null,null,{"$f":"IF(A23=\"\",\"\",VLOOKUP(A23,Data!$A$2:$B$4,2,FALSE))","v":""},{"$f":"IF(C23=\"\",\"\",VLOOKUP(C23,Data!$C$2:$D$9,2,FALSE))","v":""},"",""]
[null,null,null,null,{"$f":"IF(A24=\"\",\"\",VLOOKUP(A24,Data!$A$2:$B$4,2,FALSE))","v":""},{"$f":"IF(C24=\"\",\"\",VLOOKUP(C24,Data!$C$2:$D$9,2,FALSE))","v":""},"",""]
[null,null,null,null,{"$f":"IF(A25=\"\",\"\",VLOOKUP(A25,Data!$A$2:$B$4,2,FALSE))","v":""},{"$f":"IF(C25=\"\",\"\",VLOOKUP(C25,Data!$C$2:$D$9,2,FALSE))","v":""},"",""]
[null,null,null,null,{"$f":"IF(A26=\"\",\"\",VLOOKUP(A26,Data!$A$2:$B$4,2,FALSE))","v":""},{"$f":"IF(C26=\"\",\"\",VLOOKUP(C26,Data!$C$2:$D$9,2,FALSE))","v":""},"",""]
[null,null,null,null,{"$f":"IF(A27=\"\",\"\",VLOOKUP(A27,Data!$A$2:$B$4,2,FALSE))","v":""},{"$f":"IF(C27=\"\",\"\",VLOOKUP(C27,Data!$C$2:$D$9,2,FALSE))","v":""},"",""]
[null,null,null,null,{"$f":"IF(A28=\"\",\"\",VLOOKUP(A28,Data!$A$2:$B$4,2,FALSE))","v":""},{"$f":"IF(C28=\"\",\"\",VLOOKUP(C28,Data!$C$2:$D$9,2,FALSE))","v":""},"",""]
[null,null,null,null,{"$f":"IF(A29=\"\",\"\",VLOOKUP(A29,Data!$A$2:$B$4,2,FALSE))","v":""},{"$f":"IF(C29=\"\",\"\",VLOOKUP(C29,Data!$C$2:$D$9,2,FALSE))","v":""},"",""]
[null,null,null,null,{"$f":"IF(A30=\"\",\"\",VLOOKUP(A30,Data!$A$2:$B$4,2,FALSE))","v":""},{"$f":"IF(C30=\"\",\"\",VLOOKUP(C30,Data!$C$2:$D$9,2,FALSE))","v":""},"",""]

{"sheet":"Ropes and Barrels","index":3,"n_rows":4,"n_cols":5,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Ropes",null,null,"Barrels"]
["No. of Ropes","Total Mass of Ropes (kg)",null,"Barrel Type:","Carrying capacity (kg)"]
[78,{"$f":"IF(A3=\"\",\"\",A3*Data!$M$2)","v":46.8},null,"Plastic",{"$f":"IF(D3=\"\",\"\",VLOOKUP(D3,Data!$G$2:$K$4,5,FALSE))","v":208}]
[null,null,null,"Planned no of Barrels:",15]

{"sheet":"Raft Load","index":4,"n_rows":27,"n_cols":4,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["Loading Criteria","Total Mass of Raft Load (kg):",{"$f":"SUM($D$6,$D$9,$B$15,$B$18,$B$21,$B$24,$C$27)","v":630}]
[]
["Please enter all masses (weights) in kg"]
[]
["Crew","Average mass of Crew","No. of Crew","Mass of Crew"]
[null,80,6,{"$f":"C6*B6","v":480}]
[]
["Personal Kit","Avg. mass of Personal Kit",null,"Mass of P.K."]
[null,10,null,{"$f":"B9*C6","v":60}]
[]
["Propulsion System","Mass of Propulsion System"]
[null,50]
[]
["Shelter","Mass of Shelter"]
[null,10]
[]
["Food and Water","Mass of Food and Water"]
[null,30]
[]
["Kitchen Equipment","Mass of Kitchen Equipment"]
[null,30]
[]
["Decorations","Mass of Decorations"]
[null,20]
[]
["Extras (Description)","Mass of Extras (kg)","Total mass of extras"]
[null,null,{"$f":"SUM(B27:B43)","v":0}]

{"sheet":"Data","index":5,"n_rows":23,"n_cols":15,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["Poles",null,null,null,"Boards",null,"Barrels","Diameter(mm)","Drum Capacity","Drum Weight","Carrying capacity (kg)","length","Rope (kg)",null,"Depth of barrel in the water"]
["Poles","Density (kg/m3)","Diam. (cm)","Diameter","type","plane density (kg/mm2)","Type",null,null,null,null,1,0.6,null,0.5]
["New Poles",471.6019877,"1 to 5",3.5,"Chip",{"$f":"0.0000117717*1000000","v":11.771699999999999},"Metal",572,220,21,{"$f":"I3-J3","v":199},1.5]
["Old Poles",427.08368189999999,"4 to 8",6,"Ply",{"$f":"0.0000072853*1000000","v":7.2853000000000003},"Plastic",572,220,12,{"$f":"I4-J4","v":208},1.8]
[null,null,"6 to 10",8,null,null,null,null,null,null,null,2]
[null,null,"8 to 13",10.5,null,null,null,null,null,null,null,2.5]
[null,null,"11 to 15",13,null,null,null,null,null,null,null,3]
[null,null,"13 to 18",15.5,null,null,null,null,null,null,null,3.5]
[null,null,"16 to 20",18,null,null,null,null,null,null,null,4]
[null,null,null,null,null,null,null,null,null,null,null,4.5]
[null,null,null,null,null,null,null,null,null,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,5.5]
[null,null,null,null,null,null,null,null,null,null,null,6]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,1]