Tool 02 · controlled transformation

Three report scenarios

Each run uses the same contract: A template, B source data or report, and C declarative conversion rules.

LOCAL PROCESSINGNO SERVER UPLOAD

SCENARIO 01

Dataset to planner report

Turn a 1,800-row ERP-style export into a formatted 30-row material exception queue.

1,800 source rows → 30 exceptions

Report templateBlank XLSX with the target sheet, headers, and presentation format.

CHOOSE FILE.xlsxClick to select from this computerDownload matching template ↓

ERP-style datasetHeader-based CSV or XLSX input. Report-to-report scenarios use Report A here.

CHOOSE FILE.csv / .xlsxClick to select from this computerDownload matching source ↓

Conversion rulesJSON mapping for fields, calculations, filters, grouping, sorting, and controls.

CHOOSE FILE.jsonClick to select from this computerDownload matching rules ↓

TRANSFORMATION CONTROLLoad all three matching files to continue.Missing headers or sheets stop the run. Every source row must reconcile to matched plus suppressed rows.

EXPECTED OUTPUT1,800 source rows → 30 exceptions

A prefilled reference is provided so a reviewer can compare the browser result with the expected workbook.

Download the expected filled Report A

V1 SUPPORTS

CSV/XLSX input, header mapping, derived fields, filtering, sorting, static grouping, summary cells, basic style reuse, and an audit sheet.

V1 DOES NOT PROMISE

Arbitrary macros, encrypted workbooks, pivot caches, external connections, embedded applications, or preservation of every advanced Excel feature.