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
• 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:
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.