13.2. Data Import to Excel
Open the worksheet “Import”. If previous measurement data appears in the table,
please save the file under another name and then click “Clear tables” to erase all
measurements from the tables. Connect the VM31 to a USB port on the PC and
switch it on. If not done before, install the device driver (section 12). Click “Import
measurements from VM31”. The device with its virtual COM port will be automati-
cally detected. In rare cases detection may fail, due to other connected USB hard -
ware using virtual COM ports. It may be necessary to disconnect such hardware be-
fore data transfer.
The messages in the “Status” field inform you about import progress. Data import
may take between a few seconds and some minutes depending on the amount of
data. When the transfer is completed Excel will automatically sort the data into the
following worksheet columns: record number, date, time, comment, mode, filter and
the measurements of X/Y/Z and A. Columns B and C contain the combined values.
13.3. Calculation of Vibration Exposure A(8) and VDV(8)
Vibration exposure A(8), and alternatively, VDV(8), are both used for the risk as-
sessment of human vibration. They can be calculated based on hand-arm (H/A) and
whole-body measurements (W/B). Use the check boxes in the left column of the
import worksheet to select the data to be included in the vibration exposure calcula-
tion. Alternatively, you may click “Select all”. After selecting the data, click the
button “Transfer selected data to daily exposure worksheets”. This will transfer the
relevant records to the worksheets. These worksheets are available for RMS based
hand-arm and whole-body measurements and VDV based whole-body measure-
ments.
A message box will show you how many records have been transferred.
Select and open a worksheet according to the type of calculation you require “A(8)
RMS H-A”, “A(8) RMS W-B” or “Daily VDV W-B”.
Vibration exposure can be calculated for several persons and activities, i.e. partial
exposures. For this purpose there are two drop down menus for each record. The ten
cells “Person” and “Activity” above the table may be overwritten with your own
text. The changes you have made will be shown in the drop down menus the next
time you transfer data.
28
Figure 46: Excel import
