# 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

Source: https://allyhub.com/docs/reference/cli/sheet-calc · AllyHub 0.10.0
Index of all docs: https://allyhub.com/llms.txt

## Usage

```bash
allyhub sheet calc [sheet] [what] [options]
```

## 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

| 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

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

## Examples

```bash
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
```

## Exit codes

`0` when it succeeds; the others are listed in [Exit codes](https://allyhub.com/docs/reference/cli/exit-codes.md).

## In the work

**sheets**: Making a sheet

[`sheet capabilities`](https://allyhub.com/docs/reference/cli/sheet-capabilities.md) → [`sheet import`](https://allyhub.com/docs/reference/cli/sheet-import.md) → `sheet calc` → [`sheet trace`](https://allyhub.com/docs/reference/cli/sheet-trace.md) → [`sheet diff`](https://allyhub.com/docs/reference/cli/sheet-diff.md) → [`inspect sheet`](https://allyhub.com/docs/reference/cli/inspect-sheet.md) → [`sheet`](https://allyhub.com/docs/reference/cli/sheet.md) → [`frames`](https://allyhub.com/docs/reference/cli/frames.md) → [`check`](https://allyhub.com/docs/reference/cli/check.md) → [`dev`](https://allyhub.com/docs/reference/cli/dev.md) → [`render`](https://allyhub.com/docs/reference/cli/render.md)
