TeraCalculation_EIQ.vb Code Specification

TeraCalculation_EIQ.vb Specification Manual

EIQ Detailed Analytics Module - Complete Technical Specification

~2,479 Lines / Visual Basic .NET

📊 Module Metadata

File Name: TeraCalculation_EIQ.vb

Line Count: ~2,479 lines

Class Name: teraCalculation4_ReferenceEIQForm

Base Inheritance: Form (Windows Forms)

Interface: IDisposable (Explicit memory disposal)

Module Function: Implements core EIQ Analysis (Entry-Item-Quantity) analytics and visualization.

1. Module Architecture Overview

💡 Role of this Module
Serves as the primary EIQ analytics engine in Tera Calculation, executing data ingestion, matrix calculations, and chart/grid visual rendering.

Primary Code Regions (#Region Structure)

1️⃣ Tab Control Handler

Manages tab switching and initialization across 7 analytics views.

2️⃣ My_DATA Management

Handles reading and updating analytical configuration parameters.

3️⃣ Shared Utilities & Helpers

Executes DataGridView formatting, cell alignment, and grid sizing.

4️⃣ EIQ Data Creation Screen

Imports raw Excel files and builds core Access database tables.

5️⃣ EIQ Trend Curves

Renders time-series trend line charts.

6️⃣ EIQ Scatter Plots

Renders Entry × Item scatter plot distributions and rank classifications.

7️⃣ EIQ Data Tables

Displays detailed summary grids.

8️⃣ EIQ Matrices

Displays customer destination × SKU cross-tabulation heatmaps.

9️⃣ Custom Filter Engine

Executes multi-query data filtering and recalculation.

2. Namespaces & Key Execution Methods

Imported Namespaces

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

📥 Form Initialization

Method Name	Role Description	Execution Flow
`teraCalculationEIQ_Load`	Form Load Initialization	• Verifies data folder paths • Renders total summary grids • Loads scatter plot rank data • Applies recommended EIQ presets

🔄 Tab Control Switching

Method Name	Tab Index	Execution Action
`EIQTc_SelectedIndexChanged`	Case 0	EIQ Data Creation Tab - Checks table generation status
	Case 1	EIQ Trend Curves Tab - Renders trend charts
	Case 2	EIQ Scatter Plot Tab - Displays initial scatter plot
	Case 3	EIQ Table Tab - Configures summary grids
	Case 4	EIQ Matrix Tab - Renders cross-tabulation matrix
	Case 5	Custom Filter Tab - Resets filter parameters
	Case 6	Tote Conversion Tab - Calculates container equivalents

💾 Configuration Data Persistence

Method Name	Type	Description
`UpdateMyData()`	Sub	Saves analytical parameters into table `My_DATA1` - Database and Excel file paths - Rank thresholds (A1/A2/B/C/D) - Case vs Piece targets - Target date parameters
`LoadMyData()`	Sub	Reads settings from `My_DATA1` into global variables

3. Database Table Schema

Input Tables

Table Name	Description	Data Source
`T000_ShippingData`	Raw transaction log table	ShippingData.xlsx / Sheet1
`My_DATA1`	System configuration table	User settings

Generated Analytical Tables

Table Name	Description	Content
`T130_TotalShippingSummary`	Master summary table	Cumulative dataset totals
`T230_DailySummary`	Daily summary table	Aggregations grouped by date
`T610_EIQTableCaseShipping`	Case EIQ matrix table	Entry × Item case matrix
`T620_EIQTablePieceShipping`	Piece EIQ matrix table	Entry × Item piece matrix
`T670_EIQScatterPlotRankData`	Scatter plot rank table	A1/A2/B/C/D rank classifications

4. Memory Management & Error Handling

Explicit Memory Disposal

IDisposable Implementation: Public Class teraCalculation4_ReferenceEIQForm Implements IDisposable
Garbage Collection Triggers: Calls GC.Collect() and GC.WaitForPendingFinalizers() to purge memory after rendering large DataGridViews.
Database Connection String: Provider=Microsoft.ACE.OLEDB.12.0;Data Source={MyDB}

Common Runtime Errors & Mitigations

Error Exception	Root Cause	Engineering Mitigation
FillWeight 65535 Overflow	Excessive DataGridView columns	Fix FillWeight=10 on dynamic columns
Rank Total Error	Rank sum does not equal 100%	Validate rank totals equal 100% prior to execution
Database Lock Error	Access file locked by another process	Close Access before running imports

← Back to Menu

Tera Calculation Manual Menu