Creating your own Excel Template

Field Text Name

Meaning of Field Text

<UEAVLAeq>

Over Threshold Level LAeq [dB] (Upper Exposure Action Value)

<LEAVLAeq>

Lower Threshold Level LAeq [dB] (Upper Exposure Action Value)

<UEAVLCPeak>

Over Threshold Level LCPeak [dB] (Upper Exposure Action Value)

<LEAVLCPeak>

LowerThreshold Level LCPeak [dB] (Upper Exposure Action Value)

<ProjectNote>

Comments are recorded in this field that can be entered in the Project Info Dialogue.

<Graphic H="5.54">

Graphics are recorded in this field that can be entered in the Project Info Dialogue. The entry "H" represents the height in cm that the graphic should be. The graphic will then be automatically adapted to this height.

Remark:

In order to acquire the optimal height, during the design of the template it has proven best to insert the desired graphic in the correct spot and then to stretch it to the desired size. Then to right click on the graphic and select "Format Graphic". Under size one can than see the current height in cm.
They know then with a right mouse-click on the diagram "diagram to format" select, under "size" can you then the current height in cm see.

<MeasType>

Precision Class of the level meter

<InvestigationInsecurity>

Uncertainty Allowance according to the precision class of the level meter

<AddInfo Label="Firma" Index="1" Optional="N">

As much additional project information as required can defined to the project in the Excel Template . This information will be displayed in the Project Info Dialogue and can be edited there.

The definition of the additional project information happens as follows:

The name of the field text is <AddInfo. In addition the parameters Label, Index and Optional can be entered within the the field text.

Label defines what additional information text in the dialogue "Project Info" from the table should be displayed. 

 
Index defines in what order the additional project information from the project info dialogue should be shown. If no index is defined than the additional project information will be displayed in the order found within the worksheet. This parameter can also be left out.

Field Text Name

Meaning of Field Text

<TimePersonal>

total assessment time in minutes for the personal work evaluation, normally 480 minutes (=8 hours)

<LEXTpersonal>

personal noise exposure Lex,T in dB for personal work evaluation

Is calculated by:

Lex,T = 10 * Log10 ( (Sum (Ti * 10 0.1 * LAeq,middle ) ) / Tges )

Field Text Name

Meaning of Field Text

<MFileName>

Measurement File Name

<MNote>

Description of the measurement (will be displayed in the main dialogue in the  measurement table)

<MDate>

Date and Time of the measurement

Field Text Name

Meaning of Field Text

<MLAEQ>

LAeq of the measurement

<MLCEQ>

LCeq of the measurement

<MLAIEQ >

LAIeq of the measurement

<MLCPEAK>

LCpeak of the measurement

<MKq>

Impulse allowance Kq for this measurement. Kq is calculated as follows:

Kq = 0,  when LAIeq - LAeq < 2

Kq = LAIeq – LAeq, when LAIeq - LAeq greater or equal to 2

<MSOUNDCLASS>

Noise Class (Type of Noise). Is calculated as follows:

"HM", if LCEQ - LAEQ <= 5

"L" otherwise

<MLEX8h>

middle load based on 8 hours Lex,8h. Is calculated as follows:

LAr8h  = LAIeq , if LAeq >= 85 AND LAeq < 90 AND LAIeq >= 90 AND Kq > 2

otherwise:

LAr8h = LAeq

<MLEAVexceeded>

the lower threshold level (lower Exposure Action Value) for Lex,8h has been exceeded (Enter „Yes“ or „No“). This threshold level was set at 80 dBA in the European Union Directive 2003/10/EC.

<MUEAVexceeded>

the upper threshold level (upper Exposure Action Value) for Lex,8h has been exceeded (Enter „Yes“ or „No“). This threshold level was set at 85 dBA in the European Union Directive 2003/10/EC.

<Mactions ...>

Description of Measures that must be taken if the threshold level is exceeded.
The following parameters can then be entered:

No: This text will be displayed if no threshold level is exceeded.

LEAVexceededText: This text is displayed if the lower threshold level is exceeded.

UEAVexceededText: This text is displayed if the upper threshold level is exceeded.

Example:

If a detailed description of the necessary measures is listed in the Excel Templates footnotes * 1 and/or. *2, the field text could be displayed in this way:

<MActions No="-" LEAVexceededText="see *1" UEAVexceededText="see *1, *2">

Field Text Name

Meaning of Field Text

<MNr>

Number of period of exposure

<Mawx>

frequency-weighted r.m.s. vibration acceleration value in m/s² in x-direction, average over the total period of measurement

<Mawy>

frequency-weightedr.m.s. vibration acceleration value in m/s² in y-direction, average over the total period of measurement

<Mawz>

frequency-weighted r.m.s. vibration acceleration value in m/s² in z-direction, average over the total period of measurement

<MdailyH>

dailyduration of exposure / hours

<MdailyM>

dailyduration of exposure / minutes

<MexpAH>

duration of exposure until achievement of the daily action value/ hours

<MexpAM>

duration of exposure until achievement of the daily action value/ minutes

<MexpEH>

duration of exposure until achievement of the daily exposure limit value / hours

<MexpEM>

duration of exposure until achievement of the daily exposure limit value / minutes

Field Text Name

Meaning of Field Text

<Mawx8>

judgement acceleration value() of partial exposure in m/s² in x-direction,  normalised to an eight-hour reference period

<Mawy8>

judgement acceleration value of partial exposure in m/s² in y-direction,  normalised to an eight-hour reference period

<Mawz8>

judgement acceleration value of partial exposure in z-direction,  normalised to an eight-hour reference period

<Mpexi>

score of exposition for partial exposure in x-direction

<Mpeyi>

score of exposition for partial exposure in y-direction

<Mpezi>

score of exposition for partial exposure in z-direction

<Max8>

daily exposure value in m/s² in x-direction, normalised to an eight-hour reference period

<May8>

daily exposure value in m/s² in y-direction, normalised to an eight-hour reference period

<Maz8>

daily exposure value in m/s² in z-direction, normalised to an eight-hour reference period

<Mpex>

daily total of score of exposition in x-direction

<Mpey>

daily total of score of exposition in y-direction

<Mpez>

daily total of score of exposition in z-direction

<Mmaxai8>

daily exposure value A(8), normalised to an eight-hour reference period

<MmaxPei>

daily exposure score PE, normalised to an eight-hour reference period

Field Text Name

Meaning of Field Text

<Mahv>

total value of the frequency-weighted acceleration values in m/s²

<Mahv8>

daily exposition total ahv(8) in m/s²

<Mpei>

score of exposition PEi

<MA8>

daily exposure value normalised to an eight-hour reference periodin m/s²

<Mpe>

daily total of score of exposition PE

<Maction>

Text for actions required. Text may be:

If action value is not exceeded:

'no actions required'

If action value exceeded, but not exposure limit value exceeded:

'actions required'

If exposure limit value is exceeded:

'root cause analysis, immediate measures!'

Field Text Name

Meaning of Field Text

<MExposureTime>

TWA, time-weighted average Ti (Only for personal work protection evaluation)

<MTWALevel>

Partial Assessment Level LAeq,middle. Is calculated as:

LAeq,middle = Lex,8h  + 10 * Log10 ( TWA / 480 )

Field Text Name

Meaning of Field Text

<ConfManufacturer>

Device Manufacturer

<ConfName>

Device Designation

<ConfSerialNumber>

Serial Number of the Device

<ConfCalibration>

Date of the last Calibration of the Device