Skip to main content
WeRecycle Resources

Submit a GHG Report via Spreadsheet

Attach Report as Spreadsheet

Select the ‘Attach Report as Spreadsheet’ tile on the Home page and then select the contract type applicable to the GHG emissions you are reporting.

clipboard_e7cf16d025f537a24470b364c9e15012e.png

clipboard_e7743edae55f58290054ca9a0d8171a10.png

Select ‘Download’ and save the template to your PC. The template must be downloaded separately for each contract type since they will display different originating sites and materials.

It’s best practice to download the template each time you report to ensure that you have the most up to date version.

clipboard_eebdb008412a6c585c3fe6fda9294a020.png

Open Excel Spreadsheet

The file may have opened automatically, if not, open the downloaded file. Please note:

  • The Excel file includes a simple macro
  • Clicking ‘Save Spreadsheet as TXT file’ will run the macro, creating a .txt file with your report information. This is the format you’ll upload into the portal.
  • If the ‘Enable Content’ appears, click to accept until there is no yellow bar remaining.

clipboard_e3b72fb9fa5e2a5cbef17248d6016695c.png

Using the Template

There are four sheets available in the Excel workbook:

  • Transporter_BOL_Data
    • This is where you’ll enter the data you are submitting.
  • Sample Data
    • Shows the format that the data needs to be entered in. The line items needed can be copy/pasted into the Transporter_BOL_Data tab.
  • Instructions
    • Provides an easily accessible overview of the template fields.
  • Originating Sites
    • Full list of all contract specific Originating Sites, easily transferable onto Transporter_BOL_Data tab

clipboard_eba9e1ac7797a2b2499821c18798360e6.png

Transporter_BOL_Data Tab Field Overview:

  1. *Contract Number is the number associated with your collection type (Curbside, Multi-family or Depot).
  2. *Document Number: Each report submitted must be given a unique identifier, up to 12 characters, which can include letters and numbers. This field is for your reference only.
  3. *Service Type will always be GHG.
  4. Reference & Comments (optional): Consider providing a document reference up to 12 characters. Consider providing a note for your report, up to 30 characters long.
  5. *Reporting Period Start & End: Indicate the start and end dates for report being submitted.
  6. *Originating Site Name is the name of the site you’re reporting for. Reference the sheet Originating Sites for exact formatting.
  7. Columns J, K & N are not required for GHG purposes.
  8. *Emission Type is a descriptor of what you are reporting. Please copy/paste from the Sample Data tab to ensure formatting accuracy.
  9. *Type of measurement will always be Percentage.
  10. *Percent attributed to Recycle BC should have all values as whole numbers.
  11. *Quantity - Quantity of emissions (calculated % for that unit of measure) for the applicable material.
    e.g. Total fuel usage is 1000 L. 80% of which is attributed to Recycle BC operations.
    % Attributed to Recycle BC = 80                 Quantity = 800

Only include the material lines you need to report and remove any additional lines.

The information in the Sample Data tab is for format reference only (reporting period start/end, originating site name, originating site postal code). Please see example below, the red arrows denote modified fields.

 

clipboard_ebd4992529f151b31c5737c8e91143546.png

clipboard_ee20e057ea0adbe4b489c110549250185.png

 

Once data entry is complete, click “Save Spreadsheet as TXT file” and change the name if desired.

Upload .txt File

You can drag and drop the .txt file into the ‘No files found’ area or click the ‘+’ sign to search for the file and attach it.

clipboard_e4a51f6fa21ec5a64f2a77f96f2ba2b92.png

Once file is uploaded, click ‘Continue’. If the file needs to be removed and re-added, select the ‘x’ icon.

clipboard_ea5e7446959b9b22ed34336eee6f9bbd0.png

File Upload Review

When a file is uploaded, a summary of information will be presented.

An ‘x’ indicates an issue with the applicable for within the .txt file. You can click on ‘Show All Messages’ to review all issues on all rows, or you can click on the blue hyperlink issue under ‘Issues’ to go line by line.

Review the issues outlined and correct the Excel file where necessary, saving a new .txt file version afterwards. Please contact Recycle BC if you require assistance.

clipboard_e6ba1baf71996bed34e4dbbb61344836e.png

clipboard_eb75a237762d4a7db73e0fa42f08b14ac.png

Green check marks indicate an error free submission. Review information for completeness and click ‘Submit Report Now’.

clipboard_e29abacb8577c4254928c1848f0230839.png

You’ll see a Processing Submission dialogue box. Processing time will depend on the number of line items included in the report.

clipboard_e1bf1fdfb9e8bd447baa4e9e8659c306d.png

Confirm and Download PDF/Excel Summaries

Your GHG report has been successfully uploaded! A summary of the report will appear on the screen, along with a unique 1800- Report Number. If you have any questions or concerns regarding your submitted report, this is the reference you’ll provide.

You can download the report in PDF or Excel form for your records.

clipboard_e140b5c6ea29af40023955ca3ad31bf04.png

  • Was this article helpful?