Skip to main content

 

Knowledge Base

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. 

A screenshot of a computer

AI-generated content may be incorrect. 

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. 

A screenshot of a computer

AI-generated content may be incorrect. 

It is recommended to download the spreadsheet each time to ensure you are using the most recent version available. 

A screenshot of a computer

AI-generated content may be incorrect. 

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. 

 

A screenshot of a computer

AI-generated content may be incorrect.

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'. 

A screenshot of a computer

AI-generated content may be incorrect. 

Unblock the file by checking the 'Unblock' box and click 'Apply' and then 'OK'. 

A screenshot of a computer

AI-generated content may be incorrect. 

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. 

A screenshot of a computer

AI-generated content may be incorrect. 

On the Transporter_BOL_Data tab, paste what was copied from the Sample Data tab and populate/adjust the additional fields: 

  1. Document Number 
  1. Reference/Supplemental text (Optional) 
  1. Service Date/Delivery Date (Change - default date is date of download)  
  1. Container ID (Leave blank) 
  1. Reporting Quantity 
  1. 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’. 

A data entry sheet with text and numbers

AI-generated content may be incorrect. 

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. 

 

A screenshot of a computer

AI-generated content may be incorrect. 

  • Was this article helpful?