{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Dataset","km","km (2)","mile","api","concatenate","zip code"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"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",61.2181,-149.49369999999999]
[]
[null,"Distance (Kilometers)",{"$f":"2*6400*ASIN(SQRT((SIN(RADIANS((C6-C5)/2)))^2+COS(RADIANS(C5))*COS(RADIANS(C6))*(SIN(RADIANS((D6-D5)/2)))^2))","v":4964.648544581898}]
[]
[null,"Angle of Haversine Formula",null,null,null,null,null,"Haversine Formula"]
[]
[null,"i"]

{"sheet":"km (2)","index":2,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3],[7,3,7,6],[8,3,8,6]]}
[]
[null,"Using Haversine Formula (Cosine Version)"]
[]
[null,"State","Latitude","Longitude"]
[null,"Ohio",40.417299999999997,-82.9071]
[null,"Alaska",61.2181,-149.49369999999999]
[]
[null,"Distance (Kilometers)",{"$f":"ACOS(SIN(RADIANS(C5)) *SIN(RADIANS(C6)) +COS(RADIANS(C5)) *COS(RADIANS(C6)) *COS(RADIANS(D5-D6))) *6371","v":4942.1524808642589},{"$f":"_xlfn.FORMULATEXT(C8)","v":"=ACOS(SIN(RADIANS(C5)) *SIN(RADIANS(C6)) +COS(RADIANS(C5)) *COS(RADIANS(C6)) *COS(RADIANS(D5-D6))) *6371"}]
[null,"Distance (Miles)",{"$f":"ACOS(SIN(RADIANS(C5)) *SIN(RADIANS(C6)) +COS(RADIANS(C5)) *COS(RADIANS(C6)) *COS(RADIANS(D5-D6))) *3959","v":3071.1005606249573},{"$f":"_xlfn.FORMULATEXT(C9)","v":"=ACOS(SIN(RADIANS(C5)) *SIN(RADIANS(C6)) +COS(RADIANS(C5)) *COS(RADIANS(C6)) *COS(RADIANS(D5-D6))) *3959"}]
[]
[null,"i"]

{"sheet":"mile","index":3,"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(RADIANS((C6-C5)/2)))^2+COS(RADIANS(C5))*COS(RADIANS(C6))*(SIN(RADIANS((D6-D5)/2)))^2))","v":3062.7292124925852}]

{"sheet":"api","index":4,"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,{"$f":"C5 & \", \" &D5","v":"40.4173, -82.9071"}]
[null,"Alaska",64.200800000000001,-149.49369999999999,{"$f":"C6 & \", \" &D6","v":"64.2008, -149.4937"}]
[]
[null,"API Link","AvAMQVCQZRHasj75zfHQyX5lHvfgjJKInhHyaY6cXJtXsulSdMC3r71LGZ2uTY3a"]
[]
[null,"Distance (Miles)",{"$f":"DistanceInMiles(E5,E6,C8)","v":3858}]
[null,"Distance (Kilometers)",{"$f":"DistanceInKM(E5,E6,C8)","v":6209}]

{"sheet":"concatenate","index":5,"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)"]

{"sheet":"zip code","index":6,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Getting Zip Code Distance"]
[]
[null,"Zip Code 1","Zip Code 2","Distance (Miles)"]
[null,15237,"07747",{"$f":"[1]!GeoDistance(B5,C5)","v":304.55360000000002}]
[null,12308,61820,{"$f":"[1]!GeoDistance(B6,C6)","v":763.62350000000004}]
[null,"04011","07002",{"$f":"[1]!GeoDistance(B7,C7)","v":306.86869999999999}]
[null,17325,15001,{"$f":"[1]!GeoDistance(B8,C8)","v":171.26519999999999}]