Import Outlook emails, parse WOs, match stores, and review before dispatch. Data now persists in SQLite. V5 SQLite database persistence.
Madden Mechanical Operations
Operations Dashboard
Live dispatch priorities, field status, compliance, and invoice readiness in one view.
Outlook SyncConnected
Verizon GPSChecking
QuickBooksChecking
CorrigoConnected
DatabaseHealthy
Today at a Glance
Live operational data
Waiting / Follow-Up0
Corrigo Needs Acceptance0
Corrigo Accepted0
On Lunch0
Internal Time0
Cancelled0
Live Dispatch Map
Loading Google Dashboard Map…
Verizon Vans
Waiting for live data
Plumber Status
Action Items
Recent Activity
Today's Performance
Calculated from today's live records
Performance Details
Madden Intelligence Control Room
AI Diagnostics
Live visibility into historical intelligence, recommendation runtime, and completed-job outcome capture.
Loading AI diagnostics…
Live Outcome Capture
Checking
Live Outcomes0
Captured Today0
Audit Revisions0
Invalid0
Last captureNot yet captured
DatabaseWaiting
Recommendation Runtime
Checking
Worker—
Cache Entries0
Historical Jobs—
Indexed Jobs—
Runtime validationWaiting
Python—
Historical Intelligence
Checking
Enriched Jobs—
Knowledge Objects—
Fingerprints—
Historical Outcomes—
Artifacts display “Not installed” when an offline Knowledge V2 package has not yet been promoted into this production repository.
Learning Health
Checking
Live capture—
AI event bus—
Historical artifacts—
Recommendation worker—
Last diagnostics refresh—
Financial Snapshot Verification
B2
Enter a work-order number, internal work-order ID, or outcome ID to verify the latest captured financial revision.
No work order selected.
Recent AI Events
Checking
Total Events0
Events Today0
Successful0
Failures0
No AI events recorded yet.
Outlook → Work Order Intake
This is the original intake board. Outlook now syncs new Inbox messages automatically. Review parsed information, confirm store/address/problem data, then send WOs to dispatch.
Checking live Outlook sync…
Create Manual Work Order
Use this for new clients, one-off jobs, phone requests, or jobs that do not arrive through Outlook/Corrigo/ServiceChannel. Saving creates a normal intake WO that can be dispatched, scheduled, sent to Madden Mobile, completed, invoiced, and saved to Store History.
Intake Review
Status
Match
WO#
Location ID
Client / Location
Route
Priority
Category
Problem / Issue
Past History
No drafts loaded yet.
Ready.
Ignored / Admin Emails
These were not added to Draft Work Orders. Admin emails are separated from dispatch work.
Type
Reason
Subject
From
Received
No ignored/admin emails loaded.
Dispatch Board
Assign reviewed work orders to plumbers, schedule time windows, and move jobs through field statuses.
Total WOs0
Ready0
Assigned0
En Route / On Site0
Completed0
Click to view
Dispatch Work Orders
0 selected
Dispatch
WO#
Client / Location
Problem / Issue
Route
Priority
Assigned Plumber
Schedule
Actions
No work orders loaded yet.
Completed Work Orders
Completed and invoice-ready work orders are kept here instead of the active dispatch list.
Dispatch
WO#
Client / Location
Problem / Issue
Route
Priority
Assigned Plumber
Completed / Invoice
Actions
No completed work orders yet.
Ready.
FiltersNo active filters
Total Work Orders—Live selected-week workloadScheduled——
Live planner · drag route rows in the bottom workspace to reorder selected technician stops.
Schedule Calendar — V10.6.9
Day/week dispatch calendar by plumber. Schedule, reschedule, and open jobs from one place.
Plumbers
Selected Plumber Day Route
Pick a plumber and week to see that plumber’s scheduled day route/order.
Unscheduled / Ready to Dispatch
These WOs are not scheduled yet. Drag a WO onto a plumber schedule, or drag a scheduled WO back here to unassign it.
Time Cards — V10.6.9
Review plumber clock events, job time, travel time, lunch breaks, and missing punch warnings.
Today Events0
Clocked In Now0
Lunch Active0
Job Time Events0
Time Off Requests
Review pending plumber PTO/time off requests. Denials require an office reason that shows in Madden Mobile.
No time off requests loaded.
Timecard Reset Tools
Use this during testing to clear mistaken timecard events. This does not delete the work order.
Weekly Payroll Sheet
Office payroll view modeled after the Madden weekly timesheet. Groups technician time by week, WO/category, and Regular/OT/DT buckets.
Daily Labor Sheet
WO-centric labor sheet built from technician time events. Supports multiple plumbers on one WO and internal time like Shop/Oil Change.
WO Labor Aggregation
Aggregates labor/travel from all technicians who touched the same WO.
Plumber Time Summary
Recent Time Card Events
No events loaded.
Service Management
Stores
Search the company-wide location directory and review profile coverage before opening detailed store history.
Locations Loaded0Location Profiles0Mapped Coordinates0Historical WO Data0
Store Directory
Open Stores to load the directory.
Service Management
Work Order Follow-Up Center
Manage paused and approval-dependent work without losing track of the original work order. Waiting age and matched email updates stay attached to the same WO record.
Follow-Up Work Orders
0 work orders
Rejected Work Orders
Rejected work is preserved here for audit/history and excluded from active Intake, Dispatch, Schedule Calendar, Dispatch Map, and Madden Mobile workflows.
Rejected Work Orders0
Rejected Work Orders
Handled Outside Madden
Legitimate work orders completed or managed through the existing process during the Madden field pilot. These are preserved for audit/history and excluded from active Madden operations and Madden performance statistics.
Handled Outside Madden0
Handled Outside Madden
Cancelled Work Orders
Cancelled or voided work orders are preserved here separately from customer/Corrigo rejections.
Cancelled Work Orders0
Cancelled Work Orders
Backflow PM Program
Backflow testing schedule for Albertsons/Safeway, Haggen, and Metropolitan Market. Field techs can see due stores, open purveyor portals, update submission status in real time, and link PM rows to dispatchable work orders.
Total PM Rows0
Not Started0
Submitted0
Complete0
Portal / Email Links0
Backflow Schedule
Month
Store
WO
Dispatch Link
City
Employee
Status
Invoiced
Process
Portal / Email
Notes
Field Actions
Loading Backflow PMs...
Field Tech Workflow
Backflow Program — V10.6.267
Assembly-driven Backflow PM management. Monthly PMs come from the Outlook Backflow PM schedule, then flow into store-level assemblies, assignment, mobile testing, and invoice packets.
Due PM Stores0
Unassigned0
Linked PM WOs0
Assembly Assets0
Needs Review0
Testing Complete0
Backflow Program Controls
Backflow Test Data Reset
Use this after testing. It keeps permanent stores, assemblies, addresses, months, portals, and asset photos, but clears PM workflow/testing state, mobile state, PM invoice packets, PM timecard events, and completion/invoice test records.
Due Testing / Assignment
This is the replacement direction for the old Backflow PM list: Outlook imports create monthly PM rows here, office assigns a plumber, and Madden Mobile opens the assembly testing workflow.
Store-Level Backflow Assets
Each store owns permanent assembly asset records. The annual PM tests update these same assemblies year after year.
Assembly Asset Library
Haggen blanks are seeded as starter assembly shells. The office can refine locations, make/model/serial/size as records are verified.
Management Intelligence
Business Intelligence
Read-only financial visibility from versioned Madden Live Outcome snapshots. This foundation reports only records captured after Analytics B1.
Waiting for captured data
Loading captured financial snapshots…
Captured Invoice Value$0No captured invoices
Financially Captured WOs0Latest billing revision per WO
Average Invoice$0Current reporting period
Labor Revenue$00.0% of captured invoice value
Travel Revenue$00.0% of captured invoice value
Material Revenue$00.0% of captured invoice value
Average Labor0.0 hrPer captured work order
Current reporting period
Customer Detail
Customer
Captured financial performance from Madden Live Outcome snapshots.
0 stores0 captured WOs
Financial Summary
Captured Customer Performance
Current reporting period
Captured Invoice Value$0Total captured invoice value
Captured Work Orders0Latest billing revision per WO
Average Invoice$0Across captured work orders
Average Labor0.0 hrPer captured work order
Labor Revenue$00.0% of invoice value
Travel Revenue$00.0% of invoice value
Material Revenue$00.0% of invoice value
Customer workspace readyFinancial summary, store list, work-order explorer, and timeline sections will use this customer context.
Primary Workspace
Customer & Store Performance Explorer
Operational financial performance from captured snapshots
Profitability boundary: True profit and margin are intentionally withheld until approved labor and travel cost rules are captured. “Invoice / Labor Hr” is an operating-efficiency indicator, not profit.
Customer
Invoice Value
WOs
Avg Invoice
Labor Hrs
Invoice / Labor Hr
Travel Revenue
Material Revenue
Other / Charges
Team Performance
Technician Leaderboard
Revenue attribution follows primary technician
Technician
Invoice Value
WOs
Avg Invoice
Avg Labor
Supporting Trend
Revenue Trend
Captured invoice value over time
Revenue Mix
Revenue Breakdown
Labor, travel, materials, and other captured charges
Customer Leaderboard
Sorted by captured invoice value
Customer
Invoice Value
WOs
Avg Invoice
Avg Labor
Store Leaderboard
Latest financial snapshot per work order
Store
Invoice Value
WOs
Avg Invoice
Avg Labor
Audit Trail
Captured Work Orders
Financial snapshots behind these totals
Work Order
Completed
Customer / Store
Technician
Invoice
Core Revenue
Labor
Metric DefinitionsHow each Business Intelligence number is calculatedView definitions
On-Call Schedule
Each row below is one Friday-to-Thursday on-call week. A plumber will appear multiple times during the year because the rotation repeats.
ON CALL THIS WEEK——
NEXT ON CALL——
Weekly Coverage Schedule
One row = one coverage week. Change the assigned plumber and click Save to swap or reassign that week.
Why names repeat: this is a week-by-week schedule, not a one-time list of plumbers. The same plumber appears again every time their turn comes back around during the year.
Coverage Week
Assigned On-Call Plumber
Generate Future Rotation
Build a full year automatically, review every week and each plumber's total, then save it only when you're satisfied.
Generation rules: beginning in 2027, Zander is part of the regular rotation.
Peter stays intentionally reduced-frequency at approximately 3 weeks per year.
The remaining coverage weeks are shared as evenly as possible among the regular rotation members.
Friday Start
Thursday End
On-Call Plumber
Rotation Members
Each plumber is listed once here. This section explains how frequently they should normally appear in the weekly schedule above.
Regular rotationNormal share of on-call weeksReduced frequencyIntentionally fewer on-call weeks
Rates Administration
Manage current, future, and historical pricing periods, including corrections to future rate periods.
Effective-dated rate managementRates Admin 1.3 adds controlled editing and deletion of future periods while keeping current and historical periods read-only.
Waiting
Pricing Profiles0
Default Regular—
Default OT—
Default DT—
Current Billing Profiles
Current values are resolved from Madden's pricing history. Create one new effective-dated rate period at a time.
Source: pricingProfiles.json → pricingEngine.js
Loading current pricing profiles…
Tax Rates Administration
Review and update the Washington tax jurisdictions currently used by Madden invoice calculations.
Controlled tax-rate editingTax Rates Admin 1.2 can compare Madden against the official Washington DOR rate table, review differences, and import selected changes. Manual bulk editing remains available as an override.
Waiting
Jurisdictions0
Lowest Rate—
Highest Rate—
Data SourceLivetaxRates.json
OFFICIAL SOURCE SYNC
Washington Department of Revenue
Compare Madden's current jurisdiction rates against the official Washington DOR local sales & use tax rate table before importing anything.
Jurisdiction
Madden
DOR
Change
DOR rates are compared using the official combined sales-tax rate. Import is never automatic: Madden requires office review and confirmation.
Current Jurisdiction Rates
Search the exact jurisdiction names Madden currently uses during invoice tax matching.
Jurisdiction
Tax Rate
Loading current tax rates…
PRODUCTION DISPATCH MAP
Dispatch Map
Live Madden work orders, Verizon GPS, traffic-aware routing, filtering, and dispatch assignment on Google Maps. The map expands to use the available browser workspace.
Google Maps Active
Google Maps Configuration
Production uses Madden runtime configuration. The browser-restricted key is supplied by the server at page render time and is not stored in Git or Madden data.
Checking runtime configuration…
Production: set GOOGLE_MAPS_BROWSER_API_KEY in the hosting environment. Keep Google Cloud application restrictions limited to Madden's HTTPS domain and API restrictions limited to the Maps JavaScript API and Routes API used by this implementation.
Mapped Open WOs—
Emergency WOs—
Live Vans—
Prototype StatusNot Loaded
Live Madden Data on Google Maps
Live WO pins use Madden's authoritative dispatch data and central location bridge. Google traffic-aware routing, live Verizon vans, filtering, recommendation, assignment, and reassignment are active.
Showing all active WOs
API usage guard · Traffic routes are cached briefly so repeated popup/route clicks do not immediately create duplicate Google Routes calls.Routes API: 0 matrix · 0 route · 0 cache hits
Google Maps has not been loaded.Enter a restricted API key above. No production map code is changed by this prototype.
Work Order Emergency WO Verizon Van
DASHBOARD-SIZED PROTOTYPE
Google Dashboard Map Preview
Compact Command Center test only. The existing Dashboard/Command Center map is not replaced by this phase.
Dashboard Google preview waits for the main prototype.Load Google Maps above to populate this compact test.
Active WOs —Live Vans —
WO/van clicks are read-only and jump into the full Google prototype for deeper work.
Dispatch Map Feature ParityGoogle prototype vs. current Madden Dispatch Map workflowChecking…
2.3 is a parity checkpoint, not a production cutover. The current Leaflet/CARTO Dispatch Map remains unchanged and available.
Prototype Diagnostics
Waiting for prototype load.
Management Reports — V10.6.234
Backflow PM reporting, historical year filters, reset tools, waiting-for-parts visibility, and invoice-ready PM totals.
Report Filters
Total PMs0
Completed PMs0
Remaining PMs0
Completion %0%
Ready For Billing $$0
Waiting For Parts0Avg 0.0 days
Invoice Ready Count0
Submitted $$0
Paid $$0
PDF Compliance0%
PMs With PDFs0
Missing PDFs0
Report Data Source Check
Temporary verification cards to confirm reporting is reading PM billing packets and PDF attachments from the same source as Invoice Queue.
PM Data Management
Reset clears workflow progress only. It keeps the PM schedule rows, customer, store, city, month, portal/email links, and assembly data.
Status Breakdown
Customer Breakdown
PM count, completion percentage, ready-for-billing dollars, paid dollars, and PDF compliance by customer.
Assigned Plumber Workload
Assigned PMs, completed PMs, remaining PMs, waiting-for-parts PMs, and invoice-ready PMs by plumber.
PDF Compliance
Waiting For Parts
Month
Customer
Store
PM
City
Plumber
Notes
PMs Missing PDFs / Reports
Month
Customer
Store
PM
City
Status
Plumber
Invoice Review Queue — V10.6.234
Review completed work orders, manage NTE/quote billing holds, invoice totals, email approvals, Corrigo access, and billing status.
Draft0
Waiting NTE / Quote0
Ready for Review0
Submitted0
Paid0
Invoice Queue
No completed/invoice-ready work orders yet.
Completed Invoice Archive
Paid/completed invoice records grouped by store. PMs can be reopened from here if corrections are needed.
Paid invoices will appear here after billing is complete.
Work Order Detail
Status
Priority
Assigned Plumber
Scheduled
Problem / Issue
Location
ServiceChannel
Photos
Customer Signature
Original Request / Email
Store History
Dispatch Notes
Completion / Invoice Packet
QuickBooks Integration
Live QuickBooks Web Connector status, read-only company verification, customer imports, and item imports.
Connection Status
Not Connected
No sync yet
Customers / Jobs
0
Imported from QuickBooks
Items
0
Labor, material, tax, and other items
Connected QuickBooks Company
Company Name
Waiting for connection
Legal Name
—
QBXML Version
—
QuickBooks Connection
Checking connection status...
Customers
Import and review customers and jobs from QuickBooks.
Items
Import invoice items used for labor, materials, tax, and charges.
Customer Mapping
Mapped
0
Review
0
Unmapped
0
QuickBooks Time
Read-only employee and payroll foundation for future weekly time export.
Employees
0
Payroll Items
0
Mapped
0
Profiles
0
Item Profiles
Map Madden labor, travel, materials, and charges to QuickBooks invoice items by customer contract.
Mapped Fields
0
Remaining
45
Imported Customers
QuickBooks Name
Company
Account #
Active
No customers imported yet.
QuickBooks Protocol Monitor
No QuickBooks callbacks received yet.
Sync History
No sync activity yet.
QuickBooks Customer Mapping
Match each Workflow store to its service customer and optional backflow customer in QuickBooks.
Loading mappings...
QuickBooks Item Profiles
Choose the QuickBooks item used for each Madden invoice charge. Profiles are saved by customer contract.
Loading QuickBooks items...
QuickBooks Time Foundation
Map Madden plumbers to QuickBooks employees and assign reusable payroll profiles. Read-only: no time is exported.
Payroll Profiles
Create profiles such as 32 Journeyman, 32 Serviceman, and 26 Journeyman. Click a profile to configure REG, OT, and DB payroll items.
Imported Payroll Items
Employee Mapping
Madden Mobile — V10.6.309
This is the field-only view. A plumber only sees assigned jobs, route info, issue details, notes, and field status buttons.
Choose Madden Mobile Preview
In production, each plumber would log in and only see their own assigned jobs.
Madden Mobile
Field View
Complete Work Order
Work Performed
Recommendations / Follow-Up
Parts Needed / Ordered
Labor
Travel
Materials
Acceptance
ServiceChannel
Photos
Upload before/after/receipt/general photos tied to this WO.
Customer Signature
By signing, customer acknowledges the work performed / service visit was reviewed.
SQLite Database Status
Your work orders, assignments, statuses, notes, ignored emails, and admin emails now persist locally.
Saved Work Orders0
Ignored Emails0
Admin Emails0
Webhook Events0
Database File
This file is your local persistent database. Back it up before moving computers or deleting the app folder.
Assign Work Order
Selected helpers see this visit in Mobile and Calendar.
Visit-based helpers: original helpers do not carry into callbacks unless selected again.
Use this for handoffs. The primary plumber stays as the WO owner, but the active lead controls the current visit workflow.
Store History
Waiting / Follow-Up
These waiting jobs are over 4 days old and may need follow-up unless already scheduled for a future date.
Waiting / Follow-Up
Assembly Test
Assembly Testing
Completed Test Packet Preview
One cover page plus one full test report page per assembly.
Madden Mobile
Sign in with your Madden Workflow account to open the technician app.
This account does not have access to Madden Mobile. Sign out and use a plumber or administrator account.
Plumber account connected. Dedicated mobile routing is not enabled yet. Use the Madden Mobile tab for testing, or sign out from Account.
Install Madden Mobile
Add Madden Mobile to this device for one-tap, full-screen access.
