Closed

Web Scraping Excel a public web site I would like to scrape. - repost

This project received 24 bids from talented freelancers with an average bid price of $136 USD.

Get free quotes for a project like this
Employer working
Skills Required
Project Budget
$30 - $250 USD
Total Bids
24
Project Description

I have a few public web sites I would like to scrape. All the websites are the same design from the same company. Sample below

[url removed, login to view]

I have a spreadsheet that will have three columns that are "block, Lot, Qual" These need to be entered into the website and the retrieved information has two pieces of information that needs to be scraped. This needs to be done for each line in the Input spreadsheet.

OVERVIEW

There should be just one program written. Each website will be identical. I need to be able to change the target website and change the input Spreadsheet.

1 Sample Website to scrape (all will be the same format)
[url removed, login to view]
2 Need to use the SS below (INPUT SS) take these three entries and input into the website above. (Qual may be blank many times, but if you input the first two numbers and hit enter through the QUAL you get to the information.)

INPUT Spreadsheet

Block Lot Qual
1 1
2 1


3 After you enter the data from the input SS and retrieve the information page, I need the last payment date and the status. if ANY status on any column has the word “open” you need to mark the status as open, if not and you only see paid, then mark paid, if no entries leave blank.


RESULTING INFORMATION NEEDED
OUTPUT Spreadsheet This is the deliverable!

Block Lot Qual Last Payment Status
1 1 05/06/2013 Paid
2 1 05/06/2013 Paid

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online