Internet search for public reports and data entry from PDF's to Excel spreadsheets (3 of 4)

IN PROGRESS
Bids
29
Avg Bid (AUD)
$819
Project Budget (AUD)
$750 - $1500

Project Description:
Request for tender – Internet search for public reports and data entry from PDF’s to Excel spreadsheets

Summary of requirements

Estimated hours: 120 hours
Time of delivery: 3 weeks from notification of successful tender
Tasks required:
• Locate public PDF reports for selected companies
• Transfer data from PDF’s into a single Excel spreadsheet (template attached)

Details of requirements

We require the successful tenderer to locate public PDF reports for selected companies (list of companies will be provided upon notification of successful tender). Successful tenderer will have to transfer data from simple tables within these reports into a single Excel spreadsheet template (sample of report and Excel spreadsheet attached).

There will be approximately 200 reports covering about 70-90 companies (companies have one or more reports corresponding to different reporting years). Reports may be of varying lengths, with an average of 3 tables in each report. We will provide the list of companies and a website which is linked to some (but not all) the reports. For reports which are not directly linked from the website we provide, some work will be required to locate these PDF reports online. We would also require saved copies of all PDF reports, to be delivered either via CD or an online file sharing facility (e.g. Dropbox etc).

We estimate this job will take approximately 120 hours.

Data points, as they appear in existing reports, are:
• “Reporting corporation” to be entered in all tabs
• “Total energy use covered by all assessments in this report” to be entered in Aggregated data tab
• “Total energy assessed as percentage of total energy use of the corporate group” to be entered in Aggregated data tab
• “Total energy use in the last financial year” for each reporting entity to be entered in Energy use tab
• “Estimated energy savings by payback period” for each reporting entity to be entered in Detailed data tab
• Associated information with energy savings, e.g. “No. of opportunities”, “Payback range”, “Year or report” and “Reporting entity” to be entered in Detailed data tab

Quotations are required by AEST 1pm Monday, 13 August 2012. A decision will be made by AEST 5pm Monday, 13 August 2012. Work should commence as soon as possible after notification of successful tender.

In order to ensure timely feedback is provided before you proceed, we require the first company (i.e. all reports for 1 company) to be completed within 24 hours of notification of successful tender.

Milestone payments will be made over the course of 3 weeks upon delivery of filled Excel spreadshets, as per the following schedule:
• Week 1: 20 companies completed
• Week 2: 30 companies completed
• Week 3: Remaining companies completed

Please note that there will be a 25% payment deduction for every week of delay in milestone deliveries.

Selection will be made based on the following key criteria:
1. Price
2. Relevance of previous experience and quality/satisfaction of previous tenderers
3. Use of ethical standards in completing work (for example, but not limited to, no use of labour under the age of 15 for this project).

An applicant should address all three criteria, although only a short submission is required.

Quality checks will be conducted prior to release of payment.

Skills required:
Data Entry, Excel, Web Scraping, Web Search
Additional Files: Report+samples_20120810+v2.pdf
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 900
in 21 days
$ 750
in 18 days
$ 750
in 21 days
Hire ePelicano
$ 750
in 21 days
$ 750
in 21 days
$ 750
in 5 days
Hire Engineer85
$ 750
in 21 days
Hire hubriscorp
$ 950
in 21 days
Hire thegoodmeanings
$ 750
in 21 days
Hire onlineiftikhar
$ 750
in 21 days