Lagerbereich Länge X in m | | m | | | | |
Lagerbereich Breite Y in m | | m | | | | |
Lagerbereich Höhe h in m | | m | | | | |
Fläche | =B1*B2 | m² | | | | |
Volumen | =B4*B3 | m³ | | | | |
Palettenbreite | | mm | =B6 | mm | =B6 | |
Palettentiefe | | mm | =B7 | mm | =B7 | mm |
Palettenhöhe | | mm | =B8 | mm | =B8 | mm |
Regal | | | | | | |
Paletten pro Regalfach | | | | | | |
Lichte Fachweite | | mm | =B11 | mm | =B11 | mm |
Regalträgerhöhe | | mm | =B12 | mm | =B12 | mm |
Regalrahmentiefe | | mm | =B13 | mm | =B13 | mm |
Regalrahmenbreite zum Gang | | mm | =B14 | mm | =B14 | mm |
Anzahl Regal-Felder | =int((B1*1000-B14)/(B11+B14)) | | =B15 | | =B15 | |
Lichte Fachhöhe (PH + 150) | =B8+150 | mm | =B16 | mm | =B16 | mm |
Maß zwischen Paletten im Regal | | mm | =B17 | mm | =B17 | mm |
Arbeitsgangbreite des Staplers | | mm | | mm | | mm |
Hubhöhe Stapler max | | mm | | | | mm |
Gangbreite fix=1 variabel=0 | | 0/1 | | 0/1 | | 0/1 |
Anzahl Doppelregalgänge | =int(B2*1000/(2*B7+B18+B17)) | | =int(B2*1000/(2*B7+D18+B17)) | | =int(B2*1000/(2*B7+F18+B17)) | |
Einzelregal möglich 0 nein 1 ja | =int((B2*1000-(2*B7+B18+B17)*B21)/(B7+B18)) | 0/1 | =int((B2*1000-(2*B7+D18+B17)*D21)/(B7+D18)) | 0/1 | =int((B2*1000-(2*B7+F18+B17)*F21)/(B7+F18)) | 0/1 |
Paletten pro Ebene | =B10*B15*(B21*2+B22) | | =B15*B10*(D21*2+D22) | | =B15*B10*(F21*2+F22) | |
Nutzbare Höhe max | =min(B19+B8,B3*1000) | mm | =min(D19+B8,B3*1000) | mm | =min(F19+B8,B3*1000) | mm |
Anzahl Ebenen | =int(B24/(B16+B12)) | | =int(D24/(B16+B12)) | | =int(F24/(B16+B12)) | |
Oberste Auflage | =B25*(B16+B12) | mm | =D25*(B16+B12) | mm | =F25*(B16+B12) | mm |
Errechnete Arbeitsgangbreite | =(B2*1000-B7*(2*B21+B22)-B17*(B21-1+B22)) / (B21+B22) | mm | =(B2*1000-D7*(2*D21+D22)-D17*(D21-1+D22)) / (D21+D22) | mm | =(B2*1000-F7*(2*F21+F22)-F17*(F21-1+F22)) / (F21+F22) | mm |
Gewählte Arbeitsgangbreite | =if(B20=1,B18,B27) | mm | =if(D20=1,D18,D27) | mm | =if(F20=1,F18,F27) | mm |
Palettenplätze gesamt # | =B23*B25 | | =D23*D25 | | =F23*F25 | |
Wahl | | 0/1 | | 0/1 | | 0/1 |
Werte lesen G / E / AST | =B21*B30+D21*D30+F21*F30 | | =B25*B30+D25*D30+F25*F30 | | =B28*B30+D28*D30+F28*F30 | |
Werte lesen E1 / F / Pges | =B22*B30+D22*D30+F22*F30 | | =B15 | | =B29*B30+D29*D30+F29*F30 | |
checks: 2021-01-17 12:53:24 joba de /checkabc/check.cgi 10.1.1.1435 ©Jochen Baumann id=39 |