📋 Screen Overview
The TeraCalc1_Data Analysis Summary Tab (EIQ Data Analysis Tab) is the primary engine interface for executing EIQ analysis and filtering shipping data based on custom parameters. It evaluates outbound logistics records across Entry, Item, and Quantity dimensions to support facility design and operational slotting.
🎯 Primary Screen Objectives
- Data Extraction: Filter records by Item Category, Shipping Category, Route, and Time Slot.
- EIQ Analysis: Evaluate 3D order attributes across Entry (frequency), Item (SKU characteristics), and Quantity (volume).
- Matrix Visualization: Render the **original 5x5 EIQ Matrix Table devised by Toshiyuki Teramoto** to review distribution density.
- Ratio Calculations: Toggle between absolute numbers, Ratio A (within dataset), and Ratio B (across master data).
- Comparative Review: Compare matrix segments directly with traditional ABC calculation tables.
📌 UI Location
Located inside TabControl
Tab Header Text:
Located inside TabControl
データ分析Tc as Tab 1: "Tera計算1_データ分析集計Tp".Tab Header Text:
EIQデータ分析
🖼️ Screen Layout
Top Area: Filter Extraction Setup (GroupBox20)
Item Category
- Select All / Clear All RadioButtons
- Dgv DataGrid for Item Categories
Shipping Category
- Select All / Clear All RadioButtons
- Dgv DataGrid for Shipping Types
Shipping Route
- Select All / Clear All RadioButtons
- Dgv DataGrid for Routes
Dispatch Time 1
- Select All / Clear All RadioButtons
- Dgv DataGrid for Time Slots
✅ Filter Data Loaded Status Checkbox
Left Area: Analysis Setup (GroupBox6)
- 📅 Specify by Date RadioButton + Date ComboBox
- 📊 Specify by Characteristic RadioButton + Mode ComboBox
Center Top: Calculation Controls (GroupBox2)
- 🔢 Display Mode: Absolute / Ratio A / Ratio B
- 📦 Mode Switch: Full Case / Piece (Bara) Picking
- 🔘 Unit Selector: Lines / Pieces / Cases / Pallets / Volume / Weight
- ▶️ Execute Calculation Button (条件抽出_計算Bt)
- 💾 Export to Excel Button (Excel出力Bt)
Center Bottom: EIQ Matrix Grid View
- 📊 5x5 Intersectional Grid + Row/Column Sum Totals
- Cell Intersections: I-Rank (A1 to D) × E-Rank (A1 to D)
🎛️ Primary UI Controls
| Control Name | Type | Function / Purpose |
|---|---|---|
データ分析Tc |
TabControl | Main tab container managing all analysis screens. |
Tera計算1_データ分析集計Tp |
TabPage | Screen tab page ("EIQデータ分析"). |
GroupBox20 |
GroupBox | Container for extraction filter grids. |
条件抽出_計算Bt |
Button | Execute Calculation Button: Calls calculation routines. |
Excel出力Bt |
Button | Export Excel Button: Exports active grid results. |
📊 Area 3: EIQ Matrix Grid View
Matrix Architecture (I-Rank × E-Rank)
| E-A1 | E-A2 | E-B | E-C | E-D | Row Sum | |
|---|---|---|---|---|---|---|
| I-A1 | Cell Value | Cell Value | Cell Value | Cell Value | Cell Value | I-A1 Total |
| I-A2 | Cell Value | Cell Value | Cell Value | Cell Value | Cell Value | I-A2 Total |
| I-B | Cell Value | Cell Value | Cell Value | Cell Value | Cell Value | I-B Total |
| I-C | Cell Value | Cell Value | Cell Value | Cell Value | Cell Value | I-C Total |
| I-D | Cell Value | Cell Value | Cell Value | Cell Value | Cell Value | I-D Total |
| Column Sum | E-A1 Total | E-A2 Total | E-B Total | E-C Total | E-D Total | Grand Total |
📘 Slotting Strategy based on EIQ Matrix Sections:
- Top-Left Cells (I-A1/A2 × E-A1/A2): High-frequency SKUs ordered by major customers → Assign to automated pick zones or front pick lines.
- Center Area (I-B × E-B/C): Medium movement SKUs → Store in flow racks or standard picking aisles.
- Bottom-Right Cells (I-C/D × E-C/D): Slow-moving SKUs → Place in upper rack levels or remote reserve areas.
📖 Standard Workflow
- Open screen and verify filter data has loaded (check `条件抽出_条件データ読込済Cb`).
- Select Mode: Full Case or Piece Picking.
- Choose analysis timeframe or characteristic condition.
- Check desired extraction filters for Category, Route, and Time Slot.
- Select target physical metric unit (Lines, Pieces, Cases, Pallets, Volume, Weight).
- Click "条件抽出_計算" (Execute Calculation) to generate the EIQ Matrix.
- Review active matrix grid cells and export to Excel if required.