System Overview & Workflow

Tera Calculation 0: Software Overview & Flow

Technical overview summarizing software routines, code execution flows, and EIQ analytical data creation in Tera Calculation 0.

1. Module Overview

TeraCalculation0_ShippingDataProcessing.vb ingests raw ShippingData.xlsx into Access DB, executing category conversions, daily aggregations, and master EIQ data generation.

Inbound Excel shipping transaction log ingestion.
Case, Piece, and Mixed Case/Piece unit conversions.
Daily summary and preliminary table creation.
EIQ rank generation and master T200 table creation.
Updating rank key parameters in Excel settings.

2. Master System Flow

flowchart TD A["Launch Screen"] --> B["Verify DB / Initialize UI"] B --> C["Batch Processing 1"] C --> D["Read Shipping Excel Data"] D --> E["Create T100_Data Table"] E --> F["Create T110_CategoryConversion"] F --> G["Execute Unit Conversions"] G --> H["Build Daily & Preliminary Summaries"] H --> I["Display Case/Piece Category Views"] I --> J["EIQ Data Processing"] J --> K["Generate Ranks / T180 Table"] K --> L["Create Master T200 Table"] L --> M["Feed DC Capacity Sizing Engine"] M --> N["Update Excel Settings"]

3. Available Screen Capabilities

Feature / Control	Description
Allow Table Deletion Checkbox	Enables permission to purge existing database tables prior to re-processing.
Batch Processing 1 Button	Executes end-to-end data ingestion and preliminary summaries.
EIQ Data Processing Button	Executes rank classification, generating `T180_EIQRank` and master `T200` tables.
View Processed Data Button	Renders generated tables in grid views.
Reset Tera Presets Button	Resets rank thresholds and parameters to defaults.

4. Processing Phase 1 Details

Creates T100_Data from imported T000_ShippingData.
Calculates cases, pieces, pallets, volume, and weight in T110_CategoryConversion.
Categorizes shipments into Case-Only, Piece-Only, or Mixed Case/Piece formats.

Category Conversion Formulas (T110)

Base variables: calcC = Int(Pieces / CasePack), calcB = Pieces - (calcC × CasePack)

Category	Metric	Formula
Line Level (G)	G-Pcs	Pieces
Line Level (G)	G-Cases	Pieces / CasePack
Line Level (G)	G-PL	G-Cases / PalletTier
Line Level (G)	G-Vol	G-Cases × CaseCBM
Line Level (G)	G-Wt	G-Cases × CaseWeight
Case Level (C)	C-Pcs	calcC × CasePack
Case Level (C)	C-Cases	calcC
Case Level (C)	C-PL	C-Cases / PalletTier
Case Level (C)	C-Vol	C-Cases × CaseCBM
Case Level (C)	C-Wt	C-Cases × CaseWeight
Piece Level (B)	B-Pcs	calcB
Piece Level (B)	B-Cases	B-Pcs / CasePack
Piece Level (B)	B-PL	B-Cases / PalletTier
Piece Level (B)	B-Vol	B-Cases × CaseCBM
Piece Level (B)	B-Wt	B-Cases × CaseWeight

← Back to Menu