Parameters

Understand how parameters work in CalcTree and how they connect across different calculation sources.

In CalcTree, parameters are the core building blocks of calculations. Each source—such as a Python script, spreadsheet, or formula—defines its own parameters, which store inputs and results. These parameters can be linked across sources to create dynamic, multi-step calculations.

Sources and Parameters

• Sources define the logic and data for a calculation.

• Parameters are the named inputs and outputs within a source that carry values, results, or references.

Sources and Parameters

A single CalcTree Page may contain multiple sources, each with its own parameter set.

To learn more about setting up sources, see: → Create Calculations with Python → Create Calculations with Math Formulas → Create Calculations with Spreadsheets [coming soon] → Create Calculations with Uploaded Files

CalcTree uses Pages to organises calculation works. The CalcTree Page consists of a document and can contain a variety of calculations and data Sources.

Sources define calculation logic and data. Each source defines Parameters that hold calculated values.

• Sources: define calculation logic and data

• Parameters: hold calculated values and data of a source

Linking Between Sources

CalcTree lets you link parameters across sources, enabling more complex, chained calculations.

There are two types of linking:

• Python

• Math formulas

Reference another source’s parameter by simply typing its name.

Linking multiple sources

You can link multiple sources to create more complex calculations. That means a source picks up a result from another source and does more calculations on it. In order to link a source to other calculations, it needs to refer to the value of another source's parameters.

Source linking in CalcTree is done in two ways:

• Inside editable sources, by typing a parameter name of another source. This works inside Python editor and Math formulas

• Via assigning a parameter of another source into an input of one source. This is for sources that aren't editable on the CalcTree page i.e. Spreadsheets and Templates

Linking Python and Math formulas to other calculations

All parameters defined by all other sources are accessible by typing their names in Python editor or in Math formulas. That means you can simply refer to them by typing those parameter names. The following diagram illustrates this type of linking:

Linking to other sources inside Python scripts and Math formula editors

See examples of linking Python or Math formulas to other sources:

Create calculations

Python

Create calculations

Math formulas

Linking Spreadsheets and Templates to other calculations

To link a Spreadsheet or Template to other sources, you can connect a parameter of those other sources to an input of the spreadsheet or template. The following diagram illustrates this type of linking:

Linking to another source's parameters (a and b) by connecting them to Spreadsheet or Template inputs (x and y)

See examples of linking Spreadsheets or Templates to other sources:

Create calculations

Spreadsheets

Create calculations

Templates