The task is to visit a website where all legal notices for approximately 100 Oregon newspapers are provided online
The publications are listed here:
Working from the database of the most recent year's notices, determine the following information about legal/public notices published in the State of Oregon for the past 12 Months (July 1 2015 - June 30 2016).
For EACH MONTH and for the 1 Year Period:
1) Total number of notices in that (month, year)
2) Top 50 public agencies posting, ranked by spending, in that (month, year)
3) Top 20 private posting sources ranked by spending.
4) Total cost of the notices in the period month, year.
5) Total cost to publish all notices published by public agencies in that (month, year)
6) Total cost to publish all notices from private sources in that (month, year)
7) Total spending to publish notices in that (month, year) in each of the following categories:
b) Storage Unit Sales
c) Estate Claims
d) Forfeited Property
e) Call for Bids
f) Notice to Interested Persons
g) Notice of Budget Hearings
h) Probates and Estates
The upload provide you with the newspapers rates from the attached rate card and column-widths sheet (public/legal notices are priced by the column-inch) so that you can determine the cost of each ad, based on your estimated number of words per column inch for each publications and then, working from the rate card and the column-widths card, determine the price that was charged to publish each of the legal/public notices (each appearance). When notices are published more than once, you must account for the additional costs of repeated appearances.
Your product should be one or more Excel-compatible spreadsheets that allow me to sort the data according to source (individual public agencies or "public agency" generally) and that allows the words-per-inch to be adjusted (and thus the cost figures to be automatically recomputed) and the data to be used to understand the world of legal notice publishing (who publishes, how much they spend, where do they publish, what kind of notices).
SEQUENCE OF PERFORMANCE: 50% after Step 1; 50% after rest of work:
STEP 1) Start with ONE month (August 2015) only, and work with me to refine the output for that one month as described above so that I can approve or adjust the work product. When the output for that month is delivered and approved, I will pay 50% of the negotiated fee.
STEP 2) Once the method is approved, repeat the task with the other 11 months (Sept 2015 - July 2016)
Skills: research, date extraction, data mining and management