{"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":1,"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"]
["2017 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.3704168343462952},{"$f":"'Combined Inputs'!G9/('Combined Inputs'!B9+'Combined Inputs'!C9+'Combined Inputs'!F9)","v":0.84021104304317884},{"$f":"'Combined Inputs'!G9/('Combined Inputs'!B9+'Combined Inputs'!C9)","v":4.8036207213879951},{"$f":"('Combined Inputs'!G9+'Combined Inputs'!E9+'Combined Inputs'!I9)/('Combined Inputs'!B9+'Combined Inputs'!D9)","v":1.9734252890844013},{"$f":"('Combined Inputs'!H9+'Combined Inputs'!J9)/('Combined Inputs'!B9+'Combined Inputs'!D9)","v":2.5596035092543521}]
["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.53350888574332211},{"$f":"'Combined Inputs'!G10/('Combined Inputs'!B10+'Combined Inputs'!C10)","v":1.1840511329945926},{"$f":"('Combined Inputs'!G10+'Combined Inputs'!E10+'Combined Inputs'!I10)/('Combined Inputs'!B10+'Combined Inputs'!D10)","v":1.7072436420010091},{"$f":"('Combined Inputs'!H10+'Combined Inputs'!J10)/('Combined Inputs'!B10+'Combined Inputs'!D10)","v":1.2550532160632693}]
["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":4.7546741616439183},{"$f":"'Combined Inputs'!G11/('Combined Inputs'!B11+'Combined Inputs'!C11+'Combined Inputs'!F11)","v":0.48691850592969399},{"$f":"'Combined Inputs'!G11/('Combined Inputs'!B11+'Combined Inputs'!C11)","v":1.3277568617651898},{"$f":"('Combined Inputs'!G11+'Combined Inputs'!E11+'Combined Inputs'!I11)/('Combined Inputs'!B11+'Combined Inputs'!D11)","v":1.701383540797839},{"$f":"('Combined Inputs'!H11+'Combined Inputs'!J11)/('Combined Inputs'!B11+'Combined Inputs'!D11)","v":2.0135862264931479}]
["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.3511273350996138},{"$f":"'Combined Inputs'!G12/('Combined Inputs'!B12+'Combined Inputs'!C12+'Combined Inputs'!F12)","v":0.96787658252904563},{"$f":"'Combined Inputs'!G12/('Combined Inputs'!B12+'Combined Inputs'!C12)","v":9.0243544662785062},{"$f":"('Combined Inputs'!G12+'Combined Inputs'!E12+'Combined Inputs'!I12)/('Combined Inputs'!B12+'Combined Inputs'!D12)","v":2.247180536609279},{"$f":"('Combined Inputs'!H12+'Combined Inputs'!J12)/('Combined Inputs'!B12+'Combined Inputs'!D12)","v":3.2372925636357719}]
["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.51862403437512294},{"$f":"'Combined Inputs'!G13/('Combined Inputs'!B13+'Combined Inputs'!C13)","v":1.2205185215350347},{"$f":"('Combined Inputs'!G13+'Combined Inputs'!E13+'Combined Inputs'!I13)/('Combined Inputs'!B13+'Combined Inputs'!D13)","v":4.4096993908172468},{"$f":"('Combined Inputs'!H13+'Combined Inputs'!J13)/('Combined Inputs'!B13+'Combined Inputs'!D13)","v":1.5438092743793215}]
["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.95608178151652057},{"$f":"'Combined Inputs'!G14/('Combined Inputs'!B14+'Combined Inputs'!C14)","v":4.5865966683749217},{"$f":"('Combined Inputs'!G14+'Combined Inputs'!E14+'Combined Inputs'!I14)/('Combined Inputs'!B14+'Combined Inputs'!D14)","v":1.2781708786597623},{"$f":"('Combined Inputs'!H14+'Combined Inputs'!J14)/('Combined Inputs'!B14+'Combined Inputs'!D14)","v":1.8684614053291762}]
["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.4323806423594059},{"$f":"'Combined Inputs'!G15/('Combined Inputs'!B15+'Combined Inputs'!C15+'Combined Inputs'!F15)","v":0.83368792175112694},{"$f":"'Combined Inputs'!G15/('Combined Inputs'!B15+'Combined Inputs'!C15)","v":4.2541546899266809},{"$f":"('Combined Inputs'!G15+'Combined Inputs'!E15+'Combined Inputs'!I15)/('Combined Inputs'!B15+'Combined Inputs'!D15)","v":1.9931516811798922},{"$f":"('Combined Inputs'!H15+'Combined Inputs'!J15)/('Combined Inputs'!B15+'Combined Inputs'!D15)","v":2.4617621272882779}]
[]
["2017 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.1989620163224162},{"$f":"'Electric Ratios'!D21","v":1.2102307660862872},{"$f":"'Electric Ratios'!E21","v":2.7937682202306293},{"$f":"'Electric Ratios'!F21","v":3.1186541227219409}]

{"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"]
["2017 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.7644981189990214},{"$f":"'Electric Inputs'!G9/('Electric Inputs'!B9+'Electric Inputs'!C9+'Electric Inputs'!F9)","v":0.9596363953055107},{"$f":"'Electric Inputs'!G9/('Electric Inputs'!B9+'Electric Inputs'!C9)","v":3.2445232767410537},{"$f":"('Electric Inputs'!G9+'Electric Inputs'!I9+'Electric Inputs'!E9)/('Electric Inputs'!B9+'Electric Inputs'!D9)","v":1.6746739272932762},{"$f":"('Electric Inputs'!H9+'Electric Inputs'!J9)/('Electric Inputs'!B9+'Electric Inputs'!D9)","v":1.6412307271837048}]
["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.61718376532057206},{"$f":"'Electric Inputs'!G10/('Electric Inputs'!B10+'Electric Inputs'!C10)","v":1.769081220688951},{"$f":"('Electric Inputs'!G10+'Electric Inputs'!I10+'Electric Inputs'!E10)/('Electric Inputs'!B10+'Electric Inputs'!D10)","v":0.94247816680319929},{"$f":"('Electric Inputs'!H10+'Electric Inputs'!J10)/('Electric Inputs'!B10+'Electric Inputs'!D10)","v":1.1827965350214447}]
["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":4.7546741616439183},{"$f":"'Electric Inputs'!G11/('Electric Inputs'!B11+'Electric Inputs'!C11+'Electric Inputs'!F11)","v":0.48691850592969399},{"$f":"'Electric Inputs'!G11/('Electric Inputs'!B11+'Electric Inputs'!C11)","v":1.3277568617651898},{"$f":"('Electric Inputs'!G11+'Electric Inputs'!I11+'Electric Inputs'!E11)/('Electric Inputs'!B11+'Electric Inputs'!D11)","v":1.701383540797839},{"$f":"('Electric Inputs'!H11+'Electric Inputs'!J11)/('Electric Inputs'!B11+'Electric Inputs'!D11)","v":2.0135862264931479}]
["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.2069520239523543},{"$f":"'Electric Inputs'!G12/('Electric Inputs'!B12+'Electric Inputs'!C12)","v":11.430620875582868},{"$f":"('Electric Inputs'!G12+'Electric Inputs'!I12+'Electric Inputs'!E12)/('Electric Inputs'!B12+'Electric Inputs'!D12)","v":4.8139011724316738},{"$f":"('Electric Inputs'!H12+'Electric Inputs'!J12)/('Electric Inputs'!B12+'Electric Inputs'!D12)","v":6.7871840693468153}]
["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.36624761922253779},{"$f":"'Electric Inputs'!G13/('Electric Inputs'!B13+'Electric Inputs'!C13)","v":0.51897567803557776},{"$f":"('Electric Inputs'!G13+'Electric Inputs'!I13+'Electric Inputs'!E13)/('Electric Inputs'!B13+'Electric Inputs'!D13)","v":1.0523129752872726},{"$f":"('Electric Inputs'!H13+'Electric Inputs'!J13)/('Electric Inputs'!B13+'Electric Inputs'!D13)","v":0.6843464454713869}]
["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.1423497345396323},{"$f":"'Electric Inputs'!G14/('Electric Inputs'!B14+'Electric Inputs'!C14)","v":4.8674633743599651},{"$f":"('Electric Inputs'!G14+'Electric Inputs'!I14+'Electric Inputs'!E14)/('Electric Inputs'!B14+'Electric Inputs'!D14)","v":0.88391378410259325},{"$f":"('Electric Inputs'!H14+'Electric Inputs'!J14)/('Electric Inputs'!B14+'Electric Inputs'!D14)","v":1.3437148896370164}]
["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.8561653811034926},{"$f":"'Electric Inputs'!G15/('Electric Inputs'!B15+'Electric Inputs'!C15+'Electric Inputs'!F15)","v":1.0398162282310741},{"$f":"'Electric Inputs'!G15/('Electric Inputs'!B15+'Electric Inputs'!C15)","v":4.5003969943497726},{"$f":"('Electric Inputs'!G15+'Electric Inputs'!I15+'Electric Inputs'!E15)/('Electric Inputs'!B15+'Electric Inputs'!D15)","v":1.8483707864519694},{"$f":"('Electric Inputs'!H15+'Electric Inputs'!J15)/('Electric Inputs'!B15+'Electric Inputs'!D15)","v":2.1783632689774621}]
[]
["2017 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.1989620163224162,1.2102307660862872,2.7937682202306293,3.1186541227219409]

{"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"]
["2017 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.4694364699937976},{"$f":"'Gas Inputs'!G9/('Gas Inputs'!B9+'Gas Inputs'!C9+'Gas Inputs'!F9)","v":0.83038676149667057},{"$f":"'Gas Inputs'!G9/('Gas Inputs'!B9+'Gas Inputs'!C9)","v":5.0335683298102483},{"$f":"('Gas Inputs'!G9+'Gas Inputs'!I9+'Gas Inputs'!E9)/('Gas Inputs'!B9+'Gas Inputs'!D9)","v":2.0237368001661418},{"$f":"('Gas Inputs'!H9+'Gas Inputs'!J9)/('Gas Inputs'!B9+'Gas Inputs'!D9)","v":2.7142629629395234}]
["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.53279747314927883},{"$f":"'Gas Inputs'!G10/('Gas Inputs'!B10+'Gas Inputs'!C10)","v":1.1802072734778024},{"$f":"('Gas Inputs'!G10+'Gas Inputs'!I10+'Gas Inputs'!E10)/('Gas Inputs'!B10+'Gas Inputs'!D10)","v":1.7154437477953646},{"$f":"('Gas Inputs'!H10+'Gas Inputs'!J10)/('Gas Inputs'!B10+'Gas Inputs'!D10)","v":1.2558279796321119}]
["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.2109636974069566},{"$f":"'Gas Inputs'!G11/('Gas Inputs'!B11+'Gas Inputs'!C11+'Gas Inputs'!F11)","v":0.93330208785097934},{"$f":"'Gas Inputs'!G11/('Gas Inputs'!B11+'Gas Inputs'!C11)","v":8.6825256977883587},{"$f":"('Gas Inputs'!G11+'Gas Inputs'!I11+'Gas Inputs'!E11)/('Gas Inputs'!B11+'Gas Inputs'!D11)","v":2.045904077891842},{"$f":"('Gas Inputs'!H11+'Gas Inputs'!J11)/('Gas Inputs'!B11+'Gas Inputs'!D11)","v":2.958918056831803}]
["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.52297097719761176},{"$f":"'Gas Inputs'!G12/('Gas Inputs'!B12+'Gas Inputs'!C12)","v":1.2543955329563468},{"$f":"('Gas Inputs'!G12+'Gas Inputs'!I12+'Gas Inputs'!E12)/('Gas Inputs'!B12+'Gas Inputs'!D12)","v":4.5716488403994076},{"$f":"('Gas Inputs'!H12+'Gas Inputs'!J12)/('Gas Inputs'!B12+'Gas Inputs'!D12)","v":1.5852669783344369}]
["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.87162830941563041},{"$f":"'Gas Inputs'!G13/('Gas Inputs'!B13+'Gas Inputs'!C13)","v":4.4345441299254764},{"$f":"('Gas Inputs'!G13+'Gas Inputs'!I13+'Gas Inputs'!E13)/('Gas Inputs'!B13+'Gas Inputs'!D13)","v":1.7391103155858934},{"$f":"('Gas Inputs'!H13+'Gas Inputs'!J13)/('Gas Inputs'!B13+'Gas Inputs'!D13)","v":2.4819604819755194}]
["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.5191105628966857},{"$f":"'Gas Inputs'!G14/('Gas Inputs'!B14+'Gas Inputs'!C14+'Gas Inputs'!F14)","v":0.81292597432051428},{"$f":"'Gas Inputs'!G14/('Gas Inputs'!B14+'Gas Inputs'!C14)","v":4.2243756689141021},{"$f":"('Gas Inputs'!G14+'Gas Inputs'!I14+'Gas Inputs'!E14)/('Gas Inputs'!B14+'Gas Inputs'!D14)","v":2.0153282413810114},{"$f":"('Gas Inputs'!H14+'Gas Inputs'!J14)/('Gas Inputs'!B14+'Gas Inputs'!D14)","v":2.5051712514967508}]

{"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"]
["2017 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":51240.17},{"$f":"'Electric Inputs'!C9+'Gas Inputs'!C9","v":588146.82999999996},{"$f":"'Electric Inputs'!D9+'Gas Inputs'!D9","v":1596969.5999999999},{"$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":83611.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":36929.579969756443}]
["Residential Appliance Recycling",{"$f":"'Electric Inputs'!B11","v":1999.5},{"$f":"'Electric Inputs'!C11","v":5632.5},{"$f":"'Electric Inputs'!D11","v":3956.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":14276.31},{"$f":"'Electric Inputs'!C12+'Gas Inputs'!C11","v":142929.07999999999},{"$f":"'Electric Inputs'!D12+'Gas Inputs'!D11","v":624265.84000000008},{"$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":13850.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":18002.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":182981.054},{"$f":"SUM(C9:C14)","v":1026560.3359999999},2750767.8959999997,{"$f":"SUM(E9:E14)","v":131200},4962523.7709308043,5145576.1769289365,6700216.9876579531,{"$f":"SUM(I9:I14)","v":570630.47492330649},521975.0684237979]

{"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"]
["2017 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",13242.169999999998,68938.83,224319.4,131200,195672.32935498905,266638.16740585654,354448.49010167352,0,35444.858180329065]
["Residential Audit",522.38999999999987,1496.6100000000001,3938.33,0,3768.2147410030675,3571.7749845709923,4796.4772967174085,632.35622365137397,479.6468629834489]
["Residential Appliance Recycling",1999.5,5632.5,3956.5,0,13179.368320544165,10133.440368991929,10902.65349790053,0,1090.2660670926587]
["Nonresidential Equipment",4100.8099999999995,15453.58,42331.14,0,165638.40483151394,223518.81854328886,286492.90442218754,0,28649.286926520297]
["Small Commercial Energy Audit",932.30400000000009,1273.6959999999999,1271.2959999999998,0,919.91887471314715,1144.8603457464844,1370.9368182398059,1174.0165265965497,137.08900900094216]
["Nonresidential Custom",9016,7885,84053.03,0,55112.846550426708,82264.998490057769,113499.77888480673,0,11558.462490267426]
["Total",{"$f":"SUM(B9:B14)","v":29813.173999999995},100680.216,359869.696,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"]
["2017 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",37998,519208,1372650.2,0,2820418.2647764022,2804734.4747802494,3561774.5343669876,50046.199647877962,267095.62863031751]
["Residential Audit",83089.440000000002,224199.56,332930.14999999997,0,373391.24181133707,362664.71285972046,485999.10809030652,350993.49176617048,36449.933106772995]
["Nonresidential Equipment",10175.5,127475.5,581934.70000000007,0,1142918.6680463194,1195158.3448262655,1629772.6240254927,16242.327915088737,122232.93838879772]
["Small Commercial Energy Audit",12918.14,32764.86,32764.86,0,63892.012057297165,57304.551132044791,67367.21019283928,151542.08284392135,5052.5411784127964]
["Nonresidential Custom",8986.8000000000029,22232.199999999997,70618.290000000008,0,127612.50156625794,138442.03319214346,183792.26996080152,0,13784.417583303095]
["Total",{"$f":"SUM(B9:B13)","v":153167.88},925880.12,2390898.1999999997,0,4528232.6882576132,4558304.1167904241,5928705.7466364279,568824.10217305855,444615.45888760418]