
Excel data
- or -
Post a project like this2915
£200(approx. $271)
- Posted:
- Proposals: 29
- Remote
- #1855688
- Awarded
Data Scraping/ Mining/ Extraction, Data Entry, Researcher, Shopify, WordPress, Product Uploading, Excel Geek, Admin Support

DATA ENTRY,WEB SCRAPING, SHOPPING CART DATA ENTRY, ADMIN SUPPORT, DATA MINING ....
19879321762865173320019581821950973167042320827068369204962485635820281292049600
Description
Experience Level: Intermediate
I have a spreadsheet of articles, relating to contract wins. There are 1,600-odd rows at the moment.
At the moment, I have columns of
- Headline - contains the article headline
- Date - contains the article date
- Article - contains the article
I have further columns, which are empty. I need you to go through the article in Excel, and then fill in the other cells for each contract, with the relevant data
- Contractor - find the name of the contractor (e.g. Compass, or Caterlink). These MUST be standardised names, they can't be Compass Ltd, or Compass PLC)
- Client - the name of the client, or customer (e.g. Barclays, or Kingston upon Hull City Council)
- Client Contact - if it exists, the name of the contact for the client (Nick Webb, Head of Office Enablement)
- Value £m - if it exists, the value in £m of the contract
- Years - if it exists, the number of years that the contract runs for
- Value/Year £m - ignore this, this is a calcuation.
- Renewal Date - ignore this, this is a calculation
- Services - the services being provided by the contractor. I need to standardise the services as much as possible, so I will provide you with a list of them.
- Sector - the sector in which the client is, for example, government, or leisure, or education.
At the moment, I have columns of
- Headline - contains the article headline
- Date - contains the article date
- Article - contains the article
I have further columns, which are empty. I need you to go through the article in Excel, and then fill in the other cells for each contract, with the relevant data
- Contractor - find the name of the contractor (e.g. Compass, or Caterlink). These MUST be standardised names, they can't be Compass Ltd, or Compass PLC)
- Client - the name of the client, or customer (e.g. Barclays, or Kingston upon Hull City Council)
- Client Contact - if it exists, the name of the contact for the client (Nick Webb, Head of Office Enablement)
- Value £m - if it exists, the value in £m of the contract
- Years - if it exists, the number of years that the contract runs for
- Value/Year £m - ignore this, this is a calcuation.
- Renewal Date - ignore this, this is a calculation
- Services - the services being provided by the contractor. I need to standardise the services as much as possible, so I will provide you with a list of them.
- Sector - the sector in which the client is, for example, government, or leisure, or education.
Paul C.
100% (5)Projects Completed
6
Freelancers worked with
5
Projects awarded
33%
Last project
4 Mar 2019
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hi. What is the deadline for completing this job please?
571463
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