S A U | Reputations

Generic selectors
Exact matches only
Search title only
Search in content
Post Type Selectors
Answers
Questions

Welcome to the Quantrix Answers Community! This is a place for Quantrix users from around the world to share their questions, knowledge, and ideas. If you are posting a question, please include any accompanying information that might be useful to the reader (for example, a demo model or screenshot). Do not include any confidential information in your posts and remember that model attachments must be zipped. If your question is answered, please provide feedback! Providing feedback can help future users understand what’s worked. Thank you for being part of the Quantrix Community!

Please Note: A Quantrix team member will review new questions before publishing to the public. We hope this will reduce unwanted posts on our site.

Posted an answer
Set font and size for all matrices

The largest model I have has those specs: size on disk ... ~113 MB; number of cells ... ~33M (~31M calculated). The A-script took ~2.5 minutes to change the fonts in this model. Possible options...

4 days ago5
Received an upvote
5 days ago10
Posted an answer
Set font and size for all matrices

Before running the A-Script You must first set the value of Tools-Options-Scripting-Script Timeout to 6000 or more seconds. This defaults to 60 seconds. The value in Script Timeout is the number of seconds...

April 4, 20245
Received an upvote
April 4, 202410
Posted an answer
Set font and size for all matrices

Hi, try this script from the Scripting Console: * * Good luck

April 3, 20245
Posted an answer
Meditation on timelines

Gilbert, Your three approaches have Fusion* matrices with almost the same structure and calculate the same Items: CumAll, CumFuture and FromPrevious. Therefore, my formulas are suitable for all your approaches....

April 3, 20245
Posted an answer
Meditation on timelines

Hey Gilbert, Please take a look at my solution to your problem. Maybe you'll find answers to some of your questions here. * * * Good luck

April 2, 20245
Posted an answer
Creating a timeline using a set input year and a set stop year or number of intervening years

Hi all, creating a model's timeline by means of: a) the start year and end year: * * b) the start year and the number of years: * * Good luck

March 24, 20245
Posted an answer
Qloud Losing Formatting

Hello Mark! I see two problems here that I encountered back in 2014 in the export-import operations of the model to and from Excel. The font size always didn't match. Just like in your picture. I found...

March 22, 20245
Received an upvote
March 15, 202410
Answer was selected as best
March 13, 202410
Received an upvote
March 8, 202410
Posted an answer
How to exclude summary items in a cell reference?

Hi Gilbert, Modeling in QM can be greatly facilitated if you follow a few simple rules for structuring the model. The model consists of an input module, a calculation module, and a presentation module...

March 8, 20245
Commented on a post

Hi Gilbert, where in Marie's question is the indication of a better model structure? Marie has not disclosed the entire model or its logically complete module. So I can't say for her, is this structure...

March 1, 20242
Posted an answer
Lookup values with select

Hello, try this formula to get that you actually want: * * Good luck

March 1, 20245
Answer was selected as best
February 20, 202410
Received an upvote
February 20, 202410
Received an upvote
February 17, 202410
Posted an answer
Claculate product

Hi Marie, provided I understood you correctly: * * * Good luck

February 16, 20245
Received an upvote
February 16, 202410
Load More