{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["TST_v1.0.0","TST_v1.0.0_database","Instructions","push_pull","Sheet1"],"not_rendered":{"charts":0,"images":20,"macros":1,"external_links":1,"defined_names":118,"comments":1,"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":"TST_v1.0.0","index":0,"n_rows":35,"n_cols":29,"rows_kept":35,"cut":false,"hidden":false,"merged":[[39,0,39,16],[33,3,33,13],[34,3,34,13],[1,0,1,16]]}
["The Shoulder Tool 1.0.0",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Instructions",null,null,null,null,null,null,null,null,null,"Please select ...","Unit:English",2]
["The Shoulder Tool",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Handling Load","Unit:Metric"]
[null,"Task #",null,"Type of Task",null,"Lever Arm\n(cm)",null,"Load\n(kg)",null,"Moment\n(N.m)",null,"Repetitions\n(/work day)",null,"Damage\n(cum.)",null,"% Total (damage)",{"$f":"IF(AC1=1,\"Unit:English\",\"Unit:Metric\")","v":"Unit:Metric"},"Arm Moment\n(N.m)",null,null,null,null,null,null,null,null,"Horizontal Push/Pull"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('TST_v1.0.0'!#REF!=\"Please select...\", 'TST_v1.0.0'!#REF!=\"\", 'TST_v1.0.0'!#REF!=\"\", 'TST_v1.0.0'!#REF!=\"\"), \"\", IF('TST_v1.0.0'!#REF!<1.715, 0, IF('TST_v1.0.0'!#REF!>=27, 121.9/12, (-8.27+4.8223*'TST_v1.0.0'!#REF!)/12)))","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,"Push/Pull Downward"]
[null,1,null,"Please select ...",null,null,null,null,null,{"$f":"IF(OR(D5=AA1,F5=\"\",H5=\"\",L5=\"\"),\"\",IF(D5=AA3,F5 * H5/100*9.8,IF(D5=AA2,F5 * H5/100 * 9.8+R5,F5 * H5/100 * 9.8-R5)))","v":""},null,null,null,{"$f":"IF(OR(D5=AA1,F5=\"\",H5=\"\",L5=\"\"),\"\",IF(H5=0,0,1/(10^((101.25-100*(J5*(100*0.3937*2.2046/9.8/12)*12/681))/14.83))*L5))","v":""},null,{"$f":"IF(OR(D5=AA1,F5=\"\",H5=\"\",L5=\"\"),\"\",IF($P$34 = 0,0,N5/$P$34))","v":""},null,{"$f":"IF(OR(D5=\"Please select...\", F5=\"\", H5=\"\", L5=\"\"), \"\", IF(F5<1.715, 0, IF(F5>=27, 121.9/12, (-8.27+4.8223*F5)/12)))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('TST_v1.0.0'!#REF!=\"Please select...\", 'TST_v1.0.0'!#REF!=\"\", 'TST_v1.0.0'!#REF!=\"\", 'TST_v1.0.0'!#REF!=\"\"), \"\", IF('TST_v1.0.0'!#REF!<1.715, 0, IF('TST_v1.0.0'!#REF!>=27, 121.9/12, (-8.27+4.8223*'TST_v1.0.0'!#REF!)/12)))","v":{"$error":"#REF!"}}]
[]
[null,2,null,"Please select ...",null,null,null,null,null,{"$f":"IF(OR(D8=AA1,F8=\"\",H8=\"\",L8=\"\"),\"\",IF(D8=AA3,F8 * H8/100*9.8,IF(D8=AA2,F8 * H8/100 * 9.8+R8,F8 * H8/100 * 9.8-R8)))","v":""},null,null,null,{"$f":"IF(OR(D8=AA1,F8=\"\",H8=\"\",L8=\"\"),\"\",IF(H8=0,0,1/(10^((101.25-100*(J8*(100*0.3937*2.2046/9.8/12)*12/681))/14.83))*L8))","v":""},null,{"$f":"IF(OR(D8=AA1,F8=\"\",H8=\"\",L8=\"\"),\"\",IF($P$34 = 0,0,N8/$P$34))","v":""},null,{"$f":"IF(OR(D8=\"Please select...\", F8=\"\", H8=\"\", L8=\"\"), \"\", IF(F8<1.715, 0, IF(F8>=27, 121.9/12, (-8.27+4.8223*F8)/12)))","v":""}]
[]
[]
[null,3,null,"Please select ...",null,null,null,null,null,{"$f":"IF(OR(D11=AA1,F11=\"\",H11=\"\",L11=\"\"),\"\",IF(D11=AA3,F11 * H11/100*9.8,IF(D11=AA2,F11 * H11/100 * 9.8+R11,F11 * H11/100 * 9.8-R11)))","v":""},null,null,null,{"$f":"IF(OR(D11=AA1,F11=\"\",H11=\"\",L11=\"\"),\"\",IF(H11=0,0,1/(10^((101.25-100*(J11*(100*0.3937*2.2046/9.8/12)*12/681))/14.83))*L11))","v":""},null,{"$f":"IF(OR(D11=AA1,F11=\"\",H11=\"\",L11=\"\"),\"\",IF($P$34 = 0,0,N11/$P$34))","v":""},null,{"$f":"IF(OR(D11=\"Please select...\", F11=\"\", H11=\"\", L11=\"\"), \"\", IF(F11<1.715, 0, IF(F11>=27, 121.9/12, (-8.27+4.8223*F11)/12)))","v":""}]
[]
[]
[null,4,null,"Please select ...",null,null,null,null,null,{"$f":"IF(OR(D14=AA1,F14=\"\",H14=\"\",L14=\"\"),\"\",IF(D14=AA3,F14 * H14/100*9.8,IF(D14=AA2,F14 * H14/100 * 9.8+R14,F14 * H14/100 * 9.8-R14)))","v":""},null,null,null,{"$f":"IF(OR(D14=AA1,F14=\"\",H14=\"\",L14=\"\"),\"\",IF(H14=0,0,1/(10^((101.25-100*(J14*(100*0.3937*2.2046/9.8/12)*12/681))/14.83))*L14))","v":""},null,{"$f":"IF(OR(D14=AA1,F14=\"\",H14=\"\",L14=\"\"),\"\",IF($P$34 = 0,0,N14/$P$34))","v":""},null,{"$f":"IF(OR(D14=\"Please select...\", F14=\"\", H14=\"\", L14=\"\"), \"\", IF(F14<1.715, 0, IF(F14>=27, 121.9/12, (-8.27+4.8223*F14)/12)))","v":""}]
[]
[]
[null,5,null,"Please select ...",null,null,null,null,null,{"$f":"IF(OR(D17=AA1,F17=\"\",H17=\"\",L17=\"\"),\"\",IF(D17=AA3,F17 * H17/100*9.8,IF(D17=AA2,F17 * H17/100 * 9.8+R17,F17 * H17/100 * 9.8-R17)))","v":""},null,null,null,{"$f":"IF(OR(D17=AA1,F17=\"\",H17=\"\",L17=\"\"),\"\",IF(H17=0,0,1/(10^((101.25-100*(J17*(100*0.3937*2.2046/9.8/12)*12/681))/14.83))*L17))","v":""},null,{"$f":"IF(OR(D17=AA1,F17=\"\",H17=\"\",L17=\"\"),\"\",IF($P$34 = 0,0,N17/$P$34))","v":""},null,{"$f":"IF(OR(D17=\"Please select...\", F17=\"\", H17=\"\", L17=\"\"), \"\", IF(F17<1.715, 0, IF(F17>=27, 121.9/12, (-8.27+4.8223*F17)/12)))","v":""}]
[null,null,{"$f":"IF(OR(D32=AA1,F32=\"\",H32=\"\",L32=\"\"),\"\",IF(F32<1.715*(0.3937),0,IF(F32>27*(0.3937), 121.9/12*(0.254*0.4535/100*9.8), (-8.27+4.8223*F32*(0.3937))/12)))","v":""}]
[]
[null,6,null,"Please select ...",null,null,null,null,null,{"$f":"IF(OR(D20=AA1,F20=\"\",H20=\"\",L20=\"\"),\"\",IF(D20=AA3,F20 * H20/100*9.8,IF(D20=AA2,F20 * H20/100 * 9.8+R20,F20 * H20/100 * 9.8-R20)))","v":""},null,null,null,{"$f":"IF(OR(D20=AA1,F20=\"\",H20=\"\",L20=\"\"),\"\",IF(H20=0,0,1/(10^((101.25-100*(J20*(100*0.3937*2.2046/9.8/12)*12/681))/14.83))*L20))","v":""},null,{"$f":"IF(OR(D20=AA1,F20=\"\",H20=\"\",L20=\"\"),\"\",IF($P$34 = 0,0,N20/$P$34))","v":""},null,{"$f":"IF(OR(D20=\"Please select...\", F20=\"\", H20=\"\", L20=\"\"), \"\", IF(F20<1.715, 0, IF(F20>=27, 121.9/12, (-8.27+4.8223*F20)/12)))","v":""}]
[]
[]
[null,7,null,"Please select ...",null,null,null,null,null,{"$f":"IF(OR(D23=AA1,F23=\"\",H23=\"\",L23=\"\"),\"\",IF(D23=AA3,F23 * H23/100*9.8,IF(D23=AA2,F23 * H23/100 * 9.8+R23,F23 * H23/100 * 9.8-R23)))","v":""},null,null,null,{"$f":"IF(OR(D23=AA1,F23=\"\",H23=\"\",L23=\"\"),\"\",IF(H23=0,0,1/(10^((101.25-100*(J23*(100*0.3937*2.2046/9.8/12)*12/681))/14.83))*L23))","v":""},null,{"$f":"IF(OR(D23=AA1,F23=\"\",H23=\"\",L23=\"\"),\"\",IF($P$34 = 0,0,N23/$P$34))","v":""},null,{"$f":"IF(OR(D23=\"Please select...\", F23=\"\", H23=\"\", L23=\"\"), \"\", IF(F23<1.715, 0, IF(F23>=27, 121.9/12, (-8.27+4.8223*F23)/12)))","v":""}]
[]
[]
[null,8,null,"Please select ...",null,null,null,null,null,{"$f":"IF(OR(D26=AA1,F26=\"\",H26=\"\",L26=\"\"),\"\",IF(D26=AA3,F26 * H26/100*9.8,IF(D26=AA2,F26 * H26/100 * 9.8+R26,F26 * H26/100 * 9.8-R26)))","v":""},null,null,null,{"$f":"IF(OR(D26=AA1,F26=\"\",H26=\"\",L26=\"\"),\"\",IF(H26=0,0,1/(10^((101.25-100*(J26*(100*0.3937*2.2046/9.8/12)*12/681))/14.83))*L26))","v":""},null,{"$f":"IF(OR(D26=AA1,F26=\"\",H26=\"\",L26=\"\"),\"\",IF($P$34 = 0,0,N26/$P$34))","v":""},null,{"$f":"IF(OR(D26=\"Please select...\", F26=\"\", H26=\"\", L26=\"\"), \"\", IF(F26<1.715, 0, IF(F26>=27, 121.9/12, (-8.27+4.8223*F26)/12)))","v":""}]
[]
[]
[null,9,null,"Please select ...",null,null,null,null,null,{"$f":"IF(OR(D29=AA1,F29=\"\",H29=\"\",L29=\"\"),\"\",IF(D29=AA3,F29 * H29/100*9.8,IF(D29=AA2,F29 * H29/100 * 9.8+R29,F29 * H29/100 * 9.8-R29)))","v":""},null,null,null,{"$f":"IF(OR(D29=AA1,F29=\"\",H29=\"\",L29=\"\"),\"\",IF(H29=0,0,1/(10^((101.25-100*(J29*(100*0.3937*2.2046/9.8/12)*12/681))/14.83))*L29))","v":""},null,{"$f":"IF(OR(D29=AA1,F29=\"\",H29=\"\",L29=\"\"),\"\",IF($P$34 = 0,0,N29/$P$34))","v":""},null,{"$f":"IF(OR(D29=\"Please select...\", F29=\"\", H29=\"\", L29=\"\"), \"\", IF(F29<1.715, 0, IF(F29>=27, 121.9/12, (-8.27+4.8223*F29)/12)))","v":""}]
[]
[]
[null,10,null,"Please select ...",null,null,null,null,null,{"$f":"IF(OR(D32=AA1,F32=\"\",H32=\"\",L32=\"\"),\"\",IF(D32=AA3,F32 * H32/100*9.8,IF(D32=AA2,F32 * H32/100 * 9.8+R32,F32 * H32/100 * 9.8-R32)))","v":""},null,null,null,{"$f":"IF(OR(D32=AA1,F32=\"\",H32=\"\",L32=\"\"),\"\",IF(H32=0,0,1/(10^((101.25-100*(J32*(100*0.3937*2.2046/9.8/12)*12/681))/14.83))*L32))","v":""},null,{"$f":"IF(OR(D32=AA1,F32=\"\",H32=\"\",L32=\"\"),\"\",IF($P$34 = 0,0,N32/$P$34))","v":""},null,{"$f":"IF(OR(D32=\"Please select...\", F32=\"\", H32=\"\", L32=\"\"), \"\", IF(F32<1.715, 0, IF(F32>=27, 121.9/12, (-8.27+4.8223*F32)/12)))","v":""}]
[]
[null,null,null,"Total Cumulative Damage:",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N5:N33)","v":0}]
[null,null,null,"Probability of Shoulder Outcome:",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($P$34 = 0,0,EXP(0.864+0.928*LOG10($P$34))/(1+EXP((0.864+0.928*LOG10($P$34)))))","v":0}]

{"sheet":"TST_v1.0.0_database","index":1,"n_rows":289,"n_cols":21,"rows_kept":289,"cut":false,"hidden":false,"merged":[]}
["No.","Date","Job ID","Worker ID","Task #","Task Name","Shoulder","Push/Pull",{"$f":"'TST_v1.0.0'!F3","v":"Lever Arm\n(cm)"},{"$f":"'TST_v1.0.0'!H3","v":"Load\n(kg)"},{"$f":"'TST_v1.0.0'!J3","v":"Moment\n(N.m)"},"Repetitions\n (per work day)","Damage\n(cumulative)","% Total Damage \n(of either shoulder)","Probability of Shoulder Outcome","Comments"]
[1,"2020-11-18T23:59:16",null,null,1,null,null,"Handling Load",22,22,48.49,22,1.88836,0.5]
[2,"2020-11-18T23:59:16",null,null,2,null,null,"Push/Pull Downward",1,1,0.08,34,1.0000000000000001E-5,0]
[3,"2020-11-18T23:59:17",null,null,9,null,null,"Handling Load",22,22,48.49,22,1.88836,0.5]
[4,"2020-11-18T23:59:17",null,null,11,null,null,"Handling Load",12,21,25.13,14,2.0200000000000001E-3,0]
[5,"2020-11-18T23:59:17",null,null,null,null,null,"Probability of Shoulder Outcome:",null,null,0,null,0,0.8]
[6,"2020-11-18T23:59:17",null,null,"Total",null,null,null,null,null,null,null,3.7787453487301486,null,0.8021487528270218]
[7]
[8,"2020-11-19T00:00:31",null,null,1,null,null,"Handling Load",22,22,48.49,22,1.88836,0.5]
[9,"2020-11-19T00:00:31",null,null,2,null,null,"Push/Pull Downward",1,1,0.08,34,1.0000000000000001E-5,0]
[10,"2020-11-19T00:00:31",null,null,9,null,null,"Handling Load",22,22,48.49,22,1.88836,0.5]
[11,"2020-11-19T00:00:31",null,null,10,null,null,"Horizontal Push/Pull",34,12,34,22,3.5889999999999998E-2,0.01]
[12,"2020-11-19T00:00:32",null,null,11,null,null,"Handling Load",12,21,25.13,14,2.0200000000000001E-3,0]
[13,"2020-11-19T00:00:32",null,null,null,null,null,"Probability of Shoulder Outcome:",null,null,0,null,0,0.8]
[14,"2020-11-19T00:00:32",null,null,"Total",null,null,null,null,null,null,null,3.8146340461471357,null,0.80275267596564637]
[15]
[16,"2020-11-19T00:04:09",null,null,1,null,null,"Handling Load",22,22,13.62,22,5.0000000000000002E-5,0.41]
[17,"2020-11-19T00:04:09",null,null,2,null,null,"Push/Pull Downward",1,1,0.01,34,1.0000000000000001E-5,0.04]
[18,"2020-11-19T00:04:10",null,null,9,null,null,"Handling Load",22,22,13.62,22,5.0000000000000002E-5,0.41]
[19,"2020-11-19T00:04:10",null,null,10,null,null,"Horizontal Push/Pull",34,12,4.6100000000000003,22,1.0000000000000001E-5,7.0000000000000007E-2]
[20,"2020-11-19T00:04:10",null,null,11,null,null,"Handling Load",12,21,6.98,14,1.0000000000000001E-5,7.0000000000000007E-2]
[21,"2020-11-19T00:04:10",null,null,null,null,null,"Probability of Shoulder Outcome:",null,null,0,null,0,0.06]
[22,"2020-11-19T00:04:10",null,null,"Total",null,null,null,null,null,null,null,1.2424412642097734E-4,null,5.9495710304740407E-2]
[23]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"242, 242, 242"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"217, 217, 217"]

{"sheet":"Instructions","index":2,"n_rows":174,"n_cols":7,"rows_kept":174,"cut":false,"hidden":false,"merged":[[64,1,64,9],[77,1,77,9],[79,1,79,9],[104,1,104,9],[49,1,49,9],[66,4,66,6],[70,1,70,9],[72,1,72,9],[32,1,32,9],[34,1,34,9],[17,1,17,9],[18,1,18,9],[12,1,12,9],[1,2,1,8],[1,9,6,9],[3,2,3,8],[4,2,4,8],[8,1,8,9],[173,1,173,9],[109,1,109,9],[111,1,111,9],[112,1,112,9],[120,1,120,9],[123,1,123,9],[114,1,114,9],[129,1,129,9],[126,1,126,9],[149,1,149,9],[151,1,151,9],[157,1,157,9],[161,1,161,9],[165,1,165,9],[116,4,116,7],[167,4,167,6],[172,1,172,9],[105,4,105,7],[124,1,124,9],[171,1,171,9],[73,1,73,9]]}
[]
[null,null,"Guidance on the Use of the Shoulder Work Assessment Tool (SWAT)"]
[]
[null,null,"Version 1.0.0 - Last updated on 6/11/2019"]
[null,null,"For the most up to date version, please go to: lifft.pythonanywhere.com"]
[]
[null,null,"|",null,"|",null,"|"]
[]
[]
[]
[null,"Using The Shoulder Tool"]
[]
[null,"All that is needed to use The Shoulder Tool are three pieces of information for each shoulder task being analyzed: 1) the weight held, or force exerted by the hands; 2) the greatest horizontal distance from the acromion (the flat bone on the top of the shoulder) to the center of the hand or load during the task (using a measuring tape); and 3) the total number of repetitions of the task performed during the workday. Figures 1-3 below demonstrate how to measure the maximum distance from the shoulder joint to the load. Note that the measuring tape should be held horizontally for manual handling tasks (Figure 1), but vertically when assessing tasks involving forward pushes or backward pulls (Figure 3)."]
[]
[]
[]
[]
[]
[null,"Figure 1. Proper measurement of the distance from the shoulder joint to the hand/load (the \"lever arm\").\n(Drawing adapted from Marras et al., 1999)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Figure 2. Illustration of measuring the lever arm for the left and right shoulders for a manual handling activity."]
[]
[null,"The weight of the item should be divided between the hands. In many cases, the weight may be evenly divided, but there will also be cases where the analyst should divide the weight unevenly if one shoulder is bearing more of the weight of the object. This may have to be estimated by the analyst.\n\nWhen measuring lever arms for both shoulders it is important to measure the maximum lever arm for each shoulder during the task. The maximum lever arm for the left shoulder may occur at a different time than the maximum lever arm for the right shoulder."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Figure 3. For horizontal pushing and pulling tasks, the lever arm for the load may be a vertical measurement as in pushing the cart shown above. We recommend obtaining pushing/pulling forces using force gauges, using the peak force observed during the exertion, for example, the initial force required to get a cart moving."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Figure 4. Shoulder lever arm measurement for a task involving an upward push. The same lever arm would be used for a task involving a pulling down action in the same posture."]
[]
[]
[]
[null,"Assessing Mono-Task Jobs"]
[]
[null,"The simplest application of The Shoulder Tool is for mono-task jobs (i.e., jobs involving repetition of the same shoulder intensive task throughout the workday). Assume a job involves handling a 2-pound load with the right shoulder having a lever arm of 16 inches repeated 2,880 times during the workday. Figure 5 below shows a screenshot of The Shoulder Tool for this mono-task job, which demonstrates this job’s probability for a right shoulder outcome is 20.8%. For the shoulder tool the outcome is defined as symptoms severe enough that the worker seeks medical attention. Note that while The Shoulder Tool can evaluate the risk to both shoulders, if the analyst only wants to evaluate one shoulder, the tool will accommodate such an analysis as well."]
[]
[]
[null,"Figure 1. A screenshot of the DUET tool for analyzing a mono-task job"]
[]
[]
[]
[null,"Figure 5. A screenshot of The Shoulder Tool for analyzing a mono-task job."]
[]
[null,"Now, let’s assume another monotask job involves an operator lifting a 10 lb. panel from a conveyor to a rack using both hands (with even weight distribution). This task is performed 480 times per shift and the peak lever arm when handling the load is 18 inches. Note that in this example, the since the weight is evenly distributed and the lever arms are the same, the risk to each shoulder is identical (the tool does not differentiate “handedness” dominant hand strength). The analysis is shown in Figure 6 below:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Figure 6. Analysis of a monotask two-handed lift with even weight distribution."]
[]
[]
[null,"Assessing Jobs with Multiple Shoulder Tasks"]
[]
[null,"For jobs involving multiple exertions during a workday, each individual task should be analyzed using the same methods shown above. The cumulative damage associated with each task will be summed by The Shoulder Tool to determine the \"daily dose\" of cumulative damage for both left and right shoulders. An example is provided in Figure 7 below."]
[]
[]
[null,"Figure 7. A screenshot of The Shoulder Tool for analyzing a multi-task job."]
[]
[null,"As can be seen in Figure 7, The Shoulder Tool identifies the percentage of the total damage associated with each task. Note that the first task represents a symmetric lift with equal moments about the left and right shoulders and the same number of repetitions. In this example, task 2 was associated with the majority of the cumulative damage. Therefore, task 2 should be given priority for ergonomic intervention."]
[]
[]
[]
[null,"Assessing Highly Variable Shoulder Jobs "]
[]
[null,"If a large number of highly variable shoulder intensive tasks are to be performed (for example, warehouse picking), a \"binning\" procedure can be used. In this procedure, tasks within the same range of peak moments are summed together and the amount of cumulative damage is determined using the number of shoulder tasks within each \"bin\". For example, let’s assume a warehouse picker was to lift items that have the following shoulder moments (for the right shoulder):"]
[]
[null,null,null,"Table 1. Right shoulder data for binning example"]
[]
[null,"We can reasonably create three \"bins\" for these data based on the shoulder moments: one from 0-10 ft. lbs., one from 11-20 ft.lbs., and one from 21-30 ft.lbs. The first bin would include tasks 1, 5, and 8. Similarly, the second bin would include tasks 4, 6, and 9 and the third bin would include tasks 2, 3, and 7."]
[]
[null,"For the first bin, we would input the data for the first bin into first task (i.e., first line) of The Shoulder Tool. This task would have a 10 ft.lb. moment (12 inch lever arm and 10 lb. load) and 157 repetitions (the sum of the repetitions for tasks 1, 5, and 8). For the second line, we would input a 20 ft.lb. moment (12 inch lever arm and 20 lb. load), sum the repetitions for tasks 4, 6, and 9 (50+32+40 = 122), and input this value as the repetitions for this bin. The procedures for the third bin would follow the same steps as above. Figure 8 shows the results of the binning analysis example."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Figure 8. Results of analysis using the \"binning\" technique."]
[]
[null,"It should be noted that the binning procedure described above might result in a somewhat inflated probability of shoulder outcomes. However, the estimates should be reasonably close. In this regard, it should be recognized that when using the binning technique, it is important to use the narrowest range for the bins possible. While our example uses bins that are 10 ft.lbs. wide, there is no reason that bins with a width of 5 ft.lbs. could not be used. In fact, it is recommended that the analyst use the smallest bin size that can be reasonably used and completely cover the range of shoulder moments observed in the job."]
[]
[]
[]
[null,"Limitations"]
[]
[null,"The shoulder is a complex structure and it is difficult in a simple risk assessment tool to account for all possible loading situations the shoulder might encounter that might increase risk. One example is the case where an arm is simply held directly above the shoulder. Such a posture will create a low moment, but requires substantial muscle contraction, will be physiologically fatiguing, and will undoubtedly incur some injury risk. Similarly, there may be tasks where the applied forces go directly through the shoulder joint, such as pushing forward at shoulder height with the arms straight in front of (and in line with) the shoulder. Such an activity creates no moment, but will create stress in the shoulder. These situations are not currently addressed in the tool. We hope that future versions will be able to address these limitations. However, the tool in its current form demonstrates strong associations with shoulder pain and worker clinic visits for shoulder and neck complaints."]
[]
[null,"Excel™ Version of The Shoulder Tool"]
[]
[null,"An Excel™ version of The Shoulder Tool will soon be available for download. This version provides additional functionalities, including the ability to save your analyses in an Excel™ worksheet. This will allow the analyst to create a record of all analyses performed at a particular worksite, including information regarding the job and worker. The Excel™ version allows the analyst to save analyses of both left and right shoulders for a worker, and will save all relevant information to inform the risk associated with each shoulder and which tasks are contributing most to the workers overall risk."]
[]
[null,"Other Fatigue Failure Tools"]
[]
[null,"The Shoulder Tool is the third risk assessment tool developed by ergonomists at Auburn University, all based on the fatigue failure model of musculoskeletal injury development. The others are the Lifting Fatigue Failure Tool (LiFFT) (Gallagher et al., 2017) and the Distal Upper Extremity Tool (DUET) (Gallagher et al., 2018). The former can be used to assess the risk associated with lifting and lowering tasks, while the latter can be used to evaluate the risk of upper extremity disorders. All three can be used in conjunction with one another to get a comprehensive assessment of risk to the low back, upper extremities, and shoulders for workers."]
[]
[]
[]
[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":"push_pull","index":3,"n_rows":24,"n_cols":6,"rows_kept":24,"cut":false,"hidden":true,"merged":[]}
[]
["Dropdown","Please select ...","No Data"]
[null,"Handling Load","+ Arm Weight","moment+Arm Moment"]
[null,"Horizontal Push/Pull","NO Arm Weight","moment"]
[null,"Push/Pull Downward","- Arm Weight","moment-Arm Moment"]
[]
["Empty Cell"]
[]
[null,null,"Arm Moment"]
["Arm Moment","If lever arm<1.715",0]
[null,"If lever arm>=1.715 and <27","(-8.27 + 4.8223 * lever_arm)/12.0 "]
[null,"If lever arm>=27","121.9 / 12.0"]
[]
["Task #","Type of Task","Lever Arm \n(inch)","Load \n(lbs)","Arm Moment (ft. lbs)","Moment (ft. lbs)"]
[1,"Handling Load",12,18,{"$f":"IF(OR('TST_v1.0.0'!D5=\"Please select...\", 'TST_v1.0.0'!F5=\"\", 'TST_v1.0.0'!H5=\"\", 'TST_v1.0.0'!L5=\"\"), \"\", IF('TST_v1.0.0'!F5<1.715, 0, IF('TST_v1.0.0'!F5>=27, 121.9/12, (-8.27+4.8223*'TST_v1.0.0'!F5)/12)))","v":""},{"$f":"IF(OR(B15=\"\",C15=\"\",D15=\"Please select ...\"),\"\",IF(VLOOKUP(B15,push_pull!$B$2:$B$5,1,FALSE)=\"Horizontal Push/Pull\", C15/12*D15,IF(VLOOKUP(B15,push_pull!$B$2:$B$5,1,FALSE)=\"Handling Load\",C15/12*D15+((-8.27+4.8223*C15)/12),C15/12*D15-((-8.27+4.8223*C15)/12))))","v":22.133133333333333}]
[2,"Horizontal Push/Pull",12,15,{"$f":"IF(OR('TST_v1.0.0'!D8=\"Please select...\", 'TST_v1.0.0'!F8=\"\", 'TST_v1.0.0'!H8=\"\", 'TST_v1.0.0'!L8=\"\"), \"\", IF('TST_v1.0.0'!F8<1.715, 0, IF('TST_v1.0.0'!F8>=27, 121.9/12, (-8.27+4.8223*'TST_v1.0.0'!F8)/12)))","v":""},{"$f":"IF(OR(B16=\"\",C16=\"\",D16=\"Please select ...\"),\"\",IF(VLOOKUP(B16,push_pull!$B$2:$B$5,1,FALSE)=\"Horizontal Push/Pull\", C16/12*D16,IF(VLOOKUP(B16,push_pull!$B$2:$B$5,1,FALSE)=\"Handling Load\",C16/12*D16+((-8.27+4.8223*C16)/12),C16/12*D16-((-8.27+4.8223*C16)/12))))","v":15}]
[3,"Push/Pull Downward",12,15,{"$f":"IF(OR('TST_v1.0.0'!D11=\"Please select...\", 'TST_v1.0.0'!F11=\"\", 'TST_v1.0.0'!H11=\"\", 'TST_v1.0.0'!L11=\"\"), \"\", IF('TST_v1.0.0'!F11<1.715, 0, IF('TST_v1.0.0'!F11>=27, 121.9/12, (-8.27+4.8223*'TST_v1.0.0'!F11)/12)))","v":""},{"$f":"IF(OR(B17=\"\",C17=\"\",D17=\"Please select ...\"),\"\",IF(VLOOKUP(B17,push_pull!$B$2:$B$5,1,FALSE)=\"Horizontal Push/Pull\", C17/12*D17,IF(VLOOKUP(B17,push_pull!$B$2:$B$5,1,FALSE)=\"Handling Load\",C17/12*D17+((-8.27+4.8223*C17)/12),C17/12*D17-((-8.27+4.8223*C17)/12))))","v":10.866866666666667}]
[4,"Please select ...",null,null,null,{"$f":"IF(OR(B18=\"\",C18=\"\",D18=\"Please select ...\"),\"\",IF(VLOOKUP(B18,push_pull!$B$2:$B$5,1,FALSE)=\"Horizontal Push/Pull\", C18/12*D18,IF(VLOOKUP(B18,push_pull!$B$2:$B$5,1,FALSE)=\"Handling Load\",C18/12*D18+((-8.27+4.8223*C18)/12),C18/12*D18-((-8.27+4.8223*C18)/12))))","v":""}]
[5,"Please select ...",null,null,null,{"$f":"IF(OR(B19=\"\",C19=\"\",D19=\"Please select ...\"),\"\",IF(VLOOKUP(B19,push_pull!$B$2:$B$5,1,FALSE)=\"Horizontal Push/Pull\", C19/12*D19,IF(VLOOKUP(B19,push_pull!$B$2:$B$5,1,FALSE)=\"Handling Load\",C19/12*D19+((-8.27+4.8223*C19)/12),C19/12*D19-((-8.27+4.8223*C19)/12))))","v":""}]
[6,"Please select ...",null,null,null,{"$f":"IF(OR(B20=\"\",C20=\"\",D20=\"Please select ...\"),\"\",IF(VLOOKUP(B20,push_pull!$B$2:$B$5,1,FALSE)=\"Horizontal Push/Pull\", C20/12*D20,IF(VLOOKUP(B20,push_pull!$B$2:$B$5,1,FALSE)=\"Handling Load\",C20/12*D20+((-8.27+4.8223*C20)/12),C20/12*D20-((-8.27+4.8223*C20)/12))))","v":""}]
[7,"Please select ...",null,null,null,{"$f":"IF(OR(B21=\"\",C21=\"\",D21=\"Please select ...\"),\"\",IF(VLOOKUP(B21,push_pull!$B$2:$B$5,1,FALSE)=\"Horizontal Push/Pull\", C21/12*D21,IF(VLOOKUP(B21,push_pull!$B$2:$B$5,1,FALSE)=\"Handling Load\",C21/12*D21+((-8.27+4.8223*C21)/12),C21/12*D21-((-8.27+4.8223*C21)/12))))","v":""}]
[8,"Please select ...",null,null,null,{"$f":"IF(OR(B22=\"\",C22=\"\",D22=\"Please select ...\"),\"\",IF(VLOOKUP(B22,push_pull!$B$2:$B$5,1,FALSE)=\"Horizontal Push/Pull\", C22/12*D22,IF(VLOOKUP(B22,push_pull!$B$2:$B$5,1,FALSE)=\"Handling Load\",C22/12*D22+((-8.27+4.8223*C22)/12),C22/12*D22-((-8.27+4.8223*C22)/12))))","v":""}]
[9,"Please select ...",null,null,null,{"$f":"IF(OR(B23=\"\",C23=\"\",D23=\"Please select ...\"),\"\",IF(VLOOKUP(B23,push_pull!$B$2:$B$5,1,FALSE)=\"Horizontal Push/Pull\", C23/12*D23,IF(VLOOKUP(B23,push_pull!$B$2:$B$5,1,FALSE)=\"Handling Load\",C23/12*D23+((-8.27+4.8223*C23)/12),C23/12*D23-((-8.27+4.8223*C23)/12))))","v":""}]
[10,"Please select ...",null,null,null,{"$f":"IF(OR(B24=\"\",C24=\"\",D24=\"Please select ...\"),\"\",IF(VLOOKUP(B24,push_pull!$B$2:$B$5,1,FALSE)=\"Horizontal Push/Pull\", C24/12*D24,IF(VLOOKUP(B24,push_pull!$B$2:$B$5,1,FALSE)=\"Handling Load\",C24/12*D24+((-8.27+4.8223*C24)/12),C24/12*D24-((-8.27+4.8223*C24)/12))))","v":""}]

{"sheet":"Sheet1","index":4,"n_rows":34,"n_cols":38,"rows_kept":34,"cut":false,"hidden":true,"merged":[]}
[null,"A",1,null,null,"Task #",null,"Lever Arm \n(inch)",null,"Load \n(lbs)",null,"Push\n/Pull",null,"Moment \n(ft.lbs.)",null,"Repetitions\n(per work day)",null,"Damage\n(cumulative)",null,"% Total (damage)",null,null,null,"Task #",null,"Lever Arm \n(inch)",null,"Load \n(lbs)",null,"Push\n/Pull",null,"Moment \n(ft.lbs.)",null,"Repetitions\n(per work day)",null,"Damage\n(cumulative)",null,"% Total (damage)"]
["Task #","B",2]
[null,"C",3]
["Lever Arm \n(inch)","D",4]
[null,"E",5]
["Load \n(lbs)","F",6]
[null,"G",7]
["Push\n/Pull","H",8]
[null,"I",9]
["Moment \n(ft.lbs.)","J",10]
[null,"K",11]
["Repetitions\n(per work day)","L",12]
[null,"M",13]
["Damage\n(cumulative)","N",14]
[null,"O",15]
["% Total (damage)","P",16]
[null,"Q",17]
[null,"R",18]
[null,"S",19]
["Task #","T",20]
[null,"U",21]
["Lever Arm \n(inch)","V",22]
[null,"W",23]
["Load \n(lbs)","X",24]
[null,"Y",25]
["Push\n/Pull","Z",26]
[null,"AA1",27]
["Moment \n(ft.lbs.)","AB1",28]
[null,"AC1",29]
["Repetitions\n(per work day)","AD1",30]
[null,"AE1",31]
["Damage\n(cumulative)","AF1",32]
[null,"AG1",33]
["% Total (damage)","AH1",34]