{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Main","ExposureActionValue","ExposureLimitValue","WeeklyExposure","Instructions","Lookups"],"not_rendered":{"charts":0,"images":20,"macros":1,"external_links":0,"defined_names":85,"comments":4,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Main","index":0,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":false,"merged":[[3,2,3,5]]}
[]
[null,null,"Noise Calculator - Main menu",null,null,"V4-12 March 2021"]
[]
[null,null,"The  Control of Noise at Work Regulations 2005 define actions based on \n Exposure Action Values (LEAV and UEAV) and the Exposure Limit Value (ELV) for personal daily or weekly noise exposures."]
[]
[null,null,null,"Hover the cursor over yellow text for additional information"]
[]
[null,null,null,"Applicable to all daily noise exposure calculations:"]
[null,null,null,"For any noise exposure use the Daily Noise Exposure Action Value Calculator"]
[]
[]
[null,null,null,"Applicable for daily noise exposure calculations if you are using hearing protection to control noise risk:"]
[null,null,null,"Use the Daily Noise Exposure Limit Value Calculator if you are using hearing protection as part of your noise control programme"]
[]
[]
[null,null,null,"Applicable if you have daily noise exposure on one or two working days a week that is at least 5 dB higher than other days:"]
[null,null,null,"To estmate weekly exposures use the Weekly Noise Exposure Calculator"]

{"sheet":"ExposureActionValue","index":1,"n_rows":25,"n_cols":19,"rows_kept":25,"cut":false,"hidden":false,"merged":[[7,1,8,1],[7,2,8,2],[7,5,7,6],[7,8,7,9],[7,4,8,4],[3,2,3,13],[23,12,23,13],[24,12,24,13],[19,8,19,9],[17,13,18,13],[17,12,18,12],[17,8,18,9],[7,13,8,13],[7,12,8,12],[7,10,8,10],[21,12,21,13],[22,12,22,13]]}
[]
[null,null,"Daily Noise Exposure Action Value Calculator",null,null,null,null,null,null,null,null,null,null,{"$f":"VersionNumber","v":"V4-12 March 2021"},null,null,null,"LockTaskNames: ",false]
[]
[null,null,"The Control of Noise at Work Regulations 2005 define Lower and Upper Exposure Action Values (LEAV and UEAV) of 80 and 85 dB(A). \nThis calculator estimates the unprotected daily noise exposures of workers for comparison with the LEAV and UEAV."]
[]
[]
[]
[null,"Task1\nname / description","Noise level1\nLAeq (dB(A))",null,"Points per hour","Time (in hh:mm) to",null,null,"Daily exposure time1 ",null,"Exposure time (hh:mm)",null,"Personal noise exposure per task (dB(A))","Personal exposure points per task"]
[null,null,null,null,null,"LEAV","UEAV",null,"(hours)","(mins)"]
[null,"Task 1",null,null,{"$f":"IF(C10=\"\",\"\",10^(C10/10)*1/24/(Eighthours*10^(RefLevel/10))*RefPoints)","v":""},{"$f":"IF($C10=\"\",\"\",IF(Eighthours*10^((LEAV-$C10)/10)>=1,\">24hours\",Eighthours*10^((LEAV-$C10)/10)))","v":""},{"$f":"IF($C10=\"\",\"\",IF(Eighthours*10^((UEAV-$C10)/10)>=1,\"≥ 24 hours\",Eighthours*10^((UEAV-$C10)/10)))","v":""},null,null,null,{"$f":"I10/24+J10/24/60","v":"00:00:00"},null,{"$f":"IF(OR($C10=\"\",$K10=0),\"\",10*LOG10(10^($C10/10)*$K10/Eighthours))","v":""},{"$f":"IF(OR($C10=\"\",$K10=0),\"\",ROUND(10^($C10/10)*$K10/(Eighthours*10^(RefLevel/10))*RefPoints,0))","v":""}]
[null,"Task 2",null,null,"","","",null,null,null,{"$f":"I11/24+J11/24/60","v":"00:00:00"},null,{"$f":"IF(OR(C11=\"\",K11=0),\"\",10*LOG10(10^(C11/10)*K11/Eighthours))","v":""},""]
[null,"Task 3",null,0.22916666666666669,"","","",null,null,null,"00:00:00",null,"",""]
[null,"Task 4",null,2.0833333333333332E-2,"","","",null,null,null,"00:00:00",null,"",""]
[null,"Task 5",null,0.10416666666666666,"","","",null,null,null,"00:00:00",null,"",""]
[null,"Task 6",null,2.0833333333333332E-2,"","","",null,null,null,"00:00:00",null,"",""]
[null,"Task 7",null,0,"","","",null,null,null,"00:00:00",null,"",""]
[]
[null,null,null,null,null,null,null,null,"Total daily exposure time (hh:mm)",null,null,null,"Daily exposure, LEP,d\n (dB(A)) ","Total daily\nexposure points "]
[]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(EAV_TimeInputArea)=0,\"\",IF(SUM(K10:K16)>=1,\"≥ 24 hrs\",SUM(K10:K16)))","v":""},null,null,null,{"$f":"IF(COUNT(EAV_LAeq)=0,\"\",dbsum(M10:M16)+0.000001)","v":""},{"$f":"IF(COUNT(N10:N16)=0,\"\",SUM(N10:N16))","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,3,null,{"$f":"IF(OR(DailyExposure=\"\",$N$20=\"\"),\"\",VLOOKUP(DailyExposure,NoHPTextLookup,$K22))","v":""}]
[null,null,null,null,null,null,null,null,null,null,4,null,{"$f":"IF(OR(DailyExposure=\"\",$N$20=\"\"),\"\",VLOOKUP(DailyExposure,NoHPTextLookup,$K23))","v":""}]
[null,null,null,null,null,null,null,null,null,null,5,null,{"$f":"IF(OR(DailyExposure=\"\",$N$20=\"\"),\"\",VLOOKUP(DailyExposure,NoHPTextLookup,$K24))","v":""}]
[null,"Footnotes:",null,null,null,null,null,null,null,null,6,null,{"$f":"IF(OR(DailyExposure=\"\",$N$20=\"\"),\"\",VLOOKUP(DailyExposure,NoHPTextLookup,$K25))","v":""}]

{"sheet":"ExposureLimitValue","index":2,"n_rows":26,"n_cols":25,"rows_kept":26,"cut":false,"hidden":false,"merged":[[8,13,9,13],[8,14,9,14],[8,5,9,5],[6,9,6,12],[6,6,6,8],[3,2,3,12],[8,1,9,1],[8,2,9,2],[8,4,9,4],[8,6,9,6],[6,1,6,2],[19,4,20,4],[21,4,25,4],[19,5,20,5],[21,5,25,5],[19,6,20,6],[21,6,25,6],[8,19,9,19],[25,11,25,12],[8,8,8,9],[18,8,19,9],[20,8,20,9],[22,11,22,12],[23,11,23,12],[24,11,24,12],[8,11,9,11],[8,12,9,12],[18,11,19,11],[18,12,19,12],[8,17,9,17],[8,16,9,16],[8,18,9,18],[8,15,9,15]]}
[]
[null,null,"Daily Noise Exposure Limit Value Calculator",null,null,null,null,null,null,null,null,null,{"$f":"VersionNumber","v":"V4-12 March 2021"},null,null,null,null,null,null,null,null,null,null,"LockTaskNames: ",false]
[]
[null,null,"The Control of Noise at Work Regulations 2005 defines an Exposure Limit Value (ELV) of 87 dB(A). \nThis calculator estimates the protected daily noise exposures of workers (i.e. it accounts for the use of hearing protection) for comparison with the ELV."]
[]
[]
[null,"Hearing protector information:",null,null,"SNR value (dB):",null,"Model name (optional): "]
[]
[null,"Task1\nname / description","Noise level1\nLAeq (dB(A))",null,"Noise level2\n LCeq (dB(C))","HP worn? \n(Yes/No)","Protected level dB(A)",null,"Daily exposure time1 ",null,null,"Personal noise exposure per task (dB(A))","Personal exposure points per task","LC missing","HPCalc OK","Partial OK","Over protection","Under protection","Under/over protection","Exposure time (hh:mm)"]
[null,null,null,null,null,null,null,null,"(hours)","(mins)"]
[null,"Task 1",null,null,null,null,{"$f":"IF(O11,E11-ELV_SNR+RealWorldCorr,\"\")","v":""},null,null,null,null,{"$f":"IF(P11,10*LOG10(10^((IF(O11,G11,C11))/10)*T11/Eighthours),\"\")","v":""},{"$f":"IF(P11,ROUND(10^((IF(O11,G11,C11))/10)*T11/(Eighthours*10^(RefLevel/10))*RefPoints,0),\"\")","v":""},{"$f":"IF(AND(F11=\"Yes\",E11=\"\"),TRUE,FALSE)","v":false},{"$f":"IF(AND(ISNUMBER(C11),ISNUMBER(E11),F11=\"Yes\"),IF(COUNT(ELV_SNR)=1,TRUE,FALSE),FALSE)","v":false},{"$f":"OR(AND(ISNUMBER(C11),T11>0,NOT(F11=\"Yes\")),AND(ISNUMBER(C11),T11>0,F11=\"Yes\",O11))","v":false},{"$f":"IF(AND(NOT(F11=\"\"),G11<OverProtection),TRUE,FALSE)","v":false},{"$f":"IF(OR(G11=\"\",G11<=UnderProtection),FALSE,TRUE)","v":false},{"$f":"OR(Q11:R11)","v":false},{"$f":"I11/24+J11/24/60","v":"00:00:00"}]
[null,"Task 2",null,null,null,null,"",null,null,null,null,"","",false,false,false,false,false,{"$f":"OR(Q12:R12)","v":false},"00:00:00"]
[null,"Task 3",null,0.22916666666666669,null,null,"",null,null,null,null,"","",false,false,false,false,false,false,"00:00:00"]
[null,"Task 4",null,2.0833333333333332E-2,null,null,"",null,null,null,null,"","",false,false,false,false,false,false,"00:00:00"]
[null,"Task 5",null,0.10416666666666666,null,null,"",null,null,null,null,"","",false,false,false,false,false,false,"00:00:00"]
[null,"Task 6",null,2.0833333333333332E-2,null,null,"",null,null,null,null,"","",false,false,false,false,false,false,"00:00:00"]
[null,"Task 7",null,0,null,null,"",null,null,null,null,"","",false,false,false,false,false,false,"00:00:00"]
[]
[null,null,null,null,{"$f":"IF(COUNTIF($N$11:$N$17,TRUE)>0,Lookups!D69,\"\")","v":""},{"$f":"IF(AND($F$7=\"\",COUNTIF($F$11:$F$17,\"Yes\")>0),Lookups!D70,\"\")","v":""},{"$f":"IF(S19,Lookups!D71,\"\")","v":""},null,"Total daily exposure time (hh:mm)",null,null,"Daily exposure, LEP,d\n (dB(A)) ","Total daily\nexposure points ",{"$f":"IF(COUNTIF(N11:N17,TRUE)>0,TRUE,FALSE)","v":false},false,false,false,false,false]
[null,null,null,null,{"$f":"IF(COUNTIF($N$11:$N$17,TRUE)>0,Lookups!E69,\"\")","v":""},{"$f":"IF(AND($F$7=\"\",COUNTIF($F$11:$F$17,\"Yes\")>0),Lookups!E70,\"\")","v":""},{"$f":"IF(S19,Lookups!E71,\"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(ELV_TimeInputArea)=0,\"\",IF(SUM(T11:T17)>=1,\"≥ 24 hrs\",SUM(T11:T17)))","v":""},null,null,{"$f":"IF(COUNT(M11:M17)=0,\"\",dbsum(L11:L17)+0.000001)","v":""},{"$f":"IF(COUNT(M11:M17)=0,\"\",SUM(M11:M17))","v":""}]
[null,null,null,null,{"$f":"IF(COUNTIF($N$11:$N$17,TRUE)>0,Lookups!F69,\"\")","v":""},{"$f":"IF(AND($F$7=\"\",COUNTIF($F$11:$F$17,\"Yes\")>0),Lookups!F70,\"\")","v":""},{"$f":"IF(S19,Lookups!F71,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(DailyNoiseExposureWithHP=\"\",$M$21=\"\"),\"\",VLOOKUP($L$21,WithHPtextLookup,$N23))","v":""},null,3]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(DailyNoiseExposureWithHP=\"\",$M$21=\"\"),\"\",VLOOKUP($L$21,WithHPtextLookup,$N24))","v":""},null,4]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(DailyNoiseExposureWithHP=\"\",$M$21=\"\"),\"\",VLOOKUP($L$21,WithHPtextLookup,$N25))","v":""},null,5]
[null,"Footnotes:",null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(DailyNoiseExposureWithHP=\"\",$M$21=\"\"),\"\",VLOOKUP($L$21,WithHPtextLookup,$N26))","v":""},null,6]

{"sheet":"WeeklyExposure","index":3,"n_rows":23,"n_cols":15,"rows_kept":23,"cut":false,"hidden":false,"merged":[[3,2,3,7],[5,1,5,3],[6,1,7,1],[8,2,8,3],[13,2,13,3],[6,2,7,3],[9,2,9,3],[10,2,10,3],[11,2,11,3],[12,2,12,3],[14,2,14,3],[22,4,22,7],[6,4,6,5],[16,4,16,7],[7,6,7,7],[6,6,6,7],[19,4,19,7],[20,4,20,7],[21,4,21,7]]}
[]
[null,null,"Weekly Noise Exposure Calculator",null,null,null,null,{"$f":"VersionNumber","v":"V4-12 March 2021"},null,null,null,null,"LockJobNames: ",false]
[]
[null,null,"The  Control of Noise at Work Regulations 2005 allows the use of weekly exposures in place of daily exposures where noise exposures vary markedly from day to day1. This calculator estimates weekly noise exposure from daily exposure values through the week."]
[null,null,null,null,null,null,null,null,null,null,null,null,"Comparison With EAV/ELV selector control: ",false,true]
[null,"This calculator can be used to compare weekly exposures with the Lower and Upper   \nExposure Action Values or the Exposure Limit Value. Please select the option that applies:  ",null,null,null,null,null,null,null,null,null,null,"CompareWith flag:",{"$f":"IF(N5,\"EAV\",\"ELV\")","v":"ELV"}]
[null,"Week Day","Job titles/descriptions",null,"Daily noise exposure",null,"Daily noise exposure"]
[null,null,null,null,null,null,{"$f":"IF($N$8,\"points\",\"dB(A)\")","v":"points"},null,null,null,null,null,"Input Unit option buttons: ",true,false]
[null,"Sunday","Job Sunday",null,null,{"$f":"IF($N$8,\"dB(A)\",\"points\")","v":"dB(A)"},{"$f":"IF(E9=\"\",\"\",IF($N$8,10^(E9/10)/(10^(RefLevel/10))*RefPoints,10*LOG10(E9/RefPoints)+RefLevel))","v":""},{"$f":"IF($N$8,\"points\",\"dB(A)\")","v":"points"},null,null,null,null,"Max input: ",{"$f":"IF(WeeklyExposureUnits,125,1000000)","v":125},{"$f":"IF($N$8=11,\"dB(A)\",\"points\")","v":"points"}]
[null,"Monday","Job Monday",null,null,{"$f":"IF($N$8,\"dB(A)\",\"points\")","v":"dB(A)"},"","points",null,null,null,null,"Weekly exposure dB(A)",{"$f":"IF(WeeklyExposureUnits,WeeklyExposure,G18)","v":""},"dB(A)"]
[null,"Tuesday","Job Tuesday",null,null,"dB(A)","","points"]
[null,"Wednesday","Job Wednesday",null,null,"dB(A)","","points",null,null,null,null,"Conditional formatting thresholds"]
[null,"Thursday","Job Thursday",null,null,"dB(A)","","points",null,null,null,null,0,"dB(A)"]
[null,"Friday","Job Friday",null,null,"dB(A)","","points",null,null,null,null,{"$f":"IF($N$5,LEAV,ELV)","v":87},"dB(A)"]
[null,"Saturday","Job Saturday",null,null,"dB(A)","","points",null,null,null,null,{"$f":"IF($N$5,UEAV,ELV)","v":87},"dB(A)"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($N$5,UEAV, ELV)","v":87},"dB(A)"]
[null,null,null,null,"Weekly noise exposure"]
[null,null,null,null,{"$f":"IF(COUNT(DailyExposures)=0,\"\",IF(WeeklyExposureUnits,10*LOG10(SUM(10^(DailyExposures/10))/5),SUM(DailyExposures)/5))","v":""},{"$f":"IF($N$8,\"dB(A)\",\"points\")","v":"dB(A)"},{"$f":"IF(E18=\"\",\"\",IF($N$8,10^(E18/10)/(10^(RefLevel/10))*RefPoints,10*LOG10(E18/RefPoints)+RefLevel))","v":""},{"$f":"IF($N$8,\"points\",\"dB(A)\")","v":"points"},null,null,null,"Look up rows"]
[]
[null,null,null,null,{"$f":"IF(WeeklyExposure=\"\",\"\",IF(WeeklyCompareWithFlag=\"EAV\",VLOOKUP($N$10,WeeklyTextEAVLookup,L20),VLOOKUP($N$10,WeeklyTextELVLookUp,L20)))","v":""},null,null,null,null,null,null,3]
[null,null,null,null,{"$f":"IF(WeeklyExposure=\"\",\"\",IF(WeeklyCompareWithFlag=\"EAV\",VLOOKUP($N$10,WeeklyTextEAVLookup,L21),VLOOKUP($N$10,WeeklyTextELVLookUp,L21)))","v":""},null,null,null,null,null,null,4]
[null,null,null,null,{"$f":"IF(WeeklyExposure=\"\",\"\",IF(WeeklyCompareWithFlag=\"EAV\",VLOOKUP($N$10,WeeklyTextEAVLookup,L22),VLOOKUP($N$10,WeeklyTextELVLookUp,L22)))","v":""},null,null,null,null,null,null,5]
[null,"Footnotes:",null,null,{"$f":"IF(WeeklyExposure=\"\",\"\",IF(WeeklyCompareWithFlag=\"EAV\",VLOOKUP($N$10,WeeklyTextEAVLookup,L23),VLOOKUP($N$10,WeeklyTextELVLookUp,L23)))","v":""},null,null,null,null,null,null,6]

{"sheet":"Instructions","index":4,"n_rows":143,"n_cols":13,"rows_kept":143,"cut":false,"hidden":false,"merged":[[47,1,47,7],[57,1,57,7],[65,1,65,5],[92,1,92,7],[58,5,58,6],[58,7,58,8],[93,3,93,4],[58,1,58,2],[58,3,58,4],[71,7,71,8],[73,7,73,8],[74,7,74,8],[93,7,93,8],[39,1,39,7],[41,1,41,7],[42,1,42,7],[45,1,45,7],[46,1,46,7],[43,1,43,7],[40,1,40,5],[44,1,44,5],[126,2,126,7],[128,2,128,7],[110,2,110,7],[97,4,97,7],[101,4,101,7],[105,1,105,7],[106,1,106,7],[104,1,104,7],[108,1,108,7],[109,1,109,7],[103,1,103,7]]}
[]
[null,null,null,null,null,"Noise Exposure Calculators - Instructions",null,{"$f":"VersionNumber","v":"V4-12 March 2021"},null,null,null,"Return to (sheet):","Main"]
[]
[]
[]
["Main Menu"]
[]
[null,"The main menu provides a starting point for the three"]
[null,"closely related calculators included on this spreadsheet:"]
[]
[null,null,"Noise Exposure Action Value Calculator"]
[null,null,"-","This calculator is applicable to any noise exposures."]
[]
[null,null,"Noise Exposure Limit Value Calculator"]
[null,null,"-","This calculator can be used if you are using hearing protection."]
[]
[null,null,"Weekly Noise Exposure Calculator"]
[null,null,"-","This calculator can be used if you are considering"]
[null,null,null,"weekly averaging of noise exposures."]
[]
[null,"Use the buttons across the top each sheet to access the three calculators and these instructions."]
[]
["General"]
[]
[null,"Data entry and calculated fields:"]
[null,null,"Colours are used to help identify the function of cells in the spreadsheets:"]
[null,null,null,null,"Grey denotes column headings"]
[null,null,null,null,"White denotes user-entry cells"]
[null,null,null,null,"Yellow is used for calculated cells"]
[null,null,null,null,"Dark red is the background colour. Instructions or other supplementary information may be shown in these cells"]
[null,null,"Colours are also used to provide information and warnings:"]
[null,null,null,null,"Dark red is used when exposures are such that there are no specific actions required"]
[null,null,null,null,"Orange cell colour is used for general information notes where exposures are above an action level"]
[null,null,null,null,"Light red is used to flag those tasks where hearing protection may be under- or over-protecting the worker or where data is missing"]
[null,null,null,null,"Red cell colour is used to warn where the noise exposure is at or above the exposure limit value"]
[null,null,null,null,"Green is used for information when the noise level is below either the lower action value or the exposure limit value"]
[]
[null,null,"T",null,"Yellow text is used to indicate that hovering the cursor over the cell will provide additional information "]
[]
[null,"The calculators work from left to right. Enter a value in a white cell and the yellow cells to the right that can be calculated will be automatically populated.The calculator collates data from top to bottom. Each row is a separate task, but data from combining the tasks is shown beneath the relevant column."]
[null,"Noise exposure (LEP,d)"]
[null,"Daily noise exposure should first be considered as the daily personal noise exposure for the unprotected ear. Use the Noise Exposure Action Value Calculator to help identify the actions you should take that relate to the Lower Exposure Action Value (LEAV) and the Upper Exposure Action Value (UEAV). "]
[null,"If hearing protection is used (e.g. as an interim measure before engineering controls are implemented, use the Noise Exposure Limit Value Calculator to help you decide which hearing protection is neccessary to ensure that daily personal noise exposure at the ear is below the Exposure Limit Value (ELV). "]
[null,"Where noise exposures vary markedly from day to day, use the Weekly Noise Exposure Calculator to average exposures over a working week. Weekly averaging is only likely to be appropriate where daily personal noise exposure on one or two working days is at least 5 dB higher than other days, or the working week comprises three or fewer days of noise exposure. "]
[null,"Exposure points"]
[null,"Daily noise exposure is presented as both dB(A) values and exposure points. "]
[null,"Exposure points are calculated relative to a reference value. The HSE system uses the Upper Exposure Action Value (85 dB(A)) as a reference such that an exposure of 85 dB(A) for 8 hours a day gives 100 points. "]
[null,"Exposure points values are useful because they may be added together arithmetically, for this reason values such as \"points per hour\" may provide a quick way to estimate exposures. "]
[]
[null,"\"Zoom to fit\" function"]
[null,null,"The Zoom to fit function resizes the calculator view, such that the visible size is optimised for the largest calculator (the Noise Exposure Limit Value Calculator)."]
[]
[null,"\"Return to calculator\" function"]
[null,null,"The return to calculator function (on this page) returns to the last used calculator sheet."]
[]
["Daily Noise Exposure Action Value Calculator"]
[]
[null,"The DailyNoise Exposure Action Value Calculator estimates daily personal noise exposures for comaprison with the Lower Exposure Action Value and the Upper Exposure Action Value (LEAV and UEAV) for daily exposure, as defined in the Control of Noise at Work Regulations 2005."]
[]
[null,"Values are entered for the noise levels (in dB(A)) associated"]
[null,"with the main work activities; the calculator then shows:"]
[null,null,"-","Points per hour for each activity"]
[null,null,"-","Exposure time (for each activity on its own) to"]
[null,null,null,"reach the LEAV and UEAV."]
[]
[null,"Values can then be entered for the actual personal daily exposure\ntimes for each activity (in hours and minutes);\nthe calculator then shows:"]
[null,null,"-","The personal noise exposures per task and the "]
[null,null,null,"equivalent value expressed as personal exposure points"]
[null,null,null,"per task."]
[null,"At the bottom of the table the personal exposure points per task"]
[null,"are added together, to give:"]
[null,null,"-","Total exposure time (in hh:mm)"]
[null,null,null,"(Note - this value can be used to check that the calculator accounts for the full daily exposure time)"]
[null,null,"-","Daily noise exposure (in dB(A))"]
[null,null,"-","Daily noise exposure (in exposure points)"]
[]
[null,"An information box is shown below the table, indicating how the calculated daily noise exposure"]
[null,"relates to the lower and upper exposure action values (LEAV and UEAV)."]
[]
[null,"\"Reset\" function:"]
[null,null,"-","Clears all user-entered data in the current calculator page"]
[null,null,null,"ie, \"Noise level dB(A)\" and \"Exposure time\" columns"]
[null,null,"-","If the \"Lock task names\" option is not selected the  task names are reset to \"Task 1\", \"Task 2\" ..."]
[null,null,"-","If the \"Lock task names\" option is selected the task names are not changed"]
[]
[null,"\"Copy values from Noise ELV Calculator\" button:"]
[null,null,"-","If there are data values in the ELV calculator that you want to use in this EAV calculator, this button will copy"]
[null,null,null,"all A-weighted noise levels and all exposure time values."]
[null,null,"-","Any existing data in the current calculator will be lost."]
[]
["Daily Noise Exposure Limit Value Calculator"]
[]
[null,"The DailyNoise Exposure Limit Value Calculator estimates daily personal noise exposures for comparison with the Exposure Limit Value (ELV) for daily exposure, as defined in the Control of Noise at Work Regulations 2005."]
[]
[null,"Values are required for the A and C-weighted noise levels"]
[null,"in dB(A) and dB(C) respectively."]
[]
[null,"NOTE 1:",null,null,"The C-weighted level should not be confused with the \nPeak C  levels which are usually substantially higher  \n(i.e. 20 dB or more higher) than the A-weighted level."]
[]
[null,"Select \"Yes\" or \"No\" in the \"HP worn?\" column."]
[]
[null,"NOTE 2:",null,null,"In accordance with HSE guidance, this calculator adds   \n4 dB to the level calculated at the ear to give a realistic\nProtected level estimate of ‘real world’ wearing of\nhearing protection."]
[null,"Under- or over-protection warning:"]
[null,"The calculator provides a warning if the model of hearing protection does not achieve noise at the ear between 70 and 80 dB(A) as recommended by HSE, i.e. the hearing protection is either over- or under-protecting. "]
[null,"The warnings draw your attention to, for example:  \n    - the risk of hearing damage for individual workers who have particular risk of hearing damage and  \n    - the risks to safety if hearing protection makes warnings, communication or traffic difficult to hear. "]
[null,"In the example shown here, the job involves exposure to noise levels of 80, 86 and 95 dB(A). The daily personal noise exposure for the job is 87 dB(A) (from the noise exposure action value calculator), i.e. exposure is above the UEAV and hearing protection must be provided and its use managed. "]
[null,"Wearing hearing protection with an SNR of 19 dB during “Clear up” and “Set up” and not at all during “Main activity” results in a personal noise exposure at the protected ear equivalent to a daily personal noise exposure of 79 dB(A). The calculator warns of under-protection during “Clear up” but a higher attenuation model, e.g. SNR more than 23dB, would result in a warning of over-protection during “Set up”. "]
[null,"Use of more than one protector type:"]
[null,"In some situtions hearing protectors with different attenuation values may be needed for different parts of the work activity. e.g. a high attenuation protector for a particularly noisy short-duration task, but a low attenuation protector is sufficient for the main work activity  (with the added benefits of being more comfortable and being less likely to prevent audible warnings, mobile machinery and speech being heard)."]
[null,"The Exposure Limit Value Calculator only allows an SNR value for one type of hearing protection to be entered, so cannot be used directly where more than one type of protector has to be used by a worker. However the calculator can be used in two stages: "]
[null,null,"1. Use the calculator to determine the protected noise level for each task \n2. Enter the protected noise level for each task in the \"Noise level LAeq\" column and leave the \"Noise Level LCeq\" and \"HP worn?\" columns blank (or set HP Worn? to \"No\")."]
[null,"\"Reset\" function:"]
[null,null,"-","Clears all user-entered data in the current calculator page, i.e. SNR values and contents of the \"Noise level (dB(A))\", "]
[null,null,null," \"Noise level (dB(C))\", \"HP worn?\" and exposure time columns."]
[]
[null,"\"Copy values from Noise EAV Calculator\" button:"]
[null,null,"-","If  you want to use the data values in from the EAV calculator in this ELV calculator, this button will copy"]
[null,null,null,"all A-weighted noise levels and all exposure time values."]
[null,null,"-","Any existing data in the current calculator will be lost."]
[]
["Weekly Noise Exposure Calculator"]
[]
[null,"The Weekly Noise Exposure Calculator determines the weekly noise exposures"]
[null,"entering either:"]
[null,null,"Daily personal noise exposures of the worker"]
[null,null,null,"(Select: \"Comparison with LEAV & UEAV\", or"]
[null,null,"Daily noise exposures at the ear of workers wearing\nhearing protection "]
[null,null,null,"(Select: \"Comparison with ELV\") "]
[null,null,"The calculations in both cases are the same, but\nthe type of value entered affects whether the resultant \n weekly exposure is compared with either the EAVs or the ELV.\n "]
[]
[null,null,"-","Daily noise exposure values are entered by the user for each "]
[null,null,null,"working day of the working week."]
[null,null,"-","Daily exposure may be entered as either points values or"]
[null,null,null,"in dB(A) (set the units option in the table heading)"]
[null,null,null,"NOTE: When the units option is changed, any values"]
[null,null,null,"already entered will be converted to the new unit."]
[null,null,"-","The calculator shows the daily noise exposures in both dB(A) and points."]
[null,null,"-","The calculator shows the weekly noise exposure in dB(A) and points below the table."]
[null,null,"-","Warnings are shown a the bottom of the page depenednt on levels and whether the values are being compared to the EAVs or the ELV. "]
[]
[null,"\"Reset\" function:"]
[null,null,"-","Clears all user daily exposure entries in the visible calculator."]
[null,null,"-","If the \"lock job names\" option is not selected the job names are reset to \"Job Sunday\", \"Job Monday\", etc. . "]

{"sheet":"Lookups","index":5,"n_rows":94,"n_cols":8,"rows_kept":94,"cut":false,"hidden":true,"merged":[[3,3,3,5],[22,3,22,4],[23,3,23,4],[17,3,17,4],[18,3,18,4],[19,3,19,4],[20,3,20,4],[21,3,21,4]]}
[]
[null,"Demo data"]
[]
[null,null,null,"Model"]
[null,null,null,"HearProtect_ABC"]
[null,null,null,"H","M","L","SNR"]
[null,null,null,20,17,14,19]
[]
[null,null,"Activity","LA","hh","mm","LC","Worn?"]
[null,null,"Main Activity",80,5,null,82,"No"]
[null,null,"Set Up ",86,2,null,87,"Yes"]
[null,null,"Clear Up",95,null,45,98,"Yes"]
[]
[]
[]
[]
[]
[null,null,"Sun","Sunday tank cleaning",null,87]
[null,null,"Mon","Tank re-fit",null,88]
[null,null,"Tue","General maintenance",null,79]
[null,null,"Wed","General maintenance",null,79]
[null,null,"Thu","General maintenance",null,79]
[null,null,"Fri","Not a working day"]
[null,null,"Sat","Not a working day"]
[]
[]
[null,"Constants"]
[null,"LEAV",80,"(32 points)","LEAVpoints",{"$f":"10^(LEAV/10)/10^(UEAV/10)*RefPoints","v":31.622776601683778}]
[null,"UEAV",85,"(100 points)","UEAVpoints",100]
[null,"ELV",87,"(158 points)","ELVpoints",{"$f":"10^(ELV/10)/10^(UEAV/10)*RefPoints","v":158.48931924611105}]
[null,"OverProtection",70,"dB"]
[null,"UnderProtection",80,"dB"]
[null,"RefLevel",85,"dB"]
[null,"RefPoints",100,"points"]
[null,"RefTime","08:00:00","hh:mm:ss"]
[null,"RealWorldCorr",4,"dB"]
[]
[null,"Info text (hearing protection not accounted for)"]
[null,"Threshold Level",null,"Text line 1","Text line 2","Text line 3","Text line 4"]
[null,0,"dB(A)","Information: Below LEAV","Look for oportunities to further","eliminate or minimise the risks from noise"," "]
[null,{"$f":"LEAV","v":80},"dB(A)","Warning: At or above LEAV","Control measures required","Hearing protection must be availlable"," "]
[null,{"$f":"UEAV","v":85},"dB(A)","WARNING: At or above UEAV","Programme of control measures required","Hearing protection must be used","(check suitability with ELV calculator)"]
[null,87,"dB(A)",{"$f":"D42","v":"WARNING: At or above UEAV"},{"$f":"E42","v":"Programme of control measures required"},{"$f":"F42","v":"Hearing protection must be used"},{"$f":"G42","v":"(check suitability with ELV calculator)"}]
[]
[null,"Info text (hearing protection accounted for)"]
[null,"Threshold Level",null,"Text line 1","Text line 2","Text line 3","Text line 3"]
[null,0,"dB(A)","Information: Noise at the ear below ELV","Use EAV calculator to estimate exposures","to compare with the LEAV and UEAV"," "]
[null,80,"dB(A)",{"$f":"D47","v":"Information: Noise at the ear below ELV"},"Use EAV calculator to estimate exposures","to compare with the LEAV and UEAV"," "]
[null,85,"dB(A)","Information: Noise at the ear below ELV","Use EAV calculator to estimate exposures","to compare with the LEAV and UEAV"," "]
[null,87,"dB(A)","WARNING: ELV exceeded","Immediate action required","to prevent continued exposure","above the ELV"]
[]
[]
[null,"Info text (Weekly Exposure re EAVs))"]
[null,"Threshold Level",null,"Text line 1","Text line 2",null,"Text line 3"]
[null,0,"dB(A)","Information: Weekly exposure below LEAV","Look for oportunities to further","eliminate or minimise the risks from noise"," "]
[null,80,"dB(A)","Warning: Weekly exposure at or above LEAV","Control measures required.","Hearing protection must be availlable","(check suitability with ELV calculator)"]
[null,85,"dB(A)","WARNING: Weekly exposure at or above UEAV","Programme of control measures is required.","Hearing protection must be used","(check suitability with ELV calculator)"]
[null,87,"dB(A)",{"$f":"D57","v":"WARNING: Weekly exposure at or above UEAV"},{"$f":"E57","v":"Programme of control measures is required."},{"$f":"F57","v":"Hearing protection must be used"},{"$f":"G57","v":"(check suitability with ELV calculator)"}]
[]
[null,"Info text (Weekly Exposure re ELV)"]
[null,"Threshold Level",null,"Text line 1","Text line 2",null,"Text line 3"]
[null,0,"dB(A)","Information: Weekly exposure below ELV","Look for oportunities to further","eliminate or minimise the risks from noise"," "]
[null,80,"dB(A)",{"$f":"D62","v":"Information: Weekly exposure below ELV"},"Look for oportunities to further","eliminate or minimise the risks from noise"," "]
[null,85,"dB(A)","Information: Weekly exposure below ELV","Look for oportunities to further","eliminate or minimise the risks from noise"," "]
[null,87,"dB(A)","WARNING: Weekly exposure exceeds ELV","Immediate action required","to prevent continued exposure above the ELV","Check the suitability of hearing protection with ELV calculator"]
[]
[null,"ELV warnings"]
[null,null,null,"Text line 1","Text line 2","Text line 3","Text line 3"]
[null,null,"No LC value","Error","Value(s) required in highighted cell(s)","The C-weighted noise level is required to estimate hearing protection performance"]
[null,null,"No SNR value","Error","SNR value required","The SNR value is required to estimate  hearing protection performance"]
[null,null,"Under/over protection","Warning","Possible under or over-protection","Aim at a protected level between 70 and 80 dB(A) for the highlighted task(s)"]
[]
[]
[null,null,null,"Test (without HP)"]
[null,null,null,87]
[null,null,3,{"$f":"VLOOKUP(D$75,NoHPTextLookup,C76)","v":"WARNING: At or above UEAV"}]
[null,null,4,{"$f":"VLOOKUP(D$75,NoHPTextLookup,C77)","v":"Programme of control measures required"}]
[null,null,5,{"$f":"VLOOKUP(D$75,NoHPTextLookup,C78)","v":"Hearing protection must be used"}]
[null,null,6,{"$f":"VLOOKUP(D$75,NoHPTextLookup,C79)","v":"(check suitability with ELV calculator)"}]
[]
[null,null,null,"Test (with HP)"]
[null,null,null,77]
[null,null,3,{"$f":"VLOOKUP(D$82,WithHPtextLookup,C83)","v":"Information: Noise at the ear below ELV"}]
[null,null,4,{"$f":"VLOOKUP(D$82,WithHPtextLookup,C84)","v":"Use EAV calculator to estimate exposures"}]
[null,null,5,{"$f":"VLOOKUP(D$82,WithHPtextLookup,C85)","v":"to compare with the LEAV and UEAV"}]
[null,null,6,{"$f":"VLOOKUP(D$82,WithHPtextLookup,C86)","v":" "}]
[]
[]
[null,null,null,"Test (Weekly)"]
[null,null,null,30]
[null,null,3,{"$f":"VLOOKUP(D$90,WeeklyTextEAVLookup,C91)","v":"Information: Weekly exposure below LEAV"}]
[null,null,4,{"$f":"VLOOKUP(D$90,WeeklyTextEAVLookup,C92)","v":"Look for oportunities to further"}]
[null,null,5,{"$f":"VLOOKUP(D$90,WeeklyTextEAVLookup,C93)","v":"eliminate or minimise the risks from noise"}]
[null,null,6,{"$f":"VLOOKUP(D$90,WeeklyTextEAVLookup,C94)","v":" "}]