Calculation Sheet

Create engineering calculation sheets for peer review

Overview

Calculation sheets are used by engineers to share their formulas and calculations in a format that is easy for others to review, to ensure correctness.

The calculation sheet shows the all the calculation steps to arrive at the final results.

The FormulaDesk Calculation Sheet feature allows the user to select the cells that contain the 'final results'. It then analyses them, finds all the preceeding formulas and creates a calculation sheet in a standardized format that shows all the preceeding steps and formulas.

Example File

The videos and usage scenarios on this page make use of this file, which you can download.

Steps:

Note: This feature requires that the formula cells and their optional extra associated information all exist in the same columns. The optional 'extra associated information' is:

• Description

• Variable name

• Formula or value

• Unit of measurement

• Comment

• Reference

1. Click the 'Calculation Sheet' button on the ribbon menu.

2. On the 'Column Layout' tab, specify the correct column that the formula's extra associated information is found in.

3. On the 'Cells' tab, select the cells that you want to be included in the calculation sheet. It doesn't matter if you also select 'preceeding' formula cells - they will be correctly processed by FormulaDesk.

4. Check the 'include all precedents' checkbox to automatically include all preceeding formulas and input cells.

5. On the 'Settings' tab, choose the options you want.

6. Click the 'Refresh' button to create the document.