{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Instructions","Backend","Calculator_COP","Calculator_PlantEfficiency","Calculator_TerminalUnits","BlockSummary","PlantSummary","TerminalUnitSummary","Lists"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":105,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":16,"n_cols":3,"rows_kept":16,"cut":false,"hidden":false,"merged":[[23,1,23,11],[24,1,24,11],[25,1,25,11],[26,1,26,11],[13,2,13,10],[15,2,15,10],[17,1,17,11],[18,1,18,11],[19,1,19,11],[20,1,20,11],[21,1,21,11],[22,1,22,11],[2,1,2,11],[1,1,1,11],[3,1,3,11],[16,1,16,11],[7,2,7,11],[6,2,6,11],[8,2,8,11],[4,2,4,11],[5,2,5,11],[14,2,14,10],[10,2,10,10],[11,2,11,10],[9,2,9,10]]}
[]
[null,"Instructions"]
[null,"Use this calculator to adjust the rated heating and cooling system efficiency to remove fan power at rated conditions for input in simulation tools.\nThis calculator uses the methods defined in ASHRAE Standard 90.1-2016 Appendix G, Section G3.1.2.1 to remove the supply fan energy from the COP of a packaged equipment."]
[null,"To use this calculator-"]
[null,1,"Select the equipment type from the 'Equipment Type' drop down."]
[null,2,"Select the appropriate efficiency units from the 'Efficiency Units' drop down."]
[null,3,"Enter the rated system efficiency using the appropriate efficiency units (for SEER, EER, AFUE, COP or HSPF)"]
[null,4,"Enter the system heating and cooling capacity as well as number of systems, as applicable."]
[null,5,"The calculator adjusts the efficiency rating to remove the supply fan energy. Supply fan energy is modeled seperately in the Asset Score tool  and Asset Score-TSPR tool."]
[null,6,"User needs to provide inputs in tabs 'Calculator_COP',  'Calculator_TerminalEquipment' and 'Calculator_PlantEfficiency' for all applicable systems."]
[null,7,"It calculates weighted averages for cooling efficiency, heating efficiency, fan power and minimum airflow fraction, which are displayed in tabs 'BlockSummary' and 'TerminalUnitSummary'"]
[null,8,"The calculated weighted averages for plant efficiency are displayed in tab 'PlantSummary'"]
[]
[null,null,"Cells highlighted in light green are optional user inputs"]
[null,null,"Cells highlighted in dark green are optional user inputs"]
[null,null,"Cells highlighted in blue are calculated values, to be enterred into the TSPR Tool"]

{"sheet":"Backend","index":1,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,"nCOPSystems",{"$f":"ROW(calcCOPTableEnd)-ROW(calcCOPRef1)-1","v":21}]
[null,"nChillers",{"$f":"ROW(calcChillerTableEnd)-ROW(calcChillerRef1)-1","v":7}]
[null,"nBoilers",{"$f":"ROW(calcBoilerTableEnd)-ROW(calcBoilerRef1)-1","v":6}]
[null,"nTUs",{"$f":"ROW(calcTUTableEnd)-ROW(calcTURef1)-1","v":12}]
[null,"nCopRows",{"$f":"ROW(calcCOPTableEnd)-ROW(calcCOPRef1)-1","v":21}]
[null,"nCopFormulas",{"$f":"COLUMN(calcCOPTableEnd2)-COLUMN(coolCapacityTableEnd)+1","v":9}]
[null,"nChillerFormulas",{"$f":"COLUMN(calcChillerTableEnd2)-COLUMN(chillCapacityTableEnd)+1","v":3}]
[null,"nBoilerFormulas",{"$f":"COLUMN(calcBoilerTableEnd2)-COLUMN(boilCapacityTableEnd)+1","v":3}]
[null,"nTUFormulas",{"$f":"COLUMN(calcTUTableEnd2)-COLUMN(tuAirflowProductTableEnd)+1","v":2}]

{"sheet":"Calculator_COP","index":2,"n_rows":55,"n_cols":21,"rows_kept":55,"cut":false,"hidden":false,"merged":[[54,1,55,10],[36,1,39,10],[33,1,34,10],[32,1,32,10],[30,1,30,10],[1,1,2,20],[41,1,42,10],[43,1,48,10],[49,1,52,10],[3,2,3,18],[4,2,4,18],[29,1,29,10],[31,1,31,10]]}
[]
[null,"COP Calculator"]
[]
[null,null,"Cells highlighted in green are required user inputs"]
[null,null,"Cells highlighted in blue are calculated values, to be enterred into the TSPR Tool"]
[]
[null,"Block Assignment","Number of Systems","System ID/\nEquipment Tag","Equipment Type","Rated Cooling Capacity (Btu/h)","Rated Heating Capacity (Btu/h)","Design Supply Airflow (CFM)*","Total System Fan Power (W/CFM)**","Efficiency Units","Rated Efficiency***","HIDDEN: Cooling Capacity","HIDDEN: Heating Capacity","HIDDEN: Cooling Product","HIDDEN: Heating Product","Hidden:  Fan Airflow","Hidden:  Fan Power Product","HIDDEN: Thermal Efficiency Product","COPnfcooling","COPnfheat","Thermal Efficiency"]
[null,"Block A",4,"System 1","PTAC",12000,13500,400,0.35,"EER",11.4,{"$f":"IF(S8<>\"NA\",IFERROR($C8*F8,\"NA\"),\"NA\")","v":48000},{"$f":"IF(AND(T8=\"NA\",U8=\"NA\"),\"NA\",IFERROR($C8*G8,\"NA\"))","v":54000},{"$f":"IF(L8<>\"NA\",IFERROR(L8*S8,\"NA\"),\"NA\")","v":171483.84},{"$f":"IF(M8<>\"NA\",IFERROR(M8*T8,\"NA\"),\"NA\")","v":"NA"},{"$f":"IF(I8<=0,\"NA\",$H8*$C8)","v":1600},{"$f":"IF(I8<=0,\"NA\",$I8*$H8*$C8)","v":560},{"$f":"IFERROR(IF(U8<=0,\"NA\",$U8*$G8*$C8),\"NA\")","v":43200},{"$f":"IF(AND(OR(E8=\"PTAC\",E8=\"PTHP\"),J8=\"EER\"),0.3322*K8-0.2145,\nIF(AND(J8=\"EER\",OR(E8=\"Packaged Heat Pump\",E8=\"Packaged Air Conditioner\")),K8*0.0000000784*F8+0.338*K8,\nIF(AND(J8=\"SEER\",OR(E8=\"Packaged Heat Pump\",E8=\"Packaged Air Conditioner\")),-0.0076*K8^2+0.3796*K8,\nIF(AND(E8=\"VRF System\",J8=\"EER\"),(K8/3.413)/(1-((cfm_per_tom/12000)*W_per_cfm)*K8),\"NA\"))))","v":3.5725799999999999},{"$f":"IF(AND(E8=\"PTHP\",J8=\"COP\"),1.1329*K8-0.214,\nIF(AND(E8=\"Packaged Heat Pump\",J8=\"COP\"),K8*0.000000148*F8+1.062*K8,\nIF(AND(E8=\"Packaged Heat Pump\",J8=\"HSPF\"),-0.0296*K8^2+0.7134*K8,\nIF(AND(E8=\"VRF System\",J8=\"COP\"),K8/(1-((3.413*0.125*450/12000))*K8),\"NA\"))))","v":"NA"},0.8]
[null,"Block A",2,"System 2","PTAC",18000,19000,600,0.35,"EER",14,36000,{"$f":"IF(AND(T9=\"NA\",U9=\"NA\"),\"NA\",IFERROR($C9*G9,\"NA\"))","v":38000},159706.80000000002,"NA",{"$f":"IF(I9<=0,\"NA\",$H9*$C9)","v":1200},{"$f":"IF(I9<=0,\"NA\",$I9*$H9*$C9)","v":420},{"$f":"IFERROR(IF(U9<=0,\"NA\",$U9*$G9*$C9),\"NA\")","v":30780.000000000004},4.4363000000000001,{"$f":"IF(AND(E9=\"PTHP\",J9=\"COP\"),1.1329*K9-0.214,\nIF(AND(E9=\"Packaged Heat Pump\",J9=\"COP\"),K9*0.000000148*F9+1.062*K9,\nIF(AND(E9=\"Packaged Heat Pump\",J9=\"HSPF\"),-0.0296*K9^2+0.7134*K9,\nIF(AND(E9=\"VRF System\",J9=\"COP\"),K9/(1-((3.413*0.125*450/12000))*K9),\"NA\"))))","v":"NA"},0.81]
[null,"Block A",1,"System 3","PTAC",15000,17000,500,0.35,"EER",11,15000,17000,51595.5,"NA",500,175,14450,3.4396999999999998,"NA",0.85]
[null,"Block A",1,"System 4","PTAC",15000,16000,500,0.35,"EER",11,15000,16000,51595.5,"NA",500,175,12800,3.4396999999999998,"NA",0.8]
[null,"Block B",3,"System 5","Packaged Air Conditioner",335000,320000,12000,0.52800000000000002,"EER",10,1005000,960000,3660853.2,"NA",36000,19008,768000,3.6426400000000001,"NA",0.8]
[null,"Block C",3,"System 6","Packaged Heat Pump",240000,260000,8000,0.65200000000000002,"EER",11.2,720000,"NA",2877364.2239999999,"NA",24000,15648,"NA",3.9963392,"NA","NA"]
[null,"Block C",3,"System 6","Packaged Heat Pump",240000,260000,8000,0.65200000000000002,"COP",3.2,"NA",780000,"NA",2739409.9200000004,24000,15648,"NA","NA",3.5120640000000005,"NA"]
[null,"Block C",2,"System 7","Packaged Heat Pump",240000,255000,8000,0.57199999999999995,"EER",11.2,480000,"NA",1918242.8159999999,"NA",16000,9152,"NA",3.9963392,"NA","NA"]
[null,"Block C",2,"System 7","Packaged Heat Pump",240000,255000,8000,0.57199999999999995,"COP",3.4,"NA",510000,"NA",1903099.6800000002,16000,9152,"NA","NA",3.7315680000000002,"NA"]
[null,"Block C",4,"System 8","Packaged Heat Pump",90000,95000,3000,0.64800000000000002,"EER",11.7,360000,"NA",1453375.872,"NA",12000,7776,"NA",4.0371551999999999,"NA","NA"]
[null,"Block C",4,"System 8","Packaged Heat Pump",90000,95000,3000,0.64800000000000002,"COP",3.6,"NA",380000,"NA",1471037.7600000002,12000,7776,"NA","NA",3.8711520000000004,"NA"]
[null,"Block C",2,"System 9","Packaged Heat Pump",85000,90000,2800,0.47299999999999998,"EER",11.2,170000,"NA",656240.25600000005,"NA",5600,2648.7999999999997,"NA",3.8602368,"NA","NA"]
[null,"Block C",2,"System 9","Packaged Heat Pump",85000,90000,2800,0.47299999999999998,"COP",3.2,"NA",180000,"NA",618958.08000000007,5600,2648.7999999999997,"NA","NA",3.4386560000000004,"NA"]
[null,"Block D",1,"System 10","VRF System",240000,245000,5500,0.32,"EER",9.5,240000,"NA",699168.85057110537,"NA",5500,1760,"NA",2.9132035440462722,"NA","NA"]
[null,"Block D",1,"System 11","VRF System",155000,160000,3500,0.32,"EER",10.4,155000,"NA",496516.9505327277,"NA",3500,1120,"NA",3.2033351647272754,"NA","NA"]
[null,"Block D",1,"System 12","VRF System",240000,220000,5500,0.32,"COP",3.2,"NA",220000,"NA",741985.97182772018,5500,1760,"NA","NA",3.3726635083078191,"NA"]
[null,"Block D",1,"System 13","VRF System",155000,160000,3500,0.32,"COP",3.2,"NA",160000,"NA",539626.16132925102,3500,1120,"NA","NA",3.3726635083078191,"NA"]
[null,"Block E",4,"System 14","PTHP",15000,15000,350,0.35,"EER",12,60000,"NA",226313.99999999997,"NA",1400,489.99999999999994,"NA",3.7718999999999996,{"$f":"IF(AND(E25=\"PTHP\",J25=\"COP\"),1.1329*K25-0.214,\nIF(AND(E25=\"Packaged Heat Pump\",J25=\"COP\"),K25*0.000000148*F25+1.062*K25,\nIF(AND(E25=\"Packaged Heat Pump\",J25=\"HSPF\"),-0.0296*K25^2+0.7134*K25,\nIF(AND(E25=\"VRF System\",J25=\"COP\"),K25/(1-((3.413*0.125*450/12000))*K25),\"NA\"))))","v":"NA"},"NA"]
[null,"Block E",6,"System 15","PTHP",18000,19000,400,0.35,"COP",3.5,"NA",114000,"NA",427631.1,2400,840,"NA","NA",3.75115,"NA"]
[null,null,null,null,null,null,null,null,null,null,null,"NA",0,"NA","NA",{"$f":"IF(I27<=0,\"NA\",$H27*$C27)","v":"NA"},{"$f":"IF(I27<=0,\"NA\",$I27*$H27*$C27)","v":"NA"},{"$f":"IFERROR(IF(U27<=0,\"NA\",$U27*$G27*$C27),\"NA\")","v":"NA"},"NA","NA"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(S28<>\"NA\",IFERROR($C28*F28,\"NA\"),\"NA\")","v":"NA"},{"$f":"IF(AND(T28=\"NA\",U28=\"NA\"),\"NA\",IFERROR($C28*G28,\"NA\"))","v":0},{"$f":"IF(L28<>\"NA\",IFERROR(L28*S28,\"NA\"),\"NA\")","v":"NA"},{"$f":"IF(M28<>\"NA\",IFERROR(M28*T28,\"NA\"),\"NA\")","v":"NA"},{"$f":"IF(I28<=0,\"NA\",$H28*$C28)","v":"NA"},{"$f":"IF(I28<=0,\"NA\",$I28*$H28*$C28)","v":"NA"},{"$f":"IFERROR(IF(U28<=0,\"NA\",$U28*$G28*$C28),\"NA\")","v":"NA"},{"$f":"IF(AND(OR(E28=\"PTAC\",E28=\"PTHP\"),J28=\"EER\"),0.3322*K28-0.2145,\nIF(AND(J28=\"EER\",OR(E28=\"Packaged Heat Pump\",E28=\"Packaged Air Conditioner\")),K28*0.0000000784*F28+0.338*K28,\nIF(AND(J28=\"SEER\",OR(E28=\"Packaged Heat Pump\",E28=\"Packaged Air Conditioner\")),-0.0076*K28^2+0.3796*K28,\nIF(AND(E28=\"VRF System\",J28=\"EER\"),(K28/3.413)/(1-((cfm_per_tom/12000)*W_per_cfm)*K28),\"NA\"))))","v":"NA"},"NA"]
[]
[null,"Note: Duplicate this tab to analyze additional systems"]
[null,"* Design Supply Airflow (CFM): This is the main supply airflow (CFM) at design conditions."]
[null,"** Total System Fan Power (W/CFM): This is the input electric power for all fans (including supply, return, relief fans and series terminal fan) when operated at fan system design conditions divided by the supply airflow rate"]
[null,"*** Rated efficiency: For VRF Systems and Air Source Heat Pumps, this is the COP at 47°F db/43°F wb Outdoor Air"]
[null,"Calculator Assumptions and Calculation Process"]
[]
[null,"Packaged Terminal Systems (Tables C403.3.2(3) in WSEC)"]
[null,"For Packaged Terminal Air Conditioners (PTACs) and Packaged Terminal Heat Pumps (PTHP)\nCOPnfcooling = 0.3322 x EER – 0.2145\nFor Heat Pumps-\nCOPnfheating = 1.1329*COP – 0.2140"]
[]
[]
[]
[null,"Packaged Systems (Tables C403.3.2(1)A, C403.3.2(2) in WSEC)"]
[null,"This tool uses the methods defined in ASHRAE Standard 90.1-2016 Appendix G, Section G3.1.2.1 to remove the supply fan energy from the COP for all packaged equipment including packaged single zone AC, packaged single zone HP and packaged milti-zone VAV systems."]
[]
[null,"For Packaged DX Equipment\nCOPnfcooling = 7.84E-8 x EER x Q + 0.338 x EER\nCOPnfcooling = -0.0076 x SEER2 + 0.3796 x SEER\nFor Heat Pumps-\nCOPnfheating = 1.48E-7 x COP47 x Q + 1.062 x COP47 \nCOPnfheating = -0.0296 x HSPF2 + 0.7134 x HSPF"]
[]
[]
[]
[]
[]
[null,"Where-\nCOPnfcooling and COPnfheating are the packaged HVAC equipment cooling and\nheating energy efficiency,which excludes supply fan power, and \nQ is the AHRI-rated cooling capacity in Btu/h\nEER, SEER, COP, and HSPF are specified at AHRI test conditions."]
[]
[]
[]
[null,"VRF Systems (Table C403.3.2(1)B, C403.3.2(1)C in WSEC)"]
[null,"This calculator assumes an indoor fan power of 0.125 W/CFM and airflow as 450 CFM/ton. The rated efficiency is adjusted to remove the supply fan power."]

{"sheet":"Calculator_PlantEfficiency","index":3,"n_rows":47,"n_cols":12,"rows_kept":47,"cut":false,"hidden":false,"merged":[[1,1,1,11],[42,1,42,11],[43,2,43,8],[44,2,44,8],[31,2,31,7],[32,2,32,7],[33,1,33,11],[3,2,3,11],[4,2,4,11],[29,1,30,11],[31,1,32,1],[8,2,8,7],[9,2,9,7],[10,1,10,11],[6,1,7,11],[8,1,9,1],[45,2,45,8],[20,1,20,11],[21,2,21,8],[22,2,22,8],[23,2,23,8],[24,2,24,8]]}
[]
[null,"Chiller and Boiler Efficiency Calculator"]
[null,"This tab provides"]
[null,1,"A calculator for converting full load chiller efficiency from kW/Ton and EER to COP."]
[null,2,"A calculator for converting Boiler Efficiency from AFUE or Combustion Efficiency (Ec) to Thermal Efficiency (Et)"]
[]
[null,"Chiller COP Calculator"]
[]
[null,null,"Cells highlighted in green are required user inputs"]
[null,null,"Cells highlighted in blue are calculated values, to be enterred into the TSPR Tool"]
[]
[null,"Plant Loop Name","System ID/\nEquipment Tag","Equipment Type","Block Assignment","Number of Pieces of Equipment","Rated Cooling Capacity (tons)","Efficiency Units","Rated Efficiency*","HIDDEN: Total Capacity","HIDDEN: Capacity Product","COPcooling"]
[null,"Chiller Water Plant Loop 1","Chiller 1","Air Cooled Chiller","Block D",2,225,"EER",12,{"$f":"IF(G13<>\"\",F13*G13,\"NA\")","v":450},{"$f":"IFERROR(J13*L13,\"NA\")","v":1582.6494724501758},{"$f":"IF(I13=\"\",\"NA\",\nIF(H13=\"EER\",I13/3.412,\nIF(H13=\"COP\",I13,\n IF(H13=\"kW/ton\", (12/I13)/3.412,\"NA\"))))","v":3.5169988276670576}]
[null,"Chiller Water Plant Loop 1","Chiller 2","Air Cooled Chiller","Block D",1,160,"EER",11,{"$f":"IF(G14<>\"\",F14*G14,\"NA\")","v":160},{"$f":"IFERROR(J14*L14,\"NA\")","v":515.8264947245018},{"$f":"IF(I14=\"\",\"NA\",\nIF(H14=\"EER\",I14/3.412,\nIF(H14=\"COP\",I14,\n IF(H14=\"kW/ton\", (12/I14)/3.412,\"NA\"))))","v":3.2239155920281362}]
[null,"Chiller Water Plant Loop 2","Chiller 3","Water Cooled Chiller","Block E",1,200,"kW/Ton",0.66,200,1065.7572205051688,5.3287861025258438]
[null,"Chiller Water Plant Loop 2","Chiller 4","Water Cooled Chiller","Block E",1,450,"kW/Ton",0.61,450,2594.5073318855343,5.7655718486345204]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(G17<>\"\",F17*G17,\"NA\")","v":"NA"},"NA","NA"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(G18<>\"\",F18*G18,\"NA\")","v":"NA"},"NA",{"$f":"IF(I18=\"\",\"NA\",\nIF(H18=\"EER\",I18/3.412,\nIF(H18=\"COP\",I18,\n IF(H18=\"kW/ton\", (12/I18)/3.412,\"NA\"))))","v":"NA"}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(G19<>\"\",F19*G19,\"NA\")","v":"NA"},{"$f":"IFERROR(J19*L19,\"NA\")","v":"NA"},{"$f":"IF(I19=\"\",\"NA\",\nIF(H19=\"EER\",I19/3.412,\nIF(H19=\"COP\",I19,\n IF(H19=\"kW/ton\", (12/I19)/3.412,\"NA\"))))","v":"NA"}]
[]
[null,"Instructions"]
[null,null,"Use the 'Add Chiller' button to add additional cooling plant equipment"]
[null,null,"All inputs highlighted in green need to be provided for the calculator to work."]
[null,null,"After completing data entry, refer to the 'Plant Summary' tab for the equipment capacity weighted efficiency value for input into the Asset Score Tool and Asset Score-TSPR Tool."]
[null,null,"*For WA State TSPR Compliance Analysis, the Rated Efficiency for chillers, is the Full Load Path A efficiency as shown in WSEC Table C403.3.2(7) "]
[]
[]
[]
[]
[null,"Boiler Thermal Efficiency Calculator"]
[]
[null,null,"Cells highlighted in green are required user inputs"]
[null,null,"Cells highlighted in blue are calculated values, to be enterred into the TSPR Tool"]
[]
[null,"Plant Loop Name","System ID/\nEquipment Tag","Equipment Type","Block Assignment","Number of Pieces of Equipment","Rated Heating Capacity (Btu/hr)","Efficiency Units","Rated Efficiency**","HIDDEN: Total Capacity","HIDDEN: Capacity Product","Thermal Efficiency"]
[null,"Hot Water Plant Loop 1","Boiler 1","Boiler, Hot Water","Block D",2,250000,"AFUE",0.82,{"$f":"IF(G36<>\"\",F36*G36,\"NA\")","v":500000},{"$f":"IFERROR(J36*L36,\"NA\")","v":410300.69999999995},{"$f":"IF(I36=\"\",\"NA\",\nIF(H36=\"AFUE\",(0.0051427 *I36*100 ) + 0.3989,\nIF(H36=\"Et\",I36,\n IF(H36=\"Ec\",(I36*100-2)/100,\"NA\"))))","v":0.82060139999999993}]
[null,"Hot Water Plant Loop 1","Boiler 2","Boiler, Hot Water","Block D",1,2600000,"Ec",0.84,{"$f":"IF(G37<>\"\",F37*G37,\"NA\")","v":2600000},{"$f":"IFERROR(J37*L37,\"NA\")","v":2132000},{"$f":"IF(I37=\"\",\"NA\",\nIF(H37=\"AFUE\",(0.0051427 *I37*100 ) + 0.3989,\nIF(H37=\"Et\",I37,\n IF(H37=\"Ec\",(I37*100-2)/100,\"NA\"))))","v":0.82}]
[null,"Hot Water Plant Loop 2","Boiler 3","Boiler, Hot Water","Block E",1,1500000,"AFUE",0.82,1500000,1230902.0999999999,0.82060139999999993]
[null,"Hot Water Plant Loop 2","Boiler 4","Boiler, Hot Water","Block E",1,2500000,"Et",0.8,2500000,2000000,0.8]
[null,null,null,null,null,null,null,null,null,"NA","NA","NA"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(G41<>\"\",F41*G41,\"NA\")","v":"NA"},"NA",{"$f":"IF(I41=\"\",\"NA\",\nIF(H41=\"AFUE\",(0.0051427 *I41*100 ) + 0.3989,\nIF(H41=\"Et\",I41,\n IF(H41=\"Ec\",(I41*100-2)/100,\"NA\"))))","v":"NA"}]
[]
[null,"Instructions"]
[null,null,"Use the 'Add Boiler' button to add additional heating plant equipment"]
[null,null,"All inputs highlighted in green need to be provided for the calculator to work."]
[null,null,"After completing data entry, refer to the 'Plant Summary' tab for the equipment capacity weighted efficiency value for input into the Asset Score Tool and Asset Score-TSPR Tool."]
[null,null,"** For WA State TSPR Compliance Analysis, the Rated Efficiency for boilers, is as shown in WSEC Table 403.3.2(5)"]

{"sheet":"Calculator_TerminalUnits","index":4,"n_rows":27,"n_cols":9,"rows_kept":27,"cut":false,"hidden":false,"merged":[[4,2,5,6],[7,2,8,2],[7,3,7,5],[8,3,8,5],[10,2,13,6]]}
[]
[]
[]
[]
[null,null,"Calculator: Terminal Units"]
[]
[]
[null,null,null,"Cells highlighted in dark green are inputs"]
[null,null,null,"Cells highlighted in blue are calculated values, to be enterred into the TSPR Tool"]
[]
[null,null,"Use this table to enter information of all terminal units serving a block. The 'Terminal Unit Summary' tab will display the weighted average for minimum airflow fraction. Use the 'Add Terminal Unit' button to analyze additional blocks."]
[]
[]
[]
[null,null,"Block Name","System ID/\nEquipment Tag","Terminal Unit Peak Design Airflow (CFM)","Terminal Unit Minimum Airflow (CFM)","Minimum Airflow Fraction","Hidden: Airflow Product","Hidden: OA Fraction Product"]
[null,null,"Block F","Terminal Unit-1",600,150,{"$f":"IF(E16=\"\",\"\",F16/E16)","v":0.25},{"$f":"IFERROR($E16*F16,0)","v":90000},{"$f":"IFERROR($E16*G16,0)","v":150}]
[null,null,"Block F","Terminal Unit-2",700,175,{"$f":"IF(E17=\"\",\"\",F17/E17)","v":0.25},{"$f":"IFERROR($E17*F17,0)","v":122500},{"$f":"IFERROR($E17*G17,0)","v":175}]
[null,null,"Block F","Terminal Unit-3",450,150,0.33333333333333331,67500,150]
[null,null,"Block F","Terminal Unit-4",1200,300,0.25,360000,300]
[null,null,"Block G","Terminal Unit-5",800,200,0.25,160000,200]
[null,null,"Block G","Terminal Unit-6",900,225,0.25,202500,225]
[null,null,"Block G","Terminal Unit-7",700,175,0.25,122500,175]
[null,null,"Block G","Terminal Unit-8",450,130,0.28888888888888886,58500,130]
[null,null,"Block G","Terminal Unit-9",600,150,0.25,90000,150]
[null,null,"Block G","Terminal Unit-10",1400,350,0.25,490000,350]
[null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,{"$f":"IFERROR($E27*F27,0)","v":0},{"$f":"IFERROR($E27*G27,0)","v":0}]

{"sheet":"BlockSummary","index":5,"n_rows":17,"n_cols":9,"rows_kept":17,"cut":false,"hidden":false,"merged":[[4,3,5,3],[7,3,10,8],[2,3,3,8],[4,4,4,7],[5,4,5,7]]}
[]
[]
[null,null,null,"Block Summary"]
[]
[null,null,null,null,"Cells highlighted in dark green are required inputs."]
[null,null,null,null,"Cells highlighted in blue are calculated values, to be enterred into the TSPR Tool"]
[]
[null,null,null,"Instructions: \nClick on the 'Calculate Block Summary' button to calculate weighted average values. Enter these values into the Asset Score tool for each applicable block."]
[]
[]
[]
[null,null,null,"Block Name","System Type","Weighted Average COPnfcooling","Weighted Average COPnfheat","Thermal Efficiency","Total System Fan Power (W/CFM)*"]
[null,null,null,"Block A","PTAC",3.81,"N/A",0.81,0.35]
[null,null,null,"Block B","Packaged Air Conditioner",3.64,"N/A",0.8,0.52800000000000002]
[null,null,null,"Block C","Packaged Heat Pump",3.99,3.64,"N/A",0.61199999999999999]
[null,null,null,"Block D","VRF System",3.03,3.25,"N/A",0.32]
[null,null,null,"Block E","PTHP",3.77,3.75,"N/A",0.35]

{"sheet":"PlantSummary","index":6,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":false,"merged":[[3,2,4,5],[8,2,11,5],[5,3,5,4],[6,3,6,4],[5,2,6,2]]}
[]
[]
[]
[null,null,"Plant Loop Summary"]
[]
[null,null,null,"Cells highlighted in green are required inputs"]
[null,null,null,"Cells highlighted in blue are calculated values, to be enterred into the TSPR Tool"]
[]
[null,null,"Instructions:\nClick on the 'Calculate Plant Summary' button to calculate weighted average values. Enter these values into the Asset Score tool for each applicable plant loop."]
[]
[]
[]
[null,null,"Plant Loop Name","Plant Loop Type","Cooling COP","Thermal Efficiency"]
[null,null,"Chiller Water Plant Loop 1","Air Cooled Chiller",3.0289999999999999,"NA"]
[null,null,"Chiller Water Plant Loop 2","Water Cooled Chiller",5.6310000000000002,"NA"]
[null,null,"Hot Water Plant Loop 1","Boiler, Hot Water","NA",0.82]
[null,null,"Hot Water Plant Loop 2","Boiler, Hot Water","NA",0.80800000000000005]

{"sheet":"TerminalUnitSummary","index":7,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,3,2,5],[3,3,6,5],[7,3,9,5]]}
[]
[null,null,null,"Terminal Unit Summary"]
[]
[]
[]
[]
[]
[null,null,null,"Instructions: \nClick on the 'Calculate Terminal Unit Summary' button to calculate weighted average values.. Enter these values into the Asset Score tool for each applicable block."]
[]
[]
[null,null,null,"Block Name","Terminal Unit Minimum Airflow (CFM)","Minimum Airflow Fraction"]
[null,null,null,"Block F",216.95,0.26]
[null,null,null,"Block G",231.65,0.25]

{"sheet":"Lists","index":8,"n_rows":16,"n_cols":9,"rows_kept":16,"cut":false,"hidden":true,"merged":[]}
[]
[null,"System Type"]
[null,"PTAC","SEER","Single Zone",null,"Chiller Efficiency Units"]
[null,"PTHP","EER","Multi-Zone with Reheat",null,"EER","Air Cooled Chiller","Boiler, Hot Water","AFUE"]
[null,"Packaged Air Conditioner","HSPF",null,null,"kW/Ton","Water Cooled Chiller","Boiler, Steam","Ec"]
[null,"Packaged Heat Pump","COP",null,null,"COP",null,null,"Et"]
[null,"VRF System"]
[]
[]
[]
[]
[null,"Add a 'Add System' button on the 'CalculatorCOP' table which would add a row to the same table"]
[null,"Add a 'Add Plant Loop' button on the 'CalculatorPlantEfficiency' table which would add a row to the same table"]
[null,"Add a 'Add Yterminal Unit' button on the 'Calculator_TerminalUnits' table which would add a row to the same table. Weighted average calculations will be done for each block."]
[]
[null,"This tool will be developed further, so that a user needs to provide information only on the 'Calculator_COP', 'Calculator_PlantEfficiency' and 'Calculator_TerminalUnits' tabs. The tabs 'Block Summary' and 'PlantSummary' would be automatically populated with one row for each unique blocks with the weighted average values for COPnfHeating, COPnfCooling, Thermal Efficiency, Total System Fan Power and average minimum airflow fraction would be displayed. "]