Data Collection Software for Excel USB-ITPAK V3.0
A desired measurement sequence to collect data into Excel can be created by using USB-ITPAK with an input tool or U-WAVE. Measurement applications of USB-ITPAK (Three examples of how USB-ITPAK can be deployed are shown below) Measurement Data Management USB-ITPAK V3.0 ( IT-016U / IT-020U / USB-ITN / U-WAVE / DP-1VA LOGGER connectable)
A
Sequential measurement Measurement values are collected from multiple measuring instruments as registered in the sequence
When a measuring procedure is executed, a window is displayed. “Data request*”, “Data cancel*”, “Data skip*”, “Aborting”, “Complete” can be specified. * These operations can be allocated to the function key or foot switch (via USB-FSW ).
X
(Measurement example – see figure at right)
Y
1) Measure outside diameter at X and Y of 5 workpieces with a micrometer.
U-WAVE-T , U-WAVE-TM/TC
Cell movement direction after inputting data (down and right) Carriage return (Low, column)
H
A B C D E F 1 Setting 1 2 3 4 5 2 Dimension X 10.025 10.033 9.964 10.031 10.046 3 Dimension Y 9.982 10.017 10.008 9.996 10.027 4 Dimension H 29.97 30.02 30.07 29.96 30.04 5 External Appearance OK OK NG
U-WAVE-R
Microsoft Excel sheet previously specified Input range of micrometer (B2 to F3) Input range of caliper (B4 to F4) Input range of visual judgment (B5 to F5)
USB hub (Commercial item)
USB-ITN-C The last data input may be canceled by pressing and holding the data switch.
2) Measure length H of 5 workpieces.
USB-FSW ×4 pcs. + Foot switch ×4 pcs.
3) Inspect external view to check if there are any scratches or color shading and input “OK” or “NG”.
Character strings Input “ OK ”
Character strings Input “ NG ”
Data request*
Data cancel
* No data request for U-WAVE .
Cell that will receive next input is highlighted in green
Simultaneous measurement Measurement values are input simultaneously from several Digimatic gages
U-WAVE-R
A B C D E
USB hub (Commercial item)
Height A
Height B
Height C
Height D
1
First measurement (finished) Second measurement (finished) Third measurement (finished) Fourth measurement (Wait for next input)
USB-ITN-F ×2
2 1 5.02 8.03 9.96 6.03 3 2 4.98 8.02 10.01 5.99 4 3 4.97 8.04 10.07 5.96
USB-FSW ×2 pcs. + Foot switch ×2 pcs.
U-WAVE-T ×2 pcs.
(Measurement examples) Simultaneous measurement of the heights A to D on the workpiece below.
5 4 6 5
Data request
Data cancel
Height A B C D
Individual measurement
U-WAVE-R Several operators input measurement data asynchronously according to individually defined procedures from each Digimatic gage.
(Measurement example) Two operators measure 6 workpieces 3 workpieces per operator
B
USB hub (Commercial item)
A
C
Operator 1
Operator 2
A B C D E F G 1 Setting 1 2 3 4 5 6 2 Dimension A 10.02 10.03 9.96 10.15 10.23 10.04 3 Dimension B 9.98 10.01 10.07 9.99 9.78 4 Dimension C 10.15 10.14 9.96 10.27
USB-ITN-C
U-WAVE-T
Notes on using USB-ITPAK V3.0 : Do not merge the cells in the specified range as a measurement data input. During measurement, the Microsoft Excel worksheet cannot be modified in any way apart from entering data. If you need to modify the sheet, it is necessary to abort or finish the measurement. U-WAVE fit Bluetooth ® and U-WAVE Wireless cannot be used together.
The last data input may be canceled by pressing and holding the data switch
Data request
Data cancel
Workpiece Nos. 1 to 3
Workpiece Nos. 4 to 6
Cell that will receive next input
Cell that will receive next input
Operator 1
Operator 2
USB-FSW × 2 pcs. + Foot switch × 2 pcs.
A-13
Powered by FlippingBook