Tera Calculation 0 Master Spec

Tera Calculation 0: Data Processing Specification Manual

Comprehensive technical manual integrating system functions, operating procedures, and internal logic for Module 0, which ingests Excel logs into Access DB to build EIQ analytical tables.

1. Module Purpose & System Overview

TeraCalculation0_ShippingDataProcessing.vb ingests raw ShippingData.xlsx into the Access database. It categorizes shipping unit formats, executes daily aggregations, and generates master EIQ analytical tables (T200 series).

Inports raw Excel shipping transaction logs into Access DB.
Converts units and classifies Case, Piece, and Mixed Case/Piece shipments.
Creates daily summaries, master totals, and preliminary aggregations.
Applies rank classification logic to generate analytical tables like T200.
Updates rank key parameters in Excel configuration files.

2. Prerequisites & Startup Execution Logic

2.1 Pre-Execution Requirements

Verify presence of Access database TeraCalculation.accdb.
Verify presence of ShippingData.xlsx in the working directory.
Verify presence of Settings.xlsx configuration file.
Backup previous database files if re-running data processing routines.

2.2 Startup Verification Workflow

Verifies database integrity on form initialization:

flowchart TD A["Form Load"] --> B["Help Settings / File Check"] B --> C{"Database Exists?"} C -- "No" --> X["Display Error & Exit"] C -- "Yes" --> D{"T110_CategoryConversion Exists?"} D -- "No" --> E["Display Unprocessed Warning (Prompt Batch Run)"] D -- "Yes" --> F["Update UI to Processed State"]

3. Key UI Controls & Execution Triggers

Control / Button	Functional Role
Allow Delete All Tables	Enables permission checkbox to purge existing tables before re-processing.
Batch Processing 1	Executes batch routines from raw Excel ingestion to preliminary summaries.
EIQ Data Processing	Executes ranking algorithms, generating `T180_EIQRank` and master `T200` tables.
View Processed Data	Renders generated tables (`T000`, `T180`, `T110`, `T200`) in grid views.
Reset Tera Presets	Resets rank percentage thresholds and selection parameters to defaults.

4. Core Processing Workflows

4.1 Batch Data Processing 1 Workflow

flowchart TD A0["Start Batch 1"] --> A1{"Allow Delete Checkbox Checked?"} A1 -- "No" --> A9["Display Warning & Exit"] A1 -- "Yes" --> B1["Ingest Excel Shipping Data"] B1 --> B2["Create T100_Data Table"] B2 --> B3["Create T110_CategoryConversion Table"] B3 --> B4["Execute Unit Conversions"] B4 --> B5["Classify Shipping Unit Formats"] B5 --> B6["Generate Daily Summaries"] B6 --> B7["Display Preliminary Grids"] B7 --> B8["Summarize Case/Piece Categories"] B8 --> B9["Render Output Views"] B9 --> C0["Update Progress Bar & Complete"]

4.2 Category Conversion Formulas (T110)

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

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

5. EIQ Data Processing & Rank Generation

5.1 Rank Classification Logic

Keys are summed in descending order and assigned ranks based on cumulative volume ratios:

Cumulative Share Range	Assigned Rank
0 to A1%	A1
A1% to (A1+A2)%	A2
(A1+A2)% to (A1+A2+B)%	B
(A1+A2+B)% to (A1+A2+B+C)%	C
Remaining Share	D

5.2 Generated Output Tables

T150_UnitShippingSummary: Ranks grouped by Case/Piece × Destination (E) / Item (I).
T160_TotalShippingSummary: Total shipping ranks keyed on GPL for facility capacity sizing.
T180_EIQRank: Line-item level rank assignments.
T200: Integrated master analytical dataset joining shipping logs, unit conversions, and EIQ ranks.

← Back to Menu

Tera Calculation Manual Menu