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, ...

Feedback

Did you find what you needed?

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

=