Similar Posts
Welcome to the world of Multidimensional financial modelling
This article will introduce you a new, innovative way of financial modelling for your planning, budgeting, forecasting needs and running “what-if” analysis with multiple scenarios. Every controller faces complex modelling tasks in his/her daily work. Be ready to sit on driving seat, quickly and efficiently create your financial model. Multidimensional modelling is an alternative to…
Learn how to create Bullet Graph in Quantrix
Watch step-by-step instruction for building a Bullet graph in Quantrix. A bullet graph is a variation of a bar graph that shows progress towards a goal or performance against a reference line. A bullet graph consists of a featured measure (such as current revenue), a reference line (such as a target), and qualitative ranges (such…
Script to change column width of an item or all items
This script designed to change the column width of items.
Ultimate battle: XLOOKUP💥SELECT. Which one is going to win?🤔
XLOOKUP is promised to be the only Excel lookup function you need, mostly replacing VLOOKUP and INDEX & MATCH. But it has problems which I outline in this video.I cover 4 problems of Excel XLOOKUP and compare it to SELECT function of Quantrix Modeler.
Reorder items via script in Quantrix
It is possible to reorder items based on values via script (an example shown below). It should be clear that in a sorted matrix, Quantrix sees only original (unsorted) item position (index). One can check it by adding item with #category formula in the sorted matrix. So, concept of sorting and reordering somehow different.
Steve Jobs on Quantrix: The “Best Spreadsheet on the Planet”
„Best Spreadsheet on the Planet“: In a 1997 WWDC talk, shortly after returning to Apple, Jobs praised the Quantrix software and noted its superiority in modeling. Steve Jobs was a major proponent of Lotus Improv (the predecessor to Quantrix) during his time at NeXT, hailing it as a revolutionary, „best of breed“ spreadsheet application. He viewed…
