0% found this document useful (0 votes)
927 views58 pages

ITPAK Training Manual PDF

This document provides an overview and instructions for using USB-ITPAK software. USB-ITPAK allows direct input of measurement data from tools connected via USB into Microsoft Excel. It supports sequential, batch, and individual measurement input. The overview outlines the supported functions, including directly inputting data to inspection tables, multi-point batch measurement, random individual measurements, and foot switch control. It also provides cautions, such as not changing Excel files used in the software. The instructions cover starting up the software, connecting devices, and descriptions of the software's measurement modes and configuration dialog boxes.

Uploaded by

jake Tipones
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
927 views58 pages

ITPAK Training Manual PDF

This document provides an overview and instructions for using USB-ITPAK software. USB-ITPAK allows direct input of measurement data from tools connected via USB into Microsoft Excel. It supports sequential, batch, and individual measurement input. The overview outlines the supported functions, including directly inputting data to inspection tables, multi-point batch measurement, random individual measurements, and foot switch control. It also provides cautions, such as not changing Excel files used in the software. The instructions cover starting up the software, connecting devices, and descriptions of the software's measurement modes and configuration dialog boxes.

Uploaded by

jake Tipones
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 58

JNT

USB-ITPAK

Training Manual

pg. 1
Table of Contents
Overview ........................................................................................................................................................ 3
System Configuration ..................................................................................................................................... 4
Technical Terms .............................................................................................................................................. 5
Starting up USB-ITPAK ................................................................................................................................... 6
Connecting the measuring tool and foot switch to the PC ........................................................................... 6
Connecting the USB dongle to the PC ........................................................................................................ 6
Exiting USB-ITPAK ..................................................................................................................................... 7
Disconnecting the USB dongle from the PC ................................................................................................ 7
Disconnecting the measuring tool and foot switch from the PC ................................................................... 7
Sequential Measurement ................................................................................................................................ 8
Batch Measurement ..................................................................................................................................... 17
Individual Measurement................................................................................................................................ 25
DIALOG BOX CONFIGURATIONS OF USB-ITPAK ..................................................................................... 33
[Save (Excel file)] button ........................................................................................................................... 35
[Save (Text file)] button ............................................................................................................................. 35
Main Dialog Box ........................................................................................................................................... 36
[Setting] menu ........................................................................................................................................... 39
Data Collection menu ................................................................................................................................ 39
[About] menu ............................................................................................................................................. 39
Device Information........................................................................................................................................ 40
Device Information Setting ............................................................................................................................ 41
Options ......................................................................................................................................................... 42
Adding and Changing Procedures (Excel/Sequential or Batch) .................................................................... 43
Cell movement direction & cell displacement interval ................................................................................ 46
Cell address assign rules .......................................................................................................................... 47
Data Entry Device Settings (Excel/Sequential or Batch) ............................................................................... 48
Data entry device setting for date and time ............................................................................................... 50
Character String Data Settings ..................................................................................................................... 52
Foot Switch Option Settings ......................................................................................................................... 53
Adding and Changing Procedures (Excel/Individual) .................................................................................... 54
Data Collection ............................................................................................................................................. 55
Resuming operation (For the timer job option) .......................................................................................... 57
Timer Job Option Setting .............................................................................................................................. 57

pg. 2
Overview
USB-ITPAK is software for inputting measurement data of measuring tools connected to the USB Input
Tool Direct (hereafter referred to as USB-ITN), U-WAVE, USB Input Tool to Microsoft Excel (hereafter re-
ferred to as Excel).

USB-ITPAK supports the following functions to input data to Excel.

1. Inputting measurement data directly to inspection table sheets on Excel


2. Inputting multi-point measurement data using measurement jigs at a time

3. Randomly inputting measurement data from multiple measuring tools to worksheets


4. Request for data output to measuring tool using foot switch

5. Inputting character string such as "PASS" or "FAIL" using foot switch

General Cautions Regarding Use


Carefully read the following cautions before using USB-ITPAK.

1. Handling Excel files registered in USB-ITPAK procedures.


USB-ITPAK manages Excel files by using the Excel workbook and worksheet names registered to proce-

dures. Therefore, do not make the following changes to Excel files registered to procedures in Excel:

・Deleting or changing workbook and worksheet names


・Saving a workbook in a different folder

2. Handling Excel files currently used for data collection


Do not perform the following manipulations in Excel while collecting data by executing a procedure in USB-
ITPAK:

・Exiting Excel
・Closing an Excel file registered to a procedure
・Changing the contents of an Excel file registered to a procedure.

3. Executing procedure test (recommended)


Multiple procedures can be registered to the setting file of USB-ITPAK to provide a complex procedure that
can be run as a whole. Before running procedures, it is recommended to check their operation by testing
them beforehand.

pg. 3
System Configuration
An example of the system configuration is shown in the figure below.

*2 *1
Statistical Calculation Printer
*3
"DP-1VA" Measuring tool
*2
*1

USB Input Tool "IT-016U"


Measuring tool Measuring tool
USB Input Tool Direct "USB-ITN"

*2

USB Foot Switch Adapter "USB-FSW"


No.06ADV384 / 06AEJ484 for Korea
Software for setup and data collection U-WAVE
USB-ITPAK (This product)
No.06AFM386 USB dongle
Measuring tool
PC (accessory)

*1: Digimatic Connecting Cable


*2: Foot Switch No. 937179T / 12AAJ088
*3: Commercially-available USB cable (A - Micro B)

USB-ITPAK operates only when the supplied USB dongle is connected to the PC. Con-
nect the USB dongle to the PC before using USB-ITPAK. In addition, USB-ITPAK operates only when
the version of USB dongle is the same or higher than that of USB-ITPAK. When using a USB dongle
not supplied, check the version.

Serial label

USB dongle(Serial side)


###:Version display Example

pg. 4
Technical Terms

1. Device No.
The device No. displayed on each the USB connector ("A" plug) of the USB-ITN unit, USB-FSW unit,
USB dongle, U-WAVE, IT-016U, and DP-1VA unit is individual identification information. These de-
vices Nos. are fixed and cannot be changed.
2. Procedure
The procedure consists of information that specifies the data collection method in USB-ITPAK. This
information includes the Excel file that is the output destination, the USB-ITN / U-WAVE / IT-016U /
DP-1VA unit to be used, the input method ("sequential", "batch", etc.), the cell movement direction
following input ("down", "right", etc.).
The procedure is saved as a "setting file" by USB-ITPAK.

3. Setting files
These are the files for saving the "procedures" used in USB-ITPAK (file extension: itp ,it2).

4. Sequential measurement
Sequential measurement is a measurement method that can be selected in the "procedure" used by
USB-ITPAK.
During sequential measurement, one or more measuring tools are used and the measurement data is
input from the measuring tool(s) registered beforehand in the procedure to an Excel inspection table
sheet.

5. Batch measurement
Batch measurement is a measurement method that can be selected in the "procedure" used by USB-
ITPAK.
During batch measurement, measurement data is acquired in batch from multiple measuring tools.

6. Individual measurement
Individual measurement is a measurement method that can be selected in the "procedure" used in
USB-ITPAK.
For individual measurement, the worksheet and cells to which the measurement data is input are set
for each measuring tool. This method allows multiple operators to randomly perform measurement,
and the measurement data from each measuring tool is input to the respectively specified cells.

7. Data entry application


When selecting [Excel], data input is available only in Excel (2002 or higher).
Data input is not available using spreadsheet software other than Excel (such as OpenOffice Calc).

pg. 5
Starting up USB-ITPAK

Connecting the measuring tool and foot switch to the PC


1. Connect the measuring tool to USB-ITN and connect USB-ITN to a USB port of the PC.
2. Connect the foot switch to USB-FSW and connect USB-FSW to a USB port of the PC.

3. Connect the measuring tools to U-WAVE-T and connect U-WAVE-R to the USB port of the PC.

• Do not use USB-ITPAK and U-WAVEPAK at the same time.


Be sure to exit U-WAVEPAK before starting up USB-ITPAK.
Be sure to exit USB-ITPAK before starting up U-WAVEPAK.
The VCP communication may fail when both of them are used at the same time.

Connecting the USB dongle to the PC


1. Connect the supplied USB dongle to a USB port on the PC to be used.

2. Click the Start button of Windows and select [All Programs] - [USB-ITPAK], and then [USB-ITPAK].

3. If a shortcut icon is created on the desktop, USB-ITPAK can be started up by double- clicking this
icon.

Main dialog box is displayed for operators who create the setting file.

All the functions of USB-ITPAK, from setting of the procedure to data collection, can be used from this
dialog box.

pg. 6
Quick Menu is displayed for operators who collect data

Operators can start measurement by clicking the [Data collection] button to open an already set procedure
(setting file). Quick Menu is very useful for performing actual measurement work.

Exiting USB-ITPAK

Perform one of the two following ways to exit USB-ITPAK.

1. Click [Exit] button in Quick Menu.


2. Select [File] and then [Exit] on the main dialog box.

Disconnecting the USB dongle from the PC


Exit USB-ITPAK before disconnecting the USB dongle from the PC.

Disconnecting the measuring tool and foot switch from the PC


Exit USB-ITPAK before disconnecting any of USB-ITN, USB-FSW, U-WAVE-R, IT-016U or DP-1VA
from the USB ports of the PC.

pg. 7
Sequential Measurement
Sequential measurement is one of the measurement methods that can be selected in the procedures
used in USB-ITPAK.During sequential measurement, one or more measuring tools are used and
measurement data is input from the tools to cells specified in advance in an inspection table work-
sheet in Excel or other applications.
Example: Measurement in a pre-set sequence such as measuring the length, and
then the width by using one measuring tool
Example: Sequential measurement of measurement locations on a workpiece using
multiple measuring tools, such as measuring the length by using a caliper and
measuring the diameter by using a micrometer

1) Connection

In the example used in this section, one measuring tool is connected to USB-ITN. The
connection diagram is shown below.

Measuring tool

USB Input Tool Direct


USB-ITN x 1

USB dongle (accessory)

Setting & data collection software


USB-ITPAK (this product)

PC

2) Workpiece for measurement

The following workpiece is used in the explanation. The measurement locations are the
length, width, and height of the rectangular parallelepiped.

Length

Height Width

pg. 8
3) Measurement

The image of the inspection table upon completion of data collection is shown below.

In this measurement procedure, the length, width, and height of the first workpiece are
measured and the input data is output to the first row (Length), the second row (Width),
and the third row (Height), respectively, of the X1 column on the Excel worksheet.
Next, the second workpiece is similarly measured, and so on, until all five workpieces
have been measured.

Length (1)

Width (1)

Height (1) Height (5)

The following describes how to set up the measurement procedure, perform measurement,
and save the results.
Setting
1) Check the device information. From the menu of the main dialog box, select [Settings] and
then [Device information]. This opens the [Device information] dialog box, which allows
you to check the devices that are connected to the PC.If you do not want to change the
device number or device name, click the [Cancel] button to return to the main dialog box.
If you want to change the device number or device name, click the [Setting] button.

Click the [OK] button if you change any settings.

pg. 9
2) Enter information about the setting file in the [Description] field. Enter a de-
scription of the setting file. This field may be left blank.

2)

3)

3) Add a procedure to the setting file.

Click the [Add Procedure] button on the main dialog box.

4) Select a procedure type for the [Procedure type] field.

4) 5)

6)
7)
8)

9)

10)

11)

Check that [Sequential] is selected as the procedure type, and if not, select
[Sequential] from the drop-down list.
5) Enter a name in the [Procedure name] field. Entering the procedure name is re-
quired. Here, enter [3 side measurement].

6) Specify an Excel file in the [Workbook] field under [Excel settings].

Enter the workbook name of the Excel file to which the measured data is to be input. The file can
be selected from the [Open] dialog box by clicking the […] button.
Here, select the following file.

C:\Mitutoyo\USB-ITPAK\Sample\ITPAK_Sample_Form_1_GB.xls

pg. 10
7) Select a worksheet for the [Worksheet] field under [Excel settings].

Select the worksheet name to be included in the workbook of step "6)" from the drop- down list.

8) Enter the input range in the [Range of cells] fields under [Excel settings].

To specify the area indicated by the dot-line in the above inspection table as the input cell range, enter:
First: H11
Last: L13

TIP • The inspection table above is shown with the [Inspection item] and [Permissible value]
cells filled.

9) Select the desired direction for the [Move after return direction] field under [Excel settings].
During measurement using USB-ITPAK, once data is input from the measuring tools, the measurement
data is input to the current cell and then the entry point (cell) automatically moves to the next cell.
In the inspection table example shown above, select [Down].
10) Specify the [Displacement intervals] under [Excel settings].
Specify the interval for the cell movement specified in step 9). Specifying "1" results in movement to the
next cell. Specifying "2" results in movement to the cell after the next.
In the inspection table example above, specify "1".

pg. 11
11) Select an option under [Cell address assign rules].

In USB-ITPAK, the measuring items can be assigned to columns (vertical) or rows (horizontal)
of the inspection table worksheet.

In the inspection table example above, the measuring items are assigned to respective
rows, so select [Assign for the rows (1, 2…)].

12) Specify the [Data entry devices] settings.

The functions of the buttons for the [Data entry devices] field are as follows:

[+]: Adds device settings.

[−]: Deletes the device setting selected from the list.

[]: Changes the device setting selected from the list.

Here, click the [+] button to switch to the [Data entry device settings] dialog box.

12)

pg. 12
13) Specify the settings in the [Excel cells assignment] field on the [Data entry device settings] dialog box.

13)

14)

15)

In the [Excel cells assignment] field, specify columns (vertical) or rows (horizontal) according to the
specification in step 11). Specify the rows here.

There are three input areas in the previously described inspection table. Here, one device is assigned on
all the rows, so enter start row number "11" in the input field on the left, and input "13" in the input field on
the right.

14) In the [Entry data settings] field, select the entry data type.

The entry data types consist of measurement data input from the measuring tools (numeric data), and
character string data input by pressing the foot switch.

Here, select the [Measurement data entry] radio button.

15) In the [Select device] field, select the device to be assigned. From the drop-own list, select the device to

be assigned.

This completes the settings on the [Data entry device settings] dialog box, so click the [OK] button.

pg. 13
16) Close [Add procedure].

This completes the settings on the [Add procedure] dialog box, so click the [OK] button.

17) Save the created setting file.

From the menu of the main dialog box, select [File], [Save As], and then save the file by giving it a name.
When the file has been saved, the file name is displayed as a full path in the [Setting File] field.

pg. 14
Measurement
1) Open [Setting File].

From the menu of the main dialog box, select [File] and then [Open], or open [Setting
file] from [Recent files].

2) Open the data collection dialog box.

From the menu of the main dialog box, select [Data Collection] and then [Start], or click
the icon shown below.

When data collection starts, the message [Do you want to collect data after cancel
the current data?] is displayed. Click [Yes] to clear the existing data or [No] not to.

The data collection dialog box is displayed and data collection can now be performed.

3) Perform data collection.

During data collection, the cell to which data will be input next is highlighted in green.

pg. 15
Input data from the measuring tools through one of the following operations:

a. Pressing the DATA switch on the measuring tool.

b. Pressing the DATA switch if USB-ITN has one.

c. Clicking the [Data request] button on the data collection dialog box.

To cancel data that has been input, click the [Data cancel] button on the data collection dialog
box. The data in the entry cell is canceled and the previous cell is highlighted.
To skip the current data entry cell without inputting data, click the [Data skip] button on the data col-
lection dialog box. The next cell is highlighted.

4) End data collection and save the results.

Once all the data has been input, a completion message is displayed on the data col-
lection dialog box.

Click the [Stop] button on the data collection dialog box. The following message is dis-
played.

[Yes]: The Excel file to which data was input is saved through overwriting under the existing
file name.
[No]: The Excel file is not overwritten and the data that was input is deleted.

[Cancel]: The message dialog box is closed and the data collection dialog box is displayed.
Click the [Yes] button. The Excel file is saved through overwriting and the dialog box
switches to the main dialog box.
This completes basic data collection for sequential measurement.

pg. 16
Batch Measurement

Batch measurement is one of the measurement methods that can be selected in the procedures used in USB-
ITPAK.
During batch measurement, multiple measuring tools are used to acquire measurement data in batch.
Example: Multiple measuring tools are attached to measuring jigs and workpieces
are set to these jigs, and then measurement data is collected from all the connect-
ed measuring tools by using a foot switch, etc.
The [Data request] button of USB-ITPAK, function keys of a PC, and the foot switch can be used when collect-
ing measurement data.

1) Connection

In the example used in this section, three indicators are connected to USB-ITN. The connection dia-
gram is shown below.

USB Input Tool Direct


USB-ITN x 3
Measuring tool x 3
USB dongle (accessory)

Setting & data collection software


USB-ITPAK (this product)

PC

2) Workpiece for measurement

The following workpiece is used in the explanation. Three indicators are used and measurement is
done with measuring jigs. "Size A", "Size B", and "Size C", which are shown in the figure below, are
measured.
Size B

Size A Size C

pg. 17
3) Measurement

The image of the inspection table upon completion of data collection is shown below.

The measurement procedure is as follows. The three locations of the first workpiece are measured,
and the input data is output to the "Size A", "Size B", and "Size C" columns. Next, the three locations
of the second workpiece are measured, and the input data is output to the "Size A", "Size B", and
"Size C" columns in the "Sample 2" row of the Excel worksheet.
The remaining workpieces up to the tenth one are measured in the same manner.
Batch (1)
Batch (2)

Batch (10)

Setting

The following describes how to set up the measurement procedure, perform measurement, and save the
results.

1) Check the device information.

From the menu of the main dialog box, select [Settings] and then [Device information]. This opens the
[Device information] dialog box, which allows you to check the devices that are connected to the PC.

Click the [OK] button if you change any settings.

pg. 18
2) Enter information about the setting file in the [Description] field. Enter a descrip-
tion of the setting file. This field may be left blank.

2)

3)

3) Add a procedure to the setting file.

Click the [Add Procedure] button on the main dialog box.

4) Select a procedure type for the [Procedure type] field.

4) 5)

6)
7)
8)

9)

10)

11)

Check that [Batch] is selected as the procedure type, and if not, select [Batch] from the drop-down list.
5) Enter a name in the [Procedure name] field. Entering the
procedure name is required.
Here, enter [3 position batch measurement].

6) Specify an Excel file in the [Workbook] field under [Excel settings].

Enter the workbook name of the Excel file to which the measured data is to be input. The file can be se-
lected from the [Open] dialog box by clicking the […] button.
Here, select the following file.C:\Mitutoyo\USB-ITPAK\Sample\ITPAK_Sample_Form_3_GB.xls

pg. 19
7) Select a worksheet for the [Worksheet] field under [Excel settings].

Select the worksheet name to be included in the workbook of step "6)" from the drop- down list.
Here, select [Sample_F3].

8) Enter the input range in the [Range of cells] fields under [Excel settings].

To specify the area indicated by the dot-line in the above inspection table as the input cell range, enter:

First: D18
Last: F27
9) Select the desired direction for the [Move after return direction] field under [Excel settings].
During measurement using USB-ITPAK, once data is input from the measuring tools,
the measurement data is input to the current cell and then the entry point (cell) auto-
matically moves to the next cell.
In the inspection table example shown above, select [Down].
10) Specify the [Displacement intervals] under [Excel settings].
Specify the interval for the cell movement specified in step 9). Specifying "1" results in
movement to the next cell. Specifying "2" results in movement to the cell after the
next. In the inspection table example above, specify "1".
pg. 20
11) Select an option under [Cell address assign rules].
In USB-ITPAK, the measuring items can be assigned to columns (vertical) or rows (horizontal) of the
inspection table worksheet.
In the inspection table example above, the measuring items are assigned to respective col-
umns, so select [Assign for the columns (A, B…)].
12) Specify the [Data entry devices] settings for the first device.
The functions of the buttons for the [Data entry devices] field are as follows:
[+]: Adds device settings.
[−]: Deletes the device setting selected from the list.
[]: Changes the device setting selected from the
list.
Here, click the [+] button to switch to the [Data entry device settings] dialog box.

12)

pg. 21
13) Specify the settings in the [Excel cells assignment] field on the [Data entry device settings] dialog box.

13)

14)

15)

In the [Excel cells assignment] field, specify columns (vertical) or rows (horizontal) according to the
specification in step 11). Specify the columns here.

There are three input areas in the previously described inspection table. Here, the first device is as-
signed to the D column, which is the first column, so enter "D" in both fields.

14) In the [Entry data settings] field, select the entry data type.
The entry data types consist of measurement data input from the measuring tools (numeric data),
and character string data input by pressing the foot switch.

Here, select the [Measurement data entry] radio button.

15) In the [Select device] field, select the device to be assigned. From the drop-down list, select the device
to be assigned. Here, select the first device.
This completes the settings on the [Data entry device settings] dialog box for the first device, so
click the [OK] button.

16) Repeat steps "12) to 15)" to specify the [Data entry device] settings for the second device. Here, as-

sign the second device to the E column.

17) Repeat steps "12) to 15)" to specify the [Data entry device] settings for the third device.
Here, assign the third device to the F column.

18) Close [Add procedure]. This completes the settings on the [Add procedure] dialog box, so click the
[OK] button.

pg. 22
19) Save the created setting file.

Measurement

From the menu of the main dialog box, select [File], [Save As], and then save the file by giving it a name.
When the file has been saved, the file name is displayed as a full path in the [Setting File] field.

1) Open [Setting File].


From the menu of the main dialog box, select [File] and then [Open], or open [Setting file] from
[Recent files].
2) Open the data collection dialog box.
From the menu of the main dialog box, select [Data Collection] and then [Start], or click the icon
shown below.

When data collection starts, the message [Do you want to collect data after cancel the current
data?] is displayed. Click [Yes] to clear the existing data or [No] not to.

The data collection dialog box is displayed and data collection can now be performed.

pg. 23
3) Perform data collection.

During data collection, the cell to which data will be input next is highlighted in green.

Click the [Data request] button on the data collection dialog box and perform data input from the
measuring tools.
To cancel data that has been input, click the [Data cancel] button on the data collection dialog box.
The data in the entry cell is canceled and the previous cell is highlighted.
To skip the current data entry cell without inputting data, click the [Data skip] button on the data col-
lection dialog box. The next cell is highlighted.

4) End data collection and save the results.

Once all the data has been input, a completion message is displayed on the data col-
lection dialog box.

Click the [Stop] button on the data collection dialog box. The following message is dis-
played.

This completes basic data collection for batch measurement.

pg. 24
Individual Measurement

Individual measurement is one of the measurement methods that can be selected in the procedures used in
USB-ITPAK.
During individual measurement, measurement data from multiple operators can be input to the
respectively assigned cells in the specified Excel worksheet.
Example: Collection of data while three operators perform measurements with their respective
measuring tools.
The DATA switch of the measuring tool and the foot switch can be used when collecting measurement data.

1) Connection

In the example used in this section, three measuring tools are connected to USB-ITN. The connection
diagram is shown below.

Measuring tool x 3

USB Input Tool Direct


USB-ITN x 3

US Bdongle (accessory)

Setting & data collection software


USB-ITPAK (this product)
PC

2) Workpieces for measurement

The following workpieces are used in the explanation. The measurement location is the overall length of
the same workpiece for all three operators (designated as A, B, and C).

Operator A Operator B Operator C

Overall length Overall length Overall length

pg. 25
3) Measurement

The image of the inspection table upon completion of data collection is shown below.

The measurement procedure is as follows. Operator A, Operator B, and Operator C each


measure the width of the first workpiece, and the input data is output to the first row (for Opera-
tor A), fourth row (for Operator B), and seventh row (for Operator C) of the X1 column on the
Excel worksheet. Next, the second workpiece is measured in the same manner, with each op-
erator measuring 15 workpieces in all.

A(1)
A(2)
Input by Operator A

A(15)

B(1)
B(2)

Input by Operator B
B(15)

C(1)
C(2)

Input by Operator C
C(15)

The following describes how to set up the measurement procedure, perform measurement, and
save the results.

pg. 26
Setting
1) Check the device information. From the menu of the main dialog box, select [Settings] and then
[Device information]. This opens the [Device information] dialog box, which allows you to
check the devices that are connected to the PC.

Click the [OK] button if you change any settings.

2) Enter information about the setting file in the [Description] field. En-
terdescription of the setting file. This field may be left blank.

2)

3) Add a procedure to the setting file.

Click the [Add Procedure] button on the main dialog box.

4) Select a procedure type for the [Procedure type] field.

If [Individual] is selected, the dialog box switches to the following dialog box.

4) 5)

6)

If a different dialog box is displayed, select [Individual] from the drop-down list.

pg. 27
5) Enter a name in the [Procedure name] field. Entering the procedure name is required.
Here, enter [3 posi. individual measurement].

6) Specify the [Data entry devices] settings for the first device.

The functions of the buttons for the [Data entry devices] field are as follows:
[+]: Adds device settings.
[−]: Deletes the device setting selected from the list.

[]: Changes the device setting selected from the list.

Here, click the [+] button to switch to the [Data entry device settings] dialog box.

7) In the [Entry data settings] field, select the entry data type.

7)
9)
8)
10)

11)

12)

13)

The entry data types consist of measurement data input from the measuring tools (numeric data),
and character string data input by pressing the foot switch.
Here, select the [Measurement data entry] radio button.

8) In the [Select device] field, select the device to be assigned. From the drop-down list, select the
device to be assigned. Here, select the first device.
9) Specify an Excel file in the [Workbook] field under [Excel settings]

Enter the workbook name of the Excel file to which the measured data is to be input. The file
can be selected from the [Open] dialog box by clicking the […] button.
Here, select the following file. C:\Mitutoyo\USB-ITPAK\Sample\ITPAK_Sample_Form_4_GB.xls

10) Select a worksheet for the [Worksheet] field under [Excel settings].
Select the worksheet name to be included in the workbook of step "9)" from the drop- down list.
Here, select [Sample_F4].

pg. 28
11) Enter the input range in the [Range of cells] fields under [Excel settings].

To specify the area indicated by the dot-line in the above inspection table as the input cell range, enter:
First: H11
Last: L13

12) Select the desired direction for the [Move after return direction] field under [Excel settings].
During measurement using USB-ITPAK, once data is input from the measuring tools, the measure-
ment data is input to the current cell and then the entry point (cell) automatically moves to the next cell.
In the inspection table example shown above, select [Right].
13) Specify the [Displacement intervals] under [Excel settings].
Specify the interval for the cell movement specified in step 12). Specifying "1" results in movement
to the next cell. Specifying "2" results in movement to the cell after the next.
In the inspection table example above, specify "1".
This completes the settings on the [Data entry device settings] dialog box for the first device, so
click the [OK] button.
14) Repeat steps "6) to 13)" to specify the [Data entry device] settings for the second device.
Here, assign the second device to the [H14:L16].

pg. 29
15) Repeat steps "6) to 13)" to specify the [Data entry device] settings for the third device. Here, assign
the third device to the [H17:L19].

16) Close [Add procedure].

This completes the settings on the [Add procedure] dialog box, so click the [OK] button.
17) Save the created setting file.

From the menu of the main dialog box, select [File], [Save As], and then save the file by giv-
ing it a name. When the file has been saved, the file name is displayed as a full path in the
[Setting File] field.

pg. 30
Measurement
1) Open [Setting File].
From the menu of the main dialog box, select [File] and then [Open], or open [Setting file] from [Recent
files].
2) Open the data collection dialog box.

From the menu of the main dialog box, select [Data Collection] and then [Start], or click the icon shown
below.

When data collection starts, the message [Do you want to collect data after cancel the current data?] is
displayed. Click [Yes] to clear the existing data or [No] not to.

The data collection dialog box is displayed and data collection can now be performed.

3) Perform data collection.

During data collection, the cell to which data will be input next is highlighted in green.

Input data from the measuring tools through one of the following operations:

(1) Pressing the DATA switch on the measuring tool.


(2) Pressing the DATA switch if USB-ITN has one.

pg. 31
4) End data collection and save the results.

Once all the data has been input, a completion message is displayed on the data collection dia-
log box.

Click the [Stop] button on the data collection dialog box. The following message is displayed.

This completes basic data collection for individual measurement.

pg. 32
DIALOG BOX CONFIGURATIONS OF USB-ITPAK
1. Quick Menu (6.1) 2. Main Dialog Box (6.2) 2.1 Device Information (6.3)

2.1.1 Device Information Setting 2.2 Options (6.5) 2.3 Adding and Changing Proce-
(6.4) dures (Excel/Sequential or
Batch) (6.6)

2.3.1 Data Entry Device Settings 2.3.2 Character String Data 2.3.4 Foot Switch Option Settings
(Excel/Sequential or Batch) Settings (6.8) (6.9)
(6.7)

2.3 Adding and Changing 2.3.1 Data Entry Device Settings 2.4 Adding and Changing Pro-
Procedures (Excel/Individual) (Excel/Individual) (6.11) cedures (Optional) (6.12)
(6.10)

2.4.1 Data Entry Device Settings 3. Data Collection (6.14)


(Optional) (6.13)

pg. 33
Quick Menu
If the [Display the Quick menu] option is enabled, Quick Menu is displayed when USB- ITPAK starts up.
Quick Menu is a dialog box for operators who collect data. By clicking the [Data collection] button to open
the setting file, measurement can be started quickly, making Quick Menu a useful feature for the execution
of actual measurement work.

1)

2)

3)

4)

5)

1) [Data collection] button

Opens an already created setting file and executes data collection according to that procedure.
For the operation method, refer to "6.1.1 [Data collection] button".

2) [Save (Excel file)] button

Saves the Excel file to which measurement data is input, after data collection. For the operation
method, refer to "6.1.2 [Save (Excel file)] button".
3) [Save (Text file)] button

Saves the measurement data as a text file, after data collection. For the operation
method, refer to "6.1.3 [Save (Text file)] button".
4) [Switch to the main dialog box] button Switches the dialog box to

the main dialog box.


5) [Exit] button
Exits USB-ITPAK.

[Data collection] button


An already created setting file is opened and data is collected according to the procedure in the
file.
1) Select the setting file to be executed on the [Open] dialog box.

Select the setting file (extension: itp, it2) from the list of files, and then click the [Open] but-
ton.
2) Collect data.

When the [Do you want to collect data after cancel the current data?] message is displayed,
click either the [Yes] or [No] button.

pg. 34
The data collection dialog box is displayed and the Excel inspection table file specified in
the setting file is opened, so data collection starts.

[Save (Excel file)] button


After data has been collected, the Excel file to which measurement data is input is saved.

1)

2)

3) In the [Select the save workbook] field, select the file that is to be saved. Select the
file to be saved from the drop-down list.
4) Select the method for saving the file.

In the [Save] field, select either [Overwrite] or [Save Copy As].

5) Click the [OK] button to save the file.

When [Save Copy As] is selected in the [Save] field, the [Save As] dialog box is displayed, so
enter the file name and save the Excel file.
If multiple Excel workbooks are used in the setting file, perform steps 1) to 3) above for each file
to be saved.

[Save (Text file)] button


The measurement data is saved to a text file after data has been collected.

1) 2)

3)

6) Select the desired method in the [Save method] field.

Select the method for specifying the range of data to be saved from the measurement data
on the Excel worksheet.
• [Follow the procedure setting range]
The range specified for [Range of cells (specify the A1 reference style)] on the [Add procedure] dialog box
for the setting file is selected.

pg. 35
• [Selected range]
Directly select the cell range on the displayed Excel worksheet.

7) Select the separator in the [Separator] field.


Select the character for separating Excel columns when saving Excel worksheet data to a text file. Select
either [TAB], [Comma], or [Semicolon].
8) Specify the settings in the [Select an Excel subject for save] field.
• Select the procedure to save in the [Select procedure] field.
• Select the Excel workbook registered to the procedure to be saved, in the [Workbook] field.
9) Click the [OK] button to save the file.

The [Save As] dialog box is displayed, so enter the file name and click the [Save] button.

Main Dialog Box


If the [Display the Quick menu] option is disabled, the main dialog box is displayed when USB-
ITPAK starts up.
The main dialog box is a window for operators creating setting files. All the functions of USB-
ITPAK, from procedure setting to data collection, can be used from this dialog box.

1)
2) 2)
3)
4)
16)
5)

6) 11)
7)

8)
9)
12)
10)
17)

18) 14) 13)

15)

1) Menu bar
The functions of USB-ITPAK can be accessed using the menu bar.

2) Tool bar
The functions of USB-ITPAK can also be accessed using the tool bar.

3) [Setting file] field


Displays the path name of the setting file that is currently opened.

4) [Description] field
Enter a description of the setting file in this field. This field can be left blank.

pg. 36
5) [Data entry application] field
Select the application to which data is input in this field.
• [Excel]
Data is input to Excel.
• [Optional]
Data is input to an optional application (such as the Notepad or Word) that is active during data collection.

6) [Repetition option] field


If [Repeat procedure] is selected in this field, the procedure registered in step "11)" is performed multiple
times during data collection.

7) [Number of repeat] field


This field can be specified only if [Repeat procedure] is selected. Enter how many times to repeat the
procedure.

8) [Move direction] field


This field can be specified only if [Repeat procedure] is selected.
When the procedure is repeated during data collection, the data entry cell is shifted at each execution. The
cell movement direction at such time is selected in this field. Either [Right] or [Down] can be selected.

9) [Displacement intervals] field


This field can be specified only if [Repeat procedure] is selected.
When the procedure is repeated during data collection, the data entry cell is shifted at each execution.
The cell displacement interval is selected in this field.

10) [Error option] field


If the following errors occur during data collection, select whether to ignore them.

11) [Procedure] field


This field lists the names of the procedures that have been created. Multiple procedures
can be registered in the setting file.
12) [][] field
The sequence of procedures can be changed by clicking these buttons after selecting proce-
dures in the [Procedure] field.

13) [Add Procedure] button


This button is used to add a new procedure.

14) [Delete Procedure] button


This button is used to delete the procedure selected in the [Procedure] field.

15) [Change Procedure] button


This button is used to change the procedure selected in the [Procedure] field.

16) Procedure details display field


This field displays the information of the procedure selected in the [Procedure] field.

17) Field for displaying detailed information of device used for data collection
This field displays the information of the device (USB-ITN, USB-FSW, U-WAVE, IT- 016U, DP-
1VA) used for data collection in the procedure selected in the [Procedure] field.

18) [Timer job option] field


If selecting this field, the automatic input of the measurement data is available in the specified in-
terval.

pg. 37
[File] menu

The [File] menu is used to load and save setting files.

1)
2)
3)
4)
5)
6)
1) 2) 3) 4) 6)
7)

1) [New]

Creates a new setting file.


This operation can also be performed by clicking icon 1) on the tool bar.

2) [Open]

Loads a setting file that was saved.


This operation can also be performed by clicking 2) on the tool bar.

3) [Save]
Overwrite and saves the setting file.
This operation can also be performed by clicking icon 3) on the tool bar.

4) [Save As...]
Saves the setting file with a different name.
This operation can also be performed by clicking icon 4) on the tool bar.

5) [Recent Files]

When the setting file displayed in the sub-menu of this menu is selected, that setting file is loaded. The
five files that have been loaded or saved the most recently are registered to the sub-menu.
6) [Switch to the quick menu]

Switches the dialog box to the Quick Menu.


This operation can also be performed by clicking icon 6) on the tool bar.

7) [Exit]
Exits USB-ITPAK.

pg. 38
[Setting] menu
The [Setting] menu is used to display device information, add, delete, and change pro-
cedures, and also specify option settings related to the operation of USB-ITPAK.

1)
2)
3) 2)
4)
5) 3)
4)
2) 3) 4)
1) [Device Information]
Displays the [Device information] dialog box.
2) [Add Procedure]
Adds a new procedure to the setting file that is opened.
This operation can also be performed by clicking icon 2) on the tool bar or button 2) on the main
dialog box.
3) [Delete Procedure]
Deletes the procedure selected in the [Procedure] field on the main dialog box. This operation
can also be performed by clicking icon 3) on the tool bar or button 3) on the main dialog box.
4) [Change Procedure]
Changes the procedure that is selected in the [Procedure] field on the main dialog box.This operation
can also be performed by clicking icon 4) on the tool bar or button 4) on the main dialog box.
5) [Option]
Displays the [Option] dialog box.

Data Collection menu


The Data Collection menu on the menu bar is used to start data collection and save data after data col-
lection.

1)
2)
3)

1) [Start] 1) 2) 3)
Collects data according to the setting file.
This operation can also be performed by clicking icon 1) on the tool bar.
2) [Save to Excel file]
Saves the Excel file to which the collected data was input.
This operation can also be performed by clicking icon 2) on the tool bar.

3) [Save to Text file]


Saves the collected data as a text file.
This operation can also be performed by clicking icon 3) on the tool bar.
[About] menu
Displays the version information of USB-ITPAK.
pg. 39
Device Information

The [Device information] dialog box is displayed by selecting [Setting] and then [Device information]
from the menu described in "6.2 Main Dialog Box".

This dialog box displays any of the USB-ITN, USB-FSW, U-WAVE-R, IT-016U, or DP-1VA connected
to the PC.

1)

2)

1) [Device lists] field

Displays all the USB-ITN, USB-FSW, U-WAVE-R, IT-016U and DP-1VA units connected to
the PC and to which the dedicated VCP driver has been installed.

2) [Setting] button

When a device is selected in the [Device lists] field and then the [Setting] button is clicked, the
[Device information setting] dialog box is displayed.

3) [OK] button

Applies the changes on the [Device information setting] dialog box and returns to the main dialog
box.
4) [Cancel] button

Clears the changes on the [Device information setting] dialog box and returns to the main dialog
box.

pg. 40
Device Information Setting

Clicking the [Setting] button on the dialog box described in "6.3 Device Information" displays the [Device in-
formation setting] dialog box for the device that was selected in the [Device lists] field on the [Device infor-
mation] dialog box.
The device information settings are specified on this dialog box.

1)

2)
3)

1) [Device information] field

Displays the information of the device that was selected. The setting cannot be changed.
2) [Serial No.]
Displays the lower 8 or 10 digits of the device number of the selected device.

Displays the device number of USB-ITN, USB-FSW, IT-016U or DP-1VA in 8 digits and that of U-WAVE-R in
10 digits.
3) [Type]
Displays the upper 3 alphabetic characters of the device No. of the selected device. [ITN] stands for USB-ITN
/ IT-016U, [FSW] stands for USB-FSW, [UWR] stands for U-WAVE-R, and [DP1] stands for DP-1VA.
4) [COM]

Displays the COM port number assigned to the device.


5) [Device No.] field

The device No. is information that identifies the USB-ITN, USB-FSW, U-WAVE-R, IT-016U or
DP-1VA unit. This information is registered to the procedure.
In the initial state, the device number recorded on the USB-ITN, USB-FSW, U- WAVE-R, IT-
016U or DP-1VA unit is displayed.

6) [Device name] field

Inputting the name of the measuring tool that is connected to USB-ITN, U-WAVE, IT-016U or
DP-1VA as the device name makes it easy to check the procedure settings.

pg. 41
Options
The [Option] dialog box is displayed by selecting [Setting] and then [Options] on the dialog box .
Various settings related to USB-ITPAK operations are specified on this dialog box.

1)

2)

3)

1) [Language] field
This field is used to select the language to be used in USB-ITPAK.

2) [Data format] field


If [Replace decimal symbol] is selected, USB-ITPAK uses the decimal symbol specified in Windows
as the decimal symbol for measurement data.
If [Replace decimal symbol] is not selected, USB-ITPAK uses "." (period) as the decimal symbol for
measurement data.

3) [Startup processing] field


This field is used to specify the settings for how USB-ITPAK behaves after it starts up.

4) [Load the setting file previously used]


When [Load the setting file previously used] is selected, the setting file that was used last is au-
tomatically loaded when USB-ITPAK starts up.

a. If the Quick Menu is set to be displayed, the setting file that was used last is used for data collection.
b. If the main dialog box is set to be displayed, the main dialog box is displayed with the setting file that
was used last open when USB-ITPAK starts up.

5) [Display the Quick menu]


If [Display the Quick menu] is selected, the Quick Menu is displayed when USB- ITPAK starts
up.If it is not selected, the main dialog box is displayed when USB-ITPAK starts up.

pg. 42
Adding and Changing Procedures
(Excel/Sequential or Batch)
Clicking the [Add procedure] button on the main dialog box described in "6.2 Main Dialog Box" displays
the [Add procedure] dialog box. Selecting a procedure in the [Procedure] filed and then clicking the
[Change procedure] button displays the [Change procedure] dialog box.
On the [Add procedure] dialog box, new procedures can be created and added to the setting file. On the
[Change procedure] dialog box, existing procedures can be changed.

The operation of the [Change procedure] dialog box is similar to the operation of the [Add procedure] dia-
log box.

1) 2)

3)
4) 11)
10)
5)

6)

7)

8)

13)
9) 12)

1) [Procedure type] field


Select either [Sequential], [Batch], or [Individual] as the type of data collection procedure.

2) [Procedure name] field


Enter the name of the procedure to be created. Entering the procedure name is required.

3) [Workbook] field
Enter the workbook name of the Excel file to which the measured data is to be input. The file can
be selected from the [Open] dialog box by clicking the […] button.

pg. 43
4) [Worksheet] field
Select the name of the sheet to which data is to be input from the drop-down list.
5) [Range of cells (specify the A1 reference style)] field
Specify the range of cells in Excel to which the collected data is to be input, in the A1 format.
Besides directly entering the cell numbers, the cell range can also be selected by using the [Se-
lect] button and inputting data on the Excel dialog box. This operation is explained in "6.6.1 Selec-
tion of data entry cell range in Excel".

6) [Move after return direction] field


Specify the movement direction of the Excel cell after data input ([Right] or [Down]). This operation
is explained in "6.6.2 Cell movement direction & displacement interval ".
7) [Displacement intervals] field
Specify the interval of Excel cell movement after data input. This operation is explained in "6.6.2
Cell movement direction & displacement interval".

8) [Cell address assign rules] field


Assign the cells to which data is to be input from the device to columns (vertical) or rows (horizon-
tal) on the Excel worksheet. Select according to the position of the measurement item. This opera-
tion is explained in "6.6.3 Cell address assign rules".

9) [FunctionKey Operation] field

The [Data request], [Data cancel], and [Data skip] functions can be assigned to the function keys (F1 to
F8) of the PC.
Select the function key to which a function is to be assigned from the drop-down list.

10) [Data entry devices] field

Displays the information of the data entry device assigned in Excel.

11) Buttons in [Data entry device] field


[+] button: Adds a data entry device in the [Data entry devices] field.

[−] button: Deletes the data entry device selected in the [Data entry devices] field.
[✓] button: Changes the settings of the data entry device selected in the [Data entry devices] field.

12) [Foot switch option] field

Displays the information of the USB-FSW unit registered in the foot switch option.

13) Buttons in [Foot switch option] field


[+] button: Adds a USB-FSW unit in the [Foot switch option] field.
[−] button: Deletes the USB-FSW unit selected in the [Foot switch option] field.
[✓] button: Changes the settings of the USB-FSW unit selected in the [Foot switch option] field.

pg. 44
Selection of data entry cell range in Excel
Regarding the input method for the [Range of cells (specify the A1 reference style)] field, besides
direct input, the range of data entry cells using the [Select] button and the Excel dialog box can be
selected.
1) On the Excel dialog box, specify the range of cells to which data is to be input.

H11

L13

2) Click the [Select] button on the [Add procedure] dialog box.

To specify the area indicated by the bold lines in the above inspection table as the input cell
range, enter:
First: H11 Last: L13

pg. 45
Cell movement direction & cell displacement interval
This section explains how to specify the cell movement direction and cell displacement interval, and
the operation during data collection.
1) Cell movement direction

Select the direction in which the Excel data entry cell moves after data input in the [Move after return
direction] field.

• If [Right] is selected:

• If [Down] is selected:

2) Cell displacement interval

• Select the displacement interval of the Excel data entry cell after data input in the [Cell displacement in-
terval] field.
Example: If [Down] is selected in the [Move after return direction] field and "2" is specified in the [Displace-
ment intervals] field, the cell for the next data entry moves two cells down.

• During sequential measurement, if the cells in the current row or column are filled in the specified
range, data input to the current row or column ends and the data entry cell moves to the next row
or column.
Example: If a cell range of 4 rows x 5 columns is selected in the [Range of cells (specify the A1 refer-
ence style)] field, [Down] is selected in the [Move after return direction] field, and "2" is specified in
the [Displacement intervals] field, data entry in the first column ends when the third row has been
input, and the cell for the next data entry moves to the second column.

pg. 46
Cell address assign rules
The cells to which data is to be input from a device are assigned to columns (vertical) or rows (horizontal)
on the Excel worksheet. Select according to the position of the measurement item.

3) [Unspecified]
No device is assigned to Excel cells.
When data is input from the device registered in the procedure during data collection, the data is written to
the cell that is currently active in the order of input, regardless of the cell position.
4) [Assign for the columns (A,B,…)]
Assigns one device per column of a worksheet.
Example: The following figure shows the case when Tool 1 is assigned to [Column C], Tool 2 to [Column
D], Tool 3 to [Column E], Tool 4 to [Column F], and Tool 5 to [Column G]. The data input from Tool 1 is in-
put to cells C3, C4, and C5.

5) [Assign for the rows (1, 2…)]


Assigns one device per row of a worksheet.
Example: The following figure shows the case when Tool 1 is assigned to [Row 3], Tool 2 to [Row 4], and
Tool 3 to [Row 5]. The data input from Tool 1 is written to cells C3, D3, E3, F3, and G3.

pg. 47
Data Entry Device Settings (Excel/Sequential or
Batch)
Clicking the [+] button in the [Data entry devices] field on the dialog box described in "6.6 Adding
and Changing Procedures (Excel/Sequential or Batch)" displays the [Data entry device settings
(Excel/Sequential or Batch)] dialog box.
On this dialog box, the Excel range to be assigned as the data entry destination and the device
whose data is to be input can be selected.

1)

2)

3)

4)

1) [Excel cells assignment] field


Input the row numbers or column numbers of the Excel cells to which the data entry device is to
be assigned.
This operation is explained in "6.7.1 [Excel cells assignment] field input".
2) [Entry data settings] field
Select the device whose data is to be input in the range specified in the [Excel cells assignment]
field.
Select either [Measurement data entry] or [Character string data entry].
• [Measurement data entry]
Input the measurement data from USB-ITN, U-WAVE, IT-016U or DP-1VA. Select the
device from the drop-down list in the [Select device] field.
When selecting U-WAVE (UWR), select the channel of U-WAVE-T to be used from the
[Channel:] field.

• [Character string data entry]


Input the character string data from USB-FSW. Click the [+] button in the [Character
string data entry] field and specify the character string data.
• [Date & Time data entry]
This field is available when one or more data entry devices have been set for [Data entry devices]
in advance.
pg. 48
In the [Select device:] field, select the data entry device to add the date and time. For details, re-
fer to "6.7.2 Data entry device setting for date and time".
3) Buttons in [Character string data entry] field
[+] button: Adds a USB-FSW unit in the [Character string data entry] field.
[−] button: Deletes the USB-FSW unit selected in the [Character string data entry] field.
[✓] button: Changes the settings of the USB-FSW unit selected in the [Character string data entry] field.
4) [Device information] field
The [Device information] field displays the information of the device selected in the [Entry data set-
tings] field.

[Excel cells assignment] field input


1) If the [Excel cells assignment] field displays [Assign for the rows (1, 2,...)], input the row numbers
(1, 2,…) in Excel in the A1 format.

2) If the [Excel cells assignment] field displays [Assign for the columns (A,B,...)], input the column
numbers (A, B,…) in Excel in the A1 format.

You can also perform input by specifying the range in Excel and clicking the [Select] button in the
[Excel cells assignment] field. This operation is explained below.
If you want to specify Tool 1 from [Column C] (or [Row 3]) to [Column E] (or [Row 5]), specify the
range as shown in the figure below and then click the [Select] button on the [Data entry device set-
tings] dialog box. As a result, "C" (or "3") is input in the left side of the [Excel cells assignment] field
and "E" (or "5") is input in the right side of this field.

pg. 49
Data entry device setting for date and time
When the setting for the date and time data input is performed for the measuring tool registered for the
measuring data input, the date and time data can be input at the time when the data of the measuring tool
is input.

Procedure type Cell address assign rules Availability


・Unspecified -
Sequential ・Assign for the columns(A,B,...) ✓
・Assign for the rows(1,2,...) ✓
・Unspecified -
Batch ・Assign for the columns(A,B,...) ✓
・Assign for the rows(1,2,...) ✓

Individual -

• When selecting [Sequential] for [Procedure type] in the [Change Procedure] dialog box, a date and time
data can be input for each data entry device.
• When selecting [Sequential] for [Procedure type] and [Unspecified] for [Cell address assign rules] in the
[Change Procedure] dialog box, the setting for the date and time data input is not available.
• When selecting [Batch] for [Procedure type] in the [Change Procedure] dialog box, a date and time data
can be input for one of the data entry devices registered for the procedure.
• When selecting [Individual] for [Procedure type] in the [Change Procedure] dialog box, the setting for the
date and time data input is not available.

The following describes the procedure of the date and time data input.

3) Switch to the [Data entry device settings] dialog box to select the date and time input settings. Set one or
more data entry devices for [Data entry devices] in advance.
Click the [+] button.

1)

4) Select [DateTime data entry] in the [Entry data settings] field.


The information on the device registered for the measuring data input and the information on the
Excel cell assignment will be displayed in the [Select device:] field.
Example:
ITN-89999013[A:A]
(1) (2)
(1) :Device information
(2) :Information on the Excel cell assignment

pg. 50
5) Input the range to assign the date and time in the [Excel cells assignment] field.
In the screenshot shown below, "D" has been input in the entry field to assign the date and time to
the [D] column.

3)

2)

Click the [OK] button if you change any settings.


6) The date and time has been added in the [Data entry devices] field.

4)
For the device information in the [Data entry devices] field in the [Change Procedure] dialog box, the in-
formation on the Excel cell range to which the date and time data is input and the data entry device in-
formation assigned for the date and time data input will be displayed.
Example:
ITN-69999013 D:D date and time [A:A]
(1) (2) (3) (4)
(1) : Data entry device information assigned for the date and time data input
(2): Information on the Excel cell assignment for the date and time data input
(3): Character string indicating the date and time data input
(4): Information on the Excel cell assignment for (1)

pg. 51
Character String Data Settings
Selecting [Character string data entry] in the [Entry data settings] field on the dialog box shown in
"6.7 Data Entry Device Settings (Excel/Sequential or Batch)" and clicking the [+] button displays the
[Character string data settings] dialog box.
On this dialog box, the USB-FSW unit used for inputting character string data can be selected and
the character string to be input can be input.

1)

2)

1) [Select foot switch] field

Select the USB-FSW unit used for inputting character string data from the drop-down list. The in-
formation of the selected device is displayed in the [Device information] field.

2) [Character string data] field

Input the character string to be input to Excel when the foot switch is pressed.

pg. 52
Foot Switch Option Settings

Clicking the [+] button in the [Foot switch option] field on the dialog box described in "6.6 Adding and
Changing Procedures (Excel/Sequential or Batch)" displays the [Foot switch options settings] dialog box.
On this dialog box, the USB-FSW unit for which the foot switch option is to be set and the function to be
set can be selected.

1)

2)

1) [Select foot switch] field

Select the USB-FSW unit to which a function is to be assigned from the drop-down list. The information
of the selected device is displayed in the [Device information] field.
2) [Function] field

Select the function to be executed when the foot switch is pressed from the drop- down list.
The [Data request], [Data cancel], or [Data skip] function can be assigned.

pg. 53
Adding and Changing Procedures
(Excel/Individual)
Clicking the [Add procedure] button on the main dialog box described in "6.2 Main Dialog Box" dis-
plays the [Add procedure] dialog box. Selecting a procedure in the [Procedure] filed and then click-
ing the [Change procedure] button displays the [Change procedure] dialog box.

1) 2)

3) 4)

5)

1) Procedure type] field

Select either [Sequential], [Batch], or [Individual] as the type of data collection procedure.

2) [Procedure name] field

Enter the name of the procedure to be created. Entering the procedure name is required.

3) [Data entry devices] field


This field displays the information of the registered data entry device.

4) Buttons in [Data entry devices] field


[+] button: Adds a data entry device in the [Data entry devices] field.
[−] button: Deletes the data entry device selected in the [Data entry devices] field.
[✓] button: Changes the settings of the data entry device selected in the [Data entry devices] field.

5) [Foot switch option] field


This field displays the information of the USB-FSW unit assigned to the USB-ITN, U- WAVE, IT-016U or
DP-1VA unit selected in the [Data entry devices] field in step "3)".

pg. 54
Data Collection

Clicking the [Data collection] button on the Quick Menu described in "6.1 Quick Menu" displays the
data collection dialog box. Alternatively, selecting the Data Collection menu and then [Start] from
the dialog box described in "6.2 Main Dialog Box", or clicking the [Data collection] button on the tool
bar also displays the data collection dialog box.
This dialog box is used to input data from a measuring tool to an application.

1)
2) 3)
4) to 9)
1) [Procedure] field
This field displays the procedure currently used to collect data.
2) [Guidance message] field
Displays the following guidance messages for the operator.
• [Execute import manipulations of measurement data] Input measure-
ment data in one of the following ways.
(1) Press the DATA switch on the measuring tool.
(2) In the case of a USB-ITN, U-WAVE, IT-016U or DP-1VA unit that has a DATA switch,
press the DATA switch.
(3) Click the [Data request] button on the data collection dialog box.
(4) If the [Data request] function is assigned to the foot switch, press the foot switch.
(5) If the [Data request] function is assigned to a function key, press that function key.
• [Please execute the foot switch operation.]
Input the character string data by pressing the foot switch connected to the USB- FSW unit to which
character string data input has been assigned.
• [Execute data entry operation.]
Input measurement data or character string data by using the USB-ITN, USB-FSW, U-WAVE, IT-
016U or DP-1VA unit.
• [The import of all pieces of measurement data has been completed.]
Data collection has been completed. Click the [Exit] button and save the measurement data.
3) [Data display] field
This field displays the data input from the device in the transmission command format.
4) [Data request] button Collects data.
5) [Data cancel] button
Cancels the data that was input.
6) [Data skip] button
Skips to the next data without inputting the current data.

pg. 55
7) [Pause] button Pauses data collection.
For the operation of this button, refer to "6.14.1 [Pause/Resume] button".
8) [Resume] button Resumes data collection that had been paused.
For the operation of this button, refer to "6.14.1 [Pause/Resume] button".
9) [Exit] button Exits data collection.

[Pause/Resume] button
1) Clicking the [Pause] button pauses data collection.

When the [Pause] button is displayed as the [Resume] button, as shown below, data collection is
paused.

In the paused state, the following operations are possible.

• Specify the start cell from which to resume data collection.

• Perform worksheet editing, such as character string input.

2) To resume data collection, click the [Resume] button.


Click the [Resume] button to display the [Cell address for the resumption] dialog box as shown be-
low. Next, select either one from the [Select the resumption cell] field, and click the [OK] button.

If the paused setting file consists of multiple procedures, the [Selection of restart procedure] field
on the [Cell address for the resumption] dialog box is active, so it is possible to resume from an-
other procedure.

To resume from another procedure, select [Shift to other procedure] and from the drop-down list in
the [Select procedure] field, select the procedure for data collection resumption.

The resumption cell position is the first cell if collection is resumed from another procedure.

pg. 56
Resuming operation (For the timer job option)
If the auto data collection using the timer job option is paused, it will be required to resume the timer job.

When pressing the keys [Ctrl], [Shift] and [Space] at the same time, the timer job will resume.

Timer Job Option Setting

The automatic input of the measurement data is available in the specified interval.

1)
2)
3)

1) [Timer job option] - [Enable] field

If selecting [Enable], items 2) and 3) will be activated for selection. This field
is available only with the batch measurement.

2) [Interval (hour: min: sec):]


Specify the interval for data request.
A value between 0.0 seconds and 24 hours (0:0:0.0 - 24:0:0.0) can be specified for [Interval].

pg. 57
NOTE • For the data collection, the time [T1] to load the measurement data will surely occur. Therefore, if the
value specified for the interval [T2] is smaller than [T1], the actual data collection interval [T3] may ex-
ceed the specified value. [T1] varies according to the type and total number of data entry devices or
measuring tools. [T1] per unit is 0.3 seconds when using USB-ITN / IT-016U, 0.1 seconds when using
U-WAVE-T and 1 seconds when using DP-1VA(Including prints). However, 0.5 seconds is included in
[T1] with U- WAVE-T, regardless of the number of devices.
Data entry Total
[T1] [T2] [T3]
device number
1 0.3 sec. <0.5 sec. 0.5 sec. The interval is the specified value.
USB-ITN
2 0.6 sec. >0.5 sec. 0.6 sec. The interval exceeds the specified
/ IT-016U
3 0.9 sec. >0.5 sec. 0.9 sec. value.
1 0.6 sec. =0.6 sec. 0.6 sec. The interval is the specified value.
U-WAVE-T 2 0.7 sec. >0.6 sec. 0.7 sec. The interval exceeds the specified
3 0.8 sec. >0.6 sec. 0.8 sec. value.

If [Interval] is less than "0.6 sec" when using U-WAVE-T, the measurement data may be collected
without data input even when the values for measuring tools have changed.

3) [Count:] field

Specify the number of time for data request. The upper limit of
specified value is 60000.

-END-

pg. 58

You might also like