Similar Posts
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.
Willkommen in der Welt der mehrdimensionalen Finanzmodellierung
Dieser Artikel wurde im größten Fachportal für Controller im deutschsprachigem Raum – CONTROLLING-Portal.de veröffentlicht. Link zu Fachbeitrag In diesem Artikel wird eine neue, innovative Methode zur Finanzmodellierung für Ihre Planung, Budgetierung, Prognose und Durchführung von Was-wäre-wenn-Analysen mit mehreren Szenarien vorgestellt. Jeder Controller steht in seiner täglichen Arbeit vor komplexen Modellierungsaufgaben. Bereit sich auf den Fahrersitz zu…
Quantrix App Solution for Energy, Oil and Gas Planning and Petroleum Economics
Our solution help you to plan and evaluate projects including non-standard terms of Royalty/Tax, Production Sharing Agreements, complex acquisition or divestiture terms, gas-to-power option, etc. You can add different price scenarios, investment size and schedules, production profiles. Whether you acquire or sell assets, our customized app will help you understand the value of the projects…
Christmas tree as a Quantrix chart?!
Wishing you high values of Happiness, Love and Joy in 2022. This time with a Christmas tree chart (!) created in Quantrix #love #happiness #gobeyondexcel
Quantrix for Beginners: Build your first model
Getting started with Quantrix. In this video you will learn how to build multidimensional data model using Quantrix Modeler software. Step-by-step demo by Tahir Tahirov from Smart Modeling Solutions.
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.
