Excel Export Mastery — Math Tools Sheet, Fit Results & Backend Math Builders
Fully-featured Math Tools worksheet, Fit Results sheet, complete Polar/Bar/Line XLSX overhaul, and new server-side math computation modules for statistics, smoothing, peaks, calculus, and bar analysis.
- Math Tools Sheet in Excel Export — Dedicated “Math Tools” worksheet in every exported workbook. Includes descriptive statistics, peak detection results, calculus output, and bar analysis per curve.
- Fit Results Sheet in Excel Export — Separate “Fit Results” worksheet listing all curve-fitting results: model name, R², Adjusted-R², RMSE, and equation coefficients with formatted cells.
- Backend Statistics Module — Server-side computation of descriptive stats (mean, median, std dev, quartiles, skewness) for every data series in the export.
- Backend Smoothing Module — Moving average smoothing computed server-side and written as a dedicated column in the Math sheet.
- Backend Peaks Module — Peak and trough detection results included in the Math sheet alongside prominence values per peak.
- Backend Calculus Module — dy/dx derivative values and trapezoidal area-under-curve computed server-side for the Math sheet.
- Backend Bar Tools Module — Pareto cumulative-sum and bar delta analysis written to the Math sheet for bar/histogram projects.
- Polar Chart Excel Overhaul — Polar/Radar XLSX export now includes spoke labels as column headers, a formatted radar chart preview, and per-spoke value summary.
- Bar / Histogram Excel Overhaul — Bar XLSX now includes grouped-series summary, delta analysis table, and Pareto chart on a dedicated chart sheet.
- Line / Scatter Excel Overhaul — Line XLSX includes smoothed curve series alongside raw data, with a full chart sheet mirroring the in-app ECharts view.
- XLSX Common Format Utilities — Shared cell format library ensures consistent number formatting (scientific, percentage, currency) across all export sheets.
- XLSX Metadata Sheet — Expanded: now includes calibration pin coordinates, axis types, project creation date, and VectorGraph version string.
- Pie Chart XLSX — Segment percentage column added; donut inner-radius metadata included in the metadata sheet.
- AxesSetupPanel — Live preview of axis configuration updated in real-time as values are typed. Validation errors shown inline per field.
- Bar Distributions Panel — Histogram bin count and class interval options separated into distinct controls for clarity.
- Fixed fit_results worksheet generating an extra blank row when no curve fitting had been performed.
- Fixed Polar XLSX styler crashing when a radar series had zero spokes defined.
- Fixed Bar XLSX exporter incorrectly transposing group labels for horizontal bar chart orientations.