ZorantaGuides
Herebook

Herebook › Guides

Attendance Sheet Template: Layout, Codes and a Printable Version

A working attendance sheet needs three things: a list of names down the side, one column per session across the top, and a short code in each cell. Add a total and a rate at the end of each row and you have a register you can print or keep in a spreadsheet.

The layout below works for a class, a club or a team. Copy it, then adjust the codes and the number of columns to fit how often you meet.

A row of coat hooks with a scarf or cap on each and one empty hook

A simple attendance sheet template

This is a monthly sheet for a group that meets twice a week. Each row is one person, each column one session.

NameTue 3Thu 5Tue 10Thu 12Tue 17Thu 19Tue 24Thu 26PresentRate
Amira K.PPLPPEXP6100%
Ben O.PAPPAPXP571%
Chloe R.PPPPPPXP7100%
Dev S.APPLPPXA571%

Codes used: P present, L late, E excused, A absent, X session cancelled. The session on Tue 24 was cancelled, so it is left out for everyone and each person has 7 counted sessions. Late counts as present and Excused is left out of the rate, so Amira has 6 of 6 (100%), Ben 5 of 7 (71%) and Chloe 7 of 7 (100%).

Write your counting rule at the bottom of the sheet (for example "Late = present, Excused not counted"). Without it, someone else reading the sheet will calculate different rates.
Herebook

Herebook replaces the paper sheet with one tap per person for Present, Absent, Late or Excused, and works out each person's monthly rate. Get it on Google Play

Columns to include

ColumnWhy it is there
NameFull name or the name everyone uses. Sort it the same way every month so rows line up.
Date of each sessionThe date, not "Week 3". Dates make it clear which session was cancelled or moved.
A notes column or spaceFor short reasons such as "school trip" or "injured". Keep it brief.
Present countThe number of sessions attended, after applying your rules for late and excused.
RatePresent count ÷ counted sessions × 100.
Group total rowHow many people came to each session. Useful for room size, coaches needed or equipment.

Leave out what you will not use. A sheet with columns for contact details, payments and attendance becomes hard to read and is more personal data to look after.

Choosing attendance codes

Four codes cover most groups that are not schools: present, absent, late and excused. Add a code for a cancelled session so it does not look like everyone was absent.

Printable attendance sheet or Excel?

Printed sheetSpreadsheet (Excel, Google Sheets)
Taking rollFast with a pen, works anywhereAwkward on a phone; easier on a laptop
Totals and ratesWorked out by hand at the end of the monthFormulas do it, as long as nobody breaks them
Losing itCan be lost, rained on or left at the venueNeeds a backup or a cloud account
SharingPhoto or scanSend the file or a link

Setting up the sheet in Excel

  1. Put names in column A starting at row 2, and session dates in row 1 from column B.
  2. Use Data validation to allow only your codes (P, L, E, A, X) in the mark cells. This stops typos like "p " from being missed by formulas.
  3. In the Present column, add =COUNTIF(B2:I2,"P")+COUNTIF(B2:I2,"L") and copy it down.
  4. In the Rate column, divide by the counted sessions: =J2/(COUNTA(B2:I2)-COUNTIF(B2:I2,"E")-COUNTIF(B2:I2,"X")), formatted as a percentage.
  5. Add conditional formatting so A cells turn red and E cells grey. Patterns stand out at a glance.
  6. Copy the tab for each new month rather than adding columns to one long sheet.

For a printable version, set the page to landscape, fit all columns to one page wide, and repeat row 1 at the top of each page so dates stay visible.

Common mistakes

Herebook

Take roll without drawing the grid

With Herebook you paste your list of names straight from a spreadsheet or a chat, set your meeting days, and every tap is saved right away.

Get it on Google Play

iPhone version coming soon

More guides

All guides

Sources

Published by Zoranta, the developer of Herebook.