Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
functions/formulas
I need some serious help with my restaurant/bar schedule. I am trying to
program the sheet to do the following things: *count # of scheduled servers for day shift and night shift separately to make sure we are sufficiently staffed for each shift *program sheet so that a server cannot be scheduled in the bar and grill at the same time (big problem, we have 6 servers that work in both) *I want the servers' availability info mirrored in the weekly schedule (i.e. X in the day shift cell or night shift cell is when he/she cannot work) that will disallow a manager from scheduling someone on that shift. I would be more than happy to email an skeleton schedule that I am currently working with so you may better understand how the sheet is arranged. I am so grateful to ANYONE who can help me or at least try to help me! Pulling out my hair in Mississippi, Lara Leigh Cervantes Crescent City Grill/Mahogany Bar |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
functions/formulas
There was a similar request a few days ago
http://makeashorterlink.com/?Q695169FC scroll all the way up to the top, Debra Dalgleish provided a link to a file that can be downloaded and probably can be adapted for your situation -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com "It is a good thing to follow the first law of holes; if you are in one stop digging." Lord Healey "Lara Leigh" wrote in message ... I need some serious help with my restaurant/bar schedule. I am trying to program the sheet to do the following things: *count # of scheduled servers for day shift and night shift separately to make sure we are sufficiently staffed for each shift *program sheet so that a server cannot be scheduled in the bar and grill at the same time (big problem, we have 6 servers that work in both) *I want the servers' availability info mirrored in the weekly schedule (i.e. X in the day shift cell or night shift cell is when he/she cannot work) that will disallow a manager from scheduling someone on that shift. I would be more than happy to email an skeleton schedule that I am currently working with so you may better understand how the sheet is arranged. I am so grateful to ANYONE who can help me or at least try to help me! Pulling out my hair in Mississippi, Lara Leigh Cervantes Crescent City Grill/Mahogany Bar |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
functions/formulas
Thanks, but that information really didnt help me. Can I email a copy of my
schedule so you may look at it and then inform me from there? Thanks, LL "Peo Sjoblom" wrote: There was a similar request a few days ago http://makeashorterlink.com/?Q695169FC scroll all the way up to the top, Debra Dalgleish provided a link to a file that can be downloaded and probably can be adapted for your situation -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com "It is a good thing to follow the first law of holes; if you are in one stop digging." Lord Healey "Lara Leigh" wrote in message ... I need some serious help with my restaurant/bar schedule. I am trying to program the sheet to do the following things: *count # of scheduled servers for day shift and night shift separately to make sure we are sufficiently staffed for each shift *program sheet so that a server cannot be scheduled in the bar and grill at the same time (big problem, we have 6 servers that work in both) *I want the servers' availability info mirrored in the weekly schedule (i.e. X in the day shift cell or night shift cell is when he/she cannot work) that will disallow a manager from scheduling someone on that shift. I would be more than happy to email an skeleton schedule that I am currently working with so you may better understand how the sheet is arranged. I am so grateful to ANYONE who can help me or at least try to help me! Pulling out my hair in Mississippi, Lara Leigh Cervantes Crescent City Grill/Mahogany Bar |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Zero Values in worksheet functions/formulas. | Excel Worksheet Functions | |||
functions/formulas | Excel Worksheet Functions |