DCExpress
Welcome back
Sign in to continue
or
No account? Create one
?
Not logged in
click to change
📈 Performance Dashboard
📋
TIMESHEET
Arbeitnehmerbericht
.CSV — employee hours report
No file selected
📊
CORTEX
Itineraries DNM7
.XLSX — date Cortex
No file selected
⬆
Load Arbeitnehmerbericht.csv (Timesheet)
and Itineraries_DNM7.xlsx (Cortex),
then press ▶ Compare.
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.
Transporter ID Delivered DCR (%) DNR DPMO LOR DPMO POD (%) CC (%) CE CDF DPMO

💡 Paste directly from Scorecard (Ctrl+V anywhere in the table above)

Load between 3 and 5 Excel files (e.g. KW16.xlsx, KW17.xlsx…). The filename determines the week.
📋 Timesheet: one CSV file for the whole month  |  📊 Cortex: one XLSX per day (e.g. 2_mai.xlsx, 3_mai.xlsx…) — load up to 31 files
📋
TIMESHEET
Monthly CSV
One file — full month
No file selected
📊
CORTEX
Daily XLSX files
Select multiple files at once
No files selected
📆
Load the monthly Timesheet CSV
and the daily Cortex XLSX files,
then press ▶ Compare.
📋 Timesheet: one CSV for the month  |  📊 Cortex: one XLSX per day  |  📅 Shift Plan: one XLSX per day (optional)
📋
TIMESHEET
Monthly CSV
Full month — one file
No file selected
📊
CORTEX
Daily XLSX files
Select multiple files at once
No files selected
📅 Shift Plan — one file per day
No plan files loaded
📆
Load files and press ▶ Compare.
📄 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 Dashboard

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 — you can select multiple files at once

✅ Tasks

📋 To do
🔧 In progress
✅ Done

🗓️ Shared Calendar

🚐 Vehicle Inspections

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

DatePlateModelMileageStatusSubmitted by (account)
📥 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
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