Quantrix Modeler

Over 50,000 users in thousands of companies have made the switch to Quantrix, the only platform that provides the flexibility necessary for powerful integrated modeling and analysis across all industries, including Corporate Finance, Real Estate & Investment, Energy, Agriculture and specialized Finance Quantrix Modeler and its calculation engine is the foundation for our multi-dimensional modeling platform

• based on a typical Quantrix model versus Microsoft Excel® spreadsheet **based on actual Quantrix customers reporting comparisons with Microsoft Excel® spreadsheets

BEYOND EXCEL

FINANCIAL MODELING SOFTWARE FOR SERIOUS MODELERS

Separate Structure from logic

Create models free from the burden of having to worry about the impact of the changes you make Formulas will automatically update to reflect new structure

Our real-time, in-memory, proprietary Java-based technology is proven across thousands of deployments, and trusted by some of the world’s largest organizations

Import and Export Data

Built in data import and export functionality ensures that you can always connect to the most current data and update it with a click of a button

Intuitive natural language formulas ensure users’ existing Excel® skills are transferrable, easing user adoption and eliminating the need for technical coding skills

The power of pivot tables except always at your fingertips Quantrix’s always-on pivot engine means you can pivot and summarize your data (including calculated fields) at any time – without having to re-write logic! You can write formulas in any view of the data and immediately pivot to see the result in a new way

Traditional spreadsheets use cell addresses — such as B2 for column B of row 2 — rather than meaningful names — such as Revenues or Expenses Anyone who has tried to read such formulas, whether written by someone else or oneself, knows how hard they can be to understand or verify Quantrix provides the most flexible modeling expression based syntax, allowing you to specify multi-dimensional slices of data, taking your analysis far beyond Data Analysis Expressions (DAX) and other similar paradigms

Quantrix’s natural language formula engine means you can write formulas referring directly the structure itself meaning that modifying a name will update all formulas for consistency – and more importantly one formula can calculate hundreds, thousands or even millions of cells With user features such as formula syntax highlighting and automatic type-ahead, writing and debugging formulas has never been easier! One of the most powerful concepts within Quantrix Modeler is the ability to link common structure Being able to keep your lists of items in sync across a model or even across a set of models means adding or changing a product, region, scenario or year is as easy as a single click – no more trying to track down every reference when making edits! Our cutting-edge dependency inspector allows users to focus in on the logic driving a model With a single click, interrogate the logic driving a particular value, see the values passed into the arguments with formula breakdown and finally; visualize and navigate to the dependencies for a clear picture of the data flow

Often the users of your model only need to access certain parts of the model such as assumptions and results Using our interactive presentation canvas you can easily organize multiple tables and charts, onto a free-form dashboard to give users a simple interface in which to interact with a model You can add tables, charts, built-in widgets, expressions, custom scripted actions, logos and branding to get the exact experience you users require

Separating the presentation from the structure and logic of the model allows you to model freely and efficiently without worrying about the final layout

Using the built in scripting language Groovy, you can manipulate Quantrix data structures to perform common automation tasks Adding buttons and logic to a user input is clean and easy With the ability to import/export scripting libraries, you can cut down on the amount of code you need to maintain

SEE PRICING FOR QUANTRIX MODELER REQUEST A FREE TRIAL OF QUANTRIX MODELER

• Play video Multi-dimensional matrices with always-on pivoting Multi-dimensional matrices with always-on pivoting
• Powerful range based formulae
• Play video Dynamically link structure across a model Dynamically link structure across a model
• Play video Visually navigate and traverse model logic Visually navigate and traverse model logic
• Play video Interact with the model using free-form dashboards Interact with the model using free-form dashboards
• Powerful model automation using Groovy scripts