{"text_format":"1","workbook":"xlsx","n_sheets":21,"sheets":["SCHEDULE MJL-S1","SCHEDULE MJL-S2","SCHEDULE MJL-S3","SCHEDULE MJL-S4","SCHEDULE MJL-S5","SCHEDULE MJL-S6","SCHEDULE MJL-S7","SCHEDULE MJL-S8","SCHEDULE MJL-S9","SCHEDULE MJL-S10","SCHEDULE MJL-S11-1","SCHEDULE MJL-S11-7","SCHEDULE MJL-S12-1","SCHEDULE MJL-S12-2","SCHEDULE MJL-S13-1","SCHEDULE MJL-S13-2","SCHEDULE MJL-S14","SCHEDULE MJL-S15","SCHEDULE MJL-S16","SCHEDULE MJL-S17","SCHEDULE MJL-S18"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":27,"comments":8,"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-S1","index":0,"n_rows":67,"n_cols":7,"rows_kept":67,"cut":false,"hidden":false,"merged":[[63,2,63,5],[56,2,58,5],[0,0,0,6],[1,0,1,6],[2,0,2,6],[3,0,3,6],[51,2,54,5]]}
["AMEREN MISSOURI"]
["ORIGINAL COST OF ELECTRIC PLANT"]
[{"$f":"\"BY FUNCTIONAL CLASSIFICATION \"&'SCHEDULE MJL-S3'!A3:G3","v":"BY FUNCTIONAL CLASSIFICATION FOR THE TWELVE MONTHS ENDED SEPTEMBER 30, 2021"}]
["($000)"]
[]
[]
[null,null,null,null,"TOTALS",null,"ADJUSTED"]
[null,null,null,null,"PER",null,"ELECTRIC"]
["LINE",null,"FUNCTIONAL CLASSIFICATION",null,"BOOKS","ADJUSTMENTS","TOTALS"]
[null,null,"(A)",null,"(B)","(C)","(D)"]
[null,null,"INTANGIBLE PLANT"]
[1,null,"   FRANCHISES",null,100102.102,0,{"$f":"SUM(E12:F12)","v":100102.102}]
[{"$f":"1+A12","v":2},null,"   CALLAWAY LIFE EXTENSION DEFERRAL",null,2811.9659999999999,0,{"$f":"SUM(E13:F13)","v":2811.9659999999999}]
[3,null,"   MISC INTANGIBLE PLANT",null,538024.02399999998,-19743.992249999999,{"$f":"SUM(E14:F14)","v":518280.03174999997}]
[{"$f":"1+A14","v":4},null,"TOTAL INTANGIBLE PLANT",null,{"$f":"SUM(E12:E14)","v":640938.09199999995},{"$f":"SUM(F12:F14)","v":-19743.992249999999},{"$f":"SUM(G12:G14)","v":621194.09974999994}]
[]
[null,null,"PRODUCTION PLANT"]
[{"$f":"1+A15","v":5},null,"   NUCLEAR",null,3504909.4720000001,-101674.757,{"$f":"SUM(E18:F18)","v":3403234.7149999999}]
[{"$f":"1+A18","v":6},null,"   CALLAWAY POST OPERATIONAL ",null,116730.94602,0,116730.94602]
[{"$f":"1+A19","v":7},null,"   STEAM",null,5004970.1387700001,-700257.96643666655,4304712.1723333336]
[8,null,"   SIOUX CONSTRUCTION ACCOUNTING",null,45224.618999999999,0,45224.618999999999]
[9,null,"   HYDRAULIC",null,605555.27,0,605555.27]
[{"$f":"1+A22","v":10},null,"   WIND",null,1192153.1714900001,-52488.13121,1139665.0402800001]
[11,null,"   OTHER",null,1288048.3517200002,0,1288048.3517200002]
[12,null,"TOTAL PRODUCTION PLANT",null,{"$f":"SUM(E18:E24)","v":11757591.969000001},{"$f":"SUM(F18:F24)","v":-854420.85464666656},{"$f":"SUM(G18:G24)","v":10903171.114353333}]
[]
[{"$f":"1+A25","v":13},null,"TRANSMISSION PLANT",null,1539297.075,0,{"$f":"SUM(E27:F27)","v":1539297.075}]
[]
[{"$f":"+A27+1","v":14},null,"DISTRIBUTION PLANT",null,7141024.9280000003,0,{"$f":"SUM(E29:F29)","v":7141024.9280000003}]
[]
[{"$f":"1+A29","v":15},null,"GENERAL PLANT",null,880347.81499999994,-19075.511999999999,{"$f":"SUM(E31:F31)","v":861272.30299999996}]
[]
[{"$f":"1+A31","v":16},null,"INCENTIVE COMPENSATION CAPITALIZED",null,0,-52694.093999999997,{"$f":"SUM(E33:F33)","v":-52694.093999999997}]
[]
[{"$f":"1+A33","v":17},null,"TOTAL PLANT IN SERVICE",null,{"$f":"E15+SUM(E25:E33)","v":21959199.879000001},{"$f":"F15+SUM(F25:F33)","v":-945934.4528966666},{"$f":"G15+SUM(G25:G33)","v":21013265.426103331}]
[]
[]
[]
[null,null,"PRO FORMA ADJUSTMENTS"]
[{"$f":"1+A35","v":18},-1,"Eliminate Plant balances related to FAS 143 Asset Retirement Obligation and ASC 842 Leases "]
[{"$f":"1+A40","v":19},null,null,"NUCLEAR",null,-101674.757]
[{"$f":"1+A41","v":20},null,null,"STEAM",null,-129833.36976999999]
[{"$f":"1+A42","v":21},null,null,"WIND",null,-52488.13121]
[22,null,null,"DISTRIBUTION",null,0]
[{"$f":"1+A44","v":23},null,null,"GENERAL",null,-4614.9809999999998]
[{"$f":"1+A45","v":24},null,null,"  TOTAL",null,null,{"$f":"SUM(F41:F45)","v":-288611.23898000002}]
[]
[{"$f":"1+A46","v":25},-2,"Paperless bill credit rebuttal adjustment"]
[{"$f":"1+A48","v":26},null,null,"OTHER INTANGIBLE PLANT",null,-15.11]
[{"$f":"1+A49","v":27},null,null,"  TOTAL",null,null,{"$f":"SUM(F49:F49)","v":-15.11}]
[]
[{"$f":"A50+1","v":28},"(3)","Reduce a portion of the amounts recoverable relating to the Meramec Energy Center due to its upcoming plant retirement.  This adjustment reflects the recovery of remaining amounts over a five year period.  Other components of this adjustment will be referred to as the Meramec Energy Center adjustment throughout the remainder of schedules MJL-D2 through MJL-D17.",null,null,null,-570424.59666666668]
[]
[]
[]
[]
[{"$f":"A52+1","v":29},-4,"Eliminate portions of plant in service for multi-use 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+A57","v":30}]
[{"$f":"1+A58","v":31}]
[{"$f":"1+A59","v":32},null,null,"INTANGIBLE",null,-19728.882249999999]
[{"$f":"1+A60","v":33},null,null,"GENERAL",null,-14460.531000000001]
[null,null,null,"  TOTAL",null,null,{"$f":"SUM(F60:F61)","v":-34189.413249999998}]
[]
[{"$f":"1+A61","v":34},-5,"Reduce Plant-in-Service for disallowed capital incentive compensation"]
[{"$f":"1+A64","v":35},null,null,"GENERAL",null,null,-52694.093999999997]
[]
[{"$f":"1+A65","v":36},null,null,"TOTAL PRO FORMA ADJUSTMENTS",null,null,{"$f":"SUM(G41:G65)","v":-945934.45289666671}]

{"sheet":"SCHEDULE MJL-S2","index":1,"n_rows":60,"n_cols":7,"rows_kept":60,"cut":false,"hidden":false,"merged":[[51,2,53,4],[0,0,0,6],[2,0,2,6],[1,0,1,6],[3,0,3,6]]}
["AMEREN MISSOURI"]
["TOTAL ELECTRIC RESERVES FOR DEPRECIATION AND AMORTIZATION"]
[{"$f":"+'SCHEDULE MJL-S1'!A3:G3","v":"BY FUNCTIONAL CLASSIFICATION FOR THE TWELVE MONTHS ENDED SEPTEMBER 30, 2021"}]
["($000)"]
[]
[]
[null,null,null,null,"TOTALS",null,"ADJUSTED"]
[null,null,null,null,"PER",null,"ELECTRIC"]
["LINE",null,"FUNCTIONAL CLASSIFICATION",null,"BOOKS","ADJUSTMENTS","TOTALS"]
[null,null,"(A)",null,"(B)","(C)","(D)"]
[null,null,"INTANGIBLE PLANT"]
[1,null,"   FRANCHISES",null,29335.383000000002,0,{"$f":"E12+F12","v":29335.383000000002}]
[{"$f":"1+A12","v":2},null,"   CALLAWAY LIFE EXTENSION DEFERRAL",null,416.92399999999998,0,{"$f":"E13+F13","v":416.92399999999998}]
[3,null,"   MISC INTANGIBLE PLANT",null,239908.147,-8515.150380000001,{"$f":"E14+F14","v":231392.99661999999}]
[{"$f":"1+A14","v":4},null,"TOTAL INTANGIBLE PLANT",null,{"$f":"SUM(E12:E14)","v":269660.45400000003},{"$f":"SUM(F12:F14)","v":-8515.150380000001},{"$f":"E15+F15","v":261145.30362000002}]
[]
[null,null,"PRODUCTION PLANT"]
[{"$f":"1+A15","v":5},null,"   NUCLEAR",null,1736698.496,9228.96299,1745927.45899]
[{"$f":"1+A18","v":6},null,"   CALLAWAY POST OPERATIONAL ",null,105361.27899999999,0,{"$f":"E19+F19","v":105361.27899999999}]
[{"$f":"1+A19","v":7},null,"   STEAM",null,2283613.3746100003,-575873.00844333344,1707740.3661666668]
[8,null,"   SIOUX CONSTRUCTION ACCOUNTING",null,20736.346000000001,0]
[9,null,"   HYDRAULIC",null,136699.19699999999,0,136699.19699999999]
[{"$f":"1+A22","v":10},null,"   WIND",null,28331.025000000001,-1249.5319999999999,27081.493000000002]
[11,null,"   OTHER",null,731525.44099999988,0,731525.44099999988]
[{"$f":"1+A24","v":12},null,"TOTAL PRODUCTION PLANT",null,{"$f":"SUM(E18:E24)","v":5042965.1586100003},{"$f":"SUM(F18:F24)","v":-567893.57745333342},4475071.5811566673]
[]
[{"$f":"1+A25","v":13},null,"TRANSMISSION PLANT",null,440066.098,0,440066.098]
[]
[{"$f":"1+A27","v":14},null,"DISTRIBUTION PLANT",null,3150854.8139999998,0,3150854.8139999998]
[]
[{"$f":"1+A29","v":15},null,"GENERAL PLANT",null,263213.576,-6239.5900799999999,256973.98592000001]
[]
[{"$f":"1+A31","v":16},null,"INCENTIVE COMPENSATION CAPITALIZED",null,0,-13590.402,{"$f":"E33+F33","v":-13590.402}]
[]
[{"$f":"1+A33","v":17},null,"TOTAL DEPRC. & AMORT RESERVE",null,{"$f":"E15+E25+E27+E29+E31+E33","v":9166760.1006099992},{"$f":"F15+F25+F27+F29+F31+F33","v":-596238.71991333342},{"$f":"G15+G25+G27+G29+G31+G33","v":8570521.3806966674}]
[]
[null,null,"PRO FORMA ADJUSTMENTS"]
[{"$f":"1+A35","v":18},-1,"Eliminate Reserve balances related to FAS 143 Asset Retirement Obligation and ASC 842 Leases"]
[{"$f":"1+A38","v":19},null,null,"NUCLEAR",null,9228.96299]
[{"$f":"1+A39","v":20},null,null,"STEAM",null,-74587.037609999999]
[{"$f":"1+A40","v":21},null,null,"DISTRIBUTION",null,0]
[22,null,null,"WIND",null,-1249.5319999999999]
[23,null,null,"GENERAL",null,-2047.7370800000001]
[{"$f":"1+A43","v":24},null,null,"  TOTAL",null,null,{"$f":"SUM(F39:F43)","v":-68655.343700000012}]
[]
[{"$f":"1+A44","v":25},-2,"Paperless bill credit rebuttal adjustment"]
[{"$f":"1+A46","v":26},null,null,"MISC INTANGIBLE PLANT",null,-4.1369999999999996]
[{"$f":"1+A47","v":27},null,null,"  TOTAL",null,null,{"$f":"SUM(F47:F47)","v":-4.1369999999999996}]
[]
[{"$f":"1+A48","v":28},"(4)","Meramec Energy Center adjustment.",null,null,null,-501285.97083333338]
[]
[{"$f":"1+A50","v":29},-5,"Eliminate portions of plant in service for multi use 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+A52","v":30}]
[{"$f":"1+A53","v":31}]
[{"$f":"1+A54","v":32},null,null,"TOTAL",null,null,-12702.866380000001]
[]
[{"$f":"1+A55","v":33},-6,"Reserve Balance adjustment for disallowed Incentive Compensation capitalized"]
[{"$f":"1+A57","v":34},null,null,"GENERAL",null,null,-13590.402]
[]
[{"$f":"1+A58","v":35},null,null,"TOTAL PRO FORMA ADJUSTMENTS",null,null,{"$f":"SUM(G38:G58)","v":-596238.71991333342}]

{"sheet":"SCHEDULE MJL-S3","index":2,"n_rows":32,"n_cols":6,"rows_kept":32,"cut":false,"hidden":false,"merged":[[0,0,0,5],[29,2,29,4],[3,0,3,5],[28,2,28,4]]}
["AMEREN MISSOURI"]
["AVERAGE FUEL AND MATERIALS & SUPPLIES INVENTORIES"]
["FOR THE TWELVE MONTHS ENDED SEPTEMBER 30, 2021"]
["($000)"]
[]
[null,null,null,"TOTALS",null,"ADJUSTED"]
[null,null,null,"PER",null,"ELECTRIC"]
["LINE",null,"DESCRIPTION","BOOKS","ADJUSTMENTS","TOTALS"]
[null,null,"(A)","(B)","(C)","(D)"]
[]
[1,null,"AVERAGE NUCLEAR FUEL ",143723.024,0,{"$f":"D11+E11","v":143723.024}]
[]
[null,null,"AVERAGE FOSSIL FUEL:"]
[{"$f":"1+A11","v":2},null,"   COAL",104996.236,-3491,{"$f":"D14+E14","v":101505.236}]
[{"$f":"1+A14","v":3},null,"   OIL",3135.1019999999999,0,{"$f":"D15+E15","v":3135.1019999999999}]
[{"$f":"1+A15","v":4},null,"   STORED GAS FOR CTG'S",1215.2180000000001,0,{"$f":"D16+E16","v":1215.2180000000001}]
[{"$f":"1+A16","v":5},null,"TOTAL FOSSIL FUEL",{"$f":"SUM(D14:D16)","v":109346.556},{"$f":"SUM(E14:E16)","v":-3491},{"$f":"D17+E17","v":105855.556}]
[]
[{"$f":"1+A17","v":6},null,"EMISSION ALLOWANCES AND RECS",214.06899999999999,0,{"$f":"D19+E19","v":214.06899999999999}]
[]
[{"$f":"1+A19","v":7},null,"GENERAL MATERIALS AND SUPPLIES",280081.19199999998,-11251.86,{"$f":"D21+E21","v":268829.33199999999}]
[]
[{"$f":"1+A21","v":8},null,"TOTAL",{"$f":"D11+D17+D19+D21","v":533364.84100000001},{"$f":"E11+E17+E19+E21","v":-14742.86},{"$f":"F11+F17+F19+F21","v":518621.98100000003}]
[]
[]
[null,null,"PRO FORMA ADJUSTMENT"]
[{"$f":"1+A23","v":9},"(2)","Meramec Energy Center adjustment.",null,null,-12418.186]
[]
[{"$f":"1+A27","v":10},"(3)","Eliminate portions of average fuel and general materials and supplies which are applicable to gas "]
[{"$f":"1+A29","v":11},null,"operations.",null,null,-2324.674]
[]
[{"$f":"1+A30","v":12},null,"TOTAL PRO FORMA ADJUSTMENTS",null,null,{"$f":"SUM(F27:F31)","v":-14742.86}]

{"sheet":"SCHEDULE MJL-S4","index":3,"n_rows":37,"n_cols":7,"rows_kept":37,"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-S3'!A3","v":"FOR THE TWELVE MONTHS ENDED SEPTEMBER 30, 2021"}]
[null,"($000)"]
[]
[null,null,null,null,"TOTALS",null,"ADJUSTED"]
[null,null,null,null,"PER",null,"ELECTRIC"]
[null,"LINE",null,"DESCRIPTION ","BOOKS(1)","ADJUSTMENTS","TOTALS"]
[null,null,null,"(A)","(B)","(C)","(D)"]
[]
[null,1,null,"   RENTS (3)",391.95100000000002,-9.4459999999999997,{"$f":"E11+F11","v":382.505}]
[null,{"$f":"1+B11","v":2},null,"   INSURANCE - DIRECT (2)",11367.493,-629.96199999999999,10737.531000000001]
[null,{"$f":"1+B12","v":3},null,"   M/A COMM RADIO SYS SRVC AGREEMENT (3)",0,0,0]
[null,4,null,"   MEDICAL AND DENTAL VEBA (3)",4590.902,-110.64100000000001,4480.2610000000004]
[null,5,null,"   IMAGING SOFTWARE (2)",59.561,0,59.561]
[null,{"$f":"1+B15","v":6},null,"   OPTIV GIGAMON (3)",8.7999999999999995E-2,-1E-3,{"$f":"E16+F16","v":8.6999999999999994E-2}]
[null,{"$f":"1+B16","v":7},null,"   CRM SALESFORCE SUBSCRIPTION (3)",0,0,{"$f":"E17+F17","v":0}]
[null,8,null,"   AGA MEMBERSHIP DUES",13.909000000000001,-13.909000000000001,{"$f":"E18+F18","v":0}]
[null,9,null,"   KANSAS CITY POWER & LIGHT (2)",2034.0909999999999,0,2034.0909999999999]
[null,10,null,"   PALO ALTO ENTERPRISE (3)",123.443,-2.9750000000000001,120.468]
[null,11,null,"   RCGA MEMBERSHIP DUES",32.718000000000004,0,32.718000000000004]
[null,12,null,"   ENERGY EFFICENCY MO COLLABORATIVE ",0,0,0]
[null,13,null,"   LOW INCOME WEATHERIZATION - DIRECT (2)",385.839,-83.733999999999995,{"$f":"E23+F23","v":302.10500000000002}]
[]
[null,{"$f":"1+B23","v":14},null,"TOTAL AVERAGE PREPAYMENTS",{"$f":"SUM(E11:E23)","v":18999.994999999999},{"$f":"SUM(F11:F23)","v":-850.66800000000001},{"$f":"SUM(G11:G23)","v":18149.327000000001}]
[]
[null,{"$f":"1+B25","v":15},-1,"Reflects 13 month average"]
[null,{"$f":"1+B27","v":16},-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":"B29+1","v":14},-1,"Eliminate portions of prepayments which are applicable to gas operations.  Allocated between electric",null,null,{"$f":"+F25","v":-850.66800000000001}]
[null,{"$f":"1+B35","v":15},null,"and gas operations based on operating expenses excluding purchased power, off-system sales and"]
[null,{"$f":"1+B36","v":16},null,"purchased gas."]

{"sheet":"SCHEDULE MJL-S5","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-S3'!A3","v":"FOR THE TWELVE MONTHS ENDED SEPTEMBER 30, 2021"}]
["($000)"]
[]
[null,null,null,null,null,null,null,null,"ADJUSTED","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,37.020000000000003,-10.9,{"$f":"+E11+F11","v":26.120000000000005},{"$f":"ROUND(+G11/365,6)","v":7.1562000000000001E-2},344027.94378999999,{"$f":"ROUND(+H11*I11,0)","v":24619}]
[{"$f":"1+A11","v":2},null,"PENSIONS AND BENEFITS",null,37.020000000000003,-15.7,{"$f":"+E12+F12","v":21.320000000000004},{"$f":"ROUND(+G12/365,6)","v":5.8410999999999998E-2},-11077.954,{"$f":"ROUND(+H12*I12,0)","v":-647}]
[3,null,"OTHER EMPLOYEE BENEFITS",null,37.020000000000003,-17.649999999999999,{"$f":"+E13+F13","v":19.370000000000005},{"$f":"ROUND(+G13/365,6)","v":5.3067999999999997E-2},48973.464999999997,{"$f":"ROUND(+H13*I13,0)","v":2599}]
[4,null,"FUEL"]
[5,null,"NUCLEAR",null,37.020000000000003,-15.21,{"$f":"+E15+F15","v":21.810000000000002},{"$f":"ROUND(+G15/365,6)","v":5.9753000000000001E-2},63295,{"$f":"ROUND(+H15*I15,0)","v":3782}]
[6,null,"COAL",null,37.020000000000003,-14.43,22.590000000000003,6.1890000000000001E-2,506617,{"$f":"ROUND(+H16*I16,0)","v":31355}]
[{"$f":"1+A16","v":7},null,"NATURAL GAS",null,37.020000000000003,-40.72,-3.6999999999999957,-1.0137E-2,15420,-156]
[8,null,"OIL",null,37.020000000000003,-14.69,{"$f":"+E18+F18","v":22.330000000000005},6.1178000000000003E-2,2467,{"$f":"ROUND(+H18*I18,0)","v":151}]
[9,null,"PURCHASED POWER",null,37.020000000000003,-18.100000000000001,{"$f":"+E19+F19","v":18.920000000000002},5.1836E-2,70501.867666666702,{"$f":"ROUND(+H19*I19,0)","v":3655}]
[10,null,"INCENTIVE COMPENSATION",null,37.020000000000003,-250.8,-213.78,-0.58569899999999997,30656.818640000001,-17956]
[11,null,"UNCOLLECTIBLE ACCOUNTS",null,37.020000000000003,-37.020000000000003,0,0,7885.0389999999998,0]
[12,null,"OTHER OPERATING EXPENSES",null,37.020000000000003,-42.25,-5.2299999999999969,-1.4329E-2,485752.947668946,{"$f":"ROUND(+H22*I22,0)","v":-6960}]
[]
[{"$f":"1+A22","v":13},null,"TOTAL O&M EXPENSES",null,null,null,null,null,1564519.1277656129]
[]
[{"$f":"1+A24","v":14},null,"     TOTAL CASH WORKING CAPITAL REQUIREMENT",null,null,null,null,null,null,{"$f":"SUM(J11:J22)","v":40442}]
[]
[{"$f":"1+A26","v":15},null,"FICA - EMPLOYER'S PORTION",null,37.020000000000003,-9.3800000000000008,{"$f":"+E28+F28","v":27.64},{"$f":"ROUND(+G28/365,6)","v":7.5726000000000002E-2},21607.42928,{"$f":"ROUND(+H28*I28,0)","v":1636}]
[{"$f":"1+A28","v":16},null,"ST. LOUIS PAYROLL EXPENSE TAXES",null,37.020000000000003,-9.3800000000000008,{"$f":"+E29+F29","v":27.64},{"$f":"ROUND(+G29/365,6)","v":7.5726000000000002E-2},490.75253999999995,{"$f":"ROUND(+H29*I29,0)","v":37}]
[17,null,"FEDERAL UNEMPLOYMENT TAXES",null,37.020000000000003,-9.3800000000000008,27.64,{"$f":"ROUND(+G30/365,6)","v":7.5726000000000002E-2},178.53095000000002,14]
[18,null,"STATE UNEMPLOYMENT TAXES",null,37.020000000000003,-9.3800000000000008,27.64,7.5726000000000002E-2,4.7917800000000002,0]
[19,null,"CORPORATE FRANCHISE TAXES",null,37.020000000000003,-233.19,-196.17,-0.53745200000000004,101.55878999999999,-55]
[20,null,"PROPERTY TAXES",null,37.020000000000003,-183,-145.97999999999999,-0.39994499999999999,157052.86348000003,-62813]
[21,null,"DECOMMISSIONING FEES",null,37.020000000000003,-69.5,{"$f":"+E34+F34","v":-32.479999999999997},{"$f":"ROUND(+G34/365,6)","v":-8.8985999999999996E-2},6758.6049999999996,-601]
[22,null,"SALES TAXES",null,37.020000000000003,-9.31,27.71,7.5917999999999999E-2,70028.46226,5316]
[{"$f":"1+A35","v":23},null,"MO & IA USE TAXES",null,37.020000000000003,-76.25,-39.229999999999997,-0.10747900000000001,2754.2213700000002,-296]
[{"$f":"1+A36","v":24},null,"IL USE TAXES",null,37.020000000000003,-35.78,{"$f":"+E37+F37","v":1.240000000000002},{"$f":"ROUND(+G37/365,6)","v":3.3969999999999998E-3},47.457000000000001,{"$f":"ROUND(+H37*I37,0)","v":0}]
[25,null,"FED EXCISE HEAVY USE TAX",null,37.020000000000003,125.57,{"$f":"+E38+F38","v":162.59},{"$f":"ROUND(+G38/365,6)","v":0.44545200000000001},21.0885,{"$f":"ROUND(+H38*I38,0)","v":9}]
[{"$f":"1+A38","v":26},null,"SELF PROCURED INS TAX",null,37.020000000000003,-241.5,-204.48,-0.56021900000000002,-205.60300000000001,115]
[27,null,"OHIO COMMERCIAL ACTIVITY TAX",null,37.020000000000003,50,87.02000000000001,0.23841100000000001,0.8,0]
[28,null,"GROSS RECEIPTS TAXES",null,24.27,-26.99,-2.7199999999999989,-7.4520000000000003E-3,133304.66696,-993]
[]
[{"$f":"1+A41","v":29},null,"TOTAL TAXES AND OTHER EXPENSES",null,null,null,null,null,{"$f":"SUM(I28:I41)","v":392145.62491000001}]
[]
[{"$f":"1+A43","v":30},null,"     NET CUSTOMER SUPPLIED FUNDS",null,null,null,null,null,null,{"$f":"SUM(J28:J41)","v":-57631}]
[]
[{"$f":"1+A45","v":31},null,"NET CASH WORKING CAPITAL REQUIREMENT",null,null,null,null,null,null,{"$f":"J26+J45","v":-17189}]

{"sheet":"SCHEDULE MJL-S6","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-S5'!A3","v":"FOR THE TWELVE MONTHS ENDED SEPTEMBER 30, 2021"}]
["($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,37.020000000000003,-38,{"$f":"+E14+F14","v":-0.97999999999999687},{"$f":"ROUND(+G14/365,6)","v":-2.6849999999999999E-3},48057.373,{"$f":"ROUND(+H14*I14,0)","v":-129}]
[]
[{"$f":"1+A14","v":2},null,"MO STATE INCOME TAX CASH REQUIREMENT",null,37.020000000000003,-38,{"$f":"+E16+F16","v":-0.97999999999999687},{"$f":"ROUND(+G16/365,6)","v":-2.6849999999999999E-3},19899.440999999999,{"$f":"ROUND(+H16*I16,0)","v":-53}]
[]
[{"$f":"1+A16","v":3},null,"IN STATE INCOME TAX CASH REQUIREMENT ",null,37.020000000000003,-14,{"$f":"+E18+F18","v":23.020000000000003},{"$f":"ROUND(+G18/365,6)","v":6.3067999999999999E-2},40,{"$f":"ROUND(+H18*I18,0)","v":3}]
[]
[{"$f":"1+A18","v":4},null,"IA STATE INCOME TAX CASH REQUIREMENT",null,37.020000000000003,77,{"$f":"+E20+F20","v":114.02000000000001},{"$f":"ROUND(+G20/365,6)","v":0.312384},30,{"$f":"ROUND(+H20*I20,0)","v":9}]
[]
[{"$f":"1+A20","v":5},null,"CITY EARNINGS TAX CASH REQUIREMENT",null,37.020000000000003,-274.5,{"$f":"+E22+F22","v":-237.48},{"$f":"ROUND(+G22/365,6)","v":-0.65063000000000004},-27.193999999999999,{"$f":"ROUND(+H22*I22,0)","v":18}]
[]
[6,null,"INTEREST EXPENSE CASH REQUIREMENT",null,37.020000000000003,-91.37,{"$f":"+E24+F24","v":-54.35},{"$f":"ROUND(+G24/365,6)","v":-0.14890400000000001},188489,{"$f":"ROUND(+H24*I24,0)","v":-28067}]

{"sheet":"SCHEDULE MJL-S7","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-S4'!B3","v":"FOR THE TWELVE MONTHS ENDED SEPTEMBER 30, 2021"}]
["($000)"]
[]
[]
["LINE",null,"DESCRIPTION",null,"TOTAL ELECTRIC"]
[null,null,"(A)",null,"(B)"]
[]
[]
[]
[{"$f":"1","v":1},null,"AVERAGE CUSTOMER ADVANCES FOR CONSTRUCTION",null,-827.57500000000005]
[]
[]
[{"$f":"1+A13","v":2},null,"AVERAGE CUSTOMER DEPOSITS",null,-17969.475999999999]

{"sheet":"SCHEDULE MJL-S8","index":7,"n_rows":36,"n_cols":8,"rows_kept":36,"cut":false,"hidden":false,"merged":[[9,2,9,5],[10,2,10,5]]}
["AMEREN MISSOURI"]
["OTHER REGULATORY ASSETS "]
["AND REGULATORY LIABILITIES "]
[{"$f":"+'SCHEDULE MJL-S9'!A3:H3","v":"FOR THE TWELVE MONTHS ENDED SEPTEMBER 30, 2021"}]
["($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,-25174.27]
[]
[]
[{"$f":"1+A15","v":2},null,"OTHER POST-EMPLOYMENT BENEFITS",null,null,null,null,-6938.8689999999997]
[]
[]
[{"$f":"1+A18","v":3},null,"PAYS REGULATORY ASSET",null,null,null,null,184.80600000000001]
[]
[]
[{"$f":"1+A21","v":4},null,"PISA REGULATORY ASSET",null,null,null,null,246605.48894000001]
[]
[]
[{"$f":"1+A24","v":5},null,"Reserved for future use",null,null,null,null,0]
[]
[]
[{"$f":"A24+1","v":5},null,"OVER COLLECTED AMORTIZATIONS IN RATE BASE",null,null,null,null,-196.30099999999999]
[]
[]
[6,null,"EQUITY ISSUANCE COSTS",null,null,null,null,7003.5035499999985]
[]
[7,null,"(1)  A positive balance is a Regulatory Asset and a negative balance is a"]
[{"$f":"1+A35","v":8},null,"       Regulatory Liability."]

{"sheet":"SCHEDULE MJL-S9","index":8,"n_rows":25,"n_cols":8,"rows_kept":25,"cut":false,"hidden":false,"merged":[[25,2,25,7],[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-S3'!A3:G3","v":"FOR THE TWELVE MONTHS ENDED SEPTEMBER 30, 2021"}]
["($000)"]
[]
[null,null,null,null,null,"TOTAL",null,"ADJUSTED"]
[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,40075.785000000003,0,{"$f":"+F11+G11","v":40075.785000000003}]
[]
[2,null,"ACCOUNT 281",null,null,-91705.815000000002,0,{"$f":"+F13+G13","v":-91705.815000000002}]
[]
[3,null,"ACCOUNT 282",null,null,-2798561.9618100002,0,{"$f":"+F15+G15","v":-2798561.9618100002}]
[]
[4,null,"ACCOUNT 283",null,null,-94976.884999999995,0,{"$f":"+F17+G17","v":-94976.884999999995}]
[]
[5,null,"MERAMEC ENERGY CENTER ADJUSTMENT",null,null,0,2463.904,{"$f":"+F19+G19","v":2463.904}]
[]
[6,null,"TOTAL ACCUMULATED DEFERRED INCOME TAXES",null,null,{"$f":"SUM(F11:F20)","v":-2945168.8768099998},{"$f":"SUM(G11:G20)","v":2463.904},{"$f":"SUM(H11:H20)","v":-2942704.9728099997}]
[]
[]
[null,null,"PRO FORMA ADJUSTMENT:"]
[7,null,"Meramec Energy Center Adjustment."]

{"sheet":"SCHEDULE MJL-S10","index":9,"n_rows":66,"n_cols":6,"rows_kept":66,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
["AMEREN MISSOURI"]
["TOTAL ELECTRIC PER BOOK AND PRO FORMA OPERATING REVENUES"]
["FOR THE TWELVE MONTHS ENDED DECEMBER 31, 2020"]
["($000)"]
[]
[]
[]
[null,null,null,null,null,"ADJUSTED"]
[null,null,null,"TOTAL ",null,"TOTAL "]
["LINE",null,"DESCRIPTION","ELECTRIC","ADJUSTMENTS","ELECTRIC"]
[null,null,"(A)","(B)","(C)","(D)"]
[]
[null,null,"OPERATING REVENUES"]
[1,null,"RETAIL REVENUES",2673831.6129999999,{"$f":"SUM(D31:D45)","v":-185362.35899999997},{"$f":"D14+E14","v":2488469.2539999997}]
[{"$f":"1+A14","v":2},null,"PROVISION FOR RATE REFUNDS",29040.496999999999,{"$f":"+E48","v":-29040.496999999999},{"$f":"D15+E15","v":0}]
[{"$f":"1+A15","v":3},null,"OTHER ELECTRIC REVENUES",85005.358999999997,{"$f":"+D50+D51+D52+D55+D56+D57+D53+D54","v":3113.6854699999994},{"$f":"D16+E16","v":88119.044469999993}]
[]
[{"$f":"1+A16","v":4},null,"TOTAL REVENUES",{"$f":"SUM(D13:D16)","v":2787877.469},{"$f":"SUM(E13:E16)","v":-211289.17052999997},{"$f":"SUM(F13:F16)","v":2576588.2984699998}]
[]
[{"$f":"1+A18","v":5},null,"DISPOSITION OF ALLOWANCES",-4.8000000000000001E-2,{"$f":"+E60","v":4.8000000000000001E-2},{"$f":"D20+E20","v":0}]
[]
[{"$f":"1+A20","v":6},null,"OFF-SYSTEM SALES - ENERGY",152306.18700000001,{"$f":"+E62","v":164222.60500000001},{"$f":"D22+E22","v":316528.79200000002}]
[]
[{"$f":"1+A22","v":7},null,"OFF-SYSTEM SALES-CAPACITY REVENUE",17870.990000000002,{"$f":"+E64","v":194.886},{"$f":"D24+E24","v":18065.876}]
[]
[{"$f":"A24+1","v":8},null,"TOTAL REVENUES PER BOOKS",{"$f":"SUM(D18:D24)","v":2958054.5980000002},{"$f":"SUM(E18:E24)","v":-46871.631529999955},{"$f":"SUM(F18:F24)","v":2911182.9664699999}]
[]
[]
[]
[null,null,"PRO FORMA ADJUSTMENTS:"]
[{"$f":"1+A26","v":9},-1,"REMOVE ADD ON REVENUE TAX",-133114.44200000001]
[{"$f":"1+A31","v":10},-2,"ELIMINATE  REVENUE FROM MEEIA RECOVERIES",-90050.536999999997]
[11,-3,"ELIMINATE  REVENUE FROM FAC RECOVERIES",47582.703999999998]
[12,-4,"ELIMINATE  UNBILLED REVENUE",7432]
[13,-5,"ADJUST FOR PANDEMIC SHOCK",8256.8289999999997]
[14,-6,"ADJUST FOR UPDATE PERIOD",11041.675999999999]
[15,-7,"ADJUST FOR EDI",-308.447]
[16,-8,"ADJUST FOR GROWTH",4249.3729999999996]
[17,-9,"ADJUST FOR RESRAM REVENUES",-11459.86]
[18,-10,"ADJUST FOR ENERGY EFFICIENCY AND SOLAR ANNUALIZATION",-26043.413]
[19,-11,"ADJUST FOR SEASONAL PRORATION",4640.9790000000003]
[20,-12,"ADJUST FOR COMMUNITY SOLAR",94.055999999999997]
[21,-13,"DAYS ADJUSTMENT",5041.6289999999999]
[22,-14,"ADJUST FOR BILLING UNITS",-2844.6469999999999]
[{"$f":"1+A44","v":23},-15,"ADJUST FOR NORMAL WEATHER ",-9880.259]
[{"$f":"1+A45","v":24},null,"TOTAL",null,{"$f":"SUM(D31:D45)","v":-185362.35899999997}]
[]
[{"$f":"1+A46","v":25},-16,"ELIMINATE  PROVISION FOR RATE REFUNDS",null,-29040.496999999999]
[]
[{"$f":"1+A48","v":26},-17,"ADJUST TRANSMISSION REVENUES",2693.5804299999995]
[27,-18,"MISC REVENUE FROM COAL REFINEMENT",-1385.3959600000001]
[28,-19,"ADJUST WAIVED LATE FEE REVENUE FROM AAO",3290.6979999999999]
[29,-20,"ADJUST DICONNECT/RECONNECT FEES",349.96600000000001]
[30,-21,"ADJUST LEASE REVENUE FROM RENT REVENUE",1521.5160000000001]
[31,-22,"MISC LEASE REVENUE FROM SOFTWARE LEASES",-1671.5889999999999]
[32,-23,"ADJUST BOA LEASE REVENUE",-1686.8050000000001]
[33,-24,"ADJUST FOR PAYS REVENUES",1.7150000000000001]
[34,null,"TOTAL",null,{"$f":"SUM(D50:D57)","v":3113.6854700000004}]
[]
[{"$f":"1+A58","v":35},-21,"ELIMINATE  DISPOSITION OF ALLOWANCES",null,4.8000000000000001E-2]
[]
[{"$f":"1+A60","v":36},-22,"ADJUST OFF-SYSTEM SALES - ENERGY",null,164222.60500000001]
[]
[{"$f":"1+A62","v":37},-23,"ADJUST OFF-SYSTEM SALES - CAPACITY",null,194.886]
[]
[{"$f":"1+A64","v":38},null,"TOTAL PRO FORMA ADJUSTMENTS",null,{"$f":"SUM(E31:E64)","v":-46871.631529999955}]

{"sheet":"SCHEDULE MJL-S11-1","index":10,"n_rows":61,"n_cols":82,"rows_kept":61,"cut":false,"hidden":false,"merged":[[44,67,59,67],[44,0,59,0],[44,14,59,14],[44,28,59,28],[44,40,59,40],[44,53,59,53]]}
[null,null,null,null,null,"#1","#2","#3","#4","#5","#6","#7","#8","#9",null,null,null,null,"#10","#11","#12","#13","#14","#15","#16","#17","#18","#19",null,null,null,null,"#20","#21","#22","#23","#24","#25","#26","#27",null,null,null,null,"#28","#29","#30","#31","#32","#33","#34","#35","#36",null,null,null,null,"#37","#38","#39","#40","#41","#42","#43","#44","#45","#46",null,null,null,null,"#47","#48","#49","#50","#51","#52","#53","#54"]
[null,null,"Title included in Page header for printing purposes.",null,null,null,"SHORT-TERM","LONG-TERM",null,null,"ADJUST",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ENERGY EFFICIENCY",null,null,null,null,null,null,null,null,null,null,null,"REBASE","AMORTIZE",null,null,null,null,"BOARD OF"]
[null,null,null,null,"TOTAL",null,"INCENTIVE","INCENTIVE","STAFFING ","CHANGE IN FUEL","PURCHASED","MARK TWAIN","COAL ","STEAM ",null,null,null,null,null,"ELIMINATE","CALLAWAY","CALLAWAY ","OTHER","REBASE","ELIMINATE","ANNUALIZE SOLAR","DEPRECIATION","NORMALIZE",null,null,null,null,"ANNUALIZE","ADD INTEREST","PROGRAM COST","INTENTIONALLY","ANNUALIZE",null,"ANNUALIZE ",null,null,null,null,null,"MEDICAL & ","NON-QUALIFIED","PENSION","PENSION","RESRAM",null,null,null,"DIRECTORS",null,null,null,null,"DEPRECIATION","BOA","SOFTWARE","ALLOCATION","NORMALIZE",null,"ELECTRIC","CUSTOMER ","EV","SOFTWARE",null,null,null,null,"INCREASE IN","AMR",null,"PAPERLESS","FACILITY","CALL CENTER","RUSH ISLAND","CYBERSECURITY",null,"TOTAL","PRO FORMA"]
[null,null,null,null,"PER","LABOR","COMPENSATION","COMPENSATION","ANNUALIZATION","EXPENSE FOR","POWER FOR","TRANSMISSION","REFINEMENT","PLANT",null,null,null,null,"MERAMEC ","FAC","REFUELING","UNPLANNED","RES AMORT","RES","SOLAR","REBATE","TO O&M","STORM",null,null,null,null,"VEG MGMT &","ON CUSTOMER","RECOVERY","LEFT","BAD DEBT","MEMBERSHIP","EEI","INSURANCE",null,null,null,null,"BENEFIT","PENSION","AND OPEB","AND OPEB","BASE ","ALCOHOL","RATE CASE","MPSC","EXPENSE",null,null,null,null,"STUDY","RENTAL","RENTAL","FACTOR","COVID","REMOVE ","COSTS","CONVENIENCE ","INCENTIVE","MAINTENANCE",null,null,null,null,"BUILDING RENT","COST","MISCELLANEOUS","BILL","O&M","COSTS","NSR LEGAL FEES","COSTS",null,"PRO FORMA","ELECTRIC"]
[null,null,"LINE","FUNCTIONAL CLASSIFICATION","BOOKS","ADJUSTMENT","ADJUSTMENT","ADJUSTMENT","SALARY & BENEFITS","TU CHANGE","TU CHANGE","ADJUSTMENT","ADJUSTMENT","MAINTENANCE",null,null,"LINE","FUNCTIONAL CLASSIFICATION","ADJUSTMENT ","RECOVERY","EXPENSES","OUTAGE","ADJUSTMENT","EXPENSE","AMOUNTS","AMORTIZATION","ADJUSTMENT","COSTS",null,null,"LINE","FUNCTIONAL CLASSIFICATION","INSPECTIONS","DEPOSITS","ADJUSTMENT","BLANK","EXPENSE","DUES","DUES","ADJUST.",null,null,"LINE","FUNCTIONAL CLASSIFICATION","ADJUST.","ADJUST.","TRACKER","TRACKER","EXPENSE","PURCHASES","EXPENSES","ASSESSMENT","ADJUSTMENT",null,null,"LINE","FUNCTIONAL CLASSIFICATION","EXPENSE","EXPENSE","EXPENSE","ADJUSTMENT","EXPENSES","COLI","ALLOC TO GAS","FEES","ADJUSTMENT","ADJUSTMENT",null,null,"LINE","FUNCTIONAL CLASSIFICATION","FROM AMS","SAVINGS","EXPENSES","CREDIT","ADJUSTMENT","ADJUSTMENT","ADJUSTMENT","ADJUSTMENT",null,"ADJUSTMENT","TOTALS"]
[null,null,null,"(A)","(B)","(C)","(D)","(E)","(F)","(G)","(H)","(I)","(J)","(K)",null,null,null,"(A)","(B)","(C)","(D)","(E)","(F)","(G)","(H)","(I)","(J)","(K)",null,null,null,"(A)","(B)","(C)","(D)","(E )","(F)","(G)","(H)","(I)",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)","(K)",null,null,null,"(A)","(B)","(C)","(D)","(E )","(F)","(G)","(H)","(I)",null,"(G)","(H)"]
[null,null,null,"  PRODUCTION:",null,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,null,"  PRODUCTION:",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,null,"  PRODUCTION:"]
[null,null,null,"    INCREMENTAL COSTS:",null,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,null,"    INCREMENTAL COSTS:",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,null,"    INCREMENTAL COSTS:"]
[null,null,1,"      LABOR",204320.55914,4106.7070000000003,-819.529,-1576.9313669080432,0,0,0,0,0,null,null,null,1,"      LABOR",0,0,5088.2820000000002,0,0,0,0,0,0,0,null,null,1,"      LABOR",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,null,1,"      LABOR",0,0,0,0,null,null,null,null,null,{"$f":"SUM(F9:N9,S9:AB9,AG9:AN9,AS9:BA9,BF9:BP9,BT9:CB9)","v":6798.5286330919571},{"$f":"E9+CC9","v":211119.08777309195}]
[null,null,2,"      FUEL (EXCL. W/H CR.)",null,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,null,"      FUEL (EXCL. W/H CR.)",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,null,"      FUEL (EXCL. W/H CR.)"]
[null,null,null,"            BASE LOAD",432189.11300000001,0,0,0,0,-53823.695240000001,0,0,0,null,null,null,{"$f":"1+Q9","v":2},"            BASE LOAD",0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+AE9","v":2},"            BASE LOAD",0,0,0,0,0,0,0,0,null,null,{"$f":"1+AQ9","v":2},"            BASE LOAD",0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+BD9","v":2},"            BASE LOAD",0,0,0,0,0,0,0,0,0,null,null,null,{"$f":"1+BR9","v":2},"            BASE LOAD",0,0,0,0,null,null,null,null,null,{"$f":"SUM(F11:N11,S11:AB11,AG11:AN11,AS11:BA11,BF11:BP11,BT11:CB11)","v":-53823.695240000001},{"$f":"E11+CC11","v":378365.41775999998}]
[null,null,null,"            INTERCHANGE",103625.18713999999,0,0,0,0,117935.56686000001,0,0,0,null,null,null,{"$f":"1+Q11","v":3},"            INTERCHANGE",0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+AE11","v":3},"            INTERCHANGE",0,0,0,0,0,0,0,0,null,null,{"$f":"1+AQ11","v":3},"            INTERCHANGE",0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+BD11","v":3},"            INTERCHANGE",0,0,0,0,0,0,0,0,0,null,null,null,{"$f":"1+BR11","v":3},"            INTERCHANGE",0,0,0,0,null,null,null,null,null,{"$f":"SUM(F12:N12,S12:AB12,AG12:AN12,AS12:BA12,BF12:BP12,BT12:CB12)","v":117935.56686000001},{"$f":"E12+CC12","v":221560.75400000002}]
[null,null,3,"      FUEL ADDITIVES",6265.62,0,0,0,0,1626.5429999999999,0,0,0,0,null,null,{"$f":"1+Q12","v":4},"      FUEL ADDITIVES",0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+AE12","v":4},"      FUEL ADDITIVES",0,0,0,0,0,0,0,0,null,null,{"$f":"1+AQ12","v":4},"      FUEL ADDITIVES",0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+BD12","v":4},"      FUEL ADDITIVES",0,0,0,0,0,0,0,0,0,null,null,null,{"$f":"1+BR12","v":4},"      FUEL ADDITIVES",0,0,0,0,null,null,null,null,null,{"$f":"SUM(F13:N13,S13:AB13,AG13:AN13,AS13:BA13,BF13:BP13,BT13:CB13)","v":1626.5429999999999},{"$f":"E13+CC13","v":7892.1629999999996}]
[null,null,4,"      PURCHASED POWER ",null,0,0,0,null,null,null,null,null,null,null,null,null,"      PURCHASED POWER ",null,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,"      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,null,"      PURCHASED POWER "]
[null,null,null,"        ENERGY ",null,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,null,"        ENERGY ",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,null,"        ENERGY "]
[null,null,null,"            BASE LOAD",72665.525999999998,0,0,0,0,0,-13993.073333333299,0,0,0,null,null,{"$f":"1+Q13","v":5},"            BASE LOAD",0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+AE13","v":5},"            BASE LOAD",0,0,0,0,0,0,0,0,null,null,{"$f":"1+AQ13","v":5},"            BASE LOAD",0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+BD13","v":5},"            BASE LOAD",0,0,0,0,0,0,0,0,0,null,null,null,{"$f":"1+BR13","v":5},"            BASE LOAD",0,0,0,0,0,0,0,0,null,{"$f":"SUM(F16:N16,S16:AB16,AG16:AN16,AS16:BA16,BF16:BP16,BT16:CB16)","v":-13993.073333333299},{"$f":"E16+CC16","v":58672.452666666701}]
[null,null,null,"            INTERCHANGE",-6184.1019999999999,0,0,0,0,0,6184.1019999999999,0,0,0,null,null,{"$f":"1+Q16","v":6},"            INTERCHANGE",0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+AE16","v":6},"            INTERCHANGE",0,0,0,0,0,0,0,0,null,null,{"$f":"1+AQ16","v":6},"            INTERCHANGE",0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+BD16","v":6},"            INTERCHANGE",0,0,0,0,0,0,0,0,0,null,null,null,{"$f":"1+BR16","v":6},"            INTERCHANGE",0,0,0,0,0,0,0,0,null,6184.1019999999999,{"$f":"E17+CC17","v":0}]
[null,null,5,"        CAPACITY COSTS",null,null,null,null,null,null,null,null,null,null,null,null,null,"        CAPACITY COSTS",null,null,null,null,0,0,0,0,0,0,null,null,null,"        CAPACITY COSTS",null,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,null,"        CAPACITY COSTS",0,0,0,0,0,0,0,0,null,0]
[null,null,null,"            BASE LOAD",11550.057000000001,0,0,0,0,0,279.358,0,0,0,null,null,{"$f":"1+Q17","v":7},"            BASE LOAD",0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+AE17","v":7},"            BASE LOAD",0,0,0,0,0,0,0,0,null,null,{"$f":"1+AQ17","v":7},"            BASE LOAD",0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+BD17","v":7},"            BASE LOAD",0,0,0,0,0,0,0,0,0,null,null,null,{"$f":"1+BR17","v":7},"            BASE LOAD",0,0,0,0,0,0,0,0,null,279.358,{"$f":"E19+CC19","v":11829.415000000001}]
[null,null,null,"            INTERCHANGE",0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+Q19","v":8},"            INTERCHANGE",0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+AE19","v":8},"            INTERCHANGE",0,0,0,0,0,0,0,0,null,null,{"$f":"1+AQ19","v":8},"            INTERCHANGE",0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+BD19","v":8},"            INTERCHANGE",0,0,0,0,0,0,0,0,0,null,null,null,{"$f":"1+BR19","v":8},"            INTERCHANGE",0,0,0,0,0,0,0,0,null,0,{"$f":"E20+CC20","v":0}]
[null,null,6,"      OTHER",24070.624609999893,0,0,0,0,0,0,0,21272.217000000001,9423.9189999999999,null,null,{"$f":"1+Q20","v":9},"      OTHER",-2062.4430000000002,49056.597999999998,20608.371999999999,-265.55164000000002,3259.8629999999998,-621.32100000000003,0,0,-393.43666000000002,0,null,null,{"$f":"1+AE20","v":9},"      OTHER",0,0,0,0,0,-13.285,0,0,null,null,{"$f":"1+AQ20","v":9},"      OTHER",0,0,0,0,18235.263999999999,-4.407,0,0,0,null,null,{"$f":"1+BD20","v":9},"      OTHER",0,0,0,0,-5045.7340000000004,0,0,0,0,0,null,null,{"$f":"1+BR20","v":9},"      OTHER",0,0,-3.4613299999999998,0,0,0,0,0,null,113446.59336999997,{"$f":"E21+CC21","v":137517.21797999987}]
[null,null,{"$f":"1+C21","v":7},"  TOTAL PRODUCTION EXPENSES",{"$f":"SUM(E9:E21)","v":848502.58488999994},4106.7070000000003,-819.529,-1576.9313669080432,0,{"$f":"SUM(J9:J21)","v":65738.41462000001},{"$f":"SUM(K9:K21)","v":-7529.6133333332991},{"$f":"SUM(L9:L21)","v":0},{"$f":"SUM(M9:M21)","v":21272.217000000001},9423.9189999999999,null,null,{"$f":"1+Q21","v":10},"  TOTAL PRODUCTION EXPENSES",{"$f":"SUM(S9:S21)","v":-2062.4430000000002},{"$f":"SUM(T9:T21)","v":49056.597999999998},{"$f":"SUM(U9:U21)","v":25696.653999999999},{"$f":"SUM(V9:V21)","v":-265.55164000000002},{"$f":"SUM(W9:W21)","v":3259.8629999999998},{"$f":"SUM(X9:X21)","v":-621.32100000000003},{"$f":"SUM(Y9:Y21)","v":0},0,{"$f":"SUM(AA9:AA21)","v":-393.43666000000002},0,null,null,{"$f":"1+AE21","v":10},"  TOTAL PRODUCTION EXPENSES",{"$f":"SUM(AG9:AG21)","v":0},{"$f":"SUM(AH9:AH21)","v":0},{"$f":"SUM(AI9:AI21)","v":0},0,{"$f":"SUM(AK9:AK21)","v":0},{"$f":"SUM(AL9:AL21)","v":-13.285},0,{"$f":"SUM(AN9:AN21)","v":0},null,null,{"$f":"1+AQ21","v":10},"  TOTAL PRODUCTION EXPENSES",{"$f":"SUM(AS9:AS21)","v":0},{"$f":"SUM(AT9:AT21)","v":0},{"$f":"SUM(AU9:AU21)","v":0},{"$f":"SUM(AV9:AV21)","v":0},{"$f":"SUM(AW9:AW21)","v":18235.263999999999},-4.407,{"$f":"SUM(AY9:AY21)","v":0},{"$f":"SUM(AZ9:AZ21)","v":0},0,null,null,{"$f":"1+BD21","v":10},"  TOTAL PRODUCTION EXPENSES",{"$f":"SUM(BF9:BF21)","v":0},0,{"$f":"SUM(BH9:BH21)","v":0},{"$f":"SUM(BI9:BI21)","v":0},{"$f":"SUM(BJ9:BJ21)","v":-5045.7340000000004},{"$f":"SUM(BK9:BK21)","v":0},{"$f":"SUM(BL9:BL21)","v":0},0,0,0,null,null,{"$f":"1+BR21","v":10},"  TOTAL PRODUCTION EXPENSES",{"$f":"SUM(BT9:BT21)","v":0},0,{"$f":"SUM(BV9:BV21)","v":-3.4613299999999998},{"$f":"SUM(BW9:BW21)","v":0},{"$f":"SUM(BX9:BX21)","v":0},0,0,0,null,{"$f":"SUM(CC9:CC21)","v":178453.92328975865},{"$f":"SUM(CD9:CD21)","v":1026956.5081797584}]
[]
[null,null,null,"  TRANSMISSION EXPENSES:",null,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,null,"  TRANSMISSION EXPENSES:",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,null,"  TRANSMISSION EXPENSES:"]
[null,null,{"$f":"1+C22","v":8},"      LABOR",6197.6360000000004,114.14400000000001,-24.859000000000002,-139.64455880535601,0,0,0,0,0,0,null,null,{"$f":"1+Q22","v":11},"      LABOR",0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+AE22","v":11},"      LABOR",0,0,0,0,0,0,0,0,null,null,{"$f":"1+AQ22","v":11},"      LABOR",0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+BD22","v":11},"      LABOR",0,0,0,0,0,0,0,0,0,null,null,null,{"$f":"1+BR22","v":11},"      LABOR",0,0,0,0,0,0,0,0,null,{"$f":"SUM(F25:N25,S25:AB25,AG25:AN25,AS25:BA25,BF25:BP25,BT25:CB25)","v":-50.359558805356016},{"$f":"E25+CC25","v":6147.2764411946446}]
[null,null,{"$f":"1+C25","v":9},"      OTHER",98175.686350000004,0,0,0,0,0,2740.1770000000001,-157.95099999999999,0,0,null,null,{"$f":"1+Q25","v":12},"      OTHER",0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+AE25","v":12},"      OTHER",0,0,0,0,0,-0.32300000000000001,0,0,null,null,{"$f":"1+AQ25","v":12},"      OTHER",0,0,0,0,1918.1790000000001,-0.86599999999999999,0,0,0,null,null,{"$f":"1+BD25","v":12},"      OTHER",0,0,0,-504.30799999999999,0,0,0,0,0,0,null,null,{"$f":"1+BR25","v":12},"      OTHER",0,0,0,0,-1.13517,0,0,0,null,{"$f":"SUM(F26:N26,S26:AB26,AG26:AN26,AS26:BA26,BF26:BP26,BT26:CB26)","v":3993.7728300000003},{"$f":"E26+CC26","v":102169.45918000001}]
[null,null,{"$f":"1+C26","v":10},"  TOTAL TRANSMISSION EXPENSES",{"$f":"SUM(E25:E26)","v":104373.32235},114.14400000000001,-24.859000000000002,-139.64455880535601,0,{"$f":"SUM(J25:J26)","v":0},{"$f":"SUM(K25:K26)","v":2740.1770000000001},{"$f":"SUM(L25:L26)","v":-157.95099999999999},{"$f":"SUM(M25:M26)","v":0},0,null,null,{"$f":"1+Q26","v":13},"  TOTAL TRANSMISSION EXPENSES",{"$f":"SUM(S25:S26)","v":0},{"$f":"SUM(T25:T26)","v":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,{"$f":"SUM(AA25:AA26)","v":0},0,null,null,{"$f":"1+AE26","v":13},"  TOTAL TRANSMISSION EXPENSES",{"$f":"SUM(AG25:AG26)","v":0},{"$f":"SUM(AH25:AH26)","v":0},{"$f":"SUM(AI25:AI26)","v":0},0,{"$f":"SUM(AK25:AK26)","v":0},{"$f":"SUM(AL25:AL26)","v":-0.32300000000000001},0,{"$f":"SUM(AN25:AN26)","v":0},null,null,{"$f":"1+AQ26","v":13},"  TOTAL TRANSMISSION EXPENSES",{"$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":1918.1790000000001},-0.86599999999999999,{"$f":"SUM(AY25:AY26)","v":0},{"$f":"SUM(AZ25:AZ26)","v":0},0,null,null,{"$f":"1+BD26","v":13},"  TOTAL TRANSMISSION EXPENSES",{"$f":"SUM(BF25:BF26)","v":0},0,{"$f":"SUM(BH25:BH26)","v":0},{"$f":"SUM(BI25:BI26)","v":-504.30799999999999},{"$f":"SUM(BJ25:BJ26)","v":0},{"$f":"SUM(BK25:BK26)","v":0},{"$f":"SUM(BL25:BL26)","v":0},0,0,{"$f":"SUM(BO25:BO26)","v":0},null,null,{"$f":"1+BR26","v":13},"  TOTAL TRANSMISSION EXPENSES",{"$f":"SUM(BT25:BT26)","v":0},0,{"$f":"SUM(BV25:BV26)","v":0},{"$f":"SUM(BW25:BW26)","v":0},{"$f":"SUM(BX25:BX26)","v":-1.13517},0,0,0,null,{"$f":"SUM(CC25:CC26)","v":3943.4132711946445},{"$f":"SUM(CD25:CD26)","v":108316.73562119465}]
[]
[null,null,null,"  REGIONAL MARKET EXPENSES:",null,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,null,"  REGIONAL MARKET EXPENSES:",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,null,"  REGIONAL MARKET EXPENSES:"]
[null,null,{"$f":"1+C27","v":11},"      LABOR",0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+Q27","v":14},"      LABOR",0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+AE27","v":14},"      LABOR",0,0,0,0,0,0,0,0,null,null,{"$f":"1+AQ27","v":14},"      LABOR",0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+BD27","v":14},"      LABOR",0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+BR27","v":14},"      LABOR",0,0,0,0,0,0,0,0,null,{"$f":"SUM(F30:N30,S30:AB30,AG30:AN30,AS30:BA30,BF30:BP30,BT30:CB30)","v":0},{"$f":"E30+CC30","v":0}]
[null,null,{"$f":"1+C30","v":12},"      OTHER",7329.3331399999997,0,0,0,0,0,-653.03399999999999,0,0,0,null,null,{"$f":"1+Q30","v":15},"      OTHER",0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+AE30","v":15},"      OTHER",0,0,0,0,0,0,0,0,null,null,{"$f":"1+AQ30","v":15},"      OTHER",0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+BD30","v":15},"      OTHER",0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+BR30","v":15},"      OTHER",0,0,0,0,0,0,0,0,null,{"$f":"SUM(F31:N31,S31:AB31,AG31:AN31,AS31:BA31,BF31:BP31,BT31:CB31)","v":-653.03399999999999},{"$f":"E31+CC31","v":6676.2991400000001}]
[null,null,{"$f":"1+C31","v":13},"  TOTAL REGIONAL MARKET EXPENSES",{"$f":"SUM(E30:E31)","v":7329.3331399999997},0,0,0,0,{"$f":"SUM(J30:J31)","v":0},{"$f":"SUM(K30:K31)","v":-653.03399999999999},{"$f":"SUM(L30:L31)","v":0},{"$f":"SUM(M30:M31)","v":0},0,null,null,{"$f":"1+Q31","v":16},"  TOTAL REGIONAL MARKET EXPENSES",{"$f":"SUM(S30:S31)","v":0},{"$f":"SUM(T30:T31)","v":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,{"$f":"SUM(AA30:AA31)","v":0},0,null,null,{"$f":"1+AE31","v":16},"  TOTAL REGIONAL MARKET EXPENSES",{"$f":"SUM(AG30:AG31)","v":0},{"$f":"SUM(AH30:AH31)","v":0},{"$f":"SUM(AI30:AI31)","v":0},0,{"$f":"SUM(AK30:AK31)","v":0},{"$f":"SUM(AL30:AL31)","v":0},0,{"$f":"SUM(AN30:AN31)","v":0},null,null,{"$f":"1+AQ31","v":16},"  TOTAL REGIONAL MARKET EXPENSES",{"$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},0,{"$f":"SUM(AY30:AY31)","v":0},{"$f":"SUM(AZ30:AZ31)","v":0},0,null,null,{"$f":"1+BD31","v":16},"  TOTAL REGIONAL MARKET EXPENSES",{"$f":"SUM(BF30:BF31)","v":0},0,{"$f":"SUM(BH30:BH31)","v":0},{"$f":"SUM(BI30:BI31)","v":0},{"$f":"SUM(BJ30:BJ31)","v":0},{"$f":"SUM(BK30:BK31)","v":0},{"$f":"SUM(BL30:BL31)","v":0},0,0,0,null,null,{"$f":"1+BR31","v":16},"  TOTAL REGIONAL MARKET EXPENSES",{"$f":"SUM(BT30:BT31)","v":0},0,{"$f":"SUM(BV30:BV31)","v":0},{"$f":"SUM(BW30:BW31)","v":0},{"$f":"SUM(BX30:BX31)","v":0},0,0,0,null,{"$f":"SUM(CC30:CC31)","v":-653.03399999999999},{"$f":"SUM(CD30:CD31)","v":6676.2991400000001}]
[]
[null,null,null,"  DISTRIBUTION EXPENSES:",null,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,null,"  DISTRIBUTION EXPENSES:",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,null,"  DISTRIBUTION EXPENSES:"]
[null,null,{"$f":"1+C32","v":14},"      LABOR",63117.090939999995,1318.973,-253.16300000000001,-431.69485750037813,0,0,0,0,0,0,null,null,{"$f":"1+Q32","v":17},"      LABOR",0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+AE32","v":17},"      LABOR",0,0,0,0,0,0,0,0,null,null,{"$f":"1+AQ32","v":17},"      LABOR",0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+BD32","v":17},"      LABOR",0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+BR32","v":17},"      LABOR",0,0,0,0,0,0,0,0,null,{"$f":"SUM(F35:N35,S35:AB35,AG35:AN35,AS35:BA35,BF35:BP35,BT35:CB35)","v":634.11514249962181},{"$f":"E35+CC35","v":63751.206082499615}]
[null,null,{"$f":"1+C35","v":15},"      OTHER",78878.010280000002,0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+Q35","v":18},"      OTHER",0,0,0,0,0,0,0,0,-531.78099999999995,1617.848,null,null,{"$f":"1+AE35","v":18},"      OTHER",-1577.384,0,0,0,0,-0.157,0,0,null,null,{"$f":"1+AQ35","v":18},"      OTHER",0,0,0,0,0,-3.4279999999999999,0,0,0,null,null,{"$f":"1+BD35","v":18},"      OTHER",0,0,0,12.622,0,0,0,0,0,0,null,null,{"$f":"1+BR35","v":18},"      OTHER",0,0,-3.0463,0,-1.9011900000000002,0,0,0,null,{"$f":"SUM(F36:N36,S36:AB36,AG36:AN36,AS36:BA36,BF36:BP36,BT36:CB36)","v":-487.22748999999993},{"$f":"E36+CC36","v":78390.782789999997}]
[null,null,{"$f":"1+C36","v":16},"  TOTAL DISTRIBUTION EXPENSES",{"$f":"SUM(E35:E36)","v":141995.10122000001},1318.973,-253.16300000000001,-431.69485750037813,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},0,null,null,{"$f":"1+Q36","v":19},"  TOTAL DISTRIBUTION EXPENSES",{"$f":"SUM(S35:S36)","v":0},{"$f":"SUM(T35:T36)","v":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,{"$f":"SUM(AA35:AA36)","v":-531.78099999999995},1617.848,null,null,{"$f":"1+AE36","v":19},"  TOTAL DISTRIBUTION EXPENSES",{"$f":"SUM(AG35:AG36)","v":-1577.384},{"$f":"SUM(AH35:AH36)","v":0},{"$f":"SUM(AI35:AI36)","v":0},0,{"$f":"SUM(AK35:AK36)","v":0},-0.157,0,{"$f":"SUM(AN35:AN36)","v":0},null,null,{"$f":"1+AQ36","v":19},"  TOTAL DISTRIBUTION EXPENSES",{"$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},-3.4279999999999999,{"$f":"SUM(AY35:AY36)","v":0},{"$f":"SUM(AZ35:AZ36)","v":0},0,null,null,{"$f":"1+BD36","v":19},"  TOTAL DISTRIBUTION EXPENSES",{"$f":"SUM(BF35:BF36)","v":0},0,{"$f":"SUM(BH35:BH36)","v":0},{"$f":"SUM(BI35:BI36)","v":12.622},{"$f":"SUM(BJ35:BJ36)","v":0},{"$f":"SUM(BK35:BK36)","v":0},{"$f":"SUM(BL35:BL36)","v":0},0,0,0,null,null,{"$f":"1+BR36","v":19},"  TOTAL DISTRIBUTION EXPENSES",{"$f":"SUM(BT35:BT36)","v":0},0,{"$f":"SUM(BV35:BV36)","v":-3.0463},{"$f":"SUM(BW35:BW36)","v":0},{"$f":"SUM(BX35:BX36)","v":-1.9011900000000002},0,0,0,null,{"$f":"SUM(CC35:CC36)","v":146.88765249962188},{"$f":"SUM(CD35:CD36)","v":142141.98887249961}]
[]
[null,null,null,"  CUSTOMER ACCOUNTING EXPENSES:",null,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,null,"  CUSTOMER ACCOUNTING EXPENSES:",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,null,"  CUSTOMER ACCOUNTING EXPENSES:"]
[null,null,{"$f":"1+C37","v":17},"      LABOR",21077.866999999998,457.04700000000003,-84.543000000000006,-131.22375101263026,0,0,0,0,0,0,null,null,{"$f":"1+Q37","v":20},"      LABOR",0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+AE37","v":20},"      LABOR",0,0,0,0,0,0,0,0,null,null,{"$f":"1+AQ37","v":20},"      LABOR",0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+BD37","v":20},"      LABOR",0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+BR37","v":20},"      LABOR",0,0,0,0,0,0,0,0,null,{"$f":"SUM(F40:N40,S40:AB40,AG40:AN40,AS40:BA40,BF40:BP40,BT40:CB40)","v":241.28024898736976},{"$f":"E40+CC40","v":21319.147248987367}]
[null,null,{"$f":"1+C40","v":18},"      OTHER",43501.552320000003,0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+Q40","v":21},"      OTHER",0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+AE40","v":21},"      OTHER",0,763.70299999999997,0,0,-6545.616,-4.42,0,0,null,null,{"$f":"1+AQ40","v":21},"      OTHER",0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+BD40","v":21},"      OTHER",0,0,0,0.79100000000000004,0,0,0,4287.7768889460858,0,0,null,null,{"$f":"1+BR40","v":21},"      OTHER",0,-5098.4030000000002,0,0,0,98.201999999999998,0,0,null,{"$f":"SUM(F41:N41,S41:AB41,AG41:AN41,AS41:BA41,BF41:BP41,BT41:CB41)","v":-6497.9661110539146},{"$f":"E41+CC41","v":37003.586208946086}]
[null,null,{"$f":"1+C41","v":19},"  TOTAL CUSTOMER ACCOUNTING EXPENSES",{"$f":"SUM(E40:E41)","v":64579.419320000001},457.04700000000003,-84.543000000000006,-131.22375101263026,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},0,null,null,{"$f":"1+Q41","v":22},"  TOTAL CUSTOMER ACCOUNTING EXPENSES",{"$f":"SUM(S40:S41)","v":0},{"$f":"SUM(T40:T41)","v":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,{"$f":"SUM(AA40:AA41)","v":0},0,null,null,{"$f":"1+AE41","v":22},"  TOTAL CUSTOMER ACCOUNTING EXPENSES",{"$f":"SUM(AG40:AG41)","v":0},{"$f":"SUM(AH40:AH41)","v":763.70299999999997},{"$f":"SUM(AI40:AI41)","v":0},0,{"$f":"SUM(AK40:AK41)","v":-6545.616},-4.42,0,{"$f":"SUM(AN40:AN41)","v":0},null,null,{"$f":"1+AQ41","v":22},"  TOTAL CUSTOMER ACCOUNTING EXPENSES",{"$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},0,{"$f":"SUM(AY40:AY41)","v":0},{"$f":"SUM(AZ40:AZ41)","v":0},0,null,null,{"$f":"1+BD41","v":22},"  TOTAL CUSTOMER ACCOUNTING EXPENSES",{"$f":"SUM(BF40:BF41)","v":0},0,{"$f":"SUM(BH40:BH41)","v":0},{"$f":"SUM(BI40:BI41)","v":0.79100000000000004},{"$f":"SUM(BJ40:BJ41)","v":0},{"$f":"SUM(BK40:BK41)","v":0},{"$f":"SUM(BL40:BL41)","v":0},4287.7768889460858,0,0,null,null,{"$f":"1+BR41","v":22},"  TOTAL CUSTOMER ACCOUNTING EXPENSES",{"$f":"SUM(BT40:BT41)","v":0},-5098.4030000000002,{"$f":"SUM(BV40:BV41)","v":0},{"$f":"SUM(BW40:BW41)","v":0},{"$f":"SUM(BX40:BX41)","v":0},98.201999999999998,0,0,null,{"$f":"SUM(CC40:CC41)","v":-6256.6858620665444},{"$f":"SUM(CD40:CD41)","v":58322.733457933457}]
[]
[null,null,null,"  CUSTOMER SERV. & INFO. EXPENSES:",null,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,null,"  CUSTOMER SERV. & INFO. EXPENSES:",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,null,"  CUSTOMER SERV. & INFO. EXPENSES:"]
["SCHEDULE MJL-S11-1",null,{"$f":"1+C42","v":20},"      LABOR",6936.5230000000001,105.477,-27.821999999999999,-171.82558557102396,0,0,0,0,0,0,"SCHEDULE MJL-S11-2",null,{"$f":"1+Q42","v":23},"      LABOR",0,0,0,0,0,0,0,0,0,0,"SCHEDULE MJL-S11-3",null,{"$f":"1+AE42","v":23},"      LABOR",0,0,0,0,0,0,0,0,"SCHEDULE MJL-S11-4",null,{"$f":"1+AQ42","v":23},"      LABOR",0,0,0,0,0,0,0,0,0,"SCHEDULE MJL-S11-5",null,{"$f":"1+BD42","v":23},"      LABOR",0,0,0,0,0,0,0,0,0,0,"SCHEDULE MJL-S11-6",null,{"$f":"1+BR42","v":23},"      LABOR",0,0,0,0,0,0,0,0,null,{"$f":"SUM(F45:N45,S45:AB45,AG45:AN45,AS45:BA45,BF45:BP45,BT45:CB45)","v":-94.170585571023963},{"$f":"E45+CC45","v":6842.3524144289759}]
[null,null,{"$f":"1+C45","v":21},"      OTHER",79410.357869999993,0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+Q45","v":24},"      OTHER",0,0,0,0,0,0,-5961.1949999999997,1337.65,0,0,null,null,{"$f":"1+AE45","v":24},"      OTHER",0,0,-69518.870999999999,0,0,-0.13500000000000001,0,0,null,null,{"$f":"1+AQ45","v":24},"      OTHER",0,0,0,0,2937.306,-0.51900000000000002,0,0,0,null,null,{"$f":"1+BD45","v":24},"      OTHER",0,0,0,1.431,0,0,0,0,0,0,null,null,{"$f":"1+BR45","v":24},"      OTHER",0,0,-0.64064999999999994,-119.38200000000001,0,0,0,0,null,{"$f":"SUM(F46:N46,S46:AB46,AG46:AN46,AS46:BA46,BF46:BP46,BT46:CB46)","v":-71324.355649999998},{"$f":"E46+CC46","v":8086.0022199999948}]
[null,null,{"$f":"1+C46","v":22},"  TOTAL CUSTOMER SERV. & INFO. EXPENSES",{"$f":"SUM(E45:E46)","v":86346.880869999994},105.477,-27.821999999999999,-171.82558557102396,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},0,null,null,{"$f":"1+Q46","v":25},"  TOTAL CUSTOMER SERV. & INFO. EXPENSES",{"$f":"SUM(S45:S46)","v":0},{"$f":"SUM(T45:T46)","v":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":-5961.1949999999997},1337.65,{"$f":"SUM(AA45:AA46)","v":0},0,null,null,{"$f":"1+AE46","v":25},"  TOTAL CUSTOMER SERV. & INFO. EXPENSES",{"$f":"SUM(AG45:AG46)","v":0},{"$f":"SUM(AH45:AH46)","v":0},{"$f":"SUM(AI45:AI46)","v":-69518.870999999999},0,{"$f":"SUM(AK45:AK46)","v":0},-0.13500000000000001,0,{"$f":"SUM(AN45:AN46)","v":0},null,null,{"$f":"1+AQ46","v":25},"  TOTAL CUSTOMER SERV. & INFO. EXPENSES",{"$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":2937.306},-0.51900000000000002,{"$f":"SUM(AY45:AY46)","v":0},{"$f":"SUM(AZ45:AZ46)","v":0},0,null,null,{"$f":"1+BD46","v":25},"  TOTAL CUSTOMER SERV. & INFO. EXPENSES",{"$f":"SUM(BF45:BF46)","v":0},0,{"$f":"SUM(BH45:BH46)","v":0},{"$f":"SUM(BI45:BI46)","v":1.431},{"$f":"SUM(BJ45:BJ46)","v":0},{"$f":"SUM(BK45:BK46)","v":0},{"$f":"SUM(BL45:BL46)","v":0},0,0,{"$f":"SUM(BO45:BO46)","v":0},null,null,{"$f":"1+BR46","v":25},"  TOTAL CUSTOMER SERV. & INFO. EXPENSES",{"$f":"SUM(BT45:BT46)","v":0},0,{"$f":"SUM(BV45:BV46)","v":-0.64064999999999994},{"$f":"SUM(BW45:BW46)","v":-119.38200000000001},{"$f":"SUM(BX45:BX46)","v":0},0,0,0,null,{"$f":"SUM(CC45:CC46)","v":-71418.526235571015},{"$f":"SUM(CD45:CD46)","v":14928.354634428972}]
[]
[null,null,null,"  SALES EXPENSES:",null,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,null,"  SALES EXPENSES:",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,null,"  SALES EXPENSES:"]
[null,null,{"$f":"1+C47","v":23},"      LABOR",184.50399999999999,3.0190000000000001,-0.74,0,0,0,0,0,0,0,null,null,{"$f":"1+Q47","v":26},"      LABOR",0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+AE47","v":26},"      LABOR",0,0,0,0,0,0,0,0,null,null,{"$f":"1+AQ47","v":26},"      LABOR",0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+BD47","v":26},"      LABOR",0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+BR47","v":26},"      LABOR",0,0,0,0,0,0,0,0,null,{"$f":"SUM(F50:N50,S50:AB50,AG50:AN50,AS50:BA50,BF50:BP50,BT50:CB50)","v":2.2789999999999999},{"$f":"E50+CC50","v":186.78299999999999}]
[null,null,{"$f":"1+C50","v":24},"      OTHER",95.137540000000001,0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+Q50","v":27},"      OTHER",0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+AE50","v":27},"      OTHER",0,0,0,0,0,0,0,0,null,null,{"$f":"1+AQ50","v":27},"      OTHER",0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+BD50","v":27},"      OTHER",0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+BR50","v":27},"      OTHER",0,0,0,0,0,0,0,0,null,{"$f":"SUM(F51:N51,S51:AB51,AG51:AN51,AS51:BA51,BF51:BP51,BT51:CB51)","v":0},{"$f":"E51+CC51","v":95.137540000000001}]
[null,null,{"$f":"1+C51","v":25},"  TOTAL SALES EXPENSES",{"$f":"SUM(E50:E51)","v":279.64153999999996},3.0190000000000001,-0.74,0,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},0,null,null,{"$f":"1+Q51","v":28},"  TOTAL SALES EXPENSES",{"$f":"SUM(S50:S51)","v":0},{"$f":"SUM(T50:T51)","v":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,{"$f":"SUM(AA50:AA51)","v":0},0,null,null,{"$f":"1+AE51","v":28},"  TOTAL SALES EXPENSES",{"$f":"SUM(AG50:AG51)","v":0},{"$f":"SUM(AH50:AH51)","v":0},{"$f":"SUM(AI50:AI51)","v":0},0,{"$f":"SUM(AK50:AK51)","v":0},{"$f":"SUM(AL50:AL51)","v":0},0,{"$f":"SUM(AN50:AN51)","v":0},null,null,{"$f":"1+AQ51","v":28},"  TOTAL SALES EXPENSES",{"$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},0,{"$f":"SUM(AY50:AY51)","v":0},{"$f":"SUM(AZ50:AZ51)","v":0},0,null,null,{"$f":"1+BD51","v":28},"  TOTAL SALES EXPENSES",{"$f":"SUM(BF50:BF51)","v":0},0,{"$f":"SUM(BH50:BH51)","v":0},{"$f":"SUM(BI50:BI51)","v":0},{"$f":"SUM(BJ50:BJ51)","v":0},{"$f":"SUM(BK50:BK51)","v":0},{"$f":"SUM(BL50:BL51)","v":0},0,0,0,null,null,{"$f":"1+BR51","v":28},"  TOTAL SALES EXPENSES",{"$f":"SUM(BT50:BT51)","v":0},0,{"$f":"SUM(BV50:BV51)","v":0},{"$f":"SUM(BW50:BW51)","v":0},{"$f":"SUM(BX50:BX51)","v":0},0,0,0,null,{"$f":"SUM(CC50:CC51)","v":2.2789999999999999},{"$f":"SUM(CD50:CD51)","v":281.92053999999996}]
[]
[null,null,null,"  ADMINISTRATIVE & GENERAL EXPENSES:",null,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,null,"  ADMINISTRATIVE & GENERAL EXPENSES:",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,null,"  ADMINISTRATIVE & GENERAL EXPENSES:"]
[null,null,{"$f":"1+C52","v":26},"      LABOR",68835.903539999985,1070.837,-276.101,-3240.3310702025697,-1071.3989999999999,0,0,0,0,0,null,null,{"$f":"1+Q52","v":29},"      LABOR",0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+AE52","v":29},"      LABOR",0,0,0,0,0,0,0,0,null,null,{"$f":"1+AQ52","v":29},"      LABOR",0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+BD52","v":29},"      LABOR",0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+BR52","v":29},"      LABOR",0,0,0,0,0,0,0,0,null,{"$f":"SUM(F55:N55,S55:AB55,AG55:AN55,AS55:BA55,BF55:BP55,BT55:CB55)","v":-3516.9940702025697},{"$f":"E55+CC55","v":65318.909469797414}]
[null,null,{"$f":"1+C55","v":27},"      OTHER",123773.35662999998,0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+Q55","v":30},"      OTHER",0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+AE55","v":30},"      OTHER",0,0,0,0,0,-124.85299999999999,621.05799999999999,3563.2539999999999,null,null,{"$f":"1+AQ55","v":30},"      OTHER",-1533.9580000000001,438.76,2180.5970000000002,7329.2780000000002,0,-5.9859999999999998,139.64699999999999,-625.13800000000003,-361.85300000000001,null,null,{"$f":"1+BD55","v":30},"      OTHER",-12.095000000000001,-2819.8580000000002,-319.39600000000002,612.32399999999996,-2166.654,11458.268,10.837,0,1.04762,79.77,null,null,{"$f":"1+BR55","v":30},"      OTHER",769.88499999999999,0,-276.22440999999998,-43.5,-83.09499000000001,0,-1572.1469999999999,542.35299999999995,null,{"$f":"SUM(F56:N56,S56:AB56,AG56:AN56,AS56:BA56,BF56:BP56,BT56:CB56)","v":17802.321219999998},{"$f":"E56+CC56","v":141575.67784999998}]
[null,null,{"$f":"1+C56","v":28},"  TOTAL ADMINISTRATIVE & GENERAL EXPENSES",{"$f":"SUM(E55:E56)","v":192609.26016999997},1070.837,-276.101,-3240.3310702025697,-1071.3989999999999,{"$f":"SUM(J55:J56)","v":0},{"$f":"SUM(K55:K56)","v":0},{"$f":"SUM(L55:L56)","v":0},{"$f":"SUM(M55:M56)","v":0},0,null,null,{"$f":"1+Q56","v":31},"  TOTAL ADMINISTRATIVE & GENERAL EXPENSES",{"$f":"SUM(S55:S56)","v":0},{"$f":"SUM(T55:T56)","v":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,{"$f":"SUM(AA55:AA56)","v":0},{"$f":"SUM(AB55:AB56)","v":0},null,null,{"$f":"1+AE56","v":31},"  TOTAL ADMINISTRATIVE & GENERAL EXPENSES",{"$f":"SUM(AG55:AG56)","v":0},{"$f":"SUM(AH55:AH56)","v":0},{"$f":"SUM(AI55:AI56)","v":0},0,{"$f":"SUM(AK55:AK56)","v":0},{"$f":"SUM(AL55:AL56)","v":-124.85299999999999},621.05799999999999,{"$f":"SUM(AN55:AN56)","v":3563.2539999999999},null,null,{"$f":"1+AQ56","v":31},"  TOTAL ADMINISTRATIVE & GENERAL EXPENSES",{"$f":"SUM(AS55:AS56)","v":-1533.9580000000001},{"$f":"SUM(AT55:AT56)","v":438.76},{"$f":"SUM(AU55:AU56)","v":2180.5970000000002},7329.2780000000002,{"$f":"SUM(AW55:AW56)","v":0},{"$f":"SUM(AX55:AX56)","v":-5.9859999999999998},139.64699999999999,-625.13800000000003,{"$f":"SUM(BA55:BA56)","v":-361.85300000000001},null,null,{"$f":"1+BD56","v":31},"  TOTAL ADMINISTRATIVE & GENERAL EXPENSES",{"$f":"SUM(BF55:BF56)","v":-12.095000000000001},-2819.8580000000002,{"$f":"SUM(BH55:BH56)","v":-319.39600000000002},{"$f":"SUM(BI55:BI56)","v":612.32399999999996},{"$f":"SUM(BJ55:BJ56)","v":-2166.654},{"$f":"SUM(BK55:BK56)","v":11458.268},{"$f":"SUM(BL55:BL56)","v":10.837},0,1.04762,79.77,null,null,{"$f":"1+BR56","v":31},"  TOTAL ADMINISTRATIVE & GENERAL EXPENSES",{"$f":"SUM(BT55:BT56)","v":769.88499999999999},0,{"$f":"SUM(BV55:BV56)","v":-276.22440999999998},{"$f":"SUM(BW55:BW56)","v":-43.5},{"$f":"SUM(BX55:BX56)","v":-83.09499000000001},0,{"$f":"SUM(BZ55:BZ56)","v":-1572.1469999999999},{"$f":"SUM(CA55:CA56)","v":542.35299999999995},null,{"$f":"SUM(CC55:CC56)","v":14285.327149797427},{"$f":"SUM(CD55:CD56)","v":206894.5873197974}]
[]
[null,null,{"$f":"1+C57","v":29},"TOTAL OPERATIONS & MAINTENANCE EXPENSES",{"$f":"E22+E27+E32+E37+E42+E47+E52+E57","v":1446015.5434999999},{"$f":"F22+F27+F32+F37+F42+F47+F52+F57","v":7176.2040000000015},-1486.7570000000001,-5691.6511900000005,-1071.3989999999999,{"$f":"J22+J27+J32+J37+J42+J47+J52+J57","v":65738.41462000001},{"$f":"K22+K27+K32+K37+K42+K47+K52+K57","v":-5442.4703333332982},{"$f":"L22+L27+L32+L37+L42+L47+L52+L57","v":-157.95099999999999},{"$f":"M22+M27+M32+M37+M42+M47+M52+M57","v":21272.217000000001},9423.9189999999999,null,null,{"$f":"1+Q57","v":32},"TOTAL OPERATIONS & MAINTENANCE EXPENSES",{"$f":"S22+S27+S32+S37+S42+S47+S52+S57","v":-2062.4430000000002},{"$f":"T22+T27+T32+T37+T42+T47+T52+T57","v":49056.597999999998},{"$f":"U22+U27+U32+U37+U42+U47+U52+U57","v":25696.653999999999},{"$f":"V22+V27+V32+V37+V42+V47+V52+V57","v":-265.55164000000002},{"$f":"W22+W27+W32+W37+W42+W47+W52+W57","v":3259.8629999999998},{"$f":"X22+X27+X32+X37+X42+X47+X52+X57","v":-621.32100000000003},{"$f":"Y22+Y27+Y32+Y37+Y42+Y47+Y52+Y57","v":-5961.1949999999997},1337.65,{"$f":"AA22+AA27+AA32+AA37+AA42+AA47+AA52+AA57","v":-925.21766000000002},1617.848,null,null,{"$f":"1+AE57","v":32},"TOTAL OPERATIONS & MAINTENANCE EXPENSES",{"$f":"AG22+AG27+AG32+AG37+AG42+AG47+AG52+AG57","v":-1577.384},{"$f":"AH22+AH27+AH32+AH37+AH42+AH47+AH52+AH57","v":763.70299999999997},-69518.870999999999,{"$f":"AJ22+AJ27+AJ32+AJ37+AJ42+AJ47+AJ52+AJ57","v":0},-6545.616,{"$f":"AL22+AL27+AL32+AL37+AL42+AL47+AL52+AL57","v":-143.173},621.05799999999999,{"$f":"AN22+AN27+AN32+AN37+AN42+AN47+AN52+AN57","v":3563.2539999999999},null,null,{"$f":"1+AQ57","v":32},"TOTAL OPERATIONS & MAINTENANCE EXPENSES",{"$f":"AS22+AS27+AS32+AS37+AS42+AS47+AS52+AS57","v":-1533.9580000000001},{"$f":"AT22+AT27+AT32+AT37+AT42+AT47+AT52+AT57","v":438.76},{"$f":"AU22+AU27+AU32+AU37+AU42+AU47+AU52+AU57","v":2180.5970000000002},7329.2780000000002,{"$f":"AW22+AW27+AW32+AW37+AW42+AW47+AW52+AW57","v":23090.749},{"$f":"AX22+AX27+AX32+AX37+AX42+AX47+AX52+AX57","v":-15.206},139.64699999999999,-625.13800000000003,{"$f":"BA22+BA27+BA32+BA37+BA42+BA47+BA52+BA57","v":-361.85300000000001},null,null,{"$f":"1+BD57","v":32},"TOTAL OPERATIONS & MAINTENANCE EXPENSES",-12.095000000000001,{"$f":"BG22+BG27+BG32+BG37+BG42+BG47+BG52+BG57","v":-2819.8580000000002},{"$f":"BH22+BH27+BH32+BH37+BH42+BH47+BH52+BH57","v":-319.39600000000002},{"$f":"BI22+BI27+BI32+BI37+BI42+BI47+BI52+BI57","v":122.85999999999996},{"$f":"BJ22+BJ27+BJ32+BJ37+BJ42+BJ47+BJ52+BJ57","v":-7212.3880000000008},{"$f":"BK22+BK27+BK32+BK37+BK42+BK47+BK52+BK57","v":11458.268},{"$f":"BL22+BL27+BL32+BL37+BL42+BL47+BL52+BL57","v":10.837},4287.7768889460858,1.04762,79.77,null,null,{"$f":"1+BR57","v":32},"TOTAL OPERATIONS & MAINTENANCE EXPENSES",{"$f":"BT22+BT27+BT32+BT37+BT42+BT47+BT52+BT57","v":769.88499999999999},-5098.4030000000002,{"$f":"BV22+BV27+BV32+BV37+BV42+BV47+BV52+BV57","v":-283.37268999999998},{"$f":"BW22+BW27+BW32+BW37+BW42+BW47+BW52+BW57","v":-162.88200000000001},{"$f":"BX22+BX27+BX32+BX37+BX42+BX47+BX52+BX57","v":-86.131350000000012},98.201999999999998,{"$f":"BZ22+BZ27+BZ32+BZ37+BZ42+BZ47+BZ52+BZ57","v":-1572.1469999999999},{"$f":"CA22+CA27+CA32+CA37+CA42+CA47+CA52+CA57","v":542.35299999999995},null,{"$f":"CC22+CC27+CC32+CC37+CC42+CC47+CC52+CC57","v":118503.58426561276},{"$f":"CD22+CD27+CD32+CD37+CD42+CD47+CD52+CD57","v":1564519.1277656124}]
[]
[null,null,{"$f":"1+C59","v":30},"NOTE: See SCHEDULE MJL-S11-7 for explanation of the pro forma adjustments.",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"1+Q59","v":33},{"$f":"D61","v":"NOTE: See SCHEDULE MJL-S11-7 for explanation of the pro forma adjustments."},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"1+AE59","v":33},{"$f":"D61","v":"NOTE: See SCHEDULE MJL-S11-7 for explanation of the pro forma adjustments."},null,null,null,null,null,null,null,null,null,null,{"$f":"1+AQ59","v":33},{"$f":"D61","v":"NOTE: See SCHEDULE MJL-S11-7 for explanation of the pro forma adjustments."},null,null,null,null,null,null,null,null,null,null,null,{"$f":"1+BD59","v":33},{"$f":"D61","v":"NOTE: See SCHEDULE MJL-S11-7 for explanation of the pro forma adjustments."},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"1+BR59","v":33},{"$f":"D61","v":"NOTE: See SCHEDULE MJL-S11-7 for explanation of the pro forma adjustments."}]

{"sheet":"SCHEDULE MJL-S11-7","index":11,"n_rows":131,"n_cols":12,"rows_kept":131,"cut":false,"hidden":false,"merged":[[0,0,0,11],[2,0,2,11],[1,0,1,11],[6,2,6,9],[3,0,3,11],[4,0,4,11],[28,2,28,9],[49,2,49,9],[70,2,71,9],[30,2,30,9],[18,2,18,9],[32,2,32,9],[7,2,7,9],[9,2,11,9],[16,2,16,9],[13,2,14,9],[23,2,24,9],[73,2,73,9],[21,2,21,9],[94,2,94,9],[88,2,88,9],[34,2,34,9],[41,2,41,9],[48,2,48,9],[35,2,35,9],[89,2,89,9],[86,2,86,9],[47,2,47,9],[83,2,84,9],[75,2,75,9],[66,2,66,9],[77,2,77,9],[26,2,26,9]]}
["AMEREN MISSOURI"]
["ELECTRIC OPERATING AND MAINTENANCE EXPENSE"]
["ADJUSTMENTS"]
[{"$f":"'SCHEDULE MJL-S13-2'!A4:K4","v":"FOR THE TWELVE MONTHS ENDED DECEMBER 31, 2020 AND AS TRUED UP"}]
["($000)"]
[null,"PRO FORMA",null,null,null,null,null,null,null,null,null,"TOTAL"]
[null,"ITEM NO.","DESCRIPTION",null,null,null,null,null,null,null,null,"AMOUNT"]
[null,"(A)","(B)",null,null,null,null,null,null,null,null,"(C)"]
[]
[null,-1,"Increased labor expense from annualizing the average 1.83% wage increase for management employees effective January 1, 2021, and the 2.50% wage increase for the Company's union employees effective January 1, 2021 per the labor contracts. ",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-S11-1'!F59","v":7176.2040000000015}]
[]
[]
[]
[null,-2,"Decrease the incentive compensation expense for the incentive compensation applicable to AMS and Ameren Missouri officers earnings per share targets.",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-S11-1'!G59","v":-1486.7570000000001}]
[]
[]
[null,-3,"Eliminate the long term incentive compensation expense related to earnings per share targets.",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-S11-1'!H59","v":-5691.6511900000005}]
[]
[null,"(4)","Decrease administrative and general expenses for staffing annualization of salary. ",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-S11-1'!I59","v":-1071.3989999999999}]
[]
[]
[null,-5,"Increase in fuel expense to reflect the normalized sales and customer growth through September 30, 2021.",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-S11-1'!J59","v":65738.41462000001}]
[]
[null,-6,"Decrease in purchased power expense to reflect normalized sales and customer growth through September 30, 2021 and normalized power prices.",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-S11-1'!K59","v":-5442.4703333332982}]
[]
[]
[null,-7,"Decrease in transmission expense related to Mark Twain Transmission project.",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-S11-1'!L59","v":-157.95099999999999}]
[]
[null,-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-S11-1'!M59","v":21272.217000000001}]
[]
[null,-9,"Increase in production expense to normalize steam plant maintenance. ",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-S11-1'!N59","v":9423.9189999999999}]
[]
[null,-10,"Decrease in production expense to establish related Meramec retirement tracker base amount. ",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-S11-1'!S59","v":-2062.4430000000002}]
[]
[null,-11,"Eliminate test year FAC recovery",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-S11-1'!T59","v":49056.597999999998}]
[]
[null,-12,"Increase nuclear production expense to include the annualized amount of the last 3 Callaway",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-S11-1'!U59","v":25696.653999999999}]
[null,null,"Nuclear Plant refueling expenses."]
[]
[null,-13,"Decrease nuclear production expense to eliminate Callaway unplanned outage costs.",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-S11-1'!V59","v":-265.55164000000002}]
[]
[null,-14,"Increase in production expenses for amortization of RES cost regulatory liability.",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-S11-1'!W59","v":3259.8629999999998}]
[]
[null,-15,"Decrease in production expenses for rebase of RES expenses",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-S11-1'!X59","v":-621.32100000000003}]
[]
[null,-16,"Decrease in production expenses to eliminate Solar Rebate amortizations in the test year.",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-S11-1'!Y59","v":-5961.1949999999997}]
[]
[null,-17,"Increase in production expenses for Solar Rebate amortizations.",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-S11-1'!Z59","v":1337.65}]
[]
[null,-18,"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-S11-1'!AA59","v":-925.21766000000002}]
[]
[null,-19,"Increase in distribution expense to normalize storm costs.",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-S11-1'!AB59","v":1617.848}]
[]
[null,-20,"Decrease in distribution expense to normalize vegetation and infrastructure inspections.",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-S11-1'!AG59","v":-1577.384}]
[]
[null,-21,"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-S11-1'!AH59","v":763.70299999999997}]
[null,null,"balance."]
[]
[null,-22,"Decrease in customer service to eliminate test year MEEIA program costs.",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-S11-1'!AI59","v":-69518.870999999999}]
[]
[null,-23,"Intentionally left blank.",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-S11-1'!AJ59","v":0}]
[]
[null,-24,"Decrease in administrative and general expenses to normalize bad debt expense. ",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-S11-1'!AK59","v":-6545.616}]
[]
[null,-25,"Decrease in administrative and general expense for membership dues to be recorded below the line.",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-S11-1'!AL59","v":-143.173}]
[]
[null,-26,"Increase in administrative and general expenses to annualize EEI dues. ",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-S11-1'!AM59","v":621.05799999999999}]
[]
[null,-27,"Annualize insurance expense based upon current insurance premiums.",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-S11-1'!AN59","v":3563.2539999999999}]
[]
[null,-28,"Decrease administrative and general expenses to reflect annualized major medical and other employee benefit expenses through September 30, 2021. ",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-S11-1'!AS59","v":-1533.9580000000001}]
[]
[]
[null,-29,"Increase non-qualified pension expense to reflect current level of expense.",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-S11-1'!AT59","v":438.76}]
[]
[null,-30,"Rebase Pension and OPEB Tracker to true up level. ",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-S11-1'!AU59","v":2180.5970000000002}]
[]
[null,-31,"Increase the amortization of the net regulatory liabilities for Pension and OPEB Tracker.",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-S11-1'!AV59","v":7329.2780000000002}]
[]
[null,"(32)","Increase in operating and maintenance expense for base level expenses related to RESRAM. ",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-S11-1'!AW59","v":23090.749}]
[]
[null,-33,"Reduce expenses for alcohol purchases.",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-S11-1'!AX59","v":-15.206}]
[]
[null,-34,"Increase administrative and general expenses to reflect the 3 case average of expenses to prepare and litigate this rate filings and annualize the amount.",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-S11-1'!AY59","v":139.64699999999999}]
[]
[]
[null,-35,"Decrease administrative and general expenses to annualize MPSC Assessment.",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-S11-1'!AZ59","v":-625.13800000000003}]
[]
[null,-36,"Decrease administrative and general expenses for certain Board of Director meeting expenses.",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-S11-1'!BA59","v":-361.85300000000001}]
[]
[null,-37,"Decrease administrative and general expense to normalize depreciation study expense. ",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-S11-1'!BF59","v":-12.095000000000001}]
[]
[null,-38,"Decrease administrative and general expense to remove Bank of America lease costs.",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-S11-1'!BG59","v":-2819.8580000000002}]
[]
[null,-39,"Decrease administrative and general expenses for software rental expense",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-S11-1'!BH59","v":-319.39600000000002}]
[]
[null,-40,"Increase administrative and general expense to utilize 2021 allocation factors. ",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-S11-1'!BI59","v":122.85999999999996}]
[]
[null,"(41)","Decrease administrative and general expense normalize expense directly impacted by the COVID pandemic. ",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-S11-1'!BJ59","v":-7212.3880000000008}]
[]
[null,"(42)","Increase administrative and general expense to normalize the Company-Owned Life Insurance (COLI) expense. ",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-S11-1'!BK59","v":11458.268}]
[]
[null,"(43)","Increase administrative and general expenses for electric costs allocated to gas.",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-S11-1'!BL59","v":10.837}]
[]
[null,"(44)","Increase in operating and maintenance expense for customer convenience fees. ",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-S11-1'!BM59","v":4287.7768889460858}]
[]
[null,"(45)","Increase administrative and general expense for the EV incentive program.",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-S11-1'!BN59","v":1.04762}]
[]
[null,"(46)","Increase administrative and general expense for non-labor software maintenance costs.",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-S11-1'!BO59","v":79.77}]
[]
[null,"(47)","Increase in building rent expenses charged to AMS and allocated to Ameren Missouri.",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-S11-1'!BT59","v":769.88499999999999}]
[]
[null,"(48)","Decrease automated meter read costs, reduced as a result of automated meter infrastructure investment.",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-S11-1'!BU59","v":-5098.4030000000002}]
[]
[null,"(49)","To remove miscellaneous expenses from the test year.",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-S11-1'!BV59","v":-283.37268999999998}]
[]
[null,"(50)","To remove paperless bill credit expenses.",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-S11-1'!BW59","v":-162.88200000000001}]
[]
[null,"(51)","To remove test year O&M for facilities that are no longer in service at true-up date.",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-S11-1'!BX59","v":-86.131350000000012}]
[]
[null,"(52)","To adjust outside call center costs to a 3 year average.",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-S11-1'!BY59","v":98.201999999999998}]
[]
[null,"(53)","To adjust Rush Island New Source Review Legal Fees to annual levels ending at the true up date.",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-S11-1'!BZ59","v":-1572.1469999999999}]
[]
[null,"(54)","To true-up non-labor cybersecurity costs.",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-S11-1'!CA59","v":542.35299999999995}]
[]
[]
[]
[]
[null,"     Total Adjustments to Electric Operating and Maintenance Expenses"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L10:L130)","v":118503.58426561284}]

{"sheet":"SCHEDULE MJL-S12-1","index":12,"n_rows":60,"n_cols":6,"rows_kept":60,"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-S12-2'!A3","v":"FOR THE TWELVE MONTHS ENDED DECEMBER 31, 2020 AND AS TRUED UP"}]
[null,"($000)"]
[]
[null,null,null,"TOTALS",null,"ADJUSTED"]
[null,null,null,"PER",null,"ELECTRIC"]
[null,"LINE","DESCRIPTION","BOOKS","ADJUSTMENTS(1)","TOTALS"]
[null,null,"(A)","(B)","(C)","(D)"]
[]
[null,null,"DEPRECIATION EXPENSE:"]
[null,{"$f":"1","v":1},"STEAM",169076.66687000002,{"$f":"'SCHEDULE MJL-S12-2'!E15+'SCHEDULE MJL-S12-2'!E28+'SCHEDULE MJL-S12-2'!E45","v":54614.546630000012},{"$f":"SUM(D12:E12)","v":223691.21350000001}]
[null,{"$f":"1+B12","v":2},"NUCLEAR ",78518.149930000014,{"$f":"'SCHEDULE MJL-S12-2'!E16+'SCHEDULE MJL-S12-2'!E29","v":9070.1950699999925},87588.345000000001]
[null,3,"CALLAWAY DECOMMISSIONING ",6758.6049599999997,0,6758.6049599999997]
[null,4,"HYDRAULIC",12404.719369999999,{"$f":"'SCHEDULE MJL-S12-2'!E17+'SCHEDULE MJL-S12-2'!E30","v":2675.6986300000008},15080.418]
[null,5,"OTHER",29816.020559999997,35265.074439999997,65081.094999999994]
[null,6,"TRANSMISSION PLANT",37099.291870000001,{"$f":"'SCHEDULE MJL-S12-2'!E19+'SCHEDULE MJL-S12-2'!E32","v":760.62613000000238},37859.918000000005]
[null,7,"DISTRIBUTION PLANT",193395.52258000002,{"$f":"'SCHEDULE MJL-S12-2'!E20+'SCHEDULE MJL-S12-2'!E33","v":22616.319419999989},216011.842]
[null,8,"GENERAL PLANT",31788.508760000001,{"$f":"'SCHEDULE MJL-S12-2'!E21+'SCHEDULE MJL-S12-2'!E34+'SCHEDULE MJL-S12-2'!E46","v":4930.6852399999971},36719.193999999996]
[null,9,"PISA",-14575.63975,{"$f":"'SCHEDULE MJL-S12-2'!E39","v":14575.63975},0]
[null,10,"ICC DEPRECIATION",0,{"$f":"'SCHEDULE MJL-S12-2'!E22","v":-1517.59},{"$f":"SUM(D21:E21)","v":-1517.59}]
[]
[null,{"$f":"1+B21","v":11},"    TOTAL DEPRECIATION EXPENSE",{"$f":"SUM(D12:D22)","v":544281.84515000007},{"$f":"SUM(E12:E22)","v":142991.19530999998},{"$f":"SUM(F12:F22)","v":687273.04046000005}]
[]
[null,null,"PLANT AMORTIZATION:"]
[null,{"$f":"1+B23","v":12},"INTANGIBLE PLANT",48715.676479999995,{"$f":"'SCHEDULE MJL-S12-2'!E23+'SCHEDULE MJL-S12-2'!E35","v":21321.753960000002},{"$f":"SUM(D26:E26)","v":70037.430439999996}]
[null,{"$f":"1+B26","v":13},"HYDRAULIC PLANT",755.71475999999996,0,{"$f":"SUM(D27:E27)","v":755.71475999999996}]
[null,{"$f":"1+B27","v":14},"TRANSMISSION PLANT",420.30996000000005,0,{"$f":"SUM(D28:E28)","v":420.30996000000005}]
[null,{"$f":"1+B28","v":15},"GENERAL PLANT",0,0,{"$f":"SUM(D29:E29)","v":0}]
[null,17,"PISA",-11246.609,{"$f":"'SCHEDULE MJL-S12-2'!E40","v":11246.609},{"$f":"SUM(D30:E30)","v":0}]
[]
[null,{"$f":"1+B30","v":18},"    TOTAL PLANT AMORTIZATION",{"$f":"SUM(D26:D31)","v":38645.092199999999},{"$f":"SUM(E26:E31)","v":32568.362960000002},{"$f":"SUM(F26:F31)","v":71213.455159999998}]
[]
[null,null,"MISC. AMORTIZATION:"]
[null,{"$f":"1+B32","v":19},"CALLAWAY POST OPERATIONAL ",3687.4679999999998,0,{"$f":"SUM(D35:E35)","v":3687.4679999999998}]
[null,{"$f":"B35+1","v":20},"CALLAWAY LIFE EXTEN AMORT",99.66458999999999,{"$f":"'SCHEDULE MJL-S12-2'!E49","v":4.2124100000000038},103.877]
[null,21,"AMORT OF FUKUSHIMA STUDY COSTS",92.656000000000006,0,92.656000000000006]
[null,22,"SIOUX SCRUBBER CONSTRUCTION ACCOUNTING",1130.5360000000001,{"$f":"'SCHEDULE MJL-S12-2'!E51","v":2328.681},3459.2170000000001]
[null,23,"AMORT. OF STORM TRACKERS",-887.40531999999996,887,-0.4053199999999606]
[null,24,"AMORT. OF VEGETATION MANAGEMENT &"]
[null,25,"    INFRASTRUCTURE INSPECTION REG. ASSETS",-17.693999999999999,18,{"$f":"SUM(D41:E41)","v":0.30600000000000094}]
[null,26,"AMORT. OF ENTERGY DISPUTE",62.040099999999995,-62,4.0099999999995362E-2]
[null,27,"AMORT. OF ENERGY EFFICIENCY REG ASSETS",-1555.82897,1556,0.17102999999997337]
[null,28,"AMORT OF LOW INCOME SURCHARGE",956.87512000000004,{"$f":"'SCHEDULE MJL-S12-2'!E63","v":43.124880000000005},1000]
[null,29,"AMORT OF EXTENDED REGULATORY ITEMS",-2500.0259999999998,-160,-2660.0259999999998]
[null,30,"AMORT OF FIN 48 TRACKER",570.2958000000001,-570,0.29580000000009932]
[null,31,"PISA AMORTIZATION",-14575.63975,{"$f":"'SCHEDULE MJL-S12-2'!E67","v":27099.0674},{"$f":"SUM(D47:E47)","v":12523.42765}]
[null,32,"EXCESS DEFERRED TRACKER AMORTIZATION",4037.0349999999999,{"$f":"'SCHEDULE MJL-S12-2'!E69","v":-7399.2313333333341},-3362.1963333333342]
[null,33,"MEEIA ORDERED ADJUSTMENTS",4.0518600000000005,-4,5.1860000000000461E-2]
[null,34,"RESRAM ADJUSTMENTS",9537.0053100000005,{"$f":"'SCHEDULE MJL-S12-2'!E71","v":-9537.0053100000005},0]
[null,35,"CHARGE AHEAD CORRIDOR",0,{"$f":"'SCHEDULE MJL-S12-2'!E73","v":615.67142857142858},615.67142857142858]
[null,36,"TAX DEFERRAL RATE CHANGE JAN-JULY 2019",-14934.465,{"$f":"'SCHEDULE MJL-S12-2'!E75","v":4148.4594999999999},-10786.005499999999]
[null,37,"PAYS AMORT",0,{"$f":"'SCHEDULE MJL-S12-2'!E79","v":16.187386861313868},16.187386861313868]
[null,38,"EQUITY ISSUANCE COST AMORT",0,{"$f":"'SCHEDULE MJL-S12-2'!E81","v":255.44693799392093},255.44693799392093]
[null,39,"COVID AAO",0,{"$f":"'SCHEDULE MJL-S12-2'!E77","v":2912.0540000000001},2912.0540000000001]
[null,40,"  TOTAL MISC AMORTIZATION",{"$f":"SUM(D35:D55)","v":-14293.431259999999},{"$f":"SUM(E35:E55)","v":22151.66830009333},{"$f":"SUM(F35:F55)","v":7858.2370400933287}]
[]
[null,{"$f":"1+B56","v":41},"TOTAL DEPR & AMORTIZATION EXPENSE",{"$f":"+D23+D32+D56","v":568633.50609000004},{"$f":"+E23+E32+E56","v":197711.22657009331},{"$f":"+F23+F32+F56","v":766344.73266009334}]
[]
[null,{"$f":"1+B58","v":42},"(1)  See SCHEDULE MJL-S12-2 for explanation of the pro forma adjustments."]

{"sheet":"SCHEDULE MJL-S12-2","index":13,"n_rows":83,"n_cols":5,"rows_kept":83,"cut":false,"hidden":false,"merged":[[56,2,57,2],[59,2,60,2],[53,2,54,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 ADJUSTMENTS"]
[{"$f":"'SCHEDULE MJL-S13-1'!B3","v":"FOR THE TWELVE MONTHS ENDED DECEMBER 31, 2020 AND AS TRUED UP"}]
["($000)"]
[]
[]
[]
["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 December 31, 2020 and additions to plant in service from January 2021 through September 2021 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,-37295.173703333334]
[{"$f":"1+A15","v":5},null,"Change in Depr. Exp. - Nuclear",null,841.23106999999288]
[6,null,"Change in Depr. Exp. - Hydro",null,709.53963000000078]
[7,null,"Change in Depr. Exp. - Other Prod.",null,41383.388439999995]
[8,null,"Change in Depr. Exp. - Transmission",null,3602.0601300000026]
[9,null,"Change in Depr. Exp. - Distribution",null,18360.991419999988]
[10,null,"Change in Depr. Exp. - General Plant",null,19526.629239999998]
[11,null,"Change in Depr. Exp. - Incentive Comp Capitalized",null,-1517.59]
[12,null,"Change in Amor. Exp. - Intangible Plant",null,21321.753960000002]
[13,null,"Total Increase in Depreciation Expense",null,{"$f":"SUM(E15:E23)","v":66932.830186666644}]
[]
[{"$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,92048.144333333345]
[{"$f":"1+A28","v":16},null,"Increase in Depr. Exp. - Nuclear",null,8228.9639999999999]
[17,null,"Increase in Depr. Exp. - Hydro",null,1966.1590000000001]
[18,null,"Increase in Depr. Exp. - Other Prod.",null,-6118.3140000000003]
[19,null,"Increase in Depr. Exp. - Transmission",null,-2841.4340000000002]
[20,null,"Increase in Depr. Exp. - Distribution",null,4255.3280000000004]
[21,null,"Increase in Depr. Exp. - General Plant",null,-3226.1480000000001]
[{"$f":"1+A34","v":22},null,"Increase in Amort. Exp. - Intangible Plant",null,0]
[23,null,"Total Increase in Depreciation Expense",null,{"$f":"SUM(E28:E35)","v":94312.699333333338}]
[]
[{"$f":"1+A36","v":24},-3,"To eliminate PISA deferral"]
[{"$f":"1+A38","v":25},null,"Depreciation",null,14575.63975]
[26,null,"Amortization",null,11246.609]
[null,null,null,null,{"$f":"SUM(E39:E40)","v":25822.248749999999}]
[]
[{"$f":"1+A40","v":27},-4,"To reduce depreciation expense charged to O&M"]
[]
[{"$f":"1+A43","v":28},null,"Decrease in Depr. Exp. - Steam",null,-138.42400000000001]
[{"$f":"1+A45","v":29},null,"Decrease in Depr. Exp. - General Plant",null,-11369.796]
[{"$f":"1+A46","v":30},null,"Total Decrease in Depreciation Expense",null,{"$f":"SUM(E45:E46)","v":-11508.220000000001}]
[]
[{"$f":"1+A47","v":31},-5,"To reflect annualization of amortization of the Callaway Life Extension",null,4.2124100000000038]
[]
[{"$f":"1+A49","v":32},-6,"To align the Sioux Scrubber Construction Accounting amortization with a 2028",null,2328.681]
[{"$f":"1+A51","v":33},null,"retirement date."]
[]
[{"$f":"1+A52","v":34},-7,"To eliminate the amortization relating to expiring amortizations combined and netted at Adjustment 11.",null,3126.6353199999999]
[{"$f":"1+A54","v":35}]
[]
[{"$f":"1+A55","v":36},-8,"To eliminate the amortization of balances combined and netted in File No. ER-2019-0335.  These combined and netted balances are further considered in adjustment 11.",null,-614.64190000000008]
[{"$f":"A57+1","v":37}]
[]
[{"$f":"1+A58","v":38},-9,"To eliminate the amortizations and deferrals made under the MEEIA Rider, including MEEIA ordered adjustments",null,1812.57311]
[{"$f":"1+A60","v":39}]
[]
[{"$f":"1+A61","v":40},-10,"To reflect the elimination of Low Income Surcharge from Amortizations",null,43.124880000000005]
[]
[{"$f":"1+A63","v":41},-11,"To amortize Extended Regulatory Items",null,-2659.8173333333334]
[]
[{"$f":"1+A65","v":42},-12,"To reflect amortization of PISA",null,27099.0674]
[]
[{"$f":"1+A67","v":43},-13,"To reflect amortization of Excess Deferred Tracker",null,-7399.2313333333341]
[]
[{"$f":"1+A69","v":44},-14,"To eliminate RESRAM activity",null,-9537.0053100000005]
[]
[{"$f":"1+A71","v":45},-15,"To reflect Charge Ahead Corridor amortization",null,615.67142857142858]
[]
[{"$f":"1+A73","v":46},-16,"To reflect amortization Tax Deferral Rate Change (1/1/19 - 7/31/19)",null,4148.4594999999999]
[]
[{"$f":"1+A75","v":47},-17,"To reflect COVID AAO amortization",null,2912.0540000000001]
[]
[{"$f":"1+A77","v":48},-18,"To amortize the PAYS regulatory asset",null,16.187386861313868]
[]
[{"$f":"1+A79","v":49},-19,"To amortize equity issuance costs",null,255.44693799392093]
[]
[{"$f":"1+A81","v":50},"TOTAL PRO FORMA ADJUSTMENTS: DEPRECIATION & AMORTIZATION",null,null,{"$f":"SUM(E24,E36,E41,E47:E82)","v":197710.97576675998}]

{"sheet":"SCHEDULE MJL-S13-1","index":14,"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,"FOR THE TWELVE MONTHS ENDED DECEMBER 31, 2020 AND AS TRUED UP",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"($000)"]
[]
[null,null,null,null,"TOTAL",null,"ADJUSTED"]
[null,null,null,null,"PER",null,"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,21335.477280000003,{"$f":"'SCHEDULE MJL-S13-2'!K11","v":271.952},{"$f":"E12+F12","v":21607.429280000004}]
[null,{"$f":"1+B12","v":2},"   FEDERAL UNEMPLOYMENT",null,178.53095000000002,0,{"$f":"E13+F13","v":178.53095000000002}]
[null,{"$f":"1+B13","v":3},"   MISSOURI UNEMPLOYMENT",null,0,0,{"$f":"E14+F14","v":0}]
[null,{"$f":"1+B14","v":4},"   ILLINOIS UNEMPLOYMENT",null,3.7920799999999999,0,3.7920799999999999]
[null,{"$f":"1+B15","v":5},"   IOWA UNEMPLOYMENT",null,0.99970000000000003,0]
[null,{"$f":"1+B16","v":6},"   OTHER STATES UNEMPLOYMENT",null,4.4999999999999998E-2,0,4.4999999999999998E-2]
[null,{"$f":"1+B17","v":7},"   ST. LOUIS EMPLOYMENT TAX",null,490.75253999999995,0,490.75253999999995]
[null,{"$f":"1+B18","v":8},"      TOTAL PAYROLL TAXES",null,{"$f":"SUM(E12:E18)","v":22009.597550000002},{"$f":"SUM(F12:F18)","v":271.952},{"$f":"SUM(G12:G18)","v":22280.549850000003}]
[]
[null,null,"R.E., P.P. & CORP FRANCHISE"]
[null,{"$f":"1+B19","v":9},"   MISSOURI R.E., & P.P.",685910,154755.06531000001,{"$f":"'SCHEDULE MJL-S13-2'!K13+'SCHEDULE MJL-S13-2'!K18","v":-340.70699999999999},{"$f":"SUM(E22:F22)","v":154414.35831000001}]
[null,{"$f":"1+B22","v":10},"   ILLINOIS R.E., & P.P.",null,3786.7181800000003,0,3786.7181800000003]
[null,11,"   IOWA  R.E., & P.P.",null,1229.76683,0,1229.76683]
[null,12,"   OTHER STATES R.E. & P.P.",null,24.971,0,24.971]
[null,13,"   R.E. TAXES CAPITALIZED",null,-2142.8508400000001,0,-2142.8508400000001]
[null,14,"   TRANSFER TO GAS",762523,-175.43799999999999,0,-175.43799999999999]
[null,15,"   TRANSFER TO NON UTILITY",null,-84.662000000000006,0,-84.662000000000006]
[null,{"$f":"1+B28","v":16},"      TOTAL R.E., P.P. & CORP FRANCHISE",{"$f":"SUM(D22:D27)","v":1448433},{"$f":"SUM(E22:E28)","v":157393.57047999999},{"$f":"SUM(F22:F28)","v":-340.70699999999999},157052.86348]
[]
[null,{"$f":"1+B29","v":17},"MUNICIPAL GROSS RECEIPTS",null,133304.66696,{"$f":"'SCHEDULE MJL-S13-2'!K16","v":-133304.66696},{"$f":"SUM(E31:F31)","v":0}]
[]
[null,null,"MISCELLANEOUS"]
[null,{"$f":"1+B31","v":18},"   MISSOURI CORP FRANCHISE",null,0,0,{"$f":"E34+F34","v":0}]
[null,{"$f":"1+B34","v":19},"   ILLINOIS CORP FRANCHISE",null,101.55878999999999,0,{"$f":"E35+F35","v":101.55878999999999}]
[null,20,"   IOWA CORP FRANCHISE",null,0,0]
[null,21,"   FED. EXCISE TAX-HEAVY VEH. USE TAX",null,21.888500000000001,0,{"$f":"E37+F37","v":21.888500000000001}]
[null,22,"   ST. LOUIS EARNINGS",null,0,0]
[null,23,"   MO. EXCISE - NEIL INS. PREM.",107,0,0,{"$f":"E39+F39","v":0}]
[null,24,"   MISCELLANEOUS",null,-205.60300000000001,0,{"$f":"E40+F40","v":-205.60300000000001}]
[null,25,"      TOTAL MISCELLANEOUS",null,{"$f":"SUM(E34:E40)","v":-82.155710000000028},{"$f":"SUM(F34:F40)","v":0},{"$f":"SUM(G34:G40)","v":-82.155710000000028}]
[]
[]
[null,{"$f":"1+B41","v":26},"TOTAL TAXES OTHER THAN INCOME TAXES",null,{"$f":"E19+E29+E31+E41","v":312625.67927999998},{"$f":"F19+F29+F31+F41","v":-133373.42196000001},{"$f":"G19+G29+G31+G41","v":179251.25762000002}]
[]
[null,{"$f":"1+B44","v":27},"(1) See SCHEDULE MJL-S13-2 for explanation of the pro forma adjustments."]

{"sheet":"SCHEDULE MJL-S13-2","index":15,"n_rows":20,"n_cols":11,"rows_kept":20,"cut":false,"hidden":false,"merged":[[8,2,8,8],[10,2,10,8],[12,2,13,8],[15,2,15,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]]}
["AMEREN MISSOURI"]
["TAXES OTHER THAN INCOME"]
["ADJUSTMENTS"]
[{"$f":"'SCHEDULE MJL-S13-1'!B3","v":"FOR THE TWELVE MONTHS ENDED DECEMBER 31, 2020 AND AS TRUED UP"}]
["($000)"]
[]
[]
["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 the F.I.C.A. taxes to reflect the pro forma wage adjustments.",null,null,null,null,null,null,null,271.952]
[]
[{"$f":"1+A11","v":2},-2,"Eliminate the property taxes on future use plant, as this investment is excluded from rate base.",null,null,null,null,null,null,null,-353.65100000000001]
[{"$f":"1+A13","v":3}]
[]
[{"$f":"1+A14","v":4},-3,"Eliminate the gross receipts tax as they are a pass through tax.",null,null,null,null,null,null,null,-133304.66696]
[]
[5,-4,"Wind Prop Tax",null,null,null,null,null,null,null,12.944000000000001]
[]
[6,null,"Total Pro Forma Adjustments to Taxes Other Than Income",null,null,null,null,null,null,null,{"$f":"SUM(K10:K18)","v":-133373.42196000001}]

{"sheet":"SCHEDULE MJL-S14","index":16,"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"]
["TOTAL ELECTRIC INCOME TAXES AT THE PROPOSED RETURN\nFOR THE TWELVE MONTHS ENDED DECEMBER 31, 2020 AND AS TRUED UP"]
["($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,716032.83271904744]
[]
[null,null,"ADD"]
[{"$f":"1+A10","v":2},null,"CURRENT INCOME TAXES",null,67999.62]
[{"$f":"1+A13","v":3},null,"DEFERRED INCOME TAXES"]
[{"$f":"1+A14","v":4},null,"     DEFERRED INCOME TAX EXPENSE",null,-78324.777000000002]
[{"$f":"1+A15","v":5},null,"     I.T.C. AMORTIZATION",null,-4729.8559999999998]
[]
[{"$f":"1+A16","v":6},null,"TOTAL ELECTRIC NET INCOME BEFORE INCOME TAX",null,{"$f":"SUM(E10:E16)","v":700977.8197190474}]
[]
[null,null,"ADDITIONS TO NET INCOME BEFORE INCOME TAX"]
[{"$f":"1+A18","v":7},null,"     BOOK DEPRECIATION",null,687273.0405]
[{"$f":"1+A21","v":8},null,"     BOOK DEPRECIATION CHARGED TO O&M",null,4381.6319999999996]
[9,null,"     INTANGIBLE AMORTIZATIONS",null,70037.430439999996]
[10,null,"     HYDRAULIC AMORTIZATIONS",null,755.71475999999996]
[11,null,"     TRANSMISSION AMORTIZATIONS",null,420.30996000000005]
[12,null,"     CALLAWAY POST OPERATIONAL COSTS ",null,3687.4679999999998]
[13,null,"     NONDEDUCTIBLE PARKING LOT EXPENSE",null,672.48299999999995]
[]
[{"$f":"1+A27","v":14},null,"TOTAL ADDITIONS",null,{"$f":"SUM(E21:E28)","v":767228.07866}]
[]
[null,null,"SUBTRACTIONS TO NET INCOME BEFORE INCOME TAX"]
[{"$f":"1+A29","v":15},null,"     INTEREST ON DEBT (1)",null,188488.71100000001]
[{"$f":"1+A32","v":16},null,"     TAX STRAIGHT LINE",null,748450.49899999995]
[{"$f":"1+A33","v":17},null,"     PRODUCTION DEDUCTION",null,0]
[{"$f":"1+A34","v":18},null,"     NUCLEAR DECOMMISSIONING",null,6758.6049999999996]
[{"$f":"1+A35","v":19},null,"     RSU PERMANENT DIFFERENCE",null,855.29600000000005]
[{"$f":"1+A36","v":20},null,"     PREFERRED DIVIDEND DEDUCTION",null,415.274]
[]
[{"$f":"1+A37","v":21},null,"TOTAL SUBTRACTIONS",null,{"$f":"SUM(E32:E37)","v":944968.38499999989}]
[]
[{"$f":"1+A39","v":22},null,"TOTAL ELECTRIC NET TAXABLE INCOME",null,{"$f":"E18+E29-E39","v":523237.51337904751}]
[]
[null,null,"FEDERAL INCOME TAX "]
[{"$f":"1+A41","v":23},null,"  NET TAXABLE INCOME",null,{"$f":"E41","v":523237.51337904751}]
[{"$f":"1+A44","v":24},null,"  DEDUCT MISSOURI INCOME TAX",null,19969.440999999999]
[{"$f":"1+A45","v":25},null,"  DEDUCT CITY EARNINGS TAX",null,-27.193999999999999]
[{"$f":"1+A46","v":26},null,"  FEDERAL TAXABLE INCOME",null,{"$f":"E44-E45-E46","v":503295.26637904753}]
[]
[{"$f":"1+A47","v":27},null,{"$f":"\"  FEDERAL INCOME TAX\"","v":"  FEDERAL INCOME TAX"},0.21,105692.00599999999]
[null,null,"   LESS TAX CREDITS"]
[{"$f":"1+A49","v":28},null,"      RESEARCH CREDIT",null,1053.5830000000001]
[{"$f":"1+A51","v":29},null,"      PRODUCTION TAX CREDIT ",null,56581.05]
[{"$f":"1+A52","v":30},null,"TOTAL ELECTRIC FEDERAL INCOME TAX",null,{"$f":"+E49-E51-E52-1","v":48056.372999999992}]
[]
[null,null,"STATE INCOME TAXES"]
[{"$f":"1+A53","v":31},null,"  NET TAXABLE INCOME",null,{"$f":"E41","v":523237.51337904751}]
[{"$f":"1+A56","v":32},null,"  DEDUCT 50% OF FEDERAL INCOME TAX",null,{"$f":"ROUND(E53*0.5,0)","v":24028}]
[{"$f":"1+A57","v":33},null,"  DEDUCT CITY EARNINGS TAX",null,{"$f":"+E69","v":-27.033000000000001}]
[{"$f":"1+A58","v":34},null,"  MISSOURI TAXABLE INCOME",null,{"$f":"E56-E57-E58","v":499236.5463790475}]
[]
[{"$f":"1+A59","v":35},null,"TOTAL ELECTRIC MISSOURI INCOME TAX",0.04,{"$f":"ROUND(E59*D61,0)+1","v":19970}]
[]
[null,null,"CITY EARNINGS TAX"]
[{"$f":"1+A61","v":36},null,"  NET TAXABLE INCOME",null,{"$f":"+E41","v":523237.51337904751}]
[{"$f":"1+A64","v":37},null,"  LESS TAX ADJUSTMENTS TO INCOME",null,-513162.08600000001]
[{"$f":"1+A65","v":38},null,"  CITY TAXABLE INCOME",null,{"$f":"+E64+E65","v":10075.427379047498}]
[{"$f":"1+A66","v":39},null,"  CITY EARNINGS TAX",1.175E-3,{"$f":"ROUND(E66*D67,0)","v":12}]
[{"$f":"1+A67","v":40},null,"  LESS: TAX CREDIT",null,39.033000000000001]
[{"$f":"1+A68","v":41},null,"  TOTAL ELECTRIC NET CITY EARNINGS TAX",null,{"$f":"+E67-E68","v":-27.033000000000001}]
[]
[{"$f":"1+A69","v":42},null,"TOTAL ELECTRIC CURRENT INCOME TAXES",null,{"$f":"E53+E61+E69","v":67999.34}]
[]
[null,null,"DEFERRED INCOME TAXES:"]
[{"$f":"1+A71","v":43},null,"     DEFERRED INCOME TAX EXPENSE",null,{"$f":"+E15","v":-78324.777000000002}]
[{"$f":"1+A74","v":44},null,"     I.T.C. AMORTIZATION",null,{"$f":"+E16","v":-4729.8559999999998}]
[{"$f":"1+A75","v":45},null,"TOTAL ELECTRIC DEFERRED INCOME TAX",null,{"$f":"SUM(E74:E75)","v":-83054.633000000002}]
[]
[{"$f":"1+A76","v":46},null,"TOTAL ELECTRIC CURRENT & DEFERRED INCOME TAX",null,{"$f":"+E71+E76","v":-15055.293000000005}]
[]
[]
[{"$f":"1+A78","v":47},null,"(1)  RATE BASE X EMBEDDED"]
[{"$f":"1+A81","v":48},null,"       COST OF DEBT.",1.8489999999999999E-2]

{"sheet":"SCHEDULE MJL-S15","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-S13-1'!B3:G3","v":"FOR THE TWELVE MONTHS ENDED DECEMBER 31, 2020 AND AS TRUED UP"}]
[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-S1",null,{"$f":"+'SCHEDULE MJL-S1'!G35","v":21013265.426103331}]
[null,{"$f":"1+B13","v":2},"LESS: RESERVES FOR DEPRECIATION & AMORTIZATION","SCHEDULE MJL-S2",null,{"$f":"+'SCHEDULE MJL-S2'!G35","v":8570521.3806966674}]
[null,{"$f":"1+B14","v":3},"     NET ORIGINAL COST OF PLANT",null,null,{"$f":"F13-F14","v":12442744.045406664}]
[null,4,"AVERAGE FUEL AND MATERIALS AND SUPPLIES","SCHEDULE MJL-S3",null,{"$f":"+'SCHEDULE MJL-S3'!F23","v":518621.98100000003}]
[null,5,"AVERAGE PREPAYMENTS","SCHEDULE MJL-S4",null,{"$f":"+'SCHEDULE MJL-S4'!G25","v":18149.327000000001}]
[null,6,"CASH WORKING CAPITAL (LEAD/LAG)","SCHEDULE MJL-S5",null,{"$f":"'SCHEDULE MJL-S5'!J47","v":-17189}]
[null,7,"FEDERAL INCOME TAX CASH REQUIREMENT","SCHEDULE MJL-S6",null,{"$f":"'SCHEDULE MJL-S6'!J14","v":-129}]
[null,8,"STATE INCOME TAX CASH REQUIREMENT","SCHEDULE MJL-S6",null,{"$f":"'SCHEDULE MJL-S6'!J16","v":-53}]
[null,9,"CITY EARNINGS TAX CASH REQUIREMENT","SCHEDULE MJL-S6",null,{"$f":"'SCHEDULE MJL-S6'!J22","v":18}]
[null,{"$f":"1+B21","v":10},"INTEREST EXPENSE CASH REQUIREMENT","SCHEDULE MJL-S6",null,{"$f":"'SCHEDULE MJL-S6'!J24","v":-28067}]
[null,{"$f":"1+B22","v":11},"INDIANA STATE TAX OFFSET","SCHEDULE MJL-S6",null,{"$f":"'SCHEDULE MJL-S6'!J18","v":3}]
[null,{"$f":"1+B23","v":12},"IOWA STATE TAX OFFSET","SCHEDULE MJL-S6",null,{"$f":"'SCHEDULE MJL-S6'!J20","v":9}]
[null,{"$f":"1+B24","v":13},"AVERAGE CUSTOMER ADVANCES FOR CONSTRUCTION","SCHEDULE MJL-S7",null,{"$f":"'SCHEDULE MJL-S7'!E13","v":-827.57500000000005}]
[null,14,"AVERAGE CUSTOMER DEPOSITS","SCHEDULE MJL-S7",null,{"$f":"'SCHEDULE MJL-S7'!E16","v":-17969.475999999999}]
[null,{"$f":"1+B26","v":15},"PENSION TRACKER REG ASSET","SCHEDULE MJL-S8",null,{"$f":"+'SCHEDULE MJL-S8'!H15","v":-25174.27}]
[null,{"$f":"1+B27","v":16},"OPEB TRACKER REG  LIABILITY","SCHEDULE MJL-S8",null,{"$f":"+'SCHEDULE MJL-S8'!H18","v":-6938.8689999999997}]
[null,{"$f":"1+B28","v":17},"PAYS REGULATORY ASSET","SCHEDULE MJL-S8",null,{"$f":"+'SCHEDULE MJL-S8'!H21","v":184.80600000000001}]
[null,{"$f":"1+B29","v":18},"EQUITY ISSUANCE COST REGULATORY ASSET","SCHEDULE MJL-S8",null,{"$f":"+'SCHEDULE MJL-S8'!H33","v":7003.5035499999985}]
[null,{"$f":"1+B30","v":19},"PISA REGULATORY ASSET","SCHEDULE MJL-S8",null,{"$f":"+'SCHEDULE MJL-S8'!H24","v":246605.48894000001}]
[null,{"$f":"1+B31","v":20},"UNDER COLLECT AMORTIZATIONS IN RATE BASE","SCHEDULE MJL-S8",null,{"$f":"+'SCHEDULE MJL-S8'!H30","v":-196.30099999999999}]
[null,{"$f":"1+B32","v":21},"ACCUMULATED DEFERRED INCOME TAXES ","SCHEDULE MJL-S9",null,{"$f":"+'SCHEDULE MJL-S9'!H21","v":-2942704.9728099997}]
[]
[null,{"$f":"1+B33","v":22},"TOTAL ELECTRIC NET ORIGINAL COST RATE BASE",null,null,{"$f":"SUM(F15:F33)","v":10194089.688086664}]
[]
[null,null,"B. TOTAL ELECTRIC REVENUE REQUIREMENT"]
[]
[null,null,"TOTAL ELECTRIC OPERATING EXPENSES:"]
[null,{"$f":"1+B35","v":23},"PRODUCTION","SCHEDULE MJL-S11-1",null,{"$f":"+'SCHEDULE MJL-S11-1'!CD22","v":1026956.5081797584}]
[null,{"$f":"1+B40","v":24},"TRANSMISSION","SCHEDULE MJL-S11-1",null,{"$f":"+'SCHEDULE MJL-S11-1'!CD27","v":108316.73562119465}]
[null,{"$f":"1+B41","v":25},"REGIONAL MARKET EXPENSES","SCHEDULE MJL-S11-1",null,{"$f":"+'SCHEDULE MJL-S11-1'!CD32","v":6676.2991400000001}]
[null,{"$f":"1+B42","v":26},"DISTRIBUTION","SCHEDULE MJL-S11-1",null,{"$f":"+'SCHEDULE MJL-S11-1'!CD37","v":142141.98887249961}]
[null,27,"CUSTOMER ACCOUNTS","SCHEDULE MJL-S11-1",null,{"$f":"+'SCHEDULE MJL-S11-1'!CD42","v":58322.733457933457}]
[null,28,"CUSTOMER SERVICE","SCHEDULE MJL-S11-1",null,{"$f":"+'SCHEDULE MJL-S11-1'!CD47","v":14928.354634428972}]
[null,29,"SALES","SCHEDULE MJL-S11-1",null,{"$f":"+'SCHEDULE MJL-S11-1'!CD52","v":281.92053999999996}]
[null,30,"ADMINISTRATIVE AND GENERAL","SCHEDULE MJL-S11-1",null,{"$f":"+'SCHEDULE MJL-S11-1'!CD57","v":206894.5873197974}]
[null,31,"   TOTAL ELECTRIC OPERATING EXPENSES",null,null,{"$f":"SUM(F40:F47)","v":1564519.1277656124}]
[null,32,"DEPRECIATION AND AMORTIZATION","SCHEDULE MJL-S12-1",null,{"$f":"'SCHEDULE MJL-S12-1'!F58","v":766344.73266009334}]
[null,33,"TAXES OTHER THAN INCOME TAXES","SCHEDULE MJL-S13-1",null,{"$f":"'SCHEDULE MJL-S13-1'!G44","v":179251.25762000002}]
[null,null,"INCOME TAXES-BASED ON PROPOSED RATE OF RETURN"]
[null,{"$f":"1+B50","v":34},"  FEDERAL","SCHEDULE MJL-S14",null,{"$f":"'SCHEDULE MJL-S14'!E53","v":48056.372999999992}]
[null,{"$f":"1+B52","v":35},"  STATE","SCHEDULE MJL-S14",null,{"$f":"'SCHEDULE MJL-S14'!E61","v":19970}]
[null,{"$f":"1+B53","v":36},"  CITY EARNINGS ","SCHEDULE MJL-S14",null,{"$f":"'SCHEDULE MJL-S14'!E69","v":-27.033000000000001}]
[null,{"$f":"1+B54","v":37},"TOTAL INCOME TAXES",null,null,{"$f":"SUM(F52:F54)","v":67999.34}]
[null,null,"DEFERRED INCOME TAXES",null,0]
[null,{"$f":"1+B55","v":38},"     DEFERRED INCOME TAX EXPENSE","SCHEDULE MJL-S14",null,{"$f":"'SCHEDULE MJL-S14'!E74","v":-78324.777000000002}]
[null,{"$f":"1+B57","v":39},"     I.T.C. AMORTIZATION","SCHEDULE MJL-S14",null,{"$f":"'SCHEDULE MJL-S14'!E75","v":-4729.8559999999998}]
[null,{"$f":"1+B58","v":40},"TOTAL DEFERRED INCOME TAXES",null,null,{"$f":"SUM(F57:F58)","v":-83054.633000000002}]
[]
[null,{"$f":"1+B59","v":41},{"$f":"\"RETURN (RATE BASE * \"&TEXT(D61,\"0.000%\")&\")\"","v":"RETURN (RATE BASE * 7.024%)"},7.0239999999999997E-2,null,{"$f":"ROUND(D61*F35,0)","v":716033}]
[]
[null,{"$f":"1+B61","v":42},"TOTAL ELECTRIC REVENUE REQUIREMENT",null,null,{"$f":"+F48+F49+F50+F55+F59+F61","v":3211092.8250457058}]

{"sheet":"SCHEDULE MJL-S16","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-S15'!D61,\"0.000%\") &\" RETURN ON \"","v":"INCREASE REQUIRED TO PRODUCE 7.024% RETURN ON "}]
["TOTAL ELECTRIC NET ORIGINAL COST RATE BASE"]
[{"$f":"'SCHEDULE MJL-S15'!B3","v":"FOR THE TWELVE MONTHS ENDED DECEMBER 31, 2020 AND AS TRUED UP"}]
[]
[]
[]
[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-S15'!F35","v":10194089.688086664}]
[]
[null,null,"TOTAL ELECTRIC REVENUE REQUIREMENT:"]
[{"$f":"1+A13","v":2},null,{"$f":"\"RETURN AT PROPOSED RATE (\"&TEXT('SCHEDULE MJL-S15'!D61,\"0.000%\")&\")\"","v":"RETURN AT PROPOSED RATE (7.024%)"},null,{"$f":"'SCHEDULE MJL-S15'!F61","v":716033}]
[{"$f":"1+A16","v":3},null,"OPERATING AND MAINTENANCE EXPENSES",null,{"$f":"'SCHEDULE MJL-S15'!F48","v":1564519.1277656124}]
[4,null,"DEPRECIATION AND AMORTIZATION",null,{"$f":"'SCHEDULE MJL-S15'!F49","v":766344.73266009334}]
[5,null,"TAXES OTHER THAN INCOME",null,{"$f":"'SCHEDULE MJL-S15'!F50","v":179251.25762000002}]
[6,null,"FEDERAL AND STATE INCOME AND CITY EARNINGS TAXES AT CLAIMED RETURN",null,{"$f":"'SCHEDULE MJL-S15'!F52+'SCHEDULE MJL-S15'!F53+'SCHEDULE MJL-S15'!F54","v":67999.34}]
[7,null,"DEFERRED INCOME TAXES",null,{"$f":"'SCHEDULE MJL-S15'!F59","v":-83054.633000000002}]
[8,null,"TOTAL ELECTRIC REVENUE REQUIREMENT",null,{"$f":"SUM(E16:E21)","v":3211092.8250457058}]
[]
[]
[{"$f":"1+A22","v":9},null,"PRO FORMA TOTAL ELECTRIC OPERATING REVENUE AT PRESENT RATES",null,{"$f":"+'SCHEDULE MJL-S10'!F26","v":2911182.9664699999}]
[null,null,""]
[{"$f":"1+A25","v":10},null,"DEFICIENCY IN TOTAL ELECTRIC OPERATING REVENUE",null,{"$f":"E22-E25","v":299909.8585757059}]
[]
[]
[null,null,null,null,null,{"$f":"+UPPER(C30)","v":""}]

{"sheet":"SCHEDULE MJL-S17","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-S3'!A3","v":"FOR THE TWELVE MONTHS ENDED SEPTEMBER 30, 2021"}]
[]
[]
[]
[]
[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":374269000},null,119820000,null,254449000,null,{"$f":"E14-G14-I14","v":0}]
[{"$f":"1+A14","v":2},null,"FLY ASH (1)",null,{"$f":"G15+I15","v":-2442084.5799999996},null,-817291,null,-1624793.5799999996,null,0]
[{"$f":"1+A15","v":3},null,"FIXED GAS SUPPLY COSTS FOR LOAD (2)",null,{"$f":"G16+I16","v":6538502.7599999998},null,2193002,null,4345500.76,null,0]
[4,null,"FUEL ADDITIVES (2)",null,{"$f":"G17+I17","v":4977481.6532761501},null,1669438,null,3308043.6532761501,null,0]
[5,null,"PURCHASED POWER FOR LOAD",null,{"$f":"G18+I18","v":20733000},null,8635000,null,12098000,null,0]
[null,null,""]
[{"$f":"1+A18","v":6},null,"TOTAL BASE LOAD",null,{"$f":"SUM(E14:E18)","v":404075899.83327615},null,{"$f":"SUM(G14:G18)","v":131500149},null,{"$f":"SUM(I14:I18)","v":272575750.83327615},null,{"$f":"SUM(K14:K18)","v":0}]
[]
[null,null,"OSS"]
[7,null,"FUEL FOR LOAD",null,{"$f":"G23+I23","v":219162000},null,69389000,null,149773000]
[8,null,"FLY ASH (1)",null,{"$f":"G24+I24","v":-1430020},null,-478584,null,-951436]
[9,null,"FIXED GAS SUPPLY COSTS FOR LOAD (2)",null,{"$f":"G25+I25","v":3828774},null,1284164,null,2544610]
[10,null,"FUEL ADDITIVES (2)",null,{"$f":"G26+I26","v":2914681},null,977579,null,1937102]
[11,null,"PURCHASED POWER FOR LOAD",null,{"$f":"G27+I27","v":0},null,0,null,0]
[]
[12,null,"TOTAL OSS",null,{"$f":"SUM(E23:E27)","v":224475435},null,{"$f":"SUM(G23:G27)","v":71172159},null,{"$f":"SUM(I23:I27)","v":153303276}]
[]
[13,null,"TOTAL FUEL AND PURCHASED POWER",null,{"$f":"E20+E29","v":628551334.83327615},null,{"$f":"G20+G29","v":202672308},null,{"$f":"I20+I29","v":425879026.83327615}]
[]
[]
[null,"B","TRANSMISSION COSTS AND REVENUES"]
[14,null,"TRANSMISSION BY OTHERS (ACCT. 565 @1.87%) (2)",null,{"$f":"G35+I35","v":1500513.9112075244},null,503272,null,997241.91120752436]
[15,null,"TRANMISSION REVENUES  (ACC 456.1) (2)",null,{"$f":"G36+I36","v":-536349.48793371161},null,-179892,null,-356457.48793371161]
[]
[16,null,"TOTAL TRANSMISSION COSTS AND REVENUES",null,{"$f":"SUM(E35:E36)","v":964164.42327381275},null,{"$f":"SUM(G35:G36)","v":323380},null,{"$f":"SUM(I35:I36)","v":640784.42327381275}]
[]
[]
[null,"C","ADDITIONAL FUEL & PP COSTS "]
[17,null,"MISO DAY 2 EXCLUDING ADMIN (ACCT 555) (2)",null,{"$f":"G42+I42","v":33725702.849999994},null,11311541,null,22414161.849999994,null,{"$f":"E42-G42-I42","v":0}]
[18,null,"COMMON BOUNDARY (2)",null,198077,null,66435,null,131642]
[19,null,"CAPACITY EXPENSE (2)",null,11829414.970000001,null,3967565,null,7861849.9700000007,null,{"$f":"E44-G44-I44","v":0}]
[20,null,"ANCILLARY SERVICES PURCHASED  (ACCT. 555) (2)",null,3701564.4299999997,null,1241505,null,2460059.4299999997,null,0]
[21,null,"PJM EXCLUDING ADMIN (ACCT. 555) (2)",null,0,null,0,null,0,null,0]
[22,null,"REPLACEMENT POWER INSURANCE (ACC 925) (2)",null,653138,null,219062,null,434076]
[null,null,null,""]
[23,null,"TOTAL ADDITIONAL FUEL & PP COSTS",null,{"$f":"SUM(E42:E47)","v":50107897.249999993},null,{"$f":"SUM(G42:G47)","v":16806108},null,{"$f":"SUM(I42:I47)","v":33301789.249999993},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":244640364.20318213},null,64258000,null,180382364.20318213,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":3246722},null,1088945,null,2157777,null,0]
[{"$f":"1+A54","v":26},null,"CAPACITY SALES  REVENUES (ACCT. 447) (2)",null,18026212.736666668,null,6045960,null,11980252.736666668,null,0]
[{"$f":"1+A55","v":27},null,"BILATERAL ENERGY SALES MARGINS (447) (2)",null,32505.655908227807,null,10902,null,21603.655908227807]
[{"$f":"1+A56","v":28},null,"FINANCIAL SWAPS (ACCT 447) (2)",null,3839423.0746666668,null,1287736,null,2551687.0746666668,null,0]
[{"$f":"1+A57","v":29},null,"ANCILLARY SERVICES REVENUE (ACCT. 447) (2)",null,5244899.84,null,1759130,null,3485769.84,null,0]
[null,null,""]
[{"$f":"A58+1","v":30},null,"TOTAL SALES",null,{"$f":"SUM(E53:E59)","v":275030127.51042366},null,{"$f":"SUM(G53:G59)","v":74450673},null,{"$f":"SUM(I53:I59)","v":200579454.51042372},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":6014072.5554289222},null,2017109,null,3996963.5554289222]
[]
[{"$f":"A63+1","v":32},null,"TOTAL OTHER ADJUSTMENTS",null,{"$f":"E63","v":6014072.5554289222},null,{"$f":"G63","v":2017109},null,{"$f":"I63","v":3996963.5554289222}]
[null,null,""]
[{"$f":"A65+1","v":33},"A + B + C - D - E","NET BASE ENERGY COSTS",null,{"$f":"E31+E38+E49-E60-E65","v":398579196.44069737},null,{"$f":"G31+G38+G49-G60-G65","v":143334014},null,{"$f":"I31+I38+I49-I60-I65","v":255245182.44069731},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":32375636999.984997},null,10859000000,null,21516636999.984997,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":12.311084302090553},null,{"$f":"G67/G79*1000","v":13.199559259600331},null,{"$f":"I67/I79*1000","v":11.862689436126811},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.2311084302090554},null,{"$f":"G81/10","v":1.3199559259600331},null,{"$f":"I81/10","v":1.186268943612681},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 FUEL ACCOUNT 501 FROM FUEL MODEL."]
[{"$f":"1+A89","v":41},-2,"ALLOCATED BETWEEN SUMMER AND WINTERS BASED ON LOAD."]

{"sheet":"SCHEDULE MJL-S18","index":20,"n_rows":27,"n_cols":9,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,0,0,8],[1,0,1,8],[2,0,2,8],[5,4,5,8],[17,4,17,8]]}
["AMEREN MISSOURI"]
["MERAMEC RETIREMENT EXAMPLES"]
["($000,000)"]
[]
[null,null,"With Proposed Meramec Retirement Tracker:"]
[null,null,null,null,"Actual Costs"]
["Line",null,"Cost\n(A)","Tracker Base\n(B)","2022\n(C)","2023\n(D)","2024\n(E)","2025\n(F)","2026\n(G)"]
[1,null,"Allowed Return on Rate Base, Including Income Taxes",1.4,6.8,0,0,0,0]
[2,null,"Depreciation",9.9,49.4,0,0,0,0]
[3,null,"O&M",0.5,2.6,0,0,0,0]
[4,null,"Total",{"$f":"SUM(D8:D10)","v":11.8},{"$f":"SUM(E8:E10)","v":58.8},{"$f":"SUM(F8:F10)","v":0},{"$f":"SUM(G8:G10)","v":0},0,0]
[]
[5,null,"Annual Deferral",0,{"$f":"E11-$D$11","v":47},{"$f":"F11-$D$11","v":-11.8},-11.8,-11.8,-11.8]
[6,null,"Cost of Capital",0,4.0574792051627755,3.3890724579161287,2.6629625941259976,1.8741681415488021,1.0172775807060803]
[7,null,"Cumulative Deferral",0,{"$f":"SUM(E13:E14)+D15","v":51.057479205162778},{"$f":"SUM(F13:F14)+E15","v":42.64655166307891},33.509514257204906,23.583682398753709,12.800959979459789]
[]
[null,null,"Without Meramec Retirement Tracker:"]
[null,null,null,null,"Actual Costs"]
[null,null,"Cost\n(A)","Base Rate Amt\n(B)","2022\n(C)","2023\n(D)","2024\n(E)","2025\n(F)","2026\n(G)"]
[8,null,"Allowed Return on Rate Base, Including Income Taxes",{"$f":"E20","v":6.8},{"$f":"E8","v":6.8},0,{"$f":"F20","v":0},0,0]
[9,null,"Depreciation",{"$f":"E21","v":49.4},{"$f":"E9","v":49.4},0,0,0,0]
[10,null,"O&M",{"$f":"E22","v":2.6},{"$f":"E10","v":2.6},0,0,0,0]
[11,null,"Total",{"$f":"SUM(D20:D22)","v":58.8},{"$f":"SUM(E20:E22)","v":58.8},{"$f":"SUM(F20:F22)","v":0},0,0,0]
[]
[12,null,"Annual Deferral",0,{"$f":"E23-$D$23","v":0},{"$f":"F23-$D$23","v":-58.8},{"$f":"G23-$D$23","v":-58.8},{"$f":"H23-$D$23","v":-58.8},{"$f":"I23-$D$23","v":-58.8}]
[13,null,"Cost of Capital",0,0,-5.0761654736930035,-10.590552986779084,-16.58099396079189,-23.088585779098569]
[14,null,"Cumulative Deferral",0,{"$f":"SUM(E25:E26)+D27","v":0},{"$f":"SUM(F25:F26)+E27","v":-63.876165473693},{"$f":"SUM(G25:G26)+F27","v":-133.26671846047208},{"$f":"SUM(H25:H26)+G27","v":-208.64771242126398},-290.53629820036252]