{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Step 1 - Project Info","Dropdown","Direct Install - Unit Matrix","Air Sealing","Low Flow DHW","Dwelling Unit Lighting","Common and Exterior Lighting","Lighting Summary","Insulation","Window Replacements","Refrigerator Replacements","HVAC","Smart Thermostats","Custom Measure"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":1,"defined_names":27,"comments":2,"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":"Step 1 - Project Info","index":0,"n_rows":53,"n_cols":4,"rows_kept":53,"cut":false,"hidden":false,"merged":[[41,0,41,1],[0,1,0,2],[1,1,1,2]]}
["Multifamily Initiative Project Fill Out Form"]
["Rev. 4/11/2022","PROJECT INFO"]
[null,"Property Name"]
[null,"Property Street Number"]
[null,"Property Street"]
[null,"Property Street Address Line 2"]
[null,"Property City"]
[null,"Property Zip Code"]
[null,"Customer Electric (Master) Account Number (required)"]
[null,"Customer Gas (Master) Account Number (required)"]
[null,"Customer Contact First Name (For LOA to be addressed to)"]
[null,"Customer Contact Last Name (For LOA to be addressed to)"]
[null,"Customer Contact Title"]
[null,"Customer Company Name"]
[null,"Customer Contact Phone Number"]
[null,"Customer E-mail Address"]
[null,"Customer Street Number"]
[null,"Customer Street"]
[null,"Customer City"]
[null,"Customer State"]
[null,"Customer Zip Code"]
[null,"Contractor Company Name"]
[null,"Contractor Contact Person"]
[null,"Contractor Project Contact Phone Number"]
[null,"Contractor Project Contact E-mail Address"]
[null,"Contractor Company Address"]
[null,"Estimated project completion date (LOA Expiration date)?"]
[null,"Will incentive be paid to Customer or Contractor?"]
[null,"Incentive check payable to: Name of company and company representative"]
[null,"Incentive check payee: company address"]
[null,"Utility Contact - Project Lead"]
[null,"Is Income Eligible or Market Rate Property "]
[null,"Total Measures being proposed"]
[null,"Building Type"]
[null,"Number of Buildings"]
[null,"Number of dwelling units in project",null," "]
[null,"Heating Fuel"]
[null,"DHW Fuel"]
[null,"Cooling System"]
[null,"Heating Utility"]
[null,"Electric Utility"]
["Note: select yes for measures being proposed"]
[null,"Energy Efficiency Upgrades","Proposed","Health and Safety Issue"]
[1,"Air Sealing","No"]
[2,"Low Flow DHW","No"]
[3,"Dwelling Unit Lighting","No"]
[4,"Common and Exterior Lighting","No"]
[5,"Insulation","No"]
[6,"Window Replacements","No"]
[7,"Refrigerators Replacement","No"]
[8,"HVAC & DHW Equipment","Yes"]
[9,"Smart Thermostats","No"]
[10,"Custom Measure","No"]

{"sheet":"Dropdown","index":1,"n_rows":165,"n_cols":25,"rows_kept":165,"cut":false,"hidden":true,"merged":[[1,11,1,14],[1,16,1,22]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,"Dwelling Unit Lighting",null,null,null,null,"HVAC",null,null,null,null,null,null,null,"Insulation"]
[null,"Competitive Resources, Inc., 60 Church Street, Suite #2, Yalesville, CT 06492",null,"Andover","Carl Watts","Multifamily Low-Rise Apartments 1-3 stories","None","None","Eversource Electric","Central AC",null,"Recessed","Recessed","New Fixtures","Standard Interior",null,"Electric Heater","Constant Volume","Individual","Electric Water Heater","Indirect","Pressure","Packaged DX"]
[null,"Handyman Express Energy Solutions, LLC, 1414 Barnum Avenue,Stratford, CT 06614",null,"Ansonia","Dana Forrester","Multifamily Mid-Rise Apartments 4 - 5 stories","Air Sealing","ALM ducts","UI Electric","Window AC",null,"Drum","Drum","Retrofit Fixtures","Standard Exterior",null,"Gas Boiler","Variable Speed","Central","Heat Pump Water Heater","Storage","Temperature","Chiller Plant",null,"Attic"]
[null,"New England Smart Energy Group, LLC, 34 Sherman Court, Fairfield, CT 06824",null,"Ashford","Natalia Sudyka","Multifamily High-Rise Apartments 6 stories or more","Low Flow DHW","ALM ducts and pipes","Eversource Gas","None",null,"Wrap","Wrap","Screw-in LED","High-Performance Interior",null,"Condensing Gas Boiler",null,null,"Gas Water Heater","Instananeous",null,"Ductless Mini Split",null,"Roof line/ Vaulted Ceiling"]
[null,"Santa Fuel, Inc., 154 Admiral Street, Bridgeport, CT 06605",null,"Avon","Alysse Rodrigues","Multifamily Apartments","Dwelling Unit Lighting","ALM pipes","CNG Gas","Other",null,"Troffer","Troffer","Controls Only","High-Performance Exterior",null,"Oil Boiler",null,null,"Oil Water Heater ","Stand Alone Non-Storage",null,"DX Split",null,"Foundation wall"]
[null,"Action for Bridgeport Community Development, 1070 Park Avenue, Bridegeport, CT 06604",null,"Barkhamsted",null,"Multifamily Townhouse","Common and Exterior Lighting","CO","SCG Gas",null,null,"Sconce","Sconce","Miscellaneous Costs",null,null,"HydroAir",null,null,"Propane Water Heater",null,null,"DX HP",null,"Basement Ceiling"]
[null,"The Access Agency, 1315 Main Street, Willimantic, CT 06226",null,"Beacon Falls",null,"Multifamily Other","Insulation","Customer refused","Prop. Gas",null,null,"Jelly Jar","Jelly Jar","Non-Eligible",null,null,"Propane Boiler",null,null,null,null,null,"Air Source Heat Pump",null,"Exterior Wall"]
[null,"Community Renewal Team, Inc., 555 Windsor Street, Hartford, CT 06120",null,"Berlin",null,null,"Window Replacements","Failed CAZ","Oil",null,null,"Square","Square",null,null,null,"Electric Furnace",null,null,null,null,null,"Watersource Heat Pump",null,"Crawlspace Wall"]
[null,"Energy Resources Group Technologies, Inc., 1831 Middletown Ave, Northford, CT, 06472",null,"Bethany",null,null,"Refrigerators Replacement","Failed spillage clean up","Other",null,null,"Cloud","Cloud",null,null,null,"Gas Furnace",null,null,null,null,null,"Ground Source Heat Pump",null,"Crawlspace Ceiling"]
[null,"New Opportunities, Inc., 232 North Elm Street, Waterbury, CT 06702",null,"Bethel",null,null,"HVAC & DHW Equipment","Gas leak customer side",null,null,null,"Strip","Strip",null,null,null,"Condensing Gas Furnace",null,null,null,null,null,"Window Unit",null,"Rim Joist"]
[null,"BantamWesson, 145 Railroad Hill St, Waterbury, CT 06708",null,"Bethlehem",null,null,"Smart Thermostats","Gas leak utility side",null,null,null,"Vanity","Vanity",null,null,null,"Oil Furnace",null,null,null,null,null,"Geothermal Heat Pump",null,"Attic Hatch Cover "]
[null,"CMC Energy Services, 4 Tower Dr, Wallingford, CT 06492 ",null,"Bloomfield",null,null,"Custom Measure","Gas leaks both sides",null,null,null,"Table Lamp","Table Lamp",null,null,null,"Propane Furnace",null,null,null,null,null,null,null,"Attic Pull Down Stairs Cover "]
[null,"Dynamic Building and Energy Solutions LLC, 183 Providence-New London Tpke, North Stonington, CT 06359",null,"Bolton",null,null,"Duct Sealing Custom","Lead",null,null,null,"Floor Lamp","Floor Lamp",null,null,null,"Ductless MiniSplit",null,null,null,null,null,null,null,"Attic Whole House Fan Cover "]
[null,"Energy Efficiency Solutions LLC, 77 Pierson Lane, Unit A, Windsor, CT 06095",null,"Bozrah",null,null,null,"Mold",null,null,null,"Keyless","Keyless",null,null,null,"Ducted Heat Pumps",null,null,null,null,null,null,null,"Attic Air Sealing"]
[null,"Homestead HES, 100 West Rd, Ellington, CT 06029",null,"Branford",null,null,null,"MVG",null,null,null,"Plate","Wallpack"]
[null,"Lantern Energy, 256 Oakwood Dr, Suite 3, Glastonbury, CT 06033",null,"Bridgeport",null,null,null,"Pest infestation",null,null,null,"Other","Bollard"]
[null,"JT Energy LLC, 79 Village Hill Rd, Willington, CT, 06279",null,"Bridgewater",null,null,null,"Vermiculite",null,null,null,null,"Flood"]
[null,"Tallento Construction Group, 343 Gurdon St, Bridgeport, CT 06606",null,"Bristol",null,null,"Air Sealing","Unvented gas appliance",null,null,null,null,"Canopy"]
[null,null,null,"Brookfield",null,null,"Air Source Heat Pump",null,null,null,null,null,"Acorn"]
[null,null,null,"Brooklyn",null,null,"Boiler",null,null,null,null,null,"Par Flood"]
[null,null,null,"Burlington",null,null,"Central AC",null,null,null,null,null,"Shoebox"]
[null,"EVERSOURCE GAS",null,"Canaan",null,null,"Common and Exterior Lighting",null,null,null,null,null,"Exit Light"]
[null,"CNG GAS",null,"Canterbury",null,null,"Controls",null,null,null,null,null,"Other"]
[null,"SCG GAS",null,"Canton",null,null,"Customer refused"]
[null,"OIL",null,"Chaplin",null,null,"Dwelling Unit Lighting Bulbs"]
[null,"PROPANE",null,"Cheshire",null,null,"Dwelling Unit Lighting Fixtures"]
[null,"UI ELECTRIC",null,"Chester",null,null,"Duct Sealing"]
[null,"EVERSOURCE ELECTRIC",null,"Clinton",null,null,"ECM Pumps"]
[null,"OTHER",null,"Colchester",null,null,"Furnace"]
[null,null,null,"Colebrook",null,null,"Heat Pump Hot Water Heater"]
[null,"Market Rate",null,"Columbia",null,null,"Hot Water Heater"]
[null,"Income Eligible",null,"Cornwall",null,null,"Insulation"]
[null,null,null,"Coventry",null,null,"Refrigerators"]
[null,null,null,"Cromwell",null,null,"Variable Frequency Drive (VFD)"]
[null,null,null,"Danbury",null,null,"Water Measures"]
[null,null,null,"Darien",null,null,"Water Source Heat Pump"]
[null,null,null,"Deep River",null,null,"Window Replacement"]
[null,null,null,"Derby",null,null,"Custom"]
[null,null,null,"East Windsor"]
[null,null,null,"Eastford"]
[null,null,null,"Easton"]
[null,null,null,"Enfield"]
[null,null,null,"Essex"]
[null,null,null,"Fairfield"]
[null,null,null,"Farmington"]
[null,null,null,"Glastonbury"]
[null,null,null,"Goshen"]
[null,null,null,"Granby"]
[null,null,null,"Greenwich"]
[null,null,null,"Griswold"]
[null,null,null,"Groton"]
[null,null,null,"Guilford"]
[null,null,null,"Haddam"]
[null,null,null,"Hamden"]
[null,null,null,"Hampton"]
[null,null,null,"Hartford"]
[null,null,null,"Hartland"]
[null,null,null,"Harwinton"]
[null,null,null,"Hebron"]
[null,null,null,"Kent"]
[null,null,null,"Killingly"]
[null,null,null,"Killingworth"]
[null,null,null,"Lebanon"]
[null,null,null,"Ledyard"]
[null,null,null,"Lisbon"]
[null,null,null,"Litchfield"]
[null,null,null,"Lyme"]
[null,null,null,"Madison"]
[null,null,null,"Manchester"]
[null,null,null,"Mansfield"]
[null,null,null,"Marlborough"]
[null,null,null,"Meriden"]
[null,null,null,"Middlebury"]
[null,null,null,"Middlefield"]
[null,null,null,"Middletown"]
[null,null,null,"Milford"]
[null,null,null,"Monroe"]
[null,null,null,"Montville"]
[null,null,null,"Morris"]
[null,null,null,"Naugatuck"]
[null,null,null,"New Britain"]
[null,null,null,"New Canaan"]
[null,null,null,"New Fairfield"]
[null,null,null,"New Hartford"]
[null,null,null,"New Haven"]
[null,null,null,"New London"]
[null,null,null,"New Milford"]
[null,null,null,"Newington"]
[null,null,null,"Newtown"]
[null,null,null,"Noank"]
[null,null,null,"Norfolk"]
[null,null,null,"North Branford"]
[null,null,null,"North Canaan"]
[null,null,null,"North Haven"]
[null,null,null,"North Stonington"]
[null,null,null,"Norwalk"]
[null,null,null,"Norwich"]
[null,null,null,"Old Lyme"]
[null,null,null,"Old Saybrook"]
[null,null,null,"Orange"]
[null,null,null,"Oxford"]
[null,null,null,"Plainfield"]
[null,null,null,"Plainville"]
[null,null,null,"Plymouth"]
[null,null,null,"Pomfret"]
[null,null,null,"Portland"]
[null,null,null,"Preston"]
[null,null,null,"Prospect"]
[null,null,null,"Putnam"]
[null,null,null,"Redding"]
[null,null,null,"Ridgefield"]
[null,null,null,"Rocky Hill"]
[null,null,null,"Roxbury"]
[null,null,null,"Salem"]
[null,null,null,"Salisbury"]
[null,null,null,"Scotland"]
[null,null,null,"Seymour"]
[null,null,null,"Sharon"]
[null,null,null,"Shelton"]
[null,null,null,"Sherman"]
[null,null,null,"Simsbury"]
[null,null,null,"Somers"]
[null,null,null,"South Windsor"]
[null,null,null,"Southbury"]
[null,null,null,"Southington"]
[null,null,null,"Sprague"]
[null,null,null,"Stafford"]
[null,null,null,"Stamford"]
[null,null,null,"Sterling"]
[null,null,null,"Stonington"]
[null,null,null,"Stratford"]
[null,null,null,"Suffield"]
[null,null,null,"Terryville"]
[null,null,null,"Thomaston"]
[null,null,null,"Thompson"]
[null,null,null,"Tolland"]
[null,null,null,"Torrington"]
[null,null,null,"Trumbull"]
[null,null,null,"Union"]
[null,null,null,"Vernon"]
[null,null,null,"Voluntown"]
[null,null,null,"Wallingford"]
[null,null,null,"Warren"]
[null,null,null,"Washington"]
[null,null,null,"Waterbury"]
[null,null,null,"Waterford"]
[null,null,null,"Watertown"]
[null,null,null,"West Hartford"]
[null,null,null,"West Haven"]
[null,null,null,"Westbrook"]
[null,null,null,"Weston"]
[null,null,null,"Westport"]
[null,null,null,"Wethersfield"]
[null,null,null,"Willimantic"]
[null,null,null,"Willington"]
[null,null,null,"Wilton"]
[null,null,null,"Winchester"]
[null,null,null,"Windham"]
[null,null,null,"Windsor"]
[null,null,null,"Windsor Locks"]
[null,null,null,"Wolcott"]
[null,null,null,"Woodbridge"]
[null,null,null,"Woodbury"]
[null,null,null,"Woodstock"]

{"sheet":"Direct Install - Unit Matrix","index":2,"n_rows":18,"n_cols":10,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,0,0,14]]}
[{"$f":"'Step 1 - Project Info'!$C$3&\" - \"&'Step 1 - Project Info'!$C$7","v":" - "}]
[]
["Instructions:"]
["Direct Install measures include the following dwelling unit measures assessed and implemented by a direct install contractor*: air sealing, duct sealing, domestic hot water saving measures (e.g., low flow shower heads, faucet aerators, pipe wrap), and light bulbs (for income eligible only)."]
["1) A 10% representative sampling of dwelling units across the multifamily property must be conducted to determine the energy savings opportunities. Units sampled should be 10% of each unit type based on # bedrooms/studios and location (e.g., top corner, top middle, bottom corner, bottom middle, middle floor corner, middle floor center, etc.)."]
["2) During sampling, a contractor will perform services in each of the identified sample units."]
["3) For each sample unit, please complete the below table which summarizes the measures performed during sampling."]
["4) For each sample unit, provide detailed information regarding measures installed during sampling on the applicable tabs generated within this Project Fillout Form."]
[]
["Total Units by Type","Quantity"]
["Efficiency/ Studio"]
["1 Bedrooms"]
["2 Bedrooms"]
["3 Bedrooms"]
["4 Bedrooms"]
[]
[]
[null,null,"Unit Identification in sample","Air Sealing","Duct Sealing","DHW Savings","Dwelling Unit Bulbs (IE ONLY)",null,null,{"$f":"IF(C19<>\"\",IF('Step 1 - Project Info'!$C$44<>\"\",IF('Step 1 - Project Info'!$C$44=\"Yes\",\"Air Sealing\",None),\"\"),\"\")","v":""}]

{"sheet":"Air Sealing","index":3,"n_rows":25,"n_cols":26,"rows_kept":25,"cut":false,"hidden":true,"merged":[[1,2,1,18],[8,14,8,16],[8,17,8,19],[8,20,8,22],[8,23,8,25],[7,14,7,25],[3,14,4,20],[7,5,8,12]]}
[]
[null,null,{"$f":"'Step 1 - Project Info'!$C$3&\" - \"&'Step 1 - Project Info'!$C$7","v":" - "}]
[]
[]
[null,null,"Total Number of Units",{"$f":"'Step 1 - Project Info'!C36","v":0}]
[null,null,"Total Sample Units",{"$f":"COUNTA('Direct Install - Unit Matrix'!C19:C38)","v":0}]
[null,null,"Number of Floors",0]
[null,null,"Number of Buildings",0,null,"Note: Units sampled should be 10% of each unit type unless the property is 20 units or less, then all units must be included below (# bedrooms/ Studios, Location (Top Corner, Top Middle, Bottom Corner, Bottom Middle, Mid Fl Corner, Mid Fl Center))",null,null,null,null,null,null,null,null,"AIR SEALING DETAIL"]
[null,null,"Name of Lead Technician w/ BPI Multifamily Certification & Any Other Technicians Performing Air Sealing",null,null,null,null,null,null,null,null,null,null,null,"(1) What was air sealed? Air sealing time and location on exterior or interior wall",null,null,"(2) What was air sealed? Air sealing time and location on exterior or interior wall",null,null,"(3) What was air sealed? Air sealing time and location on exterior or interior wall",null,null,"(4) What was air sealed? Air sealing time and location on exterior or interior wall"]
[null,null,"Sample Apt #","Is Entrance Door Interior/ Exterior?","Bedroom type (Studio, 1BDRM, etc..)","Unit Locations (Top, Corner, Bottom, Middle)","SqFT of Unit","Age (years) of Building","Number of Techs Air Sealing Per Unit","Total Hours per Unit ","Total Linear Feet of Sealing per Unit","Total Number Gaskets per Unit","Door Weather Stripped Per Linear Feet per Unit","Total Number of Door Sweeps per Unit","What was Air Sealed?","Air Sealing Time (Hours)","Interior Wall, Exterior Wall, Interior Ceiling, Attic Floor, Basement Ceiling, Interior Ceiling, Basement Exterior walls","What was Air Sealed?","Air Sealing Time (Hours)","Interior Wall, Exterior Wall, Interior Ceiling, Attic Floor, Basement Ceiling, Interior Ceiling, Basement Exterior walls","What was Air Sealed?","Air Sealing Time (Hours)","Interior Wall, Exterior Wall, Interior Ceiling, Attic Floor, Basement Ceiling, Interior Ceiling, Basement Exterior walls","What was Air Sealed?","Air Sealing Time (Hours)","Interior Wall, Exterior Wall, Interior Ceiling, Attic Floor, Basement Ceiling, Interior Ceiling, Basement Exterior walls"]
[null,"EXAMPLE","Unit 1","Interior","1 BDRM","TOP FL",1100,1980,2,0.75,120,4,10,2,"bottom and top plate/exterior wall",0.5,"exterior wall","Kitchen sink penetration",0.15,"interior wall","bathroom exhaust vent",0.1,"attic ceiling"]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$D$19:$D$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:C20))),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$D$19:$D$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:C21))),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$D$19:$D$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:C22))),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$D$19:$D$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:C23))),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$D$19:$D$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:C24))),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$D$19:$D$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:C25))),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$D$19:$D$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:C26))),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$D$19:$D$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:C27))),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$D$19:$D$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:C28))),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$D$19:$D$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:C29))),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$D$19:$D$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:C30))),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$D$19:$D$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:C31))),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$D$19:$D$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:C32))),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$D$19:$D$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:C33))),\"\")","v":""}]

{"sheet":"Low Flow DHW","index":4,"n_rows":34,"n_cols":11,"rows_kept":34,"cut":false,"hidden":true,"merged":[[2,4,2,7]]}
[]
[]
[null,null,null,null,{"$f":"'Step 1 - Project Info'!$C$3&\" - \"&'Step 1 - Project Info'!$C$7","v":" - "}]
[]
[]
[null,null,null,null,"WATER MEASURES","Quantity","Cost per Measure","Total Cost",null,"MR Pricing","IE Pricing"]
[null,null,null,null,"Hand Held Showerhead",0,{"$f":"IF(D6=\"Market Rate\",J7,IF(D6=\"Income Eligible\",K7,0))","v":0},{"$f":"G7*F7","v":0},null,16.079999999999998,15.84]
["Flip & Swivel Aerator",null,null,null,"Install Low-Flow Showerhead",0,{"$f":"IF(D6=\"Market Rate\",J8,IF(D6=\"Income Eligible\",K8,0))","v":0},{"$f":"G8*F8","v":0},null,8.4700000000000006,8.2100000000000009]
["Hand Held Showerhead",null,null,null,"Install Low- Flow Aerator",0,{"$f":"IF(D6=\"Market Rate\",J9,IF(D6=\"Income Eligible\",K9,0))","v":0},{"$f":"G9*F9","v":0},null,3.51,4.18]
["Install Low- Flow Aerator",null,null,null,"Flip & Swivel Aerator",0,{"$f":"IF(D6=\"Market Rate\",J10,IF(D6=\"Income Eligible\",K10,0))","v":0},{"$f":"G10*F10","v":0},null,5.2,5.18]
["Install Low-Flow Showerhead",null,null,null,null,null,"Total Cost",{"$f":"SUM(H7:H10)","v":0}]
[]
[]
[]
[]
[null,null,"Sample Unit #","Existing Kitchen Sink GPM","Bathroom Sink GPM","Bathroom Shower GPM",{"$f":"E9","v":"Install Low- Flow Aerator"},{"$f":"E10","v":"Flip & Swivel Aerator"},{"$f":"E8","v":"Install Low-Flow Showerhead"},{"$f":"E7","v":"Hand Held Showerhead"},"NOTES"]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$F$19:$F$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:C19))),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$F$19:$F$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:C20))),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$F$19:$F$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:C21))),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$F$19:$F$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:C22))),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$F$19:$F$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:C23))),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$F$19:$F$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:C24))),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$F$19:$F$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:C25))),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$F$19:$F$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:C26))),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$F$19:$F$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:C27))),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$F$19:$F$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:C28))),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$F$19:$F$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:C29))),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$F$19:$F$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:C30))),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$F$19:$F$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:C31))),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$F$19:$F$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:C32))),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$F$19:$F$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:C33))),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$F$19:$F$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:C34))),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$F$19:$F$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:C35))),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$F$19:$F$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:C36))),\"\")","v":""}]

{"sheet":"Dwelling Unit Lighting","index":5,"n_rows":177,"n_cols":22,"rows_kept":177,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,"Date",{"$f":"TODAY()","v":"2022-06-17"},null,null,null,"Company and Auditor Name",null,null,null,null,null,null,"Total Units by Type","Quantity"]
[null,null,"Site Name",{"$f":"'Step 1 - Project Info'!C3","v":0},null,null,null,null,null,null,null,null,null,null,"Efficiency/ Studio",{"$f":"'Direct Install - Unit Matrix'!B11","v":0}]
[null,null,"Site Address",{"$f":"CONCATENATE('Step 1 - Project Info'!C4,\" \",'Step 1 - Project Info'!C5,\" \",'Step 1 - Project Info'!C7)","v":"  "},null,null,null,"Apartment Number",null,null,null,null,null,null,"1 Bedrooms",{"$f":"'Direct Install - Unit Matrix'!B12","v":0}]
[null,null,"Building Number",null,null,null,null,"# of Bedrooms",null,null,null,null,null,null,"2 Bedrooms",{"$f":"'Direct Install - Unit Matrix'!B13","v":0}]
[null,null,"See notes below",null,null,null,null,null,null,null,null,null,null,null,"3 Bedrooms",{"$f":"'Direct Install - Unit Matrix'!B14","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4 Bedrooms",{"$f":"'Direct Install - Unit Matrix'!B15","v":0}]
[null,null,"Sample Unit #","Room Location","Existing Lamp Type","Existing Lamp Wattage","Existing Lamp Quantity","Existing Fixture Type","Existing Fixture Quantity","Existing Fixture Wattage","Proposed Lighting Measure","Proposed Fixture Type","Proposed Fixture Quantity","Proposed Fixture Wattage","Recommendation (Brand/Model Number):","Comments/Notes:","Estimated Quantity Needed",null,null,null,"Table of Estimated Fixtures and Bulbs","Number of Bulbs"]
[null,null,null,"Unit type and Unit number",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Recessed",{"$f":"SUMIF($L$11:$L$176,U9,$Q$11:$Q$159)","v":0}]
[null,null,null,"Example",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Drum",0]
["IF('Core Services - Unit Matrix'!$C$12=\"\",IF('Core Services - Unit Matrix'!$C$13=\"\",IF('Core Services - Unit Matrix'!$C$14=\"\",'Core Services - Unit Matrix'!$C$12\"\")","Example",{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:C19))),\"\")","v":""},"Bedroom","CFL",13,2,"Drum",1,28,"New fixture","Floor Lamp",5,10,null,null,{"$f":"IFERROR(IF(C11<>\"\",(M11/COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38))*'Step 1 - Project Info'!$C$36,\"\"),\"\")","v":""},null,null,null,"Wrap",0]
[null,"Example",{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:C19))),\"\")","v":""},"Hallway","Inc",60,2,"Drum",1,120,"New fixture","Drum",2,10,null,null,{"$f":"IFERROR(IF(C12<>\"\",(M12/COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38))*'Step 1 - Project Info'!$C$36,\"\"),\"\")","v":""},null,null,null,"Troffer",0]
[null,"Example",{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:C19))),\"\")","v":""},"Living Room","CFL",13,2,"Drum",1,28,"New fixture","Drum",5,10,null,null,{"$f":"IFERROR(IF(C13<>\"\",(M13/COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38))*'Step 1 - Project Info'!$C$36,\"\"),\"\")","v":""},null,null,null,"Sconce",0]
[null,"Example",{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:C19))),\"\")","v":""},"Living Room","Inc",60,2,"Table Lamp",2,120,"Screw-in bulb","Jelly Jar",4,10,null,null,{"$f":"IFERROR(IF(C14<>\"\",(M14/COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38))*'Step 1 - Project Info'!$C$36,\"\"),\"\")","v":""},null,null,null,"Jelly Jar",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C15<>\"\",(M15/COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38))*'Step 1 - Project Info'!$C$36,\"\"),\"\")","v":""},null,null,null,"Square",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C16<>\"\",(M16/COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38))*'Step 1 - Project Info'!$C$36,\"\"),\"\")","v":""},null,null,null,"Cloud",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C17<>\"\",(M17/COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38))*'Step 1 - Project Info'!$C$36,\"\"),\"\")","v":""},null,null,null,"Strip",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C18<>\"\",(M18/COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38))*'Step 1 - Project Info'!$C$36,\"\"),\"\")","v":""},null,null,null,"Vanity",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C19<>\"\",(M19/COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38))*'Step 1 - Project Info'!$C$36,\"\"),\"\")","v":""},null,null,null,"Table Lamp",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C20<>\"\",(M20/COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38))*'Step 1 - Project Info'!$C$36,\"\"),\"\")","v":""},null,null,null,"Floor Lamp",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C21<>\"\",(M21/COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38))*'Step 1 - Project Info'!$C$36,\"\"),\"\")","v":""},null,null,null,"Keyless",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C22<>\"\",(M22/COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38))*'Step 1 - Project Info'!$C$36,\"\"),\"\")","v":""},null,null,null,"Wallpack",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C23<>\"\",(M23/COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38))*'Step 1 - Project Info'!$C$36,\"\"),\"\")","v":""},null,null,null,"Bollard",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C24<>\"\",(M24/COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38))*'Step 1 - Project Info'!$C$36,\"\"),\"\")","v":""},null,null,null,"Flood",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C25<>\"\",(M25/COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38))*'Step 1 - Project Info'!$C$36,\"\"),\"\")","v":""},null,null,null,"Canopy",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C26<>\"\",(M26/COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38))*'Step 1 - Project Info'!$C$36,\"\"),\"\")","v":""},null,null,null,"Acorn",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sum",{"$f":"SUM(Q11:Q26)","v":0},null,null,"Par Flood",0]
[null,"Example",{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:C20))),\"\")","v":""},"Den/Office","CFL",120,5,"Troffer",1,150,"Screw-in bulb","Troffer",10,10,null,null,{"$f":"IFERROR(IF(C28<>\"\",M28*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""},null,null,null,"Shoebox",0]
[null,"Example",{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:C20))),\"\")","v":""},"Kitchen","Inc",32,3,"Strip",1,96,"New fixture","Drum",3,10,null,null,{"$f":"IFERROR(IF(C29<>\"\",M29*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""},null,null,null,"Exit Light",0]
["IF(A31=A13,'Core Services - Unit Matrix'!$C$14,IF('Core Services - Unit Matrix'!$G$13<>\"Dwelling Unit Lighting\",IF('Core Services - Unit Matrix'!$G$14<>\"Dwelling Unit Lighting\",IF('Core Services - Unit Matrix'!$G$15<>\"Dwelling Unit Lighting\",IF('Core Services - Unit Matrix'!$G$16<>\"Dwelling Unit Lighting\",IF('Core Services - Unit Matrix'!$G$17<>\"Dwelling Unit Lighting\",IF('Core Services - Unit Matrix'!$G$18<>\"Dwelling Unit Lighting\",IF('Core Services - Unit Matrix'!$G$19<>\"Dwelling Unit Lighting\",IF('Core Services - Unit Matrix'!$G$20<>\"Dwelling Unit Lighting\",IF('Core Services - Unit Matrix'!$G$21<>\"Dwelling Unit Lighting\",\"\",'Core Services - Unit Matrix'!$C$21),'Core Services - Unit Matrix'!$C$20),'Core Services - Unit Matrix'!$C$19),'Core Services - Unit Matrix'!$C$18),'Core Services - Unit Matrix'!$C$17),'Core Services - Unit Matrix'!$C$16),'Core Services - Unit Matrix'!$C$15),'Core Services - Unit Matrix'!$C$14),'Core Services - Unit Matrix'!$C$13))",null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:C20))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C30<>\"\",M30*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""},null,null,null,"Other",0]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:C20))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C31<>\"\",M31*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:C20))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C32<>\"\",M32*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:C20))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C33<>\"\",M33*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:C20))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C34<>\"\",M34*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:C20))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C35<>\"\",M35*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:C20))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C36<>\"\",M36*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:C20))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C37<>\"\",M37*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:C20))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C38<>\"\",M38*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:C20))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C39<>\"\",M39*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:C20))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C40<>\"\",M40*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:C20))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C41<>\"\",M41*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:C20))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C42<>\"\",M42*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:C20))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C43<>\"\",M43*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sum",{"$f":"SUM(Q28:Q43)","v":0}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:C21))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C45<>\"\",M45*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:C21))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C46<>\"\",M46*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:C21))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C47<>\"\",M47*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:C21))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C48<>\"\",M48*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:C21))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C49<>\"\",M49*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:C21))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C50<>\"\",M50*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:C21))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C51<>\"\",M51*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:C21))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C52<>\"\",M52*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:C21))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C53<>\"\",M53*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:C21))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C54<>\"\",M54*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:C21))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C55<>\"\",M55*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:C21))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C56<>\"\",M56*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:C21))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C57<>\"\",M57*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:C21))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C58<>\"\",M58*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:C21))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C59<>\"\",M59*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:C21))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C60<>\"\",M60*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sum",{"$f":"SUM(Q45:Q60)","v":0}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C22))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C62<>\"\",M62*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C22))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C63<>\"\",M63*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C22))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C64<>\"\",M64*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C22))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C65<>\"\",M65*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C22))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C66<>\"\",M66*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C22))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C67<>\"\",M67*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C22))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C68<>\"\",M68*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C22))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C69<>\"\",M69*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C22))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C70<>\"\",M70*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C22))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C71<>\"\",M71*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C22))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C72<>\"\",M72*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C22))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C73<>\"\",M73*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C22))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C74<>\"\",M74*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C22))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C75<>\"\",M75*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C22))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C76<>\"\",M76*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sum",{"$f":"SUM(Q61:Q76)","v":0}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C23))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C78<>\"\",M78*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C23))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C79<>\"\",M79*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C23))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C80<>\"\",M80*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C23))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C81<>\"\",M81*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C23))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C82<>\"\",M82*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C23))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C83<>\"\",M83*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C23))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C84<>\"\",M84*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C23))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C85<>\"\",M85*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C23))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C86<>\"\",M86*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C23))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C87<>\"\",M87*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C23))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C88<>\"\",M88*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C23))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C89<>\"\",M89*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C23))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C90<>\"\",M90*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C23))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C91<>\"\",M91*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C23))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C92<>\"\",M92*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sum",{"$f":"SUM(Q77:Q92)","v":0}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C24))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C94<>\"\",M94*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C24))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C95<>\"\",M95*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C24))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C96<>\"\",M96*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C24))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C97<>\"\",M97*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C24))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C98<>\"\",M98*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C24))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C99<>\"\",M99*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C24))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C100<>\"\",M100*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C24))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C101<>\"\",M101*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C24))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C102<>\"\",M102*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C24))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C103<>\"\",M103*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C24))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C104<>\"\",M104*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C24))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C105<>\"\",M105*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C24))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C106<>\"\",M106*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C24))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C107<>\"\",M107*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C24))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C108<>\"\",M108*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sum",{"$f":"SUM(Q93:Q108)","v":0}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C25))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C110<>\"\",M110*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C25))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C111<>\"\",M111*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C25))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C112<>\"\",M112*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C25))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C113<>\"\",M113*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C25))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C114<>\"\",M114*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C25))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C115<>\"\",M115*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C25))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C116<>\"\",M116*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C25))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C117<>\"\",M117*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C25))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C118<>\"\",M118*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C25))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C119<>\"\",M119*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C25))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C120<>\"\",M120*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C25))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C121<>\"\",M121*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C25))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C122<>\"\",M122*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C25))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C123<>\"\",M123*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C25))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C124<>\"\",M124*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C25))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C125<>\"\",M125*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sum",{"$f":"SUM(Q110:Q125)","v":0}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C26))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C127<>\"\",M127*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C26))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C128<>\"\",M128*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C26))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C129<>\"\",M129*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C26))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C130<>\"\",M130*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C26))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C131<>\"\",M131*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C26))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C132<>\"\",M132*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C26))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C133<>\"\",M133*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C26))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C134<>\"\",M134*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C26))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C135<>\"\",M135*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C26))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C136<>\"\",M136*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C26))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C137<>\"\",M137*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C26))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C138<>\"\",M138*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C26))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C139<>\"\",M139*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C26))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C140<>\"\",M140*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C26))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C141<>\"\",M141*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C26))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C142<>\"\",M142*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sum",{"$f":"SUM(Q127:Q142)","v":0}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C27))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C144<>\"\",M144*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C27))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C145<>\"\",M145*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C27))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C146<>\"\",M146*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C27))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C147<>\"\",M147*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C27))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C148<>\"\",M148*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C27))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C149<>\"\",M149*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C27))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C150<>\"\",M150*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C27))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C151<>\"\",M151*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C27))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C152<>\"\",M152*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C27))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C153<>\"\",M153*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C27))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C154<>\"\",M154*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C27))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C155<>\"\",M155*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C27))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C156<>\"\",M156*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C27))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C157<>\"\",M157*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C27))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C158<>\"\",M158*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C27))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C159<>\"\",M159*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sum",{"$f":"SUM(Q144:Q159)","v":0}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C28))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C161<>\"\",M161*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C28))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C162<>\"\",M162*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C28))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C163<>\"\",M163*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C28))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C164<>\"\",M164*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C28))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C165<>\"\",M165*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C28))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C166<>\"\",M166*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C28))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C167<>\"\",M167*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C28))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C168<>\"\",M168*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C28))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C169<>\"\",M169*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C28))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C170<>\"\",M170*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C28))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C171<>\"\",M171*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C28))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C172<>\"\",M172*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C28))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C173<>\"\",M173*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C28))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C174<>\"\",M174*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C28))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C175<>\"\",M175*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX('Direct Install - Unit Matrix'!$C$19:$C$38,SMALL(IF('Direct Install - Unit Matrix'!$G$19:$G$38<>\"\",ROW('Direct Install - Unit Matrix'!$C$19:$C$38)-ROW('Direct Install - Unit Matrix'!C$19)+1),ROWS('Direct Install - Unit Matrix'!C$19:$C28))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(C176<>\"\",M176*COUNTA('Direct Install - Unit Matrix'!$G$19:$G$38),\"\"),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sum",{"$f":"SUM(Q161:Q176)","v":0}]

{"sheet":"Common and Exterior Lighting","index":6,"n_rows":124,"n_cols":18,"rows_kept":124,"cut":false,"hidden":true,"merged":[[1,3,3,13],[1,14,3,15]]}
[]
[null,null,null,{"$f":"'Step 1 - Project Info'!$C$3&\" - \"&'Step 1 - Project Info'!$C$7","v":" - "},null,null,null,null,null,null,null,null,null,null,"Company and Auditor Name"]
[]
[]
[]
[]
[null,"Area Description","Unit Quantity Before","Description Before","Watts/ Unit Before","Annual Hours Before (Verify if over 6000)","Item Type - Select From Picklist ","Lighting Group Type - Select From Picklist\n(Hold Mouse on Cell H7 To View Descriptions)","Unit Quantity After","Description After","Proposed Fixture Manufacturer","Proposed Fixture Model Number ","DLC Product ID or ENERGY STAR ","\"NEW\" Occupancy Sensor Controlled? (Y or N)","Watts/ Unit After","Annual Hours After","Installed Cost/ Fixture","Total Cost/ Group"]
["Example","Exterior Pole Lights",465,"70W High Pressure Sodium",95,4004,"Retrofit Fixtures","High-Performance Exterior",250," 20W LED Wallpack","MaxLite",123456789,"ENERGY STAR","Y",20,{"$f":"IF(N8=\"Y\",F8*0.7,F8)","v":2802.7999999999997},50,{"$f":"IF(G8=\"Non-Eligible\",0,IF(I8*Q8=0,\"\",(I8*(Q8))))","v":12500}]
[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,null,null,null,null,null,null,{"$f":"IF(G10=\"Non-Eligible\",0,IF(I10*Q10=0,\"\",(I10*(Q10))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G11=\"Non-Eligible\",0,IF(I11*Q11=0,\"\",(I11*(Q11))))","v":""}]
[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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,""]
[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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,""]
[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,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,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,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,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":"IF(G75=\"Non-Eligible\",0,IF(I75*Q75=0,\"\",(I75*(Q75))))","v":""}]
[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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,""]
[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,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,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,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,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,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,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,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,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,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,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,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,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"Lighting Summary","index":7,"n_rows":42,"n_cols":10,"rows_kept":42,"cut":false,"hidden":true,"merged":[[1,3,3,7],[5,2,7,8],[4,1,4,8]]}
[]
[null,null,null,{"$f":"'Step 1 - Project Info'!$C$3&\" - \"&'Step 1 - Project Info'!$C$7","v":" - "}]
[]
[]
[null,"Note: PLEASE SPECIFY MISCELLANEOUS COST ASSOCIATED WITH LIGHTING INSTALLATION. THE PURPOSE OF THIS TAB IS TO SUMMARIZE THE LIGHTING THAT IS BEING PROPOSED TO BE INSTALLED THROUGHOUT THE ENTIRE PROPERTY."]
[null,null,"TOTAL LIGHTING QUANTITY THE BUILDING NEEDS TO BE SERVICED"]
[]
[]
[null,"Dwelling Unit"]
[null,"Existing Bulb Name","Existing Bulb Wattage","Recommended Bulb Name/ Model","Proposed Bulb Wattage","Quantity","Location","Material cost","Labor  Cost","Total Cost "]
["Example","CFL",13,"New fixture",10,5,"Hallway",100,27,{"$f":"IFERROR((H11+I11)*F11,\"\")","v":635}]
[]
[]
[]
[]
[null,{"$f":"IF('Dwelling Unit Lighting'!E16<>\"\",'Dwelling Unit Lighting'!E16,\"\")","v":""},{"$f":"IF('Dwelling Unit Lighting'!F16<>\"\",'Dwelling Unit Lighting'!F16,\"\")","v":""},{"$f":"IF('Dwelling Unit Lighting'!K16<>\"\",'Dwelling Unit Lighting'!K16,\"\")","v":""},{"$f":"IF('Dwelling Unit Lighting'!N16<>\"\",'Dwelling Unit Lighting'!N16,\"\")","v":""},{"$f":"IF('Dwelling Unit Lighting'!M16<>\"\",'Dwelling Unit Lighting'!M16,\"\")","v":""},null,null,null,{"$f":"IFERROR((H16+I16)*F16,\"\")","v":""}]
[null,{"$f":"IF('Dwelling Unit Lighting'!E17<>\"\",'Dwelling Unit Lighting'!E17,\"\")","v":""},{"$f":"IF('Dwelling Unit Lighting'!F17<>\"\",'Dwelling Unit Lighting'!F17,\"\")","v":""},{"$f":"IF('Dwelling Unit Lighting'!K17<>\"\",'Dwelling Unit Lighting'!K17,\"\")","v":""},{"$f":"IF('Dwelling Unit Lighting'!N17<>\"\",'Dwelling Unit Lighting'!N17,\"\")","v":""},{"$f":"IF('Dwelling Unit Lighting'!M17<>\"\",'Dwelling Unit Lighting'!M17,\"\")","v":""},{"$f":"IFERROR(INDEX('Dwelling Unit Lighting'!$D$11:$D$194,SMALL(IF('Dwelling Unit Lighting'!$D$11:$D$194<>\"\",ROW('Dwelling Unit Lighting'!$D$11:$D$194)-ROW(D$10)+1),ROWS(D$10:D16))),\"\")","v":""},null,null,""]
[null,{"$f":"IF('Dwelling Unit Lighting'!E18<>\"\",'Dwelling Unit Lighting'!E18,\"\")","v":""},{"$f":"IF('Dwelling Unit Lighting'!F18<>\"\",'Dwelling Unit Lighting'!F18,\"\")","v":""},{"$f":"IF('Dwelling Unit Lighting'!K18<>\"\",'Dwelling Unit Lighting'!K18,\"\")","v":""},{"$f":"IF('Dwelling Unit Lighting'!N18<>\"\",'Dwelling Unit Lighting'!N18,\"\")","v":""},{"$f":"IF('Dwelling Unit Lighting'!M18<>\"\",'Dwelling Unit Lighting'!M18,\"\")","v":""},{"$f":"IFERROR(INDEX('Dwelling Unit Lighting'!$D$11:$D$194,SMALL(IF('Dwelling Unit Lighting'!$D$11:$D$194<>\"\",ROW('Dwelling Unit Lighting'!$D$11:$D$194)-ROW(D$10)+1),ROWS(D$10:D17))),\"\")","v":""},null,"Total",{"$f":"SUM(J11:J17)","v":635}]
[null,"Existing Fixture Name","Existing Fixture Wattage","Recommended Fixture Name/ Model","Proposed Fixture Wattage","Quantity","Location","Material cost","Labor  Cost","Total Cost "]
["Example","Incandescent Drum",120,"LED DC014",14,390,"Bedroom",25,25,{"$f":"(H20+I20)*F20","v":19500}]
["Example","Incandescent Drum",80,"LED DC015",8,217,"Bathroom",25,25,{"$f":"(H21+I21)*F21","v":10850}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(J20:J25)","v":30350}]
[]
[]
[null,"Common Area"]
[null,"Description Before","Existing Fixture or Bulb Wattage","Description After","Wattage","Quantity","Location","Total Cost "]
["Example",{"$f":"IF('Common and Exterior Lighting'!D8<>\"\",'Common and Exterior Lighting'!D8,\"\")","v":"70W High Pressure Sodium"},{"$f":"IF('Common and Exterior Lighting'!E8<>\"\",'Common and Exterior Lighting'!E8,\"\")","v":95},{"$f":"IF('Common and Exterior Lighting'!J8<>\"\",'Common and Exterior Lighting'!J8,\"\")","v":" 20W LED Wallpack"},{"$f":"IF('Common and Exterior Lighting'!O8<>\"\",'Common and Exterior Lighting'!O8,\"\")","v":20},{"$f":"IF('Common and Exterior Lighting'!I8<>\"\",'Common and Exterior Lighting'!I8,\"\")","v":250},{"$f":"IF('Common and Exterior Lighting'!B8<>\"\",'Common and Exterior Lighting'!B8,\"\")","v":"Exterior Pole Lights"},{"$f":"IF('Common and Exterior Lighting'!R8<>\"\",'Common and Exterior Lighting'!R8,\"\")","v":12500}]
[null,{"$f":"IF('Common and Exterior Lighting'!D9<>\"\",'Common and Exterior Lighting'!D9,\"\")","v":""},{"$f":"IF('Common and Exterior Lighting'!E9<>\"\",'Common and Exterior Lighting'!E9,\"\")","v":""},{"$f":"IF('Common and Exterior Lighting'!J9<>\"\",'Common and Exterior Lighting'!J9,\"\")","v":""},{"$f":"IF('Common and Exterior Lighting'!O9<>\"\",'Common and Exterior Lighting'!O9,\"\")","v":""},{"$f":"IF('Common and Exterior Lighting'!I9<>\"\",'Common and Exterior Lighting'!I9,\"\")","v":""},{"$f":"IF('Common and Exterior Lighting'!B9<>\"\",'Common and Exterior Lighting'!B9,\"\")","v":""},{"$f":"IF('Common and Exterior Lighting'!R9<>\"\",'Common and Exterior Lighting'!R9,\"\")","v":""}]
[null,{"$f":"IF('Common and Exterior Lighting'!D10<>\"\",'Common and Exterior Lighting'!D10,\"\")","v":""},{"$f":"IF('Common and Exterior Lighting'!E10<>\"\",'Common and Exterior Lighting'!E10,\"\")","v":""},{"$f":"IF('Common and Exterior Lighting'!J10<>\"\",'Common and Exterior Lighting'!J10,\"\")","v":""},{"$f":"IF('Common and Exterior Lighting'!O10<>\"\",'Common and Exterior Lighting'!O10,\"\")","v":""},{"$f":"IF('Common and Exterior Lighting'!I10<>\"\",'Common and Exterior Lighting'!I10,\"\")","v":""},{"$f":"IF('Common and Exterior Lighting'!B10<>\"\",'Common and Exterior Lighting'!B10,\"\")","v":""},{"$f":"IF('Common and Exterior Lighting'!R10<>\"\",'Common and Exterior Lighting'!R10,\"\")","v":""}]
[null,{"$f":"IF('Common and Exterior Lighting'!D11<>\"\",'Common and Exterior Lighting'!D11,\"\")","v":""},{"$f":"IF('Common and Exterior Lighting'!E11<>\"\",'Common and Exterior Lighting'!E11,\"\")","v":""},{"$f":"IF('Common and Exterior Lighting'!J11<>\"\",'Common and Exterior Lighting'!J11,\"\")","v":""},{"$f":"IF('Common and Exterior Lighting'!O11<>\"\",'Common and Exterior Lighting'!O11,\"\")","v":""},{"$f":"IF('Common and Exterior Lighting'!I11<>\"\",'Common and Exterior Lighting'!I11,\"\")","v":""},{"$f":"IF('Common and Exterior Lighting'!B11<>\"\",'Common and Exterior Lighting'!B11,\"\")","v":""},{"$f":"IF('Common and Exterior Lighting'!R11<>\"\",'Common and Exterior Lighting'!R11,\"\")","v":""}]
[null,{"$f":"IF('Common and Exterior Lighting'!D12<>\"\",'Common and Exterior Lighting'!D12,\"\")","v":""},{"$f":"IF('Common and Exterior Lighting'!E12<>\"\",'Common and Exterior Lighting'!E12,\"\")","v":""},{"$f":"IF('Common and Exterior Lighting'!J12<>\"\",'Common and Exterior Lighting'!J12,\"\")","v":""},{"$f":"IF('Common and Exterior Lighting'!O12<>\"\",'Common and Exterior Lighting'!O12,\"\")","v":""},{"$f":"IF('Common and Exterior Lighting'!I12<>\"\",'Common and Exterior Lighting'!I12,\"\")","v":""},{"$f":"IF('Common and Exterior Lighting'!B12<>\"\",'Common and Exterior Lighting'!B12,\"\")","v":""},{"$f":"IF('Common and Exterior Lighting'!R12<>\"\",'Common and Exterior Lighting'!R12,\"\")","v":""}]
[null,{"$f":"IF('Common and Exterior Lighting'!D13<>\"\",'Common and Exterior Lighting'!D13,\"\")","v":""},{"$f":"IF('Common and Exterior Lighting'!E13<>\"\",'Common and Exterior Lighting'!E13,\"\")","v":""},{"$f":"IF('Common and Exterior Lighting'!J13<>\"\",'Common and Exterior Lighting'!J13,\"\")","v":""},{"$f":"IF('Common and Exterior Lighting'!O13<>\"\",'Common and Exterior Lighting'!O13,\"\")","v":""},{"$f":"IF('Common and Exterior Lighting'!I13<>\"\",'Common and Exterior Lighting'!I13,\"\")","v":""},{"$f":"IF('Common and Exterior Lighting'!B13<>\"\",'Common and Exterior Lighting'!B13,\"\")","v":""},{"$f":"IF('Common and Exterior Lighting'!R13<>\"\",'Common and Exterior Lighting'!R13,\"\")","v":""}]
[null,{"$f":"IF('Common and Exterior Lighting'!D14<>\"\",'Common and Exterior Lighting'!D14,\"\")","v":""},{"$f":"IF('Common and Exterior Lighting'!E14<>\"\",'Common and Exterior Lighting'!E14,\"\")","v":""},{"$f":"IF('Common and Exterior Lighting'!J14<>\"\",'Common and Exterior Lighting'!J14,\"\")","v":""},{"$f":"IF('Common and Exterior Lighting'!O14<>\"\",'Common and Exterior Lighting'!O14,\"\")","v":""},{"$f":"IF('Common and Exterior Lighting'!I14<>\"\",'Common and Exterior Lighting'!I14,\"\")","v":""},{"$f":"IF('Common and Exterior Lighting'!B14<>\"\",'Common and Exterior Lighting'!B14,\"\")","v":""},{"$f":"IF('Common and Exterior Lighting'!R14<>\"\",'Common and Exterior Lighting'!R14,\"\")","v":""}]
[null,{"$f":"IF('Common and Exterior Lighting'!D15<>\"\",'Common and Exterior Lighting'!D15,\"\")","v":""},{"$f":"IF('Common and Exterior Lighting'!E15<>\"\",'Common and Exterior Lighting'!E15,\"\")","v":""},{"$f":"IF('Common and Exterior Lighting'!J15<>\"\",'Common and Exterior Lighting'!J15,\"\")","v":""},{"$f":"IF('Common and Exterior Lighting'!O15<>\"\",'Common and Exterior Lighting'!O15,\"\")","v":""},{"$f":"IF('Common and Exterior Lighting'!I15<>\"\",'Common and Exterior Lighting'!I15,\"\")","v":""},{"$f":"IF('Common and Exterior Lighting'!B15<>\"\",'Common and Exterior Lighting'!B15,\"\")","v":""},{"$f":"IF('Common and Exterior Lighting'!R15<>\"\",'Common and Exterior Lighting'!R15,\"\")","v":""}]
[null,{"$f":"IF('Common and Exterior Lighting'!D16<>\"\",'Common and Exterior Lighting'!D16,\"\")","v":""},{"$f":"IF('Common and Exterior Lighting'!E16<>\"\",'Common and Exterior Lighting'!E16,\"\")","v":""},{"$f":"IF('Common and Exterior Lighting'!J16<>\"\",'Common and Exterior Lighting'!J16,\"\")","v":""},{"$f":"IF('Common and Exterior Lighting'!O16<>\"\",'Common and Exterior Lighting'!O16,\"\")","v":""},{"$f":"IF('Common and Exterior Lighting'!I16<>\"\",'Common and Exterior Lighting'!I16,\"\")","v":""},{"$f":"IF('Common and Exterior Lighting'!B16<>\"\",'Common and Exterior Lighting'!B16,\"\")","v":""},{"$f":"IF('Common and Exterior Lighting'!R16<>\"\",'Common and Exterior Lighting'!R16,\"\")","v":""}]
[null,{"$f":"IF('Common and Exterior Lighting'!D17<>\"\",'Common and Exterior Lighting'!D17,\"\")","v":""},{"$f":"IF('Common and Exterior Lighting'!E17<>\"\",'Common and Exterior Lighting'!E17,\"\")","v":""},{"$f":"IF('Common and Exterior Lighting'!J17<>\"\",'Common and Exterior Lighting'!J17,\"\")","v":""},{"$f":"IF('Common and Exterior Lighting'!O17<>\"\",'Common and Exterior Lighting'!O17,\"\")","v":""},{"$f":"IF('Common and Exterior Lighting'!I17<>\"\",'Common and Exterior Lighting'!I17,\"\")","v":""},{"$f":"IF('Common and Exterior Lighting'!B17<>\"\",'Common and Exterior Lighting'!B17,\"\")","v":""},{"$f":"IF('Common and Exterior Lighting'!R17<>\"\",'Common and Exterior Lighting'!R17,\"\")","v":""}]
[null,{"$f":"IF('Common and Exterior Lighting'!D18<>\"\",'Common and Exterior Lighting'!D18,\"\")","v":""},{"$f":"IF('Common and Exterior Lighting'!E18<>\"\",'Common and Exterior Lighting'!E18,\"\")","v":""},{"$f":"IF('Common and Exterior Lighting'!J18<>\"\",'Common and Exterior Lighting'!J18,\"\")","v":""},{"$f":"IF('Common and Exterior Lighting'!O18<>\"\",'Common and Exterior Lighting'!O18,\"\")","v":""},{"$f":"IF('Common and Exterior Lighting'!I18<>\"\",'Common and Exterior Lighting'!I18,\"\")","v":""},{"$f":"IF('Common and Exterior Lighting'!B18<>\"\",'Common and Exterior Lighting'!B18,\"\")","v":""},{"$f":"IF('Common and Exterior Lighting'!R18<>\"\",'Common and Exterior Lighting'!R18,\"\")","v":""}]
[null,null,null,null,null,null,"Total",{"$f":"SUM(H31:H40)","v":12500}]

{"sheet":"Insulation","index":8,"n_rows":7,"n_cols":10,"rows_kept":7,"cut":false,"hidden":true,"merged":[[2,2,4,8]]}
[]
[]
[null,null,{"$f":"'Step 1 - Project Info'!$C$3&\" - \"&'Step 1 - Project Info'!$C$7","v":" - "}]
[]
[]
[]
[null,"Location","Square Footage of Insulation (Linear feet for attic air sealing)","Existing Insulation Type","Existing Insulation Thickness (Inches)","Existing Insulation R-value","Proposed Insulation Type","Proposed Insulation Thickness (Inches)","Proposed Installed Insulation R-value ","Proposed Project Cost"]

{"sheet":"Window Replacements","index":9,"n_rows":10,"n_cols":15,"rows_kept":10,"cut":false,"hidden":true,"merged":[[1,5,3,11]]}
[]
[null,null,null,null,null,{"$f":"'Step 1 - Project Info'!$C$3&\" - \"&'Step 1 - Project Info'!$C$7","v":" - "}]
[]
[]
[]
[]
[null,null,null,"EXISTING WINDOW TYPES","PROPOSED MANUFACTURER AND MODEL NUMBER","CPD NUMBER","PROPOSED U-VALUE","WIDTH","LENGTH","QUANTITY"," TOTAL AREA","PROPOSED WINDOW TYPE","PROPOSED WINDOW MATERIAL COST","PROPOSED WINDOW LABOR COST","TOTAL COST"]
[null,"Single Pane without Storm"]
[null,"Single Pane with Storm"]
[null,"Double Pane"]

{"sheet":"Refrigerator Replacements","index":10,"n_rows":15,"n_cols":13,"rows_kept":15,"cut":false,"hidden":true,"merged":[[1,2,1,12],[2,9,2,12],[2,4,2,8]]}
[]
[null,null,{"$f":"'Step 1 - Project Info'!$C$3&\" - \"&'Step 1 - Project Info'!$C$7","v":" - "}]
[null,null,null,null,"Existing Units",null,null,null,null,"Proposed Units"]
[null,null,"Number of Refrigerators","Unit #","Age","Make","Size (cubic ft)","Model","KWH","Model","Size (cubic ft)"," KWH","Cost"]
[null,"Example",10,"A101","15 yrs","Hotpoint",14,"CTH14CYBRLWW",499,"FFHT1513LW",15,355,574]
[]
[]
[]
[]
[null,null," ",null," "," "," "," "," "," "," "," "," "]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I5:I9)","v":499},null,null,{"$f":"SUM(L5:L9)","v":355},{"$f":"SUM(M5:M9)","v":574}]
[]
[null,null,null,null,null,null,null,"∆kWh = ",{"$f":"I11-L11","v":144}]
[null,null,null,null,null,null,null,"Est. Savings = "]
[null,null,null,null,null,null,null,"Est. Payback = "]

{"sheet":"HVAC","index":11,"n_rows":70,"n_cols":18,"rows_kept":70,"cut":false,"hidden":false,"merged":[[10,4,11,13],[1,3,3,16],[69,6,70,15],[18,2,19,5],[20,2,20,5],[69,2,70,5],[31,2,32,5],[33,2,33,5],[57,2,58,5],[59,2,59,5],[36,4,37,12],[22,4,23,15],[61,4,62,12],[49,4,50,12]]}
[]
[null,null,null,{"$f":"'Step 1 - Project Info'!$C$3&\" - \"&'Step 1 - Project Info'!$C$7","v":" - "}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"HEATING SYSTEM"]
[]
[null,null,"LOCATION","INDIVIDUAL OR CENTRAL SYSTEM","AGE","EXISTING HEATING SYSTEM TYPE","MODEL NUMBER","EXISTING SIZE (INPUT MBTU)","EXISTING EFFICIENCY (AFUE or HSPF)","PROPOSED HEATING TYPE","INDIVIDUAL OR CENTRAL SYSTEM","MANUFACTURER & MODEL NUMBER","SIZE (INPUT MBTU)","PROPOSED EFFICIENCY (AFUE or HSPF)","QUANTITY","PROJECT COST"]
[]
[]
[]
[]
[]
[null,null,"Is there a indirect hot water system working with the existing boiler?"]
[]
[]
[]
[null,null,null,null,"HEATING SYSTEM CIRCULATOR PUMPS"]
[]
[null,null,"LOCATION","EXISTING HEATING SYSTEM PUMPS TYPE","AGE","SIZE (HP)","INDIVIDUAL OR CENTRAL SYSTEM","QUANTITY","ARE THERE BACK-UPS?","QUANTITY OF BACK-UPS","PROPOSED HEATING SYSTEM PUMPS TYPE","SIZE (HP)","EFFICIENCY","INDIVIDUAL OR CENTRAL SYSTEM","QUANTITY","ARE THERE BACK-UPS?","QUANTITY OF BACK-UPS","PROJECT COST"]
[]
[]
[]
[]
[]
[]
[null,null,"How is the pump being controlled?"]
[]
[]
[]
[]
[null,null,null,null,"DOMESTIC HOT WATER HEATER"]
[]
[null,null,"LOCATION","EXISTING  WATER HEATER FUEL","EXISTING HOT WATER HEATER TYPE","AGE","SIZE (MBTUH)","INDIVIDUAL OR CENTRAL SYSTEM","QUANTITY","PROPOSED HOT WATER HEATER TYPE","SIZE (MBTUH)","EFFICIENCY","MANUFACTURER & MODEL NUMBER","INDIVIDUAL OR CENTRAL SYSTEM","QUANTITY","PROJECT COST"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"DOMESTIC HOT WATER CIRCULATOR PUMPS"]
[]
[null,null,"LOCATION","EXISTING HOT WATER HEATER PUMPS TYPE","AGE","SIZE (HP)","QUANTITY","ARE THERE BACK-UP PUMPS?","QUANTITY OF BACK-UPS","PROPOSED HOT WATER HEATER PUMPS TYPE","SIZE (HP)","EFFICIENCY","MANUFACTURER & MODEL NUMBER","QUANTITY","PROJECT COST"]
[]
[]
[]
[]
[]
[null,null,"How is the pump being controlled?"]
[]
[]
[]
[null,null,null,null,"COOLING SYSTEM"]
[]
[null,null,"LOCATION","EXISTING COOLING SYSTEM TYPE","INDIVIDUAL OR CENTRAL SYSTEM","AGE","SIZE (BTUH)","QUANTITY","PROPOSED COOLING TYPE","INDIVIDUAL OR CENTRAL SYSTEM","SIZE (BTUH)","EFFICIENCY (SEER/EER)","MANUFACTURER & MODEL NUMBER","QUANTITY","PROJECT COST"]
[]
[]
[]
[]
[]
[null,null,"Heat Pumps - What is the control strategy for back up heat?"]

{"sheet":"Smart Thermostats","index":12,"n_rows":11,"n_cols":9,"rows_kept":11,"cut":false,"hidden":true,"merged":[[1,4,3,10],[8,3,9,7]]}
[]
[null,null,null,null,{"$f":"'Step 1 - Project Info'!$C$3&\" - \"&'Step 1 - Project Info'!$C$7","v":" - "}]
[]
[]
[]
[]
[]
[]
[null,null,null,"Smart Thermostats"]
[]
[null,null,"LOCATION TYPE (dwelling unit/common area)","QUANTITY","MANUFACTURER","MODEL NUMBER","CENTRAL AC SYSTEM (Yes/No)","EXISTING HEATING SYSTEM TYPE","PROJECT COST (Labor & Material)"]

{"sheet":"Custom Measure","index":13,"n_rows":9,"n_cols":13,"rows_kept":9,"cut":false,"hidden":true,"merged":[[6,5,7,8],[1,2,2,8]]}
[]
[null,null,{"$f":"'Step 1 - Project Info'!$C$3&\" - \"&'Step 1 - Project Info'!$C$7","v":" - "}]
[]
[]
[]
[]
[null,null,null,null,null,"Custom Measure Details"]
[]
[null,"LOCATION","EXISTING MEASURE","MODEL NUMBER","AGE","ADDITIONAL DETAIL ON EXISTING MEASURE","ADDITIONAL DETAIL ON EXISTING MEASURE","Existing Measure Quantity","PROPOSED MEASURE","ADDITIONAL DETAIL ON EXISTING MEASURE","ADDITIONAL DETAIL ON EXISTING MEASURE","Proposed Measure Quantity","PROJECT COST"]