The output of the results via Excel are defined by the Excel-Templates.
Key words define which result is displayed on which place. A key word starts with< followed by the name of the key word. In the picture below you can find the key word <V1XWeight> in field B17. During evaluation the key words are searched in the template and replaced by the calculated results.
Informations about the keywords are given in the sections below.
Informations about a measurement
Informations about trigger conditions
Informations about working cycles
Informations about vibration channel groups and vibration channels
Informations about additional channels
Results of non-stationarity calculations
Informations about spectral analysis
Results of the additional channels
It is important that the key words exactly fit to the keyword definitions:
- The key word has to start with '<KeyWordName', without empty space between '<' and the key word name.
- Also between the last sign of the key word definition there should be no empty space.
- Upper lower cases are not distinguished ("MLAeq" and "MLAEQ" are both correct).
Measurement- and evaluation data are mainly displayed in tables. The row of the key word defines in which row this output will start. The data for each working cycle will be displayed, each working cycle in one row. To show which informations are displayed it is useful to give explanations for each column.
If a key word is not used in the template, the data according to the key word are not displayed.
key word name |
meaning of the key word |
<ProjectName> |
Name of the project |
<MeasComment> |
Comment of the measurement |
<MeasDate> |
Date and time of the measurement |
key word name |
meaning of the key word |
<Trig> |
trigger conditions for the evaluation
Please note, that for each active additional channel and each active trigger condition one line will be needed. the standard Excel templates provide room for 6 lines only, maximum of 24 lines is possible. If necessary, adjust your Excel template |
key word name |
meaning of the key word |
<ViName> |
Name of the vibration channel group. "i" means the index of the vibration channel group and has to be replaced by the index (<V1Name>, <V2Name>) |
<ViEval> |
Evaluation method of vibration channel group with index i (<V1Eval>, <V2Eval>) |
<ViXWeight> |
Weighting factor for the x-channel of vibration channel group with index i (<V1XWeight>, <V2XWeight>) |
<ViYWeight> |
Weighting factor for the y-channel of vibration channel group with index i (<V1YWeight>, <V2YWeight>) |
<ViZWeight> |
Weighting factor for the z-channel of vibration channel group with index i (<V1ZWeight>, <V2ZWeight>) |
<ViXFilter> |
Filter for the x-channel of vibration channel group with index i ( <V1XFilter>, <V2XFilter>) |
<ViYFilter> |
Filter for the y-channel of vibration channel group with index i |
<ViZFilter> |
Filter for the z-channel of vibration channel group with index i |
<SensoriName> |
Name of the sensor (e.g. type, serial number), for vibration channel group with index i (<Sensor1Name>, <Sensor2Name>) |
key word name |
meaning of the key word |
<ViX> |
RMS of the weighted acceleration of the X-channel for each working cycle in vibration channel group with index i. |
<ViY> |
RMS of the weights acceleration of the Y-channel for each working cycle in vibration channel group with index i. |
<ViZ> |
RMS of the weights acceleration of the Z-channel for each working cycle in vibration channel group with index i. |
<ViRes> |
Hand arm vibrations: Vector sum of the RMS of the weighted acceleration of the x-, y-, and z-channel for each working cycle for vibration channel group with index i Whole body vibrations: Maximum of the weighted x, y and z RMS of the weighted accelerations for each working cycle for vibration channel group with index i |
<ViXmax> |
Maximum of the weighted RMS of the weighted RMS of the weighted acceleration of the x-channel for each working cycle in vibration channel group with index i. |
<ViYmax> |
Maximum of the weighted RMS of the weighted RMS of the weighted acceleration of the y-channel for each working cycle in vibration channel group with index i. |
<ViZmax> |
Maximum of the weighted RMS of the weighted RMS of the weighted acceleration of the z-channel for each working cycle in vibration channel group with index i. |
<ViResMax> |
Hand arm vibrations: Vector sum of the maxima of the RMS of the weighted accelerations of the x-, y- and z channel for each working cycle in vibration channel group with index i. Whole body vibrations: Maximum of Xmax, Ymax, Zmax of the frequency weighted acceleration of the weighted x-, y- and z-channel for each working cycle in vibration channel group with index i. |
<MexpEH> |
duration of exposure until the daily exposition limit is reached in hours. |
<MexpEM> |
duration of exposure until the daily exposition limit is reached in minutes. |
key word name |
meaning of the key word |
<ZiName> |
Name of additional channel with index i (<Z1Name>, <Z2Name>...) |
<ZiUnit> |
Unit of additional channel with index i (<Z1Unit>, <Z2UnitUnit>...) |
key word name |
meaning of the key word |
<ZiMin> |
Minimum of the additional channel with index i for each working cycle |
<ZiMean> |
Mean of the additional channel with index i for each working cycle |
<ZiMax> |
Maximum of the additional channel with index i for each working cycle |
key word name |
meaning of the key word |
<ANo> |
Index of the working cycle |
<AName> |
Name of the working cycle |
<AFrom> |
Start of the working cycle since the beginning of the measurement in seconds |
<ATo> | End of the working cycle since the beginning of the measurement in seconds |
key word name |
meaning of the key word |
|
|
using frequency weighted accelerations |
|
|
|
<awXi> |
RMS of weighted acceleration of X-channel for each working cycle in vibration channel group with index i. |
<awYi>
|
RMS of weighted acceleration of Y-channel for each working cycle in vibration channel group with index i. |
<awZi>
|
RMS of weighted acceleration of Z-channel for each working cycle in vibration channel group with index i. |
<aw,erwXi> |
enhanced RMS of weighted acceleration of X-channel for each working cycle in vibration channel group with index i. |
<aw,erwYi> |
enhanced RMS of weighted acceleration of Y-channel for each working cycle in vibration channel group with index i. |
<aw,erwZi> |
enhanced RMS of weighted acceleration of Z-channel for each working cycle in vibration channel group with index i. |
<IFwXi> |
Non-stationarity factor of weighted acceleration of X-channel for each working cycle in vibration channel group with index i. |
<IFwYi> |
Non-stationarity factor of weighted acceleration of Y-channel for each working cycle in vibration channel group with index i. |
<IFwZi> |
Non-stationarity factor of weighted acceleration of Z-channel for each working cycle in vibration channel group with index i. |
<ExXi> |
Excess kurtosis of weighted acceleration of X-channel for each working cycle in vibration channel group with index i. |
<ExYi> |
Excess kurtosis of weighted acceleration of Y-channel for each working cycle in vibration channel group with index i. |
<ExZi> |
Excess kurtosis of weighted acceleration of Z-channel for each working cycle in vibration channel group with index i. |
<FXi> |
Form factor of weighted acceleration of X-channel for each working cycle in vibration channel group with index i. |
<FYi> |
Form factor of weighted acceleration of Y-channel for each working cycle in vibration channel group with index i. |
<FZi> |
Form factor of weighted acceleration of Z-channel for each working cycle in vibration channel group with index i. |
<KuXi> |
Kurtosis of weighted acceleration of X-channel for each working cycle in vibration channel group with index i. |
<KuYi> |
Kurtosis of weighted acceleration of Y-channel for each working cycle in vibration channel group with index i. |
<KuZi> |
Kurtosis of weighted acceleration of Z-channel for each working cycle in vibration channel group with index i. |
<SXi> |
Skew of weighted acceleration of X-channel for each working cycle in vibration channel group with index i. |
<SYi> |
Skew of weighted acceleration of Y-channel for each working cycle in vibration channel group with index i. |
<SZi> |
Skew of weighted acceleration of Z-channel for each working cycle in vibration channel group with index i. |
|
|
using unweighted accelerations |
|
|
|
<awXUi> |
RMS of unweighted acceleration of X-channel for each working cycle in vibration channel group with index i. |
<awYUi> |
RMS of unweighted acceleration of Y-channel for each working cycle in vibration channel group with index i. |
<awZUi> |
RMS of unweighted acceleration of Z-channel for each working cycle in vibration channel group with index i. |
<aw,erwXUi> |
enhanced RMS of unweighted acceleration of X-channel for each working cycle in vibration channel group with index i. |
<aw,erwYUi> |
enhanced RMS of unweighted acceleration of Y-channel for each working cycle in vibration channel group with index i. |
<aw,erwZUi> |
enhanced RMS of unweighted acceleration of Z-channel for each working cycle in vibration channel group with index i. |
<IFwXUi> |
Non-stationarity factor of unweighted acceleration of X-channel for each working cycle in vibration channel group with index i. |
<IFwYUi> |
Non-stationarity factor of unweighted acceleration of Y-channel for each working cycle in vibration channel group with index i. |
<IFwZUi> |
Non-stationarity factor of unweighted acceleration of Z-channel for each working cycle in vibration channel group with index i. |
<ExXUi> |
Excess kurtosis of unweighted acceleration of X-channel for each working cycle in vibration channel group with index i. |
<ExYUi> |
Excess kurtosis of unweighted acceleration of Y-channel for each working cycle in vibration channel group with index i. |
<ExZUi> |
Excess kurtosis of unweighted acceleration of Z-channel for each working cycle in vibration channel group with index i. |
<FXUi> |
Form factor of unweighted acceleration of X-channel for each working cycle in vibration channel group with index i. |
<FYUi> |
Form factor of unweighted acceleration of Y-channel for each working cycle in vibration channel group with index i. |
<FZUi> |
Form factor of unweighted acceleration of Z-channel for each working cycle in vibration channel group with index i. |
<KuXUi> |
Kurtosis of unweighted acceleration of X-channel for each working cycle in vibration channel group with index i. |
<KuYUi> |
Kurtosis of unweighted acceleration of Y-channel for each working cycle in vibration channel group with index i. |
<KuZUi> |
Kurtosis of unweighted acceleration of Z-channel for each working cycle in vibration channel group with index i. |
<SXUi> |
Skew of unweighted acceleration of X-channel for each working cycle in vibration channel group with index i. |
<SYUi> |
Skew of unweighted acceleration of Y-channel for each working cycle in vibration channel group with index i. |
<SZUi> |
Skew of unweighted acceleration of Z-channel for each working cycle in vibration channel group with index i. |
key word name |
meaning of the key word |
<FFTResolution> |
FFT resolution as selected in the dialogue |
<Image> |
Insert location for FFT graphic. The height of the row is automatically adjusted to the height of the graphic. |
<LegendX> |
Legend for graphic: Here the image of the color of the X-channel is displayed. Next to the box to the right the letter "X" is displayed |
<LegendY> |
Legend for graphic: Here the image of the color of the Y-channel is displayed. Next to the box to the right the letter "Y" is displayed |
<LegendZ> |
Legend for graphic: Here the image of the color of the Z-channel is displayed. Next to the box to the right the letter "Z" is displayed |
<FFTResults> |
From here, the individual results of the FFT are inserted. In the column under <FFTResults> |