| Area width X in m | | m | =B1 | | =B1 | |
| Area height Y in m | | m | =B2 | | =B2 | |
| Building height in m | | m | =B3 | | =B3 | |
| Area | =B1*B2 | m² | | | | |
| Volume | =B4*B3 | m³ | | | | |
| Pallets width X | | mm | =B6 | mm | =B6 | |
| Pallets depth Y | | mm | =B7 | mm | =B7 | mm |
| Pallets heigth Z | | mm | =B8 | mm | =B8 | mm |
| Rack | | | | | | |
| Pallets per rack shelf | | | | | | |
| Shelf with inside | | mm | =B11 | mm | =B11 | mm |
| Beam hight | | mm | =B12 | mm | =B12 | mm |
| Rack's upright depth Y | | mm | =B13 | mm | =B13 | mm |
| Rack's upright width X | | mm | =B14 | mm | =B14 | mm |
| Rack fields calculated | =int((B1*1000-B14)/(B11+B14)) | | =B15 | | =B15 | |
| Shelf free hight (PH + 150) | =B8+150 | mm | =B16 | mm | =B16 | mm |
| Rack distance between 2 racks | | mm | =B17 | mm | =B17 | mm |
| Aisle width of the truck | | mm | | mm | | mm |
| Liftheight max | | mm | | | | mm |
| Aisle width fix=1 variable=0 | | 0/1 | | 0/1 | | 0/1 |
| Number of aisles | =int(B2*1000/(2*B7+B18+B17)) | | =int(B2*1000/(2*B7+D18+B17)) | | =int(B2*1000/(2*B7+F18+B17)) | |
| Calculate with single rack 0 / 1 yes | =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 |
| Pallets per level | =B10*B15*(B21*2+B22) | | =B15*B10*(D21*2+D22) | | =B15*B10*(F21*2+F22) | |
| Height possible max | =min(B19+B8,B3*1000) | mm | =min(D19+B8,B3*1000) | mm | =min(F19+B8,B3*1000) | mm |
| Number of levels | =int(B24/(B16+B12)) | | =int(D24/(B16+B12)) | | =int(F24/(B16+B12)) | |
| Rack's top level | =B25*(B16+B12) | mm | =D25*(B16+B12) | mm | =F25*(B16+B12) | mm |
| Aisle width calculated to fill area | =(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 |
| Aisle width - calculated width | =if(B20=1,B18,B27) | mm | =if(D20=1,D18,D27) | mm | =if(F20=1,F18,F27) | mm |
| Total number of pallets# | =B23*B25 | | =D23*D25 | | =F23*F25 | |
| Selection | | 0/1 | | 0/1 | | 0/1 |
| Data selection G / E / AST | =B21*B30+D21*D30+F21*F30 | | =B25*B30+D25*D30+F25*F30 | | =B28*B30+D28*D30+F28*F30 | |
| Data selection E1 / F / Pges | =B22*B30+D22*D30+F22*F30 | | =B15 | | =B29*B30+D29*D30+F29*F30 | |
| | | | | | |
| | | | | | |
| | | | | | |
| | | | | | |
| | | | | | |
| checks: 2020-12-15 18:12:49 joba en /checkabc/check.cgi 10.1.1.1435 ©Jochen Baumann id=45 |