Similar Posts
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…
Quantrix for Banks. Real‑World Banking Use Cases Powered by Quantrix.
Quantrix serves clients in over 50 countries across industries like real estate, investment banking, energy, and agriculture. Notable customers among banks and financial institutions include: From 8 Million Formulas to 500: How Morgan Stanley Scaled $265 Billion in Assets with Quantrix In the world of high-stakes investment banking, the difference between a calculated risk and…
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.
Script to change column width of an item or all items
This script designed to change the column width of items.
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.
