Get to the results you want to see in less time than you imagined
Data processing software has become more than just a quantitative tool to tell us how much is in a sample. Now with the immense volumes of data being generated in high-throughput environments, there is an increase in demand for these software tools to be able to filter and flag large amounts of data based on particular criteria, and it all needs to be easy to use and interpret!
With the intuitive and easy to use SCIEX OS software for quantitative and qualitative data processing, you can see through the chaos. The processing method’s Calculated Columns and Flagging Rules features allow the easy creation of useful flagging criteria. These features, along with the capability of being able to filter on each column in the Results Table, provide a “review by exception” experience.
Learn more about SCIEX OS software and the calculated columns, flagging rules, and filtering on columns in SCIEX University:
- Non-targeted Screening Data Processing Using SCIEX OS software (premium content)
- Quantitative Data Processing Using SCIEX OS software (premium content)
- Algorithms and Flagging
- Quantitation and Targeted Identification Data Processing Using SCIEX OS software (premium content)
Videos
- SCIEX OS software Calculated Columns Outlier Flagging Filtering
- SCIEX OS software IS Area Mean Flagging Rule
- SCIEX OS software Carryover Flagging Rule
Helpful operators and functions
Please note: formulas follow the order of operation rules
| Operator or Function | Description |
| / | Divides the preceding value by the following value. |
| * | Multiplies the preceding value by the following value. |
| – | Subtracts the following value from the preceding value. |
| + | Adds the preceding value to the following value. |
| ( ) | Specify the order of operation. Enclose calculations to be performed first in parentheses. |
| ABS | The non-negative value of a real number (x) without regard to its sign. Also referred to as modulus [x]. |
| COUNT | The number of items in a collection. |
| GET | The value for a specific component.
GET is not available on the calculator, but can be typed in the format: GET([Results-Table-column]; ‘Component-Name‘) |
| GETGROUP | The value for a specific transition in a group.
GETGROUP is not available on the calculator, but can be typed in the format: GETGROUP([Results-Table-column]; n), where n is the number of the transition in the group. Note: If no groups are defined on the Components page, then the GETGROUP functions treats all components as members of the same group. |
| INTERCEPT | The point where the graph of a function or relation intersects with the opposite axis of the coordinate system.
INTERCEPT is not available on the calculator, but can be typed in one of the following formats:
Note: If only one value is specified, then it is used as the Y value, and Actual Concentration is used as the X value. |
| MAD | (Median Absolute Deviation) A measure of the variability of a univariate sample of quantitative data. |
| MAX | The largest value in a collection. |
| MEAN | The sum of a list of numbers divided by the number of numbers in the list. |
| MEDIAN | The value that separates the higher half of a data sample, a population, or a probability distribution, from the lower half. |
| MIN | The smallest value in a collection. |
| SLOPE | A number that describes both the direction and the steepness of the line. Also referred to as gradient.
SLOPE is not available on the calculator, but can be typed in one of the following formats:
Note: If only one value is specified, then it is used as the Y value, and Actual Concentration is used as the X value. |
| STDEV | (Standard Deviation) A measure that is used to quantify the amount of variation or dispersion of a set of data values. |
| SUM | The sum of the list of numbers in a collection. |
RUO-MKT-18-10566-A
0 Comments