{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["AERODROME OBSTACLES DATA","Setup"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"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":"AERODROME OBSTACLES DATA","index":0,"n_rows":6,"n_cols":10,"rows_kept":6,"cut":false,"hidden":false,"merged":[[4,0,5,0],[4,9,5,9],[4,8,5,8],[4,1,5,1],[4,4,4,5],[4,2,5,2],[4,3,5,3],[4,7,5,7],[1,7,1,9],[2,0,2,7],[3,0,3,7],[0,0,0,9],[1,0,1,6],[2,8,3,9]]}
["INSTRUCTIONS"]
["1. Enter the appropriate Y-CODE in Row 3 of the table. \n2. Populate the attributes in Green columns (C - J) for each reported structure. Click on each attribute headings for more information.\n3. Send the spreadsheet to vod@airservicesaustralia.com by selecting the \"SEND EMAIL\" button.\n\nNOTES:\nAirservices will enter the structures in the Vertical Obstacle Database and generate unique VOIDENTS for each reported structure.\nAirservices will send the OBST Survey Data Collection Form back to the ADO with the AIRSERVICES VOIDENT column populated.\nThe OBST Survey Data Collection Form will henceforth serve as an OBST repository between AIS and the ADO."]
["YXXX"]
["AERODROME OBSTACLES DATA"]
["AIRSERVICES VOIDENT","OBST STATUS","OBST OWNER ID","DESCRIPTION","WGS84",null,"AHD","LIGHTING","PUBLISHED IN ERSA","PUBLISHED IN DAP"]
[null,null,null,null,{"$f":"VLOOKUP(E5,Setup!A2:C5,2,)","v":"LATITUDE DMS"},{"$f":"VLOOKUP(E5,Setup!A2:C5,3,)","v":"LONGITUDE DMS"},"HEIGHT AMSL (M)"]

{"sheet":"Setup","index":1,"n_rows":18,"n_cols":12,"rows_kept":18,"cut":false,"hidden":true,"merged":[[0,0,0,2],[15,10,15,11],[16,10,16,11],[17,10,17,11],[10,10,10,11],[11,10,11,11],[12,10,12,11],[13,10,13,11],[14,10,14,11]]}
["CHOOSE PSN FORMAT",null,null,null,null,"STATUS",null,null,null,null,"ATTRIBUTE","ATTRIBUTE EXPLANATION "]
["WGS84","LATITUDE DMS","LONGITUDE DMS",null,null,"ADDED",null,"Y",null,null,"AIRSERVICES VOIDENT","A system generated unique identifier for every structure entered in the Vertical Obstacle Data base. ASA use only."]
["GDA94 MGA","NORTHING","EASTING",null,null,"AMENDED",null,"N",null,null,"OBST OWNER ID","Surveyor or aerodrome operator assigned obstacle identifier."]
["GDA2020 MGA","NORTHING","EASTING",null,null,"EXISTING",null,null,null,null,"DESCRIPTION","Brief description of structure. E.g. Tree, COMMS TWR, PWR pole."]
["GEODETIC POSITION","DIST FROM SOT (M)","OFFSET FROM CL (M)",null,null,"REMOVED",null,null,null,null,"PSN","Option of providing the PSN of structure in GDA MGA94 or WGS84. Select from drop down menu."]
[null,null,null,null,null,null,null,null,null,null,"HEIGHT AMSL (M)","Top of the structure height above mean sea level in Metres."]
[null,null,null,null,null,null,null,null,null,null,"LIGHTING","Lighting status Yes or No"]
[null,null,null,null,null,null,null,null,null,null,"PUBLISHED IN ERSA","Is the Structure published in ERSA Yes/No"]
[null,null,null,null,null,null,null,null,null,null,"PUBLISHED IN DAP","Is the structure published in DAP Yes/No"]
[]
[null,null,null,null,null,null,null,null,null,null,"INSTRUCTIONS"]
[null,null,null,null,null,null,null,null,null,null,"Enter the appropriate YCODE at the top of the table."]
[null,null,null,null,null,null,null,null,null,null,"Populate the grey attributes for each structure to be reported."]
[null,null,null,null,null,null,null,null,null,null,"Send the spreadsheet to VOD@airservicesaustralia.com "]
[null,null,null,null,null,null,null,null,null,null,"Airservices will enter the structures in the Vertical Obstacle Database and generate unique VOIDENTS for each reported structure."]
[null,null,null,null,null,null,null,null,null,null,"Airservices will send the OBST Survey Data Collection Form back to the ADO with the AIRSERVICES VOIDENT column populated."]
[null,null,null,null,null,null,null,null,null,null,"The OBST Survey Data Collection Form will henceforth serve as an OBST repository between AIS and the ADO."]
[null,null,null,null,null,null,null,null,null,null,"Changes to aerodrome OBST will be marked up in the OBST Survey Data Collection Form and sent to VOD@airservicesaustralia.com as per the SAMPLE table to the right: "]