{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["DUET_v1.3.0","DUET_v1.3.0_Database","Instructions","Scale"],"not_rendered":{"charts":0,"images":13,"macros":1,"external_links":0,"defined_names":7,"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":"DUET_v1.3.0","index":0,"n_rows":41,"n_cols":31,"rows_kept":41,"cut":false,"hidden":false,"merged":[[33,1,33,5],[34,1,34,5],[1,1,1,9],[40,1,40,9],[38,1,38,9],[39,1,39,9]]}
["DUET 1.3.0",10,null,null,null,null,null,null,null,null,"Instructions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hidded Data"]
[null,"The Distal Upper Extremity Tool (DUET)"]
[null,"Task #",null,"OMNI-RES Scale",null,"Repetitions\n(per work day)",null,"Damage\n(cumulative)",null,"% Damage Contribution"]
[]
[null,1,null,null,null,null,null,{"$f":"IF(OR(D5=\"Please select ...\", D5=\"\"),\"\",IF(F5=\"\",\"\",VLOOKUP(D5,ScaleLookup,2,FALSE)*F5))","v":""},null,{"$f":"IF(OR(H5=\"\",$H$34=\"\"),\"\",H5/$H$34)","v":""}]
[]
[]
[null,2,null,null,null,null,null,{"$f":"IF(OR(D8=\"Please select ...\", D8=\"\"),\"\",IF(F8=\"\",\"\",VLOOKUP(D8,ScaleLookup,2,FALSE)*F8))","v":""},null,{"$f":"IF(OR(H8=\"\",$H$34=\"\"),\"\",H8/$H$34)","v":""}]
[]
[]
[null,3,null,null,null,null,null,{"$f":"IF(OR(D11=\"Please select ...\",D11=\"\"),\"\",IF(F11=\"\",\"\",VLOOKUP(D11,ScaleLookup,2,FALSE)*F11))","v":""},null,{"$f":"IF(OR(H11=\"\",$H$34=\"\"),\"\",H11/$H$34)","v":""}]
[]
[]
[null,4,null,null,null,null,null,{"$f":"IF(OR(D14=\"Please select ...\", D14=\"\"),\"\",IF(F14=\"\",\"\",VLOOKUP(D14,ScaleLookup,2,FALSE)*F14))","v":""},null,{"$f":"IF(OR(H14=\"\",$H$34=\"\"),\"\",H14/$H$34)","v":""}]
[]
[]
[null,5,null,null,null,null,null,{"$f":"IF(OR(D17=\"Please select ...\", D17=\"\"),\"\",IF(F17=\"\",\"\",VLOOKUP(D17,ScaleLookup,2,FALSE)*F17))","v":""},null,{"$f":"IF(OR(H17=\"\",$H$34=\"\"),\"\",H17/$H$34)","v":""}]
[]
[]
[null,6,null,null,null,null,null,{"$f":"IF(OR(D20=\"Please select ...\", D20=\"\"),\"\",IF(F20=\"\",\"\",VLOOKUP(D20,ScaleLookup,2,FALSE)*F20))","v":""},null,{"$f":"IF(OR(H20=\"\",$H$34=\"\"),\"\",H20/$H$34)","v":""}]
[]
[]
[null,7,null,null,null,null,null,{"$f":"IF(OR(D23=\"Please select ...\", D23=\"\"),\"\",IF(F23=\"\",\"\",VLOOKUP(D23,ScaleLookup,2,FALSE)*F23))","v":""},null,{"$f":"IF(OR(H23=\"\",$H$34=\"\"),\"\",H23/$H$34)","v":""}]
[]
[]
[null,8,null,null,null,null,null,{"$f":"IF(OR(D26=\"Please select ...\", D26=\"\"),\"\",IF(F26=\"\",\"\",VLOOKUP(D26,ScaleLookup,2,FALSE)*F26))","v":""},null,{"$f":"IF(OR(H26=\"\",$H$34=\"\"),\"\",H26/$H$34)","v":""}]
[]
[]
[null,9,null,null,null,null,null,{"$f":"IF(OR(D29=\"Please select ...\", D29=\"\"),\"\",IF(F29=\"\",\"\",VLOOKUP(D29,ScaleLookup,2,FALSE)*F29))","v":""},null,{"$f":"IF(OR(H29=\"\",$H$34=\"\"),\"\",H29/$H$34)","v":""}]
[]
[]
[null,10,null,null,null,null,null,{"$f":"IF(OR(D32=\"Please select ...\",D32=\"\"),\"\",IF(F32=\"\",\"\",VLOOKUP(D32,ScaleLookup,2,FALSE)*F32))","v":""},null,{"$f":"IF(OR(H32=\"\",$H$34=\"\"),\"\",H32/$H$34)","v":""}]
[]
[null,"Total Cumulative Damage:",null,null,null,null,null,{"$f":"SUM(H5:H33)","v":0}]
[null,"Probability of Distal Upper Extremity Outcome (%):",null,null,null,null,null,{"$f":"RiskValue","v":""}]
[]
[]
[]
[null,"Lastest Version: duet.pythonanywhere.com/"]
[null,"Excel Version Developers: Rong Huangfu, Iván Nail, Dania Bani Hani, Nicholas Smith, and Tenchi Smith"]
[null," 2016 - 2019 © Sean Gallagher, Richard Sesek, Mark Schall and Rong Huangfu"]

{"sheet":"DUET_v1.3.0_Database","index":1,"n_rows":1,"n_cols":12,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["No.","Date Created","Job ID","WorkerID","Task #","Task Name","OMNI-RES \nScale","Repetitions\n(per workday)","Cumulative \nDamage","% Damage Contribution","Probability of \nDUE Outcome (%):","Comments"]

{"sheet":"Instructions","index":2,"n_rows":62,"n_cols":8,"rows_kept":62,"cut":false,"hidden":false,"merged":[[31,1,31,9],[37,1,37,9],[39,1,39,9],[40,1,40,9],[12,1,12,9],[17,7,17,8],[24,2,24,8],[28,1,28,9],[30,1,30,9],[18,2,18,6],[19,2,19,6],[20,2,20,6],[21,2,21,6],[22,2,22,6],[18,7,18,8],[19,7,19,8],[61,1,61,9],[42,1,42,9],[48,1,48,9],[50,1,50,9],[51,1,51,9],[53,1,53,9],[59,1,59,9],[3,2,3,8],[1,2,1,8],[1,9,6,9],[4,2,4,8],[8,1,8,9],[20,7,20,8],[21,7,21,8],[22,7,22,8],[13,2,13,8],[15,1,15,9],[17,2,17,6]]}
[]
[null,null,"Guidance on the Use of the Distal Upper Extremity Tool (DUET)"]
[]
[null,null,"Version 1.3.0 - Last updated 04/19/2018"]
[null,null,"For the most up to date version, please go to: duet.pythonanywhere.com"]
[]
[null,null,null,"|",null,"|",null,"|"]
[]
[null,"The DUET risk assessment tool is an easy to use method of evaluating the risk associated with upper extremity tasks. It is based on fatigue failure theory, which is the theory that assesses the cumulative damage of materials subjected to repeated stress. There is substantial evidence that upper extremity disorders (and other musculoskeletal disorders) are the result of an accumulation of damage in musculoskeletal tissues due to repetitive stress (Gallagher and Schall, Jr., 2017). The DUET tool has been validated against a cross-sectional epidemiological database in which the DUET cumulative damage measure showed strong associations with upper extremity outcomes (Gallagher et al., 2017). "]
[]
[null,"Using DUET"]
[]
[null," The purpose of the DUET tool is to determine the cumulative upper extremity load experienced during a workday. Based on DUET’s cumulative damage measure, a probability of an upper extremity outcome (specifically a first time office visit due to upper extremity symptoms) is calculated (Gallagher et al., 2017).\n\nAll that is needed to use the DUET tool are two pieces of information on each upper extremity task: 1) a rating of the intensity of the exertion for the task; 2) the number of repetitions of the task during the workday. The rating of exertion intensity can be obtained in different manners. One method is to obtain a subjective rating of exertion by the individual performing the task. Using this method the worker should be shown a copy of the OMNI-RES scale, and instructed as follows (modified from Robertson et al., 2003): "]
[null,null,"“Please give your subjective intensity of effort, strain, discomfort, and/or fatigue that you feel during performance of this task guided by the descriptors on the 10-point scale provided.” "]
[]
[null,"Observers can also evaluate the intensity of exertion using the descriptors provided by authors of the Strain Index (Moore and Garg, 1995). While a professional ergonomist should always use their best judgement when performing the rating, we generally recommend the following relationship: "]
[]
[null,null,"Observation",null,null,null,null,"OMNI-RES Score"]
[null,null,"Barely Noticeable or Relaxed Effort",null,null,null,null,1]
[null,null,"Noticeable or definite effort",null,null,null,null,3]
[null,null,"Obvious effort, unchanged expression",null,null,null,null,5]
[null,null,"Substantial effort, changed expression",null,null,null,null,7]
[null,null,"Uses shoulder or trunk for force",null,null,null,null,9]
[]
[]
[]
[null,"Assessing Mono-Task Jobs"]
[]
[null,"The simplest example of applying DUET to analyze upper extremity task demands is that of a mono-task job (i.e., a job involving the same upper extremity task all-day long). In this example, the job involves an upper extremity task with an exertion intensity rating of “Somewhat Easy” (4 on OMNI-RES scale), which is performed 1350 times during the workday. Figure 1 below shows a screenshot of the DUET tool for this mono-task job, which demonstrates that this job has approximately a 32.1% probability of experiencing distal upper extremity symptoms. "]
[]
[]
[null,"Figure 1. A screenshot of the DUET tool for analyzing a mono-task job"]
[]
[]
[]
[null,"Assessing Jobs with Multiple Exertions"]
[]
[null,"For jobs involving multiple exertions during the workday, each individual task should be analyzed using the methods shown above. The cumulative damage associated with each task will be summed by the DUET tool to determine the daily dose of cumulative upper extremity damage. An example is provided in Figure 2 below. "]
[]
[]
[null,"Figure 2. A screenshot of the DUET tool for analyzing a multi-task job"]
[]
[null,"The example above shows that the combination of these three tasks leads to a combined probability of 48.2% for distal upper extremity symptoms. Further, note that task #3 accounts for approximately 92.5% of the total damage for the workday. This task would be a prime candidate for redesign. For example, if task #3 exertion level were reduced to “Somewhat Easy”, the probability that the overall job is high risk would be reduced to 29.5%. "]
[]
[]
[]
[null,"Assessing Highly Variable Tasks"]
[]
[null,"If a large number of highly variable upper extremity tasks is performed, a “binning” procedure can be used. In this procedure, upper extremity tasks with the same exertion level would be summed together and the cumulative damage score is developed using the number of repetitions within each “bin”. Once again, the cumulative damage associated with each exertion level will be summed to establish the cumulative daily load for this combination of tasks. An example is shown in Figure 3."]
[]
[]
[null,"Figure 3. A screenshot of the DUET tool for analyzing a job comprised of highly variable tasks"]
[]
[null,"While all of the “bins” individually result in low to moderate risk, the overall probability that these tasks would lead to distal upper extremity symptoms is greater than 60%. As can be seen from Figure 3 above, more than 90% of the total cumulative damage is due to the 230 exertions in the “Hard” and “Extremely Hard” categories. "]
[]
[]
[]
[null,"References"]
[]
[null,"Gallagher, S., Schall Jr., M.C. (2017) Musculoskeletal disorders as a fatigue failure process: evidence, implications and research needs, Ergonomics, 60: 255-269.\n\nGallagher, S. Schall, Jr., M.C., Sesek, R.F., Huangfu, R. (2017). Validation of A Fatigue Failure-based Risk Assessment Tool For Distal Upper Extremity MSDs. Proceedings of the Annual Meeting of the Human Factors and Ergonomics Society, Volume: 61 issue: 1, page(s): 911-913.\n\nMoore, J.S., Garg, A. (1995). The Strain Index: A proposed method to analyze jobs for risk of distal upper extremity disorders; Am. Ind. Hyg. Assoc. J. 56:443-458.\n\nRobertson, R. J., Goss, F. L., Rutkowski, J., Lenz, B., Dixon, C., Timmer, J., Frazee, K., Dube, J., Andreacci, J. Concurrent Validation of the OMNI Perceived Exertion Scale for Resistance Exercise. Med. Sci. Sports Exerc., Vol. 35, No. 2, pp. 333–341, 2003. "]
[]
[null," 2016 - 2019 © Sean Gallagher, Richard Sesek, Mark Schall and Rong Huangfu"]

{"sheet":"Scale","index":3,"n_rows":26,"n_cols":17,"rows_kept":26,"cut":false,"hidden":true,"merged":[]}
[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17]
[2,"Scale","Damage Per Cycle"]
[3,"0: Extremely Easy",2.6E-7]
[4,1,4.4999999999999998E-7]
[5,"2: Easy",1.37E-6]
[6,3,4.1300000000000003E-6]
[7,"4: Somewhat Easy",1.2619999999999999E-5]
[8,5,3.8009999999999997E-5]
[9,"6: Somewhat Hard",1.1625000000000001E-4]
[10,7,3.5013999999999998E-4]
[11,"8: Hard",1.0537400000000001E-3]
[12,9,3.22581E-3]
[13,"10: Extremely Hard",9.7087400000000004E-3]
[14]
[15,null,"Total","Task 1","Task 2","Task 3","Task 4","Task 5","Task 6","Task 7","Task 8","Task 9","Task 10"]
[16,"Damage:",{"$f":"'DUET_v1.3.0'!H34","v":0},{"$f":"'DUET_v1.3.0'!H5","v":""},{"$f":"'DUET_v1.3.0'!H8","v":""},{"$f":"'DUET_v1.3.0'!H11","v":""},{"$f":"'DUET_v1.3.0'!H14","v":""},{"$f":"'DUET_v1.3.0'!H17","v":""},{"$f":"'DUET_v1.3.0'!H20","v":""},{"$f":"'DUET_v1.3.0'!H23","v":""},{"$f":"'DUET_v1.3.0'!H26","v":""},{"$f":"'DUET_v1.3.0'!H29","v":""},{"$f":"'DUET_v1.3.0'!H32","v":""}]
[17,"y:",{"$f":"IF(C16=\"\",\"\",IF(C16<0.000005,\"\", 0.573+0.747*LOG10(C16)))","v":""},{"$f":"IF(D16=\"\",\"\",0.573+0.747*LOG10(D16))","v":""},"","","","","","","","",""]
[18,"Damage to Risk:",{"$f":"IF(C17=\"\",\"\",EXP(C17)/(1+EXP(C17)))","v":""},{"$f":"IF(D17=\"\",\"\",EXP(D17)/(1+EXP(D17)))","v":""},"","","","","","","","",""]
[19]
[20,"Empty Cell Reference C20 (EmptyCell)"]
[21]
[22]
[23]
[24]
[25]
[26]