Juniper Systems Allegro CX Manual - Manual (Page 166)

166 Allegro CX Owner’s Manual
Dstdev(database, fi eld, criteria)
Estimates the standard deviation based on a sample, using the
numbers in the specifi ed database column matching the conditions.
Dstdevp(database, fi eld, criteria)
Calculates the standard deviation of a population based on the entire
population, using the numbers in the specifi ed database column
matching the conditions.
Dsum(database, fi eld, criteria)
Adds the numbers in the specifi ed database column matching the
conditions.
Dvar(database, fi eld, criteria)
Estimates variance based on a sample, using the numbers in the
specifi ed database column matching the conditions.
Dvarp(database, fi eld, criteria)
Calculates the variance of a population based on the entire
population, using the numbers in the specifi ed database column
matching the conditions.
Automating Tasks
The Tasks function allows you to create simple spreadsheet
applications (macros) to automate tasks.
Workbook Task Dialog Box
Use the Tasks function to defi ne, modify, and run automating tasks,
to open the Workbook Task dialog box, tap on Task | Workbook Task in
PTab.
The Task options are described below:
Run: Runs the selected task
New: Creates a new task
▲
‰
‰