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

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" <LaraLeigh@discussions.microsoft.com> wrote in message
news:7EA811D0-7501-41D2-9B29-A7F69C9CB218@microsoft.com...
>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
>

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" <LaraLeigh@discussions.microsoft.com> wrote in message
> news:7EA811D0-7501-41D2-9B29-A7F69C9CB218@microsoft.com...
> >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
> >
>
>
>