Similar Posts
Petroleum Economics Modelling: Project Economics, Portfolio and Business Plan in One System
A petroleum economics system should value every project under every price scenario and participation case at the same time. It should roll the selected projects into a portfolio and turn that portfolio into the business plan, without copying a single spreadsheet. We build these systems in Quantrix for oil and gas companies, energy investors and…
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
“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…
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…
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…
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.
