Home : Import Variables Into Location
Q13955 - INFO: Import Variables Into Location

Used to import variables to an existing location from a Hach WIMS Variable Template File.

See Import Location/Variables from Hach WIMS Variable Template to create a new location and import variables into it.

From Var Admin Tool:

 

USING:

  1. Click on the location you want to add variables to. Effl 002 in this example.
  2. On the menu choose Variable>Import Vars into Location.
  3. Pick a Variable Template File to use (WIMSVARS.XLS will be loaded by default, click here to load different template files).
  4. Select a sheet to import from
  5. Enter a Prefix Names With.  Example, enter "Effl 002" and the new variables will be named "Effl 002 Cadmium", "Effl 002 Chromium" etc...  Leave blank and the variables will be named Cadmium, Chromium,...
  6. Enter the Base VarNum or choose By Increment.  Example:
    • By adding Column A to Base Varnum of 123700 is selected V124016 Cadmium, V124021 Chromium... will be created.  124016 = 123700 + 316.
    • By incrementing by 2 to last varnum (5105) in Location is selected V5007 Cadmium, V5009 Chromium... will be created. 
  7. Select which variables to import by clicking on the rows (you can use Shift click and Ctrl Click to select multiple rows)
  8. Click the Create Vars button.

 

FIELDS:

Source Excel File: The Hach WIMS Variable Template Excel file to use to create your location/variables from.

Location: The new location to create.  The New Location Name will be combined with the Parameter Name to make the Variable Name.  For example, Variable Number 44101, Name  Influent Channel 2 Total Flow will be created in the example above. 

Set New Varnums: The options set how the new variable numbers will be generated:

By adding Column A to Base VarNum of ______:  The Base VarNum is added to column A (Var #) field to calculate the Variable Number.  For example, the first variable created will be 5101(Base VarNum of 5100 + Var # of 1 for row 4 in the example above). 

By incrementing by X to last VarNum (xxxx) in Location: Ignores Column A (Var #) and simply add X to the last Varnum in the Location.  For Example, the last varnum is 1135 for Location RAS 01 so the following would be created with an increment of 2:

1137 RAS 01 Total Flow
1139 RAS 01 BOD
1141 RAS 01 BOD Load
1143 RAS 01 cBOD
1145 RAS 01 cBOD Load


 


 


 

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 10/9/2012 1:46 PM.
Last Modified on 3/31/2020 9:50 AM.
Last Modified by Scott Dorner.
Article has been viewed 2684 times.
Rated 3 out of 10 based on 5 votes.
Print Article
Email Article