{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Plan Data"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Plan Data","index":0,"n_rows":7,"n_cols":9,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[12,"Length of Road (Km)"]
[]
["Chainage\n(Optional)","Salient Description of Point\n(Optional but Recommended)","Latitude","Longitude","Distance\n(Mt)","Bearing (Deg)","Cumulative\nDistance (Mt)","East-West\nCoordinate","North-South\nCoordinate"]
[]
["Chainage","Point Description","Latitude","Longitude","Distance\n(Mt)","Bearing (Deg)","Cumulative\nDistance (Mt)",null,"Plan"]
[0,"0/0  - Start of the road",{"$nulls":5},0,0]
[{"$nulls":4},{"$f":"CEILING(ACOS(COS(RADIANS(90-C6)) *COS(RADIANS(90-C7)) +SIN(RADIANS(90-C6)) *SIN(RADIANS(90-C7)) *COS(RADIANS(D6-D7))) *6371000,0.001)","v":0},{"$f":"DEGREES(ATAN2(COS(RADIANS(C6))*SIN(RADIANS(C7))-SIN(RADIANS(C6))*COS(RADIANS(C7))*COS(RADIANS(D7)-RADIANS(D6)),SIN(RADIANS(D7)-RADIANS(D6))*COS(RADIANS(C7))))","v":{"$error":"#DIV/0!"}},{"$f":"G6+E7","v":0},{"$f":"ROUND(H6+E7*SIN(RADIANS(F7)),2)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(I6+E7*COS(RADIANS(F7)),2)","v":{"$error":"#DIV/0!"}}]