{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Total Ratios","Electric Ratios","Gas Ratios","Combined Inputs","Electric Inputs","Gas Inputs"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"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":"Total Ratios","index":0,"n_rows":21,"n_cols":6,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,0,1,5],[2,0,2,5],[15,0,15,5]]}
["MidAmerican Energy Company"]
["South Dakota Energy Efficiency"]
["2016 Benefit/Cost Statistics - Total (Gas and Electric Non-Curtailment)"]
[]
[null,null,"Ratepayer",null,"Total"]
[null,"Participant","Impact","Utility","Resource","Societal"]
["Program","Test","Test","Test","Test","Test"]
["Residential Equipment",{"$f":"IF('Combined Inputs'!D9>0,('Combined Inputs'!F9+'Combined Inputs'!C9+'Combined Inputs'!E9+'Combined Inputs'!I9)/'Combined Inputs'!D9,0)","v":2.2754346909614611},{"$f":"'Combined Inputs'!G9/('Combined Inputs'!B9+'Combined Inputs'!C9+'Combined Inputs'!F9)","v":0.83338298304297309},{"$f":"'Combined Inputs'!G9/('Combined Inputs'!B9+'Combined Inputs'!C9)","v":4.5886790095065804},{"$f":"('Combined Inputs'!G9+'Combined Inputs'!E9+'Combined Inputs'!I9)/('Combined Inputs'!B9+'Combined Inputs'!D9)","v":1.8822905447606306},{"$f":"('Combined Inputs'!H9+'Combined Inputs'!J9)/('Combined Inputs'!B9+'Combined Inputs'!D9)","v":2.4413984712038115}]
["Residential Audit",{"$f":"IF('Combined Inputs'!D10>0,('Combined Inputs'!F10+'Combined Inputs'!C10+'Combined Inputs'!E10+'Combined Inputs'!I10)/'Combined Inputs'!D10,0)","v":2.8333950227167648},{"$f":"'Combined Inputs'!G10/('Combined Inputs'!B10+'Combined Inputs'!C10+'Combined Inputs'!F10)","v":0.53554585079253525},{"$f":"'Combined Inputs'!G10/('Combined Inputs'!B10+'Combined Inputs'!C10)","v":1.1941313017221931},{"$f":"('Combined Inputs'!G10+'Combined Inputs'!E10+'Combined Inputs'!I10)/('Combined Inputs'!B10+'Combined Inputs'!D10)","v":1.717911123537915},{"$f":"('Combined Inputs'!H10+'Combined Inputs'!J10)/('Combined Inputs'!B10+'Combined Inputs'!D10)","v":1.2617682470285387}]
["Residential Appliance Recycling",{"$f":"IF('Combined Inputs'!D11>0,('Combined Inputs'!F11+'Combined Inputs'!C11+'Combined Inputs'!E11+'Combined Inputs'!I11)/'Combined Inputs'!D11,0)","v":5.0763321747870167},{"$f":"'Combined Inputs'!G11/('Combined Inputs'!B11+'Combined Inputs'!C11+'Combined Inputs'!F11)","v":0.49888029840138587},{"$f":"'Combined Inputs'!G11/('Combined Inputs'!B11+'Combined Inputs'!C11)","v":1.4206421378090466},{"$f":"('Combined Inputs'!G11+'Combined Inputs'!E11+'Combined Inputs'!I11)/('Combined Inputs'!B11+'Combined Inputs'!D11)","v":1.8072838182614461},{"$f":"('Combined Inputs'!H11+'Combined Inputs'!J11)/('Combined Inputs'!B11+'Combined Inputs'!D11)","v":2.138919130549882}]
["Nonresidential Equipment",{"$f":"IF('Combined Inputs'!D12>0,('Combined Inputs'!F12+'Combined Inputs'!C12+'Combined Inputs'!E12+'Combined Inputs'!I12)/'Combined Inputs'!D12,0)","v":2.3221688330475931},{"$f":"'Combined Inputs'!G12/('Combined Inputs'!B12+'Combined Inputs'!C12+'Combined Inputs'!F12)","v":0.95807207363454006},{"$f":"'Combined Inputs'!G12/('Combined Inputs'!B12+'Combined Inputs'!C12)","v":8.2382854762534112},{"$f":"('Combined Inputs'!G12+'Combined Inputs'!E12+'Combined Inputs'!I12)/('Combined Inputs'!B12+'Combined Inputs'!D12)","v":2.2069555595947388},{"$f":"('Combined Inputs'!H12+'Combined Inputs'!J12)/('Combined Inputs'!B12+'Combined Inputs'!D12)","v":3.1793443850893004}]
["Small Commercial Energy Audit",{"$f":"IF('Combined Inputs'!D13>0,('Combined Inputs'!F13+'Combined Inputs'!C13+'Combined Inputs'!E13+'Combined Inputs'!I13)/'Combined Inputs'!D13,0)","v":7.3911574004575664},{"$f":"'Combined Inputs'!G13/('Combined Inputs'!B13+'Combined Inputs'!C13+'Combined Inputs'!F13)","v":0.52256526602644304},{"$f":"'Combined Inputs'!G13/('Combined Inputs'!B13+'Combined Inputs'!C13)","v":1.2425734279595926},{"$f":"('Combined Inputs'!G13+'Combined Inputs'!E13+'Combined Inputs'!I13)/('Combined Inputs'!B13+'Combined Inputs'!D13)","v":4.489387218640573},{"$f":"('Combined Inputs'!H13+'Combined Inputs'!J13)/('Combined Inputs'!B13+'Combined Inputs'!D13)","v":1.5717075043368955}]
["Nonresidential Custom",{"$f":"IF('Combined Inputs'!D14>0,('Combined Inputs'!F14+'Combined Inputs'!C14+'Combined Inputs'!E14+'Combined Inputs'!I14)/'Combined Inputs'!D14,0)","v":1.3760957630456936},{"$f":"'Combined Inputs'!G14/('Combined Inputs'!B14+'Combined Inputs'!C14+'Combined Inputs'!F14)","v":0.95608592318942409},{"$f":"'Combined Inputs'!G14/('Combined Inputs'!B14+'Combined Inputs'!C14)","v":4.5866919861634949},{"$f":"('Combined Inputs'!G14+'Combined Inputs'!E14+'Combined Inputs'!I14)/('Combined Inputs'!B14+'Combined Inputs'!D14)","v":1.2781782809171527},{"$f":"('Combined Inputs'!H14+'Combined Inputs'!J14)/('Combined Inputs'!B14+'Combined Inputs'!D14)","v":1.8684722261298041}]
["Total",{"$f":"IF('Combined Inputs'!D15>0,('Combined Inputs'!F15+'Combined Inputs'!C15+'Combined Inputs'!E15+'Combined Inputs'!I15)/'Combined Inputs'!D15,0)","v":2.3678343693070314},{"$f":"'Combined Inputs'!G15/('Combined Inputs'!B15+'Combined Inputs'!C15+'Combined Inputs'!F15)","v":0.82818788371193852},{"$f":"'Combined Inputs'!G15/('Combined Inputs'!B15+'Combined Inputs'!C15)","v":4.1147150185841843},{"$f":"('Combined Inputs'!G15+'Combined Inputs'!E15+'Combined Inputs'!I15)/('Combined Inputs'!B15+'Combined Inputs'!D15)","v":1.9353445562577591},{"$f":"('Combined Inputs'!H15+'Combined Inputs'!J15)/('Combined Inputs'!B15+'Combined Inputs'!D15)","v":2.390208084317186}]
[]
["2016 Benefit/Cost Statistics - Total Electric Curtailment"]
[]
[null,null,"Ratepayer",null,"Total"]
[null,"Participant","Impact","Utility","Resource","Societal"]
["Program","Test","Test","Test","Test","Test"]
["Residential Load Management",{"$f":"'Electric Ratios'!B21","v":0},{"$f":"'Electric Ratios'!C21","v":1.1897811847168491},{"$f":"'Electric Ratios'!D21","v":1.2008772198784443},{"$f":"'Electric Ratios'!E21","v":2.4001160580315566},{"$f":"'Electric Ratios'!F21","v":2.6751153796635108}]

{"sheet":"Electric Ratios","index":1,"n_rows":21,"n_cols":6,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,0,1,5],[2,0,2,5],[15,0,15,5]]}
["MidAmerican Energy Company"]
["South Dakota Energy Efficiency"]
["2016 Benefit/Cost Statistics - Electric Programs (Non-Curtailment)"]
[]
[null,null,"Ratepayer",null,"Total"]
[null,"Participant","Impact","Utility","Resource","Societal"]
["Program","Test","Test","Test","Test","Test"]
["Residential Equipment",{"$f":"IF('Electric Inputs'!D9>0,('Electric Inputs'!F9+'Electric Inputs'!C9+'Electric Inputs'!E9+'Electric Inputs'!I9)/'Electric Inputs'!D9,0)","v":1.7648776132405828},{"$f":"'Electric Inputs'!G9/('Electric Inputs'!B9+'Electric Inputs'!C9+'Electric Inputs'!F9)","v":0.95964330285853583},{"$f":"'Electric Inputs'!G9/('Electric Inputs'!B9+'Electric Inputs'!C9)","v":3.2446022390860993},{"$f":"('Electric Inputs'!G9+'Electric Inputs'!I9+'Electric Inputs'!E9)/('Electric Inputs'!B9+'Electric Inputs'!D9)","v":1.6751503928766898},{"$f":"('Electric Inputs'!H9+'Electric Inputs'!J9)/('Electric Inputs'!B9+'Electric Inputs'!D9)","v":1.6416976777602912}]
["Residential Audit",{"$f":"IF('Electric Inputs'!D10>0,('Electric Inputs'!F10+'Electric Inputs'!C10+'Electric Inputs'!E10+'Electric Inputs'!I10)/'Electric Inputs'!D10,0)","v":1.4973811144963578},{"$f":"'Electric Inputs'!G10/('Electric Inputs'!B10+'Electric Inputs'!C10+'Electric Inputs'!F10)","v":0.61953893220455358},{"$f":"'Electric Inputs'!G10/('Electric Inputs'!B10+'Electric Inputs'!C10)","v":1.788570347807207},{"$f":"('Electric Inputs'!G10+'Electric Inputs'!I10+'Electric Inputs'!E10)/('Electric Inputs'!B10+'Electric Inputs'!D10)","v":0.94714945034207321},{"$f":"('Electric Inputs'!H10+'Electric Inputs'!J10)/('Electric Inputs'!B10+'Electric Inputs'!D10)","v":1.1886589286327722}]
["Residential Appliance Recycling",{"$f":"IF('Electric Inputs'!D11>0,('Electric Inputs'!F11+'Electric Inputs'!C11+'Electric Inputs'!E11+'Electric Inputs'!I11)/'Electric Inputs'!D11,0)","v":5.0763321747870167},{"$f":"'Electric Inputs'!G11/('Electric Inputs'!B11+'Electric Inputs'!C11+'Electric Inputs'!F11)","v":0.49888029840138587},{"$f":"'Electric Inputs'!G11/('Electric Inputs'!B11+'Electric Inputs'!C11)","v":1.4206421378090466},{"$f":"('Electric Inputs'!G11+'Electric Inputs'!I11+'Electric Inputs'!E11)/('Electric Inputs'!B11+'Electric Inputs'!D11)","v":1.8072838182614461},{"$f":"('Electric Inputs'!H11+'Electric Inputs'!J11)/('Electric Inputs'!B11+'Electric Inputs'!D11)","v":2.138919130549882}]
["Nonresidential Equipment",{"$f":"IF('Electric Inputs'!D12>0,('Electric Inputs'!F12+'Electric Inputs'!C12+'Electric Inputs'!E12+'Electric Inputs'!I12)/'Electric Inputs'!D12,0)","v":4.2779850680022777},{"$f":"'Electric Inputs'!G12/('Electric Inputs'!B12+'Electric Inputs'!C12+'Electric Inputs'!F12)","v":1.2069585412606672},{"$f":"'Electric Inputs'!G12/('Electric Inputs'!B12+'Electric Inputs'!C12)","v":11.43120546070471},{"$f":"('Electric Inputs'!G12+'Electric Inputs'!I12+'Electric Inputs'!E12)/('Electric Inputs'!B12+'Electric Inputs'!D12)","v":4.8140048511453859},{"$f":"('Electric Inputs'!H12+'Electric Inputs'!J12)/('Electric Inputs'!B12+'Electric Inputs'!D12)","v":6.7873302473610346}]
["Small Commercial Energy Audit",{"$f":"IF('Electric Inputs'!D13>0,('Electric Inputs'!F13+'Electric Inputs'!C13+'Electric Inputs'!E13+'Electric Inputs'!I13)/'Electric Inputs'!D13,0)","v":2.6489750626995581},{"$f":"'Electric Inputs'!G13/('Electric Inputs'!B13+'Electric Inputs'!C13+'Electric Inputs'!F13)","v":0.37003567065171683},{"$f":"'Electric Inputs'!G13/('Electric Inputs'!B13+'Electric Inputs'!C13)","v":0.5266146944556046},{"$f":"('Electric Inputs'!G13+'Electric Inputs'!I13+'Electric Inputs'!E13)/('Electric Inputs'!B13+'Electric Inputs'!D13)","v":1.0678195212484041},{"$f":"('Electric Inputs'!H13+'Electric Inputs'!J13)/('Electric Inputs'!B13+'Electric Inputs'!D13)","v":0.6944307548539087}]
["Nonresidential Custom",{"$f":"IF('Electric Inputs'!D14>0,('Electric Inputs'!F14+'Electric Inputs'!C14+'Electric Inputs'!E14+'Electric Inputs'!I14)/'Electric Inputs'!D14,0)","v":0.7495011964521292},{"$f":"'Electric Inputs'!G14/('Electric Inputs'!B14+'Electric Inputs'!C14+'Electric Inputs'!F14)","v":1.1425718585725266},{"$f":"'Electric Inputs'!G14/('Electric Inputs'!B14+'Electric Inputs'!C14)","v":4.8714986966339655},{"$f":"('Electric Inputs'!G14+'Electric Inputs'!I14+'Electric Inputs'!E14)/('Electric Inputs'!B14+'Electric Inputs'!D14)","v":0.88404676770355961},{"$f":"('Electric Inputs'!H14+'Electric Inputs'!J14)/('Electric Inputs'!B14+'Electric Inputs'!D14)","v":1.3439170496755968}]
["Total",{"$f":"IF('Electric Inputs'!D15>0,('Electric Inputs'!F15+'Electric Inputs'!C15+'Electric Inputs'!E15+'Electric Inputs'!I15)/'Electric Inputs'!D15,0)","v":1.8568225913122343},{"$f":"'Electric Inputs'!G15/('Electric Inputs'!B15+'Electric Inputs'!C15+'Electric Inputs'!F15)","v":1.0408667068678301},{"$f":"'Electric Inputs'!G15/('Electric Inputs'!B15+'Electric Inputs'!C15)","v":4.5201411396247639},{"$f":"('Electric Inputs'!G15+'Electric Inputs'!I15+'Electric Inputs'!E15)/('Electric Inputs'!B15+'Electric Inputs'!D15)","v":1.8506768492195622},{"$f":"('Electric Inputs'!H15+'Electric Inputs'!J15)/('Electric Inputs'!B15+'Electric Inputs'!D15)","v":2.1810810366817028}]
[]
["2016 Benefit/Cost Statistics - Total Electric Curtailment"]
[]
[null,null,"Ratepayer",null,"Total"]
[null,"Participant","Impact","Utility","Resource","Societal"]
["Program","Test","Test","Test","Test","Test"]
["Residential Load Management",0,1.1897811847168491,1.2008772198784443,2.4001160580315566,2.6751153796635108]

{"sheet":"Gas Ratios","index":2,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,0,1,5],[2,0,2,5]]}
["MidAmerican Energy Company"]
["South Dakota Energy Efficiency"]
["2016 Benefit/Cost Statistics - Gas Programs"]
[]
[null,null,"Ratepayer",null,"Total"]
[null,"Participant","Impact","Utility","Resource","Societal"]
["Program","Test","Test","Test","Test","Test"]
["Residential Equipment",{"$f":"IF('Gas Inputs'!D9>0,('Gas Inputs'!F9+'Gas Inputs'!C9+'Gas Inputs'!E9+'Gas Inputs'!I9)/'Gas Inputs'!D9,0)","v":2.354273561172322},{"$f":"'Gas Inputs'!G9/('Gas Inputs'!B9+'Gas Inputs'!C9+'Gas Inputs'!F9)","v":0.82308780694723205},{"$f":"'Gas Inputs'!G9/('Gas Inputs'!B9+'Gas Inputs'!C9)","v":4.7767968328460979},{"$f":"('Gas Inputs'!G9+'Gas Inputs'!I9+'Gas Inputs'!E9)/('Gas Inputs'!B9+'Gas Inputs'!D9)","v":1.915295563764992},{"$f":"('Gas Inputs'!H9+'Gas Inputs'!J9)/('Gas Inputs'!B9+'Gas Inputs'!D9)","v":2.5688201209677586}]
["Residential Audit",{"$f":"IF('Gas Inputs'!D10>0,('Gas Inputs'!F10+'Gas Inputs'!C10+'Gas Inputs'!E10+'Gas Inputs'!I10)/'Gas Inputs'!D10,0)","v":2.8491991295396573},{"$f":"'Gas Inputs'!G10/('Gas Inputs'!B10+'Gas Inputs'!C10+'Gas Inputs'!F10)","v":0.53483173133302819},{"$f":"'Gas Inputs'!G10/('Gas Inputs'!B10+'Gas Inputs'!C10)","v":1.1902353556275695},{"$f":"('Gas Inputs'!G10+'Gas Inputs'!I10+'Gas Inputs'!E10)/('Gas Inputs'!B10+'Gas Inputs'!D10)","v":1.726186261703303},{"$f":"('Gas Inputs'!H10+'Gas Inputs'!J10)/('Gas Inputs'!B10+'Gas Inputs'!D10)","v":1.2625531715154996}]
["Nonresidential Equipment",{"$f":"IF('Gas Inputs'!D11>0,('Gas Inputs'!F11+'Gas Inputs'!C11+'Gas Inputs'!E11+'Gas Inputs'!I11)/'Gas Inputs'!D11,0)","v":2.1837555210834685},{"$f":"'Gas Inputs'!G11/('Gas Inputs'!B11+'Gas Inputs'!C11+'Gas Inputs'!F11)","v":0.922495680323272},{"$f":"'Gas Inputs'!G11/('Gas Inputs'!B11+'Gas Inputs'!C11)","v":7.8293002700669856},{"$f":"('Gas Inputs'!G11+'Gas Inputs'!I11+'Gas Inputs'!E11)/('Gas Inputs'!B11+'Gas Inputs'!D11)","v":2.0064622038670374},{"$f":"('Gas Inputs'!H11+'Gas Inputs'!J11)/('Gas Inputs'!B11+'Gas Inputs'!D11)","v":2.9018746819696073}]
["Small Commercial Energy Audit",{"$f":"IF('Gas Inputs'!D12>0,('Gas Inputs'!F12+'Gas Inputs'!C12+'Gas Inputs'!E12+'Gas Inputs'!I12)/'Gas Inputs'!D12,0)","v":7.5751568876295678},{"$f":"'Gas Inputs'!G12/('Gas Inputs'!B12+'Gas Inputs'!C12+'Gas Inputs'!F12)","v":0.52690442710815433},{"$f":"'Gas Inputs'!G12/('Gas Inputs'!B12+'Gas Inputs'!C12)","v":1.2772662684062139},{"$f":"('Gas Inputs'!G12+'Gas Inputs'!I12+'Gas Inputs'!E12)/('Gas Inputs'!B12+'Gas Inputs'!D12)","v":4.6550013145205869},{"$f":"('Gas Inputs'!H12+'Gas Inputs'!J12)/('Gas Inputs'!B12+'Gas Inputs'!D12)","v":1.6141703192076691}]
["Nonresidential Custom",{"$f":"IF('Gas Inputs'!D13>0,('Gas Inputs'!F13+'Gas Inputs'!C13+'Gas Inputs'!E13+'Gas Inputs'!I13)/'Gas Inputs'!D13,0)","v":2.1218964883779812},{"$f":"'Gas Inputs'!G13/('Gas Inputs'!B13+'Gas Inputs'!C13+'Gas Inputs'!F13)","v":0.87155697444393998},{"$f":"'Gas Inputs'!G13/('Gas Inputs'!B13+'Gas Inputs'!C13)","v":4.4326982963672981},{"$f":"('Gas Inputs'!G13+'Gas Inputs'!I13+'Gas Inputs'!E13)/('Gas Inputs'!B13+'Gas Inputs'!D13)","v":1.738826354565193},{"$f":"('Gas Inputs'!H13+'Gas Inputs'!J13)/('Gas Inputs'!B13+'Gas Inputs'!D13)","v":2.481555228769047}]
["Total",{"$f":"IF('Gas Inputs'!D14>0,('Gas Inputs'!F14+'Gas Inputs'!C14+'Gas Inputs'!E14+'Gas Inputs'!I14)/'Gas Inputs'!D14,0)","v":2.4417015551994989},{"$f":"'Gas Inputs'!G14/('Gas Inputs'!B14+'Gas Inputs'!C14+'Gas Inputs'!F14)","v":0.80694520792754787},{"$f":"'Gas Inputs'!G14/('Gas Inputs'!B14+'Gas Inputs'!C14)","v":4.067709836535399},{"$f":"('Gas Inputs'!G14+'Gas Inputs'!I14+'Gas Inputs'!E14)/('Gas Inputs'!B14+'Gas Inputs'!D14)","v":1.9478636239017346},{"$f":"('Gas Inputs'!H14+'Gas Inputs'!J14)/('Gas Inputs'!B14+'Gas Inputs'!D14)","v":2.4211298577668003}]

{"sheet":"Combined Inputs","index":3,"n_rows":15,"n_cols":10,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,9],[1,0,1,9],[2,0,2,9]]}
["MidAmerican Energy Company"]
["South Dakota Energy Efficiency"]
["2016 Benefit/Cost Input Data - Total (Gas and Electric Non-Curtailment)"]
[]
[null,null,null,null,null,null,"Avoided","Avoided"]
[null,null,null,null,null,"Bill","Energy - Capacity","Energy - Capacity","Non-Energy"]
[null,"Administrative","Incentives","Incremental","Tax","Savings","Costs","Costs","Benefits","Externalities"]
["Program","Costs","Paid","Investment","Credits","(NPV - PRT)","(NPV - PRT)","(NPV - SOC)","(NPV - PRT)","(NPV-SOC)"]
["Residential Equipment",{"$f":"'Electric Inputs'!B9+'Gas Inputs'!B9","v":51200.17},{"$f":"'Electric Inputs'!C9+'Gas Inputs'!C9","v":618136.82999999996},{"$f":"'Electric Inputs'!D9+'Gas Inputs'!D9","v":1676810.87},{"$f":"'Electric Inputs'!E9+'Gas Inputs'!E9","v":131200},{"$f":"'Electric Inputs'!F9+'Gas Inputs'!F9","v":3016090.594131391},{"$f":"'Electric Inputs'!G9+'Gas Inputs'!G9","v":3071372.6421861062},{"$f":"'Electric Inputs'!H9+'Gas Inputs'!H9","v":3916223.0244686613},{"$f":"'Electric Inputs'!I9+'Gas Inputs'!I9","v":50046.199647877962},{"$f":"'Electric Inputs'!J9+'Gas Inputs'!J9","v":302540.4868106466}]
["Residential Audit",{"$f":"'Electric Inputs'!B10+'Gas Inputs'!B10","v":81000.83},{"$f":"'Electric Inputs'!C10+'Gas Inputs'!C10","v":225696.16999999998},{"$f":"'Electric Inputs'!D10+'Gas Inputs'!D10","v":336868.48},{"$f":"'Electric Inputs'!E10+'Gas Inputs'!E10","v":0},{"$f":"'Electric Inputs'!F10+'Gas Inputs'!F10","v":377159.45655234013},{"$f":"'Electric Inputs'!G10+'Gas Inputs'!G10","v":366236.48784429143},{"$f":"'Electric Inputs'!H10+'Gas Inputs'!H10","v":490795.58538702392},{"$f":"'Electric Inputs'!I10+'Gas Inputs'!I10","v":351625.84798982186},{"$f":"'Electric Inputs'!J10+'Gas Inputs'!J10","v":36458.641378701097}]
["Residential Appliance Recycling",{"$f":"'Electric Inputs'!B11","v":1999.5},{"$f":"'Electric Inputs'!C11","v":5133.5},{"$f":"'Electric Inputs'!D11","v":3607.5},{"$f":"'Electric Inputs'!E11","v":0},{"$f":"'Electric Inputs'!F11","v":13179.368320544165},{"$f":"'Electric Inputs'!G11","v":10133.440368991929},{"$f":"'Electric Inputs'!H11","v":10902.65349790053},{"$f":"'Electric Inputs'!I11","v":0},{"$f":"'Electric Inputs'!J11","v":1090.2660670926587}]
["Nonresidential Equipment",{"$f":"'Electric Inputs'!B12+'Gas Inputs'!B11","v":9699.31},{"$f":"'Electric Inputs'!C12+'Gas Inputs'!C11","v":162506.07999999999},{"$f":"'Electric Inputs'!D12+'Gas Inputs'!D11","v":640481.20000000007},{"$f":"'Electric Inputs'!E12+'Gas Inputs'!E11","v":0},{"$f":"'Electric Inputs'!F12+'Gas Inputs'!F11","v":1308557.0728778334},{"$f":"'Electric Inputs'!G12+'Gas Inputs'!G11","v":1418677.1633695543},{"$f":"'Electric Inputs'!H12+'Gas Inputs'!H11","v":1916265.5284476802},{"$f":"'Electric Inputs'!I12+'Gas Inputs'!I11","v":16242.327915088737},{"$f":"'Electric Inputs'!J12+'Gas Inputs'!J11","v":150882.22531531801}]
["Small Commercial Energy Audit",{"$f":"'Electric Inputs'!B13+'Gas Inputs'!B12","v":13000.444},{"$f":"'Electric Inputs'!C13+'Gas Inputs'!C12","v":34038.555999999997},{"$f":"'Electric Inputs'!D13+'Gas Inputs'!D12","v":34036.156000000003},{"$f":"'Electric Inputs'!E13+'Gas Inputs'!E12","v":0},{"$f":"'Electric Inputs'!F13+'Gas Inputs'!F12","v":64811.930932010313},{"$f":"'Electric Inputs'!G13+'Gas Inputs'!G12","v":58449.411477791276},{"$f":"'Electric Inputs'!H13+'Gas Inputs'!H12","v":68738.147011079083},{"$f":"'Electric Inputs'!I13+'Gas Inputs'!I12","v":152716.09937051791},{"$f":"'Electric Inputs'!J13+'Gas Inputs'!J12","v":5189.6301874137389}]
["Nonresidential Custom",{"$f":"'Electric Inputs'!B14+'Gas Inputs'!B13","v":18001.800000000003},{"$f":"'Electric Inputs'!C14+'Gas Inputs'!C13","v":30117.199999999997},{"$f":"'Electric Inputs'!D14+'Gas Inputs'!D13","v":154671.32},{"$f":"'Electric Inputs'!E14+'Gas Inputs'!E13","v":0},{"$f":"'Electric Inputs'!F14+'Gas Inputs'!F13","v":182725.34811668465},{"$f":"'Electric Inputs'!G14+'Gas Inputs'!G13","v":220707.03168220122},{"$f":"'Electric Inputs'!H14+'Gas Inputs'!H13","v":297292.04884560825},{"$f":"'Electric Inputs'!I14+'Gas Inputs'!I13","v":0},{"$f":"'Electric Inputs'!J14+'Gas Inputs'!J13","v":25342.880073570523}]
["Total",{"$f":"SUM(B9:B14)","v":174902.054},{"$f":"SUM(C9:C14)","v":1075628.3359999999},2846475.5260000001,{"$f":"SUM(E9:E14)","v":131200},4962523.7709308043,5145576.1769289365,6700216.9876579531,{"$f":"SUM(I9:I14)","v":570630.47492330649},521504.12983274256]

{"sheet":"Electric Inputs","index":4,"n_rows":15,"n_cols":10,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,9],[1,0,1,9],[2,0,2,9]]}
["MidAmerican Energy Company"]
["South Dakota Energy Efficiency"]
["2016 Benefit/Cost Input Data - Electric Programs (Non-Curtailment)"]
[]
[null,null,null,null,null,null,"Avoided","Avoided"]
[null,null,null,null,null,"Bill","Energy - Capacity","Energy - Capacity","Non-Energy"]
[null,"Administrative","Incentives","Incremental","Tax","Savings","Costs","Costs","Benefits","Externalities"]
["Program","Costs","Paid","Investment","Credits","(NPV - PRT)","(NPV - PRT)","(NPV - SOC)","(NPV - PRT)","(NPV-SOC)"]
["Residential Equipment",13200.169999999998,68978.83,224293.83000000002,131200,195672.32935498905,266638.16740585654,354448.49010167352,0,35444.858180329065]
["Residential Audit",500.38999999999987,1496.6100000000001,3938.33,0,3768.2147410030675,3571.7749845709923,4796.4772967174085,632.35622365137397,479.6468629834489]
["Residential Appliance Recycling",1999.5,5133.5,3607.5,0,13179.368320544165,10133.440368991929,10902.65349790053,0,1090.2660670926587]
["Nonresidential Equipment",4099.8099999999995,15453.58,42331.14,0,165638.40483151394,223518.81854328886,286492.90442218754,0,28649.286926520297]
["Small Commercial Energy Audit",900.30400000000009,1273.6959999999999,1271.2959999999998,0,919.91887471314715,1144.8603457464844,1370.9368182398059,1174.0165265965497,137.08900900094216]
["Nonresidential Custom",9002,7885,84053.03,0,55112.846550426708,82264.998490057769,113499.77888480673,0,11558.462490267426]
["Total",{"$f":"SUM(B9:B14)","v":29702.173999999995},100221.216,359495.12599999993,131200,434291.08267319005,587272.06013851264,771511.24102152558,1806.3727502479237,77359.60953619385]

{"sheet":"Gas Inputs","index":5,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,0,0,9],[1,0,1,9],[2,0,2,9]]}
["MidAmerican Energy Company"]
["South Dakota Energy Efficiency"]
["2016 Benefit/Cost Input Data - Gas Programs"]
[]
[null,null,null,null,null,null,"Avoided","Avoided"]
[null,null,null,null,null,"Bill","Energy - Capacity","Energy - Capacity","Non-Energy"]
[null,"Administrative","Incentives","Incremental","Tax","Savings","Costs","Costs","Benefits","Externalities"]
["Program","Costs","Paid","Investment","Credits","(NPV - PRT)","(NPV - PRT)","(NPV - SOC)","(NPV - PRT)","(NPV-SOC)"]
["Residential Equipment",38000,549158,1452517.04,0,2820418.2647764022,2804734.4747802494,3561774.5343669876,50046.199647877962,267095.62863031751]
["Residential Audit",80500.44,224199.56,332930.14999999997,0,373391.24181133707,362664.71285972046,485999.10809030652,350993.49176617048,35978.994515717648]
["Nonresidential Equipment",5599.5,147052.5,598150.06000000006,0,1142918.6680463194,1195158.3448262655,1629772.6240254927,16242.327915088737,122232.93838879772]
["Small Commercial Energy Audit",12100.14,32764.86,32764.86,0,63892.012057297165,57304.551132044791,67367.21019283928,151542.08284392135,5052.5411784127964]
["Nonresidential Custom",8999.8000000000029,22232.199999999997,70618.290000000008,0,127612.50156625794,138442.03319214346,183792.26996080152,0,13784.417583303095]
["Total",{"$f":"SUM(B9:B13)","v":145199.88},975407.12,2486980.4,0,4528232.6882576132,4558304.1167904241,5928705.7466364279,568824.10217305855,444144.52029654884]