{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["SPP","MISO","AECI-CU","MISO RTOR","SPP Short Pay-Adj","Summary"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":1,"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":"SPP","index":0,"n_rows":40,"n_cols":25,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
["ChargeType","2015-01-01","2015-02-01","2015-03-01","2015-04-01","2015-05-01","2015-06-01","2015-07-01","2015-08-01","2015-09-01","2015-10-01","2015-11-01","2015-12-01","2016-01-01","2016-02-01","2016-03-01","2016-04-01","2016-05-01","2016-06-01","2016-07-01","2016-08-01","2016-09-01","2016-10-01","2016-11-01","2016-12-01"]
["Schd1aTaNitsChg",262611.63,237197.6,262258.65999999997,254140.29,262611.63,254140.29,262611.63,262611.63,254140.29,262611.63,254493.26,262611.63,233628.21,218555.42,233314.19,226091.82,233628.21,226091.82,233628.21,233628.21,226091.82,233628.21,226405.83,233628.21]
["MonthlyAssessmentChg",12.19,11.01,12.17,11.79,12.19,11.79,12.19,12.19,11.79,12.19,11.81,12.19,1.93,1.8,1.93,1.86,1.93,1.86,1.93,1.93,1.86,1.93,1.87,1.93]
["Schd11BprNitsChg",718694.36,822364.56,829883.74,826984.13,827009.53,823434.03,826535.07,829533.73,838585.18,833865.35,771918.87,771918.87,728517.37,806621.14,806620.75,808783.47,813089.37,796832.57,804664.17,809454.27,834349.06,2400022.66,1217647.1000000001,1006609.82]
["Schd11BpzNitsChg",15420.9,12154.13,12154.13,12154.13,12154.13,12154.13,12154.13,585.72,288.89999999999998,288.89999999999998,-89645.06,-119399.08,-103345.88,-104507.38,-103654.34,-107886.34,-106830.24,-107270.14,-121259.83,-106028.17,-106833.01,95963.900000000009,0,-529803.04]
["Schd12FercPtpIWNitsGfaChg",30271.65,37549.599999999999,36225.49,31237.34,26023.14,27651.05,34713.67,39650.300000000003,35791.39,32125.51,27359.64,28525.59,32405.79,32765.55,26838.66,24696.02,22517.78,24207.33,32084.82,34638.86,33541,28366.16,24370.27,24178.03]
["AdjSchd11BprNitsChg",-778.33,-924,-874.28,-2067.54,-99.44,-1334.18,-1905.95,-5082.75,-2863.05,-1694.65,73108.52,122672.26,100740.54,103635.84,99860.74,102003.69,107636.26,94909.72,98935.23,99257.39,100136.86,-102173.81,-201162.34,10.9]
["AdjSchd11BpzNitsChg",0,0,0,0,0,0,0,0,0,0,0,0,-0.02,0,0,0,0,0,0,0,0.09,0,0,0]
["AdjSchd9NitsChg",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Schd11BprPtpChg",0,0,0,0,0,13.16,0,0,0,0,0,2.58,0,0,0,0,0,0,0,-0.08,-0.08,725.5100000000001,0,0]
["Schd12FercPtpTOChg",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Schd1aTaPtpChg",0,0,0,0,0,1.95,0,0,0,0,-153.47999999999999,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Sch1ScNitsChg",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Schd1ScPtpChg",0,0,0,0,0,1.25,0,0,0,0,0.04,0.13,0,0,0,0,0,0,0,0.04,-0.04,0,0,0]
["Schd2RvPtpChg",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Schd3RfDirAssignChg",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Schd5SpDirAssignChg",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Schd6SuDirAssignChg",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Schd8NfPtpChg",0,0,0.39,0,0,13.65,0,0,0,0,3.05,0,0,0,0,0,0,0,0,3.05,0,-13.5,0,0]
["Schd11BpzPtpChg",0,0,80.33,0,0,2.44,0,0,0,0,0,17.46,0,0,0,0,0,0,0,-0.04,-0.04,109.63000000000001,0,0]
["AdjSchd7FirmPtpChg",-45.98,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["AdjMonthlyAssessmentChg",0,0,0,100.77,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-100.77,0,0,0,0,0]
["AdjSchd11BpzPtpChg",0,0,55.71,0,0,2.69,0,0,0,0,0,0,0,0,0,0,0,0,0,-0.03,0,0,0,0]
["AdjSchd1aTaPtpChg",0,0,0,0,0,-2997.35,-2143.21,-1250.78,-382.3,-2272.96,0,-347.43,-8.75,-1181.22,0,0,-16.440000000000001,0,-0.51,-91.85,-107.27,-949.18,-168.1,2.58]
["Schd12FercPtpTOChg",0,0,0,0,0,0,0,0,0,0,0,-0.01,0,0,0,0,0,0,0,0,0,0,0,0]
["AdjSchd8NfPtpChg",-8.74,0,0,-0.39,0,0,0,0,0,0,0,0,0,0.13,0,0,0,0,0,-6.08,-3.05,0,0,0]
["AdjFS_LOSS_ADJ",0,-1.18,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-0.93,0,0,0,0]
["ManualAdj",0,0,0,0,1039.22,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Schd2RvPtpChg",0,0,0,0,0,0,0,0.02,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["AdjMISC_ADJ",0,0,0,0,0,0,0,0,0,0,0,0,-1125.02,0,0,0,0,0,0,0,0,0,0,0]
["AdjSchd2RvNitsChg",0,0,0,0,0,0,0,0,0,0,0,0,0,-15.39,15.39,0,0,0,0,0,-10.82,10.82,0,0]
["Z2NitsDirAssignChg",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14814.1,0,0]
["AdjZ2DANitsCreditChg",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,423.26,423.26,423.26]
["AdjZ2Sch11RPtpRRCreditInt",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["AdjZ2Sch11ZPtpRRCreditInt",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["AdjZ2Sch8PtpRRCreditInt",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["AdjZ2Sch11RPtpRRCredit"]
["AdjZ2Sch11ZPtpRRCredit"]
["AdjZ2Sch8PtpRRCredit"]
["AdjZ2Sch11NitsRRCreditInt"]

{"sheet":"MISO","index":1,"n_rows":13,"n_cols":26,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Schedule","Description","2015-01-01","2015-02-01","2015-03-01","2015-04-01","2015-05-01","2015-06-01","2015-07-01","2015-08-01","2015-09-01","2015-10-01","2015-11-01","2015-12-01","2016-01-01","2016-02-01","2016-03-01","2016-04-01","2016-05-01","2016-06-01","2016-07-01","2016-08-01","2016-09-01","2016-10-01","2016-11-01","2016-12-01"]
["Schedule 1","Scheduling, system control, & dispatch service",6599.64,5690.96,6599.64,6386.74,6599.64,6438.66,6651.14,6651.14,6436.58,6651.14,6321.3,6532.02,7653.06,7159.32,7653.06,7406.2,7652.38,7321.98,7566.06,7566.06,7321.98,7565.58,7321.52,7565.58]
["Schedule 2","Reactive supply and voltage control",17459.060000000001,15819.7,17141.18,17051.12,17612.84,17037.060000000001,17668.48,17693.46,17192.759999999998,17745.740000000002,17058.48,17627.099999999999,17915.72,16773.14,17419.5,16834.28,16038.18,15404.4,15984.72,15918.9,15560.76,16027.88,15406.84,16104.06]
["Schedule 7","Firm Point-to-point",291597.02,263377.94,291597.02,282190.65999999997,291597.02,285383.44,294801.44,294801.44,285291.7,294801.44,292377.38,302123.3,317804.15999999997,297309.42,317844.52,255320.2,263824.02,307090.3,317326.64,317326.64,307090.3,300354.06,290665.21999999997,300354.06]
["Schedule 10-Demand","FERC Annual Charges Recovery",4642.5600000000004,4368,5327.04,5083.2,4441.68,5119.2,3124.8,4426.8,3844.8,4687.2,4896,5937.12,5111.28,4704.96,5490.72,5990.4,4880.6400000000003,4471.2,3519.12,4344.96,3960,5170.8,4845.6000000000004,5580]
["Schedule 10-Energy","FERC Annual Charges Recovery",4710.04,4354.76,5426.82,5177,4427.74,5426.08,3023.52,4610.7,3690.94,5044.5,4907.08,6389.78,5163.96,5180.6400000000003,5191.5600000000004,5909.3,5206.28,4409.6400000000003,3509.28,4266.54,3673.46,5312.48,5290.46,5986.54]
["Schedule 10-FERC","FERC Annual Charges Recovery",3697.68,3339.84,3697.68,3578.4,3697.68,3578.4,3697.68,3303.36,3196.8,3303.36,3196.8,3303.36,3303.36,3090.24,3303.36,3196.8,3303.36,3196.8,3303.36,4359.84,4219.2,4359.84,4219.2,4359.84]
["Schedule 11","Wholesale distribution service",null,null,null,null,null,null,null,null,null,68.55,2.5499999999999998,39.58,3454.83,6.12,199.33,294.12,15.35,94690.07,215.01,192.52,15.93,9978.82,92338.57,150.28]
["Schedule 26","Upgrade charge from expansion plan",35325.519999999997,31906.92,35325.519999999997,34185.980000000003,35325.519999999997,34048.239999999998,35171.879999999997,35171.879999999997,34037.300000000003,35171.879999999997,33845.82,34974.019999999997,37293.96,34887.9,37262.68,0,0]
["Schedule 33","Blackstart",389.36,351.68,389.36,376.8,389.36,375,387.36,387.36,374.88,387.36,389.72,402.7,402.62,376.64,402.62,389.62,402.58,394.2,407.36,407.36,394.2,407.32,394.11799999999999,407.32]
["Schedule 45","NERC cost recovery",754.36,681.36,754.36,730.02,754.36,726.52,750.5,750.5,726.28,750.5,722.2,746.28,757.92,709.02,757.92,733.48,757.86,742.1,766.84,766.84,742.1,702.4,679.74,702.4]
[null,"Recovery of ICT Operations Cost"]
["Schedule 8","Non-Firm Point-to-point"]

{"sheet":"AECI-CU","index":2,"n_rows":3,"n_cols":25,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Dt","2015-01-01","2015-02-01","2015-03-01","2015-04-01","2015-05-01","2015-06-01","2015-07-01","2015-08-01","2015-09-01","2015-10-01","2015-11-01","2015-12-01","2016-01-01","2016-02-01","2016-03-01","2016-04-01","2016-05-01","2016-06-01","2016-07-01","2016-08-01","2016-09-01","2016-10-01","2016-11-01","2016-12-01"]
["CU",11000,11000,11000,11000,11000,11000,10736.81,11000,11263.19,11000,11000,11000,11000,11000,11000,11000,11000,11000,11000,11000,11000,11000,11000,11000]
["AECI",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8935.73,8935.73,8935.73,8935.73]

{"sheet":"MISO RTOR","index":3,"n_rows":2,"n_cols":13,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Dt","2016-01-01","2016-02-01","2016-03-01","2016-04-01","2016-05-01","2016-06-01","2016-07-01","2016-08-01","2016-09-01","2016-10-01","2016-11-01","2016-12-01"]
["RTOR Settlement",null,null,null,null,null,-268229.27,null,null,-1694307.07]

{"sheet":"SPP Short Pay-Adj","index":4,"n_rows":2,"n_cols":13,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Dt","2015-01-01","2015-02-01","2015-03-01","2015-04-01","2015-05-01","2015-06-01","2015-07-01","2015-08-01","2015-09-01","2015-10-01","2015-11-01","2015-12-01"]
["Short Pay",null,null,null,null,null,247.75,null,null,null,5.82]

{"sheet":"Summary","index":5,"n_rows":9,"n_cols":31,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Dt","2015-01-01","2015-02-01","2015-03-01","2015-04-01","2015-05-01","2015-06-01","2015-07-01","2015-08-01","2015-09-01","2015-10-01","2015-11-01","2015-12-01",null,null,"2016-01-01","2016-02-01","2016-03-01","2016-04-01","2016-05-01","2016-06-01","2016-07-01","2016-08-01","2016-09-01","2016-10-01","2016-11-01","2016-12-01",null,null,"Diff","Diff (%)"]
["SPP",{"$f":"SUM(SPP!B2:B40)+'SPP Short Pay-Adj'!B2","v":1026177.68},{"$f":"SUM(SPP!C2:C40)+'SPP Short Pay-Adj'!C2","v":1108351.7200000002},{"$f":"SUM(SPP!D2:D40)+'SPP Short Pay-Adj'!D2","v":1139796.3399999996},{"$f":"SUM(SPP!E2:E40)+'SPP Short Pay-Adj'!E2","v":1122560.52},{"$f":"SUM(SPP!F2:F40)+'SPP Short Pay-Adj'!F2","v":1128750.3999999999},{"$f":"SUM(SPP!G2:G40)+'SPP Short Pay-Adj'!G2","v":1113342.6499999997},{"$f":"SUM(SPP!H2:H40)+'SPP Short Pay-Adj'!H2","v":1131977.5299999998},{"$f":"SUM(SPP!I2:I40)+'SPP Short Pay-Adj'!I2","v":1126060.06},{"$f":"SUM(SPP!J2:J40)+'SPP Short Pay-Adj'!J2","v":1125572.1999999997},{"$f":"SUM(SPP!K2:K40)+'SPP Short Pay-Adj'!K2","v":1124941.79},{"$f":"SUM(SPP!L2:L40)+'SPP Short Pay-Adj'!L2","v":1037096.65},{"$f":"SUM(SPP!M2:M40)+'SPP Short Pay-Adj'!M2","v":1066014.19},{"$f":"SUM(B2:M2)","v":13250641.73},null,{"$f":"SUM(SPP!N2:N40)","v":990814.17},{"$f":"SUM(SPP!O2:O40)","v":1055875.8900000001},{"$f":"SUM(SPP!P2:P40)","v":1062997.32},{"$f":"SUM(SPP!Q2:Q40)","v":1053690.52},{"$f":"SUM(SPP!R2:R40)","v":1070026.8700000001},{"$f":"SUM(SPP!S2:S40)","v":1034773.1599999999},{"$f":"SUM(SPP!T2:T40)","v":1047953.25},{"$f":"SUM(SPP!U2:U40)","v":1070856.5699999998},{"$f":"SUM(SPP!V2:V40)","v":1087166.3799999999},{"$f":"SUM(SPP!W2:W40)","v":2670929.6899999995},{"$f":"SUM(SPP!X2:X40)","v":1267517.8899999999},{"$f":"SUM(SPP!Y2:Y40)","v":735051.69},{"$f":"SUM(P2:AA2)","v":14147653.399999999},null,{"$f":"AB2-N2","v":897011.66999999806}]
["MISO",{"$f":"SUM(MISO!C2:C13)","v":365175.24},{"$f":"SUM(MISO!D2:D13)","v":329891.15999999997},{"$f":"SUM(MISO!E2:E13)","v":366258.62},{"$f":"SUM(MISO!F2:F13)","v":354759.92},{"$f":"SUM(MISO!G2:G13)","v":364845.83999999997},{"$f":"SUM(MISO!H2:H13)","v":358132.60000000009},{"$f":"SUM(MISO!I2:I13)","v":365276.8},{"$f":"SUM(MISO!J2:J13)","v":367796.63999999996},{"$f":"SUM(MISO!K2:K13)","v":354792.04000000004},{"$f":"SUM(MISO!L2:L13)","v":368611.67},{"$f":"SUM(MISO!M2:M13)","v":363717.33},{"$f":"SUM(MISO!N2:N13)","v":378075.26000000007},{"$f":"SUM(B3:M3)","v":4337333.12},null,{"$f":"SUM(MISO!O2:O13)+'MISO RTOR'!B2","v":398860.87000000005},{"$f":"SUM(MISO!P2:P13)+'MISO RTOR'!C2","v":370197.40000000008},{"$f":"SUM(MISO!Q2:Q13)+'MISO RTOR'!D2","v":395525.26999999996},{"$f":"SUM(MISO!R2:R13)+'MISO RTOR'!E2","v":296074.39999999997},{"$f":"SUM(MISO!S2:S13)+'MISO RTOR'!F2","v":302080.65000000002},{"$f":"SUM(MISO!T2:T13)+'MISO RTOR'!G2","v":169491.41999999998},{"$f":"SUM(MISO!U2:U13)+'MISO RTOR'!H2","v":352598.39000000007},{"$f":"SUM(MISO!V2:V13)+'MISO RTOR'!I2","v":355149.66000000009},{"$f":"SUM(MISO!W2:W13)+'MISO RTOR'!J2","v":-1351329.1400000001},{"$f":"SUM(MISO!X2:X13)+'MISO RTOR'!K2","v":349879.18000000005},{"$f":"SUM(MISO!Y2:Y13)+'MISO RTOR'!L2","v":421161.26799999998},{"$f":"SUM(MISO!Z2:Z13)+'MISO RTOR'!M2","v":341210.08000000007},{"$f":"SUM(P3:AA3)","v":2400899.4479999999},null,-1936433.6720000003]
["MISO Estimate",354383.9,341386.4,366258.62,354500,359902.64,358132.6,356422.23,356643.77,341078.36,367075.94,348573.35,433679.21,{"$f":"SUM(B4:M4)","v":4338037.0200000005},null,378000,391058.27,395525.27,296074.40000000002,302077.65000000002,{"$f":"293000-268229.28","v":24770.719999999972},400057.89,344322.6,{"$f":"345000-1694307.07","v":-1349307.07},352763.13,311056.81,450904.27,{"$f":"SUM(P4:AA4)","v":2297303.94},null,-2040733.0800000005]
["AECI-CU",{"$f":"SUM('AECI-CU'!B2:B3)","v":11000},{"$f":"SUM('AECI-CU'!C2:C3)","v":11000},{"$f":"SUM('AECI-CU'!D2:D3)","v":11000},{"$f":"SUM('AECI-CU'!E2:E3)","v":11000},{"$f":"SUM('AECI-CU'!F2:F3)","v":11000},{"$f":"SUM('AECI-CU'!G2:G3)","v":11000},{"$f":"SUM('AECI-CU'!H2:H3)","v":10736.81},{"$f":"SUM('AECI-CU'!I2:I3)","v":11000},{"$f":"SUM('AECI-CU'!J2:J3)","v":11263.19},{"$f":"SUM('AECI-CU'!K2:K3)","v":11000},{"$f":"SUM('AECI-CU'!L2:L3)","v":11000},{"$f":"SUM('AECI-CU'!M2:M3)","v":11000},{"$f":"SUM(B5:M5)","v":132000},null,{"$f":"SUM('AECI-CU'!N2:N3)","v":11000},{"$f":"SUM('AECI-CU'!O2:O3)","v":11000},{"$f":"SUM('AECI-CU'!P2:P3)","v":11000},{"$f":"SUM('AECI-CU'!Q2:Q3)","v":11000},{"$f":"SUM('AECI-CU'!R2:R3)","v":11000},{"$f":"SUM('AECI-CU'!S2:S3)","v":11000},{"$f":"SUM('AECI-CU'!T2:T3)","v":11000},{"$f":"SUM('AECI-CU'!U2:U3)","v":11000},{"$f":"SUM('AECI-CU'!V2:V3)","v":19935.73},{"$f":"SUM('AECI-CU'!W2:W3)","v":19935.73},{"$f":"SUM('AECI-CU'!X2:X3)","v":19935.73},{"$f":"SUM('AECI-CU'!Y2:Y3)","v":19935.73},{"$f":"SUM(P5:AA5)","v":167742.92000000001},null,35742.920000000013]
[]
[]
["Total Actuals",{"$f":"SUM(B2:B3,B5)","v":1402352.92},{"$f":"SUM(C2:C3,C5)","v":1449242.8800000001},1517054.9599999995,1488320.44,1504596.2399999998,1482475.2499999998,1507991.14,1504856.7,1491627.4299999997,1504553.46,1411813.98,1455089.45,{"$f":"SUM(B8:M8)","v":17719974.849999998},null,{"$f":"SUM(P2:P3,P5)","v":1400675.04},{"$f":"SUM(Q2:Q3,Q5)","v":1437073.2900000003},1469522.59,1360764.92,1383107.52,1215264.5799999998,1411551.6400000001,1437006.23,-244227.03000000023,3040744.5999999996,1708614.8879999998,1096197.5,{"$f":"SUM(P8:AA8)","v":16716295.768000001},null,{"$f":"AB8-N8","v":-1003679.0819999967},{"$f":"AB8/N8-1","v":-5.6641112106318614E-2}]
["Total w/ Estimate",{"$f":"SUM(B2,B4:B5)","v":1391561.58},{"$f":"SUM(C2,C4:C5)","v":1460738.12},1517054.9599999995,1488060.52,1499653.04,1482475.2499999995,1499136.5699999998,1493703.83,1477913.7499999995,1503017.73,1396670,1510693.4,{"$f":"SUM(B9:M9)","v":17720678.75},null,{"$f":"SUM(P2,P4:P5)","v":1379814.17},{"$f":"SUM(Q2,Q4:Q5)","v":1457934.1600000001},1469522.59,1360764.92,1383104.52,1070543.8799999999,1459011.1400000001,1426179.17,-242204.96000000017,3043628.5499999993,1598510.43,1205891.69,{"$f":"SUM(P9:AA9)","v":16612700.259999996},null,{"$f":"AB9-N9","v":-1107978.4900000039},{"$f":"AB9/N9-1","v":-6.2524607868082005E-2}]