Tech Support Guy banner
Status
Not open for further replies.
1 - 4 of 4 Posts

·
Registered
Joined
·
217 Posts
Discussion Starter · #1 ·
I have been trying to figure out how to make this idea work
I write a schedule every month that involves 6-8 workers
I want to be able to put their names on the schedule as i do i get the follow info
Number of total shifts
number of opening, middle & Closing shifts
Number of specific days

number of shifts for each shift and days for example
if i put Bob in on Thursday at 3pm, Friday at 7pm and Saturday at 9pm
Sally in 7 on thursday, Friday at 7pm, sat at 7pm
I would get a report saying
Bob
total shifts = 3
Total Thursdays = 1
Total Friday = 1
Total saturdays = 1
Total 3pm shifts = 1
Total 7pm shifts = 1
Total 9pm shifts = 1
Sally
total shifts = 3
Total Thursdays = 1
Total Friday = 1
Total saturdays = 1
Total 3pm shifts = 0
Total 7pm shifts = 3
Total 9pm shifts = 0

So in summary
i need to make sure get equal share of shifts
Names would be drop downs
No duplicates allowed on shifts
Totals on Days Shifts and total shifts

Second sheet
Next each worker need to enter Hourly info
House money taken in
Tips taken in
House to tip ratio
Time on the floor with House and Tips per hour
Cash in and cash out
Example of this one attached, although I want it to be in a Input Form they can use to enter but not see results

More explanation to follow
 

Attachments

·
Registered
Joined
·
3,086 Posts
This can also be done in Excel, I think, but it seems like your business rules need to be defined more completely. So far I only see two, which are not perfectly clear, and I am (dangerously) inferring more from the example.

The two you have are:

  • Make sure there is an equal share of shifts - Equal in what way? Shared among whom? What are the exceptions to this (e.g. the definition of "equal" changes if someone is on vacation)? Etc.
  • No duplicates allowed on shifts - Duplicate what? Again, what are the exceptions (e.g. someone is covering)? Etc.
Do this part first. If you can provide good and complete definitions for the scheduling business rules, then the software implementation is just gravy.

chris.
 
1 - 4 of 4 Posts
Status
Not open for further replies.
Top