{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Sheet1","index":0,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,0,0,4]]}
[">> Click here for more Free Excel resources <<"]
[]
["City","Latitude","Longitude"]
[{"$error":"#VALUE!"},{"$f":"_FV(A4,\"Latitude\")","v":40.700000000000003},{"$f":"_FV(A4,\"Longitude\")","v":-74}]
[{"$error":"#VALUE!"},{"$f":"_FV(A5,\"Latitude\")","v":34.052230000000002},{"$f":"_FV(A5,\"Longitude\")","v":-118.24368}]
[{"$error":"#VALUE!"},{"$f":"_FV(A6,\"Latitude\")","v":41.850029999999997},{"$f":"_FV(A6,\"Longitude\")","v":-87.650049999999993}]
[{"$error":"#VALUE!"},{"$f":"_FV(A7,\"Latitude\")","v":29.762777777777998},{"$f":"_FV(A7,\"Longitude\")","v":-95.383055555555998}]
[]
[]
["Distance between Pasco and Los Angeles"]
[{"$f":"6371*ACOS(COS(RADIANS(90-B4))*COS(RADIANS(90-B5))+SIN(RADIANS(90-B4))*SIN(RADIANS(90-B5))*COS(RADIANS(C4-C5)))","v":3936.339710451387}]

{"sheet":"Sheet2","index":1,"n_rows":7,"n_cols":1,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["City"]
["New York City"]
["Los Angeles"]
[]
[]
["Distance between New York City and Los Angeles"]
[{"$f":"HYPERLINK(\"https://www.google.com/maps/dir/\" & A2 & \"/\" & A3, \"Find Distance\")","v":"Find Distance"}]

{"sheet":"Sheet3","index":2,"n_rows":7,"n_cols":1,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["City"]
["New York City"]
["Los Angeles"]
[]
[]
["Distance between New York City and Los Angeles"]
[{"$f":"GetDistance(\"New York, USA\", \"Los Angeles, USA\")","v":{"$error":"#VALUE!"}}]