MMF VM30-H, Инструкция по эксплуатации, Страница: 39 / 58

The Excel macro of the VM30-H allows the calculation of A(8) for several activities and
persons.
Precondition for A(8) calculation is saving several vibration total values (Ahv) by means of the
manual recording mode (compare page 29). For each activity of each person a measuring value
including an informative comment is saved.
When the A
hv
values are imported into the Excel macro, they will appear in addition to the
worksheet "Manual" also in the worksheet "A(8) Calculation". A running number, the entered
comment, date and time are added to the A
hv
values in this worksheet.
Now each A
hv
value must be assigned to a person and an activity. First of all the entries for
Person 1, Person 2 etc. in the upper part of the worksheet "A(8) Calculation" should be
overwritten with real names. The same is done with the activities.
Now assign line by line the measuring values in the left part (1.) of the table to the persons and
activities in the middle part (2.) using pull-down menus. In addition for each A
hv
value the
exposure duration must be entered in the format hh:mm. An example is shown in Figure 24.
When the assignment is finished, click on the button "Calculate A(8)". In the right part of the
table (3.) will appear the calculated daily exposure values for each person.
In the worksheet "A(8) Report" the results are recorded. In addition to the vibration total values
and the calculated vibration exposure values also interval RMS values a
hwix
, a
hwiy
and a
hwiz
are
listed if such values have been saved. For each activity a partial exposure vale A
i
(8) is calculated
which helps to evaluate the influence of individual activities. You may add information
regarding the measuring conditions, the test persons and the tested equipment. The prepared
protocol conforms with the requirements of ISO 5349. An example protocol can be found at the
end of this chapter.
Please do not forget to save the Excel macro under a new file name.
On the next page you see an example report for A(8) measuring results generated with the Excel
macro.
34
Figure 24: Example of A(8) calculation in Excel