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

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

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