{"text_format":"1","workbook":"xlsx","n_sheets":29,"sheets":["Cover Sheet","Date Input","Data Input","Sch 1","Sch 2","Sch 3","Sch 4 p1","Sch 4 p2","Sch 4 p3","Sch 5 p1","Sch 5 p2","Sch 5 p3","Sch 5 p4","Sch 6","Sch 7 ","Ex2, pg 1","Ex 3-Authorized Return","Ex 4-Earnings Test","Exhibit 4a","FCA_A8A","FCA_A8B","FCA_A8C","FCA_A10A","FCA_A10B","FCA_A10C","FCA_A11A","FCA_A11B","FCA_A11C","Change Calculation"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":880,"comments":2,"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":"Cover Sheet","index":0,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[null,null,"AES Indiana URT Repeal"]
[]
[null,null,"FAC-135 Schedules NOI Updated Authorized Level"]

{"sheet":"Date Input","index":1,"n_rows":52,"n_cols":24,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
[]
["Billing Cycle","June","2022","enter as labels"]
[null,"July","2022"]
[null,"August","2022"]
[null,"June, July, and August 2022"]
[]
[null,"August 2022"]
[]
["Months to be Reconciled","November","2021","enter as labels"]
[null,"December","2021"]
[null,"January","2022"]
[null,"November, December 2021, and January 2022"]
[]
[null,"January 2022"]
[]
[]
[null,"2021-11-16"]
[null,{"$f":"B17+31","v":"2021-12-17"}]
[null,{"$f":"B18+31","v":"2022-01-17"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"`"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"NOW()","v":"2022-05-04T12:30:11.360"}]

{"sheet":"Data Input","index":2,"n_rows":234,"n_cols":24,"rows_kept":234,"cut":false,"hidden":false,"merged":[]}
[null,null,"use for",null,null,null,null,null,null,{"$f":"'Date Input'!$B$9","v":"November"},null,{"$f":"+'Date Input'!$B$10","v":"December"},null,{"$f":"+'Date Input'!$B$11","v":"January"}]
["2021 Loss Percentage (Change in January)",4.8149999999999998E-2,"November",null,null,null,null,null,null,{"$f":"'Date Input'!$B$9","v":"November"},null,{"$f":"+'Date Input'!$B$10","v":"December"},null,{"$f":"+'Date Input'!$B$11","v":"January"}]
["2021 Loss Percentage (Change in January)",4.8149999999999998E-2,"December",null,null,"Residential Sales - Kwh",null,null,null,327224,null,459406,null,552387]
["2022 Loss Percentage (Change in January)",4.6550000000000001E-2,"January",null,null,"Commercial Sales - Kwh",null,null,null,118722,null,147221,null,164049]
[null,"  ",null,null,null,"Industrial Sales - Kwh",null,null,null,453048,null,475724,null,491612]
[null,null,null,null,null,"EV Public Charging Stations - Kwh",null,null,null,3,null,3,null,3]
["Cause No. 38703-FAC135",null,null,null,null,"Lighting",null,null,null,5958,null,6380,null,6238]
[]
["FAC 134 Estimates"]
[null,null,null,null,null," "]
["MWH",{"$f":"+'Date Input'!B2","v":"June"},{"$f":"+'Date Input'!B3","v":"July"},{"$f":"+'Date Input'!B4","v":"August"},null,"Total Kwh Sales",null,null,null,904955,null,1088734,null,1214289]
["Steam Generation",637289,857258,836652]
["Gas Generation",605096,719440,683319,null,"Cost of Fuel Billed - Dollars"]
["Oil Generation",0,0,0,null,"   residential",null,null,null,-10374,null,2457142,null,2954441]
["Purchased Power",null,null,null,null,"   commercial",null,null,null,-3835,null,785318,null,880326]
["   Wind Purchase Power Agreement Purchases",48142,37263,40692,null,"   industrial",null,null,null,-16819,null,2399891,null,2673200]
["   Non-Wind PPA Market Purchases",52391,14912,17294,null,"   ev public charging stations",null,null,null,-0.1,null,17.170000000000002,null,0]
["   Purchased Power Other Than MISO",18112,17322,16407,null,"   lighting",null,null,null,-127,null,38637,null,37549]
["Inter-System Sales",149162,260380,267629]
["Energy Losses & Co. Use ",39132,44749,42843,null,null,null,"Cause #",null,"Deferred Fuel Amort- 132",null,"Deferred Fuel Amort - 133",null,"NOI Credit Amort","TOTAL"]
["Control Area Losses",16648,19037,18226,null,{"$f":"+'Date Input'!B9","v":"November"},null,"38703-FAC132",null,-2164574.83,null,0,null,1110262.33,{"$f":"N21+J21+L21","v":-1054312.5}]
["Non-Jurisdictional ",null,null,null,null,{"$f":"+'Date Input'!B10","v":"December"},null,"38703-FAC132/FAC133",null,-2164574.83,null,-2280603.67,null,0,{"$f":"N22+J22+L22","v":-4445178.5}]
[null,null,null,null,null,{"$f":"+'Date Input'!B11","v":"January"},null,"38703-FAC132/FAC133",null,-2164574.83,null,-2280603.67,null,0,-4445178.5]
["Total",{"$f":"B12+B13+B14+B15-B19-B20-B21+B16+B17+B18","v":1156088},{"$f":"C12+C13+C14+C15-C19-C20-C21+C16+C17+C18","v":1322029},{"$f":"D12+D13+D14+D15-D19-D20-D21+D16+D17+D18","v":1265666},null,null,null,null,null,{"$f":"SUM(J21:J23)","v":-6493724.4900000002},null,{"$f":"SUM(L21:L23)","v":-4561207.34},null,{"$f":"SUM(N21:N23)","v":1110262.33},{"$f":"N24+J24+L24","v":-9944669.5}]
[null,null,null,null,null,null,null,"Company",null,"Battery",null,"Trans",null,"Excess over","Lakefield"]
[null,null,null,null,null,null,null,"Use",null,"Storage",null,"Losses",null,"Benchmark","Credit"]
[null,null,null,null,null,{"$f":"+F21","v":"November"},null,1548,null,92,null,0,null,0,71]
["FUEL COST ($)",null,null,null,null,{"$f":"+F22","v":"December"},null,1819,null,56,null,40794.37399575115,null,0,10114.02]
["Steam Generation",16871101,20961184,19662899,null,{"$f":"+F23","v":"January"},null,2235,null,54,null,212251,null,0,267374]
["Gas Generation",21421883,27389521,25405189]
["Oil Generation",0,0,0,null,null,null,null,null,"FAC 132",null,"FAC133",null,"FAC133"]
["Purchased Power",null,null,null,null,"Forecast",null,null,null,{"$f":"+J2","v":"November"},null,{"$f":"+L2","v":"December"},null,{"$f":"+N2","v":"January"}]
["   Wind Purchase Power Agreement Purchases",4940837,3831018,3499511,null,"Steam Generation",null,null,null,795413,null,940033,null,967010]
["   Non-Wind PPA Market Purchases",2392839,626766,658357,null,"Nuclear Generation",null,null,null,0,null,0,null,0]
["   Purchased Power Other Than MISO",3010839,2819645,2728627,null,"Hydro Generation",null,null,null,0,null,0,null,0]
["Other MISO Costs",1765347,2018739,1932675,null,"Other Generation - Internal Combustion",null,null,null,0,null,0,null,0]
["Control Area Losses (R10 X R35)",487424,562813,521402,null,"Gas Combustion Turbine",null,null,null,378968,null,449911,null,593865]
["Inter-System Sales",4367277,7697815,7656369,null,"Purchases through MISO"]
["Lakefield Wind Wholesale Margin Credit",242955,279703,230564,null,"   Wind Purchase Power Agreement Purchases",null,null,null,72753,null,73403,null,76890]
["Non-Jurisdictional",0,0,0,null,"   Non-Wind PPA Market Purchases",null,null,null,80527,null,65136,null,65912]
[null,null,null,null,null,"   Other",null,null,null,0,null,0,null,0]
["Total",{"$f":"B29+B30+B31+B32+B36-B37-B38-B39+B33+B34+B35","v":45305190},{"$f":"C29+C30+C31+C32+C36-C37-C38-C39+C33+C34+C35","v":49106542},{"$f":"D29+D30+D31+D32+D36-D37-D38-D39+D33+D34+D35","v":45478923},null,"Purchased Power other than MISO",null,null,null,11290,null,5287,null,5894]
[null,null,null,null,null,"LESS:"]
[null,null,null,null,null," Energy Losses and Company Use",null,null,null,53512,null,65277,null,70664]
["$/MWH Cost",null,null,null,null," Inter-System Sales through MISO",null,null,null,294402,null,259559,null,330195]
["Steam Generation",{"$f":"ROUND(B29/B12,2)","v":26.47},24.45,23.5,null," Inter-System Sales other than MISO",null,null,null,0,null,0,null,0,null,null,null,null,null,null,null,null,null,"`"]
["Gas Generation",35.4,38.07,37.18,null," Non-Jurisdictional Retail Sales",null,null,null,0,null,0,null,0]
["Oil Generation",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Purchased Power",{"$f":"ROUND((B33+B34+B35)/(B16+B17+B18),2)","v":87.19},{"$f":"ROUND((C33+C34+C35)/(C16+C17+C18),2)","v":104.72},{"$f":"ROUND((D33+D34+D35)/(D16+D17+D18),2)","v":92.57},null,"Sales (S)",null,null,null,{"$f":"SUM(J33:J42)-SUM(J44:J47)","v":991037},null,{"$f":"SUM(L33:L42)-SUM(L44:L47)","v":1208934},null,{"$f":"SUM(N33:N42)-SUM(N44:N47)","v":1308712}]
["Control Area Losses",{"$f":"ROUND(B37/B21,2)","v":29.28},{"$f":"ROUND(C37/C21,2)","v":29.56},{"$f":"ROUND(D37/D21,2)","v":28.61}]
["Inter-System Sales",{"$f":"ROUND(B38/B19,2)","v":29.28},{"$f":"ROUND(C38/C19,2)","v":29.56},{"$f":"ROUND(D38/D19,2)","v":28.61},null,"Fuel Cost"]
["Non-Jurisdictional ",{"$f":"ROUND(B40/B22,2)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(C40/C22,2)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(D40/D22,2)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,"Steam Generation",null,null,null,16027105,null,19377649,null,20157249]
["Total",{"$f":"ROUND(B42/B24,2)","v":39.19},{"$f":"ROUND(C42/C24,2)","v":37.14},{"$f":"ROUND(D42/D24,2)","v":35.93},null,"Nuclear Generation",null,null,null,0,null,0,null,0]
[null,null,null,null,null,"Hydro Generation",null,null,null,0,null,0,null,0]
[null,null,null,null,null,"Other Generation - Internal Combustion",null,null,null,0,null,0,null,0]
[null,null,null,null,null,"Gas Combustion Turbine",null,null,null,9276128,null,15790027,null,22604674]
[null,"State Tax ",null,null,null,"Purchases through MISO"]
["Forecast Months","Rate",null,null,null,"   Wind Purchase Power Agreement Purchases",null,null,null,7927735,null,8101072,null,7923164]
["Cause No. 38703-FAC96",8.2500000000000004E-2,null,null,null,"   Non-Wind PPA Market Purchases",null,null,null,1908695,null,1851402,null,3075250]
["Cause No. 38703-FAC97",7.9200000000000007E-2,null,null,null,"   Other",null,null,null,0,null,0,null,0]
["Cause No. 38703-FAC98",7.7499999999999999E-2,null,null,null,"MISO Components of Cost of Fuel",null,null,null,1246724,null,1496660,null,1620185]
["Cause No. 38703-FAC99",7.7499999999999999E-2,null,null,null,"Purchased Power other than MISO",null,null,null,1863671,null,875857,null,1004936]
["Cause No. 38703-FAC100",7.7499999999999999E-2]
["Cause No. 38703-FAC101",7.4200000000000002E-2,null,null,null,"LESS:"]
["Cause No. 38703-FAC102",7.2499999999999995E-2]
["Cause No. 38703-FAC103",7.2499999999999995E-2,null,null,null," Inter-System Sales through MISO",null,null,null,5925787,null,6268405,null,8657771]
["Cause No. 38703-FAC104",7.2499999999999995E-2,null,null,null," Inter-System Sales other than MISO",null,null,null,0,null,0,0,0]
["Cause No. 38703-FAC105",6.83E-2,null,null,null," Non-Jurisdictional Retail Sales",null,null,null,0,null,0,0,0]
["Cause No. 38703-FAC106",6.7500000000000004E-2,null,null,null,"Transmission Losses",null,null,null,287249,null,420422,null,494131]
["Cause No. 38703-FAC107",6.7500000000000004E-2,null,null,null,"Lakefield PPA Adjustment",null,null,null,209181,null,350525,null,642380]
["Cause No. 38703-FAC108",6.7500000000000004E-2,null,null,null,"Purchased Power in Excess",null,null,null,0,null,0,null,0]
["Cause No. 38703-FAC109",6.5799999999999997E-2]
["Cause No. 38703-FAC110",6.5000000000000002E-2,null,null,null,"Total Fuel Costs (F)",null,null,null,{"$f":"SUM(J53:J63)-SUM(J66:J72)","v":31827841},null,{"$f":"SUM(L53:L63)-SUM(L66:L72)","v":40453315},null,{"$f":"SUM(N53:N63)-SUM(N66:N72)","v":46591176}]
["Cause No. 38703-FAC111",6.3750000000000001E-2]
["Cause No. 38703-FAC112",6.3750000000000001E-2,null,null,null,"F / S (Mills/kWh)",null,null,null,{"$f":"IF(J49=0,0,ROUND(J74/J49,3))","v":32.116},null,{"$f":"IF(L49=0,0,ROUND(L74/L49,3))","v":33.462000000000003},null,{"$f":"IF(N49=0,0,ROUND(N74/N49,3))","v":35.600999999999999}]
["Cause No. 38703-FAC113",6.2080000000000003E-2]
["Cause No. 38703-FAC114",6.1249999999999999E-2]
["Cause No. 38703-FAC115",6.1249999999999999E-2]
["Cause No. 38703-FAC116",6.1249999999999999E-2]
["Cause No. 38703-FAC117",5.9580000000000001E-2]
["Cause No. 38703-FAC118",5.8749999999999997E-2]
["Cause No. 38703-FAC119",5.8749999999999997E-2]
["Cause No. 38703-FAC120",5.8749999999999997E-2]
["Cause No. 38703-FAC121",5.7079999999999999E-2]
["Cause No. 38703-FAC122",5.6250000000000001E-2]
["Cause No. 38703-FAC123",5.6250000000000001E-2]
["Cause No. 38703-FAC124",5.8749999999999997E-2]
["Cause No. 38703-FAC125",5.5419999999999997E-2]
["Cause No. 38703-FAC126",5.3749999999999999E-2]
["Cause No. 38703-FAC127",5.3749999999999999E-2]
["Cause No. 38703-FAC128",5.3749999999999999E-2]
["Cause No. 38703-FAC129",5.1749999999999997E-2]
["Cause No. 38703-FAC130",5.0750000000000003E-2]
["Cause No. 38703-FAC131",5.0750000000000003E-2]
["Cause No. 38703-FAC132",5.0750000000000003E-2]
["Cause No. 38703-FAC133",4.9579999999999999E-2]
["Cause No. 38703-FAC134",4.9000000000000002E-2]
["Cause No. 38703-FAC135",4.9000000000000002E-2]
[]
[]
[null,"State Tax "]
["Actual (Trueup) Months","Rate"]
["Revenues for February, 2012",8.2500000000000004E-2]
["Revenues for March, 2012",8.2500000000000004E-2]
["Revenues for April, 2012",8.2500000000000004E-2]
["Revenues for May, 2012",8.2500000000000004E-2]
["Revenues for June, 2012",8.2500000000000004E-2]
["Revenues for July, 2012",8.2500000000000004E-2]
["Revenues for August, 2012",8.2500000000000004E-2]
["Revenues for September, 2012",8.2500000000000004E-2]
["Revenues for October, 2012",8.2500000000000004E-2]
["Revenues for November, 2012",8.2500000000000004E-2]
["Revenues for December, 2012",8.2500000000000004E-2]
["Revenues for January, 2013",7.7499999999999999E-2]
["Revenues for February, 2013",7.7499999999999999E-2]
["Revenues for March, 2013",7.7499999999999999E-2]
["Revenues for April, 2013",7.7499999999999999E-2]
["Revenues for May, 2013",7.7499999999999999E-2]
["Revenues for June, 2013",7.7499999999999999E-2]
["Revenues for July, 2013",7.7499999999999999E-2]
["Revenues for August, 2013",7.7499999999999999E-2]
["Revenues for September, 2013",7.7499999999999999E-2]
["Revenues for October, 2013",7.7499999999999999E-2]
["Revenues for November, 2013",7.7499999999999999E-2]
["Revenues for December, 2013",7.7499999999999999E-2]
["Revenues for January, 2014",7.2499999999999995E-2]
["Revenues for February, 2014",7.2499999999999995E-2]
["Revenues for March, 2014",7.2499999999999995E-2]
["Revenues for April, 2014",7.2499999999999995E-2]
["Revenues for May, 2014",7.2499999999999995E-2]
["Revenues for June, 2014",7.2499999999999995E-2]
["Revenues for July, 2014",7.2499999999999995E-2]
["Revenues for August, 2014",7.2499999999999995E-2]
["Revenues for September, 2014",7.2499999999999995E-2]
["Revenues for October, 2014",7.2499999999999995E-2]
["Revenues for November, 2014",7.2499999999999995E-2]
["Revenues for December, 2014",7.2499999999999995E-2]
["Revenues for January, 2015",6.7500000000000004E-2]
["Revenues for February, 2015",6.7500000000000004E-2]
["Revenues for March, 2015",6.7500000000000004E-2]
["Revenues for April, 2015",6.7500000000000004E-2]
["Revenues for May, 2015",6.7500000000000004E-2]
["Revenues for June, 2015",6.7500000000000004E-2]
["Revenues for July, 2015",6.7500000000000004E-2]
["Revenues for August, 2015",6.7500000000000004E-2]
["Revenues for September, 2015",6.7500000000000004E-2]
["Revenues for October, 2015",6.7500000000000004E-2]
["Revenues for November, 2015",6.7500000000000004E-2]
["Revenues for December, 2015",6.7500000000000004E-2]
["Revenues for January, 2016",6.3750000000000001E-2]
["Revenues for February, 2016",6.3750000000000001E-2]
["Revenues for March, 2016",6.3750000000000001E-2]
["Revenues for April, 2016",6.3750000000000001E-2]
["Revenues for May, 2016",6.3750000000000001E-2]
["Revenues for June, 2016",6.3750000000000001E-2]
["Revenues for July, 2016",6.3750000000000001E-2]
["Revenues for August, 2016",6.3750000000000001E-2]
["Revenues for September, 2016",6.3750000000000001E-2]
["Revenues for October, 2016",6.3750000000000001E-2]
["Revenues for November, 2016",6.3750000000000001E-2]
["Revenues for December, 2016",6.3750000000000001E-2]
["Revenues for January, 2017",6.1249999999999999E-2]
["Revenues for February, 2017",6.1249999999999999E-2]
["Revenues for March, 2017",6.1249999999999999E-2]
["Revenues for April, 2017",6.1249999999999999E-2]
["Revenues for May, 2017",6.1249999999999999E-2]
["Revenues for June, 2017",6.1249999999999999E-2]
["Revenues for July, 2017",6.1249999999999999E-2]
["Revenues for August, 2017",6.1249999999999999E-2]
["Revenues for September, 2017",6.1249999999999999E-2]
["Revenues for October, 2017",6.1249999999999999E-2]
["Revenues for November, 2017",6.1249999999999999E-2]
["Revenues for December, 2017",6.1249999999999999E-2]
["Revenues for January, 2018",5.8749999999999997E-2]
["Revenues for February, 2018",5.8749999999999997E-2]
["Revenues for March, 2018",5.8749999999999997E-2]
["Revenues for April, 2018",5.8749999999999997E-2]
["Revenues for May, 2018",5.8749999999999997E-2]
["Revenues for June, 2018",5.8749999999999997E-2]
["Revenues for July, 2018",5.8749999999999997E-2]
["Revenues for August, 2018",5.8749999999999997E-2]
["Revenues for September, 2018",5.8749999999999997E-2]
["Revenues for October, 2018",5.8749999999999997E-2]
["Revenues for November, 2018",5.8749999999999997E-2]
["Revenues for December, 2018",5.8749999999999997E-2]
["Revenues for January, 2019",5.6250000000000001E-2]
["Revenues for February, 2019",5.6250000000000001E-2]
["Revenues for March, 2019",5.6250000000000001E-2]
["Revenues for April, 2019",5.6250000000000001E-2]
["Revenues for May, 2019",5.6250000000000001E-2]
["Revenues for June, 2019",5.6250000000000001E-2]
["Revenues for July, 2019",5.6250000000000001E-2]
["Revenues for August, 2019",5.6250000000000001E-2]
["Revenues for September, 2019",5.6250000000000001E-2]
["Revenues for October, 2019",5.6250000000000001E-2]
["Revenues for November, 2019",5.6250000000000001E-2]
["Revenues for December, 2019",5.6250000000000001E-2]
["Revenues for January, 2020",5.3749999999999999E-2]
["Revenues for February, 2020",5.3749999999999999E-2]
["Revenues for March, 2020",5.3749999999999999E-2]
["Revenues for April, 2020",5.3749999999999999E-2]
["Revenues for May, 2020",5.3749999999999999E-2]
["Revenues for June, 2020",5.3749999999999999E-2]
["Revenues for July, 2020",5.3749999999999999E-2]
["Revenues for August, 2020",5.3749999999999999E-2]
["Revenues for September, 2020",5.3749999999999999E-2]
["Revenues for October, 2020",5.3749999999999999E-2]
["Revenues for November, 2020",5.3749999999999999E-2]
["Revenues for December, 2020",5.3749999999999999E-2]
["Revenues for January, 2021",5.0750000000000003E-2]
["Revenues for February, 2021",5.0750000000000003E-2]
["Revenues for March, 2021",5.0750000000000003E-2]
["Revenues for April, 2021",5.0750000000000003E-2]
["Revenues for May, 2021",5.0750000000000003E-2]
["Revenues for June, 2021",5.0750000000000003E-2]
["Revenues for July, 2021",5.0750000000000003E-2]
["Revenues for August, 2021",5.0750000000000003E-2]
["Revenues for September, 2021",5.0750000000000003E-2]
["Revenues for October, 2021",5.0750000000000003E-2]
["Revenues for November, 2021",5.0750000000000003E-2]
["Revenues for December, 2021",5.0750000000000003E-2]
["Revenues for January, 2022",4.9000000000000002E-2]
["Revenues for February, 2022",4.9000000000000002E-2]
["Revenues for March, 2022",4.9000000000000002E-2]
["Revenues for April, 2022",4.9000000000000002E-2]
["Revenues for May, 2022",4.9000000000000002E-2]
["Revenues for June, 2022",4.9000000000000002E-2]
["Revenues for July, 2022",4.9000000000000002E-2]
["Revenues for August, 2022",4.9000000000000002E-2]
["Revenues for September, 2022",4.9000000000000002E-2]
["Revenues for October, 2022",4.9000000000000002E-2]
["Revenues for November, 2022",4.9000000000000002E-2]
["Revenues for December, 2022",4.9000000000000002E-2]

{"sheet":"Sch 1","index":3,"n_rows":86,"n_cols":24,"rows_kept":86,"cut":false,"hidden":false,"merged":[[6,0,6,12],[5,0,5,12],[3,0,3,12],[4,0,4,12]]}
[{"$f":"'Data Input'!A7","v":"Cause No. 38703-FAC135"},null,null,null,null,null,null,null,null,null,null,"Applicant's Attachment NHC-1"]
[null,null,null,null,null,null,null,null,null,null,null," Schedule 1-Updated"]
[null,null,null,null,null,null,null,null,null," ",null,"Page 1 of 1"," "]
["AES INDIANA"]
["Determination of Fuel Cost Adjustment"]
[{"$f":"\"Beginning with \" &'Date Input'!B7&\" Based on the Estimated\"","v":"Beginning with August 2022 Based on the Estimated"}]
[{"$f":"\"Three Months Average of \" &'Date Input'!B5","v":"Three Months Average of June, July, and August 2022"}]
[null,null,null,"(A)",null,"(B)",null,"(C)",null,"(D)",null,"(E)"]
["     Line       ",null,null,null,null,null,null,null,null,null,null,"Estimated","     Line       "]
["No.","     Description        ",null,"Estimated Month of:",null,null,null,null,null,null,null,"Three Month","No."]
[null,"  kWh Source (000's)",null,{"$f":"'Date Input'!B2","v":"June"},null,{"$f":"'Date Input'!B3","v":"July"},null,{"$f":"'Date Input'!B4","v":"August"},null,"Total",null,"Average"]
[1,"Coal and Oil Generation",null,{"$f":"+'Data Input'!B12","v":637289},null,{"$f":"+'Data Input'!C12","v":857258},null,{"$f":"+'Data Input'!D12","v":836652},null,{"$f":"D12+F12+H12","v":2331199},null,{"$f":"ROUND(J12/3,0)","v":777066},{"$f":"A12","v":1}]
[2,"Nuclear Generation",null,0,null,0,null,0,null,{"$f":"D13+F13+H13","v":0},null,{"$f":"ROUND(J13/3,0)","v":0},2]
[3,"Hydro Generation",null,0,null,0,null,0,null,{"$f":"D14+F14+H14","v":0},null,0,3]
[4,"Other Generation - Internal Combustion",null,{"$f":"+'Data Input'!B14","v":0},null,{"$f":"+'Data Input'!C14","v":0},null,{"$f":"+'Data Input'!D14","v":0},null,{"$f":"D15+F15+H15","v":0},null,0,4]
[5,"Gas Generation",null,{"$f":"+'Data Input'!B13","v":605096},null,{"$f":"+'Data Input'!C13","v":719440},null,{"$f":"+'Data Input'!D13","v":683319},null,{"$f":"D16+F16+H16","v":2007855},null,{"$f":"ROUND(J16/3,0)","v":669285},5]
[null,"Purchases through MISO:"]
[6,"   Wind Purchase Power Agreement Purchases",null,{"$f":"'Sch 2'!D16","v":48142},null,{"$f":"'Sch 2'!D27","v":37263},null,{"$f":"'Sch 2'!D38","v":40692},null,{"$f":"D18+F18+H18","v":126097},null,{"$f":"ROUND(J18/3,0)","v":42032},6]
[7,"   Non-Wind PPA Market Purchases",null,{"$f":"'Sch 2'!D17","v":52391},null,{"$f":"'Sch 2'!D28","v":14912},null,{"$f":"'Sch 2'!D39","v":17294},null,84597,null,{"$f":"ROUND(J19/3,0)","v":28199},7]
[8,"   Other",null,{"$f":"'Sch 2'!D18","v":0},null,{"$f":"'Sch 2'!D29","v":0},null,{"$f":"'Sch 2'!D40","v":0},null,0,null,{"$f":"ROUND(J20/3,0)","v":0},8]
[9,"Purchased Power other than MISO",null,{"$f":"'Sch 2'!D20","v":18112},null,{"$f":"'Sch 2'!D31","v":17322},null,{"$f":"'Sch 2'!D42","v":16407},null,51841,null,17280,9]
[null,"LESS:"]
[{"$f":"A21+1","v":10},"   Energy Losses and Company Use",null,{"$f":"+'Data Input'!B20+'Data Input'!B21","v":55780},null,{"$f":"+'Data Input'!C20+'Data Input'!C21","v":63786},null,{"$f":"+'Data Input'!D20+'Data Input'!D21","v":61069},null,180635,null,60212,{"$f":"A23","v":10}]
[{"$f":"A23+1","v":11},"   Inter-System Sales through MISO",null,{"$f":"+'Data Input'!B19","v":149162},null,{"$f":"+'Data Input'!C19","v":260380},null,{"$f":"+'Data Input'!D19","v":267629},null,677171,null,225724,{"$f":"A24","v":11}]
[{"$f":"A24+1","v":12},"   Inter-System Sales other than MISO",null,{"$f":"'Sch 3'!D18","v":0},null,{"$f":"'Sch 3'!F18","v":0},null,0,null,0,null,0,{"$f":"A25","v":12}]
[{"$f":"A25+1","v":13},"   Non-Jurisdictional Retail Sales",null,{"$f":"+'Data Input'!B22","v":0},null,{"$f":"+'Data Input'!C22","v":0},null,{"$f":"+'Data Input'!D22","v":0},null,{"$f":"D26+F26+H26","v":0},null,{"$f":"ROUND(J26/3,0)","v":0},{"$f":"A26","v":13}]
[{"$f":"A26+1","v":14},"Sales  (S)",null,{"$f":"SUM(D12:D21)-SUM(D23:D26)","v":1156088},null,{"$f":"SUM(F12:F21)-SUM(F23:F26)","v":1322029},null,{"$f":"SUM(H12:H21)-SUM(H23:H26)","v":1265666},null,{"$f":"SUM(J12:J21)-SUM(J23:J26)","v":3743783},null,{"$f":"SUM(L12:L21)-SUM(L23:L26)","v":1247926},{"$f":"A27","v":14}]
[]
[null,"  Fuel Cost  ($)"]
[{"$f":"A27+1","v":15},"Coal and Oil Generation",null,{"$f":"+'Data Input'!B29","v":16871101},null,{"$f":"+'Data Input'!C29","v":20961184},null,{"$f":"+'Data Input'!D29","v":19662899},null,{"$f":"D30+F30+H30","v":57495184},null,{"$f":"ROUND(J30/3,0)","v":19165061},{"$f":"A30","v":15}]
[{"$f":"A30+1","v":16},"Nuclear Generation",null,0,null,0,null,0,null,0,null,0,16]
[17,"Hydro Generation",null,0,null,0,null,0,null,0,null,0,17]
[18,"Other Generation - Internal Combustion",null,{"$f":"+'Data Input'!B31","v":0},null,{"$f":"+'Data Input'!C31","v":0},null,{"$f":"+'Data Input'!D31","v":0},null,0,null,0,18]
[19,"Gas Generation",null,{"$f":"+'Data Input'!B30","v":21421883},null,{"$f":"+'Data Input'!C30","v":27389521},null,{"$f":"+'Data Input'!D30","v":25405189},null,74216593,null,24738864,19]
[null,"Purchases through MISO:"]
[20,"   Wind Purchase Power Agreement Purchases",null,{"$f":"'Sch 2'!G16","v":4940837},null,{"$f":"'Sch 2'!G27","v":3831018},null,{"$f":"'Sch 2'!G38","v":3499511},null,12271366,null,{"$f":"ROUND(J36/3,0)","v":4090455},20]
[21,"   Non-Wind PPA Market Purchases",null,{"$f":"'Sch 2'!G17","v":2392839},null,{"$f":"'Sch 2'!G28","v":626766},null,{"$f":"'Sch 2'!G39","v":658357},null,3677962,null,{"$f":"ROUND(J37/3,0)","v":1225987},21]
[22,"   Other",null,{"$f":"'Sch 2'!G18","v":0},null,{"$f":"'Sch 2'!G29","v":0},null,{"$f":"'Sch 2'!G40","v":0},null,0,null,{"$f":"ROUND(J38/3,0)","v":0},22]
[23,"MISO Components of Cost of Fuel",null,{"$f":"+'Data Input'!B36","v":1765347},null,{"$f":"+'Data Input'!C36","v":2018739},null,{"$f":"+'Data Input'!D36","v":1932675},null,5716761,null,1905587,23]
[24,"Purchased Power other than MISO",null,{"$f":"'Sch 2'!G20","v":3010839},null,{"$f":"'Sch 2'!G31","v":2819645},null,{"$f":"'Sch 2'!G42","v":2728627},null,8559111,null,2853037,24]
[null,"Less:"]
[{"$f":"A40+1","v":25},"   Inter-System Sales through MISO",null,{"$f":"'Sch 3'!F17","v":4367277},null,{"$f":"'Sch 3'!F25","v":7697815},null,{"$f":"'Sch 3'!F33","v":7656369},null,{"$f":"D42+F42+H42","v":19721461},null,{"$f":"ROUND(J42/3,0)","v":6573820},25]
[{"$f":"A42+1","v":26},"   Inter-System Sales other than MISO",null,{"$f":"'Sch 3'!F19","v":0},{"$f":"'Sch 3'!G19","v":0},{"$f":"'Sch 3'!F27","v":0},{"$f":"'Sch 3'!I19","v":0},{"$f":"'Sch 3'!F35","v":0},null,{"$f":"D43+F43+H43","v":0},null,{"$f":"ROUND(J43/3,0)","v":0},26]
[{"$f":"A43+1","v":27},"   Non-Jurisdictional Retail Sales",null,{"$f":"'Sch 3'!F20","v":0},{"$f":"'Sch 3'!G20","v":0},{"$f":"'Sch 3'!F28","v":0},{"$f":"'Sch 3'!I20","v":0},{"$f":"'Sch 3'!F36","v":0},null,{"$f":"D44+F44+H44","v":0},null,{"$f":"ROUND(J44/3,0)","v":0},27]
[{"$f":"A44+1","v":28},"   Transmission Losses",null,{"$f":"+'Data Input'!B37","v":487424},null,{"$f":"+'Data Input'!C37","v":562813},null,{"$f":"+'Data Input'!D37","v":521402},null,{"$f":"+D45+F45+H45","v":1571639},null,{"$f":"ROUND(+J45/3,0)","v":523880},28]
[{"$f":"A45+1","v":29},"   Lakefield PPA Adjustment",null,{"$f":"'Data Input'!B39","v":242955},null,{"$f":"'Data Input'!C39","v":279703},null,{"$f":"'Data Input'!D39","v":230564},null,{"$f":"+D46+F46+H46","v":753222},null,{"$f":"ROUND(+J46/3,0)","v":251074},29,null,null,null,null,null,null,null,null,null,null,"`"]
[{"$f":"A46+1","v":30},"Total Fuel Cost (F)",null,{"$f":"SUM(D30:D40)-SUM(D42:D46)","v":45305190},null,{"$f":"SUM(F29:F40)-SUM(F42:F46)","v":49106542},null,{"$f":"SUM(H29:H40)-SUM(H42:H46)","v":45478923},null,{"$f":"SUM(J29:J40)-SUM(J42:J46)","v":139890655},null,{"$f":"SUM(L29:L40)-SUM(L42:L46)","v":46630217},30]
[]
[{"$f":"A47+1","v":31},"F ÷ S (Line 30 ÷ Line 14) (Mills/kWh)",null,null,null,null,null,null,null,null,null,{"$f":"IF(L27=0,0,ROUND(L47/L27,3))","v":37.366},{"$f":"A49","v":31}]
[]
[32,"Reduction from Earnings Test",null,null,null,null,null,null,null,{"$f":"'Exhibit 4a'!G26","v":-282364.16000000003},null,null,32]
[33,"Reduction in Fuel Factor (Line 32 divided by estimated Indiana jurisdictional sales of",null,null,null,{"$f":"J27","v":3743783},"kWh (000's)",null,null,"(Mills/kWh)",null,{"$f":"+J51/F52","v":-7.5422149200421076E-2},33]
[]
[null,null,null,"Months to be Reconciled"]
[]
[]
[null,null,null,{"$f":"'Date Input'!$B$9","v":"November"},"            ",{"$f":"'Date Input'!$B$10","v":"December"},null,{"$f":"'Date Input'!$B$11","v":"January"},null,"Total"]
[{"$f":"A52+1","v":34},"Fuel Cost Variance",null,{"$f":"ROUND('Sch 4 p1'!T34,0)","v":36943851},null,{"$f":"ROUND('Sch 4 p2'!T35,0)","v":14618271},null,{"$f":"ROUND('Sch 4 p3'!T33,0)","v":12764694},null,{"$f":"D58+F58+H58","v":64326816},null,null,{"$f":"A58","v":34}]
[null,"(Mills/kWh)"]
[]
[{"$f":"A58+1","v":35},"Fuel Cost Variance - FAC 133",null,null,null,null,null,null,null,13683621.109999999,null,null,35]
[{"$f":"A61+1","v":36},"Fuel Cost Variance- FAC 133- 50% Collected",null,null,null,null,null,null,null,{"$f":"-J61*0.5","v":-6841810.5549999997},null,null,36]
[{"$f":"A62+1","v":37},"Fuel Cost Variance - FAC 134 (1)",null,null,null,null,null,null,null,32281690,null,null,37]
[38,"Subtotal Variances",null,null,null,null,null,null,null,{"$f":"SUM(J58:J63)-1","v":103450315.55500001},null,null,38]
[39,"Estimated Eagle Valley Outage Impact",null,null,null,null,null,null,null,-35168380,null,null,39]
[40,"Estimated Non Outage Related Fuel Cost Variances not yet Collected",null,null,null,null,null,null,null,{"$f":"+J64+J65","v":68281935.555000007},null,null,40]
[]
[{"$f":"A66+1","v":41},"TOTAL Fuel Cost Variance Included in this Filing- 50% (Mitigated by Collecting over FAC 135 and 136)",null,null,null,null,null,null,null,null,null,{"$f":"+J66*0.5","v":34140967.777500004},41]
[]
[]
[{"$f":"A68+1","v":42},"Variance Charge (Line 32 Total divided by estimated Indiana jurisdictional sales of",null,null,null,{"$f":"J27","v":3743783},"kWh (000's)",null,null,null,null,{"$f":"IF(F71=0,0,ROUND(L68/F71,3))","v":9.1189999999999998},42]
[{"$f":"A71+1","v":43},"Adjusted Fuel Cost Charge (Line 31 + Line 33)",null,null,null,null,null,null,null,null,null,{"$f":"ROUND(L49+L71+L52,3)","v":46.41},43]
[{"$f":"A72+1","v":44},"Less: Base Cost of Fuel Included in Rates",null,null,null,null,null,null,null,null,null,32.938000000000002,44]
[{"$f":"A73+1","v":45},"Fuel Cost Charge",null,null,null,null,null,null,null,null,null,{"$f":"ROUND(L72-L73,3)","v":13.472},45]
[{"$f":"A74+1","v":46},"Fuel Cost Charge Adjusted for Indiana Utility Receipts Tax (2)",null,null,null,null,null,null,null,null,null,{"$f":"ROUND(L$74/(1-(0/(1-(VLOOKUP(A1,'Data Input'!A60:B99,2,FALSE))))),3)","v":13.472},46]
[]
[null,"(1) As filed variances of $29,879,749 plus October tie line correction of $2,401,941"]
[null,{"$f":"CONCATENATE(\"(2) Line 45 Divided By (1-(1.40% URT Rate/(1-\",TEXT(VLOOKUP(A1,'Data Input'!A60:B99,2,FALSE),\"0.00000\"),\")))\")","v":"(2) Line 45 Divided By (1-(1.40% URT Rate/(1-0.04900)))"}]
[]
[]
[]
[]
[null,"Formula checks:"]
[null,"Should equal zero",{"$f":"SUM(D12:H21)-SUM(D23:H26)-J27","v":0},{"$f":"SUM(D30:H40)-SUM(D42:H46)-J47","v":0}]
[null,"Should be less than 1",{"$f":"+J27/3-L27","v":1.6666666667442769}]
[null,"Should equal zero",{"$f":"+L49+L71-L73-L74","v":7.4999999999997513E-2}]

{"sheet":"Sch 2","index":4,"n_rows":58,"n_cols":24,"rows_kept":58,"cut":false,"hidden":false,"merged":[]}
[{"$f":"'Data Input'!A7","v":"Cause No. 38703-FAC135"},null,null,null,null,null,null,null,"Applicant's Attachment NHC-1"]
[null,null,null,null,null,null,null,null,"Schedule 2"]
[null,null,null,null,null,null,null,null,"Page 1 of 1"]
[{"$f":"'Sch 1'!$A$4","v":"AES INDIANA"}]
["Determination of Net Energy Cost of Purchased Power"]
[{"$f":"\"For the Estimated Months of \" &'Date Input'!B5","v":"For the Estimated Months of June, July, and August 2022"}]
[]
[null,null,null,"kWh"]
["Line",null,null,"Purchased",null,null,null,null,"Line"]
["No","Supplier",null,"(000's)",null,null,"Energy *",null,"No"]
[null,null,null,"(A)",null,null,"(B)"]
[]
[null,{"$f":"'Sch 1'!D11","v":"June"}]
[]
[null,"Purchases through MISO:"]
[1,"   Wind Purchase Power Agreement Purchases",null,{"$f":"'Data Input'!B16","v":48142},null,null,{"$f":"'Data Input'!B33","v":4940837},null,{"$f":"A16","v":1}]
[2,"   Non-Wind PPA Market Purchases",null,{"$f":"'Data Input'!B17","v":52391},null,null,{"$f":"'Data Input'!B34","v":2392839},null,{"$f":"A17","v":2}]
[3,"   Other",null,0,null,null,0,null,{"$f":"A18","v":3}]
[4,"MISO Components of Cost of Fuel",null,0,null,null,{"$f":"ROUND(+'Data Input'!B36,0)","v":1765347},null,{"$f":"A19","v":4}]
[{"$f":"A19+1","v":5},"Purchased Power other than MISO",null,{"$f":"'Data Input'!B18","v":18112},null,null,{"$f":"'Data Input'!B35","v":3010839},null,{"$f":"A20","v":5}]
[]
[{"$f":"A20+1","v":6},"Total",null,{"$f":"SUM(D15:D20)","v":118645},null,null,{"$f":"SUM(G15:G20)","v":12109862},null,{"$f":"A22","v":6}]
[]
[null,{"$f":"'Sch 1'!F11","v":"July"}]
[]
[null,"Purchases through MISO:"]
[7,"   Wind Purchase Power Agreement Purchases",null,{"$f":"'Data Input'!C16","v":37263},null,null,{"$f":"'Data Input'!C33","v":3831018},null,{"$f":"A27","v":7}]
[8,"   Non-Wind PPA Market Purchases",null,{"$f":"'Data Input'!C17","v":14912},null,null,{"$f":"'Data Input'!C34","v":626766},null,{"$f":"A28","v":8}]
[9,"   Other",null,0,null,null,0,null,{"$f":"A29","v":9}]
[10,"MISO Components of Cost of Fuel",null,0,null,null,{"$f":"ROUND(+'Data Input'!C36,0)","v":2018739},null,{"$f":"A30","v":10}]
[{"$f":"A30+1","v":11},"Purchased Power other than MISO",null,{"$f":"'Data Input'!C18","v":17322},null,null,{"$f":"'Data Input'!C35","v":2819645},null,{"$f":"A31","v":11}]
[]
[{"$f":"A31+1","v":12},"Total",null,{"$f":"SUM(D26:D31)","v":69497},null,null,{"$f":"SUM(G26:G31)","v":9296168},null,{"$f":"A33","v":12}]
[]
[null,{"$f":"+'Sch 1'!H11","v":"August"}]
[]
[null,"Purchases through MISO:"]
[13,"   Wind Purchase Power Agreement Purchases",null,{"$f":"'Data Input'!D16","v":40692},null,null,{"$f":"'Data Input'!D33","v":3499511},null,{"$f":"A38","v":13}]
[14,"   Non-Wind PPA Market Purchases",null,{"$f":"'Data Input'!D17","v":17294},null,null,{"$f":"'Data Input'!D34","v":658357},null,{"$f":"A39","v":14}]
[15,"   Other",null,0,null,null,0,null,{"$f":"A40","v":15}]
[16,"MISO Components of Cost of Fuel",null,0,null,null,{"$f":"ROUND(+'Data Input'!D36,0)","v":1932675},null,{"$f":"A41","v":16}]
[{"$f":"A41+1","v":17},"Purchased Power other than MISO",null,{"$f":"'Data Input'!D18","v":16407},null,null,{"$f":"'Data Input'!D35","v":2728627},null,{"$f":"A42","v":17}]
[]
[{"$f":"A42+1","v":18},"Total",null,{"$f":"SUM(D37:D42)","v":74393},null,null,{"$f":"SUM(G37:G42)","v":8819170},null,{"$f":"A44","v":18}]
[]
[null,"Total Net Energy Cost of",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"`"]
[{"$f":"A44+1","v":19},"Purchased Power",null,{"$f":"D22+D33+D44","v":262535},null,null,{"$f":"G22+G33+G44","v":30225200},null,{"$f":"A47","v":19}]
[]
[]
[]
[null,"*  Demand Charges have not been estimated."]
[]
[]
[]
[]
[]
[null,"Formula Checks"]
[null,"Should equal zero",null,{"$f":"SUM(D16:D20,D27:D31,D38:D42)-D47","v":0},null,null,{"$f":"SUM(G16:G20,G27:G31,G38:G42)-G47","v":0}]

{"sheet":"Sch 3","index":5,"n_rows":48,"n_cols":24,"rows_kept":48,"cut":false,"hidden":false,"merged":[]}
[{"$f":"'Data Input'!A7","v":"Cause No. 38703-FAC135"},null,null,null,null,null,null,"Applicant's Attachment NHC-1"]
[null,null,null,null,null,null,null,"Schedule 3"]
[null,null,null,null,null,null,null,"Page 1 of 1"]
[]
[{"$f":"'Sch 1'!$A$4","v":"AES INDIANA"}]
["Determination of Fuel Costs Recovered Through"]
["Inter-System and Non-Jurisdictional Retail Sales by Month"]
[{"$f":"'Sch 2'!A6","v":"For the Estimated Months of June, July, and August 2022"}]
[]
[null,null,null,"kWh",null,null,null,"Line"]
["Line",null,null,"Sold",null,null,null,"No."]
["No.","Purchaser",null,"(000's)",null,"Fuel Cost *"]
[null,null,null,"(A)",null,"(B)"]
[]
[null,{"$f":"'Sch 2'!B13","v":"June"}]
[]
[1,"   Inter-System Sales through MISO",null,{"$f":"ROUND(+'Data Input'!B19,0)","v":149162},null,{"$f":"+'Data Input'!B38","v":4367277},null,{"$f":"A17","v":1}]
[{"$f":"A17+1","v":2},"   Inter-System Sales other than MISO",null,0,null,0,null,{"$f":"A18","v":2}]
[{"$f":"A18+1","v":3},"   Non-Jurisdictional Retail Sales",null,{"$f":"ROUND(+'Data Input'!B22,0)","v":0},null,{"$f":"+'Data Input'!B40","v":0},null,{"$f":"A19","v":3}]
[]
[{"$f":"A19+1","v":4},"Total",null,{"$f":"SUM(D17:D19)","v":149162},null,{"$f":"SUM(F17:F19)","v":4367277},null,{"$f":"A21","v":4}]
[]
[null,{"$f":"'Sch 2'!B24","v":"July"}]
[]
[{"$f":"A21+1","v":5},"   Inter-System Sales through MISO",null,{"$f":"ROUND(+'Data Input'!C19,0)","v":260380},null,{"$f":"+'Data Input'!C38","v":7697815},null,{"$f":"A25","v":5}]
[{"$f":"A25+1","v":6},"   Inter-System Sales other than MISO",null,0,null,0,null,{"$f":"A26","v":6}]
[{"$f":"A26+1","v":7},"   Non-Jurisdictional Retail Sales",null,{"$f":"ROUND(+'Data Input'!C22,0)","v":0},null,{"$f":"+'Data Input'!C40","v":0},null,{"$f":"A27","v":7}]
[]
[{"$f":"A27+1","v":8},"Total",null,{"$f":"SUM(D25:D27)","v":260380},null,{"$f":"SUM(F25:F27)","v":7697815},null,{"$f":"A29","v":8}]
[]
[null,{"$f":"+'Sch 1'!H11","v":"August"}]
[]
[{"$f":"A29+1","v":9},"   Inter-System Sales through MISO",null,{"$f":"ROUND(+'Data Input'!D19,0)","v":267629},null,{"$f":"+'Data Input'!D38","v":7656369},null,{"$f":"A33","v":9}]
[{"$f":"A33+1","v":10},"   Inter-System Sales other than MISO",null,0,null,0,null,{"$f":"A34","v":10}]
[{"$f":"A34+1","v":11},"   Non-Jurisdictional Retail Sales",null,{"$f":"ROUND(+'Data Input'!D22,0)","v":0},null,{"$f":"+'Data Input'!D40","v":0},null,{"$f":"A35","v":11}]
[]
[{"$f":"A35+1","v":12},"Total",null,{"$f":"SUM(D33:D35)","v":267629},null,{"$f":"SUM(F33:F35)","v":7656369},null,{"$f":"A37","v":12}]
[]
[null,"Total Inter-System and "]
[{"$f":"A37+1","v":13},"Non-Jurisdictional Retail Sales",null,{"$f":"D21+D29+D37","v":677171},null,{"$f":"F21+F29+F37","v":19721461},null,{"$f":"A40","v":13}]
[]
[]
[null,"* Demand Charges have not been estimated."]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"`"]
[null,"Formula Checks"]
[null,"Should equal zero",null,{"$f":"SUM(D17:D19)+SUM(D25:D27)+SUM(D33:D35)-D40","v":0},null,{"$f":"SUM(F17:F19)+SUM(F25:F27)+SUM(F33:F35)-F40","v":0},{"$f":"SUM(G6:G10,G17:G21,G28:G32)-G37","v":0}]

{"sheet":"Sch 4 p1","index":6,"n_rows":52,"n_cols":24,"rows_kept":52,"cut":false,"hidden":false,"merged":[[3,0,3,21],[4,0,4,21],[5,0,5,21],[6,0,6,21]]}
[{"$f":"'Data Input'!A7","v":"Cause No. 38703-FAC135"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Applicant's Attachment NHC-1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Schedule 4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Page 1 of 3"]
[{"$f":"'Sch 1'!$A$4","v":"AES INDIANA"}]
["Reconciliation of Actual Incremental Cost of Fuel"]
["Incurred to Applicable Incremental Retail Fuel Clause"]
["Revenues for November, 2021"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Incremental"]
[null,null,null,null,null,null,null,null,null,null,null,"Actual",null,"Actual",null,null,null,"Fuel Clause"]
[null,null,null,null,null,"Base Cost",null,null,null,null,null,"Incremental",null,"Incremental",null,null,null,"Revenues to"]
[null,null,null,null,null,"of Fuel",null,"Actual Cost",null,"Actual",null,"Cost of Fuel",null,"Cost of Fuel",null,"Fuel Cost (2)",null,"be Reconciled"]
[null,null,null,null,null,"Included ",null,"of Fuel",null,"Incremental",null,"Billed",null,"Billed",null,"Variance",null,"with Actual"]
[null,null,null,"kWh",null,"in Rates",null,"Incurred",null,"Cost of",null,"Including",null,"Excluding",null,"From",null,"Incremental"]
["Line ",null,null,"Sales",null,32.938000000000002,null,{"$f":"'Sch 5 p1'!E58","v":72.563000000000002},null,"Fuel",null,"Utility",null,"Utility",null,"Cause No.",null,"Cost of Fuel",null,"Fuel Cost","Line "]
["No.","Class of Customers",null,"(In 000's)",null,"Mills/kWh",null,"Mills/kWh",null,"Incurred",null,"Receipts Tx",null,"Receipts Tx (1)",null,{"$f":"+'Data Input'!H21","v":"38703-FAC132"},null,"Incurred",null,"Variance","No."]
[" ",null,null,"(A)",null,"(B)",null,"(C)",null,"(D)",null,"(E)",null,"(F)",null,"(G)",null,"(H)",null,"(I)"," "]
[null,null,null,null,null,"(Col A * mills above)",null,"(Col A * mills above)",null,"(Col C - Col B)",null,null,null,null,null,null,null,"(Col F - Col G)",null,"(Col D - Col H)"]
[]
[1,"Total Residential",null,{"$f":"+'Data Input'!J3","v":327224},null,{"$f":"ROUND(F15*D20,0)","v":10778104},null,{"$f":"ROUND(H15*D20,0)+1","v":23744356},null,{"$f":"H20-F20","v":12966252},null,{"$f":"'Data Input'!J14","v":-10374},null,{"$f":"ROUND(L20*(1-(0.014/(1-(VLOOKUP($A$7,'Data Input'!$A$104:$B$234,2,FALSE))))),0)-1","v":-10222},null,null,null,null,null,null,{"$f":"A20","v":1}]
[]
[2,"Total Commercial",null,{"$f":"+'Data Input'!J4","v":118722},null,{"$f":"ROUND(F15*D22,0)","v":3910465},null,{"$f":"ROUND(H15*D22,0)","v":8614824},null,{"$f":"H22-F22","v":4704359},null,{"$f":"'Data Input'!J15","v":-3835},null,{"$f":"ROUND(L22*(1-(0.014/(1-(VLOOKUP($A$7,'Data Input'!$A$104:$B$234,2,FALSE))))),0)","v":-3778},null,null,null,null,null,null,{"$f":"A22","v":2}]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[3,"Total Industrial",null,{"$f":"+'Data Input'!J5","v":453048},null,{"$f":"ROUND(F15*D24,0)","v":14922495},null,{"$f":"ROUND(H15*D24,0)","v":32874522},null,{"$f":"H24-F24","v":17952027},null,{"$f":"'Data Input'!J16","v":-16819},null,{"$f":"ROUND(L24*(1-(0.014/(1-(VLOOKUP($A$7,'Data Input'!$A$104:$B$234,2,FALSE))))),0)","v":-16571},null,null,null,null,null,null,{"$f":"A24","v":3}]
[]
[null,"Total Electric Vehicle"]
[4,"   Public Charging Stations",null,{"$f":"+'Data Input'!J6","v":3},null,{"$f":"ROUND(F15*D27,0)","v":99},null,{"$f":"ROUND(H15*D27,0)","v":218},null,{"$f":"H27-F27","v":119},null,{"$f":"'Data Input'!J17","v":-0.1},null,{"$f":"ROUND(L27*(1-(0.014/(1-(VLOOKUP($A$7,'Data Input'!$A$104:$B$234,2,FALSE))))),0)","v":0},null,null,null,null,null,null,{"$f":"A27","v":4}]
[]
[5,"Total Lighting",null,{"$f":"+'Data Input'!J7","v":5958},null,{"$f":"ROUND(F15*D29,0)","v":196245},null,{"$f":"+D29*H15","v":432330.35399999999},null,{"$f":"H29-F29","v":236085.35399999999},null,{"$f":"'Data Input'!J18","v":-127},null,{"$f":"ROUND(L29*(1-(0.014/(1-(VLOOKUP($A$7,'Data Input'!$A$104:$B$234,2,FALSE))))),0)","v":-125},null,null,null,null,null,null,{"$f":"A29","v":5}]
[]
[6,"Total Other",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A31","v":6}]
[]
[null,"Total Retail Sales"]
[7,"  Subject to FAC",null,{"$f":"SUM(D20:D33)","v":904955},null,{"$f":"SUM(F20:F33)","v":29807408},null,{"$f":"SUM(H20:H33)","v":65666250.354000002},null,{"$f":"SUM(J20:J33)","v":35858842.354000002},null,{"$f":"SUM(L20:L31)","v":-31155.1},null,{"$f":"SUM(N20:N33)","v":-30696},null,{"$f":"-'Data Input'!O21","v":1054312.5},null,{"$f":"N34-P34","v":-1085008.5},null,{"$f":"J34-R34","v":36943850.854000002},{"$f":"A34","v":7}]
[]
[null,"Total Retail Sales NOT"]
[8,"  Subject to FAC",null,{"$f":"+D43-D34-D40","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A37","v":8}]
[]
[null,"Total Non-jurisdictional"]
[9,"  Retail Sales",null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A40","v":9}]
[]
[]
[10,"Sales",null,{"$f":"'Data Input'!J11","v":904955},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A43","v":10}]
[]
[null,"(1) Column E Multiplied By (1-(1.4% URT Rate/(1-.05075)))"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"`"]
[null,"(2) Column G includes amortization of the prior period (over)/under collections of fuel costs and the NOI credit. FAC 132 included an NOI credit of -$3,330,787 and a fuel cost variance of $12,987,449"]
[]
[]
[]
[null,"Formula checks:"]
[null,"Should be zero",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+P34+R34-N34","v":0},null,{"$f":"+T34+R34-J34","v":0}]

{"sheet":"Sch 4 p2","index":7,"n_rows":56,"n_cols":24,"rows_kept":56,"cut":false,"hidden":false,"merged":[[3,0,3,21],[4,0,4,21],[5,0,5,21],[6,0,6,21]]}
[{"$f":"'Data Input'!A7","v":"Cause No. 38703-FAC135"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Applicant's Attachment NHC-1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Schedule 4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Page 2 of 3"]
[{"$f":"'Sch 1'!$A$4","v":"AES INDIANA"}]
["Reconciliation of Actual Incremental Cost of Fuel"]
["Incurred to Applicable Incremental Retail Fuel Clause"]
["Revenues for December, 2021"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Incremental"]
[null,null,null,null,null,null,null,null,null,null,null,"Actual",null,"Actual",null,null,null,"Fuel Clause"]
[null,null,null,null,null,"Base Cost",null,null,null,null,null,"Incremental",null,"Incremental",null,null,null,"Revenues to"]
[null,null,null,null,null,"of Fuel",null,"Actual Cost",null,"Actual",null,"Cost of Fuel",null,"Cost of Fuel",null,"Fuel Cost (2)",null,"be Reconciled"]
[null,null,null,null,null,"Included ",null,"of Fuel",null,"Incremental",null,"Billed",null,"Billed",null,"Variance",null,"with Actual"]
[null,null,null,"kWh",null,"in Rates",null,"Incurred",null,"Cost of",null,"Including",null,"Excluding",null,"From",null,"Incremental"]
["Line ",null,null,"Sales",null,32.938000000000002,null,{"$f":"+'Sch 5 p2'!E58","v":47.423000000000002},null,"Fuel",null,"Utility",null,"Utility",null,"Cause No.",null,"Cost of Fuel",null,"Fuel Cost","Line "]
["No.","Class of Customers",null,"(In 000's)",null,"Mills/kWh",null,"Mills/kWh",null,"Incurred",null,"Receipts Tx",null,"Receipts Tx (1)",null,{"$f":"+'Data Input'!H22","v":"38703-FAC132/FAC133"},null,"Incurred",null,"Variance","No."]
[" ",null,null,"(A)",null,"(B)",null,"(C)",null,"(D)",null,"(E)",null,"(F)",null,"(G)",null,"(H)",null,"(I)"," "]
[null,null,null,null,null,"(Col A * mills above)",null,"(Col A * mills above)",null,"(Col C - Col B)",null,null,null,null,null,null,null,"(Col F - Col G)",null,"(Col D - Col H)"]
[]
[1,"Total Residential",null,{"$f":"'Data Input'!L3","v":459406},null,{"$f":"ROUND(F16*D21,0)","v":15131915},null,{"$f":"ROUND(H16*D21,0)","v":21786411},null,{"$f":"H21-F21","v":6654496},null,{"$f":"+'Data Input'!L14","v":2457142},null,{"$f":"ROUND(L21*(1-(0.014/(1-(VLOOKUP($A$7,'Data Input'!$A$104:$B$234,2,FALSE))))),0)","v":2420903},null,null,null,null,null,null,{"$f":"A21","v":1}]
[]
[2,"Total Commercial",null,{"$f":"'Data Input'!L4","v":147221},null,{"$f":"ROUND(F16*D23,0)","v":4849165},null,{"$f":"ROUND(H16*D23,0)","v":6981661},null,{"$f":"H23-F23","v":2132496},null,{"$f":"+'Data Input'!L15","v":785318},null,{"$f":"ROUND(L23*(1-(0.014/(1-(VLOOKUP($A$7,'Data Input'!$A$104:$B$234,2,FALSE))))),0)","v":773736},null,null,null,null,null,null,{"$f":"A23","v":2}]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[3,"Total Industrial",null,{"$f":"'Data Input'!L5","v":475724},null,{"$f":"ROUND(F16*D25,0)","v":15669397},null,{"$f":"ROUND(H16*D25,0)","v":22560259},null,{"$f":"H25-F25","v":6890862},null,{"$f":"+'Data Input'!L16","v":2399891},null,{"$f":"ROUND(L25*(1-(0.014/(1-(VLOOKUP($A$7,'Data Input'!$A$104:$B$234,2,FALSE))))),0)","v":2364496},null,null,null,null,null,null,{"$f":"A25","v":3}]
[]
[null,"Total Electric Vehicle"]
[4,"   Public Charging Stations",null,{"$f":"'Data Input'!L6","v":3},null,{"$f":"ROUND(F16*D28,0)","v":99},null,{"$f":"ROUND(H16*D28,0)","v":142},null,{"$f":"H28-F28","v":43},null,{"$f":"+'Data Input'!L17","v":17.170000000000002},null,{"$f":"ROUND(L28*(1-(0.014/(1-(VLOOKUP($A$7,'Data Input'!$A$104:$B$234,2,FALSE))))),0)","v":17},null,null,null,null,null,null,{"$f":"A28","v":4}]
[]
[5,"Total Lighting",null,{"$f":"'Data Input'!L7","v":6380},null,{"$f":"ROUND(F16*D30,0)","v":210144},null,{"$f":"ROUND(H16*D30,0)","v":302559},null,{"$f":"H30-F30","v":92415},null,{"$f":"+'Data Input'!L18","v":38637},null,{"$f":"ROUND(L30*(1-(0.014/(1-(VLOOKUP($A$7,'Data Input'!$A$104:$B$234,2,FALSE))))),0)","v":38067},null,null,null,null,null,null,{"$f":"A30","v":5}]
[]
[6,"Total Other",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A32","v":6}]
[]
[null,"Total Retail Sales"]
[7,"  Subject to FAC",null,{"$f":"SUM(D21:D34)","v":1088734},null,{"$f":"SUM(F21:F34)","v":35860720},null,{"$f":"SUM(H21:H34)","v":51631032},null,{"$f":"SUM(J21:J34)","v":15770312},null,{"$f":"SUM(L21:L32)","v":5681005.1699999999},null,{"$f":"SUM(N21:N34)","v":5597219},null,{"$f":"-'Data Input'!O22","v":4445178.5},null,{"$f":"N35-P35","v":1152040.5},null,{"$f":"J35-R35-1","v":14618270.5},{"$f":"A35","v":7}]
[]
[null,"Total Retail Sales NOT"]
[8,"  Subject to FAC",null,{"$f":"+D44-D35-D41","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A38","v":8}]
[]
[null,"Total Non-jurisdictional"]
[9,"  Retail Sales",null,{"$f":"+'Data Input'!L8","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A41","v":9}]
[]
[]
[10,"Sales",null,{"$f":"+'Data Input'!L11","v":1088734},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A44","v":10}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"`"]
[null,"(1) Column E Multiplied By (1-(1.4% URT Rate/(1-.05075)))"]
[]
[null,"(2) Column G includes amortization of the prior period (over)/under collections of fuel costs.   Includes FAC 132 fuel cost variance of $12,987,449 and FAC 133 fuel cost variance of $13,683,622."]
[]
[]
[]
[]
[]
[null,"Formula checks:"]
[null,"Should be zero",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+P35+R35-N35","v":0},null,{"$f":"+T35+R35-J35","v":-1}]

{"sheet":"Sch 4 p3","index":8,"n_rows":52,"n_cols":24,"rows_kept":52,"cut":false,"hidden":false,"merged":[[3,0,3,16],[4,0,4,16],[5,0,5,16],[6,0,6,16]]}
[{"$f":"'Data Input'!A7","v":"Cause No. 38703-FAC135"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Applicant's Attachment NHC-1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Schedule 4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Page 3 of 3"]
[{"$f":"'Sch 1'!$A$4","v":"AES INDIANA"}]
["Reconciliation of Actual Incremental Cost of Fuel"]
["Incurred to Applicable Incremental Retail Fuel Clause"]
["Revenues for January, 2022"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Incremental"]
[null,null,null,null,null,null,null,null,null,null,null,"Actual",null,"Actual",null,null,null,"Fuel Clause"]
[null,null,null,null,null,"Base Cost",null,null,null,null,null,"Incremental",null,"Incremental",null,null,null,"Revenues to "]
[null,null,null,null,null,"of Fuel",null,"Actual Cost",null,"Actual",null,"Cost of Fuel",null,"Cost of Fuel",null,"Fuel Cost (2)",null,"be Reconciled"]
[null,null,null,null,null,"Included ",null,"of Fuel",null,"Incremental",null,"Billed",null,"Billed",null,"Variance",null,"with Actual"]
[null,null,null,"kWh",null,"in Rates",null,"Incurred",null,"Cost of",null,"Including",null,"Excluding",null,"From",null,"Incremental",null,null,"Line "]
["Line ",null,null,"Sales",null,32.938000000000002,null,{"$f":"'Sch 5 p3'!E58","v":45.097000000000001},null,"Fuel",null,"Utility",null,"Utility",null,"Cause No.",null,"Cost of Fuel",null,"Fuel Cost","No."]
["No.","Class of Customers",null,"(In 000's)",null,"Mills/kWh",null,"Mills/kWh",null,"Incurred",null,"Receipts Tx",null,"Receipts Tx (1)",null,{"$f":"+'Data Input'!H23","v":"38703-FAC132/FAC133"},null,"Incurred",null,"Variance"]
[" ",null,null,"(A)",null,"(B)",null,"(C)",null,"(D)",null,"(E)",null,"(F)",null,"(G)",null,"(H)",null,"(I)"]
[null,null,null,null,null,"(Col A * mills above)",null,"(Col A * mills above)",null,"(Col C - Col B)",null,null,null,null,null,null,null,"(Col F - Col G)",null,"(Col D - Col H)"]
[]
[1,"Total Residential",null,{"$f":"'Data Input'!N3","v":552387},null,{"$f":"ROUND(F14*D19,0)","v":18194523},null,{"$f":"ROUND(H14*D19,0)","v":24910997},null,{"$f":"H19-F19","v":6716474},null,{"$f":"'Data Input'!N14-3","v":2954438},null,{"$f":"ROUND(L19*(1-(0.0146/(1-(VLOOKUP($A$7,'Data Input'!$A$104:$B$234,2,FALSE))))),0)","v":2909081},null,null,null,null,null,null,1]
[]
[2,"Total Commercial",null,{"$f":"'Data Input'!N4","v":164049},null,{"$f":"ROUND(F14*D21,0)","v":5403446},null,{"$f":"ROUND(H14*D21,0)","v":7398118},null,{"$f":"H21-F21","v":1994672},null,{"$f":"'Data Input'!N15","v":880326},null,{"$f":"ROUND(L21*(1-(0.0146/(1-(VLOOKUP($A$7,'Data Input'!$A$104:$B$234,2,FALSE))))),0)","v":866811},null,null,null,null,null,null,2]
[" "]
[3,"Total Industrial",null,{"$f":"'Data Input'!N5","v":491612},null,{"$f":"ROUND(F14*D23,0)","v":16192716},null,{"$f":"ROUND(H14*D23,0)","v":22170226},null,{"$f":"H23-F23","v":5977510},null,{"$f":"'Data Input'!N16","v":2673200},null,{"$f":"ROUND(L23*(1-(0.0146/(1-(VLOOKUP($A$7,'Data Input'!$A$104:$B$234,2,FALSE))))),0)","v":2632160},null,null,null,null,null,null,3]
[]
[null,"Total Electric Vehicle"]
[4,"   Public Charging Stations",null,{"$f":"'Data Input'!N6","v":3},null,{"$f":"ROUND(F14*D26,0)","v":99},null,{"$f":"ROUND(H14*D26,0)","v":135},null,{"$f":"H26-F26","v":36},null,{"$f":"'Data Input'!N17","v":0},null,{"$f":"ROUND(L26*(1-(0.0146/(1-(VLOOKUP($A$7,'Data Input'!$A$104:$B$234,2,FALSE))))),0)","v":0},null,null,null,null,null,null,4]
[]
[5,"Total Lighting",null,{"$f":"'Data Input'!N7","v":6238},null,{"$f":"ROUND(F14*D28,0)","v":205467},null,{"$f":"ROUND(H14*D28,0)","v":281315},null,{"$f":"H28-F28","v":75848},null,{"$f":"'Data Input'!N18","v":37549},null,{"$f":"ROUND(L28*(1-(0.0146/(1-(VLOOKUP($A$7,'Data Input'!$A$104:$B$234,2,FALSE))))),0)","v":36973},null,null,null,null,null,null,5]
[]
[6,"Total Other ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6]
[]
[null,"Total Retail Sales"]
[7,"  Subject to FAC",null,{"$f":"SUM(D19:D32)","v":1214289},null,{"$f":"SUM(F19:F32)","v":39996251},null,{"$f":"SUM(H19:H32)","v":54760791},null,{"$f":"SUM(J19:J32)","v":14764540},null,{"$f":"SUM(L19:L29)","v":6545513},null,{"$f":"SUM(N19:N32)","v":6445025},null,{"$f":"-'Data Input'!O23","v":4445178.5},null,{"$f":"N33-P33","v":1999846.5},null,{"$f":"J33-R33","v":12764693.5},7]
[]
[null,"Total Retail Sales NOT"]
[8,"  Subject to FAC",null,{"$f":"+D41-D33-D39","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[]
[null,"Total Non-jurisdictional"]
[9,"  Retail Sales",null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9]
[]
[10,"Sales",null,{"$f":"'Data Input'!N11","v":1214289},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
[]
[]
[]
[]
[null,"(1) Column E Multiplied By (1-(1.46% URT Rate/(1-.049)))",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"`"]
[]
[null,"(2) Column G includes amortization of the prior period (over)/under collections of fuel costs.   Includes FAC 132 fuel cost variance of $12,987,449 and FAC 133 fuel cost variance of $13,683,622."]
[]
[]
[null,"Formula checks:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+P33+R33-N33","v":0},null,{"$f":"+T33+R33-J33","v":0}]
[null,"Should be zero"]

{"sheet":"Sch 5 p1","index":9,"n_rows":72,"n_cols":24,"rows_kept":72,"cut":false,"hidden":false,"merged":[[10,4,10,6]]}
[{"$f":"'Data Input'!A7","v":"Cause No. 38703-FAC135"},null,null,null,null,null,"Applicant's Attachment NHC-1"]
[null,null,null,null,null,null,"Schedule 5"]
[null,null,null,null,null,null,"Page 1 of 4"]
[{"$f":"'Sch 1'!$A$4","v":"AES INDIANA"}]
["Comparison of Actual and Estimated Cost of Fuel"]
["Reconciliation November, 2021"]
[]
[]
[]
["Line",null,null,null,null,null,null,"Line"]
[" No. ","         Description        ",null,"                         ",{"$f":"'Date Input'!$B$9","v":"November"},null,null," No. "]
[null,"kWh Source (000's)  ",null,null,"Actual",null,"Forecast"]
[]
[1,"Coal and Oil Generation",null,null,{"$f":"FCA_A8A!C16","v":184482},null,{"$f":"+'Data Input'!J33","v":795413},{"$f":"A14","v":1}]
[{"$f":"1+A14","v":2},"Nuclear Generation",null,null,0,null,{"$f":"+'Data Input'!J34","v":0},{"$f":"A15","v":2}]
[{"$f":"1+A15","v":3},"Hydro Generation",null,null,0,null,{"$f":"+'Data Input'!J35","v":0},3]
[{"$f":"1+A16","v":4},"Other Generation - Internal Combustion",null,null,{"$f":"+FCA_A8A!C23+FCA_A8A!C27+FCA_A8A!C24","v":19},null,{"$f":"+'Data Input'!J36","v":0},4]
[{"$f":"1+A17","v":5},"Gas Generation",null,null,{"$f":"+FCA_A8A!C25+FCA_A8A!C22+FCA_A8A!C20","v":382977},null,{"$f":"+'Data Input'!J37","v":378968},5]
[null,"Purchases through MISO:"]
[{"$f":"1+A18","v":6},"   Wind Purchase Power Agreement Purchases",null,null,{"$f":"ROUND(FCA_A10A!F22+FCA_A10A!F23,0)","v":59790},null,{"$f":"'Data Input'!J39","v":72753},6]
[{"$f":"A20+1","v":7},"   Non-Wind PPA Market Purchases",null,null,{"$f":"ROUND(FCA_A10A!F66,0)","v":427674},null,{"$f":"'Data Input'!J40","v":80527},7]
[{"$f":"A21+1","v":8},"   Other",null,null,{"$f":"ROUND(FCA_A10A!F14+FCA_A10A!F15+FCA_A10A!F68,0)","v":19},null,{"$f":"'Data Input'!J41","v":0},8]
[{"$f":"A22+1","v":9},"Purchased Power other than MISO",null,null,{"$f":"SUM(FCA_A10A!F24:F64)","v":7585},null,{"$f":"+'Data Input'!J42","v":11290},9]
[null,"LESS:"]
[{"$f":"A23+1","v":10},"   Energy Losses and Company Use",null,"  ",{"$f":"ROUND(+(+E14+E15+E16+E17+E18+E20+E21+E22+E23-E26-E27)*'Data Input'!B2+'Data Input'!H27+'Data Input'!J27,0)","v":52802},null,{"$f":"+'Data Input'!J44","v":53512},10]
[{"$f":"A25+1","v":11},"   Inter-System Sales through MISO",null,null,{"$f":"+FCA_A11A!D25+FCA_A11A!D23","v":0},null,{"$f":"+'Data Input'!J45","v":294402},11]
[{"$f":"A26+1","v":12},"   Inter-System Sales other than MISO",null,null,{"$f":"SUM(FCA_A11A!D19:D21)","v":0},null,{"$f":"+'Data Input'!J46","v":0},12]
[{"$f":"A27+1","v":13},"   Non-Jurisdictional Retail Sales",null,null,{"$f":"ROUND(+FCA_A11A!D49*((1-'Data Input'!B2)),0)","v":0},null,{"$f":"+'Data Input'!J47","v":0},13]
[]
[{"$f":"A28+1","v":14},"Sales (S)",null,null,{"$f":"SUM(E14:E23)-SUM(E25:E28)","v":1009744},null,{"$f":"SUM(G14:G23)-SUM(G25:G28)","v":991037},14]
[]
[null,"Fuel Cost"]
[]
[{"$f":"1+A30","v":15},"Coal and Oil Generation",null,null,{"$f":"ROUND(+FCA_A8A!S16,0)","v":4974914},null,{"$f":"+'Data Input'!J53","v":16027105},{"$f":"A34","v":15}]
[{"$f":"A34+1","v":16},"Nuclear Generation",null,null,0,null,{"$f":"+'Data Input'!J54","v":0},16]
[{"$f":"A35+1","v":17},"Hydro Generation",null,null,0,null,{"$f":"+'Data Input'!J55","v":0},17]
[{"$f":"A36+1","v":18},"Other Generation - Internal Combustion",null,null,{"$f":"ROUND(+FCA_A8A!M23+FCA_A8A!M24+FCA_A8A!M27,0)","v":2954},null,{"$f":"+'Data Input'!J56","v":0},18]
[{"$f":"A37+1","v":19},"Gas Generation",null,null,{"$f":"ROUND(+FCA_A8A!M25+FCA_A8A!P25+FCA_A8A!P22+FCA_A8A!P20,0)","v":24572739},null,{"$f":"+'Data Input'!J57","v":9276128},19]
[{"$f":"1+A38","v":20},"Financial Hedges Gains/Losses & Transactional Fees",null,null,{"$f":"FCA_A10A!J69","v":0},null,0,{"$f":"A39","v":20}]
[null,"Purchases through MISO:",null,null," "]
[{"$f":"A39+1","v":21},"   Wind Purchase Power Agreement Purchases",null,null,{"$f":"ROUND(FCA_A10A!J22+FCA_A10A!J23,0)","v":7929986},null,{"$f":"'Data Input'!J59","v":7927735},21]
[{"$f":"A41+1","v":22},"   Non-Wind PPA Market Purchases",null,null,{"$f":"ROUND(FCA_A10A!J66,0)","v":27481782},null,{"$f":"'Data Input'!J60","v":1908695},22]
[{"$f":"A42+1","v":23},"   Other",null,null,{"$f":"ROUND(FCA_A10A!J14+FCA_A10A!J15+FCA_A10A!J68,0)","v":472},null,{"$f":"'Data Input'!J61","v":0},23]
[{"$f":"A43+1","v":24},"MISO Components of Cost of Fuel",null,null,{"$f":"ROUND(+FCA_A10A!J67,0)","v":7081450},null,{"$f":"+'Data Input'!J62","v":1246724},24]
[{"$f":"A44+1","v":25},"Purchased Power other than MISO",null,null,{"$f":"ROUND(SUM(FCA_A10A!J24:J64),0)","v":1225785},null,{"$f":"+'Data Input'!J63","v":1863671},25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"`"]
[null,"LESS:"]
[]
[{"$f":"A45+1","v":26},"   Inter-System Sales through MISO",null,null,{"$f":"ROUND(+FCA_A11A!J25+FCA_A11A!T25+FCA_A11A!J23+FCA_A11A!T23,0)","v":0},null,{"$f":"+'Data Input'!J67","v":5925787},{"$f":"A49","v":26}]
[{"$f":"A49+1","v":27},"   Inter-System Sales other than MISO",null,null,{"$f":"ROUND(SUM(FCA_A11A!J19:J21)+FCA_A11A!T19+FCA_A11A!T21,0)","v":0},null,{"$f":"+'Data Input'!J68","v":0},27]
[{"$f":"A50+1","v":28},"   Non-Jurisdictional Retail Sales",null,null,{"$f":"+FCA_A11A!J49+FCA_A11A!T49+FCA_A11A!AB49","v":0},null,{"$f":"+'Data Input'!J69","v":0},28]
[{"$f":"A51+1","v":29},"   Transmission Losses",null,null,{"$f":"ROUND(+'Data Input'!L27,0)","v":0},null,{"$f":"+'Data Input'!J70","v":287249},29]
[{"$f":"A52+1","v":30},"   Lakefield PPA Adjustment",null,null,{"$f":"ROUND('Data Input'!O27,0)-2","v":69},null,{"$f":"+'Data Input'!J71","v":209181},30]
[{"$f":"A53+1","v":31},"   Purchased Power in Excess",null,null,{"$f":"ROUND(+'Data Input'!N27,0)","v":0},null,{"$f":"+'Data Input'!J72","v":0},31]
[]
[{"$f":"A54+1","v":32},"Total Fuel Costs (F)",null,null,{"$f":"ROUND(SUM(E34:E45)-SUM(E48:E54),0)","v":73270013},null,{"$f":"SUM(G34:G45)-SUM(G48:G54)","v":31827841},32]
[]
[{"$f":"A56+1","v":33},"F / S (Mills/kWh)",null,null,{"$f":"IF(E30=0,0,ROUND(E56/E30,3))","v":72.563000000000002},null,{"$f":"IF(G30=0,0,ROUND(G56/G30,3))","v":32.116},33]
[]
[null,"Weighted Average Deviation",null,null,{"$f":"IF(E58=0,0,ROUND((G58-E58)/E58,4))","v":-0.55740000000000001}]
[null,null,null,"        "]
[]
[]
[null,"Does not appear on printout - Check figures only"]
[null,"Analysis of variance between actual and estimated costs",null,null,null,null," "]
[]
[null,null,"Formula checks:"]
[null,null,"should be zero",null,{"$f":"SUM(E14:E23)-SUM(E25:E28)-E30","v":0}]
[null,null,"should be zero - rounding",null,{"$f":"E44-'Sch 6'!D28","v":0}]
[null,null,"should be zero - rounding",null,{"$f":"SUM(E34:E38)-FCA_A8A!S31","v":-0.79999999701976776}]
[null,null,"should be zero",null,{"$f":"SUM(E14:E18)-FCA_A8A!C31","v":0}]
[null,null,"should be zero",null,{"$f":"SUM(E39:E45)-FCA_A10A!J70","v":-0.39999999850988388}]

{"sheet":"Sch 5 p2","index":10,"n_rows":96,"n_cols":24,"rows_kept":96,"cut":false,"hidden":false,"merged":[[10,4,10,6]]}
[{"$f":"'Data Input'!A7","v":"Cause No. 38703-FAC135"},null,null,null,null,null,"Applicant's Attachment NHC-1"]
[null,null,null,null,null,null,"Schedule 5"]
[null,null,null,null,null,null,"Page 2 of 4"]
[{"$f":"'Sch 1'!$A$4","v":"AES INDIANA"}]
["Comparison of Actual and Estimated Cost of Fuel"]
["Reconciliation December, 2021"]
[]
[]
[]
["Line",null,null,null,null,null,null,"Line"]
[" No. ","         Description        ",null,"                         ",{"$f":"'Date Input'!B10","v":"December"},null,null," No. "]
[null,"kWh Source (000's)  ",null,null,"Actual",null,"Forecast"]
[]
[1,"Coal and Oil Generation",null,null,{"$f":"FCA_A8B!C16","v":623008},null,{"$f":"+'Data Input'!L33","v":940033},{"$f":"A14","v":1}]
[{"$f":"1+A14","v":2},"Nuclear Generation",null,null,0,null,{"$f":"+'Data Input'!L34","v":0},{"$f":"A15","v":2}]
[{"$f":"1+A15","v":3},"Hydro Generation",null,null,0,null,{"$f":"+'Data Input'!L35","v":0},3]
[{"$f":"1+A16","v":4},"Other Generation - Internal Combustion",null,null,{"$f":"+FCA_A8B!C23+FCA_A8B!C27+FCA_A8B!C24","v":15},null,{"$f":"+'Data Input'!L36","v":0},4]
[{"$f":"A17+1","v":5},"Gas Generation",null,null,{"$f":"+FCA_A8B!C25+FCA_A8B!C22+FCA_A8B!C20","v":211212},null,{"$f":"+'Data Input'!L37","v":449911},5]
[null,"Purchases through MISO"]
[{"$f":"A18+1","v":6},"   Wind Purchase Power Agreement Purchases",null,null,{"$f":"ROUND(FCA_A10B!F22+FCA_A10B!F21,0)","v":74863},null,{"$f":"'Data Input'!L39","v":73403},6]
[{"$f":"A20+1","v":7},"   Non-Wind PPA Market Purchases",null,null,{"$f":"+FCA_A10B!F65","v":226904},null,{"$f":"'Data Input'!L40","v":65136},7]
[{"$f":"A21+1","v":8},"   Other",null,null,{"$f":"+FCA_A10B!F14+FCA_A10B!F15+FCA_A10B!F67","v":14},null,{"$f":"'Data Input'!L41","v":0},8]
[{"$f":"A22+1","v":9},"Purchased Power other than MISO",null,null,{"$f":"SUM(FCA_A10B!F23:F63)","v":6768},null,{"$f":"+'Data Input'!L42","v":5287},9]
[null,"LESS:"]
[{"$f":"A23+1","v":10},"   Energy Losses and Company Use",null,"  ",{"$f":"ROUND(+(+E14+E15+E16+E17+E18+E20+E21+E22+E23-E26-E27)*'Data Input'!B3+'Data Input'!H28+'Data Input'!J28,0)","v":56393},null,{"$f":"+'Data Input'!L44","v":65277},10]
[{"$f":"A25+1","v":11},"   Inter-System Sales through MISO",null,null,{"$f":"+FCA_A11B!D25+FCA_A11B!D23","v":10527},null,{"$f":"+'Data Input'!L45","v":259559},11]
[{"$f":"A26+1","v":12},"   Inter-System Sales other than MISO",null,null,{"$f":"SUM(FCA_A11B!D17:D21)","v":0},null,{"$f":"+'Data Input'!L46","v":0},12]
[{"$f":"A27+1","v":13}," Non-Jurisdictional Retail Sales",null,null,{"$f":"ROUND(+FCA_A11B!D49*((1-'Data Input'!B3)),0)","v":0},null,{"$f":"+'Data Input'!L47","v":0},13]
[]
[{"$f":"A28+1","v":14},"Sales (S)",null,null,{"$f":"SUM(E14:E23)-SUM(E25:E28)","v":1075864},null,{"$f":"SUM(G14:G23)-SUM(G25:G28)","v":1208934},14]
[]
[null,"Fuel Cost"]
[]
[{"$f":"1+A30","v":15},"Coal and Oil Generation",null,null,{"$f":"ROUND(+FCA_A8B!S16,0)","v":14770615},null,{"$f":"+'Data Input'!L53","v":19377649},{"$f":"A34","v":15}]
[{"$f":"A34+1","v":16},"Nuclear Generation",null,null,0,null,{"$f":"+'Data Input'!L54","v":0},16]
[{"$f":"A35+1","v":17},"Hydro Generation",null,null,0,null,{"$f":"+'Data Input'!L55","v":0},17]
[{"$f":"A36+1","v":18},"Other Generation - Internal Combustion",null,null,{"$f":"ROUND(+FCA_A8B!M23+FCA_A8B!M24+FCA_A8B!M27,0)","v":1009},null,{"$f":"+'Data Input'!L56","v":0},18]
[{"$f":"A37+1","v":19},"Gas Generation",null,null,{"$f":"ROUND(+FCA_A8B!M25+FCA_A8B!P25+FCA_A8B!P22+FCA_A8B!P20,0)","v":15481539},null,{"$f":"+'Data Input'!L57","v":15790027},19]
[{"$f":"A38+1","v":20},"Financial Hedges Gains/Losses & Transactional Fees",null,null,{"$f":"FCA_A10B!J68","v":482546},null,0,{"$f":"A39","v":20}]
[null,"Purchases through MISO"]
[{"$f":"A39+1","v":21},"   Wind Purchase Power Agreement Purchases",null,null,{"$f":"ROUND(FCA_A10B!J22+FCA_A10B!J21,0)","v":7483356},null,{"$f":"'Data Input'!L59","v":8101072},21]
[{"$f":"A41+1","v":22},"   Non-Wind PPA Market Purchases",null,null,{"$f":"ROUND(+FCA_A10B!J65,0)","v":9524139},null,{"$f":"'Data Input'!L60","v":1851402},22]
[{"$f":"A42+1","v":23},"   Other",null,null,{"$f":"ROUND(+FCA_A10B!J14+FCA_A10B!J15+FCA_A10B!J17+FCA_A10B!J67,0)","v":337},null,{"$f":"'Data Input'!L61","v":0},23]
[{"$f":"A43+1","v":24},"MISO Components of Cost of Fuel",null,null,{"$f":"ROUND(+FCA_A10B!J66,0)","v":2546715},null,{"$f":"+'Data Input'!L62","v":1496660},24,null,null,null,null,"   "]
[{"$f":"A44+1","v":25},"Purchased Power other than MISO",null,null,{"$f":"ROUND(SUM(FCA_A10B!J23:J63),0)","v":1112262},null,{"$f":"+'Data Input'!L63","v":875857},25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"`"]
[null,"LESS:"]
[]
[{"$f":"A45+1","v":26},"   Inter-System Sales through MISO",null,null,{"$f":"ROUND(+FCA_A11B!J25+FCA_A11B!T25+FCA_A11B!J23+FCA_A11B!T23,0)","v":331296},null,{"$f":"+'Data Input'!L67","v":6268405},{"$f":"A49","v":26}]
[{"$f":"A49+1","v":27},"   Inter-System Sales other than MISO",null,null,{"$f":"ROUND(SUM(FCA_A11B!J17:J21)+SUM(FCA_A11B!T17:T21),0)","v":0},null,{"$f":"+'Data Input'!L68","v":0},27]
[{"$f":"A50+1","v":28},"   Non-Jurisdictional Retail Sales",null,null,{"$f":"ROUND(+FCA_A11B!J49+FCA_A11B!T49+FCA_A11B!AB49,0)","v":0},null,{"$f":"+'Data Input'!L69","v":0},28]
[{"$f":"A51+1","v":29},"   Transmission Losses",null,null,{"$f":"ROUND(+'Data Input'!L28,0)-1","v":40793},null,{"$f":"+'Data Input'!L70","v":420422},29]
[{"$f":"A52+1","v":30},"   Lakefield PPA Adjustment",null,null,{"$f":"ROUND('Data Input'!O28,0)","v":10114},null,{"$f":"+'Data Input'!L71","v":350525},30]
[{"$f":"A53+1","v":31},"   Purchased Power in Excess",null,null,{"$f":"ROUND(+'Data Input'!N28,0)","v":0},null,{"$f":"+'Data Input'!L72","v":0},31]
[]
[{"$f":"A54+1","v":32},"Total Fuel Costs (F)",null,null,{"$f":"SUM(E34:E45)-SUM(E48:E54)","v":51020315},null,{"$f":"SUM(G34:G45)-SUM(G48:G54)","v":40453315},32]
[]
[{"$f":"A56+1","v":33},"F / S (Mills/kWh)",null,null,{"$f":"IF(E30=0,0,ROUND(E56/E30,3))","v":47.423000000000002},null,{"$f":"IF(G30=0,0,ROUND(G56/G30,3))","v":33.462000000000003},33]
[]
[null,"Weighted Average Deviation",null,null,{"$f":"IF(E58=0,0,ROUND((G58-E58)/E58,4))","v":-0.2944}]
[null,null,null,"        "]
[]
[]
[null,"Does not appear on printout - Check figures only"]
[null,"Analysis of variance between actual and estimated costs"]
[null,null,null,null,"Actual per FAC",null,"Estimated"]
[null,"Avg cost of fuel (mills / kWh)","Formula checks:"]
[null,"Steam Generation","should be zero",null,{"$f":"SUM(E14:E23)-SUM(E25:E28)-E30","v":0}]
[null,"Other Generation","should be zero - Rounding",null,{"$f":"E44-'Sch 6'!F28","v":0}]
[null,"Total Generation","should be zero",null,{"$f":"SUM(E34:E38)-FCA_A8B!S31","v":0}]
[null,"Purchased Power","should be zero",null,{"$f":"SUM(E14:E18)-FCA_A8B!C31","v":0}]
[null,"Intersystem sales","should be zero",null,{"$f":"SUM(E39:E45)-FCA_A10B!J69","v":0}]
[]
[]
[]
[null,{"$f":"$B$68","v":"Steam Generation"}]
[null,{"$f":"$B$69","v":"Other Generation"}]
[null,"Total Generation"]
[null,{"$f":"$B$71","v":"Purchased Power"}]
[null,{"$f":"$B$72","v":"Intersystem sales"}]
[]
[]
[]
[null,{"$f":"$B$68","v":"Steam Generation"}]
[null,{"$f":"$B$69","v":"Other Generation"}]
[null,"Total Generation"]
[null,{"$f":"$B$71","v":"Purchased Power"}]
[null,{"$f":"$B$72","v":"Intersystem sales"}]
[]
[]
[]
[null,{"$f":"$B$68","v":"Steam Generation"}]
[null,{"$f":"$B$69","v":"Other Generation"}]
[null,"Total Generation"]
[null,{"$f":"$B$71","v":"Purchased Power"}]
[null,{"$f":"$B$72","v":"Intersystem sales"}]

{"sheet":"Sch 5 p3","index":11,"n_rows":96,"n_cols":24,"rows_kept":96,"cut":false,"hidden":false,"merged":[[10,4,10,6]]}
[{"$f":"'Data Input'!A7","v":"Cause No. 38703-FAC135"},null,null,null,null,null,"Applicant's Attachment NHC-1"]
[null,null,null,null,null,null,"Schedule 5"]
[null,null,null,null,null,null,"Page 3 of 4"]
[{"$f":"'Sch 1'!$A$4","v":"AES INDIANA"}]
["Comparison of Actual and Estimated Cost of Fuel"]
["Reconciliation January, 2022"]
[]
[]
[]
["Line",null,null,null,null,null,null,"Line"]
[" No. ","         Description        ",null,"                         ",{"$f":"'Date Input'!B11","v":"January"},null,null," No. "]
[null,"kWh Source (000's)  ",null,null,"Actual",null,"Forecast"]
[]
[1,"Coal and Oil Generation",null,null,{"$f":"FCA_A8C!C16","v":913115},null,{"$f":"+'Data Input'!N33","v":967010},{"$f":"A14","v":1}]
[{"$f":"1+A14","v":2},"Nuclear Generation",null,null,0,null,{"$f":"+'Data Input'!N34","v":0},{"$f":"A15","v":2}]
[{"$f":"1+A15","v":3},"Hydro Generation",null,null,0,null,{"$f":"+'Data Input'!N35","v":0},3]
[{"$f":"1+A16","v":4},"Other Generation - Internal Combustion",null,null,{"$f":"+FCA_A8C!C23+FCA_A8C!C27+FCA_A8C!C24","v":14},null,{"$f":"+'Data Input'!N36","v":0},4]
[{"$f":"A17+1","v":5},"Gas Generation",null,null,{"$f":"+FCA_A8C!C25+FCA_A8C!C22+FCA_A8C!C20","v":273678},null,{"$f":"+'Data Input'!N37","v":593865},5]
[null,"Purchases through MISO"]
[6,"   Wind Purchase Power Agreement Purchases",null,null,{"$f":"ROUND(FCA_A10C!F20+FCA_A10C!F19,0)","v":90717},null,{"$f":"'Data Input'!N39","v":76890},6]
[7,"   Non-Wind PPA Market Purchases",null,null,{"$f":"ROUND(FCA_A10C!F58,0)","v":141264},null,{"$f":"'Data Input'!N40","v":65912},7]
[8,"   Other",null,null,{"$f":"ROUND(FCA_A10C!F60,0)","v":280},null,{"$f":"'Data Input'!N41","v":0},8]
[9,"Purchased Power other than MISO","                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   ",null,{"$f":"SUM(FCA_A10C!F21:F57)","v":7292},null,{"$f":"+'Data Input'!N42","v":5894},9]
[null,"LESS:"]
[{"$f":"A23+1","v":10}," Energy Losses and Company Use",null,"  ",{"$f":"ROUND(+(+E14+E15+E16+E17+E18+E20+E21+E22+E23-E26-E27)*'Data Input'!B4+'Data Input'!H29+'Data Input'!J29,0)","v":66608},null,{"$f":"+'Data Input'!N44","v":70664},10]
[{"$f":"A25+1","v":11}," Inter-System Sales through MISO",null,null,{"$f":"+FCA_A11C!D25+FCA_A11C!D23","v":44636},null,{"$f":"+'Data Input'!N45","v":330195},11]
[{"$f":"A26+1","v":12}," Inter-System Sales other than MISO",null,null,{"$f":"SUM(FCA_A11C!D18:D21)","v":0},null,{"$f":"+'Data Input'!N46","v":0},12]
[{"$f":"A27+1","v":13}," Non-Jurisdictional Retail Sales",null,null,{"$f":"ROUND(+FCA_A11C!D49*((1-'Data Input'!B4)),0)","v":0},null,{"$f":"+'Data Input'!N47","v":0},13]
[]
[{"$f":"A28+1","v":14},"Sales (S)",null,null,{"$f":"SUM(E14:E23)-SUM(E25:E28)","v":1315116},null,{"$f":"SUM(G14:G23)-SUM(G25:G28)","v":1308712},14]
[]
[null,"Fuel Cost",null,null,null,null,null,null,null,null,null," "]
[]
[{"$f":"1+A30","v":15},"Coal and Oil Generation",null,null,{"$f":"ROUND(+FCA_A8C!S16,0)","v":23001892},null,{"$f":"+'Data Input'!N53","v":20157249},{"$f":"A34","v":15}]
[{"$f":"A34+1","v":16},"Nuclear Generation",null,null,0,null,{"$f":"+'Data Input'!N54","v":0},16]
[{"$f":"A35+1","v":17},"Hydro Generation",null,null,0,null,{"$f":"+'Data Input'!N55","v":0},17]
[{"$f":"A36+1","v":18},"Other Generation - Internal Combustion",null,null,{"$f":"ROUND(+FCA_A8C!M23+FCA_A8C!M24+FCA_A8C!M27,0)","v":2203},null,{"$f":"+'Data Input'!N56","v":0},18]
[{"$f":"A37+1","v":19},"Gas Generation",null,null,{"$f":"ROUND(+FCA_A8C!M25+FCA_A8C!P25+FCA_A8C!P22+FCA_A8C!P20,0)","v":20227469},null,{"$f":"+'Data Input'!N57","v":22604674},19]
[{"$f":"A38+1","v":20},"Financial Hedges Gains/Losses & Transactional Fees",null,null,{"$f":"FCA_A10C!J61","v":0},null,0,20]
[null,"Purchases through MISO"]
[{"$f":"A39+1","v":21},"   Wind Purchase Power Agreement Purchases",null,null,{"$f":"ROUND(FCA_A10C!J19+FCA_A10C!J20,0)","v":8162108},null,{"$f":"'Data Input'!N59","v":7923164},21]
[{"$f":"A41+1","v":22},"   Non-Wind PPA Market Purchases",null,null,{"$f":"ROUND(+FCA_A10C!J58,0)","v":7659290},null,{"$f":"'Data Input'!N60","v":3075250},22]
[{"$f":"A42+1","v":23},"   Other",null,null,{"$f":"ROUND(FCA_A10C!J12+FCA_A10C!J14+FCA_A10C!J13+FCA_A10C!J60,0)","v":6673},null,{"$f":"'Data Input'!N61","v":0},23]
[{"$f":"A43+1","v":24},"MISO Components of Cost of Fuel",null,null,{"$f":"ROUND(+FCA_A10C!J59,0)","v":1516613},null,{"$f":"+'Data Input'!N62","v":1620185},24]
[{"$f":"A44+1","v":25},"Purchased Power other than MISO",null,null,{"$f":"ROUND(SUM(FCA_A10C!J21:J57),0)","v":1086815},null,{"$f":"+'Data Input'!N63","v":1004936},25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"`"]
[null,"LESS:"]
[]
[{"$f":"A45+1","v":26},"   Inter-System Sales through MISO",null,null,{"$f":"ROUND(+FCA_A11C!J25+FCA_A11C!T25+FCA_A11C!J23+FCA_A11C!T23,0)","v":1875771},null,{"$f":"+'Data Input'!N67","v":8657771},{"$f":"A49","v":26}]
[{"$f":"A49+1","v":27},"   Inter-System Sales other than MISO",null,null,{"$f":"ROUND(SUM(FCA_A11C!J19:J21)+FCA_A11C!T19+FCA_A11C!T21,0)","v":0},null,{"$f":"+'Data Input'!N68","v":0},27]
[{"$f":"A50+1","v":28},"   Non-Jurisdictional Retail Sales",null,null,{"$f":"ROUND(+FCA_A11C!J49+FCA_A11C!T49+FCA_A11C!AB49,0)","v":0},null,{"$f":"+'Data Input'!N69","v":0},28]
[{"$f":"A51+1","v":29},"   Transmission Losses",null,null,{"$f":"ROUND(+'Data Input'!L29,0)","v":212251},null,{"$f":"+'Data Input'!N70","v":494131},29]
[{"$f":"A52+1","v":30},"   Lakefield PPA Adjustment",null,null,{"$f":"ROUND('Data Input'!O29,0)+1","v":267375},null,{"$f":"+'Data Input'!N71","v":642380},30]
[{"$f":"A53+1","v":31},"   Purchased Power in Excess",null,null,{"$f":"ROUND(+'Data Input'!N29,0)","v":0},null,{"$f":"+'Data Input'!N72","v":0},31]
[]
[{"$f":"A54+1","v":32},"Total Fuel Costs (F)",null,null,{"$f":"SUM(E34:E45)-SUM(E48:E54)","v":59307666},null,{"$f":"SUM(G34:G45)-SUM(G48:G54)","v":46591176},32]
[]
[{"$f":"A56+1","v":33},"F / S (Mills/kWh)",null,null,{"$f":"IF(E30=0,0,ROUND(E56/E30,3))","v":45.097000000000001},null,{"$f":"IF(G30=0,0,ROUND(G56/G30,3))","v":35.600999999999999},33]
[]
[null,"Weighted Average Deviation",null,null,{"$f":"IF(E58=0,0,ROUND((G58-E58)/E58,4))","v":-0.21060000000000001}]
[null,null,null,"        "]
[]
[]
[null,"Does not appear on printout - Check figures only"]
[null,"Analysis of variance between actual and estimated costs"]
[null,null,null,null,"Actual per FAC",null,"Estimated"]
[null,"Avg cost of fuel (mills / kWh)","Formula checks:"]
[null,"Steam Generation","should be zero",null,{"$f":"SUM(E14:E23)-SUM(E25:E28)-E30","v":0}]
[null,"Other Generation","should be zero",null,{"$f":"E44-'Sch 6'!H28","v":0}]
[null,"Total Generation","should be zero",null,{"$f":"SUM(E34:E38)-FCA_A8C!S31","v":-0.12000000476837158}]
[null,"Purchased Power","should be zero",null,{"$f":"SUM(E14:E18)-FCA_A8C!C31","v":0}]
[null,"Intersystem sales","should be zero",null,{"$f":"SUM(E39:E45)-FCA_A10C!J62","v":0}]
[]
[null,null," "]
[]
[null,{"$f":"$B$68","v":"Steam Generation"}]
[null,{"$f":"$B$69","v":"Other Generation"}]
[null,"Total Generation"]
[null,{"$f":"$B$71","v":"Purchased Power"}]
[null,{"$f":"$B$72","v":"Intersystem sales"}]
[]
[]
[]
[null,{"$f":"$B$68","v":"Steam Generation"}]
[null,{"$f":"$B$69","v":"Other Generation"}]
[null,"Total Generation"]
[null,{"$f":"$B$71","v":"Purchased Power"}]
[null,{"$f":"$B$72","v":"Intersystem sales"}]
[]
[]
[]
[null,{"$f":"$B$68","v":"Steam Generation"}]
[null,{"$f":"$B$69","v":"Other Generation"}]
[null,"Total Generation"]
[null,{"$f":"$B$71","v":"Purchased Power"}]
[null,{"$f":"$B$72","v":"Intersystem sales"}]

{"sheet":"Sch 5 p4","index":12,"n_rows":96,"n_cols":24,"rows_kept":96,"cut":false,"hidden":false,"merged":[[10,4,10,6]]}
[{"$f":"'Data Input'!A7","v":"Cause No. 38703-FAC135"},null,null,null,null,null,"Applicant's Attachment NHC-1"]
[null,null,null,null,null,null,"Schedule 5"]
[null,null,null,null,null,null,"Page 4 of 4"]
[{"$f":"'Sch 1'!$A$4","v":"AES INDIANA"}]
["Comparison of Actual and Estimated Cost of Fuel"]
[{"$f":"'Date Input'!B12","v":"November, December 2021, and January 2022"}]
[]
[]
[]
["Line",null,null,null,null,null,null,"Line"]
[" No. ","         Description        ",null,"                         ","Total",null,null," No. ",null,null,null,null,null,null,null,null,null,"Check Figure"]
[null,"kWh Source (000's)  ",null,null,"Actual",null,"Forecast"]
[]
[1,"Coal and Oil Generation",null,null,{"$f":"'Sch 5 p1'!E14+'Sch 5 p2'!E14+'Sch 5 p3'!E14","v":1720605},null,{"$f":"'Sch 5 p1'!G14+'Sch 5 p2'!G14+'Sch 5 p3'!G14","v":2702456},{"$f":"A14","v":1},null,null,null,null,null,null,null,null,null,{"$f":"E14-'Sch 5 p3'!E14-'Sch 5 p2'!E14-'Sch 5 p1'!E14","v":0},{"$f":"G14-'Sch 5 p3'!G14-'Sch 5 p2'!G14-'Sch 5 p1'!G14","v":0}]
[{"$f":"1+A14","v":2},"Nuclear Generation",null,null,{"$f":"'Sch 5 p1'!E15+'Sch 5 p2'!E15+'Sch 5 p3'!E15","v":0},null,{"$f":"'Sch 5 p1'!G15+'Sch 5 p2'!G15+'Sch 5 p3'!G15","v":0},{"$f":"A15","v":2},null,null,null,null,null,null,null,null,null,{"$f":"E15-'Sch 5 p3'!E15-'Sch 5 p2'!E15-'Sch 5 p1'!E15","v":0},{"$f":"G15-'Sch 5 p3'!G15-'Sch 5 p2'!G15-'Sch 5 p1'!G15","v":0}]
[{"$f":"1+A15","v":3},"Hydro Generation",null,null,{"$f":"'Sch 5 p1'!E16+'Sch 5 p2'!E16+'Sch 5 p3'!E16","v":0},null,{"$f":"'Sch 5 p1'!G16+'Sch 5 p2'!G16+'Sch 5 p3'!G16","v":0},3,null,null,null,null,null,null,null,null,null,{"$f":"E16-'Sch 5 p3'!E16-'Sch 5 p2'!E16-'Sch 5 p1'!E16","v":0},{"$f":"G16-'Sch 5 p3'!G16-'Sch 5 p2'!G16-'Sch 5 p1'!G16","v":0}]
[{"$f":"1+A16","v":4},"Other Generation - Internal Combustion",null,null,{"$f":"'Sch 5 p1'!E17+'Sch 5 p2'!E17+'Sch 5 p3'!E17","v":48},null,{"$f":"'Sch 5 p1'!G17+'Sch 5 p2'!G17+'Sch 5 p3'!G17","v":0},4,null,null,null,null,null,null,null,null,null,{"$f":"E17-'Sch 5 p3'!E17-'Sch 5 p2'!E17-'Sch 5 p1'!E17","v":0},{"$f":"G17-'Sch 5 p3'!G17-'Sch 5 p2'!G17-'Sch 5 p1'!G17","v":0}]
[{"$f":"A17+1","v":5},"Gas Generation",null,null,{"$f":"'Sch 5 p1'!E18+'Sch 5 p2'!E18+'Sch 5 p3'!E18","v":867867},null,{"$f":"'Sch 5 p1'!G18+'Sch 5 p2'!G18+'Sch 5 p3'!G18","v":1422744},5,null,null,null,null,null,null,null,null,null,{"$f":"E18-'Sch 5 p3'!E18-'Sch 5 p2'!E18-'Sch 5 p1'!E18","v":0},{"$f":"G18-'Sch 5 p3'!G18-'Sch 5 p2'!G18-'Sch 5 p1'!G18","v":0}]
[null,"Purchases through MISO"]
[6,"   Wind Purchase Power Agreement Purchases",null,null,{"$f":"'Sch 5 p1'!E20+'Sch 5 p2'!E20+'Sch 5 p3'!E20","v":225370},null,{"$f":"'Sch 5 p1'!G20+'Sch 5 p2'!G20+'Sch 5 p3'!G20","v":223046},6,null,null,null,null,null,null,null,null,null,{"$f":"E20-'Sch 5 p3'!E20-'Sch 5 p2'!E20-'Sch 5 p1'!E20","v":0},{"$f":"G20-'Sch 5 p3'!G20-'Sch 5 p2'!G20-'Sch 5 p1'!G20","v":0}]
[7,"   Non-Wind PPA Market Purchases",null,null,{"$f":"'Sch 5 p1'!E21+'Sch 5 p2'!E21+'Sch 5 p3'!E21","v":795842},null,{"$f":"'Sch 5 p1'!G21+'Sch 5 p2'!G21+'Sch 5 p3'!G21","v":211575},7,null,null,null,null,null,null,null,null,null,{"$f":"E21-'Sch 5 p3'!E21-'Sch 5 p2'!E21-'Sch 5 p1'!E21","v":0},{"$f":"G21-'Sch 5 p3'!G21-'Sch 5 p2'!G21-'Sch 5 p1'!G21","v":0}]
[8,"   Other",null,null,{"$f":"'Sch 5 p1'!E22+'Sch 5 p2'!E22+'Sch 5 p3'!E22","v":313},null,{"$f":"'Sch 5 p1'!G22+'Sch 5 p2'!G22+'Sch 5 p3'!G22","v":0},8,null,null,null,null,null,null,null,null,null,{"$f":"E22-'Sch 5 p3'!E22-'Sch 5 p2'!E22-'Sch 5 p1'!E22","v":0},{"$f":"G22-'Sch 5 p3'!G22-'Sch 5 p2'!G22-'Sch 5 p1'!G22","v":0}]
[9,"Purchased Power other than MISO",null,null,{"$f":"'Sch 5 p1'!E23+'Sch 5 p2'!E23+'Sch 5 p3'!E23","v":21645},null,{"$f":"'Sch 5 p1'!G23+'Sch 5 p2'!G23+'Sch 5 p3'!G23","v":22471},9,null,null,null,null,null,null,null,null,null,{"$f":"E23-'Sch 5 p3'!E23-'Sch 5 p2'!E23-'Sch 5 p1'!E23","v":0},{"$f":"G23-'Sch 5 p3'!G23-'Sch 5 p2'!G23-'Sch 5 p1'!G23","v":0}]
[null,"LESS:"]
[{"$f":"A23+1","v":10},"   Energy Losses and Company Use",null,"  ",{"$f":"'Sch 5 p1'!E25+'Sch 5 p2'!E25+'Sch 5 p3'!E25","v":175803},null,{"$f":"'Sch 5 p1'!G25+'Sch 5 p2'!G25+'Sch 5 p3'!G25","v":189453},10,null,null,null,null,null,null,null,null,null,{"$f":"E25-'Sch 5 p3'!E25-'Sch 5 p2'!E25-'Sch 5 p1'!E25","v":0},{"$f":"G25-'Sch 5 p3'!G25-'Sch 5 p2'!G25-'Sch 5 p1'!G25","v":0}]
[{"$f":"A25+1","v":11},"   Inter-System Sales through MISO",null,null,{"$f":"'Sch 5 p1'!E26+'Sch 5 p2'!E26+'Sch 5 p3'!E26","v":55163},null,{"$f":"'Sch 5 p1'!G26+'Sch 5 p2'!G26+'Sch 5 p3'!G26","v":884156},11,null,null,null,null,null,null,null,null,null,{"$f":"E26-'Sch 5 p3'!E26-'Sch 5 p2'!E26-'Sch 5 p1'!E26","v":0},{"$f":"G26-'Sch 5 p3'!G26-'Sch 5 p2'!G26-'Sch 5 p1'!G26","v":0}]
[{"$f":"A26+1","v":12},"   Inter-System Sales other than MISO",null,null,{"$f":"'Sch 5 p1'!E27+'Sch 5 p2'!E27+'Sch 5 p3'!E27","v":0},null,{"$f":"'Sch 5 p1'!G27+'Sch 5 p2'!G27+'Sch 5 p3'!G27","v":0},12,null,null,null,null,null,null,null,null,null,{"$f":"E27-'Sch 5 p3'!E27-'Sch 5 p2'!E27-'Sch 5 p1'!E27","v":0},{"$f":"G27-'Sch 5 p3'!G27-'Sch 5 p2'!G27-'Sch 5 p1'!G27","v":0}]
[{"$f":"A27+1","v":13},"   Non-Jurisdictional Retail Sales",null,null,{"$f":"'Sch 5 p1'!E28+'Sch 5 p2'!E28+'Sch 5 p3'!E28","v":0},null,{"$f":"'Sch 5 p1'!G28+'Sch 5 p2'!G28+'Sch 5 p3'!G28","v":0},13,null,null,null,null,null,null,null,null,null,{"$f":"E28-'Sch 5 p3'!E28-'Sch 5 p2'!E28-'Sch 5 p1'!E28","v":0},{"$f":"G28-'Sch 5 p3'!G28-'Sch 5 p2'!G28-'Sch 5 p1'!G28","v":0}]
[]
[{"$f":"A28+1","v":14},"Sales (S)",null,null,{"$f":"SUM(E14:E23)-SUM(E25:E28)","v":3400724},null,{"$f":"SUM(G14:G23)-SUM(G25:G28)","v":3508683},14,null,null,null,null,null,null,null,null,null,{"$f":"E30-'Sch 5 p3'!E30-'Sch 5 p2'!E30-'Sch 5 p1'!E30","v":0},{"$f":"G30-'Sch 5 p3'!G30-'Sch 5 p2'!G30-'Sch 5 p1'!G30","v":0}]
[null,null,null,null," "]
[null,"Fuel Cost"]
[]
[{"$f":"1+A30","v":15},"Coal and Oil Generation",null,null,{"$f":"'Sch 5 p1'!E34+'Sch 5 p2'!E34+'Sch 5 p3'!E34","v":42747421},null,{"$f":"'Sch 5 p1'!G34+'Sch 5 p2'!G34+'Sch 5 p3'!G34","v":55562003},{"$f":"A34","v":15},null,null,null,null,null,null,null,null,null,{"$f":"E34-'Sch 5 p3'!E34-'Sch 5 p2'!E34-'Sch 5 p1'!E34","v":0},{"$f":"G34-'Sch 5 p3'!G34-'Sch 5 p2'!G34-'Sch 5 p1'!G34","v":0}]
[{"$f":"A34+1","v":16},"Nuclear Generation",null,null,{"$f":"'Sch 5 p1'!E35+'Sch 5 p2'!E35+'Sch 5 p3'!E35","v":0},null,{"$f":"'Sch 5 p1'!G35+'Sch 5 p2'!G35+'Sch 5 p3'!G35","v":0},16,null,null,null,null,null,null,null,null,null,{"$f":"E35-'Sch 5 p3'!E35-'Sch 5 p2'!E35-'Sch 5 p1'!E35","v":0},{"$f":"G35-'Sch 5 p3'!G35-'Sch 5 p2'!G35-'Sch 5 p1'!G35","v":0}]
[{"$f":"A35+1","v":17},"Hydro Generation",null,null,{"$f":"'Sch 5 p1'!E36+'Sch 5 p2'!E36+'Sch 5 p3'!E36","v":0},null,{"$f":"'Sch 5 p1'!G36+'Sch 5 p2'!G36+'Sch 5 p3'!G36","v":0},17,null,null,null,null,null,null,null,null,null,{"$f":"E36-'Sch 5 p3'!E36-'Sch 5 p2'!E36-'Sch 5 p1'!E36","v":0},{"$f":"G36-'Sch 5 p3'!G36-'Sch 5 p2'!G36-'Sch 5 p1'!G36","v":0}]
[{"$f":"A36+1","v":18},"Other Generation - Internal Combustion",null,null,{"$f":"'Sch 5 p1'!E37+'Sch 5 p2'!E37+'Sch 5 p3'!E37","v":6166},null,{"$f":"'Sch 5 p1'!G37+'Sch 5 p2'!G37+'Sch 5 p3'!G37","v":0},18,null,null,null,null,null,null,null,null,null,{"$f":"E37-'Sch 5 p3'!E37-'Sch 5 p2'!E37-'Sch 5 p1'!E37","v":0},{"$f":"G37-'Sch 5 p3'!G37-'Sch 5 p2'!G37-'Sch 5 p1'!G37","v":0}]
[{"$f":"A37+1","v":19},"Gas Generation",null,null,{"$f":"'Sch 5 p1'!E38+'Sch 5 p2'!E38+'Sch 5 p3'!E38","v":60281747},null,{"$f":"'Sch 5 p1'!G38+'Sch 5 p2'!G38+'Sch 5 p3'!G38","v":47670829},19,null,null,null,null,null,null,null,null,null,{"$f":"E38-'Sch 5 p3'!E38-'Sch 5 p2'!E38-'Sch 5 p1'!E38","v":0},{"$f":"G38-'Sch 5 p3'!G38-'Sch 5 p2'!G38-'Sch 5 p1'!G38","v":0}]
[{"$f":"A38+1","v":20},"Financial Hedges Gains/Losses & Transactional Fees",null,null,{"$f":"'Sch 5 p1'!E39+'Sch 5 p2'!E39+'Sch 5 p3'!E39","v":482546},null,{"$f":"'Sch 5 p1'!G39+'Sch 5 p2'!G39+'Sch 5 p3'!G39","v":0},20]
[null,"Purchases through MISO"]
[{"$f":"A39+1","v":21},"   Wind Purchase Power Agreement Purchases",null,null,{"$f":"'Sch 5 p1'!E41+'Sch 5 p2'!E41+'Sch 5 p3'!E41","v":23575450},null,{"$f":"'Sch 5 p1'!G41+'Sch 5 p2'!G41+'Sch 5 p3'!G41","v":23951971},21,null,null,null,null,null,null,null,null,null,{"$f":"E41-'Sch 5 p3'!E41-'Sch 5 p2'!E41-'Sch 5 p1'!E41","v":0},{"$f":"G41-'Sch 5 p3'!G41-'Sch 5 p2'!G41-'Sch 5 p1'!G41","v":0}]
[{"$f":"A41+1","v":22},"   Non-Wind PPA Market Purchases",null,null,{"$f":"'Sch 5 p1'!E42+'Sch 5 p2'!E42+'Sch 5 p3'!E42","v":44665211},null,{"$f":"'Sch 5 p1'!G42+'Sch 5 p2'!G42+'Sch 5 p3'!G42","v":6835347},22,null,null,null,null,null,null,null,null,null,{"$f":"E42-'Sch 5 p3'!E42-'Sch 5 p2'!E42-'Sch 5 p1'!E42","v":0},{"$f":"G42-'Sch 5 p3'!G42-'Sch 5 p2'!G42-'Sch 5 p1'!G42","v":0}]
[{"$f":"A42+1","v":23},"   Other",null,null,{"$f":"'Sch 5 p1'!E43+'Sch 5 p2'!E43+'Sch 5 p3'!E43","v":7482},null,{"$f":"'Sch 5 p1'!G43+'Sch 5 p2'!G43+'Sch 5 p3'!G43","v":0},23,null,null,null,null,null,null,null,null,null,{"$f":"E43-'Sch 5 p3'!E43-'Sch 5 p2'!E43-'Sch 5 p1'!E43","v":0},{"$f":"G43-'Sch 5 p3'!G43-'Sch 5 p2'!G43-'Sch 5 p1'!G43","v":0}]
[{"$f":"A43+1","v":24},"MISO Components of Cost of Fuel",null,null,{"$f":"'Sch 5 p1'!E44+'Sch 5 p2'!E44+'Sch 5 p3'!E44","v":11144778},null,{"$f":"'Sch 5 p1'!G44+'Sch 5 p2'!G44+'Sch 5 p3'!G44","v":4363569},24,null,null,null,null,null,null,null,null,null,{"$f":"E44-'Sch 5 p3'!E44-'Sch 5 p2'!E44-'Sch 5 p1'!E44","v":0},{"$f":"G44-'Sch 5 p3'!G44-'Sch 5 p2'!G44-'Sch 5 p1'!G44","v":0}]
[{"$f":"A44+1","v":25},"Purchased Power other than MISO",null,null,{"$f":"'Sch 5 p1'!E45+'Sch 5 p2'!E45+'Sch 5 p3'!E45","v":3424862},null,{"$f":"'Sch 5 p1'!G45+'Sch 5 p2'!G45+'Sch 5 p3'!G45","v":3744464},25,null,null,null,null,null,null,null,null,null,{"$f":"E45-'Sch 5 p3'!E45-'Sch 5 p2'!E45-'Sch 5 p1'!E45","v":0},{"$f":"G45-'Sch 5 p3'!G45-'Sch 5 p2'!G45-'Sch 5 p1'!G45","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"`"]
[null,"LESS:"]
[]
[{"$f":"A45+1","v":26},"   Inter-System Sales through MISO",null,null,{"$f":"'Sch 5 p1'!E49+'Sch 5 p2'!E49+'Sch 5 p3'!E49","v":2207067},null,{"$f":"'Sch 5 p1'!G49+'Sch 5 p2'!G49+'Sch 5 p3'!G49","v":20851963},{"$f":"A49","v":26},null,null,null,null,null,null,null,null,null,{"$f":"E49-'Sch 5 p3'!E49-'Sch 5 p2'!E49-'Sch 5 p1'!E49","v":0},{"$f":"G49-'Sch 5 p3'!G49-'Sch 5 p2'!G49-'Sch 5 p1'!G49","v":0}]
[{"$f":"A49+1","v":27},"   Inter-System Sales other than MISO",null,null,{"$f":"'Sch 5 p1'!E50+'Sch 5 p2'!E50+'Sch 5 p3'!E50","v":0},null,{"$f":"'Sch 5 p1'!G50+'Sch 5 p2'!G50+'Sch 5 p3'!G50","v":0},27,null,null,null,null,null,null,null,null,null,{"$f":"E50-'Sch 5 p3'!E50-'Sch 5 p2'!E50-'Sch 5 p1'!E50","v":0},{"$f":"G50-'Sch 5 p3'!G50-'Sch 5 p2'!G50-'Sch 5 p1'!G50","v":0}]
[{"$f":"A50+1","v":28},"   Non-Jurisdictional Retail Sales",null,null,{"$f":"'Sch 5 p1'!E51+'Sch 5 p2'!E51+'Sch 5 p3'!E51","v":0},null,{"$f":"'Sch 5 p1'!G51+'Sch 5 p2'!G51+'Sch 5 p3'!G51","v":0},28,null,null,null,null,null,null,null,null,null,{"$f":"E51-'Sch 5 p3'!E51-'Sch 5 p2'!E51-'Sch 5 p1'!E51","v":0},{"$f":"G51-'Sch 5 p3'!G51-'Sch 5 p2'!G51-'Sch 5 p1'!G51","v":0}]
[{"$f":"A51+1","v":29},"   Transmission Losses",null,null,{"$f":"'Sch 5 p1'!E52+'Sch 5 p2'!E52+'Sch 5 p3'!E52","v":253044},null,{"$f":"'Sch 5 p1'!G52+'Sch 5 p2'!G52+'Sch 5 p3'!G52","v":1201802},29,null,null,null,null,null,null,null,null,null,{"$f":"E52-'Sch 5 p3'!E52-'Sch 5 p2'!E52-'Sch 5 p1'!E52","v":0},{"$f":"G52-'Sch 5 p3'!G52-'Sch 5 p2'!G52-'Sch 5 p1'!G52","v":0}]
[{"$f":"A52+1","v":30},"   Lakefield PPA Adjustment",null,null,{"$f":"'Sch 5 p1'!E53+'Sch 5 p2'!E53+'Sch 5 p3'!E53","v":277558},null,{"$f":"'Sch 5 p1'!G53+'Sch 5 p2'!G53+'Sch 5 p3'!G53","v":1202086},30,null,null,null,null,null,null,null,null,null,{"$f":"E53-'Sch 5 p3'!E53-'Sch 5 p2'!E53-'Sch 5 p1'!E53","v":0},{"$f":"G53-'Sch 5 p3'!G53-'Sch 5 p2'!G53-'Sch 5 p1'!G53","v":0}]
[{"$f":"A53+1","v":31},"   Purchased Power in Excess",null,null,{"$f":"'Sch 5 p1'!E54+'Sch 5 p2'!E54+'Sch 5 p3'!E54","v":0},null,{"$f":"'Sch 5 p1'!G54+'Sch 5 p2'!G54+'Sch 5 p3'!G54","v":0},31,null,null,null,null,null,null,null,null,null,{"$f":"E54-'Sch 5 p3'!E54-'Sch 5 p2'!E54-'Sch 5 p1'!E54","v":0},{"$f":"G54-'Sch 5 p3'!G54-'Sch 5 p2'!G54-'Sch 5 p1'!G54","v":0}]
[]
[{"$f":"A54+1","v":32},"Total Fuel Costs (F)",null,null,{"$f":"SUM(E34:E45)-SUM(E48:E54)","v":183597994},null,{"$f":"SUM(G34:G45)-SUM(G48:G54)","v":118872332},32,null,null,null,null,null,null,null,null,null,{"$f":"E56-'Sch 5 p3'!E56-'Sch 5 p2'!E56-'Sch 5 p1'!E56","v":0},{"$f":"G56-'Sch 5 p3'!G56-'Sch 5 p2'!G56-'Sch 5 p1'!G56","v":0}]
[]
[{"$f":"A56+1","v":33},"F / S (Mills/kWh)",null,null,{"$f":"IF(E30=0,0,ROUND(E56/E30,3))","v":53.988},null,{"$f":"IF(G30=0,0,ROUND(G56/G30,3))","v":33.878999999999998},33]
[]
[null,"Weighted Average Deviation",null,null,{"$f":"IF(E58=0,0,ROUND((G58-E58)/E58,4))","v":-0.3725}]
[null,null,null,"        "]
[]
[]
[null,"Does not appear on printout - Check figures only"]
[null,"Analysis of variance between actual and estimated costs"]
[null,null,null,null,"Actual per FAC",null,"Estimated"]
[null,"Avg cost of fuel (mills / kWh)","Formula checks:"]
[null,"Steam Generation","should be zero",null,{"$f":"SUM(E14:E23)-SUM(E25:E28)-E30","v":0}]
[null,"Other Generation","should be zero",null,{"$f":"E44-'Sch 6'!H28-'Sch 6'!F28-'Sch 6'!D28","v":0}]
[null,"Total Generation","should be zero - rounding",null,{"$f":"SUM(E34:E38)-FCA_A8C!S31-FCA_A8B!S31-FCA_A8A!S31","v":-0.92000000178813934}]
[null,"Purchased Power","should be zero",null,{"$f":"SUM(E14:E18)-FCA_A8C!C31-FCA_A8B!C31-FCA_A8A!C31","v":0}]
[null,"Intersystem sales","should be zero",null,{"$f":"SUM(E39:E45)-FCA_A10C!J62-FCA_A10B!J69-FCA_A10A!J70","v":-0.39999999850988388}]
[]
[]
[]
[null,{"$f":"$B$68","v":"Steam Generation"}]
[null,{"$f":"$B$69","v":"Other Generation"}]
[null,"Total Generation"]
[null,{"$f":"$B$71","v":"Purchased Power"}]
[null,{"$f":"$B$72","v":"Intersystem sales"}]
[]
[]
[]
[null,{"$f":"$B$68","v":"Steam Generation"}]
[null,{"$f":"$B$69","v":"Other Generation"}]
[null,"Total Generation"]
[null,{"$f":"$B$71","v":"Purchased Power"}]
[null,{"$f":"$B$72","v":"Intersystem sales"}]
[]
[]
[]
[null,{"$f":"$B$68","v":"Steam Generation"}]
[null,{"$f":"$B$69","v":"Other Generation"}]
[null,"Total Generation"]
[null,{"$f":"$B$71","v":"Purchased Power"}]
[null,{"$f":"$B$72","v":"Intersystem sales"}]

{"sheet":"Sch 6","index":13,"n_rows":46,"n_cols":24,"rows_kept":46,"cut":false,"hidden":false,"merged":[[4,0,4,7],[5,0,5,7],[6,0,6,7]]}
[null,{"$f":"'Data Input'!A7","v":"Cause No. 38703-FAC135"},null,null,null,null,null,"Applicant's Attachment NHC-1"]
[null,null,null,null,null,null,null,"Schedule 6"]
[null,null,null,null,null,null,null,"Page 1 of 1"]
[]
[{"$f":"'Sch 1'!A4","v":"AES INDIANA"}]
["Determination of MISO Components of Fuel Cost"]
[{"$f":"'Date Input'!B12","v":"November, December 2021, and January 2022"}]
[]
[null,null,null,"Total",null,"Total",null,"Total"]
[null,null,null,{"$f":"'Date Input'!B9","v":"November"},null,{"$f":"'Date Input'!B10","v":"December"},null,{"$f":"'Date Input'!B11","v":"January"}]
[null,null,null,"(A)",null,"(B)",null,"(C)"]
["Line",null,null,null,null,null,null,null,"Line"]
[" No. ","Energy Market FAC Adjustment Components",null,null,null,null,null,null," No. "]
[1,"   Delta LMP1 ",null,7304202,null,2957873,null,5817848,{"$f":"A14","v":1}]
[2,"   FTR (Revenue) / Expenses",null,660058,null,-127372,null,-3683354,{"$f":"A15","v":2}]
[3,"   RT Marg. Loss Surplus Credit",null,-843785,null,-444694,null,-804405,3]
[4,"   Virtuals Bids and Offers for Load",null,0,null,0,null,0,4]
[5,"   DA & RAC Recovery of Unit Commitment Costs",null,-253839,null,-49895,null,-106434,5]
["5a","   RSG 1st Pass Charges",null,68995,null,29176,null,95606,"5a"]
["5b","   RSG 2nd Pass Distribution Correction",null,0,null,0,null,0,"5b"]
[6,"   Inadvertent Energy",null,-59739,null,23638,null,-3850,6]
[7,"   Ancillary Services Revenue",null,-47938,null,-30384,null,-19250,7]
[8,"   Ancillary Services Costs",null,120547,null,119276,null,136250,8]
[9,"   Ancillary Services Incentive to Follow Dispatch2",null,137229,null,70905,null,80927,9]
[10,"   Ramp Capability3",null,-4280,null,-1808,null,3275,10]
[11,"  MISO Transmission Owner's Payment not on Settlement Statement - credit to FAC.",null,0,null,0,null,0,11]
[]
[11,"Total (Columns A, B, & C to Schedule 5, line 24)",null,{"$f":"SUM(D14:D26)","v":7081450},null,{"$f":"SUM(F14:F26)","v":2546715},null,{"$f":"SUM(H14:H26)","v":1516613},11]
[]
[]
[]
[]
[null,"Negative amount is a credit to expense (payment from MISO)"]
[null,"Positive amount is a debit to expense (payment to MISO)"]
[]
[]
[null,"1Differential of MCC and MLC between the load zone and generation pricing nodes"]
[null,"2Net of Contingency Reserve Deployment Failure Credit"]
[null,"3Ramp Capability Payments Net of Uplift"]
[]
[]
[]
[]
[]
[]
[null,"Formula Check",null,{"$f":"SUM(D14:H26)-SUM(D28:H28)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"`"]

{"sheet":"Sch 7 ","index":14,"n_rows":96,"n_cols":24,"rows_kept":96,"cut":false,"hidden":false,"merged":[[3,0,3,6],[4,0,4,6]]}
[null,{"$f":"'Data Input'!A7","v":"Cause No. 38703-FAC135"},null,null,null,null,"Applicant's Attachment NHC-1"]
[null,null,null,null,null,null,"Schedule 7"]
[null,null,null,null,null,null,"Page 1 of 1"]
["AES INDIANA"]
["MISO Charges by Month by Charge Type"]
[]
[]
["Line",null,{"$f":"'Date Input'!B17","v":"2021-11-16"},null,{"$f":"'Date Input'!B18","v":"2021-12-17"},null,{"$f":"'Date Input'!B19","v":"2022-01-17"},"Line"]
[" No. ","Charge Type","Invoice Total",null,"Invoice Total",null,"Invoice Total"," No. "]
[]
[1,"Day Ahead Market Administration Amount",148918,null,183018,null,216761,{"$f":"A11","v":1}]
[{"$f":"A11+1","v":2},"Day Ahead Regulation Amount",-9648,null,-6778,null,-1283,{"$f":"A12","v":2}]
[{"$f":"A12+1","v":3},"Day Ahead Spinning Reserve Amount",-37475,null,-2196,null,-214,3]
[4,"Day-Ahead Short-Term Reserve Amount",0,null,-6287,null,-2896]
[5,"Day Ahead Supplemental Reserve Amount",0,null,0,null,0,5]
[6,"Day Ahead Asset Energy Amount",28292539,null,10302693,null,6734382,6]
[7,"Day Ahead Financial Bilateral Transaction Congestion Amount",0,null,0,null,0,7]
[8,"Day Ahead Financial Bilateral Transaction Loss Amount",0,null,0,null,0,8]
[9,"Day Ahead Congestion Rebate on Carve-Out Grandfathered Agrmnts",0,null,0,null,0,9]
[10,"Day Ahead Losses Rebate on Carve-Out Grandfathered Agrmnts",0,null,0,null,0,10]
[11,"Day Ahead Congestion Rebate on Option B Grandfathered Agrmnts",0,null,0,null,0,11]
[12,"Day Ahead Losses Rebate on Option B Grandfathered Agrmnts",0,null,0,null,0,12]
[13,"Day Ahead Non-Asset Energy Amount",0,null,0,null,0,13]
[14,"Day Ahead Ramp Capability Amount",-11938,null,-5263,null,-2391,14]
[15,"Day Ahead Revenue Sufficiency Guarantee Distribution Amount",64595,null,30814,null,50760,15]
[16,"Day Ahead Revenue Sufficiency Guarantee Make Whole Payment Amt",-131579,null,-40344,null,-101960,16]
[17,"Day Ahead Schedule 24 Allocation Amount",22586,null,25910,null,33581,17]
[18,"Day Ahead Virtual Energy Amount",0,null,0,null,0,18]
[null,"Day Ahead Subtotal",{"$f":"SUM(C11:C28)","v":28337998},null,{"$f":"SUM(E11:E28)","v":10481567},null,{"$f":"SUM(G11:G28)","v":6926740}]
[]
[{"$f":"A28+1","v":19},"Financial Transmission Rights Market Administration Amount",5228,null,7453,null,8975,{"$f":"A31","v":19}]
[{"$f":"A31+1","v":20},"Auction Revenue Rights Transaction Amount",-231072,null,-264066,null,-264066,20]
[{"$f":"A32+1","v":21},"Financial Transmission Rights Annual Transaction Amount",189043,null,229027,null,229027,21]
[22,"Auction Revenue Rights Infeasible Uplift Amount",60108,null,23861,null,23861,22]
[23,"Auction Revenue Rights Stage 2 Distribution Amount",-146019,null,-110708,null,-110708,23]
[24,"Financial Transmission Rights Full Funding Guarantee Amount",-15826,null,103407,null,0,24]
[25,"Financial Transmission Guarantee Uplift Amount",12866,null,-128357,null,0,25]
[26,"Financial Transmission Rights Hourly Allocation Amount",806623,null,154565,null,-3521487,26]
[27,"Financial Transmission Rights Monthly Allocation Amount",-15665,null,-31694,null,-39981,27]
[28,"Financial Transmission Rights Monthly Transaction Amount",0,null,0,null,0,28]
[29,"Financial Transmission Rights Transaction Amount",0,null,0,null,0,29]
[30,"Financial Transmission Rights Yearly Allocation Amount",0,null,-103407,null,0,30]
[null,"Financial Transmission Rights Subtotal",{"$f":"SUM(C31:C42)","v":665286},null,{"$f":"SUM(E31:E42)","v":-119919},null,{"$f":"SUM(G31:G42)","v":-3674379}]
[]
[{"$f":"A42+1","v":31},"Real Time Market Administration Amount",18296,null,22305,null,25347,{"$f":"A45","v":31}]
[{"$f":"A45+1","v":32},"Contingency Reserve Deployment Failure Charge Amount",21124,null,0,null,0,32]
[{"$f":"A46+1","v":33},"Excessive Energy Amount",-28447,null,-19948,null,-15372,33,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"`"]
[34,"Real Time Excessive Deficient Energy Deployment Charge Amount",7979,null,8950,null,7768,34]
[35,"Net Regulation Adjustment Amount",0,null,0,null,0,35]
[36,"Non-Excessive Energy Amount",3397244,null,1400811,null,4556831,36]
[37,"Real Time Regulation Amount",-6115,null,10495,null,-2817,37]
[38,"Regulation Cost Distribution Amount",58361,null,46568,null,56440,38]
[39,"Real Time Spinning Reserve Amount",5303,null,-12444,null,-593,39]
[40,"Spinning Reserve Cost Distribution Amount",54924,null,39436,null,35674,40]
[41,"Real Time Short-Term Reserve Amount",0,null,-12547,null,-11447,41]
[42,"Real-Time Short-Term Reserve Deployment Failure Charge Amount",0,null,0,null,0,42]
[43,"Short-Term Reserve Cost Distribution Amount",0,null,26609,null,35042,43]
[44,"Real Time Supplemental Reserve Amount",-2,null,-627,null,0,44]
[45,"Supplemental Reserve Cost Distribution Amount",7262,null,6664,null,9093,45]
[46,"Real Time Asset Energy Amount",3257478,null,510698,null,-251609,46]
[47,"Real Time Demand Response Allocation Uplift Charge",111934,null,62128,null,73466,47]
[48,"Real Time Financial Bilateral Transaction Congestion Amount",0,null,0,null,0,48]
[49,"Real Time Financial Bilateral Transaction Loss Amount",0,null,0,null,0,49]
[50,"Real Time Congestion Rebate on Carve-Out Grandfathered Agrmnts",0,null,0,null,0,50]
[51,"Real Time Losses Rebate on Carve-Out Grandfathered Agrmnts",0,null,0,null,0,51]
[52,"Real Time Distribution of Losses Amount",-843785,null,-444694,null,-804405,52]
[53,"Real Time Miscellaneous Amount",2857,null,-395,null,9161,53]
[54,"Real Time MVP Distribution Amount",-3055,null,-6501,null,-6977,54]
[55,"Real Time Non-Asset Energy Amount",0,null,0,null,0,55]
[56,"Real Time Net Inadvertent Distribution Amount",-59739,null,23638,null,-3850,56]
[57,"Real Time Price Volatility Make Whole Payment",-132831,null,-133499,null,-319348,57]
[58,"Real Time Resource Adequacy Auction Amount",-24416,null,-25230,null,-25230,58]
[59,"Real Time Ramp Capability Amount",-3911,null,-4551,null,-2071,59]
[60,"Real Time Revenue Neutrality Uplift Amount",1138444,null,209478,null,212313,60]
[61,"Real Time Revenue Sufficiency Guarantee First Pass Dist Amount",67651,null,31393,null,109089,61]
[62,"Real Time Revenue Sufficiency Guarantee Make Whole Payment Amt",-187684,null,-46442,null,-73505,62]
[63,"Real Time Schedule 24 Allocation Amount",2780,null,3160,null,3923,63]
[64,"Real Time Schedule 24 Distribution Amount",-63425,null,-65202,null,-72769,64]
[65,"Real Time Schedule 49 Cost Distribution Amount",4937,null,4843,null,5366,65]
[66,"Real Time Virtual Energy Amount",0,null,0,null,0,66]
[null,"Real Time Subtotal",{"$f":"SUM(C45:C80)","v":6803164},null,{"$f":"SUM(E45:E80)","v":1635096},null,{"$f":"SUM(G45:G80)","v":3549520}]
[]
[null,"Grand Total",{"$f":"C81+C43+C29","v":35806448},null,{"$f":"E81+E43+E29","v":11996744},null,{"$f":"G81+G43+G29","v":6801881}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Check Figures"]
[null,"Should be less than 5; rounding",{"$f":"SUM(C11:G28)-SUM(C29:G29)","v":0}]
[null,"Should be less than 5; rounding",{"$f":"SUM(C31:G42)-SUM(C43:G43)","v":0}]
[null,"Should be less than 5; rounding",{"$f":"SUM(C45:G80)-SUM(C81:G81)","v":0}]
[null,"Should be less than 5; rounding",{"$f":"SUM(C11:G28)+SUM(C31:G42)+SUM(C45:G80)-SUM(C83:G83)","v":0}]

{"sheet":"Ex2, pg 1","index":15,"n_rows":59,"n_cols":24,"rows_kept":59,"cut":false,"hidden":false,"merged":[[10,14,10,15],[12,14,12,15],[11,14,11,15],[37,2,37,12],[36,2,36,12],[35,2,35,12]]}
[null,null,null," "]
[]
[{"$f":"+'Data Input'!A7","v":"Cause No. 38703-FAC135"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Applicant's Attachment NHC-2"]
[]
["AES INDIANA"]
["Statement of Jurisdictional Electric Operating Income for the Twelve Months Ended January 31, 2022"]
["(In $000's except where otherwise stated)"]
[null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,"Per Books For The Twelve Months Ended"]
[null,null,null,null,null," ",null,"2022-01-31"]
[null,null,null,null,null,null,null,"Total Electric",null,null,null,null,null,null,"Applicable to"]
["Line",null,null,null,null,null,null,"For the Twelve Months",null,null,null,null,"MISO",null,"Jurisdictional",null,null,null,"Line"]
["No.",null,"Description",null,null,null,null,"Ended January 31, 2022",null,null,null,null,"Attachment GG",null,"Retail Customers",null,null,null,"No."]
[]
[]
[1,null,"Operating Revenues",null,null,null,null,"$",1452350,null,null,"$",2636.1120700000001,null,"$",{"$f":"I16-M16","v":1449713.88793},null,null,{"$f":"A16","v":1}]
[]
["2",null,"Operating Expenses:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A18","v":"2"}]
["3",null,"  Operation and Maintenance Expenses",null,null,null,null,"$",882293,null,null,"$",969.15190687852873,null,"$",{"$f":"I19-M19","v":881323.84809312143},null,null,"3"]
["4",null,"  Depreciation and Amortization",null,null,null,null,null,257105,null,null,null,366.38506000000001,null,null,{"$f":"I20-M20","v":256738.61494},null,null,"4"]
[]
[{"$f":"A20+1","v":5},null,"  Taxes Other than Income Taxes:",null,null,null,null,null,45305,null,null,null,73.5619881824679,null,null,{"$f":"I22-M22","v":45231.438011817532},null,null,5]
["9",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"I23-M23","v":0},null,null,"9"]
[10,null,"  Miscellaneous - Other Expenses",null,null,null,null,null,0,null,null,null,null,null,null,{"$f":"I24-M24","v":0},null,null,10]
[]
[{"$f":"+A22+1","v":6},null,"  Income Taxes:",null,null,null,null,null,39365.985261600006,null,null,null,307,null,null,{"$f":"I26-M26","v":39058.985261600006},null,null,{"$f":"A26","v":6}]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[{"$f":"A26+1","v":7},null,"Total Operating Expenses",null,null,null,null,"$",{"$f":"SUM(I19:I26)","v":1224068.9852616},null,null,"$",{"$f":"SUM(M19:M26)","v":1716.0989550609968},null,"$",{"$f":"SUM(P19:P26)","v":1222352.8863065392},null,null,{"$f":"A28","v":7}]
[]
[{"$f":"A28+1","v":8},null,"Operating Income",null,null,null,null,"$",{"$f":"I16-I28","v":228281.0147384},null,null,"$",{"$f":"+M16-M28","v":920.01311493900334},null,"$",{"$f":"I30-M30","v":227361.00162346099},null,null,{"$f":"A30","v":8}]
[]
[]
[]
[]
[]
[null,null,"(d)(2) Test (In $000's)"]
[null,null,"Summary of Increase in Operating Expenses Applicable to Jurisdictional Retail Customers"]
[null,null,"For the Twelve Months Ended January 31, 2022"]
[]
[null,null,null,null,null,"Per Cause Nos.",null,"Per Books",null,null,null,null,"Increase"]
[null,null,null,null,null,45029,null,null,"2022-01-31",null,null,null,"(Decrease)",null,null,null,null,null,null,null,null,null,null,"`"]
[]
[{"$f":"A30+1","v":9},null,"Total Operating Expenses ",null,"$",1193106,null,"$",{"$f":"+P28","v":1222352.8863065392},null,null,"$",{"$f":"+I43-F43","v":29246.886306539178},null,null,null,null,null,{"$f":"A43","v":9}]
[{"$f":"A43+1","v":10},null,"Fuel Costs ",null,null,436216,null,null,432388,null,null,null,{"$f":"+I44-F44","v":-3828},null,null,null,null,null,{"$f":"A44","v":10}]
[{"$f":"A44+1","v":11},null,"Operating Expenses Excluding Fuel Costs",null,"$",{"$f":"+F43-F44","v":756890},null,"$",{"$f":"+I43-I44","v":789964.88630653918},null,null,"$",{"$f":"+I45-F45","v":33074.886306539178},null,null,null,null,null,{"$f":"A45","v":11}]
[]
[]
[]
[]
[]
[]
[null,null,"(d)(3) Test (In $'s)"]
[]
[{"$f":"A45+1","v":12},null,"Jurisdictional Retail Electric Operating Income (January 31, 2022)",null,null,null,null,"$",{"$f":"ROUND($P30*1000,6-LEN(INT($P30*1000)))","v":227361000},null,null,null,null,null,null,null,null,null,{"$f":"A54","v":12}]
[{"$f":"A54+1","v":13},null,"Total Authorized Operating Income (1)",null,null,null,null,null,{"$f":"+'Ex 3-Authorized Return'!E53","v":226529000},null,null,null,null,"                        ",null,null,null,null,{"$f":"A55","v":13}]
[{"$f":"A55+1","v":14},null,"Excess/(Deficiency)",null,null,null,null,"$",{"$f":"+I54-I55","v":832000},null,null,null,null,null,null,null,null,null,{"$f":"A56","v":14}]
[]
[]
[null,null,"(1 )  Calculated on Applicant's Exhibit 3."]

{"sheet":"Ex 3-Authorized Return","index":16,"n_rows":72,"n_cols":24,"rows_kept":72,"cut":false,"hidden":false,"merged":[[56,0,56,5],[3,0,3,4],[4,0,4,4],[5,0,5,4]]}
[{"$f":"'Data Input'!A7","v":"Cause No. 38703-FAC135"},null,null,null,"Applicant's Attachment NHC-3"]
[]
[]
[{"$f":"'Sch 1'!$A$4","v":"AES INDIANA"}]
["Determination of Authorized Return"]
[{"$f":"\"For the Twelve Months Ended \" &'Date Input'!B14","v":"For the Twelve Months Ended January 2022"}]
["     Line       ",null,null,null,null,"     Line       "]
["No.",null,null,null,null,"No."]
[]
[1,"Operating Income per Cause No. 45029",null,null,220076000,{"$f":"A10","v":1}]
[null,null,null,null,null,null,null,"."]
[{"$f":"A10+1","v":2},"Effective February 2021 ",null,null,null,{"$f":"A12","v":2}]
[{"$f":"A12+1","v":3},"Allowed Return on CCT Utility Plant per Cause No. 42170-ECR33 (2)",1483145,null,null,3]
[{"$f":"A13+1","v":4},"Jurisdictional Portion",1,null,null,4]
[{"$f":"A14+1","v":5},"Jurisdictional Total for Cause No. 42170-ECR33",{"$f":"ROUND(C13*C14,0)","v":1483145},null,null,5]
[{"$f":"A15+1","v":6},"Proration for Cause No. 42170-ECR33","28/365",null,null,6]
[{"$f":"A16+1","v":7},"Total for Cause No. 42170-ECR33",null,null,{"$f":"ROUND(C15*H17/1000,0)*1000","v":114000},7,null,{"$f":"ROUND(28/365,6)","v":7.6712000000000002E-2}]
[]
[{"$f":"A17+1","v":8},"Effective for March 2021 - January 2022",null,null,null,{"$f":"A19","v":8}]
[{"$f":"A19+1","v":9},"Allowed Return on CCT Utility Plant per Cause No. 42170-ECR34 (2)",1541335,null,null,9]
[{"$f":"A20+1","v":10},"Jurisdictional Portion",1,null,null,10]
[{"$f":"A21+1","v":11},"Jurisdictional Total for Cause No. 42170-ECR34",{"$f":"ROUND(C20*C21,0)","v":1541335},null,null,11]
[{"$f":"A22+1","v":12},"Proration for Cause No. 42170-ECR34","337/365",null,null,12]
[{"$f":"A23+1","v":13},"Total for Cause No. 42170-ECR34",null,null,{"$f":"ROUND(C22*H24/1000,0)*1000","v":1423000},13,null,{"$f":"ROUND(337/365,6)","v":0.923288}]
[]
[{"$f":"A24+1","v":14},"Effective for February 2021 - October 2021 ",null,null,null,{"$f":"A26","v":14}]
[{"$f":"A26+1","v":15},"Allowed Return on TDISC-1 Distribution Utility Plant per Cause No. 45264-TDSIC-1 (2)",2551960,null,null,15]
[{"$f":"A27+1","v":16},"Jurisdictional Portion",1,null,null,16]
[{"$f":"A28+1","v":17},"Jurisdictional Total for Cause No. 45264-TDSIC-1",{"$f":"ROUND(C27*C28,0)","v":2551960},null,null,17]
[{"$f":"A29+1","v":18},"Proration for Cause No.45264-TDSIC-1","273/365",null,null,18]
[{"$f":"A30+1","v":19},"Total for Cause No. 45264-TDSIC-1",null,null,{"$f":"ROUND(C29*H31/1000,0)*1000","v":1909000},19,null,{"$f":"ROUND(273/365,6)","v":0.74794499999999997}]
[]
[{"$f":"A31+1","v":20},"Effective for February 2021 - October 2021",null,null,null,{"$f":"A33","v":20}]
[{"$f":"A33+1","v":21},"Allowed Return on TDISC-1 - Transmission Utility Plant per Cause No. 45264-TDSIC-1 (2)",530592,null,null,21]
[{"$f":"A34+1","v":22},"Jurisdictional Portion",1,null,null,22]
[{"$f":"A35+1","v":23},"Jurisdictional Total for Cause No. 45264-TDSIC-1",{"$f":"ROUND(C34*C35,0)","v":530592},null,null,23]
[{"$f":"A36+1","v":24},"Proration for Cause No.45264-TDSIC-1","273/365",null,null,24]
[{"$f":"A37+1","v":25},"Total for Cause No. 45264-TDSIC-1",null,null,{"$f":"ROUND(C36*H38/1000,0)*1000","v":397000},25,null,{"$f":"ROUND(273/365,6)","v":0.74794499999999997}]
[]
[{"$f":"+A38+1","v":26},"Effective for November 2021 - January 2022",null,null,null,{"$f":"A40","v":26}]
[{"$f":"+A40+1","v":27},"Allowed Return on TDISC-3 Distribution Utility Plant per Cause No. 45264-TDSIC-3 (2)",8370218,null,null,27]
[{"$f":"+A41+1","v":28},"Jurisdictional Portion",1,null,null,28]
[29,"Jurisdictional Total for Cause No. 45264-TDSIC-3",{"$f":"ROUND(C41*C42,0)","v":8370218},null,null,29]
[30,"Proration for Cause No.45264-TDSIC-3","92/365",null,null,30]
[31,"Total for Cause No. 45264-TDSIC-3",null,null,{"$f":"ROUND(C43*H45/1000,0)*1000","v":2110000},31,null,{"$f":"ROUND(92/365,6)","v":0.25205499999999997}]
[]
[{"$f":"A45+1","v":32},"Effective for November 2021 - January 2022",null,null,null,{"$f":"A47","v":32}]
[{"$f":"A47+1","v":33},"Allowed Return on TDISC-3 - Transmission Utility Plant per Cause No. 45264-TDSIC-3 (2)",1982306,null,null,33]
[{"$f":"A48+1","v":34},"Jurisdictional Portion",1,null,null,34]
[{"$f":"A49+1","v":35},"Jurisdictional Total for Cause No. 45264-TDSIC-3",{"$f":"ROUND(C48*C49,0)","v":1982306},null,null,35]
[{"$f":"A50+1","v":36},"Proration for Cause No.45264-TDSIC-3","92/365",null,null,36]
[{"$f":"A51+1","v":37},"Total for Cause No. 45264-TDSIC-3",null,null,{"$f":"ROUND(C50*H52/1000,0)*1000","v":500000},37,null,{"$f":"ROUND(92/365,6)","v":0.25205499999999997}]
[{"$f":"A38+1","v":26},"Total Authorized Operating Income",null,null,{"$f":"SUM(E10:E52)","v":226529000},{"$f":"A53","v":26}]
[]
[]
[]
["(2) The Commission requires that, for purposes of computing the authorized net operating income for IC 8-1-2-42(d)(2) and \nIC 8-1-2-42(d)(3), the jurisdictional portion of the  increased return shall be phased-in over the appropriate period of time that the Applicant's net operating income is affected by this earnings modification resulting from the Commission's approval of the QPCP Construction Cost Rider.  The following example may be helpful in implementing the appropriate phase-in: Assume a ECCRA Order is effective and implemented Feb. 1, 2015.  Assume the test period for the first FAC filing after the ECCRA Order covers the twelve months ended March 31, 2015.  The increase to net operating income resulting from the ECCRA Order should be 59/365 of the total additional earnings authorized by the Commission's Order in the ECCRA.  Assuming all things remain constant, the next FAC filing would reflect 150/365 of the total additional ECCRA earnings.                                                                                                                    "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"`"]

{"sheet":"Ex 4-Earnings Test","index":17,"n_rows":45,"n_cols":24,"rows_kept":45,"cut":false,"hidden":false,"merged":[[3,0,3,8],[4,0,4,8]]}
[{"$f":"'Data Input'!A7","v":"Cause No. 38703-FAC135"},null,null,null,null,null,null,null,"Applicant's Attachment NHC-4"]
[]
[]
["AES INDIANA"]
["Earnings Test Summary"]
[]
[null,null,"Reporting",null,"Determined",null,"Authorized"]
["FAC No.",null,"Period",null,"Return",null,"Return",null,"Differential"]
[]
[135,null,"2022-01-31",null,{"$f":"'Ex2, pg 1'!I54","v":227361000},null,{"$f":"'Ex 3-Authorized Return'!E53","v":226529000},null,{"$f":"E10-G10","v":832000},null,3]
[134,null,"2021-10-31",null,226080000,null,224682000,null,{"$f":"E11-G11","v":1398000},null,3]
[133,null,"2021-07-31",null,219585000,null,223889000,null,-4304000,null,3]
[132,null,"2021-04-30",null,232893000,null,223097000,null,9796000,null,3]
[131,null,"2021-01-31",null,227171000,null,222310000,null,{"$f":"E14-G14","v":4861000},null,3]
[130,null,"2020-10-31",null,229881000,null,221451000,null,{"$f":"E15-G15","v":8430000},null,3]
[129,null,"2020-07-31",null,242467000,null,221368000,null,{"$f":"E16-G16","v":21099000},null,3]
[128,null,"2020-04-30",null,236917000,null,221285000,null,15632000,null,3]
[127,null,"2020-01-31",null,234075000,null,221201000,null,12874000,null,3]
[126,null,"2019-10-31",null,230875000,null,218710000,null,{"$f":"+E19-G19","v":12165000},null,3]
[125,null,"2019-07-31",null,229431000,null,206716000,null,{"$f":"+E20-G20","v":22715000},null,3]
[124,null,"2019-04-30",null,217179000,null,194654169.99314123,null,22524830.006858766,null,3]
[123,null,"2019-01-31",null,212078000,null,182107611.8367348,null,{"$f":"+E22-G22","v":29970388.163265198},null,3]
[122,null,"2018-10-31",null,201730000,null,172128000,null,29602000,null,3]
[121,null,"2018-07-31",null,190971000,null,171399000,null,19572000,null,3]
[120,null,"2018-04-30",null,180892000,null,170247000,null,10645000,null,3]
[119,null,"2018-01-31",null,177867000,null,169205000,null,8662000,null,3]
[118,null,"2017-10-31",null,180108000,null,168291000,null,11817000,null,3]
[117,null,"2017-07-31",null,185397000,null,167012000,null,18385000,null,3]
[116,null,"2017-04-30",null,183962000,null,165030000,null,18932000,null,3]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I10:I29)","v":275608218.17012393},null,{"$f":"SUM(K10:K29)","v":60}]
[]
[]
[]
[null,null,"Should be zero",null,{"$f":"SUM(E10:E29)-SUM(G10:G29)-I30","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"`"]

{"sheet":"Exhibit 4a","index":18,"n_rows":54,"n_cols":24,"rows_kept":54,"cut":false,"hidden":false,"merged":[[38,3,38,5],[38,6,38,8],[5,0,5,12],[3,0,3,12],[4,0,4,12],[6,0,6,12],[7,0,7,12],[11,1,11,2]]}
[{"$f":"'Data Input'!A7","v":"Cause No. 38703-FAC135"},null,null,null,null,null,null,null,null,null,null,"Applicant's Attachment NHC-4a"]
[]
[null,null,null,null,null,null,null,null,null," ",null,null," "]
["AES INDIANA"]
["Operating Income Earnings Test"]
["Calculated Refund"]
["Period Ending January 31, 2022"]
[]
[]
[]
[]
["Line No.","FAC Period",null,"FAC No.","Determined","Authorized","Differential"]
[]
[1,null,"January 31, 2022",135,{"$f":"'Ex 4-Earnings Test'!E10","v":227361000},{"$f":"'Ex 4-Earnings Test'!G10","v":226529000},{"$f":"E14-F14","v":832000}]
[]
[2,"Accumulated Earnings Bank Differential",null,null,null,null,{"$f":"'Ex 4-Earnings Test'!I30","v":275608218.17012393}]
[]
[{"$f":"A16+1","v":3},"Over-Earnings Basis",null,null,null,null,{"$f":"G14","v":832000}]
[]
[{"$f":"A18+1","v":4},"Quarterly Convention",null,null,null,null,0.25]
[]
[{"$f":"A20+1","v":5},"Quarterly Amount - Basis for Revenue Credits (Show as Negative Value)",null,null,null,null,{"$f":"G18*G20*-1","v":-208000}]
[]
[{"$f":"A22+1","v":6},"Revenue Conversion Factor",null,null,null,null,{"$f":"I52","v":1.3575200000000001}]
[]
[{"$f":"A24+1","v":7},"Revenue Credit Amount",null,null,null,null,{"$f":"G22*G24","v":-282364.16000000003}]
[]
[]
[null,"Revenue Conversion Factor"]
[]
[8,null,"Calculated Rate of Return from page 3 of this exhibit",null,null,null,null,null,6.6500000000000004E-2]
[9,null,"Gross Rate for Borrowed Funds (1)",null,null,null,null,null,2.1999999999999999E-2]
[10,null,"Gross Rate for Other Funds (Line 8 - Line 9)",null,null,null,null,null,{"$f":"I31-I32","v":4.4500000000000005E-2}]
[]
[11,null,"Debt and Equity Revenue Conversion Factors"]
[]
[]
[]
[null,null,null,"For Debt & Expense",null,null,"For Equity"]
[null,null,null,"Statutory ",null,"Effective","Statutory ",null,"Effective"]
[null,null,null,"Rate",null,"Rate","Rate",null,"Rate"]
[null,"11a","Utility Receipts Tax",1.46E-2,null,{"$f":"ROUND((1-D44)*D42,6)","v":1.4548E-2},1.4E-2,null,{"$f":"ROUND((1-G44)*G42,6)","v":1.3950000000000001E-2}]
[null,"11b","Public Utility Fee",1.27608E-3,null,{"$f":"+D43","v":1.27608E-3},{"$f":"+F43","v":1.27608E-3},null,{"$f":"+F43","v":1.27608E-3}]
[null,"11c","Uncollectibles",3.5620000000000001E-3,null,{"$f":"+D44","v":3.5620000000000001E-3},{"$f":"+F44","v":3.5620000000000001E-3},null,{"$f":"+G44","v":3.5620000000000001E-3}]
[null,"11d","State Income Tax",4.9000000000000002E-2,null,{"$f":"(+F42/ (1-D45))*D45","v":7.4958149316508942E-4},{"$f":"+D45","v":4.9000000000000002E-2},null,{"$f":"+G45*(1-G43-G44)","v":4.8762934080000001E-2}]
[null,"11e","Federal Income Tax ",0.21,null,0,{"$f":"+D46","v":0.21},null,{"$f":"+G46*(1-I42-I43-I44-I45)","v":0.1958142870432},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"`"]
[null,"11f","Effective Rate",null,null,{"$f":"SUM(F42:F46)","v":2.0135661493165088E-2},null,null,{"$f":"SUM(I42:I46)","v":0.2633653011232}]
[]
[null,"11g","Complement (1-Line 8f)",null,null,{"$f":"1-F47","v":0.97986433850683496},null,null,{"$f":"1-I47","v":0.7366346988768}]
[]
[null,"11h","Revenue Conversion Factor for Debt & Expense",null,null,{"$f":"ROUND(1/F49,5)","v":1.0205500000000001}]
[null,"11i","Revenue Conversion Factor for Equity",null,null,null,null,null,{"$f":"ROUND(1/I49,5)","v":1.3575200000000001}]
[]
[12,null,"Revenue Conversion Factor for Capital [((Line 9 x Line 11h) + (Line 10 x Line 11i))/Line 8]",null,null,null,null,null,{"$f":"ROUND(((I32*F51)+(I33*I52))/I31,5)","v":1.24604}]

{"sheet":"FCA_A8A","index":19,"n_rows":63,"n_cols":24,"rows_kept":63,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Schedule 8A"]
[]
["AES INDIANA"]
[{"$f":"\"Summary of Fuel Issues for \"&'Date Input'!B9&\", \"&'Date Input'!C9","v":"Summary of Fuel Issues for November, 2021"}]
[]
["Line",null,null,"Net Generation",null,null,null,"Coal Issues",null,null,null,"Oil Issues",null,null,null,"Natural Gas",null,null,"Total"]
["No.","Burnings by Station","MWH",null,"%",null,"Tons",null,"Cost",null,"Gallons",null,"Cost",null,null,"Cost",null,null,"Fuel Cost"]
["(1)","(2)","(3)",null,"(4)",null,"(5)",null,"(6)",null,"(7)",null,"(8)",null,null,"(9)",null,null,"(10)"]
[null,"   Production by Coal:"]
[]
["1","   Perry K",0,null,{"$f":"ROUND((C12/C16)*100,4)","v":0},null,0,null,0,null,0,null,0,null," $",0,null," $",0]
["2","   Petersburg",184482,null,{"$f":"ROUND((C13/C31)*100,2)+0.01","v":32.519999999999996},null,95768,null,4706357,null,109946,null,268557,null,null,0,null,null,{"$f":"+I13+M13+P13","v":4974914}]
["3","   Harding Street",0,null,{"$f":"ROUND((C14/C31)*100,2)","v":0},null,0,null,0,null,0,null,0,null,null,0,null,null,{"$f":"+I14+M14+P14","v":0}]
[null,null,null,null,null,null,null,null,0]
[4,"   Total by Steam",{"$f":"SUM(C12:C15)","v":184482},null,{"$f":"SUM(E12:E15)","v":32.519999999999996},null,{"$f":"SUM(G12:G15)","v":95768},null,{"$f":"SUM(I12:I15)","v":4706357},null,{"$f":"SUM(K12:K15)","v":109946},null,{"$f":"SUM(M12:M15)","v":268557},null," $",0,null," $",{"$f":"SUM(S12:S15)","v":4974914}]
[]
[null,"   Produced by Other:"]
[]
[5,"   Eagle Valley - CCGT",1997,null,{"$f":"ROUND((C20/C31)*100,2)","v":0.35},null,0,null,0,null,0,null,0,"                                  "," $",831086,null," $",{"$f":"+I20+M20+P20","v":831086}]
[6,"   CCGT - Financial Hedges(1)",0,null,{"$f":"ROUND((C21/C31)*100,2)","v":0},null,0,null,0,null,0,null,0,null,null,0,null,null,{"$f":"+I21+M21+P21","v":0}]
[7,"   Georgetown #1 & 4",44395,null,{"$f":"ROUND((C22/C31)*100,2)","v":7.82},null,0,null,0,null,0,null,0,null,null,2906968,null,null,{"$f":"+I22+M22+P22","v":2906968}]
[8,"   Petersburg Int. Combus.",9,null,{"$f":"ROUND((C23/C31)*100,2)","v":0},null,0,null,0,null,701,null,1712,null,null,0,null,null,1712]
[9,"   Harding Street Int. Combus.",10,null,{"$f":"ROUND((C24/C31)*100,2)","v":0},null,0,null,0,null,755,null,1242.4000000000001,null,null,0,null,null,1242.4000000000001]
[10,"   Harding Street Natural Gas",336585,null,{"$f":"ROUND((C25/C31)*100,2)","v":59.31},null,0,null,0,null,728,null,1198.4000000000001,null,null,20833487,null,null,20834685.399999999]
[11,"   Rental Diesels",0,null,{"$f":"ROUND((C26/C31)*100,2)","v":0},null,0,null,0,null,0,null,0,null,null,0,null,null,0]
[12,"   Eagle Valley Int. Combus.",0,null,{"$f":"ROUND((C27/C31)*100,2)","v":0},null,0,null,0,null,0,null,0,null,null,0,null,null,0]
[]
[13,"   Total by Other",{"$f":"SUM(C20:C28)","v":382996},null,{"$f":"SUM(E20:E28)","v":67.48},null,0,null,0,null,{"$f":"SUM(K20:K28)","v":2184},null,{"$f":"SUM(M20:M28)","v":4152.8},null," $",{"$f":"SUM(P20:P28)","v":24571541},null," $",{"$f":"SUM(S20:S28)","v":24575693.799999997}]
[]
[14,"   Total Burnings",{"$f":"SUM(+C16+C29)","v":567478},null,{"$f":"SUM(+E16+E29)","v":100},null,{"$f":"SUM(+G16+G29)","v":95768},null,{"$f":"SUM(+I16+I29)","v":4706357},null,{"$f":"SUM(+K16+K29)","v":112130},null,{"$f":"SUM(+M16+M29)","v":272709.8},null," $",{"$f":"SUM(+P16+P29)","v":24571541},null," $",{"$f":"SUM(+S16+S29)","v":29550607.799999997}]
[]
[]
[15,"   Total Production by Steam (Line 5)",null,null,null,null,{"$f":"+G16","v":95768},null,{"$f":"+I16","v":4706357},null,{"$f":"+K16","v":109946},null,{"$f":"+M16","v":268557},null," $",{"$f":"+P16","v":0},null," $",{"$f":"+S16","v":4974914}]
[]
[16,"   Less:  Allocated to Steam System - Perry K",null,null,null,null,0,null,0,null,0,null,0,null,null,0,null,null,0]
[]
[17,"   Net Electric Production by Steam",null,null,null,null,{"$f":"+G34-G36","v":95768},null,{"$f":"+I34-I36","v":4706357},null,{"$f":"+K34-K36","v":109946},null,{"$f":"+M34-M36","v":268557},null," $",0,null," $",{"$f":"+I38+M38+P38","v":4974914}]
[]
[18,"   Add:  Total by Other (Line 12)",null,null,null,null,0,null,0,null,{"$f":"+K29","v":2184},null,{"$f":"+M29","v":4152.8},null,"",{"$f":"+P29","v":24571541},null,"",{"$f":"+I40+M40+P40","v":24575693.800000001}]
[]
[19,"   Total Electric Fuel Cost for Generation",null,null,null,null,{"$f":"SUM(G38:G41)","v":95768},null,{"$f":"SUM(I38:I41)","v":4706357},null,{"$f":"SUM(K38:K41)","v":112130},null,{"$f":"SUM(M38:M41)","v":272709.8},null," $",{"$f":"SUM(P38:P41)","v":24571541},null," $",{"$f":"+I42+M42+P42","v":29550607.800000001}]
[]
[null,"* This includes realized gains/losses on Financial Hedges and Transactional Fees."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"`"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"`"]

{"sheet":"FCA_A8B","index":20,"n_rows":63,"n_cols":24,"rows_kept":63,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Schedule 8B"]
[]
["AES INDIANA"]
[{"$f":"\"Summary of Fuel Issues for \"&'Date Input'!B10&\", \"&'Date Input'!C10","v":"Summary of Fuel Issues for December, 2021"}]
[]
["Line",null,null,"Net Generation",null,null,null,"Coal Issues",null,null,null,"Oil Issues",null,null,null,"Natural Gas",null,null,"Total"]
["No.","Burnings by Station","MWH",null,"%",null,"Tons",null,"Cost",null,"Gallons",null,"Cost",null,null,"Cost",null,null,"Fuel Cost"]
["(1)","(2)","(3)",null,"(4)",null,"(5)",null,"(6)",null,"(7)",null,"(8)",null,null,"(9)",null,null,"(10)"]
[null,"   Production by Coal:"]
[]
[1,"   Perry K",0,null,{"$f":"ROUND((C12/C31)*100,2)","v":0},null,0," $",0,null,0," $",0,null," $",0,null," $",0]
[2,"   Petersburg",623008,null,{"$f":"ROUND((C13/C31)*100,2)-0.01","v":74.67},null,295875,null,14448776,null,131160,null,321839,null,null,0,null,null,{"$f":"+I13+M13+P13","v":14770615}]
[3,"   Harding Street",0,null,{"$f":"ROUND((C14/C31)*100,2)","v":0},null,0,null,0,null,0,null,0,null,null,0,null,null,{"$f":"+I14+M14+P14","v":0}]
[]
[4,"   Total by Steam",{"$f":"SUM(C12:C15)","v":623008},null,{"$f":"SUM(E12:E15)","v":74.67},null,{"$f":"SUM(G12:G15)","v":295875}," $",{"$f":"SUM(I12:I15)","v":14448776},null,{"$f":"SUM(K12:K15)","v":131160}," $",{"$f":"SUM(M12:M15)","v":321839},null," $",0,null," $",{"$f":"SUM(S12:S15)","v":14770615}]
[]
[null,"   Produced by Other:"]
[]
[5,"   Eagle Valley - CCGT",-1686,null,{"$f":"ROUND((C20/C31)*100,2)","v":-0.2},null,0," $",0,null,0," $",0,null," $",442948,null," $",{"$f":"+I20+M20+P20","v":442948}]
[6,"   CCGT - Financial Hedges(1)",0,null,{"$f":"ROUND((C21/C31)*100,2)","v":0},null,0,null,0,null,0,null,0,null,null,0,null,null,0]
[7,"   Georgetown #1 & 4",14808,null,{"$f":"ROUND((C22/C31)*100,2)","v":1.78},null,0,null,0,null,0,null,0,null,null,1093564,null,null,1093564]
[8,"   Petersburg Int. Combus.",5,null,{"$f":"ROUND((C23/C31)*100,2)","v":0},null,0,null,0,null,404,null,991,null,null,0,null,null,991]
[9,"   Harding Street Int. Combus.",10,null,{"$f":"ROUND((C24/C31)*100,2)","v":0},null,0,null,0,null,9,null,18,null,null,0,null,null,18]
[10,"   Harding Street Natural Gas",198090,null,{"$f":"ROUND((C25/C31)*100,2)","v":23.75},null,0,null,0,null,112,null,227,null,null,13944800,null,null,13945027]
[11,"   Rental Diesels",0,null,{"$f":"ROUND((C26/C31)*100,2)","v":0},null,0,null,0,null,0,null,0,null,null,0,null,null,0]
[12,"   Eagle Valley Int. Combus.",0,null,{"$f":"ROUND((C27/C31)*100,2)","v":0},null,0,null,0,null,0,null,0,null,null,0,null,null,0]
[]
[13,"   Total by Other",{"$f":"SUM(C20:C28)","v":211227},null,{"$f":"SUM(E20:E28)","v":25.33},null,0," $",0,null,{"$f":"SUM(K20:K28)","v":525}," $",{"$f":"SUM(M20:M28)","v":1236},null," $",{"$f":"SUM(P20:P28)","v":15481312},null," $",{"$f":"SUM(S20:S28)","v":15482548}]
[]
[13,"   Total Burnings",{"$f":"SUM(+C16+C29)","v":834235},null,{"$f":"SUM(+E16+E29)","v":100},null,{"$f":"SUM(+G16+G29)","v":295875}," $",{"$f":"SUM(+I16+I29)","v":14448776},null,{"$f":"SUM(+K16+K29)","v":131685}," $",{"$f":"SUM(+M16+M29)","v":323075},null," $",{"$f":"SUM(+P16+P29)","v":15481312},null," $",{"$f":"SUM(+S16+S29)","v":30253163}]
[]
[]
[14,"   Total Production by Steam (Line 5)",null,null,null,null,{"$f":"+G16","v":295875}," $",{"$f":"+I16","v":14448776},null,{"$f":"+K16","v":131160}," $",{"$f":"+M16","v":321839},null," $",0,null," $",{"$f":"+S16","v":14770615}]
[]
[15,"   Less:  Allocated to Steam System - Perry K",null,null,null,null,0,null,0,null,0,null,0,null,null,0,null,null,0]
[]
[16,"   Net Electric Production by Steam",null,null,null,null,{"$f":"+G34-G36","v":295875}," $",{"$f":"+I34-I36","v":14448776},null,{"$f":"+K34-K36","v":131160}," $",{"$f":"+M34-M36","v":321839},null," $",0,null," $",{"$f":"+I38+M38+P38","v":14770615}]
[]
[17,"   Add:  Total by Other (Line 12)",null,null,null,null,0,null,0,null,{"$f":"+K29","v":525},null,{"$f":"+M29","v":1236},null,"",{"$f":"+P29","v":15481312},null,"",{"$f":"+I40+M40+P40","v":15482548}]
[]
[18,"   Total Electric Fuel Cost for Generation",null,null,null,null,{"$f":"SUM(G38:G41)","v":295875}," $",{"$f":"SUM(I38:I41)","v":14448776},null,{"$f":"SUM(K38:K41)","v":131685}," $",{"$f":"SUM(M38:M41)","v":323075},null," $",{"$f":"SUM(P38:P41)","v":15481312},null," $",{"$f":"+I42+M42+P42","v":30253163}]
[]
[null,"* This includes realized gains/losses on Financial Hedges and Transactional Fees."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"`"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"`"]

{"sheet":"FCA_A8C","index":21,"n_rows":63,"n_cols":24,"rows_kept":63,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Schedule 8C"]
[]
["AES INDIANA"]
[{"$f":"\"Summary of Fuel Issues for \"&'Date Input'!B11&\", \"&'Date Input'!C11","v":"Summary of Fuel Issues for January, 2022"}]
[]
["Line",null,null,"Net Generation",null,null,null,"Coal Issues",null,null,null,"Oil Issues",null,null,null,"Natural Gas",null,null,"Total"]
["No.","Burnings by Station","MWH",null,"%",null,"Tons",null,"Cost",null,"Gallons",null,"Cost",null,null,"Cost",null,null,"Fuel Cost"]
["(1)","(2)","(3)",null,"(4)",null,"(5)",null,"(6)",null,"(7)",null,"(8)",null,null,"(9)",null,null,"(10)"]
[null,"   Production by Coal:"]
[]
["1","   Perry K",0,null,{"$f":"ROUND((C12/C31)*100,2)","v":0},null,0," $",0,null,0," $",0,null," $",0,null," $",0]
["2","   Petersburg",913115,null,{"$f":"ROUND((C13/C31)*100,2)","v":76.94},null,432206,null,22836155,null,66826.000082446146,null,165737,null,null,0,null,null,{"$f":"+I13+M13+P13","v":23001892}]
["3","   Harding Street",0,null,{"$f":"ROUND((C14/C31)*100,2)","v":0},null,0,null,0,null,0,null,0,null,null,0,null,null,{"$f":"+I14+M14+P14","v":0}]
[]
[4,"   Total by Steam",{"$f":"SUM(C12:C15)","v":913115},null,{"$f":"SUM(E12:E15)","v":76.94},null,{"$f":"SUM(G12:G15)","v":432206}," $",{"$f":"SUM(I12:I15)","v":22836155},null,{"$f":"SUM(K12:K15)","v":66826.000082446146}," $",{"$f":"SUM(M12:M15)","v":165737},null," $",0,null," $",{"$f":"SUM(S12:S15)","v":23001892}]
[]
[null,"   Produced by Other:"]
[]
[5,"   Eagle Valley - CCGT",-1751,null,{"$f":"ROUND((C20/C31)*100,2)","v":-0.15},null,0," $",0,null,0," $",0,null," $",459759,null," $",{"$f":"+I20+M20+P20","v":459759}]
[6,"   CCGT - Financial Hedges(1)",0,null,{"$f":"ROUND((C21/C31)*100,2)","v":0},null,0,null,0,null,0,null,0,null,null,0,null,null,{"$f":"+I21+M21+P21","v":0}]
[7,"   Georgetown #1 & 4",33125,null,{"$f":"ROUND((C22/C31)*100,2)","v":2.79},null,0,null,0,null,0,null,0,null,null,2579942,null,null,{"$f":"+I22+M22+P22","v":2579942}]
[8,"   Petersburg Int. Combus.",4,null,{"$f":"ROUND((C23/C31)*100,2)","v":0},null,0,null,0,null,321,null,796.12,null,null,0,null,null,796.12]
[9,"   Harding Street Int. Combus.",10,null,{"$f":"ROUND((C24/C31)*100,2)","v":0},null,0,null,0,null,693,null,1407,null,null,0,null,null,1407]
[10,"   Harding Street Natural Gas",242304,null,{"$f":"ROUND((C25/C31)*100,2)","v":20.420000000000002},null,0,null,0,null,11507,null,23371,null,null,17164397,null,null,17187768]
[11,"   Rental Diesels",0,null,{"$f":"ROUND((C26/C31)*100,2)","v":0},null,0,null,0,null,0,null,0,null,null,0,null,null,0]
[12,"   Eagle Valley Int. Combus.",0,null,{"$f":"ROUND((C27/C31)*100,2)","v":0},null,0,null,0,null,0,null,0,null,null,0,null,null,0]
[]
[13,"   Total by Other",{"$f":"SUM(C20:C28)","v":273692},null,{"$f":"SUM(E20:E28)","v":23.060000000000002},null,0," $",0,null,{"$f":"SUM(K20:K28)","v":12521}," $",{"$f":"SUM(M20:M28)","v":25574.12},null," $",{"$f":"SUM(P20:P28)","v":20204098},null," $",{"$f":"SUM(S20:S28)","v":20229672.120000001}]
[]
[14,"   Total Burnings",{"$f":"SUM(+C16+C29)","v":1186807},null,{"$f":"SUM(+E16+E29)","v":100},null,{"$f":"SUM(+G16+G29)","v":432206}," $",{"$f":"SUM(+I16+I29)","v":22836155},null,{"$f":"SUM(+K16+K29)","v":79347.000082446146}," $",{"$f":"SUM(+M16+M29)","v":191311.12},null," $",{"$f":"SUM(+P16+P29)","v":20204098},null," $",{"$f":"SUM(+S16+S29)","v":43231564.120000005}]
[]
[]
[15,"   Total Production by Steam (Line 5)",null,null,null,null,{"$f":"+G16","v":432206}," $",{"$f":"+I16","v":22836155},null,{"$f":"+K16","v":66826.000082446146}," $",{"$f":"+M16","v":165737},null," $",0,null," $",{"$f":"+S16","v":23001892}]
[]
[16,"   Less:  Allocated to Steam System - Perry K",null,null,null,null,0,null,0,null,0,null,0,null,null,0,null,null,0]
[]
[17,"   Net Electric Production by Steam",null,null,null,null,{"$f":"+G34-G36","v":432206}," $",{"$f":"+I34-I36","v":22836155},null,{"$f":"+K34-K36","v":66826.000082446146}," $",{"$f":"+M34-M36","v":165737},null," $",0,null," $",{"$f":"+I38+M38+P38","v":23001892}]
[]
[18,"   Add:  Total by Other (Line 12)",null,null,null,null,0,null,0,null,{"$f":"+K29","v":12521},null,{"$f":"+M29","v":25574.12},null,"",{"$f":"+P29","v":20204098},null,"",{"$f":"+I40+M40+P40","v":20229672.120000001}]
[]
[19,"   Total Electric Fuel Cost for Generation",null,null,null,null,{"$f":"SUM(G38:G41)","v":432206}," $",{"$f":"SUM(I38:I41)","v":22836155},null,{"$f":"SUM(K38:K41)","v":79347.000082446146}," $",{"$f":"SUM(M38:M41)","v":191311.12},null," $",{"$f":"SUM(P38:P41)","v":20204098},null," $",{"$f":"+I42+M42+P42","v":43231564.120000005}]
[]
[null,"* This includes realized gains/losses on Financial Hedges and Transactional Fees."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"`"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"`"]

{"sheet":"FCA_A10A","index":22,"n_rows":70,"n_cols":24,"rows_kept":70,"cut":false,"hidden":false,"merged":[]}
["EXCLUDED FROM PUBLIC ACCESS PER A.R. 9(G)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Exhibit A"]
["PRINT ON GREEN PAPER",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Schedule 10A"]
[]
["AES INDIANA"]
["Determination of Net Energy Costs of Other Purchased"]
["Power for Actual Month of November, 2021"]
[]
[]
["Line",null,null,null,null,"Purchased",null,"Demand",null,"Net Energy",null,"Other",null,"Emissions",null,"Total"]
["No.",null,"Supplier","Type",null,"KWH (000's)",null,"Charges",null,"Costs",null,"Costs",null,"Costs",null,"Charges"]
["(1)",null,"(2)","(3)",null,"(4)",null,"(5)",null,"(6)",null,"(7)",null,"(8)",null,"(9)"]
[]
[]
[1,null,"M-Rets Renewables Registry",null,null,0,null,0,null,0,null,0,null,0,null,{"$f":"SUM(H14:N14)","v":0}]
[1,null,"M-Rets Renewables Registry",null,null,0,null,0,null,0,null,0,null,0,null,{"$f":"SUM(H15:N15)","v":0}]
[{"$f":"A15+1","v":2},null,"ICAP Energy LLLC",null,null,0,null,0,null,0,null,0,null,0,null,{"$f":"SUM(H16:N16)","v":0}]
[{"$f":"A16+1","v":3},null,"ACES",null,null,0,null,0,null,0,null,0,null,0,null,0]
[4,null,"TFS Energy",null,null,0,null,0,null,0,null,0,null,0,null,0]
[5,null,"BP",null,null,0,null,0,null,0,null,0,null,0,null,0]
[6,null,"NextEra","Capacity",null,0,null,0,null,0,null,0,null,0,null,0]
[1,null,"MISO Resource Adequacy","Capacity",null,0,null,-24416,null,0,null,0,null,0,null,-24416]
[2,null,"Hoosier Wind",null,null,28322,null,0,null,2653574,null,0,null,0,null,2653574]
[3,null,"Lakefield Wind",null,null,31468,null,0,null,5276412,null,0,null,0,null,5276412]
[4,null,"Melloh Enterprises",null,null,2,null,0,null,598,null,0,null,0,null,598]
[5,null,"GSA Finance Division",null,null,0,null,0,null,0,null,0,null,0,null,0]
[6,null,"Energy Solutions by JMS",null,null,4,null,0,null,912,null,0,null,0,null,912]
[7,null,"L&R",null,null,2,null,0,null,549,null,0,null,0,null,549]
[8,null,"L&R Housing",null,null,2,null,0,null,447,null,0,null,0,null,447]
[9,null,"Indiana Veneers",null,null,0,null,0,null,0,null,0,null,0,null,0]
[10,null,"JMS LLC",null,null,7,null,0,null,1656,null,0,null,0,null,1656]
[11,null,"Celedon Trucking",null,null,0,null,0,null,0,null,0,null,0,null,0]
[12,null,"IUPUI",null,null,4,null,0,null,886,null,0,null,0,null,886]
[13,null,"Bulldog Energy LLC",null,null,31,null,0,null,6200,null,0,null,0,null,6200]
[14,null,"Bulldog Energy LLC",null,null,8,null,0,null,1997,null,0,null,0,null,1997]
[15,null,"Bulldog Energy LLC",null,null,6,null,0,null,1488,null,0,null,0,null,1488]
[16,null,"Bulldog Energy LLC",null,null,193,null,0,null,38600,null,0,null,0,null,38600]
[17,null,"MCV Solar",null,null,1,null,0,null,210,null,0,null,0,null,210]
[18,null,"MCV Solar - Building 1",null,null,1,null,0,null,284,null,0,null,0,null,284]
[19,null,"ET Energy Solutions",null,null,798,null,0,null,159600,null,0,null,0,null,159600]
[20,null,"WGL Energy Systems",null,null,646,null,0,null,129200,null,0,null,0,null,129200]
[21,null,"Merrell Brothers",null,null,8,null,0,null,1800,null,0,null,0,null,1800]
[22,null,"Merrell Brothers",null,null,60,null,0,null,12000,null,0,null,0,null,12000]
[23,null,"Indy Solar I",null,null,1017,null,0,null,111768,null,0,null,0,null,111768]
[24,null,"Indy Solar II",null,null,1036,null,0,null,93136,null,0,null,0,null,93136]
[25,null,"Indy Solar III",null,null,879,null,0,null,87812,null,0,null,0,null,87812]
[26,null,"A-Pallett-Bulldog Energy LLC",null,null,3,null,0,null,672,null,0,null,0,null,672,null,null,null,null,null,null,null,"`"]
[27,null,"A-Pallett-Bulldog Energy LLC",null,null,5,null,0,null,1224,null,0,null,0,null,1224]
[28,null,"HQC Maywood LLC",null,null,519,null,0,null,103800,null,0,null,0,null,103800]
[29,null,"Solscient Energy LLC",null,null,14,null,0,null,2800,null,0,null,0,null,2800]
[30,null,"Solscient Energy LLC",null,null,0,null,0,null,0,null,0,null,0,null,0]
[31,null,"Solscient Energy LLC",null,null,20,null,0,null,4060,null,0,null,0,null,4060]
[32,null,"Rockville Solar I LLC",null,null,196,null,0,null,39200,null,0,null,0,null,39200]
[33,null,"Blue Renewable Energy",null,null,712,null,0,null,142400,null,0,null,0,null,142400]
[34,null,"Rockville Solar II LLC",null,null,150,null,0,null,30000,null,0,null,0,null,30000]
[35,null,"HMV Indy I",null,null,121,null,0,null,24200,null,0,null,0,null,24200]
[36,null,"HMV Indy I",null,null,138,null,0,null,27600,null,0,null,0,null,27600]
[37,null,"HMV Indy I",null,null,113,null,0,null,22600,null,0,null,0,null,22600]
[38,null,"5839 LLC",null,null,4,null,0,null,1046,null,0,null,0,null,1046]
[39,null,"GES Megaone LLC",null,null,72,null,0,null,14400,null,0,null,0,null,14400]
[40,null,"Marion Solar LLC",null,null,282,null,0,null,56400,null,0,null,0,null,56400]
[41,null,"Marion Solar LLC",null,null,129,null,0,null,25800,null,0,null,0,null,25800]
[42,null,"NRG Energy LLC",null,null,295,null,0,null,59000,null,0,null,0,null,59000]
[43,null,"SSA Solar of IN 5 LLC",null,null,107,null,0,null,21440,null,0,null,0,null,{"$f":"SUM(H63:N63)","v":21440},null,null,null,null,null,null,"`"]
[44,null,"Citizens- Perry K",null,null,0,null,0,null,0,null,0,null,0,null,0]
[45,null,"Rider 15","On Call Generation",null,0,null,0,null,0,null,0,null,0,null,0]
[46,null,"Purchases through MISO",null,null,427674,null,0,null,27481782,null,0,null,0,null,27481782]
[47,null,"MISO Components of the Cost of Fuel",null,null,0,null,0,null,7081450,null,0,null,0,null,7081450]
[48,null,"Rate CGS Customers",null,null,19.32,null,235.56,null,472.4,null,0,null,0,null,707.96]
[49,null,"JP Morgan - Hedge",null,null,0,null,0,null,0,null,0,null,0,null,0]
[{"$f":"A68+1","v":49},null,"Total for Month",null,null,{"$f":"SUM(F14:F69)","v":495068.32},"   $",{"$f":"SUM(H14:H69)","v":-24180.44}," $",{"$f":"SUM(J14:J69)","v":43719475.399999999},"$",{"$f":"SUM(L14:L69)","v":0},"$",{"$f":"SUM(N14:N69)","v":0},"$",{"$f":"SUM(P14:P69)","v":43695294.960000001}]

{"sheet":"FCA_A10B","index":23,"n_rows":69,"n_cols":24,"rows_kept":69,"cut":false,"hidden":false,"merged":[]}
["EXCLUDED FROM PUBLIC ACCESS PER A.R. 9(G)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Exhibit A"]
["PRINT ON GREEN PAPER",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Schedule 10B"]
[]
["AES INDIANA"]
["Determination of Net Energy Costs of Other Purchased"]
["Power for Actual Month of December, 2021"]
[]
[]
["Line",null,null,null,null,"Purchased",null,"Demand",null,"Net Energy",null,"Other",null,"Emissions",null,"Total"]
["No.",null,"Supplier","Type",null,"KWH (000's)",null,"Charges",null,"Costs",null,"Costs",null,"Costs",null,"Charges"]
["(1)",null,"(2)","(3)",null,"(4)",null,"(5)",null,"(6)",null,"(7)",null,"(8)",null,"(9)"]
[]
[]
[1,null,"M-Rets Renewables Registry",null,null,0,null,0,null,0,null,0,null,0,null,{"$f":"SUM(H14:N14)","v":0}]
[{"$f":"+A14+1","v":2},null,"ICAP Energy LLC",null,null,0,null,0,null,0,null,0,null,0,null,{"$f":"SUM(H15:N15)","v":0}]
[{"$f":"+A15+1","v":3},null,"ACES",null,null,0,null,0,null,0,null,0,null,0,null,0]
[4,null,"TFS Energy",null,null,0,null,0,null,0,null,0,null,0,null,0]
[5,null,"BP","Capacity",null,0,null,0,null,0,null,0,null,0,null,0]
[6,null,"NextEra","Capacity",null,0,null,0,null,0,null,0,null,0,null,0]
[1,null,"MISO Resource Adequacy","Capacity",null,0,null,-25230,null,0,null,0,null,0,null,-25230]
[2,null,"Hoosier Wind",null,null,29541,null,0,null,2542298,null,0,null,0,null,2542298]
[3,null,"Lakefield Wind",null,null,45322,null,0,null,4941058,null,0,null,0,null,4941058]
[4,null,"Melloh Enterprises",null,null,2,null,0,null,561,null,0,null,0,null,561]
[5,null,"GSA Finance Center",null,null,0,null,0,null,0,null,0,null,0,null,0]
[6,null,"Energy Solutions by JMS",null,null,3,null,0,null,607,null,0,null,0,null,607]
[7,null,"L&R",null,null,2,null,0,null,475,null,0,null,0,null,475]
[8,null,"L&R Housing",null,null,2,null,0,null,386,null,0,null,0,null,386]
[9,null,"Indiana Veneers",null,null,0,null,0,null,0,null,0,null,0,null,0]
[10,null,"JMS LLC",null,null,7,null,0,null,1728,null,0,null,0,null,1728]
[11,null,"Celedon Trucking",null,null,0,null,0,null,0,null,0,null,0,null,0]
[12,null,"IUPUI",null,null,3,null,0,null,624,null,0,null,0,null,624]
[13,null,"Bulldog Energy LLC",null,null,28,null,0,null,5600,null,0,null,0,null,5600]
[14,null,"Bulldog Energy LLC",null,null,6,null,0,null,1517,null,0,null,0,null,1517]
[15,null,"Bulldog Energy LLC",null,null,6,null,0,null,1320,null,0,null,0,null,1320]
[16,null,"Bulldog Energy LLC",null,null,190,null,0,null,38000,null,0,null,0,null,38000]
[17,null,"MCV Solar",null,null,1,null,0,null,223,null,0,null,0,null,223]
[18,null,"MCV Solar - Building 1",null,null,1,null,0,null,282,null,0,null,0,null,282]
[19,null,"ET Energy Solutions",null,null,798,null,0,null,159600,null,0,null,0,null,159600]
[20,null,"WGL Energy Systems",null,null,577,null,0,null,115400,null,0,null,0,null,115400]
[21,null,"Merrell Brothers",null,null,7,null,0,null,1728,null,0,null,0,null,1728]
[22,null,"Merrell Brothers",null,null,60,null,0,null,12000,null,0,null,0,null,12000]
[23,null,"Indy Solar I",null,null,843,null,0,null,92646,null,0,null,0,null,92646]
[24,null,"Indy Solar II",null,null,866,null,0,null,77853,null,0,null,0,null,77853]
[25,null,"Indy Solar III",null,null,341,null,0,null,34066,null,0,null,0,null,34066]
[26,null,"A-Pallett- Bulldog Energy LLC",null,null,3,null,0,null,720,null,0,null,0,null,720]
[27,null,"A-Pallett- Bulldog Energy LLC",null,null,5,null,0,null,1080,null,0,null,0,null,1080,null,null,null,null,null,null,null,"`"]
[28,null,"HQC Maywood LLC",null,null,256,null,0,null,51200,null,0,null,0,null,51200]
[29,null,"Solscient Energy LLC",null,null,12,null,0,null,2320,null,0,null,0,null,2320]
[30,null,"Solscient Energy LLC",null,null,16,null,0,null,3280,null,0,null,0,null,3280]
[31,null,"Solscient Energy LLC",null,null,16,null,0,null,3220,null,0,null,0,null,3220]
[32,null,"Rockville Solar I LLC",null,null,191,null,0,null,38200,null,0,null,0,null,38200]
[33,null,"Blue Renewable Energy",null,null,699,null,0,null,139800,null,0,null,0,null,139800]
[34,null,"Rockville Solar II LLC",null,null,142,null,0,null,28400,null,0,null,0,null,28400]
[35,null,"HMV Indy I",null,null,208,null,0,null,41600,null,0,null,0,null,41600]
[36,null,"HMV Indy I",null,null,144,null,0,null,28800,null,0,null,0,null,28800]
[37,null,"HMV Indy I",null,null,190,null,0,null,38000,null,0,null,0,null,38000]
[38,null,"5839 LLC",null,null,3,null,0,null,787,null,0,null,0,null,787]
[39,null,"GES Megaone LLC",null,null,56,null,0,null,11200,null,0,null,0,null,11200]
[40,null,"Marion Solar LLC",null,null,287,null,0,null,57400,null,0,null,0,null,57400]
[41,null,"Marion Solar LLC",null,null,119,null,0,null,23800,null,0,null,0,null,23800]
[42,null,"NRG Energy LLC",null,null,320,null,0,null,64400,null,0,null,0,null,64400]
[43,null,"SSA Solar of IN 5 LLC",null,null,94,null,0,null,18880,null,0,null,0,null,{"$f":"SUM(H62:N62)","v":18880}]
[44,null,"Citizens- Perry K",null,null,264,null,0,null,14559,null,0,null,0,null,14559,null,null,null,null,null,null,"`"]
[45,null,"Rider 15","On Call Generation",null,0,null,0,null,0,null,0,null,0,null,0]
[46,null,"Purchases through MISO",null,null,226904,null,0,null,9524139,null,0,null,0,null,9524139]
[47,null,"MISO Components of the Cost of Fuel",null,null,0,null,0,null,2546715,null,0,null,0,null,2546715]
[48,null,"Rate CGS Customers",null,null,14,null,170,null,337,null,0,null,0,null,{"$f":"SUM(H67:N67)","v":507}]
[49,null,"JP Morgan - Hedge",null,null,0,null,0,null,482546,null,0,null,0,null,{"$f":"SUM(H68:N68)","v":482546}]
[50,null,"Total for Month",null,null,{"$f":"SUM(F14:F68)","v":308549},"   $",{"$f":"SUM(H14:H68)","v":-25060}," $",{"$f":"SUM(J14:J68)","v":21149355},"$",{"$f":"SUM(L14:L68)","v":0},"$",{"$f":"SUM(N14:N68)","v":0},"$",{"$f":"SUM(P14:P68)","v":21124295}]

{"sheet":"FCA_A10C","index":24,"n_rows":62,"n_cols":24,"rows_kept":62,"cut":false,"hidden":false,"merged":[]}
["EXCLUDED FROM PUBLIC ACCESS PER A.R. 9(G)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Exhibit A"]
["PRINT ON GREEN PAPER",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Schedule 10C"]
[]
["AES INDIANA"]
["Determination of Net Energy Costs of Other Purchased"]
["Power for Actual Month of January, 2022"]
[]
[]
["Line",null,null,null,null,"Purchased",null,"Demand",null,"Net Energy",null,"Other",null,"Emissions",null,"Total"]
["No.",null,"Supplier","Type",null,"KWH (000's)",null,"Charges",null,"Costs",null,"Costs",null,"Costs",null,"Charges"]
["(1)",null,"(2)","(3)",null,"(4)",null,"(5)",null,"(6)",null,"(7)",null,"(8)",null,"(9)"]
[1,null,"M-Rets Renewables Registry",null,null,0,null,0,null,0,null,0,null,0,null,{"$f":"SUM(H12:N12)","v":0}]
[{"$f":"+A12+1","v":2},null,"ICAP Energy LLC",null,null,0,null,0,null,0,null,0,null,0,null,0]
[{"$f":"+A13+1","v":3},null,"ACES",null,null,0,null,0,null,0,null,0,null,0,null,0]
[4,null,"TFS Energy",null,null,0,null,0,null,0,null,0,null,0,null,0]
[5,null,"BP","Capacity",null,0,null,0,null,0,null,0,null,0,null,0]
[6,null,"NextEra","Capacity",null,0,null,0,null,0,null,0,null,0,null,0]
[1,null,"MISO Resource Adequacy","Capacity",null,0,null,-25229.97,null,0,null,0,null,0,null,-25229.97]
[2,null,"Hoosier Wind",null,null,26600,null,0,null,2289196,null,0,null,0,null,2289196]
[3,null,"Lakefield Wind",null,null,64117,null,0,null,5872912,null,0,null,0,null,5872912]
[4,null,"Melloh Enterprises",null,null,2,null,0,null,521,null,0,null,0,null,521]
[5,null,"Energy Solutions by JMS",null,null,1,null,0,null,349,null,0,null,0,null,349]
[6,null,"AMF Astro LLC",null,null,812,null,0,null,152400,null,0,null,0,null,152400]
[7,null,"Indiana Veneers",null,null,0,null,0,null,0,null,0,null,0,null,0]
[8,null,"JMS LLC",null,null,7,null,0,null,1776,null,0,null,0,null,1776]
[9,null,"IUPUI",null,null,3,null,0,null,697,null,0,null,0,null,697]
[10,null,"Bulldog Energy LLC",null,null,27,null,0,null,5400,null,0,null,0,null,5400]
[11,null,"Bulldog Energy LLC",null,null,5,null,0,null,1296,null,0,null,0,null,1296]
[12,null,"Bulldog Energy LLC",null,null,5,null,0,null,1224,null,0,null,0,null,1224]
[13,null,"Bulldog Energy LLC",null,null,175,null,0,null,35000,null,0,null,0,null,35000]
[14,null,"MCV Solar",null,null,1,null,0,null,228,null,0,null,0,null,228]
[15,null,"MCV Solar - Building 1",null,null,1,null,0,null,287,null,0,null,0,null,287]
[16,null,"WGL Energy Systems",null,null,553,null,0,null,110600,null,0,null,0,null,110600]
[17,null,"Merrell Brothers",null,null,7,null,0,null,1656,null,0,null,0,null,1656]
[18,null,"Merrell Brothers",null,null,58,null,0,null,11600,null,0,null,0,null,11600]
[19,null,"Novatus Fund Holdings LLC",null,null,670,null,0,null,73633,null,0,null,0,null,73633]
[20,null,"Novatus Fund Holdings LLC",null,null,589,null,0,null,52951,null,0,null,0,null,52951]
[21,null,"Novatus Fund Holdings LLC",null,null,659,null,0,null,65834,null,0,null,0,null,65834]
[22,null,"A-Pallett- Bulldog Energy LLC",null,null,3,null,0,null,696,null,0,null,0,null,696]
[23,null,"A-Pallett- Bulldog Energy LLC",null,null,5,null,0,null,1152,null,0,null,0,null,1152]
[24,null,"HQC Maywood LLC",null,null,391,null,0,null,78200,null,0,null,0,null,78200]
[25,null,"Solscient Energy LLC",null,null,11,null,0,null,2120,null,0,null,0,null,2120,null,null,null,null,null,null,null,"`"]
[26,null,"Marine Center of Ind",null,null,16,null,0,null,3168,null,0,null,0,null,3168]
[27,null,"Marine Center of Ind",null,null,13,null,0,null,2600,null,0,null,0,null,2600]
[28,null,"Rockville Solar I LLC",null,null,197,null,0,null,39400,null,0,null,0,null,39400]
[29,null,"Blue Renewable Energy",null,null,671,null,0,null,134200,null,0,null,0,null,134200]
[30,null,"Rockville Solar II LLC",null,null,143,null,0,null,28600,null,0,null,0,null,28600]
[31,null,"HMV Indy I",null,null,175,null,0,null,35000,null,0,null,0,null,35000]
[32,null,"HMV Indy I",null,null,125,null,0,null,25000,null,0,null,0,null,25000]
[33,null,"HMV Indy I",null,null,149,null,0,null,29800,null,0,null,0,null,29800]
[34,null,"5839 LLC",null,null,3,null,0,null,672,null,0,null,0,null,672]
[35,null,"GES Megaone",null,null,64,null,0,null,12800,null,0,null,0,null,12800]
[36,null,"Marion Solar LLC",null,null,272,null,0,null,54400,null,0,null,0,null,54400]
[37,null,"Marion Solar LLC",null,null,102,null,0,null,20400,null,0,null,0,null,20400]
[38,null,"DGPV Fund II LLC Lenape II Solar LLC",null,null,155,null,0,null,31000,null,0,null,0,null,31000]
[39,null,"SSA Solar of IN 5 LLC",null,null,93,null,0,null,18640,null,0,null,0,null,{"$f":"SUM(H56:N56)","v":18640}]
[40,null,"Citizens Energy- Perry K",null,null,1129,null,0,null,53515,null,0,null,0,null,53515]
[41,null,"Purchases through MISO",null,null,141264,null,0,null,7659290,null,0,null,0,null,{"$f":"SUM(H58:N58)","v":7659290}]
[42,null,"MISO Components of the Cost of Fuel",null,null,0,null,0,null,1516613,null,0,null,0,null,1516613]
[43,null,"Rate CGS Customers",null,null,280,null,2092,null,6673,null,0,null,0,null,8765]
[44,null,"JP Morgan - Hedge",null,null,0,null,0,null,0,null,0,null,0,null,{"$f":"SUM(H61:N61)","v":0}]
[45,null,"Total for Month",null,null,{"$f":"SUM(F12:F61)","v":239553},"   $",{"$f":"SUM(H12:H61)","v":-23137.97}," $",{"$f":"SUM(J12:J61)","v":18431499},"$",{"$f":"SUM(L12:L61)","v":0},"$",{"$f":"SUM(N12:N61)","v":0},"$",{"$f":"SUM(P12:P61)","v":18408361.030000001}]

{"sheet":"FCA_A11A","index":25,"n_rows":46,"n_cols":30,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Exhibit A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Schedule 11A"]
[]
[]
["AES INDIANA"]
["Determination of Fuel Costs Recovered Through Inter-System Sales"]
["and Fuel Costs Allocated to Non-Jurisdictional Retail Sales"]
["Sales for Actual Month of November, 2021"]
[]
[]
[null,null,null,null,null,null,null,"IPL",null,null,null,"IPL",null,null,null,"IPL"]
[null,null,null,"KWH",null,null,null,"Generated",null,"IPL",null,"Handling",null,"IPL",null,"Total",null,null,null,"Purchased Power Resold",null,null,null,null,null,"Total",null,"Total"]
["Line",null,null,"Sold",null,"Demand",null,"KWH",null,"Fuel",null,"Other",null,"Emissions",null,"Energy",null,"KWH",null,"Fuel",null,"Emissions",null,"Market",null,"Energy",null,"Other",null,"Total"]
["No.","Purchaser","Type","(000's)",null,"Charges",null,"(000's)",null,"Costs",null,"Costs",null,"Costs",null,"Costs",null,"(000's)",null,"Costs",null,"Costs",null,"Admin Cost",null,"Costs",null,"Costs",null,"Charges"]
["(1)","(2)","(3)","(4)",null,"(5)",null,"(6)",null,"(7)",null,"(8)",null,"(9)",null,"(10)",null,"(11)",null,"(12)",null,"(13)",null,null,null,"(14)",null,"(15)",null,"(16)"]
[]
[1,"MISO AUCTION","       APRC",0,null,0,null,0,null,0,null,0,null,0,null,{"$f":"SUM(J17:N17)","v":0},null,0,null,0,null,0,null,0,null,{"$f":"P17+T17+V17+X17","v":0},null,0,null,{"$f":"F17+Z17+AB17","v":0}]
[]
[2,"NIPSCO","       APRC",0,null,0,null,0,null,0,null,0,null,0,null,{"$f":"SUM(J19:N19)","v":0},null,0,null,0,null,0,null,0,null,{"$f":"P19+T19+V19+X19","v":0},null,0,null,0]
[]
[3,"HOOSIER","       APRC",0,null,0,null,0,null,0,null,0,null,0,null,{"$f":"SUM(J21:N21)","v":0},null,0,null,0,null,0,null,0,null,{"$f":"P21+T21+V21+X21","v":0},null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[4,"LAKEFIELD","      WIND",0,null,0,null,0,null,0,null,0,null,0,null,{"$f":"SUM(J23:N23)","v":0},null,0,null,0,null,0,null,0,null,{"$f":"P23+T23+V23+X23","v":0},null,71.459999999999994,null,{"$f":"F23+Z23+AB23","v":71.459999999999994}]
[]
[5,"Sales through MISO","Under TEMT",0,null,0,null,0,null,0,null,0,null,0,null,{"$f":"SUM(J25:N25)","v":0},null,0,null,0,null,0,null,0,null,{"$f":"P25+T25+V25+X25","v":0},null,756.83,null,{"$f":"F25+Z25+AB25","v":756.83}]
[]
[]
[]
[6,"Total for Month",null,{"$f":"SUM(D17:D28)","v":0},"$",{"$f":"SUM(F17:F28)","v":0},null,{"$f":"SUM(H17:H28)","v":0},"$",{"$f":"SUM(J17:J28)","v":0},"$",{"$f":"SUM(L17:L28)","v":0},"$",{"$f":"SUM(N17:N28)","v":0},"$",{"$f":"SUM(P17:P28)","v":0},null,{"$f":"SUM(R17:R28)","v":0},"$",{"$f":"SUM(T17:T28)","v":0},"$",{"$f":"SUM(V17:V28)","v":0},"$",{"$f":"SUM(X17:X28)","v":0},"$",{"$f":"SUM(Z17:Z28)","v":0},"$",{"$f":"SUM(AB17:AB28)","v":828.29000000000008},"$",{"$f":"SUM(AD17:AD28)","v":828.29000000000008}]
[]
[]
[8,"Non-Jurisdictional","Elect Plan",0,"$",0,null,"ICAP Energy LLC","$",0,"$",0,"$",0,"$",{"$f":"SUM(J32:N32)","v":0},null,0,"$",0,"$",0,null,null,"$",{"$f":"P32+T32+V32","v":0},"$",0,"$",{"$f":"F32+Z32+AB32","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"`"]

{"sheet":"FCA_A11B","index":26,"n_rows":46,"n_cols":30,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Exhibit A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Schedule 11B"]
[]
[]
["AES INDIANA"]
["Determination of Fuel Costs Recovered Through Inter-System Sales"]
["and Fuel Costs Allocated to Non-Jurisdictional Retail Sales"]
["Sales for Actual Month of December, 2021"]
[]
[]
[null,null,null,null,null,null,null,"IPL",null,null,null,"IPL",null,null,null,"IPL"]
[null,null,null,"KWH",null,null,null,"Generated",null,"IPL",null,"Handling",null,"IPL",null,"Total",null,null,null,"Purchased Power Resold",null,null,null,null,null,"Total",null,"Total"]
["Line",null,null,"Sold",null,"Demand",null,"KWH",null,"Fuel",null,"Other",null,"Emissions",null,"Energy",null,"KWH",null,"Fuel",null,"Emissions",null,"Market",null,"Energy",null,"Other",null,"Total"]
["No.","Purchaser","Type","(000's)",null,"Charges",null,"(000's)",null,"Costs",null,"Costs",null,"Costs",null,"Costs",null,"(000's)",null,"Costs",null,"Costs",null,"Admin Cost",null,"Costs",null,"Costs",null,"Charges"]
["(1)","(2)","(3)","(4)",null,"(5)",null,"(6)",null,"(7)",null,"(8)",null,"(9)",null,"(10)",null,"(11)",null,"(12)",null,"(13)",null,null,null,"(14)",null,"(15)",null,"(16)"]
[]
[1,"MISO AUCTION","       APRC",0,null,0,null,0,null,0,null,0,null,0,null,{"$f":"SUM(J17:N17)","v":0},null,0,null,0,null,0,null,0,null,{"$f":"P17+T17+V17+X17","v":0},null,0,null,{"$f":"F17+Z17+AB17","v":0}]
[]
[2,"NIPSCO","       APRC",0,null,0,null,0,null,0,null,0,null,0,null,{"$f":"SUM(J19:N19)","v":0},null,0,null,0,null,0,null,0,null,{"$f":"P19+T19+V19+X19","v":0},null,0,null,0]
[]
[3,"HOOSIER","       APRC",0,null,0,null,0,null,0,null,0,null,0,null,{"$f":"SUM(J21:N21)","v":0},null,0,null,0,null,0,null,0,null,{"$f":"P21+T21+V21+X21","v":0},null,0,null,0]
[]
[4,"LAKEFIELD","      WIND",6033,null,0,null,6033,null,184982.45,null,15020.579999999985,null,13.53,null,{"$f":"SUM(J23:N23)","v":200016.56},null,0,null,0,null,0,null,532.71,null,{"$f":"P23+T23+V23+X23","v":200549.27},null,10114.02,null,{"$f":"F23+Z23+AB23","v":210663.28999999998}]
[]
[5,"Sales through MISO","Under TEMT",4494,null,0,null,4494,null,146314,null,9316.8600000000151,null,6,null,{"$f":"SUM(J25:N25)","v":155636.86000000002},null,0,null,0,null,0,null,396.82,null,{"$f":"P25+T25+V25+X25","v":156033.68000000002},null,19801.93,null,{"$f":"F25+Z25+AB25","v":175835.61000000002}]
[]
[]
[]
[6,"Total for Month",null,{"$f":"SUM(D17:D28)","v":10527},"$",{"$f":"SUM(F17:F28)","v":0},null,{"$f":"SUM(H17:H28)","v":10527},"$",{"$f":"SUM(J17:J28)","v":331296.45},"$",{"$f":"SUM(L17:L28)","v":24337.440000000002},"$",{"$f":"SUM(N17:N28)","v":19.53},"$",{"$f":"SUM(P17:P28)","v":355653.42000000004},null,{"$f":"SUM(R17:R28)","v":0},"$",{"$f":"SUM(T17:T28)","v":0},"$",{"$f":"SUM(V17:V28)","v":0},"$",{"$f":"SUM(X17:X28)","v":929.53},null,{"$f":"SUM(Z17:Z28)-1","v":356581.95},"$",{"$f":"SUM(AB17:AB28)+1","v":29916.95},"$",{"$f":"SUM(AD17:AD28)","v":386498.9}]
[]
[]
[5,"Non-Jurisdictional","Elect Plan",0,"$",0,null,"ICAP Energy LLC","$",0,"$",0,"$",0,"$",{"$f":"SUM(J32:N32)","v":0},null,0,"$",0,"$",0,"$",null,null,{"$f":"P32+T32+V32","v":0},"$",0,"$",{"$f":"F32+Z32+AB32","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"`"]

{"sheet":"FCA_A11C","index":27,"n_rows":46,"n_cols":30,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Exhibit A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Schedule 11C"]
[]
[]
["AES INDIANA"]
["Determination of Fuel Costs Recovered Through Inter-System Sales"]
["and Fuel Costs Allocated to Non-Jurisdictional Retail Sales"]
["Sales for Actual Month of January, 2022"]
[]
[]
[null,null,null,null,null,null,null,"IPL",null,null,null,"IPL",null,null,null,"IPL"]
[null,null,null,"KWH",null,null,null,"Generated",null,"IPL",null,"Handling",null,"IPL",null,"Total",null,null,null,"Purchased Power Resold",null,null,null,null,null,"Total",null,"Total"]
["Line",null,null,"Sold",null,"Demand",null,"KWH",null,"Fuel",null,"Other",null,"Emissions",null,"Energy",null,"KWH",null,"Fuel",null,"Emissions",null,"Market",null,"Energy",null,"Other",null,"Total"]
["No.","Purchaser","Type","(000's)",null,"Charges",null,"(000's)",null,"Costs",null,"Costs",null,"Costs",null,"Costs",null,"(000's)",null,"Costs",null,"Costs",null,"Admin Cost",null,"Costs",null,"Costs",null,"Charges"]
["(1)","(2)","(3)","(4)",null,"(5)",null,"(6)",null,"(7)",null,"(8)",null,"(9)",null,"(10)",null,"(11)",null,"(12)",null,"(13)",null,null,null,"(14)",null,"(15)",null,"(16)"]
[]
[1,"MISO AUCTION","APRC",0,null,0,null,0,null,0,null,0,null,0,null,{"$f":"SUM(J17:N17)","v":0},null,0,null,0,null,0,null,0,null,{"$f":"P17+T17+V17+X17","v":0},null,0,null,{"$f":"F17+Z17+AB17","v":0}]
[]
[2,"NIPSCO","APRC",0,null,0,null,0,null,0,null,0,null,0,null,{"$f":"SUM(J19:N19)","v":0},null,0,null,0,null,0,null,0,null,{"$f":"P19+T19+V19+X19","v":0},null,0,null,0]
[]
[3,"HOOSIER","APRC",0,null,0,null,0,null,0,null,0,null,0,null,{"$f":"SUM(J21:N21)","v":0},null,0,null,0,null,0,null,0,null,{"$f":"P21+T21+V21+X21","v":0},null,0,null,0]
[]
[4,"LAKEFIELD","WIND",21957,null,0,null,21957,null,973581,null,43334,null,35,null,{"$f":"SUM(J23:N23)","v":1016950},null,0,null,0,null,0,null,1743,null,{"$f":"P23+T23+V23+X23","v":1018693},null,267374,null,{"$f":"F23+Z23+AB23","v":1286067}]
[]
[5,"Sales through MISO","Under TEMT",22679,null,0,null,22679,null,902190,null,36993,null,25,null,{"$f":"SUM(J25:N25)","v":939208},null,0,null,0,null,0,null,1801,null,{"$f":"P25+T25+V25+X25","v":941009},null,350845,null,{"$f":"F25+Z25+AB25","v":1291854}]
[]
[]
[]
[6,"Total for Month",null,{"$f":"SUM(D17:D28)","v":44636},"$",{"$f":"SUM(F17:F28)","v":0},null,{"$f":"SUM(H17:H28)","v":44636},"$",{"$f":"SUM(J17:J28)","v":1875771},"$",{"$f":"SUM(L17:L28)","v":80327},"$",{"$f":"SUM(N17:N28)","v":60},"$",{"$f":"SUM(P17:P28)","v":1956158},null,{"$f":"SUM(R17:R28)","v":0},"$",{"$f":"SUM(T17:T28)","v":0},"$",{"$f":"SUM(V17:V28)","v":0},"$",{"$f":"SUM(X17:X28)","v":3544},null,{"$f":"SUM(Z17:Z28)","v":1959702},"$",{"$f":"SUM(AB17:AB28)","v":618219},"$",{"$f":"SUM(AD17:AD28)","v":2577921}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[5,"Non-Jurisdictional","Elect Plan","       APRC","$",0,null,0,"$",0,"$",0,"$",0,"$",{"$f":"SUM(J32:N32)","v":0},null,0,"$",0,"$",0,"$",null,null,{"$f":"P32+T32+V32","v":0},"$",0,"$",{"$f":"F32+Z32+AB32","v":0}]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null," "]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               "]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"`"]

{"sheet":"Change Calculation","index":28,"n_rows":55,"n_cols":22,"rows_kept":55,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"'Ex 4-Earnings Test'!A1","v":"Cause No. 38703-FAC135"}]
[]
[null,null,"          The following table summarizes the differences between the estimated and actual fuel costs for the reconciliation period:"]
[null,null,"           (used in testimony)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Percent Estimate"]
[null,null,null,null,null,null,null,"Actual",null,null,"Estimated",null,null,"Over (Under)"]
[null,null,null,null,"Month",null,null,"Cost",null,null,"Cost",null,null,"Actual"]
[]
[null,null,null,"Nov, 2021",null,null,null,{"$f":"+'Sch 5 p1'!E58","v":72.563000000000002},null,null,{"$f":"+'Sch 5 p1'!G58","v":32.116},null,null,{"$f":"ROUND(((K12-H12)/H12),4)","v":-0.55740000000000001}]
[null,null,null,"Dec, 2021",null,null,null,{"$f":"+'Sch 5 p2'!E58","v":47.423000000000002},null,null,{"$f":"+'Sch 5 p2'!G58","v":33.462000000000003},null,null,{"$f":"ROUND(((K13-H13)/H13),4)","v":-0.2944}]
[null,null,null,"Jan, 2022",null,null,null,{"$f":"+'Sch 5 p3'!E58","v":45.097000000000001},null,null,{"$f":"+'Sch 5 p3'!G58","v":35.600999999999999},null,null,{"$f":"ROUND(((K14-H14)/H14),4)","v":-0.21060000000000001}]
[]
[null,null,"          Testimony - 12A:"]
[null,null,"                    Difference in Estimated Cost from Base Cost = ",null,null,null,null,null,null,null,{"$f":"+'Sch 1'!L49","v":37.366},"-",null,"12.456 =",null,null,{"$f":"ROUND(K17-12.456,3)","v":24.91}]
[null,null,"          Testimony - 16A:"]
[null,null,"                    Weighted Average Actual = ",null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,"                    Weighted Average Estimated = ",null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[]
[null,null,null,null,null,null,null,null,null,"The error of the weighted average is an underestimate of:",{"$f":"ROUND((K20-H19)/H19,4)","v":{"$error":"#DIV/0!"}},null,null,"and"]
[]
[null,null,null,null,null,null,null,null,null,"the absolute average error is:",{"$f":"ROUND((N12+N13+N14)/3,4)","v":-0.35410000000000003},null,null,"."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,137.47,null,null,{"$f":"+H27-N26","v":-8.3899999999999864}]
[null,null,"1,000 kWh Customer:","@",{"$f":"+'Sch 1'!L75","v":13.472},"=",null,{"$f":"ROUND((E27+K50),2)","v":129.08000000000001},null,null,null,null,null,null,null,null,{"$f":"+Q26/N26","v":-6.1031497781334008E-2}]
[null,null,"          Less 1,000 kWh customer using fuel"]
[null,null,"          increment from previous filing:",null,null,null,null,123.03]
[null,null,null,null,null,null,null,{"$f":"ROUND((H27-H29),2)","v":6.05},null,"Decrease"]
[]
[null,null,null,null,null,null,null,{"$f":"ROUND((H30/H29)*100,2)","v":4.92},null,"%","Decrease"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[]
[null,"Per New Tariff Sheets Eff December",null,null,"Customer Charge",null,null,null,null,null,17]
[]
[null,null,null,null,"Energy"]
[null,null,null,null,"     1st 500 kwh",null,null,0.10645399999999999,null,null,{"$f":"ROUND(500*H46,2)","v":53.23}]
[null,null,null,null,"2nd 500 kwh",null,null,9.0751999999999999E-2,null,null,{"$f":"ROUND(500*H47,2)","v":45.38}]
[]
[]
[null,null,null,null,"Total Bill",null,null,null,null,null,{"$f":"+K43+K46+K47","v":115.60999999999999}]
[null,null,null,null,"Base Cost of Fuel"]
[null,null,null,null,"Adj for URT"]
[]
[null,null,null,null,"Sch 1 FAC factor",null,null,null,null,null,{"$f":"+K56","v":0}]
[null,null,null,null,"Total New Bill",null,null,null,null,null,{"$f":"+K50+K51+K54","v":115.60999999999999}]