Skip to main content
T
tmartinka1-Visitor
1-Visitor
November 22, 2016
Question

automatical change of input

  • November 22, 2016
  • 3 replies
  • 1409 views

Hello,

i have question about repeating calculating of sheet. I would like to type a program where is important change input according on the result. Example.

a=1,1

X:=some equation

X=6

and it is less than I need, so I need to change the a argument. I need to by it automatically.

Thank you for answer.

Tomáš Martinka

3 replies

M
MJG1-Visitor
1-Visitor
November 22, 2016

A "solve block" is probably the closest to your request.  Look them up.

L
LucMeekes23-Emerald IV
23-Emerald IV
November 22, 2016

But for some cases, especially if you have a single equation, the root() function may work just as well.

An example:

So for x=1.165, f(x)=5.

Luc

T
tmartinka1-VisitorAuthor
1-Visitor
November 22, 2016

But saidly i have more complicated case. I am trying to use FEM for calculating of load capacity. So I have load classes and I need change classes automatically when is load from choose class less than allowed load..

F
Fred_Kohlhepp23-Emerald I
23-Emerald I
November 22, 2016

It might be challenging to do (it's impossible without seeing the sheet) but you might be able to rewrite your calculation as a function of the input.  It would then be possible to execute one or both of the options above.

Terms & ConditionsAccessibility statement