{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Cover Page","BHS - Manual Balancing Valve","BHS - Pressure Independent","Copyright","Language","Information Boxes","Units","Data"],"not_rendered":{"charts":0,"images":24,"macros":1,"external_links":0,"defined_names":1,"comments":1,"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":"row_number_cap","date_system":"1900"}

{"sheet":"Cover Page","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[[11,3,11,5],[12,4,12,5]]}

{"sheet":"BHS - Manual Balancing Valve","index":1,"n_rows":50,"n_cols":27,"rows_kept":50,"cut":false,"hidden":true,"merged":[[11,1,11,3],[16,1,16,3],[1,1,3,10],[37,20,37,21],[37,24,37,25],[25,20,25,21],[26,20,26,21],[25,24,25,25],[26,24,26,25],[26,16,26,17],[35,20,35,21],[36,20,36,21],[8,12,8,13],[9,12,9,13],[10,12,10,13],[9,16,9,17],[27,16,27,17],[28,16,28,17],[38,12,38,13],[38,16,38,17],[38,20,38,21],[38,24,38,25],[37,12,37,13],[37,16,37,17],[35,16,35,17],[36,16,36,17],[36,24,36,25],[25,12,25,13],[26,12,26,13],[35,12,35,13],[36,12,36,13],[27,12,27,13],[28,12,28,13],[9,24,9,25],[10,24,10,25],[19,12,19,13],[18,12,18,13],[17,16,17,17],[10,16,10,17],[18,16,18,17],[19,16,19,17],[6,1,6,3],[8,2,8,3],[10,20,10,21],[9,20,9,21],[35,24,35,25],[27,20,27,21],[28,20,28,21],[27,24,27,25],[28,24,28,25],[18,20,18,21],[19,20,19,21],[19,24,19,25],[18,24,18,25],[12,1,12,3],[15,1,15,3],[25,16,25,17]]}
[]
[null,"Belimo Hydronic Simulator™"]
[]
[]
[]
[]
[null,{"$f":"INDEX(Language!$6:$6,MATCH(Language!$H$2,Language!$1:$1,0))","v":"Design Settings"}]
[null,{"$f":"INDEX(Language!$7:$7,MATCH(Language!$H$2,Language!$1:$1,0))","v":"Flow per coil"},{"$f":"Data!B15","v":0.9},{"$f":"Data!B14","v":"GPM"},null,null,null,{"$f":"Data!Y29","v":"5.07 GPM"}]
[null,{"$f":"INDEX(Language!$8:$8,MATCH(Language!$H$2,Language!$1:$1,0))","v":"Delta P Units"},{"$f":"Units!S14","v":"kPa"},null,null,null,null,{"$f":"ROUND(Data!AB29/100,2)","v":1.1299999999999999},null,null,{"$f":"Data!Y25","v":6.2700000000000005},null,null,null,{"$f":"Data!Y20","v":3.96},null,null,null,{"$f":"Data!Y15","v":4.16},null,null,null,{"$f":"Data!Y10","v":3.58},null,null,null,{"$f":"Data!Y5","v":1.79}]
[null,null,null,null,null,null,null,{"$f":"Data!V27","v":"3.81 kPa"},null,{"$f":"Data!AB23","v":"1.31 GPM"},{"$f":"Units!$S$14","v":"kPa"},null,{"$f":"Data!AB18","v":"1.04 GPM"},null,{"$f":"Units!$S$14","v":"kPa"},null,{"$f":"Data!AB13","v":"1.06 GPM"},null,{"$f":"Units!$S$14","v":"kPa"},null,{"$f":"Data!AB8","v":"0.98 GPM"},null,{"$f":"Units!$S$14","v":"kPa"},null,{"$f":"Data!AB3","v":"0.7 GPM"},null,{"$f":"Units!$S$14","v":"kPa"}]
[{"$f":"Data!D14","v":""},"Delta P",3,{"$f":"Data!C14","v":"kPa"},null,null,null,{"$f":"Data!Z27","v":4.0000000000001004},null,{"$f":"ROUND(Data!AB24/100,2)","v":1.44},null,null,{"$f":"ROUND(Data!AB19/100,2)","v":1.1499999999999999},{"$f":"ROUND(Data!AF24/100,2)","v":4},null,null,{"$f":"ROUND(Data!AB14/100,2)","v":1.18},{"$f":"ROUND(Data!AJ24/100,2)","v":0.04},null,null,{"$f":"ROUND(Data!AB9/100,2)","v":1.0900000000000001},{"$f":"ROUND(Data!AN24/100,2)","v":7.0000000000000007E-2},null,null,{"$f":"ROUND(Data!AB4/100,2)","v":0.77},{"$f":"ROUND(Data!AR24/100,2)","v":0.03}]
[null,{"$f":"INDEX(Language!$9:$9,MATCH(Language!$H$2,Language!$1:$1,0))","v":"Pumping Costs"},null,null,null,null,null,null,null,null,{"$f":"INDEX(Language!$14:$14,MATCH(Language!$H$2,Language!$1:$1,0))","v":"Turns"},null,null,null,{"$f":"INDEX(Language!$14:$14,MATCH(Language!$H$2,Language!$1:$1,0))","v":"Turns"},null,null,null,{"$f":"INDEX(Language!$14:$14,MATCH(Language!$H$2,Language!$1:$1,0))","v":"Turns"},null,null,null,{"$f":"INDEX(Language!$14:$14,MATCH(Language!$H$2,Language!$1:$1,0))","v":"Turns"},null,null,null,{"$f":"INDEX(Language!$14:$14,MATCH(Language!$H$2,Language!$1:$1,0))","v":"Turns"}]
[null,{"$f":"ROUND(Data!B20,0)&\"%\"","v":"614%"},null,null,null,null,null,null,null,null,{"$f":"Data!Z22","v":4.0000000000001004},null,null,null,{"$f":"Data!Z17","v":4.0000000000001004},null,null,null,{"$f":"Data!Z12","v":4.0000000000001004},null,null,null,{"$f":"Data!Z7","v":4.0000000000001004},null,null,null,{"$f":"Data!Z2","v":4.0000000000001004}]
[]
[null,"Position",{"$f":"Data!D15","v":3.998046875},"turns"]
[null,{"$f":"INDEX(Language!$10:$10,MATCH(Language!$H$2,Language!$1:$1,0))","v":"Pump Head"}]
[null,{"$f":"Data!B26","v":"300 kPa"},null,null,null,null,null,{"$f":"Data!S29","v":"6.7 GPM"}]
[null,null,null,null,null,null,null,{"$f":"ROUND(Data!V29/100,2)","v":1.49},null,null,{"$f":"Data!S25","v":10.3},null,null,null,{"$f":"Data!S20","v":6.99},null,null,null,{"$f":"Data!S15","v":6.54},null,null,null,{"$f":"Data!S10","v":6.1000000000000005},null,null,null,{"$f":"Data!S5","v":4.07}]
[null,null,null,null,null,null,null,{"$f":"Data!P27","v":"6.64 kPa"},null,{"$f":"Data!V23","v":"1.66 GPM"},{"$f":"Units!$S$14","v":"kPa"},null,{"$f":"Data!V18","v":"1.38 GPM"},null,{"$f":"Units!$S$14","v":"kPa"},null,{"$f":"Data!V13","v":"1.33 GPM"},null,{"$f":"Units!$S$14","v":"kPa"},null,{"$f":"Data!V8","v":"1.29 GPM"},null,{"$f":"Units!$S$14","v":"kPa"},null,{"$f":"Data!V3","v":"1.05 GPM"},null,{"$f":"Units!$S$14","v":"kPa"}]
[null,null,null,null,null,null,null,{"$f":"Data!T27","v":4.0000000000001004},null,{"$f":"ROUND(Data!V24/100,2)","v":1.84},null,null,{"$f":"ROUND(Data!V19/100,2)","v":1.53},{"$f":"ROUND(Data!Z24/100,2)","v":0},null,null,{"$f":"ROUND(Data!V14/100,2)","v":1.48},{"$f":"ROUND(Data!AD24/100,2)","v":0},null,null,{"$f":"ROUND(Data!V9/100,2)","v":1.43},{"$f":"ROUND(Data!AH24/100,2)","v":0},null,null,{"$f":"ROUND(Data!V4/100,2)","v":1.1599999999999999},{"$f":"ROUND(Data!AL24/100,2)","v":0.01}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(Language!$14:$14,MATCH(Language!$H$2,Language!$1:$1,0))","v":"Turns"},null,null,null,{"$f":"INDEX(Language!$14:$14,MATCH(Language!$H$2,Language!$1:$1,0))","v":"Turns"},null,null,null,{"$f":"INDEX(Language!$14:$14,MATCH(Language!$H$2,Language!$1:$1,0))","v":"Turns"},null,null,null,{"$f":"INDEX(Language!$14:$14,MATCH(Language!$H$2,Language!$1:$1,0))","v":"Turns"},null,null,null,{"$f":"INDEX(Language!$14:$14,MATCH(Language!$H$2,Language!$1:$1,0))","v":"Turns"}]
[null,{"$f":"J28","v":"1.87 GPM"},null,{"$f":"K27","v":12.9},null,null,null,null,null,null,{"$f":"Data!T22","v":4.0000000000001004},null,null,null,{"$f":"Data!T17","v":4.0000000000001004},null,null,null,{"$f":"Data!T12","v":4.0000000000001004},null,null,null,{"$f":"Data!T7","v":4.0000000000001004},null,null,null,{"$f":"Data!T2","v":4.0000000000001004}]
[null,{"$f":"J29","v":2.0699999999999998},null,{"$f":"K28","v":"kPa"}]
[null,null,null,{"$f":"K30","v":"Turns"}]
[null,null,null,{"$f":"K31","v":4.0000000000001004}]
[null,null,null,null,null,null,null,{"$f":"Data!M29","v":"8.01 GPM"}]
[null,null,null,null,null,null,null,{"$f":"ROUND(Data!P29/100,2)","v":1.78},null,null,{"$f":"Data!M25","v":12.9},null,null,null,{"$f":"Data!M20","v":12.4},null,null,null,{"$f":"Data!M15","v":12.100000000000001},null,null,null,{"$f":"Data!M10","v":5.63},null,null,null,{"$f":"Data!M5","v":6.04}]
[null,null,null,null,null,null,null,{"$f":"Data!J27","v":"9.49 kPa"},null,{"$f":"Data!P23","v":"1.87 GPM"},{"$f":"Units!$S$14","v":"kPa"},null,{"$f":"Data!P18","v":"1.83 GPM"},null,{"$f":"Units!$S$14","v":"kPa"},null,{"$f":"Data!P13","v":"1.81 GPM"},null,{"$f":"Units!$S$14","v":"kPa"},null,{"$f":"Data!P8","v":"1.24 GPM"},null,{"$f":"Units!$S$14","v":"kPa"},null,{"$f":"Data!P3","v":"1.28 GPM"},null,{"$f":"Units!$S$14","v":"kPa"}]
[null,null,null,null,null,null,null,{"$f":"Data!N27","v":4.0000000000001004},null,{"$f":"ROUND(Data!P24/100,2)","v":2.0699999999999998},null,null,{"$f":"ROUND(Data!P19/100,2)","v":2.0299999999999998},{"$f":"ROUND(Data!T24/100,2)","v":0},null,null,{"$f":"ROUND(Data!P14/100,2)","v":2},{"$f":"ROUND(Data!X24/100,2)","v":0},null,null,{"$f":"ROUND(Data!P9/100,2)","v":1.37},{"$f":"ROUND(Data!AB24/100,2)","v":1.44},null,null,{"$f":"ROUND(Data!P4/100,2)","v":1.42},{"$f":"ROUND(Data!AF24/100,2)","v":4}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(Language!$14:$14,MATCH(Language!$H$2,Language!$1:$1,0))","v":"Turns"},null,null,null,{"$f":"INDEX(Language!$14:$14,MATCH(Language!$H$2,Language!$1:$1,0))","v":"Turns"},null,null,null,{"$f":"INDEX(Language!$14:$14,MATCH(Language!$H$2,Language!$1:$1,0))","v":"Turns"},null,null,null,{"$f":"INDEX(Language!$14:$14,MATCH(Language!$H$2,Language!$1:$1,0))","v":"Turns"},null,null,null,{"$f":"INDEX(Language!$14:$14,MATCH(Language!$H$2,Language!$1:$1,0))","v":"Turns"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"Data!N22","v":4.0000000000001004},null,null,null,{"$f":"Data!N17","v":4.0000000000001004},null,null,null,{"$f":"Data!N12","v":4.0000000000001004},null,null,null,{"$f":"Data!N7","v":4.0000000000001004},null,null,null,{"$f":"Data!N2","v":4.0000000000001004}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"Data!G29","v":"10.1 GPM"}]
[null,null,null,null,null,null,null,{"$f":"ROUND(Data!J29/100,2)","v":2.23},null,null,{"$f":"Data!G25","v":19.900000000000002},null,null,null,{"$f":"Data!G20","v":18.900000000000002},null,null,null,{"$f":"Data!G15","v":14.100000000000001},null,null,null,{"$f":"Data!G10","v":12.9},null,null,null,{"$f":"Data!G5","v":10.4}]
[null,null,null,null,null,null,null,{"$f":"Data!D27","v":"15 kPa"},null,{"$f":"Data!J23","v":"2.32 GPM"},{"$f":"Units!$S$14","v":"kPa"},null,{"$f":"Data!J18","v":"2.26 GPM"},null,{"$f":"Units!$S$14","v":"kPa"},null,{"$f":"Data!J13","v":"1.95 GPM"},null,{"$f":"Units!$S$14","v":"kPa"},null,{"$f":"Data!J8","v":"1.87 GPM"},null,{"$f":"Units!$S$14","v":"kPa"},null,{"$f":"Data!J3","v":"1.67 GPM"},null,{"$f":"Units!$S$14","v":"kPa"}]
[null,null,null,null,null,null,null,{"$f":"Data!H27","v":4.0000000000001004},null,{"$f":"ROUND(Data!J24/100,2)","v":2.57},null,null,{"$f":"ROUND(Data!J19/100,2)","v":2.5099999999999998},{"$f":"ROUND(Data!N24/100,2)","v":0},null,null,{"$f":"ROUND(Data!J14/100,2)","v":2.16},{"$f":"ROUND(Data!R24/100,2)","v":0},null,null,{"$f":"ROUND(Data!J9/100,2)","v":2.0699999999999998},{"$f":"ROUND(Data!V24/100,2)","v":1.84},null,null,{"$f":"ROUND(Data!J4/100,2)","v":1.85},{"$f":"ROUND(Data!Z24/100,2)","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(Language!$14:$14,MATCH(Language!$H$2,Language!$1:$1,0))","v":"Turns"},null,null,null,{"$f":"INDEX(Language!$14:$14,MATCH(Language!$H$2,Language!$1:$1,0))","v":"Turns"},null,null,null,{"$f":"INDEX(Language!$14:$14,MATCH(Language!$H$2,Language!$1:$1,0))","v":"Turns"},null,null,null,{"$f":"INDEX(Language!$14:$14,MATCH(Language!$H$2,Language!$1:$1,0))","v":"Turns"},null,null,null,{"$f":"INDEX(Language!$14:$14,MATCH(Language!$H$2,Language!$1:$1,0))","v":"Turns"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"Data!H22","v":4.0000000000001004},null,null,null,{"$f":"Data!H17","v":4.0000000000001004},null,null,null,{"$f":"Data!H12","v":4.0000000000001004},null,null,null,{"$f":"Data!H7","v":4.0000000000001004},null,null,null,{"$f":"Data!H2","v":4.0000000000001004}]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"Data!B33","v":"29.9 GPM"}]
[null,null,null,null,null,null,null,{"$f":"ROUND(Data!B34/100,2)","v":1.66}]
[null,null,null,null,null,null,null,{"$f":"Data!D32","v":"8.24 kPa"}]
[null,null,null,null,null,null,null,{"$f":"Data!E29","v":4.0000010000000001}]

{"sheet":"BHS - Pressure Independent","index":2,"n_rows":50,"n_cols":27,"rows_kept":50,"cut":false,"hidden":true,"merged":[[1,1,3,10],[8,12,8,13],[9,12,9,13],[6,1,6,3],[8,2,8,3],[9,20,9,21],[9,24,9,25],[10,12,10,13],[10,16,10,17],[10,20,10,21],[10,24,10,25],[9,16,9,17],[18,20,18,21],[18,24,18,25],[25,12,25,13],[25,16,25,17],[25,20,25,21],[25,24,25,25],[19,12,19,13],[19,16,19,17],[19,20,19,21],[19,24,19,25],[11,1,11,3],[12,1,12,3],[17,16,17,17],[18,12,18,13],[18,16,18,17],[15,1,15,3],[16,1,16,3],[27,12,27,13],[27,16,27,17],[27,20,27,21],[27,24,27,25],[26,12,26,13],[26,16,26,17],[26,20,26,21],[26,24,26,25],[28,12,28,13],[28,16,28,17],[28,20,28,21],[28,24,28,25],[35,12,35,13],[35,16,35,17],[35,20,35,21],[35,24,35,25],[38,12,38,13],[38,16,38,17],[38,20,38,21],[38,24,38,25],[36,12,36,13],[36,16,36,17],[36,20,36,21],[36,24,36,25],[37,12,37,13],[37,16,37,17],[37,20,37,21],[37,24,37,25]],"read":"row_number_cap"}
[]
[null,"Belimo Hydronic Simulator™"]
[]
[]
[]
[]
[null,{"$f":"INDEX(Language!$6:$6,MATCH(Language!$H$2,Language!$1:$1,0))","v":"Design Settings"}]
[null,{"$f":"INDEX(Language!$7:$7,MATCH(Language!$H$2,Language!$1:$1,0))","v":"Flow per coil"},{"$f":"Data!B15","v":0.9},{"$f":"Data!B14","v":"GPM"},null,null,null,{"$f":"Data!Y30","v":"5.09 GPM"}]
[null,{"$f":"INDEX(Language!$8:$8,MATCH(Language!$H$2,Language!$1:$1,0))","v":"Delta P Units"},{"$f":"Units!S14","v":"kPa"},null,null,null,null,{"$f":"ROUND(Data!DU32/Units!$Z$13/5,2)","v":1.1299999999999999},null,null,{"$f":"Data!Y25","v":6.2700000000000005},null,null,null,{"$f":"Data!Y20","v":3.96},null,null,null,{"$f":"Data!Y15","v":4.16},null,null,null,{"$f":"Data!Y10","v":3.58},null,null,null,{"$f":"Data!Y5","v":1.79}]
[null,null,null,null,null,null,null,{"$f":"Data!V27","v":"3.81 kPa"},null,{"$f":"Data!AB23","v":"1.31 GPM"},{"$f":"Units!$S$14","v":"kPa"},null,{"$f":"IF(O9>=Units!$F$38,IF(Data!Y20>3,IF(OR(AND(Data!DU21<(C8-2%),Data!DU21>0.001),Data!DU21>(C8+2%)),C8&\" \"&Units!R14,Data!AB18),Data!AB18),Data!AB18)","v":"1.04 GPM"},null,{"$f":"Units!$S$14","v":"kPa"},null,{"$f":"Data!AB13","v":"1.06 GPM"},null,{"$f":"Units!$S$14","v":"kPa"},null,{"$f":"Data!AB8","v":"0.98 GPM"},null,{"$f":"Units!$S$14","v":"kPa"},null,{"$f":"Data!AB3","v":"0.7 GPM"},null,{"$f":"Units!$S$14","v":"kPa"}]
[{"$f":"Data!D14","v":""},"Delta P",3,{"$f":"Data!C14","v":"kPa"},null,null,null,{"$f":"Data!Z27","v":4.0000000000001004},null,{"$f":"ROUND(Data!AB24/100,2)","v":1.44},null,null,{"$f":"IF(O9>=Units!$F$38,IF(AND(Data!Y20>3,Data!Y20>0.1),ROUND(IF(OR(AND(Data!DW19<97.9,Data!DW19>1),Data!DW19>102.5),\"100\",Data!AB19)/100,2),ROUND(Data!AB19/100,2)),'BHS - Manual Balancing Valve'!M11:N11)","v":1.1499999999999999},{"$f":"ROUND(Data!AF24/100,2)","v":4},null,null,{"$f":"ROUND(Data!AB14/100,2)","v":1.18},{"$f":"ROUND(Data!AJ24/100,2)","v":0.04},null,null,{"$f":"ROUND(Data!AB9/100,2)","v":1.0900000000000001},{"$f":"ROUND(Data!AN24/100,2)","v":7.0000000000000007E-2},null,null,{"$f":"ROUND(Data!AB4/100,2)","v":0.77},{"$f":"ROUND(Data!AR24/100,2)","v":0.03}]
[null,{"$f":"INDEX(Language!$9:$9,MATCH(Language!$H$2,Language!$1:$1,0))","v":"Pumping Costs"},null,null,null,null,null,null,null,null,{"$f":"INDEX(Language!$14:$14,MATCH(Language!$H$2,Language!$1:$1,0))","v":"Turns"},null,null,null,"Clip",null,null,null,{"$f":"INDEX(Language!$14:$14,MATCH(Language!$H$2,Language!$1:$1,0))","v":"Turns"},null,null,null,{"$f":"INDEX(Language!$14:$14,MATCH(Language!$H$2,Language!$1:$1,0))","v":"Turns"},null,null,null,{"$f":"INDEX(Language!$14:$14,MATCH(Language!$H$2,Language!$1:$1,0))","v":"Turns"}]
[null,{"$f":"ROUND(Data!B20,0)&\"%\"","v":"614%"},null,null,null,null,null,null,null,null,{"$f":"Data!Z22","v":4.0000000000001004},null,null,null,{"$f":"INDEX(Units!$G$30:$G$35,MATCH(Units!$Y$13,INDEX(Units!$C$30:$F$35,,Units!$R$9),0))","v":"No Clip"},null,null,null,{"$f":"Data!Z12","v":4.0000000000001004},null,null,null,{"$f":"Data!Z7","v":4.0000000000001004},null,null,null,{"$f":"Data!Z2","v":4.0000000000001004}]
[]
[null,"Position",{"$f":"Data!D15","v":3.998046875},"turns"]
[null,{"$f":"INDEX(Language!$10:$10,MATCH(Language!$H$2,Language!$1:$1,0))","v":"Pump Head"}]
[null,{"$f":"Data!B26","v":"300 kPa"},null,null,null,null,null,{"$f":"Data!S30","v":"6.71 GPM"}]
[null,null,null,null,null,null,null,{"$f":"ROUND(Data!CU32/Units!$Z$13/5,2)","v":1.49},null,null,{"$f":"Data!S25","v":10.3},null,null,null,{"$f":"Data!S20","v":6.99},null,null,null,{"$f":"Data!S15","v":6.54},null,null,null,{"$f":"Data!S10","v":6.1000000000000005},null,null,null,{"$f":"Data!S5","v":4.07}]
[null,null,null,null,null,null,null,{"$f":"Data!P27","v":"6.64 kPa"},null,{"$f":"Data!V23","v":"1.66 GPM"},{"$f":"Units!$S$14","v":"kPa"},null,{"$f":"Data!V18","v":"1.38 GPM"},null,{"$f":"Units!$S$14","v":"kPa"},null,{"$f":"Data!V13","v":"1.33 GPM"},null,{"$f":"Units!$S$14","v":"kPa"},null,{"$f":"IF(W18>=Units!$F$38,IF(Data!S10>3,IF(OR(AND(Data!CU11<(C8-2%),Data!CU11>0.001),Data!CU11>(C8+2%)),C8&\" \"&Units!R14,Data!V8),Data!V8),'BHS - Manual Balancing Valve'!U19:V19)","v":"1.29 GPM"},null,{"$f":"Units!$S$14","v":"kPa"},null,{"$f":"Data!V3","v":"1.05 GPM"},null,{"$f":"Units!$S$14","v":"kPa"}]
[null,null,null,null,null,null,null,{"$f":"Data!T27","v":4.0000000000001004},null,{"$f":"ROUND(Data!V24/100,2)","v":1.84},null,null,{"$f":"ROUND(Data!V19/100,2)","v":1.53},{"$f":"ROUND(Data!Z24/100,2)","v":0},null,null,{"$f":"ROUND(Data!V14/100,2)","v":1.48},{"$f":"ROUND(Data!AD24/100,2)","v":0},null,null,{"$f":"IF(W18>=Units!$F$38,IF(AND(Data!S10>3,Data!S10>0.1),ROUND(IF(OR(AND(Data!CW9<97.9,Data!CW9>1),Data!CW9>102.5),\"100\",Data!V9)/100,2),ROUND(Data!V9/100,2)),'BHS - Manual Balancing Valve'!U20:V20)","v":1.43},{"$f":"ROUND(Data!AH24/100,2)","v":0},null,null,{"$f":"ROUND(Data!V4/100,2)","v":1.1599999999999999},{"$f":"ROUND(Data!AL24/100,2)","v":0.01}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(Language!$14:$14,MATCH(Language!$H$2,Language!$1:$1,0))","v":"Turns"},null,null,null,{"$f":"INDEX(Language!$14:$14,MATCH(Language!$H$2,Language!$1:$1,0))","v":"Turns"},null,null,null,{"$f":"INDEX(Language!$14:$14,MATCH(Language!$H$2,Language!$1:$1,0))","v":"Turns"},null,null,null,"Clip",null,null,null,{"$f":"INDEX(Language!$14:$14,MATCH(Language!$H$2,Language!$1:$1,0))","v":"Turns"}]
[null,{"$f":"J28","v":"1.87 GPM"},null,{"$f":"K27","v":12.9},null,null,null,null,null,null,{"$f":"Data!T22","v":4.0000000000001004},null,null,null,{"$f":"Data!T17","v":4.0000000000001004},null,null,null,{"$f":"Data!T12","v":4.0000000000001004},null,null,null,{"$f":"INDEX(Units!$G$30:$G$35,MATCH(Units!$Y$13,INDEX(Units!$C$30:$F$35,,Units!$R$9),0))","v":"No Clip"},null,null,null,{"$f":"Data!T2","v":4.0000000000001004}]
[null,{"$f":"J29","v":2.0699999999999998},null,{"$f":"K28","v":"kPa"}]
[null,null,null,{"$f":"K40","v":"Turns"}]
[null,null,null,{"$f":"K41","v":4.0000000000001004}]
[null,null,null,null,null,null,null,{"$f":"Data!M30","v":"8.03 GPM"}]
[null,null,null,null,null,null,null,{"$f":"ROUND(Data!BU32/Units!$Z$13/5,2)","v":1.78},null,null,{"$f":"Data!M25","v":12.9},null,null,null,{"$f":"Data!M20","v":12.4},null,null,null,{"$f":"Data!M15","v":12.100000000000001},null,null,null,{"$f":"Data!M10","v":5.63},null,null,null,{"$f":"Data!M5","v":6.04}]
[null,null,null,null,null,null,null,{"$f":"Data!J27","v":"9.49 kPa"},null,{"$f":"IF(K27>=Units!$F$38,IF(Data!M25>3,IF(OR(AND(Data!BU26<(C8-2%),Data!BU26>0.001),Data!BU26>(C8+2%)),C8&\" \"&Units!R14,Data!P23),Data!P23),'BHS - Manual Balancing Valve'!J28)","v":"1.87 GPM"},{"$f":"Units!$S$14","v":"kPa"},null,{"$f":"Data!P18","v":"1.83 GPM"},null,{"$f":"Units!$S$14","v":"kPa"},null,{"$f":"Data!P13","v":"1.81 GPM"},null,{"$f":"Units!$S$14","v":"kPa"},null,{"$f":"Data!P8","v":"1.24 GPM"},null,{"$f":"Units!$S$14","v":"kPa"},null,{"$f":"IF(AA27>=Units!$F$38,IF(Data!M5>3,IF(OR(AND(Data!BU6<(C8-2%),Data!BU6>0.001),Data!BU6>(C8+2%)),C8&\" \"&Units!R14,Data!P3),Data!P3),'BHS - Manual Balancing Valve'!Y28:Z28)","v":"1.28 GPM"},null,{"$f":"Units!$S$14","v":"kPa"}]
[null,null,null,null,null,null,null,{"$f":"Data!N27","v":4.0000000000001004},null,{"$f":"IF(K27>=Units!$F$38,IF(AND(Data!M25>3,Data!M25>0.1),ROUND(IF(OR(AND(Data!BW24<97.9,Data!BW24>1),Data!BW24>102.5),\"100\",Data!P24)/100,2),ROUND(Data!P24/100,2)),'BHS - Manual Balancing Valve'!J29)","v":2.0699999999999998},null,null,{"$f":"ROUND(Data!P19/100,2)","v":2.0299999999999998},{"$f":"ROUND(Data!T24/100,2)","v":0},null,null,{"$f":"ROUND(Data!P14/100,2)","v":2},{"$f":"ROUND(Data!X24/100,2)","v":0},null,null,{"$f":"ROUND(Data!P9/100,2)","v":1.37},{"$f":"ROUND(Data!AB24/100,2)","v":1.44},null,null,{"$f":"IF(AA27>=Units!$F$38,IF(AND(Data!M5>3,Data!M5>0.1),ROUND(IF(OR(AND(Data!BW4<97.9,Data!BW4>1),Data!BW4>102.5),\"100\",Data!P4)/100,2),ROUND(Data!P4/100,2)),'BHS - Manual Balancing Valve'!Y29:Z29)","v":1.42},{"$f":"ROUND(Data!AF24/100,2)","v":4}]
[null,null,null,null,null,null,null,null,null,null,"Clip",null,null,null,{"$f":"INDEX(Language!$14:$14,MATCH(Language!$H$2,Language!$1:$1,0))","v":"Turns"},null,null,null,{"$f":"INDEX(Language!$14:$14,MATCH(Language!$H$2,Language!$1:$1,0))","v":"Turns"},null,null,null,{"$f":"INDEX(Language!$14:$14,MATCH(Language!$H$2,Language!$1:$1,0))","v":"Turns"},null,null,null,"Clip"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(Units!$G$30:$G$35,MATCH(Units!$Y$13,INDEX(Units!$C$30:$F$35,,Units!$R$9),0))","v":"No Clip"},null,null,null,{"$f":"Data!N17","v":4.0000000000001004},null,null,null,{"$f":"Data!N12","v":4.0000000000001004},null,null,null,{"$f":"Data!N7","v":4.0000000000001004},null,null,null,{"$f":"INDEX(Units!$G$30:$G$35,MATCH(Units!$Y$13,INDEX(Units!$C$30:$F$35,,Units!$R$9),0))","v":"No Clip"}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"Data!G30","v":"10.07 GPM"}]
[null,null,null,null,null,null,null,{"$f":"ROUND(Data!AU49/Units!$Z$13/5,2)","v":2.2400000000000002},null,null,{"$f":"Data!G25","v":19.900000000000002},null,null,null,{"$f":"Data!G20","v":18.900000000000002},null,null,null,{"$f":"Data!G15","v":14.100000000000001},null,null,null,{"$f":"Data!G10","v":12.9},null,null,null,{"$f":"Data!G5","v":10.4}]
[null,null,null,null,null,null,null,{"$f":"Data!D27","v":"15 kPa"},null,{"$f":"Data!J23","v":"2.32 GPM"},{"$f":"Units!$S$14","v":"kPa"},null,{"$f":"Data!J18","v":"2.26 GPM"},null,{"$f":"Units!$S$14","v":"kPa"},null,{"$f":"IF(S37>=Units!$F$38,IF(Data!G15>3,IF(OR(AND(Data!AU16<(C8-2%),Data!AU16>0.001),Data!AU16>(C8+2%)),C8&\" \"&Units!R14,Data!J13),Data!J13),'BHS - Manual Balancing Valve'!Q38:R38)","v":"1.95 GPM"},null,{"$f":"Units!$S$14","v":"kPa"},null,{"$f":"Data!J8","v":"1.87 GPM"},null,{"$f":"Units!$S$14","v":"kPa"},null,{"$f":"Data!J3","v":"1.67 GPM"},null,{"$f":"Units!$S$14","v":"kPa"}]
[null,null,null,null,null,null,null,{"$f":"Data!H27","v":4.0000000000001004},null,{"$f":"ROUND(Data!J24/100,2)","v":2.57},null,null,{"$f":"ROUND(Data!J19/100,2)","v":2.5099999999999998},{"$f":"ROUND(Data!N24/100,2)","v":0},null,null,{"$f":"IF(S37>=Units!$F$38,IF(AND(Data!G15>3,Data!G15>0.1),ROUND(IF(OR(AND(Data!AW14<97.9,Data!AW14>1),Data!AW14>102.5),\"100\",Data!J14)/100,2),ROUND(Data!J14/100,2)),'BHS - Manual Balancing Valve'!Q39:R39)","v":2.16},{"$f":"ROUND(Data!R24/100,2)","v":0},null,null,{"$f":"ROUND(Data!J9/100,2)","v":2.0699999999999998},{"$f":"ROUND(Data!V24/100,2)","v":1.84},null,null,{"$f":"ROUND(Data!J4/100,2)","v":1.85},{"$f":"ROUND(Data!Z24/100,2)","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(Language!$14:$14,MATCH(Language!$H$2,Language!$1:$1,0))","v":"Turns"},null,null,null,{"$f":"INDEX(Language!$14:$14,MATCH(Language!$H$2,Language!$1:$1,0))","v":"Turns"},null,null,null,"Clip",null,null,null,{"$f":"INDEX(Language!$14:$14,MATCH(Language!$H$2,Language!$1:$1,0))","v":"Turns"},null,null,null,{"$f":"INDEX(Language!$14:$14,MATCH(Language!$H$2,Language!$1:$1,0))","v":"Turns"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"Data!H22","v":4.0000000000001004},null,null,null,{"$f":"Data!H17","v":4.0000000000001004},null,null,null,{"$f":"INDEX(Units!$G$30:$G$35,MATCH(Units!$Y$13,INDEX(Units!$C$30:$F$35,,Units!$R$9),0))","v":"No Clip"},null,null,null,{"$f":"Data!H7","v":4.0000000000001004},null,null,null,{"$f":"Data!H2","v":4.0000000000001004}]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"Data!B35","v":"29.9 GPM"}]
[null,null,null,null,null,null,null,{"$f":"ROUND(Data!AK42/Units!$Z$13/20,2)","v":1.66}]
[null,null,null,null,null,null,null,{"$f":"Data!D32","v":"8.24 kPa"}]
[null,null,null,null,null,null,null,{"$f":"Data!E29","v":4.0000010000000001}]

{"sheet":"Copyright","index":3,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[null,"BELIMO HYDRONIC SIMULATOR ™ "]
[]
[null,"© BELIMO HOLDING AG 2018","© BELIMO HOLDING AG 2018"]
[]
[null,"Rechte am Geistigen Eigentum","Intellectual Property Rights"]
[]
[null,"Sämtliche Rechte, Titel und Ansprüche (einschliesslich Copyrights, Marken, Patente und anderer Rechte an geistigem Eigentum) an allen Informationen und Inhalten (einschliesslich aller Texte, Daten, Grafiken und Logos) des BELIMO Hydronic Simulator™ verbleiben bei der BELIMO oder dem jeweiligen Rechteinhaber. Einzelne Seiten, Teile oder Ergebnisse des BELIMO Hydronic Simulator™ dürfen ausschliesslich zu privater oder interner Verwendung ausgedruckt werden, und nur insoweit als der jeweilige Ausdruck alle betreffenden Hinweise auf Copyrights und andere Eigentumsrechte enthält. Es ist den Benutzern verboten, irgendwelche Informationen, Texte, Grafiken, Bilder, Datenbanken, Listen oder Software, die vom BELIMO Hydronic Simulator™ stammen, im Ganzen oder teilweise ohne die vorherige schriftliche Genehmigung von BELIMO zu verändern, zu kopieren, zu senden, weiterzugeben, auszustellen, vorzuführen, zu reproduzieren, zu veröffentlichen, zu lizenzieren, als Frame in einer Webseite zu verwenden, zu übertragen und von den genannten Inhalten abgeleitete Werke zu erstellen oder sie auf andere Art für gewerbliche oder öffentliche Zwecke zu nutzen. ","BELIMO, or the applicable third-party owner, retains all right, title and interest (including copyrights, trademarks, patents, as well as any other intellectual property right) in all information and content (including all text, data, graphics and logos) on the BELIMO Hydronic Simulator™. Individual pages, sections or results of the BELIMO Hydronic Simulator™ may be printed for personal or internal use only, and provided that such printouts retain all applicable copyright or other proprietary notices. All users must not, without limitation, modify, copy, transmit, distribute, display, perform, reproduce, publish, license, frame, create derivative works from, transfer or otherwise use in any other way, whether in whole or in part, any information, text, graphics, images, databases, listings or software obtained from the BELIMO Hydronic Simulator™for commercial or public purposes, without the prior written permission of BELIMO. "]

{"sheet":"Language","index":4,"n_rows":22,"n_cols":8,"rows_kept":22,"cut":false,"hidden":true,"merged":[]}
["Shape Name","English","French","Spanish","Portuguese",null,null,"Selected Language"]
["LabelSelectLanguage","Select Language","Sélectionnez la Langue","Seleccione el Idioma","Selecione o Idioma",null,null,"English"]
["LabelSelectFlowUnits","Select the Flow units","Sélectionnez les unités de mesure du débit","Seleccione las unidades de flujo","Selecione as unidades de vazão"]
["LabelSelectFlowPerCoil","Select the Flow per coil","Sélectionnez le débit par serpentin","Seleccione el flujo por serpentín","Selecione a vazão por unidade terminal"]
["LabelSelectDeltaPUnits","Select the Delta P units","Sélectionnez les unités de mesure du delta P","Seleccione las unidades de Delta P","Selecione as unidades de Delta P"]
[null,"Design Settings","Paramètre de conception","Dados de diseño","Dados de projeto"]
[null,"Flow per coil","Débit","Flujo","Vazão p/ coil"]
[null,"Delta P Units","Unités Dp","Unidades Dp","Unidade Dp"]
[null,"Pumping Costs","Frais de pompage","Costo del bombeo","Custo de Bombeamento"]
[null,"Pump Head","Pression de pompe","Cabeza de la bomba","Altura Manométrica"]
[null,"Nominal","Nominale","Nominal","Nominal"]
["Open","Open","Ouvert","Abrir","Abrir"]
["Closed","Closed","Fermé","Cerrar","Fechar"]
[null,"Turns","Tours","Vueltas","Voltas"]
["FullyOpen","Open Valves Fully","Ouvre entièrement les robinets","Abrir las válvulas completamente","Abrir totalmente as válvulas"]
["ButtonBalanceSystem","Balance System","Équilibre le système","Balanceo del sistema","Balancear o sistema"]
[null,"Pressure drop across the manual balancing valve","Chute de pression dans le robinet d’équilibrage manuel ","Caída de presión en la válvula de balanceo manual","Perda de carga na válvula de balanceamento manual"]
[null,"Turns in the manual balancing valve","Tours de la tige du robinet d'équilibrage manuel","Vueltas en la válvula de balanceo manual","Número de voltas na válvula de balanceamento manual"]
[null,"Blue pipe – Supply / Red pipe - Return","Canalisation bleue – Alimentation / Canalisation rouge – Retour","Tubería azul – Suministro / Tubería roja - Retorno","Tubulação azul – Alimentação / Tubulação vermelha - Retorno"]
[null,"Open or Close manual balancing valve","Ouvre ou ferme le robinet d'équilibrage manuel","Abrir o cerrar la válvula de balanceo manual","Abrir ou fechar a válvula de balanceamento manual"]
[null,"Flow percentage in the coil","Débit dans le serpentin en pourcentage","Porcentaje de flujo en el serpentín","Porcentagem de vazão na unidade terminal"]
[null,"Current flow in the coil","Débit réel dans le serpentin","Flujo actual en el serpentín","Vazão atual na unidade terminal"]

{"sheet":"Information Boxes","index":5,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
["Button","Information"]
["GPMInfo",{"$f":"INDEX(Language!$22:$22,MATCH(Language!$H$2,Language!$1:$1,0))","v":"Current flow in the coil"}]
["PercentInfo",{"$f":"INDEX(Language!$21:$21,MATCH(Language!$H$2,Language!$1:$1,0))","v":"Flow percentage in the coil"}]
["PSIInfo",{"$f":"INDEX(Language!$17:$17,MATCH(Language!$H$2,Language!$1:$1,0))","v":"Pressure drop across the manual balancing valve"}]
["OpenCloseInfo",{"$f":"INDEX(Language!$20:$20,MATCH(Language!$H$2,Language!$1:$1,0))","v":"Open or Close manual balancing valve"}]
["TurnInfo",{"$f":"INDEX(Language!$18:$18,MATCH(Language!$H$2,Language!$1:$1,0))","v":"Turns in the manual balancing valve"}]
["PipesInfo",{"$f":"INDEX(Language!$19:$19,MATCH(Language!$H$2,Language!$1:$1,0))","v":"Blue pipe – Supply / Red pipe - Return"}]

{"sheet":"Units","index":6,"n_rows":38,"n_cols":26,"rows_kept":38,"cut":false,"hidden":true,"merged":[[27,2,27,5],[37,2,37,4]]}
[]
[]
[]
[]
[]
[null,null,null,null,null,"Some parameters",null,null,"Suggested","Chosen","Units"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"kPa-l/h"]
[null,null,"Click on the units required",null,null,"Dp pipes between the risers",null,null,{"$f":"Z11","v":12},{"$f":"I8","v":12},{"$f":"$S$14","v":"kPa"},null,null,null,null,null,null,null,null,"Flow","Dp","Suggested","Chosen"]
[null,null,"Flow units","Dp units",null,"Dp pipes between coils of one riser",null,null,{"$f":"Z12","v":2},{"$f":"I9","v":2},{"$f":"$S$14","v":"kPa"},null,null,null,null,null,null,2,1,"Correction factors"]
[null,null,null,null,null,"Design water flow in each coil",null,null,{"$f":"Z13","v":0.9},{"$f":"I10","v":0.9},{"$f":"R14","v":"GPM"},null,null,null,null,null,1,"l/h","kPa",1,1,3,{"$f":"V10*$U$14","v":3},null,{"$f":"V10/$U$14","v":3},{"$f":"ROUND(Y10,IF(Y10>=100,0,1))","v":3}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"GPM","psi",227,6.9,12,{"$f":"J8*$U$14","v":12},null,{"$f":"V11/$U$14","v":12},{"$f":"ROUND(Y11,IF(Y11>=100,0,1))","v":12}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"l/s",null,3600,null,2,{"$f":"J9*$U$14","v":2},null,{"$f":"V12/$U$14","v":2},{"$f":"ROUND(Y12,IF(Y12>=100,0,1))","v":2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"m3/h",null,1000,null,150,{"$f":"J10*T14","v":204.3},null,0.9,{"$f":"ROUND(Y13,IF(Y13>=100,0,2-ROUND(LOG10(Y13),0)))","v":0.9}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LOOKUP(R9,$Q$10:$Q$13,R10:R13)","v":"GPM"},{"$f":"LOOKUP(S9,$Q$10:$Q$13,S10:S13)","v":"kPa"},{"$f":"LOOKUP(R9,$Q$10:$Q$13,T10:T13)","v":227},{"$f":"LOOKUP(S9,$Q$10:$Q$13,U10:U13)","v":1}]
[null,"Important remark:",null,"For all modification of the working units",null,null,null,{"$f":"$J$9","v":2},{"$f":"$J$9","v":2},{"$f":"$J$9","v":2},{"$f":"$J$9","v":2}]
[null,"please check the values visible in the yellow cells"]
[null,null,null,null,null,null,null,{"$f":"$J$9","v":2},{"$f":"$J$9","v":2},{"$f":"$J$9","v":2},{"$f":"$J$9","v":2}]
[null,null,{"$f":"\"Design Dp in each coil in \"&K7","v":"Design Dp in each coil in "}]
[null,null,"Column 1","Column 2","Column 3","Column 4",null,{"$f":"$J$9","v":2},{"$f":"$J$9","v":2},{"$f":"$J$9","v":2},{"$f":"$J$9","v":2}]
[null,5,5,9,7,13]
[null,4,5,12,5,6,null,{"$f":"$J$9","v":2},{"$f":"$J$9","v":2},{"$f":"$J$9","v":2},{"$f":"$J$9","v":2}]
[null,3,6,5,6,6]
[null,2,5,6,7,8,null,{"$f":"$J$9","v":2},{"$f":"$J$9","v":2},{"$f":"$J$9","v":2},{"$f":"$J$9","v":2}]
[null,1,6,7,5,5]
[null,null,null,null,null,null,null,{"$f":"$J$8","v":12},{"$f":"$J$8","v":12},{"$f":"$J$8","v":12},{"$f":"$J$8","v":12}]
[null,null,null,null,null,null,null,null,"Dp pipes between the risers"]
[]
[null,null,"Flow"]
[null,null,"l/h","GPM","l/s","m3/h","Clip Position"]
[null,null,91,0.4,{"$f":"ROUND(D30*227/3600,3)","v":2.5000000000000001E-2},{"$f":"ROUND(D30*227/1000,3)","v":9.0999999999999998E-2},5]
[null,null,114,0.5,{"$f":"ROUND(D31*227/3600,3)","v":3.2000000000000001E-2},{"$f":"ROUND(D31*227/1000,3)","v":0.114},"6-"]
[null,null,136,0.6,3.7999999999999999E-2,0.13600000000000001,"6+"]
[null,null,159,0.7,4.3999999999999997E-2,0.159,"N-"]
[null,null,182,0.8,0.05,0.182,"N"]
[null,null,204,0.9,5.7000000000000002E-2,0.20399999999999999,"No Clip"]
[]
[null,null,null,null,null,"Value","Ref. Value"]
[null,null,"Min Delta P on the Pressure Independent",null,null,{"$f":"G38/U14","v":16},16]

{"sheet":"Data","index":7,"n_rows":49,"n_cols":172,"rows_kept":49,"cut":false,"hidden":true,"merged":[]}
[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,"kPa"]
[null,null,null,null,null,null,null,{"$f":"AJ4","v":4.0000000000001004},null,null,null,null,null,{"$f":"$BJ4","v":4.0000000000001004},null,null,null,null,null,{"$f":"CJ4","v":4.0000000000001004},null,null,null,null,null,{"$f":"$DJ4","v":4.0000000000001004},null,null,null,null,null,100,{"$f":"Units!$W$13","v":204.3},"Min",{"$f":"Units!$W$10","v":3},"Kvs=",{"$f":"0.01*$AG$2/$AI$2^0.5","v":1.1795265999544056},"L=",{"$f":"Units!$W$12","v":2},"Units","l/h","kPa","Corr",{"$f":"Units!$T$14","v":227},{"$f":"Units!$U$14","v":1},null,null,"STAD","q%",null,null,{"$f":"Units!$R$14:$U$14","v":"GPM"},"kPa",227,1,null,null,200,{"$f":"Units!$W$13","v":204.3},"Min",{"$f":"Units!$W$10","v":3},"Kvs=",{"$f":"0.01*$AG$2/$AI$2^0.5","v":1.1795265999544056},"L=",{"$f":"Units!$W$12","v":2},"Units","l/h","kPa","Corr",{"$f":"Units!$T$14","v":227},{"$f":"Units!$U$14","v":1},null,null,"STAD","q%",null,null,null,null,null,null,null,null,"qc",{"$f":"Units!$W$13","v":204.3},"Min",{"$f":"Units!$W$10","v":3},"Kvs=",{"$f":"0.01*$AG$2/$AI$2^0.5","v":1.1795265999544056},"L=",{"$f":"Units!$W$12","v":2},"Units","l/h","kPa","Corr",{"$f":"Units!$T$14","v":227},{"$f":"Units!$U$14","v":1},null,null,"STAD","q%",null,null,null,null,null,null,null,null,"qc",{"$f":"Units!$W$13","v":204.3},"Min",{"$f":"Units!$W$10","v":3},"Kvs=",{"$f":"0.01*$AG$2/$AI$2^0.5","v":1.1795265999544056},"L=",{"$f":"Units!$W$12","v":2},"Units","l/h","kPa","Corr",{"$f":"Units!$T$14","v":227},{"$f":"Units!$U$14","v":1},null,null,"STAD","q%",null,"Kv","Max","Min","Pos","Kv2","Max","Min","Pos","Kv2","Max","Min","Pos","Kv2","Max","Min","Pos","Kv2","Max","Min","Pos","Kv2","Max","Min","Pos","Kv2","Max","Min","Pos","Kv2","Max","Min","Pos","Kv2","Max","Min","Pos","Kv2","Max","Min","Pos","Kv2","Max","Min","Pos"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(AU6&\" \"&$AZ$2=\"0.0001 GPM\",\"0 GPM\",AU6&\" \"&$AZ$2)","v":"1.67 GPM"},null,null,null,null,null,{"$f":"IF(BU6&\" \"&$AZ$2=\"0.0001 GPM\",\"0 GPM\",BU6&\" \"&$AZ$2)","v":"1.28 GPM"},null,null,null,null,null,{"$f":"IF(CU6&\" \"&$AZ$2=\"0.0001 GPM\",\"0 GPM\",CU6&\" \"&$AZ$2)","v":"1.05 GPM"},null,null,null,null,null,{"$f":"IF(DU6&\" \"&$AZ$2=\"0.0001 GPM\",\"0 GPM\",DU6&\" \"&$AZ$2)","v":"0.7 GPM"},null,null,false,"Pos5",null,null,"Units","Pos",{"$f":"\"C\"&(6-AM4)","v":"C5"},{"$f":"\"KvC\"&(6-AM4)","v":"KvC5"},"Nb",{"$f":"\"KvL\"&(6-AM4)","v":"KvL5"},{"$f":"\"Kvs\"&(6-AM4)","v":"Kvs5"},null,null,{"$f":"\"KV\"&(6-AM4)","v":"KV5"},"PE",null,{"$f":"\"q5\"","v":"q5"},null,null,null,null,null,null,null,null,null,false,"Pos5",null,null,null,"Pos",{"$f":"\"C\"&(6-BM4)","v":"C5"},{"$f":"\"KvC\"&(6-BM4)","v":"KvC5"},"Nb",{"$f":"\"KvL\"&(6-BM4)","v":"KvL5"},{"$f":"\"Kvs\"&(6-BM4)","v":"Kvs5"},null,null,{"$f":"\"KV\"&(6-BM4)","v":"KV5"},"PE",null,{"$f":"\"q5\"","v":"q5"},null,null,null,null,null,null,null,null,null,false,"Pos5",null,null,null,"Pos",{"$f":"\"C\"&(6-CM4)","v":"C5"},{"$f":"\"KvC\"&(6-CM4)","v":"KvC5"},"Nb",{"$f":"\"KvL\"&(6-CM4)","v":"KvL5"},{"$f":"\"Kvs\"&(6-CM4)","v":"Kvs5"},null,null,{"$f":"\"KV\"&(6-CM4)","v":"KV5"},"PE",null,{"$f":"\"q5\"","v":"q5"},null,null,null,null,null,null,null,null,null,false,"Pos5",null,null,null,"Pos",{"$f":"\"C\"&(6-DM4)","v":"C5"},{"$f":"\"KvC\"&(6-DM4)","v":"KvC5"},"Nb",{"$f":"\"KvL\"&(6-DM4)","v":"KvL5"},{"$f":"\"Kvs\"&(6-DM4)","v":"Kvs5"},null,null,{"$f":"\"KV\"&(6-DM4)","v":"KV5"},"PE",null,{"$f":"\"q5\"","v":"q5"},null,null,null,{"$f":"0.01*B15*BB2/(C15*BC2)^0.5","v":1.1795265999544056},4,0,{"$f":"(DZ3+EA3)/2","v":2},{"$f":"$BA$7*0.4/(4/EB3-0.6)+10^-10","v":0.33700760008697306},{"$f":"IF(EC3>$DY$3,EB3,DZ3)","v":4},{"$f":"IF(EC3>$DY$3,EA3,EB3)","v":2},{"$f":"(ED3+EE3)/2","v":3},{"$f":"$BA$7*0.4/(4/EF3-0.6)+10^-10","v":0.64337814552967587},{"$f":"IF(EG3>$DY$3,EF3,ED3)","v":4},{"$f":"IF(EG3>$DY$3,EE3,EF3)","v":3},{"$f":"(EH3+EI3)/2","v":3.5},{"$f":"$BA$7*0.4/(4/EJ3-0.6)+10^-10","v":0.86912486322429894},{"$f":"IF(EK3>$DY$3,EJ3,EH3)","v":4},{"$f":"IF(EK3>$DY$3,EI3,EJ3)","v":3.5},{"$f":"(EL3+EM3)/2","v":3.75},{"$f":"$BA$7*0.4/(4/EN3-0.6)+10^-10","v":1.0110228000609192},{"$f":"IF(EO3>$DY$3,EN3,EL3)","v":4},{"$f":"IF(EO3>$DY$3,EM3,EN3)","v":3.75},{"$f":"(EP3+EQ3)/2","v":3.875},{"$f":"$BA$7*0.4/(4/ER3-0.6)+10^-10","v":1.09150222692348},{"$f":"IF(ES3>$DY$3,ER3,EP3)","v":4},{"$f":"IF(ES3>$DY$3,EQ3,ER3)","v":3.875},{"$f":"(ET3+EU3)/2","v":3.9375},{"$f":"$BA$7*0.4/(4/EV3-0.6)+10^-10","v":1.1345065008195048},{"$f":"IF(EW3>$DY$3,EV3,ET3)","v":4},{"$f":"IF(EW3>$DY$3,EU3,EV3)","v":3.9375},{"$f":"(EX3+EY3)/2","v":3.96875},{"$f":"$BA$7*0.4/(4/EZ3-0.6)+10^-10","v":1.1567558162715021},{"$f":"IF(FA3>$DY$3,EZ3,EX3)","v":4},{"$f":"IF(FA3>$DY$3,EY3,EZ3)","v":3.96875},{"$f":"(FB3+FC3)/2","v":3.984375},{"$f":"$BA$7*0.4/(4/FD3-0.6)+10^-10","v":1.1680748854917415},{"$f":"IF(FE3>$DY$3,FD3,FB3)","v":4},{"$f":"IF(FE3>$DY$3,FC3,FD3)","v":3.984375},{"$f":"(FF3+FG3)/2","v":3.9921875},{"$f":"$BA$7*0.4/(4/FH3-0.6)+10^-10","v":1.1737840168024369},{"$f":"IF(FI3>$DY$3,FH3,FF3)","v":4},{"$f":"IF(FI3>$DY$3,FG3,FH3)","v":3.9921875},{"$f":"(FJ3+FK3)/2","v":3.99609375},{"$f":"$BA$7*0.4/(4/FL3-0.6)+10^-10","v":1.17665110858694},{"$f":"IF(FM3>$DY$3,FL3,FJ3)","v":4},{"$f":"IF(FM3>$DY$3,FK3,FL3)","v":3.99609375},{"$f":"(FN3+FO3)/2","v":3.998046875}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF($AW4=0,\"0\",$AW4)","v":185.35966501167022},"%",null,null,null,null,{"$f":"IF($BW4=0,\"0\",$BW4)","v":141.79240084622893},"%",null,null,null,null,{"$f":"IF($CW4=0,\"0\",$CW4)","v":116.41872459819072},"%",null,null,null,null,{"$f":"IF($DW4=0,\"0\",$DW4)","v":77.158513248060203},"%",null,400,{"$f":"IF(AE3=TRUE,0,AE4)","v":400},null,null,{"$f":"AI2/9.81","v":0.3058103975535168},{"$f":"AF4/100+0.0000000000001","v":4.0000000000001004},{"$f":"Units!$C$20*$BC$2","v":5},{"$f":"0.01*$AG$2/AK4^0.5","v":0.91365737560641413},1,{"$f":"0.01*$AG$2/$AM$2^0.5*AM4","v":1.4446191539641167},{"$f":"$AK$2*(0.4/(4/AJ4-0.6))+10^-10","v":1.1795266000544797},null,null,{"$f":"1/(1/AL4^2+1/AN4^2+1/AO4^2)^0.5","v":0.6460533259888438},{"$f":"IF(AS9-(0.01*AT9/AN4)^2<0.0002,0,AS9-(0.01*AT9/AN4)^2)","v":27.486564328841915},null,{"$f":"100*AR4*AS9^0.5","v":378.68979561884225},{"$f":"(0.01*AU4/AO4)^2","v":10.307461622222551},{"$f":"100*AU4/$AG$2","v":185.35966501167022},null,null,null,null,null,null,null,400,{"$f":"IF(BE3=TRUE,0,BE4)","v":400},null,null,null,{"$f":"BF4/100+0.0000000000001","v":4.0000000000001004},{"$f":"Units!$D$20*BC2","v":9},{"$f":"0.01*$AG$2/BK4^0.5","v":0.68100000000000005},1,{"$f":"0.01*$AG$2/$AM$2^0.5*BM4","v":1.4446191539641167},{"$f":"$AK$2*(0.4/(4/BJ4-0.6))+10^-10","v":1.1795266000544797},null,null,{"$f":"1/(1/BL4^2+1/BN4^2+1/BO4^2)^0.5","v":0.54601471723700989},{"$f":"IF(BS9-(0.01*BT9/BN4)^2<0.0002,0,BS9-(0.01*BT9/BN4)^2)","v":24.126101924261746},null,{"$f":"100*BR4*BS9^0.5","v":289.68187492884573},{"$f":"(0.01*BU4/BO4)^2","v":6.0315254802978364},{"$f":"100*BU4/$AG$2","v":141.79240084622893},null,null,null,null,null,null,null,400,{"$f":"IF(CE3=TRUE,0,CE4)","v":400},null,null,null,{"$f":"CF4/100+0.0000000000001","v":4.0000000000001004},{"$f":"Units!$E$20*BC2","v":7},{"$f":"0.01*$AG$2/CK4^0.5","v":0.77218141835785126},1,{"$f":"0.01*$AG$2/$AM$2^0.5*CM4","v":1.4446191539641167},{"$f":"$AK$2*(0.4/(4/CJ4-0.6))+10^-10","v":1.1795266000544797},null,null,{"$f":"1/(1/CL4^2+1/CN4^2+1/CO4^2)^0.5","v":0.589763299989712},{"$f":"IF(CS9-(0.01*CT9/CN4)^2<0.0002,0,CS9-(0.01*CT9/CN4)^2)","v":13.553319436379432},null,{"$f":"100*CR4*CS9^0.5","v":237.84345435410367},{"$f":"(0.01*CU4/CO4)^2","v":4.0659958304308725},{"$f":"100*CU4/$AG$2","v":116.41872459819072},null,null,null,null,null,null,null,400,{"$f":"IF(DE3=TRUE,0,DE4)","v":400},null,null,null,{"$f":"DF4/100+0.0000000000001","v":4.0000000000001004},{"$f":"Units!$F$20*BC2","v":13},{"$f":"0.01*$AG$2/DK4^0.5","v":0.56662625044407167},1,{"$f":"0.01*$AG$2/$AM$2^0.5*DM4","v":1.4446191539641167},{"$f":"$AK$2*(0.4/(4/DJ4-0.6))+10^-10","v":1.1795266000544797},null,null,{"$f":"1/(1/DL4^2+1/DN4^2+1/DO4^2)^0.5","v":0.48153971799484818},{"$f":"IF(DS9-(0.01*DT9/DN4)^2<0.0002,0,DS9-(0.01*DT9/DN4)^2)","v":9.5254978663386698},null,{"$f":"100*DR4*DS9^0.5","v":157.63484256578701},{"$f":"(0.01*DU4/DO4)^2","v":1.7860308496922612},{"$f":"100*DU4/$AG$2","v":77.158513248060203}]
[null,null,null,null,null,null,{"$f":"IF(H2=0.0000000000001,0,AV6)","v":10.4},null,null,null,null,null,{"$f":"IF(N2=0.0000000000001,0,BV6)","v":6.04},null,null,null,null,null,{"$f":"IF(T2=0.0000000000001,0,CV6)","v":4.07},null,null,null,null,null,{"$f":"IF(Z2=0.0000000000001,0,DV6)","v":1.79},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$AU4/$AR$2","v":1.668236985105032},{"$f":"$AV4/$BC$2","v":10.307461622222551},null,null,null,null,"Kvs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BU4/$AR$2","v":1.2761316076160605},{"$f":"BV4/$BC$2","v":6.0315254802978364},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CU4/$AR$2","v":1.0477685213837167},{"$f":"CV4/$BC$2","v":4.0659958304308725},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DU4/$AR$2","v":0.6944266192325419},{"$f":"DV4/$BC$2","v":1.7860308496922612},null,null,"Kvs"]
[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,{"$f":"ROUND(CEILING(AU5,IF(AU5>=100,1,IF(AND(AU5<100,AU5>=10),0.1,IF(AND(AU5<10,AU5>=1),0.01,IF(AND(AU5<1,AU5>=0.1),0.001,0.0001))))),2)","v":1.67},{"$f":"CEILING(AV5,IF(AV5>=100,1,IF(AND(AV5<100,AV5>=10),0.1,IF(AND(AV5<10,AV5>=1),0.01,IF(AND(AV5<1,AV5>=0.1),0.001,0.0001)))))","v":10.4},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(CEILING(BU5,IF(BU5>=100,1,IF(AND(BU5<100,BU5>=10),0.1,IF(AND(BU5<10,BU5>=1),0.01,IF(AND(BU5<1,BU5>=0.1),0.001,0.0001))))),2)","v":1.28},{"$f":"CEILING(BV5,IF(BV5>=100,1,IF(AND(BV5<100,BV5>=10),0.1,IF(AND(BV5<10,BV5>=1),0.01,IF(AND(BV5<1,BV5>=0.1),0.001,0.0001)))))","v":6.04},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(CEILING(CU5,IF(CU5>=100,1,IF(AND(CU5<100,CU5>=10),0.1,IF(AND(CU5<10,CU5>=1),0.01,IF(AND(CU5<1,CU5>=0.1),0.001,0.0001))))),2)","v":1.05},{"$f":"CEILING(CV5,IF(CV5>=100,1,IF(AND(CV5<100,CV5>=10),0.1,IF(AND(CV5<10,CV5>=1),0.01,IF(AND(CV5<1,CV5>=0.1),0.001,0.0001)))))","v":4.07},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(CEILING(DU5,IF(DU5>=100,1,IF(AND(DU5<100,DU5>=10),0.1,IF(AND(DU5<10,DU5>=1),0.01,IF(AND(DU5<1,DU5>=0.1),0.001,0.0001))))),2)","v":0.7},{"$f":"CEILING(DV5,IF(DV5>=100,1,IF(AND(DV5<100,DV5>=10),0.1,IF(AND(DV5<10,DV5>=1),0.01,IF(AND(DV5<1,DV5>=0.1),0.001,0.0001)))))","v":1.79}]
[null,null,null,null,null,null,null,{"$f":"AJ9","v":4.0000000000001004},null,null,null,null,null,{"$f":"$BJ9","v":4.0000000000001004},null,null,null,null,null,{"$f":"CJ9","v":4.0000000000001004},null,null,null,null,null,{"$f":"$DJ9","v":4.0000000000001004},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,{"$f":"0.01*BB2*B15/(BI2)^0.5","v":1.1795265999544056},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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BA7","v":1.1795265999544056}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(AU11&\" \"&$AZ$2=\"0.0001 GPM\",\"0 GPM\",AU11&\" \"&$AZ$2)","v":"1.87 GPM"},null,null,null,null,null,{"$f":"IF(BU11&\" \"&$AZ$2=\"0.0001 GPM\",\"0 GPM\",BU11&\" \"&$AZ$2)","v":"1.24 GPM"},null,null,null,null,null,{"$f":"IF(CU11&\" \"&$AZ$2=\"0.0001 GPM\",\"0 GPM\",CU11&\" \"&$AZ$2)","v":"1.29 GPM"},null,null,null,null,null,{"$f":"IF(DU11&\" \"&$AZ$2=\"0.0001 GPM\",\"0 GPM\",DU11&\" \"&$AZ$2)","v":"0.98 GPM"},null,null,false,"Pos4",null,null,null,"Pos",{"$f":"\"C\"&(6-AM9)","v":"C4"},{"$f":"\"KvC\"&(6-AM9)","v":"KvC4"},"Nb",{"$f":"\"KvL\"&(6-AM9)","v":"KvL4"},{"$f":"\"Kvs\"&(6-AM9)","v":"Kvs4"},{"$f":"\"D1\"","v":"D1"},{"$f":"\"D2\"","v":"D2"},"KvD","PD",{"$f":"\"q45\"","v":"q45"},{"$f":"\"q4\"","v":"q4"},null,null,null,null,null,null,null,null,null,false,"Pos4",null,null,null,"Pos",{"$f":"\"C\"&(6-BM9)","v":"C4"},{"$f":"\"KvC\"&(6-BM9)","v":"KvC4"},"Nb",{"$f":"\"KvL\"&(6-BM9)","v":"KvL4"},{"$f":"\"Kvs\"&(6-BM9)","v":"Kvs4"},{"$f":"\"D1\"","v":"D1"},{"$f":"\"D2\"","v":"D2"},"KvD","PD",{"$f":"\"q45\"","v":"q45"},{"$f":"\"q4\"","v":"q4"},null,null,null,null,null,null,null,null,null,false,"Pos4",null,null,null,"Pos",{"$f":"\"C\"&(6-CM9)","v":"C4"},{"$f":"\"KvC\"&(6-CM9)","v":"KvC4"},"Nb",{"$f":"\"KvL\"&(6-CM9)","v":"KvL4"},{"$f":"\"Kvs\"&(6-CM9)","v":"Kvs4"},{"$f":"\"D1\"","v":"D1"},{"$f":"\"D2\"","v":"D2"},"KvD","PD",{"$f":"\"q45\"","v":"q45"},{"$f":"\"q4\"","v":"q4"},null,null,null,null,null,null,null,null,null,false,"Pos4",null,null,null,"Pos",{"$f":"\"C\"&(6-DM9)","v":"C4"},{"$f":"\"KvC\"&(6-DM9)","v":"KvC4"},"Nb",{"$f":"\"KvL\"&(6-DM9)","v":"KvL4"},{"$f":"\"Kvs\"&(6-DM9)","v":"Kvs4"},{"$f":"\"D1\"","v":"D1"},{"$f":"\"D2\"","v":"D2"},"KvD","PD",{"$f":"\"q45\"","v":"q45"},{"$f":"\"q4\"","v":"q4"}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF($AW9=0,\"0\",$AW9)","v":207.23840562766068},"%",null,null,null,null,{"$f":"IF($BW9=0,\"0\",$BW9)","v":136.98447336046158},"%",null,null,null,null,{"$f":"IF($CW9=0,\"0\",$CW9)","v":142.58323588709607},"%",null,null,null,null,{"$f":"IF($DW9=0,\"0\",$DW9)","v":109.11861588949385},"%",null,400,{"$f":"IF(AE8=TRUE,0,AE9)","v":400},null,null,null,{"$f":"AF9/100+0.0000000000001","v":4.0000000000001004},{"$f":"Units!$C$21*$BC$2","v":5},{"$f":"0.01*$AG$2/AK9^0.5","v":0.91365737560641413},2,{"$f":"0.01*$AG$2/$AM$2^0.5*AM9","v":2.8892383079282333},{"$f":"$AK$2*(0.4/(4/AJ9-0.6))+10^-10","v":1.1795266000544797},{"$f":"AR4","v":0.6460533259888438},{"$f":"1/(1/AL9^2+1/AO9^2)^0.5","v":0.72230957700503939},{"$f":"AQ9+AP9","v":1.3683629029938831},{"$f":"IF(AS14-(0.01*AT14/AN9)^2<0.0002,0,AS14-(0.01*AT14/AN9)^2)","v":34.358205411489578},{"$f":"AT14-AU9","v":378.68979561884078},{"$f":"100*AQ9*AS9^0.5","v":423.38806269731083},{"$f":"(0.01*AU9/AO9)^2","v":12.884327027942165},{"$f":"100*AU9/$AG$2","v":207.23840562766068},null,null,null,null,null,null,null,400,{"$f":"IF(BE8=TRUE,0,BE9)","v":400},null,null,null,{"$f":"BF9/100+0.0000000000001","v":4.0000000000001004},{"$f":"Units!$D$21*BC2","v":12},{"$f":"0.01*$AG$2/BK9^0.5","v":0.58976329997720278},2,{"$f":"0.01*$AG$2/$AM$2^0.5*BM9","v":2.8892383079282333},{"$f":"$AK$2*(0.4/(4/BJ9-0.6))+10^-10","v":1.1795266000544797},{"$f":"BR4","v":0.54601471723700989},{"$f":"1/(1/BL9^2+1/BO9^2)^0.5","v":0.52750033176240119},{"$f":"BQ9+BP9","v":1.0735150489994112},{"$f":"IF(BS14-(0.01*BT14/BN9)^2<0.0002,0,BS14-(0.01*BT14/BN9)^2)","v":28.147118911809272},{"$f":"BT14-BU9","v":289.6818749288455},{"$f":"100*BQ9*BS9^0.5","v":279.85927907542299},{"$f":"(0.01*BU9/BO9)^2","v":5.6294237815976711},{"$f":"100*BU9/$AG$2","v":136.98447336046158},null,null,null,null,null,null,null,400,{"$f":"IF(CE8=TRUE,0,CE9)","v":400},null,null,null,{"$f":"CF9/100+0.0000000000001","v":4.0000000000001004},{"$f":"Units!$E$21*BC2","v":5},{"$f":"0.01*$AG$2/CK9^0.5","v":0.91365737560641413},2,{"$f":"0.01*$AG$2/$AM$2^0.5*CM9","v":2.8892383079282333},{"$f":"$AK$2*(0.4/(4/CJ9-0.6))+10^-10","v":1.1795266000544797},{"$f":"CR4","v":0.589763299989712},{"$f":"1/(1/CL9^2+1/CO9^2)^0.5","v":0.72230957700503939},{"$f":"CQ9+CP9","v":1.3120728769947514},{"$f":"IF(CS14-(0.01*CT14/CN9)^2<0.0002,0,CS14-(0.01*CT14/CN9)^2)","v":16.263983323793312},{"$f":"CT14-CU9","v":237.84345435410387},{"$f":"100*CQ9*CS9^0.5","v":291.29755091733728},{"$f":"(0.01*CU9/CO9)^2","v":6.0989937457756742},{"$f":"100*CU9/$AG$2","v":142.58323588709607},null,null,null,null,null,null,null,400,{"$f":"IF(DE8=TRUE,0,DE9)","v":400},null,null,null,{"$f":"DF9/100+0.0000000000001","v":4.0000000000001004},{"$f":"Units!$F$21*BC2","v":6},{"$f":"0.01*$AG$2/DK9^0.5","v":0.83405125741767228},2,{"$f":"0.01*$AG$2/$AM$2^0.5*DM9","v":2.8892383079282333},{"$f":"$AK$2*(0.4/(4/DJ9-0.6))+10^-10","v":1.1795266000544797},{"$f":"DR4","v":0.48153971799484818},{"$f":"1/(1/DL9^2+1/DO9^2)^0.5","v":0.68100000001925942},{"$f":"DQ9+DP9","v":1.1625397180141075},{"$f":"IF(DS14-(0.01*DT14/DN9)^2<0.0002,0,DS14-(0.01*DT14/DN9)^2)","v":10.716185099668881},{"$f":"DT14-DU9","v":157.63484256578664},{"$f":"100*DQ9*DS9^0.5","v":222.92933226223596},{"$f":"(0.01*DU9/DO9)^2","v":3.5720616994855439},{"$f":"100*DU9/$AG$2","v":109.11861588949385}]
[null,null,null,null,null,null,{"$f":"IF(H7=0.0000000000001,0,AV11)","v":12.9},null,null,null,null,null,{"$f":"IF(N7=0.0000000000001,0,BV11)","v":5.63},null,null,null,null,null,{"$f":"IF(T7=0.0000000000001,0,CV11)","v":6.1000000000000005},null,null,null,null,null,{"$f":"IF(Z7=0.0000000000001,0,DV11)","v":3.58},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$AU9/$AR$2","v":1.8651456506489463},{"$f":"$AV9/$BC$2","v":12.884327027942165},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BU9/$AR$2","v":1.2328602602441541},{"$f":"BV9/$BC$2","v":5.6294237815976711},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CU9/$AR$2","v":1.2832491229838647},{"$f":"CV9/$BC$2","v":6.0989937457756742},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DU9/$AR$2","v":0.98206754300544474},{"$f":"DV9/$BC$2","v":3.5720616994855439}]
[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,{"$f":"ROUND(CEILING(AU10,IF(AU10>=100,1,IF(AND(AU10<100,AU10>=10),0.1,IF(AND(AU10<10,AU10>=1),0.01,IF(AND(AU10<1,AU10>=0.1),0.001,0.0001))))),2)","v":1.87},{"$f":"CEILING(AV10,IF(AV10>=100,1,IF(AND(AV10<100,AV10>=10),0.1,IF(AND(AV10<10,AV10>=1),0.01,IF(AND(AV10<1,AV10>=0.1),0.001,0.0001)))))","v":12.9},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(CEILING(BU10,IF(BU10>=100,1,IF(AND(BU10<100,BU10>=10),0.1,IF(AND(BU10<10,BU10>=1),0.01,IF(AND(BU10<1,BU10>=0.1),0.001,0.0001))))),2)","v":1.24},{"$f":"CEILING(BV10,IF(BV10>=100,1,IF(AND(BV10<100,BV10>=10),0.1,IF(AND(BV10<10,BV10>=1),0.01,IF(AND(BV10<1,BV10>=0.1),0.001,0.0001)))))","v":5.63},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(CEILING(CU10,IF(CU10>=100,1,IF(AND(CU10<100,CU10>=10),0.1,IF(AND(CU10<10,CU10>=1),0.01,IF(AND(CU10<1,CU10>=0.1),0.001,0.0001))))),2)","v":1.29},{"$f":"CEILING(CV10,IF(CV10>=100,1,IF(AND(CV10<100,CV10>=10),0.1,IF(AND(CV10<10,CV10>=1),0.01,IF(AND(CV10<1,CV10>=0.1),0.001,0.0001)))))","v":6.1000000000000005},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(CEILING(DU10,IF(DU10>=100,1,IF(AND(DU10<100,DU10>=10),0.1,IF(AND(DU10<10,DU10>=1),0.01,IF(AND(DU10<1,DU10>=0.1),0.001,0.0001))))),2)","v":0.98},{"$f":"CEILING(DV10,IF(DV10>=100,1,IF(AND(DV10<100,DV10>=10),0.1,IF(AND(DV10<10,DV10>=1),0.01,IF(AND(DV10<1,DV10>=0.1),0.001,0.0001)))))","v":3.58}]
[null,"Presetting for",null,null,null,null,null,{"$f":"AJ14","v":4.0000000000001004},null,null,null,null,null,{"$f":"$BJ14","v":4.0000000000001004},null,null,null,null,null,{"$f":"CJ14","v":4.0000000000001004},null,null,null,null,null,{"$f":"$DJ14","v":4.0000000000001004}]
[null,"Flow","Dp  ","Pos.",null,null,null,null,null,{"$f":"IF(AU16&\" \"&$AZ$2=\"0.0001 GPM\",\"0 GPM\",AU16&\" \"&$AZ$2)","v":"1.95 GPM"},null,null,null,null,null,{"$f":"IF(BU16&\" \"&$AZ$2=\"0.0001 GPM\",\"0 GPM\",BU16&\" \"&$AZ$2)","v":"1.81 GPM"},null,null,null,null,null,{"$f":"IF(CU16&\" \"&$AZ$2=\"0.0001 GPM\",\"0 GPM\",CU16&\" \"&$AZ$2)","v":"1.33 GPM"},null,null,null,null,null,{"$f":"IF(DU16&\" \"&$AZ$2=\"0.0001 GPM\",\"0 GPM\",DU16&\" \"&$AZ$2)","v":"1.06 GPM"},null,null,false,"Pos3",null,null,null,"Pos",{"$f":"\"C\"&(6-AM14)","v":"C3"},{"$f":"\"KvC\"&(6-AM14)","v":"KvC3"},"Nb",{"$f":"\"KvL\"&(6-AM14)","v":"KvL3"},{"$f":"\"Kvs\"&(6-AM14)","v":"Kvs3"},{"$f":"\"C1\"","v":"C1"},{"$f":"\"C2\"","v":"C2"},"KvC","PC",{"$f":"\"q34\"","v":"q34"},{"$f":"\"q3\"","v":"q3"},null,null,null,null,null,null,null,null,null,false,"Pos3",null,null,null,"Pos",{"$f":"\"C\"&(6-BM14)","v":"C3"},{"$f":"\"KvC\"&(6-BM14)","v":"KvC3"},"Nb",{"$f":"\"KvL\"&(6-BM14)","v":"KvL3"},{"$f":"\"Kvs\"&(6-BM14)","v":"Kvs3"},{"$f":"\"C1\"","v":"C1"},{"$f":"\"C2\"","v":"C2"},"KvC","PC",{"$f":"\"q34\"","v":"q34"},{"$f":"\"q3\"","v":"q3"},null,null,null,null,null,null,null,null,null,false,"Pos3",null,null,null,"Pos",{"$f":"\"C\"&(6-CM14)","v":"C3"},{"$f":"\"KvC\"&(6-CM14)","v":"KvC3"},"Nb",{"$f":"\"KvL\"&(6-CM14)","v":"KvL3"},{"$f":"\"Kvs\"&(6-CM14)","v":"Kvs3"},{"$f":"\"C1\"","v":"C1"},{"$f":"\"C2\"","v":"C2"},"KvC","PC",{"$f":"\"q34\"","v":"q34"},{"$f":"\"q3\"","v":"q3"},null,null,null,null,null,null,null,null,null,false,"Pos3",null,null,null,"Pos",{"$f":"\"C\"&(6-DM14)","v":"C3"},{"$f":"\"KvC\"&(6-DM14)","v":"KvC3"},"Nb",{"$f":"\"KvL\"&(6-DM14)","v":"KvL3"},{"$f":"\"Kvs\"&(6-DM14)","v":"Kvs3"},{"$f":"\"C1\"","v":"C1"},{"$f":"\"C2\"","v":"C2"},"KvC","PC",{"$f":"\"q34\"","v":"q34"},{"$f":"\"q3\"","v":"q3"}]
[null,{"$f":"AZ2","v":"GPM"},{"$f":"BA2","v":"kPa"},{"$f":"IF(DY3>DY7,\">Kvs\",\"\")","v":""},null,null,null,null,null,{"$f":"IF($AW14=0,\"0\",$AW14)","v":216.19144722355867},"%",null,null,null,null,{"$f":"IF($BW14=0,\"0\",$BW14)","v":200.10293036794286},"%",null,null,null,null,{"$f":"IF($CW14=0,\"0\",$CW14)","v":147.64102148139983},"%",null,null,null,null,{"$f":"IF($DW14=0,\"0\",$DW14)","v":117.62059316274129},"%",null,400,{"$f":"IF(AE13=TRUE,0,AE14)","v":400},null,null,null,{"$f":"AF14/100+0.0000000000001","v":4.0000000000001004},{"$f":"Units!$C$22*$BC$2","v":6},{"$f":"0.01*$AG$2/AK14^0.5","v":0.83405125741767228},3,{"$f":"0.01*$AG$2/$AM$2^0.5*AM14","v":4.3338574618923502},{"$f":"$AK$2*(0.4/(4/AJ14-0.6))+10^-10","v":1.1795266000544797},{"$f":"1/(1/AR9^2+1/AN9^2)^0.5","v":1.2366783679304174},{"$f":"1/(1/AL14^2+1/AO14^2)^0.5","v":0.68100000001925942},{"$f":"AQ14+AP14","v":1.9176783679496769},{"$f":"IF(AS19-(0.01*AT19/AN14)^2<0.0002,0,AS19-(0.01*AT19/AN14)^2)","v":42.0648676649758},{"$f":"AT19-AU14","v":802.07785831615161},{"$f":"100*AQ14*AS14^0.5","v":441.67912667773038},{"$f":"(0.01*AU14/AO14)^2","v":14.021622553405765},{"$f":"100*AU14/$AG$2","v":216.19144722355867},null,null,null,null,null,null,null,400,{"$f":"IF(BE13=TRUE,0,BE14)","v":400},null,null,null,{"$f":"BF14/100+0.0000000000001","v":4.0000000000001004},{"$f":"Units!$D$22*BC2","v":5},{"$f":"0.01*$AG$2/BK14^0.5","v":0.91365737560641413},3,{"$f":"0.01*$AG$2/$AM$2^0.5*BM14","v":4.3338574618923502},{"$f":"$AK$2*(0.4/(4/BJ14-0.6))+10^-10","v":1.1795266000544797},{"$f":"1/(1/BR9^2+1/BN9^2)^0.5","v":1.0062981372474729},{"$f":"1/(1/BL14^2+1/BO14^2)^0.5","v":0.72230957700503939},{"$f":"BQ14+BP14","v":1.7286077142525123},{"$f":"IF(BS19-(0.01*BT19/BN14)^2<0.0002,0,BS19-(0.01*BT19/BN14)^2)","v":32.032946191431918},{"$f":"BT19-BU14","v":569.54115400426849},{"$f":"100*BQ14*BS14^0.5","v":408.81028674170733},{"$f":"(0.01*BU14/BO14)^2","v":12.01235482051302},{"$f":"100*BU14/$AG$2","v":200.10293036794286},null,null,null,null,null,null,null,400,{"$f":"IF(CE13=TRUE,0,CE14)","v":400},null,null,null,{"$f":"CF14/100+0.0000000000001","v":4.0000000000001004},{"$f":"Units!$E$22*BC2","v":6},{"$f":"0.01*$AG$2/CK14^0.5","v":0.83405125741767228},3,{"$f":"0.01*$AG$2/$AM$2^0.5*CM14","v":4.3338574618923502},{"$f":"$AK$2*(0.4/(4/CJ14-0.6))+10^-10","v":1.1795266000544797},{"$f":"1/(1/CR9^2+1/CN9^2)^0.5","v":1.194656697208569},{"$f":"1/(1/CL14^2+1/CO14^2)^0.5","v":0.68100000001925942},{"$f":"CQ14+CP14","v":1.8756566972278286},{"$f":"IF(CS19-(0.01*CT19/CN14)^2<0.0002,0,CS19-(0.01*CT19/CN14)^2)","v":19.618084100554416},{"$f":"CT19-CU14","v":529.14100527144114},{"$f":"100*CQ14*CS14^0.5","v":301.63060688649989},{"$f":"(0.01*CU14/CO14)^2","v":6.5393613661117174},{"$f":"100*CU14/$AG$2","v":147.64102148139983},null,null,null,null,null,null,null,400,{"$f":"IF(DE13=TRUE,0,DE14)","v":400},null,null,null,{"$f":"DF14/100+0.0000000000001","v":4.0000000000001004},{"$f":"Units!$F$22*BC2","v":6},{"$f":"0.01*$AG$2/DK14^0.5","v":0.83405125741767228},3,{"$f":"0.01*$AG$2/$AM$2^0.5*DM14","v":4.3338574618923502},{"$f":"$AK$2*(0.4/(4/DJ14-0.6))+10^-10","v":1.1795266000544797},{"$f":"1/(1/DR9^2+1/DN9^2)^0.5","v":1.0785077811225126},{"$f":"1/(1/DL14^2+1/DO14^2)^0.5","v":0.68100000001925942},{"$f":"DQ14+DP14","v":1.7595077811417719},{"$f":"IF(DS19-(0.01*DT19/DN14)^2<0.0002,0,DS19-(0.01*DT19/DN14)^2)","v":12.451143541655327},{"$f":"DT19-DU14","v":380.5641748280226},{"$f":"100*DQ14*DS14^0.5","v":240.29887183148045},{"$f":"(0.01*DU14/DO14)^2","v":4.1503811800822712},{"$f":"100*DU14/$AG$2","v":117.62059316274129}]
[null,{"$f":"Units!$Z$13","v":0.9},3,{"$f":"IF(DY3>DY7,\"?\",FP3)","v":3.998046875},null,null,{"$f":"IF(H12=0.0000000000001,0,AV16)","v":14.100000000000001},null,null,null,null,null,{"$f":"IF(N12=0.0000000000001,0,BV16)","v":12.100000000000001},null,null,null,null,null,{"$f":"IF(T12=0.0000000000001,0,CV16)","v":6.54},null,null,null,null,null,{"$f":"IF(Z12=0.0000000000001,0,DV16)","v":4.16},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$AU14/$AR$2","v":1.9457230250120281},{"$f":"$AV14/$BC$2","v":14.021622553405765},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BU14/$AR$2","v":1.800926373311486},{"$f":"BV14/$BC$2","v":12.01235482051302},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CU14/$AR$2","v":1.3287691933325987},{"$f":"CV14/$BC$2","v":6.5393613661117174},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DU14/$AR$2","v":1.0585853384646715},{"$f":"DV14/$BC$2","v":4.1503811800822712}]
[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,{"$f":"ROUND(CEILING(AU15,IF(AU15>=100,1,IF(AND(AU15<100,AU15>=10),0.1,IF(AND(AU15<10,AU15>=1),0.01,IF(AND(AU15<1,AU15>=0.1),0.001,0.0001))))),2)","v":1.95},{"$f":"CEILING(AV15,IF(AV15>=100,1,IF(AND(AV15<100,AV15>=10),0.1,IF(AND(AV15<10,AV15>=1),0.01,IF(AND(AV15<1,AV15>=0.1),0.001,0.0001)))))","v":14.100000000000001},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(CEILING(BU15,IF(BU15>=100,1,IF(AND(BU15<100,BU15>=10),0.1,IF(AND(BU15<10,BU15>=1),0.01,IF(AND(BU15<1,BU15>=0.1),0.001,0.0001))))),2)","v":1.81},{"$f":"CEILING(BV15,IF(BV15>=100,1,IF(AND(BV15<100,BV15>=10),0.1,IF(AND(BV15<10,BV15>=1),0.01,IF(AND(BV15<1,BV15>=0.1),0.001,0.0001)))))","v":12.100000000000001},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(CEILING(CU15,IF(CU15>=100,1,IF(AND(CU15<100,CU15>=10),0.1,IF(AND(CU15<10,CU15>=1),0.01,IF(AND(CU15<1,CU15>=0.1),0.001,0.0001))))),2)","v":1.33},{"$f":"CEILING(CV15,IF(CV15>=100,1,IF(AND(CV15<100,CV15>=10),0.1,IF(AND(CV15<10,CV15>=1),0.01,IF(AND(CV15<1,CV15>=0.1),0.001,0.0001)))))","v":6.54},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(CEILING(DU15,IF(DU15>=100,1,IF(AND(DU15<100,DU15>=10),0.1,IF(AND(DU15<10,DU15>=1),0.01,IF(AND(DU15<1,DU15>=0.1),0.001,0.0001))))),2)","v":1.06},{"$f":"CEILING(DV15,IF(DV15>=100,1,IF(AND(DV15<100,DV15>=10),0.1,IF(AND(DV15<10,DV15>=1),0.01,IF(AND(DV15<1,DV15>=0.1),0.001,0.0001)))))","v":4.16}]
[null,null,null,null,null,null,null,{"$f":"AJ19","v":4.0000000000001004},null,null,null,null,null,{"$f":"$BJ19","v":4.0000000000001004},null,null,null,null,null,{"$f":"CJ19","v":4.0000000000001004},null,null,null,null,null,{"$f":"$DJ19","v":4.0000000000001004}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(AU21&\" \"&$AZ$2=\"0.0001 GPM\",\"0 GPM\",AU21&\" \"&$AZ$2)","v":"2.26 GPM"},null,null,null,null,null,{"$f":"IF(BU21&\" \"&$AZ$2=\"0.0001 GPM\",\"0 GPM\",BU21&\" \"&$AZ$2)","v":"1.83 GPM"},null,null,null,null,null,{"$f":"IF(CU21&\" \"&$AZ$2=\"0.0001 GPM\",\"0 GPM\",CU21&\" \"&$AZ$2)","v":"1.38 GPM"},null,null,null,null,null,{"$f":"IF(DU21&\" \"&$AZ$2=\"0.0001 GPM\",\"0 GPM\",DU21&\" \"&$AZ$2)","v":"1.04 GPM"},null,null,false,"Pos2",null,null,null,"Pos",{"$f":"\"C\"&(6-AM19)","v":"C2"},{"$f":"\"KvC\"&(6-AM19)","v":"KvC2"},"Nb",{"$f":"\"KvL\"&(6-AM19)","v":"KvL2"},{"$f":"\"Kvs\"&(6-AM19)","v":"Kvs2"},{"$f":"\"B1\"","v":"B1"},{"$f":"\"B2\"","v":"B2"},"KvB","PB",{"$f":"\"q23\"","v":"q23"},{"$f":"\"q2\"","v":"q2"},null,null,null,null,null,null,null,null,null,false,"Pos2",null,null,null,"Pos",{"$f":"\"C\"&(6-BM19)","v":"C2"},{"$f":"\"KvC\"&(6-BM19)","v":"KvC2"},"Nb",{"$f":"\"KvL\"&(6-BM19)","v":"KvL2"},{"$f":"\"Kvs\"&(6-BM19)","v":"Kvs2"},{"$f":"\"B1\"","v":"B1"},{"$f":"\"B2\"","v":"B2"},"KvB","PB",{"$f":"\"q23\"","v":"q23"},{"$f":"\"q2\"","v":"q2"},null,null,null,null,null,null,null,null,null,false,"Pos2",null,null,null,"Pos",{"$f":"\"C\"&(6-CM19)","v":"C2"},{"$f":"\"KvC\"&(6-CM19)","v":"KvC2"},"Nb",{"$f":"\"KvL\"&(6-CM19)","v":"KvL2"},{"$f":"\"Kvs\"&(6-CM19)","v":"Kvs2"},{"$f":"\"B1\"","v":"B1"},{"$f":"\"B2\"","v":"B2"},"KvB","PB",{"$f":"\"q23\"","v":"q23"},{"$f":"\"q2\"","v":"q2"},null,null,null,null,null,null,null,null,null,false,"Pos2",null,null,null,"Pos",{"$f":"\"C\"&(6-DM19)","v":"C2"},{"$f":"\"KvC\"&(6-DM19)","v":"KvC2"},"Nb",{"$f":"\"KvL\"&(6-DM19)","v":"KvL2"},{"$f":"\"Kvs\"&(6-DM19)","v":"Kvs2"},{"$f":"\"B1\"","v":"B1"},{"$f":"\"B2\"","v":"B2"},"KvB","PB",{"$f":"\"q23\"","v":"q23"},{"$f":"\"q2\"","v":"q2"}]
[null,"Pumping costs",null,null,null,null,null,null,null,{"$f":"IF($AW19=0,\"0\",$AW19)","v":250.75130010340226},"%",null,null,null,null,{"$f":"IF($BW19=0,\"0\",$BW19)","v":203.11211074020852},"%",null,null,null,null,{"$f":"IF($CW19=0,\"0\",$CW19)","v":152.6195196021113},"%",null,null,null,null,{"$f":"IF($DW19=0,\"0\",$DW19)","v":114.82576040684474},"%",null,400,{"$f":"IF(AE18=TRUE,0,AE19)","v":400},null,null,null,{"$f":"AF19/100+0.0000000000001","v":4.0000000000001004},{"$f":"Units!$C$23*BC2","v":5},{"$f":"0.01*$AG$2/AK19^0.5","v":0.91365737560641413},4,{"$f":"0.01*$AG$2/$AM$2^0.5*AM19","v":5.7784766158564667},{"$f":"$AK$2*(0.4/(4/AJ19-0.6))+10^-10","v":1.1795266000544797},{"$f":"1/(1/AR14^2+1/AN14^2)^0.5","v":1.75366787311297},{"$f":"1/(1/AL19^2+1/AO19^2)^0.5","v":0.72230957700503939},{"$f":"AQ19+AP19","v":2.4759774501180094},{"$f":"IF(AS24-(0.01*AT24/AN19)^2<0.0002,0,AS24-(0.01*AT24/AN19)^2)","v":50.300971599636441},{"$f":"AT24-AU19","v":1243.756984993882},{"$f":"100*AQ19*AS19^0.5","v":512.28490611125085},{"$f":"(0.01*AU19/AO19)^2","v":18.862864347863198},{"$f":"100*AU19/$AG$2","v":250.75130010340226},null,null,null,null,null,null,null,400,{"$f":"IF(BE18=TRUE,0,BE19)","v":400},null,null,null,{"$f":"BF19/100+0.0000000000001","v":4.0000000000001004},{"$f":"Units!$D$23*BC2","v":6},{"$f":"0.01*$AG$2/BK19^0.5","v":0.83405125741767228},4,{"$f":"0.01*$AG$2/$AM$2^0.5*BM19","v":5.7784766158564667},{"$f":"$AK$2*(0.4/(4/BJ19-0.6))+10^-10","v":1.1795266000544797},{"$f":"1/(1/BR14^2+1/BN14^2)^0.5","v":1.6056016834056244},{"$f":"1/(1/BL19^2+1/BO19^2)^0.5","v":0.68100000001925942},{"$f":"BQ19+BP19","v":2.2866016834248839},{"$f":"IF(BS24-(0.01*BT24/BN19)^2<0.0002,0,BS24-(0.01*BT24/BN19)^2)","v":37.129076574308343},{"$f":"BT24-BU19","v":978.35144074597588},{"$f":"100*BQ19*BS19^0.5","v":414.95804224224599},{"$f":"(0.01*BU19/BO19)^2","v":12.376358856702728},{"$f":"100*BU19/$AG$2","v":203.11211074020852},null,null,null,null,null,null,null,400,{"$f":"IF(CE18=TRUE,0,CE19)","v":400},null,null,null,{"$f":"CF19/100+0.0000000000001","v":4.0000000000001004},{"$f":"Units!$E$23*BC2","v":7},{"$f":"0.01*$AG$2/CK19^0.5","v":0.77218141835785126},4,{"$f":"0.01*$AG$2/$AM$2^0.5*CM19","v":5.7784766158564667},{"$f":"$AK$2*(0.4/(4/CJ19-0.6))+10^-10","v":1.1795266000544797},{"$f":"1/(1/CR14^2+1/CN14^2)^0.5","v":1.7213594412727073},{"$f":"1/(1/CL19^2+1/CO19^2)^0.5","v":0.6460533259888438},{"$f":"CQ19+CP19","v":2.367412767261551},{"$f":"IF(CS24-(0.01*CT24/CN19)^2<0.0002,0,CS24-(0.01*CT24/CN19)^2)","v":23.292717762393508},{"$f":"CT24-CU19","v":830.77161215794104},{"$f":"100*CQ19*CS19^0.5","v":311.8016785471134},{"$f":"(0.01*CU19/CO19)^2","v":6.9878153278880415},{"$f":"100*CU19/$AG$2","v":152.6195196021113},null,null,null,null,null,null,null,400,{"$f":"IF(DE18=TRUE,0,DE19)","v":400},null,null,null,{"$f":"DF19/100+0.0000000000001","v":4.0000000000001004},{"$f":"Units!$F$23*BC2","v":8},{"$f":"0.01*$AG$2/DK19^0.5","v":0.72230957698205833},4,{"$f":"0.01*$AG$2/$AM$2^0.5*DM19","v":5.7784766158564667},{"$f":"$AK$2*(0.4/(4/DJ19-0.6))+10^-10","v":1.1795266000544797},{"$f":"1/(1/DR14^2+1/DN14^2)^0.5","v":1.6302722606670965},{"$f":"1/(1/DL19^2+1/DO19^2)^0.5","v":0.61598767698662449},{"$f":"DQ19+DP19","v":2.2462599376537211},{"$f":"IF(DS24-(0.01*DT24/DN19)^2<0.0002,0,DS24-(0.01*DT24/DN19)^2)","v":14.503450777639934},{"$f":"DT24-DU19","v":620.86304665950308},{"$f":"100*DQ19*DS19^0.5","v":234.58902851118384},{"$f":"(0.01*DU19/DO19)^2","v":3.9554865752318467},{"$f":"100*DU19/$AG$2","v":114.82576040684474}]
[null,{"$f":"(B34+3)*AG48/BB34/1.03","v":613.98129969333888},"%",null,null,null,{"$f":"IF(H17=0.0000000000001,0,AV21)","v":18.900000000000002},null,null,null,null,null,{"$f":"IF(N17=0.0000000000001,0,BV21)","v":12.4},null,null,null,null,null,{"$f":"IF(T17=0.0000000000001,0,CV21)","v":6.99},null,null,null,null,null,{"$f":"IF(Z17=0.0000000000001,0,DV21)","v":3.96},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$AU19/$AR$2","v":2.2567617009306207},{"$f":"$AV19/$BC$2","v":18.862864347863198},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BU19/$AR$2","v":1.8280089966618767},{"$f":"BV19/$BC$2","v":12.376358856702728},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CU19/$AR$2","v":1.3735756764190017},{"$f":"CV19/$BC$2","v":6.9878153278880415},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DU19/$AR$2","v":1.0334318436616028},{"$f":"DV19/$BC$2","v":3.9554865752318467}]
[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,{"$f":"ROUND(CEILING(AU20,IF(AU20>=100,1,IF(AND(AU20<100,AU20>=10),0.1,IF(AND(AU20<10,AU20>=1),0.01,IF(AND(AU20<1,AU20>=0.1),0.001,0.0001))))),2)","v":2.2599999999999998},{"$f":"CEILING(AV20,IF(AV20>=100,1,IF(AND(AV20<100,AV20>=10),0.1,IF(AND(AV20<10,AV20>=1),0.01,IF(AND(AV20<1,AV20>=0.1),0.001,0.0001)))))","v":18.900000000000002},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(CEILING(BU20,IF(BU20>=100,1,IF(AND(BU20<100,BU20>=10),0.1,IF(AND(BU20<10,BU20>=1),0.01,IF(AND(BU20<1,BU20>=0.1),0.001,0.0001))))),2)","v":1.83},{"$f":"CEILING(BV20,IF(BV20>=100,1,IF(AND(BV20<100,BV20>=10),0.1,IF(AND(BV20<10,BV20>=1),0.01,IF(AND(BV20<1,BV20>=0.1),0.001,0.0001)))))","v":12.4},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(CEILING(CU20,IF(CU20>=100,1,IF(AND(CU20<100,CU20>=10),0.1,IF(AND(CU20<10,CU20>=1),0.01,IF(AND(CU20<1,CU20>=0.1),0.001,0.0001))))),2)","v":1.38},{"$f":"CEILING(CV20,IF(CV20>=100,1,IF(AND(CV20<100,CV20>=10),0.1,IF(AND(CV20<10,CV20>=1),0.01,IF(AND(CV20<1,CV20>=0.1),0.001,0.0001)))))","v":6.99},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(CEILING(DU20,IF(DU20>=100,1,IF(AND(DU20<100,DU20>=10),0.1,IF(AND(DU20<10,DU20>=1),0.01,IF(AND(DU20<1,DU20>=0.1),0.001,0.0001))))),2)","v":1.04},{"$f":"CEILING(DV20,IF(DV20>=100,1,IF(AND(DV20<100,DV20>=10),0.1,IF(AND(DV20<10,DV20>=1),0.01,IF(AND(DV20<1,DV20>=0.1),0.001,0.0001)))))","v":3.96}]
[null,"Pump head",null,null,null,null,null,{"$f":"AJ24","v":4.0000000000001004},null,null,null,null,null,{"$f":"$BJ24","v":4.0000000000001004},null,null,null,null,null,{"$f":"CJ24","v":4.0000000000001004},null,null,null,null,null,{"$f":"$DJ24","v":4.0000000000001004}]
[null,"Optimum",null,null,null,null,null,null,null,{"$f":"IF(AU26&\" \"&$AZ$2=\"0.0001 GPM\",\"0 GPM\",AU26&\" \"&$AZ$2)","v":"2.32 GPM"},null,null,null,null,null,{"$f":"IF(BU26&\" \"&$AZ$2=\"0.0001 GPM\",\"0 GPM\",BU26&\" \"&$AZ$2)","v":"1.87 GPM"},null,null,null,null,null,{"$f":"IF(CU26&\" \"&$AZ$2=\"0.0001 GPM\",\"0 GPM\",CU26&\" \"&$AZ$2)","v":"1.66 GPM"},null,null,null,null,null,{"$f":"IF(DU26&\" \"&$AZ$2=\"0.0001 GPM\",\"0 GPM\",DU26&\" \"&$AZ$2)","v":"1.31 GPM"},null,null,false,"Pos1",null,null,null,"Pos",{"$f":"\"C\"&(6-AM24)","v":"C1"},{"$f":"\"KvC\"&(6-AM24)","v":"KvC1"},"Nb",{"$f":"\"KvL\"&(6-AM24)","v":"KvL1"},{"$f":"\"Kvs\"&(6-AM24)","v":"Kvs1"},{"$f":"\"A1\"","v":"A1"},{"$f":"\"A2\"","v":"A2"},"KvA","PA",{"$f":"\"q12\"","v":"q12"},{"$f":"\"q1\"","v":"q1"},null,null,null,null,null,null,null,null,null,false,"Pos1",null,null,null,"Pos",{"$f":"\"C\"&(6-BM24)","v":"C1"},{"$f":"\"KvC\"&(6-BM24)","v":"KvC1"},"Nb",{"$f":"\"KvL\"&(6-BM24)","v":"KvL1"},{"$f":"\"Kvs\"&(6-BM24)","v":"Kvs1"},{"$f":"\"A1\"","v":"A1"},{"$f":"\"A2\"","v":"A2"},"KvA","PA",{"$f":"\"q12\"","v":"q12"},{"$f":"\"q1\"","v":"q1"},null,null,null,null,null,null,null,null,null,false,"Pos1",null,null,null,"Pos",{"$f":"\"C\"&(6-CM24)","v":"C1"},{"$f":"\"KvC\"&(6-CM24)","v":"KvC1"},"Nb",{"$f":"\"KvL\"&(6-CM24)","v":"KvL1"},{"$f":"\"Kvs\"&(6-CM24)","v":"Kvs1"},{"$f":"\"A1\"","v":"A1"},{"$f":"\"A2\"","v":"A2"},"KvA","PA",{"$f":"\"q12\"","v":"q12"},{"$f":"\"q1\"","v":"q1"},null,null,null,null,null,null,null,null,null,false,"Pos1",null,null,null,"Pos",{"$f":"\"C\"&(6-DM24)","v":"C1"},{"$f":"\"KvC\"&(6-DM24)","v":"KvC1"},"Nb",{"$f":"\"KvL\"&(6-DM24)","v":"KvL1"},{"$f":"\"Kvs\"&(6-DM24)","v":"Kvs1"},{"$f":"\"A1\"","v":"A1"},{"$f":"\"A2\"","v":"A2"},"KvA","PA",{"$f":"\"q12\"","v":"q12"},{"$f":"\"q1\"","v":"q1"}]
[null,{"$f":"BB34&\" \"&$BA$2","v":"80 kPa"},null,null,null,null,null,null,null,{"$f":"IF($AW24=0,\"0\",$AW24)","v":257.19880297129635},"%",null,null,null,null,{"$f":"IF($BW24=0,\"0\",$BW24)","v":207.22690156789358},"%",null,null,null,null,{"$f":"IF($CW24=0,\"0\",$CW24)","v":184.39902245160775},"%",null,null,null,null,{"$f":"IF($DW24=0,\"0\",$DW24)","v":144.46049510087624},"%",null,400,{"$f":"IF(AE23=TRUE,0,AE24)","v":400},null,null,null,{"$f":"AF24/100+0.0000000000001","v":4.0000000000001004},{"$f":"Units!$C$24*BC2","v":6},{"$f":"0.01*$AG$2/AK24^0.5","v":0.83405125741767228},5,{"$f":"0.01*$AG$2/$AM$2^0.5*AM24","v":7.2230957698205831},{"$f":"$AK$2*(0.4/(4/AJ24-0.6))+10^-10","v":1.1795266000544797},{"$f":"1/(1/AR19^2+1/AN19^2)^0.5","v":2.2758554483510727},{"$f":"1/(1/AL24^2+1/AO24^2)^0.5","v":0.68100000001925942},{"$f":"AQ24+AP24","v":2.956855448370332},{"$f":"AS29-(0.01*AU29/AN24)^2-(0.01*AU29/AO29)^2","v":59.536101821513455},{"$f":"AU29-AU24","v":1756.0418911051329},{"$f":"100*AQ24*AS24^0.5","v":525.45715447035855},{"$f":"(0.01*AU24/AO24)^2","v":19.845367271592856},{"$f":"100*AU24/$AG$2","v":257.19880297129635},null,null,null,null,null,null,null,400,{"$f":"IF(BE23=TRUE,0,BE24)","v":400},null,null,null,{"$f":"BF24/100+0.0000000000001","v":4.0000000000001004},{"$f":"Units!$D$24*BC2","v":7},{"$f":"0.01*$AG$2/BK24^0.5","v":0.77218141835785126},5,{"$f":"0.01*$AG$2/$AM$2^0.5*BM24","v":7.2230957698205831},{"$f":"$AK$2*(0.4/(4/BJ24-0.6))+10^-10","v":1.1795266000544797},{"$f":"1/(1/BR19^2+1/BN19^2)^0.5","v":2.1261870049352694},{"$f":"1/(1/BL24^2+1/BO24^2)^0.5","v":0.6460533259888438},{"$f":"BQ24+BP24","v":2.772240330924113},{"$f":"BS29-(0.01*BU29/BN24)^2-(0.01*BU29/BO29)^2","v":42.942988731243425},{"$f":"BU29-BU24","v":1393.3094829882218},{"$f":"100*BQ24*BS24^0.5","v":423.36455990320661},{"$f":"(0.01*BU24/BO24)^2","v":12.882896617842794},{"$f":"100*BU24/$AG$2","v":207.22690156789358},null,null,null,null,null,null,null,400,{"$f":"IF(CE23=TRUE,0,CE24)","v":400},null,null,null,{"$f":"CF24/100+0.0000000000001","v":4.0000000000001004},{"$f":"Units!$E$24*BC2","v":5},{"$f":"0.01*$AG$2/CK24^0.5","v":0.91365737560641413},5,{"$f":"0.01*$AG$2/$AM$2^0.5*CM24","v":7.2230957698205831},{"$f":"$AK$2*(0.4/(4/CJ24-0.6))+10^-10","v":1.1795266000544797},{"$f":"1/(1/CR19^2+1/CN19^2)^0.5","v":2.1906876488401719},{"$f":"1/(1/CL24^2+1/CO24^2)^0.5","v":0.72230957700503939},{"$f":"CQ24+CP24","v":2.9129972258452113},{"$f":"CS29-(0.01*CU29/CN24)^2-(0.01*CU29/CO29)^2","v":27.202399583155881},{"$f":"CU29-CU24","v":1142.5732907050544},{"$f":"100*CQ24*CS24^0.5","v":376.72720286863461},{"$f":"(0.01*CU24/CO24)^2","v":10.200899842601615},{"$f":"100*CU24/$AG$2","v":184.39902245160775},null,null,null,null,null,null,null,400,{"$f":"IF(DE23=TRUE,0,DE24)","v":400},null,null,null,{"$f":"DF24/100+0.0000000000001","v":4.0000000000001004},{"$f":"Units!$F$24*BC2","v":5},{"$f":"0.01*$AG$2/DK24^0.5","v":0.91365737560641413},5,{"$f":"0.01*$AG$2/$AM$2^0.5*DM24","v":7.2230957698205831},{"$f":"$AK$2*(0.4/(4/DJ24-0.6))+10^-10","v":1.1795266000544797},{"$f":"1/(1/DR19^2+1/DN19^2)^0.5","v":2.0936379974682549},{"$f":"1/(1/DL24^2+1/DO24^2)^0.5","v":0.72230957700503939},{"$f":"DQ24+DP24","v":2.8159475744732942},{"$f":"DS29-(0.01*DU29/DN24)^2-(0.01*DU29/DO29)^2","v":16.695067714769891},{"$f":"DU29-DU24","v":855.45207517068695},{"$f":"100*DQ24*DS24^0.5","v":295.13279149109019},{"$f":"(0.01*DU24/DO24)^2","v":6.2606503923747452},{"$f":"100*DU24/$AG$2","v":144.46049510087624}]
[null,"Nominal",null,null,null,null,{"$f":"IF(H22=0.0000000000001,0,AV26)","v":19.900000000000002},null,null,null,null,null,{"$f":"IF(N22=0.0000000000001,0,BV26)","v":12.9},null,null,null,null,null,{"$f":"IF(T22=0.0000000000001,0,CV26)","v":10.3},null,null,null,null,null,{"$f":"IF(Z22=0.0000000000001,0,DV26)","v":6.2700000000000005},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$AU24/$AR$2","v":2.3147892267416674},{"$f":"AV24/$BC$2","v":19.845367271592856},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BU24/$AR$2","v":1.8650421141110423},{"$f":"BV24/$BC$2","v":12.882896617842794},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CU24/$AR$2","v":1.6595912020644696},{"$f":"CV24/$BC$2","v":10.200899842601615},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DU24/$AR$2","v":1.3001444559078863},{"$f":"DV24/$BC$2","v":6.2606503923747452}]
[null,{"$f":"AG48&\" \"&$BA$2","v":"300 kPa"},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,{"$f":"ROUND(CEILING(AU25,IF(AU25>=100,1,IF(AND(AU25<100,AU25>=10),0.1,IF(AND(AU25<10,AU25>=1),0.01,IF(AND(AU25<1,AU25>=0.1),0.001,0.0001))))),2)","v":2.3199999999999998},{"$f":"IF(CEILING(AV25,IF(AV25>=100,1,IF(AND(AV25<100,AV25>=10),0.1,IF(AND(AV25<10,AV25>=1),0.01,IF(AND(AV25<1,AV25>=0.1),0.001,0.0001)))))=0.0001,0,CEILING(AV25,IF(AV25>=100,1,IF(AND(AV25<100,AV25>=10),0.1,IF(AND(AV25<10,AV25>=1),0.01,IF(AND(AV25<1,AV25>=0.1),0.001,0.0001))))))","v":19.900000000000002},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(CEILING(BU25,IF(BU25>=100,1,IF(AND(BU25<100,BU25>=10),0.1,IF(AND(BU25<10,BU25>=1),0.01,IF(AND(BU25<1,BU25>=0.1),0.001,0.0001))))),2)","v":1.87},{"$f":"IF(CEILING(BV25,IF(BV25>=100,1,IF(AND(BV25<100,BV25>=10),0.1,IF(AND(BV25<10,BV25>=1),0.01,IF(AND(BV25<1,BV25>=0.1),0.001,0.0001)))))=0.0001,0,CEILING(BV25,IF(BV25>=100,1,IF(AND(BV25<100,BV25>=10),0.1,IF(AND(BV25<10,BV25>=1),0.01,IF(AND(BV25<1,BV25>=0.1),0.001,0.0001))))))","v":12.9},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(CEILING(CU25,IF(CU25>=100,1,IF(AND(CU25<100,CU25>=10),0.1,IF(AND(CU25<10,CU25>=1),0.01,IF(AND(CU25<1,CU25>=0.1),0.001,0.0001))))),2)","v":1.66},{"$f":"IF(CEILING(CV25,IF(CV25>=100,1,IF(AND(CV25<100,CV25>=10),0.1,IF(AND(CV25<10,CV25>=1),0.01,IF(AND(CV25<1,CV25>=0.1),0.001,0.0001)))))=0.0001,0,CEILING(CV25,IF(CV25>=100,1,IF(AND(CV25<100,CV25>=10),0.1,IF(AND(CV25<10,CV25>=1),0.01,IF(AND(CV25<1,CV25>=0.1),0.001,0.0001))))))","v":10.3},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(CEILING(DU25,IF(DU25>=100,1,IF(AND(DU25<100,DU25>=10),0.1,IF(AND(DU25<10,DU25>=1),0.01,IF(AND(DU25<1,DU25>=0.1),0.001,0.0001))))),2)","v":1.31},{"$f":"IF(CEILING(DV25,IF(DV25>=100,1,IF(AND(DV25<100,DV25>=10),0.1,IF(AND(DV25<10,DV25>=1),0.01,IF(AND(DV25<1,DV25>=0.1),0.001,0.0001)))))=0.0001,0,CEILING(DV25,IF(DV25>=100,1,IF(AND(DV25<100,DV25>=10),0.1,IF(AND(DV25<10,DV25>=1),0.01,IF(AND(DV25<1,DV25>=0.1),0.001,0.0001))))))","v":6.2700000000000005}]
[null,"Operating",null,{"$f":"AV31&\" \"&$BA$2","v":"15 kPa"},null,null,null,{"$f":"AJ29","v":4.0000000000001004},null,{"$f":"BV31&\" \"&$BA$2","v":"9.49 kPa"},null,null,null,{"$f":"$BJ$29","v":4.0000000000001004},null,{"$f":"CV31&\" \"&$BA$2","v":"6.64 kPa"},null,null,null,{"$f":"$CJ29","v":4.0000000000001004},null,{"$f":"DV31&\" \"&$BA$2","v":"3.81 kPa"},null,null,null,{"$f":"DJ29","v":4.0000000000001004}]
[null,{"$f":"AH48&\" \"&$BA$2","v":"126 kPa"},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,false,"PosF",null,null,null,"Pos",null,null,null,null,{"$f":"\"Kvs\"&(6-AM29)","v":"Kvs6"},null,null,"KvF","pF",null,"qF",null,null,null,null,null,null,null,null,null,false,"PosF",null,null,null,"Pos",null,null,null,null,{"$f":"\"Kvs\"&(6-BM29)","v":"Kvs6"},null,null,"KvF","pF",null,"qF",null,null,null,null,null,null,null,null,null,false,"PosF",null,null,null,"Pos",null,null,null,null,{"$f":"\"Kvs\"&(6-CM29)","v":"Kvs6"},null,null,"KvF","pF",null,"qF",null,null,null,null,null,null,null,null,null,false,"PosF",null,null,null,"Pos",null,null,null,null,{"$f":"\"Kvs\"&(6-DM29)","v":"Kvs6"},null,null,"KvF","pF",null,"qF"]
[null,null,null,null,{"$f":"IF(AJ36=0.010001,\"0.00\",AJ36)","v":4.0000010000000001},null,{"$f":"IF(AU31&\" \"&$AZ$2=\"0.0001 GPM\",\"0 GPM\",AU31&\" \"&$AZ$2)","v":"10.1 GPM"},null,null,{"$f":"IF($AW29=0,\"0\",$AW29)","v":223.34792418751749},"%",null,{"$f":"IF(BU31&\" \"&$AZ$2=\"0.0001 GPM\",\"0 GPM\",BU31&\" \"&$AZ$2)","v":"8.01 GPM"},null,null,{"$f":"IF($BW29=0,\"0\",$BW29)","v":177.84376337654706},"%",null,{"$f":"IF(CU31&\" \"&$AZ$2=\"0.0001 GPM\",\"0 GPM\",CU31&\" \"&$AZ$2)","v":"6.7 GPM"},null,null,{"$f":"IF($CW29=0,\"0\",$CW29)","v":148.73230480408114},"%",null,{"$f":"IF(DU31&\" \"&$AZ$2=\"0.0001 GPM\",\"0 GPM\",DU31&\" \"&$AZ$2)","v":"5.07 GPM"},null,null,{"$f":"IF($DW29=0,\"0\",$DW29)","v":112.63679556160325},"%",null,400,{"$f":"IF(AE28=TRUE,0,AE29)","v":400},null,null,null,{"$f":"AF29/100+0.0000000000001","v":4.0000000000001004},null,null,null,null,{"$f":"5*$AK$2*(0.4/(4/AJ29-0.6))+10^-10","v":5.897632999872398},null,null,{"$f":"1/(1/AO29^2+1/AR24^2+1/AN24^2)^0.5","v":2.4822632553420081},{"$f":"AR39","v":84.478249440440607},null,{"$f":"100*AR29*AS29^0.5","v":2281.4990455754914},{"$f":"(0.01*AU29/AO29)^2","v":14.965288571152541},{"$f":"100*AU29/5/$AG$2","v":223.34792418751749},null,null,null,null,null,null,null,400,{"$f":"IF(BE28=TRUE,0,BE29)","v":400},null,null,null,{"$f":"BF29/100+0.0000000000001","v":4.0000000000001004},null,null,null,null,{"$f":"5*$AK$2*(0.4/(4/BJ29-0.6))+10^-10","v":5.897632999872398},null,null,{"$f":"1/(1/BO29^2+1/BR24^2+1/BN24^2)^0.5","v":2.3699899202792634},{"$f":"AS39","v":58.757190816887089},null,{"$f":"100*BR29*BS29^0.5","v":1816.6740428914284},{"$f":"(0.01*BU29/BO29)^2","v":9.4885212512570138},{"$f":"100*BU29/5/$AG$2","v":177.84376337654706},null,null,null,null,null,null,null,400,{"$f":"IF(CE28=TRUE,0,CE29)","v":400},null,null,null,{"$f":"CF29/100+0.0000000000001","v":4.0000000000001004},null,null,null,null,{"$f":"5*$AK$2*(0.4/(4/CJ29-0.6))+10^-10","v":5.897632999872398},null,null,{"$f":"1/(1/CO29^2+1/CR24^2+1/CN24^2)^0.5","v":2.4561443828285028},{"$f":"AT39","v":38.263048829097045},null,{"$f":"100*CR29*CS29^0.5","v":1519.300493573689},{"$f":"(0.01*CU29/CO29)^2","v":6.6363895474743435},{"$f":"100*CU29/5/$AG$2","v":148.73230480408114},null,null,null,null,null,null,null,400,{"$f":"IF(DE28=TRUE,0,DE29)","v":400},null,null,null,{"$f":"DF29/100+0.0000000000001","v":4.0000000000001004},null,null,null,null,{"$f":"5*$AK$2*(0.4/(4/DJ29-0.6))+10^-10","v":5.897632999872398},null,null,{"$f":"1/(1/DO29^2+1/DR24^2+1/DN24^2)^0.5","v":2.3971250744271204},{"$f":"AU39","v":23.038591571833543},null,{"$f":"100*DR29*DS29^0.5","v":1150.5848666617771},{"$f":"(0.01*DU29/DO29)^2","v":3.8061143141863694},{"$f":"100*DU29/5/$AG$2","v":112.63679556160325}]
[null,null,null,null,null,null,{"$f":"IF(AU49&\" \"&$AZ$2=\"0.0001 GPM\",\"0 GPM\",AU49&\" \"&$AZ$2)","v":"10.07 GPM"},null,null,null,null,null,{"$f":"IF(BU32&\" \"&$AZ$2=\"0.0001 GPM\",\"0 GPM\",BU32&\" \"&$AZ$2)","v":"8.03 GPM"},null,null,null,null,null,{"$f":"IF(CU32&\" \"&$AZ$2=\"0.0001 GPM\",\"0 GPM\",CU32&\" \"&$AZ$2)","v":"6.71 GPM"},null,null,null,null,null,{"$f":"IF(DU32&\" \"&$AZ$2=\"0.0001 GPM\",\"0 GPM\",DU32&\" \"&$AZ$2)","v":"5.09 GPM"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$AU29/$AR$2","v":10.050656588438288},{"$f":"$AV29/$BC$2","v":14.965288571152541},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BU29/$AR$2","v":8.0029693519446177},{"$f":"BV29/$BC$2","v":9.4885212512570138},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CU29/$AR$2","v":6.6929537161836521},{"$f":"CV29/$BC$2","v":6.6363895474743435},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DU29/$AR$2","v":5.068655800272146},{"$f":"DV29/$BC$2","v":3.8061143141863694}]
[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,"Kv colonnes",null,null,null,null,"Kv lignes",null,null,null,null,null,null,null,null,{"$f":"ROUND(CEILING(AU30,IF(AU30>=100,1,IF(AND(AU30<100,AU30>=10),0.1,IF(AND(AU30<10,AU30>=1),0.01,IF(AND(AU30<1,AU30>=0.1),0.001,0.0001))))),2)","v":10.1},{"$f":"ROUND(IF(AU31>0,CEILING(AV30,IF(AV30>=100,1,IF(AND(AV30<100,AV30>=10),0.1,IF(AND(AV30<10,AV30>=1),0.01,IF(AND(AV30<1,AV30>=0.1),0.001,0.0001))))),\"0\"),2)","v":15},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(CEILING(BU30,IF(BU30>=100,1,IF(AND(BU30<100,BU30>=10),0.1,IF(AND(BU30<10,BU30>=1),0.01,IF(AND(BU30<1,BU30>=0.1),0.001,0.0001))))),2)","v":8.01},{"$f":"ROUND(IF(BU31>0,CEILING(BV30,IF(BV30>=100,1,IF(AND(BV30<100,BV30>=10),0.1,IF(AND(BV30<10,BV30>=1),0.01,IF(AND(BV30<1,BV30>=0.1),0.001,0.0001))))),\"0\"),2)","v":9.49},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(CEILING(CU30,IF(CU30>=100,1,IF(AND(CU30<100,CU30>=10),0.1,IF(AND(CU30<10,CU30>=1),0.01,IF(AND(CU30<1,CU30>=0.1),0.001,0.0001))))),2)","v":6.7},{"$f":"ROUND(IF(CU31>0,CEILING(CV30,IF(CV30>=100,1,IF(AND(CV30<100,CV30>=10),0.1,IF(AND(CV30<10,CV30>=1),0.01,IF(AND(CV30<1,CV30>=0.1),0.001,0.0001))))),\"0\"),2)","v":6.64},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(CEILING(DU30,IF(DU30>=100,1,IF(AND(DU30<100,DU30>=10),0.1,IF(AND(DU30<10,DU30>=1),0.01,IF(AND(DU30<1,DU30>=0.1),0.001,0.0001))))),2)","v":5.07},{"$f":"ROUND(IF(DU31>0,CEILING(DV30,IF(DV30>=100,1,IF(AND(DV30<100,DV30>=10),0.1,IF(AND(DV30<10,DV30>=1),0.01,IF(AND(DV30<1,DV30>=0.1),0.001,0.0001))))),\"0\"),2)","v":3.81}]
[null,"Total flow",null,{"$f":"IF(OR(AX38&\" \"&$BA$2=\"0.0001 psi\",AX38&\" \"&$BA$2=\"48.4 psi\"),\"0 psi\",AX38&\" \"&$BA$2)","v":"8.24 kPa"},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,"LL","KvF1","KvF2","KvF3","KvF4",null,null,"L34","L23","L12","L01","Kv0","Kv1","Kv2","Kv3","Kv4",null,null,null,null,{"$f":"$AM$2+6+MAX(MAX(MAX(MAX(AK4+$AM$2,AK9)+$AM$2,AK14)+$AM$2,AK19)+$AM$2,AK24)","v":21},null,{"$f":"$AI$2+AF33+MAX(MAX(MAX(DZ32+AF33,CZ32)+AF33,BZ32)+AF33,AZ32)","v":80},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(BU6=0,0,IF(BV6>=Units!$F$38,Units!Z13,Data!BU6))+BU11+BU16+BU21+IF(BU26=0,0,IF(BV26>=Units!$F$38,Units!Z13,Data!BU26))","v":8.0300000000000011},null,null,null,null,{"$f":"$AM$2+6+MAX(MAX(MAX(MAX(BK4+$AM$2,BK9)+$AM$2,BK14)+$AM$2,BK19)+$AM$2,BK24)","v":26},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CU6+IF(CU11=0,0,IF(CV11>=Units!$F$38,Units!Z13,Data!CU11))+CU16+CU21+CU26","v":6.71},null,null,null,null,{"$f":"$AM$2+6+MAX(MAX(MAX(MAX(CK4+$AM$2,CK9)+$AM$2,CK14)+$AM$2,CK19)+$AM$2,CK24)","v":23},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DU6+DU11+DU16+IF(DU21=0,0,IF(DV21>=Units!$F$38,Units!Z13,Data!DU21))+DU26","v":5.09},null,null,null,null,{"$f":"$AM$2+6+MAX(MAX(MAX(MAX(DK4+$AM$2,DK9)+$AM$2,DK14)+$AM$2,DK19)+$AM$2,DK24)","v":29}]
[null,{"$f":"IF(OR(AK40&\" \"&AZ2=\"0.0001 GPM\",AK40&\" \"&AZ2=\"0.0443 GPM\"),\"0 GPM\",AK40&\" \"&AZ2)","v":"29.9 GPM"},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,{"$f":"Units!$W$11","v":12},{"$f":"AR29","v":2.4822632553420081},{"$f":"BR29","v":2.3699899202792634},{"$f":"CR29","v":2.4561443828285028},{"$f":"DR29","v":2.3971250744271204},null,null,{"$f":"0.01*5*$AG$2/$AF$33^0.5","v":2.9488164998860142},{"$f":"0.01*10*$AG$2/$AF$33^0.5","v":5.8976329997720285},{"$f":"0.01*15*$AG$2/$AF$33^0.5","v":8.8464494996580409},{"$f":"0.01*20*$AG$2/$AF$33^0.5","v":11.795265999544057},{"$f":"1/(1/AR33^2+1/AO36^2+1/AP33^2+1/AM36^2)^0.5","v":3.3840292243511896},{"$f":"AG33+1/(1/AS33^2+1/AO33^2)^0.5","v":7.363624731643597},{"$f":"AH33+1/(1/AT33^2+1/AN33^2)^0.5","v":5.8530591130267791},{"$f":"AI33+1/(1/AU33^2+1/AM33^2)^0.5","v":4.316212597886798},{"$f":"AJ33","v":2.3971250744271204},null,null,null,null,null,null,{"$f":"BB32/$BC$2","v":80}]
[null,{"$f":"IF($AM38<=1,\"0\",$AM38)","v":165.64019698243706},"%",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,"STAD",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CEILING(BB33,IF(BB33>=100,1,IF(AND(BB33<100,BB33>=10),0.1,IF(AND(BB33<10,BB33>=1),0.01,IF(AND(BB33<1,BB33>=0.1),0.001,0.0001)))))","v":80}]
[null,{"$f":"IF(OR(AK42&\" \"&AZ2=\"0.0001 GPM\",AK42&\" \"&AZ2=\"0.0443 GPM\"),\"0 GPM\",AK42&\" \"&AZ2)","v":"29.9 GPM"},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,false,"Pos0","ts",null,"Pos",null,null,"Kvf",null,"Kvso",null,null,"q1","q2","q3","q4",null,null,"STADo"]
[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,400,{"$f":"IF(AF35=TRUE,0,AF36)","v":400},81,null,{"$f":"AG36/100+0.000001","v":4.0000010000000001},null,null,{"$f":"0.01*3^0.5*20*$AG$2/AM41^0.5","v":4.0859999999999994},null,{"$f":"20*$AK$2*0.4/(4/AJ36-0.6)+10^-10","v":23.590546743276139},null,null,{"$f":"100*AG33*AR39^0.5","v":2281.4990455754914},{"$f":"100*AH33*AS39^0.5","v":1816.6740428914284},{"$f":"100*AI33*AT39^0.5","v":1519.300493573689},{"$f":"100*AJ33*AU39^0.5","v":1150.5848666617771},null,null,{"$f":"(0.01*AK38/AO36)^2","v":8.2309921680971012}]
[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,"%",{"$f":"100*AR36/5/$AG$2","v":223.34792418751749},{"$f":"100*AS36/5/$AG$2","v":177.84376337654706},{"$f":"100*AT36/5/$AG$2","v":148.73230480408114},{"$f":"100*AU36/5/$AG$2","v":112.63679556160325},null,null,{"$f":"AX36/$BC$2","v":8.2309921680971012}]
[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,"Pump head",null,{"$f":"4/3*AM41","v":400},null,"qT=",{"$f":"100*AQ33*AH38^0.5","v":6768.0584487023789},"q%=",{"$f":"100*AK38/20/AG2","v":165.64019698243706},null,null,null,null,"P1","P2","P3","P4",null,null,{"$f":"CEILING(AX37,IF(AX37>=100,1,IF(AND(AX37<100,AX37>=10),0.1,IF(AND(AX37<10,AX37>=1),0.01,IF(AND(AX37<1,AX37>=0.1),0.001,0.0001)))))","v":8.24}]
[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,{"$f":"$AK38/$AR$2","v":29.815235456838675},null,null,null,null,null,null,{"$f":"AH38-(0.01*AK38)^2*(1/AP33^2+1/AO36^2+1/AM36^2)","v":84.478249440440607},{"$f":"AR39-(0.01*AS41/AO33)^2","v":58.757190816887089},{"$f":"AS39-(0.01*AT41/AN33)^2","v":38.263048829097045},{"$f":"AT39-(0.01*AU41/AM33)^2","v":23.038591571833543}]
[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,"Pump head",null,{"$f":"AH38-(0.01*AK38/AM36)^2","v":125.63325143619431},null,null,{"$f":"CEILING(AK39,IF(AK39>=100,1,IF(AND(AK39<100,AK39>=10),0.1,IF(AND(AK39<10,AK39>=1),0.01,IF(AND(AK39<1,AK39>=0.1),0.001,0.0001)))))","v":29.900000000000002},null,null,null,null,null,null,"q10","q12","q23","q34"]
[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,"Nominal pump head",null,null,{"$f":"AF44","v":300},null,null,null,null,{"$f":"AK38","v":6768.0584487023789},{"$f":"AK38-AR36","v":4486.5594031268874},{"$f":"AS41-AS36","v":2669.8853602354593},{"$f":"AT41-AT36","v":1150.5848666617703}]
[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,{"$f":"AU49+BU32+CU32+DU32","v":29.900000000000002},null,null,null,null,null,"%",{"$f":"AM38","v":165.64019698243706},{"$f":"100*AS41/15/$AG$2","v":146.40428791407692},{"$f":"100*AT41/10/$AG$2","v":130.68455018284189},{"$f":"100*AU41/5/$AG$2","v":112.63679556160257}]
[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,"Pump",null,null,null,"Pump"]
[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,300,null,null,null,{"$f":"AF44/$AS$2","v":300}]
[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,"kPa",null,"Opera.",null,"Units Dp"]
[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,"Dp",{"$f":"AF44","v":300},{"$f":"AH40","v":125.63325143619431}]
[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,{"$f":"AG46/$BC$2","v":300},{"$f":"AH46/$BC$2","v":125.63325143619431},{"$f":"AI46/$BC$2","v":0}]
[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,{"$f":"CEILING(AG47,IF(AG47>=100,1,IF(AND(AG47<100,AG47>=10),0.1,IF(AND(AG47<10,AG47>=1),0.01,IF(AND(AG47<1,AG47>=0.1),0.001,0.0001)))))","v":300},{"$f":"CEILING(AH47,IF(AH47>=100,1,IF(AND(AH47<100,AH47>=10),0.1,IF(AND(AH47<10,AH47>=1),0.01,IF(AND(AH47<1,AH47>=0.1),0.001,0.0001)))))","v":126},{"$f":"CEILING(AI47,IF(AI47>=100,1,IF(AND(AI47<100,AI47>=10),0.1,IF(AND(AI47<10,AI47>=1),0.01,IF(AND(AI47<1,AI47>=0.1),0.001,0.0001)))))","v":0}]
[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,{"$f":"AU6+AU11+IF(AU16=0,0,IF(AV16>=Units!$F$38,Units!Z13,Data!AU16))+AU21+AU26","v":10.07}]