Excel data
- or -
Post a project like this2281
£200(approx. $251)
- Posted:
- Proposals: 30
- Remote
- #1855688
- Awarded
Editor and Travel writer - British/American English, fiction/non-fiction; Public speaking coach and presentation designer.
Protaras
Data entry, 3d character modeling, 3d animation, Graphics design,Web design and development,wordpress
Dhaka
198793219929361799344186060918720171908869195097319581822050614204962420496002050738
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