Reconcile data sources (various xls/doc files) - dirty data - 850 records - URGENT
- or -
Post a project like this2782
$$$
- Posted:
- Proposals: 4
- Remote
- #1249158
- Awarded
Description
Experience Level: Expert
Estimated project duration: less than 1 week
URGENT!
We are a language school based in the UK. We have two centres: Abergele and Chester. We welcome groups of international students. Each unit of business is a group: they usually stay with us for one or two weeks and we organize language courses and work experiences. Our programmes are part of their secondary schools programmes. Our contracts are set up with their secondary schools or agents.
Your proposal will be selected on Wed 17th August before 11.00 am GMT when you will immediately receive the full final material. Your work must BY ALL MEANS be delivered and fully finalized BEFORE Mon 22nd August 6.00 am GMT or ASAP. NO DELAY CAN BE ACCEPTED, and it is critical to deliver all the work BEFORE Mon 22nd August 6.00 am GMT.
Please, do not apply if you can’t commit to the timing of this project.
The job is split into 3 parts: 2014-2016 where we have more structured information and you need to cross-index information and do some textual research in the corresponding files, 2009-2013 where information is unstructured and there is high level of manual textual research to do into word documents; 2016-2017 potential work where we have no invoice job but a few records to transfer information from one file by comparing with the results of the first two parts.
The output must be in the format “Output format.xls”
Full final material files (full details available on Wed 17th Aug):
*2014-2016 part (400 records):
Outgoing invoices xls file – Invoices sheet (index file for 400 valid records providing the key for the sales file)
Sales file – Data entry sheet (index file to extract some information based on the Key of the Outgoing file)
Outgoing invoices (400 files) – this contains the heading and address to be parsed
Booking forms (190 files) – this contact contact details to be parsed
*2009-2013 part (400 records):
Outgoing invoices (400 files)
Each invoice need to be searched and details need to be found manually. Please, find the maximum level of details. Information might sometimes be in Italian.
*2016-2017 potential work (48 records)
Sales file and results of the parts above
Please, send me a sample of the first two parts based on the attachments and the detailed job description you can find attached – in advance of the selection of your proposal.
Your proposal will be selected on Wed 17th August before 11.00 am GMT when you will immediately receive the full final material. Your work must BY ALL MEANS be delivered and fully finalized BEFORE Mon 22nd August 6.00 am GMT or ASAP. NO DELAY CAN BE ACCEPTED, and it is critical to deliver all the work BEFORE Mon 22nd August 6.00 am GMT.
We are a language school based in the UK. We have two centres: Abergele and Chester. We welcome groups of international students. Each unit of business is a group: they usually stay with us for one or two weeks and we organize language courses and work experiences. Our programmes are part of their secondary schools programmes. Our contracts are set up with their secondary schools or agents.
Your proposal will be selected on Wed 17th August before 11.00 am GMT when you will immediately receive the full final material. Your work must BY ALL MEANS be delivered and fully finalized BEFORE Mon 22nd August 6.00 am GMT or ASAP. NO DELAY CAN BE ACCEPTED, and it is critical to deliver all the work BEFORE Mon 22nd August 6.00 am GMT.
Please, do not apply if you can’t commit to the timing of this project.
The job is split into 3 parts: 2014-2016 where we have more structured information and you need to cross-index information and do some textual research in the corresponding files, 2009-2013 where information is unstructured and there is high level of manual textual research to do into word documents; 2016-2017 potential work where we have no invoice job but a few records to transfer information from one file by comparing with the results of the first two parts.
The output must be in the format “Output format.xls”
Full final material files (full details available on Wed 17th Aug):
*2014-2016 part (400 records):
Outgoing invoices xls file – Invoices sheet (index file for 400 valid records providing the key for the sales file)
Sales file – Data entry sheet (index file to extract some information based on the Key of the Outgoing file)
Outgoing invoices (400 files) – this contains the heading and address to be parsed
Booking forms (190 files) – this contact contact details to be parsed
*2009-2013 part (400 records):
Outgoing invoices (400 files)
Each invoice need to be searched and details need to be found manually. Please, find the maximum level of details. Information might sometimes be in Italian.
*2016-2017 potential work (48 records)
Sales file and results of the parts above
Please, send me a sample of the first two parts based on the attachments and the detailed job description you can find attached – in advance of the selection of your proposal.
Your proposal will be selected on Wed 17th August before 11.00 am GMT when you will immediately receive the full final material. Your work must BY ALL MEANS be delivered and fully finalized BEFORE Mon 22nd August 6.00 am GMT or ASAP. NO DELAY CAN BE ACCEPTED, and it is critical to deliver all the work BEFORE Mon 22nd August 6.00 am GMT.
Francesco C.
99% (70)Projects Completed
70
Freelancers worked with
22
Projects awarded
62%
Last project
26 Jan 2024
Italy
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies