Functions 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:
Control & Logical
assignIf, empty, exists, existsOrEmpty, ...
Scoring
linearMapping, pughSum, pughSumEx, topsis, ...
Tables & Columns
accumulate, groupBy, norm, paretoSum, ...
Matrices
getMatrix, identicalRows, ifSelected, isEmptyRow, ...
Layers
accumulatedstates, count, countinrange, extend, ...
Levels
leaflev, lev, outlev, parLev, ...
Hierarchical
hDistribute, hGet, hMax, hMean, ...
Properties & Access
getProperty, isPrimary, isState, setCondFormat, ...
Custom Lists
createEnum, findEnum, selection
Text
concat, list, strfind, text, ...
Date & Time
addTime, days, hours, minutes, ...
Arithmetic
In this group you can find all standard math functions, e.g. Sinus, Cosinus, etc.
Statistical
comb, geoMean, geoMeanE, harMean, ...
Linear Algebra
choleskyGetL, choleskySolve, condition, cov, ...
XY Scatter
criticality, diagramLookup, distHyperbolic, distTargetZone, ...
Sub Project
subSysCount, subSysMax, subSysMean, subSysMin, ...
File
beginOutput, browseFileName, createFolder, deleteFile, ...
App
alert, beep, colorCode, execute, ...
GANTT
earliestStart, groupTime, latestFinish, latestStart, ...
AHP
ahpMean, consistencyRatio, pairedComparison, spectralRadius, ...
QFD
benchmarkScaled, best, csi, gap, ...
FTA
ftaImportance, ftaProbability, ftaSensitivity
FMEA
fmeaAP, fmeaClass, fmeaNetFaultType, fmeaNetRating, ...
Quality
dpmo, isPoeFactor, poe, poeSensitivity, ...
Other
bomConceptCost, trizSolution