{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Inputs for section 4.2"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":3,"defined_names":57,"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":"Inputs for section 4.2","index":0,"n_rows":156,"n_cols":27,"rows_kept":156,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"THE INDEPENDENT PRICING AND REGULATORY TRIBUNAL OF NSW"]
[]
[null,null,null,{"$f":"MID(CELL(\"filename\"),SEARCH(\"[\",CELL(\"filename\"))+1, SEARCH(\"]\",CELL(\"filename\"))-SEARCH(\"[\",CELL(\"filename\"))-1)","v":"Attachment A to request form - Inputs for section 4.2.xlsm"}]
[]
[null,null,null,"Scheme-specific inputs for section 4.2 of request form"]
[]
[null,null,null,"Purpose of this workbook"]
[null,null,null,"The purpose of this workbook is to collect information specific to a particular on-selling wholesale scheme to be used in a scheme-specific review."]
[]
[null,null,null,"This workbook is Attachment A to IPART's Request form for scheme-specific price review (January 2018).  The request form is available on our website: "]
[null,null,null,"https://www.ipart.nsw.gov.au/Home."]
[]
[null,null,null,"Colour coding"]
[null,null,null,"This workbook uses standard IPART colour coding:"]
[null,null,null,"Blue cells indicate inputs"]
[null,null,null,"Light blue cells indicate inputs with default values"]
[]
[null,null,null,"To complete this workbook"]
[null,null,null,"The 'Inputs for section 4.2' worksheet"]
[null,null,null,"Enter inputs in the blue/light blue cells only. "]
[]
[null,null,null,"NOTE: ONLY BLUE OR LIGHT BLUE CELLS MAY BE CHANGED BY THE USER."]
[]
[null,null,null,"Index of tables",null,null,null,"Row number"]
[null,null,null,{"$f":"D34","v":"Table 1:  Year and $ basis assumptions"},null,null,null,{"$f":"ROW(D34)","v":34}]
[null,null,null,{"$f":"D40","v":"Table 2:  Scheme characteristics"},null,null,null,{"$f":"ROW(D40)","v":40}]
[null,null,null,{"$f":"D49","v":"Table 3:  Retail input costs ($, )"},null,null,null,{"$f":"ROW(D49)","v":49}]
[null,null,null,{"$f":"D81","v":"Table 4:  Reticulation input costs ($, )"},null,null,null,{"$f":"ROW(D81)","v":81}]
[]
[]
[null,null,null,"Inputs"]
[]
[null,null,null,"Table 1:  Year and $ basis assumptions"]
[null,null,null,null,null,null,null,null,null,null,null,"Comments"]
[null,null,null,"Current financial year (eg, 2017-18)"]
[null,null,null,"Dollar basis of inputs (eg, $2015-16)"]
[]
[]
[null,null,null,"Table 2:  Scheme characteristics",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"The information in this box is related to the data validation options in columns F and G.  Do not change or delete these values."]
[null,null,null,null,null,null,null,null,null,null,null,"Comments",null,null,null,null,null,null,null,null,null,null,"Scheme type","Initial capital cost category","Asset category 5","Operating cost category","Sewerge main configuration"]
[null,null,null,"Brown or green fields",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Brown fields","AFOC","Depreciating","Life cycle","Gravity mains"]
[null,null,null,"Number of customers",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Green fields","Capex","Non-depreciating","Annual average","Pressure mains"]
[null,null,null,"Length of water mains (km)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D42","v":"Brown or green fields"},{"$f":"IF(G42=W42,1,2)","v":2}]
[null,null,null,"Length of sewerage mains (km)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Retail Capital Classification"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D59","v":"Meters"},null,{"$f":"IF(G59=$X$42,1,2)","v":2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D60","v":"Asset category 2"},null,{"$f":"IF(G60=$X$42,1,2)","v":2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D61","v":"Asset category 3"},null,{"$f":"IF(G61=$X$42,1,2)","v":2}]
[null,null,null,{"$f":"\"Table 3:  Retail input costs ($, \"&G37&\")\"","v":"Table 3:  Retail input costs ($, )"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D62","v":"Asset category 4"},null,{"$f":"IF(G62=$X$42,1,2)","v":2}]
[null,null,null,null,null,null,null,null,null,null,null,"Comments",null,null,null,null,null,null,null,null,null,{"$f":"D63","v":"Asset category 5"},null,{"$f":"IF(G63=$X$42,1,2)","v":2},{"$f":"IF(H63=$Y$42,1,2)","v":2}]
[null,null,null,"Stage capital costs","Units",null,"Initial","Replacement",null,null,null,null,null,null,null,null,null,null,null,null,null,"Retic Water Capital Classification"]
[null,null,null,"Meters","$",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D93","v":"Pipes"},null,{"$f":"IF(G93=$X$42,1,2)","v":2}]
[null,null,null,"Asset category 2","$",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D94","v":"Valves"},null,{"$f":"IF(G94=$X$42,1,2)","v":2}]
[null,null,null,"Asset category 3","$",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D95","v":"Asset category 3"},null,{"$f":"IF(G95=$X$42,1,2)","v":2}]
[null,null,null,"Asset category 4","$",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D96","v":"Asset category 4"},null,{"$f":"IF(G96=$X$42,1,2)","v":2}]
[null,null,null,"Asset category 5","$",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D97","v":"Asset category 5"},null,{"$f":"IF(G97=$X$42,1,2)","v":2},{"$f":"IF(H97=$Y$42,1,2)","v":2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Retic Water Opex Classification"]
[null,null,null,"Initial capital cost classification",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D107","v":"Pipes & Valves"},null,null,null,{"$f":"IF(G114=$Z$42,1,2)","v":2}]
[null,null,null,{"$f":"D52","v":"Meters"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D108","v":"Asset category 2"},null,null,null,{"$f":"IF(G115=$Z$42,1,2)","v":2}]
[null,null,null,{"$f":"D53","v":"Asset category 2"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D109","v":"Asset category 3"},null,null,null,{"$f":"IF(G116=$Z$42,1,2)","v":2}]
[null,null,null,{"$f":"D54","v":"Asset category 3"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D110","v":"Asset category 4"},null,null,null,{"$f":"IF(G117=$Z$42,1,2)","v":2}]
[null,null,null,{"$f":"D55","v":"Asset category 4"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D111","v":"Asset category 5"},null,null,null,{"$f":"IF(G118=$Z$42,1,2)","v":2}]
[null,null,null,{"$f":"D56","v":"Asset category 5"},null,null,null,"Non-depreciating",null,null,null,null,null,null,null,null,null,null,null,null,null,"Retic Sewerage Capital Classification"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D131","v":"Pipes"},null,{"$f":"IF(G131=$X$42,1,2)","v":2},null,null,{"$f":"IF(H131=$AA$42,1,2)","v":2}]
[null,null,null,"Asset lives",null,null,"Regulatory","Tax",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D132","v":"Pumping stations"},null,{"$f":"IF(G132=$X$42,1,2)","v":2}]
[null,null,null,{"$f":"D52","v":"Meters"},"Years",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D133","v":"Asset category A"},null,{"$f":"IF(G133=$X$42,1,2)","v":2}]
[null,null,null,{"$f":"D53","v":"Asset category 2"},"Years",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D134","v":"Asset category B"},null,{"$f":"IF(G134=$X$42,1,2)","v":2}]
[null,null,null,{"$f":"D54","v":"Asset category 3"},"Years",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D135","v":"Asset category C"},null,{"$f":"IF(G135=$X$42,1,2)","v":2},{"$f":"IF(H135=$Y$42,1,2)","v":1}]
[null,null,null,{"$f":"D55","v":"Asset category 4"},"Years",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Retic Sewerage Opex Classification"]
[null,null,null,{"$f":"D56","v":"Asset category 5"},"Years",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D152","v":"Pipes"},null,null,null,{"$f":"IF(G152=$Z$42,1,2)","v":2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D153","v":"Pumping stations"},null,null,null,{"$f":"IF(G153=$Z$42,1,2)","v":2}]
[null,null,null,"Operating costs",null,null,"Cost in year 1","All other years",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D154","v":"Asset category A"},null,null,null,{"$f":"IF(G154=$Z$42,1,2)","v":2}]
[null,null,null,{"$f":"D52","v":"Meters"},"$",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D155","v":"Asset category B"},null,null,null,{"$f":"IF(G155=$Z$42,1,2)","v":2}]
[null,null,null,"Billing","$",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D156","v":"Asset category C"},null,null,null,{"$f":"IF(G156=$Z$42,1,2)","v":2}]
[null,null,null,{"$f":"D54","v":"Asset category 3"},"$"]
[null,null,null,{"$f":"D55","v":"Asset category 4"},"$"]
[null,null,null,{"$f":"D56","v":"Asset category 5"},"$"]
[]
[]
[]
[null,null,null,{"$f":"\"Table 4:  Reticulation input costs ($, \"&G37&\")\"","v":"Table 4:  Reticulation input costs ($, )"}]
[null,null,null,null,null,null,null,null,null,null,null,"Comments"]
[null,null,null,"Cost for Water Services"]
[]
[null,null,null,"Stage capital costs","Units",null,"Initial","Replacement"]
[null,null,null,"Pipes","$"]
[null,null,null,"Valves","$"]
[null,null,null,"Asset category 3","$"]
[null,null,null,"Asset category 4","$"]
[null,null,null,"Asset category 5","$"]
[]
[null,null,null,"Initial capital cost classification"]
[null,null,null,{"$f":"D86","v":"Pipes"}]
[null,null,null,{"$f":"D87","v":"Valves"}]
[null,null,null,{"$f":"D88","v":"Asset category 3"}]
[null,null,null,{"$f":"D89","v":"Asset category 4"}]
[null,null,null,{"$f":"D90","v":"Asset category 5"},null,null,null,"Non-depreciating"]
[]
[null,null,null,"Asset lives",null,null,"Regulatory","Tax"]
[null,null,null,{"$f":"D86","v":"Pipes"},"Years"]
[null,null,null,{"$f":"D87","v":"Valves"},"Years"]
[null,null,null,{"$f":"D88","v":"Asset category 3"},"Years"]
[null,null,null,{"$f":"D89","v":"Asset category 4"},"Years"]
[null,null,null,{"$f":"D90","v":"Asset category 5"},"Years"]
[]
[null,null,null,"Operating costs",null,null,"Cost in year 1","Average annual costs"]
[null,null,null,{"$f":"D86&\" & \"&D87","v":"Pipes & Valves"},"$"]
[null,null,null,"Asset category 2","$"]
[null,null,null,{"$f":"D95","v":"Asset category 3"},"$"]
[null,null,null,{"$f":"D96","v":"Asset category 4"},"$"]
[null,null,null,"Asset category 5","$"]
[]
[null,null,null,"Operating cost classification"]
[null,null,null,{"$f":"D107","v":"Pipes & Valves"}]
[null,null,null,{"$f":"D108","v":"Asset category 2"}]
[null,null,null,{"$f":"D109","v":"Asset category 3"}]
[null,null,null,{"$f":"D110","v":"Asset category 4"}]
[null,null,null,{"$f":"D111","v":"Asset category 5"}]
[]
[]
[null,null,null,"Cost for Sewerage Services"]
[]
[null,null,null,"Stage capital costs",null,null,"Initial","Replacement"]
[null,null,null,"Pipes","$"]
[null,null,null,"Pumping stations","$"]
[null,null,null,"Asset category A","$"]
[null,null,null,"Asset category B","$"]
[null,null,null,"Asset category C","$"]
[]
[null,null,null,"Initial capital cost classification"]
[null,null,null,{"$f":"D124","v":"Pipes"}]
[null,null,null,{"$f":"D125","v":"Pumping stations"}]
[null,null,null,{"$f":"D126","v":"Asset category A"}]
[null,null,null,{"$f":"D127","v":"Asset category B"}]
[null,null,null,{"$f":"D128","v":"Asset category C"},null,null,null,"Depreciating"]
[]
[null,null,null,"Asset lives",null,null,"Regulatory","Tax"]
[null,null,null,{"$f":"D124","v":"Pipes"},"Years"]
[null,null,null,{"$f":"D125","v":"Pumping stations"},"Years"]
[null,null,null,{"$f":"D126","v":"Asset category A"},"Years"]
[null,null,null,{"$f":"D127","v":"Asset category B"},"Years"]
[null,null,null,{"$f":"D128","v":"Asset category C"},"Years"]
[]
[null,null,null,"Operating costs",null,null,"Cost in year 1","Average annual costs"]
[null,null,null,{"$f":"D124","v":"Pipes"},"$"]
[null,null,null,{"$f":"D125","v":"Pumping stations"},"$"]
[null,null,null,{"$f":"D126","v":"Asset category A"},"$"]
[null,null,null,{"$f":"D127","v":"Asset category B"},"$"]
[null,null,null,{"$f":"D128","v":"Asset category C"},"$"]
[]
[null,null,null,"Operating cost classification"]
[null,null,null,{"$f":"D145","v":"Pipes"}]
[null,null,null,{"$f":"D146","v":"Pumping stations"}]
[null,null,null,"Asset category A"]
[null,null,null,"Asset category B"]
[null,null,null,"Asset category C"]