{"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":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":"Contents","index":0,"n_rows":19,"n_cols":6,"rows_kept":19,"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\"&'1. F-Factor summary'!J10","v":"NOTE: This spreadsheet includes IRU targets up to and including FY2023/24"}]

{"sheet":"Cover","index":1,"n_rows":49,"n_cols":7,"rows_kept":49,"cut":false,"hidden":false,"merged":[[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],[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]]}
[]
[]
[]
[]
[]
[]
[]
[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,"Jemena"]
[]
[null,"DNSP - trading name:",null,"Jemena Electricity Networks (Vic) Ltd"]
[]
[null,"DNSP - Australian business number: ",null,"82 064 651 083"]
[]
[null,"Reporting year:",null,"2022/23"]
[]
[]
[]
[]
[null,"Business address","Address",null,"Level 16, 567 Collins Street"]
[null,null,"Suburb",null,"Melbourne"]
[null,null,null,"State","Victoria","Postcode",3000]
[]
[null,"Postal address","Address",null,"Level 16, 567 Collins Street"]
[null,null,"Suburb",null,"Melbourne"]
[null,null,null,"State","Victoria","Postcode",3000]
[]
[]
[null,"Contact name/s"]
[null,"Contact phone/s"]
[null,"Contact email address/s"]

{"sheet":"1. F-Factor summary","index":2,"n_rows":14,"n_cols":15,"rows_kept":14,"cut":false,"hidden":false,"merged":[[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],[5,1,5,2],[3,6,3,8],[4,6,4,8],[5,6,5,8],[11,2,11,3]]}
[null,{"$f":"IF(Cover!D27=\"\",\"[DNSP Name]\", Cover!D27)","v":"Jemena"},"IRU target:",{"$f":"IF(SUM(K2:O2)=0,\"\",SUM(K2:O2))","v":2.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:S1812)=0,\"\",SUM('2. Individual fire start info'!S38:S1812))","v":0.59840000000000004},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":""},{"$f":"IF(OR($B3=\"[Year]\",$B1=\"[DNSP Name]\",$B1<>M1),\"\",LOOKUP($B3,$J3:$J101,M3:M101))","v":2.7},{"$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":"2022/23"},"Revenue adjustment:",{"$f":"IF(OR(D1=\"\",D2=\"\"),\"\",15000*(D1-D2))","v":31524.000000000004},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$1812,'1. F-Factor summary'!$B8)","v":7},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$1812,'1. F-Factor summary'!$B9)","v":1},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$1812,'1. F-Factor summary'!$B10)","v":3},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$1812,'1. F-Factor summary'!$B11)","v":0}]
[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$1812,'1. F-Factor summary'!$B12)","v":1}]
[null,"Otherwise started by a distribution system",{"$f":"COUNTIF('2. Individual fire start info'!$N$38:$N$1812,'1. F-Factor summary'!$B13)","v":0}]
[null,"Total",{"$f":"SUM(C8:C13)","v":12}]

{"sheet":"2. Individual fire start info","index":3,"n_rows":187,"n_cols":25,"rows_kept":187,"cut":false,"hidden":false,"merged":[[3,22,3,24],[4,22,4,24],[5,22,5,24],[7,1,7,21],[11,1,11,2],[9,1,9,21],[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],[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]]}
[null,{"$f":"IF(Cover!D27=\"\",\"[DNSP Name]\", Cover!D27)","v":"Jemena"}]
[null,"F-factor data reporting"]
[null,{"$f":"IF(Cover!D33=\"\",\"[Year]\",Cover!D33)","v":"2022/23"}]
[]
[]
[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 Jemena. 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":"Jemena 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 Jemena 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: For the 2022-2023 period, the AER and ESV will accept either the initiating event or the cause.]"]
[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) Jemena'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,"2022-08-26","19:36:00",-37.733443999999999,145.01134999999999,"25A GOLDSMITH AVENUE, PRESTON VIC 3072","A063845","PTN11","Low voltage AC (<1kV)","Urban"," - switch (disconnector/isolator)","three 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(C38>=DATE(2022,9,1),IF(Q38=\"No rating\",0.05,IF(Q38=\"Moderate\",0.334,IF(Q38=\"High\",0.678,IF(Q38=\"Extreme\",2.272,4.754)))),0.05))","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},"J.22.0065928","20221201JEM_01","Minor grass fire. Failed LV switch (Krone box) burnt out leading to small charring of nature strip below (<0.2m)",null,null,"Overhead conductors"]
[17,2,"2022-09-25","08:37:00",-37.826371000000002,144.887902,"228 HALL STREET, SPOTSWOOD VIC 3015","A041386","YVE12","22kV AC","Rural Short"," - transformer (kiosk mounted)","three phase","Started by any person, bird, reptile or other animal coming into contact with a distribution system","LBRA only",0.2,"No rating",{"$f":"IF(Q39=\"\",\"\",IF(C39>=DATE(2022,9,1),IF(Q39=\"No rating\",0.05,IF(Q39=\"Moderate\",0.334,IF(Q39=\"High\",0.678,IF(Q39=\"Extreme\",2.272,4.754)))),0.05))","v":0.05},1.0000000000000002E-2,"J.22.0067275","20221201JEM_02","Kiosk Fire. During Copper Theft event, vandals have cut into live red phase 22kV cable which has caused leaking oil from drain valve resulting in subsequent fire within kiosk. Police & MFB on site. Substation was previously isolated with only incoming 22kV cable live.",null,null," - overhead conductor (bare; aluminium core steel reinforced)"]
[17,3,"2022-11-09","18:45:00",-37.733362999999997,145.01168000000001,"21 GOLDSMITH AVENUE, PRESTON VIC 3072","A063844","PTN11","Low voltage AC (<1kV)","Urban"," - overhead conductor (ABC)","three phase","Started in or originated from a distribution system","LBRA only",{"$f":"IF(O40=\"\",\"\",IF(O40=\"LBRA only\",0.2,IF(O40=\"HBRA only\",1,IF(O40=\"within electric line construction area\",19.8,IF(O40=\"within area delineated on plan LEGL./16-354\",4.6,\"\")))))","v":0.2},"No rating",{"$f":"IF(Q40=\"\",\"\",IF(C40>=DATE(2022,9,1),IF(Q40=\"No rating\",0.05,IF(Q40=\"Moderate\",0.334,IF(Q40=\"High\",0.678,IF(Q40=\"Extreme\",2.272,4.754)))),0.05))","v":0.05},{"$f":"IF(OR(P40=\"\",R40=\"\"),\"\",IF(AND(O40=\"within electric line construction area\",Q40=\"No forecast\"),1,P40*R40))","v":1.0000000000000002E-2},"J.22.0069611","20221109JEM_01","Conductor failure. Flashover from detereriorated conductor caused tree outside no.21 to catch fire. MFB on site. Small area beneath tree (<2 sq. m) of nature strip burnt.",null,null," - overhead conductor (bare; all aluminium conductor)"]
[17,4,"2022-11-19","16:31:00",-37.721615,145.02428,"31 NORTH ROAD, RESERVOIR VIC 3073","A048071","TT10","22kV AC","Urban"," - crossarm (wood)","three phase","Started in or originated from a distribution system","LBRA only",0.2,"No rating",0.05,1.0000000000000002E-2,"J.22.0070157","20230725JEM_01","Ground fire (<1m2). Poly insulator eyebolt pulled through termination crossarm at pole A048071 charring the bottom part of neighbouring fence. TT10 CB tripped to lockout.",null,null," - overhead conductor (bare; copper)"]
[17,5,"2022-11-20","08:41:00",-37.752586999999998,145.04471599999999,"16 SULLIVAN STREET, BELLFIELD VIC 3081","A106197","EPN33","22kV AC","Urban"," - pole (wood)","three phase","Started by any person, bird, reptile or other animal coming into contact with a distribution system","LBRA only",0.2,"No rating",0.05,1.0000000000000002E-2,"J.22.0070225","20221129JEM_01","Pole fire (A106197). LV crossarm King bolt to HV crossarm strap coach bolt caused by possum contact.",null,null," - overhead conductor (bare; steel)"]
[17,6,"2022-11-20","10:03:00",-37.709243000000001,144.93819400000001,"141A MIDDLE STREET, HADFIELD VIC 3046","A038463","PV15","11kV AC","Urban"," - pole (wood)","three phase","Started in or originated from a distribution system","LBRA only",0.2,"No rating",0.05,1.0000000000000002E-2,"J.22.0070230","20230830JEM_02","Pole fire (A038463). Pole burnt through top of pole where eye bolt meets the stay meets the pole.",null,null," - overhead conductor (ABC)"]
[17,7,"2023-01-08","16:31:00",-37.816113000000001,144.88722000000001,"78 ANDERSON STREET, YARRAVILLE VIC 3013","A146256","FE12","22kV AC","Urban"," - surge diverter","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,6.6800000000000012E-2,"J.23.0072511","20230108JEM_01","Minor grass fire. Metallic balloons shorted across HV CHP and surge diverters causing a successful reclose of feeder FE12. This fault current cause the burning of grass of approx. 3m^2.",null,null," - overhead conductor (covered uninsulated)"]
[17,8,"2023-01-15","09:19:00",-37.756749999999997,144.86098000000001,"4 ORLEANS ROAD, AVONDALE HEIGHTS VIC 3034 ","A025288","BY14","22kV AC","Urban"," - crossarm (wood)","three phase","Started in or originated from a distribution system","LBRA only",0.2,"Moderate",0.33400000000000002,6.6800000000000012E-2,"J.23.0072819","20230115JEM_01","Crossarm Fire (A025288). HV int crossarm burnt through at strap footpath side location due to tracking.",null,null," - overhead conductor (insulated)"]
[17,9,"2023-01-18","05:00:00",-37.866875999999998,144.90960799999999,"26 KANOWNA STREET, WILLIAMSTOWN VIC 3016","A060031","NT15","22kV AC","Urban"," - crossarm (wood)","three phase","Started in or originated from a distribution system","LBRA only",0.2,"High",0.67800000000000005,0.13560000000000003,"J.23.0073022","20230118JEM_03","Crossarm Fire (A060031). HV Cossarm burnt through due to tracking.",null,null,"Service lines"]
[17,10,"2023-01-26","22:39:00",-37.791263999999998,144.88550000000001,"18 ELEANOR STREET, FOOTSCRAY VIC 3011","A083919","FW04","22kV AC","Urban"," - connector / termination","three phase","Started by any person, bird, reptile or other animal coming into contact with a distribution system","LBRA only",0.2,"Moderate",0.33400000000000002,6.6800000000000012E-2,"J.23.0073394","20230126JEM_02","Minor grass fire. Possum got across HV CHP causing feeder to trip and minor grass fire at base of pole.",null,null," - overhead service conductor (residential)"]
[17,11,"2023-02-21","09:57:00",-37.572896999999998,144.705431,"58 HEYSEN DRIVE, SUNBURY VIC 3429","A001596","SBY32","22kV AC","Urban"," - crossarm (wood)","three phase","Started in or originated from a distribution system","LBRA only",0.2,"High",0.67800000000000005,0.13560000000000003,"J.23.0074594","20230223JEM_01","Crossarm Fire (A001596) HV Inter Crossarm fire outside at pole A001596",null,null," - overhead service conductor (commercial / industrial)"]
[17,12,"2023-03-28","08:58:00",-37.722676,144.97643400000001,"184 NEWLANDS ROAD, COBURG NORTH VIC 3058","A105238","CN03","22kV AC","Urban"," - transformer (ground outdoor mounted)","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,"J.23.0076405","20230328JEM_01","Ground Type Substation Fire (Newlands-Davies Co.). Vegetation growth within ground substation caused a fire due t contact with high voltage bushing.",null,null," - overhead service conductor (subdivision / construction)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," - overhead service conductor (other)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," - underground service cable (residential)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," - underground service cable (commercial / industrial)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," - underground service cable (subdivision / construction)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," - underground service cable (other)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Underground cables"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," - underground cable"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," - underground communications cable"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Poles"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," - pole (concrete)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," - pole (steel)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," - pole (wood)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Crossarms"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," - crossarm (wood)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," - crossarm (steel)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," - crossarm (other)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Overhead assets"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," - capacity balancing units"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," - connector / termination"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," - dropper / bridge"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," - guy wire"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," - insulator tie wires / connections"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," - insulators"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," - tower"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," - traction lines"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Underground assets"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," - LV pillar"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," - services pit"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Transformers"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," - transformer (pole mounted)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," - transformer (kiosk mounted)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," - transformer (ground outdoor mounted)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," - transformer (indoor chamber mounted)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," - transformer (any other type)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," - measurement transformer (current transformer)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," - measurement transformer (voltage transformer)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," - measurement transformer (capacitive voltage transformer)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fuses and switchgear"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," - fuse (boric acid)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," - fuse (EDO fuse)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," - fuse (Fault Tamer)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," - fuse (powder filled)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," - fuse (any other type)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," - circuit breaker"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," - switch (disconnector/isolator)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," - switch (earth)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," - switch (FuseSaver)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," - switch (any other type)"]
[null,null,null,null,null,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"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," - audio frequency load controller (AFLC)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," - arc suppresion coil"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," - automatic circuit recloser (ACR)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," - communications linear assets"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," - communications network assets"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," - communications site infrastructure"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," - field devices"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," - local network wiring assets"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," - master station assets"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," - neutral earthing resistor"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," - oil-filled circuit recloser (OCR)"]
[null,null,null,null,null,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)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," - surge diverter"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," - voltage regulator"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Public lighting"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," - brackets (major road)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," - brackets (minor road)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," - lamps (major road)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," - lamps (minor road)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," - luminaires (major road)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," - luminaires (minor road)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," - poles / columns (major road)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," - poles / columns (minor road)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," - connection box"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," - earth / earthing"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Extra low voltage AC (<50V)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Low voltage AC (<1kV)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2.2kV AC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6.6kV AC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"11kV AC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"12.7kV AC (SWER)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"22kV AC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"33kV AC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"66kV AC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"132kV AC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"220kV AC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"330kV AC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"500kV AC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Low voltage DC (<1.5kV)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"600V DC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1500V DC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Earthing cable"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"single wire earth return (SWER)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"single phase"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"two phase"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"three phase"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Negligible: no ground fire"]
[null,null,null,null,null,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"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Small: 10 - 1000 aq.m"]
[null,null,null,null,null,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"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Large: more than 10 ha"]
[]
[]
[null,null,null,null,null,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"]
[null,null,null,null,null,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"]
[null,null,null,null,null,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"]
[null,null,null,null,null,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 "]
[null,null,null,null,null,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"]
[null,null,null,null,null,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"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Y177+1","v":11}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Y178+1","v":12}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13]
[null,null,null,null,null,null,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,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,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,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,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,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,null,null,null,null,null,null,20]

{"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":"Jemena"}]
[null,"F-factor data reporting"]
[null,{"$f":"IF(Cover!D33=\"\",\"[Year]\",Cover!D33)","v":"2022/23"}]
[]
[]
[null,"Instructions:"]
[]
[null,{"$f":"IF(Cover!D27=\"\",\"[DNSP Name] must provide:\", CONCATENATE(Cover!D27,\" must provide:\"))","v":"Jemena must provide:"}]
[]
[null,"Table 4 - Information or reporting systems"]
[null,"   (1) Name of any IT system used to collect fire start data or fault event data - i.e. SCADA system, or fault reporting system"]
[null,"   (2) Whether the fire recording or fault recording process has been audited or complies with a relevant Australian or industry standard - Yes or No"]
[null,"   (3) List any relevant Australian or industry standards that the fire recording or fault recording process complies with"]
[null,"   (4) Whether the data entered into or removed from the IT system has been audited - Yes or No"]
[]
[]
[null,"Table 4: Information or reporting systems"]
[]
[null,"Information or reporting systems","Name","System Audited","Relevant Standards"]
[null,"System 1","SAP Plant Maintenance Module","Yes"]
[null,"System 2","ESV Fault Reporting Register (OSIRIS)","Yes","Energy Safe Victoria, \"Electrical Incident and Safety Performance Reporting Guidelines\""]
[null,"System 3 ","Outage Management System (OMS/CMOS)","Yes","Jemena, JEN PR 0502, \"JEN AER Network Reliability Reporting Procedure\""]
[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."]