{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Capex Model Structure","Summary",">>>outputs>>>","PTRM_Outputs"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":52,"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":"Capex Model Structure","index":0,"n_rows":49,"n_cols":19,"rows_kept":49,"cut":false,"hidden":false,"merged":[[48,18,48,22]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Model Overview"]
[]
[null,"Legend"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Model Structure "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other Info (External sheets)"]

{"sheet":"Summary","index":1,"n_rows":95,"n_cols":2,"rows_kept":95,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Capex Model Summary"]
[]
[]
[]
[null,"Inputs tab"]
[]
[null,"CPI"]
[null,"The CPI% forecast is assumed to be 2.5% with 2014/15 June as a base year for escalation."]
[]
[null,"Overheads"]
[null,"The overheads for forecast years is calculated consistent with TasNetworks CAM"]
[]
[null,"The Corporate Capex is allocated between forms of control consistent with TasNetworks CAM"]
[]
[null,"Real Escalation"]
[null,"The base case does not apply any real material/labour escalation. There is provision within the model to perform scenario analysis."]
[]
[null,"Unbilled Labour adjustment"]
[null,"The unbilled labour adjustment has been performed in line with historical RINs."]
[]
[null,"DAA Adjustment"]
[null,"The amount relating to damage to TN poles is removed from poles (REPOL) and allocated to unregulated capex. This assumption is consistent with Framework and Approach."]
[]
[null,"Mapping Table"]
[]
[null,"Mapping table is used to allocating the WC level capex to RIN asset classes."]
[]
[null,"Allocation Table"]
[]
[null,"Allocation table is used to allocate the WC level capex to AER asset classes."]
[]
[null,"Draft DD17 POW"]
[]
[null,"The raw POW capex data is placed within this tab. The filter macro within this tab filters the data for the selected year and applies following adjustments."]
[null,"- Ignores the Overheads numbers provided within the POW tool  and applies Works and Services overhead's consistent with the Cost allocation method."]
[null,"- Does unbilled labour adjustment"]
[null,"- Has the provision to apply real escalation at the Work category level. However TN has choosen to not apply real escalation and absord any real escalation."]
[]
[null,"As a result this tab produces the capex data at the work catergory level (for all forms of control) including the data at Work category level for works and service delivery overheads. "]
[null,"This however excludes the shared services OH's and corporate capex which is applied later on the RIN Outputs Tab (explained later)."]
[null,"This data is produced at an annaul basis based on the year selected on Input tab (C59)."]
[]
[null,"Selected POW Macro"]
[]
[null,"This tab uses the Work category data copy Macro to copy the WC level data (POW capex + Works and Service Delivery overheads). "]
[]
[null,"WC Data"]
[]
[null,"This data is directly linked to the WC Data tab which feeds this data straight to Capex Map tab."]
[]
[null,"M. Table"]
[]
[null,"Based on the allocation map (on Allocation sheet). This tab populates the allocation %'s at the WC level."]
[]
[null,"Capex Map"]
[]
[null,"This is where using the Allocation %'s this data is allcoated across the AER asset classes."]
[]
[null,"Capex Map (OH)"]
[]
[null,"Same as above is done for the OH's data. I.e. work category level OH's data is allocated to the AER asset classes."]
[]
[null,"Cust Contribution data"]
[]
[null,"The customer contribution forecast data (at the AER asset class level) is directly used in the RIN_Outputs tab."]
[]
[null,"RIN outputs tab"]
[]
[null,"The RIN outputs tab produces the static output (for a selected year) at the AER asset class level. It also allocates the capitalised overheads data (based on % of spend) at the AER asset class level."]
[]
[null,"The DAA adjustment for damaged Tas Networks assets is also performed in this tab."]
[]
[null,"The static data produced on the RIN outputs tab for each year is manually copied and pasted below for each of the year. This is a repetitive process explained below (Process to Run the Model)."]
[]
[null,"This tab also seperates out the capex data for the other forms of control (for each year) and also adds the Corporate Capex (IT/Facilities and Fleet) depending on if the table is for Standard Control/Alternative Control or other forms of control capex."]
[]
[null,"RFM_outputs"]
[]
[null,"The outputs produced from the RIN_outputs tab flows to the RFM-outputs model in a format which is needed for the Roll forward Model. Roll forward model is external to this model. "]
[null,"The outputs produced for the roll forward model are in Nominal terms."]
[]
[null,"PTRM_outputs"]
[]
[null,"The outputs produced from the RIN_outputs tab flows to the PTRM_outputs model in a format which is needed for the PTRM model. PTRM is external to this model. "]
[null,"The outputs produced for the PTRM are in  $ 16/17. Only data from 17/18 onwards is used for PTRM."]
[]
[null,"Process to Run the model "]

{"sheet":">>>outputs>>>","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"PTRM_Outputs","index":3,"n_rows":56,"n_cols":11,"rows_kept":56,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Standard Control Real $ 2016/17 (Outputs for PTRM)"]
[]
[null,"Real $m","2017/18","2018/19",null,null,"2017/18","2018/19",null,"2017/18","2018/19"]
[null,null,"Total Capex including Ohs and capitalised labour","Total Capex including Ohs and capitalised labour",null,null,"Customer Contributions","Customer Contributions",null,"Disposals","Disposals"]
[null,"Overhead Subtransmission Lines (Urban)",0.20313255268058353,0.20835727180530272,null,null,3.0922191076180015E-2,3.1508231635702919E-2,null,0,0]
[null,"Underground Subtransmission Lines (Urban)",0,0,null,null,0,0,null,0,0]
[null,"Urban Zone Substations",0.81376342341383257,4.2431387535163392,null,null,3.5465652152473119E-3,3.5808677897601641E-3,null,0,0]
[null,"Rural Zone Substations",1.1221731354727993,2.0672433290841692,null,null,0,0,null,0,0]
[null,"SCADA",3.3300496124266772,2.0526165646882522,null,null,7.0931304304946239E-3,7.1617355795203282E-3,null,0,0]
[null,"Distribution Switching Stations (Ground)",0.2858655314234777,0.23517197518456687,null,null,2.4825956506731181E-2,2.5066074528321148E-2,null,0,0]
[null,"Overhead High Voltage Lines Urban",6.4007386388077077,6.4620836380264235,null,null,0.40322960271625025,0.40604257540640881,null,0,0]
[null,"Overhead High Voltage Lines Rural",21.085116760435916,20.48454587255949,null,null,1.8637336415123325,1.8504409075481245,null,0,0]
[null,"Voltage Regulators on Distribution Feeders",1.5690970183098492,0.78437955763255873,null,null,0,0,null,0,0]
[null,"Underground High Voltage Lines",8.9752148824211915,8.3316305365072445,null,null,2.6779833834799374,2.6609759184605313,null,0,0]
[null,"Underground High Voltage Lines SWER",0,0,null,null,0,0,null,0,0]
[null,"Distribution Substations HV (Pole)",0.21686911267585177,0.21895725841474123,null,null,5.8839011100922746E-2,5.9408105263882106E-2,null,0,0]
[null,"Distribution Substations HV (Ground)",3.7338592010419926,3.5999517289106557,null,null,0.25816464608446987,0.25912207840874552,null,0,0]
[null,"Distribution Substations LV (Pole)",7.1359267276497791,7.1960767224909672,null,null,0.54390588104101223,0.54154849766573609,null,0,0]
[null,"Distribution Substations LV (Ground)",7.248241832010728,7.0750495596571072,null,null,1.364031500016043,1.3418237036370202,null,0,0]
[null,"Overhead Low Voltage Lines Underbuilt Urban",3.4892194824269045,3.514265058839241,null,null,1.2792193389466017E-2,1.3096905829407608E-2,null,0,0]
[null,"Overhead Low Voltage Lines Underbuilt Rural",3.2240826078778402,3.2141928606422563,null,null,0.24685020545506231,0.24216687341855422,null,0,0]
[null,"Overhead Low Voltage Lines Urban",4.208792104871165,4.2459588480181853,null,null,0.29367610011023682,0.29672811504882068,null,0,0]
[null,"Overhead Low Voltage Lines Rural",6.8576382650901708,6.8715096613917206,null,null,0.69402655623588017,0.69023749658219169,null,0,0]
[null,"Underground Low Voltage Lines",5.7280415729285208,5.6850758183731402,null,null,1.3416194098433631,1.3099364671540914,null,0,0]
[null,"Underground Low Voltage Common Trench",2.2185817166985671,2.1898434282318227,null,null,1.3416194098433631,1.3099364671540914,null,0,0]
[null,"HVST Service Connections",0,0,null,null,0,0,null,0,0]
[null,"HV Service Connections",7.8974996987362864E-2,7.5854852346486451E-2,null,null,0,0,null,0,0]
[null,"HV Metering CA Service Connections",2.3893886268519043E-2,2.3759750142079823E-2,null,null,0,0,null,0,0]
[null,"HV/LV Service Connections",0.14284445883666658,0.13720095912511321,null,null,0,0,null,0,0]
[null,"Business LV Service Connections",0.38409176782842858,0.36924945527742764,null,null,0,0,null,0,0]
[null,"Business LV Metering CA Service Connections",0.69430400801645231,0.6908608731931476,null,null,0,0,null,0,0]
[null,"Domestic LV Service Connections",3.030594524971145,2.9118589405775546,null,null,0,0,null,0,0]
[null,"Domestic LV Metering CA Service Connections",0.5200243859158582,0.51906107603693707,null,null,0,0,null,0,0]
[null,"Wholesale Metering",0,0,null,null,0,0,null,0,0]
[null,"HV Metering",0,0,null,null,0,0,null,0,0]
[null,"HV/LV Metering",0,0,null,null,0,0,null,0,0]
[null,"Business LV Metering",0,0,null,null,0,0,null,0,0]
[null,"Domestic LV Metering",0,0,null,null,0,0,null,0,0]
[null,"Off Peak Metering",0,0,null,null,0,0,null,0,0]
[null,"Emergency Network Spares",0,0,null,null,0,0,null,0,0]
[null,"Ajilis",11.337801037537208,0,null,null,0,0,null,0,0]
[null,"System Land",0,0.87478693445493194,null,null,0,0,null,0,0]
[null,"Motor Vehicles",2.4561750123790125,2.4603166737814206,null,null,0,0,null,0.75459022670694254,0.75459022670694254]
[null,"Minor Assets",15.315454416243471,14.514672937767486,null,null,0,0,null,0,0]
[null,"Non-System Property",1.3103693691042031,1.2203170701955848,null,null,0,0,null,0,0]
[null,"Non-System Land",0,0,null,null,0,0,null,0,0]
[null,"NEM Assets",0,0,null,null,0,0,null,0,0]
[null,"Streetlighting",0,0,null,null,0,0,null,0,0]
[null,"Spare Parts",0,0,null,null,0,0,null,0,0]
[null,"Easements",0,0,null,null,0,0,null,0,0]
[null,"Meters - Contestable",0,0,null,null,0,0,null,0,0]
[null,"Negotiated Services",0,0,null,null,0,0,null,0,0]
[null,"Capex Unregulated Other",0,0,null,null,0,0,null,0,0]
[null,"Total Assets",123.1409320427519,112.47798796687235,null,null,11.166859384056993,11.048781021110912,null,0.75459022670694254,0.75459022670694254]