if you could create some snipshots that would be great

Week ending 2 May 2021 Results Name Hours Worked Sales Sales p/h Bob 5 2 Belinda 24 220 James 12 50 Peter 32 215 Kevin 18 70 Ava 30 130 Sally 38 370 Trevor 12 80 KPI Index Maximum Hours 0 - 2.0 10 2.01 -4.00 15 4.01 - 6.00 20 6.01 - 8.00 30 8.01 + 38 F G H 1 1 2 3 4 5 6 7 1. Calculate Sales p/h 2. Format sales p/h results to match KPI index 3. Calculate maximum hour allocation per team member 4. Calculate entire team sales per hour 5. Create email to go to team and senior management to appropriately communicate results - Include table of results, data sorted - Calling out positive results where appropriate - Calling out entire team results, good or bad? - Anything else you think is appropriate 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 po 26 27 28