| Asked a question Is a native Monte-Carlo functionality needed in Quantrix?Hi all! Yesterday during the Roadmap - Session of the Quantrix Dimension, there was a point about including native Monte-Carlo functionality in Quantrix. I was a bit intrigued by this, as I have developed... | November 15, 2023 | 2 |
| Asked a question Would a cell property „Protect cell from input“ (setable via expression) make sense?There are a series of input values in the model, which are specified by the modeler (in a sense of default values). Depending on privilege, the user may or may not change these default values. How can... | November 15, 2023 | 2 |
| Posted an answer SubroutinesHi Andrés, Did you watch the Dimension conference today? Ben Wake answered all these questions about the Expert mode to a user questions which was probably yours ... Ifnot, you might want to see the... | November 14, 2023 | 5 |
| Posted an answer Apple M3 supportThere is native support for M-processors since a year. I use it on a Apple M1, and it's great performance. Much faster than on PC. I've not tested on M3 tough. Gilles | November 14, 2023 | 5 |
| Posted an answer Delete Visible Rows in Large DataHi Jim, Did you try to do the delete-step with "Autocalculate = Off". I suppose (but not 100% sure) that deleting is step by step process, so it will eventually trigger recalculations and verifications... | March 6, 2023 | 5 |
| Posted an answer Sum of items: Get sum of all items to calculate one itemHi S A U, Thank you very much for your suggestion. It perfectly works! Lyndsey earlier suggested to me to use "summary". It looks to me that all three variants Final = Unscaled / sum ( forcelist (Unscaled:Comp:Percentage)... | February 9, 2023 | 5 |
| Posted an answer Sum of items: Get sum of all items to calculate one itemHonestly, this is not a marketing gag. But seems that always if I think hard how I could explain a problem to somebody (e.g. the board), it clears my head and I find the solution. So hope this helps somebody:... | February 8, 2023 | 5 |
| Asked a question Sum of items: Get sum of all items to calculate one itemHi there, I very often come along this question, which should be simple to answer. Each time I fail. And do an easy workaround. BUT ... how can this be done nicely? Typical examples: Calculate ratio... | February 8, 2023 | 2 |
| Commented on a post Cool, thanks for the hint! I just downloaded and successfully installed. It now shows correctly "Apple Chips" under application. I run first speed tests, it seems to double the calculation speed. Not the... | January 26, 2023 | 2 |
| Commented on a post Just successfully installed M1, the App now correctly shows "Apple Chips" in the application information screen. I did some performance measurements on my Monte-Carlo-Simulations: the speed increase is... | January 26, 2023 | 2 |
| Commented on a post Dear SAU, Thank you very much for suggestion. Looks really cool!! Unfortunately, it gives me just "Syntax error", without telling me why. Some questions: * What does mean to put a category in parathesis... | January 26, 2023 | 2 |
| Commented on a post Just successfully installed M1, the App now correctly shows "Apple Chips" in the application information screen. I did some performance measurements on my Monte-Carlo-Simulations: the speed increase is... | January 26, 2023 | 2 |
| Asked a question Access solver by scripting?Hi there, As far I see, it's not possible to access the solver by script? If it would, I could include it inside my Monte-Carlo-Simulation: draw random variables as an input (this are e.g. parameters... | January 26, 2023 | 2 |
| Posted an answer Setting a cell to a fixed valueI do not think now() does recalculate, if the test is false. So it would write time only once. Except if you force recalculate the model, then it will write empty. This is not what you want. So I suggest:... | January 26, 2023 | 5 |
| Posted an answer Models saved in v22.2 backwards compatible?Hi Jeff, Are you working on Windows? And sometimes you say you can open an V22.2 saved model on a V22.1.2 version? I'm working on Mac (M1-version), and model saved in V22.2 can NEVER be opened in V22.1.2... | January 9, 2023 | 5 |
| Posted an answer How to profile? How to find performance bottlenecks in your model?Thank you very much Brian! Ben gave me some hints where I might lose a lot of time. I tried to restructure my model accordingly, and it now runs significantly faster. My findings: Do not use INDIRECT. ... | December 31, 2022 | 5 |
| Posted an answer Monte Carlo SimulationThis is an old post, but since it can still be found on google, I want to add this: If you are interested in Stoachstic simulation in Quantrix, you should take a look at this post: Monte-Carlo-Simulation... | December 16, 2022 | 5 |
| Posted an answer True simulation capabilitiesThis is an old post, but since it can still be found on google, I want to add this: If you are interested in Stoachstic simulation in Quantrix, you should take a look at this post: Monte-Carlo-Simulation... | December 16, 2022 | 5 |
| Received an upvote | December 16, 2022 | 10 |
| Asked a question How-To do a Monte-Carlo-Simulation with Quantrix to add Risk and Uncertainty to PlanningDear all, Quantrix is an excellent tool to do business forecasting and planning. But planning often means deterministic extrapolation of the past. Unfortunately, the future has always been unpredictable,... | December 16, 2022 | 2 |