You can create custom fields or formulas within the model’s preset sections or field libraries. Fields representing direct measurements of emissions or sequestration should be marked accordingly to ensure they are included in roll-up calculations.
How To
Identify where you need to add custom fields or formulas to support your project.
Add formulas within the preset sections, or add fields within the preset field libraries.
📌 Avoid creating new sections or libraries unless specifically instructed.
For fields representing direct measurements of emissions or sequestration:
Edit the formula and mark the field as Direct Emission or Direct Sequestration.
Ensure that all direct emission and sequestration fields are included in the roll-up formulas that contribute to the final calculation.
Save your changes and test formulas with sample or actual data to confirm accuracy.
Summing Batch Fields
When referencing a batch-level field in a formula, you can optionally sum it to aggregate values across all batches. This is useful when you want to calculate a total value rather than performing per-batch calculations.
Example
SUM({Weight}) * {Emission Factor}{Weight}is a batch-level field (different for each batch).SUM({Weight})adds up all batch values into a single total.{Emission Factor}is treated as a constant applied to the aggregated weight.
Use this approach when your calculation should reflect the total of all batches rather than individual batch-level results.
Tips and Best Practices
Regularly check that all direct emission/sequestration fields are marked appropriately.
Use descriptive names for fields and formulas to maintain clarity.
Test formulas with sample inputs to ensure results match expected outputs before finalizing.