{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["HAV calculator","Instructions"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":3,"comments":0,"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":"HAV calculator","index":0,"n_rows":25,"n_cols":19,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,null,"JOB: ",null,null,null,null,"HAND-ARM VIBRATION EXPOSURE CALCULATOR"]
[]
[null,null,null,"Vibration",null,"Exposure",null,"Time to Reach EAV",null,null,"Time to Reach ELV",null,null,"Exposure",null,null,"Partial",null,"Partial"]
[null,null,null,"Magnitude",null,"Points",null,"2.5 m/s2 A(8)",null,null,"5 m/s2 A(8)",null,null,"Duration",null,null,"Exposure",null,"Exposure"]
[null,null,"Tool / Process","m/s² r.m.s.",null,"per hour",null,"hours","minutes",null,"hours","minutes",null,"hours","minutes",null,"m/s² A(8)",null,"Points"]
[null,null,null,null,null,{"$f":"IF(D11<=0,\" \",(2*D11*D11))","v":" "},null,{"$f":"IF(D11<=0,\" \",IF(J11>=24,\">24\",TRUNC(J11)))","v":" "},{"$f":"IF(D11<=0,\" \",IF(J11>=24,\"\",(J11-H11)*60))","v":" "},{"$f":"IF(D11<=0,\" \",(8*2.5*2.5/(D11*D11)))","v":" "},{"$f":"IF(D11<=0,\" \",IF(M11>=24,\">24\",TRUNC(M11)))","v":" "},{"$f":"IF(D11<=0,\" \",IF(M11>=24,\"\",(M11-K11)*60))","v":" "},{"$f":"IF(D11<=0,\"\",(8*5*5/(D11*D11)))","v":""},null,null,{"$f":"(N11*60)+O11","v":0},{"$f":"IF(OR(D11<=0,P11<=0, P11>1440),\" \",(D11*(P11^0.5)/21.9))","v":" "},null,{"$f":"IF(Q11=\" \",\" \",(Q11^2)*100/6.25)","v":" "}]
[null,null,null,null,null," ",null," "," "," "," "," ","",null,null,0," ",null," "]
[null,null,null,null,null," ",null," "," "," "," "," ","",null,null,0," ",null," "]
[null,null,null,null,null," ",null," "," "," "," "," ","",null,null,0," ",null," "]
[null,null,null,null,null," ",null," "," "," "," "," ","",null,null,0," ",null," "]
[null,null,null,null,null," ",null," "," "," "," "," ","",null,null,0," ",null," "]
[]
[null,null,"Instructions for use:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Daily",null,"Total"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Exposure",null,"Exposure"]
[null,null,"Enter vibration magnitudes and exposure durations in the white areas. ",null,null,null,null,null,null,null,null,null,null,null,null,null,"m/s² A(8)",null,"Points"]
[null,null,"To calculate, press the Enter key, or move the cursor to a different cell.",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(SQRT(SUMSQ(Q11:Q16))=0,P17>1440),\" \",SQRT(SUMSQ(Q11:Q16)))","v":" "},null,{"$f":"IF(OR(SUM(S11:S16)<=0,Q21 = \" \"),\" \",SUM(S11:S16))","v":" "}]
[null,null,"The results are displayed in the light blue areas."]
[null,null,"To clear all cells, click on the 'Reset' button."]
[]
[null,null,null,null,null,null,null,null,"*Adapted from HSE Health & Safety Executive HAV Calculator"]

{"sheet":"Instructions","index":1,"n_rows":39,"n_cols":7,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"Source: HSE Health & Safety Executive"]
[]
[]
[null,null,null,null,null,null,"HAND-ARM VIBRATION EXPOSURE CALCULATOR"]
[null,null,null,null,null,null,"INSTRUCTIONS AND DEFINITIONS"]
[]
[null,"Instructions"]
[]
[null,"Insert your input values in the white areas, in one or more of the six Tool / Process rows."]
[null,"(More than one row is required where the individual is exposed to vibration from more than one tool or process within the same day.)"]
[null,"After entering the data, press the Enter key, or move the cursor to another cell."]
[null,"The outputs will appear in the light blue areas.  (Light blue cells will remain blank if valid input data have not been entered.)"]
[null,"To clear the calculator of all values, click on the Reset button.  (The Reset button will only work if macros are enabled in Excel.)"]
[]
[null,"Definitions: Inputs"]
[]
[null,"The Vibration Magnitude is the frequency-weighted r.m.s. acceleration value in m/s2 for each Tool or process."]
[null,"The Exposure Duration is the total daily vibration contact time or \"trigger time\" for each Tool or process."]
[null,"It may be expressed in any combinations of hours and/or minutes but must not exceed 24 hours."]
[]
[null,"Definitions: Outputs"]
[]
[null,"The Exposure Points Per Hour is the rate at which exposure will rise at the specificed Vibration Magnitude."]
[null,"The Exposure Points system is a simple alternative to the A(8) value for describing and managing exposures in the workplace. "]
[null,"The Exposure Action Value (EAV) is equivalent to 100 points and the Exposure Limit Value (ELV) is equivalent to 400 points.)"]
[null,"The Time to Reach EAV is the time required to reach the Exposure Action Value (EAV) of 2.5 m/s2 A(8)."]
[null,"The Time to Reach ELV is the time required to reach the Exposure Limit Value (ELV) of 5 m/s2 A(8)."]
[]
[null,"Note: The Exposure Points per hour, Time to Reach EAV and the Time to Reach ELV are calculated from the Vibration Magnitude for each Tool / Process."]
[]
[null,"The Partial exposure is the vibration exposure, expressed in m/s2 A(8) and in exposure points, for each Tool / Process.  "]
[null,"It is calculated from the Vibration Magnitude and the Exposure Duration."]
[]
[null,"The Total Exposure, also in m/s2 A(8) and in exposure points, is calculated from all the Partial Exposures."]
[]
[null,"Note:  A partial or total exposure will not be calculated if the corresponding exposure duration exceeds 24 hours."]