Submit a PPP Report as Spreadsheet
Overview
Reports can also be uploaded via spreadsheet. Select the ‘Attach Report as Spreadsheet’ tile on the home page to begin.
Select the contract you’ll be working with from the list presented. If there is only one active contract, it will automatically select that contract.
It is recommended to download the spreadsheet each time to ensure you are using the most recent version available.
The template is a macro-enabled Excel file which will open automatically.
Excel Template Maintenance
[This section is content reuse]
Download the template, which is an Excel macro-enabled file.
Select ‘Enable Content’ if a yellow security warning dialogue bar appears.
If you see the red security risk warning below, please follow these steps to enable the Excel workbook Macro.
Enable Macro
Please follow these steps to enable the Excel workbook Macro.
Close the open Excel file. Locate where the file downloaded. Right click on the downloaded file and select 'Properties'.
Unblock the file by checking the 'Unblock' box and click 'Apply' and then 'OK'.
Re-open the unblocked file and the red warning box will no longer appear. Select the “Enable Content” ribbon at the top to proceed.
Excel Template
Download the template, which is an Excel macro-enabled file.
Select ‘Enable Content’ if the Security Warning dialogue bar appears.
Navigate to the ‘Sample Data’ tab, which you can copy/paste from into the ‘Transporter_BOL_Data’ tab. The Service and Delivery dates will default to the date the template was downloaded. You will need to fill out the additional blank fields as they pertain to your reporting data.
On the Transporter_BOL_Data tab, paste what was copied from the Sample Data tab and populate/adjust the additional fields:
- Document Number
- Reference/Supplemental text (Optional)
- Service Date/Delivery Date (Change - default date is date of download)
- Container ID (Leave blank)
- Reporting Quantity
- Weight
Field Descriptors:
- Document Number: Key in your document or scale ticket number here. Please note that the document number is unique for each contract. You cannot submit the same scale ticket number on the same contract.
- Service Date: The date of the collection service, which must be before the delivery date.
- Delivery Date: The date on which the material is delivered to the post collection site.
- Reference: Optional field for any reference information.
- Supplemental Text: Optional field for supporting information.
- Originating Site: The Originating Site of the reported data.
- Destination Site: Destination Site of the reported data.
- Reporting Qty: Enter the data/weight being reported here.
- Weight (kg): Same as Reporting Quantity.
If there are extra rows that do not contain any reporting data, please delete them.
Once your report is complete, click ‘Save Spreadsheet as .txt file’.
Load .txt file into the Portal
Select the document to be uploaded by clicking the plus button on the right-hand side or dragging and dropping the file into the attachment section. Be sure to select the .txt version of the file.
Use ‘x’ to delete any unwanted documents. Click continue once finished.