bcgov / bcgov/lcfs

LCFS - Create backend data table for compliance reporting calculation titled 'Energy Effectiveness Ratios (EERs)- Diesel Category'

Open
#564 0 comments 0 reactions 0 assignees View on GitHub
Medium Story
Dominant language
Python
Stars
6
Forks
6
Avg merge
2d 4h
Merged PRs (30d)
87

Description

**Description:**
Create data tables to store the values needed to calculate formulas used in the compliance reporting feature of the LCFS portal. The two formulas used are:

1. Compliance units

![Image](https://github.com/bcgov/lcfs/assets/156380046/db3db672-3598-4334-948c-aec4728c657d)

2. Target carbon intensity

![Image](https://github.com/bcgov/lcfs/assets/156380046/9d1c1c83-2c31-4b5f-8c19-14b57015a649)

This data table created for compliance reporting calculations should be entitled 'Energy Effectiveness Ratios (EERs)- Diesel Category'

The data table should include the following column titles:

- Fuel type | End use | EER

The following inputs should be included in the rows:

- CNG | Any | 0.9
- Electricity | Battery bus | 3.8
- Electricity | Battery truck | 3.2
- Electricity | Cargo handling equipment | 2.5
- Electricity | Fixed guiderail | 2.9
- Electricity | Ground Support equipment | 2.5
- Electricity | Heavy Forklift | 3.9
- Electricity | Marine | 2.5
- Electricity | Shore power | 2.8
- Electricity | Trolley bus | 2.4
- Electricity | Other or unknown | 1.0
- Hydrogen | Fuel cell vehicle | 1.8
- Hydrogen | Other or unknown | 0.9
- LNG | Compression-ignition engine | 1.0
- LNG | Other or unknown | 0.9
- Propane | Any | 0.9
- All other fuels | Any | 1.0

Purpose and Benefit to User:

This table is part of a feature that enables the calculations needed in compliance reporting. The Energy Effectiveness Ratio (EER) is a measurement of efficiency which compares the useful work output of an engine running on a low carbon fuel (e.g., renewable diesel) to the engine output of the base fuel (e.g., fossil derived diesel) it is displacing.

More information about EERs can be found in the LCFS Technical Requirements Intentions Paper: https://www2.gov.bc.ca/assets/gov/farming-natural-resources-and-industry/electricity-alternative-energy/transportation/renewable-low-carbon-fuels/technical_regulation_intentions_paper_jan2023.pdf

**Acceptance Criteria:**

- [ ] Given I am a , When I am , then
- [ ] Given I am a , When I am , then

**Development Checklist:**
- [ ] A
- [ ] B
- [ ] C

**Notes:**

Contributor guide

Open the contributing guide

Research direction

The issue names no files, tests, or entry points. Start by locating existing compliance-reporting data-table models and migrations, then verify the title, columns, and 17 specified rows; done means the table stores all requested fuel, end-use, and EER values.

Written by the indexing model from the issue text.

Assessment

Tech stack
python
Domain
backend, database
Issue type
Feature
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
38/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.