Ready
Delivery dates: press Load Data
Tick the product types that come from Dekko. Composite doors (AP/DM/MOD) and install lines are never counted.
Load Data to see the product types on booked installs.
Only needed if the live delivery monitor can't be read. Used in this tab only — nothing is saved.
No report loaded
By installation date — booked installs with Dekko frames, by install week · click a week to open it · recommended = leaves one delivery day free before install (two for special colours) · booked = from the uploaded MBN report
Click Load Data for the booked installs, then upload the MBN report for the booked delivery dates.
Dekko deliveries — suggested (our plan, incl. manual dates) vs booked (MBN report) per delivery day · click a delivery to open it · Wednesday truck 85, extra truck 65
Delivery days — untick a Wednesday with no truck (e.g. Christmas), add an extra day (e.g. a Friday)
Add a delivery day Dates in the uploaded MBN report are always counted as delivery days.
Dekko trucks from the MBN report — what's actually booked · click a truck to see what's on it
Upload the MBN Orders Expected By Date & Supplier report to see the trucks.
Job orders — every job on MBN's delivery monitor, by install date · each cell: status · expected date · received of total
Press Load Data to read the delivery monitor from MBN.
Dekko schedule — Dekko's weekly "Dekko Window Status Report", by despatch date · Dekko's note: the despatch date is not necessarily the delivery date · click a date to see its orders
Press Check inbox to read the latest Dekko Window Status Report from orders@.
Delivery monitor — exactly what MBN gives, one column per field · status codes: 1 Not ordered · 2 Ordered · 3 Part in · 4 Received · counts = received / total · scroll sideways for more
Press Load Data to read the delivery monitor from MBN.