retro-think
by
Jason Price
Jason PriceWhat do you think
Sidebar
Comments (0)
Sign in to leave a comment
Auto-Detect & Map Columns
Upload your delivery report and retro-think will automatically detect column headers and map them to the required fields. Review the mapping and adjust manually where needed before confirming import.
Supports files up to 30 MB
.xlsx
.xls
.csv
Drop your delivery report here
Drag and drop your file, or browse to select
.xlsx· .xls· .csv
Maximum file size: 30 MB
Auto-Detection Results
8 columns analysed from uploaded report
4 High2 Medium2 Low
Delivery ReferenceDelivery ID
textSite IdentifierSite Code
textDelivery DateScheduled Date
datePlot NumberPlot No.
numberCSMR StatusCSMR Status
textAssigned UserAssigned To
textOverdueOverdue Flag
booleanNotesNotes / Comments
unknownColumn Mapping
Map source columns to Dispatch system fields
10 Mapped
2 Unmatched
0 Ignored
Source File Columns12 / 12
DeliveryDatedate
PlotRefstring
SiteCodestring
SupplierNamestring
OrderQtynumber
DeliveredQtynumber
CSMR_Statusstring
ForecastWeekstring
AssignedUserstring
RiskFlagboolean
Notestext
LastModifieddate
Dispatch System Fields12 fields
Legend:
Mapped — column has a matching Dispatch field
Unmatched — requires manual selection
Ignored — excluded from import
Data Preview
Showing first 7 rows — column headers reflect current mapping
248 rows loaded
| # | Delivery Ref | Site Code | Plot No. | Delivery Date | Item Description | Assigned To | Status | Notes |
|---|---|---|---|---|---|---|---|---|
| 1 | DLV-2024-0081 | NW-ALPHA | PLT-14A | 2024-06-03 | Structural Steel Frame | J. Marsh | On Track | AM delivery confirmed |
| 2 | DLV-2024-0082 | NW-ALPHA | PLT-15B | 2024-06-03 | Concrete Foundations Mix | R. Patel | On Track | — |
| 3 | DLV-2024-0083 | SE-BETA | PLT-22 | 2024-06-04 | Roof Timber Kit | S. Okafor | At Risk | Supplier delay flagged |
| 4 | DLV-2024-0084 | SW-GAMMA | PLT-07 | 2024-06-01 | Window & Door Frames | L. Chen | Overdue | Escalated to PM |
| 5 | DLV-2024-0085 | SE-BETA | PLT-30C | 2024-06-05 | Insulation Batts | M. Torres | On Track | — |
| 6 | DLV-2024-0086 | NW-ALPHA | PLT-09 | 2024-06-05 | Plasterboard Sheets | J. Marsh | At Risk | Check warehouse stock |
| 7 | DLV-2024-0087 | SW-GAMMA | PLT-18D | 2024-06-06 | Electrical Cable Tray | D. Nwosu | On Track | Pre-installation needed |
Mapping confirmed — loading Viewer
Ref # | Assigned To | Site | Plot | Delivery Type | Date | Quantity | Status |
|---|---|---|---|---|---|---|---|
| DEL-0048 | M. Torres | Manchester Hub | Plot 1D | Structural Steel | 2026-05-13 | 18 units | Delayed |
| DEL-0043 | M. Torres | Manchester Hub | Plot 3C | Concrete Mix | 2026-05-14 | 12 m³ | Delayed |
| DEL-0041 | J. Hartley | Heathrow T5 | Plot 12A | Structural Steel | 2026-05-15 | 24 units | On Track |
| DEL-0042 | S. Patel | Canary Wharf | Plot 7B | Glazing Panels | 2026-05-16 | 80 m² | At Risk |
| DEL-0044 | J. Hartley | Heathrow T5 | Plot 14D | MEP Ducting | 2026-05-17 | 45 m | On Track |
| DEL-0045 | K. Ndubisi | Birmingham East | Plot 2A | Roofing Membrane | 2026-05-18 | 320 m² | Delivered |
| DEL-0046 | S. Patel | Canary Wharf | Plot 9F | Cladding Systems | 2026-05-19 | 60 panels | At Risk |
| DEL-0047 | A. Brennan | Leeds Central | Plot 5B | Electrical Cables | 2026-05-20 | 800 m | On Track |
No comments yet. Be the first!