Diagrammr

Roster To Calendar

Upload your links, select your line and download your shifts to your Calendar.

Diagrammr treats each PDF page, or each sheet in an Excel workbook, as a different fixed link. Pick your page, pick the line you start on, set the Sunday you join that line, and export everything through to the date you need.

Diagrammr is an independent tool. Every effort is made to keep exports accurate, but colleagues remain responsible for checking their roster and confirming when they are due to work.

Upload the roster PDF or Excel workbook.
Choose your link.
Confirm your line, start Sunday and export window.
Download the .ics file and import it into your calendar.

Step 1

Upload A Roster

Step 2

Choose Your Link

Each page below is treated as a different fixed link. Your calendar will stay on the page you choose and rotate only through the selected line on that page.

Step 3

Set The Export

Line This is the line on your chosen link page that you start on. Depot Code Required for Excel uploads so turn numbers can be prefixed correctly, for example EXS. Line Start Sunday Railway weeks run Sunday to Saturday. Export Through Usually the day before the next timetable change. Rest Days Rest Day Availability Best effort across calendar apps. Outlook support is strongest here. Automatic Cleanup Delete roster from the server after the .ics download Recommended for privacy. Turn this off only if you expect to make more than one export from the same upload.

Preview

First 3 Weeks From Your Selection

This preview follows the same weekly rotation that will be exported, so you can sense-check the next 3 railway weeks before downloading the calendar.

Happy with the preview? Download the .ics file and import it into your calendar. With automatic cleanup switched on, Diagrammr will remove the uploaded roster from the server as soon as the export is ready.