Omega Vehicle Security 1400 manual Command Characters Data Destination Timeout Region

Command

Characters

Data Destination

Timeout Region

Link to Excel…

Upload Data

During

Acquisition

(automatic control)

Stop Upload

(Ctrl + J) (manual control)

This area contains two fields for entering command characters, one for row setting and one for column setting. Enter the characters (Excel parameters) to match the applicable version of Excel; for example:

France - Row = L, Column = C

Germany - Row = Z, Column = S United States - Row = R, Column = C.

Assign the Data Destination. This area allows you to assign the data destination on the Excel spreadsheet. Specify the data starting point by entering a number for row, and another for column. The two numbers designate the upper left hand corner cell of the Excel data entry.

Positioning Data in Excel. The data destination region also allows you to select one of three options in regard to positioning data in Excel on subsequent scans. Options are as follows:

Row 1 Column 1. This selection starts the next scan at the designated row and column on the Excel spreadsheet. Changing the values in the “Row” and “Column” boxes (above figure) will automatically enter the new values in the corresponding fields of the “Row # Column #” placement assignment. For example, If you entered a 3 in the row box and a 5 in the column box you would see Row 3 Column 5, instead of Row 1 Column 1, in the above figure; and the next scan would start at row 3 column 5 in Excel.

Row after last scan. When “Row after last scan” is selected the next scan will begin at the point in Excel where the previous acquisition left off.

Prompt each time. When “Prompt each time” is selected, after each acquisition is completed a dialog box will ask if you want to return to origin. If you select “Yes”, you will have an overwrite on the Excel spreadsheet, starting with the existing column and row designation. If you select “No,” the next scan will begin on the spreadsheet’s next row (from where the previous acquisition left off).

Increment the Row on each new scan. With this selected (9), the Excel spreadsheet will use multiple rows, one row for each new data scan. With no check-mark, the spreadsheet will make use of one row only and will continue to display the latest scan information in that row.

Timestamp Format. This feature can only be used if Timestamps have been enabled in the Setup/Destination dialog box. If this is the case, you can select a pre-configured format for the timestamps sent to the Excel spreadsheet. Available formats are indicated in the previous screen capture. This feature only affects the timestamp format in the Excel spreadsheet. It has no effect on timestamps saved to disk.

This field allows you to enter a DDE link timeout value from 5 to 3276 seconds. The value is how long the data import to Excel can be suspended while you perform a second Excel activity, such as displaying graphs, or saving data to disk. A screen message informs you when the DDE link is timed out, terminating the DDE link to Excel.

Creates DDE link to Excel spreadsheet. Excel must already be running, and Excel Format must be selected in the Setup/Data Destination dialog box.

Enables ChartView to retrieve scans from device memory as data becomes available. The acquisition is active.

Stops ChartView’s transfer of data from the instrument to disk.

ChartScan User’s Manual ChartView Software Reference 4-21