Upload Daily Tracker Workbook

The one true substitute for a MongoDB connection: every field below builds on top of what's uploaded here.

Tracker Rows

Fulfillment Brain

Operator Coverage Scenario

Matches the original before/after scenario workflow.

By Day

Trips by Service Day

Route Trip Volume

Work Blocks

Upload DDOT DIV7 Compliance Control Workbook

Reads the Vehicle Compliance tab. Independent of the Daily Tracker upload.
Adjust compliance rules

End-of-Day Compliance Update

Copy the summary straight into Teams.

Provider PMI Emails

One draft per provider with a PMI or mileage exception. Paste the body into Outlook and address it yourself.

End-of-Day Division Brief

Draft fields remain only in this browser session.
This report is prepared today using complete operational data through yesterday. Its factual overview is generated automatically from the data.
On combines routes such as 1029-A and 1029-B. Turn it off for a division that counts those routes separately.

Provider Check-In Report

Provider Performance Review

Select any Provider LLC to generate an evidence-based executive comparison.

Liquidated Damages Interview

One question at a time, covering every category in Exhibit A -- ends in a totaled result with a downloadable explanation.

Performance Standards & LD Schedule

Exhibit A -- Additional Terms of Service, from the CONTRACT FOR TRANSPORTATION SERVICES on file
Violation Minimum Requirement Liquidated Damage
Uncovered Route Provider is contracted to operate a route that has documented service days, and is obligated to operate that route on all service days. $150 per route/day uncovered.
Open After 7 PM The route must be confirmed/staffed by 7:00 PM local time the day prior to the scheduled service day. $100 additional per occurrence when the route is left open after 7pm local time the day prior to the route.
Late to First Drivers must arrive to their first trip within the ready-time window. This only takes pre-scheduled trips into consideration. $50 per occurrence when driver is late to first trip.
Accident Reporting All accidents must be reported within 24 hours; major accidents must be reported within 1 hour. $500 per occurrence when not reported.
Vehicle Cleanliness Vehicle interiors must be cleaned daily and exteriors cleaned once weekly or as needed. $25 per occurrence when a vehicle is found to be in non-compliance, exterior/interior.
Driver Appearance Drivers must meet the minimum requirements described in the Statement of Work while in service. $25 per occurrence when drivers are found non-compliant.
Preventable Accident Threshold Maximum 1.0 preventable accidents per 60,000 miles driven. Contract Termination.
No Leave Behind (Paratransit Door-to-Door only) A driver may not leave a location prior to confirming the passenger has safely entered the facility, home, or business. The total amount of the damages leveraged against Big Star, by the Authority, for that specific occurrence. Contract Termination.
Other Liquidated Damages (§6) Provider shall be liable to BIG STAR for any liquidated damages or similar charges, fines or penalties (“Liquidated Damages”) imposed by BIG STAR as a result of any action or inaction on the part of Provider in the performance of Services, including, without limitation, any such liquidated damages or similar charges, fines or penalties imposed in connection with any breach by Provider of any Customer Regulations. The amount of any such Liquidated Damages shall be payable by Provider upon demand by BIG STAR. Without limiting the foregoing, BIG STAR may offset the amount of such Liquidated Damages against any amount due to Provider under this Agreement without additional consent to do so. Amount and reason as assessed by BIG STAR under Agreement §6, entered by the reviewer.

KPI Trend vs Targets

Route Quadrant

How to read this: Each dot is one route. The further right it sits, the better it's covering its scheduled hours (SHF). The further up , the better its on-time performance (OTP). Bigger dots mean more trips that week. Green = hitting every target, gold = hitting some, red = missing both OTP and SHF — the goal is the top-right corner.

KPI Target Coverage

How to read this: Each bar shows how many of the six weekly KPI targets a route met. Longer bars mean more targets met. Use the KPI-specific views to see exactly where attention is needed.

Provider Diagnostics

Compare one provider with every other provider in the selected reporting week.

Route Target Attainment

Share of measured routes meeting each configured KPI target.

Diagnostic Findings

Evidence from the selected provider, peers, routes, and operators.

Six-Week Context

Uses the same elapsed weekday window when the selected week is partial.

Selected-Week Daily Pattern

Selected provider versus all other providers on each available day.

Route Drivers

Raw event totals provide context; KPI comparisons above use route-day averages.

Operator Drivers

Measured operator results within the selected provider and reporting window.

Monthly Operating Picture

Monthly Summary

Upload Week-over-Week KPI Tracker

Independent from the Daily Tracker upload above -- this workbook drives only the WOW Strength Dashboard.
Guided, private, and session-only

Contract Notices

Prepare an approved notice, verify the evidence, and download editable Word and distribution-ready PDF files.

Operator Roster

Thresholds and Weights