Crystal nVision Lab Reference - Manual (Page 12)

Data Management  10
CrystalControl Operation Manual
—
Data ManageMent
In order to provide for a flexible reporting solution, CrystalControl is capable of directly interfacing with Microsoft® Excel to paste recorded run data for
archiving, reporting, graphing, and analysis. CrystalControl Excel templates must be in Excel 2003 (.xlt) format, and exported Excel files will be in Excel 2003
(.xls) format. This section assumes some familiarity with Excel.
exporting Data
One of CrystalControl’s greatest strengths is the ability to create a multitude of .xls/.csv files using an Excel template. This allows the data file to be fully cus-
tomized, including the use of graphics and foreign languages. CrystalControl creates data files by filling an Excel template with the appropriate stored data,
replacing tags that identify the fields that are to be filled. Specifically, CrystalControl does search-and-replace operations in the template worksheet named
“Data”. Refer to Excel Template Tags for a list of tags that can be included in the data files.
CrystalControl uses the template file specified in the Settings. You can edit this setting by going to Tools menu, selecting Settings, and choose the Export Data
Settings tab. You can either Browse to a new template you have created, or edit the existing template by using Windows to browse to the currently selected
file. By default, CrystalControl uses a template file titled “nVisionDataView” that is located in the Public or Shared Documents folder (Windows Vista or 7: Public
Documents\Crystal Engineering\CrystalControl\Templates), (Windows XP: Shared Documents\Crystal Engineering\CrystalControl\Templates).
Due to the limitations of Excel 2003 it is only possible to graph a total of 32,000 rows of data into any one graph. If your downloaded run is greater than 32,000
data points, subsequent data will be moved to a newly created sheet(s) in the same file where you may create a new graph. Comma Separated Value (.csv)
data will all be exported to one file regardless of the number data points. The PDF and Signed PDF options will graph all logged data points and include the
.xls and .csv files as attachments.