T3_5_Case_ASRS.vb Detailed Explanation

Purpose

The main form class that performs design calculations for the Case AS/RS. It supports mixed storage of multiple sizes and optimizes storage layout per tier.

Key Properties

This class inherits from System.Windows.Forms.Form and holds UI controls such as DataGridViews, TextBoxes, Labels, and Buttons. The main variables and controls are as follows:

• RequestedCaseCountDgv: DataGridView - Input and display of case specs and requested quantities.
• StorageDetailsDgv: DataGridView - Detailed display of stored case counts per tier.
• RackHeightDgv: DataGridView - Display of height information per tier.
• Basic Configuration: Columns, Bays_PerColumn, Tiers, Prerequisite Case Count.
• Case Information: Ratios, counts, required bays, and required tiers for Case Nos 1-4.
• Calculation Results: Required Width, Required Length, Required Height, Required Area.
• Image Path: MyJpgPath (Used for drawing display, currently commented out).

Key Methods / Functions

• CaseASRSCalc_Load - Form initialization and startup of main processes
• GetPathToFolderFromWhichProgramWasLaunched - Image path retrieval
• CaseASRSCalc_InitialSettings - Initialization and default value setting for DataGridView
• RackCountCalc - Main logic for case count, tier layout, and bay calculation
• StorageDetails - Calculates the detailed case storage layout for each tier
• DgvAggregation - Aggregation processing for DataGridView
• Layout_Calc - Calculation of overall warehouse dimensions and area
• LayoutRecalcBt_Click - Processing when the recalculation button is clicked
• DgvFormat - Formatting settings for DataGridView

Function Description

Event handler executed when the form loads. It sets copyright and expiration date displays, retrieves the image path, applies initial settings, and executes calculations sequentially.

Arguments

Return Value

Type: None (Sub)
Description: No return value as it is an event handler

Processing Flow

1. Set text for the copyright label and expiration date label.
2. Call GetPathToFolderFromWhichProgramWasLaunched() to set the image path.
3. Initialize DataGridViews via CaseASRSCalc_InitialSettings().
4. Execute case layout calculation via RackCountCalc().
5. Calculate warehouse dimensions and area via Layout_Calc().

Function Description

Initializes the Requested Case Count DataGridView and sets default case specifications and ratios. It performs adding columns, creating rows, setting cells as read-only, and inputting default values.

Arguments

None

Return Value

Type: None (Sub)
Description: Initialization of DataGridView only

Processing Flow

1. Clear DataGridView columns.
2. Add 11 columns:
   • Case Height Rank
   • Case No (1-4)
   • Case Width (Range display)
   • Case Length (Fixed 600mm)
   • Case Height (User editable)
   • Case Count Ratio % (User editable)
   • Requested Case Count (Auto-calculated)
   • Bay Capacity (6, 5, 4, 3)
   • Required Bays (Auto-calculated)
   • Bay Count A (Bays per column × 2)
   • Required Tiers (Auto-calculated)
3. Add 4 rows (for Case Nos 1-4).
4. Set fixed values (Case No, Case Width Range, Case Length, Bay Capacity).
5. Set default case heights (300, 400, 450, 500mm).
6. Set default case count ratios (20%, 40%, 35%, 5%).
7. Set the background color of editable cells (Case Height, Case Count Ratio) to PeachPuff.
8. Call RackCountCalc() to execute the initial calculation.

Function Description

This is the core calculation process for the Case AS/RS. It calculates the requested number of each case based on the prerequisite case count and case ratios, then computes the required number of bays and tiers. It then sorts by case height to determine the priority order for tier layout.

Arguments

None (gets values from controls on the form)

Return Value

Type: None (Sub)
Description: Calculation results are displayed in the DataGridView

Processing Flow

1. Get and Calculate Basic Values:
   • Total Bays = Columns × Bays_PerColumn × Tiers
   • Get Prerequisite Case Count
   • Bay Count A = Columns × Bays_PerColumn
2. Calculate Case Counts:
   • Sort by Case No (Ascending)
   • Get the ratio for each case
   • Case Nos 1-3: Round up using Int(Prerequisite Case Count × Ratio / 100 + 0.99999)
   • Case No 4: Remainder = Prerequisite Case Count - (Sum of Case Nos 1-3)
   • Display requested case counts in the DataGridView
3. Calculate Required Bay Count:
   • Case No 1: Int(Requested Count / 6 + 0.9999)
   • Case No 2: Int(Requested Count / 5 + 0.9999)
   • Case No 3: Int(Requested Count / 4 + 0.9999)
   • Case No 4: Int(Requested Count / 3 + 0.9999)
   • Calculate Total Required Bays
4. Setting Bay Count A:
   • For all cases, Bay Count A = Bays_PerColumn × 2
5. Calculate Required Tiers:
   • Required Tiers for each case = Required Bays / Bay Count A
   • Calculate Total Required Tiers
   • If Total Required Tiers > Specified Tiers, display a warning and Exit Sub
6. Sort by Case Height:
   • Sort in descending order by case height (tallest cases placed first)
   • Set Case Height Rank (1-4)
7. Call Subsequent Processes:
   • DgvFormat(RequestedCaseCountDgv)
   • StorageDetails()
   • DgvAggregation()
   • Layout_Calc()

Function Description

Calculates in detail which cases and how many are stored on each tier, and displays it in the Storage Details DataGridView. It implements a complex logic that fills tiers in order of height and fills remaining bays with the next case.

Arguments

None

Return Value

Type: None (Sub)
Description: Results are displayed in the Storage Details DataGridView

Processing Flow

1. Initialize DataGridView:
   • After clearing columns, add basic columns (Case Height Rank, Case No, Case Width, Case Length, Case Height, Required Bays).
   • Dynamically add columns for the number of tiers (Tier 01, Tier 02, ...).
   • Add 4 rows (for Case Nos 1-4).
2. Placement of Case Height Rank 1 (Tallest Case):
   • Get required number of bays.
   • Calculated Tiers = Int(Required Bays / Bay Count A + 0.999).
   • Remaining Bays = (Calculated Tiers × Bay Count A) - Required Bays.
   • Place Bay Count A in each tier from start tier to end tier.
   • Place (Bay Count A - Remaining Bays) in the final tier.
   • Save remaining bays for the next case.
3. Placement of Case Height Rank 2:
   • Consider the remaining bays from the previous case.
   • Required Bays = Requested Required Bays - Remaining Bays.
   • Calculate tier layout similarly.
   • Calculate new remaining bays.
4. Placement of Case Height Rank 3:
   • Place using similar logic.
5. Placement of Case Height Rank 4:
   • Place in all remaining bays.
   • Display if there are any unused bays.

Function Description

Calculates overall warehouse dimensions (width, length, height) and required area. It also outputs height information for each tier to the Rack Height DataGridView.

Arguments

None (gets values from controls on the form)

Return Value

Type: None (Sub)
Description: Calculation results are displayed in TextBoxes and DataGridView

Processing Flow

1. Calculation of Required Width:
   • Rack Travel Width = Bay Width + Crane Aisle Width (For travel path)
   • Required Width = Rack Travel Width × Columns + Adjacent C × 2 + Inter-Column C × (Columns - 1)
2. Calculation of Required Length:
   • Bay Pitch = Bay Length + Pillar Width + Rack C
   • Total Rack Length = Bay Pitch × Bays + Pillar Width
   • Required Length = Total Rack Length + I/O CV Length + Work Area Length + Protective Pillars + Inspection Aisle
3. Calculation of Required Height:
   • Get height of each tier for Rack Height Dgv from Storage Details
   • Calculate (Case Height + Insertion Height C + Beam Thickness) for each tier
   • Calculate Required Height using sum of all tiers + Bottom Tier Offset + Ceiling C
4. Calculation of Required Area:
   • Required Area = (Required Width × Required Length) / 1000² [m²]

Function Description

Event handler executed when the "Recalculate Layout" button is clicked. Checks that the sum of case count ratios is 100% and executes recalculation.

Arguments

Return Value

Type: None (Sub)
Description: No return value as it is an event handler

Processing Flow

1. Calculate the sum of case count ratios (Loop through 4 rows and add).
2. If the sum is not 100, display an error message and Exit Sub.
3. If the sum is 100, execute RackCountCalc().
4. Toggle background color of Required Dimensions Tp (LightYellow ⇔ PowderBlue).

Function Description

Utility methods for adding aggregation rows and formatting DataGridViews.

Main Features

• DgvAggregation: Adds a total row to each DataGridView.
• DgvFormat: Cell formatting settings (text size, alignment, colors, etc.).