In-Situ TROLL 9500 Operators Manual User Manual
Page 144
139
0095110 rev. 007 01/09
TROLL 9500 Operator’s Manual
OUTPUT
,OW &LOW
&LOW 3ENSE
Project name
Site name
Well ID
Date (m-dd-yyyy)
Low flow file designator
EXPORT TO EXCEL OPTION
To automatically create an output report in Microsoft
®
Excel
®
from
Win-Situ 4:
1. In the Win-Situ Navigation tree, select a low-flow data file. If it
opens in Graph view, select the Report button.
2. On the Win-Situ File Menu, select Export to Excel.
3. The report will open in an Excel spreadsheet.
USING A CUSTOM EXCEL TEMPLATE
The Win-Situ 4 installation includes an Excel template for creating an
output report (shown on the following page). This template is named
InSituLowFlow.xlt, and is automatically installed to the Templates
directory of the Microsoft operating system. Brief instructions for using
this template are included in the spreadsheet that opens when you
select Export to Excel.
To format an output report using the custom template,
1. After exporting a low flow data file to Excel, insert a new sheet
based on a template by right-clicking the tab at the bottom of the
screen in Excel.
2. Click Insert, then select the template InSituLowFlow.xlt.
3. When prompted by Excel, select “Enable Macros.”
An example of low flow data formatted in Excel using this template
is shown on the following page.
4. If desired, save the report as an .xls file.
SECTION 20: LOW-FLOW MONITORING
STABILIZATION READINGS—METER AND GRAPH
Time the Wizard started
Elapsed time
No. of readings taken
Countdown to next reading
11
s
over the last 3 readings OR
s
third reading back, expressed as a percentage
s
To view this data in graphical form, click Graph.
The graph shows the change
and stabilization ranges of
all parameters. The “change
band,” between the heavy
dotted lines, represents a
composite target of all speci-
fied stability ranges. You can
drag the range finder up or
down, or expand the stability
region to zoom in.
The most recent readings
are shown on the right, ear-
lier readings on the left. 0
marks the latest reading. The
change band is centered on
the third point as a reference.
The graph can show up to
10 sets of readings. Change
is recalculated with each
reading.
Graph view of unstable change
Graph view of stabilized change
11