Hello, I think it depends a lot on what you want your sample to be. Should it be evenly distributed in terms of geographic area, in terms of population, etc.? Possible approaches may be: - Generate random GPS coordinates then use some reverse geocoding service (I think Google does it) - Use public open data, such as the areas covered by voting locations - Parse the Open Street Map database for a certain type of amenities I think it varies from country to country. In the UK, the Post Office database has all addresses and can be licensed, but I don't know about equivalents elsewhere. Regards, Raphael Velt PhD student, Mixed Reality Lab, University of Nottingham Sent from my Windows Phone ________________________________ From: Babiga Birregah<mailto:bbirregah@gmail.com> Sent: ‎29/‎04/‎2014 00:30 To: Lovaas,Steven<mailto:Steven.Lovaas@colostate.edu> Cc: air-l@listserv.aoir.org<mailto:air-l@listserv.aoir.org> Subject: Re: [Air-L] SOS: want to randomly fill address field in a spreadsheet thanks but my concerns is that: 1) how to pick a list of postal addresses corresponding to a given area or city (from a map) 2) and then randomly choose some of them to fill my excel column of addresses regards Babiga 2014-04-29 1:26 GMT+02:00 Lovaas,Steven <Steven.Lovaas@colostate.edu>:

I would number another column in your address list and then run your random-number generator against that.

Steve Lovaas

Sent from my iPhone

...

On Apr 28, 2014, at 5:11 PM, "Babiga Birregah" <bbirregah@gmail.com> wrote:

Dear all I am wondering if anyone knows how to fill randomly a spreadsheet with a list of address picked from a given area or region or city? thanks for your help

Regards, Babiga --

-- BIRREGAH Babiga, Phd Enseignant-Chercheur/ Assistant professor ICD UMR-CNRS 6279 STMR Sciences et Technologies pour la Maîtrise des Risques Joint Research Unit in Sciences and Technologies for Risk Management Department of Operational Research, Applied Statistics and Simulation UTT - ROSAS LM2S H107 12 Rue Marie Curie CS 42060 10004 TROYES CEDEX Tél. +33 (0) 325715869 Fax. +33 (0) 325715649 QR: http://goo.gl/Et0A4 _______________________________________________ The Air-L@listserv.aoir.org mailing list is provided by the Association of Internet Researchers http://aoir.org Subscribe, change options or unsubscribe at: http://listserv.aoir.org/listinfo.cgi/air-l-aoir.org

Join the Association of Internet Researchers: http://www.aoir.org/

-- -- BIRREGAH Babiga, Phd Enseignant-Chercheur/ Assistant professor ICD UMR-CNRS 6279 STMR Sciences et Technologies pour la Maîtrise des Risques Joint Research Unit in Sciences and Technologies for Risk Management Department of Operational Research, Applied Statistics and Simulation UTT - ROSAS LM2S H107 12 Rue Marie Curie CS 42060 10004 TROYES CEDEX Tél. +33 (0) 325715869 Fax. +33 (0) 325715649 QR: http://goo.gl/Et0A4 _______________________________________________ The Air-L@listserv.aoir.org mailing list is provided by the Association of Internet Researchers http://aoir.org Subscribe, change options or unsubscribe at: http://listserv.aoir.org/listinfo.cgi/air-l-aoir.org Join the Association of Internet Researchers: http://www.aoir.org/