User Guides › Matrix Forge

← Previous: Admin User Guide Next: Formula syntax →

Matrix Forge (Calc Engine Guide)

The calc engine runs formula-based calculations in three phases: Variables (pre-calcs), Output Matrices (row-based grid calcs), and Output Variables (summaries and post-calcs). Formulas are written in a C#-like expression language evaluated by the engine.

Topics

  1. Formula syntax — How to reference form/flow data (Input), rates, data sheets, and row number (RowNum). Links to C# math and conversion APIs.
  2. Variables — Pre-calculations and re-used values (lookups, intermediates). Not included in schema output.
  3. Output matrices — Multiple matrices, row definitions, column formulas, and include/exclude from output.
  4. Output variables — Post-calcs, summarizing matrix columns, and stat calcs (sum, min, max, avg, etc.).
  5. Testing — Test tab: creating test data and running the engine.

User Guides › Matrix Forge

← Previous: Admin User Guide Next: Formula syntax →