📹 Cameras — Admin Only

Live and event dashcam footage from Samsara. Visible only to the Admin role.

🛡 Safety & HR — Admin Only

Samsara safety events (harsh braking, speeding, seatbelt) and driver HR / discipline. Admin-only.

Samsara's API does not offer live streaming. Recorded-footage retrieval needs the camera media scopes plus camera hardware on the vehicle. Request a clip below, then review it in the Samsara console.

📝 RC Forms & Filing

Fill Alta Regional Center forms on their original templates, draft narrative sections with AI, then download or email straight to the coordinator. Pick a form to begin.

Every form filed here or in the standalone Alta Forms Hub — one shared list, so admin and drivers retrieve the same records from either app.

📇 Directory

Tap Call or Text to reach anyone through your own company phone — no charge, nothing is dialed by the app.

🚐 Fleet & Driver Compliance

Live from the backend. Upload your master “Driver List and Fleet List.xlsx” once to load/refresh.

Vehicles

Driver certifications

🔧 Maintenance

Manufacturer schedule + repair log with due tracking. Live from the backend.

Real engine fault codes (check-engine), battery voltage and coolant temp per vehicle — not a mock. Flags any van that needs attention.

History

🧭 Trip Sessions

Upload a TripSpark route manifest (PDF) — the backend extracts each rider’s exact AM pickup → arrival → departure → PM drop-off.

🔐 Access & Accounts

Give each staff member their own login. When someone leaves, tap Revoke — they're logged out instantly and can't sign back in. No need to change anyone else's code.

✅ Today — mark attendance

Tap each rider as you complete the stop. Round Trip = rode both ways · One Way = one leg · No Show · Cancel · Absent. Saves instantly and feeds the monthly report.

When the van reaches a rider's stop, it pops up here — tap Boarded or No-Show once, GPS-timestamped. Each boarding adds a leg (One Way → Round Trip). Runs in demo mode until the Samsara address scope + geocoded stops are added, then it flips to live automatically.

📋 Monthly Attendance

Attendance codes: 0 Absent · 1 One Way · 2 Round Trip · NS No Show · C Cancellation · X Vendor Cancellation.

Edit mode on — set any rider's code for any day (e.g. a driver forgot to enter it). Changes save instantly and feed billing + no-show detection.

Morning Van Inspection

Company device · complete before pullout. Wheelchair lift is mandatory — any FAIL flags the van DO NOT OPERATE.

⛽ Gas log — end of day

Fuel level — start —F7/83/45/81/23/81/41/8E

Fuel level — end —F7/83/45/81/23/81/41/8E

Gas station — select —

Paid with Company credit cardPetty cash

Gas added ($)

Cash given ($)

Change back ($) — auto

Driver initials

📷 Receipt photo (for gas verification)

📈 Reports

Operational + financial reports. Fuel-expense exports feed the SEC Financial Operations (FOS) app.

Attendance — by route & by day

Riders present per route each service day (⚠ = no-shows).

⛽ Gas log & fuel expenses

Every fill with payment method (petty cash / credit card), amounts, change, and receipt status.

📊 Fuel usage — per day, by vehicle

Miles driven per van per day (from Samsara odometer snapshots) plus gas $ filled that day. Batch report for one van or all vehicles.

Fuel Level Check

Required before pulling out. Read the fuel gauge on the van dashboard and select the matching level. This locks into the inspection — you can't submit inspection if the tank is below ¼ without confirming you have a gas card or cash to refuel.

Today's Route

Mark each rider per leg. Round-trip = AM + PM. Enter your ending odometer at the end of your route.

📋 My tasks

Tasks assigned to you this week and next. Mark done as you complete them.

Drop a Route Detail or TSR spreadsheet (.xlsx). The app reads its columns; you map each one to a board field, preview, then push to the board. No retyping vans.

Dispatch & Scheduling

Assign vans to route blocks across the day.

Pending Rider Assignments

Riders with current ACRC TSRs on file but not on any of the 8 active manifests. Resolve each one with R&D / Alta before pulling them onto a route.

Driver Schedule

Every driver is scheduled for exactly 8 paid hours per day — 6 hrs required work (AM + paid standby + PM) plus 2 hrs discretionary. All times derive from rider manifests (TSRs). Edit any field below and the schedule recomputes.

Task Library

Master catalog of duties drivers can be assigned during their 2-hr discretionary block, early-return windows, or post-shift garage time. Each task has a duty chart (instructions + acceptance criteria). Tasks here are the menu — assignment happens on the Task Schedule tab.

🎯 Ops Console

Live operational picture: today's task completion, unacknowledged safety events, EOD status, and live vehicle positions. One glance — one decision.

🛰 Samsara Routes

Routes stored in Samsara. Read via the Samsara Routing API. Route progress is tracked automatically by each van's Vehicle Gateway — no manual start/stop by drivers.

Driver Roster

Single source of truth for who's employed. Sync pulls folder names from Dropbox; termination status lives only here — sync will never re-activate a terminated driver, even if their folder still exists in Dropbox.

Nightly automated snapshot to Dropbox at ~2 AM PT. Backups stored at /sec-fleet-ops-backups/. Restore = drop file back into sec-fleet.db on the Repl.

👤 Rider Database

Persistent rider records with UCI, mobility, program, service coordinator contact, and behavioral flags. Discharged riders are hidden but retained in history.

📋 Special Incident Reports

Auto-populates ACRC form 552x from a rider record and, optionally, a linked Samsara safety event. Draft → review → submit externally to ACRC → mark submitted here for tracking.

🔄 Auto-rotate schedule

Generates a fair rotation: van-specific tasks go to that van's driver; shared tasks rotate weekly so no one repeats. Each driver's day is capped at 6h optimal / 8h max (route driving counts) — overtime is flagged. Days a route doesn't run are marked for time-off-or-tasks review.

Weekly Task Assignment

Assign tasks from the library to drivers on specific days. Tasks fill discretionary gaps, post-shift windows, or early-return windows. Late-route tasks auto-route per category: Compliance/Maintenance/Operations/Training → flag for admin · Cleaning/Admin → roll forward.

Attendance & Auto-Billing

Track each rider's AM and PM attendance separately for the operational record. Billing still rolls up to one day per §11.3.4: $800 per route per day the route ran (regardless of partial attendance), plus $120 per billable 1:1 attendant per day the attended rider rode in either leg.

Program Closure Calendar

Track day-program closures (holidays, in-services, weather days). When a program is closed, riders going to that program don't ride — the route either doesn't run or runs partial. Upload a program calendar to populate dates automatically; click any day to mark/unmark manually.

Tip: click a day cell to open the closure picker. Multiple programs can be closed on the same day. Weekends are dimmed by default (no scheduled service).

Drag a PDF, Excel, or CSV calendar from any of your programs and the parser will identify closure dates and apply them. (Parser activates once you upload a sample so I can match its format.)

Monthly Billing & Growth

Rolls up every auto-posted billing line by calendar month. Source data comes from the Attendance tab — close out each day there and the totals here recalculate.

Growth Model

The live version of your spreadsheet. Adjust the levers and watch annual revenue move toward the target.

Utilization = shifts worked ÷ 3 possible (AM / MID / PM).

Integration layer between sec-fleet-ops and Samsara. Today: CSV bridge + mock-mode simulator (works offline, lets you see live-integration UX without an account). Tomorrow: paste API credentials and flip to live mode — same UI, real data.

Generates a CSV file containing every rider as a stop, grouped by route. Upload to Samsara Fleet → Routing → Import, or use the Samsara Routing API. (Or in live mode, use the Samsara Routing API.)

Upload a Samsara stats export (CSV) for a service date — OR pull live from the API in live mode / from the simulator in mock mode. Reads geofence arrival/departure events, pre-populates attendance.

Every van's live position, fuel, engine state, and odometer. Polls the Samsara stats endpoint every 30 seconds when Live Fleet is toggled ON. Read-only.

Compares billed Vehicle Service Hours (from posted billing rows) against actual GPS first-pickup-to-last-dropoff timestamps from Samsara. Flags discrepancies for review. Catches both under-billing (lost revenue) and over-billing (audit risk).

When mock mode is active, shows simulated GPS positions, fuel levels, and fault codes per van. When live mode is active and your backend is connected, shows real data polled every 60 seconds.

Route CSV import requires these column headers exactly (case-sensitive). The export above uses this format automatically.

Live mode requires a Node.js backend deployed on Replit/Render/Vercel. The backend stores your Samsara API token securely, proxies all requests, and receives Samsara webhooks. A ready-to-deploy version is delivered alongside this file (sec-backend/server.js).

Deployment steps:

1. Provision Samsara account, get API token from cloud.samsara.com → Settings → API Tokens
2. Create a new Replit project, paste sec-backend/server.js
3. Set Replit Secrets: SAMSARA_API_TOKEN, API_KEY_SEC=DGE_TOKEN (any random string)
4. Click Run, copy the public URL
5. Return here → Connection panel → Live mode → paste backend URL + auth token → Test connection
6. (Optional) In Samsara Dashboard → Settings → Webhooks, register webhook URL: {backend}/webhook for real-time push