{"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":47,"n_cols":6,"rows_kept":47,"cut":false,"hidden":false,"merged":[[36,1,36,2],[36,3,36,6],[39,1,39,2],[39,3,39,6],[17,0,17,8],[35,1,35,2],[35,3,35,6],[30,2,30,4],[28,2,28,4],[24,2,24,4],[24,0,24,1],[26,2,26,4],[29,2,29,4],[18,0,18,8],[19,0,19,8],[20,0,23,8],[46,1,46,5],[40,1,40,2],[40,3,40,6],[44,1,44,5],[45,1,45,5],[10,0,11,8],[12,0,12,8],[15,0,15,8],[14,0,14,8],[13,0,13,8]]}
[]
[]
[]
[]
[]
[]
[]
["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 headings"]
["Grey = AER instructions"]
["Yellow = Input cells"]
["Light orange = Automatically-generated cells"]
[]
["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:",null,"CitiPower"]
[]
["DNSP - trading name:",null,"CitiPower Pty Ltd"]
[]
["DNSP - Australian business number: ",null,"76 064 651 056"]
[]
["Reporting year:",null,"2016/17"]
[]
[]
[]
[]
["Business address","Address",null,"40 Market Street"]
[null,"Suburb",null,"Melbourne"]
[null,null,"State","Victoria","Postcode",3000]
[]
["Postal address","Address",null,"Locked Bag 14090"]
[null,"Suburb",null,"Melbourne"]
[null,null,"State","Victoria","Postcode",8001]
[]
[]
["Contact name/s","Mark de Villiers"]
["Contact phone/s",396834907]
["Contact email address/s","mdevilliers@powercor.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":147,"n_cols":15,"rows_kept":147,"cut":false,"hidden":false,"merged":[[26,1,26,2],[8,1,12,1],[16,1,20,1],[5,1,5,2],[3,6,3,8],[4,6,4,8],[5,6,5,8],[13,1,15,1],[6,3,7,3]]}
[null,{"$f":"IF(Cover!C25=\"\",\"[DNSP Name]\", Cover!C25)","v":"CitiPower"},"IRU target:",{"$f":"IF(SUM(K6:O6)=0,\"\",SUM(K6:O6))","v":3.4},null,null,null,null,null,null,"AusNet Services","CitiPower","Jemena","Powercor","United Energy"]
[null,"F-factor data reporting","IRU amount:",{"$f":"IF(SUM('2. Individual fire start info'!U40:U126)=0,\"\",SUM('2. Individual fire start info'!U40:U126))","v":0.52},null,null,null,null,null,"2016/17",247.7,3.4,9.6999999999999993,468,22.3]
[null,{"$f":"IF(Cover!C31=\"\",\"[Year]\",Cover!C31)","v":"2016/17"},"Revenue adjustment:",{"$f":"IF(OR(D1=\"\",D2=\"\"),\"\",15000*(D1-D2))","v":43200},null,null,null,null,null,"2017/18",247.7,3.4,9.6999999999999993,468,22.3]
[null,null,null,null,null,null,null,null,null,"2018/19",247.7,3.4,9.6999999999999993,468,22.3]
[null,"Table 1: Summary of total fire starts",null,null,null,null,null,null,null,"2019/20",221.1,3.4,9.6999999999999993,412.8,22.3]
[null,"This is a summary of data in worksheet \"2. Fire Start Report\"",null,null,null,null,null,null,null,null,{"$f":"IF(OR($B3=\"[Year]\",$B1=\"[DNSP Name]\",$B1<>K1),\"\",LOOKUP($B3,$J2:$J5,K2:K5))","v":""},{"$f":"IF(OR($B3=\"[Year]\",$B1=\"[DNSP Name]\",$B1<>L1),\"\",LOOKUP($B3,$J2:$J5,L2:L5))","v":3.4},{"$f":"IF(OR($B3=\"[Year]\",$B1=\"[DNSP Name]\",$B1<>M1),\"\",LOOKUP($B3,$J2:$J5,M2:M5))","v":""},{"$f":"IF(OR($B3=\"[Year]\",$B1=\"[DNSP Name]\",$B1<>N1),\"\",LOOKUP($B3,$J2:$J5,N2:N5))","v":""},{"$f":"IF(OR($B3=\"[Year]\",$B1=\"[DNSP Name]\",$B1<>O1),\"\",LOOKUP($B3,$J2:$J5,O2:O5))","v":""}]
[null,null,null,"Total fires by category"]
[null,"Fire Start by Category","Fire Start by Asset"]
[null,"Asset failures resulting in grass/vegetation fire","Pole and cross arm failure or Pole and cross arm fire",{"$f":"COUNTIF('2. Individual fire start info'!$K$40:$K$127,'1. F-Factor summary'!$J9)","v":0},null,null,null,null,null,{"$f":"B9&\" : \"&C9","v":"Asset failures resulting in grass/vegetation fire : Pole and cross arm failure or Pole and cross arm fire"}]
[null,null,"Oil-filled plant",{"$f":"COUNTIF('2. Individual fire start info'!$K$40:$K$127,'1. F-Factor summary'!$J10)","v":0},null,null,null,null,null,{"$f":"B9&\" : \"&C10","v":"Asset failures resulting in grass/vegetation fire : Oil-filled plant"}]
[null,null,"HV Fuse",{"$f":"COUNTIF('2. Individual fire start info'!$K$40:$K$127,'1. F-Factor summary'!$J11)","v":0},null,null,null,null,null,{"$f":"B9&\" : \"&C11","v":"Asset failures resulting in grass/vegetation fire : HV Fuse"}]
[null,null,"Other Assets",{"$f":"COUNTIF('2. Individual fire start info'!$K$40:$K$127,'1. F-Factor summary'!$J12)","v":1},null,null,null,null,null,{"$f":"B9&\" : \"&C12","v":"Asset failures resulting in grass/vegetation fire : Other Assets"}]
[null,null,"Any fire triggered by any asset failure caused by Lightning",{"$f":"COUNTIF('2. Individual fire start info'!$K$40:$K$127,'1. F-Factor summary'!$J13)","v":0},null,null,null,null,null,{"$f":"B9&\" : \"&C13","v":"Asset failures resulting in grass/vegetation fire : Any fire triggered by any asset failure caused by Lightning"}]
[null,"Grass/vegetation fires from assets (non-asset failures)","Fire starts in grass/vegetation resulting from animal contact with network assets",{"$f":"COUNTIF('2. Individual fire start info'!$K$40:$K$127,'1. F-Factor summary'!$J14)","v":0},null,null,null,null,null,{"$f":"B14&\" : \"&C14","v":"Grass/vegetation fires from assets (non-asset failures) : Fire starts in grass/vegetation resulting from animal contact with network assets"}]
[null,null,"Fire starts in grass/vegetation resulting from trees contacting network assets",{"$f":"COUNTIF('2. Individual fire start info'!$K$40:$K$127,'1. F-Factor summary'!$J15)","v":0},null,null,null,null,null,{"$f":"B14&\" : \"&C15","v":"Grass/vegetation fires from assets (non-asset failures) : Fire starts in grass/vegetation resulting from trees contacting network assets"}]
[null,null,"Fire starts in grass/vegetation resulting from other causes (vehicle strikes, vandalism etc)",{"$f":"COUNTIF('2. Individual fire start info'!$K$40:$K$127,'1. F-Factor summary'!$J16)","v":0},null,null,null,null,null,{"$f":"B14&\" : \"&C16","v":"Grass/vegetation fires from assets (non-asset failures) : Fire starts in grass/vegetation resulting from other causes (vehicle strikes, vandalism etc)"}]
[null,"Asset failures resulting in asset fire (no grass/vegetation fire)","Pole and cross arm fire (including ‘smouldering’ or ‘smoke’)",{"$f":"COUNTIF('2. Individual fire start info'!$K$40:$K$127,'1. F-Factor summary'!$J17)","v":1},null,null,null,null,null,{"$f":"B17&\" : \"&C17","v":"Asset failures resulting in asset fire (no grass/vegetation fire) : Pole and cross arm fire (including ‘smouldering’ or ‘smoke’)"}]
[null,null,"Oil-filled plant fire",{"$f":"COUNTIF('2. Individual fire start info'!$K$40:$K$127,'1. F-Factor summary'!$J18)","v":0},null,null,null,null,null,{"$f":"B17&\" : \"&C18","v":"Asset failures resulting in asset fire (no grass/vegetation fire) : Oil-filled plant fire"}]
[null,null,"HV Fuse Failure (including ‘hang-ups’ and ‘candling’)",{"$f":"COUNTIF('2. Individual fire start info'!$K$40:$K$127,'1. F-Factor summary'!$J19)","v":0},null,null,null,null,null,{"$f":"B17&\" : \"&C19","v":"Asset failures resulting in asset fire (no grass/vegetation fire) : HV Fuse Failure (including ‘hang-ups’ and ‘candling’)"}]
[null,null,"Other Assets",{"$f":"COUNTIF('2. Individual fire start info'!$K$40:$K$127,'1. F-Factor summary'!$J20)","v":10},null,null,null,null,null,{"$f":"B17&\" : \"&C20","v":"Asset failures resulting in asset fire (no grass/vegetation fire) : Other Assets"}]
[null,null,"Any fire triggered by any asset failure caused by Lightning",{"$f":"COUNTIF('2. Individual fire start info'!$K$40:$K$127,'1. F-Factor summary'!$J21)","v":0},null,null,null,null,null,{"$f":"B17&\" : \"&C21","v":"Asset failures resulting in asset fire (no grass/vegetation fire) : Any fire triggered by any asset failure caused by Lightning"}]
[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",{"$f":"COUNTIF('2. Individual fire start info'!$K$40:$K$127,'1. F-Factor summary'!$J22)","v":0},null,null,null,null,null,{"$f":"B22&\" : \"&C22","v":"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"}]
[null,"Total",null,{"$f":"SUM(D9:D22)","v":12}]
[]
[]
[null,"Table 2: Summary of total fire starts by F factor Order definition"]
[null,"This is a summary of data in worksheet \"2. Fire Start Report\""]
[null,"Kind of Fire Start by definition of fire start under clause 5 of F-factor Order","Total fires by cause",null,null,null,null,null,null,"Overhead conductors"]
[null,"Started in or originated from a distribution system",{"$f":"COUNTIF('2. Individual fire start info'!$N$40:$N$127,'1. F-Factor summary'!$B29)","v":12},null,null,null,null,null,null," - overhead conductor (bare; aluminium core steel reinforced)"]
[null,"Started by any tree, or part of a tree, falling upon or coming into contact with a distribution system",{"$f":"COUNTIF('2. Individual fire start info'!$N$40:$N$127,'1. F-Factor summary'!$B30)","v":0},null,null,null,null,null,null," - overhead conductor (bare; all aluminium conductor)"]
[null,"Started by any person, bird, reptile or other animal coming into contact with a distribution system",{"$f":"COUNTIF('2. Individual fire start info'!$N$40:$N$127,'1. F-Factor summary'!$B31)","v":0},null,null,null,null,null,null," - overhead conductor (bare; copper)"]
[null,"Started by lightning striking a distribution system or a part of a distribution system ",{"$f":"COUNTIF('2. Individual fire start info'!$N$40:$N$127,'1. F-Factor summary'!$B32)","v":0},null,null,null,null,null,null," - overhead conductor (bare; steel)"]
[null,"Started by any other thing forming part of or coming into contact with a distribution system",{"$f":"COUNTIF('2. Individual fire start info'!$N$40:$N$127,'1. F-Factor summary'!$B33)","v":0},null,null,null,null,null,null," - overhead conductor (ABC)"]
[null,"Otherwise started by a distribution system",{"$f":"COUNTIF('2. Individual fire start info'!$N$40:$N$127,'1. F-Factor summary'!$B34)","v":0},null,null,null,null,null,null," - overhead conductor (covered uninsulated)"]
[null,"Total",{"$f":"SUM(C29:C34)","v":12},null,null,null,null,null,null," - overhead conductor (insulated)"]
[null,null,null,null,null,null,null,null,null,"Service lines"]
[null,null,null,null,null,null,null,null,null," - overhead service conductor (residential)"]
[null,null,null,null,null,null,null,null,null," - overhead service conductor (commercial / industrial)"]
[null,null,null,null,null,null,null,null,null," - overhead service conductor (subdivision / construction)"]
[null,null,null,null,null,null,null,null,null," - overhead service conductor (other)"]
[null,null,null,null,null,null,null,null,null," - underground service cable (residential)"]
[null,null,null,null,null,null,null,null,null," - underground service cable (commercial / industrial)"]
[null,null,null,null,null,null,null,null,null," - underground service cable (subdivision / construction)"]
[null,null,null,null,null,null,null,null,null," - underground service cable (other)"]
[null,null,null,null,null,null,null,null,null,"Underground cables"]
[null,null,null,null,null,null,null,null,null," - underground cable"]
[null,null,null,null,null,null,null,null,null," - underground communications cable"]
[null,null,null,null,null,null,null,null,null,"Poles"]
[null,null,null,null,null,null,null,null,null," - pole (concrete)"]
[null,null,null,null,null,null,null,null,null," - pole (steel)"]
[null,null,null,null,null,null,null,null,null," - pole (wood)"]
[null,null,null,null,null,null,null,null,null,"Crossarms"]
[null,null,null,null,null,null,null,null,null," - crossarm (wood)"]
[null,null,null,null,null,null,null,null,null," - crossarm (steel)"]
[null,null,null,null,null,null,null,null,null," - crossarm (other)"]
[null,null,null,null,null,null,null,null,null,"Overhead assets"]
[null,null,null,null,null,null,null,null,null," - capacity balancing units"]
[null,null,null,null,null,null,null,null,null," - connector / termination"]
[null,null,null,null,null,null,null,null,null," - dropper / bridge"]
[null,null,null,null,null,null,null,null,null," - guy wire"]
[null,null,null,null,null,null,null,null,null," - insulator tie wires / connections"]
[null,null,null,null,null,null,null,null,null," - insulators"]
[null,null,null,null,null,null,null,null,null," - tower"]
[null,null,null,null,null,null,null,null,null," - traction lines"]
[null,null,null,null,null,null,null,null,null,"Underground assets"]
[null,null,null,null,null,null,null,null,null," - LV pillar"]
[null,null,null,null,null,null,null,null,null," - services pit"]
[null,null,null,null,null,null,null,null,null,"Transformers"]
[null,null,null,null,null,null,null,null,null," - transformer (pole mounted)"]
[null,null,null,null,null,null,null,null,null," - transformer (kiosk mounted)"]
[null,null,null,null,null,null,null,null,null," - transformer (ground outdoor mounted)"]
[null,null,null,null,null,null,null,null,null," - transformer (indoor chamber mounted)"]
[null,null,null,null,null,null,null,null,null," - transformer (any other type)"]
[null,null,null,null,null,null,null,null,null," - measurement transformer (current transformer)"]
[null,null,null,null,null,null,null,null,null," - measurement transformer (voltage transformer)"]
[null,null,null,null,null,null,null,null,null," - measurement transformer (capacitive voltage transformer)"]
[null,null,null,null,null,null,null,null,null,"Fuses and switchgear"]
[null,null,null,null,null,null,null,null,null," - fuse (boric acid)"]
[null,null,null,null,null,null,null,null,null," - fuse (EDO fuse)"]
[null,null,null,null,null,null,null,null,null," - fuse (Fault Tamer)"]
[null,null,null,null,null,null,null,null,null," - fuse (powder filled)"]
[null,null,null,null,null,null,null,null,null," - fuse (any other type)"]
[null,null,null,null,null,null,null,null,null," - circuit breaker"]
[null,null,null,null,null,null,null,null,null," - switch (disconnector/isolator)"]
[null,null,null,null,null,null,null,null,null," - switch (earth)"]
[null,null,null,null,null,null,null,null,null," - switch (FuseSaver)"]
[null,null,null,null,null,null,null,null,null," - switch (any other type)"]
[null,null,null,null,null,null,null,null,null,"SCADA, network control and protection systems"]
[null,null,null,null,null,null,null,null,null," - audio frequency load controller (AFLC)"]
[null,null,null,null,null,null,null,null,null," - arc suppresion coil"]
[null,null,null,null,null,null,null,null,null," - automatic circuit recloser (ACR)"]
[null,null,null,null,null,null,null,null,null," - communications linear assets"]
[null,null,null,null,null,null,null,null,null," - communications network assets"]
[null,null,null,null,null,null,null,null,null," - communications site infrastructure"]
[null,null,null,null,null,null,null,null,null," - field devices"]
[null,null,null,null,null,null,null,null,null," - local network wiring assets"]
[null,null,null,null,null,null,null,null,null," - master station assets"]
[null,null,null,null,null,null,null,null,null," - neutral earthing resistor"]
[null,null,null,null,null,null,null,null,null," - oil-filled circuit recloser (OCR)"]
[null,null,null,null,null,null,null,null,null," - rapid earth fault current limiter (REFCL)"]
[null,null,null,null,null,null,null,null,null," - surge diverter"]
[null,null,null,null,null,null,null,null,null," - voltage regulator"]
[null,null,null,null,null,null,null,null,null,"Public lighting"]
[null,null,null,null,null,null,null,null,null," - brackets (major road)"]
[null,null,null,null,null,null,null,null,null," - brackets (minor road)"]
[null,null,null,null,null,null,null,null,null," - lamps (major road)"]
[null,null,null,null,null,null,null,null,null," - lamps (minor road)"]
[null,null,null,null,null,null,null,null,null," - luminaries (major road)"]
[null,null,null,null,null,null,null,null,null," - luminaries (minor road)"]
[null,null,null,null,null,null,null,null,null," - poles / columns (major road)"]
[null,null,null,null,null,null,null,null,null," - poles / columns (minor road)"]
[null,null,null,null,null,null,null,null,null,"Other "]
[null,null,null,null,null,null,null,null,null," - connection box"]
[null,null,null,null,null,null,null,null,null," - earth / earthing"]
[]
[]
[null,null,null,null,null,null,null,null,null,"Extra low voltage AC (<50V)"]
[null,null,null,null,null,null,null,null,null,"Low voltage AC (<1kV)"]
[null,null,null,null,null,null,null,null,null,"2.2kV AC"]
[null,null,null,null,null,null,null,null,null,"6.6kV AC"]
[null,null,null,null,null,null,null,null,null,"11kV AC"]
[null,null,null,null,null,null,null,null,null,"12.7kV AC (SWER)"]
[null,null,null,null,null,null,null,null,null,"22kV AC"]
[null,null,null,null,null,null,null,null,null,"33kV AC"]
[null,null,null,null,null,null,null,null,null,"66kV AC"]
[null,null,null,null,null,null,null,null,null,"132kV AC"]
[null,null,null,null,null,null,null,null,null,"220kV AC"]
[null,null,null,null,null,null,null,null,null,"330kV AC"]
[null,null,null,null,null,null,null,null,null,"500kV AC"]
[null,null,null,null,null,null,null,null,null,"Extra low voltage DC (<120V ripple free)"]
[null,null,null,null,null,null,null,null,null,"Low voltage DC (<1.5kV)"]
[null,null,null,null,null,null,null,null,null,"600V DC"]
[null,null,null,null,null,null,null,null,null,"1500V DC"]
[null,null,null,null,null,null,null,null,null,"Earthing cable"]
[]
[]
[null,null,null,null,null,null,null,null,null,"single wire earth return (SWER)"]
[null,null,null,null,null,null,null,null,null,"single phase"]
[null,null,null,null,null,null,null,null,null,"two phase"]
[null,null,null,null,null,null,null,null,null,"three phase"]
[]
[]
[null,null,null,null,null,null,null,null,null,"Negligible: no ground fire"]
[null,null,null,null,null,null,null,null,null,"Localised: less than 10 sq.m"]
[null,null,null,null,null,null,null,null,null,"Small: 10 - 1000 aq.m"]
[null,null,null,null,null,null,null,null,null,"Medium: 1000 sq.m - 10 ha"]
[null,null,null,null,null,null,null,null,null,"Large: more than 10 ha"]

{"sheet":"2. Individual fire start info","index":3,"n_rows":124,"n_cols":24,"rows_kept":124,"cut":false,"hidden":false,"merged":[[3,24,3,26],[4,24,4,26],[5,24,5,26],[7,1,7,23],[27,1,27,20],[11,1,11,2],[13,1,13,11],[22,1,22,23],[24,1,24,23],[14,1,14,22],[15,1,15,20],[16,1,16,20],[17,1,17,20],[20,1,20,20],[9,1,9,23],[18,1,18,20],[37,10,37,13],[25,1,25,20],[37,21,37,23],[35,1,35,4],[37,14,37,19],[37,2,37,9],[30,1,30,20],[28,1,28,23],[31,1,31,20],[23,1,23,20],[19,1,19,20],[26,1,26,20],[21,1,21,23],[29,1,29,22]]}
[null,{"$f":"IF(Cover!C25=\"\",\"[DNSP Name]\", Cover!C25)","v":"CitiPower"}]
[null,"F-factor data reporting"]
[null,{"$f":"IF(Cover!C31=\"\",\"[Year]\",Cover!C31)","v":"2016/17"}]
[]
[]
[null,"Instructions:"]
[]
[null,{"$f":"\"Enter into this worksheet fire start data, from any IT system, which have been recorded by \"&IF(Cover!C25=\"\",\"[DNSP Name]\", Cover!C25)&\". Note that fire starts must be in accordance with the definition of a fire start in the Order In Council.\"","v":"Enter into this worksheet fire start data, from any IT system, which have been recorded by CitiPower. Note that fire starts must be in accordance with the definition of a fire start in the Order In Council."}]
[]
[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,{"$f":"IF(Cover!C25=\"\",\"[DNSP Name] must provide:\", CONCATENATE(Cover!C25,\" must provide:\"))","v":"CitiPower must provide:"}]
[]
[null,"Table 3 - Individual Fire Starts"]
[null,"   (1) Date - dd/mm/yyyy"]
[null,"   (2) Time - if known, the 24-hour time of the fire start hh:mm"]
[null,"   (3) Latitude and longitude of the fire start as decimal coordinates"]
[null,"   (4) Asset number for the asset nearest the fire start"]
[null,{"$f":"\"   (5) Feeder ID for the polyphase overhead line or underground cable nearest the fire start in the \"&B1&\" network\"","v":"   (5) Feeder ID for the polyphase overhead line or underground cable nearest the fire start in the CitiPower network"}]
[null,"   (6) Voltage on the line in which the fire start occurred (note: this may not be the nearest polyphase overhead line)"]
[null,"   (7) Network categorisation - CBD, Urban, Rural Long or Rural Short"]
[null,"   (8) Fire start by category in accordance with ESV quarterly reporting categories"]
[null,"   (9) Asset type of primary asset causing fire in accordance with OSIRIS asset categories"]
[null,"   (10) Where the asset involved in the fire is a transformer or an overhead or underground line, provide the phase of the line or transformer"]
[null,"   (11) Kind of fire start in accordance with categories specified in Clause 5 of the F-factor Order-In-Council"]
[null,"   (12) Rating of High Bushfire Risk Area (HBRA) or Low Bushfire Risk Are (LBRA) as assigned by CFA & MFB under s.80 of the Electricity Safety Act"]
[null,"   (13) Identify the location of the fire start in accordance with the categories specified in Clause 11(b) of the F-factor Order-In-Council"]
[null,"   (14) Has the CFA declared a fire danger period under the Country Fire Authority Act 1958 - Y/N?"]
[null,"   (15) Where a fire danger period has been declared, provide the daily CFA fire danger rating (or leave blank if the area has not yet been declared)"]
[null,{"$f":"\"   (16) \"&IF(Cover!C25=\"\",\"[DNSP Name]\", Cover!C25)&\"'s record number for the incident\"","v":"   (16) CitiPower's record number for the incident"}]
[null,"   (17) ESV's OSIRIS reference number for the incident"]
[null,"   (18) Free text description of the fault containing relevant comments from field reports "]
[]
[]
[]
[null,"Table 3: Individual Fire Starts"]
[]
[null,"Number","Fire starts",null,null,null,null,null,null,null,"Fire Type",null,null,null,"Risk Factors",null,null,null,null,null,"IRU \namount"]
[null,null,"Date 1","Time 2","Latitude 3","Longitude 3","ID of \nnearest \nasset 4","ID of nearest \npolyphase \nline 5","Voltage of line in which \nfire start \noccurred 6","Network categorisation 7","Fire start by \nESV category 8","Fire start by\nasset type 9","Phase of \nline or \ntransformer 10","Kind of fire start as per Clause 5\nof F-factor Order-In-Council 11","HBRA or \nLBRA 12","Location \narea 13","Location\nmultiplier","Fire danger period declared? 14","Fire \ndanger \nrating 15","Danger multiplier","Product of multipliers","DNSP record number 16","OSIRIS \n(ESV) reference \nnumber 17","Fault \ndescription 18"]
[null,1,"2016-08-18","13:54:00",-37.838704999999997,144.99312,30302043,"TK024","Low voltage AC (<1kV)","Urban","Asset failures resulting in asset fire (no grass/vegetation fire) : Other Assets"," - fuse (any other type)","single phase","Started in or originated from a distribution system","LBRA","LBRA only",{"$f":"IF(P40=\"\",\"\",IF(P40=\"LBRA only\",0.2,IF(P40=\"HBRA only\",1,IF(P40=\"within electric line construction area\",19.8,IF(P40=\"within area delineated on plan LEGL./16-354\",4.6,\"\")))))","v":0.2},"N","No forecast",{"$f":"IF(S40=\"\",\"\",IF(S40=\"No forecast\",0.1,IF(R40=\"N\",0.1,IF(S40=\"Low-moderate\",0.2,IF(S40=\"High\",0.5,IF(S40=\"Very high\",1,IF(S40=\"Severe\",2,IF(S40=\"Extreme\",3.5,5))))))))","v":0.1},{"$f":"IF(OR(Q40=\"\",T40=\"\"),\"\",IF(AND(P40=\"within electric line construction area\",S40=\"No forecast\"),1,Q40*T40))","v":2.0000000000000004E-2},12356,"20160826PWA_03","A customer requested urgent attendance to isolate supply due to fire in MSB room at the incident location. Upon arrival, crew found that an overheated LV fuse board caught fire. MFB attended. Protection operated. The supply isolated\rand the place made safe. There were no injuries or ground fire."]
[null,2,"2016-08-20","18:06:00",-37.862769999999998,145.01956000000001,30198370,"AR007","Low voltage AC (<1kV)","Urban","Asset failures resulting in asset fire (no grass/vegetation fire) : Other Assets"," - luminaries (major road)","single phase","Started in or originated from a distribution system","LBRA","LBRA only",0.2,"N","No forecast",0.1,2.0000000000000004E-2,12360,"20160830PWA_01","Trams control room reported a light fitting on Tramway Pole was on fire at the above incident location. On arrival, the crew found that a light fitting cap on a PTC Tramway Pole (located on the Tramway medium strip) had caught on fire, which melted the cap and burnt the light electrical components. There was no ground fire nor third party damaged. There were no reported injuries."]
[null,3,"2016-10-19","11:47:00",-37.832901999999997,144.95615000000001,30170659,"AP011","Low voltage AC (<1kV)","Urban","Asset failures resulting in asset fire (no grass/vegetation fire) : Other Assets"," - connection box","three phase","Started in or originated from a distribution system","LBRA","LBRA only",0.2,"N","No forecast",0.1,2.0000000000000004E-2,12501,"20161019PWA_02","CitiPower  report room received advise from the MFB about a fire at the incident location. \rOn arrival the fault crew found that a krone box had overheated and caught fire, resulting in molten plastic falling onto a car below it, causing damage to the cars paint.\rThe MFB extinguished the fire.\rCitiPower fault crew replaced the krone box and re-terminated connections to it. Supply was restored.\rThere was no injury or ground fire as a result of this incident"]
[null,4,"2016-10-28","18:15:00",-37.802757,144.94565,30198811,"VM014","Low voltage AC (<1kV)","CBD","Asset failures resulting in asset fire (no grass/vegetation fire) : Other Assets"," - luminaries (major road)","single phase","Started in or originated from a distribution system","LBRA","LBRA only",0.2,"N","No forecast",0.1,2.0000000000000004E-2,12541,"20161108PWA_05","MSY Technology Pty Ltd staff reported a light fitting on Public Lighting Pole was on fire at the above incident location. On arrival, the crew found that a light fitting cap on a Public Lighting Pole had caught on fire, which melted the cap and burnt the light electrical components. There was no ground fire nor third party damaged. There were no reported injuries."]
[null,5,"2016-11-15","10:00:00",-37.760702999999999,144.99776,30186544,"NC014","11kV AC","Urban","Asset failures resulting in asset fire (no grass/vegetation fire) : Other Assets"," - switch (disconnector/isolator)","three phase","Started in or originated from a distribution system","LBRA","LBRA only",0.2,"Y","Low-moderate",0.2,4.0000000000000008E-2,12577,"20161125PWA_02","A passer-by called to advise pole on the corner of Stott & Woolton Avenue is sparking and making an arcing noise the MFB are in attendance at the incident location.\rOn arrival the fault crew found that the a GFB switch was candling of the arc chute on roadside phase (HVSW #1008) was on fire at the incident location.\r\nThe GFB was opened and the fire then extinguished.\r There was no ground fire and no injury as a result of this incident."]
[null,6,"2016-12-24","16:30:00",-37.808593000000002,145.07619199999999,30175325,"L004","Low voltage AC (<1kV)","Urban","Asset failures resulting in grass/vegetation fire : Other Assets"," - overhead conductor (bare; copper)","three phase","Started in or originated from a distribution system","LBRA","LBRA only",0.2,"Y","High",0.5,0.1,12667,"20161229PWA_10","A customer reported that an insulator exploded and a fire occurred outside 125 Gordon St Balwyn at 16:30 24/12/16. \rCitiPower fault was dispatched at 16:37 to investigate. On arrival the crew found the bimetal crimp on the blue phase of the LV conductor, overheated and as a result melted the aluminium connecting cable. This caused melted aluminium to drop down to the below grass creating a ground fire on the road reserve. The dimension of the ground fire was 250mmx250mm. Crew reported that the fire was located on the road reserve next to pole LIS 18339 outside 127 Gordon St Balwyn. Crew made the site safe, installed parallels to put the customers back on supply and organised another crew to replace damaged assets. \rThere were no reported injuries or 3rd party damage."]
[null,7,"2016-12-29","19:05:00",-37.759822,144.99338,30197792,"NC013","Low voltage AC (<1kV)","Urban","Asset failures resulting in asset fire (no grass/vegetation fire) : Other Assets"," - connection box","three phase","Started in or originated from a distribution system","LBRA","LBRA only",0.2,"Y","Low-moderate",0.2,4.0000000000000008E-2,12724,"20170117PWA_04","MFB reported a fire at the pole outside 316 St Georges Rd. On arrival the crew found that a krone box had burnt and required replacement. The krone box was open at the time of the fault & the cause of the fire was attributed to a loose connection. There were no reported injuries, ground fire or property damage."]
[null,8,"2017-01-18","07:47:00",-37.798416000000003,144.99530999999999,30170685,"CW009","11kV AC","Urban","Asset failures resulting in asset fire (no grass/vegetation fire) : Pole and cross arm fire (including ‘smouldering’ or ‘smoke’)"," - crossarm (wood)","three phase","Started in or originated from a distribution system","LBRA","LBRA only",0.2,"Y","High",0.5,0.1,12753,"20170125PWA_01","Vic Fire informed that a pole on fire at the incident location and also a customer reported a transformer on fire. On arrival the crew found that an 11kV top cross arm had burnt through but the insulator and conductor intact  on LULIE ABBOTT P07S (LIS 20676). The crew made the place safe and repairs have been arranged. \rThere was no ground fire, third party damage or injury. MFB attended the scene."]
[null,9,"2017-03-19","14:01:00",-37.868192999999998,145.01453000000001,30219414,"EL011","Low voltage AC (<1kV)","Urban","Asset failures resulting in asset fire (no grass/vegetation fire) : Other Assets"," - connection box","three phase","Started in or originated from a distribution system","LBRA","LBRA only",0.2,"Y","High",0.5,0.1,12964,"20170331PWA_04","Customer phoned in to advise that the a pole mounted box has caught fire and dropped to the ground, still smoking, and a possible wire down. Upon arrival the CitiPower faults crew found that the LV FOLCB supplying 590 & 590A Inkerman Rd, Caulfield North had caught fire and melted to the ground. The FOLCB also came into contact with the CATV on the pole which was found hanging from Pole LIS-30749. The crew made temporary repairs to the CATV to make it safe and made repairs to the LV underground service. There was no ground fire, injuries or third party damage."]
[null,11,"2017-05-19","17:09:00",-37.840180140000001,145.07241905000001,30177504,"RD009","Low voltage AC (<1kV)","Urban","Asset failures resulting in asset fire (no grass/vegetation fire) : Other Assets"," - connection box","three phase","Started in or originated from a distribution system","LBRA","LBRA only",0.2,"N","No forecast",0.1,2.0000000000000004E-2,13133,"20170601PWA_03","MFB reported a pole fire opposite Wilson Park at 8 Culliton Rd Camberwell at approximate 17:09 19/05/2017.  \nCitiPower linesmen were dispatched to investigate. On arrival the Linesmen determined that an FOLCB on Pole LIS 10497 overheated causing it to be damaged. The Linesmen on further investigation found burn marks on the pole and concluded that there was a small fire on the pole.  "]
[null,10,"2017-05-28","22:46:00",-37.824959,144.99797000000001,30221370,"NR006","Low voltage AC (<1kV)","Urban","Asset failures resulting in asset fire (no grass/vegetation fire) : Other Assets"," - luminaries (major road)","single phase","Started in or originated from a distribution system","LBRA","LBRA only",0.2,"N","No forecast",0.1,2.0000000000000004E-2,13132,"20170601PWA_02","MFB reported a pole fire at the above incident location. On arrival, the crew found that a Public Lighting Photo Electric Cell had faulted and caught on fire. There was no ground fire nor third party damaged. There were no reported injuries."]
[null,12,"2017-06-30","12:42:00",-37.830592629999998,145.05289325999999,30202208,"CL023","Low voltage AC (<1kV)","Urban","Asset failures resulting in asset fire (no grass/vegetation fire) : Other Assets"," - connection box","three phase","Started in or originated from a distribution system","LBRA","LBRA only",0.2,"N","No forecast",0.1,2.0000000000000004E-2,13222,"20170713PWA_07 ","MFB reported a pole fire at the incident location. Upon arrival, the Powercor crew found that an overheated termination ignited the junction box on the pole. There were no injuries, third party damages or ground fire."]
[null,13,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,14,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,15,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,16,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,17,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,18,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,19,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,20,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,21,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,22,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,23,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,24,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,26,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,27,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,28,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,29,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,30,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,31,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,32,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,33,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(S72=\"\",\"\",IF(S72=\"No forecast\",0.1,IF(R72=\"N\",0.1,IF(S72=\"Low-moderate\",0.2,IF(S72=\"High\",0.5,IF(S72=\"Very high\",1,IF(S72=\"Severe\",2,IF(S72=\"Extreme\",3.5,5))))))))","v":""},{"$f":"IF(OR(Q72=\"\",T72=\"\"),\"\",IF(AND(P72=\"within electric line construction area\",S72=\"No forecast\"),1,Q72*T72))","v":""}]
[null,34,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,35,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,36,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,37,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,38,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,39,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,40,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,41,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,42,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,43,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,44,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,45,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,46,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,47,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,48,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,49,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,50,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,51,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,52,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,53,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,54,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,55,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,56,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,57,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,58,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,59,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,60,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,61,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,62,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,63,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,64,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,65,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(S104=\"\",\"\",IF(S104=\"No forecast\",0.1,IF(R104=\"N\",0.1,IF(S104=\"Low-moderate\",0.2,IF(S104=\"High\",0.5,IF(S104=\"Very high\",1,IF(S104=\"Severe\",2,IF(S104=\"Extreme\",3.5,5))))))))","v":""},{"$f":"IF(OR(Q104=\"\",T104=\"\"),\"\",IF(AND(P104=\"within electric line construction area\",S104=\"No forecast\"),1,Q104*T104))","v":""}]
[null,66,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,67,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,68,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,69,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,70,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,71,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,72,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,73,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,74,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,75,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,76,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,77,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,78,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,79,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,80,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,81,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,82,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,83,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,84,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,85,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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!C25=\"\",\"[DNSP Name]\", Cover!C25)","v":"CitiPower"}]
[null,"F-factor data reporting"]
[null,{"$f":"IF(Cover!C31=\"\",\"[Year]\",Cover!C31)","v":"2016/17"}]
[]
[]
[null,"Instructions:"]
[]
[null,{"$f":"IF(Cover!C25=\"\",\"[DNSP Name] must provide:\", CONCATENATE(Cover!C25,\" must provide:\"))","v":"CitiPower 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","Yes","None"]
[null,"System 2","Outage Management System (OMS)","Yes","None"]
[null,"System 3 ","SCADA","Yes","None"]
[null,"System 4","etc"]
[null,"System 5","etc"]
[]
[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."]