From the Roster Administration page it is possible to export the roster as a ".xlsx" spreadsheet. Click the Download button to start the process.
You will then be prompted for several options:
- "Include Extra Info Column". This determines if a second column is added to each shift in the export. The extra column will include the role/crew/team etc. that is applicable to the employee on the shift.
- "Include Band Label". The roster bands will be shown in the export as they are on the Roster Administration page. If this option is ticked, then a header row will also be included on the export that shows the band labeling, e.g. "Week 1" etc.
- "Include Non Grouped Members". The Roster Administration page shows personnel that are not in the Group view selected (Crew/Role/Team) in a separate group, labeled "(none)", at the bottom of the view. These personnel can be excluded from the export if desired.
- "Put Legend On Separate Sheet". If selected, this will make the shift legend be written to a separate worksheet in the export. If not select, the legend will be on the same sheet as the roster, after all roster data is printed.
- "Weeks Per Panel". The export is able to spread the data over a number of vertical panels. This value is how many week in each panel. E.g. if the export view is for 6 weeks and this value set as 3, then the first three weeks will be printed across the top of the export and then the next three will be below those on the same worksheet.
This export can also available from the Work Roster page. This is a system setting and can be turned on or off by a request to the ROSTERkey support portal.