BOXSTI — EXCEL & CSV AUTOMATION SAMPLE
Three CSV files. One checked sales report.

All companies, customers, transactions and figures are fictional.
This is a demonstration, not a client case study or a measured savings claim.

START HERE
Open Boxsti_Excel_CSV_Demo.xlsx for the sales report, accepted rows and review queue.
Open website-demo.html in a browser for the presentation version.

WHAT THE SAMPLE DOES
Reads three CSV exports with different header names and date formats.
Maps columns, trims surrounding spaces and normalizes SKU, region and currency.
Converts numeric inputs and dates under the explicitly documented file mappings.
Checks required fields, valid dates, positive whole quantities, nonnegative USD
prices to two decimals, known SKU/product pairs and supported regions.
Excludes identical normalized copies using order ID + SKU as the duplicate key.
Holds invalid rows for review instead of guessing missing information.
Keeps each accepted row's source filename and CSV row number (header is row 1).

EXPECTED RESULTS
3 files x 20 rows = 60 imported rows.
54 accepted sales lines; 3 duplicate copies excluded; 3 rows needing correction.
1,074 accepted units; accepted sales USD 18,488.00.
North USD 6,199.50; South USD 6,289.75; Online USD 5,998.75.
Sales = quantity x unit price. Taxes, discounts and shipping are not included.

FILES
input_csv/                   Three original fictional exports, with intentional errors.
generated/clean_sales.csv     Normalized accepted rows and calculated sales.
generated/exceptions.csv      Exclusions, explanations and original source-row JSON.
generated/region_summary.csv  Accepted units and sales by region.
Boxsti_Excel_CSV_Demo.xlsx     Formatted Excel sample with editable calculation formulas.
website-demo.html            Static page suitable for adapting to the Boxsti website.
report-preview.png           Image of the Excel report for a post or website preview.
make_demo.py                 Reproducible CSV processing workflow; Python standard library.

RERUN THE CSV WORKFLOW
Requires Python 3.9 or later; no third-party packages or API key required.
In a terminal opened in the extracted folder, run:
  python make_demo.py
This overwrites generated CSV/JSON files and website-demo.html using input_csv/.
On systems with the Python launcher, use: py make_demo.py
To recreate the original fictional inputs as well: python make_demo.py --seed

The Excel workbook is a saved import, not a live connection to the CSV files.
Editing its existing accepted quantity/price cells recalculates the report.
Rerunning Python refreshes the CSV outputs and HTML page, NOT the workbook.
Adding rows in Excel requires extending formula ranges. Changing validity in
Excel does not rerun the Python validation or refresh the exception list.

DATE MAPPINGS
branch_north.csv: YYYY-MM-DD
branch_south.csv: DD/MM/YYYY
online_orders.csv: DD-MM-YYYY
The raw online export includes an intentionally invalid date ending in X.

LIMITS
Designed for the three included, documented export layouts and USD only.
First valid occurrence is retained; conflicting later duplicates are held for
review. Resolve conflicts against source records before using financial totals.
No universal format detection, tax audit, accounting-system connection,
currency conversion, unattended scheduling or live client data is included.

POSTING ON YOUR WEBSITE
Upload the Excel workbook as a sample download and use report-preview.png as
its preview. Keep the fictional-data label visible in any cropped preview.
To publish website-demo.html, retain its relative generated/ download files and
the Excel workbook alongside it, or update those download links for your site.
The HTML is a saved output with no file-upload form, external scripts or trackers.
Permission: Boxsti may adapt and publish these original fictional demo materials.

SHORT DESCRIPTION
See how three differently formatted CSV exports become one checked sales report.
This fictional Boxsti demo standardizes columns, removes exact duplicate copies,
flags missing or invalid inputs, and preserves a source trail for every accepted
row. Download the sample Excel report and source CSV files to explore the results.

Contact: shubham@boxstiai.com
Website: https://boxstiai.com/
