{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["A1.1 Summary","A1.2 REDA","A1.3 PGTVA"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"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":"A1.1 Summary","index":0,"n_rows":30,"n_cols":5,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["EPCOR Natural Gas Limited Partnership"]
["REDA & PGTVA Account balances for input to rate rider calculation"]
[null,null,"Balance",null,"Interest"]
[null,"REDA","2017-09-30",null,"Re-allocation"]
[null,"IFRS",{"$f":"'A1.2 REDA'!AA29","v":3685.58},null,{"$f":"C5+C5/$C$14*$C$15","v":3824.5250700727611}]
[null,"EB-2008-0346 - Cost Awards for DSM",{"$f":"'A1.2 REDA'!AA19","v":1537.7099999999998},null,{"$f":"C6+C6/$C$14*$C$15","v":1595.681126308908}]
[null,"EB 2010-0280 - Low Income",{"$f":"'A1.2 REDA'!AA56","v":20838.05},null,21623.637157904508]
[null,"EB 2014-0199 - QRAM Process",{"$f":"'A1.2 REDA'!AA89","v":23085},null,23955.296382829754]
[null,"EB-2014-0289 - Natural Gas Market Review",{"$f":"'A1.2 REDA'!AA99","v":13802.46},null,14322.807888765536]
[null,"EB-2010-0018 - Engineering Study (@ 50%)",{"$f":"'A1.2 REDA'!AA47","v":9415.69},null,9770.6582022458879]
[null,"EB-2010-0108 - System Integrity Study",{"$f":"'A1.2 REDA'!AA80","v":72515.509999999995},null,75249.319229025554]
[null,"Other REDA",{"$f":"'A1.2 REDA'!AA130","v":4113},null,4268.0586537829231]
[null,"DSM Account",{"$f":"'A1.2 REDA'!AA104","v":3532.03},null,3665.1862890641623]
[null,"Sub-total",{"$f":"SUM(C5:C13)","v":152525.03},null,{"$f":"SUM(E5:E13)","v":158275.16999999998}]
[null,"Interest",{"$f":"'A1.2 REDA'!AA136","v":5750.14},null,0]
[null,"Total",{"$f":"C14+C15","v":158275.17000000001},null,{"$f":"E14+E15","v":158275.16999999998}]
[]
[]
[null,"PGTVA 1-5",{"$f":"'A1.3 PGTVA'!AA20","v":399098.44808320951}]
[null,"Interest",{"$f":"'A1.3 PGTVA'!AA24","v":29822.360000000008}]
[null,"Total",{"$f":"SUM(C19:C20)","v":428920.8080832095}]
[]
[null,"PGTVA 6",{"$f":"'A1.3 PGTVA'!AA40","v":500576.85912199999}]
[null,"Interest",{"$f":"'A1.3 PGTVA'!AA43","v":43734.539999999986}]
[null,"Total",{"$f":"SUM(C23:C24)","v":544311.39912199997}]
[]
[]
[]
[]
[null,{"$f":"MID(CELL(\"filename\",A2),FIND(\"]\",CELL(\"filename\",A2))+1,255)","v":"A1.1 Summary"}]

{"sheet":"A1.2 REDA","index":1,"n_rows":140,"n_cols":27,"rows_kept":140,"cut":false,"hidden":false,"merged":[]}
["EPCOR Natural Gas Limited Partnership"]
["REDA Account continuity"]
[]
[]
[null,"Regulatory Expense Deferral Account (REDA)","2015-09-30","2015-10-31","2015-11-30","2015-12-31","2016-01-31","2016-02-28","2016-03-31","2016-04-30","2016-05-31","2016-06-30","2016-07-31","2016-08-31","2016-09-30","2016-10-31","2016-11-30","2016-12-31","2017-01-31","2017-02-28","2017-03-31","2017-04-30","2017-05-31","2017-06-30","2017-07-31","2017-08-31","2017-09-30"]
[null,"Rate Riders REDA/PGTVA (Ride 2)"]
[null,"PGTVA IGPC (167,115 + 950 = 168,065)",{"$f":"24009.29+24009.29+24009.29+24009.29+24009.29+24009.29+24009.29-167115-30.59-230-230-230-230","v":-0.55999999997209216},{"$f":"24009.29+24009.29+24009.29+24009.29+24009.29+24009.29+24009.29-167115-30.59-230-230-230-230","v":-0.55999999997209216},-0.55999999997209216,-0.55999999997209216,-0.55999999997209216,-0.55999999997209216,-0.55999999997209216,-0.55999999997209216,-0.55999999997209216,-0.55999999997209216,-0.55999999997209216,-0.55999999997209216]
[null,"PGTVA/REDA ",{"$f":"-19549.58-19612.08-19607.08-19528.08-19576.57-19564.07-19705.07+1822.5+59856+111123+156.26+952-31696.45-3358.92-176+29740.47","v":31276.329999999973},{"$f":"-19549.58-19612.08-19607.08-19528.08-19576.57-19564.07-19705.07+1822.5+59856+111123+156.26+952-31696.45-3358.92-176+29740.47","v":31276.329999999973},31276.329999999973,31276.329999999973,31276.329999999973,31276.329999999973,31276.329999999973,31276.329999999973,31276.329999999973,31276.329999999973,31276.329999999973,31276.329999999973]
[null,"Payment",0,0,0,0,0,0,0,0,-29740.47,-29740.47,-29740.47,-29740.47]
[null,"PGTVA (31,696)+REDA 172 ,801+int (2,427) = 138,678",{"$f":"SUM(C7:C9)","v":31275.77},{"$f":"SUM(D7:D9)","v":31275.77},31275.77,31275.77,31275.77,31275.77,31275.77,31275.77,1535.2999999999993,1535.2999999999993,1535.2999999999993,1535.2999999999993,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Write off rate rider over rebated $1,535.30"]
[]
[null,"EB-2008-0346 - Cost Awards for Guidelines for DSM"]
[]
[null,"Ontario Energy Board Inv #CA1011Q2003",1042.3399999999999,1042.3399999999999,1042.3399999999999,1042.3399999999999,1042.3399999999999,1042.3399999999999,1042.3399999999999,1042.3399999999999,1042.3399999999999,1042.3399999999999,1042.3399999999999,1042.3399999999999,1042.3399999999999,1042.3399999999999,1042.3399999999999,1042.3399999999999,1042.3399999999999,1042.3399999999999,1042.3399999999999,1042.3399999999999,1042.3399999999999,1042.3399999999999,1042.3399999999999,1042.3399999999999,1042.3399999999999]
[null,"Ontario Energy Board Inv #2011067",83.35,83.35,83.35,83.35,83.35,83.35,83.35,83.35,83.35,83.35,83.35,83.35,83.35,83.35,83.35,83.35,83.35,83.35,83.35,83.35,83.35,83.35,83.35,83.35,83.35]
[null,"Ontario Energy Board Inv #CA1112Q4003",412.02,412.02,412.02,412.02,412.02,412.02,412.02,412.02,412.02,412.02,412.02,412.02,412.02,412.02,412.02,412.02,412.02,412.02,412.02,412.02,412.02,412.02,412.02,412.02,412.02]
[]
[null,"sub-total",{"$f":"SUM(C15:C18)","v":1537.7099999999998},{"$f":"SUM(D15:D18)","v":1537.7099999999998},1537.7099999999998,1537.7099999999998,1537.7099999999998,1537.7099999999998,1537.7099999999998,1537.7099999999998,1537.7099999999998,1537.7099999999998,1537.7099999999998,1537.7099999999998,1537.7099999999998,1537.7099999999998,1537.7099999999998,1537.7099999999998,1537.7099999999998,1537.7099999999998,1537.7099999999998,1537.7099999999998,1537.7099999999998,1537.7099999999998,1537.7099999999998,1537.7099999999998,1537.7099999999998]
[]
[]
[null,"IFRS Matters"]
[null,"Ogilvy Renault Inv #931085",280,280,280,280,280,280,280,280,280,280,280,280,280,280,280,280,280,280,280,280,280,280,280,280,280]
[null,"Ogilvy Renault Inv #937256",300,300,300,300,300,300,300,300,300,300,300,300,300,300,300,300,300,300,300,300,300,300,300,300,300]
[null,"Ontario Energy Board",423.83,423.83,423.83,423.83,423.83,423.83,423.83,423.83,423.83,423.83,423.83,423.83,423.83,423.83,423.83,423.83,423.83,423.83,423.83,423.83,423.83,423.83,423.83,423.83,423.83]
[null,"Ogilvy Renault Inv #904962",1891.75,1891.75,1891.75,1891.75,1891.75,1891.75,1891.75,1891.75,1891.75,1891.75,1891.75,1891.75,1891.75,1891.75,1891.75,1891.75,1891.75,1891.75,1891.75,1891.75,1891.75,1891.75,1891.75,1891.75,1891.75]
[null,"Ogilvy Renault Inv #910519",790,790,790,790,790,790,790,790,790,790,790,790,790,790,790,790,790,790,790,790,790,790,790,790,790]
[]
[null,"sub-total",{"$f":"SUM(C23:C28)","v":3685.58},{"$f":"SUM(D23:D28)","v":3685.58},3685.58,3685.58,3685.58,3685.58,3685.58,3685.58,3685.58,3685.58,3685.58,3685.58,3685.58,3685.58,3685.58,3685.58,3685.58,3685.58,3685.58,3685.58,3685.58,3685.58,3685.58,3685.58,3685.58]
[]
[null,"Eng. Study Terms of Reference"]
[null,"MIG Engineering",191.36,191.36,191.36,191.36,191.36,191.36,191.36,191.36,191.36,191.36,191.36,191.36,191.36,191.36,191.36,191.36,191.36,191.36,191.36,191.36,191.36,191.36,191.36,191.36,191.36]
[null,"MIG Engineering - Inv #26931",1108.46,1108.46,1108.46,1108.46,1108.46,1108.46,1108.46,1108.46,1108.46,1108.46,1108.46,1108.46,1108.46,1108.46,1108.46,1108.46,1108.46,1108.46,1108.46,1108.46,1108.46,1108.46,1108.46,1108.46,1108.46]
[null,"MIG Engineering - Inv #26942",514.01,514.01,514.01,514.01,514.01,514.01,514.01,514.01,514.01,514.01,514.01,514.01,514.01,514.01,514.01,514.01,514.01,514.01,514.01,514.01,514.01,514.01,514.01,514.01,514.01]
[null,"MIG Engineering - Inv #27025",577.96,577.96,577.96,577.96,577.96,577.96,577.96,577.96,577.96,577.96,577.96,577.96,577.96,577.96,577.96,577.96,577.96,577.96,577.96,577.96,577.96,577.96,577.96,577.96,577.96]
[null,"MIG Engineering - Inv #27126",828.4,828.4,828.4,828.4,828.4,828.4,828.4,828.4,828.4,828.4,828.4,828.4,828.4,828.4,828.4,828.4,828.4,828.4,828.4,828.4,828.4,828.4,828.4,828.4,828.4]
[null,"Aecon Utility - Inv #1620",4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000]
[null,"MIG Engineering - Inv #27164",1772.57,1772.57,1772.57,1772.57,1772.57,1772.57,1772.57,1772.57,1772.57,1772.57,1772.57,1772.57,1772.57,1772.57,1772.57,1772.57,1772.57,1772.57,1772.57,1772.57,1772.57,1772.57,1772.57,1772.57,1772.57]
[null,"Aecon Utility - Inv #1671",3880,3880,3880,3880,3880,3880,3880,3880,3880,3880,3880,3880,3880,3880,3880,3880,3880,3880,3880,3880,3880,3880,3880,3880,3880]
[null,"Aecon Utility - Inv #1707",150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150]
[null,"Aecon Utility - Inv #1751",550,550,550,550,550,550,550,550,550,550,550,550,550,550,550,550,550,550,550,550,550,550,550,550,550]
[null,"MIG Engineering - Inv #27253",427.94,427.94,427.94,427.94,427.94,427.94,427.94,427.94,427.94,427.94,427.94,427.94,427.94,427.94,427.94,427.94,427.94,427.94,427.94,427.94,427.94,427.94,427.94,427.94,427.94]
[null,"MIG Enginieering - Inv #27302",380.68,380.68,380.68,380.68,380.68,380.68,380.68,380.68,380.68,380.68,380.68,380.68,380.68,380.68,380.68,380.68,380.68,380.68,380.68,380.68,380.68,380.68,380.68,380.68,380.68]
[null,"Aecon Utility - Inv #1917",4450,4450,4450,4450,4450,4450,4450,4450,4450,4450,4450,4450,4450,4450,4450,4450,4450,4450,4450,4450,4450,4450,4450,4450,4450]
[null,"Reallocate 50%",-9415.69,-9415.69,-9415.69,-9415.69,-9415.69,-9415.69,-9415.69,-9415.69,-9415.69,-9415.69,-9415.69,-9415.69,-9415.69,-9415.69,-9415.69,-9415.69,-9415.69,-9415.69,-9415.69,-9415.69,-9415.69,-9415.69,-9415.69,-9415.69,-9415.69]
[]
[null,"sub-total",{"$f":"SUM(C32:C46)","v":9415.69},{"$f":"SUM(D32:D46)","v":9415.69},9415.69,9415.69,9415.69,9415.69,9415.69,9415.69,9415.69,9415.69,9415.69,9415.69,9415.69,9415.69,9415.69,9415.69,9415.69,9415.69,9415.69,9415.69,9415.69,9415.69,9415.69,9415.69,9415.69]
[]
[null,"Low Income - EB 2010-0280"]
[null,"Norton Rose - Inv #1228144",390,390,390,390,390,390,390,390,390,390,390,390,390,390,390,390,390,390,390,390,390,390,390,390,390]
[null,"Progressive Impact - 1060",1126.25,1126.25,1126.25,1126.25,1126.25,1126.25,1126.25,1126.25,1126.25,1126.25,1126.25,1126.25,1126.25,1126.25,1126.25,1126.25,1126.25,1126.25,1126.25,1126.25,1126.25,1126.25,1126.25,1126.25,1126.25]
[null,"Norton Rose - Inv #1237457",19256.64,19256.64,19256.64,19256.64,19256.64,19256.64,19256.64,19256.64,19256.64,19256.64,19256.64,19256.64,19256.64,19256.64,19256.64,19256.64,19256.64,19256.64,19256.64,19256.64,19256.64,19256.64,19256.64,19256.64,19256.64]
[null,"Ontario Energy Board - CA1314Q1080",54.5,54.5,54.5,54.5,54.5,54.5,54.5,54.5,54.5,54.5,54.5,54.5,54.5,54.5,54.5,54.5,54.5,54.5,54.5,54.5,54.5,54.5,54.5,54.5,54.5]
[null,"Ontario Energy Board - CA1314Q2003",10.66,10.66,10.66,10.66,10.66,10.66,10.66,10.66,10.66,10.66,10.66,10.66,10.66,10.66,10.66,10.66,10.66,10.66,10.66,10.66,10.66,10.66,10.66,10.66,10.66]
[]
[null,"sub-total",{"$f":"SUM(C50:C55)","v":20838.05},{"$f":"SUM(D50:D55)","v":20838.05},20838.05,20838.05,20838.05,20838.05,20838.05,20838.05,20838.05,20838.05,20838.05,20838.05,20838.05,20838.05,20838.05,20838.05,20838.05,20838.05,20838.05,20838.05,20838.05,20838.05,20838.05,20838.05,20838.05]
[]
[null,"Steering Committee (System Integrety Study)"]
[null,"Osler Hoskin & Harcourt - Inv #11582938",532,532,532,532,532,532,532,532,532,532,532,532,532,532,532,532,532,532,532,532,532,532,532,532,532]
[null,"Osler Hoskin & Harcourt - Inv #11576514",3876,3876,3876,3876,3876,3876,3876,3876,3876,3876,3876,3876,3876,3876,3876,3876,3876,3876,3876,3876,3876,3876,3876,3876,3876]
[null,"Osler Hoskin & Harcourt - Inv #11657342",390,390,390,390,390,390,390,390,390,390,390,390,390,390,390,390,390,390,390,390,390,390,390,390,390]
[null,"SNC-Lavalin - Inv #1162427",1465.74,1465.74,1465.74,1465.74,1465.74,1465.74,1465.74,1465.74,1465.74,1465.74,1465.74,1465.74,1465.74,1465.74,1465.74,1465.74,1465.74,1465.74,1465.74,1465.74,1465.74,1465.74,1465.74,1465.74,1465.74]
[null,"SNC-Lavalin - Inv #1154174",8625.2800000000007,8625.2800000000007,8625.2800000000007,8625.2800000000007,8625.2800000000007,8625.2800000000007,8625.2800000000007,8625.2800000000007,8625.2800000000007,8625.2800000000007,8625.2800000000007,8625.2800000000007,8625.2800000000007,8625.2800000000007,8625.2800000000007,8625.2800000000007,8625.2800000000007,8625.2800000000007,8625.2800000000007,8625.2800000000007,8625.2800000000007,8625.2800000000007,8625.2800000000007,8625.2800000000007,8625.2800000000007]
[null,"Walsh, Phil Inv #001-14",17600,17600,17600,17600,17600,17600,17600,17600,17600,17600,17600,17600,17600,17600,17600,17600,17600,17600,17600,17600,17600,17600,17600,17600,17600]
[null,"SNC-Lavalin - Inv #1175490",2868.45,2868.45,2868.45,2868.45,2868.45,2868.45,2868.45,2868.45,2868.45,2868.45,2868.45,2868.45,2868.45,2868.45,2868.45,2868.45,2868.45,2868.45,2868.45,2868.45,2868.45,2868.45,2868.45,2868.45,2868.45]
[null,"SNC-Lavalin - Inv #1164160",2025.72,2025.72,2025.72,2025.72,2025.72,2025.72,2025.72,2025.72,2025.72,2025.72,2025.72,2025.72,2025.72,2025.72,2025.72,2025.72,2025.72,2025.72,2025.72,2025.72,2025.72,2025.72,2025.72,2025.72,2025.72]
[null,"SNC-Lavalin - Inv #1179246",6664.31,6664.31,6664.31,6664.31,6664.31,6664.31,6664.31,6664.31,6664.31,6664.31,6664.31,6664.31,6664.31,6664.31,6664.31,6664.31,6664.31,6664.31,6664.31,6664.31,6664.31,6664.31,6664.31,6664.31,6664.31]
[null,"SNC-Lavalin - Inv #1184110",2891.9,2891.9,2891.9,2891.9,2891.9,2891.9,2891.9,2891.9,2891.9,2891.9,2891.9,2891.9,2891.9,2891.9,2891.9,2891.9,2891.9,2891.9,2891.9,2891.9,2891.9,2891.9,2891.9,2891.9,2891.9]
[null,"SNC-Lavalin - Inv #1192504",2619.35,2619.35,2619.35,2619.35,2619.35,2619.35,2619.35,2619.35,2619.35,2619.35,2619.35,2619.35,2619.35,2619.35,2619.35,2619.35,2619.35,2619.35,2619.35,2619.35,2619.35,2619.35,2619.35,2619.35,2619.35]
[null,"SNC-Lavalin - Inv #1200425",4922.6099999999997,4922.6099999999997,4922.6099999999997,4922.6099999999997,4922.6099999999997,4922.6099999999997,4922.6099999999997,4922.6099999999997,4922.6099999999997,4922.6099999999997,4922.6099999999997,4922.6099999999997,4922.6099999999997,4922.6099999999997,4922.6099999999997,4922.6099999999997,4922.6099999999997,4922.6099999999997,4922.6099999999997,4922.6099999999997,4922.6099999999997,4922.6099999999997,4922.6099999999997,4922.6099999999997,4922.6099999999997]
[null,"SNC-Lavalin - Inv #1202608",2921.78,2921.78,2921.78,2921.78,2921.78,2921.78,2921.78,2921.78,2921.78,2921.78,2921.78,2921.78,2921.78,2921.78,2921.78,2921.78,2921.78,2921.78,2921.78,2921.78,2921.78,2921.78,2921.78,2921.78,2921.78]
[null,"SNC-Lavalin - Inv #1171542",1186.26,1186.26,1186.26,1186.26,1186.26,1186.26,1186.26,1186.26,1186.26,1186.26,1186.26,1186.26,1186.26,1186.26,1186.26,1186.26,1186.26,1186.26,1186.26,1186.26,1186.26,1186.26,1186.26,1186.26,1186.26]
[null,"SNC-Lavalin - Inv #1207283",1162,1162,1162,1162,1162,1162,1162,1162,1162,1162,1162,1162,1162,1162,1162,1162,1162,1162,1162,1162,1162,1162,1162,1162,1162]
[null,"SNC-Lavalin - Inv #1228955",0,0,0,0,1613.7,1613.7,1613.7,1613.7,1613.7,1613.7,1613.7,1613.7,1613.7,1613.7,1613.7,1613.7,1613.7,1613.7,1613.7,1613.7,1613.7,1613.7,1613.7,1613.7,1613.7]
[null,"SNC-Lavalin - Inv #1232433",0,0,0,0,0,1945.05,1945.05,1945.05,1945.05,1945.05,1945.05,1945.05,1945.05,1945.05,1945.05,1945.05,1945.05,1945.05,1945.05,1945.05,1945.05,1945.05,1945.05,1945.05,1945.05]
[null,"SNC-Lavalin - Inv #1268298",0,0,0,0,0,0,0,0,0,0,0,0,0,219,219,219,219,219,219,219,219,219,219,219,219]
[null,"SNC-Lavalin - Inv #1248789",0,0,0,0,0,0,0,0,0,0,0,0,3780.46,3780.46,3780.46,3780.46,3780.46,3780.46,3780.46,3780.46,3780.46,3780.46,3780.46,3780.46,3780.46]
[null,"SNC-Lavalin - Inv #1240539",0,0,0,0,0,0,0,0,0,0,0,0,5205.8999999999996,5205.8999999999996,5205.8999999999996,5205.8999999999996,5205.8999999999996,5205.8999999999996,5205.8999999999996,5205.8999999999996,5205.8999999999996,5205.8999999999996,5205.8999999999996,5205.8999999999996,5205.8999999999996]
[]
[null,"sub-total",{"$f":"SUM(C59:C79)","v":59751.4},{"$f":"SUM(D59:D79)","v":59751.4},59751.4,59751.4,61365.1,63310.15,63310.15,63310.15,63310.15,63310.15,63310.15,{"$f":"SUM(N59:N79)","v":63310.15},72296.509999999995,72515.509999999995,72515.509999999995,72515.509999999995,72515.509999999995,72515.509999999995,72515.509999999995,72515.509999999995,72515.509999999995,72515.509999999995,72515.509999999995,72515.509999999995,72515.509999999995]
[]
[null,"2014-0199 - Review of QRAM Process"]
[null,"Fasken Martineau DuMoulin - Inv #834063",14820,14820,14820,14820,14820,14820,14820,14820,14820,14820,14820,14820,14820,14820,14820,14820,14820,14820,14820,14820,14820,14820,14820,14820,14820]
[null,"Fasken Martineau DuMoulin - Inv #839124",1330,1330,1330,1330,1330,1330,1330,1330,1330,1330,1330,1330,1330,1330,1330,1330,1330,1330,1330,1330,1330,1330,1330,1330,1330]
[null,"Fasken Martineau DuMoulin - Inv #849444",5700,5700,5700,5700,5700,5700,5700,5700,5700,5700,5700,5700,5700,5700,5700,5700,5700,5700,5700,5700,5700,5700,5700,5700,5700]
[null,"Fasken Martineau DuMoulin - Inv #853098",1140,1140,1140,1140,1140,1140,1140,1140,1140,1140,1140,1140,1140,1140,1140,1140,1140,1140,1140,1140,1140,1140,1140,1140,1140]
[null,"Fasken Martineau DuMoulin - Inv #816984",95,95,95,95,95,95,95,95,95,95,95,95,95,95,95,95,95,95,95,95,95,95,95,95,95]
[]
[null,"sub-total",{"$f":"SUM(C83:C88)","v":23085},{"$f":"SUM(D83:D88)","v":23085},23085,23085,23085,23085,23085,23085,23085,23085,23085,23085,23085,23085,23085,23085,23085,23085,23085,23085,23085,23085,23085,23085,23085]
[]
[null,"2014-0289 Natural Gas Market Review"]
[null,"Fasken Martineau DuMoulin - Inv #864049",1995,1995,1995,1995,1995,1995,1995,1995,1995,1995,1995,1995,1995,1995,1995,1995,1995,1995,1995,1995,1995,1995,1995,1995,1995]
[null,"Fasken Martineau DuMoulin - Inv #883674",7885,7885,7885,7885,7885,7885,7885,7885,7885,7885,7885,7885,7885,7885,7885,7885,7885,7885,7885,7885,7885,7885,7885,7885,7885]
[null,"Fasken Martineau Dumoulin - Inv #887975",2700,2700,2700,2700,2700,2700,2700,2700,2700,2700,2700,2700,2700,2700,2700,2700,2700,2700,2700,2700,2700,2700,2700,2700,2700]
[null,"Fasken Martineau DuMoulin LLP - Inv #913514",180,180,180,180,180,180,180,180,180,180,180,180,180,180,180,180,180,180,180,180,180,180,180,180,180]
[null,"Fasken Martineau DuMoulin LLP - Inv #922460",90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90]
[null,"Ontario Energy Board - #CA1516Q2003",952.46,952.46,952.46,952.46,952.46,952.46,952.46,952.46,952.46,952.46,952.46,952.46,952.46,952.46,952.46,952.46,952.46,952.46,952.46,952.46,952.46,952.46,952.46,952.46,952.46]
[]
[null,"sub-total",{"$f":"SUM(C92:C98)","v":13802.46},{"$f":"SUM(D92:D98)","v":13802.46},13802.46,13802.46,13802.46,13802.46,13802.46,13802.46,13802.46,13802.46,13802.46,13802.46,13802.46,13802.46,13802.46,13802.46,13802.46,13802.46,13802.46,13802.46,13802.46,13802.46,13802.46,13802.46,13802.46]
[]
[null,"DSM Account"]
[null,"Redman/Williams - #IN138280",3532.03,3532.03,3532.03,3532.03,3532.03,3532.03,3532.03,3532.03,3532.03,3532.03,3532.03,3532.03,3532.03,3532.03,3532.03,3532.03,3532.03,3532.03,3532.03,3532.03,3532.03,3532.03,3532.03,3532.03,3532.03]
[]
[null,"sub-total",{"$f":"SUM(C102:C103)","v":3532.03},{"$f":"SUM(D102:D103)","v":3532.03},3532.03,3532.03,3532.03,3532.03,3532.03,3532.03,3532.03,3532.03,3532.03,3532.03,3532.03,3532.03,3532.03,3532.03,3532.03,3532.03,3532.03,3532.03,3532.03,3532.03,3532.03,3532.03,3532.03]
[]
[null,"Application for Service - put to capital cost of Pipeline"]
[null,"Osler, Hoskin & Harcourt LLP - #11842664",0,0,50080.58,50080.58,50080.58,50080.58,50080.58,50080.58,50080.58,50080.58,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Osler, Hoskin & Harcourt LLP - #11850956",0,0,0,15217.94,15217.94,15217.94,15217.94,15217.94,15217.94,15217.94,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"John A. Gandry - #November 2015",0,0,0,275,275,275,275,275,275,275,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Osler, Hoskin & Harcourt LLP - #11860762",0,0,0,0,774.5,774.5,774.5,774.5,774.5,774.5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Osler, Hoskin & Harcourt LLP - #11869746",0,0,0,0,0,2248.65,2248.65,2248.65,2248.65,2248.65,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Osler, Hoskin & Harcourt LLP - #1168788",0,0,0,0,0,0,13393.96,13393.96,13393.96,13393.96,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Osler, Hoskin & Harcourt LLP - #11886676",0,0,0,0,0,0,0,2723.41,2723.41,2723.41,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Osler, Hoskin & Harcourt LLP - #11899047",0,0,0,0,0,0,0,0,2970.9,2970.9,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Lenczner Slaught Royce Smith Griffin LLP - Inv #40668",0,0,0,0,0,0,0,0,5435.11,5435.11,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Osler, Hoskin & Harcourt LLP - #11908625",0,0,0,0,0,0,0,0,0,2807.7,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"sub-total",{"$f":"SUM(C107:C117)","v":0},0,50080.58,65573.52,66348.02,68596.67,81990.63,84714.040000000008,93120.05,95927.75,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Other REDA Items"]
[]
[null,"Cap & Trade Deferral (moved to C&T in 2017)",null,0,0,0,0,0,0,0,0,0,0,4290,6517.5,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"EB-2015-0238 Distribution Gas Supply Planning - OEB - Inv #CA1617Q4003",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,119]
[null,"EB=2014-0255 Corporate Governance - OEB - Inv #CA1718Q1003",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,106,106,106,106,106,106]
[null,"EB-2016-0004 OEB - Inv #CA1718Q1003 ",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,2817,2817,2817,2817,2817,2817]
[null,"EB-2015-0245 - OEB - Inv #CA1718Q3003",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"EB-2016-0359 - OEB - Inv #CA1718Q3003",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"DSM Evaluation Technical Committee - OEB - Inv #CA1718Q2003",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,192,192,192]
[null,"Cyber Security Framework - OEB - Inv #CA1718Q2003 ",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,879,879,879]
[]
[null,"sub-total",{"$f":"SUM(C122:C129)","v":0},{"$f":"SUM(D121:D129)","v":0},{"$f":"SUM(E121:E129)","v":0},0,0,0,0,0,0,0,0,4290,6517.5,0,0,0,0,0,0,2923,2923,2923,3994,3994,4113]
[]
[null,"Total REDA",{"$f":"C130+C104+C99+C89+C80+C56+C47+C29+C19+C10+C118","v":166923.68999999997},166923.68999999997,217004.26999999996,232497.20999999996,234885.40999999997,239079.11,252473.06999999998,255196.47999999998,233862.01999999996,236669.71999999997,140741.96999999997,145031.96999999997,154710.52999999997,{"$f":"P130+P104+P99+P89+P80+P56+P47+P29+P19","v":148412.02999999997},148412.02999999997,148412.02999999997,148412.02999999997,148412.02999999997,148412.02999999997,151335.02999999997,151335.02999999997,151335.02999999997,152406.02999999997,152406.02999999997,152525.02999999997]
[]
[null,"REDA Interest Expense","Interest Rate",1.0999999999999999E-2]
[null,"NRG Calculated",null,0,{"$f":"E136-D136","v":0},{"$f":"F136-E136","v":0},0,0,0,0,0,0,-32839.61,123.42999999999984,119.44999999999982,123.43000000000029,178.57999999999993,135.34000000000015,135.34000000000015,122.23999999999978,135.34000000000015,130.97000000000025,135.34000000000015,130.96999999999935,135.34000000000015,135.34000000000015,130.97000000000025]
[null,"REDA Interest Balance",36717.67,36717.67,36717.67,36717.67,36717.67,36717.67,36717.67,36717.67,36717.67,36717.67,3878.06,4001.49,4120.9399999999996,4244.37,4422.95,4558.29,4693.63,4815.87,4951.21,5082.18,5217.5200000000004,5348.49,5483.83,5619.17,5750.14]
[]
[]
[]
[null,{"$f":"MID(CELL(\"filename\",A2),FIND(\"]\",CELL(\"filename\",A2))+1,255)","v":"A1.2 REDA"}]

{"sheet":"A1.3 PGTVA","index":2,"n_rows":48,"n_cols":27,"rows_kept":48,"cut":false,"hidden":false,"merged":[]}
["EPCOR Natural Gas Limited Partnership"]
["Purchased Gas Transportation Variance Account Calculation"]
[]
[null,"TO MATCH"]
[null,"OEB AUDIT REPORT, March 2017"]
[null,"2015","2015","2015","2015","2016","2016","2016","2016","2016","2016","2016","2016","2016","2016","2016","2016","2016","2017","2017","2017","2017","2017","2017","2017","2017","2017"]
[null,"TOTAL","OCT","NOV","DEC","JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","TOTAL","OCT","NOV","DEC","JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP"]
["PGTVA"]
["Transportation Cost"]
["Union Gas - Delivery",null,4756.03,4951.28,4812.6099999999997,6996.97,5950.61,4564.12,3463.58,1521.24,857.86,825.88,990.78,1560.44,{"$f":"SUM(C10:N10)","v":41251.399999999994},4119.87,5246.96,7028.36,136822.88,107245.26000000001,122305.27,62695.3,53568.420000000006,31945.95,-5428.87,1074.71,40858.730000000003]
["Union Gas - Adjmts ",null,16292.03,0,0,1634.18,100.98,0,0,0,0,0,0,0,18027.189999999999,-1147.44,0,0,-126361.59999999999,-98725.06,-113274.38,-57937.19,-49502.97,-29521.49,5034.9100000000017,-951.25000000000011,-37694.870000000003]
["Union Gas - Demand",null,27300.28,27300.28,27300.28,29306.39,29306.39,29306.39,29306.39,29306.39,29306.39,29306.39,29306.39,29306.39,{"$f":"SUM(C12:N12)","v":345658.35000000009},29306.39,33229.019999999997,33229.019999999997,42533.16,42533.16,42533.16,42533.16,42533.16,42533.16,42533.16,42533.16,42533.16]
["Total Transportation Cost",null,{"$f":"SUM(C10:C12)","v":48348.34},32251.559999999998,32112.89,37937.54,35357.979999999996,33870.51,32769.97,30827.63,30164.25,30132.27,30297.17,30866.829999999998,404936.94000000006,32278.82,38475.979999999996,40257.379999999997,52994.440000000017,51053.360000000015,51564.05,47291.270000000004,46598.610000000008,44957.62,42139.200000000004,42656.62,45697.020000000004]
["Volumes Transported (m3)",null,2508653.2000000002,2606055.2000000002,2541817.2999999998,4089316.8,3499077.3,2712688.2,2269700.9,1005487.2999999999,526943.1,484672.6,705101.8,1100143,null,2325858.506849315,2901490.5,3844007.2,3958131.3,3100332.4,3561919.5,1880789.9,1637092.5999999999,1022493.3,-14133.29999999993,159937.5,1263122.3]
["Average Cost ($/m3)",null,{"$f":"C13/C14","v":1.9272628038024545E-2},1.2375624276876405E-2,1.2633830920892703E-2,9.2772318349118865E-3,1.0104943951938415E-2,1.2485957656320398E-2,1.4438012515217315E-2,3.0659392714358503E-2,5.7243846631638222E-2,6.217035995020144E-2,4.2968504689677431E-2,2.8057107121528747E-2,null,{"$f":"P13/P14","v":1.3878238897569894E-2},1.3260763735052724E-2,1.0472763942793863E-2,1.3388752414554823E-2,1.6467060112651151E-2,1.447647820227268E-2,2.514436620485893E-2,2.8464248143324336E-2,4.3968620625680382E-2,-2.9815542017787928,0.26670805783509183,3.6177826961015576E-2]
["Reference Price - corrected per EB-2017-0215",null,1.8339000000000001E-2,1.8339000000000001E-2,1.8339000000000001E-2,1.8339000000000001E-2,1.8339000000000001E-2,1.8339000000000001E-2,1.8339000000000001E-2,1.8339000000000001E-2,1.8339000000000001E-2,1.8339000000000001E-2,1.8339000000000001E-2,1.8339000000000001E-2,null,{"$f":"N16","v":1.8339000000000001E-2},{"$f":"P16","v":1.8339000000000001E-2},{"$f":"Q16","v":1.8339000000000001E-2},1.8339000000000001E-2,1.8339000000000001E-2,1.8339000000000001E-2,1.8339000000000001E-2,1.8339000000000001E-2,1.8339000000000001E-2,1.8339000000000001E-2,1.8339000000000001E-2,1.8339000000000001E-2]
["Rate Difference",null,{"$f":"C16-C15","v":-9.3362803802454417E-4},5.9633757231235957E-3,5.7051690791072984E-3,9.0617681650881146E-3,8.234056048061586E-3,5.8530423436796031E-3,3.9009874847826861E-3,-1.2320392714358502E-2,-3.8904846631638221E-2,-4.3831359950201439E-2,-2.462950468967743E-2,-9.7181071215287455E-3,null,{"$f":"P16-P15","v":4.4607611024301067E-3},5.0782362649472775E-3,7.8662360572061378E-3,4.9502475854451781E-3,1.8719398873488502E-3,3.8625217977273207E-3,-6.8053662048589286E-3,-1.0125248143324335E-2,-2.5629620625680381E-2,2.9998932017787929,-0.24836905783509183,-1.7838826961015575E-2]
[]
["PGTVA",null,{"$f":"C17*C14","v":-2342.1489651999946},15540.886312800008,14501.497464699998,37056.440795199997,28811.598604700004,15877.478899800006,8854.0748050999991,-12387.998405300001,-20500.640489100002,-21243.859188599999,-17366.308089799997,-10691.307522999999,{"$f":"SUM(C19:N19)","v":36109.714221300033},{"$f":"P17*P14","v":10375.099157109593},14734.454279500009,30237.868040800007,19593.729910699982,5803.6358835999899,13757.991710499999,-12799.464023900004,-16575.968808600006,-26206.115371299999,-42398.390588700007,-39723.5261875,-22532.620140300005]
["Balance",428722.04,{"$f":"B20+C19","v":426379.89103479998},{"$f":"C20+D19","v":441920.77734759997},456422.27481229999,493478.71560749999,522290.3142122,538167.79311199998,547021.86791709997,534633.8695118,514133.22902269999,492889.36983410001,475523.06174430001,464831.75422130001,{"$f":"B20+O19","v":464831.75422130001},{"$f":"O20+P19","v":475206.85337840958},489941.30765790958,520179.17569870956,539772.90560940956,545576.54149300954,559334.53320350952,546535.06917960953,529959.10037100955,503752.98499970953,461354.59441100952,421631.06822350953,399098.44808320951]
["PGTVA Interest"]
["Interest rate",null,1.0999999999999999E-2,{"$f":"C22","v":1.0999999999999999E-2},{"$f":"D22","v":1.0999999999999999E-2},1.0999999999999999E-2,1.0999999999999999E-2,1.0999999999999999E-2,1.0999999999999999E-2,1.0999999999999999E-2,1.0999999999999999E-2,1.0999999999999999E-2,1.0999999999999999E-2,1.0999999999999999E-2,null,{"$f":"N22","v":1.0999999999999999E-2},{"$f":"P22","v":1.0999999999999999E-2},{"$f":"Q22","v":1.0999999999999999E-2},1.0999999999999999E-2,1.0999999999999999E-2,1.0999999999999999E-2,1.0999999999999999E-2,1.0999999999999999E-2,1.0999999999999999E-2,1.0999999999999999E-2,1.0999999999999999E-2,1.0999999999999999E-2]
["Interest",null,{"$f":"ROUND(B20*C22/12,2)","v":393},390.85,405.09,418.39,452.36,478.77,493.32,501.44,490.08,471.29,451.82,435.9,{"$f":"SUM(C23:N23)","v":5382.3099999999995},{"$f":"ROUND(O20*P22/12,2)","v":426.1},435.61,449.11,476.83,494.79,500.11,512.72,500.99,485.8,461.77,422.91,386.5]
["Balance",18886.810000000001,{"$f":"B24+C23","v":19279.810000000001},19670.66,20075.75,20494.14,20946.5,21425.27,21918.59,22420.03,22910.11,23381.4,23833.22,24269.120000000003,{"$f":"B24+O23","v":24269.120000000003},{"$f":"O24+P23","v":24695.22},25130.83,25579.940000000002,26056.770000000004,26551.560000000005,27051.670000000006,27564.390000000007,28065.380000000008,28551.180000000008,29012.950000000008,29435.860000000008,29822.360000000008]
[]
["Total PGTVA and Interest",{"$f":"B20+B24","v":447608.85},445659.70103479997,461591.43734759995,476498.02481229999,513972.85560750001,543236.8142122,559593.063112,568940.45791709994,557053.89951180003,537043.33902269998,516270.76983410004,499356.28174430004,489100.87422130001,489100.87422130001,499902.07337840961,515072.1376579096,545759.11569870962,565829.67560940958,572128.1014930096,586386.20320350956,574099.45917960955,558024.48037100956,532304.16499970958,490367.54441100953,451066.92822350952,428920.8080832095]
[]
["PGTVA (IGPC)"]
["Transportation Cost"]
["Union Gas - Delivery IGPC",null,12897.99,6154.32,6979.81,6114.8,5341.3,16138.919999999998,10418.93,5561.18,5396.33,5862.08,5766.54,4717.17,{"$f":"SUM(C30:N30)","v":91349.37},6792.3,6833.94,6828.85,125815.77,97241.38,104438.38,113400.04,121104.51,108862.96,107035.49,109492.75,106248.15]
["Union Gas - Adjmts IGPC",null,17718.3,-7153.8,2738.16,597.87,769.75,0,-2115.14,0,0,0,0,0,12555.140000000001,-1663.18,0,0,-116196.09,-89806.45,-96453.18,-104793.81,-111913.58,-100601.06,-98747.28,-101014.26,-98020.91]
["Union Gas - Demand IGPC",null,17570.27,18489,18489,19847.62,19847.62,19847.62,19847.62,23334.400000000001,23334.400000000001,23334.400000000001,23334.400000000001,23334.400000000001,{"$f":"SUM(C32:N32)","v":250610.74999999997},23334.400000000001,23334.400000000001,23334.400000000001,29868.05,29868.05,29868.05,29868.05,29868.05,29868.05,29868.05,29868.05,29868.05]
["Total Transportation Cost",null,{"$f":"SUM(C30:C32)","v":48186.559999999998},17489.52,28206.97,26560.29,25958.67,35986.539999999994,28151.41,28895.58,28730.730000000003,29196.480000000003,29100.940000000002,28051.57,354515.25999999995,28463.52,30168.34,30163.25,39487.73000000001,37302.98000000001,37853.250000000015,38474.28,39058.979999999996,38129.950000000012,38156.260000000009,38346.540000000008,38095.289999999994]
["IGPC Volumes Transported (m3)",null,2791422.9,3048200.7,3464668.5,3479093.5999999996,3010080.9,3396853.5999999996,3238318.5000000005,3415955.5,3314698.4,3440185.2,3384119.1,2768291.7,null,3571137.8,3593029.1,3590352.4,3501886.2,2706562.6,2906879.8,3158247.6,3372821.1,3031887.6,2976018.7,3044340.4,2954127.6]
["Actual Price",null,{"$f":"ROUND(+(C32+C30+C31)/C34,6)","v":1.7262E-2},5.738E-3,8.1410000000000007E-3,7.6340000000000002E-3,8.6239999999999997E-3,1.0593999999999999E-2,8.6929999999999993E-3,8.4589999999999995E-3,8.6680000000000004E-3,8.4869999999999998E-3,8.5990000000000007E-3,1.0133E-2,null,{"$f":"ROUND(+(P32+P30+P31)/P34,6)","v":7.9699999999999997E-3},8.3960000000000007E-3,8.4010000000000005E-3,1.1276E-2,1.3782000000000001E-2,1.3022000000000001E-2,1.2182E-2,1.1580999999999999E-2,1.2576E-2,1.2821000000000001E-2,1.2596E-2,1.2895999999999999E-2]
["Reference Price - corrected per EB-2017-0215",null,9.8849999999999997E-3,9.8849999999999997E-3,9.8849999999999997E-3,9.8849999999999997E-3,9.8849999999999997E-3,9.8849999999999997E-3,9.8849999999999997E-3,9.8849999999999997E-3,9.8849999999999997E-3,9.8849999999999997E-3,9.8849999999999997E-3,9.8849999999999997E-3,null,{"$f":"N36","v":9.8849999999999997E-3},{"$f":"M36","v":9.8849999999999997E-3},{"$f":"P36","v":9.8849999999999997E-3},{"$f":"R36","v":9.8849999999999997E-3},{"$f":"S36","v":9.8849999999999997E-3},9.8849999999999997E-3,9.8849999999999997E-3,9.8849999999999997E-3,9.8849999999999997E-3,9.8849999999999997E-3,9.8849999999999997E-3,9.8849999999999997E-3]
["Rate Difference",null,{"$f":"C36-C35","v":-7.3769999999999999E-3},4.1469999999999996E-3,1.743999999999999E-3,2.2509999999999995E-3,1.261E-3,-7.0899999999999956E-4,1.1920000000000004E-3,1.4260000000000002E-3,1.2169999999999993E-3,1.3979999999999999E-3,1.2859999999999989E-3,-2.4799999999999996E-4,null,{"$f":"P36-P35","v":1.915E-3},1.488999999999999E-3,1.4839999999999992E-3,-1.3909999999999999E-3,-3.8970000000000012E-3,-3.1370000000000009E-3,-2.2970000000000004E-3,-1.6959999999999996E-3,-2.6910000000000007E-3,-2.9360000000000011E-3,-2.7109999999999999E-3,-3.0109999999999998E-3]
[]
["PGTVA (IGPC)",null,{"$f":"+C37*C34","v":-20592.3267333},12640.888302899999,6042.3818639999963,7831.4396935999976,3795.7120148999998,-2408.3692023999984,3860.0756520000018,4871.1525430000011,4033.9879527999979,4809.3789096,4351.9771625999965,-686.5363415999999,{"$f":"SUM(C39:N39)","v":28549.761818099993},{"$f":"+P37*P34","v":6838.7288870000002},5350.0203298999968,5328.0829615999974,-4871.1237042000002,-10547.474452200004,-9118.8819326000012,-7254.4947372000015,-5720.304585599999,-8158.8095316000026,-8737.5909032000036,-8253.2068244000002,-8894.8782035999993]
["Balance",526067.03,{"$f":"B40+C39","v":505474.70326670003},518115.59156960004,524157.97343360004,531989.41312719998,535785.12514210003,533376.75593970006,537236.83159170009,542107.98413470003,546141.97208750003,550951.3509971,555303.32815970003,554616.79181810003,{"$f":"B40+O39","v":554616.79181810003},{"$f":"O40+P39","v":561455.52070510003},566805.541035,572133.62399660004,567262.50029240001,556715.02584020002,547596.14390759997,540341.64917039999,534621.34458479995,526462.53505319997,517724.94415,509471.7373256,500576.85912199999]
["PGTVA (IGPC) Interest"]
["Interest IGPC",null,{"$f":"ROUND(B40*C22/12,2)","v":482.23},463.35,474.94,480.48,487.66,491.14,488.93,492.47,496.93,500.63,505.04,509.03,{"$f":"SUM(C42:N42)","v":5872.83},{"$f":"ROUND(O40*P22/12,2)","v":508.4},514.66999999999996,519.57000000000005,524.46,519.99,510.32,501.96,495.31,490.07,482.59,474.58,467.02]
["Balance",31852.77,{"$f":"B43+C42","v":32335},32798.35,33273.29,33753.770000000004,34241.430000000008,34732.570000000007,35221.500000000007,35713.970000000008,36210.900000000009,36711.530000000006,37216.570000000007,37725.600000000006,{"$f":"B43+O42","v":37725.599999999999},{"$f":"O43+P42","v":38234},38748.67,39268.239999999998,39792.699999999997,40312.689999999995,40823.009999999995,41324.969999999994,41820.279999999992,42310.349999999991,42792.939999999988,43267.51999999999,43734.539999999986]
[]
["Total PGTVA (IGPC) and Interest",{"$f":"B40+B43","v":557919.80000000005},537809.70326670003,550913.94156960002,557431.26343360008,565743.1831272,570026.55514210009,568109.32593970001,572458.33159170009,577821.9541347,582352.87208750006,587662.88099710003,592519.89815969998,592342.3918181,592342.3918181,599689.52070510003,605554.21103500004,611401.86399660003,607055.20029239997,597027.71584019996,588419.15390759998,581666.61917039996,576441.62458479998,568772.88505319995,560517.88414999994,552739.25732560002,544311.39912199997]
[]
[]
[{"$f":"MID(CELL(\"filename\",A2),FIND(\"]\",CELL(\"filename\",A2))+1,255)","v":"A1.3 PGTVA"}]