{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Form","Tables"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"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":"Form","index":0,"n_rows":34,"n_cols":7,"rows_kept":34,"cut":false,"hidden":false,"merged":[[5,2,5,5],[6,2,6,5],[7,2,7,5]]}
["Pushing and Pulling Guidelines"]
["Based on Snook & Cirello Psychophysical Tables"]
["75% capable, female"]
["Directions:  Must fill in cells in order, from top to bottom."]
[]
["Date"]
["Analyst"]
["Job"]
[]
[]
["Load Scenario"]
["Distance of Push/Pull "]
["Frequency (one push/pull every)"]
["Hand Height"]
[]
[]
["Suggested Maximum Initial Force",null,null,null,null,{"$f":"CONCATENATE(IF(F11=\"Pull\",IF(Form!F12=\"7 ft\",HLOOKUP(Form!F13,Tables!C7:J10,MATCH(Form!F14,Tables!C7:C10,0),FALSE),IF(F12=\"25 ft\",HLOOKUP(F13,Tables!L7:S10,MATCH(Form!F14,Tables!L7:L10,0),FALSE),IF(Form!F12=\"50 ft\",HLOOKUP(Form!F13,Tables!U7:AB10,MATCH(Form!F14,Tables!U7:U10,0),FALSE),IF(Form!F12=\"100 ft\",HLOOKUP(Form!F13,Tables!AD7:AI10,MATCH(Form!F14,Tables!AD7:AD10,0),FALSE),IF(Form!F12=\"150 ft\",HLOOKUP(Form!F13,Tables!AK7:AP10,MATCH(Form!F14,Tables!AK7:AK10,0),FALSE),IF(Form!F12=\"200 ft\",HLOOKUP(Form!F13,Tables!AR7:AV10,MATCH(Form!F14,Tables!AR7:AR10,0),FALSE),0)))))),IF(F12=\"7 ft\",HLOOKUP(F13,Tables!C27:J30,MATCH(Form!F14,Tables!C27:C30,0),FALSE),IF(Form!F12=\"25 ft\",HLOOKUP(Form!F13,Tables!L27:S30,MATCH(Form!F14,Tables!L27:L30,0),FALSE),IF(Form!F12=\"50 ft\",HLOOKUP(Form!F13,Tables!U27:AB30,MATCH(Form!F14,Tables!U27:U30,0),FALSE),IF(Form!F12=\"100 ft\",HLOOKUP(Form!F13,Tables!AD27:AI30,MATCH(Form!F14,Tables!AK27:AK30,0),FALSE),IF(Form!F12=\"150 ft\",HLOOKUP(Form!F13,Tables!AK27:AP30,MATCH(Form!F14,Tables!AK27:AK30,0),FALSE),IF(Form!F12=\"200 ft\",HLOOKUP(Form!F13,Tables!AR27:AV30,MATCH(Form!F14,Tables!AR27:AR30,0),FALSE),0))))))),\" lbs\")","v":"0 lbs"}]
["Suggested Maximum Sustained Force",null,null,null,null,{"$f":"CONCATENATE(IF(F11=\"Pull\",IF(F12=\"7 ft\",HLOOKUP(F13,Tables!C17:J20,MATCH(Form!F14,Tables!C17:C20,0),FALSE),IF(Form!F12=\"25 ft\",HLOOKUP(Form!F13,Tables!L17:S20,MATCH(Form!F14,Tables!L17:L20,0),FALSE),IF(Form!F12=\"50 ft\",HLOOKUP(Form!F13,Tables!U17:AB20,MATCH(Form!F14,Tables!U17:U20,0),FALSE),IF(Form!F12=\"100 ft\",HLOOKUP(Form!F13,Tables!AD17:AI20,MATCH(Form!F14,Tables!AD17:AD20,0),FALSE),IF(Form!F12=\"150 ft\",HLOOKUP(Form!F13,Tables!AK17:AP20,MATCH(Form!F14,Tables!AK17:AK20,0),FALSE),IF(Form!F12=\"200 ft\",HLOOKUP(Form!F13,Tables!AR17:AV20,MATCH(Form!F14,Tables!AR17:AR20,0),FALSE),0)))))),IF(Form!F12=\"7 ft\",HLOOKUP(Form!F13,Tables!C37:J40,MATCH(Form!F14,Tables!C37:C40,0),FALSE),IF(Form!F12=\"25 ft\",HLOOKUP(Form!F13,Tables!L37:S40,MATCH(Form!F14,Tables!L37:L40,0),FALSE),IF(Form!F12=\"50 ft\",HLOOKUP(Form!F13,Tables!U37:AB40,MATCH(Form!F14,Tables!U37:U40,0),FALSE),IF(Form!F12=\"100 ft\",HLOOKUP(Form!F13,Tables!AD37:AI40,MATCH(Form!F14,Tables!AD37:AD40,0),FALSE),IF(Form!F12=\"150 ft\",HLOOKUP(Form!F13,Tables!AK37:AP40,MATCH(Form!F14,Tables!AK37:AK40,0),FALSE),IF(Form!F12=\"200 ft\",HLOOKUP(Form!F13,Tables!AR37:AV40,MATCH(Form!F14,Tables!AR37:AR40,0),FALSE),0))))))),\" lbs\")","v":"0 lbs"}]
[]
["Reference: S. H. Snook and V. M. Ciriello"]
["The design of manual handling tasks: revised tables of maximum acceptable weights and forces"]
["Ergonomics 34(9):1197-1213, 1991"]
[]
["6 sec","15 sec","25 sec","1 min","2 min",null,"7 ft"]
["12 sec","22 sec","35 sec","2 min","5 min",null,"25 ft"]
["1 min","1 min","1 min","5 min","30 min",null,"50 ft"]
["2 min","2 min","2 min","30 min","8 hr",null,"100 ft"]
["5 min","5 min","5 min","8 hr",null,null,"150 ft"]
["30 min","30 min","30 min",null,null,null,"200 ft"]
["8 hr","8 hr","8 hr"]
[]
["Push",null,"22 in"]
["Pull",null,"35 in"]
[null,null,"53 in"]

{"sheet":"Tables","index":1,"n_rows":40,"n_cols":48,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
["These forces correspond to 75% of what the female population can handle"]
[]
[]
[null,"PULLING - INITIAL"]
[null,null,null,null,null,"7 ft","distance",null,null,null,null,null,null,null,"25 ft",null,null,null,null,null,null,null,null,null,"50 ft",null,null,null,null,null,null,null,"100 ft",null,null,null,null,null,null,"150 ft",null,null,null,null,null,"200 ft"]
[null,null,null,null,null,null,null,null,"frequency"]
[null,null,null,"6 sec","12 sec","1 min","2 min","5 min","30 min","8 hr",null,null,"15 sec","22 sec","1 min","2 min","5 min","30 min","8 hr",null,null,"25 sec","35 sec","1 min","2 min","5 min","30 min","8 hr",null,null,"1 min","2 min","5 min","30 min","8 hr",null,null,"1 min","2 min","5 min","30 min","8 hr",null,null,"2 min","5 min","30 min","8 hr"]
[null,"hand height","53 in",35,42,44,46,53,55,57,null,"53 in",35,37,42,42,46,49,53,null,"53 in",26,31,35,35,40,42,44,null,"53 in",31,35,37,40,44,null,"53 in",31,35,37,40,44,null,"53 in",31,33,35,40]
[null,null,"35 in",35,42,46,49,55,57,60,null,"35 in",37,40,42,44,49,51,55,null,"35 in",26,33,37,37,42,44,46,null,"35 in",33,35,40,42,46,null,"35 in",33,35,40,42,46,null,"35 in",33,35,37,42]
[null,null,"22 in",37,44,49,51,57,60,62,null,"22 in",37,42,44,46,51,53,57,null,"22 in",29,33,37,40,44,46,49,null,"22 in",35,37,40,44,49,null,"22 in",35,37,40,44,49,null,"22 in",33,35,40,44]
[]
[]
[]
[null,"PULLING - SUSTAINED"]
[null,null,null,null,null,"7 ft",null,null,null,null,null,null,null,null,"25 ft",null,null,null,null,null,null,null,null,null,"50 ft",null,null,null,null,null,null,null,"100 ft",null,null,null,null,null,null,"150 ft",null,null,null,null,null,"200 ft"]
[]
[null,null,null,"6 sec","12 sec","1 min","2 min","5 min","30 min","8 hr",null,null,"15 sec","22 sec","1 min","2 min","5 min","30 min","8 hr",null,null,"25 sec","35 sec","1 min","2 min","5 min","30 min","8 hr",null,null,"1 min","2 min","5 min","30 min","8 hr",null,null,"1 min","2 min","5 min","30 min","8 hr",null,null,"2 min","5 min","30 min","8 hr"]
[null,null,"53 in",18,26,29,31,33,35,44,null,"53 in",20,24,26,26,29,31,40,null,"53 in",15,20,22,22,24,26,33,null,"53 in",18,20,22,22,31,null,"53 in",18,20,20,20,26,null,"53 in",15,15,15,22]
[null,null,"35 in",18,26,29,29,33,35,42,null,"35 in",20,22,24,26,29,31,37,null,"35 in",15,18,22,22,24,26,31,null,"35 in",18,20,20,22,29,null,"35 in",15,18,20,20,26,null,"35 in",13,15,15,20]
[null,null,"22 in",15,24,26,26,29,31,40,null,"22 in",18,20,24,24,26,29,35,null,"22 in",15,18,20,20,22,24,29,null,"22 in",15,18,20,20,26,null,"22 in",15,18,18,18,24,null,"22 in",13,13,13,20]
[]
[]
[]
[null,"PUSHING - INITIAL"]
[null,null,null,null,null,"7 ft",null,null,null,null,null,null,null,null,"25 ft",null,null,null,null,null,null,null,null,null,"50 ft",null,null,null,null,null,null,null,"100 ft",null,null,null,null,null,null,"150 ft",null,null,null,null,null,"200 ft"]
[]
[null,null,null,"6 sec","12 sec","1 min","2 min","5 min","30 min","8 hr",null,null,"15 sec","22 sec","1 min","2 min","5 min","30 min","8 hr",null,null,"25 sec","35 sec","1 min","2 min","5 min","30 min","8 hr",null,null,"1 min","2 min","5 min","30 min","8 hr",null,null,"1 min","2 min","5 min","30 min","8 hr",null,null,"2 min","5 min","30 min","8 hr"]
[null,null,"53 in",37,40,46,49,53,55,60,null,"53 in",40,42,42,44,49,51,53,null,"53 in",33,37,37,37,42,44,46,null,"53 in",33,35,37,42,46,null,"53 in",33,35,37,42,46,null,"53 in",31,33,37,42]
[null,null,"35 in",37,40,46,49,53,55,60,null,"35 in",37,40,44,44,49,51,55,null,"35 in",31,35,37,37,42,44,46,null,"35 in",33,35,40,42,46,null,"35 in",33,35,40,42,46,null,"35 in",33,35,37,42]
[null,null,"22 in",31,33,37,37,42,44,46,null,"22 in",31,33,37,37,42,44,46,null,"22 in",24,29,31,33,35,37,40,null,"22 in",29,31,33,35,40,null,"22 in",29,31,33,35,40,null,"22 in",26,29,31,35]
[]
[]
[]
[null,"PUSHING - SUSTAINED"]
[null,null,null,null,null,"7 ft",null,null,null,null,null,null,null,null,"25 ft",null,null,null,null,null,null,null,null,null,"50 ft",null,null,null,null,null,null,null,"100 ft",null,null,null,null,null,null,"150 ft",null,null,null,null,null,"200 ft"]
[]
[null,null,null,"6 sec","12 sec","1 min","2 min","5 min","30 min","8 hr",null,null,"15 sec","22 sec","1 min","2 min","5 min","30 min","8 hr",null,null,"25 sec","35 sec","1 min","2 min","5 min","30 min","8 hr",null,null,"1 min","2 min","5 min","30 min","8 hr",null,null,"1 min","2 min","5 min","30 min","8 hr",null,null,"2 min","5 min","30 min","8 hr"]
[null,null,"53 in",20,26,31,31,35,37,46,null,"53 in",20,22,24,24,26,29,35,null,"53 in",15,18,20,20,22,24,29,null,"53 in",15,18,20,20,26,null,"53 in",15,18,18,18,24,null,"53 in",13,13,13,20]
[null,null,"35 in",18,24,29,29,33,35,42,null,"35 in",20,22,24,24,29,29,37,null,"35 in",15,18,20,22,24,24,31,null,"35 in",18,20,20,22,29,null,"35 in",15,18,18,20,26,null,"35 in",13,13,15,20]
[null,null,"22 in",15,20,24,26,29,31,37,null,"22 in",18,22,22,24,26,26,33,null,"22 in",15,18,20,20,22,22,29,null,"22 in",15,18,18,20,26,null,"22 in",15,15,18,18,24,null,"22 in",13,13,13,18]