{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["checklist","contents","1. Customers","2. Rebates","3.Transfers","4. Opex","5. Miscellaneous Charges","6. Energy sales","7. Model inputs","8. Depreciation "],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":8,"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":"checklist","index":0,"n_rows":58,"n_cols":3,"rows_kept":58,"cut":false,"hidden":false,"merged":[[11,1,11,13],[13,1,13,13]]}
[]
[null,"Information Requirement for Electricity Retail Businesses (November 2012)"]
[null,"Information required for the review of Regulated Retail Prices for Electricity 2010-2013"]
[]
[null,"Agency"]
[null,"Date "]
[]
[null,"Information requested by 20 December 2012. Please submit before due date if possible."]
[]
[]
[null,"Background to the information request"]
[null,"The NSW Minister for Energy has requested the Tribunal conduct a review of NSW regulated retail electricity prices to apply from 1 July 2013 to 30 June 2016. The review will be carried out under Section 43EA(1) of the Electricity Supply Act of 1995."]
[]
[null,"To facilitate the investigation, the Tribunal requires updated information on certain aspects of the regulated  and non-regulated retail business.  This information will be used in the Tribunal's deliberations on the appropriate cost-reflective levels of regulated prices."]
[]
[]
[]
[null,"Check list"]
[]
[]
[null,"A)","Please provide all compulsory information. Any incomplete or missing data should be accompanied "]
[null,null,"by explanatory notes or comments. "]
[]
[null,"B) ","Please do not enter text into tables unless specifically requested to do so. If no information is available, leave "]
[null,null,"cells blank."]
[]
[null,"C)","Please ensure that no \"error\" messages are displayed in the control edit boxes before returning the spreasheet. If "]
[null,null,"there are still \"error\" messages, please provide explanations.  PLEASE DO NOT OVER-WRITE HARD CODED "]
[null,null,"FORMULAE."]
[]
[null,"D)","Please confirm the the accuracy of the historical data shaded in orange."]
[]
[null,"E)","All costs should be provided in nominal dollars to the financial year ending 30 June 2013 and then in "]
[null,null,"2012/13 dollars for subsequent years. "]
[]
[null,"F)","All financial data should be reported as exclusive of GST except where noted"]
[]
[null,"G)","Please provide any other relevant information in the \"comments\" column. In particular, it would be helpful if agencies "]
[null,null,"could indicate where data has been estimated."]
[]
[null,"H)","Small retail customers refers to customers on regulated tariffs or negotiated contracts with consumption of up to 100MWh"]
[null,null,"per year."]
[]
[]
[]
[null,"Colour coding of input sheets:"]
[null,"Light blue = Input cells recording actual historical data.  Information is compulsory."]
[null,"Yellow = Forecasts inputs. Information is compulsory"]
[null,"grey = no information required."]
[null,"black against a white background = calcuations. No information required."]
[null,"Pink type = ERROR CHECK boxes. No information required."]
[]
[]
[null,"Contacts"]
[null,"If you have any queries, please contact: "]
[null,"Alexus van der Weyden (02 9290 8460 or Alexus_VanDerWeyden@ipart.nsw.gov.au)) or"]
[null,"Juliana Weingaertner (02 9113 7737or Juliana_Weingaertner@ipart.nsw.gov.au) or"]
[null,"Anna Brakey (02 9290 8438 or Anna_Brakey@ipart.nsw.gov.au)"]

{"sheet":"contents","index":1,"n_rows":66,"n_cols":10,"rows_kept":66,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"checklist!B2","v":"Information Requirement for Electricity Retail Businesses (November 2012)"}]
[null,"Agency:",null,{"$f":"checklist!F5","v":0}]
[]
[]
[null,"Contents"]
[null,null,null,null,null,null,null,null,null,"Tab name"]
[null,{"$f":"'1. Customers'!B4","v":"1. Customer numbers in NSW"},null,null,null,null,null,null,null,"1. Customers"]
[]
[null,{"$f":"'1. Customers'!B16","v":"Table 1 - Numbers of Small Retail Customers of Retailer"}]
[null,{"$f":"'1. Customers'!B23","v":"1.1 Your customers on regulated retail tariffs"}]
[null,{"$f":"'1. Customers'!B41","v":"1.2 Your customers on negotiated contracts"}]
[null,{"$f":"'1. Customers'!B85","v":"Table 2 - Number of Small Retail Customers by consumption"}]
[null,{"$f":"'1. Customers'!B88","v":"2.1 Customers on regulated retail tariffs"}]
[null,{"$f":"'1. Customers'!B103","v":"2.2 Customers on negotiated contracts in your standard supply area"}]
[null,{"$f":"'1. Customers'!B118","v":"2.3 Your customers on negotiated contracts rest of NSW"}]
[]
[]
[null,{"$f":"'2. Rebates'!B4","v":"2. Rebates for customers on regulated and market prices"},null,null,null,null,null,null,null,"2. Rebates"]
[]
[null,{"$f":"'2. Rebates'!B14","v":"Table 1 - Small customers receiving low-income or special rebates"}]
[null,{"$f":"'2. Rebates'!B21","v":"1.1 Your customers on regulated retail tariffs"}]
[null,{"$f":"'2. Rebates'!B26","v":"1.2 Your customers on negotiated contracts"}]
[]
[]
[null,{"$f":"'3.Transfers'!B4","v":"3. Customer transfer numbers in NSW"},null,null,null,null,null,null,null,"3. Transfers"]
[]
[null,{"$f":"'3.Transfers'!B18","v":"Table 1 - Numbers of Small Retail Transfers of Retailer"}]
[null,{"$f":"'3.Transfers'!B23","v":"1.1 Your customers transfers - regulated retail tariffs"}]
[null,{"$f":"'3.Transfers'!B36","v":"1.2 Your customers transfers -  negotiated contracts"}]
[]
[]
[null,{"$f":"'4. Opex'!B4","v":"4. Retail operating costs"},null,null,null,null,null,null,null,"4. Opex"]
[]
[null,{"$f":"'4. Opex'!B18","v":"Table 1  - Retail costs of supplying small retail customers"}]
[null,{"$f":"'4. Opex'!B116","v":"Table 2. Estimate of retail cost of retaining existing small customers"}]
[null,{"$f":"'4. Opex'!B138","v":"Table 3 - Estimate of retail costs of acquiring a new small customer"}]
[]
[]
[null,{"$f":"'5. Miscellaneous Charges'!B4","v":"5. Miscellanous charges applicable to customers on Regulated tariffs"},null,null,null,null,null,null,null,"5. Miscellaneous charges"]
[]
[null,{"$f":"'5. Miscellaneous Charges'!B14","v":"Table 1 - Number, incidence and revenue from miscellaneous charges"}]
[null,{"$f":"'5. Miscellaneous Charges'!B17","v":"1.1  Late payment fees"}]
[null,{"$f":"'5. Miscellaneous Charges'!B29","v":"1.2  Dishonoured cheque fees"}]
[null,{"$f":"'5. Miscellaneous Charges'!B38","v":"1.3  Security deposits"}]
[null,{"$f":"'5. Miscellaneous Charges'!B60","v":"Table 2 - Retailer costs associated with miscellaneous charges"}]
[null,{"$f":"'5. Miscellaneous Charges'!B62","v":"2.1  Costs associated with late payments"}]
[null,{"$f":"'5. Miscellaneous Charges'!B76","v":"2.2  Costs associated with dishonoured payments"}]
[null,{"$f":"'5. Miscellaneous Charges'!B119","v":"2.3  Costs associated with security deposits"}]
[]
[]
[null,{"$f":"'6. Energy sales'!B4","v":"6. Energy sales "},null,null,null,null,null,null,null,"6. Energy costs"]
[]
[null,{"$f":"'6. Energy sales'!B16","v":"Table 1 - Electricity sales to small Retail Customers on regulated tariffs"}]
[]
[]
[null,{"$f":"'7. Model inputs'!B4","v":"7. Additional information required for modelling "},null,null,null,null,null,null,null,"7. Model inputs"]
[]
[null,{"$f":"'7. Model inputs'!B16","v":"Table 1 -  Customers and sales volumes for customers on regulated retail tariffs"}]
[null,{"$f":"'7. Model inputs'!B39","v":"Table 2 - Network (DUOS and TUOS) payments to network business for customers on regulated tariffs (excluding GST, nominal $'000)"}]
[null,{"$f":"'7. Model inputs'!B64","v":"Table 3 - Regulated Tariffs (excluding GST)"}]
[]
[null,{"$f":"'8. Depreciation '!B4","v":"8. Depreciation & Amortisation "},null,null,null,null,null,null,null,"8. Depreciation"]
[]
[null,{"$f":"'8. Depreciation '!B16","v":"Table 1 - Depreciation & Amortisation of the NSW business (including regulated and unregulated customers)  "}]
[null,{"$f":"'8. Depreciation '!B21","v":"1.1 Depreciation "}]
[null,{"$f":"'8. Depreciation '!B29","v":"1.2 Amortisation"}]

{"sheet":"1. Customers","index":2,"n_rows":136,"n_cols":16,"rows_kept":136,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"checklist!B2","v":"Information Requirement for Electricity Retail Businesses (November 2012)"}]
[null,"Agency:",null,{"$f":"checklist!F5","v":0}]
[]
[null,"1. Customer numbers in NSW"]
[]
[]
[null,"This sheet seeks information on your small retail customers in NSW."]
[]
[null,"Colour coding of input sheets:"]
[null,"Light blue = Input cells for historical data.  Information is compulsory."]
[null,"Yellow = Forecasts inputs. Information is compulsory"]
[null,"black against a white background = calcuations. No information required."]
[null,"Pink type = ERROR CHECK boxes. No information required."]
[]
[]
[null,"Table 1 - Numbers of Small Retail Customers of Retailer"]
[null,null,null,"As of 30 June",null,{"$f":"G17-1","v":2007},2008,2009,2010,2011,{"$f":"L17-1","v":2012},2013,{"$f":"L17+1","v":2014},{"$f":"M17+1","v":2015},2016,"RETAILER'S COMMENTS"]
[null,null,null,"units",null,"Actual","Actual","Actual","Actual","Actual","Actual","Forecast","Forecast","Forecast","Forecast"]
[]
[null,"NOTE:"]
[null,"Information from 2006/07 onwards is required. "]
[]
[null,"1.1 Your customers on regulated retail tariffs"]
[null,"Residential"]
[null,"block or single rate tariff",null,"no."]
[null,"time of use",null,{"$f":"D25","v":"no."}]
[null,"controlled load A",null,{"$f":"D26","v":"no."}]
[null,"controlled load B",null,{"$f":"D27","v":"no."}]
[null,"Total",null,"no.",null,{"$f":"SUM(F25:F26)","v":0},0,0,0,0,0,0,0,0,0]
[null,"% Overall growth",null,"%",null,null,{"$f":"IF(F29=0,0,G29/F29-1)","v":0},0,0,0,0,0,{"$f":"IF(L29=0,0,M29/L29-1)","v":0},{"$f":"IF(M29=0,0,N29/M29-1)","v":0},{"$f":"IF(N29=0,0,O29/N29-1)","v":0}]
[]
[null,"Business (less than 100 MWh pa)"]
[null,"block or single rate",null,{"$f":"D25","v":"no."}]
[null,"time of use",null,{"$f":"D26","v":"no."}]
[null,"Total",null,{"$f":"D29","v":"no."},null,{"$f":"SUM(F33:F34)","v":0},0,0,0,0,0,0,{"$f":"SUM(M33:M34)","v":0},0,0]
[null,"% Overall growth",null,{"$f":"D30","v":"%"},null,null,{"$f":"IF(F35=0,0,G35/F35-1)","v":0},0,0,0,0,0,{"$f":"IF(L35=0,0,M35/L35-1)","v":0},{"$f":"IF(M35=0,0,N35/M35-1)","v":0},{"$f":"IF(N35=0,0,O35/N35-1)","v":0}]
[]
[null,"Total customers on regulated tariffs",null,{"$f":"D33","v":"no."},null,{"$f":"SUM(F29,F35)","v":0},0,0,0,0,0,0,{"$f":"SUM(M29,M35)","v":0},0,0]
[null,"% total growth in total customers",null,"%",null,null,{"$f":"IF(F38=0,0,G38/F38-1)","v":0},0,0,0,0,0,{"$f":"IF(L38=0,0,M38/L38-1)","v":0},{"$f":"IF(M38=0,0,N38/M38-1)","v":0},{"$f":"IF(N38=0,0,O38/N38-1)","v":0}]
[]
[null,"1.2 Your customers on negotiated contracts"]
[null,"In standard supply area"]
[null,"residential - block or single rate tariff",null,"no."]
[null,"residential - time of use",null,{"$f":"D43","v":"no."}]
[null,"residential controlled load A",null,{"$f":"D44","v":"no."}]
[null,"residential controlled load B",null,"no."]
[null,"business - block or single rate (<100 MWh pa)",null,{"$f":"D43","v":"no."}]
[null,"business - time of use (<100 MWh pa)",null,{"$f":"D47","v":"no."}]
[null,"Total",null,{"$f":"D48","v":"no."},null,{"$f":"SUM(F43:F44,F47:F48)","v":0},{"$f":"SUM(G43:G44,G47:G48)","v":0},0,0,0,0,0,0,0,0]
[null,"% overall growth",null,"%",null,null,{"$f":"IF(F49=0,0,G49/F49-1)","v":0},0,0,0,0,0,{"$f":"IF(L49=0,0,M49/L49-1)","v":0},{"$f":"IF(M49=0,0,N49/M49-1)","v":0},{"$f":"IF(N49=0,0,O49/N49-1)","v":0}]
[]
[null,"In the rest of NSW"]
[null,{"$f":"B43","v":"residential - block or single rate tariff"},null,{"$f":"D43","v":"no."}]
[null,{"$f":"B44","v":"residential - time of use"},null,{"$f":"D44","v":"no."}]
[null,{"$f":"B45","v":"residential controlled load A"},null,{"$f":"D45","v":"no."}]
[null,"residential controlled load B",null,"no."]
[null,{"$f":"B47","v":"business - block or single rate (<100 MWh pa)"},null,{"$f":"D47","v":"no."}]
[null,{"$f":"B48","v":"business - time of use (<100 MWh pa)"},null,{"$f":"D48","v":"no."}]
[null,{"$f":"B49","v":"Total"},null,{"$f":"D49","v":"no."},null,{"$f":"SUM(F53:F54,F57:F58)","v":0},{"$f":"SUM(G53:G54,G57:G58)","v":0},{"$f":"SUM(H53:H54,H57:H58)","v":0},{"$f":"SUM(I53:I54,I57:I58)","v":0},{"$f":"SUM(J53:J54,J57:J58)","v":0},{"$f":"SUM(K53:K54,K57:K58)","v":0},{"$f":"SUM(L53:L54,L57:L58)","v":0},{"$f":"SUM(M53:M54,M57:M58)","v":0},{"$f":"SUM(N53:N54,N57:N58)","v":0},{"$f":"SUM(O53:O54,O57:O58)","v":0}]
[null,"% overall growth",null,"%",null,null,{"$f":"IF(F59=0,0,G59/F59-1)","v":0},0,0,0,0,0,{"$f":"IF(L59=0,0,M59/L59-1)","v":0},{"$f":"IF(M59=0,0,N59/M59-1)","v":0},{"$f":"IF(N59=0,0,O59/N59-1)","v":0}]
[]
[null,"All customers on negotiated tariffs"]
[null,"Residential"]
[null,"Total",null,null,null,{"$f":"SUM(F43:F44,F53:F54)","v":0},0,0,0,{"$f":"SUM(J43:J44,J53:J54)","v":0},0,0,{"$f":"SUM(M43:M44,M53:M54)","v":0},0,0]
[null,"% overall growth",null,null,null,null,{"$f":"IF(F64=0,0,G64/F64-1)","v":0},0,0,0,0,0,{"$f":"IF(L64=0,0,M64/L64-1)","v":0},{"$f":"IF(M64=0,0,N64/M64-1)","v":0},{"$f":"IF(N64=0,0,O64/N64-1)","v":0}]
[null,"Business"]
[null,"Total",null,null,null,{"$f":"SUM(F47:F48,F57:F58)","v":0},0,0,0,0,0,0,{"$f":"SUM(M47:M48,M57:M58)","v":0},0,0]
[null,"% overall growth",null,null,null,null,{"$f":"IF(F67=0,0,G67/F67-1)","v":0},0,0,0,0,0,{"$f":"IF(L67=0,0,M67/L67-1)","v":0},{"$f":"IF(M67=0,0,N67/M67-1)","v":0},{"$f":"IF(N67=0,0,O67/N67-1)","v":0}]
[]
[null,"Description of forecast of customer numbers. "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Table 2 - Number of Small Retail Customers by consumption"]
[null,null,null,"As at  30 June",null,{"$f":"F$17","v":2007},2008,2009,2010,2011,2012,2013,2014,2015,2016,{"$f":"P$17","v":"RETAILER'S COMMENTS"}]
[null,null,null,"units",null,{"$f":"F$18","v":"Actual"},"Actual","Actual","Actual","Actual","Actual","Forecast","Forecast","Forecast","Forecast",{"$f":"P$18","v":0}]
[null,"2.1 Customers on regulated retail tariffs"]
[null,"Regulated Residential"]
[null,"Up to 5 MWhs per annum",null,"no."]
[null,"5.1 to 10 MWhs per annum",null,{"$f":"D90","v":"no."}]
[null,"10.1 to 15 MWhs per annum",null,{"$f":"D91","v":"no."}]
[null,"15.1 to 40 MWhs per annum",null,{"$f":"D92","v":"no."}]
["\\","40.1 to 100 MWhs per annum",null,{"$f":"D93","v":"no."}]
[]
[null,"Regulated Business"]
[null,"Up to 20 MWhs per annum",null,{"$f":"D90","v":"no."}]
[null,"20.1 to 40 MWhs per annum",null,{"$f":"D91","v":"no."}]
[null,"40.1 to 60 MWhs per annum",null,{"$f":"D92","v":"no."}]
[null,"60.1 to 100 MWhs per annum",null,{"$f":"D93","v":"no."}]
[]
[]
[null,"2.2 Customers on negotiated contracts in your standard supply area"]
[null,"Residential"]
[null,{"$f":"B90","v":"Up to 5 MWhs per annum"},null,{"$f":"D90","v":"no."}]
[null,{"$f":"B91","v":"5.1 to 10 MWhs per annum"},null,{"$f":"D91","v":"no."}]
[null,{"$f":"B92","v":"10.1 to 15 MWhs per annum"},null,"no."]
[null,{"$f":"B93","v":"15.1 to 40 MWhs per annum"},null,"no."]
[null,{"$f":"B94","v":"40.1 to 100 MWhs per annum"},null,"no."]
[]
[null,"Business"]
[null,{"$f":"B97","v":"Up to 20 MWhs per annum"},null,"no."]
[null,{"$f":"B98","v":"20.1 to 40 MWhs per annum"},null,"no."]
[null,{"$f":"B99","v":"40.1 to 60 MWhs per annum"},null,"no."]
[null,{"$f":"B100","v":"60.1 to 100 MWhs per annum"},null,"no."]
[]
[]
[null,"2.3 Your customers on negotiated contracts rest of NSW"]
[null,"Residential"]
[null,{"$f":"B105","v":"Up to 5 MWhs per annum"},null,{"$f":"D105","v":"no."}]
[null,{"$f":"B106","v":"5.1 to 10 MWhs per annum"},null,"no."]
[null,{"$f":"B107","v":"10.1 to 15 MWhs per annum"},null,"no."]
[null,{"$f":"B108","v":"15.1 to 40 MWhs per annum"},null,"no."]
[null,{"$f":"B109","v":"40.1 to 100 MWhs per annum"},null,"no."]
[]
[null,"Business"]
[null,{"$f":"B112","v":"Up to 20 MWhs per annum"},null,"no."]
[null,{"$f":"B113","v":"20.1 to 40 MWhs per annum"},null,"no."]
[null,{"$f":"B114","v":"40.1 to 60 MWhs per annum"},null,"no."]
[null,{"$f":"B115","v":"60.1 to 100 MWhs per annum"},null,{"$f":"D115","v":"no."}]
[]
[]
[null,"Error check - regulated residential",null,null,null,{"$f":"IF(ROUND(SUM(F90:F94)-F25-F26,0)=0,\"ok\",\"Error\")","v":"ok"},"ok","ok","ok","ok","ok","ok"]
[null,"Error check - regulated business",null,null,null,{"$f":"IF(ROUND(SUM(F97:F101)-F33-F34,0)=0,\"ok\",\"Error\")","v":"ok"},"ok","ok","ok","ok","ok","ok"]
[null,"Error check - negotiated contract residential",null,null,null,{"$f":"IF(ROUND(SUM(F105:F109,F120:F124)-SUM(F43:F44,F53:F54),0)=0,\"ok\",\"Error\")","v":"ok"},"ok","ok","ok","ok","ok","ok"]
[null,"Error check - negotiated contract  business",null,null,null,{"$f":"IF(ROUND(SUM(F112:F116,F127:F131)-SUM(F47:F48,F57:F58),0)=0,\"ok\",\"Error\")","v":"ok"},"ok","ok","ok","ok","ok","ok"]

{"sheet":"2. Rebates","index":3,"n_rows":35,"n_cols":12,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"'6. Energy sales'!B1","v":"Information Requirement for Electricity Retail Businesses (November 2012)"}]
[null,{"$f":"'6. Energy sales'!B2","v":"Agency:"},{"$f":"'6. Energy sales'!C2","v":0}]
[]
[null,"2. Rebates for customers on regulated and market prices"]
[]
[null,"IPART would like information on the extent to which certain customer groups within the metropolitan and non-metropolitan markets of NSW have accessed the competitive market. "]
[null,"For example, are customers with concession cards more likely to have market contracts or pay regulated prices. "]
[]
[]
[null,"Colour coding of input sheets:"]
[null,"Light blue = Input cells for historical data.  Information is compulsory."]
[]
[]
[null,"Table 1 - Small customers receiving low-income or special rebates"]
[null,null,null,"As of 30 June",null,2007,{"$f":"F15+1","v":2008},{"$f":"G15+1","v":2009},2010,2011,2012,"RETAILER'S COMMENTS"]
[null,null,null,"units",null,"Actual","Actual","Actual","Actual","Actual","Actual"]
[]
[null,"NOTE:"]
[null,"Information from 2006/07 onwards is required. "]
[]
[null,"1.1 Your customers on regulated retail tariffs"]
[null,"Customers with a  health care card",null,"no."]
[null,"Customers with a pension concession card",null,"no."]
[null,"Customers receiving special rebates (eg medical)",null,"no."]
[]
[null,"1.2 Your customers on negotiated contracts"]
[null,"In supply area"]
[null,{"$f":"B22","v":"Customers with a  health care card"},null,"no."]
[null,{"$f":"B23","v":"Customers with a pension concession card"},null,"no."]
[null,"Customers receiving special rebates (eg medical)",null,"no."]
[]
[null,"In rest of NSW"]
[null,{"$f":"B28","v":"Customers with a  health care card"},null,"no."]
[null,{"$f":"B29","v":"Customers with a pension concession card"},null,"no."]
[null,"Customers receiving special rebates (eg medical)",null,"no."]

{"sheet":"3.Transfers","index":4,"n_rows":46,"n_cols":11,"rows_kept":46,"cut":false,"hidden":false,"merged":[[20,10,24,10]]}
[null,{"$f":"'6. Energy sales'!B1","v":"Information Requirement for Electricity Retail Businesses (November 2012)"}]
[null,{"$f":"'6. Energy sales'!B2","v":"Agency:"},{"$f":"'6. Energy sales'!C2","v":0}]
[]
[null,"3. Customer transfer numbers in NSW"]
[]
[null,"This sheet seeks information on your small retail customer transfers in NSW. "]
[null,"Customer' means the person whose name an electricity account is held under one supply contract."]
[null,"For customers on regulated retail tariffs, 'gross transfers from within' means existing customers switching from negotiated contracts to regulated contracts."]
[null,"For customers on negotiated tariffs, 'gross transfers from within' includes existing customers switching from  regulated contracts to negotiated contracts as well as existing customers switching between negotiated contracts. "]
[]
[null,"Colour coding of input sheets:"]
[null,"Light blue = Input cells recording actual historical data.  Information is compulsory."]
[null,"Yellow = Forecasts inputs. Information is compulsory"]
[null,"black against a white background = calcuations. No information required."]
[null,"Pink type = ERROR CHECK boxes. No information required."]
[]
[]
[null,"Table 1 - Numbers of Small Retail Transfers of Retailer"]
[null,null,null,"As of 30 June",2011,2012,2013,2014,2015,2016,"RETAILER'S COMMENTS"]
[null,null,null,"units","Actual","Actual","Forecast","Forecast","Forecast","Forecast"]
[]
[]
[null,"1.1 Your customers transfers - regulated retail tariffs"]
[]
[null,"Residential"]
[null,"gross transfers from another retailer (IN)",null,"no."]
[null,"gross transfers from within (IN)",null,"no."]
[]
[]
[]
[null,"Business"]
[null,"gross transfers from another retailer (IN)",null,"no."]
[null,"gross transfers from within (IN)",null,"no."]
[]
[]
[null,"1.2 Your customers transfers -  negotiated contracts"]
[]
[null,"Residential"]
[null,"gross transfers from another retailer (IN)",null,"no."]
[null,"gross transfers from within (IN)",null,"no."]
[]
[]
[]
[null,"Business"]
[null,"gross transfers from another retailer (IN)",null,"no."]
[null,"gross transfers from within (IN)",null,"no."]

{"sheet":"4. Opex","index":5,"n_rows":201,"n_cols":11,"rows_kept":201,"cut":false,"hidden":false,"merged":[[58,10,61,10],[23,10,26,10],[28,10,32,10],[33,10,37,10],[46,10,47,10],[41,10,44,10],[51,10,54,10],[157,27,157,37],[157,39,157,49],[157,51,157,61],[157,12,157,13],[157,159,157,169],[157,15,157,25],[157,87,157,97],[157,147,157,157],[157,111,157,121],[157,63,157,73],[157,135,157,145],[157,123,157,133],[157,75,157,85],[157,99,157,109],[157,219,157,221],[157,171,157,181],[157,183,157,193],[157,195,157,205],[157,207,157,217]]}
[null,{"$f":"checklist!B2","v":"Information Requirement for Electricity Retail Businesses (November 2012)"}]
[null,"Agency:",{"$f":"checklist!F5","v":0}]
[]
[null,"4. Retail operating costs"]
[]
[null,"Information should be provided for costs of supplying both regulated retail customers and small retail customers "]
[]
[]
[null,"Colour coding of input sheets:"]
[null,"Light blue = Input cells recording actual historical data.  Information is compulsory."]
[null,"Yellow = Forecasts inputs. Information is compulsory"]
[null,"grey = no information required."]
[null,"black against a white background = calcuations. No information required."]
[null,"Pink type = ERROR CHECK boxes. No information required."]
[]
[]
[]
[null,"Table 1  - Retail costs of supplying small retail customers"]
[null,null,null,"Financial year ending 30 June",{"$f":"'1. Customers'!J$17","v":2011},{"$f":"'1. Customers'!K$17","v":2012},{"$f":"'1. Customers'!L$17","v":2013},{"$f":"'1. Customers'!M$17","v":2014},{"$f":"'1. Customers'!N$17","v":2015},{"$f":"'1. Customers'!O$17","v":2016},{"$f":"'1. Customers'!P17","v":"RETAILER'S COMMENTS"}]
[null,null,null,"Unit",{"$f":"'1. Customers'!J$18","v":"Actual"},{"$f":"'1. Customers'!K$18","v":"Actual"},{"$f":"'1. Customers'!L$18","v":"Forecast"},{"$f":"'1. Customers'!M$18","v":"Forecast"},{"$f":"'1. Customers'!N$18","v":"Forecast"},{"$f":"'1. Customers'!O$18","v":"Forecast"}]
[null,null,null,null,"nominal","nominal","$12/13","$12/13","$12/13","$12/13"]
[]
[null,"NOTES:   "]
[]
[null,"Please indicate what costs you have included in each category."]
[null,"Please provide all actual and forecast costs using a consistent cost allocation methodology."]
[]
[null,"Call centre costs"]
[null,"Item (describe)",null,"$/customer"]
[null,"Item (describe)",null,"$/customer"]
[null,"Total call centre costs",null,"$/customer",{"$f":"SUM(E29:E30)","v":0},0,0,0,0,0]
[]
[null,"Customer information costs"]
[null,"Item (describe)",null,"$/customer"]
[null,"Item (describe)",null,"$/customer"]
[null,"Item (describe)",null,"$/customer"]
[null,"Item (describe)",null,"$/customer"]
[null,"Total customer information costs",null,{"$f":"D36","v":"$/customer"},{"$f":"SUM(E34:E37)","v":0},0,0,0,0,0]
[]
[null,"Corporate overhead costs"]
[null,"Item (describe)",null,"$/customer"]
[null,"Item (describe)",null,"$/customer"]
[null,"Total corporate overhead costs",null,{"$f":"D41","v":"$/customer"},{"$f":"SUM(E41:E42)","v":0},0,0,0,0,0]
[]
[null,"Regulatory compliance costs"]
[null,"Item (describe)",null,{"$f":"D41","v":"$/customer"}]
[null,"Item (describe)",null,{"$f":"D46","v":"$/customer"}]
[null,"Total regulatory compliance costs",null,"$/customer",{"$f":"SUM(E46:E47)","v":0},0,0,0,0,0]
[]
[null,"Billing and revenue collection costs",null,"Excluding amounts for bad debt. Do not include costs associated with collecting late and dishonoured payments. See miscellaneous charges for these details"]
[null,"collection costs"]
[null,"Item (describe)",null,"$/customer"]
[null,"Item (describe)",null,"$/customer"]
[null,"Item (describe)",null,"$/customer"]
[null,"Item (describe)",null,"$/customer"]
[null,"Total collection costs",null,"$/customer",{"$f":"SUM(E52:E55)","v":0},0,0,0,0,0]
[]
[null,"Bad and doubtul debt"]
[null,"Item (describe)",null,"$/customer"]
[null,"Item (describe)",null,"$/customer"]
[null,"Total bad and doubful debt",null,"  $/customer",{"$f":"SUM(E59:E60)","v":0},0,0,0,0,0]
[]
[]
[null,"Other (describe)"]
[null,"Item (describe)",null,"  $/customer"]
[null,"Item (describe)",null,"  $/customer"]
[null,"Total other costs",null,"  $/customer",{"$f":"SUM(E65:E66)","v":0},0,0,0,0,0]
[]
[]
[null,"Total costs",null,{"$f":"D67","v":"  $/customer"},{"$f":"SUM(E31,E38,E43,E48,E56,E61)","v":0},{"$f":"SUM(F31,F38,F43,F48,F56,F61)","v":0},{"$f":"SUM(G31,G38,G43,G48,G56,G61,G67)","v":0},{"$f":"SUM(H31,H38,H43,H48,H56,H61,H67)","v":0},{"$f":"SUM(I31,I38,I43,I48,I56,I61,I67)","v":0},{"$f":"SUM(J31,J38,J43,J48,J56,J61,J67)","v":0}]
[]
[]
[null,"Please explain how you have allocated total retail costs to small retail customers"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Please indicate the proportion of total operating costs that are volume-related and non-volume related.  The term 'volume-related' means the costs which would be incurred regardless of elelctricity consumption "]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"For each cost category, please explain the drivers for the changes in operating cost forecast."]
[]
[null,"           "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Table 2. Estimate of retail cost of retaining existing small customers"]
[null,null,null,"Financial year ending 30 June",{"$f":"E$19","v":2011},{"$f":"F$19","v":2012},2013,2014,2015,2016,"RETAILER'S COMMENTS"]
[null,null,null,"Unit",{"$f":"E$20","v":"Actual"},{"$f":"F$20","v":"Actual"},"Forecast","Forecast","Forecast","Forecast"]
[null,null,null,null,{"$f":"E$21","v":"nominal"},{"$f":"F$21","v":"nominal"},"$12/13","$12/13","$12/13","$12/13"]
[null,"Marketing costs",null,"Excluding costs directly related to the acquisition of new customers. See Table 3 for details of customers acquisition costs."]
[null,"Item (describe)",null,"$/customer"]
[null,"Item (describe)",null,"$/customer"]
[null,"Total marketing costs",null,"$/customer",{"$f":"SUM(E121:E122)","v":0},0,0,0,0,0]
[]
[null,"Costs of moving an existing customer on a regulated contract  to a negotiated contract "]
[null,"Item (describe)",null,"$/customer transfer "]
[null,"Item (describe)",null,"$/customer transfer "]
[null,"Total",null,"$/customer transfer ",{"$f":"SUM(E126:E127)","v":0},{"$f":"SUM(F126:F127)","v":0},0,0,0,0]
[]
[null,"Costs of moving an existing customers on a negotiated contract to a regulated contract"]
[null,"Item (describe)",null,"$/customer transfer "]
[null,"Item (describe)",null,"$/customer transfer "]
[null,"Total",null,"$/customer transfer ",{"$f":"SUM(E131:E132)","v":0},{"$f":"SUM(F131:F132)","v":0},0,0,0,0]
[]
[]
[]
[]
[null,"Table 3 - Estimate of retail costs of acquiring a new small customer"]
[null,null,null,"Financial year ending 30 June",{"$f":"E$19","v":2011},2012,2013,2014,2015,2016,"RETAILER'S COMMENTS"]
[null,null,null,"Unit",{"$f":"E$20","v":"Actual"},"Actual","Forecast","Forecast","Forecast","Forecast"]
[null,null,null,null,{"$f":"E$21","v":"nominal"},"nominal","$12/13","$12/13","$12/13","$12/13"]
[null,"Cost of acquiring a new residential customer 1"]
[]
[null,"Common costs"]
[null,"Retail operations",null,"$/new customer"]
[null,"New customer transfers",null,"$/new customer"]
[null,"Item  (describe)",null,"$/new customer"]
[null,"Item  (describe)",null,"$/new customer"]
[null,"total common costs",null,null,null,{"$f":"SUM(F145:F148)","v":0},{"$f":"SUM(G145:G148)","v":0},{"$f":"SUM(H145:H148)","v":0},{"$f":"SUM(I145:I148)","v":0},{"$f":"SUM(J145:J148)","v":0}]
[]
[null,"Costs specific to each sales channel"]
[null,"Door-to-Door sales ",null,"$/new customer"]
[null,"Online switching ",null,"$/new customer"]
[null,"Telemarketing",null,"$/new customer"]
[null,"Own website",null,"$/new customer"]
[null,"Item  (describe)",null,"$/new customer"]
[null,"Item  (describe)",null,"$/new customer"]
[null,"Item  (describe)",null,"$/new customer"]
[]
[null,"Proportion of new residential customers acquired by channel type"]
[null,{"$f":"B152","v":"Door-to-Door sales "},null,"%"]
[null,"Online switching ",null,"%"]
[null,"Telemarketing",null,"%"]
[null,"Own website",null,"%"]
[null,"Item  (describe)",null,"%"]
[null,"Item  (describe)",null,"%"]
[]
[null,"Cost of acquiring a new business customer 1"]
[]
[null,"Common costs",null,"$/new customer"]
[null,"Retail operations",null,"$/new customer"]
[null,"New customer transfers",null,"$/new customer"]
[null,"Item  (describe)",null,"$/new customer"]
[null,"Item  (describe)",null,"$/new customer"]
[null,"total common costs",null,"$/new customer",{"$f":"SUM(E170:E174)","v":0},0,0,0,0,0]
[]
[null,"Costs specific to each sales channel"]
[null,"Door-to-Door sales ",null,"$/new customer"]
[null,"Online switching ",null,"$/new customer"]
[null,"Telemarketing",null,"$/new customer"]
[null,"Own website",null,"$/new customer"]
[null,"Item  (describe)",null,"$/new customer"]
[null,"Item  (describe)",null,"$/new customer"]
[null,"Item  (describe)",null,"$/new customer"]
[]
[null,"Proportion of new business customers acquired by channel type "]
[null,{"$f":"B178","v":"Door-to-Door sales "},null,"%"]
[null,{"$f":"B179","v":"Online switching "},null,"%"]
[null,{"$f":"B180","v":"Telemarketing"},null,"%"]
[null,{"$f":"B181","v":"Own website"},null,"%"]
[null,{"$f":" B182","v":"Item  (describe)"},null,"%"]
[null,{"$f":" B183","v":"Item  (describe)"},null,"%"]
[null,{"$f":" B184","v":"Item  (describe)"},null,"%"]
[]
[]
[null,"Average number of years a residential customer on a "]
[null,"negotiated contract typically stays with retailer ",null,"No."]
[null,"Average years a business customer on a negotiated  "]
[null,"contract typically stays with retailer",null,"No."]
[null,"Notes:"]
[null,"1 Reported as costs per new customer acquired. Including only those costs directly related to the acquisition of new customers (door-knocking, mail outs, etc.)."]

{"sheet":"5. Miscellaneous Charges","index":6,"n_rows":133,"n_cols":9,"rows_kept":133,"cut":false,"hidden":false,"merged":[[96,8,100,8],[50,8,54,8],[18,8,20,8],[39,8,41,8],[84,8,85,8],[28,8,29,8]]}
[null,{"$f":"checklist!B2","v":"Information Requirement for Electricity Retail Businesses (November 2012)"}]
[null,"Agency:",{"$f":"checklist!F5","v":0}]
[]
[null,"5. Miscellanous charges applicable to customers on Regulated tariffs"]
[]
[]
[null,"Colour coding of input sheets:"]
[null,"Light blue = Input cells recording actual historical data.  Information is compulsory."]
[null,"Black against a white background = calcuations. No information required."]
[]
[]
[]
[]
[null,"Table 1 - Number, incidence and revenue from miscellaneous charges"]
[null,null,null,null,null,{"$f":"'1. Customers'!I$17","v":2010},{"$f":"'1. Customers'!J$17","v":2011},{"$f":"'1. Customers'!K$17","v":2012},"RETAILER'S COMMENTS"]
[null,null,null,null,null,{"$f":"'1. Customers'!I$18","v":"Actual"},{"$f":"'1. Customers'!J$18","v":"Actual"},{"$f":"'1. Customers'!K$18","v":"Actual"}]
[null,"1.1  Late payment fees"]
[null,"Number of times fee is charged per year (include all fees that are subsequently waived)"]
[null,"   residential customers",null,"no"]
[null,"   business customers",null,{"$f":"D19","v":"no"}]
[null,"Proportion of fees charged which are subsequently waived  "]
[null,"   residential customers",null,"%"]
[null,"   business customers",null,{"$f":"D22","v":"%"}]
[]
[null,"Late payment fee (amount charged excl. GST)",null,"$"]
[null,"Annual revenue from fees",null,"$'000"]
[]
[]
[null,"1.2  Dishonoured cheque fees"]
[null,"Number of times fee is charged per year"]
[null,"   residential customers",null,"no"]
[null,"   business customers",null,{"$f":"D31","v":"no"}]
[]
[null,"Average dishonoured cheque fee charged to customers",null,"$"]
[null,"Annual revenue from fees",null,"$'000"]
[]
[]
[null,"1.3  Security deposits"]
[null,"Number of new security deposits made per year"]
[null,"   residential customers",null,"no"]
[null,"   business customers",null,{"$f":"D40","v":"no"}]
[]
[null,"Average $ value of security deposit requested"]
[null,{"$f":"B40","v":"   residential customers"},null,{"$f":"D34","v":"$"}]
[null,{"$f":"B41","v":"   business customers"},null,{"$f":"D44","v":"$"}]
[]
[null,"$ of security value allocated to bad and doubtful debt"]
[null,{"$f":"B44","v":"   residential customers"},null,{"$f":"D44","v":"$"}]
[null,{"$f":"B45","v":"   business customers"},null,{"$f":"D48","v":"$"}]
[]
[null,"Estimated income earned from holding security deposits"]
[null,"  interest income",null,{"$f":"D26","v":"$'000"}]
[null,"  (other - please describe)",null,{"$f":"D52","v":"$'000"}]
[null,"  (other - please describe)",null,{"$f":"D53","v":"$'000"}]
[]
[]
[]
[]
[]
[null,"Table 2 - Retailer costs associated with miscellaneous charges"]
[]
[null,"2.1  Costs associated with late payments"]
[null,"List the average costs (broken down into cost elements)  per late payment. Separately list working capital costs, if included."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"2.2  Costs associated with dishonoured payments"]
[]
[null,null,null,"Financial year ending 30 June",null,2010,{"$f":"F78+1","v":2011},{"$f":"G78+1","v":2012},"RETAILER'S COMMENTS"]
[null,null,null,"Unit",null,"Actual","Actual","Actual"]
[]
[]
[null,"Annual financial institution charges for dishonoured payments"]
[null," bank charges for dishonoured cheques",null,"$'000"]
[null," bank charges for dishonoured direct debits",null,"$'000"]
[null," bank charges for dishonoured credit card payments",null,"$'000"]
[null,"bank charges (other payment methods- please describe )",null,"$'000"]
[]
[null,"Number of times bank charges incurred by retailer for dishonoured payments"]
[null," dishonoured cheques",null,"no"]
[null," direct debits",null,"no"]
[null," credit card payments",null,"no"]
[null,"Annual bank charges for dishonoured cheques by customer type"]
[null,"   residential customers",null,"$'000"]
[null,"    business customers",null,{"$f":"D93","v":"$'000"}]
[]
[null,"Importance of different payment methods"]
[null,"Percentage of all bill payments made by cheque",null,"%"]
[null,"Percentage of all bill payments made by direct debit",null,{"$f":"D97","v":"%"}]
[null,"Percentage of all bill payments made by credit card",null,{"$f":"D98","v":"%"}]
[]
[null,"Incidence of dishonoured payments by payment method"]
[null,"   cheque payments dishonoured",null,"%"]
[null,"   direct debit payments dishonoured",null,"%"]
[null,"   credit card payments dishonoured",null,"%"]
[null," (other payment types dishonoured - please describe)",null,"%"]
[]
[null,"List any additional costs (broken down into cost elements) per late payment. Separately list working capital costs, if included."]
[null,"Item (describe)",null,"$'000"]
[null,"Item (describe)",null,{"$f":"D108","v":"$'000"}]
[null,"Item (describe)",null,"$'000"]
[null,"Item (describe)",null,{"$f":"D110","v":"$'000"}]
[null,"Item (describe)",null,"$'000"]
[null,"Item (describe)",null,{"$f":"D112","v":"$'000"}]
[null,"Item (describe)",null,"$'000"]
[null,"Item (describe)",null,{"$f":"D114","v":"$'000"}]
[null,"Item (describe)",null,{"$f":"D115","v":"$'000"}]
[]
[]
[null,"2.3  Costs associated with security deposits"]
[null,"List the average costs (broken down into cost elements) associated with security deposits.  "]
[null,"What proportion of security deposits are wholly or partially used to offset overdue/unpaid bills?"]
[null,"Item (describe)",null,"$'000"]
[null,"Item (describe)",null,{"$f":"D122","v":"$'000"}]
[null,"Item (describe)",null,"$'000"]
[null,"Item (describe)",null,{"$f":"D124","v":"$'000"}]
[null,"Item (describe)",null,"$'000"]
[null,"Item (describe)",null,{"$f":"D126","v":"$'000"}]
[null,"Item (describe)",null,"$'000"]
[null,"Item (describe)",null,{"$f":"D128","v":"$'000"}]
[null,"Item (describe)",null,{"$f":"D129","v":"$'000"}]
[]
[]
[null,"Please add rows to this table as required"]

{"sheet":"6. Energy sales","index":7,"n_rows":37,"n_cols":11,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"checklist!B2","v":"Information Requirement for Electricity Retail Businesses (November 2012)"}]
[null,"Agency:",{"$f":"checklist!F5","v":0}]
[]
[null,"6. Energy sales "]
[]
[]
[]
[null,"Colour coding of input sheets:"]
[null,"Light blue = Input cells recording actual historical data.  Information is compulsory."]
[null,"Black against a white background = calcuations. No information required."]
[]
[]
[]
[]
[]
[null,"Table 1 - Electricity sales to small Retail Customers on regulated tariffs"]
[null,null,null,"Financial year ending 30 June",null,{"$f":"G17-1","v":2007},2008,2009,2010,2011,{"$f":"'1. Customers'!K$17","v":2012}]
[null,null,null,"units",null,"Actual","Actual","Actual","Actual","Actual","Actual"]
[]
[]
[null,"Your customers on regulated retail tariffs"]
[null,"Residential"]
[null,"block or single rate tariff",null,"MWh"]
[null,"time of use",null,{"$f":"D23","v":"MWh"}]
[null,"controlled load A",null,{"$f":"D24","v":"MWh"}]
[null,"controlled load B",null,{"$f":"D25","v":"MWh"}]
[null,"Total",null,{"$f":"D26","v":"MWh"},null,{"$f":"SUM(F23:F26)","v":0},{"$f":"SUM(G23:G26)","v":0},0,0,0,0]
[null,"% Overall growth",null,"%",null,null,{"$f":"IF(F27=0,0,G27/F27-1)","v":0},0,0,0,0]
[]
[null,"Business (less than 100 MWh pa)"]
[null,"block or single rate",null,{"$f":"D23","v":"MWh"}]
[null,"time of use",null,{"$f":"D24","v":"MWh"}]
[null,"Total",null,{"$f":"D25","v":"MWh"},null,{"$f":"SUM(F31:F32)","v":0},{"$f":"SUM(G31:G32)","v":0},0,0,0,0]
[null,"% Overall growth",null,{"$f":"D28","v":"%"},null,null,{"$f":"IF(F33=0,0,G33/F33-1)","v":0},0,0,0,0]
[]
[null,"Total customers on regulated tariffs",null,{"$f":"D31","v":"MWh"},null,{"$f":"SUM(F27,F33)","v":0},0,0,0,0,0]
[null,"% total growth in total customers",null,"%",null,null,{"$f":"IF(F36=0,0,G36/F36-1)","v":0},0,0,0,0]

{"sheet":"7. Model inputs","index":8,"n_rows":93,"n_cols":11,"rows_kept":93,"cut":false,"hidden":false,"merged":[[45,10,46,10]]}
[null,{"$f":"checklist!B2","v":"Information Requirement for Electricity Retail Businesses (November 2012)"}]
[null,"Agency:",{"$f":"checklist!F5","v":0}]
[]
[null,"7. Additional information required for modelling "]
[]
[]
[]
[null,"Colour coding of input sheets:"]
[null,"Light blue = Input cells recording actual historical data.  Information is compulsory."]
[null,"grey = no information required."]
[null,"black against a white background = calcuations. No information required."]
[]
[]
[]
[]
[null,"Table 1 -  Customers and sales volumes for customers on regulated retail tariffs"]
[null,null,null,"Financial year ending 30 June",null,{"$f":"'1. Customers'!K$17","v":2012},{"$f":"F17+1","v":2013},{"$f":"G17+1","v":2014},2015,2016,{"$f":"'1. Customers'!P$17","v":"RETAILER'S COMMENTS"}]
[null,"Financial year ending 30 June",null,null,null,{"$f":"'1. Customers'!K$18","v":"Actual"},{"$f":"'1. Customers'!L$18","v":"Forecast"},{"$f":"'1. Customers'!M$18","v":"Forecast"},{"$f":"'1. Customers'!N$18","v":"Forecast"},{"$f":"'1. Customers'!O$18","v":"Forecast"}]
[]
[null,null,null,"Unit"]
[null,"Customer numbers (average for the year)"]
[null,"Residential customers",null,"no."]
[null,"Non-residential customers <100 MWh pa",null,"no."]
[null,"Total customers",null,"no.",null,{"$f":"SUM(F22:F23)","v":0}]
[]
[null,"Sales volumes"]
[null,"Residential customers",null,"MWh",null,{"$f":"'6. Energy sales'!K27","v":0}]
[null,"Non-residential customers",null,{"$f":"D27","v":"MWh"},null,{"$f":"'6. Energy sales'!K33","v":0}]
[null,"Total sales",null,{"$f":"D28","v":"MWh"},null,{"$f":"F28+F27","v":0}]
[]
[null,"Sales per residential customer",null,{"$f":"D27","v":"MWh"},null,{"$f":"F27/F22","v":{"$error":"#DIV/0!"}}]
[null,"Sales per non-residential customer",null,{"$f":"D31","v":"MWh"},null,{"$f":"F28/F23","v":{"$error":"#DIV/0!"}}]
[null,"Sales per customer",null,{"$f":"D31","v":"MWh"},null,{"$error":"#DIV/0!"}]
[]
[null,"Note:  No additional information is required for sales volumes.  The purpose of this table is to show what information is required for the R model and to check that consumption per customer is sensible."]
[]
[]
[]
[null,"Table 2 - Network (DUOS and TUOS) payments to network business for customers on regulated tariffs (excluding GST, nominal $'000)"]
[null,null,null,"Financial year ending 30 June",null,{"$f":"'1. Customers'!K$17","v":2012},{"$f":"'1. Customers'!L$17","v":2013},{"$f":"'1. Customers'!M$17","v":2014},{"$f":"'1. Customers'!N$17","v":2015},{"$f":"'1. Customers'!O$17","v":2016},{"$f":"'1. Customers'!P$17","v":"RETAILER'S COMMENTS"}]
[null,null,null,"Unit",null,{"$f":"'1. Customers'!K$18","v":"Actual"},{"$f":"'1. Customers'!L$18","v":"Forecast"},{"$f":"'1. Customers'!M$18","v":"Forecast"},{"$f":"'1. Customers'!N$18","v":"Forecast"},{"$f":"'1. Customers'!O$18","v":"Forecast"}]
[null,null,null,null,null,"nominal"]
[null,"The PURPOSE of this information is to allow the Tribunal to calculate the retail margin on the full (N+R) tariff."]
[]
[null,"1.1 DUOS"]
[null,"Fixed charges",null,"$'000"]
[null,"Variable charges",null,"$'000"]
[null,"Total DUOS charges",null,"$'000",null,{"$f":"SUM(F46:F47)","v":0}]
[]
[null,"1.2 TUOS"]
[null,"Fixed charges",null,"$'000"]
[null,"Variable charges",null,"$'000"]
[null,"Total TUOS charges",null,"$'000",null,{"$f":"SUM(F51:F52)","v":0}]
[]
[null,"1.3 FORECAST INCREASE IN CHARGES"]
[null,"Expected average real increases in DUOS charges excluding CCL",null,"%"]
[null,"Expected average real increases in CCL charge per MWh",null,"%"]
[null,"Expected average real increases in TUOS charges",null,"%"]
[null,{"$f":"\"Inflation rate to convert to nominal increases in \"&G40","v":"Inflation rate to convert to nominal increases in 2013"},null,"%"]
[null,"Note:  If you cannot separate DUOS and TUOS charges, please enter the NOUS charges and percentage increases in section 1.1. Please indicate that  have done  in the \"RETALIER'S COMMENTS\" column"]
[]
[]
[]
[null,"Table 3 - Regulated Tariffs (excluding GST)"]
[null,null,null,"Tariffs for financial year ending 30 June",{"$f":"F65-1","v":2011},{"$f":"G65-1","v":2012},{"$f":"G40","v":2013},{"$f":"G65+1","v":2014},{"$f":"H65+1","v":2015},2016,{"$f":"'1. Customers'!P$17","v":"RETAILER'S COMMENTS"}]
[null,null,null,null,"Actual","Actual","Actual",{"$f":"'1. Customers'!M$18","v":"Forecast"},{"$f":"'1. Customers'!N$18","v":"Forecast"},{"$f":"'1. Customers'!O$18","v":"Forecast"}]
[]
[null,"Residential Block or Single Rate Tariffs "]
[null,"<name>"]
[null,"Fixed charge","c/day"]
[]
[null,"Block 1 up to","kWh per quarter"]
[null,"Block 2 up to",{"$f":"C72","v":"kWh per quarter"}]
[]
[null,"Block 1 tariff","c/kWh"]
[null,"Block 2 tariff","c/kWh"]
[null,"Block 3 tariff","c/kWh"]
[]
[null,"Residential Controlled Load A"]
[null,"<name>"]
[null,"Fixed charge","c/day"]
[null,"Usage charge","c/kWh"]
[]
[null,"Business Block and Single Rate Tariffs"]
[null,"<name>"]
[null,"Fixed charge","c/day"]
[]
[null,"Block 1 up to",{"$f":"C72","v":"kWh per quarter"}]
[]
[null,"Block 1 tariff","c/kWh"]
[null,"Block 2 tariff","c/kWh"]
[]
[null,"Note: Please provide information for the most common tariff in each category.  There tariff are used to calculated typical customer bills."]

{"sheet":"8. Depreciation ","index":9,"n_rows":34,"n_cols":11,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"checklist!B2","v":"Information Requirement for Electricity Retail Businesses (November 2012)"}]
[null,"Agency:",{"$f":"checklist!F5","v":0}]
[]
[null,"8. Depreciation & Amortisation "]
[]
[null,"Allocate amounts of amortisation and depreciation to asset classes, consistently with reporting system typically used."]
[]
[null,"Colour coding of input sheets:"]
[null,"Light blue = Input cells recording actual historical data.  Information is compulsory."]
[null,"Yellow = Forecasts inputs. Information is compulsory"]
[null,"grey = no information required."]
[null,"black against a white background = calcuations. No information required."]
[null,"Pink type = ERROR CHECK boxes. No information required."]
[]
[]
[null,"Table 1 - Depreciation & Amortisation of the NSW business (including regulated and unregulated customers)  "]
[null,null,null,"Financial year ending 30 June",null,2011,2012,2013,2014,2015,2016]
[null,null,null,null,null,"Actual","Actual","Forecast","Forecast","Forecast","Forecast"]
[null,null,null,"units",null,"nominal","nominal","$12/13","$12/13","$12/13","$12/13"]
[]
[null,"1.1 Depreciation "]
[null,"Buildings",null,"$'000"]
[null,"Computer Hardware",null,"$'000"]
[null,"Other Items",null,"$'000"]
[null,"Asset 4  (describe)",null,"$'000"]
[null,"Asset 5  (describe)",null,"$'000"]
[null,"Asset 6  (describe)"]
[]
[null,"1.2 Amortisation"]
[null,"Asset 1  (describe)",null,"$'000"]
[null,"Asset 2  (describe)",null,"$'000"]
[null,"Asset 3  (describe)",null,"$'000"]
[null,"Asset 4  (describe)",null,"$'000"]
[null,"Asset 5  (describe)",null,"$'000"]