I am currently trying to measure the productivity of blue collars working in my firm. They have to register in a certain tool what they are doing at each moment of the day. For example, as you can see in my file, Jef says he is doing task A from 4.01am until 4.09am
Besides what they register in the file, they also generate a certain activity in another program. This is the output you can see in the second table.
I want to check whether these to values correspond, meaning that I want to check that these guys are really doing what they say they are doing. the system output should match what these people say they're doing at all times. these two tables should match.
The outcome should be what I have highlighted in red. These values are wrong so they should be red.
Jef says he is doing task A from 4.01am-4.09am, but in reality he did task B at 4.06am, which is why this is highlighted in red.
Jef says he is doing task A from 6.44am - 12.30pm, but in reality he executed task C at 7.45am --> red
Dan says he is doing task B from 9.07am - 10.28 am, but in reality he did task A at 9.40am --> red
The other should be green because they are correct. Example:
Dan says he is doing task F from 10.28am - 14.41pm, which matches the value in the second table --> green.
Can anyone please help me with this?
Any help is highly appreciated!
Bookmarks