{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["TAB 1-Installation Report","TAB 2-Measure Specifications","Measure Category","Master Export","Export"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":9,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"TAB 1-Installation Report","index":0,"n_rows":42,"n_cols":18,"rows_kept":42,"cut":false,"hidden":false,"merged":[[0,1,0,13],[1,1,1,13],[2,1,2,13],[10,4,10,10],[11,1,11,2],[38,1,38,2],[7,7,7,8],[4,1,4,16],[39,1,39,2],[40,1,40,2],[10,1,10,2],[9,1,9,11],[6,3,6,4],[7,3,7,4],[6,7,6,8]]}
[null,"New Jersey Office of Clean Energy"]
[null,"Pay for Performance Program"]
[null,"Installation Report v4.0b (09-20-2016)"]
[]
[null,"INSTRUCTIONS:\n1) This document should only be used for projects using ERP Tables v4.4 or earlier. Projects using ERP Table v4.5 and later must use same ERP Tables, updated with as-built data to complete this exercise. \n2) Open approved ERP Excel Tables. Copy and paste values from  'Table 14 Measure Costs & Savings' (v3.2a and older) or 'Measure Simulation' tab (v4.0-4.4) into Columns C through L in the table below. Align with table headers.\n3) Any changes to the installed scope of work must follow Program Guidelines v4.1, Section 5.4. \n4) Enter Actual Installed Cost for each measure in Column N. This is the actual amount paid for both material and labor for each measure and should match invoice(s). \n5) Include invoices with submittal. Invoices should be organized by measure, include a description of the equipment installed, quantity, and unit price (e.g. material price per fixture, motor, etc.), and align with measure costs in Column N.  Material and labor should be indicated separately if possible. Invoices must also be submitted for any CM and Partner fees listed. \n6) Fill out all remaining columns (all blue cells) for each measure.\n7) Hide extra rows as necessary. \n8) Go to TAB-2"]
[]
[null,null,"P4P Project Name:",null,null,"P4P Application #: "]
[null,null,"P4P Partner Firm:",null,null,"Report Date: "]
[]
[null,"<-------------------------------------------------------Paste from approved ERP Excel Tables---------------------------------------------------------------->"]
[null,"Measure Name",null,"Installed Cost (incl. design)","Annual Energy Savings",null,null,null,null,null,null,"Demand Savings","Actual Installed Cost","Invoice Attached?","Completion Date","Performance Testing Required?","List Remaining Punchlist Items","Notes"]
[null,null,null,"$","kWh","Gas MMBtu","Steam MMBtu","HW MMBtu","CW MMBTU","Fuel Oil/Propane MMBtu","Other MMBtu","kW","$","(Y/N)","(mm/dd/yy)","(Y/N)"]
[null,1,null,null,null,null,null,null,null,null,null,null,0]
[null,2,null,null,null,null,null,null,null,null,null,null,0]
[null,3,null,null,null,null,null,null,null,null,null,null,0]
[null,4,null,null,null,null,null,null,null,null,null,null,0]
[null,5,null,null,null,null,null,null,null,null,null,null,0]
[null,6,null,null,null,null,null,null,null,null,null,null,0]
[null,7,null,null,null,null,null,null,null,null,null,null,0]
[null,8,null,null,null,null,null,null,null,null,null,null,0]
[null,9,null,null,null,null,null,null,null,null,null,null,0]
[null,10,null,null,null,null,null,null,null,null,null,null,0]
[null,11,null,null,null,null,null,null,null,null,null,null,0]
[null,12,null,null,null,null,null,null,null,null,null,null,0]
[null,13,null,null,null,null,null,null,null,null,null,null,0]
[null,14,null,null,null,null,null,null,null,null,null,null,0]
[null,15,null,null,null,null,null,null,null,null,null,null,0]
[null,16,null,null,null,null,null,null,null,null,null,null,0]
[null,17,null,null,null,null,null,null,null,null,null,null,0]
[null,18,null,null,null,null,null,null,null,null,null,null,0]
[null,19,null,null,null,null,null,null,null,null,null,null,0]
[null,20,null,null,null,null,null,null,null,null,null,null,0]
[null,21,null,null,null,null,null,null,null,null,null,null,0]
[null,22,null,null,null,null,null,null,null,null,null,null,0]
[null,23,null,null,null,null,null,null,null,null,null,null,0]
[null,24,null,null,null,null,null,null,null,null,null,null,0]
[null,25,null,null,null,null,null,null,null,null,null,null,0]
[]
[null,"CM Fees",null,null,null,null,null,null,null,null,null,null,0]
[null,"Partner Fees",null,null,null,null,null,null,null,null,null,null,0]
[null,"TOTALS",null,{"$f":"SUM(D13:D40)","v":0},{"$f":"SUM(E13:E37)","v":0},0,0,0,0,0,0,0,{"$f":"SUM(M13:M40)","v":0}]
[null,null,null,null,null,null,null,null,null,null," Cap for Incentives 2 + 3:",null,{"$f":"0.5*M41","v":0}]

{"sheet":"TAB 2-Measure Specifications","index":1,"n_rows":35,"n_cols":25,"rows_kept":35,"cut":false,"hidden":false,"merged":[[9,23,9,24],[9,1,9,2],[0,0,0,12],[1,0,1,12],[2,0,2,12],[4,1,4,11]]}
["New Jersey Office of Clean Energy"]
["Pay for Performance Program"]
["As-Built Measure Specifications"]
[]
[null,"INSTRUCTIONS:\n1) Fill out table below so that it reflects actual installed measures. Please be specific as this table will be used to conduct the Post-Inspection. Use Additional Notes column to explain any deviations from approved scope of work in the ERP. \n2) For lighting measures, please include a separate Lighting Worksheet (using ERP Excel Tables, Lighting table) showing as-built lighting schedule. Changes to as-built fixtures and/or controls from proposed fixtures and/or controls in the ERP should be highlighted/noted. \n3) Upon completion of both TAB 1-Installation Report and TAB 2-Measure Specifications, please submit to Program Manager, along with Invoices, Request for Incentive #2 form, and any supplementary documentation (e.g. revised ERP (if required), etc.)."]
[]
[null,null,"P4P Project Name:",{"$f":"IF('TAB 1-Installation Report'!D7=0, \" \",'TAB 1-Installation Report'!D7)","v":" "},"P4P Application #: ",{"$f":"IF('TAB 1-Installation Report'!H7=0, \" \",'TAB 1-Installation Report'!H7)","v":" "}]
[null,null,"P4P Partner Firm:",{"$f":"IF('TAB 1-Installation Report'!D8=0, \" \",'TAB 1-Installation Report'!D8)","v":" "},"Report Date: ",{"$f":"IF('TAB 1-Installation Report'!H8=0, \" \",'TAB 1-Installation Report'!H8)","v":" "}]
[]
[null,"Measure Name",null,"Measure Category","Measure Details ","Location ","Manufacturer","Model","Capacity","Capacity Units","Quantity","Efficiency","Efficiency Units","Additional Notes"]
[null,1,{"$f":"IF('TAB 1-Installation Report'!C13=0, \" \",'TAB 1-Installation Report'!C13)","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Capacity Units","Efficiency Units"]
[null,2,{"$f":"IF('TAB 1-Installation Report'!C14=0, \" \",'TAB 1-Installation Report'!C14)","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tons","EER"]
[null,3,{"$f":"IF('TAB 1-Installation Report'!C15=0, \" \",'TAB 1-Installation Report'!C15)","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gallons","SEER"]
[null,4,{"$f":"IF('TAB 1-Installation Report'!C16=0, \" \",'TAB 1-Installation Report'!C16)","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BTUH","HSPF"]
[null,5,{"$f":"IF('TAB 1-Installation Report'!C17=0, \" \",'TAB 1-Installation Report'!C17)","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MBH","AFUE"]
[null,6,{"$f":"IF('TAB 1-Installation Report'!C18=0, \" \",'TAB 1-Installation Report'!C18)","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"W","Et"]
[null,7,{"$f":"IF('TAB 1-Installation Report'!C19=0, \" \",'TAB 1-Installation Report'!C19)","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DCW","Ec"]
[null,8,{"$f":"IF('TAB 1-Installation Report'!C20=0, \" \",'TAB 1-Installation Report'!C20)","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HP","Energy Factor"]
[null,9,{"$f":"IF('TAB 1-Installation Report'!C21=0, \" \",'TAB 1-Installation Report'!C21)","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NPC","kW/ton"]
[null,10,{"$f":"IF('TAB 1-Installation Report'!C22=0, \" \",'TAB 1-Installation Report'!C22)","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WG","COP"]
[null,11,{"$f":"IF('TAB 1-Installation Report'!C23=0, \" \",'TAB 1-Installation Report'!C23)","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GPM","gpm"]
[null,12,{"$f":"IF('TAB 1-Installation Report'!C24=0, \" \",'TAB 1-Installation Report'!C24)","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NEMA"]
[null,13,{"$f":"IF('TAB 1-Installation Report'!C25=0, \" \",'TAB 1-Installation Report'!C25)","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CFM"]
[null,14,{"$f":"IF('TAB 1-Installation Report'!C26=0, \" \",'TAB 1-Installation Report'!C26)","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CFM/sf"]
[null,15,{"$f":"IF('TAB 1-Installation Report'!C27=0, \" \",'TAB 1-Installation Report'!C27)","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"U-value"]
[null,16,{"$f":"IF('TAB 1-Installation Report'!C28=0, \" \",'TAB 1-Installation Report'!C28)","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"R-value"]
[null,17,{"$f":"IF('TAB 1-Installation Report'!C29=0, \" \",'TAB 1-Installation Report'!C29)","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SHGC"]
[null,18,{"$f":"IF('TAB 1-Installation Report'!C30=0, \" \",'TAB 1-Installation Report'!C30)","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A"]
[null,19,{"$f":"IF('TAB 1-Installation Report'!C31=0, \" \",'TAB 1-Installation Report'!C31)","v":" "}]
[null,20,{"$f":"IF('TAB 1-Installation Report'!C32=0, \" \",'TAB 1-Installation Report'!C32)","v":" "}]
[null,21,{"$f":"IF('TAB 1-Installation Report'!C33=0, \" \",'TAB 1-Installation Report'!C33)","v":" "}]
[null,22,{"$f":"IF('TAB 1-Installation Report'!C34=0, \" \",'TAB 1-Installation Report'!C34)","v":" "}]
[null,23,{"$f":"IF('TAB 1-Installation Report'!C35=0, \" \",'TAB 1-Installation Report'!C35)","v":" "}]
[null,24,{"$f":"IF('TAB 1-Installation Report'!C36=0, \" \",'TAB 1-Installation Report'!C36)","v":" "}]
[null,25,{"$f":"IF('TAB 1-Installation Report'!C37=0, \" \",'TAB 1-Installation Report'!C37)","v":" "}]

{"sheet":"Measure Category","index":2,"n_rows":98,"n_cols":2,"rows_kept":98,"cut":false,"hidden":true,"merged":[]}
["Measure Category (consistent with database) - \nMeasure Descriptions tab","Measure Life"]
["                    --  HVAC --"]
["Air Cooled Chiller (Electric)",25]
["Air to Air Heat Pump",15]
["Central DX AC System",15]
["Closed Loop HP",15]
["Desiccant System (Gas or Electric)",15]
["Dual Enthalpy Economizer",15]
["Gas Absorption Chiller",25]
["Gas Furnace",20]
["Hot Water Boiler (Gas)",25]
["Open Loop HP",15]
["Packaged Terminal AC & HP",15]
["Programmable Thermostat",15]
["Steam Boiler (Gas)",25]
["Unitary HVAC/Split Systems",15]
["Water Cooled Chiller (Electric) - Full Load",25]
["Water Cooled Chiller (Electric) - Partial Load",25]
["Water Source Heat Pump",15]
["                    --  Motors/Pumps  --"]
["Air Compressor with VFD",8]
["Fractional Electronically Commutated Motor",20]
["ODP Premium Motor - 1200 RPM",20]
["ODP Premium Motor - 1800 RPM",20]
["ODP Premium Motor - 3600 RPM",20]
["TEFC Premium Motor - 1200 RPM",20]
["TEFC Premium Motor - 1800 RPM",20]
["TEFC Premium Motor - 3600 RPM",20]
["VFD - Chilled Water Pump",15]
["VFD - Variable Air Volume",15]
["                --  Service Hot Water  --"]
["Water Heater (Gas) - </= 50 Gals.",10]
["Water Heater (Gas) - > 50 Gals.",10]
["Water Booster Heater (Gas)",10]
["                    --  Lighting  --"]
["CFL - Indoor Fixture",15]
["Fluorescent Fixtures",15]
["De-Lamp/Add Reflectors",15]
["HID",15]
["Incandescent",15]
["Metal Halide",15]
["Mercury Vapor",15]
["Halogen",15]
["LED Lighting",15]
["LED Exit Signs",15]
["LED Parking Lot Lighting",15]
["LED Traffic Signal (For historic files only.)",15]
["LED Pedestrian Signal (For historic files only.)",15]
["Other Lighting",15]
["                    --  Lighting Controls  --"]
["Occupancy Sensors - Wall Mounted (OSW)",18]
["Occupancy Sensors - Remote Mounted (OSR, OSRH)",18]
["Occupancy Hi-Low Controls",18]
["Daylight Dimming Control",18]
["                    --  Envelope  --"]
["Air Sealing",30]
["Doors",30]
["Insulation",30]
["Other Shell Measures",30]
["WindowsSkylights",30]
["                    --  Plug Loads  --"]
["Computer (CPU or Laptop)",10]
["LCD or LED Monitor",10]
["CRT Monitor",10]
["CPU and LCD or LED Monitor",10]
["CPU and CRT Monitor",10]
["TV",10]
["Printer",10]
["                  --  Refrigeration  --"]
["Cooler or Freezer Door Heater Control",10]
["Energy Efficient Doors",10]
["Evaporator-Compressor Control",10]
["Fan-Door Control",10]
["Night Covers for Refrigerator Cases",10]
["Novelty Cooler Shutoff",10]
["                  --  Commercial Food  --"]
["Commercial Convection Oven (Electric)",12]
["Commercial Convection Oven (Gas)",12]
["Commercial Conveyer Oven",12]
["Commercial Dishwasher",12]
["Commercial Freezer - Glass Door",12]
["Commercial Freezer - Solid Door",12]
["Commercial Fryer (Electric)",12]
["Commercial Fryer (Gas)",12]
["Commercial Griddle (Electric)",12]
["Commercial Griddle (Gas)",12]
["Commercial Hot Food Holding Cabinet",12]
["Commercial Ice Machine",12]
["Commercial Rack Oven",12]
["Commercial Refrigerator - Glass Door",12]
["Commercial Refrigerator - Solid Door",12]
["Commercial Steam Cooker (Electric)",12]
["Commercial Steam Cooker (Gas)",12]
["Commercial Combination Steam Cooker (Electric)",12]
["Commercial Combination Steam Cooker (Gas)",12]
["                    --  Other  --"]
["Custom Electric",18]
["Custom Gas",18]

{"sheet":"Master Export","index":3,"n_rows":28,"n_cols":50,"rows_kept":28,"cut":false,"hidden":true,"merged":[]}
["Pay For Performance - Existing Buildings: 2016"]
["Project Name",{"$f":"'TAB 1-Installation Report'!D7","v":0},"Project ID",0,"Street Address",0,"Project SF",0,"CM Fees",{"$f":"'TAB 1-Installation Report'!M39","v":0},"Partner Fees",{"$f":"'TAB 1-Installation Report'!M40","v":0},"Total Measure Cost",{"$f":"'TAB 1-Installation Report'!M41","v":0},"Committed Incentive #1",0,"Paid Incentive #1",0,"Committed Incentive #2",0,"Paid Incentive #2",0,"Committed Incentive #3",0,"Paid Incentive #3",0,"Annual Energy Cost",0,"Annual Cost Savings",0,"Internal Rate of Return (IRR)",0,"Life Cycle Savings",0,"Simple Payback (yrs)",0,"Simple Payback with NJCEP Incentive (yrs)",0,"Peak kW",0,"Total % Savings",0,"% Elec",0,"% Gas",0,"% Oil or Propane",0,"% Other",0]
["Measure Name","Measure Description","Manufacturer","Model","Installation Cost per Unit","Annual Energy Cost Savings per Unit","Incentive Per Unit","Simple Payback w/o Incentives","Simple Payback w/ Incentives","Peak Demand Reduction per Unit","Annual Electricity Savings per Unit","Lifetime Electricity Savings per Unit","Annual Gas Savings per Unit","Lifetime Gas Savings per Unit","Annual Propane Savings per Unit","Lifetime Propane Savings per Unit","Annual Oil Savings per Unit","Lifetime Oil Savings per Unit","Other Energy Savings MMBTU per Unit","Other Lifetime Energy Savings MMBTU per Unit","CO2e Emissions Reduction per Unit (lbs)","Quantity Committed","Quantity Installed"]
[{"$f":"'TAB 2-Measure Specifications'!D11","v":0},{"$f":"'TAB 1-Installation Report'!C13","v":0},{"$f":"'TAB 2-Measure Specifications'!G11","v":0},{"$f":"'TAB 2-Measure Specifications'!H11","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!M13/W4,0)","v":0},0,0,0,0,{"$f":"IFERROR('TAB 1-Installation Report'!L13/W4,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!E13/W4,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!E13*VLOOKUP('TAB 2-Measure Specifications'!D11,MeasureLife,2,FALSE)/W4,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!F13/W4,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!F13*VLOOKUP('TAB 2-Measure Specifications'!D11,MeasureLife,2,FALSE)/W4,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!J3/W4,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!J13*VLOOKUP('TAB 2-Measure Specifications'!D11,MeasureLife,2,FALSE)/W4,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!J13/W4,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!J13*VLOOKUP('TAB 2-Measure Specifications'!D11,MeasureLife,2,FALSE)/W4,0)","v":0},{"$f":"IFERROR(SUM('TAB 1-Installation Report'!G14,'TAB 1-Installation Report'!H14,'TAB 1-Installation Report'!I14,'TAB 1-Installation Report'!K14)/W4,0)","v":0},{"$f":"IFERROR(SUM('TAB 1-Installation Report'!G14,'TAB 1-Installation Report'!H14,'TAB 1-Installation Report'!I14,'TAB 1-Installation Report'!K14)*VLOOKUP('TAB 2-Measure Specifications'!D11,MeasureLife,2,FALSE)/W4,0)","v":0},0,0,{"$f":"IFERROR('TAB 2-Measure Specifications'!K11*1,1)","v":0},"Capacity/Size",{"$f":"'TAB 2-Measure Specifications'!I11","v":0},"Capacity/Size Units",{"$f":"'TAB 2-Measure Specifications'!J11","v":0},"Efficiency",{"$f":"'TAB 2-Measure Specifications'!L11","v":0},"Efficiency Units",{"$f":"'TAB 2-Measure Specifications'!M11","v":0}]
[{"$f":"'TAB 2-Measure Specifications'!D12","v":0},{"$f":"'TAB 1-Installation Report'!C14","v":0},{"$f":"'TAB 2-Measure Specifications'!G12","v":0},{"$f":"'TAB 2-Measure Specifications'!H12","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!M14/W5,0)","v":0},0,0,0,0,{"$f":"IFERROR('TAB 1-Installation Report'!L14/W5,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!E14/W5,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!E14*VLOOKUP('TAB 2-Measure Specifications'!D12,MeasureLife,2,FALSE)/W5,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!F14/W5,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!F14*VLOOKUP('TAB 2-Measure Specifications'!D12,MeasureLife,2,FALSE)/W5,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!J4/W5,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!J14*VLOOKUP('TAB 2-Measure Specifications'!D12,MeasureLife,2,FALSE)/W5,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!J14/W5,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!J14*VLOOKUP('TAB 2-Measure Specifications'!D12,MeasureLife,2,FALSE)/W5,0)","v":0},{"$f":"IFERROR(SUM('TAB 1-Installation Report'!G15,'TAB 1-Installation Report'!H15,'TAB 1-Installation Report'!I15,'TAB 1-Installation Report'!K15)/W5,0)","v":0},{"$f":"IFERROR(SUM('TAB 1-Installation Report'!G15,'TAB 1-Installation Report'!H15,'TAB 1-Installation Report'!I15,'TAB 1-Installation Report'!K15)*VLOOKUP('TAB 2-Measure Specifications'!D12,MeasureLife,2,FALSE)/W5,0)","v":0},0,0,{"$f":"IFERROR('TAB 2-Measure Specifications'!K12*1,1)","v":0},"Capacity/Size",{"$f":"'TAB 2-Measure Specifications'!I12","v":0},"Capacity/Size Units",{"$f":"'TAB 2-Measure Specifications'!J12","v":0},"Efficiency",{"$f":"'TAB 2-Measure Specifications'!L12","v":0},"Efficiency Units",{"$f":"'TAB 2-Measure Specifications'!M12","v":0}]
[{"$f":"'TAB 2-Measure Specifications'!D13","v":0},{"$f":"'TAB 1-Installation Report'!C15","v":0},{"$f":"'TAB 2-Measure Specifications'!G13","v":0},{"$f":"'TAB 2-Measure Specifications'!H13","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!M15/W6,0)","v":0},0,0,0,0,{"$f":"IFERROR('TAB 1-Installation Report'!L15/W6,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!E15/W6,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!E15*VLOOKUP('TAB 2-Measure Specifications'!D13,MeasureLife,2,FALSE)/W6,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!F15/W6,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!F15*VLOOKUP('TAB 2-Measure Specifications'!D13,MeasureLife,2,FALSE)/W6,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!J5/W6,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!J15*VLOOKUP('TAB 2-Measure Specifications'!D13,MeasureLife,2,FALSE)/W6,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!J15/W6,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!J15*VLOOKUP('TAB 2-Measure Specifications'!D13,MeasureLife,2,FALSE)/W6,0)","v":0},{"$f":"IFERROR(SUM('TAB 1-Installation Report'!G16,'TAB 1-Installation Report'!H16,'TAB 1-Installation Report'!I16,'TAB 1-Installation Report'!K16)/W6,0)","v":0},{"$f":"IFERROR(SUM('TAB 1-Installation Report'!G16,'TAB 1-Installation Report'!H16,'TAB 1-Installation Report'!I16,'TAB 1-Installation Report'!K16)*VLOOKUP('TAB 2-Measure Specifications'!D13,MeasureLife,2,FALSE)/W6,0)","v":0},0,0,{"$f":"IFERROR('TAB 2-Measure Specifications'!K13*1,1)","v":0},"Capacity/Size",{"$f":"'TAB 2-Measure Specifications'!I13","v":0},"Capacity/Size Units",{"$f":"'TAB 2-Measure Specifications'!J13","v":0},"Efficiency",{"$f":"'TAB 2-Measure Specifications'!L13","v":0},"Efficiency Units",{"$f":"'TAB 2-Measure Specifications'!M13","v":0}]
[{"$f":"'TAB 2-Measure Specifications'!D14","v":0},{"$f":"'TAB 1-Installation Report'!C16","v":0},{"$f":"'TAB 2-Measure Specifications'!G14","v":0},{"$f":"'TAB 2-Measure Specifications'!H14","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!M16/W7,0)","v":0},0,0,0,0,{"$f":"IFERROR('TAB 1-Installation Report'!L16/W7,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!E16/W7,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!E16*VLOOKUP('TAB 2-Measure Specifications'!D14,MeasureLife,2,FALSE)/W7,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!F16/W7,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!F16*VLOOKUP('TAB 2-Measure Specifications'!D14,MeasureLife,2,FALSE)/W7,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!J6/W7,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!J16*VLOOKUP('TAB 2-Measure Specifications'!D14,MeasureLife,2,FALSE)/W7,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!J16/W7,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!J16*VLOOKUP('TAB 2-Measure Specifications'!D14,MeasureLife,2,FALSE)/W7,0)","v":0},{"$f":"IFERROR(SUM('TAB 1-Installation Report'!G17,'TAB 1-Installation Report'!H17,'TAB 1-Installation Report'!I17,'TAB 1-Installation Report'!K17)/W7,0)","v":0},{"$f":"IFERROR(SUM('TAB 1-Installation Report'!G17,'TAB 1-Installation Report'!H17,'TAB 1-Installation Report'!I17,'TAB 1-Installation Report'!K17)*VLOOKUP('TAB 2-Measure Specifications'!D14,MeasureLife,2,FALSE)/W7,0)","v":0},0,0,{"$f":"IFERROR('TAB 2-Measure Specifications'!K14*1,1)","v":0},"Capacity/Size",{"$f":"'TAB 2-Measure Specifications'!I14","v":0},"Capacity/Size Units",{"$f":"'TAB 2-Measure Specifications'!J14","v":0},"Efficiency",{"$f":"'TAB 2-Measure Specifications'!L14","v":0},"Efficiency Units",{"$f":"'TAB 2-Measure Specifications'!M14","v":0}]
[{"$f":"'TAB 2-Measure Specifications'!D15","v":0},{"$f":"'TAB 1-Installation Report'!C17","v":0},{"$f":"'TAB 2-Measure Specifications'!G15","v":0},{"$f":"'TAB 2-Measure Specifications'!H15","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!M17/W8,0)","v":0},0,0,0,0,{"$f":"IFERROR('TAB 1-Installation Report'!L17/W8,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!E17/W8,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!E17*VLOOKUP('TAB 2-Measure Specifications'!D15,MeasureLife,2,FALSE)/W8,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!F17/W8,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!F17*VLOOKUP('TAB 2-Measure Specifications'!D15,MeasureLife,2,FALSE)/W8,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!J7/W8,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!J17*VLOOKUP('TAB 2-Measure Specifications'!D15,MeasureLife,2,FALSE)/W8,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!J17/W8,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!J17*VLOOKUP('TAB 2-Measure Specifications'!D15,MeasureLife,2,FALSE)/W8,0)","v":0},{"$f":"IFERROR(SUM('TAB 1-Installation Report'!G18,'TAB 1-Installation Report'!H18,'TAB 1-Installation Report'!I18,'TAB 1-Installation Report'!K18)/W8,0)","v":0},{"$f":"IFERROR(SUM('TAB 1-Installation Report'!G18,'TAB 1-Installation Report'!H18,'TAB 1-Installation Report'!I18,'TAB 1-Installation Report'!K18)*VLOOKUP('TAB 2-Measure Specifications'!D15,MeasureLife,2,FALSE)/W8,0)","v":0},0,0,{"$f":"IFERROR('TAB 2-Measure Specifications'!K15*1,1)","v":0},"Capacity/Size",{"$f":"'TAB 2-Measure Specifications'!I15","v":0},"Capacity/Size Units",{"$f":"'TAB 2-Measure Specifications'!J15","v":0},"Efficiency",{"$f":"'TAB 2-Measure Specifications'!L15","v":0},"Efficiency Units",{"$f":"'TAB 2-Measure Specifications'!M15","v":0}]
[{"$f":"'TAB 2-Measure Specifications'!D16","v":0},{"$f":"'TAB 1-Installation Report'!C18","v":0},{"$f":"'TAB 2-Measure Specifications'!G16","v":0},{"$f":"'TAB 2-Measure Specifications'!H16","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!M18/W9,0)","v":0},0,0,0,0,{"$f":"IFERROR('TAB 1-Installation Report'!L18/W9,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!E18/W9,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!E18*VLOOKUP('TAB 2-Measure Specifications'!D16,MeasureLife,2,FALSE)/W9,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!F18/W9,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!F18*VLOOKUP('TAB 2-Measure Specifications'!D16,MeasureLife,2,FALSE)/W9,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!J8/W9,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!J18*VLOOKUP('TAB 2-Measure Specifications'!D16,MeasureLife,2,FALSE)/W9,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!J18/W9,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!J18*VLOOKUP('TAB 2-Measure Specifications'!D16,MeasureLife,2,FALSE)/W9,0)","v":0},{"$f":"IFERROR(SUM('TAB 1-Installation Report'!G19,'TAB 1-Installation Report'!H19,'TAB 1-Installation Report'!I19,'TAB 1-Installation Report'!K19)/W9,0)","v":0},{"$f":"IFERROR(SUM('TAB 1-Installation Report'!G19,'TAB 1-Installation Report'!H19,'TAB 1-Installation Report'!I19,'TAB 1-Installation Report'!K19)*VLOOKUP('TAB 2-Measure Specifications'!D16,MeasureLife,2,FALSE)/W9,0)","v":0},0,0,{"$f":"IFERROR('TAB 2-Measure Specifications'!K16*1,1)","v":0},"Capacity/Size",{"$f":"'TAB 2-Measure Specifications'!I16","v":0},"Capacity/Size Units",{"$f":"'TAB 2-Measure Specifications'!J16","v":0},"Efficiency",{"$f":"'TAB 2-Measure Specifications'!L16","v":0},"Efficiency Units",{"$f":"'TAB 2-Measure Specifications'!M16","v":0}]
[{"$f":"'TAB 2-Measure Specifications'!D17","v":0},{"$f":"'TAB 1-Installation Report'!C19","v":0},{"$f":"'TAB 2-Measure Specifications'!G17","v":0},{"$f":"'TAB 2-Measure Specifications'!H17","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!M19/W10,0)","v":0},0,0,0,0,{"$f":"IFERROR('TAB 1-Installation Report'!L19/W10,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!E19/W10,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!E19*VLOOKUP('TAB 2-Measure Specifications'!D17,MeasureLife,2,FALSE)/W10,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!F19/W10,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!F19*VLOOKUP('TAB 2-Measure Specifications'!D17,MeasureLife,2,FALSE)/W10,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!J9/W10,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!J19*VLOOKUP('TAB 2-Measure Specifications'!D17,MeasureLife,2,FALSE)/W10,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!J19/W10,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!J19*VLOOKUP('TAB 2-Measure Specifications'!D17,MeasureLife,2,FALSE)/W10,0)","v":0},{"$f":"IFERROR(SUM('TAB 1-Installation Report'!G20,'TAB 1-Installation Report'!H20,'TAB 1-Installation Report'!I20,'TAB 1-Installation Report'!K20)/W10,0)","v":0},{"$f":"IFERROR(SUM('TAB 1-Installation Report'!G20,'TAB 1-Installation Report'!H20,'TAB 1-Installation Report'!I20,'TAB 1-Installation Report'!K20)*VLOOKUP('TAB 2-Measure Specifications'!D17,MeasureLife,2,FALSE)/W10,0)","v":0},0,0,{"$f":"IFERROR('TAB 2-Measure Specifications'!K17*1,1)","v":0},"Capacity/Size",{"$f":"'TAB 2-Measure Specifications'!I17","v":0},"Capacity/Size Units",{"$f":"'TAB 2-Measure Specifications'!J17","v":0},"Efficiency",{"$f":"'TAB 2-Measure Specifications'!L17","v":0},"Efficiency Units",{"$f":"'TAB 2-Measure Specifications'!M17","v":0}]
[{"$f":"'TAB 2-Measure Specifications'!D18","v":0},{"$f":"'TAB 1-Installation Report'!C20","v":0},{"$f":"'TAB 2-Measure Specifications'!G18","v":0},{"$f":"'TAB 2-Measure Specifications'!H18","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!M20/W11,0)","v":0},0,0,0,0,{"$f":"IFERROR('TAB 1-Installation Report'!L20/W11,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!E20/W11,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!E20*VLOOKUP('TAB 2-Measure Specifications'!D18,MeasureLife,2,FALSE)/W11,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!F20/W11,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!F20*VLOOKUP('TAB 2-Measure Specifications'!D18,MeasureLife,2,FALSE)/W11,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!J10/W11,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!J20*VLOOKUP('TAB 2-Measure Specifications'!D18,MeasureLife,2,FALSE)/W11,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!J20/W11,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!J20*VLOOKUP('TAB 2-Measure Specifications'!D18,MeasureLife,2,FALSE)/W11,0)","v":0},{"$f":"IFERROR(SUM('TAB 1-Installation Report'!G21,'TAB 1-Installation Report'!H21,'TAB 1-Installation Report'!I21,'TAB 1-Installation Report'!K21)/W11,0)","v":0},{"$f":"IFERROR(SUM('TAB 1-Installation Report'!G21,'TAB 1-Installation Report'!H21,'TAB 1-Installation Report'!I21,'TAB 1-Installation Report'!K21)*VLOOKUP('TAB 2-Measure Specifications'!D18,MeasureLife,2,FALSE)/W11,0)","v":0},0,0,{"$f":"IFERROR('TAB 2-Measure Specifications'!K18*1,1)","v":0},"Capacity/Size",{"$f":"'TAB 2-Measure Specifications'!I18","v":0},"Capacity/Size Units",{"$f":"'TAB 2-Measure Specifications'!J18","v":0},"Efficiency",{"$f":"'TAB 2-Measure Specifications'!L18","v":0},"Efficiency Units",{"$f":"'TAB 2-Measure Specifications'!M18","v":0}]
[{"$f":"'TAB 2-Measure Specifications'!D19","v":0},{"$f":"'TAB 1-Installation Report'!C21","v":0},{"$f":"'TAB 2-Measure Specifications'!G19","v":0},{"$f":"'TAB 2-Measure Specifications'!H19","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!M21/W12,0)","v":0},0,0,0,0,{"$f":"IFERROR('TAB 1-Installation Report'!L21/W12,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!E21/W12,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!E21*VLOOKUP('TAB 2-Measure Specifications'!D19,MeasureLife,2,FALSE)/W12,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!F21/W12,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!F21*VLOOKUP('TAB 2-Measure Specifications'!D19,MeasureLife,2,FALSE)/W12,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!J11/W12,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!J21*VLOOKUP('TAB 2-Measure Specifications'!D19,MeasureLife,2,FALSE)/W12,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!J21/W12,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!J21*VLOOKUP('TAB 2-Measure Specifications'!D19,MeasureLife,2,FALSE)/W12,0)","v":0},{"$f":"IFERROR(SUM('TAB 1-Installation Report'!G22,'TAB 1-Installation Report'!H22,'TAB 1-Installation Report'!I22,'TAB 1-Installation Report'!K22)/W12,0)","v":0},{"$f":"IFERROR(SUM('TAB 1-Installation Report'!G22,'TAB 1-Installation Report'!H22,'TAB 1-Installation Report'!I22,'TAB 1-Installation Report'!K22)*VLOOKUP('TAB 2-Measure Specifications'!D19,MeasureLife,2,FALSE)/W12,0)","v":0},0,0,{"$f":"IFERROR('TAB 2-Measure Specifications'!K19*1,1)","v":0},"Capacity/Size",{"$f":"'TAB 2-Measure Specifications'!I19","v":0},"Capacity/Size Units",{"$f":"'TAB 2-Measure Specifications'!J19","v":0},"Efficiency",{"$f":"'TAB 2-Measure Specifications'!L19","v":0},"Efficiency Units",{"$f":"'TAB 2-Measure Specifications'!M19","v":0}]
[{"$f":"'TAB 2-Measure Specifications'!D20","v":0},{"$f":"'TAB 1-Installation Report'!C22","v":0},{"$f":"'TAB 2-Measure Specifications'!G20","v":0},{"$f":"'TAB 2-Measure Specifications'!H20","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!M22/W13,0)","v":0},0,0,0,0,{"$f":"IFERROR('TAB 1-Installation Report'!L22/W13,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!E22/W13,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!E22*VLOOKUP('TAB 2-Measure Specifications'!D20,MeasureLife,2,FALSE)/W13,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!F22/W13,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!F22*VLOOKUP('TAB 2-Measure Specifications'!D20,MeasureLife,2,FALSE)/W13,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!J12/W13,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!J22*VLOOKUP('TAB 2-Measure Specifications'!D20,MeasureLife,2,FALSE)/W13,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!J22/W13,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!J22*VLOOKUP('TAB 2-Measure Specifications'!D20,MeasureLife,2,FALSE)/W13,0)","v":0},{"$f":"IFERROR(SUM('TAB 1-Installation Report'!G23,'TAB 1-Installation Report'!H23,'TAB 1-Installation Report'!I23,'TAB 1-Installation Report'!K23)/W13,0)","v":0},{"$f":"IFERROR(SUM('TAB 1-Installation Report'!G23,'TAB 1-Installation Report'!H23,'TAB 1-Installation Report'!I23,'TAB 1-Installation Report'!K23)*VLOOKUP('TAB 2-Measure Specifications'!D20,MeasureLife,2,FALSE)/W13,0)","v":0},0,0,{"$f":"IFERROR('TAB 2-Measure Specifications'!K20*1,1)","v":0},"Capacity/Size",{"$f":"'TAB 2-Measure Specifications'!I20","v":0},"Capacity/Size Units",{"$f":"'TAB 2-Measure Specifications'!J20","v":0},"Efficiency",{"$f":"'TAB 2-Measure Specifications'!L20","v":0},"Efficiency Units",{"$f":"'TAB 2-Measure Specifications'!M20","v":0}]
[{"$f":"'TAB 2-Measure Specifications'!D21","v":0},{"$f":"'TAB 1-Installation Report'!C23","v":0},{"$f":"'TAB 2-Measure Specifications'!G21","v":0},{"$f":"'TAB 2-Measure Specifications'!H21","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!M23/W14,0)","v":0},0,0,0,0,{"$f":"IFERROR('TAB 1-Installation Report'!L23/W14,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!E23/W14,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!E23*VLOOKUP('TAB 2-Measure Specifications'!D21,MeasureLife,2,FALSE)/W14,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!F23/W14,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!F23*VLOOKUP('TAB 2-Measure Specifications'!D21,MeasureLife,2,FALSE)/W14,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!J13/W14,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!J23*VLOOKUP('TAB 2-Measure Specifications'!D21,MeasureLife,2,FALSE)/W14,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!J23/W14,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!J23*VLOOKUP('TAB 2-Measure Specifications'!D21,MeasureLife,2,FALSE)/W14,0)","v":0},{"$f":"IFERROR(SUM('TAB 1-Installation Report'!G24,'TAB 1-Installation Report'!H24,'TAB 1-Installation Report'!I24,'TAB 1-Installation Report'!K24)/W14,0)","v":0},{"$f":"IFERROR(SUM('TAB 1-Installation Report'!G24,'TAB 1-Installation Report'!H24,'TAB 1-Installation Report'!I24,'TAB 1-Installation Report'!K24)*VLOOKUP('TAB 2-Measure Specifications'!D21,MeasureLife,2,FALSE)/W14,0)","v":0},0,0,{"$f":"IFERROR('TAB 2-Measure Specifications'!K21*1,1)","v":0},"Capacity/Size",{"$f":"'TAB 2-Measure Specifications'!I21","v":0},"Capacity/Size Units",{"$f":"'TAB 2-Measure Specifications'!J21","v":0},"Efficiency",{"$f":"'TAB 2-Measure Specifications'!L21","v":0},"Efficiency Units",{"$f":"'TAB 2-Measure Specifications'!M21","v":0}]
[{"$f":"'TAB 2-Measure Specifications'!D22","v":0},{"$f":"'TAB 1-Installation Report'!C24","v":0},{"$f":"'TAB 2-Measure Specifications'!G22","v":0},{"$f":"'TAB 2-Measure Specifications'!H22","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!M24/W15,0)","v":0},0,0,0,0,{"$f":"IFERROR('TAB 1-Installation Report'!L24/W15,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!E24/W15,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!E24*VLOOKUP('TAB 2-Measure Specifications'!D22,MeasureLife,2,FALSE)/W15,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!F24/W15,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!F24*VLOOKUP('TAB 2-Measure Specifications'!D22,MeasureLife,2,FALSE)/W15,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!J14/W15,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!J24*VLOOKUP('TAB 2-Measure Specifications'!D22,MeasureLife,2,FALSE)/W15,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!J24/W15,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!J24*VLOOKUP('TAB 2-Measure Specifications'!D22,MeasureLife,2,FALSE)/W15,0)","v":0},{"$f":"IFERROR(SUM('TAB 1-Installation Report'!G25,'TAB 1-Installation Report'!H25,'TAB 1-Installation Report'!I25,'TAB 1-Installation Report'!K25)/W15,0)","v":0},{"$f":"IFERROR(SUM('TAB 1-Installation Report'!G25,'TAB 1-Installation Report'!H25,'TAB 1-Installation Report'!I25,'TAB 1-Installation Report'!K25)*VLOOKUP('TAB 2-Measure Specifications'!D22,MeasureLife,2,FALSE)/W15,0)","v":0},0,0,{"$f":"IFERROR('TAB 2-Measure Specifications'!K22*1,1)","v":0},"Capacity/Size",{"$f":"'TAB 2-Measure Specifications'!I22","v":0},"Capacity/Size Units",{"$f":"'TAB 2-Measure Specifications'!J22","v":0},"Efficiency",{"$f":"'TAB 2-Measure Specifications'!L22","v":0},"Efficiency Units",{"$f":"'TAB 2-Measure Specifications'!M22","v":0}]
[{"$f":"'TAB 2-Measure Specifications'!D23","v":0},{"$f":"'TAB 1-Installation Report'!C25","v":0},{"$f":"'TAB 2-Measure Specifications'!G23","v":0},{"$f":"'TAB 2-Measure Specifications'!H23","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!M25/W16,0)","v":0},0,0,0,0,{"$f":"IFERROR('TAB 1-Installation Report'!L25/W16,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!E25/W16,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!E25*VLOOKUP('TAB 2-Measure Specifications'!D23,MeasureLife,2,FALSE)/W16,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!F25/W16,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!F25*VLOOKUP('TAB 2-Measure Specifications'!D23,MeasureLife,2,FALSE)/W16,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!J15/W16,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!J25*VLOOKUP('TAB 2-Measure Specifications'!D23,MeasureLife,2,FALSE)/W16,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!J25/W16,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!J25*VLOOKUP('TAB 2-Measure Specifications'!D23,MeasureLife,2,FALSE)/W16,0)","v":0},{"$f":"IFERROR(SUM('TAB 1-Installation Report'!G26,'TAB 1-Installation Report'!H26,'TAB 1-Installation Report'!I26,'TAB 1-Installation Report'!K26)/W16,0)","v":0},{"$f":"IFERROR(SUM('TAB 1-Installation Report'!G26,'TAB 1-Installation Report'!H26,'TAB 1-Installation Report'!I26,'TAB 1-Installation Report'!K26)*VLOOKUP('TAB 2-Measure Specifications'!D23,MeasureLife,2,FALSE)/W16,0)","v":0},0,0,{"$f":"IFERROR('TAB 2-Measure Specifications'!K23*1,1)","v":0},"Capacity/Size",{"$f":"'TAB 2-Measure Specifications'!I23","v":0},"Capacity/Size Units",{"$f":"'TAB 2-Measure Specifications'!J23","v":0},"Efficiency",{"$f":"'TAB 2-Measure Specifications'!L23","v":0},"Efficiency Units",{"$f":"'TAB 2-Measure Specifications'!M23","v":0}]
[{"$f":"'TAB 2-Measure Specifications'!D24","v":0},{"$f":"'TAB 1-Installation Report'!C26","v":0},{"$f":"'TAB 2-Measure Specifications'!G24","v":0},{"$f":"'TAB 2-Measure Specifications'!H24","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!M26/W17,0)","v":0},0,0,0,0,{"$f":"IFERROR('TAB 1-Installation Report'!L26/W17,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!E26/W17,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!E26*VLOOKUP('TAB 2-Measure Specifications'!D24,MeasureLife,2,FALSE)/W17,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!F26/W17,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!F26*VLOOKUP('TAB 2-Measure Specifications'!D24,MeasureLife,2,FALSE)/W17,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!J16/W17,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!J26*VLOOKUP('TAB 2-Measure Specifications'!D24,MeasureLife,2,FALSE)/W17,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!J26/W17,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!J26*VLOOKUP('TAB 2-Measure Specifications'!D24,MeasureLife,2,FALSE)/W17,0)","v":0},{"$f":"IFERROR(SUM('TAB 1-Installation Report'!G27,'TAB 1-Installation Report'!H27,'TAB 1-Installation Report'!I27,'TAB 1-Installation Report'!K27)/W17,0)","v":0},{"$f":"IFERROR(SUM('TAB 1-Installation Report'!G27,'TAB 1-Installation Report'!H27,'TAB 1-Installation Report'!I27,'TAB 1-Installation Report'!K27)*VLOOKUP('TAB 2-Measure Specifications'!D24,MeasureLife,2,FALSE)/W17,0)","v":0},0,0,{"$f":"IFERROR('TAB 2-Measure Specifications'!K24*1,1)","v":0},"Capacity/Size",{"$f":"'TAB 2-Measure Specifications'!I24","v":0},"Capacity/Size Units",{"$f":"'TAB 2-Measure Specifications'!J24","v":0},"Efficiency",{"$f":"'TAB 2-Measure Specifications'!L24","v":0},"Efficiency Units",{"$f":"'TAB 2-Measure Specifications'!M24","v":0}]
[{"$f":"'TAB 2-Measure Specifications'!D25","v":0},{"$f":"'TAB 1-Installation Report'!C27","v":0},{"$f":"'TAB 2-Measure Specifications'!G25","v":0},{"$f":"'TAB 2-Measure Specifications'!H25","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!M27/W18,0)","v":0},0,0,0,0,{"$f":"IFERROR('TAB 1-Installation Report'!L27/W18,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!E27/W18,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!E27*VLOOKUP('TAB 2-Measure Specifications'!D25,MeasureLife,2,FALSE)/W18,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!F27/W18,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!F27*VLOOKUP('TAB 2-Measure Specifications'!D25,MeasureLife,2,FALSE)/W18,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!J17/W18,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!J27*VLOOKUP('TAB 2-Measure Specifications'!D25,MeasureLife,2,FALSE)/W18,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!J27/W18,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!J27*VLOOKUP('TAB 2-Measure Specifications'!D25,MeasureLife,2,FALSE)/W18,0)","v":0},{"$f":"IFERROR(SUM('TAB 1-Installation Report'!G28,'TAB 1-Installation Report'!H28,'TAB 1-Installation Report'!I28,'TAB 1-Installation Report'!K28)/W18,0)","v":0},{"$f":"IFERROR(SUM('TAB 1-Installation Report'!G28,'TAB 1-Installation Report'!H28,'TAB 1-Installation Report'!I28,'TAB 1-Installation Report'!K28)*VLOOKUP('TAB 2-Measure Specifications'!D25,MeasureLife,2,FALSE)/W18,0)","v":0},0,0,{"$f":"IFERROR('TAB 2-Measure Specifications'!K25*1,1)","v":0},"Capacity/Size",{"$f":"'TAB 2-Measure Specifications'!I25","v":0},"Capacity/Size Units",{"$f":"'TAB 2-Measure Specifications'!J25","v":0},"Efficiency",{"$f":"'TAB 2-Measure Specifications'!L25","v":0},"Efficiency Units",{"$f":"'TAB 2-Measure Specifications'!M25","v":0}]
[{"$f":"'TAB 2-Measure Specifications'!D26","v":0},{"$f":"'TAB 1-Installation Report'!C28","v":0},{"$f":"'TAB 2-Measure Specifications'!G26","v":0},{"$f":"'TAB 2-Measure Specifications'!H26","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!M28/W19,0)","v":0},0,0,0,0,{"$f":"IFERROR('TAB 1-Installation Report'!L28/W19,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!E28/W19,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!E28*VLOOKUP('TAB 2-Measure Specifications'!D26,MeasureLife,2,FALSE)/W19,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!F28/W19,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!F28*VLOOKUP('TAB 2-Measure Specifications'!D26,MeasureLife,2,FALSE)/W19,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!J18/W19,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!J28*VLOOKUP('TAB 2-Measure Specifications'!D26,MeasureLife,2,FALSE)/W19,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!J28/W19,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!J28*VLOOKUP('TAB 2-Measure Specifications'!D26,MeasureLife,2,FALSE)/W19,0)","v":0},{"$f":"IFERROR(SUM('TAB 1-Installation Report'!G29,'TAB 1-Installation Report'!H29,'TAB 1-Installation Report'!I29,'TAB 1-Installation Report'!K29)/W19,0)","v":0},{"$f":"IFERROR(SUM('TAB 1-Installation Report'!G29,'TAB 1-Installation Report'!H29,'TAB 1-Installation Report'!I29,'TAB 1-Installation Report'!K29)*VLOOKUP('TAB 2-Measure Specifications'!D26,MeasureLife,2,FALSE)/W19,0)","v":0},0,0,{"$f":"IFERROR('TAB 2-Measure Specifications'!K26*1,1)","v":0},"Capacity/Size",{"$f":"'TAB 2-Measure Specifications'!I26","v":0},"Capacity/Size Units",{"$f":"'TAB 2-Measure Specifications'!J26","v":0},"Efficiency",{"$f":"'TAB 2-Measure Specifications'!L26","v":0},"Efficiency Units",{"$f":"'TAB 2-Measure Specifications'!M26","v":0}]
[{"$f":"'TAB 2-Measure Specifications'!D27","v":0},{"$f":"'TAB 1-Installation Report'!C29","v":0},{"$f":"'TAB 2-Measure Specifications'!G27","v":0},{"$f":"'TAB 2-Measure Specifications'!H27","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!M29/W20,0)","v":0},0,0,0,0,{"$f":"IFERROR('TAB 1-Installation Report'!L29/W20,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!E29/W20,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!E29*VLOOKUP('TAB 2-Measure Specifications'!D27,MeasureLife,2,FALSE)/W20,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!F29/W20,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!F29*VLOOKUP('TAB 2-Measure Specifications'!D27,MeasureLife,2,FALSE)/W20,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!J19/W20,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!J29*VLOOKUP('TAB 2-Measure Specifications'!D27,MeasureLife,2,FALSE)/W20,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!J29/W20,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!J29*VLOOKUP('TAB 2-Measure Specifications'!D27,MeasureLife,2,FALSE)/W20,0)","v":0},{"$f":"IFERROR(SUM('TAB 1-Installation Report'!G30,'TAB 1-Installation Report'!H30,'TAB 1-Installation Report'!I30,'TAB 1-Installation Report'!K30)/W20,0)","v":0},{"$f":"IFERROR(SUM('TAB 1-Installation Report'!G30,'TAB 1-Installation Report'!H30,'TAB 1-Installation Report'!I30,'TAB 1-Installation Report'!K30)*VLOOKUP('TAB 2-Measure Specifications'!D27,MeasureLife,2,FALSE)/W20,0)","v":0},0,0,{"$f":"IFERROR('TAB 2-Measure Specifications'!K27*1,1)","v":0},"Capacity/Size",{"$f":"'TAB 2-Measure Specifications'!I27","v":0},"Capacity/Size Units",{"$f":"'TAB 2-Measure Specifications'!J27","v":0},"Efficiency",{"$f":"'TAB 2-Measure Specifications'!L27","v":0},"Efficiency Units",{"$f":"'TAB 2-Measure Specifications'!M27","v":0}]
[{"$f":"'TAB 2-Measure Specifications'!D28","v":0},{"$f":"'TAB 1-Installation Report'!C30","v":0},{"$f":"'TAB 2-Measure Specifications'!G28","v":0},{"$f":"'TAB 2-Measure Specifications'!H28","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!M30/W21,0)","v":0},0,0,0,0,{"$f":"IFERROR('TAB 1-Installation Report'!L30/W21,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!E30/W21,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!E30*VLOOKUP('TAB 2-Measure Specifications'!D28,MeasureLife,2,FALSE)/W21,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!F30/W21,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!F30*VLOOKUP('TAB 2-Measure Specifications'!D28,MeasureLife,2,FALSE)/W21,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!J20/W21,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!J30*VLOOKUP('TAB 2-Measure Specifications'!D28,MeasureLife,2,FALSE)/W21,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!J30/W21,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!J30*VLOOKUP('TAB 2-Measure Specifications'!D28,MeasureLife,2,FALSE)/W21,0)","v":0},{"$f":"IFERROR(SUM('TAB 1-Installation Report'!G31,'TAB 1-Installation Report'!H31,'TAB 1-Installation Report'!I31,'TAB 1-Installation Report'!K31)/W21,0)","v":0},{"$f":"IFERROR(SUM('TAB 1-Installation Report'!G31,'TAB 1-Installation Report'!H31,'TAB 1-Installation Report'!I31,'TAB 1-Installation Report'!K31)*VLOOKUP('TAB 2-Measure Specifications'!D28,MeasureLife,2,FALSE)/W21,0)","v":0},0,0,{"$f":"IFERROR('TAB 2-Measure Specifications'!K28*1,1)","v":0},"Capacity/Size",{"$f":"'TAB 2-Measure Specifications'!I28","v":0},"Capacity/Size Units",{"$f":"'TAB 2-Measure Specifications'!J28","v":0},"Efficiency",{"$f":"'TAB 2-Measure Specifications'!L28","v":0},"Efficiency Units",{"$f":"'TAB 2-Measure Specifications'!M28","v":0}]
[{"$f":"'TAB 2-Measure Specifications'!D29","v":0},{"$f":"'TAB 1-Installation Report'!C31","v":0},{"$f":"'TAB 2-Measure Specifications'!G29","v":0},{"$f":"'TAB 2-Measure Specifications'!H29","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!M31/W22,0)","v":0},0,0,0,0,{"$f":"IFERROR('TAB 1-Installation Report'!L31/W22,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!E31/W22,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!E31*VLOOKUP('TAB 2-Measure Specifications'!D29,MeasureLife,2,FALSE)/W22,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!F31/W22,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!F31*VLOOKUP('TAB 2-Measure Specifications'!D29,MeasureLife,2,FALSE)/W22,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!J21/W22,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!J31*VLOOKUP('TAB 2-Measure Specifications'!D29,MeasureLife,2,FALSE)/W22,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!J31/W22,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!J31*VLOOKUP('TAB 2-Measure Specifications'!D29,MeasureLife,2,FALSE)/W22,0)","v":0},{"$f":"IFERROR(SUM('TAB 1-Installation Report'!G32,'TAB 1-Installation Report'!H32,'TAB 1-Installation Report'!I32,'TAB 1-Installation Report'!K32)/W22,0)","v":0},{"$f":"IFERROR(SUM('TAB 1-Installation Report'!G32,'TAB 1-Installation Report'!H32,'TAB 1-Installation Report'!I32,'TAB 1-Installation Report'!K32)*VLOOKUP('TAB 2-Measure Specifications'!D29,MeasureLife,2,FALSE)/W22,0)","v":0},0,0,{"$f":"IFERROR('TAB 2-Measure Specifications'!K29*1,1)","v":0},"Capacity/Size",{"$f":"'TAB 2-Measure Specifications'!I29","v":0},"Capacity/Size Units",{"$f":"'TAB 2-Measure Specifications'!J29","v":0},"Efficiency",{"$f":"'TAB 2-Measure Specifications'!L29","v":0},"Efficiency Units",{"$f":"'TAB 2-Measure Specifications'!M29","v":0}]
[{"$f":"'TAB 2-Measure Specifications'!D30","v":0},{"$f":"'TAB 1-Installation Report'!C32","v":0},{"$f":"'TAB 2-Measure Specifications'!G30","v":0},{"$f":"'TAB 2-Measure Specifications'!H30","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!M32/W23,0)","v":0},0,0,0,0,{"$f":"IFERROR('TAB 1-Installation Report'!L32/W23,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!E32/W23,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!E32*VLOOKUP('TAB 2-Measure Specifications'!D30,MeasureLife,2,FALSE)/W23,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!F32/W23,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!F32*VLOOKUP('TAB 2-Measure Specifications'!D30,MeasureLife,2,FALSE)/W23,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!J22/W23,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!J32*VLOOKUP('TAB 2-Measure Specifications'!D30,MeasureLife,2,FALSE)/W23,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!J32/W23,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!J32*VLOOKUP('TAB 2-Measure Specifications'!D30,MeasureLife,2,FALSE)/W23,0)","v":0},{"$f":"IFERROR(SUM('TAB 1-Installation Report'!G33,'TAB 1-Installation Report'!H33,'TAB 1-Installation Report'!I33,'TAB 1-Installation Report'!K33)/W23,0)","v":0},{"$f":"IFERROR(SUM('TAB 1-Installation Report'!G33,'TAB 1-Installation Report'!H33,'TAB 1-Installation Report'!I33,'TAB 1-Installation Report'!K33)*VLOOKUP('TAB 2-Measure Specifications'!D30,MeasureLife,2,FALSE)/W23,0)","v":0},0,0,{"$f":"IFERROR('TAB 2-Measure Specifications'!K30*1,1)","v":0},"Capacity/Size",{"$f":"'TAB 2-Measure Specifications'!I30","v":0},"Capacity/Size Units",{"$f":"'TAB 2-Measure Specifications'!J30","v":0},"Efficiency",{"$f":"'TAB 2-Measure Specifications'!L30","v":0},"Efficiency Units",{"$f":"'TAB 2-Measure Specifications'!M30","v":0}]
[{"$f":"'TAB 2-Measure Specifications'!D31","v":0},{"$f":"'TAB 1-Installation Report'!C33","v":0},{"$f":"'TAB 2-Measure Specifications'!G31","v":0},{"$f":"'TAB 2-Measure Specifications'!H31","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!M33/W24,0)","v":0},0,0,0,0,{"$f":"IFERROR('TAB 1-Installation Report'!L33/W24,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!E33/W24,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!E33*VLOOKUP('TAB 2-Measure Specifications'!D31,MeasureLife,2,FALSE)/W24,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!F33/W24,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!F33*VLOOKUP('TAB 2-Measure Specifications'!D31,MeasureLife,2,FALSE)/W24,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!J23/W24,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!J33*VLOOKUP('TAB 2-Measure Specifications'!D31,MeasureLife,2,FALSE)/W24,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!J33/W24,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!J33*VLOOKUP('TAB 2-Measure Specifications'!D31,MeasureLife,2,FALSE)/W24,0)","v":0},{"$f":"IFERROR(SUM('TAB 1-Installation Report'!G34,'TAB 1-Installation Report'!H34,'TAB 1-Installation Report'!I34,'TAB 1-Installation Report'!K34)/W24,0)","v":0},{"$f":"IFERROR(SUM('TAB 1-Installation Report'!G34,'TAB 1-Installation Report'!H34,'TAB 1-Installation Report'!I34,'TAB 1-Installation Report'!K34)*VLOOKUP('TAB 2-Measure Specifications'!D31,MeasureLife,2,FALSE)/W24,0)","v":0},0,0,{"$f":"IFERROR('TAB 2-Measure Specifications'!K31*1,1)","v":0},"Capacity/Size",{"$f":"'TAB 2-Measure Specifications'!I31","v":0},"Capacity/Size Units",{"$f":"'TAB 2-Measure Specifications'!J31","v":0},"Efficiency",{"$f":"'TAB 2-Measure Specifications'!L31","v":0},"Efficiency Units",{"$f":"'TAB 2-Measure Specifications'!M31","v":0}]
[{"$f":"'TAB 2-Measure Specifications'!D32","v":0},{"$f":"'TAB 1-Installation Report'!C34","v":0},{"$f":"'TAB 2-Measure Specifications'!G32","v":0},{"$f":"'TAB 2-Measure Specifications'!H32","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!M34/W25,0)","v":0},0,0,0,0,{"$f":"IFERROR('TAB 1-Installation Report'!L34/W25,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!E34/W25,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!E34*VLOOKUP('TAB 2-Measure Specifications'!D32,MeasureLife,2,FALSE)/W25,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!F34/W25,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!F34*VLOOKUP('TAB 2-Measure Specifications'!D32,MeasureLife,2,FALSE)/W25,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!J24/W25,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!J34*VLOOKUP('TAB 2-Measure Specifications'!D32,MeasureLife,2,FALSE)/W25,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!J34/W25,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!J34*VLOOKUP('TAB 2-Measure Specifications'!D32,MeasureLife,2,FALSE)/W25,0)","v":0},{"$f":"IFERROR(SUM('TAB 1-Installation Report'!G35,'TAB 1-Installation Report'!H35,'TAB 1-Installation Report'!I35,'TAB 1-Installation Report'!K35)/W25,0)","v":0},{"$f":"IFERROR(SUM('TAB 1-Installation Report'!G35,'TAB 1-Installation Report'!H35,'TAB 1-Installation Report'!I35,'TAB 1-Installation Report'!K35)*VLOOKUP('TAB 2-Measure Specifications'!D32,MeasureLife,2,FALSE)/W25,0)","v":0},0,0,{"$f":"IFERROR('TAB 2-Measure Specifications'!K32*1,1)","v":0},"Capacity/Size",{"$f":"'TAB 2-Measure Specifications'!I32","v":0},"Capacity/Size Units",{"$f":"'TAB 2-Measure Specifications'!J32","v":0},"Efficiency",{"$f":"'TAB 2-Measure Specifications'!L32","v":0},"Efficiency Units",{"$f":"'TAB 2-Measure Specifications'!M32","v":0}]
[{"$f":"'TAB 2-Measure Specifications'!D33","v":0},{"$f":"'TAB 1-Installation Report'!C35","v":0},{"$f":"'TAB 2-Measure Specifications'!G33","v":0},{"$f":"'TAB 2-Measure Specifications'!H33","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!M35/W26,0)","v":0},0,0,0,0,{"$f":"IFERROR('TAB 1-Installation Report'!L35/W26,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!E35/W26,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!E35*VLOOKUP('TAB 2-Measure Specifications'!D33,MeasureLife,2,FALSE)/W26,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!F35/W26,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!F35*VLOOKUP('TAB 2-Measure Specifications'!D33,MeasureLife,2,FALSE)/W26,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!J25/W26,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!J35*VLOOKUP('TAB 2-Measure Specifications'!D33,MeasureLife,2,FALSE)/W26,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!J35/W26,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!J35*VLOOKUP('TAB 2-Measure Specifications'!D33,MeasureLife,2,FALSE)/W26,0)","v":0},{"$f":"IFERROR(SUM('TAB 1-Installation Report'!G36,'TAB 1-Installation Report'!H36,'TAB 1-Installation Report'!I36,'TAB 1-Installation Report'!K36)/W26,0)","v":0},{"$f":"IFERROR(SUM('TAB 1-Installation Report'!G36,'TAB 1-Installation Report'!H36,'TAB 1-Installation Report'!I36,'TAB 1-Installation Report'!K36)*VLOOKUP('TAB 2-Measure Specifications'!D33,MeasureLife,2,FALSE)/W26,0)","v":0},0,0,{"$f":"IFERROR('TAB 2-Measure Specifications'!K33*1,1)","v":0},"Capacity/Size",{"$f":"'TAB 2-Measure Specifications'!I33","v":0},"Capacity/Size Units",{"$f":"'TAB 2-Measure Specifications'!J33","v":0},"Efficiency",{"$f":"'TAB 2-Measure Specifications'!L33","v":0},"Efficiency Units",{"$f":"'TAB 2-Measure Specifications'!M33","v":0}]
[{"$f":"'TAB 2-Measure Specifications'!D34","v":0},{"$f":"'TAB 1-Installation Report'!C36","v":0},{"$f":"'TAB 2-Measure Specifications'!G34","v":0},{"$f":"'TAB 2-Measure Specifications'!H34","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!M36/W27,0)","v":0},0,0,0,0,{"$f":"IFERROR('TAB 1-Installation Report'!L36/W27,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!E36/W27,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!E36*VLOOKUP('TAB 2-Measure Specifications'!D34,MeasureLife,2,FALSE)/W27,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!F36/W27,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!F36*VLOOKUP('TAB 2-Measure Specifications'!D34,MeasureLife,2,FALSE)/W27,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!J26/W27,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!J36*VLOOKUP('TAB 2-Measure Specifications'!D34,MeasureLife,2,FALSE)/W27,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!J36/W27,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!J36*VLOOKUP('TAB 2-Measure Specifications'!D34,MeasureLife,2,FALSE)/W27,0)","v":0},{"$f":"IFERROR(SUM('TAB 1-Installation Report'!G37,'TAB 1-Installation Report'!H37,'TAB 1-Installation Report'!I37,'TAB 1-Installation Report'!K37)/W27,0)","v":0},{"$f":"IFERROR(SUM('TAB 1-Installation Report'!G37,'TAB 1-Installation Report'!H37,'TAB 1-Installation Report'!I37,'TAB 1-Installation Report'!K37)*VLOOKUP('TAB 2-Measure Specifications'!D34,MeasureLife,2,FALSE)/W27,0)","v":0},0,0,{"$f":"IFERROR('TAB 2-Measure Specifications'!K34*1,1)","v":0},"Capacity/Size",{"$f":"'TAB 2-Measure Specifications'!I34","v":0},"Capacity/Size Units",{"$f":"'TAB 2-Measure Specifications'!J34","v":0},"Efficiency",{"$f":"'TAB 2-Measure Specifications'!L34","v":0},"Efficiency Units",{"$f":"'TAB 2-Measure Specifications'!M34","v":0}]
[{"$f":"'TAB 2-Measure Specifications'!D35","v":0},{"$f":"'TAB 1-Installation Report'!C37","v":0},{"$f":"'TAB 2-Measure Specifications'!G35","v":0},{"$f":"'TAB 2-Measure Specifications'!H35","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!M37/W28,0)","v":0},0,0,0,0,{"$f":"IFERROR('TAB 1-Installation Report'!L37/W28,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!E37/W28,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!E37*VLOOKUP('TAB 2-Measure Specifications'!D35,MeasureLife,2,FALSE)/W28,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!F37/W28,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!F37*VLOOKUP('TAB 2-Measure Specifications'!D35,MeasureLife,2,FALSE)/W28,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!J27/W28,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!J37*VLOOKUP('TAB 2-Measure Specifications'!D35,MeasureLife,2,FALSE)/W28,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!J37/W28,0)","v":0},{"$f":"IFERROR('TAB 1-Installation Report'!J37*VLOOKUP('TAB 2-Measure Specifications'!D35,MeasureLife,2,FALSE)/W28,0)","v":0},{"$f":"IFERROR(SUM('TAB 1-Installation Report'!G38,'TAB 1-Installation Report'!H38,'TAB 1-Installation Report'!I38,'TAB 1-Installation Report'!K38)/W28,0)","v":0},{"$f":"IFERROR(SUM('TAB 1-Installation Report'!G38,'TAB 1-Installation Report'!H38,'TAB 1-Installation Report'!I38,'TAB 1-Installation Report'!K38)*VLOOKUP('TAB 2-Measure Specifications'!D35,MeasureLife,2,FALSE)/W28,0)","v":0},0,0,{"$f":"IFERROR('TAB 2-Measure Specifications'!K35*1,1)","v":0},"Capacity/Size",{"$f":"'TAB 2-Measure Specifications'!I35","v":0},"Capacity/Size Units",{"$f":"'TAB 2-Measure Specifications'!J35","v":0},"Efficiency",{"$f":"'TAB 2-Measure Specifications'!L35","v":0},"Efficiency Units",{"$f":"'TAB 2-Measure Specifications'!M35","v":0}]

{"sheet":"Export","index":4,"n_rows":3,"n_cols":50,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["Pay For Performance - Existing Buildings: 2016"]
["Project Name",0,"Project ID",0,"Street Address",0,"Project SF",0,"CM Fees",0,"Partner Fees",0,"Total Measure Cost",0,"Committed Incentive #1",0,"Paid Incentive #1",0,"Committed Incentive #2",0,"Paid Incentive #2",0,"Committed Incentive #3",0,"Paid Incentive #3",0,"Annual Energy Cost",0,"Annual Cost Savings",0,"Internal Rate of Return (IRR)",0,"Life Cycle Savings",0,"Simple Payback (yrs)",0,"Simple Payback with NJCEP Incentive (yrs)",0,"Peak kW",0,"Total % Savings",0,"% Elec",0,"% Gas",0,"% Oil or Propane",0,"% Other",0]
["Measure Name","Measure Description","Manufacturer","Model","Installation Cost per Unit","Annual Energy Cost Savings per Unit","Incentive Per Unit","Simple Payback w/o Incentives","Simple Payback w/ Incentives","Peak Demand Reduction per Unit","Annual Electricity Savings per Unit","Lifetime Electricity Savings per Unit","Annual Gas Savings per Unit","Lifetime Gas Savings per Unit","Annual Propane Savings per Unit","Lifetime Propane Savings per Unit","Annual Oil Savings per Unit","Lifetime Oil Savings per Unit","Other Energy Savings MMBTU per Unit","Other Lifetime Energy Savings MMBTU per Unit","CO2e Emissions Reduction per Unit (lbs)","Quantity Committed","Quantity Installed"]