I need a work plan done in excel
- or -
Post a project like this1860
$100
- Posted:
- Proposals: 6
- Remote
- #2312110
- Awarded
Virtual Assistant | Web Research Specialist | Excel | Fillable / Editable PDF |Data Mining Specialist |Data Extraction | & Project Coordinator
Cairo
243369713718271711586178829023454602471024
Description
Experience Level: Expert
Dear all
I need Bi-Weekly work plan (in Excel) with some special functionality.
Functionality 1:
Every day 100 digits (from 00 – 99) must be distributed. This needs to happen for each weekday.
- A crosscheck would be needed (each day – light up green when all digits are distributed)
The number distribution consists of
a) Fixed digits (in red) and
b) of daily deputy digits (shown on each weekday)
Functionality 2:
As not every clerk works full time, the number of digits is not evenly distributed.
The number of digits per clerk should be displayed and adjustable in a separate tab. A "target" function with warning would be needed.
Example:
If the maximum of 7 digits (this is the TARGET function) is reached by one clerk, this should be visible. But if one clerk is sick he can get a total of 8 (1 more than the TARGET). This should technically be possible, but with must be shown with a warning (e.g. change of color).
There are clerks who represent each permanently. Therefore, it should be possible to define which clerks deputize each other so the digits are distributed all on the day a clerk is not available.
Example:
Whenever Clerk 3 (ded) is gone, its digits are automatically given to clerk 10 (kha) and vice versa.
There should be 3 different types of OFF Days: “school”, “holidays”, “sickness” and “training”
As the distribution happens every day, it should be noted that clerks (if possible) can keep the numbers from the day before and do not every day get After the distribution each clerk should keep the numbers (from the day(s) before) to be substituted (if possible) and does not change it daily.
Pia on purpose has no numbers, she is still in training.
My example is what we currently have in place (at lease the bi-weekly version of it - it would be great if the calendar would be ongoing - e.g. where weeks/days can be entered). If you have questions please do not hesitate to contact me.
What you need:
- Good Excel Knowledge (not super)
- Very Good analytical skills (to understand what we need)
- Minor design skills (so the excel does not look bad)
I will decline any general proposals.
And please ask questions.
I need Bi-Weekly work plan (in Excel) with some special functionality.
Functionality 1:
Every day 100 digits (from 00 – 99) must be distributed. This needs to happen for each weekday.
- A crosscheck would be needed (each day – light up green when all digits are distributed)
The number distribution consists of
a) Fixed digits (in red) and
b) of daily deputy digits (shown on each weekday)
Functionality 2:
As not every clerk works full time, the number of digits is not evenly distributed.
The number of digits per clerk should be displayed and adjustable in a separate tab. A "target" function with warning would be needed.
Example:
If the maximum of 7 digits (this is the TARGET function) is reached by one clerk, this should be visible. But if one clerk is sick he can get a total of 8 (1 more than the TARGET). This should technically be possible, but with must be shown with a warning (e.g. change of color).
There are clerks who represent each permanently. Therefore, it should be possible to define which clerks deputize each other so the digits are distributed all on the day a clerk is not available.
Example:
Whenever Clerk 3 (ded) is gone, its digits are automatically given to clerk 10 (kha) and vice versa.
There should be 3 different types of OFF Days: “school”, “holidays”, “sickness” and “training”
As the distribution happens every day, it should be noted that clerks (if possible) can keep the numbers from the day before and do not every day get After the distribution each clerk should keep the numbers (from the day(s) before) to be substituted (if possible) and does not change it daily.
Pia on purpose has no numbers, she is still in training.
My example is what we currently have in place (at lease the bi-weekly version of it - it would be great if the calendar would be ongoing - e.g. where weeks/days can be entered). If you have questions please do not hesitate to contact me.
What you need:
- Good Excel Knowledge (not super)
- Very Good analytical skills (to understand what we need)
- Minor design skills (so the excel does not look bad)
I will decline any general proposals.
And please ask questions.
Chris F.
100% (16)Projects Completed
15
Freelancers worked with
13
Projects awarded
56%
Last project
13 Oct 2021
Switzerland
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