New calculated column functionality added to SCIEX OS software starting with version 3.3.1

日期: 10/03/2024
类别: SCIEX OS

0 投票数
   打印    评价文章:

For research use only. Not for use in diagnostic procedures.


Answer

Starting with the release of version 3.3.1, SCIEX OS software includes many new calculated column functions that were unavailable previously in the Calculated Columns section of the Analytics processing method. Below is a description of these new functions and how to use them.

For additional information regarding these functions and their syntax, please refer to the "Formula Page" within the Analytics pane help system in SCIEX OS software.

WILDCARD CHARACTERDESCRIPTION
?

A question mark (?) finds any single character.
Example: SEARCH('?ard';[Component Comment];1)
?ard finds "card" in the text "Test wild card characters (?) and (*)". The return position is 11.

Note: To search for a question mark (?), type a backslash (\) before the character. Example: SEARCH('\?';[Component Comment];1)
\? finds "?" in the text "Test wild card characters (?) and (*)". The return position is 28.
*

An asterisk (*) finds any sequence of characters.
Example: SEARCH('*ard';[Component Comment];1)
*ard finds "Test wild card" in the text "Test wild card characters (?) and (*)". The return position is 1.

Note: To search for an asterisk (*), type a backslash (\) before the character.
Example: SEARCH('\*';[Component Comment];1)
\* finds "*" in the text "Test wild card characters (?) and (*)". The return position is 36.

 
FUNCTIONDESCRIPTION
ACOS

Gets the angle with the cosine, which is the value of a results table column or the specified number. The ACOS function is not available on the calculator but can be typed.

ASIN

Gets the angle with the sine, which is the value of a results table column or the specified number. The ASIN function is not available on the calculator but can be typed.

ATAN

Gets the angle with the arc tangent, which is the value of a results table column or the specified number. The ATAN function is not available on the calculator but can be typed.

CEILING

Gets the smallest integer that is more than or equal to the value shown in the specified results table column or the specified number.

COS

Gets the cosine of an angle, which can be specified as the value of a results table column or as a number. The COS function is not available on the calculator but can be typed.

EXP

Gets e raised to the specified power, which can be the value of a results table column or the specified number.

FIND

Gets the position of the specified characters in the text in a standard or custom results table column. The FIND function does not support wild card characters.

FLOOR1,2

Gets the largest integer that is less than or equal to the number shown in the specified results table column or the specified number.

GETSAMPLE4,5

Gets values from a standard or custom results table column for the sample of the selected type.

GETSAMPLECLOSEST

Gets the value from a standard or custom results table column for the sample of the selected type with a value closest to the user-specified value.

GETSAMPLECLOSESTLOW 6,7,8,9,10

Gets the value from a standard or custom results table column for the closest sample of the selected type with a value less than or equal to the user-specified value.

GETSAMPLECLOSESTHIGH6,7,8,9,10

Gets the value from a standard or custom results table column for the closest sample of the selected type that has a value more than or equal to the user-specified value.

GETSAMPLEEQUAL6,7,8,9,10

Gets the value from a standard or custom results table column for the sample of the selected type with a value equal to the user-specified value.

IEEEREMAINDER

Gets the remainder that is the result of dividing a results table column or user-specified number by another results table column or user-specified number. The IEEEREMAINDER function is not available on the calculator but can be typed.

IN

Identifies if an element is in a set of values. If the element is in the set, then true is supplied. If the element is not in the set, then false is supplied.

INTERCEPT

Gets the point where the graph of a function or relation intersects with the opposite axis of the coordinate system.

ISNUMBER

Identifies a value in a cell in the results table as numeric or non-numeric. If the value is a number, then true is supplied. If the value is not a number, then false is supplied.

LEFT

Gets a specified number of characters from the start of the text.

LOG

Gets the logarithm of the specified number.

LOG10

Gets the base 10 logarithm of the specified number.

MAD

Gets a measure of the variability of a univariate sample of quantitative data. The MAD function is not available on the calculator but can be typed.

POW

Gets a specified number raised to the specified power.

RIGHT11,12,13

Gets the specified number of characters from the end of the text.

ROUND1,2

Rounds the number in the specified results table column or specified by the user to the nearest integer or specified number of decimal places.

SEARCH11,14,15

Gets the position of the specified characters in the text in a standard or custom Results. SEARCH supports the use of the wildcard characters.

SIGN

Gets a value that identifies the sign of the value of a results table column or the specified number. The SIGN function is not available on the calculator but can be typed.

SIN

Gets the sine of a specified angle, specified as the value of a results table column or as a number. The SIN function is not available on the calculator but can be typed.

SLOPE

Gets a number that identifies both the direction and steepness of the line. Also referred to as gradient.

SQRT

Gets the square root of the value of a results table column or the specified number.

SUBSTITUTE3,11

Makes a column in the results table that replaces an alphanumeric value with another one from a standard or custom results table column.

TAN

Gets the tangent of an angle, which can be specified as the value of a results table column or as a number. The TAN function is not available on the calculator but can be typed.

TRIM11

Removes extra spaces from text. All leading, trailing, and internal spaces, except for those that divide words, are removed from a standard or custom results table column.

TRUNCATE

Gets the integral part of a number in a results table column.

 
1The function can be used for functions inside functions and with user-specified numbers.
2The user-selected column to which these functions are applied must be in number format.
3Text used in this function is case-sensitive.
4If multiple samples have the same Sample Name, then the software supplies data from the first matched sample that is processed.
5If the specified Sample Name is not found in the results table, then the result is controlled by the option selected for Treat resulting text values as.
6The input value must be a numeric column.
7The function uses the precision of the numeric value in the stored data for the comparison not the precision configured in the results table.
8If multiple processed samples have the same input value, then the software supplies data from the first matched sample that is processed.
9If the specified input value is not in the results table, then the result is controlled by the option selected for Treat resulting text values as.
10Sample type selection is available for the input value. 
11The function can be used with other functions.
12The function can be used in number, text, or Boolean columns.
13The function is recommended for use in text columns.
14Text used inside this function is not case-sensitive.
15If the search string is not found, then the result is controlled by the option selected for Treat resulting text values as. If Treat resulting text values as is set to Original text, then the function gets N/A.

Comment

SCIEX Now 支持网络

一站式支持平台

SCIEX临床诊断产品线仅用于体外诊断。仅凭处方销售。这些产品并非在所有国家地区都提供销售。获取有关具体可用信息，请联系当地销售代表或查阅 https://sciex.com.cn/diagnostics。所有其他产品仅用于研究。不用于临床诊断。
本文提及的商标和/或注册商标的所有权，归属于AB Sciex Pte. Ltd. 或在美国和/或某些其他国家地区的各权利所有人。Beckman Coulter® 商标经许可使用。© DH Tech. Dev. Pte. Ltd.

MKT-001-0001