Find freelancers. Lose those costly delays.

With 1.7 million freelancers, we'll match you with the perfect talent.

or, Register with Elance »

Excel Macro With Geocoding
Sign in to Add to Watch List

IT & Programming > Other IT & Programming

View Change History

The client has made the following changes to the job.


Job Description

  |  Change History >>


  • Posted: Mon, Jun 11, 2012
  • Time Left: Closed
  • Location: Anywhere
  • Client prefers freelancers from:

    You are still able to submit a proposal for this job.

    The client prefers freelancers from
    a different location.

    You're still able to submit a proposal for this job, regardless of your location.
  • Start: Immediately
  • Budget: Less than $500
  • Fixed Price Job
  • Elance Escrow Protection
  • U.S. freelancers must have W9
Sign in to view client's details

We have a mailing list of around 300K people – this is in CSV format and contains the geo-coding for each address (lat / long) – call this the "original list". We have another list of say 25 homes – there is no geo-coding in this list – this list contains a column "how many homes needed" – call this the "trigger list". We need to generate a new list of the nearest x homes around each of the say 25 homes (in the trigger list) from within the "original list" – this output list should contain the same layout and columns as in the "original list". So maybe something like – drop into a folder "orginal_list" that CSV file – drop into a folder "trigger_list" that CSV file – run the macro – geo-code the trigger list – place into the folder "output_list" the final CSV file which contains the mailing list of the nearest homes to those within the trigger list (say 100 nearest homes to address a and the nearest 250 homes to address b etc. etc).

Sign in or Register to see more

Job ID: 31152949
Avg $ | High $ | Low $ — Show Pricing
  • Submit Date (Latest)

I have more then 10 years of experience in both functional and automation testing. Worked with elite clients like Essentia, Citi, Sella synergy,...
 0.0   |  Private   |  1 Jobs
Bid ID: 31272516  |  Submitted: Jun 16, 2012 02:52 ET 
Proposal SEALED

 India  |  
Successfully finished over 400 Microsoft Access Database projects and 50+ .net projects. Microsoft Access 2003 , Microsoft Access 2007 , Microsoft...
 4.5   |  Private   |  3 Jobs
Bid ID: 31207367  |  Submitted: Jun 13, 2012 10:13 ET 
Proposal SEALED

Eyad El-Haj Salem      
Eyad El-Haj Salem's identity has been verified.  Learn More
 Palestine  |  
I am VB, VBA, C#, WPF, XAML, CAD and GIS developer. I developed large number of desktop applications in addition to web sites and scripts. I...
 4.8   |  $2,355 Earnings   |  6 Jobs   |  2 verified credential(s)
Bid ID: 31190330  |  Submitted: Jun 12, 2012 17:59 ET 
Proposal SEALED

 India  |  
I have been doing software development and Support since year 2000, I am a fulltime Freelance programmer looking for Jobs in Elance to build...
 0.0   |  Private   |  0 Jobs
Bid ID: 31165494  |  Submitted: Jun 11, 2012 22:44 ET 
Proposal SEALED

 Egypt  |  
Feel free to contact me regarding any help about MS Excel. I have a very good overall knowledge of Excel, and can assist on most matters. I worked...
 0.0   |  Private   |  0 Jobs
Bid ID: 31156766  |  Submitted: Jun 11, 2012 14:06 ET 
Proposal SEALED

 Sri Lanka  |  
I am a hard worker have the capacity to finish the work very successfully I will try my best to do every work that i get on time
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 31156206  |  Submitted: Jun 11, 2012 13:45 ET 
Proposal SEALED

 Pakistan  |  
Top 5% in MS Access skills test, A postgraduate in Computer Science and Software Engineering PGD holder , possessing over 7 years of experience in...
 5.0   |  Private   |  9 Jobs
Bid ID: 31153242  |  Submitted: Jun 11, 2012 11:52 ET 
Proposal SEALED
Sign in to Elance and start working on jobs today.
Sign in to view more of the job details and submit a proposal. Once registered, you'll have access to thousands of jobs online or through email.
Are you ready to post a job like this one?
Post a Similar Job »