{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Introduction","Data Dictionary","Program Dashboard","Expenditure Graph Data","Audit-Retrofit Graph Data"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":5,"defined_names":18,"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":"Introduction","index":0,"n_rows":13,"n_cols":8,"rows_kept":13,"cut":false,"hidden":false,"merged":[[4,1,5,1],[4,2,5,22],[1,2,1,22],[9,7,10,21],[12,7,13,21],[8,1,14,1]]}
[]
[null,null,"Grantee Dashboard"]
[]
[]
[null,"Introduction","This spreadsheet presents a summary of data reported by organizations 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\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, audits completed, hours worked,  and estimated annual energy savings. The number of completed building upgrade projects is based on the number of projects submitted."]
[]
[]
[]
[null,"Links"]
[null,null,null,null,null,null,null,"This tab provides a brief description of key data fields in the Program Dashboard tab."]
[]
[]
[null,null,null,null,null,null,null,"This tab includes a BBNP summary of important project information that include program outlays, leveraged spending, job hours, assessments and upgrades, and total energy savings. "]

{"sheet":"Data Dictionary","index":1,"n_rows":21,"n_cols":3,"rows_kept":21,"cut":false,"hidden":false,"merged":[[3,0,8,0],[9,0,14,0],[16,0,20,0]]}
["Data Field Section","Data Field ","Description"]
["Outlays","Total Grantee Outlays","This field is the total grant outlays during the program, calculated by the sum of three categories reported - 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 when managed directly by the grantee. However, if the funds are drawn down to pay a third-party to capitalize a loan fund then they are considered outlays.). Outlays represent actual grant funds spent on program delivery and any associated incentives or loans issued during the program."]
["Leveraging","Leveraged Spending","This field is the total leveraged spending during the program, calculated by the sume of two categories reported - Other Federal Expenditurers and Non-Federal Expenditures. \nOther Federal Expenditures is the total amount of other Federal leveraged funds expended by the awardee during the length of the program.  Other federal funds many include funds from EECBG and SEP, loans from HUD, etc.\nNon-Federal Expenditure is the total estimated amount of Non-Federal funds expended during the length of the program.  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."]
["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."]
["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 Job Hours","This field is the total job hours worked during the program. 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 the program. 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 program. 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 program. 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 program. 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 program.  Additionally, any cost savings through direct installations conducted are also included. "]

{"sheet":"Program Dashboard","index":2,"n_rows":23,"n_cols":23,"rows_kept":23,"cut":false,"hidden":false,"merged":[[2,11,2,16],[2,18,2,22],[20,1,20,2],[0,1,1,3],[0,4,1,4],[0,5,1,5],[2,1,3,1],[2,2,3,2],[2,3,3,3],[2,4,3,4],[2,5,2,10]]}
[null,"Program Dashboard",null,null,"Date","2015-05-18"]
[]
[null,"Year","Quarter","Grantee Outlays","Leveraged Spending","Audits",null,null,null,null,null,"Upgrades*",null,null,null,null,null,null,"Annual Estimated Energy Savings"]
[null,null,null,null,null,"Residential Single-Family","Residential Multi-Family Units","Residential Multi-Family Buildings","Commercial Buildings"," Industrial Buildings","Agricultural Buildings","Residential Single-Family","Residential Multi-Family Units","Residential Multi-Family Buildings","Commercial Buildings"," Industrial Buildings","Agricultural Buildings","Total Job hours","Electricity (kWhrs)","Natural Gas (therms)","Heating oil (gallons)","LPG (gallons)","Energy Cost Savings"]
[null,2010,4,16301562.66,96586667.840000004,6074,6323,252,96,0,0,3719,244,224,45,0,0,136912,3966466,388515,259407,2741,1807391]
[null,2011,1,18073065.920000002,46907771.039999999,10211,1058,7,246,0,2,4075,79,79,107,0,0,168415,11975627,722063,456072,35042.5,4343157]
[null,2011,2,43467416.579999998,22547418.329999998,8337,2376,50,378,2,14,3237,430,395,133,0,1,340370,9852680,548231,231033,25277.919999999998,2824715]
[null,2011,3,40388622.750000007,29946679,9792,4100,34,972,3,28,3657,544,378,216,0,3,430264,13938923,2573191,288576,33838.020000000004,5364031]
[null,2011,4,44762785.270000003,50071280.630000003,9898,8823,130,753,0,41,4208,549,417,362,0,8,428199,19051545,900921,374008,55640.34,4593319]
[null,2012,1,42234611.620000005,53820507.910000004,10993,17536,312,537,1,37,4890,679,527,338,0,17,487192,18724000,1031799,238978,55336.160000000003,6169218]
[null,2012,2,41417115.390000001,101543311.23,11990,6486,119,1021,1,76,6190,1524,1101,328,0,29,530412,24922619,1123738,312064,55685,6984023]
[null,2012,3,41926261.359999999,60164991,12239,5702,169,562,5,50,6970,2466,857,360,2,47,586609,27012122,1320747,246968,68671.66,5115460.4000000004]
[null,2012,4,45744537.879999995,59114835.170000002,14385,5146,234,794,11,4,9626,3320,1206,436,1,28,654715,37272840,2214854,320504,49168.74,7468936]
[null,2013,1,33179490,53811215.600000001,15267,10083,288,554,8,16,10430,2341,983,502,1,15,677645,30030168,3354156,359967,19465.579999999998,7213199]
[null,2013,2,41497713,89187132.849999994,17755,9785,335,657,4,1,8630,4304,1095,372,6,15,669016,41972633,3153985,328761,92055.92,9802026]
[null,2013,3,35965470.670000002,89468844.510000005,11382,7058,336,753,1,7,8861,4850,1407,348,5,0,666041,49003703,1988321,348049,21174.46,9139937.5899999999]
[null,2013,4,7178992,26092226,5885,4234,48,108,0,0,3121,2248,51,125,9,0,180608,19634321.019567955,768331.39400000009,643929.53848920856,64905.025889631012,5122900.8994999994]
[null,2014,1,4403993,18701823,6485,4234,48,4,0,0,3685,756,101,72,0,0,172144,9017768.0247213785,695079.59500000009,543543.03857142851,59240.377570349279,4323611.0199999996]
[null,2014,2,0,0,105,0,0,0,0,0,4454,130,7,19,0,0,1065,2408796.0208352534,507626.67365187715,482636.46571428556,62533.855759334292,2972680.2980069402]
[null,2014,3,0,0,0,0,0,0,0,0,4947,476,11,1,0,0,0,1302530.6674110675,465814.45537941984,637688.91259285703,80793.046972517259,3479083.252696245]
[null,"Total",null,{"$f":"SUM(D5:D20)","v":456541638.10000002},{"$f":"SUM(E5:E20)","v":797964704.11000001},150798,92944,2362,7435,36,276,90700,24940,8839,3764,24,163,6129607,320086741.73253572,21757373.118031297,6072184.9553677794,781569.60619183176,86723688.460203171]
[]
[null,"* Aggregated from the Residential, Commercial, Agricultural and Industrial building upgrade projects submitted by recipients. This information was reported on the Residential, Commercial, Agricultural or Industrial tabs in the the BBNP Program Report Excel Template."]

{"sheet":"Expenditure Graph Data","index":3,"n_rows":17,"n_cols":10,"rows_kept":17,"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":"CONCATENATE(#REF!,\"-\",\"Q\",#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!/10^6","v":{"$error":"#REF!"}},{"$f":"C5","v":{"$error":"#REF!"}},{"$f":"#REF!/10^6","v":{"$error":"#REF!"}},{"$f":"E5","v":{"$error":"#REF!"}},{"$f":"#REF!/10^6","v":{"$error":"#REF!"}},{"$f":"G5","v":{"$error":"#REF!"}},{"$f":"#REF!/10^6","v":{"$error":"#REF!"}},{"$f":"I5","v":{"$error":"#REF!"}}]
[null,{"$f":"CONCATENATE(#REF!,\"-\",\"Q\",#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!/10^6","v":{"$error":"#REF!"}},{"$f":"C6+D5","v":{"$error":"#REF!"}},{"$f":"#REF!/10^6","v":{"$error":"#REF!"}},{"$f":"E6+F5","v":{"$error":"#REF!"}},{"$f":"#REF!/10^6","v":{"$error":"#REF!"}},{"$f":"G6+H5","v":{"$error":"#REF!"}},{"$f":"#REF!/10^6","v":{"$error":"#REF!"}},{"$f":"I6+J5","v":{"$error":"#REF!"}}]
[null,{"$f":"CONCATENATE(#REF!,\"-\",\"Q\",#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!/10^6","v":{"$error":"#REF!"}},{"$f":"C7+D6","v":{"$error":"#REF!"}},{"$f":"#REF!/10^6","v":{"$error":"#REF!"}},{"$f":"E7+F6","v":{"$error":"#REF!"}},{"$f":"#REF!/10^6","v":{"$error":"#REF!"}},{"$f":"G7+H6","v":{"$error":"#REF!"}},{"$f":"#REF!/10^6","v":{"$error":"#REF!"}},{"$f":"I7+J6","v":{"$error":"#REF!"}}]
[null,{"$f":"CONCATENATE(#REF!,\"-\",\"Q\",#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!/10^6","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"#REF!/10^6","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"#REF!/10^6","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"#REF!/10^6","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[null,{"$f":"CONCATENATE(#REF!,\"-\",\"Q\",#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!/10^6","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"#REF!/10^6","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"#REF!/10^6","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"#REF!/10^6","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[null,{"$f":"CONCATENATE(#REF!,\"-\",\"Q\",#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!/10^6","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"#REF!/10^6","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"#REF!/10^6","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"#REF!/10^6","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[null,{"$f":"CONCATENATE(#REF!,\"-\",\"Q\",#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!/10^6","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"#REF!/10^6","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"#REF!/10^6","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"#REF!/10^6","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[null,{"$f":"CONCATENATE(#REF!,\"-\",\"Q\",#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!/10^6","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"#REF!/10^6","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"#REF!/10^6","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"#REF!/10^6","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[null,{"$f":"CONCATENATE(#REF!,\"-\",\"Q\",#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!/10^6","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"#REF!/10^6","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"#REF!/10^6","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"#REF!/10^6","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[null,{"$f":"CONCATENATE(#REF!,\"-\",\"Q\",#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!/10^6","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"#REF!/10^6","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"#REF!/10^6","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"#REF!/10^6","v":{"$error":"#REF!"}},{"$f":"I14+J13","v":{"$error":"#REF!"}}]
[null,"2013-Q2",{"$f":"#REF!/10^6","v":{"$error":"#REF!"}},{"$f":"C15+D14","v":{"$error":"#REF!"}},{"$f":"#REF!/10^6","v":{"$error":"#REF!"}},{"$f":"E15+F14","v":{"$error":"#REF!"}},{"$f":"#REF!/10^6","v":{"$error":"#REF!"}},{"$f":"G15+H14","v":{"$error":"#REF!"}},{"$f":"#REF!/10^6","v":{"$error":"#REF!"}},{"$f":"I15+J14","v":{"$error":"#REF!"}}]
[null,"2013-Q3",{"$f":"#REF!/10^6","v":{"$error":"#REF!"}},{"$f":"C16+D15","v":{"$error":"#REF!"}},{"$f":"#REF!/10^6","v":{"$error":"#REF!"}},{"$f":"E16+F15","v":{"$error":"#REF!"}},{"$f":"#REF!/10^6","v":{"$error":"#REF!"}},{"$f":"G16+H15","v":{"$error":"#REF!"}},{"$f":"#REF!/10^6","v":{"$error":"#REF!"}},{"$f":"I16+J15","v":{"$error":"#REF!"}}]
[null,"TOTAL",{"$f":"SUM(C5:C16)","v":{"$error":"#REF!"}},null,{"$f":"SUM(E5:E16)","v":{"$error":"#REF!"}},null,{"$f":"SUM(G5:G16)","v":{"$error":"#REF!"}},null,{"$f":"SUM(I5:I16)","v":{"$error":"#REF!"}}]

{"sheet":"Audit-Retrofit Graph Data","index":4,"n_rows":17,"n_cols":8,"rows_kept":17,"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":"CONCATENATE(#REF!,\"-\",\"Q\",#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"C5","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"E5","v":{"$error":"#REF!"}},{"$f":"(#REF!*3412.14*3.365)/1000000+(#REF!*100000*1.092)/1000000+(#REF!*(140000/1000000)*1.158)+(#REF!*(91330/1000000)*1.151)","v":{"$error":"#REF!"}},{"$f":"G5","v":{"$error":"#REF!"}}]
[null,{"$f":"CONCATENATE(#REF!,\"-\",\"Q\",#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"C6+D5","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"E6+F5","v":{"$error":"#REF!"}},{"$f":"(#REF!*3412.14*3.365)/1000000+(#REF!*100000*1.092)/1000000+(#REF!*(140000/1000000)*1.158)+(#REF!*(91330/1000000)*1.151)","v":{"$error":"#REF!"}},{"$f":"G6+H5","v":{"$error":"#REF!"}}]
[null,{"$f":"CONCATENATE(#REF!,\"-\",\"Q\",#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"C7+D6","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"E7+F6","v":{"$error":"#REF!"}},{"$f":"(#REF!*3412.14*3.365)/1000000+(#REF!*100000*1.092)/1000000+(#REF!*(140000/1000000)*1.158)+(#REF!*(91330/1000000)*1.151)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[null,{"$f":"CONCATENATE(#REF!,\"-\",\"Q\",#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"(#REF!*3412.14*3.365)/1000000+(#REF!*100000*1.092)/1000000+(#REF!*(140000/1000000)*1.158)+(#REF!*(91330/1000000)*1.151)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[null,{"$f":"CONCATENATE(#REF!,\"-\",\"Q\",#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"(#REF!*3412.14*3.365)/1000000+(#REF!*100000*1.092)/1000000+(#REF!*(140000/1000000)*1.158)+(#REF!*(91330/1000000)*1.151)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[null,{"$f":"CONCATENATE(#REF!,\"-\",\"Q\",#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"(#REF!*3412.14*3.365)/1000000+(#REF!*100000*1.092)/1000000+(#REF!*(140000/1000000)*1.158)+(#REF!*(91330/1000000)*1.151)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[null,{"$f":"CONCATENATE(#REF!,\"-\",\"Q\",#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"(#REF!*3412.14*3.365)/1000000+(#REF!*100000*1.092)/1000000+(#REF!*(140000/1000000)*1.158)+(#REF!*(91330/1000000)*1.151)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[null,{"$f":"CONCATENATE(#REF!,\"-\",\"Q\",#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"(#REF!*3412.14*3.365)/1000000+(#REF!*100000*1.092)/1000000+(#REF!*(140000/1000000)*1.158)+(#REF!*(91330/1000000)*1.151)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[null,{"$f":"CONCATENATE(#REF!,\"-\",\"Q\",#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"(#REF!*3412.14*3.365)/1000000+(#REF!*100000*1.092)/1000000+(#REF!*(140000/1000000)*1.158)+(#REF!*(91330/1000000)*1.151)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[null,{"$f":"CONCATENATE(#REF!,\"-\",\"Q\",#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"(#REF!*3412.14*3.365)/1000000+(#REF!*100000*1.092)/1000000+(#REF!*(140000/1000000)*1.158)+(#REF!*(91330/1000000)*1.151)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[null,"2013-Q2",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"C15+D14","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"E15+F14","v":{"$error":"#REF!"}},{"$f":"(#REF!*3412.14*3.365)/1000000+(#REF!*100000*1.092)/1000000+(#REF!*(140000/1000000)*1.158)+(#REF!*(91330/1000000)*1.151)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[null,"2013-Q3",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"C16+D15","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"E16+F15","v":{"$error":"#REF!"}},{"$f":"(#REF!*3412.14*3.365)/1000000+(#REF!*100000*1.092)/1000000+(#REF!*(140000/1000000)*1.158)+(#REF!*(91330/1000000)*1.151)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[null,"TOTAL",{"$f":"SUM(C5:C16)","v":{"$error":"#REF!"}},null,{"$f":"SUM(E5:E16)","v":{"$error":"#REF!"}},null,{"$f":"SUM(G5:G16)","v":{"$error":"#REF!"}}]