{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["ASP3","Overhead","Street Lighting","Underground","Substation"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":12,"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":"ASP3","index":0,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[9,2,9,5],[10,2,10,5],[8,0,8,1],[1,0,1,12],[10,0,10,1],[9,0,9,1],[6,1,6,5],[7,1,7,2],[7,4,7,5],[8,2,8,5]]}
[]
["Asset Number Request Sheet v20150828"]
[]
["To obtain asset numbers please complete the \"Asset Number Request Sheet\" as outlined in NS104"]
[]
[]
["Project ID:"]
["Date:",null,null,"Designer:"]
["Project Details:"]
["ASP 3 Company:"]
["Email address:"]

{"sheet":"Overhead","index":1,"n_rows":22,"n_cols":13,"rows_kept":22,"cut":false,"hidden":false,"merged":[[6,2,6,5],[4,4,4,5],[7,2,7,5],[1,0,1,12],[4,1,4,2],[5,2,5,5],[3,1,3,5]]}
[]
["Asset Number Request Sheet - Overhead Poles & Equipment "]
[]
["Project ID:",{"$f":"IF('ASP3'!B7=0,\"\",'ASP3'!B7)","v":""}]
["Date:",{"$f":"IF('ASP3'!B8=0,\"\",'ASP3'!B8)","v":""},null,"Designer:",{"$f":"IF('ASP3'!E8=0,\"\",'ASP3'!E8)","v":""}]
["Project Details:",null,{"$f":"IF('ASP3'!C9=0,\"\",'ASP3'!C9)","v":""}]
["ASP 3 Company:",null,{"$f":"IF('ASP3'!C10=0,\"\",'ASP3'!C10)","v":""}]
["Email address:",null,{"$f":"IF('ASP3'!C11=0,\"\",'ASP3'!C11)","v":""}]
[]
[]
[]
["Example:"]
["Asset Ref","1:2000   GRID REF.","Size","Material","Equipment Type","Dedicated Street/Road","Suburb","Council","Voltage","Pole #","ABS #","LVL #","Pole Sub #"]
[]
["NP1","PA-22","12.5m 8 kN","Timber","Pole","Smith Street","Smithfield","Smithfield Council",11000,"PA-12324",20151]
["NP2","PA-22","11.0m 12 kN","Timber","Pole","Smith Street","Smithfield","Smithfield Council",415,"PA-12325",null,22250]
["NP3","PA-22","6m","Steel","Pole","Smith Street","Smithfield","Smithfield Council",250,"PA-12326",null,null,51265]
[]
[]
["NOTE:  Please request dedicated street light column numbers on Street Lighting tab"]
[]
["Asset Ref","1:2000   GRID REF.","Size","Material","Equipment Type","Dedicated Street/Road","Suburb","Council","Voltage","Pole #","ABS #","LVL #",{"$f":"M13","v":"Pole Sub #"}]

{"sheet":"Street Lighting","index":2,"n_rows":23,"n_cols":12,"rows_kept":23,"cut":false,"hidden":false,"merged":[[17,0,17,10],[1,0,1,11],[4,5,4,6],[7,2,7,6],[3,1,3,6],[4,1,4,2],[5,2,5,6],[6,2,6,6]]}
[]
["Asset Number Request Sheet - Street Lighting Column & Equipment"]
[]
["Project ID:",{"$f":"IF('ASP3'!B7=0,\"\",'ASP3'!B7)","v":""}]
["Date:",{"$f":"IF('ASP3'!B8=0,\"\",'ASP3'!B8)","v":""},null,null,"Designer:",{"$f":"IF('ASP3'!E8=0,\"\",'ASP3'!E8)","v":""}]
["Project Details:",null,{"$f":"IF('ASP3'!C9=0,\"\",'ASP3'!C9)","v":""}]
["ASP 3 Company:",null,{"$f":"IF('ASP3'!C10=0,\"\",'ASP3'!C10)","v":""}]
["Email address:",null,{"$f":"IF('ASP3'!C11=0,\"\",'ASP3'!C11)","v":""}]
[]
[]
[]
["Example:"]
["Asset Ref","Column Type","1:2000   GRID REF.","Address","Luminaire Type ","Lamp Size (W)","Bracket ","Support","Connection","Rate","Customer","Asset #"]
["NP1","Steel","PA-22","70 Smith St Smithfield","42W Amalgam CFL ECG CAT P Aeroscreen","42W CFL",3,"6m","U/G",2,"Smithfield Council","PA-25553"]
["PA-25600","Timber","PA-22","64 Smith St Smithfield","42W Amalgam CFL ECG CAT P Aeroscreen","42W CFL",1.2,"N/A","O/H",1,"Smithfield Council","Existing"]
[]
[]
[]
[]
[]
["NOTE:  This tab is for Street Light equipment only, eg Steel Columns, Lamps and Luminaires"]
[]
["Asset Ref","Column Type","1:2000   GRID REF.","Address","Luminaire Type ","Lamp Size (W)","Bracket ","Support","Connection","Rate","Customer","Asset #"]

{"sheet":"Underground","index":3,"n_rows":20,"n_cols":12,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,0,1,11],[4,1,4,2],[3,1,3,5],[4,4,4,5],[11,0,11,9],[5,2,5,5],[6,2,6,5],[7,2,7,5]]}
[]
["Asset Number Request Sheet - Underground Pillars, LV Links etc"]
[]
["Project ID:",{"$f":"IF('ASP3'!B7=0,\"\",'ASP3'!B7)","v":""}]
["Date:",{"$f":"IF('ASP3'!B8=0,\"\",'ASP3'!B8)","v":""},null,"Designer:",{"$f":"IF('ASP3'!E8=0,\"\",'ASP3'!E8)","v":""}]
["Project Details:",null,{"$f":"IF('ASP3'!C9=0,\"\",'ASP3'!C9)","v":""}]
["ASP 3 Company:",null,{"$f":"IF('ASP3'!C10=0,\"\",'ASP3'!C10)","v":""}]
["Email address:",null,{"$f":"IF('ASP3'!C11=0,\"\",'ASP3'!C11)","v":""}]
[]
[]
[]
["Example: (NOTE: Road/Street name must be the same as rates notice from local Council)"]
["Asset Ref","1:2000   GRID REF.","Sub No","Dist/Fuse No","Base","Turret","Dedicated Street/Road","Suburb","Council","Pillar #","LVL #","Pit #"]
["A","PA-22",56123,1,"Plastic","Large","Smith Street","Smithfield","Smithfield Council","PA-22210",22251]
["B","PA-22",56123,1,"Plastic","Large","Smith Street","Smithfield","Smithfield Council","PA-22211"]
[]
[]
[]
[]
["Asset Ref","1:2000   GRID REF.","Sub No","Dist/Fuse No","Base","Turret","Dedicated Street/Road","Suburb","Council","Pillar #","LVL #","PIT #"]

{"sheet":"Substation","index":4,"n_rows":49,"n_cols":5,"rows_kept":49,"cut":false,"hidden":false,"merged":[[43,2,43,3],[1,0,1,5],[4,1,4,2],[3,1,3,5],[4,4,4,5],[11,2,11,3],[27,2,27,3],[6,2,6,5],[5,2,5,5],[7,2,7,5]]}
[]
["Asset Number Request Sheet - Substation"]
[]
["Project ID:",{"$f":"IF('ASP3'!B7=0,\"\",'ASP3'!B7)","v":""}]
["Date:",{"$f":"IF('ASP3'!B8=0,\"\",'ASP3'!B8)","v":""},null,"Designer:",{"$f":"IF('ASP3'!E8=0,\"\",'ASP3'!E8)","v":""}]
["Project Details:",null,{"$f":"IF('ASP3'!C9=0,\"\",'ASP3'!C9)","v":""}]
["ASP 3 Company:",null,{"$f":"IF('ASP3'!C10=0,\"\",'ASP3'!C10)","v":""}]
["Email address:",null,{"$f":"IF('ASP3'!C11=0,\"\",'ASP3'!C11)","v":""}]
[]
[]
[null,null,"Example:"]
[null,null,"Kiosk Substation Numbers"]
[null,null,"Component","Asset #"]
[null,null,"Sub Name","Smith Street"]
[null,null,"Sub No","S.56123"]
[null,null,"Addresss","62-70 Smith St Smithfield"]
[null,null,"Kiosk Type","L Type"]
[null,null,"Size","800kVA"]
[null,null,"Configuration","800/400/400/400"]
[null,null,"Dist No 1","62-70 Smith St Consumers Mains"]
[null,null,"Dist No 2","WDNO"]
[null,null,"Dist No 3","Pillar PA-25601 (N/O)"]
[null,null,"Dist No 4","Smith St O/H"]
[]
[]
["NOTE:  Asset numbers for Chamber substations to be issued on request."]
[]
[null,null,"Kiosk Substation Numbers"]
[null,null,"Component","Asset #"]
[null,null,"Sub Name"]
[null,null,"Sub No"]
[null,null,"Addresss"]
[null,null,"Kiosk Type"]
[null,null,"Size"]
[null,null,"Configuration"]
[null,null,"Dist No 1"]
[null,null,"Dist No 2"]
[null,null,"Dist No 3"]
[null,null,"Dist No 4"]
[]
[]
[]
[]
[null,null,"Pole Substation Numbers"]
[null,null,"Component","Asset #"]
[null,null,"Sub Name"]
[null,null,"Sub No"]
[null,null,"Addresss"]
[null,null,"Size"]