Successive solve blocks
- July 20, 2017
- 2 replies
- 6074 views
I have a few questions for our resident experts. I am working on a sheet that I'd like to have use multiple solve blocks. The first block feeds results to the second block. While I can do it - I wonder if there isn't a simpler way. It's rather cumbersome to set everything up this way.
I'm also curious about how MC works in regards to solving - as it seems sluggish. Is MC solving the same solve block over and over every time I call the functions (e.g. When I solve for L(alpha) and K(alpha) does it solve the 2nd block twice and the first block 4 times)?
Here's a picture of a very simplified version. MC4.0 attached. (note: actual sheet is 18 pages with dozens of variables and I'm using multiple blocks because using one block has become unmanagable. It also allows me to use existing calculation templates without merging calculations.)

Is there a better way?
Thanks,



