Math

BuildSeries

Assembles up to ten individual numbers into a single column, in the order you supply them. Use it to hand-build a short series, such as scenario cases or a set of assumed cash flows, without creating a source table first.

Inputs

InputAcceptsRequired
V0Value (a single number)Yes
V1Value (a single number)Yes
V2Value (a single number)Yes
V3Value (a single number)Yes
V4Value (a single number)Yes
V5Value (a single number)Yes
V6Value (a single number)Yes
V7Value (a single number)Yes
V8Value (a single number)Yes
V9Value (a single number)Yes

Outputs

OutputProduces
ResultSeries (a list of numbers)

Settings

Typed in on the node or set by the assistant, not wired.

SettingDefaultNotes
Count5How many of the ten value slots (V0 through V9) to include, in order. Default 5, maximum 10.

Example

You want to test a project's return under three growth assumptions. Wire the NPV result of each scenario branch into V0, V1, and V2, say 1,850,000 (bear), 2,400,000 (base), 3,100,000 (bull), and set Count to 3. The three values become one column you can feed into a bar chart for a side-by-side scenario comparison, with a Labels input naming the cases.

Tips

Each slot takes either a wired value from another node (a Constant or an Aggregate result, for example) or is left empty, in which case it contributes 0. Count controls how many slots are read; leave it at the number of values you actually filled, or the extra slots pad the column with zeros. For series longer than ten values, start from a table column instead.

Related nodes