{"text_format":"1","workbook":"xlsx","n_sheets":16,"sheets":["Step 1 - Project Info","Core Services - Unit Matrix","Air Sealing (Blower Door)","Duct Sealing","Low Flow DHW","Dwelling Unit Lighting","Common and Exterior Lighting","Lighting Summary","Insulation","Window Replacements","Refrigerator Replacements","HVAC","Drop Down List","Custom Measure","Building Oil or Propane Usage","Dropdown"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":1,"defined_names":15,"comments":1,"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":67,"n_cols":5,"rows_kept":67,"cut":false,"hidden":false,"merged":[[50,0,50,1],[0,1,0,2],[1,1,1,2]]}
["Multifamily Initiative Project Fill Out From"]
["Rev. 2016.03.24","PROJECT INFO"]
[null,"Property Name","Winem Apartments"]
[null,"Property Street Number","31"]
[null,"Property Street","Field St."]
[null,"Property Street Address Line 2"]
[null,"Property City","Ashford"]
[null,"Property Zip Code","06010"]
[null,"Customer Electric (Master) Account Number(s)"]
[null,"Customer Gas (Master) Account Number(s)"]
[null,"Customer Contact First Name (For LOA to be addressed to)","William"]
[null,"Customer Contact Last Name (For LOA to be addressed to)","Smith"]
[null,"Customer Contact Title","Director of Housing Management"]
[null,"Customer Company Name","Housing Care LLC"]
[null,"Customer Contact Phone Number","8605419852"]
[null,"Customer E-mail Address"]
[null,"Customer Street Number (if different)"]
[null,"Customer Street (if different)"]
[null,"Customer City (if different)"]
[null,"Customer Zip Code (if different)"]
[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 number of weeks project will take to complete once LOA is executed"]
[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","Multifamily Low-Rise Apartments"]
[null,"Number of dwelling units in project",30,null," "]
[null,"Heating Fuel","Electric"]
[null,"DHW Fuel","Electric"]
[null,"Cooling System","None"]
[null,"Heating Utility","None"]
[null,"Electric Utility","None"]
["Note: select yes for measures being proposed"]
[null,"Property Energy Efficiency Upgrades","Proposed","Reason For Not Considering","Heath and Safety Issue"]
[1,"Air Sealing (Blower Door)"]
[2,"Duct Sealing"]
[3,"Water Measures"]
[4,"Dwelling Unit Lighting"]
[5,"Common and Exterior Lighting"]
[6,"Insulation"]
[7,"Window Replacements"]
[8,"Refrigerators Replacement"]
[9,"HVAC"]
[10,"Custom Measure"]
[11,"None"]
[12,"None"]
[13,"None"]
[14,"None"]
[15,"None"]

{"sheet":"Core Services - Unit Matrix","index":1,"n_rows":39,"n_cols":10,"rows_kept":39,"cut":false,"hidden":false,"merged":[[0,0,0,14]]}
[{"$f":"'Step 1 - Project Info'!$C$3&\" - \"&'Step 1 - Project Info'!$C$7","v":"Winem Apartments - Ashford"}]
[]
["Instructions"]
["Core services includes the following dwelling unit measures assessed and implemented by a weatherization contractor*: air sealing, duct sealing, water conservation (e.g., low flow shower heads, faucet aerators, pipe wrap), and light bulbs."]
["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 core 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","Water Conservation","Dwelling Unit Lighting",null,null,{"$f":"IF(C19<>\"\",IF('Step 1 - Project Info'!$C$53<>\"\",IF('Step 1 - Project Info'!$C$53=\"Yes\",\"Air Sealing\",None),\"\"),\"\")","v":""}]
[null,null,"Unit 101","Air Sealing","Duct Sealing","Water Conservation","Dwelling Unit Lighting"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["*If your project has any of the core services measures specified and you are not using a certified weatherization contractor, please complete the applicable Project Fillout Form tab(s)."]

{"sheet":"Air Sealing (Blower Door)","index":2,"n_rows":23,"n_cols":24,"rows_kept":23,"cut":false,"hidden":true,"merged":[[1,2,1,16],[6,12,6,14],[6,15,6,17],[6,18,6,20],[6,21,6,23],[5,12,5,23],[3,12,4,18],[3,6,4,11]]}
[]
[null,null,{"$f":"'Step 1 - Project Info'!$C$3&\" - \"&'Step 1 - Project Info'!$C$7","v":"Winem Apartments - Ashford"}]
[]
[null,null,"Total Number of Units",{"$f":"'Step 1 - Project Info'!C45","v":30},null,null,"Note: Units sample should be 10% of each unit type (# bedrooms/ Studios, Location (Top Corner, Top Middle, Bottom Corner, Bottom Middle, Mid Fl Corner, Mid Fl Center))",null,null,null,null,null,"Note: Provide before and after pictures of areas air sealed to get the post blower door results, Provide pictures of Manometer before and after readings. All picture files can be included in any form that is convenient to you (such as word, pdf, dropbox), however, it should be readable or visible by Eversource staff."]
[null,null,"Total Sample Units",{"$f":"COUNTA('Core Services - Unit Matrix'!C19:C36)","v":1}]
[null,null,"Name of Lead Technician w/ BPI Multifamily Certification ",null,null,null,null,null,null,null,null,null,"AIR SEALING DETAIL"]
[null,null,"Techician's BPI ID #",null,null,null,null,null,null,null,null,null,"(1) What was air sealed? Air sealing CFM reduction and location on exterior or interior wall",null,null,"(2) What was air sealed? Air sealing CFM reduction and location on exterior or interior wall",null,null,"(3) What was air sealed? Air sealing CFM reduction and location on exterior or interior wall",null,null,"(4) What was air sealed? Air sealing CFM reduction 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","Pre Blower Door CFM at 50 PA","Post Blower Door CFM at 50","CFM Reduction ","NOTES","What was Air Sealed?","Air Sealing CFM Reduction","Interior Wall, Exterior Wall, Interior Ceiling, Attic Floor, Basement Ceiling, Interior Ceiling, Basement Exterior walls, Other please specify:","What was Air Sealed?","Air Sealing CFM Reduction","Interior Wall, Exterior Wall, Interior Ceiling, Attic Floor, Basement Ceiling, Interior Ceiling, Basement Exterior walls, Other please specify:","What was Air Sealed?","Air Sealing CFM Reduction","Interior Wall, Exterior Wall, Interior Ceiling, Attic Floor, Basement Ceiling, Interior Ceiling, Basement Exterior walls, Other please specify:","What was Air Sealed?","Air Sealing CFM Reduction","Interior Wall, Exterior Wall, Interior Ceiling, Attic Floor, Basement Ceiling, Interior Ceiling, Basement Exterior walls, Other please specify:"]
[null,"EXAMPLE",{"$f":"IF('Core Services - Unit Matrix'!D19=\"Air Sealing\",'Core Services - Unit Matrix'!C19,\"\")","v":"Unit 101"},"Interior","1 BDRM","TOP FL",1100,1980,1000,800,200,null,"bottom and top plate/ 35 CFM/ exterior wall",35,null,"Kitchen sink penetration",10,"interior wall","bathroom exhaust vent",12,"attic ceiling","bathroom exhaust vent","bathroom exhaust vent","bathroom exhaust vent"]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!D20=\"Air Sealing\",'Core Services - Unit Matrix'!C20,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!D21=\"Air Sealing\",'Core Services - Unit Matrix'!C21,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!D22=\"Air Sealing\",'Core Services - Unit Matrix'!C22,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!D23=\"Air Sealing\",'Core Services - Unit Matrix'!C23,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!D24=\"Air Sealing\",'Core Services - Unit Matrix'!C24,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!D25=\"Air Sealing\",'Core Services - Unit Matrix'!C25,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!D26=\"Air Sealing\",'Core Services - Unit Matrix'!C26,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!D27=\"Air Sealing\",'Core Services - Unit Matrix'!C27,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!D28=\"Air Sealing\",'Core Services - Unit Matrix'!C28,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!D29=\"Air Sealing\",'Core Services - Unit Matrix'!C29,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!D30=\"Air Sealing\",'Core Services - Unit Matrix'!C30,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!D31=\"Air Sealing\",'Core Services - Unit Matrix'!C31,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!D32=\"Air Sealing\",'Core Services - Unit Matrix'!C32,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!D33=\"Air Sealing\",'Core Services - Unit Matrix'!C33,\"\")","v":""}]

{"sheet":"Duct Sealing","index":3,"n_rows":14,"n_cols":8,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
[{"$f":"\"Duct Blaster Testing - \" & 'Step 1 - Project Info'!C3","v":"Duct Blaster Testing - Winem Apartments"}]
[]
["Sample Apt #","Ductwork (Yes or No) / in condition or uncondition space","Bedroom type (Studio, 1BDRM, etc..)","Unit Locations (Top, Corner, Bottom, Middle)","SqFT of Unit","Pre Duct Blaster CFM at 25 PA","Post Duct Blaster CFM at 25","CFM Reduction "]
[{"$f":"IF('Core Services - Unit Matrix'!E19=\"Duct Sealing\",'Core Services - Unit Matrix'!C19,\"\")","v":"Unit 101"}]
[{"$f":"IF('Core Services - Unit Matrix'!E20=\"Duct Sealing\",'Core Services - Unit Matrix'!C20,\"\")","v":""}]
[{"$f":"IF('Core Services - Unit Matrix'!E21=\"Duct Sealing\",'Core Services - Unit Matrix'!C21,\"\")","v":""}]
[{"$f":"IF('Core Services - Unit Matrix'!E22=\"Duct Sealing\",'Core Services - Unit Matrix'!C22,\"\")","v":""}]
[{"$f":"IF('Core Services - Unit Matrix'!E23=\"Duct Sealing\",'Core Services - Unit Matrix'!C23,\"\")","v":""}]
[{"$f":"IF('Core Services - Unit Matrix'!E24=\"Duct Sealing\",'Core Services - Unit Matrix'!C24,\"\")","v":""}]
[{"$f":"IF('Core Services - Unit Matrix'!E25=\"Duct Sealing\",'Core Services - Unit Matrix'!C25,\"\")","v":""}]
[{"$f":"IF('Core Services - Unit Matrix'!E26=\"Duct Sealing\",'Core Services - Unit Matrix'!C26,\"\")","v":""}]
[{"$f":"IF('Core Services - Unit Matrix'!E27=\"Duct Sealing\",'Core Services - Unit Matrix'!C27,\"\")","v":""}]
[{"$f":"IF('Core Services - Unit Matrix'!E28=\"Duct Sealing\",'Core Services - Unit Matrix'!C28,\"\")","v":""}]
[{"$f":"IF('Core Services - Unit Matrix'!E29=\"Duct Sealing\",'Core Services - Unit Matrix'!C29,\"\")","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":"Winem Apartments - Ashford"}]
[]
[]
[null,null,null,null,"WATER MEASURES","Quantity","Cost per Measure","Total Cost"]
[null,null,null,null,"Hand Held Showerhead",null,null,{"$f":"G7*F7","v":0}]
["Flip & Swivel Aerator",null,null,null,"Install Low-Flow Showerhead",null,null,{"$f":"G8*F8","v":0}]
["Hand Held Showerhead",null,null,null,"Install Low- Flow Aerator",null,null,{"$f":"G9*F9","v":0}]
["Install Low- Flow Aerator",null,null,null,"Flip & Swivel Aerator",null,null,{"$f":"G10*F10","v":0}]
["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":"IF('Core Services - Unit Matrix'!F19=\"Water Conservation\",'Core Services - Unit Matrix'!C19,\"\")","v":"Unit 101"}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!F20=\"Water Conservation\",'Core Services - Unit Matrix'!C20,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!F21=\"Water Conservation\",'Core Services - Unit Matrix'!C21,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!F22=\"Water Conservation\",'Core Services - Unit Matrix'!C22,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!F23=\"Water Conservation\",'Core Services - Unit Matrix'!C23,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!F24=\"Water Conservation\",'Core Services - Unit Matrix'!C24,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!F25=\"Water Conservation\",'Core Services - Unit Matrix'!C25,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!F26=\"Water Conservation\",'Core Services - Unit Matrix'!C26,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!F27=\"Water Conservation\",'Core Services - Unit Matrix'!C27,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!F28=\"Water Conservation\",'Core Services - Unit Matrix'!C28,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!F29=\"Water Conservation\",'Core Services - Unit Matrix'!C29,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!F30=\"Water Conservation\",'Core Services - Unit Matrix'!C30,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!F31=\"Water Conservation\",'Core Services - Unit Matrix'!C31,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!F32=\"Water Conservation\",'Core Services - Unit Matrix'!C32,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!F33=\"Water Conservation\",'Core Services - Unit Matrix'!C33,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!F34=\"Water Conservation\",'Core Services - Unit Matrix'!C34,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!F35=\"Water Conservation\",'Core Services - Unit Matrix'!C35,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!F36=\"Water Conservation\",'Core Services - Unit Matrix'!C36,\"\")","v":""}]

{"sheet":"Dwelling Unit Lighting","index":5,"n_rows":176,"n_cols":16,"rows_kept":176,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,"Date",null,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":"Winem Apartments"},null,null,null,null,null,null,null,null,null,null,"Efficiency/ Studio",{"$f":"'Core Services - 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":"31 Field St. Ashford"},null,null,null,"Apartment Number",null,null,null,null,null,null,"1 Bedrooms",{"$f":"'Core Services - Unit Matrix'!B12","v":0}]
[null,null,"Building Number",null,null,null,null,"# of Bedrooms",null,null,null,null,null,null,"2 Bedrooms",{"$f":"'Core Services - Unit Matrix'!B13","v":0}]
[null,null,"See notes below",null,null,null,null,null,null,null,null,null,null,null,"3 Bedrooms",{"$f":"'Core Services - Unit Matrix'!B14","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4 Bedrooms",{"$f":"'Core Services - 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:"]
[null,null,null,"Unit type and Unit number"]
[null,"Example",null,"Example"]
["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":"IF('Core Services - Unit Matrix'!$G$19=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$19,\"\")","v":"Unit 101"}]
[null,"Example",{"$f":"IF('Core Services - Unit Matrix'!$G$19=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$19,\"\")","v":"Unit 101"},"Bedroom","CFL",13,2,"drum",1,28,"New fixture","drum"]
[null,"Example",{"$f":"IF('Core Services - Unit Matrix'!$G$19=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$19,\"\")","v":"Unit 101"},"Hallway","Inc",60,2,"drum",1,120,"New fixture","drum"]
[null,"Example",{"$f":"IF('Core Services - Unit Matrix'!$G$19=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$19,\"\")","v":"Unit 101"},"Living Room","CFL",13,2,"drum",1,28,"New fixture","drum"]
[null,"Example",{"$f":"IF('Core Services - Unit Matrix'!$G$19=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$19,\"\")","v":"Unit 101"},"Living Room","Inc",60,2,"table lamp",2,120,"Screw-in bulb","table lamp"]
[null,"Example",{"$f":"IF('Core Services - Unit Matrix'!$G$19=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$19,\"\")","v":"Unit 101"}]
[null,"Example",{"$f":"IF('Core Services - Unit Matrix'!$G$19=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$19,\"\")","v":"Unit 101"}]
[null,"Example",{"$f":"IF('Core Services - Unit Matrix'!$G$19=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$19,\"\")","v":"Unit 101"}]
[null,"Example",{"$f":"IF('Core Services - Unit Matrix'!$G$19=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$19,\"\")","v":"Unit 101"}]
[null,"Example",{"$f":"IF('Core Services - Unit Matrix'!$G$19=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$19,\"\")","v":"Unit 101"}]
[null,"Example",{"$f":"IF('Core Services - Unit Matrix'!$G$19=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$19,\"\")","v":"Unit 101"}]
[null,"Example",{"$f":"IF('Core Services - Unit Matrix'!$G$19=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$19,\"\")","v":"Unit 101"}]
[null,"Example",{"$f":"IF('Core Services - Unit Matrix'!$G$19=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$19,\"\")","v":"Unit 101"}]
[null,"Example",{"$f":"IF('Core Services - Unit Matrix'!$G$19=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$19,\"\")","v":"Unit 101"}]
[null,"Example",{"$f":"IF('Core Services - Unit Matrix'!$G$19=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$19,\"\")","v":"Unit 101"}]
[null,"Example",{"$f":"IF('Core Services - Unit Matrix'!$G$19=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$19,\"\")","v":"Unit 101"}]
[null,"Example"]
[null,"Example",{"$f":"IF('Core Services - Unit Matrix'!$G$20=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$20,\"\")","v":""}]
[null,"Example",{"$f":"IF('Core Services - Unit Matrix'!$G$20=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$20,\"\")","v":""},"Kitchen","CFL",13,2,"drum",1,28,"New fixture","drum",1,23,"LED23TM8"]
["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":"IF('Core Services - Unit Matrix'!$G$20=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$20,\"\")","v":""},"Bedroom 1","CFL",13,2,"drum",1,28,null,"drum"]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$20=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$20,\"\")","v":""},"Bathroom 1 - Ceiling","CFL",13,2,"drum",1,28,null,"drum"]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$20=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$20,\"\")","v":""},"Front Exterior Entry","Inc",60,2,"table lamp",2,120,"Screw-in bulb","table lamp"]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$20=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$20,\"\")","v":""},"Hall Way","None"]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$20=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$20,\"\")","v":""},"Closet","CFL",13,2,"drum",1,28,null,"drum"]
[null,"Example",{"$f":"IF('Core Services - Unit Matrix'!$G$20=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$20,\"\")","v":""},"Kitchen - Sink","Inc",60,2,"drum",1,120,null,"drum"]
[null,"Example",{"$f":"IF('Core Services - Unit Matrix'!$G$20=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$20,\"\")","v":""},"Living Room - Ceiling Fan"]
[null,"Example",{"$f":"IF('Core Services - Unit Matrix'!$G$20=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$20,\"\")","v":""},"Living Room- Floor Lamp","Inc",60,1,"floor lamp",2,60,"Screw-in bulb","floor lamp"]
[null,"Example",{"$f":"IF('Core Services - Unit Matrix'!$G$20=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$20,\"\")","v":""},"Dining Room"]
[null,"Example",{"$f":"IF('Core Services - Unit Matrix'!$G$20=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$20,\"\")","v":""},"Dining Room - Table Lamp","Inc",60,2,"table lamp",2,120,"Screw-in bulb","table lamp"]
[null,"Example",{"$f":"IF('Core Services - Unit Matrix'!$G$20=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$20,\"\")","v":""},"Bedroom 1","None"]
[null,"Example",{"$f":"IF('Core Services - Unit Matrix'!$G$20=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$20,\"\")","v":""},"Hall Way","None"]
[null,"Example",{"$f":"IF('Core Services - Unit Matrix'!$G$20=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$20,\"\")","v":""},"Closet","None"]
[null,"Example",{"$f":"IF('Core Services - Unit Matrix'!$G$20=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$20,\"\")","v":""},"Pantry","None"]
[null,"Example"]
[null,"Example",{"$f":"IF('Core Services - Unit Matrix'!$G$21=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$21,\"\")","v":""}]
[null,"Example",{"$f":"IF('Core Services - Unit Matrix'!$G$21=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$21,\"\")","v":""},"Kitchen","CFL",13,2,"drum",1,28,"New fixture","drum",1,23,"LED23TM8"]
[null,"Example",{"$f":"IF('Core Services - Unit Matrix'!$G$21=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$21,\"\")","v":""},"Kitchen - Sink","Inc",60,2,"drum",1,120,null,"drum"]
[null,"Example",{"$f":"IF('Core Services - Unit Matrix'!$G$21=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$21,\"\")","v":""},"Living Room - Ceiling Fan","None"]
[null,"Example",{"$f":"IF('Core Services - Unit Matrix'!$G$21=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$21,\"\")","v":""},"Living Room- Floor Lamp","Inc",60,1,"floor lamp",2,60,"Screw-in bulb","floor lamp"]
[null,"Example",{"$f":"IF('Core Services - Unit Matrix'!$G$21=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$21,\"\")","v":""},"Dining Room","None"]
[null,"Example",{"$f":"IF('Core Services - Unit Matrix'!$G$21=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$21,\"\")","v":""},"Dining Room - Table Lamp","Inc",60,2,"table lamp",2,120,"Screw-in bulb","table lamp"]
[null,"Example",{"$f":"IF('Core Services - Unit Matrix'!$G$21=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$21,\"\")","v":""},"Bedroom 1","CFL",13,2,"drum",1,28,null,"drum"]
[null,"Example",{"$f":"IF('Core Services - Unit Matrix'!$G$21=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$21,\"\")","v":""},"Bedroom 2","CFL",13,2,"drum",1,28,null,"drum"]
[null,"Example",{"$f":"IF('Core Services - Unit Matrix'!$G$21=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$21,\"\")","v":""},"Bedroom 2 - Table Lamp","Inc",60,2,"table lamp",2,120,"Screw-in bulb","table lamp"]
[null,"Example",{"$f":"IF('Core Services - Unit Matrix'!$G$21=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$21,\"\")","v":""},"Hall Way","None"]
[null,"Example",{"$f":"IF('Core Services - Unit Matrix'!$G$21=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$21,\"\")","v":""},"Closet","CFL",13,2,"drum",1,28,null,"drum"]
[null,"Example",{"$f":"IF('Core Services - Unit Matrix'!$G$21=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$21,\"\")","v":""},"Pantry","None"]
[null,"Example",{"$f":"IF('Core Services - Unit Matrix'!$G$21=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$21,\"\")","v":""},"Garage","CFL",13,2,"drum",1,28,null,"drum"]
[null,"Example",{"$f":"IF('Core Services - Unit Matrix'!$G$21=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$21,\"\")","v":""},"Basement","None"]
[null,"Example",{"$f":"IF('Core Services - Unit Matrix'!$G$21=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$21,\"\")","v":""},"Bathroom 1 - Ceiling","CFL",13,2,"drum",1,26,"New fixture","drum"]
[null,"Example"]
[null,"Example",{"$f":"IF('Core Services - Unit Matrix'!$G$22=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$22,\"\")","v":""}]
[null,"Example",{"$f":"IF('Core Services - Unit Matrix'!$G$22=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$22,\"\")","v":""},"Kitchen","Inc",60,2,"drum",1,120,null,"drum"]
[null,"Example",{"$f":"IF('Core Services - Unit Matrix'!$G$22=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$22,\"\")","v":""},"Kitchen","4'T12",34,2,"troffer",1,74,null,"troffer"]
[null,"Example",{"$f":"IF('Core Services - Unit Matrix'!$G$22=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$22,\"\")","v":""},"Kitchen","4'T12",34,2,"troffer",2,74,null,"troffer"]
[null,"Example",{"$f":"IF('Core Services - Unit Matrix'!$G$22=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$22,\"\")","v":""},"Bedroom 1"]
[null,"Example",{"$f":"IF('Core Services - Unit Matrix'!$G$22=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$22,\"\")","v":""},"Bedroom 2"]
[null,"Example",{"$f":"IF('Core Services - Unit Matrix'!$G$22=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$22,\"\")","v":""},"Bathroom"]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$22=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$22,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$22=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$22,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$22=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$22,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$22=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$22,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$22=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$22,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$22=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$22,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$22=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$22,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$22=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$22,\"\")","v":""}]
[]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$23=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$23,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$23=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$23,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$23=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$23,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$23=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$23,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$23=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$23,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$23=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$23,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$23=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$23,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$23=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$23,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$23=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$23,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$23=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$23,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$23=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$23,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$23=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$23,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$23=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$23,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$23=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$23,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$23=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$23,\"\")","v":""}]
[]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$24=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$24,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$24=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$24,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$24=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$24,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$24=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$24,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$24=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$24,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$24=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$24,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$24=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$24,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$24=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$24,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$24=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$24,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$24=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$24,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$24=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$24,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$24=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$24,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$24=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$24,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$24=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$24,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$24=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$24,\"\")","v":""}]
[]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$25=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$25,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$25=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$25,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$25=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$25,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$25=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$25,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$25=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$25,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$25=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$25,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$25=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$25,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$25=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$25,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$25=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$25,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$25=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$25,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$25=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$25,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$25=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$25,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$25=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$25,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$25=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$25,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$25=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$25,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$25=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$25,\"\")","v":""}]
[]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$26=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$26,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$26=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$26,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$26=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$26,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$26=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$26,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$26=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$26,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$26=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$26,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$26=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$26,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$26=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$26,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$26=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$26,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$26=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$26,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$26=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$26,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$26=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$26,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$26=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$26,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$26=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$26,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$26=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$26,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$26=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$26,\"\")","v":""}]
[]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$27=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$27,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$27=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$27,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$27=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$27,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$27=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$27,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$27=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$27,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$27=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$27,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$27=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$27,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$27=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$27,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$27=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$27,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$27=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$27,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$27=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$27,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$27=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$27,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$27=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$27,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$27=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$27,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$27=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$27,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$27=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$27,\"\")","v":""}]
[]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$28=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$28,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$28=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$28,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$28=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$28,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$28=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$28,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$28=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$28,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$28=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$28,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$28=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$28,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$28=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$28,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$28=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$28,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$28=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$28,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$28=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$28,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$28=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$28,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$28=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$28,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$28=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$28,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$28=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$28,\"\")","v":""}]
[null,null,{"$f":"IF('Core Services - Unit Matrix'!$G$28=\"Dwelling Unit Lighting\",'Core Services - Unit Matrix'!$C$28,\"\")","v":""}]

{"sheet":"Common and Exterior Lighting","index":6,"n_rows":124,"n_cols":15,"rows_kept":124,"cut":false,"hidden":true,"merged":[[1,3,3,10],[1,11,3,12],[1,13,1,14],[2,13,2,14],[3,13,3,14]]}
[]
[null,null,null,{"$f":"'Step 1 - Project Info'!$C$3&\" - \"&'Step 1 - Project Info'!$C$7","v":"Winem Apartments - Ashford"},null,null,null,null,null,null,null,"Company and Auditor Name"]
[]
[]
[]
[]
[null,"Area Description","Qty Before","Description Before","Watts/ Fixture Before","Annual Hours Before","Item Type - Select From Picklist","Lighting Group Type - Select From Picklist ","Qty After","Description After","Watts/ Fixture After","Annual Hours After","Material Cost","Labor Cost","Total Cost/ Group"]
["Example","Exterior Pole Lights",465,"70W High Pressure Sodium",95,4004,"Retrofit fixture","High- Performance Exterior",250,"20W LED Corn Bulb",20,5000,50,50,{"$f":"IF(G8=\"Non-Eligible\",0,(I8*(N8+M8)))","v":25000}]
[null,null,null,null,null,560,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,{"$f":"IF(G9=\"Non-Eligible\",0,(I9*(N9+M9)))","v":0}]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
["Example","Exterior Pole Lights",70,"70W High Pressure Sodium",95,4004,"Retrofit fixture","High- Performance Exterior",null,"NA",null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,{"$f":"IF(G73=\"Non-Eligible\",0,(I73*(N73+M73)))","v":0}]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Retrofit fixture","High- Performance Exterior",null,null,null,null,null,null,0]

{"sheet":"Lighting Summary","index":7,"n_rows":42,"n_cols":10,"rows_kept":42,"cut":false,"hidden":true,"merged":[[2,3,4,7],[6,2,8,8]]}
[]
[]
[null,null,null,{"$f":"'Step 1 - Project Info'!$C$3&\" - \"&'Step 1 - Project Info'!$C$7","v":"Winem Apartments - Ashford"}]
[]
[]
[null,null,null,"Note: PLEASE SPECIFY MISCELLANEOUS COST ASSOCIATED WITH LIGHTING INSTALLATION"]
[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","Incandescent Bulb",60,"A-Line",10,390,"Bedroom",3,3,{"$f":"(H12+I12)*F12","v":2340}]
["Example","Incandescent Bulb",40,"Globe",8,217,"Bathroom",3,3,{"$f":"(H13+I13)*F13","v":1302}]
["Example","Incandescent Bulb",60,"CFL",13,260,"Closet",3,3,1560]
["Example","Incandescent Bulb",60,"A-Line",10,390,"Living room",3,3,2340]
["Example","Incandescent Bulb",40,"Globe",8,217,"Dining Room",3,3,1302]
["Example","Incandescent Bulb",60,"CFL",13,260,"HallWay",3,3,1560]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(J12:J18)","v":10404}]
[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":"(H21+I21)*F21","v":19500}]
["Example","Incandescent Drum",80,"LED DC015",8,217,"Bathroom",25,25,{"$f":"(H22+I22)*F22","v":10850}]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(J21:J26)","v":30350}]
[]
[]
[null,"Common Area"]
[null,"Existing Fixture or Bulb Name","Existing Fixture or Bulb Wattage","Recommended Fixture or BulbsName/ Model","Wattage","Quantity","Location","Material cost","Labor  Cost","Total Cost "]
["Example","Incandescent Bulb",60,"RAB WLED35",41,390,"Exterior BLDG 2",80,100,{"$f":"(H32+I32)*F32","v":70200}]
["Example","Incandescent Bulb",40,"DC014 LED",8,217,"Common Area Hallway BLDG 3",80,27,{"$f":"(H33+I33)*F33","v":23219}]
["Example","Incandescent Bulb",60,"RAB WLED37",41,260,"Exterior BLDG 4",80,100,46800]
["Example","Incandescent Bulb",60,"RAB WLED38",41,390,"Exterior BLDG 5",80,100,70200]
["Example","Incandescent Bulb",40,"RAB WLED39",41,217,"Exterior BLDG 6",80,100,39060]
["Example","Incandescent Bulb",60,"RAB WLED40",41,260,"Exterior BLDG 7",80,100,46800]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(J32:J41)","v":296279}]

{"sheet":"Insulation","index":8,"n_rows":20,"n_cols":11,"rows_kept":20,"cut":false,"hidden":true,"merged":[[19,3,19,4],[17,3,17,4],[18,3,18,4],[16,3,16,4],[2,4,4,9]]}
[]
[]
[null,null,null,null,{"$f":"'Step 1 - Project Info'!$C$3&\" - \"&'Step 1 - Project Info'!$C$7","v":"Winem Apartments - Ashford"}]
[]
[]
[]
[null,null,null,"LOCATION","SQUARE FOOTAGE BEING INSULATED","Existing Insulation Type","Existing Insulation Thickness Inches","Existing Insulation R-value","Proposed Insulation Type","Proposed Insulation Installed R-value","Proposed Project Cost"]
[null,"Attic"]
[null,"Roof line/ Vaulted Ceiling"]
[null,"Foundation wall"]
[null,"Basement Ceiling"]
[null,"Exterior Wall"]
[null,"Crawlspace Wall"]
[null,"Crawlspace Ceiling"]
[null,"Rim Joist"]
[null,"Attic Hatch Cover "]
[null,"Attic Pull Down Stairs Cover ",null,null,null,"COST"]
[null,"Attic Whole House Fan Cover ",null,"ADDITIONAL INSULATION AND AIR SEALING MEASURES"]
[null,null,null,"PROP VENTS"]
[null,null,null,"AIR SEALING ENTRY WAYS (ATTIC HATCH, CRAWLSPACE,"]

{"sheet":"Window Replacements","index":9,"n_rows":20,"n_cols":14,"rows_kept":20,"cut":false,"hidden":true,"merged":[[1,5,3,10]]}
[]
[null,null,null,null,null,{"$f":"'Step 1 - Project Info'!$C$3&\" - \"&'Step 1 - Project Info'!$C$7","v":"Winem Apartments - Ashford"}]
[]
[]
[]
[]
[null,null,null,"EXISTING WINDOW TYPES","PROPOSED MANUFACTURER AND MODEL NUMBER","CPD NUMBER","WIDTH","LENGTH","QUANTITY"," TOTAL AREA","PROPOSED WINDOW TYPE","PROPOSED WINDOW MATERIAL COST","PROPOSED WINDOW LABOR COST","TOTAL COST"]
[null,"Single Pane",null,"Single Pane",null,null,null,null,null,{"$f":"G8*H8*I8","v":0}]
[null,"Double Pane",null,null,null,null,null,null,null,{"$f":"G9*H9*I9","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"G10*H10*I10","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"G11*H11*I11","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"G12*H12*I12","v":0}]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,{"$f":"G18*H18*I18","v":0}]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]

{"sheet":"Refrigerator Replacements","index":10,"n_rows":15,"n_cols":12,"rows_kept":15,"cut":false,"hidden":true,"merged":[[1,2,1,11],[2,8,2,11],[2,3,2,7]]}
[]
[null,null,{"$f":"'Step 1 - Project Info'!$C$3&\" - \"&'Step 1 - Project Info'!$C$7","v":"Winem Apartments - Ashford"}]
[null,null,null,"Existing Units",null,null,null,null,"Proposed Units"]
[null,null,"Unit #","Age","Make","Size","Model","KWH","Model","Size"," KWH","Cost"]
[null,"Example","A101","15 yrs","Hotpoint",14,"CTH14CYBRLWW",499,"FFHT1513LW",15,355,574]
[]
[]
[]
[]
[null,null," "," "," "," "," "," "," "," "," "," "]
[null,null,null,null,null,null,null,{"$f":"SUM(H5:H9)","v":499},null,null,{"$f":"SUM(K5:K9)","v":355},{"$f":"SUM(L5:L9)","v":574}]
[]
[null,null,null,null,null,null,"∆kWh = ",{"$f":"H11-K11","v":144}]
[null,null,null,null,null,null,"Est. Savings = "]
[null,null,null,null,null,null,"Est. Payback = "]

{"sheet":"HVAC","index":11,"n_rows":72,"n_cols":15,"rows_kept":72,"cut":false,"hidden":true,"merged":[[68,5,68,9],[47,7,48,10],[59,7,60,10],[16,3,17,4],[18,3,18,4],[67,3,68,4],[29,3,30,4],[31,3,31,4],[55,3,56,4],[57,3,57,4],[1,5,3,12],[8,7,9,10],[20,7,21,10],[34,7,35,10],[67,5,67,9]]}
[]
[null,null,null,null,null,{"$f":"'Step 1 - Project Info'!$C$3&\" - \"&'Step 1 - Project Info'!$C$7","v":"Winem Apartments - Ashford"}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"HEATING SYSTEM"]
[]
[null,null,null,"LOCATION","EXISTING HEATING SYSTEM TYPE","MODEL NUMBER","AGE","EXISTING SIZE (INPUT MBTU)","Individual or Central System","Quantity","PROPOSED HEATING TYPE","SIZE (INPUT MBTU)","PROPOSED EFFICIENCY (AFUE or HSPF)","Quantity","PROJECT COST"]
[null,"Electric Heater"]
[null,"Gas Boiler"]
[null,"Condensing Gas Boiler"]
[null,"Oil Boiler"]
[null,"HydroAir"]
[null,"Propane Boiler",null,"Is there a indirect hot water system working with the existing boiler?"]
[null,"Electric Furnace"]
[null,"Gas Furnace"]
[null,"Condensing Gas Furnace"]
[null,"Oil Furnace",null,null,null,null,null,"HEATING SYSTEM PUMPS"]
[null,"Propane Furnace"]
[null,"Ductless MiniSplit",null,"LOCATION","EXISTING HEATING SYSTEM PUMPS TYPE",null,"AGE","SIZE (HP)","Individual or Central System","Quantity","PROPOSED HEATING SYSTEM PUMPS TYPE","SIZE (HP)","EFFICIENCY","Quantity","PROJECT COST"]
[null,"Ducted Heat Pumps",null,null,"CONSTANT VOLUME"]
[]
[]
[]
[null,"CONSTANT VOLUME"]
[null,"VARIABLE SPEED"]
[null,null,null,"How is the pump being controlled?"]
[]
[]
[null,"Individual"]
[null,"Central"]
[null,null,null,null,null,null,null,"DOMESTIC HOT WATER HEATER"]
[]
[null,null,null,"LOCATION","EXISTING HOT WATER HEATER TYPE","Indirect/ Storage/ Instantaneous","AGE","SIZE (MBTU)","Individual or Central System","Quantity","PROPOSED HOT WATER HEATER TYPE","SIZE (MBTU)","EFFICIENCY","Quantity","PROJECT COST"]
[null,"Electric Water Heater"]
[null,"Heat Pump Water Heater"]
[null,"Gas Water Heater"]
[null,"Oil Water Heater "]
[null,"Propane Water Heater"]
[]
[null,"Indirect"]
[null,"Storage"]
[null,"Instananeous"]
[]
[null,null,null,null,null,null,null,"DOMESTIC HOT WATER HEATER CIRCULATOR PUMPS"]
[]
[null,null,null,"LOCATION","EXISTING HOT WATER HEATER PUMPS TYPE",null,"AGE","SIZE (HP)",null,"Quantity","PROPOSED HOT WATER HEATER PUMPS TYPE","SIZE (HP)","EFFICIENCY","Quantity","PROJECT COST"]
[]
[]
[]
[]
[null,"Pressure"]
[null,"Temperature",null,"How is the pump being controlled?"]
[]
[]
[]
[null,null,null,null,null,null,null,"COOLING SYSTEM"]
[]
[null,null,null,"LOCATION","EXISTING COOLING SYSTEM TYPE",null,"AGE","SIZE (TONS)","Individual or Central System","Quantity","PROPOSED COOLING TYPE","SIZE (BTUH)","EFFICIENCY (SEER/EER)","Quantity","PROJECT COST"]
[null,"PACKAGED DX"]
[null,"CHILLER PLANT"]
[null,"DUCTLESS MINI SPLIT"]
[null,"DX SPLIT"]
[null,"DX HP "]
[null,"AIR SOURCE HEAT PUMP",null,"For Heat Pumps is there a control strategy for back up heat?",null,"Notes"]
[null,"WATERSOURCE HEAT PUMP"]
[null,"GROUND SOURCE HEAT PUMP"]
[null,"WINDOW UNIT"]
[null,"GEOTHERMAL HEAT PUMP"]

{"sheet":"Drop Down List","index":12,"n_rows":22,"n_cols":6,"rows_kept":22,"cut":false,"hidden":true,"merged":[]}
["recessed","recessed"]
["drum","drum","New fixture",null,null,"High- Performance Exterior"]
["wrap","wrap","Retrofit fixture",null,null,"High- Performance Exterior"]
["troffer","troffer","Screw-in bulb",null,null,"Standard Interior"]
["sconce","sconce","Ineligible",null,null,"Standard Exterior"]
["jelly jar","jelly jar","No recommendation"]
["square","square"]
["cloud","cloud"]
["strip","strip"]
["vanity","vanity"]
["table lamp","table lamp"]
["floor lamp","floor lamp"]
["keyless","keyless"]
["plate","wallpack"]
["other","bollard"]
[null,"flood"]
[null,"canopy"]
[null,"acorn"]
[null,"Par Flood"]
[null,"shoebox"]
[null,"exit light"]
[null,"other"]

{"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":"Winem Apartments - Ashford"}]
[]
[]
[]
[]
[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"]

{"sheet":"Building Oil or Propane Usage","index":14,"n_rows":30,"n_cols":10,"rows_kept":30,"cut":false,"hidden":true,"merged":[[1,6,2,12]]}
[]
[null,null,null,null,null,null,{"$f":"'Step 1 - Project Info'!$C$3&\"-\"&'Step 1 - Project Info'!$C$7","v":"Winem Apartments-Ashford"}]
[]
[]
[]
[null,null,"Example",null,"Oil Usage Gallons",null,null,"Example",null,"Propane Usage Gallons"]
[null,null,"2013-01-15","2013-02-15",1500,null,null,"2013-01-15","2013-02-15",1500]
[null,null,"2013-02-15","2013-03-15",1000,null,null,"2013-02-15","2013-03-15",1000]
[null,null,"2013-03-15","2013-04-15",600,null,null,"2013-03-15","2013-04-15",600]
[null,null,"2013-04-15","2013-05-15",300,null,null,"2013-04-15","2013-05-15",300]
[null,null,"2013-05-15","2013-06-15",300,null,null,"2013-05-15","2013-06-15",300]
[null,null,"2013-06-15","2013-07-15",300,null,null,"2013-06-15","2013-07-15",300]
[null,null,"2013-07-15","2013-08-15",300,null,null,"2013-07-15","2013-08-15",300]
[null,null,"2013-08-15","2013-09-15",300,null,null,"2013-08-15","2013-09-15",300]
[null,null,"2013-09-15","2013-10-15",300,null,null,"2013-09-15","2013-10-15",300]
[null,null,"2013-10-15","2013-11-15",600,null,null,"2013-10-15","2013-11-15",600]
[null,null,"2013-11-15","2013-12-15",1000,null,null,"2013-11-15","2013-12-15",1000]
[null,null,"2013-12-15","2014-01-15",1500,null,null,"2013-12-15","2014-01-15",1500]
[null,null,"2014-01-15","2014-02-15",1500,null,null,"2014-01-15","2014-02-15",1500]
[null,null,"2014-02-15","2014-03-15",1000,null,null,"2014-02-15","2014-03-15",1000]
[null,null,"2014-03-15","2014-04-15",600,null,null,"2014-03-15","2014-04-15",600]
[null,null,"2014-04-15","2014-05-15",300,null,null,"2014-04-15","2014-05-15",300]
[null,null,"2014-05-15","2014-06-15",300,null,null,"2014-05-15","2014-06-15",300]
[null,null,"2014-06-15","2014-07-15",300,null,null,"2014-06-15","2014-07-15",300]
[null,null,"2014-07-15","2014-08-15",300,null,null,"2014-07-15","2014-08-15",300]
[null,null,"2014-08-15","2014-09-15",300,null,null,"2014-08-15","2014-09-15",300]
[null,null,"2014-09-15","2014-10-15",300,null,null,"2014-09-15","2014-10-15",300]
[null,null,"2014-10-15","2014-11-15",600,null,null,"2014-10-15","2014-11-15",600]
[null,null,"2014-11-15","2014-12-15",1000,null,null,"2014-11-15","2014-12-15",1000]
[null,null,"2014-12-15","2015-01-15",1500,null,null,"2014-12-15","2015-01-15",1500]

{"sheet":"Dropdown","index":15,"n_rows":163,"n_cols":10,"rows_kept":163,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,"Competitive Resources, Inc., 60 Church Street, Suite #2, Yalesville, CT 06492",null,"Andover","Carl Watts","Multifamily Low-Rise Apartments 1-3 stories","Air Sealing","None","Electric","Central AC"]
[null,"Energy Efficiencies Solutions, LLC, 398 Palisado Avenue, Windsor, CT 06095",null,"Ansonia","Dana Forrester","Multifamily Mid-Rise Apartments 4 - 5 stories","Duct Sealing","ALM ducts","Nat. Gas","Window AC"]
[null,"Handyman Express Energy Solutions, LLC, 1414 Barnum Avenue,Stratford, CT 06614",null,"Ashford","Sheldon Scott","Multifamily High-Rise Apartments 6 stories or more","Water Measures","ALM ducts and pipes","Prop. Gas","None"]
[null,"New England Smart Energy Group, LLC, 34 Sherman Court, Fairfield, CT 06824",null,"Avon","Natalia Sudyka","Multifamily Apartments","Dwelling Unit Lighting","ALM Pipes","Oil","Other"]
[null,"Santa Fuel, Inc., 154 Admiral Street, Bridgeport, CT 06605",null,"Barkhamsted","Enoch Lenge","Multifamily Townhouse","Common and Exterior Lighting","CO","Other"]
[null,"Action for Bridgeport Community Development, 1070 Park Avenue, Bridegeport, CT 06604",null,"Beacon Falls","Sheldon Scott","Multifamily Other","Insulation","Customer refused"]
[null,"The Access Agency, 1315 Main Street, Willimantic, CT 06226",null,"Berlin","Evan Seretan",null,"Window Replacements","Failed CAZ"]
[null,"Community Renewal Team, Inc., 555 Windsor Street, Hartford, CT 06120",null,"Bethany","Elizabeth Murphy",null,"Refrigerators Replacement","Failed wores case spillage"]
[null,"New Opportunities, Inc.",null,"Bethel",null,null,"HVAC","Gas leak customer side"]
[null,"Energy Resources Group Technologies, Inc.",null,"Bethlehem",null,null,"Custom Measure","Gas Leak Utility side"]
[null,"New Opportunities, Inc., 232 North Elm Street, Waterbury, CT 06702",null,"Bloomfield",null,null,null,"Gas leaks both sides"]
[null,null,null,"Bolton",null,null,null,"Lead"]
[null,"EVERSOURCE GAS",null,"Bozrah",null,null,null,"Mold"]
[null,"CNG GAS",null,"Branford",null,null,null,"MVG"]
[null,"SCG GAS",null,"Bridgeport",null,null,null,"Pest investation"]
[null,"OIL",null,"Bridgewater",null,null,null,"Vermiculite"]
[null,"PROPANE",null,"Bristol",null,null,"Air Sealing","Unvented gas appliance"]
[null,null,null,"Brookfield",null,null,"Air Source Heat Pump"]
[null,"UI ELECTRIC",null,"Brooklyn",null,null,"Boiler"]
[null,"EVERSOURCE ELECTRIC",null,"Burlington",null,null,"Central AC"]
[null,"OTHER",null,"Canaan",null,null,"Common and Exterior Lighting"]
[null,null,null,"Canterbury",null,null,"Controls"]
[null,"Market Rate",null,"Canton",null,null,"Customer refused"]
[null,"Income Eligible",null,"Chaplin",null,null,"Dwelling Unit Lighting Bulbs"]
[null,null,null,"Cheshire",null,null,"Dwelling Unit Lighting Fixtures"]
[null,null,null,"Chester",null,null,"Duct Sealing"]
[null,null,null,"Clinton",null,null,"ECM Pumps"]
[null,null,null,"Colchester",null,null,"Furnace"]
[null,null,null,"Colebrook",null,null,"Heat Pump Hot Water Heater"]
[null,null,null,"Columbia",null,null,"Hot Water Heater"]
[null,null,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,"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,"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,"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"]