English
GermanFunctions and Formulas
How Formulas Work
Like any spreadsheet application, Qualica provides a set of calculation functions that can be applied to the cells in worksheets. Calculation functions in Qualica do not refer to single cells only. Instead, input and result of functions can be scalars, vectors, matrices and tensors of higher dimensionality. This makes it possible to add, move and delete columns or rows in a spreadsheet without thinking about function references.
Function Reference
Calculation functions are sorted into groups for different purposes. These groups are:
Arithmetic
In this group you can find all standard math functions, e.g. Sinus, Cosinus, etc.
Linear Algebra
CholeskyGetL, CholeskySolve, condition, count, ...
DFSS
benchmarking, best, BOMConceptCost, consistencyRatio, ...
Statistic
accumulateState, DPMO, FisherTest, geoMean, ...
Text
concat, list, strfind, text, ...
SixSigma
CPK, ispoefactor, pk, poe, ...
Graphical Analysis
disthyperbolic, disttargetzone
Logical
assignif, empty, exists, filter, ...
Date & Time
addtime, days, earlieststart, hours, ...
Comparison & Selection
Hierarchical
hdistribution, hget, hmax, hmean, ...
Status & Access
ahpmean, attributelookup, currentlayer, diagramlookup, ...
Subprojects
subsyscount, subsysmax, subsysmean, subsysmin, ...
Matrix Fill
accumulate, groupby, limit, markselected, ...
FMEA & FTA
failureclass, faulttree, fmbestaction, fmeaform, ...
File I/O
beginoutput, browsefilename, createfolder, deletefile, ...
System
alert, beep, colorcode, execute, ...