📋 Tab Overview
🎯 What is "All Data Summary & Characteristics Tab"?[cite: 2]
This tab calculates statistical summaries of filtered all shipping data (T200 table)
and presents key logistics characteristics numerically[cite: 2].
It displays not only total counts of destinations, items, lines, and volume,
but also averages per customer/item and Max/Avg/Min metrics for case pack counts, pallet stacking, volume, and weight[cite: 2].
This tab calculates statistical summaries of filtered all shipping data (T200 table)
and presents key logistics characteristics numerically[cite: 2].
It displays not only total counts of destinations, items, lines, and volume,
but also averages per customer/item and Max/Avg/Min metrics for case pack counts, pallet stacking, volume, and weight[cite: 2].
This tab operates on an auto-calculating, read-only basis and automatically updates whenever condition extraction completes[cite: 2].
🎯 Purpose and Role
Main Objectives
- Overall Profile Understanding: Grasp dataset volume and structure through core figures[cite: 2].
- Logistics Characteristic Analysis: Review average demand metrics per customer and per item[cite: 2].
- Facility Design Baselines: Obtain case dimensions, weights, and pallet specs for design input[cite: 2].
- Throughput Capacity Estimation: Derive needed system capacity from total line counts and volume[cite: 2].
- Data Validation: Identify extreme values (Max/Min) to verify source data quality[cite: 2].
System Context
| Item | Details |
|---|---|
| Parent Form | 1出荷データ分析.vb[cite: 2] |
| Parent TabControl | データ分析Tc[cite: 2] |
| Tab Name | 全データ集計及び特性[cite: 2] |
| TabPage Name | 全データ集計及び特性Tp[cite: 2] |
| Tab Index | TabIndex = 3 (Next to EIQ Data Analysis)[cite: 2] |
| Data Sources | T200 (Filtered Shipping Data) T230 (Case/Loose Totals) T250 (Case Volume Max/Avg/Min)[cite: 2] |
| Update Trigger | Executes automatically after clicking "条件抽出_計算Bt"[cite: 2] |
🖼️ Screen Layout
Hierarchical Structure
Inside 全データ集計及び特性Tp, TabControl1 houses two sub-tabs[cite: 2]:
| Control Name | Type | Content |
|---|---|---|
TabControl1 |
TabControl | Container control managing sub-tabs[cite: 2] |
目隠しTp |
TabPage | Sub-tab 1: Displays characteristics viewed from overall totals[cite: 2] |
ケースバラ日別集計Tp |
TabPage | Sub-tab 2: Displays daily trend summaries[cite: 2] |
全データ集計から見た特性Dgv |
DataGridView | Shows statistical matrix in a 9-row by 9-column grid[cite: 2] |
📘 Technical Note on "目隠しTp"
Though named "目隠しTp" internally, Sub-tab 1 serves as the primary view for overall logistics statistics[cite: 2].
Though named "目隠しTp" internally, Sub-tab 1 serves as the primary view for overall logistics statistics[cite: 2].
📊 Global Statistics
Main Aggregate Items (Row 1)
📦 Overall Shipping Totals
Shows total aggregated values from the extracted T200 table[cite: 2].
| Metric | Description | Unit |
|---|---|---|
| Destinations | Total count of unique shipping destinations[cite: 2] | Count[cite: 2] |
| Items | Total count of unique SKU items[cite: 2] | SKU[cite: 2] |
| Order Lines | Total shipping order records[cite: 2] | Lines[cite: 2] |
| Piece Count | Total quantity in individual pieces[cite: 2] | Pcs[cite: 2] |
| Case Count | Total converted case count[cite: 2] | Cases[cite: 2] |
| Pallet Count | Total converted pallet count[cite: 2] | PL[cite: 2] |
| Volume | Total cubic volume[cite: 2] | m³[cite: 2] |
| Weight | Total shipping weight[cite: 2] | kg[cite: 2] |
Example Display
| Metric Row | Destinations | Items | Lines | Pieces | Cases | Pallets | Volume | Weight |
| Total Values | 200 | 1,000 | 5,000 | 50,000 | 10,000 | 500 | 1,200 | 60,000 |
📐 Per-Unit Averages
Per Destination
🏢 Average Demand per Shipping Destination
Calculated by dividing overall totals by total destination count[cite: 2].
| Metric | Calculation Formula |
|---|---|
| Items / Destination | Total Items ÷ Total Destinations[cite: 2] |
| Lines / Destination | Total Lines ÷ Total Destinations[cite: 2] |
| Pieces / Destination | Total Pieces ÷ Total Destinations[cite: 2] |
| Cases / Destination | Total Cases ÷ Total Destinations[cite: 2] |
| Pallets / Destination | Total Pallets ÷ Total Destinations[cite: 2] |
| Volume / Destination | Total Volume ÷ Total Destinations[cite: 2] |
| Weight / Destination | Total Weight ÷ Total Destinations[cite: 2] |
Per Item
📦 Average Volume per Item SKU
Calculated by dividing overall totals by total item count[cite: 2].
| Metric | Calculation Formula |
|---|---|
| Destinations / Item | Total Destinations ÷ Total Items[cite: 2] |
| Lines / Item | Total Lines ÷ Total Items[cite: 2] |
| Pieces / Item | Total Pieces ÷ Total Items[cite: 2] |
| Cases / Item | Total Cases ÷ Total Items[cite: 2] |
| Pallets / Item | Total Pallets ÷ Total Items[cite: 2] |
| Volume / Item | Total Volume ÷ Total Items[cite: 2] |
| Weight / Item | Total Weight ÷ Total Items[cite: 2] |
📌 Practical Applications
- Per Destination: Helps evaluate customer order sizing for delivery vehicle planning[cite: 2].
- Per Item: Identifies SKU movement density for warehouse slotting & inventory control[cite: 2].
📈 Max / Avg / Min Metrics
Case Pack Size
📦 Quantity per Case
Derived from the "Case Pack Quantity" column in table T200[cite: 2].
| Metric | Description |
|---|---|
| Max Case Pack | Highest piece count per case (e.g., 100 pcs/case)[cite: 2] |
| Avg Case Pack | Average piece count across all cases (e.g., 50 pcs/case)[cite: 2] |
| Min Case Pack | Lowest piece count per case (e.g., 10 pcs/case)[cite: 2] |
Pallet Stacking Quantity
🏗️ Cases per Pallet
Derived from the "Pallet Stacking Capacity" column in table T200[cite: 2].
| Metric | Description |
|---|---|
| Max Stacking | Maximum case capacity per pallet (e.g., 50 cases/PL)[cite: 2] |
| Avg Stacking | Average cases per pallet (e.g., 30 cases/PL)[cite: 2] |
| Min Stacking | Minimum case capacity per pallet (e.g., 10 cases/PL)[cite: 2] |
Case Volume
📏 Volume per Case (m³)
Derived from the "Case Volume" column in table T200[cite: 2].
| Metric | Description |
|---|---|
| Max Volume | Largest case volume (e.g., 0.150 m³)[cite: 2] |
| Avg Volume | Average case volume (e.g., 0.050 m³)[cite: 2] |
| Min Volume | Smallest case volume (e.g., 0.010 m³)[cite: 2] |
Case Weight
⚖️ Weight per Case (kg)
Derived from the "Case Weight" column in table T200[cite: 2].
| Metric | Description |
|---|---|
| Max Weight | Heaviest case weight (e.g., 30.0 kg)[cite: 2] |
| Avg Weight | Average case weight (e.g., 15.0 kg)[cite: 2] |
| Min Weight | Lightest case weight (e.g., 5.0 kg)[cite: 2] |
🏗️ Pallet Specifications
Standard Specifications
📦 Pallet Dimensions & Capacities
Standard physical attributes defined by default system rules[cite: 2].
| Item | Value | Unit |
|---|---|---|
| Pallet Width (W) | 1100[cite: 2] | mm[cite: 2] |
| Pallet Depth (D) | 1100[cite: 2] | mm[cite: 2] |
| Pallet Tare Height | 144[cite: 2] | mm[cite: 2] |
| Cargo Load Height | 1700[cite: 2] | mm[cite: 2] |
| Total Height (Pallet + Cargo) | 1844[cite: 2] | mm[cite: 2] |
| Pallet Weight | 20[cite: 2] | kg[cite: 2] |
| Max Load Capacity | 1000[cite: 2] | kg[cite: 2] |
Case Dimension Estimation
📐 Estimated Average Case Dimensions
Estimates average case dimensions (Width × Depth × Height) based on mean case volume[cite: 2].
Estimation Logic
- Assumes a standard dimensional aspect ratio (W:D:H = 5:4:3)[cite: 2].
- Calculates exact millimeter dimensions backwards from average volume (m³)[cite: 2].
📖 Usage Guide
Standard Operation Steps
-
Run Condition Extraction[cite: 2]
- Set conditions on the "EIQ Data Analysis" tab[cite: 2].
- Click "条件抽出_計算Bt"[cite: 2].
-
Select "All Data Summary & Characteristics" Tab[cite: 2]
- Select the tab from the main TabControl[cite: 2].
- Statistics will be loaded automatically[cite: 2].
-
View Data Grid[cite: 2]
- Inspect metrics inside
全データ集計から見た特性Dgv[cite: 2]. - Copy or screen capture tables for reporting if needed[cite: 2].
- Inspect metrics inside
📚 Data Interpretation & Validation
⚠️ Data Quality Warnings
- Min Case Pack < 1: Indicates missing or faulty packing data[cite: 2].
- Max Case Weight > 100kg: Indicates input typos or erroneous weight units[cite: 2].
💼 Case Studies
Case Study 1: Warehouse Footprint Estimation
Objective
Estimate minimum required floor space for a logistics center[cite: 2].
Steps
- Check total pallet count from this tab (e.g., 500 PL)[cite: 2].
- Apply storage footprint allowance (e.g., 1.5 m²/PL including aisle clearance)[cite: 2].
- Storage Area = 500 PL × 1.5 m² = 750 m²[cite: 2].
- Factor buffer ratio (e.g., 2.0× buffer) = 750 m² × 2 = 1,500 m² total[cite: 2].