Documentation
Reference for the building blocks of a Vireo model. The assistant works with the same nodes and functions listed here, so when you want to know exactly what a step in your pipeline does, this is the place to check.
Getting startedYour first model in Vireo, from imported data to result.The AI assistantHow to prompt, and how much the assistant may do on its own.Formula functionsEvery function you can use in a formula column.
Node reference
Transform
- FilterKeeps only the rows that meet a condition and drops the rest. Type a condition like Amount…
- SortReorders the rows of a table by one column, smallest to largest or largest to smallest.…
- GroupByCollapses a table into one row per group and totals the numbers, the way a subtotal report…
- PivotTurns a long list into a summary grid: one column supplies the row labels, another…
- UnpivotConverts a wide table, where periods or categories sit as column headers, into a long list…
- JoinCombines two tables side by side by matching rows on a shared key column, like a VLOOKUP…
- UnionStacks two tables on top of each other into one longer table. Columns are matched by name,…
- SelectColumnsKeeps only the columns you name and drops the rest. Useful for trimming a wide export down…
- RenameColumnsGives columns clearer names without touching the data. List the current names and the new…
- TransposeFlips a table so rows become columns and columns become rows (the same move as Paste…
- DeduplicateRemoves duplicate rows, keeping the first occurrence of each. By default two rows are…
- TopNKeeps only the highest (or lowest) N rows ranked by one column, such as the top 10…
- SamplePulls N rows at random from a table, the standard move for audit testing and spot checks.…
- SplitColumnBreaks one text column into several, splitting at a delimiter, the node version of Text to…
- MergeColumnsCombines two or more columns into a single text column, joining each row's values with a…
- ExtractColumnPulls one column out of a table as a list of values, ready to feed calculation nodes. NPV,…
Math
- ArithmeticCombines two numbers or two columns of numbers with a basic operation: add, subtract,…
- RandomGenerates a column of random numbers spread evenly between a minimum and a maximum. Useful…
- RoundRounds a number, or every number in a column, to a set number of decimal places. Use it to…
- AbsTurns every number positive by stripping the sign, on a single value or a whole column at…
- ClampCaps a number, or every number in a column, so nothing falls below a floor or rises above…
- MapRangeRescales a number, or every number in a column, from one range onto another, for example…
- AccumulateTurns a column of amounts into a running total: each row becomes the sum of everything up…
- DifferenceComputes the change from one row to the next: each value minus the value before it. Use it…
- PercentChangeComputes the percentage change from one row to the next, the growth rate between…
- InterpolateFills gaps in a column of numbers by estimating the missing values from their neighbors.…
- AggregateReduces a column of numbers to a single figure: the total, average, smallest, largest,…
- SeriesIndexPulls a single value out of a column by position: the first, the third, or, most usefully,…
- BuildSeriesAssembles up to ten individual numbers into a single column, in the order you supply them.…
Statistical
- RankAssigns a rank number to every value in a column, so you can see where each row stands…
- PercentileFinds the value at a chosen cut point in a column of numbers, such as the median or the…
- DescribeBuilds a one-glance summary table for a column of numbers: how many values there are, the…
- CorrelationMeasures how closely two columns of numbers move together, on a scale from -1 to 1. A…
- MovingAverageSmooths a bumpy column of numbers by replacing each value with the average of it and the…
- ZScoreFlags unusual values in a column by scoring each one on how far it sits from the column's…
- HistogramSorts a column of numbers into evenly sized buckets and counts how many values land in…
- RegressionFits a straight trend line through two columns of numbers and tells you how steeply one…
Financial
- TimeValueSolves a standard time-value-of-money problem: given a per-period rate, a number of…
- AmortizationBuilds a full month-by-month loan schedule from a principal, an annual rate, and a payment…
- NPVComputes the net present value of a series of cash flows at a fixed discount rate. The…
- IRRFinds the discount rate at which a series of cash flows nets out to zero present value.…
- DepreciationProduces a year-by-year depreciation schedule for an asset from its cost, salvage value,…
- CompoundGrowthGenerates a compound growth curve: a series that starts at an initial value and multiplies…
- ForecastSeriesProjects a single base value forward over N periods at a compound growth rate, producing a…
- WACCComputes the weighted average cost of capital from the equity/debt mix, the cost of each,…
- TerminalValueComputes the terminal value at the end of a forecast's explicit period, by either the…
- DiscountCashFlowsThe workhorse of a DCF: discounts a series of future cash flows to today and returns both…
- DebtScheduleModels a debt tranche paying down through mandatory amortization plus an optional…
- ActualizeSplices an actuals table and a forecast table into one continuous series at a cutoff date:…
- WaterfallAllocationAllocates each period's demand across a set of capacity-limited tiers in priority order:…
- ExtendForecastExtends a dated table with new future rows: it appends N periods past the last historical…
Text
- TextCaseConverts text to UPPER, lower, or Title Case. Its main job is cleaning up inconsistent…
- TextReplaceFinds every occurrence of one piece of text and swaps it for another. It matches the exact…
- TextSplitBreaks a piece of text into parts wherever a separator appears: a dash, a comma, or any…
- RegexExtractPulls a specific piece out of messy text by describing its pattern, such as an invoice…
Date & time
- DatePartsBreaks a date into its pieces (year, month, day, and day of the week) as four separate…
- DateDiffMeasures the gap between two dates, such as days to close a deal or months a loan has been…
- DateOffsetShifts a date forward or backward by a number of days, months, years, or hours. Use it to…
- DateSequenceGenerates a run of dates from a start date to an end date, a fixed number of days apart.…
Logic
- IfPicks one of two values based on a true/false condition, equivalent to Excel's IF. Connect…
- SwitchMatches a value against up to two cases and returns the result paired with the matching…
- CompareChecks two values against each other (equal, not equal, greater, less) and answers true or…
- AndOrCombines two true/false results into one: both must hold (And), at least one must hold…
- CoalesceReturns the first of its inputs that actually has a value, skipping any that are blank. It…
- ConstantHolds one fixed value (a number, a piece of text, or a date) and feeds it to anything…
- ParameterA named assumption with a default value. It behaves like a Constant, but carries a label,…
Visualization
- BarChartDraws a bar chart comparing values across categories, such as revenue by region or opex by…
- LineChartDraws values over time, the standard chart for revenue trends and cash balances. Connect a…
- PieChartShows how a total breaks down into parts, such as portfolio allocation or expense mix.…
- ScatterPlotPlots one measure against another, one point per row, to show whether two things move…
- KPICardShows a single headline number with a label, such as total pipeline or cash on hand, as a…
- DashboardArranges up to four charts into a single grid layout: the one-page view for a monthly…
Input
- SliderA draggable control that outputs a number between a minimum and maximum you set. It turns…
- DropdownA pick-one-from-a-list control. It outputs whichever option is currently selected, so the…
- TextInputA type-anything text box. It outputs whatever is entered, which makes it useful for text…
- CheckboxAn on/off toggle that outputs true or false. Pair it with an If node to flip a whole…
- DatePickerA calendar control that outputs the picked date. Use it wherever a model hinges on an…
- FileInputLoads a CSV or Excel file from disk and outputs it as a table, so a pipeline can start…