{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Project","Configs","SAPJOB","SAPTAS"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":3,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Project","index":0,"n_rows":42,"n_cols":9,"rows_kept":42,"cut":false,"hidden":false,"merged":[[13,10,13,11],[16,8,16,9],[2,8,2,9],[11,8,11,9],[13,8,13,9],[16,4,16,6],[17,4,17,6],[2,4,2,6],[3,4,3,6],[13,4,13,6],[1,4,1,6],[6,4,6,6],[11,4,11,6],[9,4,9,6],[4,4,4,6],[7,4,7,6]]}
[]
[null,"PROJECT:",null,null,null,null,null,null,"Endeavour Use Only"]
[null,null,null,null,"P.35645.6"]
[null,"RETIC DRAWING NUMBER:"]
[null,null,null,null,"Request new Retic Drawing number"]
[]
[null,"DUCT DRAWING NUMBER:"]
[null,null,null,null,"Request new Duct Drawing number"]
[]
[null,"CAP APPLICATION NUMBER:",null,null,"GEDTEST",null,null,null,"ASP Use Only"]
[]
[null,"LOCATION:",null,null,"Penrith Field Service Centre",null,null,null,"Endeavour Use Only"]
[]
[null,"PROCESSING:",null,null,"TAS+TAL",null,null,null,"TAS Only or TAS+TAL        "]
[null,null,null,null,null,null,null,null,"Endeavour Use Only"]
[]
[null,"Person:",null,null,null,null,null,null,"Endeavour Use Only"]
[null,"eMail:"]
[]
[null,"Functional Locations:",null,null,"Quantity"]
[]
[null,"Poles:",null,null,1]
[null,null,null,null,null,null,"Poles: 1"]
[null,null,null,null,null,null,"Pole Structure",1]
[null,null,null,null,null,null,"Pole Switch"]
[null,null,null,null,null,null,"Pole Street Lighting"]
[null,null,null,null,null,null,"Pole Assembly (1 per voltage level)",1]
[null,null,null,null,null,null,"Pole Streetlight Control Point"]
[]
[null,"Columns:",null,null,0]
[]
[null,"Pillars:",null,null,0]
[]
[null,"HV Combination Switchgear:",null,null,0]
[]
[null,"Ground Dist Subs:",null,null,0]
[]
[null,"LV Combination Switchgear:",null,null,0]
[]
[null,"Pole Dist Subs:",null,null,0]
[]
[null,"<Select Equipment Type>",null,null,0]

{"sheet":"Configs","index":1,"n_rows":42,"n_cols":12,"rows_kept":42,"cut":false,"hidden":true,"merged":[]}
[null,null,"Qty","FLOC PREFIX","REFERENCE FLOC","SupFLoc",null,"<Select Equipment Type>",null,null,"<Select Location>","Location Code"]
["Parent","HV Combination Switchgear",1,"HVDG","HVDGDSUB0001",null,null,"HV Combination Switchgear","HVDGDSUB0001",null,"Central Logistics Facility","1000"]
["Child","HV and Earth Tx Switches",null,"DSSW","DSSWDSUB0001","HVDGDSUB0001",null,"HV and Earth Tx Switches","DSSWDSUB0001",null,"Head Office Huntingwood","1100"]
["Child","HV and Earth Fdr Switches",null,"SWIT","SWITDSUB0001","HVDGDSUB0001",null,"HV and Earth Fdr Switches","SWITDSUB0001",null,"Kandos Field Service Centre","1110"]
["Child","HVCB - HV Circuit Breaker",null,"HVCB","HVCBDSUB0001","HVDGDSUB0001",null,"HVCB - HV Circuit Breaker","HVCBDSUB0001",null,"Katoomba Field Service Centre","1120"]
["Child","HV Busbar Bay",1,"BBHV","BBHVDSUB0001","HVDGDSUB0001",null,"HV Busbar Bay","BBHVDSUB0001",null,"Kings Park Field ServiceCentre","1130"]
[null,null,null,null,null,null,null,"Pole Structure","POLEPOLE0001",null,"Parramatta Field ServiceCentre","1140"]
["Parent","Pole Structure",1,"POLE","POLEPOLE0001",null,null,"Pole Switch","SWITPOLE0001",null,"Penrith Field Service Centre","1150"]
["Child","Pole Switch",null,"SWIT","SWITPOLE0001","POLEPOLE0001",null,"Pole Street Lighting","SLGTPOLE0001",null,"Penrith Pole Yard","1160"]
["Child","Pole Street Lighting",null,"SLGT","SLGTPOLE0001","POLEPOLE0001",null,"Pole Assembly (1 per voltage level)","ASSMPOLE0001",null,"Windsor Field Service Centre","1170"]
["Child","Pole Assembly (1 per voltage level)",1,"ASSM","ASSMPOLE0001","POLEPOLE0001",null,"Pole Streetlight Control Point","SLCPPOLE0001",null,"Bowenfels Field Service Centre","1180"]
["Child","Pole Streetlight Control Point",null,"SLCP","SLCPPOLE0001","POLEPOLE0001",null,"Ground Distribution Substation","DSUBDSUB0001",null,"Glendenning FieldServiceCentre","1190"]
[null,null,null,null,null,null,null,"Ground Transformer","DSTXDSUB0001",null,"Hoxton Park FieldServiceCentre","1210"]
["Parent","Ground Distribution Substation",1,"DSUB","DSUBDSUB0001",null,null,"Column Structure","CLMNCLMN0001",null,"Hoxton Park Technical Training","1220"]
["Child","Ground Transformer",null,"DSTX","DSTXDSUB0001","DSUBDSUB0001",null,"Column Internal Assembly","ASSMCLMN0001",null,"Moss Vale Field Service Centre","1230"]
["Child"," -",null,null,null,null,null,"Column Street Lighting","SLGTCLMN0001",null,"Narellan Field Service Centre","1240"]
["Child"," -",null,null,null,null,null,"Column Streetlight Control Point","SLCPCLMN0001",null,"Picton Field Service Centre","1250"]
["Child"," -",null,null,null,null,null,"Column LV Switch","SWITCLMN0001",null,"Transformer Workshop","1260"]
[null,null,null,null,null,null,null,"LV Pillar Structure","PILLPILL0001",null,"Nowra Field Service Centre","1310"]
["Parent","Column Structure",1,"CLMN","CLMNCLMN0001",null,null,"Pillar Internal Assembly","ASSMPILL0001",null,"Shellharbour FieldServiceCentr","1320"]
["Child","Column Internal Assembly",1,"ASSM","ASSMCLMN0001","CLMNCLMN0001",null,"Pillar LV Switch","SWITPILL0001",null,"Springhill Field ServiceCentre","1330"]
["Child","Column Street Lighting",1,"SLGT","SLGTCLMN0001","CLMNCLMN0001",null,"LV Combination Switchgear","LVDGDSUB0001",null,"Ulladulla Field Service Centre","1340"]
["Child","Column Streetlight Control Point",null,"SLCP","SLCPCLMN0001","CLMNCLMN0001",null,"LV Tx Switch","DSSWDSUB0002",null,"Compressor # 1","YB_3001"]
["Child","Column LV Switch",null,"SWIT","SWITCLMN0001","CLMNCLMN0001",null,"LV Switches and Gen Link","SWITDSUB0002",null,"Compressor # 2","YB_3002"]
[null,null,null,null,null,null,null,"LVCB - LV Circuit Breaker","LVCBDSUB0001",null,"Compressor # 3","YB_3003"]
["Parent","LV Pillar Structure",1,"PILL","PILLPILL0001",null,null,"LV Busbar Bay","BBLVDSUB0001",null,"Compressor # 4","YB_3004"]
["Child","Pillar Internal Assembly",1,"ASSM","ASSMPILL0001","PILLPILL0001",null,"Pole Distribution Substation","DSUBPOLE0001",null,"Air Dryer","YB_3005"]
["Child","Pillar LV Switch",null,"SWIT","SWITPILL0001","PILLPILL0001",null,"Pole Transformer","DSTXPOLE0001",null,"Cooling Water System","YB_3006"]
["Child"," -",null,null,null,null,null,"Pole Sub Switches (LV,HV,Tx links,etc)","DSSWPOLE0001",null,"Cooling Towers","YB_3007"]
["Child"," -",null,null,null,null,null,"Pole LV Busbar","BBLVPOLE0001"]
[]
["Parent","LV Combination Switchgear",1,"LVDG","LVDGDSUB0001"]
["Child","LV Tx Switch",null,"DSSW","DSSWDSUB0002","LVDGDSUB0001"]
["Child","LV Switches and Gen Link",null,"SWIT","SWITDSUB0002","LVDGDSUB0001"]
["Child","LVCB - LV Circuit Breaker",null,"LVCB","LVCBDSUB0001","LVDGDSUB0001"]
["Child","LV Busbar Bay",1,"BBLV","BBLVDSUB0001","LVDGDSUB0001"]
[]
["Parent","Pole Distribution Substation",1,"DSUB","DSUBPOLE0001"]
["Child","Pole Transformer",null,"DSTX","DSTXPOLE0001","DSUBPOLE0001"]
["Child","Pole Sub Switches (LV,HV,Tx links,etc)",null,"DSSW","DSSWPOLE0001","DSUBPOLE0001"]
["Child","Pole LV Busbar",1,"BBLV","BBLVPOLE0001","DSUBPOLE0001"]
["Child"," -"]

{"sheet":"SAPJOB","index":2,"n_rows":2,"n_cols":7,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["PROJNUM","DRAWING","CAP APPLICATION NUMBER","MAINTLOC","PROCOPTION","SOURCEBY","SOURCEMAIL"]
[{"$f":"IF(Project!E2<>\"\",Project!E2,\"\")","v":""},{"$f":"Project!E4","v":0},{"$f":"IF(Project!E10<>\"\",Project!E10,\"\")","v":"GEDTEST"},{"$f":"VLOOKUP(Project!E12,Configs!K2:L29,2,FALSE)","v":"1150"},{"$f":"Project!E14","v":"TAS+TAL"},{"$f":"Project!E17","v":0},{"$f":"Project!E18","v":0}]

{"sheet":"SAPTAS","index":3,"n_rows":3,"n_cols":5,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["Proj Num","Ref FLoc","Sup FLoc","Group","Qty"]
[null,"POLEPOLE0001",null,null,1]
[null,"ASSMPOLE0001","POLEPOLE0001",1,1]