Customisation

NB: ROSTERkey includes a standard out-of-the-box Staffing Sheet. If this Staffing Sheet doesn't mean your organisation's needs, contact a ROSTERkey specialist, or a consultant from Shiftwork Solutions - the staffing sheet can be tailored to suit your specific requirements.


The Staffing Sheet

The Staffing Sheet is an Excel (.xlsx) report that shows worker allocations for a selected date range and department. It is downloaded directly from the Roster Administration page, if your organisation has Staffing Sheets available as an Additional Setting.



When the Staffing Sheet button is selected, the following popup appears: 

Staffing Sheets can be customised to show a range of dates, and can be downloaded on the spot if needed.


Out of the Box

The following screenshot shows ROSTERkey's out-of-the-box Staffing Sheet from a single day date range.


Saved Reports

Saved Reports allow you to schedule reports to be generated and delivered automatically. No need to manually download them each time.



When creating a Saved Report you provide a name for the configuration as well as default values that will be applied to the report when it is run.


Different From/To/Number Of Days/Reverse In Time values will initiate different report date windows as follows.  You can also indicate to reverse the dates


FromTo (inclusive)Number of DaysReverse In TimeReport Start Date
Report End Date (inclusive)
not providednot provided0 or not providednobeginning of current monthend of current month
not providednot provided0 or not providedyesbeginning of previous monthend of previous month
not providednot provided> 0nocurrent daycurrent day + Number of Days - 1
not providednot provided> 0yesNumber of Days before current dayday before current day
not providedprovided0 or not providedN/Abeginning of month matching the To monththe provided To date
not providedprovided> 0N/Athe provided To date less Number of Daysthe provided To date
providednot provided0 or not providednothe provided From dateend of month matching the From month
providednot provided0 or not providedyesbeginning of the month of the provided From datethe provided From date
providednot provided> 0nothe provided From datethe provided From date + Number of Days - 1
providednot provided> 0yesNumber of Days before the provided From datethe provided From date
providedprovidedN/AN/Athe provided From datethe provided To date


How It Works

At the scheduled time, ROSTERkey generates the staffing report and emails a link to the nominated recipients. Reports are available as Excel (.xlsx) or CSV depending on report type.


If a report fails to generate, an email notification is sent to you and the ROSTERkey support team.