Romagen

Rota Matrix Generator and Enricher. Build a weekly matrix from shifts, then enrich it with your pasted employee IDs.

Process (build matrix)

Load your weekly files, set options, process once, then review the matrix.

Main shifts file

Drop your main shifts CSV

Select shifts file

Expected import headers: Employee ID, Employee, Group, Day, Date, Start Time, End Time, ...

Leave / holiday file (optional)

Upload leave for the same week as shifts

Select leave file

Example headers: Employee ID, Employee, Start Date, End Date, Type.

Normalize times ending in :01 to :00

Fill empty shift cells (staff with shifts) with Off

All rows are shown below. Scroll inside the table to review.

Paste your WFM extract and match it against the selected matrix using FourthID.

Select a matrix source, parse input, then run enrich.

Matrix Source

Drop a matrix file, select one manually, or reuse the processed matrix from Process.

Drop matrix CSV/XLSX

or Select matrix file

Paste Input Data Paste list or structured rows

Input delimiter

Deduplicate input (keep first row)

Keep digits only

Strip leading zeros

Trim spaces

Append matrix-missed rows to matched results

Results appear after you run enrich.

Run enrich to view results.

Activity Log

Import shifts (and optional leave), process once, review the matrix, then continue.