Spreadsheet: 692880d1598619416-lookup-that-looks-down-then-across-dynamic-rows-excel-help-lookup-down-then-across
Sheet: Sheet2

ADHERENCE SUMMARY
 | From:  01/08/2020 |  |  |  |  | Filter By: Off World
 | To:  27/08/2020 |  |  |  |  | Group By:  Employee
 |  |  |  |  |  | Using Organization Day Boundaries
Start Date |  | Time Adhering to Schedule (Hours) | Time Not Adhering to Schedule (Hours) |  |  |  | Total Time Scheduled (Hours) | Time Adhering to Schedule (%) | Time Not Adhering to Schedule (%) | Adherence Violations |  |  |  |  |  | Time Adhering to Schedule (%)
Employee: Supergirl |  |  | Supervisor: Mrs M |  |  |  |  | Organization: Mrs M |  |  |  |  |  |  | Employee: Supergirl | 92.24 | from line 27, 'Totals'
2020-08-03 00:00:00 |  | 6.38 | 1.12 |  |  |  | 7.5 | 85.1111111111111 | 14.8888888888889 | 9 |  |  |  |  | Employee: Wonderwoman | 90.98 | from line 45, 'Totals'
2020-08-04 00:00:00 |  | 6.83 | 0.67 |  |  |  | 7.5 | 91.1111111111111 | 8.88888888888889 | 9 |  |  |  |  | Employee: Iceman | 91.54 | etc
2020-08-07 00:00:00 |  | 7.03 | 0.47 |  |  |  | 7.5 | 93.7777777777778 | 6.22222222222222 | 6 |  |  |  |  | Employee: Wolverine | 90.21 | etc
2020-08-10 00:00:00 |  | 7.1 | 0.4 |  |  |  | 7.5 | 94.6666666666667 | 5.33333333333333 | 8 |  |  |  |  | Employee: BatGirl | 90.54 | etc
2020-08-11 00:00:00 |  | 7.03 | 0.47 |  |  |  | 7.5 | 93.7777777777778 | 6.22222222222222 | 6 |  |  |  |  | Employee: Batman | 93.93 | etc
2020-08-12 00:00:00 |  | 6.92 | 0.58 |  |  |  | 7.5 | 92.2222222222222 | 7.77777777777778 | 6
2020-08-13 00:00:00 |  | 6.92 | 0.58 |  |  |  | 7.5 | 92.2222222222222 | 7.77777777777778 | 8
2020-08-14 00:00:00 |  | 6.97 | 0.53 |  |  |  | 7.5 | 92.8888888888889 | 7.11111111111111 | 4
2020-08-17 00:00:00 |  | 6.88 | 0.62 |  |  |  | 7.5 | 91.7777777777778 | 8.22222222222222 | 9
2020-08-18 00:00:00 |  | 6.97 | 0.53 |  |  |  | 7.5 | 92.8888888888889 | 7.11111111111111 | 9
2020-08-19 00:00:00 |  | 7.23 | 0.27 |  |  |  | 7.5 | 96.4444444444444 | 3.55555555555556 | 6
2020-08-20 00:00:00 |  | 7.23 | 0.27 |  |  |  | 7.5 | 96.4444444444444 | 3.55555555555556 | 3
2020-08-21 00:00:00 |  | 6.2 | 1.3 |  |  |  | 7.5 | 82.6666666666667 | 17.3333333333333 | 9
2020-08-24 00:00:00 |  | 6.7 | 0.8 |  |  |  | 7.5 | 89.3333333333333 | 10.6666666666667 | 7
2020-08-25 00:00:00 |  | 7 | 0.5 |  |  |  | 7.5 | 93.3333333333333 | 6.66666666666667 | 4
2020-08-26 00:00:00 |  | 6.97 | 0.53 |  |  |  | 7.5 | 92.8888888888889 | 7.11111111111111 | 7
2020-08-27 00:00:00 |  | 7.23 | 0.27 |  |  |  | 7.5 | 96.4444444444444 | 3.55555555555556 | 2
Totals: |  | 117.59 | 9.91 |  |  |  | 127.5 | 92.2352941176471 | 7.76470588235294 | 112
Employee: Wonderwoman |  |  | Supervisor: [NAME] |  |  |  |  | Organization:Mrs L
2020-08-03 00:00:00 |  | 7.28 | 0.72 |  |  |  | 8 | 91.0416666666667 | 8.95833333333333 | 8
2020-08-04 00:00:00 |  | 6.15 | 1.35 |  |  |  | 7.5 | 82 | 18 | 12
2020-08-07 00:00:00 |  | 7.2 | 0.3 |  |  |  | 7.5 | 96 | 4 | 5
2020-08-10 00:00:00 |  | 6.57 | 0.93 |  |  |  | 7.5 | 87.5555555555556 | 12.4444444444444 | 8
2020-08-11 00:00:00 |  | 6.93 | 0.57 |  |  |  | 7.5 | 92.4444444444444 | 7.55555555555556 | 9
2020-08-12 00:00:00 |  | 7.23 | 0.27 |  |  |  | 7.5 | 96.4444444444444 | 3.55555555555556 | 5
2020-08-13 00:00:00 |  | 6.92 | 0.58 |  |  |  | 7.5 | 92.2222222222222 | 7.77777777777778 | 13
2020-08-14 00:00:00 |  | 6.67 | 0.83 |  |  |  | 7.5 | 88.8888888888889 | 11.1111111111111 | 8
2020-08-17 00:00:00 |  | 6.38 | 1.12 |  |  |  | 7.5 | 85.1111111111111 | 14.8888888888889 | 8
2020-08-18 00:00:00 |  | 6.73 | 0.77 |  |  |  | 7.5 | 89.7777777777778 | 10.2222222222222 | 6
2020-08-19 00:00:00 |  | 6.85 | 0.65 |  |  |  | 7.5 | 91.3333333333333 | 8.66666666666667 | 8
2020-08-20 00:00:00 |  | 7.05 | 0.45 |  |  |  | 7.5 | 94 | 6 | 7
2020-08-24 00:00:00 |  | 6.83 | 0.67 |  |  |  | 7.5 | 91.1111111111111 | 8.88888888888889 | 5
2020-08-25 00:00:00 |  | 6.9 | 0.6 |  |  |  | 7.5 | 92 | 8 | 4
2020-08-26 00:00:00 |  | 6.85 | 0.65 |  |  |  | 7.5 | 91.3333333333333 | 8.66666666666667 | 5
2020-08-27 00:00:00 |  | 7.08 | 0.42 |  |  |  | 7.5 | 94.4444444444444 | 5.55555555555556 | 6
Totals: |  | 109.62 | 10.88 |  |  |  | 120.5 | 90.9820193637621 | 9.0179806362379 | 117
Employee: Iceman |  |  | Supervisor: Mrs Q |  |  |  |  | Organization: Mrs Q
2020-08-03 00:00:00 |  | 6.2 | 1.3 |  |  |  | 7.5 | 82.6666666666667 | 17.3333333333333 | 16
2020-08-04 00:00:00 |  | 6.85 | 0.65 |  |  |  | 7.5 | 91.3333333333333 | 8.66666666666667 | 10
2020-08-05 00:00:00 |  | 6.97 | 0.53 |  |  |  | 7.5 | 92.8888888888889 | 7.11111111111111 | 7
2020-08-06 00:00:00 |  | 7.08 | 0.42 |  |  |  | 7.5 | 94.4444444444444 | 5.55555555555556 | 11
2020-08-07 00:00:00 |  | 6.77 | 0.73 |  |  |  | 7.5 | 90.2222222222222 | 9.77777777777778 | 5
2020-08-10 00:00:00 |  | 6.92 | 0.58 |  |  |  | 7.5 | 92.2222222222222 | 7.77777777777778 | 11
2020-08-11 00:00:00 |  | 6.77 | 0.73 |  |  |  | 7.5 | 90.2222222222222 | 9.77777777777778 | 10
2020-08-12 00:00:00 |  | 6.9 | 0.6 |  |  |  | 7.5 | 92 | 8 | 5
2020-08-13 00:00:00 |  | 7.12 | 0.38 |  |  |  | 7.5 | 94.8888888888889 | 5.11111111111111 | 8
2020-08-14 00:00:00 |  | 6.93 | 0.57 |  |  |  | 7.5 | 92.4444444444444 | 7.55555555555556 | 8
2020-08-17 00:00:00 |  | 6.75 | 0.75 |  |  |  | 7.5 | 90 | 10 | 15
2020-08-18 00:00:00 |  | 6.92 | 0.58 |  |  |  | 7.5 | 92.2222222222222 | 7.77777777777778 | 7
2020-08-19 00:00:00 |  | 7.1 | 0.4 |  |  |  | 7.5 | 94.6666666666667 | 5.33333333333333 | 7
2020-08-20 00:00:00 |  | 6.98 | 0.52 |  |  |  | 7.5 | 93.1111111111111 | 6.88888888888889 | 6
2020-08-21 00:00:00 |  | 7.07 | 0.43 |  |  |  | 7.5 | 94.2222222222222 | 5.77777777777778 | 9
2020-08-24 00:00:00 |  | 7.07 | 0.43 |  |  |  | 7.5 | 94.2222222222222 | 5.77777777777778 | 14
2020-08-25 00:00:00 |  | 6.57 | 0.93 |  |  |  | 7.5 | 87.5555555555556 | 12.4444444444444 | 6
2020-08-26 00:00:00 |  | 7.08 | 0.42 |  |  |  | 7.5 | 94.4444444444444 | 5.55555555555556 | 4
2020-08-27 00:00:00 |  | 6.42 | 1.08 |  |  |  | 7.5 | 85.5555555555556 | 14.4444444444444 | 2
Totals: |  | 130.47 | 12.03 |  |  |  | 142.5 | 91.5438596491228 | 8.45614035087719 | 161
Employee: Wolverine |  |  | Supervisor:[NAME] |  |  |  |  | Organization: [NAME]
2020-08-10 00:00:00 |  | 6.77 | 0.73 |  |  |  | 7.5 | 90.2222222222222 | 9.77777777777778 | 9
2020-08-11 00:00:00 |  | 6.52 | 0.98 |  |  |  | 7.5 | 86.8888888888889 | 13.1111111111111 | 10
2020-08-12 00:00:00 |  | 6.38 | 1.12 |  |  |  | 7.5 | 85.1111111111111 | 14.8888888888889 | 13
2020-08-13 00:00:00 |  | 6.82 | 0.93 |  |  |  | 7.75 | 87.9569892473118 | 12.0430107526882 | 11
2020-08-14 00:00:00 |  | 6.28 | 1.22 |  |  |  | 7.5 | 83.7777777777778 | 16.2222222222222 | 10
2020-08-17 00:00:00 |  | 6.9 | 0.6 |  |  |  | 7.5 | 92 | 8 | 12
2020-08-18 00:00:00 |  | 7.17 | 0.33 |  |  |  | 7.5 | 95.5555555555556 | 4.44444444444444 | 11
2020-08-19 00:00:00 |  | 7.02 | 0.48 |  |  |  | 7.5 | 93.5555555555556 | 6.44444444444444 | 7
2020-08-20 00:00:00 |  | 6.83 | 0.67 |  |  |  | 7.5 | 91.1111111111111 | 8.88888888888889 | 11
2020-08-21 00:00:00 |  | 7.03 | 0.47 |  |  |  | 7.5 | 93.7777777777778 | 6.22222222222222 | 9
2020-08-24 00:00:00 |  | 6.02 | 1.48 |  |  |  | 7.5 | 80.2222222222222 | 19.7777777777778 | 8
2020-08-25 00:00:00 |  | 7.25 | 0.55 |  |  |  | 7.8 | 92.948717948718 | 7.05128205128205 | 6
2020-08-26 00:00:00 |  | 7.07 | 0.43 |  |  |  | 7.5 | 94.2222222222222 | 5.77777777777778 | 6
2020-08-27 00:00:00 |  | 7.17 | 0.33 |  |  |  | 7.5 | 95.5555555555556 | 4.44444444444444 | 3
Totals: |  | 95.23 | 10.32 |  |  |  | 105.55 | 90.2100110532133 | 9.78998894678667 | 126
Employee: BatGirl |  |  | Supervisor: Mrs Y |  |  |  |  | Organization: Mrs Y
2020-08-07 00:00:00 |  | 8.25 | 0 |  |  |  | 8.25 | 100 | 0 | 0
2020-08-10 00:00:00 |  | 7.92 | 0.33 |  |  |  | 8.25 | 95.959595959596 | 4.04040404040404 | 8
2020-08-11 00:00:00 |  | 6.8 | 0.7 |  |  |  | 7.5 | 90.6666666666667 | 9.33333333333333 | 7
2020-08-12 00:00:00 |  | 5.43 | 0.32 |  |  |  | 5.75 | 94.4927536231884 | 5.50724637681159 | 3
2020-08-13 00:00:00 |  | 4 | 0.5 |  |  |  | 4.5 | 88.8888888888889 | 11.1111111111111 | 3
2020-08-14 00:00:00 |  | 6.7 | 0.8 |  |  |  | 7.5 | 89.3333333333333 | 10.6666666666667 | 8
2020-08-17 00:00:00 |  | 6.95 | 1.3 |  |  |  | 8.25 | 84.2424242424242 | 15.7575757575758 | 7
2020-08-18 00:00:00 |  | 6.32 | 1.18 |  |  |  | 7.5 | 84.2222222222222 | 15.7777777777778 | 10
2020-08-19 00:00:00 |  | 4.7 | 1.05 |  |  |  | 5.75 | 81.7391304347826 | 18.2608695652174 | 5
2020-08-20 00:00:00 |  | 7.45 | 0.8 |  |  |  | 8.25 | 90.3030303030303 | 9.6969696969697 | 8
2020-08-21 00:00:00 |  | 6.47 | 1.03 |  |  |  | 7.5 | 86.2222222222222 | 13.7777777777778 | 7
2020-08-24 00:00:00 |  | 7.42 | 0.83 |  |  |  | 8.25 | 89.8989898989899 | 10.1010101010101 | 5
2020-08-25 00:00:00 |  | 6.77 | 0.73 |  |  |  | 7.5 | 90.2222222222222 | 9.77777777777778 | 6
2020-08-26 00:00:00 |  | 5.3 | 0.45 |  |  |  | 5.75 | 92.1739130434783 | 7.82608695652174 | 3
2020-08-27 00:00:00 |  | 8 | 0.25 |  |  |  | 8.25 | 96.969696969697 | 3.03030303030303 | 2
Totals: |  | 98.48 | 10.27 |  |  |  | 108.75 | 90.544061302682 | 9.45593869731801 | 82
Employee: Batman |  |  | Supervisor: Mrs A |  |  |  |  | Organization: Mrs A
2020-08-03 00:00:00 |  | 8.75 | 0 |  |  |  | 8.75 | 100 | 0 | 0
2020-08-04 00:00:00 |  | 8.75 | 0 |  |  |  | 8.75 | 100 | 0 | 0
2020-08-05 00:00:00 |  | 8.25 | 0 |  |  |  | 8.25 | 100 | 0 | 0
2020-08-06 00:00:00 |  | 8.25 | 0 |  |  |  | 8.25 | 100 | 0 | 0
2020-08-07 00:00:00 |  | 8.25 | 0 |  |  |  | 8.25 | 100 | 0 | 0
2020-08-10 00:00:00 |  | 7.72 | 0.78 |  |  |  | 8.5 | 90.7843137254902 | 9.2156862745098 | 5
2020-08-11 00:00:00 |  | 7 | 0.75 |  |  |  | 7.75 | 90.3225806451613 | 9.67741935483871 | 9
2020-08-12 00:00:00 |  | 6.83 | 0.67 |  |  |  | 7.5 | 91.1111111111111 | 8.88888888888889 | 7
2020-08-13 00:00:00 |  | 6.75 | 0.75 |  |  |  | 7.5 | 90 | 10 | 12
2020-08-14 00:00:00 |  | 6.98 | 0.52 |  |  |  | 7.5 | 93.1111111111111 | 6.88888888888889 | 6
2020-08-15 00:00:00 |  | 3.73 | 0.27 |  |  |  | 4 | 93.3333333333333 | 6.66666666666667 | 4
2020-08-17 00:00:00 |  | 6.53 | 0.97 |  |  |  | 7.5 | 87.1111111111111 | 12.8888888888889 | 11
2020-08-18 00:00:00 |  | 7.1 | 0.4 |  |  |  | 7.5 | 94.6666666666667 | 5.33333333333333 | 5
2020-08-19 00:00:00 |  | 6.87 | 0.63 |  |  |  | 7.5 | 91.5555555555556 | 8.44444444444444 | 8
2020-08-20 00:00:00 |  | 7.17 | 0.33 |  |  |  | 7.5 | 95.5555555555556 | 4.44444444444444 | 5
2020-08-21 00:00:00 |  | 7.2 | 0.3 |  |  |  | 7.5 | 96 | 4 | 5
2020-08-24 00:00:00 |  | 6.9 | 0.6 |  |  |  | 7.5 | 92 | 8 | 6
2020-08-25 00:00:00 |  | 6 | 1.5 |  |  |  | 7.5 | 80 | 20 | 8
2020-08-26 00:00:00 |  | 6.97 | 0.53 |  |  |  | 7.5 | 92.8888888888889 | 7.11111111111111 | 11
2020-08-27 00:00:00 |  | 5.37 | 0.13 |  |  |  | 5.5 | 97.5757575757576 | 2.42424242424242 | 2
Totals: |  | 141.37 | 9.13 |  |  |  | 150.5 | 93.9313399778516 | 6.06866002214839 | 104