VINFO returns variable information such as Name, Units, etc for the specifed variable.

SYNTAX:

VINFO(VarNum, Field, optional Offset, optional Decimal Places) 

VarNum: The variable number to search for.  Can be a number (i.e. 12), a cell reference (i.e. C2) to a cell that contains a number, a quoted string that is a Variable WHERE Clause, or a cell reference to a cell containing a Variable WHERE Clause

Field: Which field to retrieve.  Valid settings include:

"VarNum"
"Name"
"VarDisplay" - Returns the default variable display based on the Facility's Default Variable Display Setting.
"VarDisplayxx" - Returns the last xx characters of the default variable display based on the Facility's Default Variable Display Setting.   Example VINFO(1031,"VarDisplay30") returns "...\AerTank 1 Dissolved Oxygen",VINFO(1,"VarDisplay30") returns "Influent Flow" (the whole VarDisplay since it was less than 30 characters.
"VarDispxx" - Returns the last xx characters of the default variable display based on the Facility's Default Variable Display Setting. Same as VarDisplayxx besides it replaces the "\" with "\ " (\<space>), usefull when you have long location paths and are placing the text in a cell that has Wrap Text Enabled.  
"Name.Units" - Returns "Variable Name {units}"
"Location.VarName" - Returns Variable Location.Variable Name
"Area.Location.VarName"' - Returns Area.Location.Variable Name
"Location:VarName" - Returns Location Path<space>Variable Name
"ShortName"
"ShortName.Units" - Returns the ShortName (Heading) {Units}
"VarType" - Returns the Variables internal Vartype value (i.e. P for Daily Parameter, N for Hourly Calc...)
"Frequency" - Returns the variable's frequency - "Day", "4 Hours","Hour", "15 Minutes"...
"Type" - Returns the variable's type - "Parameter", "Calculated","Text Parameter"
"DataTable" - Returns the table that stores the variables data (i.e. datatbl, dataddh, etc...)
"ScadaTag" - The Interface ScadaTag.
"Statistic" - The SCADA Interface Statistic (i.e. Average, Max,...)
"LIMS_LOC" - The LIMS Interface Location.
"LIMS_TEST" - The LIMS Interface Test or Analyte
"XREF" - The interface cross reference.  If SCADA returns ScadaTag (Statistic), ex "FIT_RAW_WATER (AVERAGE)".  If LIMS returns LIMS_LOC::LIMS_TEST, ex "RAW::PH"
"StoretCode" - Returns the StoretCode for the variable (i.e. 50050, 00310)
"StoretCodeDesc" - Returns the description for the variable's storet code (i.e. "FLOW, IN CONDUIT OR THRU A TREATMENT PLANT MGD")
"StoretCode-Desc" - Returns the storetcode a dash and then the description (i.e. "50050-FLOW, IN CONDUIT OR THRU A TREATMENT PLANT MGD")
"AnalyteCode" - Returns the AnalyteCode for the variable (i.e. 0100, 3100)
"AnalyteCodeDesc" - Returns the description for the variable's AnalyteCode (i.e. "COLIFORM (TCR)")
"AnalyteCode-Desc" - Returns the AnalyteCode a dash and then the description (i.e. "3100-COLIFORM (TCR)")
"AllowSymbol"
"DecPlaces"
"SigFigs"
"EntryMin"
"EntryMax"
"Entry Range" - Returns EntryMin and Max with a dash between.  IE 0-14, if only an Entry Max returns <=14, only Entry Min returns >=0.
"Daily Min"
"Daily Max"
"Weekly Min"
"Weekly Max"
"Monthly Min"
"Monthly Max"
"Quarterly Min"
"Quarterly Max"
"Annual Min"
"Annual Max"
"Limit.????.Description" - ???? is the limit name entered in Variable Setup, Limits.
"Limit.????.Compare"
"Limit.????.StartDate"
"Limit.????.EndDate"
"Limit.????.Grouping"
"Limit.????.STATISTIC"
"Limit.????.Limit" - Limit Value for ???? Limit.
"QC STARTDATE"
"QC UCL"
"QC UWL"
"QC MEAN"
"QC LCL"
"QC LWL"
"VGROUP" - Returns the Variable Group name
"VGROUPPATH" - Returns the full path of the Variable Group
"USERVGROUPACCESS" - Returns the logged in user's Variable Group access level (Edit, View, No Access)
"Location"
"Location.fieldname" - fieldname is any fieldname from the Location or Area table.  Examples "LOCATION.SITEADDRESS","LOCATION.PERMITNUMBER","LOCATION.AREANAME","LOCATION.PWSID" etc...
"LOCATION.LEVELx" - The Location at Level x (1-9) of the Location tree.
"LOCATION.LVLx_ID" - The ID of the location at Level x (1 - 9)
"PARENT" - The Location Name of the Parent of the variable's location.
"PARENTID" - The LocId of the parent of the variable's location.
"GRANDPARENT" - The Location Name of the Grandparent in the Location tree.  See Location Tree Example below.
"GRANDPARENTID" - The LocId of the grandparent of the variable's location.
"PATH" - The full location path seperated by \.  See Location Tree Example below.
"VARDESC_I.fieldname" - The Variable Additional Info field specified by fieldname.
"LOCATION_I.fieldname" - The Location Additional Info field specified by fieldname.

 

Offset: Optional.  Used with limit fields ( "Daily Min", "Daily Max", "Weekly Min", "Weekly Max", "Monthly Min", "Monthly Max", "Quarterly Min", "Quarterly Max", "Annual Min", "Annual Max", "QC STARTDATE,"QC UCL", "QC UWL", "QC MEAN", "QC LWL","QC LCL") which specifies which month to display the limit for.  The Offset sets the month to be retrieved relative to the specified report start date.  For example, with a report start date of 1/1/96, in Offset of 1 would define January, 2 February, etc..  If the Offset is a date string (i.e. "07/16/2004") or refers to a cell with a date in it, it sets the specific date to find the limit for.

Decimal Places: Optional.  Used with limit fields ("Daily Min", "Daily Max", "Weekly Min", "Weekly Max", "Monthly Min", "Monthly Max", "Quarterly Min", "Quarterly Max", "Annual Min", "Annual Max", "QC STARTDATE,"QC UCL", "QC UWL", "QC MEAN", "QC LWL","QC LCL", "ENTRYMIN","ENTRYMAX").  The VINFO function returns text as a default.  If you need to format the number to a certain number of decimal places it can be specified with this parameter.  You can also use the VAL function to change the cell to a number and then use Format, Cell to set decimal places. 

NOTES:

Use Locate, Variable Info to locate this formula.

EXAMPLES: