gilles | Reputations

Generic selectors
Exact matches only
Search title only
Search in content
Post Type Selectors
Answers
Questions
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...

5 days ago2
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...

5 days ago2
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...

5 days ago2
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...

5 days ago2
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...

5 days ago2
Posted an answer
Setting a cell to a fixed value

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

5 days ago5
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, 20235
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, 20225
Posted an answer
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...

December 16, 20225
Posted an answer
True simulation capabilities

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

December 16, 20225
Received an upvote
December 16, 202210
Asked a question
How-To do a Monte-Carlo-Simulation with Quantrix to add Risk and Uncertainty to Planning

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

December 16, 20222
Posted an answer
Abort script nicely

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

November 29, 20225
Posted an answer
Abort script nicely

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

November 29, 20225
Asked a question
How to profile? How to find performance bottlenecks in your model?

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

November 27, 20222
Asked a question
Abort script nicely

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

November 27, 20222
Answer was selected as best
November 18, 202210
Selected an answer as best
November 18, 20222
Posted an answer
Why do I need a Helper when I know the Item?

Here I post the updated sample model, containing all the solutions. Thanks again to "S A U" and Lyndsey! Happy modeling everybody! Gilbert

November 18, 20225
Posted an answer
Why do I need a Helper when I know the Item?

Dear SAU, I'm so sorry!! For an unknown reason the ":" went away in my formulas, so I wrote "=" instead of ":=", seems I was too tired last night! Now, both formulas work!! Thanks for all your explanations,...

November 18, 20225
Load More