{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Calculator","Trans","Specs","Log","Variables","Light-Medium-Heavy Duty","Application Factors","Validation data","PRJ2106"],"not_rendered":{"charts":0,"images":11,"macros":1,"external_links":1,"defined_names":117,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Calculator","index":0,"n_rows":67,"n_cols":22,"rows_kept":67,"cut":false,"hidden":false,"merged":[[27,12,33,12],[27,13,33,13],[27,14,33,14],[27,15,33,15],[27,16,33,16],[20,12,26,12],[20,13,26,13],[20,14,26,14],[20,15,26,15],[20,16,26,16],[10,12,19,12],[10,13,19,13],[10,14,19,14],[10,15,19,15],[10,16,19,16],[2,14,2,16],[3,14,4,14],[3,15,4,15],[3,16,4,16],[5,14,9,14],[5,15,9,15],[5,16,9,16],[55,1,55,3],[43,1,43,3],[39,1,39,3],[34,1,34,3],[6,1,6,3],[40,12,40,16],[41,12,53,16],[1,12,1,16],[65,1,65,3],[66,1,74,3],[2,12,7,13],[8,12,9,13],[1,1,1,3],[57,12,57,16],[58,12,60,13],[58,14,58,16],[60,14,61,14],[60,15,61,15],[60,16,61,16],[61,12,61,13],[2,1,2,3]]}
[]
[null,{"$f":"IF($C$5=Trans!$A$6,Trans!A7, IF($C$5=Trans!$B$6,Trans!B7, IF($C$5=Trans!$C$6,Trans!C7, IF($C$5=Trans!$D$6,Trans!D7,Trans!E7))))","v":"Bleisäurebatterie"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF($C$5=Trans!$A$6,Trans!A86, IF($C$5=Trans!$B$6,Trans!B86, IF($C$5=Trans!$C$6,Trans!C86, IF($C$5=Trans!$D$6,Trans!D86,Trans!E86))))","v":"Anwendungsmatrix"}]
[null,{"$f":"IF($C$5=Trans!$A$6,Trans!A8, IF($C$5=Trans!$B$6,Trans!B8, IF($C$5=Trans!$C$6,Trans!C8, IF($C$5=Trans!$D$6,Trans!D8,Trans!E8))))","v":"Leitfaden zur Verlängerung der Batterielebensdauer"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF($C$5=Trans!$A$6,Trans!A87, IF($C$5=Trans!$B$6,Trans!B87, IF($C$5=Trans!$C$6,Trans!C87, IF($C$5=Trans!$D$6,Trans!D87,Trans!E87))))","v":"In den Matrixkriterien „Arbeitszyklus“ und im Rechner „Ergebnis“ wählen."},null,{"$f":"IF($C$5=Trans!$A$6,Trans!A95, IF($C$5=Trans!$B$6,Trans!B95, IF($C$5=Trans!$C$6,Trans!C95, IF($C$5=Trans!$D$6,Trans!D95,Trans!E95))))","v":"WELCHE LASTEN WERDEN BEFÖRDERT?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($C$5=Trans!$A$6,Trans!A96, IF($C$5=Trans!$B$6,Trans!B96, IF($C$5=Trans!$C$6,Trans!C96, IF($C$5=Trans!$D$6,Trans!D96,Trans!E96))))","v":"Normalerweise leichte Lasten"},{"$f":"IF($C$5=Trans!$A$6,Trans!A97, IF($C$5=Trans!$B$6,Trans!B97, IF($C$5=Trans!$C$6,Trans!C97, IF($C$5=Trans!$D$6,Trans!D97,Trans!E97))))","v":"Leichte bis mittelschwere Lasten"},{"$f":"IF($C$5=Trans!$A$6,Trans!A98, IF($C$5=Trans!$B$6,Trans!B98, IF($C$5=Trans!$C$6,Trans!C98, IF($C$5=Trans!$D$6,Trans!D98,Trans!E98))))","v":"Maximallasten"}]
[null,null,"Deutsch"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($C$5=Trans!$A$6,Trans!A99, IF($C$5=Trans!$B$6,Trans!B99, IF($C$5=Trans!$C$6,Trans!C99, IF($C$5=Trans!$D$6,Trans!D99,Trans!E99))))","v":"Normalerweise weniger als 50 % der Maximallast – gelegentlich Maximallasten"},{"$f":"IF($C$5=Trans!$A$6,Trans!A100, IF($C$5=Trans!$B$6,Trans!B100, IF($C$5=Trans!$C$6,Trans!C100, IF($C$5=Trans!$D$6,Trans!D100,Trans!E100))))","v":"Normalerweise weniger als 75 % der Maximallast – gelegentlich Maximallasten"},{"$f":"IF($C$5=Trans!$A$6,Trans!A101, IF($C$5=Trans!$B$6,Trans!B101, IF($C$5=Trans!$C$6,Trans!C101, IF($C$5=Trans!$D$6,Trans!D101,Trans!E101))))","v":"Häufiges Handling von Lasten bei oder nahe der Maximallast"}]
[null,{"$f":"IF($C$5=Trans!$A$6,Trans!A10, IF($C$5=Trans!$B$6,Trans!B10, IF($C$5=Trans!$C$6,Trans!C10, IF($C$5=Trans!$D$6,Trans!D10,Trans!E10))))","v":"Auswahl Stapler, Batterie und Anwendung"}]
[]
[null,{"$f":"IF($C$5=Trans!$A$6,Trans!A11, IF($C$5=Trans!$B$6,Trans!B11, IF($C$5=Trans!$C$6,Trans!C11, IF($C$5=Trans!$D$6,Trans!D11,Trans!E11))))","v":"Stapler"},null,{"$f":"IF($C$5=Trans!$A$6,Trans!A32, IF($C$5=Trans!$B$6,Trans!B32, IF($C$5=Trans!$C$6,Trans!C32, IF($C$5=Trans!$D$6,Trans!D32,Trans!E32))))","v":"Auswahl"},null,null,null,"Truck",{"$f":"C9","v":0},"Select",null,null,{"$f":"IF($C$5=Trans!$A$6,Trans!A88, IF($C$5=Trans!$B$6,Trans!B88, IF($C$5=Trans!$C$6,Trans!C88, IF($C$5=Trans!$D$6,Trans!D88,Trans!E88))))","v":"FAHR- UND/ODER HYDRAULIKBETRIEB?"}]
[null,{"$f":"IF($C$5=Trans!$A$6,Trans!A13, IF($C$5=Trans!$B$6,Trans!B13, IF($C$5=Trans!$C$6,Trans!C13, IF($C$5=Trans!$D$6,Trans!D13,Trans!E13))))","v":"Batterie"},null,{"$f":"IF($C$5=Trans!$A$6,Trans!A33, IF($C$5=Trans!$B$6,Trans!B33, IF($C$5=Trans!$C$6,Trans!C33, IF($C$5=Trans!$D$6,Trans!D33,Trans!E33))))","v":"Auswahl (Präfix ND = nicht DIN)"},null,{"$f":"IF(C10=\"\", \"INC\", \"OK\")","v":"INC"},null,"Battery",{"$f":"C10","v":0},"Select (Prefix ND = Non DIN)"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($C$5=Trans!$A$6,Trans!A89, IF($C$5=Trans!$B$6,Trans!B89, IF($C$5=Trans!$C$6,Trans!C89, IF($C$5=Trans!$D$6,Trans!D89,Trans!E89))))","v":"Zumeist Stapeln und Beladen mit deutlich mehr Fahr- als Hydraulikbetrieb"},{"$f":"IF($C$5=Trans!$A$6,Trans!A92, IF($C$5=Trans!$B$6,Trans!B92, IF($C$5=Trans!$C$6,Trans!C92, IF($C$5=Trans!$D$6,Trans!D92,Trans!E92))))","v":"Handling und Stapeln in Bodennähe mit Hubhöhen unterhalb von 3 Metern"},{"$f":"IF($C$5=Trans!$A$6,Trans!A102, IF($C$5=Trans!$B$6,Trans!B102, IF($C$5=Trans!$C$6,Trans!C102, IF($C$5=Trans!$D$6,Trans!D102,Trans!E102))))","v":"LEICHTE BEANSPRUCHUNG"},{"$f":"IF($C$5=Trans!$A$6,Trans!A103, IF($C$5=Trans!$B$6,Trans!B103, IF($C$5=Trans!$C$6,Trans!C103, IF($C$5=Trans!$D$6,Trans!D103,Trans!E103))))","v":"MITTLERE BEANSPRUCHUNG"},{"$f":"IF($C$5=Trans!$A$6,Trans!A104, IF($C$5=Trans!$B$6,Trans!B104, IF($C$5=Trans!$C$6,Trans!C104, IF($C$5=Trans!$D$6,Trans!D104,Trans!E104))))","v":"STARKE BEANSPRUCHUNG"}]
[null,{"$f":"IF($C$5=Trans!$A$6,Trans!A111, IF($C$5=Trans!$B$6,Trans!B111, IF($C$5=Trans!$C$6,Trans!C111, IF($C$5=Trans!$D$6,Trans!D111,Trans!E111))))","v":"Betriebsstunden pro Tag"},null,{"$f":"IF($C$5=Trans!$A$6,Trans!A32, IF($C$5=Trans!$B$6,Trans!B32, IF($C$5=Trans!$C$6,Trans!C32, IF($C$5=Trans!$D$6,Trans!D32,Trans!E32))))","v":"Auswahl"}]
[null,{"$f":"IF($C$5=Trans!$A$6,Trans!A112, IF($C$5=Trans!$B$6,Trans!B112, IF($C$5=Trans!$C$6,Trans!C112, IF($C$5=Trans!$D$6,Trans!D112,Trans!E112))))","v":"Pausen- und Staplerstillstandzeiten (Stunden)"},null,{"$f":"IF($C$5=Trans!$A$6,Trans!A32, IF($C$5=Trans!$B$6,Trans!B32, IF($C$5=Trans!$C$6,Trans!C32, IF($C$5=Trans!$D$6,Trans!D32,Trans!E32))))","v":"Auswahl"}]
[null,{"$f":"IF($C$5=Trans!$A$6,Trans!A15, IF($C$5=Trans!$B$6,Trans!B15, IF($C$5=Trans!$C$6,Trans!C15, IF($C$5=Trans!$D$6,Trans!D15,Trans!E15))))","v":"Staplernutzung"},{"$f":"IFERROR((C12-C13)/C12,\"-\")","v":"-"},null,null,null,null,"Truck Utilisation / Shift",{"$f":"C14","v":"-"},"Select"]
[]
[null,{"$f":"IF($C$5=Trans!$A$6,Trans!A80, IF($C$5=Trans!$B$6,Trans!B80, IF($C$5=Trans!$C$6,Trans!C80, IF($C$5=Trans!$D$6,Trans!D80,Trans!E80))))","v":"Arbeitszyklus"},null,{"$f":"IF($C$5=Trans!$A$6,Trans!A34, IF($C$5=Trans!$B$6,Trans!B34, IF($C$5=Trans!$C$6,Trans!C34, IF($C$5=Trans!$D$6,Trans!D34,Trans!E34))))","v":"Auswahl auf Basis der Anwendungsmatrix"},null,{"$f":"IF(C16=\"\", \"INC\", \"OK\")","v":"INC"},null,"Duty Cycle",{"$f":"IF(F16=\"INC\", \"-\", IF(OR(C16=Trans!A81,C16=Trans!B81,C16=Trans!C81,C16=Trans!D81,C16=Trans!E81),Trans!A81,IF(OR(C16=Trans!A82,C16=Trans!B82,C16=Trans!C82,C16=Trans!D82,C16=Trans!E82),Trans!A82,IF(OR(C16=Trans!A83,C16=Trans!B83,C16=Trans!C83,C16=Trans!D83,C16=Trans!E83),Trans!A83,Trans!A84))))","v":"-"},"Select based on application matrix"]
[]
[null,{"$f":"IF($C$5=Trans!$A$6,Trans!A20, IF($C$5=Trans!$B$6,Trans!B20, IF($C$5=Trans!$C$6,Trans!C20, IF($C$5=Trans!$D$6,Trans!D20,Trans!E20))))","v":"Hubgerüsttyp"},null,{"$f":"IF($C$5=Trans!$A$6,Trans!A32, IF($C$5=Trans!$B$6,Trans!B32, IF($C$5=Trans!$C$6,Trans!C32, IF($C$5=Trans!$D$6,Trans!D32,Trans!E32))))","v":"Auswahl"},null,{"$f":"IF(C18=\"\", \"INC\", \"OK\")","v":"INC"},null,"Mast Type",{"$f":"IF(F18=\"INC\", \"-\", C18)","v":"-"},"Select"]
[]
[null,{"$f":"IF($C$5=Trans!$A$6,Trans!A21, IF($C$5=Trans!$B$6,Trans!B21, IF($C$5=Trans!$C$6,Trans!C21, IF($C$5=Trans!$D$6,Trans!D21,Trans!E21))))","v":"Anbaugerät"},null,{"$f":"IF($C$5=Trans!$A$6,Trans!A32, IF($C$5=Trans!$B$6,Trans!B32, IF($C$5=Trans!$C$6,Trans!C32, IF($C$5=Trans!$D$6,Trans!D32,Trans!E32))))","v":"Auswahl"},null,"INC",null,"Attachment",{"$f":"IF(F20=\"INC\", \"-\", IF(OR(C20=Trans!A39,C20=Trans!B39,C20=Trans!C39,C20=Trans!D39,C20=Trans!E39),Trans!A39,Trans!A40))","v":"-"},"Select"]
[null,{"$f":"IF($C$5=Trans!$A$6,Trans!A22, IF($C$5=Trans!$B$6,Trans!B22, IF($C$5=Trans!$C$6,Trans!C22, IF($C$5=Trans!$D$6,Trans!D22,Trans!E22))))","v":"Seitenschub/Gabelzinkenverstellung"},null,{"$f":"IF($C$5=Trans!$A$6,Trans!A32, IF($C$5=Trans!$B$6,Trans!B32, IF($C$5=Trans!$C$6,Trans!C32, IF($C$5=Trans!$D$6,Trans!D32,Trans!E32))))","v":"Auswahl"},null,"INC",null,"Side shift/Fork Positioner",{"$f":"IF(F21=\"INC\", \"-\", IF(OR(C21=Trans!A53,C21=Trans!B53,C21=Trans!C53,C21=Trans!D53,C21=Trans!E53),Trans!A53,IF(OR(C21=Trans!A54,C21=Trans!B54,C21=Trans!C54,C21=Trans!D54,C21=Trans!E54),Trans!A54,Trans!A55)))","v":"-"},"Select",null,null,{"$f":"IF($C$5=Trans!$A$6,Trans!A90, IF($C$5=Trans!$B$6,Trans!B90, IF($C$5=Trans!$C$6,Trans!C90, IF($C$5=Trans!$D$6,Trans!D90,Trans!E90))))","v":"Stapeln sowie Be- oder Entladen von Regalen mit etwa ausgeglichenem Verhältnis zwischen Fahr- und Hydraulikbetrieb"},{"$f":"IF($C$5=Trans!$A$6,Trans!A93, IF($C$5=Trans!$B$6,Trans!B93, IF($C$5=Trans!$C$6,Trans!C93, IF($C$5=Trans!$D$6,Trans!D93,Trans!E93))))","v":"Hubhöhen zumeist unterhalb von 3 Metern – nur gelegentlich größere Hubhöhen"},{"$f":"IF($C$5=Trans!$A$6,Trans!A103, IF($C$5=Trans!$B$6,Trans!B103, IF($C$5=Trans!$C$6,Trans!C103, IF($C$5=Trans!$D$6,Trans!D103,Trans!E103))))","v":"MITTLERE BEANSPRUCHUNG"},{"$f":"IF($C$5=Trans!$A$6,Trans!A104, IF($C$5=Trans!$B$6,Trans!B104, IF($C$5=Trans!$C$6,Trans!C104, IF($C$5=Trans!$D$6,Trans!D104,Trans!E104))))","v":"STARKE BEANSPRUCHUNG"},{"$f":"IF($C$5=Trans!$A$6,Trans!A105, IF($C$5=Trans!$B$6,Trans!B105, IF($C$5=Trans!$C$6,Trans!C105, IF($C$5=Trans!$D$6,Trans!D105,Trans!E105))))","v":"INTENSIVE BEANSPRUCHUNG"}]
[]
[null,{"$f":"IF($C$5=Trans!$A$6,Trans!A23, IF($C$5=Trans!$B$6,Trans!B23, IF($C$5=Trans!$C$6,Trans!C23, IF($C$5=Trans!$D$6,Trans!D23,Trans!E23))))","v":"Kühlhaus"},null,{"$f":"IF($C$5=Trans!$A$6,Trans!A32, IF($C$5=Trans!$B$6,Trans!B32, IF($C$5=Trans!$C$6,Trans!C32, IF($C$5=Trans!$D$6,Trans!D32,Trans!E32))))","v":"Auswahl"},null,"INC",null,"Cold Store",{"$f":"IF(F23=\"INC\", \"-\", IF(OR(C23=Trans!A17,C23=Trans!B17,C23=Trans!C17,C23=Trans!D17,C23=Trans!E17),Trans!A17,Trans!A18))","v":"-"},"Select"]
[null,{"$f":"IF($C$5=Trans!$A$6,Trans!A24, IF($C$5=Trans!$B$6,Trans!B24, IF($C$5=Trans!$C$6,Trans!C24, IF($C$5=Trans!$D$6,Trans!D24,Trans!E24))))","v":"Kategorie Kühlhaus"},null,{"$f":"IF($C$5=Trans!$A$6,Trans!A35, IF($C$5=Trans!$B$6,Trans!B35, IF($C$5=Trans!$C$6,Trans!C35, IF($C$5=Trans!$D$6,Trans!D35,Trans!E35))))","v":"Auswahl nur mit Kühlhaus"},null,"INC",null,"Cold Store Category",{"$f":"IF(F24=\"INC\",\"-\",IF(OR(C24=Trans!A43,C24=Trans!B43,C24=Trans!C43,C24=Trans!D43,C24=Trans!E43),Trans!A43,Trans!A44))","v":"-"},"Select only if Cold Store = Yes",null,null,null,null,null,null,null,null," "]
[]
[null,{"$f":"IF($C$5=Trans!$A$6,Trans!A25, IF($C$5=Trans!$B$6,Trans!B25, IF($C$5=Trans!$C$6,Trans!C25, IF($C$5=Trans!$D$6,Trans!D25,Trans!E25))))","v":"Rampe"},null,{"$f":"IF($C$5=Trans!$A$6,Trans!A32, IF($C$5=Trans!$B$6,Trans!B32, IF($C$5=Trans!$C$6,Trans!C32, IF($C$5=Trans!$D$6,Trans!D32,Trans!E32))))","v":"Auswahl"},null,"INC",null,"Ramp",{"$f":"IF(F26=\"INC\", \"-\", IF(OR(C26=Trans!A17,C26=Trans!B17,C26=Trans!C17,C26=Trans!D17,C26=Trans!E17),Trans!A17,Trans!A18))","v":"-"},"Select"]
[null,{"$f":"IF($C$5=Trans!$A$6,Trans!A26, IF($C$5=Trans!$B$6,Trans!B26, IF($C$5=Trans!$C$6,Trans!C26, IF($C$5=Trans!$D$6,Trans!D26,Trans!E26))))","v":"Länge"},null,{"$f":"IF($C$5=Trans!$A$6,Trans!A36, IF($C$5=Trans!$B$6,Trans!B36, IF($C$5=Trans!$C$6,Trans!C36, IF($C$5=Trans!$D$6,Trans!D36,Trans!E36))))","v":"Auswahl nur mit Rampe"},null,"INC",null,"Length",{"$f":"IF(F27=\"INC\", \"-\", C27)","v":"-"},"Select only  if ramp = Yes"]
[null,{"$f":"IF($C$5=Trans!$A$6,Trans!A27, IF($C$5=Trans!$B$6,Trans!B27, IF($C$5=Trans!$C$6,Trans!C27, IF($C$5=Trans!$D$6,Trans!D27,Trans!E27))))","v":"Gefälle"},null,{"$f":"IF($C$5=Trans!$A$6,Trans!A36, IF($C$5=Trans!$B$6,Trans!B36, IF($C$5=Trans!$C$6,Trans!C36, IF($C$5=Trans!$D$6,Trans!D36,Trans!E36))))","v":"Auswahl nur mit Rampe"},null,"INC",null,"Gradient",{"$f":"IF(F28=\"INC\", \"-\", C28)","v":"-"},"Select only  if ramp = Yes",null,null,{"$f":"IF($C$5=Trans!$A$6,Trans!A91, IF($C$5=Trans!$B$6,Trans!B91, IF($C$5=Trans!$C$6,Trans!C91, IF($C$5=Trans!$D$6,Trans!D91,Trans!E91))))","v":"Stapeln sowie Be- oder Entladen mit längeren Zeiten für das Handling von Lasten in der Höhe"},{"$f":"IF($C$5=Trans!$A$6,Trans!A94, IF($C$5=Trans!$B$6,Trans!B94, IF($C$5=Trans!$C$6,Trans!C94, IF($C$5=Trans!$D$6,Trans!D94,Trans!E94))))","v":"Hubhöhen zumeist oberhalb von 3 Metern"},{"$f":"IF($C$5=Trans!$A$6,Trans!A104, IF($C$5=Trans!$B$6,Trans!B104, IF($C$5=Trans!$C$6,Trans!C104, IF($C$5=Trans!$D$6,Trans!D104,Trans!E104))))","v":"STARKE BEANSPRUCHUNG"},{"$f":"IF($C$5=Trans!$A$6,Trans!A105, IF($C$5=Trans!$B$6,Trans!B105, IF($C$5=Trans!$C$6,Trans!C105, IF($C$5=Trans!$D$6,Trans!D105,Trans!E105))))","v":"INTENSIVE BEANSPRUCHUNG"},{"$f":"IF($C$5=Trans!$A$6,Trans!A105, IF($C$5=Trans!$B$6,Trans!B105, IF($C$5=Trans!$C$6,Trans!C105, IF($C$5=Trans!$D$6,Trans!D105,Trans!E105))))","v":"INTENSIVE BEANSPRUCHUNG"}]
[null,{"$f":"IF($C$5=Trans!$A$6,Trans!A28, IF($C$5=Trans!$B$6,Trans!B28, IF($C$5=Trans!$C$6,Trans!C28, IF($C$5=Trans!$D$6,Trans!D28,Trans!E28))))","v":"Nutzungshäufigkeit"},null,{"$f":"IF($C$5=Trans!$A$6,Trans!A36, IF($C$5=Trans!$B$6,Trans!B36, IF($C$5=Trans!$C$6,Trans!C36, IF($C$5=Trans!$D$6,Trans!D36,Trans!E36))))","v":"Auswahl nur mit Rampe"},null,"INC",null,"Frequency used",{"$f":"IF(F29=\"INC\", \"-\", IF(OR(C29=Trans!A49,C29=Trans!B49,C29=Trans!C49,C29=Trans!D49,C29=Trans!E49),Trans!A49,IF(OR(C29=Trans!A50,C29=Trans!B50,C29=Trans!C50,C29=Trans!D50,C29=Trans!E50),Trans!A50,Trans!A51)))","v":"-"},"Select only  if ramp = Yes"]
[]
[null,{"$f":"IF($C$5=Trans!$A$6,Trans!A29, IF($C$5=Trans!$B$6,Trans!B29, IF($C$5=Trans!$C$6,Trans!C29, IF($C$5=Trans!$D$6,Trans!D29,Trans!E29))))","v":"Elektr. Zusatzfunktionen, Beleuchtung etc."},null,{"$f":"IF($C$5=Trans!$A$6,Trans!A32, IF($C$5=Trans!$B$6,Trans!B32, IF($C$5=Trans!$C$6,Trans!C32, IF($C$5=Trans!$D$6,Trans!D32,Trans!E32))))","v":"Auswahl"},null,"INC",null,"Aux Electrics, Lights etc.…",{"$f":"IF(F31=\"INC\", \"-\", IF(OR(C31=Trans!A17,C31=Trans!B17,C31=Trans!C17,C31=Trans!D17,C31=Trans!E17),Trans!A17,Trans!A18))","v":"-"},"Select"]
[null,{"$f":"IF($C$5=Trans!$A$6,Trans!A30, IF($C$5=Trans!$B$6,Trans!B30, IF($C$5=Trans!$C$6,Trans!C30, IF($C$5=Trans!$D$6,Trans!D30,Trans!E30))))","v":"Kabinenheizung"},null,{"$f":"IF($C$5=Trans!$A$6,Trans!A32, IF($C$5=Trans!$B$6,Trans!B32, IF($C$5=Trans!$C$6,Trans!C32, IF($C$5=Trans!$D$6,Trans!D32,Trans!E32))))","v":"Auswahl"},null,"INC",null,"Cab Heater",{"$f":"IF(F32=\"INC\", \"-\", IF(OR(C32=Trans!A17,C32=Trans!B17,C32=Trans!C17,C32=Trans!D17,C32=Trans!E17),Trans!A17,Trans!A18))","v":"-"},"Select"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[null,{"$f":"IF($C$5=Trans!$A$6,Trans!A57, IF($C$5=Trans!$B$6,Trans!B57, IF($C$5=Trans!$C$6,Trans!C57, IF($C$5=Trans!$D$6,Trans!D57,Trans!E57))))","v":"Energieverbrauch Staplergrundmodell"},null,null,null,"To hide"]
[null,"Truck Capacity",{"$f":"IFERROR(INDEX(Specs!B3:B33, MATCH(Calculator!I9,TRUCKS, 0)), \"-\")","v":"-"},"Tons",null,"To hide",null,"Truck Capacity",null,"Tons"]
[null,"E-Lo  Base Duty Cycle Consumption",{"$f":"IF(F16=\"OK\", INDEX(INDEXarea,MATCH(Calculator!I9,TRUCKS, 0),MATCH(Calculator!I16,MATCHCOLUMNS,0)), \"-\")","v":"-"},"kWh/h",null,"To hide",null,"E-Lo  Base Duty Cycle Consumption",null,"kWh/h",null,null," "]
[null,"Hip  Base Duty Cycle Consumption",{"$f":"IF(F16=\"OK\", INDEX(INDEXAREA_HIP,MATCH(Calculator!I9,TRUCKS, 0),MATCH(Calculator!I16,MATCHCOLUMNS_HIP,0)), \"-\")","v":"-"},"kWh/h",null,"To hide",null,"Hip  Base Duty Cycle Consumption",null,"kWh/h"]
[]
[null,{"$f":"IF($C$5=Trans!$A$6,Trans!A61, IF($C$5=Trans!$B$6,Trans!B61, IF($C$5=Trans!$C$6,Trans!C61, IF($C$5=Trans!$D$6,Trans!D61,Trans!E61))))","v":"Anwendungsenergieverbrauch"}]
[null,{"$f":"IF($C$5=Trans!$A$6,Trans!A62, IF($C$5=Trans!$B$6,Trans!B62, IF($C$5=Trans!$C$6,Trans!C62, IF($C$5=Trans!$D$6,Trans!D62,Trans!E62))))","v":"E-Lo-Leistung"},{"$f":"IF(AND(F16=\"OK\",F18=\"OK\",F20=\"OK\",F21=\"OK\",F23=\"OK\",F26=\"OK\",F31=\"OK\",F32=\"OK\"),IFERROR(C37+(C37*(INDEX(Variables!B30:B31,MATCH(Calculator!I20,Attachment,0))))+(C37*(INDEX(Variables!B80:B82,MATCH(I21,Side,0))))+(C37*(INDEX(Variables!B88:B90,MATCH(I18,Mast_Type,0))))+IF(I26=\"Yes\",(C37*(INDEX(Variables!B60:B64,MATCH(I27,Length,0))))+(C37*(INDEX(Variables!B74:B76,MATCH(I28,Gradient,0))))+(C37*(INDEX(Variables!B68:B70,MATCH(I29,Frequency,0)))),0)+(IF(I31=\"Yes\",INDEX(Variables!B93:B95,MATCH(I31,Aux_Elec,0))))+(IF(I32=\"Yes\",INDEX(CAB_HEATER_COL,MATCH(Calculator!I9,TRUCKS,0)))),\"-\"),\"-\")","v":"-"},"kWh/h",null,null,null,null,{"$f":"IF(AND(F16=\"OK\",F18=\"OK\",F20=\"OK\",F21=\"OK\",F23=\"OK\",F26=\"OK\",F31=\"OK\",F32=\"OK\"),IFERROR(C37+(C37*(INDEX(Variables!B30:B31,MATCH(Calculator!I20,Attachment,0))))+(C37*(INDEX(Variables!B80:B82,MATCH(I21,Side,0))))+(C37*(INDEX(Variables!B88:B90,MATCH(I18,Mast_Type,0))))+IF(I26=\"Yes\",(C37*(INDEX(Variables!B60:B64,MATCH(I27,Length,0))))+(C37*(INDEX(Variables!B74:B76,MATCH(I28,Gradient,0))))+(C37*(INDEX(Variables!B68:B70,MATCH(I29,Frequency,0)))),0)+(IF(I31=\"Yes\",INDEX(Variables!B93:B95,MATCH(I31,Aux_Elec,0))))+(IF(I32=\"Yes\",INDEX(CAB_HEATER_COL,MATCH(Calculator!I9,TRUCKS,0)))),\"-\"),\"-\")","v":"-"},null,null,null,{"$f":"IF($C$5=Trans!$A$6,Trans!A115, IF($C$5=Trans!$B$6,Trans!B115, IF($C$5=Trans!$C$6,Trans!C115, IF($C$5=Trans!$D$6,Trans!D115,Trans!E115))))","v":"Anleitung"}]
[null,{"$f":"IF($C$5=Trans!$A$6,Trans!A63, IF($C$5=Trans!$B$6,Trans!B63, IF($C$5=Trans!$C$6,Trans!C63, IF($C$5=Trans!$D$6,Trans!D63,Trans!E63))))","v":"HiP-Leistung"},{"$f":"IF(AND(F16=\"OK\",F18=\"OK\",F20=\"OK\",F21=\"OK\",F23=\"OK\",F26=\"OK\",F31=\"OK\",F32=\"OK\"),IFERROR(C38+(C38*(INDEX(Variables!B30:B31,MATCH(Calculator!I20,Attachment,0))))+(C38*(INDEX(Variables!B80:B82,MATCH(I21,Side,0))))+(C38*(INDEX(Variables!B88:B90,MATCH(I18,Mast_Type,0))))+IF(I26=\"Yes\",(C38*(INDEX(Variables!B60:B64,MATCH(I27,Length,0))))+(C38*(INDEX(Variables!B74:B76,MATCH(I28,Gradient,0))))+(C38*(INDEX(Variables!B68:B70,MATCH(I29,Frequency,0)))),0)+(IF(I31=\"Yes\",INDEX(Variables!B93:B95,MATCH(I31,Aux_Elec,0))))+(IF(I32=\"Yes\",INDEX(CAB_HEATER_COL,MATCH(Calculator!I9,TRUCKS,0)))),\"-\"),\"-\")","v":"-"},"kWh/h",null,null,null,null,null,null,null,null,{"$f":"IF($C$5=Trans!$A$6,Trans!A116, IF($C$5=Trans!$B$6,Trans!B116, IF($C$5=Trans!$C$6,Trans!C116, IF($C$5=Trans!$D$6,Trans!D116,Trans!E116))))","v":"Der Bleibatterie – Ladezustands - Rechner ist in der Lage Ihnen den erwarteten Batterieverbrauch der Gegengewichtsgabelstapler in bestimmten Anwendungen auszurechnen und die für Sie optimale Batteriegröße für Ihren Einsatz wiederzugeben.\n\nBitte wählen Sie zunächste Ihre Sprache in Spalte „C5“. Danach nutzen Sie bitte die Auswahlmöglichkeiten in Spalte „C“ und den Stapler und den Einsatz zu konfigurieren. In Spalte „D“ sehen Sie die zwangsläufig benötigten Teile, zusammen mit einer kleinen Beschreibung in roter Schrift.\n\nSobald Sie alle benötigten Felder ausgefüllt haben, werden Sie eine Zusammenfassung sehen und die für Sie vorgeschlagende Batteriegröße."}]
[]
[null,{"$f":"IF($C$5=Trans!$A$6,Trans!A67, IF($C$5=Trans!$B$6,Trans!B67, IF($C$5=Trans!$C$6,Trans!C67, IF($C$5=Trans!$D$6,Trans!D67,Trans!E67))))","v":"Geschätzte Batterielebensdauer"}]
[null,"V",{"$f":"IFERROR(INDEX(Variables!B2:B25, MATCH(Calculator!C10,Variables!A2:A25, 0)), \"-\")","v":"-"},null,null,"To hide",null,null,null,null,null,"Hide this row in final calculator"]
[null,"Ah",{"$f":"IFERROR(INDEX(Variables!C2:C25, MATCH(Calculator!C10,Variables!A2:A25, 0)),\"-\")","v":"-"},null,null,"To hide",null,null,null,null,null,"Hide this row in final calculator"]
[null,"Watt hours",{"$f":"IFERROR(C45*C46, \"-\")","v":"-"},null,null,"To hide",null,null,null,null,null,"Hide this row in final calculator"]
[null,"kWh",{"$f":"IFERROR((C47/1000)*(C50*(1-IF(I23=\"Yes\",INDEX(Variables!B39:B41,MATCH(I24,COLD,0))))), \"-\")","v":"-"},"based on 80% discharge",null,"To hide",null,null,null,null,null,"Hide this row in final calculator"]
[null,"kWh",{"$f":"IFERROR(C48*(1-DegradationIndex), \"-\")","v":"-"},"Incl. 15% battery degradation",null,"To hide",null,null,null,null,null,"Hide this row in final calculator"]
[null,{"$f":"IF($C$5=Trans!$A$6,Trans!A73, IF($C$5=Trans!$B$6,Trans!B73, IF($C$5=Trans!$C$6,Trans!C73, IF($C$5=Trans!$D$6,Trans!D73,Trans!E73))))","v":"Entladung"},0.8,null,null,"To hide",null,null,null,null,null,"Hide this row in final calculator"]
[null,null,null,null,null,"To hide",null,null,null,null,null,"Hide this row in final calculator"]
[null,{"$f":"IF($C$5=Trans!$A$6,Trans!A113, IF($C$5=Trans!$B$6,Trans!B113, IF($C$5=Trans!$C$6,Trans!C113, IF($C$5=Trans!$D$6,Trans!D113,Trans!E113))))","v":"Anwendungsanforderung"},{"$f":"IFERROR(C12, \"-\")","v":0},{"$f":"IF($C$5=Trans!$A$6,Trans!A78, IF($C$5=Trans!$B$6,Trans!B78, IF($C$5=Trans!$C$6,Trans!C78, IF($C$5=Trans!$D$6,Trans!D78,Trans!E78))))","v":"Stunden"}]
[null,{"$f":"IF($C$5=Trans!$A$6,Trans!A62, IF($C$5=Trans!$B$6,Trans!B62, IF($C$5=Trans!$C$6,Trans!C62, IF($C$5=Trans!$D$6,Trans!D62,Trans!E62))))","v":"E-Lo-Leistung"},{"$f":"IFERROR(C49/(C41*C14), \"-\")","v":"-"},{"$f":"IF($C$5=Trans!$A$6,Trans!A78, IF($C$5=Trans!$B$6,Trans!B78, IF($C$5=Trans!$C$6,Trans!C78, IF($C$5=Trans!$D$6,Trans!D78,Trans!E78))))","v":"Stunden"}]
[null,{"$f":"IF($C$5=Trans!$A$6,Trans!A63, IF($C$5=Trans!$B$6,Trans!B63, IF($C$5=Trans!$C$6,Trans!C63, IF($C$5=Trans!$D$6,Trans!D63,Trans!E63))))","v":"HiP-Leistung"},{"$f":"IFERROR(C49/(C42*C14),\"-\")","v":"-"},{"$f":"IF($C$5=Trans!$A$6,Trans!A78, IF($C$5=Trans!$B$6,Trans!B78, IF($C$5=Trans!$C$6,Trans!C78, IF($C$5=Trans!$D$6,Trans!D78,Trans!E78))))","v":"Stunden"}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"APPLICATION MATRIX"]
[null,null,null," ",null,null,null,null,null,null,null,null,"Choose duty cycle from the matrix criterea and enter result in the calculator",null,"WHAT LOADS ARE HANDLED?"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Application Factors'!C7","v":"Generally Light Loads"},{"$f":"'Application Factors'!C8","v":"Light to Medium Loads"},{"$f":"'Application Factors'!C9","v":"Capacity Loads"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Application Factors'!D7","v":"Generally less than 50% capacity occasional capacity loads"},{"$f":"'Application Factors'!D8","v":"Generally less than 75% capacity occasional capacity loads"},{"$f":"'Application Factors'!D9","v":"Often Handling loads at or close to capacity"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"TRAVEL Vs. HYDRAULICS OPERATION?"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Application Factors'!C11","v":"Generally Stacking and Loading - signficantly more travel than lifting"},{"$f":"'Application Factors'!D11","v":"Ground Handling and stacking -  Lifts below 3m"}," VERY LIGHT DUTY","LIGHT  DUTY","MEDIUM DUTY"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Application Factors'!C13","v":"Stacking and loading or unloading with significant time handling loads at height"},{"$f":"'Application Factors'!D12","v":"Most Lifts below 3 m but with occasional higher lifts"},"LIGHT DUTY","MEDIUM DUTY","HEAVY DUTY"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Application Factors'!C13","v":"Stacking and loading or unloading with significant time handling loads at height"},{"$f":"'Application Factors'!D13","v":"Signficant High Lifting "},"MEDIUM DUTY","HEAVY DUTY","HEAVY DUTY"]
[null,{"$f":"IF($C$5=Trans!$A$6,Trans!A107, IF($C$5=Trans!$B$6,Trans!B107, IF($C$5=Trans!$C$6,Trans!C107, IF($C$5=Trans!$D$6,Trans!D107,Trans!E107))))","v":"HAFTUNGSAUSSCHLUSS"}]
[null,{"$f":"IF($C$5=Trans!$A$6,Trans!A109, IF($C$5=Trans!$B$6,Trans!B109, IF($C$5=Trans!$C$6,Trans!C109, IF($C$5=Trans!$D$6,Trans!D109,Trans!E109))))","v":"DIESES TOOL VON HYG ZUR VERLÄNGERUNG DER LEBENSDAUER VON BLEISÄUREBATTERIEN VERWENDET GENERISCHE UND TECHNISCHE DATEN DER HYSTER-YALE GROUP (HYG) UND IHREN ZULIEFERERN ZUR MODELLIERUNG DER LEBENSDAUER VON BLEISÄUREBATTERIEN IN VON HYG BEREITGESTELLTEN FLURFÖRDERZEUGEN. DAS TOOL BERECHNET DIE LEISTUNG VON FLURFÖRDERZEUGEN IN TYPISCHEN FLURFÖRDERANWENDUNGEN AUF GRUNDLAGE VON BENUTZEREINGABEN. OBWOHL SICH HYG BEMÜHT HAT, DIE GENAUIGKEIT DER ERGEBNISSE SICHERZUSTELLEN, KANN HYG KEINERLEI GARANTIE FÜR DIE GENAUIGKEIT ODER EIGNUNG DER ERMITTELTEN ERGEBNISSE FÜR SPEZIFISCHE KUNDEN ODER ANWENDUNGEN ÜBERNEHMEN. DARÜBER HINAUS HÄNGT DIE LEISTUNG DES TOOLS VON DER VOLLSTÄNDIGKEIT UND DER GENAUIGKEIT DER BENUTZEREINGABEN AB. DIE VON DEM TOOL ERMITTELTEN ERGEBNISSE KÖNNEN DURCH VERWENDUNG UNVOLLSTÄNDIGER ODER UNGENAUER EINGABEN BEEINTRÄCHTIGT WERDEN. DAS TOOL STELLT NUR SCHÄTZUNGEN BEREIT. ES DARF NICHT ZUR GENAUEN PROGNOSE ODER VORHERSAGE VON ERGEBNISSEN IN TATSÄCHLICH GENUTZTEN FLURFÖRDERZEUGEN VERWENDET WERDEN. HYG LEHNT AUSDRÜCKLICH UND OHNE EINSCHRÄNKUNG JEGLICHE HAFTUNG FÜR DIREKTE ODER INDIREKTE SCHÄDEN ODER VERLUSTE ALLER ART AB, WELCHE SICH MÖGLICHERWEISE DURCH DIE NUTZUNG ODER BERUFUNG AUF ERGEBNISSE DES TOOLS VON HYG ZUR VERLÄNGERUNG DER BATTERIELEBENSDAUER ERGEBEN KÖNNTEN. "}]

{"sheet":"Trans","index":1,"n_rows":116,"n_cols":5,"rows_kept":116,"cut":false,"hidden":true,"merged":[]}
["Translations"]
[]
[]
[]
[]
["English","Deutsch","Français","Español","Italiano"]
["Lead Acid Battery","Bleisäurebatterie","Batterie au plomb","Batería de Ácido Plomo","Batteria al piombo acido"]
["Battery Duration Guide","Leitfaden zur Verlängerung der Batterielebensdauer","Guide d'évaluation de la durée d'une batterie","Guía de Duración de la Batería","Guida durata delle batterie"]
[]
["Truck, Battery and Application Selection","Auswahl Stapler, Batterie und Anwendung","Sélection du chariot, de la batterie et de l'application","Selección de Carretilla, Batería y Aplicación","Selezione carrello elevatore, batteria e applicazione"]
["Truck","Stapler","Chariot","Carretilla","Carrello elevatore"]
["Trucks","Stapler","Chariots","Carretillas","Carrelli elevatori"]
["Battery","Batterie","Batterie","Batería","Batteria"]
[]
["Truck Utilisation","Staplernutzung","Utilisation du chariot","Utilización de la Carretilla","Utilizzo del carrello elevatore"]
[]
["Yes","Ja","Oui","Sí","Sì"]
["No","Nein","Non","No","No"]
[]
["Mast Type","Hubgerüsttyp","Type de mât","Tipo de Mástil","Tipo montante"]
["Attachment","Anbaugerät","Accessoire ","Accesorio","Attrezzatura"]
["Side Shift/Fork Positioner","Seitenschub/Gabelzinkenverstellung","Déplacement latéral/positionneur de fourches","Desplazamiento Lateral/Posicionador de Horquillas","Traslatore/Posizionatore forca"]
["Cold Store","Kühlhaus","Chambre froide","Almacenamiento en Frío","Cella frigo"]
["Cold Store Category","Kategorie Kühlhaus","Catégorie de chambre froide","Categoría de Almacenamiento en Frío","Categoria per celle frigo"]
["Ramp","Rampe","Rampe","Rampa","Rampa"]
["Length","Länge","Longueur","Longitud","Lunghezza"]
["Gradient","Gefälle","Pente","Gradiente","Pendenza"]
["Frequency used","Nutzungshäufigkeit","Fréquence d'utilisation","Frecuencia de utilización","Frequenza di utilizzo"]
["Aux Electrics, Lights etc.…","Elektr. Zusatzfunktionen, Beleuchtung etc.","Fonctions électriques aux., éclairages, etc.","Electricidad Aux, Luces, etc.","Dispositivi elettrici ausiliari, Luci, ecc.…"]
["Cab Heater","Kabinenheizung","Chauffage de cabine","Calefactor de Cabina","Riscaldatore cabina"]
[]
["Select","Auswahl","Sélectionner","Seleccionar","Seleziona"]
["Select (Prefix ND = Non DIN)","Auswahl (Präfix ND = nicht DIN)","Sélectionner (préfixe ND = Non-DIN)","Seleccionar (Prefijo ND = No DIN)","Seleziona (Prefisso ND = Non DIN)"]
["Select based on application matrix","Auswahl auf Basis der Anwendungsmatrix","Sélectionner sur la base de la matrice de l'application","Seleccionar basándose en la matriz de aplicaciones","Seleziona in base alla matrice dell'applicazione"]
["Select only with Cold Store","Auswahl nur mit Kühlhaus","Sélectionner uniquement avec chambre froide","Seleccionar solamente con Almacenamiento en Frío","Seleziona solo con Cella frigo"]
["Select only with Ramp","Auswahl nur mit Rampe","Sélectionner uniquement avec rampe","Seleccionar solamente con Rampa","Seleziona solo con rampa"]
[]
["Attachment","Anbaugerät","Accessoire","Accesorio","Attrezzatura"]
["Clamp / Rotator","Klammer/Drehvorrichtung","Accessoire de serrage/accessoire rotatif","Pinza / Rotador","Pinza / Dispositivo di rotazione"]
["No","Nein","Non","No","No"]
[]
["Cold Store","Kühlhaus","Chambre froide","Almacenamiento en Frío","Cella frigo"]
["Chilled store","Gekühltes Lager","Chambre réfrigérée","Almacenamiento Refrigerado","Magazzino refrigerato"]
["Sub zero freezer","Tiefkühllager","Chambre ultra-froide","Congelador bajo cero","Cella frigorifera sotto zero"]
["No","Nein","Non","No","No"]
[]
["Ramp","Rampe","Rampe","Rampa","Rampa"]
["Frequency","Häufigkeit","Fréquence","Frecuencia","Frequenza"]
["Continuous","Kontinuierlich","En continu","Continua","Continuamente"]
["Sometimes","Gelegentlich","Quelquefois","Algunas veces","Talvolta"]
["Rarely","Selten","Rarement","Raramente","Raramente"]
[]
["Side Shift & Fork Positioner","Seitenschub und Gabelzinkenverstellung","Déplacement latéral et positionneur de fourches","Desplazamiento Lateral y Posicionador de Horquillas","Traslatore e posizionatore forca"]
["Side Shift","Seitenschub","Déplacement latéral","Desplazamiento Lateral","Traslatore"]
["No","Nein","Non","No","No"]
[]
["Basic Truck Energy Consumption","Energieverbrauch Staplergrundmodell","Consommation énergétique du chariot de base","Consumo de Energía de la Carretilla Básica","Consumo energetico di base del carrello elevatore"]
["Truck Capacity","Staplertragfähigkeit","Capacité du chariot","Capacidad de la Carretilla","Portata carrello"]
["E-Lo Base Duty Cycle Consumption","Energieverbrauch für Basisarbeitszyklus im E-Lo-Modus","Consommation en cycle d'utilisation base E-Lo","Consumo en Ciclo de Trabajo Base E-Lo","Consumo con ciclo di lavoro base E-Lo"]
["Hip Base Duty Cycle Consumption","Energieverbrauch für Basisarbeitszyklus im HiP-Modus","Consommation en cycle d'utilisation base HiP","Consumo en Ciclo de Trabajo Base Hip","Consumo con ciclo di lavoro base Hip"]
["Application Consumption","Anwendungsenergieverbrauch","Consommation pour l'application","Consumo de la Aplicación","Consumo applicazione"]
["E-Lo Performance","E-Lo-Leistung","Performances E-Lo","Rendimiento E-Lo","Prestazione E-Lo"]
["HiP Performance","HiP-Leistung","Performances HiP","Rendimiento HiP ","Prestazione HiP"]
[]
["Tons","Tonnen","Tonnes","Toneladas","Tonnellate"]
[]
["Estimated Battery Duration","Geschätzte Batterielebensdauer","Durée estimée de la batterie","Duración Estimada de la Batería","Durata stimata della batteria"]
["V","V","V","V","V"]
["Ah","Ah","Ah","Ah","Ah"]
["Watt hours","Wattstunden","Watts/heure","Vatios hora","Wattora"]
["kWh","kWh","kWh","kWh","kWh"]
["kWh","kWh","kWh","kWh","kWh"]
["Discharge","Entladung","Décharge","Descarga","Scarica"]
[]
["based on 80% discharge","basierend auf 80 % Entladung","Sur la base de 80 % de décharge","basándose en un 80% de descarga","in base all'80% di scarica"]
["Incl. 15% battery degradation","einschl. 15 % Batteriealterung","Inclut une dégradation de 15 % de la batterie","Incl. un 15% de degradación de la batería","Compr. il 15% di degrado della batteria"]
[]
["Hours","Stunden","Heures","Horas","Ore"]
[]
["Duty Cycle","Arbeitszyklus","Cycle d'utilisation","Ciclo de Trabajo","Ciclo di lavoro"]
["Light Duty","Leichte Beanspruchung","Application légère","Trabajo Ligero ","Lavoro leggero"]
["Medium Duty","Mittlere Beanspruchung","Application moyennement ardue","Trabajo Medio ","Lavoro mediamente gravoso"]
["Heavy Duty","Schwere Beanspruchung","Application ardue","Trabajo Fuerte","Lavoro altamente gravoso"]
["Intensive Duty","Intensive Beanspruchung","Application intensive","Trabajo Intensivo","Lavoro intensivo"]
[]
["Application Matrix","Anwendungsmatrix","Matrice De L'Application","Matriz De Aplicaciones","Matrice Applicazione"]
["Choose duty cycle from the matrix criteria and select result in the calculator","In den Matrixkriterien „Arbeitszyklus“ und im Rechner „Ergebnis“ wählen.","Choisissez type d'application à partir des critères de la matrice et sélectionnez le résultat dans le calculateur","Elija un ciclo de trabajo en los criterios de la matriz y seleccione el resultado en la calculadora","Scegliere il ciclo di lavoro dai criteri della matrice e selezionare il risultato nel calcolatore"]
["TRAVEL Vs. HYDRAULICS OPERATION?","FAHR- UND/ODER HYDRAULIKBETRIEB?","DÉPLACEMENT OU UTILISATION DE L'HYDRAULIQUE ?","¿DESPLAZAMIENTO DEL VEHÍCULO FRENTE A FUNCIONAMIENTO DE LOS HIDRÁULICOS?","MARCIA RISPETTO AL FUNZIONAMENTO IDRAULICO?"]
["Generally Stacking and Loading - signficantly more travel than lifting","Zumeist Stapeln und Beladen mit deutlich mehr Fahr- als Hydraulikbetrieb","En général, gerbage et chargement, avec beaucoup plus de déplacements que de levées","Generalmente Apilado y Carga - significativamente más desplazamiento que elevación","Stoccaggio e carico in generale - notevolmente più marcia che sollevamento"]
["Stacking and loading or unloading racking with similar amounts of travel and hydraulic work","Stapeln sowie Be- oder Entladen von Regalen mit etwa ausgeglichenem Verhältnis zwischen Fahr- und Hydraulikbetrieb","Gerbage et chargement ou déchargement de rayonnages avec autant de déplacements que de fonctionnement hydraulique","Apilado y carga o descarga de estanterías con una cantidad similar de desplazamiento y de trabajo hidráulico","Stoccaggio e carico o scarico rastrelliere con quantità simili di marcia e funzionamento idraulico"]
["Stacking and loading or unloading with significant time handling loads at height","Stapeln sowie Be- oder Entladen mit längeren Zeiten für das Handling von Lasten in der Höhe","Gerbage et chargement ou déchargement avec beaucoup de temps de manutention de charges à grandes hauteurs","Apilado y carga o descarga con un tiempo significativo de manejo de cargas en altura","Stoccaggio e carico o scarico con un tempo significativo di movimentazione di carichi in posizione elevata"]
["Ground Handling and stacking -  Lifts below 3m","Handling und Stapeln in Bodennähe mit Hubhöhen unterhalb von 3 Metern","Manutention et gerbage au niveau du sol - levées à moins de 3 m","Manejo en el Suelo y apilado - Elevación por debajo de 3m","Movimentazione e stoccaggio a terra -  Sollevamenti al di sotto dei 3 m"]
["Most Lifts below 3 m but with occasional higher lifts","Hubhöhen zumeist unterhalb von 3 Metern – nur gelegentlich größere Hubhöhen","La plupart des levées se font à moins de 3 m, mais avec des levées à plus grandes hauteurs occasionnelles","La mayoría de elevaciones por debajo de 3 m pero con elevaciones a mayor altura de forma ocasional","La maggior parte dei sollevamenti al di sotto dei 3 m ma con sollevamenti occasionali più elevati"]
["Most Lifts above 3 m","Hubhöhen zumeist oberhalb von 3 Metern","La plupart des levées se font au-dessus de 3 m","La mayoría de elevaciones por encima de 3 m","La maggior parte dei sollevamenti al di sopra dei 3 m"]
["WHAT LOADS ARE HANDLED?","WELCHE LASTEN WERDEN BEFÖRDERT?","QUELLES SONT LES CHARGES MANIPULÉES ?","¿QUÉ CARGAS SE MANEJAN?","QUALI CARICHI VENGONO MOVIMENTATI?"]
["Generally Light Loads","Normalerweise leichte Lasten","Charges légères, en général","Generalmente Cargas Ligeras","Carichi generalmente leggeri"]
["Light to Medium Loads","Leichte bis mittelschwere Lasten","Charges légères à moyennes","Cargas de Ligeras  a Medias","Carichi da leggeri a medi"]
["Capacity Loads","Maximallasten","Charges nominales","Cargas Nominales","Carichi pari alla portata"]
["Generally less than 50% capacity occasional capacity loads","Normalerweise weniger als 50 % der Maximallast – gelegentlich Maximallasten","En général à moins de 50 % de la capacité, avec occasionnellement des charges à la capacité maximale","Generalmente menos del 50% de la capacidad nominal, cargas nominales de forma ocasional","Carichi generalmente inferiori al 50% della portata e carichi occasionali pari alla portata"]
["Generally less than 75% capacity occasional capacity loads","Normalerweise weniger als 75 % der Maximallast – gelegentlich Maximallasten","En général à moins de 75 % de la capacité, avec occasionnellement des charges à la capacité maximale","Generalmente menos del 75% de la capacidad nominal, cargas nominales de forma ocasional","Carichi generalmente inferiori al 75% della portata e carichi occasionali pari alla portata"]
["Often Handling loads at or close to capacity","Häufiges Handling von Lasten bei oder nahe der Maximallast","Manutention fréquente de charges à la capacité maximale ou à une capacité proche de la capacité maximale","Manejo Frecuente de cargas nominales o próximas a los valores nominales","Movimentazione frequente di carichi pari o prossimi alla portata"]
[" LIGHT DUTY","LEICHTE BEANSPRUCHUNG","APPLICATION LÉGÈRE","TRABAJO LIGERO","LAVORO LEGGERO"]
["MEDIUM DUTY","MITTLERE BEANSPRUCHUNG","APPLICATION MOYENNEMENT ARDUE","TRABAJO MEDIO","LAVORO MEDIAMENTE GRAVOSO"]
["HEAVY DUTY","STARKE BEANSPRUCHUNG","APPLICATION ARDUE","TRABAJO FUERTE","LAVORO ALTAMENTE GRAVOSO"]
["INTENSIVE DUTY","INTENSIVE BEANSPRUCHUNG","APPLICATION INTENSIVE","TRABAJO INTENSIVO","LAVORO INTENSIVO"]
[]
["DISCLAIMER","HAFTUNGSAUSSCHLUSS","CLAUSE DE NON-RESPONSABILITÉ","DESCARGO DE RESPONSABILIDAD","DECLINAZIONE DI RESPONSABILITÀ"]
[]
["THIS HYG LEAD ACID BATTERY DURATION TOOL USES GENERIC DATA AND TECHNICAL DATA FROM HYSTER-YALE GROUP (HYG) AND ITS SUPPLIERS TO MODEL THE ESTIMATED BATTERY DURATION OF LEAD ACID BATTERY EQUIPMENT SUPPLIED BY HYG. BASED ON USER INPUTS IT CALCULATES THE PERFORMANCE OF THE EQUIPMENT IN TYPICAL MATERIALS HANDLING APPLICATIONS. WHILE HYG HAS ENDEAVOURED TO ENSURE ITS ACCURACY, HYG CANNOT GUARANTEE THAT THE RESULTS GENERATED WILL BE ACCURATE OR CORRECT FOR A SPECIFIC CUSTOMER OR APPLICATION. FURTHER, THE PERFORMANCE OF THE TOOL RELIES ON THE USER PROVIDING COMPLETE AND ACCURATE INPUTS. RESULTS GENERATED BY THE TOOL MAY BE COMPROMISED IF INCOMPLETE OR INACCURATE INPUTS ARE USED. THE TOOL PROVIDES ESTIMATES ONLY, AND SHOULD NOT BE RELIED UPON TO ACCURATELY FORECAST OR PREDICT RESULTS IN ACTUAL USE OF MATERIALS HANDLING EQUIPMENT. HYG EXPRESSLY DISCLAIMS AND EXCLUDES ANY LIABILITY FOR LOSS OR DAMAGE HOWEVER CAUSED, WHETHER DIRECT OR INDIRECT, THAT MAY RESULT FROM USE OF THE HYG BATTERY DURATION TOOL OR RELIANCE ON ITS RESULTS. ","DIESES TOOL VON HYG ZUR VERLÄNGERUNG DER LEBENSDAUER VON BLEISÄUREBATTERIEN VERWENDET GENERISCHE UND TECHNISCHE DATEN DER HYSTER-YALE GROUP (HYG) UND IHREN ZULIEFERERN ZUR MODELLIERUNG DER LEBENSDAUER VON BLEISÄUREBATTERIEN IN VON HYG BEREITGESTELLTEN FLURFÖRDERZEUGEN. DAS TOOL BERECHNET DIE LEISTUNG VON FLURFÖRDERZEUGEN IN TYPISCHEN FLURFÖRDERANWENDUNGEN AUF GRUNDLAGE VON BENUTZEREINGABEN. OBWOHL SICH HYG BEMÜHT HAT, DIE GENAUIGKEIT DER ERGEBNISSE SICHERZUSTELLEN, KANN HYG KEINERLEI GARANTIE FÜR DIE GENAUIGKEIT ODER EIGNUNG DER ERMITTELTEN ERGEBNISSE FÜR SPEZIFISCHE KUNDEN ODER ANWENDUNGEN ÜBERNEHMEN. DARÜBER HINAUS HÄNGT DIE LEISTUNG DES TOOLS VON DER VOLLSTÄNDIGKEIT UND DER GENAUIGKEIT DER BENUTZEREINGABEN AB. DIE VON DEM TOOL ERMITTELTEN ERGEBNISSE KÖNNEN DURCH VERWENDUNG UNVOLLSTÄNDIGER ODER UNGENAUER EINGABEN BEEINTRÄCHTIGT WERDEN. DAS TOOL STELLT NUR SCHÄTZUNGEN BEREIT. ES DARF NICHT ZUR GENAUEN PROGNOSE ODER VORHERSAGE VON ERGEBNISSEN IN TATSÄCHLICH GENUTZTEN FLURFÖRDERZEUGEN VERWENDET WERDEN. HYG LEHNT AUSDRÜCKLICH UND OHNE EINSCHRÄNKUNG JEGLICHE HAFTUNG FÜR DIREKTE ODER INDIREKTE SCHÄDEN ODER VERLUSTE ALLER ART AB, WELCHE SICH MÖGLICHERWEISE DURCH DIE NUTZUNG ODER BERUFUNG AUF ERGEBNISSE DES TOOLS VON HYG ZUR VERLÄNGERUNG DER BATTERIELEBENSDAUER ERGEBEN KÖNNTEN. ","CET OUTIL D'ÉVALUATION DE LA DURÉE D'UNE BATTERIE AU PLOMB-ACIDE HYG UTILISE DES DONNÉES GÉNÉRIQUES ET DES DONNÉES TECHNIQUES D'HYSTER-YALE GROUP (HYG) ET DE SES FOURNISSEURS POUR MODÉLISER LA DURÉE ESTIMATIVE DE LA BATTERIE D'UN ÉQUIPEMENT DOTÉ D'UNE BATTERIE AU PLOMB-ACIDE FOURNI PAR HYG. EN SE BASANT SUR LES DONNÉES SAISIES PAR L'UTILISATEUR, IL CALCULE LES PERFORMANCES DE L'ÉQUIPEMENT DANS LE CADRE D'APPLICATIONS DE MANUTENTION TYPES. MÊME SI HYG A FAIT TOUT SON POSSIBLE POUR ASSURER LEUR EXACTITUDE, HYG NE PEUT GARANTIR QUE LES RÉSULTATS GÉNÉRÉS SERONT EXACTS OU CORRECTS POUR UN CLIENT DONNÉ OU UNE APPLICATION SPÉCIFIQUE. EN OUTRE, LE FONCTIONNEMENT DE CET OUTIL EST CONDITIONNÉ PAR L'EXHAUSTIVITÉ ET L'EXACTITUDE DES DONNÉES SAISIES PAR L'UTILISATEUR. LES RÉSULTATS GÉNÉRÉS PAR CET OUTIL PEUVENT ÊTRE COMPROMIS SI LES DONNÉES UTILISÉES SONT INCOMPLÈTES OU INEXACTES. CET OUTIL NE FOURNIT QUE DES ESTIMATIONS ET NE DOIT PAS SERVIR À PRÉVOIR OU À PRÉDIRE AVEC EXACTITUDE LES RÉSULTATS D'UNE UTILISATION RÉELLE D'UN ÉQUIPEMENT DE MANUTENTION. HYG DÉCLINE TOUTE RESPONSABILITÉ EN CAS DE PERTE OU DE DOMMAGE CAUSÉ(E) DE QUELQUE MANIÈRE QUE CE SOIT, DIRECTEMENT OU INDIRECTEMENT, POUVANT DÉCOULER DE L'UTILISATION DE L'OUTIL D'ÉVALUATION DE LA DURÉE D'UNE BATTERIE HYG OU DE LA CONFIANCE ACCORDÉE AUX RÉSULTATS GÉNÉRÉS PAR CET OUTIL. ","LA HERRAMIENTA DE DURACIÓN DE LAS BATERÍAS DE ÁCIDO PLOMO DE HYG UTILIZA DATOS GENÉRICOS Y DATOS TÉCNICOS DE HYSTER-YALE GROUP (HYG) Y DE SUS SUMINISTRADORES PARA MODELAR LA DURACIÓN ESTIMADA DE LA BATERÍA EN LOS EQUIPOS CON BATERÍAS DE ÁCIDO PLOMO SUMINISTRADOS POR HYG. BASÁNDOSE EN LOS VALORES INTRODUCIDOS POR EL USUARIO CALCULA EL RENDIMIENTO DE LOS EQUIPOS EN APLICACIONES DE MANUTENCIÓN TÍPICAS. AUNQUE HYG SE HA ESFORZADO POR GARANTIZAR SU EXACTITUD, HYG NO PUEDE GARANTIZAR QUE LOS RESULTADOS GENERADOS SEAN EXACTOS O CORRECTOS PARA UN CLIENTE O APLICACIÓN ESPECÍFICOS. ADICIONALMENTE, EL FUNCIONAMIENTO DE LA HERRAMIENTA SE BASA EN QUE EL USUARIO PROPORCIONE UNOS VALORES DE ENTRADA COMPLETOS Y EXACTOS. LOS RESULTADOS GENERADOS POR LA HERRAMIENTA PUEDEN VERSE COMPROMETIDOS SI SE UTILIZAN VALORES DE ENTRADA INCOMPLETOS O INEXACTOS. LA HERRAMIENTA PROPORCIONA ESTIMACIONES ÚNICAMENTE, Y NO DEBERÍAN TOMARSE COMBO BASE PARA REALIZAR DE FORMA EXACTA PREVISIONES O PREDICCIONES DE RESULTADOS EN EL USO REAL DE LOS EQUIPOS DE MANUTENCIÓN. HYG DECLINA Y EXCLUYE CUALQUIER RESPONSABILIDAD POR LA PÉRDIDAS O DAÑOS DIRECTOS O INDIRECTOS QUE NO OBSTANTE SE PUEDAN CAUSAR, Y QUE PUEDAN PRODUCIRSE COMO CONSECUENCIA DE LA UTILIZACIÓN DE LA HERRAMIENTA DE DURACIÓN DE LA  BATERÍA DE HYG O COMO CONSECUENCIA DE CONFIAR EN SUS RESULTADOS. ","QUESTO STRUMENTO PER LA DURATA DELLE BATTERIE AL PIOMBO HYG UTILIZZA DATI GENERICI E I DATI TECNICI PROVENIENTI DAL GRUPPO HYSTER-YALE (HYG) E DAI SUOI FORNITORI PER MODELLARE LA DURATA STIMATA DELLA BATTERIA DELLE APPARECCHIATURE CON BATTERIA AL PIOMBO FORNITE DA HYG. IN BASE AI DATI IMMESSI DALL'UTENTE ESSO CALCOLA LE PRESTAZIONI DELL'APPARECCHIATURA IN TIPICHE APPLICAZIONI DI MOVIMENTAZIONE DEI MATERIALI. SEBBENE HYG SI SIA SFORZATA DI GARANTIRNE L'ACCURATEZZA, HYG NON PUÒ GARANTIRE CHE I RISULTATI OTTENUTI SARANNO ACCURATI O CORRETTI PER UNO SPECIFICO CLIENTE O UNA SPECIFICA APPLICAZIONE. INOLTRE, LE PRESTAZIONI DELLO STRUMENTO DIPENDONO DALLA COMPLETEZZA E ACCURATEZZA DEI DATI IMMESSI DALL'UTENTE. SE SI UTILIZZANO DATI DI INGRESSO INCOMPLETI O NON ACCURATI, I RISULTATI GENERATI DALLO STRUMENTO POSSONO ESSERE COMPROMESSI. LO STRUMENTO FORNISCE SOLTANTO DELLE STIME E NON SI DOVREBBE FARE AFFIDAMENTO SU DI ESSO PER PREVEDERE O PREDIRE I RISULTATI DELL'USO EFFETTIVO DELL'APPARECCHIATURA DI MOVIMENTAZIONE DEI MATERIALI. HYG DECLINA ED ESCLUDE ESPRESSAMENTE QUALSIASI RESPONSABILITÀ PER PERDITE E O DANNI IN QUALUNQUE MODO CAUSATI, SIANO ESSI DIRETTI O INDIRETTI, EVENTUALMENTE DERIVANTI DALL'USO DELLO STRUMENTO DI CALCOLO DELLA DURATA DELLE BATTERIE HYG O DALL'AVER FATTO AFFIDAMENTO SUI SUOI RISULTATI. "]
[]
["Working hours per day","Betriebsstunden pro Tag","Nombre d'heures d'utilisation par jour","Horas de trabajo al día","Ore di lavoro al giorno"]
["Break/s & truck idle time (hours)","Pausen- und Staplerstillstandzeiten (Stunden)","Durée des pauses et des temps d'arrêt du chariot (en heures)","Pausa/s y tiempo de reposo de la carretilla (horas)","Pausa/e e tempo di inattività del carrello elevatore (ore)"]
["Application requirement","Anwendungsanforderung","Besoins de l'application","Requisito de la aplicación","Requisito applicazione"]
[]
["Instructions","Anleitung","Instructions","Instrucciones","Istruzioni"]
["The Lead Acid Battery duration guide tool is designed to estimate the energy consumption of our Counterbalanced Forklifts in given applications and from that to suggest optimal Lead Acid battery size to achieve the required shift life.\n\nPlease start by selecting your desired language in “C5”. You’ll then need to use the drop down menus in the same column “C” in order to configure the truck and the application. The adjacent cells in column “D” will show if the field in column “C” is compulsory with instructions in red font.\n\nOnce you’ve selected all the required fields you’ll be able to see the application consumption and the estimated battery duration below.","Der Bleibatterie – Ladezustands - Rechner ist in der Lage Ihnen den erwarteten Batterieverbrauch der Gegengewichtsgabelstapler in bestimmten Anwendungen auszurechnen und die für Sie optimale Batteriegröße für Ihren Einsatz wiederzugeben.\n\nBitte wählen Sie zunächste Ihre Sprache in Spalte „C5“. Danach nutzen Sie bitte die Auswahlmöglichkeiten in Spalte „C“ und den Stapler und den Einsatz zu konfigurieren. In Spalte „D“ sehen Sie die zwangsläufig benötigten Teile, zusammen mit einer kleinen Beschreibung in roter Schrift.\n\nSobald Sie alle benötigten Felder ausgefüllt haben, werden Sie eine Zusammenfassung sehen und die für Sie vorgeschlagende Batteriegröße.","Le guide de sélection de la batterie au plomb est un outil conçu pour estimer la consommation d'énergie de nos chariots élévateurs à contrepoids durant des applications données et pour suggérer la taille optimale de la batterie au plomb qui fonctionnera pendant la durée du poste alloué.\n\nCommencez par sélectionner la langue recuise dans \"C5\". Vous devrez ensuite utiliser les menus déroulants dans la même colonne \"C\" pour configurer le chariot et l'application. Les cellules adjacentes dans la colonne \"D\" montreront si le champ dans la colonne \"C\" est obligatoire avec des instructions en police rouge.\n\nUne fois que vous avez sélectionné tous les champs requis, vous pourrez voir la consommation utile à l'application et la durée estimée de la batterie ci-dessous.","La herramienta guía de duración de batería de ácido de plomo ha sido diseñada para estimar la energía consumida por nuestras carretillas elevadoras contrapesadas en aplicaciones específicas con el fin de sugerir un tamaño de batería óptimo para alcanzar la duración requerida en la jornada laboral.\n\nPor favor empiece seleccionando el idioma adecuado en “C5”. Después necesitará usar los menús desplegables en la misma columna “C” para configurar la carretilla y la aplicación. Las celdas adyacentes en la columna “D” mostrarán si la celda específica en la columna “C” es imperativa con instrucciones en rojo.\n\nUna vez se seleccionen todos los campos necesarios podrá ver debajo la consumición en la aplicación y la duración estimada de la batería.","Lo strumento per il calcolo della durata della batteria al piombo-acido è progettato per stimare il consumo energetico dei nostri carrelli controbilanciati in determinate applicazioni, suggerendo le dimensioni ottimali della batteria al piombo-acido a seconda della durata del turno richiesta.\n\nInizia selezionando la lingua desiderata in \"C5\". Dovrai quindi utilizzare i menu a tendina nella stessa colonna \"C\" per configurare il carrello e l'applicazione. Le celle adiacenti nella colonna \"D\" mostreranno se il campo nella colonna \"C\" è obbligatorio con le istruzioni in carattere rosso.\n\nUna volta selezionati tutti i campi richiesti, potrai vedere il consumo energetico dell'applicazione e la durata stimata della batteria."]

{"sheet":"Specs","index":2,"n_rows":44,"n_cols":17,"rows_kept":44,"cut":false,"hidden":true,"merged":[[0,3,0,6],[0,13,0,16],[36,12,36,13]]}
[null,null,null,"E-Lo",null,null,null,null,null,null,null,null,"Cab\nHeater","HiP"]
["Model","Capacity, T","tested","Light Duty","Medium Duty","Heavy Duty","Intensive Duty","Batteries1","Batteries2","Batteries3","Batteries4","Batteries5","kW","Light Duty","Medium Duty","Heavy Duty","Intensive Duty"]
["A1.3XNT",1.3,null,{"$f":"F3+(Specs!F3*Specs!$B$41)","v":1.3649999999999998},{"$f":"F3+(F3*$B$42)","v":1.95},3.9,{"$f":"F3+(F3*$B$44)","v":4.3680000000000003},"24V875Ah","24V735Ah",null,null,null,{"$f":"1.5*0.6","v":0.89999999999999991},{"$f":"P3+(Specs!P3*Specs!$B$41)","v":1.4332499999999997},{"$f":"P3+(P3*$B$42)","v":2.0474999999999999},{"$f":"F3*1.05","v":4.0949999999999998},{"$f":"P3+(P3*$B$44)","v":4.5863999999999994}]
["A1.5XNT",1.5,null,{"$f":"F4+(Specs!F4*Specs!$B$41)","v":1.4},{"$f":"F4+(F4*$B$42)","v":2},4,{"$f":"F4+(F4*$B$44)","v":4.4800000000000004},"24V1000Ah","24V840Ah",null,null,null,{"$f":"1.5*0.6","v":0.89999999999999991},{"$f":"P4+(Specs!P4*Specs!$B$41)","v":1.4699999999999998},{"$f":"P4+(P4*$B$42)","v":2.1},{"$f":"F4*1.05","v":4.2},{"$f":"P4+(P4*$B$44)","v":4.7040000000000006}]
["J1.5XNT_SWB",1.5,null,{"$f":"F5+(Specs!F5*Specs!$B$41)","v":1.3649999999999998},1.95,3.9,4.3680000000000003,"48V500Ah","48V460Ah","48V420Ah","ND48V700Ah","ND48V595Ah",0.89999999999999991,{"$f":"P5+(Specs!P5*Specs!$B$41)","v":1.4332499999999997},2.0474999999999999,4.0949999999999998,4.5863999999999994]
["J1.6XN_LWB",1.6,null,{"$f":"F6+(Specs!F6*Specs!$B$41)","v":1.5749999999999997},2.25,4.5,5.04,"48V750Ah","48V690Ah","ND48V900Ah","ND48V750Ah","ND48V690Ah",0.89999999999999991,{"$f":"P6+(Specs!P6*Specs!$B$41)","v":1.6537500000000001},2.3625000000000003,4.7250000000000005,5.2920000000000007]
["J1.6XN_MWB",1.6,"1.71/2.66",{"$f":"F7+(Specs!F7*Specs!$B$41)","v":1.54},2.2000000000000002,4.4000000000000004,{"$f":"F7*1.02","v":4.4880000000000004},"48V625Ah","48V575Ah",null,null,null,0.89999999999999991,{"$f":"P7+(Specs!P7*Specs!$B$41)","v":1.75},2.5,5,{"$f":"F7*1.23","v":5.4119999999999999}]
["J1.6XNT_LWB",1.6,null,{"$f":"F8+(Specs!F8*Specs!$B$41)","v":1.4699999999999998},2.1,4.2,4.7040000000000006,"48V750Ah","48V690Ah",null,null,null,0.89999999999999991,{"$f":"P8+(Specs!P8*Specs!$B$41)","v":1.5434999999999999},2.2050000000000001,{"$f":"F8*1.05","v":4.41},4.9392000000000005]
["J1.6XNT_MWB",1.6,null,{"$f":"F9+(Specs!F9*Specs!$B$41)","v":1.4699999999999998},2.1,4.2,{"$f":"F9*1.07","v":4.4940000000000007},"48V625Ah","48V575Ah",null,null,null,0.89999999999999991,{"$f":"P9+(Specs!P9*Specs!$B$41)","v":1.6799999999999997},2.4,4.8,5.4]
["J1.6XNT_SWB",1.6,null,{"$f":"F10+(Specs!F10*Specs!$B$41)","v":1.4699999999999998},2.1,4.2,4.7040000000000006,"48V500Ah","48V460Ah","48V420Ah","ND48V700Ah","ND48V595Ah",0.89999999999999991,{"$f":"P10+(Specs!P10*Specs!$B$41)","v":1.5434999999999999},2.2050000000000001,{"$f":"F10*1.05","v":4.41},4.9392000000000005]
["J1.8XN_LWB",1.8,null,{"$f":"F11+(Specs!F11*Specs!$B$41)","v":1.75},2.5,5,5.6,"48V750Ah","48V690Ah","ND48V900Ah","ND48V750Ah","ND48V690Ah",0.89999999999999991,{"$f":"P11+(Specs!P11*Specs!$B$41)","v":1.8374999999999999},2.625,{"$f":"F11*1.05","v":5.25},5.88]
["J1.8XN_MWB",1.8,1.48,{"$f":"F12+(Specs!F12*Specs!$B$41)","v":1.75},2.5,5,5.6,"48V625Ah","48V575Ah",null,null,null,0.89999999999999991,{"$f":"P12+(Specs!P12*Specs!$B$41)","v":1.8374999999999999},2.625,5.25,5.88]
["J1.8XNT_LWB",1.8,null,{"$f":"F13+(Specs!F13*Specs!$B$41)","v":1.645},2.35,4.7,5.2640000000000002,"48V750Ah","48V690Ah","ND48V900Ah","ND48V750Ah","ND48V690Ah",0.89999999999999991,{"$f":"P13+(Specs!P13*Specs!$B$41)","v":1.7272500000000002},2.4675000000000002,4.9350000000000005,5.5272000000000006]
["J1.8XNT_MWB",1.8,1.1499999999999999,{"$f":"F14+(Specs!F14*Specs!$B$41)","v":1.645},2.35,4.7,5.2640000000000002,"48V625Ah","48V575Ah","ND48V750Ah","ND48V625Ah",null,0.89999999999999991,{"$f":"P14+(Specs!P14*Specs!$B$41)","v":1.7272500000000002},2.4675000000000002,{"$f":"F14*1.05","v":4.9350000000000005},5.5272000000000006]
["J2.0XN_LWB",2,"1.37/1.65/2.71/2.31",{"$f":"F15+(Specs!F15*Specs!$B$41)","v":1.9249999999999998},2.75,5.5,6.16,"48V750Ah","48V690Ah","ND48V900Ah","ND48V750Ah","ND48V690Ah",0.89999999999999991,{"$f":"P15+(Specs!P15*Specs!$B$41)","v":2.0212500000000002},2.8875000000000002,5.7750000000000004,6.468]
["J2.0XN_MWB",2,null,{"$f":"F16+(Specs!F16*Specs!$B$41)","v":1.9249999999999998},2.75,5.5,6.16,"48V625Ah","48V575Ah",null,null,null,0.89999999999999991,{"$f":"P16+(Specs!P16*Specs!$B$41)","v":2.1349999999999998},3.05,6.1,{"$f":"P16+(P16*$B$44)","v":6.8319999999999999}]
["J2.0XNT_LWB",2,"0.76/1.21",{"$f":"F17+(Specs!F17*Specs!$B$41)","v":1.8199999999999998},2.6,5.2,5.8239999999999998,"48V750Ah","48V690Ah","ND48V900Ah","ND48V750Ah","ND48V690Ah",0.89999999999999991,{"$f":"P17+(Specs!P17*Specs!$B$41)","v":1.911},2.7300000000000004,{"$f":"F17*1.05","v":5.4600000000000009},6.1152000000000006]
["J2.0XNT_MWB",2,1.1200000000000001,{"$f":"F18+(Specs!F18*Specs!$B$41)","v":1.9249999999999998},2.75,5.5,6.16,"48V625Ah","48V575Ah","ND48V750Ah","ND48V625Ah",null,0.89999999999999991,{"$f":"P18+(Specs!P18*Specs!$B$41)","v":2.1349999999999998},3.05,6.1,6.8319999999999999]
["J2.2XN_Adv",2.2000000000000002,null,{"$f":"F19+(Specs!F19*Specs!$B$41)","v":2.3380000000000001},3.34,6.68,7.4815999999999994,"80V620Ah","80V560Ah",null,null,null,0.89999999999999991,{"$f":"P19+(Specs!P19*Specs!$B$41)","v":2.4549000000000003},3.5070000000000001,{"$f":"F19*1.05","v":7.0140000000000002},7.8556800000000004]
["J2.2XN_Adv_Plus",2.2000000000000002,null,{"$f":"F20+(Specs!F20*Specs!$B$41)","v":2.6284999999999998},3.7549999999999999,7.51,8.4111999999999991,"80V620Ah","80V560Ah",null,null,null,0.89999999999999991,{"$f":"P20+(Specs!P20*Specs!$B$41)","v":2.759925},3.9427500000000002,{"$f":"F20*1.05","v":7.8855000000000004},8.8317600000000009]
["J2.5XN_717_Adv",2.5,2.4500000000000002,{"$f":"F21+(Specs!F21*Specs!$B$41)","v":2.4500000000000002},3.5,7,{"$f":"F21*1.16","v":8.1199999999999992},"80V620Ah","80V560Ah",null,null,null,0.89999999999999991,{"$f":"P21+(Specs!P21*Specs!$B$41)","v":2.7684999999999995},3.9549999999999996,{"$f":"F21*1.13","v":7.9099999999999993},{"$f":"F21*1.68","v":11.76}]
["J2.5XN_717_Adv_Plus",2.5,null,{"$f":"F22+(Specs!F22*Specs!$B$41)","v":2.7545000000000002},3.9350000000000001,7.87,8.8144000000000009,"80V620Ah","80V560Ah",null,null,null,0.89999999999999991,{"$f":"P22+(Specs!P22*Specs!$B$41)","v":2.8922249999999998},4.1317500000000003,{"$f":"F22*1.05","v":8.2635000000000005},9.2551199999999998]
["J2.5XN_861_Adv",2.5,"2.12/2.67",{"$f":"F23+(Specs!F23*Specs!$B$41)","v":2.7614999999999998},3.9449999999999998,7.89,8.8368000000000002,"80V750Ah","80V700Ah",null,null,null,0.89999999999999991,{"$f":"P23+(Specs!P23*Specs!$B$41)","v":2.8995749999999996},4.1422499999999998,{"$f":"F23*1.05","v":8.2844999999999995},9.2786399999999993]
["J2.5XN_861_Adv_Plus",2.5,null,{"$f":"F24+(Specs!F24*Specs!$B$41)","v":3.101},4.43,8.86,9.9231999999999996,"80V750Ah","80V700Ah",null,null,null,0.89999999999999991,{"$f":"P24+(Specs!P24*Specs!$B$41)","v":3.2560499999999992},4.6514999999999995,9.302999999999999,10.419359999999999]
["J3.0XN_Adv",3,null,{"$f":"F25+(Specs!F25*Specs!$B$41)","v":3.0449999999999999},4.3499999999999996,8.6999999999999993,9.7439999999999998,"80V775Ah","80V700Ah",null,null,null,0.89999999999999991,{"$f":"P25+(Specs!P25*Specs!$B$41)","v":3.1972499999999995},4.5674999999999999,{"$f":"F25*1.05","v":9.1349999999999998},10.231199999999999]
["J3.0XN_Adv_Plus",3,null,{"$f":"F26+(Specs!F26*Specs!$B$41)","v":3.3949999999999996},4.8499999999999996,9.6999999999999993,10.863999999999999,"80V775Ah","80V700Ah",null,null,null,0.89999999999999991,{"$f":"P26+(Specs!P26*Specs!$B$41)","v":3.5647500000000001},5.0925000000000002,{"$f":"F26*1.05","v":10.185},11.4072]
["J3.5XN_Adv",3.5,"2.1/2.17",{"$f":"F27+(Specs!F27*Specs!$B$41)","v":3.5},5,10,11.2,"80V775Ah","80V700Ah",null,null,null,0.89999999999999991,{"$f":"P27+(Specs!P27*Specs!$B$41)","v":3.5104999999999995},5.0149999999999997,10.029999999999999,{"$f":"P27","v":10.029999999999999}]
["J3.5XN_Adv_Plus",3.5,null,{"$f":"F28+(Specs!F28*Specs!$B$41)","v":3.9550000000000001},5.65,11.3,12.656000000000001,"80V775Ah","80V700Ah",null,null,null,0.89999999999999991,{"$f":"P28+(Specs!P28*Specs!$B$41)","v":4.1527500000000002},5.932500000000001,{"$f":"F28*1.05","v":11.865000000000002},{"$f":"G28*1.05","v":13.288800000000002}]
["J4.0XN",4,"13/11.3",{"$f":"F29+(Specs!F29*Specs!$B$41)","v":4.15625},5.9375,{"$f":"G29*0.95","v":11.875},12.5,"80V840Ah","80V930Ah",null,null,null,{"$f":"2*0.6","v":1.2},{"$f":"P29+(Specs!P29*Specs!$B$41)","v":4.34},6.2,12.4,12.9]
["J4.5XN",4.5,2.94,{"$f":"F30+(Specs!F30*Specs!$B$41)","v":4.2227499999999996},6.0324999999999998,{"$f":"G30*0.95","v":12.065},12.7,"80V840Ah","80V930Ah",null,null,null,{"$f":"2*0.6","v":1.2},{"$f":"P30+(Specs!P30*Specs!$B$41)","v":4.4338874999999991},6.3341250000000002,{"$f":"F30*1.05","v":12.66825},{"$f":"G30*1.05","v":13.334999999999999}]
["J5.0XN",5,null,{"$f":"F31+(Specs!F31*Specs!$B$41)","v":4.2892499999999991},6.1274999999999995,{"$f":"G31*0.95","v":12.254999999999999},12.9,"80V840Ah","80V930Ah",null,null,null,1.2,{"$f":"P31+(Specs!P31*Specs!$B$41)","v":4.5037124999999989},6.4338749999999996,{"$f":"F31*1.05","v":12.867749999999999},{"$f":"G31*1.05","v":13.545000000000002}]
["J5.0XN6",5,null,{"$f":"F32+(Specs!F32*Specs!$B$41)","v":4.3557499999999987},6.2224999999999993,12.444999999999999,13.1,"80V840Ah","80V930Ah",null,null,null,1.2,{"$f":"P32+(Specs!P32*Specs!$B$41)","v":4.5735374999999987},6.5336249999999998,13.06725,{"$f":"G32*1.05","v":13.755000000000001}]
["J5.5XN6",5.5,13.5,{"$f":"F33+(Specs!F33*Specs!$B$41)","v":4.7249999999999996},6.75,13.5,13.5,"80V840Ah","80V930Ah",null," ",null,1.2,{"$f":"P33+(Specs!P33*Specs!$B$41)","v":4.9612499999999997},7.0875000000000004,14.175000000000001,{"$f":"G33*1.05","v":14.175000000000001}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"1.5kW","1-3.5t"]
[null,null,null,null,null,null,null,null,"Tested",null,null,null,"2kW","4-5.5t"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Use 60% as working factor."]
[]
["To be replaced with test data for final calculator"]
["Duty %"]
[" Light",-0.65]
["Medium  ",-0.5]
["Heavy",0,null,null," "]
["Intensive",0.12]

{"sheet":"Log","index":3,"n_rows":27,"n_cols":4,"rows_kept":27,"cut":false,"hidden":true,"merged":[]}
["Version","Date","Who","Description"]
["Version 1.0","2016-08-03","L. Ceballos","Calculator creation in Hyster branding, with all the calculations and the main calculation algorythm"]
["Version 1.1","2016-08-04","L. Ceballos","Checked and amended variables with UK TMs"]
["Version 1.2","2016-08-06","L. Ceballos","Validated % with Charlie Whilton"]
["Version 1.3","2016-09-02","L. Ceballos","Added activate/deactivate button changed formula for discharge, added hours and minutes to estimated time"]
["Version 1.4","2016-09-08","L. Ceballos","Added Mast and performance settings to the variables"]
["Version 1.5","2016-09-09","L. Ceballos","Added extended shift, formated for printing"]
["Version 1.6","2017-01-25","C. Whilton","Charlie took over and amended the calculator creating a new DRAFT"]
["Version 1.7","2017-01-27","C. Whilton","Added functionality to all inputs."]
["Version 1.8","2017-03-07","C. Whilton","Added HIP functionality and Cab heater option."]
["Version 1.9","2017-06-26","C. Whilton","Changed duty cycles"]
["Version 1.10","2017-07-13","L.Ceballos","Revised 'calculator' cell C9 to force selection of appropriate battery."]
["Version 1.11","2017-09-27","C. Whilton","Included additional test data for J5.5XN6"]
["Version 1.12","2017-10-24","L. Ceballos","Luis took overa and re-adjusted all the functions mirroring the calculator to start including translation and modified the design in line with other calculations created in the past"]
["Version 1.13","2017-10-25","L. Ceballos","Modified functions to allow translation up to attachments."]
["Version 1.14","2017-10-26","L. Ceballos","Modified most of the other functions to allow translation."]
["Version 1.15","2017-10-27","L. Ceballos","Finalised functions, re-formated, included disclaimer at the bottom and finalised linkage to translations, finalised formating matrix and included it on the right side"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"NOTES"]
[null,null,null,"% truck utilisation"]
[null,null,null,"Disclaimer"]

{"sheet":"Variables","index":4,"n_rows":98,"n_cols":5,"rows_kept":98,"cut":false,"hidden":true,"merged":[]}
["Battery","V","Ah","watt hours","kWh"]
["24V735Ah",24,735,{"$f":"B2*C2","v":17640},{"$f":"D2/1000","v":17.64}]
["24V875Ah",24,875,{"$f":"B3*C3","v":21000},{"$f":"D3/1000","v":21}]
["24V840Ah",24,840,20160,20.16]
["24V1000Ah",24,1000,24000,24]
["48V420Ah",48,420,20160,20.16]
["48V460Ah",48,460,22080,22.08]
["48V500Ah",48,500,24000,24]
["48V575Ah",48,575,27600,27.6]
["48V625Ah",48,625,30000,30]
["48V690Ah",48,690,33120,33.119999999999997]
["48V750Ah",48,750,36000,36]
["80V560Ah",80,560,44800,44.8]
["80V620Ah",80,620,49600,49.6]
["80V700Ah",80,700,56000,56]
["80V750Ah",80,750,60000,60]
["80V775Ah",80,775,62000,62]
["80V840Ah",80,840,67200,67.2]
["80V930Ah",80,930,74400,74.400000000000006]
["ND48V595Ah",48,595,28560,28.56]
["ND48V625Ah",48,625,30000,30]
["ND48V690Ah",48,690,33120,33.119999999999997]
["ND48V700Ah",48,700,33600,33.6]
["ND48V750Ah",48,750,36000,36]
["ND48V900Ah",48,900,43200,43.2]
[]
[null,null,null,"Description"]
[]
["Attachment"]
["Clamp / Rotator",0.1,null,"Truck uses a heavy attachment that influence its consumption"]
["No",0,null,"Truck uses the forks"]
[]
["Cold Store"]
["Yes"]
["No"]
[]
[]
["Cold store",null,null,"Truck works in cold store increasing the battery discharge rate"]
["Chilled store",0.25,null,"75% available battery"]
["Sub zero freezer",0.5,null,"50% available battery"]
["No",0,null,"Full Battery"]
[]
["Utilisation",0.1,null,"Driver spends 10% of the time driving and 60% of the time not driving"]
[null,0.2,null,"Driver spends 20% of the time driving and 60% of the time not driving"]
[null,0.3,null,"Driver spends 30% of the time driving and 60% of the time not driving"]
[null,0.4,null,"Driver spends 40% of the time driving and 60% of the time not driving"]
[null,0.5,null,"Driver spends 50% of the time driving and 50% of the time not driving"]
[null,0.6,null,"Driver spends 60% of the time driving and 40% of the time not driving"]
[null,0.7,null,"Driver spends 70% of the time driving and 30% of the time not driving"]
[null,0.8,null,"Driver spends 80% of the time driving and 20% of the time not driving"]
[null,0.9,null,"Driver spends 90% of the time driving and 10% of the time not driving"]
[]
["Battery discharge",0.8,null,"Truck works until there's  20% of battery left"]
[]
["Ramp"]
["Yes"]
["No"]
[]
["Length"]
["15m",0.05]
["12m",0.04]
["9m",0.03]
["6m",0.02]
["3m",0.01]
[]
[]
["Frequency"]
["Continuous",0.05]
["Sometimes",0.03]
["Rarely",0.01]
[]
[]
["Gradient"]
[0.15,0.05]
[0.1,0.03]
[0.05,0.01]
[]
[]
["Side shift/fork posit."]
["Side Shift & Fork Positioner",0.02]
["Side shift",0.01]
["No",0]
[]
[]
["Battery Degradation over time.",0.15,"Discuss with batt mfgr"]
[]
["Mast Type"]
["2 LFL",0]
["2 FFL",0]
["3 FFL",0.08]
[]
["Aux Electrics, Lights etc.…","0.3kW"]
["Yes",0.3,"kW, Based on 6 hr operational shift."]
["No",0]
[]
["Cab Heater"]
["Yes"]
["No"]

{"sheet":"Light-Medium-Heavy Duty","index":5,"n_rows":16,"n_cols":11,"rows_kept":16,"cut":false,"hidden":true,"merged":[[1,3,1,5],[4,0,6,0],[9,3,9,5],[8,1,8,5],[11,3,12,3],[11,4,12,4],[11,5,12,5],[12,1,12,2],[9,1,11,2]]}
[null,"Application Matrix"]
[null,null,null,"What is weight of loads are Handled?"]
[null,null,null,{"$f":"'Application Factors'!C7","v":"Generally Light Loads"},{"$f":"'Application Factors'!C8","v":"Light to Medium Loads"},{"$f":"'Application Factors'!C9","v":"Capacity Loads"}]
[null,null,null,{"$f":"'Application Factors'!D7","v":"Generally less than 50% capacity occasional capacity loads"},{"$f":"'Application Factors'!D8","v":"Generally less than 75% capacity occasional capacity loads"},{"$f":"'Application Factors'!D9","v":"Often Handling loads at or close to capacity"}]
["How much Hydraulic Work?",{"$f":"'Application Factors'!C11","v":"Generally Stacking and Loading - signficantly more travel than lifting"},{"$f":"'Application Factors'!D11","v":"Ground Handling and stacking -  Lifts below 3m"},"Very Light Duty \n OR Light Duty ","Light Duty\nOr Medium Duty ","Medium Duty\nOr Heavy Duty"]
[null,{"$f":"'Application Factors'!C12","v":"Stacking and loading or unloading racking with similar amounts of travel and hydraulic work"},{"$f":"'Application Factors'!D12","v":"Most Lifts below 3 m but with occasional higher lifts"},"Light Duty\nOr Medium Duty","Medium Duty","Heavy Duty",null,"ORIGINAL"]
[null,{"$f":"'Application Factors'!C13","v":"Stacking and loading or unloading with significant time handling loads at height"},{"$f":"'Application Factors'!C15","v":"Or Forklift Operating with clamping attachment or rotator"},"Medium Duty","Medium Duty\nOr Heavy Duty","Heavy Duty"]
[]
[null,"APPLICATION MATRIX",null,null,null,null,null,null,null,null," "]
[null,"Choose duty cycle from the matrix criterea and select result in the calculator",null,"WHAT LOADS ARE HANDLED?"]
[null,null,null,{"$f":"'Application Factors'!C7","v":"Generally Light Loads"},{"$f":"'Application Factors'!C8","v":"Light to Medium Loads"},{"$f":"'Application Factors'!C9","v":"Capacity Loads"}]
[null,null,null,{"$f":"'Application Factors'!D7","v":"Generally less than 50% capacity occasional capacity loads"},{"$f":"'Application Factors'!D8","v":"Generally less than 75% capacity occasional capacity loads"},{"$f":"'Application Factors'!D9","v":"Often Handling loads at or close to capacity"}]
[null,"TRAVEL Vs. HYDRAULICS OPERATION?"]
[null,{"$f":"'Application Factors'!C11","v":"Generally Stacking and Loading - signficantly more travel than lifting"},{"$f":"'Application Factors'!D11","v":"Ground Handling and stacking -  Lifts below 3m"}," LIGHT DUTY","MEDIUM DUTY","HEAVY DUTY"]
[null,{"$f":"'Application Factors'!C12","v":"Stacking and loading or unloading racking with similar amounts of travel and hydraulic work"},{"$f":"'Application Factors'!D12","v":"Most Lifts below 3 m but with occasional higher lifts"},"MEDIUM DUTY","HEAVY DUTY","INTENSIVE DUTY",null,"REVISED"]
[null,{"$f":"'Application Factors'!C13","v":"Stacking and loading or unloading with significant time handling loads at height"},{"$f":"'Application Factors'!D12","v":"Most Lifts below 3 m but with occasional higher lifts"},"HEAVY DUTY","INTENSIVE DUTY","INTENSIVE DUTY"]

{"sheet":"Application Factors","index":6,"n_rows":31,"n_cols":10,"rows_kept":31,"cut":false,"hidden":true,"merged":[[0,0,0,4],[11,9,11,12],[28,1,29,5],[30,1,30,5]]}
["Strawman of Factors to be applied to the Calculated Battery Autonomy based on Possible Consumption* and Available Battery Capacity **"]
[]
[null,"Factor to be Applied","Where Used","Description to assist selection","Suggested Factor to be Applied","Reasoning","Validation Needed and Completed"]
[]
[1,"% of shift time where truck is operated (%)","Direct estimate from Application Survey entered via input sheet",null,"Direct % applied to increase operating time","Neglegable consumption when truck not operating","Probably not required"]
[]
[2,"Average Loads Carried (incorporated into Light Medium Heavy Matrix)","Generally Light Loads","Generally less than 50% capacity occasional capacity loads","decrease possible consumption by 25%","Lower GVW and hydraulic loads than are seen on VDI2198 (60 cycle)","Yes"]
[null,null,"Light to Medium Loads","Generally less than 75% capacity occasional capacity loads","decrease possible consumption by 15%","Lower GVW and hydraulic loads than are seen on VDI2198 (60 cycle)","Yes"]
[null,null,"Capacity Loads","Often Handling loads at or close to capacity","No change in prediction","Similar loads to VDI2198 (60 cycle)","Yes"]
[]
[3,"Hydraulic Work (incorporated into Light Medium Heavy Matrix)","Generally Stacking and Loading - signficantly more travel than lifting","Ground Handling and stacking -  Lifts below 3m","decrease possible consumption by 10%","Lower hydraulic loads than are seen on VDI2198 (60 cycle)","Yes"]
[null,null,"Stacking and loading or unloading racking with similar amounts of travel and hydraulic work","Most Lifts below 3 m but with occasional higher lifts","No change in prediction","Similar loads to VDI2198 (60 cycle)","Yes",null,null,"REFINE FACTORS"]
[null,null,"Stacking and loading or unloading with significant time handling loads at height","Signficant High Lifting ","increase possible consumption by 20%","Higher hydraulic loads than are seen on VDI2198 (60 cycle)","Yes"]
[null,null,"Forklift Operating with non clamping attachment, Fork Positionner, ",null,"No change in prediction","Similar loads to VDI2198 (60 cycle)","Probably not required as attachment usage is low"]
[null,null,"Or Forklift Operating with clamping attachment or rotator","Operating with Appliance Clamp, Bail Clamp, Paper Roll Clamp","increase possible consumption by 20%","Higher hydraulic loads than are seen on VDI2198 (60 cycle)","Yes"]
[]
[4,"Ramps","Short slight ramps occasionally travelled","5-10%, 5-10 meters long","increase possible consumption by 5%","More tractive work than VDI2198 (60 cycle)","Impact could be calculated from consumption data on ramp"]
[null,null,"Short slight ramps travelled frequently, or steeper ramps inc loading ramps","Portable loading ramps and other ramps above 10% occasionally used","increase possible consumption by 15%","More tractive work than VDI2198 (60 cycle)","Impact could be calculated from consumption data on ramp"]
[null,null,"Significant Ramp work","Portable loading ramps and those above 10%, travelled frequently","increase possible consumption by 25%","More tractive work than VDI2198 (60 cycle)","Impact could be calculated from consumption data on ramp"]
[]
[5,"Operating Temperature Factors","Cold Store","Operation in cold store for greater than 20% of operating time","Decrease available battery capacity by 20%","Battery efficiency diminished at lower temperatures","Midac could validate?"]
[null,null,"High Ambient Temperatures ","Intensive operation likely at moderate ambients above 20C ","Decrease available battery capacity by 15%","Battery efficiency diminished at higher battery temperatures","Midac could validate?"]
[null,null,"Intensive at Very High Ambient Temperatures ","Intensive operation likely at moderate ambients above 30C ","Decrease available battery capacity by 25%","Battery efficiency signficantly diminished at higher battery temperatures","Midac could validate?"]
[]
[6,"Battery Ageing","Batteries Well Maintained","Expectation of 5 year batttery life ","Decrease available battery capacity by 10%","Direct factor applied to accommodate required battery performance at end of battery life","Midac could validate?"]
[null,null,"Batteries generally well maintained, occasional lapses","Expectation of 5 year battery life with ","Decrease available battery capacity by 20%","Direct factor applied to accommodate required battery performance at end of battery life","Midac could validate?"]
[null,null,"Battery maintenance unknown or uncertain","Expectation of 5 year battery life with ","Decrease available battery capacity by 30%","Direct factor applied to accommodate required battery performance at end of battery life","Midac could validate?"]
[]
[null,"* Possible Consumption can increase up to the max power usable by the truck series, based on application. A lower capacity machine in the series could see signficantly increased consumption due to these factors, wheras highest capacity machine will see smaller increments, as motors and controllers cannot utilise/consume much more power."]
[]
[null,"** Available Battery Capacity can be impacted by temperature and by battery degradation (loss of capacity) over time. This effect is unaffected by machine capacity."]

{"sheet":"Validation data","index":7,"n_rows":48,"n_cols":6,"rows_kept":48,"cut":false,"hidden":true,"merged":[]}
["Duty Cycle",0.5,null,null,null,"shift letter"]
["Light Duty",1,1,"A",{"$f":"Calculator!C12-0.5","v":-0.5},{"$f":"VLOOKUP(E2,'Validation data'!B2:D48,3,FALSE)","v":{"$error":"#N/A"}}]
["Medium Duty",1.5,1.5,"B"]
["Heavy Duty",2,2,"CC"]
["Intensive Duty",2.5,2.5,"D"]
[null,3,3,"E"]
[null,3.5,3.5,"F"]
[null,4,4,"G"]
[null,4.5,4.5,"H"]
[null,5,5,"I"]
[null,5.5,5.5,"J"]
[null,6,6,"K"]
[null,6.5,6.5,"L"]
[null,7,7,"M"]
[null,7.5,7.5,"N"]
[null,8,8,"O"]
[null,8.5,8.5,"P"]
[null,9,9,"Q"]
[null,9.5,9.5,"RR"]
[null,10,10,"S"]
[null,10.5,10.5,"T"]
[null,11,11,"U"]
[null,11.5,11.5,"V"]
[null,12,12,"W"]
[null,12.5,12.5,"X"]
[null,13,13,"Y"]
[null,13.5,13.5,"Z"]
[null,14,14,"AA"]
[null,14.5,14.5,"AB"]
[null,15,15,"AC"]
[null,15.5,15.5,"AD"]
[null,16,16,"AE"]
[null,16.5,16.5,"AF"]
[null,17,17,"AG"]
[null,17.5,17.5,"AH"]
[null,18,18,"AI"]
[null,18.5,null,"AJ"]
[null,19,null,"AK"]
[null,19.5,null,"AL"]
[null,20,null,"AM"]
[null,20.5,null,"AN"]
[null,21,null,"AO"]
[null,21.5,null,"AP"]
[null,22,null,"AQ"]
[null,22.5,null,"AR"]
[null,23,null,"AS"]
[null,23.5,null,"AT"]
[null,24,null,"AU"]

{"sheet":"PRJ2106","index":8,"n_rows":7,"n_cols":1,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
["Translations"]
[]
["English"]
["Deutsch"]
["Français"]
["Español"]
["Italiano"]