{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Error","All Systems","Summary","Report Template","Report","Pipe Details (104)","Pump Details","Pipe Details (Template)","Help Guide","Pipe Velocity Check","Lookup Values","Pipe System Lookup Values","Water Properties","Worksheet"],"not_rendered":{"charts":0,"images":33,"macros":1,"external_links":0,"defined_names":89,"comments":4,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Error","index":0,"n_rows":3,"n_cols":1,"rows_kept":3,"cut":false,"hidden":false,"merged":[[2,0,2,5]]}
[]
[]
["The Pump System Calculator requires macros to function. Please choose Enable Macros when opening the workbook. If this option is not available, then please see your IT administrator to ensure you have the appropriate privileges to enable macros.\nThe navigation ribbon above relies upon the macros to function, and so will be non-responsive. Please close the workbook using the close button within the title bar in the top right corner, or use the File menu (which does not depend on macros) to select Close.\nYou can then re-open the workbook, this time choosing to enable macros.\n\nThis sheet will also appear while the Calculator is loading. Please wait a few seconds to allow it to initialise."]

{"sheet":"All Systems","index":1,"n_rows":23,"n_cols":47,"rows_kept":23,"cut":false,"hidden":true,"merged":[[1,1,1,17],[3,13,3,17],[10,46,11,46],[5,1,5,3],[4,1,4,3],[9,1,9,45],[10,2,11,2],[10,3,11,3],[10,4,11,4],[10,5,11,6],[10,7,10,9],[10,42,10,45],[3,1,3,11],[4,5,4,7],[5,5,5,7],[10,39,10,41],[18,1,18,17],[23,1,23,3],[10,10,10,12],[4,8,4,11],[5,8,5,11],[20,1,20,17],[12,16,12,17],[13,16,13,17],[17,1,17,17],[10,13,10,15],[10,16,11,17],[10,1,11,1],[14,16,14,17]]}
[]
[null,"Calculator  "]
[]
[null,"Project Information",null,null,null,null,null,null,null,null,null,null,null,"Colour Guide"]
[null,"Building Name and Description",null,null,"Project Number","Designer",null,null,"Company",null,null,null,null,"Input","Calculated","N/A","Satisfactory","Not Satisfactory"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Gold","White","Grey","Green","Red"]
[]
[null,null,null,null,"Formula reference","VBA reference","Row number"]
[null,null,"Active System",1,{"$f":"CONCATENATE(\"'\",F9,\"'\")","v":"'Pipe Details (104)'"},"Pipe Details (104)",{"$f":"14+Active_System_Number","v":15},null,"Next ID Number",105]
[null,"Systems"]
[null,"Controls","ID","System Description","Pump Tag","Configuration",null,"Straight Pipe PD (Pa/m)",null,null,"Energy Efficiency Index",null,null,"Minimum Efficiency Index",null,null,"Summary",null,{"$f":"Summary!B9","v":"Pipe System Type"},{"$f":"Summary!C9","v":"System Speed Control"},{"$f":"Summary!D9","v":"Operating Hours Per Annum"},{"$f":"Summary!B15","v":"Pump Configuration"},{"$f":"Summary!C15","v":"Pump Design"},{"$f":"Summary!D15","v":"Pump Stages"},{"$f":"Summary!E15","v":"Pump Speed"},{"$f":"'Pump Details'!B13","v":"Energy Efficiency Index"},{"$f":"'Pump Details'!C13","v":"Hydraulic Power Output"},{"$f":"'Pump Details'!B19","v":"Method"},{"$f":"'Pump Details'!B25","v":"Minimum Efficiency Index"},{"$f":"'Pump Details'!B29","v":"Water Flow Rate"},"Water Flow Units",{"$f":"'Pump Details'!C29","v":"System Head"},"System Head Units",{"$f":"'Pump Details'!D29","v":"Number of series impellers"},{"$f":"'Pump Details'!E29","v":"Efficiency at Best Efficiency Point"},"Duct Worksheet name (VBA)","Duct worksheet name (Excel)","Active & Compliant","Summary","Component Requirements",null,null,"System Requirements",null,null,null,"Pipe Method"]
[null,null,null,null,null,null,null,"System","Allowable",null,"System","Allowable",null,"System","Allowable",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":"Summary!B22","v":"Pipe"},{"$f":"Summary!C22","v":"Pump"},{"$f":"Summary!D22","v":"Overall"},{"$f":"Summary!C26","v":"Pump"},{"$f":"Summary!B26","v":"Pipe"},{"$f":"Summary!D26","v":"Motor Power"},{"$f":"Summary!E26","v":"Overall"}]
[null,null,2,null,null,"Incomplete",null,"TBC","TBC",null,null,null,null,null,null,null,"Insufficient Data",null,"-Select-","-Select-","-Select-","-Select-","-Select-","-Select-","-Select-",null,null,"None",null,null,"L/s",null,"kPa",null,null,"Pipe Details (Template)",{"$f":"CONCATENATE(\"'\",AJ13,\"'\")","v":"'Pipe Details (Template)'"},{"$f":"CONCATENATE(IF(C13=Active_System_Number,1,0),Q13)","v":"0Insufficient Data"},"More data is required to evaluate the system on either component or systemic levels.\r\nMore data is required before the pump can be evaluated.\r\nMore data is required before the pipework can be evaluated.\r\nEnsure that you select a pipe system type using the drop down menu.\r\nEnsure that you select the system's speed control using the drop down menu.\r\nEnsure that you enter the number of hours per annum that the system operates.\r\nEnsure that you select the pump configuration using the drop down menu.\r\nEnsure that you select the pump design using the drop down menu.\r\nEnsure that you select whether the pump is single or multistage.\r\nEnsure that you select the pump's speed from the drop down menu.","Insufficient Data","Insufficient Data","Insufficient Data","Insufficient Data","Insufficient Data","Insufficient Data","Insufficient Data"]
[null,null,1,null,null,"Incomplete",null,"TBC","TBC",null,null,"<0.27",null,null,null,null,"Insufficient Data",null,"Non-distributive","Constant Speed","2000 or Less","Circulator","End Suction Close Coupled","-Select-","-Select-",null,null,"None",null,null,"L/s",null,"kPa",null,null,"Pipe Details (84)","'Pipe Details (84)'","1Insufficient Data","More data is required to evaluate the system on either component or systemic levels.\r\nMore data is required before the pump can be evaluated.\r\nMore data is required before the pipework can be evaluated.\r\nEnsure that you select whether the pump is single or multistage.\r\nEnsure that you select the pump's speed from the drop down menu.","Insufficient Data","Insufficient Data","Insufficient Data","Insufficient Data","Insufficient Data","Insufficient Data","Insufficient Data"]
[null,null,1,null,null,"Incomplete",null,"TBC","TBC",null,null,null,null,null,null,null,"Insufficient Data",null,"-Select-","-Select-","-Select-","-Select-","-Select-","-Select-","-Select-",null,null,"None",null,null,"L/s",null,"kPa",null,null,"Pipe Details (104)",{"$f":"CONCATENATE(\"'\",AJ15,\"'\")","v":"'Pipe Details (104)'"},{"$f":"CONCATENATE(IF(C15=Active_System_Number,1,0),Q15)","v":"1Insufficient Data"},"More data is required to evaluate the system on either component or systemic levels.\r\nMore data is required before the pump can be evaluated.\r\nMore data is required before the pipework can be evaluated.\r\nEnsure that you select a pipe system type using the drop down menu.\r\nEnsure that you select the system's speed control using the drop down menu.\r\nEnsure that you enter the number of hours per annum that the system operates.\r\nEnsure that you select the pump configuration using the drop down menu.\r\nEnsure that you select the pump design using the drop down menu.\r\nEnsure that you select whether the pump is single or multistage.\r\nEnsure that you select the pump's speed from the drop down menu.","Insufficient Data","Insufficient Data","Insufficient Data","Insufficient Data","Insufficient Data","Insufficient Data","Insufficient Data","Z"]
[null,"Complete",null,null,"Complete",null,"TBC","TBC",null,null,null,null,null,"TBC",null,"Not Applicable",null,null,"Axial - other","Ducted","Ducted","No","Smoke spill only",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"The system is of a type covered by J5.4(e), and thus it is not required to comply with the other elements of J5.4. Component results are displayed below only to aid in the design process.\r\n\r\nMore data is required before the length of flexible duct can be evaluated.\r\nMore data is required before the index run's straight duct can be evaluated.\r\nMore data is required before the duct fittings in the index run can be evaluated.\r\nMore data is required before the index run can be evaluated.\r\nMore data is required before the fan's efficiency can be evaluated.\r\n","Insufficient Information","Insufficient Information","Not Applicable","Insufficient Information","Insufficient Information","Insufficient Information","Not Applicable"]
[]
[null,"Notice for new users:"]
[null,"The Pump System Calculator uses a custom ribbon for navigation. Worksheet tabs are not supported. For more guidance on this tool, please click the Help button on the ribbon above."]
[null,"Notice for all users:"]
[null,"The Pump System Calculator is not a compliance tool, nor a Verification Method. It is provided solely to aid practitioners in developing their understanding of the NCC.\nThe accuracy of the Calculator's output is based entirely on the accuracy of the data entered by the user."]
[]
[null,"IMPORTANT NOTICE AND DISCLAIMER IN RESPECT OF THIS PUMP SYSTEM CALCULATOR"]

{"sheet":"Summary","index":2,"n_rows":35,"n_cols":6,"rows_kept":35,"cut":false,"hidden":true,"merged":[[37,2,37,5],[35,1,35,3],[29,1,29,4],[21,3,21,4],[22,3,22,4],[24,1,24,4],[20,1,20,4],[28,1,28,4],[4,1,4,2],[3,1,3,4],[7,1,7,4],[9,3,10,4],[5,1,5,2],[13,1,13,4],[8,3,8,4],[9,2,10,2]]}
[]
[null,null,null,null,null,"Calculator"]
[]
[null,"System General Information"]
[null,"Building Name and Description",null,"Pump Tag","System Description"]
[null,{"$f":"IF('All Systems'!B6=\"\",\"\",'All Systems'!B6)","v":""},null,{"$f":"IF(INDIRECT(\"'All Systems'!E\" & Active_System_RowNo)=\"\",\"\",INDIRECT(\"'All Systems'!E\" & Active_System_RowNo))","v":""},{"$f":"IF(INDIRECT(\"'All Systems'!D\" & Active_System_RowNo)=\"\",\"\",INDIRECT(\"'All Systems'!D\" & Active_System_RowNo))","v":""}]
[]
[null,"System Characteristics"]
[null,"Pipe System Type","System Speed Control","Operating Hours Per Annum"]
[null,"-Select-","-Select-","-Select-"]
[null,{"$f":"VLOOKUP(B12,'Lookup Values'!B32:C34,2,FALSE)","v":"Please select a non-distributive system to comply with J5.7(d)(i) or a distributive system to comply with J5.7(d)(ii)."}]
[null,{"$f":"IFERROR(VLOOKUP(B10,'Lookup Values'!A32:C35,2,FALSE),\"Z\")","v":"Z"},{"$f":"IFERROR(VLOOKUP(C10,'Lookup Values'!A38:B41,2,FALSE),\"Z\")","v":"Z"},{"$f":"IFERROR(VLOOKUP(D10,'Pipe System Lookup Values'!A62:B66,2,FALSE),\"Z\")","v":"Z"},{"$f":"IFERROR(VLOOKUP(D12,'Pipe System Lookup Values'!B62:C65,2,FALSE),5)","v":5}]
[]
[null,"Pump Characteristics"]
[null,"Pump Configuration","Pump Design","Pump Stages","Pump Speed"]
[null,"-Select-","-Select-","-Select-","-Select-"]
[null,{"$f":"VLOOKUP(B20,'Lookup Values'!B3:C5,2,FALSE)","v":"Please select a circulator to comply with J5.7(b) or another pump to comply with J5.7(c)."},{"$f":"VLOOKUP(C20,'Lookup Values'!B9:C15,2,FALSE)","v":"Please select your pump type using the drop-down menu. This cell will provide a description of the pump selected."},{"$f":"VLOOKUP(D20,'Lookup Values'!B60:C62,2,FALSE)","v":"Select the pump's speed using the drop-down menu."},{"$f":"VLOOKUP(E20,'Lookup Values'!B18:D21,3,FALSE)","v":"Please select your pump's speed."}]
[]
[null,"Table Reference for J5.7a-d",{"$f":"CONCATENATE(B12,C12)","v":"ZZ"},"Config Complete",{"$f":"IF(COUNTIF(B12:D12,\"Z\")+COUNTIF(B20:E20,\"Z\")>0,\"Incomplete\",\"Complete\")","v":"Incomplete"}]
[null,{"$f":"IFERROR(VLOOKUP(B16,'Lookup Values'!A3:C6,2,FALSE),\"Z\")","v":"Z"},{"$f":"IFERROR(VLOOKUP(C16,'Lookup Values'!A9:C16,2,FALSE),\"Z\")","v":"Z"},{"$f":"IFERROR(VLOOKUP(D16,'Lookup Values'!A60:C63,2,FALSE),\"Z\")","v":"Z"},{"$f":"IFERROR(VLOOKUP(E16,'Lookup Values'!A18:D22,2,FALSE),\"Z\")","v":"Z"}]
[null,"Component Level Satisfaction"]
[null,"Pipe","Pump","Overall"]
[null,{"$f":"INDIRECT(PipeSheetFormulaName & \"!Pipe_Component_Compliance\")","v":"Insufficient Data"},{"$f":"'Pump Details'!B49","v":"Insufficient Data"},{"$f":"IF(COUNTIF(B23:C23,\"Clause J5.7 Not Satisfied\")>0,\"Clause J5.7 Not Satisfied\",IF(COUNTIF(B23:C23,\"Inapplicable\")>0,\"Inapplicable\",IF(COUNTIF(B23:C23,\"Insufficient Data\")>0,\"Insufficient Data\",\"Satisfies Clause J5.7\")))","v":"Insufficient Data"}]
[]
[null,"System Level Satisfaction"]
[null,"Pipe","Pump","Motor Power","Overall"]
[null,{"$f":"IFERROR(IF(COUNTIF(INDIRECT(PipeSheetFormulaName & \"!Pipe_Average_PD\"),\"Insufficient Data\")+COUNTIF(INDIRECT(PipeSheetFormulaName & \"!Pipe_Maximum_PD\"),\"Insufficient Data\")>0,\"Insufficient Data\",INDIRECT(PipeSheetFormulaName & \"!Pipe_Average_PD\")/INDIRECT(PipeSheetFormulaName & \"!Pipe_Maximum_PD\")-1),\"Insufficient Data\")","v":"Insufficient Data"},{"$f":"IFERROR(IF(B20=\"A\",IF(Component_Pump=\"Inapplicable\",\"Inapplicable\",IF(Entered_EEI=\"\",\"Insufficient Data\",Entered_EEI/0.27-1)),IF(B20=\"B\",IF(OR(C20=\"F\",E20=\"C\"),\"Inapplicable\",IF(Pump_Method_Tag=\"A\",\"Unavailable\",IF(Pump_Method_Tag=\"B\",'Pump Details'!B44/Alternate_MEI_Efficiency-1,\"Insufficient Data\"))),\"Insufficient Data\")),\"Insufficient Data\")","v":"Insufficient Data"},{"$f":"IFERROR(IF(COUNTBLANK(B27:C27)+COUNTIF(B27:C27,\"Insufficient Data\")>0,\"Insufficient Data\",IF(COUNTIF(B27:C27,\"Inapplicable\"),\"Inapplicable\",(C27+1)*(B27+1)-1)),\"Insufficient Data\")","v":"Insufficient Data"},{"$f":"IFERROR(IF(C27=\"Inapplicable\",\"Inapplicable\",IF(COUNTBLANK(B27:D27)+COUNTIF(B27:D27,\"Insufficient Data\")>0,\"Insufficient Data\",IF(D27<0,\"Satisfies Clause J5.7\",\"Clause J5.7 Not Satisfied\"))),\"Insufficient Data\")","v":"Insufficient Data"}]
[]
[null,"Result"]
[null,"More data is required to evaluate the system on either component or systemic levels.\r\nMore data is required before the pump can be evaluated.\r\nMore data is required before the pipework can be evaluated.\r\nEnsure that you select a pipe system type using the drop down menu.\r\nEnsure that you select the system's speed control using the drop down menu.\r\nEnsure that you enter the number of hours per annum that the system operates.\r\nEnsure that you select the pump configuration using the drop down menu.\r\nEnsure that you select the pump design using the drop down menu.\r\nEnsure that you select whether the pump is single or multistage.\r\nEnsure that you select the pump's speed from the drop down menu."]
[null,null,null,"Compliant total"]
[null,null,null,{"$f":"IF(OR(D23=\"Inapplicable\",E27=\"Inapplicable\"),\"Inapplicable\",IF(OR(D23=\"Satisfies Clause J5.7\",E27=\"Satisfies Clause J5.7\"),\"Satisfies Clause J5.7\",IF(OR(D23=\"Clause J5.7 Not Satisfied\",E27=\"Clause J5.7 Not Satisfied\"),\"Clause J5.7 Not Satisfied\",\"Insufficient Data\")))","v":"Insufficient Data"}]
[]
[null,null,null,null,"Version number: 1.0"]
[null,"IMPORTANT NOTICE AND DISCLAIMER IN RESPECT OF THIS PUMP SYSTEM CALCULATOR"]

{"sheet":"Report Template","index":3,"n_rows":37,"n_cols":5,"rows_kept":37,"cut":false,"hidden":true,"merged":[[15,1,15,2],[16,1,16,2],[18,0,18,2],[25,0,25,2],[29,0,29,3],[33,0,33,4],[34,0,34,4],[37,1,37,3],[21,1,21,2],[23,1,23,2],[20,0,21,0],[22,0,23,0],[14,1,14,2],[3,0,3,4],[4,0,4,1],[5,0,5,1],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[7,0,7,2],[8,1,8,2]]}
[]
[]
[]
["Project Information"]
[{"$f":"'All Systems'!B5","v":"Building Name and Description"},null,{"$f":"'All Systems'!E5","v":"Project Number"},{"$f":"'All Systems'!F5","v":"Designer"},{"$f":"'All Systems'!I5","v":"Company"}]
[{"$f":"IF('All Systems'!B6=\"\",\"\",'All Systems'!B6)","v":""},null,{"$f":"IF('All Systems'!E6=\"\",\"\",'All Systems'!E6)","v":""},{"$f":"IF('All Systems'!F6=\"\",\"\",'All Systems'!F6)","v":""},{"$f":"IF('All Systems'!I6=\"\",\"\",'All Systems'!I6)","v":""}]
[]
["System Information"]
["Pump Tag:"]
["Description:"]
["System Type:"]
["Speed Control:"]
["Operating Hours Per Annum:"]
["Pump Configuration:"]
["Pump Design:"]
["Pump Stages:"]
["Pump Speed:"]
[]
["Calculation Summary"]
["Component","System","Allowable"]
["Straight Pressure Drop"]
[]
["Minimum Efficiency Index"]
[]
[]
["Component Level Satisfaction"]
["Pipe","Pump","Overall"]
[]
[]
["System Level Satisfaction"]
["Pipe","Pump","Motor Power","Overall"]
[]
[]
["Result"]
[]
[]
["IMPORTANT NOTICE AND DISCLAIMER IN RESPECT OF THIS PUMP SYSTEM CALCULATOR"]

{"sheet":"Report","index":4,"n_rows":37,"n_cols":5,"rows_kept":37,"cut":false,"hidden":true,"merged":[[3,0,3,4],[9,1,9,2],[4,0,4,1],[5,0,5,1],[7,0,7,2],[8,1,8,2],[37,1,37,3],[20,0,21,0],[21,1,21,2],[22,0,23,0],[23,1,23,2],[25,0,25,2],[29,0,29,3],[33,0,33,4],[34,0,34,4],[15,1,15,2],[16,1,16,2],[14,1,14,2],[18,0,18,2],[10,1,10,2],[13,1,13,2],[11,1,11,2],[12,1,12,2]]}
[]
[]
[]
["Project Information"]
["Building Name and Description",null,"Project Number","Designer","Company"]
["",null,"","",""]
[]
["System Information"]
["Pump Tag:"]
["Description:"]
["System Type:","-Select-"]
["Speed Control:","-Select-"]
["Operating Hours Per Annum:","-Select-"]
["Pump Configuration:","-Select-"]
["Pump Design:","-Select-"]
["Pump Stages:","-Select-"]
["Pump Speed:","-Select-"]
[]
["Calculation Summary"]
["Component","System","Allowable"]
["Straight Pressure Drop","TBC","TBC"]
[]
["Minimum Efficiency Index",0,"TBC"]
[]
[]
["Component Level Satisfaction"]
["Pipe","Pump","Overall"]
["Insufficient Data","Insufficient Data","Insufficient Data"]
[]
["System Level Satisfaction"]
["Pipe","Pump","Motor Power","Overall"]
["Insufficient Data","Insufficient Data","Insufficient Data","Insufficient Data"]
[]
["Result"]
["More data is required to evaluate the system on either component or systemic levels.\r\nMore data is required before the pump can be evaluated.\r\nMore data is required before the pipework can be evaluated.\r\nEnsure that you select a pipe system type using the drop down menu.\r\nEnsure that you select the system's speed control using the drop down menu.\r\nEnsure that you enter the number of hours per annum that the system operates.\r\nEnsure that you select the pump configuration using the drop down menu.\r\nEnsure that you select the pump design using the drop down menu.\r\nEnsure that you select whether the pump is single or multistage.\r\nEnsure that you select the pump's speed from the drop down menu."]
["Version number: 1.0"]
["IMPORTANT NOTICE AND DISCLAIMER IN RESPECT OF THIS PUMP SYSTEM CALCULATOR"]

{"sheet":"Pipe Details (104)","index":5,"n_rows":44,"n_cols":25,"rows_kept":44,"cut":false,"hidden":true,"merged":[[26,1,26,2],[26,4,26,5],[29,1,29,18],[39,1,39,13],[40,1,40,2],[40,4,40,5],[40,6,41,13],[41,1,41,2],[41,4,41,5],[25,1,25,2],[25,4,25,5],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[23,1,23,2],[24,1,24,2],[24,4,24,5],[13,1,13,3],[13,5,13,8],[3,1,3,8],[4,1,4,3],[4,4,4,5],[4,6,4,8],[5,1,5,3],[5,4,5,5],[5,6,5,8],[7,1,7,5],[8,1,8,2],[8,4,8,5],[9,1,9,2],[9,4,9,5]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Calculator"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"S3+1","v":1},2,3,4,5]
[null,"System General Information"]
[null,"Building Name and Description",null,null,"Pump Tag",null,"System Description"]
[null,{"$f":"IF(Summary!B6=\"\",\"\",Summary!B6)","v":""},null,null,{"$f":"IF(Summary!D6=\"\",\"\",Summary!D6)","v":""},null,{"$f":"IF(Summary!E6=\"\",\"\",Summary!E6)","v":""}]
[]
[null,"System Characteristics"]
[null,{"$f":"Summary!B9","v":"Pipe System Type"},null,{"$f":"Summary!C9","v":"System Speed Control"},{"$f":"Summary!D9","v":"Operating Hours Per Annum"}]
[null,{"$f":"IF(Summary!B10=\"\",\"\",Summary!B10)","v":"-Select-"},null,{"$f":"IF(Summary!C10=\"\",\"\",Summary!C10)","v":"-Select-"},{"$f":"IF(Summary!D10=\"\",\"\",Summary!D10)","v":"-Select-"}]
[]
[null,"Method","None",{"$f":"VLOOKUP(C12,'Lookup Values'!A66:B69,2,FALSE)","v":"Z"}]
[]
[null,"The Simple Method requires the average pressure drop to be pre-calculated. The maximum pressure drop allowed may be lower than that of a fully described system.",null,null,null,"The Complex Method allows for the piping to be entered and both the average pressure drop and maximum pressure drop to be calculated taking into account variations in pipe size throughout the system."]
[]
[null,"Piping Details",null,null,null,null,null,null,null,null,null,"Calculation Behind Simple Method"]
[null,"Diameter Present",null,null,null,null,null,null,null,null,null,"Diameter reference","Max PD","Present",null,null,null,null,null,"Max PD or \"N/A\""]
[null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(OR((ISNUMBER(FIND(Configuration_Plus_Design,\"Z\"))),Summary!$D$12=\"Z\"),0,VLOOKUP(L18,INDIRECT(\"Table\"&Summary!$C$19),HLOOKUP(Summary!$D$12,INDIRECT(\"Mini\"&Summary!$C$19),2,FALSE),TRUE))","v":0},true,null,null,null,null,null,{"$f":"IF(N18,M18,\"N/A\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,25,{"$f":"IF(OR((ISNUMBER(FIND(Configuration_Plus_Design,\"Z\"))),Summary!$D$12=\"Z\"),0,VLOOKUP(L19,INDIRECT(\"Table\"&Summary!$C$19),HLOOKUP(Summary!$D$12,INDIRECT(\"Mini\"&Summary!$C$19),2,FALSE),TRUE))","v":0},true,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,32,{"$f":"IF(OR((ISNUMBER(FIND(Configuration_Plus_Design,\"Z\"))),Summary!$D$12=\"Z\"),0,VLOOKUP(L20,INDIRECT(\"Table\"&Summary!$C$19),HLOOKUP(Summary!$D$12,INDIRECT(\"Mini\"&Summary!$C$19),2,FALSE),TRUE))","v":0},true,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,40,{"$f":"IF(OR((ISNUMBER(FIND(Configuration_Plus_Design,\"Z\"))),Summary!$D$12=\"Z\"),0,VLOOKUP(L21,INDIRECT(\"Table\"&Summary!$C$19),HLOOKUP(Summary!$D$12,INDIRECT(\"Mini\"&Summary!$C$19),2,FALSE),TRUE))","v":0},true,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,50,{"$f":"IF(OR((ISNUMBER(FIND(Configuration_Plus_Design,\"Z\"))),Summary!$D$12=\"Z\"),0,VLOOKUP(L22,INDIRECT(\"Table\"&Summary!$C$19),HLOOKUP(Summary!$D$12,INDIRECT(\"Mini\"&Summary!$C$19),2,FALSE),TRUE))","v":0},true,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,65,{"$f":"IF(OR((ISNUMBER(FIND(Configuration_Plus_Design,\"Z\"))),Summary!$D$12=\"Z\"),0,VLOOKUP(L23,INDIRECT(\"Table\"&Summary!$C$19),HLOOKUP(Summary!$D$12,INDIRECT(\"Mini\"&Summary!$C$19),2,FALSE),TRUE))","v":0},true,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,80,{"$f":"IF(OR((ISNUMBER(FIND(Configuration_Plus_Design,\"Z\"))),Summary!$D$12=\"Z\"),0,VLOOKUP(L24,INDIRECT(\"Table\"&Summary!$C$19),HLOOKUP(Summary!$D$12,INDIRECT(\"Mini\"&Summary!$C$19),2,FALSE),TRUE))","v":0},true,null,null,null,null,null,0]
[null,null,null,null,"System Information",null,null,null,null,null,null,100,{"$f":"IF(OR((ISNUMBER(FIND(Configuration_Plus_Design,\"Z\"))),Summary!$D$12=\"Z\"),0,VLOOKUP(L25,INDIRECT(\"Table\"&Summary!$C$19),HLOOKUP(Summary!$D$12,INDIRECT(\"Mini\"&Summary!$C$19),2,FALSE),TRUE))","v":0},true,null,null,null,null,null,0]
[null,null,null,null,"Average Pressure Drop Pa/m",null,null,null,null,null,null,125,{"$f":"IF(OR((ISNUMBER(FIND(Configuration_Plus_Design,\"Z\"))),Summary!$D$12=\"Z\"),0,VLOOKUP(L26,INDIRECT(\"Table\"&Summary!$C$19),HLOOKUP(Summary!$D$12,INDIRECT(\"Mini\"&Summary!$C$19),2,FALSE),TRUE))","v":0},true,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,150,{"$f":"IF(OR((ISNUMBER(FIND(Configuration_Plus_Design,\"Z\"))),Summary!$D$12=\"Z\"),0,VLOOKUP(L27,INDIRECT(\"Table\"&Summary!$C$19),HLOOKUP(Summary!$D$12,INDIRECT(\"Mini\"&Summary!$C$19),2,FALSE),TRUE))","v":0},true,null,null,null,null,null,0]
[null,"This row has sums in it",null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(N18:N27,TRUE)","v":10},null,null,null,null,null,{"$f":"IF(N28=0,\"TBC\",MIN(T18:T27))","v":0}]
[]
[null,"Piping Details"]
[null,"ID","Description","Material","Temperature","Flow Rate","Diameter","Length","Roughness","Internal Diameter","Flow Rate For Iterative Solving","Fluid Density","Dynamic Viscosity","Velocity","Velocity Check","Pressure Drop","Maximum PD","Compliant","Total PD","Total Maximum PD"]
[null,null,null,null,"°C","L/s","mm","m","mm","m","L/s","kg/m³","mPas","m/s",null,"Pa/m","Pa/m",null,"kPa","kPa"]
[null,"Controls",{"$f":"IF(ISBLANK(B32),B31,B31 & CHAR(10) & B32)","v":"ID"},"Description","Material","Temperature\n°C","Flow Rate\nL/s","Diameter\nmm","Length\nm","Roughness\nmm","Internal Diameter\nm","Flow Rate For Iterative Solving\nL/s","Fluid Density\nkg/m³","Dynamic Viscosity\nmPas","Velocity\nm/s","Velocity Check","Pressure Drop\nPa/m","Maximum PD\nPa/m","Compliant","Total PD\nkPa","Total Maximum PD\nkPa","Reynolds Number","Velocity Check Conditions","Ready For DP Calc"]
[null,null,"Template Row (Hidden)",null,"Copper Type B to AS1432",null,null,20,null,null,{"$f":"IFERROR((IF(E34=\"Custom\",IF(ISBLANK(H34),\"\",H34/1000),INDEX('Pipe System Lookup Values'!$C$4:$G$20,MATCH('Pipe Details (104)'!H34,'Pipe System Lookup Values'!$B$4:$B$20,0),MATCH(E34,'Pipe System Lookup Values'!$C$3:$H$3,0))/1000)),\"\")","v":1.6930000000000001E-2},{"$f":"IFERROR(-1000*PI()*(Q34*K34^5/(2*M34))^0.5*LOG(((J34/1000)/(3.7*K34))+(1.255*(N34/1000)/M34)/(Q34*K34^3/(2*M34))^0.5),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($F34,'Water Properties'!$A$2:$C$82,3),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($F34,'Water Properties'!$A$2:$C$82,2),\"\")","v":""},{"$f":"IF(AND(G34>0,K34>0,ISNUMBER(G34),ISNUMBER(K34)),G34/(PI()*(K34/2)^2)/1000,\"\")","v":""},"Not Determined",null,{"$f":"IF(OR(H34=\"\",OR(ISNUMBER(FIND(\"Z\",Configuration_Plus_Design)),Summary!$D$12=\"Z\")),\"\",VLOOKUP(H34,INDIRECT(\"Table\"&Summary!$C$19),HLOOKUP(Summary!$D$12,INDIRECT(\"Mini\"&Summary!$C$19),2,FALSE),TRUE))","v":""},{"$f":"IF(OR(R34=\"\",Q34=\"\"),\"TBC\",IF(P34=\"Applicable\",\"Exempt\",IF(R34>Q34,\"Satisfies Clause J5.7\",\"Clause J5.7 Not Satisfied\")))","v":"TBC"},{"$f":"IF(OR(I34=\"\",Q34=\"\"),\"\",I34*Q34/1000)","v":""},{"$f":"IF(OR(R34=\"\",I34=\"\"),\"\",R34*I34/1000)","v":""},{"$f":"IFERROR(M34*(G34/1000)*K34/((PI()*(K34/2)^2)*(N34/1000)),0)","v":0},null,{"$f":"IF(COUNTBLANK(E34:H34)+COUNTBLANK(J34:K34)>0,FALSE,TRUE)","v":false}]
[null,null,"Copy Row",null,"Copper Type B to AS1432",null,null,null,null,1.4999999999999999E-2,{"$f":"IFERROR((IF(E35=\"Custom\",IF(ISBLANK(H35),\"\",H35/1000),INDEX('Pipe System Lookup Values'!$C$4:$G$20,MATCH('Pipe Details (104)'!H35,'Pipe System Lookup Values'!$B$4:$B$20,0),MATCH(E35,'Pipe System Lookup Values'!$C$3:$H$3,0))/1000)),\"\")","v":""},"",{"$f":"IFERROR(VLOOKUP($F35,'Water Properties'!$A$2:$C$82,3),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($F35,'Water Properties'!$A$2:$C$82,2),\"\")","v":""},{"$f":"IF(AND(G35>0,K35>0,ISNUMBER(G35),ISNUMBER(K35)),G35/(PI()*(K35/2)^2)/1000,\"\")","v":""},"Not Determined",null,{"$f":"IF(OR(H35=\"\",OR(ISNUMBER(FIND(\"Z\",Configuration_Plus_Design)),Summary!$D$12=\"Z\")),\"\",VLOOKUP(H35,INDIRECT(\"Table\"&Summary!$C$19),HLOOKUP(Summary!$D$12,INDIRECT(\"Mini\"&Summary!$C$19),2,FALSE),TRUE))","v":""},{"$f":"IF(OR(R35=\"\",Q35=\"\"),\"TBC\",IF(P35=\"Applicable\",\"Exempt\",IF(R35>Q35,\"Satisfies Clause J5.7\",\"Clause J5.7 Not Satisfied\")))","v":"TBC"},"","",0,"5,0.015,999,1.138,Copper Type B to AS1432",{"$f":"IF(COUNTBLANK(E35:H35)+COUNTBLANK(J35:K35)>0,FALSE,TRUE)","v":false}]
[null,null,1,null,"Copper Type B to AS1432",null,null,null,null,null,{"$f":"IFERROR((IF(E36=\"Custom\",IF(ISBLANK(H36),\"\",H36/1000),INDEX('Pipe System Lookup Values'!$C$4:$G$20,MATCH('Pipe Details (104)'!H36,'Pipe System Lookup Values'!$B$4:$B$20,0),MATCH(E36,'Pipe System Lookup Values'!$C$3:$H$3,0))/1000)),\"\")","v":""},"",{"$f":"IFERROR(VLOOKUP($F36,'Water Properties'!$A$2:$C$82,3),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($F36,'Water Properties'!$A$2:$C$82,2),\"\")","v":""},"","Not Determined",null,{"$f":"IF(OR(H36=\"\",OR(ISNUMBER(FIND(\"Z\",Configuration_Plus_Design)),Summary!$D$12=\"Z\")),\"\",VLOOKUP(H36,INDIRECT(\"Table\"&Summary!$C$19),HLOOKUP(Summary!$D$12,INDIRECT(\"Mini\"&Summary!$C$19),2,FALSE),TRUE))","v":""},{"$f":"IF(OR(R36=\"\",Q36=\"\"),\"TBC\",IF(P36=\"Applicable\",\"Exempt\",IF(R36>Q36,\"Satisfies Clause J5.7\",\"Clause J5.7 Not Satisfied\")))","v":"TBC"},"","",0,"5,0.015,999,1.138,Copper Type B to AS1432",{"$f":"IF(COUNTBLANK(E36:H36)+COUNTBLANK(J36:K36)>0,FALSE,TRUE)","v":false}]
[null,"Average",null,"Custom",null,1,{"$f":"IFERROR(IF(MAX($G36:$G36)/MIN($G36:$G36)>1.01,FALSE,TRUE),TRUE)","v":true},null,{"$f":"SUMIFS(I36:I36,$X36:$X36,TRUE,$P36:$P36,\"Not Applicable\")","v":0},null,{"$f":"IFERROR(-1000*PI()*(P37*J37^5/(2*L37))^0.5*LOG(((I37/1000)/(3.7*J37))+(1.255*(M37/1000)/L37)/(P37*J37^3/(2*L37))^0.5),\"\")","v":""},null,null,"Head in the units specified for pump head ----->",{"$f":"IFERROR(D42/VLOOKUP('Pump Details'!C30,'Lookup Values'!A52:B56,2,FALSE)*'Lookup Values'!B52,\"\")","v":""},null,null,"Insufficient Data",{"$f":"COUNTIF($S36:$S36,\"TBC\")","v":1},{"$f":"SUMIFS(T36:T36,$X36:$X36,TRUE,$P36:$P36,\"Not Applicable\")","v":0},{"$f":"SUMIFS(U36:U36,$X36:$X36,TRUE,$P36:$P36,\"Not Applicable\")","v":0}]
[null,"Total",null,null,null,1,null,null,null,null,"",null,null,null,{"$f":"IF(AND('Pump Details'!C19=\"Alternate\",Summary!B16='Lookup Values'!A5,'Pump Details'!C31>0),IF(C37>'Pump Details'!C31,\"Warning\",\"No Warning\"),\"No Warning\")","v":"No Warning"},null,null,"Insufficient Data",{"$f":"IFERROR(COUNTIF($S36:$S36,\"Exempt\")/COUNTA($S36:$S36),0)","v":0}]
[]
[null,"Piping Summary"]
[null,"Component Level Satisfaction",null,{"$f":"\"Average Pressure Drop\" & CHAR(10) & \"Pa/m\"","v":"Average Pressure Drop\nPa/m"},{"$f":"\"Maximum Pressure Drop\" & CHAR(10) & \"Pa/m\"","v":"Maximum Pressure Drop\nPa/m"},null,"Note: This pressure drop only includes straight sections of pipe. Designers should ensure that all fittings are also accounted for in their pump selections."]
[null,{"$f":"IF(ExemptCheckFormula=1,\"Exempt\",IF(COUNTIF(D42:F42,\"TBC\")+IF(Method_Tag=\"B\",TBC_Check_Formula,0)>0,\"Insufficient Data\",IFERROR(IF(D42<=E42,\"Satisfies Clause J5.7\",\"Clause J5.7 Not Satisfied\"),\"Insufficient Data\")))","v":"Insufficient Data"},null,{"$f":"IF(D12=\"B\",IF(ExemptCheckFormula=1,\"Exempt\",IFERROR(1000*Total_PD_Calc/Total_Length,\"TBC\")),IF(D12=\"A\",IF(E27=\"\",\"TBC\",E27),\"TBC\"))","v":"TBC"},{"$f":"IF(D12=\"B\",IF(ExemptCheckFormula=1,\"Exempt\",IFERROR(1000*Total_Max_PD_Calc/Total_Length,\"TBC\")),IF(D12=\"A\",T28,\"TBC\"))","v":"TBC"}]
[]
[null,"IMPORTANT NOTICE AND DISCLAIMER IN RESPECT OF THIS PUMP SYSTEM CALCULATOR"]

{"sheet":"Pump Details","index":6,"n_rows":50,"n_cols":7,"rows_kept":50,"cut":false,"hidden":true,"merged":[[41,2,42,2],[28,4,28,5],[29,4,29,5],[8,2,8,3],[9,2,9,3],[40,1,40,2],[27,1,27,5],[30,4,30,5],[12,1,13,1],[3,1,3,5],[23,1,23,2],[11,1,11,4],[20,1,20,2],[20,4,20,5],[12,3,13,4],[14,3,14,4],[4,1,4,3],[5,1,5,3],[7,1,7,5]]}
[]
[null,null,null,null,null,null,"Calculator"]
[]
[null,"System General Information"]
[null,"Building Name and Description",null,null,"Pump Tag","System Description"]
[null,{"$f":"IF(Summary!B6=\"\",\"\",Summary!B6)","v":""},null,null,{"$f":"IF(Summary!D6=\"\",\"\",Summary!D6)","v":""},{"$f":"IF(Summary!E6=\"\",\"\",Summary!E6)","v":""}]
[]
[null,"Pump Characteristics"]
[null,"Pump Configuration","Pump Design",null,"Pump Stages","Pump Speed"]
[null,{"$f":"IF(Summary!B16=\"\",\"\",Summary!B16)","v":"-Select-"},{"$f":"IF(Summary!C16=\"\",\"\",Summary!C16)","v":"-Select-"},null,{"$f":"IF(Summary!D16=\"\",\"\",Summary!D16)","v":"-Select-"},{"$f":"IF(Summary!E16=\"\",\"\",Summary!E16)","v":"-Select-"}]
[]
[null,"Component Level Satisfaction"]
[null,"Energy Efficiency Index","Hydraulic Power Output","Pump Component"]
[null,null,"kW"]
[null,null,null,{"$f":"IF(OR(ISBLANK(B15),ISBLANK(C15)),\"Insufficient Data\",IF(C15<2.5,IF(B15<=0.27,\"Satisfies Clause J5.7\",\"Clause J5.7 Not Satisfied\"),\"Inapplicable\"))","v":"Insufficient Data"}]
[]
[]
[]
[null,"Method","None",{"$f":"IFERROR(VLOOKUP(Pump_Method,'Lookup Values'!A72:B75,2,FALSE),\"Z\")","v":"Z"},"Complete",{"$f":"IF(C19=\"Alternate\",IF(C44=\"Insufficient Data\",\"Please complete on the Pump Details sheet\",IF(Summary!E27=\"Insufficient Data\",\"Complete for component level check only\",\"Complete\")),IF(C19=\"Simple\",IF(C26=\"Insufficient Data\",\"Please complete on the Pump Details sheet\",\"Complete for component level check only\"),\"Please complete on the Pump Details sheet\"))","v":"Please complete on the Pump Details sheet"}]
[]
[null,"The Simple Method requires only the pump's Minimum Efficiency Index. However, the system can only be evaluated on a component level if this option is chosen.",null,null,"The Alternate Method requires information on the system's water flow rate, system head, number of pump impellers and efficiency (at its best efficiency point). Although this requires more information, it also allows for the system to be evaluated as a whole."]
[]
[]
[null,"Component Level Satisfaction"]
[null,"Minimum Efficiency Index","Pump Component"]
[null,null,{"$f":"IF(OR(Summary!C20=\"Z\",Summary!D20=\"Z\",Summary!E20=\"Z\"),\"Insufficient Data\",IF(OR(Summary!C20=\"F\",Summary!E20=\"C\"),\"Inapplicable\",IF(ISBLANK(B26),\"Insufficient Data\",IF(B26>=0.4,\"Satisfies Clause J5.7\",\"Clause J5.7 Not Satisfied\"))))","v":"Insufficient Data"}]
[]
[null,"Details For Alternate Energy Efficiency Method"]
[null,"Water Flow Rate","System Head","Number of series impellers","Efficiency at Best Efficiency Point"]
[null,"L/s","kPa","#","%"]
[]
[]
[null,"(Hidden calculations)"]
[null,"Water flow rate","Water flow rate","Number of impellers","Rotational speed","System head"]
[null,"m3/hr","m3/s","#","rpm","m"]
[null,{"$f":"IF(COUNTBLANK(C36)>0,\"\",C36*60*60)","v":""},{"$f":"IF(COUNTBLANK(B30:B31)>0,\"\",B31*VLOOKUP(B30,'Lookup Values'!$A$45:$B$48,2,FALSE))","v":""},{"$f":"IF(Summary!D16='Lookup Values'!A61,1,IF(D31=\"\",\"\",'Pump Details'!D31))","v":""},{"$f":"VLOOKUP(Summary!$E$20,'Lookup Values'!$B$19:$C$22,2,FALSE)","v":"N/A"},{"$f":"IF(COUNTBLANK(C30:C31)>0,\"\",C31*VLOOKUP(C30,'Lookup Values'!$A$52:$B$56,2,FALSE))","v":""}]
[]
[null,"Specific speed","x","Summary MEI","y","Cpumptype"]
[null,"/min",null,{"$f":"IF(C44=\"Inapplicable\",\"N/A\",IF(C44=\"Insufficient Data\",\"TBC\",IF(C44=\"Satisfies Clause J5.7\",\">0.40\",\"<0.40\")))","v":"TBC"}]
[null,{"$f":"IF(COUNTBLANK(B31:C31)+COUNTBLANK(E31)+COUNTBLANK(D36)+COUNTIF(E36,\"N/A\")+COUNTBLANK(E36)>0,\"\",E36*(C36^0.5)/((1/D36)*F36)^(3/4))","v":""},{"$f":"IF(COUNTBLANK(B40)>0,\"\",LN(B40))","v":""},null,{"$f":"IF(COUNTBLANK(B36)>0,\"\",LN(B36))","v":""},{"$f":"INDEX('Lookup Values'!$D$27:$J$30,MATCH(Summary!$E$20,'Lookup Values'!$C$27:$C$30,0),MATCH(Summary!$C$20,'Lookup Values'!$D$26:$J$26,0))","v":"TBC"}]
[null,"Component Level Satisfaction"]
[null,"Required Efficiency","Pump Component"]
[null,"%"]
[null,{"$f":"IF(F40=\"N/A\",\"Inapplicable\",IF(F40=\"TBC\",\"Insufficient Data\",IF(COUNTBLANK(C40)+COUNTBLANK(E40:F40)>0,\"\",(88.59*C40+13.46*E40-11.48*C40^2-0.85*E40^2-0.38*C40*E40-F40)/100)))","v":"Insufficient Data"},{"$f":"IF(B44=\"Inapplicable\",\"Inapplicable\",IF(OR(COUNTBLANK(E31)>0,COUNTBLANK(B44)>0,B44=\"Insufficient Data\"),\"Insufficient Data\",IF(B44<E31,\"Satisfies Clause J5.7\",\"Clause J5.7 Not Satisfied\")))","v":"Insufficient Data"}]
[]
[]
[]
[null,"Total Pump Compliance Check (hidden)"]
[null,{"$f":"IF(B10='Lookup Values'!A4,'Pump Details'!D15,IF(AND('Pump Details'!B10='Lookup Values'!A5,C19<>\"None\"),IF(C19=\"Alternate\",C44,C26),\"Insufficient Data\"))","v":"Insufficient Data"}]
[null,"IMPORTANT NOTICE AND DISCLAIMER IN RESPECT OF THIS PUMP SYSTEM CALCULATOR"]

{"sheet":"Pipe Details (Template)","index":7,"n_rows":44,"n_cols":25,"rows_kept":44,"cut":false,"hidden":true,"merged":[[3,1,3,8],[7,1,7,5],[8,4,8,5],[8,1,8,2],[9,4,9,5],[9,1,9,2],[4,6,4,8],[5,6,5,8],[4,4,4,5],[5,4,5,5],[4,1,4,3],[5,1,5,3],[25,1,25,2],[26,1,26,2],[25,4,25,5],[40,6,41,13],[39,1,39,13],[40,1,40,2],[41,1,41,2],[41,4,41,5],[29,1,29,18],[40,4,40,5],[26,4,26,5],[13,5,13,8],[16,1,16,2],[15,1,15,2],[13,1,13,3],[24,4,24,5],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[23,1,23,2],[24,1,24,2]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Calculator"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"S3+1","v":1},2,3,4,5]
[null,"System General Information"]
[null,"Building Name and Description",null,null,"Pump Tag",null,"System Description"]
[null,{"$f":"IF(Summary!B6=\"\",\"\",Summary!B6)","v":""},null,null,{"$f":"IF(Summary!D6=\"\",\"\",Summary!D6)","v":""},null,{"$f":"IF(Summary!E6=\"\",\"\",Summary!E6)","v":""}]
[]
[null,"System Characteristics"]
[null,{"$f":"Summary!B9","v":"Pipe System Type"},null,{"$f":"Summary!C9","v":"System Speed Control"},{"$f":"Summary!D9","v":"Operating Hours Per Annum"}]
[null,{"$f":"IF(Summary!B10=\"\",\"\",Summary!B10)","v":"-Select-"},null,{"$f":"IF(Summary!C10=\"\",\"\",Summary!C10)","v":"-Select-"},{"$f":"IF(Summary!D10=\"\",\"\",Summary!D10)","v":"-Select-"}]
[]
[null,"Method","None",{"$f":"VLOOKUP(C12,'Lookup Values'!A66:B69,2,FALSE)","v":"Z"}]
[]
[null,"The Simple Method requires the average pressure drop to be pre-calculated. The maximum pressure drop allowed may be lower than that of a fully described system.",null,null,null,"The Complex Method allows for the piping to be entered and both the average pressure drop and maximum pressure drop to be calculated taking into account variations in pipe size throughout the system."]
[]
[null,"Piping Details",null,null,null,null,null,null,null,null,null,"Calculation Behind Simple Method"]
[null,"Diameter Present",null,null,null,null,null,null,null,null,null,"Diameter reference","Max PD","Present",null,null,null,null,null,"Max PD or \"N/A\""]
[null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(OR((ISNUMBER(FIND(Configuration_Plus_Design,\"Z\"))),Summary!$D$12=\"Z\"),0,VLOOKUP(L18,INDIRECT(\"Table\"&Summary!$C$19),HLOOKUP(Summary!$D$12,INDIRECT(\"Mini\"&Summary!$C$19),2,FALSE),TRUE))","v":0},true,null,null,null,null,null,{"$f":"IF(N18,M18,\"N/A\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,25,{"$f":"IF(OR((ISNUMBER(FIND(Configuration_Plus_Design,\"Z\"))),Summary!$D$12=\"Z\"),0,VLOOKUP(L19,INDIRECT(\"Table\"&Summary!$C$19),HLOOKUP(Summary!$D$12,INDIRECT(\"Mini\"&Summary!$C$19),2,FALSE),TRUE))","v":0},true,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,32,{"$f":"IF(OR((ISNUMBER(FIND(Configuration_Plus_Design,\"Z\"))),Summary!$D$12=\"Z\"),0,VLOOKUP(L20,INDIRECT(\"Table\"&Summary!$C$19),HLOOKUP(Summary!$D$12,INDIRECT(\"Mini\"&Summary!$C$19),2,FALSE),TRUE))","v":0},true,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,40,{"$f":"IF(OR((ISNUMBER(FIND(Configuration_Plus_Design,\"Z\"))),Summary!$D$12=\"Z\"),0,VLOOKUP(L21,INDIRECT(\"Table\"&Summary!$C$19),HLOOKUP(Summary!$D$12,INDIRECT(\"Mini\"&Summary!$C$19),2,FALSE),TRUE))","v":0},true,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,50,{"$f":"IF(OR((ISNUMBER(FIND(Configuration_Plus_Design,\"Z\"))),Summary!$D$12=\"Z\"),0,VLOOKUP(L22,INDIRECT(\"Table\"&Summary!$C$19),HLOOKUP(Summary!$D$12,INDIRECT(\"Mini\"&Summary!$C$19),2,FALSE),TRUE))","v":0},true,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,65,{"$f":"IF(OR((ISNUMBER(FIND(Configuration_Plus_Design,\"Z\"))),Summary!$D$12=\"Z\"),0,VLOOKUP(L23,INDIRECT(\"Table\"&Summary!$C$19),HLOOKUP(Summary!$D$12,INDIRECT(\"Mini\"&Summary!$C$19),2,FALSE),TRUE))","v":0},true,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,80,{"$f":"IF(OR((ISNUMBER(FIND(Configuration_Plus_Design,\"Z\"))),Summary!$D$12=\"Z\"),0,VLOOKUP(L24,INDIRECT(\"Table\"&Summary!$C$19),HLOOKUP(Summary!$D$12,INDIRECT(\"Mini\"&Summary!$C$19),2,FALSE),TRUE))","v":0},true,null,null,null,null,null,0]
[null,null,null,null,"System Information",null,null,null,null,null,null,100,{"$f":"IF(OR((ISNUMBER(FIND(Configuration_Plus_Design,\"Z\"))),Summary!$D$12=\"Z\"),0,VLOOKUP(L25,INDIRECT(\"Table\"&Summary!$C$19),HLOOKUP(Summary!$D$12,INDIRECT(\"Mini\"&Summary!$C$19),2,FALSE),TRUE))","v":0},true,null,null,null,null,null,0]
[null,null,null,null,"Average Pressure Drop Pa/m",null,null,null,null,null,null,125,{"$f":"IF(OR((ISNUMBER(FIND(Configuration_Plus_Design,\"Z\"))),Summary!$D$12=\"Z\"),0,VLOOKUP(L26,INDIRECT(\"Table\"&Summary!$C$19),HLOOKUP(Summary!$D$12,INDIRECT(\"Mini\"&Summary!$C$19),2,FALSE),TRUE))","v":0},true,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,150,{"$f":"IF(OR((ISNUMBER(FIND(Configuration_Plus_Design,\"Z\"))),Summary!$D$12=\"Z\"),0,VLOOKUP(L27,INDIRECT(\"Table\"&Summary!$C$19),HLOOKUP(Summary!$D$12,INDIRECT(\"Mini\"&Summary!$C$19),2,FALSE),TRUE))","v":0},true,null,null,null,null,null,0]
[null,"This row has sums in it",null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(N18:N27,TRUE)","v":10},null,null,null,null,null,{"$f":"IF(N28=0,\"TBC\",MIN(T18:T27))","v":0}]
[]
[null,"Piping Details"]
[null,"ID","Description","Material","Temperature","Flow Rate","Diameter","Length","Roughness","Internal Diameter","Flow Rate For Iterative Solving","Fluid Density","Dynamic Viscosity","Velocity","Velocity Check","Pressure Drop","Maximum PD","Compliant","Total PD","Total Maximum PD"]
[null,null,null,null,"°C","L/s","mm","m","mm","m","L/s","kg/m³","mPas","m/s",null,"Pa/m","Pa/m",null,"kPa","kPa"]
[null,"Controls",{"$f":"IF(ISBLANK(B32),B31,B31 & CHAR(10) & B32)","v":"ID"},"Description","Material","Temperature\n°C","Flow Rate\nL/s","Diameter\nmm","Length\nm","Roughness\nmm","Internal Diameter\nm","Flow Rate For Iterative Solving\nL/s","Fluid Density\nkg/m³","Dynamic Viscosity\nmPas","Velocity\nm/s","Velocity Check","Pressure Drop\nPa/m","Maximum PD\nPa/m","Compliant","Total PD\nkPa","Total Maximum PD\nkPa","Reynolds Number","Velocity Check Conditions","Ready For DP Calc"]
[null,null,"Template Row (Hidden)",null,"Copper Type B to AS1432",null,null,20,null,null,{"$f":"IFERROR((IF(E34=\"Custom\",IF(ISBLANK(H34),\"\",H34/1000),INDEX('Pipe System Lookup Values'!$C$4:$G$20,MATCH('Pipe Details (Template)'!H34,'Pipe System Lookup Values'!$B$4:$B$20,0),MATCH(E34,'Pipe System Lookup Values'!$C$3:$H$3,0))/1000)),\"\")","v":1.6930000000000001E-2},{"$f":"IFERROR(-1000*PI()*(Q34*K34^5/(2*M34))^0.5*LOG(((J34/1000)/(3.7*K34))+(1.255*(N34/1000)/M34)/(Q34*K34^3/(2*M34))^0.5),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($F34,'Water Properties'!$A$2:$C$82,3),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($F34,'Water Properties'!$A$2:$C$82,2),\"\")","v":""},{"$f":"IF(AND(G34>0,K34>0,ISNUMBER(G34),ISNUMBER(K34)),G34/(PI()*(K34/2)^2)/1000,\"\")","v":""},"Not Determined",null,{"$f":"IF(OR(H34=\"\",OR(ISNUMBER(FIND(\"Z\",Configuration_Plus_Design)),Summary!$D$12=\"Z\")),\"\",VLOOKUP(H34,INDIRECT(\"Table\"&Summary!$C$19),HLOOKUP(Summary!$D$12,INDIRECT(\"Mini\"&Summary!$C$19),2,FALSE),TRUE))","v":""},{"$f":"IF(OR(R34=\"\",Q34=\"\"),\"TBC\",IF(P34=\"Applicable\",\"Exempt\",IF(R34>Q34,\"Satisfies Clause J5.7\",\"Clause J5.7 Not Satisfied\")))","v":"TBC"},{"$f":"IF(OR(I34=\"\",Q34=\"\"),\"\",I34*Q34/1000)","v":""},{"$f":"IF(OR(R34=\"\",I34=\"\"),\"\",R34*I34/1000)","v":""},{"$f":"IFERROR(M34*(G34/1000)*K34/((PI()*(K34/2)^2)*(N34/1000)),0)","v":0},null,{"$f":"IF(COUNTBLANK(E34:H34)+COUNTBLANK(J34:K34)>0,FALSE,TRUE)","v":false}]
[null,null,"Copy Row",null,"Copper Type B to AS1432",null,null,null,null,1.4999999999999999E-2,{"$f":"IFERROR((IF(E35=\"Custom\",IF(ISBLANK(H35),\"\",H35/1000),INDEX('Pipe System Lookup Values'!$C$4:$G$20,MATCH('Pipe Details (Template)'!H35,'Pipe System Lookup Values'!$B$4:$B$20,0),MATCH(E35,'Pipe System Lookup Values'!$C$3:$H$3,0))/1000)),\"\")","v":""},"",{"$f":"IFERROR(VLOOKUP($F35,'Water Properties'!$A$2:$C$82,3),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($F35,'Water Properties'!$A$2:$C$82,2),\"\")","v":""},{"$f":"IF(AND(G35>0,K35>0,ISNUMBER(G35),ISNUMBER(K35)),G35/(PI()*(K35/2)^2)/1000,\"\")","v":""},"Not Determined",null,{"$f":"IF(OR(H35=\"\",OR(ISNUMBER(FIND(\"Z\",Configuration_Plus_Design)),Summary!$D$12=\"Z\")),\"\",VLOOKUP(H35,INDIRECT(\"Table\"&Summary!$C$19),HLOOKUP(Summary!$D$12,INDIRECT(\"Mini\"&Summary!$C$19),2,FALSE),TRUE))","v":""},{"$f":"IF(OR(R35=\"\",Q35=\"\"),\"TBC\",IF(P35=\"Applicable\",\"Exempt\",IF(R35>Q35,\"Satisfies Clause J5.7\",\"Clause J5.7 Not Satisfied\")))","v":"TBC"},"","",0,"5,0.015,999,1.138,Copper Type B to AS1432",{"$f":"IF(COUNTBLANK(E35:H35)+COUNTBLANK(J35:K35)>0,FALSE,TRUE)","v":false}]
[null,null,1,null,"Copper Type B to AS1432",null,null,null,null,null,{"$f":"IFERROR((IF(E36=\"Custom\",IF(ISBLANK(H36),\"\",H36/1000),INDEX('Pipe System Lookup Values'!$C$4:$G$20,MATCH('Pipe Details (Template)'!H36,'Pipe System Lookup Values'!$B$4:$B$20,0),MATCH(E36,'Pipe System Lookup Values'!$C$3:$H$3,0))/1000)),\"\")","v":""},{"$f":"IFERROR(-1000*PI()*(Q36*K36^5/(2*M36))^0.5*LOG(((J36/1000)/(3.7*K36))+(1.255*(N36/1000)/M36)/(Q36*K36^3/(2*M36))^0.5),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($F36,'Water Properties'!$A$2:$C$82,3),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($F36,'Water Properties'!$A$2:$C$82,2),\"\")","v":""},"","Not Determined",null,{"$f":"IF(OR(H36=\"\",OR(ISNUMBER(FIND(\"Z\",Configuration_Plus_Design)),Summary!$D$12=\"Z\")),\"\",VLOOKUP(H36,INDIRECT(\"Table\"&Summary!$C$19),HLOOKUP(Summary!$D$12,INDIRECT(\"Mini\"&Summary!$C$19),2,FALSE),TRUE))","v":""},{"$f":"IF(OR(R36=\"\",Q36=\"\"),\"TBC\",IF(P36=\"Applicable\",\"Exempt\",IF(R36>Q36,\"Satisfies Clause J5.7\",\"Clause J5.7 Not Satisfied\")))","v":"TBC"},{"$f":"IF(OR(I36=\"\",Q36=\"\"),\"\",I36*Q36/1000)","v":""},{"$f":"IF(OR(R36=\"\",I36=\"\"),\"\",R36*I36/1000)","v":""},{"$f":"IFERROR(M36*(G36/1000)*K36/((PI()*(K36/2)^2)*(N36/1000)),0)","v":0},"5,0.015,999,1.138,Copper Type B to AS1432",{"$f":"IF(COUNTBLANK(E36:H36)+COUNTBLANK(J36:K36)>0,FALSE,TRUE)","v":false}]
[null,"Average",null,"Custom",null,1,null,null,{"$f":"SUMIFS(I36,$X36,TRUE,$P36,\"Not Applicable\")","v":0},null,{"$f":"IFERROR(-1000*PI()*(P37*J37^5/(2*L37))^0.5*LOG(((I37/1000)/(3.7*J37))+(1.255*(M37/1000)/L37)/(P37*J37^3/(2*L37))^0.5),\"\")","v":""},null,null,"Head in the units specified for pump head ----->",{"$f":"IFERROR(D42/VLOOKUP('Pump Details'!C30,'Lookup Values'!A52:B56,2,FALSE)*'Lookup Values'!B52,\"\")","v":""},null,null,"Insufficient Data",null,{"$f":"SUMIFS(T36,$X36,TRUE,$P36,\"Not Applicable\")","v":0},{"$f":"SUMIFS(U36,$X36,TRUE,$P36,\"Not Applicable\")","v":0}]
[null,"Total",null,null,null,1,null,null,null,null,"",null,null,null,{"$f":"IF(AND('Pump Details'!C19=\"Alternate\",Summary!B16='Lookup Values'!A5,'Pump Details'!C31>0),IF(C37>'Pump Details'!C31,\"Warning\",\"No Warning\"),\"No Warning\")","v":"No Warning"},null,null,"Insufficient Data"]
[]
[null,"Piping Summary"]
[null,"Component Level Satisfaction",null,{"$f":"\"Average Pressure Drop\" & CHAR(10) & \"Pa/m\"","v":"Average Pressure Drop\nPa/m"},{"$f":"\"Maximum Pressure Drop\" & CHAR(10) & \"Pa/m\"","v":"Maximum Pressure Drop\nPa/m"},null,"Note: This pressure drop only includes straight sections of pipe. Designers should ensure that all fittings are also accounted for in their pump selections."]
[null,{"$f":"IF(ExemptCheckFormula=1,\"Exempt\",IF(COUNTIF(D42:F42,\"TBC\")+IF(Method_Tag=\"B\",TBC_Check_Formula,0)>0,\"Insufficient Data\",IFERROR(IF(D42<=E42,\"Satisfies Clause J5.7\",\"Clause J5.7 Not Satisfied\"),\"Insufficient Data\")))","v":"Insufficient Data"},null,{"$f":"IF(D12=\"B\",IF(ExemptCheckFormula=1,\"Exempt\",IFERROR(1000*Total_PD_Calc/Total_Length,\"TBC\")),IF(D12=\"A\",IF(E27=\"\",\"TBC\",E27),\"TBC\"))","v":"TBC"},{"$f":"IF(D12=\"B\",IF(ExemptCheckFormula=1,\"Exempt\",IFERROR(1000*Total_Max_PD_Calc/Total_Length,\"TBC\")),IF(D12=\"A\",T28,\"TBC\"))","v":"TBC"}]
[]
[null,"IMPORTANT NOTICE AND DISCLAIMER IN RESPECT OF THIS PUMP SYSTEM CALCULATOR"]

{"sheet":"Help Guide","index":8,"n_rows":334,"n_cols":3,"rows_kept":334,"cut":false,"hidden":true,"merged":[[3,1,3,2],[9,1,9,2],[8,1,8,2],[4,1,4,2],[6,1,6,2],[7,1,7,2],[5,1,5,2],[10,1,10,2],[11,1,11,2],[278,1,278,2],[119,1,119,2],[123,1,123,2],[13,1,13,2],[58,1,58,2]]}
[]
[]
[]
[null,"Table of Contents"]
[null,"Technical Information"]
[null,"Information on the calculator, its configuration and operation"]
[null,"How To Use The Calculator"]
[null,"A step-by-step guide to using the calculator"]
[null,"Calculation Details"]
[null,"Background engineering information on how the calculator performs its operations"]
[null,"Change Log"]
[null,"A list of changes made by each update to the calculator"]
[]
[null,"Technical Information"]
[null,"1. Version"]
[null,null,"This is a release version of the Pump System Calculator, first issued for use with Part J5 Air-conditioning and ventilation systems, NCC 2019 Volume One, Deemed-to-Satisfy (DTS) Provisions."]
[null,null,"The file name and summary sheet indicate the version number. The latest version should always be used."]
[null,null,"A record of changes made to each version of this calculator appears at the end of the Help section."]
[null,"2. Software version"]
[null,null,"This calculator has been developed and tested on the Microsoft Windows version of Microsoft Excel 2013. Other configurations have not been tested."]
[null,null,"For operation of the Pump System Calculator, macros must be enabled. If they are not, the calculator will display an error."]
[null,"3. Displaying the calculator form"]
[null,null,"This calculator has been designed for view at 100% zoom. Some scrolling may be necessary to view the entire calculator, depending upon your system configuration."]
[null,"4. Configuration of the calculator"]
[null,null,"The Pump System Calculator uses four different sheets to provide a logical sequence of operations. "]
[null,null,"The All Systems sheet serves as a schedule of pumps for the project, and allows for navigation between them."]
[null,null,"The Summary sheet includes general information about a particular system and computes the final results."]
[null,null,"The Pump Details sheet includes the efficiency of the pump, and calculations as required to verify pump compliance on a component level."]
[null,null,"The Pipe Details sheet allows the user to input the details of their pipe system, and evaluates its pressure drops to compare with the requirements of the NCC."]
[null,"5. Changing input details"]
[null,null,"Generally cells coloured in light yellow are available for user input. On occasion, an incorrect entry will be coloured red and be available for user input."]
[null,null,"Pipe System rows coloured red or green to indicate their compliance will remain available for user input. Other cells are involved in calculations or otherwise are not editable."]
[null,null,"On the Summary sheet, the general configuration of the system can be input. Building, system and pump names are also available for input here."]
[null,null,"The Pump Details sheet changes depending upon the pump configuration options selected on the Summary. These options are listed on the Pump Details sheet for reference, but must be edited on the Summary sheet."]
[null,null,"On the Pump Details sheet, the efficiency of the pump selected can be input, with the particular details to be input depending upon the pump options and method selected."]
[null,null,"The Pipe Details sheet allows two different methods - a simple option if pressure drops have already been calculated, or a complex option to determine these within the calculator."]
[null,null,"The procedure and details to be input on each sheet are described in more detail in How To Use The Calculator section of the Help Guide."]
[null,"6. Printing"]
[null,null,"The Report can be printed by selecting the appropriate button on the ribbon. This has been designed for printing and record keeping."]
[null,null,"Alternately, the calculator can be printed using the File/Print menu. The print area has been preset to fit onto one A4 page for each sheet."]
[null,"7. Navigation"]
[null,null,"Due to the calculator's configuration, conventional navigation using the workbook tabs is not available."]
[null,null,"Instead, the custom ribbon tab enables navigation between sheets and additional control options."]
[null,null,"Buttons are also included on the All Systems sheet to allow users to immediately inspect an area of interest."]
[null,null,"Although the calculator allows many systems to be evaluated on a project, only one can be active at any time."]
[null,null,"The active systems is highlighted with an italic font on the All Systems sheet, as well as references to pump tags across the other worksheets."]
[null,null,"It can be changed by clicking within another row on the All Systems sheet, using the drop down at the left of the ribbon, or through clicking one of the corresponding Go To buttons on the All Systems sheet."]
[null,"8. User's worksheet"]
[null,null,"A protected worksheet with the majority of cells accessible has been provided for the user to make their own notes and caculations. "]
[null,null,"Protection is necessary to maintain the integrity of the calculator, but does restrict the functions and operations accessible to the user. The worksheet can be accessed by selecting the 'Worksheet' tab within the bottom pane."]
[null,null,"Use of this worksheet is optional and responsibility for its contents and outputs rests entirely with the user. The ABCB accepts no responsibility for any calculations performed or the outputs of these calculations on this worksheet. "]
[null,"9. Macros"]
[null,null,"This calculator makes heavy use of macros and code to perform its operations. As part of its protection, the execution of other macros which may interfere with its operation are prohibited. "]
[null,"10. State and Territory variations"]
[null,null,"This calculator does not account for State and Territory variations to Part J5 Air-conditioning and ventilation systems, NCC 2019 Volume One, Deemed-to-Satisfy (DTS) Provisions."]
[null,"11. Defined terms"]
[null,null,"Please note that the calculator incorporates NCC defined terms. Refer to Part A1 of NCC 2019 Volume One for further information on defined terms."]
[]
[null,"How to use the Calculator"]
[null,"Step One - The Ribbon"]
[]
[null,"When you open the calculator, instead of the normal Microsoft Excel menu, the custom Pump System Calculator ribbon will appear."]
[null,"The first group consists of only one object - the system change drop down."]
[null,"Clicking this will bring down a list of pump tags, and clicking any of them will change the active system to that one."]
[]
[null,"The second grouping is used to navigate between the sheets."]
[null,"Clicking All Systems, Summary, Pipe Details or Pump Details will bring you to that sheet for the particular system which is active. The Worksheet is also navigable here."]
[null,"These sheets are the core of the calculator, so we'll be using these buttons quite a bit in the guide to follow."]
[]
[null,"The third grouping is concerned with reporting."]
[null,"You can go to the report sheet, bringing together the summaries for all systems within this project, or print it from here."]
[]
[null,"The fourth grouping is a link to the help, which brings you to this guide."]
[]
[null,"The fifth grouping includes zoom functions, for ease of accessibility."]
[]
[null,"The remainder of this guide will demonstrate how to operate each of the individual sheets which can be reached through this ribbon."]
[]
[null,"Step Two - Project Information"]
[]
[null,"Click the All Systems button in the ribbon to reach the project's base page."]
[]
[null,"The All Systems sheet serves as a schedule of pumps, summarising information about the project and each system within."]
[]
[null,"Enter your project's basic information at the top. This serves for your own identification of this project, and will be repeated in the report we generate at the end."]
[]
[]
[]
[null,"Below this, you are presented with a table of systems. This serves as the project's schedule."]
[]
[]
[]
[null,"At present, there should only be one system there."]
[null,"Each system, in addition to the information listed, has a series of control buttons on the left hand side."]
[null,"The Plus (+) button adds another system to the project."]
[null,"The Minus (-) button removes a system from the project."]
[null,"The Copy (C) and Paste (P) buttons allow you to duplicate existing sytsems. We'll cover those in a little while, but first we need to fill out our schedule."]
[null,"The Default (D) button sets a system as the default. All future systems added will be modelled on the default system."]
[]
[null,"Enter the system description and tag for your first pump."]
[null,"Then, you can click on the Plus button to add another system to the project. Repeat this until all your systems are included."]
[null,"As you proceed with this, you'll notice that only one row has italic font, and the others are conventional. The italic font designates the currently active system."]
[null,"The easiest way to change the active system is to click within another system's row. You'll find that the other system is now highlighted in italic."]
[null,"Alternately, if you click the Change To button on the ribbon you'll find that all your pump tags are listed, for easy navigation."]
[null,"Although the Pump System Calculator can hold as many systems as you like, you can only edit one system at a time. The other sheets are all concerned with the details of a particular system, so you need to have the correct one selected."]
[]
[null,"If you have multiple systems which are similar, you can copy the data from one to the other."]
[null,"If you click the Copy (C) button in the controls of a row, the calculator takes record of its data. You won't notice any immediate change. "]
[null,"However, once you click the Paste (P) button on another row, you'll be prompted to overwrite your data and then all the information for the copied row will be transferred."]
[null,"This covers not only basic configuration information but also all the index run details as well."]
[null,"So if you have similar systems, make ample use of the Copy and Paste functions - they'll save you time."]
[null,"The Default button allows you to set a system as the default. This means that whenever you add another system, its configuration will be based upon the default shystem."]
[]
[null,"Select your first system. Remember that there are three ways to change the active system - clicking in a system's row, using the ribbon drop down, or the Go To buttons."]
[null,"Since we'll be heading to set up the system configuration, you can use the Go To button next to your incomplete configuration to change both active system and sheet. "]
[null,"Alternately, you can select the system via either of the other methods and click the Summary button on the ribbon."]
[]
[null,"Step Three - System Characteristics"]
[]
[null,"The Summary sheet serves as a hub for both system-wide information and a repository for results."]
[]
[]
[]
[null,"Your building's name, along with the tag of the pump and system being analysed are listed along the top."]
[]
[null,"Use the next row of drop down menus to choose the characteristics of your system."]
[null,"Choose your type of system to meet J5.7(d) - between a non-distributive system (per J5.7(d)(i)), and a distributive system (per J5.7(d)(ii))."]
[null,"Choose whether your system is constant or variable speed - this determines whether you need to comply with (A) or (B) within J5.7(d)'s sub-clauses."]
[null,"A variable speed pump is one with continuously variable control. A pump which only has two or three speed options, or one which isn't controlled to vary with demand is considered a constant speed pump."]
[null,"Select how many hours per annum your system operates. This can be computed by considering a typical period and extrapolating to the year, and is used within Table J5.7b to Table J5.7e."]
[]
[null,"You can then enter the characteristics of your pump, using the next table of drop down menus."]
[null,"Select your pump configuration to determine whether you are complying with J5.7(b) or (c). To determine which type, please refer to those clauses of the NCC. Most pumps come under the 'Other' category, unless this is specifically a circulating system."]
[null,"Select your pump design, from the options contained within EU Commission Regulation No. 547/2012. If you have a circulator type pump, you may have a design which isn't any of the options given - in this case, select Other."]
[null,"Select whether your pump is single or multistage. If you have multiple series impellers, then you have a multistage pump, otherwise, you have a single stage pump."]
[null,"Select the speed at which your pump operates. Unless you are using a circulator, this must match the allowed pump designs of EU Commission Regulation No. 547/2012 - the calculator's results will tell you if you select an invalid speed."]
[null,"The EU Commission Regulations regarding Circulators and Other Pumps may be useful references for this. Links to these are available below."]
[]
[null,"Commission Regulation (EU) No 622/2012, as referenced in J5.7(b)"]
[null,"Commission Regulation (EU) No 547/2012, as referenced in J5.7(c)"]
[]
[]
[]
[null,"Step Four: Pipe Details"]
[]
[null,"The system characteristics you provided on the Summary are listed here for reference."]
[null,"Two options are available for determining the characteristics of the pipe within the system."]
[]
[]
[]
[null,"The simple method is intended for cases where designers have already calculated the average pressure drop through their design process."]
[null,"This method allows the average pressure drop to be entered directly, and for the diameters within the system to be selected."]
[null,"As the system is not fully described, the maximum pressure drop is determined conservatively as the worst associated with an included diameter."]
[]
[null,"The complex method allows for the system to be modelled and the pressure drop calculated."]
[null,"By knowing the quantities of pipe at each diameter, the allowable pressure drop can be determined more accurately."]
[]
[null,"Select your preferred method by clicking the appropriate button."]
[]
[null,"The simple method has two elements."]
[]
[]
[]
[null,"A list of pipe diameters included in Tables J5.7a to J5.7d is located on the left. "]
[null,"For each pipe diameter, tick the checkbox if it is included within your system, or untick it if it is not."]
[]
[null,"On the right is the system's average pressure drop, in Pa/m."]
[null,"This can be determined from a designer's own calculations and entered within the cell."]
[null,"If you do not know your system's average pressure drop, then the complex method is more appropriate, as it allows you to model the system and calculate this."]
[]
[null,"If you wish to change methods, click the Return to Method Selection button."]
[]
[null,"The complex method allows you to build the index run of your pipe system and determine whether it complies with J5.7(d)."]
[]
[]
[]
[null,"Much like All Systems, Pipe Details allows you to build a table to suit your needs."]
[null,"Each row of the Piping Details table represents one configuration of pipe - you might have 20m of copper pipe at 50mm carrying 1L/s of water as one row, to take one example."]
[]
[null,"The Plus (+), Minus (-), Copy (C), Paste (P) and Default (D) buttons are present and operate in the same manner as in All Systems."]
[null,"You can use the Plus (+) button to add more items to your system and Minus (-) to clear away unnecessary ones."]
[null,"Copy (C) and Paste (P) allow you to reuse similar data and save time."]
[null,"The Default (D) button lets you set a particular row as the default."]
[null,"When adding a new row it will be a copy of that default row, enabling you to set standard parameters like roughness, material and temperature once and have them repeated."]
[]
[null,"For each row of pipe, enter a description, material, water temperature, water flow rate, length and roughness."]
[null,"The material used can be chosen from a drop down selector to suit common materials to Australian Standards, or you can select a custom material."]
[null,"For materials to Australian Standards, you can select their nominal diameter from those covered within the Standard, and the calculator will automatically work out its internal diameter to use in calculation."]
[null,"However, if you use a custom material, you will need to input the internal diameter yourself."]
[null,"Once this information is provided, the calculator will determine the pressure drop of each section of pipe, and compare it to the requirement of J5.7(d). "]
[null,"It will also check whether the velocity check of J5.7(e)(ii) applies to each section of pipe, and account for this."]
[null,"These results are put together to determine the average pressure drop through the straight lengths of pipe provided. These should only be those on the index run."]
[null,"By comparing the average pressure drop with that allowed by J5.7(d), the calculator will determine whether the piping complies with J5.7(d) on a component level."]
[]
[]
[]
[null,"Step Five - Pump Details"]
[]
[null,"After completing the pipe details, all that remains is to provide the details of the system's pump."]
[]
[null,"The Pump Details sheet can change quite radically depending on your selections. The first split is between Circulators and Other Pumps, to determine compliance with J5.7(b) or J5.7(c)."]
[]
[null,"For circulator type pumps, you only need to identify the pump's Energy Efficiency Index and hydraulic power output. These should both be available from your pump supplier. "]
[]
[]
[]
[null,"Enter these values in the cells provided."]
[null,"The calculator will compare these with the requirement of J5.7(b) and determine whether you comply on a component level."]
[]
[]
[]
[null,"For Other Pumps, you have two options to demonstrate compliance. "]
[]
[]
[]
[null,"The simple method allows you to enter only a single number - the pump's Minimum Efficiency Index. This is usually available with a supplier's pump selections. "]
[]
[]
[]
[null,"The calculator will compare this with the requirement of J5.7(c), and determine whether you comply on a component level."]
[null,"However, the simple method does not contain enough information to compute the pump's actual efficiency, and thus cannot be used in a system-wide compliance check under J5.7(a)(ii)."]
[]
[null,"If you want to check an Other Pump for systemic compliance, you need to choose the Alternate Method. "]
[null,"The Return to Method Selection button allows you to go back to the method selection step and to instead choose the Alternate Method."]
[]
[]
[]
[null,"The Alternate method uses the procedure within EU Commission Regulation No. 547/2012 to compute the required efficiency and compare it with the actual efficiency."]
[null,"Enter the water flow rate, pressure drop and efficiency of your pump at the Best Efficiency Point. If your pump is multistage, then you will also be required to enter how many series impellers are included here."]
[null,"Per the Regulation, this should be done at the Best Efficiency Point, but if information at this point is unavailable then using the selection point is conservative and allows you to demonstrate compliance."]
[null,"The dimensions used for water flow rate and system head can be changed by clicking on the units and using the drop down menu which results."]
[null,"The calculator will determine what efficiency is required to comply with the Minimum Efficiency Index and compare that with your pump, to determine if your selection complies with J5.7(c) on a component level."]
[]
[]
[]
[null,"This completes the information required on this pump and the system as a whole."]
[]
[null,"Step Six - Results"]
[]
[null,"To find the overall results for this system, we need to return back to the Summary sheet, so click the Summary button on the ribbon."]
[null,"After our initial system characteristics, the remainder of the Summary sheets serves as both a progress checker and to communicate the results."]
[]
[]
[]
[null,"It will also pull together the results of each component, to tell if you comply with (b) and (c) (pump) and (d) (pipe) components of the J5.7 requirement, under J5.7(a)(i)."]
[null,"If you need to leave a calculation part way through, the component results within the Summary will tell you which items are still remaining to be completed."]
[]
[]
[]
[null,"If you do not comply with J5.7(a)(i), then the NCC 2019 allows compliance to be proven on a system level as well, under J5.7(a)(ii)."]
[null,"If all the data has been provided (and the Alternate method has been used if this is an Other Pump), then the calculator will determine your energy usage compared with a system which meets the component requirements separately. "]
[null,"This allows you to trade off improvements in one area against reductions in others to meet the intent of the energy efficiency requirements."]
[]
[]
[]
[null,"The Pump System Calculator also summarises all its findings, to provide guidance around how you may be able to reach compliance."]
[null,"The Result within the Summary sheet is colour coded and summarised through a bold sentence at the top."]
[null,"It also contains information determined from your inputs across each component, and even handy hints on how your system might be able to comply, or which information is missing."]
[]
[]
[]
[null,"This completes the procedure for a single system."]
[null,"The results will be summarised in All Systems, while you can move on to the next system using either the Change To drop down on the ribbon or by clicking within its row in All Systems."]
[null,"The same steps can be followed to complete and check compliance for all systems within the project."]
[]
[null,"Step Seven - Reporting"]
[null,"The All Systems sheet provides a quick summary of each system. But the calculator also provides the facility for a more complex report on the whole project."]
[null,"Click the Go To Report button on the ribbon to generate and go to the report."]
[]
[]
[null,"This report summarises the results in an easily printable document."]
[null,"Each system is represented on a different page, so you may need to scroll sideways to see them all."]
[]
[null,"To print this for your records, select the Print Report button on the ribbon."]
[null,"This uses the standard Excel printing interface, so you can choose to output a PDF or to a physical printer to suit your needs."]
[]
[]
[]
[null,"Calculation Details"]
[]
[null,"This section provides some background details on the calculations used within the calculator, to better inform you on its processes."]
[null,"The Other Pump Alternate Method follows the calculations within EU Commission Regulation No. 547/2012 to derive the required efficiency to meet a MEI of 0.4."]
[]
[]
[null,"where - "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"where - "]
[]
[]
[null,"The pressure drop through the piping system can be computed by using the Darcy-Weisbach equation:"]
[]
[null,"where - "]
[]
[]
[]
[null,"The friction factor f can be determined through the implicit Colebrook-White equation:"]
[]
[null,"where - "]
[]
[null,"These equations are brought together to form an implicit equation for the fluid flow rate, which is solved for iteratively using Excel's Goal Seek function:"]
[]
[null,"where the terms are as defined above, and -"]
[]
[null,"The Reynolds Number of each case is also compiuted, and below a Reynolds Number of 3000, a friction factor of 64/Re is used to simulate laminar flow, though such low Re numbers are unlikely in normal scenarios."]
[null,"The density and dynamic viscosity of the water are determined through a lookup table of these properties in water with varying temperature. This saves the user from having to look up such a table manually."]
[null,"The maximum allowed pressure drop for each section of pipe is determined by looking up Table J5.7b to Table J5.7e with the system properties provided."]
[]
[null,"The velocity check builds a parallel table of diameters to determine the smallest pipe size compliant with J5.7(d) and its velocity."]
[null,"The Reynolds number is computed to determine whether the laminar friction factor should be used."]
[null,"When the flow is turbulent, the pressure drop through each diameter is initially determined through the Haaland equation as an explicit approximation of Colebrook-White to increase computational speed:"]
[]
[null,"Then, if the Haaland approximation gives a pressure drop per unit length within 100Pa/m of the maximum allowed, Colebrook-White is used to maximise accuracy."]
[null,"Through this, the smallest pipe size compliant with the J5.7(d) requirements is computed and the velocity at this size is checked against the requirement, in order to report back to the Pipe Details table whether J5.7(e)(ii) applies."]
[null,"This procedure is followed for each row of the pipe details table, whenever any of its core characteristics are changed."]
[]
[]
[]
[null,"Change Log"]
[null,"v1.0"]
[null,"References to Clause J5.7 corrected"]
[null,"Beta removed from titles"]
[null,"Public release"]
[]
[null,"v0.9"]
[null,"For public beta testing"]

{"sheet":"Pipe Velocity Check","index":9,"n_rows":36,"n_cols":8,"rows_kept":36,"cut":false,"hidden":true,"merged":[]}
[null,"Pipe Velocity Check Sheet"]
[null,"This sheet is entirely driven by macro, to ensure that cases where J5.7(e )(ii) applies are correctly arbitered"]
[]
[null,"Common Values"]
[null,"Flow Rate","Roughness","Fluid Density","Fluid Dynamic Viscosity","Pressure Drop Requirement"]
[null,"L/s","mm","kg/m3","m2/s","Pa/m"]
[null,5,1.5E-3,999.4,1.234]
[]
[]
[null,"Nominal Pipe Diameter","Internal Pipe Diameter","Pressure Drop","Velocity","Calculated Flow Rate","Pressure Drop Requirement","Reynolds Number"]
[null,"mm","m","Pa/m","m/s","L/s","Pa/m"]
[null,null,4.8499999999999993E-3,118115857.42030692,{"$f":"$B$7/(PI()*(C12/2)^2)/1000","v":270.64290460945119},null,400,{"$f":"$D$7*E12*C12/($E$7/1000)","v":1063071.7313642015}]
[null,null,6.4400000000000004E-3,27644345.957330521,{"$f":"$B$7/(PI()*(C13/2)^2)/1000","v":153.50000298203707},null,400,{"$f":"$D$7*E13*C13/($E$7/1000)","v":800605.26352738752}]
[null,null,7.6199999999999992E-3,11755207.974765345,109.64029118833253,null,400,676627.02061894711]
[null,null,1.0799999999999999E-2,2033664.0142229844,54.57988446224121,{"$f":"-1000*PI()*(D15*C15^5/(2*$D$7))^0.5*LOG((($C$7/1000)/(3.7*C15))+(1.255*($E$7/1000)/$D$7)/(D15*C15^3/(2*$D$7))^0.5)","v":4.9710704053710106},400,477397.9534367015]
[null,null,1.3760000000000001E-2,610341.97680179996,33.623526038546025,null,400,374701.88205787609]
[null,null,1.6930000000000001E-2,219811.00596540526,22.210902554787854,{"$f":"-1000*PI()*(D17*C17^5/(2*$D$7))^0.5*LOG((($C$7/1000)/(3.7*C17))+(1.255*($E$7/1000)/$D$7)/(D17*C17^3/(2*$D$7))^0.5)","v":4.9648177887308051},400,304542.10851248523]
[null,null,2.2859999999999998E-2,50682.354485293043,12.182254576481391,{"$f":"-1000*PI()*(D18*C18^5/(2*$D$7))^0.5*LOG((($C$7/1000)/(3.7*C18))+(1.255*($E$7/1000)/$D$7)/(D18*C18^3/(2*$D$7))^0.5)","v":4.9641458767525499},400,225542.34020631568]
[null,null,2.9209999999999996E-2,15427.192129823194,7.4613430676369958,null,400,176511.39668320355]
[null,null,3.5560000000000001E-2,5962.7761274867471,5.0345031668111861,{"$f":"-1000*PI()*(D20*C20^5/(2*$D$7))^0.5*LOG((($C$7/1000)/(3.7*C20))+(1.255*($E$7/1000)/$D$7)/(D20*C20^3/(2*$D$7))^0.5)","v":4.9659728155845571},400,144991.50441834581]
[null,null,4.8230000000000002E-2,1374.2706194299524,2.7368159934781944,4.9679270006285066,400,106902.29933892547]
[null,null,6.0910000000000006E-2,452.9674294453834,1.7159432629838607,{"$f":"-1000*PI()*(D22*C22^5/(2*$D$7))^0.5*LOG((($C$7/1000)/(3.7*C22))+(1.255*($E$7/1000)/$D$7)/(D22*C22^3/(2*$D$7))^0.5)","v":4.9999930665677459},400,84647.806552559108]
[null,null,7.2759999999999991E-2,191.0937659143857,1.2025267395551944,4.9707923241749459,400,70861.708316607706]
[null,null,8.5440000000000002E-2,293.70419183861827,0.87208264452119699,9.70888222037612,400,60345.246923178544]
[null,null,9.8089999999999983E-2,284.62007675981613,0.66165356054497737,13.792102238612861,400,52562.930952353738]
[null,null,null,null,{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"}]

{"sheet":"Lookup Values","index":10,"n_rows":75,"n_cols":10,"rows_kept":75,"cut":false,"hidden":true,"merged":[]}
[]
["System Roles","Reference","Description"]
["-Select-","Z","Please select a circulator to comply with J5.7(b) or another pump to comply with J5.7(c)."]
["Circulator","A","A glandless impeller pump with a rated hydraulic power of less than 2.5kW used in a closed loop system, per EU Commission Regulation No. 622/2012. These are commonly used to circulate heating hot water or as secondary pumps for chilled water systems."]
["Other Pump","B","Any other pump used in an air-conditioning system, in accordance with Articles 1 and 2 of EU Commission Regulation No. 547/2012. Any pump which isn't used as a circulator, or a circulator if above 2.5kW comes under this category."]
[0,"Z","Please select a circulator to comply with J5.7(b) or another pump to comply with J5.7(c)."]
[]
["Pump Types","Reference","Description"]
["-Select-","Z","Please select your pump type using the drop-down menu. This cell will provide a description of the pump selected."]
["End Suction Own Bearing","A","An end suction water pump with own bearings. Commonly called long-coupled pumps."]
["End Suction Close Coupled","B","An end suction water pump where the motor shaft is extended to also become the pump shaft. Commonly called close-coupled pumps."]
["End Suction Close Coupled Inline","C","An end suction water pump where the water inlet of the pump is on the same axis as the water outlet of the pump. Commonly called inline pumps."]
["Vertical Multistage","D","A glanded multi stage rotodynamic water pump in which the impellers are assembled on a vertical rotating shaft. Must be 2 Pole to comply, unless used as a circulator."]
["Submersible Multistage","E","A multi stage rotodynamic water pump designed to be operated in a borehole. Must be 2 Pole to comply, unless used as a circulator."]
["Other","F","A pump other than those listed. Will not comply, unless used as a circulator. "]
[0,"Z","Please select your pump type using the drop-down menu. This cell will provide a description of the pump selected."]
["Poles Options","Reference"]
["-Select-","Z","N/A","Please select your pump's speed."]
["2 Pole","A",2900,"2900 RPM"]
["4 Pole","B",1450,"1450 RPM"]
["Other","C","N/A","A speed other than those listed."]
[0,"Z","N/A","Please select your pump's speed."]
[]
["C-Values for Eff min",null,"Pump Type"]
[null,null,null,"End Suction Own Bearing","End Suction Close Coupled","End Suction Close Coupled Inline","Vertical Multistage","Submersible Multistage","Other"]
[null,null,null,"A","B","C","D","E","F","Z"]
["Poles","2 Pole","A",130.27000000000001,130.77000000000001,133.69,133.94999999999999,128.79,"N/A","TBC"]
[null,"4 Pole","B",128.07,128.46,132.30000000000001,"N/A","N/A","N/A","TBC"]
[null,"Other","C","N/A","N/A","N/A","N/A","N/A","N/A","N/A"]
[null,null,"Z","TBC","TBC","TBC","TBC","TBC","N/A","TBC"]
["Pipe System Types","Internal Reference","Description"]
["-Select-","Z","Please select a non-distributive system to comply with J5.7(d)(i) or a distributive system to comply with J5.7(d)(ii)."]
["Non-distributive","A","A pipework system associated with an air-conditioning system which does not have branches and has the same flow rate throughout the entire pipe network. This is common in primary systems separated from the field."]
["Distributive","B","Any other pipework system associated with an air-conditioning system. This is common for any system which serves multiple coils or units."]
[0,"Z","Please select a non-distributive system to comply with J5.7(d)(i) or a distributive system to comply with J5.7(d)(ii)."]
[]
["Speed Types","Internal Reference"]
["-Select-","Z"]
["Constant Speed","A"]
["Variable Speed","B"]
[0,"Z"]
[]
["Flow Rate Conversions"]
["(All numbers to m3/s)"]
["m³/s",1]
["m³/hr",{"$f":"1/(60*60)","v":2.7777777777777778E-4}]
["L/s",{"$f":"1/1000","v":1E-3}]
["L/hr",{"$f":"1/(1000*60*60)","v":2.7777777777777776E-7}]
[]
["Pressure Drop Conversions"]
["(All numbers to m)"]
["kPa",{"$f":"B53*1000","v":0.10197162129779283}]
["Pa",{"$f":"1/(9.80665*1000)","v":1.0197162129779283E-4}]
["bar",{"$f":"B52*100","v":10.197162129779283}]
["mm",{"$f":"1/1000","v":1E-3}]
["m",1]
["Pump Completion Return Values based on number of blank check cells"]
[]
["Pump stage options","Reference","Description"]
["-Select-","Z","Select the pump's speed using the drop-down menu."]
["Single Stage","A","Most pumps use a single stage."]
["Multistage","B","Some particular pumps use multiple stages with a series of impellers."]
[0,"Z","Select the pump's speed using the drop-down menu."]
[]
["Methods for Pipe PD Calculation"]
["None","Z"]
["Simple","A"]
["Complex","B"]
[0,"Z"]
[]
["Methods for Pump Calculation"]
["None","Z"]
["Simple","A"]
["Alternate","B"]
[0,"Z"]

{"sheet":"Pipe System Lookup Values","index":11,"n_rows":66,"n_cols":14,"rows_kept":66,"cut":false,"hidden":true,"merged":[[3,0,19,0],[1,2,1,7],[29,1,29,2],[46,1,46,2],[29,6,29,7],[46,6,46,7]]}
["Table of Internal Diameters"]
[null,null,"Material",null,null,null,null,null,null,"Allowable selections"]
[null,null,"Copper Type B to AS1432","Light Steel to AS1074","Medium Steel to AS1074","Heavy Steel to AS1074","PVC to AS1477 Class PN12","Custom","Maximum PD",{"$f":"C3","v":"Copper Type B to AS1432"},"Light Steel to AS1074","Medium Steel to AS1074","Heavy Steel to AS1074","PVC to AS1477 Class PN12"]
["Nominal Diameter",6,{"$f":"6.27-0.71*2","v":4.8499999999999996},null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(SEARCH(\"Z\",Configuration_Plus_Design)),Summary!$D$12=\"Z\"),\"\",VLOOKUP(B4,INDIRECT(\"Table\"&Summary!$C$19),HLOOKUP(Summary!$D$12,INDIRECT(\"Mini\"&Summary!$C$19),2,TRUE),TRUE))","v":""},6,8,8,8,20]
[null,8,{"$f":"7.86-2*0.71","v":6.44},{"$f":"13.2-1.8*2","v":9.6},{"$f":"13.3-2.3*2","v":8.7000000000000011},{"$f":"13.3-2.9*2","v":7.5000000000000009},null,null,{"$f":"IF(OR(ISNUMBER(SEARCH(\"Z\",Configuration_Plus_Design)),Summary!$D$12=\"Z\"),\"\",VLOOKUP(B5,INDIRECT(\"Table\"&Summary!$C$19),HLOOKUP(Summary!$D$12,INDIRECT(\"Mini\"&Summary!$C$19),2,TRUE),TRUE))","v":""},8,10,10,10,25]
[null,10,{"$f":"9.44-0.91*2","v":7.6199999999999992},{"$f":"16.7-1.8*2","v":13.1},{"$f":"16.8-2*2.3","v":12.200000000000001},{"$f":"16.8-2.9*2","v":11},null,null,{"$f":"IF(OR(ISNUMBER(SEARCH(\"Z\",Configuration_Plus_Design)),Summary!$D$12=\"Z\"),\"\",VLOOKUP(B6,INDIRECT(\"Table\"&Summary!$C$19),HLOOKUP(Summary!$D$12,INDIRECT(\"Mini\"&Summary!$C$19),2,TRUE),TRUE))","v":""},10,15,15,15,32]
[null,15,{"$f":"12.62-0.91*2","v":10.799999999999999},{"$f":"21-2*2","v":17},{"$f":"21.1-2.6*2","v":15.900000000000002},{"$f":"21.1-3.2*2","v":14.700000000000001},null,null,{"$f":"IF(OR(ISNUMBER(SEARCH(\"Z\",Configuration_Plus_Design)),Summary!$D$12=\"Z\"),\"\",VLOOKUP(B7,INDIRECT(\"Table\"&Summary!$C$19),HLOOKUP(Summary!$D$12,INDIRECT(\"Mini\"&Summary!$C$19),2,TRUE),TRUE))","v":""},15,20,20,20,40]
[null,18,{"$f":"15.8-1.02*2","v":13.760000000000002},null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(SEARCH(\"Z\",Configuration_Plus_Design)),Summary!$D$12=\"Z\"),\"\",VLOOKUP(B8,INDIRECT(\"Table\"&Summary!$C$19),HLOOKUP(Summary!$D$12,INDIRECT(\"Mini\"&Summary!$C$19),2,TRUE),TRUE))","v":""},18,25,25,25,50]
[null,20,{"$f":"18.97-1.02*2","v":16.93},{"$f":"26.4-2.3*2","v":21.799999999999997},{"$f":"26.6-2.6*2","v":21.400000000000002},{"$f":"26.6-3.2*2","v":20.200000000000003},{"$f":"26.6-1.7*2","v":23.200000000000003},null,{"$f":"IF(OR(ISNUMBER(SEARCH(\"Z\",Configuration_Plus_Design)),Summary!$D$12=\"Z\"),\"\",VLOOKUP(B9,INDIRECT(\"Table\"&Summary!$C$19),HLOOKUP(Summary!$D$12,INDIRECT(\"Mini\"&Summary!$C$19),2,TRUE),TRUE))","v":""},20,32,32,32,65]
[null,25,{"$f":"25.3-1.22*2","v":22.86},{"$f":"33.2-2.6*2","v":28.000000000000004},{"$f":"33.4-3.2*2","v":27},{"$f":"33.4-4*2","v":25.4},{"$f":"33.4-2.1*2","v":29.2},null,{"$f":"IF(OR(ISNUMBER(SEARCH(\"Z\",Configuration_Plus_Design)),Summary!$D$12=\"Z\"),\"\",VLOOKUP(B10,INDIRECT(\"Table\"&Summary!$C$19),HLOOKUP(Summary!$D$12,INDIRECT(\"Mini\"&Summary!$C$19),2,TRUE),TRUE))","v":""},25,40,40,40,80]
[null,32,{"$f":"31.65-1.22*2","v":29.209999999999997},{"$f":"41.9-2.6*2","v":36.699999999999996},{"$f":"42.1-3.2*2","v":35.700000000000003},{"$f":"42.1-4*2","v":34.1},{"$f":"42.1-2.6*2","v":36.9},null,{"$f":"IF(OR(ISNUMBER(SEARCH(\"Z\",Configuration_Plus_Design)),Summary!$D$12=\"Z\"),\"\",VLOOKUP(B11,INDIRECT(\"Table\"&Summary!$C$19),HLOOKUP(Summary!$D$12,INDIRECT(\"Mini\"&Summary!$C$19),2,TRUE),TRUE))","v":""},32,50,50,50,100]
[null,40,{"$f":"38-1.22*2","v":35.56},{"$f":"47.8-2.9*2","v":42},{"$f":"48-3.2*2","v":41.6},{"$f":"48-4*2","v":40},{"$f":"48.1-3*2","v":42.1},null,{"$f":"IF(OR(ISNUMBER(SEARCH(\"Z\",Configuration_Plus_Design)),Summary!$D$12=\"Z\"),\"\",VLOOKUP(B12,INDIRECT(\"Table\"&Summary!$C$19),HLOOKUP(Summary!$D$12,INDIRECT(\"Mini\"&Summary!$C$19),2,TRUE),TRUE))","v":""},40,65,65,65,125]
[null,50,{"$f":"50.67-2*1.22","v":48.230000000000004},{"$f":"59.6-2.9*2","v":53.800000000000004},{"$f":"59.8-3.6*2","v":52.599999999999994},{"$f":"59.8-4.5*2","v":50.8},{"$f":"60.2-3.6*2","v":53},null,{"$f":"IF(OR(ISNUMBER(SEARCH(\"Z\",Configuration_Plus_Design)),Summary!$D$12=\"Z\"),\"\",VLOOKUP(B13,INDIRECT(\"Table\"&Summary!$C$19),HLOOKUP(Summary!$D$12,INDIRECT(\"Mini\"&Summary!$C$19),2,TRUE),TRUE))","v":""},50,80,80,80,150]
[null,65,{"$f":"63.35-1.22*2","v":60.910000000000004},{"$f":"75.2-3.2*2","v":68.8},{"$f":"75.4-3.6*2","v":68.2},{"$f":"75.4-4.5*2","v":66.400000000000006},{"$f":"75.2-4.5*2","v":66.2},null,{"$f":"IF(OR(ISNUMBER(SEARCH(\"Z\",Configuration_Plus_Design)),Summary!$D$12=\"Z\"),\"\",VLOOKUP(B14,INDIRECT(\"Table\"&Summary!$C$19),HLOOKUP(Summary!$D$12,INDIRECT(\"Mini\"&Summary!$C$19),2,TRUE),TRUE))","v":""},65,100,100,100,200]
[null,80,{"$f":"76.02-1.63*2","v":72.759999999999991},{"$f":"87.9-3.2*2","v":81.5},{"$f":"88.1-4*2","v":80.099999999999994},{"$f":"88.1-5*2","v":78.099999999999994},{"$f":"88.7-5.3*2","v":78.100000000000009},null,{"$f":"IF(OR(ISNUMBER(SEARCH(\"Z\",Configuration_Plus_Design)),Summary!$D$12=\"Z\"),\"\",VLOOKUP(B15,INDIRECT(\"Table\"&Summary!$C$19),HLOOKUP(Summary!$D$12,INDIRECT(\"Mini\"&Summary!$C$19),2,TRUE),TRUE))","v":""},80,null,125,125]
[null,90,{"$f":"88.7-1.63*2","v":85.44},null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(SEARCH(\"Z\",Configuration_Plus_Design)),Summary!$D$12=\"Z\"),\"\",VLOOKUP(B16,INDIRECT(\"Table\"&Summary!$C$19),HLOOKUP(Summary!$D$12,INDIRECT(\"Mini\"&Summary!$C$19),2,TRUE),TRUE))","v":""},90,null,150,150]
[null,100,{"$f":"101.35-2*1.63","v":98.089999999999989},{"$f":"113-3.6*2","v":105.8},{"$f":"113.3-4.5*2","v":104.3},{"$f":"113.3-5.4*2","v":102.5},{"$f":"114.1-6.7*2","v":100.69999999999999},null,{"$f":"IF(OR(ISNUMBER(SEARCH(\"Z\",Configuration_Plus_Design)),Summary!$D$12=\"Z\"),\"\",VLOOKUP(B17,INDIRECT(\"Table\"&Summary!$C$19),HLOOKUP(Summary!$D$12,INDIRECT(\"Mini\"&Summary!$C$19),2,TRUE),TRUE))","v":""},100]
[null,125,{"$f":"126.75-2*1.63","v":123.49},null,{"$f":"138.7-5*2","v":128.69999999999999},{"$f":"138.7-5.4*2","v":127.89999999999999},{"$f":"140-8.1*2","v":123.8},null,{"$f":"IF(OR(ISNUMBER(SEARCH(\"Z\",Configuration_Plus_Design)),Summary!$D$12=\"Z\"),\"\",VLOOKUP(B18,INDIRECT(\"Table\"&Summary!$C$19),HLOOKUP(Summary!$D$12,INDIRECT(\"Mini\"&Summary!$C$19),2,TRUE),TRUE))","v":""},125]
[null,150,{"$f":"152.1-2.03*2","v":148.04},null,{"$f":"164.1-5*2","v":154.1},{"$f":"164.1-5.4*2","v":153.29999999999998},{"$f":"160-9.3*2","v":141.4},null,{"$f":"IF(OR(ISNUMBER(SEARCH(\"Z\",Configuration_Plus_Design)),Summary!$D$12=\"Z\"),\"\",VLOOKUP(B19,INDIRECT(\"Table\"&Summary!$C$19),HLOOKUP(Summary!$D$12,INDIRECT(\"Mini\"&Summary!$C$19),2,TRUE),TRUE))","v":""},150]
[null,200,{"$f":"202.8-2.03*2","v":198.74},null,null,null,{"$f":"225-11.7*2","v":201.6},null,{"$f":"IF(OR(ISNUMBER(SEARCH(\"Z\",Configuration_Plus_Design)),Summary!$D$12=\"Z\"),\"\",VLOOKUP(B20,INDIRECT(\"Table\"&Summary!$C$19),HLOOKUP(Summary!$D$12,INDIRECT(\"Mini\"&Summary!$C$19),2,TRUE),TRUE))","v":""},200]
[null,"End"]
[]
[]
["Maximum Pressure Drops"]
[]
["Table J5.7B - Constant Speed, No Branches",null,null,null,null,"Table J5.7D - Constant Speed, Distributive"]
["Minimum Diameter","A","B","C","Z","Minimum Diameter","A","B","C","Z"]
[1,2,3,4,5,1,2,3,4,5]
[]
["AA","Minimum Hours",null,null,null,"BA","Minimum Hours"]
[null,"2000 or Less","Between 2000 and 5000","More than 5000","Z",null,"2000 or Less","Between 2000 and 5000","More than 5000","Z"]
[0,400,400,400,null,0,400,300,150]
[25,400,400,400,null,25,400,220,100]
[32,400,400,400,null,32,400,220,100]
[40,400,400,400,null,40,400,220,100]
[50,400,400,350,null,50,400,220,100]
[65,400,400,350,null,65,400,400,170]
[80,400,400,350,null,80,400,400,170]
[100,400,400,200,null,100,400,400,170]
[125,400,400,200,null,125,400,400,170]
[150,400,400,200,null,150,400,400,170]
[]
["Table J5.7C - Variable Speed, No Branches",null,null,null,null,"Table J5.7E - Variable Speed, Distributive"]
["Minimum Diameter","A","B","C","Z","Minimum Diameter","A","B","C","Z"]
[1,2,3,4,5,1,2,3,4,5]
[]
["AB","Minimum Hours",null,null,null,"BB","Minimum Hours"]
[null,"2000 or Less","Between 2000 and 5000","More than 5000","Z",null,"2000 or Less","Between 2000 and 5000","More than 5000","Z"]
[0,400,400,400,null,0,400,400,250]
[25,400,400,400,null,25,400,400,180]
[32,400,400,400,null,32,400,400,180]
[40,400,400,400,null,40,400,400,180]
[50,400,400,400,null,50,400,400,180]
[65,400,400,400,null,65,400,400,300]
[80,400,400,400,null,80,400,400,300]
[100,400,400,300,null,100,400,400,300]
[125,400,400,300,null,125,400,400,300]
[150,400,400,300,null,150,400,400,300]
[]
["Selection Lookup Table"]
["Selection","Tag","Column Number"]
["-Select-","Z",5]
["2000 or Less","A",2]
["Between 2000 and 5000","B",3]
["More than 5000","C",4]
[0,"Z",5]

{"sheet":"Water Properties","index":12,"n_rows":102,"n_cols":3,"rows_kept":102,"cut":false,"hidden":true,"merged":[]}
["Temperature","Dynamic Viscosity","Density"]
[0.01,1.782,999.8]
[1,1.724,999.8]
[2,1.6990000000000001,999.9]
[3,1.6160000000000001,999.9]
[4,1.5649999999999999,999.9]
[5,1.5169999999999999,999.9]
[6,1.4710000000000001,999.9]
[7,1.427,999.9]
[8,1.385,999.8]
[9,1.3340000000000001,999.7]
[10,1.306,999.7]
[11,1.2689999999999999,999.6]
[12,1.234,999.4]
[13,1.2010000000000001,999.3]
[14,1.169,999.2]
[15,1.1379999999999999,999]
[16,1.1080000000000001,998.9]
[17,1.08,998.7]
[18,1.0529999999999999,998.6]
[19,1.0269999999999999,998.4]
[20,1.002,998.2]
[21,0.97799999999999998,997.9]
[22,0.95499999999999996,997.7]
[23,0.93200000000000005,997.5]
[24,0.91100000000000003,997.2]
[25,0.89,997]
[26,0.87,996.7]
[27,0.85099999999999998,996.5]
[28,0.83299999999999996,996.2]
[29,0.81499999999999995,995.9]
[30,0.79800000000000004,995.6]
[31,0.78100000000000003,995.3]
[32,0.76500000000000001,995]
[33,0.749,994.6]
[34,0.73399999999999999,994.3]
[35,0.71899999999999997,994]
[36,0.70499999999999996,993.6]
[37,0.69199999999999995,993.3]
[38,0.67800000000000005,993]
[39,0.66600000000000004,992.6]
[40,0.65300000000000002,992.2]
[41,0.64100000000000001,991.8]
[{"$f":"A43+1","v":42},0.629,991.4]
[{"$f":"A44+1","v":43},0.61799999999999999,991]
[44,0.60599999999999998,990.6]
[45,0.59599999999999997,990.2]
[46,0.58599999999999997,989.8]
[47,0.57599999999999996,989.3]
[48,0.56599999999999995,988.9]
[49,0.55600000000000005,988.5]
[50,0.54700000000000004,988]
[51,0.53800000000000003,987.6]
[52,0.52900000000000003,987.2]
[53,0.52100000000000002,986.7]
[54,0.51200000000000001,986.2]
[55,0.504,985.7]
[56,0.496,985.2]
[57,0.48899999999999999,984.7]
[58,0.48099999999999998,984.3]
[59,0.47399999999999998,983.7]
[60,0.46700000000000003,983.2]
[61,0.46,982.7]
[62,0.45300000000000001,982.1]
[63,0.44700000000000001,981.6]
[64,0.44,981.1]
[65,0.434,980.5]
[66,0.42799999999999999,979.9]
[67,0.42199999999999999,979.4]
[68,0.41599999999999998,978.9]
[69,0.41,978.3]
[70,0.40400000000000003,977.7]
[71,0.39900000000000002,977.1]
[72,0.39400000000000002,976.6]
[73,0.38800000000000001,976]
[74,0.38300000000000001,975.4]
[75,0.378,974.9]
[76,0.373,974.3]
[77,0.36899999999999999,973.6]
[78,0.36399999999999999,973.1]
[79,0.35899999999999999,972.5]
[80,0.35499999999999998,971.8]
[81,0.35,971.2]
[{"$f":"A83+1","v":82},0.34599999999999997,970.6]
[{"$f":"A84+1","v":83},0.34200000000000003,969.9]
[84,0.33800000000000002,969.3]
[85,0.33400000000000002,968.6]
[86,0.33,968]
[87,0.32600000000000001,967.3]
[88,0.32200000000000001,966.7]
[89,0.318,966]
[90,0.314,965.3]
[91,0.311,964.7]
[92,0.307,964]
[93,0.30399999999999999,963.3]
[94,0.3,962.7]
[95,0.29699999999999999,961.9]
[{"$f":"A97+1","v":96},0.29399999999999998,961.2]
[97,0.29099999999999998,960.5]
[98,0.28699999999999998,959.8]
[99,0.28399999999999997,959.1]
[100,0.28100000000000003,958.3]

{"sheet":"Worksheet","index":13,"n_rows":5,"n_cols":1,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
["User's worksheet:"]
["This worksheet has been added for recording notes and making calculations (where desired)."]
["To maintain the integrity of the Calculator, this sheet is protected, which may cause some unavoidable restrictions on the functions available."]
["All cells below row 5 are accessible for user input, editing and formatting, subject to the limitations due to protection."]
["Use of this worksheet and responsibility for its contents and consequences remains entirely with the user."]