Catalog of Quanto spreadsheet functions registered in Spreado FunctionRegistry, with short descriptions from QuantoFunctionDescriptions. Workflow and export: Reports, import, and export.

Named context refs (use anywhere a sample path, compound name, or sample key is expected):

Name Meaning Example
Q.CurrentSample Current sample relative path =Q.Sample("SampleName", Q.CurrentSample)
Q.CurrentCompound Current compound name =Q.Compound("Peak.Area", Q.CurrentSample, Q.CurrentCompound)
Q.CurrentSmpKey Current sample key (Sample keys view) =Q.KeyCompound("Result.FinalConcentration", Q.CurrentSmpKey, Q.CurrentCompound)

Batch, method, samples

Function Description Example
Q.Batch Batch field (Name, DataPath, LastSaved, …) =Q.Batch("Name")
Q.Method Method field (Name, CalibrationMode, AreaThresholdPercent, …) =Q.Method("CalibrationMode")
Q.Sample Sample field(s) for path(s) =Q.Sample("SampleName", Q.CurrentSample)
Q.Samples Vertical list of sample paths (sort/filter) =Q.Samples("Acquired", "Type", "=", "Sample")
Q.SmpKeys Distinct sample keys in batch order =Q.SmpKeys()

Method lists

Function Description Example
Q.Analytes Analyte names in method order =Q.Analytes()
Q.Doses Dose names in method order =Q.Doses()
Q.AcqKeys Acquisition-set names =Q.AcqKeys()
Q.Quants Distinct QntKey values =Q.Quants()
Q.SampleTypes Sample-type names =Q.SampleTypes()
Q.AnalyteGroups Analyte-group names =Q.AnalyteGroups()
Q.SumGroups Sum-group names =Q.SumGroups()
Q.AnalyteTypes Analyte-type names =Q.AnalyteTypes()
Q.SampleGroups Sample-group names =Q.SampleGroups()

Compounds and results

Function Description Example
Q.Compound Compound / peak / result fields for sample × compound =Q.Compound("Result.FinalConcentration", Q.CurrentSample, Q.CurrentCompound)
Q.KeyCompound Chosen result within a sample-key group =Q.KeyCompound("Result.FinalConcentration", Q.CurrentSmpKey, Q.CurrentCompound)
Q.Compounds Compound names for sample(s), optional filter =Q.Compounds(, Q.CurrentSample, "Result.Concentration", ">", 0)
Q.AllCompounds Sample/compound columns across the batch =Q.AllCompounds(,,"Result.Concentration",">",50)

Q.Compound property paths include Peak.*, Peak.AutoInt.*, Peak.ManInt.*, Result.*, Level.*, Q1.* qualifiers, and related prefixes — see names-grid help in the designer.

Calibration levels

Function Description Example
Q.Level Level field for compound / level key =Q.Level("Concentration", , Q.CurrentCompound, $B$4#)
Q.Levels Level keys for sample/compound context =Q.Levels(, Q.CurrentSample, Q.CurrentCompound)
Q.AllLevels Level matrix or analyte/level-key lists =Q.AllLevels("Result.Concentration")

Sheet helpers

Function Description Example
Q.SheetName Worksheet name containing the formula =Q.SheetName()
Q.TemplateName Report template file name (no extension) =Q.TemplateName()
Q.RepeatCells Tile a source range =Q.RepeatCells(A1:B2, 2, 3)
Q.ByRowAndColumn LAMBDA over row × column vectors =Q.ByRowAndColumn(A1:D1, A2:A5, LAMBDA(r,c,r&"-"&c))
Q.VSearch Find text on sheets; return relative cells =Q.VSearch({"Results"}, {"Limit"}, {"R0C1"})

Show / hide blocks

Place in column A to hide rows or in row 1 to hide columns. Worksheet must contain HIDE in A1 to enable visibility processing. Use -- on spilled refs so blanks become numeric zero.

Function Description Example
Q.HideIfError Hide when values are errors =Q.HideIfError(--A1#)
Q.HideIfBlank Hide when values are blank =Q.HideIfBlank(--A1#)
Q.HideIfFalse Hide when values are FALSE =Q.HideIfFalse(--A1#>0)
Q.ShowIfTrue Show only when values are TRUE =Q.ShowIfTrue(--I5#>10)

(Same family as noted in the reports guide: HideIfError / HideIfBlank / HideIfFalse / ShowIfTrue.)

Visual plots (baked on export)

Function Description Example
Q.VSample Sample TIC plot in the cell =Q.VSample(Q.CurrentSample)
Q.VCompound Compound chromatogram =Q.VCompound(Q.CurrentSample, Q.CurrentCompound)
Q.VCalibration Calibration curve plot =Q.VCalibration(Q.CurrentSample, Q.CurrentCompound)
Q.VQualifier Qualifier overlay (0 = quant, 1 = all, 2+ = specific) =Q.VQualifier(Q.CurrentSample, Q.CurrentCompound, 1)

Related