Gym attendance sheet in Excel, free to download.
Mark each visit, count visits per member and see who hasn’t come in for 10 days, in Excel or on paper. No sign-up.
Download the attendance sheet
Free, with no sign-up or email.
What’s in the sheet
A month of visits, and who has stopped coming.
-
A month at a glance
Type the month once, and the dates and weekdays fill in, 28 to 31 days.
-
One P per visit
Type P in a member’s row on each day they come in. Marked days are shaded.
-
Visits this month
Counted for each member, so you can see who comes often and who rarely does.
-
Last visit and days since
Days since turns bold once a member hasn’t come in for 10 days or more.
Using attendance to keep members
-
Mark at the door
Mark members as they walk in, not at the end of the day from memory.
-
Check days since every week
Sort by days since and call everyone at 10 days or more.
-
Look for zero visits
A member who paid but hasn’t come in this month needs a call before renewal time.
-
One sheet per month
Copy the sheet for each new month and keep last month’s for comparison.
Attendance in UsefulDesk
Check members in at the desk by name or Member ID, see the visits left on packs, and see who hasn’t come in for 10 days or more. Attendance in UsefulDesk.
Questions
Is it free? Do I need to sign up?
It is free. There is no sign-up and no email address to give.
How do I mark attendance?
Type the month at the top, then type P in a member’s row on each day they come in. Visits, last visit and days since fill themselves in.
How do I start a new month?
Copy the sheet: right-click its tab, choose Move or Copy, then Create a copy. Change the month and clear the marks. Keep one sheet per month in the same file.
Why 10 days?
A member who hasn’t come in for 10 days or more is often about to drop off, and a call can still bring them back. UsefulDesk uses the same 10 days for its At risk list.
Can I use it in Google Sheets?
Yes. In Google Sheets, choose File, then Import, and upload the Excel file. The visit counts and the days since work there too.
Can I bring this attendance into UsefulDesk?
No. UsefulDesk keeps attendance from each member’s first check-in in UsefulDesk. Bring your members in with the free member register, and attendance starts from your first day.
See who stopped coming without adding up the register.
Fourteen days free. Check members in at the desk, and see who hasn’t come in for 10 days or more.
Already using UsefulDesk? Log in