gaqwheels.blogg.se

To use this argument to return the value of a specific element in a 1-dimensional cube (containing a structural dimension), use the form: “. It’s also possible to use this argument to return the name of a specific element in a cube containing one or more structural dimensions. Please see the Simulation example in the Dimensional Modeling chapter in Frontline Solvers User Guide for more information on this function.

If “vals” is passed for this argument, the result values will be displayed along with the dimension elements in the form of a relational or pivot table. If “dims” is passed for this argument, the Psi Statistic function will print all dimensions in the cube with their lengths so the user can be advised of the size of the cubes and will be able to estimate the range needed when entering the Psi Statistic function as an array formula. If omitted, all cube values will be printed in a single column.

Struc_format: This argument is an optional argument entered as a string. PsiAbsDev (cell,simulation,struc_format,param_slice) Two additional arguments are utilized when a Psi Statistic function is used with Dimensional Modeling: Struc_format and Param_slice. This is also known as Mean Absolute Deviation (MAD), especially in time series analysis applications. PsiAbsDev returns the average of the absolute deviations of the specified uncertain function cell’s sample values from their mean.