{"text_format":"1","workbook":"xlsx","n_sheets":25,"sheets":["Project Data","Project Summary","1- Interior Lighting & NLC","1.1 High Perf. Guidelines","Interior BuildingAreaBaselines","1A- Space by Space","lists","2- Occupancy Sensors","21- Daylighting","4- Exterior Lighting","5- Unitary & Split DX","6- Air Source Heat Pumps","7- Ground Source Heat Pumps","8- VRF-VRV","9- VFDs","10- Chillers","11- Energy Recovery","12- DCV (CO2 Control)","13 - Heat Pump Water Heaters","14 - Kitchen Hood VFDs","15 - Insulation","16 - Windows","17 - Custom Measure","18 - Air Compressor & Dryer","19-Air Compressor Heat Recovery"],"not_rendered":{"charts":0,"images":7,"macros":1,"external_links":3,"defined_names":73,"comments":12,"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":"Project Data","index":0,"n_rows":53,"n_cols":17,"rows_kept":53,"cut":false,"hidden":false,"merged":[[40,0,44,1],[0,0,0,2],[4,0,4,7],[6,0,6,1],[24,0,24,1],[24,4,24,7],[25,4,25,7],[31,6,31,7],[1,0,2,2],[32,6,32,7],[33,0,33,1],[35,6,35,7],[36,6,36,7],[37,6,37,7]]}
["2025 EnergizeCT\nCommercial & Industrial New Construction/Major Renovation\nData Collection v 1"]
["For additional program information go to: http://www.energizect.com/businesses/programs/Energy-Conscious-Blueprint or email CTECB@eversource.com"]
[]
[]
["To be eligible to receive an incentive payment the participant must obtain conditional approval from the Utilities prior to the purchase or installation of any energy efficiency measures. In addition to this data collection, submit a full set of building plans & relevant specification sheets, submittals, and/or proposals for every measure you are submitting for. If you don't know which Energy Efficiency Consultant will manage this project, email this form and the backup documentation to ctecb@eversource.com.\n\nCustomers participating in this pathway may not also participate in Energize CT Midstream (program payments made to distributors or Express (customer rebate programs) with the exception of some ENERGY STAR certified kitchen equipment."]
[]
["Facility Information",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Type of Project"]
["Facility Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"New facility"]
["Facility Street Address",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Addition to existing facility"]
["Facility City, State Zip",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Major renovation"]
["Facility Type (drop down)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Major renovation plus addition"]
["Electric Utility Company Name"]
["Electric Utility Account Number (if known)"]
["Natural Gas Utility Company Name"]
["Natural Gas Utility Account Number (if known)"]
["Which is this project: new facility, addition to existing facility, major renovation, or major renovation plus addition?"]
["Estimated Project Completion Date"]
["Square Footage of Project"]
["Weather Station Closest"]
["Fossil Fuel Type (and Electrification Base Fuel)"]
["Project Type"]
["Early/Late Engagement"]
["Approximate Weekly or Annual Occupied Hours"]
[]
["Customer Information",null,null,null,"General Building Hours of Operation"]
["Customer Contact Name",null,null,null,"(Times must be entered in 0 - 24 hr format)"]
["Customer Contact Title"]
["Customer Company Name",null,null,null,null,null,"Start","End"]
["Customer Contact Email Address",null,null,null,"Weekdays"]
["Customer Contact Phone Number",null,null,null,"Saturday"]
["Customer Street Address (if different from facility address)",null,null,null,"Sunday"]
["Customer City, State Zip (if different from facility address)",null,null,null,"Holiday Closures?"]
[null,null,null,null,"Seasonal Bldg Hours?"]
["Payee Information (include a W-9 with submission)",null,null,null,"If building is not used, enter \"0\" for Start and End"]
["Incentive Check Payable to Name (INCLUDE A W-9)"]
["Incentive Check Payable to Street Address",null,null,null,"Monthly/Seasonal",null,"Must enter a value for each"]
["Incentive Check Payable to City, State, Zip",null,null,null,"Bldg Hours Diversity",null,"month (0 - 100%). If left blank,"]
[null,null,null,null,"(if variable)",null,"default of 100% is assumed."]
["Total Project Cost","$",null,null,"Month","Usage Div.","Default"]
[null,null,null,null,"Jan",null,1]
["There are multi-end use incentives available for projects that includes a minimum of 3 end uses. An end use is defined as natural gas or electric that impact heating; cooling; lighting; process; domestic water heating; refrigeration; motors and drives. The incentive is an additional $0.10/kWh saved and/or $1.00/ccf, capped at $20,000. If eligible, this incentive will be added after all savings analyses are completed.",null,null,null,"Feb",null,1]
[null,null,null,null,"Mar",null,1]
[null,null,null,null,"Apr",null,1]
[null,null,null,null,"May",null,1]
[null,null,null,null,"Jun",null,1]
[null,null,null,null,"Jul",null,1]
[null,null,null,null,"Aug",null,1]
[null,null,null,null,"Sep",null,1]
[null,null,null,null,"Oct",null,1]
[null,null,null,null,"Nov",null,1]
[null,null,null,null,"Dec",null,1]
[]
["Version date: 11/15/2024"]

{"sheet":"Project Summary","index":1,"n_rows":29,"n_cols":5,"rows_kept":29,"cut":false,"hidden":false,"merged":[[1,4,12,11],[14,4,16,11],[22,1,22,2],[24,1,24,2],[28,1,28,2],[2,1,2,2],[6,1,6,2],[16,1,16,2],[19,1,19,2],[19,4,23,11]]}
[]
[null,"Measures:","Included In Project:",null,"Measure tabs to fill out will appear for measures where \"yes\" is selected. \n\nIf you are not able to see tabs when you select \"yes\", you may need to click \"enable content\" in a yellow bar at the top of the screen. \n\nIf that bar is no longer available, you can close and reopen the sheet, or go to file>options>trust center>trust center settings>macro settings and enable macros. You may want to disable them again when you are finished working."]
[null,"Lighting & Controls"]
[null,"1- Interior Lighting & NLC \n","No"]
[null,"3- Network Lighting Controls","No"]
[null,"4- Exterior Lighting","No"]
[null,"HVAC & Controls"]
[null,"5- Unitary & Split DX","No"]
[null,"6- Air Source Heat Pumps","No"]
[null,"7- Ground Source Heat Pumps","No"]
[null,"8- VRF-VRV","No"]
[null,"9- VFDs","No"]
[null,"10- Chillers","No"]
[null,"11- Energy Recovery","No"]
[null,"12- DCV (CO2 control)","No",null,"For ENERGY STAR certified electric kitchen equipment incentives, visit https://energizect.com/rebates-incentives/foodservice"]
[null,"13 - Heat Pump Water Heaters","No"]
[null,"Commercial Kitchen"]
[null,"16- Cooking Equipment","No"]
[null,"14 - Kitchen Hood VFDs","No"]
[null,"Building Envelope",null,null,"As of January 1 2025, the Companies can no longer incentivize new gas combustion equipment. Gas savings from secondary sources like envelope improvements are still considered. There are some exceptions for industrial process equipment. Contact your Companies consultant for more information."]
[null,"15 - Insulation","No"]
[null,"16 - Windows","No"]
[null,"Custom"]
[null,"17 - Custom Measure","No"]
[null,"Manufacturing"]
[null,"18 - Air Compressor & Dryer","No"]
[null,"19-Air Compressor Heat Recovery","No"]
[]
[null,"Notes: "]

{"sheet":"1- Interior Lighting & NLC","index":2,"n_rows":74,"n_cols":11,"rows_kept":74,"cut":false,"hidden":true,"merged":[[12,1,12,4],[13,1,15,4],[16,1,16,4],[7,6,16,7],[9,1,9,3],[0,1,0,7],[1,1,2,7],[3,1,3,3],[4,1,4,3],[5,1,5,3],[10,1,10,3],[11,1,11,5],[6,6,6,7],[6,1,6,3],[7,1,7,3],[8,1,8,3],[4,6,4,7]]}
["Click to go back to the project summary tab","Interior Lighting Fixture Schedule with Quantities"]
[null,"Please complete all yellow cells and provide:\n- Spec sheets for all fixtures\n- Project lighting plans/lighting schedules\n- a COMcheck\n\nFor projects submitting with Networked Lighting Controls (NLC), please also provide:\n- DLC certificate for the NLC\n- Narrative detailing the control strategy for the building and list of fixtures controlled by the NLC (see tab 1.1 High Performance Guidelines)"]
[]
[null,"Building Type"]
[null,"Square footage of lit area",null,null,null,null,"High Performance Guidelines",null,null,null," "]
[null,"Baseline calculation method",null,null,null,null,null,null,null,null," "]
[null,"Space Cooling/Economizer",null,null,null,null,"Incentives for LED Fixtures with Networked Lighting Controls System"]
[null,"Is this project installing a Networked Lighting Control (NLC) System?",null,null,null,null,"Greater of $0.65/kWh saved or $1,000/summer peak kW saved, capped at 95% of incremental cost. \n\nRequirements:\n• Utilize a networked lighting control system, as defined by DLC, with all controlled LED fixtures wirelessly accessible to initialize, configure, and commission. \n• Individual fixture addressability and luminaire level lighting control (LLLC) and compliance with LLLC capabilities as outlined by DLC is optional. Must include and demonstrate task tuning/high end trim per fixture and at least one other different control strategy at the project level (e.g. occupancy, daylighting).  \n• System must be capable of energy monitoring and demand response, as defined by DLC. Customer must also provide control narrative for the system, and it must be fully commissioned with reporting capability.\n• Fixture LPD must meet at least a 20% reduction under IECC 2021 LPD allowances.\n\nIncentives without networked lighting controls are calculated as the Greater of $0.40/kWh saved or $1,000/summer peak kW reduction.  "]
[null,"If yes, is the NLC System capable of energy monitoring and demand response?"]
[null,"If yes, provide NLC Brand & System name"]
[null,"NLC Sytem Cost"]
[]
[null,"Project must be 100% LEDs to qualify."]
[null," LED fixtures or lamps are required to be UL listed and are highly recommended to be Design Lights Consortium (DLC) or Energy Star’s Qualified Products."]
[]
[]
[null,"Baseline for lighting  comes from:\nIndustry standard practice: 20% reduction from IECC 2021 standard values and coincident factors from 2024 PSD."]
[null,null,null,null,null,null,null,null,null,"For Network Lighting Control (NLC) PROJECTS ONLY"]
[null,"Fixture Code (optional)","Total Quantity of New Fixtures","Quantity of Existing Fixtures Remaining (not being changed in Major Renovation)","Watts Per Fixture","Quantity of fixtures Controlled by Qualified NLC? ","Fixture Description\n*INCLUDE A SPEC SHEET FOR EACH FIXTURE WHEN YOU SUBMIT THIS FORM*","Total Wattage For This Fixture",null,"High End Trim % (Enter as decimal)"]
[null,"A (EXAMPLE PROJECT)",12,0,44,2,"EXAMPLE: Fixture Manufacturer & Full Model # (provide spec sheet)",{"$f":"E20*C20+E20*D20","v":528},null,0.9]
[null,"B (EXAMPLE PROJECT)",10,0,60,3,"EXAMPLE: Fixture Manufacturer & Full Model # (provide spec sheet)",600,null,0.9]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,"Totals",{"$f":"SUM(C22:C69)","v":0},0,null,{"$f":"SUM(F22:F69)","v":0},null,{"$f":"SUM(H22:H69)","v":0}]
[]
[]
[]
[null,"Provide any additional information relevant to this project."]

{"sheet":"1.1 High Perf. Guidelines","index":3,"n_rows":1,"n_cols":13,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,"Click to go back to the Interior Lighting & NLC"]

{"sheet":"Interior BuildingAreaBaselines","index":4,"n_rows":82,"n_cols":10,"rows_kept":82,"cut":false,"hidden":true,"merged":[]}
["2023 PSD - Building Area Method LPD Baseline Values",null,null,null,null,null,null,null,"PSD: ISP % Reduction from 2021 IECC Values",0.2]
["Building Type","Baseline Building Area LPD (Watts/Sqft)","Target LPD For 15% Reduction (Watts/sqft) ","Average Lighting Hours Estimate"," Lighting Summer Coincidence Factor","Lighting Winter Coincidence Factor"," Occupancy Sensor Summer Coincidence Factor","Occupancy Sensor  Winter Coincidence Factor","Target LPD For 10% Reduction (Watts/sqft)","Target LPD For 40% Reduction (Watts/sqft)"]
["Automotive facility ",{"$f":"B45*(1-$J$1)","v":0.60000000000000009},{"$f":"B3*0.85","v":0.51},2807,0.68300000000000005,0.36899999999999999,2.4E-2,6.6000000000000003E-2,{"$f":"B3*0.9","v":0.54000000000000015},{"$f":"B3*0.6","v":0.36000000000000004}]
["Convention center",0.51200000000000001,0.43519999999999998,913,0.17,9.1999999999999998E-2,2.4E-2,6.6000000000000003E-2,0.46080000000000004,0.30719999999999997]
["Courthouse ",0.63200000000000012,0.53720000000000012,4181,0.86899999999999999,0.76700000000000002,2.4E-2,6.6000000000000003E-2,0.56880000000000008,0.37920000000000004]
["Dining: bar lounge/leisure ",0.64000000000000012,0.54400000000000004,5018,0.77500000000000002,0.77,0.14699999999999999,0.13300000000000001,0.57600000000000018,0.38400000000000006]
["Dining: cafeteria/fast food ",0.6080000000000001,0.51680000000000004,5018,0.77500000000000002,0.77,0.14699999999999999,0.13300000000000001,0.54720000000000013,0.36480000000000007]
["Dining: family ",0.56799999999999995,0.48279999999999995,5018,0.77500000000000002,0.77,0.14699999999999999,0.13300000000000001,0.51119999999999999,0.34079999999999994]
["Dormitory ",0.42400000000000004,0.36040000000000005,4026,0.36799999999999999,0.46,0.28299999999999997,0.23100000000000001,0.38160000000000005,0.25440000000000002]
["Exercise center ",0.57599999999999996,0.48959999999999992,5836,0.98399999999999999,0.85599999999999998,0.14699999999999999,0.13300000000000001,0.51839999999999997,0.34559999999999996]
["Fire station (unmanned)",0.44800000000000006,0.38080000000000003,4336,0.86899999999999999,0.76700000000000002,2.4E-2,6.6000000000000003E-2,0.40320000000000006,0.26880000000000004]
["Gymnasium ",0.6080000000000001,0.51680000000000004,2586,0.59899999999999998,0.38800000000000001,0.20899999999999999,0.159,0.54720000000000013,0.36480000000000007]
["Health care clinic ",0.64800000000000013,0.55080000000000007,5564,0.82499999999999996,0.69599999999999995,0.23899999999999999,0.221,0.58320000000000016,0.38880000000000009]
["Hospital ",0.76800000000000002,0.65280000000000005,5413,0.82499999999999996,0.69599999999999995,0.23899999999999999,0.221,0.69120000000000004,0.46079999999999999]
["Hotel/Motel ",0.44800000000000006,0.38080000000000003,3112,0.40600000000000003,0.375,2.4E-2,6.6000000000000003E-2,0.40320000000000006,0.26880000000000004]
["Library ",0.66400000000000003,0.56440000000000001,3748,0.70199999999999996,0.53900000000000003,0.27400000000000002,0.29599999999999999,0.59760000000000002,0.39840000000000003]
["Manufacturing facility ",0.65600000000000003,0.55759999999999998,5793,0.83,0.66500000000000004,0.19800000000000001,0.17199999999999999,0.59040000000000004,0.39360000000000001]
["Motion picture theater ",0.35200000000000004,0.29920000000000002,1954,0.86899999999999999,0.76700000000000002,2.4E-2,6.6000000000000003E-2,0.31680000000000003,0.21120000000000003]
["Multifamily ",0.36000000000000004,0.30600000000000005,6388,0.17,1,0.18,0.12,0.32400000000000007,0.21600000000000003]
["Museum ",0.44000000000000006,0.37400000000000005,3748,0.98399999999999999,0.85599999999999998,0.14699999999999999,0.13300000000000001,0.39600000000000007,0.26400000000000001]
["Office ",0.51200000000000001,0.43519999999999998,4098,0.70199999999999996,0.53900000000000003,0.27400000000000002,0.29599999999999999,0.46080000000000004,0.30719999999999997]
["Parking garage ",0.14399999999999999,0.12239999999999998,6887,1.4999999999999999E-2,0.873,2.4E-2,6.6000000000000003E-2,0.12959999999999999,8.6399999999999991E-2]
["Penitentiary ",0.55199999999999994,0.46919999999999995,5477,0.86899999999999999,0.76700000000000002,2.4E-2,6.6000000000000003E-2,0.49679999999999996,0.33119999999999994]
["Performing arts theater ",0.67200000000000004,0.57120000000000004,913,0.86899999999999999,0.76700000000000002,2.4E-2,6.6000000000000003E-2,0.6048,0.4032]
["Police station (24/7)",0.52800000000000002,0.44880000000000003,8760,0.76800000000000002,0.441,0.27400000000000002,0.29599999999999999,0.47520000000000001,0.31680000000000003]
["Post office ",0.52,0.442,3748,0.98399999999999999,0.85599999999999998,0.14699999999999999,0.13300000000000001,0.46800000000000003,0.312]
["Religious building ",0.53600000000000003,0.4556,913,0.17,9.1999999999999998E-2,2.4E-2,6.6000000000000003E-2,0.48240000000000005,0.3216]
["Retail ",0.67200000000000004,0.57120000000000004,4939,0.98399999999999999,0.85599999999999998,0.14699999999999999,0.13300000000000001,0.6048,0.4032]
["School/university ",0.57599999999999996,0.48959999999999992,2967,0.59899999999999998,0.38800000000000001,0.20899999999999999,0.159,0.51839999999999997,0.34559999999999996]
["Sports arena ",0.6080000000000001,0.51680000000000004,913,0.17,9.1999999999999998E-2,2.4E-2,6.6000000000000003E-2,0.54720000000000013,0.36480000000000007]
["Town hall ",0.55199999999999994,0.46919999999999995,4181,0.86899999999999999,0.76700000000000002,2.4E-2,6.6000000000000003E-2,0.49679999999999996,0.33119999999999994]
["Transportation ",0.4,0.34,6456,0.68300000000000005,0.36899999999999999,2.4E-2,6.6000000000000003E-2,0.36000000000000004,0.24]
["Warehouse ",0.36000000000000004,0.30600000000000005,5667,0.89300000000000002,0.72399999999999998,0.246,0.183,0.32400000000000007,0.21600000000000003]
["Workshop ",0.72800000000000009,0.61880000000000002,3750,0.83,0.66500000000000004,0.19800000000000001,0.17199999999999999,0.65520000000000012,0.43680000000000002]
[]
["Always check with a lighting professional to ensure the lighting levels are appropriate for the tasks being performed in the space. "]
["Baselines From"]
["ISP: 20% Reduction from IECC 2021 Standard values"]
[null,null,null,"MIN",{"$f":"MIN(E3:E34)","v":1.4999999999999999E-2},9.1999999999999998E-2,2.4E-2,6.6000000000000003E-2]
["Coincident factors from 2023 PSD",null,null,"MAX",{"$f":"MAX(E3:E34)","v":0.98399999999999999},1,0.28299999999999997,0.29599999999999999]
[]
[]
["2021 IECC Standard Lighting Power Table C405.3.2(2)"]
["Building Type","Baseline Building Area LPD (Watts/Sqft)","Target LPD For 15% Reduction (Watts/sqft) ","Average Lighting Hours Estimate"," Lighting Summer Coincidence Factor","Lighting Winter Coincidence Factor"," Occupancy Sensor Summer Coincidence Factor","Occupancy Sensor  Winter Coincidence Factor","Target LPD For 10% Reduction (Watts/sqft)","Target LPD For 40% Reduction (Watts/sqft)"]
[{"$f":"A3","v":"Automotive facility "},0.75,null,2807,0.68300000000000005,0.36899999999999999,2.4E-2,6.6000000000000003E-2,{"$f":"B45*0.9","v":0.67500000000000004},{"$f":"B45*0.6","v":0.44999999999999996}]
["Convention center",0.64,null,913,0.17,9.1999999999999998E-2,2.4E-2,6.6000000000000003E-2,0.57600000000000007,0.38400000000000001]
["Courthouse ",0.79,null,4181,0.86899999999999999,0.76700000000000002,2.4E-2,6.6000000000000003E-2,0.71100000000000008,0.47399999999999998]
["Dining: bar lounge/leisure ",0.8,null,5018,0.77500000000000002,0.77,0.14699999999999999,0.13300000000000001,0.72000000000000008,0.48]
["Dining: cafeteria/fast food ",0.76,null,5018,0.77500000000000002,0.77,0.14699999999999999,0.13300000000000001,0.68400000000000005,0.45599999999999996]
["Dining: family ",0.71,null,5018,0.77500000000000002,0.77,0.14699999999999999,0.13300000000000001,0.63900000000000001,0.42599999999999999]
["Dormitory ",0.53,null,4026,0.36799999999999999,0.46,0.28299999999999997,0.23100000000000001,0.47700000000000004,0.318]
["Exercise center ",0.72,null,5836,0.98399999999999999,0.85599999999999998,0.14699999999999999,0.13300000000000001,0.64800000000000002,0.432]
["Fire station (unmanned)",0.56000000000000005,null,4336,0.86899999999999999,0.76700000000000002,2.4E-2,6.6000000000000003E-2,0.50400000000000011,0.33600000000000002]
["Gymnasium ",0.76,null,2586,0.59899999999999998,0.38800000000000001,0.20899999999999999,0.159,0.68400000000000005,0.45599999999999996]
["Health care clinic ",0.81,null,5564,0.82499999999999996,0.69599999999999995,0.23899999999999999,0.221,0.72900000000000009,0.48599999999999999]
["Hospital ",0.96,null,5413,0.82499999999999996,0.69599999999999995,0.23899999999999999,0.221,0.86399999999999999,0.57599999999999996]
["Hotel/Motel ",0.56000000000000005,null,3112,0.40600000000000003,0.375,2.4E-2,6.6000000000000003E-2,0.50400000000000011,0.33600000000000002]
["Library ",0.83,null,3748,0.70199999999999996,0.53900000000000003,0.27400000000000002,0.29599999999999999,0.747,0.49799999999999994]
["Manufacturing facility ",0.82,null,5793,0.83,0.66500000000000004,0.19800000000000001,0.17199999999999999,0.73799999999999999,0.49199999999999994]
["Motion picture theater ",0.44,null,1954,0.86899999999999999,0.76700000000000002,2.4E-2,6.6000000000000003E-2,0.39600000000000002,0.26400000000000001]
["Multifamily ",0.45,null,6388,0.17,1,0.18,0.12,0.40500000000000003,0.27]
["Museum ",0.55000000000000004,null,3748,0.98399999999999999,0.85599999999999998,0.14699999999999999,0.13300000000000001,0.49500000000000005,0.33]
["Office ",0.64,null,4098,0.70199999999999996,0.53900000000000003,0.27400000000000002,0.29599999999999999,0.57600000000000007,0.38400000000000001]
["Parking garage ",0.18,null,6887,1.4999999999999999E-2,0.873,2.4E-2,6.6000000000000003E-2,0.16200000000000001,0.108]
["Penitentiary ",0.69,null,5477,0.86899999999999999,0.76700000000000002,2.4E-2,6.6000000000000003E-2,0.621,0.41399999999999998]
["Performing arts theater ",0.84,null,913,0.86899999999999999,0.76700000000000002,2.4E-2,6.6000000000000003E-2,0.75600000000000001,0.504]
["Police station (24/7)",0.66,null,8760,0.76800000000000002,0.441,0.27400000000000002,0.29599999999999999,0.59400000000000008,0.39600000000000002]
["Post office ",0.65,null,3748,0.98399999999999999,0.85599999999999998,0.14699999999999999,0.13300000000000001,0.58500000000000008,0.39]
["Religious building ",0.67,null,913,0.17,9.1999999999999998E-2,2.4E-2,6.6000000000000003E-2,0.60300000000000009,0.40200000000000002]
["Retail ",0.84,null,4939,0.98399999999999999,0.85599999999999998,0.14699999999999999,0.13300000000000001,0.75600000000000001,0.504]
["School/university ",0.72,null,2967,0.59899999999999998,0.38800000000000001,0.20899999999999999,0.159,0.64800000000000002,0.432]
["Sports arena ",0.76,null,913,0.17,9.1999999999999998E-2,2.4E-2,6.6000000000000003E-2,0.68400000000000005,0.45599999999999996]
["Town hall ",0.69,null,4181,0.86899999999999999,0.76700000000000002,2.4E-2,6.6000000000000003E-2,0.621,0.41399999999999998]
["Transportation ",0.5,null,6456,0.68300000000000005,0.36899999999999999,2.4E-2,6.6000000000000003E-2,0.45,0.3]
["Warehouse ",0.45,null,5667,0.89300000000000002,0.72399999999999998,0.246,0.183,0.40500000000000003,0.27]
["Workshop ",0.91,null,3750,0.83,0.66500000000000004,0.19800000000000001,0.17199999999999999,0.81900000000000006,0.54600000000000004]
[]
["Always check with a lighting professional to ensure the lighting levels are appropriate for the tasks being performed in the space. "]
[]
[]
[null,null,null,"MIN",{"$f":"MIN(E45:E76)","v":1.4999999999999999E-2},9.1999999999999998E-2,2.4E-2,6.6000000000000003E-2]
["Coincident factors from 2023 PSD",null,null,"MAX",{"$f":"MAX(E45:E76)","v":0.98399999999999999},1,0.28299999999999997,0.29599999999999999]

{"sheet":"1A- Space by Space","index":5,"n_rows":41,"n_cols":10,"rows_kept":41,"cut":false,"hidden":true,"merged":[[8,2,8,3],[40,1,40,7],[41,1,47,7],[0,1,0,6],[1,1,2,6],[3,2,3,3],[4,2,4,3],[5,1,5,2]]}
[null,"Space by Space Area Types"]
[null,"Please use this tab if you are selecting the space-by-space method in tab 1: Interior Lighting & NLC. Total square footage must equal project square footage on the project data tab."]
[]
[null,"Area for each Space Type (sq ft)","Space Type",null,null,"Area for each Space Type (sq ft)","Space Type",null,"Area for each Space Type (sq ft)","Space Type"]
[null,null,"Common Space Types",null,null,null,"Common Space Types",null,null,"Common Space Types"]
[null,null,null,"Atrium Height (ft.)",null,null,"Laboratory - In or as a classroom ",null,null,"Healthcare facility - In an exam/treatment room "]
[null,null,"Atrium – 40 feet or less",null,null,null,"Laboratory - Otherwise ",null,null,"Healthcare facility - In an imaging room "]
[null,null,"Atrium – Above 40 feet",null,null,null,"Laundry/washing area ",null,null,"Healthcare facility - In a medical supply room "]
[null,null,"Audience/seating area - In an auditorium ",null,null,null,"Loading dock, interior ",null,null,"Healthcare facility - In a nursery "]
[null,null,"Audience/seating area - In a convention center ",null,null,null,"Lobby - In a facility for the visually impaired (and not used primarily by the staff) ",null,null,"Healthcare facility - In a nurse’s station "]
[null,null,"Audience/seating area - In a gymnasium ",null,null,null,"Lobby - For an elevator ",null,null,"Healthcare facility - In an operating room "]
[null,null,"Audience/seating area - In a motion picture theater ",null,null,null,"Lobby - In a hotel ",null,null,"Healthcare facility - In a patient room "]
[null,null,"Audience/seating area - In a penitentiary ",null,null,null,"Lobby - In a motion picture theater ",null,null,"Healthcare facility - In a physical therapy room "]
[null,null,"Audience/seating area - In a performing arts theater ",null,null,null,"Lobby - In a performing arts theater ",null,null,"Healthcare facility - In a recovery room "]
[null,null,"Audience/seating area - In a religious building ",null,null,null,"Lobby - Otherwise ",null,null,"Library - In a reading area "]
[null,null,"Audience/seating area - In a sports arena ",null,null,null,"Locker room ",null,null,"Library - In the stacks "]
[null,null,"Audience/seating area - Otherwise ",null,null,null,"Lounge/breakroom - In a healthcare facility ",null,null,"Manufacturing facility - In a detailed manufacturing area "]
[null,null,"Banking activity area ",null,null,null,"Lounge/breakroom - Otherwise ",null,null,"Manufacturing facility - In an equipment room "]
[null,null,"Classroom/lecture hall/training room - In a penitentiary ",null,null,null,"Office - Enclosed ",null,null,"Manufacturing facility - In an extra high bay area (greater than 50 ' floor to ceiling height) "]
[null,null,"Classroom/lecture hall/training room - Otherwise ",null,null,null,"Office - Open plan ",null,null,"Manufacturing facility - In a high bay area (25-50' floor to ceiling height) "]
[null,null,"Conference/meeting/multipurpose room ",null,null,null,"Parking area, interior ",null,null,"Manufacturing facility - In a low bay area (less than 25' floor to ceiling height) "]
[null,null,"Copy/print room ",null,null,null,"Pharmacy area ",null,null,"Museum - In a general exhibition area "]
[null,null,"Corridor - In a facility for the visually impaired (and not used primarily by the staff) ",null,null,null,"Restroom - In a facility for the visually impaired (and not used primarily by the staff) ",null,null,"Museum - In a restoration room "]
[null,null,"Corridor - In a hospital ",null,null,null,"Restroom - Otherwise ",null,null,"Performing arts theater—dressing room "]
[null,null,"Corridor - In a manufacturing facility ",null,null,null,"Sales area ",null,null,"Post Office—Sorting Area "]
[null,null,"Corridor - Otherwise ",null,null,null,"Seating area, general ",null,null,"Religious buildings - In a fellowship hall "]
[null,null,"Courtroom ",null,null,null,"Stairwell ",null,null,"Religious buildings - In a worship/pulpit/choir area "]
[null,null,"Computer room ",null,null,null,"Storage room ",null,null,"Retail facilities - In a dressing/fitting room "]
[null,null,"Dining area - In a penitentiary ",null,null,null,"Vehicular maintenance area ",null,null,"Retail facilities - In a mall concourse "]
[null,null,"Dining area - In a facility for the visually impaired (and not used primarily by the staff) ",null,null,null,"Workshop ",null,null,"Sports arena—playing area - For a Class I facility "]
[null,null,"Dining area - In bar/lounge or leisure dining ",null,null,null,"Facility for the visually impaired - In a chapel (and not used primarily by the staff) ",null,null,"Sports arena—playing area - For a Class II facility "]
[null,null,"Dining area - In cafeteria or fast food dining ",null,null,null,"Facility for the visually impaired - In a recreation room (and not used primarily by the staff) ",null,null,"Sports arena—playing area - For a Class III facility "]
[null,null,"Dining area - In family dining ",null,null,null,"Convention Center—exhibit space ",null,null,"Sports arena—playing area - For a Class IV facility "]
[null,null,"Dining area - Otherwise ",null,null,null,"Dormitory—living quarters ",null,null,"Transportation facility - In a baggage/carousel area "]
[null,null,"Electrical/mechanical room ",null,null,null,"Fire Station—sleeping quarters ",null,null,"Transportation facility - In an airport concourse "]
[null,null,"Emergency vehicle garage ",null,null,null,"Gymnasium/fitness center - In an exercise area ",null,null,"Transportation facility - At a terminal ticket counter "]
[null,null,"Food preparation area ",null,null,null,"Gymnasium/fitness center - In a playing area ",null,null,"Warehouse—storage area - For medium to bulky, palletized items "]
[null,null,"Guest room ",null,null,null,null,null,null,"Warehouse—storage area - For smaller, hand carried items"]
[null,null,null,null,null,null,null,null,{"$f":"SUM(B7:B38)+SUM(F6:F37)+SUM(I6:I38)","v":0},"TOTAL SF"]
[]
[null,"Provide any additional information relevant to this project."]

{"sheet":"lists","index":6,"n_rows":32,"n_cols":7,"rows_kept":32,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,null,null,null,null,"Lights On (PM)","Lights Off (AM)"]
[null,"Area Types","Units","Building Area Method",null,"Dusk","Dawn"]
[1,"Parking Areas and Drives - Uncovered","Sqft of Lit Area","Space by Space Calculation, see Space by Space tab",null,4,"11 PM"]
[2,"Building Grounds - Walkways Less Than 10' Wide","Linear Feet",null,null,5,"Midnight"]
[3,"Building Grounds - Walkways 10' Wide or Greater, Plaza Areas, or Special Feature Areas","Sqft of Lit Area",null,null,6,1]
[4,"Building Grounds - Dining Areas","Sqft of Lit Area",null,null,7,2]
[5,"Building Grounds - Stairways","Sqft of Lit Area",null,null,8,3]
[6,"Building Grounds - Pedestrian Tunnels","Sqft of Lit Area",null,null,9,4]
[7,"Building Grounds - Landscaping","Sqft of Lit Area",null,null,10,5]
[8,"Pedestrian & Vehicular Entrances & Exits","Linear Feet (door width)",null,null,11,6]
[9,"Building Entrance and Exit - Entry Canopies","Sqft of Lit Area",null,null,"Midnight",7]
[10,"Building Entrance and Exit - Loading Docks","Sqft of Lit Area"]
[11,"Sales Canopies - Free-Standing and Attached","Sqft of Lit Area"]
[12,"Outdoor Sales - Open Areas (including vehicle sales lots)","Sqft of Lit Area"]
[13,"Outdoor Sales - Street Frontage For Vehicle Sales Lots","Linear Feet"]
[14,"Building Facades","Sqft of Lit Wall Area"]
[15,"Automated Teller Machines and Night Depositories","Qty of ATMs"]
[16,"Uncovered Entrances and Gate-House Inspection Stations","Sqft of Lit Area"]
[17,"Uncovered Loading Areas for Law Enforcement, Fire, Ambulance, Emergency","Sqft of Lit Area"]
[18,"Drive-up Windows","Qty of Drive-Ups"]
[19,"Parking Near 24 Hour Retail Entrances","Qty of Entries"]
[]
[]
[]
[]
[]
[]
[null,"Yes"]
[null,"No"]
[null,"N/A (not applicable)"]

{"sheet":"2- Occupancy Sensors","index":7,"n_rows":46,"n_cols":16,"rows_kept":46,"cut":false,"hidden":true,"merged":[[0,1,0,15],[1,1,1,7],[4,1,4,11],[6,4,6,5],[7,4,7,5],[8,1,8,4],[11,4,11,5],[21,7,21,9],[26,7,26,9],[30,7,30,9],[21,1,21,3],[22,1,22,3],[23,1,23,3],[24,1,24,3],[46,2,52,8],[39,12,39,14],[40,12,40,14],[18,7,18,9],[19,7,19,9],[20,7,20,9]]}
["Click to go back to the Project Summary tab","Occupancy Sensors"]
[null,"Participant must obtain conditional approval from the Utilities prior to the purchase or installation of any energy efficiency measures to be eligible to receive efficiency incentives. \n\nThe following are required for ALL measures:  \n        (1) Proposal to customer\n        (2) ALL specification sheets and supporting documents.\n        (3) Data fields (in yellow) on applicable tabs MUST BE FILLED IN"]
[]
[]
[null,"*Occupancy sensors can only qualify if they are not used to satisfy code requirements. Under IECC 2021 occupancy sensors are required in classrooms, conference/meeting rooms, copy/print rooms, lounges, employee lunch and break rooms, private offices, restrooms, storage rooms, janitorial closets, locker rooms, warehouse, and other spaces 300 square feet or less enclosed by floor-to-ceiling height partitions and the occupancy sensors must be a second level of automated control\n"]
[null,""]
[null,"*Fixture Code\n(Match to the fixture code used in the interior lighting tab)","Quantity of Fixtures Under Occupancy Control","Quantity of Occupancy Sensors To Be Installed","Space Type",null,null,"*Fixture Code\n(Match to the fixture code used in the interior lighting tab)","Quantity of Fixtures Under Occupancy Control","Quantity of Occupancy Sensors To Be Installed","Space Type",null,"*Fixture Code\n(Match to the fixture code used in the interior lighting tab)","Quantity of Fixtures Under Occupancy Control","Quantity of Occupancy Sensors To Be Installed","Space Type"]
[null,null,null,null,"Common Space Types",null,null,null,null,null,"Common Space Types",null,null,null,null,"Common Space Types"]
[null,null,null,null,null,"Atrium Height (ft.)",null,null,null,null,"Laboratory - In or as a classroom ",null,null,null,null,"Healthcare facility - In an exam/treatment room "]
[null,null,null,null,"Atrium – 40 feet or less",null,null,null,null,null,"Laboratory - Otherwise ",null,null,null,null,"Healthcare facility - In an imaging room "]
[null,null,null,null,"Atrium – Above 40 feet",null,null,"x",45,2,"Laundry/washing area ",null,null,null,null,"Healthcare facility - In a medical supply room "]
[null,null,null,null,"Audience/seating area - In an auditorium ",null,null,null,null,null,"Loading dock, interior ",null,null,null,null,"Healthcare facility - In a nursery "]
[null,null,null,null,"Audience/seating area - In a convention center ",null,null,null,null,null,"Lobby - In a facility for the visually impaired (and not used primarily by the staff) ",null,null,null,null,"Healthcare facility - In a nurse’s station "]
[null,null,null,null,"Audience/seating area - In a gymnasium ",null,null,null,null,null,"Lobby - For an elevator ",null,null,null,null,"Healthcare facility - In an operating room "]
[null,null,null,null,"Audience/seating area - In a motion picture theater ",null,null,null,null,null,"Lobby - In a hotel ",null,null,null,null,"Healthcare facility - In a patient room "]
[null,null,null,null,"Audience/seating area - In a penitentiary ",null,null,null,null,null,"Lobby - In a motion picture theater ",null,null,null,null,"Healthcare facility - In a physical therapy room "]
[null,null,null,null,"Audience/seating area - In a performing arts theater ",null,null,null,null,null,"Lobby - In a performing arts theater ",null,null,null,null,"Healthcare facility - In a recovery room "]
[null,null,null,null,"Audience/seating area - In a religious building ",null,null,null,null,null,"Lobby - Otherwise ",null,null,null,null,"Library - In a reading area "]
[null,null,null,null,"Audience/seating area - In a sports arena ",null,null,"REQUIRED BY ENERGY CODE",null,null,"Locker room ",null,null,null,null,"Library - In the stacks "]
[null,null,null,null,"Audience/seating area - Otherwise ",null,null,"REQUIRED BY ENERGY CODE",null,null,"Lounge/breakroom - In a healthcare facility ",null,null,null,null,"Manufacturing facility - In a detailed manufacturing area "]
[null,null,null,null,"Banking activity area ",null,null,"REQUIRED BY ENERGY CODE",null,null,"Lounge/breakroom - Otherwise ",null,null,null,null,"Manufacturing facility - In an equipment room "]
[null,"REQUIRED BY ENERGY CODE",null,null,"Classroom/lecture hall/training room - In a penitentiary ",null,null,"REQUIRED BY ENERGY CODE",null,null,"Office - Enclosed ",null,null,null,null,"Manufacturing facility - In an extra high bay area (greater than 50 ' floor to ceiling height) "]
[null,"REQUIRED BY ENERGY CODE",null,null,"Classroom/lecture hall/training room - Otherwise ",null,null,null,null,null,"Office - Open plan ",null,null,null,null,"Manufacturing facility - In a high bay area (25-50' floor to ceiling height) "]
[null,"REQUIRED BY ENERGY CODE",null,null,"Conference/meeting/multipurpose room ",null,null,null,null,null,"Parking area, interior ",null,null,null,null,"Manufacturing facility - In a low bay area (less than 25' floor to ceiling height) "]
[null,"REQUIRED BY ENERGY CODE",null,null,"Copy/print room ",null,null,null,null,null,"Pharmacy area ",null,null,null,null,"Museum - In a general exhibition area "]
[null,null,null,null,"Corridor - In a facility for the visually impaired (and not used primarily by the staff) ",null,null,null,null,null,"Restroom - In a facility for the visually impaired (and not used primarily by the staff) ",null,null,null,null,"Museum - In a restoration room "]
[null,null,null,null,"Corridor - In a hospital ",null,null,"REQUIRED BY ENERGY CODE",null,null,"Restroom - Otherwise ",null,null,null,null,"Performing arts theater—dressing room "]
[null,null,null,null,"Corridor - In a manufacturing facility ",null,null,null,null,null,"Sales area ",null,null,null,null,"Post Office—Sorting Area "]
[null,null,null,null,"Corridor - Otherwise ",null,null,null,null,null,"Seating area, general ",null,null,null,null,"Religious buildings - In a fellowship hall "]
[null,null,null,null,"Courtroom ",null,null,null,null,null,"Stairwell ",null,null,null,null,"Religious buildings - In a worship/pulpit/choir area "]
[null,null,null,null,"Computer room ",null,null,"REQUIRED BY ENERGY CODE",null,null,"Storage room ",null,null,null,null,"Retail facilities - In a dressing/fitting room "]
[null,null,null,null,"Dining area - In a penitentiary ",null,null,null,null,null,"Vehicular maintenance area ",null,null,null,null,"Retail facilities - In a mall concourse "]
[null,null,null,null,"Dining area - In a facility for the visually impaired (and not used primarily by the staff) ",null,null,null,null,null,"Workshop ",null,null,null,null,"Sports arena—playing area - For a Class I facility "]
[null,null,null,null,"Dining area - In bar/lounge or leisure dining ",null,null,null,null,null,"Facility for the visually impaired - In a chapel (and not used primarily by the staff) ",null,null,null,null,"Sports arena—playing area - For a Class II facility "]
[null,null,null,null,"Dining area - In cafeteria or fast food dining ",null,null,null,null,null,"Facility for the visually impaired - In a recreation room (and not used primarily by the staff) ",null,null,null,null,"Sports arena—playing area - For a Class III facility "]
[null,null,null,null,"Dining area - In family dining ",null,null,null,null,null,"Convention Center—exhibit space ",null,null,null,null,"Sports arena—playing area - For a Class IV facility "]
[null,null,null,null,"Dining area - Otherwise ",null,null,null,null,null,"Dormitory—living quarters ",null,null,null,null,"Transportation facility - In a baggage/carousel area "]
[null,null,null,null,"Electrical/mechanical room ",null,null,null,null,null,"Fire Station—sleeping quarters ",null,null,null,null,"Transportation facility - In an airport concourse "]
[null,null,null,null,"Emergency vehicle garage ",null,null,null,null,null,"Gymnasium/fitness center - In an exercise area ",null,null,null,null,"Transportation facility - At a terminal ticket counter "]
[null,null,null,null,"Food preparation area ",null,null,null,null,null,"Gymnasium/fitness center - In a playing area ",null,"REQUIRED BY ENERGY CODE",null,null,"Warehouse—storage area - For medium to bulky, palletized items "]
[null,null,null,null,"Guest room ",null,null,null,null,null,null,null,"REQUIRED BY ENERGY CODE",null,null,"Warehouse—storage area - For smaller, hand carried items"]
[]
[]
[]
[]
[null,null,"Provide any additional information relevant to this project."]

{"sheet":"21- Daylighting","index":8,"n_rows":35,"n_cols":13,"rows_kept":35,"cut":false,"hidden":true,"merged":[[0,1,0,9],[1,0,1,1],[1,2,1,8],[8,1,8,3],[9,1,9,3],[10,1,10,3],[10,8,10,12],[11,1,11,3],[12,1,12,3],[13,1,13,3],[14,1,14,3],[14,5,14,7],[17,8,17,10],[18,1,18,3],[31,1,31,3],[32,1,32,3],[33,1,33,3],[19,1,19,3],[20,1,20,3],[21,1,21,3],[22,1,22,3],[28,1,28,3],[29,1,29,3],[30,1,30,3]]}
[null,"Interior Lighting - Daylighting Sensors"]
["Project: ",null,{"$f":"'Project Summary'!#REF!","v":{"$error":"#REF!"}}]
[]
["Lighting Schedule: Months included (input 0 if month not included in analysis and 1 if it is)"]
[null,"January","February","March","April","May","June","July","August","September","October","November","December"]
["Months"]
[]
[null,null,null,null,"Fill Out:","Units","Fill Out (EXAMPLE):","Units (EXAMPLE):"]
[null,"Total Window Area in daylit zones",null,null,null,"SF",100,"SF"]
[null,"Total Wall Area (with windows) in daylit zones",null,null,null,"SF",300,"SF"]
[null,"Window to Wall Ratio**\n(Total Window Area/Total Wall Area)",null,null,{"$f":"E9/E10","v":{"$error":"#DIV/0!"}},"%",{"$f":"G9/G10","v":0.33333333333333331},"%","**A MINIUM OF 30% WINDOW TO WALL RATIO IS REQUIRED TO QUALIFY FOR INCENTIVES"]
[null,"Daylighting Zone Area*",null,null,null,"SF",100,"SF"]
[null,"Total Number of Sensors ",null,null,null,null,6]
[null,"Cost to add Daylighting System to project including design, installation and commissioning",null,null,null,null,950]
[null,"Floor and Lighting Plan Attached?",null,null,"Yes","Notes:"]
[null,"*Fixtures must be within the daylighting zone as defined by ASHRAE 90.1 - 2010 and not required by IECC 2012"]
[]
[null,"Controlled Fixture Schedule",null,null,null,null,null,null,"Lighting Schedule"]
[null,"Fixture designation",null,null,"Quantity of fixtures under control","Wattage","Total wattage",null,null,"Start Time","End Time"]
[null,null,null,null,null,null,{"$f":"F20*E20","v":0},null,"Weekday","N/A","N/A"]
[null,null,null,null,null,null,0,null,"Saturday","N/A","N/A"]
[null,null,null,null,null,null,0,null,"Sunday","N/A","N/A"]
[null,null,null,null,null,null,0]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,{"$f":"F29*E29","v":0}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,{"$f":"SUM(E20:E34)","v":0},null,{"$f":"SUM(G20:G34)","v":0}]

{"sheet":"4- Exterior Lighting","index":9,"n_rows":43,"n_cols":26,"rows_kept":43,"cut":false,"hidden":true,"merged":[[31,13,31,17],[34,12,34,17],[42,1,42,9],[43,1,49,9],[0,1,0,10],[1,1,1,10],[3,1,3,10],[5,1,5,2],[8,5,11,8],[9,12,11,13],[14,1,14,10],[14,12,14,17],[16,13,16,17],[18,13,18,17],[25,13,25,17],[29,13,29,17]]}
["Click to go back on Project summary tab","Exterior Lighting"]
[null,"Please complete all yellow cells and provide:\n- Spec sheets for all fixtures\n- Project lighting plans/lighting schedules\n- a COMcheck"]
[]
[null,"Include all exterior fixtures for proposed design, even those not listed as high performance (LED) or existing to remain. All fixtures must be LED to qualify. The minimum incentive is earned at 10% below code lighting power. LED fixtures or lamps are required to be UL listed and are highly recommended to be Design Lights Consortium (DLC) or Energy Star’s Qualified Products. The incentive is calculated based on energy savings: $.40/kWh annual savings or $1,000/summer peak kW and capped based on the table below. "]
[]
[null,"Incentives - LEDs ONLY"]
[null,"Fixture Type","Maximum Incentive per Fixture"]
[null,"Pole Lights per Head",125]
[null,"Wall packs and wall mounted",50,null,null,"PLEASE FILL OUT THE EXTERIOR LIGHTS POWER ALLOWANCE IN COLUMNS N THROUGH R WHEN FILLING OUT THIS TAB. LINEAL FEET FOR DOORWAYS REQUIRES WIDTH OF THE DOORS. --->"]
[null,"Bollards",30,null,null,null,null,null,null,null,null,null,"Uncovered exterior lights should not exceed 4368 hours/year."]
[null,"Canopy Lights",50]
[null,"Other Eligible LED fixtures",30]
[null,"Ineligible fixtures, ex. fluorescent, induction",0]
[null,null,null,null,null,null,null,null,null,null,null,null,"Project Lighting Zone (Per PSD Table 2-8 shown to the right)"]
[null," High Efficiency Exterior Design Proposed",null,null,null,null,null,null,null,null,null,null,"Exterior Lighting Power Allowance"]
[null,"Fixture Code (Optional)","Fixtures by Area Type\n(use drop down list)","Total Quantity of New Fixtures","Quantity of Existing Fixtures Remaining","Eligible Technology? (Y/N)","Advanced Technology? (Y/N)","Fixture Description\nManufacturer and Model number\n*INCLUDE A SPEC SHEET FOR EACH FIXTURE WHEN YOU SUBMIT THIS FORM*","Fixture Description","Actual Fixture Wattage","Total Wattage For This Fixture",null,"Base Site Allowance (Base allowance is usable in tradable or nontradable surfaces.)","Sq Ft of Lit Area","Units","Annual Hours of Light Use*","Time the Lights Turn On (PM)","Time the Lights Turn Off (AM)"]
[null,"Example: A","Building Grounds -Walkways Less Than 10' Wide",4,1,"Y ","Y","EXAMPLE: Manufacturer model XYZ","LED wall washers/ wall mounted fixtures",50,{"$f":"(J17*E17)+(J17*D17)","v":250},null,"Uncovered Parking Areas"]
[null,"Example: B","Parking Areas and Drives - Uncovered",5,0,"Y","Y","EXAMPLE: Manufacturer model XYZ","LED heads on poles",60,300,null,{"$f":"lists!B5","v":"Parking Areas and Drives - Uncovered"},null,{"$f":"VLOOKUP(M18,lists!$B$5:$C$23,2,FALSE)","v":"Sqft of Lit Area"},{"$f":"IF(OR(Q18=\"\",R18=\"\"),\"\",(SUM(IF(Q18=\"Dusk\",12-6.5,IF(Q18=\"Midnight\",0,12-Q18)),IF(R18=\"Dawn\",6,IF(R18=\"Midnight\",0,IF(R18=\"11 PM\",-1,R18))))*52*7))","v":""}]
[null,null,null,null,null,null,null,null,null,null,0,null,"Building Grounds",null,null,null,null,null,null,null,null,null,null,null,null,"LED heads on poles"]
[null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"lists!B6","v":"Building Grounds - Walkways Less Than 10' Wide"},null,{"$f":"VLOOKUP(M20,lists!$B$5:$C$23,2,FALSE)","v":"Linear Feet"},{"$f":"IF(OR(Q20=\"\",R20=\"\"),\"\",(SUM(IF(Q20=\"Dusk\",12-6.5,IF(Q20=\"Midnight\",0,12-Q20)),IF(R20=\"Dawn\",6,IF(R20=\"Midnight\",0,IF(R20=\"11 PM\",-1,R20))))*52*7))","v":""},null,null,null,null,null,null,null,null,null,"LED wall washers/ wall mounted fixtures"]
[null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"lists!B7","v":"Building Grounds - Walkways 10' Wide or Greater, Plaza Areas, or Special Feature Areas"},null,{"$f":"VLOOKUP(M21,lists!$B$5:$C$23,2,FALSE)","v":"Sqft of Lit Area"},"",null,null,null,null,null,null,null,null,null,"LED bollards"]
[null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"lists!B8","v":"Building Grounds - Dining Areas"},null,{"$f":"VLOOKUP(M22,lists!$B$5:$C$23,2,FALSE)","v":"Sqft of Lit Area"},"",null,null,null,null,null,null,null,null,null,"LED canopy lights"]
[null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"lists!B9","v":"Building Grounds - Stairways"},null,{"$f":"VLOOKUP(M23,lists!$B$5:$C$23,2,FALSE)","v":"Sqft of Lit Area"},"",null,null,null,null,null,null,null,null,null,"Induction lights"]
[null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"lists!B10","v":"Building Grounds - Pedestrian Tunnels"},null,{"$f":"VLOOKUP(M24,lists!$B$5:$C$23,2,FALSE)","v":"Sqft of Lit Area"},"",null,null,null,null,null,null,null,null,null,"Other eligible LED fixture"]
[null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"lists!B11","v":"Building Grounds - Landscaping"},null,{"$f":"VLOOKUP(M25,lists!$B$5:$C$23,2,FALSE)","v":"Sqft of Lit Area"},"",null,null,null,null,null,null,null,null,null,"Ineligible fixture"]
[null,null,null,null,null,null,null,null,null,null,0,null,"Building Entrances and Exits"]
[null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"lists!B12","v":"Pedestrian & Vehicular Entrances & Exits"},null,{"$f":"VLOOKUP(M27,lists!$B$5:$C$23,2,FALSE)","v":"Linear Feet (door width)"},{"$f":"IF(OR(Q27=\"\",R27=\"\"),\"\",(SUM(IF(Q27=\"Dusk\",12-6.5,IF(Q27=\"Midnight\",0,12-Q27)),IF(R27=\"Dawn\",6,IF(R27=\"Midnight\",0,IF(R27=\"11 PM\",-1,R27))))*52*7))","v":""}]
[null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"lists!B13","v":"Building Entrance and Exit - Entry Canopies"},null,{"$f":"VLOOKUP(M28,lists!$B$5:$C$23,2,FALSE)","v":"Sqft of Lit Area"},""]
[null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"lists!B14","v":"Building Entrance and Exit - Loading Docks"},null,{"$f":"VLOOKUP(M29,lists!$B$5:$C$23,2,FALSE)","v":"Sqft of Lit Area"},""]
[null,null,null,null,null,null,null,null,null,null,0,null,"Sales Canopies"]
[null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"lists!B15","v":"Sales Canopies - Free-Standing and Attached"},null,{"$f":"VLOOKUP(M31,lists!$B$5:$C$23,2,FALSE)","v":"Sqft of Lit Area"},{"$f":"IF(OR(Q31=\"\",R31=\"\"),\"\",(SUM(IF(Q31=\"Dusk\",12-6.5,IF(Q31=\"Midnight\",0,12-Q31)),IF(R31=\"Dawn\",6,IF(R31=\"Midnight\",0,IF(R31=\"11 PM\",-1,R31))))*52*7))","v":""}]
[null,null,null,null,null,null,null,null,null,null,0,null,"Outdoor Sales"]
[null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"lists!B16","v":"Outdoor Sales - Open Areas (including vehicle sales lots)"},null,{"$f":"VLOOKUP(M33,lists!$B$5:$C$23,2,FALSE)","v":"Sqft of Lit Area"},{"$f":"IF(OR(Q33=\"\",R33=\"\"),\"\",(SUM(IF(Q33=\"Dusk\",12-6.5,IF(Q33=\"Midnight\",0,12-Q33)),IF(R33=\"Dawn\",6,IF(R33=\"Midnight\",0,IF(R33=\"11 PM\",-1,R33))))*52*7))","v":""}]
[null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"lists!B17","v":"Outdoor Sales - Street Frontage For Vehicle Sales Lots"},null,{"$f":"VLOOKUP(M34,lists!$B$5:$C$22,2,FALSE)","v":"Linear Feet"},""]
[null,null,null,null,null,null,null,null,null,null,0,null,"Non-Tradeable Surfaces"]
[null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"lists!B18","v":"Building Facades"},null,{"$f":"VLOOKUP(M36,lists!$B$5:$C$23,2,FALSE)","v":"Sqft of Lit Wall Area"},{"$f":"IF(OR(Q36=\"\",R36=\"\"),\"\",(SUM(IF(Q36=\"Dusk\",12-6.5,IF(Q36=\"Midnight\",0,12-Q36)),IF(R36=\"Dawn\",6,IF(R36=\"Midnight\",0,IF(R36=\"11 PM\",-1,R36))))*52*7))","v":""}]
[null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"lists!B19","v":"Automated Teller Machines and Night Depositories"},null,{"$f":"VLOOKUP(M37,lists!$B$5:$C$23,2,FALSE)","v":"Qty of ATMs"},""]
[null,"Totals",null,{"$f":"SUM(D19:D37)","v":0},0,null,null,null,{"$f":"SUM(K19:K37)","v":0},null,null,null,{"$f":"lists!B20","v":"Uncovered Entrances and Gate-House Inspection Stations"},null,{"$f":"VLOOKUP(M38,lists!$B$5:$C$23,2,FALSE)","v":"Sqft of Lit Area"},""]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"lists!B21","v":"Uncovered Loading Areas for Law Enforcement, Fire, Ambulance, Emergency"},null,{"$f":"VLOOKUP(M39,lists!$B$5:$C$23,2,FALSE)","v":"Sqft of Lit Area"},""]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"lists!B22","v":"Drive-up Windows"},null,{"$f":"VLOOKUP(M40,lists!$B$5:$C$23,2,FALSE)","v":"Qty of Drive-Ups"},""]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"lists!B23","v":"Parking Near 24 Hour Retail Entrances"},null,{"$f":"VLOOKUP(M41,lists!$B$5:$C$23,2,FALSE)","v":"Qty of Entries"},""]
[]
[null,"Provide any additional information relevant to this project."]

{"sheet":"5- Unitary & Split DX","index":10,"n_rows":32,"n_cols":17,"rows_kept":32,"cut":false,"hidden":true,"merged":[[8,0,8,6],[0,1,0,6],[1,1,4,6],[6,0,6,6],[32,0,38,6],[31,0,31,6],[1,12,1,15],[2,12,3,12],[2,13,3,14],[2,15,3,16]]}
["Click to go back to project summary tab","Unitary & Split DX HVAC"]
[null,"Please complete all yellow cells and provide:\n- Site mechanical plans\n- Spec sheets for each unit\n- AHRI certificate for each unit",null,null,null,null,null,null,null,null,"Packaged & Split DX HVAC Equipment Incentives",null,"Packaged & Split DX HVAC Equipment Incentives"]
[null,null,null,null,null,null,null,null,null,null,"Size",null,"Size","Tier 1 ",null,"Tier 2"]
[]
[null,null,null,null,null,null,null,null,null,null,"Nominal Tons",null,"MBTU/Hr","Minimum Qualifying Ratings (based on AHRI)","Incentive ($/Ton)","Minimum Qualifying Ratings (based on AHRI)","Incentive ($/Ton)"]
[null,null,null,null,null,null,null,null,null,null,"< 5.4 (packaged unit equipment only)",null,"< 65 (packaged unit equipment only)","15.2 SEER2",50,"16.0 SEER2",150]
["*Full system rating is required on split HVAC equipment. No incentives are available for the condensing unit alone.",null,null,null,null,null,null,null,null,null,"≥ 5.4 to < 11.3",null,"≥ 65 to < 135","16.3 IEER",50,"18 IEER",150]
[null,null,null,null,null,null,null,null,null,null,"≥ 11.3 to < 20",null,"≥ 135 to < 240","15.6 IEER",50,"17 IEER ",150]
["Unitary & Split DX HVAC Proposed",null,null,null,null,null,null,null,null,null,"≥ 20 to ≤ 30",null,"≥ 240 to ≤ 375","14.5 IEER",50,"15.8 IEER",150]
["Unit ID","Installed Quantity","Manufacturer & Model Number","AHRI Cooling Capacity (BTU/Hr)","Equipment Type \n(if <65,000 BTUh) \nUnitary or Split","Installed IEER (Use SEER2 under 65,000 Btu/h)","AHRI Certified Reference Number",null,null,null,"> 30 to < 63.3",null,"> 375 to ≤ 760","14.5 IEER",50,"15.8 IEER",150]
["EXAMPLE: RTU-1",1,"XYZ COMPANY",67000,"Unitary",12,1234567,null,null,null,"> 63.3",null,"> 760","13.5 IEER",50,"14.9 IEER",150]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Unitary"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Split"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Attached with Data \nCollection Submission"]
[null,null,null,null,null,null,null,null,null,null,"Pasted Below"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Provide any additional information relevant to this project."]

{"sheet":"6- Air Source Heat Pumps","index":11,"n_rows":42,"n_cols":30,"rows_kept":42,"cut":false,"hidden":true,"merged":[[16,1,16,13],[10,1,10,5],[15,1,15,5],[4,21,5,21],[4,22,5,22],[4,25,4,26],[5,25,5,26],[3,25,3,26],[11,1,11,4],[0,1,0,10],[1,1,3,10],[1,21,1,27],[2,23,3,23],[2,24,2,25],[2,26,2,27],[5,1,8,10],[6,25,6,26],[7,25,7,26],[8,25,8,26],[9,25,9,26],[2,21,2,22],[17,4,17,5],[18,4,18,5],[19,4,19,5],[20,4,20,5],[21,4,21,5],[22,4,22,5],[23,4,23,5],[24,4,24,5],[25,4,25,5],[26,4,26,5],[27,4,27,5],[28,4,28,5],[36,4,36,5],[29,4,29,5],[30,4,30,5],[31,4,31,5],[32,4,32,5],[33,4,33,5],[34,4,34,5],[35,4,35,5],[42,1,48,13],[41,1,41,13]]}
["Click to go back to the summary tab","Air Source Heat Pumps (non VRF/VRV)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Full "]
[null,"Please complete all yellow cells and provide:\n- Site mechanical plans\n- Spec sheets for each unit\n- AHRI certificate for each unit",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Air Source Heat Pump Incentives2",null,null,null,null,null,null,null,"Partial - more than 50%"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Size",null,"Type","Minimum Ratings (based on AHRI)",null,"Incentive ",null,null,"Partial - less than 50%"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nominal Tons","MBTU/Hr",null,"SEER/EER","COP/HSPF",null,"($/Heating Ton)",null,"Not used for primary heating"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"< 5.4","< 65","Split System","16.4 SEER2","8.6 HSPF2",null,"$640 capped at \nEversource: $400,000\nAvangrid: $200,000"]
[null,"*Path 4 Systems projects engaging after 100%  construction documents (CDs) will be eligible for heat pump incentives at 50% of these stated rates.\n\n**Heating and cooling capability required for heat pump systems to receive high-level heat pump savings. Heat pump values may be decreased for projects engaging after 100% construction documents on the Path 4 Systems pathway.\n\n***See Energy Recovery tab for DOAS systems with energy recovery not required by code.  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Single Pkg","15.2 SEER2","8.1 HSPF2",null,"$640 capped at \nEversource: $400,000\nAvangrid: $200,000"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"≥ 5.4 to < 11.3","≥ 65 to < 135","All","15.4 IEER","3.5 COP",null,"$640 capped at \nEversource: $400,000\nAvangrid: $200,000"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"≥ 11.3 to < 20","≥135 to <240","All","14.6 IEER","3.4 COP",null,"$640 capped at \nEversource: $400,000\nAvangrid: $200,000"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"≥ 20 to ≤ 30","≥ 240 to ≤ 375 ","All","13 IEER","3.3 COP",null,"$640 capped at \nEversource: $400,000\nAvangrid: $200,000"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"> 30","> 375 ","All","13 IEER","3.3 COP",null,"$640 capped at \nEversource: $400,000\nAvangrid: $200,000"]
[null,"Are heat pumps the main source of heating for the project?"]
[]
[]
[]
[]
[]
[null,"Air Source Heat Pumps (non VRV/ VRF) Units Proposed"]
[null,"Unit ID","Indoor Unit Type","Quantity","Manufacturer / Full Model Number",null,"AHRI Cooling Capacity (Btu/hr)","AHRI Heating Capacity at 47°F (Btu/hr)","Equipment Type if Cooling Capacity <65,000 Btu/hr","Installed IEER (Use SEER2 under 65,000 btu/h)","Installed AHRI Heating COP @ 47deg F\n (Use HSPF2  under 65,000 btu/h) ","Installed AHRI Heating COP @5 deg F\n (Use HSPF2  under 65,000 btu/h) ","AHRI Certified Reference Number","Integrated Control Model Number (if not main source of heating)",null,null,null,null,"Ducted",null,"Attached with Data \nCollection Submission"]
[null,"EXAMPLE: ASHP-1","Ducted",1,"XYZ COMPANY / MODEL XYZ123",null,67,12,"Ductless Single Zone",1234567,1234567,1234567,1234567,1234567,null,null,null,null,"Non-Ducted",null,"Pasted Below"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mixed"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null," ",null,null,null," ",null," "]
[]
[]
[]
[null,"Provide any additional information relevant to this project."]

{"sheet":"7- Ground Source Heat Pumps","index":12,"n_rows":41,"n_cols":27,"rows_kept":41,"cut":false,"hidden":true,"merged":[[12,8,12,9],[13,8,13,9],[14,1,14,5],[15,1,15,5],[0,1,0,10],[3,1,6,10],[8,8,8,13],[9,8,9,13],[10,8,10,9],[11,8,11,9],[11,13,13,13],[7,1,12,6],[16,17,16,20],[17,6,17,9],[17,10,17,13],[17,14,18,14],[18,3,18,4],[17,15,18,15],[16,1,16,15],[19,3,19,4],[20,3,20,4],[21,3,21,4],[22,3,22,4],[23,3,23,4],[24,3,24,4],[25,3,25,4],[26,3,26,4],[34,3,34,4],[35,3,35,4],[27,3,27,4],[28,3,28,4],[29,3,29,4],[30,3,30,4],[31,3,31,4],[32,3,32,4],[33,3,33,4],[36,3,36,4],[37,3,37,4],[38,3,38,4],[40,1,40,10],[41,1,47,10]]}
["Click to go back to the Project Summary Tab","Ground Source Heat Pumps"]
[]
[]
[null,"Please complete all yellow cells and provide:\n- Site mechanical plans\n- Spec sheets for each unit\n- AHRI certificate for each unit"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Full"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Partial - More than 50%"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Partial - Less than 50%"]
[null,"*Efficiencies are for closed ground loop systems. AHRI denotes both Brine (liquid) to Air and Brine (liquid) to Water as Ground Loop Heat Pumps (GLHP). \n\n**Systems with heating capacity >135,000 MBTU/hr may be evaluated on a case-by-case basis.\n\n**Heating and cooling capacity required for heat pump systems to receive high-level heat pump savings. Heat pump values will be decreased to 50% for projects engaging after 100% consutrction documents in the Path 4: Systems pathway.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Not Used for Primary Heating"]
[null,null,null,null,null,null,null,null,"Incentives"]
[null,null,null,null,null,null,null,null,"Ground Source Heat Pump Equipment"]
[null,null,null,null,null,null,null,null,"Type",null,"Nominal Tons","Minimum Qualifying EER (based on AHRI)","Minimum Qualifying COP (based on AHRI)","Incentive $/Heating Ton"]
[null,null,null,null,null,null,null,null,"Brine to Air Heat Pump Equipment",null,"< 11.3",17.100000000000001,3.6,"$4,000 capped at: Eversource $600,000, Avangrid $400,000"]
[null,null,null,null,null,null,null,null,"Brine to Water Heat Pump Equipment",null,"<  5.4 ",16.100000000000001,3.1]
[null,null,null,null,null,null,null,null,"Brine to Water Heat Pump Equipment",null,"≥5.4 <11.3",16.100000000000001,3]
[null,"Are heat pumps the main source of heating for this project?"]
[]
[null," High Efficiency Water Source Heat Pumps Units Proposed",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GUIDE TO GROUND SOURCE HEAT PUMP EQUIPMENT TYPES"]
[null,null,null,null,null,null,"AHRI Values for Ground Loop (Closed Loop)\n(*Program eligibility is based on this value.)",null,null,null,"AHRI Values for Installed Equipment Type",null,null,null,"AHRI Certified Reference Number","Integrated Model Control Number (if not main source of heating)"]
[null,"Unit ID","Quantity","Equipment Description \nMake/Model Number",null,"Equipment Type","Btu/h Cooling Capacity","Btu/h Heating Capacity","Installed Cooling EER","Installed Heating COP ","Btu/h Cooling Capacity","Btu/h Heating Capacity","Cooling EER","Heating COP"]
[null," WSHP-1",2,"XYZ COMPANY",null,"Water-to-Air: Water Loop",55,16,50,3.5,null,null,null,null,1234567,1234567,null,null,null,null,null,null,null,null,null,"Category or Type"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Water-to-Air: Water Loop"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Water-to-Air: Ground Water (Open Loop)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Brine-to-Air: Ground Loop (Closed Loop)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Water-to-Water: Water Loop"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Water-to-Water: Ground Water (Open Loop)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Brine-to-Water: Ground Loop (Closed Loop)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null," ",null,null,null,null," ",null," "]
[null,"Provide any additional information relevant to this project."]

{"sheet":"8- VRF-VRV","index":13,"n_rows":37,"n_cols":21,"rows_kept":37,"cut":false,"hidden":true,"merged":[[36,1,36,11],[37,1,43,11],[0,1,0,6],[1,1,4,6],[5,1,8,6],[12,1,12,13],[1,8,1,12],[3,10,3,12],[10,1,10,4],[11,1,11,4]]}
["Click to go back to the Project Summary Tab","VRF"]
[null,"Please complete all yellow cells and provide:\n- Site mechanical plans\n- Spec sheets for each unit\n- AHRI certificate for each unit",null,null,null,null,null,null,"VRF Incentives",null,null,null,null,null,null,null,null,null,null,null,"Full"]
[null,null,null,null,null,null,null,null,"Size (BTU/hr)","Nominal Tons","Minimum Qualifying EER","Minimum Qualifying COP","Incentive ($/Heating Ton)",null,null,null,null,null,null,null,"Partial - more than 50%"]
[null,null,null,null,null,null,null,null,"≤65,000","<5.4","AHRI rates VRF units this size and smaller as air source heat pumps. Those ratings and incentive values will apply to this program.",null,null,null,null,null,null,null,null,null,"Partial - less than 50%"]
[null,null,null,null,null,null,null,null,"≥65,000 to ≤135,000","5.4-11.3","11.3 EER, 18.9 IEER","3.4 at 47◦F, 2.25 at 17◦F","$1,000 capped at Eversource $500,000, Avangrid $300,000",null,null,null,null,null,null,null,"Not used for primary heating"]
[null,"*This incentive is available for equipment greater than 65,000 BTUh. If your unit is under 65,000 BTUh use the Air Source Heat Pumps tab. \n\n**See Energy Recovery tab for DOAS systems with energy recovery not required by code.\n\n**Heating and cooling capability required for heat pump systems to receive high-level heat pump savings. Heat pump values may be decreased to 50%for projects engaging after 100% construction documents on the Path 4 Systems pathway.",null,null,null,null,null,null,">135,000 to ≤240,000","11.3-20","10.9 EER, 18 IEER","3.7 at 47◦F, 2.2 at 17◦F","$1,000 capped at Eversource $500,000, Avangrid $300,000"]
[null,null,null,null,null,null,null,null,">240,000",">20","10.3 EER, 16.4 IEER","3.3 at 47◦F, 2.2 at 17◦F","$1,000 capped at Eversource $500,000, Avangrid $300,000"]
[]
[]
[]
[null,"Are heat pumps the main source of heating for this project?"]
[]
[null," High Efficiency VRF Units Proposed"]
[null,"Unit ID","Outdoor Unit Quantity","Manufacturer/ Outdoor Unit Model #","Indoor Unit Type","VRF Classification","Cooling Capacity (Btu/hr)","Heating Capacity (Btu/hr)","Cooling EER","Cooling IEER","Heating COP at 47°F","Heating COP at 17°F","AHRI Certified Reference Number","Integrated Control Model Number (if not main source of heating"]
[null,"EXAMPLE: VRF-1",1,1,"Ducted","Cooling Only",65000,65000,12,17.399999999999999,10.5,10.5,1234567]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null," ",null,null,null,null,null,null," "]
[]
[null,"Provide any additional information relevant to this project."]

{"sheet":"9- VFDs","index":14,"n_rows":61,"n_cols":27,"rows_kept":61,"cut":false,"hidden":true,"merged":[[7,6,8,6],[0,1,0,8],[1,1,1,8],[2,1,3,8],[5,1,5,8],[6,1,6,8],[40,1,40,4],[60,1,60,7],[61,1,67,7],[7,1,7,2],[13,1,14,1],[13,2,14,2],[13,7,14,7],[16,1,16,6],[17,1,17,6],[7,4,7,5],[7,7,7,8],[18,1,18,6],[20,1,20,6],[20,8,20,14],[13,8,14,8],[7,3,8,3]]}
["Click to go back on Project summary tab","VFDs"]
[null,"Note: New Construction/Major Renovation VFDs only (use Existing Building VFD submission for Retrofit applications)"]
[null,"Please complete all yellow cells and provide:\n- Site mechanical plans\n- Spec sheets for all units"]
[]
[]
[null,"Incentives"]
[null,"Eligibility Requirements"]
[null,"Air Handling Fans\n(only for DX Cooling with a mechanical cooling capacity <65,000 Btu/h**)",null,null,"Chilled Water & Hot Water Pumps\n(only for systems with a capacity less than 500 MBH)",null,null,"Cooling Tower Fans"]
[null,"Motor Size (HP)","Incentive*, **",null,"Motor Size (HP)","Incentive*, **",null,"Motor Size (HP)","Incentive*,**"]
[null,"< 1",0,null,"< 1",0,null,"<1",0]
[null,"≥ 1 to < 2","up to $100",null,"≥ 1 to < 2","up to $200",null,"≥ 1 to < 2","up to $100"]
[null,"≥ 2 to < 5","up to $200",null,"≥ 2 to < 5","up to $350",null,"≥ 2 to < 5","up to $200"]
[null,"≥ 5 to < 7.5","up to $920",null,"≥ 5 to < 7.5","up to $1,710",null,"≥ 5 to < 7.5","up to $920"]
[null,null,null,null,"≥ 7.5 to < 10","up to $2,100",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DX Cooling"]
[null,null,null,null,"≥ 10 to < 15","up to $2,150",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chilled water and evaporative cooling"]
[]
[null,"Notes:"]
[null,"*VFD Incentives listed above represent maximum incentives - actual incentives need to be qualified with energy savings."]
[null,"**For new construction or major renovation projects, air handling fans on DX cooling systems ≥ 65,000 BTU/h, hot or chilled water pump systems ≥ 500 MBH, and cooling tower fans ≥ 7.5 HP shall have Variable Frequency Drives per IECC 2015 and therefore, are not eligible for incentives. "]
[]
[null,"Air Handling Fans",null,null,null,null,null,null,"Chilled Water Pumps & Hot Water Pumps"]
[null,"Cooling System Type","Rated Cooling Capacity (BTUH)**","Fan ID","Quantity","Override Hours ","Motor HP",null,"Hot Water Pump or Chilled Water Pump?","Pump ID","Total Quantity","Back Up Quantity","Override Hours ","Motor HP","Rated Cooling/Heating System Capacity (MBH)"]
[null,"DX Cooling",50000,"AHU-1 SF",2,3000,5,null,"Hot Water","EXAMPLE: HWP-1",2,1,3000,7.5,150]
[null,"DX Cooling",40000,"AHU-1 EF",2,3000,2.5,null,"Chilled Water","EXAMPLE: CWP-1",2,1,3000,7.5,150]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Cooling Tower Fans"]
[null,"Tower ID","Quantity","Override Hours ","Motor HP"]
[null,"CT-1",2,3000,5]
[null,"CT-2",2,3000,2.5]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Provide any additional information relevant to this project."]

{"sheet":"10- Chillers","index":15,"n_rows":45,"n_cols":9,"rows_kept":45,"cut":false,"hidden":true,"merged":[[0,1,0,6],[1,0,2,6],[3,0,3,6],[2,8,2,14],[1,8,1,14],[7,0,7,6],[16,0,16,6],[17,2,17,3],[17,4,17,5],[18,0,18,1],[18,2,18,3],[18,4,18,5],[19,2,19,3],[19,4,19,5],[19,0,19,1],[20,0,20,1],[20,2,20,3],[20,4,20,5],[21,0,21,1],[21,2,21,3],[21,4,21,5],[22,0,22,1],[22,2,22,3],[22,4,22,5],[23,0,23,6],[24,2,24,3],[24,5,24,6],[25,0,25,1],[37,0,37,1],[38,0,38,1],[44,0,44,6],[45,0,51,6],[26,0,26,1],[27,0,27,1],[28,0,28,1],[33,0,33,6],[34,0,34,1],[35,0,35,1],[36,0,36,1],[39,0,39,1],[40,0,40,1]]}
["Click to go back on Project summary tab","Chillers"]
["Please complete all yellow cells and provide:\n- Site mechanical plans\n- Specs for all units\n- Submittals as noted below",null,null,null,null,null,null,null,"Incentives"]
[null,null,null,null,null,null,null,null,"Lesser of:\nElectric Incentive: greater of $0.40/kWh OR $1,000.00/summer peak kW\n\nCapped at 95% of Incremental Cost for New Construction/ Major Renovation"]
["PROVIDE SUBMITTALS WITH THE FULL LOAD EER/KW PER TON, IPLV AND PART LOAD RATINGS FOR 25%, 50%, 75%, AND 100% LOAD AT AHRI IPLV CONDITIONS (NOT DESIGN CONDITIONS)"]
[]
[]
[]
["Months included (input 0 if month not included in analysis and 1 if it is)"]
[null,"January","February","March","April","May","June"]
["Months"]
[null,"July","August","September","October","November","December"]
[]
["Occupied Hours","Weekday","Weekend"]
["Midnight to 8am",null,null,"Input occupied hours for time periods shown."]
["8am to 4pm",null,null,"Input occupied hours for time periods shown."]
["4pm to Midnight",null,null,"Input occupied hours for time periods shown."]
["Cooling Load Information"]
[null,null,"Occupied Hours",null,"Unoccupied Hours"]
["Load at 100 deg OA Temp",null," "]
["Economizer OAT set point"]
["Load at economizer set point (OAT+)"]
["Load at economizer below setpoint (OAT-)"]
["Load at 0 deg OA Temp"]
["Chiller Plant Information (ARI 550/590 - 98)"]
[null,null,"Baseline ",null,null,"Proposed- High Efficiency Plant"]
[null,null,"Base Lead Chiller","Base Lag Chiller",null,"EE Lead Chiller","EE Lag Chiller"]
["Manufacturer & Model # (Description)"]
["ARI rated capacity (tons)"]
["Chiller Type (select from dropdown)"]
[null,null,null,null,"Eff @ 100% Load"]
[null,null,null,null,"Eff @ 75% Load"]
[null,null,null,null,"Eff @ 50% Load"]
[null,null,null,null,"Eff @ 25% Load"]
["Auxiliaries Information"]
[null,null,"Chiller 3 (Backup)","Chiller 4 (Backup)"]
["ARI rated capacity (tons)"]
["Chiller Type (select from dropdown)"]
["Full Load"]
["IPLV"]
["Incremental Cost"]
[]
[]
[]
[]
["Provide any additional information relevant to this project."]

{"sheet":"11- Energy Recovery","index":16,"n_rows":38,"n_cols":16,"rows_kept":38,"cut":false,"hidden":true,"merged":[[0,1,0,6],[1,0,5,6],[5,8,6,14],[7,0,7,6],[8,0,8,6],[8,8,8,15],[10,0,10,6],[20,8,20,15],[22,8,22,15],[23,0,23,2],[24,0,24,6],[37,0,37,6],[38,0,44,6],[12,8,12,15],[13,8,13,15],[15,8,15,15],[18,8,18,15],[19,8,19,15],[20,0,20,2],[21,0,21,2]]}
["Click to go back on Project summary tab","Heat Recovery/Energy Recovery Ventilation Units"]
["Please complete all yellow cells and provide:\n- Site mechanical plans\n- Specs for all units\n- Submittals as noted below\n- Base case and efficient proposals to support incremental cost value"]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Notes: Energy Recovery is a Custom Measure available where not required by code. This is based on percent outdoor air, operating hours, and heating/cooling in the space."]
[]
["Incentives"]
["Lesser of:\nElectric Incentive: greater of $0.40/kWh OR $1,000.00/summer peak kW\nNatural Gas Incentive: $6.00/CCF\n\nCapped at 95% of Incremental Cost for New Construction/ Major Renovation",null,null,null,null,null,null,null,"From IECC 2021 - Code Requirement"]
[null,null,null,null,null,null,null,null,"Energy Recovery Required by code if airflow exceeds values in the table below. "]
["Months included (input 0 if month not included in analysis and 1 if it is)",null,null,null,null,null,null,null,"Some Exceptions/Exemptions apply in 2021 IECC Section C403.7.4.2."]
[null,"January","February","March","April","May","June",null,"TABLE C403.7.4.2(1)"]
["Months",null,null,null,null,null,null,null,"ENERGY RECOVERY REQUIREMENT (VENTILATION SYSTEMS OPERATING LESS THAN 8,000 HOURS PER YEAR)"]
[null,"July","August","September","October","November","December",null,"PERCENT (%) OUTDOOR AIR AT FULL DESIGN AIRFLOW RATE"]
[null,null,null,null,null,null,null,null,"≥ 10% and < 20%","≥ 20% and < 30%","≥ 30% and < 40%","≥ 40% and < 50%","≥ 50% and < 60%","≥ 60% and < 70%","≥ 70% and < 80%","≥ 80%"]
["Occupied Hours","Weekday","Weekend",null,null,null,null,null,"DESIGN SUPPLY FAN AIRFLOW RATE (cfm)"]
["Midnight to 8am",null,null,"Input occupied hours for time periods shown.",null,null,null,null,"≥ 26,000"," ≥ 16,000"," ≥ 5,500"," ≥ 4,500"," ≥ 3,500"," ≥ 2,000"," ≥ 1,000","> 120"]
["8am to 4pm",null,null,"Input occupied hours for time periods shown."]
["4pm to Midnight",null,null,"Input occupied hours for time periods shown.",null,null,null,null,"TABLE C403.7.4.2(2)"]
[null,null,null,null,null,null,null,null,"ENERGY RECOVERY REQUIREMENT (VENTILATION SYSTEMS OPERATING NOT LESS THAN 8,000 HOURS PER YEAR)"]
["Design Supply Fan Airflow Rate of Fan System (CFM)\nInclude Submittal with Project Submission",null,null,null,null,null,null,null,"PERCENT (%) OUTDOOR AIR AT FULL DESIGN AIRFLOW RATE"]
["Percent Outdoor Air at Full Design Airflow Rate (%)",null,null,null,null,null,null,null,"≥ 10% and < 20%","≥ 20% and < 30%","≥ 30% and < 40%","≥ 40% and < 50%","≥ 50% and < 60%","≥ 60% and < 70%","≥ 70% and < 80%","≥ 80%"]
[null,null,null,null,null,null,null,null,"DESIGN SUPPLY FAN AIRFLOW RATE (cfm)"]
["Incremental cost to add heat recovery to project including design, installation and commissioning:",null,null,null,null,null,null,null,"≥ 200","≥ 130","≥ 100","≥ 80","≥ 70","≥ 60","≥ 50","≥ 40"]
[]
["Unit ID (AHU #)","Manufacturer and Model #","Return Air DB TEMP. (Default 72 degrees)","Return air enthalpy, h (default 26.45)","Cooling EER","Heating fuel","Heating Efficiency ","Building Balance Point\n (default 55°F)","Total Heating Energy Recovery Effectiveness (%)","Total Cooling Energy Recovery Effectiveness (%)","Heat Recovery By-Pass","Exhaust Airflow (cfm)","Heat recovery required by code?",{"$f":"IF(N$25=\"Yes\",\"N/A\",\"System Type\")","v":"System Type"},"Supply Fan Power (hp)","Return Fan Power (hp)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Provide any additional information relevant to this project."]

{"sheet":"12- DCV (CO2 Control)","index":17,"n_rows":36,"n_cols":21,"rows_kept":36,"cut":false,"hidden":true,"merged":[[18,6,19,6],[20,1,20,3],[21,1,21,10],[35,1,35,7],[36,1,42,7],[0,1,0,7],[1,1,3,7],[18,1,19,3],[18,4,19,4],[2,9,2,15],[3,9,3,15],[5,9,18,13],[18,5,19,5]]}
["Click to go back to the Project Summary Tab","Demand Control Ventilation of Outside Air with CO2 sensors"]
[null,"Please complete all yellow cells and provide:\n- Site mechanical plans\n- Specs for all units\n- Base case and efficient proposals to support incremental cost value"]
[null,null,null,null,null,null,null,null,null,"Incentives"]
[null,null,null,null,null,null,null,null,null,"Lesser of:\n-Electric Incentive: greater of $0.40/kWh OR $1,000.00/summer peak kW & Natural Gas Incentive: $6.00/CCF\n-$750/sensor\n-95% of Incremental Cost for New Construction/Major Renovation                                                                                                                       \n*Oil and Propane Incentives Not available.. "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"wall mounted"]
[null,null,null,null,null,null,null,null,null,"Notes: Demand Control Ventilation is a Custom Measure available where not required by code. In general, energy code requires CO2 control for all single-zone systems required to comply with Sections C403.5 through C403.5.3 of the IECC. Demand Control Ventilation is also required for spaces larger than 500 square feet and with an average occupant load of 15 people per 1,000 square feet (per the International Mechanical Code) and served by systems with: an air-side economizer, automatic modulating control of the outdoor air damper, and/or outdoor airflow is greater than 3,000 CFM. Do not include any CO2 controls below that are required by energy code. Fill out the yellow boxes for energy savings evaluation. ",null,null,null,null,null,null,null,null,null,null,"return duct"]
[]
[]
[null,"Months included (input 0 if month not included in analysis and 1 if it is)"]
[null,null,"January","February","March","April","May","June"]
[null,"Months"]
[null,null,"July","August","September","October","November","December"]
[]
[null,"Occupied Hours","Weekday","Weekend"]
[null,"Midnight to 8am",null,null,"Input occupied hours for time periods shown."]
[null,"8am to 4pm",null,null,"Input occupied hours for time periods shown."]
[null,"4pm to Midnight",null,null,"Input occupied hours for time periods shown."]
[]
[null,"Incremental cost to add CO2 sensors to project including design, installation and commissioning:",null,null,null,"Control Placement"]
[]
[null,"Are the CO2 sensors part of the EMS?",null,null,null,"# CO2 Sensors"]
[null,"CO2 Control of Outside Air (Demand Control Ventilation)"]
[null,"Unit ID","Return Air DB TEMP. \n(Default 72 degrees)","Return air enthalpy, h (default 26.45)","Total Airflow (cfm)","Outside Air (%)","Average Airflow Reduction (%)","Cooling EER","Heating fuel","Heating Efficiency ","Building Balance Point (°F)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Provide any additional information relevant to this project."]

{"sheet":"13 - Heat Pump Water Heaters","index":18,"n_rows":20,"n_cols":8,"rows_kept":20,"cut":false,"hidden":true,"merged":[[7,2,7,3],[8,2,8,3],[19,0,19,6],[20,0,31,6],[0,1,0,8],[1,1,1,8],[3,0,3,3],[4,0,4,3],[5,2,5,3],[6,2,6,3]]}
["Click to go back on Project summary tab","Heat Pump Domestic Hot Water Heaters"]
[null,"Please complete all yellow cells and provide:\n- Site mechanical plans\n- Specs for all units\n- AHRI certificates for each unit"]
[]
["Heat Pump Hot Water Heater Incentives "]
["Eligibility Requirements"]
["Rated Storage Volume","Minimum Efficiency","Incentive per Unit"]
["≥20 gallons to ≤55 gallons","ENERGY STAR certified - UEF ≥3.4 or ≥2.2 for 120 Volt/15 Amp circuit system",1000]
[">55 gallons to ≤120 gallons","ENERGY STAR certified - UEF ≥3.4 or ≥2.2 for 120 Volt/15 Amp circuit system",1000]
[">120 gallons","ENERGY STAR certified >3.6 CoP",1400]
[]
["Unit ID","Manufacturer and Model Number","Quantity","Input kW","Storage Capacity (Gallons)","Rated COPh","System Volts/Amps","Square Footage Served by this Water Heater"]
["EXAMPLE: WH-1","MODEL 1234",1,5,80,3.5,"120V/15A",30000]
[]
[]
[]
[]
[]
[]
[]
["Provide any additional information relevant to this project."]

{"sheet":"14 - Kitchen Hood VFDs","index":19,"n_rows":36,"n_cols":12,"rows_kept":36,"cut":false,"hidden":true,"merged":[[16,1,16,11],[35,1,35,10],[36,1,42,10],[0,0,1,0],[0,1,0,7],[1,1,2,7],[5,9,5,11],[6,9,14,11]]}
["Click to go back on Project summary tab","Kitchen Hood VFDs"]
[null,"Please fill out all yellow cells and provide:\n- Site mechanical plans\n- Specs for all units\n- Documentation to support additional costs"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Incentives"]
[null,"Months included (input 0 if month not included in analysis and 1 if it is) ",null,null,null,null,null,null,null,"Lesser of:\nElectric Incentive: greater of $0.40/kWh OR $1,000.00/summer peak kW\nNatural Gas Incentive: $6.00/CCF\nCapped at 95% of Incremental Cost for New Construction/Major Renovation\n\n*Oil and Propane Incentives Not available"]
[null,null,"January","February","March","April","May","June"]
[null,"Months"]
[null,null,"July","August","September","October","November","December"]
[]
[null,"Occupied Hours","Weekday","Weekend"]
[null,"Midnight to 8am",null,null,"Input occupied hours for time periods shown."]
[null,"8am to 4pm",null,null,"Input occupied hours for time periods shown."]
[null,"4pm to Midnight",null,null,"Input occupied hours for time periods shown."]
[]
[null,"Kitchen Hoods Proposed"]
[null,"Unit Description","Fan HP","Load Factor","Motor Efficiency","Airflow (CFM)*","Cooling EER","Heating Efficiency","Heating Setpoint (⁰F)","Cooling Setpoint (⁰F)","Outside Air Adjustments ","Additional Cost to Add Controls"]
[null,"Hood #1 (EXAMPLE)",1,0.8,0.85,2200,12,0.8,70,75,"Default- Outside Air will not be adjusted",2000]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Incremental Cost"]
[null,"Type of Heating"]
[]
[null,"*NOTE: For New Construction, kitchen hood variable flow controls "]
[null,"is BASELINE if kitchen has ≥ 5,000 CFM total combined hood exhaust flow."]
[]
[null,"Provide any additional information relevant to this project."]

{"sheet":"15 - Insulation","index":20,"n_rows":40,"n_cols":9,"rows_kept":40,"cut":false,"hidden":true,"merged":[[33,1,33,5],[34,1,40,5],[3,5,4,5],[0,1,0,4],[1,1,3,4],[21,1,21,2],[21,4,21,5],[27,1,27,2],[27,4,27,5]]}
["Click to go back on Project summary tab","Insulation"]
[null,"Please fill out all yellow cells and provide:\n- Architectural drawings with insulation levels shown and/or a proposal from your vendor showing insulation values, spaces, and square footages, that can be used to validate the data input below.\n- Documentation supporting incremental cost values, such as a baseline proposal and the true vendor proposal"]
[null,null,null,null,null,"Incentives"]
[null,null,null,null,null,"Lesser of:\nElectric Incentive: greater of $0.40/kWh OR $1,000.00/summer peak kW\nNatural Gas Incentive: $6.00/CCF\n95% of Incremental Cost                                                                                               \n\n*Oil and Propane Incentives Not Available."]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Heating Temp Setpoint"]
[null,null,"Cooling Temp Setpoint"]
[null,null,"Setback Degrees"]
[null,null,"Heating Fuel Type"]
[null,null,"Percent of Building Being Cooled"]
[null,null,"Cooling System EER"]
[null,null,"Heating System Efficiency (Default= 80%)"]
[null,null,"Perimeter Zone Balance Point"]
[null,null,"Incremental Cost of Insulation **REQUIRED"]
[]
[null,"Area A",null,null,"Area B"]
[null,null,"Area A Description/Assembly Type",null,null,"Area B Description/Assembly Type"]
[null,null,"Total SF Area A",null,null,"Total SF Area B"]
[null,null,"Baseline U Value",null,null,"Baseline U Value"]
[null,null,"Proposed U Value",null,null,"Proposed U Value"]
[]
[null,"Area C",null,null,"Area D"]
[null,null,"Area C Description/Assembly Type",null,null,"Area D Description/ Assembly Type"]
[null,null,"Total SF Area C",null,null,"Total SF Area D"]
[null,null,"Baseline U Value",null,null,"Baseline U Value"]
[null,null,"Proposed U Value",null,null,"Proposed U Value"]
[]
[null,"Provide any additional information relevant to this project.",null,null,null,null,null,null,"Mass Wall"]
[null,null,null,null,null,null,null,null,"Metal Building Wall"]
[null,null,null,null,null,null,null,null,"Metal Framed"]
[null,null,null,null,null,null,null,null,"Wood Framed and Other"]
[null,null,null,null,null,null,null,null,"Attic and Other"]
[null,null,null,null,null,null,null,null,"Roof Insulation Above Deck"]
[null,null,null,null,null,null,null,null,"Metal Building Wall"]

{"sheet":"16 - Windows","index":21,"n_rows":72,"n_cols":10,"rows_kept":72,"cut":false,"hidden":true,"merged":[[38,9,38,10],[39,9,39,10],[29,9,29,10],[30,9,30,10],[31,9,31,10],[32,9,32,10],[33,9,33,10],[36,9,36,10],[37,9,37,10],[35,8,35,10],[20,4,20,5],[21,4,21,5],[22,4,22,5],[48,4,48,5],[49,4,49,5],[36,4,36,5],[37,4,37,5],[38,4,38,5],[39,4,39,5],[40,4,40,5],[41,4,41,5],[43,3,43,5],[44,4,44,5],[45,4,45,5],[46,4,46,5],[47,4,47,5],[31,4,31,5],[32,4,32,5],[33,4,33,5],[43,1,43,2],[0,1,0,10],[1,1,2,10],[6,7,6,9],[7,7,13,9],[19,1,19,2],[19,6,19,7],[19,8,19,10],[27,1,27,2],[27,3,27,5],[27,6,27,7],[27,8,27,10],[19,3,19,5],[35,1,35,2],[20,9,20,10],[21,9,21,10],[22,9,22,10],[23,9,23,10],[24,9,24,10],[25,9,25,10],[28,9,28,10],[23,4,23,5],[24,4,24,5],[25,4,25,5],[35,3,35,5],[35,6,35,7],[28,4,28,5],[29,4,29,5],[30,4,30,5],[62,1,62,4],[68,1,68,2],[40,9,40,10],[41,9,41,10],[43,6,43,7],[43,8,43,10],[44,9,44,10],[45,9,45,10],[46,9,46,10],[47,9,47,10],[48,9,48,10],[49,9,49,10],[52,1,52,10],[53,1,59,10]]}
["Click to go back on Project summary tab","Windows"]
[null,"Please fill out all yellow cells and provide:\n- Architectural drawings highlighting where the windows are shown and/or a proposal from your vendor showing the efficiency ratings, orientation, and window sizes\n- Documentation supporting incremental cost values, such as a proposal for baseline efficiency windows and the proposal for the actual windows to be installed"]
[]
[]
[]
[null,"Project Type: ",null,null,null,"Qty Windows Side A"]
[null,null,"Heating Temperature Setpoint",null,null,"Qty Windows Side B",null,"Incentives"]
[null,null,"Cooling Temperature Setpoint",null,null,"Qty Windows Side C",null,"Lesser of:\nElectric Incentive: greater of $0.40/kWh OR $1,000.00/summer peak kW\nNatural Gas Incentive: $6.00/CCF\n95% of Incremental Cost for New Construction/ Major Renovation\n\n*Oil and Propane Incentives Not available"]
[null,null,"Setback Degrees",null,null,"Qty Windows Side D"]
[null,null,"Heating Fuel Type\n(Electric, Natural Gas, Oil,Propane)"]
[null,null,"Heating System Efficiency %"]
[null,null,"Perimeter Zone Balance Point"]
[null,null,"Percent of building cooled"]
[null,null,"Cooling EER"]
[null,null,"Incremental Cost of Windows **REQUIRED"]
[]
[]
[]
[]
[null,"Side A",null,"Side B",null,null,"Side C",null,"Side D"]
[null,null,"Window Orientation",null,"Window Orientation",null,null,"Window Orientation",null,"Window Orientation"]
[null,null,"Total Window area",null,"Total Window area",null,null,"Total Window area",null,"Total Window area"]
[null,null,"Window U value",null,"Window U value",null,null,"Window U value",null,"Window U value"]
[null,null,"Window SHGC",null,"Window SHGC",null,null,"Window SHGC",null,"Window SHGC"]
[null,null,"Projection Factor",null,"Projection Factor",null,null,"Projection Factor",null,"Projection Factor"]
[null,null,"Fixed, Operable, Entrance Door",null,"Fixed, Operable, or Entrance Door",null,null,"Fixed, Operable, or Entrance Door",null,"Fixed, Operable, or Entrance Door"]
[]
[null,"Side A",null,"Side B",null,null,"Side C",null,"Side D"]
[null,null,"Window Orientation",null,"Window Orientation",null,null,"Window Orientation",null,"Window Orientation"]
[null,null,"Total Window area",null,"Total Window area",null,null,"Total Window area",null,"Total Window area"]
[null,null,"Window U value",null,"Window U value",null,null,"Window U value",null,"Window U value"]
[null,null,"Window SHGC",null,"Window SHGC",null,null,"Window SHGC",null,"Window SHGC"]
[null,null,"Projection Factor",null,"Projection Factor",null,null,"Projection Factor",null,"Projection Factor"]
[null,null,"Fixed or Operable",null,"Fixed, Operable, or Entrance Door",null,null,"Fixed, Operable, or Entrance Door",null,"Fixed, Operable, or Entrance Door"]
[]
[null,"Side A",null,"Side B",null,null,"Side C",null,"Side D"]
[null,null,"Window Orientation",null,"Window Orientation",null,null,"Window Orientation",null,"Window Orientation"]
[null,null,"Total Window area",null,"Total Window area",null,null,"Total Window area",null,"Total Window area"]
[null,null,"Window U value",null,"Window U value",null,null,"Window U value",null,"Window U value"]
[null,null,"Window SHGC",null,"Window SHGC",null,null,"Window SHGC",null,"Window SHGC"]
[null,null,"Projection Factor",null,"Projection Factor",null,null,"Projection Factor",null,"Projection Factor"]
[null,null,"Fixed, Operable,or Entrance Door",null,"Fixed, Operable, or Entrance Door",null,null,"Fixed, Operable, or Entrance Door",null,"Fixed, Operable, or Entrance Door"]
[]
[null,"Side A",null,"Side B",null,null,"Side C",null,"Side D"]
[null,null,"Window Orientation",null,"Window Orientation",null,null,"Window Orientation",null,"Window Orientation"]
[null,null,"Total Window area",null,"Total Window area",null,null,"Total Window area",null,"Total Window area"]
[null,null,"Window U value",null,"Window U value",null,null,"Window U value",null,"Window U value"]
[null,null,"Window SHGC",null,"Window SHGC",null,null,"Window SHGC",null,"Window SHGC"]
[null,null,"Projection Factor",null,"Projection Factor",null,null,"Projection Factor",null,"Projection Factor"]
[null,null,"Fixed, Operable,or Entrance Door",null,"Fixed, Operable, or Entrance Door",null,null,"Fixed, Operable, or Entrance Door",null,"Fixed, Operable, or Entrance Door"]
[]
[]
[null,"Provide any additional information relevant to this project."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"SHGC: Table C402.4 IECC 2021"]
[null,"Orientation",{"$f":"B70","v":"Fixed"},{"$f":"B71","v":"Operable"},{"$f":"B72","v":"Entrance Doors"}]
[null,"PF < 0.2",0.38,0.33]
[null,"0.2 <= PF < 0.5",0.46,0.4]
[null,"PF >= 0.5",0.61,0.53]
[]
[null,"U-values: Table C402.4 IECC 2021"]
[null,"Fixed",0.36]
[null,"Operable",0.45]
[null,"Entrance Doors",0.63]

{"sheet":"17 - Custom Measure","index":22,"n_rows":55,"n_cols":4,"rows_kept":55,"cut":false,"hidden":true,"merged":[[0,1,0,3],[1,1,3,3],[5,1,5,3],[6,1,6,3],[8,1,8,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[20,1,20,2],[29,1,29,2],[54,1,54,3],[55,1,65,3],[21,1,21,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[28,1,28,2],[31,1,31,3],[36,1,36,3],[42,1,42,3],[47,1,47,3],[50,1,50,3]]}
["Click to go back on Project summary tab","Custom Measure"]
[null,"Please fill out the relevant yellow cells and provide: \n- Energy savings and annual energy usage calculations in a format like Excel so underlying formulas can be displayed and followed. \n- Documentation to support incremental cost values such as a proposal for baseline equipment and the proposal for equipment considered for installation\n- Mechanical, electrical, and/or architectural drawings"]
[]
[]
[]
[null,"Incentives"]
[null,"Lesser of:\nElectric Incentive: greater of $0.40/kWh OR $1,000.00/summer peak kW\nNatural Gas Incentive: $6.00/CCF - no incentives for gas combustion equipment beginning in 2025. Potential exemptions for process equipment, contact your utility's Energy Efficiency Consultant for more info.\n\nCapped at 95% of Incremental Cost for New Construction/ Major Renovation"]
[]
[null,"Equipment being evaluated"]
[null,"Brief description of project and how energy savings will be achieved"]
[null,"Heating Source"]
[null,"Cost of Proposed System"]
[null,"Cost of Baseline System"]
[null,"Incremental Cost"]
[]
[null,"Proposed EE System (fill out below as relevant)"]
[null,"Describe of Proposed System"]
[null,"Number of Units to be Installed"]
[null,"Cost per Unit"]
[null,"Operating Hours"]
[null,"Estimated Annual Energy Use (ccf or kWh)"]
[null,"Estimated Demand (Summer kW, Winter kW, annual & peak saving in CCF)"]
[]
[null,"Baseline System (fill out below as relevant)"]
[null,"Describe of Baseline System"]
[null,"Cost per Unit"]
[null,"Number of Units to be Installed"]
[null,"Operating Hours"]
[null,"Estimated Annual Energy Use (ccf or kWh)"]
[null,"Estimated Demand (Summer kW, Winter kW, annual & peak saving in CCF)"]
[]
[null,"EQUIPMENT:  Provide a list of equipment or materials installed as part of this project.  Include equipment counts, HP, kW, efficiency and capacity ratings, rating conditions, location of controls hardware, etc. The Yes/No checkboxes are intended for use as the utility’s post-installation inspection record (check one).  "]
[null,"Compliance","Project Design Intent","Post Inspection Findings"]
[null,null,1]
[null,null,2]
[null,null,3]
[null,"SEQUENCES OF OPERATION:  Provide a description of equipment operating sequences, setpoints, operating schedules, balancing requirements (flow, velocity, head, etc.) or any other required operating parameters.  Describe requirements separately."]
[null,null,4]
[null,null,5]
[null,null,6]
[null,null,7]
[null,null,8]
[null,"DOCUMENTATION:  List written documentation required to train, verify, operate, or maintain the equipment being installed or controlled.  This may include specification sheets, test reports, construction drawings, etc."]
[null,null,9]
[null,null,10]
[null,null,11]
[null,null,12]
[null,"POST INSTALLATION VERIFICATION:  Provide a list of controls and monitoring capabilities required to verify proper system operation.  Trends should document operational sequences, set points and scheduling of equipment as described in TA Study."]
[null,null,13]
[null,null,14]
[null,"OTHER REQUIREMENTS:  Describe any requirements for demolition, removal, etc. of existing equipment."]
[null,null,15]
[null,null,16]
[]
[null,"Provide any additional information relevant to this project."]

{"sheet":"18 - Air Compressor & Dryer","index":23,"n_rows":84,"n_cols":29,"rows_kept":84,"cut":false,"hidden":true,"merged":[[58,1,58,5],[59,1,65,5],[0,1,0,5],[1,1,2,5],[6,1,6,5],[7,4,7,5],[8,4,8,5],[9,4,9,5],[10,4,10,5],[11,4,11,5],[13,1,13,2],[13,4,13,5],[14,1,14,2],[45,1,45,2],[45,4,45,5],[46,1,46,2]]}
["Click to go back to Project summary tab","Air Compressor & Dryer"]
[null,"All yellow fields must be filled in for output to be correct. Green load profile and CAGI cells do not all need to be filled if not relevant.\n\nPlease provide:\n- Site mechanical plans\n- Specification sheets for all units\n- CAGI data sheets"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Active Fixture?"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"ACTIVE\"","v":"ACTIVE"}]
[null,"Load Profile:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(I7*VLOOKUP(P7,[3]!PV,4,FALSE)+S7*VLOOKUP(P7,[3]!PV,2,FALSE)),0,I7*VLOOKUP(P7,[3]!PV,4,FALSE)+S7*VLOOKUP(P7,[3]!PV,2,FALSE))","v":0},{"$f":"IF(AND(#REF!=\"New Fixtures\",#REF!>0,OR(#REF!=\"Standard Interior\",#REF!=\"High-Performance Interior\")),#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(OR(#REF!=\"Standard Interior\",#REF!=\"High-Performance Interior\"),(NOT(OR(#REF!=\"Misc. Costs - Standard\",#REF!=\"Misc. Costs - High Performance\")))),#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(OR(#REF!=\"Standard Interior\",#REF!=\"High-Performance Interior\"),#REF!*#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(OR(#REF!=\"Misc. Costs - High Performance\",#REF!=\"High-Performance Interior\",#REF!=\"High-Performance Exterior\"),\"Y\",\"N\")","v":{"$error":"#REF!"}},{"$f":"IF(X7=\"Y\",#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(X7=\"Y\",N7,0)","v":{"$error":"#REF!"}},{"$f":"IF(X7=\"Y\",O7,0)","v":{"$error":"#REF!"}},{"$f":"IF(OR(#REF!=\"Misc. Costs - Interior\",#REF!=\"Misc. Costs - Exterior\"),0,1)","v":{"$error":"#REF!"}},{"$f":"IF(OR(#REF!<>\"\",#REF!<>\"\",#REF!<>\"\",#REF!<>\"\",#REF!<>\"\",#REF!<>\"\",#REF!<>\"\"),\"ACTIVE\",\"\")","v":{"$error":"#REF!"}}]
[null,"(2 loads min.)","Flow (cfm)","Run Time (hrs)","Description",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(I8*VLOOKUP(P8,[3]!PV,4,FALSE)+S8*VLOOKUP(P8,[3]!PV,2,FALSE)),0,I8*VLOOKUP(P8,[3]!PV,4,FALSE)+S8*VLOOKUP(P8,[3]!PV,2,FALSE))","v":0},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Load 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(I9*VLOOKUP(P9,[3]!PV,4,FALSE)+S9*VLOOKUP(P9,[3]!PV,2,FALSE)),0,I9*VLOOKUP(P9,[3]!PV,4,FALSE)+S9*VLOOKUP(P9,[3]!PV,2,FALSE))","v":0},{"$f":"IF(AND(B4=\"New Fixtures\",F4>0,OR(D4=\"Standard Interior\",D4=\"High-Performance Interior\")),F4,0)","v":0},{"$f":"IF(AND(OR(D4=\"Standard Interior\",D4=\"High-Performance Interior\"),(NOT(OR(B4=\"Misc. Costs - Standard\",B4=\"Misc. Costs - High Performance\")))),F4,0)","v":0},{"$f":"IF(OR(D4=\"Standard Interior\",D4=\"High-Performance Interior\"),F4*#REF!,0)","v":0},{"$f":"IF(OR(B4=\"Misc. Costs - High Performance\",D4=\"High-Performance Interior\",D4=\"High-Performance Exterior\"),\"Y\",\"N\")","v":"N"},0,0,0,{"$f":"IF(OR(B4=\"Misc. Costs - Interior\",B4=\"Misc. Costs - Exterior\"),0,1)","v":1},{"$f":"IF(OR(#REF!<>\"\",#REF!<>\"\",#REF!<>\"\",#REF!<>\"\",F4<>\"\",#REF!<>\"\",#REF!<>\"\"),\"ACTIVE\",\"\")","v":{"$error":"#REF!"}}]
[null,"Load 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(I10*VLOOKUP(P10,[3]!PV,4,FALSE)+S10*VLOOKUP(P10,[3]!PV,2,FALSE)),0,I10*VLOOKUP(P10,[3]!PV,4,FALSE)+S10*VLOOKUP(P10,[3]!PV,2,FALSE))","v":0},{"$f":"IF(AND(B5=\"New Fixtures\",G5>0,OR(D5=\"Standard Interior\",D5=\"High-Performance Interior\")),G5,0)","v":0},{"$f":"IF(AND(OR(D5=\"Standard Interior\",D5=\"High-Performance Interior\"),(NOT(OR(B5=\"Misc. Costs - Standard\",B5=\"Misc. Costs - High Performance\")))),G5,0)","v":0},{"$f":"IF(OR(D5=\"Standard Interior\",D5=\"High-Performance Interior\"),G5*#REF!,0)","v":0},"N",0,0,0,1,{"$f":"IF(OR(#REF!<>\"\",#REF!<>\"\",#REF!<>\"\",#REF!<>\"\",G5<>\"\",#REF!<>\"\",#REF!<>\"\"),\"ACTIVE\",\"\")","v":{"$error":"#REF!"}}]
[null,"Load 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(I11*VLOOKUP(P11,[3]!PV,4,FALSE)+S11*VLOOKUP(P11,[3]!PV,2,FALSE)),0,I11*VLOOKUP(P11,[3]!PV,4,FALSE)+S11*VLOOKUP(P11,[3]!PV,2,FALSE))","v":0},{"$f":"IF(AND(#REF!=\"New Fixtures\",#REF!>0,OR(#REF!=\"Standard Interior\",#REF!=\"High-Performance Interior\")),#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(OR(#REF!=\"Standard Interior\",#REF!=\"High-Performance Interior\"),(NOT(OR(#REF!=\"Misc. Costs - Standard\",#REF!=\"Misc. Costs - High Performance\")))),#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(OR(#REF!=\"Standard Interior\",#REF!=\"High-Performance Interior\"),#REF!*#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(OR(#REF!=\"Misc. Costs - High Performance\",#REF!=\"High-Performance Interior\",#REF!=\"High-Performance Exterior\"),\"Y\",\"N\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(OR(#REF!=\"Misc. Costs - Interior\",#REF!=\"Misc. Costs - Exterior\"),0,1)","v":{"$error":"#REF!"}},{"$f":"IF(OR(#REF!<>\"\",#REF!<>\"\",#REF!<>\"\",#REF!<>\"\",#REF!<>\"\",#REF!<>\"\",#REF!<>\"\"),\"ACTIVE\",\"\")","v":{"$error":"#REF!"}}]
[null,"Load 4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(I12*VLOOKUP(P12,[3]!PV,4,FALSE)+S12*VLOOKUP(P12,[3]!PV,2,FALSE)),0,I12*VLOOKUP(P12,[3]!PV,4,FALSE)+S12*VLOOKUP(P12,[3]!PV,2,FALSE))","v":0},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(I13*VLOOKUP(P13,[3]!PV,4,FALSE)+S13*VLOOKUP(P13,[3]!PV,2,FALSE)),0,I13*VLOOKUP(P13,[3]!PV,4,FALSE)+S13*VLOOKUP(P13,[3]!PV,2,FALSE))","v":0},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Compressor           (CAGI Data sheets must be provided)",null,null,"Energy Efficient Model (VFD control, other)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(I14*VLOOKUP(P14,[3]!PV,4,FALSE)+S14*VLOOKUP(P14,[3]!PV,2,FALSE)),0,I14*VLOOKUP(P14,[3]!PV,4,FALSE)+S14*VLOOKUP(P14,[3]!PV,2,FALSE))","v":0},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Base Model",null,null,"Manufacturer:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(I15*VLOOKUP(P15,[3]!PV,4,FALSE)+S15*VLOOKUP(P15,[3]!PV,2,FALSE)),0,I15*VLOOKUP(P15,[3]!PV,4,FALSE)+S15*VLOOKUP(P15,[3]!PV,2,FALSE))","v":0},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Manufacturer:",null,null,"Model Number",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(I16*VLOOKUP(P16,[3]!PV,4,FALSE)+S16*VLOOKUP(P16,[3]!PV,2,FALSE)),0,I16*VLOOKUP(P16,[3]!PV,4,FALSE)+S16*VLOOKUP(P16,[3]!PV,2,FALSE))","v":0},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Model Number",null,null,"Cost Each",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(I17*VLOOKUP(P17,[3]!PV,4,FALSE)+S17*VLOOKUP(P17,[3]!PV,2,FALSE)),0,I17*VLOOKUP(P17,[3]!PV,4,FALSE)+S17*VLOOKUP(P17,[3]!PV,2,FALSE))","v":0},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Cost Each",null,null,"Air or Water Cooled",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(I18*VLOOKUP(P18,[3]!PV,4,FALSE)+S18*VLOOKUP(P18,[3]!PV,2,FALSE)),0,I18*VLOOKUP(P18,[3]!PV,4,FALSE)+S18*VLOOKUP(P18,[3]!PV,2,FALSE))","v":0},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Air or Water Cooled",null,null,"Oil Injected or Oil Free",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(I19*VLOOKUP(P19,[3]!PV,4,FALSE)+S19*VLOOKUP(P19,[3]!PV,2,FALSE)),0,I19*VLOOKUP(P19,[3]!PV,4,FALSE)+S19*VLOOKUP(P19,[3]!PV,2,FALSE))","v":0},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Oil Injected or Oil Free",null,null,"Compressor Type",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(I20*VLOOKUP(P20,[3]!PV,4,FALSE)+S20*VLOOKUP(P20,[3]!PV,2,FALSE)),0,I20*VLOOKUP(P20,[3]!PV,4,FALSE)+S20*VLOOKUP(P20,[3]!PV,2,FALSE))","v":0},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Compressor Type",null,null,"# of Stages",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(I21*VLOOKUP(P21,[3]!PV,4,FALSE)+S21*VLOOKUP(P21,[3]!PV,2,FALSE)),0,I21*VLOOKUP(P21,[3]!PV,4,FALSE)+S21*VLOOKUP(P21,[3]!PV,2,FALSE))","v":0},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"# of Stages",null,null,"Number of Compressors:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(I22*VLOOKUP(P22,[3]!PV,4,FALSE)+S22*VLOOKUP(P22,[3]!PV,2,FALSE)),0,I22*VLOOKUP(P22,[3]!PV,4,FALSE)+S22*VLOOKUP(P22,[3]!PV,2,FALSE))","v":0},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Number of Compressors:",null,null,"Rated Operating Pressure psig",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(I23*VLOOKUP(P23,[3]!PV,4,FALSE)+S23*VLOOKUP(P23,[3]!PV,2,FALSE)),0,I23*VLOOKUP(P23,[3]!PV,4,FALSE)+S23*VLOOKUP(P23,[3]!PV,2,FALSE))","v":0},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Rated Capacity @ Full Load Operating Pressure acfm",null,null,"Drive Motor Nominal Rating hp",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(I24*VLOOKUP(P24,[3]!PV,4,FALSE)+S24*VLOOKUP(P24,[3]!PV,2,FALSE)),0,I24*VLOOKUP(P24,[3]!PV,4,FALSE)+S24*VLOOKUP(P24,[3]!PV,2,FALSE))","v":0},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Full Load Operating Pressure psig",null,null,"Drive Motor Nominal Efficiency %",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(I25*VLOOKUP(P25,[3]!PV,4,FALSE)+S25*VLOOKUP(P25,[3]!PV,2,FALSE)),0,I25*VLOOKUP(P25,[3]!PV,4,FALSE)+S25*VLOOKUP(P25,[3]!PV,2,FALSE))","v":0},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Drive Motor Nominal Rating hp",null,null,"Fan Motor Nominal Rating hp",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(I26*VLOOKUP(P26,[3]!PV,4,FALSE)+S26*VLOOKUP(P26,[3]!PV,2,FALSE)),0,I26*VLOOKUP(P26,[3]!PV,4,FALSE)+S26*VLOOKUP(P26,[3]!PV,2,FALSE))","v":0},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Drive Motor Nominal Efficiency %",null,null,"Fan Motor Efficiency %",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(I27*VLOOKUP(P27,[3]!PV,4,FALSE)+S27*VLOOKUP(P27,[3]!PV,2,FALSE)),0,I27*VLOOKUP(P27,[3]!PV,4,FALSE)+S27*VLOOKUP(P27,[3]!PV,2,FALSE))","v":0},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Fan Motor Nominal Rating hp",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(I28*VLOOKUP(P28,[3]!PV,4,FALSE)+S28*VLOOKUP(P28,[3]!PV,2,FALSE)),0,I28*VLOOKUP(P28,[3]!PV,4,FALSE)+S28*VLOOKUP(P28,[3]!PV,2,FALSE))","v":0},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Fan Motor Nominal Efficiency %",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(I29*VLOOKUP(P29,[3]!PV,4,FALSE)+S29*VLOOKUP(P29,[3]!PV,2,FALSE)),0,I29*VLOOKUP(P29,[3]!PV,4,FALSE)+S29*VLOOKUP(P29,[3]!PV,2,FALSE))","v":0},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(OR(#REF!<>\"\",B7<>\"\",C7<>\"\",F7<>\"\",#REF!<>\"\",#REF!<>\"\",#REF!<>\"\"),\"ACTIVE\",\"\")","v":{"$error":"#REF!"}}]
[null,"Total Package Input Power @ Rated\nCapacity & Full Load Pressure kW",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(I30*VLOOKUP(P30,[3]!PV,4,FALSE)+S30*VLOOKUP(P30,[3]!PV,2,FALSE)),0,I30*VLOOKUP(P30,[3]!PV,4,FALSE)+S30*VLOOKUP(P30,[3]!PV,2,FALSE))","v":0},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(OR(B8<>\"\",C8<>\"\",D8<>\"\",F8<>\"\",#REF!<>\"\",#REF!<>\"\",#REF!<>\"\"),\"ACTIVE\",\"\")","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(I31*VLOOKUP(P31,[3]!PV,4,FALSE)+S31*VLOOKUP(P31,[3]!PV,2,FALSE)),0,I31*VLOOKUP(P31,[3]!PV,4,FALSE)+S31*VLOOKUP(P31,[3]!PV,2,FALSE))","v":0},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Input Power profile (kW):","KW","CFM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(I32*VLOOKUP(P32,[3]!PV,4,FALSE)+S32*VLOOKUP(P32,[3]!PV,2,FALSE)),0,I32*VLOOKUP(P32,[3]!PV,4,FALSE)+S32*VLOOKUP(P32,[3]!PV,2,FALSE))","v":0},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Max.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(I33*VLOOKUP(P33,[3]!PV,4,FALSE)+S33*VLOOKUP(P33,[3]!PV,2,FALSE)),0,I33*VLOOKUP(P33,[3]!PV,4,FALSE)+S33*VLOOKUP(P33,[3]!PV,2,FALSE))","v":0},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(I34*VLOOKUP(P34,[3]!PV,4,FALSE)+S34*VLOOKUP(P34,[3]!PV,2,FALSE)),0,I34*VLOOKUP(P34,[3]!PV,4,FALSE)+S34*VLOOKUP(P34,[3]!PV,2,FALSE))","v":0},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(I35*VLOOKUP(P35,[3]!PV,4,FALSE)+S35*VLOOKUP(P35,[3]!PV,2,FALSE)),0,I35*VLOOKUP(P35,[3]!PV,4,FALSE)+S35*VLOOKUP(P35,[3]!PV,2,FALSE))","v":0},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(I36*VLOOKUP(P36,[3]!PV,4,FALSE)+S36*VLOOKUP(P36,[3]!PV,2,FALSE)),0,I36*VLOOKUP(P36,[3]!PV,4,FALSE)+S36*VLOOKUP(P36,[3]!PV,2,FALSE))","v":0},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(OR(#REF!<>\"\",#REF!<>\"\",#REF!<>\"\",#REF!<>\"\",#REF!<>\"\",#REF!<>\"\",#REF!<>\"\"),\"ACTIVE\",\"\")","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(I37*VLOOKUP(P37,[3]!PV,4,FALSE)+S37*VLOOKUP(P37,[3]!PV,2,FALSE)),0,I37*VLOOKUP(P37,[3]!PV,4,FALSE)+S37*VLOOKUP(P37,[3]!PV,2,FALSE))","v":0},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(I38*VLOOKUP(P38,[3]!PV,4,FALSE)+S38*VLOOKUP(P38,[3]!PV,2,FALSE)),0,I38*VLOOKUP(P38,[3]!PV,4,FALSE)+S38*VLOOKUP(P38,[3]!PV,2,FALSE))","v":0},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(I39*VLOOKUP(P39,[3]!PV,4,FALSE)+S39*VLOOKUP(P39,[3]!PV,2,FALSE)),0,I39*VLOOKUP(P39,[3]!PV,4,FALSE)+S39*VLOOKUP(P39,[3]!PV,2,FALSE))","v":0},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(I40*VLOOKUP(P40,[3]!PV,4,FALSE)+S40*VLOOKUP(P40,[3]!PV,2,FALSE)),0,I40*VLOOKUP(P40,[3]!PV,4,FALSE)+S40*VLOOKUP(P40,[3]!PV,2,FALSE))","v":0},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(OR(B18<>\"\",C18<>\"\",D18<>\"\",#REF!<>\"\",#REF!<>\"\",#REF!<>\"\",#REF!<>\"\"),\"ACTIVE\",\"\")","v":{"$error":"#REF!"}}]
[null,"Min.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(I41*VLOOKUP(P41,[3]!PV,4,FALSE)+S41*VLOOKUP(P41,[3]!PV,2,FALSE)),0,I41*VLOOKUP(P41,[3]!PV,4,FALSE)+S41*VLOOKUP(P41,[3]!PV,2,FALSE))","v":0},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Total Package Input Power \n@ Zero Flow KW",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(I42*VLOOKUP(P42,[3]!PV,4,FALSE)+S42*VLOOKUP(P42,[3]!PV,2,FALSE)),0,I42*VLOOKUP(P42,[3]!PV,4,FALSE)+S42*VLOOKUP(P42,[3]!PV,2,FALSE))","v":0},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(OR(#REF!<>\"\",#REF!<>\"\",#REF!<>\"\",#REF!<>\"\",#REF!<>\"\",#REF!<>\"\",#REF!<>\"\"),\"ACTIVE\",\"\")","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(I43*VLOOKUP(P43,[3]!PV,4,FALSE)+S43*VLOOKUP(P43,[3]!PV,2,FALSE)),0,I43*VLOOKUP(P43,[3]!PV,4,FALSE)+S43*VLOOKUP(P43,[3]!PV,2,FALSE))","v":0},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(OR(B20<>\"\",C20<>\"\",D20<>\"\",#REF!<>\"\",#REF!<>\"\",#REF!<>\"\",#REF!<>\"\"),\"ACTIVE\",\"\")","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(I44*VLOOKUP(P44,[3]!PV,4,FALSE)+S44*VLOOKUP(P44,[3]!PV,2,FALSE)),0,I44*VLOOKUP(P44,[3]!PV,4,FALSE)+S44*VLOOKUP(P44,[3]!PV,2,FALSE))","v":0},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(OR(#REF!<>\"\",#REF!<>\"\",#REF!<>\"\",#REF!<>\"\",#REF!<>\"\",#REF!<>\"\",#REF!<>\"\"),\"ACTIVE\",\"\")","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(I45*VLOOKUP(P45,[3]!PV,4,FALSE)+S45*VLOOKUP(P45,[3]!PV,2,FALSE)),0,I45*VLOOKUP(P45,[3]!PV,4,FALSE)+S45*VLOOKUP(P45,[3]!PV,2,FALSE))","v":0},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(OR(B21<>\"\",C21<>\"\",D21<>\"\",#REF!<>\"\",#REF!<>\"\",#REF!<>\"\",#REF!<>\"\"),\"ACTIVE\",\"\")","v":{"$error":"#REF!"}}]
[null,"Refrigerated Air Dryer:",null,null,"Energy Efficient Model"]
[null,"Base Model",null,null,"Cost Each",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(I47*VLOOKUP(P47,[3]!PV,4,FALSE)+S47*VLOOKUP(P47,[3]!PV,2,FALSE)),0,I47*VLOOKUP(P47,[3]!PV,4,FALSE)+S47*VLOOKUP(P47,[3]!PV,2,FALSE))","v":0},{"$f":"IF(AND(#REF!=\"New Fixtures\",#REF!>0,OR(#REF!=\"Standard Interior\",#REF!=\"High-Performance Interior\")),#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(OR(#REF!=\"Standard Interior\",#REF!=\"High-Performance Interior\"),(NOT(OR(#REF!=\"Misc. Costs - Standard\",#REF!=\"Misc. Costs - High Performance\")))),#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(OR(#REF!=\"Standard Interior\",#REF!=\"High-Performance Interior\"),#REF!*#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(OR(#REF!=\"Misc. Costs - High Performance\",#REF!=\"High-Performance Interior\",#REF!=\"High-Performance Exterior\"),\"Y\",\"N\")","v":{"$error":"#REF!"}},{"$f":"IF(X47=\"Y\",#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(X47=\"Y\",N47,0)","v":{"$error":"#REF!"}},{"$f":"IF(X47=\"Y\",O47,0)","v":{"$error":"#REF!"}},{"$f":"IF(OR(#REF!=\"Misc. Costs - Interior\",#REF!=\"Misc. Costs - Exterior\"),0,1)","v":{"$error":"#REF!"}},{"$f":"IF(OR(B22<>\"\",C22<>\"\",D22<>\"\",#REF!<>\"\",#REF!<>\"\",#REF!<>\"\",#REF!<>\"\"),\"ACTIVE\",\"\")","v":{"$error":"#REF!"}}]
[null,"Cost Each",null,null,"Manufacturer:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(I48*VLOOKUP(P48,[3]!PV,4,FALSE)+S48*VLOOKUP(P48,[3]!PV,2,FALSE)),0,I48*VLOOKUP(P48,[3]!PV,4,FALSE)+S48*VLOOKUP(P48,[3]!PV,2,FALSE))","v":0},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(OR(B23<>\"\",#REF!<>\"\",D23<>\"\",C23<>\"\",#REF!<>\"\",#REF!<>\"\",#REF!<>\"\"),\"ACTIVE\",\"\")","v":{"$error":"#REF!"}}]
[null,"Manufacturer:",null,null,"Model Number",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(I49*VLOOKUP(P49,[3]!PV,4,FALSE)+S49*VLOOKUP(P49,[3]!PV,2,FALSE)),0,I49*VLOOKUP(P49,[3]!PV,4,FALSE)+S49*VLOOKUP(P49,[3]!PV,2,FALSE))","v":0},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Model Number",null,null,"Air or Water Cooled",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(I50*VLOOKUP(P50,[3]!PV,4,FALSE)+S50*VLOOKUP(P50,[3]!PV,2,FALSE)),0,I50*VLOOKUP(P50,[3]!PV,4,FALSE)+S50*VLOOKUP(P50,[3]!PV,2,FALSE))","v":0},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Air or Water Cooled",null,null,"Cycling/Non Cycling",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(I51*VLOOKUP(P51,[3]!PV,4,FALSE)+S51*VLOOKUP(P51,[3]!PV,2,FALSE)),0,I51*VLOOKUP(P51,[3]!PV,4,FALSE)+S51*VLOOKUP(P51,[3]!PV,2,FALSE))","v":0},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Cycling/Non Cycling",null,null,"Tested Flow scfm",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(I52*VLOOKUP(P52,[3]!PV,4,FALSE)+S52*VLOOKUP(P52,[3]!PV,2,FALSE)),0,I52*VLOOKUP(P52,[3]!PV,4,FALSE)+S52*VLOOKUP(P52,[3]!PV,2,FALSE))","v":0},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Tested Flow scfm",null,null,"# of Air Dryers:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(I53*VLOOKUP(P53,[3]!PV,4,FALSE)+S53*VLOOKUP(P53,[3]!PV,2,FALSE)),0,I53*VLOOKUP(P53,[3]!PV,4,FALSE)+S53*VLOOKUP(P53,[3]!PV,2,FALSE))","v":0},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"# of Air Dryers:",null,null,"Outlet Pressure Dewpoint  °F"]
[null,"Outlet Pressure Dewpoint  °F",null,null,"Pressure Drop psi",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(I55*VLOOKUP(P55,[3]!PV,4,FALSE)+S55*VLOOKUP(P55,[3]!PV,2,FALSE)),0,I55*VLOOKUP(P55,[3]!PV,4,FALSE)+S55*VLOOKUP(P55,[3]!PV,2,FALSE))","v":0},{"$f":"IF(AND(#REF!=\"New Fixtures\",#REF!>0,OR(#REF!=\"Standard Interior\",#REF!=\"High-Performance Interior\")),#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(OR(#REF!=\"Standard Interior\",#REF!=\"High-Performance Interior\"),(NOT(OR(#REF!=\"Misc. Costs - Standard\",#REF!=\"Misc. Costs - High Performance\")))),#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(OR(#REF!=\"Standard Interior\",#REF!=\"High-Performance Interior\"),#REF!*#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(OR(#REF!=\"Misc. Costs - High Performance\",#REF!=\"High-Performance Interior\",#REF!=\"High-Performance Exterior\"),\"Y\",\"N\")","v":{"$error":"#REF!"}},{"$f":"IF(X55=\"Y\",#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(X55=\"Y\",N55,0)","v":{"$error":"#REF!"}},{"$f":"IF(X55=\"Y\",O55,0)","v":{"$error":"#REF!"}},{"$f":"IF(OR(#REF!=\"Misc. Costs - Interior\",#REF!=\"Misc. Costs - Exterior\"),0,1)","v":{"$error":"#REF!"}},{"$f":"IF(OR(B29<>\"\",#REF!<>\"\",D29<>\"\",C29<>\"\",#REF!<>\"\",#REF!<>\"\",#REF!<>\"\"),\"ACTIVE\",\"\")","v":{"$error":"#REF!"}}]
[null,"Pressure Drop psi",null,null,"Total Dryer Input Power kW",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(I56*VLOOKUP(P56,[3]!PV,4,FALSE)+S56*VLOOKUP(P56,[3]!PV,2,FALSE)),0,I56*VLOOKUP(P56,[3]!PV,4,FALSE)+S56*VLOOKUP(P56,[3]!PV,2,FALSE))","v":0},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Total Dryer Input Power kW",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(I57*VLOOKUP(P57,[3]!PV,4,FALSE)+S57*VLOOKUP(P57,[3]!PV,2,FALSE)),0,I57*VLOOKUP(P57,[3]!PV,4,FALSE)+S57*VLOOKUP(P57,[3]!PV,2,FALSE))","v":0},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(OR(B31<>\"\",C31<>\"\",D31<>\"\",#REF!<>\"\",#REF!<>\"\",#REF!<>\"\",#REF!<>\"\"),\"ACTIVE\",\"\")","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(I58*VLOOKUP(P58,[3]!PV,4,FALSE)+S58*VLOOKUP(P58,[3]!PV,2,FALSE)),0,I58*VLOOKUP(P58,[3]!PV,4,FALSE)+S58*VLOOKUP(P58,[3]!PV,2,FALSE))","v":0},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(OR(E14<>\"\",F14<>\"\",#REF!<>\"\",#REF!<>\"\",#REF!<>\"\",#REF!<>\"\",#REF!<>\"\"),\"ACTIVE\",\"\")","v":{"$error":"#REF!"}}]
[null,"Provide any additional information relevant to this project.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(I59*VLOOKUP(P59,[3]!PV,4,FALSE)+S59*VLOOKUP(P59,[3]!PV,2,FALSE)),0,I59*VLOOKUP(P59,[3]!PV,4,FALSE)+S59*VLOOKUP(P59,[3]!PV,2,FALSE))","v":0},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(OR(E17<>\"\",F17<>\"\",#REF!<>\"\",#REF!<>\"\",#REF!<>\"\",#REF!<>\"\",#REF!<>\"\"),\"ACTIVE\",\"\")","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(I60*VLOOKUP(P60,[3]!PV,4,FALSE)+S60*VLOOKUP(P60,[3]!PV,2,FALSE)),0,I60*VLOOKUP(P60,[3]!PV,4,FALSE)+S60*VLOOKUP(P60,[3]!PV,2,FALSE))","v":0},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(OR(E18<>\"\",F18<>\"\",#REF!<>\"\",#REF!<>\"\",#REF!<>\"\",#REF!<>\"\",#REF!<>\"\"),\"ACTIVE\",\"\")","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(I61*VLOOKUP(P61,[3]!PV,4,FALSE)+S61*VLOOKUP(P61,[3]!PV,2,FALSE)),0,I61*VLOOKUP(P61,[3]!PV,4,FALSE)+S61*VLOOKUP(P61,[3]!PV,2,FALSE))","v":0},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(OR(E19<>\"\",F19<>\"\",#REF!<>\"\",#REF!<>\"\",#REF!<>\"\",#REF!<>\"\",#REF!<>\"\"),\"ACTIVE\",\"\")","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(I62*VLOOKUP(P62,[3]!PV,4,FALSE)+S62*VLOOKUP(P62,[3]!PV,2,FALSE)),0,I62*VLOOKUP(P62,[3]!PV,4,FALSE)+S62*VLOOKUP(P62,[3]!PV,2,FALSE))","v":0},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(OR(#REF!<>\"\",#REF!<>\"\",#REF!<>\"\",#REF!<>\"\",#REF!<>\"\",#REF!<>\"\",#REF!<>\"\"),\"ACTIVE\",\"\")","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(I63*VLOOKUP(P63,[3]!PV,4,FALSE)+S63*VLOOKUP(P63,[3]!PV,2,FALSE)),0,I63*VLOOKUP(P63,[3]!PV,4,FALSE)+S63*VLOOKUP(P63,[3]!PV,2,FALSE))","v":0},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(OR(E22<>\"\",F22<>\"\",#REF!<>\"\",F39<>\"\",#REF!<>\"\",#REF!<>\"\",#REF!<>\"\"),\"ACTIVE\",\"\")","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(I64*VLOOKUP(P64,[3]!PV,4,FALSE)+S64*VLOOKUP(P64,[3]!PV,2,FALSE)),0,I64*VLOOKUP(P64,[3]!PV,4,FALSE)+S64*VLOOKUP(P64,[3]!PV,2,FALSE))","v":0},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(OR(E24<>\"\",#REF!<>\"\",F24<>\"\",#REF!<>\"\",#REF!<>\"\",#REF!<>\"\",#REF!<>\"\"),\"ACTIVE\",\"\")","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(I65*VLOOKUP(P65,[3]!PV,4,FALSE)+S65*VLOOKUP(P65,[3]!PV,2,FALSE)),0,I65*VLOOKUP(P65,[3]!PV,4,FALSE)+S65*VLOOKUP(P65,[3]!PV,2,FALSE))","v":0},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(OR(E25<>\"\",#REF!<>\"\",D43<>\"\",F25<>\"\",#REF!<>\"\",#REF!<>\"\",#REF!<>\"\"),\"ACTIVE\",\"\")","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(I66*VLOOKUP(P66,[3]!PV,4,FALSE)+S66*VLOOKUP(P66,[3]!PV,2,FALSE)),0,I66*VLOOKUP(P66,[3]!PV,4,FALSE)+S66*VLOOKUP(P66,[3]!PV,2,FALSE))","v":0},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(OR(E26<>\"\",#REF!<>\"\",D44<>\"\",F26<>\"\",#REF!<>\"\",#REF!<>\"\",#REF!<>\"\"),\"ACTIVE\",\"\")","v":{"$error":"#REF!"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(I68*VLOOKUP(P68,[3]!PV,4,FALSE)+S68*VLOOKUP(P68,[3]!PV,2,FALSE)),0,I68*VLOOKUP(P68,[3]!PV,4,FALSE)+S68*VLOOKUP(P68,[3]!PV,2,FALSE))","v":0},{"$f":"IF(AND(#REF!=\"New Fixtures\",#REF!>0,OR(#REF!=\"Standard Interior\",#REF!=\"High-Performance Interior\")),#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(OR(#REF!=\"Standard Interior\",#REF!=\"High-Performance Interior\"),(NOT(OR(#REF!=\"Misc. Costs - Standard\",#REF!=\"Misc. Costs - High Performance\")))),#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(OR(#REF!=\"Standard Interior\",#REF!=\"High-Performance Interior\"),#REF!*#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(OR(#REF!=\"Misc. Costs - High Performance\",#REF!=\"High-Performance Interior\",#REF!=\"High-Performance Exterior\"),\"Y\",\"N\")","v":{"$error":"#REF!"}},{"$f":"IF(X68=\"Y\",#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(X68=\"Y\",N68,0)","v":{"$error":"#REF!"}},{"$f":"IF(X68=\"Y\",O68,0)","v":{"$error":"#REF!"}},{"$f":"IF(OR(#REF!=\"Misc. Costs - Interior\",#REF!=\"Misc. Costs - Exterior\"),0,1)","v":{"$error":"#REF!"}},{"$f":"IF(OR(E27<>\"\",#REF!<>\"\",D45<>\"\",F27<>\"\",#REF!<>\"\",#REF!<>\"\",#REF!<>\"\"),\"ACTIVE\",\"\")","v":{"$error":"#REF!"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(I70*VLOOKUP(P70,[3]!PV,4,FALSE)+S70*VLOOKUP(P70,[3]!PV,2,FALSE)),0,I70*VLOOKUP(P70,[3]!PV,4,FALSE)+S70*VLOOKUP(P70,[3]!PV,2,FALSE))","v":0},{"$f":"IF(AND(#REF!=\"New Fixtures\",#REF!>0,OR(#REF!=\"Standard Interior\",#REF!=\"High-Performance Interior\")),#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(OR(#REF!=\"Standard Interior\",#REF!=\"High-Performance Interior\"),(NOT(OR(#REF!=\"Misc. Costs - Standard\",#REF!=\"Misc. Costs - High Performance\")))),#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(OR(#REF!=\"Standard Interior\",#REF!=\"High-Performance Interior\"),#REF!*#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(OR(#REF!=\"Misc. Costs - High Performance\",#REF!=\"High-Performance Interior\",#REF!=\"High-Performance Exterior\"),\"Y\",\"N\")","v":{"$error":"#REF!"}},{"$f":"IF(X70=\"Y\",#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(X70=\"Y\",N70,0)","v":{"$error":"#REF!"}},{"$f":"IF(X70=\"Y\",O70,0)","v":{"$error":"#REF!"}},{"$f":"IF(OR(#REF!=\"Misc. Costs - Interior\",#REF!=\"Misc. Costs - Exterior\"),0,1)","v":{"$error":"#REF!"}},{"$f":"IF(OR(B32<>\"\",C32<>\"\",D32<>\"\",F45<>\"\",#REF!<>\"\",#REF!<>\"\",#REF!<>\"\"),\"ACTIVE\",\"\")","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(I71*VLOOKUP(P71,[3]!PV,4,FALSE)+S71*VLOOKUP(P71,[3]!PV,2,FALSE)),0,I71*VLOOKUP(P71,[3]!PV,4,FALSE)+S71*VLOOKUP(P71,[3]!PV,2,FALSE))","v":0},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(OR(B33<>\"\",C33<>\"\",#REF!<>\"\",#REF!<>\"\",#REF!<>\"\",#REF!<>\"\",#REF!<>\"\"),\"ACTIVE\",\"\")","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(I72*VLOOKUP(P72,[3]!PV,4,FALSE)+S72*VLOOKUP(P72,[3]!PV,2,FALSE)),0,I72*VLOOKUP(P72,[3]!PV,4,FALSE)+S72*VLOOKUP(P72,[3]!PV,2,FALSE))","v":0},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(I73*VLOOKUP(P73,[3]!PV,4,FALSE)+S73*VLOOKUP(P73,[3]!PV,2,FALSE)),0,I73*VLOOKUP(P73,[3]!PV,4,FALSE)+S73*VLOOKUP(P73,[3]!PV,2,FALSE))","v":0},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(I74*VLOOKUP(P74,[3]!PV,4,FALSE)+S74*VLOOKUP(P74,[3]!PV,2,FALSE)),0,I74*VLOOKUP(P74,[3]!PV,4,FALSE)+S74*VLOOKUP(P74,[3]!PV,2,FALSE))","v":0},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(I75*VLOOKUP(P75,[3]!PV,4,FALSE)+S75*VLOOKUP(P75,[3]!PV,2,FALSE)),0,I75*VLOOKUP(P75,[3]!PV,4,FALSE)+S75*VLOOKUP(P75,[3]!PV,2,FALSE))","v":0},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(I76*VLOOKUP(P76,[3]!PV,4,FALSE)+S76*VLOOKUP(P76,[3]!PV,2,FALSE)),0,I76*VLOOKUP(P76,[3]!PV,4,FALSE)+S76*VLOOKUP(P76,[3]!PV,2,FALSE))","v":0},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(I77*VLOOKUP(P77,[3]!PV,4,FALSE)+S77*VLOOKUP(P77,[3]!PV,2,FALSE)),0,I77*VLOOKUP(P77,[3]!PV,4,FALSE)+S77*VLOOKUP(P77,[3]!PV,2,FALSE))","v":0},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(OR(B40<>\"\",C40<>\"\",#REF!<>\"\",#REF!<>\"\",#REF!<>\"\",#REF!<>\"\",#REF!<>\"\"),\"ACTIVE\",\"\")","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(I78*VLOOKUP(P78,[3]!PV,4,FALSE)+S78*VLOOKUP(P78,[3]!PV,2,FALSE)),0,I78*VLOOKUP(P78,[3]!PV,4,FALSE)+S78*VLOOKUP(P78,[3]!PV,2,FALSE))","v":0},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(OR(#REF!<>\"\",#REF!<>\"\",#REF!<>\"\",#REF!<>\"\",#REF!<>\"\",#REF!<>\"\",#REF!<>\"\"),\"ACTIVE\",\"\")","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(I79*VLOOKUP(P79,[3]!PV,4,FALSE)+S79*VLOOKUP(P79,[3]!PV,2,FALSE)),0,I79*VLOOKUP(P79,[3]!PV,4,FALSE)+S79*VLOOKUP(P79,[3]!PV,2,FALSE))","v":0},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(OR(B41<>\"\",C41<>\"\",#REF!<>\"\",#REF!<>\"\",#REF!<>\"\",#REF!<>\"\",#REF!<>\"\"),\"ACTIVE\",\"\")","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(I80*VLOOKUP(P80,[3]!PV,4,FALSE)+S80*VLOOKUP(P80,[3]!PV,2,FALSE)),0,I80*VLOOKUP(P80,[3]!PV,4,FALSE)+S80*VLOOKUP(P80,[3]!PV,2,FALSE))","v":0},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(OR(B42<>\"\",C42<>\"\",D42<>\"\",F57<>\"\",#REF!<>\"\",#REF!<>\"\",#REF!<>\"\"),\"ACTIVE\",\"\")","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(I81*VLOOKUP(P81,[3]!PV,4,FALSE)+S81*VLOOKUP(P81,[3]!PV,2,FALSE)),0,I81*VLOOKUP(P81,[3]!PV,4,FALSE)+S81*VLOOKUP(P81,[3]!PV,2,FALSE))","v":0},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(OR(B46<>\"\",C46<>\"\",#REF!<>\"\",#REF!<>\"\",#REF!<>\"\",#REF!<>\"\",#REF!<>\"\"),\"ACTIVE\",\"\")","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(I82*VLOOKUP(P82,[3]!PV,4,FALSE)+S82*VLOOKUP(P82,[3]!PV,2,FALSE)),0,I82*VLOOKUP(P82,[3]!PV,4,FALSE)+S82*VLOOKUP(P82,[3]!PV,2,FALSE))","v":0},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(OR(#REF!<>\"\",#REF!<>\"\",#REF!<>\"\",#REF!<>\"\",#REF!<>\"\",#REF!<>\"\",#REF!<>\"\"),\"ACTIVE\",\"\")","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(H83*VLOOKUP(P83,[3]!PV,4,FALSE)+S83*VLOOKUP(P83,[3]!PV,2,FALSE)),0,H83*VLOOKUP(P83,[3]!PV,4,FALSE)+S83*VLOOKUP(P83,[3]!PV,2,FALSE))","v":0},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(OR(B47<>\"\",C47<>\"\",#REF!<>\"\",#REF!<>\"\",#REF!<>\"\",#REF!<>\"\",#REF!<>\"\"),\"ACTIVE\",\"\")","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(H84*VLOOKUP(P84,[3]!PV,4,FALSE)+S84*VLOOKUP(P84,[3]!PV,2,FALSE)),0,H84*VLOOKUP(P84,[3]!PV,4,FALSE)+S84*VLOOKUP(P84,[3]!PV,2,FALSE))","v":0},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(OR(B48<>\"\",C48<>\"\",#REF!<>\"\",#REF!<>\"\",#REF!<>\"\",#REF!<>\"\",#REF!<>\"\"),\"ACTIVE\",\"\")","v":{"$error":"#REF!"}}]

{"sheet":"19-Air Compressor Heat Recovery","index":24,"n_rows":63,"n_cols":26,"rows_kept":63,"cut":false,"hidden":true,"merged":[[0,1,0,7],[1,1,3,7],[3,9,4,15],[5,1,5,7],[5,9,17,15],[13,1,13,7],[15,1,15,7],[16,1,16,7],[17,1,17,7],[28,2,28,7],[29,2,29,7],[30,2,30,7],[18,1,19,7],[20,2,20,3],[22,2,22,3],[24,1,24,7],[25,2,25,7],[31,2,31,7],[32,2,32,7],[48,9,48,15],[49,9,55,15],[18,9,18,15],[19,9,20,15],[23,9,26,15],[28,9,33,15],[34,9,34,15],[35,9,35,15],[37,9,44,15],[53,2,53,5],[54,2,54,5],[55,1,55,5],[26,2,26,7],[27,2,27,7],[56,1,61,5],[62,1,62,5],[63,1,68,5],[37,1,37,3],[47,1,47,5],[48,2,48,5],[49,2,49,5],[50,2,50,5],[51,2,51,5],[52,2,52,5]]}
["Click to go back on Project summary tab","Air Compressor Heat Recovery"]
[null,"Please complete all yellow cells and provide:\n- Site mechanical plans\n- Specifications for all units\n- Documentation to support cost data, such as the vendor proposal"]
[]
[null,null,null,null,null,null,null,null,null,"Compressed Air Heat Recovery"]
[]
[null,"Compressor Hours",null,null,null,null,null,null,null,"For conditions where the air compressor takes in outside/indoor air to cool itself.  This is not for water cooled compressors.  This measure can effect heating or cooling of a building space but not both.  See notes below. The occupied building space must be served by Electric air conditioning equipment or Natural Gas heating equipment and the customer must be on a firm rate.  The sheet calculations are based on bin data analysis and the thermostat setpoint at which the system will automatically switch over to begin to recover heat. System must have automated control with motorized dampers, thermostatic control and correct control logic for safe  compressor operation."]
[null,null,"Weekday","Weekend"]
[null,"Midnight to 8am",null,null,"Input occupied hours for time periods shown."]
[null,"8am to 4pm",null,null,"Input occupied hours for time periods shown."]
[null,"4pm to Midnight",null,null,"Input occupied hours for time periods shown."]
[]
[]
[]
[null,"Building Systems Information"]
[]
[null,"How would you best describe the location of the compressor?"]
[]
[null,"If other location if \"Other\" was chosen:"]
[]
[null,null,null,null,null,null,null,null,null,"If the air compressor draws its cooling air from the outside or a separate mechanical room and does not currently exhaust this air into heated occupied building space then indicate \"No\" for Is Space Cooled."]
[null,null,"Is space cooled?"]
[]
[null,null,"TOTAL INSTALLED COSTS"]
[null,null,null,null,null,null,null,null,null,"If the air compressor is located in an occupied building space (not a separate back room) that is air conditioned and draws and exhausts  its cooling air from this occupied space then indicate \"Yes\" for Is Space Cooled."]
[null,"Compressor Data"]
[null,null,"Existing or New Compressor",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Compressor is existing"]
[null,null,"Compressor Rating (hp)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Compressor is new"]
[null,null,"Compressor Qty."]
[null,null,"Rated Capacity at Full Load Operating Pressure (cfm for each comp.) - CAGI",null,null,null,null,null,null,"Program assumptions include 80% of compressor power generates waste heat. Of that 80%, only 80% of that will be effectively recovered to the space (skin losses of compressor and duct work). Space is assumed to have a heating system that is 80% efficient which is specified in the Program Savings Document."]
[null,null,"Quantity of thermostats"]
[null,null,"Heating thermostat setpoint °F",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"compressor location"]
[null,null,"Compressor heat recovery setpoint"]
[null,null,"% useful compressor heat recovered (assume 80% due to skin/ducting losses)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Located in conditioned space (heated /maybe cooled)"]
[null,"Heating Fuel Type",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Located in in a room with venting to the outside"]
[null,null,null,null,null,null,null,null,null,"INSTRUCTIONS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other -describe below"]
[]
[null,"Facility Loads",null,null,null,null,null,null,null,"Enter the hours of operation for Production in relation to the weekday/weekend schedules. Calculation inputs include: location of compressor, whether the space the compressor is located is cooled in the Summer, installed cost for the automated heat recovery, whether this is for an existing system or part of a new compressor installation, compressor horsepower rating, number of compressors, full load air compresor capacity (cfm) and compressor load profile."]
[null,"Loads","CFM","HRS"]
[]
[null,1]
[null,2]
[null,3]
[null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No"]
[]
[]
[null,"HVAC Data (for area where heating/cooling will be supplied)"]
[null,null,"OA temperature setpoint for heating (winter operation)",null,null,null,null,null,null,"Provide any additional information relevant to this project."]
[null,null,"Heating equipment type"]
[null,null,"Heating capacity (Btu/h)"]
[null,null,"Heating efficiency"]
[null,null,"Cooling equipment type"]
[null,null,"Cooling capacity Btu/hr"]
[null,null,"Cooling EER"]
[null,"Describe the location of thermostats"]
[]
[]
[]
[]
[]
[]
[null,"Describe the location where ductwork will vent from the compressor"]