Creating Variables Using AI

Getting Started

Global Functions

Administration

Extended Planning & Analysis (xP&A)

xP&A Video Tutorials

User Roles in Lucanet xP&A

Lucanet xP&A User Interface

All Steps at a Glance

Basic Concepts and Elements

Creating a Model

Integrating Data

Modeling Your Data

Creating and Editing Variables

Using Sections

Using Groups

Moving Variables

Referencing Variables From Linked Models

Aggregation Functions

Relative Time for Variables

Creating Variables Using AI

Creating and Editing Formulas

Working with Time

Using Dimensions

Using Currency and Currency Translation

Viewing and Visualizing Data

Working with Models

Using Comments and Descriptions

Comparison: xP&A vs. Excel Performance

Consolidation & Financial Planning

ESG Reporting

Disclosure Management

XBRL Tagger

Lease Accounting

Banking & Cash Management

Data Collection

Tax Compliance & Reporting

Glossary

xP&A offers different options for AI assistance when creating new variables. AI can be used to suggest new variables to be added to your model. It comes up with up to 5 suggestions for names and formulas completely on its own, including adding new hardcoded assumptions to then be used in its own calculations.

You can enable the AI assistance at model level or when creating new variables.

How it works

Based on the variables that you have in your model, AI makes suggestions for your next variable. The suggestions are based on names of the variables and on the formulas you are already using.

The following options to use AI assistance for creating new variables are available:

With the Ask AI menu, you can benefit from two different AI functionalities:

Suggest variables

With this option, you can ask AI to generate one-off suggestions for new variables based on your model.

To use it, click on the Ask AI button at the top of the spreadsheet and select Suggest variables. The AI-suggested variables will appear in the Inputs section:

Shows the spreadsheet of a model. Highlighted is the option 'Ask AI', four variables that have been suggested by the AI. — Suggest variables in the 'Ask AI' menu

Prompt AI

With this option, you can directly interact with the AI, asking for help with setting up certain calculations and analysis. The AI then suggests the variables typically used for these calculations.

To use it, click on the Ask AI button at the top of the spreadsheet and select Prompt AI. Enter your prompt in the text field and click Submit. The AI-suggested variables will appear in the Inputs section: