Schedule Converter

Upload Schedule files to transpose dates. Duplicates are automatically removed.

Upload a schedule file to see the transposed data here.

Training & Route Dashboard

Upload the Training/Status file to extract the first 5 scheduled routes (from Rostered Work Blocks only) for active associates.

Download Format for using Option: A

Note:The first 4 columns are obtained from the WST Training part. You must add the DSP Names for the trainees by yourself in the formatted sheet.

Use for the standard "DSP Name / Transporter ID" format.

Select multiple WST Excel/CSV files or ZIP archives.

Upload an entire folder containing multiple WST ZIPs or files.

⚠️ Please upload Schedule files in the section above first.

About Newbies Scheduling Tool

Manage new associate schedules with ease. This tool converts rostered work blocks and training schedules into a clean, searchable format, helping you cross-match training records with actual scheduled routes.

How to Use
  1. Upload your schedule Excel files.
  2. Upload your Training/Status file or WST records.
  3. View the matched 'Active' associates and their upcoming routes.
  4. Check the 'Discrepancy Report' for missing entries.
  5. Download or copy the results for your management team.
Key Features
  • Intelligent name and ID matching
  • Rostered work block extraction
  • Training status integration
  • Automated discrepancy reporting
  • Duplicate removal
  • Copy-to-clipboard with Excel formatting

What is the Newbies Scheduling & Training Dashboard?

The Newbies Scheduling Tool by Ztoolx is a sophisticated workforce management utility designed to bridge the gap between training and operations. Specifically created for Delivery Service Partners (DSPs), it automates the process of identifying when newly trained associates are first integrated into the active schedule. By cross-matching "Training Records" with "Rostered Work Blocks," it provides a real-time visualization of the onboarding funnel, ensuring that no associate is lost in the transition from the classroom to the road.

How to Audit Newbie Schedules

Managing your onboarding pipeline is now a simple, automated process:

  1. Import Schedules: Upload your standard "Rostered Work Blocks" Excel files. Our tool will automatically transpose the dates and associates into a searchable database.
  2. Integrate Training Data: Upload your training files or WST records. The tool uses intelligent fuzzy matching to link associates across different reports, even if their names are spelled slightly differently.
  3. Analyze the Dashboard: View the first five scheduled routes for every trainee. See exactly which associates are "Active" and who is still "Missing in Schedule."
  4. Review Discrepancies: Use the "Cross-Match Discrepancy Report" to identify associates who are in the schedule but missing from your WST training records, helping you catch billing or compliance gaps.

Key Benefits

  • Automated Name Matching: Our "Fuzzy Match" engine handles variations in name formats (e.g., "Last, First" vs "First Last") and minor typos, ensuring a high match rate without manual intervention.
  • Onboarding Visibility: Instantly see the first five routes for each newbie. This helps managers monitor early performance and ensure successful integration into the fleet.
  • Billing Integrity: The discrepancy report ensures that every associate on the road has a corresponding training record, protecting you against compliance audits and lost reimbursements.
  • Data Sovereignty: As with all Ztoolx tools, your personnel and scheduling data is processed entirely in your browser. We never store or transmit your sensitive workforce information.

Frequently Asked Questions (FAQ)

What counts as an 'Active' associate?

An associate is marked as "Active" if their name or Transporter ID appears in the "Rostered Work Blocks" sheet of your uploaded schedule files.

How many routes does the dashboard show?

The dashboard is optimized to show the first five scheduled routes chronologically, allowing you to monitor the critical first week of a new associate's tenure.

Can I copy the dashboard to Excel?

Yes. Use the "Copy to Clipboard" button to copy the entire dashboard with its formatting intact, ready to be pasted directly into Microsoft Excel or Google Sheets.