www.modeler-forum.com • View topic - the mathematical functions available in the formula editor

View unanswered posts | View active topics

Board index » Wie geht das / How to ... » CONSIDEO MODELER

All times are UTC + 1 hour [ DST ]

the mathematical functions available in the formula editor

Page 1 of 2

[ 14 posts ]

Go to page 1, 2 Next

Print view

Previous topic | Next topic

Author

Message

Kai

Post subject: the mathematical functions available in the formula editor

Posted: Tue 23. Nov 2010, 10:22

Administrator

Joined: Fri 3. Sep 2010, 13:20
Posts: 300

Here we are presenting further explanations together with some examples of the use of the formulas. You may use the search-functionality of the forum to find them, e.g. looking for if(), min() etc..

Please do also add your examples and explanations of the formula as some of them are just of use for very specific challenges that Consideo itself has no experience with.

_________________
Kai Neumann

Consideo

Top

Kai

Post subject: abs() formula

Posted: Tue 23. Nov 2010, 10:25

Administrator

Joined: Fri 3. Sep 2010, 13:20
Posts: 300

abs() calculates the absolute value of something to -6 becomes 6, -3 becomes 3 etc...

Attachments:

absFormula.cons [7.31 KiB]
Downloaded 1361 times

_________________
Kai Neumann

Consideo

Top

Kai

Post subject: acc() formula

Posted: Tue 23. Nov 2010, 10:27

Administrator

Joined: Fri 3. Sep 2010, 13:20
Posts: 300

acc() does the same a level factor does. It summarizes values of e.g. a connected factor over time

Attachments:

accFormula.cons [5.98 KiB]
Downloaded 1433 times

_________________
Kai Neumann

Consideo

Top

Kai

Post subject: and() formula

Posted: Tue 23. Nov 2010, 10:30

Administrator

Joined: Fri 3. Sep 2010, 13:20
Posts: 300

and allows to extend conditions in an if() formula

Attachments:

andFormula.cons [10.55 KiB]
Downloaded 1474 times

_________________
Kai Neumann

Consideo

Top

Kai

Post subject: average() formula

Posted: Tue 23. Nov 2010, 10:38

Administrator

Joined: Fri 3. Sep 2010, 13:20
Posts: 300

average() allows to calculate a recent trend of a series of values. In the example file it is the average of the last three values.

Please note that the average for the first two results includes one or two values of zero ... ...

For an overall average see midvalue()

Attachments:

averageFormula.cons [5.81 KiB]
Downloaded 1414 times

_________________
Kai Neumann

Consideo

Top

Kai

Post subject: averageE() and averageW() formula

Posted: Mon 29. Nov 2010, 14:22

Administrator

Joined: Fri 3. Sep 2010, 13:20
Posts: 300

The averageE() and the averageW() formula both smooth a series of values... best shown by example

Attachments:

averageEuWFormula.cons [18.17 KiB]
Downloaded 1467 times

_________________
Kai Neumann

Consideo

Top

Kai

Post subject: date() formula

Posted: Mon 29. Nov 2010, 14:36

Administrator

Joined: Fri 3. Sep 2010, 13:20
Posts: 300

The date() formula allows to make calculations depended from a date, like shown in the example....

Attachments:

dateFormula.cons [8.77 KiB]
Downloaded 1475 times

_________________
Kai Neumann

Consideo

Top

Kai

Post subject: smooth1() smooth3() delay1() and delay() functions

Posted: Mon 29. Nov 2010, 15:04

Administrator

Joined: Fri 3. Sep 2010, 13:20
Posts: 300

The smooth1() smooth3() delay1() and delay() functions are all for certain, nonlinear delays that result in a sort of smoothing on values. Their benefits are best described with the example and the pdf-papers attached ....

Attachments:

File comment: English Paper based on Vensim

DelaysSmoothing.pdf [207.24 KiB]
Downloaded 1326 times

File comment: Deutsche Erläuterung bezogen auf Vensim

DelaysMillingPaper.pdf [276.11 KiB]
Downloaded 1236 times

delayANDsmoothFormulas.cons [22.45 KiB]
Downloaded 1426 times

_________________
Kai Neumann

Consideo

Top

Kai

Post subject: gauss() formula

Posted: Mon 29. Nov 2010, 15:34

Administrator

Joined: Fri 3. Sep 2010, 13:20
Posts: 300

The gauss() formula transforms a linear input-series to a gauss-shaped input-series. In practical terms that is probably needed for only a few, rather static calculations. For a real distribution of likelihoods you should refer to the description of the Monte-Carlo-simulation in our manual that comes with the MODELER.

Attachments:

gaussFormula.cons [6.02 KiB]
Downloaded 1467 times

_________________
Kai Neumann

Consideo

Top

Kai

Post subject: modulo() formula

Posted: Mon 29. Nov 2010, 16:16

Administrator

Joined: Fri 3. Sep 2010, 13:20
Posts: 300

the modulo() formula returns the residue of a division .... like shown in the example

Attachments:

moduloFormula.cons [10.7 KiB]
Downloaded 1452 times

_________________
Kai Neumann

Consideo

Top

Page 1 of 2

[ 14 posts ]

Go to page 1, 2 Next

Board index » Wie geht das / How to ... » CONSIDEO MODELER

All times are UTC + 1 hour [ DST ]

Who is online

Users browsing this forum: No registered users and 4 guests

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to: