DataLoggerXP User’s Manual • Page 15
C R Y S T A L
e n g i n e e r i n g
c o r p o r a t i o n
the gauge’s clock with the computer’s clock which will allow the time stamps to be correctly read.
However, if multiple resets have occurred with the gauge, only time stamps after the last reset will
be xed. When a reset occurs, it is stored as a run with a reset event and no data.
Excel Templates
In order to provide for a exible reporting solution, DataLoggerXP is capable of directly interfacing
with Microsoft® Excel to paste run data for reporting and graphing. DataLoggerXP supports Excel
95 through Excel 2003. This section assumes some familiarity with Excel.
Note: For information on how to save data to the dierent le types see “Saving”, on pg 11.
DataLoggerXP works with two Excel le types: workbook (.xls) les and template (.xlt) les. The
key dierence is when using a template le, the template is loaded and data is copied to a specic
location, whereas a workbook le is a new document with only the run data.
Workbooks
When using workbook les, Excel is started and a new workbook is created with the default work-
sheets. Data is then copied into the rst worksheet at cell location A1. The le is then saved using
the lename provided by the user. If the le already exists, it will be overwritten with the new
workbook le. Any formatting or reporting is then done by the user after the document is created.
Templates
As opposed to workbooks, templates use an existing Excel template le to create the new work-
book. This allows any amount of formatting or graphing to be done beforehand and stored as a
template le. Then, when the Excel workbook is created, the template le is opened and data is
copied to the location specied in the Options Dialog. When selecting the template le directly
during the le save process, the new workbook is created with the Excel template using the name
of the template le followed by a number, typically 1. The user must also save the le manually,
making any changes to the le name as necessary. However, it is possible to save directly to the
user provided le name, see section 3.2.2 below for more information.
As an example on how to use templates, a sample template le, DataLoggerXP.xlt, is located in the
DataLoggerXP program directory, and can be used as-is or modied to meet the user’s require-
ments.
Excel Password Protection
It is possible to password protect the Excel workbook by selecting the Password Protect Excel
Documents checkbox in the Options dialog. Only the data sheet and rst sheet of the workbook
will be password protected. To protect other sheets, password protect them in the template itself.
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Comentarios a estos manuales