{"text_format":"1","workbook":"xlsx","n_sheets":21,"sheets":["SCHEDULE MJL-D1","SCHEDULE MJL-D2","SCHEDULE MJL-D3","SCHEDULE MJL-D4","SCHEDULE MJL-D5","SCHEDULE MJL-D6","SCHEDULE MJL-D7","SCHEDULE MJL-D8","SCHEDULE MJL-D9","SCHEDULE MJL-D10","SCHEDULE MJL-D11-1 to 6","SCHEDULE MJL-D11-7","SCHEDULE MJL-D12-1","SCHEDULE MJL-D14","SCHEDULE MJL-D12-2","SCHEDULE MJL-D13-1","SCHEDULE MJL-D13-2","SCHEDULE MJL-D15","SCHEDULE MJL-D16","SCHEDULE MJL-D17","SCHEDULE MJL-D18"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":2,"defined_names":27,"comments":18,"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":"SCHEDULE MJL-D1","index":0,"n_rows":72,"n_cols":7,"rows_kept":72,"cut":false,"hidden":false,"merged":[[68,2,68,5],[63,2,65,5],[0,0,0,6],[1,0,1,6],[2,0,2,6],[3,0,3,6],[60,2,61,5]]}
["AMEREN MISSOURI"]
["ORIGINAL COST OF ELECTRIC PLANT"]
[{"$f":"\"BY FUNCTIONAL CLASSIFICATION \"&'SCHEDULE MJL-D3'!A3:G3","v":"BY FUNCTIONAL CLASSIFICATION FOR THE TWELVE MONTHS ENDED MARCH 31, 2022"}]
["($000)"]
[]
[]
[null,null,null,null,"TOTALS",null,"PRO FORMA"]
[null,null,null,null,"PER","PRO FORMA","ELECTRIC"]
["LINE",null,"FUNCTIONAL CLASSIFICATION",null,"BOOKS","ADJUSTMENTS","TOTALS"]
[null,null,"(A)",null,"(B)","(C)","(D)"]
[null,null,"INTANGIBLE PLANT"]
[1,null,"   FRANCHISES",null,{"$f":"+ROUND([1]Plant!$B$10*0.001,0)","v":100102},{"$f":"+ROUND(SUM([1]Plant!$C$10:$G$10)*0.001,0)","v":0},{"$f":"SUM(E12:F12)","v":100102}]
[{"$f":"1+A12","v":2},null,"   CALLAWAY LIFE EXTENSION DEFERRAL",null,{"$f":"+ROUND([1]Plant!$B$11*0.001,0)","v":2812},{"$f":"+ROUND(SUM([1]Plant!$C$11:$G$11)*0.001,0)","v":0},{"$f":"SUM(E13:F13)","v":2812}]
[3,null,"   MISC INTANGIBLE PLANT",null,{"$f":"+ROUND([1]Plant!$B$12*0.001,0)","v":582853},{"$f":"+ROUND(SUM([1]Plant!$C$12:$G$12)*0.001,0)","v":54772},{"$f":"SUM(E14:F14)","v":637625}]
[{"$f":"1+A14","v":4},null,"TOTAL INTANGIBLE PLANT",null,{"$f":"SUM(E12:E14)","v":685767},{"$f":"SUM(F12:F14)","v":54772},{"$f":"SUM(G12:G14)","v":740539}]
[]
[null,null,"PRODUCTION PLANT"]
[{"$f":"1+A15","v":5},null,"   NUCLEAR",null,{"$f":"+ROUND([1]Plant!$B$17*0.001,0)","v":3522205},{"$f":"+ROUND(SUM([1]Plant!$C$17:$G$17)*0.001,0)","v":-32615},{"$f":"SUM(E18:F18)","v":3489590}]
[{"$f":"1+A18","v":6},null,"   CALLAWAY POST OPERATIONAL ",null,{"$f":"+ROUND([1]Plant!$B$18*0.001,0)","v":116731},{"$f":"+ROUND(SUM([1]Plant!$C$18:$G$18)*0.001,0)","v":0},116731]
[{"$f":"1+A19","v":7},null,"   STEAM",null,{"$f":"+ROUND(([1]Plant!$B$19+[1]Plant!$B$20)*0.001,0)+1","v":5083574},{"$f":"+ROUND(SUM([1]Plant!$C$19:$G$20)*0.001,0)","v":-677631},4405943]
[{"$f":"1+A20","v":8},null,"   HYDRAULIC",null,{"$f":"+ROUND([1]Plant!$B$21*0.001,0)","v":623350},{"$f":"+ROUND(SUM([1]Plant!$C$21:$G$21)*0.001,0)","v":26054},649404]
[{"$f":"1+A21","v":9},null,"   WIND",null,{"$f":"+ROUND([1]Plant!$B$22*0.001,0)","v":1204170},{"$f":"+ROUND(SUM([1]Plant!$C$22:$G$22)*0.001,0)","v":-39436},1164734]
[10,null,"   OTHER",null,{"$f":"+ROUND([1]Plant!$B$23*0.001,0)","v":1301491},{"$f":"+ROUND(SUM([1]Plant!$C$23:$G$23)*0.001,0)","v":25336},1326827]
[11,null,"TOTAL PRODUCTION PLANT",null,{"$f":"SUM(E18:E23)","v":11851521},{"$f":"SUM(F18:F23)","v":-698292},{"$f":"SUM(G18:G23)","v":11153229}]
[]
[{"$f":"1+A24","v":12},null,"TRANSMISSION PLANT",null,{"$f":"+ROUND([1]Plant!$B$26*0.001,0)","v":1670668},{"$f":"+ROUND(SUM([1]Plant!$C$26:$G$26)*0.001,0)","v":209848},{"$f":"SUM(E26:F26)","v":1880516}]
[]
[{"$f":"+A26+1","v":13},null,"DISTRIBUTION PLANT",null,{"$f":"+ROUND([1]Plant!$B$28*0.001,0)","v":7423433},{"$f":"+ROUND(SUM([1]Plant!$C$28:$G$28)*0.001,0)","v":733300},{"$f":"SUM(E28:F28)","v":8156733}]
[]
[{"$f":"1+A28","v":14},null,"GENERAL PLANT",null,{"$f":"+ROUND([1]Plant!$B$30*0.001,0)","v":918473},{"$f":"+ROUND(SUM([1]Plant!$C$30:$G$30)*0.001,0)","v":91118},{"$f":"SUM(E30:F30)","v":1009591}]
[]
[{"$f":"1+A30","v":15},null,"INCENTIVE COMPENSATION CAPITALIZED",null,{"$f":"+ROUND([1]Plant!$B32*0.001,0)","v":0},{"$f":"+ROUND(SUM([1]Plant!$C$32:$G$32)*0.001,0)","v":-57150},{"$f":"SUM(E32:F32)","v":-57150}]
[]
[{"$f":"1+A32","v":16},null,"TOTAL PLANT IN SERVICE",null,{"$f":"E15+SUM(E24:E32)","v":22549862},{"$f":"F15+SUM(F24:F32)","v":333596},{"$f":"G15+SUM(G24:G32)","v":22883458}]
[]
[]
[]
[null,null,"PRO FORMA ADJUSTMENTS"]
[{"$f":"1+A34","v":17},-1,"Eliminate Plant balances related to FAS 143 Asset Retirement Obligation and ASC 842 Leases "]
[{"$f":"1+A39","v":18},null,null,"NUCLEAR",null,{"$f":"+ROUND([1]Plant!$C$17*0.001,0)","v":-101675}]
[{"$f":"1+A40","v":19},null,null,"STEAM",null,{"$f":"+ROUND([1]Plant!$C$19*0.001,0)","v":-140108}]
[{"$f":"1+A41","v":20},null,null,"WIND",null,{"$f":"+ROUND([1]Plant!$C$22*0.001,0)","v":-52681}]
[21,null,null,"DISTRIBUTION",null,{"$f":"+ROUND([1]Plant!$C$28*0.001,0)","v":0}]
[22,null,null,"OTHER",null,{"$f":"+ROUND([1]Plant!$C$23*0.001,0)","v":-428}]
[23,null,null,"GENERAL",null,{"$f":"+ROUND([1]Plant!$C$30*0.001,0)","v":-3737}]
[24,null,null,"  TOTAL",null,null,{"$f":"SUM(F40:F45)","v":-298629}]
[]
[{"$f":"1+A46","v":25},-2,"Plant Additions for the true-up period"]
[{"$f":"1+A48","v":26},null,null,"INTANGIBLE FRANCHISES",null,{"$f":"+ROUND(([1]Plant!$D$10)*0.001,0)","v":0}]
[27,null,null,"OTHER INTANGIBLE PLANT",null,{"$f":"+ROUND([1]Plant!$D$12*0.001,0)","v":79992}]
[28,null,null,"NUCLEAR",null,{"$f":"+ROUND([1]Plant!$D$17*0.001,0)","v":69059}]
[29,null,null,"STEAM",null,{"$f":"+ROUND(([1]Plant!$D$19+[1]Plant!$D$20)*0.001,0)","v":146987}]
[30,null,null,"HYDRAULIC",null,{"$f":"+ROUND([1]Plant!$D$21*0.001,0)","v":26054}]
[31,null,null,"WIND",null,{"$f":"+ROUND([1]Plant!$D$22*0.001,0)+1","v":13245}]
[32,null,null,"OTHER",null,{"$f":"+ROUND([1]Plant!$D$23*0.001,0)","v":25764}]
[33,null,null,"TRANSMISSION",null,{"$f":"+ROUND([1]Plant!$D$26*0.001,0)","v":209848}]
[34,null,null,"DISTRIBUTION",null,{"$f":"+ROUND([1]Plant!$D$28*0.001,0)","v":733300}]
[35,null,null,"GENERAL",null,{"$f":"+ROUND([1]Plant!$D$30*0.001,0)","v":112309}]
[36,null,null,"  TOTAL",null,null,{"$f":"SUM(F49:F58)","v":1416558}]
[]
[{"$f":"A59+1","v":37},"(3)","Reduce Meramec Energy Center plant investment in accordance with the Stipulation and Agreement from File No. ER-2021-0240.",null,null,null,{"$f":"+ROUND(([1]Plant!$E$34)*0.001,0)","v":-684510}]
[{"$f":"1+A61","v":38}]
[]
[{"$f":"A62+1","v":39},-4,"Eliminate portions of plant in service for multi use general assets which are applicable to gas operations.  For convenience, such assets are recorded as electric plant but are commonly used for both electric and gas."]
[{"$f":"1+A64","v":40}]
[{"$f":"1+A65","v":41}]
[{"$f":"1+A66","v":42},null,null,"GENERAL",null,null,{"$f":"+ROUND([1]Plant!$F$34*0.001,0)","v":-42658}]
[]
[{"$f":"1+A67","v":43},-5,"Reduce Plant-in-Service for specified incentive compensation capitalized."]
[{"$f":"1+A69","v":44},null,null,"GENERAL",null,null,{"$f":"+ROUND([1]Plant!$G$34*0.001,0)","v":-57165}]
[]
[{"$f":"1+A70","v":45},null,null,"TOTAL PRO FORMA ADJUSTMENTS",null,null,{"$f":"SUM(G40:G70)","v":333596}]

{"sheet":"SCHEDULE MJL-D2","index":1,"n_rows":86,"n_cols":7,"rows_kept":86,"cut":false,"hidden":false,"merged":[[82,2,82,5],[77,2,79,4],[61,2,62,4],[0,0,0,6],[2,0,2,6],[1,0,1,6],[3,0,3,6],[45,2,46,4]]}
["AMEREN MISSOURI"]
["TOTAL ELECTRIC RESERVES FOR DEPRECIATION AND AMORTIZATION"]
[{"$f":"+'SCHEDULE MJL-D1'!A3:G3","v":"BY FUNCTIONAL CLASSIFICATION FOR THE TWELVE MONTHS ENDED MARCH 31, 2022"}]
["($000)"]
[]
[]
[null,null,null,null,"TOTALS",null,"PRO FORMA"]
[null,null,null,null,"PER","PRO FORMA","ELECTRIC"]
["LINE",null,"FUNCTIONAL CLASSIFICATION",null,"BOOKS","ADJUSTMENTS","TOTALS"]
[null,null,"(A)",null,"(B)","(C)","(D)"]
[null,null,"INTANGIBLE PLANT"]
[1,null,"   FRANCHISES",null,{"$f":"+ROUND([1]Reserve!$C$10*0.001,0)","v":31486},{"$f":"+ROUND(SUM([1]Reserve!$D$10:$J$10)*0.001,0)","v":3175},{"$f":"E12+F12","v":34661}]
[{"$f":"1+A12","v":2},null,"   CALLAWAY LIFE EXTENSION DEFERRAL",null,{"$f":"+ROUND([1]Reserve!$C$11*0.001,0)","v":469},{"$f":"+ROUND(SUM([1]Reserve!$D$11:$J$11)*0.001,0)","v":78},{"$f":"E13+F13","v":547}]
[3,null,"   MISC INTANGIBLE PLANT",null,{"$f":"+ROUND([1]Reserve!$C$12*0.001,0)-1","v":281513},{"$f":"+ROUND(SUM([1]Reserve!$D$12:$J$12)*0.001,0)","v":-5426},{"$f":"E14+F14","v":276087}]
[{"$f":"1+A14","v":4},null,"TOTAL INTANGIBLE PLANT",null,{"$f":"SUM(E12:E14)","v":313468},{"$f":"SUM(F12:F14)","v":-2173},{"$f":"E15+F15","v":311295}]
[]
[null,null,"PRODUCTION PLANT"]
[{"$f":"1+A15","v":5},null,"   NUCLEAR",null,{"$f":"+ROUND([1]Reserve!$C$17*0.001,0)","v":1777698},{"$f":"+ROUND(SUM([1]Reserve!$D$17:$J$17)*0.001,0)","v":67495},1845193]
[{"$f":"1+A18","v":6},null,"   CALLAWAY POST OPERATIONAL ",null,{"$f":"+ROUND([1]Reserve!$C$18*0.001,0)","v":107205},{"$f":"+ROUND(SUM([1]Reserve!$D$18:$J$18)*0.001,0)","v":2766},{"$f":"E19+F19","v":109971}]
[{"$f":"1+A19","v":7},null,"   STEAM",null,{"$f":"+ROUND((SUM([1]Reserve!$C$19:$C$20))*0.001,0)","v":2378593},{"$f":"+ROUND(SUM([1]Reserve!$D$19:$J$20)*0.001,0)","v":-547234},1831359]
[{"$f":"1+A20","v":8},null,"   HYDRAULIC",null,{"$f":"+ROUND([1]Reserve!$C$21*0.001,0)","v":140530},{"$f":"+ROUND(SUM([1]Reserve!$D$21:$J$21)*0.001,0)","v":12036},152566]
[{"$f":"1+A21","v":9},null,"   WIND",null,{"$f":"+ROUND([1]Reserve!$C$22*0.001,0)","v":50147},{"$f":"+ROUND(SUM([1]Reserve!$D$22:$J$22)*0.001,0)","v":29278},79425]
[10,null,"   OTHER",null,{"$f":"+ROUND([1]Reserve!$C$23*0.001,0)-1","v":742951},{"$f":"+ROUND(SUM([1]Reserve!$D$23:$J$23)*0.001,0)+1","v":18480},761431]
[{"$f":"1+A23","v":11},null,"TOTAL PRODUCTION PLANT",null,{"$f":"SUM(E18:E23)","v":5197124},{"$f":"SUM(F18:F23)","v":-417179},4779945]
[]
[{"$f":"1+A24","v":12},null,"TRANSMISSION PLANT",null,{"$f":"+ROUND([1]Reserve!$C$26*0.001,0)","v":441573},{"$f":"+ROUND(SUM([1]Reserve!$D$26:$J$26)*0.001,0)","v":28687},470260]
[]
[{"$f":"1+A26","v":13},null,"DISTRIBUTION PLANT",null,{"$f":"+ROUND([1]Reserve!$C$28*0.001,0)","v":3205675},{"$f":"+ROUND(SUM([1]Reserve!$D$28:$J$28)*0.001,0)","v":157435},3363110]
[]
[{"$f":"1+A28","v":14},null,"GENERAL PLANT",null,{"$f":"+ROUND([1]Reserve!$C$30*0.001,0)","v":279071},{"$f":"+ROUND(SUM([1]Reserve!$D$30:$J$30)*0.001,0)","v":33696},312767]
[]
[{"$f":"1+A30","v":15},null,"INCENTIVE COMPENSATION CAPITALIZED",null,{"$f":"+ROUND([1]Reserve!$C$32*0.001,0)","v":0},{"$f":"+ROUND(SUM([1]Reserve!$D$32:$J$32)*0.001,0)","v":-15776},{"$f":"E32+F32","v":-15776}]
[]
[{"$f":"1+A32","v":16},null,"TOTAL DEPRC. & AMORT RESERVE",null,{"$f":"E15+E24+E26+E28+E30+E32","v":9436911},{"$f":"F15+F24+F26+F28+F30+F32","v":-215310},{"$f":"G15+G24+G26+G28+G30+G32","v":9221601}]
[]
[null,null,"PRO FORMA ADJUSTMENTS"]
[{"$f":"1+A34","v":17},-1,"Eliminate Reserve balances related to FAS 143 Asset Retirement Obligation and ASC 842 Leases"]
[{"$f":"1+A37","v":18},null,null,"NUCLEAR",null,{"$f":"+ROUND([1]Reserve!$D$17*0.001,0)","v":6828}]
[{"$f":"1+A38","v":19},null,null,"STEAM",null,{"$f":"+ROUND([1]Reserve!$D$19*0.001,0)","v":-83937}]
[20,null,null,"WIND",null,{"$f":"+ROUND([1]Reserve!$D$22*0.001,0)","v":-2128}]
[22,null,null,"DISTRIBUTION",null,{"$f":"+ROUND([1]Reserve!$D$28*0.001,0)","v":0}]
[23,null,null,"OTHER",null,{"$f":"+ROUND([1]Reserve!$D$23*0.001,0)","v":-2}]
[24,null,null,"GENERAL",null,{"$f":"+ROUND([1]Reserve!$D$30*0.001,0)","v":-1513}]
[{"$f":"1+A43","v":25},null,null,"  TOTAL",null,null,{"$f":"SUM(F38:F43)","v":-80752}]
[]
[{"$f":"1+A44","v":26},-2,"Reserve Balance at December 31, 2020 adjusted to reflect Reserve Balance at September 30, 2021 ."]
[{"$f":"1+A46","v":27}]
[{"$f":"1+A47","v":28},null,null,"INTANGIBLE FRANCHISES",null,{"$f":"+ROUND([1]Reserve!$E$10*0.001,0)","v":3175}]
[{"$f":"1+A48","v":29},null,null,"CALLAWAY LIFE EXTENSION DEFERRAL",null,{"$f":"+ROUND([1]Reserve!$E$11*0.001,0)","v":78}]
[{"$f":"1+A49","v":30},null,null,"MISC INTANGIBLE PLANT",null,{"$f":"+ROUND([1]Reserve!$E$12*0.001,0)","v":0}]
[{"$f":"A50+1","v":31},null,null,"NUCLEAR",null,{"$f":"+ROUND([1]Reserve!$E$17*0.001,0)","v":60018}]
[{"$f":"A51+1","v":32},null,null,"CALLAWAY POST OPERATIONAL ",null,{"$f":"+ROUND([1]Reserve!$E$18*0.001,0)","v":2766}]
[{"$f":"1+A52","v":33},null,null,"STEAM",null,{"$f":"+ROUND(SUM([1]Reserve!$E$19:$E$20)*0.001,0)-1","v":204723}]
[34,null,null,"HYDRAULIC",null,{"$f":"+ROUND([1]Reserve!$E$21*0.001,0)","v":11780}]
[35,null,null,"WIND",null,{"$f":"+ROUND([1]Reserve!$E$22*0.001,0)","v":31224}]
[36,null,null,"OTHER",null,{"$f":"+ROUND([1]Reserve!$E$23*0.001,0)","v":18229}]
[37,null,null,"TRANSMISSION",null,{"$f":"+ROUND([1]Reserve!$E$26*0.001,0)","v":27419}]
[38,null,null,"DISTRIBUTION",null,{"$f":"+ROUND([1]Reserve!$E$28*0.001,0)","v":152481}]
[39,null,null,"GENERAL",null,{"$f":"+ROUND([1]Reserve!$E$30*0.001,0)","v":37909}]
[40,null,null,"  TOTAL",null,null,{"$f":"SUM(F48:F59)","v":549802}]
[]
[{"$f":"1+A60","v":41},-3,"Adjustment to depreciation reserve for the additions to plant in service for the true-up period of January 1, 2021 through September 31, 2021."]
[{"$f":"1+A62","v":42}]
[{"$f":"1+A63","v":43},null,null,"INTANGIBLE FRANCHISES",null,{"$f":"+ROUND([1]Reserve!$F$10*0.001,0)","v":0}]
[{"$f":"1+A64","v":44},null,null,"MISC INTANGIBLE PLANT",null,{"$f":"+ROUND([1]Reserve!$F$12*0.001,0)","v":5720}]
[{"$f":"1+A65","v":45},null,null,"NUCLEAR",null,{"$f":"+ROUND([1]Reserve!$F$17*0.001,0)","v":650}]
[{"$f":"1+A66","v":46},null,null,"STEAM",null,{"$f":"+ROUND(SUM([1]Reserve!$F$19:$F$20)*0.001,0)","v":3207}]
[47,null,null,"HYDRAULIC",null,{"$f":"+ROUND([1]Reserve!$F$21*0.001,0)","v":256}]
[48,null,null,"WIND",null,{"$f":"+ROUND([1]Reserve!$F$22*0.001,0)","v":182}]
[49,null,null,"OTHER",null,{"$f":"+ROUND([1]Reserve!$F$23*0.001,0)","v":252}]
[50,null,null,"TRANSMISSION",null,{"$f":"+ROUND([1]Reserve!$F$26*0.001,0)","v":1268}]
[51,null,null,"DISTRIBUTION",null,{"$f":"+ROUND([1]Reserve!$F$28*0.001,0)+1","v":4954}]
[52,null,null,"GENERAL",null,{"$f":"+ROUND([1]Reserve!$F$30*0.001,0)","v":2487}]
[53,null,null,"  TOTAL",null,null,{"$f":"SUM(F64:F73)","v":18976}]
[]
[{"$f":"1+A74","v":54},"(4)","Meramec Energy Center adjustment. See Schedule MJL-D1 adjustment (3).",null,null,null,{"$f":"+ROUND([1]Reserve!$G$34*0.001,0)","v":-671227}]
[]
[{"$f":"1+A76","v":55},-5,"Eliminate portions of plant in service for multi use general assets which are applicable to gas operations.  For convenience, such assets are recorded as electric plant but are commonly used for both electric and gas"]
[{"$f":"1+A78","v":56}]
[{"$f":"1+A79","v":57}]
[{"$f":"1+A80","v":58},null,null,"GENERAL",null,null,{"$f":"+ROUND([1]Reserve!$I$34*0.001,0)","v":-16325}]
[]
[{"$f":"1+A81","v":59},-6,"Reduce Reserve for specified incentive compensation capitalized."]
[{"$f":"1+A83","v":60},null,null,"GENERAL",null,null,{"$f":"+ROUND([1]Reserve!$J$34*0.001,0)","v":-15784}]
[]
[{"$f":"1+A84","v":61},null,null,"TOTAL PRO FORMA ADJUSTMENTS",null,null,{"$f":"SUM(G37:G84)","v":-215310}]

{"sheet":"SCHEDULE MJL-D3","index":2,"n_rows":34,"n_cols":6,"rows_kept":34,"cut":false,"hidden":false,"merged":[[0,0,0,5],[31,2,31,4],[3,0,3,5],[30,2,30,4],[26,2,26,4]]}
["AMEREN MISSOURI"]
["AVERAGE FUEL AND MATERIALS & SUPPLIES INVENTORIES"]
["FOR THE TWELVE MONTHS ENDED MARCH 31, 2022"]
["($000)"]
[]
[null,null,null,"TOTALS",null,"PRO FORMA"]
[null,null,null,"PER","PRO FORMA","ELECTRIC"]
["LINE",null,"DESCRIPTION","BOOKS","ADJUSTMENTS","TOTALS"]
[null,null,"(A)","(B)","(C)","(D)"]
[]
[1,null,"AVERAGE NUCLEAR FUEL ",{"$f":"+ROUND('[1]Mat&Sup'!$D$10*0.001,0)","v":160034},0,{"$f":"D11+E11","v":160034}]
[]
[null,null,"AVERAGE FOSSIL FUEL:"]
[{"$f":"1+A11","v":2},null,"   COAL",{"$f":"+ROUND('[1]Mat&Sup2'!$D$30*0.001,0)","v":100641},{"$f":"+ROUND(SUM('[1]Mat&Sup2'!$D$37,'[1]Mat&Sup'!$B$58)*0.001,0)-1","v":24779},{"$f":"D14+E14","v":125420}]
[{"$f":"1+A14","v":3},null,"   OIL",{"$f":"+ROUND('[1]Mat&Sup'!$D$12*0.001,0)","v":3187},0,{"$f":"D15+E15","v":3187}]
[{"$f":"1+A15","v":4},null,"   STORED GAS FOR CTG'S",{"$f":"+ROUND('[1]Mat&Sup'!$D$13*0.001,0)","v":1436},0,{"$f":"D16+E16","v":1436}]
[{"$f":"1+A16","v":5},null,"TOTAL FOSSIL FUEL",{"$f":"SUM(D14:D16)","v":105264},{"$f":"SUM(E14:E16)","v":24779},{"$f":"D17+E17","v":130043}]
[]
[{"$f":"1+A17","v":6},null,"EMISSION ALLOWANCES AND RECS",{"$f":"+ROUND('[1]Mat&Sup'!$D$17*0.001,0)","v":42},0,{"$f":"D19+E19","v":42}]
[]
[{"$f":"1+A19","v":7},null,"GENERAL MATERIALS AND SUPPLIES",{"$f":"+ROUND('[1]Mat&Sup'!$C$19*0.001,0)","v":293597},{"$f":"ROUND(SUM(-'[1]Mat&Sup'!$E$19, '[1]Mat&Sup'!$D$21)*0.001,0)","v":-15766},{"$f":"D21+E21","v":277831}]
[]
[{"$f":"1+A21","v":8},null,"TOTAL",{"$f":"D11+D17+D19+D21","v":558937},{"$f":"E11+E17+E19+E21","v":9013},{"$f":"F11+F17+F19+F21","v":567950}]
[]
[]
[null,null,"PRO FORMA ADJUSTMENT"]
[{"$f":"1+A23","v":9},-1," Adjust Coal Supply to reflect 13 month average inventory levels priced at the January 2023 coal prices.",null,null,{"$f":"+ROUND(('[1]Mat&Sup2'!$D$37+'[1]Mat&Sup'!$B$58)*0.001,0)","v":24780}]
[]
[{"$f":"1+A27","v":10},"(2)","Meramec Energy Center adjustment. See Schedule MJL-D1 adjustment (3).",null,null,{"$f":"+ROUND('[1]Mat&Sup'!$D$21*0.001,0)","v":-13653}]
[]
[{"$f":"1+A29","v":11},"(3)","Eliminate portions of average fuel and general materials and supplies which are applicable to gas "]
[{"$f":"1+A31","v":12},null,"operations.",null,null,{"$f":"-ROUND('[1]Mat&Sup'!$E$19*0.001,0)","v":-2114}]
[]
[{"$f":"1+A32","v":13},null,"TOTAL PRO FORMA ADJUSTMENTS",null,null,{"$f":"SUM(F27:F33)","v":9013}]

{"sheet":"SCHEDULE MJL-D4","index":3,"n_rows":36,"n_cols":7,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,1,0,6],[1,1,1,6],[2,1,2,6],[3,1,3,6]]}
[null,"AMEREN MISSOURI"]
[null,"AVERAGE PREPAYMENTS"]
[null,{"$f":"+'SCHEDULE MJL-D3'!A3","v":"FOR THE TWELVE MONTHS ENDED MARCH 31, 2022"}]
[null,"($000)"]
[]
[null,null,null,null,"TOTALS",null,"PRO FORMA"]
[null,null,null,null,"PER","PRO FORMA","ELECTRIC"]
[null,"LINE",null,"DESCRIPTION ","BOOKS(1)","ADJUSTMENTS","TOTALS"]
[null,null,null,"(A)","(B)","(C)","(D)"]
[]
[null,1,null,"   RENTS (3)",{"$f":"+ROUND([1]Prepay!$C$9*0.001,0)","v":210},{"$f":"-ROUND([1]Prepay!$E$9*0.001,0)","v":-5},{"$f":"E11+F11","v":205}]
[null,{"$f":"1+B11","v":2},null,"   INSURANCE - DIRECT (2)",{"$f":"+ROUND([1]Prepay!$C$10*0.001,0)","v":11521},{"$f":"-ROUND([1]Prepay!$E$10*0.001,0)","v":-605},10916]
[null,{"$f":"1+B12","v":3},null,"   M/A COMM RADIO SYS SRVC AGREEMENT (3)",{"$f":"+ROUND([1]Prepay!$C$11*0.001,0)","v":0},{"$f":"-ROUND([1]Prepay!$E$11*0.001,0)","v":0},0]
[null,4,null,"   MEDICAL AND DENTAL VEBA (3)",{"$f":"+ROUND([1]Prepay!$C$12*0.001,0)","v":4481},{"$f":"-ROUND([1]Prepay!$E$12*0.001,0)","v":-105},4376]
[null,5,null,"   MEDICAL AND DENTAL VEBA (3)",{"$f":"+ROUND([1]Prepay!$C$13*0.001,0)","v":54},{"$f":"-ROUND([1]Prepay!$E$13*0.001,0)","v":0},54]
[null,{"$f":"1+B15","v":6},null,"   OPTIV GIGAMON (3)",{"$f":"+ROUND([1]Prepay!$C$14*0.001,0)","v":0},{"$f":"-ROUND([1]Prepay!$E$14*0.001,0)","v":0},{"$f":"E16+F16","v":0}]
[null,{"$f":"1+B16","v":7},null,"   CRM SALESFORCE SUBSCRIPTION (3)",{"$f":"+ROUND([1]Prepay!$C$19*0.001,0)","v":0},{"$f":"-ROUND([1]Prepay!$E$19*0.001,0)","v":0},{"$f":"E17+F17","v":0}]
[null,8,null,"   AGA MEMBERSHIP DUES (2)",{"$f":"+ROUND([1]Prepay!$C$20*0.001,0)","v":23},{"$f":"-ROUND([1]Prepay!$E$20*0.001,0)","v":-23},{"$f":"E18+F18","v":0}]
[null,9,null,"   KANSAS CITY POWER & LIGHT (2)",{"$f":"+ROUND([1]Prepay!$C$21*0.001,0)","v":0},{"$f":"-ROUND([1]Prepay!$E$21*0.001,0)","v":0},{"$f":"E19+F19","v":0}]
[null,{"$f":"1+B19","v":10},null,"   PALO ALTO ENTERPRISE (3)",{"$f":"+ROUND([1]Prepay!$C$22*0.001,0)","v":157},{"$f":"-ROUND([1]Prepay!$E$22*0.001,0)+1","v":-3},154]
[null,11,null,"   RCGA MEMBERSHIP DUES (2)",{"$f":"+ROUND([1]Prepay!$C$23*0.001,0)","v":41},{"$f":"-ROUND([1]Prepay!$E$23*0.001,0)","v":0},41]
[null,12,null,"   LOW INCOME WEATHERIZATION (2)",{"$f":"+ROUND([1]Prepay!$C$25*0.001,0)","v":499},{"$f":"-ROUND([1]Prepay!$E$25*0.001,0)","v":-109},{"$f":"E22+F22","v":390}]
[null,13,null,"   NOKIA WARRANTY (3)",{"$f":"+ROUND([1]Prepay!$C$26*0.001,0)","v":196},{"$f":"-ROUND([1]Prepay!$E$26*0.001,0)","v":-5},{"$f":"E23+F23","v":191}]
[null,{"$f":"1+B22","v":13},null,"TOTAL AVERAGE PREPAYMENTS",{"$f":"SUM(E11:E23)","v":17182},{"$f":"SUM(F11:F23)","v":-855},{"$f":"SUM(G11:G23)","v":16327}]
[]
[null,{"$f":"1+B24","v":14},-1,"Reflects 13 month average"]
[null,{"$f":"1+B26","v":15},-2,"Directly assigned to electric or gas."]
[null,13,-3,"Allocated to gas based on operating expenses excluding fuel and purchased power."]
[]
[]
[]
[null,null,"PRO FORMA ADJUSTMENT"]
[]
[null,{"$f":"B28+1","v":14},-1,"Eliminate portions of prepayments which are applicable to gas operations.  Allocated between electric",null,null,{"$f":"+F24","v":-855}]
[null,{"$f":"1+B34","v":15},null,"and gas operations based on operating expenses excluding purchased power, off-system sales and"]
[null,{"$f":"1+B35","v":16},null,"purchased gas."]

{"sheet":"SCHEDULE MJL-D5","index":4,"n_rows":47,"n_cols":10,"rows_kept":47,"cut":false,"hidden":false,"merged":[[0,0,0,10],[1,0,1,10]]}
["AMEREN MISSOURI"]
["TOTAL ELECTRIC CASH WORKING CAPITAL"]
[{"$f":"+'SCHEDULE MJL-D3'!A3","v":"FOR THE TWELVE MONTHS ENDED MARCH 31, 2022"}]
["($000)"]
[]
[null,null,null,null,null,null,null,null,null,"CASH WORKING"]
[null,null,null,null,"REVENUE","EXPENSE","NET",null,"TEST YEAR","CAPITAL"]
["LINE",null,"DESCRIPTION",null,"LAG","LEAD (1)","LEAD/LAG","FACTOR","EXPENSE ","REQUIREMENT"]
[null,null,"(A)",null,"(B)","(C)","(D)","(E)","(F)","(G)"]
[]
[1,null,"PAYROLL & WITHHOLDINGS",null,{"$f":"+[1]CashWorkCap!$C$10","v":37.020000000000003},{"$f":"[1]CashWorkCap!$D$10","v":-10.9},{"$f":"+E11+F11","v":26.120000000000005},{"$f":"ROUND(+G11/365,6)","v":7.1562000000000001E-2},{"$f":"+ROUND([1]CashWorkCap!$G$10*0.001,0)","v":340184},{"$f":"ROUND(+H11*I11,0)","v":24344}]
[{"$f":"1+A11","v":2},null,"PENSIONS AND BENEFITS",null,{"$f":"[1]CashWorkCap!$C$11","v":37.020000000000003},{"$f":"[1]CashWorkCap!$D$11","v":-15.7},{"$f":"+E12+F12","v":21.320000000000004},{"$f":"ROUND(+G12/365,6)","v":5.8410999999999998E-2},{"$f":"+ROUND([1]CashWorkCap!$G$11*0.001,0)","v":-49059},{"$f":"ROUND(+H12*I12,0)","v":-2866}]
[3,null,"OTHER EMPLOYEE BENEFITS",null,{"$f":"[1]CashWorkCap!$C$12","v":37.020000000000003},{"$f":"[1]CashWorkCap!$D$12","v":-17.649999999999999},{"$f":"+E13+F13","v":19.370000000000005},{"$f":"ROUND(+G13/365,6)","v":5.3067999999999997E-2},{"$f":"+ROUND([1]CashWorkCap!$G$12*0.001,0)","v":50506},{"$f":"ROUND(+H13*I13,0)","v":2680}]
[4,null,"FUEL"]
[5,null,"NUCLEAR",null,{"$f":"[1]CashWorkCap!$C$14","v":37.020000000000003},{"$f":"[1]CashWorkCap!$D$14","v":-15.21},{"$f":"+E15+F15","v":21.810000000000002},{"$f":"ROUND(+G15/365,6)","v":5.9753000000000001E-2},{"$f":"+ROUND([1]CashWorkCap!$G$14*0.001,0)","v":62765},{"$f":"ROUND(+H15*I15,0)","v":3750}]
[6,null,"COAL",null,{"$f":"[1]CashWorkCap!$C$15","v":37.020000000000003},{"$f":"[1]CashWorkCap!$D$15","v":-14.43},22.590000000000003,6.1890000000000001E-2,{"$f":"+ROUND([1]CashWorkCap!$G$15*0.001,0)","v":484349},{"$f":"ROUND(+H16*I16,0)","v":29976}]
[{"$f":"1+A16","v":7},null,"NATURAL GAS",null,{"$f":"[1]CashWorkCap!$C$16","v":37.020000000000003},{"$f":"[1]CashWorkCap!$D$16","v":-40.72},-3.6999999999999957,-1.0137E-2,{"$f":"+ROUND([1]CashWorkCap!$G$16*0.001,0)","v":21850},-221]
[8,null,"OIL",null,{"$f":"[1]CashWorkCap!$C$17","v":37.020000000000003},{"$f":"[1]CashWorkCap!$D$17","v":-14.69},{"$f":"+E18+F18","v":22.330000000000005},6.1178000000000003E-2,{"$f":"+ROUND([1]CashWorkCap!$G$17*0.001,0)","v":3098},{"$f":"ROUND(+H18*I18,0)","v":190}]
[9,null,"PURCHASED POWER",null,{"$f":"[1]CashWorkCap!$C$18","v":37.020000000000003},{"$f":"[1]CashWorkCap!$D$18","v":-18.100000000000001},{"$f":"+E19+F19","v":18.920000000000002},5.1836E-2,{"$f":"+ROUND([1]CashWorkCap!$G$18*0.001,0)","v":290134},{"$f":"ROUND(+H19*I19,0)","v":15039}]
[10,null,"INCENTIVE COMPENSATION",null,{"$f":"[1]CashWorkCap!$C$19","v":37.020000000000003},{"$f":"[1]CashWorkCap!$D$19","v":-250.8},-213.78,-0.58569899999999997,{"$f":"+ROUND([1]CashWorkCap!$G$19*0.001,0)","v":30427},-17821]
[11,null,"UNCOLLECTIBLE ACCOUNTS",null,{"$f":"[1]CashWorkCap!$C$20","v":37.020000000000003},{"$f":"[1]CashWorkCap!$D$20","v":-37.020000000000003},0,0,{"$f":"+ROUND([1]CashWorkCap!$G$20*0.001,0)","v":7849},0]
[12,null,"OTHER OPERATING EXPENSES",null,{"$f":"[1]CashWorkCap!$C$21","v":37.020000000000003},{"$f":"[1]CashWorkCap!$D$21","v":-42.25},-5.2299999999999969,-1.4329E-2,{"$f":"+ROUND([1]CashWorkCap!$G$21*0.001,0)+1","v":504116},{"$f":"ROUND(+H22*I22,0)","v":-7223}]
[]
[{"$f":"1+A22","v":13},null,"TOTAL O&M EXPENSES",null,null,null,null,null,{"$f":"ROUND([1]CashWorkCap!$G$23*0.001,0)","v":1746220}]
[]
[{"$f":"1+A24","v":14},null,"     TOTAL CASH WORKING CAPITAL REQUIREMENT",null,null,null,null,null,null,{"$f":"SUM(J11:J22)","v":47848}]
[]
[{"$f":"1+A26","v":15},null,"FICA - EMPLOYER'S PORTION",null,{"$f":"[1]CashWorkCap!$C$28","v":37.020000000000003},{"$f":"[1]CashWorkCap!$D$28","v":-9.3800000000000008},{"$f":"+E28+F28","v":27.64},{"$f":"ROUND(+G28/365,6)","v":7.5726000000000002E-2},{"$f":"+ROUND([1]CashWorkCap!$G$28*0.001,0)","v":21086},{"$f":"ROUND(+H28*I28,0)","v":1597}]
[{"$f":"1+A28","v":16},null,"ST. LOUIS PAYROLL EXPENSE TAXES",null,{"$f":"[1]CashWorkCap!$C$29","v":37.020000000000003},{"$f":"[1]CashWorkCap!$D$29","v":-9.3800000000000008},{"$f":"+E29+F29","v":27.64},{"$f":"ROUND(+G29/365,6)","v":7.5726000000000002E-2},{"$f":"+ROUND([1]CashWorkCap!$G$29*0.001,0)","v":449},{"$f":"ROUND(+H29*I29,0)","v":34}]
[17,null,"FEDERAL UNEMPLOYMENT TAXES",null,{"$f":"[1]CashWorkCap!$C$30","v":37.020000000000003},{"$f":"[1]CashWorkCap!$D$30","v":-9.3800000000000008},27.64,{"$f":"ROUND(+G30/365,6)","v":7.5726000000000002E-2},{"$f":"+ROUND([1]CashWorkCap!$G$30*0.001,0)","v":180},14]
[18,null,"STATE UNEMPLOYMENT TAXES",null,{"$f":"[1]CashWorkCap!$C$31","v":37.020000000000003},{"$f":"[1]CashWorkCap!$D$31","v":-9.3800000000000008},27.64,7.5726000000000002E-2,{"$f":"+ROUND([1]CashWorkCap!$G$31*0.001,0)","v":42},3]
[19,null,"CORPORATE FRANCHISE TAXES",null,{"$f":"[1]CashWorkCap!$C$32","v":37.020000000000003},{"$f":"[1]CashWorkCap!$D$32","v":-233.19},-196.17,-0.53745200000000004,{"$f":"+ROUND([1]CashWorkCap!$G$32*0.001,0)","v":136},-73]
[20,null,"PROPERTY TAXES",null,{"$f":"[1]CashWorkCap!$C$33","v":37.020000000000003},{"$f":"[1]CashWorkCap!$D$33","v":-183},-145.97999999999999,-0.39994499999999999,{"$f":"+ROUND([1]CashWorkCap!$G$33*0.001,0)","v":172041},-68807]
[21,null,"DECOMMISSIONING FEES",null,{"$f":"[1]CashWorkCap!$C$34","v":37.020000000000003},{"$f":"[1]CashWorkCap!$D$34","v":-69.5},{"$f":"+E34+F34","v":-32.479999999999997},{"$f":"ROUND(+G34/365,6)","v":-8.8985999999999996E-2},{"$f":"+ROUND([1]CashWorkCap!$G$34*0.001,0)","v":6759},-601]
[22,null,"SALES TAXES",null,{"$f":"[1]CashWorkCap!$C$35","v":37.020000000000003},{"$f":"[1]CashWorkCap!$D$35","v":-9.31},27.71,7.5917999999999999E-2,{"$f":"+ROUND([1]CashWorkCap!$G$35*0.001,0)","v":75938},5765]
[{"$f":"1+A35","v":23},null,"MO & IA USE TAXES",null,{"$f":"[1]CashWorkCap!$C$36","v":37.020000000000003},{"$f":"[1]CashWorkCap!$D$36","v":-76.25},-39.229999999999997,-0.10747900000000001,{"$f":"+ROUND([1]CashWorkCap!$G$36*0.001,0)","v":3907},-420]
[{"$f":"1+A36","v":24},null,"IL USE TAXES",null,{"$f":"[1]CashWorkCap!$C$37","v":37.020000000000003},{"$f":"[1]CashWorkCap!$D$37","v":-35.78},{"$f":"+E37+F37","v":1.240000000000002},{"$f":"ROUND(+G37/365,6)","v":3.3969999999999998E-3},{"$f":"+ROUND([1]CashWorkCap!$G$37*0.001,0)","v":68},{"$f":"ROUND(+H37*I37,0)","v":0}]
[25,null,"FED EXCISE HEAVY USE TAX",null,{"$f":"[1]CashWorkCap!$C$38","v":37.020000000000003},{"$f":"[1]CashWorkCap!$D$38","v":125.57},{"$f":"+E38+F38","v":162.59},{"$f":"ROUND(+G38/365,6)","v":0.44545200000000001},{"$f":"+ROUND([1]CashWorkCap!$G$38*0.001,0)","v":22},{"$f":"ROUND(+H38*I38,0)","v":10}]
[{"$f":"1+A38","v":26},null,"SELF PROCURED INS TAX",null,{"$f":"[1]CashWorkCap!$C$39","v":37.020000000000003},{"$f":"[1]CashWorkCap!$D$39","v":-241.5},-204.48,-0.56021900000000002,{"$f":"+ROUND([1]CashWorkCap!$G$39*0.001,0)","v":113},-63]
[27,null,"OHIO COMMERCIAL ACTIVITY TAX",null,{"$f":"[1]CashWorkCap!$C$40","v":37.020000000000003},{"$f":"[1]CashWorkCap!$D$40","v":50},87.02000000000001,0.23841100000000001,{"$f":"+ROUND([1]CashWorkCap!$G$40*0.001,0)","v":1},0]
[28,null,"GROSS RECEIPTS TAXES",null,{"$f":"[1]CashWorkCap!$C$41","v":24.27},{"$f":"[1]CashWorkCap!$D$41","v":-26.99},-2.7199999999999989,-7.4520000000000003E-3,{"$f":"+ROUND([1]CashWorkCap!$G$41*0.001,0)+1","v":145598},-1085]
[]
[{"$f":"1+A41","v":29},null,"TOTAL TAXES AND OTHER EXPENSES",null,null,null,null,null,{"$f":"SUM(I28:I41)","v":426340}]
[]
[{"$f":"1+A43","v":30},null,"     NET CUSTOMER SUPPLIED FUNDS",null,null,null,null,null,null,{"$f":"SUM(J28:J41)","v":-63626}]
[]
[{"$f":"1+A45","v":31},null,"NET CASH WORKING CAPITAL REQUIREMENT",null,null,null,null,null,null,{"$f":"J26+J45","v":-15778}]

{"sheet":"SCHEDULE MJL-D6","index":5,"n_rows":24,"n_cols":10,"rows_kept":24,"cut":false,"hidden":false,"merged":[[5,0,5,10],[4,0,4,10],[0,0,0,10],[1,0,1,10],[2,0,2,10],[3,0,3,10]]}
["AMEREN MISSOURI"]
["TOTAL ELECTRIC FEDERAL AND STATE INCOME TAX AND CITY EARNINGS TAX CASH REQUIREMENTS"]
["AND INTEREST EXPENSE CASH REQUIREMENT "]
[{"$f":"'SCHEDULE MJL-D5'!A3","v":"FOR THE TWELVE MONTHS ENDED MARCH 31, 2022"}]
["($000)"]
[]
[]
[null,null,null,null,null,null,null,null,null,"CASH WORKING"]
[null,null,null,null,"REVENUE","EXPENSE","NET",null,"TEST YEAR","CAPITAL"]
["LINE",null,"DESCRIPTION",null,"LAG","LEAD (1)","LEAD/LAG","FACTOR","EXPENSE ","REQUIREMENT"]
[null,null,"(A)",null,"(B)","(C)","(D)","(E)","(F)","(G)"]
[]
[]
[1,null,"FEDERAL INCOME TAX CASH REQUIREMENT",null,{"$f":"[1]CashWorkCap!$C$51","v":37.020000000000003},{"$f":"[1]CashWorkCap!$D$51","v":-38},{"$f":"+E14+F14","v":-0.97999999999999687},{"$f":"ROUND(+G14/365,6)","v":-2.6849999999999999E-3},{"$f":"+ROUND([1]CashWorkCap!$G$51*0.001,0)","v":70244},{"$f":"ROUND(+H14*I14,0)","v":-189}]
[]
[{"$f":"1+A14","v":2},null,"MO STATE INCOME TAX CASH REQUIREMENT",null,{"$f":"[1]CashWorkCap!$C$52","v":37.020000000000003},{"$f":"[1]CashWorkCap!$D$52","v":-38},{"$f":"+E16+F16","v":-0.97999999999999687},{"$f":"ROUND(+G16/365,6)","v":-2.6849999999999999E-3},{"$f":"+ROUND([1]CashWorkCap!$G$52*0.001,0)","v":23910},{"$f":"ROUND(+H16*I16,0)","v":-64}]
[]
[{"$f":"1+A16","v":3},null,"IN STATE INCOME TAX CASH REQUIREMENT ",null,{"$f":"[1]CashWorkCap!$C$53","v":37.020000000000003},{"$f":"[1]CashWorkCap!$D$53","v":-14},{"$f":"+E18+F18","v":23.020000000000003},{"$f":"ROUND(+G18/365,6)","v":6.3067999999999999E-2},{"$f":"+ROUND([1]CashWorkCap!$G$53*0.001,0)","v":0},{"$f":"ROUND(+H18*I18,0)","v":0}]
[]
[{"$f":"1+A18","v":4},null,"IA STATE INCOME TAX CASH REQUIREMENT",null,{"$f":"[1]CashWorkCap!$C$54","v":37.020000000000003},{"$f":"[1]CashWorkCap!$D$54","v":77},{"$f":"+E20+F20","v":114.02000000000001},{"$f":"ROUND(+G20/365,6)","v":0.312384},{"$f":"+ROUND([1]CashWorkCap!$G$54*0.001,0)","v":0},{"$f":"ROUND(+H20*I20,0)","v":0}]
[]
[{"$f":"1+A20","v":5},null,"CITY EARNINGS TAX CASH REQUIREMENT",null,{"$f":"[1]CashWorkCap!$C$55","v":37.020000000000003},{"$f":"[1]CashWorkCap!$D$55","v":-274.5},{"$f":"+E22+F22","v":-237.48},{"$f":"ROUND(+G22/365,6)","v":-0.65063000000000004},{"$f":"+ROUND([1]CashWorkCap!$G$55*0.001,0)","v":138},{"$f":"ROUND(+H22*I22,0)+1","v":-89}]
[]
[6,null,"INTEREST EXPENSE CASH REQUIREMENT",null,{"$f":"[1]CashWorkCap!$C$56","v":37.020000000000003},{"$f":"[1]CashWorkCap!$D$56","v":-91.37},{"$f":"+E24+F24","v":-54.35},{"$f":"ROUND(+G24/365,6)","v":-0.14890400000000001},{"$f":"+ROUND([1]CashWorkCap!$G$56*0.001,0)","v":215984},{"$f":"ROUND(+H24*I24,0)","v":-32161}]

{"sheet":"SCHEDULE MJL-D7","index":6,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,0,0,4]]}
["AMEREN MISSOURI"]
["TOTAL ELECTRIC AVERAGE CUSTOMER ADVANCES FOR CONSTRUCTION AND "]
["AVERAGE CUSTOMER DEPOSITS"]
[{"$f":"'SCHEDULE MJL-D4'!B3","v":"FOR THE TWELVE MONTHS ENDED MARCH 31, 2022"}]
["($000)"]
[]
[]
["LINE",null,"DESCRIPTION",null,"TOTAL ELECTRIC"]
[null,null,"(A)",null,"(B)"]
[]
[]
[]
[{"$f":"1","v":1},null,"AVERAGE CUSTOMER ADVANCES FOR CONSTRUCTION",null,{"$f":"ROUND('[1]Rate Base'!$C$29*0.001,0)","v":-546}]
[]
[]
[{"$f":"1+A13","v":2},null,"AVERAGE CUSTOMER DEPOSITS",null,{"$f":"ROUND('[1]Rate Base'!$C$31*0.001,0)","v":-18816}]

{"sheet":"SCHEDULE MJL-D8","index":7,"n_rows":34,"n_cols":8,"rows_kept":34,"cut":false,"hidden":false,"merged":[[9,2,9,5],[10,2,10,5]]}
["AMEREN MISSOURI"]
["OTHER REGULATORY ASSETS "]
["AND REGULATORY LIABILITIES "]
[{"$f":"+'SCHEDULE MJL-D9'!A3:H3","v":"FOR THE TWELVE MONTHS ENDED MARCH 31, 2022"}]
["($000)"]
[]
[]
[]
[null,null,null,null,null,null,null,"TOTAL"]
["LINE",null,"DESCRIPTION",null,null,null,null,"ELECTRIC"]
[null,null,"(A)",null,null,null,null,"(B)(1)"]
[]
[]
[]
[{"$f":"1","v":1},null,"PENSIONS",null,null,null,null,{"$f":"+ROUND(SUM('[1]Rate Base'!$C$33:$C$38)*0.001,0)","v":-29516}]
[]
[]
[{"$f":"1+A15","v":2},null,"OTHER POST-EMPLOYMENT BENEFITS",null,null,null,null,{"$f":"+ROUND(SUM('[1]Rate Base'!$C$39:$C$44)*0.001,0)","v":-10163}]
[]
[]
[{"$f":"1+A18","v":3},null,"PAYS REGULATORY ASSET",null,null,null,null,{"$f":"+ROUND('[1]Rate Base'!$C$47*0.001,0)","v":1861}]
[]
[]
[{"$f":"1+A21","v":4},null,"PISA REGULATORY ASSET",null,null,null,null,{"$f":"+ROUND('[1]Rate Base'!$C$52*0.001,0)","v":394572}]
[]
[]
[{"$f":"1+A24","v":5},null,"MERAMEC RETIREMENT ASSET",null,null,null,null,{"$f":"+ROUND('[1]Rate Base'!$C$50*0.001,0)","v":38581}]
[]
[]
[6,null,"UNDER COLLECTED AMORTIZATIONS IN RATE BASE",null,null,null,null,{"$f":"+ROUND('[1]Rate Base'!$C$54*0.001,0)","v":161}]
[]
[]
[{"$f":"1+A30","v":7},null,"(1)  A positive balance is a Regulatory Asset and a negative balance is a"]
[{"$f":"1+A33","v":8},null,"       Regulatory Liability."]

{"sheet":"SCHEDULE MJL-D9","index":8,"n_rows":25,"n_cols":8,"rows_kept":25,"cut":false,"hidden":false,"merged":[[24,2,24,7],[0,0,0,7],[2,0,2,7],[7,2,7,3],[8,2,8,3],[3,0,3,7]]}
["AMEREN MISSOURI"]
["ACCUMULATED DEFERRED INCOME TAXES"]
[{"$f":"+'SCHEDULE MJL-D3'!A3:G3","v":"FOR THE TWELVE MONTHS ENDED MARCH 31, 2022"}]
["($000)"]
[]
[null,null,null,null,null,"TOTAL",null,"PRO FORMA"]
[null,null,null,null,null,"ELECTRIC","PRO FORMA","ELECTRIC"]
["LINE",null,"DESCRIPTION",null,null,"PER BOOKS","ADJUSTMENTS","TOTAL"]
[null,null,"(A)",null,null,"(B)","(C)","(D)"]
[]
[1,null,"ACCOUNT 190",null,null,{"$f":"ROUND([1]AccumDef!$D$69*0.001,0)","v":36591},{"$f":"ROUND([1]AccumDef!$F$69*0.001,0)","v":-3349},{"$f":"+F11+G11","v":33242}]
[]
[2,null,"ACCOUNT 281",null,null,{"$f":"ROUND([1]AccumDef!$D$75*0.001,0)","v":-88067},{"$f":"ROUND([1]AccumDef!$F$75*0.001,0)","v":0},{"$f":"+F13+G13","v":-88067}]
[]
[3,null,"ACCOUNT 282",null,null,{"$f":"ROUND([1]AccumDef!$D$140*0.001,0)","v":-2768510},{"$f":"ROUND([1]AccumDef!$F$140*0.001,0)","v":-43313},{"$f":"+F15+G15","v":-2811823}]
[]
[4,null,"ACCOUNT 283",null,null,{"$f":"ROUND([1]AccumDef!$D$184*0.001,0)","v":-98060},{"$f":"ROUND([1]AccumDef!$F$184*0.001,0)","v":-3500},{"$f":"+F17+G17","v":-101560}]
[]
[5,null,"MERAMEC ADJUSTMENT",null,null,0,0,{"$f":"+F19+G19","v":0}]
[]
[6,null,"TOTAL ACCUMULATED DEFERRED INCOME TAXES",null,null,{"$f":"SUM(F11:F20)","v":-2918046},{"$f":"SUM(G11:G20)","v":-50162},{"$f":"SUM(H11:H20)","v":-2968208}]
[]
[]
[null,null,"PRO FORMA ADJUSTMENT:"]
[7,null,"Changes in balances from March 31, 2022 to December 31, 2022, which is the end of the true-up period."]

{"sheet":"SCHEDULE MJL-D10","index":9,"n_rows":65,"n_cols":6,"rows_kept":65,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
["AMEREN MISSOURI"]
["TOTAL ELECTRIC PER BOOK AND PRO FORMA OPERATING REVENUES"]
[{"$f":"'SCHEDULE MJL-D5'!A3","v":"FOR THE TWELVE MONTHS ENDED MARCH 31, 2022"}]
["($000)"]
[]
[]
[]
[null,null,null,null,null,"ADJUSTED"]
[null,null,null,"TOTAL ","PRO FORMA","TOTAL "]
["LINE",null,"DESCRIPTION","ELECTRIC","ADJUSTMENTS","ELECTRIC"]
[null,null,"(A)","(B)","(C)","(D)"]
[]
[null,null,"OPERATING REVENUES"]
[1,null,"RETAIL REVENUES",{"$f":"+ROUND(([1]Revenues!$C$10)*0.001,0)","v":2913418},{"$f":"SUM(D31:D43)","v":-195834},{"$f":"D14+E14","v":2717584}]
[{"$f":"1+A14","v":2},null,"PROVISION FOR RATE REFUNDS",{"$f":"+ROUND(([1]Revenues!$C$29)*0.001,0)","v":-23766},{"$f":"+E46","v":23766},{"$f":"D15+E15","v":0}]
[{"$f":"1+A15","v":3},null,"OTHER ELECTRIC REVENUES",{"$f":"+ROUND(([1]Revenues!$C$45)*0.001,0)","v":177165},{"$f":"E57","v":-92173},{"$f":"D16+E16","v":84992}]
[]
[{"$f":"1+A16","v":4},null,"TOTAL REVENUES",{"$f":"SUM(D13:D16)","v":3066817},{"$f":"SUM(E13:E16)","v":-264241},{"$f":"SUM(F13:F16)","v":2802576}]
[]
[{"$f":"1+A18","v":5},null,"DISPOSITION OF ALLOWANCES",{"$f":"+ROUND(([1]Revenues!$C$47)*0.001,0)","v":0},{"$f":"+E59","v":0},{"$f":"D20+E20","v":0}]
[]
[{"$f":"1+A20","v":6},null,"OFF-SYSTEM SALES - ENERGY",{"$f":"+ROUND(([1]Revenues!$C$49)*0.001,0)","v":223764},{"$f":"+E61","v":56291},{"$f":"D22+E22","v":280055}]
[]
[{"$f":"1+A22","v":7},null,"OFF-SYSTEM SALES-CAPACITY REVENUE",{"$f":"+ROUND(([1]Revenues!$C$51)*0.001,0)","v":18324},{"$f":"+E63","v":211108},{"$f":"D24+E24","v":229432}]
[]
[{"$f":"A24+1","v":8},null,"TOTAL REVENUES PER BOOKS",{"$f":"SUM(D18:D24)","v":3308905},{"$f":"SUM(E18:E24)","v":3158},{"$f":"SUM(F18:F24)","v":3312063}]
[]
[]
[]
[null,null,"PRO FORMA ADJUSTMENTS:"]
[{"$f":"1+A26","v":9},-1,"REMOVE ADD ON REVENUE TAX",{"$f":"ROUND([1]Revenues!$E$12*0.001,0)","v":-143699}]
[{"$f":"1+A31","v":10},-2,"ELIMINATE  REVENUE FROM MEEIA RECOVERIES",{"$f":"ROUND(([1]Revenues!$E$11+[1]Revenues!$E$16)*0.001,0)","v":-135558}]
[11,-3,"ELIMINATE  REVENUE FROM FAC RECOVERIES",{"$f":"ROUND([1]Revenues!$E$14*0.001,0)","v":-88220}]
[12,-4,"ELIMINATE  UNBILLED REVENUE",{"$f":"ROUND([1]Revenues!$E$13*0.001,0)","v":-22430}]
[{"$f":"1+A34","v":13},-5,"ANNUALIZE RATE CHANGE",{"$f":"ROUND([1]Revenues!$E$19*0.001,0)-1","v":214415}]
[14,-6,"ADJUST FOR EDI",{"$f":"ROUND([1]Revenues!$E$20*0.001,0)","v":-676}]
[15,-7,"ADJUST FOR COMMUNITY SOLAR",{"$f":"ROUND([1]Revenues!$E$21*0.001,0)","v":221}]
[16,-8,"ADJUST FOR GROWTH",{"$f":"ROUND([1]Revenues!$E$22*0.001,0)","v":5893}]
[17,-9,"ADJUST FOR RESRAM REVENUES",{"$f":"ROUND([1]Revenues!$E$15*0.001,0)","v":-1531}]
[18,-10,"ADJUST FOR ENERGY EFFICIENCY AND SOLAR ANNUALIZATION",{"$f":"ROUND([1]Revenues!$E$23*0.001,0)","v":-16225}]
[19,-11,"DAYS ADJUSTMENT",{"$f":"ROUND([1]Revenues!$E$24*0.001,0)","v":8567}]
[20,-12,"ADJUST FOR BILLING UNITS",{"$f":"ROUND([1]Revenues!$E$25*0.001,0)","v":12594}]
[21,-13,"ADJUST FOR NORMAL WEATHER ",{"$f":"ROUND([1]Revenues!$E$26*0.001,0)","v":-29185}]
[22,null,"TOTAL",null,{"$f":"SUM(D31:D43)","v":-195834}]
[]
[{"$f":"1+A44","v":23},-14,"ELIMINATE  PROVISION FOR RATE REFUNDS",null,{"$f":"ROUND([1]Revenues!$E$29*0.001,0)","v":23766}]
[]
[{"$f":"1+A46","v":24},-15,"ADJUST TRANSMISSION REVENUES",{"$f":"ROUND((SUM([1]Revenues!$E$32:$E$34))*0.001,0)","v":348}]
[{"$f":"1+A48","v":25},-16,"MISC REVENUE FROM COAL REFINEMENT",{"$f":"ROUND([1]Revenues!$E$38*0.001,0)","v":-311}]
[26,-17,"ADJUST LATE FEE REVENUE",{"$f":"ROUND([1]Revenues!$E$36*0.001,0)","v":-2151}]
[27,-18,"REMOVE CALLAWAY INSURANCE RECOVERIES",{"$f":"ROUND([1]Revenues!$E$37*0.001,0)","v":-87950}]
[28,-19,"ADJUST LEASE REVENUE FROM RENT",{"$f":"ROUND([1]Revenues!$E$39*0.001,0)+1","v":196}]
[29,-20,"MISC LEASE REVENUE FROM SOFTWARE LEASES",{"$f":"ROUND([1]Revenues!$E$41*0.001,0)","v":-922}]
[30,-21,"ADJUST BOA LEASE REVENUE",{"$f":"ROUND([1]Revenues!$E$40*0.001,0)","v":-375}]
[31,-22,"ADJUST FOR PAYS REVENUES",{"$f":"ROUND([1]Revenues!$E$42*0.001,0)","v":19}]
[32,-23,"REMOVE ADD ON REVENUE TAX",{"$f":"ROUND([1]Revenues!$E$43*0.001,0)","v":-1027}]
[{"$f":"1+A56","v":33},null,"TOTAL",null,{"$f":"SUM(D48:D56)","v":-92173}]
[]
[{"$f":"1+A57","v":34},-24,"ELIMINATE  DISPOSITION OF ALLOWANCES",null,{"$f":"ROUND([1]Revenues!$E$47*0.001,0)","v":0}]
[]
[{"$f":"1+A59","v":35},-25,"ADJUST OFF-SYSTEM SALES - ENERGY",null,{"$f":"ROUND([1]Revenues!$E$49*0.001,0)-1","v":56291}]
[]
[{"$f":"1+A61","v":36},-26,"ADJUST OFF-SYSTEM SALES - CAPACITY",null,{"$f":"ROUND([1]Revenues!$E$51*0.001,0)","v":211108}]
[]
[{"$f":"1+A63","v":37},null,"TOTAL PRO FORMA ADJUSTMENTS",null,{"$f":"SUM(E31:E63)","v":3158}]

{"sheet":"SCHEDULE MJL-D11-1 to 6","index":10,"n_rows":61,"n_cols":77,"rows_kept":61,"cut":false,"hidden":false,"merged":[[45,65,60,65],[45,0,60,0],[45,26,60,26],[45,13,60,13],[45,39,60,39],[45,52,60,52]]}
[null,null,null,null,null,"#1","#2","#3","#4","#5","#6","#7","#8",null,null,null,null,"#9","#10","#11","#12","#13","#14","#15","#16","#17",null,null,null,null,"#18","#19","#20","#21","#22","#23","#24","#25","#26",null,null,null,null,"#27","#28","#29","#30","#31","#32","#33","#34","#35",null,null,null,null,"#36","#37","#38","#39","#40","#41","#42","#43","#44",null,null,null,null,"#45","#46","#47","#48","#49"]
[null,null,"Title included in Page header for printing purposes.",null,null,null,null,"LONG TERM",null,"ADJUST",null,null,null,null,null,null,null,null,null,null,null,null,"REMOVE",null,null,null,null,null,null,null,null,null,null,null,null,"ENERGY EFFICIENCY",null,null,null,null,null,null,null,"PRO FORMA",null,"REBASE","AMORTIZE",null,null,null,"BOARD OF",null,null,null,null,null,"INCREASE"]
[null,null,null,null,"TOTAL",null,"INCENTIVE","INCENTIVE","CHANGE IN FUEL","PURCHASED","MARK TWAIN","REMOVE","COAL ",null,null,null,null,"STEAM ","RUSH IISLAND","MERAMEC","ELIMINATE","CALLAWAY","CALLAWAY","CALLAWAY","OTHER ","REBASE",null,null,null,null,"ELIMINATE","ANNUALIZE SOLAR","DEPRECIATION","NORMALIZE","ADD INTEREST","PROGRAM COST","PAYS","ANNUALIZE",null,null,null,null,null,"MEDICAL & ","NON-QUALIFIED","PENSION","PENSION","RESRAM","NET",null,"DIRECTORS","NORMALIZE",null,null,null,null,"BUILDING ","RECENTLY","SOFTWARE","ALLOCATION","AMR","CUSTOMER ","CLEAN ENERGY","ELECTRIC","CUSTOMER ",null,null,null,null,"CYBERSECURITY","SOFTWARE ",null,null,"EV",null,"TOTAL","PRO FORMA"]
[null,null,null,null,"PER","LABOR","COMPENSATION","COMPENSATION","EXPENSE FOR","POWER FOR","TRANSMISSION","MEMBERSHIP","REFINEMENT",null,null,null,null,"PLANT","MAINTENANCE ","MAINTENANCE ","FAC","REFUELING","REFUELING","UNPLANNED","RES","RES",null,null,null,null,"SOLAR","REBATE","TO O&M","STORM","ON CUSTOMER","RECOVERY","PROGRAM","BAD DEBT","INSURANCE",null,null,null,null,"BENEFIT","PENSION","AND OPEB","AND OPEB","BASE ","RATE CASE","MPSC","EXPENSE","STUDY",null,null,null,null,"RENT FROM ","EXITED","RENTAL","FACTOR","COST","AFFORDABILITY","TRANSITION","COSTS","CONVENIENCE ",null,null,null,null,"COSTS","MAINTENANCE ","NRC FEE","SALES AND USE","INCENTIVE",null,"PRO FORMA","ELECTRIC"]
[null,null,"LINE","FUNCTIONAL CLASSIFICATION","BOOKS","ADJUSTMENT","ADJUSTMENT","ADJUSTMENT","TU CHANGE","TU CHANGE","ADJUSTMENT","DUES","ADJUSTMENT",null,null,"LINE","FUNCTIONAL CLASSIFICATION","MAINTENANCE","ADJUSTMENT ","ADJUSTMENT ","RECOVERY","EXPENSES","AMORTIZATION","OUTAGE","ADJUSTMENT","EXPENSE",null,null,null,"FUNCTIONAL CLASSIFICATION","AMOUNTS","AMORTIZATION","ADJUSTMENT","COSTS","DEPOSITS","ADJUSTMENT","AMORTIZATION","EXPENSE","ADJUST.",null,null,"LINE","FUNCTIONAL CLASSIFICATION","ADJUST.","ADJUST.","TRACKER","TRACKER","EXPENSE","EXPENSES","ASSESSMENT","ADJUSTMENT","EXPENSE",null,null,"LINE","FUNCTIONAL CLASSIFICATION","AMS","FACILITIES","EXPENSE","ADJUSTMENT","SAVINGS","ADJUSTMENT","ADJUSTMENT","ALLOC TO GAS","FEES",null,null,"LINE","FUNCTIONAL CLASSIFICATION","ADJUSTMENT","ADJUSTMENT","ANNUALIZATION","TAX AUDIT","ADJUSTMENT",null,"ADJUSTMENT","TOTALS"]
[null,null,null,"(A)","(B)","(C)","(D)","(E)","(G)","(H)","(I)","(J)","(K)",null,null,null,"(A)","(B)","(C)","(D)","(E)","(F)","(G)","(H)","(I)","(J)",null,null,null,"(A)","(B)","(C)","(D)","(E)","(F)","(G)","(H)","(I)","(J)",null,null,null,"(A)","(B)","(C)","(D)","(E )","(F)","(G)","(H)","(I)","(J)",null,null,null,"(A)","(B)","(C)","(D)","(E )","(F)","(G)","(H)","(I)","(J)",null,null,null,"(A)","(B)","(C)","(D)","(E)","(F)",null,"(G)","(H)"]
[null,null,null,"  PRODUCTION:",null,null,null,null,null,null,null,null,null,null,null,null,"  PRODUCTION:",null,null,null,null,null,null,null,null,null,null,null,null,"  PRODUCTION:",null,null,null,null,null,null,null,null,null,null,null,null,"  PRODUCTION:",null,null,null,null,null,null,null,null,null,null,null,null,"  PRODUCTION:",null,null,null,null,null,null,null,null,null,null,null,null,"  PRODUCTION:"]
[null,null,null,"    INCREMENTAL COSTS:",null,null,null,null,null,null,null,null,null,null,null,null,"    INCREMENTAL COSTS:",null,null,null,null,null,null,null,null,null,null,null,null,"    INCREMENTAL COSTS:",null,null,null,null,null,null,null,null,null,null,null,null,"    INCREMENTAL COSTS:",null,null,null,null,null,null,null,null,null,null,null,null,"    INCREMENTAL COSTS:",null,null,null,null,null,null,null,null,null,null,null,null,"    INCREMENTAL COSTS:"]
[null,null,1,"      LABOR",{"$f":"+ROUND('[1]O&M'!$B$11*0.001,0)","v":197565},{"$f":"+ROUND('[1]O&M'!$C$11*0.001,0)","v":10141},{"$f":"+ROUND('[1]O&M'!$D$11*0.001,0)","v":-1093},{"$f":"+ROUND('[1]O&M'!$E$11*0.001,0)","v":-1641},0,0,0,0,0,null,null,1,"      LABOR",null,0,0,0,{"$f":"+ROUND('[1]O&M'!$P$11*0.001,0)","v":5262},0,0,0,0,null,null,1,"      LABOR",0,0,0,0,0,0,0,0,0,null,null,1,"      LABOR",0,0,0,0,0,0,0,0,0,null,null,1,"      LABOR",0,0,0,0,0,0,0,0,0,null,null,1,"      LABOR",0,0,0,0,0,null,{"$f":"SUM(F9:M9,R9:Z9,AE9:AM9,AR9:AZ9,BE9:BM9,BR9:BW9)","v":12669},{"$f":"E9+BX9","v":210234}]
[null,null,null,"      FUEL (EXCL. W/H CR.)",null,null,null,null,null,null,null,null,null,null,null,null,"      FUEL (EXCL. W/H CR.)",null,null,null,null,null,null,null,null,null,null,null,null,"      FUEL (EXCL. W/H CR.)",null,null,null,null,null,null,null,null,null,null,null,null,"      FUEL (EXCL. W/H CR.)",null,null,null,null,null,null,null,null,null,null,null,null,"      FUEL (EXCL. W/H CR.)",null,null,null,null,null,null,null,null,null,null,null,null,"      FUEL (EXCL. W/H CR.)"]
[null,null,{"$f":"1+C9","v":2},"            BASE LOAD",{"$f":"+ROUND('[1]O&M'!$B$13*0.001,0)","v":415685},0,0,0,{"$f":"+ROUND('[1]O&M'!$G$13*0.001,0)","v":34675},0,0,0,0,null,null,{"$f":"1+P9","v":2},"            BASE LOAD",null,0,0,0,0,0,0,0,0,null,null,{"$f":"1+AC9","v":2},"            BASE LOAD",0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+AP9","v":2},"            BASE LOAD",0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+BC9","v":2},"            BASE LOAD",0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+BP9","v":2},"            BASE LOAD",0,0,0,0,0,null,{"$f":"SUM(F11:M11,R11:Z11,AE11:AM11,AR11:AZ11,BE11:BM11,BR11:BW11)","v":34675},{"$f":"E11+BX11","v":450360}]
[null,null,{"$f":"1+C11","v":3},"            INTERCHANGE",{"$f":"+ROUND('[1]O&M'!$B$14*0.001,0)","v":175916},0,0,0,{"$f":"+ROUND('[1]O&M'!$G$14*0.001,0)","v":-46785},0,0,0,0,null,null,{"$f":"1+P11","v":3},"            INTERCHANGE",null,0,0,0,0,0,0,0,0,null,null,{"$f":"1+AC11","v":3},"            INTERCHANGE",0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+AP11","v":3},"            INTERCHANGE",0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+BC11","v":3},"            INTERCHANGE",0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+BP11","v":3},"            INTERCHANGE",0,0,0,0,0,null,{"$f":"SUM(F12:M12,R12:Z12,AE12:AM12,AR12:AZ12,BE12:BM12,BR12:BW12)","v":-46785},{"$f":"E12+BX12","v":129131}]
[null,null,{"$f":"1+C12","v":4},"      FUEL ADDITIVES",{"$f":"+ROUND('[1]O&M'!$B$15*0.001,0)","v":6979},0,0,0,{"$f":"+ROUND('[1]O&M'!$G$15*0.001,0)","v":224},0,0,0,0,null,null,{"$f":"1+P12","v":4},"      FUEL ADDITIVES",0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+AC12","v":4},"      FUEL ADDITIVES",0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+AP12","v":4},"      FUEL ADDITIVES",0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+BC12","v":4},"      FUEL ADDITIVES",0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+BP12","v":4},"      FUEL ADDITIVES",0,0,0,0,0,null,{"$f":"SUM(F13:M13,R13:Z13,AE13:AM13,AR13:AZ13,BE13:BM13,BR13:BW13)","v":224},{"$f":"E13+BX13","v":7203}]
[null,null,null,"      PURCHASED POWER ",null,null,null,null,null,null,null,null,null,null,null,null,"      PURCHASED POWER ",null,null,null,null,null,null,null,null,null,null,null,null,"      PURCHASED POWER ",null,null,null,null,null,null,null,null,null,null,null,null,"      PURCHASED POWER ",null,null,null,null,null,null,null,null,null,null,null,null,"      PURCHASED POWER ",null,null,null,null,null,null,null,null,null,null,null,null,"      PURCHASED POWER "]
[null,null,null,"        ENERGY ",null,null,null,null,null,null,null,null,null,null,null,null,"        ENERGY ",null,null,null,null,null,null,null,null,null,null,null,null,"        ENERGY ",null,null,null,null,null,null,null,null,null,null,null,null,"        ENERGY ",null,null,null,null,null,null,null,null,null,null,null,null,"        ENERGY ",null,null,null,null,null,null,null,null,null,null,null,null,"        ENERGY "]
[null,null,{"$f":"1+C13","v":5},"            BASE LOAD",{"$f":"+ROUND('[1]O&M'!$B$18*0.001,0)","v":71903},0,0,0,{"$f":"+ROUND('[1]O&M'!G18*0.001,0)","v":0},{"$f":"+ROUND('[1]O&M'!$H$18*0.001,0)","v":-362},0,0,0,null,null,{"$f":"1+P13","v":5},"            BASE LOAD",0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+AC13","v":5},"            BASE LOAD",0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+AP13","v":5},"            BASE LOAD",0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+BC13","v":5},"            BASE LOAD",0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+BP13","v":5},"            BASE LOAD",0,0,0,0,0,null,{"$f":"SUM(F16:M16,R16:Z16,AE16:AM16,AR16:AZ16,BE16:BM16,BR16:BW16)","v":-362},{"$f":"E16+BX16","v":71541}]
[null,null,{"$f":"1+C16","v":6},"            INTERCHANGE",{"$f":"+ROUND('[1]O&M'!$B$19*0.001,0)","v":5992},0,0,0,{"$f":"+ROUND('[1]O&M'!G19*0.001,0)","v":0},{"$f":"+ROUND('[1]O&M'!$H$19*0.001,0)","v":-5992},0,0,0,null,null,{"$f":"1+P16","v":6},"            INTERCHANGE",0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+AC16","v":6},"            INTERCHANGE",0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+AP16","v":6},"            INTERCHANGE",0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+BC16","v":6},"            INTERCHANGE",0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+BP16","v":6},"            INTERCHANGE",0,0,0,0,0,null,-5992,{"$f":"E17+BX17","v":0}]
[null,null,null,"        CAPACITY COSTS",null,null,null,null,null,null,null,null,null,null,null,null,"        CAPACITY COSTS",null,null,null,null,null,0,0,0,0,null,null,null,"        CAPACITY COSTS",0,0,null,null,null,null,null,null,null,null,null,null,"        CAPACITY COSTS",null,0,0,0,0,0,0,0,0,null,null,null,"        CAPACITY COSTS",0,0,0,0,0,0,0,0,0,null,null,null,"        CAPACITY COSTS",0,0,0,0,0,null,0]
[null,null,{"$f":"1+C17","v":7},"            BASE LOAD",{"$f":"+ROUND('[1]O&M'!$B$21*0.001,0)","v":13305},0,0,0,{"$f":"+ROUND('[1]O&M'!G21*0.001,0)","v":0},{"$f":"+ROUND('[1]O&M'!$H$21*0.001,0)","v":205289},0,0,0,null,null,{"$f":"1+P17","v":7},"            BASE LOAD",0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+AC17","v":7},"            BASE LOAD",0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+AP17","v":7},"            BASE LOAD",0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+BC17","v":7},"            BASE LOAD",0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+BP17","v":7},"            BASE LOAD",0,0,0,0,0,null,205289,{"$f":"E19+BX19","v":218594}]
[null,null,{"$f":"1+C19","v":8},"            INTERCHANGE",0,0,0,0,{"$f":"+ROUND('[1]O&M'!G22*0.001,0)","v":0},0,0,0,0,null,null,{"$f":"1+P19","v":8},"            INTERCHANGE",0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+AC19","v":8},"            INTERCHANGE",0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+AP19","v":8},"            INTERCHANGE",0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+BC19","v":8},"            INTERCHANGE",0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+BP19","v":8},"            INTERCHANGE",0,0,0,0,0,null,0,{"$f":"E20+BX20","v":0}]
[null,null,{"$f":"1+C20","v":9},"      OTHER",{"$f":"+ROUND('[1]O&M'!$B$23*0.001,0)","v":244290},0,0,0,{"$f":"+ROUND('[1]O&M'!G23*0.001,0)","v":0},0,0,{"$f":"+ROUND('[1]O&M'!$J$23*0.001,0)-1","v":-28},{"$f":"+ROUND('[1]O&M'!$K$23*0.001,0)","v":15105},null,null,{"$f":"1+P20","v":9},"      OTHER",{"$f":"+ROUND('[1]O&M'!$L$23*0.001,0)","v":1496},{"$f":"+ROUND('[1]O&M'!$M$23*0.001,0)","v":-2539},{"$f":"+ROUND('[1]O&M'!$N$23*0.001,0)","v":-1443},{"$f":"+ROUND('[1]O&M'!$O$23*0.001,0)","v":-102847},{"$f":"+ROUND('[1]O&M'!$P$23*0.001,0)","v":22715},{"$f":"+ROUND('[1]O&M'!$Q$23*0.001,0)","v":-27887},{"$f":"+ROUND('[1]O&M'!$R$23*0.001,0)","v":-968},{"$f":"+ROUND('[1]O&M'!$S$23*0.001,0)","v":3902},{"$f":"+ROUND('[1]O&M'!$T$23*0.001,0)","v":1962},null,null,{"$f":"1+AC20","v":9},"      OTHER",{"$f":"+ROUND('[1]O&M'!$V$23*0.001,0)","v":0},0,{"$f":"+ROUND('[1]O&M'!$W$23*0.001,0)","v":-399},0,0,0,0,0,0,null,null,{"$f":"1+AP20","v":9},"      OTHER",0,0,0,0,{"$f":"+ROUND('[1]O&M'!$AO$23*0.001,0)","v":3892},0,0,0,0,null,null,{"$f":"1+BC20","v":9},"      OTHER",0,0,0,0,{"$f":"ROUND('[1]O&M'!$BD$23*0.001,0)","v":0},{"$f":"ROUND('[1]O&M'!$BD$23*0.001,0)","v":0},{"$f":"+ROUND('[1]O&M'!$BM$23*0.001,0)","v":-3434},0,0,null,null,{"$f":"1+BP20","v":9},"      OTHER",0,0,{"$f":"+ROUND('[1]O&M'!$BP$23*0.001,0)","v":22},0,0,null,-90451,{"$f":"E21+BX21","v":153839}]
[null,null,{"$f":"1+C21","v":10},"  TOTAL PRODUCTION EXPENSES",{"$f":"SUM(E9:E21)","v":1131635},10141,-1093,-1641,{"$f":"SUM(I9:I21)","v":-11886},{"$f":"SUM(J9:J21)","v":198935},{"$f":"SUM(K9:K21)","v":0},{"$f":"SUM(L9:L21)","v":-28},{"$f":"SUM(M9:M21)","v":15105},null,null,{"$f":"1+P21","v":10},"  TOTAL PRODUCTION EXPENSES",{"$f":"SUM(R9:R21)","v":1496},{"$f":"SUM(S9:S21)","v":-2539},-1443,{"$f":"SUM(U9:U21)","v":-102847},{"$f":"SUM(V9:V21)","v":27977},{"$f":"SUM(W9:W21)","v":-27887},{"$f":"SUM(X9:X21)","v":-968},{"$f":"SUM(Y9:Y21)","v":3902},1962,null,null,{"$f":"1+AC21","v":10},"  TOTAL PRODUCTION EXPENSES",{"$f":"SUM(AE9:AE21)","v":0},{"$f":"SUM(AF9:AF21)","v":0},{"$f":"SUM(AG9:AG21)","v":-399},{"$f":"SUM(AH9:AH21)","v":0},{"$f":"SUM(AI9:AI21)","v":0},{"$f":"SUM(AJ9:AJ21)","v":0},{"$f":"SUM(AK9:AK21)","v":0},0,{"$f":"SUM(AM9:AM21)","v":0},null,null,{"$f":"1+AP21","v":10},"  TOTAL PRODUCTION EXPENSES",{"$f":"SUM(AR9:AR21)","v":0},{"$f":"SUM(AS9:AS21)","v":0},{"$f":"SUM(AT9:AT21)","v":0},{"$f":"SUM(AU9:AU21)","v":0},{"$f":"SUM(AV9:AV21)","v":3892},{"$f":"SUM(AW9:AW21)","v":0},{"$f":"SUM(AX9:AX21)","v":0},0,{"$f":"SUM(AZ9:AZ21)","v":0},null,null,{"$f":"1+BC21","v":10},"  TOTAL PRODUCTION EXPENSES",{"$f":"SUM(BE9:BE21)","v":0},{"$f":"SUM(BF9:BF21)","v":0},0,0,0,0,-3434,0,{"$f":"SUM(BM9:BM21)","v":0},null,null,{"$f":"1+BP21","v":10},"  TOTAL PRODUCTION EXPENSES",{"$f":"SUM(BR9:BR21)","v":0},0,{"$f":"SUM(BT9:BT21)","v":22},0,0,null,{"$f":"SUM(BX9:BX21)","v":109267},{"$f":"SUM(BY9:BY21)","v":1240902}]
[]
[null,null,null,"  TRANSMISSION EXPENSES:",null,null,null,null,null,null,null,null,null,null,null,null,"  TRANSMISSION EXPENSES:",null,null,null,null,null,null,null,null,null,null,null,null,"  TRANSMISSION EXPENSES:",null,null,null,null,null,null,null,null,null,null,null,null,"  TRANSMISSION EXPENSES:",null,null,null,null,null,null,null,null,null,null,null,null,"  TRANSMISSION EXPENSES:",null,null,null,null,null,null,null,null,null,null,null,null,"  TRANSMISSION EXPENSES:"]
[null,null,{"$f":"1+C22","v":11},"      LABOR",{"$f":"+ROUND('[1]O&M'!$B$27*0.001,0)-1","v":5925},{"$f":"+ROUND('[1]O&M'!$C$27*0.001,0)","v":285},{"$f":"+ROUND('[1]O&M'!$D$27*0.001,0)","v":-33},{"$f":"+ROUND('[1]O&M'!$E$27*0.001,0)","v":-135},{"$f":"+ROUND('[1]O&M'!G27*0.001,0)","v":0},0,0,0,0,null,null,{"$f":"1+P22","v":11},"      LABOR",0,0,0,0,{"$f":"+ROUND('[1]O&M'!O27*0.001,0)","v":0},{"$f":"+ROUND('[1]O&M'!U27*0.001,0)","v":0},{"$f":"+ROUND('[1]O&M'!V27*0.001,0)","v":0},0,0,null,null,{"$f":"1+AC22","v":11},"      LABOR",0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+AP22","v":11},"      LABOR",0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+BC22","v":11},"      LABOR",0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+BP22","v":11},"      LABOR",0,0,0,0,0,null,{"$f":"SUM(F25:M25,R25:Z25,AE25:AM25,AR25:AZ25,BE25:BM25,BR25:BW25)","v":117},{"$f":"E25+BX25","v":6042}]
[null,null,{"$f":"1+C25","v":12},"      OTHER",{"$f":"+ROUND('[1]O&M'!$B$28*0.001,0)","v":105237},0,0,0,{"$f":"+ROUND('[1]O&M'!G28*0.001,0)","v":0},{"$f":"+ROUND('[1]O&M'!$H$28*0.001,0)","v":1831},{"$f":"+ROUND('[1]O&M'!$I$28*0.001,0)","v":-125},0,0,null,null,{"$f":"1+P25","v":12},"      OTHER",0,0,0,0,{"$f":"+ROUND('[1]O&M'!O28*0.001,0)","v":0},{"$f":"+ROUND('[1]O&M'!U28*0.001,0)","v":0},{"$f":"+ROUND('[1]O&M'!V28*0.001,0)","v":0},0,0,null,null,{"$f":"1+AC25","v":12},"      OTHER",0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+AP25","v":12},"      OTHER",0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+BC25","v":12},"      OTHER",0,0,0,{"$f":"ROUND('[1]O&M'!$BC$28*0.001,0)","v":-44},0,0,0,0,0,null,null,{"$f":"1+BP25","v":12},"      OTHER",0,0,0,0,0,null,{"$f":"SUM(F26:M26,R26:Z26,AE26:AM26,AR26:AZ26,BE26:BM26,BR26:BW26)","v":1662},{"$f":"E26+BX26","v":106899}]
[null,null,{"$f":"1+C26","v":13},"  TOTAL TRANSMISSION EXPENSES",{"$f":"SUM(E25:E26)","v":111162},285,-33,-135,{"$f":"SUM(I25:I26)","v":0},{"$f":"SUM(J25:J26)","v":1831},{"$f":"SUM(K25:K26)","v":-125},{"$f":"SUM(L25:L26)","v":0},{"$f":"SUM(M25:M26)","v":0},null,null,{"$f":"1+P26","v":13},"  TOTAL TRANSMISSION EXPENSES",{"$f":"SUM(R25:R26)","v":0},{"$f":"SUM(S25:S26)","v":0},0,{"$f":"SUM(U25:U26)","v":0},{"$f":"SUM(V25:V26)","v":0},{"$f":"SUM(W25:W26)","v":0},{"$f":"SUM(X25:X26)","v":0},{"$f":"SUM(Y25:Y26)","v":0},0,null,null,{"$f":"1+AC26","v":13},"  TOTAL TRANSMISSION EXPENSES",{"$f":"SUM(AE25:AE26)","v":0},{"$f":"SUM(AF25:AF26)","v":0},{"$f":"SUM(AG25:AG26)","v":0},{"$f":"SUM(AH25:AH26)","v":0},{"$f":"SUM(AI25:AI26)","v":0},{"$f":"SUM(AJ25:AJ26)","v":0},{"$f":"SUM(AK25:AK26)","v":0},0,{"$f":"SUM(AM25:AM26)","v":0},null,null,{"$f":"1+AP26","v":13},"  TOTAL TRANSMISSION EXPENSES",{"$f":"SUM(AR25:AR26)","v":0},{"$f":"SUM(AS25:AS26)","v":0},{"$f":"SUM(AT25:AT26)","v":0},{"$f":"SUM(AU25:AU26)","v":0},{"$f":"SUM(AV25:AV26)","v":0},{"$f":"SUM(AW25:AW26)","v":0},{"$f":"SUM(AX25:AX26)","v":0},0,{"$f":"SUM(AZ25:AZ26)","v":0},null,null,{"$f":"1+BC26","v":13},"  TOTAL TRANSMISSION EXPENSES",{"$f":"SUM(BE25:BE26)","v":0},{"$f":"SUM(BF25:BF26)","v":0},0,-44,0,0,0,0,{"$f":"SUM(BM25:BM26)","v":0},null,null,{"$f":"1+BP26","v":13},"  TOTAL TRANSMISSION EXPENSES",{"$f":"SUM(BR25:BR26)","v":0},0,{"$f":"SUM(BT25:BT26)","v":0},0,0,null,{"$f":"SUM(BX25:BX26)","v":1779},{"$f":"SUM(BY25:BY26)","v":112941}]
[]
[null,null,null,"  REGIONAL MARKET EXPENSES:",null,null,null,null,null,null,null,null,null,null,null,null,"  REGIONAL MARKET EXPENSES:",null,null,null,null,null,null,null,null,null,null,null,null,"  REGIONAL MARKET EXPENSES:",null,null,null,null,null,null,null,null,null,null,null,null,"  REGIONAL MARKET EXPENSES:",null,null,null,null,null,null,null,null,null,null,null,null,"  REGIONAL MARKET EXPENSES:",null,null,null,null,null,null,null,null,null,null,null,null,"  REGIONAL MARKET EXPENSES:"]
[null,null,{"$f":"1+C27","v":14},"      LABOR",{"$f":"+ROUND('[1]O&M'!$B$32*0.001,0)","v":0},0,0,0,{"$f":"+ROUND('[1]O&M'!G32*0.001,0)","v":0},0,{"$f":"+ROUND('[1]O&M'!I32*0.001,0)","v":0},0,0,null,null,{"$f":"1+P27","v":14},"      LABOR",0,0,0,0,{"$f":"+ROUND('[1]O&M'!O32*0.001,0)","v":0},{"$f":"+ROUND('[1]O&M'!U32*0.001,0)","v":0},{"$f":"+ROUND('[1]O&M'!V32*0.001,0)","v":0},0,0,null,null,{"$f":"1+AC27","v":14},"      LABOR",0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+AP27","v":14},"      LABOR",0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+BC27","v":14},"      LABOR",0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+BP27","v":14},"      LABOR",0,0,0,0,0,null,{"$f":"SUM(F30:M30,R30:Z30,AE30:AM30,AR30:AZ30,BE30:BM30,BR30:BW30)","v":0},{"$f":"E30+BX30","v":0}]
[null,null,{"$f":"1+C30","v":15},"      OTHER",{"$f":"+ROUND('[1]O&M'!$B$33*0.001,0)","v":6924},0,0,0,{"$f":"+ROUND('[1]O&M'!G33*0.001,0)","v":0},0,{"$f":"+ROUND('[1]O&M'!I33*0.001,0)","v":0},0,0,null,null,{"$f":"1+P30","v":15},"      OTHER",0,0,0,0,{"$f":"+ROUND('[1]O&M'!O33*0.001,0)","v":0},{"$f":"+ROUND('[1]O&M'!U33*0.001,0)","v":0},{"$f":"+ROUND('[1]O&M'!V33*0.001,0)","v":0},0,0,null,null,{"$f":"1+AC30","v":15},"      OTHER",0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+AP30","v":15},"      OTHER",0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+BC30","v":15},"      OTHER",0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+BP30","v":15},"      OTHER",0,0,0,0,0,null,{"$f":"SUM(F31:M31,R31:Z31,AE31:AM31,AR31:AZ31,BE31:BM31,BR31:BW31)","v":0},{"$f":"E31+BX31","v":6924}]
[null,null,{"$f":"1+C31","v":16},"  TOTAL REGIONAL MARKET EXPENSES",{"$f":"SUM(E30:E31)","v":6924},0,0,0,{"$f":"SUM(I30:I31)","v":0},{"$f":"SUM(J30:J31)","v":0},{"$f":"SUM(K30:K31)","v":0},{"$f":"SUM(L30:L31)","v":0},{"$f":"SUM(M30:M31)","v":0},null,null,{"$f":"1+P31","v":16},"  TOTAL REGIONAL MARKET EXPENSES",{"$f":"SUM(R30:R31)","v":0},{"$f":"SUM(S30:S31)","v":0},0,{"$f":"SUM(U30:U31)","v":0},{"$f":"SUM(V30:V31)","v":0},{"$f":"SUM(W30:W31)","v":0},{"$f":"SUM(X30:X31)","v":0},{"$f":"SUM(Y30:Y31)","v":0},0,null,null,{"$f":"1+AC31","v":16},"  TOTAL REGIONAL MARKET EXPENSES",{"$f":"SUM(AE30:AE31)","v":0},{"$f":"SUM(AF30:AF31)","v":0},{"$f":"SUM(AG30:AG31)","v":0},{"$f":"SUM(AH30:AH31)","v":0},{"$f":"SUM(AI30:AI31)","v":0},{"$f":"SUM(AJ30:AJ31)","v":0},{"$f":"SUM(AK30:AK31)","v":0},0,{"$f":"SUM(AM30:AM31)","v":0},null,null,{"$f":"1+AP31","v":16},"  TOTAL REGIONAL MARKET EXPENSES",{"$f":"SUM(AR30:AR31)","v":0},{"$f":"SUM(AS30:AS31)","v":0},{"$f":"SUM(AT30:AT31)","v":0},{"$f":"SUM(AU30:AU31)","v":0},{"$f":"SUM(AV30:AV31)","v":0},{"$f":"SUM(AW30:AW31)","v":0},{"$f":"SUM(AX30:AX31)","v":0},0,{"$f":"SUM(AZ30:AZ31)","v":0},null,null,{"$f":"1+BC31","v":16},"  TOTAL REGIONAL MARKET EXPENSES",{"$f":"SUM(BE30:BE31)","v":0},{"$f":"SUM(BF30:BF31)","v":0},0,0,0,0,0,0,{"$f":"SUM(BM30:BM31)","v":0},null,null,{"$f":"1+BP31","v":16},"  TOTAL REGIONAL MARKET EXPENSES",{"$f":"SUM(BR30:BR31)","v":0},0,{"$f":"SUM(BT30:BT31)","v":0},0,0,null,{"$f":"SUM(BX30:BX31)","v":0},{"$f":"SUM(BY30:BY31)","v":6924}]
[]
[null,null,null,"  DISTRIBUTION EXPENSES:",null,null,null,null,null,null,null,null,null,null,null,null,"  DISTRIBUTION EXPENSES:",null,null,null,null,null,null,null,null,null,null,null,null,"  DISTRIBUTION EXPENSES:",null,null,null,null,null,null,null,null,null,null,null,null,"  DISTRIBUTION EXPENSES:",null,null,null,null,null,null,null,null,null,null,null,null,"  DISTRIBUTION EXPENSES:",null,null,null,null,null,null,null,null,null,null,null,null,"  DISTRIBUTION EXPENSES:"]
[null,null,{"$f":"1+C32","v":17},"      LABOR",{"$f":"+ROUND('[1]O&M'!$B$37*0.001,0)","v":59721},{"$f":"+ROUND('[1]O&M'!$C$37*0.001,0)","v":3160},{"$f":"+ROUND('[1]O&M'!$D$37*0.001,0)","v":-330},{"$f":"+ROUND('[1]O&M'!$E$37*0.001,0)","v":-358},{"$f":"+ROUND('[1]O&M'!G37*0.001,0)","v":0},0,{"$f":"+ROUND('[1]O&M'!I37*0.001,0)","v":0},0,0,null,null,{"$f":"1+P32","v":17},"      LABOR",0,0,0,0,{"$f":"+ROUND('[1]O&M'!O37*0.001,0)","v":0},{"$f":"+ROUND('[1]O&M'!U37*0.001,0)","v":0},{"$f":"+ROUND('[1]O&M'!V37*0.001,0)","v":0},0,0,null,null,{"$f":"1+AC32","v":17},"      LABOR",0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+AP32","v":17},"      LABOR",0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+BC32","v":17},"      LABOR",0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+BP32","v":17},"      LABOR",0,0,0,0,0,null,{"$f":"SUM(F35:M35,R35:Z35,AE35:AM35,AR35:AZ35,BE35:BM35,BR35:BW35)","v":2472},{"$f":"E35+BX35","v":62193}]
[null,null,{"$f":"1+C35","v":18},"      OTHER",{"$f":"+ROUND('[1]O&M'!$B$38*0.001,0)","v":93964},0,0,0,{"$f":"+ROUND('[1]O&M'!G38*0.001,0)","v":0},0,{"$f":"+ROUND('[1]O&M'!I38*0.001,0)","v":0},{"$f":"+ROUND('[1]O&M'!$J$38*0.001,0)","v":0},0,null,null,{"$f":"1+P35","v":18},"      OTHER",0,0,0,0,{"$f":"+ROUND('[1]O&M'!O38*0.001,0)","v":0},{"$f":"+ROUND('[1]O&M'!U38*0.001,0)","v":0},{"$f":"+ROUND('[1]O&M'!V38*0.001,0)","v":0},0,0,null,null,{"$f":"1+AC35","v":18},"      OTHER",{"$f":"+ROUND('[1]O&M'!$V$38*0.001,0)","v":0},{"$f":"+ROUND('[1]O&M'!$V$38*0.001,0)","v":0},{"$f":"+ROUND('[1]O&M'!$W$38*0.001,0)+1","v":-426},{"$f":"+ROUND('[1]O&M'!$X$38*0.001,0)","v":-5330},0,0,0,0,0,null,null,{"$f":"1+AP35","v":18},"      OTHER",0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+BC35","v":18},"      OTHER",0,0,0,{"$f":"ROUND('[1]O&M'!$BC$38*0.001,0)","v":9},0,0,0,0,0,null,null,{"$f":"1+BP35","v":18},"      OTHER",0,0,0,0,0,null,{"$f":"SUM(F36:M36,R36:Z36,AE36:AM36,AR36:AZ36,BE36:BM36,BR36:BW36)","v":-5747},{"$f":"E36+BX36","v":88217}]
[null,null,{"$f":"1+C36","v":19},"  TOTAL DISTRIBUTION EXPENSES",{"$f":"SUM(E35:E36)","v":153685},3160,-330,-358,{"$f":"SUM(I35:I36)","v":0},{"$f":"SUM(J35:J36)","v":0},{"$f":"SUM(K35:K36)","v":0},{"$f":"SUM(L35:L36)","v":0},{"$f":"SUM(M35:M36)","v":0},null,null,{"$f":"1+P36","v":19},"  TOTAL DISTRIBUTION EXPENSES",{"$f":"SUM(R35:R36)","v":0},{"$f":"SUM(S35:S36)","v":0},0,{"$f":"SUM(U35:U36)","v":0},{"$f":"SUM(V35:V36)","v":0},{"$f":"SUM(W35:W36)","v":0},{"$f":"SUM(X35:X36)","v":0},{"$f":"SUM(Y35:Y36)","v":0},0,null,null,{"$f":"1+AC36","v":19},"  TOTAL DISTRIBUTION EXPENSES",{"$f":"SUM(AE35:AE36)","v":0},{"$f":"SUM(AF35:AF36)","v":0},{"$f":"SUM(AG35:AG36)","v":-426},{"$f":"SUM(AH35:AH36)","v":-5330},{"$f":"SUM(AI35:AI36)","v":0},{"$f":"SUM(AJ35:AJ36)","v":0},{"$f":"SUM(AK35:AK36)","v":0},0,{"$f":"SUM(AM35:AM36)","v":0},null,null,{"$f":"1+AP36","v":19},"  TOTAL DISTRIBUTION EXPENSES",{"$f":"SUM(AR35:AR36)","v":0},{"$f":"SUM(AS35:AS36)","v":0},{"$f":"SUM(AT35:AT36)","v":0},{"$f":"SUM(AU35:AU36)","v":0},{"$f":"SUM(AV35:AV36)","v":0},{"$f":"SUM(AW35:AW36)","v":0},{"$f":"SUM(AX35:AX36)","v":0},0,{"$f":"SUM(AZ35:AZ36)","v":0},null,null,{"$f":"1+BC36","v":19},"  TOTAL DISTRIBUTION EXPENSES",{"$f":"SUM(BE35:BE36)","v":0},{"$f":"SUM(BF35:BF36)","v":0},0,9,0,0,0,0,{"$f":"SUM(BM35:BM36)","v":0},null,null,{"$f":"1+BP36","v":19},"  TOTAL DISTRIBUTION EXPENSES",{"$f":"SUM(BR35:BR36)","v":0},0,{"$f":"SUM(BT35:BT36)","v":0},0,0,null,{"$f":"SUM(BX35:BX36)","v":-3275},{"$f":"SUM(BY35:BY36)","v":150410}]
[]
[null,null,null,"  CUSTOMER ACCOUNTING EXPENSES:",null,null,null,null,null,null,null,null,null,null,null,null,"  CUSTOMER ACCOUNTING EXPENSES:",null,null,null,null,null,null,null,null,null,null,null,null,"  CUSTOMER ACCOUNTING EXPENSES:",null,null,null,null,null,null,null,null,null,null,null,null,"  CUSTOMER ACCOUNTING EXPENSES:",null,null,null,null,null,null,null,null,null,null,null,null,"  CUSTOMER ACCOUNTING EXPENSES:",null,null,null,null,null,null,null,null,null,null,null,null,"  CUSTOMER ACCOUNTING EXPENSES:"]
[null,null,{"$f":"1+C37","v":20},"      LABOR",{"$f":"+ROUND('[1]O&M'!$B$42*0.001,0)","v":20476},{"$f":"+ROUND('[1]O&M'!$C$42*0.001,0)","v":1083},{"$f":"+ROUND('[1]O&M'!$D$42*0.001,0)","v":-113},{"$f":"+ROUND('[1]O&M'!$E$42*0.001,0)","v":-164},{"$f":"+ROUND('[1]O&M'!G42*0.001,0)","v":0},0,{"$f":"+ROUND('[1]O&M'!I42*0.001,0)","v":0},0,0,null,null,{"$f":"1+P37","v":20},"      LABOR",0,0,0,0,{"$f":"+ROUND('[1]O&M'!O42*0.001,0)","v":0},{"$f":"+ROUND('[1]O&M'!U42*0.001,0)","v":0},{"$f":"+ROUND('[1]O&M'!V42*0.001,0)","v":0},0,0,null,null,{"$f":"1+AC37","v":20},"      LABOR",0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+AP37","v":20},"      LABOR",0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+BC37","v":20},"      LABOR",0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+BP37","v":20},"      LABOR",0,0,0,0,0,null,{"$f":"SUM(F40:M40,R40:Z40,AE40:AM40,AR40:AZ40,BE40:BM40,BR40:BW40)","v":806},{"$f":"E40+BX40","v":21282}]
[null,null,{"$f":"1+C40","v":21},"      OTHER",{"$f":"+ROUND('[1]O&M'!$B$43*0.001,0)","v":27092},0,0,0,{"$f":"+ROUND('[1]O&M'!G43*0.001,0)","v":0},0,{"$f":"+ROUND('[1]O&M'!I43*0.001,0)","v":0},0,0,null,null,{"$f":"1+P40","v":21},"      OTHER",0,0,0,0,{"$f":"+ROUND('[1]O&M'!O43*0.001,0)","v":0},{"$f":"+ROUND('[1]O&M'!U43*0.001,0)","v":0},{"$f":"+ROUND('[1]O&M'!V43*0.001,0)","v":0},0,0,null,null,{"$f":"1+AC40","v":21},"      OTHER",0,0,0,0,{"$f":"+ROUND('[1]O&M'!$Z$43*0.001,0)","v":800},0,0,{"$f":"+ROUND('[1]O&M'!$AE$43*0.001,0)","v":3572},0,null,null,{"$f":"1+AP40","v":21},"      OTHER",0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+BC40","v":21},"      OTHER",0,0,0,{"$f":"ROUND('[1]O&M'!$BC$43*0.001,0)","v":0},{"$f":"ROUND('[1]O&M'!$BD$43*0.001,0)","v":-2373},{"$f":"ROUND('[1]O&M'!$BK$43*0.001,0)","v":0},0,0,{"$f":"+ROUND('[1]O&M'!$BH$43*0.001,0)","v":3849},null,null,{"$f":"1+BP40","v":21},"      OTHER",0,0,0,0,0,null,{"$f":"SUM(F41:M41,R41:Z41,AE41:AM41,AR41:AZ41,BE41:BM41,BR41:BW41)","v":5848},{"$f":"E41+BX41","v":32940}]
[null,null,{"$f":"1+C41","v":22},"  TOTAL CUSTOMER ACCOUNTING EXPENSES",{"$f":"SUM(E40:E41)","v":47568},1083,-113,-164,{"$f":"SUM(I40:I41)","v":0},{"$f":"SUM(J40:J41)","v":0},{"$f":"SUM(K40:K41)","v":0},{"$f":"SUM(L40:L41)","v":0},{"$f":"SUM(M40:M41)","v":0},null,null,{"$f":"1+P41","v":22},"  TOTAL CUSTOMER ACCOUNTING EXPENSES",{"$f":"SUM(R40:R41)","v":0},{"$f":"SUM(S40:S41)","v":0},0,{"$f":"SUM(U40:U41)","v":0},{"$f":"SUM(V40:V41)","v":0},{"$f":"SUM(W40:W41)","v":0},{"$f":"SUM(X40:X41)","v":0},{"$f":"SUM(Y40:Y41)","v":0},0,null,null,{"$f":"1+AC41","v":22},"  TOTAL CUSTOMER ACCOUNTING EXPENSES",{"$f":"SUM(AE40:AE41)","v":0},{"$f":"SUM(AF40:AF41)","v":0},{"$f":"SUM(AG40:AG41)","v":0},{"$f":"SUM(AH40:AH41)","v":0},{"$f":"SUM(AI40:AI41)","v":800},{"$f":"SUM(AJ40:AJ41)","v":0},{"$f":"SUM(AK40:AK41)","v":0},3572,{"$f":"SUM(AM40:AM41)","v":0},null,null,{"$f":"1+AP41","v":22},"  TOTAL CUSTOMER ACCOUNTING EXPENSES",{"$f":"SUM(AR40:AR41)","v":0},{"$f":"SUM(AS40:AS41)","v":0},{"$f":"SUM(AT40:AT41)","v":0},{"$f":"SUM(AU40:AU41)","v":0},{"$f":"SUM(AV40:AV41)","v":0},{"$f":"SUM(AW40:AW41)","v":0},{"$f":"SUM(AX40:AX41)","v":0},0,{"$f":"SUM(AZ40:AZ41)","v":0},null,null,{"$f":"1+BC41","v":22},"  TOTAL CUSTOMER ACCOUNTING EXPENSES",{"$f":"SUM(BE40:BE41)","v":0},{"$f":"SUM(BF40:BF41)","v":0},0,0,-2373,0,0,0,{"$f":"SUM(BM40:BM41)","v":3849},null,null,{"$f":"1+BP41","v":22},"  TOTAL CUSTOMER ACCOUNTING EXPENSES",{"$f":"SUM(BR40:BR41)","v":0},0,{"$f":"SUM(BT40:BT41)","v":0},0,0,null,{"$f":"SUM(BX40:BX41)","v":6654},{"$f":"SUM(BY40:BY41)","v":54222}]
[]
[null,null,null,"  CUSTOMER SERV. & INFO. EXPENSES:",null,null,null,null,null,null,null,null,null,null,null,null,"  CUSTOMER SERV. & INFO. EXPENSES:",null,null,null,null,null,null,null,null,null,null,null,null,"  CUSTOMER SERV. & INFO. EXPENSES:",null,null,null,null,null,null,null,null,null,null,null,null,"  CUSTOMER SERV. & INFO. EXPENSES:",null,null,null,null,null,null,null,null,null,null,null,null,"  CUSTOMER SERV. & INFO. EXPENSES:",null,null,null,null,null,null,null,null,null,null,null,null,"  CUSTOMER SERV. & INFO. EXPENSES:"]
[null,null,{"$f":"1+C42","v":23},"      LABOR",{"$f":"+ROUND('[1]O&M'!$B$47*0.001,0)","v":6915},{"$f":"+ROUND('[1]O&M'!$C$47*0.001,0)+1","v":329},{"$f":"+ROUND('[1]O&M'!$D$47*0.001,0)","v":-38},{"$f":"+ROUND('[1]O&M'!$E$47*0.001,0)+0.5","v":-210.5},{"$f":"+ROUND('[1]O&M'!G47*0.001,0)","v":0},0,{"$f":"+ROUND('[1]O&M'!I47*0.001,0)","v":0},0,0,null,null,{"$f":"1+P42","v":23},"      LABOR",0,0,0,0,{"$f":"+ROUND('[1]O&M'!O47*0.001,0)","v":0},{"$f":"+ROUND('[1]O&M'!U47*0.001,0)","v":0},{"$f":"+ROUND('[1]O&M'!V47*0.001,0)","v":0},0,0,null,null,{"$f":"1+AC42","v":23},"      LABOR",0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+AP42","v":23},"      LABOR",0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+BC42","v":23},"      LABOR",0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+BP42","v":23},"      LABOR",0,0,0,0,0,null,{"$f":"SUM(F45:M45,R45:Z45,AE45:AM45,AR45:AZ45,BE45:BM45,BR45:BW45)","v":80.5},{"$f":"E45+BX45","v":6995.5}]
["SCHEDULE MJL-D11-1 ",null,{"$f":"1+C45","v":24},"      OTHER",{"$f":"+ROUND('[1]O&M'!$B$48*0.001,0)","v":81084},0,0,0,{"$f":"+ROUND('[1]O&M'!G48*0.001,0)","v":0},0,{"$f":"+ROUND('[1]O&M'!I48*0.001,0)","v":0},0,0,"SCHEDULE MJL-D11-2  ",null,{"$f":"1+P45","v":24},"      OTHER",0,0,0,0,{"$f":"+ROUND('[1]O&M'!O48*0.001,0)","v":0},0,0,0,0,"SCHEDULE MJL-D11-3 ",null,{"$f":"1+AC45","v":24},"      OTHER",{"$f":"+ROUND('[1]O&M'!$U$48*0.001,0)","v":-978},{"$f":"+ROUND('[1]O&M'!$V$48*0.001,0)","v":1338},0,0,0,{"$f":"+ROUND('[1]O&M'!$AB$48*0.001,0)","v":-73388},{"$f":"+ROUND('[1]O&M'!$AC$48*0.001,0)","v":163},0,0,"SCHEDULE MJL-D11-4 ",null,{"$f":"1+AP45","v":24},"      OTHER",0,0,0,0,{"$f":"+ROUND('[1]O&M'!$AN$48*0.001,0)","v":0},0,0,0,0,"SCHEDULE MJL-D11-5 ",null,{"$f":"1+BC45","v":24},"      OTHER",0,0,0,{"$f":"ROUND('[1]O&M'!$BC$48*0.001,0)","v":1},0,0,0,0,0,"SCHEDULE MJL-D11-6 ",null,{"$f":"1+BP45","v":24},"      OTHER",0,0,0,0,0,null,{"$f":"SUM(F46:M46,R46:Z46,AE46:AM46,AR46:AZ46,BE46:BM46,BR46:BW46)","v":-72864},{"$f":"E46+BX46","v":8220}]
[null,null,{"$f":"1+C46","v":25},"  TOTAL CUSTOMER SERV. & INFO. EXPENSES",{"$f":"SUM(E45:E46)","v":87999},329,-38,-210.5,{"$f":"SUM(I45:I46)","v":0},{"$f":"SUM(J45:J46)","v":0},{"$f":"SUM(K45:K46)","v":0},{"$f":"SUM(L45:L46)","v":0},{"$f":"SUM(M45:M46)","v":0},null,null,{"$f":"1+P46","v":25},"  TOTAL CUSTOMER SERV. & INFO. EXPENSES",{"$f":"SUM(R45:R46)","v":0},{"$f":"SUM(S45:S46)","v":0},0,{"$f":"SUM(U45:U46)","v":0},{"$f":"SUM(V45:V46)","v":0},{"$f":"SUM(W45:W46)","v":0},{"$f":"SUM(X45:X46)","v":0},{"$f":"SUM(Y45:Y46)","v":0},0,null,null,{"$f":"1+AC46","v":25},"  TOTAL CUSTOMER SERV. & INFO. EXPENSES",{"$f":"SUM(AE45:AE46)","v":-978},{"$f":"SUM(AF45:AF46)","v":1338},{"$f":"SUM(AG45:AG46)","v":0},{"$f":"SUM(AH45:AH46)","v":0},{"$f":"SUM(AI45:AI46)","v":0},{"$f":"SUM(AJ45:AJ46)","v":-73388},{"$f":"SUM(AK45:AK46)","v":163},0,{"$f":"SUM(AM45:AM46)","v":0},null,null,{"$f":"1+AP46","v":25},"  TOTAL CUSTOMER SERV. & INFO. EXPENSES",{"$f":"SUM(AR45:AR46)","v":0},{"$f":"SUM(AS45:AS46)","v":0},{"$f":"SUM(AT45:AT46)","v":0},{"$f":"SUM(AU45:AU46)","v":0},{"$f":"SUM(AV45:AV46)","v":0},{"$f":"SUM(AW45:AW46)","v":0},{"$f":"SUM(AX45:AX46)","v":0},0,{"$f":"SUM(AZ45:AZ46)","v":0},null,null,{"$f":"1+BC46","v":25},"  TOTAL CUSTOMER SERV. & INFO. EXPENSES",{"$f":"SUM(BE45:BE46)","v":0},{"$f":"SUM(BF45:BF46)","v":0},0,1,0,0,0,0,{"$f":"SUM(BM45:BM46)","v":0},null,null,{"$f":"1+BP46","v":25},"  TOTAL CUSTOMER SERV. & INFO. EXPENSES",{"$f":"SUM(BR45:BR46)","v":0},0,{"$f":"SUM(BT45:BT46)","v":0},0,0,null,{"$f":"SUM(BX45:BX46)","v":-72783.5},{"$f":"SUM(BY45:BY46)","v":15215.5}]
[]
[null,null,null,"  SALES EXPENSES:",null,null,null,null,null,null,null,null,null,null,null,null,"  SALES EXPENSES:",null,null,null,null,null,null,null,null,null,null,null,null,"  SALES EXPENSES:",null,null,null,null,null,null,null,null,null,null,null,null,"  SALES EXPENSES:",null,null,null,null,null,null,null,null,null,null,null,null,"  SALES EXPENSES:",null,null,null,null,null,null,null,null,null,null,null,null,"  SALES EXPENSES:"]
[null,null,{"$f":"1+C47","v":26},"      LABOR",{"$f":"+ROUND('[1]O&M'!$B$52*0.001,0)","v":279},{"$f":"+ROUND('[1]O&M'!$C$52*0.001,0)","v":14},{"$f":"+ROUND('[1]O&M'!$D$52*0.001,0)","v":-2},0,{"$f":"+ROUND('[1]O&M'!G52*0.001,0)","v":0},0,{"$f":"+ROUND('[1]O&M'!I52*0.001,0)","v":0},0,0,null,null,{"$f":"1+P47","v":26},"      LABOR",0,0,0,0,{"$f":"+ROUND('[1]O&M'!O52*0.001,0)","v":0},{"$f":"+ROUND('[1]O&M'!U52*0.001,0)","v":0},{"$f":"+ROUND('[1]O&M'!V52*0.001,0)","v":0},0,0,null,null,{"$f":"1+AC47","v":26},"      LABOR",0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+AP47","v":26},"      LABOR",0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+BC47","v":26},"      LABOR",0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+BP47","v":26},"      LABOR",0,0,0,0,0,null,{"$f":"SUM(F50:M50,R50:Z50,AE50:AM50,AR50:AZ50,BE50:BM50,BR50:BW50)","v":12},{"$f":"E50+BX50","v":291}]
[null,null,{"$f":"1+C50","v":27},"      OTHER",{"$f":"+ROUND('[1]O&M'!$B$53*0.001,0)+1","v":200},0,0,0,{"$f":"+ROUND('[1]O&M'!G53*0.001,0)","v":0},0,{"$f":"+ROUND('[1]O&M'!I53*0.001,0)","v":0},{"$f":"+ROUND('[1]O&M'!$J$53*0.001,0)","v":0},0,null,null,{"$f":"1+P50","v":27},"      OTHER",0,0,0,0,{"$f":"+ROUND('[1]O&M'!O53*0.001,0)","v":0},{"$f":"+ROUND('[1]O&M'!U53*0.001,0)","v":0},{"$f":"+ROUND('[1]O&M'!V53*0.001,0)","v":0},0,0,null,null,{"$f":"1+AC50","v":27},"      OTHER",0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+AP50","v":27},"      OTHER",0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+BC50","v":27},"      OTHER",0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+BP50","v":27},"      OTHER",0,0,0,0,0,null,{"$f":"SUM(F51:M51,R51:Z51,AE51:AM51,AR51:AZ51,BE51:BM51,BR51:BW51)","v":0},{"$f":"E51+BX51","v":200}]
[null,null,{"$f":"1+C51","v":28},"  TOTAL SALES EXPENSES",{"$f":"SUM(E50:E51)","v":479},14,-2,0,{"$f":"SUM(I50:I51)","v":0},{"$f":"SUM(J50:J51)","v":0},{"$f":"SUM(K50:K51)","v":0},{"$f":"SUM(L50:L51)","v":0},{"$f":"SUM(M50:M51)","v":0},null,null,{"$f":"1+P51","v":28},"  TOTAL SALES EXPENSES",{"$f":"SUM(R50:R51)","v":0},{"$f":"SUM(S50:S51)","v":0},0,{"$f":"SUM(U50:U51)","v":0},{"$f":"SUM(V50:V51)","v":0},{"$f":"SUM(W50:W51)","v":0},{"$f":"SUM(X50:X51)","v":0},{"$f":"SUM(Y50:Y51)","v":0},0,null,null,{"$f":"1+AC51","v":28},"  TOTAL SALES EXPENSES",{"$f":"SUM(AE50:AE51)","v":0},{"$f":"SUM(AF50:AF51)","v":0},{"$f":"SUM(AG50:AG51)","v":0},{"$f":"SUM(AH50:AH51)","v":0},{"$f":"SUM(AI50:AI51)","v":0},{"$f":"SUM(AJ50:AJ51)","v":0},{"$f":"SUM(AK50:AK51)","v":0},0,{"$f":"SUM(AM50:AM51)","v":0},null,null,{"$f":"1+AP51","v":28},"  TOTAL SALES EXPENSES",{"$f":"SUM(AR50:AR51)","v":0},{"$f":"SUM(AS50:AS51)","v":0},{"$f":"SUM(AT50:AT51)","v":0},{"$f":"SUM(AU50:AU51)","v":0},{"$f":"SUM(AV50:AV51)","v":0},{"$f":"SUM(AW50:AW51)","v":0},{"$f":"SUM(AX50:AX51)","v":0},0,{"$f":"SUM(AZ50:AZ51)","v":0},null,null,{"$f":"1+BC51","v":28},"  TOTAL SALES EXPENSES",{"$f":"SUM(BE50:BE51)","v":0},{"$f":"SUM(BF50:BF51)","v":0},0,0,0,0,0,0,{"$f":"SUM(BM50:BM51)","v":0},null,null,{"$f":"1+BP51","v":28},"  TOTAL SALES EXPENSES",{"$f":"SUM(BR50:BR51)","v":0},0,{"$f":"SUM(BT50:BT51)","v":0},0,0,null,{"$f":"SUM(BX50:BX51)","v":12},{"$f":"SUM(BY50:BY51)","v":491}]
[]
[null,null,null,"  ADMINISTRATIVE & GENERAL EXPENSES:",null,null,null,null,null,null,null,null,null,null,null,null,"  ADMINISTRATIVE & GENERAL EXPENSES:",null,null,null,null,null,null,null,null,null,null,null,null,"  ADMINISTRATIVE & GENERAL EXPENSES:",null,null,null,null,null,null,null,null,null,null,null,null,"  ADMINISTRATIVE & GENERAL EXPENSES:",null,null,null,null,null,null,null,null,null,null,null,null,"  ADMINISTRATIVE & GENERAL EXPENSES:",null,null,null,null,null,null,null,null,null,null,null,null,"  ADMINISTRATIVE & GENERAL EXPENSES:"]
[null,null,{"$f":"1+C52","v":29},"      LABOR",{"$f":"+ROUND('[1]O&M'!$B$57*0.001,0)","v":65147},{"$f":"+ROUND('[1]O&M'!$C$57*0.001,0)","v":2716},{"$f":"+ROUND('[1]O&M'!$D$57*0.001,0)","v":-360},{"$f":"+ROUND('[1]O&M'!$E$57*0.001,0)","v":-3929},{"$f":"+ROUND('[1]O&M'!G57*0.001,0)","v":0},0,{"$f":"+ROUND('[1]O&M'!I57*0.001,0)","v":0},0,0,null,null,{"$f":"1+P52","v":29},"      LABOR",0,0,0,0,{"$f":"+ROUND('[1]O&M'!O57*0.001,0)","v":0},{"$f":"+ROUND('[1]O&M'!U57*0.001,0)","v":0},{"$f":"+ROUND('[1]O&M'!V57*0.001,0)","v":0},0,0,null,null,{"$f":"1+AC52","v":29},"      LABOR",0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+AP52","v":29},"      LABOR",0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+BC52","v":29},"      LABOR",0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+BP52","v":29},"      LABOR",0,0,0,0,0,null,{"$f":"SUM(F55:M55,R55:Z55,AE55:AM55,AR55:AZ55,BE55:BM55,BR55:BW55)","v":-1573},{"$f":"E55+BX55","v":63574}]
[null,null,{"$f":"1+C55","v":30},"      OTHER",{"$f":"+ROUND('[1]O&M'!$B$58*0.001,0)","v":129431},0,0,0,{"$f":"+ROUND('[1]O&M'!G58*0.001,0)","v":0},0,{"$f":"+ROUND('[1]O&M'!I58*0.001,0)","v":0},{"$f":"+ROUND('[1]O&M'!$J$58*0.001,0)","v":-1},0,null,null,{"$f":"1+P55","v":30},"      OTHER",0,0,0,0,{"$f":"+ROUND('[1]O&M'!O58*0.001,0)","v":0},{"$f":"+ROUND('[1]O&M'!U58*0.001,0)","v":0},{"$f":"+ROUND('[1]O&M'!V58*0.001,0)","v":0},0,0,null,null,{"$f":"1+AC55","v":30},"      OTHER",0,{"$f":"+ROUND('[1]O&M'!$Z$48*0.001,0)","v":0},0,0,0,{"$f":"+ROUND('[1]O&M'!$AA$58*0.001,0)","v":0},0,0,{"$f":"+ROUND('[1]O&M'!$AI$58*0.001,0)","v":3018},null,null,{"$f":"1+AP55","v":30},"      OTHER",{"$f":"+ROUND('[1]O&M'!$AJ$58*0.001,0)","v":975},{"$f":"+ROUND('[1]O&M'!$AL$58*0.001,0)","v":-148},{"$f":"+ROUND('[1]O&M'!$AM$58*0.001,0)","v":-27901},{"$f":"+ROUND('[1]O&M'!$AN$58*0.001,0)","v":2498},0,{"$f":"+ROUND('[1]O&M'!$AP$58*0.001,0)","v":-136},{"$f":"+ROUND('[1]O&M'!$AQ$58*0.001,0)","v":-232},{"$f":"+ROUND('[1]O&M'!$AR$58*0.001,0)","v":-422},{"$f":"+ROUND('[1]O&M'!$AT$58*0.001,0)","v":-48},null,null,{"$f":"1+BC55","v":30},"      OTHER",{"$f":"+ROUND('[1]O&M'!$AS$58*0.001,0)","v":80},{"$f":"+ROUND('[1]O&M'!$AW$58*0.001,0)","v":-710},{"$f":"+ROUND('[1]O&M'!$AY$58*0.001,0)","v":0},{"$f":"+ROUND('[1]O&M'!$BC$58*0.001,0)+1","v":588},{"$f":"+ROUND('[1]O&M'!$BD$58*0.001,0)","v":0},{"$f":"+ROUND('[1]O&M'!$BK$58*0.001,0)","v":-6274},{"$f":"+ROUND('[1]O&M'!$BM$58*0.001,0)","v":0},{"$f":"+ROUND('[1]O&M'!$BG$58*0.001,0)","v":15},0,null,null,{"$f":"1+BP55","v":30},"      OTHER",{"$f":"+ROUND('[1]O&M'!$BN$58*0.001,0)","v":345},{"$f":"+ROUND('[1]O&M'!$BO$58*0.001,0)","v":-277},{"$f":"+ROUND('[1]O&M'!$BP$58*0.001,0)","v":355},{"$f":"+ROUND('[1]O&M'!$BQ$58*0.001,0)","v":384},{"$f":"+ROUND('[1]O&M'!$BS$58*0.001,0)","v":1},null,{"$f":"SUM(F56:M56,R56:Z56,AE56:AM56,AR56:AZ56,BE56:BM56,BR56:BW56)","v":-27890},{"$f":"E56+BX56","v":101541}]
[null,null,{"$f":"1+C56","v":31},"  TOTAL ADMINISTRATIVE & GENERAL EXPENSES",{"$f":"SUM(E55:E56)","v":194578},2716,-360,-3929,{"$f":"SUM(I55:I56)","v":0},{"$f":"SUM(J55:J56)","v":0},{"$f":"SUM(K55:K56)","v":0},{"$f":"SUM(L55:L56)","v":-1},{"$f":"SUM(M55:M56)","v":0},null,null,{"$f":"1+P56","v":31},"  TOTAL ADMINISTRATIVE & GENERAL EXPENSES",{"$f":"SUM(R55:R56)","v":0},{"$f":"SUM(S55:S56)","v":0},0,{"$f":"SUM(U55:U56)","v":0},{"$f":"SUM(V55:V56)","v":0},{"$f":"SUM(W55:W56)","v":0},{"$f":"SUM(X55:X56)","v":0},{"$f":"SUM(Y55:Y56)","v":0},0,null,null,{"$f":"1+AC56","v":31},"  TOTAL ADMINISTRATIVE & GENERAL EXPENSES",{"$f":"SUM(AE55:AE56)","v":0},{"$f":"SUM(AF55:AF56)","v":0},{"$f":"SUM(AG55:AG56)","v":0},{"$f":"SUM(AH55:AH56)","v":0},{"$f":"SUM(AI55:AI56)","v":0},{"$f":"SUM(AJ55:AJ56)","v":0},{"$f":"SUM(AK55:AK56)","v":0},0,{"$f":"SUM(AM55:AM56)","v":3018},null,null,{"$f":"1+AP56","v":31},"  TOTAL ADMINISTRATIVE & GENERAL EXPENSES",{"$f":"SUM(AR55:AR56)","v":975},{"$f":"SUM(AS55:AS56)","v":-148},{"$f":"SUM(AT55:AT56)","v":-27901},2498,{"$f":"SUM(AV55:AV56)","v":0},{"$f":"SUM(AW55:AW56)","v":-136},-232,{"$f":"SUM(AY55:AY56)","v":-422},{"$f":"SUM(AZ55:AZ56)","v":-48},null,null,{"$f":"1+BC56","v":31},"  TOTAL ADMINISTRATIVE & GENERAL EXPENSES",{"$f":"SUM(BE55:BE56)","v":80},{"$f":"SUM(BF55:BF56)","v":-710},0,588,0,-6274,0,15,{"$f":"SUM(BM55:BM56)","v":0},null,null,{"$f":"1+BP56","v":31},"  TOTAL ADMINISTRATIVE & GENERAL EXPENSES",{"$f":"SUM(BR55:BR56)","v":345},-277,{"$f":"SUM(BT55:BT56)","v":355},384,1,null,{"$f":"SUM(BX55:BX56)","v":-29463},{"$f":"SUM(BY55:BY56)","v":165115}]
[]
[null,null,{"$f":"1+C57","v":32},"TOTAL OPERATIONS & MAINTENANCE EXPENSES",{"$f":"E22+E27+E32+E37+E42+E47+E52+E57","v":1734030},{"$f":"F22+F27+F32+F37+F42+F47+F52+F57","v":17728},-1969,-6437.5,{"$f":"I22+I27+I32+I37+I42+I47+I52+I57","v":-11886},{"$f":"J22+J27+J32+J37+J42+J47+J52+J57","v":200766},{"$f":"K22+K27+K32+K37+K42+K47+K52+K57","v":-125},{"$f":"L22+L27+L32+L37+L42+L47+L52+L57","v":-29},{"$f":"M22+M27+M32+M37+M42+M47+M52+M57","v":15105},null,null,{"$f":"1+P57","v":32},"TOTAL OPERATIONS & MAINTENANCE EXPENSES",{"$f":"R22+R27+R32+R37+R42+R47+R52+R57","v":1496},{"$f":"S22+S27+S32+S37+S42+S47+S52+S57","v":-2539},-1443,{"$f":"U22+U27+U32+U37+U42+U47+U52+U57","v":-102847},{"$f":"V22+V27+V32+V37+V42+V47+V52+V57","v":27977},{"$f":"W22+W27+W32+W37+W42+W47+W52+W57","v":-27887},{"$f":"X22+X27+X32+X37+X42+X47+X52+X57","v":-968},{"$f":"Y22+Y27+Y32+Y37+Y42+Y47+Y52+Y57","v":3902},1962,null,null,{"$f":"1+AC57","v":32},"TOTAL OPERATIONS & MAINTENANCE EXPENSES",{"$f":"AE22+AE27+AE32+AE37+AE42+AE47+AE52+AE57","v":-978},{"$f":"AF22+AF27+AF32+AF37+AF42+AF47+AF52+AF57","v":1338},{"$f":"AG22+AG27+AG32+AG37+AG42+AG47+AG52+AG57","v":-825},-5330,{"$f":"AI22+AI27+AI32+AI37+AI42+AI47+AI52+AI57","v":800},-73388,163,3572,{"$f":"AM22+AM27+AM32+AM37+AM42+AM47+AM52+AM57","v":3018},null,null,{"$f":"1+AP57","v":32},"TOTAL OPERATIONS & MAINTENANCE EXPENSES",{"$f":"AR22+AR27+AR32+AR37+AR42+AR47+AR52+AR57","v":975},{"$f":"AS22+AS27+AS32+AS37+AS42+AS47+AS52+AS57","v":-148},{"$f":"AT22+AT27+AT32+AT37+AT42+AT47+AT52+AT57","v":-27901},2498,{"$f":"AV22+AV27+AV32+AV37+AV42+AV47+AV52+AV57","v":3892},{"$f":"AW22+AW27+AW32+AW37+AW42+AW47+AW52+AW57","v":-136},-232,{"$f":"AY22+AY27+AY32+AY37+AY42+AY47+AY52+AY57","v":-422},{"$f":"AZ22+AZ27+AZ32+AZ37+AZ42+AZ47+AZ52+AZ57","v":-48},null,null,{"$f":"1+BC57","v":32},"TOTAL OPERATIONS & MAINTENANCE EXPENSES",{"$f":"BE22+BE27+BE32+BE37+BE42+BE47+BE52+BE57","v":80},{"$f":"BF22+BF27+BF32+BF37+BF42+BF47+BF52+BF57","v":-710},0,554,-2373,-6274,-3434,15,{"$f":"BM22+BM27+BM32+BM37+BM42+BM47+BM52+BM57","v":3849},null,null,{"$f":"1+BP57","v":32},"TOTAL OPERATIONS & MAINTENANCE EXPENSES",{"$f":"BR22+BR27+BR32+BR37+BR42+BR47+BR52+BR57","v":345},-277,{"$f":"BT22+BT27+BT32+BT37+BT42+BT47+BT52+BT57","v":377},384,1,null,{"$f":"BX22+BX27+BX32+BX37+BX42+BX47+BX52+BX57","v":12190.5},{"$f":"BY22+BY27+BY32+BY37+BY42+BY47+BY52+BY57","v":1746220.5}]
[]
[null,null,{"$f":"1+C59","v":33},"NOTE: See SCHEDULE MJL-D11-7 for explanation of the pro forma adjustments.",null,null,null,null,null,null,null,null,null,null,null,{"$f":"1+P59","v":33},"NOTE: See SCHEDULE MJL-D11-7 for explanation of the pro forma adjustments.",null,null,null,null,null,null,null,null,null,null,null,{"$f":"1+AC59","v":33},"NOTE: See SCHEDULE MJL-D11-7 for explanation of the pro forma adjustments.",null,null,null,null,null,null,null,null,null,null,null,{"$f":"1+AP59","v":33},"NOTE: See SCHEDULE MJL-D11-7 for explanation of the pro forma adjustments.",null,null,null,null,null,null,null,null,null,null,null,{"$f":"1+BC59","v":33},"NOTE: See SCHEDULE MJL-D11-7 for explanation of the pro forma adjustments.",null,null,null,null,null,null,null,null,null,null,null,{"$f":"1+BP59","v":33},"NOTE: See SCHEDULE MJL-D11-7 for explanation of the pro forma adjustments."]

{"sheet":"SCHEDULE MJL-D11-7","index":11,"n_rows":120,"n_cols":12,"rows_kept":120,"cut":false,"hidden":false,"merged":[[9,2,12,9],[100,2,100,9],[102,2,102,9],[0,0,0,11],[2,0,2,11],[1,0,1,11],[6,2,6,9],[3,0,3,11],[4,0,4,11],[30,2,30,9],[55,2,55,9],[70,2,71,9],[32,2,32,9],[36,2,36,9],[7,2,7,9],[17,2,17,9],[14,2,15,9],[23,2,24,9],[73,2,73,9],[20,2,21,9],[26,2,26,9],[34,2,34,9],[28,2,28,9],[94,2,94,9],[86,2,86,9],[38,2,38,9],[47,2,47,9],[54,2,54,9],[39,2,39,9],[87,2,87,9],[84,2,84,9],[53,2,53,9],[81,2,82,9],[75,2,75,9],[77,2,77,9]]}
["AMEREN MISSOURI"]
["ELECTRIC OPERATING AND MAINTENANCE EXPENSE"]
["PRO FORMA ADJUSTMENTS"]
[{"$f":"'SCHEDULE MJL-D5'!A3","v":"FOR THE TWELVE MONTHS ENDED MARCH 31, 2022"}]
["($000)"]
[null,"PRO FORMA",null,null,null,null,null,null,null,null,null,"TOTAL"]
["LINE","ITEM NO.","DESCRIPTION",null,null,null,null,null,null,null,null,"AMOUNT"]
[null,"(A)","(B)",null,null,null,null,null,null,null,null,"(C)"]
[]
[1,-1,"Increased labor expense from annualizing the average 2.25% wage increase for management employees effective January 1, 2022, the 2.50% wage increase for the Company's union employees effective January 1, 2022 per the labor contracts, annualizing an average 3.75% wage increase for management employees effective January 1, 2023, and the 3.75% wage increase for the Company's union employees effective January 1, 2023. ",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-D11-1 to 6'!F59","v":17728}]
[{"$f":"1+A10","v":2}]
[{"$f":"1+A11","v":3}]
[{"$f":"1+A12","v":4}]
[]
[{"$f":"1+A13","v":5},-2,"Decrease the incentive compensation expense for the incentive compensation applicable to AMS and Ameren Missouri officers that is based on the achievement of earnings-per-share goals of the Company.",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-D11-1 to 6'!G59","v":-1969}]
[{"$f":"1+A15","v":6}]
[]
[{"$f":"1+A16","v":7},-3,"Eliminate the long term incentive compensation expense that is based on the achievement of earnings-per-share goals of the Company.",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-D11-1 to 6'!H59","v":-6437.5}]
[]
[]
[{"$f":"1+A18","v":8},-4,"Decrease in fuel expense to reflect the normalized sales and customer growth through  December 31, 2022 reflecting January 2023 fuel prices.",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-D11-1 to 6'!I59","v":-11886}]
[{"$f":"1+A21","v":9}]
[]
[{"$f":"1+A22","v":10},-5,"Increase in purchased power expense to reflect normalized sales and customer growth through December 30, 2022 and normalized power prices.",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-D11-1 to 6'!J59","v":200766}]
[{"$f":"1+A24","v":11}]
[]
[{"$f":"1+A25","v":12},-6,"Decrease in transmission expense related to Mark Twain Transmission project.",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-D11-1 to 6'!K59","v":-125}]
[]
[{"$f":"1+A27","v":13},-7,"Remove membership dues related to lobbying activities.",null,null,null,null,null,null,null,null,{"$f":"+'SCHEDULE MJL-D11-1 to 6'!L59","v":-29}]
[]
[{"$f":"1+A29","v":14},-8,"Increase the coal handling costs to reflect the elimination of the coal refinement process.",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-D11-1 to 6'!M59","v":15105}]
[]
[{"$f":"1+A31","v":15},-9,"Increase in production expense to normalize steam plant maintenance. ",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-D11-1 to 6'!R59","v":1496}]
[]
[{"$f":"1+A33","v":16},-10,"Decrease in production expense to remove a portion of production expense related to Rush Island Energy Center. ",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-D11-1 to 6'!S59","v":-2539}]
[]
[{"$f":"1+A35","v":17},-11,"Decrease in production expense to remove a portion of production expense related to Meramec Energy Center. ",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-D11-1 to 6'!T59","v":-1443}]
[]
[{"$f":"1+A37","v":18},-12,"Eliminate test year FAC recovery.",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-D11-1 to 6'!U59","v":-102847}]
[]
[{"$f":"1+A39","v":19},-13,"Increase to the nuclear production expense to include the average annualized amount of the last 3 Callaway",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-D11-1 to 6'!V59","v":27977}]
[{"$f":"1+A41","v":20},null,"Nuclear Plant refueling expenses."]
[]
[{"$f":"1+A42","v":21},-14,"Decrease in production expenses for the amortization of Callaway refueling amortization.",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-D11-1 to 6'!W59","v":-27887}]
[]
[{"$f":"1+A44","v":22},-15,"Decrease in production expenses for the unplanned Callaway outage.",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-D11-1 to 6'!X59","v":-968}]
[]
[{"$f":"1+A46","v":23},-16,"Increase in production expenses for amortization of RES cost regulatory liability.",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-D11-1 to 6'!Y59","v":3902}]
[]
[{"$f":"1+A48","v":24},-17,"Increase in production expenses for rebase of RES expenses",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-D11-1 to 6'!Z59","v":1962}]
[]
[{"$f":"1+A50","v":25},-18,"Decrease in production expenses to eliminate Solar Rebate amortizations in the test year.",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-D11-1 to 6'!AE59","v":-978}]
[]
[{"$f":"1+A52","v":26},-19,"Increase in production expenses for Solar Rebate amortizations.",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-D11-1 to 6'!AF59","v":1338}]
[]
[{"$f":"1+A54","v":27},-20,"Decrease in production and distribution expenses for decrease in depreciation charged to O&M.",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-D11-1 to 6'!AG59","v":-825}]
[]
[{"$f":"1+A56","v":28},-21,"Decrease in distribution expense to normalize storm costs.",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-D11-1 to 6'!AH59","v":-5330}]
[]
[{"$f":"1+A58","v":29},-22,"Increase in customer accounting expenses to reflect interest expense at 4.25% on the average customer deposit",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-D11-1 to 6'!AI59","v":800}]
[{"$f":"1+A60","v":30},null,"balance."]
[]
[{"$f":"A61+1","v":31},-23,"Decrease in customer service to eliminate test year MEEIA program costs.",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-D11-1 to 6'!AJ59","v":-73388}]
[]
[{"$f":"1+A63","v":32},-24,"Increase in PAYS program amortization. ",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-D11-1 to 6'!AK59","v":163}]
[]
[{"$f":"1+A65","v":33},-25,"Increase in administrative and general expenses to normalize bad debt expense. ",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-D11-1 to 6'!AL59","v":3572}]
[]
[{"$f":"1+A67","v":34},-26,"Annualize insurance expense based upon current and expected insurance premiums.",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-D11-1 to 6'!AM59","v":3018}]
[]
[{"$f":"1+A69","v":35},-27,"Increase administrative and general expenses to reflect annualized major medical and other employee benefit expenses through December 31, 2022. ",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-D11-1 to 6'!AR59","v":975}]
[{"$f":"1+A71","v":36}]
[]
[{"$f":"1+A72","v":37},-28,"Decrease non-qualified pension expense to reflect current level of expense.",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-D11-1 to 6'!AS59","v":-148}]
[]
[{"$f":"1+A74","v":38},-29,"Rebase Pension and OPEB Tracker to true up level. ",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-D11-1 to 6'!AT59","v":-27901}]
[]
[{"$f":"1+A76","v":39},-30,"Increase the amortization of the net regulatory liabilities for Pension and OPEB Tracker.",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-D11-1 to 6'!AU59","v":2498}]
[]
[{"$f":"1+A78","v":40},-31,"Increase in operating and maintenance expense for base level expenses related to RESRAM. ",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-D11-1 to 6'!AV59","v":3892}]
[]
[{"$f":"1+A80","v":41},-32,"Decrease administrative and general expenses to reflect the 5 case average of expenses to prepare and litigate this rate filings and normalize the amount.",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-D11-1 to 6'!AW59","v":-136}]
[{"$f":"1+A82","v":42}]
[]
[{"$f":"1+A83","v":43},-33,"Decrease administrative and general expenses to annualize MPSC Assessment.",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-D11-1 to 6'!AX59","v":-232}]
[]
[{"$f":"1+A85","v":44},-34,"Decrease administrative and general expenses for certain Board of Director meeting expenses.",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-D11-1 to 6'!AY59","v":-422}]
[]
[{"$f":"1+A87","v":45},-35,"Decrease administrative and general expense to normalize depreciation study expense. ",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-D11-1 to 6'!AZ59","v":-48}]
[]
[{"$f":"1+A89","v":46},-36,"Increase in administrative and general expense for building rent from AMS.",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-D11-1 to 6'!BE59","v":80}]
[]
[{"$f":"1+A91","v":47},-37,"Decrease administrative and general expenses for recently exited facilities.",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-D11-1 to 6'!BF59","v":-710}]
[]
[{"$f":"1+A93","v":48},-38,"Increase administrative and general expenses for software rental expense",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-D11-1 to 6'!BG59","v":0}]
[]
[{"$f":"1+A95","v":49},-39,"Increase administrative and general expense to utilize 2022 allocation factors. ",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-D11-1 to 6'!BH59","v":554}]
[]
[{"$f":"1+A97","v":50},-40,"Decrease in customer accounting expenses to reflect AMR cost savings.",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-D11-1 to 6'!BI59","v":-2373}]
[]
[{"$f":"1+A99","v":51},-41,"Decrease administrative and general expense to remove customer affordability study costs.",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-D11-1 to 6'!BJ59","v":-6274}]
[]
[{"$f":"1+A101","v":52},-42,"Eliminate renewable energy transition costs.",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-D11-1 to 6'!BK59","v":-3434}]
[]
[{"$f":"1+A103","v":53},-43,"Increase administrative and general expenses for electric costs allocated to gas.",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-D11-1 to 6'!BL59","v":15}]
[]
[{"$f":"1+A105","v":54},-44,"Increase in operating and maintenance expense for customer convenience fees. ",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-D11-1 to 6'!BM59","v":3849}]
[]
[{"$f":"1+A107","v":55},-45,"Increase in administrative and general for an increase in cybersecurity costs.",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-D11-1 to 6'!BR59","v":345}]
[]
[{"$f":"1+A109","v":56},-46,"Decrease in administrative and general for a decrease in software maintenance costs.",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-D11-1 to 6'!BS59","v":-277}]
[]
[{"$f":"1+A111","v":57},-47,"Increase in administrative and general and production for NRC fee annualization.",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-D11-1 to 6'!BT59","v":377}]
[]
[{"$f":"1+A113","v":58},-48,"Increase in administrative and general for the sales and use tax audit findings.",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-D11-1 to 6'!BU59","v":384}]
[]
[{"$f":"1+A115","v":59},-49,"Increase administrative and general expense for the EV incentive program.",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-D11-1 to 6'!BV59","v":1}]
[]
[{"$f":"1+A117","v":60},"     Total Pro Forma Adjustments to Electric Operating and Maintenance Expenses"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L10:L119)","v":12190.5}]

{"sheet":"SCHEDULE MJL-D12-1","index":12,"n_rows":58,"n_cols":6,"rows_kept":58,"cut":false,"hidden":false,"merged":[[0,0,0,6],[1,1,1,5],[2,1,2,5],[3,1,3,5]]}
["AMEREN MISSOURI"]
[null,"DEPRECIATION & AMORTIZATION EXPENSE"]
[null,{"$f":"'SCHEDULE MJL-D5'!A3","v":"FOR THE TWELVE MONTHS ENDED MARCH 31, 2022"}]
[null,"($000)"]
[]
[null,null,null,"TOTALS",null,"PRO FORMA"]
[null,null,null,"PER","PRO FORMA","ELECTRIC"]
[null,"LINE","DESCRIPTION","BOOKS","ADJUSTMENTS(1)","TOTALS"]
[null,null,"(A)","(B)","(C)","(D)"]
[]
[null,null,"DEPRECIATION EXPENSE:"]
[null,{"$f":"1","v":1},"STEAM",{"$f":"ROUND('[1]Depreciation Pro Forma'!C13*0.001,0)","v":185282},{"$f":"+'SCHEDULE MJL-D12-2'!E15+'SCHEDULE MJL-D12-2'!E28+'SCHEDULE MJL-D12-2'!E45","v":30480},{"$f":"SUM(D12:E12)","v":215762}]
[null,{"$f":"1+B12","v":2},"NUCLEAR ",{"$f":"ROUND('[1]Depreciation Pro Forma'!C14*0.001,0)","v":79981},{"$f":"+'SCHEDULE MJL-D12-2'!E16+'SCHEDULE MJL-D12-2'!E29","v":12480},92461]
[null,3,"CALLAWAY DECOMMISSIONING ",{"$f":"ROUND('[1]Depreciation Pro Forma'!C15*0.001,0)","v":6759},0,6759]
[null,4,"HYDRAULIC",{"$f":"ROUND('[1]Depreciation Pro Forma'!C16*0.001,0)","v":13115},{"$f":"+'SCHEDULE MJL-D12-2'!E17+'SCHEDULE MJL-D12-2'!E30","v":3450},16565]
[null,5,"OTHER",{"$f":"ROUND('[1]Depreciation Pro Forma'!C17*0.001,0)","v":68522},{"$f":"+'SCHEDULE MJL-D12-2'!E18+'SCHEDULE MJL-D12-2'!E31","v":-2699},65823]
[null,6,"TRANSMISSION PLANT",{"$f":"ROUND('[1]Depreciation Pro Forma'!C18*0.001,0)","v":40737},{"$f":"+'SCHEDULE MJL-D12-2'!E19+'SCHEDULE MJL-D12-2'!E32","v":5957},46694]
[null,7,"DISTRIBUTION PLANT",{"$f":"ROUND('[1]Depreciation Pro Forma'!C19*0.001,0)","v":209517},{"$f":"+'SCHEDULE MJL-D12-2'!E20+'SCHEDULE MJL-D12-2'!E33","v":19699},229216]
[null,8,"GENERAL PLANT",{"$f":"ROUND('[1]Depreciation Pro Forma'!C20*0.001,0)","v":36499},{"$f":"+'SCHEDULE MJL-D12-2'!E21+'SCHEDULE MJL-D12-2'!E34+'SCHEDULE MJL-D12-2'!E46","v":10392},46891]
[null,9,"PISA",{"$f":"ROUND(SUM('[1]Depreciation Pro Forma'!C21:C23)*0.001,0)","v":-60981},{"$f":"+'SCHEDULE MJL-D12-2'!E39","v":60981},0]
[null,10,"ICC DEPRECIATION",{"$f":"ROUND('[1]Depreciation Pro Forma'!C24*0.001,0)","v":0},{"$f":"+'SCHEDULE MJL-D12-2'!E22","v":-1823},{"$f":"SUM(D21:E21)","v":-1823}]
[]
[null,{"$f":"1+B21","v":11},"    TOTAL DEPRECIATION EXPENSE",{"$f":"SUM(D12:D22)","v":579431},{"$f":"SUM(E12:E22)","v":138917},{"$f":"SUM(F12:F22)","v":718348}]
[]
[null,null,"PLANT AMORTIZATION:"]
[null,{"$f":"1+B23","v":12},"INTANGIBLE PLANT",{"$f":"ROUND(SUM('[1]Depreciation Pro Forma'!C29,'[1]Depreciation Pro Forma'!C33,'[1]Depreciation Pro Forma'!$C$34)*0.001,0)","v":80748},{"$f":"+'SCHEDULE MJL-D12-2'!E23+'SCHEDULE MJL-D12-2'!E35","v":7286},{"$f":"SUM(D26:E26)","v":88034}]
[null,{"$f":"1+B26","v":13},"HYDRAULIC PLANT",{"$f":"ROUND('[1]Depreciation Pro Forma'!C30*0.001,0)","v":756},0,{"$f":"SUM(D27:E27)","v":756}]
[null,{"$f":"1+B27","v":14},"TRANSMISSION PLANT",{"$f":"ROUND('[1]Depreciation Pro Forma'!C31*0.001,0)","v":431},0,{"$f":"SUM(D28:E28)","v":431}]
[null,{"$f":"1+B28","v":15},"GENERAL PLANT",{"$f":"ROUND('[1]Depreciation Pro Forma'!C32*0.001,0)","v":0},0,{"$f":"SUM(D29:E29)","v":0}]
[null,{"$f":"1+B29","v":16},"PISA",{"$f":"ROUND(SUM('[1]Depreciation Pro Forma'!C35:C38)*0.001,0)","v":-32983},{"$f":"+'SCHEDULE MJL-D12-2'!E40","v":32983},{"$f":"SUM(D30:E30)","v":0}]
[]
[null,{"$f":"1+B30","v":17},"    TOTAL PLANT AMORTIZATION",{"$f":"SUM(D26:D31)","v":48952},{"$f":"SUM(E26:E31)","v":40269},{"$f":"SUM(F26:F31)","v":89221}]
[]
[null,null,"MISC. AMORTIZATION:"]
[null,{"$f":"1+B32","v":18},"CALLAWAY POST OPERATIONAL ",{"$f":"ROUND('[1]Depreciation Pro Forma'!C43*0.001,0)+1","v":3688},0,{"$f":"SUM(D35:E35)","v":3688}]
[null,{"$f":"B35+1","v":19},"CALLAWAY LIFE EXTEN AMORT",{"$f":"ROUND('[1]Depreciation Pro Forma'!C44*0.001,0)","v":104},0,104]
[null,20,"AMORT OF FUKUSHIMA STUDY COSTS",{"$f":"ROUND('[1]Depreciation Pro Forma'!C45*0.001,0)","v":93},0,93]
[null,21,"SIOUX SCRUBBER CONSTRUCTION ACCOUNTING",{"$f":"ROUND(SUM('[1]Depreciation Pro Forma'!C46:C49)*0.001,0)","v":1196},{"$f":"'SCHEDULE MJL-D12-2'!E49","v":1341},2537]
[null,22,"AMORT OF STORM TRACKERS",{"$f":"ROUND(SUM('[1]Depreciation Pro Forma'!C50:C52)*0.001,0)","v":-519},{"$f":"'SCHEDULE MJL-D12-2'!E52","v":519},0]
[null,23,"CUSTOMER AFFORDABILITY STUDY",{"$f":"ROUND(SUM('[1]Depreciation Pro Forma'!C56)*0.001,0)","v":0},{"$f":"'SCHEDULE MJL-D12-2'!E58","v":1926},1926]
[null,24,"AMORT. OF ENERGY EFFICIENCY REG ASSETS AND MEEIA ORDERED ADJUSTMENTS",{"$f":"ROUND(SUM('[1]Depreciation Pro Forma'!C57:C66)*0.001,0)+ROUND(SUM('[1]Depreciation Pro Forma'!C83)*0.001,0)","v":17440},{"$f":"'SCHEDULE MJL-D12-2'!E55","v":-17438},{"$f":"SUM(D41:E41)","v":2}]
[null,25,"AMORT OF LOW INCOME SURCHARGE",{"$f":"ROUND('[1]Depreciation Pro Forma'!C67*0.001,0)","v":1083},{"$f":"+'SCHEDULE MJL-D12-2'!E60","v":917},2000]
[null,26,"AMORT OF EXTENDED REGULATORY ITEMS",{"$f":"ROUND(SUM('[1]Depreciation Pro Forma'!C68:C70)*0.001,0)","v":-4417},{"$f":"'SCHEDULE MJL-D12-2'!E62","v":3345},-1072]
[null,27,"PISA AMORTIZATION",{"$f":"ROUND(SUM('[1]Depreciation Pro Forma'!C74:C76)*0.001,0)","v":0},{"$f":"'SCHEDULE MJL-D12-2'!E64","v":20497},{"$f":"SUM(D44:E44)","v":20497}]
[null,{"$f":"B44+1","v":28},"EXCESS DEFERRED TRACKER AMORTIZATION",{"$f":"ROUND(SUM('[1]Depreciation Pro Forma'!C78:C80)*0.001,0)","v":5027},{"$f":"+'SCHEDULE MJL-D12-2'!E66","v":-10829},-5802]
[null,29,"RESRAM ADJUSTMENTS",{"$f":"ROUND(SUM('[1]Depreciation Pro Forma'!C84:C91)*0.001,0)","v":5475},{"$f":"+'SCHEDULE MJL-D12-2'!E68","v":-5475},0]
[null,30,"CHARGE AHEAD CORRIDOR",{"$f":"ROUND(SUM('[1]Depreciation Pro Forma'!C92:C93)*0.001,0)","v":51},{"$f":"+'SCHEDULE MJL-D12-2'!E70","v":953},1004]
[null,31,"FERC ROE CASE AMORTIZATION",{"$f":"ROUND('[1]Depreciation Pro Forma'!C95*0.001,0)","v":0},{"$f":"'SCHEDULE MJL-D12-2'!E72","v":-760},-760]
[null,32,"EQUITY ISSUANCE COST AMORTIZATION",{"$f":"ROUND(SUM('[1]Depreciation Pro Forma'!C98:C99)*0.001,0)","v":0},{"$f":"'SCHEDULE MJL-D12-2'!E76","v":1782},1782]
[null,33,"MERAMEC RETIREMENT",{"$f":"ROUND(SUM('[1]Depreciation Pro Forma'!C100:C101)*0.001,0)","v":-5077},{"$f":"'SCHEDULE MJL-D12-2'!E78","v":17260},12183]
[null,34,"COVID AAO",{"$f":"ROUND('[1]Depreciation Pro Forma'!C102*0.001,0)+ROUND('[1]Depreciation Pro Forma'!$C$103*0.001,0)","v":566},{"$f":"+'SCHEDULE MJL-D12-2'!E74-1","v":1180},1746]
[null,35,"CRITICAL NEEDS LOW INCOME PROGRAM",{"$f":"ROUND('[1]Depreciation Pro Forma'!C104*0.001,0)","v":21},{"$f":"+'SCHEDULE MJL-D12-2'!E80","v":229},250]
[null,36,"REHOUSING PILOT LOW INCOME PROGRAM",{"$f":"ROUND('[1]Depreciation Pro Forma'!C105*0.001,0)","v":21},{"$f":"+'SCHEDULE MJL-D12-2'!E82","v":229},250]
[null,37,"  TOTAL MISC AMORTIZATION",{"$f":"SUM(D35:D53)","v":24752},{"$f":"SUM(E35:E53)","v":15676},{"$f":"SUM(F35:F53)","v":40428}]
[]
[null,{"$f":"1+B54","v":38},"TOTAL DEPR & AMORTIZATION EXPENSE",{"$f":"+D23+D32+D54","v":653135},{"$f":"+E23+E32+E54","v":194862},{"$f":"+F23+F32+F54","v":847997}]
[]
[null,{"$f":"1+B56","v":39},"(1)  See SCHEDULE MJL-D12-2 for explanation of the pro forma adjustments."]

{"sheet":"SCHEDULE MJL-D14","index":13,"n_rows":82,"n_cols":5,"rows_kept":82,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,0,1,5],[2,0,2,5]]}
["AMEREN MISSOURI"]
[{"$f":"\"TOTAL ELECTRIC INCOME TAXES AT THE PROPOSED RETURN\n\" & 'SCHEDULE MJL-D5'!A3","v":"TOTAL ELECTRIC INCOME TAXES AT THE PROPOSED RETURN\nFOR THE TWELVE MONTHS ENDED MARCH 31, 2022"}]
["($000)"]
[]
[]
[null,null,null,null,"TOTAL"]
["LINE",null,"DESCRIPTION",null,"ELECTRIC"]
[null,null,"(A)","(B)","(C)"]
[]
[1,null,"TOTAL ELECTRIC NET INCOME FROM OPERATIONS",null,{"$f":"ROUND([1]IncomeTaxClaimed!$E$8*0.001,0)","v":833991}]
[]
[null,null,"ADD"]
[{"$f":"1+A10","v":2},null,"CURRENT INCOME TAXES",null,{"$f":"ROUND([1]IncomeTaxClaimed!$E$12*0.001,0)+1","v":94293}]
[{"$f":"1+A13","v":3},null,"DEFERRED INCOME TAXES"]
[{"$f":"1+A14","v":4},null,"     DEFERRED INCOME TAX EXPENSE",null,{"$f":"ROUND([1]IncomeTaxClaimed!$E$14*0.001,0)","v":-84756}]
[{"$f":"1+A15","v":5},null,"     I.T.C. AMORTIZATION",null,{"$f":"ROUND([1]IncomeTaxClaimed!$E$15*0.001,0)","v":-4125}]
[]
[{"$f":"1+A16","v":6},null,"TOTAL ELECTRIC NET INCOME BEFORE INCOME TAX",null,{"$f":"SUM(E10:E16)","v":839403}]
[]
[null,null,"ADDITIONS TO NET INCOME BEFORE INCOME TAX"]
[{"$f":"1+A18","v":7},null,"     BOOK DEPRECIATION",null,{"$f":"ROUND([1]IncomeTaxClaimed!$E$20*0.001,0)","v":718348}]
[{"$f":"1+A21","v":8},null,"     BOOK DEPRECIATION CHARGED TO O&M",null,{"$f":"ROUND([1]IncomeTaxClaimed!$E$21*0.001,0)","v":3857}]
[9,null,"     INTANGIBLE AMORTIZATIONS",null,{"$f":"ROUND([1]IncomeTaxClaimed!$E$22*0.001,0)","v":88034}]
[10,null,"     HYDRAULIC AMORTIZATIONS",null,{"$f":"ROUND([1]IncomeTaxClaimed!$E$23*0.001,0)","v":756}]
[11,null,"     TRANSMISSION AMORTIZATIONS",null,{"$f":"ROUND([1]IncomeTaxClaimed!$E$24*0.001,0)","v":431}]
[12,null,"     CALLAWAY POST OPERATIONAL COSTS ",null,{"$f":"ROUND([1]IncomeTaxClaimed!$E$25*0.001,0)","v":3687}]
[13,null,"     NONDEDUCTIBLE PARKING LOT EXPENSE",null,{"$f":"ROUND([1]IncomeTaxClaimed!$E$26*0.001,0)-1","v":421}]
[]
[{"$f":"1+A27","v":14},null,"TOTAL ADDITIONS",null,{"$f":"SUM(E21:E28)","v":815534}]
[]
[null,null,"SUBTRACTIONS TO NET INCOME BEFORE INCOME TAX"]
[{"$f":"1+A29","v":15},null,"     INTEREST ON DEBT (1)",null,{"$f":"ROUND([1]IncomeTaxClaimed!$E$31*0.001,0)-1","v":215983}]
[{"$f":"1+A32","v":16},null,"     TAX STRAIGHT LINE",null,{"$f":"ROUND([1]IncomeTaxClaimed!$E$32*0.001,0)","v":798151}]
[{"$f":"1+A33","v":17},null,"     PRODUCTION DEDUCTION",null,{"$f":"ROUND([1]IncomeTaxClaimed!$E$33*0.001,0)","v":0}]
[{"$f":"1+A34","v":18},null,"     NUCLEAR DECOMMISSIONING",null,{"$f":"ROUND([1]IncomeTaxClaimed!$E$34*0.001,0)","v":6759}]
[{"$f":"1+A33","v":17},null,"     RESTRICTED STOCK UNITS",null,{"$f":"ROUND([1]IncomeTaxClaimed!$E$35*0.001,0)","v":616}]
[{"$f":"1+A34","v":18},null,"     PREFERRED DIVIDEND DEDUCTION",null,{"$f":"ROUND([1]IncomeTaxClaimed!$E$36*0.001,0)","v":415}]
[]
[{"$f":"1+A37","v":19},null,"TOTAL SUBTRACTIONS",null,{"$f":"SUM(E32:E37)","v":1021924}]
[]
[{"$f":"1+A39","v":20},null,"TOTAL ELECTRIC NET TAXABLE INCOME",null,{"$f":"E18+E29-E39","v":633013}]
[]
[null,null,"FEDERAL INCOME TAX "]
[{"$f":"1+A41","v":21},null,"  NET TAXABLE INCOME",null,{"$f":"E41","v":633013}]
[{"$f":"1+A44","v":22},null,"  DEDUCT MISSOURI INCOME TAX",null,{"$f":"ROUND([1]IncomeTaxClaimed!$E$46*0.001,0)","v":23910}]
[{"$f":"1+A45","v":23},null,"  DEDUCT CITY EARNINGS TAX",null,{"$f":"+E69","v":138}]
[{"$f":"1+A46","v":24},null,"  FEDERAL TAXABLE INCOME",null,{"$f":"E44-E45-E46","v":608965}]
[]
[{"$f":"1+A47","v":25},null,{"$f":"\"  FEDERAL INCOME TAX\"","v":"  FEDERAL INCOME TAX"},{"$f":"[1]IncomeTaxClaimed!$D$50","v":0.21},{"$f":"ROUND(E47*D49,0)","v":127883}]
[null,null,"   LESS TAX CREDITS"]
[{"$f":"1+A49","v":26},null,"      RESEARCH CREDIT",null,{"$f":"ROUND([1]IncomeTaxClaimed!$E$52*0.001,0)","v":1054}]
[{"$f":"1+A51","v":27},null,"      PRODUCTION TAX CREDIT ",null,{"$f":"ROUND([1]IncomeTaxClaimed!$E$53*0.001,0)+1","v":56586}]
[{"$f":"1+A52","v":28},null,"TOTAL ELECTRIC FEDERAL INCOME TAX",null,{"$f":"+E49-E51-E52","v":70243}]
[]
[null,null,"STATE INCOME TAXES"]
[{"$f":"1+A53","v":29},null,"  NET TAXABLE INCOME",null,{"$f":"E41","v":633013}]
[{"$f":"1+A56","v":30},null,"  DEDUCT 50% OF FEDERAL INCOME TAX",null,{"$f":"ROUND(E53*0.5,0)","v":35122}]
[{"$f":"1+A57","v":31},null,"  DEDUCT CITY EARNINGS TAX",null,{"$f":"+E69","v":138}]
[{"$f":"1+A58","v":32},null,"  MISSOURI TAXABLE INCOME",null,{"$f":"E56-E57-E58","v":597753}]
[]
[{"$f":"1+A59","v":33},null,"TOTAL ELECTRIC MISSOURI INCOME TAX",{"$f":"[1]IncomeTaxClaimed!$D$63","v":0.04},{"$f":"ROUND(E59*D61,0)+1","v":23911}]
[]
[null,null,"CITY EARNINGS TAX"]
[{"$f":"1+A61","v":34},null,"  NET TAXABLE INCOME",null,{"$f":"+E41","v":633013}]
[{"$f":"1+A64","v":35},null,"  LESS TAX ADJUSTMENTS TO INCOME",null,{"$f":"ROUND([1]IncomeTaxClaimed!$E$67*0.001,0)","v":-482664}]
[{"$f":"1+A65","v":36},null,"  CITY TAXABLE INCOME",null,{"$f":"+E64+E65","v":150349}]
[{"$f":"1+A66","v":37},null,"  CITY EARNINGS TAX",{"$f":"[1]IncomeTaxClaimed!$D$69","v":1.175E-3},{"$f":"ROUND(E66*D67,0)","v":177}]
[{"$f":"1+A67","v":38},null,"  LESS: TAX CREDIT",null,{"$f":"ROUND([1]IncomeTaxClaimed!$E$70*0.001,0)","v":39}]
[{"$f":"1+A68","v":39},null,"  TOTAL ELECTRIC NET CITY EARNINGS TAX",null,{"$f":"+E67-E68","v":138}]
[]
[{"$f":"1+A69","v":40},null,"TOTAL ELECTRIC CURRENT INCOME TAXES",null,{"$f":"E53+E61+E69","v":94292}]
[]
[null,null,"DEFERRED INCOME TAXES:"]
[{"$f":"1+A71","v":41},null,"     DEFERRED INCOME TAX EXPENSE",null,{"$f":"+E15","v":-84756}]
[{"$f":"1+A74","v":42},null,"     I.T.C. AMORTIZATION",null,{"$f":"+E16","v":-4125}]
[{"$f":"1+A75","v":43},null,"TOTAL ELECTRIC DEFERRED INCOME TAX",null,{"$f":"SUM(E74:E75)","v":-88881}]
[]
[{"$f":"1+A76","v":44},null,"TOTAL ELECTRIC CURRENT & DEFERRED INCOME TAX",null,{"$f":"+E71+E76","v":5411}]
[]
[]
[{"$f":"1+A78","v":45},null,"(1)  RATE BASE X EMBEDDED"]
[{"$f":"1+A81","v":46},null,"       COST OF DEBT.",{"$f":"[1]CostofCap!$I$12+[1]CostofCap!$I$14","v":1.8610000000000002E-2}]

{"sheet":"SCHEDULE MJL-D12-2","index":14,"n_rows":85,"n_cols":5,"rows_kept":85,"cut":false,"hidden":false,"merged":[[54,2,55,2],[51,2,52,2],[0,0,0,4],[1,0,1,4],[2,0,2,4],[3,0,3,4],[10,2,12,2]]}
["AMEREN MISSOURI"]
["ELECTRIC DEPRECIATION & AMORTIZATION EXPENSE PRO FORMA ADJUSTMENTS"]
[{"$f":"'SCHEDULE MJL-D5'!A3","v":"FOR THE TWELVE MONTHS ENDED MARCH 31, 2022"}]
["($000)"]
[]
[]
[null,null,null,null,"PRO FORMA"]
["LINE","ITEM NO.","DESCRIPTION",null,"ADJUSTMENTS"]
[null,"(A)","(B)",null,"(C)"]
[]
[1,-1,"To reflect the book depreciation annualized for the plant in service depreciable balances at March 31, 2022 and additions to plant in service from April 2022 through December 2022 to reflect the true-up."]
[{"$f":"1+A11","v":2}]
[{"$f":"1+A12","v":3}]
[]
[{"$f":"1+A13","v":4},null,"Change in Depr. Exp. - Steam",null,{"$f":"ROUND(SUM('[1]Depreciation Pro Forma'!F13)*0.001,0)","v":38090}]
[{"$f":"1+A15","v":5},null,"Change in Depr. Exp. - Nuclear",null,{"$f":"ROUND('[1]Depreciation Pro Forma'!F14*0.001,0)","v":1776}]
[6,null,"Change in Depr. Exp. - Hydro",null,{"$f":"ROUND('[1]Depreciation Pro Forma'!F16*0.001,0)","v":3096}]
[7,null,"Change in Depr. Exp. - Other Prod.",null,{"$f":"ROUND('[1]Depreciation Pro Forma'!F17*0.001,0)","v":-1428}]
[8,null,"Change in Depr. Exp. - Transmission",null,{"$f":"ROUND('[1]Depreciation Pro Forma'!F18*0.001,0)","v":-1233}]
[9,null,"Change in Depr. Exp. - Distribution",null,{"$f":"ROUND('[1]Depreciation Pro Forma'!F19*0.001,0)","v":7375}]
[10,null,"Change in Depr. Exp. - General Plant",null,{"$f":"ROUND('[1]Depreciation Pro Forma'!F20*0.001,0)","v":20679}]
[11,null,"Change in Depr. Exp. - Incentive Comp Capitalized",null,{"$f":"ROUND('[1]Depreciation Pro Forma'!F24*0.001,0)","v":-1823}]
[12,null,"Change in Amor. Exp. - Intangible Plant",null,{"$f":"ROUND('[1]Depreciation Pro Forma'!$F$29*0.001,0)+ROUND('[1]Depreciation Pro Forma'!$F$33*0.001,0)+ROUND('[1]Depreciation Pro Forma'!$F$34*0.001,0)","v":7286}]
[13,null,"Total Increase in Depreciation Expense",null,{"$f":"SUM(E15:E23)","v":73818}]
[]
[{"$f":"1+A24","v":14},-2,"To reflect change in depreciation rates per testimony of Gannett Fleming"]
[]
[{"$f":"1+A26","v":15},null,"Increase in Depr. Exp. - Steam",null,{"$f":"ROUND('[1]Depreciation Pro Forma'!H13*0.001,0)","v":-7502}]
[{"$f":"1+A28","v":16},null,"Increase in Depr. Exp. - Nuclear",null,{"$f":"ROUND('[1]Depreciation Pro Forma'!H14*0.001,0)","v":10704}]
[17,null,"Increase in Depr. Exp. - Hydro",null,{"$f":"ROUND('[1]Depreciation Pro Forma'!H16*0.001,0)","v":354}]
[18,null,"Increase in Depr. Exp. - Other Prod.",null,{"$f":"ROUND('[1]Depreciation Pro Forma'!H17*0.001,0)","v":-1271}]
[19,null,"Increase in Depr. Exp. - Transmission",null,{"$f":"ROUND('[1]Depreciation Pro Forma'!H18*0.001,0)","v":7190}]
[20,null,"Increase in Depr. Exp. - Distribution",null,{"$f":"ROUND('[1]Depreciation Pro Forma'!H19*0.001,0)","v":12324}]
[21,null,"Increase in Depr. Exp. - General Plant",null,{"$f":"ROUND('[1]Depreciation Pro Forma'!H20*0.001,0)","v":2257}]
[22,null,"Increase in Amort. Exp. - Intangible Plant",null,{"$f":"ROUND('[1]Depreciation Pro Forma'!H29*0.001,0)","v":0}]
[23,null,"Total Increase in Depreciation Expense",null,{"$f":"SUM(E28:E35)","v":24056}]
[]
[{"$f":"1+A36","v":24},-3,"To eliminate PISA deferral"]
[{"$f":"1+A38","v":25},null,"Depreciation",null,{"$f":"ROUND(SUM('[1]Depreciation Pro Forma'!F21:F23)*0.001,0)","v":60981}]
[26,null,"Amortization",null,{"$f":"ROUND(SUM('[1]Depreciation Pro Forma'!F35:F38)*0.001,0)","v":32983}]
[27,null,null,null,{"$f":"SUM(E39:E40)","v":93964}]
[]
[{"$f":"1+A41","v":28},-4,"To reduce depreciation expense charged to O&M"]
[]
[{"$f":"1+A43","v":29},null,"Decrease in Depr. Exp. - Steam",null,{"$f":"ROUND('[1]Depreciation Pro Forma'!I13*0.001,0)","v":-108}]
[{"$f":"1+A45","v":30},null,"Decrease in Depr. Exp. - General Plant",null,{"$f":"ROUND('[1]Depreciation Pro Forma'!I20*0.001,0)","v":-12544}]
[{"$f":"1+A46","v":31},null,"Total Decrease in Depreciation Expense",null,{"$f":"SUM(E45:E46)","v":-12652}]
[]
[{"$f":"1+A47","v":32},-5,"To eliminate the amortizations of the Sioux Scrubber Construction Accounting",null,{"$f":"ROUND(SUM('[1]Depreciation Pro Forma'!F46:F49)*0.001,0)","v":1341}]
[{"$f":"1+A49","v":33},null,"contra regulatory assets."]
[]
[{"$f":"1+A50","v":34},-6,"To eliminate the amortization relating to expiring amortizations combined and netted at Adjustment 10.",null,{"$f":"ROUND(SUM('[1]Depreciation Pro Forma'!F52)*0.001,0)","v":519}]
[{"$f":"1+A52","v":35}]
[]
[{"$f":"1+A53","v":36},-7,"To eliminate the amortizations and deferrals made under the MEEIA Rider, including MEEIA ordered adjustments",null,{"$f":"ROUND(SUM('[1]Depreciation Pro Forma'!F62:F65)*0.001,0)+ROUND('[1]Depreciation Pro Forma'!F83*0.001,0)+2","v":-17438}]
[{"$f":"1+A55","v":37}]
[]
[{"$f":"1+A56","v":38},-8,"To reflect amortization of Customer Affordability Best Practices McKinsey",null,{"$f":"ROUND('[1]Depreciation Pro Forma'!F56*0.001,0)","v":1926}]
[]
[{"$f":"1+A58","v":39},-9,"To reflect annualization of amortization of Low Income Surcharge",null,{"$f":"ROUND('[1]Depreciation Pro Forma'!F67*0.001,0)","v":917}]
[]
[{"$f":"1+A60","v":40},-10,"To amortize Extended Regulatory Items",null,{"$f":"ROUND(SUM('[1]Depreciation Pro Forma'!F68:F70)*0.001,0)","v":3345}]
[]
[{"$f":"1+A62","v":41},-11,"To reflect amortization of PISA",null,{"$f":"ROUND(SUM('[1]Depreciation Pro Forma'!F74:F76)*0.001,0)","v":20497}]
[]
[{"$f":"1+A64","v":42},-12,"To elminate accumulation and reflect annualized amortization of Excess Deferred Tracker",null,{"$f":"ROUND(SUM('[1]Depreciation Pro Forma'!F78:F81)*0.001,0)","v":-10829}]
[]
[{"$f":"1+A66","v":43},-13,"To eliminate RESRAM activity",null,{"$f":"ROUND(SUM('[1]Depreciation Pro Forma'!F84:F91)*0.001,0)","v":-5475}]
[]
[{"$f":"1+A68","v":44},-14,"To reflect Charge Ahead Corridor amortization",null,{"$f":"ROUND(SUM('[1]Depreciation Pro Forma'!F92:F93)*0.001,0)","v":953}]
[]
[{"$f":"1+A70","v":45},-15,"To reflect amortization FERC ROE Case",null,{"$f":"ROUND(SUM('[1]Depreciation Pro Forma'!F95)*0.001,0)","v":-760}]
[]
[{"$f":"1+A72","v":46},-16,"To reflect COVID AAO amortization",null,{"$f":"ROUND('[1]Depreciation Pro Forma'!F102*0.001,0)+ROUND('[1]Depreciation Pro Forma'!$F$103*0.001,0)","v":1181}]
[]
[{"$f":"1+A74","v":47},-17,"To elminate accumulation and to reflect annualized amortization of Equity Issuance Cost",null,{"$f":"ROUND(SUM('[1]Depreciation Pro Forma'!F98:F99)*0.001,0)","v":1782}]
[]
[{"$f":"1+A76","v":48},-18,"To elminate accumulation and reflect annualized amortization of Meramec Retirement Asset",null,{"$f":"ROUND(SUM('[1]Depreciation Pro Forma'!F100:F101)*0.001,0)","v":17260}]
[]
[{"$f":"1+A78","v":49},-19,"To annaulize amortization of Critical Needs Low Income Program",null,{"$f":"ROUND('[1]Depreciation Pro Forma'!F104*0.001,0)","v":229}]
[]
[{"$f":"1+A80","v":50},-20,"To annualize amortization of Rehousing Pilot Low Income Program",null,{"$f":"ROUND('[1]Depreciation Pro Forma'!F105*0.001,0)","v":229}]
[]
[]
[{"$f":"1+A82","v":51},"TOTAL PRO FORMA ADJUSTMENTS: DEPRECIATION & AMORTIZATION",null,null,{"$f":"SUM(E24,E36,E41,E47:E83)","v":194863}]

{"sheet":"SCHEDULE MJL-D13-1","index":15,"n_rows":46,"n_cols":7,"rows_kept":46,"cut":false,"hidden":false,"merged":[[0,1,0,6],[1,1,1,6],[2,1,2,6],[3,1,3,6]]}
[null,"AMEREN MISSOURI"]
[null,"TAXES OTHER THAN INCOME TAXES"]
[null,{"$f":"'SCHEDULE MJL-D5'!A3","v":"FOR THE TWELVE MONTHS ENDED MARCH 31, 2022"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"($000)"]
[]
[null,null,null,null,"TOTAL",null,"PRO FORMA"]
[null,null,null,null,"PER","PRO FORMA","ELECTRIC"]
[null,"LINE ","DESCRIPTION",null,"BOOKS","ADJUSTMENTS(1)","TOTALS"]
[null,null,"(A)",null,"(B)","(C)","(D)"]
[]
[null,null,"PAYROLL TAXES"]
[null,1,"   F.I.C.A.",165021,{"$f":"ROUND([1]OtherTax!C10*0.001,0)","v":20089},{"$f":"ROUND(SUM([1]OtherTax!D10:H10)*0.001,0)","v":997},{"$f":"E12+F12","v":21086}]
[null,{"$f":"1+B12","v":2},"   FEDERAL UNEMPLOYMENT",null,{"$f":"ROUND([1]OtherTax!C11*0.001,0)","v":180},{"$f":"ROUND(SUM([1]OtherTax!D11:H11)*0.001,0)","v":0},{"$f":"E13+F13","v":180}]
[null,{"$f":"1+B13","v":3},"   MISSOURI UNEMPLOYMENT",null,{"$f":"ROUND([1]OtherTax!C12*0.001,0)","v":-2},{"$f":"ROUND(SUM([1]OtherTax!D12:H12)*0.001,0)","v":0},{"$f":"E14+F14","v":-2}]
[null,{"$f":"1+B14","v":4},"   ILLINOIS UNEMPLOYMENT",null,{"$f":"ROUND([1]OtherTax!C13*0.001,0)","v":39},{"$f":"ROUND(SUM([1]OtherTax!D13:H13)*0.001,0)","v":0},39]
[null,{"$f":"1+B15","v":5},"   IOWA UNEMPLOYMENT",null,{"$f":"ROUND([1]OtherTax!C14*0.001,0)+1","v":6},{"$f":"ROUND(SUM([1]OtherTax!D14:H14)*0.001,0)","v":0},6]
[null,{"$f":"1+B16","v":6},"   OTHER STATES UNEMPLOYMENT",null,{"$f":"ROUND([1]OtherTax!C15*0.001,0)","v":0},{"$f":"ROUND(SUM([1]OtherTax!D15:H15)*0.001,0)","v":0},0]
[null,{"$f":"1+B17","v":7},"   ST. LOUIS EMPLOYMENT TAX",null,{"$f":"ROUND([1]OtherTax!C16*0.001,0)","v":449},{"$f":"ROUND(SUM([1]OtherTax!D16:H16)*0.001,0)","v":0},449]
[null,{"$f":"1+B18","v":8},"      TOTAL PAYROLL TAXES",null,{"$f":"SUM(E12:E18)","v":20761},{"$f":"SUM(F12:F18)","v":997},{"$f":"SUM(G12:G18)","v":21758}]
[]
[null,null,"R.E., P.P. & CORP FRANCHISE"]
[null,{"$f":"1+B19","v":9},"   MISSOURI R.E., & P.P.",685910,{"$f":"ROUND([1]OtherTax!C20*0.001,0)","v":167555},{"$f":"ROUND(SUM([1]OtherTax!D20:H20)*0.001,0)","v":3230},{"$f":"SUM(E22:F22)","v":170785}]
[null,{"$f":"1+B22","v":10},"   ILLINOIS R.E., & P.P.",null,{"$f":"ROUND([1]OtherTax!C21*0.001,0)","v":3999},{"$f":"ROUND(SUM([1]OtherTax!D21:H21)*0.001,0)","v":72},4071]
[null,11,"   IOWA  R.E., & P.P.",null,{"$f":"ROUND([1]OtherTax!C22*0.001,0)","v":1457},{"$f":"ROUND(SUM([1]OtherTax!D22:H22)*0.001,0)","v":13},1470]
[null,12,"   OTHER STATES R.E. & P.P.",null,{"$f":"ROUND([1]OtherTax!C23*0.001,0)","v":25},{"$f":"ROUND(SUM([1]OtherTax!D23:H23)*0.001,0)","v":8},33]
[null,13,"   R.E. TAXES CAPITALIZED",null,{"$f":"ROUND([1]OtherTax!C24*0.001,0)","v":-4044},{"$f":"ROUND(SUM([1]OtherTax!D24:H24)*0.001,0)","v":0},-4044]
[null,14,"   TRANSFER TO GAS",762523,{"$f":"ROUND([1]OtherTax!C25*0.001,0)","v":-189},{"$f":"ROUND(SUM([1]OtherTax!D25:H25)*0.001,0)","v":0},-189]
[null,15,"   TRANSFER TO NON UTILITY",null,{"$f":"ROUND([1]OtherTax!C26*0.001,0)","v":-85},{"$f":"ROUND(SUM([1]OtherTax!D26:H26)*0.001,0)","v":0},-85]
[null,{"$f":"1+B28","v":16},"      TOTAL R.E., P.P. & CORP FRANCHISE",{"$f":"SUM(D22:D27)","v":1448433},{"$f":"SUM(E22:E28)","v":168718},{"$f":"SUM(F22:F28)","v":3323},172041]
[]
[null,{"$f":"1+B29","v":17},"MUNICIPAL GROSS RECEIPTS",null,{"$f":"ROUND([1]OtherTax!C29*0.001,0)","v":145597},{"$f":"ROUND(SUM([1]OtherTax!D29:H29)*0.001,0)","v":-145597},{"$f":"SUM(E31:F31)","v":0}]
[]
[null,null,"MISCELLANEOUS"]
[null,{"$f":"1+B31","v":18},"   MISSOURI CORP FRANCHISE",null,{"$f":"ROUND([1]OtherTax!C32*0.001,0)","v":0},{"$f":"ROUND(SUM([1]OtherTax!D32:H32)*0.001,0)","v":0},{"$f":"E34+F34","v":0}]
[null,{"$f":"1+B34","v":19},"   ILLINOIS CORP FRANCHISE",null,{"$f":"ROUND([1]OtherTax!C33*0.001,0)","v":136},{"$f":"ROUND(SUM([1]OtherTax!D33:H33)*0.001,0)","v":0},{"$f":"E35+F35","v":136}]
[null,20,"   IOWA CORP FRANCHISE",null,{"$f":"ROUND([1]OtherTax!C34*0.001,0)","v":0},{"$f":"ROUND(SUM([1]OtherTax!D34:H34)*0.001,0)","v":0}]
[null,21,"   FED. EXCISE TAX-HEAVY VEH. USE TAX",null,{"$f":"ROUND([1]OtherTax!C35*0.001,0)","v":24},{"$f":"ROUND(SUM([1]OtherTax!D35:H35)*0.001,0)","v":0},{"$f":"E37+F37","v":24}]
[null,22,"   ST. LOUIS EARNINGS",null,{"$f":"ROUND([1]OtherTax!C36*0.001,0)","v":0},{"$f":"ROUND(SUM([1]OtherTax!D36:H36)*0.001,0)","v":0}]
[null,23,"   MO. EXCISE - NEIL INS. PREM.",107,{"$f":"ROUND([1]OtherTax!C37*0.001,0)","v":0},{"$f":"ROUND(SUM([1]OtherTax!D37:H37)*0.001,0)","v":0},{"$f":"E39+F39","v":0}]
[null,24,"   MISCELLANEOUS",null,{"$f":"ROUND([1]OtherTax!C38*0.001,0)","v":113},{"$f":"ROUND(SUM([1]OtherTax!D38:H38)*0.001,0)","v":0},{"$f":"E40+F40","v":113}]
[null,25,"      TOTAL MISCELLANEOUS",null,{"$f":"SUM(E34:E40)","v":273},{"$f":"SUM(F34:F40)","v":0},{"$f":"SUM(G34:G40)","v":273}]
[]
[]
[null,{"$f":"1+B41","v":26},"TOTAL TAXES OTHER THAN INCOME TAXES",null,{"$f":"E19+E29+E31+E41","v":335349},{"$f":"F19+F29+F31+F41","v":-141277},{"$f":"G19+G29+G31+G41","v":194072}]
[]
[null,{"$f":"1+B44","v":27},"(1) See SCHEDULE MJL-D13-2 for explanation of the pro forma adjustments."]

{"sheet":"SCHEDULE MJL-D13-2","index":16,"n_rows":20,"n_cols":11,"rows_kept":20,"cut":false,"hidden":false,"merged":[[8,2,8,8],[10,2,10,8],[14,2,15,8],[17,2,17,8],[0,0,0,10],[1,0,1,10],[2,0,2,10],[3,0,3,10],[4,0,4,10],[7,2,7,8],[12,2,12,8]]}
["AMEREN MISSOURI"]
["TAXES OTHER THAN INCOME"]
["PRO FORMA ADJUSTMENTS"]
[{"$f":"'SCHEDULE MJL-D5'!A3","v":"FOR THE TWELVE MONTHS ENDED MARCH 31, 2022"}]
["($000)"]
[]
[null,null,null,null,null,null,null,null,null,null,"PRO FORMA"]
["LINE","ITEM NO.","DESCRIPTION",null,null,null,null,null,null,null,"AMOUNT"]
[null,"(A)","(B)",null,null,null,null,null,null,null,"(C)"]
[]
[1,-1,"Increase F.I.C.A. taxes to reflect the pro forma wage adjustments.",null,null,null,null,null,null,null,{"$f":"ROUND([1]OtherTax!$D$10*0.001,0)","v":997}]
[]
[2,-2,"Property tax true-up adjustment.",null,null,null,null,null,null,null,{"$f":"ROUND(SUM([1]OtherTax!E20:E26)*0.001,0)","v":3625}]
[]
[3,-3,"Eliminate the property taxes on future use plant, as this investment is excluded from rate base.",null,null,null,null,null,null,null,{"$f":"ROUND([1]OtherTax!$F$20*0.001,0)","v":-302}]
[{"$f":"1+A15","v":4}]
[]
[{"$f":"1+A16","v":5},-4,"Eliminate the gross receipts tax as they are a pass through tax.",null,null,null,null,null,null,null,{"$f":"ROUND([1]OtherTax!$G$29*0.001,0)","v":-145597}]
[]
[{"$f":"1+A18","v":6},null,"Total Pro Forma Adjustments to Taxes Other Than Income",null,null,null,null,null,null,null,{"$f":"SUM(K10:K19)","v":-141277}]

{"sheet":"SCHEDULE MJL-D15","index":17,"n_rows":63,"n_cols":6,"rows_kept":63,"cut":false,"hidden":false,"merged":[[3,1,3,5],[0,1,0,5],[1,1,1,5],[2,1,2,5]]}
[null,"AMEREN MISSOURI"]
[null,"TOTAL ELECTRIC NET ORIGINAL COST RATE BASE AND REVENUE REQUIREMENT"]
[null,{"$f":" 'SCHEDULE MJL-D5'!A3","v":"FOR THE TWELVE MONTHS ENDED MARCH 31, 2022"}]
[null,"($000)"]
[]
[null,null,null,null,null,"TOTAL"]
[null,null,null,null,null,"ELECTRIC"]
[null,"LINE","DESCRIPTION","REFERENCE",null,"AMOUNT"]
[null,null,"(A)","(B)",null,"(C)"]
[]
[null,null,"A. TOTAL ELECTRIC NET ORIGINAL COST RATE BASE"]
[]
[null,1,"ORIGINAL COST OF PLANT IN SERVICE","SCHEDULE MJL-D1",null,{"$f":"+'SCHEDULE MJL-D1'!G34","v":22883458}]
[null,{"$f":"1+B13","v":2},"LESS: RESERVES FOR DEPRECIATION & AMORTIZATION","SCHEDULE MJL-D2",null,{"$f":"+'SCHEDULE MJL-D2'!G34","v":9221601}]
[null,{"$f":"1+B14","v":3},"     NET ORIGINAL COST OF PLANT",null,null,{"$f":"F13-F14","v":13661857}]
[null,4,"AVERAGE FUEL AND MATERIALS AND SUPPLIES","SCHEDULE MJL-D3",null,{"$f":"+'SCHEDULE MJL-D3'!F23","v":567950}]
[null,5,"AVERAGE PREPAYMENTS","SCHEDULE MJL-D4",null,{"$f":"+'SCHEDULE MJL-D4'!G24","v":16327}]
[null,6,"CASH WORKING CAPITAL (LEAD/LAG)","SCHEDULE MJL-D5",null,{"$f":"'SCHEDULE MJL-D5'!J47","v":-15778}]
[null,7,"FEDERAL INCOME TAX CASH REQUIREMENT","SCHEDULE MJL-D6",null,{"$f":"'SCHEDULE MJL-D6'!J14","v":-189}]
[null,8,"STATE INCOME TAX CASH REQUIREMENT","SCHEDULE MJL-D6",null,{"$f":"'SCHEDULE MJL-D6'!J16","v":-64}]
[null,9,"CITY EARNINGS TAX CASH REQUIREMENT","SCHEDULE MJL-D6",null,{"$f":"'SCHEDULE MJL-D6'!J22","v":-89}]
[null,{"$f":"1+B21","v":10},"INTEREST EXPENSE CASH REQUIREMENT","SCHEDULE MJL-D6",null,{"$f":"'SCHEDULE MJL-D6'!J24","v":-32161}]
[null,{"$f":"1+B22","v":11},"INDIANA STATE TAX OFFSET","SCHEDULE MJL-D6",null,{"$f":"'SCHEDULE MJL-D6'!J18","v":0}]
[null,{"$f":"1+B23","v":12},"IOWA STATE TAX OFFSET","SCHEDULE MJL-D6",null,{"$f":"'SCHEDULE MJL-D6'!J20","v":0}]
[null,{"$f":"1+B24","v":13},"AVERAGE CUSTOMER ADVANCES FOR CONSTRUCTION","SCHEDULE MJL-D7",null,{"$f":"'SCHEDULE MJL-D7'!E13","v":-546}]
[null,14,"AVERAGE CUSTOMER DEPOSITS","SCHEDULE MJL-D7",null,{"$f":"'SCHEDULE MJL-D7'!E16","v":-18816}]
[null,{"$f":"1+B26","v":15},"PENSION TRACKER REG ASSET","SCHEDULE MJL-D8",null,{"$f":"+'SCHEDULE MJL-D8'!H15","v":-29516}]
[null,{"$f":"1+B27","v":16},"OPEB TRACKER REG  LIABILITY","SCHEDULE MJL-D8",null,{"$f":"+'SCHEDULE MJL-D8'!H18","v":-10163}]
[null,{"$f":"1+B28","v":17},"PAYS REGULATORY ASSET","SCHEDULE MJL-D8",null,{"$f":"+'SCHEDULE MJL-D8'!H21","v":1861}]
[null,{"$f":"1+B29","v":18},"PISA REGULATORY ASSET","SCHEDULE MJL-D8",null,{"$f":"+'SCHEDULE MJL-D8'!H24","v":394572}]
[null,19,"MERAMEC REGULATORY ASSET","SCHEDULE MJL-D8",null,{"$f":"'SCHEDULE MJL-D8'!H27","v":38581}]
[null,20,"UNDER COLLECT AMORTIZATIONS IN RATE BASE","SCHEDULE MJL-D8",null,{"$f":"+'SCHEDULE MJL-D8'!H30","v":161}]
[null,{"$f":"1+B32","v":21},"ACCUMULATED DEFERRED INCOME TAXES ","SCHEDULE MJL-D9",null,{"$f":"+'SCHEDULE MJL-D9'!H21","v":-2968208}]
[]
[null,{"$f":"1+B33","v":22},"TOTAL ELECTRIC NET ORIGINAL COST RATE BASE",null,null,{"$f":"SUM(F15:F33)","v":11605779}]
[]
[null,null,"B. TOTAL ELECTRIC REVENUE REQUIREMENT"]
[]
[null,null,"TOTAL ELECTRIC OPERATING EXPENSES:"]
[null,{"$f":"1+B35","v":23},"PRODUCTION","SCHEDULE MJL-11-1",null,{"$f":"+'SCHEDULE MJL-D11-1 to 6'!BY22","v":1240902}]
[null,{"$f":"1+B40","v":24},"TRANSMISSION","SCHEDULE MJL-11-1",null,{"$f":"+'SCHEDULE MJL-D11-1 to 6'!BY27","v":112941}]
[null,{"$f":"1+B41","v":25},"REGIONAL MARKET EXPENSES","SCHEDULE MJL-11-1",null,{"$f":"+'SCHEDULE MJL-D11-1 to 6'!BY32","v":6924}]
[null,{"$f":"1+B42","v":26},"DISTRIBUTION","SCHEDULE MJL-11-1",null,{"$f":"+'SCHEDULE MJL-D11-1 to 6'!BY37","v":150410}]
[null,27,"CUSTOMER ACCOUNTS","SCHEDULE MJL-11-1",null,{"$f":"+'SCHEDULE MJL-D11-1 to 6'!BY42","v":54222}]
[null,28,"CUSTOMER SERVICE","SCHEDULE MJL-11-1",null,{"$f":"+'SCHEDULE MJL-D11-1 to 6'!BY47","v":15215.5}]
[null,29,"SALES","SCHEDULE MJL-11-1",null,{"$f":"+'SCHEDULE MJL-D11-1 to 6'!BY52","v":491}]
[null,30,"ADMINISTRATIVE AND GENERAL","SCHEDULE MJL-11-1",null,{"$f":"+'SCHEDULE MJL-D11-1 to 6'!BY57","v":165115}]
[null,31,"   TOTAL ELECTRIC OPERATING EXPENSES",null,null,{"$f":"SUM(F40:F47)","v":1746220.5}]
[null,32,"DEPRECIATION AND AMORTIZATION","SCHEDULE MJL-12-1",null,{"$f":"'SCHEDULE MJL-D12-1'!F56","v":847997}]
[null,33,"TAXES OTHER THAN INCOME TAXES","SCHEDULE MJL-13-1",null,{"$f":"'SCHEDULE MJL-D13-1'!G44","v":194072}]
[null,null,"INCOME TAXES-BASED ON PROPOSED RATE OF RETURN"]
[null,{"$f":"1+B50","v":34},"  FEDERAL","SCHEDULE MJL-14",null,{"$f":"'SCHEDULE MJL-D14'!E53","v":70243}]
[null,{"$f":"1+B52","v":35},"  STATE","SCHEDULE MJL-14",null,{"$f":"'SCHEDULE MJL-D14'!E61","v":23911}]
[null,{"$f":"1+B53","v":36},"  CITY EARNINGS ","SCHEDULE MJL-14",null,{"$f":"'SCHEDULE MJL-D14'!E69","v":138}]
[null,{"$f":"1+B54","v":37},"TOTAL INCOME TAXES",null,null,{"$f":"SUM(F52:F54)","v":94292}]
[null,null,"DEFERRED INCOME TAXES",null,{"$f":"+ROUND('[1]Depreciation Pro Forma'!$J$20*0.001,0)+ROUND('[1]Depreciation Pro Forma'!$J$21*0.001,0)","v":0}]
[null,{"$f":"1+B55","v":38},"     DEFERRED INCOME TAX EXPENSE","SCHEDULE MJL-14",null,{"$f":"'SCHEDULE MJL-D14'!E74","v":-84756}]
[null,{"$f":"1+B57","v":39},"     I.T.C. AMORTIZATION","SCHEDULE MJL-14",null,{"$f":"'SCHEDULE MJL-D14'!E75","v":-4125}]
[null,{"$f":"1+B58","v":40},"TOTAL DEFERRED INCOME TAXES",null,null,{"$f":"SUM(F57:F58)","v":-88881}]
[]
[null,{"$f":"1+B59","v":41},{"$f":"\"RETURN (RATE BASE * \"&TEXT(D61,\"0.000%\")&\")\"","v":"RETURN (RATE BASE * 7.186%)"},{"$f":"[1]CostofCap!$I$20","v":7.1860000000000007E-2},null,{"$f":"ROUND(D61*F35,0)","v":833991}]
[]
[null,{"$f":"1+B61","v":42},"TOTAL ELECTRIC REVENUE REQUIREMENT",null,null,{"$f":"+F48+F49+F50+F55+F59+F61","v":3627691.5}]

{"sheet":"SCHEDULE MJL-D16","index":18,"n_rows":30,"n_cols":6,"rows_kept":30,"cut":false,"hidden":false,"merged":[[3,0,3,4],[0,0,0,4],[1,0,1,4],[2,0,2,4]]}
["AMEREN MISSOURI"]
[{"$f":"\"INCREASE REQUIRED TO PRODUCE \"& TEXT('SCHEDULE MJL-D15'!D61,\"0.000%\") &\" RETURN ON \"","v":"INCREASE REQUIRED TO PRODUCE 7.186% RETURN ON "}]
["TOTAL ELECTRIC NET ORIGINAL COST RATE BASE"]
[{"$f":" 'SCHEDULE MJL-D5'!A3","v":"FOR THE TWELVE MONTHS ENDED MARCH 31, 2022"}]
[]
[]
[]
[null,null,null,null,"TOTAL"]
[null,null,null,null,"ELECTRIC"]
["LINE",null,"DESCRIPTION",null,"AMOUNT"]
[null,null,"(A)",null,"(B)"]
[]
[1,null,"TOTAL ELECTRIC NET ORIGINAL COST RATE BASE",null,{"$f":"'SCHEDULE MJL-D15'!F35","v":11605779}]
[]
[null,null,"TOTAL ELECTRIC REVENUE REQUIREMENT:"]
[{"$f":"1+A13","v":2},null,{"$f":"\"RETURN AT PROPOSED RATE (\"&TEXT('SCHEDULE MJL-D15'!D61,\"0.000%\")&\")\"","v":"RETURN AT PROPOSED RATE (7.186%)"},null,{"$f":"'SCHEDULE MJL-D15'!F61","v":833991}]
[{"$f":"1+A16","v":3},null,"OPERATING AND MAINTENANCE EXPENSES",null,{"$f":"'SCHEDULE MJL-D15'!F48","v":1746220.5}]
[4,null,"DEPRECIATION AND AMORTIZATION",null,{"$f":"'SCHEDULE MJL-D15'!F49","v":847997}]
[5,null,"TAXES OTHER THAN INCOME",null,{"$f":"'SCHEDULE MJL-D15'!F50","v":194072}]
[6,null,"FEDERAL AND STATE INCOME AND CITY EARNINGS TAXES AT CLAIMED RETURN",null,{"$f":"'SCHEDULE MJL-D15'!F52+'SCHEDULE MJL-D15'!F53+'SCHEDULE MJL-D15'!F54","v":94292}]
[7,null,"DEFERRED INCOME TAXES",null,{"$f":"'SCHEDULE MJL-D15'!F59","v":-88881}]
[8,null,"TOTAL ELECTRIC REVENUE REQUIREMENT",null,{"$f":"SUM(E16:E21)","v":3627691.5}]
[]
[]
[{"$f":"1+A22","v":9},null,"PRO FORMA TOTAL ELECTRIC OPERATING REVENUE AT PRESENT RATES",null,{"$f":"+'SCHEDULE MJL-D10'!F26","v":3312063}]
[null,null,""]
[{"$f":"1+A25","v":10},null,"DEFICIENCY IN TOTAL ELECTRIC OPERATING REVENUE",null,{"$f":"E22-E25","v":315628.5}]
[]
[]
[null,null,null,null,null,{"$f":"+UPPER(C30)","v":""}]

{"sheet":"SCHEDULE MJL-D17","index":19,"n_rows":90,"n_cols":11,"rows_kept":90,"cut":false,"hidden":false,"merged":[]}
["AMEREN MISSOURI"]
["CALCULATION OF NET BASE ENERGY COST (BF)"]
[{"$f":"'SCHEDULE MJL-D5'!A3","v":"FOR THE TWELVE MONTHS ENDED MARCH 31, 2022"}]
[]
[]
[]
[]
[null,null,null,null,"","",null,null,null,""]
["LINE",null,"DESCRIPTION",null,"TOTAL","","SUMMER",null,"WINTER","","WINTER-2"]
[null,null,"(A)",null,"(B)",null,"(D)",null,"(E)",null,"(F)"]
[]
[null,"A","FUEL & PURCHASED POWER COSTS"]
[null,null,"BASE LOAD"]
[{"$f":"1","v":1},null,"FUEL FOR LOAD",null,{"$f":"G14+I14","v":444586215.78187412},null,{"$f":"SUM('[2]NBEC '!$F$12:$F$14)","v":157569000},null,{"$f":"SUM('[2]NBEC '!$J$12:$J$14)","v":287017215.78187412},null,{"$f":"E14-G14-I14","v":0}]
[{"$f":"1+A14","v":2},null,"FLY ASH (1)",null,{"$f":"G15+I15","v":-2163081.5399999991},null,{"$f":"'[2]NBEC '!$F$15","v":-749679},null,{"$f":"'[2]NBEC '!$J$15","v":-1413402.5399999991},null,0]
[{"$f":"1+A15","v":3},null,"FIXED GAS SUPPLY COSTS FOR LOAD (2)",null,{"$f":"G16+I16","v":7936238.8900000006},null,{"$f":"'[2]NBEC '!$F$17","v":2848884},null,{"$f":"'[2]NBEC '!$J$17","v":5087354.8900000006},null,0]
[4,null,"FUEL ADDITIVES (2)",null,{"$f":"G17+I17","v":5598255.1142942701},null,{"$f":"'[2]NBEC '!$F$16","v":2009614},null,{"$f":"'[2]NBEC '!$J$16","v":3588641.1142942701},null,0]
[5,null,"PURCHASED POWER FOR LOAD",null,{"$f":"G18+I18","v":50363269.308219999},null,{"$f":"'[2]NBEC '!$F$18","v":15792000},null,{"$f":"'[2]NBEC '!$J$18","v":34571269.308219999},null,0]
[null,null,""]
[{"$f":"1+A18","v":6},null,"TOTAL BASE LOAD",null,{"$f":"SUM(E14:E18)","v":506320897.5543884},null,{"$f":"SUM(G14:G18)","v":177469819},null,{"$f":"SUM(I14:I18)","v":328851078.5543884},null,{"$f":"SUM(K14:K18)","v":0}]
[]
[null,null,"OSS"]
[7,null,"FUEL FOR LOAD",null,{"$f":"G23+I23","v":127476232.53269699},null,{"$f":"SUM('[2]NBEC '!$F$22:$F$24)","v":53008000},null,{"$f":"SUM('[2]NBEC '!$J$22:$J$24)","v":74468232.532696992}]
[8,null,"FLY ASH (1)",null,{"$f":"G24+I24","v":-620220},null,{"$f":"'[2]NBEC '!$F$25","v":-214955},null,{"$f":"'[2]NBEC '!$J$25","v":-405265}]
[9,null,"FIXED GAS SUPPLY COSTS FOR LOAD (2)",null,{"$f":"G25+I25","v":2275558},null,{"$f":"'[2]NBEC '!$F$27","v":816861},null,{"$f":"'[2]NBEC '!$J$27","v":1458697}]
[10,null,"FUEL ADDITIVES (2)",null,{"$f":"G26+I26","v":1605188},null,{"$f":"'[2]NBEC '!$F$26","v":576217},null,{"$f":"'[2]NBEC '!$J$26","v":1028971}]
[11,null,"PURCHASED POWER FOR LOAD",null,{"$f":"G27+I27","v":0},null,{"$f":"'[2]NBEC '!$F$28","v":0},null,{"$f":"'[2]NBEC '!$J$28","v":0}]
[]
[12,null,"TOTAL OSS",null,{"$f":"SUM(E23:E27)","v":130736758.53269699},null,{"$f":"SUM(G23:G27)","v":54186123},null,{"$f":"SUM(I23:I27)","v":76550635.532696992}]
[]
[13,null,"TOTAL FUEL AND PURCHASED POWER",null,{"$f":"E20+E29","v":637057656.08708537},null,{"$f":"G20+G29","v":231655942},null,{"$f":"I20+I29","v":405401714.08708537}]
[]
[]
[null,"B","TRANSMISSION COSTS AND REVENUES"]
[14,null,"TRANSMISSION BY OTHERS (ACCT. 565 @1.65%) (2)",null,{"$f":"G35+I35","v":3697834.8927183794},null,{"$f":"'[2]NBEC '!$F$34","v":1327523},null,{"$f":"'[2]NBEC '!$J$34","v":2370311.8927183794}]
[15,null,"TRANMISSION REVENUES  (ACC 456.1) (2)",null,{"$f":"G36+I36","v":-1474670.6625304276},null,{"$f":"'[2]NBEC '!$F$35","v":-529407},null,{"$f":"'[2]NBEC '!$J$35","v":-945263.66253042757}]
[]
[16,null,"TOTAL TRANSMISSION COSTS AND REVENUES",null,{"$f":"SUM(E35:E36)","v":2223164.2301879516},null,{"$f":"SUM(G35:G36)","v":798116},null,{"$f":"SUM(I35:I36)","v":1425048.2301879518}]
[]
[]
[null,"C","ADDITIONAL FUEL & PP COSTS "]
[17,null,"MISO DAY 2 EXCLUDING ADMIN (ACCT 555) (2)",null,{"$f":"G42+I42","v":15283072.830000002},null,{"$f":"'[2]NBEC '!$F$39","v":5486189},null,{"$f":"'[2]NBEC '!$J$39","v":9796883.8300000019},null,{"$f":"E42-G42-I42","v":0}]
[18,null,"COMMON BOUNDARY (2)",null,173045.09,null,{"$f":"'[2]NBEC '!$F$40","v":62118},null,{"$f":"'[2]NBEC '!$J$40","v":110927.09}]
[19,null,"CAPACITY EXPENSE (2)",null,218593605,null,{"$f":"'[2]NBEC '!$F$41","v":78468891},null,{"$f":"'[2]NBEC '!$J$41","v":140124714},null,{"$f":"E44-G44-I44","v":0}]
[20,null,"ANCILLARY SERVICES PURCHASED  (ACCT. 555) (2)",null,3792292.9899999998,null,{"$f":"'[2]NBEC '!$F$42","v":1361433},null,{"$f":"'[2]NBEC '!$J$42","v":2430859.9899999998},null,0]
[21,null,"PJM EXCLUDING ADMIN (ACCT. 555) (2)",null,0,null,{"$f":"'[2]NBEC '!$F$43","v":0},null,{"$f":"'[2]NBEC '!$J$43","v":0},null,0]
[22,null,"REPLACEMENT POWER INSURANCE (ACC 925) (2)",null,687759.72,null,{"$f":"'[2]NBEC '!$F$44","v":246906},null,{"$f":"'[2]NBEC '!$J$44","v":440853.72}]
[null,null,null,""]
[23,null,"TOTAL ADDITIONAL FUEL & PP COSTS",null,{"$f":"SUM(E42:E47)","v":238529775.63000003},null,{"$f":"SUM(G42:G47)","v":85625537},null,{"$f":"SUM(I42:I47)","v":152904238.63000003},null,{"$f":"SUM(K42:K46)","v":0}]
[]
[null,null,""]
[null,"D","SALES"]
[{"$f":"1+A49","v":24},null,"OFF-SYSTEM ENERGY SALES  REVENUES (ACCT. 447)",null,{"$f":"G53+I53","v":189830535.328343},null,{"$f":"'[2]NBEC '!$F$50","v":60993000},null,{"$f":"'[2]NBEC '!$J$50","v":128837535.328343},null,{"$f":"E53-G53-I53","v":0}]
[{"$f":"1+A53","v":25},null,"MAKE WHOLE PAYMENT MARGINS (ACCT 447)  (2)",null,{"$f":"G54+I54","v":2666247},null,{"$f":"'[2]NBEC '!$F$51","v":957107},null,{"$f":"'[2]NBEC '!$J$51","v":1709140},null,0]
[{"$f":"1+A54","v":26},null,"CAPACITY SALES  REVENUES (ACCT. 447) (2)",null,228379369,null,{"$f":"'[2]NBEC '!$F$52","v":81981702},null,{"$f":"'[2]NBEC '!$J$52","v":146397667},null,0]
[{"$f":"1+A55","v":27},null,"BILATERAL ENERGY SALES MARGINS (447) (2)",null,0,null,{"$f":"'[2]NBEC '!$F$53","v":0},null,{"$f":"'[2]NBEC '!$J$53","v":0}]
[{"$f":"1+A56","v":28},null,"FINANCIAL SWAPS (ACCT 447) (2)",null,0,null,{"$f":"'[2]NBEC '!$F$54","v":0},null,{"$f":"'[2]NBEC '!$J$54","v":0},null,0]
[{"$f":"1+A57","v":29},null,"ANCILLARY SERVICES REVENUE (ACCT. 447) (2)",null,6813374.1400000006,null,{"$f":"'[2]NBEC '!$F$55","v":2445808},null,{"$f":"'[2]NBEC '!$J$55","v":4367566.1400000006},null,0]
[null,null,""]
[{"$f":"A58+1","v":30},null,"TOTAL SALES",null,{"$f":"SUM(E53:E59)","v":427689525.46834302},null,{"$f":"SUM(G53:G59)","v":146377617},null,{"$f":"SUM(I53:I59)","v":281311908.46834302},null,{"$f":"SUM(K53:K59)","v":0}]
[]
[null,"E","OTHER ADJUSTMENTS"]
[{"$f":"A60+1","v":31},null,"REAL-TIME LOAD AND GENERATION DEVIATION (2)",null,{"$f":"G63+I63","v":7674509},null,{"$f":"'[2]NBEC '!$F$59","v":2754931},null,{"$f":"'[2]NBEC '!$J$59","v":4919578}]
[]
[{"$f":"A63+1","v":32},null,"TOTAL OTHER ADJUSTMENTS",null,{"$f":"E63","v":7674509},null,{"$f":"G63","v":2754931},null,{"$f":"I63","v":4919578}]
[null,null,""]
[{"$f":"A65+1","v":33},"A + B + C - D - E","NET BASE ENERGY COSTS",null,{"$f":"E31+E38+E49-E60-E65","v":442446561.47893023},null,{"$f":"G31+G38+G49-G60-G65","v":168947047},null,{"$f":"I31+I38+I49-I60-I65","v":273499514.47893035},null,{"$f":"K20+K49-K60","v":0}]
[null,null,""]
[null,null,"LOAD FORECAST (DELIVERED MWH) USED IN PROSYM RUN",null,{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}}]
[null,null,""]
[null,null,"NET BASE FUEL COSTS ($ PER MWH)",null,{"$f":"E67*1000/E69","v":{"$error":"#REF!"}}]
[null,null,""]
[null,null,""]
[null,null,"LOAD FORECAST AT GENERATION LEVEL*",null,{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}}]
[null,null,"* EXCLUDES TRANSMISSION LINE LOSSES"]
[null,null,""]
[null,null,"NET BASE FUEL COSTS ($ PER MWH) AT GENERATION LEVEL",null,{"$f":"+E67*1000/E74","v":{"$error":"#REF!"}}]
[null,null,""]
[{"$f":"1+A67","v":34},null,"LOAD AT MISO CP NODE AMMO.UE (KWH)",null,{"$f":"G79+I79","v":32510188373.988998},null,{"$f":"'[2]NBEC '!$F$68","v":11670000000},null,{"$f":"'[2]NBEC '!$J$68","v":20840188373.988998},null,{"$f":"E79-G79-I79","v":0}]
[null,null,""]
[{"$f":"1+A79","v":35},null,"BASE FACTOR (BF) ($ PER MWH)",null,{"$f":"E67/E79*1000","v":13.609473940573237},null,{"$f":"G67/G79*1000","v":14.477039160239931},null,{"$f":"I67/I79*1000","v":13.123658460798266},null,{"$f":"K67/K79*1000","v":{"$error":"#DIV/0!"}}]
[null,null,""]
[{"$f":"1+A81","v":36},null,"BASE FACTOR (BF) (CENTS PER KWH)",null,{"$f":"E81/10","v":1.3609473940573236},null,{"$f":"G81/10","v":1.4477039160239931},null,{"$f":"I81/10","v":1.3123658460798266},null,{"$f":"K81/10","v":{"$error":"#DIV/0!"}}]
[]
[{"$f":"1+A83","v":37},"MONTHS IN EACH PERIOD:"]
[{"$f":"1+A85","v":38},null,"SUMMER: JUNE THROUGH SEPTEMBER"]
[39,null,"WINTER: OCTOBER THROUGH MAY"]
[]
[{"$f":"A87+1","v":40},-1,"ALLOCATED BETWEEN SUMMER AND WINTERS BASED ON COAL FROM FUEL MODEL."]
[{"$f":"1+A89","v":41},-2,"ALLOCATED BETWEEN SUMMER AND WINTERS BASED ON LOAD."]

{"sheet":"SCHEDULE MJL-D18","index":20,"n_rows":35,"n_cols":11,"rows_kept":35,"cut":false,"hidden":false,"merged":[[0,0,0,10],[1,0,1,10]]}
["Ameren Missouri Electric Rate Case"]
["Cash Working Capital Requirement"]
[]
[]
["Line No.",null,"Description",null,"Revenue Lag",null,"Expense Lead",null,"Net Lag",null,"CWC Factor"]
[" ",null,"(A)",null,"(B)",null,"(C)",null,"(D)",null,"(E)"]
[]
[1,null,"Pensions & Benefits",null,37.020000000000003,null,-15.7,null,{"$f":"E8+G8","v":21.320000000000004},null,{"$f":"I8/365","v":5.8410958904109599E-2}]
[{"$f":"A8+1","v":2},null,"Employee Benefits (Group Health & 401k)",null,37.020000000000003,null,-17.649999999999999,null,19.370000000000005,null,{"$f":"I9/365","v":5.3068493150684945E-2}]
[{"$f":"A9+1","v":3},null,"Payroll and Withholdings",null,37.020000000000003,null,-10.9,null,26.120000000000005,null,{"$f":"I10/365","v":7.1561643835616445E-2}]
[4,null,"Payroll Taxes",null,37.020000000000003,null,-9.3785215167225466,null,27.641478483277456,null,7.5730078036376589E-2]
[5,null,"Other Operations and Maintenance Expenses",null,37.020000000000003,null,-42.250370548239815,null,-5.2303705482398115,null,-1.432978232394469E-2]
[6,null,"Property/Real Estate Taxes",null,37.020000000000003,null,-183,null,-145.97999999999999,null,-0.399945205479452]
[7,null,"Missouri Sales Tax",null,37.020000000000003,null,-9.312952732948057,null,27.707047267051948,null,7.5909718539868345E-2]
[8,null,"Missouri and Iowa Use Tax",null,37.020000000000003,null,-76.247944202578992,null,-39.227944202578989,null,-0.10747381973309313]
[9,null,"Illinois Use Tax",null,37.020000000000003,null,-35.78168930209273,null,{"$f":"E16+G16","v":1.2383106979072735},null,{"$f":"I16/365","v":3.3926320490610235E-3}]
[10,null,"Gross Receipts Taxes",null,24.27,null,-26.985801752714565,null,-2.7158017527145653,null,-7.4405527471631929E-3]
[11,null,"Federal Income Tax",null,37.020000000000003,null,-38,null,-0.97999999999999687,null,-2.6849315068493067E-3]
[12,null,"State Income Tax",null,37.020000000000003,null,-38,null,-0.97999999999999687,null,-2.6849315068493067E-3]
[13,null,"St Louis Corporate Earnings Tax",null,37.020000000000003,null,-274.5,null,{"$f":"E20+G20","v":-237.48},null,{"$f":"I20/365","v":-0.65063013698630134}]
[14,null,"Fuel - Nuclear",null,37.020000000000003,null,-15.208333333333334,null,{"$f":"E21+G21","v":21.811666666666667},null,{"$f":"I21/365","v":5.9757990867579908E-2}]
[15,null,"Fuel - Coal",null,37.020000000000003,null,-14.43339818369048,null,{"$f":"E22+G22","v":22.586601816309525},null,{"$f":"I22/365","v":6.1881100866601438E-2}]
[16,null,"Fuel - Oil",null,37.020000000000003,null,-14.687539183708767,null,{"$f":"E23+G23","v":22.332460816291238},null,{"$f":"I23/365","v":6.1184824154222571E-2}]
[17,null,"Fuel - Gas",null,37.020000000000003,null,-40.72113374533086,null,{"$f":"E24+G24","v":-3.701133745330857},null,{"$f":"I24/365","v":-1.0140092452961252E-2}]
[18,null,"Interest Expense",null,37.020000000000003,null,-91.368771393379063,null,-54.34877139337906,null,-0.14890074354350427]
[19,null,"Uncollectible Expense",null,37.020000000000003,null,{"$f":"-E26","v":-37.020000000000003},null,0,null,0]
[20,null,"Purchased Power",null,37.020000000000003,null,-18.100283771819221,null,18.919716228180782,null,5.1834838981317209E-2]
[21,null,"Decommissioning Fees",null,37.020000000000003,null,-69.5,null,-32.479999999999997,null,-8.8986301369863005E-2]
[22,null,"Incentive Compensation",null,37.020000000000003,null,-250.8,null,-213.78,null,-0.58569863013698631]
[23,null,"Fed Excise Heavy Use Tax",null,37.020000000000003,null,125.57361171391369,null,162.5936117139137,null,0.44546194990113341]
[24,null,"Self Procured Insurance Tax",null,37.020000000000003,null,-241.5,null,-204.48,null,-0.56021917808219179]
[25,null,"Ohio Commercial Activity Tax",null,37.020000000000003,null,50,null,87.02000000000001,null,0.23841095890410963]
[26,null,"Corporate Franchise Tax",null,37.020000000000003,null,-233.1920070138685,null,-196.17200701386849,null,-0.53745755346265345]
[27,null,"State of Indiana Corporate Income Tax",null,37.020000000000003,null,-14,null,23.020000000000003,null,6.306849315068494E-2]
[28,null,"State of Iowa Corporate Income Tax",null,37.020000000000003,null,77,null,114.02000000000001,null,0.31238356164383563]