{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Error","All Systems","Report Template","Summary","Duct Details (Template)","Duct Details (170)","Fan Details","Help Guide","Report","Worksheet","Lists for Drop Down Selectors"],"not_rendered":{"charts":0,"images":23,"macros":1,"external_links":0,"defined_names":95,"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":[]}
[]
["Calculator"]
["The Fan 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":46,"rows_kept":23,"cut":false,"hidden":true,"merged":[[14,20,14,21],[4,1,4,6],[5,1,5,6],[3,1,3,12],[3,14,3,21],[4,15,4,16],[4,18,4,19],[4,20,4,21],[5,20,5,21],[4,11,4,12],[5,11,5,12],[4,9,4,10],[5,9,5,10],[4,7,4,8],[5,7,5,8],[5,18,5,19],[5,15,5,16],[23,1,23,3],[18,1,18,21],[17,1,17,21],[20,1,20,21],[10,6,11,7],[13,20,13,21],[10,3,11,3],[10,17,10,19],[10,20,11,21],[10,1,11,1],[10,2,11,2],[10,4,11,4],[12,20,12,21],[10,8,10,10],[9,1,9,45],[10,39,10,41],[10,42,10,45],[10,5,11,5],[10,36,10,38],[10,11,10,13],[10,14,10,16]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Calculator  "]
[]
[null,"Project Information",null,null,null,null,null,null,null,null,null,null,null,null,"Colour Guide"]
[null,"Building Name and Description",null,null,null,null,null,"Project Number",null,"Designer",null,"Company",null,null,"Input","Calculated",null,"N/A","Compliant",null,"Non-compliant"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gold","White",null,"Grey","Green",null,"Red"]
[]
[null,null,null,null,null,"Formula reference","VBA reference","Row number"]
[null,null,"Active System",1,"Duct Spreadsheet References",{"$f":"CONCATENATE(\"'\",G9,\"'\")","v":"'Duct Details (170)'"},"Duct Details (170)",{"$f":"14+Active_System_Number","v":15},null,"Next ID Number",174]
[null,"Systems"]
[null,"Controls","ID","System Description","Fan Tag","Flow Rate (L/s)","Configuration",null,"Straight Duct PD (Pa)",null,null,"Fitting PD (Pa)",null,null,"Efficiency (%)",null,null,"Motor Input Power (kW)",null,null,"Summary",null,"Dummy",{"$f":"Summary!B9","v":"Fan Type"},{"$f":"Summary!D9","v":"Fan Inlet"},{"$f":"Summary!E9","v":"Fan Outlet"},{"$f":"Summary!F9","v":"Fouling Risk"},"Dummy",{"$f":"Summary!C15","v":"Role"},{"$f":"'Fan Details'!C17","v":"Design Static Pressure Pa"},{"$f":"'Fan Details'!B21","v":"Motor Input Power"},{"$f":"'Fan Details'!C21","v":"System Total Efficiency"},"Duct Worksheet name (VBA)","Duct worksheet name (Excel)","Active & Compliant","Summary","Basic Requirements",null,null,"Component Requirements",null,null,"System Requirements"]
[null,null,null,null,null,null,null,null,"Calculated","Allowable",null,"Calculated","Allowable",null,"Calculated","Allowable",null,"Calculated","Allowable",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Summary!B20","v":"Requirements Applicable"},{"$f":"Summary!C20","v":0},{"$f":"Summary!D20","v":0},{"$f":"Summary!B24","v":"Index Run"},{"$f":"Summary!C24","v":"Fan"},{"$f":"Summary!D24","v":"Overall"},{"$f":"Summary!B28","v":"Efficiency"},{"$f":"Summary!C28","v":"Pressure Drop"},{"$f":"Summary!D28","v":"Motor Power"},{"$f":"Summary!E28","v":"Overall"}]
[null,null,2,null,null,null,"Incomplete",null,"TBC","TBC",null,"TBC","TBC",null,null,"TBC",null,"TBC","TBC",null,"Insufficient Information",null,null,"-Select-","-Select-","-Select-","-Select-",null,"-Select-",null,null,null,"Duct Details (160)",{"$f":"CONCATENATE(\"'\",AG13,\"'\")","v":"'Duct Details (160)'"},{"$f":"CONCATENATE(IF(Active_System_Number=C13,1,0),U13)","v":"0Insufficient Information"},"More data is required before it can be determined whether the requirements are applicable to the system.\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",null,null,"Insufficient Information","Insufficient Information","Insufficient Information","Insufficient Information","Insufficient Information","Insufficient Information","Insufficient Information"]
[null,null,1,"ABC","XYZ",5000,"Complete",null,0.38320082079850321,5,null,60.904249286156983,75.904249286156983,null,0.45,0.35138258823251323,null,1.6666666666666667,2.8176095176214773,null,"Satisfies Part J5.4",null,null,"Axial - other","Ducted","Ducted","No",null,"Any other air-conditioning or ventilation fan",150,2,0.45,"Duct Details (169)",{"$f":"CONCATENATE(\"'\",AG14,\"'\")","v":"'Duct Details (169)'"},"1Satisfies Part J5.4","The fan system satisfies Part J5.4 on both component and systemic levels.\r\n\r\nThe length of flexible duct in the index run satisfies Part J5.4.\r\nThe sections of straight duct in the index run have an average pressure drop which satisfies Part J5.4.\r\nThe duct fittings in the index run satisfy the DTS Provisions of Part J5.4.\r\nConsidering these elements, the index run satisfies Part J5.4 on a component level.\r\nThe fan's efficiency satisfies Part J5.4 on a component level.\r\n\r\nThis calculator does not check whether the upstream connections to ductwork bends, elbows and tees in the index run have an equivalent diameter to the connected duct per J5.4(c)(iii). Ensure you check whether your system satisfies this provision, and if not, make suitable allowances in systemic energy usage calculations for the pressure drop differences which would result.","Applicable",null,null,"Satisfies Part J5.4","Satisfies Part J5.4","Satisfies Part J5.4",-0.21914980392774841,-0.24246933074945431,-0.40848202838496739,"Satisfies Part J5.4"]
[null,null,1,null,null,null,"Incomplete",null,"TBC","TBC",null,"TBC","TBC",null,null,"TBC",null,"TBC","TBC",null,"Insufficient Information",null,null,"-Select-","-Select-","-Select-","-Select-",null,"-Select-",null,null,null,"Duct Details (170)",{"$f":"CONCATENATE(\"'\",AG15,\"'\")","v":"'Duct Details (170)'"},{"$f":"CONCATENATE(IF(Active_System_Number=C15,1,0),U15)","v":"1Insufficient Information"},"More data is required before it can be determined whether the requirements are applicable to the system.\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",null,null,"Insufficient Information","Insufficient Information","Insufficient Information","Insufficient Information","Insufficient Information","Insufficient Information","Insufficient Information"]
[null,"Complete",null,null,null,"Complete",null,"TBC","TBC",null,"TBC","TBC",null,null,"TBC",null,"TBC","TBC",null,"Not Applicable",null,null,null,"Axial - other","Ducted","Ducted","No",null,"Smoke spill only",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","Not Applicable",null,null,"Insufficient Information","Insufficient Information","Not Applicable","Insufficient Information","Insufficient Information","Insufficient Information","Not Applicable"]
[]
[null,"Notice for new users:"]
[null,"The Fan System Calculator uses a custom ribbon for navigation. For more guidance on this tool, please click the Help button on the ribbon above."]
[null,"Notice for all users:"]
[null,"The Fan 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 FAN SYSTEM CALCULATOR"]

{"sheet":"Report Template","index":2,"n_rows":40,"n_cols":5,"rows_kept":40,"cut":false,"hidden":true,"merged":[[11,1,11,2],[32,3,32,4],[33,3,33,4],[31,0,31,4],[24,0,24,1],[39,1,39,4],[36,0,36,4],[3,0,3,4],[4,0,4,1],[5,0,5,1],[25,0,25,1],[35,0,35,4],[27,0,27,2],[7,0,7,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[16,0,16,2],[8,1,8,2],[9,1,9,2],[10,1,10,2]]}
[]
[null,null,null,null,"Calculator"]
[]
["Project Information"]
[{"$f":"'All Systems'!B5","v":"Building Name and Description"},null,{"$f":"'All Systems'!H5","v":"Project Number"},{"$f":"'All Systems'!J5","v":"Designer"},{"$f":"'All Systems'!L5","v":"Company"}]
[{"$f":"IF('All Systems'!B6=\"\",\"\",'All Systems'!B6)","v":""},null,{"$f":"IF('All Systems'!H6=\"\",\"\",'All Systems'!H6)","v":""},{"$f":"IF('All Systems'!J6=\"\",\"\",'All Systems'!J6)","v":""},{"$f":"IF('All Systems'!L6=\"\",\"\",'All Systems'!L6)","v":""}]
[]
["System Information"]
["Fan Tag:"]
["Description:"]
["Type:"]
["Role:"]
["Inlet:"]
["Outlet:"]
["Flow Rate:"]
[]
["Calculation Summary"]
["Component","System","Allowable"]
["Pressure Drop"]
["Straight PD"]
["Fitting PD"]
["Fan Efficiency"]
["Motor Input Power"]
[]
["Requirements Applicable"]
[]
[]
["Component Level"]
["Index Run","Fan","Overall"]
[]
[]
["System Level"]
["Efficiency","Pressure Drop","Motor Power","Overall"]
[]
[]
["Result"]
[]
["Version number: 1.0"]
["IMPORTANT NOTICE AND DISCLAIMER IN RESPECT OF THIS FAN SYSTEM CALCULATOR"]
[null,"IMPORTANT NOTICE AND DISCLAIMER IN RESPECT OF THIS FAN SYSTEM CALCULATOR"]

{"sheet":"Summary","index":3,"n_rows":40,"n_cols":6,"rows_kept":40,"cut":false,"hidden":true,"merged":[[45,0,45,2],[7,1,7,4],[4,1,4,2],[5,1,5,2],[3,1,3,5],[26,1,26,4],[33,1,33,5],[22,1,22,3],[8,1,8,2],[9,1,9,2],[32,1,32,5],[15,2,15,3],[14,2,14,3],[19,1,19,2],[20,1,20,2],[13,1,13,3]]}
[]
[null,null,null,null,null,"Calculator"]
[]
[null,"System General Information"]
[null,"Building Name and Description",null,"Project Number","Fan Tag","System Description"]
[null,{"$f":"IF('All Systems'!B6=\"\",\"\",'All Systems'!B6)","v":""},null,{"$f":"IF('All Systems'!H6=\"\",\"\",'All Systems'!H6)","v":""},{"$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,"Fan Type",null,"Fan Inlet","Fan Outlet","Fouling Risk"]
[null,"-Select-",null,"-Select-","-Select-","-Select-"]
[]
[null,"Installation Type",{"$f":"IFERROR(INDEX('Lists for Drop Down Selectors'!C36:E38,HLOOKUP(D10,'Lists for Drop Down Selectors'!C34:E35,2,FALSE),HLOOKUP(Summary!E10,'Lists for Drop Down Selectors'!C34:E35,2,FALSE)),\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(VLOOKUP(F10,'Lists for Drop Down Selectors'!H4:I7,2,FALSE),\"B\")","v":"B"}]
[]
[null,"Fan Characteristics"]
[null,"Flow Rate L/s","Role"]
[null,{"$f":"INDIRECT(\"'All Systems'!F\" & Active_System_RowNo)","v":0},"-Select-"]
[null,null,null,{"$f":"VLOOKUP(C16,'Lists for Drop Down Selectors'!E11:F19,2,FALSE)","v":"Z"},"Configuration Complete?",{"$f":"IF(COUNTIF(B10,\"-Select-\")+COUNTIF(C16:C16,\"-Select-\")+COUNTBLANK(B10)+COUNTBLANK(C16:C16)+COUNTIF(D10:F10,\"-Select-\")+COUNTBLANK(D10:F10)>0,\"Incomplete\",\"Complete\")","v":"Incomplete"}]
[]
[null,"Installation Type",{"$f":"Summary!C12","v":"N/A"},"Requirements applicable",{"$f":"IF(OR(D17=\"A\",AND(C19=\"A\",B16<1000,ISNUMBER(B16))),\"Not Applicable\",IF(OR(B16=\"\",D17=\"Z\",C19=\"Z\"),\"Insufficient Information\",\"Applicable\"))","v":"Insufficient Information"}]
[null,"Requirements Applicable"]
[null,{"$f":"Summary!E19","v":"Insufficient Information"}]
[]
[null,"Component Level"]
[null,"Index Run","Fan","Overall"]
[null,{"$f":"INDIRECT('All Systems'!F9 &\"!Ductwork_Component_Compliance\")","v":"Insufficient Information"},{"$f":"'Fan Details'!C33","v":"Insufficient Information"},{"$f":"IF(COUNTIF(B25:C25,\"N/A\")>0,\"Invalid Selection\",IF(COUNTIF(B25:C25,\"Not Applicable\")+COUNTIF(B21:D21,\"Not Applicable\")>0,\"Not Applicable\",IF(COUNTIF(B25:C25,\"Part J5.4 Not Satisfied\")+COUNTIF(B21:D21,\"Part J5.4 Not Satisfied\")>0,\"Part J5.4 Not Satisfied\",IF(COUNTIF(B25:C25,\"Insufficient Information\")+COUNTIF(B21:D21,\"Insufficient Information\")>0,\"Insufficient Information\",\"Satisfies Part J5.4\"))))","v":"Insufficient Information"}]
[]
[null,"System Level"]
[null,"Efficiency","Pressure Drop","Motor Power","Overall"]
[null,{"$f":"IF(COUNTBLANK('Fan Details'!B33)+COUNTBLANK('Fan Details'!C23)+COUNTIF('Fan Details'!B33,\"Insufficient Information\")+COUNTIF('Fan Details'!C23,\"Insufficient Information\")>0,\"Insufficient Information\",IFERROR('Fan Details'!B33/'Fan Details'!C23-1,\"Insufficienct Information\"))","v":"Insufficient Information"},{"$f":"IF(C31>0,\"Not Evaluated\",IFERROR(INDIRECT('All Systems'!F9 &\"!Total_Calculated_PD\")/INDIRECT('All Systems'!F9 &\"!Total_Allowable_PD\")-1,\"Insufficient Information\"))","v":"Insufficient Information"},{"$f":"IF(COUNTIF(B29:C29,\"Not Evaluated\")>0,\"Not Evaluated\",IF(COUNTBLANK(B29:C29)+COUNTIF(B29:C29,\"Insufficient Information\")>0,\"Insufficient Information\",IFERROR((B29+1)*(C29+1)-1,\"Insufficient Information\")))","v":"Insufficient Information"},{"$f":"IF(B21=\"Not Applicable\",\"Not Applicable\",IF(COUNTIF(C21:D21,\"Part J5.4 Not Satisfied\")>0,\"Part J5.4 Not Satisfied\",IF(COUNTIF(B21:D21,\"Insufficient Information\")>0,\"Insufficient Information\",IF(COUNTIF(B29:D29,\"Not Evaluated\")>0,\"Not Evaluated\",IF(COUNTBLANK(B29:D29)+COUNTIF(B29:D29,\"Insufficient Information\")>0,\"Insufficient Information\",IF(D29<0,\"Satisfies Part J5.4\",\"Part J5.4 Not Satisfied\"))))))","v":"Insufficient Information"}]
[]
[null,null,{"$f":"IF(F12=\"B\",INDIRECT('All Systems'!F9 & \"!Non_Compliant_Bends\"),0)","v":0},null,null,"Non-compliance check"]
[null,{"$f":"INDIRECT('All Systems'!F9 & \"!Straight_Compliance\")","v":"Insufficient Information"},{"$f":"INDIRECT('All Systems'!F9 & \"!Bends_or_Others\")","v":0},{"$f":"INDIRECT('All Systems'!F9 & \"!All_Fittings_Compliance\")","v":"Insufficient Information"},{"$f":"INDIRECT('All Systems'!F9 & \"!Ductwork_Component_Compliance\")","v":"Insufficient Information"},{"$f":"INDIRECT('All Systems'!F9 & \"!Do_any_rows_not_comply\")","v":"NO"}]
[null,"Result"]
[null,"More data is required before it can be determined whether the requirements are applicable to the system.\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"]
[null,"Motor Input Power","Allowed Motor Input Power","Compliant Total","Flexible Duct"]
[null,{"$f":"IFERROR(B16*'Fan Details'!C18/(Fan_Efficiency*1000^2),\"TBC\")","v":"TBC"},{"$f":"IFERROR(B16*'Fan Details'!C18*INDIRECT('All Systems'!F9 & \"!Total_Allowable_PD\")/INDIRECT('All Systems'!F9 & \"!Total_Calculated_PD\")/(Fan_Efficiency_Required*1000^2),\"TBC\")","v":"TBC"},{"$f":"IF(OR(D25=\"Not Applicable\",E29=\"Not Applicable\"),\"Not Applicable\",IF(OR(D25=\"Satisfies Part J5.4\",E29=\"Satisfies Part J5.4\"),\"Satisfies Part J5.4\",IF(OR(D25=\"Part J5.4 Not Satisfied\",E29=\"Part J5.4 Not Satisfied\"),\"Part J5.4 Not Satisfied\",\"Insufficient Information\")))","v":"Insufficient Information"},{"$f":"INDIRECT('All Systems'!F9 & \"!Flexible_Duct_Compliance\")","v":"Insufficient Information"}]
[]
[]
[null,null,null,null,null,"Version number: 1.1"]
["IMPORTANT NOTICE AND DISCLAIMER IN RESPECT OF THIS FAN SYSTEM CALCULATOR"]

{"sheet":"Duct Details (Template)","index":4,"n_rows":32,"n_cols":40,"rows_kept":32,"cut":false,"hidden":true,"merged":[[5,10,5,15],[4,10,4,15],[4,7,4,9],[4,1,4,6],[5,1,5,6],[3,1,3,15],[5,7,5,9],[29,7,29,8],[28,9,28,11],[29,9,29,11],[27,1,27,11],[23,1,23,2],[29,1,29,2],[28,1,28,2],[28,5,28,6],[29,5,29,6],[28,3,28,4],[29,3,29,4],[24,1,24,2],[25,1,25,2],[22,1,22,2],[28,7,28,8],[7,1,7,7],[8,1,8,4],[9,1,9,4],[21,1,21,4],[11,1,11,38]]}
[]
[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,"Calculator"]
[]
[null,"System General Information"]
[null,{"$f":"Summary!B5","v":"Building Name and Description"},null,null,null,null,null,{"$f":"Summary!E5","v":"Fan Tag"},null,null,{"$f":"Summary!F5","v":"System Description"}]
[null,{"$f":"IF(Summary!B6=\"\",\"\",Summary!B6)","v":""},null,null,null,null,null,{"$f":"IF(Summary!E6=\"\",\"\",Summary!E6)","v":""},null,null,{"$f":"IF(Summary!F6=\"\",\"\",Summary!F6)","v":""}]
[]
[null,"System Characteristics"]
[null,{"$f":"Summary!B9","v":"Fan Type"},null,null,null,{"$f":"Summary!D9","v":"Fan Inlet"},{"$f":"Summary!E9","v":"Fan Outlet"},{"$f":"Summary!F9","v":"Fouling Risk"}]
[null,{"$f":"IF(Summary!B10=\"\",\"\",Summary!B10)","v":"-Select-"},null,null,null,{"$f":"IF(Summary!D10=\"\",\"\",Summary!D10)","v":"-Select-"},{"$f":"IF(Summary!E10=\"\",\"\",Summary!E10)","v":"-Select-"},{"$f":"IF(Summary!F10=\"\",\"\",Summary!F10)","v":"-Select-"}]
[]
[null,"Index Run Details"]
[null,"ID","Description","Duct Shape","Component Type","Fitting Type","Specific Fitting","Temperature","Flow Rate","Width","Height","Diameter","Length","Roughness","Fitting Loss Coefficient Kt","Pressure Drop","Straight Pressure Drop","Allowable Pressure Drop","Fitting Pressure Drop","Allowable Fitting PD","Fitting Type Code",null,null,"Equivalent Diameter (PD)","Equivalent Diameter (Velocity)","Flow Rate For Iterative Solving","Fluid Density","Absolute Viscosity","Velocity","Total Straight PD","Compliant","Length of Flex"]
[null,null,null,null,null,null,null,"°C","L/s","mm","mm","mm","m","mm",null,"Pa","Pa/m","Pa","Pa","Pa",null,null,null,"m","m","L/s","kg/m³","kg/ms","m/s","Pa"]
[null,"Controls",{"$f":"IF(ISBLANK(B14),B13,B13 & CHAR(10) & B14)","v":"ID"},"Description","Duct Shape","Component Type","Fitting Type","Specific Fitting","Temperature\n°C","Flow Rate\nL/s","Width\nmm","Height\nmm","Diameter\nmm","Length\nm","Roughness\nmm","Fitting Loss Coefficient Kt",{"$f":"IF(ISBLANK(P14),P13,P13 & CHAR(10) & P14)","v":"Pressure Drop\nPa"},{"$f":"IF(ISBLANK(Q14),Q13,Q13 & CHAR(10) & Q14)","v":"Straight Pressure Drop\nPa/m"},{"$f":"IF(ISBLANK(R14),R13,R13 & CHAR(10) & R14)","v":"Allowable Pressure Drop\nPa"},"Fitting Pressure Drop\nPa","Allowable Fitting PD\nPa",{"$f":"IF(ISBLANK(U14),U13,U13 & CHAR(10) & U14)","v":"Fitting Type Code"},"Internal Reference","Ready for DP Calc","Equivalent Diameter (PD)\nm","Equivalent Diameter (Velocity)\nm","Flow Rate For Iterative Solving\nL/s","Fluid Density\nkg/m³","Absolute Viscosity\nkg/ms","Velocity\nm/s",{"$f":"IF(ISBLANK(AD14),AD13,AD13 & CHAR(10) & AD14)","v":"Total Straight PD\nPa"},"Satisfactory",{"$f":"IF(ISBLANK(AF14),AF13,AF13 & CHAR(10) & AF14)","v":"Length of Flex"},"Reynolds Number","Pressure Drop Formula To Copy","Compliant fitting PD to copy","Type+Compliance","Filter alternate maximum","Lastref"]
[null,null,0,null,"-Select-","-Select-",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(RIGHT(W16,1)=\"A\",AE16,IF(OR(RIGHT(W16,1)=\"B\",RIGHT(W16,1)=\"C\"),T16,\"\"))","v":""},null,{"$f":"IF(RIGHT(W16,1)=\"A\",N16*1,IF(OR(RIGHT(W16,1)=\"B\",RIGHT(W16,1)=\"C\"),U16,\"\"))","v":""},{"$f":"IF(AND(OR(RIGHT(W16,1)=\"C\",RIGHT(W16,1)=\"B\"),COUNTBLANK(Q16)=0),Q16,IF(RIGHT(W16,1)=\"A\",\"\",\"TBC\"))","v":"TBC"},{"$f":"IF(RIGHT(W16,1)=\"A\",\"\",IFERROR(IF(AND(AL16>0,ISNUMBER(AL16)),MAX(VLOOKUP(H16,INDIRECT(\"Allowable\"&V16),2,FALSE),AL16),VLOOKUP(H16,INDIRECT(\"Allowable\"&V16),2,FALSE)),\"TBC\"))","v":"TBC"},{"$f":"IFERROR(VLOOKUP(G16,'Lists for Drop Down Selectors'!$A$41:$B$57,2,FALSE),\"Z\")","v":"Z"},{"$f":"CONCATENATE(IFERROR(VLOOKUP(E16,'Lists for Drop Down Selectors'!$A$11:$B$15,2,FALSE),\"Z\"),IFERROR(VLOOKUP(F16,'Lists for Drop Down Selectors'!$A$4:$B$8,2,FALSE),\"Z\"))","v":"ZZ"},{"$f":"AND(RIGHT(W16,1)=\"A\",COUNTBLANK(Y16)=0,COUNTBLANK(O16)=0,COUNTBLANK(I16:J16)=0)","v":false},{"$f":"IF(LEFT(W16,1)=\"A\",IF(COUNTBLANK(K16:L16)=0,IFERROR(((32*(L16/1000)^3*(K16/1000)^3)/((PI()^2)*((L16/1000)+(K16/1000))))^(1/5),\"\"),\"\"),IF(AND(OR(LEFT(W16,1)=\"B\",LEFT(W16,1)=\"C\"),COUNTBLANK(M16)=0),IFERROR(M16/1000,\"\"),\"\"))","v":""},{"$f":"IF(LEFT(W16,1)=\"A\",IF(COUNTBLANK(K16:L16)=0,IFERROR((4*(K16/1000)*(L16/1000)/PI())^0.5,\"\"),\"\"),IF(AND(OR(LEFT(W16,1)=\"B\",LEFT(W16,1)=\"C\"),COUNTBLANK(M16)=0),IFERROR(M16/1000,\"\"),\"\"))","v":""},{"$f":"IFERROR(-1000*PI()*(R16*Y16^5/(2*AB16))^0.5*LOG(((O16/1000)/(3.7*Y16))+(1.255*(AC16)/AB16)/(R16*Y16^3/(2*AB16))^0.5),\"\")","v":""},{"$f":"IF(ISBLANK(I16),\"\",IFERROR(1000*101.325/(287.058*(273.15+I16)),\"\"))","v":""},{"$f":"IF(ISBLANK(I16),\"\",IFERROR(0.00001716*(((I16+273.15)/273.15)^(3/2))*((273.15+110.4)/(273.15+I16+110.4)),\"\"))","v":""},{"$f":"IF(AND(J16>0,Z16>0,COUNTBLANK(J16)=0,COUNTBLANK(Z16)=0),IFERROR(J16/(PI()*(Z16/2)^2)/1000,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(W16,1)=\"A\",IF(OR(N16=\"\",R16=\"\",R16=\"TBC\"),\"TBC\",IFERROR(N16*R16,\"TBC\")),\"\")","v":""},{"$f":"IF(RIGHT(W16,1)=\"A\",IF(OR(R16=\"TBC\",ISBLANK(R16)),\"TBC\",IF(R16<1,\"YES\",\"NO\")),IF(OR(COUNTBLANK(T16:U16)>0,U16=\"TBC\",T16=\"TBC\"),\"TBC\",IF(OR(RIGHT(W16,1)=\"B\",RIGHT(W16,1)=\"C\"),IF(OR(T16<=U16,U16=\"N/A\"),\"YES\",\"NO\"),\"TBC\")))","v":"TBC"},{"$f":"IF(LEFT(W16,1)=\"C\",N16,0)","v":0},{"$f":"IFERROR(AB16*(J16/1000)*Y16/((PI()*(Y16/2)^2)*(AC16)),0)","v":0},{"$f":"IF(RIGHT(W16,1)=\"A\",AE16,IF(OR(RIGHT(W16,1)=\"B\",RIGHT(W16,1)=\"C\"),IF(OR(P16=\"\",P16=0,AD16=\"\"),\"TBC\",IFERROR(P16*0.5*AB16*AD16^2,\"TBC\")),\"TBC\"))","v":"TBC"},{"$f":"IFERROR(IF(AND(AL16>0,ISNUMBER(AL16)),MAX(VLOOKUP(H16,INDIRECT(\"Allowable\"&V16),2,FALSE),AL16),VLOOKUP(H16,INDIRECT(\"Allowable\"&V16),2,FALSE)),\"TBC\")","v":"TBC"},{"$f":"CONCATENATE(IF(OR(RIGHT(W16,1)=\"B\",RIGHT(W16,1)=\"C\"),\"F\",IF(RIGHT(W16,1)=\"A\",\"S\",\"Z\")),AF16)","v":"ZTBC"},{"$f":"IFERROR(IF(RIGHT(W16,1)=\"B\",IF(OR(ISNUMBER(SEARCH(\"HEPA\",H16)),ISNUMBER(SEARCH(\"MERV\",H16))),P16*0.5*AB16*IF(ISNUMBER(SEARCH(\"HEPA\",H16)),1.5,2.5)^2,\"N/A\"),IF(RIGHT(W16,1)=\"C\",IF(OR(ISNUMBER(SEARCH(\"HEPA\",H16)),ISNUMBER(SEARCH(\"MERV\",H16))),IF(ISNUMBER(SEARCH(\"HEPA\",H16)),1.5,2.5)^2*T16/AD16^2,\"N/A\"),\"N/A\")),\"N/A\")","v":"N/A"},"ZZ"]
[null,null,"#",null,"-Select-","-Select-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Z","ZZ",false,null,null,null,null,null,null,null,"TBC",0,0,{"$f":"IF(RIGHT(W17,1)=\"A\",AE17,IF(OR(RIGHT(W17,1)=\"B\",RIGHT(W17,1)=\"C\"),IF(OR(P17=\"\",P17=0,AD17=\"\"),\"TBC\",IFERROR(P17*0.5*AB17*AD17^2,\"TBC\")),\"TBC\"))","v":"TBC"},"TBC","ZTBC","N/A","ZZ"]
[null,null,1,null,"-Select-","-Select-",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(RIGHT(W18,1)=\"A\",AE18,IF(OR(RIGHT(W18,1)=\"B\",RIGHT(W18,1)=\"C\"),T18,\"\"))","v":""},null,{"$f":"IF(RIGHT(W18,1)=\"A\",N18*1,IF(OR(RIGHT(W18,1)=\"B\",RIGHT(W18,1)=\"C\"),U18,\"\"))","v":""},{"$f":"IF(AND(OR(RIGHT(W18,1)=\"C\",RIGHT(W18,1)=\"B\"),COUNTBLANK(Q18)=0),Q18,IF(RIGHT(W18,1)=\"A\",\"\",\"TBC\"))","v":"TBC"},{"$f":"IF(RIGHT(W18,1)=\"A\",\"\",IFERROR(IF(AND(AL18>0,ISNUMBER(AL18)),MAX(VLOOKUP(H18,INDIRECT(\"Allowable\"&V18),2,FALSE),AL18),VLOOKUP(H18,INDIRECT(\"Allowable\"&V18),2,FALSE)),\"TBC\"))","v":"TBC"},{"$f":"IFERROR(VLOOKUP(G18,'Lists for Drop Down Selectors'!$A$41:$B$57,2,FALSE),\"Z\")","v":"Z"},{"$f":"CONCATENATE(IFERROR(VLOOKUP(E18,'Lists for Drop Down Selectors'!$A$11:$B$15,2,FALSE),\"Z\"),IFERROR(VLOOKUP(F18,'Lists for Drop Down Selectors'!$A$4:$B$8,2,FALSE),\"Z\"))","v":"ZZ"},{"$f":"AND(RIGHT(W18,1)=\"A\",COUNTBLANK(Y18)=0,COUNTBLANK(O18)=0,COUNTBLANK(I18:J18)=0)","v":false},{"$f":"IF(LEFT(W18,1)=\"A\",IF(COUNTBLANK(K18:L18)=0,IFERROR(((32*(L18/1000)^3*(K18/1000)^3)/((PI()^2)*((L18/1000)+(K18/1000))))^(1/5),\"\"),\"\"),IF(AND(OR(LEFT(W18,1)=\"B\",LEFT(W18,1)=\"C\"),COUNTBLANK(M18)=0),IFERROR(M18/1000,\"\"),\"\"))","v":""},{"$f":"IF(LEFT(W18,1)=\"A\",IF(COUNTBLANK(K18:L18)=0,IFERROR((4*(K18/1000)*(L18/1000)/PI())^0.5,\"\"),\"\"),IF(AND(OR(LEFT(W18,1)=\"B\",LEFT(W18,1)=\"C\"),COUNTBLANK(M18)=0),IFERROR(M18/1000,\"\"),\"\"))","v":""},{"$f":"IFERROR(-1000*PI()*(R18*Y18^5/(2*AB18))^0.5*LOG(((O18/1000)/(3.7*Y18))+(1.255*(AC18)/AB18)/(R18*Y18^3/(2*AB18))^0.5),\"\")","v":""},{"$f":"IF(ISBLANK(I18),\"\",IFERROR(1000*101.325/(287.058*(273.15+I18)),\"\"))","v":""},{"$f":"IF(ISBLANK(I18),\"\",IFERROR(0.00001716*(((I18+273.15)/273.15)^(3/2))*((273.15+110.4)/(273.15+I18+110.4)),\"\"))","v":""},{"$f":"IF(AND(J18>0,Z18>0,COUNTBLANK(J18)=0,COUNTBLANK(Z18)=0),IFERROR(J18/(PI()*(Z18/2)^2)/1000,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(W18,1)=\"A\",IF(OR(N18=\"\",R18=\"\",R18=\"TBC\"),\"TBC\",IFERROR(N18*R18,\"TBC\")),\"\")","v":""},{"$f":"IF(RIGHT(W18,1)=\"A\",IF(OR(R18=\"TBC\",ISBLANK(R18)),\"TBC\",IF(R18<1,\"YES\",\"NO\")),IF(OR(COUNTBLANK(T18:U18)>0,U18=\"TBC\",T18=\"TBC\"),\"TBC\",IF(OR(RIGHT(W18,1)=\"B\",RIGHT(W18,1)=\"C\"),IF(OR(T18<=U18,U18=\"N/A\"),\"YES\",\"NO\"),\"TBC\")))","v":"TBC"},{"$f":"IF(LEFT(W18,1)=\"C\",N18,0)","v":0},{"$f":"IFERROR(AB18*(J18/1000)*Y18/((PI()*(Y18/2)^2)*(AC18)),0)","v":0},{"$f":"IF(RIGHT(W18,1)=\"A\",AE18,IF(OR(RIGHT(W18,1)=\"B\",RIGHT(W18,1)=\"C\"),IF(OR(P18=\"\",P18=0,AD18=\"\"),\"TBC\",IFERROR(P18*0.5*AB18*AD18^2,\"TBC\")),\"TBC\"))","v":"TBC"},{"$f":"IFERROR(IF(AND(AL18>0,ISNUMBER(AL18)),MAX(VLOOKUP(H18,INDIRECT(\"Allowable\"&V18),2,FALSE),AL18),VLOOKUP(H18,INDIRECT(\"Allowable\"&V18),2,FALSE)),\"TBC\")","v":"TBC"},{"$f":"CONCATENATE(IF(OR(RIGHT(W18,1)=\"B\",RIGHT(W18,1)=\"C\"),\"F\",IF(RIGHT(W18,1)=\"A\",\"S\",\"Z\")),AF18)","v":"ZTBC"},{"$f":"IFERROR(IF(RIGHT(W18,1)=\"B\",IF(OR(ISNUMBER(SEARCH(\"HEPA\",H18)),ISNUMBER(SEARCH(\"MERV\",H18))),P18*0.5*AB18*IF(ISNUMBER(SEARCH(\"HEPA\",H18)),1.5,2.5)^2,\"N/A\"),IF(RIGHT(W18,1)=\"C\",IF(OR(ISNUMBER(SEARCH(\"HEPA\",H18)),ISNUMBER(SEARCH(\"MERV\",H18))),IF(ISNUMBER(SEARCH(\"HEPA\",H18)),1.5,2.5)^2*T18/AD18^2,\"N/A\"),\"N/A\")),\"N/A\")","v":"N/A"},"ZZ"]
[null,"Average",null,null,null,null,null,{"$f":"COUNTIF(H18:H18,'Lists for Drop Down Selectors'!$A$133)","v":0},null,null,null,null,null,{"$f":"SUM(N18:N18)","v":0},null,null,null,null,null,{"$f":"IF(COUNTIF(T18:T18,\"TBC\")>0,\"TBC\",SUM(T18:T18))","v":"TBC"},{"$f":"IF(COUNTIF(U18:U18,\"TBC\")>0,\"TBC\",SUMIF(U18:U18,\"<>N/A\")+SUMIF(R18:R18,\"N/A\",Q18:Q18))","v":"TBC"},null,{"$f":"COUNTIF(W18:W18,\"*Z*\")","v":1},null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(AE18:AE18,\"TBC\")>0,\"TBC\",SUM(AE18:AE18))","v":0},null,{"$f":"SUM(AG18:AG18)","v":0},null,null,{"$f":"IF(COUNTIF(AK18,\"FNO\")>0,\"Part J5.4 Not Satisfied\",IF(COUNTIF(AK18,\"FTBC\")>0,\"Insufficient Information\",\"Satisfies Part J5.4\"))","v":"Satisfies Part J5.4"},{"$f":"IF(COUNTIF(AK18:AK18,\"FNO\")>0,\"Part J5.4 Not Satisfied\",IF(COUNTIF(AK18:AK18,\"FTBC\")>0,\"Insufficient Information\",\"Satisfies Part J5.4\"))","v":"Satisfies Part J5.4"}]
[null,"Total",null,null,null,null,null,{"$f":"COUNTIF(G18:G18,\"Other\")+COUNTIF(G18:G18,\"Bend\")","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(AF18:AF18,\"TBC\")>0,\"TBC\",\"YES\")","v":"TBC"},{"$f":"IF(COUNTIF(#REF!,\"NO\")>0,\"YES\",\"NO\")","v":{"$error":"#REF!"}},{"$f":"IF(COUNTIF(AF18:AF18,\"NO\")>0,\"YES\",\"NO\")","v":"NO"}]
[]
[null,"Total Results"]
[null,"Section",null,"Calculated Pressure Drop Pa","Allowable Pressure Drop Pa"]
[null,"Straight Duct",null,{"$f":"IF(W19>0,\"TBC\",AE19)","v":"TBC"},{"$f":"IF(W19>0,\"TBC\",N19*1)","v":"TBC"}]
[null,"Fittings",null,{"$f":"IF(W19>0,\"TBC\",T19)","v":"TBC"},{"$f":"IF(W19>0,\"TBC\",U19)","v":"TBC"}]
[null,"Total",null,{"$f":"IFERROR(IF(OR(D24=\"TBC\",D25=\"TBC\",V19>0),\"TBC\",D24+D25),\"TBC\")","v":"TBC"},{"$f":"IFERROR(IF(OR(E24=\"TBC\",E25=\"TBC\",V19>0),\"TBC\",E24+E25),\"TBC\")","v":"TBC"}]
[]
[null,"Index Run Component Results"]
[null,"Straight Duct",null,"Fittings",null,"Turning Vanes",null,"Flexible Duct",null,"Overall"]
[null,{"$f":"IF(OR(D24=\"TBC\",E24=\"TBC\"),\"Insufficient Information\",IF(E24>=D24,\"Satisfies Part J5.4\",\"Part J5.4 Not Satisfied\"))","v":"Insufficient Information"},null,{"$f":"IF(OR(AK19=\"TBC\",W19>0),\"Insufficient Information\",AK19)","v":"Insufficient Information"},null,{"$f":"IF(IF(OR(Summary!F12=\"B\",Summary!F12=\"Z\"),H19,0)>0,\"Part J5.4 Not Satisfied\",\"Satisfies Part J5.4\")","v":"Satisfies Part J5.4"},null,{"$f":"IFERROR(IF(W19>0,\"Insufficient Information\",IF(AG19<=6,\"Satisfies Part J5.4\",\"Part J5.4 Not Satisfied\")),\"Insufficient Information\")","v":"Insufficient Information"},null,{"$f":"IF(COUNTIF(B30:I30,\"Part J5.4 Not Satisfied\")>0,\"Part J5.4 Not Satisfied\",IF(COUNTIF(B30:I30,\"Insufficient Information\")>0,\"Insufficient Information\",\"Satisfies Part J5.4\"))","v":"Insufficient Information"}]
[]
[null,"IMPORTANT NOTICE AND DISCLAIMER IN RESPECT OF THIS FAN SYSTEM CALCULATOR"]

{"sheet":"Duct Details (170)","index":5,"n_rows":32,"n_cols":40,"rows_kept":32,"cut":false,"hidden":true,"merged":[[29,1,29,2],[29,3,29,4],[29,5,29,6],[29,7,29,8],[29,9,29,11],[23,1,23,2],[24,1,24,2],[25,1,25,2],[27,1,27,11],[28,1,28,2],[28,3,28,4],[28,5,28,6],[28,7,28,8],[28,9,28,11],[22,1,22,2],[3,1,3,15],[4,1,4,6],[4,7,4,9],[4,10,4,15],[5,1,5,6],[5,7,5,9],[5,10,5,15],[7,1,7,7],[8,1,8,4],[9,1,9,4],[11,1,11,38],[21,1,21,4]]}
[]
[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,"Calculator"]
[]
[null,"System General Information"]
[null,{"$f":"Summary!B5","v":"Building Name and Description"},null,null,null,null,null,{"$f":"Summary!E5","v":"Fan Tag"},null,null,{"$f":"Summary!F5","v":"System Description"}]
[null,{"$f":"IF(Summary!B6=\"\",\"\",Summary!B6)","v":""},null,null,null,null,null,{"$f":"IF(Summary!E6=\"\",\"\",Summary!E6)","v":""},null,null,{"$f":"IF(Summary!F6=\"\",\"\",Summary!F6)","v":""}]
[]
[null,"System Characteristics"]
[null,{"$f":"Summary!B9","v":"Fan Type"},null,null,null,{"$f":"Summary!D9","v":"Fan Inlet"},{"$f":"Summary!E9","v":"Fan Outlet"},{"$f":"Summary!F9","v":"Fouling Risk"}]
[null,{"$f":"IF(Summary!B10=\"\",\"\",Summary!B10)","v":"-Select-"},null,null,null,{"$f":"IF(Summary!D10=\"\",\"\",Summary!D10)","v":"-Select-"},{"$f":"IF(Summary!E10=\"\",\"\",Summary!E10)","v":"-Select-"},{"$f":"IF(Summary!F10=\"\",\"\",Summary!F10)","v":"-Select-"}]
[]
[null,"Index Run Details"]
[null,"ID","Description","Duct Shape","Component Type","Fitting Type","Specific Fitting","Temperature","Flow Rate","Width","Height","Diameter","Length","Roughness","Fitting Loss Coefficient Kt","Pressure Drop","Straight Pressure Drop","Allowable Pressure Drop","Fitting Pressure Drop","Allowable Fitting PD","Fitting Type Code",null,null,"Equivalent Diameter (PD)","Equivalent Diameter (Velocity)","Flow Rate For Iterative Solving","Fluid Density","Absolute Viscosity","Velocity","Total Straight PD","Compliant","Length of Flex"]
[null,null,null,null,null,null,null,"°C","L/s","mm","mm","mm","m","mm",null,"Pa","Pa/m","Pa","Pa","Pa",null,null,null,"m","m","L/s","kg/m³","kg/ms","m/s","Pa"]
[null,"Controls",{"$f":"IF(ISBLANK(B14),B13,B13 & CHAR(10) & B14)","v":"ID"},"Description","Duct Shape","Component Type","Fitting Type","Specific Fitting","Temperature\n°C","Flow Rate\nL/s","Width\nmm","Height\nmm","Diameter\nmm","Length\nm","Roughness\nmm","Fitting Loss Coefficient Kt",{"$f":"IF(ISBLANK(P14),P13,P13 & CHAR(10) & P14)","v":"Pressure Drop\nPa"},{"$f":"IF(ISBLANK(Q14),Q13,Q13 & CHAR(10) & Q14)","v":"Straight Pressure Drop\nPa/m"},{"$f":"IF(ISBLANK(R14),R13,R13 & CHAR(10) & R14)","v":"Allowable Pressure Drop\nPa"},"Fitting Pressure Drop\nPa","Allowable Fitting PD\nPa",{"$f":"IF(ISBLANK(U14),U13,U13 & CHAR(10) & U14)","v":"Fitting Type Code"},"Internal Reference","Ready for DP Calc","Equivalent Diameter (PD)\nm","Equivalent Diameter (Velocity)\nm","Flow Rate For Iterative Solving\nL/s","Fluid Density\nkg/m³","Absolute Viscosity\nkg/ms","Velocity\nm/s",{"$f":"IF(ISBLANK(AD14),AD13,AD13 & CHAR(10) & AD14)","v":"Total Straight PD\nPa"},"Satisfactory",{"$f":"IF(ISBLANK(AF14),AF13,AF13 & CHAR(10) & AF14)","v":"Length of Flex"},"Reynolds Number","Pressure Drop Formula To Copy","Compliant fitting PD to copy","Type+Compliance","Filter alternate maximum","Lastref"]
[null,null,0,null,"-Select-","-Select-",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(RIGHT(W16,1)=\"A\",AE16,IF(OR(RIGHT(W16,1)=\"B\",RIGHT(W16,1)=\"C\"),T16,\"\"))","v":""},null,{"$f":"IF(RIGHT(W16,1)=\"A\",N16*1,IF(OR(RIGHT(W16,1)=\"B\",RIGHT(W16,1)=\"C\"),U16,\"\"))","v":""},{"$f":"IF(AND(OR(RIGHT(W16,1)=\"C\",RIGHT(W16,1)=\"B\"),COUNTBLANK(Q16)=0),Q16,IF(RIGHT(W16,1)=\"A\",\"\",\"TBC\"))","v":"TBC"},{"$f":"IF(RIGHT(W16,1)=\"A\",\"\",IFERROR(IF(AND(AL16>0,ISNUMBER(AL16)),MAX(VLOOKUP(H16,INDIRECT(\"Allowable\"&V16),2,FALSE),AL16),VLOOKUP(H16,INDIRECT(\"Allowable\"&V16),2,FALSE)),\"TBC\"))","v":"TBC"},{"$f":"IFERROR(VLOOKUP(G16,'Lists for Drop Down Selectors'!$A$41:$B$57,2,FALSE),\"Z\")","v":"Z"},{"$f":"CONCATENATE(IFERROR(VLOOKUP(E16,'Lists for Drop Down Selectors'!$A$11:$B$15,2,FALSE),\"Z\"),IFERROR(VLOOKUP(F16,'Lists for Drop Down Selectors'!$A$4:$B$8,2,FALSE),\"Z\"))","v":"ZZ"},{"$f":"AND(RIGHT(W16,1)=\"A\",COUNTBLANK(Y16)=0,COUNTBLANK(O16)=0,COUNTBLANK(I16:J16)=0)","v":false},{"$f":"IF(LEFT(W16,1)=\"A\",IF(COUNTBLANK(K16:L16)=0,IFERROR(((32*(L16/1000)^3*(K16/1000)^3)/((PI()^2)*((L16/1000)+(K16/1000))))^(1/5),\"\"),\"\"),IF(AND(OR(LEFT(W16,1)=\"B\",LEFT(W16,1)=\"C\"),COUNTBLANK(M16)=0),IFERROR(M16/1000,\"\"),\"\"))","v":""},{"$f":"IF(LEFT(W16,1)=\"A\",IF(COUNTBLANK(K16:L16)=0,IFERROR((4*(K16/1000)*(L16/1000)/PI())^0.5,\"\"),\"\"),IF(AND(OR(LEFT(W16,1)=\"B\",LEFT(W16,1)=\"C\"),COUNTBLANK(M16)=0),IFERROR(M16/1000,\"\"),\"\"))","v":""},{"$f":"IFERROR(-1000*PI()*(R16*Y16^5/(2*AB16))^0.5*LOG(((O16/1000)/(3.7*Y16))+(1.255*(AC16)/AB16)/(R16*Y16^3/(2*AB16))^0.5),\"\")","v":""},{"$f":"IF(ISBLANK(I16),\"\",IFERROR(1000*101.325/(287.058*(273.15+I16)),\"\"))","v":""},{"$f":"IF(ISBLANK(I16),\"\",IFERROR(0.00001716*(((I16+273.15)/273.15)^(3/2))*((273.15+110.4)/(273.15+I16+110.4)),\"\"))","v":""},{"$f":"IF(AND(J16>0,Z16>0,COUNTBLANK(J16)=0,COUNTBLANK(Z16)=0),IFERROR(J16/(PI()*(Z16/2)^2)/1000,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(W16,1)=\"A\",IF(OR(N16=\"\",R16=\"\",R16=\"TBC\"),\"TBC\",IFERROR(N16*R16,\"TBC\")),\"\")","v":""},{"$f":"IF(RIGHT(W16,1)=\"A\",IF(OR(R16=\"TBC\",ISBLANK(R16)),\"TBC\",IF(R16<1,\"YES\",\"NO\")),IF(OR(COUNTBLANK(T16:U16)>0,U16=\"TBC\",T16=\"TBC\"),\"TBC\",IF(OR(RIGHT(W16,1)=\"B\",RIGHT(W16,1)=\"C\"),IF(OR(T16<=U16,U16=\"N/A\"),\"YES\",\"NO\"),\"TBC\")))","v":"TBC"},{"$f":"IF(LEFT(W16,1)=\"C\",N16,0)","v":0},{"$f":"IFERROR(AB16*(J16/1000)*Y16/((PI()*(Y16/2)^2)*(AC16)),0)","v":0},{"$f":"IF(RIGHT(W16,1)=\"A\",AE16,IF(OR(RIGHT(W16,1)=\"B\",RIGHT(W16,1)=\"C\"),IF(OR(P16=\"\",P16=0,AD16=\"\"),\"TBC\",IFERROR(P16*0.5*AB16*AD16^2,\"TBC\")),\"TBC\"))","v":"TBC"},{"$f":"IFERROR(IF(AND(AL16>0,ISNUMBER(AL16)),MAX(VLOOKUP(H16,INDIRECT(\"Allowable\"&V16),2,FALSE),AL16),VLOOKUP(H16,INDIRECT(\"Allowable\"&V16),2,FALSE)),\"TBC\")","v":"TBC"},{"$f":"CONCATENATE(IF(OR(RIGHT(W16,1)=\"B\",RIGHT(W16,1)=\"C\"),\"F\",IF(RIGHT(W16,1)=\"A\",\"S\",\"Z\")),AF16)","v":"ZTBC"},{"$f":"IFERROR(IF(RIGHT(W16,1)=\"B\",IF(OR(ISNUMBER(SEARCH(\"HEPA\",H16)),ISNUMBER(SEARCH(\"MERV\",H16))),P16*0.5*AB16*IF(ISNUMBER(SEARCH(\"HEPA\",H16)),1.5,2.5)^2,\"N/A\"),IF(RIGHT(W16,1)=\"C\",IF(OR(ISNUMBER(SEARCH(\"HEPA\",H16)),ISNUMBER(SEARCH(\"MERV\",H16))),IF(ISNUMBER(SEARCH(\"HEPA\",H16)),1.5,2.5)^2*T16/AD16^2,\"N/A\"),\"N/A\")),\"N/A\")","v":"N/A"},"ZZ"]
[null,null,"#",null,"-Select-","-Select-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Z","ZZ",false,null,null,null,null,null,null,null,"TBC",0,0,{"$f":"IF(RIGHT(W17,1)=\"A\",AE17,IF(OR(RIGHT(W17,1)=\"B\",RIGHT(W17,1)=\"C\"),IF(OR(P17=\"\",P17=0,AD17=\"\"),\"TBC\",IFERROR(P17*0.5*AB17*AD17^2,\"TBC\")),\"TBC\"))","v":"TBC"},"TBC","ZTBC","N/A","ZZ"]
[null,null,1,null,"-Select-","-Select-",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(RIGHT(W18,1)=\"A\",AE18,IF(OR(RIGHT(W18,1)=\"B\",RIGHT(W18,1)=\"C\"),T18,\"\"))","v":""},null,{"$f":"IF(RIGHT(W18,1)=\"A\",N18*1,IF(OR(RIGHT(W18,1)=\"B\",RIGHT(W18,1)=\"C\"),U18,\"\"))","v":""},{"$f":"IF(AND(OR(RIGHT(W18,1)=\"C\",RIGHT(W18,1)=\"B\"),COUNTBLANK(Q18)=0),Q18,IF(RIGHT(W18,1)=\"A\",\"\",\"TBC\"))","v":"TBC"},{"$f":"IF(RIGHT(W18,1)=\"A\",\"\",IFERROR(IF(AND(AL18>0,ISNUMBER(AL18)),MAX(VLOOKUP(H18,INDIRECT(\"Allowable\"&V18),2,FALSE),AL18),VLOOKUP(H18,INDIRECT(\"Allowable\"&V18),2,FALSE)),\"TBC\"))","v":"TBC"},{"$f":"IFERROR(VLOOKUP(G18,'Lists for Drop Down Selectors'!$A$41:$B$57,2,FALSE),\"Z\")","v":"Z"},{"$f":"CONCATENATE(IFERROR(VLOOKUP(E18,'Lists for Drop Down Selectors'!$A$11:$B$15,2,FALSE),\"Z\"),IFERROR(VLOOKUP(F18,'Lists for Drop Down Selectors'!$A$4:$B$8,2,FALSE),\"Z\"))","v":"ZZ"},{"$f":"AND(RIGHT(W18,1)=\"A\",COUNTBLANK(Y18)=0,COUNTBLANK(O18)=0,COUNTBLANK(I18:J18)=0)","v":false},{"$f":"IF(LEFT(W18,1)=\"A\",IF(COUNTBLANK(K18:L18)=0,IFERROR(((32*(L18/1000)^3*(K18/1000)^3)/((PI()^2)*((L18/1000)+(K18/1000))))^(1/5),\"\"),\"\"),IF(AND(OR(LEFT(W18,1)=\"B\",LEFT(W18,1)=\"C\"),COUNTBLANK(M18)=0),IFERROR(M18/1000,\"\"),\"\"))","v":""},{"$f":"IF(LEFT(W18,1)=\"A\",IF(COUNTBLANK(K18:L18)=0,IFERROR((4*(K18/1000)*(L18/1000)/PI())^0.5,\"\"),\"\"),IF(AND(OR(LEFT(W18,1)=\"B\",LEFT(W18,1)=\"C\"),COUNTBLANK(M18)=0),IFERROR(M18/1000,\"\"),\"\"))","v":""},{"$f":"IFERROR(-1000*PI()*(R18*Y18^5/(2*AB18))^0.5*LOG(((O18/1000)/(3.7*Y18))+(1.255*(AC18)/AB18)/(R18*Y18^3/(2*AB18))^0.5),\"\")","v":""},{"$f":"IF(ISBLANK(I18),\"\",IFERROR(1000*101.325/(287.058*(273.15+I18)),\"\"))","v":""},{"$f":"IF(ISBLANK(I18),\"\",IFERROR(0.00001716*(((I18+273.15)/273.15)^(3/2))*((273.15+110.4)/(273.15+I18+110.4)),\"\"))","v":""},{"$f":"IF(AND(J18>0,Z18>0,COUNTBLANK(J18)=0,COUNTBLANK(Z18)=0),IFERROR(J18/(PI()*(Z18/2)^2)/1000,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(W18,1)=\"A\",IF(OR(N18=\"\",R18=\"\",R18=\"TBC\"),\"TBC\",IFERROR(N18*R18,\"TBC\")),\"\")","v":""},{"$f":"IF(RIGHT(W18,1)=\"A\",IF(OR(R18=\"TBC\",ISBLANK(R18)),\"TBC\",IF(R18<1,\"YES\",\"NO\")),IF(OR(COUNTBLANK(T18:U18)>0,U18=\"TBC\",T18=\"TBC\"),\"TBC\",IF(OR(RIGHT(W18,1)=\"B\",RIGHT(W18,1)=\"C\"),IF(OR(T18<=U18,U18=\"N/A\"),\"YES\",\"NO\"),\"TBC\")))","v":"TBC"},{"$f":"IF(LEFT(W18,1)=\"C\",N18,0)","v":0},{"$f":"IFERROR(AB18*(J18/1000)*Y18/((PI()*(Y18/2)^2)*(AC18)),0)","v":0},{"$f":"IF(RIGHT(W18,1)=\"A\",AE18,IF(OR(RIGHT(W18,1)=\"B\",RIGHT(W18,1)=\"C\"),IF(OR(P18=\"\",P18=0,AD18=\"\"),\"TBC\",IFERROR(P18*0.5*AB18*AD18^2,\"TBC\")),\"TBC\"))","v":"TBC"},{"$f":"IFERROR(IF(AND(AL18>0,ISNUMBER(AL18)),MAX(VLOOKUP(H18,INDIRECT(\"Allowable\"&V18),2,FALSE),AL18),VLOOKUP(H18,INDIRECT(\"Allowable\"&V18),2,FALSE)),\"TBC\")","v":"TBC"},{"$f":"CONCATENATE(IF(OR(RIGHT(W18,1)=\"B\",RIGHT(W18,1)=\"C\"),\"F\",IF(RIGHT(W18,1)=\"A\",\"S\",\"Z\")),AF18)","v":"ZTBC"},{"$f":"IFERROR(IF(RIGHT(W18,1)=\"B\",IF(OR(ISNUMBER(SEARCH(\"HEPA\",H18)),ISNUMBER(SEARCH(\"MERV\",H18))),P18*0.5*AB18*IF(ISNUMBER(SEARCH(\"HEPA\",H18)),1.5,2.5)^2,\"N/A\"),IF(RIGHT(W18,1)=\"C\",IF(OR(ISNUMBER(SEARCH(\"HEPA\",H18)),ISNUMBER(SEARCH(\"MERV\",H18))),IF(ISNUMBER(SEARCH(\"HEPA\",H18)),1.5,2.5)^2*T18/AD18^2,\"N/A\"),\"N/A\")),\"N/A\")","v":"N/A"},"ZZ"]
[null,"Average",null,null,null,null,null,{"$f":"COUNTIF(H18:H18,'Lists for Drop Down Selectors'!$A$133)","v":0},null,null,null,null,null,{"$f":"SUM(N18:N18)","v":0},null,null,null,null,null,{"$f":"IF(COUNTIF(T18:T18,\"TBC\")>0,\"TBC\",SUM(T18:T18))","v":"TBC"},{"$f":"IF(COUNTIF(U18:U18,\"TBC\")>0,\"TBC\",SUMIF(U18:U18,\"<>N/A\")+SUMIF(R18:R18,\"N/A\",Q18:Q18))","v":"TBC"},null,{"$f":"COUNTIF(W18:W18,\"*Z*\")","v":1},null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(AE18:AE18,\"TBC\")>0,\"TBC\",SUM(AE18:AE18))","v":0},null,{"$f":"SUM(AG18:AG18)","v":0},null,null,{"$f":"IF(COUNTIF(AK18,\"FNO\")>0,\"Part J5.4 Not Satisfied\",IF(COUNTIF(AK18,\"FTBC\")>0,\"Insufficient Information\",\"Satisfies Part J5.4\"))","v":"Satisfies Part J5.4"},{"$f":"IF(COUNTIF(AK18:AK18,\"FNO\")>0,\"Part J5.4 Not Satisfied\",IF(COUNTIF(AK18:AK18,\"FTBC\")>0,\"Insufficient Information\",\"Satisfies Part J5.4\"))","v":"Satisfies Part J5.4"}]
[null,"Total",null,null,null,null,null,{"$f":"COUNTIF(G18:G18,\"Other\")+COUNTIF(G18:G18,\"Bend\")","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(AF18:AF18,\"TBC\")>0,\"TBC\",\"YES\")","v":"TBC"},{"$f":"IF(COUNTIF(#REF!,\"NO\")>0,\"YES\",\"NO\")","v":{"$error":"#REF!"}},{"$f":"IF(COUNTIF(AF18:AF18,\"NO\")>0,\"YES\",\"NO\")","v":"NO"}]
[]
[null,"Total Results"]
[null,"Section",null,"Calculated Pressure Drop Pa","Allowable Pressure Drop Pa"]
[null,"Straight Duct",null,{"$f":"IF(W19>0,\"TBC\",AE19)","v":"TBC"},{"$f":"IF(W19>0,\"TBC\",N19*1)","v":"TBC"}]
[null,"Fittings",null,{"$f":"IF(W19>0,\"TBC\",T19)","v":"TBC"},{"$f":"IF(W19>0,\"TBC\",U19)","v":"TBC"}]
[null,"Total",null,{"$f":"IFERROR(IF(OR(D24=\"TBC\",D25=\"TBC\",V19>0),\"TBC\",D24+D25),\"TBC\")","v":"TBC"},{"$f":"IFERROR(IF(OR(E24=\"TBC\",E25=\"TBC\",V19>0),\"TBC\",E24+E25),\"TBC\")","v":"TBC"}]
[]
[null,"Index Run Component Results"]
[null,"Straight Duct",null,"Fittings",null,"Turning Vanes",null,"Flexible Duct",null,"Overall"]
[null,{"$f":"IF(OR(D24=\"TBC\",E24=\"TBC\"),\"Insufficient Information\",IF(E24>=D24,\"Satisfies Part J5.4\",\"Part J5.4 Not Satisfied\"))","v":"Insufficient Information"},null,{"$f":"IF(OR(AK19=\"TBC\",W19>0),\"Insufficient Information\",AK19)","v":"Insufficient Information"},null,{"$f":"IF(IF(OR(Summary!F12=\"B\",Summary!F12=\"Z\"),H19,0)>0,\"Part J5.4 Not Satisfied\",\"Satisfies Part J5.4\")","v":"Satisfies Part J5.4"},null,{"$f":"IFERROR(IF(W19>0,\"Insufficient Information\",IF(AG19<=6,\"Satisfies Part J5.4\",\"Part J5.4 Not Satisfied\")),\"Insufficient Information\")","v":"Insufficient Information"},null,{"$f":"IF(COUNTIF(B30:I30,\"Part J5.4 Not Satisfied\")>0,\"Part J5.4 Not Satisfied\",IF(COUNTIF(B30:I30,\"Insufficient Information\")>0,\"Insufficient Information\",\"Satisfies Part J5.4\"))","v":"Insufficient Information"}]
[]
[null,"IMPORTANT NOTICE AND DISCLAIMER IN RESPECT OF THIS FAN SYSTEM CALCULATOR"]

{"sheet":"Fan Details","index":6,"n_rows":37,"n_cols":7,"rows_kept":37,"cut":false,"hidden":true,"merged":[[36,1,36,4],[30,1,30,2],[16,3,17,5],[15,1,15,5],[20,3,22,5],[19,1,19,5],[4,4,4,5],[5,4,5,5],[3,1,3,5],[12,2,12,3],[13,2,13,3],[11,1,11,3],[9,1,9,2],[8,1,8,2],[4,1,4,2],[5,1,5,2],[7,1,7,5]]}
[]
[null,null,null,null,null,null,"Calculator"]
[]
[null,"System General Information"]
[null,{"$f":"Summary!B5","v":"Building Name and Description"},null,{"$f":"Summary!E5","v":"Fan Tag"},{"$f":"Summary!F5","v":"System Description"}]
[null,{"$f":"IF(Summary!B6=\"\",\"\",Summary!B6)","v":""},null,{"$f":"IF(Summary!E6=\"\",\"\",Summary!E6)","v":""},{"$f":"IF(Summary!F6=\"\",\"\",Summary!F6)","v":""}]
[]
[null,{"$f":"Summary!B8","v":"System Characteristics"}]
[null,{"$f":"Summary!B9","v":"Fan Type"},null,{"$f":"Summary!D9","v":"Fan Inlet"},{"$f":"Summary!E9","v":"Fan Outlet"},{"$f":"Summary!F9","v":"Fouling Risk"}]
[null,{"$f":"IF(Summary!B10=\"\",\"\",Summary!B10)","v":"-Select-"},null,{"$f":"IF(Summary!D10=\"\",\"\",Summary!D10)","v":"-Select-"},{"$f":"IF(Summary!E10=\"\",\"\",Summary!E10)","v":"-Select-"},{"$f":"IF(Summary!F10=\"\",\"\",Summary!F10)","v":"-Select-"}]
[]
[null,"Fan Characteristics"]
[null,{"$f":"Summary!B15","v":"Flow Rate L/s"},{"$f":"Summary!C15","v":"Role"}]
[null,{"$f":"Summary!B16","v":0},{"$f":"Summary!C16","v":"-Select-"}]
[]
[null,"External Static Pressure"]
[null,"Calculated Static Pressure Pa","Design Static Pressure Pa","Note: The design static pressure will likely exceed that calculated through allowances for dirty filters, inlet/outlet losses, safety factors etc. Ensure that these items are accounted for in your design static pressure calculations."]
[null,{"$f":"INDIRECT('All Systems'!F9 & \"!Total_Calculated_PD\")","v":"TBC"}]
[]
[null,"Fan Details"]
[null,"Motor Input Power",{"$f":"IF(OR(Summary!C19=\"A\",Summary!C19=\"C\"),\"System Static Efficiency\",\"System Total Efficiency\")","v":"System Total Efficiency"},"Note: The fan's efficiency should be presented at the full load operating point."]
[null,"kW","%"]
[]
[]
[null,"(Hidden calculations)"]
[null,"Coefficient a","Coefficient b","Min Performance Grade N"]
[null,{"$f":"IFERROR(VLOOKUP(B10,'Lists for Drop Down Selectors'!A24:J31,IF('Fan Details'!B23<10,7,8),FALSE),\"N/A\")","v":"N/A"},{"$f":"IFERROR(VLOOKUP(B10,'Lists for Drop Down Selectors'!A24:J31,IF('Fan Details'!B23<10,9,10),FALSE),\"N/A\")","v":"N/A"},{"$f":"IFERROR(VLOOKUP(B10,'Lists for Drop Down Selectors'!A24:F31,HLOOKUP(Summary!C19,'Lists for Drop Down Selectors'!B22:F23,2,FALSE),FALSE),\"N/A\")","v":"N/A"}]
[]
[null,"Minimum Efficiency (static<200)","Minimum efficiency (General)","Explosion Proof?"]
[null,{"$f":"IF(COUNTBLANK(C18)+COUNTBLANK(B10)+COUNTBLANK(D10:E10)+COUNTIF(B10:E10,\"-Select-\")+COUNTIF(B27:D27,\"N/A\")>0,\"TBC\",IFERROR(MAX((13*LN(C18)-30)/100,0),\"TBC\"))","v":"TBC"},{"$f":"IF(COUNTBLANK(B27:D27)+COUNTBLANK(B23)+COUNTBLANK(B10)+COUNTBLANK(D10:E10)+COUNTIF(B10:E10,\"-Select-\")+COUNTIF(B27:D27,\"N/A\")>0,\"TBC\",IFERROR(0.85*(B27*LN(B23)-C27+D27)/100,\"TBC\"))","v":"TBC"},{"$f":"IF(Summary!C16='Lists for Drop Down Selectors'!E16,TRUE,FALSE)","v":false}]
[null,"Component Level Compliance"]
[null,"Required Efficiency %","Efficiency Result"]
[null,{"$f":"IFERROR(IF(D30,0,IF(C18<=200,B30,C30)),\"TBC\")","v":"TBC"},{"$f":"IF(OR(B33=\"TBC\",COUNTBLANK(C23)>0),\"Insufficient Information\",IF(B33<=C23,\"Satisfies Part J5.4\",\"Part J5.4 Not Satisfied\"))","v":"Insufficient Information"}]
[]
[]
[]
[null,"IMPORTANT NOTICE AND DISCLAIMER IN RESPECT OF THIS FAN SYSTEM CALCULATOR"]

{"sheet":"Help Guide","index":7,"n_rows":246,"n_cols":3,"rows_kept":246,"cut":false,"hidden":true,"merged":[[6,1,6,2],[3,1,3,2],[4,1,4,2],[5,1,5,2],[199,1,199,2],[7,1,7,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[15,1,15,2],[61,1,61,2],[113,1,113,2],[116,1,116,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,"Return to All Systems"]
[null,"Leave the guide and return to the All Systems sheet"]
[]
[null,"Technical Information"]
[null,"1. Version"]
[null,null,"This is a release version of the Fan 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 Fan System Calculator, macros must be enabled. If they are not, the Calculator will display an error."]
[null,"3. Displaying the Calculator"]
[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 Fan System Calculator uses four different sheets to provide a logical sequence of operations. "]
[null,null,"The 'All Systems' sheet serves as a schedule of fans included in the project, and allows for navigation between them."]
[null,null,"The 'Summary' sheet includes general information about a particular system and computes the results."]
[null,null,"The 'Index Run' sheet allows the user to input the details of their index run, and evaluates its pressure drops to compare with the NCC DTS requirements."]
[null,null,"The 'Fan Details' sheet includes the efficiency of the fan, and characteristics required to determine the required fan efficiency."]
[null,null,"The 'Report' sheet builds a dynamic report summarising the results of all the systems within the project."]
[null,"5. Changing input details"]
[null,null,"Generally cells coloured in light brown/gold are available for user input. On occasion, an incorrect entry will be coloured red and be available for user input."]
[null,null,"Index Run or All Systems rows coloured red or green to indicate they satisfy J5.4 and will remain available for user input. Other cells are involved in calculations or otherwise are not editable."]
[null,null,"On the 'All Systems' sheet, a schedule of fans can be built and basic information input. System-wide information can also be entered here."]
[null,null,"On the 'Summary' sheet, the general configuration of the system can be selected."]
[null,null,"The 'Index Run' sheet allows the user to build a duct system and fill in the details of that system."]
[null,null,"On the 'Fan Details' sheet, the efficiency of the fan selected can be input, along with details to determine its required efficiency."]
[null,null,"The procedure and details to be input on each sheet are described in more detail in the '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 pre-set 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 of them is active at any time."]
[null,null,"The active system is highlighted with an italic font on the 'All Systems' sheet, as well as references to fan tags across the other worksheets."]
[null,null,"It can be changed by clicking within its row on the 'All Systems' sheet, using the drop down at the left of the ribbon, or through clicking one of its 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 calculations. "]
[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' button on the ribbon."]
[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, 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 1 - The Ribbon"]
[]
[null,"When you open the Calculator, instead of the normal Microsoft Excel menu, the custom Fan System Calculator ribbon will appear."]
[null,"The first group consists of only one object - the system change drop down menu."]
[null,"Clicking this will display a list of fan tags, and clicking any of them will change the active system to that one."]
[]
[null,"The second group is used to navigate between the sheets."]
[null,"Clicking All Systems, Summary, Index Run or Fan Details will bring you to that sheet for the particular system which is active and navigable here."]
[null,"These sheets are the core of the Calculator."]
[]
[null,"The third group is concerned with reporting."]
[null,"You can go to the 'Report' sheet, bringing together the summaries for all systems within this project, and print the report from here."]
[]
[null,"The fourth group is a link to the help guide, which brings you to this guide."]
[]
[null,"The fifth group includes the zoom functions, for ease of access."]
[]
[null,"The remainder of this guide will demonstrate how to operate each of the individual sheets reached through the ribbon."]
[]
[null,"Step 2 - 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 fans, summarising information about the project and each system within."]
[]
[null,"Enter your project's basic information at the top. This serves as your identification of this project, and will be repeated in the report generated at the end."]
[]
[null,"Below this, you are presented with a table of systems. This serves as the project's schedule."]
[null,"When opening a new calculator, there should only be one system here."]
[null,"Each system, in addition to the information listed, has a series of controls button on the right 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 systems."]
[]
[null,"Filling out the schedule"]
[null,"Enter the system description, tag and flow rate for the first fan."]
[null,"Then, click on the Plus (+) button to add another system. Repeat until all 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 on 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 fan tags are listed, for easy navigation."]
[null,"Although the Calculator can hold as many systems as you like, you can only edit one system at a time. The other sheets relate to the selected 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, using the Copy and Paste functions will save you time."]
[]
[null,"Step 3 - System Characteristics"]
[]
[null,"Select your first system. Remember, 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,"The Summary sheet serves dual purposes. It holds more specific configuration information and builds the results for your system."]
[null,"The configuration is the first item of interest."]
[]
[null,"The basic building and fan information you entered in the previous sheet are filled through to here. If you forget which system is active, the fan tag will tell you."]
[null,"There's also have a series of drop down selectors providing more information about the particular system."]
[null,"The fan's type together with its inlet and outlet conditions are used as part of the efficiency calculations. Its role and the presence or absence of a fouling risk are used to customise the requirements."]
[null,"After this information is entered, it's worth taking a look at the 'Requirements Applicable' cell."]
[null,"Some types of systems aren't required to comply with the provisions of J5.4. So if the requirements are 'Not Applicable' to your system, skip and move on to the next system."]
[null,"The 'Set As Default' button can be used. If you have a series of fans with similar configurations, you can set up one, then hit the 'Set As Default' button. All future fans added to the project will follow that configuration."]
[null,"The 'Copy/Paste' buttons in the 'All Systems' sheet can also be used for this if you'd prefer to set up the configuration once and copy it to each similar system."]
[]
[null,"The remainder of this sheet is dedicated to results, covered later."]
[]
[null,"Step 4 - Index Run"]
[]
[null,"Select the 'Index Run' sheet."]
[null,"The 'Index Run' sheet allows you to build the index run of the duct system and determine whether it complies with the pressure drop requirements."]
[]
[]
[null,"Depending on your computer's configuration, you might need to zoom out a little to fit the entire sheet on one screen."]
[]
[null,"Much like the 'All Systems' sheet, the 'Index Run' sheet allows you to build a table to suit your needs."]
[null,"Each row represents one segment of a system, e.g. a straight run of duct, a bend, or a coil."]
[]
[null,"The Plus (+), Minus (-), Copy (C), Paste (P) and Default (D) buttons are present and operate in the same manner as in the 'All Systems' sheet."]
[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, allowing you to use its values for each future row you add."]
[null,"This is a powerful way to maintain consistent parameters like roughness, shape and temperature where they will be the same throughout the system."]
[]
[null,"Each row will reconfigure itself based on the selections made. "]
[null,"If you select a rectangular shape, then the width and height will become available. Conversely, a circular shaped duct will require a diameter."]
[null,"The Calculator is only compatible with rectangular and circular duct. For atypical ducts (oval, fabric, etc.), this Calculator cannot be used."]
[null,"When selecting each component's type, you'll have the option of straight duct, or a fitting. For fittings, you can choose between selecting a pressure drop or using a loss coefficient."]
[null,"The fittings with defined maximum pressure drops in J5.4(d) are included, as well as bends associated with J5.4(c)(iv). An 'other' option should be used for fittings without defined maximum pressure drops."]
[null,"The choice can vary by item, and the Calculator will automatically reconfigure itself to suit your choices."]
[]
[null,"For each item, complete the highlighted light brown/gold sections. Once enough information has been entered, it will be highlighted in green or red to identify it satisfies J5.4."]
[null,"The Calculator will pull together the pressure drop through the straight sections of duct, to compare with the requirement of J5.4(c)(i)."]
[null,"It also checks the pressure drops of each fitting individually as well as summing these up to form a total."]
[null,"Thanks to the trading off provisions available in J5.4(a)(ii), it is entirely possible for a fan system to satisfy J5.4 even when one or more individual items don't."]
[]
[null,"So even if the result is that your index run isn't compliant on a component level, you can still proceed to the Fan Details sheet."]
[]
[null,"Step 5 - Fan Details"]
[]
[null,"The last remaining hole in the puzzle is the Fan Details. So click its button on the ribbon."]
[]
[]
[null,"The 'Fan Details' sheet compiles together the information already provided on this system's fan with the additional specifics required."]
[null,"If you have completed the 'Duct Details' sheet, the total static pressure that's been calculated will be listed."]
[null,"Although this can be used as a guide for the design static pressure, designers should also ensure they allow for all the other contingencies for a system's design."]
[]
[null,"The motor input power and efficiency should also be entered."]
[null,"The efficiency required to comply on a component level will be calculated based upon the information entered, both here and in previous sections."]
[]
[null,"Step Six - Results"]
[]
[null,"Having completed the inputs, returning to the 'Summary' sheet will show the results for this system. Click the 'Summary' button on the ribbon to navigate here."]
[null,"After the initial system characteristics, the remainder of the 'Summary' sheet serves as both a progress checker and to communicate the results."]
[]
[]
[null,"If you need to leave a calculation part way through, the Summary will tell you which components are still remaining to be completed."]
[null,"It also pulls together the results of each component, to tell if you satisfy both the fan and index run components of the J5.4 requirement (J5.4(a)(i))."]
[null,"If you do not satisfy J5.4(a)(i), then NCC 2019 allows this to be proven on a system level in J5.4(a)(ii)."]
[null,"If all the data has been provided, 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 Calculator also summarises all its findings, to provide guidance around how you may be able to reach compliance or other areas of concern."]
[null,"The 'Result' within the 'Summary' sheet is colour coded and summarised through a bold sentence at the top."]
[null,"It also contains information based on your inputs across each component, and even handy hints on how your system might be able to satisfy the requirements, or which information is missing."]
[]
[null,"From here, you can move to another system, by using the ribbon to change it. Alternately, return to the 'All Systems' sheet, take stock and select your next system from there."]
[null,"Steps 3 to 6 can be repeated for each system in your project."]
[]
[null,"Step 7 - Reporting"]
[null,"The 'All Systems' sheet provides a quick summary of each system. But the Calculator also provides 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 pressure drop through the straight duct 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 iteratively using Excel's 'Goal Seek' function:"]
[]
[null,"where the terms are as defined above, and -"]
[]
[null,"The density of air is calculated through the ideal gas laws."]
[null,"The dynamic viscosity of air is determined through Sutherland's law."]
[null,"This is used to determine the pressure drop through straight duct."]
[]
[null,"When a kt value is provided, the pressure drop through a fitting is determined through:"]
[]
[null,"If a pressure drop is provided directly, then this is the figure used."]
[null,"The calculated (via a kt value) or entered pressure drop for a fitting is compared with the allowances of J5.4(d)."]
[null,"Neither the Calculator nor the NCC DTS requirements take static regain into account. For these methods, it is anticipated that designers will compute their fan motor input power and use J5.4(a)(ii)."]
[]
[null,"The required efficiency is computed through J5.4(b)(i) if the static pressure is less than 200Pa:"]
[]
[null,"If the external static pressure is more than 200Pa, then J5.4(b)(ii) is used:"]
[]
[null,"where - "]
[null,"P = the motor input power of the fan in kW"]
[null,"N = the minimum performance grade obtained by comparing the user inputs with Table J5.4a"]
[null,"a = the coefficient a, obtained by comparing the user inputs with Table J5.4b"]
[null,"b = the coefficient b, obtained by comparing the user inputs with Table J5.4c"]
[null,"This required efficiency is compared with that which the user enters."]
[]
[null,"Change Log"]
[null,"v1.1"]
[null,"Resolved bug where the wrong coefficients were applied for the efficiency of backwards-curved centrifugal fans"]
[]
[null,"v1.0"]
[null,"Released for full use."]
[]
[null,"v0.9"]
[null,"Beta release"]

{"sheet":"Report","index":8,"n_rows":40,"n_cols":5,"rows_kept":40,"cut":false,"hidden":true,"merged":[[39,1,39,4],[3,0,3,4],[4,0,4,1],[5,0,5,1],[7,0,7,2],[24,0,24,1],[8,1,8,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[14,1,14,2],[16,0,16,2],[12,1,12,2],[13,1,13,2],[25,0,25,1],[27,0,27,2],[35,0,35,4],[36,0,36,4],[31,0,31,4],[32,3,32,4],[33,3,33,4]]}
[]
[null,null,null,null,"Calculator"]
[]
["Project Information"]
["Building Name and Description",null,"Project Number","Designer","Company"]
["",null,"","",""]
[]
["System Information"]
["Fan Tag:"]
["Description:"]
["Type:","-Select-"]
["Role:","-Select-"]
["Inlet:","-Select-"]
["Outlet:","-Select-"]
["Flow Rate:"," L/s"]
[]
["Calculation Summary"]
["Component","System","Allowable"]
["Pressure Drop","TBC","TBC"]
["Straight PD","TBC","TBC"]
["Fitting PD","TBC","TBC"]
["Fan Efficiency",null,"TBC"]
["Motor Input Power","TBC","TBC"]
[]
["Requirements Applicable"]
["Insufficient Information"]
[]
["Component Level"]
["Index Run","Fan","Overall"]
["Insufficient Information","Insufficient Information","Insufficient Information"]
[]
["System Level"]
["Efficiency","Pressure Drop","Motor Power","Overall"]
["Insufficient Information","Insufficient Information","Insufficient Information","Insufficient Information"]
[]
["Result"]
["More data is required before it can be determined whether the requirements are applicable to the system.\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"]
["Version number: 1.0"]
["IMPORTANT NOTICE AND DISCLAIMER IN RESPECT OF THIS FAN SYSTEM CALCULATOR"]
[null,"IMPORTANT NOTICE AND DISCLAIMER IN RESPECT OF THIS FAN SYSTEM CALCULATOR"]

{"sheet":"Worksheet","index":9,"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."]

{"sheet":"Lists for Drop Down Selectors","index":10,"n_rows":148,"n_cols":10,"rows_kept":148,"cut":false,"hidden":true,"merged":[[20,1,20,4],[20,6,20,7],[20,8,20,9],[36,0,37,0],[32,2,32,3]]}
["This sheet is used to populate the options available. It should not be visible to regular users. If you see this, your calculator is malfunctioning  -the ABCB suggest that you return to our website and download a fresh copy."]
[]
["Types of Duct","Case Digit",null,null,"Types of Speed Control",null,null,"Fouling Risk"]
["-Select-","Z",null,null,"-Select-","Z",null,"-Select-","B"]
["Straight Duct","A",null,null,"Variable Speed","A",null,"Yes","A"]
["Duct Fitting (Kt)","B",null,null,"Constant Speed (as required by Part F4)","A",null,"No","B"]
["Duct Fitting (PD)","C",null,null,"Constant Speed (not required by Part F4)","B",null,0,"B"]
[0,"Z",null,null,0,"Z"]
[]
["Duct Shapes","Case Digit",null,null,"Fan Roles"]
["-Select-","Z",null,null,"-Select-","Z"]
["Rectangular Duct","A",null,null,"Smoke spill only","A"]
["Circular Duct","B",null,null,"Smoke spill (also used for air-conditioning or ventilation)","B"]
["Circular Flexible Duct","C",null,null,"Kitchen exhaust","A"]
[0,"Z",null,null,"Process-related","A"]
[null,null,null,null,"Explosion proof","B"]
[null,null,null,null,"Fan within an electricity substation","A"]
[null,null,null,null,"Any other air-conditioning or ventilation fan","B"]
[null,null,null,null,0,"Z"]
[]
[null,"Fan performance grade by type",null,null,null,null,"coefficient  a",null,"coefficient b"]
["Fan Types","A","B","C","D","N/A","<10",">=10","<10",">=10"]
[1,2,3,4,5,6]
["-Select-","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A"]
["Axial - as a component of an air handling unit or fan coil unit",46,51.5,46,51.5,"N/A",2.74,0.78,6.33,1.88]
["Axial - other",42,61,42,61,"N/A",2.74,0.78,6.33,1.88]
["Mixed flow - as a component of an air handling unit or fan coil unit",46,51.5,46,51.5,"N/A",4.5599999999999996,1.1000000000000001,10.5,2.6]
["Mixed flow - other",52.5,65,52.5,65,"N/A",4.5599999999999996,1.1000000000000001,10.5,2.6]
["Centrifugal forward-curved",46,51.5,46,51.5,"N/A",2.74,0.78,6.33,1.88]
["Centrifugal radial bladed",46,51.5,46,51.5,"N/A",2.74,0.78,6.33,1.88]
["Centrifugal backward-curved",64,64,64,64,"N/A",4.5599999999999996,1.1000000000000001,10.5,2.6]
[]
["Index table for installation type",null,"Outlet"]
[null,null,"-Select-","Free","Ducted"]
[null,null,1,2,3]
[null,"-Select-","N/A","N/A","N/A"]
["Inlet","Free","N/A","A","B"]
[null,"Ducted","N/A","C","D"]
[]
["Fitting Types","Tag"]
["-Select-","Z"]
["Bend","K"]
["Other","L"]
["Coil","A"]
["Air Filter","B"]
["Intake Louvre","C"]
["VAV Box","D"]
["Rooftop Cowl","E"]
["Attenuator","F"]
["Damper","G"]
["Diffuser or Grille","H"]
["Transfer Duct","I"]
["Active Chilled Beam","J"]
["Straight Duct","Y"]
["N/A","Z"]
[{"$f":"\"\"","v":""},"Z"]
[0,"Z"]
[]
["Fitting Allowable Losses","Maximum PD (Pa)"]
[]
["A"]
["-Select-","TBC"]
["1 Row Coil",30]
["2 Row Coil",50]
["4 Row Coil",90]
["6 Row Coil",130]
["8 Row Coil",175]
["10 Row Coil",220]
[0,"TBC"]
[]
["B"]
["-Select-","TBC"]
["HEPA Filter",200]
["MERV 9 Filter",55]
["MERV 11 Filter",65]
["MERV 13 Filter",95]
["MERV 14 Filter",110]
[0,"TBC"]
[]
["C"]
["-Select-","TBC"]
["Single Stage Louvre",30]
["Two Stage Louvre",60]
["Acoustic Louvre",50]
["Other Non-Weatherproof Louvre",30]
[0,"TBC"]
[]
["D"]
["-Select-","TBC"]
["Electric Reheat VAV",100]
["Other VAV",25]
[0,"TBC"]
[]
["E"]
["-Select-","TBC"]
["Any Rooftop Cowl",30]
[0,"TBC"]
[]
["F"]
["-Select-","TBC"]
["Any Attenuator",40]
[0,"TBC"]
[]
["G"]
["-Select-","TBC"]
["Fire Damper",15]
["Balancing or Control Damper",25]
[0,"TBC"]
[]
["H"]
["-Select-","TBC"]
["Supply Air Diffuser",40]
["Supply Grille",40]
["Exhaust Grille",30]
["Door Grille",12]
[0,"TBC"]
[]
["I"]
["-Select-","TBC"]
["Any Transfer Duct",12]
[0,"TBC"]
[]
["J"]
["-Select-","TBC"]
["Any Active Chilled Beam",150]
[0,"TBC"]
[]
["K"]
["-Select-","TBC"]
["Bend with turning vanes","N/A"]
["Long radius bend","N/A"]
["Bend with obtruse angle (more than 90°)","N/A"]
["Any other bend","N/A"]
[0,"TBC"]
[]
["L"]
["-Select-","TBC"]
["Any Other","N/A"]
[0,"TBC"]
[]
["Z"]
["-Select-","TBC"]
["N/A","TBC"]
[0,"TBC"]
[]
["Y"]
["N/A","TBC"]
[0,"TBC"]