{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Cover","Contents","1. F-Factor summary","2. Individual fire start info","3. Systems and Audit"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":2,"defined_names":97,"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":"Cover","index":0,"n_rows":44,"n_cols":6,"rows_kept":44,"cut":false,"hidden":false,"merged":[[10,0,11,8],[12,0,12,8],[15,0,15,8],[14,0,14,8],[43,1,43,5],[37,1,37,2],[37,3,37,6],[41,1,41,5],[42,1,42,5],[33,1,33,2],[33,3,33,6],[36,1,36,2],[36,3,36,6],[16,0,16,8],[32,1,32,2],[32,3,32,6],[23,2,23,4],[26,2,26,4],[27,2,27,4],[25,2,25,4]]}
[]
[]
[]
[]
[]
[]
[]
["Distribution Network Service Provider"]
["Fire start report"]
[]
["This template is to be used by a DNSP to provide a fire start report to the AER in accordance with section 5 of the F-factor Order in Council.  "]
[]
["Colour coding of input sheets:"]
["Dark blue = AER insructions/headings"]
["Yellow = Input cells"]
["Grey - Not applicable/No inputs required"]
[]
["Leave coloured cells blank if no information exists - PLEASE DO NOT ENTER TEXT unless specifically requested to do so."]
["All dollar amounts are to be unrounded, and in nominal terms."]
[]
[]
[]
[]
["DNSP - trading name:",null,"Jemena Electricity Networks (Vic) Ltd"]
[]
["DNSP - Australian business number: ",null,"82 064 651 083 "]
[]
["Reporting year:",null,2016]
[]
[]
[]
[]
["Business address","Address",null,"567 Collins St "]
[null,"Suburb",null,"Melbourne"]
[null,null,"State","Victoria","Postcode",3000]
[]
["Postal address","Address",null,"567 Collins St "]
[null,"Suburb",null,"Melbourne"]
[null,null,"State","Victoria","Postcode",3000]
[]
[]
["Contact name/s","Matthew Serpell"]
["Contact phone/s","03 9173 7000"]
["Contact email address/s","matthew.serpell@jemena.com.au"]

{"sheet":"Contents","index":1,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":false,"merged":[[2,4,2,10]]}
[" "]
[]
[null,null,null,null,"Electricity Distribution Network Service Provider    F-factor Reporting Template"]
[]
[null,null,null,null,null,null,null,"Table of contents"]
[]
[]
[null,null,"Cover sheet",null,null,"2. Fire start report"]
[]
[]
[]
[null,null,"1. F-factor summary",null,null,"3. Systems and Audit"]

{"sheet":"1. F-Factor summary","index":2,"n_rows":48,"n_cols":4,"rows_kept":48,"cut":false,"hidden":false,"merged":[[22,1,26,1],[30,1,34,1],[19,1,19,2],[3,6,3,8],[4,6,4,8],[5,6,5,8],[9,1,9,5],[14,1,14,5],[12,1,12,3],[27,1,29,1]]}
[null,{"$f":"IF(Cover!C24=\"\",\"[DNSP Name]\", Cover!C24)","v":"Jemena Electricity Networks (Vic) Ltd"}]
[null,"F-factor data reporting"]
[null,{"$f":"IF(Cover!C28=\"\",\"[Year]\",Cover!C28)","v":2016}]
[]
[]
[null,"Instructions:"]
[]
[null,{"$f":"IF(Cover!C24=\"\",\"[DNSP Name] must provide:\", CONCATENATE(Cover!C24,\" must provide:\"))","v":"Jemena Electricity Networks (Vic) Ltd must provide:"}]
[]
[null,"Table 1 - Summary of fire starts. This table should provide a high level summary of all fire starts contained in worksheet \"2. Fire Start Report\"."]
[]
[]
[null,"\"Fire\" should be interpreted using its common meaning and can be defined as a process in which substances combine chemically with oxygen from the air and typically give out bright light, heat and smoke. A fire should be recorded where there is evidence of smoking, charring, scorching, burning or any other evidence that a fire had occurred.  "]
[]
[]
[]
[]
[]
[null,"Table 1: Summary of total fire starts (generally based on ESV definitions)"]
[null,"This is a summary of data in worksheet \"2. Fire Start Report\""]
[null,null,null,"Year"]
[null,"Fire Start by Category","Fire Start by Asset",2016]
[null,"Asset failures resulting in grass/vegetation fire","Pole and cross arm failure or Pole and cross arm fire",0]
[null,null,"Oil-filled plant",0]
[null,null,"HV Fuse",0]
[null,null,"Other Assets",2]
[null,null,"Any fire triggered by any asset failure caused by Lightning",0]
[null,"Grass/vegetation fires from assets (non-asset failures)","Fire starts in grass/vegetation resulting from animal contact with network assets",2]
[null,null,"Fire starts in grass/vegetation resulting from trees contacting network assets",1]
[null,null,"Fire starts in grass/vegetation resulting from other causes (vehicle strikes, vandalism etc)",3]
[null,"Asset failures resulting in asset fire (no grass/vegetation fire)","Pole and cross arm fire (including ‘smouldering’ or ‘smoke’)",11]
[null,null,"Oil-filled plant fire",0]
[null,null,"HV Fuse Failure (including ‘hang-ups’ and ‘candling’)",1]
[null,null,"Other Assets",4]
[null,null,"Any fire triggered by any asset failure caused by Lightning",0]
[null,"Any other Fire Start","Any additional fires, caused by any asset failure, not reported to the ESV and required to be reported by the f-factor Order",0]
[null,"Total",null,24]
[]
[]
[null,"Table 2: Summary of total fire starts by F factor Order definition"]
[null,"Kind of Fire Start by definition of fire start under clause 4 of F-factor Order","Year "]
[null,null,2016]
[null,"Started by any tree, or part of a tree, falling upon or coming into contact with a distribution system",1]
[null,"Started by any person, bird, reptile or other animal coming into contact with a distribution system",2]
[null,"Started by lightning striking a distribution system or a part of a distribution system ",0]
[null,"Started by any other thing forming part of or coming into contact with a distribution system",21]
[null,"Otherwise started by a distribution system",0]
[null,"Total",24]

{"sheet":"2. Individual fire start info","index":3,"n_rows":121,"n_cols":19,"rows_kept":121,"cut":false,"hidden":false,"merged":[[3,19,3,21],[4,19,4,21],[5,19,5,21],[7,1,7,18],[21,1,21,15],[9,1,9,2],[11,1,11,8],[18,1,18,18],[19,1,19,18],[12,1,12,17],[13,1,13,15],[14,1,14,15],[15,1,15,15],[16,1,16,15],[25,1,25,15],[17,1,17,18],[20,1,20,18],[23,1,23,15],[27,1,27,15],[22,1,22,15],[24,1,24,16],[26,1,26,15],[34,3,34,7],[34,8,34,10],[28,1,28,15],[34,13,34,18],[34,11,34,12],[32,1,32,4]]}
[null,{"$f":"IF(Cover!C24=\"\",\"[DNSP Name]\", Cover!C24)","v":"Jemena Electricity Networks (Vic) Ltd"}]
[null,"F-factor data reporting"]
[null,{"$f":"IF(Cover!C28=\"\",\"[Year]\",Cover!C28)","v":2016}]
[]
[]
[null,"Instructions:"]
[]
[null,"Enter into this worksheet fire start data, from any IT system, which have been recorded by the DNSP. Note that fire starts must be in accordance with the definition of a fire start in the Order In Council."]
[]
[null,{"$f":"IF(Cover!C24=\"\",\"[DNSP Name] must provide:\", CONCATENATE(Cover!C24,\" must provide:\"))","v":"Jemena Electricity Networks (Vic) Ltd must provide:"}]
[]
[null,"Table 3 - Individual Fire Starts"]
[null,"   (1) Date - dd/mm/yyyy"]
[null,"   (2) Time - if known, the time of the fire start hh:mm"]
[null,"   (3) Location - GPS, Map reference or other unique identifier"]
[null,"   (4) Feeder ID"]
[null,"   (5) Network Categorisation - CBD, Urban, Rural Long or Rural Short"]
[null,"   (6) Fire Start by Category - In accordance with ESV reporting guidelines and additional categories created as required. "]
[null,"   (7) Fire Start by Asset - In accordance with ESV reporting guidelines and additional categories created as required."]
[null,"   (8) Kind of Fire Start F-factor Order - In accordance with Clause 4 of the F-factor order in council"]
[null,"   (9) Daily CFA Fire danger rating"]
[null,"  (10) Fire danger period declared - Y/N. Has the CFA declared a fire danger period under the Country Fire Authority Act 1958?"]
[null,"  (11) Estimated area burnt"]
[null,"  (12) Descripition of property damaged by the fire - Free text describing the types of properties damaged as result of the fire "]
[null,"  (13) Reported to relevant entity - Y/N"]
[null,"  (14) Record Number - Any unique identifier associated with the event contained within the DNSPs reporting system."]
[null,"  (15) Additional Evidence available - Y/N Examples could include CFA, MFB or linesman report of incident."]
[null,"  (16) Fault descripition - Free text containing relevant comments from field reports "]
[null,"  (17) High Bushfire Risk Area - Fire Hazard Rating (high or low bushfire risk) as assigned by CFA & MFB under s.80 of the Electricity Safety Act"]
[]
[]
[]
[null,"Table 3: Individual Fire Starts"]
[]
[null,"Fire Starts",null,null,null,null,null,null,"Fire Type",null,null,"Risk Factors",null,"Reporting"]
[null,null,"Date","Time","Location","Feeder ID","Network categorisation","High Bushfire Risk Area","Fire Start by ESV category","Fire Start by Asset","Kind of Fire Start by F-factor Order  - Clause 4","CFA fire danger rating","Fire Danger period declared?","Estimated area burnt","Description of types of property damaged","Reported to a relevant entity?","Record Number","Additional evidence available?","Fault description"]
[null,1,"2016-01-13","15:20:00","\n54 Salisbury Ave, Ivanhoe","HB15","Urban","No","Grass/vegetation fires from assets (non-asset failures)","Fire starts in grass/vegetation resulting from trees contacting network assets","Started by any tree, or part of a tree, falling upon or coming into contact with a distribution system","Severe","Yes","<5","Minor grass fire","Yes",128385,"Yes","Tree branch contact with network assets resulted in a minor grass fire."]
[null,2,"2016-01-13","16:20:00","8/2 Tullamarine park Rd, Tullamarine","AW3","Urban","No","Asset failures resulting in grass/vegetation fire","Other Assets","Started by any other thing forming part of or coming into contact with a distribution system","Severe","Yes","<2","Minor grass fire","Yes",128391,"Yes","Trifurcating cable head failure resulted in a minor grass fire."]
[null,3,"2016-01-14","11:03:00","1 Loddon Ave, Reservoir","TT10","Urban","No","Asset failures resulting in asset fire (no grass/vegetation fire)","Pole and cross arm fire (including ‘smouldering’ or ‘smoke’)","Started by any other thing forming part of or coming into contact with a distribution system","High","Yes","<0.2","Confined to pole top","Yes",128487,"Yes","Cross arm fire.\nCross arm replaced with a new steel arm."]
[null,4,"2016-01-14","15:46:00","24 Gordon St, Maribyrnong","BY12","Urban","No","Asset failures resulting in asset fire (no grass/vegetation fire)","Pole and cross arm fire (including ‘smouldering’ or ‘smoke’)","Started by any other thing forming part of or coming into contact with a distribution system","High","Yes","<0.2","Confined to pole top","Yes",128508,"Yes","Cross arm fire.\nCross arm replaced with a new steel arm."]
[null,5,"2016-01-17","15:10:00","645 Geelong Rd, Brooklyn ","FW6","Urban","No","Asset failures resulting in grass/vegetation fire","Other Assets","Started by any other thing forming part of or coming into contact with a distribution system","Very High","Yes","<10","Minor grass fire","Yes",128593,"Yes","Conductor clashing resulted in a minor grass fire."]
[null,6,"2016-01-20","09:14:00","4 Edward Street, Macleod","NH2","Urban","No","Asset failures resulting in asset fire (no grass/vegetation fire)","Pole and cross arm fire (including ‘smouldering’ or ‘smoke’)","Started by any other thing forming part of or coming into contact with a distribution system","Low-Moderate","Yes","<0.2","Confined to pole top","Yes",128736,"Yes","Cross arm fire.\nCross arm replaced with a new steel arm."]
[null,7,"2016-01-22","08:50:00","31 Victoria St, Flemington","FT5","Urban","No","Asset failures resulting in asset fire (no grass/vegetation fire)","Pole and cross arm fire (including ‘smouldering’ or ‘smoke’)","Started by any other thing forming part of or coming into contact with a distribution system","Low-Moderate","Yes","<0.2","Confined to pole top","Yes",128845,"Yes","Cross arm fire.\nCross arm replaced with a new steel arm."]
[null,8,"2016-01-22","19:17:00","42 Maffra St, Coolaroo","BD1","Urban","No","Asset failures resulting in asset fire (no grass/vegetation fire)","Pole and cross arm fire (including ‘smouldering’ or ‘smoke’)","Started by any other thing forming part of or coming into contact with a distribution system","Low-Moderate","Yes","<0.2","Confined to pole top","Yes",128889,"Yes","Cross arm fire.\nCross arm replaced with a new steel arm."]
[null,9,"2016-01-31","15:39:00","189-209 Camp Rd, Broadmeadows","BMS23","Urban","No","Asset failures resulting in asset fire (no grass/vegetation fire)","Pole and cross arm fire (including ‘smouldering’ or ‘smoke’)","Started by any other thing forming part of or coming into contact with a distribution system","Low-Moderate","Yes","<0.2","Confined to pole top","Yes",129250,"Yes","Vehicle impact with network assets resulted in pole top fire."]
[null,10,"2016-02-02","15:54:00","23 Lara Way, Campbellfield","SMTS-SSS","Urban","No","Grass/vegetation fires from assets (non-asset failures)","Fire starts in grass/vegetation resulting from other causes (vehicle strikes, vandalism etc)","Started by any other thing forming part of or coming into contact with a distribution system","Low-Moderate","Yes","< 160","Minor burning to pole, fence & vegetation","Yes",129432,"Yes","Airborne debris (air-conditioner tubing) contact with overhead line resulted in burning to pole and  fence and, minor grass fire."]
[null,11,"2016-02-15","11:50:00","Cnr Lower Heidelberg Rd & Bourke Rd, Ivanhoe East","HB24","Urban","No","Grass/vegetation fires from assets (non-asset failures)","Fire starts in grass/vegetation resulting from other causes (vehicle strikes, vandalism etc)","Started by any other thing forming part of or coming into contact with a distribution system","High","Yes","<4","Minor grass fire","Yes",129899,"Yes","Vehicle impact with communication cable caused high voltage conductor clashing which resulted in a minor grass fire."]
[null,12,"2016-03-04","22:05:00","522 Ballarat Rd, Albion","KTS-BY","Urban","No","Asset failures resulting in asset fire (no grass/vegetation fire)","Pole and cross arm fire (including ‘smouldering’ or ‘smoke’)","Started by any other thing forming part of or coming into contact with a distribution system","High","Yes","<0.2","Confined to pole top","Yes",10248233,"Yes","Cross arm fire.\nCross arm replaced with a new steel arm."]
[null,13,"2016-03-07","20:50:00","89 Esplanade, Williamstown ","NT15","Urban","No","Asset failures resulting in asset fire (no grass/vegetation fire)","Other Assets","Started by any other thing forming part of or coming into contact with a distribution system","High","Yes","<0.2","Confined to public light","Yes",10248303,"Yes","Public light lantern caught fire. Lantern replaced."]
[null,14,"2016-03-18","03:15:00","25 Ovata Dr, Tullamarine","AW11","Urban","No","Asset failures resulting in asset fire (no grass/vegetation fire)","Pole and cross arm fire (including ‘smouldering’ or ‘smoke’)","Started by any other thing forming part of or coming into contact with a distribution system","High","Yes","<0.2","Confined to pole","Yes",131252,"Yes","Pole and cross arm fire.\nPole has been replaced."]
[null,15,"2016-03-20","09:50:00","Cnr Nolans Rd & Riddell Rd, Riddells Creek","SBY11","Rural","Yes","Asset failures resulting in asset fire (no grass/vegetation fire)","HV Fuse Failure (including ‘hang-ups’ and ‘candling’)","Started by any other thing forming part of or coming into contact with a distribution system","Low-Moderate","Yes","<0.2","Confined to fuse cartridge","Yes",131317,"Yes","Candling fuse.\nFuse has been replaced."]
[null,16,"2016-03-21","10:56:00","10 Buckley Rd, Diggers Rest ","SHM11","Rural","Yes","Grass/vegetation fires from assets (non-asset failures)","Fire starts in grass/vegetation resulting from animal contact with network assets","Started by any person, bird, reptile or other animal coming into contact with a distribution system","Low-Moderate","Yes","<156","Minor grass fire","Yes",131350,"Yes","Animal contact with network assets resulted in a minor grass fire."]
[null,17,"2016-04-06","07:31:00","3 Carson St, Reservoir ","TT10","Urban","No","Asset failures resulting in asset fire (no grass/vegetation fire)","Pole and cross arm fire (including ‘smouldering’ or ‘smoke’)","Started by any other thing forming part of or coming into contact with a distribution system","Low-Moderate","No","<0.2","Confined to pole top","Yes",131829,"Yes","Cross arm fire.\nCross arm replaced with a new steel arm."]
[null,18,"2016-04-09","12:10:00","101 Mickleham Rd, Tullamarine","AW9","Urban","No","Grass/vegetation fires from assets (non-asset failures)","Fire starts in grass/vegetation resulting from other causes (vehicle strikes, vandalism etc)","Started by any other thing forming part of or coming into contact with a distribution system","Low-Moderate","No","<1","Minor grass fire","Yes",131989,"Yes","Vehicle impact with communication cable caused low voltage conductor clashing which resulted in a minor grass fire."]
[null,19,"2016-04-15","14:00:00","2122 Sydney Rd, Campbellfield ","ST23","Urban","No","Grass/vegetation fires from assets (non-asset failures)","Fire starts in grass/vegetation resulting from animal contact with network assets","Started by any person, bird, reptile or other animal coming into contact with a distribution system","High","No","<5","Minor grass fire","Yes",132201,"Yes","Animal contact with network assets resulted in a minor grass fire."]
[null,20,"2016-04-21","02:37:00","339 Gilbert Rd, Preston","CS3","Urban","No","Asset failures resulting in asset fire (no grass/vegetation fire)","Other Assets","Started by any other thing forming part of or coming into contact with a distribution system","Low-Moderate","No","<0.2","Confined to public light","Yes",132361,"Yes","Public light lantern caught fire. Lantern replaced."]
[null,21,"2016-04-22","03:09:00","Cnr Bamfield Rd & Dougharty Rd, Heidelberg Heights","NH3","Urban","No","Asset failures resulting in asset fire (no grass/vegetation fire)","Pole and cross arm fire (including ‘smouldering’ or ‘smoke’)","Started by any other thing forming part of or coming into contact with a distribution system","Low-Moderate","No","<0.2","Confined to pole top","Yes",132423,"Yes","Vehicle impact with distribution pole resulted in a cross arm fire."]
[null,22,"2016-05-18","10:21:00","129 Rennie St, Coburg","CS9","Urban","No","Asset failures resulting in asset fire (no grass/vegetation fire)","Pole and cross arm fire (including ‘smouldering’ or ‘smoke’)","Started by any other thing forming part of or coming into contact with a distribution system","Unavailable","No","<0.2","Confined to pole top","Yes",133396,"Yes","Cross arm fire.\nCross arm replaced with a new steel arm."]
[null,23,"2016-05-28","19:18:00","8 Ford St, Footscray","FE8","Urban","No","Asset failures resulting in asset fire (no grass/vegetation fire)","Other Assets","Started by any other thing forming part of or coming into contact with a distribution system","Unavailable","No","<0.2","Confined to pole mounted low voltage connection boxes","Yes",133824,"Yes","Pole junction box fire.\nJunction boxes have been replaced."]
[null,24,"2016-06-04","09:56:00","5 Joynt St, Macleod ","NH3","Urban","No","Asset failures resulting in asset fire (no grass/vegetation fire)","Other Assets","Started by any other thing forming part of or coming into contact with a distribution system","Unavailable","No","<0.2","Confined to transformer high voltage insulated leads","Yes",134100,"Yes","Transformer leads failed resulting minor burning of the leads.\nThe HV leads were replaced."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"."]

{"sheet":"3. Systems and Audit","index":4,"n_rows":26,"n_cols":5,"rows_kept":26,"cut":false,"hidden":false,"merged":[[25,1,26,4],[3,5,3,6],[4,5,4,6],[5,5,5,6],[6,1,6,4],[9,1,9,4],[14,1,14,4],[10,1,10,4],[13,1,13,4],[12,1,12,4],[11,1,11,4]]}
[null,{"$f":"IF(Cover!C24=\"\",\"[DNSP Name]\", Cover!C24)","v":"Jemena Electricity Networks (Vic) Ltd"}]
[null,"F-factor data reporting"]
[null,{"$f":"IF(Cover!C28=\"\",\"[Year]\",Cover!C28)","v":2016}]
[]
[]
[null,"Instructions:"]
[]
[null,{"$f":"IF(Cover!C24=\"\",\"[DNSP Name] must provide:\", CONCATENATE(Cover!C24,\" must provide:\"))","v":"Jemena Electricity Networks (Vic) Ltd must provide:"}]
[]
[null,"Table 4 - Information or reporting systems"]
[null,"   (1) Name of any IT system used to collect fire start data or fault event data - i.e. SCADA system, or fault reporting system"]
[null,"   (2) Whether the fire recording or fault recording process has been audited or complies with a relevant Australian or industry standard - Yes or No"]
[null,"   (3) List any relevant Australian or industry standards that the fire recording or fault recording process complies with"]
[null,"   (4) Whether the data entered into or removed from the IT system has been audited - Yes or No"]
[]
[]
[null,"Table 4: Information or reporting systems"]
[]
[null,"Information or reporting systems","Name","System Audited","Relevant Standards"]
[null,"System 1","SAP Plant Maintenance Module","Yes","None"]
[null,"System 2","Outage Management System (OMS/CMOS)","Yes","Jemena, JEN PR 0502, \"JEN AER Network Reliability Reporting Procedure\""]
[null,"System 3 ","ESV Fault Reporting Register (OSIRIS)","Yes","Energy Safe Victoria, \"Electrical Incident and Safety Performance Reporting Guidelines\""]
[null,"System 4"]
[null,"System 5"]
[null,"   JEN's explanatory note:"]
[null,"   'The SGSPAA Internal Audit function undertakes a programme of work in accordance with the SGSPAA Group Internal Audit Plan. This internal audit activity covers elements of the systems and process used for capturing, recording and maintaining fire start data."]