Attendance Sheet Maker

Anywhere a phone is a distraction or a liability — a classroom, a workshop floor, a rehearsal room — the roster on a clipboard is still the fastest way to take a register. This builds the grid; the pen is yours.

Attendance Sheet Maker — Printable Roster Grid by Date or by SessionBuildFigure

Dates or sessions

Calendar mode gives one column per day of a month, with the day number over the first letter of the weekday, and skipping weekends is on by default because most things that take a register do not meet on them. Weekend and holiday columns that do appear are shaded, so you are not left wondering whether the blank column means nobody came or nothing was scheduled.

Session mode numbers the columns 1 to N and says nothing about dates. It is the better fit whenever the meeting pattern is not every weekday: a class on Tuesdays and Thursdays for eight weeks is sixteen sessions, and sixteen columns you write the date into beats a 31-column month grid with two thirds of it crossed out. It also handles anything that meets irregularly, like a rehearsal schedule.

Paging, row height and long names

Thirty names go on a landscape sheet and longer rosters page automatically, with the heading, the column header and the legend repeated on every sheet so no page is orphaned. Row height is worked out from how many names are on the fullest page, so a class of twelve gets tall roomy rows and a class of thirty gets about 5 mm each. Numbering is continuous across sheets, which is what makes a two-sheet roster usable.

The name column is a fixed share of the width and long names wrap to a second line rather than being cut off. Sorting is whatever order you paste in — the tool does not reorder anything, so if you want alphabetical, sort before pasting. Pasting a column straight out of a spreadsheet works; blank lines are dropped.

About the holidays it marks

The federal list is computed from the rules rather than looked up in a table, so it is right for any year you print: the third Monday in January, the last Monday in May, the fourth Thursday in November, and so on. Fixed-date holidays that land on a Saturday are marked on the Friday before and ones that land on a Sunday on the Monday after, which is what the federal observed calendar does and what most banks follow.

That list is not your list. States add their own days, school districts run a calendar nobody else uses, and plenty of private employers work Columbus Day and Veterans Day while closing the Friday after Thanksgiving, which is not a federal holiday at all. Treat the marks as a starting point and put your own closures in the second box, one per line as a date and a label. Anything you type there wins over the federal name for the same day.

In calendar mode a marked day is shaded and named in the legend under the grid. If your group meets on a federal holiday anyway, turn the federal list off and put only your own closures in.

Marking it up

The legend printed under the grid is present, late, absent, excused. That is a convention rather than a rule, and if your organisation uses different letters, cross it out and write yours in on the master before you photocopy. The notes column on the right is for the things that do not fit a single letter: left early, make-up session owed, parent contacted. Turn it off to give the date columns more width when the month is long.

Questions people ask

Can I get only Tuesdays and Thursdays as columns?

There is no weekday filter in calendar mode. Use session numbering for the count of meetings you actually have and write the date at the top of each column — it comes out cleaner than a month grid with most of it struck through.

Does it hold the names between visits?

No. Nothing is stored and nothing is uploaded; refreshing the page clears everything. Keep the name list in a text file or spreadsheet and paste it in each time you need a fresh sheet.

Why 30 names to a page?

It is about the point where rows drop under 5 mm on a landscape sheet, which is too shallow to write a letter in cleanly. Below 30 the rows grow to use the space, so a class of 15 gets a noticeably more comfortable sheet.

Can I add a signature column for people to sign in?

Turn on the notes column and use it for signatures with a short roster — it is the widest column on the sheet. For a proper sign-in sheet with one wide signature line per person, a checklist with roomy spacing and the blank-line box shape is closer to what you want.

Related