Skip to main content
B
BPP1-Visitor
1-Visitor
May 23, 2016
Question

Dependent equations

  • May 23, 2016
  • 11 replies
  • 3633 views

Hello everyone.

I want to express a set of equations as a function of some variables, to evaluate the results according to different input data.

PD: attached the spreadsheet with what I intend to do.

Thanks in advance.

11 replies

W
Werner_E25-Diamond I
25-Diamond I
May 23, 2016

One possible way to wade through the problem is to disable the green definitions at the top - you'll get alot of red errors now.

Now go through the whole sheet and wherever you encount an error, turn is into a function of the appropriate arguments, beginning with A.beam(d.beam):=...

When it comes to the solveblocks, instead of

you could use something like

WE

B
BPP1-VisitorAuthor
1-Visitor
May 23, 2016

Thanks for the help Werner

I tried to do what you told mebut appear errors and can not find the solution 

A
AlanStevens19-Tanzanite
19-Tanzanite
May 24, 2016

Perhaps the attached will help (though there is probably an error in it somewhere!)

Alan

W
Werner_E25-Diamond I
25-Diamond I
May 24, 2016

> (though there is probably an error in it somewhere!)

Yes, the solve block (function R.AB) doesn't do its job and simply returns the guess values (100 N).

The same is true if we delete the superfluous second line using "Find" in Bryans sheet, which throws the first error in his sheet.

I thought that the reason may be the range variable created in a function and used to sum up. But obviously thats not the case.

I also wonder why a solve block is used as the second equation can directly be solved for R.Ay.

WE

A
AlanStevens19-Tanzanite
19-Tanzanite
May 24, 2016

"Yes, the solve block (function R.AB) doesn't do its job and simply returns the guess values (100 N)."

That's odd.  It doesn't do that for me.  Here are the values before and after calling the solve block:

RAB.PNG

It is odd that both returned values are the same though (or is it?).

Alan

B
BPP1-VisitorAuthor
1-Visitor
May 25, 2016

Following the advice of each of you I think I've managed to get what I needed, thank you very much to all for the help.

Terms & ConditionsAccessibility statement