Spreadsheet: 823267d1679864848-calculating-100-attendance-for-a-sports-club-test-v2
Sheet: Sheet1

First | Last | 2023 Attends | Attendance | Activity | 04-Jan-23 | 11-Jan-23 | 18-Jan-23 | 25-Jan-23 | 01-Feb-23 | 08-Feb-23 | 15-Feb-23 | 22-Feb-23 | 01-Mar-23 | 08-Mar-23 | 15-Mar-23 | 22-Mar-23 | 29-Mar-23 | 05-Apr-23 | 12-Apr-23 | 19-Apr-23 | 26-Apr-23 | 03-May-23 | 10-May-23 | 17-May-23 | 24-May-23 | 31-May-23 | 07-Jun-23 | 14-Jun-23 | 21-Jun-23 | 28-Jun-23 | 05-Jul-23 | 12-Jul-23 | 19-Jul-23 | 26-Jul-23 | 02-Aug-23 | 09-Aug-23 | 16-Aug-23 | 23-Aug-23 | 30-Aug-23 | 06-Sep-23 | 13-Sep-23 | 20-Sep-23 | 27-Sep-23 | 04-Oct-23 | 11-Oct-23 | 18-Oct-23 | 25-Oct-23 | 01-Nov-23 | 08-Nov-23 | 15-Nov-23 | 22-Nov-23 | 29-Nov-23 | 06-Dec-23 | 13-Dec-23 | 20-Dec-23 | Total Attends This Year | Percent Attends This Year | 2023 Account
[NAME] | Wilson |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 999
[NAME] | [NAME] |  |  |  | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
[NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 0 | 10
Deanna | Coles |  |  |  |  | 999 | 5 | 5
Emily | Brooks |  |  |  | 5 | 5 |  | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
[NAME] | Vaughn |  |  |  |  |  |  |  |  |  |  |  |  | 999 | 5 | 5
George | Saunders |  |  |  | 5 | 5 | 5 | 5 |  | 5 | 5 | 5 | 5 | 5 | 5
[NAME] | [NAME] |  |  |  | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
[NAME] | [NAME]
Julia | [NAME]
[NAME] | Sunderland |  |  |  | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
[NAME] | Jones
Michelle | [NAME]
[NAME] | Smith |  |  |  | 5 | 5 | 5 |  | 5 | 5 |  | 5 | 5 | 5 |  | 5
[NAME] | [NAME]
Penny | Morgan |  |  |  |  |  |  | 5 |  | 3
Quenten | Harper |  |  |  |  |  |  |  |  |  |  |  |  |  | 999
Rowena | [NAME] |  |  |  | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 0 | 10 | 5 | 5
[NAME] | McIntosh |  |  |  |  | 5 | 5 | 5 | 5 | 5 | 5 |  | 5 |  | 5 | 5
[NAME] | Summers |  |  |  |  | 5 | 5 |  |  | 5 | 5 | 5 |  | 5 | 5 | 5
Una | Stubbs |  |  |  | 0 | 0 | 0 | 10 | 0 | 0 | 0 | 40 | 0 | 0 | 0 | 0
Victor | Hughes
[NAME] | Allerdyce |  |  |  | 5 | 5 | 5 | 5 | 5 | 5 |  | 5 |  |  | 5 | 5
Xavier | D'Anjou |  |  |  | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
Yvonne | Smith |  |  |  |  |  |  | 888 | 5 |  | 5 |  |  | 5
Zak | Barton
 | 2023 Members |  |  | Here today: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | < Today |  | Zero |  |  | Attends $
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | < £ Subs |  | Attends |  | 1
All names are made up to protect privacy |  |  |  | 100% Attendance so far: | 10 | 11 | 10 | 9 | 7 | 7 | 6 | 6 | 6 | 7 | 8 | 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | < 100% |  |  |  | 1-99%
 |  |  |  | Week No: | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | < Wk No |  |  |  | 0
 |  |  |  | New Attenders Each Week: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | < New |  |  |  | All
 |  |  | Monthly Attendance:
 |  |  | Monthly New Members:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Weeks to date: