Test to Graph
Description
This Excel Spreadsheet contains macros. It was developed to automate all the kinematic calculations for the LVI impact test. İmportant Notes: 1. These codes were generated for the PCB M202B Quartz Force Ring sensor. 2. The LVI rig had a 15.5 kg mass impactor. If anyone uses a different value from the existing one, he/she must change the mass of the impactor. The password for the "Template" sheet is "a". 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.