{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Welcome","Project Workscope","Data Import","Measure Classification"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":20,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Welcome","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Project Workscope","index":1,"n_rows":112,"n_cols":13,"rows_kept":112,"cut":false,"hidden":false,"merged":[[9,12,10,13],[107,2,110,2],[67,2,70,2],[71,2,74,2],[75,2,78,2],[79,2,82,2],[83,2,86,2],[87,2,90,2],[91,2,94,2],[95,2,98,2],[99,2,102,2],[27,2,30,2],[31,2,34,2],[35,2,38,2],[39,2,42,2],[43,2,46,2],[47,2,50,2],[51,2,54,2],[55,2,58,2],[59,2,62,2],[91,3,94,3],[91,4,94,4],[91,5,94,5],[91,7,94,7],[103,0,106,0],[103,1,106,1],[103,3,106,3],[103,4,106,4],[103,5,106,5],[103,7,106,7],[103,6,106,6],[103,8,106,8],[103,9,106,9],[103,2,106,2],[99,0,102,0],[99,1,102,1],[99,3,102,3],[99,4,102,4],[99,5,102,5],[99,7,102,7],[99,6,102,6],[99,8,102,8],[99,9,102,9],[91,6,94,6],[91,8,94,8],[91,9,94,9],[95,0,98,0],[95,1,98,1],[95,3,98,3],[95,4,98,4],[95,5,98,5],[95,7,98,7],[95,6,98,6],[95,8,98,8],[95,9,98,9],[91,0,94,0],[91,1,94,1],[43,6,46,6],[43,8,46,8],[43,9,46,9],[47,6,50,6],[47,8,50,8],[47,9,50,9],[47,0,50,0],[47,1,50,1],[47,3,50,3],[43,0,46,0],[43,1,46,1],[43,3,46,3],[43,4,46,4],[43,5,46,5],[43,7,46,7],[47,4,50,4],[47,5,50,5],[47,7,50,7],[51,9,54,9],[55,0,58,0],[55,1,58,1],[55,3,58,3],[55,4,58,4],[55,5,58,5],[55,7,58,7],[59,0,62,0],[59,1,62,1],[59,3,62,3],[59,4,62,4],[59,5,62,5],[59,7,62,7],[63,2,66,2],[51,0,54,0],[51,1,54,1],[51,3,54,3],[51,4,54,4],[51,5,54,5],[51,7,54,7],[51,6,54,6],[51,8,54,8],[55,6,58,6],[63,4,66,4],[63,5,66,5],[63,0,66,0],[63,1,66,1],[63,3,66,3],[67,8,70,8],[67,9,70,9],[71,6,74,6],[71,8,74,8],[71,9,74,9],[59,6,62,6],[59,8,62,8],[59,9,62,9],[55,8,58,8],[55,9,58,9],[63,7,66,7],[63,6,66,6],[63,8,66,8],[63,9,66,9],[75,8,78,8],[75,9,78,9],[79,0,82,0],[79,1,82,1],[79,3,82,3],[79,4,82,4],[79,5,82,5],[79,7,82,7],[79,6,82,6],[79,8,82,8],[79,9,82,9],[75,4,78,4],[75,5,78,5],[75,7,78,7],[75,6,78,6],[71,0,74,0],[71,1,74,1],[71,3,74,3],[71,4,74,4],[71,5,74,5],[71,7,74,7],[67,0,70,0],[67,1,70,1],[67,3,70,3],[67,4,70,4],[67,5,70,5],[67,7,70,7],[67,6,70,6],[11,3,14,3],[11,4,14,4],[11,5,14,5],[11,7,14,7],[15,5,18,5],[15,0,18,0],[15,1,18,1],[15,3,18,3],[15,4,18,4],[11,0,14,0],[11,1,14,1],[8,0,10,0],[8,1,10,1],[8,3,10,3],[8,4,9,4],[8,5,10,5],[8,7,10,7],[8,6,10,6],[8,8,10,8],[8,2,10,2],[8,10,8,11],[9,10,10,11],[11,8,14,8],[11,9,14,9],[15,6,18,6],[15,8,18,8],[15,9,18,9],[35,4,38,4],[35,5,38,5],[35,7,38,7],[8,9,9,9],[19,9,22,9],[23,6,26,6],[23,8,26,8],[23,9,26,9],[19,6,22,6],[19,8,22,8],[15,7,18,7],[11,6,14,6],[19,0,22,0],[19,1,22,1],[19,3,22,3],[19,4,22,4],[19,5,22,5],[19,7,22,7],[23,0,26,0],[23,1,26,1],[23,3,26,3],[23,4,26,4],[23,5,26,5],[23,7,26,7],[19,2,22,2],[23,2,26,2],[11,2,14,2],[15,2,18,2],[27,8,30,8],[27,9,30,9],[35,6,38,6],[35,8,38,8],[35,9,38,9],[39,0,42,0],[39,1,42,1],[31,0,34,0],[31,1,34,1],[31,3,34,3],[27,0,30,0],[27,1,30,1],[27,3,30,3],[27,4,30,4],[27,5,30,5],[27,7,30,7],[31,4,34,4],[31,5,34,5],[31,7,34,7],[31,6,34,6],[39,3,42,3],[35,0,38,0],[35,1,38,1],[35,3,38,3],[111,0,111,3],[111,10,111,11],[107,6,110,6],[107,8,110,8],[107,9,110,9],[75,0,78,0],[75,1,78,1],[75,3,78,3],[107,0,110,0],[107,1,110,1],[107,3,110,3],[107,4,110,4],[107,5,110,5],[107,7,110,7],[83,0,86,0],[83,1,86,1],[83,3,86,3],[83,4,86,4],[83,5,86,5],[83,7,86,7],[83,6,86,6],[83,8,86,8],[83,9,86,9],[87,0,90,0],[111,12,111,13],[11,12,14,13],[15,12,18,13],[19,12,22,13],[23,12,26,13],[27,12,30,13],[31,12,34,13],[35,12,38,13],[39,12,42,13],[43,12,46,13],[47,12,50,13],[51,12,54,13],[55,12,58,13],[59,12,62,13],[63,12,66,13],[67,12,70,13],[71,12,74,13],[75,12,78,13],[79,12,82,13],[83,12,86,13],[87,12,90,13],[91,12,94,13],[95,12,98,13],[99,12,102,13],[103,12,106,13],[107,12,110,13],[2,2,2,8],[4,2,4,8],[5,0,5,1],[5,5,5,6],[8,12,8,13],[39,4,42,4],[39,5,42,5],[39,7,42,7],[39,6,42,6],[39,8,42,8],[87,1,90,1],[87,3,90,3],[87,4,90,4],[87,5,90,5],[87,7,90,7],[87,6,90,6],[87,8,90,8],[87,9,90,9],[39,9,42,9],[31,8,34,8],[31,9,34,9],[27,6,30,6]]}
["Project Workscope and Completion Status"]
[]
["Project Name:"]
[]
["Project Address:",null,{"$f":"'Data Import'!C7","v":" , NY "}]
["# of Units:",null,null,"# of Buildings:",null,null,null,"# of Stories:"]
[]
["Partner Progress To Date"]
["Measure Number","Measure Name","Measure Category","Measure Classification","Projected Source Energy Savings","Projected % Source Energy Savings","Previously Installed (Yes/No)","% Complete To Date ","% of Total Projected Energy Savings","Est. Energy Savings To Date","Summary of Progress ",null,"Summary of Progress"]
[null,null,null,null,null,null,null,null,null,null,"(indicate measure status )",null,"(Describe measure status in detail to justify % complete entered in column H.)"]
[null,null,null,null,"(MMBtu)",null,null,null,null,"(MMBtu)"]
[1,null,null,null,null,null,null,null,{"$f":"IF(E12=0,\"\",E12/$E$112)","v":""},{"$f":"IF(E12=0,\"\",H12*E12)","v":""},null,"Installation has not begun"]
[null,null,null,null,null,null,null,null,null,null,null,"Partially Complete"]
[null,null,null,null,null,null,null,null,null,null,null,"Complete"]
[null,null,null,null,null,null,null,null,null,null,null,"Measure Removed from Work Scope"]
[2,null,null,null,null,null,null,null,{"$f":"IF(E16=0,\"\",E16/$E$112)","v":""},{"$f":"IF(E16=0,\"\",H16*E16)","v":""},null,"Installation has not begun"]
[null,null,null,null,null,null,null,null,null,null,null,"Partially Complete"]
[null,null,null,null,null,null,null,null,null,null,null,"Complete"]
[null,null,null,null,null,null,null,null,null,null,null,"Measure Removed from Work Scope"]
[3,null,null,null,null,null,null,null,{"$f":"IF(E20=0,\"\",E20/$E$112)","v":""},{"$f":"IF(E20=0,\"\",H20*E20)","v":""},null,"Installation has not begun"]
[null,null,null,null,null,null,null,null,null,null,null,"Partially Complete"]
[null,null,null,null,null,null,null,null,null,null,null,"Complete"]
[null,null,null,null,null,null,null,null,null,null,null,"Measure Removed from Work Scope"]
[4,null,null,null,null,null,null,null,{"$f":"IF(E24=0,\"\",E24/$E$112)","v":""},{"$f":"IF(E24=0,\"\",H24*E24)","v":""},null,"Installation has not begun"]
[null,null,null,null,null,null,null,null,null,null,null,"Partially Complete"]
[null,null,null,null,null,null,null,null,null,null,null,"Complete"]
[null,null,null,null,null,null,null,null,null,null,null,"Measure Removed from Work Scope"]
[5,null,null,null,null,null,null,null,{"$f":"IF(E28=0,\"\",E28/$E$112)","v":""},{"$f":"IF(E28=0,\"\",H28*E28)","v":""},null,"Installation has not begun"]
[null,null,null,null,null,null,null,null,null,null,null,"Partially Complete"]
[null,null,null,null,null,null,null,null,null,null,null,"Complete"]
[null,null,null,null,null,null,null,null,null,null,null,"Measure Removed from Work Scope"]
[6,null,null,null,null,null,null,null,{"$f":"IF(E32=0,\"\",E32/$E$112)","v":""},{"$f":"IF(E32=0,\"\",H32*E32)","v":""},null,"Installation has not begun"]
[null,null,null,null,null,null,null,null,null,null,null,"Partially Complete"]
[null,null,null,null,null,null,null,null,null,null,null,"Complete"]
[null,null,null,null,null,null,null,null,null,null,null,"Measure Removed from Work Scope"]
[7,null,null,null,null,null,null,null,{"$f":"IF(E36=0,\"\",E36/$E$112)","v":""},{"$f":"IF(E36=0,\"\",H36*E36)","v":""},null,"Installation has not begun"]
[null,null,null,null,null,null,null,null,null,null,null,"Partially Complete"]
[null,null,null,null,null,null,null,null,null,null,null,"Complete"]
[null,null,null,null,null,null,null,null,null,null,null,"Measure Removed from Work Scope"]
[8,null,null,null,null,null,null,null,{"$f":"IF(E40=0,\"\",E40/$E$112)","v":""},{"$f":"IF(E40=0,\"\",H40*E40)","v":""},null,"Installation has not begun"]
[null,null,null,null,null,null,null,null,null,null,null,"Partially Complete"]
[null,null,null,null,null,null,null,null,null,null,null,"Complete"]
[null,null,null,null,null,null,null,null,null,null,null,"Measure Removed from Work Scope"]
[9,null,null,null,null,null,null,null,{"$f":"IF(E44=0,\"\",E44/$E$112)","v":""},{"$f":"IF(E44=0,\"\",H44*E44)","v":""},null,"Installation has not begun"]
[null,null,null,null,null,null,null,null,null,null,null,"Partially Complete"]
[null,null,null,null,null,null,null,null,null,null,null,"Complete"]
[null,null,null,null,null,null,null,null,null,null,null,"Measure Removed from Work Scope"]
[10,null,null,null,null,null,null,null,{"$f":"IF(E48=0,\"\",E48/$E$112)","v":""},{"$f":"IF(E48=0,\"\",H48*E48)","v":""},null,"Installation has not begun"]
[null,null,null,null,null,null,null,null,null,null,null,"Partially Complete"]
[null,null,null,null,null,null,null,null,null,null,null,"Complete"]
[null,null,null,null,null,null,null,null,null,null,null,"Measure Removed from Work Scope"]
[11,null,null,null,null,null,null,null,{"$f":"IF(E52=0,\"\",E52/$E$112)","v":""},{"$f":"IF(E52=0,\"\",H52*E52)","v":""},null,"Installation has not begun"]
[null,null,null,null,null,null,null,null,null,null,null,"Partially Complete"]
[null,null,null,null,null,null,null,null,null,null,null,"Complete"]
[null,null,null,null,null,null,null,null,null,null,null,"Measure Removed from Work Scope"]
[12,null,null,null,null,null,null,null,{"$f":"IF(E56=0,\"\",E56/$E$112)","v":""},{"$f":"IF(E56=0,\"\",H56*E56)","v":""},null,"Installation has not begun"]
[null,null,null,null,null,null,null,null,null,null,null,"Partially Complete"]
[null,null,null,null,null,null,null,null,null,null,null,"Complete"]
[null,null,null,null,null,null,null,null,null,null,null,"Measure Removed from Work Scope"]
[13,null,null,null,null,null,null,null,{"$f":"IF(E60=0,\"\",E60/$E$112)","v":""},{"$f":"IF(E60=0,\"\",H60*E60)","v":""},null,"Installation has not begun"]
[null,null,null,null,null,null,null,null,null,null,null,"Partially Complete"]
[null,null,null,null,null,null,null,null,null,null,null,"Complete"]
[null,null,null,null,null,null,null,null,null,null,null,"Measure Removed from Work Scope"]
[14,null,null,null,null,null,null,null,{"$f":"IF(E64=0,\"\",E64/$E$112)","v":""},{"$f":"IF(E64=0,\"\",H64*E64)","v":""},null,"Installation has not begun"]
[null,null,null,null,null,null,null,null,null,null,null,"Partially Complete"]
[null,null,null,null,null,null,null,null,null,null,null,"Complete"]
[null,null,null,null,null,null,null,null,null,null,null,"Measure Removed from Work Scope"]
[15,null,null,null,null,null,null,null,{"$f":"IF(E68=0,\"\",E68/$E$112)","v":""},{"$f":"IF(E68=0,\"\",H68*E68)","v":""},null,"Installation has not begun"]
[null,null,null,null,null,null,null,null,null,null,null,"Partially Complete"]
[null,null,null,null,null,null,null,null,null,null,null,"Complete"]
[null,null,null,null,null,null,null,null,null,null,null,"Measure Removed from Work Scope"]
[16,null,null,null,null,null,null,null,{"$f":"IF(E72=0,\"\",E72/$E$112)","v":""},{"$f":"IF(E72=0,\"\",H72*E72)","v":""},null,"Installation has not begun"]
[null,null,null,null,null,null,null,null,null,null,null,"Partially Complete"]
[null,null,null,null,null,null,null,null,null,null,null,"Complete"]
[null,null,null,null,null,null,null,null,null,null,null,"Measure Removed from Work Scope"]
[17,null,null,null,null,null,null,null,{"$f":"IF(E76=0,\"\",E76/$E$112)","v":""},{"$f":"IF(E76=0,\"\",H76*E76)","v":""},null,"Installation has not begun"]
[null,null,null,null,null,null,null,null,null,null,null,"Partially Complete"]
[null,null,null,null,null,null,null,null,null,null,null,"Complete"]
[null,null,null,null,null,null,null,null,null,null,null,"Measure Removed from Work Scope"]
[18,null,null,null,null,null,null,null,{"$f":"IF(E80=0,\"\",E80/$E$112)","v":""},{"$f":"IF(E80=0,\"\",H80*E80)","v":""},null,"Installation has not begun"]
[null,null,null,null,null,null,null,null,null,null,null,"Partially Complete"]
[null,null,null,null,null,null,null,null,null,null,null,"Complete"]
[null,null,null,null,null,null,null,null,null,null,null,"Measure Removed from Work Scope"]
[19,null,null,null,null,null,null,null,{"$f":"IF(E84=0,\"\",E84/$E$112)","v":""},{"$f":"IF(E84=0,\"\",H84*E84)","v":""},null,"Installation has not begun"]
[null,null,null,null,null,null,null,null,null,null,null,"Partially Complete"]
[null,null,null,null,null,null,null,null,null,null,null,"Complete"]
[null,null,null,null,null,null,null,null,null,null,null,"Measure Removed from Work Scope"]
[20,null,null,null,null,null,null,null,{"$f":"IF(E88=0,\"\",E88/$E$112)","v":""},{"$f":"IF(E88=0,\"\",H88*E88)","v":""},null,"Installation has not begun"]
[null,null,null,null,null,null,null,null,null,null,null,"Partially Complete"]
[null,null,null,null,null,null,null,null,null,null,null,"Complete"]
[null,null,null,null,null,null,null,null,null,null,null,"Measure Removed from Work Scope"]
[21,null,null,null,null,null,null,null,{"$f":"IF(E92=0,\"\",E92/$E$112)","v":""},{"$f":"IF(E92=0,\"\",H92*E92)","v":""},null,"Installation has not begun"]
[null,null,null,null,null,null,null,null,null,null,null,"Partially Complete"]
[null,null,null,null,null,null,null,null,null,null,null,"Complete"]
[null,null,null,null,null,null,null,null,null,null,null,"Measure Removed from Work Scope"]
[22,null,null,null,null,null,null,null,{"$f":"IF(E96=0,\"\",E96/$E$112)","v":""},{"$f":"IF(E96=0,\"\",H96*E96)","v":""},null,"Installation has not begun"]
[null,null,null,null,null,null,null,null,null,null,null,"Partially Complete"]
[null,null,null,null,null,null,null,null,null,null,null,"Complete"]
[null,null,null,null,null,null,null,null,null,null,null,"Measure Removed from Work Scope"]
[23,null,null,null,null,null,null,null,{"$f":"IF(E100=0,\"\",E100/$E$112)","v":""},{"$f":"IF(E100=0,\"\",H100*E100)","v":""},null,"Installation has not begun"]
[null,null,null,null,null,null,null,null,null,null,null,"Partially Complete"]
[null,null,null,null,null,null,null,null,null,null,null,"Complete"]
[null,null,null,null,null,null,null,null,null,null,null,"Measure Removed from Work Scope"]
[24,null,null,null,null,null,null,null,{"$f":"IF(E104=0,\"\",E104/$E$112)","v":""},{"$f":"IF(E104=0,\"\",H104*E104)","v":""},null,"Installation has not begun"]
[null,null,null,null,null,null,null,null,null,null,null,"Partially Complete"]
[null,null,null,null,null,null,null,null,null,null,null,"Complete"]
[null,null,null,null,null,null,null,null,null,null,null,"Measure Removed from Work Scope"]
[25,null,null,null,null,null,null,null,{"$f":"IF(E108=0,\"\",E108/$E$112)","v":""},{"$f":"IF(E108=0,\"\",H108*E108)","v":""},null,"Installation has not begun"]
[null,null,null,null,null,null,null,null,null,null,null,"Partially Complete"]
[null,null,null,null,null,null,null,null,null,null,null,"Complete"]
[null,null,null,null,null,null,null,null,null,null,null,"Measure Removed from Work Scope"]
["Progress To Date:",null,null,null,{"$f":"SUM(E12:E111)","v":0},{"$f":"SUM(F12:F111)","v":0},null,{"$f":"SUMIF(G12:G111,\"<>Yes\",J12:J111)/SUMIF(G12:G111,\"<>Yes\",E12:E111)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(I12:I111)","v":0},{"$f":"SUM(J12:J111)","v":0}]

{"sheet":"Data Import","index":2,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":true,"merged":[[0,0,0,2]]}
["SAV-IT Import"]
["Construction Management Reference","SAV-IT Reference","Compiled References"]
["='Project Workscope'!DT_ProjectName","='General Project Info'!DT_GeneralProjectInfo_ProjectInfo_Name"]
["='Data Import'!DT_StreetAddress","='General Project Info'!DT_GeneralProjectInfo_ProjectInfo_StreetAddress"]
["='Data Import'!DT_City","='General Project Info'!DT_GeneralProjectInfo_ProjectInfo_City"]
["='Data Import'!DT_Zip","='General Project Info'!DT_GeneralProjectInfo_ProjectInfo_Zip"]
[null,null,{"$f":"DT_StreetAddress&\" \"&DT_City&\", NY \"&DT_Zip","v":" , NY "}]
["='Project Workscope'!DT_Units","='General Project Info'!C40"]
["='Project Workscope'!DT_Buildings","='General Project Info'!DT_GeneralProjectInfo_BuildingInfo_NumBuildings1"]
["='Project Workscope'!DT_Stories","='General Project Info'!DT_GeneralProjectInfo_BuildingInfo_NumStories1"]

{"sheet":"Measure Classification","index":3,"n_rows":21,"n_cols":10,"rows_kept":21,"cut":false,"hidden":true,"merged":[]}
["MeasureCategory","Appliance","DHW","Envelope","Heating_Cooling","Lighting","Motors","Ventilation","Renewables","Other"]
["Appliance","Dishwasher, Install Energy Star","Controls","Air Sealing","Boiler, Replace (Central)","Exterior Lighting, Upgrade","Elevator Motors and Controls, Upgrade","Constant Air Regulators, Install","CHP","Other"]
["DHW","Gas-fired Dryers, Replace Electric","Low-flow Devices","Exterior Doors, Replace","Boiler, Replace (In-Unit)","High Efficiency Fluorescent, Apt, Install","Exhaust Fans, Replace","Duct Sealing","Geothermal","Submetering"]
["Envelope","Other Appliances, Install Energy Star","Other DHW Measure","Insulation, Above Grade Walls","Boiler/Burner Clean and Tune","High Efficiency Fluorescent, CA, Install","Motors, Install NEMA Premium Efficiency","Exhaust Fan Demand Control","Photovoltaic System"]
["Heating/Cooling","Refrigerators, install Energy Star","Piping, DHW, Insulate","Insulation, Below Grade Walls","Burner, Replace","LED Exit Signs","Other Motor Measure","Fan/Air Handlers, Upgrade","Solar Hot Water"]
["Lighting","Washing Machines, Install Energy Star","Replace DHW Heater (Central)","Insulation, Other Shell","Central AC/HP","LED Fixtures & Screw-Ins","Pumps, Upgrade","Heat/Energy Recovery","Wind Turbine"]
["Motors",null,"Replace DHW Heater (In-Unit)","Insulation, Roof Deck or Attic","Chiller, Replace","Other Lighting Measure","Var. Speed Drive","Other Ventilation Measure"]
["Renewables",null,"Replace DHW Indirect-fired Heater","Insulation, Slab","Distribution System, Upgrade","Timers/Sensors, Install",null,"Ventilation Central Controls"]
["Ventilation",null,null,"Smoke-Driven Louver, Install","Economizer, Install"]
["Other",null,null,"Vertical Shafts, Seal","Energy Management System (EMS), Install"]
[null,null,null,"Windows, Replace","Furnace, Replace"]
[null,null,null,"Windows, Weatherstrip or Airseal","Other Cooling Measure"]
[null,null,null,null,"Other Heating Measure"]
[null,null,null,null,"Outdoor Reset Control, Install"]
[null,null,null,null,"Piping, Heating, Insulate"]
[null,null,null,null,"Programmable Thermostats, Common Area"]
[null,null,null,null,"Split System AC/HP"]
[null,null,null,null,"Steam Traps, Replace"]
[null,null,null,null,"Thermostatic Radiator Valves, install"]
[null,null,null,null,"Water Source AC/HP"]
[null,null,null,null,"Window Air Conditioners, Install"]