Articles on: Checklists

Use spreadsheets inside checklists for TAB

You can use inline spreadsheets directly inside your checklists. This allows you customize the design and the values you need to obtain.

You can use Excel-formula's inside the spreadsheet.

General



You can copy-paste data directly from your local spreadsheets, or just write directly in the cells. Each cell can be customized with colors and font.

Input cells



You must select the cells which the user can input data into. You do that by using the button in the toolbar or by right clicking and select "Input field".

Formulas



It is also possible to use formulas to perform calculations. The available functions are: +, -, /, *, (, ), SUM(), AVERAGE(), &. To use a formula start by writing = in the cell followed by the formula.

General: Eg.: =C2+B2+(G3-G5)*2

Video






Guide



The screenshot below shows how to set up 3 solar panels including the values.

Input fields


Note that the three green columns (with a little pen) is the input-fields. You must select the fields, which the user can edit, and click the "Input-field".

Calculations


The purple fields are calculations (formula) which then are formatted as a percentage.

Example formulas


On the right side a couple of example formulas are shown.

Spreadsheet example

Updated on: 11/19/2023

Was this article helpful?

Share your feedback

Cancel

Thank you!