Own residents on in-house EM/PEM + incoming residents from other centers (detected automatically from the master sheet). Minimums in Settings.

One row per resident, like the sheet: the two EM selectives (EM at another center), their status and requirements for the chief to follow up, and the electives (where and which specialty). Blocks come from the Master Rota; type the hospital, mark 📤 sent / ✔ approved, note requirements. ☁ Save keeps it.

Where residents choose to go for their selective rotations, by level and over the years. Paste the "Rotation selective" sheet once per academic year; hospital names are normalised automatically.

One line per cross-center rotation: when the request went out (or came in), from which mailbox, and when the approval arrived. Tick the checklist as emails move, or drop an email and let the Hub read it. Private to your center.

Residents submit through the link (sick leave requires the medical report attached) — you and the chief decide here, and ✉ sends the stamped approval form to everyone involved.

Reads the SBEM sheet layout (level rows R4…R1, resident names, 13 block columns). Preview before applying.

Two-way, but only when you click — nothing syncs by itself. ⬇ Pull = Sheet → Hub (you see a comparison first, then Apply). ⬆ Push = Hub → Sheet (writes the chosen tab's columns B–Q only — formulas, stats and structure are never touched). Requires 🔌 Connect Google in Settings.

When residents choose their tracks: pick the level, paste their names in track order (one per line), and they fill "Track 1, 2, 3…" in sequence. You can also click any track name on the sheet to type one name at a time.

Publishes a read-only snapshot (no login needed). Re-publish after big updates.

Chief Resident / Post-grad accounts see the full master sheet + their center's coverage and follow-up — but cannot edit the schedule (PD only).

Invite your chief resident (or post-grad) to your center: this creates their sign-in, emails them a set-password link, and assigns them to your center automatically. Then tick 🧑‍⚕️ chief runs Selectives & Leaves on your center's header bar if the chief is in charge of those.

Each level counts its own rotations (e.g. R3: Hajj & EMS · R1: Ortho & OB). Up to 6 categories per level; the counter columns at the end of each row turn green when met, red when under, amber when over.

How many residents may be on the same rotation in the same block (e.g. EMS max 5, US max 5, ICU max 4). A code without a dash (ICU) caps that rotation at any site; with a dash (ICU-PMAH) caps that exact site only. The 📊 counts table under your sheet colors violations red, and 💡 Auto-fill respects these caps.

Used in the cell menu. EM-<CENTER> codes are built automatically from the center list.

Used by the ✉ buttons in the incoming/outgoing list. Placeholders: {resident} {level} {home} {host} {block} {dates} {type} {ay} {myname}

One connection gives you: 🚀 one-click request emails with the PDF attached, and ⬇⬆ sync with the shared SBEM Google Sheet.
Each PD: click Connect once and approve Google's popup — after that it reconnects by itself. You connect your own Gmail; nobody else can use or see it. The ID below is the app's public identifier, not a password.
Admin setup (once, already done if this works): Google Cloud Console → Credentials → web OAuth client → add this site to Authorized JavaScript origins → enable Gmail + Sheets APIs → add each PD's Gmail under OAuth consent screen → Test users → paste the Client ID here → ☁ Save.
Sheet safety: Pull only reads. Push writes only your own tab's white cells (columns B–Q) — never adds/removes rows, never touches the formulas, statistics, the Master tab, or other centers; Google's per-PD protections still apply, and the sheet's Version history is the rollback.

For clearing test data or starting a fresh academic year. These write to the cloud immediately.

Each center's PD, chief resident and post-grad emails — set once, used for every request email to that center.