{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["NLE (Single Task)"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":38,"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":"NLE (Single Task)","index":0,"n_rows":75,"n_cols":28,"rows_kept":75,"cut":false,"hidden":false,"merged":[[3,9,3,13],[6,6,7,6],[8,6,9,6],[10,6,11,6],[12,6,13,6],[3,3,3,7],[8,12,9,12],[6,3,7,3],[8,3,9,3],[10,3,11,3],[12,3,13,3],[20,3,21,3],[8,9,9,9],[8,10,9,10],[8,11,9,11],[14,3,15,3],[16,3,17,3],[14,6,15,6],[16,6,17,6],[20,6,21,6],[55,16,55,17],[55,18,55,19],[55,20,55,21],[8,13,9,13],[8,14,9,14],[8,15,9,15]]}
[]
[]
[null,"Analyst",null,"Task"]
[]
[]
[null,null,null,"Origin",null,null,"Destination"]
[null,"Horizontal Location"]
[null,"(min. 10\", max. 25\")"]
[null,"Vertical Location"]
[null,"(min. 0\", max. 70\")"]
[null,"Travel Distance"]
[null,"(min. 10\", max. 70\")"]
[null,"Angle of Asymmetry",null,null,null,null,null,null,null,null,null,null,null,1]
[null,"(min. 0, max. 135)",null,null,null,null,null,null,null,null,null,null,null,2]
[null,"Coupling",null,null,null,null,null,null,null,null,null,null,null,3]
[null,"(1=good | 2=fair | 3=poor)"]
[null,"Frequency"]
[null,"(min. 0.2 lifts/min.)",null,null,null,null,null,null,null,null,null,null,null,1]
[null,"Avg. Load",null,null,null,null,null,null,null,null,null,null,null,2]
[null,"Max Load",null,null,null,null,null,null,null,null,null,null,null,8]
[null,"Duration"]
[null,"(enter 1, 2 or 8)"]
[]
[]
[]
[null,null,null,51,null,null,51]
[null,"Horizontal Multiplier (HM)","x",{"$f":"IF(HorizontalLocation=\"\",\"\",IF((OR(HorizontalLocation<10,HorizontalLocation>25)),\"ERROR\",IF(HorizontalLocation>25.1,0,10/HorizontalLocation)))","v":""},null,"x",{"$f":"IF(destHorizontalLocation=\"\",\"\",IF((OR(destHorizontalLocation<10,destHorizontalLocation>25)),\"ERROR\",IF(destHorizontalLocation>25.1,0,10/destHorizontalLocation)))","v":""}]
[null,"Vertical Multiplier (VM)","x",{"$f":"IF(VerticalLocation=\"\",\"\",IF((OR(VerticalLocation<0,VerticalLocation>70)),\"ERROR\",IF(VerticalLocation<71.1,1-(0.0075*ABS(VerticalLocation-30)),0)))","v":""},null,"x",{"$f":"IF(destVerticalLocation=\"\",\"\",IF((OR(destVerticalLocation<0,destVerticalLocation>70)),\"ERROR\",IF(destVerticalLocation<71.1,1-(0.0075*ABS(destVerticalLocation-30)),0)))","v":""}]
[null,"Distance Multiplier (DM)","x",{"$f":"IF(TravelDistance=\"\",\"\",IF(TravelDistance<10,1,IF(TravelDistance<70.1,0.82+(1.8/TravelDistance),0)))","v":""},null,"x",{"$f":"IF(destTravelDistance=\"\",\"\",IF(destTravelDistance<10,1,IF(destTravelDistance<70.1,0.82+(1.8/destTravelDistance),0)))","v":""}]
[null,"Frequency Multiplier (FM)","x",{"$f":"IF(Frequency=\"\",\"\",VLOOKUP(Frequency,FrequencyMultiplierTable,VLOOKUP(VerticalLocation,Y56:AB58,IF(Duration=8,2,IF(Duration=2,3,4)))))","v":""},null,"x",{"$f":"IF(destFrequency=\"\",\"\",VLOOKUP(destFrequency,FrequencyMultiplierTable,VLOOKUP(destVerticalLocation,Y56:AB58,IF(destDuration=8,2,IF(destDuration=2,3,4)))))","v":""}]
[null,"Angle Multiplier (AM)","x",{"$f":"IF(Angle=\"\",\"\",IF(OR(Angle<0,Angle>135),\"ERROR\",IF(Angle<135.1,1-(0.0032*Angle),0)))","v":""},null,"x",{"$f":"IF(destAngle=\"\",\"\",IF(OR(destAngle<0,destAngle>135),\"ERROR\",IF(destAngle<135.1,1-(0.0032*destAngle),0)))","v":""}]
[null,"Coupling Multiplier (CM)","x",{"$f":"IF(Coupling=\"\",\"\",IF(Coupling=1,1,IF(Coupling=3,0.9,IF(AND(Coupling=2,VerticalLocation<30),0.95,IF(Coupling>3,\"ERROR\",1)))))","v":""},null,"x",{"$f":"IF(destCoupling=\"\",\"\",IF(destCoupling=1,1,IF(destCoupling=3,0.9,IF(AND(destCoupling=2,destVerticalLocation<30),0.95,IF(destCoupling>3,\"ERROR\",1)))))","v":""}]
[]
[null,"Recommended Weight Limit (RWL)",null,{"$f":"51*HM*VM*DM*FM*AM*CM","v":{"$error":"#VALUE!"}},null,null,{"$f":"IF(destavgLoad=\"\",\"\",G26*destHM*destVM*destDM*destFM*destAM*destCM)","v":""}]
[]
[null,"Frequency Independent RWL (FIRWL)",null,{"$f":"IF(avgLoad=\"\",\"\",D26*HM*VM*DM*AM*CM)","v":""},null,null,{"$f":"IF(destavgLoad=\"\",\"\",G26*destHM*destVM*destDM*destAM*destCM)","v":""}]
[]
[null,"Lifting Index (LI)",null,{"$f":"IF(RWL=\"\",\"\",avgLoad/RWL)","v":{"$error":"#VALUE!"}},null,null,{"$f":"IF(destRWL=\"\",\"\",destavgLoad/destRWL)","v":""}]
[]
[null,"Frequency Independent LI (FILI)",null,{"$f":"IF(avgLoad=\"\",\"\",maxLoad/FIRWL)","v":""},null,null,{"$f":"IF(destavgLoad=\"\",\"\",destmaxLoad/destFIRWL)","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Frequency Multiplier Table",null,null,null,null,null,null,null,null,"Vertical Location","Duration"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"8 hours",null,"2 hours",null,"1 hour",null,null,null,null,8,2,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lifts / Min","V < 30","V ≥ 30","V < 30","V ≥ 30","V < 30","V ≥ 30",null,null,0,2,4,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.2,0.85,0.85,0.95,0.95,1,1,null,null,30,3,5,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.5,0.81,0.81,0.92,0.92,0.97,0.97]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,0.75,0.75,0.88,0.88,0.94,0.94,null,null,"Column Lookup"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,0.65,0.65,0.84,0.84,0.91,0.91,null,null,{"$f":"VLOOKUP(VerticalLocation,Y56:AB58,IF(Duration=8,2,IF(Duration=2,3,4)))","v":6}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,0.55000000000000004,0.55000000000000004,0.79,0.79,0.88,0.88]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,0.45,0.45,0.72,0.72,0.84,0.84]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,0.35,0.35,0.6,0.6,0.8,0.8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,0.27,0.27,0.5,0.5,0.75,0.75]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,0.22,0.22,0.42,0.42,0.7,0.7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,0.18,0.18,0.35,0.35,0.6,0.6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,0,0.15,0.3,0.3,0.52,0.52]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,0,0.13,0.26,0.26,0.45,0.45]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,0,0,0,0.23,0.41,0.41]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,0,0,0,0.21,0.37,0.37]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,0,0,0,0,0,0.34]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,0,0,0,0,0,0.31]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,0,0,0,0,0,0.28000000000000003]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"> 15",0,0,0,0,0,0]