Clinic Hours Reconciliation
Paste this clinic's sign-in and sign-out form responses. The tool matches them, backfills volunteer IDs from your roster and history, flags anything that needs your eyes, and writes the finished rows straight into Sheet 1.
1
Paste your existing Sheet 1 data
How the tool backfills missing volunteer IDs and continues the id_in / id_out sequence
Open the Volunteer Hours Public sheet, select all of Sheet 1 (including the header row), copy, and paste it below. The tool reads every past submission to find volunteer IDs by name, phone, or email, and to detect the highest id_in / id_out used so far.
Paste everything. Header row recommended but optional — the tool auto-detects it.
Paste Sheet 1 above, then click Load roster.
These auto-fill from the pasted Sheet 1. Override them here if you want the sequence to continue from a specific number.
2
Paste form responses
Copy the rows from each Google Form response sheet — header row optional
Select the sign-in response rows and paste here.
Select the sign-out response rows and paste here.
Load your roster above first for ID backfill and sequencing.