{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["geography data","VBA"],"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":"geography data","index":0,"n_rows":16,"n_cols":9,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,3],[3,6,3,8],[1,6,1,8]]}
[]
[null,"Geocoding with Geography Data",null,null,null,null,"Practice Yourself"]
[]
[null,"Address","Latitude","Longitude",null,null,"Geocoding with Geography Data"]
[null,{"$error":"#VALUE!"},{"$f":"_FV(B5,\"Latitude\")","v":40.700000000000003},{"$f":"_FV(B5,\"Longitude\")","v":-74}]
[null,{"$error":"#VALUE!"},{"$f":"_FV(B6,\"Latitude\")","v":51.507222222221998},{"$f":"_FV(B6,\"Longitude\")","v":-0.1275},null,null,"Address","Latitude","Longitude"]
[null,{"$error":"#VALUE!"},{"$f":"_FV(B7,\"Latitude\")","v":34.052230000000002},{"$f":"_FV(B7,\"Longitude\")","v":-118.24368},null,null,"New York City"]
[null,{"$error":"#VALUE!"},{"$f":"_FV(B8,\"Latitude\")","v":48.856666666666698},{"$f":"_FV(B8,\"Longitude\")","v":2.35222222222222},null,null,"London"]
[null,{"$error":"#VALUE!"},{"$f":"_FV(B9,\"Latitude\")","v":48.137500000000003},{"$f":"_FV(B9,\"Longitude\")","v":11.574999999999999},null,null,"Los Angeles"]
[null,{"$error":"#VALUE!"},{"$f":"_FV(B10,\"Latitude\")","v":47.3744444444444},{"$f":"_FV(B10,\"Longitude\")","v":8.5411111111111104},null,null,"Paris"]
[null,{"$error":"#VALUE!"},{"$f":"_FV(B11,\"Latitude\")","v":41.3825},{"$f":"_FV(B11,\"Longitude\")","v":2.1769444444444002},null,null,"Munich"]
[null,{"$error":"#VALUE!"},{"$f":"_FV(B12,\"Latitude\")","v":45.466944444444003},{"$f":"_FV(B12,\"Longitude\")","v":9.19},null,null,"Zurich"]
[null,{"$error":"#VALUE!"},{"$f":"_FV(B13,\"Latitude\")","v":43.670277777777997},{"$f":"_FV(B13,\"Longitude\")","v":-79.386666666666997},null,null,"Barcelona"]
[null,{"$error":"#VALUE!"},{"$f":"_FV(B14,\"Latitude\")","v":41.850029999999997},{"$f":"_FV(B14,\"Longitude\")","v":-87.650049999999993},null,null,"Milan"]
[null,null,null,null,null,null,"Toronto"]
[null,null,null,null,null,null,"Chicago"]

{"sheet":"VBA","index":1,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,2],[3,4,3,5],[1,4,1,5]]}
[]
[null,"Geocoding Using VBA",null,null,"Practice Yourself"]
[]
[null,"Address","Latitude, Longitude",null,"Geocoding Using VBA"]
[null,"5331 Rexford Court, Montgomery, AL 36116",{"$f":"Co_Ordinates(B5)","v":"32.3374755,-86.2161153"}]
[null,"1 Rockefeller Plaza, New York, NY 10020",{"$f":"Co_Ordinates(B6)","v":"40.7580432,-73.9790248"},null,"Address","Latitude, Longitude"]
[null,"150 Central Park West, New York, NY 10023",{"$f":"Co_Ordinates(B7)","v":"40.7780372,-73.9748486"},null,"5331 Rexford Court, Montgomery, AL 36116"]
[null,"19141 Pine Ridge Circle, Anchorage, AK 99516",{"$f":"Co_Ordinates(B8)","v":"61.0476673,-149.7778449"},null,"1 Rockefeller Plaza, New York, NY 10020"]
[null,"300 North Michigan Avenue, Chicago, IL 60601",{"$f":"Co_Ordinates(B9)","v":"41.8831356,-87.6245115"},null,"150 Central Park West, New York, NY 10023"]
[null,"500 Beale Street, Memphis, TN 38103",{"$f":"Co_Ordinates(B10)","v":"35.1389488,-90.0450548"},null,"19141 Pine Ridge Circle, Anchorage, AK 99516"]
[null,"700 Main Street, Los Angeles, CA 90017",{"$f":"Co_Ordinates(B11)","v":"34.0955041,-118.1561391"},null,"300 North Michigan Avenue, Chicago, IL 60601"]
[null,"1600 Pennsylvania Avenue NW, Washington, D.C.",{"$f":"Co_Ordinates(B12)","v":"38.8976997,-77.0365532"},null,"500 Beale Street, Memphis, TN 38103"]
[null,"123 Sesame Street, New York, NY 10027",{"$f":"Co_Ordinates(B13)","v":"40.7709393,-73.9810759"},null,"700 Main Street, Los Angeles, CA 90017"]
[null,null,null,null,"1600 Pennsylvania Avenue NW, Washington, D.C."]
[null,null,null,null,"123 Sesame Street, New York, NY 10027"]