DCExpress
Welcome back
Sign in to continue
or
No account? Create one
?
Not logged in
click to change
Performance
Tools
Operations
Tools

ID Replacer

Replace Amazon transporter IDs with driver names in any CDF, CC, Scorecard, POD or PHR export.

1. File type
Coloring: each driver gets a unique color.
2. Load file
No file selected
3. Driver ID column
4. Code → Name mapping
CodeName
— load a file to preview —
🔄
Load a CSV or Excel file,
select the ID column
and press ▶ Process.
Tools

Score Calculator

Paste the weekly scorecard rows, then calculate each driver's score.

Transporter ID Delivered DCR (%) DNR DPMO LOR DPMO POD (%) CC (%) CE CDF DPMO

Tip: paste directly from the Scorecard (Ctrl+V anywhere in the table above)

Tools

Monthly Average

Average each driver's weekly scores across a month.

Load between 3 and 5 Excel files (e.g. KW16.xlsx, KW17.xlsx…). The filename determines the week.
Tools

Contract Generator

Fill in the fields below. All three documents will be generated automatically with the data replaced:
Arbeitsvertrag · Kleidung Ausgabe · Sicherheitsschulung
Preview — replacements
Fill in the fields above to preview the replacements.
Performance

Driver Scorecard

Upload the weekly scorecards (e.g. KW16.xlsx … KW27.xlsx) to see the full-season driver ranking — who's performing best, who needs support, and what each driver should focus on.

Choose scorecard files
.XLSX — select several weeks at once
Tools

QR Generator

Create a QR code from any text, or QR labels with the vehicle VIN, ready to print from Word.

Content
0 characters
Quick examples
Colors
Preview
Generated QR code
Operations

Tasks

To do
In progress
Done
Operations

Shared Calendar

Operations

Vehicle Inspections

Weekly vehicle inspection checklist. Dispatchers complete this per vehicle from the iPad — it's saved straight to the dashboard.

DatePlateModelMileageStatusSubmitted by (account)
Tools

Kenjo Data Import

Converts Amazon Itineraries exports into the Kenjo import format (attendance.xlsx).
1. Upload Itineraries files (.xlsx)
Drag Itineraries files here (a single day or a whole month)
or click to select — the shift date is read from the file name
How the conversion works
The driver's name is automatically replaced with the email from the internal roster; unmatched rows are flagged and you fill them in manually.
Break = Total break time used from Itineraries, but never below the legal minimum: under 6h → 0 · 6h–9h → 30 min · over 9h → 45 min. The break is placed at the midpoint of the shift, rounded to 5 minutes.
If the same driver appears on multiple rows in one file (e.g. two routes in one day, marked with a ⚭ badge), they're merged into a single row: first sign-in → last sign-out, with the real gap between routes used as the break.
A 🧑‍🤝‍🧑 helper badge marks routes that had a helper (ride-along) — shown for information only, no row is generated automatically for them.
You can manually edit the break before downloading; for rows without an email you can fill in the address and click + roster to save it directly to the shared roster (synced to the database, visible for everyone).
Internal roster (name → email) — 0 entries ▸ Manage