Test to Graph

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.