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
allyhub sheet calc [sheet] [what] [options]Arguments
Section titled “Arguments”| 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 |
Options
Section titled “Options”| 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 |
Global options
Section titled “Global options”--dir <value>: the project’s folder; default the one around where it is run. --json: print the result as JSON.
Examples
Section titled “Examples”allyhub sheet calc finance/budgetallyhub sheet calc finance/budget Summaryallyhub sheet calc finance/budget ordersallyhub sheet calc finance/budget 'Summary!B3:M3' --jsonallyhub sheet calc finance/budget revenue --scenario highallyhub sheet calc finance/budget 'revenue,Summary!B4' --scenariosExit codes
Section titled “Exit codes”0 when it succeeds; the others are listed in Exit codes.
In the work
Section titled “In the work”sheets: Making a sheet
sheet capabilities → sheet import → sheet calc → sheet trace → sheet diff → inspect sheet → sheet → frames → check → dev → render