www.modeler-forum.com
https://modeler-forum.com/

the mathematical functions available in the formula editor
https://modeler-forum.com/viewtopic.php?f=17&t=59		 Page 1 of 2
Author:  Kai [ Tue 23. Nov 2010, 10:22 ]
Post subject:  the mathematical functions available in the formula editor
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.
Author:  Kai [ Tue 23. Nov 2010, 10:25 ]
Post subject:  abs() formula
abs() calculates the absolute value of something to -6 becomes 6, -3 becomes 3 etc...

Attachments:
absFormula.cons [7.31 KiB]
Downloaded 1362 times
Author:  Kai [ Tue 23. Nov 2010, 10:27 ]
Post subject:  acc() formula
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
Author:  Kai [ Tue 23. Nov 2010, 10:30 ]
Post subject:  and() formula
and allows to extend conditions in an if() formula

Attachments:
andFormula.cons [10.55 KiB]
Downloaded 1475 times
Author:  Kai [ Tue 23. Nov 2010, 10:38 ]
Post subject:  average() formula
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 1415 times
Author:  Kai [ Mon 29. Nov 2010, 14:22 ]
Post subject:  averageE() and averageW() formula
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
Author:  Kai [ Mon 29. Nov 2010, 14:36 ]
Post subject:  date() formula
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
Author:  Kai [ Mon 29. Nov 2010, 15:04 ]
Post subject:  smooth1() smooth3() delay1() and delay() functions
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 1327 times
File comment: Deutsche Erläuterung bezogen auf Vensim
DelaysMillingPaper.pdf [276.11 KiB]
Downloaded 1237 times
delayANDsmoothFormulas.cons [22.45 KiB]
Downloaded 1427 times
Author:  Kai [ Mon 29. Nov 2010, 15:34 ]
Post subject:  gauss() formula
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 1468 times
Author:  Kai [ Mon 29. Nov 2010, 16:16 ]
Post subject:  modulo() formula
the modulo() formula returns the residue of a division .... like shown in the example

Attachments:
moduloFormula.cons [10.7 KiB]
Downloaded 1453 times
Page 1 of 2 All times are UTC + 1 hour [ DST ]
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/