{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Instructions","Eligibility Tool","Data Collection","Lookup Info","Additional Info","DI Request"],"not_rendered":{"charts":0,"images":249,"macros":1,"external_links":0,"defined_names":41,"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":"Instructions","index":0,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":false,"merged":[[7,1,7,3],[2,1,2,18],[4,1,4,18],[3,1,3,17],[5,2,5,17],[6,1,6,17]]}
["Instructions"]
[]
["1.","Save eligibility tool to your computer."]
["2.","Accept security warning(s)."]
["3.","Complete Eligibility Tool tab to the best of your abilities."]
[null,"a.","See Additional Info tab for examples and more information."]
["4.","Use Review button to verify all required fields have been completed."]
["5.","Send completed tool to: ",null,null,"multifamilyprograms@franklinenergy.com"]

{"sheet":"Eligibility Tool","index":1,"n_rows":117,"n_cols":18,"rows_kept":117,"cut":false,"hidden":false,"merged":[[103,0,103,5],[103,6,103,10],[103,11,103,14],[103,15,103,16],[103,17,103,18],[73,3,74,18],[89,4,89,10],[89,11,89,12],[89,13,89,18],[102,0,102,5],[102,6,102,10],[102,11,102,14],[102,15,102,16],[102,17,102,18],[94,6,94,10],[94,11,94,14],[94,15,94,16],[94,0,94,5],[94,17,94,18],[93,15,93,16],[93,11,93,14],[86,14,86,18],[79,14,79,18],[77,0,77,1],[72,7,72,9],[72,10,72,12],[72,13,72,18],[80,12,80,18],[101,17,101,18],[98,11,98,14],[99,11,99,14],[100,11,100,14],[101,11,101,14],[95,15,95,16],[96,15,96,16],[97,15,97,16],[98,15,98,16],[99,15,99,16],[97,11,97,14],[95,17,95,18],[96,17,96,18],[97,17,97,18],[98,17,98,18],[99,17,99,18],[100,17,100,18],[96,11,96,14],[88,11,88,12],[87,9,87,11],[19,13,19,18],[42,0,42,18],[25,13,25,18],[26,13,26,18],[25,0,25,3],[28,13,28,14],[43,17,43,18],[20,1,20,11],[22,0,22,1],[23,4,23,10],[26,0,26,3],[25,11,25,12],[31,0,31,18],[23,13,23,18],[24,11,24,12],[24,4,24,8],[28,1,28,8],[28,10,28,12],[28,15,28,18],[38,4,38,11],[36,4,36,9],[30,0,30,18],[21,0,21,18],[32,0,32,18],[112,9,112,10],[113,0,113,8],[108,0,109,2],[111,3,111,9],[111,10,111,12],[111,13,111,18],[112,0,112,3],[112,4,112,7],[113,15,113,18],[113,12,113,14],[113,9,113,10],[108,3,109,18],[110,0,110,18],[111,0,111,2],[112,11,112,18],[107,0,107,4],[107,12,107,14],[107,15,107,18],[107,5,107,11],[95,6,95,10],[96,6,96,10],[97,6,97,10],[98,6,98,10],[99,6,99,10],[100,15,100,16],[95,0,95,5],[96,0,96,5],[95,11,95,14],[100,6,100,10],[106,0,106,18],[104,3,105,18],[104,0,105,2],[101,6,101,10],[97,0,97,5],[98,0,98,5],[99,0,99,5],[100,0,100,5],[101,0,101,5],[101,15,101,16],[48,0,48,8],[48,16,48,18],[43,0,43,10],[37,13,37,18],[36,10,36,11],[43,11,43,15],[46,0,46,5],[46,10,46,13],[46,6,46,9],[46,14,46,18],[47,16,47,18],[40,0,40,18],[39,0,39,3],[38,13,38,18],[45,0,45,7],[39,10,39,11],[39,4,39,9],[44,9,44,10],[45,14,45,18],[47,0,47,3],[82,0,82,6],[82,7,82,10],[82,11,82,13],[82,14,82,18],[81,16,81,18],[60,12,60,18],[61,3,62,18],[61,0,62,2],[77,13,77,18],[68,0,68,5],[81,0,81,8],[71,0,71,8],[72,0,72,6],[69,0,70,2],[76,4,76,8],[76,9,76,11],[77,2,77,11],[79,0,79,6],[78,0,78,7],[73,0,74,2],[75,0,75,18],[79,12,79,13],[79,7,79,11],[81,9,81,12],[87,15,87,18],[93,6,93,10],[87,3,87,8],[89,0,89,3],[87,0,87,2],[88,0,88,3],[88,13,88,18],[90,3,91,18],[87,12,87,13],[90,0,91,2],[92,0,92,18],[53,0,53,6],[59,2,59,11],[58,12,58,18],[93,17,93,18],[83,0,84,2],[65,3,66,18],[76,12,76,18],[69,3,70,18],[63,0,63,7],[56,3,57,18],[83,3,84,18],[85,0,85,18],[80,4,80,7],[80,8,80,11],[80,0,80,3],[86,0,86,7],[86,8,86,11],[86,12,86,13],[81,13,81,15],[78,8,78,13],[78,14,78,18],[76,0,76,3],[88,4,88,10],[93,0,93,5],[54,13,54,18],[65,0,66,2],[68,6,68,10],[68,11,68,14],[68,15,68,18],[60,8,60,11],[64,0,64,7],[63,11,63,12],[55,8,55,11],[59,0,59,1],[58,0,58,6],[58,7,58,8],[56,0,57,2],[55,0,55,3],[54,2,54,11],[55,4,55,7],[64,12,64,18],[63,13,63,18],[54,0,54,1],[67,13,67,15],[67,9,67,12],[67,16,67,18],[60,4,60,7],[55,12,55,18],[51,0,51,18],[52,0,52,18],[14,13,14,14],[12,0,12,5],[12,6,12,18],[13,15,13,18],[13,1,13,8],[19,0,19,6],[17,6,17,10],[17,12,17,18],[16,11,16,18],[16,0,16,3],[18,0,18,1],[18,2,18,18],[14,4,14,8],[14,9,14,11],[16,4,16,10],[14,15,14,18],[17,0,17,5],[35,13,35,18],[49,0,49,3],[49,11,49,12],[49,13,49,18],[23,0,23,3],[49,4,49,10],[50,0,50,18],[4,0,4,18],[34,0,34,3],[14,0,14,3],[7,0,7,18],[29,0,29,18],[5,0,5,18],[8,0,8,18],[10,0,10,18],[15,0,15,5],[13,10,13,12],[13,13,13,14],[33,0,33,18],[11,0,11,4],[15,6,15,13],[19,7,19,11],[22,2,22,18],[23,11,23,12],[15,15,15,18],[24,17,24,18],[24,13,24,15],[11,5,11,18],[20,13,20,18],[34,4,34,11],[58,9,58,11],[71,9,71,12],[71,13,71,15],[71,16,71,18],[64,8,64,11],[41,0,41,18],[53,12,53,18],[24,0,24,3],[26,11,26,12],[53,7,53,8],[27,0,27,1],[27,2,27,18],[59,13,59,18],[60,0,60,3],[36,12,36,18],[35,4,35,11],[37,4,37,12],[48,12,48,15],[44,16,44,18],[39,12,39,18],[25,4,25,10],[26,4,26,10],[34,13,34,18],[53,9,53,11],[116,16,116,18],[116,4,116,9],[114,9,114,10],[114,0,114,3],[114,4,114,7],[114,11,114,12],[114,13,114,18],[6,0,6,18],[9,0,9,18],[67,0,67,8],[45,8,45,13],[44,11,44,15],[35,0,35,3],[37,0,37,3],[38,0,38,3],[36,0,36,3],[48,9,48,11],[44,0,44,8],[63,8,63,10],[47,4,47,7],[47,10,47,11],[47,8,47,9],[47,12,47,15]]}
[]
[]
[]
[]
["Multifamily Energy Savings Program (MESP) Eligibility Tool"]
["Property Eligibility"]
["This portion of the tool identifies if your property is eligible for the MESP program. In order to be eligible you must have a multifamily building that is 4 or more units. Buildings with less than 4 units may qualify for other programs."]
["Property Information"]
[" ● A building is defined as the number of units under one roof. Buildings with multiple entrances and addresses\n   that are all under one  roof are considered one building. "]
["● For properties with multiple buildings please provide the address for each building."]
["● Building Breakdown- For properties with multiple building please provide the number of buildings of each size\n   (ex. 2-24 units, 4-8 units, etc.), in the building breakdown section."]
["Property Name"]
["Property Address(s)"]
["City",null,null,null,null,null,null,null,null,"State",null,null,null,"Zip Code"]
["# of Buildings",null,null,null,null,null,null,null,null,"Total # of Units",null,null,null,"# of Floors"]
["Building Breakdown",null,null,null,null,null,null,null,null,null,null,null,null,null,"Year Built"]
["Building Type"]
["Affordable Housing",null,null,null,null,null,null,null,null,null,null,"Type"]
["Parking"]
["On-site Contact Name",null,null,null,null,null,null,null,null,null,null,null,"Phone #"]
["Email",null,null,null,null,null,null,null,null,null,null,null,"Fax #"]
["Management Company or Property Owner"]
["Name"]
["Contact Name",null,null,null,null,null,null,null,null,null,null,"Owner Name"]
["Contact Phone",null,null,null,null,null,null,null,null,"Ext.",null,"Owner Phone",null,null,null,null,"Ext."]
["Contact Fax",null,null,null,null,null,null,null,null,null,null,"Owner Fax"]
["Contact Email",null,null,null,null,null,null,null,null,null,null,"Owner Email"]
["Address"]
["City",null,null,null,null,null,null,null,null,"State",null,null,null,"Zip Code"]
["Utility Information"]
["● If your utility is not in the drop down they may not participate in the Focus on Energy program. In this case you\n   should contact your utility to see if they do participate or if they offer their own incentive program."]
["● Master metered buildings have one meter for the entire building. "]
["● Individually metered buildings contain House Meters for the common area electric and individual meters for each\n   apartment. Please provide all House Meter numbers, 2 lines are provided for electric and gas meter numbers. "]
["● If you do not have natural gas or use another fuel source (fuel oil, city steam, LP, etc.) please indicate in the\n    comments section. "]
["Gas Utility ",null,null,null,null,null,null,null,null,null,null,null,"Meter #"]
["Gas Account #",null,null,null,null,null,null,null,null,null,null,null,"Meter #"]
["Metering",null,null,null,null,null,null,null,null,null,"Comments"]
["Electric Utility"]
["Elec Account #",null,null,null,null,null,null,null,null,null,null,null,"Meter #"]
["Metering",null,null,null,null,null,null,null,null,null,"Comments"]
["Direct Install Eligibility"]
["The MESP Direct Install (DI) program installs low flow/high pressure showerheads, aerators and CFL's in every unit for no cost. This portion of the eligibility tool will verify your eligibility for this free program. "]
["● Handicap accessible baths counts should be included in the number of full and half baths."]
["Have you had DI at your property since 2005?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date"]
["Typical Showerhead Flow Rate (GPM)",null,null,null,null,null,null,null,null,null,null,"Typical Faucet Flow Rate (GPM)"]
["Water Heater Fuel Source"]
["Water Heater Type",null,null,null,null,null,null,null,null,null,"Water Heater Location"]
["# of Full Baths",null,null,null,null,null,null,null,"# of Half Baths",null,null,null,"# Handicap Accessible"]
["Average # of Lamps per Unit (Total)",null,null,null,null,null,null,null,null,null,null,null,"# of Decorative Lamps"]
["Exit Sign Type",null,null,null,null,null,null,null,null,null,null,"# of Exit Signs"]
["Performance Track Eligibility"]
["This portion of the eligibility tool will assist program staff in determining eligibility for the Performance Track. The Performance Track is for buildings that have Custom Incentive opportunities. Buildings not eligible for the Performance Track may be eligible for Standard Incentives. "]
["Heating, Ventilation & Cooling (HVAC)"]
["Primary Heating Type",null,null,null,null,null,null,null,null,"Heating Equipment"]
["Brand",null,null,null,null,null,null,null,null,null,null,null,"Model #"]
["Year Installed",null,null,null,null,null,null,null,"Current Replacement Plan"]
["Comments"]
[]
["Primary Cooling Type",null,null,null,null,null,null,null,null,"Cooling Equipment"]
["Brand",null,null,null,null,null,null,null,null,null,null,null,"Model #"]
["Year Installed",null,null,null,null,null,null,null,"Current Replacement Plan"]
["Comments"]
[]
["Primary Ventilation Type",null,null,null,null,null,null,null,null,null,null,"Control Strategy"]
["Contains Heat Recovery"]
["Comments"]
[]
["Parking Garage Heating Equipment ",null,null,null,null,null,null,null,null,null,null,null,null,"Temp Set Point"]
["Ventilation Control",null,null,null,null,null,null,null,null,null,null,"Fan Motor Horsepower (HP)"]
["Comments"]
[]
["Current HVAC Maintenance Practices",null,null,null,null,null,null,null,null,null,null,null,null,"Last Service Date"]
["Equipment Serviced By",null,null,null,null,null,null,null,null,null,"Contractor Selection"]
["Comments"]
[]
["Domestic Hot Water (DHW)"]
["System Type",null,null,null,null,null,null,null,null,"Equipment Type"]
["Brand",null,null,null,null,null,null,null,null,null,null,null,"Model #"]
["Water Heater Fuel Source"]
["Recirculating System",null,null,null,null,null,null,null,null,null,null,null," Control"]
["Year Installed",null,null,null,null,null,null,null,"Current Replacement Plan"]
["Current Maintenance Practices",null,null,null,null,null,null,null,null,null,null,null,null,"Last Service Date"]
["Equipment Serviced By",null,null,null,null,null,null,null,null,null,null,"Contractor Selection"]
["Comments"]
[]
["Building Shell"]
["Exterior Wall Construction",null,null,null,null,null,null,null,null,null,null,null,"R-value"]
["Roof Type",null,null,null,null,null,null,null,null,"Year Replaced ",null,null,null,null,"R-value"]
["Window Type ",null,null,null,null,null,null,null,null,null,null,"Frame Material"]
["Window Style",null,null,null,null,null,null,null,null,null,null,"Storms"]
["Comments"]
[]
["Lighting"]
["Area",null,null,null,null,null,"Lighting Technology",null,null,null,null,"Lighting Type",null,null,null,"Control",null,"Est. Hrs"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Comments"]
[]
["In Unit"]
["Thermostat Type",null,null,null,null,null,null,null,null,null,null,null,"Cooking Stove Type"]
["Comments"]
[]
["Laundry"]
["Location ",null,null,null,null,null,null,null,null,null,"Equipment Owner"]
["# of Washers",null,null,null,null,null,null,null,"$/Load"]
["Loads per Machine per Month",null,null,null,null,null,null,null,null,null,null,"or","Total Monthly Income"]
["# of Dryers",null,null,null,null,null,null,null,"$/Load",null,null,"Dryer Type"]
[]
["Completed By:",null,null,null,null,null,null,null,null,null,null,null,null,"Date Submitted:"]

{"sheet":"Data Collection","index":2,"n_rows":102,"n_cols":20,"rows_kept":102,"cut":false,"hidden":true,"merged":[[64,0,64,4],[64,5,64,14],[64,15,64,20],[61,1,61,14],[61,15,61,20],[95,0,95,5],[95,6,95,10],[95,11,95,14],[95,16,95,18],[95,19,95,20],[63,8,63,11],[66,0,66,6],[86,6,86,10],[86,11,86,14],[88,6,88,10],[89,6,89,10],[94,6,94,10],[88,11,88,14],[89,11,89,14],[90,11,90,14],[91,11,91,14],[92,11,92,14],[93,11,93,14],[94,11,94,14],[96,0,96,5],[96,6,96,10],[96,11,96,14],[96,16,96,18],[96,19,96,20],[92,6,92,10],[93,6,93,10],[42,0,42,20],[43,0,43,20],[44,0,44,20],[53,1,53,16],[53,17,53,20],[58,13,58,16],[58,17,58,20],[90,6,90,10],[91,6,91,10],[93,16,93,18],[93,19,93,20],[70,0,70,5],[71,0,71,5],[70,6,70,10],[71,6,71,11],[71,12,71,20],[63,0,63,7],[45,0,45,20],[46,0,46,20],[47,0,47,20],[48,0,48,20],[49,0,49,20],[50,0,50,20],[86,16,86,18],[86,19,86,20],[59,13,59,14],[59,16,59,20],[77,16,77,20],[77,5,77,8],[77,9,77,11],[77,12,77,14],[66,7,66,12],[67,9,67,13],[67,14,67,16],[67,17,67,20],[79,0,79,6],[79,7,79,11],[76,6,76,9],[78,18,78,20],[52,17,52,20],[52,12,52,16],[87,19,87,20],[88,19,88,20],[89,19,89,20],[90,19,90,20],[91,19,91,20],[92,19,92,20],[87,16,87,18],[88,16,88,18],[89,16,89,18],[90,16,90,18],[91,16,91,18],[92,16,92,18],[94,19,94,20],[87,6,87,10],[87,11,87,14],[94,16,94,18],[79,12,79,14],[79,15,79,20],[65,18,65,20],[65,15,65,17],[70,12,70,16],[70,17,70,20],[65,0,65,8],[65,9,65,14],[78,0,78,8],[78,9,78,14],[76,12,76,20],[75,0,75,3],[75,13,75,14],[78,15,78,17],[75,9,75,10],[75,11,75,12],[75,15,75,20],[76,10,76,11],[77,0,77,4],[76,0,76,5],[51,0,51,20],[54,0,54,1],[54,2,54,12],[54,14,54,20],[31,0,31,3],[57,0,57,2],[57,10,57,11],[57,12,57,13],[57,14,57,20],[55,10,55,12],[55,13,55,15],[55,16,55,20],[56,10,56,11],[34,0,34,20],[33,0,33,20],[35,0,35,20],[36,0,36,20],[37,0,37,20],[38,0,38,20],[39,0,39,20],[40,0,40,20],[41,0,41,20],[56,0,56,3],[55,1,55,8],[100,13,100,15],[100,16,100,20],[100,0,100,7],[97,0,97,20],[98,0,98,2],[99,0,99,3],[99,10,99,11],[100,8,100,11],[99,4,99,8],[98,3,98,9],[98,10,98,12],[98,13,98,20],[80,0,80,20],[81,0,81,7],[84,4,84,14],[84,16,84,20],[81,16,81,17],[81,18,81,20],[81,8,81,14],[82,16,82,17],[82,18,82,20],[82,3,82,12],[68,0,68,6],[68,7,68,11],[68,12,68,14],[68,15,68,20],[66,18,66,20],[66,13,66,17],[67,0,67,8],[94,0,94,5],[92,0,92,5],[93,0,93,5],[90,0,90,5],[91,0,91,5],[88,0,88,5],[89,0,89,5],[86,0,86,5],[87,0,87,5],[84,0,84,3],[85,0,85,20],[82,0,82,2],[82,13,82,14],[83,0,83,3],[83,4,83,11],[83,12,83,13],[83,14,83,20],[72,0,72,1],[72,2,72,12],[72,14,72,20],[69,0,69,20],[75,4,75,8],[74,4,74,8],[73,1,73,8],[73,10,73,12],[73,13,73,15],[73,16,73,20],[74,0,74,3],[74,10,74,11],[74,12,74,14],[74,15,74,20],[56,4,56,8],[58,2,58,8],[63,12,63,13],[63,14,63,20],[57,8,57,9],[56,12,56,14],[56,15,56,20],[58,11,58,12],[59,0,59,5],[59,6,59,9],[59,10,59,12],[57,3,57,7],[60,12,60,13],[60,14,60,20],[60,7,60,11],[58,0,58,1],[58,9,58,10],[60,0,60,6],[62,0,62,1],[62,2,62,12],[62,14,62,20],[31,9,31,10],[31,11,31,12],[29,0,29,4],[27,0,27,3],[27,4,27,10],[28,0,28,20],[29,5,29,11],[29,15,29,20],[27,12,27,20],[30,0,30,4],[30,9,30,10],[30,11,30,12],[30,13,30,14],[30,16,30,18],[30,19,30,20],[25,0,25,3],[25,4,25,13],[25,14,25,20],[26,0,26,3],[26,14,26,20],[23,0,23,3],[23,14,23,20],[24,0,24,3],[24,4,24,10],[24,12,24,20],[22,0,22,3],[22,4,22,13],[22,14,22,20],[20,1,20,9],[20,11,20,13],[20,14,20,15],[20,16,20,20],[21,0,21,20],[18,0,18,3],[18,4,18,11],[18,12,18,13],[18,14,18,20],[19,0,19,3],[19,4,19,20],[17,0,17,3],[17,4,17,11],[17,12,17,13],[17,14,17,20],[13,0,13,20],[14,0,14,1],[14,2,14,20],[15,0,15,3],[15,4,15,11],[15,12,15,13],[15,14,15,20],[16,4,16,9],[16,14,16,16],[16,18,16,20],[11,0,11,6],[11,7,11,12],[11,14,11,20],[12,1,12,12],[12,14,12,20],[8,0,8,3],[9,0,9,5],[8,4,8,20],[16,0,16,3],[16,12,16,13],[4,5,4,20],[5,1,5,9],[5,11,5,13],[5,14,5,15],[5,16,5,20],[10,0,10,1],[0,0,0,20],[2,0,2,20],[6,0,6,3],[6,4,6,9],[6,14,6,15],[6,16,6,20],[7,0,7,5],[7,6,7,14],[7,15,7,16],[7,17,7,20],[6,10,6,11],[6,12,6,13],[1,0,1,4],[1,5,1,9],[1,10,1,12],[1,13,1,20],[10,2,10,20],[101,0,101,3],[101,4,101,8],[101,10,101,11],[101,12,101,13],[101,14,101,20],[99,12,99,20],[52,0,52,5],[52,6,52,10],[3,0,3,3],[3,4,3,20],[31,13,31,15],[32,13,32,15],[31,16,31,20],[32,16,32,20],[32,0,32,8],[32,9,32,12],[31,4,31,8],[30,5,30,8],[23,4,23,12],[26,4,26,12],[9,11,9,20],[9,6,9,9],[29,12,29,14],[4,0,4,4]]}
["Multifamily Energy Savings Program (MESP) Data Collection & Eligibility "]
["Assesment Date",null,null,null,null,null,null,null,null,null,"Assesment Completed By"]
["Property Information"]
["Property Name",null,null,null,{"$f":"IF('Eligibility Tool'!F12=\"\",\"\",'Eligibility Tool'!F12)","v":""}]
["Property Address",null,null,null,null,{"$f":"IF('Eligibility Tool'!G13=\"\",\"\",'Eligibility Tool'!G13)","v":""}]
["City",{"$f":"IF('Eligibility Tool'!B14=\"\",\"\",'Eligibility Tool'!B14)","v":""},null,null,null,null,null,null,null,null,"State",{"$f":"IF('Eligibility Tool'!K14=\"\",\"\",'Eligibility Tool'!K14)","v":""},null,null,"Zip Code",null,{"$f":"IF('Eligibility Tool'!P14=\"\",\"\",'Eligibility Tool'!P14)","v":""}]
["# of Buildings",null,null,null,{"$f":"IF('Eligibility Tool'!E15=\"\",\"\",'Eligibility Tool'!E15)","v":""},null,null,null,null,null,"Total # of Units",null,{"$f":"IF('Eligibility Tool'!M15=\"\",\"\",'Eligibility Tool'!M15)","v":""},null,"# of Floors",null,{"$f":"IF('Eligibility Tool'!P15=\"\",\"\",'Eligibility Tool'!P15)","v":""}]
["Building Breakdown",null,null,null,null,null,{"$f":"IF('Eligibility Tool'!G16=\"\",\"\",'Eligibility Tool'!G16)","v":""},null,null,null,null,null,null,null,null,"Year Built",null,{"$f":"IF('Eligibility Tool'!P16=\"\",\"\",'Eligibility Tool'!P16)","v":""}]
["Building Type"]
["Affordable Housing",null,null,null,null,null,null,null,null,null,"Type",{"$f":"IF('Eligibility Tool'!M18=\"\",\"\",'Eligibility Tool'!M18)","v":""}]
["Parking"]
["On-site Contact Name",null,null,null,null,null,null,{"$f":"IF('Eligibility Tool'!H20=\"\",\"\",'Eligibility Tool'!H20)","v":""},null,null,null,null,null,"Phone #",{"$f":"IF('Eligibility Tool'!N20=\"\",\"(       )\",'Eligibility Tool'!N20)","v":"(       )"}]
["Email",{"$f":"IF('Eligibility Tool'!B21=\"\",\"\",'Eligibility Tool'!B21)","v":""},null,null,null,null,null,null,null,null,null,null,null,"Fax #",{"$f":"IF('Eligibility Tool'!N21=\"\",\"(       )\",'Eligibility Tool'!N21)","v":"(       )"}]
["Management Company or Property Owner"]
["Name",null,{"$f":"IF('Eligibility Tool'!C23=\"\",\"\",'Eligibility Tool'!C23)","v":""}]
["Contact Name",null,null,null,{"$f":"IF('Eligibility Tool'!E24=\"\",\"\",'Eligibility Tool'!E24)","v":""},null,null,null,null,null,null,null,"Owner Name",null,{"$f":"IF('Eligibility Tool'!N24=\"\",\"\",'Eligibility Tool'!N24)","v":""}]
["Contact Phone",null,null,null,{"$f":"IF('Eligibility Tool'!E25=\"\",\"\",'Eligibility Tool'!E25)","v":""},null,null,null,null,null,"Ext.",{"$f":"IF('Eligibility Tool'!K25=\"\",\"\",'Eligibility Tool'!K25)","v":""},"Owner Phone",null,{"$f":"IF('Eligibility Tool'!N25=\"\",\"\",'Eligibility Tool'!N25)","v":""},null,null,"Ext.",{"$f":"IF('Eligibility Tool'!R25=\"\",\"\",'Eligibility Tool'!R25)","v":""}]
["Contact Fax",null,null,null,{"$f":"IF('Eligibility Tool'!E26=\"\",\"\",'Eligibility Tool'!E26)","v":""},null,null,null,null,null,null,null,"Owner Fax",null,{"$f":"IF('Eligibility Tool'!N26=\"\",\"\",'Eligibility Tool'!N26)","v":""}]
["Contact Email",null,null,null,{"$f":"IF('Eligibility Tool'!E27=\"\",\"\",'Eligibility Tool'!E27)","v":""},null,null,null,null,null,null,null,"Owner Email",null,{"$f":"IF('Eligibility Tool'!N27=\"\",\"\",'Eligibility Tool'!N27)","v":""}]
["Address",null,null,null,{"$f":"IF('Eligibility Tool'!C28=\"\",\"\",'Eligibility Tool'!C28)","v":""}]
["City",{"$f":"IF('Eligibility Tool'!B29=\"\",\"\",'Eligibility Tool'!B29)","v":""},null,null,null,null,null,null,null,null,"State",{"$f":"IF('Eligibility Tool'!K29=\"\",\"\",'Eligibility Tool'!K29)","v":""},null,null,"Zip Code",null,{"$f":"IF('Eligibility Tool'!P29=\"\",\"\",'Eligibility Tool'!P29)","v":""}]
["Utility Information"]
["Gas Utility ",null,null,null,{"$f":"\"    \" &IF('Eligibility Tool'!E35=\"\",\"\",'Eligibility Tool'!E35)","v":"    "},null,null,null,null,null,null,null,null,null,{"$f":"IF('Eligibility Tool'!N35=\"\",\"\",'Eligibility Tool'!N35)","v":""}]
["Gas Account #",null,null,null,{"$f":"\"    \" &IF('Eligibility Tool'!E36=\"\",\"\",'Eligibility Tool'!E36)","v":"    "},null,null,null,null,null,null,null,null,"Meter #",{"$f":"IF('Eligibility Tool'!N36=\"\",\"\",'Eligibility Tool'!N36)","v":""}]
["Metering",null,null,null,null,null,null,null,null,null,null,"Comments",{"$f":"IF('Eligibility Tool'!M37=\"\",\"\",'Eligibility Tool'!M37)","v":""}]
["Electric Utility",null,null,null,{"$f":"\"    \" &IF('Eligibility Tool'!E38=\"\",\"\",'Eligibility Tool'!E38)","v":"    "},null,null,null,null,null,null,null,null,null,{"$f":"IF('Eligibility Tool'!N38=\"\",\"\",'Eligibility Tool'!N38)","v":""}]
["Elec Account #",null,null,null,{"$f":"\"    \" &IF('Eligibility Tool'!E39=\"\",\"\",'Eligibility Tool'!E39)","v":"    "},null,null,null,null,null,null,null,null,"Meter #",{"$f":"IF('Eligibility Tool'!N39=\"\",\"\",'Eligibility Tool'!N39)","v":""}]
["Metering",null,null,null,null,null,null,null,null,null,null,"Comments",{"$f":"IF('Eligibility Tool'!M40=\"\",\"\",'Eligibility Tool'!M40)","v":""}]
["In Unit"]
["Thermostat Type",null,null,null,null,{"$f":"IF('Eligibility Tool'!F108=\"\",\"\",'Eligibility Tool'!F108)","v":""},null,null,null,null,null,null,"Cooking Stove Type",null,null,{"$f":"IF('Eligibility Tool'!P108=\"LP\",\"\",IF('Eligibility Tool'!P108=\"\",\"\",'Eligibility Tool'!P108))","v":""}]
["Showerhead GPM",null,null,null,null,{"$f":"IF('Eligibility Tool'!J45=\"\",\"\",'Eligibility Tool'!J45)","v":""},null,null,null,"Kitchen GPM",null,null,null,"Bath GPM",null,{"$f":"IF('Eligibility Tool'!Q45=\"\",\"\",'Eligibility Tool'!Q45)","v":""},"H20 Temp"]
["# of Full Baths",null,null,null,{"$f":"IF('Eligibility Tool'!E48=\"\",\"\",'Eligibility Tool'!E48)","v":""},null,null,null,null,"# of Half Baths",null,{"$f":"IF('Eligibility Tool'!K48=\"\",\"\",'Eligibility Tool'!K48)","v":""},null,"# Handicap Accessible",null,null,{"$f":"IF('Eligibility Tool'!Q48=\"\",\"\",'Eligibility Tool'!Q48)","v":""}]
["Average # of Lamps per Unit (Total)",null,null,null,null,null,null,null,null,{"$f":"IF('Eligibility Tool'!J49=\"\",\"\",'Eligibility Tool'!J49)","v":""},null,null,null,"# of Decorative Lamps",null,null,{"$f":"IF('Eligibility Tool'!Q49=\"\",\"\",'Eligibility Tool'!Q49)","v":""}]
["NOTES"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Heating, Ventilation & Cooling (HVAC)"]
["Primary Heating Type",null,null,null,null,null,null,null,null,null,null,"Fuel"]
["Type"]
["Brand",null,{"$f":"\"    \" &IF('Eligibility Tool'!C55=\"\",\"\",'Eligibility Tool'!C55)","v":"    "},null,null,null,null,null,null,null,null,null,null,"Model #",{"$f":"\"    \" &IF('Eligibility Tool'!N55=\"\",\"\",'Eligibility Tool'!N55)","v":"    "}]
["Input",null,null,null,null,null,null,null,null,"Output",null,null,null,"Combustion Efficiency",null,null,"%"]
["Year Installed",null,null,null,{"$f":"IF('Eligibility Tool'!E56=\"\",\"\",'Eligibility Tool'!E56)","v":""},null,null,null,null,"Quantity",null,null,"Condition of Unit"]
["I/O Reset",null,null,null,null,null,null,null,"Standing Pilot",null,null,null,"Vent Damper"]
["Staging",null,null,null,null,null,null,null,null,"Combustion Air",null,null,null,"Size Acceptable for System"]
["Pipes/Ducts Insulated",null,null,null,null,null,null,null,null,null,"Type or R-value",null,null,null,null,"AFUE","%"]
["Primary Cooling Type",null,null,null,null,null,null,null,null,null,null,null,"Year Installed",null,{"$f":"IF('Eligibility Tool'!E61=\"\",\"\",'Eligibility Tool'!E61)","v":""}]
["Type"]
["Brand",null,{"$f":"IF('Eligibility Tool'!C60=\"\",\"\",'Eligibility Tool'!C60)","v":""},null,null,null,null,null,null,null,null,null,null,"Model #",{"$f":"IF('Eligibility Tool'!N60=\"\",\"\",'Eligibility Tool'!N60)","v":""}]
["Primary Ventilation Type",null,null,null,null,null,null,null,null,null,null,null,"Heat Recovery"]
["Control Strategy"]
["Parking Garage Heating Equipment ",null,null,null,null,null,null,null,null,{"$f":"IF('Eligibility Tool'!J68=\"\",\"\",'Eligibility Tool'!J68)","v":""},null,null,null,null,null,"Temp Set Point",null,null,{"$f":"IF('Eligibility Tool'!Q68=\"\",\"\",'Eligibility Tool'!Q68)","v":""}]
["Ex. Fan Control",null,null,null,null,null,null,null,null,null,null,null,null,"Fan Motor Horsepower (HP)",null,null,null,null,{"$f":"IF('Eligibility Tool'!P69=\"\",\"\",'Eligibility Tool'!P69)","v":""}]
["Current HVAC Maintenance Practices",null,null,null,null,null,null,null,null,{"$f":"IF('Eligibility Tool'!J72=\"\",\"\",'Eligibility Tool'!J72)","v":""},null,null,null,null,"Last Service Date",null,null,{"$f":"IF('Eligibility Tool'!Q72=\"\",\"\",'Eligibility Tool'!Q72)","v":""}]
["Equipment Serviced By",null,null,null,null,null,null,{"$f":"IF('Eligibility Tool'!H73=\"\",\"\",'Eligibility Tool'!H73)","v":""},null,null,null,null,"Contractor Selection",null,null,{"$f":"IF('Eligibility Tool'!N73=\"\",\"\",'Eligibility Tool'!N73)","v":""}]
["Domestic Hot Water (DHW)"]
["System Type",null,null,null,null,null,null,null,null,null,null,"Fuel"]
["Equipment Type",null,null,null,null,null,{"$f":"IF('Eligibility Tool'!M77=\"\",\"\",'Eligibility Tool'!M77)","v":""}]
["Brand",null,{"$f":"\"   \" &IF('Eligibility Tool'!C78=\"\",\"\",'Eligibility Tool'!C78)","v":"   "},null,null,null,null,null,null,null,null,null,null,"Model #",{"$f":"IF('Eligibility Tool'!N78=\"\",\"\",'Eligibility Tool'!N78)","v":""}]
["Input",null,null,null,null,null,null,null,null,"Gallons",null,null,null,"Combustion Efficiency",null,null,"%"]
["Year Installed",null,null,null,{"$f":"IF('Eligibility Tool'!E81=\"\",\"\",'Eligibility Tool'!E81)","v":""},null,null,null,null,"Quantity",null,null,"Condition of Unit"]
["Power Vent",null,null,null,null,null,null,null,null,"Standing Pilot",null,null,null,"Vent Damper"]
["Recirculating System",null,null,null,null,null,null,null,null,null," Control"]
["Pipes Insulated",null,null,null,null,null,null,null,null,"Type or R-value",null,null,null,null,null,"EF/AFUE","%"]
["Current DHW Maintenance Practices",null,null,null,null,null,null,null,null,{"$f":"IF('Eligibility Tool'!J82=\"\",\"\",'Eligibility Tool'!J82)","v":""},null,null,null,null,null,"Last Service Date",null,null,{"$f":"IF('Eligibility Tool'!Q82=\"\",\"\",'Eligibility Tool'!Q82)","v":""}]
["Equipment Serviced By",null,null,null,null,null,null,{"$f":"IF('Eligibility Tool'!H83=\"\",\"\",'Eligibility Tool'!H83)","v":""},null,null,null,null,"Contractor Selection",null,null,{"$f":"IF('Eligibility Tool'!O83=\"\",\"\",'Eligibility Tool'!O83)","v":""}]
["Building Shell"]
["Exterior Wall Construction",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"R-value",null,{"$f":"IF('Eligibility Tool'!O87=\"\",\"\",'Eligibility Tool'!O87)","v":""}]
["Roof Type",null,null,null,null,null,null,null,null,null,null,null,null,"Year Replaced ",null,{"$f":"IF('Eligibility Tool'!M88=\"\",\"\",'Eligibility Tool'!M88)","v":""},"R-value",null,{"$f":"IF('Eligibility Tool'!P88=\"\",\"\",'Eligibility Tool'!P88)","v":""}]
["Window Type ",null,null,null,null,null,null,null,null,null,null,null,"Frame Material"]
["Window Style",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Storms"]
["Lighting"]
["Area",null,null,null,null,null,"Lighting Technology",null,null,null,null,"Lighting Type",null,null,null,"Qty","Control",null,null,"Hrs"]
[{"$f":"IF('Eligibility Tool'!A95=\"\",\"\",'Eligibility Tool'!A95)","v":""},null,null,null,null,null,{"$f":"IF('Eligibility Tool'!G95=\"\",\"\",'Eligibility Tool'!G95)","v":""},null,null,null,null,{"$f":"IF('Eligibility Tool'!L95=\"\",\"\",'Eligibility Tool'!L95)","v":""},null,null,null,null,{"$f":"IF('Eligibility Tool'!P95=\"\",\"\",'Eligibility Tool'!P95)","v":""},null,null,{"$f":"IF('Eligibility Tool'!R95=\"\",\"\",'Eligibility Tool'!R95)","v":""}]
[{"$f":"IF('Eligibility Tool'!A96=\"\",\"\",'Eligibility Tool'!A96)","v":""},null,null,null,null,null,{"$f":"IF('Eligibility Tool'!G96=\"\",\"\",'Eligibility Tool'!G96)","v":""},null,null,null,null,{"$f":"IF('Eligibility Tool'!L96=\"\",\"\",'Eligibility Tool'!L96)","v":""},null,null,null,null,{"$f":"IF('Eligibility Tool'!P96=\"\",\"\",'Eligibility Tool'!P96)","v":""},null,null,{"$f":"IF('Eligibility Tool'!R96=\"\",\"\",'Eligibility Tool'!R96)","v":""}]
[{"$f":"IF('Eligibility Tool'!A97=\"\",\"\",'Eligibility Tool'!A97)","v":""},null,null,null,null,null,{"$f":"IF('Eligibility Tool'!G97=\"\",\"\",'Eligibility Tool'!G97)","v":""},null,null,null,null,{"$f":"IF('Eligibility Tool'!L97=\"\",\"\",'Eligibility Tool'!L97)","v":""},null,null,null,null,{"$f":"IF('Eligibility Tool'!P97=\"\",\"\",'Eligibility Tool'!P97)","v":""},null,null,{"$f":"IF('Eligibility Tool'!R97=\"\",\"\",'Eligibility Tool'!R97)","v":""}]
[{"$f":"IF('Eligibility Tool'!A98=\"\",\"\",'Eligibility Tool'!A98)","v":""},null,null,null,null,null,{"$f":"IF('Eligibility Tool'!G98=\"\",\"\",'Eligibility Tool'!G98)","v":""},null,null,null,null,{"$f":"IF('Eligibility Tool'!L98=\"\",\"\",'Eligibility Tool'!L98)","v":""},null,null,null,null,{"$f":"IF('Eligibility Tool'!P98=\"\",\"\",'Eligibility Tool'!P98)","v":""},null,null,{"$f":"IF('Eligibility Tool'!R98=\"\",\"\",'Eligibility Tool'!R98)","v":""}]
[{"$f":"IF('Eligibility Tool'!A99=\"\",\"\",'Eligibility Tool'!A99)","v":""},null,null,null,null,null,{"$f":"IF('Eligibility Tool'!G99=\"\",\"\",'Eligibility Tool'!G99)","v":""},null,null,null,null,{"$f":"IF('Eligibility Tool'!L99=\"\",\"\",'Eligibility Tool'!L99)","v":""},null,null,null,null,{"$f":"IF('Eligibility Tool'!P99=\"\",\"\",'Eligibility Tool'!P99)","v":""},null,null,{"$f":"IF('Eligibility Tool'!R99=\"\",\"\",'Eligibility Tool'!R99)","v":""}]
[{"$f":"IF('Eligibility Tool'!A100=\"\",\"\",'Eligibility Tool'!A100)","v":""},null,null,null,null,null,{"$f":"IF('Eligibility Tool'!G100=\"\",\"\",'Eligibility Tool'!G100)","v":""},null,null,null,null,{"$f":"IF('Eligibility Tool'!L100=\"\",\"\",'Eligibility Tool'!L100)","v":""},null,null,null,null,{"$f":"IF('Eligibility Tool'!P100=\"\",\"\",'Eligibility Tool'!P100)","v":""},null,null,{"$f":"IF('Eligibility Tool'!R100=\"\",\"\",'Eligibility Tool'!R100)","v":""}]
[{"$f":"IF('Eligibility Tool'!A101=\"\",\"\",'Eligibility Tool'!A101)","v":""},null,null,null,null,null,{"$f":"IF('Eligibility Tool'!G101=\"\",\"\",'Eligibility Tool'!G101)","v":""},null,null,null,null,{"$f":"IF('Eligibility Tool'!L101=\"\",\"\",'Eligibility Tool'!L101)","v":""},null,null,null,null,{"$f":"IF('Eligibility Tool'!P101=\"\",\"\",'Eligibility Tool'!P101)","v":""},null,null,{"$f":"IF('Eligibility Tool'!R101=\"\",\"\",'Eligibility Tool'!R101)","v":""}]
[{"$f":"IF('Eligibility Tool'!A102=\"\",\"\",'Eligibility Tool'!A102)","v":""},null,null,null,null,null,{"$f":"IF('Eligibility Tool'!G102=\"\",\"\",'Eligibility Tool'!G102)","v":""},null,null,null,null,{"$f":"IF('Eligibility Tool'!L102=\"\",\"\",'Eligibility Tool'!L102)","v":""},null,null,null,null,{"$f":"IF('Eligibility Tool'!P102=\"\",\"\",'Eligibility Tool'!P102)","v":""},null,null,{"$f":"IF('Eligibility Tool'!R102=\"\",\"\",'Eligibility Tool'!R102)","v":""}]
[{"$f":"IF('Eligibility Tool'!A103=\"\",\"\",'Eligibility Tool'!A103)","v":""},null,null,null,null,null,{"$f":"IF('Eligibility Tool'!G103=\"\",\"\",'Eligibility Tool'!G103)","v":""},null,null,null,null,{"$f":"IF('Eligibility Tool'!L103=\"\",\"\",'Eligibility Tool'!L103)","v":""},null,null,null,null,{"$f":"IF('Eligibility Tool'!P103=\"\",\"\",'Eligibility Tool'!P103)","v":""},null,null,{"$f":"IF('Eligibility Tool'!R103=\"\",\"\",'Eligibility Tool'!R103)","v":""}]
[{"$f":"IF('Eligibility Tool'!A104=\"\",\"\",'Eligibility Tool'!A104)","v":""},null,null,null,null,null,{"$f":"IF('Eligibility Tool'!G104=\"\",\"\",'Eligibility Tool'!G104)","v":""},null,null,null,null,{"$f":"IF('Eligibility Tool'!L104=\"\",\"\",'Eligibility Tool'!L104)","v":""},null,null,null,null,{"$f":"IF('Eligibility Tool'!P104=\"\",\"\",'Eligibility Tool'!P104)","v":""},null,null,{"$f":"IF('Eligibility Tool'!R104=\"\",\"\",'Eligibility Tool'!R104)","v":""}]
["Laundry"]
["Location ",null,null,null,null,null,null,null,null,null,"Equipment Owner"]
["# of Washers",null,null,null,{"$f":"IF('Eligibility Tool'!E113=\"\",\"\",'Eligibility Tool'!E113)","v":""},null,null,null,null,"$/Load",{"$f":"IF('Eligibility Tool'!J113=\"\",\"\",'Eligibility Tool'!J113)","v":""},null,{"$f":"IF('Eligibility Tool'!L113=\"\",\"\",'Eligibility Tool'!L113)","v":""}]
["Loads per Machine per Month",null,null,null,null,null,null,null,{"$f":"IF('Eligibility Tool'!J114=\"\",\"\",'Eligibility Tool'!J114)","v":""},null,null,null,"or","Total Monthly Income",null,null,{"$f":"IF('Eligibility Tool'!P114=\"\",\"\",'Eligibility Tool'!P114)","v":""}]
["# of Dryers",null,null,null,{"$f":"IF('Eligibility Tool'!E115=\"\",\"\",'Eligibility Tool'!E115)","v":""},null,null,null,null,"$/Load",{"$f":"IF('Eligibility Tool'!J115=\"\",\"\",'Eligibility Tool'!J115)","v":""},null,"Dryer Type",null,{"$f":"IF('Eligibility Tool'!N115=\"\",\"\",'Eligibility Tool'!N115)","v":""}]

{"sheet":"Lookup Info","index":3,"n_rows":108,"n_cols":12,"rows_kept":108,"cut":false,"hidden":true,"merged":[]}
["Electric Utilities","Gas Utilities","Primary Heating Type","Building Type","Wall Construction","Roof Type","Window Type","Frame Material","Window Style","Thermostat Type","Stove Type","Affordable Housing Type"]
["Investor Owned Utilities","Investor Owned Utilities","Individual","Apartment","Wood Frame","Sloped Roof","Single Pane","Aluminum","Double Hung","Mercury Dial","Electric ","Section 8"]
["   Alliant Energy","   Alliant Energy","Central","Condominium","Concrete Block","Flat Roof (Attic Space)","Double Pane","Vinyl","Awning","Electronic","Natural Gas","Section 42"]
["   Madison Gas & Electric","   Madison Gas & Electric",null,"Assisted Living","Metal Frame","Flat Roof (No Attic Space)","Triple Pane","Wood","Fixed","Programmable","LP","Section 236"]
["   Superior Water, Light & Power","   Superior Water, Light & Power",null,"Apartment/Commercial","Other (Provide Explanation)",null,"Other (Provide Explanation)","Other (Provide Explanation)","Casement","Thermostatic Radiator Valve (TRV)",null,"Section 221"]
["   We Energies","   We Energies",null,"Condo/Commercial",null,null,null,null,"Sliders","Pneumatic ",null,"Section 202 (elderly households)"]
["   Wisconsin Public Service Corp. ","   Wisconsin Public Service Corp. ",null,null,null,null,null,null,"Other (Provide Explanation)","Other (Provide Explanation)",null,"Section 515 (rural renters)"]
["   Xcel Energy ","   Xcel Energy ",null,null,null,null,null,null,null,null,null,"Section 811 (people with disabilities)"]
["Municipal Utilities & Cooperatives","Municipal Utilities & Cooperatives","Heating Equipment","Cooling Equipment","Ventilation Type","DHW Equipment","Lighting Location","Lighting Technology","Lighting Type","Lighting Control",null,"Parking (used check boxes)"]
["   Adams-Columbia Electric Cooperative","   City Gas Company","Boiler (Water)","Sleeve AC","Central (Makeup Air System)","Stand Alone Tank","Exit Signs","Incandescent","Screw-based Lamp","Switch ",null,"Lot"]
["   Algoma Utilities","   Midwest Natural Gas, Inc. ","Boiler (Steam)","Window AC","Individual (Bathroom Exhaust Only)","Storage Tank (Internal Heat Exchanger)","Exterior","CFL","Pin-based Lamp","Motion ",null,"Underground"]
["   Arcadia Electric Utility","   St. Croix Gas","City Steam","Split System","None","Storage Tank (External Heat Exchanger)","Hall","LED","GU-24 based Lamp","Photo eye",null,"Detached Garage"]
["   Argyle Electric & Water Utility",null,"Electric Baseboard","Chiller","Control Strategy","Solar ","Stairwell","Linear Fluorescent","T-12","Timer",null,"Attached Garage"]
["   Bangor Municipal Utility",null,"Gas Furnace","Rooftop","Switch","Other (Provide Explanation)","Laundry Room","HID","T-8","None",null,"None"]
["   Barron Light & Water",null,"Electric Furnace","None","Timer",null,"Basement","Halogen","High Performance (HP) T-8","Other (Provide Explanation)",null,"Other (Provide Explanation)"]
["   Belmont Municipal Light & Water",null,"Heat Pump","Other (Provide Explanation)","Occupancy","Recirculator Control","Parking Garage","Induction","T-5"]
["   Benton Electric & Water Utility ",null,"Gas Rooftop",null,"Schedule","Time Clock","Community Room","Circline","High Pressure Sodium (HPS)"]
["   Boscobel Utilities",null,"Electric Rooftop","Cooling Type","None","Aquastat","In-unit ","Other (Provide Explanation)","Metal Halide (MH)"]
["   Brodhead Water & Light",null,"Other (Provide Explanation)","Central","Other (Provide Explanation)","Demand","Other Common Area",null,"Mercury Vapor (MV)"]
["   Cadott Light & Water Department",null,null,"Individual",null,"None","Other (Provide Explanation)",null,"Low Pressure Sodium (LPS)"]
["   Cashton Light & Water",null,"Current Replacement Plan",null,"Parking Garage Ventilation Control","Other (Provide Explanation)",null,null,"No Additional Detail"]
["   Cedarburg Light & Water",null,"Replace with Similar Equipment",null,"None (24 hr Operation)",null,null,null,"Other (Provide Explanation)"]
["   Centuria Municipal Electric Utility",null,"Replace with High Efficiency Equipment",null,"Time Clock","Flow Rates"]
["   Clark Electric Cooperative",null,"Replace on Fail",null,"Carbon Monoxide (CO)",">3.0"]
["   Clintonville Utilities",null,"Repair Indefinitely",null,"Shut Off",3,null,"Incandescent","No Additional Detail"]
["   Columbus Water & Light",null,"None",null,"Switch",2.5,null,null,"Other (Provide Explanation)"]
["   Consolidated Water Power Company",null,"Other (Provide Explanation)",null,"None (No Ventilation)",2,null,"CFL","Screw-based Lamp"]
["   Cornell Municipal Light Department",null,null,null,null,1.5,null,null,"Pin-based Lamp"]
["   Cuba City Light & Water",null,"Parking Garage Heating Equipment",null,null,1,null,null,"GU-24 based Lamp"]
["   Cumberland Municipal Utility",null,"None",null,null,0.5,null,null,"Other (Provide Explanation)"]
["   Dahlberg Light & Power Company",null,"Gas Unit Heater",null,null,null,null,"Linear Fluorescent","T-12"]
["   Eagle River Light & Water Utility",null,"Electric Unit Heater",null,null,null,null,null,"T-8"]
["   Eau Claire Energy Cooperative",null,"Gas Furnace",null,null,null,null,null,"High Performance (HP) T-8"]
["   Elkhorn Light & Water",null,"Electric Furnace",null,null,null,null,null,"T-5"]
["   Elroy Electric & Water Utility",null,"Direct Fired Unit",null,null,null,null,null,"Other (Provide Explanation)"]
["   Evansville Water & Light",null,"Boiler (Water)",null,null,null,null,"Circline","T-12"]
["   Fennimore Municipal Utility ",null,"Boiler (Steam)",null,null,null,null,null,"T-8"]
["   Florence Utilities",null,"Other (Provide Explanation)",null,"Contractor Selection",null,null,null,"Other (Provide Explanation)"]
["   Gresham Water & Electric Plant",null,null,null,"Always Use Same",null,null,"HID","High Pressure Sodium (HPS)"]
["   Hartford Electric",null,"HVAC Maintenance","Maintained By","Selected on System",null,null,null,"Metal Halide (MH)"]
["   Hazel Green Light & Water Utility",null,"Repaired as Needed","Maintenance Staff","Selected on Project",null,null,null,"Mercury Vapor (MV)"]
["   Hustisford Utilities",null,"Maintained on Schedule","Contractor","Based on Quotes",null,null,null,"Low Pressure Sodium (LPS)"]
["   Jefferson Utilities",null,"Tuned & Cleaned Annually","Owner","Other (Provide Explanation)",null,null,null,"Other (Provide Explanation)"]
["   Juneau Utilities",null,"Maintained per Service Contract","Equip Leasing Company",null,null,null,"LED","No Additional Detail"]
["   Kaukauna Utilities",null,"None","Other (Provide Explanation)",null,null,null,null,"Other (Provide Explanation)"]
["   Kiel Utilities",null,"Other (Provide Explanation)",null,null,null,null,"Induction","No Additional Detail"]
["   La Farge Municipal Utilities",null,null,null,null,null,null,null,"Other (Provide Explanation)"]
["   Lake Mills Light & Water",null,null,null,null,null,null,"Halogen","Screw-based Lamp"]
["   Lodi Utilities",null,null,null,null,null,null,null,"Pin-based Lamp"]
["   Manitowoc Public Utilities",null,null,null,null,null,null,null,"Other (Provide Explanation)"]
["   Marshfield Utilities"]
["   Mazomanie Electric Utility"]
["   Medford Electric Utility"]
["   Menasha Utilities"]
["   Merrillan Electric & Water Utility"]
["   Mount Horeb Utilities"]
["   Muscoda Utilities"]
["   New Glarus Utilities"]
["   New Holstein Utilities"]
["   New Lisbon Municipal Light & Water"]
["   New London Utilities"]
["   New Richmond Utilities"]
["   North Central Power Co. Inc."]
["   Northwestern Wisconsin Electric Company"]
["   Oakdale Electric Cooperative"]
["   Oconomowoc Utilities"]
["   Oconto Electric Cooperative"]
["   Oconto Falls Municipal Utilities"]
["   Pardeeville Public Utilities"]
["   Pierce Pepin Cooperative Services"]
["   Pioneer Power & Light Co."]
["   Plymouth Utilities"]
["   Polk-Burnett Electric Cooperative"]
["   Prairie du Sac Utilities"]
["   Price Electric Cooperative"]
["   Princeton Light & Water Department"]
["   Reedsburg Utility Commission"]
["   Rice Lake Utilities"]
["   City Utilities of Richland Center"]
["   Richland Electric Cooperative"]
["   River Falls Municipal Utilities"]
["   Rock Energy Cooperative "]
["   Sauk City Utilities "]
["   Scenic Rivers Energy Cooperative"]
["   Shawano Municipal Utilities"]
["   Sheboygan Falls Utilities"]
["   Shullsburg Electric Utility"]
["   Slinger Utilities"]
["   Spooner Municipal Electric Utility"]
["   Stoughton Utilities"]
["   Stratford Water & Electric Department"]
["   Sturgeon Bay Utilities"]
["   Sun Prairie Utilities"]
["   Taylor Electric Cooperative"]
["   Trempealeau Municipal Utilities"]
["   Two Rivers Water & Light"]
["   Vernon Electric Cooperative"]
["   Viola Municipal Electric Utility"]
["   Waterloo Utilities"]
["   Waunakee Utilities"]
["   Waupun Utilities"]
["   Westby Utilities"]
["   Westfield Electric Company"]
["   Whitehall Electric Utility"]
["   Wisconsin Dells Water & Light Utility"]
["   Wisconsin Rapids Water Works & Lighting Comm.",null,"These are phantom controls."]
["   Wonewoc Water & Light Department",null,"They act as containers for code that makes the checkboxes behave correctly."]
[null,null,"Please don't disturb them."]

{"sheet":"Additional Info","index":4,"n_rows":49,"n_cols":1,"rows_kept":49,"cut":false,"hidden":false,"merged":[[18,1,18,14],[24,1,24,23],[48,0,50,17],[16,1,16,23],[20,1,20,8],[22,1,22,8],[38,1,38,23],[40,1,40,21],[42,1,42,17],[44,1,44,10],[26,1,26,17],[28,1,28,3],[30,1,30,3],[32,1,32,3],[34,1,34,7],[36,1,36,6]]}
["Additional Information"]
["See below for examples or further explanation of a technology. "]
[]
["Window Styles"]
["Awning"]
["Casement"]
["Double Hung"]
["Fixed"]
["Sliders"]
[]
["Lighting"]
["CFL-Compact Flourscent Lamp"]
["LED-Light Emitting Diode"]
["HID-High Intensity Discharage"]
[]
["Types"]
["Incandescent Lamp Samples"]
[]
["Screw-based CFL Samples (notice the ballast)"]
[]
["Pin-based CFL Samples (notice the pin-base)"]
[]
["GU-24 Based CFL Samples (notice the base)"]
[]
["LED Samples                 (notice the heat sink),     (individual LEDs)    or (see model)"]
[]
["Halogen Lamp Samples"]
[]
["T-12 Lamp Sample (notice the diameter 12/8ths or 1.5\")"]
[]
["T-8 Lamp Sample (notice the diameter 8/8ths or 1\")"]
[]
["T-5 Lamp Sample (notice the diameter 5/8ths or 0.625\")"]
[]
["U-tube Fluorescent Samples"]
[]
["Circline Fluorescent Samples"]
[]
["High Intensity Discharge (HID)-Metal Halide (MH) Samples (produces white light)"]
[]
["High Intensity Discharge (HID)-High Pressure Sodium (HPS) Samples (produces yellowish light)"]
[]
["High Intensity Discharge (HID)-Mercury Vapor (MV) Samples (produces blue/green light)"]
[]
["Induction Lighting Samples"]
[]
[]
["Disclaimer"]
["This reference contains images that are not owned by Franklin Energy.   Any copyright or other intellectual property rights in the images used in this reference remain the property of their respective owners.  Any use of these images that does not constitute “fair use” under 17 U.S.C. § 107 requires express permission from the copyright owner.  Franklin Energy disclaims any responsibility for infringing material.  "]

{"sheet":"DI Request","index":5,"n_rows":41,"n_cols":18,"rows_kept":41,"cut":false,"hidden":true,"merged":[[40,0,41,18],[31,0,31,8],[31,9,31,11],[31,12,31,15],[31,16,31,18],[32,0,32,3],[32,4,32,10],[32,11,32,12],[32,13,32,18],[33,0,33,18],[34,0,34,6],[34,7,34,18],[35,0,35,18],[36,0,36,1],[36,2,36,9],[36,12,36,18],[37,0,37,6],[37,7,37,18],[30,0,30,3],[30,4,30,7],[30,8,30,9],[30,10,30,11],[30,12,30,15],[30,16,30,18],[28,0,28,7],[28,8,28,13],[28,14,28,18],[29,0,29,5],[29,6,29,9],[29,10,29,13],[29,14,29,18],[26,0,26,10],[26,11,26,15],[26,17,26,18],[27,0,27,8],[27,9,27,10],[27,11,27,15],[27,16,27,18],[24,0,24,3],[24,4,24,9],[24,10,24,11],[24,12,24,18],[25,0,25,18],[22,0,22,3],[22,4,22,12],[22,13,22,18],[23,0,23,3],[23,4,23,11],[23,13,23,18],[20,0,20,3],[20,4,20,11],[20,13,20,18],[21,0,21,3],[21,4,21,9],[21,10,21,11],[21,12,21,18],[19,0,19,3],[19,4,19,12],[19,13,19,18],[17,1,17,8],[17,10,17,12],[17,13,17,14],[17,15,17,18],[18,0,18,18],[15,0,15,3],[15,4,15,10],[15,11,15,12],[15,13,15,18],[16,0,16,3],[16,4,16,18],[13,0,13,3],[13,4,13,10],[13,11,13,12],[13,13,13,18],[14,0,14,3],[14,4,14,10],[14,11,14,12],[14,13,14,18],[10,0,10,18],[11,0,11,1],[11,2,11,18],[12,0,12,3],[12,4,12,10],[12,11,12,12],[12,13,12,18],[8,0,8,6],[8,7,8,11],[8,13,8,18],[9,1,9,11],[9,13,9,18],[7,0,7,3],[7,4,7,10],[7,11,7,18],[5,0,5,3],[5,4,5,8],[5,9,5,11],[5,13,5,14],[5,15,5,18],[6,0,6,5],[6,6,6,13],[6,15,6,18],[2,0,2,4],[2,5,2,18],[3,0,3,5],[3,6,3,18],[4,1,4,8],[4,10,4,12],[4,13,4,14],[4,15,4,18],[0,0,0,18],[1,0,1,18]]}
["Multifamily Energy Savings Program (MESP) Direct Install Request Form"]
["Property Information"]
["Property Name",null,null,null,null,{"$f":"IF('Eligibility Tool'!$F$12=\"\",\"\",'Eligibility Tool'!$F$12)","v":""}]
["Property Address(s)",null,null,null,null,null,{"$f":"IF('Eligibility Tool'!$G$13=\"\",\"\",'Eligibility Tool'!$G$13)","v":""}]
["City",{"$f":"IF('Eligibility Tool'!$B$14=\"\",\"\",'Eligibility Tool'!$B$14)","v":""},null,null,null,null,null,null,null,"State",{"$f":"IF('Eligibility Tool'!$K$14=\"\",\"\",'Eligibility Tool'!$K$14)","v":""},null,null,"Zip Code",null,{"$f":"IF('Eligibility Tool'!$P14=\"\",\"\",'Eligibility Tool'!$P14)","v":""}]
["# of Buildings",null,null,null,{"$f":"IF('Eligibility Tool'!$E$15=\"\",\"\",'Eligibility Tool'!$E$15)","v":""},null,null,null,null,"Total # of Units",null,null,{"$f":"IF('Eligibility Tool'!$M$15=\"\",\"\",'Eligibility Tool'!$M$15)","v":""},"# of Floors",null,{"$f":"IF('Eligibility Tool'!$P15=\"\",\"\",'Eligibility Tool'!$P15)","v":""}]
["Building Breakdown",null,null,null,null,null,{"$f":"IF('Eligibility Tool'!$G$16=\"\",\"\",'Eligibility Tool'!$G$16)","v":""},null,null,null,null,null,null,null,"Year Built",{"$f":"IF('Eligibility Tool'!$P16=\"\",\"\",'Eligibility Tool'!$P16)","v":""}]
["Building Type",null,null,null,{"$f":"IF('Eligibility Tool'!$E$17=\"\",\"\",'Eligibility Tool'!$E$17)","v":""},null,null,null,null,null,null,{"$f":"IF('Eligibility Tool'!$L$17=\"\",\"\",'Eligibility Tool'!$L$17)","v":""}]
["On-site Contact Name",null,null,null,null,null,null,{"$f":"IF('Eligibility Tool'!$H$20=\"\",\"\",'Eligibility Tool'!$H$20)","v":""},null,null,null,null,"Phone #",{"$f":"IF('Eligibility Tool'!$N$20=\"\",\"\",'Eligibility Tool'!$N$20)","v":""}]
["Email",{"$f":"IF('Eligibility Tool'!$B$21=\"\",\"\",'Eligibility Tool'!$B$21)","v":""},null,null,null,null,null,null,null,null,null,null,"Fax #",{"$f":"IF('Eligibility Tool'!$N$20=\"\",\"\",'Eligibility Tool'!$N$20)","v":""}]
["Management Company or Property Owner"]
["Name",null,{"$f":"IF('Eligibility Tool'!$C$23=\"\",\"\",'Eligibility Tool'!$C$23)","v":""}]
["Owner Name",null,null,null,{"$f":"IF('Eligibility Tool'!$E24=\"\",\"\",'Eligibility Tool'!$E24)","v":""},null,null,null,null,null,null,"Contact Name",null,{"$f":"IF('Eligibility Tool'!N24=\"\",\"\",'Eligibility Tool'!N24)","v":""}]
["Owner Phone",null,null,null,{"$f":"IF('Eligibility Tool'!$E25=\"\",\"\",'Eligibility Tool'!$E25)","v":""},null,null,null,null,null,null,"Contact Phone",null,{"$f":"IF('Eligibility Tool'!N25=\"\",\"\",'Eligibility Tool'!N25)","v":""}]
["Owner Fax",null,null,null,{"$f":"IF('Eligibility Tool'!$E26=\"\",\"\",'Eligibility Tool'!$E26)","v":""},null,null,null,null,null,null,"Contact Fax",null,{"$f":"IF('Eligibility Tool'!N26=\"\",\"\",'Eligibility Tool'!N26)","v":""}]
["Owner Email",null,null,null,{"$f":"IF('Eligibility Tool'!$E27=\"\",\"\",'Eligibility Tool'!$E27)","v":""},null,null,null,null,null,null,"Contact Email",null,{"$f":"IF('Eligibility Tool'!N27=\"\",\"\",'Eligibility Tool'!N27)","v":""}]
["Address",null,null,null,{"$f":"IF('Eligibility Tool'!C28=\"\",\"\",'Eligibility Tool'!C28)","v":""}]
["City",{"$f":"IF('Eligibility Tool'!B29=\"\",\"\",'Eligibility Tool'!B29)","v":""},null,null,null,null,null,null,null,"State",{"$f":"IF('Eligibility Tool'!K29=\"\",\"\",'Eligibility Tool'!K29)","v":""},null,null,"Zip Code",null,{"$f":"IF('Eligibility Tool'!P29=\"\",\"\",'Eligibility Tool'!P29)","v":""}]
["Utility Information"]
["Gas Utility ",null,null,null,{"$f":"\"    \"&IF('Eligibility Tool'!E35=\"\",\"\",'Eligibility Tool'!E35)","v":"    "},null,null,null,null,null,null,null,null,{"$f":"IF('Eligibility Tool'!N35=\"\",\"\",'Eligibility Tool'!N35)","v":""}]
["Gas Account #",null,null,null,{"$f":"IF('Eligibility Tool'!E36=\"\",\"\",'Eligibility Tool'!E36)","v":""},null,null,null,null,null,null,null,"Meter #",{"$f":"IF('Eligibility Tool'!N36=\"\",\"\",'Eligibility Tool'!N36)","v":""}]
["Metering",null,null,null,null,null,null,null,null,null,"Comments",null,{"$f":"IF('Eligibility Tool'!M37=\"\",\"\",'Eligibility Tool'!M37)","v":""}]
["Electric Utility",null,null,null,{"$f":"IF('Eligibility Tool'!E38=\"\",\"\",'Eligibility Tool'!E38)","v":""},null,null,null,null,null,null,null,null,{"$f":"IF('Eligibility Tool'!N38=\"\",\"\",'Eligibility Tool'!N38)","v":""}]
["Elec Account #",null,null,null,null,null,null,null,null,null,null,null,"Meter #",{"$f":"IF('Eligibility Tool'!N39=\"\",\"\",'Eligibility Tool'!N39)","v":""}]
["Metering",null,null,null,null,null,null,null,null,null,"Comments",null,{"$f":"IF('Eligibility Tool'!M40=\"\",\"\",'Eligibility Tool'!M40)","v":""}]
["Direct Install Eligibility"]
["Have you had DI at your property since 2005?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date",{"$f":"IF('Eligibility Tool'!R44=\"\",\"\",'Eligibility Tool'!R44)","v":""}]
["Typical Showerhead Flow rate (GPM)",null,null,null,null,null,null,null,null,{"$f":"IF('Eligibility Tool'!J45=\"\",\"\",'Eligibility Tool'!J45)","v":""},null,"Typical Faucet Flow rate (GPM)",null,null,null,null,{"$f":"IF('Eligibility Tool'!Q45=\"\",\"\",'Eligibility Tool'!Q45)","v":""}]
["Water Heater Fuel Source",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Eligibility Tool'!O46=\"\",\"\",'Eligibility Tool'!O46)","v":""}]
["Water Heater Type",null,null,null,null,null,null,null,null,null,"Water Heater Location"]
["# of Full Baths",null,null,null,{"$f":"IF('Eligibility Tool'!E48=\"\",\"\",'Eligibility Tool'!E48)","v":""},null,null,null,"# of Half Baths",null,{"$f":"IF('Eligibility Tool'!K48=\"\",\"\",'Eligibility Tool'!K48)","v":""},null,"# Handicap Accessible",null,null,null,{"$f":"IF('Eligibility Tool'!Q48=\"\",\"\",'Eligibility Tool'!Q48)","v":""}]
["Average # of Lamps per Unit (Total)",null,null,null,null,null,null,null,null,{"$f":"IF('Eligibility Tool'!J49=\"\",\"\",'Eligibility Tool'!J49)","v":""},null,null,"# of Decorative Lamps",null,null,null,{"$f":"IF('Eligibility Tool'!Q49=\"\",\"\",'Eligibility Tool'!Q49)","v":""}]
["Exit Sign Type",null,null,null,null,null,null,null,null,null,null,"# of Exit Signs",null,{"$f":"IF('Eligibility Tool'!N50=\"\",\"\",'Eligibility Tool'!N50)","v":""}]
["Customer Legal Information"]
["Customer Legal Name:"]
["Tax Identification Number (complete ONE only, must be 9 digits):"]
[" FEIN #: ",null,null,null,null,null,null,null,null,null,"OR","SSN:"]
["Business Classification: "]
[]
["Customer Signature: ",null,null,null,null,null,null,null,null,null,"Customer Name (Print):",null,null,null,null,null,"Date: "]
["By signing above I authorize Franklin Energy Services, LLC to enter the property for the pupose of installing energy efficiency measures and performing an energy assessment. I agree to notify tenants in accordance with Wisconsin tenant-landlord laws prior to their arrival."]