{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["A>G-MHORA Details","B>MAC Lifting-Lowering-Carrying","B- Formulae","C>RAPP Pushing-Pulling","C- Formulae","D>Controls","Look-ups","E>Photographs","F>Instructions","G>Lift-Lower-Carry Conditions","H>Push-Pull Conditions","V>Version Log"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":55,"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":"A>G-MHORA Details","index":0,"n_rows":46,"n_cols":11,"rows_kept":46,"cut":false,"hidden":false,"merged":[[45,2,45,9],[41,0,45,1],[34,0,34,2],[35,0,35,2],[36,0,36,2],[37,0,37,2],[40,0,40,1],[40,2,40,9],[34,5,34,9],[35,5,35,9],[36,5,36,9],[37,5,37,9],[29,0,29,9],[39,0,39,9],[26,0,26,1],[26,2,26,9],[27,0,27,1],[27,2,27,9],[30,0,30,1],[30,2,30,9],[33,0,33,9],[31,0,31,1],[31,2,31,9],[12,0,14,1],[2,0,2,9],[19,0,19,9],[25,0,25,9],[22,0,22,3],[22,4,22,7],[22,8,22,9],[23,0,23,3],[23,4,23,7],[14,2,14,3],[14,4,14,9],[23,8,23,9],[5,5,7,6],[20,0,20,3],[20,4,20,7],[20,8,20,9],[21,0,21,3],[21,4,21,7],[21,8,21,9],[15,0,17,1],[15,3,15,6],[15,8,15,9],[16,2,16,3],[16,4,16,9],[17,2,17,3],[17,4,17,9],[4,2,4,9],[0,0,0,9],[3,0,3,1],[3,2,3,6],[3,7,3,8],[4,0,4,1],[5,0,7,1],[34,3,34,4],[35,3,35,4],[36,3,36,4],[37,3,37,4],[10,4,10,9],[11,4,11,9],[9,0,11,1],[10,2,10,3],[11,2,11,3],[9,8,9,9],[9,3,9,6],[12,3,12,6],[12,8,12,9],[13,2,13,3],[13,4,13,9]]}
["PART A -  RISK ASSESSMENT DETAILS"]
[null,null,null,null,null,null,null,null,null,"V5-6 19/07/2018"]
["A1: Assessment Reference Details"]
["Reference No:",null,null,null,null,null,null,"Version No:",null,null,"A1.1"]
["Manual Handling Operation:",null,null,null,null,null,null,null,null,null,"A1.2"]
["Status of Assessment:",null,null,null,null,"Purpose of Assessment:",null,null,null,null,"A1.3"]
[]
[]
[]
["Completed By:",null,"Name:",null,null,null,null,"Date:",null,null,"A1.4"]
[null,null,"Job Title:"]
[null,null,"Business Unit:"]
["Checked By:",null,"Name:",null,null,null,null,"Date:",null,null,"A1.5"]
[null,null,"Job Title:"]
[null,null,"Business Unit:"]
["Peer Reviewed By (STE):",null,"Name:",null,null,null,null,"Date:",null,null,"A1.6"]
[null,null,"Job Title:"]
[null,null,"Business Unit:"]
[]
["A2:  Related Work Activity Risk Assessments"]
["Description",null,null,null,"Reference",null,null,null,"Version",null,"A2"]
[]
[]
[]
[]
["A3:  Details of Load"]
["Item Handled\n(inc manufacturer/ model etc if applicable)",null,null,null,null,null,null,null,null,null,"A3.1"]
["Maximum Weight(s) in Kg\nFor each part handled",null,null,null,null,null,null,null,null,null,"A3.2"]
[]
["A4:  Overview of Manual Handling Operation"]
["Brief Description of Manual Handling Operation",null,null,null,null,null,null,null,null,null,"A4.1"]
["What Types of Staff Carry Out this Task",null,null,null,null,null,null,null,null,null,"A4.2"]
[]
["A5:  Details of Where and When  Manual Handling Operation was Observed"]
["Where was Manual Handling Operation observed?",null,null,"On what date was it observed?",null,"Who was Involved in Completing the Assessment?",null,null,null,null,"A5"]
[]
[]
[]
[]
["A6:  Indications that Operation poses Risk of Injury"]
["Any history of incidents (last 5 years)? \nIf so, provide details",null,null,null,null,null,null,null,null,null,"A6.1"]
["Other Indications:",null,null,null,null,null,null,null,null,null,"A6.2"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"A6.3"]

{"sheet":"B>MAC Lifting-Lowering-Carrying","index":1,"n_rows":39,"n_cols":29,"rows_kept":39,"cut":false,"hidden":false,"merged":[[16,18,17,18],[16,19,17,19],[16,20,17,20],[16,22,16,23],[8,2,8,5],[9,2,9,5],[10,2,10,5],[13,12,14,12],[6,0,6,1],[7,0,7,1],[8,0,8,1],[9,0,9,1],[10,0,10,1],[0,0,0,10],[4,0,4,1],[5,0,5,1],[2,0,2,1],[2,2,2,4],[2,6,2,10],[3,6,3,10],[3,2,3,5],[5,2,5,5],[4,2,4,5],[2,13,2,14],[2,17,2,18],[2,19,2,20],[2,21,2,22],[2,15,2,16],[11,0,11,1],[12,0,12,1],[15,8,15,10],[9,6,9,10],[11,2,11,5],[12,2,12,5],[6,2,6,5],[7,2,7,5],[38,0,38,1],[31,0,31,10],[30,2,30,10],[33,6,34,8],[33,9,34,10],[35,2,35,5],[36,2,36,5],[38,2,38,5],[35,6,35,8],[36,6,36,8],[37,6,37,8],[38,6,38,8],[35,9,35,10],[36,9,36,10],[37,2,37,5],[33,2,34,5],[37,9,37,10],[38,9,38,10],[4,6,4,10],[5,6,5,10],[6,6,6,10],[7,6,7,10],[8,6,8,10],[10,6,10,10],[11,6,11,10],[12,6,12,10],[15,2,15,7],[16,2,16,3],[16,4,16,5],[16,6,16,7]]}
["PART B -  HSE MAC - LIFTING/LOWERING/CARRYING TASK STEPS - RISK ASSESSMENT"]
[]
["Description of Task Step",null,"Type of manual handling activity",null,null,null,"Standard location type \n",null,null,null,null,null,null,"Floor surface",null,"Environmental factors",null,"Postural Constraints",null,"Carry distance",null,"Obstacles en Route"]
[null,"B1.1","B1.2",null,null,null,"B1.3",null,null,null,null,null,null,"Colour","Score","Colour","Score","Colour","Score","Colour","Score","Colour","Score"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR($C5=\"\",$G5=\"\"),\"\",VLOOKUP($G5,LLC_Stan_scores,3))","v":""},{"$f":"IF(OR($C5=\"\",$G5=\"\"),\"\",VLOOKUP($G5,LLC_Stan_scores,4))","v":""},{"$f":"IF(OR($C5=\"\",$G5=\"\"),\"\",VLOOKUP($G5,LLC_Stan_scores,6))","v":""},{"$f":"IF(OR($C5=\"\",$G5=\"\"),\"\",VLOOKUP($G5,LLC_Stan_scores,7))","v":""},{"$f":"IF(OR($C5=\"\",$G5=\"\"),\"\",VLOOKUP($G5,LLC_Stan_scores,9))","v":""},{"$f":"IF(OR($C5=\"\",$G5=\"\"),\"\",VLOOKUP($G5,LLC_Stan_scores,10))","v":""},{"$f":"IF(OR($C5=\"\",$C5<>\"Individual Carry\",$G5=\"\"),\"\",VLOOKUP($G5,LLC_Stan_scores,12))","v":""},{"$f":"IF(OR($C5=\"\",$C5<>\"Individual Carry\",$G5=\"\"),\"\",VLOOKUP($G5,LLC_Stan_scores,13))","v":""},{"$f":"IF(OR($C5=\"\",$C5<>\"Individual Carry\",$G5=\"\"),\"\",VLOOKUP($G5,LLC_Stan_scores,15))","v":""},{"$f":"IF(OR($C5=\"\",$C5<>\"Individual Carry\",$G5=\"\"),\"\",VLOOKUP($G5,LLC_Stan_scores,16))","v":""}]
[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,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,null,null,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR($C10=\"\",$G10=\"\"),\"\",VLOOKUP($G10,LLC_Stan_scores,3))","v":""},{"$f":"IF(OR($C10=\"\",$G10=\"\"),\"\",VLOOKUP($G10,LLC_Stan_scores,4))","v":""},{"$f":"IF(OR($C10=\"\",$G10=\"\"),\"\",VLOOKUP($G10,LLC_Stan_scores,6))","v":""},{"$f":"IF(OR($C10=\"\",$G10=\"\"),\"\",VLOOKUP($G10,LLC_Stan_scores,7))","v":""},{"$f":"IF(OR($C10=\"\",$G10=\"\"),\"\",VLOOKUP($G10,LLC_Stan_scores,9))","v":""},{"$f":"IF(OR($C10=\"\",$G10=\"\"),\"\",VLOOKUP($G10,LLC_Stan_scores,10))","v":""},{"$f":"IF(OR($C10=\"\",$C10<>\"Individual Carry\",$G10=\"\"),\"\",VLOOKUP($G10,LLC_Stan_scores,12))","v":""},{"$f":"IF(OR($C10=\"\",$C10<>\"Individual Carry\",$G10=\"\"),\"\",VLOOKUP($G10,LLC_Stan_scores,13))","v":""},{"$f":"IF(OR($C10=\"\",$C10<>\"Individual Carry\",$G10=\"\"),\"\",VLOOKUP($G10,LLC_Stan_scores,15))","v":""},{"$f":"IF(OR($C10=\"\",$C10<>\"Individual Carry\",$G10=\"\"),\"\",VLOOKUP($G10,LLC_Stan_scores,16))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR($C11=\"\",$G11=\"\"),\"\",VLOOKUP($G11,LLC_Stan_scores,3))","v":""},{"$f":"IF(OR($C11=\"\",$G11=\"\"),\"\",VLOOKUP($G11,LLC_Stan_scores,4))","v":""},{"$f":"IF(OR($C11=\"\",$G11=\"\"),\"\",VLOOKUP($G11,LLC_Stan_scores,6))","v":""},{"$f":"IF(OR($C11=\"\",$G11=\"\"),\"\",VLOOKUP($G11,LLC_Stan_scores,7))","v":""},{"$f":"IF(OR($C11=\"\",$G11=\"\"),\"\",VLOOKUP($G11,LLC_Stan_scores,9))","v":""},{"$f":"IF(OR($C11=\"\",$G11=\"\"),\"\",VLOOKUP($G11,LLC_Stan_scores,10))","v":""},{"$f":"IF(OR($C11=\"\",$C11<>\"Individual Carry\",$G11=\"\"),\"\",VLOOKUP($G11,LLC_Stan_scores,12))","v":""},{"$f":"IF(OR($C11=\"\",$C11<>\"Individual Carry\",$G11=\"\"),\"\",VLOOKUP($G11,LLC_Stan_scores,13))","v":""},{"$f":"IF(OR($C11=\"\",$C11<>\"Individual Carry\",$G11=\"\"),\"\",VLOOKUP($G11,LLC_Stan_scores,15))","v":""},{"$f":"IF(OR($C11=\"\",$C11<>\"Individual Carry\",$G11=\"\"),\"\",VLOOKUP($G11,LLC_Stan_scores,16))","v":""}]
[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,null,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,"Worst Case Colour/Score",{"$f":"IF(O14=\"\",\"\",IF(O14=1,\"AMBER\",IF(O14=2,\"RED\",\"GREEN\")))","v":""},{"$f":"IF(COUNT(O5:O13)=0, \"\",MAX(O5:O13))","v":""},{"$f":"IF(Q14=\"\",\"\",IF(Q14=1,\"AMBER\",IF(Q14=2,\"RED\",\"GREEN\")))","v":""},{"$f":"IF(COUNT(Q5:Q13)=0, \"\",MAX(Q5:Q13))","v":""},{"$f":"IF(S14=\"\",\"\",IF(S14=1,\"AMBER\",IF(S14=3,\"RED\",\"GREEN\")))","v":""},{"$f":"IF(COUNT(S5:S13)=0, \"\",MAX(S5:S13))","v":""},{"$f":"IF(U14=\"\",\"\",IF(U14=1,\"AMBER\",IF(U14=3,\"RED\",\"GREEN\")))","v":""},{"$f":"IF(COUNT(U5:U13)=0, \"\",MAX(U5:U13))","v":""},{"$f":"IF(W14=\"\",\"\",IF(W14=2,\"AMBER\",IF(W14=3,\"RED\",\"GREEN\")))","v":""},{"$f":"IF(COUNT(W5:W13)=0, \"\",MAX(W5:W13))","v":""}]
["Table above must be completed before ratings are entered below:",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N14<>\"\",LEFT(N14,1),\"\")","v":""},{"$f":"IF(O14<>\"\",LEFT(O14,1),\"\")","v":""},"","","","","","","",""]
["Lifting/Lowering/Carrying Risk factor",null,"Colour Band",null,null,null,null,null,"Numerical Score"]
["B2","Type","Lift/Lower",null,"Carry",null,"Team",null,"Lift/Lower","Carry","Team",null,null,"Score table",null,null,null,"Colour","Lift/Lower","Carry","Team",null,"Index Table",null,null,null,"Colour Code Table (GREEN = 1, AMBER = 2, RED = 3)"]
["Active check:",null,{"$f":"COUNTIF(LLC_Type_Range,'Look-ups'!A3)","v":0},null,{"$f":"COUNTIF(LLC_Type_Range,'Look-ups'!A4)","v":0},null,{"$f":"COUNTIF(LLC_Type_Range,'Look-ups'!A5)","v":0},null,{"$f":"C18","v":0},{"$f":"E18","v":0},{"$f":"G18","v":0},null,null,"Lift/Lower","Carry","Team",null,"MAX",null,null,null,null,"Lift/Lower","Carry","Team",null,"Lift/Lower","Carry","Team"]
["Load weight and lift/carry frequency","WGT",null,null,null,null,null,null,{"$f":"IF(OR($C19=\"\",$C19=\"N/A\"),\"\",N19)","v":""},{"$f":"IF(OR($E19=\"\",$E19=\"N/A\"),\"\",O19)","v":""},{"$f":"IF(OR($G19=\"\",$G19=\"N/A\"),\"\",P19)","v":""},null,null,{"$f":"IF(OR($C19=\"\",$C19=\"N/A\"),\"\",VLOOKUP(W19,LLC_Scores,MATCH(C19,LLC_Score_col,0),0))","v":""},{"$f":"IF(OR($E19=\"\",$E19=\"N/A\"),\"\",VLOOKUP(X19,LLC_Scores,MATCH(E19,LLC_Score_col,0),0))","v":""},{"$f":"IF(OR($G19=\"\",$G19=\"N/A\"),\"\",VLOOKUP(Y19,LLC_Scores,MATCH(G19,LLC_Score_col,0),0))","v":""},null,"WGT",{"$f":"IF(N19=\"\",\"\",N19)","v":""},{"$f":"IF(O19=\"\",\"\",O19)","v":""},"",null,1,12,23]
["Hand distance from the lower back","T&L",null,null,null,null,null,null,"",{"$f":"IF(OR($E20=\"\",$E20=\"N/A\"),\"\",O20)","v":""},{"$f":"IF(OR($G20=\"\",$G20=\"N/A\"),\"\",P20)","v":""},null,null,"",{"$f":"IF(OR($E20=\"\",$E20=\"N/A\"),\"\",VLOOKUP(X20,LLC_Scores,MATCH(E20,LLC_Score_col,0),0))","v":""},"",null,"T&L",{"$f":"IF(AND(N20=\"\",N21=\"\",N22=\"\",N24=\"\",N29=\"\"),\"\",MAX(N20,N21,N22,N24,N29))","v":""},{"$f":"IF(AND(O20=\"\",O21=\"\",O22=\"\",O24=\"\",O29=\"\"),\"\",MAX(O20,O21,O22,O24,O29))","v":""},"",null,2,13,24,null,{"$f":"IF(OR(C20=\"\",C20=\"N/A\"),\"\",VLOOKUP(C20,Col_Index,2))","v":""},{"$f":"IF(OR(E20=\"\",E20=\"N/A\"),\"\",VLOOKUP(E20,Col_Index,2))","v":""},{"$f":"IF(OR(G20=\"\",G20=\"N/A\"),\"\",VLOOKUP(G20,Col_Index,2))","v":""}]
["Vertical lift region","T&L",null,null,"N/A",null,null,null,"","N/A","",null,null,"",null,"",null,"ENV",{"$f":"IF(AND(N23=\"\",N25=\"\",N28=\"\"),\"\",MAX(N23,N25:N28))","v":""},{"$f":"IF(AND(O23=\"\",O25=\"\",O28=\"\"),\"\",MAX(O23,O25:O28))","v":""},"",null,3,14,25,null,"","",""]
["Assymetrical torso/load\nTorso twisting/sideways bending (carrying)","T&L",null,null,null,null,null,null,"",{"$f":"IF(OR($E22=\"\",$E22=\"N/A\"),\"\",O22)","v":""},"",null,null,"",{"$f":"IF(OR($E22=\"\",$E22=\"N/A\"),\"\",VLOOKUP(X22,LLC_Scores,MATCH(E22,LLC_Score_col,0),0))","v":""},"",null,"Highest colour code",null,null,null,null,4,15,26,null,"","",""]
["Postural Constraints","ENV",{"$f":"IF(C$18=0,\"\",$R$14)","v":""},{"$f":"IF(C$18=0,\"\",$R$15)","v":""},{"$f":"IF(E$18=0,\"\",$R$14)","v":""},{"$f":"IF(E$18=0,\"\",$R$15)","v":""},{"$f":"IF(G$18=0,\"\",$R$14)","v":""},{"$f":"IF(G$18=0,\"\",$R$15)","v":""},"","","",null,null,"","","",null,"Colour","Lift/Lower","Carry","Team",null,5,16,27,null,"","",""]
["Grip on the load","T&L",null,null,null,null,null,null,"","","",null,null,"","","",null,"WGT",null,null,null,null,6,17,28,null,"","",""]
["Floor Surface","ENV",{"$f":"IF(C$18=0,\"\",$N$14)","v":""},{"$f":"IF(C$18=0,\"\",$N$15)","v":""},{"$f":"IF(E$18=0,\"\",$N$14)","v":""},{"$f":"IF(E$18=0,\"\",$N$15)","v":""},{"$f":"IF(G$18=0,\"\",$N$14)","v":""},{"$f":"IF(G$18=0,\"\",$N$15)","v":""},"","","",null,null,"","","",null,"T&L",{"$f":"IF(MAX(AA20,AA21,AA22,AA24,AA29)=0,\"\",MAX(AA20,AA21,AA22,AA24,AA29))","v":""},{"$f":"IF(MAX(AB20,AB21,AB22,AB24,AB29)=0,\"\",MAX(AB20,AB21,AB22,AB24,AB29))","v":""},"",null,7,18,29,null,"","",""]
["Other environmental factors","ENV",{"$f":"IF(C$18=0,\"\",$P$14)","v":""},{"$f":"IF(C$18=0,\"\",$P$15)","v":""},{"$f":"IF(E$18=0,\"\",$P$14)","v":""},{"$f":"IF(E$18=0,\"\",$P$15)","v":""},{"$f":"IF(G$18=0,\"\",$P$14)","v":""},{"$f":"IF(G$18=0,\"\",$P$15)","v":""},"","","",null,null,"","","",null,"ENV",{"$f":"IF(MAX(AA23,AA25,AA26,AA27,AA28)=0,\"\",MAX(AA23,AA25,AA26,AA27,AA28))","v":""},{"$f":"IF(MAX(AB23,AB25,AB26,AB27,AB28)=0,\"\",MAX(AB23,AB25,AB26,AB27,AB28))","v":""},"",null,8,19,30,null,"","",""]
["Carry distance","ENV","N/A",null,{"$f":"IF(C$18=0,\"\",$T$14)","v":""},{"$f":"IF(C$18=0,\"\",$T$15)","v":""},"N/A",null,"N/A","","N/A",null,null,null,"",null,null,"Highest Colour",null,null,null,null,9,20,31,null,"","",""]
["Obstacles en route","ENV","N/A",null,{"$f":"IF(C$18=0,\"\",$V$14)","v":""},{"$f":"IF(C$18=0,\"\",$V$15)","v":""},"N/A",null,"N/A","","N/A",null,null,null,"",null,null,"Colour","Lift/Lower","Carry","Team",null,10,21,32,null,"","",""]
["Communication and co-ordination","T&L","N/A",null,"N/A",null,null,null,"N/A","N/A",{"$f":"IF(OR($G29=\"\",$G29=\"N/A\"),\"\",P29)","v":""},null,null,null,null,{"$f":"IF(OR($G29=\"\",$G29=\"N/A\"),\"\",VLOOKUP(Y29,LLC_Scores,MATCH(G29,LLC_Score_col,0),0))","v":""},null,"WGT",{"$f":"IF(S19=\"\",\"\",C19)","v":""},{"$f":"IF(T19=\"\",\"\",E19)","v":""},{"$f":"IF(U19=\"\",\"\",G19)","v":""},null,11,22,33,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T&L",{"$f":"IF(S25=\"\",\"\",VLOOKUP(S25,Col_Lookup,2))","v":""},{"$f":"IF(T25=\"\",\"\",VLOOKUP(T25,Col_Lookup,2))","v":""},""]
["Comments on Lift/Lower/Carry Tasks","B3","Use ALT-RTN to start new line",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ENV","","",""]
[]
[]
["SUMMARY RESULTS",null,"Individual Lifting/Lowering",null,null,null,"Individual\nCarrying",null,null,"Team\nLifting/Lowering/ Carrying"]
["B4","Type"]
["Load Weight Risk","WGT",{"$f":"IF(LLC_L_Active=0,\"N/A\",S29)","v":"N/A"},null,null,null,{"$f":"IF(LLC_C_Active=0,\"N/A\",T29)","v":"N/A"},null,null,{"$f":"IF(LLC_T_Active=0,\"N/A\",U29)","v":"N/A"}]
["Load Design and Task Risk","T&L",{"$f":"IF(LLC_L_Active=0,\"N/A\",S30)","v":"N/A"},null,null,null,{"$f":"IF(LLC_C_Active=0,\"N/A\",T30)","v":"N/A"},null,null,{"$f":"IF(LLC_T_Active=0,\"N/A\",U30)","v":"N/A"}]
["Location and Environment Risk","ENV",{"$f":"IF(LLC_L_Active=0,\"N/A\",S31)","v":"N/A"},null,null,null,{"$f":"IF(LLC_C_Active=0,\"N/A\",T31)","v":"N/A"},null,null,{"$f":"IF(LLC_T_Active=0,\"N/A\",U31)","v":"N/A"}]
["Total Risk Score: ",null,{"$f":"IF(LLC_L_Active=0,\"N/A\",SUM(I19:I29))","v":"N/A"},null,null,null,{"$f":"IF(LLC_C_Active=0,\"N/A\",SUM(J19:J29))","v":"N/A"},null,null,{"$f":"IF(LLC_T_Active=0,\"N/A\",SUM(K19:K29))","v":"N/A"}]

{"sheet":"B- Formulae","index":2,"n_rows":30,"n_cols":23,"rows_kept":30,"cut":false,"hidden":true,"merged":[[12,8,12,10],[14,13,14,22],[15,8,15,10],[9,8,9,10],[10,2,10,6],[10,8,10,10],[11,2,11,6],[11,8,11,10],[6,8,6,10],[7,2,7,6],[7,8,7,10],[8,2,8,6],[8,8,8,10],[2,17,2,18],[2,19,2,20],[2,21,2,22],[4,2,4,6],[4,8,4,10],[2,13,2,14],[2,15,2,16],[5,8,5,10],[0,0,0,10],[2,0,3,0],[2,2,3,6],[2,8,3,10],[16,2,16,3],[16,4,16,5],[16,6,16,7],[15,2,15,7],[5,2,5,6],[6,2,6,6],[9,2,9,6],[12,2,12,6]]}
["PART B -  LIFTING/LOWERING/CARRYING TASK STEPS - RISK ASSESSMENT"]
[]
["Description of Task Step",null,"Type of manual handling activity",null,null,null,null,null,"Standard location type \n",null,null,null,null,"Floor surface",null,"Environmental factors",null,"Postural Constraints",null,"Carry distance",null,"Obstacles en Route"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Colour","Score","Colour","Score","Colour","Score","Colour","Score","Colour","Score"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR($C5=\"\",$I5=\"\"),\"\",VLOOKUP($I5,LLC_Stan_scores,3))","v":""},{"$f":"IF(OR($C5=\"\",$I5=\"\"),\"\",VLOOKUP($I5,LLC_Stan_scores,4))","v":""},{"$f":"IF(OR($C5=\"\",$I5=\"\"),\"\",VLOOKUP($I5,LLC_Stan_scores,6))","v":""},{"$f":"IF(OR($C5=\"\",$I5=\"\"),\"\",VLOOKUP($I5,LLC_Stan_scores,7))","v":""},{"$f":"IF(OR($C5=\"\",$I5=\"\"),\"\",VLOOKUP($I5,LLC_Stan_scores,9))","v":""},{"$f":"IF(OR($C5=\"\",$I5=\"\"),\"\",VLOOKUP($I5,LLC_Stan_scores,10))","v":""},{"$f":"IF(OR($C5=\"\",$C5<>\"Individual Carry\",$I5=\"\"),\"\",VLOOKUP($I5,LLC_Stan_scores,12))","v":""},{"$f":"IF(OR($C5=\"\",$C5<>\"Individual Carry\",$I5=\"\"),\"\",VLOOKUP($I5,LLC_Stan_scores,13))","v":""},{"$f":"IF(OR($C5=\"\",$C5<>\"Individual Carry\",$I5=\"\"),\"\",VLOOKUP($I5,LLC_Stan_scores,15))","v":""},{"$f":"IF(OR($C5=\"\",$C5<>\"Individual Carry\",$I5=\"\"),\"\",VLOOKUP($I5,LLC_Stan_scores,16))","v":""}]
[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,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,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,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,null,null,null,null,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(O14=\"\",\"\",IF(O14=1,\"AMBER\",IF(O14=2,\"RED\",\"GREEN\")))","v":""},{"$f":"IF(COUNT(O5:O13)=0, \"\",MAX(O5:O13))","v":""},{"$f":"IF(Q14=\"\",\"\",IF(Q14=1,\"AMBER\",IF(Q14=2,\"RED\",\"GREEN\")))","v":""},{"$f":"IF(COUNT(Q5:Q13)=0, \"\",MAX(Q5:Q13))","v":""},{"$f":"IF(S14=\"\",\"\",IF(S14=1,\"AMBER\",IF(S14=3,\"RED\",\"GREEN\")))","v":""},{"$f":"IF(COUNT(S5:S13)=0, \"\",MAX(S5:S13))","v":""},{"$f":"IF(U14=\"\",\"\",IF(U14=1,\"AMBER\",IF(U14=3,\"RED\",\"GREEN\")))","v":""},{"$f":"IF(COUNT(U5:U13)=0, \"\",MAX(U5:U13))","v":""},{"$f":"IF(W14=\"\",\"\",IF(W14=2,\"AMBER\",IF(W14=3,\"RED\",\"GREEN\")))","v":""},{"$f":"IF(COUNT(W5:W13)=0, \"\",MAX(W5:W13))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Worst Case Colour/Score"]
["Lifting/Lowering/Carrying Risk factor",null,"Colour Band",null,null,null,null,null,"Numerical Score"]
[null,"Type","Lift/Lower",null,"Carry",null,"Team",null,"Lift/Lower","Carry","Team"]
["Active check:",null,{"$f":"COUNTIF(LLC_Type_Range,'Look-ups'!A3)","v":0},null,{"$f":"COUNTIF(LLC_Type_Range,'Look-ups'!A4)","v":0},null,{"$f":"COUNTIF(LLC_Type_Range,'Look-ups'!A5)","v":0},null,{"$f":"C18","v":0},{"$f":"E18","v":0},{"$f":"G18","v":0}]
["Load weight and lift/carry frequency","WGT",null,null,null,null,null,null,{"$f":"IF(OR($C19=\"\",$C19=\"N/A\"),\"\",N19)","v":""},{"$f":"IF(OR($E19=\"\",$E19=\"N/A\"),\"\",O19)","v":""},{"$f":"IF(OR($G19=\"\",$G19=\"N/A\"),\"\",P19)","v":""}]
["Hand distance from the lower back","T&L",null,null,null,null,null,null,"",{"$f":"IF(OR($E20=\"\",$E20=\"N/A\"),\"\",O20)","v":""},{"$f":"IF(OR($G20=\"\",$G20=\"N/A\"),\"\",P20)","v":""}]
["Vertical lift region","T&L",null,null,"N/A",null,null,null,"","N/A",""]
["Assymetrical torso/load\nTorso twisting/sideways bending (carrying)","T&L",null,null,null,null,null,null,"",{"$f":"IF(OR($E22=\"\",$E22=\"N/A\"),\"\",O22)","v":""},""]
["Postural Constraints","ENV",{"$f":"IF(C$18=0,\"\",$R$14)","v":""},{"$f":"IF(C$18=0,\"\",$R$15)","v":""},{"$f":"IF(E$18=0,\"\",$R$14)","v":""},{"$f":"IF(E$18=0,\"\",$R$15)","v":""},{"$f":"IF(G$18=0,\"\",$R$14)","v":""},{"$f":"IF(G$18=0,\"\",$R$15)","v":""},"","",""]
["Grip on the load","T&L",null,null,null,null,null,null,"","",""]
["Floor Surface","ENV",{"$f":"IF(C$18=0,\"\",$N$14)","v":""},{"$f":"IF(C$18=0,\"\",$N$15)","v":""},{"$f":"IF(E$18=0,\"\",$N$14)","v":""},{"$f":"IF(E$18=0,\"\",$N$15)","v":""},{"$f":"IF(G$18=0,\"\",$N$14)","v":""},{"$f":"IF(G$18=0,\"\",$N$15)","v":""},"","",""]
["Other environmental factors","ENV",{"$f":"IF(C$18=0,\"\",$P$14)","v":""},{"$f":"IF(C$18=0,\"\",$P$15)","v":""},{"$f":"IF(E$18=0,\"\",$P$14)","v":""},{"$f":"IF(E$18=0,\"\",$P$15)","v":""},{"$f":"IF(G$18=0,\"\",$P$14)","v":""},{"$f":"IF(G$18=0,\"\",$P$15)","v":""},"","",""]
["Carry distance","ENV","N/A",null,{"$f":"IF(C$18=0,\"\",$T$14)","v":""},{"$f":"IF(C$18=0,\"\",$T$15)","v":""},"N/A",null,"N/A","","N/A"]
["Obstacles en route","ENV","N/A",null,{"$f":"IF(C$18=0,\"\",$V$14)","v":""},{"$f":"IF(C$18=0,\"\",$V$15)","v":""},"N/A",null,"N/A","","N/A"]
["Communication and co-ordination","T&L","N/A",null,"N/A",null,null,null,"N/A","N/A",{"$f":"IF(OR($G29=\"\",$G29=\"N/A\"),\"\",P29)","v":""}]
[null,null,null,null,null,null,"Total Score:",null,{"$f":"IF(I18=0,\"\",SUM(I19:I29))","v":""},{"$f":"IF(J18=0,\"\",SUM(J19:J29))","v":""},{"$f":"IF(K18=0,\"\",SUM(K19:K29))","v":""}]

{"sheet":"C>RAPP Pushing-Pulling","index":3,"n_rows":46,"n_cols":35,"rows_kept":46,"cut":false,"hidden":false,"merged":[[26,13,26,14],[12,20,12,21],[45,7,45,8],[40,7,40,10],[4,0,4,1],[40,2,40,6],[41,7,41,8],[42,7,42,8],[43,7,43,8],[44,7,44,8],[43,2,43,3],[44,2,44,3],[45,2,45,3],[41,4,41,5],[42,4,42,5],[43,4,43,5],[44,4,44,5],[45,4,45,5],[41,2,41,3],[42,2,42,3],[7,0,7,1],[8,0,8,1],[9,0,9,1],[38,0,38,10],[12,8,12,10],[25,8,25,10],[37,2,37,10],[25,0,25,1],[13,2,13,3],[13,4,13,5],[13,6,13,7],[12,2,12,7],[25,2,25,7],[26,2,26,3],[0,0,0,10],[5,0,5,1],[6,0,6,1],[8,6,8,10],[2,0,2,1],[2,2,2,5],[2,6,2,10],[3,6,3,10],[4,6,4,10],[5,6,5,10],[6,6,6,10],[26,4,26,5],[26,6,26,7],[3,2,3,5],[2,13,2,14],[2,15,2,16],[2,19,2,20],[2,21,2,22],[2,17,2,18],[9,2,9,5],[7,6,7,10],[9,6,9,10],[4,2,4,5],[5,2,5,5],[6,2,6,5],[7,2,7,5],[8,2,8,5]]}
["PART C - HSE RAPP - PUSHING/PULLING TASK STEPS - RISK ASSESSMENT"]
[]
["Description of Task Step",null,"Type of manual",null,null,null,"Standard location type ",null,null,null,null,null,null,"Floor surface",null,"Other factors *",null,"Travel Distance \n(Wheeled)",null,"Travel Distance \n(No wheels)",null,"Obstacles en Route "]
[null,"C1.1","  handling activity C1.2",null,null,null,"C1.3",null,null,null,null,null,null,"Colour","Score","Colour","Score","Colour","Score","Colour","Score","Colour","Score"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR($C5=\"\",$G5=\"\"),\"\",VLOOKUP($G5,PP_Stan_scores,3))","v":""},{"$f":"IF(OR($C5=\"\",$G5=\"\"),\"\",VLOOKUP($G5,PP_Stan_scores,4))","v":""},{"$f":"IF(OR($C5=\"\",$G5=\"\"),\"\",VLOOKUP($G5,PP_Stan_scores,6))","v":""},{"$f":"IF(OR($C5=\"\",$G5=\"\"),\"\",VLOOKUP($G5,PP_Stan_scores,7))","v":""},{"$f":"IF(OR($C5=\"\",$G5=\"\"),\"\",VLOOKUP($G5,PP_Stan_scores,9))","v":""},{"$f":"IF(OR($C5=\"\",$G5=\"\"),\"\",VLOOKUP($G5,PP_Stan_scores,10))","v":""},{"$f":"IF(OR($C5=\"\",$G5=\"\"),\"\",VLOOKUP($G5,PP_Stan_scores,12))","v":""},{"$f":"IF(OR($C5=\"\",$G5=\"\"),\"\",VLOOKUP($G5,PP_Stan_scores,13))","v":""},{"$f":"IF(OR($C5=\"\",$G5=\"\"),\"\",VLOOKUP($G5,PP_Stan_scores,15))","v":""},{"$f":"IF(OR($C5=\"\",$G5=\"\"),\"\",VLOOKUP($G5,PP_Stan_scores,16))","v":""}]
[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,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,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,null,null,null,{"$f":"IF(O11=\"\",\"\",IF(O11=1,\"AMBER\",IF(O11=4,\"RED\",\"GREEN\")))","v":""},{"$f":"IF(COUNT(O5:O10)=0, \"\",MAX(O5:O10))","v":""},{"$f":"IF(Q11=\"\",\"\",IF(Q11=1,\"AMBER\",IF(Q11=2,\"RED\",\"GREEN\")))","v":""},{"$f":"IF(COUNT(Q5:Q10)=0, \"\",MAX(Q5:Q10))","v":""},{"$f":"IF(S11=\"\",\"\",IF(S11=1,\"AMBER\",IF(S11=3,\"RED\",\"GREEN\")))","v":""},{"$f":"IF(COUNT(S5:S10)=0, \"\",MAX(S5:S10))","v":""},{"$f":"IF(U11=\"\",\"\",IF(U11=1,\"AMBER\",IF(U11=3,\"RED\",\"GREEN\")))","v":""},{"$f":"IF(COUNT(U5:U10)=0, \"\",MAX(U5:U10))","v":""},{"$f":"IF(W11=\"\",\"\",IF(W11=2,\"AMBER\",IF(W11=3,\"RED\",\"GREEN\")))","v":""},{"$f":"IF(COUNT(W5:W10)=0, \"\",MAX(W5:W10))","v":""}]
["Table above must be completed before ratings are entered below:",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N11<>\"\",LEFT(N11,1),\"\")","v":""},null,{"$f":"IF(P11<>\"\",LEFT(P11,1),\"\")","v":""},null,{"$f":"IF(R11<>\"\",LEFT(R11,1),\"\")","v":""},null,{"$f":"IF(T11<>\"\",LEFT(T11,1),\"\")","v":""},null,{"$f":"IF(V11<>\"\",LEFT(V11,1),\"\")","v":""}]
["Wheeled Loads Risk Factors",null,"Colour Band",null,null,null,null,null,"Numerical Score",null,null,null,null,"Score table",null,null,null,null,null,null,"Index Table"]
["C2","Type","Small",null,"Medium",null,"Large",null,"Small","Medium","Large",null,null,"Small","Medium","Large","Rolling","Churning","Dragging",null,"Small","Medium","Large","Rolling","Churning","Dragging"]
["Active check:",null,{"$f":"COUNTIF(PP_Type_Range,'Look-ups'!A8)","v":0},1,{"$f":"COUNTIF(PP_Type_Range,'Look-ups'!A9)","v":0},1,{"$f":"COUNTIF(PP_Type_Range,'Look-ups'!A10)","v":0},null,{"$f":"C15","v":0},{"$f":"E15","v":0},{"$f":"G15","v":0}]
["Load weight","WGT",null,null,null,null,null,null,{"$f":"IF(OR($C16=\"\",$C16=\"N/A\"),\"\",N16)","v":""},{"$f":"IF(OR($E16=\"\",$E16=\"N/A\"),\"\",O16)","v":""},{"$f":"IF(OR($G16=\"\",$G16=\"N/A\"),\"\",P16)","v":""},null,null,{"$f":"IF(OR($C16=\"\",$C16=\"N/A\"),\"\",VLOOKUP(U16,PP_Scores,MATCH(C16,PP_Score_col,0),0))","v":""},{"$f":"IF(OR($E16=\"\",$E16=\"N/A\"),\"\",VLOOKUP(V16,PP_Scores,MATCH($E16,PP_Score_col,0),0))","v":""},{"$f":"IF(OR($G16=\"\",$G16=\"N/A\"),\"\",VLOOKUP(W16,PP_Scores,MATCH($G16,PP_Score_col,0),0))","v":""},{"$f":"IF(OR($C29=\"\",$C29=\"N/A\"),\"\",VLOOKUP(X16,PP_Scores,MATCH($C29,PP_Score_col,0),0))","v":""},{"$f":"IF(OR($E29=\"\",$E29=\"N/A\"),\"\",VLOOKUP(Y16,PP_Scores,MATCH($E29,PP_Score_col,0),0))","v":""},{"$f":"IF(OR($G29=\"\",$G29=\"N/A\"),\"\",VLOOKUP(Z16,PP_Scores,MATCH($G29,PP_Score_col,0),0))","v":""},null,1,10,19,28,36,44]
["Posture","T&L",null,null,null,null,null,null,{"$f":"IF(OR($C17=\"\",$C17=\"N/A\"),\"\",N17)","v":""},{"$f":"IF(OR($E17=\"\",$E17=\"N/A\"),\"\",O17)","v":""},{"$f":"IF(OR($G17=\"\",$G17=\"N/A\"),\"\",P17)","v":""},null,null,"",{"$f":"IF(OR($E17=\"\",$E17=\"N/A\"),\"\",VLOOKUP(V17,PP_Scores,MATCH($E17,PP_Score_col,0),0))","v":""},"",{"$f":"IF(OR($C30=\"\",$C30=\"N/A\"),\"\",VLOOKUP(X17,PP_Scores,MATCH($C30,PP_Score_col,0),0))","v":""},{"$f":"IF(OR($E30=\"\",$E30=\"N/A\"),\"\",VLOOKUP(Y17,PP_Scores,MATCH($E30,PP_Score_col,0),0))","v":""},{"$f":"IF(OR($G30=\"\",$G30=\"N/A\"),\"\",VLOOKUP(Z17,PP_Scores,MATCH($G30,PP_Score_col,0),0))","v":""},null,2,11,20,29,37,45]
["Hand grip","T&L",null,null,null,null,null,null,"","","",null,null,"","","",{"$f":"IF(OR($C31=\"\",$C31=\"N/A\"),\"\",VLOOKUP(X18,PP_Scores,MATCH($C31,PP_Score_col,0),0))","v":""},{"$f":"IF(OR($E31=\"\",$E31=\"N/A\"),\"\",VLOOKUP(Y18,PP_Scores,MATCH($E31,PP_Score_col,0),0))","v":""},{"$f":"IF(OR($G31=\"\",$G31=\"N/A\"),\"\",VLOOKUP(Z18,PP_Scores,MATCH($G31,PP_Score_col,0),0))","v":""},null,3,12,21,30,38,46]
["Work pattern","T&L",null,null,null,null,null,null,"","","",null,null,"","","",{"$f":"IF(OR($C32=\"\",$C32=\"N/A\"),\"\",VLOOKUP(X19,PP_Scores,MATCH($C32,PP_Score_col,0),0))","v":""},{"$f":"IF(OR($E32=\"\",$E32=\"N/A\"),\"\",VLOOKUP(Y19,PP_Scores,MATCH($E32,PP_Score_col,0),0))","v":""},{"$f":"IF(OR($G32=\"\",$G32=\"N/A\"),\"\",VLOOKUP(Z19,PP_Scores,MATCH($G32,PP_Score_col,0),0))","v":""},null,4,13,22,31,39,47]
["Travel distance","ENV",{"$f":"IF(C$15=0,\"\",$R$11)","v":""},{"$f":"IF(C$15=0,\"\",$R$12)","v":""},{"$f":"IF(E$15=0,\"\",$R$11)","v":""},{"$f":"IF(E$15=0,\"\",$R$12)","v":""},{"$f":"IF(G$15=0,\"\",$R$11)","v":""},{"$f":"IF(G$15=0,\"\",$R$12)","v":""},"","","",null,null,"","","",{"$f":"IF(OR($C33=\"\",$C33=\"N/A\"),\"\",VLOOKUP(X20,PP_Scores,MATCH($C33,PP_Score_col,0),0))","v":""},{"$f":"IF(OR($E33=\"\",$E33=\"N/A\"),\"\",VLOOKUP(Y20,PP_Scores,MATCH($E33,PP_Score_col,0),0))","v":""},{"$f":"IF(OR($G33=\"\",$G33=\"N/A\"),\"\",VLOOKUP(Z20,PP_Scores,MATCH($G33,PP_Score_col,0),0))","v":""},null,5,14,23,32,40,48]
["Condition of equipment","T&L",null,null,null,null,null,null,"","","",null,null,"","","",null,null,null,null,6,15,24]
["Floor surface","ENV",{"$f":"IF(C$15=0,\"\",$N$11)","v":""},{"$f":"IF(C$15=0,\"\",$N$12)","v":""},{"$f":"IF(E$15=0,\"\",$N$11)","v":""},{"$f":"IF(E$15=0,\"\",$N$12)","v":""},{"$f":"IF(G$15=0,\"\",$N$11)","v":""},{"$f":"IF(G$15=0,\"\",$N$12)","v":""},"","","",null,null,"","","",{"$f":"IF(OR($C34=\"\",$C34=\"N/A\"),\"\",VLOOKUP(X22,PP_Scores,MATCH($C34,PP_Score_col,0),0))","v":""},{"$f":"IF(OR($E34=\"\",$E34=\"N/A\"),\"\",VLOOKUP(Y22,PP_Scores,MATCH($E34,PP_Score_col,0),0))","v":""},{"$f":"IF(OR($G34=\"\",$G34=\"N/A\"),\"\",VLOOKUP(Z22,PP_Scores,MATCH($G34,PP_Score_col,0),0))","v":""},null,7,16,25,33,41,49]
["Obstacles en route","ENV",{"$f":"IF(C$15=0,\"\",$V$11)","v":""},{"$f":"IF(C$15=0,\"\",$V$12)","v":""},{"$f":"IF(E$15=0,\"\",$V$11)","v":""},{"$f":"IF(E$15=0,\"\",$V$12)","v":""},{"$f":"IF(G$15=0,\"\",$V$11)","v":""},{"$f":"IF(G$15=0,\"\",$V$12)","v":""},"","","",null,null,"","","",{"$f":"IF(OR($C35=\"\",$C35=\"N/A\"),\"\",VLOOKUP(X23,PP_Scores,MATCH($C35,PP_Score_col,0),0))","v":""},{"$f":"IF(OR($E35=\"\",$E35=\"N/A\"),\"\",VLOOKUP(Y23,PP_Scores,MATCH($E35,PP_Score_col,0),0))","v":""},{"$f":"IF(OR($G35=\"\",$G35=\"N/A\"),\"\",VLOOKUP(Z23,PP_Scores,MATCH($G35,PP_Score_col,0),0))","v":""},null,8,17,26,34,42,50]
["Other factors","ENV",{"$f":"IF(C$15=0,\"\",$P$11)","v":""},{"$f":"IF(C$15=0,\"\",$P$12)","v":""},{"$f":"IF(E$15=0,\"\",$P$11)","v":""},{"$f":"IF(E$15=0,\"\",$P$12)","v":""},{"$f":"IF(G$15=0,\"\",$P$11)","v":""},{"$f":"IF(G$15=0,\"\",$P$12)","v":""},"","","",null,null,"","","",{"$f":"IF(OR($C36=\"\",$C36=\"N/A\"),\"\",VLOOKUP(X24,PP_Scores,MATCH($C36,PP_Score_col,0),0))","v":""},{"$f":"IF(OR($E36=\"\",$E36=\"N/A\"),\"\",VLOOKUP(Y24,PP_Scores,MATCH($E36,PP_Score_col,0),0))","v":""},{"$f":"IF(OR($G36=\"\",$G36=\"N/A\"),\"\",VLOOKUP(Z24,PP_Scores,MATCH($G36,PP_Score_col,0),0))","v":""},null,9,18,27,35,43,51]
[]
["Loads Pushed/Pulled not on Wheels Risk Factors",null,"Colour Band",null,null,null,null,null,"Numerical Score",null,null,null,null,null,null,null,null,null,null,null,null,"Colour Code Table (GREEN = 1, AMBER = 2, RED = 3)"]
["C3","Type","Rolling",null,"Churning",null,"Dragging",null,"Rolling","Churning","Dragging",null,null,"Highest Score",null,null,null,null,null,null,null,"Small","Medium","Large","Rolling","Churning","Dragging"]
["Active check:",null,{"$f":"COUNTIF(PP_Type_Range,'Look-ups'!A11)","v":0},1,{"$f":"COUNTIF(PP_Type_Range,'Look-ups'!A12)","v":0},1,{"$f":"COUNTIF(PP_Type_Range,'Look-ups'!A13)","v":0},null,{"$f":"C28","v":0},{"$f":"E28","v":0},{"$f":"G28","v":0}]
["Load weight","WGT",null,null,null,null,null,null,{"$f":"IF(OR($C29=\"\",$C29=\"N/A\"),\"\",Q16)","v":""},{"$f":"IF(OR($E29=\"\",$E29=\"N/A\"),\"\",R16)","v":""},{"$f":"IF(OR($G29=\"\",$G29=\"N/A\"),\"\",S16)","v":""},null,null,"MAX","Small","Medium","Large","Rolling","Churning","Dragging",null,null,null,null,null,null,null,null,"Highest colour code"]
["Posture","T&L",null,null,null,null,null,null,{"$f":"IF(OR($C30=\"\",$C30=\"N/A\"),\"\",Q17)","v":""},"",{"$f":"IF(OR($G30=\"\",$G30=\"N/A\"),\"\",S17)","v":""},null,null,"WGT",null,null,null,null,null,null,null,{"$f":"IF(OR(C17=\"\",C17=\"N/A\"),\"\",VLOOKUP(C17,Col_Index,2))","v":""},{"$f":"IF(OR(E17=\"\",E17=\"N/A\"),\"\",VLOOKUP(E17,Col_Index,2))","v":""},{"$f":"IF(OR(G17=\"\",G17=\"N/A\"),\"\",VLOOKUP(G17,Col_Index,2))","v":""},{"$f":"IF(OR(C30=\"\",C30=\"N/A\"),\"\",VLOOKUP(C30,Col_Index,2))","v":""},{"$f":"IF(OR(E30=\"\",E30=\"N/A\"),\"\",VLOOKUP(E30,Col_Index,2))","v":""},{"$f":"IF(OR(G30=\"\",G30=\"N/A\"),\"\",VLOOKUP(G30,Col_Index,2))","v":""},null,"Colour","Small","Medium","Large","Rolling","Churning","Dragging"]
["Hand grip","T&L",null,null,null,null,null,null,{"$f":"IF(OR($C31=\"\",$C31=\"N/A\"),\"\",Q18)","v":""},"",{"$f":"IF(OR($G31=\"\",$G31=\"N/A\"),\"\",S18)","v":""},null,null,"T&L",{"$f":"MAX(N17,N18,N19,N21)","v":0},{"$f":"MAX(O17,O18,O19,O21)","v":0},{"$f":"MAX(P17,P18,P19,P21)","v":0},{"$f":"MAX(Q17,Q18,Q19)","v":0},{"$f":"MAX(R17,R18,R19)","v":0},{"$f":"MAX(S17,S18,S19)","v":0},null,"","","",{"$f":"IF(OR(C31=\"\",C31=\"N/A\"),\"\",VLOOKUP(C31,Col_Index,2))","v":""},{"$f":"IF(OR(E31=\"\",E31=\"N/A\"),\"\",VLOOKUP(E31,Col_Index,2))","v":""},{"$f":"IF(OR(G31=\"\",G31=\"N/A\"),\"\",VLOOKUP(G31,Col_Index,2))","v":""},null,"WGT"]
["Work pattern","T&L",null,null,null,null,null,null,{"$f":"IF(OR($C32=\"\",$C32=\"N/A\"),\"\",Q19)","v":""},"",{"$f":"IF(OR($G32=\"\",$G32=\"N/A\"),\"\",S19)","v":""},null,null,"ENV",{"$f":"MAX(N20,N22:N24)","v":0},0,0,0,0,0,null,"","","",{"$f":"IF(OR(C32=\"\",C32=\"N/A\"),\"\",VLOOKUP(C32,Col_Index,2))","v":""},{"$f":"IF(OR(E32=\"\",E32=\"N/A\"),\"\",VLOOKUP(E32,Col_Index,2))","v":""},{"$f":"IF(OR(G32=\"\",G32=\"N/A\"),\"\",VLOOKUP(G32,Col_Index,2))","v":""},null,"T&L",{"$f":"IF(MAX(V30,V31,V32,V34)=0,\"\",MAX(V30,V31,V32,V34))","v":""},{"$f":"IF(MAX(W30,W31,W32,W34)=0,\"\",MAX(W30,W31,W32,W34))","v":""},"",{"$f":"IF(MAX(Y30,Y31,Y32,Y34)=0,\"\",MAX(Y30,Y31,Y32,Y34))","v":""},{"$f":"IF(MAX(Z30,Z31,Z32,Z34)=0,\"\",MAX(Z30,Z31,Z32,Z34))","v":""},{"$f":"IF(MAX(AA30,AA31,AA32,AA34)=0,\"\",MAX(AA30,AA31,AA32,AA34))","v":""}]
["Travel distance","ENV",{"$f":"IF(C$28=0,\"\",$T$11)","v":""},{"$f":"IF(C$28=0,\"\",$T$12)","v":""},{"$f":"IF(E$28=0,\"\",$T$11)","v":""},{"$f":"IF(E$28=0,\"\",$T$12)","v":""},{"$f":"IF(G$28=0,\"\",$T$11)","v":""},{"$f":"IF(G$28=0,\"\",$T$12)","v":""},{"$f":"IF(OR($C33=\"\",$C33=\"N/A\"),\"\",Q20)","v":""},"",{"$f":"IF(OR($G33=\"\",$G33=\"N/A\"),\"\",S20)","v":""},null,null,"Highest Colour",null,null,null,null,null,null,null,"","","",{"$f":"IF(OR(C33=\"\",C33=\"N/A\"),\"\",VLOOKUP(C33,Col_Index,2))","v":""},{"$f":"IF(OR(E33=\"\",E33=\"N/A\"),\"\",VLOOKUP(E33,Col_Index,2))","v":""},{"$f":"IF(OR(G33=\"\",G33=\"N/A\"),\"\",VLOOKUP(G33,Col_Index,2))","v":""},null,"ENV",{"$f":"IF(MAX(V33,V35,V36,V37)=0,\"\",MAX(V33,V35,V36,V37))","v":""},{"$f":"IF(MAX(W33,W35,W36,W37)=0,\"\",MAX(W33,W35,W36,W37))","v":""},"","","",""]
["Floor surface","ENV",{"$f":"IF(C$28=0,\"\",$N$11)","v":""},{"$f":"IF(C$28=0,\"\",$N$12)","v":""},{"$f":"IF(E$28=0,\"\",$N$11)","v":""},{"$f":"IF(E$28=0,\"\",$N$12)","v":""},{"$f":"IF(G$28=0,\"\",$N$11)","v":""},{"$f":"IF(G$28=0,\"\",$N$12)","v":""},{"$f":"IF(OR($C34=\"\",$C34=\"N/A\"),\"\",Q22)","v":""},"",{"$f":"IF(OR($G34=\"\",$G34=\"N/A\"),\"\",S22)","v":""},null,null,"Colour","Small","Medium","Large","Rolling","Churning","Dragging",null,"","",""]
["Obstacles en route","ENV",{"$f":"IF(C$28=0,\"\",$V$11)","v":""},{"$f":"IF(C$28=0,\"\",$V$12)","v":""},{"$f":"IF(E$28=0,\"\",$V$11)","v":""},{"$f":"IF(E$28=0,\"\",$V$12)","v":""},{"$f":"IF(G$28=0,\"\",$V$11)","v":""},{"$f":"IF(G$28=0,\"\",$V$12)","v":""},{"$f":"IF(OR($C35=\"\",$C35=\"N/A\"),\"\",Q23)","v":""},"",{"$f":"IF(OR($G35=\"\",$G35=\"N/A\"),\"\",S23)","v":""},null,null,"WGT",{"$f":"IF(OR(C16=\"\",C16=\"N/A\"),\"\",C16)","v":""},{"$f":"IF(OR(E16=\"\",E16=\"N/A\"),\"\",E16)","v":""},{"$f":"IF(OR(G16=\"\",G16=\"N/A\"),\"\",G16)","v":""},{"$f":"IF(OR(C29=\"\",C29=\"N/A\"),\"\",C29)","v":""},{"$f":"IF(OR(E29=\"\",E29=\"N/A\"),\"\",E29)","v":""},{"$f":"IF(OR(G29=\"\",G29=\"N/A\"),\"\",G29)","v":""},null,"","","",{"$f":"IF(OR(C34=\"\",C34=\"N/A\"),\"\",VLOOKUP(C34,Col_Index,2))","v":""},{"$f":"IF(OR(E34=\"\",E34=\"N/A\"),\"\",VLOOKUP(E34,Col_Index,2))","v":""},{"$f":"IF(OR(G34=\"\",G34=\"N/A\"),\"\",VLOOKUP(G34,Col_Index,2))","v":""}]
["Other factors","ENV",{"$f":"IF(C$28=0,\"\",$P$11)","v":""},{"$f":"IF(C$28=0,\"\",$P$12)","v":""},{"$f":"IF(E$28=0,\"\",$P$11)","v":""},{"$f":"IF(E$28=0,\"\",$P$12)","v":""},{"$f":"IF(G$28=0,\"\",$P$11)","v":""},{"$f":"IF(G$28=0,\"\",$P$12)","v":""},{"$f":"IF(OR($C36=\"\",$C36=\"N/A\"),\"\",Q24)","v":""},"",{"$f":"IF(OR($G36=\"\",$G36=\"N/A\"),\"\",S24)","v":""},null,null,"T&L",{"$f":"IF(AD32=\"\",\"\",VLOOKUP(AD32,Col_Lookup,2))","v":""},"","","","","",null,"","","",{"$f":"IF(OR(C35=\"\",C35=\"N/A\"),\"\",VLOOKUP(C35,Col_Index,2))","v":""},{"$f":"IF(OR(E35=\"\",E35=\"N/A\"),\"\",VLOOKUP(E35,Col_Index,2))","v":""},{"$f":"IF(OR(G35=\"\",G35=\"N/A\"),\"\",VLOOKUP(G35,Col_Index,2))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ENV","","","","","","",null,"","","",{"$f":"IF(OR(C36=\"\",C36=\"N/A\"),\"\",VLOOKUP(C36,Col_Index,2))","v":""},{"$f":"IF(OR(E36=\"\",E36=\"N/A\"),\"\",VLOOKUP(E36,Col_Index,2))","v":""},{"$f":"IF(OR(G36=\"\",G36=\"N/A\"),\"\",VLOOKUP(G36,Col_Index,2))","v":""}]
["Comments on Pushing/Pulling Tasks","C4","Use ALT-RTN to start new line"]
[]
[]
["SUMMARY RESULTS",null,"Wheeled Load",null,null,null,null,"Non-Wheeled Load"]
["C5","Type","Small",null,"Medium",null,"Large","Rolling",null,"Churning","Dragging"]
["Load Weight Risk","WGT",{"$f":"IF(PP_WS_Active=0,\"N/A\",O35)","v":"N/A"},null,{"$f":"IF(PP_WM_Active=0,\"N/A\",P35)","v":"N/A"},null,{"$f":"IF(PP_WL_Active=0,\"N/A\",Q35)","v":"N/A"},{"$f":"IF(PP_NR_Active=0,\"N/A\",R35)","v":"N/A"},null,{"$f":"IF(PP_NC_Active=0,\"N/A\",S35)","v":"N/A"},{"$f":"IF(PP_ND_Active=0,\"N/A\",T35)","v":"N/A"}]
["Load Design and Task Risk","T&L",{"$f":"IF(PP_WS_Active=0,\"N/A\",O36)","v":"N/A"},null,{"$f":"IF(PP_WM_Active=0,\"N/A\",P36)","v":"N/A"},null,{"$f":"IF(PP_WL_Active=0,\"N/A\",Q36)","v":"N/A"},{"$f":"IF(PP_NR_Active=0,\"N/A\",R36)","v":"N/A"},null,{"$f":"IF(PP_NC_Active=0,\"N/A\",S36)","v":"N/A"},{"$f":"IF(PP_ND_Active=0,\"N/A\",T36)","v":"N/A"}]
["Location and Environment Risk","ENV",{"$f":"IF(PP_WS_Active=0,\"N/A\",O37)","v":"N/A"},null,{"$f":"IF(PP_WM_Active=0,\"N/A\",P37)","v":"N/A"},null,{"$f":"IF(PP_WL_Active=0,\"N/A\",Q37)","v":"N/A"},{"$f":"IF(PP_NR_Active=0,\"N/A\",R37)","v":"N/A"},null,{"$f":"IF(PP_NC_Active=0,\"N/A\",S37)","v":"N/A"},{"$f":"IF(PP_ND_Active=0,\"N/A\",T37)","v":"N/A"}]
["Total Risk Score: ",null,{"$f":"IF(PP_WS_Active=0,\"N/A\",SUM(I16:I24))","v":"N/A"},null,{"$f":"IF(PP_WM_Active=0,\"N/A\",SUM(J16:J24))","v":"N/A"},null,{"$f":"IF(PP_WL_Active=0,\"N/A\",SUM(K16:K24))","v":"N/A"},{"$f":"IF(PP_NR_Active=0,\"N/A\",SUM(I29:I36))","v":"N/A"},null,{"$f":"IF(PP_NC_Active=0,\"N/A\",SUM(J29:J36))","v":"N/A"},{"$f":"IF(PP_ND_Active=0,\"N/A\",SUM(K29:K36))","v":"N/A"}]

{"sheet":"C- Formulae","index":4,"n_rows":37,"n_cols":22,"rows_kept":37,"cut":false,"hidden":true,"merged":[[13,2,13,7],[26,0,27,0],[10,0,10,1],[10,2,10,6],[10,8,10,10],[14,2,14,3],[14,4,14,5],[14,6,14,7],[26,2,26,7],[27,2,27,3],[27,4,27,5],[27,6,27,7],[12,12,12,21],[8,0,8,1],[8,2,8,6],[8,8,8,10],[9,0,9,1],[9,2,9,6],[9,8,9,10],[6,0,6,1],[6,2,6,6],[6,8,6,10],[7,0,7,1],[7,2,7,6],[7,8,7,10],[2,16,2,17],[2,18,2,19],[2,20,2,21],[4,2,4,6],[4,8,4,10],[2,12,2,13],[2,14,2,15],[5,0,5,1],[5,2,5,6],[5,8,5,10],[2,0,3,1],[2,2,3,6],[2,8,3,10]]}
["HIDDEN SHEET PROVIDING FORMULAE FOR RESETTING GENERIC SCORE CELLS FOR RAPP"]
[]
["Description of Task Step",null,"Type of manual handling activity",null,null,null,null,null,"Standard location type ",null,null,null,"Floor surface",null,"Other factors *",null,"Travel Distance \n(Wheeled)",null,"Travel Distance \n(No wheels)",null,"Obstacles en Route "]
[null,null,null,null,null,null,null,null,null,null,null,null,"Colour","Score","Colour","Score","Colour","Score","Colour","Score","Colour","Score"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR($C5=\"\",$I5=\"\"),\"\",VLOOKUP($I5,PP_Stan_scores,3))","v":""},{"$f":"IF(OR($C5=\"\",$I5=\"\"),\"\",VLOOKUP($I5,PP_Stan_scores,4))","v":""},{"$f":"IF(OR($C5=\"\",$I5=\"\"),\"\",VLOOKUP($I5,PP_Stan_scores,6))","v":""},{"$f":"IF(OR($C5=\"\",$I5=\"\"),\"\",VLOOKUP($I5,PP_Stan_scores,7))","v":""},{"$f":"IF(OR($C5=\"\",$I5=\"\"),\"\",VLOOKUP($I5,PP_Stan_scores,9))","v":""},{"$f":"IF(OR($C5=\"\",$I5=\"\"),\"\",VLOOKUP($I5,PP_Stan_scores,10))","v":""},{"$f":"IF(OR($C5=\"\",$I5=\"\"),\"\",VLOOKUP($I5,PP_Stan_scores,12))","v":""},{"$f":"IF(OR($C5=\"\",$I5=\"\"),\"\",VLOOKUP($I5,PP_Stan_scores,13))","v":""},{"$f":"IF(OR($C5=\"\",$I5=\"\"),\"\",VLOOKUP($I5,PP_Stan_scores,15))","v":""},{"$f":"IF(OR($C5=\"\",$I5=\"\"),\"\",VLOOKUP($I5,PP_Stan_scores,16))","v":""}]
[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,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,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,null,null,null,null,null,null,null,null,null,{"$f":"IF(N12=\"\",\"\",IF(N12=1,\"AMBER\",IF(N12=4,\"RED\",\"GREEN\")))","v":""},{"$f":"IF(COUNT(N5:N11)=0, \"\",MAX(N5:N11))","v":""},{"$f":"IF(P12=\"\",\"\",IF(P12=1,\"AMBER\",IF(P12=2,\"RED\",\"GREEN\")))","v":""},{"$f":"IF(COUNT(P5:P11)=0, \"\",MAX(P5:P11))","v":""},{"$f":"IF(R12=\"\",\"\",IF(R12=1,\"AMBER\",IF(R12=3,\"RED\",\"GREEN\")))","v":""},{"$f":"IF(COUNT(R5:R11)=0, \"\",MAX(R5:R11))","v":""},{"$f":"IF(T12=\"\",\"\",IF(T12=1,\"AMBER\",IF(T12=3,\"RED\",\"GREEN\")))","v":""},{"$f":"IF(COUNT(T5:T11)=0, \"\",MAX(T5:T11))","v":""},{"$f":"IF(V12=\"\",\"\",IF(V12=2,\"AMBER\",IF(V12=3,\"RED\",\"GREEN\")))","v":""},{"$f":"IF(COUNT(V5:V11)=0, \"\",MAX(V5:V11))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Worst Case Colour/Score"]
["Wheeled Loads Risk Factors",null,"Colour Band"]
[null,"Type","Small",null,"Medium",null,"Large"]
["Active check:",null,{"$f":"COUNTIF(PP_Type_Range,'Look-ups'!A9)","v":0},1,{"$f":"COUNTIF(PP_Type_Range,'Look-ups'!A10)","v":0},1,{"$f":"COUNTIF(PP_Type_Range,'Look-ups'!A11)","v":0}]
["Load weight","WGT"]
["Posture","T&L"]
["Hand grip","T&L"]
["Work pattern","T&L"]
["Travel distance","ENV",{"$f":"IF(C$15=0,\"\",$R$11)","v":""},{"$f":"IF(C$15=0,\"\",$R$12)","v":""},{"$f":"IF(E$15=0,\"\",$R$11)","v":""},{"$f":"IF(E$15=0,\"\",$R$12)","v":""},{"$f":"IF(G$15=0,\"\",$R$11)","v":""},{"$f":"IF(G$15=0,\"\",$R$12)","v":""}]
["Condition of equipment","T&L"]
["Floor surface","ENV",{"$f":"IF(C$15=0,\"\",$N$11)","v":""},{"$f":"IF(C$15=0,\"\",$N$12)","v":""},{"$f":"IF(E$15=0,\"\",$N$11)","v":""},{"$f":"IF(E$15=0,\"\",$N$12)","v":""},{"$f":"IF(G$15=0,\"\",$N$11)","v":""},{"$f":"IF(G$15=0,\"\",$N$12)","v":""}]
["Obstacles en route","ENV",{"$f":"IF(C$15=0,\"\",$V$11)","v":""},{"$f":"IF(C$15=0,\"\",$V$12)","v":""},{"$f":"IF(E$15=0,\"\",$V$11)","v":""},{"$f":"IF(E$15=0,\"\",$V$12)","v":""},{"$f":"IF(G$15=0,\"\",$V$11)","v":""},{"$f":"IF(G$15=0,\"\",$V$12)","v":""}]
["Other factors","ENV",{"$f":"IF(C$15=0,\"\",$P$11)","v":""},{"$f":"IF(C$15=0,\"\",$P$12)","v":""},{"$f":"IF(E$15=0,\"\",$P$11)","v":""},{"$f":"IF(E$15=0,\"\",$P$12)","v":""},{"$f":"IF(G$15=0,\"\",$P$11)","v":""},{"$f":"IF(G$15=0,\"\",$P$12)","v":""}]
[]
["Loads Pushed/Pulled not on Wheels\nRisk Factors",null,"Colour Band"]
[null,"Type","Rolling",null,"Churning",null,"Dragging"]
["Active check:",null,{"$f":"COUNTIF(PP_Type_Range,'Look-ups'!A12)","v":0},1,{"$f":"COUNTIF(PP_Type_Range,'Look-ups'!A13)","v":0},1,{"$f":"COUNTIF(PP_Type_Range,'Look-ups'!A14)","v":0}]
["Load weight","WGT"]
["Posture","T&L"]
["Hand grip","T&L"]
["Work pattern","T&L"]
["Travel distance","ENV",{"$f":"IF(C$28=0,\"\",$T$11)","v":""},{"$f":"IF(C$28=0,\"\",$T$12)","v":""},{"$f":"IF(E$28=0,\"\",$T$11)","v":""},{"$f":"IF(E$28=0,\"\",$T$12)","v":""},{"$f":"IF(G$28=0,\"\",$T$11)","v":""},{"$f":"IF(G$28=0,\"\",$T$12)","v":""}]
["Floor surface","ENV",{"$f":"IF(C$28=0,\"\",$N$11)","v":""},{"$f":"IF(C$28=0,\"\",$N$12)","v":""},{"$f":"IF(E$28=0,\"\",$N$11)","v":""},{"$f":"IF(E$28=0,\"\",$N$12)","v":""},{"$f":"IF(G$28=0,\"\",$N$11)","v":""},{"$f":"IF(G$28=0,\"\",$N$12)","v":""}]
["Obstacles en route","ENV",{"$f":"IF(C$28=0,\"\",$V$11)","v":""},{"$f":"IF(C$28=0,\"\",$V$12)","v":""},{"$f":"IF(E$28=0,\"\",$V$11)","v":""},{"$f":"IF(E$28=0,\"\",$V$12)","v":""},{"$f":"IF(G$28=0,\"\",$V$11)","v":""},{"$f":"IF(G$28=0,\"\",$V$12)","v":""}]
["Other factors","ENV",{"$f":"IF(C$28=0,\"\",$P$11)","v":""},{"$f":"IF(C$28=0,\"\",$P$12)","v":""},{"$f":"IF(E$28=0,\"\",$P$11)","v":""},{"$f":"IF(E$28=0,\"\",$P$12)","v":""},{"$f":"IF(G$28=0,\"\",$P$11)","v":""},{"$f":"IF(G$28=0,\"\",$P$12)","v":""}]

{"sheet":"D>Controls","index":5,"n_rows":24,"n_cols":9,"rows_kept":24,"cut":false,"hidden":false,"merged":[[21,8,21,9],[22,8,22,9],[23,8,23,9],[16,8,16,9],[17,8,17,9],[18,8,18,9],[19,8,19,9],[20,8,20,9],[13,1,13,9],[15,0,15,9],[12,1,12,9],[0,0,0,9],[2,0,2,9],[3,1,3,9],[4,1,4,9],[5,1,5,9],[6,1,6,9],[7,1,7,9],[8,1,8,9],[9,1,9,9],[10,1,10,9],[11,1,11,9],[21,6,21,7],[22,6,22,7],[23,6,23,7],[21,1,21,5],[22,1,22,5],[23,1,23,5],[16,6,16,7],[17,6,17,7],[18,6,18,7],[19,6,19,7],[20,6,20,7],[16,1,16,5],[17,1,17,5],[18,1,18,5],[19,1,19,5],[20,1,20,5]]}
["PART D - CONTROLS (Specific to this Manual Handling Operation)"]
[]
["D1:  Current Controls"]
["Ref","Description of Control"]
[1]
[{"$f":"A5+1","v":2}]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[]
["D2:  Future Controls (Requiring Development or Implementation)"]
["Ref","Description of Control",null,null,null,null,"By Whom",null,"Due Date"]
[1]
[{"$f":"A18+1","v":2}]
[3]
[4]
[5]
[6]
[7]

{"sheet":"Look-ups","index":6,"n_rows":144,"n_cols":12,"rows_kept":144,"cut":false,"hidden":true,"merged":[[35,0,35,1],[40,0,40,1]]}
[]
["LLC_Types"]
["Individual Lift/Lower"]
["Individual Carry"]
["Team Lift/Lower/Carrry"]
[]
["PP_Types"]
["Small wheeled"]
["Medium wheeled"]
["Large wheeled"]
["Rolling"]
["Churning"]
["Dragging"]
[]
["LLC_Load_Col"]
["PURPLE"]
["RED"]
["AMBER"]
["GREEN"]
[]
[]
["PP_Load_Col"]
["PURPLE"]
["HIGH RED"]
["RED"]
["AMBER"]
["GREEN"]
[]
[]
["LLC_Other_Col"]
["RED"]
["AMBER"]
["GREEN"]
[]
[]
["Col_Index"]
["AMBER",2]
["GREEN",1]
["RED",3]
[]
["Col_Lookup"]
[1,"GREEN"]
[2,"AMBER"]
[3,"RED"]
[]
["PP_Other_Col"]
["RED"]
["AMBER"]
["GREEN"]
[]
[]
["Yes_No_NA"]
["Yes"]
["No"]
["N/A"]
[]
["Scores","OpCode","GREEN","AMBER","RED","PURPLE","N/A","Type"]
["Load weight and lift/carry frequency",1,0,4,6,10,0,"Lifting"]
["Hand distance from the lower back",2,0,3,6,null,0]
["Vertical lift region",3,0,1,3,null,0]
["Torso twisting/sideways bending\nAssymetrical torso/load (carrying)",4,0,1,2,null,0]
["Postural Constraints",5,0,1,3,null,0]
["Grip on the load",6,0,1,2,null,0]
["Floor Surface",7,0,1,2,null,0]
["Other environmental factors",8,0,1,2,null,0]
["Carry distance",9,0,0,0,null,0]
["Obstacles en route",10,0,0,0,null,0]
["Communication and co-ordination",11,0,0,0,null,0]
["Load weight and lift/carry frequency",12,0,4,6,10,0,"Carry"]
["Hand distance from the lower back",13,0,3,6,null,0]
["Vertical lift region",14,0,0,0,null,0,null,null,null,null,"z"]
["Torso twisting/sideways bending\nAssymetrical torso/load (carrying)",15,0,1,2,null,0]
["Postural Constraints",16,0,1,3,null,0]
["Grip on the load",17,0,1,2,null,0]
["Floor Surface",18,0,1,2,null,0]
["Other environmental factors",19,0,1,2,null,0]
["Carry distance",20,0,1,3,null,0]
["Obstacles en route",21,0,2,3,null,0]
["Communication and co-ordination",22,0,0,0,null,0]
["Load weight and lift/carry frequency",23,0,4,6,10,0,"Team Handling"]
["Hand distance from the lower back",24,0,3,6,null,0]
["Vertical lift region",25,0,1,3,null,0]
["Torso twisting/sideways bending\nAssymetrical torso/load (carrying)",26,0,1,2,null,0]
["Postural Constraints",27,0,1,3,null,0]
["Grip on the load",28,0,1,2,null,0]
["Floor Surface",29,0,1,2,null,0]
["Other environmental factors",30,0,1,2,null,0]
["Carry distance",31,0,0,0,null,0]
["Obstacles en route",32,0,0,0,null,0]
["Communication and co-ordination",33,0,1,3,null,0]
[]
[]
["Scores","OpCode","GREEN","AMBER","RED","HIGH RED","PURPLE","N/A"]
["Load weight",1,0,2,4,8,100,0,"Small Wheeled"]
["Posture",2,0,3,6,null,null,0]
["Hand Grip",3,0,1,2,null,null,0]
["Work Pattern",4,0,1,3,null,null,0]
["Travel distance",5,0,1,3,null,null,0]
["Condition of equipment",6,0,2,4,null,null,0]
["Floor Surface",7,0,1,4,null,null,0]
["Obstacles en route",8,0,2,3,null,null,0]
["Other factors",9,0,1,2,null,null,0]
["Load weight",10,0,2,4,8,100,0,"Medium Wheeled"]
["Posture",11,0,3,6,null,null,0]
["Hand Grip",12,0,1,2,null,null,0]
["Work Pattern",13,0,1,3,null,null,0]
["Travel distance",14,0,1,3,null,null,0]
["Condition of equipment",15,0,2,4,null,null,0]
["Floor Surface",16,0,1,4,null,null,0]
["Obstacles en route",17,0,2,3,null,null,0]
["Other factors",18,0,1,2,null,null,0]
["Load weight",19,0,2,4,8,100,0,"Large Wheeled"]
["Posture",20,0,3,6,null,null,0]
["Hand Grip",21,0,1,2,null,null,0]
["Work Pattern",22,0,1,3,null,null,0]
["Travel distance",23,0,1,3,null,null,0]
["Condition of equipment",24,0,2,4,null,null,0]
["Floor Surface",25,0,1,4,null,null,0]
["Obstacles en route",26,0,2,3,null,null,0]
["Other factors",27,0,1,2,null,null,0]
["Load weight",28,0,2,4,8,100,0,"Rolling"]
["Posture",29,0,3,6,null,null,0]
["Hand Grip",30,0,1,2,null,null,0]
["Work Pattern",31,0,1,3,null,null,0]
["Travel distance",32,0,1,3,null,null,0]
["Floor Surface",33,0,1,4,null,null,0]
["Obstacles en route",34,0,2,3,null,null,0]
["Other factors",35,0,1,2,null,null,0]
["Load weight",36,0,2,4,8,100,0,"Churning"]
["Posture",37,0,3,6,null,null,0]
["Hand Grip",38,0,1,2,null,null,0]
["Work Pattern",39,0,1,3,null,null,0]
["Travel distance",40,0,1,3,null,null,0]
["Floor Surface",41,0,1,4,null,null,0]
["Obstacles en route",42,0,2,3,null,null,0]
["Other factors",43,0,1,2,null,null,0]
["Load weight",44,0,2,4,8,100,0,"Dragging"]
["Posture",45,0,3,6,null,null,0]
["Hand Grip",46,0,1,2,null,null,0]
["Work Pattern",47,0,1,3,null,null,0]
["Travel distance",48,0,1,3,null,null,0]
["Floor Surface",49,0,1,4,null,null,0]
["Obstacles en route",50,0,2,3,null,null,0]
["Other factors",51,0,1,2,null,null,0]

{"sheet":"E>Photographs","index":7,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[[0,0,0,10],[1,0,52,10]]}
["PART E -  PHOTOGRAPHS (illustrating manual handling operation)"]

{"sheet":"F>Instructions","index":8,"n_rows":94,"n_cols":2,"rows_kept":94,"cut":false,"hidden":false,"merged":[[83,0,83,1],[84,0,84,1],[81,0,81,1],[85,0,85,1],[86,0,86,1],[87,0,87,1],[89,0,89,1],[90,0,90,1],[91,0,91,1],[92,0,92,1],[93,0,93,1],[2,0,2,1],[26,0,26,1],[31,0,31,1],[27,0,27,1],[29,0,29,1],[28,0,28,1],[51,0,51,1],[37,0,37,1],[43,0,43,1],[44,0,44,1],[45,0,45,1],[46,0,46,1],[47,0,47,1],[32,0,32,1],[33,0,33,1],[0,0,0,1],[4,0,4,1],[11,0,11,1],[13,0,13,1],[16,0,16,1],[38,0,38,1],[39,0,39,1],[19,0,19,1],[21,0,21,1],[53,0,53,1],[54,0,54,1],[55,0,55,1],[56,0,56,1],[58,0,58,1],[59,0,59,1],[60,0,60,1],[64,0,64,1],[65,0,65,1],[66,0,66,1],[70,0,70,1],[74,0,74,1],[75,0,75,1],[76,0,76,1],[77,0,77,1],[71,0,71,1],[72,0,72,1],[73,0,73,1]]}
["PART F >  EXPLANTORY NOTES"]
[]
["TAB: A>G-MHORA Details"]
["Section","Notes"]
["A1: Assessment Reference Details"]
["A1.1","Reference number for risk assessments is assigned by STE, unless risk assessment is local.\nVersion number should start at 0.1 as the first draft, with each draft version incremented by 0.1 (e.g. 0.1, 0.2 etc).  Each approved issue should be a whole number (1.0, 2.0 etc)"]
["A1.2","Enter brief title describing the manual handling operation, including what is being handled and where from/to."]
["A1.3","Status of Assessment: Select as follows:\n- Draft under development: For assessments under development/revision\n- Issue for Checking/Review: For assessments completed and issued for review\n- Approved for Use: For assessments finalised and issued for use\n\nPurpose of Assessment: Select as follows:\n- Assessment of Current Controls: For assesssments or re-assessments of operation with current controls\n- Test of New/Enhanced Controls: For assessments of operation testing additional/new controls\n- Location/Task Specific: For local assessments limited to a single business unit"]
["A1.4","Enter detals of assessor and date assessment issued for review."]
["A1.5","Enter details of business unit reviewer and date assessment completed review."]
["A1.6","Enter details of STE peer reviewer and date peer review completed."]
["A2:  Related Work Activity Risk Assessments"]
["A2","Where a WARA is created, it can identify work activities that require a manual handling assessment.  If this has prompted this assessment, enter details of the specific WARAs that cross-refer to this manual handling risk assessment."]
["A3:  Details of Load"]
["A3.1","Provide details of the item manually handled, including the make/model as applicable."]
["A3.2","Enter details of the weight of the item, or each part of the item if handled seperately.  Weight should include the maximum weight of any fuel or other fluids."]
["A4:  Overview of Manual Handling Operation"]
["A4.1","Describe the manual handling operation including each step of lifting/carrying/lowering, how many staff are involved and any manual handling aids (e.g. trolleys) used."]
["A4.2","Describe the staff involved in this task (e.g. track staff, welding team, signal maintenance technicians, mobile operations managers, station assistants)."]
["A5: Details of Where and When Manual Handling Operation was Observed"]
["A5.1","Provide outline details of the observations carried out of the manual handling operation.  The details requested are describing where the manual handling operation was observed (e.g. Stockport DU training centre), on what date the observation took place and who was involved in the assessment (e.g. J. White, HSEA; F Brown, Track Supervising Engineer; M Green, RMT Local Rep; Track team, Stockport DU).  \n\nSpace is provided to record three observations.  You can insert additional rows if more is required."]
["A6: Indications that Operation poses Risk of Injury"]
["A6.1","A good indication of the potential risk of a manual handling operation is any data on previous injuries and accidents.  It is useful to carry out a search of previous accident records and to include summary details on the form.   "]
["A6.2","Record any other indications that operation poses a risk of injury.  A series of check boxes are provided to identify where typical indications apply.  The text field can be used to record any other indications."]
[]
[]
["TAB: B>MAC Lifting-Lowering-Carrying"]
["This tab provides a record sheet for applying the HSE MAC (Manual handling Assessment Charts) tool to Lifting-Lowering-Carrying Operations. Details of how to carry out a MAC assessment and a version of the guide that can downloaded are provided on the HSE website:"]
["http://www.hse.gov.uk/msd/mac/"]
["Only carry out a MAC assessment for individual or team lifting/lowering and carrying tasks.  Where the manual handling operation involves a load being pushed or pulled and not lifted/carried, carry out a RAPP assessment (refer to Tab C). "]
["Section","Notes"]
["B1: Description of Task Steps"]
["In the first table, describe each of the task steps that are involved in the manual handling operation.  For example for a piece of equipment that is taken from a store in a Delivery Unit and then taken and used on site, this might include:\n- Team lift to pick up item in store\n- Team carry to van\n- At access point, team lift of item out of van\n- Team carry down access steps to trackside gate\n- Team carry to site of work\n\nWhere the same operations are repeated in reverse to retrieve the item, there is no need to record the steps again.  \n\nIf there is a task step that involves pushing/pulling (e.g. placing item on a track trolley and pushing to/from site), do NOT record this task step on this tab.  This should be recorded on Tab C."]
["For each task step, you are requried to select what kind of manual handling operation it is (Lifting/Lowering; Carrying; Team Lift/Lower/Carry) and what kind of location it is carried out at.  The reasons for this are as follows:\n\nMost manual handling risk assessments will review a specific situation, but are required to provide a generic assessment.  Yet the actual conditions can vary from site to site, and depend upon the specific conditions on the day when the observation took place.  The used of standard location types means that a baseline and standardised set of Generic MAC scores are applied to the assessment of the environmental factors.  The definiton of the standardised conditions and scores are provided in Tab G>Lift-Lower-Carry Conditions for information."]
["B1.1","Describe each task step in turn that is covered in the manual handling operation.  If the field is too small to include the text, you can drag the bottom line down to make more space."]
["B1.2","Select from the drop down menu to define the type of manual handling activity involved in the task step."]
["B1.3","Select from the drop down menu the appropriate standard location type. "]
["Once you have made selections in this table, the columns for the related manual handling activity types are changed in table B2 below.  Relevant environmental factors are populated with their generic factor ratings.  Other relevant fields are changed to a light yellow colour.  Scores are added to the related Numerical Score fields.\n\nThis first table MUST be completed before attempting to enter scores in Table B2.\n"]
["B2: Lifting/Lowering/Carrying Risk Factor"]
["The risk factors are those identified in the HSE MAC tool.  You will need to refer to the HSE MAC documentation to understand the colour bands.\n\nThese have been classified into three groupings:\n"]
["WGT:","Weight of load (and lift/lower/carry frequency)"]
["T&L:","Task and Load design, which predominatly are about the shape of the load, placement of lifting points and what needs to be done with it (e.g. lifted to/from the ground)."]
["ENV:"," Environmental aspects including weather, lighting conditions, any space constraints, floor surfaces, distance that items need to be carried, objects that might be encountered en route. "]
["In the colour band table, you will see columns that do NOT apply to the manual handling operation remain greyed out.  Those that do apply will have relevant ENV ratings already entered and other cells (in light yellow) awaiting for the risk factor rating to be entered.  The risk factor can be selected using the drop down menu.\n\nYou can decide to apply a different rating to an environment factor to the one that has been pre-populated.  Please record the reason for this in the comments box (B3).  You will see that the pre-populated rating colour will remain in the small window to left hand side of the relevant cell, so you can reset it to the default if required later.\n\nThe numerical scores are automatically entered from the selected risk rating and cannot be edited."]
["B3: Comments on Lift/Lower/Carry Tasks"]
["Use the text box to provide any necessary explanation of the chosen ratings.   This can also be used to explain what \"other environmental factors\" have been included.\n"]
["Summary Results"]
["The summary table is automatically populated from the information entered.\n\nThe colours shown are the HIGHEST rating applied to the WGT, T&L and ENV factors in the table above.  In general these can be interpreted as follows:"]
["WGT:","A high rating for this factor indicates the most significant factor in causing risk, combining weight and frequency of taks repetition.  Any rating which is PURPLE indicates a very significant risk and ways to reduce the weight of the load or to avoid manual handling should be sought as a priority. "]
["T&L:","A high rating for this factors suggests that the load design needs to be reviewed.  It may be possible to apply job aids to reeduce the risks from manual handling (e.g. to reduce having to lift or lower to/from ground level."]
["ENV:","Some environmental aspects are inevitable in the rail environment (e.g. rain, high winds), but their effects can be exacerbated when combined with other environmental, weight, task and load factors.  Some environmental factors may be improved, such as providing better layout in a storage location, improving flooring conditions, avoiding use of stepped or narrow access routes for the manual handling operation etc."]
["Risk reduction actions should target the highest risk factors first and aim to reduce all risk factors to GREEN.\n\nFinally, a total risk score is provided.   This means little on its own, but does allow some comparison between manual handling operations (the higher the score, the greater the risk)."]
[]
["TAB: C>RAPP Pushing-Pulling"]
["This tab provides a record sheet for applying the HSE RAPP (Risk Assessment of Pushing-Pulling) tool to Manual Handling Operations that involve pushing or pulling a load, whether on a trolley/truck or without. Details of how to carry out a RAPP assessment and a version of the guide that can downloaded are provided on the HSE website:"]
["http://www.hse.gov.uk/pubns/indg478.htm"]
["Only carry out a RAPP assessment where a load is pushed or pulled.  Where the manual handling operation involves a load being lifted/carried, carry out a MAC assessment (refer to Tab B). "]
["Section","Notes"]
["C1: Description of Task Steps"]
["In the first table, describe each of the task steps that are involved in the manual handling operation that involve pushing/pulling.  For example for a piece of equipment that is taken from a store in a Delivery Unit and then taken and used on site, this might include:\n- Push item on trolley to van\n- Push item on trolley from van to trackside\n- Push item on rail mounted trolley to site of work\n\nWhere the same operations are repeated in reverse to retrieve the item, there is no need to record the steps again.  \n\nIf there are task steps that involve lifting the item on to or off the trolley, or into/out of the van, do NOT record this task step on this tab.  This should be recorded on Tab B."]
["For each task step, you are required to select what kind of manual handling operation it is (dragging, churning, pushing a small/medium/large wheeled truck/item) and what kind of location it is carried out at.   The reasons for this are as follows:\n\nMost manual handling risk assessments will review a specific situation, but apart from location specific assessments, we are required to provide a generic assessment.  Yet the actual conditions can vary from site to site, and depend upon the specific conditions on the day when the observation took place.  The used of standard location types means that a baseline and standardised set of Generic MAC scores are applied to the assessment of the environmental factors.  The definiton of the standardised conditions and scores are provided in Tab H>Push-Pull Conditions for information."]
["C1.1","Describe each task step in turn that is covered in the manual handling operation.  If the field is too small to include the text, you can drag the bottom line down to make more space."]
["C1.2","Select from the drop down menu to define the type of manual handling activity involved in the task step. The definitions of the types of pushing/pulling activities are provided in the RAPP documentation.  You will need to fit to the best option."]
["C1.3","Select from the drop down menu the appropriate standard location type. "]
["Once you have made selections in this table, the columns for the related manual handling activity types are changed in tables C2 and C3 below.  Relevant environmental factors are populated with their generic factor ratings.  Other relevant fields are changed to a light yellow colour.  Scores are added to the related Numerical Score fields.\n\nThis first table MUST be completed before attempting to enter scores in Tables C2 or C3.\n"]
["C2: Wheeled Loads Risk Factor"]
["The risk factors are those identified in the HSE RAPP tool for wheeled loads.  You may need to refer to the HSE RAPP documentation to understand the colour bands.\n\nThese have been classified into three groupings:\n"]
["WGT:","Weight of load being pushed/pulled"]
["T&L:","Task and Load design, which predominatly are about the shape of the load for pushing/pulling, its typical condition and work pattern."]
["ENV:","Environmental aspects including any space constraints, floor surfaces, distance that items need to be pushed/pulled, objects that might be encountered en route. "]
["In the colour band table, you will see columns that do NOT apply to the manual handling operation remain greyed out.  Those that do apply will have relevant ENV ratings already entered and other cells (in light yellow) awaiting for the risk factor rating to be entered.  The risk factor can be selected using the drop down menu.\n\nYou can decide to apply a different rating to an environment factor to the one that has been pre-populated.  Please record the reason for this in the comments box (C4).  You will see that the pre-populated rating colour will remain in the small window to left hand side of the relevant cell, so you can reset it to the default if required later.\n\nThe numerical scores are automatically entered from the selected risk rating and cannot be edited."]
["C3: Loads Pushed/Pulled not on Wheels Risk Factors"]
["The risk factors are those identified in the HSE RAPP tool for loads moved by rolling, dragging or churning.  You may need to refer to the HSE RAPP documentation to understand the colour bands.\n"]
["In the colour band table, you will see columns that do NOT apply to the manual handling operation remain greyed out.  Those that do apply will have relevant ENV ratings already entered and other cells (in light yellow) awaiting for the risk factor rating to be entered.  The risk factor can be selected using the drop down menu.\n\nYou can decide to apply a different rating to an environment factor to the one that has been pre-populated.  Please record the reason for this in the comments box (C4).  You will see that the pre-populated rating colour will remain in the small window to left hand side of the relevant cell, so you can reset it to the default if required later.\n\nThe numerical scores are automatically entered from the selected risk rating and cannot be edited."]
["C4: Comments on Pushing/Pulling Tasks"]
["Use the text box to provide any necessary explanation of the chosen ratings for any steps assessed in the previous two tables.   This can also be used to explain what \"other factors\" have been included.\n"]
["Summary Results"]
["The summary table is automatically populated from the information entered.\n\nThe colours shown are the HIGHEST rating applied to the WGT, T&L and ENV factors in the table above.  In general these can be interpreted as follows:"]
["WGT:","A high rating for this factor indicates the most significant factor in causing risk.  Any rating which is PURPLE indicates that the weight exceeds the rated load of the trolley and should cease immediately. A HIGH RED rating is very significant and ways to reduce the weight of the load or to mechanise transport should be sought as a priority. "]
["T&L:","A high rating for this factors suggests that the load or trolley/truck design needs to be reviewed.  Also high ratings for the work pattern can be addressed by providing breaks."]
["ENV:","Some environmental aspects are inevitable in the rail environment (e.g. rain, high winds), but their effects can be exacerbated when combined with other environmental, weight, task and load factors.  Some environmental factors may be improved, such as improving flooring conditions, avoiding use of stepped or narrow access routes for the manual handling operation etc."]
["Risk reduction actions should target the highest risk factors first and aim to reduce all risk factors to GREEN.\n\nFinally, a total risk score is provided.   This means little on its own, but does allow some comparison between manual handling operations (the higher the score, the greater the risk)."]
[]
["TAB: D>Controls"]
["D1: Current Controls"]
["List all current controls apply to this manual handling operation.  This should avoid listing controls that are general requirements (such as all task performers shall have a manual handling competency).  This could include minimum staffing levels and operations that are prohibited (This item shall not be carried up/down flights of steps/stairs). \n"]
["D2: Future Controls (Requiring Development or Implementation)"]
["This should list all proposed controls required to reduce the risks from manual handling operations to low as reasonable practicable.   As these are essentially actions, this needs to identify which individual is taked with developing the control and by when.  The assessment may be revised to reflect chosen controls, which once accepted should be added to the current controls box (D1). \n"]
[]
["TAB: E>Photographs"]
["For the purpose of communicating the manual handling risks and to assist with reviewing the manual handling assessment, suitable photographs should be inserted in this page (ideally each with explanatory labels).  \n\nTo insert a photograph on to the page in this tab::\n\n1 - Select the Excel Insert Menu\n2 - Select Picture from the Illustrations section of the command ribbon\n3 - From the file dialogue that appears, navigate to where the picture is stored, select the file and press Insert\n4 - Size and position the picture as necessary"]
["It is also useful to insert a video file on this page. To do this:\n\n1 - Select the Excel Insert Menu\n2 - Select Object from the Text section of the command ribbon\n3 - From the dialogue that appears, select the Create from File tab\n4 - Check the Display As Icon check box\n5 - Click the Browse button to navigate to the video file you want to insert and then select it\n6 - Click Insert to embed the video file\n7 - Drag the icon to where you want it on the page"]
["WARNING:  Once phographs and vidoes are inserted, the size of the Excel file will rapidly grow.  This is likely to prevent you emailing the risk assessment to anyone else.  For the Manual Handling Improvement Project, completed risk assessments can be uploaded for review to the MHIP Hub:"]
["MHIP Hub Phase 3 Risk Assessments Submit Folder"]

{"sheet":"G>Lift-Lower-Carry Conditions","index":9,"n_rows":13,"n_cols":17,"rows_kept":13,"cut":false,"hidden":false,"merged":[[3,14,3,16],[0,0,1,1],[3,2,3,4],[3,5,3,7],[3,8,3,10],[3,11,3,13]]}
["Individual & Team Lifting/Lowering/Carrying\nStandardised Conditions"]
[]
[]
["Standardised Locations","Typical Locations","Floor surface",null,null,"Environmental factors",null,null,"Postural Constraints",null,null,"Carry distance \n(Carrying only)",null,null,"Obstacles en Route \n(Carrying Only)"]
["1. Inside building, on one floor level","Office or control centre interior space, some stores, equipment room, station concourse or platform area that is undercover","GREEN",0,"Surface assumed to be flat and in good condition","GREEN",0,"Assumed to be dry, reasonable temperature, no strong air movements, good lighting","GREEN",0,"Assumed to be sufficent space to not constrain lifting/carrying task.  Assumes stores are laid out to enable access.","GREEN",0,"Assumed that carry distance within building 4m or less","GREEN",0,"Assumed flat surface and no obstacles en route.  Doors held open by member of team."]
["2. Inside medium sized enclosed van ","Inside a van moving equipment or materials, Transit size (or less)","GREEN",0,"Surface assumed to be flat and in good condition. May have ridges in floor, but assumed staff wearing boots with ankle support.","GREEN",0,"Assumed to be dry, no strong air movements, sufficient lighting.","RED",3,"Space very limited so assumed to result in severly restricted posture.  Van also likely to have significant amount of equipment & materials affecting space to lift.","GREEN",0,"Carry distance within van will be 4m or less","RED",3,"Assumed flat surface but signficant tripping hazards to be avoided"]
["3. Inside large van or lorry load space ","Inside a large van or back of lorry moving equipment or materials. Tall load space enabling staff to stand upright and stowage for all equipment that allows clear access.","GREEN",0,"Surface assumed to be flat and in good condition. May have ridges in floor, but assumed staff wearing boots with ankle support.","GREEN",0,"Assumed to be dry, no strong air movements, sufficient lighting","AMBER",1,"Space constrained so will result in restricted posture.  Good storage and housekeeing assumed.","GREEN",0,"Carry distance within van will be 4m or less","AMBER",2,"Assumed flat surface but some tripping hazards to be avoided"]
["4. Inside building or under cover, stepped or sloping surface","Office stairwell, covered/internal access ramp","RED",2,"Based on \"steep, sloping floor\" from MAC defintion, which is also taken to include steps","GREEN",0,"Assumed to be dry, reasonable temperature, no strong air movements, good lighting","GREEN",0,"Assumed to be sufficent space to not constrain lifting/carrying task.","AMBER",1,"Assumed that carry distance more than 4m but less than 10m","AMBER",2,"Sloping surfaces or up/down steps"]
["5. Outside in well organised and maintained depot yard","Depot yard (concrete/tarmac surface), good smooth well made surface, external stores well organised.","GREEN",0,"May be wet surface, but good footwear assumed. Surface contamination (e.g. ice, grease, snow) treated/cleared.","AMBER",1,"Assumed to be either to be sheltered to a limited degree or a short exposure time. Likely to be sufficient lighting.  Still likely to be some exposure to the elements on occasions, with some mitigation by appropriate PPE - so one factor deemed to be present (as per MAC)","GREEN",0,"Assumed to be sufficent space to not constrain lifting/carrying task.  Assumes storage is laid out to enable access and egress.","AMBER",1,"Assumed that carry distance more than 4m but less than 10m","GREEN",0,"Assumed flat surface without tripping hazards. Assumes good housekeeping"]
["6. Outside on uncovered platform, station forecourt","Station forecourt, uncovered platform area","GREEN",0,"May be wet surface, but good footwear assumed. Surface contamination (e.g. ice, grease, snow) treated/cleared.","AMBER",1,"Assumed to be either to be sheltered to a limited degree or a short exposure time. Likely to be sufficient lighting.  Still likely to be some exposure to the elements on occasions, with some mitigation by appropriate PPE - so one factor deemed to be present (as per MAC)","GREEN",0,"Assumed to be sufficent space to not constrain lifting/carrying task.  Assumes storage is laid out to enable access and egress.","GREEN",0,"Assumed that carry distance less than 4m","GREEN",0,"Assumed flat surface without acess constraints from platform furniture."]
["7. Outside at vehicular access point","Road-rail access point","AMBER",1,"May be wet surface, but good footwear assumed. Surface contamination (e.g. ice, grease, snow) treated/cleared. May be worn or uneven.","AMBER",1,"Assumed to be short exposure time and sufficient lighting.  Still likely to be some exposure to the elements on occasions, with some mitigation by appropriate PPE - so one factor deemed to be present (as per MAC)","GREEN",0,"Assumed to be sufficent space and width of gate to not constrain lifting/carrying task.","AMBER",1,"Assumed that carry distance more than 4m but less than 10m","GREEN",0,"Assumed flat surface without tripping hazards and space to manouvre"]
["8. Outside, stepped or sloping access","Exterior stairway/ramp, rail access paths","RED",2,"Based on \"steep, sloping floor\" from MAC defintion, which is also taken to include steps","AMBER",1,"Assumed to be either to be comparatively short exposure time. Likely to be sufficient lighting.  Still likely to be some exposure to the elements on occasions, with some mitigation by appropriate PPE - so one factor deemed to be present (as defined in MAC)","GREEN",0,"Assumed to be sufficient space to not constrain lifting/carrying task.  (Note - likely to be some obstacles for carrying, but covered by obstacles en route)","AMBER",1,"Assumed that carry distance more than 4m but less than 10m","AMBER",2,"Sloping surfaces or up/down steps"]
["9. Pedestrian Access Point, Trackside, on track","Personnel access point on to track (through gateway), trackside access paths, on or about the track ","RED",2,"Based on \"unstable surface\"","RED",2,"Could be extensive exposure time with poor lighting and full impact of elements (strong winds, rain/snow)","AMBER",1,"Access gates and trackside walking routes are likely to provide some postural constraints","RED",3,"Carry distance likely to exceed 10m","AMBER",2,"Significant trip hazards and slopes due to ballast shoulder, vegetation, sleepers on track etc"]

{"sheet":"H>Push-Pull Conditions","index":10,"n_rows":17,"n_cols":17,"rows_kept":17,"cut":false,"hidden":false,"merged":[[3,14,3,16],[3,11,3,13],[0,0,1,1],[3,2,3,4],[3,5,3,7],[3,8,3,10]]}
["Pushing/Pulling\nStandardised Conditions"]
[]
[]
["Standardised Location Selection","Typical Locations","Floor surface",null,null,"Other factors *",null,null,"Travel Distance \n(Wheeled equipment)",null,null,"Travel Distance \n(Without wheels)",null,null,"Obstacles en Route "]
["1. Inside building on one floor level","Office or control centre interior space, some stores, equipment room, station concourse or platform area that is undercover","GREEN",0,"Surface assumed to be flat and in good condition","GREEN",0,"Assumed to be dry, reasonable temperature, no strong air movements, good lighting","GREEN",0,"Assumed that travel distance within building generally 10m or less prior to a break (as broken up by using lifts etc)","AMBER",1,"Assumed that travel distance within building generally 10m or less prior to a break (as broken up by using lifts etc)","GREEN",0,"Assumed flat surface and no obstacles en route.  Doors held open by member of team."]
["2. Inside medium sized enclosed van ","Inside a van moving equipment or materials, Transit size","GREEN",0,"Surface assumed to be flat and in good condition. May have ridges in floor, but assumed staff wearing boots with ankle support.","GREEN",0,"Assumed to be dry, no strong air movements, sufficient lighting.","GREEN",0,"Movement distance within van will be 10m or less","GREEN",0,"Movement distance within van will be 2m or less","RED",3,"Assumed flat surface but signficant tripping hazards to be avoided"]
["3. Inside large van or lorry load space ","Inside a large van or back of lorry moving equipment or materials. Tall load space enabling staff to stand upright and stowage for all equipment that allows clear access.","GREEN",0,"Surface assumed to be flat and in good condition. May have ridges in floor, but assumed staff wearing boots with ankle support.","GREEN",0,"Assumed to be dry, no strong air movements, sufficient lighting.","GREEN",0,"Movement distance within van will be 10m or less","AMBER",1,"Movement distance within van may exceed 2m","AMBER",2,"Assumed flat surface but some tripping hazards to be avoided"]
["4. Inside building or under cover, sloping surface","Covered/internal access ramp","AMBER",1,"Based on \"sloping gradient (between 3° and 5°)\"","GREEN",0,"Assumed to be dry, reasonable temperature, no strong air movements, good lighting","AMBER",1,"Assumed that distance to move load if a ramp is provided will be more than 10m but less than 30m","RED",3,"Assumed that distance to move load if a ramp is provided will be more than 10m","GREEN",0,"Assumed gently sloping surface (not a steep ramp), no obstacles"]
["5. Outside in well organised and maintained depot yard","Depot yard (concrete/tarmac surface), good smooth well made surface, external stores well organised.","GREEN",0,"May be wet surface, but good footwear assumed. Surface contamination (e.g. ice, grease, snow) treated/cleared.","AMBER",1,"Assumed to be either to be sheltered to a limited degree or a short exposure time. Likely to be sufficient lighting.  Still likely to be some exposure to the elements on occasions, with some mitigation by appropriate PPE - so one factor deemed to be present (as per MAC)","GREEN",0,"Assumed that travel distance less than or equal to 10m, store to/from vehicle","AMBER",1,"Assumed that travel distance less than or equal to 10m, store to/from vehicle","GREEN",0,"Assumed flat surface without narrow doors/gates/passageways. Assumes good housekeeping of stores to allow access."]
["6. Outside on uncovered platform, station forecourt","Station forecourt, uncovered platform area","GREEN",0,"May be wet surface, but good footwear assumed. Surface contamination (e.g. ice, grease, snow) treated/cleared.","AMBER",1,"Assumed to be either sheltered to a limited degree or a short exposure time. Likely to be sufficient lighting.  Still likely to be some exposure to the elements on occasions, with some mitigation by appropriate PPE - so one factor deemed to be present (as per MAC)","GREEN",0,"Assumed that travel distance less than or equal to 10m","AMBER",1,"Assumed that travel distance could be more than 2m but less than 10m","GREEN",0,"Assumed flat surface without acess constraints from platform furniture."]
["7. Outside at vehicular access point","Road-rail access point","AMBER",1,"May be wet surface, but good footwear assumed. Surface contamination (e.g. ice, grease, snow) treated/cleared. May be worn or uneven.","AMBER",1,"Assumed to be short exposure time and sufficient lighting.  Still likely to be some exposure to the elements on occasions, with some mitigation by appropriate PPE - so one factor deemed to be present (as per MAC)","GREEN",0,"Assumed that travel distance less than or equal to 10m, vehicle to/from track or trackside","AMBER",1,"Assumed that travel distance less than or equal to 10m, vehicle to/from track or trackside","GREEN",0,"Assumed flat surface without tripping hazards and space to manouvre"]
["8. Outside, sloping access ramp","Exterior access ramp","AMBER",1,"Based on \"sloping gradient (between 3° and 5°)\"","AMBER",1,"Assumed to be short exposure time. Likely to be sufficient lighting.  Still likely to be some exposure to the elements on occasions, with some mitigation by appropriate PPE - so one factor deemed to be present (as per MAC)","AMBER",1,"Assumed that distance to move load if a ramp is provided will be more than 10m but less than 30m","RED",3,"Assumed that distance to move load if a ramp is provided will be more than 10m","GREEN",0,"Assumed gently sloping surface (not a steep ramp), no obstacles"]
["9. Outside, steep slope or some steps","Exterior access steps, or steep access slope","RED",4,"Based on wet, \"steep slope (more than 5°)\" or soft/unstable underfoot.","AMBER",1,"Assumed to be short exposure time. Likely to be sufficient lighting.  Still likely to be some exposure to the elements on occasions, with some mitigation by appropriate PPE - so one factor deemed to be present (as per MAC)","AMBER",1,"Assumed that distance to move load up/down a slope or steps will be more than 10m but less than 30m","RED",3,"Assumed that distance to move load up/down a slope or steps will be more than 10m","RED",3,"Includes some steps or a steep ramp."]
["10. Outside at non-vehicular access point","Access on to track or trackside path (through personnel access gateway)","RED",4,"Based on soft/unstable under foot and/or wet","AMBER",1,"Assumed to be short exposure time and sufficient lighting.  Still likely to be some exposure to the elements on occasions, with some mitigation by appropriate PPE - so one factor deemed to be present (as per MAC)","GREEN",0,"Travel distance pushing load on or about track unlikely to exceed 10m","RED",3,"Travel distance pushing load on or about track likely to exceed 2m but not 10m","RED",3,"Ramps with ballast shoulder, through narrow access gate."]
["11. On track","Travel on rail mounted trolley","GREEN",0,"Rail surface good and no steep slopes","RED",2,"Could be extensive exposure time to elements, with poor lighting and full impact of elements (strong winds, rain/snow)","RED",3,"Travel distance likely to exceed 30m","RED",3,"Travel distance likely to exceed 10m","GREEN",0,"No obstacles on track"]
[null,null,"*",null,"Default rating based on Environmental conditions ONLY."]
[null,null,null,null,"Selection of \"load conditions\" increase this rating depending on how many apply."]

{"sheet":"V>Version Log","index":11,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":true,"merged":[[43,0,50,0],[43,1,50,1],[27,0,34,0],[27,1,34,1],[11,2,18,2],[35,0,42,0],[35,1,42,1],[3,0,10,0],[3,1,10,1],[3,2,10,2],[11,1,18,1],[19,1,26,1],[11,0,18,0],[19,0,26,0]]}
["CHANGE LOG"]
[]
["Ver No","Date","Who","Sheet","Changes"]
["5-5","2018-06-05","MC","C>RAPP","Formulae missing to populate summary results - in Colour Code table - added in missing formulae"]
[null,null,null,"C>RAPP","Purple score for load weight corrupted total risk score.  Added PURPLE with score of 100 to PP_SCORES table (PURPLE = stop use now)"]
[null,null,null,"C>RAPP","Added colour code for PURPLE to top row (only) of summary results "]
[null,null,null,"B>MAC","Fixed error in Load Weight Risk table in summary results (cells S:29 to U29)"]
[null,null,null,"B>MAC","Hid row 18"]
[null,null,null,"V>Version","Created version log"]
[null,null,null,"Page layout","Added version number to footer"]
[null,null,null,"A>Details","Added version number to front page"]
["5-6","2018-08-19","MC","B>MAC","Locked cells in summary results section"]
[null,null,null,"C>RAPP","Calculation columns hidden"]
[null,null,null,"B>MAC","Changed conditional formatting to BOLD"]
[null,null,null,"G> LLC","Edit station text to make clear that \"1. Inside building on one floor level\" does not apply to exposed platform areas"]
[null,null,null,"H>PP","Edit station text to make clear that \"1. Inside building on one floor level\" does not apply to exposed platform areas"]