Period, location and pseudonymous person identifier.
← All templates
Attendance data and privacy · free CSV
Badge-data attendance analysis workbook
A privacy-conscious analysis structure for period, location, pseudonymous ID, event quality, qualifying-day decision, corrections, and retention.
Direct answer
What this template helps you do
A privacy-conscious analysis structure for period, location, pseudonymous ID, event quality, qualifying-day decision, corrections, and retention.
Inside the file
What the template includes
Event state, qualifying-day decision and data-quality flag.
Exception status without confidential reasons, correction state and retention end.
Best suited for
- Designing the minimum analysis table before importing badge-derived records.
- Making unknown, missing and corrected records visible.
- Preparing aggregate attendance or capacity analysis with a deletion date.
Use it well
Step-by-step instructions
- 01Approve the specification
Document purpose, authority, population, qualifying event, denominator, exclusions, access, corrections, outputs and retention before data is loaded.
- 02Use minimum necessary records
Keep raw access logs in the authorized source and import only fields needed for the approved analysis.
- 03Validate and correct
Mark outages, duplicates, missing events and unknowns; provide a documented correction route before reporting.
- 04Aggregate and delete
Produce the least detailed output that answers the purpose and delete or de-identify records at the approved retention end.
Make it fit
How to customize the working copy
- Replace example statuses with the approved local definitions.
- Add the policy version, data owner and review date used by your organization.
Boundaries
What this template does not replace
- The workbook does not make badge data accurate, necessary, lawful, proportionate, or suitable for performance decisions.
- Do not store confidential exception reasons or raw access credentials in the CSV.
Common questions
Common questions about Badge-data attendance analysis workbook
Should names be stored in the workbook?
Use a pseudonymous identifier where individual linkage is necessary and authorized. Keep the re-identification key separately with tighter access and delete it when no longer needed.
Can the workbook prove attendance?
It organizes an analysis; it cannot fix missing exits, shared access, forgotten badges, outages, off-site work, or a poor qualifying-day definition.
When should the file be deleted?
At the approved retention end or earlier when the identifiable detail is no longer necessary. Record the deletion or de-identification action.
An optional next step
When office-day planning needs one shared workflow
HybridTrack is the iOS companion for individuals who want a clearer office-day record and better hybrid schedule planning. Workplace teams can also discuss a coordinated employer workflow.
Download HybridTrack Discuss an employer pilot Available for iPhone. The website guides and tools remain free.