{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Introduction","Data Dictionary","Grantee Dashboard","Expenditure Graph Data","Expenditure Graph","Audit-Retrofit Graph Data","Assessments & Upgrades Graph"],"not_rendered":{"charts":4,"images":0,"macros":1,"external_links":5,"defined_names":18,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Expenditure Graph","index":4,"reason":"not_a_worksheet"},{"sheet":"Assessments & Upgrades Graph","index":6,"reason":"not_a_worksheet"}],"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":"Introduction","index":0,"n_rows":19,"n_cols":8,"rows_kept":19,"cut":false,"hidden":false,"merged":[[4,1,5,1],[8,1,20,1],[4,2,5,22],[1,2,1,22],[9,7,10,21],[12,7,13,21],[15,7,16,21],[18,7,19,21]]}
[]
[null,null,"Grantee Dashboard"]
[]
[]
[null,"Introduction","This spreadsheet presents a summary of data reported by an organization awarded federal financial assistance (cooperative agreements or grants) by the U.S. Department of Energy (DOE) Better Buildings Neighborhood Program (BBNP) from July 2010 or September 2010 through September 30, 2014. This document is not an evaluation of the BBNP program or a final report of award recipient activities. The purpose of this document is to provide a summary of data reported quarterly by recipients.\n\nThe BBNP included 34 (25 topic 1 and 9 topic 2) Energy Efficiency Conservation Block Grants (EECBGs) and seven State Energy Program (SEP) cooperative agreements. Topic 1 EECBGs were awarded at the beginning of June 2010, Topic 2 EECBGs were awarded in August 2010, and SEP agreements were awarded in October 2010. The first Quarterly Program Reports were due from recipients for Q4-2010 (grant start date through December 30, 2010) regardless of when the awards occurred. \n\nEECBG (34) and SEP (7) awards had slightly different requirements for BBNP quarterly Program Reports. For example, reporting job hours worked was mandatory for EECBG awards and voluntary for SEP. Reporting workers trained and certified was mandatory for SEP awards and voluntary for EECBG. Reporting the number of active contractors performing retrofits under the program was mandatory for EECBG awards and voluntary for SEP.\n\nThe data summary provided in this document is based on information recipients formally submitted to DOE using the BBNP Quarterly Program Report. Recipients reported quarterly totals for some information like spending, estimated energy savings, audits completed, and workers trained or certified, while information like invoiced cost and loan amount was reported for each upgrade project. A total invoiced cost or loan amount is obtained from summing all the values reported for each upgrade project record that included this information. Estimated energy savings was reported as a total for the quarter."]
[]
[]
[]
[null,"Links"]
[null,null,null,null,null,null,null,"This tab provides a brief description of key data fields in the Grantee Dashboard tab."]
[]
[]
[null,null,null,null,null,null,null,"This tab includes important project information that include programmatic information, job hours, invoiced cost, assessments and upgrades, total energy savings, number of loans and other details. "]
[]
[]
[null,null,null,null,null,null,null,"This tab shows the cumulative energy assessments and upgrades reported through the end of September 2014 and the estimated annual source energy savings."]
[]
[]
[null,null,null,null,null,null,null,"This tab shows the total recipient expenditures, other federal expenditures,  and non-federal expenditures  (leveraged spending) compared to the total investment in building upgrades (reported as invoiced cost)."]

{"sheet":"Data Dictionary","index":1,"n_rows":70,"n_cols":3,"rows_kept":70,"cut":false,"hidden":false,"merged":[[29,2,31,2],[29,0,32,0],[33,0,34,0],[35,0,38,0],[39,0,69,0],[1,0,4,0],[5,0,6,0],[8,0,14,0],[15,0,21,0],[24,0,28,0]]}
["Data Field Section","Data Field ","Description"]
["Outlays","Total Marketing & Outreach","This field consists of grant outlays for communications activities designed to identify, reach and motivate potential program participants to take actions to either learn more (e.g. assessment or other informational activity) energy efficiency or initiate an energy efficiency upgrade at the program level.  "]
[null,"Labor & Materials Cost","This field consists of grant outlays incurred as part of an assessment or upgrade directly associated with the installation of more energy efficient equipment, appliances, or building components (e.g. insulation, windows, etc.) at the program level. "]
[null,"Other Program Expenses","This field consists of other program grant outlays for the quarter at the program level, not classified as materials, labor, marketing, or outreach. "]
[null,"Total Grantee Outlays","This field is the total grant outlays for the quarter, calculated by the sum of the three categories above - Total Marketing & Outreach, Labor & Materials Cost, and Other Program Expenses. Outlays are distinct from DOE's definition of expenditures (i.e., outlays do not include funds drawn down to capitalize a loan fund). Outlays represent actual grant funds spent on program delivery and any associated incentives or loans issued during the quarter."]
["Leveraging","Other Federal Expenditures","This field is the total amount of other Federal leveraged funds expended by the awardee during the most recent quarter.  Other federal funds many include funds from EECBG and SEP, loans from HUD, etc."]
[null,"Non-Federal Expenditures","This field is the total estimated amount of Non-Federal funds expended during the most recent quarter.  This includes third-party, in-kind contributions, and the portion of the costs of a federally assisted project or program not borne by the Federal Government."]
["Invoiced Cost","Retrofit Invoiced Cost","This field is the total cost of the upgrade (customer contribution plus BetterBuildings funds plus other leveraged funds.) Other leveraged funds can include those from both Federal and non-Federal sources (EECBG, SEP, financial institutions etc.)"]
["Assessments","Residential Single-Family","This field is the total number of residential single-family assessments completed among BB and leveraged partners. "]
[null,"Residential Multi-Family Units","This field is the total number of residential multi-family unit assessments completed among BB and leveraged partners. "]
[null,"Residential Multi-Family Buildings","This field is the total number of residential multi-family building assessments completed among BB and leveraged partners."]
[null,"Commercial Buildings","This field is the total number of commercial building assessments completed among BB and leveraged partners."]
[null,"Industrial Buildings","This field is the total number of industrial building assessments completed among BB and leveraged partners."]
[null,"Agriculture Buildings","This field is the total number of agricultural building assessments completed among BB and leveraged partners."]
[null,"Total Assessments","This field is the total number of assessments summed from the above building sectors."]
["Upgrades","Residential Single-Family","This field is the total number of residential single-family upgrades completed among BB and leveraged partners. "]
[null,"Residential Multi-Family Units","This field is the total number of residential multi-family unit upgrades completed among BB and leveraged partners. "]
[null,"Residential Multi-Family Buildings","This field is the total number of residential multi-family building upgrades completed among BB and leveraged partners."]
[null,"Commercial Buildings","This field is the total number of commercial building upgrades completed among BB and leveraged partners."]
[null,"Industrial Buildings","This field is the total number of industrial building upgrades completed among BB and leveraged partners."]
[null,"Agriculture Buildings","This field is the total number of agricultural building upgrades completed among BB and leveraged partners."]
[null,"Total Upgrades","This field is the total number of upgrades summed from the above building sectors."]
[null,"Commercial Buildings Floorspace (square feet)*","This field is the total commercial building floorspace upgraded, that includes all the area enclosed by the exterior walls of the building, both finished and unfinished, including indoor parking facilities, basements, hallways, lobbies, stairways, and elevator shafts."]
[null,"Total Job Hours","This field is the total job hours worked in that quarter. A job hour worked includes hours worked administrating or working under projects funded by BBNP and leveraged funds (i.e., state and local funds, utilities, financial institutions, private contributions, etc). This includes, but is not limited to, administrative staff, consultants and contractors involved in the management or deployment of upgrade and assessment activities. "]
["Total Estimated Annual Energy Savings","Electricity (kWh)","This field is the total estimated annual Electricity kWh saved based on the total upgrade measures installed during that quarter. Additionally, any electricity kWh savings through direct installations conducted are also included. "]
[null,"Natural Gas (therms)","This field is the total estimated annual Natural Gas therms saved based on the total upgrade measures installed during the most recent quarter. Additionally, any natural gas therm savings through direct installations conducted are also included. "]
[null,"Heating Oil (gallons)","This field is the total estimated annual Heating Oil gallons saved based on the total upgrade measures installed during the most recent quarter. Additionally, any heating oil gallon savings through direct installations conducted are also included. "]
[null,"LPG (gallons)","This field is the total estimated annual LPG gallons saved based on the total upgrade measures installed during the most recent quarter. Additionally, any LPG gallon savings through direct installations conducted are also included. "]
[null,"Energy Cost Savings","This field is the total annual cost savings based on the total measures installed during the most recent quarter.  Additionally, any cost savings through direct installations conducted are also included. "]
["Market Transformation","Market Definition - Residential","The Market Definition must be broad enough to require the upgrade of a substantial number of buildings to reach the 2% annual goal. \"Substantial\" would mean that the minimum market would be comprised of 50,000 residential buildings such that 1,000 homes would have to be upgraded annually. Markets can cross city and state boundaries. This field is mandatory for SEP Awardees and voluntary for EECBG Grantees."]
[null,"Market Definition - Commercial"]
[null,"Market Definition - Other (Please specify here)"]
[null,"Number of active contractors performing retrofits under program","This field consists of active and qualified (qualified according to awardee program guidance) contractors who have performed one or more upgrades. This field is mandatory for EECBG Grantees and voluntary for SEP Awardees. "]
["Individuals Trained and Certified","Number of Trained Workers","This field consists of the total number of workers trained during that quarter. This field is mandatory for SEP Awardees and voluntary for EECBG Grantees."]
[null,"Number of Certified Workers","This field consists of the total number of workers certified during that quarter. Awardees were required to use nationally-recognized certifications, or if a non nationally-recongized organization was used, a justification was required. This field is mandatory for SEP Awardees and voluntary for EECBG Grantees."]
["Loan Information","Number of Loans Provided - Residential","Total number of residential loans reported in that quarter."]
[null,"Total Amount of Loans Provided - Residential ($)","This field consists of the total amount of residential loan(s) taken on by the customer."]
[null,"Number of Loans Provided - Commercial","Total number of commercial loans reported in that quarter."]
[null,"Total Amount of Loans Provided - Commercial ($)","This field consists of the total amount of commercial loan(s) taken on by the customer."]
["Marketing and Outreach","Business organization outreach_Number attending session","The number of buildings owners that attended a meeting to learn more about the program."]
[null,"Contests_Number of Contests","The number of contests held by the program."]
[null,"Contests_Number of participants","The total number of participants in the contests."]
[null,"Direct mail_Number of direct mail slips","The number of direct mail pieces that were sent out."]
[null,"Direct mail_Number of applications with direct mail IDs","The number of applications that were solicited by direct mail. "]
[null,"Door to door_Number of homes visited","The number of homes that were visited in any door to door outreach undertaken."]
[null,"Door to door_Number of homes agreeing","The number of homes that agreed to sign up for further action, whether it was an assessment, a neighborhood meeting, etc."]
[null,"Hotline_Number of calls","The number of calls to the hotline."]
[null,"Hotline_Number of calls that lead to applications","The number of calls that led to applications being filled out."]
[null,"One-stop-shop_Number of visitors","The number of building owners that expressed interest in program service offerings, whether by phone, email, or walk-ins."]
[null,"One-stop-shop_Number who requests services","The number of building owners that requested follow-up services, such as a direct installation or an assessment."]
[null,"One-stop-shop_Number of clients served","The number of building owners that followed through to having an upgrade conducted."]
[null,"Online Advertising_Number of advertisements","The number of 'buys' that were placed for online advertising space through internet search ads or banners, including Facebook ads."]
[null,"Online Advertising_Number of clicks","The number of clicks on the above advertisements such as internet search ads or banners, including Facebook ads."]
[null,"Online Advertising_Number of click-throughs to apply to program","The number of click-throughs that resulted in completed applications."]
[null,"School, church, library_Number attending session","The number of building owners that heard about the program through a school, church, or library setting."]
[null,"School, church, library_Number of audit sign-ups","The number of building owners that signed up for assessments while marketing and outreach efforts occurred at the school, church, or library."]
[null,"Neighborhood Meeting_Number Attended","The number of building owners who attended a neighborhood meeting."]
[null,"Social Media_Number of Clicks","The number of clicks on links placed on any social media site, such as Twitter, Facebook, or LinkedIn, or other forms of \"social media\" (i.e., networking tools on the Internet. This does not include any form of advertisement through these social media services. (See above for more guidance.)"]
[null,"Social Media_Number of click-throughs to apply to program","The number of click-throughs that resulted in completed applications."]
[null,"Telethon/direct phone calls_Number of calls made","The number of calls made during any telethons."]
[null,"Telethon/direct phone calls_Number of calls answered","The number of calls that were answered during any telethons."]
[null,"Telethon/direct phone calls_Number of calls that lead to applications","The number of calls that resulted in a building owner filling out an application."]
[null,"Traditional advertising: Radio_Number of advertisements","The number of radio advertisements."]
[null,"Traditional advertising: Newspaper_Number of advertisements","The number of newspaper advertisements."]
[null,"Traditional advertising: TV_Number of advertisements","The number of TV advertisements."]
[null,"Webinar_Number of webinars","The number of webinars that were held for building owners."]
[null,"Webinar_Number of participants","The number of participants in the webinars."]
[null,"Website_Number of unique visits","The number of unique visits-- those from unique IP addresses for instance, to your program website."]
[null,"Website_Number of unique visits on application page","The number of unique visits-- those from unique IP addresses for instance, to the application page."]
[null,"Website_Number of web applicants","The number of people who successfully completed an application online."]

{"sheet":"Grantee Dashboard","index":2,"n_rows":28,"n_cols":79,"rows_kept":28,"cut":false,"hidden":false,"merged":[[4,40,4,41],[4,48,4,80],[4,28,5,28],[4,26,5,26],[4,1,4,2],[4,7,4,8],[4,11,4,17],[4,19,4,25],[4,36,4,39],[4,43,4,46],[4,30,4,34],[23,1,23,2],[2,6,2,7],[1,6,1,7],[0,6,0,7],[0,1,3,3],[18,1,18,2],[4,3,4,6],[0,4,0,5],[3,4,3,5],[2,4,2,5],[1,4,1,5],[3,6,3,7]]}
[null,"Grantee Dashboard",null,null,"Date",null,"2015-05-19"]
[null,null,null,null,"Award Number",null,3561]
[null,null,null,null,"Grantee",null,"Chicago Metro Agency for Planning"]
[null,null,null,null,"Granted Amount",null,25000000]
[null,null,null,"OUTLAYS",null,null,null,"LEVERAGING",null,"INVOICED COST*",null,"ASSESSMENTS",null,null,null,null,null,null,null,"UPGRADES*",null,null,null,null,null,null,"Commercial Buildings Floorspace (square feet)*",null,"Total Job hours",null,"ANNUAL ESTIMATED ENERGY SAVINGS",null,null,null,null,null,"MARKET TRANSFORMATION",null,null,null,"INDIVIDUALS TRAINED AND CERTIFIED",null,null,"LOAN INFORMATION*",null,null,null,null,"MARKETING & OUTREACH"]
[null,"Year","Quarter","Total Marketing & Outreach","Labor & Materials Cost","Other Program Expenses","Total Grantee Outlays","Other Federal Expenditures","Non-Federal Expenditures","Retrofit Invoiced Cost",null,"Residential Single-Family","Residential Multi-Family Units","Residential Multi-Family Buildings","Commercial Buildings"," Industrial Buildings","Agricultural Buildings","Total Assessments",null,"Residential Single-Family","Residential Multi-Family Units","Residential Multi-Family Buildings","Commercial Buildings"," Industrial Buildings","Agricultural Buildings","Total Upgrades",null,null,null,null,"Electricity (kWh)","Natural Gas (therms)","Heating oil (gallons)","LPG (gallons)","Energy Cost Savings",null,"Market Definition - Residential","Market Definition - Commercial","Market Definition - Other (Please specify here)","Number of active contractors performing retrofits under program","Number of Trained Workers","Number of Certified Workers",null,"Number of Loans Provided - Residential","Total Amount of Loans Provided - Residential ($)","Number of Loans Provided - Commercial","Total Amount of Loans Provided - Commercial ($)",null,"Business organization outreach_Number attending session","Contests_Number of Contests","Contests_Number of participants","Direct mail_Number of direct mail slips","Direct mail_Number of applications with direct mail IDs","Door to door_Number of homes visited","Door to door_Number of homes agreeing","Hotline_Number of calls","Hotline_Number of calls that lead to applications","One-stop-shop_Number of visitors","One-stop-shop_Number who requests services","One-stop-shop_Number of clients served","Online Advertising_Number of advertisements","Online Advertising_Number of clicks","Online Advertising_Number of click-throughs to apply to program","School, church, library_Number attending session","School, church, library_Number of audit sign-ups","Neighborhood Meeting_Number Attended","Social Media_Number of Clicks","Social Media_Number of click-throughs to apply to program","Telethon/direct phone calls_Number of calls made","Telethon/direct phone calls_Number of calls answered","Telethon/direct phone calls_Number of calls that lead to applications","Traditional advertising: Radio_Number of advertisements","Traditional advertising: Newspaper_Number of advertisements","Traditional advertising: TV_Number of advertisements","Webinar_Number of webinars","Webinar_Number of participants","Website_Number of unique visits","Website_Number of unique visits on application page","Website_Number of web applicants"]
[null,2010,4,0,0,95429.25,95429.25,0,0,null,null,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,null,1636,null,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,2011,1,277063.12,0,1781634,2058697.12,0,0,null,null,0,166,6,0,0,0,166,null,0,0,0,0,0,0,0,0,null,7282,null,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,2011,2,1051428,0,11452471,12503899,0,107873,null,null,0,415,19,1,0,0,416,null,0,0,0,0,0,0,0,0,null,8360,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,80,0,0,0,0,0,0,6,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1141,0,0]
[null,2011,3,1405665,5000,2314635,3725300,0,63626,87575,null,3,1202,12,1,0,0,1206,null,0,23,1,0,0,0,23,0,null,21924,null,2510,10130,0,0,10381,null,null,null,null,1,null,null,null,1,85000,null,null,null,124,0,0,0,0,0,0,7,0,0,0,0,0,0,0,0,0,24,0,0,0,0,0,0,0,0,0,0,7143,0,0]
[null,2011,4,1545670,25000,354082,1924752,30000,128561,2163388,null,7,385,11,2,0,0,394,null,2,6,3,1,0,0,9,32000,null,14000,null,41503,8801,0,0,11273,null,null,null,null,6,null,null,null,4,23294,1,1000000,null,2232,1,28,5257,0,0,0,76,0,0,0,0,4200000,42000,0,45,0,12,3271,0,0,0,0,274,30,430,0,0,37917,324,0]
[null,2012,1,683506,4500,245415,933421,14270,373021,200430,null,18,953,10,1,0,0,972,null,5,9,1,1,0,0,15,8342.4,null,10334,null,4246,5423,0,0,5457,null,null,null,null,10,null,null,null,1,15000,null,null,null,1110,0,0,74750,0,0,0,75,0,0,0,0,0,0,0,0,0,232,1987,0,0,0,0,0,19,0,1,40,3732,42,2]
[null,2012,2,184221,292500,318463,795184,0,149128,20513,null,59,977,41,4,0,0,1040,null,2,2,1,0,0,0,4,0,null,9895,null,1100,1682,0,0,1510,null,null,null,null,12,null,null,null,null,null,null,null,null,2169,0,0,13304,0,0,0,79,0,0,0,0,2,5500,0,803,0,969,1488,0,193,0,0,0,1,0,2,8,13180,263,2]
[null,2012,3,541645,1001850,-4340403,-2796908,4800,1631143,1720241,null,754,605,21,4,0,0,1363,null,279,27,4,0,0,0,306,0,null,23617,null,216578,90302,0,0,108583,null,null,null,null,28,null,null,null,4,151124,null,null,null,3026,0,0,61353,3,0,0,459,0,0,0,0,1003,6566,0,163,257,4873,1650,0,1474,1474,107,1,11,604,3,47,22108,146,3]
[null,2012,4,760045,45705,335835,1141585,2386,3080485,4741517,null,1116,195,34,4,0,0,1315,null,802,215,11,2,0,0,1019,99000,null,53731,null,798533,350247,0,75,400799,null,null,null,null,40,null,null,null,8,482910,2,664703,null,1942,0,0,57772,0,0,0,230,0,0,0,0,3,5323,0,107,1410,6736,1014,0,61,0,0,0,25,268,1,50,20774,205,89]
[null,2013,1,648374,620868,322515,1591757,0,2347346,3697353,null,1551,228,38,16,0,0,1795,null,717,288,14,0,0,0,1005,0,null,54064,null,690140,386659,0,0,429850,null,null,null,null,49,null,null,null,12,808608,null,null,null,350,0,0,75201,0,0,0,1456,0,35,19,0,0,0,0,348,0,6450,665,0,15,0,0,0,21,0,0,0,19338,214,84]
[null,2013,2,869775,-1795040,494882,-430383,12500,3138344,5068913,null,1654,987,91,12,0,0,2653,null,742,1154,47,0,0,0,1896,0,null,75251,null,1222018,452697,0,0,544357,null,null,null,null,58,null,null,null,9,240819,null,null,null,1159,0,0,0,0,0,0,876,0,0,0,0,0,0,0,623,0,4562,1013,0,0,0,0,0,19,0,0,0,10887,0,0]
[null,2013,3,861150,1956842,498490,3316482,12500,2942450,5244266,null,310,1032,114,1,0,0,1343,null,940,965,69,3,0,0,1908,62127.5,null,76873,null,1052868,662523,0,0,752977,null,null,null,null,64,0,0,null,11,220174,1,75000,null,247,0,0,268,0,0,0,0,0,0,0,0,0,0,0,281,0,951,517,0,0,0,0,0,21,0,0,0,15432,1284,66]
[null,"Q3 2013 Subtotal",null,{"$f":"SUM(D7:D18)","v":8828542.120000001},{"$f":"SUM(E7:E18)","v":2157225},13873448.25,24859215.370000001,76456,13961977,22944196,null,{"$f":"SUM(L7:L18)","v":5472},{"$f":"SUM(M7:M18)","v":7145},397,46,0,0,12663,null,{"$f":"SUM(T7:T18)","v":3489},{"$f":"SUM(U7:U18)","v":2689},151,7,0,0,6185,201469.9,null,{"$f":"SUM(AC7:AC18)","v":356967},null,{"$f":"SUM(AE7:AE18)","v":4029496},{"$f":"SUM(AF7:AF18)","v":1968464},0,75,2265187,null,{"$f":"SUM(AK7:AK18)","v":0},{"$f":"SUM(AL7:AL18)","v":0},0,null,0,0,null,{"$f":"SUM(AR7:AR18)","v":50},{"$f":"SUM(AS7:AS18)","v":2026929},4,1739703,null,{"$f":"SUM(AW7:AW18)","v":12439},{"$f":"SUM(AX7:AX18)","v":1},28,287905,3,0,0,3264,0,35,19,0,4201008,59389,0,2370,1667,24809,11605,0,1743,1474,107,275,147,1302,7,145,151652,2478,246]
[null,2013,4,null,null,null,0,null,null,827144.6,null,null,null,null,null,null,null,0,null,34,117,29,0,1,0,152,61155,null,null,null,129789,51147,0,0,56505]
[null,2014,1,null,null,null,0,null,null,621705.80000000005,null,null,null,null,null,null,null,0,null,124,33,15,1,0,0,158,41000,null,null,null,163640,58325,0,0,77561]
[null,2014,2,null,null,null,0,null,null,818470,null,null,null,null,null,null,null,0,null,132,40,6,3,0,null,175,34800,null,null,null,244304,61649,0,0,82580]
[null,2014,3,null,null,null,0,null,null,1854687.23,null,null,null,null,null,null,null,0,null,43,403,11,null,0,null,446,0,null,null,null,183221,71288,0,0,91366.5]
[null,"Total",null,{"$f":"SUM(D19:D23)","v":8828542.120000001},2157225,13873448.25,24859215.370000001,76456,13961977,27066203.630000003,null,{"$f":"SUM(L19:L23)","v":5472},7145,397,46,0,0,12663,null,{"$f":"SUM(T19:T23)","v":3822},3282,212,11,1,0,7116,338424.9,null,{"$f":"SUM(AC19:AC23)","v":356967},null,{"$f":"SUM(AE19:AE23)","v":4750450},{"$f":"SUM(AF19:AF23)","v":2210873},{"$f":"SUM(AG19:AG23)","v":0},{"$f":"SUM(AH19:AH23)","v":75},{"$f":"SUM(AI19:AI23)","v":2573199.5},null,{"$f":"SUM(AK19:AK23)","v":0},{"$f":"SUM(AL19:AL23)","v":0},{"$f":"SUM(AM19:AM23)","v":0},null,{"$f":"SUM(AO19:AO23)","v":0},{"$f":"SUM(AP19:AP23)","v":0},null,{"$f":"SUM(AR19:AR23)","v":50},{"$f":"SUM(AS19:AS23)","v":2026929},{"$f":"SUM(AT19:AT23)","v":4},{"$f":"SUM(AU19:AU23)","v":1739703},null,{"$f":"SUM(AW19:AW23)","v":12439},1,28,287905,3,0,0,3264,0,35,19,0,4201008,59389,0,2370,1667,24809,11605,0,1743,1474,107,275,147,1302,7,145,151652,2478,246]
[]
[]
[null,"* Aggregated from the Residential, Commercial, Agricultural and Industrial tabs."]
[null,"Note: Do not delete or rename any of tabs in this workbook.  Also do not alter the rows, columns, or cells in any way."]

{"sheet":"Expenditure Graph Data","index":3,"n_rows":21,"n_cols":10,"rows_kept":21,"cut":false,"hidden":true,"merged":[[1,2,1,9]]}
[]
[null,null,"Millions of Dollars ($)"]
[null,null,null,"Cumulative",null,"Cumulative",null,"Cumulative"]
[null,"Quarter-Year","Total Outlays ($)","BBNP Award Spending","Other Federal Expenditures (non-BBNP)","Other Fed Expenditures","Non-Federal Expenditures","Non-Fed Expenditures","Retrofit Invoiced Cost","Invoiced Upgrade Costs"]
[null,{"$f":"'Grantee Dashboard'!B7&\"-Q\"&'Grantee Dashboard'!C7","v":"2010-Q4"},{"$f":"'Grantee Dashboard'!G7/10^6","v":9.5429249999999993E-2},{"$f":"C5","v":9.5429249999999993E-2},{"$f":"'Grantee Dashboard'!H7/10^6","v":0},{"$f":"E5","v":0},{"$f":"'Grantee Dashboard'!I7/10^6","v":0},{"$f":"G5","v":0},{"$f":"'Grantee Dashboard'!J7/10^6","v":0},{"$f":"I5","v":0}]
[null,{"$f":"'Grantee Dashboard'!B8&\"-Q\"&'Grantee Dashboard'!C8","v":"2011-Q1"},{"$f":"'Grantee Dashboard'!G8/10^6","v":2.0586971200000002},{"$f":"C6+D5","v":2.1541263700000002},{"$f":"'Grantee Dashboard'!H8/10^6","v":0},{"$f":"E6+F5","v":0},{"$f":"'Grantee Dashboard'!I8/10^6","v":0},{"$f":"G6+H5","v":0},{"$f":"'Grantee Dashboard'!J8/10^6","v":0},{"$f":"I6+J5","v":0}]
[null,{"$f":"'Grantee Dashboard'!B9&\"-Q\"&'Grantee Dashboard'!C9","v":"2011-Q2"},{"$f":"'Grantee Dashboard'!G9/10^6","v":12.503899000000001},{"$f":"C7+D6","v":14.658025370000001},{"$f":"'Grantee Dashboard'!H9/10^6","v":0},{"$f":"E7+F6","v":0},{"$f":"'Grantee Dashboard'!I9/10^6","v":0.107873},{"$f":"G7+H6","v":0.107873},{"$f":"'Grantee Dashboard'!J9/10^6","v":0},{"$f":"I7+J6","v":0}]
[null,{"$f":"'Grantee Dashboard'!B10&\"-Q\"&'Grantee Dashboard'!C10","v":"2011-Q3"},{"$f":"'Grantee Dashboard'!G10/10^6","v":3.7252999999999998},18.383325370000001,{"$f":"'Grantee Dashboard'!H10/10^6","v":0},0,{"$f":"'Grantee Dashboard'!I10/10^6","v":6.3626000000000002E-2},0.17149900000000001,{"$f":"'Grantee Dashboard'!J10/10^6","v":8.7575E-2},8.7575E-2]
[null,{"$f":"'Grantee Dashboard'!B11&\"-Q\"&'Grantee Dashboard'!C11","v":"2011-Q4"},{"$f":"'Grantee Dashboard'!G11/10^6","v":1.924752},20.308077370000003,{"$f":"'Grantee Dashboard'!H11/10^6","v":0.03},0.03,{"$f":"'Grantee Dashboard'!I11/10^6","v":0.12856100000000001},0.30005999999999999,{"$f":"'Grantee Dashboard'!J11/10^6","v":2.1633879999999999},2.250963]
[null,{"$f":"'Grantee Dashboard'!B12&\"-Q\"&'Grantee Dashboard'!C12","v":"2012-Q1"},{"$f":"'Grantee Dashboard'!G12/10^6","v":0.93342099999999995},21.241498370000002,{"$f":"'Grantee Dashboard'!H12/10^6","v":1.427E-2},4.4269999999999997E-2,{"$f":"'Grantee Dashboard'!I12/10^6","v":0.37302099999999999},0.67308100000000004,{"$f":"'Grantee Dashboard'!J12/10^6","v":0.20043},2.4513929999999999]
[null,{"$f":"'Grantee Dashboard'!B13&\"-Q\"&'Grantee Dashboard'!C13","v":"2012-Q2"},{"$f":"'Grantee Dashboard'!G13/10^6","v":0.795184},22.036682370000001,{"$f":"'Grantee Dashboard'!H13/10^6","v":0},4.4269999999999997E-2,{"$f":"'Grantee Dashboard'!I13/10^6","v":0.14912800000000001},0.82220900000000008,{"$f":"'Grantee Dashboard'!J13/10^6","v":2.0513E-2},2.4719059999999997]
[null,{"$f":"'Grantee Dashboard'!B14&\"-Q\"&'Grantee Dashboard'!C14","v":"2012-Q3"},{"$f":"'Grantee Dashboard'!G14/10^6","v":-2.7969080000000002},19.239774369999999,{"$f":"'Grantee Dashboard'!H14/10^6","v":4.7999999999999996E-3},4.9069999999999996E-2,{"$f":"'Grantee Dashboard'!I14/10^6","v":1.631143},2.4533520000000002,{"$f":"'Grantee Dashboard'!J14/10^6","v":1.7202409999999999},4.1921469999999994]
[null,{"$f":"'Grantee Dashboard'!B15&\"-Q\"&'Grantee Dashboard'!C15","v":"2012-Q4"},{"$f":"'Grantee Dashboard'!G15/10^6","v":1.1415850000000001},20.381359369999998,{"$f":"'Grantee Dashboard'!H15/10^6","v":2.3860000000000001E-3},5.1455999999999995E-2,{"$f":"'Grantee Dashboard'!I15/10^6","v":3.0804849999999999},5.5338370000000001,{"$f":"'Grantee Dashboard'!J15/10^6","v":4.741517},8.9336640000000003]
[null,{"$f":"'Grantee Dashboard'!B16&\"-Q\"&'Grantee Dashboard'!C16","v":"2013-Q1"},{"$f":"'Grantee Dashboard'!G16/10^6","v":1.5917570000000001},21.97311637,{"$f":"'Grantee Dashboard'!H16/10^6","v":0},5.1455999999999995E-2,{"$f":"'Grantee Dashboard'!I16/10^6","v":2.3473459999999999},7.881183,{"$f":"'Grantee Dashboard'!J16/10^6","v":3.6973530000000001},{"$f":"I14+J13","v":12.631017}]
[null,{"$f":"'Grantee Dashboard'!B17&\"-Q\"&'Grantee Dashboard'!C17","v":"2013-Q2"},{"$f":"'Grantee Dashboard'!G17/10^6","v":-0.43038300000000002},21.542733370000001,{"$f":"'Grantee Dashboard'!H17/10^6","v":1.2500000000000001E-2},6.3955999999999999E-2,{"$f":"'Grantee Dashboard'!I17/10^6","v":3.138344},11.019527,{"$f":"'Grantee Dashboard'!J17/10^6","v":5.0689130000000002},{"$f":"I15+J14","v":17.699930000000002}]
[null,{"$f":"'Grantee Dashboard'!B18&\"-Q\"&'Grantee Dashboard'!C18","v":"2013-Q3"},{"$f":"'Grantee Dashboard'!G18/10^6","v":3.3164820000000002},24.859215370000001,{"$f":"'Grantee Dashboard'!H18/10^6","v":1.2500000000000001E-2},7.6455999999999996E-2,{"$f":"'Grantee Dashboard'!I18/10^6","v":2.94245},13.961977000000001,{"$f":"'Grantee Dashboard'!J18/10^6","v":5.2442659999999997},{"$f":"I16+J15","v":22.944196000000002}]
[null,{"$f":"'Grantee Dashboard'!B20&\"-Q\"&'Grantee Dashboard'!C20","v":"2013-Q4"},{"$f":"'Grantee Dashboard'!G20/10^6","v":0},24.859215370000001,{"$f":"'Grantee Dashboard'!H20/10^6","v":0},7.6455999999999996E-2,{"$f":"'Grantee Dashboard'!I20/10^6","v":0},13.961977000000001,{"$f":"'Grantee Dashboard'!J20/10^6","v":0.82714460000000001},{"$f":"I17+J16","v":23.771340600000002}]
[null,{"$f":"'Grantee Dashboard'!B21&\"-Q\"&'Grantee Dashboard'!C21","v":"2014-Q1"},{"$f":"'Grantee Dashboard'!G21/10^6","v":0},24.859215370000001,{"$f":"'Grantee Dashboard'!H21/10^6","v":0},7.6455999999999996E-2,{"$f":"'Grantee Dashboard'!I21/10^6","v":0},13.961977000000001,{"$f":"'Grantee Dashboard'!J21/10^6","v":0.62170580000000009},24.393046400000003]
[null,{"$f":"'Grantee Dashboard'!B22&\"-Q\"&'Grantee Dashboard'!C22","v":"2014-Q2"},{"$f":"'Grantee Dashboard'!G22/10^6","v":0},24.859215370000001,{"$f":"'Grantee Dashboard'!H22/10^6","v":0},7.6455999999999996E-2,{"$f":"'Grantee Dashboard'!I22/10^6","v":0},13.961977000000001,{"$f":"'Grantee Dashboard'!J22/10^6","v":0.81847000000000003},25.211516400000004]
[null,"2014-Q3",{"$f":"'Grantee Dashboard'!G23/10^6","v":0},{"$f":"C20+D19","v":24.859215370000001},{"$f":"'Grantee Dashboard'!H23/10^6","v":0},{"$f":"E20+F19","v":7.6455999999999996E-2},{"$f":"'Grantee Dashboard'!I23/10^6","v":0},{"$f":"G20+H19","v":13.961977000000001},{"$f":"'Grantee Dashboard'!J23/10^6","v":1.8546872299999999},{"$f":"I20+J19","v":27.066203630000004}]
[null,"TOTAL",{"$f":"SUM(C5:C20)","v":24.859215370000001},null,{"$f":"SUM(E5:E20)","v":7.6455999999999996E-2},null,{"$f":"SUM(G5:G20)","v":13.961977000000001},null,{"$f":"SUM(I5:I20)","v":27.066203630000004}]

{"sheet":"Audit-Retrofit Graph Data","index":5,"n_rows":21,"n_cols":8,"rows_kept":21,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[null,"Quarter-Year","Total Audits","Total Assessments","Total Retrofit Projects","Total Upgrades","Total Source Energy Savings","Cumulative Source Energy Savings"]
[null,{"$f":"'Grantee Dashboard'!B7&\"-Q\"&'Grantee Dashboard'!C7","v":"2010-Q4"},{"$f":"'Grantee Dashboard'!R7","v":0},{"$f":"C5","v":0},{"$f":"'Grantee Dashboard'!Z7","v":0},{"$f":"E5","v":0},{"$f":"('Grantee Dashboard'!AE7*3412.14*3.365)/1000000+('Grantee Dashboard'!AF7*100000*1.092)/1000000+('Grantee Dashboard'!AG7*(140000/1000000)*1.158)+('Grantee Dashboard'!AH7*(91330/1000000)*1.151)","v":0},{"$f":"G5","v":0}]
[null,{"$f":"'Grantee Dashboard'!B8&\"-Q\"&'Grantee Dashboard'!C8","v":"2011-Q1"},{"$f":"'Grantee Dashboard'!R8","v":166},{"$f":"C6+D5","v":166},{"$f":"'Grantee Dashboard'!Z8","v":0},{"$f":"E6+F5","v":0},{"$f":"('Grantee Dashboard'!AE8*3412.14*3.365)/1000000+('Grantee Dashboard'!AF8*100000*1.092)/1000000+('Grantee Dashboard'!AG8*(140000/1000000)*1.158)+('Grantee Dashboard'!AH8*(91330/1000000)*1.151)","v":0},{"$f":"G6+H5","v":0}]
[null,{"$f":"'Grantee Dashboard'!B9&\"-Q\"&'Grantee Dashboard'!C9","v":"2011-Q2"},{"$f":"'Grantee Dashboard'!R9","v":416},{"$f":"C7+D6","v":582},{"$f":"'Grantee Dashboard'!Z9","v":0},{"$f":"E7+F6","v":0},{"$f":"('Grantee Dashboard'!AE9*3412.14*3.365)/1000000+('Grantee Dashboard'!AF9*100000*1.092)/1000000+('Grantee Dashboard'!AG9*(140000/1000000)*1.158)+('Grantee Dashboard'!AH9*(91330/1000000)*1.151)","v":0},0]
[null,{"$f":"'Grantee Dashboard'!B10&\"-Q\"&'Grantee Dashboard'!C10","v":"2011-Q3"},{"$f":"'Grantee Dashboard'!R10","v":1206},1788,{"$f":"'Grantee Dashboard'!Z10","v":23},23,{"$f":"('Grantee Dashboard'!AE10*3412.14*3.365)/1000000+('Grantee Dashboard'!AF10*100000*1.092)/1000000+('Grantee Dashboard'!AG10*(140000/1000000)*1.158)+('Grantee Dashboard'!AH10*(91330/1000000)*1.151)","v":1135.0154462609999},1135.0154462609999]
[null,{"$f":"'Grantee Dashboard'!B11&\"-Q\"&'Grantee Dashboard'!C11","v":"2011-Q4"},{"$f":"'Grantee Dashboard'!R11","v":394},2182,{"$f":"'Grantee Dashboard'!Z11","v":9},32,{"$f":"('Grantee Dashboard'!AE11*3412.14*3.365)/1000000+('Grantee Dashboard'!AF11*100000*1.092)/1000000+('Grantee Dashboard'!AG11*(140000/1000000)*1.158)+('Grantee Dashboard'!AH11*(91330/1000000)*1.151)","v":1437.6004662033001},2572.6159124643]
[null,{"$f":"'Grantee Dashboard'!B12&\"-Q\"&'Grantee Dashboard'!C12","v":"2012-Q1"},{"$f":"'Grantee Dashboard'!R12","v":972},3154,{"$f":"'Grantee Dashboard'!Z12","v":15},47,{"$f":"('Grantee Dashboard'!AE12*3412.14*3.365)/1000000+('Grantee Dashboard'!AF12*100000*1.092)/1000000+('Grantee Dashboard'!AG12*(140000/1000000)*1.158)+('Grantee Dashboard'!AH12*(91330/1000000)*1.151)","v":640.94353977059995},3213.5594522349002]
[null,{"$f":"'Grantee Dashboard'!B13&\"-Q\"&'Grantee Dashboard'!C13","v":"2012-Q2"},{"$f":"'Grantee Dashboard'!R13","v":1040},4194,{"$f":"'Grantee Dashboard'!Z13","v":4},51,{"$f":"('Grantee Dashboard'!AE13*3412.14*3.365)/1000000+('Grantee Dashboard'!AF13*100000*1.092)/1000000+('Grantee Dashboard'!AG13*(140000/1000000)*1.158)+('Grantee Dashboard'!AH13*(91330/1000000)*1.151)","v":196.30443621000001},3409.8638884449001]
[null,{"$f":"'Grantee Dashboard'!B14&\"-Q\"&'Grantee Dashboard'!C14","v":"2012-Q3"},{"$f":"'Grantee Dashboard'!R14","v":1363},5557,{"$f":"'Grantee Dashboard'!Z14","v":306},357,{"$f":"('Grantee Dashboard'!AE14*3412.14*3.365)/1000000+('Grantee Dashboard'!AF14*100000*1.092)/1000000+('Grantee Dashboard'!AG14*(140000/1000000)*1.158)+('Grantee Dashboard'!AH14*(91330/1000000)*1.151)","v":12347.694747535799},15757.558635980698]
[null,{"$f":"'Grantee Dashboard'!B15&\"-Q\"&'Grantee Dashboard'!C15","v":"2012-Q4"},{"$f":"'Grantee Dashboard'!R15","v":1315},6872,{"$f":"'Grantee Dashboard'!Z15","v":1019},1376,{"$f":"('Grantee Dashboard'!AE15*3412.14*3.365)/1000000+('Grantee Dashboard'!AF15*100000*1.092)/1000000+('Grantee Dashboard'!AG15*(140000/1000000)*1.158)+('Grantee Dashboard'!AH15*(91330/1000000)*1.151)","v":47423.493466686297},63181.052102666996]
[null,{"$f":"'Grantee Dashboard'!B16&\"-Q\"&'Grantee Dashboard'!C16","v":"2013-Q1"},{"$f":"'Grantee Dashboard'!R16","v":1795},8667,{"$f":"'Grantee Dashboard'!Z16","v":1005},2381,{"$f":"('Grantee Dashboard'!AE16*3412.14*3.365)/1000000+('Grantee Dashboard'!AF16*100000*1.092)/1000000+('Grantee Dashboard'!AG16*(140000/1000000)*1.158)+('Grantee Dashboard'!AH16*(91330/1000000)*1.151)","v":50147.247518153999},113328.299620821]
[null,{"$f":"'Grantee Dashboard'!B17&\"-Q\"&'Grantee Dashboard'!C17","v":"2013-Q2"},{"$f":"'Grantee Dashboard'!R17","v":2653},11320,{"$f":"'Grantee Dashboard'!Z17","v":1896},4277,{"$f":"('Grantee Dashboard'!AE17*3412.14*3.365)/1000000+('Grantee Dashboard'!AF17*100000*1.092)/1000000+('Grantee Dashboard'!AG17*(140000/1000000)*1.158)+('Grantee Dashboard'!AH17*(91330/1000000)*1.151)","v":63465.541117519802},176793.8407383408]
[null,{"$f":"'Grantee Dashboard'!B18&\"-Q\"&'Grantee Dashboard'!C18","v":"2013-Q3"},{"$f":"'Grantee Dashboard'!R18","v":1343},12663,{"$f":"'Grantee Dashboard'!Z18","v":1908},6185,{"$f":"('Grantee Dashboard'!AE18*3412.14*3.365)/1000000+('Grantee Dashboard'!AF18*100000*1.092)/1000000+('Grantee Dashboard'!AG18*(140000/1000000)*1.158)+('Grantee Dashboard'!AH18*(91330/1000000)*1.151)","v":84436.385203954793},261230.2259422956]
[null,{"$f":"'Grantee Dashboard'!B20&\"-Q\"&'Grantee Dashboard'!C20","v":"2013-Q4"},{"$f":"'Grantee Dashboard'!R20","v":0},{"$f":"C17+D16","v":12663},{"$f":"'Grantee Dashboard'!Z20","v":152},{"$f":"E17+F16","v":6337},{"$f":"('Grantee Dashboard'!AE20*3412.14*3.365)/1000000+('Grantee Dashboard'!AF20*100000*1.092)/1000000+('Grantee Dashboard'!AG20*(140000/1000000)*1.158)+('Grantee Dashboard'!AH20*(91330/1000000)*1.151)","v":7075.4703724178999},{"$f":"G17+H16","v":268305.69631471351}]
[null,{"$f":"'Grantee Dashboard'!B21&\"-Q\"&'Grantee Dashboard'!C21","v":"2014-Q1"},{"$f":"'Grantee Dashboard'!R21","v":0},12663,{"$f":"'Grantee Dashboard'!Z21","v":158},6495,{"$f":"('Grantee Dashboard'!AE21*3412.14*3.365)/1000000+('Grantee Dashboard'!AF21*100000*1.092)/1000000+('Grantee Dashboard'!AG21*(140000/1000000)*1.158)+('Grantee Dashboard'!AH21*(91330/1000000)*1.151)","v":8247.9801140039999},276553.6764287175]
[null,{"$f":"'Grantee Dashboard'!B22&\"-Q\"&'Grantee Dashboard'!C22","v":"2014-Q2"},{"$f":"'Grantee Dashboard'!R22","v":0},12663,{"$f":"'Grantee Dashboard'!Z22","v":175},6670,{"$f":"('Grantee Dashboard'!AE22*3412.14*3.365)/1000000+('Grantee Dashboard'!AF22*100000*1.092)/1000000+('Grantee Dashboard'!AG22*(140000/1000000)*1.158)+('Grantee Dashboard'!AH22*(91330/1000000)*1.151)","v":9537.1329511344011},286090.80937985191]
[null,"2014-Q3",{"$f":"'Grantee Dashboard'!R23","v":0},{"$f":"C20+D19","v":12663},{"$f":"'Grantee Dashboard'!Z23","v":446},{"$f":"E20+F19","v":7116},{"$f":"('Grantee Dashboard'!AE23*3412.14*3.365)/1000000+('Grantee Dashboard'!AF23*100000*1.092)/1000000+('Grantee Dashboard'!AG23*(140000/1000000)*1.158)+('Grantee Dashboard'!AH23*(91330/1000000)*1.151)","v":9888.3658403931004},{"$f":"G20+H19","v":295979.17522024503}]
[null,"TOTAL",{"$f":"SUM(C5:C20)","v":12663},null,{"$f":"SUM(E5:E20)","v":7116},null,{"$f":"SUM(G5:G20)","v":295979.17522024503}]