LCFS - Add new "UCI" column to Fuel supplier and Export compliance report inputs
- Dominant language
- Python
- Stars
- 6
- Forks
- 6
- Avg merge
- 2d 7h
- Merged PRs (30d)
- 87
Description
**Describe the task**
Add a new column titled "UCI" which is the additional CI attributable to use (UCI) - gCO₂e/MJ to the **Fuel Supply** and **Export** sections of the Compliance Report AG grids. This column will display UCI values based on fuel type and end use, organized in the format Fuel type | End use | EER. The UCI values apply to LNG and other relevant fuels, supporting compliance unit calculations as initially outlined with UCIs in card #574.
**Purpose**
To clearly represent the additional carbon intensity attributable to specific fuel uses in the Compliance Report. This column will improve transparency and accuracy in reporting by displaying UCI values (measured in grams of CO₂ equivalent per megajoule) directly in the AG grids for compliance.
**Acceptance Criteria**
- [ ] A new column, "Additional CI Attributable to Use (UCI) - gCO₂e/MJ", is added to the AG grids in the Fuel Supply and Export sections of the Compliance Report. Should be located to the direct right of the CI input column.
- [ ] The UCI column is automatically populated with the following numerical values, organized by Fuel type | End use | EER:
- LNG | Marine - General | 27.3
- LNG | Marine - Operated within 51 to 75% of load range | 17.8
- LNG | Marine - Operated within 76 to 100% of load range | 12.2
- LNG | Marine, w/ methane slip reduction kit - General | 10.6
- LNG | Marine, w/ methane slip reduction kit - Operated within 51 to 75% of load range | 8.4
- LNG | Marine, w/ methane slip reduction kit - Operated within 76 to 100% of load range | 8.0
- LNG | Unknown | 27.3
- LNG | Other | 0
- Other | All uses | 0
- [ ] Each entry correctly aligns based on fuel type and end-use criteria.
- [ ] The new column is accessible and accurately displayed for both IDIR and BCeID users.
**Additional context**
The new column's title and values are based on the "Additional CI Attributable to Use" metric in gCO₂e/MJ, providing clarity for LNG and other fuel types' carbon intensity in the Compliance Report. This task continues work initially documented in card #574.
Contributor guide
Research direction
Locate the Compliance Report AG grids and their Fuel Supply and Export sections, then trace the existing CI input column and fuel type/end-use handling. Done means the adjacent UCI column displays the specified values with correct alignment for both IDIR and BCeID users.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- python
- Domain
- full-stack
- Issue type
- Feature
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 45/100