{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Intro + Configuracion","Addresses"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":10,"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":"Intro + Configuracion","index":0,"n_rows":29,"n_cols":8,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"This macro is for obtain GPS coordinates from an Address"]
[null,null,"Google has the limit of 2000 diary addresses"]
[]
[null,null,"You must to activate a VBA module",null,null,"Position Type"]
[null,null,"     Using the Visual Basic console (Alt + F11)"]
[null,null,"     Tools -> References, ",null,null,null,"ROOFTOP"]
[null,null,"     Select Microsoft XML, 3.0",null,null,null,null,"The result is a geographic code with the exact place of the address"]
[]
[null,null,null,null,null,null,"RANGE_INTERPOLATED"]
[null,null,null,null,null,null,null,"The result is an aproximation interpolated between two precise points"]
[null,null,null,null,null,null,null,"intersection of streets for example."]
[]
[null,null,"Column Name","Position",null,null,"GEOMETRIC_CENTER"]
[null,null,"Id",1,null,null,null,"This result is the geometric center of a region or street"]
[null,null,"Lat",2]
[null,null,"Long",3,null,null,"APPROXIMATE"]
[null,null,"Position Type",4,null,null,null,"As the name says, is something aproximate"]
[null,null,"Address",5]
[null,null,"State",6,null,"How to use"]
[null,null,"Province",7]
[null,null,"Town",8,null,null,"You can configure the position of the columns of the Adresses page"]
[null,null,"Postal Code",9,null,null,"The result of this macro is in the columns:"]
[null,null,"Type of street",10,null,null,null,"Lat"]
[null,null,"Address",11,null,null,null,"Long"]
[null,null,"Number",12,null,null,null,"Position Type"]
[null,null,null,null,null,null,null,"Address"]
[null,null,"Waiting time",3,null,null,"Id is a mandatory column to check if the macro has to process the row"]

{"sheet":"Addresses","index":1,"n_rows":3,"n_cols":12,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["ID","Lat","Long","Position Type","Address","State","Province","Town","Postal Code","Type of street","Address","Number"]
[1,null,null,null,null,"Madrid","Madrid","UCEDA","19187","Calle","MAYOR",18]
[2,null,null,null,null,"Madrid","Madrid","TORREJON DE ARDOZ","28850","Avenida","CONSTITUCION",167]