{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Dataset","km","mile","api","concatenate"],"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":"Dataset","index":0,"n_rows":6,"n_cols":4,"rows_kept":6,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Calculate Distance Between Two Addresses "]
[]
[null,"State","Latitude","Longitude"]
[null,"Ohio",40.417299999999997,82.9071]
[null,"Alaska",64.200800000000001,149.49369999999999]

{"sheet":"km","index":1,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3],[9,1,9,4],[9,7,9,13]]}
[]
[null,"Using Haversine Formula"]
[]
[null,"State","Latitude","Longitude"]
[null,"Ohio",40.417299999999997,82.9071]
[null,"Alaska",64.200800000000001,149.49369999999999]
[]
[null,"Distance (Kilometers)",{"$f":"2*6400*ASIN(SQRT((SIN(C6-C5)/2)^2+COS(C5)*COS(C6)*(SIN(D6-D5)/2)^2))","v":6292.133385033706}]
[]
[null,"Angle of Haversine Formula",null,null,null,null,null,"Haversine Formula"]
[]
[null,"i"]

{"sheet":"mile","index":2,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using Haversine Formula"]
[]
[null,"State","Latitude","Longitude"]
[null,"Ohio",40.417299999999997,82.9071]
[null,"Alaska",64.200800000000001,149.49369999999999]
[]
[null,"Distance (Miles)",{"$f":"2*3959*ASIN(SQRT((SIN(C6-C5)/2)^2+COS(C5)*COS(C6)*(SIN(D6-D5)/2)^2))","v":3892.274386148194}]

{"sheet":"api","index":3,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4],[7,2,7,4]]}
[]
[null,"Using API & VBA"]
[]
[null,"State","Latitude","Longitude","GPS Coordinates"]
[null,"Ohio",40.417299999999997,82.9071,"40.4173, -82.9071"]
[null,"Alaska",64.200800000000001,149.49369999999999,"64.2008, -149.4937"]
[]
[null,"API Link","AvYVBUwRObGHzb1GsyJyR5oPjy4tOJDM59Hs226cenJ9WZd2iHp6_MZ8m1Uqy7aV"]
[]
[null,"Distance (Miles)",{"$f":"DistanceInMiles(E5,E6,C8)","v":3858}]
[null,"Distance (Kilometers)",{"$f":"DistanceInKM(E5,E6,C8)","v":6209}]

{"sheet":"concatenate","index":4,"n_rows":8,"n_cols":8,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,3],[7,2,7,3],[1,5,1,7]]}
[]
[null,"Using CONCATENATE & SUBSTITUTE Function",null,null,null,"Practice Section"]
[]
[null,"State","Latitude","Longitude",null,"State","Latitude","Longitude"]
[null,"Ohio",40.417299999999997,82.9071,null,"Ohio",40.417299999999997,82.9071]
[null,"Alaska",64.200800000000001,149.49369999999999,null,"Alaska",64.200800000000001,149.49369999999999]
[]
[null,"Distance URL",{"$f":"CONCATENATE(\"http://maps.google.co.uk/maps?f=d&source=s_d&saddr=\",\nSUBSTITUTE(B5,\" \",\"+\"),\"&daddr=\",SUBSTITUTE(B6,\" \",\"+\"))","v":"http://maps.google.co.uk/maps?f=d&source=s_d&saddr=Ohio&daddr=Alaska"},null,null,"Distance (Kilometers)"]