
Job categorisation model / database in Excel
- or -
Post a project like this1591
£255(approx. $344)
- Posted:
- Proposals: 5
- Remote
- #3128048
- OPPORTUNITY
- Awarded
Description
Experience Level: Intermediate
I need someone who is very good at excel in terms of 1) formula development 2) explanation of how the excel has been developed 3) high quality presentation to build me an excel model.
I have a set of tasks that someone in any role in an organisation would do and I have ranked each task to determine the likely workplace setting for this task based upon one of 4 work settings. So "Learning from others" has a ranking of 4) - Flexible (more office based) through to 1) Home based. There are 22 work tasks in total.
I now need to develop a model which takes one role at a time (4,500 in total) and determines which setting the specific role will be in. So I would like to have a Data base which does the following
Roles:
- A form which I can input data into and once complete, I can hit a button, it clears and I can input new data
- A cell to input the role title
- A cell to input directorate
- A cell to input line manager
- Area to input the role location
- List all tasks and provide a column to rank them from 1-22 in terms of importance of the task to that role
- A column next to each task and ranking that allows me to enter a "Low" "Medium" or "High" frequency by which tasks is undertaken.
The model then determines, from all the information provided in this form, plus the overall categorisation / ranking of the tasks on the previous page, which one of 4 categories this role falls into.
The form, when you hit a button will clear, all the data from this form will go onto another page and I can then enter another job role. I want to be able to go to the data page and delete a line if I need to start that one again
I would also like an analysis page from the data provided which I can use as a report format giving me key to executive level stakeholders. Information such as categories and locations of these categories (based upon the persons job role) break down of the categories by directorate. The programme is called "Workforce Categorisation" which should be displayed on the report along with my name and the date.
I want this to be smart and professional, it needs a cover page, really good, clear and concise analysis and, importantly, I must be able to (If people wish to see it cut another way) be able to change the overall ranking of tasks across roles if required and that then feed through to all of the data. (The page I have included in the excel and summarised above)
Looking for a quick turn around please. I have provided a summary excel page of the tasks
I have a set of tasks that someone in any role in an organisation would do and I have ranked each task to determine the likely workplace setting for this task based upon one of 4 work settings. So "Learning from others" has a ranking of 4) - Flexible (more office based) through to 1) Home based. There are 22 work tasks in total.
I now need to develop a model which takes one role at a time (4,500 in total) and determines which setting the specific role will be in. So I would like to have a Data base which does the following
Roles:
- A form which I can input data into and once complete, I can hit a button, it clears and I can input new data
- A cell to input the role title
- A cell to input directorate
- A cell to input line manager
- Area to input the role location
- List all tasks and provide a column to rank them from 1-22 in terms of importance of the task to that role
- A column next to each task and ranking that allows me to enter a "Low" "Medium" or "High" frequency by which tasks is undertaken.
The model then determines, from all the information provided in this form, plus the overall categorisation / ranking of the tasks on the previous page, which one of 4 categories this role falls into.
The form, when you hit a button will clear, all the data from this form will go onto another page and I can then enter another job role. I want to be able to go to the data page and delete a line if I need to start that one again
I would also like an analysis page from the data provided which I can use as a report format giving me key to executive level stakeholders. Information such as categories and locations of these categories (based upon the persons job role) break down of the categories by directorate. The programme is called "Workforce Categorisation" which should be displayed on the report along with my name and the date.
I want this to be smart and professional, it needs a cover page, really good, clear and concise analysis and, importantly, I must be able to (If people wish to see it cut another way) be able to change the overall ranking of tasks across roles if required and that then feed through to all of the data. (The page I have included in the excel and summarised above)
Looking for a quick turn around please. I have provided a summary excel page of the tasks
Neil M.
100% (9)Projects Completed
6
Freelancers worked with
6
Projects awarded
75%
Last project
3 Aug 2021
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