How to programme this in excel?

[Sherees]

This is what I want to know..
cell B1 & C1 is the cell to enter the duties of two staffs (namely X & Y).
B1 is for staff X, C1 is for staff Y. staff can chose any one of duty in B1
& C1 frm a dropdownlist of 10 different duties(like "Break shift", "10 - 6
PM", "10 - 2 PM"..and so on)..

We have another cell D1 E1 & F1 where we enter the staff strength in the
shop on three intervals of time (say 10 - 2PM, 2 - 6PM, & 6 - 10PM)
Assume D1 cell to show the staffs present in the shop during time interval
10 - 2PM, E1 for 2 - 6PM & F1 for 6 - 10PM.

Now for eg, staff X chose her duty as Break Shift in cell B1(assume cell B1
as Jan 1, B2 as Jan 2 and so on), now we enter in D1 & F1 digit 1. & the
other staff chose 2 -10pm duty in C1 now the staff strenght cells are as
follows...

D1 shows 1, E1 shows 1 &F1 shows 2... This is entered manually now checking
the staff duty.. Is it possible to automate it.. When the staff's select
their duty the staff strength column in the particular day must show up the
number of staffs as per the duty automatically.. Pls help me

rgds,

 

[Arceedee]

What are the 10 different duties? You can't just say "and so on" and expect
a full answer. We need all the facts please.

You state there are only three time periods in the day but we need to know
how the different duties are reflected in those periods.

In theory it doesn't seem too difficult but I would need to build a s/s
myself to prove it works.

Also ,why don't you have any titles at the tops of your columns?

 

[p45cal]

This is what I want to know..
cell B1 & C1 is the cell to enter the duties of two staffs (namely X &
Y).
B1 is for staff X, C1 is for staff Y. staff can chose any one of duty
in B1
& C1 frm a dropdownlist of 10 different duties(like "Break shift", "10
- 6
PM", "10 - 2 PM"..and so on)..

We have another cell D1 E1 & F1 where we enter the staff strength in
the
shop on three intervals of time (say 10 - 2PM, 2 - 6PM, & 6 - 10PM)
Assume D1 cell to show the staffs present in the shop during time
interval
10 - 2PM, E1 for 2 - 6PM & F1 for 6 - 10PM.

Now for eg, staff X chose her duty as Break Shift in cell B1(assume
cell B1
as Jan 1, B2 as Jan 2 and so on), now we enter in D1 & F1 digit 1. &
the
other staff chose 2 -10pm duty in C1 now the staff strenght cells are
as
follows...

D1 shows 1, E1 shows 1 &F1 shows 2... This is entered manually now
checking
the staff duty.. Is it possible to automate it.. When the staff's
select
their duty the staff strength column in the particular day must show up
the
number of staffs as per the duty automatically.. Pls help me

rgds,

Use Countif
see attached file at thecodecage.com thread.


+-------------------------------------------------------------------+
|Filename: StaffStrength.xls |
|Download: http://www.thecodecage.com/forumz/attachment.php?attachmentid=383|
+-------------------------------------------------------------------+

 

[Sherees]

Could u pls give me ur e-mail id so that i can send u the excel sheet with
the mail, which wud make things much easier..

 

[Sherees]

Hi,

10 duties are as follows, 10 - 6PM, 2 - 10PM, BREAK SHIFT, 10 - 2/W.OFF, 10
- 2/P.OFF, 6 - 10/W.OFF, 6 -10/P.OFF, W.OFF, P. OFF, 10 - 10PM...

SHOP WORKS 10AM TO 10 PM, WHICH IS DIVIDED INTO 10 - 2PM, 2-6PM, 6-10PM

BREAK SHIFT= 10 - 2PM & 6 - 10 PM.. i TRUST THERE WONT BE ANY DOUBT WITH
OTHER DUTIES... 6 - 10/P.OFF means staff will work in the shop from 6pm to
10pm/4 hours is her pending off(P.OFF)...

if u give me the email id, i can send u the file that i made, and u can
suggest me better changes.. so please send me ur email id..

rgds
Sherees

 

[p45cal]

Hi,

10 duties are as follows, 10 - 6PM, 2 - 10PM, BREAK SHIFT, 10 -
2/W.OFF, 10
- 2/P.OFF, 6 - 10/W.OFF, 6 -10/P.OFF, W.OFF, P. OFF, 10 - 10PM...

SHOP WORKS 10AM TO 10 PM, WHICH IS DIVIDED INTO 10 - 2PM, 2-6PM,
6-10PM

BREAK SHIFT= 10 - 2PM & 6 - 10 PM.. i TRUST THERE WONT BE ANY DOUBT
WITH
OTHER DUTIES... 6 - 10/P.OFF means staff will work in the shop from 6pm
to
10pm/4 hours is her pending off(P.OFF)...

if u give me the email id, i can send u the file that i made, and u
can
suggest me better changes.. so please send me ur email id..

rgds
Sherees
--
Life isa journey not a destination


There's a file attached to this message at thecodecage.com (and a
screenshot) which seems to do it.
384
On Sheet2 of that file there's a table which you have to check; enter a
1 if the duty covers that shift, leave BLANK otherwise.
The formulae in columns D,E & F can be copied up/down, but NOT
left/right.
The Table on Sheet2 is used (1) to populate data validation (the
dropdown lists) and (2) to translate that to shifts.

(If you want to make your file available, you could do worse than
register at thecodecage.com and attach it to this thread.)


+-------------------------------------------------------------------+
|Filename: StaffStrength2.xls |
|Download: http://www.thecodecage.com/forumz/attachment.php?attachmentid=385|
+-------------------------------------------------------------------+

 

[Sherees]

is my answer sufficient