Create Excel Database by manual searching

Ολοκληρωμένο Αναρτήθηκε Dec 7, 2011 Πληρώθηκε κατά την παράδοση
Ολοκληρωμένο Πληρώθηκε κατά την παράδοση

Create 2 'Master' Excel files by searching and downloading Excel files from a website. This will not take more than 3-4 hours at the VERY most

The winning bid will have this COMPLETED in 1 day

Here are the steps:

• Goto [login to view URL]://[login to view URL]

• Login with

o Library Card Number = 042647880

o PIN = 1871

(I) From Available Databases, Click "US Businesses / Employers USA - 14 million businesses - Search". For the database “US Businesses / Employers USA”, there will be 12,973 total results to download and combine into 1 Excel file, 25 records at a time, which is 520 file downloads using the following steps 1-4:

(1) Create Search Criteria:

a. Select Custom Search

b. Click "Business Type" from left-side navigation

- Select Checkbox for "Major industry group"

- select "+" to expand "Retail Trade (52-59)" (NOTE - do not check the box)

- select "+" to expand "58 Eating and Drinking Places" (NOTE - do not check the box)

- Check the box for "5812-Eating Places"

c. Click "GeoGraphy" from left-side navigation

- Select Checkbox for "Metro Area"

- From Metro Area menu at the bottom of the page:

- Select Iowa from the drop-down for State

1. Select "Des Moines-West Des Moines "

- Select Nebraska from the drop-down for State

1. Select "Omaha-Council Bluffs"

2. Select "Lincoln"

- Select Kansas from the drop-down for State

1. Select "Kansas City, MO-KS"

2. Select “St Louis, MO-IL”

d. Click Green link "VIEW RESULTS "

(2) Download Results - Save the results into an Excel file:

a. Select checkbox to left of ‘Company Name’, so that all 25 records are selected

b. Click "Download"

c. Select "Excel"

d. Select "Detailed"

e. Click “DOWNLOAD RECORDS”

f. Save XLS file

(3) Continue with the Download Results process – combine all results into 1 Excel file:

a. Click "Back"

b. UNSELECT ALL RECORDS – De-Select checkbox to left of ‘Company Name’, so that all 25 records are unselected

c. Goto the NEXT page (click the Right arrow once)

d. Select checkbox to left of ‘Company Name’, so that all 25 records are selected

e. Click "Download"

f. Select "Excel"

g. Select "Detailed"

h. Click “DOWNLOAD RECORDS”

i. Combine these 25 results into 1 XLS file

(4) CONTINUE thru Page 251, UNTIL ALL 6260 records are downloaded

(II)

Click Home or go back to this URL [login to view URL]

• From Available Databases, Click "US New Businesses - 4 million businesses - Search". For the database “US New Businesses”, there will be 1844 total results to download and combine into 1 Excel file, 25 records at a time, which is 74 file downloads using the SAME ABOVE steps 1-4

Εισαγωγή Δεδομένων Excel Web Scraping Διαδικτυακή Αναζήτηση

Ταυτότητα Εργασίας: #1330031

Σχετικά με την εργασία

11 προτάσεις Απομακρυσμένη εργασία Ενεργό Dec 7, 2011

Ανατέθηκε στον:

sheenakakkar

Hi, I am ready to start immediately.. Please check PMB.. Regards Sheena

$30 USD σε 1 μέρα
(14 Αξιολογήσεις)
5.6

11 freelancers κάνουν προσφορές κατά μέσο όρο $35 για αυτή τη δουλειά

abdussamad

Please check pm

$30 USD σε 1 μέρα
(41 Αξιολογήσεις)
5.9
ExactSystems

Please see detail on PMB regards

$50 USD σε 1 μέρα
(3 Αξιολογήσεις)
4.5
abdunnoor99

Expert is here. View PM for details.

$30 USD σε 1 μέρα
(13 Αξιολογήσεις)
3.9
Engineer85

Hi, I am interested in doing this project. Have tried your given steps and can complete the work in next 4 hours. Thanks.

$50 USD σε 1 μέρα
(12 Αξιολογήσεις)
4.4
aliasneo38

READY TO ROLL OUT RIGHT AWAY.

$30 USD σε 1 μέρα
(5 Αξιολογήσεις)
2.9
Sushantind

Dear Sir, We are ready to start the work. Check your personal message.

$40 USD σε 1 μέρα
(3 Αξιολογήσεις)
2.1
mondalali100

I can do it very well. Please inform me. Thank you

$30 USD σε 1 μέρα
(0 Αξιολογήσεις)
0.0
yellowman57

Hello sir, i want to work with you. if you give me the opportunity, i assure you i will complete my job within one day. commitment and honesty are my investment.

$40 USD σε 1 μέρα
(0 Αξιολογήσεις)
0.0
Careuwell

Hello sir, Ready to work. I just refer all the steps. Please check pm

$30 USD σε 1 μέρα
(0 Αξιολογήσεις)
0.0
delwar018

Dear Sir Thank you for posting this nice job. I understand your information fairly. To justify my work quality I attached a file as a sample according to your information. Please see that. I will delivery my work on Περισσότερα

$30 USD σε 1 μέρα
(0 Αξιολογήσεις)
0.0