{"text_format":"1","workbook":"xlsx","n_sheets":19,"sheets":["Workbook Introduction","Summary Sheet","Optimize Economizer Control","ResetControl(CHW,CW,DAT,Boiler)","System Scheduling","RTU Coil Cleaning","Steam Trap Repair","Reduce Steam Pressure","Comp. Air Leaks and Pressure","Anti Sweat Door Heater Controls","Cycle Evaporator Fans","Reduce Defrost Run Time","Optimize Evaporator Fans","Optimize Condenser Fans","Lower Condenser Pressure","Floating Head Pressure","Clean Condenser Coils","Reference","System Scheduling Calculations"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"comments":5,"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":"Workbook Introduction","index":0,"n_rows":46,"n_cols":6,"rows_kept":46,"cut":false,"hidden":false,"merged":[[36,2,36,3],[34,2,34,3],[35,2,35,3],[37,2,37,3],[34,6,34,7],[35,6,35,7],[36,6,36,7],[37,6,37,7],[45,1,45,7],[31,1,32,7],[1,1,2,7],[15,1,15,7],[22,1,23,2],[22,3,23,7],[13,1,14,7],[16,1,17,2],[16,3,17,7],[18,1,19,2],[18,3,19,7],[20,1,21,2],[20,3,21,7],[4,1,11,7],[39,2,39,3],[40,2,40,3]]}
[]
[null,"Equipment & Systems Performance Optimization (ESPO) Program\nLow Cost Tuning Measures (LCTM) Track Input Workbook"]
[]
[]
[null,"This input workbook has been developed by the Massachusetts PA's as way to collect necessary data to calculate energy savings. These tabs are color coded and organized by end use (blue for HVAC, orange for Steam, grey for Compressed Air, and yellow for Refrigeration) and may have more than one measure contained on each. The measures with inputs tracked in this sheet represent all 20 measures currently being considered in the Low Cost Tuning Track of the ESPO Program. Based on the information that is input on each tab, the sheet will display the incentive that can be expected, if the project is implemented. Accurate and complete information is required for each measure requesting incentive, as savings calculations are completed with the collected information."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Each tab in the workbook utilizes the following regarding color coding for cells. Please review before entering information."]
[]
[null,"Workbook Cell Color Key"]
[null,"User Input",null,"Fill in user input cells according to the best available understanding. Because these are site-specific values, there are no assumptions that can replace these inputs.\n\nNote: Some user input cells are not required for all measures. These are noted in the \"Relevant measures\" field."]
[]
[null,"Calculated - Affected by inputs",null,"This is a calculation cell that varies with user inputs. It can be used to understand more about when savings occurs."]
[]
[null,"Deemed or Assumed Values",null,"Values that are deemed or assumed if the user does not have access to that specific piece of information."]
[]
[null,"Optional user input",null,"These optional user inputs may be used to provide greater accuracy for savings. If they are left blank, default values will be used."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Please provide the following information keeping in mind that each Input Workbook should contain measures belonging to only one facility:"]
[]
[null,"Customer Information:",null,null,"Submitter Information:"]
[null,"Name",null,null,null,"Name"]
[null,"Facility Street",null,null,null,"Email Address"]
[null,"Facility City",{"$f":"HLOOKUP(C38,Reference!$C$34:$TB$35,2,FALSE)","v":{"$error":"#N/A"}},null,null,"Phone"]
[null,"Facility Zip Code",null,null,null,"Relationship to Customer"]
[]
[null,"Electric PA"]
[null,"Natural Gas PA"]
[]
[]
[]
[]
[null,"Document Version: 1/31/2024"]

{"sheet":"Summary Sheet","index":1,"n_rows":29,"n_cols":12,"rows_kept":29,"cut":false,"hidden":false,"merged":[[15,8,15,9],[25,8,25,9],[26,8,26,9],[28,8,28,9],[28,5,28,7],[23,8,23,9],[24,8,24,9],[23,6,23,7],[24,6,24,7],[25,6,25,7],[26,6,26,7],[22,6,22,7],[25,1,25,5],[26,1,26,5],[22,1,22,5],[23,1,23,5],[3,1,8,9],[19,8,19,9],[20,8,20,9],[21,8,21,9],[22,8,22,9],[12,8,12,9],[13,8,13,9],[14,8,14,9],[16,8,16,9],[17,8,17,9],[18,8,18,9],[17,6,17,7],[18,6,18,7],[19,6,19,7],[20,6,20,7],[21,6,21,7],[10,1,11,5],[10,8,11,9],[10,6,11,7],[12,6,12,7],[13,6,13,7],[14,6,14,7],[16,6,16,7],[19,1,19,5],[20,1,20,5],[21,1,21,5],[15,6,15,7],[24,1,24,5],[18,1,18,5],[14,1,14,5],[12,1,12,5],[13,1,13,5],[16,1,16,5],[17,1,17,5],[15,1,15,5]]}
[]
[null,"ESPO LCTM Summary"]
[]
[null,"As inputs are populated, estimated incentives for the customer will be summarized here. Your Program Administrator will confirm the incentive via Pre-Approval.\n\nIn the table below, please select which measures will be implemented at the site using the 'Yes / No' drop down.\n\nPlease note that if rows are added to an Input Sheet or tabs are added to the workbook, this Summary may not autopopulate for all entries."]
[]
[]
[]
[]
[]
[]
[null,"Measure List",null,null,null,null,"Select 'Yes' to access input sheet for measures being considered",null,"Incentive estimate based \non provided inputs"]
[]
[null,"Optimize Economizer Control",null,null,null,null,"No",null,{"$f":"L13","v":" "},null,null,{"$f":"IF(G13=\"Yes\",'Optimize Economizer Control'!G36,\" \")","v":" "}]
[null,"Reset CHW, CW, DAT & Boiler Temperatures",null,null,null,null,"No",null,{"$f":"L14","v":" "},null,null,{"$f":"IF(G14=\"Yes\",'ResetControl(CHW,CW,DAT,Boiler)'!H68,\" \")","v":" "}]
[null,"Adjust Pump & System Schedules",null,null,null,null,"No",null," ",null,null,{"$f":"IF(G15=\"Yes\",'System Scheduling'!D66,\" \")","v":" "}]
[null,"Clean RTU Coils",null,null,null,null,"No",null,{"$f":"L16","v":" "},null,null,{"$f":"IF(G16=\"Yes\",'RTU Coil Cleaning'!G44,\" \")","v":" "}]
[null,"Steam Trap Repair",null,null,null,null,"No",null,{"$f":"L17","v":" "},null,null,{"$f":"IF(G17=\"Yes\",'Steam Trap Repair'!D28,\" \")","v":" "}]
[null,"Reduce Steam Boiler Pressure",null,null,null,null,"No",null," ",null,null,{"$f":"IF(G18=\"Yes\",'Reduce Steam Pressure'!D38,\" \")","v":" "}]
[null,"Compressed Air Leaks and Pressure Reduction Measures",null,null,null,null,"No",null," ",null,null,{"$f":"IF(G19=\"Yes\",'Comp. Air Leaks and Pressure'!D92,\" \")","v":" "}]
[null,"Tune Anti-Sweat Controls",null,null,null,null,"No",null," ",null,null,{"$f":"IF(G20=\"Yes\",'Anti Sweat Door Heater Controls'!G30,\" \")","v":" "}]
[null,"Cycle Evaporator Fans",null,null,null,null,"No",null," ",null,null,{"$f":"IF(G21=\"Yes\",'Cycle Evaporator Fans'!G31,\" \")","v":" "}]
[null,"Reduce Defrost",null,null,null,null,"No",null," ",null,null,{"$f":"IF(G22=\"Yes\",'Reduce Defrost Run Time'!G31,\" \")","v":" "}]
[null,"Optimize Evaporator Fans",null,null,null,null,"No",null," ",null,null,{"$f":"IF(G23=\"Yes\",'Optimize Evaporator Fans'!G47,\" \")","v":" "}]
[null,"Optimize Condenser Fans",null,null,null,null,"No",null," ",null,null,{"$f":"IF(G24=\"Yes\",'Optimize Condenser Fans'!G54,\" \")","v":" "}]
[null,"Lower Condenser Pressure",null,null,null,null,"No",null," ",null,null,{"$f":"IF(G25=\"Yes\",'Lower Condenser Pressure'!I46,\" \")","v":" "}]
[null,"Optimize Floating Head Pressure",null,null,null,null,"No",null," ",null,null,{"$f":"IF(G26=\"Yes\",'Floating Head Pressure'!J48,\" \")","v":" "}]
[null,"Clean Condenser Coils",null,null,null,null,"No",null," ",null,null,{"$f":"IF(G27=\"Yes\",'Clean Condenser Coils'!I48,\" \")","v":" "}]
[]
[null,null,null,null,null,"Facility Estimated Incentive",null,null,{"$f":"SUM(I13:J27)","v":0}]

{"sheet":"Optimize Economizer Control","index":2,"n_rows":36,"n_cols":7,"rows_kept":36,"cut":false,"hidden":true,"merged":[[4,1,6,9],[9,1,12,9],[15,1,16,2],[15,3,16,9],[27,2,27,9],[26,2,26,9],[20,2,20,9],[21,2,21,9],[22,2,22,9],[23,2,23,9],[24,2,24,9],[25,2,25,9],[17,1,18,2],[17,3,18,9],[35,1,35,5],[31,2,31,9],[33,2,33,9],[28,2,28,9],[29,2,29,9],[30,2,30,9]]}
[]
[null,"Optimize Economizer Control Inputs"]
[]
[null,"Purpose"]
[null,"This tool was developed for the implementation of the MassSave ESPO Program. The measure contained in this tool is the installation of an economizer control to a cooling system. "]
[]
[]
[]
[null,"Measure Description"]
[null,"Optimize Economizer Control - Repair and retune economizers to ensure optimal operations of economizers and associated controls by utilizing free cooling when conditions allow. After tuning, the system controls should continuously monitor both the outside air and return air conditions and control the dampers adjusting the outdoor air flow based on the two readings."]
[]
[]
[]
[]
[null,"Instructions"]
[null,"User Input",null,"Fill in user input cells according to the best available understanding. No cells can be left blank, there are no assumptions that can replace these inputs."]
[]
[null,"Calculated - Affected by inputs",null,"This is a calculation cell that varies with user inputs. It can be used to understand more about when savings occurs."]
[]
[]
[null,"Input","Input Description"]
[null,{"$f":"'Workbook Introduction'!C40","v":0},"Project Electric Utility"]
[null,{"$f":"'Workbook Introduction'!C38","v":0},"MA ZIP Code for project"]
[null,null,"Pre-existing economizer technology (if in non-functioning state select \"No Economizer\")"]
[null,null,"Proposed economizer technology"]
[null,null,"Cooling system type"]
[null,null,"Full load capacity of all impacted cooling coils with enthalpy controls, tons"]
[null,null,"Cooling space (return) air temperature setpoint, °F"]
[null,null,"Cooling space (return) humidity setpoint, %RH (if unknown, set to 50%)"]
[null,null,"Cooling supply air temperature setpoint, °F"]
[null,null,"Outdoor air temperature when heating is enabled, °F"]
[null,null,"Minimum outdoor air %"]
[]
[null,null,"Number of units having their economizer repaired"]
[]
[null,{"$f":"IF(B26=Reference!B24,Reference!I19,IF(B26=Reference!B25,Reference!I19,IF(B26=Reference!B26,Reference!I19,IF(B26=Reference!B27,Reference!I19,Reference!I20))))","v":"Water or Air Cooled Chiller System Economizer Incentive"},null,null,null,null,{"$f":"Reference!O22","v":0}]

{"sheet":"ResetControl(CHW,CW,DAT,Boiler)","index":3,"n_rows":68,"n_cols":13,"rows_kept":68,"cut":false,"hidden":true,"merged":[[62,9,64,11],[67,5,67,6],[25,1,26,2],[25,3,26,9],[5,1,7,9],[10,1,12,9],[13,1,15,9],[16,1,19,9],[20,1,22,9],[62,1,62,6],[65,1,65,6],[64,1,64,6],[63,1,63,6],[27,1,28,2],[27,3,28,9],[62,8,64,8]]}
[]
[null,"Reset Temperatures Inputs"]
[null,"Chilled Water, Condenser Water, Discharge Air Temperature & Boiler Water"]
[]
[null,"Purpose"]
[null,"This tool was developed for the implementation of the MassSave ESPO Program. All of these measures are HVAC controls strategies that optimize energy consumption by using the outdoor air temperature to optimize (reset) control points in the system."]
[]
[]
[]
[null,"Measure Descriptions"]
[null,"Reset Chilled Water (CHW) Temperature - Investigate the chiller system to determine the optimal operation of the controls adjusting the chilled water temperature to increase when outdoor air conditions allow and the building is experiencing a reduced demand for cooling."]
[]
[]
[null,"Reset Condenser Water (CW) Temperature - Investigate the chiller system to determine the minimum allowed temperature of condenser water and, where safe for the chiller, lower the condenser water temperature to allow for more efficient chiller operations."]
[]
[]
[null,"Reset Discharge Air Temperature (DAT) - Adjust discharge air setpoints and ensure optimal operation of the controls enabling modulation of discharge air temperature based on the space temperature. This will minimize the amount of heating and/or cooling needed when the building is operating below peak conditions (weather or occupancy)."]
[]
[]
[]
[null,"Reset Boiler Water Temperature - Repair and retune boiler reset controller to ensure automatic control of boiler water temperature based on outdoor or return water temperature."]
[]
[]
[]
[null,"Instructions"]
[null,"User Input",null,"Fill in user input cells according to the best available understanding. No cells can be left blank, there are no assumptions that can replace these inputs."]
[]
[null,"Calculated - Affected by inputs",null,"This is a calculation cell that varies with user inputs. It can be used to understand more about when savings occurs."]
[]
[]
["Measure Installed?","Measure ","Input Description"]
[null,"Global Inputs (Used for all measures)"]
[null,{"$f":"'Workbook Introduction'!C40","v":0},"Project Electric Utility"]
[null,{"$f":"'Workbook Introduction'!C41","v":0},"Project Natural Gas Utility"]
[null,{"$f":"'Workbook Introduction'!C38","v":0},"Project Zip Code"]
["No","Chilled Water Reset"]
[null,null,"Chiller Capacity, in tons"]
[null,null,"Baseline chilled water temperature, degree F"]
[null,null,"Chilled water temperature reset upper limit, degree F (maximum chilled water temperature allowed by customer)",null,null,null,null,null,null,null,null,null,"Minimum reset must be greater than or equal to 5 deg"]
[null,null,"Chiller lockout outdoor air temperature (below this temperature, the chiller does not run), degree F"]
["No","Condenser Water Reset"]
[null,null,"Chiller Capacity, in tons"]
[null,null,"Condenser water temperature reset lower limit, degree F (minimum condenser water temperature allowed by chiller manufacturer)"]
[null,null,"Chiller lockout outdoor air temperature (below this temperature, the chiller does not run), degree F"]
[null,null,"Existing Leaving Condenser Water Temperature (LCWT). If blank, calculation assumes (Design WBT + 7F)"]
["No","Discharge Air Temperature (DAT) Reset"]
[null,null,"Percent of Heating and Cooling Loads Affected (Estimate using % of total building cfm, or % of total building SQFT, or % of air handlers affected)"]
[null,null,"Chiller Capacity, in tons"]
[null,null,"Boiler Capacity, in MBH"]
[null,null,"Building Balance Point (outdoor temperature at which no heating or cooling is required). If blank, assumes 55F OAT"]
[null,null,"Cooling mode - Baseline discharge air temp"]
[null,null,"Heating mode - Baseline discharge air temp"]
[null,null,"Cooling mode - Discharge Air Temperature upper limit, degree F (maximum DAT allowed by customer)"]
[null,null,"Heating mode - Discharge Air Temperature lower limit, degree F (minimum DAT allower by customer) "]
[null,null,"Minimum outdoor air temperature for chiller operation (below this temperature, there is no need for the chiller to run)"]
[null,null,"Boiler lockout outdoor air temperature (above this temperature, the boiler does not run), degree F",null,null,null,null,null,null,null,null,null,"Cannot be higher than 65Deg F"]
["No","Boiler Reset"]
[null,null,"Boiler Capacity, MBH"]
[null,null,"Boiler Type"]
[null,null,"Boiler lockout temperature (above this temperature, the boiler does not run), degree F",null,null,null,null,null,null,null,null,null,"Cannot be higher than 65Deg F"]
[]
[]
[null,"Chilled Water Reset Incentive",null,null,null,null,null,{"$f":"IF(A36=\"YES\",IF((B39-B38)<5,\"Under Minimum\",100),\"0\")","v":"0"},{"$f":"IF(Reference!O43=3,800,\"\")","v":""},{"$f":"IF(Reference!O43=3,\"Completing these 3 ECM together will result in a bonus of $50 bringing the total to $800\",\"\")","v":""}]
[null,"Condenser Water Reset Incentive",null,null,null,null,null,{"$f":"IF(A41=\"YES\",IF((B45-B43)<1,\"Under Minimum\",600),\"0\")","v":"0"}]
[null,"Discharge Air Temperature Reset Incentive",null,null,null,null,null,{"$f":"IF(A46=\"YES\",IF(B56>65,\"65 Deg F is Maximum Allowed\",50),\"0\")","v":"0"}]
[null,"Boiler Reset Incentive",null,null,null,null,null,{"$f":"IF(A57=\"YES\",IF(B60>65,\"65 Deg F is Maximum Allowed\",300),\"0\")","v":"0"}]
[]
[null,null,null,null,null,"Total Incentive",null,{"$f":"IF(750=SUM(H63:H65),(I63+H66),(SUM(H63:H66)))","v":0}]

{"sheet":"System Scheduling","index":4,"n_rows":66,"n_cols":28,"rows_kept":66,"cut":false,"hidden":true,"merged":[[34,0,34,18],[27,0,27,18],[24,8,24,12],[24,13,24,17],[25,16,25,17],[25,9,25,10],[25,11,25,12],[25,14,25,15],[58,1,58,2],[57,1,57,2],[55,1,55,2],[56,1,56,2],[51,0,51,17],[63,1,63,2],[62,1,62,2],[61,1,61,2],[60,1,60,2],[59,1,59,2],[4,1,5,9],[8,1,10,9],[11,1,13,9],[16,1,17,2],[16,3,17,9],[22,0,22,18],[23,0,23,18],[25,0,25,1],[24,0,24,1],[18,1,19,2],[18,3,19,9]]}
[]
[null,"Adjust Pump & System Schedules Inputs"]
[]
[null,"Purpose"]
[null,"This tool was developed for the implementation of the ESPO Program. All of these measures are HVAC controls strategies that optimize energy consumption by reducing the number of hours a given piece of equipment is operating. This is done by stipulating equipment schedules that reduce run hours."]
[]
[]
[null,"Measure Descriptions"]
[null,"Adjust Pump Schedules - Adjust scheduling on the pumps of heating and cooling systems to align the operational hours with the occupancy of the space they serve. "]
[]
[]
[null,"Check System Schedules - Adjust scheduling on HVAC systems such as cooling tower fans, rooftop units, air handler fans, exhaust fans and electric resistance heating to align the operational hours with the occupancy of the space they serve."]
[]
[]
[]
[null,"Instructions"]
[null,"User Input",null,"Fill in user input cells according to the best available understanding. No cells can be left blank, there are no assumptions that can replace these inputs."]
[]
[null,"Calculated - Affected by inputs",null,"This is a calculation cell that varies with user inputs. It can be used to understand more about when savings occurs."]
[]
[]
["User Inputs"]
["Instructions: For each equipment type affected by the schedule updates, fill in all orange cells. If there are equipment of multiple sizes affected, use a new line for each one (e.g., one line for 30 hp AHU fans, and a separate line for 20 hp AHU fans)"]
["DO NOT insert rows or columns into the sheet. Create a copy of the tab if you exceed the below equipment counts. Note the Summary Sheet may not properly summerize incentives in this case."]
["Building Type",null,null,null,null,null,null,null,"Before RCx",null,null,null,null,"After RCx",null,null,null,null,"Savings"]
["Building Baseline Energy Consumption (kWh/yr)",null,null,null,null,null,null,null,"Weeks","Weekday",null,"Weekend",null,"Weeks","Weekday",null,"Weekend"]
["Load Type","Load Type Note","Updated Scheduling affects this equipment?","Quantity","Capacity per Unit (HP)","Heater Capacity (kW)","Is motor VFD-driven?","Unit Flow (CFM or GPM)","Weeks/year","Hour Starting","Hour Ending","Hour Starting","Hour Ending","Weeks/year","Hour Starting","Hour Ending","Hour Starting","Hour Ending","Annual Hours"]
["Pump Schedules"]
["Pumps in Cooling System","Examples: chilled water pumps, condenser water pumps, cooling tower spray pumps",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($C29=\"Yes\",IF(OR(ISBLANK($D29),ISBLANK($E29),ISBLANK($G29),ISBLANK($H29),ISBLANK($I29),ISBLANK($J29),ISBLANK($K29),ISBLANK($L29),ISBLANK($M29),ISBLANK($N29),ISBLANK($O29),ISBLANK($P29),ISBLANK($Q29),ISBLANK($R29)),\"Fill all inputs\",'System Scheduling Calculations'!D61),0)","v":0},{"$f":"IF(S29=\"fill all inputs\",1,\"\")","v":""},null,null,null,null,null,null,{"$f":"S29/364","v":0},{"$f":"E29*AA29*14*D29","v":0}]
["Pumps in Cooling System, line 2","Examples: chilled water pumps, condenser water pumps, cooling tower spray pumps",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($C30=\"Yes\",IF(OR(ISBLANK($D30),ISBLANK($E30),ISBLANK($G30),ISBLANK($H30),ISBLANK($I30),ISBLANK($J30),ISBLANK($K30),ISBLANK($L30),ISBLANK($M30),ISBLANK($N30),ISBLANK($O30),ISBLANK($P30),ISBLANK($Q30),ISBLANK($R30)),\"Fill all inputs\",'System Scheduling Calculations'!D62),0)","v":0},"",null,null,null,null,null,null,{"$f":"S30/364","v":0},0]
["Pumps in Cooling System, line 3","Examples: chilled water pumps, condenser water pumps, cooling tower spray pumps",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($C31=\"Yes\",IF(OR(ISBLANK($D31),ISBLANK($E31),ISBLANK($G31),ISBLANK($H31),ISBLANK($I31),ISBLANK($J31),ISBLANK($K31),ISBLANK($L31),ISBLANK($M31),ISBLANK($N31),ISBLANK($O31),ISBLANK($P31),ISBLANK($Q31),ISBLANK($R31)),\"Fill all inputs\",'System Scheduling Calculations'!D63),0)","v":0},"",null,null,null,null,null,null,0,0]
["Pumps in Heating System","Examples: hot water pumps, condensate return pumps, feedwater pumps",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($C32=\"Yes\",IF(OR(ISBLANK($D32),ISBLANK($E32),ISBLANK($G32),ISBLANK($H32),ISBLANK($I32),ISBLANK($J32),ISBLANK($K32),ISBLANK($L32),ISBLANK($M32),ISBLANK($N32),ISBLANK($O32),ISBLANK($P32),ISBLANK($Q32),ISBLANK($R32)),\"Fill all inputs\",'System Scheduling Calculations'!D64),0)","v":0},"",null,null,null,null,null,null,0,0]
["Pumps in Heating System, line 2","Examples: hot water pumps, condensate return pumps, feedwater pumps",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($C33=\"Yes\",IF(OR(ISBLANK($D33),ISBLANK($E33),ISBLANK($G33),ISBLANK($H33),ISBLANK($I33),ISBLANK($J33),ISBLANK($K33),ISBLANK($L33),ISBLANK($M33),ISBLANK($N33),ISBLANK($O33),ISBLANK($P33),ISBLANK($Q33),ISBLANK($R33)),\"Fill all inputs\",'System Scheduling Calculations'!D65),0)","v":0},"",null,null,null,null,null,null,0,0]
["Pumps in Heating System, line 3","Examples: hot water pumps, condensate return pumps, feedwater pumps",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($C34=\"Yes\",IF(OR(ISBLANK($D34),ISBLANK($E34),ISBLANK($G34),ISBLANK($H34),ISBLANK($I34),ISBLANK($J34),ISBLANK($K34),ISBLANK($L34),ISBLANK($M34),ISBLANK($N34),ISBLANK($O34),ISBLANK($P34),ISBLANK($Q34),ISBLANK($R34)),\"Fill all inputs\",'System Scheduling Calculations'!D66),0)","v":0},"",null,null,null,null,null,null,0,0]
["Other HVAC System Schedules"]
["Cooling Tower Fans","Examples: cooling tower fans, water-cooled condensers",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($C36=\"Yes\",IF(OR(ISBLANK($D36),ISBLANK($E36),ISBLANK($G36),ISBLANK($H36),ISBLANK($I36),ISBLANK($J36),ISBLANK($K36),ISBLANK($L36),ISBLANK($M36),ISBLANK($N36),ISBLANK($O36),ISBLANK($P36),ISBLANK($Q36),ISBLANK($R36)),\"Fill all inputs\",'System Scheduling Calculations'!D67),0)","v":0},{"$f":"IF(S36=\"fill all inputs\",1,\"\")","v":""},null,null,null,null,null,null,0,{"$f":"E36*AA36*30*D36","v":0}]
["Cooling Tower Fans, line 2","Examples: cooling tower fans, water-cooled condensers",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($C37=\"Yes\",IF(OR(ISBLANK($D37),ISBLANK($E37),ISBLANK($G37),ISBLANK($H37),ISBLANK($I37),ISBLANK($J37),ISBLANK($K37),ISBLANK($L37),ISBLANK($M37),ISBLANK($N37),ISBLANK($O37),ISBLANK($P37),ISBLANK($Q37),ISBLANK($R37)),\"Fill all inputs\",'System Scheduling Calculations'!D68),0)","v":0},"",null,null,null,null,null,null,0,0]
["Cooling Tower Fans, line 3","Examples: cooling tower fans, water-cooled condensers",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($C38=\"Yes\",IF(OR(ISBLANK($D38),ISBLANK($E38),ISBLANK($G38),ISBLANK($H38),ISBLANK($I38),ISBLANK($J38),ISBLANK($K38),ISBLANK($L38),ISBLANK($M38),ISBLANK($N38),ISBLANK($O38),ISBLANK($P38),ISBLANK($Q38),ISBLANK($R38)),\"Fill all inputs\",'System Scheduling Calculations'!D69),0)","v":0},"",null,null,null,null,null,null,0,0]
["Cooling Tower Fans, line 4","Examples: cooling tower fans, water-cooled condensers",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($C39=\"Yes\",IF(OR(ISBLANK($D39),ISBLANK($E39),ISBLANK($G39),ISBLANK($H39),ISBLANK($I39),ISBLANK($J39),ISBLANK($K39),ISBLANK($L39),ISBLANK($M39),ISBLANK($N39),ISBLANK($O39),ISBLANK($P39),ISBLANK($Q39),ISBLANK($R39)),\"Fill all inputs\",'System Scheduling Calculations'!D70),0)","v":0},"",null,null,null,null,null,null,0,0]
["Rooftop Units","Examples: Rooftop Units (RTUs), packaged heating and cooling units",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($C40=\"Yes\",IF(OR(ISBLANK($D40),ISBLANK($E40),ISBLANK($G40),ISBLANK($H40),ISBLANK($I40),ISBLANK($J40),ISBLANK($K40),ISBLANK($L40),ISBLANK($M40),ISBLANK($N40),ISBLANK($O40),ISBLANK($P40),ISBLANK($Q40),ISBLANK($R40)),\"Fill all inputs\",'System Scheduling Calculations'!D71),0)","v":0},"",null,null,null,null,null,null,0,0]
["Rooftop Units, line 2","Examples: Rooftop Units (RTUs), packaged heating and cooling units",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($C41=\"Yes\",IF(OR(ISBLANK($D41),ISBLANK($E41),ISBLANK($G41),ISBLANK($H41),ISBLANK($I41),ISBLANK($J41),ISBLANK($K41),ISBLANK($L41),ISBLANK($M41),ISBLANK($N41),ISBLANK($O41),ISBLANK($P41),ISBLANK($Q41),ISBLANK($R41)),\"Fill all inputs\",'System Scheduling Calculations'!D72),0)","v":0},"",null,null,null,null,null,null,0,0]
["Rooftop Units, line 3","Examples: Rooftop Units (RTUs), packaged heating and cooling units",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($C42=\"Yes\",IF(OR(ISBLANK($D42),ISBLANK($E42),ISBLANK($G42),ISBLANK($H42),ISBLANK($I42),ISBLANK($J42),ISBLANK($K42),ISBLANK($L42),ISBLANK($M42),ISBLANK($N42),ISBLANK($O42),ISBLANK($P42),ISBLANK($Q42),ISBLANK($R42)),\"Fill all inputs\",'System Scheduling Calculations'!D73),0)","v":0},"",null,null,null,null,null,null,0,0]
["Rooftop Units, line 4","Examples: Rooftop Units (RTUs), packaged heating and cooling units",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($C43=\"Yes\",IF(OR(ISBLANK($D43),ISBLANK($E43),ISBLANK($G43),ISBLANK($H43),ISBLANK($I43),ISBLANK($J43),ISBLANK($K43),ISBLANK($L43),ISBLANK($M43),ISBLANK($N43),ISBLANK($O43),ISBLANK($P43),ISBLANK($Q43),ISBLANK($R43)),\"Fill all inputs\",'System Scheduling Calculations'!D74),0)","v":0},"",null,null,null,null,null,null,0,0]
["Air Handler Fans and Exhaust Fans","Examples: Multi-zone air handler, single-zone air handler, make-up air fan, kitchen exhaust fan",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($C44=\"Yes\",IF(OR(ISBLANK($D44),ISBLANK($E44),ISBLANK($G44),ISBLANK($H44),ISBLANK($I44),ISBLANK($J44),ISBLANK($K44),ISBLANK($L44),ISBLANK($M44),ISBLANK($N44),ISBLANK($O44),ISBLANK($P44),ISBLANK($Q44),ISBLANK($R44)),\"Fill all inputs\",'System Scheduling Calculations'!D75),0)","v":0},"",null,null,null,null,null,null,0,0]
["Air Handler Fans and Exhaust Fans, line 2","Examples: Multi-zone air handler, single-zone air handler, make-up air fan, kitchen exhaust fan",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($C45=\"Yes\",IF(OR(ISBLANK($D45),ISBLANK($E45),ISBLANK($G45),ISBLANK($H45),ISBLANK($I45),ISBLANK($J45),ISBLANK($K45),ISBLANK($L45),ISBLANK($M45),ISBLANK($N45),ISBLANK($O45),ISBLANK($P45),ISBLANK($Q45),ISBLANK($R45)),\"Fill all inputs\",'System Scheduling Calculations'!D76),0)","v":0},"",null,null,null,null,null,null,0,0]
["Air Handler Fans and Exhaust Fans, line 3","Examples: Multi-zone air handler, single-zone air handler, make-up air fan, kitchen exhaust fan",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($C46=\"Yes\",IF(OR(ISBLANK($D46),ISBLANK($E46),ISBLANK($G46),ISBLANK($H46),ISBLANK($I46),ISBLANK($J46),ISBLANK($K46),ISBLANK($L46),ISBLANK($M46),ISBLANK($N46),ISBLANK($O46),ISBLANK($P46),ISBLANK($Q46),ISBLANK($R46)),\"Fill all inputs\",'System Scheduling Calculations'!D77),0)","v":0},"",null,null,null,null,null,null,0,0]
["Air Handler Fans and Exhaust Fans, line 4","Examples: Multi-zone air handler, single-zone air handler, make-up air fan, kitchen exhaust fan",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($C47=\"Yes\",IF(OR(ISBLANK($D47),ISBLANK($E47),ISBLANK($G47),ISBLANK($H47),ISBLANK($I47),ISBLANK($J47),ISBLANK($K47),ISBLANK($L47),ISBLANK($M47),ISBLANK($N47),ISBLANK($O47),ISBLANK($P47),ISBLANK($Q47),ISBLANK($R47)),\"Fill all inputs\",'System Scheduling Calculations'!D78),0)","v":0},"",null,null,null,null,null,null,0,0]
["Electric Resistance Heating","Examples: Baseboard electric heat, freeze protection resistance heaters",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($C48=\"Yes\",IF(OR(ISBLANK($D48),ISBLANK($F48),ISBLANK($I48),ISBLANK($J48),ISBLANK($K48),ISBLANK($L48),ISBLANK($M48),ISBLANK($N48),ISBLANK($O48),ISBLANK($P48),ISBLANK($Q48),ISBLANK($R48)),\"Fill all inputs\",'System Scheduling Calculations'!D79),0)","v":0},"",null,null,null,null,null,null,0,{"$f":"F48*AA48*25*D48","v":0}]
["Other","(Please Describe)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($C49=\"Yes\",IF(OR(ISBLANK(D$49),ISBLANK($E49),ISBLANK($G49),ISBLANK($I49),ISBLANK($J49),ISBLANK($K49),ISBLANK($L49),ISBLANK($M49),ISBLANK($N49),ISBLANK($O49),ISBLANK($P49),ISBLANK($Q49),ISBLANK($R49)),\"Fill all inputs\",'System Scheduling Calculations'!D80),0)","v":0},"",null,null,null,null,null,null,0,{"$f":"E49*AA49*25*D49","v":0}]
["Other 2","(Please Describe)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($C50=\"Yes\",IF(OR(ISBLANK(D$49),ISBLANK($E50),ISBLANK($G50),ISBLANK($I50),ISBLANK($J50),ISBLANK($K50),ISBLANK($L50),ISBLANK($M50),ISBLANK($N50),ISBLANK($O50),ISBLANK($P50),ISBLANK($Q50),ISBLANK($R50)),\"Fill all inputs\",'System Scheduling Calculations'!D81),0)","v":0},"",null,null,null,null,null,null,0,{"$f":"E50*AA50*25*D50","v":0}]
["Other 3","(Please Describe)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($C51=\"Yes\",IF(OR(ISBLANK(D$49),ISBLANK($E51),ISBLANK($G51),ISBLANK($I51),ISBLANK($J51),ISBLANK($K51),ISBLANK($L51),ISBLANK($M51),ISBLANK($N51),ISBLANK($O51),ISBLANK($P51),ISBLANK($Q51),ISBLANK($R51)),\"Fill all inputs\",'System Scheduling Calculations'!D82),0)","v":0},"",null,null,null,null,null,null,0,{"$f":"E51*AA51*25*D51","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[]
[null,"Pumps in Cooling System Scheduling Incentive",null,{"$f":"IF(SUM(AB29:AB31)>0,SUM(AB29:AB31),\"\")","v":""}]
[null,"Pumps in Heating System Scheduling Incentive",null,{"$f":"IF(SUM(AB32:AB34)>0,SUM(AB32:AB34),\"\")","v":""}]
[null,"Cooling Tower Fans Scheduling Incentive",null,{"$f":"IF(SUM(AB36:AB39)>0,SUM(AB36:AB39),\"\")","v":""}]
[null,"Rooftop Units Scheduling Incentive",null,{"$f":"IF(SUM(AB40:AB43)>0,SUM(AB40:AB43),\"\")","v":""}]
[null,"Air Handler Fans and Exhaust Fans Scheduling Incentive",null,{"$f":"IF(SUM(AB44:AB47)>0,SUM(AB44:AB47),\"\")","v":""}]
[null,"Electric Resistance Heating Scheduling Incentive",null,{"$f":"IF(SUM(AB48)>0,SUM(AB48),\"\")","v":""}]
[null,"Other Scheduling Incentive",null,{"$f":"IF(SUM(AB49)>0,SUM(AB49),\"\")","v":""}]
[null,"Other 2  Scheduling Incentive",null,{"$f":"IF(SUM(AB50)>0,SUM(AB50),\"\")","v":""}]
[null,"Other 3  Scheduling Incentive",null,{"$f":"IF(SUM(AB51)>0,SUM(AB51),\"\")","v":""}]
[]
[null,null,"Total Incentive",{"$f":"SUM(D56:D64)","v":0}]

{"sheet":"RTU Coil Cleaning","index":5,"n_rows":44,"n_cols":7,"rows_kept":44,"cut":false,"hidden":true,"merged":[[8,1,11,11],[3,1,3,11],[4,1,5,11],[43,6,43,11],[19,3,20,11],[21,3,22,11],[18,1,18,11],[21,1,22,2],[43,1,43,5],[7,1,7,11],[19,1,20,2],[26,2,26,11],[27,2,27,11],[31,2,31,11],[32,2,32,11],[35,2,35,11],[13,2,13,11],[14,2,14,11],[15,2,15,11],[16,2,16,11],[33,2,33,11],[28,2,28,11],[29,2,29,11],[30,2,30,11],[24,2,24,11],[25,2,25,11],[34,2,34,11],[39,2,39,11],[40,2,40,11],[41,2,41,11],[38,2,38,11],[36,2,36,11]]}
[]
[null,"Clean RTU Coils"]
[]
[null,"Purpose"]
[null,"This tool was developed for the implementation of the MassSave ESPO Program. This measure involves the cleaning of a packaged (DX) RTU's evaporator and condensing coils to increase comfort cooling system efficiency."]
[]
[]
[null,"Measure Description"]
[null,"RTU Coil Cleaning - Clean the evaporator and condenser coils of a Direct Expansion (DX) Rooftop Unit (RTU) in order to improve heat transfer. Use an approved cleaning solution and remove any debris obstructing airflow. The maximum unit size covered by this prescriptive offer is 150 tons cooling capacity. The coils must show improved condition in order to qualify. A before and after photo of each coil will be required as part of the submission."]
[]
[]
[]
[]
[null,"Coil Condition","Description"]
[null,"Poor","Substantial coil fouling and visible dirt on all sides of coils"]
[null,"Fair","Semi dirty coils and some fouling on backside of coil "]
[null,"Good","Clean and minimal signs of fouling"]
[]
[null,"Instructions"]
[null,"User Input",null,"Fill in user input cells according to the best available understanding. No cells can be left blank, there are no assumptions that can replace these inputs."]
[]
[null,"Calculated - Affected by inputs",null,"This is a calculation cell that varies with user inputs. It can be used to understand more about when savings occurs."]
[]
[]
[null,"Input","Input Description"]
[null,{"$f":"'Workbook Introduction'!C40","v":0},"Project Electric Utility"]
[null,{"$f":"'Workbook Introduction'!C38","v":0},"MA ZIP Code for project"]
[null,null,"Economizer Technology"]
[null,null,"Packaged Roof Top Unit Efficiency (EER)"]
[null,null,"Packaged Roof Top Unit Full Load Capacity (Tons)"]
[null,null,"Cooling space (return) air temperature setpoint, °F"]
[null,null,"Cooling space (return) humidity setpoint, %RH (if unknown, set to 50%)"]
[null,null,"Cooling supply air temperature setpoint, °F"]
[null,null,"Outdoor air temperature when heating is enabled, °F"]
[null,null,"Minimum outdoor air %"]
[null,null,"Condenser Coil Baseline Condition"]
[null,null,"Evaporator Coil Baseline Condition"]
[]
[null,"Input","Operating Schedule"]
[null,null,"Weekday - Number of Shifts (8 hours per shift)"]
[null,null,"Saturday - Number of Shifts (8 hours per shift)"]
[null,null,"Sunday - Number of Shifts (8 hours per shift)"]
[]
[null,"RTU Coil Cleaning Incentive",null,null,null,null,{"$f":"B30*5","v":0}]

{"sheet":"Steam Trap Repair","index":6,"n_rows":28,"n_cols":7,"rows_kept":28,"cut":false,"hidden":true,"merged":[[27,1,27,2],[17,1,18,2],[17,3,18,7],[20,1,20,2],[20,4,20,6],[21,1,21,2],[22,4,22,6],[4,1,5,7],[8,1,10,7],[13,1,14,2],[13,3,14,7],[15,1,16,2],[15,3,16,7]]}
[]
[null,"Steam Trap Repair Inputs"]
[]
[null,"Purpose"]
[null,"This tool was developed for the implementation of the MassSave ESPO Program. The measure contained in this tool is the replacement of mechanical steam traps in a steam distribution system."]
[]
[]
[null,"Measure Description"]
[null,"Steam Trap Repair - Repair failed steam traps to ensure proper system operation. According to the US Department of Energy, a steam system that has not been maintained for 3-5 years will experience up to a 30% failure rate on steam traps which can drastically decrease system efficiency. "]
[]
[]
[]
[null,"Instructions"]
[null,"User Input",null,"Fill in user input cells according to the best available understanding. No cells can be left blank, there are no assumptions that can replace these inputs."]
[]
[null,"Optional user input",null,"These optional user inputs may be used to provide greater accuracy for savings. If they are left blank, default values will be used."]
[]
[null,"Calculated - Affected by inputs",null,"This is a calculation cell that varies with user inputs. It can be used to understand more about when savings occurs."]
[]
[]
[null,"User Inputs",null,null,"To convert Boiler Hp to Mbtu/hr please input Boiler Hp below"]
[null,"Required",null,null,"Boiler capacity (BHp)"]
[null,"Boiler capacity (MBtu/hr)",null,null,"Please input the calculated value below into the Boiler capacity (Mbtu/hr)"]
[null,"Baseline setpoint pressure (psig)",null,null,"Converted From BHp to Mbtu/hr",{"$f":"F22*33.475","v":0}]
[null,"Number of Steam Traps being replaced"]
[]
[]
[null,"Steam Trap Replacement Incentive",null,{"$f":"IF(C25=\"\",\"N/A\",(C25*50))","v":"N/A"},null,null,50]

{"sheet":"Reduce Steam Pressure","index":7,"n_rows":38,"n_cols":7,"rows_kept":38,"cut":false,"hidden":true,"merged":[[19,1,20,2],[19,3,20,7],[4,1,6,7],[9,1,12,7],[15,1,16,2],[15,3,16,7],[17,1,18,2],[17,3,18,7],[37,1,37,2],[23,1,23,2],[27,1,27,2],[22,1,22,2],[24,4,24,6],[22,4,22,6]]}
[]
[null,"Reduce Steam Boiler Pressure Inputs"]
[]
[null,"Purpose"]
[null,"This tool was developed for the implementation of the MassSave ESPO Program. The measure contained in this tool is the reduction of system operating pressure in a boiler system."]
[]
[]
[]
[null,"Measure Description"]
[null,"Reduce Steam Pressure - Lower continuous operating steam boiler pressure to increase boiler efficiency. Ensure that minimum pressure needs are met for equipment utilizing steam supply before lowering the pressure of the boiler. For best results with boiler pressure reduction, ensure that steam traps are working properly and regularly checked, pipe insulation is installed and in good condition, and that steam leaks are repaired."]
[]
[]
[]
[]
[null,"Instructions"]
[null,"User Input",null,"Fill in user input cells according to the best available understanding. No cells can be left blank, there are no assumptions that can replace these inputs."]
[]
[null,"Optional user input",null,"These optional user inputs may be used to provide greater accuracy for savings. If they are left blank, default values will be used."]
[]
[null,"Calculated - Affected by inputs",null,"This is a calculation cell that varies with user inputs. It can be used to understand more about when savings occurs."]
[]
[]
[null,"User Inputs",null,null,"To convert Boiler Hp to Mbtu/hr please input Boiler Hp below"]
[null,"Required",null,null,"Boiler capacity (BHp)"]
[null,"Boiler capacity (MBtu/hr)",null,null,"Please input the calculated value below into the Boiler capacity (Mbtu/hr)"]
[null,"Baseline setpoint pressure (psig)",null,null,"Converted From BHp to Mbtu/hr",{"$f":"F24*33.475","v":0}]
[null,"Proposed setpoint pressure (psig)"]
[null,"Optional"]
[null,"Boiler EFLH (hr/yr)"]
[null,"Steam production (lb/hr)"]
[null,"Makeup water flow rate (gpm)"]
[null,"Condensate flow rate (gpm)"]
[null,"Condensate pressure (psig)"]
[null,"Boiler efficiency (%)"]
[null,"Makeup water temperature (F)"]
[]
[]
[null,"Reduce Steam Pressure Incentive",null,{"$f":"IF(C26=\"\",\"N/A\",(C26-C27)*100)","v":"N/A"},null,null,50]

{"sheet":"Comp. Air Leaks and Pressure","index":8,"n_rows":92,"n_cols":8,"rows_kept":92,"cut":false,"hidden":true,"merged":[[3,1,3,7],[7,1,7,7],[88,1,88,2],[89,1,89,2],[21,4,23,6],[4,1,5,7],[8,1,9,7],[10,1,11,7],[14,1,15,2],[14,3,15,7],[16,1,17,2],[16,3,17,7],[13,1,13,7],[18,1,19,2],[18,3,19,7]]}
[]
[null,"Compressed Air Leaks and Pressure Reduction Measures"]
[]
[null,"Purpose"]
[null,"This tool was developed for the implementation of the MassSave ESPO Program. All of these measures are compressed air system energy effiency measures."]
[]
[]
[null,"Measure Descriptions"]
[null,"Reduce Supply Side Compressed Air Pressure - Investigate the compressed air system and the equipment it serves to lower the supply side pressure to the minimum necessary level to decrease compressor run time."]
[]
[null,"Repair Compressed Air Leaks - Complete a leak assessment to identify all compressed air leaks throughout the system and repair each to increase system efficiency."]
[]
[]
[null,"Instructions"]
[null,"User Input",null,"Fill in user input cells according to the best available understanding. Because these are site-specific values, there are no assumptions that can replace these inputs.\n\nNote: Some user input cells are not required for all measures. These are noted in the \"Relevant measures\" field."]
[]
[null,"Assumption",null,"This is an assumption made by technical staff. They are not intended to be overridden. "]
[]
[null,"Calculated - Affected by inputs",null,"This is a calculation cell that varies with user inputs. It can be used to understand more about when savings occurs."]
[]
[]
[null,"Operating Schedule","User input","Relevant measures"]
[null,"Weeks per Year of Operation (wk/yr)",null,"All"]
[null,"Weekday - Number of 8 hour Shifts",null,"All"]
[null,"Saturday - Number of 8 Hour Shifts",null,"All"]
[null,"Sunday - Number of 8 hour Shifts",null,"All"]
[null,"Measure Information","User input","Default value","Relevant measures"]
[null,"Existing number of compressors",null,{"$f":"IF(C28=\"\",\"User input requred!\", C28)","v":"User input requred!"},"All"]
[null,"Existing number of dryers",null,{"$f":"IF(C29=\"\",\"User input requred!\", C29)","v":"User input requred!"},"All"]
[null,"Existing compressor air setpoint (psig)",null,{"$f":"IF(C30=\"\",120,C30)","v":120},"Reduce Supply Side Pressure"]
[null,"Proposed compressor air setpoint (psig)",null,{"$f":"IF(C31=\"\",D30,C31)","v":120},"Reduce Supply Side Pressure"]
[null,"Quantity of existing air leaks",null,{"$f":"IF(C32=\"\",0,C32)","v":0},"Repair Leaks"]
[null,"Existing air leaks (cfm)",null,{"$f":"IF(C33=\"\",0,C33)","v":0},"Repair Leaks"]
[null,"Proposed air leaks (cfm)",null,{"$f":"IF(C34=\"\",D33*0.5,C34)","v":0},"Repair Leaks"]
[null,"Existing Individual Compressor Information","User input","Default value","Relevant measures"]
[null,"Compressor #1 Type",null,{"$f":"IF($D$28<1,\"\",IF(C36=\"\",\"User input required!\",C36))","v":"User input required!"},"All"]
[null,"Compressor #1 ref #",null,{"$f":"IF(ISNA(VLOOKUP(D36,Reference!$C$91:$D$102,2,0)),\"\",VLOOKUP(D36,Reference!$C$91:$D$102,2,0))","v":""},"All"]
[null,"Average compressor kW/CFM =",null,{"$f":"IF(ISERROR(INDEX(Reference!$H$92:$S$103,MATCH(ROUND(G74,1),Reference!$G$92:$G$103,0),D37)),\"\",INDEX(Reference!$H$92:$S$103,MATCH(ROUND(G74,1),Reference!$G$92:$G$103,0),D37))","v":""},"All"]
[null,"Compressor #1 HP",null,{"$f":"IF(C39=\"\",\"User input required!\",C39)","v":"User input required!"},"All"]
[null,"Full Load CFM",null,{"$f":"IF(OR(D39=0,D39=\"User input required!\"),0,D39*4.2)","v":0},"All"]
[null,"Is this compressor a back up unit"]
[null,"Compressor #2 Type",null,{"$f":"IF($D$28<1,\"\",IF(C42=\"\",\"User input required!\",C42))","v":"User input required!"},"All"]
[null,"Compressor #2 ref #",null,{"$f":"IF(ISNA(VLOOKUP(D42,Reference!$C$91:$D$102,2,0)),\"\",VLOOKUP(D42,Reference!$C$91:$D$102,2,0))","v":""},"All"]
[null,"Average compressor kW/CFM =",null,{"$f":"IF(ISERROR(INDEX(Reference!$H$92:$S$103,MATCH(ROUND(G79,1),Reference!$G$92:$G$103,0),D43)),\"\",INDEX(Reference!$H$92:$S$103,MATCH(ROUND(G79,1),Reference!$G$92:$G$103,0),D43))","v":""},"All"]
[null,"Compressor #2 HP",null,{"$f":"IF(C45=\"\",\"User input required!\",C45)","v":"User input required!"},"All"]
[null,"Full Load CFM",null,{"$f":"IF(OR(D45=0,D45=\"User input required!\"),0,D45*4.2)","v":0},"All"]
[null,"Is this compressor a back up unit"]
[null,"Compressor #3 Type",null,{"$f":"IF($D$28<1,\"\",IF(C48=\"\",\"User input required!\",C48))","v":"User input required!"},"All"]
[null,"Compressor #3 ref #",null,{"$f":"IF(ISNA(VLOOKUP(D48,Reference!$C$91:$D$102,2,0)),\"\",VLOOKUP(D48,Reference!$C$91:$D$102,2,0))","v":""},"All"]
[null,"Average compressor kW/CFM =",null,{"$f":"IF(ISERROR(INDEX(Reference!$H$92:$S$103,MATCH(ROUND(G84,1),Reference!$G$92:$G$103,0),D49)),\"\",INDEX(Reference!$H$92:$S$103,MATCH(ROUND(G84,1),Reference!$G$92:$G$103,0),D49))","v":""},"All"]
[null,"Compressor #3 HP",null,{"$f":"IF(C51=\"\",\"User input required!\",C51)","v":"User input required!"},"All"]
[null,"Full Load CFM",null,{"$f":"IF(OR(D51=0,D51=\"User input required!\"),0,D51*4.2)","v":0},"All"]
[null,"Is this compressor a back up unit"]
[null,"Compressor #4 Type",null,{"$f":"IF($D$28<1,\"\",IF(C54=\"\",\"User input required!\",C54))","v":"User input required!"},"All"]
[null,"Compressor #4 ref #",null,{"$f":"IF(ISNA(VLOOKUP(D54,Reference!$C$91:$D$102,2,0)),\"\",VLOOKUP(D54,Reference!$C$91:$D$102,2,0))","v":""},"All"]
[null,"Average compressor kW/CFM =",null,{"$f":"IF(ISERROR(INDEX(Reference!$H$92:$S$103,MATCH(ROUND(G89,1),Reference!$G$92:$G$103,0),D55)),\"\",INDEX(Reference!$H$92:$S$103,MATCH(ROUND(G89,1),Reference!$G$92:$G$103,0),D55))","v":""},"All"]
[null,"Compressor #4 HP",null,{"$f":"IF(C57=\"\",\"User input required!\",C57)","v":"User input required!"},"All"]
[null,"Full Load CFM",null,{"$f":"IF(OR(D57=0,D57=\"User input required!\"),0,D57*4.2)","v":0},"All"]
[null,"Is this compressor a back up unit"]
[null,"Existing Dryer Information","User input","Default value","Relevant measures"]
[null,"Dryer #1 Type",null,{"$f":"IF(C61=\"\",\"Refrigerated\",C61)","v":"Refrigerated"},"All"]
[null,"Dryer #1 ref #",null,{"$f":"VLOOKUP(D61,Reference!$C$107:$D$112,2,0)","v":1},"All"]
[null,"Dryer #1 Rated CFM",null,{"$f":"IF(AND($D$29>=1,C63=\"\"),\"User input required!\",C63)","v":"User input required!"},"All"]
[null,"Dryer #2 Type",null,{"$f":"IF(C64=\"\",\"Refrigerated\",C64)","v":"Refrigerated"},"All"]
[null,"Dryer #2 ref #",null,{"$f":"VLOOKUP(D64,Reference!$C$107:$D$112,2,0)","v":1},"All"]
[null,"Dryer #2 Rated CFM",null,{"$f":"IF(AND($D$29>=2,C66=\"\"),\"User input required!\",C66)","v":"User input required!"},"All"]
[null,"Dryer #3 Type",null,{"$f":"IF(C67=\"\",\"Refrigerated\",C67)","v":"Refrigerated"},"All"]
[null,"Dryer #3 ref #",null,{"$f":"VLOOKUP(D67,Reference!$C$107:$D$112,2,0)","v":1},"All"]
[null,"Dryer #3 Rated CFM",null,{"$f":"IF(AND($D$29>=2,C69=\"\"),\"User input required!\",C69)","v":"User input required!"},"All"]
[null,"Compressor weekly loading","Shift #","Weekday","Saturday","Sunday","Overall","Relevant measures"]
[null,"Compressor #1 Percent Load - First Shift (%)",1,null,null,null,{"$f":"IF(SUM(D71:F71)=0,0,(D71*5+E71+F71)/(IF(D71>0,5,0)+IF(E71>0,1,0)+IF(F71>0,1,0)))","v":0},"All"]
[null,"Compressor #1 Percent Load - Second Shift (%)",2,null,null,null,0,"All"]
[null,"Compressor #1 Percent Load - Third Shift (%)",3,null,null,null,0,"All"]
[null,"Average (%)","avg",{"$f":"IF(SUM(D71:D73)=0,0,AVERAGEIF(D71:D73,\">0\"))","v":0},{"$f":"IF(SUM(E71:E73)=0,0,AVERAGEIF(E71:E73,\">0\"))","v":0},{"$f":"IF(SUM(F71:F73)=0,0,AVERAGEIF(F71:F73,\">0\"))","v":0},{"$f":"IF(SUM(D74:F74)=0,0,(D74*5+E74+F74)/(IF(D74>0,5,0)+IF(E74>0,1,0)+IF(F74>0,1,0)))","v":0},"All"]
[null,"Compressor #2 Percent Load - First Shift (%)",1,null,null,null,0,"All"]
[null,"Compressor #2 Percent Load - Second Shift (%)",2,null,null,null,0,"All"]
[null,"Compressor #2 Percent Load - Third Shift (%)",3,null,null,null,0,"All"]
[null,"Average (%)","avg",{"$f":"IF(SUM(D75:D77)=0,0,AVERAGEIF(D75:D77,\">0\"))","v":0},{"$f":"IF(SUM(E75:E77)=0,0,AVERAGEIF(E75:E77,\">0\"))","v":0},{"$f":"IF(SUM(F75:F77)=0,0,AVERAGEIF(F75:F77,\">0\"))","v":0},{"$f":"IF(SUM(D78:F78)=0,0,(D78*5+E78+F78)/(IF(D78>0,5,0)+IF(E78>0,1,0)+IF(F78>0,1,0)))","v":0},"All"]
[null,"Compressor #3 Percent Load - First Shift (%)",1,null,null,null,0,"All"]
[null,"Compressor #3 Percent Load - Second Shift (%)",2,null,null,null,0,"All"]
[null,"Compressor #3 Percent Load - Third Shift (%)",3,null,null,null,0,"All"]
[null,"Average (%)","avg",{"$f":"IF(SUM(D79:D81)=0,0,AVERAGEIF(D79:D81,\">0\"))","v":0},{"$f":"IF(SUM(E79:E81)=0,0,AVERAGEIF(E79:E81,\">0\"))","v":0},{"$f":"IF(SUM(F79:F81)=0,0,AVERAGEIF(F79:F81,\">0\"))","v":0},{"$f":"IF(SUM(D82:F82)=0,0,(D82*5+E82+F82)/(IF(D82>0,5,0)+IF(E82>0,1,0)+IF(F82>0,1,0)))","v":0},"All"]
[null,"Compressor #4 Percent Load - First Shift (%)",1,null,null,null,0,"All"]
[null,"Compressor #4 Percent Load - Second Shift (%)",2,null,null,null,0,"All"]
[null,"Compressor #4 Percent Load - Third Shift (%)",3,null,null,null,0,"All"]
[null,"Average (%)","avg",{"$f":"IF(SUM(D83:D85)=0,0,AVERAGEIF(D83:D85,\">0\"))","v":0},{"$f":"IF(SUM(E83:E85)=0,0,AVERAGEIF(E83:E85,\">0\"))","v":0},{"$f":"IF(SUM(F83:F85)=0,0,AVERAGEIF(F83:F85,\">0\"))","v":0},{"$f":"IF(SUM(D86:F86)=0,0,(D86*5+E86+F86)/(IF(D86>0,5,0)+IF(E86>0,1,0)+IF(F86>0,1,0)))","v":0},"All"]
[]
[]
[null,"Reduce Supply Side Air Pressure Incentive",null,{"$f":"IF(Reference!X95>0,Reference!X95*0.85,\"\")","v":""}]
[null,"Repair Air Leaks Incentive",null,{"$f":"IF(C33=\"\",\"\",(C33-C34)*50)","v":""}]
[]
[null,null,"Total Incentive",{"$f":"SUM(D89:D91)","v":0}]

{"sheet":"Anti Sweat Door Heater Controls","index":9,"n_rows":30,"n_cols":9,"rows_kept":30,"cut":false,"hidden":true,"merged":[[29,4,29,5],[26,1,26,5],[27,1,27,5],[14,1,15,2],[14,3,15,7],[18,1,18,4],[18,5,18,8],[3,1,3,7],[8,1,8,7],[9,1,11,7],[13,1,13,7],[4,1,6,7]]}
[]
[null,"Tune Anti-Sweat Controls"]
[]
[null,"Purpose"]
[null,"This tool was developed for the implementation of the MassSave ESPO Program. This measure applies to dew-point based heater cycling or modulation controls retrofitted to AS door heaters on walk-in coolers, freezers and all types of refrigerated cases. "]
[]
[]
[]
[null,"Measure Descriptions"]
[null,"Tune Anti-Sweat Controls - Repair and retune dew-point based controls to reduce the runtime of door and frame heaters on refrigeration systems. This applies to both freezers and refrigerators including walk-in or reach-in units. The reduced door heating also results in a reduced cooling load."]
[]
[]
[]
[null,"Instructions"]
[null,"User Input",null,"Fill in user input cells according to the best available understanding. Because these are site-specific values, there are no assumptions that can replace these inputs.\n\nNote: Some user input cells are not required for all measures. These are noted in the \"Relevant measures\" field."]
[]
[]
[null,"User Inputs"]
[null,"Low Temp",null,null,null,"Medium Temp"]
[null,"Amperage per Heater Circuit","Heater Voltage","Heater Circuit Count","Existing Heater % Off Time","Amperage per Heater Circuit","Heater Voltage","Heater Circuit Count","Existing Heater % Off Time"]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"SUM(D21:D25)","v":0},null,null,null,{"$f":"SUM(H21:H25)","v":0}]
[null,"Low Temp Anti Sweat Door Heater Control Incentive",null,null,null,null,{"$f":"IF(D26>0,D26*400,\"\")","v":""}]
[null,"Medium Temp Anti Sweat Door Heater Control Incentive",null,null,null,null,{"$f":"IF(H26>0,H26*800,\"\")","v":""}]
[]
[null,null,null,null,"Total Incentive",null,{"$f":"SUM(G27:G28)","v":0}]

{"sheet":"Cycle Evaporator Fans","index":10,"n_rows":31,"n_cols":13,"rows_kept":31,"cut":false,"hidden":true,"merged":[[30,4,30,5],[17,7,17,12],[17,1,17,6],[27,1,27,5],[28,1,28,5],[13,1,14,2],[13,3,14,7],[3,1,3,7],[4,1,5,7],[7,1,7,7],[8,1,10,7],[12,1,12,7]]}
[]
[null,"Cycle Evaporator Fans"]
[]
[null,"Purpose"]
[null,"This tool was developed for the implementation of the MassSave ESPO Program. This measure applies to the optimal cycling of the refrigeration evaporator fans, where the fans run only when necessary."]
[]
[]
[null,"Measure Descriptions"]
[null,"Cycle Evaporator Fans - Repair or retune refrigeration controls enabling modulation of evaporator fans based on temperature conditions, reducing fan and compressor run time and limiting waste heat delivered into the refrigerated space."]
[]
[]
[]
[null,"Instructions"]
[null,"User Input",null,"Fill in user input cells according to the best available understanding. Because these are site-specific values, there are no assumptions that can replace these inputs.\n\nNote: Some user input cells are not required for all measures. These are noted in the \"Relevant measures\" field."]
[]
[]
[null,"User Inputs"]
[null,"Low Temp",null,null,null,null,null,"Medium Temp"]
[null,"Amperage per Fan Circuit","Fan Circuit Voltage","Fan Circuit Count","Fan Circuit Phases","Existing Fan % Off Time","# of Fans per Circuit","Amperage per Fan Circuit","Fan Circuit Voltage","Fan Circuit Count","Fan Circuit Phases","Existing Fan % Off Time","# of Fans per Circuit"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,{"$f":"SUM(G20:G26)","v":0},null,null,null,null,null,{"$f":"SUM(M20:M26)","v":0}]
[null,"Low Temp Cycle Evaporator Fans Incentive",null,null,null,null,{"$f":"IF(G27>0,G27*35,\"\")","v":""}]
[null,"Medium Temp Cycle Evaporator Fans Incentive",null,null,null,null,{"$f":"IF(M27>0,M27*35,\"\")","v":""}]
[]
[null,null,null,null,"Total Incentive",null,{"$f":"SUM(G28:G29)","v":0}]

{"sheet":"Reduce Defrost Run Time","index":11,"n_rows":31,"n_cols":18,"rows_kept":31,"cut":false,"hidden":true,"merged":[[17,1,17,7],[17,8,17,14],[30,4,30,5],[27,1,27,5],[28,1,28,5],[13,1,14,2],[13,3,14,7],[3,1,3,7],[4,1,6,7],[8,1,8,7],[9,1,10,7],[12,1,12,7]]}
[]
[null,"Reduce Defrost"]
[]
[null,"Purpose"]
[null,"This tool was developed for the implementation of the MassSave ESPO Program. This measure applies to control mechanisms to initiate defrost only when necessary, for evaporators in walk-in coolers, freezers and all types of refrigerated cases. "]
[]
[]
[]
[null,"Measure Descriptions"]
[null,"Reduce Defrost - Repair or retune defrost controls to minimize defrost cycles on evaporator coils when enthalpy conditions allow. Reducing the number of defrost cycles also reduces the heat load in the refrigerated space."]
[]
[]
[null,"Instructions"]
[null,"User Input",null,"Fill in user input cells according to the best available understanding. Because these are site-specific values, there are no assumptions that can replace these inputs.\n\nNote: Some user input cells are not required for all measures. These are noted in the \"Relevant measures\" field."]
[]
[]
[null,"User Inputs"]
[null,"Low Temp",null,null,null,null,null,null,"Medium Temp"]
[null,"Amperage per Defrost Circuit","Defrost Circuit Voltage","Defrost Circuit Count","Existing Interval between Start of Defrost Cycles (Hours)","Existing Defrost Duration (Minutes)","Proposed Interval between Start of Defrost Cycles (Hours)","Proposed Defrost Duration (Minutes)","Amperage per Defrost Circuit","Defrost Circuit Voltage","Defrost Circuit Count","Existing Interval between Start of Defrost Cycles (Hours)","Existing Defrost Duration (Minutes)","Proposed Interval between Start of Defrost Cycles (Hours)","Proposed Defrost Duration (Minutes)",null,"Low Temp","Med Temp"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"G20-E20","v":0},{"$f":"N20-L20","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"G21-E21","v":0},{"$f":"N21-L21","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"N22-L22","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q20:Q26)","v":0},{"$f":"SUM(R20:R26)","v":0}]
[null,"Low Temp Reduce Defrost Run Time Incentive",null,null,null,null,{"$f":"IF(Q27>0,Q27*100,\"\")","v":""}]
[null,"Medium Temp Reduce Defrost Run Time Incentive",null,null,null,null,{"$f":"IF(R27>0,R27*100,\"\")","v":""}]
[]
[null,null,null,null,"Total Incentive",null,{"$f":"SUM(G28:G29)","v":0}]

{"sheet":"Optimize Evaporator Fans","index":12,"n_rows":47,"n_cols":16,"rows_kept":47,"cut":false,"hidden":true,"merged":[[46,4,46,5],[43,1,43,5],[44,1,44,5],[23,1,23,7],[33,1,33,7],[19,1,19,2],[19,3,19,4],[3,1,3,7],[4,1,5,7],[7,1,7,7],[8,1,9,7],[11,1,11,7],[12,1,13,2],[12,3,13,7],[14,1,15,2],[14,3,15,7]]}
[]
[null,"Optimize Evaporator Fans"]
[]
[null,"Purpose"]
[null,"This tool was developed for the implementation of the MassSave ESPO Program. This measure applies to optimizing evaporator fan controls for fans with VFDs."]
[]
[]
[null,"Measure Descriptions"]
[null,"Optimize Evaporator Fans - Repair or retune fan controls to ensure that larger refrigeration systems equipped with VFDs are modulating the evaporator fans appropriately based on loads."]
[]
[]
[null,"Instructions"]
[null,"User Input",null,"Fill in user input cells according to the best available understanding. Because these are site-specific values, there are no assumptions that can replace these inputs.\n\nNote: Some user input cells are not required for all measures. These are noted in the \"Relevant measures\" field."]
[]
[null,"Calculated - Affected by inputs",null,"This is a calculation cell that varies with user inputs. It can be used to understand more about when savings occurs."]
[]
[]
[null,"User Inputs"]
[]
[null,"Select project location",null,{"$f":"'Workbook Introduction'!C37","v":{"$error":"#N/A"}}]
[]
[null,"*Use sum of motor nameplate amps where possible, especially if an evaporator bank has been retrofitted with new motors"]
[]
[null,"Low Temp (Freezers)"]
[null,"Amperage per Fan Circuit","Fan Circuit Voltage","Fan Circuit Count","Fan Circuit Phases","Existing Fan Controls","Proposed Fan Controls","Is Evaporator Oversized?",null,null,null,null,"Convert to HP","Total HP of fans","Tier Determination","Incentive"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"((B26*C26)/1000)*1.34","v":0},{"$f":"IF(M26>0,M26*D26,\"\")","v":""},{"$f":"IF(M26>0,IF(G26=Reference!$B$125,2,1),\"\")","v":""},{"$f":"IF(O26=1,N26*50,IF(O26=2,N26*75,\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"((B27*C27)/1000)*1.34","v":0},{"$f":"IF(M27>0,M27*D27,\"\")","v":""},{"$f":"IF(M27>0,IF(G27=Reference!$B$125,2,1),\"\")","v":""},{"$f":"IF(O27=1,N27*50,IF(O27=2,N27*75,\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,0,"",{"$f":"IF(M28>0,IF(G28=Reference!$B$125,2,1),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,0,"",{"$f":"IF(M29>0,IF(G29=Reference!$B$125,2,1),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,0,"",{"$f":"IF(M30>0,IF(G30=Reference!$B$125,2,1),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,0,"",{"$f":"IF(M31>0,IF(G31=Reference!$B$125,2,1),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,0,"",{"$f":"IF(M32>0,IF(G32=Reference!$B$125,2,1),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(P26:P32)","v":0}]
[null,"Medium Temp (Coolers)"]
[null,"Amperage per Fan Circuit","Fan Circuit Voltage","Fan Circuit Count","Fan Circuit Phases","Existing Fan Controls","Proposed Fan Controls","Is Evaporator Oversized?",null,null,null,null,"Convert to HP","Total HP of fans","Tier Determination","Incentive"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"((B36*C36)/1000)*1.34","v":0},{"$f":"IF(M36>0,M36*D36,\"\")","v":""},{"$f":"IF(M36>0,IF(G36=Reference!$B$125,2,1),\"\")","v":""},{"$f":"IF(O36=1,N36*50,IF(O36=2,N36*75,\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"((B37*C37)/1000)*1.34","v":0},{"$f":"IF(M37>0,M37*D37,\"\")","v":""},{"$f":"IF(M37>0,IF(G37=Reference!$B$125,2,1),\"\")","v":""},{"$f":"IF(O37=1,N37*50,IF(O37=2,N37*75,\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,0,"",{"$f":"IF(M38>0,IF(G38=Reference!$B$125,2,1),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,0,"",{"$f":"IF(M39>0,IF(G39=Reference!$B$125,2,1),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,0,"",{"$f":"IF(M40>0,IF(G40=Reference!$B$125,2,1),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,0,"",{"$f":"IF(M41>0,IF(G41=Reference!$B$125,2,1),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,0,"",{"$f":"IF(M42>0,IF(G42=Reference!$B$125,2,1),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(P36:P42)","v":0}]
[null,"Low Temp Optimizer Evaporator Run Time Incentive",null,null,null,null,{"$f":"IF(P33>0,P33,\"\")","v":""}]
[null,"Medium Temp Optimizer Evaporator Run Time Incentive",null,null,null,null,{"$f":"IF(P43>0,P43,\"\")","v":""}]
[]
[null,null,null,null,"Total Incentive",null,{"$f":"SUM(G44:G45)","v":0}]

{"sheet":"Optimize Condenser Fans","index":13,"n_rows":54,"n_cols":16,"rows_kept":54,"cut":false,"hidden":true,"merged":[[51,2,51,5],[37,3,37,8],[53,4,53,5],[14,1,15,2],[14,3,15,7],[16,1,17,2],[16,3,17,7],[50,2,50,5],[47,4,47,7],[48,4,48,7],[42,4,42,7],[43,4,43,7],[44,4,44,7],[45,4,45,7],[46,4,46,7],[40,3,40,8],[34,1,34,2],[35,1,35,2],[36,1,36,2],[39,3,39,8],[38,3,38,8],[30,1,30,2],[31,1,31,2],[32,1,32,2],[33,1,33,2],[3,1,3,7],[4,1,5,7],[7,1,7,7],[8,1,9,7],[11,1,11,7],[12,1,13,2],[12,3,13,7],[21,2,21,3],[21,4,21,5],[23,2,23,6],[23,7,23,11],[29,1,29,2]]}
[]
[null,"Optimize Condenser Fans"]
[]
[null,"Purpose"]
[null,"This tool was developed for the implementation of the MassSave ESPO Program. This measure applies to optimizing the condenser fans equipped with VFDs. "]
[]
[]
[null,"Measure Descriptions"]
[null,"Optimize Condenser Fans - Repair or retune fan controls to ensure that larger refrigeration systems equipped with VFDs are modulating the condenser fans appropriately based on loads."]
[]
[]
[null,"Instructions"]
[null,"User Input",null,"Fill in user input cells according to the best available understanding. Because these are site-specific values, there are no assumptions that can replace these inputs.\n\nNote: Some user input cells are not required for all measures. These are noted in the \"Relevant measures\" field."]
[]
[null,"Calculated - Affected by inputs",null,"This is a calculation cell that varies with user inputs. It can be used to understand more about when savings occurs."]
[]
[null,"Deemed or Assumed Values",null,"Values that are deemed or assumed if the user does not have access to that specific piece of information."]
[]
[]
[null,"User Inputs"]
[]
[null,null,"Select project location",null,{"$f":"'Workbook Introduction'!C37","v":{"$error":"#N/A"}}]
[]
[null,null,"Low Temp",null,null,null,null,"Medium Temp"]
[null,null,"Suction Group","Suction Temperature (°F)","Design Load (Btu/hr)","Diversity","Average Load (Btu/hr)","Suction Group","Suction Temperature (°F)","Design Load (Btu/hr)","Diversity","Average Load (Btu/hr)"]
[null,null,1,null,null,null,{"$f":"IF(OR(D26=\"\",E26=\"\",F26=\"\"),\"\",F26*E26)","v":""},1,null,null,null,{"$f":"IF(OR(I26=\"\",J26=\"\",K26=\"\"),\"\",K26*J26)","v":""}]
[null,null,2,null,null,null,{"$f":"IF(OR(D27=\"\",E27=\"\",F27=\"\"),\"\",F27*E27)","v":""},2,null,null,null,{"$f":"IF(OR(I27=\"\",J27=\"\",K27=\"\"),\"\",K27*J27)","v":""}]
[null,null,3,null,null,null,{"$f":"IF(OR(D28=\"\",E28=\"\",F28=\"\"),\"\",F28*E28)","v":""},3,null,null,null,{"$f":"IF(OR(I28=\"\",J28=\"\",K28=\"\"),\"\",K28*J28)","v":""}]
[null,null,"Total or average",{"$f":"SUMPRODUCT(D26:D28,E26:E28)/E29","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E26:E28)","v":0},{"$f":"SUMPRODUCT(F26:F28,E26:E28)/E29","v":{"$error":"#DIV/0!"}},{"$f":"SUM(G26:G28)","v":0},"Total or average",{"$f":"SUMPRODUCT(I26:I28,J26:J28)/J29","v":{"$error":"#DIV/0!"}},{"$f":"SUM(J26:J28)","v":0},{"$f":"SUMPRODUCT(K26:K28,J26:J28)/J29","v":{"$error":"#DIV/0!"}},{"$f":"SUM(L26:L28)","v":0}]
[null,"Parameter",null,"Input Source?","User Input","Default","Value to Use",null,"Input Source?","User Input","Default","Value to Use","Unit"]
[null,"Condenser rated capacity",null,null,null,{"$f":"E29*200%/10","v":0},{"$f":"IF(D31=\"User input\",E31,F31)","v":0},null,null,null,{"$f":"J29*200%/10","v":0},{"$f":"IF(I31=\"User input\",J31,K31)","v":0},"Btu/hr-°F"]
[null,"Rated total condenser fan power",null,null,null,{"$f":"E29/15000","v":0},{"$f":"IF(D32=\"User input\",E32,F32)","v":0},null,null,null,{"$f":"J29/15000","v":0},{"$f":"IF(I32=\"User input\",J32,K32)","v":0},"kW"]
[null,"Existing rated Temperature Differential",null,null,null,10,{"$f":"IF(D33=\"User input\",E33,F33)","v":10},null,null,null,10,{"$f":"IF(I33=\"User input\",J33,K33)","v":10},"°F"]
[null,"Existing condensing temperature setpoint",null,null,null,85,{"$f":"IF(D34=\"User input\",E34,F34)","v":85},null,null,null,85,{"$f":"IF(I34=\"User input\",J34,K34)","v":85},"°F"]
[null,"Existing control strategy",null,null,null,1,1,null,null,null,1,1]
[null,"Proposed control strategy",null,null,null,6,6,null,null,null,6,6]
[null,"Existing condenser condition",null,"User input",null,null,null,null,"User input"]
[null,"Condenser Condition","Capacity Factor","Description"]
[null,"Good",0.95,"Condenser less than 10 years old, without visible scaling or damage"]
[null,"Average",0.85,"Condenser has scaling less than 1/64 in. or dirt less than 1/16 in., and/or minor damage"]
[null,"Poor",0.7,"Condenser is covered in scale/dirt, and/or has corroded/bent fins"]
[]
[null,null,null,"Strategy","Control Strategy Description"]
[null,null,null,1,"Cycle on/off"]
[null,null,null,2,"Split condenser, two-speed"]
[null,null,null,3,"Two-speed"]
[null,null,null,4,"Split condenser (3 sections), VFD"]
[null,null,null,5,"Split condenser (2 sections), VFD"]
[null,null,null,6,"VFD, synchronized speed on all fans"]
[]
[null,null,"Low Temp Condenser Fans Incentive",null,null,null,{"$f":"P52","v":0},null,null,null,null,null,"Low Temp","convert to hp","Incentive Tier","Incentive"]
[null,null,"Medium Temp Condenser Fans Incentive",null,null,null,{"$f":"P54","v":0},null,null,null,null,null,{"$f":"G32","v":0},{"$f":"M52*1.34","v":0},{"$f":"IF(G36<6,1,2)","v":2},{"$f":"IF(O52=1,20*N52,50*N52)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Med Temp","convert to hp","Incentive Tier"]
[null,null,null,null,"Total Incentive",null,{"$f":"SUM(G51:G52)","v":0},null,null,null,null,null,{"$f":"L32","v":0},{"$f":"M54*1.34","v":0},{"$f":"IF(L36<6,1,2)","v":2},{"$f":"IF(O54=1,20*N54,50*N54)","v":0}]

{"sheet":"Lower Condenser Pressure","index":14,"n_rows":46,"n_cols":28,"rows_kept":46,"cut":false,"hidden":true,"merged":[[45,6,45,7],[42,3,42,7],[43,3,43,7],[37,3,37,12],[38,3,38,12],[39,3,39,12],[40,3,40,12],[24,2,24,6],[24,7,24,11],[30,1,30,2],[30,7,36,7],[31,1,31,2],[32,1,32,2],[33,1,33,2],[34,1,34,2],[35,1,35,2],[36,1,36,2],[15,1,16,2],[15,3,16,7],[17,1,18,2],[17,3,18,7],[22,2,22,3],[22,4,22,5],[13,1,14,2],[13,3,14,7],[3,1,3,7],[4,1,6,7],[8,1,8,7],[9,1,10,7],[12,1,12,7]]}
[]
[null,"Lower Condenser Pressure"]
[]
[null,"Purpose"]
[null,"This tool was developed for the implementation of the MassSave ESPO Program. This measure applies to lowering the condensing pressure (or temperature) setpoint on systems with fixed setpoint controls (systems without TD-based floating head pressure controls)."]
[]
[]
[]
[null,"Measure Descriptions"]
[null,"Lower Condensing Pressure - Permanently lower the condensing pressure (or temperature) setpoint on refrigeration systems with fixed setpoint controls. This is best suited for systems without temperature differential based floating head pressure controls."]
[]
[]
[null,"Instructions"]
[null,"User Input",null,"Fill in user input cells according to the best available understanding. Because these are site-specific values, there are no assumptions that can replace these inputs.\n\nNote: Some user input cells are not required for all measures. These are noted in the \"Relevant measures\" field."]
[]
[null,"Calculated - Affected by inputs",null,"This is a calculation cell that varies with user inputs. It can be used to understand more about when savings occurs."]
[]
[null,"Deemed or Assumed Values",null,"Values that are deemed or assumed if the user does not have access to that specific piece of information."]
[]
[]
[null,"User Inputs"]
[]
[null,null,"Select project location",null,{"$f":"'Workbook Introduction'!C37","v":{"$error":"#N/A"}}]
[]
[null,null,"Low Temp",null,null,null,null,"Medium Temp"]
[null,null,"Suction Group","Suction Temperature (°F)","Design Load (Btu/hr)","Diversity","Average Load (Btu/hr)","Suction Group","Suction Temperature (°F)","Design Load (Btu/hr)","Diversity","Average Load (Btu/hr)"]
[null,null,1,null,null,null,{"$f":"IF(OR(D27=\"\",E27=\"\",F27=\"\"),\"\",F27*E27)","v":""},1,null,null,null,{"$f":"IF(OR(I27=\"\",J27=\"\",K27=\"\"),\"\",K27*J27)","v":""}]
[null,null,2,null,null,null,{"$f":"IF(OR(D28=\"\",E28=\"\",F28=\"\"),\"\",F28*E28)","v":""},2,null,null,null,{"$f":"IF(OR(I28=\"\",J28=\"\",K28=\"\"),\"\",K28*J28)","v":""}]
[null,null,3,null,null,null,{"$f":"IF(OR(D29=\"\",E29=\"\",F29=\"\"),\"\",F29*E29)","v":""},3,null,null,null,{"$f":"IF(OR(I29=\"\",J29=\"\",K29=\"\"),\"\",K29*J29)","v":""}]
[null,null,"Total or average",{"$f":"SUMPRODUCT(D27:D29,E27:E29)/E30","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E27:E29)","v":0},{"$f":"SUMPRODUCT(F27:F29,E27:E29)/E30","v":{"$error":"#DIV/0!"}},{"$f":"SUM(G27:G29)","v":0},"Total or average",{"$f":"SUMPRODUCT(I27:I29,J27:J29)/J30","v":{"$error":"#DIV/0!"}},{"$f":"SUM(J27:J29)","v":0},{"$f":"SUMPRODUCT(K27:K29,J27:J29)/J30","v":{"$error":"#DIV/0!"}},{"$f":"SUM(L27:L29)","v":0}]
[null,"Parameter",null,"Input Source?","User Input","Default","Value to Use",null,"Input Source?","User Input","Default","Value to Use","Unit"]
[null,"Condenser rated capacity",null,null,null,{"$f":"E30*200%/10","v":0},{"$f":"IF(D32=\"User input\",E32,F32)","v":0},null,null,null,{"$f":"J30*200%/10","v":0},{"$f":"IF(I32=\"User input\",J32,K32)","v":0},"Btu/hr-°F",null,null,null,null,null,null,null,null,null,null,null,null,null,"Low Temp HP","Incentive Calculation"]
[null,"Rated total condenser fan power",null,null,null,{"$f":"E30/15000","v":0},{"$f":"IF(D33=\"User input\",E33,F33)","v":0},null,null,null,{"$f":"J30/15000","v":0},{"$f":"IF(I33=\"User input\",J33,K33)","v":0},"kW",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"G33*1.34","v":0},{"$f":"IF(G34>0,35*AA33,\"\")","v":0}]
[null,"Existing rated Temperature Differential",null,null,null,10,{"$f":"IF(D34=\"User input\",E34,F34)","v":10},null,null,null,10,{"$f":"IF(I34=\"User input\",J34,K34)","v":10},"°F",null,null,null,null,null,null,null,null,null,null,null,null,null,"Med Temp HP"]
[null,"Existing condensing temperature setpoint",null,null,null,85,{"$f":"IF(D35=\"User input\",E35,F35)","v":85},null,null,null,85,{"$f":"IF(I35=\"User input\",J35,K35)","v":85},"°F",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"L33*1.34","v":0},{"$f":"IF(L34>0,35*AA35,\"\")","v":0}]
[null,"Proposed condensing temperature setpoint",null,null,null,70,70,null,null,null,70,70,"°F"]
[null,"Existing condenser condition",null,"User input",null,null,null,null,"User input"]
[null,"Condenser Condition","Capacity Factor","Description"]
[null,"Good",0.95,"Condenser less than 10 years old, without visible scaling or damage"]
[null,"Average",0.85,"Condenser has scaling less than 1/64 in. or dirt less than 1/16 in., and/or minor damage"]
[null,"Poor",0.7,"Condenser is covered in scale/dirt, and/or has corroded/bent fins"]
[]
[null,null,null,"Low Temp Condenser Pressure Reduction Incentive",null,null,null,null,{"$f":"AB33","v":0}]
[null,null,null,"Medium Temp Condenser Pressure Reduction Incentive",null,null,null,null,{"$f":"AB35","v":0}]
[]
[null,null,null,null,null,null,"Total Incentive",null,{"$f":"SUM(I43:I44)","v":0}]

{"sheet":"Floating Head Pressure","index":15,"n_rows":48,"n_cols":28,"rows_kept":48,"cut":false,"hidden":true,"merged":[[47,7,47,8],[44,3,44,8],[45,3,45,8],[38,1,38,2],[39,3,39,12],[40,3,40,12],[41,3,41,12],[42,3,42,12],[25,2,25,6],[25,7,25,11],[31,1,31,2],[31,7,38,7],[32,1,32,2],[33,1,33,2],[34,1,34,2],[35,1,35,2],[36,1,36,2],[37,1,37,2],[16,1,17,2],[16,3,17,7],[18,1,19,2],[18,3,19,7],[23,2,23,3],[23,4,23,5],[14,1,15,2],[14,3,15,7],[3,1,3,7],[4,1,6,7],[8,1,8,7],[9,1,11,7],[13,1,13,7]]}
[]
[null,"Optimize Floating Head Pressue"]
[]
[null,"Purpose"]
[null,"This tool was developed for the implementation of the MassSave ESPO Program. This measure applies to programming or reprogramming refrigeration head pressure floating strategie, including changing the minimum condensing temperature setpoint, and changing the temperature differential (TD)."]
[]
[]
[]
[null,"Measure Descriptions"]
[null,"Optimize Floating Head Pressure - Repair or retune controls to ensure optimal operation of controls decreasing compressor use by enabling head pressure reduction based on outside air wet bulb temperature. When conditions allow, the condenser capacity increases during cool outdoor conditions. "]
[]
[]
[]
[null,"Instructions"]
[null,"User Input",null,"Fill in user input cells according to the best available understanding. Because these are site-specific values, there are no assumptions that can replace these inputs.\n\nNote: Some user input cells are not required for all measures. These are noted in the \"Relevant measures\" field."]
[]
[null,"Calculated - Affected by inputs",null,"This is a calculation cell that varies with user inputs. It can be used to understand more about when savings occurs."]
[]
[null,"Deemed or Assumed Values",null,"Values that are deemed or assumed if the user does not have access to that specific piece of information."]
[]
[]
[null,"User Inputs"]
[]
[null,null,"Select project location",null,{"$f":"'Workbook Introduction'!C37","v":{"$error":"#N/A"}}]
[]
[null,null,"Low Temp",null,null,null,null,"Medium Temp"]
[null,null,"Suction Group","Suction Temperature (°F)","Design Load (Btu/hr)","Diversity","Average Load (Btu/hr)","Suction Group","Suction Temperature (°F)","Design Load (Btu/hr)","Diversity","Average Load (Btu/hr)"]
[null,null,1,null,null,null,{"$f":"IF(OR(D28=\"\",E28=\"\",F28=\"\"),\"\",F28*E28)","v":""},1,null,null,null,{"$f":"IF(OR(I28=\"\",J28=\"\",K28=\"\"),\"\",K28*J28)","v":""}]
[null,null,2,null,null,null,{"$f":"IF(OR(D29=\"\",E29=\"\",F29=\"\"),\"\",F29*E29)","v":""},2,null,null,null,{"$f":"IF(OR(I29=\"\",J29=\"\",K29=\"\"),\"\",K29*J29)","v":""}]
[null,null,3,null,null,null,{"$f":"IF(OR(D30=\"\",E30=\"\",F30=\"\"),\"\",F30*E30)","v":""},3,null,null,null,{"$f":"IF(OR(I30=\"\",J30=\"\",K30=\"\"),\"\",K30*J30)","v":""}]
[null,null,"Total or average",{"$f":"SUMPRODUCT(D28:D30,E28:E30)/E31","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E28:E30)","v":0},{"$f":"SUMPRODUCT(F28:F30,E28:E30)/E31","v":{"$error":"#DIV/0!"}},{"$f":"SUM(G28:G30)","v":0},"Total or average",{"$f":"SUMPRODUCT(I28:I30,J28:J30)/J31","v":{"$error":"#DIV/0!"}},{"$f":"SUM(J28:J30)","v":0},{"$f":"SUMPRODUCT(K28:K30,J28:J30)/J31","v":{"$error":"#DIV/0!"}},{"$f":"SUM(L28:L30)","v":0}]
[null,"Parameter",null,"Input Source?","User Input","Default","Value to Use",null,"Input Source?","User Input","Default","Value to Use","Unit",null,null,null,null,null,null,null,null,null,null,null,null,null,"Low Temp HP","Incentive Calculation"]
[null,"Condenser rated capacity",null,null,null,{"$f":"E31*200%/10","v":0},{"$f":"IF(D33=\"User input\",E33,F33)","v":0},null,null,null,{"$f":"J31*200%/10","v":0},{"$f":"IF(I33=\"User input\",J33,K33)","v":0},"Btu/hr-°F",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"G34*1.34","v":0},{"$f":"IF(G34>0,40*AA33,\"\")","v":""}]
[null,"Rated total condenser fan power",null,null,null,{"$f":"E31/15000","v":0},{"$f":"IF(D34=\"User input\",E34,F34)","v":0},null,null,null,{"$f":"J31/15000","v":0},{"$f":"IF(I34=\"User input\",J34,K34)","v":0},"kW",null,null,null,null,null,null,null,null,null,null,null,null,null,"Med Temp HP"]
[null,"Existing Rated TD",null,null,null,10,{"$f":"IF(D35=\"User input\",E35,F35)","v":10},null,null,null,10,{"$f":"IF(I35=\"User input\",J35,K35)","v":10},"°F",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"L34*1.34","v":0},{"$f":"IF(L34>0,40*AA35,\"\")","v":""}]
[null,"Proposed TD",null,null,null,12,{"$f":"IF(D36=\"User input\",E36,F36)","v":12},null,null,null,12,{"$f":"IF(I36=\"User input\",J36,K36)","v":12},"°F"]
[null,"Existing condensing temperature setpoint",null,null,null,85,85,null,null,null,85,85,"°F"]
[null,"Proposed condensing temperature setpoint",null,null,null,70,70,null,null,null,70,70,"°F"]
[null,"Existing condenser condition",null,"User input",null,null,null,null,"User input"]
[null,"Condenser Condition","Capacity Factor","Description"]
[null,"Good",0.95,"Condenser less than 10 years old, without visible scaling or damage"]
[null,"Average",0.85,"Condenser has scaling less than 1/64 in. or dirt less than 1/16 in., and/or minor damage"]
[null,"Poor",0.7,"Condenser is covered in scale/dirt, and/or has corroded/bent fins"]
[]
[null,null,null,"Low Temp Floating Head Pressure Reduction Incentive",null,null,null,null,null,{"$f":"AB33","v":""}]
[null,null,null,"Medium Temp Floating Head Pressure Reduction Incentive",null,null,null,null,null,{"$f":"AB35","v":""}]
[]
[null,null,null,null,null,null,null,"Total Incentive",null,{"$f":"SUM(J45:J46)","v":0}]

{"sheet":"Clean Condenser Coils","index":16,"n_rows":48,"n_cols":13,"rows_kept":48,"cut":false,"hidden":true,"merged":[[47,6,47,7],[45,3,45,7],[44,3,44,7],[41,3,41,6],[42,3,42,6],[36,3,36,12],[37,3,37,12],[38,3,38,12],[39,3,39,12],[24,2,24,6],[24,7,24,11],[30,1,30,2],[30,7,35,7],[31,1,31,2],[32,1,32,2],[33,1,33,2],[34,1,34,2],[35,1,35,2],[15,1,16,2],[15,3,16,7],[17,1,18,2],[17,3,18,7],[22,2,22,3],[22,4,22,5],[13,1,14,2],[13,3,14,7],[3,1,3,7],[4,1,6,7],[8,1,8,7],[9,1,10,7],[12,1,12,7]]}
[]
[null,"Clean Condenser Coils"]
[]
[null,"Purpose"]
[null,"This tool was developed for the implementation of the MassSave ESPO Program. This measure applies to cleaning or replacing the condenser coils to improve heat transfer. The measure results in a lower head pressure, and thus refrigeration compressor savings."]
[]
[]
[]
[null,"Measure Descriptions"]
[null,"Clean Condenser Coils - Remove dust and scale build up from condenser coils on refrigeration units improving heat transfer through lower head pressure and reduced compressor cycling."]
[]
[]
[null,"Instructions"]
[null,"User Input",null,"Fill in user input cells according to the best available understanding. Because these are site-specific values, there are no assumptions that can replace these inputs.\n\nNote: Some user input cells are not required for all measures. These are noted in the \"Relevant measures\" field."]
[]
[null,"Calculated - Affected by inputs",null,"This is a calculation cell that varies with user inputs. It can be used to understand more about when savings occurs."]
[]
[null,"Deemed or Assumed Values",null,"Values that are deemed or assumed if the user does not have access to that specific piece of information."]
[]
[]
[null,"User Inputs"]
[]
[null,null,"Select project location",null,{"$f":"'Workbook Introduction'!C37","v":{"$error":"#N/A"}}]
[]
[null,null,"Low Temp",null,null,null,null,"Medium Temp"]
[null,null,"Suction Group","Suction Temperature (°F)","Design Load (Btu/hr)","Diversity","Average Load (Btu/hr)","Suction Group","Suction Temperature (°F)","Design Load (Btu/hr)","Diversity","Average Load (Btu/hr)"]
[null,null,1,null,null,null,{"$f":"IF(OR(D27=\"\",E27=\"\",F27=\"\"),\"\",F27*E27)","v":""},1,null,null,null,{"$f":"IF(OR(I27=\"\",J27=\"\",K27=\"\"),\"\",K27*J27)","v":""}]
[null,null,2,null,null,null,{"$f":"IF(OR(D28=\"\",E28=\"\",F28=\"\"),\"\",F28*E28)","v":""},2,null,null,null,{"$f":"IF(OR(I28=\"\",J28=\"\",K28=\"\"),\"\",K28*J28)","v":""}]
[null,null,3,null,null,null,{"$f":"IF(OR(D29=\"\",E29=\"\",F29=\"\"),\"\",F29*E29)","v":""},3,null,null,null,{"$f":"IF(OR(I29=\"\",J29=\"\",K29=\"\"),\"\",K29*J29)","v":""}]
[null,null,"Total or average",{"$f":"SUMPRODUCT(D27:D29,E27:E29)/E30","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E27:E29)","v":0},{"$f":"SUMPRODUCT(F27:F29,E27:E29)/E30","v":{"$error":"#DIV/0!"}},{"$f":"SUM(G27:G29)","v":0},"Total or average",{"$f":"SUMPRODUCT(I27:I29,J27:J29)/J30","v":{"$error":"#DIV/0!"}},{"$f":"SUM(J27:J29)","v":0},{"$f":"SUMPRODUCT(K27:K29,J27:J29)/J30","v":{"$error":"#DIV/0!"}},{"$f":"SUM(L27:L29)","v":0}]
[null,"Parameter",null,"Input Source?","User Input","Default","Value to Use",null,"Input Source?","User Input","Default","Value to Use","Unit"]
[null,"Condenser rated capacity",null,null,null,{"$f":"E30*200%/10","v":0},{"$f":"IF(D32=\"User input\",E32,F32)","v":0},null,null,null,{"$f":"J30*200%/10","v":0},{"$f":"IF(I32=\"User input\",J32,K32)","v":0},"Btu/hr-°F"]
[null,"Rated total condenser fan power",null,null,null,{"$f":"E30/15000","v":0},{"$f":"IF(D33=\"User input\",E33,F33)","v":0},null,null,null,{"$f":"J30/15000","v":0},{"$f":"IF(I33=\"User input\",J33,K33)","v":0},"kW"]
[null,"Rated TD",null,null,null,10,{"$f":"IF(D34=\"User input\",E34,F34)","v":10},null,null,null,10,{"$f":"IF(I34=\"User input\",J34,K34)","v":10},"°F"]
[null,"Existing condensing temperature setpoint",null,null,null,85,{"$f":"IF(D35=\"User input\",E35,F35)","v":85},null,null,null,85,{"$f":"IF(I35=\"User input\",J35,K35)","v":85},"°F"]
[null,"Existing condenser condition",null,"User input",null,null,null,null,"User input"]
[null,"Condenser Condition","Capacity Factor","Description"]
[null,"Good",0.95,"Condenser less than 10 years old, without visible scaling or damage"]
[null,"Average",0.85,"Condenser has scaling less than 1/64 in. or dirt less than 1/16 in., and/or minor damage"]
[null,"Poor",0.7,"Condenser is covered in scale/dirt, and/or has corroded/bent fins"]
[]
[null,null,null,"How many low temp Condenser Coils are being cleanded"]
[null,null,null,"How many medium temp condenser coils are being cleaned"]
[]
[null,null,null,"Low Temp Clean Condenser Coils Incentive",null,null,null,null,{"$f":"IF(H42>0,H42*150,\"\")","v":""}]
[null,null,null,"Medium Temp Clean Condenser Coils Incentive",null,null,null,null,{"$f":"IF(H43>0,H43*150,\"\")","v":""}]
[]
[null,null,null,null,null,null,"Total Incentive",null,{"$f":"SUM(I45:I46)","v":0}]

{"sheet":"Reference","index":17,"n_rows":150,"n_cols":522,"rows_kept":150,"cut":false,"hidden":true,"merged":[]}
[]
[null,"List of Electric PA:","List of Natural Gas PA:","Yes/No"]
[null,"Cape Light Compact","Berkshire","Yes"]
[null,"Eversource East","Blackstone","No"]
[null,"Eversource West","Columbia"]
[null,"National Grid","Eversource"]
[null,"Unitil","Liberty"]
[null,null,"National Grid"]
[null,null,"Unitil"]
[]
[]
[]
[]
[null,"Optimize Economizer Control Dropdowns"]
[]
[null,"List of Electric PA:","List of baselines:"]
[null,"Cape Light Compact","No economizer"]
[null,"Eversource East","Dry bulb economizer"]
[null,"National Grid","Fixed enthalpy economizer",null,null,null,null,null,"DX Packaged or Split System Economizer Incentive",null,null,null,null,null,175,"ton"]
[null,"Unitil","Differential enthalpy economizer",null,null,null,null,null,"Water or Air Cooled Chiller System Economizer Incentive",null,null,null,null,null,600,"ton"]
[null,"Eversource West"]
[null,null,null,"Incentive is paid at: $"," / Ton of Chiller Capacity",null,null,null,null,null,null,null,null,null,{"$f":"IF('Optimize Economizer Control'!B36=Reference!I19,Reference!O19*'Optimize Economizer Control'!B34,'Optimize Economizer Control'!B34*Reference!O20)","v":0}]
[null,"Cooling system types:"]
[null,"Packaged or split DX, <5 tons",19.8,{"$f":"$D$22&C24&$E$22","v":"Incentive is paid at: $19.8 / Ton of Chiller Capacity"}]
[null,"Packaged or split DX, 5-11 tons",22.7,{"$f":"$D$22&C25&$E$22","v":"Incentive is paid at: $22.7 / Ton of Chiller Capacity"}]
[null,"Packaged or split DX, 11-20 tons",21.9,"Incentive is paid at: $21.9 / Ton of Chiller Capacity"]
[null,"Packaged or split DX, >20 tons",29.5,"Incentive is paid at: $29.5 / Ton of Chiller Capacity"]
[null,"Chiller, air-cooled, < 150 tons",20.2,"Incentive is paid at: $20.2 / Ton of Chiller Capacity"]
[null,"Chiller, air-cooled, > 150 tons",19.8,"Incentive is paid at: $19.8 / Ton of Chiller Capacity"]
[null,"Chiller, water-cooled, < 300 tons",12.7,"Incentive is paid at: $12.7 / Ton of Chiller Capacity"]
[null,"Chiller, water-cooled, > 300 tons",12,"Incentive is paid at: $12 / Ton of Chiller Capacity"]
[]
[]
[null,"ZIP code",2351,1720,2743,1220,1001,2134,1913,1003,1002,1002,1810,2476,2474,1430,1431,1330,1721,1222,2702,1331,2703,2763,1501,2466,2322,1432,1436,2630,1005,1223,1730,1007,2019,2478,2779,1224,1503,1337,1915,1821,1504,1008,1008,1740,2111,2215,2110,2108,2109,2115,2114,2163,2118,2127,2210,2113,2199,2222,2128,2116,1719,1921,1505,2184,2631,2324,2135,1010,1010,2301,2302,1506,2445,2446,1338,1803,2542,2532,2532,1922,2139,2140,2138,2141,2142,2021,1741,2330,2534,2632,1339,2129,1507,2633,1824,2150,1611,1225,1011,1011,1012,2467,2467,2467,1022,1020,1013,2535,1510,2025,1340,1742,1341,2635,2637,1026,1026,2713,1226,1923,2026,1342,2638,2639,1434,1434,2715,2121,2125,2122,2124,1516,2030,1826,1343,1571,1827,2332,2333,1515,2641,2536,2717,1028,2537,2718,2032,2538,2189,2642,1027,2539,1344,1929,2149,2719,2720,2721,2724,2723,2540,1745,1030,1518,1420,1062,2644,2035,1702,1701,2038,1440,1833,1031,1354,1930,1032,1519,1033,1034,1230,1301,1450,1834,1035,2338,1036,2339,1731,2341,1037,1451,2645,2646,1038,1830,1832,1835,1039,1039,1346,2043,1235,1235,2343,1520,1521,1746,1040,1747,1748,1236,1452,1749,2045,1050,1050,2601,2647,2136,1151,1938,2130,1522,2364,2347,1523,1237,1843,1841,1840,1238,1053,1524,1240,1453,1054,2420,2421,1773,1460,1106,1852,1854,1850,1851,1056,1462,1905,1901,1904,1902,1940,2148,1944,2048,1945,2738,1752,2050,2648,2649,2126,2739,1754,2052,2155,2053,2176,1756,1860,1844,2346,1949,1757,1527,1349,2054,1529,2186,1350,1057,1351,1245,2553,1908,2554,1760,2492,2494,2744,2746,2745,2740,1531,1355,1951,1950,2458,2459,2461,2462,2464,2460,2056,1247,1247,1845,2760,1862,1535,2650,1863,2747,2764,2356,2556,1536,1537,1864,2652,2191,1060,1532,1534,1360,2766,2061,2062,2557,1068,2558,1364,2653,2655,1253,1540,1069,1612,1960,2359,1463,1366,1201,1070,2762,2360,2367,2559,1541,2657,2170,2171,2169,2368,2767,1867,2769,2151,1254,1542,2770,2370,1966,2131,1367,1969,2119,2120,1368,1071,1543,2561,2562,1970,1952,1255,2563,1906,1256,2066,2771,2067,1257,1370,1770,1464,1545,1072,2564,2725,2726,2144,2145,2143,2659,2748,1373,2660,2375,1258,1560,1075,1982,2071,2663,2190,2664,1073,1772,1550,1259,1077,1562,1107,1103,1104,1119,1105,1108,1128,1129,1109,1118,1564,1262,2180,2072,1775,1566,1776,1375,1590,1907,2777,2780,1468,1876,1080,1983,1469,2666,1376,1879,1264,1568,1569,1718,2568,2468,1880,1081,2081,2451,2452,2453,1082,1082,2571,1083,1378,2472,1778,1570,2482,2481,2667,1379,1984,2668,1583,2379,1585,1084,2670,2671,1088,1985,2465,2132,1089,1266,1474,2576,1092,2673,1581,1085,1886,1473,2493,2790,2791,2090,2188,1588,2382,1095,1096,1096,1267,1887,1475,1890,1270,2152,1801,2543,1604,1609,1610,1608,1603,1607,1606,1605,1602,1098,2093,2675]
[null,"ZIP code name","ABINGTON","ACTON","ACUSHNET","ADAMS","AGAWAM","ALLSTON","AMESBURY","AMHERST","AMHERST","AMHERST","ANDOVER","ARLINGTON","ARLINGTON","ASHBURNHAM","ASHBY","ASHFIELD","ASHLAND","ASHLEY FALLS","ASSONET","ATHOL","ATTLEBORO","ATTLEBORO FALLS","AUBURN","AUBURNDALE","AVON","AYER","BALDWINVILLE","BARNSTABLE","BARRE","BECKET","BEDFORD","BELCHERTOWN","BELLINGHAM","BELMONT","BERKLEY","BERKSHIRE","BERLIN","BERNARDSTON","BEVERLY","BILLERICA","BLACKSTONE","BLANDFORD","BLANDFORD","BOLTON","BOSTON","BOSTON","BOSTON","BOSTON","BOSTON","BOSTON","BOSTON","BOSTON","BOSTON","BOSTON","BOSTON","BOSTON","BOSTON","BOSTON","BOSTON","BOSTON","BOXBOROUGH","BOXFORD","BOYLSTON","BRAINTREE","BREWSTER","BRIDGEWATER","BRIGHTON","BRIMFIELD","BRIMFIELD","BROCKTON","BROCKTON","BROOKFIELD","BROOKLINE","BROOKLINE","BUCKLAND","BURLINGTON","BUZZARDS BAY","BUZZARDS BAY","BUZZARDS BAY","BYFIELD","CAMBRIDGE","CAMBRIDGE","CAMBRIDGE","CAMBRIDGE","CAMBRIDGE","CANTON","CARLISLE","CARVER","CATAUMET","CENTERVILLE","CHARLEMONT","CHARLESTOWN","CHARLTON","CHATHAM","CHELMSFORD","CHELSEA","CHERRY VALLEY","CHESHIRE","CHESTER","CHESTER","CHESTERFIELD","CHESTNUT HILL","CHESTNUT HILL","CHESTNUT HILL","CHICOPEE","CHICOPEE","CHICOPEE","CHILMARK","CLINTON","COHASSET","COLRAIN","CONCORD","CONWAY","COTUIT","CUMMAQUID","CUMMINGTON","CUMMINGTON","CUTTYHUNK","DALTON","DANVERS","DEDHAM","DEERFIELD","DENNIS","DENNIS PORT","DEVENS","DEVENS","DIGHTON","DORCHESTER","DORCHESTER","DORCHESTER","DORCHESTER CENTER","DOUGLAS","DOVER","DRACUT","DRURY","DUDLEY","DUNSTABLE","DUXBURY","EAST BRIDGEWATER","EAST BROOKFIELD","EAST DENNIS","EAST FALMOUTH","EAST FREETOWN","EAST LONGMEADOW","EAST SANDWICH","EAST TAUNTON","EAST WALPOLE","EAST WAREHAM","EAST WEYMOUTH","EASTHAM","EASTHAMPTON","EDGARTOWN","ERVING","ESSEX","EVERETT","FAIRHAVEN","FALL RIVER","FALL RIVER","FALL RIVER","FALL RIVER","FALMOUTH","FAYVILLE","FEEDING HILLS","FISKDALE","FITCHBURG","FLORENCE","FORESTDALE","FOXBORO","FRAMINGHAM","FRAMINGHAM","FRANKLIN","GARDNER","GEORGETOWN","GILBERTVILLE","GILL","GLOUCESTER","GOSHEN","GRAFTON","GRANBY","GRANVILLE","GREAT BARRINGTON","GREENFIELD","GROTON","GROVELAND","HADLEY","HALIFAX","HAMPDEN","HANOVER","HANSCOM AFB","HANSON","HARDWICK","HARVARD","HARWICH","HARWICH PORT","HATFIELD","HAVERHILL","HAVERHILL","HAVERHILL","HAYDENVILLE","HAYDENVILLE","HEATH","HINGHAM","HINSDALE","HINSDALE","HOLBROOK","HOLDEN","HOLLAND","HOLLISTON","HOLYOKE","HOPEDALE","HOPKINTON","HOUSATONIC","HUBBARDSTON","HUDSON","HULL","HUNTINGTON","HUNTINGTON","HYANNIS","HYANNIS PORT","HYDE PARK","INDIAN ORCHARD","IPSWICH","JAMAICA PLAIN","JEFFERSON","KINGSTON","LAKEVILLE","LANCASTER","LANESBORO","LAWRENCE","LAWRENCE","LAWRENCE","LEE","LEEDS","LEICESTER","LENOX","LEOMINSTER","LEVERETT","LEXINGTON","LEXINGTON","LINCOLN","LITTLETON","LONGMEADOW","LOWELL","LOWELL","LOWELL","LOWELL","LUDLOW","LUNENBURG","LYNN","LYNN","LYNN","LYNN","LYNNFIELD","MALDEN","MANCHESTER","MANSFIELD","MARBLEHEAD","MARION","MARLBOROUGH","MARSHFIELD","MARSTONS MILLS","MASHPEE","MATTAPAN","MATTAPOISETT","MAYNARD","MEDFIELD","MEDFORD","MEDWAY","MELROSE","MENDON","MERRIMAC","METHUEN","MIDDLEBORO","MIDDLETON","MILFORD","MILLBURY","MILLERS FALLS","MILLIS","MILLVILLE","MILTON","MONROE BRIDGE","MONSON","MONTAGUE","MONTEREY","MONUMENT BEACH","NAHANT","NANTUCKET","NATICK","NEEDHAM","NEEDHAM HEIGHTS","NEW BEDFORD","NEW BEDFORD","NEW BEDFORD","NEW BEDFORD","NEW BRAINTREE","NEW SALEM","NEWBURY","NEWBURYPORT","NEWTON","NEWTON CENTER","NEWTON HIGHLANDS","NEWTON LOWER FALLS","NEWTON UPPER FALLS","NEWTONVILLE","NORFOLK","NORTH ADAMS","NORTH ADAMS","NORTH ANDOVER","NORTH ATTLEBORO","NORTH BILLERICA","NORTH BROOKFIELD","NORTH CHATHAM","NORTH CHELMSFORD","NORTH DARTMOUTH","NORTH DIGHTON","NORTH EASTON","NORTH FALMOUTH","NORTH GRAFTON","NORTH OXFORD","NORTH READING","NORTH TRURO","NORTH WEYMOUTH","NORTHAMPTON","NORTHBOROUGH","NORTHBRIDGE","NORTHFIELD","NORTON","NORWELL","NORWOOD","OAK BLUFFS","OAKHAM","ONSET","ORANGE","ORLEANS","OSTERVILLE","OTIS","OXFORD","PALMER","PAXTON","PEABODY","PEMBROKE","PEPPERELL","PETERSHAM","PITTSFIELD","PLAINFIELD","PLAINVILLE","PLYMOUTH","PLYMPTON","POCASSET","PRINCETON","PROVINCETOWN","QUINCY","QUINCY","QUINCY","RANDOLPH","RAYNHAM","READING","REHOBOTH","REVERE","RICHMOND","ROCHDALE","ROCHESTER","ROCKLAND","ROCKPORT","ROSLINDALE","ROWE","ROWLEY","ROXBURY","ROXBURY CROSSING","ROYALSTON","RUSSELL","RUTLAND","SAGAMORE","SAGAMORE BEACH","SALEM","SALISBURY","SANDISFIELD","SANDWICH","SAUGUS","SAVOY","SCITUATE","SEEKONK","SHARON","SHEFFIELD","SHELBURNE FALLS","SHERBORN","SHIRLEY","SHREWSBURY","SHUTESBURY","SIASCONSET","SOMERSET","SOMERSET","SOMERVILLE","SOMERVILLE","SOMERVILLE","SOUTH CHATHAM","SOUTH DARTMOUTH","SOUTH DEERFIELD","SOUTH DENNIS","SOUTH EASTON","SOUTH EGREMONT","SOUTH GRAFTON","SOUTH HADLEY","SOUTH HAMILTON","SOUTH WALPOLE","SOUTH WELLFLEET","SOUTH WEYMOUTH","SOUTH YARMOUTH","SOUTHAMPTON","SOUTHBOROUGH","SOUTHBRIDGE","SOUTHFIELD","SOUTHWICK","SPENCER","SPRINGFIELD","SPRINGFIELD","SPRINGFIELD","SPRINGFIELD","SPRINGFIELD","SPRINGFIELD","SPRINGFIELD","SPRINGFIELD","SPRINGFIELD","SPRINGFIELD","STERLING","STOCKBRIDGE","STONEHAM","STOUGHTON","STOW","STURBRIDGE","SUDBURY","SUNDERLAND","SUTTON","SWAMPSCOTT","SWANSEA","TAUNTON","TEMPLETON","TEWKSBURY","THREE RIVERS","TOPSFIELD","TOWNSEND","TRURO","TURNERS FALLS","TYNGSBORO","TYRINGHAM","UPTON","UXBRIDGE","VILLAGE OF NAGOG WOODS","VINEYARD HAVEN","WABAN","WAKEFIELD","WALES","WALPOLE","WALTHAM","WALTHAM","WALTHAM","WARE","WARE","WAREHAM","WARREN","WARWICK","WATERTOWN","WAYLAND","WEBSTER","WELLESLEY","WELLESLEY HILLS","WELLFLEET","WENDELL","WENHAM","WEST BARNSTABLE","WEST BOYLSTON","WEST BRIDGEWATER","WEST BROOKFIELD","WEST CHESTERFIELD","WEST DENNIS","WEST HARWICH","WEST HATFIELD","WEST NEWBURY","WEST NEWTON","WEST ROXBURY","WEST SPRINGFIELD","WEST STOCKBRIDGE","WEST TOWNSEND","WEST WAREHAM","WEST WARREN","WEST YARMOUTH","WESTBOROUGH","WESTFIELD","WESTFORD","WESTMINSTER","WESTON","WESTPORT","WESTPORT POINT","WESTWOOD","WEYMOUTH","WHITINSVILLE","WHITMAN","WILBRAHAM","WILLIAMSBURG","WILLIAMSBURG","WILLIAMSTOWN","WILMINGTON","WINCHENDON","WINCHESTER","WINDSOR","WINTHROP","WOBURN","WOODS HOLE","WORCESTER","WORCESTER","WORCESTER","WORCESTER","WORCESTER","WORCESTER","WORCESTER","WORCESTER","WORCESTER","WORTHINGTON","WRENTHAM","YARMOUTH PORT"]
[]
[]
[]
[null,"Reset Calculator Dropdowns"]
[null,"Chilled Water, Condenser Water, Discharge Air Temperature, Boiler",null,null,null,null,null,null,"Chilled Water Reset",null,null,null,null,{"$f":"'ResetControl(CHW,CW,DAT,Boiler)'!H63","v":"0"},{"$f":"IF(N40=100,1,0)","v":0},{"$f":"IF('ResetControl(CHW,CW,DAT,Boiler)'!B39-'ResetControl(CHW,CW,DAT,Boiler)'!B38<55,\"Under Minimum\",100)","v":"Under Minimum"}]
[null,null,null,null,null,null,null,null,"Condenser Water Reset",null,null,null,null,{"$f":"'ResetControl(CHW,CW,DAT,Boiler)'!H64","v":"0"},{"$f":"IF(N41=600,1,0)","v":0}]
[null,"List of Electric PA:","Yes/No",null,null,null,null,null,"Discharge Air Temperature (DAT) Reset",null,null,null,null,{"$f":"'ResetControl(CHW,CW,DAT,Boiler)'!H65","v":"0"},{"$f":"IF(N42=50,1,0)","v":0}]
[null,"Cape Light Compact","Yes",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O40:O42)","v":0},800]
[null,"Eversource East","No"]
[null,"National Grid","Boiler Type"]
[null,"Unitil","Non-Condensing"]
[null,"Eversource West","Condensing"]
[]
[null,"ZIP code",2351,1720,2743,1220,1001,2134,1913,1003,1002,1002,1810,2476,2474,1430,1431,1330,1721,1222,2702,1331,2703,2763,1501,2466,2322,1432,1436,2630,1005,1223,1730,1007,2019,2478,2779,1224,1503,1337,1915,1821,1504,1008,1008,1740,2111,2215,2110,2108,2109,2115,2114,2163,2118,2127,2210,2113,2199,2222,2128,2116,1719,1921,1505,2184,2631,2324,2135,1010,1010,2301,2302,1506,2445,2446,1338,1803,2542,2532,2532,1922,2139,2140,2138,2141,2142,2021,1741,2330,2534,2632,1339,2129,1507,2633,1824,2150,1611,1225,1011,1011,1012,2467,2467,2467,1022,1020,1013,2535,1510,2025,1340,1742,1341,2635,2637,1026,1026,2713,1226,1923,2026,1342,2638,2639,1434,1434,2715,2121,2125,2122,2124,1516,2030,1826,1343,1571,1827,2332,2333,1515,2641,2536,2717,1028,2537,2718,2032,2538,2189,2642,1027,2539,1344,1929,2149,2719,2720,2721,2724,2723,2540,1745,1030,1518,1420,1062,2644,2035,1702,1701,2038,1440,1833,1031,1354,1930,1032,1519,1033,1034,1230,1301,1450,1834,1035,2338,1036,2339,1731,2341,1037,1451,2645,2646,1038,1830,1832,1835,1039,1039,1346,2043,1235,1235,2343,1520,1521,1746,1040,1747,1748,1236,1452,1749,2045,1050,1050,2601,2647,2136,1151,1938,2130,1522,2364,2347,1523,1237,1843,1841,1840,1238,1053,1524,1240,1453,1054,2420,2421,1773,1460,1106,1852,1854,1850,1851,1056,1462,1905,1901,1904,1902,1940,2148,1944,2048,1945,2738,1752,2050,2648,2649,2126,2739,1754,2052,2155,2053,2176,1756,1860,1844,2346,1949,1757,1527,1349,2054,1529,2186,1350,1057,1351,1245,2553,1908,2554,1760,2492,2494,2744,2746,2745,2740,1531,1355,1951,1950,2458,2459,2461,2462,2464,2460,2056,1247,1247,1845,2760,1862,1535,2650,1863,2747,2764,2356,2556,1536,1537,1864,2652,2191,1060,1532,1534,1360,2766,2061,2062,2557,1068,2558,1364,2653,2655,1253,1540,1069,1612,1960,2359,1463,1366,1201,1070,2762,2360,2367,2559,1541,2657,2170,2171,2169,2368,2767,1867,2769,2151,1254,1542,2770,2370,1966,2131,1367,1969,2119,2120,1368,1071,1543,2561,2562,1970,1952,1255,2563,1906,1256,2066,2771,2067,1257,1370,1770,1464,1545,1072,2564,2725,2726,2144,2145,2143,2659,2748,1373,2660,2375,1258,1560,1075,1982,2071,2663,2190,2664,1073,1772,1550,1259,1077,1562,1107,1103,1104,1119,1105,1108,1128,1129,1109,1118,1564,1262,2180,2072,1775,1566,1776,1375,1590,1907,2777,2780,1468,1876,1080,1983,1469,2666,1376,1879,1264,1568,1569,1718,2568,2468,1880,1081,2081,2451,2452,2453,1082,1082,2571,1083,1378,2472,1778,1570,2482,2481,2667,1379,1984,2668,1583,2379,1585,1084,2670,2671,1088,1985,2465,2132,1089,1266,1474,2576,1092,2673,1581,1085,1886,1473,2493,2790,2791,2090,2188,1588,2382,1095,1096,1096,1267,1887,1475,1890,1270,2152,1801,2543,1604,1609,1610,1608,1603,1607,1606,1605,1602,1098,2093,2675]
[null,"ZIP code name","ABINGTON","ACTON","ACUSHNET","ADAMS","AGAWAM","ALLSTON","AMESBURY","AMHERST","AMHERST","AMHERST","ANDOVER","ARLINGTON","ARLINGTON","ASHBURNHAM","ASHBY","ASHFIELD","ASHLAND","ASHLEY FALLS","ASSONET","ATHOL","ATTLEBORO","ATTLEBORO FALLS","AUBURN","AUBURNDALE","AVON","AYER","BALDWINVILLE","BARNSTABLE","BARRE","BECKET","BEDFORD","BELCHERTOWN","BELLINGHAM","BELMONT","BERKLEY","BERKSHIRE","BERLIN","BERNARDSTON","BEVERLY","BILLERICA","BLACKSTONE","BLANDFORD","BLANDFORD","BOLTON","BOSTON","BOSTON","BOSTON","BOSTON","BOSTON","BOSTON","BOSTON","BOSTON","BOSTON","BOSTON","BOSTON","BOSTON","BOSTON","BOSTON","BOSTON","BOSTON","BOXBOROUGH","BOXFORD","BOYLSTON","BRAINTREE","BREWSTER","BRIDGEWATER","BRIGHTON","BRIMFIELD","BRIMFIELD","BROCKTON","BROCKTON","BROOKFIELD","BROOKLINE","BROOKLINE","BUCKLAND","BURLINGTON","BUZZARDS BAY","BUZZARDS BAY","BUZZARDS BAY","BYFIELD","CAMBRIDGE","CAMBRIDGE","CAMBRIDGE","CAMBRIDGE","CAMBRIDGE","CANTON","CARLISLE","CARVER","CATAUMET","CENTERVILLE","CHARLEMONT","CHARLESTOWN","CHARLTON","CHATHAM","CHELMSFORD","CHELSEA","CHERRY VALLEY","CHESHIRE","CHESTER","CHESTER","CHESTERFIELD","CHESTNUT HILL","CHESTNUT HILL","CHESTNUT HILL","CHICOPEE","CHICOPEE","CHICOPEE","CHILMARK","CLINTON","COHASSET","COLRAIN","CONCORD","CONWAY","COTUIT","CUMMAQUID","CUMMINGTON","CUMMINGTON","CUTTYHUNK","DALTON","DANVERS","DEDHAM","DEERFIELD","DENNIS","DENNIS PORT","DEVENS","DEVENS","DIGHTON","DORCHESTER","DORCHESTER","DORCHESTER","DORCHESTER CENTER","DOUGLAS","DOVER","DRACUT","DRURY","DUDLEY","DUNSTABLE","DUXBURY","EAST BRIDGEWATER","EAST BROOKFIELD","EAST DENNIS","EAST FALMOUTH","EAST FREETOWN","EAST LONGMEADOW","EAST SANDWICH","EAST TAUNTON","EAST WALPOLE","EAST WAREHAM","EAST WEYMOUTH","EASTHAM","EASTHAMPTON","EDGARTOWN","ERVING","ESSEX","EVERETT","FAIRHAVEN","FALL RIVER","FALL RIVER","FALL RIVER","FALL RIVER","FALMOUTH","FAYVILLE","FEEDING HILLS","FISKDALE","FITCHBURG","FLORENCE","FORESTDALE","FOXBORO","FRAMINGHAM","FRAMINGHAM","FRANKLIN","GARDNER","GEORGETOWN","GILBERTVILLE","GILL","GLOUCESTER","GOSHEN","GRAFTON","GRANBY","GRANVILLE","GREAT BARRINGTON","GREENFIELD","GROTON","GROVELAND","HADLEY","HALIFAX","HAMPDEN","HANOVER","HANSCOM AFB","HANSON","HARDWICK","HARVARD","HARWICH","HARWICH PORT","HATFIELD","HAVERHILL","HAVERHILL","HAVERHILL","HAYDENVILLE","HAYDENVILLE","HEATH","HINGHAM","HINSDALE","HINSDALE","HOLBROOK","HOLDEN","HOLLAND","HOLLISTON","HOLYOKE","HOPEDALE","HOPKINTON","HOUSATONIC","HUBBARDSTON","HUDSON","HULL","HUNTINGTON","HUNTINGTON","HYANNIS","HYANNIS PORT","HYDE PARK","INDIAN ORCHARD","IPSWICH","JAMAICA PLAIN","JEFFERSON","KINGSTON","LAKEVILLE","LANCASTER","LANESBORO","LAWRENCE","LAWRENCE","LAWRENCE","LEE","LEEDS","LEICESTER","LENOX","LEOMINSTER","LEVERETT","LEXINGTON","LEXINGTON","LINCOLN","LITTLETON","LONGMEADOW","LOWELL","LOWELL","LOWELL","LOWELL","LUDLOW","LUNENBURG","LYNN","LYNN","LYNN","LYNN","LYNNFIELD","MALDEN","MANCHESTER","MANSFIELD","MARBLEHEAD","MARION","MARLBOROUGH","MARSHFIELD","MARSTONS MILLS","MASHPEE","MATTAPAN","MATTAPOISETT","MAYNARD","MEDFIELD","MEDFORD","MEDWAY","MELROSE","MENDON","MERRIMAC","METHUEN","MIDDLEBORO","MIDDLETON","MILFORD","MILLBURY","MILLERS FALLS","MILLIS","MILLVILLE","MILTON","MONROE BRIDGE","MONSON","MONTAGUE","MONTEREY","MONUMENT BEACH","NAHANT","NANTUCKET","NATICK","NEEDHAM","NEEDHAM HEIGHTS","NEW BEDFORD","NEW BEDFORD","NEW BEDFORD","NEW BEDFORD","NEW BRAINTREE","NEW SALEM","NEWBURY","NEWBURYPORT","NEWTON","NEWTON CENTER","NEWTON HIGHLANDS","NEWTON LOWER FALLS","NEWTON UPPER FALLS","NEWTONVILLE","NORFOLK","NORTH ADAMS","NORTH ADAMS","NORTH ANDOVER","NORTH ATTLEBORO","NORTH BILLERICA","NORTH BROOKFIELD","NORTH CHATHAM","NORTH CHELMSFORD","NORTH DARTMOUTH","NORTH DIGHTON","NORTH EASTON","NORTH FALMOUTH","NORTH GRAFTON","NORTH OXFORD","NORTH READING","NORTH TRURO","NORTH WEYMOUTH","NORTHAMPTON","NORTHBOROUGH","NORTHBRIDGE","NORTHFIELD","NORTON","NORWELL","NORWOOD","OAK BLUFFS","OAKHAM","ONSET","ORANGE","ORLEANS","OSTERVILLE","OTIS","OXFORD","PALMER","PAXTON","PEABODY","PEMBROKE","PEPPERELL","PETERSHAM","PITTSFIELD","PLAINFIELD","PLAINVILLE","PLYMOUTH","PLYMPTON","POCASSET","PRINCETON","PROVINCETOWN","QUINCY","QUINCY","QUINCY","RANDOLPH","RAYNHAM","READING","REHOBOTH","REVERE","RICHMOND","ROCHDALE","ROCHESTER","ROCKLAND","ROCKPORT","ROSLINDALE","ROWE","ROWLEY","ROXBURY","ROXBURY CROSSING","ROYALSTON","RUSSELL","RUTLAND","SAGAMORE","SAGAMORE BEACH","SALEM","SALISBURY","SANDISFIELD","SANDWICH","SAUGUS","SAVOY","SCITUATE","SEEKONK","SHARON","SHEFFIELD","SHELBURNE FALLS","SHERBORN","SHIRLEY","SHREWSBURY","SHUTESBURY","SIASCONSET","SOMERSET","SOMERSET","SOMERVILLE","SOMERVILLE","SOMERVILLE","SOUTH CHATHAM","SOUTH DARTMOUTH","SOUTH DEERFIELD","SOUTH DENNIS","SOUTH EASTON","SOUTH EGREMONT","SOUTH GRAFTON","SOUTH HADLEY","SOUTH HAMILTON","SOUTH WALPOLE","SOUTH WELLFLEET","SOUTH WEYMOUTH","SOUTH YARMOUTH","SOUTHAMPTON","SOUTHBOROUGH","SOUTHBRIDGE","SOUTHFIELD","SOUTHWICK","SPENCER","SPRINGFIELD","SPRINGFIELD","SPRINGFIELD","SPRINGFIELD","SPRINGFIELD","SPRINGFIELD","SPRINGFIELD","SPRINGFIELD","SPRINGFIELD","SPRINGFIELD","STERLING","STOCKBRIDGE","STONEHAM","STOUGHTON","STOW","STURBRIDGE","SUDBURY","SUNDERLAND","SUTTON","SWAMPSCOTT","SWANSEA","TAUNTON","TEMPLETON","TEWKSBURY","THREE RIVERS","TOPSFIELD","TOWNSEND","TRURO","TURNERS FALLS","TYNGSBORO","TYRINGHAM","UPTON","UXBRIDGE","VILLAGE OF NAGOG WOODS","VINEYARD HAVEN","WABAN","WAKEFIELD","WALES","WALPOLE","WALTHAM","WALTHAM","WALTHAM","WARE","WARE","WAREHAM","WARREN","WARWICK","WATERTOWN","WAYLAND","WEBSTER","WELLESLEY","WELLESLEY HILLS","WELLFLEET","WENDELL","WENHAM","WEST BARNSTABLE","WEST BOYLSTON","WEST BRIDGEWATER","WEST BROOKFIELD","WEST CHESTERFIELD","WEST DENNIS","WEST HARWICH","WEST HATFIELD","WEST NEWBURY","WEST NEWTON","WEST ROXBURY","WEST SPRINGFIELD","WEST STOCKBRIDGE","WEST TOWNSEND","WEST WAREHAM","WEST WARREN","WEST YARMOUTH","WESTBOROUGH","WESTFIELD","WESTFORD","WESTMINSTER","WESTON","WESTPORT","WESTPORT POINT","WESTWOOD","WEYMOUTH","WHITINSVILLE","WHITMAN","WILBRAHAM","WILLIAMSBURG","WILLIAMSBURG","WILLIAMSTOWN","WILMINGTON","WINCHENDON","WINCHESTER","WINDSOR","WINTHROP","WOBURN","WOODS HOLE","WORCESTER","WORCESTER","WORCESTER","WORCESTER","WORCESTER","WORCESTER","WORCESTER","WORCESTER","WORCESTER","WORTHINGTON","WRENTHAM","YARMOUTH PORT"]
[]
[]
[]
[null,"Fan and Pump Calculator Dropdowns"]
[]
[null,"Data Validation Dropdowns:",null,"Utilities","Building Type"]
[null,"Yes","24/7","Cape Light Compact","University/College"]
[null,"No","off","NGrid","Elm/H School"]
[null,null,"00:00:00","Eversource East","Multi-Family"]
[null,null,{"$f":"C59+TIME(1,0,0)","v":"01:00:00"},"Unitil","Hotel/Motel"]
[null,null,{"$f":"C60+TIME(1,0,0)","v":"02:00:00"},"Eversource West","Health"]
[null,null,"03:00:00",null,"Warehouse"]
[null,null,"04:00:00",null,"Restaurant"]
[null,null,"05:00:00",null,"Retail"]
[null,null,"06:00:00",null,"Grocery"]
[null,null,"07:00:00",null,"Offices"]
[null,null,"08:00:00"]
[null,null,"09:00:00"]
[null,null,"10:00:00"]
[null,null,"11:00:00"]
[null,null,"12:00:00"]
[null,null,"13:00:00"]
[null,null,"14:00:00"]
[null,null,"15:00:00"]
[null,null,"16:00:00"]
[null,null,"17:00:00"]
[null,null,"18:00:00"]
[null,null,"19:00:00"]
[null,null,{"$f":"C78+TIME(1,0,0)","v":"20:00:00"}]
[null,null,"21:00:00"]
[null,null,"22:00:00"]
[null,null,"23:00:00"]
[]
[]
[]
[]
[null,"Compressed Air Leaks and Pressure Reduction Measures"]
[]
[null,"Compressor Types",null,null,null,null,"Compressor Performance Data"]
[null,"Ref No.","Description","Ref No.","Comments",null,"Percent","Type 1","Type 2","Type 3","Type 4","Type 5","Type 6","Type 7","Type 8","Type 9","Type 10","Type 11","Type 12"]
[null,1,"Reciprocating, Single Stage",1,null,null,"Load ","kW/CFM","kW/CFM","kW/CFM","kW/CFM","kW/CFM","kW/CFM","kW/CFM","kW/CFM","kW/CFM","kW/CFM","kW/CFM","kW/CFM",null,null,null,"Compressor 1",{"$f":"IF('Comp. Air Leaks and Pressure'!C41=\"No\",'Comp. Air Leaks and Pressure'!C39,\"\")","v":""}]
[null,2,"Reciprocating, Multi-Stage",2,null,null,0,0,0,0,0,0.21224272343567499,0,0,0.20163058726389124,0,0.20163058726389124,0,0.27300000000000002,null,null,null,"Compressor 2",{"$f":"IF('Comp. Air Leaks and Pressure'!C47=\"No\",'Comp. Air Leaks and Pressure'!C44,\"\")","v":""}]
[null,3,"Rotary Screw, Single Stage, Dual Auto",3,null,null,0.01,0,0,0.5,2,0.21224272343567499,2,2,0.20163058726389124,0.71199999999999997,0.20163058726389124,0.03,0.27300000000000002,null,null,null,"Compressor 3",{"$f":"IF('Comp. Air Leaks and Pressure'!C53=\"No\",'Comp. Air Leaks and Pressure'!C51,\"\")","v":""}]
[null,4,"Rotary Screw, Single Stage, Modulating",4,null,null,0.1,0.34521601489757914,0.34521601489757914,0.48919977064817954,1.403787912398758,0.21224272343567499,0.65096308644514389,1.403787912398758,0.20163058726389124,0.64400000000000002,0.20163058726389124,0.05,0.27300000000000002,null,null,null,"Compressor 4",{"$f":"IF('Comp. Air Leaks and Pressure'!C59=\"No\",'Comp. Air Leaks and Pressure'!C57,\"\")","v":""}]
[null,5,"Rotary Screw, Single Stage, VFD",5,null,null,0.2,0.24397629354772213,0.24397629354772213,0.32037970563709861,0.73692786385470643,0.21224272343567499,0.38830571016870086,0.73692786385470643,0.20163058726389124,0.38640000000000002,0.18679999999999999,7.4099999999999999E-2,0.27300000000000002,null,null,null,null,{"$f":"SUM(X91:X94)","v":0}]
[null,6,"Rotary Screw, Multi-Stage, Dual Auto",6,null,null,0.3,0.20987793523653039,0.20987793523653039,0.26374092654509634,0.51508876097167233,0.21224272343567499,0.31380276657921558,0.51508876097167233,0.20163058726389124,0.31890000000000002,0.18590000000000001,0.14560000000000001,0.2049]
[null,7,"Rotary Screw, Multi-Stage, Modulating",7,null,null,0.4,0.19256783302639655,0.19256783302639655,0.23515043183087703,0.40412953699948539,0.21224272343567499,0.27941627636781119,0.40412953699948539,0.20163058726389124,0.27600000000000002,0.1845,0.1714,0.18859999999999999]
[null,8,"Rotary Screw, Multi-Stage, VFD",8,null,null,0.5,0.18197533129459736,0.182,0.21778158714211096,0.33789999999999998,0.1922892337226044,0.2608474485183564,0.3378848330976616,0.18267477203647417,0.23549999999999999,0.18379999999999999,0.18740000000000001,0.193]
[null,9,"Rotary Screw, Variable Displacement",9,null,null,0.6,0.17474351682578371,0.17469999999999999,0.20602548649881078,0.29340615867499531,0.187745483110762,0.24922260458978251,0.29340615867499531,0.17835820895522389,0.21460000000000001,0.18260000000000001,0.19359999999999999,0.19320000000000001]
[null,10,"Multi-Stage, Centrifugal",10,null,null,0.7,0.16943368895827909,0.16943368895827909,0.19747828959593666,0.26189457896596707,0.1854847645429363,0.2212238816996171,0.26189457896596707,0.17621052631578948,0.2024,0.18129999999999999,0.2011,0.19450000000000001]
[null,11,"Rotary Vane",11,null,null,0.8,0.16532647711232104,0.16532647711232104,0.19093805612110912,0.23800458070896643,0.18493216588088138,0.20001358193153834,0.23800458070896643,0.17568555758683729,0.19550000000000001,0.1794,0.2099,0.19719999999999999]
[null,12,"Rotary Screw, Switch Reluctance VFD",12,null,null,0.9,0.1620222132922555,0.1620222132922555,0.18573702385362978,0.21964233433570229,0.18518833432531248,0.18369790214394999,0.21964233433570229,0.17592891760904686,0.19220000000000001,0.17730000000000001,0.21759999999999999,0.2]
[null,null,null,null,null,null,1,0.15928108108108108,0.15928108108108108,0.18040773883126826,0.20517373548971621,0.18733790999237224,0.17064535831387928,0.20519999999999999,0.17797101449275363,0.1842,0.17610000000000001,0.2437,0.2021]
[]
[null,"Dryer Types",null,null,null,null,"Dryer Performance Data",null,null,null,null,null,null,null,"Yes"]
[null,"Ref No.","Description","Ref No.","Comments",null,"Type 1","Type 2","Type 3","Type 4","Type 5","Type 6",null,null,"No"]
[null,1,"Refrigerated",1,null,null,"kW/CFM","kW/CFM","kW/CFM","kW/CFM","kW/CFM","kW/CFM"]
[null,2,"Dessicant, Heat Ractivated, Compressed Air Purge",2,null,null,{"$f":"0.79/100","v":7.9000000000000008E-3},{"$f":"3/100","v":0.03},{"$f":"2/100","v":0.02},{"$f":"0.15/100","v":1.5E-3},{"$f":"0.2/100","v":2E-3},{"$f":"0.8/100","v":8.0000000000000002E-3}]
[null,3,"Dessicant, Heatless, Compressed Air Purge",3]
[null,4,"Dessicant, Heat Reactivated, Blower Purge",4]
[null,5,"Deliquescent",5]
[null,6,"Heat of Compression",6]
[]
[]
[]
[null,"Optimize Evaporator Run Time"]
[]
[null,"ZIP code",2351,1720,2743,1220,1001,2134,1913,1003,1002,1002,1810,2476,2474,1430,1431,1330,1721,1222,2702,1331,2703,2763,1501,2466,2322,1432,1436,2630,1005,1223,1730,1007,2019,2478,2779,1224,1503,1337,1915,1821,1504,1008,1008,1740,2111,2215,2110,2108,2109,2115,2114,2163,2118,2127,2210,2113,2199,2222,2128,2116,1719,1921,1505,2184,2631,2324,2135,1010,1010,2301,2302,1506,2445,2446,1338,1803,2542,2532,2532,1922,2139,2140,2138,2141,2142,2021,1741,2330,2534,2632,1339,2129,1507,2633,1824,2150,1611,1225,1011,1011,1012,2467,2467,2467,1022,1020,1013,2535,1510,2025,1340,1742,1341,2635,2637,1026,1026,2713,1226,1923,2026,1342,2638,2639,1434,1434,2715,2121,2125,2122,2124,1516,2030,1826,1343,1571,1827,2332,2333,1515,2641,2536,2717,1028,2537,2718,2032,2538,2189,2642,1027,2539,1344,1929,2149,2719,2720,2721,2724,2723,2540,1745,1030,1518,1420,1062,2644,2035,1702,1701,2038,1440,1833,1031,1354,1930,1032,1519,1033,1034,1230,1301,1450,1834,1035,2338,1036,2339,1731,2341,1037,1451,2645,2646,1038,1830,1832,1835,1039,1039,1346,2043,1235,1235,2343,1520,1521,1746,1040,1747,1748,1236,1452,1749,2045,1050,1050,2601,2647,2136,1151,1938,2130,1522,2364,2347,1523,1237,1843,1841,1840,1238,1053,1524,1240,1453,1054,2420,2421,1773,1460,1106,1852,1854,1850,1851,1056,1462,1905,1901,1904,1902,1940,2148,1944,2048,1945,2738,1752,2050,2648,2649,2126,2739,1754,2052,2155,2053,2176,1756,1860,1844,2346,1949,1757,1527,1349,2054,1529,2186,1350,1057,1351,1245,2553,1908,2554,1760,2492,2494,2744,2746,2745,2740,1531,1355,1951,1950,2458,2459,2461,2462,2464,2460,2056,1247,1247,1845,2760,1862,1535,2650,1863,2747,2764,2356,2556,1536,1537,1864,2652,2191,1060,1532,1534,1360,2766,2061,2062,2557,1068,2558,1364,2653,2655,1253,1540,1069,1612,1960,2359,1463,1366,1201,1070,2762,2360,2367,2559,1541,2657,2170,2171,2169,2368,2767,1867,2769,2151,1254,1542,2770,2370,1966,2131,1367,1969,2119,2120,1368,1071,1543,2561,2562,1970,1952,1255,2563,1906,1256,2066,2771,2067,1257,1370,1770,1464,1545,1072,2564,2725,2726,2144,2145,2143,2659,2748,1373,2660,2375,1258,1560,1075,1982,2071,2663,2190,2664,1073,1772,1550,1259,1077,1562,1107,1103,1104,1119,1105,1108,1128,1129,1109,1118,1564,1262,2180,2072,1775,1566,1776,1375,1590,1907,2777,2780,1468,1876,1080,1983,1469,2666,1376,1879,1264,1568,1569,1718,2568,2468,1880,1081,2081,2451,2452,2453,1082,1082,2571,1083,1378,2472,1778,1570,2482,2481,2667,1379,1984,2668,1583,2379,1585,1084,2670,2671,1088,1985,2465,2132,1089,1266,1474,2576,1092,2673,1581,1085,1886,1473,2493,2790,2791,2090,2188,1588,2382,1095,1096,1096,1267,1887,1475,1890,1270,2152,1801,2543,1604,1609,1610,1608,1603,1607,1606,1605,1602,1098,2093,2675]
[null,"ZIP code name","ABINGTON","ACTON","ACUSHNET","ADAMS","AGAWAM","ALLSTON","AMESBURY","AMHERST","AMHERST","AMHERST","ANDOVER","ARLINGTON","ARLINGTON","ASHBURNHAM","ASHBY","ASHFIELD","ASHLAND","ASHLEY FALLS","ASSONET","ATHOL","ATTLEBORO","ATTLEBORO FALLS","AUBURN","AUBURNDALE","AVON","AYER","BALDWINVILLE","BARNSTABLE","BARRE","BECKET","BEDFORD","BELCHERTOWN","BELLINGHAM","BELMONT","BERKLEY","BERKSHIRE","BERLIN","BERNARDSTON","BEVERLY","BILLERICA","BLACKSTONE","BLANDFORD","BLANDFORD","BOLTON","BOSTON","BOSTON","BOSTON","BOSTON","BOSTON","BOSTON","BOSTON","BOSTON","BOSTON","BOSTON","BOSTON","BOSTON","BOSTON","BOSTON","BOSTON","BOSTON","BOXBOROUGH","BOXFORD","BOYLSTON","BRAINTREE","BREWSTER","BRIDGEWATER","BRIGHTON","BRIMFIELD","BRIMFIELD","BROCKTON","BROCKTON","BROOKFIELD","BROOKLINE","BROOKLINE","BUCKLAND","BURLINGTON","BUZZARDS BAY","BUZZARDS BAY","BUZZARDS BAY","BYFIELD","CAMBRIDGE","CAMBRIDGE","CAMBRIDGE","CAMBRIDGE","CAMBRIDGE","CANTON","CARLISLE","CARVER","CATAUMET","CENTERVILLE","CHARLEMONT","CHARLESTOWN","CHARLTON","CHATHAM","CHELMSFORD","CHELSEA","CHERRY VALLEY","CHESHIRE","CHESTER","CHESTER","CHESTERFIELD","CHESTNUT HILL","CHESTNUT HILL","CHESTNUT HILL","CHICOPEE","CHICOPEE","CHICOPEE","CHILMARK","CLINTON","COHASSET","COLRAIN","CONCORD","CONWAY","COTUIT","CUMMAQUID","CUMMINGTON","CUMMINGTON","CUTTYHUNK","DALTON","DANVERS","DEDHAM","DEERFIELD","DENNIS","DENNIS PORT","DEVENS","DEVENS","DIGHTON","DORCHESTER","DORCHESTER","DORCHESTER","DORCHESTER CENTER","DOUGLAS","DOVER","DRACUT","DRURY","DUDLEY","DUNSTABLE","DUXBURY","EAST BRIDGEWATER","EAST BROOKFIELD","EAST DENNIS","EAST FALMOUTH","EAST FREETOWN","EAST LONGMEADOW","EAST SANDWICH","EAST TAUNTON","EAST WALPOLE","EAST WAREHAM","EAST WEYMOUTH","EASTHAM","EASTHAMPTON","EDGARTOWN","ERVING","ESSEX","EVERETT","FAIRHAVEN","FALL RIVER","FALL RIVER","FALL RIVER","FALL RIVER","FALMOUTH","FAYVILLE","FEEDING HILLS","FISKDALE","FITCHBURG","FLORENCE","FORESTDALE","FOXBORO","FRAMINGHAM","FRAMINGHAM","FRANKLIN","GARDNER","GEORGETOWN","GILBERTVILLE","GILL","GLOUCESTER","GOSHEN","GRAFTON","GRANBY","GRANVILLE","GREAT BARRINGTON","GREENFIELD","GROTON","GROVELAND","HADLEY","HALIFAX","HAMPDEN","HANOVER","HANSCOM AFB","HANSON","HARDWICK","HARVARD","HARWICH","HARWICH PORT","HATFIELD","HAVERHILL","HAVERHILL","HAVERHILL","HAYDENVILLE","HAYDENVILLE","HEATH","HINGHAM","HINSDALE","HINSDALE","HOLBROOK","HOLDEN","HOLLAND","HOLLISTON","HOLYOKE","HOPEDALE","HOPKINTON","HOUSATONIC","HUBBARDSTON","HUDSON","HULL","HUNTINGTON","HUNTINGTON","HYANNIS","HYANNIS PORT","HYDE PARK","INDIAN ORCHARD","IPSWICH","JAMAICA PLAIN","JEFFERSON","KINGSTON","LAKEVILLE","LANCASTER","LANESBORO","LAWRENCE","LAWRENCE","LAWRENCE","LEE","LEEDS","LEICESTER","LENOX","LEOMINSTER","LEVERETT","LEXINGTON","LEXINGTON","LINCOLN","LITTLETON","LONGMEADOW","LOWELL","LOWELL","LOWELL","LOWELL","LUDLOW","LUNENBURG","LYNN","LYNN","LYNN","LYNN","LYNNFIELD","MALDEN","MANCHESTER","MANSFIELD","MARBLEHEAD","MARION","MARLBOROUGH","MARSHFIELD","MARSTONS MILLS","MASHPEE","MATTAPAN","MATTAPOISETT","MAYNARD","MEDFIELD","MEDFORD","MEDWAY","MELROSE","MENDON","MERRIMAC","METHUEN","MIDDLEBORO","MIDDLETON","MILFORD","MILLBURY","MILLERS FALLS","MILLIS","MILLVILLE","MILTON","MONROE BRIDGE","MONSON","MONTAGUE","MONTEREY","MONUMENT BEACH","NAHANT","NANTUCKET","NATICK","NEEDHAM","NEEDHAM HEIGHTS","NEW BEDFORD","NEW BEDFORD","NEW BEDFORD","NEW BEDFORD","NEW BRAINTREE","NEW SALEM","NEWBURY","NEWBURYPORT","NEWTON","NEWTON CENTER","NEWTON HIGHLANDS","NEWTON LOWER FALLS","NEWTON UPPER FALLS","NEWTONVILLE","NORFOLK","NORTH ADAMS","NORTH ADAMS","NORTH ANDOVER","NORTH ATTLEBORO","NORTH BILLERICA","NORTH BROOKFIELD","NORTH CHATHAM","NORTH CHELMSFORD","NORTH DARTMOUTH","NORTH DIGHTON","NORTH EASTON","NORTH FALMOUTH","NORTH GRAFTON","NORTH OXFORD","NORTH READING","NORTH TRURO","NORTH WEYMOUTH","NORTHAMPTON","NORTHBOROUGH","NORTHBRIDGE","NORTHFIELD","NORTON","NORWELL","NORWOOD","OAK BLUFFS","OAKHAM","ONSET","ORANGE","ORLEANS","OSTERVILLE","OTIS","OXFORD","PALMER","PAXTON","PEABODY","PEMBROKE","PEPPERELL","PETERSHAM","PITTSFIELD","PLAINFIELD","PLAINVILLE","PLYMOUTH","PLYMPTON","POCASSET","PRINCETON","PROVINCETOWN","QUINCY","QUINCY","QUINCY","RANDOLPH","RAYNHAM","READING","REHOBOTH","REVERE","RICHMOND","ROCHDALE","ROCHESTER","ROCKLAND","ROCKPORT","ROSLINDALE","ROWE","ROWLEY","ROXBURY","ROXBURY CROSSING","ROYALSTON","RUSSELL","RUTLAND","SAGAMORE","SAGAMORE BEACH","SALEM","SALISBURY","SANDISFIELD","SANDWICH","SAUGUS","SAVOY","SCITUATE","SEEKONK","SHARON","SHEFFIELD","SHELBURNE FALLS","SHERBORN","SHIRLEY","SHREWSBURY","SHUTESBURY","SIASCONSET","SOMERSET","SOMERSET","SOMERVILLE","SOMERVILLE","SOMERVILLE","SOUTH CHATHAM","SOUTH DARTMOUTH","SOUTH DEERFIELD","SOUTH DENNIS","SOUTH EASTON","SOUTH EGREMONT","SOUTH GRAFTON","SOUTH HADLEY","SOUTH HAMILTON","SOUTH WALPOLE","SOUTH WELLFLEET","SOUTH WEYMOUTH","SOUTH YARMOUTH","SOUTHAMPTON","SOUTHBOROUGH","SOUTHBRIDGE","SOUTHFIELD","SOUTHWICK","SPENCER","SPRINGFIELD","SPRINGFIELD","SPRINGFIELD","SPRINGFIELD","SPRINGFIELD","SPRINGFIELD","SPRINGFIELD","SPRINGFIELD","SPRINGFIELD","SPRINGFIELD","STERLING","STOCKBRIDGE","STONEHAM","STOUGHTON","STOW","STURBRIDGE","SUDBURY","SUNDERLAND","SUTTON","SWAMPSCOTT","SWANSEA","TAUNTON","TEMPLETON","TEWKSBURY","THREE RIVERS","TOPSFIELD","TOWNSEND","TRURO","TURNERS FALLS","TYNGSBORO","TYRINGHAM","UPTON","UXBRIDGE","VILLAGE OF NAGOG WOODS","VINEYARD HAVEN","WABAN","WAKEFIELD","WALES","WALPOLE","WALTHAM","WALTHAM","WALTHAM","WARE","WARE","WAREHAM","WARREN","WARWICK","WATERTOWN","WAYLAND","WEBSTER","WELLESLEY","WELLESLEY HILLS","WELLFLEET","WENDELL","WENHAM","WEST BARNSTABLE","WEST BOYLSTON","WEST BRIDGEWATER","WEST BROOKFIELD","WEST CHESTERFIELD","WEST DENNIS","WEST HARWICH","WEST HATFIELD","WEST NEWBURY","WEST NEWTON","WEST ROXBURY","WEST SPRINGFIELD","WEST STOCKBRIDGE","WEST TOWNSEND","WEST WAREHAM","WEST WARREN","WEST YARMOUTH","WESTBOROUGH","WESTFIELD","WESTFORD","WESTMINSTER","WESTON","WESTPORT","WESTPORT POINT","WESTWOOD","WEYMOUTH","WHITINSVILLE","WHITMAN","WILBRAHAM","WILLIAMSBURG","WILLIAMSBURG","WILLIAMSTOWN","WILMINGTON","WINCHENDON","WINCHESTER","WINDSOR","WINTHROP","WOBURN","WOODS HOLE","WORCESTER","WORCESTER","WORCESTER","WORCESTER","WORCESTER","WORCESTER","WORCESTER","WORCESTER","WORCESTER","WORTHINGTON","WRENTHAM","YARMOUTH PORT"]
[]
[null,"Control Descriptions"]
[null,"Constant on"]
[null,"Cycle on/off"]
[null,"Two-speed"]
[null,"VFD, synchronized speed on all fans"]
[]
[]
[]
[]
[null,"Optimize Condenser Fans"]
[]
[null,"ZIP code name","ABINGTON","ACTON","ACUSHNET","ADAMS","AGAWAM","ALLSTON","AMESBURY","AMHERST","AMHERST","AMHERST","ANDOVER","ARLINGTON","ARLINGTON","ASHBURNHAM","ASHBY","ASHFIELD","ASHLAND","ASHLEY FALLS","ASSONET","ATHOL","ATTLEBORO","ATTLEBORO FALLS","AUBURN","AUBURNDALE","AVON","AYER","BALDWINVILLE","BARNSTABLE","BARRE","BECKET","BEDFORD","BELCHERTOWN","BELLINGHAM","BELMONT","BERKLEY","BERKSHIRE","BERLIN","BERNARDSTON","BEVERLY","BILLERICA","BLACKSTONE","BLANDFORD","BLANDFORD","BOLTON","BOSTON","BOSTON","BOSTON","BOSTON","BOSTON","BOSTON","BOSTON","BOSTON","BOSTON","BOSTON","BOSTON","BOSTON","BOSTON","BOSTON","BOSTON","BOSTON","BOXBOROUGH","BOXFORD","BOYLSTON","BRAINTREE","BREWSTER","BRIDGEWATER","BRIGHTON","BRIMFIELD","BRIMFIELD","BROCKTON","BROCKTON","BROOKFIELD","BROOKLINE","BROOKLINE","BUCKLAND","BURLINGTON","BUZZARDS BAY","BUZZARDS BAY","BUZZARDS BAY","BYFIELD","CAMBRIDGE","CAMBRIDGE","CAMBRIDGE","CAMBRIDGE","CAMBRIDGE","CANTON","CARLISLE","CARVER","CATAUMET","CENTERVILLE","CHARLEMONT","CHARLESTOWN","CHARLTON","CHATHAM","CHELMSFORD","CHELSEA","CHERRY VALLEY","CHESHIRE","CHESTER","CHESTER","CHESTERFIELD","CHESTNUT HILL","CHESTNUT HILL","CHESTNUT HILL","CHICOPEE","CHICOPEE","CHICOPEE","CHILMARK","CLINTON","COHASSET","COLRAIN","CONCORD","CONWAY","COTUIT","CUMMAQUID","CUMMINGTON","CUMMINGTON","CUTTYHUNK","DALTON","DANVERS","DEDHAM","DEERFIELD","DENNIS","DENNIS PORT","DEVENS","DEVENS","DIGHTON","DORCHESTER","DORCHESTER","DORCHESTER","DORCHESTER CENTER","DOUGLAS","DOVER","DRACUT","DRURY","DUDLEY","DUNSTABLE","DUXBURY","EAST BRIDGEWATER","EAST BROOKFIELD","EAST DENNIS","EAST FALMOUTH","EAST FREETOWN","EAST LONGMEADOW","EAST SANDWICH","EAST TAUNTON","EAST WALPOLE","EAST WAREHAM","EAST WEYMOUTH","EASTHAM","EASTHAMPTON","EDGARTOWN","ERVING","ESSEX","EVERETT","FAIRHAVEN","FALL RIVER","FALL RIVER","FALL RIVER","FALL RIVER","FALMOUTH","FAYVILLE","FEEDING HILLS","FISKDALE","FITCHBURG","FLORENCE","FORESTDALE","FOXBORO","FRAMINGHAM","FRAMINGHAM","FRANKLIN","GARDNER","GEORGETOWN","GILBERTVILLE","GILL","GLOUCESTER","GOSHEN","GRAFTON","GRANBY","GRANVILLE","GREAT BARRINGTON","GREENFIELD","GROTON","GROVELAND","HADLEY","HALIFAX","HAMPDEN","HANOVER","HANSCOM AFB","HANSON","HARDWICK","HARVARD","HARWICH","HARWICH PORT","HATFIELD","HAVERHILL","HAVERHILL","HAVERHILL","HAYDENVILLE","HAYDENVILLE","HEATH","HINGHAM","HINSDALE","HINSDALE","HOLBROOK","HOLDEN","HOLLAND","HOLLISTON","HOLYOKE","HOPEDALE","HOPKINTON","HOUSATONIC","HUBBARDSTON","HUDSON","HULL","HUNTINGTON","HUNTINGTON","HYANNIS","HYANNIS PORT","HYDE PARK","INDIAN ORCHARD","IPSWICH","JAMAICA PLAIN","JEFFERSON","KINGSTON","LAKEVILLE","LANCASTER","LANESBORO","LAWRENCE","LAWRENCE","LAWRENCE","LEE","LEEDS","LEICESTER","LENOX","LEOMINSTER","LEVERETT","LEXINGTON","LEXINGTON","LINCOLN","LITTLETON","LONGMEADOW","LOWELL","LOWELL","LOWELL","LOWELL","LUDLOW","LUNENBURG","LYNN","LYNN","LYNN","LYNN","LYNNFIELD","MALDEN","MANCHESTER","MANSFIELD","MARBLEHEAD","MARION","MARLBOROUGH","MARSHFIELD","MARSTONS MILLS","MASHPEE","MATTAPAN","MATTAPOISETT","MAYNARD","MEDFIELD","MEDFORD","MEDWAY","MELROSE","MENDON","MERRIMAC","METHUEN","MIDDLEBORO","MIDDLETON","MILFORD","MILLBURY","MILLERS FALLS","MILLIS","MILLVILLE","MILTON","MONROE BRIDGE","MONSON","MONTAGUE","MONTEREY","MONUMENT BEACH","NAHANT","NANTUCKET","NATICK","NEEDHAM","NEEDHAM HEIGHTS","NEW BEDFORD","NEW BEDFORD","NEW BEDFORD","NEW BEDFORD","NEW BRAINTREE","NEW SALEM","NEWBURY","NEWBURYPORT","NEWTON","NEWTON CENTER","NEWTON HIGHLANDS","NEWTON LOWER FALLS","NEWTON UPPER FALLS","NEWTONVILLE","NORFOLK","NORTH ADAMS","NORTH ADAMS","NORTH ANDOVER","NORTH ATTLEBORO","NORTH BILLERICA","NORTH BROOKFIELD","NORTH CHATHAM","NORTH CHELMSFORD","NORTH DARTMOUTH","NORTH DIGHTON","NORTH EASTON","NORTH FALMOUTH","NORTH GRAFTON","NORTH OXFORD","NORTH READING","NORTH TRURO","NORTH WEYMOUTH","NORTHAMPTON","NORTHBOROUGH","NORTHBRIDGE","NORTHFIELD","NORTON","NORWELL","NORWOOD","OAK BLUFFS","OAKHAM","ONSET","ORANGE","ORLEANS","OSTERVILLE","OTIS","OXFORD","PALMER","PAXTON","PEABODY","PEMBROKE","PEPPERELL","PETERSHAM","PITTSFIELD","PLAINFIELD","PLAINVILLE","PLYMOUTH","PLYMPTON","POCASSET","PRINCETON","PROVINCETOWN","QUINCY","QUINCY","QUINCY","RANDOLPH","RAYNHAM","READING","REHOBOTH","REVERE","RICHMOND","ROCHDALE","ROCHESTER","ROCKLAND","ROCKPORT","ROSLINDALE","ROWE","ROWLEY","ROXBURY","ROXBURY CROSSING","ROYALSTON","RUSSELL","RUTLAND","SAGAMORE","SAGAMORE BEACH","SALEM","SALISBURY","SANDISFIELD","SANDWICH","SAUGUS","SAVOY","SCITUATE","SEEKONK","SHARON","SHEFFIELD","SHELBURNE FALLS","SHERBORN","SHIRLEY","SHREWSBURY","SHUTESBURY","SIASCONSET","SOMERSET","SOMERSET","SOMERVILLE","SOMERVILLE","SOMERVILLE","SOUTH CHATHAM","SOUTH DARTMOUTH","SOUTH DEERFIELD","SOUTH DENNIS","SOUTH EASTON","SOUTH EGREMONT","SOUTH GRAFTON","SOUTH HADLEY","SOUTH HAMILTON","SOUTH WALPOLE","SOUTH WELLFLEET","SOUTH WEYMOUTH","SOUTH YARMOUTH","SOUTHAMPTON","SOUTHBOROUGH","SOUTHBRIDGE","SOUTHFIELD","SOUTHWICK","SPENCER","SPRINGFIELD","SPRINGFIELD","SPRINGFIELD","SPRINGFIELD","SPRINGFIELD","SPRINGFIELD","SPRINGFIELD","SPRINGFIELD","SPRINGFIELD","SPRINGFIELD","STERLING","STOCKBRIDGE","STONEHAM","STOUGHTON","STOW","STURBRIDGE","SUDBURY","SUNDERLAND","SUTTON","SWAMPSCOTT","SWANSEA","TAUNTON","TEMPLETON","TEWKSBURY","THREE RIVERS","TOPSFIELD","TOWNSEND","TRURO","TURNERS FALLS","TYNGSBORO","TYRINGHAM","UPTON","UXBRIDGE","VILLAGE OF NAGOG WOODS","VINEYARD HAVEN","WABAN","WAKEFIELD","WALES","WALPOLE","WALTHAM","WALTHAM","WALTHAM","WARE","WARE","WAREHAM","WARREN","WARWICK","WATERTOWN","WAYLAND","WEBSTER","WELLESLEY","WELLESLEY HILLS","WELLFLEET","WENDELL","WENHAM","WEST BARNSTABLE","WEST BOYLSTON","WEST BRIDGEWATER","WEST BROOKFIELD","WEST CHESTERFIELD","WEST DENNIS","WEST HARWICH","WEST HATFIELD","WEST NEWBURY","WEST NEWTON","WEST ROXBURY","WEST SPRINGFIELD","WEST STOCKBRIDGE","WEST TOWNSEND","WEST WAREHAM","WEST WARREN","WEST YARMOUTH","WESTBOROUGH","WESTFIELD","WESTFORD","WESTMINSTER","WESTON","WESTPORT","WESTPORT POINT","WESTWOOD","WEYMOUTH","WHITINSVILLE","WHITMAN","WILBRAHAM","WILLIAMSBURG","WILLIAMSBURG","WILLIAMSTOWN","WILMINGTON","WINCHENDON","WINCHESTER","WINDSOR","WINTHROP","WOBURN","WOODS HOLE","WORCESTER","WORCESTER","WORCESTER","WORCESTER","WORCESTER","WORCESTER","WORCESTER","WORCESTER","WORCESTER","WORTHINGTON","WRENTHAM","YARMOUTH PORT"]
[]
[]
[]
[null,"Lower Condenser Pressure"]
[]
[null,"ZIP code name","ABINGTON","ACTON","ACUSHNET","ADAMS","AGAWAM","ALLSTON","AMESBURY","AMHERST","AMHERST","AMHERST","ANDOVER","ARLINGTON","ARLINGTON","ASHBURNHAM","ASHBY","ASHFIELD","ASHLAND","ASHLEY FALLS","ASSONET","ATHOL","ATTLEBORO","ATTLEBORO FALLS","AUBURN","AUBURNDALE","AVON","AYER","BALDWINVILLE","BARNSTABLE","BARRE","BECKET","BEDFORD","BELCHERTOWN","BELLINGHAM","BELMONT","BERKLEY","BERKSHIRE","BERLIN","BERNARDSTON","BEVERLY","BILLERICA","BLACKSTONE","BLANDFORD","BLANDFORD","BOLTON","BOSTON","BOSTON","BOSTON","BOSTON","BOSTON","BOSTON","BOSTON","BOSTON","BOSTON","BOSTON","BOSTON","BOSTON","BOSTON","BOSTON","BOSTON","BOSTON","BOXBOROUGH","BOXFORD","BOYLSTON","BRAINTREE","BREWSTER","BRIDGEWATER","BRIGHTON","BRIMFIELD","BRIMFIELD","BROCKTON","BROCKTON","BROOKFIELD","BROOKLINE","BROOKLINE","BUCKLAND","BURLINGTON","BUZZARDS BAY","BUZZARDS BAY","BUZZARDS BAY","BYFIELD","CAMBRIDGE","CAMBRIDGE","CAMBRIDGE","CAMBRIDGE","CAMBRIDGE","CANTON","CARLISLE","CARVER","CATAUMET","CENTERVILLE","CHARLEMONT","CHARLESTOWN","CHARLTON","CHATHAM","CHELMSFORD","CHELSEA","CHERRY VALLEY","CHESHIRE","CHESTER","CHESTER","CHESTERFIELD","CHESTNUT HILL","CHESTNUT HILL","CHESTNUT HILL","CHICOPEE","CHICOPEE","CHICOPEE","CHILMARK","CLINTON","COHASSET","COLRAIN","CONCORD","CONWAY","COTUIT","CUMMAQUID","CUMMINGTON","CUMMINGTON","CUTTYHUNK","DALTON","DANVERS","DEDHAM","DEERFIELD","DENNIS","DENNIS PORT","DEVENS","DEVENS","DIGHTON","DORCHESTER","DORCHESTER","DORCHESTER","DORCHESTER CENTER","DOUGLAS","DOVER","DRACUT","DRURY","DUDLEY","DUNSTABLE","DUXBURY","EAST BRIDGEWATER","EAST BROOKFIELD","EAST DENNIS","EAST FALMOUTH","EAST FREETOWN","EAST LONGMEADOW","EAST SANDWICH","EAST TAUNTON","EAST WALPOLE","EAST WAREHAM","EAST WEYMOUTH","EASTHAM","EASTHAMPTON","EDGARTOWN","ERVING","ESSEX","EVERETT","FAIRHAVEN","FALL RIVER","FALL RIVER","FALL RIVER","FALL RIVER","FALMOUTH","FAYVILLE","FEEDING HILLS","FISKDALE","FITCHBURG","FLORENCE","FORESTDALE","FOXBORO","FRAMINGHAM","FRAMINGHAM","FRANKLIN","GARDNER","GEORGETOWN","GILBERTVILLE","GILL","GLOUCESTER","GOSHEN","GRAFTON","GRANBY","GRANVILLE","GREAT BARRINGTON","GREENFIELD","GROTON","GROVELAND","HADLEY","HALIFAX","HAMPDEN","HANOVER","HANSCOM AFB","HANSON","HARDWICK","HARVARD","HARWICH","HARWICH PORT","HATFIELD","HAVERHILL","HAVERHILL","HAVERHILL","HAYDENVILLE","HAYDENVILLE","HEATH","HINGHAM","HINSDALE","HINSDALE","HOLBROOK","HOLDEN","HOLLAND","HOLLISTON","HOLYOKE","HOPEDALE","HOPKINTON","HOUSATONIC","HUBBARDSTON","HUDSON","HULL","HUNTINGTON","HUNTINGTON","HYANNIS","HYANNIS PORT","HYDE PARK","INDIAN ORCHARD","IPSWICH","JAMAICA PLAIN","JEFFERSON","KINGSTON","LAKEVILLE","LANCASTER","LANESBORO","LAWRENCE","LAWRENCE","LAWRENCE","LEE","LEEDS","LEICESTER","LENOX","LEOMINSTER","LEVERETT","LEXINGTON","LEXINGTON","LINCOLN","LITTLETON","LONGMEADOW","LOWELL","LOWELL","LOWELL","LOWELL","LUDLOW","LUNENBURG","LYNN","LYNN","LYNN","LYNN","LYNNFIELD","MALDEN","MANCHESTER","MANSFIELD","MARBLEHEAD","MARION","MARLBOROUGH","MARSHFIELD","MARSTONS MILLS","MASHPEE","MATTAPAN","MATTAPOISETT","MAYNARD","MEDFIELD","MEDFORD","MEDWAY","MELROSE","MENDON","MERRIMAC","METHUEN","MIDDLEBORO","MIDDLETON","MILFORD","MILLBURY","MILLERS FALLS","MILLIS","MILLVILLE","MILTON","MONROE BRIDGE","MONSON","MONTAGUE","MONTEREY","MONUMENT BEACH","NAHANT","NANTUCKET","NATICK","NEEDHAM","NEEDHAM HEIGHTS","NEW BEDFORD","NEW BEDFORD","NEW BEDFORD","NEW BEDFORD","NEW BRAINTREE","NEW SALEM","NEWBURY","NEWBURYPORT","NEWTON","NEWTON CENTER","NEWTON HIGHLANDS","NEWTON LOWER FALLS","NEWTON UPPER FALLS","NEWTONVILLE","NORFOLK","NORTH ADAMS","NORTH ADAMS","NORTH ANDOVER","NORTH ATTLEBORO","NORTH BILLERICA","NORTH BROOKFIELD","NORTH CHATHAM","NORTH CHELMSFORD","NORTH DARTMOUTH","NORTH DIGHTON","NORTH EASTON","NORTH FALMOUTH","NORTH GRAFTON","NORTH OXFORD","NORTH READING","NORTH TRURO","NORTH WEYMOUTH","NORTHAMPTON","NORTHBOROUGH","NORTHBRIDGE","NORTHFIELD","NORTON","NORWELL","NORWOOD","OAK BLUFFS","OAKHAM","ONSET","ORANGE","ORLEANS","OSTERVILLE","OTIS","OXFORD","PALMER","PAXTON","PEABODY","PEMBROKE","PEPPERELL","PETERSHAM","PITTSFIELD","PLAINFIELD","PLAINVILLE","PLYMOUTH","PLYMPTON","POCASSET","PRINCETON","PROVINCETOWN","QUINCY","QUINCY","QUINCY","RANDOLPH","RAYNHAM","READING","REHOBOTH","REVERE","RICHMOND","ROCHDALE","ROCHESTER","ROCKLAND","ROCKPORT","ROSLINDALE","ROWE","ROWLEY","ROXBURY","ROXBURY CROSSING","ROYALSTON","RUSSELL","RUTLAND","SAGAMORE","SAGAMORE BEACH","SALEM","SALISBURY","SANDISFIELD","SANDWICH","SAUGUS","SAVOY","SCITUATE","SEEKONK","SHARON","SHEFFIELD","SHELBURNE FALLS","SHERBORN","SHIRLEY","SHREWSBURY","SHUTESBURY","SIASCONSET","SOMERSET","SOMERSET","SOMERVILLE","SOMERVILLE","SOMERVILLE","SOUTH CHATHAM","SOUTH DARTMOUTH","SOUTH DEERFIELD","SOUTH DENNIS","SOUTH EASTON","SOUTH EGREMONT","SOUTH GRAFTON","SOUTH HADLEY","SOUTH HAMILTON","SOUTH WALPOLE","SOUTH WELLFLEET","SOUTH WEYMOUTH","SOUTH YARMOUTH","SOUTHAMPTON","SOUTHBOROUGH","SOUTHBRIDGE","SOUTHFIELD","SOUTHWICK","SPENCER","SPRINGFIELD","SPRINGFIELD","SPRINGFIELD","SPRINGFIELD","SPRINGFIELD","SPRINGFIELD","SPRINGFIELD","SPRINGFIELD","SPRINGFIELD","SPRINGFIELD","STERLING","STOCKBRIDGE","STONEHAM","STOUGHTON","STOW","STURBRIDGE","SUDBURY","SUNDERLAND","SUTTON","SWAMPSCOTT","SWANSEA","TAUNTON","TEMPLETON","TEWKSBURY","THREE RIVERS","TOPSFIELD","TOWNSEND","TRURO","TURNERS FALLS","TYNGSBORO","TYRINGHAM","UPTON","UXBRIDGE","VILLAGE OF NAGOG WOODS","VINEYARD HAVEN","WABAN","WAKEFIELD","WALES","WALPOLE","WALTHAM","WALTHAM","WALTHAM","WARE","WARE","WAREHAM","WARREN","WARWICK","WATERTOWN","WAYLAND","WEBSTER","WELLESLEY","WELLESLEY HILLS","WELLFLEET","WENDELL","WENHAM","WEST BARNSTABLE","WEST BOYLSTON","WEST BRIDGEWATER","WEST BROOKFIELD","WEST CHESTERFIELD","WEST DENNIS","WEST HARWICH","WEST HATFIELD","WEST NEWBURY","WEST NEWTON","WEST ROXBURY","WEST SPRINGFIELD","WEST STOCKBRIDGE","WEST TOWNSEND","WEST WAREHAM","WEST WARREN","WEST YARMOUTH","WESTBOROUGH","WESTFIELD","WESTFORD","WESTMINSTER","WESTON","WESTPORT","WESTPORT POINT","WESTWOOD","WEYMOUTH","WHITINSVILLE","WHITMAN","WILBRAHAM","WILLIAMSBURG","WILLIAMSBURG","WILLIAMSTOWN","WILMINGTON","WINCHENDON","WINCHESTER","WINDSOR","WINTHROP","WOBURN","WOODS HOLE","WORCESTER","WORCESTER","WORCESTER","WORCESTER","WORCESTER","WORCESTER","WORCESTER","WORCESTER","WORCESTER","WORTHINGTON","WRENTHAM","YARMOUTH PORT"]
[]
[]
[]
[null,"Optimize Floating Head Pressue"]
[]
[null,"ZIP code name","ABINGTON","ACTON","ACUSHNET","ADAMS","AGAWAM","ALLSTON","AMESBURY","AMHERST","AMHERST","AMHERST","ANDOVER","ARLINGTON","ARLINGTON","ASHBURNHAM","ASHBY","ASHFIELD","ASHLAND","ASHLEY FALLS","ASSONET","ATHOL","ATTLEBORO","ATTLEBORO FALLS","AUBURN","AUBURNDALE","AVON","AYER","BALDWINVILLE","BARNSTABLE","BARRE","BECKET","BEDFORD","BELCHERTOWN","BELLINGHAM","BELMONT","BERKLEY","BERKSHIRE","BERLIN","BERNARDSTON","BEVERLY","BILLERICA","BLACKSTONE","BLANDFORD","BLANDFORD","BOLTON","BOSTON","BOSTON","BOSTON","BOSTON","BOSTON","BOSTON","BOSTON","BOSTON","BOSTON","BOSTON","BOSTON","BOSTON","BOSTON","BOSTON","BOSTON","BOSTON","BOXBOROUGH","BOXFORD","BOYLSTON","BRAINTREE","BREWSTER","BRIDGEWATER","BRIGHTON","BRIMFIELD","BRIMFIELD","BROCKTON","BROCKTON","BROOKFIELD","BROOKLINE","BROOKLINE","BUCKLAND","BURLINGTON","BUZZARDS BAY","BUZZARDS BAY","BUZZARDS BAY","BYFIELD","CAMBRIDGE","CAMBRIDGE","CAMBRIDGE","CAMBRIDGE","CAMBRIDGE","CANTON","CARLISLE","CARVER","CATAUMET","CENTERVILLE","CHARLEMONT","CHARLESTOWN","CHARLTON","CHATHAM","CHELMSFORD","CHELSEA","CHERRY VALLEY","CHESHIRE","CHESTER","CHESTER","CHESTERFIELD","CHESTNUT HILL","CHESTNUT HILL","CHESTNUT HILL","CHICOPEE","CHICOPEE","CHICOPEE","CHILMARK","CLINTON","COHASSET","COLRAIN","CONCORD","CONWAY","COTUIT","CUMMAQUID","CUMMINGTON","CUMMINGTON","CUTTYHUNK","DALTON","DANVERS","DEDHAM","DEERFIELD","DENNIS","DENNIS PORT","DEVENS","DEVENS","DIGHTON","DORCHESTER","DORCHESTER","DORCHESTER","DORCHESTER CENTER","DOUGLAS","DOVER","DRACUT","DRURY","DUDLEY","DUNSTABLE","DUXBURY","EAST BRIDGEWATER","EAST BROOKFIELD","EAST DENNIS","EAST FALMOUTH","EAST FREETOWN","EAST LONGMEADOW","EAST SANDWICH","EAST TAUNTON","EAST WALPOLE","EAST WAREHAM","EAST WEYMOUTH","EASTHAM","EASTHAMPTON","EDGARTOWN","ERVING","ESSEX","EVERETT","FAIRHAVEN","FALL RIVER","FALL RIVER","FALL RIVER","FALL RIVER","FALMOUTH","FAYVILLE","FEEDING HILLS","FISKDALE","FITCHBURG","FLORENCE","FORESTDALE","FOXBORO","FRAMINGHAM","FRAMINGHAM","FRANKLIN","GARDNER","GEORGETOWN","GILBERTVILLE","GILL","GLOUCESTER","GOSHEN","GRAFTON","GRANBY","GRANVILLE","GREAT BARRINGTON","GREENFIELD","GROTON","GROVELAND","HADLEY","HALIFAX","HAMPDEN","HANOVER","HANSCOM AFB","HANSON","HARDWICK","HARVARD","HARWICH","HARWICH PORT","HATFIELD","HAVERHILL","HAVERHILL","HAVERHILL","HAYDENVILLE","HAYDENVILLE","HEATH","HINGHAM","HINSDALE","HINSDALE","HOLBROOK","HOLDEN","HOLLAND","HOLLISTON","HOLYOKE","HOPEDALE","HOPKINTON","HOUSATONIC","HUBBARDSTON","HUDSON","HULL","HUNTINGTON","HUNTINGTON","HYANNIS","HYANNIS PORT","HYDE PARK","INDIAN ORCHARD","IPSWICH","JAMAICA PLAIN","JEFFERSON","KINGSTON","LAKEVILLE","LANCASTER","LANESBORO","LAWRENCE","LAWRENCE","LAWRENCE","LEE","LEEDS","LEICESTER","LENOX","LEOMINSTER","LEVERETT","LEXINGTON","LEXINGTON","LINCOLN","LITTLETON","LONGMEADOW","LOWELL","LOWELL","LOWELL","LOWELL","LUDLOW","LUNENBURG","LYNN","LYNN","LYNN","LYNN","LYNNFIELD","MALDEN","MANCHESTER","MANSFIELD","MARBLEHEAD","MARION","MARLBOROUGH","MARSHFIELD","MARSTONS MILLS","MASHPEE","MATTAPAN","MATTAPOISETT","MAYNARD","MEDFIELD","MEDFORD","MEDWAY","MELROSE","MENDON","MERRIMAC","METHUEN","MIDDLEBORO","MIDDLETON","MILFORD","MILLBURY","MILLERS FALLS","MILLIS","MILLVILLE","MILTON","MONROE BRIDGE","MONSON","MONTAGUE","MONTEREY","MONUMENT BEACH","NAHANT","NANTUCKET","NATICK","NEEDHAM","NEEDHAM HEIGHTS","NEW BEDFORD","NEW BEDFORD","NEW BEDFORD","NEW BEDFORD","NEW BRAINTREE","NEW SALEM","NEWBURY","NEWBURYPORT","NEWTON","NEWTON CENTER","NEWTON HIGHLANDS","NEWTON LOWER FALLS","NEWTON UPPER FALLS","NEWTONVILLE","NORFOLK","NORTH ADAMS","NORTH ADAMS","NORTH ANDOVER","NORTH ATTLEBORO","NORTH BILLERICA","NORTH BROOKFIELD","NORTH CHATHAM","NORTH CHELMSFORD","NORTH DARTMOUTH","NORTH DIGHTON","NORTH EASTON","NORTH FALMOUTH","NORTH GRAFTON","NORTH OXFORD","NORTH READING","NORTH TRURO","NORTH WEYMOUTH","NORTHAMPTON","NORTHBOROUGH","NORTHBRIDGE","NORTHFIELD","NORTON","NORWELL","NORWOOD","OAK BLUFFS","OAKHAM","ONSET","ORANGE","ORLEANS","OSTERVILLE","OTIS","OXFORD","PALMER","PAXTON","PEABODY","PEMBROKE","PEPPERELL","PETERSHAM","PITTSFIELD","PLAINFIELD","PLAINVILLE","PLYMOUTH","PLYMPTON","POCASSET","PRINCETON","PROVINCETOWN","QUINCY","QUINCY","QUINCY","RANDOLPH","RAYNHAM","READING","REHOBOTH","REVERE","RICHMOND","ROCHDALE","ROCHESTER","ROCKLAND","ROCKPORT","ROSLINDALE","ROWE","ROWLEY","ROXBURY","ROXBURY CROSSING","ROYALSTON","RUSSELL","RUTLAND","SAGAMORE","SAGAMORE BEACH","SALEM","SALISBURY","SANDISFIELD","SANDWICH","SAUGUS","SAVOY","SCITUATE","SEEKONK","SHARON","SHEFFIELD","SHELBURNE FALLS","SHERBORN","SHIRLEY","SHREWSBURY","SHUTESBURY","SIASCONSET","SOMERSET","SOMERSET","SOMERVILLE","SOMERVILLE","SOMERVILLE","SOUTH CHATHAM","SOUTH DARTMOUTH","SOUTH DEERFIELD","SOUTH DENNIS","SOUTH EASTON","SOUTH EGREMONT","SOUTH GRAFTON","SOUTH HADLEY","SOUTH HAMILTON","SOUTH WALPOLE","SOUTH WELLFLEET","SOUTH WEYMOUTH","SOUTH YARMOUTH","SOUTHAMPTON","SOUTHBOROUGH","SOUTHBRIDGE","SOUTHFIELD","SOUTHWICK","SPENCER","SPRINGFIELD","SPRINGFIELD","SPRINGFIELD","SPRINGFIELD","SPRINGFIELD","SPRINGFIELD","SPRINGFIELD","SPRINGFIELD","SPRINGFIELD","SPRINGFIELD","STERLING","STOCKBRIDGE","STONEHAM","STOUGHTON","STOW","STURBRIDGE","SUDBURY","SUNDERLAND","SUTTON","SWAMPSCOTT","SWANSEA","TAUNTON","TEMPLETON","TEWKSBURY","THREE RIVERS","TOPSFIELD","TOWNSEND","TRURO","TURNERS FALLS","TYNGSBORO","TYRINGHAM","UPTON","UXBRIDGE","VILLAGE OF NAGOG WOODS","VINEYARD HAVEN","WABAN","WAKEFIELD","WALES","WALPOLE","WALTHAM","WALTHAM","WALTHAM","WARE","WARE","WAREHAM","WARREN","WARWICK","WATERTOWN","WAYLAND","WEBSTER","WELLESLEY","WELLESLEY HILLS","WELLFLEET","WENDELL","WENHAM","WEST BARNSTABLE","WEST BOYLSTON","WEST BRIDGEWATER","WEST BROOKFIELD","WEST CHESTERFIELD","WEST DENNIS","WEST HARWICH","WEST HATFIELD","WEST NEWBURY","WEST NEWTON","WEST ROXBURY","WEST SPRINGFIELD","WEST STOCKBRIDGE","WEST TOWNSEND","WEST WAREHAM","WEST WARREN","WEST YARMOUTH","WESTBOROUGH","WESTFIELD","WESTFORD","WESTMINSTER","WESTON","WESTPORT","WESTPORT POINT","WESTWOOD","WEYMOUTH","WHITINSVILLE","WHITMAN","WILBRAHAM","WILLIAMSBURG","WILLIAMSBURG","WILLIAMSTOWN","WILMINGTON","WINCHENDON","WINCHESTER","WINDSOR","WINTHROP","WOBURN","WOODS HOLE","WORCESTER","WORCESTER","WORCESTER","WORCESTER","WORCESTER","WORCESTER","WORCESTER","WORCESTER","WORCESTER","WORTHINGTON","WRENTHAM","YARMOUTH PORT"]
[]
[]
[]
[]
[]
[null,"ZIP code name","ABINGTON","ACTON","ACUSHNET","ADAMS","AGAWAM","ALLSTON","AMESBURY","AMHERST","AMHERST","AMHERST","ANDOVER","ARLINGTON","ARLINGTON","ASHBURNHAM","ASHBY","ASHFIELD","ASHLAND","ASHLEY FALLS","ASSONET","ATHOL","ATTLEBORO","ATTLEBORO FALLS","AUBURN","AUBURNDALE","AVON","AYER","BALDWINVILLE","BARNSTABLE","BARRE","BECKET","BEDFORD","BELCHERTOWN","BELLINGHAM","BELMONT","BERKLEY","BERKSHIRE","BERLIN","BERNARDSTON","BEVERLY","BILLERICA","BLACKSTONE","BLANDFORD","BLANDFORD","BOLTON","BOSTON","BOSTON","BOSTON","BOSTON","BOSTON","BOSTON","BOSTON","BOSTON","BOSTON","BOSTON","BOSTON","BOSTON","BOSTON","BOSTON","BOSTON","BOSTON","BOXBOROUGH","BOXFORD","BOYLSTON","BRAINTREE","BREWSTER","BRIDGEWATER","BRIGHTON","BRIMFIELD","BRIMFIELD","BROCKTON","BROCKTON","BROOKFIELD","BROOKLINE","BROOKLINE","BUCKLAND","BURLINGTON","BUZZARDS BAY","BUZZARDS BAY","BUZZARDS BAY","BYFIELD","CAMBRIDGE","CAMBRIDGE","CAMBRIDGE","CAMBRIDGE","CAMBRIDGE","CANTON","CARLISLE","CARVER","CATAUMET","CENTERVILLE","CHARLEMONT","CHARLESTOWN","CHARLTON","CHATHAM","CHELMSFORD","CHELSEA","CHERRY VALLEY","CHESHIRE","CHESTER","CHESTER","CHESTERFIELD","CHESTNUT HILL","CHESTNUT HILL","CHESTNUT HILL","CHICOPEE","CHICOPEE","CHICOPEE","CHILMARK","CLINTON","COHASSET","COLRAIN","CONCORD","CONWAY","COTUIT","CUMMAQUID","CUMMINGTON","CUMMINGTON","CUTTYHUNK","DALTON","DANVERS","DEDHAM","DEERFIELD","DENNIS","DENNIS PORT","DEVENS","DEVENS","DIGHTON","DORCHESTER","DORCHESTER","DORCHESTER","DORCHESTER CENTER","DOUGLAS","DOVER","DRACUT","DRURY","DUDLEY","DUNSTABLE","DUXBURY","EAST BRIDGEWATER","EAST BROOKFIELD","EAST DENNIS","EAST FALMOUTH","EAST FREETOWN","EAST LONGMEADOW","EAST SANDWICH","EAST TAUNTON","EAST WALPOLE","EAST WAREHAM","EAST WEYMOUTH","EASTHAM","EASTHAMPTON","EDGARTOWN","ERVING","ESSEX","EVERETT","FAIRHAVEN","FALL RIVER","FALL RIVER","FALL RIVER","FALL RIVER","FALMOUTH","FAYVILLE","FEEDING HILLS","FISKDALE","FITCHBURG","FLORENCE","FORESTDALE","FOXBORO","FRAMINGHAM","FRAMINGHAM","FRANKLIN","GARDNER","GEORGETOWN","GILBERTVILLE","GILL","GLOUCESTER","GOSHEN","GRAFTON","GRANBY","GRANVILLE","GREAT BARRINGTON","GREENFIELD","GROTON","GROVELAND","HADLEY","HALIFAX","HAMPDEN","HANOVER","HANSCOM AFB","HANSON","HARDWICK","HARVARD","HARWICH","HARWICH PORT","HATFIELD","HAVERHILL","HAVERHILL","HAVERHILL","HAYDENVILLE","HAYDENVILLE","HEATH","HINGHAM","HINSDALE","HINSDALE","HOLBROOK","HOLDEN","HOLLAND","HOLLISTON","HOLYOKE","HOPEDALE","HOPKINTON","HOUSATONIC","HUBBARDSTON","HUDSON","HULL","HUNTINGTON","HUNTINGTON","HYANNIS","HYANNIS PORT","HYDE PARK","INDIAN ORCHARD","IPSWICH","JAMAICA PLAIN","JEFFERSON","KINGSTON","LAKEVILLE","LANCASTER","LANESBORO","LAWRENCE","LAWRENCE","LAWRENCE","LEE","LEEDS","LEICESTER","LENOX","LEOMINSTER","LEVERETT","LEXINGTON","LEXINGTON","LINCOLN","LITTLETON","LONGMEADOW","LOWELL","LOWELL","LOWELL","LOWELL","LUDLOW","LUNENBURG","LYNN","LYNN","LYNN","LYNN","LYNNFIELD","MALDEN","MANCHESTER","MANSFIELD","MARBLEHEAD","MARION","MARLBOROUGH","MARSHFIELD","MARSTONS MILLS","MASHPEE","MATTAPAN","MATTAPOISETT","MAYNARD","MEDFIELD","MEDFORD","MEDWAY","MELROSE","MENDON","MERRIMAC","METHUEN","MIDDLEBORO","MIDDLETON","MILFORD","MILLBURY","MILLERS FALLS","MILLIS","MILLVILLE","MILTON","MONROE BRIDGE","MONSON","MONTAGUE","MONTEREY","MONUMENT BEACH","NAHANT","NANTUCKET","NATICK","NEEDHAM","NEEDHAM HEIGHTS","NEW BEDFORD","NEW BEDFORD","NEW BEDFORD","NEW BEDFORD","NEW BRAINTREE","NEW SALEM","NEWBURY","NEWBURYPORT","NEWTON","NEWTON CENTER","NEWTON HIGHLANDS","NEWTON LOWER FALLS","NEWTON UPPER FALLS","NEWTONVILLE","NORFOLK","NORTH ADAMS","NORTH ADAMS","NORTH ANDOVER","NORTH ATTLEBORO","NORTH BILLERICA","NORTH BROOKFIELD","NORTH CHATHAM","NORTH CHELMSFORD","NORTH DARTMOUTH","NORTH DIGHTON","NORTH EASTON","NORTH FALMOUTH","NORTH GRAFTON","NORTH OXFORD","NORTH READING","NORTH TRURO","NORTH WEYMOUTH","NORTHAMPTON","NORTHBOROUGH","NORTHBRIDGE","NORTHFIELD","NORTON","NORWELL","NORWOOD","OAK BLUFFS","OAKHAM","ONSET","ORANGE","ORLEANS","OSTERVILLE","OTIS","OXFORD","PALMER","PAXTON","PEABODY","PEMBROKE","PEPPERELL","PETERSHAM","PITTSFIELD","PLAINFIELD","PLAINVILLE","PLYMOUTH","PLYMPTON","POCASSET","PRINCETON","PROVINCETOWN","QUINCY","QUINCY","QUINCY","RANDOLPH","RAYNHAM","READING","REHOBOTH","REVERE","RICHMOND","ROCHDALE","ROCHESTER","ROCKLAND","ROCKPORT","ROSLINDALE","ROWE","ROWLEY","ROXBURY","ROXBURY CROSSING","ROYALSTON","RUSSELL","RUTLAND","SAGAMORE","SAGAMORE BEACH","SALEM","SALISBURY","SANDISFIELD","SANDWICH","SAUGUS","SAVOY","SCITUATE","SEEKONK","SHARON","SHEFFIELD","SHELBURNE FALLS","SHERBORN","SHIRLEY","SHREWSBURY","SHUTESBURY","SIASCONSET","SOMERSET","SOMERSET","SOMERVILLE","SOMERVILLE","SOMERVILLE","SOUTH CHATHAM","SOUTH DARTMOUTH","SOUTH DEERFIELD","SOUTH DENNIS","SOUTH EASTON","SOUTH EGREMONT","SOUTH GRAFTON","SOUTH HADLEY","SOUTH HAMILTON","SOUTH WALPOLE","SOUTH WELLFLEET","SOUTH WEYMOUTH","SOUTH YARMOUTH","SOUTHAMPTON","SOUTHBOROUGH","SOUTHBRIDGE","SOUTHFIELD","SOUTHWICK","SPENCER","SPRINGFIELD","SPRINGFIELD","SPRINGFIELD","SPRINGFIELD","SPRINGFIELD","SPRINGFIELD","SPRINGFIELD","SPRINGFIELD","SPRINGFIELD","SPRINGFIELD","STERLING","STOCKBRIDGE","STONEHAM","STOUGHTON","STOW","STURBRIDGE","SUDBURY","SUNDERLAND","SUTTON","SWAMPSCOTT","SWANSEA","TAUNTON","TEMPLETON","TEWKSBURY","THREE RIVERS","TOPSFIELD","TOWNSEND","TRURO","TURNERS FALLS","TYNGSBORO","TYRINGHAM","UPTON","UXBRIDGE","VILLAGE OF NAGOG WOODS","VINEYARD HAVEN","WABAN","WAKEFIELD","WALES","WALPOLE","WALTHAM","WALTHAM","WALTHAM","WARE","WARE","WAREHAM","WARREN","WARWICK","WATERTOWN","WAYLAND","WEBSTER","WELLESLEY","WELLESLEY HILLS","WELLFLEET","WENDELL","WENHAM","WEST BARNSTABLE","WEST BOYLSTON","WEST BRIDGEWATER","WEST BROOKFIELD","WEST CHESTERFIELD","WEST DENNIS","WEST HARWICH","WEST HATFIELD","WEST NEWBURY","WEST NEWTON","WEST ROXBURY","WEST SPRINGFIELD","WEST STOCKBRIDGE","WEST TOWNSEND","WEST WAREHAM","WEST WARREN","WEST YARMOUTH","WESTBOROUGH","WESTFIELD","WESTFORD","WESTMINSTER","WESTON","WESTPORT","WESTPORT POINT","WESTWOOD","WEYMOUTH","WHITINSVILLE","WHITMAN","WILBRAHAM","WILLIAMSBURG","WILLIAMSBURG","WILLIAMSTOWN","WILMINGTON","WINCHENDON","WINCHESTER","WINDSOR","WINTHROP","WOBURN","WOODS HOLE","WORCESTER","WORCESTER","WORCESTER","WORCESTER","WORCESTER","WORCESTER","WORCESTER","WORCESTER","WORCESTER","WORTHINGTON","WRENTHAM","YARMOUTH PORT"]

{"sheet":"System Scheduling Calculations","index":18,"n_rows":83,"n_cols":57,"rows_kept":83,"cut":false,"hidden":true,"merged":[[1,30,1,55],[1,4,1,29],[30,4,30,29],[30,30,30,55]]}
[null,null,"Baseline"]
[null,null,null,null,"Weekday",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Weekend",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"do not drag formulas down all rows, they are not all the same"]
[null,null,"Load Type",null,null,null,{"$f":"G4/24","v":0},4.1666666666666664E-2,8.3333333333333329E-2,0.125,0.16666666666666666,0.20833333333333334,0.25,0.29166666666666669,0.33333333333333331,0.375,0.41666666666666669,0.45833333333333331,0.5,0.54166666666666663,0.58333333333333337,0.625,0.66666666666666663,0.70833333333333337,0.75,0.79166666666666663,0.83333333333333337,0.875,0.91666666666666663,0.95833333333333337,null,null,{"$f":"AG4/24","v":0},4.1666666666666664E-2,8.3333333333333329E-2,0.125,0.16666666666666666,0.20833333333333334,0.25,0.29166666666666669,0.33333333333333331,0.375,0.41666666666666669,0.45833333333333331,0.5,0.54166666666666663,0.58333333333333337,0.625,0.66666666666666663,0.70833333333333337,0.75,0.79166666666666663,0.83333333333333337,0.875,0.91666666666666663,0.95833333333333337,"Baseline"]
[null,null,"Cooling and Heating equipment - variable loads","weeks","hour start","hour end",0,{"$f":"G4+1","v":1},2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,"hour start","hour end",0,{"$f":"AG4+1","v":1},2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,"Annual Hours"]
[null,null,"Pumps in Cooling System",{"$f":"'System Scheduling'!I29","v":0},{"$f":"'System Scheduling'!J29","v":"00:00:00"},{"$f":"'System Scheduling'!K29","v":"00:00:00"},{"$f":"IF(AND($E5=\"24/7\",$F5=\"24/7\"),1,IF(G$3>=$E5,IF(G$3<$F5,1,\"\"),\"\"))","v":""},"","","","","","","","","",{"$f":"IF(AND($E5=\"24/7\",$F5=\"24/7\"),1,IF(Q$3>=$E5,IF(Q$3<$F5,1,\"\"),\"\"))","v":""},"","","","","","","","","","","","","",{"$f":"'System Scheduling'!L29","v":"00:00:00"},{"$f":"'System Scheduling'!M29","v":"00:00:00"},{"$f":"IF(AND($AE5=\"24/7\",$AF5=\"24/7\"),1,IF(AG$3>=$AE5,IF(AG$3<$AF5,1,\"\"),\"\"))","v":""},"","","","","","","","","",{"$f":"IF(AND($AE5=\"24/7\",$AF5=\"24/7\"),1,IF(AQ$3>=$AE5,IF(AQ$3<$AF5,1,\"\"),\"\"))","v":""},"","","","","","","","","","","","","",{"$f":"SUM(G5:AD5)*5*D5+SUM(AG5:BD5)*2*D5","v":0}]
[null,null,"Pumps in Cooling System",{"$f":"'System Scheduling'!I30","v":0},{"$f":"'System Scheduling'!J30","v":"00:00:00"},{"$f":"'System Scheduling'!K30","v":"00:00:00"},"","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"'System Scheduling'!L30","v":"00:00:00"},{"$f":"'System Scheduling'!M30","v":"00:00:00"},"","","","","","","","","","","","","","","","","","","","","","","","",0]
[null,null,"Pumps in Cooling System",{"$f":"'System Scheduling'!I31","v":0},{"$f":"'System Scheduling'!J31","v":"00:00:00"},{"$f":"'System Scheduling'!K31","v":"00:00:00"},"","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"'System Scheduling'!L31","v":"00:00:00"},{"$f":"'System Scheduling'!M31","v":"00:00:00"},"","","","","","","","","","","","","","","","","","","","","","","","",0]
[null,null,"Pumps in Heating System",{"$f":"'System Scheduling'!I32","v":0},{"$f":"'System Scheduling'!J32","v":"00:00:00"},{"$f":"'System Scheduling'!K32","v":"00:00:00"},"","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"'System Scheduling'!L32","v":"00:00:00"},{"$f":"'System Scheduling'!M32","v":"00:00:00"},"","","","","","","","","","","","","","","","","","","","","","","","",0]
[null,null,"Pumps in Heating System",{"$f":"'System Scheduling'!I33","v":0},{"$f":"'System Scheduling'!J33","v":"00:00:00"},{"$f":"'System Scheduling'!K33","v":"00:00:00"},"","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"'System Scheduling'!L33","v":"00:00:00"},{"$f":"'System Scheduling'!M33","v":"00:00:00"},"","","","","","","","","","","","","","","","","","","","","","","","",0]
[null,null,"Pumps in Heating System",{"$f":"'System Scheduling'!I34","v":0},{"$f":"'System Scheduling'!J34","v":"00:00:00"},{"$f":"'System Scheduling'!K34","v":"00:00:00"},"","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"'System Scheduling'!L34","v":"00:00:00"},{"$f":"'System Scheduling'!M34","v":"00:00:00"},"","","","","","","","","","","","","","","","","","","","","","","","",0]
[null,null,"Cooling Tower Fans",{"$f":"'System Scheduling'!I36","v":0},{"$f":"'System Scheduling'!J36","v":"00:00:00"},{"$f":"'System Scheduling'!K36","v":"00:00:00"},"","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"'System Scheduling'!L36","v":"00:00:00"},{"$f":"'System Scheduling'!M36","v":"00:00:00"},"","","","","","","","","","","","","","","","","","","","","","","","",0]
[null,null,"Cooling Tower Fans",{"$f":"'System Scheduling'!I37","v":0},{"$f":"'System Scheduling'!J37","v":"00:00:00"},{"$f":"'System Scheduling'!K37","v":"00:00:00"},"","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"'System Scheduling'!L37","v":"00:00:00"},{"$f":"'System Scheduling'!M37","v":"00:00:00"},"","","","","","","","","","","","","","","","","","","","","","","","",0]
[null,null,"Cooling Tower Fans",{"$f":"'System Scheduling'!I38","v":0},{"$f":"'System Scheduling'!J38","v":"00:00:00"},{"$f":"'System Scheduling'!K38","v":"00:00:00"},"","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"'System Scheduling'!L38","v":"00:00:00"},{"$f":"'System Scheduling'!M38","v":"00:00:00"},"","","","","","","","","","","","","","","","","","","","","","","","",0]
[null,null,"Cooling Tower Fans",{"$f":"'System Scheduling'!I39","v":0},{"$f":"'System Scheduling'!J39","v":"00:00:00"},{"$f":"'System Scheduling'!K39","v":"00:00:00"},"","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"'System Scheduling'!L39","v":"00:00:00"},{"$f":"'System Scheduling'!M39","v":"00:00:00"},"","","","","","","","","","","","","","","","","","","","","","","","",0]
[null,null,"Rooftop Units",{"$f":"'System Scheduling'!I40","v":0},{"$f":"'System Scheduling'!J40","v":"00:00:00"},{"$f":"'System Scheduling'!K40","v":"00:00:00"},{"$f":"IF(AND($E15=\"24/7\",$F15=\"24/7\"),1,IF(G$3>=$E15,IF(G$3<$F15,1,\"\"),\"\"))","v":""},"","","","","","","","","",{"$f":"IF(AND($E15=\"24/7\",$F15=\"24/7\"),1,IF(Q$3>=$E15,IF(Q$3<$F15,1,\"\"),\"\"))","v":""},"","","","","","","","","","","","","",{"$f":"'System Scheduling'!L40","v":"00:00:00"},{"$f":"'System Scheduling'!M40","v":"00:00:00"},{"$f":"IF(AND($AE15=\"24/7\",$AF15=\"24/7\"),1,IF(AG$3>=$AE15,IF(AG$3<$AF15,1,\"\"),\"\"))","v":""},"","","","","","","","","",{"$f":"IF(AND($AE15=\"24/7\",$AF15=\"24/7\"),1,IF(AQ$3>=$AE15,IF(AQ$3<$AF15,1,\"\"),\"\"))","v":""},"","","","","","","","","","","","","",0]
[null,null,"Rooftop Units",{"$f":"'System Scheduling'!I41","v":0},{"$f":"'System Scheduling'!J41","v":"00:00:00"},{"$f":"'System Scheduling'!K41","v":"00:00:00"},"","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"'System Scheduling'!L41","v":"00:00:00"},{"$f":"'System Scheduling'!M41","v":"00:00:00"},"","","","","","","","","","","","","","","","","","","","","","","","",0]
[null,null,"Rooftop Units",{"$f":"'System Scheduling'!I42","v":0},{"$f":"'System Scheduling'!J42","v":"00:00:00"},{"$f":"'System Scheduling'!K42","v":"00:00:00"},"","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"'System Scheduling'!L42","v":"00:00:00"},{"$f":"'System Scheduling'!M42","v":"00:00:00"},"","","","","","","","","","","","","","","","","","","","","","","","",0]
[null,null,"Rooftop Units",{"$f":"'System Scheduling'!I43","v":0},{"$f":"'System Scheduling'!J43","v":"00:00:00"},{"$f":"'System Scheduling'!K43","v":"00:00:00"},"","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"'System Scheduling'!L43","v":"00:00:00"},{"$f":"'System Scheduling'!M43","v":"00:00:00"},"","","","","","","","","","","","","","","","","","","","","","","","",0]
[null,null,"Air Handler Fans and Exhaust Fans",{"$f":"'System Scheduling'!I44","v":0},{"$f":"'System Scheduling'!J44","v":"00:00:00"},{"$f":"'System Scheduling'!K44","v":"00:00:00"},"","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"'System Scheduling'!L44","v":"00:00:00"},{"$f":"'System Scheduling'!M44","v":"00:00:00"},"","","","","","","","","","","","","","","","","","","","","","","","",0]
[null,null,"Air Handler Fans and Exhaust Fans",{"$f":"'System Scheduling'!I45","v":0},{"$f":"'System Scheduling'!J45","v":"00:00:00"},{"$f":"'System Scheduling'!K45","v":"00:00:00"},"","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"'System Scheduling'!L45","v":"00:00:00"},{"$f":"'System Scheduling'!M45","v":"00:00:00"},"","","","","","","","","","","","","","","","","","","","","","","","",0]
[null,null,"Air Handler Fans and Exhaust Fans",{"$f":"'System Scheduling'!I46","v":0},{"$f":"'System Scheduling'!J46","v":"00:00:00"},{"$f":"'System Scheduling'!K46","v":"00:00:00"},"","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"'System Scheduling'!L46","v":"00:00:00"},{"$f":"'System Scheduling'!M46","v":"00:00:00"},"","","","","","","","","","","","","","","","","","","","","","","","",0]
[null,null,"Air Handler Fans and Exhaust Fans",{"$f":"'System Scheduling'!I47","v":0},{"$f":"'System Scheduling'!J47","v":"00:00:00"},{"$f":"'System Scheduling'!K47","v":"00:00:00"},"","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"'System Scheduling'!L47","v":"00:00:00"},{"$f":"'System Scheduling'!M47","v":"00:00:00"},"","","","","","","","","","","","","","","","","","","","","","","","",0]
[null,null,"Electric Resistance Heating",{"$f":"'System Scheduling'!I48","v":0},{"$f":"'System Scheduling'!J48","v":"00:00:00"},{"$f":"'System Scheduling'!K48","v":"00:00:00"},"","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"'System Scheduling'!L48","v":"00:00:00"},{"$f":"'System Scheduling'!M48","v":"00:00:00"},"","","","","","","","","","","","","","","","","","","","","","","","",0]
[null,null,"Other",{"$f":"'System Scheduling'!I49","v":0},{"$f":"'System Scheduling'!J49","v":"00:00:00"},{"$f":"'System Scheduling'!K49","v":"00:00:00"},"","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"'System Scheduling'!L49","v":"00:00:00"},{"$f":"'System Scheduling'!M49","v":"00:00:00"},"","","","","","","","","","","","","","","","","","","","","","","","",0]
[null,null,"Other",{"$f":"'System Scheduling'!I50","v":0},{"$f":"'System Scheduling'!J50","v":"00:00:00"},{"$f":"'System Scheduling'!K50","v":"00:00:00"},"","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"'System Scheduling'!L50","v":"00:00:00"},{"$f":"'System Scheduling'!M50","v":"00:00:00"},"","","","","","","","","","","","","","","","","","","","","","","","",0]
[null,null,"Other",{"$f":"'System Scheduling'!I51","v":0},{"$f":"'System Scheduling'!J51","v":"00:00:00"},{"$f":"'System Scheduling'!K51","v":"00:00:00"},"","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"'System Scheduling'!L51","v":"00:00:00"},{"$f":"'System Scheduling'!M51","v":"00:00:00"},"","","","","","","","","","","","","","","","","","","","","","","","",0]
[null,null,"Total Savings"]
[]
[]
[null,null,"Proposed"]
[null,null,null,null,"Weekday",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Weekend"]
[null,null,"Load Type",null,null,null,{"$f":"G33/24","v":0},4.1666666666666664E-2,8.3333333333333329E-2,0.125,0.16666666666666666,0.20833333333333334,0.25,0.29166666666666669,0.33333333333333331,0.375,0.41666666666666669,0.45833333333333331,0.5,0.54166666666666663,0.58333333333333337,0.625,0.66666666666666663,0.70833333333333337,0.75,0.79166666666666663,0.83333333333333337,0.875,0.91666666666666663,0.95833333333333337,null,null,{"$f":"AG33/24","v":0},4.1666666666666664E-2,8.3333333333333329E-2,0.125,0.16666666666666666,0.20833333333333334,0.25,0.29166666666666669,0.33333333333333331,0.375,0.41666666666666669,0.45833333333333331,0.5,0.54166666666666663,0.58333333333333337,0.625,0.66666666666666663,0.70833333333333337,0.75,0.79166666666666663,0.83333333333333337,0.875,0.91666666666666663,0.95833333333333337,"Proposed"]
[null,null,"Cooling and Heating equipment - variable loads","weeks","hour start","hour end",0,{"$f":"G33+1","v":1},2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,"hour start","hour end",0,{"$f":"AG33+1","v":1},2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,"Annual Hours"]
[null,null,{"$f":"C5","v":"Pumps in Cooling System"},{"$f":"'System Scheduling'!N29","v":0},{"$f":"'System Scheduling'!O29","v":"00:00:00"},{"$f":"'System Scheduling'!P29","v":"00:00:00"},{"$f":"IF(AND($E34=\"24/7\",$F34=\"24/7\"),1,IF(G$3>=$E34,IF(G$3<$F34,1,\"\"),\"\"))","v":""},"","","","","","","","","",{"$f":"IF(AND($E34=\"24/7\",$F34=\"24/7\"),1,IF(Q$3>=$E34,IF(Q$3<$F34,1,\"\"),\"\"))","v":""},"","","","","","","","","","","","","",{"$f":"'System Scheduling'!Q29","v":"00:00:00"},{"$f":"'System Scheduling'!R29","v":"00:00:00"},{"$f":"IF(AND($AE34=\"24/7\",$AF34=\"24/7\"),1,IF(AG$3>=$AE34,IF(AG$3<$AF34,1,\"\"),\"\"))","v":""},"","","","","","","","","",{"$f":"IF(AND($AE34=\"24/7\",$AF34=\"24/7\"),1,IF(AQ$3>=$AE34,IF(AQ$3<$AF34,1,\"\"),\"\"))","v":""},"","","","","","","","","","","","","",{"$f":"SUM(G34:AD34)*5*D34+SUM(AG34:BD34)*2*D34","v":0}]
[null,null,"Pumps in Cooling System",{"$f":"'System Scheduling'!N30","v":0},{"$f":"'System Scheduling'!O30","v":"00:00:00"},{"$f":"'System Scheduling'!P30","v":"00:00:00"},"","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"'System Scheduling'!Q30","v":"00:00:00"},{"$f":"'System Scheduling'!R30","v":"00:00:00"},"","","","","","","","","","","","","","","","","","","","","","","","",0]
[null,null,"Pumps in Cooling System",{"$f":"'System Scheduling'!N31","v":0},{"$f":"'System Scheduling'!O31","v":"00:00:00"},{"$f":"'System Scheduling'!P31","v":"00:00:00"},"","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"'System Scheduling'!Q31","v":"00:00:00"},{"$f":"'System Scheduling'!R31","v":"00:00:00"},"","","","","","","","","","","","","","","","","","","","","","","","",0]
[null,null,"Pumps in Heating System",{"$f":"'System Scheduling'!N32","v":0},{"$f":"'System Scheduling'!O32","v":"00:00:00"},{"$f":"'System Scheduling'!P32","v":"00:00:00"},"","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"'System Scheduling'!Q32","v":"00:00:00"},{"$f":"'System Scheduling'!R32","v":"00:00:00"},"","","","","","","","","","","","","","","","","","","","","","","","",0]
[null,null,"Pumps in Heating System",{"$f":"'System Scheduling'!N33","v":0},{"$f":"'System Scheduling'!O33","v":"00:00:00"},{"$f":"'System Scheduling'!P33","v":"00:00:00"},"","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"'System Scheduling'!Q33","v":"00:00:00"},{"$f":"'System Scheduling'!R33","v":"00:00:00"},"","","","","","","","","","","","","","","","","","","","","","","","",0]
[null,null,"Pumps in Heating System",{"$f":"'System Scheduling'!N34","v":0},{"$f":"'System Scheduling'!O34","v":"00:00:00"},{"$f":"'System Scheduling'!P34","v":"00:00:00"},"","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"'System Scheduling'!Q34","v":"00:00:00"},{"$f":"'System Scheduling'!R34","v":"00:00:00"},"","","","","","","","","","","","","","","","","","","","","","","","",0]
[null,null,"Cooling Tower Fans",{"$f":"'System Scheduling'!N36","v":0},{"$f":"'System Scheduling'!O36","v":"00:00:00"},{"$f":"'System Scheduling'!P36","v":"00:00:00"},"","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"'System Scheduling'!Q36","v":"00:00:00"},{"$f":"'System Scheduling'!R36","v":"00:00:00"},"","","","","","","","","","","","","","","","","","","","","","","","",0]
[null,null,"Cooling Tower Fans",{"$f":"'System Scheduling'!N37","v":0},{"$f":"'System Scheduling'!O37","v":"00:00:00"},{"$f":"'System Scheduling'!P37","v":"00:00:00"},"","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"'System Scheduling'!Q37","v":"00:00:00"},{"$f":"'System Scheduling'!R37","v":"00:00:00"},"","","","","","","","","","","","","","","","","","","","","","","","",0]
[null,null,"Cooling Tower Fans",{"$f":"'System Scheduling'!N38","v":0},{"$f":"'System Scheduling'!O38","v":"00:00:00"},{"$f":"'System Scheduling'!P38","v":"00:00:00"},"","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"'System Scheduling'!Q38","v":"00:00:00"},{"$f":"'System Scheduling'!R38","v":"00:00:00"},"","","","","","","","","","","","","","","","","","","","","","","","",0]
[null,null,"Cooling Tower Fans",{"$f":"'System Scheduling'!N39","v":0},{"$f":"'System Scheduling'!O39","v":"00:00:00"},{"$f":"'System Scheduling'!P39","v":"00:00:00"},"","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"'System Scheduling'!Q39","v":"00:00:00"},{"$f":"'System Scheduling'!R39","v":"00:00:00"},"","","","","","","","","","","","","","","","","","","","","","","","",0]
[null,null,"Rooftop Units",{"$f":"'System Scheduling'!N40","v":0},{"$f":"'System Scheduling'!O40","v":"00:00:00"},{"$f":"'System Scheduling'!P40","v":"00:00:00"},{"$f":"IF(AND($E44=\"24/7\",$F44=\"24/7\"),1,IF(G$3>=$E44,IF(G$3<$F44,1,\"\"),\"\"))","v":""},"","","","","","","","","",{"$f":"IF(AND($E44=\"24/7\",$F44=\"24/7\"),1,IF(Q$3>=$E44,IF(Q$3<$F44,1,\"\"),\"\"))","v":""},"","","","","","","","","","","","","",{"$f":"'System Scheduling'!Q40","v":"00:00:00"},{"$f":"'System Scheduling'!R40","v":"00:00:00"},{"$f":"IF(AND($AE44=\"24/7\",$AF44=\"24/7\"),1,IF(AG$3>=$AE44,IF(AG$3<$AF44,1,\"\"),\"\"))","v":""},"","","","","","","","","",{"$f":"IF(AND($AE44=\"24/7\",$AF44=\"24/7\"),1,IF(AQ$3>=$AE44,IF(AQ$3<$AF44,1,\"\"),\"\"))","v":""},"","","","","","","","","","","","","",0]
[null,null,"Rooftop Units",{"$f":"'System Scheduling'!N41","v":0},{"$f":"'System Scheduling'!O41","v":"00:00:00"},{"$f":"'System Scheduling'!P41","v":"00:00:00"},"","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"'System Scheduling'!Q41","v":"00:00:00"},{"$f":"'System Scheduling'!R41","v":"00:00:00"},"","","","","","","","","","","","","","","","","","","","","","","","",0]
[null,null,"Rooftop Units",{"$f":"'System Scheduling'!N42","v":0},{"$f":"'System Scheduling'!O42","v":"00:00:00"},{"$f":"'System Scheduling'!P42","v":"00:00:00"},"","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"'System Scheduling'!Q42","v":"00:00:00"},{"$f":"'System Scheduling'!R42","v":"00:00:00"},"","","","","","","","","","","","","","","","","","","","","","","","",0]
[null,null,"Rooftop Units",{"$f":"'System Scheduling'!N43","v":0},{"$f":"'System Scheduling'!O43","v":"00:00:00"},{"$f":"'System Scheduling'!P43","v":"00:00:00"},"","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"'System Scheduling'!Q43","v":"00:00:00"},{"$f":"'System Scheduling'!R43","v":"00:00:00"},"","","","","","","","","","","","","","","","","","","","","","","","",0]
[null,null,"Air Handler Fans and Exhaust Fans",{"$f":"'System Scheduling'!N44","v":0},{"$f":"'System Scheduling'!O44","v":"00:00:00"},{"$f":"'System Scheduling'!P44","v":"00:00:00"},"","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"'System Scheduling'!Q44","v":"00:00:00"},{"$f":"'System Scheduling'!R44","v":"00:00:00"},"","","","","","","","","","","","","","","","","","","","","","","","",0]
[null,null,"Air Handler Fans and Exhaust Fans",{"$f":"'System Scheduling'!N45","v":0},{"$f":"'System Scheduling'!O45","v":"00:00:00"},{"$f":"'System Scheduling'!P45","v":"00:00:00"},"","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"'System Scheduling'!Q45","v":"00:00:00"},{"$f":"'System Scheduling'!R45","v":"00:00:00"},"","","","","","","","","","","","","","","","","","","","","","","","",0]
[null,null,"Air Handler Fans and Exhaust Fans",{"$f":"'System Scheduling'!N46","v":0},{"$f":"'System Scheduling'!O46","v":"00:00:00"},{"$f":"'System Scheduling'!P46","v":"00:00:00"},"","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"'System Scheduling'!Q46","v":"00:00:00"},{"$f":"'System Scheduling'!R46","v":"00:00:00"},"","","","","","","","","","","","","","","","","","","","","","","","",0]
[null,null,"Air Handler Fans and Exhaust Fans",{"$f":"'System Scheduling'!N47","v":0},{"$f":"'System Scheduling'!O47","v":"00:00:00"},{"$f":"'System Scheduling'!P47","v":"00:00:00"},"","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"'System Scheduling'!Q47","v":"00:00:00"},{"$f":"'System Scheduling'!R47","v":"00:00:00"},"","","","","","","","","","","","","","","","","","","","","","","","",0]
[null,null,"Electric Resistance Heating",{"$f":"'System Scheduling'!N48","v":0},{"$f":"'System Scheduling'!O48","v":"00:00:00"},{"$f":"'System Scheduling'!P48","v":"00:00:00"},"","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"'System Scheduling'!Q48","v":"00:00:00"},{"$f":"'System Scheduling'!R48","v":"00:00:00"},"","","","","","","","","","","","","","","","","","","","","","","","",0]
[null,null,"Other",{"$f":"'System Scheduling'!N49","v":0},{"$f":"'System Scheduling'!O49","v":"00:00:00"},{"$f":"'System Scheduling'!P49","v":"00:00:00"},"","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"'System Scheduling'!Q49","v":"00:00:00"},{"$f":"'System Scheduling'!R49","v":"00:00:00"},"","","","","","","","","","","","","","","","","","","","","","","","",0]
[null,null,"Other",{"$f":"'System Scheduling'!N50","v":0},{"$f":"'System Scheduling'!O50","v":"00:00:00"},{"$f":"'System Scheduling'!P50","v":"00:00:00"},"","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"'System Scheduling'!Q50","v":"00:00:00"},{"$f":"'System Scheduling'!R50","v":"00:00:00"},"","","","","","","","","","","","","","","","","","","","","","","","",0]
[null,null,"Other",{"$f":"'System Scheduling'!N51","v":0},{"$f":"'System Scheduling'!O51","v":"00:00:00"},{"$f":"'System Scheduling'!P51","v":"00:00:00"},"","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"'System Scheduling'!Q51","v":"00:00:00"},{"$f":"'System Scheduling'!R51","v":"00:00:00"},"","","","","","","","","","","","","","","","","","","","","","","","",0]
[null,null,"Total Savings"]
[]
[]
[null,null,"Load Type","Savings"]
[null,null,"Cooling and Heating equipment - variable loads","Annual Hours"]
[null,null,{"$f":"C5","v":"Pumps in Cooling System"},{"$f":"BE5-BE34","v":0}]
[null,null,"Pumps in Cooling System",0]
[null,null,"Pumps in Cooling System",0]
[null,null,"Pumps in Heating System",0]
[null,null,"Pumps in Heating System",0]
[null,null,"Pumps in Heating System",0]
[null,null,"Cooling Tower Fans",0]
[null,null,"Cooling Tower Fans",0]
[null,null,"Cooling Tower Fans",0]
[null,null,"Cooling Tower Fans",0]
[null,null,"Rooftop Units",0]
[null,null,"Rooftop Units",0]
[null,null,"Rooftop Units",0]
[null,null,"Rooftop Units",0]
[null,null,"Air Handler Fans and Exhaust Fans",0]
[null,null,"Air Handler Fans and Exhaust Fans",0]
[null,null,"Air Handler Fans and Exhaust Fans",0]
[null,null,"Air Handler Fans and Exhaust Fans",0]
[null,null,"Electric Resistance Heating",0]
[null,null,"Other",0]
[null,null,"Other",0]
[null,null,"Other",0]
[null,null,"Total Savings"]