{"id":26,"date":"2015-09-03T11:36:00","date_gmt":"2015-09-03T11:36:00","guid":{"rendered":"http:\/\/jasonstark.com\/website\/?p=26"},"modified":"2020-07-11T01:43:12","modified_gmt":"2020-07-11T01:43:12","slug":"vernier-loggerpro-function-reference","status":"publish","type":"post","link":"https:\/\/jasonstark.com\/website\/2015\/09\/03\/vernier-loggerpro-function-reference\/","title":{"rendered":"Vernier LoggerPro Function Reference"},"content":{"rendered":"\n

LoggerPro functions for use in Calculated Columns.  I always Google for this information and can never find it online.  It is hidden in the \u201cHelp\u201d for LoggerPro (who would think to look there!?).<\/p>\n\n\n\n

Functions<\/h3>\n\n\n\n

\u2013 Trigonometric functions will use degrees or radians as set in the Settings for (file name) in the File menu.<\/p>\n\n\n\n

\u2013 For more information about Savitsky-Golay methods see Numerical Recipes in C: http:\/\/lib-www.lanl.gov\/numerical\/bookcpdf.html<\/a> chapter 15<\/p>\n\n\n\n

analysis<\/h2>\n\n\n\n
Function<\/td>Description<\/td><\/tr>
analysis<\/td>(\u201cX\u201d, startRow, endRow)
Takes all columns named \u201cX\u201d and extracts startRow to endRow for each of those columns, appending the values into a single column.<\/td><\/tr>
dataSets<\/td>datasets(\u201cX\u201d)
Appends the dataset names of all datasets that have a column named \u201cX\u201d. Use analysis and datasets together to create a graph (analysis on the vertical axis and datasets on the horizontal). for example, if you had 3 datasets as follows:
DS1  DS2  DS3
X       X      Y
1      11     21
2      12     22and then added analysis(\u201cX\u201d, 1, 1) and datasets(\u201cX\u201d) you would get:datasets    analysis
DS1             1
DS2            11<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
\n\n\n\n
beats per minute<\/td>BeatsPerMinute(\u201cSignal\u201d, \u201cTime\u201d, intervalInSeconds, minPercent, maxPercent, noise)
Returns the number of beats per minute of the values in \u201cSignal\u201d vs. \u201cTime\u201d. This function is similar to the rate function except that the interval given here is always in seconds and the returned value is always in minutes. For example, if \u201cTime\u201d is in seconds then: beatsPerMinute(\u201cSignal\u201d, \u201cTime\u201d, interval, min, max, noise) = 60 * rate(\u201cSignal\u201d, \u201cTime\u201d, interval, min, max, noise)<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

blood pressure<\/h2>\n\n\n\n
diastolic<\/td>The measured arterial pressure when the heart is at rest. \u201cPressure\u201d and a \u201cTime\u201d column as inputs and return a single number.
diastolic(\u201cPressure\u201d, \u201cTime\u201d)
\u201cPressure\u201d: Pressure values from the BPS
\u201cTime\u201d: Time the pressure values were recorded
Returns the smaller number of blood pressure<\/td><\/tr>
meanArterialPressure<\/td>meanArterialPressure(\u201cPressure\u201d, \u201cTime\u201d)\u201cPressure\u201d: Pressure values from the BPS
\u201cTime\u201d: Time the pressure values were recorded
Returns the pressure value at the max peak used for blood pressure calculations.<\/td><\/tr>
Oscillations<\/td>Oscillations(\u201cPressure\u201d, \u201cTime\u201d)
\u201cPressure\u201d: Pressure values from the BPS
\u201cTime\u201d: Time the pressure values were recorded
Returns the Oscillations of the peaks and valleys used to calculate systolic and other blood pressure values.<\/td><\/tr>
OscillatoryPeaks<\/td>OscillatoryPeaks(\u201cPressure\u201d, \u201cTime\u201d)
\u201cPressure\u201d: Pressure values from the BPS
\u201cTime\u201d: Time the pressure values were recorded
Returns the peaks used to calculate systolic, diastolic, and pulse (the \u201chigh\u201d values in \u201cOscillations\u201d).<\/td><\/tr>
pulse<\/td>pulse(\u201cPressure\u201d, \u201cTime\u201d)
\u201cPressure\u201d: Pressure values from the BPS
\u201cTime\u201d: Time the pressure values were recorded
Returns the pulse using the inputs from the Blood Pressure Sensor (similar results, different algorithm as the other beats-per-minute functions)<\/td><\/tr>
systolic<\/td>systolic(\u201cPressure\u201d, \u201cTime\u201d)
\u201cPressure\u201d: Pressure values from the BPS
\u201cTime\u201d: Time the pressure values were recorded
The measured arterial pressure when the heart contracts. Returns the larger number of blood pressure<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

boolean<\/h2>\n\n\n\n
<\/td>For the boolean functions a 1 is considered true, 0 false and anything else an invalid input<\/td><\/tr>
AND<\/td>AND(X, Y) return 1 if and only if X and Y are both 1<\/td><\/tr>
NOT<\/td>NOT(X) return 1 if X is 0; 0 if X is 1<\/td><\/tr>
OR<\/td>OR(X, Y) return 1 if X or Y is 1<\/td><\/tr>
XOR<\/td>XOR(X, Y) return 1 if X or Y is 1 but not both<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

calculus<\/h2>\n\n\n\n
calculus ><\/td><\/td><\/tr>
derivative<\/td>derivative(\u201cY\u201d, \u201cX\u201d)
\u201cY\u201d: A column of real numbers
\u201cX\u201d: Optional. A column of real numbers
The numerical derivative is the weighted average of the slope of \u2018n\u2019 points around each point. You can set \u2018n\u2019 in Settings for (Name). If you don\u2019t supply an \u201cX\u201d column, the program will find one.<\/td><\/tr>
derivativeSG<\/td>derivativeSG(\u201cY\u201d, \u201cX\u201d)
\u201cY\u201d: A column of real numbers
\u201cX\u201d: Optional. A column of real numbers
Savitsky-Golay derivative. Fits a polynomial to \u2018n\u2019 points around each point and computes the derivative of the polynomial at that point. You can set \u2018n\u2019 in Settings for (Name). If you don\u2019t supply an \u201cX\u201d column, the program will find one.<\/td><\/tr>
derivativeTimeShift<\/td>derivativeTimeShift(\u201cY\u201d, \u201cX\u201d)
Returns the derivative of \u201cY\u201d with respect to \u201cX\u201d.
This function is specifically designed to be used with photogate and picket fence data. The derivatives returned are adjusted to estimate values at the start of the timing interval, instead of the midpoint. For details see The Physics Teacher, Vol 35, April 1997, p. 220. The article written by William Leonard is entitled \u201cThe Dangers of Automated Data Analysis.\u201d
Average velocity during the time interval is equal to the instantaneous velocity at midpoint of the time interval.\"\"
Where\"\"<\/td><\/tr>
integral<\/td>integral(\u201cY\u201d,\u201dX\u201d)
\u201cY\u201d: A column of real numbers
\u201cX\u201d: Optional. A column of real numbers
The numerical integral is the running sum of the areas of rectangles calculated by the midpoint rule. The i\u2019th rectangle is (Yi \u2013 Y(i-1)) \/ (Xi \u2013 X(i-1)). If you don\u2019t supply an \u201cX\u201d column, the program will find one.<\/td><\/tr>
secondderivative<\/td>secondDerivative(\u201cY\u201d, \u201cX\u201d)
\u201cY\u201d: A column of real numbers
\u201cX\u201d: Optional. A column of real numbers
Calculates the numerical second derivative of \u201cY\u201d with respect to \u201cX\u201d. If you don\u2019t supply an \u201cX\u201d column, the program will find one.<\/td><\/tr>
secondderivativeSG<\/td>secondDerivativeSG(\u201cY\u201d, \u201cX\u201d)
\u201cY\u201d: A column of real numbers
\u201cX\u201d: Optional. A column of real numbers
Savitsky-Golay second derivative. Fits a polynomial to \u2018n\u2019 points around each point and computes the second derivative of the polynomial at that point. You can set \u2018n\u2019 in Settings for (Name). If you don\u2019t supply an \u201cX\u201d column, the program will find one.<\/td><\/tr>
secondderivative
Time Shift<\/td>		secondDerivativeTimeShift(\u201cY\u201d, \u201cX\u201d)
\u201cY\u201d: A column of real numbers
\u201cX\u201d: Optional. A column of real numbers
Numerical time-shifted second derivative. Calculates the second numerical derivative of \u201cY\u201d with respect to \u201cX\u201d. The values are shifted so that the derivatives are calculated at the midpoints between each two values. If you don\u2019t supply an \u201cX\u201d column, the program will find one.\"\"<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
collapse<\/td>collapse(\u201cX\u201d)
Returns a column with all non-numerical cells (blanks and text) removed.<\/td><\/tr>
collapseIndirect<\/td>collapseIndirect(X, Y)
Returns a column of only the rows in \u201cX\u201d corresponding to rows in \u201cY\u201d that have valid numerical cells.<\/td><\/tr>
constant<\/td>Constant(x, num)
x: A real number
num: A real number or a column
Generates a constant column filled with the value \u2018x\u2019.  The number of values in the returned column is num, or if a column was passed in, the size of the passed-in column.<\/td><\/tr>
delta<\/td>delta (\u201cX\u201d)
\u201cX\u201d: A column of real numbers
Returns a column of values where the i\u2019th value is the i\u2019th value in \u201cX\u201d minus the (i-1)\u2019th value in \u201cX\u201d.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

digital filtering<\/h2>\n\n\n\n
lowPassFilter<\/td>(\u201cY\u201d, \u201cX\u201d, \u201cripple\u201d, \u201cfreqCutoff\u201d)
\u201cY\u201d: The data column to be filtered
\u201cX\u201d: The associated time column for \u201cY\u201d
\u201cripple\u201d: The ripple allowed in the pass-band
\u201cfreqCutoff\u201d: Cut-off frequency (-3dB), in hertz
Applies a Chebyshev low-pass filter. For \u201cripple\u201d, enter a value that is a percent of the pass-band. To apply a Butterworth low-pass filter, set \u201cripple\u201d to 0.<\/td><\/tr>
highPassFilter<\/td>(\u201cY\u201d, \u201cX\u201d, \u201cripple\u201d, \u201cfreqCutoff\u201d)
\u201cY\u201d: The data column to be filtered
\u201cX\u201d: The associated time column for \u201cY\u201d
\u201cripple\u201d: The ripple allowed in the pass-band
\u201cfreqCutoff\u201d: Cut-off frequency (-3dB), in hertz
Applies a Chebyshev high-pass filter. For \u201cripple\u201d, enter a value that is a percent of the pass-band. To apply a Butterworth high-pass filter, set ripple to 0.<\/td><\/tr>
bandPassFliter<\/td>(\u201cY\u201d, \u201cX\u201d, \u201clowFreq\u201d, \u201chighFreq\u201d)
\u201cY\u201d: The data column to be filtered
\u201cX\u201d: The associated time column for \u201cY\u201d
\u201clowFreq\u201d: Low frequency cut-off (-3dB), in hertz
\u201chighFreq\u201d: High frequency cut-off (-3dB), in hertz
Ripple is automatically set to zero and is not adjustable. The function returns the signal with the frequencies outside the designated frequency range removed.<\/td><\/tr>
bandStopFliter<\/td>(\u201cY\u201d, \u201cX\u201d, \u201clowFreq\u201d, \u201chighFreq\u201d)
\u201cY\u201d: The data column to be filtered
\u201cX\u201d: The associated time column for \u201cY\u201d
\u201clowFreq\u201d: Low frequency cut-off (-3dB), in hertz
\u201chighFreq\u201d: High frequency cut-off (-3dB), in hertz
Ripple is automatically set to zero and is not adjustable. The function returns the signal with the frequencies inside the designated frequency range removed.<\/td><\/tr>
timeDecayFilter<\/td>(\u201cY\u201d, \u201cX\u201d, \u201cdecayConstant\u201d)
\u201cY\u201d: The data column to be filtered
\u201cX\u201d: The associated time column for \u201cY\u201d
\u201cdecayConstant\u201d: A value in seconds that determines the decay of \u201cY\u201d
Applies an exponential time decay to the signal.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
ElectrophoresisInterpolate<\/td>ElectrophoresisInterpolate(\u201cStd. Dist\u201d, \u201cStd. BP\u201d, \u201cDist\u201d)
\u201cStd. Dist\u201d: Distances from the standard
\u201cStd. BP\u201d: Base Pair Counts from the standard
\u201cDist\u201d: Distances to interpolate
Returns a column of base pair counts based on the Electrophoresis curve fit for \u201cStd. Dist\u201d vs. \u201cStd. BP\u201d given \u201cDist\u201d. Will NOT work if curve fit has been deleted. This function is used automatically when doing a Gel Analysis (Electrophoresis).<\/td><\/tr>
exp<\/td>exp(\u201cX\u201d)
\u201cX\u201d: A column of real numbers
Returns the exponent, exp(x) = e^x, where e is the natural log base (2.17\u2026).<\/td><\/tr>
integer<\/td>integer(\u201cX\u201d)
Extracts the integral part of values in \u201cX\u201d.<\/td><\/tr>
interpolate<\/td>interpolate(\u201cX\u201d)
Fills in missing values using linear interpolation.<\/td><\/tr>
ln<\/td>ln(\u201cX\u201d)
\u201cX\u201d: A column of real numbers larger than 0
Returns the natural logarithm. If b = ln(a) then e^b = a  (Where e is the constant 2.17\u2026).<\/td><\/tr>
log<\/td>log(\u201cX\u201d)
\u201cX\u201d: A column of real numbers larger than 0
(Log base 10) If b = log(a) then 10^b = a.<\/td><\/tr>
modulo<\/td>modulo(\u201cX\u201d, n)
\u201cX\u201d: A column of integers
n: An integer larger than 0
Returns the remainder of each of the numbers in \u201cX\u201d when divided by n.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

photogate<\/h2>\n\n\n\n
Blocked MidTimes<\/td>BlockedMidTimes(\u201cTime\u201d, \u201cGate1\u201d, \u201cGate2\u201d)
\u201cTime\u201d: Optional. A column of real numbers (the times of events)
\u201cGate1\u201d: A column of photogate states (1\u2019s and 0\u2019s)
\u201cGate2\u201d: Optional. A column of photogate states (1\u2019s and 0\u2019s)
Calculate the average times between blocked events from Gate 1 to Gate 2. If you don\u2019t enter a \u201cTime\u201d column, the program will find one. If you don\u2019t enter \u201cGate2\u201d, \u201cGate1\u201d will be used.<\/td><\/tr>
Blocked to Blocked<\/td>BlockedToBlocked(\u201cTime\u201d, \u201cGate1\u201d, \u201cGate2\u201d)
\u201cTime\u201d: Optional. A column of real numbers (the times of events)
\u201cGate1\u201d: A column of photogate states (1\u2019s and 0\u2019s)
\u201cGate2\u201d: Optional. A column of photogate states (1\u2019s and 0\u2019s)
Returns a column of the times between successive blocked events in gate 1 and blocked events in gate 2. If you don\u2019t enter a \u201cTime\u201d column, the program will find one. If you don\u2019t enter \u201cGate2\u201d, \u201cGate1\u201d will be used.<\/td><\/tr>
Blocked to Unblocked<\/td>BlockedToUnblocked(\u201cTime\u201d, \u201cGate1\u201d, \u201cGate2\u201d)
\u201cTime\u201d: Optional. A column of real numbers (the times of events)
\u201cGate1\u201d: A column of photogate states (1\u2019s and 0\u2019s)
\u201cGate2\u201d: Optional. A column of photogate states (1\u2019s and 0\u2019s)
Returns a column of the times between successive blocked events in gate 1 and unblocked events in gate 2. If you don\u2019t enter a \u201cTime\u201d column, the program will find one. If you don\u2019t enter \u201cGate2\u201d, \u201cGate1\u201d will be used.<\/td><\/tr>
Blocked to Unblocked MidTimes<\/td>Blocked to Unblocked MidTimes
\u201cTime\u201d: Optional. A column of real numbers (the times of events)
\u201cGate1\u201d: A column of photogate states (1\u2019s and 0\u2019s)
\u201cGate2\u201d: Optional. A column of photogate states (1\u2019s and 0\u2019s)
Calculate the average time between the blocked events in gate 1 and unblocked events in gate 2. If you don\u2019t enter a \u201cTime\u201d column, the program will find one. If you don\u2019t enter \u201cGate2\u201d, \u201cGate1\u201d will be used.<\/td><\/tr>
derivativeTimeShift<\/td>DerivativeTimeShift (\u201cY\u201d, \u201cX\u201d)
Returns the derivative of \u201cY\u201d with respect to \u201cX\u201d.
This function is specifically designed to be used with photogate and picket fence data. The derivatives returned are adjusted to estimate values at the start of the timing interval, instead of the midpoint. For details see The Physics Teacher, Vol 35, April 1997, p. 220.
Average velocity during the time interval is equal to the instantaneous velocity at midpoint of the time interval.\"\"
Where\"\"<\/td><\/tr>
Pendulum Period<\/td>PendulumPeriod(\u201cTime\u201d, \u201cGate1\u201d)
\u201cTime\u201d: Optional. A column of real numbers (the times of events)
\u201cGate1\u201d: A column of photogate states (1\u2019s and 0\u2019s)
Calculate the time between every other blocked event on Gate 1. If you don\u2019t enter a \u201cTime\u201d column, the program will find one.<\/td><\/tr>
secondDerivativeTimeShift<\/td>secondDerivativeTimeShift(\u201cY\u201d, \u201cX\u201d)
\u201cY\u201d: A column of real numbers
\u201cX\u201d: Optional. A column of real numbers
Numerical time-shifted second derivative. Calculates the second numerical derivative of \u201cY\u201d with respect to \u201cX\u201d. The values are shifted so that the derivatives are calculated at the midpoints between each two values. If you don\u2019t supply an \u201cX\u201d column, the program will find one.\"\"<\/td><\/tr>
Unblocked to Blocked<\/td>UnblockedToBlocked(\u201cTime\u201d, \u201cGate1\u201d, \u201cGate2\u201d)
\u201cTime\u201d: Optional. A column of real numbers (the times of events)
\u201cGate1\u201d: A column of photogate states (1\u2019s and 0\u2019s)
\u201cGate2\u201d: Optional. A column of photogate states (1\u2019s and 0\u2019s)
Returns a column of the times between successive unblocked events in gate 1 and blocked events in gate 2. If you don\u2019t enter a \u201cTime\u201d column, the program will find one. If you don\u2019t enter \u201cGate2\u201d, \u201cGate1\u201d will be used.<\/td><\/tr>
Unblocked to Unblocked<\/td>UnblockedToUnblocked(\u201cTime\u201d, \u201cGate1\u201d, \u201cGate2\u201d)
\u201cTime\u201d: Optional. A column of real numbers (the times of events)
\u201cGate1\u201d: A column of photogate states (1\u2019s and 0\u2019s)
\u201cGate2\u201d: Optional. A column of photogate states (1\u2019s and 0\u2019s)
Returns a column of the times between successive unblocked events in gate 1 and unblocked events in gate 2. If you don\u2019t enter a \u201cTime\u201d column, the program will find one. If you don\u2019t enter \u201cGate2\u201d, \u201cGate1\u201d will be used.<\/td><\/tr>
Unblocked to Blocked MidTimes<\/td>Unblocked to Blocked MidTimes
\u201cTime\u201d: Optional. A column of real numbers (the times of events)
\u201cGate1\u201d: A column of photogate states (1\u2019s and 0\u2019s)
\u201cGate2\u201d: Optional. A column of photogate states (1\u2019s and 0\u2019s)
Calculate the average time between unblocked events in gate 1 and blocked events in gate 2. If you don\u2019t enter a \u201cTime\u201d column, the program will find one. If you don\u2019t enter \u201cGate2\u201d, \u201cGate1\u201d will be used.<\/td><\/tr>
Unblocked MidTimes<\/td>UnblockedMidTimes(\u201cTime\u201d, \u201cGate1\u201d, \u201cGate2\u201d)
\u201cTime\u201d: Optional. A column of real numbers (the times of events)
\u201cGate1\u201d: A column of photogate states (1\u2019s and 0\u2019s)
\u201cGate2\u201d: Optional. A column of photogate states (1\u2019s and 0\u2019s)
Calculate the average times between unblocked events from Gate 1 to Gate 2. If you don\u2019t enter a \u201cTime\u201d column, the program will find one. If you don\u2019t enter \u201cGate2\u201d, \u201cGate1\u201d will be used.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
\n\n\n\n
rate<\/td>rate(\u201cY\u201d, \u201cX\u201d, t, m1, m2, n)
\u201cY\u201d: A column of real numbers
\u201cX\u201d: Optional. A column of real numbers
t: Optional. Time interval
m1: Optional. Minimum threshold
m2: Optional. Maximum threshold
n: Optional. Noise threshold
Returns the rate of \u201cY\u201d with respect to \u201cX\u201d, where t is the time interval measured, m1 is min percentage threshold, m2 is max percentage threshold, and n is noise threshold. \u201cX\u201d, t, m1, m2, and noise are all optional with default values \u201cX\u201d is time column, t = 1\/10 the range, m1 = 40%, m2 = 60%, and noise = 0. Details<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

rotary motion<\/h2>\n\n\n\n
\n\n\n\n
amplitude<\/td>(\u201cData Column\u201d, \u201cTime Column\u201d, \u201cMin Percent\u201d, \u201cMax Percent\u201d, \u201cTime Interval\u201d)
\u201cData Column\u201d: Data for which you want to calculate amplitude
\u201cTime Column\u201d: Associated time column for \u201cData Column\u201d
\u201cMin Percent\u201d: Threshold used to detect valleys
\u201cMax Percent\u201d: Threshold used to detect peaks
\u201cTime Interval\u201d: Period of time over which amplitude is calculated (in the time units of the experiment)
Calculates peak to peak amplitude. For Min and Max Percent, enter values between 0 and 100. Smaller values are more sensitive to noise and thus more sensitive to real cycles. Larger values are less sensitive to noise; too large of a value may filter out real cycles. \u201cTime Interval\u201d ends at the row at which the value is calculated (the current time).<\/td><\/tr>
period<\/td>(\u201cData Column\u201d, \u201cTime Column\u201d, \u201cMin Percent\u201d, \u201cMax Percent\u201d, \u201cTime Interval\u201d)
\u201cData Column\u201d: Data for which you want to calculate period
\u201cTime Column\u201d: Associated time column for \u201cData Column\u201d
\u201cMin Percent\u201d: Threshold used to detect valleys
\u201cMax Percent\u201d: Threshold used to detect peaks
\u201cTime Interval\u201d: Period of time over which period is calculated (in the time units of the experiment)
Calculates the period of an oscillating function. For Min and Max Percent, enter values between 0 and 100. Smaller values are more sensitive to noise and thus more sensitive to real cycles. Larger values are less sensitive to noise; too large of a value may filter out real cycles. \u201cTime Interval\u201d ends at the row at which the value is calculated (the current time).<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
round<\/td>round(\u201cX\u201d)
\u201cX\u201d: A column of real numbers
Round. Returns the closest integer to x. If x is equidistant to two integers, round(x) gives the largest of the two (e.g., round(0.5) = 1).<\/td><\/tr>
smoothAve<\/td>smoothAve(\u201cX\u201d)
\u201cX\u201d: A column of real numbers
Returns a column of moving averages of the values in \u201cX\u201d. The width of the \u201cwindow\u201d to use when averaging points can be set in Settings for (Name)\u2026<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

statistics<\/h2>\n\n\n\n
abs<\/td>abs(\u201cX\u201d)
\u201cX\u201d: A column of real numbers
Absolute value. If x less than 0, then abs(x) = -x.  Otherwise, abs(x) = x.<\/td><\/tr>
ceiling<\/td>ceiling(\u201cX\u201d)
\u201cX\u201d: A column of real numbers
Returns the smallest integer larger than or equal to x.<\/td><\/tr>
floor<\/td>floor(\u201cX\u201d)
\u201cX\u201d: A column of real numbers
Returns the largest integer smaller than or equal to x.<\/td><\/tr>
max<\/td>max(\u201cX\u201d)
\u201cX\u201d: A column of real numbers
Compares all the values in a single column and returns a single number-the largest number in the column.<\/td><\/tr>
max2<\/td>max2(\u201cX\u201d, \u201cY\u201d)
\u201cX\u201d: column of real numbers
\u201cY\u201d: A column of real numbers or a single number.
Compares all the values in a column against a real number (e.g max2(\u201cX\u201d, 5.1))<\/td><\/tr>
mean<\/td>mean(\u201cX\u201d)
\u201cX\u201d: A column of real numbers
Arithmetic mean. Returns the sum of all the values in \u201cX\u201d divided by the number of values.<\/td><\/tr>
median<\/td>Median(\u201cX\u201d).
\u201cX\u201d: A column of real numbers
If m = median(\u201cX\u201d), then half the numbers in \u201cX\u201d are greater than (or equal) to m, and half are less than or equal.<\/td><\/tr>
min<\/td>min(\u201cX\u201d)
\u201cX\u201d: A column of real numbers
Compares all the values in a single column ,and returns a single number-the smallest number in the column.<\/td><\/tr>
min2<\/td>min(\u201cX\u201d, \u201cY\u201d)
\u201cX\u201d: A column of real numbers
\u201cY\u201d: A column of real numbers or a single number
Compares all the values in a column against a real number (e.g min2(\u201cX\u201d, 5.1))<\/td><\/tr>
numRows<\/td>NumRows(\u201cX\u201d)
\u201cX\u201d: A column of real numbers
Returns a single value-the number of rows in the column.<\/td><\/tr>
randInt<\/td>randInt(min, max, num):
min: A real number
max: A real number
num: A real number or a column
Random Integer. Returns a column of random integers between min and max (inclusive). The size of the returned column is num. If num is a column, then the size will be the number of rows in that column.<\/td><\/tr>
randReal<\/td>randReal(min, max, num)
min: A real number
max: A real number
num: A real number or a column
Random Real. Returns a column of random real numbers between min and max (inclusive). The size of the returned column is num. If num is a column, then the size will be the number of rows in that column.<\/td><\/tr>
stddev<\/td>stddev(\u201cX\u201d)
\u201cX\u201d: A column of real numbers
Standard Deviation. Returns a column representing the standard deviations of each of the numbers in a column.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
step<\/td>step(start, increment, num, first, skip)
start: Start value
increment: Increment value
num: Number of values to generate
first: Optional. First non-empty row
skip: Optional. Rows to skip between each value
Generates a column \u201cnum\u201d rows long starting with \u201cstart\u201d and incrementing by \u201cincrement\u201d. \u201cnum\u201d can be a positive integer or a column name. Optional parameters: \u201cfirst\u201d is the first non-empty row and \u201cskip\u201d is the number of rows to skip between each value.<\/td><\/tr>
StepColumnBase<\/td>stepColumnBased(\u201cX\u201d, start, increment, first, skip)
start: Start value
increment: increment value
first: Optional. First non-empty row
skip: Optional. Row to skip between each value
Generates a column based on non-empty values in column \u201cX\u201d starting with \u201cstart\u201d and incrementing by \u201cincrement.\u201d \u201cFirst\u201d is the first non-empty row and \u201cskip\u201d is the number of rows to skip between each value.<\/td><\/tr>
subset<\/td>subset(\u201cX\u201d, startRow, step)
\u201cX\u201d: A column of real numbers
startRow: An integer larger than 0
step: An integer larger than 0
Extract a subset. Returns a column extracted from \u201cX\u201d starting with \u2018startRow\u2019 by \u2018step\u2019. For example, subset(\u201cX\u201d, 1, 2) will get every second row of \u201cX\u201d starting with row 1.<\/td><\/tr>
sum<\/td>Sum(\u201cX\u201d)
\u201cX\u201d: A column of real numbers
Returns a column whose n\u2019th value is the sum of the values in \u201cX\u201d from row 1 to n.<\/td><\/tr>
sqrt<\/td>Square root. \u201cX\u201d: A column of non-negative real numbers.
If x is the square root of y, then x*x = y.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

trigonometric<\/h2>\n\n\n\n
\n\n\n\n
sin<\/td>sin(\u201cX\u201d)
\u201cX\u201d: A column of real numbers
In a right triangle with angle between two sides \u2018x\u2019, sin(x) is the length of the opposite side divided by the hypotenuse.<\/td><\/tr>
cos<\/td>cos(\u201cX\u201d)
\u201cX\u201d: A column of real numbers
In a right triangle with angle between two sides \u2018x\u2019, cos(x) is the length of the adjacent side divided by the hypotenuse.<\/td><\/tr>
tan<\/td>tan(\u201cX\u201d)
\u201cX\u201d: A column of real numbers
In a right triangle with angle between two sides \u2018x\u2019, tan(x) is the length of the opposite side divided by the adjacent side.<\/td><\/tr>
asin<\/td>asin(\u201cX\u201d)
\u201cX\u201d: A column of real numbers between -1 and 1
Arcsine function. asin(x) = the angle whose sine is x.<\/td><\/tr>
acos<\/td>acos(\u201cX\u201d)
\u201cX\u201d: A column of real numbers between -1 and 1
Arccosine function. acos(x) = the angle whose cosine is x.<\/td><\/tr>
atan<\/td>atan(\u201cX\u201d)
\u201cX\u201d: A column of real numbers
Arctangent function. atan(x) = the angle whose tangent is x. The result will be between -pi\/2 and pi\/2.<\/td><\/tr>
sinh<\/td>sinh(\u201cX\u201d)
\u201cX\u201d: A column of real numbers
Hyperbolic sine.<\/td><\/tr>
cosh<\/td>cosh(\u201cX\u201d)
\u201cX\u201d: A column of real numbers
Hyperbolic cosine.<\/td><\/tr>
tanh<\/td>tanh(\u201cX\u201d)
\u201cX\u201d: A column of real numbers
Hyperbolic tangent.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
\n\n\n\n
Value<\/td>Value(n, \u201cX\u201d)
n: Number of rows backwards (when n < 0) or forwards (n >0) in column \u201cX\u201d to extract a value from.
\u201cX\u201d: Column from which to extract values .
Create a new column from another column by extracting offset values.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

If data are imported from an experiment file, you may want to specify the independent column. For example, if the imported data included \u201ctime\u201d in the first column but you wanted to calculate the derivative of pH with respect to volume, you have to define the derivative as derivative(\u201cpH\u201d,\u201dVolume\u201d).<\/p>\n","protected":false},"excerpt":{"rendered":"

LoggerPro functions for use in Calculated Columns.  I always Google for this information and can never find it online.  It is hidden in the \u201cHelp\u201d for LoggerPro (who would think to look there!?). Functions \u2013…<\/p>\n

Read More<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10,14,17],"tags":[],"class_list":["post-26","post","type-post","status-publish","format-standard","hentry","category-academics","category-engineering","category-modeling-instruction"],"_links":{"self":[{"href":"https:\/\/jasonstark.com\/website\/wp-json\/wp\/v2\/posts\/26","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jasonstark.com\/website\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jasonstark.com\/website\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jasonstark.com\/website\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jasonstark.com\/website\/wp-json\/wp\/v2\/comments?post=26"}],"version-history":[{"count":1,"href":"https:\/\/jasonstark.com\/website\/wp-json\/wp\/v2\/posts\/26\/revisions"}],"predecessor-version":[{"id":27,"href":"https:\/\/jasonstark.com\/website\/wp-json\/wp\/v2\/posts\/26\/revisions\/27"}],"wp:attachment":[{"href":"https:\/\/jasonstark.com\/website\/wp-json\/wp\/v2\/media?parent=26"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jasonstark.com\/website\/wp-json\/wp\/v2\/categories?post=26"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jasonstark.com\/website\/wp-json\/wp\/v2\/tags?post=26"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}