Tables & Formulas Spreadsheet Template

Sample spreadsheet template with usage of tables and formulas.

Sample Table & Formulas
This document provides a sample spreadsheet template with usage of tables and formulas.

Formulas referencing dynamic Fields
You can use formula cells in your template that refer to dynamic fields with placeholder. They will be calculated once you open generated spreadsheet:
Field 1:	{field1}
Formula referencing field 1:	=B6 + 10

In-Table Formulas
You can create a table with dynamic rows by binding each column cell with property name followed by # and name of table.
It is recommended to use named tables as you can reference other columns by name but you can also use regular formulas referencing other cells - they will be copied to new rows and adjusted automatically
Table Data
Product	Quantity	Price	Cost
{#table.product}	{#table.quantity}	{#table.price}	=B14*C14

Formulas Referencing Table
If you want to reference dynamic table data range where number of rows is not known you should use named table to reference whole column in table instead of specific cells range.
Average Price	=AVERAGE(table[Price])
Total Cost	=SUM(table[Cost])
Total Quantity	=SUM(table[Quantity])

Summary
This spreadsheet demonstrates how to use tables and formulas.
Remember to set the correct data types for each field and table column (number, string) to ensure that formulas work correctly.
You can add more rows to the table, and the formulas will automatically adjust to include the new data.

This document template includes dynamic placeholders for automated document generation with Documentero.com. Excel Template - Free download

Download Excel Template (.XLSX)

Customize Template

Download the Tables & Formulas template in .XLSX format. Customize it to suit your needs using your preferred editor (Excel, Google Sheets...).