🔧 T3_Uty4_ForkliftLoadingAisleWidth.vb - Detailed Explanation

📋 Overview

This file is a specialized utility designed to calculate the required aisle width for a forklift to perform a 90-degree right-angle stacking operation. In warehouse layout design, it automatically calculates the minimum required aisle width based on the forklift model and pallet size.

🔧 Dependencies

Technologies Used:

• Office.Interop: Excel integration (data updates via Excel.Application)
• EPPlus (FormulaParsing): Excel formula parsing support
• OleDb: Reading data from Excel files

🚜 Supported Forklift Types

1. Reach Type Forklift

2. 3-Wheel Counterbalance Forklift

3. 4-Wheel Counterbalance Forklift

📐 Calculation Parameter Details

🧮 Detailed Explanation of Formulas

Calculation for Reach Type Forklift

Calculation for 3-Wheel Counterbalance Forklift

Calculation for 4-Wheel Counterbalance Forklift

🔍 Main Methods Details

1. Form Load Processing

Initialization Process:

1. Display expiration date and copyright
2. Check existence of required files
3. Set Excel file paths
   MyExcel = DatSavePath & "\ForkliftAisleCalc\ForkliftModels.xlsx"
   MySheet1 = "CatalogDat"
   MySheet2 = "ManualInputDat"
4. Load catalog specification data (CatalogSpecDgv)
5. Load manual input data (ManualInputDgv)
6. Radio button check (Initial display setting)
7. Set data load completion flag

2. Data Load Processing

Processing Flow:

1. Remove all existing DataGridView columns
2. Setup OleDb Connection
   Provider=Microsoft.ACE.OLEDB.12.0
   Data source=[File Path]
   Extended properties="Excel 8.0;HDR=YES;IMEX=1"
3. Retrieve the entire Excel sheet using a SQL SELECT statement
   SELECT * FROM [SheetName$]
4. Store in a DataSet and bind to the DataGridView

3. Radio Button Check Processing

Processing Details:

• When Reach Type is selected:
  • Change background color to LightCyan
  • Display the Reach Type tab
  • Filter the vehicle type ComboBox for reach types
• When 3-Wheel Counterbalance is selected:
  • Change background color to PowderBlue
  • Display the 3-Wheel Counterbalance tab
  • Filter the vehicle type ComboBox for 3-wheel counterbalance types
• When 4-Wheel Counterbalance is selected:
  • Change background color to LavenderBlush
  • Display the 4-Wheel Counterbalance tab
  • Filter the vehicle type ComboBox for 4-wheel counterbalance types

4. Vehicle Type ComboBox Change Processing

Processing Details:

1. Set ComboBox drop-down style (non-editable)
2. Clear existing items
3. Extract the models of the selected vehicle type from the DataGridView
4. Add the models to the ComboBox
5. Automatically select the first model
6. Call the TextBox display processing

5. TextBox Display Processing

Key Features:

• Retrieve data corresponding to the selected model from the DataGridView
• Set values in each TextBox
• Set ReadOnly properties and background colors:
  • Gainsboro (Gray): Read-only (Catalog data)
  • Bisque (Beige): Editable (Adjustable parameters)
• Execute calculation formulas based on vehicle type
• Control show/hide for controls:
  • Reach type: Show reach stroke and back overhang
  • Counterbalance types: Hide those controls

6. Recalculation Processing

Processing Flow:

1. Input Check (Required fields)
   Vehicle Total Width, Min Turning Radius, Pallet Width, Pallet Depth,
   Front Overhang, Clearance
   (And Reach Stroke if Reach Type)
2. Range Check (Validity Verification)

   Item	Range
   Vehicle Total Width	800 ～ 2000 mm
   Minimum Turning Radius	1000 ～ 3000 mm
   Pallet Width	700 ～ 2000 mm
   Pallet Depth	900 ～ 2000 mm
   Reach Stroke	300 ～ 1000 mm
   Front Overhang	100 ～ 800 mm
   Clearance	80 ～ 500 mm

3. Execute Vehicle Type Calculations
   • Reach Type: Calc BO → Calc R2 → Calc R
   • 3-Wheel Counterbalance: Calc R2 → Calc R
   • 4-Wheel Counterbalance: Calc R2 (considering W/2) → Calc R
4. Visual Feedback
   • Toggle background color between PaleGoldenrod and Azure
   • Visually confirm that recalculation has occurred

7. Clear Values Processing

Processing Details:

• Switch to Manual Input Calculation Mode
• Clear all TextBoxes
• Set all TextBoxes to editable (BackColor = Bisque)
• Reset state so users can enter custom data

🎨 UI Components

RadioButtons (Vehicle Type Selection)

RadioButtons (Calculation Mode Selection)

• CatalogRefCalcRb: Select from catalog specs
• ManualInputCalcRb: Manually enter custom data

ComboBox

• VehicleTypeCbox: Model selection (dynamically filtered by vehicle type)

DataGridView

• CatalogSpecDgv: Manufacturer catalog data (Loaded from Excel)
• ManualInputDgv: User's custom registered data (Loaded from Excel)

Input TextBoxes (Parameters)

Output TextBoxes (Calculation Results)

Buttons

• TextRecalcTb: Execute recalculation after parameter changes
• TextValueClearBt: Clear all TextBoxes and enter manual input mode
• ReachCloseBt: Close the form

TabControl (PictureBox1)

• ReachTypeTp: Dimension diagram tab for reach type
• Counter3WheelTp: Dimension diagram tab for 3-wheel counterbalance
• Counter4WheelTp: Dimension diagram tab for 4-wheel counterbalance

🎯 Visual Feedback

Background Color Usage

Show/Hide Controls

• Shown only when Reach Type is selected:
  • Reach Stroke L / RSTb
  • Back Overhang L / BOTb
• Hidden when Counterbalance Types are selected:
  • Reach Stroke related controls
  • Back Overhang related controls

🔄 Overall Processing Flowchart

┌─────────────────────────────────────┐
│   Form Load                         │
└──────────┬──────────────────────────┘
           │
           ├→ Expiration / Copyright Display
           ├→ File Verification
           ├→ Set Excel Path
           ├→ Load Catalog Spec Data
           ├→ Load Manual Input Data
           └→ RadioButton Chk (Initial Display)
           │
           ▼
┌─────────────────────────────────────┐
│   Vehicle Type Selection (RadioBtn) │
│   Reach / 3-Wheel / 4-Wheel         │
└──────────┬──────────────────────────┘
           │
           ├→ Change Background Color
           ├→ Toggle Tab Display
           └→ Call VehicleTypeCboxChange1
           │
           ▼
┌─────────────────────────────────────┐
│   Calc Mode Selection (RadioBtn)    │
│   Catalog Ref / Manual Input        │
└──────────┬──────────────────────────┘
           │
           ├→ Catalog Ref: DataGridView = CatalogSpecDgv
           └→ Manual Input: DataGridView = ManualInputDgv
           │
           ▼
┌─────────────────────────────────────┐
│   Model Selection (ComboBox Change) │
└──────────┬──────────────────────────┘
           │
           └→ TextBox Display Processing
           │
           ▼
┌─────────────────────────────────────┐
│   TextBox Display Processing        │
└──────────┬──────────────────────────┘
           │
           ├─ Retrieve model data from DataGridView
           ├─ Set values to each TextBox
           ├─ Set ReadOnly / Background Colors
           ├─ Show/Hide controls based on vehicle type
           │
           ├─ If Reach Type
           │   ├→ BO = RS - FO
           │   ├→ R2 = √((PW/2)² + (PD-BO)²)
           │   └→ R = R1 + R2 + C×2
           │
           ├─ If 3-Wheel Counterbalance
           │   ├→ R2 = √((PW/2)² + (PD+BO)²)
           │   └→ R = R1 + R2 + C×2
           │
           └─ If 4-Wheel Counterbalance
               ├→ R2 = √((PW/2+W/2)² + (PD+BO)²)
               └→ R = R1 + R2 + C×2
           │
           ▼
┌─────────────────────────────────────┐
│   Parameter Adjustment (User Input) │
│   Change PW, PD, C, etc.            │
└──────────┬──────────────────────────┘
           │
           ▼
┌─────────────────────────────────────┐
│   Recalculate Button Click          │
└──────────┬──────────────────────────┘
           │
           ├─ Input Check (Required fields)
           ├─ Range Check (Validity verification)
           ├─ Execute Calc by Vehicle Type
           ├─ Recalculate R2, R
           └─ Toggle Background Color (Visual feedback)
           │
           ▼
┌─────────────────────────────────────┐
│   Display Calculation Results       │
│   Display results in R2Tb, RTb      │
└─────────────────────────────────────┘

💡 Use Cases

1. New Warehouse & Layout Design

• Aisle width simulation before selecting forklift models
• Verification of support for multiple pallet sizes
• Maximizing storage efficiency by securing minimum aisle widths

2. Introducing Forklifts to Existing Warehouses

• Selecting usable models based on existing aisle widths
• Support for selecting replacement models
• Studying the trade-off between operational efficiency and aisle width

3. Impact Analysis of Pallet Size Changes

• Studying pallet standardization (e.g., 1100mm → 1000mm)
• Evaluating the feasibility of introducing special-sized pallets
• Checking impacts on aisle widths

4. Clearance Optimization

• Balancing safety and efficiency
• Accounting for differences between veterans and newcomers
• Analyzing the relationship between work speed and clearance

5. Calculating Special Specifications Not in Catalogs

• Entering custom data in manual input mode
• Verifying modified or special vehicles
• Confirming dimensions for foreign-made forklifts

📊 Calculation Examples

Example 1: Reach Type Forklift (Standard Pallet)

Example 2: 3-Wheel Counterbalance Forklift

⚠️ Important Notes & Constraints

Calculation Prerequisites

Practical Notes

Data Input Notes

Out-of-Range Warnings

The system displays warning message boxes for values outside the following ranges:

• Vehicle Total Width: 800 - 2000 mm
• Min Turning Radius: 1000 - 3000 mm
• Pallet Width: 700 - 2000 mm
• Pallet Depth: 900 - 2000 mm
• Reach Stroke: 300 - 1000 mm
• Front Overhang: 100 - 800 mm
• Clearance: 80 - 500 mm

🔗 Related Modules

This utility integrates with the following Tera Calculation Systems:

• T3_2 Packaging Volume Calc: Calculation of pallet counts
• T3_3 Storage Space Calc: Layout design considering aisle widths
• T3_4 Shipping Space: Aisle planning in shipping areas

💾 File & Data Structure

Excel Files

Data Column Structure

• Serial No
• Change Date/Time
• Vehicle Type (Reach, 3-Wheel Counterbalance, 4-Wheel Counterbalance)
• Model
• Rated Load (kg)
• Vehicle Total Length (mm)
• Vehicle Total Width (mm)
• Min Turning Radius (mm)
• Pallet Width (mm)
• Pallet Depth (mm)
• Reach Amount (mm) *Reach type only
• Front Overhang (mm)
• Clearance (mm)

Data Connection

🎓 Basics of Aisle Width Design

Factors Determining Aisle Width

1. Forklift Model: Minimum turning radius is most important.
2. Pallet Size: Larger pallets require wider aisles.
3. Work Frequency: High frequency requires more margin.
4. Operator Skill: Wider settings needed if many beginners.
5. Safety Standards: Company regulations and industry standards.

Aisle Width Guidelines

Aisle Width Optimization Points

• Storage Efficiency: Narrow aisle → Increased storage space
• Work Efficiency: Wide aisle → Increased operational speed
• Safety: Appropriate clearance → Accident prevention
• Future-Proofing: Margin design anticipating future model changes

📚 Summary

T3_Uty4_ForkliftLoadingAisleWidth.vb is a specialized tool that precisely calculates the required aisle width for a forklift's right-angle stacking operations.

Key Features

• ✅ Supports 3 types of forklifts (Reach, 3-wheel counter, 4-wheel counter)
• ✅ Supports both catalog specification lookups and manual entries
• ✅ Flexible adjustment of pallet sizes and clearances
• ✅ Implements accurate calculation formulas for each vehicle type
• ✅ Input value validity check feature
• ✅ Visual feedback (background colors, dimension diagram displays)
• ✅ Extensibility via Excel integration

Application Areas

• Designing new warehouses and logistics centers
• Planning forklift introductions for existing facilities
• Layout modifications and optimizations
• Studies on pallet standardization
• Balancing operational efficiency and storage efficiency

Points for Improving Calculation Accuracy

• Use accurate catalog values (official manufacturer data)
• Reflect actual pallet measurements (checking differences from standard specs)
• Consider the physical environment (floor conditions, lighting, visibility)
• Set clearance according to operator skill levels
• Verify by conducting test runs in actual operations

📞 Support Information

Document Date: Auto-generated

Target File: T3_Uty4_ForkliftLoadingAisleWidth.vb

Language: Visual Basic .NET (VB.NET)

Total Lines: 350 lines

Core Technologies: Windows Forms, Excel Integration (OleDb/Interop), Geometric Calculations (Pythagorean Theorem)

Calculation Targets: Reach type, 3-Wheel Counterbalance, 4-Wheel Counterbalance forklifts