tezza73
asked on
Sifting thro' data to find Double Shift
Hi Experts
Firstly A Merry Christmas to you all, I think you do a sterling job helping us amateurs. At my age now, it probably is too late to try and grasp all that Excel can offer, but your help is very much appreciated. And that is not a sychophantic statement either !
I have yet another problem which I hope you may be able to help as I am totally stumped. I need to interrogate a huge SAP download to determine whether shift people have worked "Double shifts".
The daily shift pattern is Mornings 7.8 hours, Afternoons 8.2 hours, Nights 7.2 hours. It is a 5 Crew Shift System on a 35 day rolling calendar. The list is about 13000 rows of data and if I were to attack this manually, I would be in cuckoo land by the end. (If, indeed, I could get to the end).
The list is a download sorted in Shift, Name and Date order.
I hope that you can help.
Regards
tezza73
Firstly A Merry Christmas to you all, I think you do a sterling job helping us amateurs. At my age now, it probably is too late to try and grasp all that Excel can offer, but your help is very much appreciated. And that is not a sychophantic statement either !
I have yet another problem which I hope you may be able to help as I am totally stumped. I need to interrogate a huge SAP download to determine whether shift people have worked "Double shifts".
The daily shift pattern is Mornings 7.8 hours, Afternoons 8.2 hours, Nights 7.2 hours. It is a 5 Crew Shift System on a 35 day rolling calendar. The list is about 13000 rows of data and if I were to attack this manually, I would be in cuckoo land by the end. (If, indeed, I could get to the end).
The list is a download sorted in Shift, Name and Date order.
I hope that you can help.
Regards
tezza73
What constitues a double shift? Is it just more than one entry per day?
Could you provide a little more info on what criteria constitute a "double-shift"?
My guess would be this:
double shift if
Pers. No = Pers. No
Date = Date
Shift <> (not equal) Shift
I'm not sure if someone could have the same value for Shift on the same day, but another field would actually have different values which would mean they worked a double-shift.
I'll start working on what I believe the solution is, but please provide feedback. If I don't hear back in an hour, I unfortunately will be on the road back home and not able to check back for a couple of days.
Merry Christmas,
WC
My guess would be this:
double shift if
Pers. No = Pers. No
Date = Date
Shift <> (not equal) Shift
I'm not sure if someone could have the same value for Shift on the same day, but another field would actually have different values which would mean they worked a double-shift.
I'll start working on what I believe the solution is, but please provide feedback. If I don't hear back in an hour, I unfortunately will be on the road back home and not able to check back for a couple of days.
Merry Christmas,
WC
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi experts
Sorry guys, I had to go out and this first time back.
A double shift is when a person works his own shift, say afternoons, and his relief mate phones in unbale to get to work for whatever reason, so the guy working the afternoon shift elects to work the night shift too!
So his entry would be:
30-August 8.2
30-August 7.2
Hope that clarifies
tezza73
Sorry guys, I had to go out and this first time back.
A double shift is when a person works his own shift, say afternoons, and his relief mate phones in unbale to get to work for whatever reason, so the guy working the afternoon shift elects to work the night shift too!
So his entry would be:
30-August 8.2
30-August 7.2
Hope that clarifies
tezza73
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks both, I have awarded shared points based on the fact that warcrimes was almost there and sewed the seed, so to speak. ProdOps was spot on, thanks both.
Have A Merry Christmas
tezza73
Have A Merry Christmas
tezza73
ASKER
People.XLS