In-Situ Win-Situ 4 / Pocket-Situ 4 Operators Manual - Manual (Page 89)

89 SECTION 11: FLOW-SENSE WIZARD
rev. 003 11/04
EXPORT TO EXCEL OPTION
To automatically create an output report in Microsoft® Excel™ from Win-
Situ
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 Low Flow 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.
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.
TIP: If Excel is
not set up to run
macros, you may
be asked how you wish to
handle the macros in this
template. For best results,
be sure to Enable the
Macros.
TIP: To export
low flow data to
Excel, first
transfer the low flow data
file(s) from the PDA to a
desktop or laptop PC and
open them in Win-Situ.
Instructions for transferring
data files are given in
Section 10 of this guide.