So, I an Level1 seller and have positive feedback from my customers… Untill today.
My story is about one user who have received the good quality work (I am very confident in this words).
User _____ have ordered the servise that was about the schedule.
So, currently the schedule was very hard to deliver and was overloaded in some days and not loaded in another days. The task was to fix it. There were couple of requirements (provided them below) that was met upon completion the job.
Below i am providing the task, the current schedule (this was additionaly provided by me just to understand the problem and found the solution) and the solution schedule. The main document here is the solution schedule.
(all of the documents that were in conversation are attached)
this is current schedule
the schedule is for people who work on shift
the numbers represent different people
total workers is 5
the problem statement is this:
- every worker should have two consecutive day offs
- two flexible shift workers from total 5 workers
- 24 hours coverage.
I’ve provided this schdule, see below
with these comments:
This excel file consist of couple of tabs inside.
First one is your current schedule and it is only for comparing and problem identification, so you may not needed and can delete it as it was information purpose only.
The tab Revised is the one that you need.
_This is your schedule. _
As requested all information have been incorporated into schedule:
two consecutive day offs,
two flexible shift workers,
24 hours coverage.
The schedule is named by numbers, so you can change to worker names. Each day of the week have been splitted to four pieces by time (from … to …). Every shift worker will be on shift when his name (number in our case) is under certain time period of each day. Vacation have been separated to the bottom of the table to emphasize the vacation section. Approved overtime section shows the day and shift where anyone from NOT LISTED on this particular day shift workers can come to work.
additionally i’ve provided this schedule for different view.
Also, excell document was optimized for printing.
User at the end said that why you do not use formulas, you do not know excel and called me scammer.
Please kindly review the schedule I’ve provided and let me know what goes wrong in here?
My position is obvious, but want to know your opinion also.
User was late in responding to messages and starts compaining after order was delivered and marked as completed. Also, his offensive language was inapropriate.
What are your thoughts?
Thank you in advance.