The generated Excel template is the standard monthly route for data, per asset and reporting year. Client admins, methodology owners and data providers (for their assets) can import.
Download and fill the template
- Data input → Excel import. Choose the Asset and the Reporting year.
- Under 1. Download template, tick Pre-fill with values already committed if you want the current values in the file, then click Download template.
- Fill the workbook in Excel. The Activity sheet has one row per monthly data stream, a Unit list, a Quality flag list (measured, calculated, estimated, gap_filled), one column per month and a Note. Other sheets hold compositions, production, events, energy and inventories.
- Locked months are grey and protected. Do not add, delete or move rows, columns or sheets.
A blank cell means “no data”; 0 means zero activity. A blank cell never overwrites a value that is already committed.
Upload, validate and commit
- Under 2. Upload completed workbook, choose the file (or drop it on the upload area) and click Upload and validate. The page shows the maximum file size.
- The Import job page opens with the steps Upload, Validate and Commit, and shows “Validating the workbook. This page updates automatically.”
- Validation failed means nothing was saved. Use the Findings table (filter by Severity, Sheet and Code; columns Cell, Message and Suggested fix), click Download findings workbook to get your file with the problem cells highlighted, correct the cells and upload again.
- Validation summary means the workbook passed. Check Rows per sheet (New, Changed, Unchanged). If there are warnings, tick “I have reviewed all warnings with codes … and accept them.” and click Acknowledge warnings.
- Check Preview changes (current value against new value), then click Commit import.
- The page shows Import committed and Recalculation queued. When the run status shows finished, the dashboards are up to date.
Errors block the commit. Warnings do not, but each warning code must be acknowledged, and the acknowledgement is recorded. Changed values are saved as new versions, so earlier values stay traceable.
Common findings
| Code | Type | Meaning |
|---|---|---|
| E004 | Error | The workbook structure was changed (headers, sheets, row order). Download a fresh template. |
| E006 | Error | A value was entered in a locked month. Request a restatement first. |
| E010, E011 | Error | Text in a number cell, or a negative value. |
| E012 | Error | Unit not allowed for the stream, invalid quality flag, or values with a blank unit. |
| E020 | Error | A gas composition does not add up to 100 mol% within the tolerance. |
| W030 | Warning | The month-over-month change is above your organisation’s threshold (Settings → General). |
| W031 | Warning | A month is blank for a stream that was active in that month. |
| W033 | Warning | The value differs from an already committed value; a new version will be created. |
| W040 | Warning | The change touches a submitted, reviewed or approved month, which returns to Open. |
What this means next to a finding explains its code on the job page.
Imports list
Data input → Imports lists every import job with File, Asset, Year, Uploaded, Findings and Status (Uploaded, Validating, Validated, Failed, Committed, Cancelled). Filter by Status, click a file name to reopen its job, or click New import.
Rules worth knowing
- Only one import can be open per asset and year. Finish it or use Cancel import before uploading another.
- Files with macros, external links, embedded objects or suspicious compression are rejected.
- The uploaded workbook is kept as evidence of the import.
- Your own spreadsheet layout can be imported with the Mapping wizard.