LCFS - Update 'Target CI' lookup and compliance unit calculations

[airinggov]

Description:
Update the ‘Target CI’ lookup table/field to accept up to 5 decimal places and update the values based on the spreadsheet. Compliance unit calculations on the ‘Fuel supply’ and ‘Export fuel’ schedules should display as whole numbers in the table but retain the decimals in the background for more accurate totals in the Summary. The Summary will do a final rounding to a whole compliance unit value. Adding up the schedule values from the front end may not equal the value in the Summary but this is acceptable. Compliance units are never displayed with decimals but the Target CI column in the schedules should display the full decimal value. Card 2061 will create will run a script against existing 2024 reports including draft reports to recalculate using this new method.

Wireframe:
Carbon Intensity Calculations.xlsx

Purpose and Benefit to User:

• Ensures precise compliance unit calculations without introducing visible complexity in the UI.
• Enhances data integrity and reporting accuracy by maintaining decimals in the background.
• Aligns compliance unit reporting with regulatory and business expectations.

Acceptance Criteria:

• The ‘Target CI’ field allows up to five decimal places.
• Existing ‘Target CI’ values are updated to reflect correct decimal precision.
• Compliance unit values in ‘Fuel supply’ and ‘Export fuel’ schedules display as whole numbers while retaining decimals in the background.
• The Summary section rounds compliance unit values to whole numbers for final display.
• Target CI values remain fully visible in schedule columns.
• Summing frontend schedule values may not match the Summary due to background decimal retention.

Development Checklist:

• Modify database schema and input validation to support five decimal places for ‘Target CI’.
• Update existing data to conform to the new decimal precision.
• Implement logic to store and calculate compliance units with decimals but display whole numbers in tables.
• Ensure final Summary section rounds compliance units appropriately.
• Validate UI updates for displaying compliance units and Target CI correctly.
• Conduct testing to confirm that calculations remain accurate despite rounding rules.

Notes:

• Verify that backend calculations use the retained decimal values for accuracy.
• Coordinate with compliance and regulatory teams to confirm alignment with reporting requirements.

[airinggov]

@dhaselhan the target CI values for Gasoline and Diesel are flipped