{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["STAFF-RHDR-02-005"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"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":"STAFF-RHDR-02-005","index":0,"n_rows":58,"n_cols":14,"rows_kept":58,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"2019-01-31","2019-02-28","2019-03-31","2019-04-30","2019-05-31","2019-06-30","2019-07-31","2019-08-31","2019-09-30","2019-10-31","2019-11-30","2019-12-31",2019]
[]
["Aggregate - AFUDC Eligible Spend:"]
["CWIP Beginning Balance",73794159.999999985,75368342.429418787,79778469.87903142,80528406.449457705,92598708.856203496,51657981.172894597,46005748.975874797,54316809.962694317,63769562.266894899,50693983.911118299,62138010.911813699,72280412.153772697]
[]
["Prior Period Cash Cap. Ex.",14465680,6584591.3054418992,9112168.1742418986,11051992.527241899,16624730.4135419,14309290.010634899,13371044.424561804,11998889.122603601,12214389.935312301,16643007.2686159,15805311.315583702,13767095.152870601]
[0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5]
[null,{"$f":"-B9*B10","v":-7232840},{"$f":"-C9*C10","v":-3292295.6527209496},{"$f":"-D9*D10","v":-4556084.0871209493},{"$f":"-E9*E10","v":-5525996.2636209494},{"$f":"-F9*F10","v":-8312365.20677095},{"$f":"-G9*G10","v":-7154645.0053174496},{"$f":"-H9*H10","v":-6685522.2122809021},{"$f":"-I9*I10","v":-5999444.5613018004},{"$f":"-J9*J10","v":-6107194.9676561505},{"$f":"-K9*K10","v":-8321503.6343079498},{"$f":"-L9*L10","v":-7902655.6577918511},{"$f":"-M9*M10","v":-6883547.5764353005}]
[]
["Current Period Closings",-5328084.7092841007,-5039474.4024809003,-10642811.174106002,-4911993.4391684998,-55532281.779940501,-19212785.947576899,-3889046.8335455009,-2995087.2603728999,-29941340.738213699,-4582540.4089013999,-3886920.4169335999,-57431215.665210098]
[]
["AFUDC Base for Calculation",{"$f":"B7+B11+B13","v":61233235.290715888},67036572.374216944,64579574.617804468,70090416.746668264,28754061.869492039,25290550.220000248,35431179.930048399,45322278.14101962,27721026.56102505,37789939.867908947,50348434.837088242,7965648.9121273011]
[]
["AFUDC Debt:"]
["AFUDC Debt Rate",1.7792105701349146E-3,1.7262631648349066E-3,1.8095796868377236E-3,1.7495536433649339E-3,3.3665634154806832E-3,2.5698198983192919E-3,1.9476597848037216E-3,1.7664926523704284E-3,2.7558067053118241E-3,2.0079339317429484E-3,1.7861626038343968E-3,7.9813549444299105E-3]
["AFUDC Debt, Calculated",{"$f":"B15*B18","v":108946.81947279998},{"$f":"C15*C18","v":115722.76558640001},{"$f":"D15*D18","v":116861.88641300001},{"$f":"E15*E18","v":122626.94398410004},{"$f":"F15*F18","v":96802.372736299993},{"$f":"G15*G18","v":64992.159194799984},{"$f":"H15*H18","v":69007.884277899997},{"$f":"I15*I18","v":80061.471324800033},{"$f":"J15*J18","v":76393.790875000006},{"$f":"K15*K18","v":75879.702539300008},{"$f":"L15*L18","v":89930.49146759999},{"$f":"M15*M18","v":63576.671330399971},{"$f":"SUM(B19:M19)","v":1080802.9592023999}]
[]
["AFUDC Equity:"]
["AFUDC Equity Rate",3.4087536416640596E-3,3.3073127758822089E-3,3.4669372197548209E-3,3.3519345338999967E-3,6.4499309385111312E-3,4.9234661056258644E-3,3.7314820941476731E-3,3.384387639556312E-3,5.2797944774628123E-3,3.8469601164238159E-3,3.4220729027981877E-3,1.5291316940740072E-2]
["AFUDC Equity, Calculated",{"$f":"B15*B22","v":208729.01378809998},221710.91226460005,223893.33087840001,234938.4883886,185461.71325989993,124517.16680079997,132210.81348350001,153388.15793700004,146361.3229465,145376.3914739,172296.01455429997,121805.26215399992,{"$f":"SUM(B23:M23)","v":2070688.5879295999}]
[]
["AFUDC Total",{"$f":"B19+B23","v":317675.83326089999},337433.67785100004,340755.21729140001,357565.43237270007,282264.08599619992,189509.32599559997,201218.69776140002,233449.62926180009,222755.11382150001,221256.09401320003,262226.50602189999,185381.93348439989,{"$f":"N19+N23","v":3151491.5471319999}]
[]
[null,null,null,null,null,null,null,null,null,"Allocated to Major Projects at Tab 27",null,null,null,1593739]
[]
[null,null,null,null,null,null,null,null,null,"Attributable to Normal Recurring Construction",null,null,null,{"$f":"N25-N27","v":1557752.5471319999}]
[]
[]
[]
[null,"2020-01-31","2020-02-29","2020-03-31","2020-04-30","2020-05-31","2020-06-30","2020-07-31","2020-08-31","2020-09-30","2020-10-31","2020-11-30","2020-12-31",2020]
[]
["Aggregate - AFUDC Eligible Spend:"]
["CWIP Beginning Balance",26744120,30760736.372917503,35796894.898793504,36173115.199494988,44189476.369418986,51854885.325267389,47362997.176284894,56076148.361107796,65069521.763457,65848917.381793596,74222805.316140786,81455294.459108099]
[]
["Prior Period Cash Cap. Ex.",11704807.948712399,7070944.4369737981,8019052.7339737993,10027753.203173801,11776138.734830899,11717294.218930902,12673874.371730905,11206580.160730902,11108320.6421309,10773252.874830903,10365581.9822309,9528284.9370309021]
[0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5]
[null,{"$f":"-B38*B39","v":-5852403.9743561996},{"$f":"-C38*C39","v":-3535472.218486899},-4009526.3669868996,-5013876.6015869007,-5888069.3674154496,-5858647.109465451,-6336937.1858654525,-5603290.0803654511,-5554160.3210654501,-5386626.4374154517,-5182790.9911154499,-4764142.4685154511]
[]
["Current Period Closings",-3166862.1993272994,-3113539.9112928002,-9791104.8002147973,-3941523.4689943003,-4268018.1722366996,-17387976.707152497,-2732581.8529745,-2396188.8489282001,-10304523.160502503,-2334343.8342597997,-2677515.4910078999,-50756823.825962506]
[]
["AFUDC Base for Calculation",{"$f":"B36+B40+B42","v":17724853.826316498},24111724.243137807,21996263.731591806,27217715.128913786,34033388.82976684,28608261.508649442,38293478.137444943,48076669.431814149,49210838.281889051,58127947.110118344,66362498.834017433,25934328.164630137]
[]
["AFUDC Debt:"]
["AFUDC Debt Rate",2.2695636199486576E-3,1.8582204752673995E-3,2.1761029811646127E-3,1.9462774238248137E-3,1.8510045259877686E-3,2.2639774222043474E-3,1.8202983380488243E-3,1.7050494440772415E-3,1.8400287359669847E-3,1.7181348901502034E-3,1.6765388309559627E-3,3.3078691617930106E-3]
["AFUDC Debt, Calculated",{"$f":"B44*B47","v":40227.683413115687},{"$f":"C44*C47","v":44804.899682600015},47866.135080799977,52973.22448349998,62995.95675859999,64768.458144100019,69705.554611700019,81973.098487800031,90549.356559700012,99871.654022700008,111259.30621450003,85787.364367599963,{"$f":"SUM(B48:M48)","v":852782.69182671572}]
[]
["AFUDC Equity:"]
["AFUDC Equity Rate",4.3482111585347125E-3,3.5601271251528318E-3,4.1691518059946212E-3,4.7312082955377407E-3,4.4996092854926277E-3,5.5035056306199431E-3,4.4249655736914471E-3,4.1448068889405314E-3,4.4729282234074238E-3,4.1766163166501976E-3,4.0755004028142751E-3,8.0398871158601434E-3]
["AFUDC Equity, Calculated",{"$f":"B44*B51","v":77071.407190986094},85840.803512200044,91705.762661699962,128772.67960349997,153136.95239519994,157445.72829509998,169447.32245509996,199268.51065829996,220116.54744860003,242778.13235349997,270460.39072979992,208509.07086929868,{"$f":"SUM(B52:M52)","v":2004553.3081732844}]
[]
["AFUDC Total",{"$f":"B48+B52","v":117299.09060410177},130645.70319480007,139571.89774249995,181745.90408699994,216132.90915379993,222214.18643920001,239152.87706679996,281241.6091461,310665.90400830004,342649.78637619998,381719.69694429997,294296.43523689866,{"$f":"N48+N52","v":2857336}]
[]
[null,null,null,null,null,null,null,null,null,"Allocated to Major Projects at Tab 27",null,null,null,1464347]
[]
[null,null,null,null,null,null,null,null,null,"Attributable to Normal Recurring Construction",null,null,null,{"$f":"N54-N56","v":1392989}]