{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Contents","Cover","1. F-Factor summary","2. Individual fire start info","3. Systems and Audit"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":7,"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":"Contents","index":0,"n_rows":22,"n_cols":15,"rows_kept":22,"cut":false,"hidden":false,"merged":[[8,2,9,3],[2,1,2,10],[4,1,4,10]]}
[" "]
[]
[null,"Electricity Distribution Network Service Provider\nF-factor Reporting Template"]
[]
[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"]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"\"NOTE: This spreadsheet includes IRU targets up to and including FY\"&yearMax","v":"NOTE: This spreadsheet includes IRU targets up to and including FY2024/25"}]
[]
[null,null,{"$f":"\"NOTE: This spreadsheet was last updated on \"&TEXT(revisionDate,\"DD MMMM YYY\")","v":"NOTE: This spreadsheet was last updated on 23 July 2024"},null,null,null,null,null,null,null,null,null,null,null,"2024-07-23"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,true]

{"sheet":"Cover","index":1,"n_rows":49,"n_cols":6,"rows_kept":49,"cut":false,"hidden":false,"merged":[[10,1,11,8],[13,1,13,8],[48,2,48,6],[42,2,42,3],[42,4,42,7],[46,2,46,6],[47,2,47,6],[38,2,38,3],[38,4,38,7],[41,2,41,3],[41,4,41,7],[37,2,37,3],[37,4,37,7],[32,3,32,8],[30,3,30,8],[15,1,15,8],[26,3,26,8],[28,3,28,8],[26,1,26,2],[31,3,31,5],[14,1,14,8],[16,1,16,8],[17,1,17,8],[21,1,21,8],[19,1,19,8]]}
[]
[]
[]
[]
[]
[]
[]
[null,"Distribution Network Service Provider"]
[null,"Fire start report"]
[]
[null,"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.  "]
[]
[]
[null,"Colour coding of input sheets:"]
[null,"Dark blue = AER headings"]
[null,"Grey = AER instructions"]
[null,"Yellow = Input cells"]
[null,"Light orange = Automatically-generated cells"]
[]
[null,"Leave coloured cells blank if no information exists - PLEASE DO NOT ENTER TEXT unless specifically requested to do so."]
[null,"The cells and structure of the spreadsheet is locked to prevent inadvertent interference with the automated settings."]
[null,"All dollar amounts are to be unrounded, and in nominal terms."]
[]
[]
[]
[]
[null,"DNSP:",null,"CitiPower"]
[]
[null,"DNSP - trading name:",null,"CitiPower Pty Ltd"]
[]
[null,"DNSP - Australian business number: ",null,"ACN 064 651 056"]
[]
[null,"Reporting year:",null,"2023/24"]
[]
[]
[]
[]
[null,"Business address","Address",null,"40 Market Street"]
[null,null,"Suburb",null,"Melbourne"]
[null,null,null,"State","Victoria","Postcode"]
[]
[null,"Postal address","Address",null,"Locked Bag 14090"]
[null,null,"Suburb",null,"Melbourne"]
[null,null,null,"State","Victoria","Postcode"]
[]
[]
[null,"Contact name/s"]
[null,"Contact phone/s"]
[null,"Contact email address/s"]

{"sheet":"1. F-Factor summary","index":2,"n_rows":21,"n_cols":15,"rows_kept":21,"cut":false,"hidden":false,"merged":[[5,1,5,2],[3,6,3,8],[4,6,4,8],[5,6,5,8],[11,2,11,3],[12,2,12,3],[13,2,13,3],[6,2,6,3],[7,2,7,3],[8,2,8,3],[9,2,9,3],[10,2,10,3]]}
[null,{"$f":"IF(Cover!D27=\"\",\"[DNSP Name]\", Cover!D27)","v":"CitiPower"},"IRU target:",{"$f":"IF(SUM(K2:O2)=0,\"\",SUM(K2:O2))","v":1.7},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'!S38:S1915)=0,\"\",SUM('2. Individual fire start info'!S38:S1915))","v":1.6779999999999999},null,null,null,null,null,"current",{"$f":"IF(OR($B3=\"[Year]\",$B1=\"[DNSP Name]\",$B1<>K1),\"\",LOOKUP($B3,$J3:$J101,K3:K101))","v":""},{"$f":"IF(OR($B3=\"[Year]\",$B1=\"[DNSP Name]\",$B1<>L1),\"\",LOOKUP($B3,$J3:$J101,L3:L101))","v":1.7},{"$f":"IF(OR($B3=\"[Year]\",$B1=\"[DNSP Name]\",$B1<>M1),\"\",LOOKUP($B3,$J3:$J101,M3:M101))","v":""},{"$f":"IF(OR($B3=\"[Year]\",$B1=\"[DNSP Name]\",$B1<>N1),\"\",LOOKUP($B3,$J3:$J101,N3:N101))","v":""},{"$f":"IF(OR($B3=\"[Year]\",$B1=\"[DNSP Name]\",$B1<>O1),\"\",LOOKUP($B3,$J3:$J101,O3:O101))","v":""}]
[null,{"$f":"IF(Cover!D33=\"\",\"[Year]\",Cover!D33)","v":"2023/24"},"Revenue adjustment:",{"$f":"IF(OR(D1=\"\",D2=\"\"),\"\",15000*(D1-D2))","v":330.00000000000028},null,null,null,null,null,"2016/17",247.7,3.4,9.6999999999999993,468,22.3]
[null,null,null,null,null,null,null,null,null,"2017/18",247.7,3.4,9.6999999999999993,468,22.3]
[null,"Table 2: Summary of total fire starts by F factor Order definition",null,null,null,null,null,null,null,"2018/19",247.7,3.4,9.6999999999999993,468,22.3]
[null,"This is a summary of data in worksheet \"2. Fire Start Report\"",null,null,null,null,null,null,null,"2019/20",221.1,3.4,9.6999999999999993,412.8,22.3]
[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,"2020/21",177.5,1.3,4.2,277.60000000000002,18.7]
[null,"Started in or originated from a distribution system",{"$f":"COUNTIF('2. Individual fire start info'!$N$38:$N$1915,'1. F-Factor summary'!$B8)","v":15},null,null,null,null,null,null,"2021/22",164.3,1.9,3.7,235.2,19]
[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$38:$N$1915,'1. F-Factor summary'!$B9)","v":5},null,null,null,null,null,null,"2022/23",149.69999999999999,1.5,2.7,188,13.9]
[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$38:$N$1915,'1. F-Factor summary'!$B10)","v":0},null,null,null,null,null,null,"2023/24",131.69999999999999,1.7,2.7,185.5,14.2]
[null,"Started by lightning striking a distribution system or a part of a distribution system ",{"$f":"COUNTIF('2. Individual fire start info'!$N$38:$N$1915,'1. F-Factor summary'!$B11)","v":0},null,null,null,null,null,null,"2024/25",127,1.7,2.2999999999999998,147.9,11.7]
[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$38:$N$1915,'1. F-Factor summary'!$B12)","v":2}]
[null,"Otherwise started by a distribution system",{"$f":"COUNTIF('2. Individual fire start info'!$N$38:$N$1915,'1. F-Factor summary'!$B13)","v":0}]
[null,"Total",{"$f":"SUM(C8:C13)","v":22}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,45496]

{"sheet":"2. Individual fire start info","index":3,"n_rows":237,"n_cols":25,"rows_kept":237,"cut":false,"hidden":false,"merged":[[25,1,25,18],[27,1,27,20],[26,1,26,21],[35,19,35,21],[33,1,33,4],[35,2,35,10],[28,1,28,18],[29,1,29,18],[35,11,35,13],[35,14,35,17],[13,1,13,11],[22,1,22,21],[24,1,24,21],[14,1,14,20],[15,1,15,18],[16,1,16,18],[18,1,18,18],[21,1,21,18],[19,1,19,18],[23,1,23,18],[20,1,20,18],[17,1,17,18],[3,22,3,24],[4,22,4,24],[5,22,5,24],[7,1,7,21],[11,1,11,2],[9,1,9,21]]}
[null,{"$f":"IF(Cover!D27=\"\",\"[DNSP Name]\", Cover!D27)","v":"CitiPower"}]
[null,"F-factor data reporting"]
[null,{"$f":"IF(Cover!D33=\"\",\"[Year]\",Cover!D33)","v":"2023/24"}]
[]
[]
[null,"Instructions:"]
[]
[null,{"$f":"\"Enter into this worksheet fire start data, from any IT system, which have been recorded by \"&IF(Cover!D27=\"\",\"[DNSP Name]\", Cover!D27)&\". 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!D27=\"\",\"[DNSP Name] must provide:\", CONCATENATE(Cover!D27,\" 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) Address of the property on which the incident occurred or closest to the incident"]
[null,"   (5) Asset number for the asset nearest the fire start"]
[null,{"$f":"\"   (6) Feeder ID for the polyphase overhead line or underground cable nearest the fire start in the \"&B1&\" network\"","v":"   (6) Feeder ID for the polyphase overhead line or underground cable nearest the fire start in the CitiPower network"}]
[null,"   (7) Voltage on the line in which the fire start occurred (note: this may not be the nearest polyphase overhead line)"]
[null,"   (8) Network categorisation - CBD, Urban, Rural Long or Rural Short"]
[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, or phases, 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 [Note: This is interpreted as the initiating event rather than the cause. For instance, a fuse failure resulting from a lightning strike would be attributed to \"lightning\" even if the fuse should have protected against such strikes.]"]
[null,"   (12) 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,"   (13) Provide the BOM fire danger rating applicable at the time of the fire start (data is available on the EM-COP website) [Note: The fire danger rating applies from the time it was issued; ratings do no apply retrospectively. The rating from the previous day carries into the current day until the rating is changed. If no fire danger rating is issued for the day, a rating of \"No forecast\" applies for the whole day.]"]
[null,{"$f":"\"   (14) \"&IF(Cover!D27=\"\",\"[DNSP Name]\", Cover!D27)&\"'s record number for the incident\"","v":"   (14) CitiPower's record number for the incident"}]
[null,"   (15) ESV's OSIRIS reference number for the incident"]
[null,"   (16) Free text description of the fault containing relevant comments from field reports "]
[]
[]
[]
[null,"Table 2: Individual Fire Starts"]
[]
[null,"Number","Fire starts",null,null,null,null,null,null,null,null,"Fire Type",null,null,"Risk Factors",null,null,null,"IRU \namount","Additional information"]
[null,null,"Date 1","Time 2","Latitude 3","Longitude 3","Address of incident 4","ID of \nnearest \nasset 5","ID of nearest \npolyphase \nline 6","Voltage of line in which \nfire start \noccurred 7","Network categorisation 8","Type of primary asset \ninvolved in fire start 9","Phase(s) of \nline or \ntransformer 10","Kind of fire start as per Clause 5\nof F-factor Order-In-Council 11","Location \narea 12","Location\nmultiplier","Fire \ndanger \nrating 13","Danger multiplier","Product of multipliers","DNSP record number 14","OSIRIS \n(ESV) reference \nnumber 15","Fault \ndescription 16"]
[{"$f":"COUNTA(C38:O38,Q38,T38:V38)","v":17},1,"2023-08-29","18:36",-37.838175999999997,144.94268700000001,"242 State Route 30, Port Melbourne VIC 3207, Australia",30202105,"MG001","Low voltage AC (<1kV)","Urban"," - luminaires (major road)","single phase","Started in or originated from a distribution system","LBRA only",{"$f":"IF(O38=\"\",\"\",IF(O38=\"LBRA only\",0.2,IF(O38=\"HBRA only\",1,IF(O38=\"within electric line construction area\",19.8,IF(O38=\"within area delineated on plan LEGL./16-354\",4.6,\"\")))))","v":0.2},"No rating",{"$f":"IF(Q38=\"\",\"\",IF(Q38=\"No rating\",0.05,IF(Q38=\"Moderate\",0.334,IF(Q38=\"High\",0.678,IF(Q38=\"Extreme\",2.272,4.754)))))","v":0.05},{"$f":"IF(OR(P38=\"\",R38=\"\"),\"\",IF(AND(O38=\"within electric line construction area\",Q38=\"No forecast\"),1,P38*R38))","v":1.0000000000000002E-2},"INC-0022627","20231020PWA_03","MFB reported street light pole fire.\nno ground fire\nFound during outage  data review",null,null,"Overhead conductors"]
[17,2,"2023-09-02","08:34",-37.854297000000003,144.99011999999999,"118 Union St, Windsor VIC 3181, Australia",30217045,"BC007","Low voltage AC (<1kV)","Urban"," - switch (disconnector/isolator)","three phase","Started in or originated from a distribution system","LBRA only",0.2,"No rating",{"$f":"IF(Q39=\"\",\"\",IF(Q39=\"No rating\",0.05,IF(Q39=\"Moderate\",0.334,IF(Q39=\"High\",0.678,IF(Q39=\"Extreme\",2.272,4.754)))))","v":0.05},1.0000000000000002E-2,"INC-0021937","20230904PWA_01","Report received of pole fire at incident location.\nCrew reported that the krone box on pole LIS 33744 had melted .\nNo ground fire evident",null,null," - overhead conductor (bare; aluminium core steel reinforced)"]
[17,3,"2023-11-24","19:10",-37.864716999999999,144.99841900000001,"10 Leslie St, St Kilda East VIC 3183, Australia",30210933,"BC022","Low voltage AC (<1kV)","Urban"," - overhead service conductor (residential)","single phase","Started by any tree, or part of a tree, falling upon or coming into contact with a distribution system","LBRA only",0.2,"Moderate",0.33400000000000002,6.6800000000000012E-2,"INC-0026336","20240703PWA_04","Cust reports all switches are on, meter is blank, ... service wire is in tree and has flames/sparks on the wire also\nCrew  found service damaged by vegetation",null,null," - overhead conductor (bare; all aluminium conductor)"]
[17,4,"2023-11-29","18:24",-37.794316999999999,144.983935,"200 Alexandra Parade, Fitzroy VIC 3065, Australia",30331911,"CW008","11kV AC","Urban"," - overhead conductor (bare; all aluminium conductor)","three phase","Started by any tree, or part of a tree, falling upon or coming into contact with a distribution system","LBRA only",0.2,"Moderate",0.33400000000000002,6.6800000000000012E-2,"INC-0023203","20231130PWA_04","VIC EMERGENCY advised Tree making contact with HV has started a fire - emergency services onsite.\n\nCrew advise strong wind causing tree branches to contact the high voltage conductors of the CW8 11kV feeder.  \nIn Gore Street south of Alexander Parade.\nSparks emitted and debris falling to the ground. \nArcing and sparking  evident, \n\n",null,null," - overhead conductor (bare; copper)"]
[17,5,"2024-01-08","06:30",-37.818949000000003,144.99570800000001,"2 Allowah Terrace, Richmond VIC 3121, Australia",30193035,"NR006","Low voltage AC (<1kV)","Urban"," - insulators","three phase","Started in or originated from a distribution system","LBRA only",0.2,"No rating",0.05,1.0000000000000002E-2,"INC-0023666","20240109PWA_01","Crew attended site after reports of a pole fire.\nCrew advise that the public light cable had caught fire and caused pole to also become alight. ",null,null," - overhead conductor (bare; steel)"]
[17,6,"2024-01-10","19:12",-37.815956999999997,144.960857,"123 Queen St, Melbourne VIC 3000, Australia",33112029,"JA005","Low voltage AC (<1kV)","CBD"," - switch (disconnector/isolator)","three phase","Started in or originated from a distribution system","LBRA only",0.2,"Moderate",0.33400000000000002,6.6800000000000012E-2,"INC-0023705","20240111PWA_01"," Vic Fire advised of a Fire at switchboard in basement.\n\nCrew advised that water ingress had resulted in a flashover on low voltage swotchgear gear in the substation.  \n412 Lt Collins Street, Melbourne, 3000.",null,null," - overhead conductor (ABC)"]
[17,7,"2024-01-14","15:00",-37.803178000000003,145.102743,"352 Belmore Rd, Balwyn VIC 3103, Australia",30220739,"WD032","Low voltage AC (<1kV)","Urban"," - overhead service conductor (residential)","single phase","Started in or originated from a distribution system","LBRA only",0.2,"Moderate",0.33400000000000002,6.6800000000000012E-2,"INC-0024207","20240214PWA_01","A 4 core grey twisted cable failed phase to phase. This caused a small grass fire at the base of the pole. The blue phase fuse operated at the substation",null,null," - overhead conductor (covered uninsulated)"]
[17,8,"2024-01-16","13:17",-37.813063,145.08260300000001,"272 State Route 34, Balwyn VIC 3103, Australia",30174057,"L001","Low voltage AC (<1kV)","Urban"," - connector / termination","three phase","Started in or originated from a distribution system","LBRA only",0.2,"Moderate",0.33400000000000002,6.6800000000000012E-2,"INC-0023798","20240117PWA_02","Firecomms reported fire on Cable.\nAttending crew found LV ABC tails into Krone Box from IPC had burnt and melted into each other.",null,null," - overhead conductor (insulated)"]
[17,9,"2024-02-04","18:29",-37.786569,145.07818,"3 Bernard St, Balwyn North VIC 3104, Australia",30183356,"WD011","11kV AC","Urban"," - overhead conductor (bare; all aluminium conductor)","three phase","Started by any tree, or part of a tree, falling upon or coming into contact with a distribution system","LBRA only",0.2,"High",0.67800000000000005,0.13560000000000003,"INC-0024030","20240205PWA_02","FRV reported a branch on conductors  on fire, extinguished by FRV. \nOn arrival, CitiPower Faults crew found a branch from a customer tree had landed on a bare HV conductor, resulting in a fire.",null,null,"Service lines"]
[17,10,"2024-02-12","15:13",-37.803091999999999,145.10257100000001,"Eastern Bell Chinese Restaurant, 399 Belmore Rd, Balwyn VIC 3103, Australia",30194452,"WD032","Low voltage AC (<1kV)","Urban"," - overhead service conductor (commercial / industrial)","three phase","Started in or originated from a distribution system","LBRA only",0.2,"High",0.67800000000000005,0.13560000000000003,"INC-0026658","20240718PWA_02","Blown up service line, grass fire underneath\nmultiple commercial customers off supply.\nno photos found\nsmall fire underneath service line\nFound during Outage data review.",null,null," - overhead service conductor (residential)"]
[17,11,"2024-02-23","04:57",-37.764749999999999,144.96776399999999,"17 Cooraminta St, Brunswick VIC 3056, Australia",30159197,"BK004","11kV AC","Urban"," - insulators","three phase","Started in or originated from a distribution system","LBRA only",0.2,"Extreme",2.2719999999999998,0.45439999999999997,"INC-0024357","20240223PWA_05","Fire agency reported pole fire\nCrew found HV arm had  burnt through at king bolt position  ",null,null," - overhead service conductor (commercial / industrial)"]
[17,12,"2024-03-08","14:10",-37.801546000000002,144.98148,"268 George St, Fitzroy VIC 3065, Australia",30586004,"B021","Low voltage AC (<1kV)","Urban"," - overhead service conductor (residential)","single phase","Started in or originated from a distribution system","LBRA only",0.2,"Moderate",0.33400000000000002,6.6800000000000012E-2,"INC-0024664","20240313PWA_05","VIC fire reported  J-box/Fuse box on fire \nNo Imagery , \ncrew found  burn damage to neutral screen service ",null,null," - overhead service conductor (subdivision / construction)"]
[17,13,"2024-03-17","16:00",-37.813957000000002,145.01672099999999,"2 Oak St, Hawthorn VIC 3122, Australia",30187515,"Q019","22kV AC","Urban"," - overhead conductor (bare; copper)","three phase","Started by any tree, or part of a tree, falling upon or coming into contact with a distribution system","LBRA only",0.2,"Moderate",0.33400000000000002,6.6800000000000012E-2,"INC-0024752","20240319PWA_01","Vic emergency reported tree branch has hit HV. Reports fire started in tree. \nAttending crew found branch had fallen from street tree and landed on High and Low voltage conductors. \nBranch shows signs of burning and probable extinguishment. ",null,null," - overhead service conductor (other)"]
[17,14,"2024-03-19","12:57",-37.787585999999997,144.99229,"392 Queens Parade, Fitzroy North VIC 3068, Australia",30220526,"F035","Low voltage AC (<1kV)","Urban"," - connector / termination","three phase","Started in or originated from a distribution system","LBRA only",0.2,"High",0.67800000000000005,0.13560000000000003,"INC-0024787","20240320PWA_06","Fire comms recd report of pole fire out front\nCrew found ABC cable connection has caught fire",null,null," - underground service cable (residential)"]
[17,15,"2024-03-20","02:30",-37.817979000000001,145.01018300000001,"63-69 Murphy St, Richmond VIC 3121, Australia",30182402,"RTS-CL","Low voltage AC (<1kV)","Urban"," - crossarm (wood)","three phase","Started in or originated from a distribution system","LBRA only",0.2,"High",0.67800000000000005,0.13560000000000003,"INC-0024800","20240321PWA_03","Crew arrived and found fire brigade onsite.\n Pole (arm) was smouldering at LV xarm level.",null,null," - underground service cable (commercial / industrial)"]
[17,16,"2024-03-21","16:38",-37.798253000000003,145.07991100000001,"12 Dight Ave, Balwyn North VIC 3104, Australia",30191613,"L001","Low voltage AC (<1kV)","Urban"," - overhead service conductor (residential)","single phase","Started in or originated from a distribution system","LBRA only",0.2,"Moderate",0.33400000000000002,6.6800000000000012E-2,"INC-0026789","20240725PWA_03","Report of service line fire and POA fire.\nNot a lot of information \nno photos\nFound during Outage data review",null,null," - underground service cable (subdivision / construction)"]
[17,17,"2024-04-13","20:43",-37.794317999999997,145.08569199999999,"207 Doncaster Rd, Balwyn North VIC 3104, Australia",30178308,"WD013","11kV AC","Urban"," - overhead conductor (bare; all aluminium conductor)","three phase","Started by any other thing forming part of or coming into contact with a distribution system","LBRA only",0.2,"Moderate",0.33400000000000002,{"$f":"IF(OR(P54=\"\",R54=\"\"),\"\",IF(AND(O54=\"within electric line construction area\",Q54=\"No forecast\"),1,P54*R54))","v":6.6800000000000012E-2},"INC-0026537","20240712PWA_03","Citi power was advised of Car into pole LIS10217 Doncaster rd HV conductor fell into tree and was burning",null,null," - underground service cable (other)"]
[17,18,"2024-05-26","18:28",-37.826427000000002,145.05706900000001,"29 Burwood Ave, Hawthorn East VIC 3123, Australia",30179652,"L014","Low voltage AC (<1kV)","Urban"," - switch (disconnector/isolator)","three phase","Started in or originated from a distribution system","LBRA only",0.2,"No rating",0.05,1.0000000000000002E-2,"INC-0025733","20240527PWA_04","FRV reported fire on transformer pole.\nOn arrival, CitiPower faults crew found burnt out cable from a Krone box.  \nThere was no ground fire but molten aluminium had dripped onto asphalt below.",null,null,"Underground cables"]
[17,19,"2024-06-21","09:24",-37.809587000000001,145.014296,"4A Hodgson St, Kew VIC 3101, Australia",30165420,"NR016","Low voltage AC (<1kV)","Urban"," - pole (wood)","three phase","Started by any other thing forming part of or coming into contact with a distribution system","LBRA only",0.2,"No rating",0.05,1.0000000000000002E-2,"INC-0026107","20240621PWA_05","Car v pole breaking pole and causing small grass fire.\nActual reported address is 54 Young St.",null,null," - underground cable"]
[17,20,"2024-06-27","17:00",-37.771664000000001,144.965992,"34 LYDIA STREET, BRUNSWICK VIC 3056",30157155,"C023","Low voltage AC (<1kV)","Urban"," - overhead service conductor (residential)","single phase","Started by any tree, or part of a tree, falling upon or coming into contact with a distribution system","LBRA only",0.2,"No rating",0.05,1.0000000000000002E-2,"INC-0026275","20240701PWA_03","Damaged/failed service wire running in laneway rear of 34 Lidia st Brunswick caused small fire in tree in rear yard.\n2 bays of damaged cable between Poles 49482 and 49490.\nThere was no ground fire or reported injuries",null,null," - underground communications cable"]
[17,21,"2024-06-30","12:38",-37.868944999999997,145.027569,"22 MALAKOFF STREET, CAULFIELD NORTH VIC 3161",30220104,"AR004","Low voltage AC (<1kV)","Urban"," - overhead service conductor (residential)","single phase","Started in or originated from a distribution system","LBRA only",0.2,"No rating",0.05,1.0000000000000002E-2,"INC-0026283","20240701PWA_06","Neighbour advises service wire to this address was sparking overnight and now wire has come down, still connected at pole and laying in trees \nSmall burnt patch on ground\nNo injuries",null,null,"Poles"]
[17,22,"2024-05-10","16:23:00",-37.813744999999997,145.02066600000001,"3 Pine St, Hawthorn VIC 3122, Australia",30183832,"Q019","Low voltage AC (<1kV)","Urban"," - overhead service conductor (residential)","single phase","Started in or originated from a distribution system","LBRA only",0.2,"No rating",0.05,1.0000000000000002E-2,"INC-0026639","20240717PWA_10","Service parted at roller clamp, customer reported flames",null,null," - pole (concrete)"]
[0,23,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - pole (steel)"]
[0,24,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - pole (wood)"]
[0,25,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,"Crossarms"]
[0,26,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - crossarm (wood)"]
[0,27,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - crossarm (steel)"]
[0,28,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - crossarm (other)"]
[0,29,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,"Overhead assets"]
[0,30,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - capacity balancing units"]
[0,31,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - connector / termination"]
[0,32,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - dropper / bridge"]
[0,33,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - guy wire"]
[0,34,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - insulator tie wires / connections"]
[0,35,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - insulators"]
[0,36,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - tower"]
[0,37,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - traction lines"]
[0,38,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",{"$f":"IF(OR(P75=\"\",R75=\"\"),\"\",IF(AND(O75=\"within electric line construction area\",Q75=\"No forecast\"),1,P75*R75))","v":""},null,null,null,null,null,"Underground assets"]
[{"$f":"COUNTA(C76:O76,Q76,T76:V76)","v":0},39,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(O76=\"\",\"\",IF(O76=\"LBRA only\",0.2,IF(O76=\"HBRA only\",1,IF(O76=\"within electric line construction area\",19.8,IF(O76=\"within area delineated on plan LEGL./16-354\",4.6,\"\")))))","v":""},null,"","",null,null,null,null,null," - LV pillar"]
[0,40,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - services pit"]
[0,41,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,"Transformers"]
[0,42,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - transformer (pole mounted)"]
[0,43,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - transformer (kiosk mounted)"]
[0,44,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - transformer (ground outdoor mounted)"]
[0,45,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - transformer (indoor chamber mounted)"]
[0,46,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - transformer (any other type)"]
[0,47,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - measurement transformer (current transformer)"]
[0,48,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - measurement transformer (voltage transformer)"]
[0,49,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - measurement transformer (capacitive voltage transformer)"]
[0,50,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,"Fuses and switchgear"]
[0,51,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - fuse (boric acid)"]
[0,52,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - fuse (EDO fuse)"]
[0,53,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - fuse (Fault Tamer)"]
[0,54,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - fuse (powder filled)"]
[0,55,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - fuse (any other type)"]
[0,56,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - circuit breaker"]
[0,57,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - switch (disconnector/isolator)"]
[0,58,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - switch (earth)"]
[0,59,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - switch (FuseSaver)"]
[0,60,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - switch (any other type)"]
[0,61,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,"SCADA, network control and protection systems"]
[0,62,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - audio frequency load controller (AFLC)"]
[0,63,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - arc suppresion coil"]
[0,64,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - automatic circuit recloser (ACR)"]
[0,65,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - communications linear assets"]
[0,66,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(Q103=\"\",\"\",IF(Q103=\"No rating\",0.05,IF(Q103=\"Moderate\",0.334,IF(Q103=\"High\",0.678,IF(Q103=\"Extreme\",2.272,4.754)))))","v":""},"",null,null,null,null,null," - communications network assets"]
[0,67,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - communications site infrastructure"]
[0,68,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - field devices"]
[0,69,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - local network wiring assets"]
[0,70,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",{"$f":"IF(OR(P107=\"\",R107=\"\"),\"\",IF(AND(O107=\"within electric line construction area\",Q107=\"No forecast\"),1,P107*R107))","v":""},null,null,null,null,null," - master station assets"]
[0,71,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - neutral earthing resistor"]
[0,72,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - oil-filled circuit recloser (OCR)"]
[0,73,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - rapid earth fault current limiter (REFCL)"]
[0,74,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - surge diverter"]
[0,75,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - voltage regulator"]
[0,76,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,"Public lighting"]
[0,77,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - brackets (major road)"]
[0,78,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - brackets (minor road)"]
[0,79,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - lamps (major road)"]
[0,80,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - lamps (minor road)"]
[0,81,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - luminaires (major road)"]
[0,82,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - luminaires (minor road)"]
[0,83,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - poles / columns (major road)"]
[0,84,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - poles / columns (minor road)"]
[0,85,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,"Other "]
[0,86,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - connection box"]
[0,87,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - earth / earthing"]
[0,88,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,89,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,90,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,"Extra low voltage AC (<50V)"]
[0,91,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,"Low voltage AC (<1kV)"]
[0,92,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,"2.2kV AC"]
[0,93,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,"6.6kV AC"]
[0,94,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,"11kV AC"]
[0,95,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,"12.7kV AC (SWER)"]
[0,96,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,"22kV AC"]
[0,97,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,"33kV AC"]
[0,98,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,"66kV AC"]
[0,99,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,"132kV AC"]
[0,100,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,"220kV AC"]
[0,101,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,"330kV AC"]
[0,102,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",{"$f":"IF(OR(P139=\"\",R139=\"\"),\"\",IF(AND(O139=\"within electric line construction area\",Q139=\"No forecast\"),1,P139*R139))","v":""},null,null,null,null,null,"500kV AC"]
[{"$f":"COUNTA(C140:O140,Q140,T140:V140)","v":0},103,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(O140=\"\",\"\",IF(O140=\"LBRA only\",0.2,IF(O140=\"HBRA only\",1,IF(O140=\"within electric line construction area\",19.8,IF(O140=\"within area delineated on plan LEGL./16-354\",4.6,\"\")))))","v":""},null,"","",null,null,null,null,null,"Extra low voltage DC (<120V ripple free)"]
[0,104,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,"Low voltage DC (<1.5kV)"]
[0,105,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,"600V DC"]
[0,106,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,"1500V DC"]
[0,107,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,"Earthing cable"]
[0,108,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,109,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,110,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,"single wire earth return (SWER)"]
[0,111,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,"single phase"]
[0,112,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,"two phase"]
[0,113,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,"three phase"]
[0,114,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,115,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,116,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,"Negligible: no ground fire"]
[0,117,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,"Localised: less than 10 sq.m"]
[0,118,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,"Small: 10 - 1000 aq.m"]
[0,119,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,"Medium: 1000 sq.m - 10 ha"]
[0,120,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,"Large: more than 10 ha"]
[0,121,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,122,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,123,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,"Started in or originated from a distribution system"]
[0,124,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,"Started by any tree, or part of a tree, falling upon or coming into contact with a distribution system"]
[0,125,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,"Started by any person, bird, reptile or other animal coming into contact with a distribution system"]
[0,126,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,"Started by lightning striking a distribution system or a part of a distribution system "]
[0,127,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,"Started by any other thing forming part of or coming into contact with a distribution system"]
[0,128,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,"Otherwise started by a distribution system"]
[0,129,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,130,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(Q167=\"\",\"\",IF(Q167=\"No rating\",0.05,IF(Q167=\"Moderate\",0.334,IF(Q167=\"High\",0.678,IF(Q167=\"Extreme\",2.272,4.754)))))","v":""},""]
[0,131,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,1]
[0,132,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,2]
[0,133,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,5]
[0,134,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",{"$f":"IF(OR(P171=\"\",R171=\"\"),\"\",IF(AND(O171=\"within electric line construction area\",Q171=\"No forecast\"),1,P171*R171))","v":""},null,null,null,null,null,10]
[0,135,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,15]
[0,136,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,20]
[0,137,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,25]
[0,138,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,30]
[0,139,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,50]
[0,140,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,100]
[0,141,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,142,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,143,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,144,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,145,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,146,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,147,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,148,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,149,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,150,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,151,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,152,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,153,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,154,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",{"$f":"IF(OR(P191=\"\",R191=\"\"),\"\",IF(AND(O191=\"within electric line construction area\",Q191=\"No forecast\"),1,P191*R191))","v":""}]
[0,155,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,156,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,157,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,158,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,159,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,160,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[{"$f":"COUNTA(C198:O198,Q198,T198:V198)","v":0},161,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[{"$f":"COUNTA(C199:O199,Q199,T199:V199)","v":0},162,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,163,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,164,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,165,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,166,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,167,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(O204=\"\",\"\",IF(O204=\"LBRA only\",0.2,IF(O204=\"HBRA only\",1,IF(O204=\"within electric line construction area\",19.8,IF(O204=\"within area delineated on plan LEGL./16-354\",4.6,\"\")))))","v":""},null,"",""]
[0,168,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,169,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,170,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[{"$f":"COUNTA(C208:O208,Q208,T208:V208)","v":0},171,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[{"$f":"COUNTA(C209:O209,Q209,T209:V209)","v":0},172,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,173,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,174,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,175,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,176,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,177,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,178,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,179,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,180,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,181,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,182,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,183,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[{"$f":"COUNTA(C221:O221,Q221,T221:V221)","v":0},184,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[{"$f":"COUNTA(C222:O222,Q222,T222:V222)","v":0},185,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,186,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,187,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,188,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,189,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,190,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,191,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,192,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,193,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,194,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(Q231=\"\",\"\",IF(Q231=\"No rating\",0.05,IF(Q231=\"Moderate\",0.334,IF(Q231=\"High\",0.678,IF(Q231=\"Extreme\",2.272,4.754)))))","v":""},""]
[0,195,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,196,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[{"$f":"COUNTA(C234:O234,Q234,T234:V234)","v":0},197,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(O234=\"\",\"\",IF(O234=\"LBRA only\",0.2,IF(O234=\"HBRA only\",1,IF(O234=\"within electric line construction area\",19.8,IF(O234=\"within area delineated on plan LEGL./16-354\",4.6,\"\")))))","v":""},null,"",{"$f":"IF(OR(P234=\"\",R234=\"\"),\"\",IF(AND(O234=\"within electric line construction area\",Q234=\"No forecast\"),1,P234*R234))","v":""}]
[{"$f":"COUNTA(C235:O235,Q235,T235:V235)","v":0},198,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(O235=\"\",\"\",IF(O235=\"LBRA only\",0.2,IF(O235=\"HBRA only\",1,IF(O235=\"within electric line construction area\",19.8,IF(O235=\"within area delineated on plan LEGL./16-354\",4.6,\"\")))))","v":""},null,"",{"$f":"IF(OR(P235=\"\",R235=\"\"),\"\",IF(AND(O235=\"within electric line construction area\",Q235=\"No forecast\"),1,P235*R235))","v":""}]
[0,199,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,200,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]

{"sheet":"3. Systems and Audit","index":4,"n_rows":29,"n_cols":5,"rows_kept":29,"cut":false,"hidden":false,"merged":[[28,1,29,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!D27=\"\",\"[DNSP Name]\", Cover!D27)","v":"CitiPower"}]
[null,"F-factor data reporting"]
[null,{"$f":"IF(Cover!D33=\"\",\"[Year]\",Cover!D33)","v":"2023/24"}]
[]
[]
[null,"Instructions:"]
[]
[null,{"$f":"IF(Cover!D27=\"\",\"[DNSP Name] must provide:\", CONCATENATE(Cover!D27,\" 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","Network Incidents Database","Yes","None applicable"]
[null,"System 2","Outage Management System (OMS)","Yes","None applicable"]
[null,"System 3 ","Smallworld GIS (Graphical Information System)","Yes","None applicable"]
[null,"System 4"]
[null,"System 5"]
[null,"System 6"]
[null,"System 7"]
[null,"System 8"]
[]
[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."]