{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["HAV calculator","HELP"],"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":20,"n_cols":18,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"HAND-ARM VIBRATION EXPOSURE CALCULATOR",null,null,null,null,null,null,null,null,null,null,null,null,"     Version 3  June 2005"]
[]
[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,"magnitude",null,"points",null,"2.5 m/s2 A(8)",null,"time in min","5 m/s2 A(8)",null,"time in min","duration",null,"time in mins","exposure","partial exp","exposure"]
[null,null,"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,"Tool or process 1",null,null,{"$f":"IF(C7<=0,\" \",(2*C7*C7))","v":" "},null,{"$f":"IF(C7<=0,\" \",IF(I7>=24,\">24\",TRUNC(I7)))","v":" "},{"$f":"IF(C7<=0,\" \",IF(I7>=24,\"\",(I7-G7)*60))","v":" "},{"$f":"IF(C7<=0,\" \",(8*2.5*2.5/(C7*C7)))","v":" "},{"$f":"IF(C7<=0,\" \",IF(L7>=24,\">24\",TRUNC(L7)))","v":" "},{"$f":"IF(C7<=0,\" \",IF(L7>=24,\"\",(L7-J7)*60))","v":" "},{"$f":"IF(C7<=0,\"\",(8*5*5/(C7*C7)))","v":""},null,null,{"$f":"(M7*60)+N7","v":0},{"$f":"IF(OR(C7<=0,O7<=0, O7>1440),\" \",(C7*(O7^0.5)/21.9))","v":" "},null,{"$f":"IF(P7=\" \",\" \",(P7^2)*100/6.25)","v":" "}]
[null,"Tool or process 2",null,null," ",null," "," "," "," "," ","",null,null,0," ",null," "]
[null,"Tool or process 3",null,null," ",null," "," "," "," "," ","",null,null,0," ",null," "]
[null,"Tool or process 4",null,null," ",null," "," "," "," "," ","",null,null,0," ",null," "]
[null,"Tool or process 5",null,null," ",null," "," "," "," "," ","",null,null,0," ",null," "]
[null,"Tool or process 6",null,null," ",null," "," "," "," "," ","",null,null,0," ",null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O7:O12)","v":0}]
[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,"exposure",null,"exposure"]
[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,"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(P7:P12))=0,O13>1440),\" \",SQRT(SUMSQ(P7:P12)))","v":" "},null,{"$f":"IF(OR(SUM(R7:R12)<=0,P17 = \" \"),\" \",SUM(R7:R12))","v":" "}]
[null,"The results are displayed in the yelllow areas."]
[null,"To clear all cells, click on the 'Reset' button."]
[null,"For more information, click the HELP tab below."]

{"sheet":"HELP","index":1,"n_rows":45,"n_cols":7,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[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 or 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 yellow areas.  (Yellow 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,"(The Exposure points per hour, Time to reach EAV and the Time to reach ELV are calculated from the Vibration magnitude for each Tool or process.)"]
[]
[null,"The Partial exposure is the vibration exposure, expressed in m/s2 A(8) and in exposure points, for each Tool or 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."]