How to create scenarios in Quantrix.
Онлайн-семинар Quantrix на русском.Часть 4. Создание сценариев в Quantrix 0:00 Представление – Таир Таиров, Smart Modeling Solutions01:05 Создание сценариев в Quantrix – Rich Lopez, Quantrix Authority
Quantrix Resources: Tutorials, Events, Solutions, Publications & Testimonials
-
-
Quantrix calculation algorithms, remote control of models and icongraphics.
Онлайн-семинар Quantrix на русском. Часть 3. Алгоритмы расчета, управление моделями и иконографика. Использование алгоритмов расчета, возможности масштабирования моделей и визуализация с помощью иконок в Quantrix – Таир Таиров, Smart Modeling Solutions
-
How to use Quantrix for budgeting in a retail business.
Онлайн-семинар Quantrix на русском. Часть 2. Опыт внедрения Quantrix для составления бюджета. 0:00 Представление – Таир Таиров, Smart Modeling Solutions01:20 Опыт внедрения Quantrix в TOO “Magnum Cash&Carry” – торгово-розничной сети №1 в Казахстане – Жибек Мамбетова, АССА, Заместитель финансового директора по финансовой отчетности и бизнес-процессам, ТОО «Magnum Cash&Carry».
-
Quantrix Webinar in Russian – Introduction and how to use Quantrix in a bank.
Онлайн-семинар Quantrix на русском. Часть 1. Вступление и опыт использования Quantrix в банке. 0:00 Вступление – Таир Таиров, Smart Modeling Solutions6:11 Использование Quantrix для стратегического планирования в банке – Михаил Прозоров, ПАО “БАНК УРАЛСИБ”30:10 Использование Quantrix для ad-hoc анализа в банке, Алексей Романов, ПАО “БАНК УРАЛСИБ”
-
Enhanced Filtering in Quantrix: Leveraging the ALL Dropdown and Improved UI
To enhance the filtering process and provide an option to show all items, user can consider adding an “ALL” item to the dropdown list (this can be done via concatlist() or the generate items feature). When a user selects “ALL,” the entire table will be displayed. This approach may be more intuitive for users, as…
-
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.
-
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.
-
“Revolutionary new program that may wind up stealing the show” – LA Times
This almost 30 years old article promises that Lotus’ Improv for Windows will change the way people create and look at spreadsheets. With Excel dominating the market, these amazing advantages of Lotus Improv are almost forgotten. But they are still valid today.Luckily, we have all these amazing concepts of Lotus Improv in Quantrix for those who want…
-
Use new $RoleName variable to create views assigned to each role
I think the most interesting way of using role names is in creating different views of the same Matrix based on the role. This means users with different roles will see different parts of the matrix assigned to them. We can do it by using the role name variable in filter expression. You save your…
-
Track Changes in Quantrix
Show changes directly on the matrix along with the date and user name using data from Audit Trail. This feature significantly increased transparency and enhance my model audit capacity.
-
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…
