Attendance Analyzer

Department

Drop your attendance files here

Absences · Shifts Worked · Shift Requests — all at once
Period 1
📋 Absences Report
Self-reported & staff-marked
⏱ Shifts Worked
Assigned vs. timeclock entries
🔄 Shift Requests
Drops, coverage, pickups
🕐 Timesheets
Actual clock in/out times
Period 2 (optional)
📋 Absences Report
Self-reported & staff-marked
⏱ Shifts Worked
Assigned vs. timeclock entries
🔄 Shift Requests
Drops, coverage, pickups
🕐 Timesheets
Actual clock in/out times
Roster
👥 Users Report
Emails & portal roles
Analysis Range
→
All dates
Live Data Periods
Period 1
→
Period 2 (starts after Period 1)
→
▶ Timezone & Advanced
Timezone
Utilities
▶ College Closed Days
Dates excluded from the "available slots" calculation in Prep & Closing. Auto-detected when no one has any P&C activity on a given date.
Auto-detected
Run analyze to detect
Add manually
None added
▶ Penalty-Free Days
School is not in session, but shifts may still occur. Missed/dropped shifts on these dates won't count against attendance. Shifts worked still earn full credit.
Start
End (optional)
None added
▶ Excused Absences
Mark a worker's emergency/excused dates. Their missed shifts in this range — dropped or not, covered or not — won't count against attendance. Shifts worked still earn full credit. Synced to the studio's server, so it follows you to any computer and re-applies automatically to every upload.
Worker
Start
End (optional)
Note (optional)
None added
Metric Notes
Absences Self-reported: reporter = employee
Staff-marked: reporter ≠ employee Attendance % Worked ÷ (Assigned + Picked Up + Covered by Others)
Worked = shifts with clock-in entry Shift drops Filled by Someone = accepted & covered
Left Open = canceled / denied / expired Penalty-Free Days Unworked shifts excluded from denominator. Clocked shifts still count as worked.
📂

Load live department data or upload reports to begin

Local files stay in your browser