HyQuest Solutions Pty Ltd
Point Velocity Display - Model PVD100
©
Copyright
38
Issue 1.00 4 Apr, 2007
8. In the ‘Delimiters’ window,
a) deselect ‘Tab’,
b)
select
‘Comma’,
c) select ‘Other’, then type ‘n’ in the box next to ‘Other’.
The text file preview should show a vertical line separating the meter counts
column data and the time data column.
9. Click ‘Next’, this will bring you to Step 3 of the Wizard.
10. In Step 3 window, click ‘Do not import column (skip)’ in the ‘Column data
format’ window. This will show ‘Skip’ in the column 1 heading.
11. Click on column 3 (where the Time data is shown in HEX-ASCII) and change
in the ‘Column data format’ window from ‘General’ to ‘Text’.
12. In the ‘Data Preview’ window, the columns should show the following
selections on the column heading:
a) ‘Skip’ for column 1
b) ‘General’ for column 2—Current meter counts
c) ‘Text’ for column 3—Time
13. Click ‘Finish’, and then click ‘OK’ to import data into the existing worksheet.
14. Save the workbook under a file name.
15. Shown below is an example of an imported ‘Spin Test’ file.
