Company research for 17 companies and build spreadsheet
2225
$$$
- Posted:
- Proposals: 0
- Remote
- #1921984
- Archived
Description
Experience Level: Expert
I have a research job to include creating a spreadsheet to manage details about some Companies on separate tabs per company.
I would like each page to look like a form – probably grey form, with white input areas?
The requirements are listed below, please let me know if you have any questions?
What I need from you is;
1 - When can you start
2 - When can you deliver the work (sooner the better)
3 - How much you will charge
First Job is to agree the format of the spreadsheet (front page and company template)
Second task is to populate spreadsheet with details from the companies below.
Thanks
Ken
Company research spreadsheet requirements
First Tab page of the spreadsheet should be a contents page listing each company and each company should be a hyper link to the company tab.
First Tab title – Ken Sayer - 2018 Territory
Details to be collected for each company tab are. -
Company Legal name
Brief description of company
UK HQ address
Switchboard number
Link to Main Website
Main business Units or Divisions, with revenue and links to specific websites
Annual revenue for 3 years - 2015, 2016, 2017
Number of employees
Link to Annual reports page
Link to board of director’s page
Link to management team page
List top 5 competitors, with links to their websites
Hyper link to news about the company (example to open google with the search - news "royal mail")
Key contacts section – table to be left blank so I can populate. Column titles should be
Name
Job title
Email
Mobile number
Landline number
notes section
Products section – table to be left blank so I can populate with details of the products they have purchased. Column titles should be
Division/Business Unit
Product bought
Date signed
Cloud or on premise
Link to contract
Documents section– Table to link to documents, columns should be
Description
Link to document
Business Development – table to be left blank so I can populate. There should be two rows, the first with the row titles below, the second, where I can type notes
ADM
Big Data
BW
BW/4 HANA
Celonis
Data Hub
Data Services
Data Tiering
ECC
GDPR
Hana Ent
HANA RT
ILM
Information Steward
IOT
IQ
MDM
OT Archiving
OT Doc Access
PI/PO
S4
SAP Cloud Platform
SCP other
VIM
XECM
Companies to be included in the spreadsheet -
AMEY
BABCOCK (VT Group)
BAE SYSTEMS (AI, land, air, sea etc)
Balfour Beatty Plc
GKN
Inchcape PLC (automotive not shipping)
Jaguar Land Rover
JC Bamford Excavators Ltd
Laing O'Rourke Plc
Lookers Plc
Post Office
Royal Mail Group
Smiths Group Plc (Detection, john crane etc)
Spectris Plc (main 12 or 14 only)
Thales
Unipart
Volkswagon (Bentley, Porsche etc)
Wates Group Ltd.
I would like each page to look like a form – probably grey form, with white input areas?
The requirements are listed below, please let me know if you have any questions?
What I need from you is;
1 - When can you start
2 - When can you deliver the work (sooner the better)
3 - How much you will charge
First Job is to agree the format of the spreadsheet (front page and company template)
Second task is to populate spreadsheet with details from the companies below.
Thanks
Ken
Company research spreadsheet requirements
First Tab page of the spreadsheet should be a contents page listing each company and each company should be a hyper link to the company tab.
First Tab title – Ken Sayer - 2018 Territory
Details to be collected for each company tab are. -
Company Legal name
Brief description of company
UK HQ address
Switchboard number
Link to Main Website
Main business Units or Divisions, with revenue and links to specific websites
Annual revenue for 3 years - 2015, 2016, 2017
Number of employees
Link to Annual reports page
Link to board of director’s page
Link to management team page
List top 5 competitors, with links to their websites
Hyper link to news about the company (example to open google with the search - news "royal mail")
Key contacts section – table to be left blank so I can populate. Column titles should be
Name
Job title
Mobile number
Landline number
notes section
Products section – table to be left blank so I can populate with details of the products they have purchased. Column titles should be
Division/Business Unit
Product bought
Date signed
Cloud or on premise
Link to contract
Documents section– Table to link to documents, columns should be
Description
Link to document
Business Development – table to be left blank so I can populate. There should be two rows, the first with the row titles below, the second, where I can type notes
ADM
Big Data
BW
BW/4 HANA
Celonis
Data Hub
Data Services
Data Tiering
ECC
GDPR
Hana Ent
HANA RT
ILM
Information Steward
IOT
IQ
MDM
OT Archiving
OT Doc Access
PI/PO
S4
SAP Cloud Platform
SCP other
VIM
XECM
Companies to be included in the spreadsheet -
AMEY
BABCOCK (VT Group)
BAE SYSTEMS (AI, land, air, sea etc)
Balfour Beatty Plc
GKN
Inchcape PLC (automotive not shipping)
Jaguar Land Rover
JC Bamford Excavators Ltd
Laing O'Rourke Plc
Lookers Plc
Post Office
Royal Mail Group
Smiths Group Plc (Detection, john crane etc)
Spectris Plc (main 12 or 14 only)
Thales
Unipart
Volkswagon (Bentley, Porsche etc)
Wates Group Ltd.
Projects Completed
176
Freelancers worked with
132
Projects awarded
28%
Last project
5 May 2024
United Kingdom
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