PupCodeStart a project

PupCode Lab / Excel automation

From messy export to clean report.

Inspect the source, run the batch, and compare the cleaned output with the records that need attention. Take the Excel workbook and an offline dashboard with you.

FIG. 03 / REPORT SORTERSCENE STUDY

EXCEL AUTOMATIONPC-ORDERS-01

Run the order batch.

Start with 1,248 synthetic orders from four branches. The export mixes date and currency formats, casing, aliases, and incomplete records. The 3D sorter shows the first six rows.

  1. Read source rows
  2. Normalise and validate
  3. Publish results
Preview raw data ➘

Raw data is ready to preview below.

DATA INSPECTOR / PC-ORDERS-01

Inspect the batch.

1,248 matching rows
Raw data
Source rowOrder IDDateBranchChannelStatusAmount (GHS)
2 ord-10001 05/08/2026TakoradiWebsiteCompleted5952.94
3Blank2026-08-03 ACCRA Emailin progress2081.90
4ORD-100032026-08-05Takoradi shop Completed3265.08
5ORD-1000403/08/2026TakoradiEmailCancelledGHS 896.43
6 ord-10005 2026-08-03AccraEmaildone2348.30
7ORD-1000631/02/2026TakoradiWebsiteCompleted5938.06
8ORD-1000703/08/2026TamaleRetailPending2679.51
9ORD-100082026-08-03Takoradi shop in progress3263.58
10 ord-10009 2026-08-03 TAKORADI RetailProcessingTBC
11ORD-1001003/08/2026TamaleWebsiteCancelledGHS 1,565.16
12ORD-100112026-08-05TamaleEmailvoid45.15
13ORD-100122026-08-03TamaleRetailProcessing3916.00
14 ord-10013 03/08/2026Tamale mail Cancelled1501.67
15ORD-100142026-08-04AccraWebsitecheck later2947.02
16ORD-100152026-08-05KumasiWebsiteCompleted2184.09
17ORD-1001603/08/2026 TAKORADI EmailProcessingGHS 3,338.70
18 ord-10017 2026-08-05KumasiWebsitedone3662.78
19ORD-100182026-08-05Kumasi WEB Completed1889.60
20ORD-1001904/08/2026AccraRetailProcessing4562.42
21ORD-100202026-08-05BlankRetaildone2732.63
Page 1 of 63