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

Feedback

Did you find what you needed?

If you have any further questions or suggestions to improve this page, please let us know:

=