{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["distance","Config"],"not_rendered":{"charts":0,"images":7,"macros":1,"external_links":0,"defined_names":24,"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":"distance","index":0,"n_rows":24,"n_cols":24,"rows_kept":24,"cut":false,"hidden":false,"merged":[[23,12,24,14],[23,2,24,3],[23,4,24,11],[3,2,3,4],[6,2,6,4],[13,5,13,6],[15,5,15,6]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Read more Excel tutorials",null,null,null,null,"http://www.learnexcelmacro.com/wp/excel-macro-tutorial/"]
[]
[null,null,null,null,null,null,null,null,null,null,"Amsterdam",null,null,null,null,null,null,null,"Subscribe to LearnExcelmacro and get a FREE E-Book",null,null,null,null,"http://feedburner.google.com/fb/a/mailverify?uri=learnexcelmacro/ZhAB"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Download more interesting tools and Templates (FREE)",null,null,null,null,"http://www.learnexcelmacro.com/wp/download/"]
[null,null,null,null,null,null,null,null,null,null,"Utrecht"]
[]
[null,null,null,null,"Driving"]
[]
[]
[]
[]
[null,null,null,null,null,0,null,"M",null,null,0,"Min"]
[]
[null,null,null,null,null,{"$f":"distance/1000","v":0},null,"KM",null,null,{"$f":"duration/60","v":0},"Hrs."]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"IF(SourceCity=\"\",\"\",SourceCity)","v":"Amsterdam"},null,null,null,null,null,null,null,null,null,{"$f":"IF(TargetCity=\"\",\"\",TargetCity)","v":"Utrecht"}]

{"sheet":"Config","index":1,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,null,"Base","https://maps.googleapis.com/maps/api/distancematrix/xml?origins="]
[null,null,null,"Source",{"$f":"SourceHouseNumber &\"+\" &SourceStreetName & \"+\" & SourceCity & \"+\" & SourcePostalCode & \"+\" & SourceState & \"+\" &Sourcecountry","v":"++Amsterdam+++"}]
[null,null,null,"Destinations",{"$f":"TargetHouseNumber &\"+\" &TargetStreetName & \"+\" & TargetCity & \"+\" & TargetPostalCode & \"+\" & TargetState & \"+\" &TargetCountry","v":"++Utrecht+++"}]
[null,null,null,"Mode",{"$f":"LOWER(SelectedMode)","v":"driving"}]
[null,null,null,"URL",{"$f":"SUBSTITUTE(E4&E5&\"&destinations=\" &E6 & \"&mode=\" & mode &\"&key=\" &apiKey,\" \",\"%\")","v":"https://maps.googleapis.com/maps/api/distancematrix/xml?origins=++Amsterdam+++&destinations=++Utrecht+++&mode=driving&key=<YOUR_API_KEY>"}]
[null,null,null,"apiKey","<YOUR_API_KEY>"]
[]
[]
[]
[null,null,null,null,null,"Transport Mode"]
[null,null,null,null,null,"Bicycling"]
[null,null,null,null,null,"Driving"]
[null,null,null,null,null,"Walking"]
[null,null,null,null,null,"Transit"]