Tera Calculation Manual Menu

jp tw Email MAP___ By Logistics Technology Institute
TeraCalculation_Traditional.vb Code Specification

TeraCalculation_Traditional.vb Specification Manual

Traditional Statistical Analytics Module - Complete Technical Specification

~1,182 Lines / Visual Basic .NET

📊 Module Metadata

File Name: TeraCalculation_Traditional.vb

Line Count: ~1,182 lines

Class Name: TeraCalculation4_ReferenceTraditionalForm

Base Inheritance: Form (Windows Forms)

Module Function: Statistical aggregation and conventional ABC analysis of shipping transaction logs.

1. Module Architecture Overview

💡 Role of this Module
Provides intuitive conventional analytics, centering on basic statistical summaries, 5-tier ABC Pareto profiling, and trend charting.

Tab Control Interface Structure

Imported Namespaces

Imports System.Data.OleDb Imports System.Windows.Forms.DataVisualization.Charting

2. Total Dataset Aggregation & Dimension Estimation

📊 Aggregation Scope

Display Item Description Data Source Table
Daily Summary Detailed daily metrics (13 parameters) T230_DailySummary
Destinations & SKUs Actual total customer destination & SKU counts T130_TotalShippingSummary
Cumulative Destinations Sum of daily active destination counts Sum from T230_DailySummary
Cumulative SKUs Sum of daily active SKU counts Sum from T230_DailySummary

📊 Statistical Ratios & Carton Dimension Estimation

Calculates average, maximum, and minimum values across the following operational metrics:

Carton Dimension Estimation Logic: - Volume = W × D × H - Cross-referenced with weight parameters - Identifies predominant carton dimensions

3. Unit-Level Shipping Analytics & ABC Analysis

📊 Unit-Level Shipping Analytics

Aggregation Mode Description Content
Unit Analytics 1 Cross-tabulation: Date × Shipping Unit Daily details grouped by shipping unit
Unit Analytics 2 Master unit summary Cumulative totals per shipping unit
Unit Charts Chart visualizer 3 selectable trend chart display modes

📊 ABC Pareto Analysis

💡 What is ABC Analysis?
Based on Pareto's 80/20 rule, it classifies SKUs into Rank A (critical), Rank B (moderate), and Rank C (low volume) to prioritize inventory management.
Rank Cumulative Share Priority Status Operational Strategy
A 0 – 70% Top Priority SKUs Fast-picking zones, safety stock buffer
B 70 – 90% Moderate Priority SKUs Standard storage media
C 90 – 100% Low Velocity SKUs Dense high-bay storage

4. Database Schema & Key Methods

Database Tables

Table Name Description Usage Module
T130_TotalShippingSummary Master summary table Total Dataset Aggregation Tab
T230_DailySummary Daily summary table Total Dataset Tab & Daily Charts
T330_DailyUnitSummary Date × Unit cross-summary Unit-Level Shipping Tab
TABC010_ItemSummary Item ABC analysis table ABC Analysis Tab
TABC010_DestinationSummary Destination ABC table ABC Analysis Tab

Primary Class Methods

Category Method Name Description
Form Control Form1_Load Initializes form, loads data summaries, estimates carton sizes, and sets charts
TraditionalTc_SelectedIndexChanged Tab switching handler; triggers data loading on tab display
ABC Analysis CreateABCData() Executes Access macro "RunABCAnalysis" via COM Interop
CreateABCParetoChart() Renders cumulative Pareto curves directly onto PictureBox via GDI+

5. Comparison: Traditional Analytics vs EIQ Analysis

Feature Traditional Analytics EIQ Analysis
Analytical Focus Time-series, ABC, Unit ratios Entry × Item cross-matrix
Complexity Beginner to Intermediate Advanced Systems Engineering
Execution Speed High Speed Requires extended processing
Primary Purpose Executive summary, daily reporting Facility sizing, layout optimization
← Back to Menu