Wednesday Attendance
No data yet — import your .xlsx files to see trends
Needs Attention
Import attendance data to surface alerts.
Recent First-Timers
New faces this semester
First-timers detected from creation date on import.
Last Service Summary
No imports yet
Import a CSV to see last service breakdown.
Students are flagged Missing after 3 or more consecutive Wednesdays absent. Sorted by weeks absent.
Missing Students
—
All (3+ weeks)
🔴 3 weeks
🚨 5+ weeks
| Student | Weeks Absent | Last Seen | Attendance History | Status |
|---|
First-timers are identified by the First Time Students column in your Subsplash export — any student with NEW in that cell is flagged as a first-timer for that service.
All First-Timers
—
| Student | First Visit | Weeks Since | Return Rate | Current Status |
|---|
All Students
—
All
🔴 Missing
🟢 Active
✨ First-timer
| Student | Age | Gender | Status | Last Seen | Attendance % ↕ | Streak |
|---|
Weekly Attendance — Full Semester
Attendance Heatmap
Each row = one student · Each column = one Wednesday
Present
First visit
Starter
Absent
Volunteer Team
The Blend leadership team
| Name ↕ | Role ↕ | Email ↕ | Phone ↕ | Birthday ↕ | Status ↕ |
|---|
Subsplash Excel Import
Drop multiple .xlsx files at once to load the whole semester in one shot — one file per Wednesday service. The CRM will detect attendance, flag first-timers by creation date, track streaks, and surface who's been missing.
✅ Columns used: First Name, Last Name, First Time Students, Age, Gender, Date of Birth
📅 File name = service date (e.g. April 27.xlsx)
Step 1 — Drop your Subsplash files
You can drop multiple .xlsx files at once
📂
Drop all your Wednesday .xlsx files here
Or click to browse · Multiple files supported
Import History
| Service Date | File | Present | First-Timers | New Added |
|---|
No imports yet.
Starters — Wednesday Attendance
No data yet — import to see trends
Missing 3+ Weeks
Import data to surface alerts.
Full Semester Heatmap
Each row = one Starter · Each column = one Wednesday
Present
Absent
All Starters
—
| Name | Grade | Position | Status | Last Seen | Attendance % | Recent Weeks |
|---|
Import Starters Attendance
Drop .xlsx files — one per Wednesday. Columns needed: First Name, Last Name, Role
Drop your files
📂
Drop Starters .xlsx files here
Adult Volunteers — Wednesday Attendance
No data yet — import to see trends
Missing 3+ Weeks
Import data to surface alerts.
Full Semester Heatmap
Each row = one Adult Volunteer · Each column = one Wednesday
Present
Absent
All Adult Volunteers
—
| Name | Role | Status | Last Seen | Attendance % ↕ | Recent Weeks |
|---|
Import Adult Volunteer Attendance
Roster is pulled automatically from your Volunteers list. Just drop attendance files here — one per Wednesday. Columns needed: First Name, Last Name (Role optional)
Drop your files
📂
Drop Adult Volunteer .xlsx files here