Test to Graph

What’s new? Import & Data Handling • Removed Excel QueryTable import; replaced with a fully manual TXT import engine for deterministic two-column data ingestion. • Eliminated all Excel regional dependency (decimal / thousand separators). • Implemented locale-independent numeric parsing supporting both , and . decimals. • Added post-import normalization to prevent magnitude scaling errors. Template Integrity • Enforced fixed two-leading-column data layout to prevent formula and chart misalignment. • Prevented cumulative column drift during batch processing.

Input System • Unified user input handling using a single Double standard. • Added selectable analysis modes: o Impact velocity–driven o Impact energy–driven • Automatic conversion between velocity and energy using kinetic energy relations. • Default input values auto-extracted from test file names. Signal Processing & Feature Extraction • Robust computation of: o Fmax, t(Fmax), Emax o F1, t(F1), E1 (force–time discontinuity detection) • Added fallback logic for extreme or noisy datasets. • All extracted values written consistently to experiment sheets and summary table.

Summary

Automation • Automatic generation and population of a Summary worksheet containing all key impact metrics. • All values extracted using locale-safe numeric readers. Codebase Cleanup • Removed legacy parsing routines, separator hacks, and duplicate helpers. • Consolidated logic into reusable, defensive helper functions. • Improved naming consistency and eliminated variable reuse conflicts. Stability & Reproducibility • Results are now fully reproducible across different Windows regional settings. • No silent truncation, rounding, or formatting-induced data corruption.