En cours

Macro Expert for Excel Spreadsheet Data Collection

Macro Expert for Excel Spreadsheet Data Collection

You are bidding for a job to create a macro that will collect data from 3 different websites. All data collected will then be automatically input into the correct cells in the provided Excel spreadsheet. It is very important that the imported data be put into the correct cells very accurately. We will spot check data from different rows for accuracy. If macro is setup correctly all data should be 100% accurate.

We will not pay any money until the job is complete. Once the data is verified to be 100% accurate, funds will be released. We prefer a macro to manual input to eliminate errors. Once the Excel spreadsheet is complete, send it to us for verification. If errors are found, we will send the file back for corrections. If corrections are needed more than 2 times, we will not make payment and re-post the job.

Job must be completed within 2 days from the award date.

Please ask questions before you bid for the job. Job will be awarded within 48 hours.

We have attached a sample file with the first 5 records for your review. The actual file will contain 1500 records and will be sent to you when you are awarded the job.

Listed below are the directions as to how we obtained the data in the first row. Complete the first 5 rows so you can see what data we are collecting. This will help you create the macro for the data collection.

County Website

[url removed, login to view]%28ricomg452pcxgumcitaltjac%29/[url removed, login to view]

1. Cut and paste the “Property Address” in to spreadsheet. (Match destination formatting)

2. Cut and paste the “Market Value” for “Tax Year 2012” in to spreadsheet. (Match destination formatting)

3. Cut and paste the “Market Value” for “Tax Year 2008” in to spreadsheet. (Match destination formatting)

4. Cut and paste the “Tax Year” for “2011” in to spreadsheet. (Match destination formatting)

5. Cut and paste the “Tax Year” for “2011 Total Due” in to spreadsheet. (Match destination formatting)

6. Cut and paste the “Tax Year” for “2010Total Due” in to spreadsheet. (Match destination formatting)

7. Move to the next record.

Zillow Data Collection

Go to: [url removed, login to view]

1. In the find homes window enter the property address

2. Cut and paste the “Zestimate” in to spreadsheet. (Match destination formatting)

3. Cut and paste the “Rent Zestimate” in to spreadsheet. (Match destination formatting)

4. Cut and paste the “Beds” in to spreadsheet. (Match destination formatting)

5. Cut and paste the “Baths” in to spreadsheet. (Match destination formatting)

6. Cut and paste the “Sqft” in to spreadsheet. (Match destination formatting)

7. Cut and paste the “Lot” in to spreadsheet. (Match destination formatting)

8. Cut and paste the “Type” in to spreadsheet. (Match destination formatting)

9. Cut and paste the “Year Built” in to spreadsheet. (Match destination formatting)

10. Under “Tax History” cut and paste the “2011 Property Taxes” in to spreadsheet. (Match destination formatting)

11. Under “Tax History” cut and paste the “2010 Property Taxes” in to spreadsheet. (Match destination formatting)

12. Under “Tax History” cut and paste the “2009 Property Taxes” in to spreadsheet. (Match destination formatting)

13. Under “Property History” cut and paste the “Last Sold and Dollar Amount” in to spreadsheet. If not available put 3 dashes - - - (Match destination formatting)

14. Move to the next record.

County Assessments Look Up Link

Go to: [url removed, login to view]

1. Enter the property Number and Street

2. Check off: Parcel, Structure, Establishment

3. Click “Search”

4. Copy and paste the “Page URL” in to the spreadsheet. (Match destination formatting)

5. Move to the next record.

Compétences : Saisie de Données, Excel

Voir plus : excel macro collection, data collection macro excel, data collection macro, macro bid award excel, macro collect data excel, macro expert excel, data collection excel macro, macro collect data website, excel macro expert, data collect website macro, window street, record data structure, website establishment, tax websites, search data structure, job homes, index data structure, look job, land job, find job excel expert, create website find money, ask money, ask job, formatting websites, file excel expert

Concernant l'employeur :
( 1 commentaire ) El Monte, United States

N° du projet : #2394012

10 freelance ont fait une offre moyenne de 154 $ pour ce travail

ZeusMan

Looking forward to working with you....

250 $ USD en 2 jours
(48 Commentaires)
5.6
vbexcel

Web scraping pro - over ten years of experience.

249 $ USD en 2 jours
(25 Commentaires)
5.3
mrbrave

Hi...Please see PMB

220 $ USD en 2 jours
(64 Commentaires)
5.3
ViraCute

hi sir,please check my sample, thank's

75 $ USD en 2 jours
(21 Commentaires)
4.1
Star12

Ready to Go! I can work right away if you find me the right person for the job. I have good command with the Internet marketing, English language and can work with the project easily.

30 $ USD en 1 jour
(7 Commentaires)
4.0
mzahid32

Hi, I am willing to work with you on this project.

50 $ USD en 1 jour
(1 Commentaire)
1.0
hellokiran

I can do handle your project more efficiently and i will try my best to do perfect.Please send me the sample for review.

70 $ USD en 2 jours
(0 Commentaires)
0.0
Dataworkers6

I am ready to start work...

100 $ USD en 2 jours
(0 Commentaires)
0.0
mrxl

Experienced in web scrapping and processing data in Excel. Will be complete within 24 hours, with 100% accuracy.

199 $ USD en 1 jour
(0 Commentaires)
0.0
eobin

Hi, I was an employee of Deloitte before and I have quite a bit of experience in building Macros. Please do let me know if you are interested. Regards, Eobin

200 $ USD en 7 jours
(0 Commentaires)
0.0
ranjeetbtp25

================Let's Start ============. Regards, Lovely

200 $ USD en 5 jours
(1 Commentaire)
0.0