Variables can be organized into several Sections in the spreadsheet view in Lucanet xP&A (Extended Planning & Analysis).

The first section in xP&A is always the Inputs section, this is not able to be renamed or deleted. Any variables that are in this section will show up in the Dashboard, and are able to be played with (i.e. adjusted) by viewers. If you do not want a variable to appear as an adjustable input, move it out of your model's Inputs section.

Model inputs can be in any section of a model!

Shows the 'INPUTS' section of a model's spreadsheet in xP&A, listing the variables 'Initial Customers' with a value of 100 and 'Subscription per month' with a value of 50.
Input section in the spreadsheet view

By default, there is one more section auto-created when you start a new model in xP&A, named Calculations. However, you can delete or rename that section, add more sections, colour your sections, and reorder sections as you wish.

Shows the '+' icon to add a new section below an existing section in xP&A's spreadsheet, highlighted in red with the tooltip 'Add Section Below'.
Add a new section

Easily add totals for a section in xP&A, which will automatically stay up to date as new variables are added, or existing variables are removed, from the section.

  • In the spreadsheet: hit the sum icon at the top of the group/section row.
  • On tables: add a group/section as a series to add its variables as well as a total row. (Hit the sum icon once added to see the total only, or variables only).
Shows the 'CALCULATIONS' section of a model's spreadsheet in xP&A, with the sum (Σ) icon highlighted in red at the top of the section row.
Automatic totals

Easily sum (or avg/min/max...) the variables within a section. Just type sum(Section Name) and xP&A will sum all the variables within that section. When variables are added to (or removed from) the section, the function (e.g. sum) will auto-update.

If you add a section to a table (as opposed to the individual variables), then the table in xP&A will automatically stay up to date as variables are added/removed from the section in the spreadsheet.

Shows the 'Setup' tab of the 'Expenses' pivot table in xP&A, with the 'Series axis' drop-down menu open showing 'Variables & Sum' selected, alongside the 'Variables' and 'Total only' options, and the date range set from 'Jan '24' to 'Dec '25'.
Sync Table with spreadsheet

Organise variables under their Section Name headers on tables in xP&A (within the Display settings).

Shows the 'Display' tab of a table's details in xP&A, with the 'Show group headers' and 'Show section headers' options highlighted in red.
Display settings for table headers

This content was generated using AI and reviewed by Lucanet subject matter experts before publication.