📊 TeraCalc2 Manual

📊 TeraCalc2_2 Data Preparation.vb

Technical Specification - Data Processing and EIQ Table Generation Form

📋 Overview

TeraCalc2_2 Data Preparation.vb implements the core data processing and staging form for the TeraCalc2 DC sizing application. It builds 20+ intermediate EIQ summary tables from raw shipping line items.

🎯 Primary System Roles

  • Data Generation Pipeline: Sequentially builds Master, Daily, Total, and Average EIQ tables.
  • Data State Management: Prevents duplicate execution by checking for master table existence.
  • Data Purging: Offers batch deletion of generated `T7*`, `T8*`, `T9*`, and `TA*` tables.