# Brew sheet variables by batch report

The **Brew sheet variables by batch** report puts the values recorded or calculated on your brew sheets side by side, with a row for each batch and a column for each variable you choose. Use it to compare figures across batches, such as litre degrees at each stage of the brew.

Find it under **Reporting** → **Pre-built Production & inventory reports** → **Batches & production**.

## Running the report

1. Choose a date range.
2. Under **Which date should the date range apply to?**, choose **Brew date** or **Completion date**. If you choose the completion date, batches that are still in progress are left out.
3. Optionally, choose which beers to include. If you don't select any, all of them are included.
4. Under **Variables**, choose the [input variables and calculated variables](https://breww.com/docs/input-and-calculated-variables/) you want to see. The list is split into **Calculated variables** and **Input variables**, and you can type to search it.
5. Choose to view the report in your browser, or export it to Excel or CSV.

The columns appear in the order you choose the variables, so pick them in the order you want to read them.

## Reading the results

Each row is one batch, showing its batch number, beer, status and brew date, followed by a column for each variable. Input variables that are recorded in a unit show the unit in the column heading.

Check input variables show **Yes** or **No**.

### Batches with more than one brewhouse turn

If any batch in the report has values for a variable on more than one brewhouse turn, that variable gets a column for each turn, such as "Litre degrees, turn 1" and "Litre degrees, turn 2". Values recorded on a step that doesn't belong to a particular turn go in the plain column for that variable.

### Averaged values

If a batch has more than one value for the same variable and turn, for example because the variable is used in more than one recipe step, the report shows the average.

## Exporting

In an Excel or CSV export, durations are given in minutes, and the column heading says so, so you can work with them as numbers.

## Row actions

Each row offers **View batch** to open the batch.

## Seeing each individual record

This report shows one value per batch and variable. To see every individual value recorded, who recorded it, when, and whether the step was skipped, use the **Input variable records** report in the same section of the reporting dashboard.
