{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Usage","Cost per kWh","Plan EFL Eval","data","Crude Oil-M-2018-June","Natural Gas-M-2018-June","coal, raw"],"not_rendered":{"charts":4,"images":9,"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":"Usage","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Cost per kWh","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Plan EFL Eval","index":2,"n_rows":67,"n_cols":69,"rows_kept":67,"cut":false,"hidden":false,"merged":[[43,2,43,11],[2,5,2,9],[2,61,2,65],[2,45,2,49],[2,37,2,41],[2,29,2,33],[2,21,2,25],[2,13,2,17],[2,53,2,57]]}
[]
[]
[null,null,null,null,null,"TXU, Current, Easy Saver",null,null,null,null,null,null,null,"TXU, New-Price Saver 12",null,null,null,null,null,null,null,"TXU, New-Price Saver 18",null,null,null,null,null,null,null,"TXU, New-Price Saver 24",null,null,null,null,null,null,null,"TXU, Real Choice 24, Adjusted",null,null,null,null,null,null,null,"Reliant, Clear Flex",null,null,null,null,null,null,null,"Smart Deal 36",null,null,null,null,null,null,null,"Smart Deal 12  (25 June 2018, Current)"]
[]
[null,null,null,null,"Plan 1",null,null,null,null,true,null,null,"Plan 2",null,null,null,null,true,null,null,"Plan 3",null,null,null,null,true,null,null,"Plan 4",null,null,null,null,true,null,null,"Plan 5",null,null,null,null,true,null,null,"Plan 6",null,null,null,null,true,null,null,"Plan 7",null,null,null,null,true,null,null,"Plan 8",null,null,null,null,true]
[null,null,null,null,null,"Base Charge",null,null,9.9499999999999993,{"$f":"IF(I6=\"\",\"\",I6)","v":9.9499999999999993},null,null,null,"Base Charge",null,null,9.9499999999999993,{"$f":"IF(Q6=\"\",\"\",Q6)","v":9.9499999999999993},null,null,null,"Base Charge",null,null,9.9499999999999993,{"$f":"IF(Y6=\"\",\"\",Y6)","v":9.9499999999999993},null,null,null,"Base Charge",null,null,9.9499999999999993,{"$f":"IF(AG6=\"\",\"\",AG6)","v":9.9499999999999993},null,null,null,"Base Charge",null,null,9.9499999999999993,{"$f":"IF(AO6=\"\",\"\",AO6)","v":9.9499999999999993},null,null,null,"Base Charge",null,null,9.9499999999999993,{"$f":"IF(AW6=\"\",\"\",AW6)","v":9.9499999999999993},null,null,null,"Base Charge",null,null,9.9499999999999993,{"$f":"IF(BE6=\"\",\"\",BE6)","v":9.9499999999999993},null,null,null,"Base Charge",null,null,9.9499999999999993,{"$f":"IF(BM6=\"\",\"\",BM6)","v":9.9499999999999993}]
[null,null,null,null,null,"1st Tier",null,1200,10.1,{"$f":"IF(I7=\"\",\"\",I7/100)","v":0.10099999999999999},null,null,null,"1st Tier",null,1200,9.3000000000000007,{"$f":"IF(Q7=\"\",\"\",Q7/100)","v":9.3000000000000013E-2},null,null,null,"1st Tier",null,1200,10.1,{"$f":"IF(Y7=\"\",\"\",Y7/100)","v":0.10099999999999999},null,null,null,"1st Tier",null,1200,10.6,{"$f":"IF(AG7=\"\",\"\",AG7/100)","v":0.106},null,null,null,"1st Tier",null,1350,8.4,{"$f":"IF(AO7=\"\",\"\",AO7/100)","v":8.4000000000000005E-2},null,null,null,"1st Tier",null,">",8.1,{"$f":"IF(AW7=\"\",\"\",AW7/100)","v":8.1000000000000003E-2},null,null,null,"1st Tier",null,1200,12.2,{"$f":"IF(BE7=\"\",\"\",BE7/100)","v":0.122},null,null,null,"1st Tier",null,1200,9.6999999999999993,{"$f":"IF(BM7=\"\",\"\",BM7/100)","v":9.6999999999999989E-2}]
[null,null,null,null,null,"2nd Tier",null,2000,5.0999999999999996,{"$f":"IF(I8=\"\",\"\",I8/100)","v":5.0999999999999997E-2},null,null,null,"2nd Tier",null,2000,4.7,{"$f":"IF(Q8=\"\",\"\",Q8/100)","v":4.7E-2},null,null,null,"2nd Tier",null,2000,5.0999999999999996,{"$f":"IF(Y8=\"\",\"\",Y8/100)","v":5.0999999999999997E-2},null,null,null,"2nd Tier",null,2000,5.3,{"$f":"IF(AG8=\"\",\"\",AG8/100)","v":5.2999999999999999E-2},null,null,null,"2nd Tier",null,2000,1.9,{"$f":"IF(AO8=\"\",\"\",AO8/100)","v":1.9E-2},null,null,null,"2nd Tier",null,null,null,{"$f":"IF(AW8=\"\",\"\",AW8/100)","v":""},null,null,null,"2nd Tier",null,2000,6.1,{"$f":"IF(BE8=\"\",\"\",BE8/100)","v":6.0999999999999999E-2},null,null,null,"2nd Tier",null,2000,4.9000000000000004,{"$f":"IF(BM8=\"\",\"\",BM8/100)","v":4.9000000000000002E-2}]
[null,null,null,null,null,"3rd Tier",null,">",10.6,{"$f":"IF(I9=\"\",\"\",I9/100)","v":0.106},null,null,null,"3rd Tier",null,">",9.8000000000000007,{"$f":"IF(Q9=\"\",\"\",Q9/100)","v":9.8000000000000004E-2},null,null,null,"3rd Tier",null,">",10.6,{"$f":"IF(Y9=\"\",\"\",Y9/100)","v":0.106},null,null,null,"3rd Tier",null,">",11.1,{"$f":"IF(AG9=\"\",\"\",AG9/100)","v":0.111},null,null,null,"3rd Tier",null,">",16,{"$f":"IF(AO9=\"\",\"\",AO9/100)","v":0.16},null,null,null,"3rd Tier",null,null,null,{"$f":"IF(AW9=\"\",\"\",AW9/100)","v":""},null,null,null,"3rd Tier",null,">",12.8,{"$f":"IF(BE9=\"\",\"\",BE9/100)","v":0.128},null,null,null,"3rd Tier",null,">",10.199999999999999,{"$f":"IF(BM9=\"\",\"\",BM9/100)","v":0.10199999999999999}]
[null,null,null,null,null,"4th Tier",null,null,null,{"$f":"IF(I10=\"\",\"\",I10/100)","v":""},null,null,null,"4th Tier",null,null,null,{"$f":"IF(Q10=\"\",\"\",Q10/100)","v":""},null,null,null,"4th Tier",null,null,null,{"$f":"IF(Y10=\"\",\"\",Y10/100)","v":""},null,null,null,"4th Tier",null,null,null,{"$f":"IF(AG10=\"\",\"\",AG10/100)","v":""},null,null,null,"4th Tier",null,null,null,{"$f":"IF(AO10=\"\",\"\",AO10/100)","v":""},null,null,null,"4th Tier",null,null,null,{"$f":"IF(AW10=\"\",\"\",AW10/100)","v":""},null,null,null,"4th Tier",null,null,null,{"$f":"IF(BE10=\"\",\"\",BE10/100)","v":""},null,null,null,"4th Tier",null,null,null,{"$f":"IF(BM10=\"\",\"\",BM10/100)","v":""}]
[]
[null,null,null,null,null,"TDU Base",null,null,5.47,{"$f":"IF(I12=\"\",\"\",I12)","v":5.47},null,null,null,"TDU Base",null,null,5.47,{"$f":"IF(Q12=\"\",\"\",Q12)","v":5.47},null,null,null,"TDU Base",null,null,5.47,{"$f":"IF(Y12=\"\",\"\",Y12)","v":5.47},null,null,null,"TDU Base",null,null,5.47,{"$f":"IF(AG12=\"\",\"\",AG12)","v":5.47},null,null,null,"TDU Base",null,null,5.47,{"$f":"IF(AO12=\"\",\"\",AO12)","v":5.47},null,null,null,"TDU Base",null,null,5.47,{"$f":"IF(AW12=\"\",\"\",AW12)","v":5.47},null,null,null,"TDU Base",null,null,5.47,{"$f":"IF(BE12=\"\",\"\",BE12)","v":5.47},null,null,null,"TDU Base",null,null,5.47,{"$f":"IF(BM12=\"\",\"\",BM12)","v":5.47}]
[null,null,null,null,null,"TDU per kWh",null,null,4.1112000000000002,{"$f":"IF(I13=\"\",\"\",I13/100)","v":4.1112000000000003E-2},null,null,null,"TDU per kWh",null,null,4.1112000000000002,{"$f":"IF(Q13=\"\",\"\",Q13/100)","v":4.1112000000000003E-2},null,null,null,"TDU per kWh",null,null,4.1112000000000002,{"$f":"IF(Y13=\"\",\"\",Y13/100)","v":4.1112000000000003E-2},null,null,null,"TDU per kWh",null,null,4.1112000000000002,{"$f":"IF(AG13=\"\",\"\",AG13/100)","v":4.1112000000000003E-2},null,null,null,"TDU per kWh",null,null,4.1112000000000002,{"$f":"IF(AO13=\"\",\"\",AO13/100)","v":4.1112000000000003E-2},null,null,null,"TDU per kWh",null,null,3.8711000000000002,{"$f":"IF(AW13=\"\",\"\",AW13/100)","v":3.8711000000000002E-2},null,null,null,"TDU per kWh",null,null,4.1112000000000002,{"$f":"IF(BE13=\"\",\"\",BE13/100)","v":4.1112000000000003E-2},null,null,null,"TDU per kWh",null,null,4.1112000000000002,{"$f":"IF(BM13=\"\",\"\",BM13/100)","v":4.1112000000000003E-2}]
[]
[null,null,null,null,null,"Usage Credit",null,1200,30,{"$f":"IF(I15=\"\",\"\",I15)","v":30},null,null,null,"Usage Credit",null,1200,30,{"$f":"IF(Q15=\"\",\"\",Q15)","v":30},null,null,null,"Usage Credit",null,1200,30,{"$f":"IF(Y15=\"\",\"\",Y15)","v":30},null,null,null,"Usage Credit",null,1200,30,{"$f":"IF(AG15=\"\",\"\",AG15)","v":30},null,null,null,"Usage Credit",null,null,null,{"$f":"IF(AO15=\"\",\"\",AO15)","v":""},null,null,null,"Usage Credit",null,800,9.9499999999999993,{"$f":"IF(AW15=\"\",\"\",AW15)","v":9.9499999999999993},null,null,null,"Usage Credit",null,1200,30,{"$f":"IF(BE15=\"\",\"\",BE15)","v":30},null,null,null,"Usage Credit",null,1200,30,{"$f":"IF(BM15=\"\",\"\",BM15)","v":30}]
[null,null,null,null,null,"Other Credits",null,null,null,{"$f":"IF(I16=\"\",\"\",I16)","v":""},null,null,null,"Other Credits",null,null,null,{"$f":"IF(Q16=\"\",\"\",Q16)","v":""},null,null,null,"Other Credits",null,null,null,{"$f":"IF(Y16=\"\",\"\",Y16)","v":""},null,null,null,"Other Credits",null,null,null,{"$f":"IF(AG16=\"\",\"\",AG16)","v":""},null,null,null,"Other Credits",null,null,null,{"$f":"IF(AO16=\"\",\"\",AO16)","v":""},null,null,null,"Other Credits",null,null,null,{"$f":"IF(AW16=\"\",\"\",AW16)","v":""},null,null,null,"Other Credits",null,null,null,{"$f":"IF(BE16=\"\",\"\",BE16)","v":""},null,null,null,"Other Credits",null,null,{"$f":"150/12","v":12.5},{"$f":"IF(BM16=\"\",\"\",BM16)","v":12.5}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Estimated",null,"Effective",null,null,null,null,null,"Estimated",null,"Effective",null,null,null,null,null,"Estimated",null,"Effective",null,null,null,null,null,"Estimated",null,"Effective",null,null,null,null,null,"Estimated",null,"Effective",null,null,null,null,null,"Estimated",null,"Effective",null,null,null,null,null,"Estimated",null,"Effective",null,null,null,null,null,"Estimated",null,"Effective"]
[null,null,"Input kWh Usage",null,null,null,null,"Plan","TDU","Total Bill",null,"¢ per kWh",null,null,null,"Plan","TDU","Total Bill",null,"¢ per kWh",null,null,null,"Plan","TDU","Total Bill",null,"¢ per kWh",null,null,null,"Plan","TDU","Total Bill",null,"¢ per kWh",null,null,null,"Plan","TDU","Total Bill",null,"¢ per kWh",null,null,null,"Plan","TDU","Total Bill",null,"¢ per kWh",null,null,null,"Plan","TDU","Total Bill",null,"¢ per kWh",null,null,null,"Plan","TDU","Total Bill",null,"¢ per kWh"]
[null,null,null,"s",null,500,null,{"$f":"IF(OR(I$6=\"\",H$7=\"\",J$7=\"\"),\"\",J$6+CalcPlan(J$5,$F22,H$7)-GetUsageCredits($F22, H$15, J$15)-IF(J$16=\"\",0,J$16))","v":60.449999999999989},{"$f":"IF(OR(J$12=\"\",J$13=\"\"),\"\", J$12+($F22*J$13))","v":26.026},{"$f":"IF(AND(H22=\"\",I22=\"\"),\"\",SUM(H22:I22))","v":86.475999999999985},null,{"$f":"IF(OR(J22=\"\",$F22=\"\"),\"\", J22/$F22*100)","v":17.295199999999998},null,null,null,{"$f":"IF(OR(Q$6=\"\",P$7=\"\",R$7=\"\"),\"\",R$6+CalcPlan(R$5,$F22,P$7)-GetUsageCredits($F22, P$15, R$15)-IF(R$16=\"\",0,R$16))","v":56.45},{"$f":"IF(OR(R$12=\"\",R$13=\"\"),\"\", R$12+($F22*R$13))","v":26.026},{"$f":"IF(AND(P22=\"\",Q22=\"\"),\"\",SUM(P22:Q22))","v":82.475999999999999},null,{"$f":"IF(OR(R22=\"\",$F22=\"\"),\"\", R22/$F22*100)","v":16.495199999999997},null,null,null,{"$f":"IF(OR(Y$6=\"\",X$7=\"\",Z$7=\"\"),\"\",Z$6+CalcPlan(Z$5,$F22,X$7)-GetUsageCredits($F22, X$15, Z$15)-IF(Z$16=\"\",0,Z$16))","v":60.449999999999989},{"$f":"IF(OR(Z$12=\"\",Z$13=\"\"),\"\", Z$12+($F22*Z$13))","v":26.026},{"$f":"IF(AND(X22=\"\",Y22=\"\"),\"\",SUM(X22:Y22))","v":86.475999999999985},null,{"$f":"IF(OR(Z22=\"\",$F22=\"\"),\"\", Z22/$F22*100)","v":17.295199999999998},null,null,null,{"$f":"IF(OR(AG$6=\"\",AF$7=\"\",AH$7=\"\"),\"\",AH$6+CalcPlan(AH$5,$F22,AF$7)-GetUsageCredits($F22, AF$15, AH$15)-IF(AH$16=\"\",0,AH$16))","v":62.95},{"$f":"IF(OR(AH$12=\"\",AH$13=\"\"),\"\", AH$12+($F22*AH$13))","v":26.026},{"$f":"IF(AND(AF22=\"\",AG22=\"\"),\"\",SUM(AF22:AG22))","v":88.975999999999999},null,{"$f":"IF(OR(AH22=\"\",$F22=\"\"),\"\", AH22/$F22*100)","v":17.795200000000001},null,null,null,{"$f":"IF(OR(AO$6=\"\",AN$7=\"\",AP$7=\"\"),\"\",AP$6+CalcPlan(AP$5,$F22,AN$7)-GetUsageCredits($F22, AN$15, AP$15)-IF(AP$16=\"\",0,AP$16))","v":51.95},{"$f":"IF(OR(AP$12=\"\",AP$13=\"\"),\"\", AP$12+($F22*AP$13))","v":26.026},{"$f":"IF(AND(AN22=\"\",AO22=\"\"),\"\",SUM(AN22:AO22))","v":77.975999999999999},null,{"$f":"IF(OR(AP22=\"\",$F22=\"\"),\"\", AP22/$F22*100)","v":15.5952},null,null,null,{"$f":"IF(OR(AW$6=\"\",AV$7=\"\",AX$7=\"\"),\"\",AX$6+CalcPlan(AX$5,$F22,AV$7)-GetUsageCredits($F22, AV$15, AX$15)-IF(AX$16=\"\",0,AX$16))","v":50.45},{"$f":"IF(OR(AX$12=\"\",AX$13=\"\"),\"\", AX$12+($F22*AX$13))","v":24.825500000000002},{"$f":"IF(AND(AV22=\"\",AW22=\"\"),\"\",SUM(AV22:AW22))","v":75.275500000000008},null,{"$f":"IF(OR(AX22=\"\",$F22=\"\"),\"\", AX22/$F22*100)","v":15.055100000000001},null,null,null,{"$f":"IF(OR(BE$6=\"\",BD$7=\"\",BF$7=\"\"),\"\",BF$6+CalcPlan(BF$5,$F22,BD$7)-GetUsageCredits($F22, BD$15, BF$15)-IF(BF$16=\"\",0,BF$16))","v":70.95},{"$f":"IF(OR(BF$12=\"\",BF$13=\"\"),\"\", BF$12+($F22*BF$13))","v":26.026},{"$f":"IF(AND(BD22=\"\",BE22=\"\"),\"\",SUM(BD22:BE22))","v":96.975999999999999},null,{"$f":"IF(OR(BF22=\"\",$F22=\"\"),\"\", BF22/$F22*100)","v":19.395199999999999},null,null,null,{"$f":"IF(OR(BM$6=\"\",BL$7=\"\",BN$7=\"\"),\"\",BN$6+CalcPlan(BN$5,$F22,BL$7)-GetUsageCredits($F22, BL$15, BN$15)-IF(BN$16=\"\",0,BN$16))","v":45.949999999999989},{"$f":"IF(OR(BN$12=\"\",BN$13=\"\"),\"\", BN$12+($F22*BN$13))","v":26.026},{"$f":"IF(AND(BL22=\"\",BM22=\"\"),\"\",SUM(BL22:BM22))","v":71.975999999999985},null,{"$f":"IF(OR(BN22=\"\",$F22=\"\"),\"\", BN22/$F22*100)","v":14.395199999999997}]
[null,null,null,"s",null,1000,null,{"$f":"IF(OR(I$6=\"\",H$7=\"\",J$7=\"\"),\"\",J$6+CalcPlan(J$5,$F23,H$7)-GetUsageCredits($F23, H$15, J$15)-IF(J$16=\"\",0,J$16))","v":110.94999999999999},{"$f":"IF(OR(J$12=\"\",J$13=\"\"),\"\", J$12+($F23*J$13))","v":46.582000000000001},{"$f":"IF(AND(H23=\"\",I23=\"\"),\"\",SUM(H23:I23))","v":157.53199999999998},null,{"$f":"IF(OR(J23=\"\",$F23=\"\"),\"\", J23/$F23*100)","v":15.753199999999998},null,null,null,{"$f":"IF(OR(Q$6=\"\",P$7=\"\",R$7=\"\"),\"\",R$6+CalcPlan(R$5,$F23,P$7)-GetUsageCredits($F23, P$15, R$15)-IF(R$16=\"\",0,R$16))","v":102.95000000000002},{"$f":"IF(OR(R$12=\"\",R$13=\"\"),\"\", R$12+($F23*R$13))","v":46.582000000000001},{"$f":"IF(AND(P23=\"\",Q23=\"\"),\"\",SUM(P23:Q23))","v":149.53200000000001},null,{"$f":"IF(OR(R23=\"\",$F23=\"\"),\"\", R23/$F23*100)","v":14.953199999999999},null,null,null,{"$f":"IF(OR(Y$6=\"\",X$7=\"\",Z$7=\"\"),\"\",Z$6+CalcPlan(Z$5,$F23,X$7)-GetUsageCredits($F23, X$15, Z$15)-IF(Z$16=\"\",0,Z$16))","v":110.94999999999999},{"$f":"IF(OR(Z$12=\"\",Z$13=\"\"),\"\", Z$12+($F23*Z$13))","v":46.582000000000001},{"$f":"IF(AND(X23=\"\",Y23=\"\"),\"\",SUM(X23:Y23))","v":157.53199999999998},null,{"$f":"IF(OR(Z23=\"\",$F23=\"\"),\"\", Z23/$F23*100)","v":15.753199999999998},null,null,null,{"$f":"IF(OR(AG$6=\"\",AF$7=\"\",AH$7=\"\"),\"\",AH$6+CalcPlan(AH$5,$F23,AF$7)-GetUsageCredits($F23, AF$15, AH$15)-IF(AH$16=\"\",0,AH$16))","v":115.95},{"$f":"IF(OR(AH$12=\"\",AH$13=\"\"),\"\", AH$12+($F23*AH$13))","v":46.582000000000001},{"$f":"IF(AND(AF23=\"\",AG23=\"\"),\"\",SUM(AF23:AG23))","v":162.53200000000001},null,{"$f":"IF(OR(AH23=\"\",$F23=\"\"),\"\", AH23/$F23*100)","v":16.2532},null,null,null,{"$f":"IF(OR(AO$6=\"\",AN$7=\"\",AP$7=\"\"),\"\",AP$6+CalcPlan(AP$5,$F23,AN$7)-GetUsageCredits($F23, AN$15, AP$15)-IF(AP$16=\"\",0,AP$16))","v":93.95},{"$f":"IF(OR(AP$12=\"\",AP$13=\"\"),\"\", AP$12+($F23*AP$13))","v":46.582000000000001},{"$f":"IF(AND(AN23=\"\",AO23=\"\"),\"\",SUM(AN23:AO23))","v":140.53200000000001},null,{"$f":"IF(OR(AP23=\"\",$F23=\"\"),\"\", AP23/$F23*100)","v":14.053200000000002},null,null,null,{"$f":"IF(OR(AW$6=\"\",AV$7=\"\",AX$7=\"\"),\"\",AX$6+CalcPlan(AX$5,$F23,AV$7)-GetUsageCredits($F23, AV$15, AX$15)-IF(AX$16=\"\",0,AX$16))","v":81},{"$f":"IF(OR(AX$12=\"\",AX$13=\"\"),\"\", AX$12+($F23*AX$13))","v":44.181000000000004},{"$f":"IF(AND(AV23=\"\",AW23=\"\"),\"\",SUM(AV23:AW23))","v":125.18100000000001},null,{"$f":"IF(OR(AX23=\"\",$F23=\"\"),\"\", AX23/$F23*100)","v":12.518100000000002},null,null,null,{"$f":"IF(OR(BE$6=\"\",BD$7=\"\",BF$7=\"\"),\"\",BF$6+CalcPlan(BF$5,$F23,BD$7)-GetUsageCredits($F23, BD$15, BF$15)-IF(BF$16=\"\",0,BF$16))","v":131.94999999999999},{"$f":"IF(OR(BF$12=\"\",BF$13=\"\"),\"\", BF$12+($F23*BF$13))","v":46.582000000000001},{"$f":"IF(AND(BD23=\"\",BE23=\"\"),\"\",SUM(BD23:BE23))","v":178.53199999999998},null,{"$f":"IF(OR(BF23=\"\",$F23=\"\"),\"\", BF23/$F23*100)","v":17.853199999999998},null,null,null,{"$f":"IF(OR(BM$6=\"\",BL$7=\"\",BN$7=\"\"),\"\",BN$6+CalcPlan(BN$5,$F23,BL$7)-GetUsageCredits($F23, BL$15, BN$15)-IF(BN$16=\"\",0,BN$16))","v":94.449999999999989},{"$f":"IF(OR(BN$12=\"\",BN$13=\"\"),\"\", BN$12+($F23*BN$13))","v":46.582000000000001},{"$f":"IF(AND(BL23=\"\",BM23=\"\"),\"\",SUM(BL23:BM23))","v":141.03199999999998},null,{"$f":"IF(OR(BN23=\"\",$F23=\"\"),\"\", BN23/$F23*100)","v":14.103199999999999}]
[null,null,null,"s",null,2000,null,{"$f":"IF(OR(I$6=\"\",H$7=\"\",J$7=\"\"),\"\",J$6+CalcPlan(J$5,$F24,H$7)-GetUsageCredits($F24, H$15, J$15)-IF(J$16=\"\",0,J$16))","v":141.94999999999999},{"$f":"IF(OR(J$12=\"\",J$13=\"\"),\"\", J$12+($F24*J$13))","v":87.694000000000003},{"$f":"IF(AND(H24=\"\",I24=\"\"),\"\",SUM(H24:I24))","v":229.64400000000001},null,{"$f":"IF(OR(J24=\"\",$F24=\"\"),\"\", J24/$F24*100)","v":11.482200000000001},null,null,null,{"$f":"IF(OR(Q$6=\"\",P$7=\"\",R$7=\"\"),\"\",R$6+CalcPlan(R$5,$F24,P$7)-GetUsageCredits($F24, P$15, R$15)-IF(R$16=\"\",0,R$16))","v":129.15},{"$f":"IF(OR(R$12=\"\",R$13=\"\"),\"\", R$12+($F24*R$13))","v":87.694000000000003},{"$f":"IF(AND(P24=\"\",Q24=\"\"),\"\",SUM(P24:Q24))","v":216.84399999999999},null,{"$f":"IF(OR(R24=\"\",$F24=\"\"),\"\", R24/$F24*100)","v":10.842199999999998},null,null,null,{"$f":"IF(OR(Y$6=\"\",X$7=\"\",Z$7=\"\"),\"\",Z$6+CalcPlan(Z$5,$F24,X$7)-GetUsageCredits($F24, X$15, Z$15)-IF(Z$16=\"\",0,Z$16))","v":141.94999999999999},{"$f":"IF(OR(Z$12=\"\",Z$13=\"\"),\"\", Z$12+($F24*Z$13))","v":87.694000000000003},{"$f":"IF(AND(X24=\"\",Y24=\"\"),\"\",SUM(X24:Y24))","v":229.64400000000001},null,{"$f":"IF(OR(Z24=\"\",$F24=\"\"),\"\", Z24/$F24*100)","v":11.482200000000001},null,null,null,{"$f":"IF(OR(AG$6=\"\",AF$7=\"\",AH$7=\"\"),\"\",AH$6+CalcPlan(AH$5,$F24,AF$7)-GetUsageCredits($F24, AF$15, AH$15)-IF(AH$16=\"\",0,AH$16))","v":149.54999999999998},{"$f":"IF(OR(AH$12=\"\",AH$13=\"\"),\"\", AH$12+($F24*AH$13))","v":87.694000000000003},{"$f":"IF(AND(AF24=\"\",AG24=\"\"),\"\",SUM(AF24:AG24))","v":237.24399999999997},null,{"$f":"IF(OR(AH24=\"\",$F24=\"\"),\"\", AH24/$F24*100)","v":11.8622},null,null,null,{"$f":"IF(OR(AO$6=\"\",AN$7=\"\",AP$7=\"\"),\"\",AP$6+CalcPlan(AP$5,$F24,AN$7)-GetUsageCredits($F24, AN$15, AP$15)-IF(AP$16=\"\",0,AP$16))","v":135.69999999999999},{"$f":"IF(OR(AP$12=\"\",AP$13=\"\"),\"\", AP$12+($F24*AP$13))","v":87.694000000000003},{"$f":"IF(AND(AN24=\"\",AO24=\"\"),\"\",SUM(AN24:AO24))","v":223.39400000000001},null,{"$f":"IF(OR(AP24=\"\",$F24=\"\"),\"\", AP24/$F24*100)","v":11.169700000000001},null,null,null,{"$f":"IF(OR(AW$6=\"\",AV$7=\"\",AX$7=\"\"),\"\",AX$6+CalcPlan(AX$5,$F24,AV$7)-GetUsageCredits($F24, AV$15, AX$15)-IF(AX$16=\"\",0,AX$16))","v":162},{"$f":"IF(OR(AX$12=\"\",AX$13=\"\"),\"\", AX$12+($F24*AX$13))","v":82.89200000000001},{"$f":"IF(AND(AV24=\"\",AW24=\"\"),\"\",SUM(AV24:AW24))","v":244.892},null,{"$f":"IF(OR(AX24=\"\",$F24=\"\"),\"\", AX24/$F24*100)","v":12.2446},null,null,null,{"$f":"IF(OR(BE$6=\"\",BD$7=\"\",BF$7=\"\"),\"\",BF$6+CalcPlan(BF$5,$F24,BD$7)-GetUsageCredits($F24, BD$15, BF$15)-IF(BF$16=\"\",0,BF$16))","v":175.14999999999998},{"$f":"IF(OR(BF$12=\"\",BF$13=\"\"),\"\", BF$12+($F24*BF$13))","v":87.694000000000003},{"$f":"IF(AND(BD24=\"\",BE24=\"\"),\"\",SUM(BD24:BE24))","v":262.84399999999999},null,{"$f":"IF(OR(BF24=\"\",$F24=\"\"),\"\", BF24/$F24*100)","v":13.142199999999999},null,null,null,{"$f":"IF(OR(BM$6=\"\",BL$7=\"\",BN$7=\"\"),\"\",BN$6+CalcPlan(BN$5,$F24,BL$7)-GetUsageCredits($F24, BL$15, BN$15)-IF(BN$16=\"\",0,BN$16))","v":123.04999999999998},{"$f":"IF(OR(BN$12=\"\",BN$13=\"\"),\"\", BN$12+($F24*BN$13))","v":87.694000000000003},{"$f":"IF(AND(BL24=\"\",BM24=\"\"),\"\",SUM(BL24:BM24))","v":210.74399999999997},null,{"$f":"IF(OR(BN24=\"\",$F24=\"\"),\"\", BN24/$F24*100)","v":10.537199999999999}]
[]
[null,null,null,1,null,{"$f":"data!K214","v":2985},null,{"$f":"IF(OR(I$6=\"\",H$7=\"\",J$7=\"\"),\"\",J$6+CalcPlan(J$5,$F26,H$7)-GetUsageCredits($F26, H$15, J$15)-IF(J$16=\"\",0,J$16))","v":246.35999999999996},{"$f":"IF(OR(J$12=\"\",J$13=\"\"),\"\", J$12+($F26*J$13))","v":128.18932000000001},{"$f":"IF(AND(H26=\"\",I26=\"\"),\"\",SUM(H26:I26))","v":374.54931999999997},null,{"$f":"IF(OR(J26=\"\",$F26=\"\"),\"\", J26/$F26*100)","v":12.547715912897822},null,null,null,{"$f":"IF(OR(Q$6=\"\",P$7=\"\",R$7=\"\"),\"\",R$6+CalcPlan(R$5,$F26,P$7)-GetUsageCredits($F26, P$15, R$15)-IF(R$16=\"\",0,R$16))","v":225.68},{"$f":"IF(OR(R$12=\"\",R$13=\"\"),\"\", R$12+($F26*R$13))","v":128.18932000000001},{"$f":"IF(AND(P26=\"\",Q26=\"\"),\"\",SUM(P26:Q26))","v":353.86932000000002},null,{"$f":"IF(OR(R26=\"\",$F26=\"\"),\"\", R26/$F26*100)","v":11.854918592964825},null,null,null,{"$f":"IF(OR(Y$6=\"\",X$7=\"\",Z$7=\"\"),\"\",Z$6+CalcPlan(Z$5,$F26,X$7)-GetUsageCredits($F26, X$15, Z$15)-IF(Z$16=\"\",0,Z$16))","v":246.35999999999996},{"$f":"IF(OR(Z$12=\"\",Z$13=\"\"),\"\", Z$12+($F26*Z$13))","v":128.18932000000001},{"$f":"IF(AND(X26=\"\",Y26=\"\"),\"\",SUM(X26:Y26))","v":374.54931999999997},null,{"$f":"IF(OR(Z26=\"\",$F26=\"\"),\"\", Z26/$F26*100)","v":12.547715912897822},null,null,null,{"$f":"IF(OR(AG$6=\"\",AF$7=\"\",AH$7=\"\"),\"\",AH$6+CalcPlan(AH$5,$F26,AF$7)-GetUsageCredits($F26, AF$15, AH$15)-IF(AH$16=\"\",0,AH$16))","v":258.88499999999999},{"$f":"IF(OR(AH$12=\"\",AH$13=\"\"),\"\", AH$12+($F26*AH$13))","v":128.18932000000001},{"$f":"IF(AND(AF26=\"\",AG26=\"\"),\"\",SUM(AF26:AG26))","v":387.07432},null,{"$f":"IF(OR(AH26=\"\",$F26=\"\"),\"\", AH26/$F26*100)","v":12.967313902847572},null,null,null,{"$f":"IF(OR(AO$6=\"\",AN$7=\"\",AP$7=\"\"),\"\",AP$6+CalcPlan(AP$5,$F26,AN$7)-GetUsageCredits($F26, AN$15, AP$15)-IF(AP$16=\"\",0,AP$16))","v":293.3},{"$f":"IF(OR(AP$12=\"\",AP$13=\"\"),\"\", AP$12+($F26*AP$13))","v":128.18932000000001},{"$f":"IF(AND(AN26=\"\",AO26=\"\"),\"\",SUM(AN26:AO26))","v":421.48932000000002},null,{"$f":"IF(OR(AP26=\"\",$F26=\"\"),\"\", AP26/$F26*100)","v":14.120245226130654},null,null,null,{"$f":"IF(OR(AW$6=\"\",AV$7=\"\",AX$7=\"\"),\"\",AX$6+CalcPlan(AX$5,$F26,AV$7)-GetUsageCredits($F26, AV$15, AX$15)-IF(AX$16=\"\",0,AX$16))","v":241.785},{"$f":"IF(OR(AX$12=\"\",AX$13=\"\"),\"\", AX$12+($F26*AX$13))","v":121.02233500000001},{"$f":"IF(AND(AV26=\"\",AW26=\"\"),\"\",SUM(AV26:AW26))","v":362.80733500000002},null,{"$f":"IF(OR(AX26=\"\",$F26=\"\"),\"\", AX26/$F26*100)","v":12.154349581239533},null,null,null,{"$f":"IF(OR(BE$6=\"\",BD$7=\"\",BF$7=\"\"),\"\",BF$6+CalcPlan(BF$5,$F26,BD$7)-GetUsageCredits($F26, BD$15, BF$15)-IF(BF$16=\"\",0,BF$16))","v":301.22999999999996},{"$f":"IF(OR(BF$12=\"\",BF$13=\"\"),\"\", BF$12+($F26*BF$13))","v":128.18932000000001},{"$f":"IF(AND(BD26=\"\",BE26=\"\"),\"\",SUM(BD26:BE26))","v":429.41931999999997},null,{"$f":"IF(OR(BF26=\"\",$F26=\"\"),\"\", BF26/$F26*100)","v":14.385906867671691},null,null,null,{"$f":"IF(OR(BM$6=\"\",BL$7=\"\",BN$7=\"\"),\"\",BN$6+CalcPlan(BN$5,$F26,BL$7)-GetUsageCredits($F26, BL$15, BN$15)-IF(BN$16=\"\",0,BN$16))","v":223.51999999999998},{"$f":"IF(OR(BN$12=\"\",BN$13=\"\"),\"\", BN$12+($F26*BN$13))","v":128.18932000000001},{"$f":"IF(AND(BL26=\"\",BM26=\"\"),\"\",SUM(BL26:BM26))","v":351.70931999999999},null,{"$f":"IF(OR(BN26=\"\",$F26=\"\"),\"\", BN26/$F26*100)","v":11.782556783919599}]
[null,null,null,2,null,{"$f":"data!K215","v":3134},null,{"$f":"IF(OR(I$6=\"\",H$7=\"\",J$7=\"\"),\"\",J$6+CalcPlan(J$5,$F27,H$7)-GetUsageCredits($F27, H$15, J$15)-IF(J$16=\"\",0,J$16))","v":262.154},134.31500800000001,396.46900800000003,null,12.650574601148692,null,null,null,{"$f":"IF(OR(Q$6=\"\",P$7=\"\",R$7=\"\"),\"\",R$6+CalcPlan(R$5,$F27,P$7)-GetUsageCredits($F27, P$15, R$15)-IF(R$16=\"\",0,R$16))","v":240.28199999999998},134.31500800000001,374.59700799999996,null,11.952680536056157,null,null,null,{"$f":"IF(OR(Y$6=\"\",X$7=\"\",Z$7=\"\"),\"\",Z$6+CalcPlan(Z$5,$F27,X$7)-GetUsageCredits($F27, X$15, Z$15)-IF(Z$16=\"\",0,Z$16))","v":262.154},134.31500800000001,396.46900800000003,null,12.650574601148692,null,null,null,{"$f":"IF(OR(AG$6=\"\",AF$7=\"\",AH$7=\"\"),\"\",AH$6+CalcPlan(AH$5,$F27,AF$7)-GetUsageCredits($F27, AF$15, AH$15)-IF(AH$16=\"\",0,AH$16))","v":275.42399999999998},134.31500800000001,409.73900800000001,null,13.073995149968093,null,null,null,{"$f":"IF(OR(AO$6=\"\",AN$7=\"\",AP$7=\"\"),\"\",AP$6+CalcPlan(AP$5,$F27,AN$7)-GetUsageCredits($F27, AN$15, AP$15)-IF(AP$16=\"\",0,AP$16))","v":317.14},134.31500800000001,451.45500800000002,null,14.405073643905553,null,null,null,{"$f":"IF(OR(AW$6=\"\",AV$7=\"\",AX$7=\"\"),\"\",AX$6+CalcPlan(AX$5,$F27,AV$7)-GetUsageCredits($F27, AV$15, AX$15)-IF(AX$16=\"\",0,AX$16))","v":253.85400000000004},126.79027400000001,380.64427400000005,null,12.145637332482453,null,null,null,{"$f":"IF(OR(BE$6=\"\",BD$7=\"\",BF$7=\"\"),\"\",BF$6+CalcPlan(BF$5,$F27,BD$7)-GetUsageCredits($F27, BD$15, BF$15)-IF(BF$16=\"\",0,BF$16))","v":320.30199999999996},134.31500800000001,454.61700799999994,null,14.50596707083599,null,null,null,{"$f":"IF(OR(BM$6=\"\",BL$7=\"\",BN$7=\"\"),\"\",BN$6+CalcPlan(BN$5,$F27,BL$7)-GetUsageCredits($F27, BL$15, BN$15)-IF(BN$16=\"\",0,BN$16))","v":238.71799999999996},134.31500800000001,373.033008,null,11.902776260370134]
[null,null,null,3,null,{"$f":"data!K216","v":3152},null,{"$f":"IF(OR(I$6=\"\",H$7=\"\",J$7=\"\"),\"\",J$6+CalcPlan(J$5,$F28,H$7)-GetUsageCredits($F28, H$15, J$15)-IF(J$16=\"\",0,J$16))","v":264.06199999999995},135.055024,399.11702399999996,null,12.662342131979695,null,null,null,{"$f":"IF(OR(Q$6=\"\",P$7=\"\",R$7=\"\"),\"\",R$6+CalcPlan(R$5,$F28,P$7)-GetUsageCredits($F28, P$15, R$15)-IF(R$16=\"\",0,R$16))","v":242.04599999999999},135.055024,377.101024,null,11.963864974619289,null,null,null,{"$f":"IF(OR(Y$6=\"\",X$7=\"\",Z$7=\"\"),\"\",Z$6+CalcPlan(Z$5,$F28,X$7)-GetUsageCredits($F28, X$15, Z$15)-IF(Z$16=\"\",0,Z$16))","v":264.06199999999995},135.055024,399.11702399999996,null,12.662342131979695,null,null,null,{"$f":"IF(OR(AG$6=\"\",AF$7=\"\",AH$7=\"\"),\"\",AH$6+CalcPlan(AH$5,$F28,AF$7)-GetUsageCredits($F28, AF$15, AH$15)-IF(AH$16=\"\",0,AH$16))","v":277.42199999999997},135.055024,412.47702399999997,null,13.086199999999998,null,null,null,{"$f":"IF(OR(AO$6=\"\",AN$7=\"\",AP$7=\"\"),\"\",AP$6+CalcPlan(AP$5,$F28,AN$7)-GetUsageCredits($F28, AN$15, AP$15)-IF(AP$16=\"\",0,AP$16))","v":320.02},135.055024,455.07502399999998,null,14.437659390862944,null,null,null,{"$f":"IF(OR(AW$6=\"\",AV$7=\"\",AX$7=\"\"),\"\",AX$6+CalcPlan(AX$5,$F28,AV$7)-GetUsageCredits($F28, AV$15, AX$15)-IF(AX$16=\"\",0,AX$16))","v":255.31200000000001},127.48707200000001,382.79907200000002,null,12.144640609137056,null,null,null,{"$f":"IF(OR(BE$6=\"\",BD$7=\"\",BF$7=\"\"),\"\",BF$6+CalcPlan(BF$5,$F28,BD$7)-GetUsageCredits($F28, BD$15, BF$15)-IF(BF$16=\"\",0,BF$16))","v":322.60599999999999},135.055024,457.661024,null,14.519702538071066,null,null,null,{"$f":"IF(OR(BM$6=\"\",BL$7=\"\",BN$7=\"\"),\"\",BN$6+CalcPlan(BN$5,$F28,BL$7)-GetUsageCredits($F28, BL$15, BN$15)-IF(BN$16=\"\",0,BN$16))","v":240.55399999999997},135.055024,375.60902399999998,null,11.916529949238578]
[null,null,null,4,null,{"$f":"data!K217","v":2594},null,{"$f":"IF(OR(I$6=\"\",H$7=\"\",J$7=\"\"),\"\",J$6+CalcPlan(J$5,$F29,H$7)-GetUsageCredits($F29, H$15, J$15)-IF(J$16=\"\",0,J$16))","v":204.91399999999999},112.11452800000001,317.02852799999999,null,12.221608635312259,null,null,null,{"$f":"IF(OR(Q$6=\"\",P$7=\"\",R$7=\"\"),\"\",R$6+CalcPlan(R$5,$F29,P$7)-GetUsageCredits($F29, P$15, R$15)-IF(R$16=\"\",0,R$16))","v":187.36200000000002},112.11452800000001,299.47652800000003,null,11.544970239013107,null,null,null,{"$f":"IF(OR(Y$6=\"\",X$7=\"\",Z$7=\"\"),\"\",Z$6+CalcPlan(Z$5,$F29,X$7)-GetUsageCredits($F29, X$15, Z$15)-IF(Z$16=\"\",0,Z$16))","v":204.91399999999999},112.11452800000001,317.02852799999999,null,12.221608635312259,null,null,null,{"$f":"IF(OR(AG$6=\"\",AF$7=\"\",AH$7=\"\"),\"\",AH$6+CalcPlan(AH$5,$F29,AF$7)-GetUsageCredits($F29, AF$15, AH$15)-IF(AH$16=\"\",0,AH$16))","v":215.48399999999998},112.11452800000001,327.59852799999999,null,12.629087432536624,null,null,null,{"$f":"IF(OR(AO$6=\"\",AN$7=\"\",AP$7=\"\"),\"\",AP$6+CalcPlan(AP$5,$F29,AN$7)-GetUsageCredits($F29, AN$15, AP$15)-IF(AP$16=\"\",0,AP$16))","v":230.74},112.11452800000001,342.85452800000002,null,13.217213878180416,null,null,null,{"$f":"IF(OR(AW$6=\"\",AV$7=\"\",AX$7=\"\"),\"\",AX$6+CalcPlan(AX$5,$F29,AV$7)-GetUsageCredits($F29, AV$15, AX$15)-IF(AX$16=\"\",0,AX$16))","v":210.114},105.88633400000001,316.00033400000001,null,12.181971241326139,null,null,null,{"$f":"IF(OR(BE$6=\"\",BD$7=\"\",BF$7=\"\"),\"\",BF$6+CalcPlan(BF$5,$F29,BD$7)-GetUsageCredits($F29, BD$15, BF$15)-IF(BF$16=\"\",0,BF$16))","v":251.18199999999996},112.11452800000001,363.29652799999997,null,14.005263222821895,null,null,null,{"$f":"IF(OR(BM$6=\"\",BL$7=\"\",BN$7=\"\"),\"\",BN$6+CalcPlan(BN$5,$F29,BL$7)-GetUsageCredits($F29, BL$15, BN$15)-IF(BN$16=\"\",0,BN$16))","v":183.63799999999998},112.11452800000001,295.75252799999998,null,11.401408172706244]
[null,null,null,5,null,{"$f":"data!K218","v":1922},null,{"$f":"IF(OR(I$6=\"\",H$7=\"\",J$7=\"\"),\"\",J$6+CalcPlan(J$5,$F30,H$7)-GetUsageCredits($F30, H$15, J$15)-IF(J$16=\"\",0,J$16))","v":137.97199999999998},84.48726400000001,222.45926399999999,null,11.574363371488033,null,null,null,{"$f":"IF(OR(Q$6=\"\",P$7=\"\",R$7=\"\"),\"\",R$6+CalcPlan(R$5,$F30,P$7)-GetUsageCredits($F30, P$15, R$15)-IF(R$16=\"\",0,R$16))","v":125.48400000000001},84.48726400000001,209.97126400000002,null,10.924623517169616,null,null,null,{"$f":"IF(OR(Y$6=\"\",X$7=\"\",Z$7=\"\"),\"\",Z$6+CalcPlan(Z$5,$F30,X$7)-GetUsageCredits($F30, X$15, Z$15)-IF(Z$16=\"\",0,Z$16))","v":137.97199999999998},84.48726400000001,222.45926399999999,null,11.574363371488033,null,null,null,{"$f":"IF(OR(AG$6=\"\",AF$7=\"\",AH$7=\"\"),\"\",AH$6+CalcPlan(AH$5,$F30,AF$7)-GetUsageCredits($F30, AF$15, AH$15)-IF(AH$16=\"\",0,AH$16))","v":145.416},84.48726400000001,229.90326400000001,null,11.961668262226848,null,null,null,{"$f":"IF(OR(AO$6=\"\",AN$7=\"\",AP$7=\"\"),\"\",AP$6+CalcPlan(AP$5,$F30,AN$7)-GetUsageCredits($F30, AN$15, AP$15)-IF(AP$16=\"\",0,AP$16))","v":134.21799999999999},84.48726400000001,218.705264,null,11.379045993756504,null,null,null,{"$f":"IF(OR(AW$6=\"\",AV$7=\"\",AX$7=\"\"),\"\",AX$6+CalcPlan(AX$5,$F30,AV$7)-GetUsageCredits($F30, AV$15, AX$15)-IF(AX$16=\"\",0,AX$16))","v":155.68200000000002},79.87254200000001,235.55454200000003,null,12.255699375650366,null,null,null,{"$f":"IF(OR(BE$6=\"\",BD$7=\"\",BF$7=\"\"),\"\",BF$6+CalcPlan(BF$5,$F30,BD$7)-GetUsageCredits($F30, BD$15, BF$15)-IF(BF$16=\"\",0,BF$16))","v":170.392},84.48726400000001,254.87926400000001,null,13.261147970863686,null,null,null,{"$f":"IF(OR(BM$6=\"\",BL$7=\"\",BN$7=\"\"),\"\",BN$6+CalcPlan(BN$5,$F30,BL$7)-GetUsageCredits($F30, BL$15, BN$15)-IF(BN$16=\"\",0,BN$16))","v":119.22799999999998},84.48726400000001,203.71526399999999,null,10.599129240374609]
[null,null,null,6,null,{"$f":"data!K219","v":1470},null,{"$f":"IF(OR(I$6=\"\",H$7=\"\",J$7=\"\"),\"\",J$6+CalcPlan(J$5,$F31,H$7)-GetUsageCredits($F31, H$15, J$15)-IF(J$16=\"\",0,J$16))","v":114.91999999999999},65.904640000000001,180.82463999999999,null,12.300995918367347,null,null,null,{"$f":"IF(OR(Q$6=\"\",P$7=\"\",R$7=\"\"),\"\",R$6+CalcPlan(R$5,$F31,P$7)-GetUsageCredits($F31, P$15, R$15)-IF(R$16=\"\",0,R$16))","v":104.24000000000001},65.904640000000001,170.14464000000001,null,11.57446530612245,null,null,null,{"$f":"IF(OR(Y$6=\"\",X$7=\"\",Z$7=\"\"),\"\",Z$6+CalcPlan(Z$5,$F31,X$7)-GetUsageCredits($F31, X$15, Z$15)-IF(Z$16=\"\",0,Z$16))","v":114.91999999999999},65.904640000000001,180.82463999999999,null,12.300995918367347,null,null,null,{"$f":"IF(OR(AG$6=\"\",AF$7=\"\",AH$7=\"\"),\"\",AH$6+CalcPlan(AH$5,$F31,AF$7)-GetUsageCredits($F31, AF$15, AH$15)-IF(AH$16=\"\",0,AH$16))","v":121.45999999999998},65.904640000000001,187.36463999999998,null,12.745893877551017,null,null,null,{"$f":"IF(OR(AO$6=\"\",AN$7=\"\",AP$7=\"\"),\"\",AP$6+CalcPlan(AP$5,$F31,AN$7)-GetUsageCredits($F31, AN$15, AP$15)-IF(AP$16=\"\",0,AP$16))","v":125.63000000000001},65.904640000000001,191.53464000000002,null,13.029567346938778,null,null,null,{"$f":"IF(OR(AW$6=\"\",AV$7=\"\",AX$7=\"\"),\"\",AX$6+CalcPlan(AX$5,$F31,AV$7)-GetUsageCredits($F31, AV$15, AX$15)-IF(AX$16=\"\",0,AX$16))","v":119.07000000000001},62.375170000000004,181.44517000000002,null,12.343208843537417,null,null,null,{"$f":"IF(OR(BE$6=\"\",BD$7=\"\",BF$7=\"\"),\"\",BF$6+CalcPlan(BF$5,$F31,BD$7)-GetUsageCredits($F31, BD$15, BF$15)-IF(BF$16=\"\",0,BF$16))","v":142.82},65.904640000000001,208.72463999999999,null,14.198955102040816,null,null,null,{"$f":"IF(OR(BM$6=\"\",BL$7=\"\",BN$7=\"\"),\"\",BN$6+CalcPlan(BN$5,$F31,BL$7)-GetUsageCredits($F31, BL$15, BN$15)-IF(BN$16=\"\",0,BN$16))","v":97.079999999999984},65.904640000000001,162.98463999999998,null,11.087390476190476]
[null,null,null,7,null,{"$f":"data!K220","v":1407},null,{"$f":"IF(OR(I$6=\"\",H$7=\"\",J$7=\"\"),\"\",J$6+CalcPlan(J$5,$F32,H$7)-GetUsageCredits($F32, H$15, J$15)-IF(J$16=\"\",0,J$16))","v":111.70699999999997},63.314584000000004,175.02158399999996,null,12.439344989339016,null,null,null,{"$f":"IF(OR(Q$6=\"\",P$7=\"\",R$7=\"\"),\"\",R$6+CalcPlan(R$5,$F32,P$7)-GetUsageCredits($F32, P$15, R$15)-IF(R$16=\"\",0,R$16))","v":101.27900000000002},63.314584000000004,164.59358400000002,null,11.698193603411514,null,null,null,{"$f":"IF(OR(Y$6=\"\",X$7=\"\",Z$7=\"\"),\"\",Z$6+CalcPlan(Z$5,$F32,X$7)-GetUsageCredits($F32, X$15, Z$15)-IF(Z$16=\"\",0,Z$16))","v":111.70699999999997},63.314584000000004,175.02158399999996,null,12.439344989339016,null,null,null,{"$f":"IF(OR(AG$6=\"\",AF$7=\"\",AH$7=\"\"),\"\",AH$6+CalcPlan(AH$5,$F32,AF$7)-GetUsageCredits($F32, AF$15, AH$15)-IF(AH$16=\"\",0,AH$16))","v":118.12099999999998},63.314584000000004,181.43558399999998,null,12.895208528784647,null,null,null,{"$f":"IF(OR(AO$6=\"\",AN$7=\"\",AP$7=\"\"),\"\",AP$6+CalcPlan(AP$5,$F32,AN$7)-GetUsageCredits($F32, AN$15, AP$15)-IF(AP$16=\"\",0,AP$16))","v":124.43300000000001},63.314584000000004,187.74758400000002,null,13.343822601279317,null,null,null,{"$f":"IF(OR(AW$6=\"\",AV$7=\"\",AX$7=\"\"),\"\",AX$6+CalcPlan(AX$5,$F32,AV$7)-GetUsageCredits($F32, AV$15, AX$15)-IF(AX$16=\"\",0,AX$16))","v":113.967},59.936377,173.90337700000001,null,12.359870433546554,null,null,null,{"$f":"IF(OR(BE$6=\"\",BD$7=\"\",BF$7=\"\"),\"\",BF$6+CalcPlan(BF$5,$F32,BD$7)-GetUsageCredits($F32, BD$15, BF$15)-IF(BF$16=\"\",0,BF$16))","v":138.977},63.314584000000004,202.291584,null,14.377511300639659,null,null,null,{"$f":"IF(OR(BM$6=\"\",BL$7=\"\",BN$7=\"\"),\"\",BN$6+CalcPlan(BN$5,$F32,BL$7)-GetUsageCredits($F32, BL$15, BN$15)-IF(BN$16=\"\",0,BN$16))","v":93.992999999999995},63.314584000000004,157.30758399999999,null,11.180354228855721]
[null,null,null,8,null,{"$f":"data!K221","v":1203},null,{"$f":"IF(OR(I$6=\"\",H$7=\"\",J$7=\"\"),\"\",J$6+CalcPlan(J$5,$F33,H$7)-GetUsageCredits($F33, H$15, J$15)-IF(J$16=\"\",0,J$16))","v":101.303},54.927736000000003,156.23073600000001,null,12.986761097256858,null,null,null,{"$f":"IF(OR(Q$6=\"\",P$7=\"\",R$7=\"\"),\"\",R$6+CalcPlan(R$5,$F33,P$7)-GetUsageCredits($F33, P$15, R$15)-IF(R$16=\"\",0,R$16))","v":91.691000000000031},54.927736000000003,146.61873600000004,null,12.187758603491275,null,null,null,{"$f":"IF(OR(Y$6=\"\",X$7=\"\",Z$7=\"\"),\"\",Z$6+CalcPlan(Z$5,$F33,X$7)-GetUsageCredits($F33, X$15, Z$15)-IF(Z$16=\"\",0,Z$16))","v":101.303},54.927736000000003,156.23073600000001,null,12.986761097256858,null,null,null,{"$f":"IF(OR(AG$6=\"\",AF$7=\"\",AH$7=\"\"),\"\",AH$6+CalcPlan(AH$5,$F33,AF$7)-GetUsageCredits($F33, AF$15, AH$15)-IF(AH$16=\"\",0,AH$16))","v":107.309},54.927736000000003,162.23673600000001,null,13.486012967581049,null,null,null,{"$f":"IF(OR(AO$6=\"\",AN$7=\"\",AP$7=\"\"),\"\",AP$6+CalcPlan(AP$5,$F33,AN$7)-GetUsageCredits($F33, AN$15, AP$15)-IF(AP$16=\"\",0,AP$16))","v":111.00200000000001},54.927736000000003,165.92973600000002,null,13.792995511221948,null,null,null,{"$f":"IF(OR(AW$6=\"\",AV$7=\"\",AX$7=\"\"),\"\",AX$6+CalcPlan(AX$5,$F33,AV$7)-GetUsageCredits($F33, AV$15, AX$15)-IF(AX$16=\"\",0,AX$16))","v":97.442999999999998},52.039332999999999,149.48233299999998,null,12.425796591853699,null,null,null,{"$f":"IF(OR(BE$6=\"\",BD$7=\"\",BF$7=\"\"),\"\",BF$6+CalcPlan(BF$5,$F33,BD$7)-GetUsageCredits($F33, BD$15, BF$15)-IF(BF$16=\"\",0,BF$16))","v":126.53299999999999},54.927736000000003,181.460736,null,15.08401795511222,null,null,null,{"$f":"IF(OR(BM$6=\"\",BL$7=\"\",BN$7=\"\"),\"\",BN$6+CalcPlan(BN$5,$F33,BL$7)-GetUsageCredits($F33, BL$15, BN$15)-IF(BN$16=\"\",0,BN$16))","v":83.997},54.927736000000003,138.924736,null,11.548190856192852]
[null,null,null,9,null,{"$f":"data!K222","v":1479},null,{"$f":"IF(OR(I$6=\"\",H$7=\"\",J$7=\"\"),\"\",J$6+CalcPlan(J$5,$F34,H$7)-GetUsageCredits($F34, H$15, J$15)-IF(J$16=\"\",0,J$16))","v":115.37899999999996},66.274648000000013,181.65364799999998,null,12.2821939148073,null,null,null,{"$f":"IF(OR(Q$6=\"\",P$7=\"\",R$7=\"\"),\"\",R$6+CalcPlan(R$5,$F34,P$7)-GetUsageCredits($F34, P$15, R$15)-IF(R$16=\"\",0,R$16))","v":104.66300000000001},66.274648000000013,170.93764800000002,null,11.557650304259637,null,null,null,{"$f":"IF(OR(Y$6=\"\",X$7=\"\",Z$7=\"\"),\"\",Z$6+CalcPlan(Z$5,$F34,X$7)-GetUsageCredits($F34, X$15, Z$15)-IF(Z$16=\"\",0,Z$16))","v":115.37899999999996},66.274648000000013,181.65364799999998,null,12.2821939148073,null,null,null,{"$f":"IF(OR(AG$6=\"\",AF$7=\"\",AH$7=\"\"),\"\",AH$6+CalcPlan(AH$5,$F34,AF$7)-GetUsageCredits($F34, AF$15, AH$15)-IF(AH$16=\"\",0,AH$16))","v":121.93699999999998},66.274648000000013,188.211648,null,12.725601622718052,null,null,null,{"$f":"IF(OR(AO$6=\"\",AN$7=\"\",AP$7=\"\"),\"\",AP$6+CalcPlan(AP$5,$F34,AN$7)-GetUsageCredits($F34, AN$15, AP$15)-IF(AP$16=\"\",0,AP$16))","v":125.801},66.274648000000013,192.075648,null,12.986859229208925,null,null,null,{"$f":"IF(OR(AW$6=\"\",AV$7=\"\",AX$7=\"\"),\"\",AX$6+CalcPlan(AX$5,$F34,AV$7)-GetUsageCredits($F34, AV$15, AX$15)-IF(AX$16=\"\",0,AX$16))","v":119.79899999999999},62.723569000000005,182.522569,null,12.340944489519947,null,null,null,{"$f":"IF(OR(BE$6=\"\",BD$7=\"\",BF$7=\"\"),\"\",BF$6+CalcPlan(BF$5,$F34,BD$7)-GetUsageCredits($F34, BD$15, BF$15)-IF(BF$16=\"\",0,BF$16))","v":143.369},66.274648000000013,209.64364800000001,null,14.174688843813389,null,null,null,{"$f":"IF(OR(BM$6=\"\",BL$7=\"\",BN$7=\"\"),\"\",BN$6+CalcPlan(BN$5,$F34,BL$7)-GetUsageCredits($F34, BL$15, BN$15)-IF(BN$16=\"\",0,BN$16))","v":97.520999999999987},66.274648000000013,163.795648,null,11.074756457065584]
[null,null,null,10,null,{"$f":"data!K223","v":1648},null,{"$f":"IF(OR(I$6=\"\",H$7=\"\",J$7=\"\"),\"\",J$6+CalcPlan(J$5,$F35,H$7)-GetUsageCredits($F35, H$15, J$15)-IF(J$16=\"\",0,J$16))","v":123.99799999999999},73.222576000000004,197.22057599999999,null,11.967267961165048,null,null,null,{"$f":"IF(OR(Q$6=\"\",P$7=\"\",R$7=\"\"),\"\",R$6+CalcPlan(R$5,$F35,P$7)-GetUsageCredits($F35, P$15, R$15)-IF(R$16=\"\",0,R$16))","v":112.60600000000002},73.222576000000004,185.82857600000003,null,11.27600582524272,null,null,null,{"$f":"IF(OR(Y$6=\"\",X$7=\"\",Z$7=\"\"),\"\",Z$6+CalcPlan(Z$5,$F35,X$7)-GetUsageCredits($F35, X$15, Z$15)-IF(Z$16=\"\",0,Z$16))","v":123.99799999999999},73.222576000000004,197.22057599999999,null,11.967267961165048,null,null,null,{"$f":"IF(OR(AG$6=\"\",AF$7=\"\",AH$7=\"\"),\"\",AH$6+CalcPlan(AH$5,$F35,AF$7)-GetUsageCredits($F35, AF$15, AH$15)-IF(AH$16=\"\",0,AH$16))","v":130.89400000000001},73.222576000000004,204.11657600000001,null,12.385714563106797,null,null,null,{"$f":"IF(OR(AO$6=\"\",AN$7=\"\",AP$7=\"\"),\"\",AP$6+CalcPlan(AP$5,$F35,AN$7)-GetUsageCredits($F35, AN$15, AP$15)-IF(AP$16=\"\",0,AP$16))","v":129.012},73.222576000000004,202.234576,null,12.271515533980583,null,null,null,{"$f":"IF(OR(AW$6=\"\",AV$7=\"\",AX$7=\"\"),\"\",AX$6+CalcPlan(AX$5,$F35,AV$7)-GetUsageCredits($F35, AV$15, AX$15)-IF(AX$16=\"\",0,AX$16))","v":133.488},69.26572800000001,202.75372800000002,null,12.303017475728156,null,null,null,{"$f":"IF(OR(BE$6=\"\",BD$7=\"\",BF$7=\"\"),\"\",BF$6+CalcPlan(BF$5,$F35,BD$7)-GetUsageCredits($F35, BD$15, BF$15)-IF(BF$16=\"\",0,BF$16))","v":153.678},73.222576000000004,226.900576,null,13.768238834951458,null,null,null,{"$f":"IF(OR(BM$6=\"\",BL$7=\"\",BN$7=\"\"),\"\",BN$6+CalcPlan(BN$5,$F35,BL$7)-GetUsageCredits($F35, BL$15, BN$15)-IF(BN$16=\"\",0,BN$16))","v":105.80199999999999},73.222576000000004,179.024576,null,10.863141747572817]
[null,null,null,11,null,{"$f":"data!K224","v":2170},null,{"$f":"IF(OR(I$6=\"\",H$7=\"\",J$7=\"\"),\"\",J$6+CalcPlan(J$5,$F36,H$7)-GetUsageCredits($F36, H$15, J$15)-IF(J$16=\"\",0,J$16))","v":159.97},94.683040000000005,254.65304,null,11.735163133640553,null,null,null,{"$f":"IF(OR(Q$6=\"\",P$7=\"\",R$7=\"\"),\"\",R$6+CalcPlan(R$5,$F36,P$7)-GetUsageCredits($F36, P$15, R$15)-IF(R$16=\"\",0,R$16))","v":145.81},94.683040000000005,240.49304000000001,null,11.082628571428572,null,null,null,{"$f":"IF(OR(Y$6=\"\",X$7=\"\",Z$7=\"\"),\"\",Z$6+CalcPlan(Z$5,$F36,X$7)-GetUsageCredits($F36, X$15, Z$15)-IF(Z$16=\"\",0,Z$16))","v":159.97},94.683040000000005,254.65304,null,11.735163133640553,null,null,null,{"$f":"IF(OR(AG$6=\"\",AF$7=\"\",AH$7=\"\"),\"\",AH$6+CalcPlan(AH$5,$F36,AF$7)-GetUsageCredits($F36, AF$15, AH$15)-IF(AH$16=\"\",0,AH$16))","v":168.42},94.683040000000005,263.10303999999996,null,12.124564055299537,null,null,null,{"$f":"IF(OR(AO$6=\"\",AN$7=\"\",AP$7=\"\"),\"\",AP$6+CalcPlan(AP$5,$F36,AN$7)-GetUsageCredits($F36, AN$15, AP$15)-IF(AP$16=\"\",0,AP$16))","v":162.89999999999998},94.683040000000005,257.58303999999998,null,11.870186175115206,null,null,null,{"$f":"IF(OR(AW$6=\"\",AV$7=\"\",AX$7=\"\"),\"\",AX$6+CalcPlan(AX$5,$F36,AV$7)-GetUsageCredits($F36, AV$15, AX$15)-IF(AX$16=\"\",0,AX$16))","v":175.77},89.47287,265.24287000000004,null,12.223173732718896,null,null,null,{"$f":"IF(OR(BE$6=\"\",BD$7=\"\",BF$7=\"\"),\"\",BF$6+CalcPlan(BF$5,$F36,BD$7)-GetUsageCredits($F36, BD$15, BF$15)-IF(BF$16=\"\",0,BF$16))","v":196.90999999999997},94.683040000000005,291.59303999999997,null,13.437467281105988,null,null,null,{"$f":"IF(OR(BM$6=\"\",BL$7=\"\",BN$7=\"\"),\"\",BN$6+CalcPlan(BN$5,$F36,BL$7)-GetUsageCredits($F36, BL$15, BN$15)-IF(BN$16=\"\",0,BN$16))","v":140.38999999999999},94.683040000000005,235.07303999999999,null,10.832858986175115]
[null,null,null,12,null,{"$f":"data!K225","v":3085},null,{"$f":"IF(OR(I$6=\"\",H$7=\"\",J$7=\"\"),\"\",J$6+CalcPlan(J$5,$F37,H$7)-GetUsageCredits($F37, H$15, J$15)-IF(J$16=\"\",0,J$16))","v":256.95999999999998},132.30052000000001,389.26051999999999,null,12.617845056726093,null,null,null,{"$f":"IF(OR(Q$6=\"\",P$7=\"\",R$7=\"\"),\"\",R$6+CalcPlan(R$5,$F37,P$7)-GetUsageCredits($F37, P$15, R$15)-IF(R$16=\"\",0,R$16))","v":235.48000000000002},132.30052000000001,367.78052000000002,null,11.92157277147488,null,null,null,{"$f":"IF(OR(Y$6=\"\",X$7=\"\",Z$7=\"\"),\"\",Z$6+CalcPlan(Z$5,$F37,X$7)-GetUsageCredits($F37, X$15, Z$15)-IF(Z$16=\"\",0,Z$16))","v":256.95999999999998},132.30052000000001,389.26051999999999,null,12.617845056726093,null,null,null,{"$f":"IF(OR(AG$6=\"\",AF$7=\"\",AH$7=\"\"),\"\",AH$6+CalcPlan(AH$5,$F37,AF$7)-GetUsageCredits($F37, AF$15, AH$15)-IF(AH$16=\"\",0,AH$16))","v":269.98499999999996},132.30052000000001,402.28551999999996,null,13.040049270664506,null,null,null,{"$f":"IF(OR(AO$6=\"\",AN$7=\"\",AP$7=\"\"),\"\",AP$6+CalcPlan(AP$5,$F37,AN$7)-GetUsageCredits($F37, AN$15, AP$15)-IF(AP$16=\"\",0,AP$16))","v":309.3},132.30052000000001,441.60052000000002,null,14.314441491085899,null,null,null,{"$f":"IF(OR(AW$6=\"\",AV$7=\"\",AX$7=\"\"),\"\",AX$6+CalcPlan(AX$5,$F37,AV$7)-GetUsageCredits($F37, AV$15, AX$15)-IF(AX$16=\"\",0,AX$16))","v":249.88500000000005},124.89343500000001,374.77843500000006,null,12.148409562398706,null,null,null,{"$f":"IF(OR(BE$6=\"\",BD$7=\"\",BF$7=\"\"),\"\",BF$6+CalcPlan(BF$5,$F37,BD$7)-GetUsageCredits($F37, BD$15, BF$15)-IF(BF$16=\"\",0,BF$16))","v":314.02999999999997},132.30052000000001,446.33051999999998,null,14.467764019448945,null,null,null,{"$f":"IF(OR(BM$6=\"\",BL$7=\"\",BN$7=\"\"),\"\",BN$6+CalcPlan(BN$5,$F37,BL$7)-GetUsageCredits($F37, BL$15, BN$15)-IF(BN$16=\"\",0,BN$16))","v":233.71999999999997},132.30052000000001,366.02051999999998,null,11.864522528363047]
[]
[null,null,null,"Avg",null,{"$f":"AVERAGE(F26:F37)","v":2187.4166666666665}]
[null,null,null,"Total",null,{"$f":"SUM(F26:F37)","v":26249},null,null,null,{"$f":"IF(J26=\"\",\"\",SUM(J26:J37))","v":3244.4878880000001},null,{"$f":"IF(L26=\"\",\"\",AVERAGE(L26:L37))","v":12.33218139367739},{"$f":"IF(J40=\"\",\"\",J40/$F$40*100)","v":12.360424732370758},null,null,null,null,{"$f":"IF(R26=\"\",\"\",SUM(R26:R37))","v":3061.4118879999996},null,{"$f":"IF(T26=\"\",\"\",AVERAGE(T26:T37))","v":11.628277737104504},{"$f":"IF(R40=\"\",\"\",R40/$F$40*100)","v":11.662965781553583},null,null,null,null,{"$f":"IF(Z26=\"\",\"\",SUM(Z26:Z37))","v":3244.4878880000001},null,{"$f":"IF(AB26=\"\",\"\",AVERAGE(AB26:AB37))","v":12.33218139367739},{"$f":"IF(Z40=\"\",\"\",Z40/$F$40*100)","v":12.360424732370758},null,null,null,null,{"$f":"IF(AH26=\"\",\"\",SUM(AH26:AH37))","v":3355.5458879999996},null,{"$f":"IF(AJ26=\"\",\"\",AVERAGE(AJ26:AJ37))","v":12.760109136107062},{"$f":"IF(AH40=\"\",\"\",AH40/$F$40*100)","v":12.783518945483635},null,null,null,null,{"$f":"IF(AP26=\"\",\"\",SUM(AP26:AP37))","v":3528.2848880000001},null,{"$f":"IF(AR26=\"\",\"\",AVERAGE(AR26:AR37))","v":13.264052168472226},{"$f":"IF(AP40=\"\",\"\",AP40/$F$40*100)","v":13.441597348470419},null,null,null,null,{"$f":"IF(AX26=\"\",\"\",SUM(AX26:AX37))","v":3207.9340390000007},null,{"$f":"IF(AZ26=\"\",\"\",AVERAGE(AZ26:AZ37))","v":12.252226605761578},{"$f":"IF(AX40=\"\",\"\",AX40/$F$40*100)","v":12.221166669206449},null,null,null,null,{"$f":"IF(BF26=\"\",\"\",SUM(BF26:BF37))","v":3726.817888},null,{"$f":"IF(BH26=\"\",\"\",AVERAGE(BH26:BH37))","v":14.182219250614734},{"$f":"IF(BF40=\"\",\"\",BF40/$F$40*100)","v":14.197942352089605},null,null,null,null,{"$f":"IF(BN26=\"\",\"\",SUM(BN26:BN37))","v":3002.9498879999992},null,{"$f":"IF(BP26=\"\",\"\",AVERAGE(BP26:BP37))","v":11.337801307252064},{"$f":"IF(BN40=\"\",\"\",BN40/$F$40*100)","v":11.440244915996796}]
[]
[]
[]
[null,"*","The TDU Company is fixed based on your address"]
[]
[]
[]
[null,"Manual Checks"]
[]
[null,null,null,null,null,null,null,1000,{"$f":"H50*J7","v":100.99999999999999},"plan",null,null,null,null,null,1000,{"$f":"P50*R7","v":93.000000000000014},"plan",null,null,null,null,null,1000,{"$f":"X50*Z7","v":100.99999999999999},"plan",null,null,null,null,null,1000,{"$f":"AF50*AH7","v":106},"plan"]
[null,null,null,null,null,null,null,null,{"$f":"H50*J13","v":41.112000000000002},"tdu",null,null,null,null,null,null,{"$f":"P50*R13","v":41.112000000000002},"tdu",null,null,null,null,null,null,{"$f":"X50*Z13","v":41.112000000000002},"tdu",null,null,null,null,null,null,{"$f":"AF50*AH13","v":41.112000000000002},"tdu"]
[null,null,null,null,null,null,null,null,{"$f":"J6+J12","v":15.419999999999998},"base",null,null,null,null,null,null,{"$f":"R6+R12","v":15.419999999999998},"base",null,null,null,null,null,null,{"$f":"Z6+Z12","v":15.419999999999998},"base",null,null,null,null,null,null,{"$f":"AH6+AH12","v":15.419999999999998},"base"]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I50:I52)","v":157.53199999999998},{"$f":"I53/H50","v":0.15753199999999998},null,{"$f":"J53*100","v":15.753199999999998},null,null,null,null,{"$f":"SUM(Q50:Q52)","v":149.53200000000001},{"$f":"Q53/P50","v":0.149532},null,{"$f":"R53*100","v":14.953199999999999},null,null,null,null,{"$f":"SUM(Y50:Y52)","v":157.53199999999998},{"$f":"Y53/X50","v":0.15753199999999998},null,{"$f":"Z53*100","v":15.753199999999998},null,null,null,null,{"$f":"SUM(AG50:AG52)","v":162.53199999999998},{"$f":"AG53/AF50","v":0.16253199999999998},null,{"$f":"AH53*100","v":16.2532}]
[]
[]
[null,null,null,null,null,null,null,500,{"$f":"H56*J7","v":50.499999999999993},"plan",null,null,null,null,null,500,{"$f":"P56*R7","v":46.500000000000007},"plan",null,null,null,null,null,500,{"$f":"X56*Z7","v":50.499999999999993},"plan",null,null,null,null,null,500,{"$f":"AF56*AH7","v":53},"plan"]
[null,null,null,null,null,null,null,null,{"$f":"H56*J13","v":20.556000000000001},"tdu",null,null,null,null,null,null,{"$f":"P56*R13","v":20.556000000000001},"tdu",null,null,null,null,null,null,{"$f":"X56*Z13","v":20.556000000000001},"tdu",null,null,null,null,null,null,{"$f":"AF56*AH13","v":20.556000000000001},"tdu"]
[null,null,null,null,null,null,null,null,{"$f":"J12+J6","v":15.419999999999998},"base",null,null,null,null,null,null,{"$f":"R12+R6","v":15.419999999999998},"base",null,null,null,null,null,null,{"$f":"Z12+Z6","v":15.419999999999998},"base",null,null,null,null,null,null,{"$f":"AH12+AH6","v":15.419999999999998},"base"]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I56:I58)","v":86.475999999999999},{"$f":"I59/H56","v":0.17295199999999999},null,{"$f":"J59*100","v":17.295200000000001},null,null,null,null,{"$f":"SUM(Q56:Q58)","v":82.476000000000013},{"$f":"Q59/P56","v":0.16495200000000002},null,{"$f":"R59*100","v":16.495200000000001},null,null,null,null,{"$f":"SUM(Y56:Y58)","v":86.475999999999999},{"$f":"Y59/X56","v":0.17295199999999999},null,{"$f":"Z59*100","v":17.295200000000001},null,null,null,null,{"$f":"SUM(AG56:AG58)","v":88.975999999999999},{"$f":"AG59/AF56","v":0.177952},null,{"$f":"AH59*100","v":17.795200000000001}]
[]
[]
[]
[null,"It is important to understand two facts concerning the prices for the standard usage tiers of 500/1000/2000"]
[]
[null,null,"This is NOT a Bill estimate, this is purely the cost OF the electricity and does not include any other fees or  taxes!  The TXU EFL description of \"average price\" is inaccurate as this is in no way an average but a precisely calculated number based upon discrete plan details!"]
[]
[null,null,"With respect to a manual check on the spreadsheet's calculations, it is important to note that in most cases, and TXU specifically, the choice of manually checking the lower end tiers of 500/1000 is done purposely because they fit inside the first pricing tier which simplifies the math by removing any concerns of errors or differences in properly evaluating the portion of the cost for the upper tiers.  IF these lower tiers are inaccurate, we definitively know there is a problem!"]

{"sheet":"data","index":3,"n_rows":271,"n_cols":21,"rows_kept":271,"cut":false,"hidden":false,"merged":[]}
[null,null,"Period Ending","from","to","Billing Days","Dumbass Days","kWh Used","Curr Meter","Prev Meter","kWh Used","KWh Diff","Avg. High Temp","Avg. Daily Use","Plan Subtotal","TDU Subtotal","Total Charges","¢ per kWh, Plan","¢ per kWh, TDU",null,"Total ¢ per kWh"]
["Reliant",null,19991111,null,null,29,29,null,null,null,1054,null,null,{"$f":"K2/F2","v":36.344827586206897},null,null,84.56,null,null,null,{"$f":"(Q2/K2)*100","v":8.022770398481974}]
[null,null,19991214,null,null,33,33,null,null,null,1034,null,null,31.333333333333332,null,null,83.29,null,null,null,8.0551257253384918]
[null,null,20000113,null,null,30,30,null,null,null,814,null,null,27.133333333333333,null,null,68.08,null,null,null,8.3636363636363633]
[null,null,20000214,null,null,32,32,null,null,null,1024,null,null,32,null,null,81.11,null,null,null,7.9208984375]
[null,null,20000313,null,null,28,28,null,null,null,1143,null,null,40.821428571428569,null,null,88.51,null,null,null,7.7436570428696418]
[null,null,20000412,null,null,30,30,null,null,null,1219,null,null,40.633333333333333,null,null,93.22,null,null,null,7.6472518457752257]
[null,null,20000512,null,null,30,30,null,null,null,1975,null,null,65.833333333333329,null,null,175.99,null,null,null,8.9108860759493673]
[null,null,20000613,null,null,32,32,null,null,null,2803,null,null,87.59375,null,null,252.64,null,null,null,9.0132001427042443]
[null,null,20000713,null,null,30,30,null,null,null,3122,null,null,104.06666666666666,null,null,282.17,null,null,null,9.0381165919282509]
[null,null,20000811,null,null,29,29,null,null,null,3159,null,null,108.93103448275862,null,null,285.60000000000002,null,null,null,9.0408357075023744]
[null,null,20000911,null,null,31,31,null,null,null,3637,null,null,117.3225806451613,null,null,366.06,null,null,null,10.064888644487215]
[null,null,20001010,null,null,29,29,null,null,null,2283,null,null,78.724137931034477,null,null,227.24200009110001,null,null,null,9.9536574722339033]
[null,null,20001109,null,null,30,30,null,null,null,1677,null,null,55.9,null,null,138.33000000000001,null,null,null,8.2486583184257611]
[null,null,20001211,null,null,32,32,null,null,null,820,null,null,25.625,null,null,84.93,null,null,null,10.357317073170732]
[null,null,20010115,null,null,35,35,null,null,null,1061,null,null,30.314285714285713,null,null,104.75,null,null,null,9.8727615457115938]
[null,null,20010213,null,null,29,29,null,null,null,875,null,null,30.172413793103448,null,null,89.46,null,null,null,10.224]
[null,null,20010314,null,null,29,29,null,null,null,961,null,null,33.137931034482762,null,null,96.53,null,null,null,10.044745057232051]
[null,null,20010412,null,null,29,29,null,null,null,1279,null,null,44.103448275862071,null,null,122.66,null,null,null,9.5903049257232205]
[null,null,20010514,null,null,32,32,null,null,null,2070,null,null,64.6875,null,null,239.32,null,null,null,11.56135265700483]
[null,null,20010613,null,null,30,30,null,null,null,2601,null,null,86.7,null,null,302.45,null,null,null,11.628219915417146]
[null,null,20010713,null,null,30,30,null,null,null,3013,null,null,100.43333333333334,null,null,351.45,null,null,null,11.664454032525722]
[null,null,20010811,null,null,29,29,null,null,null,3047,null,null,105.06896551724138,null,null,336.49,null,null,null,11.04332129963899]
[null,null,20010912,null,null,32,32,null,null,null,2876,null,null,89.875,null,null,317.22000000000003,null,null,null,11.029902642559112]
[null,null,20011011,null,null,29,29,null,null,null,1908,null,null,65.793103448275858,null,null,208.15,null,null,null,10.909329140461216]
[null,null,20011108,null,null,28,28,null,null,null,642,null,null,22.928571428571427,null,null,65.48,null,null,null,10.199376947040498]
[null,null,20011211,null,null,33,33,null,null,null,1300,null,null,39.393939393939391,null,null,124.37,null,null,null,9.5669230769230769]
[null,null,20020114,null,null,34,34,null,null,null,1071,null,null,31.5,null,null,97.73,null,null,null,9.125116713352007]
[null,null,20020212,null,null,30,30,null,null,null,886,null,null,29.533333333333335,null,null,74.510000000000005,null,null,null,8.4097065462753964]
[null,null,20020312,null,null,28,28,null,null,null,825,null,null,29.464285714285715,null,null,70.510000000000005,null,null,null,8.5466666666666669]
[null,null,20020411,null,null,30,30,null,null,null,1279,null,null,42.633333333333333,null,null,100.24,null,null,null,7.8373729476153242]
[null,null,20020513,null,null,32,32,null,null,null,2621,null,null,81.90625,null,null,188.11,null,null,null,7.1770316673025567]
[null,null,20020612,null,null,30,30,null,null,null,2309,null,null,76.966666666666669,null,null,210.96,null,null,null,9.1364226938068427]
[null,null,20020711,null,null,29,29,null,null,null,2862,null,null,{"$f":"K34/F34","v":98.689655172413794},null,null,263.02,null,null,null,{"$f":"(Q34/K34)*100","v":9.1900768693221515}]
[null,null,20020809,null,null,29,29,null,null,null,3220,null,null,111.03448275862068,null,null,296.73,null,null,null,9.215217391304348]
[null,null,20020910,null,null,32,32,null,null,null,3053,null,null,95.40625,null,null,296.62,null,null,null,9.7156894857517209]
[null,null,20021009,null,null,29,29,null,null,null,2043,null,null,70.448275862068968,null,null,196.36,null,null,null,9.6113558492413134]
[null,null,20021108,null,null,30,30,null,null,null,1138,null,null,37.93333333333333,null,null,106.52,null,null,null,9.3602811950790858]
[null,null,20021211,null,null,33,33,null,null,null,1088,null,null,32.969696969696969,null,null,93.3,null,null,null,8.5753676470588243]
[null,null,20030115,null,null,35,35,null,null,null,1169,null,null,33.4,null,null,101.8,null,null,null,8.7082976903336178]
[null,null,20030212,null,null,28,28,null,null,null,839,null,null,29.964285714285715,null,null,77.72,null,null,null,9.2634088200238374]
[null,null,20030314,null,null,30,30,null,null,null,1008,null,null,33.6,null,null,97.88,null,null,null,9.7103174603174587]
[null,null,20030414,null,null,31,31,null,null,null,1193,null,null,38.483870967741936,null,null,112.82,null,null,null,9.45683151718357]
[null,null,20030513,null,null,29,29,null,null,null,1849,null,null,63.758620689655174,null,null,165.79,null,null,null,8.966468361276366]
[null,null,20030613,null,null,31,31,null,null,null,2498,null,null,80.58064516129032,null,null,266.87,null,null,null,10.683346677341873]
[null,null,20030715,null,null,32,32,null,null,null,2670,null,null,83.4375,null,null,285.69,null,null,null,10.7]
[null,null,20030813,null,null,29,29,null,null,null,2611,null,null,90.034482758620683,null,null,303.95,null,null,null,11.641133665262352]
[null,null,20030912,null,null,30,30,null,null,null,2531,null,null,84.36666666666666,null,null,294.44,null,null,null,11.633346503358357]
[null,null,20031013,null,null,31,31,null,null,null,2179,null,null,70.290322580645167,null,null,252.59,null,null,null,11.592014685635613]
[null,null,20031013,null,null,31,31,null,null,null,2179,null,null,70.290322580645167,null,null,252.59,null,null,null,11.592014685635613]
[null,null,20031111,null,null,29,29,null,null,null,1657,null,null,57.137931034482762,null,null,190.55,null,null,null,11.499698249849127]
[null,null,20031212,null,null,31,31,null,null,null,1328,null,null,42.838709677419352,null,null,136.29,null,null,null,10.262801204819276]
[null,null,20040114,null,null,33,33,null,null,null,1079,null,null,32.696969696969695,null,null,113.82,null,null,null,10.548656163113995]
[null,null,20040213,null,null,30,30,null,null,null,930,null,null,31,null,null,100.38,null,null,null,10.793548387096774]
[null,null,20040315,null,null,31,31,null,null,null,970,null,null,31.29032258064516,null,null,104,null,null,null,10.721649484536082]
[null,null,20040414,null,null,30,30,null,null,null,1499,null,null,49.966666666666669,null,null,151.72,null,null,null,10.121414276184122]
[null,null,20040513,null,null,29,29,null,null,null,1639,null,null,56.517241379310342,null,null,164.35,null,null,null,10.027455765710799]
[null,null,20040614,null,null,32,32,null,null,null,2589,null,null,80.90625,null,null,301.33,null,null,null,11.638856701429122]
[null,null,20040714,null,null,30,30,null,null,null,2219,null,null,73.966666666666669,null,null,257.35000000000002,null,null,null,11.597566471383507]
[null,null,20040812,null,null,29,29,null,null,null,2552,null,null,88,null,null,296.94,null,null,null,11.635579937304074]
[null,null,20040911,null,null,30,30,null,null,null,2288,null,null,76.266666666666666,null,null,265.55,null,null,null,11.606206293706295]
[null,null,20041012,null,null,31,31,null,null,null,1388,null,null,44.774193548387096,null,null,158.56,null,null,null,11.423631123919309]
[null,null,20041213,null,null,33,33,null,null,null,1183,null,null,35.848484848484851,null,null,123.21,null,null,null,10.415046491969568]
[null,null,20050113,null,null,31,31,null,null,null,1086,null,null,35.032258064516128,null,null,127.01,null,null,null,11.695211786372008]
[null,null,20050214,null,null,32,32,null,null,null,951,null,null,29.71875,null,null,113.27,null,null,null,11.91062039957939]
[null,null,20050315,null,null,29,29,null,null,null,976,null,null,{"$f":"K66/F66","v":33.655172413793103},null,null,115.81,null,null,null,{"$f":"(Q66/K66)*100","v":11.865778688524591}]
[null,null,20050414,null,null,30,30,null,null,null,1095,null,null,36.5,null,null,127.92,null,null,null,11.682191780821919]
[null,null,20050513,null,null,29,29,null,null,null,1348,null,null,46.482758620689658,null,null,161.94,null,null,null,12.013353115727003]
[null,null,20050614,null,null,32,32,null,null,null,2647,null,null,82.71875,null,null,355.07,null,null,null,13.414053645636571]
[null,"X",20050715,null,null,32,32,null,null,null,2647,null,null,{"$f":"K70/F70","v":82.71875},null,null,355.07,null,null,null,13.414053645636571]
[null,null,20050812,null,null,30,30,null,null,null,2378,null,null,79.266666666666666,null,null,318.33,null,null,null,13.38645920941968]
[null,null,20050913,null,null,32,32,null,null,null,2714,null,null,84.8125,null,null,366.43,null,null,null,13.50147383935151]
[null,null,20051012,null,null,29,29,null,null,null,2178,null,null,75.103448275862064,null,null,292.79000000000002,null,null,null,13.443067033976124]
[null,null,20051110,null,null,29,29,null,null,null,1287,null,null,44.379310344827587,null,null,194.23,null,null,null,15.091686091686091]
[null,null,20051212,null,null,32,32,null,null,null,1126,null,null,35.1875,null,null,159.78,null,null,null,14.19005328596803]
[null,null,20060116,null,null,35,35,null,null,null,870,null,null,24.857142857142858,null,null,137.05000000000001,null,null,null,15.752873563218392]
[null,null,20060213,null,null,28,28,null,null,null,920,null,null,32.857142857142854,null,null,144.19999999999999,null,null,null,15.67391304347826]
[null,null,20060315,null,null,30,30,null,null,null,960,null,null,32,null,null,149.75,null,null,null,15.598958333333332]
[null,null,20060412,null,null,28,28,null,null,null,1225,null,null,43.75,null,null,192.61,null,null,null,15.72326530612245]
[null,null,20060515,null,null,33,33,null,null,null,2303,null,null,69.787878787878782,null,null,347.6,null,null,null,15.093356491532784]
[null,null,20060613,null,null,29,29,null,null,null,2161,null,89,74.517241379310349,null,null,366.19,null,null,null,16.945395650161963]
[null,null,20060714,null,null,31,31,null,null,null,2659,null,89,85.774193548387103,null,null,452.07,null,null,null,17.001504324934185]
[null,null,20060812,null,null,29,29,null,null,null,2701,null,92,93.137931034482762,null,null,458.82,null,null,null,16.987041836356905]
[null,null,20060913,null,null,32,32,null,null,null,2389,null,92,74.65625,null,null,353.94,null,null,null,14.815403934700711]
[null,null,20061012,null,null,29,29,null,null,null,2010,null,88,69.310344827586206,null,null,320.10000000000002,null,null,null,15.92537313432836]
[null,null,20061113,null,null,32,32,null,null,null,1396,null,78,43.625,null,null,224.41,null,null,null,16.075214899713465]
[null,null,20061214,null,null,31,31,null,null,null,1120,null,69,36.12903225806452,null,null,181.38,null,null,null,16.194642857142856]
[null,null,20070117,null,null,34,34,null,null,null,1177,null,65,34.617647058823529,null,null,190.27,null,null,null,16.165675446049281]
[null,null,20070215,null,null,29,29,null,null,null,985,null,58,33.96551724137931,null,null,134.66999999999999,null,null,null,13.67208121827411]
[null,null,20070316,null,null,29,29,null,null,null,1060,null,72,36.551724137931032,null,null,172.04,null,null,null,16.230188679245284]
[null,null,20070416,null,null,31,31,null,null,null,1310,null,75,42.258064516129032,null,null,211.01,null,null,null,16.107633587786257]
[null,null,20070516,null,null,30,30,null,null,null,1648,null,82,54.93333333333333,null,null,255.75,null,null,null,15.518810679611651]
[null,null,20070615,null,null,30,30,null,null,null,2094,null,86,69.8,null,null,323.19,null,null,null,15.434097421203438]
[null,null,20070716,null,null,31,31,null,null,null,2427,null,88,78.290322580645167,null,null,373.66,null,null,null,15.395962093119078]
[null,null,20070813,null,null,28,28,null,null,null,2348,null,91,83.857142857142861,null,null,361.71,null,null,null,15.405025553662691]
[null,null,20070914,null,null,32,32,null,null,null,2678,null,91,83.6875,null,null,411.61,null,null,null,15.370052277819269]
[null,null,20071012,null,null,28,28,null,null,null,2155,null,91,76.964285714285708,null,null,334.02,null,null,null,15.499767981438515]
[null,"X",20071115,null,null,28,28,null,null,null,2155,null,91,76.964285714285708,null,null,334.02,null,null,null,15.499767981438515]
[null,"X",20071215,null,null,28,28,null,null,null,2155,null,91,76.964285714285708,null,null,334.02,null,null,null,15.499767981438515]
["TXU","ü",20080118,"2007-12-14","2008-01-16",{"$f":"IF(OR(D100=\"\", E100=\"\"),\"\",DATEDIF(D100, E100, \"d\"))","v":33},null,1228,93984,92756,{"$f":"IF(OR(I100=\"\",J100=\"\"),\"\",IF((I100-J100)<0,I100-J100+100000,I100-J100))","v":1228},{"$f":"IF(OR(H100=\"\", K100=\"\"),\"\",K100-H100)","v":0},null,{"$f":"IF(OR(F100=\"\", K100=\"\"),\"\",K100/F100)","v":37.212121212121211},null,null,167.02,null,null,null,{"$f":"IF(OR(Q100=\"\", K100=\"\"),\"\", (Q100/K100)*100)","v":13.60097719869707}]
[null,"ü",20080218,{"$f":"IF(OR(C101=\"\", E100=\"\"),\"\",E100)","v":"2008-01-16"},"2008-02-13",{"$f":"IF(OR(D101=\"\", E101=\"\"),\"\",DATEDIF(D101, E101, \"d\"))","v":28},null,990,94974,93984,990,{"$f":"IF(OR(H101=\"\", K101=\"\"),\"\",K101-H101)","v":0},null,{"$f":"IF(OR(F101=\"\", K101=\"\"),\"\",K101/F101)","v":35.357142857142854},null,null,134.65,null,null,null,13.601010101010102]
[null,"ü",20080318,{"$f":"IF(OR(C102=\"\", E101=\"\"),\"\",E101)","v":"2008-02-13"},"2008-03-14",30,null,1050,96024,94974,1050,0,null,35,null,null,142.81,null,null,null,13.60095238095238]
[null,"ü",20080417,{"$f":"IF(OR(C103=\"\", E102=\"\"),\"\",E102)","v":"2008-03-14"},"2008-04-14",31,null,1497,97521,96024,1497,0,null,48.29032258064516,null,null,203.61,null,null,null,13.601202404809619]
[null,"ü",20080516,{"$f":"IF(OR(C104=\"\", E103=\"\"),\"\",E103)","v":"2008-04-14"},"2008-05-14",30,null,1704,99225,97521,1704,0,null,56.8,null,null,231.77,null,null,null,13.601525821596244]
[null,"ü",20080617,"2008-05-14","2008-06-16",33,null,2855,2080,99225,2855,0,null,86.515151515151516,null,null,388.31,null,null,null,13.601050788091069]
[null,"ü",20080717,"2008-06-16","2008-07-16",30,null,2579,4659,2080,{"$f":"IF(OR(I106=\"\",J106=\"\"),\"\",IF((I106-J106)<0,I106-J106+100000,I106-J106))","v":2579},0,null,85.966666666666669,null,null,350.77,null,null,null,13.601008142690965]
[null,"ü",20080815,"2008-07-16","2008-08-14",29,null,2670,7329,4659,2670,0,null,92.068965517241381,null,null,363.15,null,null,null,13.601123595505618]
[null,"ü",20080916,"2008-08-14","2008-09-12",29,null,2398,9727,7329,2398,0,null,82.689655172413794,null,null,326.14999999999998,null,null,null,13.600917431192661]
[null,"ü",20081015,"2008-09-12","2008-10-13",31,null,501,10228,9727,501,0,null,16.161290322580644,null,null,68.14,null,null,null,13.600798403193611]
[null,"ü",20081114,"2008-10-13","2008-11-11",29,null,2587,12815,10228,2587,0,null,89.206896551724142,null,null,351.86,null,null,null,13.601082334750677]
[null,"ü",20081216,"2008-11-11","2008-12-13",32,null,1270,14085,12815,{"$f":"IF(OR(I111=\"\",J111=\"\"),\"\",IF((I111-J111)<0,I111-J111+100000,I111-J111))","v":1270},{"$f":"IF(OR(H111=\"\", K111=\"\"),\"\",K111-H111)","v":0},null,39.6875,null,null,172.58,null,null,null,13.588976377952758]
["txu-d+1","ü",20090120,{"$f":"IF(OR(C112=\"\", E111=\"\"),\"\",E111)","v":"2008-12-13"},"2009-01-16",34,35,1306,15391,14085,{"$f":"IF(OR(I112=\"\",J112=\"\"),\"\",IF((I112-J112)<0,I112-J112+100000,I112-J112))","v":1306},{"$f":"IF(OR(H112=\"\", K112=\"\"),\"\",K112-H112)","v":0},null,38.411764705882355,null,null,177.63,null,null,null,13.601071975497703]
["txu-d+1","ü",20090219,{"$f":"IF(OR(C113=\"\", E112=\"\"),\"\",E112)","v":"2009-01-16"},"2009-02-13",28,29,984,16375,15391,{"$f":"IF(OR(I113=\"\",J113=\"\"),\"\",IF((I113-J113)<0,I113-J113+100000,I113-J113))","v":984},{"$f":"IF(OR(H113=\"\", K113=\"\"),\"\",K113-H113)","v":0},null,35.142857142857146,null,null,137.13,null,null,null,13.935975609756095]
["txu-d+1","ü",20090325,{"$f":"IF(OR(C114=\"\", E113=\"\"),\"\",E113)","v":"2009-02-13"},"2009-03-13",28,29,1157,17532,16375,1157,0,null,41.321428571428569,null,null,{"$f":"155.04+3.1+3.3","v":161.44},null,null,null,13.953327571305099]
["txu-d+1","ü",20090421,{"$f":"IF(OR(C115=\"\", E114=\"\"),\"\",E114)","v":"2009-03-13"},"2009-04-14",32,33,1335,18867,17532,1335,0,null,41.71875,null,null,{"$f":"178.89+2.68+3.29","v":184.85999999999999},null,null,null,13.847191011235955]
["txu-d+1","ü",20090520,"2009-04-14","2009-05-14",30,31,1729,20596,18867,1729,0,null,57.633333333333333,null,null,{"$f":"231.69+3.48+3.29","v":238.45999999999998},null,null,null,13.79178716020821]
["txu-d+1","ü",20090623,"2009-05-14","2009-06-15",32,33,2300,22896,20596,2300,0,null,71.875,null,null,{"$f":"308.2+4.62+3.29","v":316.11},null,null,null,13.743913043478262]
["txu-d+1","ü",20090721,"2009-06-15","2009-07-15",30,31,2561,25457,22896,2561,0,null,85.36666666666666,null,null,{"$f":"343.17+5.15+3.29","v":351.61},null,null,null,13.729402577118313]
["txu-d+1","ü",20090819,"2009-07-15","2009-08-14",30,31,2701,28158,25457,2701,0,null,90.033333333333331,null,null,{"$f":"361.93+5.43+3.24+0.05","v":370.65000000000003},null,null,null,13.722695298037765]
["txu-d+1","ü",20090918,"2009-08-14","2009-09-12",29,30,2436,30594,28158,2436,0,null,84,null,null,{"$f":"326.42+3.24+4.95","v":334.61},null,null,null,13.736042692939247]
["txu-d+1","ü",20091017,"2009-09-12","2009-10-11",29,30,2061,32655,30594,2061,0,null,71.068965517241381,null,null,{"$f":"276.17+3.24+4.19","v":283.60000000000002},null,null,null,13.760310528869482]
[null,"+1",20091117,{"$f":"IF(OR(C122=\"\", E121=\"\"),\"\",E121+1)","v":"2009-10-12"},"2009-11-10",29,29,1458,34113,32655,1458,0,null,50.275862068965516,null,null,{"$f":"195.37+3.24+2.98","v":201.59},null,null,null,13.82647462277092]
[null,"+1",20091217,{"$f":"IF(OR(C123=\"\", E122=\"\"),\"\",E122+1)","v":"2009-11-11"},"2009-12-14",33,33,1255,35368,34113,1255,0,null,38.030303030303031,null,null,{"$f":"168.17+4.01+2.58","v":174.76},null,null,null,13.925099601593624]
[null,"+1",20100120,{"$f":"IF(OR(C124=\"\", E123=\"\"),\"\",E123+1)","v":"2009-12-15"},"2010-01-15",31,31,1277,36645,35368,{"$f":"IF(OR(I124=\"\",J124=\"\"),\"\",IF((I124-J124)<0,I124-J124+100000,I124-J124))","v":1277},{"$f":"IF(OR(H124=\"\", K124=\"\"),\"\",K124-H124)","v":0},null,41.193548387096776,null,null,{"$f":"171.12+4.57+2.64","v":178.32999999999998},null,null,null,13.964761158966327]
[null,"+1",20100218,{"$f":"IF(OR(C125=\"\", E124=\"\"),\"\",E124+1)","v":"2010-01-16"},"2010-02-15",30,30,1234,37879,36645,1234,0,null,41.133333333333333,null,null,{"$f":"165.36+4.52+2.55","v":172.43000000000004},null,null,null,13.973257698541333]
[null,"ü",20100319,{"$f":"IF(OR(C126=\"\", E125=\"\"),\"\",E125)","v":"2010-02-15"},"2010-03-16",29,29,1191,39070,37879,1191,0,null,41.068965517241381,null,null,{"$f":"5.46+153.97+2.39+0.11","v":161.93},null,null,null,13.596137699412258]
[null,"ü",20100419,"2010-03-16","2010-04-15",30,30,1207,40277,39070,1207,0,null,40.233333333333334,null,null,171.73,null,null,null,14.227837613918807]
[null,"ü",20100519,"2010-04-15","2010-05-13",28,28,1782,42059,40277,1782,0,null,63.642857142857146,null,null,245.1,null,null,null,13.754208754208754]
[null,"ü",20100618,"2010-05-13","2010-06-15",33,33,2862,44921,42059,2862,0,null,86.727272727272734,null,null,391.62,null,null,null,13.683438155136269]
[null,"ü",20100719,"2010-06-15","2010-07-15",30,30,2919,47840,44921,2919,0,null,97.3,null,null,{"$f":"419.45-19.58","v":399.87},null,null,null,13.698869475847895]
[null,"ü",20100818,"2010-07-15","2010-08-12",28,28,2718,50558,47840,2718,0,null,97.071428571428569,null,null,372.59,null,null,null,13.708241353936717]
[null,"ü",20100917,{"$f":"IF(OR(C132=\"\", E131=\"\"),\"\",E131)","v":"2010-08-12"},"2010-09-09",28,28,2642,53200,50558,2642,0,null,94.357142857142861,null,null,362.28,null,null,null,{"$f":"IF(OR(Q132=\"\", K132=\"\"),\"\", (Q132/K132)*100)","v":13.712339137017409}]
[null,"ü",20101016,"2010-09-09","2010-10-11",32,32,2477,55677,53200,2477,0,null,77.40625,null,null,358.02,null,null,null,14.453774727492934]
[null,"ü",20101115,"2010-10-11","2010-11-10",30,30,1837,57514,55677,1837,0,null,61.233333333333334,null,null,253.21,null,null,null,13.783886771910725]
[null,"ü",20101217,"2010-11-10","2010-12-13",33,33,1609,59123,57514,1609,0,null,48.757575757575758,null,null,222.27,null,null,null,13.814170292106901]
[null,"ü",20110120,"2010-12-13","2011-01-14",32,32,1522,60645,59123,1522,0,null,47.5625,null,null,210.34,null,null,null,13.819973718791065]
[null,"ü",20110218,"2011-01-14","2011-02-15",32,32,1332,61977,60645,1332,0,null,41.625,null,null,184.35,null,null,null,13.84009009009009]
[null,"ü",20110319,"2011-02-15","2011-03-15",28,28,1352,63329,61977,1352,0,null,48.285714285714285,null,null,187.07,null,null,null,13.836538461538462]
[null,"ü",20110418,"2011-03-15","2011-04-14",30,30,1768,65097,63329,1768,0,null,58.93333333333333,null,null,243.53,null,null,null,13.774321266968325]
[null,null,20110519,"2011-04-14","2011-05-15",31,31,2310,67407,65097,2310,0,null,74.516129032258064,null,null,317.10000000000002,null,null,null,13.72727272727273]
[null,null,20110618,"2011-05-15","2011-06-14",30,30,{"$f":"2308+689","v":2997},{"$f":"68096+2308","v":70404},67407,2997,0,null,99.9,null,null,410.34,null,null,null,13.691691691691691]
[null,null,20110720,{"$f":"IF(OR(C142=\"\", E141=\"\"),\"\",E141)","v":"2011-06-14"},"2011-07-14",30,30,3301,5609,2308,3301,0,null,110.03333333333333,null,null,451.62,null,null,null,13.681308694335051]
[null,null,20110819,{"$f":"IF(OR(C143=\"\", E142=\"\"),\"\",E142)","v":"2011-07-14"},"2011-08-14",{"$f":"IF(OR(D143=\"\", E143=\"\"),\"\",DATEDIF(D143, E143, \"d\"))","v":31},31,3505,9114,5609,{"$f":"IF(OR(I143=\"\",J143=\"\"),\"\",IF((I143-J143)<0,I143-J143+100000,I143-J143))","v":3505},{"$f":"IF(OR(H143=\"\", K143=\"\"),\"\",K143-H143)","v":0},null,{"$f":"IF(OR(F143=\"\", K143=\"\"),\"\",K143/F143)","v":113.06451612903226},null,null,479.3,null,null,null,13.67475035663338]
[null,null,20110917,{"$f":"IF(OR(C144=\"\", E143=\"\"),\"\",E143)","v":"2011-08-14"},"2011-09-13",30,30,3086,12200,9114,3086,0,null,102.86666666666666,null,null,368.53,null,null,null,11.941996111471159]
[null,null,20111017,{"$f":"IF(OR(C145=\"\", E144=\"\"),\"\",E144)","v":"2011-09-13"},"2011-10-12",29,29,2543,14743,12200,2543,0,null,87.689655172413794,null,null,305.8,null,null,null,12.025167125442392]
[null,null,20111116,"2011-10-12","2011-11-10",29,29,1808,16551,14743,1808,0,null,62.344827586206897,null,null,221.71,null,null,null,12.262721238938054]
[null,null,20111217,"2011-11-10","2011-12-13",33,33,1582,18133,16551,1582,0,null,47.939393939393938,null,null,195.44,null,null,null,12.353982300884955]
[null,null,20120120,"2011-12-13","2012-01-16",34,34,1459,19592,18133,1459,0,null,42.911764705882355,null,null,181.31,null,null,null,12.427004797806717]
[null,null,20120218,"2012-01-16","2012-02-14",{"$f":"IF(OR(D149=\"\", E149=\"\"),\"\",DATEDIF(D149, E149, \"d\"))","v":29},29,1459,21051,19592,{"$f":"IF(OR(I149=\"\",J149=\"\"),\"\",IF((I149-J149)<0,I149-J149+100000,I149-J149))","v":1459},{"$f":"IF(OR(H149=\"\", K149=\"\"),\"\",K149-H149)","v":0},null,{"$f":"IF(OR(F149=\"\", K149=\"\"),\"\",K149/F149)","v":50.310344827586206},null,null,184.54,null,null,null,12.648389307745031]
[null,null,20120319,{"$f":"IF(OR(C150=\"\", E149=\"\"),\"\",E149)","v":"2012-02-14"},"2012-03-14",29,29,1346,22397,21051,1346,0,null,46.413793103448278,null,null,179.49,null,null,null,13.335066864784547]
[null,null,20120419,"2012-03-14","2012-04-15",32,32,2265,24662,22397,2265,0,null,70.78125,null,null,278.22000000000003,null,null,null,12.283443708609273]
[null,null,20120518,"2012-04-15","2012-05-14",29,29,2349,27011,24662,2349,0,null,81,null,null,288.10000000000002,null,null,null,12.264793529161347]
[null,null,20120618,"2012-05-14","2012-06-13",30,30,2566,29577,27011,2566,0,null,85.533333333333331,null,null,{"$f":"425.09-111.48","v":313.60999999999996},null,null,null,12.221745908028057]
[null,null,20120719,"2012-06-13","2012-07-15",32,32,2667,32244,29577,2667,0,null,83.34375,null,null,325.43,null,null,null,12.202099737532809]
[null,null,20120817,"2012-07-15","2012-08-13",29,29,2719,34963,32244,2719,0,null,93.758620689655174,null,null,331.58,null,null,null,12.194924604634055]
[null,null,20120917,"2012-08-13","2012-09-12",30,30,2597,37560,34963,2597,0,null,86.566666666666663,null,null,355.29,null,null,null,13.680785521755872]
[null,null,20121017,"2012-09-12","2012-10-11",29,29,2050,39610,37560,2050,0,null,70.689655172413794,null,null,283.61,null,null,null,13.834634146341465]
[null,null,20121115,"2012-10-11","2012-11-11",31,31,1702,41312,39610,1702,0,null,54.903225806451616,null,null,237.38,null,null,null,13.947121034077556]
[null,null,20121217,"2012-11-11","2012-12-12",31,31,1331,42643,41312,1331,0,null,42.935483870967744,null,null,200.57,null,null,null,15.069120961682945]
[null,null,20130119,"2012-12-12","2013-01-15",{"$f":"IF(OR(D160=\"\", E160=\"\"),\"\",DATEDIF(D160, E160, \"d\"))","v":34},34,1330,43973,42643,{"$f":"IF(OR(I160=\"\",J160=\"\"),\"\",IF((I160-J160)<0,I160-J160+100000,I160-J160))","v":1330},{"$f":"IF(OR(H160=\"\", K160=\"\"),\"\",K160-H160)","v":0},null,{"$f":"IF(OR(F160=\"\", K160=\"\"),\"\",K160/F160)","v":39.117647058823529},null,null,187.99,null,null,null,14.134586466165414]
[null,null,20130219,"2013-01-15","2013-02-13",{"$f":"IF(OR(D161=\"\", E161=\"\"),\"\",DATEDIF(D161, E161, \"d\"))","v":29},29,1135,45108,43973,{"$f":"IF(OR(I161=\"\",J161=\"\"),\"\",IF((I161-J161)<0,I161-J161+100000,I161-J161))","v":1135},{"$f":"IF(OR(H161=\"\", K161=\"\"),\"\",K161-H161)","v":0},null,{"$f":"IF(OR(F161=\"\", K161=\"\"),\"\",K161/F161)","v":39.137931034482762},null,null,162.61000000000001,null,null,null,14.326872246696038]
[null,null,20130320,"2013-02-13","2013-03-14",29,29,1085,46193,45108,1085,0,null,37.413793103448278,null,null,156.11000000000001,null,null,null,14.388018433179726]
[null,null,20130419,"2013-03-14","2013-04-15",32,32,1642,47835,46193,1642,0,null,51.3125,null,null,228.56,null,null,null,13.919610231425091]
[null,null,20130518,{"$f":"IF(OR(C164=\"\", E163=\"\"),\"\",E163)","v":"2013-04-15"},"2013-05-14",29,29,1587,49422,47835,1587,0,null,54.724137931034484,null,null,221.42,null,null,null,{"$f":"IF(OR(Q164=\"\", K164=\"\"),\"\", (Q164/K164)*100)","v":13.952110901071201}]
[null,null,20131619,"2013-05-14","2013-06-13",30,30,2513,51935,49422,2513,0,null,83.766666666666666,null,null,341.89,null,null,null,13.604854755272584]
[null,null,20130719,"2013-06-13","2013-07-15",32,32,3146,55081,51935,3146,0,null,98.3125,null,null,424.25,null,null,null,13.485378258105532]
[null,null,20130817,"2013-07-15","2013-08-13",29,29,2610,57691,55081,2610,0,null,90,null,null,353.77,null,null,null,13.554406130268198]
[null,null,20130918,"2013-08-13","2013-09-12",30,30,2585,60276,57691,2585,0,null,86.166666666666671,null,null,348.56,null,null,null,13.48394584139265]
[null,null,20131017,"2013-09-12","2013-10-13",31,31,2186,62462,60276,2186,0,null,70.516129032258064,null,null,297.06,null,null,null,13.589204025617565]
[null,null,20131115,"2013-10-13","2013-11-11",29,29,1255,63717,62462,1255,0,null,43.275862068965516,null,null,177.14,null,null,null,14.114741035856573]
[null,null,20131218,"2013-11-11","2013-12-12",31,31,1159,64876,63717,1159,0,null,37.387096774193552,null,null,174.19,null,null,null,15.029335634167385]
[null,null,20140121,"2013-12-12","2014-01-15",{"$f":"IF(OR(D172=\"\", E172=\"\"),\"\",DATEDIF(D172, E172, \"d\"))","v":34},34,1093,65969,64876,{"$f":"IF(OR(I172=\"\",J172=\"\"),\"\",IF((I172-J172)<0,I172-J172+100000,I172-J172))","v":1093},{"$f":"IF(OR(H172=\"\", K172=\"\"),\"\",K172-H172)","v":0},null,{"$f":"IF(OR(F172=\"\", K172=\"\"),\"\",K172/F172)","v":32.147058823529413},null,null,158.02000000000001,null,null,null,14.457456541628547]
[null,null,20140219,"2014-01-15","2014-02-13",29,29,862,66831,65969,862,0,null,29.724137931034484,null,null,127.86,null,null,null,14.83294663573086]
[null,null,20140320,"2014-02-13","2014-03-16",31,31,1036,67867,66831,1036,0,null,33.41935483870968,null,null,152.71,null,null,null,14.74034749034749]
[null,null,20140418,"2014-03-16","2014-04-14",29,29,1083,68950,67867,1083,0,null,37.344827586206897,null,null,159.02000000000001,null,null,null,14.683287165281625]
[null,null,20140519,"2014-04-14","2014-05-14",30,30,1500,70450,68950,1500,0,null,50,null,null,214.87,null,null,null,14.324666666666666]
[null,null,20140619,"2014-05-14","2014-06-14",31,31,2216,72666,70450,2216,0,null,71.483870967741936,null,null,341.06,null,null,null,15.390794223826715]
[null,null,20140719,"2014-06-14","2014-07-15",31,31,2520,75186,72666,2520,0,null,81.290322580645167,null,null,385.79,null,null,null,15.309126984126987]
[null,null,20140818,"2014-07-15","2014-08-13",29,29,2410,77596,75186,2410,0,null,83.103448275862064,null,null,369.57,null,null,null,15.334854771784231]
[null,null,20140918,"2014-08-13","2014-09-14",32,32,2620,80216,77596,2620,0,null,81.875,null,null,407.26,null,null,null,15.544274809160305]
[null,null,20141017,"2014-09-14","2014-10-13",29,29,1967,82183,80216,1967,0,null,67.827586206896555,null,null,309.23,null,null,null,15.720894763599391]
[null,null,20141117,"2014-10-13","2014-11-11",29,29,1402,83585,82183,1402,0,null,48.344827586206897,null,null,223.13,null,null,null,15.915121255349501]
[null,null,20141218,"2014-11-11","2014-12-14",33,33,1212,84797,83585,1212,0,null,36.727272727272727,null,null,194.87,null,null,null,16.078382838283829]
[null,null,20150121,"2014-12-14","2015-01-15",32,32,1194,85991,84797,1194,0,null,37.3125,null,null,190.36,null,null,null,15.943048576214405]
[null,null,20150219,"2015-01-15","2015-02-15",31,31,1029,87020,85991,1029,0,null,33.193548387096776,null,null,166.07,null,null,null,16.138969873663751]
[null,null,20150320,{"$f":"IF(OR(C186=\"\", E185=\"\"),\"\",E185)","v":"2015-02-15"},"2015-03-16",{"$f":"IF(OR(D186=\"\", E186=\"\"),\"\",DATEDIF(D186, E186, \"d\"))","v":29},29,1022,88042,87020,{"$f":"IF(OR(I186=\"\",J186=\"\"),\"\",IF((I186-J186)<0,I186-J186+100000,I186-J186))","v":1022},{"$f":"IF(OR(H186=\"\", K186=\"\"),\"\",K186-H186)","v":0},null,{"$f":"IF(OR(F186=\"\", K186=\"\"),\"\",K186/F186)","v":35.241379310344826},null,null,163.69,null,null,null,16.016634050880626]
[null,null,20150420,"2015-03-16","2015-04-15",30,30,1410,89452,88042,1410,0,null,47,null,null,220.44,null,null,null,15.634042553191488]
[null,null,20150520,"2015-04-15","2015-05-14",29,29,1649,91101,89452,1649,0,null,56.862068965517238,null,null,255.43,null,null,null,15.489993935718619]
[null,null,20150619,"2015-05-14","2015-06-15",32,32,2486,93587,91101,2486,0,null,77.6875,null,null,374.73,null,null,null,15.073612228479485]
[null,null,20150720,"2015-06-15","2015-07-15",30,30,2662,96249,93587,2662,0,null,88.733333333333334,null,null,400.46,null,null,null,15.043576258452291]
[null,null,20150819,"2015-07-15","2015-08-13",29,29,3008,99257,96249,3008,0,null,103.72413793103448,null,null,451.1,null,null,null,14.996675531914894]
[null,null,20150918,"2015-08-13","2015-09-14",32,32,2608,1865,99257,2608,0,null,81.5,null,null,253.32,null,null,null,9.7131901840490791]
[null,null,20151017,"2015-09-14","2015-10-13",29,29,2178,4043,1865,2178,0,null,75.103448275862064,null,null,204.37,null,null,null,9.3833792470156112]
[null,null,20151117,"2015-10-13","2015-11-11",29,29,1665,5708,4043,1665,0,null,57.413793103448278,null,null,166.19,null,null,null,9.9813813813813805]
[null,null,20151218,"2015-11-11","2015-12-14",33,33,1391,7099,5708,1391,0,null,42.151515151515149,77.86,65.23,145.24,{"$f":"IF(OR(O195=\"\",$K195=\"\"), \"\", (O195/$K195)*100)","v":5.5974119338605322},{"$f":"IF(OR(P195=\"\",$K195=\"\"), \"\", (P195/$K195)*100)","v":4.6894320632638387},{"$f":"IF(OR(R195=\"\",S195=\"\"), \"\", R195+S195)","v":10.286843997124372},10.441409058231489]
[null,null,20160121,"2015-12-14","2016-01-17",34,34,1409,8508,7099,1409,0,null,41.441176470588232,78.44,67.47,148.1,{"$f":"IF(OR(O196=\"\",$K196=\"\"), \"\", (O196/$K196)*100)","v":5.567068843151171},{"$f":"IF(OR(P196=\"\",$K196=\"\"), \"\", (P196/$K196)*100)","v":4.7885024840312278},{"$f":"IF(OR(R196=\"\",S196=\"\"), \"\", R196+S196)","v":10.3555713271824},{"$f":"IF(OR(Q196=\"\", K196=\"\"),\"\", (Q196/K196)*100)","v":10.511000709723207}]
[null,null,20160219,"2016-01-17","2016-02-15",29,29,1046,9554,8508,1046,0,null,36.068965517241381,76.89,51.75,130.57,7.350860420650096,4.9474187380497128,12.29827915869981,12.482791586998088]
[null,null,20160319,"2016-02-15","2016-03-15",29,29,1124,10678,9554,1124,0,null,38.758620689655174,81.89,51.48,135.37,7.2855871886120998,4.580071174377224,11.865658362989324,12.043594306049823]
[null,null,20160420,"2016-03-15","2016-04-14",30,30,1368,12046,10678,1368,0,null,45.6,77.13,60.98,140.18,5.6381578947368416,4.4576023391812862,10.095760233918128,10.247076023391813]
[null,null,20160519,"2016-04-14","2016-05-15",31,31,2080,14126,12046,2080,0,null,67.096774193548384,102.71,89.54,195.13,4.9379807692307685,4.3048076923076923,9.2427884615384599,9.3812499999999996]
[null,null,20160618,"2016-05-15","2016-06-14",30,30,2370,16496,14126,2370,0,null,79,122.14,101.35,226.84,5.153586497890295,4.2763713080168779,9.429957805907172,9.5713080168776372]
[null,null,20160720,"2016-06-14","2016-07-14",30,30,3191,19687,16496,3191,0,null,106.36666666666666,177.15,134.78,316.61,5.5515512378564713,4.2237543089940459,9.7753055468505181,9.9219680350987165]
[null,null,20160815,{"$f":"IF(OR(C203=\"\", E202=\"\"),\"\",E202)","v":"2016-07-14"},"2016-08-10",27,27,2874,22561,19687,2874,0,null,106.44444444444444,155.91,121.87,281.95,5.4248434237995822,4.2404314544189283,9.6652748782185114,9.8103688239387612]
[null,null,20160915,"2016-08-10","2016-09-11",32,32,2987,25548,22561,2987,0,null,93.34375,163.47999999999999,140,307.64999999999998,5.4730498828255776,4.6869768998995651,10.160026782725144,10.299631737529293]
[null,null,20161014,"2016-09-11","2016-10-10",29,29,2476,28024,25548,2476,0,null,85.379310344827587,118.39,116.67,238.58,4.7815024232633281,4.7120355411954762,9.4935379644588043,9.6357027463651068]
[null,null,20161114,"2016-10-10","2016-11-08",29,29,2122,30146,28024,2122,0,null,73.172413793103445,93.97,95.69,192.51,4.4283694627709709,4.5094250706880299,8.9377945334590017,9.0721017907634298]
[null,null,20161214,"2016-11-08","2016-12-11",33,33,1428,31574,30146,1428,0,null,43.272727272727273,66.67,65.790000000000006,134.44999999999999,4.6687675070028005,4.6071428571428577,9.2759103641456591,9.4152661064425764]
[null,null,20170117,"2016-12-11","2017-01-12",{"$f":"IF(OR(D208=\"\", E208=\"\"),\"\",DATEDIF(D208, E208, \"d\"))","v":32},32,1537,33111,31574,{"$f":"IF(OR(I208=\"\",J208=\"\"),\"\",IF((I208-J208)<0,I208-J208+100000,I208-J208))","v":1537},{"$f":"IF(OR(H208=\"\", K208=\"\"),\"\",K208-H208)","v":0},null,{"$f":"IF(OR(F208=\"\", K208=\"\"),\"\",K208/F208)","v":48.03125},70.27,67.900000000000006,140.25,{"$f":"IF(OR(O208=\"\",$K208=\"\"), \"\", (O208/$K208)*100)","v":4.571893298633702},{"$f":"IF(OR(P208=\"\",$K208=\"\"), \"\", (P208/$K208)*100)","v":4.4176968119713731},{"$f":"IF(OR(R208=\"\",S208=\"\"), \"\", R208+S208)","v":8.9895901106050751},{"$f":"IF(OR(Q208=\"\", K208=\"\"),\"\", (Q208/K208)*100)","v":9.1249186727391027}]
[null,null,20170216,"2017-01-12","2017-02-12",{"$f":"IF(OR(D209=\"\", E209=\"\"),\"\",DATEDIF(D209, E209, \"d\"))","v":31},31,1324,34435,33111,{"$f":"IF(OR(I209=\"\",J209=\"\"),\"\",IF((I209-J209)<0,I209-J209+100000,I209-J209))","v":1324},{"$f":"IF(OR(H209=\"\", K209=\"\"),\"\",K209-H209)","v":0},null,{"$f":"IF(OR(F209=\"\", K209=\"\"),\"\",K209/F209)","v":42.70967741935484},63.24,59.17,124.25,{"$f":"IF(OR(O209=\"\",$K209=\"\"), \"\", (O209/$K209)*100)","v":4.7764350453172204},{"$f":"IF(OR(P209=\"\",$K209=\"\"), \"\", (P209/$K209)*100)","v":4.4690332326283988},{"$f":"IF(OR(R209=\"\",S209=\"\"), \"\", R209+S209)","v":9.2454682779456192},{"$f":"IF(OR(Q209=\"\", K209=\"\"),\"\", (Q209/K209)*100)","v":9.3844410876132933}]
[null,null,20170317,"2017-02-12","2017-03-13",29,29,1381,35816,34435,1381,0,null,47.620689655172413,65.12,56.99,123.95,4.715423606082549,4.126719768283853,8.8421433743664011,8.9753801593048514]
[null,null,20170414,"2017-03-13","2017-04-11",29,29,1721,37537,35816,1721,0,null,59.344827586206897,76.34,69.58,148.11000000000001,4.4357931435212086,4.0429982568274259,8.4787914003486335,8.6060429982568287]
[null,null,20170515,"2017-04-11","2017-05-11",30,30,2027,39564,37537,2027,0,null,67.566666666666663,87.41,80.91,170.85,4.31228416378885,3.9916132215096196,8.3038973852984697,8.4287123828317707]
[null,null,20170617,"2017-05-11","2017-06-12",32,32,2862,42426,39564,2862,0,null,89.4375,145.03,112.37,261.26,5.06743535988819,3.9262753319357095,8.9937106918238996,9.1285814116002797]
[null,null,20170717,"2017-06-12","2017-07-12",30,30,2985,45411,42426,2985,0,null,99.5,153.52000000000001,116.99,274.57,5.1430485762144054,3.9192629815745397,9.062311557788945,9.198324958123953]
[null,null,20170816,"2017-07-12","2017-08-10",29,29,3134,48545,45411,3134,0,null,108.06896551724138,163.80000000000001,122.63,290.73,5.2265475430759416,3.9128908742820676,9.1394384173580097,9.2766432673899182]
[null,null,20170919,"2017-08-10","2017-09-11",32,32,3152,51697,48545,3152,0,null,98.5,165.04,138.21,307.8,5.2360406091370555,4.3848350253807107,9.6208756345177662,9.7652284263959395]
[null,null,20171013,"2017-09-11","2017-10-10",29,29,2594,54291,51697,2594,0,null,89.448275862068968,126.54,114.54,244.7,4.8781804163454128,4.4155744024672323,9.2937548188126442,9.4333076329992291]
[null,null,20171113,"2017-10-10","2017-11-08",29,29,1922,56213,54291,1922,0,null,66.275862068965523,137.97,92.11,233.53,7.1784599375650364,4.7924037460978148,11.970863683662852,12.150364203954215]
[null,null,20171214,"2017-11-08","2017-12-11",33,33,1470,57683,56213,1470,0,null,44.545454545454547,114.92,72.39,190.12,7.8176870748299319,4.9244897959183671,12.742176870748299,12.933333333333334]
[null,null,20180117,"2017-12-11","2018-01-14",34,34,1407,59090,57683,1407,0,null,41.382352941176471,111.71,73.05,187.53,7.9395877754086701,5.1918976545842215,13.131485429992892,13.328358208955224]
[null,null,20180215,"2018-01-14","2018-02-12",29,29,1203,60293,59090,1203,0,null,41.482758620689658,101.3,63.67,167.44,8.4206151288445561,5.2926018287614296,13.713216957605987,13.918536990856193]
[null,null,20180317,{"$f":"IF(OR(C222=\"\", E221=\"\"),\"\",E221)","v":"2018-02-12"},"2018-03-13",{"$f":"IF(OR(D222=\"\", E222=\"\"),\"\",DATEDIF(D222, E222, \"d\"))","v":29},29,1479,61772,60293,{"$f":"IF(OR(I222=\"\",J222=\"\"),\"\",IF((I222-J222)<0,I222-J222+100000,I222-J222))","v":1479},{"$f":"IF(OR(H222=\"\", K222=\"\"),\"\",K222-H222)","v":0},null,{"$f":"IF(OR(F222=\"\", K222=\"\"),\"\",K222/F222)","v":51},115.38,69.56,187.72,{"$f":"IF(OR(O222=\"\",$K222=\"\"), \"\", (O222/$K222)*100)","v":7.8012170385395541},{"$f":"IF(OR(P222=\"\",$K222=\"\"), \"\", (P222/$K222)*100)","v":4.703177822853279},{"$f":"IF(OR(R222=\"\",S222=\"\"), \"\", R222+S222)","v":12.504394861392832},{"$f":"IF(OR(Q222=\"\", K222=\"\"),\"\", (Q222/K222)*100)","v":12.69235970250169}]
[null,null,20180417,"2018-03-13","2018-04-12",30,30,1648,63420,61772,1648,0,null,54.93333333333333,124,76.790000000000006,203.8,7.5242718446601939,4.6595873786407767,12.183859223300971,12.366504854368934]
[null,null,20180516,"2018-04-12","2018-05-13",31,31,2170,65590,63420,2170,0,null,70,159.97,99.27,263.13,7.3718894009216589,4.5746543778801847,11.946543778801843,12.125806451612902]
[null,null,20180615,"2018-05-13","2018-06-12",30,30,3085,68675,65590,3085,0,null,102.83333333333333,256.95999999999998,139.37,402.27,8.3293354943273901,4.5176661264181526,12.847001620745543,13.039546191247972]
[null,null,null,"",null,"",null,null,null,null,"","",null,"",null,null,null,"","","",""]
[null,null,null,"",null,"",null,null,null,null,"","",null,"",null,null,null,"","","",""]
[null,null,null,"",null,"",null,null,null,null,"","",null,"",null,null,null,"","","",""]
[null,null,null,"",null,"",null,null,null,null,"","",null,"",null,null,null,"","","",""]
[null,null,null,"",null,"",null,null,null,null,"","",null,"",null,null,null,"","","",""]
[null,null,null,"",null,"",null,null,null,null,"","",null,"",null,null,null,"","","",""]
[null,null,null,"",null,"",null,null,null,null,"","",null,"",null,null,null,"","","",""]
[null,null,null,"",null,"",null,null,null,null,"","",null,"",null,null,null,"","","",""]
[null,null,null,"",null,"",null,null,null,null,"","",null,"",null,null,null,"","","",""]
[null,null,null,"",null,"",null,null,null,null,"","",null,"",null,null,null,"","","",""]
[null,null,null,"",null,"",null,null,null,null,"","",null,"",null,null,null,"","","",""]
[null,null,null,"",null,"",null,null,null,null,"","",null,"",null,null,null,"","","",""]
[null,null,null,"",null,"",null,null,null,null,"","",null,"",null,null,null,"","","",""]
[null,null,null,{"$f":"IF(OR(C239=\"\", E238=\"\"),\"\",E238)","v":""},null,{"$f":"IF(OR(D239=\"\", E239=\"\"),\"\",DATEDIF(D239, E239, \"d\"))","v":""},null,null,null,null,{"$f":"IF(OR(I239=\"\",J239=\"\"),\"\",IF((I239-J239)<0,I239-J239+100000,I239-J239))","v":""},{"$f":"IF(OR(H239=\"\", K239=\"\"),\"\",K239-H239)","v":""},null,{"$f":"IF(OR(F239=\"\", K239=\"\"),\"\",K239/F239)","v":""},null,null,null,{"$f":"IF(OR(O239=\"\",$K239=\"\"), \"\", (O239/$K239)*100)","v":""},{"$f":"IF(OR(P239=\"\",$K239=\"\"), \"\", (P239/$K239)*100)","v":""},{"$f":"IF(OR(R239=\"\",S239=\"\"), \"\", R239+S239)","v":""},{"$f":"IF(OR(Q239=\"\", K239=\"\"),\"\", (Q239/K239)*100)","v":""}]
[null,null,null,"",null,"",null,null,null,null,"","",null,"",null,null,null,"","","",""]
[null,null,null,"",null,"",null,null,null,null,"","",null,"",null,null,null,"","","",""]
[null,null,null,"",null,"",null,null,null,null,"","",null,"",null,null,null,"","","",""]
[null,null,null,"",null,"",null,null,null,null,"","",null,"",null,null,null,"","","",""]
[null,null,null,"",null,"",null,null,null,null,"","",null,"",null,null,null,"","","",""]
[null,null,null,"",null,"",null,null,null,null,"","",null,"",null,null,null,"","","",""]
[null,null,null,"",null,"",null,null,null,null,"","",null,"",null,null,null,"","","",""]
[null,null,null,"",null,"",null,null,null,null,"","",null,"",null,null,null,"","","",""]
[null,null,null,"",null,"",null,null,null,null,"","",null,"",null,null,null,"","","",""]
[null,null,null,"",null,"",null,null,null,null,"","",null,"",null,null,null,"","","",""]
[null,null,null,"",null,"",null,null,null,null,"","",null,"",null,null,null,"","","",""]
[null,null,null,"",null,"",null,null,null,null,"","",null,"",null,null,null,"","","",""]
[null,null,null,"",null,"",null,null,null,null,"","",null,"",null,null,null,"","","",""]
[null,null,null,"",null,"",null,null,null,null,"","",null,"",null,null,null,"","","",""]
[null,null,null,"",null,"",null,null,null,null,"","",null,"",null,null,null,"","","",""]
[null,null,null,"",null,"",null,null,null,null,"","",null,"",null,null,null,"","","",""]
[null,null,null,"",null,"",null,null,null,null,"","",null,"",null,null,null,"","","",""]
[null,null,null,"",null,"",null,null,null,null,"","",null,"",null,null,null,"","","",""]
[null,null,null,"",null,"",null,null,null,null,"","",null,"",null,null,null,"","","",""]
[null,null,null,"",null,"",null,null,null,null,"","",null,"",null,null,null,"","","",""]
[null,null,null,"",null,"",null,null,null,null,"","",null,"",null,null,null,"","","",""]
[null,null,null,"",null,"",null,null,null,null,"","",null,"",null,null,null,"","","",""]
[null,null,null,"",null,"",null,null,null,null,"","",null,"",null,null,null,"","","",""]
[null,null,null,"",null,"",null,null,null,null,"","",null,"",null,null,null,"","","",""]
[null,null,null,"",null,"",null,null,null,null,"","",null,"",null,null,null,"","","",""]
[null,null,null,"",null,"",null,null,null,null,"","",null,"",null,null,null,"","","",""]
[null,null,null,"",null,"",null,null,null,null,"","",null,"",null,null,null,"","","",""]
[null,null,null,"",null,"",null,null,null,null,"","",null,"",null,null,null,"","","",""]
[null,null,null,"",null,"",null,null,null,null,"","",null,"",null,null,null,"","","",""]
[null,null,null,"",null,"",null,null,null,null,"","",null,"",null,null,null,"","","",""]
[null,null,null,"",null,"",null,null,null,null,"","",null,"",null,null,null,null,null,null,""]
["End of Formulas"]

{"sheet":"Crude Oil-M-2018-June","index":4,"n_rows":596,"n_cols":21,"rows_kept":596,"cut":false,"hidden":false,"merged":[[595,0,595,4],[2,14,2,19],[3,14,3,19],[4,14,4,19],[0,0,0,1],[0,2,0,3],[37,2,37,3],[592,0,592,4],[593,0,593,4],[594,0,594,4]]}
["EIA Short-Term Energy Outlook,",null,"2018-06-12",null,null,null,null,null,null,null,null,null,"The hickie here is in what YEAR are we going to represent the prices?  If we want to add prices moving forward, we must either continually redownload the entire series, which means we're going to want to manipulate it LESS; OR, we'll have to run our own Real prices conversion"]
["Monthly Average Imported Crude Oil Price"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Sources:",null,"https://www.eia.gov/outlooks/steo/realprices/"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"https://www.eia.gov/petroleum/data.cfm#prices"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"https://www.eia.gov/dnav/pet/pet_pri_spt_s1_d.htm",null,null,null,null,null,"WTI, West Texas Intermediate, (Texas Light Sweet), low sulfer, Benchmark in Oil Pricing, underlying commodity in NY Mercantile Exchange's Oil Futures Contracts"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Consumer Price","Imported Crude Oil Price ($/barrel)"]
["Month","Index (1982-84=1)","Nominal","Real",null,{"$f":"A593","v":"EIA Short-Term Energy Outlook, June 2018"}]
["1974-01-01",0.46800000000000003,9.59,{"$f":"C40*$B$592/B40","v":51.592232820512812},null,{"$f":"A594","v":"Forecast / estimated values shown in blue"}]
["1974-02-01",0.47299999999999998,12.45,66.270428752642701,null,{"$f":"A595","v":"Real Price (Jun 2018 $)"}]
["1974-03-01",0.47799999999999998,12.73,67.052052552301262,null,{"$f":"A596","v":"See Notes and Sources for more information"}]
["1974-04-01",0.48099999999999998,12.72,66.581504532224528]
["1974-05-01",0.48599999999999999,13.02,67.450672592592596]
["1974-06-01",0.49,13.06,67.105584979591839]
["1974-07-01",0.49299999999999999,12.75,65.114068965517248]
["1974-08-01",0.499,12.68,63.977943727454907]
["1974-09-01",0.50600000000000001,12.53,62.346506561264817]
["1974-10-01",0.51,12.44,61.41320658823529]
["1974-11-01",0.51500000000000001,12.53,61.256955961165048]
["1974-12-01",0.51900000000000002,12.82,62.191672601156071]
["1975-01-01",0.52300000000000002,12.77,61.475317170172083]
["1975-02-01",0.52600000000000002,13.05,62.464941444866916]
["1975-03-01",0.52800000000000002,13.28,63.325076363636356]
["1975-04-01",0.53,13.26,62.991104603773579]
["1975-05-01",0.53100000000000003,13.27,62.919892429378521]
["1975-06-01",0.53500000000000003,14.15,66.590799252336453]
["1975-07-01",0.54,14.03,65.414719111111111]
["1975-08-01",0.54200000000000004,14.25,66.195298892988916]
["1975-09-01",0.54600000000000004,14.04,64.741988571428564]
["1975-10-01",0.54900000000000004,14.66,67.231561092896172]
["1975-11-01",0.55300000000000005,15.04,68.475352188065088]
["1975-12-01",0.55600000000000005,14.81,67.064368057553949]
["1976-01-01",0.55800000000000005,13.27,59.875381505376332]
["1976-02-01",0.55900000000000005,13.26,59.72322976744185]
["1976-03-01",0.56000000000000005,13.51,60.740573999999995]
["1976-04-01",0.56100000000000005,13.39,60.093747165775397]
["1976-05-01",0.56399999999999995,13.41,59.863381276595753]
["1976-06-01",0.56699999999999995,13.48,59.857476402116411]
["1976-07-01",0.56999999999999995,13.51,59.674949894736848]
["1976-08-01",0.57299999999999995,13.58,59.670093403141358]
["1976-09-01",0.57599999999999996,13.47,58.878492500000007]
["1976-10-01",0.57899999999999996,13.49,58.660391295336794]
["1976-11-01",0.58099999999999996,13.58,58.848474216867466]
["1976-12-01",0.58399999999999996,13.71,59.106627123287673]
["1977-01-01",0.58699999999999997,14.11,60.520217785349239]
["1977-02-01",0.59299999999999997,14.5,61.563723440134915]
["1977-03-01",0.59599999999999997,14.54,61.422815033557043]
["1977-04-01",0.6,14.36,60.258006399999999]
["1977-05-01",0.60199999999999998,14.62,61.145211428571429]
["1977-06-01",0.60499999999999998,14.63,60.883627636363634]
["1977-07-01",0.60799999999999998,14.44,59.796420000000005]
["1977-08-01",0.61099999999999999,14.68,60.491787103109658]
["1977-09-01",0.61299999999999999,14.5,59.555119086460039]
["1977-10-01",0.61599999999999999,14.56,59.510312727272733]
["1977-11-01",0.62,14.61,59.329419096774188]
["1977-12-01",0.623,14.76,59.649922054574638]
["1978-01-01",0.627,14.52,58.30565052631578]
["1978-02-01",0.63,14.41,57.588398476190477]
["1978-03-01",0.63400000000000001,14.57,57.860457539432169]
["1978-04-01",0.63900000000000001,14.4,56.737892957746482]
["1978-05-01",0.64500000000000002,14.51,56.639481302325571]
["1978-06-01",0.65,14.54,56.319996553846146]
["1978-07-01",0.65500000000000003,14.49,55.697878717557252]
["1978-08-01",0.65900000000000003,14.46,55.245187010622153]
["1978-09-01",0.66500000000000004,14.53,55.011759879699241]
["1978-10-01",0.67100000000000004,14.63,54.895074098360652]
["1978-11-01",0.67500000000000004,14.74,54.980068977777776]
["1978-12-01",0.67900000000000005,14.94,55.397784035346092]
["1979-01-01",0.68500000000000005,15.5,56.970849635036494]
["1979-02-01",0.69199999999999995,15.88,57.777131098265905]
["1979-03-01",0.69899999999999995,16.41,59.10755227467812]
["1979-04-01",0.70599999999999996,17.579999999999998,62.69396532577904]
["1979-05-01",0.71399999999999997,19,{"$f":"C104*$B$592/B104","v":66.998789915966384}]
["1979-06-01",0.72199999999999998,21.03,73.335396565096957]
["1979-07-01",0.73,23.09,79.636587616438348]
["1979-08-01",0.73699999999999999,23.98,81.920625671641801]
["1979-09-01",0.74399999999999999,25.06,84.804656774193546]
["1979-10-01",0.752,25.05,83.868998936170215]
["1979-11-01",0.76,27.02,89.512424842105276]
["1979-12-01",0.76900000000000002,28.91,94.652768582574765]
["1980-01-01",0.78,30.75,99.257215384615378]
["1980-02-01",0.79,32.4,103.25937417721518]
["1980-03-01",0.80100000000000005,33.42,105.04744629213482]
["1980-04-01",0.80900000000000005,33.54,104.38211836835598]
["1980-05-01",0.81699999999999995,34.33,105.79455510403918]
["1980-06-01",0.82499999999999996,34.479999999999997,105.22644014545455]
["1980-07-01",0.82599999999999996,34.51,105.19049084745762]
["1980-08-01",0.83199999999999996,34.44,104.22007615384615]
["1980-09-01",0.83899999999999997,34.46,103.41055809296782]
["1980-10-01",0.84699999999999998,34.630000000000003,102.93916731995279]
["1980-11-01",0.85599999999999998,35.090000000000003,103.20985626168225]
["1980-12-01",0.86399999999999999,35.630000000000003,103.82779944444445]
["1981-01-01",0.872,38.85,112.17242477064219]
["1981-02-01",0.88,39,111.58183636363636]
["1981-03-01",0.88600000000000001,38.31,108.86543187358916]
["1981-04-01",0.89100000000000001,38.409999999999997,108.53708983164982]
["1981-05-01",0.89700000000000002,37.840000000000003,106.21118501672242]
["1981-06-01",0.90500000000000003,37.03,103.01885118232045]
["1981-07-01",0.91500000000000004,36.58,100.65472734426228]
["1981-08-01",0.92200000000000004,35.82,97.815173622559641]
["1981-09-01",0.93100000000000005,35.44,95.841941310418889]
["1981-10-01",0.93400000000000005,35.43,95.507141241970018]
["1981-11-01",0.93799999999999994,36.21,97.193507718550109]
["1981-12-01",0.94099999999999995,35.950000000000003,96.18798809776834]
["1982-01-01",0.94399999999999995,35.54,94.78879423728813]
["1982-02-01",0.94699999999999995,35.479999999999997,94.328993790918688]
["1982-03-01",0.94699999999999995,34.07,90.580293643083422]
["1982-04-01",0.95,32.82,86.981429557894742]
["1982-05-01",0.95899999999999996,32.78,86.060112950990614]
["1982-06-01",0.97,33.79,87.705742020618558]
["1982-07-01",0.97499999999999998,33.44,86.352163446153838]
["1982-08-01",0.97699999999999998,32.950000000000003,84.912655885363378]
["1982-09-01",0.97699999999999998,33.03,85.118817113613105]
["1982-10-01",0.98099999999999998,33.28,85.41337443425077]
["1982-11-01",0.98,33.090000000000003,85.012396897959192]
["1982-12-01",0.97699999999999998,32.85,84.65495435005117]
["1983-01-01",0.97899999999999998,31.4,80.752974055158333]
["1983-02-01",0.98,30.76,79.02633208163266]
["1983-03-01",0.98099999999999998,28.43,72.965812354740066]
["1983-04-01",0.98799999999999999,27.95,71.225652631578953]
["1983-05-01",0.99199999999999999,28.53,72.410520483870968]
["1983-06-01",0.99399999999999999,29.23,74.037884426559359]
["1983-07-01",0.998,28.76,72.555428296593192]
["1983-08-01",1.0009999999999999,29.5,74.19924875124876]
["1983-09-01",1.004,29.54,74.077846374501988]
["1983-10-01",1.008,29.67,74.108595714285713]
["1983-11-01",1.0109999999999999,29.09,72.444285816023751]
["1983-12-01",1.014,29.3,72.751379881656803]
["1984-01-01",1.0209999999999999,28.8,71.019615279138108]
["1984-02-01",1.026,28.91,70.943449356725139]
["1984-03-01",1.0289999999999999,28.95,70.834488629737606]
["1984-04-01",1.0329999999999999,29.11,70.950172158760893]
["1984-05-01",1.0349999999999999,29.26,71.177960811594204]
["1984-06-01",1.0369999999999999,29.19,70.870730337512057]
["1984-07-01",1.0409999999999999,29,70.138881844380407]
["1984-08-01",1.044,28.92,69.744402758620694]
["1984-09-01",1.0469999999999999,28.7,{"$f":"C168*$B$592/B168","v":69.015523209169061}]
["1984-10-01",1.0509999999999999,28.79,68.968458382492855]
["1984-11-01",1.0529999999999999,28.74,68.71791316239316]
["1984-12-01",1.0549999999999999,28.02,66.869371450236969]
["1985-01-01",1.0569999999999999,27.49,65.480399772942292]
["1985-02-01",1.0629999999999999,26.99,63.926538626528696]
["1985-03-01",1.0680000000000001,27.2,64.12231910112358]
["1985-04-01",1.07,27.59,64.920146691588783]
["1985-05-01",1.0720000000000001,27.6,64.822513432835819]
["1985-06-01",1.075,27.25,63.821882790697678]
["1985-07-01",1.077,26.57,62.113702952646243]
["1985-08-01",1.079,26.61,62.091907173308627]
["1985-09-01",1.081,26.56,61.860574135060126]
["1985-10-01",1.085,26.79,62.166232036866354]
["1985-11-01",1.0900000000000001,27.12,62.643318605504589]
["1985-12-01",1.095,26.21,60.26490432876713]
["1986-01-01",1.099,24.93,57.113155523202913]
["1986-02-01",1.097,18.11,41.564579617137646]
["1986-03-01",1.091,14.22,32.816058368469299]
["1986-04-01",1.087,13.15,30.458448574057041]
["1986-05-01",1.0900000000000001,13.17,30.420815119266056]
["1986-06-01",1.0940000000000001,12.25,28.192288848263253]
["1986-07-01",1.095,10.91,25.085467616438358]
["1986-08-01",1.0960000000000001,11.87,27.267902627737222]
["1986-09-01",1.1000000000000001,12.85,29.411827636363636]
["1986-10-01",1.1020000000000001,12.78,29.198519346642467]
["1986-11-01",1.1040000000000001,13.46,30.696407826086954]
["1986-12-01",1.1080000000000001,14.17,32.198946281588448]
["1987-01-01",1.1140000000000001,16.45,37.178535727109505]
["1987-02-01",1.1180000000000001,16.98,38.239081502683362]
["1987-03-01",1.1220000000000001,17.260000000000002,38.731070802139037]
["1987-04-01",1.127,17.89,39.966672724046141]
["1987-05-01",1.1299999999999999,18.25,40.6626796460177]
["1987-06-01",1.135,18.71,41.503956158590313]
["1987-07-01",1.1379999999999999,19.260000000000002,42.611379121265387]
["1987-08-01",1.143,19.32,42.557142677165352]
["1987-09-01",1.147,18.57,40.762429014821272]
["1987-10-01",1.1499999999999999,18.53,40.568518539130444]
["1987-11-01",1.1539999999999999,18.14,39.577015736568463]
["1987-12-01",1.1559999999999999,17.2,37.461242906574398]
["1988-01-01",1.1599999999999999,15.45,33.533745517241378]
["1988-02-01",1.1619999999999999,15.43,33.43269356282272]
["1988-03-01",1.165,14.73,31.833793236051502]
["1988-04-01",1.1719999999999999,15.62,33.555598361774742]
["1988-05-01",1.175,15.93,34.134180357446809]
["1988-06-01",1.18,15.5,33.072061016949156]
["1988-07-01",1.1850000000000001,14.81,31.466488303797469]
["1988-08-01",1.19,14.32,30.297558050420168]
["1988-09-01",1.1950000000000001,13.84,29.159478627615062]
["1988-10-01",1.1990000000000001,13.05,27.403302085070891]
["1988-11-01",1.2030000000000001,12.66,26.495959301745636]
["1988-12-01",1.2070000000000001,14.11,29.432781971830984]
["1989-01-01",1.212,16.04,33.320638415841586]
["1989-02-01",1.216,16.61,34.39122355263158]
["1989-03-01",1.222,17.77,36.612365695581012]
["1989-04-01",1.2310000000000001,19.59,40.067103948009745]
["1989-05-01",1.2370000000000001,19.05,38.77366467259499]
["1989-06-01",1.2410000000000001,18.27,37.066223110394837]
["1989-07-01",1.2450000000000001,17.989999999999998,36.380895228915655]
["1989-08-01",1.2450000000000001,17.23,34.843959132530117]
["1989-09-01",1.248,17.62,35.546994615384612]
["1989-10-01",1.254,18.29,36.72211942583732]
["1989-11-01",1.2589999999999999,18.32,36.636274884829234]
["1989-12-01",1.2629999999999999,20.05,39.96893681710214]
["1990-01-01",1.2749999999999999,20.51,{"$f":"C232*$B$592/B232","v":40.501121129411771}]
["1990-02-01",1.28,19.78,38.90701275]
["1990-03-01",1.286,18.940000000000001,37.080926407465007]
["1990-04-01",1.2889999999999999,16.66,32.541206392552368]
["1990-05-01",1.2909999999999999,16.07,31.340159628195199]
["1990-06-01",1.2989999999999999,15.15,29.363988914549658]
["1990-07-01",1.3049999999999999,16.54,31.910717057471263]
["1990-08-01",1.3160000000000001,24.26,46.4137305775076]
["1990-09-01",1.325,29.88,56.777502430188676]
["1990-10-01",1.3340000000000001,32.880000000000003,62.056538770614694]
["1990-11-01",1.337,30.19,56.851676409872844]
["1990-12-01",1.3420000000000001,25.56,47.953455022354696]
["1991-01-01",1.347,22.3,41.682027616926504]
["1991-02-01",1.3480000000000001,18.3,34.180055786350145]
["1991-03-01",1.3480000000000001,17.579999999999998,32.835266706231451]
["1991-04-01",1.351,18.32,34.141428630643965]
["1991-05-01",1.3560000000000001,18.36,34.089808141592918]
["1991-06-01",1.36,17.78,32.915800235294114]
["1991-07-01",1.3620000000000001,18.14,33.532948722466962]
["1991-08-01",1.3660000000000001,18.71,34.485351566617858]
["1991-09-01",1.37,19,34.917617518248171]
["1991-10-01",1.3720000000000001,19.86,36.444894927113701]
["1991-11-01",1.3779999999999999,19.350000000000001,35.354387808418004]
["1991-12-01",1.3819999999999999,17.170000000000002,31.280509753979743]
["1992-01-01",1.383,16.100000000000001,29.309962689804774]
["1992-02-01",1.3859999999999999,16,29.064865800865803]
["1992-03-01",1.391,16.36,29.611999884974839]
["1992-04-01",1.3939999999999999,17.37,31.372462898134867]
["1992-05-01",1.397,18.79,33.864287587687897]
["1992-06-01",1.401,19.829999999999998,35.63659066381156]
["1992-07-01",1.405,19.739999999999998,35.373855202846968]
["1992-08-01",1.4079999999999999,19.25,34.422281250000005]
["1992-09-01",1.411,19.260000000000002,34.366937944720064]
["1992-10-01",1.417,19.34,34.363563133380381]
["1992-11-01",1.421,18.399999999999999,32.601329767769172]
["1992-12-01",1.423,16.940000000000001,29.972300323260718]
["1993-01-01",1.4279999999999999,16.8,29.620517647058826]
["1993-02-01",1.431,17.41,30.631672285115304]
["1993-03-01",1.4330000000000001,17.82,31.309279888346129]
["1993-04-01",1.4379999999999999,18.350000000000001,32.128374408901252]
["1993-05-01",1.4419999999999999,17.89,31.236088876560334]
["1993-06-01",1.4430000000000001,16.8,29.312612058212061]
["1993-07-01",1.4450000000000001,15.81,27.547081411764708]
["1993-08-01",1.448,15.64,27.194417237569063]
["1993-09-01",1.45,15.32,26.601267641379312]
["1993-10-01",1.456,15.59,26.958536373626373]
["1993-11-01",1.46,14.05,24.22897479452055]
["1993-12-01",1.4630000000000001,12.56,21.615081777170197]
["1994-01-01",1.4630000000000001,12.93,22.251831797676004]
["1994-02-01",1.4670000000000001,12.9,22.139671165644174]
["1994-03-01",1.4710000000000001,13.18,22.558712386131884]
["1994-04-01",1.472,14.54,24.869563695652172]
["1994-05-01",1.4750000000000001,15.74,26.867315633898304]
["1994-06-01",1.4790000000000001,17.04,29.007679350912777]
["1994-07-01",1.484,17.52,29.724309218328841]
["1994-08-01",1.49,16.66,28.151419489932884]
["1994-09-01",1.4930000000000001,15.91,26.830078392498322]
["1994-10-01",1.494,16.27,27.418805140562249]
["1994-11-01",1.498,16.46,27.664930734312417]
["1994-12-01",1.5009999999999999,15.78,26.469020866089274]
["1995-01-01",1.5049999999999999,16.559999999999999,27.703548598006645]
["1995-02-01",1.5089999999999999,17.21,28.714628389662032]
["1995-03-01",1.512,17.21,28.657654920634922]
["1995-04-01",1.518,18.7,31.015686956521733]
["1995-05-01",1.5209999999999999,18.559999999999999,{"$f":"C296*$B$592/B296","v":30.722767021696253}]
["1995-06-01",1.524,17.43,28.795457952755907]
["1995-07-01",1.526,16.5,27.22331323722149]
["1995-08-01",1.5289999999999999,16.54,27.235765703073906]
["1995-09-01",1.5309999999999999,16.71,27.479753259307643]
["1995-10-01",1.5349999999999999,16.29,26.719250657980457]
["1995-11-01",1.5369999999999999,16.52,27.061243253090435]
["1995-12-01",1.5389999999999999,17.53,28.678396569200785]
["1996-01-01",1.5469999999999999,17.48,28.448716948933424]
["1996-02-01",1.55,17.77,28.864716696774188]
["1996-03-01",1.5549999999999999,19.899999999999999,32.220646688102896]
["1996-04-01",1.5609999999999999,21.33,34.403254016655985]
["1996-05-01",1.5640000000000001,20.12,32.389392122762146]
["1996-06-01",1.5669999999999999,19.32,31.04200005105297]
["1996-07-01",1.57,19.600000000000001,31.431708535031845]
["1996-08-01",1.5720000000000001,20.53,32.881224122137404]
["1996-09-01",1.577,22.04,35.187747469879518]
["1996-10-01",1.5820000000000001,23.22,36.954497901390639]
["1996-11-01",1.587,22.66,35.949640226843101]
["1996-12-01",1.591,23.22,36.74545297297297]
["1997-01-01",1.5940000000000001,23.02,36.360393274780421]
["1997-02-01",1.597,20.88,32.918280976831561]
["1997-03-01",1.5980000000000001,19.16,30.187719048811012]
["1997-04-01",1.599,17.829999999999998,28.074656360225138]
["1997-05-01",1.599,18.55,29.208349718574109]
["1997-06-01",1.6020000000000001,17.350000000000001,27.267701872659174]
["1997-07-01",1.6040000000000001,17.489999999999998,27.453455461346628]
["1997-08-01",1.6080000000000001,17.96,28.121071044776116]
["1997-09-01",1.6120000000000001,17.850000000000001,27.879485359801489]
["1997-10-01",1.615,18.73,29.199594501547988]
["1997-11-01",1.617,17.88,27.839989313543597]
["1997-12-01",1.6180000000000001,15.95,24.819540667490728]
["1998-01-01",1.62,14.33,22.271155259259256]
["1998-02-01",1.62,13.32,20.701450666666663]
["1998-03-01",1.62,12.34,19.178370962962962]
["1998-04-01",1.6220000000000001,12.81,19.884279062885327]
["1998-05-01",1.6259999999999999,12.61,19.525677638376383]
["1998-06-01",1.6279999999999999,11.61,17.955164520884519]
["1998-07-01",1.6319999999999999,11.55,17.818592647058825]
["1998-08-01",1.6339999999999999,11.34,17.473204993880049]
["1998-09-01",1.635,12.77,19.66458157798165]
["1998-10-01",1.639,12.11,18.60273327638804]
["1998-11-01",1.641,10.99,16.861673711151738]
["1998-12-01",1.6439999999999999,9.39,14.380545109489052]
["1999-01-01",1.647,10.16,15.53143839708561]
["1999-02-01",1.647,10.33,15.791314826958105]
["1999-03-01",1.6479999999999999,12.1,18.485863106796117]
["1999-04-01",1.659,14.82,22.491239349005426]
["1999-05-01",1.66,15.57,23.615225349397591]
["1999-06-01",1.66,15.91,24.130907855421686]
["1999-07-01",1.667,18.05,27.261715176964607]
["1999-08-01",1.671,19.559999999999999,29.471617378815079]
["1999-09-01",1.6779999999999999,21.64,32.469594851013113]
["1999-10-01",1.681,21.62,32.38169261154075]
["1999-11-01",1.6839999999999999,23.14,34.596553539192399]
["1999-12-01",1.6879999999999999,24.35,36.319352132701425]
["2000-01-01",1.6930000000000001,25.29,37.610009308919075]
["2000-02-01",1.7,27.39,40.565298917647063]
["2000-03-01",1.71,27.7,40.784508070175434]
["2000-04-01",1.7090000000000001,24.29,35.784670427150374]
["2000-05-01",1.712,26.35,38.751492056074767]
["2000-06-01",1.722,28.91,42.269441951219513]
["2000-07-01",1.7270000000000001,28,40.820400694846555]
["2000-08-01",1.7270000000000001,28.8,41.986697857556457]
["2000-09-01",1.736,30.56,{"$f":"C360*$B$592/B360","v":44.321576405529953}]
["2000-10-01",1.7390000000000001,29.71,43.014476273720526]
["2000-11-01",1.742,30,43.359540757749713]
["2000-12-01",1.746,25.19,36.324153127147767]
["2001-01-01",1.756,24.49,35.11363927107061]
["2001-02-01",1.76,24.97,35.720492999999998]
["2001-03-01",1.7609999999999999,23.01,32.897949710391828]
["2001-04-01",1.764,22.99,32.813454965986395]
["2001-05-01",1.7729999999999999,24.63,34.9757669035533]
["2001-06-01",1.7769999999999999,23.95,33.933578390545861]
["2001-07-01",1.774,22.76,32.302059436302144]
["2001-08-01",1.774,23.77,33.735498804960542]
["2001-09-01",1.7809999999999999,22.51,31.821683009545204]
["2001-10-01",1.776,18.760000000000002,26.595088648648648]
["2001-11-01",1.7749999999999999,16.059999999999999,22.78026402253521]
["2001-12-01",1.774,15.95,22.63698804960541]
["2002-01-01",1.7769999999999999,17.04,24.143138863252673]
["2002-02-01",1.78,18.239999999999998,25.799803685393258]
["2002-03-01",1.7849999999999999,22.29,31.440063731092437]
["2002-04-01",1.7929999999999999,23.98,33.67289521472393]
["2002-05-01",1.7949999999999999,24.44,34.280592401114212]
["2002-06-01",1.796,23.45,32.873661915367478]
["2002-07-01",1.8,24.99,34.954679199999994]
["2002-08-01",1.8049999999999999,25.68,35.82031352908588]
["2002-09-01",1.8080000000000001,27.14,37.794011150442479]
["2002-10-01",1.8120000000000001,25.99,36.112674701986748]
["2002-11-01",1.8149999999999999,23.68,32.848582876033056]
["2002-12-01",1.8180000000000001,26.68,36.949070363036299]
["2003-01-01",1.8260000000000001,30.3,41.778555969331876]
["2003-02-01",1.8360000000000001,32.229999999999997,44.197652026143786]
["2003-03-01",1.839,29.23,40.018301859706362]
["2003-04-01",1.8320000000000001,24.48,33.64321676855895]
["2003-05-01",1.829,25.15,34.620700710770912]
["2003-06-01",1.831,27.22,37.429269077007099]
["2003-07-01",1.837,27.95,38.307536635819275]
["2003-08-01",1.845,28.5,38.891980487804872]
["2003-09-01",1.851,25.66,34.902923306320908]
["2003-10-01",1.849,27.32,37.201063320713899]
["2003-11-01",1.85,27.47,37.385096043243237]
["2003-12-01",1.855,28.63,38.858765886792447]
["2004-01-01",1.863,30.11,40.69204070853462]
["2004-02-01",1.867,30.69,41.387018403856459]
["2004-03-01",1.871,32.159999999999997,43.276668647781932]
["2004-04-01",1.8740000000000001,32.340000000000003,43.449221430096053]
["2004-05-01",1.8819999999999999,35.68,47.732787417640807]
["2004-06-01",1.889,33.450000000000003,44.583661619904717]
["2004-07-01",1.891,35.89,47.785210026441042]
["2004-08-01",1.8919999999999999,39.46,52.510665031712477]
["2004-09-01",1.8979999999999999,40.42,53.618130916754481]
["2004-10-01",1.9079999999999999,45.36,59.855800754716981]
["2004-11-01",1.917,39.89,52.390614585289519]
["2004-12-01",1.917,34.07,44.746759561815331]
["2005-01-01",1.9159999999999999,37.56,49.356192400835077]
["2005-02-01",1.9239999999999999,39.72,51.977542453222455]
["2005-03-01",1.931,45.73,59.625289031589844]
["2005-04-01",1.9370000000000001,45.25,58.816683531233863]
["2005-05-01",1.9359999999999999,43.19,56.168059586776856]
["2005-06-01",1.9370000000000001,49.28,64.054942860092922]
["2005-07-01",1.9490000000000001,52.79,68.194820810672127]
["2005-08-01",1.9610000000000001,58.67,75.326894686384492]
["2005-09-01",1.988,58.79,74.45581979879276]
["2005-10-01",1.9910000000000001,55.31,69.94295361125063]
["2005-11-01",1.9810000000000001,49.97,63.509170964159509]
["2005-12-01",1.9810000000000001,50.85,64.627603432609789]
["2006-01-01",1.9930000000000001,55.85,{"$f":"C424*$B$592/B424","v":70.554943502257899}]
["2006-02-01",1.994,52.8,66.668446940822463]
["2006-03-01",1.9970000000000001,55.31,69.732809534301452]
["2006-04-01",2.0070000000000001,62.41,78.292178893871437]
["2006-05-01",2.0129999999999999,64.39,80.535288703427724]
["2006-06-01",2.0179999999999998,63.79,79.587160436075337]
["2006-07-01",2.0289999999999999,67.989999999999995,84.367380266140955]
["2006-08-01",2.0379999999999998,66.45,82.092290873405318]
["2006-09-01",2.028,57.29,71.125026508875735]
["2006-10-01",2.0190000000000001,52.7,65.71823120356612]
["2006-11-01",2.02,52.7,65.685697425742575]
["2006-12-01",2.0310000000000001,54.97,68.143962422451992]
["2007-01-01",2.03437,49.57,61.348019327850885]
["2007-02-01",2.0422600000000002,53.77,66.288863748983957]
["2007-03-01",2.05288,56.31,69.061106659911928]
["2007-04-01",2.05904,60.45,73.916788794778157]
["2007-05-01",2.0675500000000002,61.55,74.952065584870965]
["2007-06-01",2.0723400000000001,65.239999999999995,79.261906135093653]
["2007-07-01",2.0760299999999998,70.75,85.803378563893602]
["2007-08-01",2.07667,68.28,82.782319925650199]
["2007-09-01",2.0854699999999999,72.34,87.334558137973701]
["2007-10-01",2.0918999999999999,78.61,94.612484267890437]
["2007-11-01",2.1083400000000001,85.53,102.13848066251174]
["2007-12-01",2.1144500000000002,83.21,99.080838156494579]
["2008-01-01",2.12174,84.82,100.6509025988104]
["2008-02-01",2.1268699999999998,87.41,103.47412067498249]
["2008-03-01",2.1344799999999999,96.96,114.36999092987519]
["2008-04-01",2.1394199999999999,104.72,123.23814476820822]
["2008-05-01",2.1520800000000002,116.55,136.35323185011708]
["2008-06-01",2.1746300000000001,126.22,146.13504259575191]
["2008-07-01",2.1901600000000001,127.77,146.88066208861451]
["2008-08-01",2.1869000000000001,111.19,128.01131984087061]
["2008-09-01",2.1887699999999999,96.38,110.86599629929138]
["2008-10-01",2.16995,70.84,82.194052839927181]
["2008-11-01",2.1315300000000001,49.1,57.996476896876885]
["2008-12-01",2.1139800000000002,35.590000000000003,42.387585956347742]
["2009-01-01",2.1193300000000002,36.840000000000003,43.765571647643355]
["2009-02-01",2.1270500000000001,38.56,45.64265468136621]
["2009-03-01",2.1249500000000001,45.96,54.4556409515518]
["2009-04-01",2.1270899999999999,49.58,58.68569149401295]
["2009-05-01",2.13022,56.77,67.097448563998086]
["2009-06-01",2.1478999999999999,66.37,77.79816065924858]
["2009-07-01",2.1472600000000002,63.46,74.409263079459393]
["2009-08-01",2.1544500000000002,68.09,79.571672101928556]
["2009-09-01",2.1586099999999999,67.650000000000006,78.905120239413336]
["2009-10-01",2.1650900000000002,72.06,83.797270616925857]
["2009-11-01",2.1723400000000002,74.400000000000006,86.229666442637892]
["2009-12-01",2.17347,72.67,84.180806029068719]
["2010-01-01",2.1748799999999999,75.069999999999993,86.904584197748846]
["2010-02-01",2.1728100000000001,73.73,85.434651497369757]
["2010-03-01",2.17353,76.77,88.927784240383147]
["2010-04-01",2.1740300000000001,80.03,92.682737735909811]
["2010-05-01",2.1728999999999998,71.150000000000006,82.441661190114615]
["2010-06-01",2.1719900000000001,71.91,83.357184443758939]
["2010-07-01",2.17605,73.27,84.775213290135781]
["2010-08-01",2.17923,73.52,84.94034079927313]
["2010-09-01",2.18275,73.150000000000006,84.376577070209606]
["2010-10-01",2.19035,76.900000000000006,88.394326751432416]
["2010-11-01",2.1959,79.92,91.63354455120907]
["2010-12-01",2.20472,85.59,97.741984905112673]
["2011-01-01",2.2118699999999998,87.61,99.725368959296887]
["2011-02-01",2.2189800000000002,91.42,103.72881075088554]
["2011-03-01",2.2304599999999999,102.43,115.62301853429338]
["2011-04-01",2.2409300000000001,113.02,126.98095294364391]
["2011-05-01",2.2480600000000002,107.98,{"$f":"C488*$B$592/B488","v":120.93360369385159}]
["2011-06-01",2.2480600000000002,105.38,118.0216999190413]
["2011-07-01",2.2539500000000001,105.94,118.33882710796601]
["2011-08-01",2.2610600000000001,99,110.23885080448993]
["2011-09-01",2.2659699999999998,101.05,112.27775795796062]
["2011-10-01",2.2675000000000001,101.99,113.24573784343991]
["2011-11-01",2.27169,107.67,119.33208161324829]
["2011-12-01",2.27223,106.52,118.02946483410571]
["2012-01-01",2.2784200000000001,105.25,116.30540286689897]
["2012-02-01",2.28329,108.08,119.17792813002291]
["2012-03-01",2.2880699999999998,111,122.14206033906306]
["2012-04-01",2.2918699999999999,108.54,119.23710060343737]
["2012-05-01",2.2871299999999999,103.26,113.67182689221863]
["2012-06-01",2.2852399999999999,92.18,101.55854173741052]
["2012-07-01",2.2858999999999998,92.99,102.42137213351415]
["2012-08-01",2.2991799999999998,97.04,106.26478908132466]
["2012-09-01",2.3101500000000001,101.82,110.96971801831047]
["2012-10-01",2.3163800000000001,100.92,109.69302294096823]
["2012-11-01",2.3124899999999999,98.07,106.77458241116717]
["2012-12-01",2.3122099999999999,93.7,102.0290599902258]
["2013-01-01",2.3167900000000001,97.91,106.40252894737976]
["2013-02-01",2.3293699999999999,99.23,107.25463843013347]
["2013-03-01",2.3228200000000001,99.11,107.42701020311517]
["2013-04-01",2.3179699999999999,96.45,104.76253307851267]
["2013-05-01",2.3189299999999999,98.5,106.94492028651145]
["2013-06-01",2.3244500000000001,97.17,105.2503536234378]
["2013-07-01",2.3290000000000002,101.56,109.79050263632459]
["2013-08-01",2.3345600000000002,104.16,112.33303707765059]
["2013-09-01",2.3354400000000002,103.49,111.56840961874421]
["2013-10-01",2.3366899999999999,97.84,105.42094713462205]
["2013-11-01",2.3410000000000002,90.36,97.182122101665954]
["2013-12-01",2.3471899999999999,90.57,97.151093043170761]
["2014-01-01",2.3534700000000002,89.71,95.97182638402019]
["2014-02-01",2.3552200000000001,96.1,102.73146389721553]
["2014-03-01",2.3595600000000001,97.13,103.64155805319635]
["2014-04-01",2.36463,97.33,103.63229068395479]
["2014-05-01",2.3686699999999998,98.46,104.65665299091896]
["2014-06-01",2.37188,100.26,106.42571017083495]
["2014-07-01",2.3748499999999999,98.75,104.69175737414994]
["2014-08-01",2.37439,93.23,98.85876925020743]
["2014-09-01",2.37452,89.38,94.771136364402068]
["2014-10-01",2.3744700000000001,82.75,87.743082035148888]
["2014-11-01",2.3704200000000002,74.34,78.960306173589487]
["2014-12-01",2.3626999999999998,57.36,61.124051229525548]
["2015-01-01",2.34836,44.74,47.967035105350121]
["2015-02-01",2.3527399999999998,47.18,50.488860613582467]
["2015-03-01",2.3595600000000001,47.22,50.385610740985598]
["2015-04-01",2.36165,51.62,55.031840145660873]
["2015-05-01",2.3695200000000001,57.51,61.107505925250685]
["2015-06-01",2.3761800000000002,58.89,62.398447996363906]
["2015-07-01",2.3799299999999999,52.42,55.45547158109693]
["2015-08-01",2.3798900000000001,43.23,45.73407725567148]
["2015-09-01",2.3746700000000001,41.12,43.597482294381955]
["2015-10-01",2.37764,42.03,44.506645379451889]
["2015-11-01",2.3807200000000002,39.049999999999997,41.297549984878515]
["2015-12-01",2.3782700000000001,33.159999999999997,35.10467316158384]
["2016-01-01",2.3799000000000001,27.48,29.071643816967097]
["2016-02-01",2.3753199999999999,26.66,28.258531498913833]
["2016-03-01",2.38022,32.24,34.102757963549593]
["2016-04-01",2.3884300000000001,35.9,37.843692132488705]
["2016-05-01",2.39439,40.880000000000003,42.986052698182]
["2016-06-01",2.4007399999999999,44.13,46.280747902729992]
["2016-07-01",2.4005800000000002,41.48,43.504495213656696]
["2016-08-01",2.4056899999999999,41.21,43.129509720703837]
["2016-09-01",2.4101699999999999,40.86,{"$f":"C552*$B$592/B552","v":42.683719339299714}]
["2016-10-01",2.4166699999999999,44.76,46.632027310307159]
["2016-11-01",2.4208099999999999,41.8,43.473754321900515]
["2016-12-01",2.4278400000000002,46.72,48.450062475286664]
["2017-01-01",2.44028,48.12,49.64751638336584]
["2017-02-01",2.44102,49.38,50.932068856461647]
["2017-03-01",2.4371700000000001,46.53,48.068303942687621]
["2017-04-01",2.4408699999999999,47.47,48.965044299778363]
["2017-05-01",2.4391099999999999,46.94,48.453289667132687]
["2017-06-01",2.4403199999999998,43.93,45.323766522423291]
["2017-07-01",2.4423599999999999,45.02,46.409552596668803]
["2017-08-01",2.45262,47.61,48.874180199133981]
["2017-09-01",2.4639199999999999,50.37,51.470325854735542]
["2017-10-01",2.46583,51.8,52.89056390748754]
["2017-11-01",2.47411,56.36,57.353978537736801,"Forecast"]
["2017-12-01",2.4790999999999999,57.56,58.45724038562382,"Values"]
["2018-01-01",2.4924499999999998,59.39,59.992704431382776,{"$f":"IF($A568>DATE(YEAR($C$1),MONTH($C$1)-2,1),1,0)","v":0}]
["2018-02-01",2.4961899999999999,57.94,58.440297958088124,0]
["2018-03-01",2.4946199999999998,59.225000000000001,59.773988984294199,0]
["2018-04-01",2.50013,62.753999999999998,63.196116592337191,0]
["2018-05-01",2.5121991852000001,66.48,66.626731712228718,1]
["2018-06-01",2.517744,62,62.000000000000007,1]
["2018-07-01",2.5236900000000002,62,61.853923421656383,1]
["2018-08-01",2.528438,61.5,61.239886443725332,1]
["2018-09-01",2.5325700000000002,60.5,60.145824992004165,1]
["2018-10-01",2.5354009999999998,59.5,59.085631030357725,1]
["2018-11-01",2.5388130000000002,59.5,59.006223774653741,1]
["2018-12-01",2.5421230000000001,59.5,58.929394053710226,1]
["2019-01-01",2.5443669999999998,58.5,57.887884884531211,1]
["2019-02-01",2.5481929999999999,59,58.294994138983981,1]
["2019-03-01",2.5526369999999998,59.5,58.686671077791324,1]
["2019-04-01",2.558538,58.5,57.567260677777703,1]
["2019-05-01",2.56359,58.5,57.453814377494062,1]
["2019-06-01",2.568632,58.5,57.341037563964008,1]
["2019-07-01",2.5742129999999999,57.5,56.238656241732905,1]
["2019-08-01",2.5788220000000002,57.5,56.138143695066965,1]
["2019-09-01",2.583008,58.5,57.021900048315764,1]
["2019-10-01",2.5861540000000001,58.5,56.952534149165132,1]
["2019-11-01",2.58996,58.5,56.868841217624983,1]
["2019-12-01",2.5938080000000001,58.5,56.784474409825243,1]
["Base CPI (6/2018)",2.517744]
[{"$f":"A1&\" \"&TEXT(C1,\"Mmmm yyyy\")","v":"EIA Short-Term Energy Outlook, June 2018"}]
["Forecast / estimated values shown in blue"]
[{"$f":"\"Real Price (\"&TEXT($C$1,\"mmm yyyy\")&\" $)\"","v":"Real Price (Jun 2018 $)"}]
["See Notes and Sources for more information"]

{"sheet":"Natural Gas-M-2018-June","index":5,"n_rows":513,"n_cols":15,"rows_kept":513,"cut":false,"hidden":false,"merged":[[0,0,0,1],[0,2,0,3],[37,2,37,3],[510,0,510,4]]}
["EIA Short-Term Energy Outlook,",null,"2018-06-12"]
["Monthly Average Residential Natural Gas Price"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Source:",null,"https://www.eia.gov/dnav/ng/ng_pri_sum_dcu_nus_m.htm"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Consumer Price","Residential Natural Gas Price ($/mcf)"]
["Month","Index (1982-84=1)","Nominal","Real",null,{"$f":"A509","v":"EIA Short-Term Energy Outlook, June 2018"}]
["1981-01-01",0.872,3.94,{"$f":"C40*$B$508/B40","v":11.37604513761468},null,{"$f":"A510","v":"Forecast / estimated values shown in blue"}]
["1981-02-01",0.88,3.99,11.415680181818182,null,{"$f":"A511","v":"Values shown for recent months are estimates if official historical data has not yet been released"}]
["1981-03-01",0.88600000000000001,4.0599999999999996,11.537291918735891,null,{"$f":"A512","v":"Real Price (Jun 2018 $)"}]
["1981-04-01",0.89100000000000001,4.1100000000000003,11.61383595959596,null,{"$f":"A513","v":"See Notes and Sources for more information"}]
["1981-05-01",0.89700000000000002,4.29,12.041384347826085]
["1981-06-01",0.90500000000000003,4.3,11.962761546961325]
["1981-07-01",0.91500000000000004,4.32,11.887053639344261]
["1981-08-01",0.92200000000000004,4.3,11.742190021691973]
["1981-09-01",0.93100000000000005,4.47,12.08841641245972]
["1981-10-01",0.93400000000000005,4.5,12.130458244111349]
["1981-11-01",0.93799999999999994,4.53,12.15925407249467]
["1981-12-01",0.94099999999999995,4.55,12.174001275239107]
["1982-01-01",0.94399999999999995,4.6500000000000004,12.402022881355935]
["1982-02-01",0.94699999999999995,4.6900000000000004,12.469080633579727]
["1982-03-01",0.94699999999999995,4.78,12.708359366420277]
["1982-04-01",0.95,4.8600000000000003,12.88024825263158]
["1982-05-01",0.95899999999999996,5.17,13.573239290928051]
["1982-06-01",0.97,5.2,13.497184329896909]
["1982-07-01",0.97499999999999998,5.23,13.505437046153848]
["1982-08-01",0.97699999999999998,5.23,13.477790296827024]
["1982-09-01",0.97699999999999998,5.41,13.941653060388946]
["1982-10-01",0.98099999999999998,5.66,14.526433272171255]
["1982-11-01",0.98,5.68,14.59263869387755]
["1982-12-01",0.97699999999999998,5.74,14.792068126919141]
["1983-01-01",0.97899999999999998,5.86,15.070459489274771]
["1983-02-01",0.98,5.87,15.080772734693877]
["1983-03-01",0.98099999999999998,6,15.399045871559633]
["1983-04-01",0.98799999999999999,6.06,15.442842753036436]
["1983-05-01",0.99199999999999999,6.22,15.786660967741934]
["1983-06-01",0.99399999999999999,6.2,15.704238229376257]
["1983-07-01",0.998,6.21,15.666523286573147]
["1983-08-01",1.0009999999999999,6.18,15.544113806193808]
["1983-09-01",1.004,6.19,15.522744382470121]
["1983-10-01",1.008,6.7,16.735004761904761]
["1983-11-01",1.0109999999999999,6.3,15.689205934718103]
["1983-12-01",1.014,5.94,14.748914556213018]
["1984-01-01",1.0209999999999999,5.78,14.253242233104801]
["1984-02-01",1.026,5.84,14.331018479532162]
["1984-03-01",1.0289999999999999,5.92,14.484980058309038]
["1984-04-01",1.0329999999999999,5.96,14.526383581800582]
["1984-05-01",1.0349999999999999,6.27,15.252420173913045]
["1984-06-01",1.0369999999999999,6.76,16.412680270009641]
["1984-07-01",1.0409999999999999,7.11,17.196118962536026]
["1984-08-01",1.044,7.23,17.436100689655174]
["1984-09-01",1.0469999999999999,7.17,17.241857191977079]
["1984-10-01",1.0509999999999999,6.8,16.289875547098003]
["1984-11-01",1.0529999999999999,6.31,15.08733584045584]
["1984-12-01",1.0549999999999999,6.05,14.43824758293839]
["1985-01-01",1.0569999999999999,5.97,14.220370558183539]
["1985-02-01",1.0629999999999999,5.86,13.879567111947321]
["1985-03-01",1.0680000000000001,5.99,14.121054831460674]
["1985-04-01",1.07,6.11,14.37702414953271]
["1985-05-01",1.0720000000000001,6.59,15.477549402985074]
["1985-06-01",1.075,6.96,16.300928595348836]
["1985-07-01",1.077,7.07,16.527808802228414]
["1985-08-01",1.079,7.21,16.823850083410566]
["1985-09-01",1.081,7.06,16.443360444033299]
["1985-10-01",1.085,6.5,15.083258986175116]
["1985-11-01",1.0900000000000001,6.13,14.159422678899082]
["1985-12-01",1.095,5.7,13.106064657534246]
["1986-01-01",1.099,5.63,12.897997015468608]
["1986-02-01",1.097,5.67,13.013316754785778]
["1986-03-01",1.091,5.71,13.177193620531623]
["1986-04-01",1.087,5.89,13.642605482980679]
["1986-05-01",1.0900000000000001,6.18,{"$f":"C104*$B$508/B104","v":14.274915522935778}]
["1986-06-01",1.0940000000000001,6.67,15.35041360146252]
["1986-07-01",1.095,6.84,15.727277589041096]
["1986-08-01",1.0960000000000001,6.94,15.942649051094891]
["1986-09-01",1.1000000000000001,6.83,15.632901381818179]
["1986-10-01",1.1020000000000001,6.38,14.576412631578947]
["1986-11-01",1.1040000000000001,5.66,12.907999130434781]
["1986-12-01",1.1080000000000001,5.28,11.997913646209387]
["1987-01-01",1.1140000000000001,5.3,11.978494793536804]
["1987-02-01",1.1180000000000001,5.34,12.025718211091233]
["1987-03-01",1.1220000000000001,5.36,12.027725347593583]
["1987-04-01",1.127,5.46,12.19776596273292]
["1987-05-01",1.1299999999999999,5.98,13.323990371681418]
["1987-06-01",1.135,6.55,14.529712070484582]
["1987-07-01",1.1379999999999999,6.78,15.000267416520213]
["1987-08-01",1.143,6.84,15.066814488188976]
["1987-09-01",1.147,6.64,14.57525733217088]
["1987-10-01",1.1499999999999999,5.85,12.807654260869565]
["1987-11-01",1.1539999999999999,5.42,11.825106135181978]
["1987-12-01",1.1559999999999999,5.13,11.173033494809689]
["1988-01-01",1.1599999999999999,5.08,11.025982344827588]
["1988-02-01",1.1619999999999999,5.09,11.028672082616179]
["1988-03-01",1.165,5.18,11.194775896995706]
["1988-04-01",1.1719999999999999,5.35,11.493114675767918]
["1988-05-01",1.175,5.87,12.578006195744679]
["1988-06-01",1.18,6.5,13.868928813559322]
["1988-07-01",1.1850000000000001,6.74,14.320332962025317]
["1988-08-01",1.19,6.92,14.640998722689078]
["1988-09-01",1.1950000000000001,6.79,14.305842476987445]
["1988-10-01",1.1990000000000001,5.95,12.494225854879065]
["1988-11-01",1.2030000000000001,5.56,11.636456059850373]
["1988-12-01",1.2070000000000001,5.39,11.243280994200497]
["1989-01-01",1.212,5.41,11.238444752475248]
["1989-02-01",1.216,5.38,11.139360789473685]
["1989-03-01",1.222,5.45,11.228890998363338]
["1989-04-01",1.2310000000000001,5.54,11.33087064175467]
["1989-05-01",1.2370000000000001,5.93,12.06970244139046]
["1989-06-01",1.2410000000000001,6.58,13.349520966962126]
["1989-07-01",1.2450000000000001,6.92,13.994207614457832]
["1989-08-01",1.2450000000000001,7.07,14.29755026506024]
["1989-09-01",1.248,6.8,13.718476923076922]
["1989-10-01",1.254,6.06,12.167088229665071]
["1989-11-01",1.2589999999999999,5.56,11.118869451945988]
["1989-12-01",1.2629999999999999,5.3,10.56535486935867]
["1990-01-01",1.2749999999999999,5.43,10.722627388235294]
["1990-02-01",1.28,5.65,11.113479375000001]
["1990-03-01",1.286,5.6,10.963737480559875]
["1990-04-01",1.2889999999999999,5.64,11.016350783553142]
["1990-05-01",1.2909999999999999,6,11.701366382649109]
["1990-06-01",1.2989999999999999,6.56,12.714704110854505]
["1990-07-01",1.3049999999999999,7.04,13.582312459770115]
["1990-08-01",1.3160000000000001,7.08,13.545309665653496]
["1990-09-01",1.325,6.9,13.111270641509435]
["1990-10-01",1.3340000000000001,6.14,11.588416911544225]
["1990-11-01",1.337,5.69,10.715006252804788]
["1990-12-01",1.3420000000000001,5.62,10.543756542473918]
["1991-01-01",1.347,5.54,10.355086681514477]
["1991-02-01",1.3480000000000001,5.56,10.384760118694359]
["1991-03-01",1.3480000000000001,5.6,10.4594706231454]
["1991-04-01",1.351,5.9,10.995329089563286]
["1991-05-01",1.3560000000000001,6.28,11.66034831858407]
["1991-06-01",1.36,6.97,12.903437999999998]
["1991-07-01",1.3620000000000001,7.23,13.365116828193832]
["1991-08-01",1.3660000000000001,7.36,13.565589926793557]
["1991-09-01",1.37,6.92,{"$f":"C168*$B$508/B168","v":12.717363854014598}]
["1991-10-01",1.3720000000000001,6.2,11.377560349854226]
["1991-11-01",1.3779999999999999,5.51,10.067321799709724]
["1991-12-01",1.3819999999999999,5.51,10.038183386396527]
["1992-01-01",1.383,5.53,10.067335010845987]
["1992-02-01",1.3859999999999999,5.54,10.063709783549784]
["1992-03-01",1.391,5.5,9.9551344356578007]
["1992-04-01",1.3939999999999999,5.62,10.15044568149211]
["1992-05-01",1.397,6.15,11.083840801717967]
["1992-06-01",1.401,6.84,12.292197687366166]
["1992-07-01",1.405,7.27,13.027757209964411]
["1992-08-01",1.4079999999999999,7.45,13.321869886363636]
["1992-09-01",1.411,7.15,12.758235010630758]
["1992-10-01",1.417,6.52,11.584820663373323]
["1992-11-01",1.421,6.02,10.666304630541871]
["1992-12-01",1.423,5.74,10.155903415319747]
["1993-01-01",1.4279999999999999,5.73,10.102712268907563]
["1993-02-01",1.431,5.73,10.081532578616352]
["1993-03-01",1.4330000000000001,5.67,9.9620436008374025]
["1993-04-01",1.4379999999999999,6.02,10.540207844228094]
["1993-05-01",1.4419999999999999,6.78,11.837936421636618]
["1993-06-01",1.4430000000000001,7.37,12.859163742203743]
["1993-07-01",1.4450000000000001,7.86,13.695133453287196]
["1993-08-01",1.448,8.1300000000000008,14.136228397790058]
["1993-09-01",1.45,7.75,13.456907586206897]
["1993-10-01",1.456,6.79,11.741402307692306]
["1993-11-01",1.46,6.17,10.64005512328767]
["1993-12-01",1.4630000000000001,6.07,10.446142228298017]
["1994-01-01",1.4630000000000001,5.93,10.205209788106629]
["1994-02-01",1.4670000000000001,6.04,10.366171615541921]
["1994-03-01",1.4710000000000001,6.3,10.782996057104011]
["1994-04-01",1.472,6.6,11.288797826086956]
["1994-05-01",1.4750000000000001,6.84,11.675504379661016]
["1994-06-01",1.4790000000000001,7.66,13.039837079107503]
["1994-07-01",1.484,8.1,13.742403234501348]
["1994-08-01",1.49,8.2200000000000006,13.889836026845638]
["1994-09-01",1.4930000000000001,7.84,13.221107139986604]
["1994-10-01",1.494,6.86,11.56072546184739]
["1994-11-01",1.498,6.27,10.538220881174899]
["1994-12-01",1.5009999999999999,6.06,10.164909153897401]
["1995-01-01",1.5049999999999999,5.85,9.7865796677740864]
["1995-02-01",1.5089999999999999,5.76,9.6104741153081505]
["1995-03-01",1.512,5.84,9.7246196825396822]
["1995-04-01",1.518,6.06,10.051072885375493]
["1995-05-01",1.5209999999999999,6.54,10.825802603550297]
["1995-06-01",1.524,7.49,12.373951811023622]
["1995-07-01",1.526,7.82,12.902200576671035]
["1995-08-01",1.5289999999999999,8.1300000000000008,13.387350372792678]
["1995-09-01",1.5309999999999999,7.73,12.712058210320054]
["1995-10-01",1.5349999999999999,6.62,10.858283570032574]
["1995-11-01",1.5369999999999999,5.61,9.1896836955107357]
["1995-12-01",1.5389999999999999,5.54,9.0632240155945425]
["1996-01-01",1.5469999999999999,5.64,9.1791054686489968]
["1996-02-01",1.55,5.82,9.4537226322580636]
["1996-03-01",1.5549999999999999,5.93,9.6014288874598073]
["1996-04-01",1.5609999999999999,6.27,10.112911518257528]
["1996-05-01",1.5640000000000001,6.84,11.011105473145779]
["1996-06-01",1.5669999999999999,7.83,12.580686356094448]
["1996-07-01",1.57,8.64,13.85561029299363]
["1996-08-01",1.5720000000000001,8.73,13.982127938931297]
["1996-09-01",1.577,7.99,12.756356727964489]
["1996-10-01",1.5820000000000001,7.05,11.220034892541086]
["1996-11-01",1.587,6.37,10.105878563327032]
["1996-12-01",1.591,6.47,10.238720100565681]
["1997-01-01",1.5940000000000001,6.74,{"$f":"C232*$B$508/B232","v":10.645918795483061}]
["1997-02-01",1.597,6.79,10.704747501565434]
["1997-03-01",1.5980000000000001,6.52,10.272647609511889]
["1997-04-01",1.599,6.53,10.281968930581614]
["1997-05-01",1.599,6.83,10.754341163227016]
["1997-06-01",1.6020000000000001,8.3000000000000007,13.044491385767792]
["1997-07-01",1.6040000000000001,8.7799999999999994,13.781666034912718]
["1997-08-01",1.6080000000000001,8.99,14.076193134328358]
["1997-09-01",1.6120000000000001,8.84,13.806983225806452]
["1997-10-01",1.615,7.69,11.988514773993808]
["1997-11-01",1.617,6.86,10.681338181818182]
["1997-12-01",1.6180000000000001,6.54,10.176789715698392]
["1998-01-01",1.62,6.41,9.9621845925925925]
["1998-02-01",1.62,6.41,9.9621845925925925]
["1998-03-01",1.62,6.29,9.7756850370370358]
["1998-04-01",1.6220000000000001,6.81,10.5707994081381]
["1998-05-01",1.6259999999999999,7.7,11.92289594095941]
["1998-06-01",1.6279999999999999,8.51,13.160934545454547]
["1998-07-01",1.6319999999999999,8.5299999999999994,13.159532058823528]
["1998-08-01",1.6339999999999999,9.25,14.252834761321909]
["1998-09-01",1.635,8.9600000000000009,13.797545100917432]
["1998-10-01",1.639,7.6,11.674712873703477]
["1998-11-01",1.641,6.58,10.095524387568556]
["1998-12-01",1.6439999999999999,6.34,9.7095480291970802]
["1999-01-01",1.647,6,9.1721092896174863]
["1999-02-01",1.647,6.29,9.6154279052823313]
["1999-03-01",1.6479999999999999,6.06,9.2582091262135915]
["1999-04-01",1.659,6.44,9.7735210126582288]
["1999-05-01",1.66,7.3,11.072006746987952]
["1999-06-01",1.66,8.1999999999999993,12.437048674698794]
["1999-07-01",1.667,8.83,13.336340443911217]
["1999-08-01",1.671,9.14,13.771502190305206]
["1999-09-01",1.6779999999999999,8.6300000000000008,12.948826412395711]
["1999-10-01",1.681,7.56,11.323108054729326]
["1999-11-01",1.6839999999999999,7.15,10.689946318289786]
["1999-12-01",1.6879999999999999,6.51,9.7100198104265409]
["2000-01-01",1.6930000000000001,6.37,9.4731419255759004]
["2000-02-01",1.7,6.54,9.685909270588235]
["2000-03-01",1.71,6.91,10.17404154385965]
["2000-04-01",1.7090000000000001,7.19,10.592498162668226]
["2000-05-01",1.712,8.26,12.147526542056074]
["2000-06-01",1.722,9.5,13.889993031358886]
["2000-07-01",1.7270000000000001,10.32,15.04523339895773]
["2000-08-01",1.7270000000000001,10.37,15.118126971627097]
["2000-09-01",1.736,10.1,14.648164976958524]
["2000-10-01",1.7390000000000001,9.44,13.667339482461184]
["2000-11-01",1.742,8.58,12.400828656716417]
["2000-12-01",1.746,8.56,12.343578831615121]
["2001-01-01",1.756,10.119999999999999,14.510005284738039]
["2001-02-01",1.76,10.26,14.67730309090909]
["2001-03-01",1.7609999999999999,9.85,14.082781601362861]
["2001-04-01",1.764,10.16,14.501291972789115]
["2001-05-01",1.7729999999999999,11.14,15.819327783417936]
["2001-06-01",1.7769999999999999,11.58,16.407133100731571]
["2001-07-01",1.774,11.22,15.923950214205187]
["2001-08-01",1.774,10.89,15.4555987373168]
["2001-09-01",1.7809999999999999,10.17,14.377010937675465]
["2001-10-01",1.776,8.24,11.681424864864866]
["2001-11-01",1.7749999999999999,7.98,11.319209645070423]
["2001-12-01",1.774,7.3,10.360502367531003]
["2002-01-01",1.7769999999999999,7.38,10.4563594372538]
["2002-02-01",1.78,7.23,10.226566921348315]
["2002-03-01",1.7849999999999999,7.1,10.014555966386554]
["2002-04-01",1.7929999999999999,7.66,10.756229247071946]
["2002-05-01",1.7949999999999999,8.5399999999999991,{"$f":"C296*$B$508/B296","v":11.978570339832869}]
["2002-06-01",1.796,9.58,13.429837149220489]
["2002-07-01",1.8,10.31,14.421078133333333]
["2002-08-01",1.8049999999999999,10.44,14.562463911357341]
["2002-09-01",1.8080000000000001,10.23,14.245863451327434]
["2002-10-01",1.8120000000000001,8.61,11.963452450331125]
["2002-11-01",1.8149999999999999,7.99,11.083622347107438]
["2002-12-01",1.8180000000000001,7.87,10.899144818481847]
["2003-01-01",1.8260000000000001,8.18,11.278831281489595]
["2003-02-01",1.8360000000000001,8.58,11.765927843137254]
["2003-03-01",1.839,9.77,13.375942838499185]
["2003-04-01",1.8320000000000001,10.18,13.990520698689954]
["2003-05-01",1.829,10.79,14.853175374521594]
["2003-06-01",1.831,12.08,16.610785101037685]
["2003-07-01",1.837,12.75,17.474815459989113]
["2003-08-01",1.845,12.84,17.521860682926832]
["2003-09-01",1.851,12.31,16.744153776337114]
["2003-10-01",1.849,10.64,14.48826184964846]
["2003-11-01",1.85,9.77,13.296410205405405]
["2003-12-01",1.855,9.51,12.907679482479784]
["2004-01-01",1.863,9.7100000000000009,13.122541191626411]
["2004-02-01",1.867,9.85,13.283223567220137]
["2004-03-01",1.871,10.029999999999999,13.497045601282736]
["2004-04-01",1.8740000000000001,10.54,14.160630608324437]
["2004-05-01",1.8819999999999999,11.63,15.558641190223168]
["2004-06-01",1.889,13.08,17.433611180518792]
["2004-07-01",1.891,13.54,18.027632871496561]
["2004-08-01",1.8919999999999999,13.74,18.284250824524314]
["2004-09-01",1.8979999999999999,13.31,17.656044594309801]
["2004-10-01",1.9079999999999999,11.69,15.425800503144654]
["2004-11-01",1.917,11.44,15.025034616588419]
["2004-12-01",1.917,11.09,14.565352613458529]
["2005-01-01",1.9159999999999999,10.9,14.323282672233821]
["2005-02-01",1.9239999999999999,10.87,14.22446844074844]
["2005-03-01",1.931,10.84,14.133788171931641]
["2005-04-01",1.9370000000000001,11.88,15.441816582343831]
["2005-05-01",1.9359999999999999,12.74,16.568212066115702]
["2005-06-01",1.9370000000000001,13.79,17.924465544656684]
["2005-07-01",1.9490000000000001,14.86,19.196344710107745]
["2005-08-01",1.9610000000000001,15.51,19.913416338602751]
["2005-09-01",1.988,16.559999999999999,20.972756861166999]
["2005-10-01",1.9910000000000001,16.440000000000001,20.789408016072326]
["2005-11-01",1.9810000000000001,15.64,19.877595234729935]
["2005-12-01",1.9810000000000001,14.6,18.555811408379604]
["2006-01-01",1.9930000000000001,14.92,18.848339427997992]
["2006-02-01",1.994,13.98,17.651986519558676]
["2006-03-01",1.9970000000000001,13.17,16.604250615923885]
["2006-04-01",2.0070000000000001,13.27,16.646967055306426]
["2006-05-01",2.0129999999999999,14.41,18.023194754098363]
["2006-06-01",2.0179999999999998,15.07,18.801983191278495]
["2006-07-01",2.0289999999999999,15.72,19.506621823558405]
["2006-08-01",2.0379999999999998,16.18,19.988762473012759]
["2006-09-01",2.028,15.71,19.503825562130178]
["2006-10-01",2.0190000000000001,12.51,15.600286002971766]
["2006-11-01",2.02,12.45,15.517778613861385]
["2006-12-01",2.0310000000000001,12.53,15.532906115214178]
["2007-01-01",2.03437,12.17,15.061637991122558]
["2007-02-01",2.0422600000000002,12.13,14.95413645667055]
["2007-03-01",2.05288,12.81,15.710757881610226]
["2007-04-01",2.05904,13.31,16.275144067138083]
["2007-05-01",2.0675500000000002,14.69,17.888640835771806]
["2007-06-01",2.0723400000000001,16.28,19.779028692203021]
["2007-07-01",2.0760299999999998,16.71,20.265363332899817]
["2007-08-01",2.07667,16.71,20.259117837692074]
["2007-09-01",2.0854699999999999,16.03,{"$f":"C360*$B$508/B360","v":19.352681323634481}]
["2007-10-01",2.0918999999999999,14.57,17.535986462067974]
["2007-11-01",2.1083400000000001,13.04,15.572147642220893]
["2007-12-01",2.1144500000000002,12.34,14.693637097117453]
["2008-01-01",2.12174,12.24,14.524487712914873]
["2008-02-01",2.1268699999999998,12.58,14.891939573175607]
["2008-03-01",2.1344799999999999,13.13,15.487602938420601]
["2008-04-01",2.1394199999999999,14.49,17.052336876349667]
["2008-05-01",2.1520800000000002,16.329999999999998,19.104661313705805]
["2008-06-01",2.1746300000000001,18.91,21.893627440070265]
["2008-07-01",2.1901600000000001,20.77,23.876585674106]
["2008-08-01",2.1869000000000001,20.170000000000002,23.221407691252459]
["2008-09-01",2.1887699999999999,18.41,21.177038720377201]
["2008-10-01",2.16995,15.45,17.926286227793263]
["2008-11-01",2.1315300000000001,13.8,16.300435461851347]
["2008-12-01",2.1139800000000002,12.84,15.292402463599466]
["2009-01-01",2.1193300000000002,12.49,14.838001896825883]
["2009-02-01",2.1270500000000001,12.26,14.511902136762181]
["2009-03-01",2.1249500000000001,11.98,14.194486044377514]
["2009-04-01",2.1270899999999999,11.68,13.825108443930439]
["2009-05-01",2.13022,12.86,15.199457257935798]
["2009-06-01",2.1478999999999999,14.26,16.715410140136878]
["2009-07-01",2.1472600000000002,15.27,17.904655644868342]
["2009-08-01",2.1544500000000002,15.61,18.242235299032235]
["2009-09-01",2.1586099999999999,14.8,17.262317509879043]
["2009-10-01",2.1650900000000002,11.78,13.698748929605696]
["2009-11-01",2.1723400000000002,11.48,13.305330252170471]
["2009-12-01",2.17347,10.42,12.070510510842109]
["2010-01-01",2.1748799999999999,10.56,12.224755683072171]
["2010-02-01",2.1728100000000001,10.69,12.387039529457246]
["2010-03-01",2.17353,10.99,12.730446122206734]
["2010-04-01",2.1740300000000001,11.97,13.86245621265576]
["2010-05-01",2.1728999999999998,13.12,15.202172801325419]
["2010-06-01",2.1719900000000001,14.86,17.225528588989818]
["2010-07-01",2.17605,16.21,18.755373378369065]
["2010-08-01",2.17923,16.649999999999999,19.236353023774452]
["2010-09-01",2.18275,15.63,18.028788784789828]
["2010-10-01",2.19035,13.37,15.368428461204831]
["2010-11-01",2.1959,10.89,12.486102354387723]
["2010-12-01",2.20472,9.98,11.396950687615661]
["2011-01-01",2.2118699999999998,9.9,11.269046372526416]
["2011-02-01",2.2189800000000002,10.14,11.505252034718653]
["2011-03-01",2.2304599999999999,10.43,11.773387516476422]
["2011-04-01",2.2409300000000001,11.27,12.662142449786472]
["2011-05-01",2.2480600000000002,12.5,13.99953737889558]
["2011-06-01",2.2480600000000002,14.7,16.463455957581203]
["2011-07-01",2.2539500000000001,16.14,18.028966108387497]
["2011-08-01",2.2610600000000001,16.670000000000002,18.562440837483308]
["2011-09-01",2.2659699999999998,15.63,17.366663601018548]
["2011-10-01",2.2675000000000001,12.85,14.268141300992284]
["2011-11-01",2.27169,10.78,11.947616232848672]
["2011-12-01",2.27223,9.83,10.892129546744828]
["2012-01-01",2.2784200000000001,9.6199999999999992,10.630479577953142]
["2012-02-01",2.28329,9.4700000000000006,10.4424035843016]
["2012-03-01",2.2880699999999998,10.41,11.454944577744563]
["2012-04-01",2.2918699999999999,10.94,12.018185743519485]
["2012-05-01",2.2871299999999999,12.61,13.881481087651336]
["2012-06-01",2.2852399999999999,14.18,15.622696049430255]
["2012-07-01",2.2858999999999998,15.13,16.664537696312177]
["2012-08-01",2.2991799999999998,15.82,17.323876373315706]
["2012-09-01",2.3101500000000001,14.72,16.042764184143884]
["2012-10-01",2.3163800000000001,11.68,12.695347879018122]
["2012-11-01",2.3124899999999999,9.99,10.876701114383199]
["2012-12-01",2.3122099999999999,9.8000000000000007,10.671129006448377]
["2013-01-01",2.3167900000000001,9.15,{"$f":"C424*$B$508/B424","v":9.9436537623176893}]
["2013-02-01",2.3293699999999999,9.23,9.9764215732150756]
["2013-03-01",2.3228200000000001,9.35,10.134623604067468]
["2013-04-01",2.3179699999999999,10.43,11.328908450066223]
["2013-05-01",2.3189299999999999,12.61,13.691121267136134]
["2013-06-01",2.3244500000000001,15.02,16.269016274817698]
["2013-07-01",2.3290000000000002,16.3,17.620964877629881]
["2013-08-01",2.3345600000000002,16.43,17.719199300938936]
["2013-09-01",2.3354400000000002,15.69,16.914758400986535]
["2013-10-01",2.3366899999999999,12.38,13.339240857794573]
["2013-11-01",2.3410000000000002,10.039999999999999,10.798013566851772]
["2013-12-01",2.3471899999999999,9.14,9.8041403380212095]
["2014-01-01",2.3534700000000002,9.26,9.9063550587005551]
["2014-02-01",2.3552200000000001,9.77,10.444187328572276]
["2014-03-01",2.3595600000000001,10.7,11.417323907847225]
["2014-04-01",2.36463,11.76,12.521480925134165]
["2014-05-01",2.3686699999999998,13.6,14.455926068215497]
["2014-06-01",2.37188,16.13,17.1219499806061]
["2014-07-01",2.3748499999999999,17.23,18.266723843611175]
["2014-08-01",2.37439,17.41,18.461130243978456]
["2014-09-01",2.37452,16.27,17.25135811869346]
["2014-10-01",2.3744700000000001,13.11,13.901049008831444]
["2014-11-01",2.3704200000000002,10.19,10.823318804262534]
["2014-12-01",2.3626999999999998,10.01,10.666871562195794]
["2015-01-01",2.34836,9.5,10.185222027287129]
["2015-02-01",2.3527399999999998,9.08,9.7168048828174811]
["2015-03-01",2.3595600000000001,9.2799999999999994,9.9021276509179668]
["2015-04-01",2.36165,10.43,11.119374132492114]
["2015-05-01",2.3695200000000001,12.73,13.526318039096525]
["2015-06-01",2.3761800000000002,15.07,15.967814761507965]
["2015-07-01",2.3799299999999999,16.28,17.222721811145711]
["2015-08-01",2.3798900000000001,16.88,17.857765997588121]
["2015-09-01",2.3746700000000001,16.399999999999999,17.388100915074514]
["2015-10-01",2.37764,12.6,13.342463282919198]
["2015-11-01",2.3807200000000002,10.02,10.596708088309418]
["2015-12-01",2.3782700000000001,9.27,9.8136405370290163]
["2016-01-01",2.3799000000000001,8.2799999999999994,8.7595782679944527]
["2016-02-01",2.3753199999999999,8.36,8.8612649411447713]
["2016-03-01",2.38022,9.19,9.7209784641755785]
["2016-04-01",2.3884300000000001,9.65,10.172468776560335]
["2016-05-01",2.39439,11.62,12.218638266948991]
["2016-06-01",2.4007399999999999,14.43,15.133269708506544]
["2016-07-01",2.4005800000000002,16.55,17.357748210849046]
["2016-08-01",2.4056899999999999,17.600000000000001,18.419785757932239]
["2016-09-01",2.4101699999999999,16.78,17.52894788334433]
["2016-10-01",2.4166699999999999,13.74,14.314657177024584]
["2016-11-01",2.4208099999999999,10.77,11.201252010690636]
["2016-12-01",2.4278400000000002,9.06,9.3954958481613282]
["2017-01-01",2.44028,9.3800000000000008,9.6777577655023208]
["2017-02-01",2.44102,10.07,10.386511409165022]
["2017-03-01",2.4371700000000001,9.9,10.227298711210134]
["2017-04-01",2.4408699999999999,11.38,11.738407502243055]
["2017-05-01",2.4391099999999999,13.32,13.749420928125422]
["2017-06-01",2.4403199999999998,16.13,16.641756294256492]
["2017-07-01",2.4423599999999999,17.96,18.514339507689286]
["2017-08-01",2.45262,18.32,18.806447831298776]
["2017-09-01",2.4639199999999999,17.010000000000002,17.381581155232315]
["2017-10-01",2.46583,13.5,13.784220323379959]
["2017-11-01",2.47411,10.26,10.440947831745557,"Forecast"]
["2017-12-01",2.4790999999999999,9.33,9.4754352466620961,"Values"]
["2018-01-01",2.4924499999999998,8.93,9.0206238520331397,{"$f":"IF($A484>=DATE(YEAR($C$1),MONTH($C$1)-2,1),1,0)","v":0}]
["2018-02-01",2.4961899999999999,9.65,9.7333254279521988,0]
["2018-03-01",2.4946199999999998,9.7899999999999991,9.8807488755802471,0]
["2018-04-01",2.50013,10.11421,10.185466972613424,1]
["2018-05-01",2.5121991852000001,12.42469,{"$f":"C488*$B$508/B488","v":12.452113225595834},1]
["2018-06-01",2.517744,14.77243,14.77243,1]
["2018-07-01",2.5236900000000002,16.298780000000001,16.260378870748784,1]
["2018-08-01",2.528438,17.179880000000001,17.107217891330539,1]
["2018-09-01",2.5325700000000002,16.21414,16.119220278278586,1]
["2018-10-01",2.5354009999999998,13.182499999999999,13.090694639625054,1]
["2018-11-01",2.5388130000000002,10.728149999999999,10.639119656942043,1]
["2018-12-01",2.5421230000000001,9.7553210000000004,9.6617673164610842,1]
["2019-01-01",2.5443669999999998,9.5338709999999995,9.4341132812302622,1]
["2019-02-01",2.5481929999999999,9.6480940000000004,9.5328064946163806,1]
["2019-03-01",2.5526369999999998,9.946612,9.8106478450825563,1]
["2019-04-01",2.558538,10.874320000000001,10.700936993736267,1]
["2019-05-01",2.56359,12.8718,12.641606972721847,1]
["2019-06-01",2.568632,15.22241,14.920833908103612,1]
["2019-07-01",2.5742129999999999,16.651540000000001,16.286264938355917,1]
["2019-08-01",2.5788220000000002,17.410969999999999,16.998600621400001,1]
["2019-09-01",2.583008,16.425840000000001,16.010813789566274,1]
["2019-10-01",2.5861540000000001,13.366,13.012437118593864,1]
["2019-11-01",2.58996,10.88247,10.579033478385766,1]
["2019-12-01",2.5938080000000001,9.9099789999999999,9.6193666483317184,1]
["Base CPI (6/2018)",2.517744]
[{"$f":"A1&\" \"&TEXT(C1,\"Mmmm yyyy\")","v":"EIA Short-Term Energy Outlook, June 2018"}]
["Forecast / estimated values shown in blue"]
["Values shown for recent months are estimates if official historical data has not yet been released"]
[{"$f":"\"Real Price (\"&TEXT($C$1,\"mmm yyyy\")&\" $)\"","v":"Real Price (Jun 2018 $)"}]
["See Notes and Sources for more information"]

{"sheet":"coal, raw","index":6,"n_rows":20,"n_cols":3,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[null,"Coal Prices, Real Dollars"]
[null,19991231,16.989999999999998]
[null,20001231,16.78]
[null,20011231,16.97]
[null,20021231,17.260000000000002]
[null,20031231,16.78]
[null,20041231,18.21]
[null,20051231,20.87]
[null,20061231,21.56]
[null,20071231,21.87]
[null,20081231,26.62]
[null,20091231]
[null,20101231]
[null,20111231]
[null,20121231]
[null,20131231]
[null,20141231]
[null,20151231]
[null,20161231]
[null,20171231]