Battery techs and battery installers. Leave blank to keep the existing value. Unscored techs default to 5 in the router.
Sent to the monitor
Checking…
To:
Subject:
The Google Sheet emails this to the monitor by itself, about a minute after any change. Nothing to click.
Other SVC Scores — 1 (best) to 3 (worst)
Road service techs. Leave blank to keep the existing value. Unscored techs default to 3 in the router.
Sent to the monitor
Checking…
To:
Subject:
The Google Sheet emails this to the monitor by itself, about a minute after any change. Nothing to click.
Canonical Techs — 0 total
Role battery_tech / battery_installer → Battery Scores tab. Role rs → Other SVC Scores tab. Aliases are alternate spellings the monitor accepts when matching schedule-email names to this canonical name (e.g. Mike T, M Tomaso). Email is the tech's address for alert delivery (e.g. tech-missing-GPS); add it as an Email column in the Sheet — leave blank when unknown.
The roster normally comes from the Google Sheet (Settings tab) and is read-only here. Edit the Sheet, click Refresh, then send the Roster Update. Manual rows are only for when no Sheet is configured.
Sent to the monitor — Tech Roster Update
Checking…
To:
Subject:
The Roster Update email ships canonical names + roles + aliases + phone + backup phone to the monitor (techs.json). techs.json is the source of truth for ROLE and phone numbers (used by the wake-up escalation ladder). The Google Sheet emails it by itself about a minute after any roster edit — nothing to click. Add a Phone 2 column in the Sheet for a tech's backup / cell number; the ladder dials it right after the primary before escalating. A tech with Role Director is the top escalation contact.
Roster Google Sheet (shared with Schedule Composer)
CSV URL
Editor URL
Roster not loaded yet.
Both the Schedule Composer and this Tech Composer read the same Sheet so tech names stay consistent. The CSV URL comes from File → Share → Publish to web → CSV. The Editor URL is whatever's in your address bar while editing the sheet. URLs are saved in this browser's localStorage. Sheet columns: Canonical Name, Role, Aliases, Email (role = rs / battery_tech / battery_installer; Email is optional, used for per-tech alert delivery).
Offline / fetch-blocked fallback — paste raw CSV:
Score write-back (saves scores typed here into the Sheet)
Web app URL
Token
With this set, the Battery / Other SVC score boxes are editable and every change is written straight into the Sheet's score columns, so whoever opens the app next sees it. The URL comes from deploying sheet_writeback.gs (in this app's repo) as a Web app on the roster Sheet — Extensions → Apps Script → Deploy. Without it, scores are read-only here and are changed in the Sheet.