Create and View Spoil Reports

Permissions

All users can access the All Reports page (Menu > All Reports) and view spoil reports that they create, spoil reports shared with them by other users, and spoil reports that have been configured as public. All users can also edit their own spoil reports, but not those created by other users.

Create a New Spoil Report

To create a new spoil report:

1. Sign in to Virtual Superintendent.
2. Click Menu > All Reports. The All Reports page opens.
3. Click Create New Report. The Create New Report panel opens.
4. Click Spoil. The Spoil - New Report page opens.
5. Click the Clock icon in the upper-right corner. The date range selector opens.
6. Choose a report date range. The report updates.
7. Use the filters on the left side of the page to refine the report data. The report updates to display only matching spoil movements.

Each row in the report represents a single spoil movement of material from a load site to a dump site using data generated from several sources, including:

• Load information from fixed weighbridges (created using integrations), virtual weighbridge (VWB) dockets, driver-created dockets, gatekeeper-created dockets, and manually recorded load details entered by users with Spoil Admin permissions.
• Disposal information from driver-created dockets, fixed weighbridge dockets (created using integrations), and manually recorded load details entered by users with Spoil Admin permissions.

The data from these sources is compiled by Virtual Superintendent, calculated using data priority rules, and then displayed under the following report columns:

Movement

Load

Disposal

Allocation

Order

Manage column visibility

To show or hide columns you aren't interested in:

1. Hover your mouse over a column group heading then click the three-dot menu. A contextual menu opens.

2. Click Manage Columns. The column selection dialog opens.

   

   Click or tap to expand image

3. Toggle on or off individual columns.

   

   Click or tap to expand image

To hide individual columns:

1. Hover your mouse over a column heading then click the three-dot menu. A contextual menu opens.

2. Click Hide Column. The column is removed from the report.

   

   Click or tap to expand image

View individual spoil movement details

To view spoil movement details for individual hauler vehicles on a given day:

1. Sign in to Virtual Superintendent.
2. Click Menu > All Reports. The All Reports page opens.
3. Open an existing spoil report or create a new spoil report.
4. Click a movement row in the report. The Spoil Movement Details dialog opens.
5. Select a checkbox beside a movement. The bottom of the dialog updates, showing information about the selected movement and other movements by the hauler vehicle on that day.

The page displays:

• All spoil movements completed by the truck on the selected day at the top of the dialog. Each row represents a single movement.
• Edits made to the spoil movement by Spoil Admin users in a panel below the movements list (only shown if edits have been made).
• Load information for the selected movement in a panel at the bottom-left of the dialog. Change the movement shown in this panel by selecting a checkbox beside another movement in the upper movements list.
• Disposal information for the selected movement at the bottom-right of the dialog. Change the movement shown in this panel by selecting a checkbox beside another movement in the upper movements list.
• A Show next and previous days checkbox in the upper-right corner. Select this to update the report dialog to also show information about spoil movements from the day before and after the selected date (showing a total of three days of information).

If a spoil movement contains multiple load or disposal entries for a single spoil movement, all entries are displayed.

Data priority rules

When multiple data sources provide load and disposal information about the same movement, Virtual Superintendent uses priority rules to decide which of the conflicting values is shown in the spoil report.

When competing values exist and Virtual Superintendent has chosen a "winner", this is indicated with a green tick.

Load information typically prioritizes:

• Load site
• Material type
• Load time

Disposal information typically prioritizes:

• Disposal site
• Disposal time
• Weight

Where duplicate information exists, the most recent entry typically takes priority.

View weighbridge dockets

Virtual Superintendent automatically generates a weighbridge docket for each spoil movement. These are shown under the Docket ID column in spoil reports.

To open a weighbridge docket:

1. Sign in to Virtual Superintendent.
2. Click Menu > All Reports. The All Reports page opens.
3. Open an existing spoil report or create a new spoil report.
4. Select a docket link under the Docket ID column. The weighbridge docket opens.

Depending on the docket type, you can:

• Assign an engineer. Typically, these dockets are automatically assigned to a default supervisor set by Virtual Superintendent support in coordination with your project management team.
• Apply cost codes
• Review attachments

Report Settings and Filters

This section explains what filter options are available in reports, how to set a report date range, and how to toggle the color coding of rows on or off.

Using the report filters

Use the filter and settings panel on the left side of the report to name, configure, save and download a report and to control the data it contains.

Report settings

Filter settings

The report supports the following filters:

Report updates

The update icon (a green animated circle) in the upper-right corner of the report indicates when the data shown was last refreshed. Hover over the icon to view the exact update time.

Set the Report Date Range

Spoil reports support relative and absolute date ranges.

Relative date ranges

Relative reports are based on timeframe relative to the current date and time. Use relative date ranges for reports that you view regularly.

To set a relative date range:

1. Click the current date range in the upper-tight corner. The date range selector panel opens.

   

   Click or tap to expand image

2. Click Relative.

   

   Click or tap to expand image
3. Select a predefined date range. Examples include Today, This Week and the current Working Day.

Absolute date ranges

Use absolute date ranges for reports covering a specific period.

To set an absolute date range:

1. Click the current date range in the upper-tight corner. The date range selector panel opens.

   

   Click or tap to expand image

2. Click Absolute.

   

   Click or tap to expand image
3. Select a start date and end date on the calendar.
4. Click Apply Time Range. The report updates.

To specify a time range:

1. Select the From or To time field. The Select Time & Date dialog opens.

2. Select the required time.

   

   Click or tap to expand image
3. Click OK. The report displays data only for the selected date and time range.

Enable color coding

Color coding links chart data with the corresponding report rows.

To toggle color coding on or off:

1. Click the palette icon. The report and charts display matching colors for related data.

   

   Click or tap to expand image

Export Spoil Report Data

You can export spoil report data as Excel files and PDF files.

Export to Excel

To export an Excel file:

1. Apply any required filters.
2. Click the Download XLSX button. The Excel file downloads to your computer.

Users with Spoil Admin permissions can update supported fields in the exported template and upload it using the Upload XLSX button to perform bulk edits.

Export to PDF

To export PDF files:

1. Select the columns you want to include.
2. Click the PDF icon. The Processing Tasks dialog opens and begins the PDF generation process. When this process is completed, the PDF files are downloaded as a ZIP archive.