{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Flexiflume","Pumpline"],"not_rendered":{"charts":0,"images":7,"macros":1,"external_links":0,"defined_names":0,"comments":2,"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":"Flexiflume","index":0,"n_rows":34,"n_cols":8,"rows_kept":34,"cut":false,"hidden":false,"merged":[[8,1,8,3],[7,5,7,7],[33,0,33,7],[1,4,1,7],[2,4,2,7],[3,4,3,7],[4,4,4,7],[5,4,5,7]]}
[]
[null,null,null,null,"Free Call: 1800 115 440"]
[null,null,null,null,"land line: 03 5339 3103"]
[null,null,null,null,"International: +61 3 5339 3103"]
[null,null,null,null,"info@bartlett.net.au"]
[null,null,null,null,"www.bartlett.net.au"]
["Flexiflume Friction Loss Calculator"]
[null,null,null,null,null,"Converted Inputs"]
[null,"Calculation Inputs",null,null,null,"Flow","Distance","Stat.Hd."]
["Static Head:- Difference in Altitude between","Flow","Distance","Static",null,"US gpm","feet","feet"]
["Lowest & Highest points of the line","in","in","Head",null,{"$f":"B13/3.7854*60","v":0},{"$f":"C13*3.281","v":0},{"$f":"D13*3.281","v":0}]
[null,"L/Sec","Metres","Metres",null,"UK gmp","yards","psi"]
[null,0,0,0,null,{"$f":"B13/4.5461*60","v":0},{"$f":"G11/3","v":0},{"$f":"D13*1.42094","v":0}]
[null,null,null,null,null,"CuSec","chains","Kpa"]
["Approximate number of outlets that could run at 2l/s each",{"$f":"B13/2","v":0},null,null,null,{"$f":"F11*0.00222801","v":0},{"$f":"C13/20.11684","v":0},{"$f":"D13*9.806","v":0}]
["Note: You need between 1.5m and 0.5m head",null,null,null,null,"ML/day"]
["at each outlet for proper operation.",null,null,null,null,{"$f":"(+B13*60*60*24)/1000000","v":0}]
[]
["Calculation Results"]
["Fluming Nominal Diameter (inches)","3\"","5\"","7\"","9\"","11\"","13\"","16\""]
["Fluming Actual Diameter (inches)",3.3860000000000001,5.2750000000000004,7.2,9.1,11.02,12.9,16.73]
["Fluming Actual Diameter (millimetres)",86,134,183,231,280,328,425]
["Friction Loss per 100m (metres head)",{"$f":"((((3350000)*$B$13))/((B$22^2.63)*149))^1.852","v":0},0,0,0,0,0,0]
["Friction Loss per 100 feet (Feet head )",{"$f":"B23","v":0},{"$f":"C23","v":0},0,0,0,0,0]
["Friction Loss per 100 feet (psi )",{"$f":"B23*1.42094/3.281","v":0},{"$f":"C23*1.42094/3.281","v":0},0,0,0,0,0]
["Total Friction Loss + Static Head (metres head)",{"$f":"((+$C$13*0.01)*B$23)+$D$13","v":0},{"$f":"((+$C$13*0.01)*C23)+$D$13","v":0},0,0,0,0,0]
["Total Friction Loss + Static Head (feet head)",{"$f":"(((+$C$13*0.01)*B$23)+$D$13)*3.281","v":0},{"$f":"(((+$C$13*0.01)*C$23)+$D$13)*3.281","v":0},0,0,0,0,0]
["Total Friction Loss + Static Head (psi)",{"$f":"(((+$C$13*0.01)*B$23)+$D$13)*1.42094","v":0},{"$f":"(((+$C$13*0.01)*C$23)+$D$13)*1.42094","v":0},0,0,0,0,0]
["Maximum Working Pressure (metres head)",11,8,6,4.5,3.5,2.2999999999999998,1.4]
["Maximum Working Pressure (feet head)",{"$f":"B29*3.281","v":36.091000000000001},{"$f":"C29*3.281","v":26.248000000000001},19.686,14.7645,11.483500000000001,7.5462999999999996,4.5933999999999999]
["Maximum Working Pressure (psi)",{"$f":"B29*1.42094","v":15.63034},{"$f":"C29*1.42094","v":11.367520000000001},8.525640000000001,6.3942300000000003,4.9732900000000004,3.2681619999999998,1.9893160000000001]
["Allowable Fluming Size?",{"$f":"IF(+B26<=B29,\"  YES\",\"   NO\")","v":"  YES"},"  YES","  YES","  YES","  YES","  YES","  YES"]
[]
["Note: when using outlets the maximum head pressure regardless of Flexiflume diameter being used is 1.4m"]

{"sheet":"Pumpline","index":1,"n_rows":32,"n_cols":11,"rows_kept":32,"cut":false,"hidden":false,"merged":[[5,4,5,7],[8,1,8,3],[7,5,7,7],[1,4,1,7],[2,4,2,7],[3,4,3,7],[4,4,4,7]]}
[]
[null,null,null,null,"Free Call: 1800 115 440"]
[null,null,null,null,"land line: 03 5339 3103"]
[null,null,null,null,"International: +61 3 5339 3103"]
[null,null,null,null,"info@bartlett.net.au"]
[null,null,null,null,"www.bartlett.net.au"]
["Pumpline Friction Loss Calculator"]
[null,null,null,null,null,"Converted Inputs"]
[null,"Calculation Inputs",null,null,null,"Flow","Distance","Stat.Hd."]
["Static Head:- Difference in Altitude between","Flow","Distance","Static",null,"US gpm","feet","feet"]
["Lowest & Highest points of the line","in","in","Head",null,{"$f":"B13/3.7854*60","v":0},{"$f":"C13*3.281","v":0},{"$f":"D13*3.281","v":0}]
[null,"L/Sec","Metres","Metres",null,"UK gmp","yards","psi"]
[null,0,0,0,null,{"$f":"B13/4.5461*60","v":0},{"$f":"G11/3","v":0},{"$f":"D13*1.42094","v":0}]
[null,null,null,null,null,"CuSec","chains","Kpa"]
[null,null,null,null,null,{"$f":"F11*0.00222801","v":0},{"$f":"C13/20.11684","v":0},{"$f":"D13*9.806","v":0}]
[null,null,null,null,null,"ML/day"]
[null,null,null,null,null,{"$f":"(+B13*60*60*24)/1000000","v":0}]
[]
["Calculation Results"]
["Fluming Nominal Diameter (inches)","3\"","5\"","7\"","9\"","11\"","13\"","16\"","19\"","24\"","30\""]
["Fluming Actual Diameter (inches)",3.3860000000000001,5.2750000000000004,7.2,9.1,11.02,12.9,16.73,{"$f":"I22/25.4","v":19.7244094488189},{"$f":"J22/25.4","v":25.039370078740159},{"$f":"K22/25.4","v":30.629921259842522}]
["Fluming Actual Diameter (millimetres)",86,134,183,231,280,328,425,501,636,778]
["Friction Loss per 100m (metres head)",{"$f":"((((3350000)*$B$13))/((B$22^2.63)*149))^1.852","v":0},0,0,0,0,0,0,0,0,0]
["Friction Loss per 100 feet (Feet head )",{"$f":"B23","v":0},0,0,0,0,0,0,{"$f":"I23","v":0},{"$f":"J23","v":0},{"$f":"K23","v":0}]
["Friction Loss per 100 feet (psi )",{"$f":"B23*1.42094/3.281","v":0},0,0,0,0,0,0,{"$f":"I23*1.42094/3.281","v":0},{"$f":"J23*1.42094/3.281","v":0},{"$f":"K23*1.42094/3.281","v":0}]
["Total Friction Loss + Static Head (metres head)",{"$f":"((+$C$13*0.01)*B$23)+$D$13","v":0},{"$f":"((+$C$13*0.01)*C23)+$D$13","v":0},0,0,0,0,0,{"$f":"((+$C$13*0.01)*I23)+$D$13","v":0},{"$f":"((+$C$13*0.01)*J23)+$D$13","v":0},{"$f":"((+$C$13*0.01)*K23)+$D$13","v":0}]
["Total Friction Loss + Static Head (feet head)",{"$f":"(((+$C$13*0.01)*B$23)+$D$13)*3.281","v":0},0,0,0,0,0,0,0,0,0]
["Total Friction Loss + Static Head (psi)",{"$f":"(((+$C$13*0.01)*B$23)+$D$13)*1.42094","v":0},0,0,0,0,0,0,0,0,0]
["Maximum Working Pressure (metres head)",33,21,15.5,12,10,8.5,6.5,5.5,4.5,3.5]
["Maximum Working Pressure (feet head)",{"$f":"B29*3.281","v":108.27300000000001},68.900999999999996,50.855499999999999,39.372,32.81,27.888500000000001,21.326499999999999,{"$f":"I29*3.281","v":18.045500000000001},{"$f":"J29*3.281","v":14.7645},{"$f":"K29*3.281","v":11.483500000000001}]
["Maximum Working Pressure (psi)",{"$f":"B29*1.42094","v":46.891020000000005},29.839740000000003,22.024570000000001,17.051280000000002,14.2094,12.077990000000002,9.23611,{"$f":"I29*1.42094","v":7.8151700000000002},{"$f":"J29*1.42094","v":6.3942300000000003},{"$f":"K29*1.42094","v":4.9732900000000004}]
["Allowable Fluming Size?",{"$f":"IF(+B26<=B29,\"  YES\",\"   NO\")","v":"  YES"},"  YES","  YES","  YES","  YES","  YES","  YES","  YES","  YES","  YES"]