Hello All,
I would need someones help with frequency formula. never used it and now i need it for some of my work, i can come up with basic one but not with one with multiple criteria.
So here is what i need help on, i have a document with persons working times. Based on that i need to be able to calculate how many days they have worked by counting status "Connected" only once per day. I have below recreated the layout of the data. Criteria is based on country, weeks, persons ID, status what should be considered is "Connected". (please note that there will be drop downs and based on selected week and ID i need to be able to see their working days).
Hope the table makes sense
And thank you in advance!
[TABLE="class: grid, width: 100, align: left"]
<tbody>[TR]
[TD]
<tbody>
[TD="width: 64"][/TD]
[TD="width: 64"]ID[/TD]
[TD="width: 64"][/TD]
[TD="width: 108"][/TD]
</tbody>[/TD]
[TD]
<tbody>
</tbody>[/TD]
[TD]
<tbody>
</tbody>[/TD]
[TD]
<tbody>
</tbody>[/TD]
[TD]
<tbody>
</tbody>[/TD]
[TD]
<tbody>
</tbody>[/TD]
[TD]
<tbody>
</tbody>[/TD]
[TD]
<tbody>
</tbody>[/TD]
[TD]
<tbody>
</tbody>[/TD]
[TD]
<tbody>
</tbody>[/TD]
[TD]
<tbody>
</tbody>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]
<tbody>
</tbody>[/TD]
[TD]UK[/TD]
[TD]<- This is dropdown[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: right"]12345[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]
<tbody>
</tbody>[/TD]
[TD]
<tbody>
</tbody>[/TD]
[TD]
<tbody>
</tbody>[/TD]
[TD]
<tbody>
[TD="class: xl65, align: right"]18-06-18[/TD]
</tbody>[/TD]
[TD]
<tbody>
[TD="class: xl65, align: right"]18-06-18[/TD]
</tbody>[/TD]
[TD]UK[/TD]
[TD]25[/TD]
[TD]6[/TD]
[TD]2018[/TD]
[TD]Monday[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Week[/TD]
[TD]25[/TD]
[TD]<- This is dropdown[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]
<tbody>
[TD="align: right"]12345[/TD]
</tbody>[/TD]
[TD]
<tbody>
</tbody>[/TD]
[TD][TABLE="width: 83"]
<tbody>[TR]
[TD="width: 83"]John[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 171"]
<tbody>[TR]
[TD="width: 171"]CONNECTED[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 75"]
<tbody>[TR]
[TD="class: xl65, width: 75, align: right"]18-06-18[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]
<tbody>
[TD="class: xl65, align: right"]18-06-18[/TD]
</tbody>[/TD]
[TD]UK[/TD]
[TD]25[/TD]
[TD]6[/TD]
[TD]2018[/TD]
[TD]Monday[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]ID[/TD]
[TD]1234[/TD]
[TD]<- This is dropdown[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]
<tbody>
[TD="align: right"]12345[/TD]
</tbody>[/TD]
[TD]
<tbody>
</tbody>[/TD]
[TD][TABLE="width: 83"]
<tbody>[TR]
[TD="width: 83"]John[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]
<tbody>
</tbody>[/TD]
[TD][TABLE="width: 75"]
<tbody>[TR]
[TD="class: xl65, width: 75, align: right"]18-06-18[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]
<tbody>
[TD="class: xl65, align: right"]18-06-18[/TD]
</tbody>[/TD]
[TD]UK[/TD]
[TD]25[/TD]
[TD]6[/TD]
[TD]2018[/TD]
[TD]Monday[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Days worked?[/TD]
[TD]?[/TD]
[TD]Based on statuses "Connected".[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: right"]12345[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]
<tbody>
</tbody>[/TD]
[TD][TABLE="width: 83"]
<tbody>[TR]
[TD="width: 83"]John[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]
<tbody>
</tbody>[/TD]
[TD]
<tbody>
[TD="class: xl65, align: right"]18-06-18[/TD]
</tbody>[/TD]
[TD]
<tbody>
[TD="class: xl65, align: right"]18-06-18[/TD]
</tbody>[/TD]
[TD]UK[/TD]
[TD]25[/TD]
[TD]6[/TD]
[TD]2018[/TD]
[TD]Monday[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Result should be[/TD]
[TD]4[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]
<tbody>
[TD="align: right"]12345[/TD]
</tbody>[/TD]
[TD]
<tbody>
</tbody>[/TD]
[TD]
<tbody>
</tbody>[/TD]
[TD]
<tbody>
</tbody>[/TD]
[TD]
<tbody>
[TD="class: xl65, align: right"]18-06-18[/TD]
</tbody>[/TD]
[TD]
<tbody>
[TD="class: xl65, align: right"]18-06-18[/TD]
</tbody>[/TD]
[TD]UK[/TD]
[TD]25[/TD]
[TD]6[/TD]
[TD]2018[/TD]
[TD]Monday[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]
<tbody>
[TD="align: right"]12345[/TD]
</tbody>[/TD]
[TD]
<tbody>
</tbody>[/TD]
[TD][TABLE="width: 83"]
<tbody>[TR]
[TD="width: 83"]John[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]
<tbody>
</tbody>[/TD]
[TD]
<tbody>
[TD="class: xl65, align: right"]18-06-18[/TD]
</tbody>[/TD]
[TD]
<tbody>
[TD="class: xl65, align: right"]18-06-18[/TD]
</tbody>[/TD]
[TD]UK[/TD]
[TD]25[/TD]
[TD]6[/TD]
[TD]2018[/TD]
[TD]Monday[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: right"]12345[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]
<tbody>
</tbody>[/TD]
[TD][TABLE="width: 83"]
<tbody>[TR]
[TD="width: 83"]John[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]
<tbody>
</tbody>[/TD]
[TD]
<tbody>
[TD="class: xl65, align: right"]19-06-18[/TD]
</tbody>[/TD]
[TD]
<tbody>
[TD="class: xl65, align: right"]19-06-18[/TD]
</tbody>[/TD]
[TD]UK[/TD]
[TD]25[/TD]
[TD]6[/TD]
[TD]2018[/TD]
[TD]Tuesday[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]
<tbody>
[TD="align: right"]12345[/TD]
</tbody>[/TD]
[TD]
<tbody>
</tbody>[/TD]
[TD][TABLE="width: 83"]
<tbody>[TR]
[TD="width: 83"]John[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]
<tbody>
</tbody>[/TD]
[TD]
<tbody>
[TD="class: xl65, align: right"]19-06-18[/TD]
</tbody>[/TD]
[TD]
<tbody>
[TD="class: xl65, align: right"]19-06-18[/TD]
</tbody>[/TD]
[TD]UK[/TD]
[TD]25[/TD]
[TD]6[/TD]
[TD]2018[/TD]
[TD]Tuesday[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]
<tbody>
[TD="align: right"]12345[/TD]
</tbody>[/TD]
[TD][TABLE="width: 158"]
<tbody>[TR]
[TD="width: 75"]SMITH[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]
<tbody>
</tbody>[/TD]
[TD][TABLE="width: 171"]
<tbody>[TR]
[TD="width: 171"]WRAPUP[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 75"]
<tbody>[TR]
[TD="class: xl65, width: 75, align: right"]19-06-18[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 106"]
<tbody>[TR]
[TD="class: xl65, width: 106, align: right"]19-06-18[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]UK[/TD]
[TD]25[/TD]
[TD]6[/TD]
[TD]2018[/TD]
[TD]Tuesday[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: right"]12345[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]
<tbody>
</tbody>[/TD]
[TD]
<tbody>
</tbody>[/TD]
[TD]
<tbody>
</tbody>[/TD]
[TD]
<tbody>
[TD="class: xl65, align: right"]19-06-18[/TD]
</tbody>[/TD]
[TD]
<tbody>
[TD="class: xl65, align: right"]19-06-18[/TD]
</tbody>[/TD]
[TD]UK[/TD]
[TD]25[/TD]
[TD]6[/TD]
[TD]2018[/TD]
[TD]Tuesday[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]
<tbody>
[TD="align: right"]12345[/TD]
</tbody>[/TD]
[TD][TABLE="width: 158"]
<tbody>[TR]
[TD="width: 75"]SMITH[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 83"]
<tbody>[TR]
[TD="width: 83"]John[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 171"]
<tbody>[TR]
[TD="width: 171"]READY[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]
<tbody>
[TD="class: xl65, align: right"]19-06-18[/TD]
</tbody>[/TD]
[TD][TABLE="width: 106"]
<tbody>[TR]
[TD="class: xl65, width: 106, align: right"]19-06-18[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]UK[/TD]
[TD]25[/TD]
[TD]6[/TD]
[TD]2018[/TD]
[TD]Tuesday[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]
<tbody>
[TD="align: right"]12345[/TD]
</tbody>[/TD]
[TD]
<tbody>
</tbody>[/TD]
[TD][TABLE="width: 83"]
<tbody>[TR]
[TD="width: 83"]John[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]
<tbody>
</tbody>[/TD]
[TD][TABLE="width: 75"]
<tbody>[TR]
[TD="class: xl65, width: 75, align: right"]20-06-18[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]
<tbody>
[TD="class: xl65, align: right"]20-06-18[/TD]
</tbody>[/TD]
[TD]UK[/TD]
[TD]25[/TD]
[TD]6[/TD]
[TD]2018[/TD]
[TD]Wednesday[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: right"]12345[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]
<tbody>
</tbody>[/TD]
[TD]
<tbody>
</tbody>[/TD]
[TD]
<tbody>
</tbody>[/TD]
[TD][TABLE="width: 75"]
<tbody>[TR]
[TD="class: xl65, width: 75, align: right"]20-06-18[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 106"]
<tbody>[TR]
[TD="class: xl65, width: 106, align: right"]20-06-18[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]UK[/TD]
[TD]25[/TD]
[TD]6[/TD]
[TD]2018[/TD]
[TD]Wednesday[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]
<tbody>
[TD="align: right"]12345[/TD]
</tbody>[/TD]
[TD]
<tbody>
</tbody>[/TD]
[TD]
<tbody>
</tbody>[/TD]
[TD]
<tbody>
</tbody>[/TD]
[TD]
<tbody>
[TD="class: xl65, align: right"]20-06-18[/TD]
</tbody>[/TD]
[TD]
<tbody>
[TD="class: xl65, align: right"]20-06-18[/TD]
</tbody>[/TD]
[TD]UK[/TD]
[TD]25[/TD]
[TD]6[/TD]
[TD]2018[/TD]
[TD]Wednesday[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]
<tbody>
[TD="align: right"]12345[/TD]
</tbody>[/TD]
[TD]
<tbody>
</tbody>[/TD]
[TD]
<tbody>
</tbody>[/TD]
[TD]
<tbody>
</tbody>[/TD]
[TD]
<tbody>
[TD="class: xl65, align: right"]20-06-18[/TD]
</tbody>[/TD]
[TD]
<tbody>
[TD="class: xl65, align: right"]20-06-18[/TD]
</tbody>[/TD]
[TD]UK[/TD]
[TD]25[/TD]
[TD]6[/TD]
[TD]2018[/TD]
[TD]Wednesday[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]
<tbody>
[TD="align: right"]12345[/TD]
</tbody>[/TD]
[TD]
<tbody>
</tbody>[/TD]
[TD]
<tbody>
</tbody>[/TD]
[TD]
<tbody>
</tbody>[/TD]
[TD][TABLE="width: 75"]
<tbody>[TR]
[TD="class: xl65, width: 75, align: right"]21-06-18[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]
<tbody>
[TD="class: xl65, align: right"]21-06-18[/TD]
</tbody>[/TD]
[TD]UK[/TD]
[TD]25[/TD]
[TD]6[/TD]
[TD]2018[/TD]
[TD]Thursday[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: right"]12345[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]
<tbody>
</tbody>[/TD]
[TD][TABLE="width: 83"]
<tbody>[TR]
[TD="width: 83"]John[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]
<tbody>
</tbody>[/TD]
[TD]
<tbody>
[TD="class: xl65, align: right"]21-06-18[/TD]
</tbody>[/TD]
[TD]
<tbody>
[TD="class: xl65, align: right"]21-06-18[/TD]
</tbody>[/TD]
[TD]UK[/TD]
[TD]25[/TD]
[TD]6[/TD]
[TD]2018[/TD]
[TD]Thursday[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]
<tbody>
[TD="align: right"]12345[/TD]
</tbody>[/TD]
[TD]
<tbody>
</tbody>[/TD]
[TD]
<tbody>
</tbody>[/TD]
[TD]
<tbody>
</tbody>[/TD]
[TD]
<tbody>
[TD="class: xl65, align: right"]21-06-18[/TD]
</tbody>[/TD]
[TD]
<tbody>
[TD="class: xl65, align: right"]21-06-18[/TD]
</tbody>[/TD]
[TD]UK[/TD]
[TD]25[/TD]
[TD]6[/TD]
[TD]2018[/TD]
[TD]Thursday[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: right"]12345[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]
<tbody>
</tbody>[/TD]
[TD][TABLE="width: 83"]
<tbody>[TR]
[TD="width: 83"]John[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]
<tbody>
</tbody>[/TD]
[TD]
<tbody>
[TD="class: xl65, align: right"]21-06-18[/TD]
</tbody>[/TD]
[TD]
<tbody>
[TD="class: xl65, align: right"]21-06-18[/TD]
</tbody>[/TD]
[TD]UK[/TD]
[TD]25[/TD]
[TD]6[/TD]
[TD]2018[/TD]
[TD]Thursday[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]
<tbody>
[TD="align: right"]12345[/TD]
</tbody>[/TD]
[TD]
<tbody>
</tbody>[/TD]
[TD]
<tbody>
</tbody>[/TD]
[TD]
<tbody>
</tbody>[/TD]
[TD]
<tbody>
[TD="class: xl65, align: right"]21-06-18[/TD]
</tbody>[/TD]
[TD]
<tbody>
[TD="class: xl65, align: right"]21-06-18[/TD]
</tbody>[/TD]
[TD]UK[/TD]
[TD]25[/TD]
[TD]6[/TD]
[TD]2018[/TD]
[TD]Thursday[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: right"]12345[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]
<tbody>
</tbody>[/TD]
[TD]
<tbody>
</tbody>[/TD]
[TD]
<tbody>
</tbody>[/TD]
[TD]
<tbody>
[TD="class: xl65, align: right"]21-06-18[/TD]
</tbody>[/TD]
[TD]
<tbody>
[TD="class: xl65, align: right"]21-06-18[/TD]
</tbody>[/TD]
[TD]UK[/TD]
[TD]25[/TD]
[TD]6[/TD]
[TD]2018[/TD]
[TD]Thursday[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I would need someones help with frequency formula. never used it and now i need it for some of my work, i can come up with basic one but not with one with multiple criteria.
So here is what i need help on, i have a document with persons working times. Based on that i need to be able to calculate how many days they have worked by counting status "Connected" only once per day. I have below recreated the layout of the data. Criteria is based on country, weeks, persons ID, status what should be considered is "Connected". (please note that there will be drop downs and based on selected week and ID i need to be able to see their working days).
Hope the table makes sense
And thank you in advance!
[TABLE="class: grid, width: 100, align: left"]
<tbody>[TR]
[TD]
<tbody>
[TD="width: 64"][/TD]
[TD="width: 64"]ID[/TD]
[TD="width: 64"][/TD]
[TD="width: 108"][/TD]
</tbody>
[TD]
Surname |
<tbody>
</tbody>
[TD]
Name |
<tbody>
</tbody>
[TD]
STATUS |
<tbody>
</tbody>
[TD]
START |
<tbody>
</tbody>
[TD]
END |
<tbody>
</tbody>
[TD]
Country |
<tbody>
</tbody>
[TD]
WEEK |
<tbody>
</tbody>
[TD]
MONTH |
<tbody>
</tbody>
[TD]
Year |
<tbody>
</tbody>
[TD]
WEEKDAY |
<tbody>
</tbody>
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]
Country |
<tbody>
</tbody>
[TD]UK[/TD]
[TD]<- This is dropdown[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: right"]12345[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]
SMITH |
<tbody>
</tbody>
[TD]
John |
<tbody>
</tbody>
[TD]
ON_SITE |
<tbody>
</tbody>
[TD]
<tbody>
[TD="class: xl65, align: right"]18-06-18[/TD]
</tbody>
[TD]
<tbody>
[TD="class: xl65, align: right"]18-06-18[/TD]
</tbody>
[TD]UK[/TD]
[TD]25[/TD]
[TD]6[/TD]
[TD]2018[/TD]
[TD]Monday[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Week[/TD]
[TD]25[/TD]
[TD]<- This is dropdown[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]
<tbody>
[TD="align: right"]12345[/TD]
</tbody>
[TD]
SMITH |
<tbody>
</tbody>
[TD][TABLE="width: 83"]
<tbody>[TR]
[TD="width: 83"]John[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 171"]
<tbody>[TR]
[TD="width: 171"]CONNECTED[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 75"]
<tbody>[TR]
[TD="class: xl65, width: 75, align: right"]18-06-18[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]
<tbody>
[TD="class: xl65, align: right"]18-06-18[/TD]
</tbody>
[TD]UK[/TD]
[TD]25[/TD]
[TD]6[/TD]
[TD]2018[/TD]
[TD]Monday[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]ID[/TD]
[TD]1234[/TD]
[TD]<- This is dropdown[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]
<tbody>
[TD="align: right"]12345[/TD]
</tbody>
[TD]
SMITH |
<tbody>
</tbody>
[TD][TABLE="width: 83"]
<tbody>[TR]
[TD="width: 83"]John[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]
CONNECTED |
<tbody>
</tbody>
[TD][TABLE="width: 75"]
<tbody>[TR]
[TD="class: xl65, width: 75, align: right"]18-06-18[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]
<tbody>
[TD="class: xl65, align: right"]18-06-18[/TD]
</tbody>
[TD]UK[/TD]
[TD]25[/TD]
[TD]6[/TD]
[TD]2018[/TD]
[TD]Monday[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Days worked?[/TD]
[TD]?[/TD]
[TD]Based on statuses "Connected".[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: right"]12345[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]
SMITH |
<tbody>
</tbody>
[TD][TABLE="width: 83"]
<tbody>[TR]
[TD="width: 83"]John[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]
READY |
<tbody>
</tbody>
[TD]
<tbody>
[TD="class: xl65, align: right"]18-06-18[/TD]
</tbody>
[TD]
<tbody>
[TD="class: xl65, align: right"]18-06-18[/TD]
</tbody>
[TD]UK[/TD]
[TD]25[/TD]
[TD]6[/TD]
[TD]2018[/TD]
[TD]Monday[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Result should be[/TD]
[TD]4[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]
<tbody>
[TD="align: right"]12345[/TD]
</tbody>
[TD]
SMITH |
<tbody>
</tbody>
[TD]
John |
<tbody>
</tbody>
[TD]
Unavailable |
<tbody>
</tbody>
[TD]
<tbody>
[TD="class: xl65, align: right"]18-06-18[/TD]
</tbody>
[TD]
<tbody>
[TD="class: xl65, align: right"]18-06-18[/TD]
</tbody>
[TD]UK[/TD]
[TD]25[/TD]
[TD]6[/TD]
[TD]2018[/TD]
[TD]Monday[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]
<tbody>
[TD="align: right"]12345[/TD]
</tbody>
[TD]
SMITH |
<tbody>
</tbody>
[TD][TABLE="width: 83"]
<tbody>[TR]
[TD="width: 83"]John[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]
CONNECTED |
<tbody>
</tbody>
[TD]
<tbody>
[TD="class: xl65, align: right"]18-06-18[/TD]
</tbody>
[TD]
<tbody>
[TD="class: xl65, align: right"]18-06-18[/TD]
</tbody>
[TD]UK[/TD]
[TD]25[/TD]
[TD]6[/TD]
[TD]2018[/TD]
[TD]Monday[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: right"]12345[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]
SMITH |
<tbody>
</tbody>
[TD][TABLE="width: 83"]
<tbody>[TR]
[TD="width: 83"]John[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]
WRAPUP |
<tbody>
</tbody>
[TD]
<tbody>
[TD="class: xl65, align: right"]19-06-18[/TD]
</tbody>
[TD]
<tbody>
[TD="class: xl65, align: right"]19-06-18[/TD]
</tbody>
[TD]UK[/TD]
[TD]25[/TD]
[TD]6[/TD]
[TD]2018[/TD]
[TD]Tuesday[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]
<tbody>
[TD="align: right"]12345[/TD]
</tbody>
[TD]
SMITH |
<tbody>
</tbody>
[TD][TABLE="width: 83"]
<tbody>[TR]
[TD="width: 83"]John[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]
WRAPUP |
<tbody>
</tbody>
[TD]
<tbody>
[TD="class: xl65, align: right"]19-06-18[/TD]
</tbody>
[TD]
<tbody>
[TD="class: xl65, align: right"]19-06-18[/TD]
</tbody>
[TD]UK[/TD]
[TD]25[/TD]
[TD]6[/TD]
[TD]2018[/TD]
[TD]Tuesday[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]
<tbody>
[TD="align: right"]12345[/TD]
</tbody>
[TD][TABLE="width: 158"]
<tbody>[TR]
[TD="width: 75"]SMITH[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]
John |
<tbody>
</tbody>
[TD][TABLE="width: 171"]
<tbody>[TR]
[TD="width: 171"]WRAPUP[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 75"]
<tbody>[TR]
[TD="class: xl65, width: 75, align: right"]19-06-18[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 106"]
<tbody>[TR]
[TD="class: xl65, width: 106, align: right"]19-06-18[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]UK[/TD]
[TD]25[/TD]
[TD]6[/TD]
[TD]2018[/TD]
[TD]Tuesday[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: right"]12345[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]
SMITH |
<tbody>
</tbody>
[TD]
John |
<tbody>
</tbody>
[TD]
CONNECTED |
<tbody>
</tbody>
[TD]
<tbody>
[TD="class: xl65, align: right"]19-06-18[/TD]
</tbody>
[TD]
<tbody>
[TD="class: xl65, align: right"]19-06-18[/TD]
</tbody>
[TD]UK[/TD]
[TD]25[/TD]
[TD]6[/TD]
[TD]2018[/TD]
[TD]Tuesday[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]
<tbody>
[TD="align: right"]12345[/TD]
</tbody>
[TD][TABLE="width: 158"]
<tbody>[TR]
[TD="width: 75"]SMITH[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 83"]
<tbody>[TR]
[TD="width: 83"]John[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 171"]
<tbody>[TR]
[TD="width: 171"]READY[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]
<tbody>
[TD="class: xl65, align: right"]19-06-18[/TD]
</tbody>
[TD][TABLE="width: 106"]
<tbody>[TR]
[TD="class: xl65, width: 106, align: right"]19-06-18[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]UK[/TD]
[TD]25[/TD]
[TD]6[/TD]
[TD]2018[/TD]
[TD]Tuesday[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]
<tbody>
[TD="align: right"]12345[/TD]
</tbody>
[TD]
SMITH |
<tbody>
</tbody>
[TD][TABLE="width: 83"]
<tbody>[TR]
[TD="width: 83"]John[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]
ON_SITE |
<tbody>
</tbody>
[TD][TABLE="width: 75"]
<tbody>[TR]
[TD="class: xl65, width: 75, align: right"]20-06-18[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]
<tbody>
[TD="class: xl65, align: right"]20-06-18[/TD]
</tbody>
[TD]UK[/TD]
[TD]25[/TD]
[TD]6[/TD]
[TD]2018[/TD]
[TD]Wednesday[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: right"]12345[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]
SMITH |
<tbody>
</tbody>
[TD]
John |
<tbody>
</tbody>
[TD]
CONNECTED |
<tbody>
</tbody>
[TD][TABLE="width: 75"]
<tbody>[TR]
[TD="class: xl65, width: 75, align: right"]20-06-18[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 106"]
<tbody>[TR]
[TD="class: xl65, width: 106, align: right"]20-06-18[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]UK[/TD]
[TD]25[/TD]
[TD]6[/TD]
[TD]2018[/TD]
[TD]Wednesday[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]
<tbody>
[TD="align: right"]12345[/TD]
</tbody>
[TD]
SMITH |
<tbody>
</tbody>
[TD]
John |
<tbody>
</tbody>
[TD]
CONNECTED |
<tbody>
</tbody>
[TD]
<tbody>
[TD="class: xl65, align: right"]20-06-18[/TD]
</tbody>
[TD]
<tbody>
[TD="class: xl65, align: right"]20-06-18[/TD]
</tbody>
[TD]UK[/TD]
[TD]25[/TD]
[TD]6[/TD]
[TD]2018[/TD]
[TD]Wednesday[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]
<tbody>
[TD="align: right"]12345[/TD]
</tbody>
[TD]
SMITH |
<tbody>
</tbody>
[TD]
John |
<tbody>
</tbody>
[TD]
READY |
<tbody>
</tbody>
[TD]
<tbody>
[TD="class: xl65, align: right"]20-06-18[/TD]
</tbody>
[TD]
<tbody>
[TD="class: xl65, align: right"]20-06-18[/TD]
</tbody>
[TD]UK[/TD]
[TD]25[/TD]
[TD]6[/TD]
[TD]2018[/TD]
[TD]Wednesday[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]
<tbody>
[TD="align: right"]12345[/TD]
</tbody>
[TD]
SMITH |
<tbody>
</tbody>
[TD]
John |
<tbody>
</tbody>
[TD]
Unavailable |
<tbody>
</tbody>
[TD][TABLE="width: 75"]
<tbody>[TR]
[TD="class: xl65, width: 75, align: right"]21-06-18[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]
<tbody>
[TD="class: xl65, align: right"]21-06-18[/TD]
</tbody>
[TD]UK[/TD]
[TD]25[/TD]
[TD]6[/TD]
[TD]2018[/TD]
[TD]Thursday[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: right"]12345[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]
SMITH |
<tbody>
</tbody>
[TD][TABLE="width: 83"]
<tbody>[TR]
[TD="width: 83"]John[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]
CONNECTED |
<tbody>
</tbody>
[TD]
<tbody>
[TD="class: xl65, align: right"]21-06-18[/TD]
</tbody>
[TD]
<tbody>
[TD="class: xl65, align: right"]21-06-18[/TD]
</tbody>
[TD]UK[/TD]
[TD]25[/TD]
[TD]6[/TD]
[TD]2018[/TD]
[TD]Thursday[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]
<tbody>
[TD="align: right"]12345[/TD]
</tbody>
[TD]
<tbody> </tbody> |
<tbody>
</tbody>
[TD]
John |
<tbody>
</tbody>
[TD]
CONNECTED |
<tbody>
</tbody>
[TD]
<tbody>
[TD="class: xl65, align: right"]21-06-18[/TD]
</tbody>
[TD]
<tbody>
[TD="class: xl65, align: right"]21-06-18[/TD]
</tbody>
[TD]UK[/TD]
[TD]25[/TD]
[TD]6[/TD]
[TD]2018[/TD]
[TD]Thursday[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: right"]12345[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]
SMITH |
<tbody>
</tbody>
[TD][TABLE="width: 83"]
<tbody>[TR]
[TD="width: 83"]John[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]
READY |
<tbody>
</tbody>
[TD]
<tbody>
[TD="class: xl65, align: right"]21-06-18[/TD]
</tbody>
[TD]
<tbody>
[TD="class: xl65, align: right"]21-06-18[/TD]
</tbody>
[TD]UK[/TD]
[TD]25[/TD]
[TD]6[/TD]
[TD]2018[/TD]
[TD]Thursday[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]
<tbody>
[TD="align: right"]12345[/TD]
</tbody>
[TD]
SMITH |
<tbody>
</tbody>
[TD]
John |
<tbody>
</tbody>
[TD]
ON_SITE |
<tbody>
</tbody>
[TD]
<tbody>
[TD="class: xl65, align: right"]21-06-18[/TD]
</tbody>
[TD]
<tbody>
[TD="class: xl65, align: right"]21-06-18[/TD]
</tbody>
[TD]UK[/TD]
[TD]25[/TD]
[TD]6[/TD]
[TD]2018[/TD]
[TD]Thursday[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: right"]12345[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]
SMITH |
<tbody>
</tbody>
[TD]
John |
<tbody>
</tbody>
[TD]
READY |
<tbody>
</tbody>
[TD]
<tbody>
[TD="class: xl65, align: right"]21-06-18[/TD]
</tbody>
[TD]
<tbody>
[TD="class: xl65, align: right"]21-06-18[/TD]
</tbody>
[TD]UK[/TD]
[TD]25[/TD]
[TD]6[/TD]
[TD]2018[/TD]
[TD]Thursday[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]