Question description:
This user has given permission to use the problem statement for this
blog.
Trying to determine if employees are colluding to get overtime. In essence, One employee would take the day off, receive sick pay, and get a friend to cover their shift, resulting in the friend receiving overtime pay. Then they swap places, and the one employee would receive overtime, and the friend would receive the sick day pay off
Solved by G. E. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
User
28/03/2018 - 03:56
These are not helpful
Excelchat Expert
28/03/2018 - 03:56
Hi there
User
28/03/2018 - 03:56
Hi
Excelchat Expert
28/03/2018 - 03:56
How are you and how may i assist you today?
User
28/03/2018 - 03:57
Trying to determine if employees are colluding to get overtime. In essence, One employee would take the day off, receive sick pay, and get a friend to cover their shift, resulting in the friend receiving overtime pay. Then they swap places, and the one employee would receive overtime, and the friend would receive the sick day pay off
Excelchat Expert
28/03/2018 - 03:57
Okay, i will try my best to help you out with this
Excelchat Expert
28/03/2018 - 03:58
Can you share me a sample worksheet
User
28/03/2018 - 03:58
I cannot as the information is confidential
Excelchat Expert
28/03/2018 - 03:58
So that we both can have a better evaluation to resolve the issue
Excelchat Expert
28/03/2018 - 03:58
Okay that will be good there
Excelchat Expert
28/03/2018 - 03:59
Please go ahead
User
28/03/2018 - 03:59
its essential laid out like this
User
28/03/2018 - 03:59
but with a lot more data
Excelchat Expert
28/03/2018 - 03:59
okay
Excelchat Expert
28/03/2018 - 04:00
Can you show me an example of a resultant column
User
28/03/2018 - 04:01
I am sorry, what do you mean by resultant?
Excelchat Expert
28/03/2018 - 04:01
Like, how you want to treat these data
User
28/03/2018 - 04:01
so I would like to isolate instances where the employees would be alternating between being sick and receiving overtime
User
28/03/2018 - 04:02
The names repeat too, for example, abby might be sick 3/1 3/2 3/3 etc
Excelchat Expert
28/03/2018 - 04:03
request you to provide me a specific data so that i can create a logic for the formula
Excelchat Expert
28/03/2018 - 04:03
else that would be quite difficult for me to derive the formula
Excelchat Expert
28/03/2018 - 04:09
I know that you understand the requirement, but m totally unaware that how you want to get the calculation done for the requirement untill, i dont have the clear visibility on the raw data from where the formula is to be derived
Excelchat Expert
28/03/2018 - 04:09
Hope you get that
Excelchat Expert
28/03/2018 - 04:13
Are you there?
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.