Skip to main content
ppennington1-Visitor
1-Visitor
May 26, 2015 11:54 PM UTC
Solved

Automatic pulling of answers from a solver block

Hi

I'm working on a sheet which has a number of solver blocks. For clarity of work and for a concise summary, I want to pull the answers from the 'FIND' function out of the solver block. Currently I have to do this manually as I can't find a way of automatically outputting the values into the main body of the sheet. Does anybody know how to achieve this automatically?

Solver block issue.png

Thanks

StuartBruffAnswer
23-Emerald V
May 28, 2015 10:43 PM UTC

Phil Pennington wrote:

Thanks Stuart

This appears to provide the same outcome as the original formula however, as below. If I type Fcyl= outside of the solver block, although it does pull out the value automatically, it pulls out the complete matrix including the other 11 outputs, which isn't particularly helpful. I'm really looking to isolate each output in the same manner as I am currently manually typing in the image below

mcd export.png

OK.  You've got a few choices for dealing with this, I think. (I've only got the Prime Express, which doesn't allow access to solve blocks or programs).

Your Find statement will return all of the parameters you've asked it to do.  I assume you want all of them.

Either way, you need to define a (column) vector containing all of the names of parameters and in the order that you've put them.   You can then replace FCYL in the Solve Block with some arbitrary but meaningful name, such as Results, and then assign Results to the vector of names.  Alternatively, you could try just replacing FCYL with the vector of names inside the Solve Block.

Stuart

View in thread

4 replies

StuartBruff23-Emerald V
23-Emerald V
May 27, 2015 2:27 PM UTC

Instead of writing "Find(x,y,z)=", write "Results:=Find(x,y,z)" , or whatever variable name you want in place of "Result".

You can even write "f(a):=Find(x,y,z)" where a is a parameter that you use within your solve block.   I think this should be covered in the Help somewhere.

Stuart

Translate
    ppennington1-VisitorAuthor
    1-Visitor
    May 27, 2015 8:44 PM UTC

    Thanks Stuart

    This appears to provide the same outcome as the original formula however, as below. If I type Fcyl= outside of the solver block, although it does pull out the value automatically, it pulls out the complete matrix including the other 11 outputs, which isn't particularly helpful. I'm really looking to isolate each output in the same manner as I am currently manually typing in the image below

    mcd export.png

    Thanks

    Phil

    Translate
    StuartBruff23-Emerald VAnswer
    23-Emerald V
    May 28, 2015 10:43 PM UTC

    Phil Pennington wrote:

    Thanks Stuart

    This appears to provide the same outcome as the original formula however, as below. If I type Fcyl= outside of the solver block, although it does pull out the value automatically, it pulls out the complete matrix including the other 11 outputs, which isn't particularly helpful. I'm really looking to isolate each output in the same manner as I am currently manually typing in the image below

    mcd export.png

    OK.  You've got a few choices for dealing with this, I think. (I've only got the Prime Express, which doesn't allow access to solve blocks or programs).

    Your Find statement will return all of the parameters you've asked it to do.  I assume you want all of them.

    Either way, you need to define a (column) vector containing all of the names of parameters and in the order that you've put them.   You can then replace FCYL in the Solve Block with some arbitrary but meaningful name, such as Results, and then assign Results to the vector of names.  Alternatively, you could try just replacing FCYL with the vector of names inside the Solve Block.

    Stuart

    Translate
    Terms & ConditionsAccessibility statement