68
Getting Started with DT800
dataTaker
UM-0071-A0
10-2
E
OGGER
’
S
S
PREADSHEET
W
INDOW
A DeLogger
spreadsheet
window is a standard
spreadsheet into which you can load (“dump”) an
entire DeLogger replay file one row per timestamp,
one column per channel. Then you use standard
spreadsheet tools to manipulate and analyse the data.
You can also
• load the contents of the spreadsheet into Microsoft
Excel (if it’s installed on your computer) with a single
command
• export the contents of the spreadsheet in a variety of
formats.
The spreadsheet window is different from the form
window in several ways:
• The form window is a dynamic display of incoming
data; the spreadsheet window is a static display of
historical data.
• Each row in the form window displays a variety of
information from one channel; each row in the
spreadsheet window displays just channel readings
from one scan that may include many channels,
each in a separate column.
The Spread Menu
When a spreadsheet window is DeLogger’s front-most
window, the seventh menu on DeLogger’s menu bar is
Spread
(see Figure 20 on page 27). Commands on
this menu are specific to the spreadsheet window, and
some are duplicated by buttons on the spreadsheet
toolbar.
Formula bar
Spreadsheet toolbar
Load
a replay file (.dlr).
Set
print range
Load
the current worksheet into
Excel
(opens Excel).
Scale view
down
(zoom out)
Scale view
up
(zoom in)
Show/hide
gridlines
Show/hide row and column
headers
Left, centre, or right
align
contents of selected cell(s)
Set number of
decimal places
of selected cell(s)
Rename a worksheet by
double-clicking its tab
(the Sheet Name dialog
box opens)
.
Double-
right
-click anywhere
in a worksheet to open it in
the Formula One Workbook
Designer, where additional
commands are available if
you need them (for example,
Sheet > Insert Sheet, Sheet >
Delete Sheet, Data > Recalc).
F
IGURE
71
A new DeLogger spreadsheet window
Summary of Contents for DT800
Page 1: ...UM 0071 A0 ...
Page 2: ...UM 0071 A0 ...
Page 73: ...UM 0071 A0 ...
Page 74: ...UM 0071 A0 ...