gilles | Reputations

Hi 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...

Hi 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)...

Honestly, 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:...

Hi 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...

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...

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...

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...

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...

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...

I 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:...

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...

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. ...

This 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...

This 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...

Dear 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,...

Sorry Lyndsey, return DOES work IF you use it correctly!!! Return does not abort the script, but just the exits the current code bloc, NOT the entire script, as an unfamiliar user like me might expect....

I also did try "return", unfortunately, this does not work (e.g. the script just continues). Gilbert

Hi, In the real world Monte-Carlo-Modell, the model is growing. Still relatively simple, but a full recalc takes about 1.5 seconds. This seems not very long, but when you want to do 10'000 recalcs, it...

Hi, In my script, I check the user input, and in case I find something wrong, I want to inform the user (using "Alert()" to send a custom message) and then quit the script nicely. I did not find anything...