Home : SRFL Spread Function
Q14641 - INFO: SRFL Spread Function

SRFL returns Sample Result information For a Variable and Location.  Typically used with ad hoc samples.

SYNTAX:

SRFL(VarNum, Location Id/Location,Offset,DecPlaces,Field)


VarNum/Where Clause:  Specifies the variable to get text value for.  Can be a variable number, a cell reference to a variable number or a Variable WHERE Clause.

Location Id/Location:  If a number specifies the Location Id for the location to report on, if it is a string it can specify the Location name or the full location path.

Offset:  Sets which value to return.  For example, a setting of 1 means return the 1st value found in the report dates, 2 means return the 2nd value found, etc…

Decimal Places: Number of decimal places to display the result to.  ONLY used if the Field is blank or TextResult.

Field: The field in the Sample table (LC_SAMPLE)  or SampleTest Table (LC_SAMPLETEST) to return.  Common fields:

Sample Fields (LC_SAMPLE) Test/Analyte Fields (LC_SAMPLETEST)

ID
SAMPLENUM
SAMPLENAME

LOCID

RECEIVED_DATETIME
RECEIVEDBY
SAMPLEDTTIME
SAMPLEDBYNAME
ASSIGNEDTO
RECEIVEDBY,RCVDBY,RCVDBYNAME
RECEIVED_DATETIME

LAB
SAMPLEVOLUME
SAMPLEUD1..SAMPLEUD9
NOTES - Sample Notes/Comments

TOTALCOST

TESTNAME
RESULT
TEXTVALUE

STARTANALYST
ANALYSIS_START, DATESTART

ANALYZEDBY
ANALYZED_DATETIME,ANALYSIS_END,DATECOMPLETE
METHODNAME


EXAMPLES:

=SRFL(11226,243,1,2,"TEXTVALUE") - Get the 1st result for variable 11226 when the sample location is set to id 243. 

=SRFL(11226,$C$2,1,2,"SAMPLENUM") - Cell C2 contains the location name "4020 Peggy St, Rio Rancho, NM 87144". 

SEE ALSO: VSAMP , STI

Related Articles
No Related Articles Available.

Article Attachments
No Attachments Available.

Related External Links
No Related Links Available.
Help us improve this article...
What did you think of this article?

poor 
1
2
3
4
5
6
7
8
9
10

 excellent
Tell us why you rated the content this way. (optional)
 
Approved Comments...
No user comments available for this article.
Created on 3/8/2021 4:30 PM.
Last Modified on 3/9/2021 9:59 AM.
Last Modified by Scott Dorner.
Article has been viewed 109 times.
Rated 0 out of 10 based on 0 votes.
Print Article
Email Article