Crew Scheduling: Run Reports from the Schedule
The Crew Scheduling module has its own set of reports, which you run from the Personnel > Schedule > Schedule tab. You can download most of them as an Excel or CSV file, or copy a link that another system can use to read the data. The Assignments by Vessel Report is a printable report instead.
For a tour of the schedule, see "Crew Scheduling: Introduction to Managing Schedules."
The Reports
You'll find the reports on the More actions menu at the right end of the schedule toolbar.
- Notifications History: The manual notifications you've sent to your crew. You can filter it by date, by who sent the notification, and by who received it. This report appears if your tenant uses manual notifications. See "Crew Scheduling: Send Manual Crew Change Notifications."
- Export Schedule Data: The schedules on the assets you choose, for a date range. The Excel file also counts the number of days each crew member spends onboard.
- Export Time Off Data: All the time off in a date range.
- Export Current Crew: Who is onboard your assets at a specific time. It uses the current time unless you choose another date and time. The report also shows what each crew member is doing at that time, based on their work rest records.
- Crew Change Report: The crew changes on the assets you choose, for a date range, with who is crewing on, who is crewing off, and who is onboard. In the Excel file, the crew change dates run along the top.
- Lay Days Report: Each crew member's lay day balance, day by day, for a date range, including the lay days accrued and withdrawn. You can narrow it by division, position, and payroll group. Its settings are on the Reports settings page. See "Crew Scheduling: Introduction to Setup."
- Assignments by Vessel Report: A printable report of who is assigned to each asset over the number of weeks you choose. It has one table for each week, with a row for each asset and the crew on each day listed by position.
Export a Report
Every report except the Assignments by Vessel Report downloads as an Excel file or a CSV file. The CSV file contains the raw data only. Where a report has summary tabs, they're included in the Excel file. To link another system to a report instead of downloading it, see Connect a Report to Another System.
To export a report
- Go to the Personnel > Schedule > Schedule tab.
- Click the More actions icon (⋮) at the right end of the toolbar.
- Click the report you want.
- Complete the fields. Some fields start filled in, such as the assets you're viewing on the schedule, and you can change them.
- Click EXCEL DOWNLOAD or CSV DOWNLOAD.
Some reports have extra options:
- Export Current Crew: To see who was onboard at another time, select Use Specific Date, then enter the Date and Time.
- Crew Change Report: Select Only Show Published to leave out unpublished crew changes. Select Include Only Crew Change People to list only the crew getting on or off, and leave out crew who stay onboard.
- Notifications History: Use the Sent By and Sent To lists to narrow the report to certain people.
Connect a Report to Another System
Every report window except the Assignments by Vessel Report also shows a CSV Connection String. This is a link that runs the report with the current data each time it's opened. You can paste it into a browser, or into another system that reads CSV data, instead of downloading a file.
To copy a report's CSV connection string
- Go to the Personnel > Schedule > Schedule tab.
- Click the More actions icon (⋮).
- Click the report you want.
- Complete the fields. The CSV Connection String updates to match them.
- Click the copy icon to the left of the CSV Connection String.
- Click CANCEL, or CLOSE on the Notifications History window.
Print an Assignments by Vessel Report
To print an Assignments by Vessel Report
- Go to the Personnel > Schedule > Schedule tab.
- Click the More actions icon (⋮).
- Click Assignments by Vessel Report.
- Complete the following fields:
- Start Date and Number of Weeks: The period the report covers. The Start Date defaults to today's date, and the Number of Weeks defaults to 1.
- Date Mode: Select Planned Dates, Actual Dates, or Actual Dates (fallback to planned), which shows actual dates where they exist and planned dates otherwise.
- Hide Crew Offs on Crew Change Days: When this is selected, crew leaving an asset aren't listed on the day they come off. It's selected by default.
- Filter By: Select Asset Group or Asset, then select the asset groups or assets from the list below it. The report remembers your filter selections the next time you open it.
- Contact Information to Include: Keep Phone and Email selected, or clear the ones you don't want in the report.
- Click APPLY.
The report opens in your browser's print window, where you can print it or save it as a PDF.