Skip to content
Get started

allyhub sheet calc

What a sheet computes, without opening anything: a sheet, a range, a table, a name, or every sheet, as an aligned table

Terminal window
allyhub sheet calc [sheet] [what] [options]
Argument Type What it is
<sheet> string The sheet, by its file or its id in allyhub.yaml
<what> string A sheet (its used range), a range (Summary!B3:D3, or B3 on the first sheet), a table or a name; default every sheet
Option Type Default What it does
--all boolean false Every row, not the first 50
--scenario string Compute it with this scenario’s inputs (the sheet’s scenarios); nothing is written
--scenarios boolean false Compare the base case and every scenario: what is names, cells or ranges, apart by commas, a row each; default the names no scenario sets

--dir <value>: the project’s folder; default the one around where it is run. --json: print the result as JSON.

Terminal window
allyhub sheet calc finance/budget
allyhub sheet calc finance/budget Summary
allyhub sheet calc finance/budget orders
allyhub sheet calc finance/budget 'Summary!B3:M3' --json
allyhub sheet calc finance/budget revenue --scenario high
allyhub sheet calc finance/budget 'revenue,Summary!B4' --scenarios

0 when it succeeds; the others are listed in Exit codes.

sheets: Making a sheet

sheet capabilities → sheet import → sheet calc → sheet trace → sheet diff → inspect sheet → sheet → frames → check → dev → render

Was this page helpful?