Web Apps & Dashboards · Production
Fleet Insights
Monthly repair reports that show each branch which trucks cost too much.
Built for: A regional truck dealer and service company that runs fleet maintenance for a commercial customer with about 85 branches
The problem
Every branch of a large commercial fleet sends in repair and maintenance invoices each month. Branch managers had no simple way to tell whether their spend was normal for that equipment, which units drove the cost, or when a truck should be replaced instead of repaired. The old process ran on spreadsheets.
What I built
I built a four-stage Python pipeline that compares every unit with peers of the same type and age and writes one self-contained report per branch, per district and for management. Around it are a Report Builder desktop app for the program staff, a Claude review of every report before it goes out, and a guarded workflow that lets non-developers ask for report changes in plain English.
How it works
- Pull a month of repair and maintenance records through a secure MCP connection.
- Match each unit with similar units by year, make, model and type.
- Rank the units and branches that spend most above their peers, with keep or replace verdicts.
- Have Claude check every report against a written checklist.
- Publish one interactive HTML report per branch and district.
Built with
- Python
- pandas
- PySide6
- Claude Agent SDK
- MCP
- HTML/CSS/JavaScript
More of Jeremy's work
Web Apps & Dashboards
Security & Compliance
Documents & OCR
- OCR WatchReads handwritten parts sheets on the PC and flags only uncertain entries.
- AME-XDOCMoves hundreds of Word documents to a new template, and checks itself.
- Meeting Executive Summary EmailA 30-second meeting summary page, with the detail one click away.
- OCR Review StudioUpload a scan, check OCR line by line, tune it, export Markdown.
AI & Agents
- AME MCP ServerOne governed doorway between AI assistants and business systems.
- CAD Drawing IndexLets staff ask their AI assistant what is inside AutoCAD drawings.
- Secure AI Hatz TipsFact-checked how-to answers inside the AI chat customers already use.
- Hatz User WatchWarns admins before any person runs out of AI credits.
- AI Hours TrackerAI interviews staff and writes up each AI time-saving win for leadership.
- Meeting Summary BuilderTurns a Teams or Zoom transcript into a branded Word meeting summary.
- Hatz Usage WatchTray app that tracks every Hatz AI client's monthly credit use and warns early.
- Secure AI for ExcelChat with any Hatz AI model inside Excel and let it do the work.
- TokenXMeasures what each Hatz AI model really costs, then helps people choose.
- FollowUp AITracks sent emails still waiting on a reply and helps close them.
- localzeroInbox-zero triage for Outlook Classic, run locally with Claude.
- Secure AI Advanced ChatSaved-prompt workspaces for Claude through the Hatz AI gateway.
- Hatz Admin ToolkitAdmin tools for moving users and bulk-assigning roles in Hatz AI.
- Secure AI Process MapThe 90-day Secure AI onboarding program on one clickable page.
Desktop Apps
- MDViewA portable Markdown reader and editor for Windows, one file, no install.
- CommCentralTeams, Outlook, calendar, inbox KPIs and an AI assistant in one window.
- N-ToolsOne portable Windows toolkit to diagnose, repair and document a PC.
- TicketNotesTime tracker that drafts Q360 timebill notes with AI.
- Activity LogRecords your workday and turns any time range into a ticket write-up.
- PriorityNotifyVIP emails and Teams chats that break through meetings and mute.
- MeetingRemindMeeting reminders that check you actually joined the call.
- MyDashA self-building launcher for every tool in a scripts folder.
- AppWatcherKeeps important tray apps running and alerts when they keep failing.