SOR & BRE Open Shift Filter & Exporter

Input Data (Proto.csv / Schedule CSV)

Click to select or drag and drop schedule CSV file

Supports standard master schedule / Proto.csv files

Testing locally? You can load Proto.csv directly:

Export Column Mode:

Standard View (Exact 4 columns)

Date (WorkDate), Post Type, Shift Start, Shift End

Minimal (Date & Post Type only)

Date, Post Type

Full Original CSV Columns

All original columns with PostDescription sanitized

Filter & Masking Rules Enforced:

Unfilled only: Filters out filled shifts (EmployeeNumber must be blank).
No Satellite: Strips all -S shifts.
Excluded: Any hybrid shifts (Break Relief/GSOC, etc.).
Post Masking: 6-digit SOR IDs masked to SOR; -Sb01 preserved as SOR-Sb01.
CSV Export: Chronologically sorted by Date, then Start Time, with 2 delimiter rows (1 blank + headers) between distinct days.

Total Raw Rows -

Filled (Ignored) -

Unfilled Open -

Accepted Shifts -

CUP Shifts -

SV Shifts -

Filtered Shift Schedule 0 shifts 0 distinct days

Filter Date:

Filter Type:

#	Date (WorkDate)	Post Type	Shift Start	Shift End	Orig Post (Masked ID)
No schedule loaded. Upload a CSV file or load sample Proto.csv to begin.

Showing 0 rows

Export creates CSV grouped by date, sorted by start time, with 2-row breaks: [Blank Row] → [Headers]

Inter-Day Row Breaks (2 Rows):

When the export transitions to a new calendar date, it inserts:

11/13/2026, SOR, 15:00, 23:45, ... (Last shift of Day 1)

WorkDate, PostDescription, ShiftStartTime, ... <HEADER ROW>

11/14/2026, BRE, 08:30, 17:15, ... (First shift of Day 2)

Masking & Criteria Check:

JobNumber Location Mapping:
- 233265 → CUP SOR
- 235144 → CUP Break Relief Extra
- 266778 → SV SOR
- 267588 → SV Break Relief Extra
Filtered Out: Shifts with EmployeeNumber filled in (assigned).
Filtered Out: PostDescription ending with satellite tag -S (e.g. 255577-S, 261237-S, 261617-S).
Filtered Out: Hybrids or non-SOR/BRE (e.g. Break Relief/GSOC Hybrid, Pad).
SOR Masking: 6-digit SOR posts (e.g. 258171-Ap01, 262562) → CUP SOR or SV SOR.
Sb01 Exception: Posts like 261190-Sb01 → CUP SOR-Sb01 / SV SOR-Sb01.
BRE: Exact match for Break Relief Extra → CUP Break Relief Extra or SV Break Relief Extra.