Tera Calculation Software Workflows & Module Specifications
Comprehensive technical documentation detailing operational workflows,
primary system roles, and core code execution functions across all software
modules (Tera Calculation 0 to 4).
Tera Calculation 0: Shipping Data Processing
Execution Workflow (Initialization to EIQ Preparation)
Step 1: On screen load, executes HelpSettings() and FileCheck().
Step 2: Verifies presence of database file (TeraCalculation.accdb).
Step 3: Checks status of T110_CategoryConversion table, displaying Completed/Pending status.
Step 4: Executes BatchDataProcessing() via the "Batch Data Processing 1" trigger.
Step 5: Transitions to "EIQ Data Processing" screen, executing CreateT200_EIQDataProcessing().
Step 6: Displays results via ShowEIQRankSummary() and ShowEIQProcessedData().
System Overview & Core Function
Tera Calculation 0 (Shipping Data Processing.vb) serves as the pre-processing engine structuring raw shipping logs for
downstream analytics in Modules 1 and 2.
It executes table generation, unit conversions, case/piece categorization,
and preliminary aggregations to output foundational EIQ datasets (T200
series).
Primary Execution Functions
BatchDataProcessing() / DeleteAllTables() / CreateT200_EIQDataProcessing()
ShowEIQRankSummary() / ShowEIQProcessedData()
Tera Calculation 1: Module 1 - Shipping Data Analytics
Execution Workflow (Initialization to EIQ Profiling)
Step 1: On screen load, executes FileCheck().
Step 2: Verifies presence of table T200 (prompts execution of Module 0 if missing).
Step 3: Generates required query tables ➔ Renders UI ➔ Displays total dataset
characteristics ➔ Generates target date tables.
Step 4: Click "Custom Filter Calculation" to trigger StartCustomFilterCalculation().
Step 5: Executes ProcessAllShippingData() if "All Shipping Data" is selected; otherwise executes ProcessSelectedDate().
Step 6: Computes EIQ matrices, calculates ratios, renders data views, and updates
case/piece color coding.
System Overview & Core Function
1_ShippingDataAnalytics.vb utilizes Module 0 datasets to execute multi-dimensional EIQ matrix profiling.
It switches between custom filtering, total dataset analytics, traditional
ABC profiling, and ratio views to clarify shipping structures for downstream
equipment assignment.
Primary Execution Functions
StartCustomFilterCalculation() / ProcessSelectedDate() / ProcessAllShippingData()
CalculateEIQMatrix() / CalculateEIQRatios() / RenderEIQMatrixView()
Tera Calculation 1: Module 2 - Inventory & Inbound Estimator
Execution Workflow (Initialization to Inventory Estimation)
Step 1: On screen load, executes FileCheck() and aggregates case/piece volume flows.
Step 2: Loads case shipping SKU counts, order frequencies, and volumes via AggregateCaseVolume().
Step 3: Loads piece shipping SKU counts, order frequencies, and volumes via AggregatePieceVolume().
Step 4: Calculates stable operating inventory days via "Start Case Analysis"
or "Start Piece Analysis".
Step 5: Computes average daily shipping throughput and updates inventory/inbound
calculation views.
Step 6: On form closure, prompts SaveCasePieceInventoryReceipts() if unsaved data exists.
System Overview & Core Function
2_InventoryInboundEstimation.vb calculates daily average case and piece shipping throughput from T200
tables.
Applying user-defined maximum and safety inventory days, it estimates required
operating inventory and inbound receipt volumes to size storage media.
Primary Execution Functions
AggregateCaseVolume() / AggregatePieceVolume() / RenderAverageVolumeGrid()
CalculateStableCaseInventoryDays() / CalculateStablePieceInventoryDays()
RenderCaseCalculationGrid() / RenderPieceCalculationGrid()
Tera Calculation 1: Module 3 - Equipment Assignment
Execution Workflow (Initialization to MHE Mapping)
Step 1: On load, executes FileCheck(), renders daily summaries, and populates target date dropdowns.
Step 2: Prepares equipment mapping tables via CreateEIQMappingTables() and imports configuration files.
Step 3: Fetches case/piece rank keys and generates four equipment grids (storage
& shipping MHE).
Step 4: Ingests existing equipment configuration Excel files to render initial
mappings.
Step 5: Optionally sets recommended equipment automatically via TeraEquipmentPresetRadioButton.
Step 6: Saves mapping configurations to Excel via "Export Equipment Config"
for downstream sizing.
System Overview & Core Function
3_EquipmentAssignment.vb maps specific storage and shipping material handling equipment (MHE) to
SKU ranks derived from EIQ analysis.
Configurations export to Excel, serving as prerequisite inputs for capacity
sizing and inventory calculations.
Primary Execution Functions
RenderDailySummaryGrid() / SetTargetDateComboBox() / CreateEquipmentGrids()
ImportEquipmentExcel() / ExportEquipmentExcel()
Tera Calculation 1: Module 4 - Equipment Capacity Sizing
Execution Workflow (Initialization to Throughput Calculation)
Step 1: On screen load, executes FileCheck() to validate module navigation.
Step 2: Reads inbound case/piece volumes from InventoryInbound.xlsx via "Start Inbound Volume".
Step 3: Reads inventory case/piece volumes from InventoryInbound.xlsx via "Start Inventory Volume".
Step 4: Selects target shipping metrics (orders, pieces, cases, pallets, CBM,
weight) via "Start Outbound Volume".
Step 5: Generates table TS60 from TS50 summaries, populating rank and equipment capacity grids.
Step 6: Computes required hourly throughput capacities incorporating peak surge
ratios.
System Overview & Core Function
4_EquipmentCapacitySizing.vb estimates required hourly throughput capacities for individual MHE systems
using inventory, inbound, and outbound transaction data.
Dynamic unit switching and peak ratio multipliers establish realistic operational
capacity requirements.
Primary Execution Functions
ImportInventoryInboundExcel() / StartOutboundVolumeCalculation() / LoadWorkGrid()
RenderRankVolumeGrid() / RenderEquipmentCapacityGrid()
Tera Calculation 1: Module 5 - Material Flow Visualizer
Execution Workflow (Initialization to Flow Visualization)
Step 1: On screen load, executes FileCheck() and imports inventory/inbound Excel files.
Step 2: Prepares case/piece work grids and renders initial inbound, inventory,
and outbound volumes.
Step 3: Generates flow diagram visual elements via RenderInboundFlow(), RenderInventoryFlow(), and RenderOutboundFlow().
Step 4: Prepares equipment-specific shipping datasets via AggregateTS50().
Step 5: Triggers RefreshView() to update diagrams upon changing units (cases/pieces, pallets, CBM) or
metrics.
Step 6: Evaluates material flow balance across receiving, storage, and dispatch
on a unified screen.
System Overview & Core Function
5_MaterialFlowVisualizer.vb converts Module 1 analytics into a unified material flow diagram.
By toggling units and metrics, engineers evaluate volume balance and equipment
load distribution across the entire facility.
Primary Execution Functions
ImportInventoryInboundXLSX() / RenderInboundGrid() / RenderInventoryGrid() / RenderOutboundGrid()
RenderInboundFlow() / RenderInventoryFlow() / RenderOutboundFlow() / AggregateTS50() / RefreshView()
Tera Calculation 2: Distribution Center Capacity Sizing
Tera Calculation 2: Main Entry Menu
Execution Workflow (Menu Navigation)
Step 1: On load, executes FileCheck() and initializes copyright displays.
Step 2: Clicking "Tera Calculation 2 Data Processing" opens TeraCalculation2DataCreationForm modally.
Step 3: Clicking "Tera Calculation 2 Capacity Sizing" opens DCSizingForm_v5 modally.
Step 4: Clicking "Return to Menu" closes the form and returns to the
master menu.
System Overview & Core Function
TeraCalculation2_MainMenu.vb controls navigation between the Data Creation and Capacity Sizing modules
in Tera Calculation 2.
Primary Execution Functions
Form_Load() / DataProcessingButton_Click() / CapacitySizingButton_Click() / ReturnMenuButton_Click()
Tera Calculation 2: Data Creation Module
Execution Workflow (Data Generation & Rendering)
Step 1: Checks table T830_AllPieceDataEIQ and builds target date dropdowns.
Step 2: Clicking "Create Data" fetches total transaction days and initiates
table generation.
Step 3: Creates tables T610/T612/T614/T615/T620 to generate daily and shift-hour summaries.
Step 4: Builds EIQ series tables T700–T930, applying null-value corrections and table joins.
Step 5: Applies shipping unit parameters to update EIQ and traditional views.
Step 6: If "Delete All Data" is checked, purges T7–TA series tables to reset system state.
System Overview & Core Function
TeraCalculation2_DataCreation.vb executes batch generation and table restructuring required for distribution
center capacity sizing.
It generates daily summaries, total aggregations, and EIQ matrix tables
utilized by downstream sizing algorithms.
Primary Execution Functions
CreateDataButton_Click() / GetTotalDays() / RenderView()
CreateT610_TotalShippingSummary() / CreateT612_DailyShippingSummary() / CreateT620_DailyOperatingHours()
CreateT700_TemplateEIQ() / NullCorrection() / JoinEIQTables()
Integrated Capacity Sizing Workflow
Step 1: Launching main menu executes FileCheck().
Step 2: Opens DataCreationForm to generate base tables.
Step 3: Generates summary tables T610–T620 and EIQ tables T7–TA.
Step 4: Sets units and target dates to verify EIQ and traditional views.
Step 5: Opens DCSizingForm_v5 via "Capacity Sizing".
Step 6: Ingests total summaries, daily averages, and peak ratios to execute mathematical
capacity sizing.
System Overview & Core Function
Tera Calculation 2: DC Capacity Sizing calculates required distribution center space, labor staffing, and equipment
capacity using Module 1 datasets.
Primary Execution Functions
CreateDataButton_Click() / CreateT610_TotalShippingSummary() / CreateT612_DailyShippingSummary()
AggregateAllData() / AggregateDailyShipping() / CalculateOperatingHoursAndPeakVolume()
Tera Calculation 2: Capacity Sizing Interface
Execution Workflow (Sizing Execution)
Step 1: On load, executes FileCheck() and ingests daily summaries and case/piece aggregations.
Step 2: Computes peak hour volume ratios and shipping shift durations via CalculateOperatingHoursAndPeakVolume().
Step 3: Configures target date dropdowns and selects target dataset scope (Total
Average vs Peak Day).
Step 4: Generates EIQ work grids (TA10/TA20/TA30 series) for calculation processing.
Step 5: Executes mathematical sizing across receiving, storage, packing, and
shipping tabs.
Step 6: Applies peak ratio multipliers to display final distribution center footprint
and capacity requirements.
System Overview & Core Function
TeraCalculation2_DCSizingForm.vb serves as the primary sizing engine, calculating required facility footprints
and work capacities from EIQ tables.
It evaluates space and labor requirements across average and peak volume
scenarios.
Primary Execution Functions
Form_Load() / AggregateAllData() / AggregateDailyShipping()
AggregateCaseShippingData() / AggregatePieceShippingData()
CreateWorkGrid() / CalculateOperatingHoursAndPeakVolume() / SetDateComboBox()
Tera Calculation 3: Utility Suite
T3_Uty0 Menu Interface
Execution Workflow (Utility Navigation)
Step 1: On load, initializes expiration displays via MenuForm_Load().
Step 2: Selects utility calculators: Manual Formulas, Receiving Space, Packing
Volume, or Shipping Space.
Step 3: Opens target utility form modally to execute calculation routines.
Step 4: Executes specialized utilities: Truck Swept Path, Piece Container, Pallet
Stacking, or Aisle Width calculators.
Step 5: Closes individual utility forms to return to the utility menu.
Step 6: Terminates utility suite via "Exit Program".
System Overview & Core Function
Tera Calculation 3 Utility Suite provides standalone engineering calculators for routine logistics calculations.
It complements Modules 1 and 2 by offering rapid tools for dock sizing,
container packing, pallet stacking, and aisle width engineering.
Primary Execution Functions
ManualCalculationButton_Click() / InboundSpaceButton_Click() / PackingVolumeButton_Click()
TruckSweptPathButton_Click() / PieceContainerButton_Click()
PalletStackingButton_Click() / AisleWidthButton_Click() / ExitProgramButton_Click()
Tera Calculation 3: Equipment Footprint Calculator
T3_0 Menu Interface
Execution Workflow (Equipment Calculator Navigation)
Step 1: On load, verifies copyright, license key, and software expiration status.
Step 2: Selects target equipment type (Pallet AS/RS, Selective Racking, Mobile
Racking, Carton AS/RS, Sorter).
Step 3: Launches selected equipment footprint calculator form modally.
Step 4: Enters dimensional parameters to compute required installation footprint
area.
Step 5: Closes calculator form and returns to equipment menu to model additional
MHE systems.
Step 6: Closes equipment menu via "Close".
System Overview & Core Function
Tera Calculation 3 Equipment Calculator models required installation footprints for specific material handling
equipment.
It evaluates clear dimensions for AS/RS systems, mobile racks, flow racks,
and sorters to support master layout design.
Primary Execution Functions
MenuForm_Load() / PalletASRSButton_Click() / SelectiveRackButton_Click() / MobileRackButton_Click()
CartonASRSButton_Click() / ToteASRSButton_Click() / FlowRackButton_Click() / MediumShelvingButton_Click()
CaseSorterButton_Click() / ManualSortButton_Click() / PackSpaceButton_Click() / CloseButton_Click()
Tera Calculation 4: Reference Module
Tera Calculation 4 Reference Menu
Execution Workflow (Reference Navigation)
Step 1: Displays Reference Module menu interface.
Step 2: Click "Reference EIQ" to launch TeraCalculation4_ReferenceEIQForm.
Step 3: Click "Traditional Analytics" to launch TeraCalculation4_ReferenceTraditionalForm.
Step 4: Evaluates comparative analytics views and closes form.
System Overview & Core Function
Tera Calculation 4 Reference Module provides comparative views contrasting EIQ analysis results against traditional
ABC analytics.
It serves as an educational and verification tool for auditing system calculations.
Primary Execution Functions
ReferenceEIQButton_Click() / TraditionalAnalyticsButton_Click() / CloseButton_Click()
Tera Calculation 4: EIQ Reference Viewer
Execution Workflow (EIQ Verification)
Step 1: On load, executes FileCheck() and loads summary data grids.
Step 2: Sets default analytical parameters via SetRecommendedEIQPresets().
Step 3: Updates curves, scatter plots, EIQ tables, and matrix views upon tab
switching.
Step 4: Re-aggregates custom datasets via the Custom Filter tab.
System Overview & Core Function
4_ReferenceEIQ.vb provides multi-dimensional visualization of EIQ analytics results.
Toggling tabs renders EIQ curves, scatter distribution plots, and matrix
tables for comparative audit.
Primary Execution Functions
ReferenceEIQ_Load() / TabControl_SelectedIndexChanged() / SetRecommendedEIQPresets()
Tera Calculation 4: Traditional Analytics Viewer
Execution Workflow (Traditional ABC Verification)
Step 1: On screen load, executes FileCheck().
Step 2: Renders AggregateAllData() and DisplayDatasetCharacteristics().
Step 3: Renders auxiliary data via EstimateCartonDimensions() and chart initialization.
Step 4: Navigates to unit summaries and ABC analysis tabs for comparative verification.
System Overview & Core Function
4_ReferenceTraditional.vb renders conventional 5-rank ABC aggregations to contrast against EIQ matrix
profiling.
Primary Execution Functions
Form_Load() / AggregateAllData() / DisplayDatasetCharacteristics() / EstimateCartonDimensions() / CreateABCData()