pwe

It looks like your message might have been a typo or got cut short — "pwe" doesn't match anything I can clearly interpret. Did you mean:

  • PWE — as in a specific acronym (e.g., "Protected Work Environment," or something else)?

  • Power or password — a truncated word?

  • Something else entirely?

Just let me know what you were going for and I'm happy to help!

Prepared using Claude Opus 4.6 Thinking
run for may 7700 auths
May_2026_Shift_Calendar

May 2026 — AZ PA Shift Assignment Calendar

Team: 15 docs (HR, BR, MAL, DD, RC, SL, MS, BM, CS, VS, Popli, Ji, Bekera, Harrington, Canonico)
Effective FTE: 15 − 0.5 (BR half) − 0.75 (BM quarter) = 13.75 FTE
BR counts 0.5 FTE when on (adj −0.5). BM/Marotz counts 0.25 FTE when on (adj −0.75). All others = 1.0 FTE.
LG = external HI (no FTE impact). Bekera clinic (Tue PM) excluded from clinic count.
Avg Daily Auths: 350.0/day (7,700 ÷ 22)

Monday

Tuesday

Wednesday

Thursday

Friday

Wknd/Notes

11 OUT

AZ-AM: MAL DD HR BR SL CS RC MS VS

AZ-PM: MAL DD BR CS RC MS VS

AZ-DoD: MAL

AZ-PTO:

AZ-Swing: Marotz

West Clinic: VS(AM), SL(PM)

NV: HR BR

WA-overflow: MAL

WA-P: Popli

WA-J: Ji

OR: Bekera

OR: Harrington

HI: Canonico

────────────────────────────

West Clinic: VS(AM), SL(PM) = 1.0

AZ PTO: 0

West PTO: 0

TOTAL OUT: 1 (15−1=14 on)

TOTAL ON: 14 −0.5 BR −0.75 BM = 12.75

~27 auths/MD (350.0÷12.75)

Sat 2 / Sun 3

41 OUT

AZ-AM: MAL DD HR BR SL MS VS

AZ-PM: MAL DD HR SL RC MS VS

AZ-DoD: SL

AZ-PTO:

AZ-Swing: Marotz

West Clinic: RC(AM), BR(PM)

NV: HR BR

WA-overflow: MAL

WA-P: Popli

WA-J: Ji

OR: Bekera

OR: Harrington

HI: Canonico

────────────────────────────

West Clinic: RC(AM), BR(PM) = 1.0

AZ PTO: 0

West PTO: 0

TOTAL OUT: 1 (15−1=14 on)

TOTAL ON: 14 −0.5 BR −0.75 BM = 12.75

~27 auths/MD (350.0÷12.75)

50.5 OUT

AZ-AM: MAL DD HR BR SL RC MS VS

AZ-PM: DD HR BR SL CS RC MS VS

AZ-DoD: DD

AZ-PTO:

AZ-Swing: Marotz

West Clinic: MAL(PM), Bekera(PM)

NV: HR BR

WA-overflow: MAL

WA-P: Popli

WA-J: Ji

OR: Bekera

OR: Harrington

HI: Canonico

────────────────────────────

West Clinic: MAL(PM) = 0.5

AZ PTO: 0

West PTO: 0

TOTAL OUT: 0.5 (15−0.5=14.5 on)

TOTAL ON: 14.5 −0.5 BR −0.75 BM = 13.25

~26 auths/MD (350.0÷13.25)

61.5 OUT

AZ-AM: MAL DD HR BR SL RC VS

AZ-PM: MAL HR BR SL CS RC MS VS

AZ-DoD: HR

AZ-PTO:

AZ-Swing: Marotz

West Clinic: MS(AM), DD(PM), Popli(PM)

NV: HR BR

WA-overflow: MAL

WA-P: AM Popli/PM MAL

WA-J: Ji

OR: Bekera

OR: Harrington

HI: Canonico

────────────────────────────

West Clinic: MS(AM), DD(PM), Popli(PM) = 1.5

AZ PTO: 0

West PTO: 0

TOTAL OUT: 1.5 (15−1.5=13.5 on)

TOTAL ON: 13.5 −0.5 BR −0.75 BM = 12.25

~29 auths/MD (350.0÷12.25)

71 OUT

AZ-AM: MAL DD HR BR SL CS RC MS VS

AZ-PM: MAL DD BR SL CS RC MS VS

AZ-DoD: RC

AZ-PTO:

AZ-Swing: Marotz

West Clinic: HR(PM), Singh(PM)

NV: HR BR

WA-overflow: MAL

WA-P: Popli

WA-J: Ji

OR: Bekera

OR: Harrington

HI: Canonico

────────────────────────────

West Clinic: HR(PM), Singh(PM) = 1.0

AZ PTO: 0

West PTO: 0

TOTAL OUT: 1 (15−1=14 on)

TOTAL ON: 14 −0.5 BR −0.75 BM = 12.75

~27 auths/MD (350.0÷12.75)

81 OUT

AZ-AM: MAL DD HR BR SL CS RC MS VS

AZ-PM: MAL DD BR CS RC MS VS

AZ-DoD: MAL

AZ-PTO:

AZ-Swing: Marotz

West Clinic: VS(AM), SL(PM)

NV: HR BR

WA-overflow: MAL

WA-P: Popli

WA-J: Ji

OR: Bekera

OR: Harrington

HI: Canonico

────────────────────────────

West Clinic: VS(AM), SL(PM) = 1.0

AZ PTO: 0

West PTO: 0

TOTAL OUT: 1 (15−1=14 on)

TOTAL ON: 14 −0.5 BR −0.75 BM = 12.75

~27 auths/MD (350.0÷12.75)

Sat 9 / Sun 10

Monday

Tuesday

Wednesday

Thursday

Friday

Wknd/Notes

111 OUT

AZ-AM: MAL DD HR BR SL MS VS

AZ-PM: MAL DD HR SL RC MS VS

AZ-DoD: SL

AZ-PTO:

AZ-Swing: Marotz

West Clinic: RC(AM), BR(PM)

NV: HR BR

WA-overflow: MAL

WA-P: Popli

WA-J: Ji

OR: Bekera

OR: Harrington

HI: Canonico

────────────────────────────

West Clinic: RC(AM), BR(PM) = 1.0

AZ PTO: 0

West PTO: 0

TOTAL OUT: 1 (15−1=14 on)

TOTAL ON: 14 −0.5 BR −0.75 BM = 12.75

~27 auths/MD (350.0÷12.75)

120.5 OUT

AZ-AM: MAL DD HR BR SL RC MS VS

AZ-PM: DD HR BR SL CS RC MS VS

AZ-DoD: DD

AZ-PTO:

AZ-Swing: Marotz

West Clinic: MAL(PM), Bekera(PM)

NV: HR BR

WA-overflow: MAL

WA-P: Popli

WA-J: Ji

OR: Bekera

OR: Harrington

HI: Canonico

────────────────────────────

West Clinic: MAL(PM) = 0.5

AZ PTO: 0

West PTO: 0

TOTAL OUT: 0.5 (15−0.5=14.5 on)

TOTAL ON: 14.5 −0.5 BR −0.75 BM = 13.25

~26 auths/MD (350.0÷13.25)

131.5 OUT

AZ-AM: MAL DD HR BR SL RC VS

AZ-PM: MAL HR BR SL CS RC MS VS

AZ-DoD: HR

AZ-PTO:

AZ-Swing: Marotz

West Clinic: MS(AM), DD(PM), Popli(PM)

NV: HR BR

WA-overflow: MAL

WA-P: AM Popli/PM MAL

WA-J: Ji

OR: Bekera

OR: Harrington

HI: Canonico

────────────────────────────

West Clinic: MS(AM), DD(PM), Popli(PM) = 1.5

AZ PTO: 0

West PTO: 0

TOTAL OUT: 1.5 (15−1.5=13.5 on)

TOTAL ON: 13.5 −0.5 BR −0.75 BM = 12.25

~29 auths/MD (350.0÷12.25)

141 OUT

AZ-AM: MAL DD HR BR SL CS RC MS VS

AZ-PM: MAL DD BR SL CS RC MS VS

AZ-DoD: RC

AZ-PTO:

AZ-Swing: Marotz

West Clinic: HR(PM), Singh(PM)

NV: HR BR

WA-overflow: MAL

WA-P: Popli

WA-J: Ji

OR: Bekera

OR: Harrington

HI: Canonico

────────────────────────────

West Clinic: HR(PM), Singh(PM) = 1.0

AZ PTO: 0

West PTO: 0

TOTAL OUT: 1 (15−1=14 on)

TOTAL ON: 14 −0.5 BR −0.75 BM = 12.75

~27 auths/MD (350.0÷12.75)

151 OUT

AZ-AM: MAL DD HR BR SL CS RC MS VS

AZ-PM: MAL DD BR CS RC MS VS

AZ-DoD: MAL

AZ-PTO:

AZ-Swing: Marotz

West Clinic: VS(AM), SL(PM)

NV: HR BR

WA-overflow: MAL

WA-P: Popli

WA-J: Ji

OR: Bekera

OR: Harrington

HI: Canonico

────────────────────────────

West Clinic: VS(AM), SL(PM) = 1.0

AZ PTO: 0

West PTO: 0

TOTAL OUT: 1 (15−1=14 on)

TOTAL ON: 14 −0.5 BR −0.75 BM = 12.75

~27 auths/MD (350.0÷12.75)

Sat 16 / Sun 17

181 OUT

AZ-AM: MAL DD HR BR SL MS VS

AZ-PM: MAL DD HR SL RC MS VS

AZ-DoD: SL

AZ-PTO:

AZ-Swing: Marotz

West Clinic: RC(AM), BR(PM)

NV: HR BR

WA-overflow: MAL

WA-P: Popli

WA-J: Ji

OR: Bekera

OR: Harrington

HI: Canonico

────────────────────────────

West Clinic: RC(AM), BR(PM) = 1.0

AZ PTO: 0

West PTO: 0

TOTAL OUT: 1 (15−1=14 on)

TOTAL ON: 14 −0.5 BR −0.75 BM = 12.75

~27 auths/MD (350.0÷12.75)

190.5 OUT

AZ-AM: MAL DD HR BR SL RC MS VS

AZ-PM: DD HR BR SL CS RC MS VS

AZ-DoD: DD

AZ-PTO:

AZ-Swing: Marotz

West Clinic: MAL(PM), Bekera(PM)

NV: HR BR

WA-overflow: MAL

WA-P: Popli

WA-J: Ji

OR: Bekera

OR: Harrington

HI: Canonico

────────────────────────────

West Clinic: MAL(PM) = 0.5

AZ PTO: 0

West PTO: 0

TOTAL OUT: 0.5 (15−0.5=14.5 on)

TOTAL ON: 14.5 −0.5 BR −0.75 BM = 13.25

~26 auths/MD (350.0÷13.25)

201.5 OUT

AZ-AM: MAL DD HR BR SL RC VS

AZ-PM: MAL HR BR SL CS RC MS VS

AZ-DoD: HR

AZ-PTO:

AZ-Swing: Marotz

West Clinic: MS(AM), DD(PM), Popli(PM)

NV: HR BR

WA-overflow: MAL

WA-P: AM Popli/PM MAL

WA-J: Ji

OR: Bekera

OR: Harrington

HI: Canonico

────────────────────────────

West Clinic: MS(AM), DD(PM), Popli(PM) = 1.5

AZ PTO: 0

West PTO: 0

TOTAL OUT: 1.5 (15−1.5=13.5 on)

TOTAL ON: 13.5 −0.5 BR −0.75 BM = 12.25

~29 auths/MD (350.0÷12.25)

211 OUT

AZ-AM: MAL DD HR BR SL CS RC MS VS

AZ-PM: MAL DD BR SL CS RC MS VS

AZ-DoD: RC

AZ-PTO:

AZ-Swing: Marotz

West Clinic: HR(PM), Singh(PM)

NV: HR BR

WA-overflow: MAL

WA-P: Popli

WA-J: Ji

OR: Bekera

OR: Harrington

HI: Canonico

────────────────────────────

West Clinic: HR(PM), Singh(PM) = 1.0

AZ PTO: 0

West PTO: 0

TOTAL OUT: 1 (15−1=14 on)

TOTAL ON: 14 −0.5 BR −0.75 BM = 12.75

~27 auths/MD (350.0÷12.75)

221 OUT

AZ-AM: MAL DD HR BR SL CS RC MS VS

AZ-PM: MAL DD BR CS RC MS VS

AZ-DoD: MAL

AZ-PTO:

AZ-Swing: Marotz

West Clinic: VS(AM), SL(PM)

NV: HR BR

WA-overflow: MAL

WA-P: Popli

WA-J: Ji

OR: Bekera

OR: Harrington

HI: Canonico

────────────────────────────

West Clinic: VS(AM), SL(PM) = 1.0

AZ PTO: 0

West PTO: 0

TOTAL OUT: 1 (15−1=14 on)

TOTAL ON: 14 −0.5 BR −0.75 BM = 12.75

~27 auths/MD (350.0÷12.75)

Sat 23 / Sun 24

Monday

Tuesday

Wednesday

Thursday

Friday

Wknd/Notes

251 OUT

AZ-AM: MAL DD HR BR SL MS VS

AZ-PM: MAL DD HR SL RC MS VS

AZ-DoD: SL

AZ-PTO:

AZ-Swing: Marotz

West Clinic: RC(AM), BR(PM)

NV: HR BR

WA-overflow: MAL

WA-P: Popli

WA-J: Ji

OR: Bekera

OR: Harrington

HI: Canonico

────────────────────────────

West Clinic: RC(AM), BR(PM) = 1.0

AZ PTO: 0

West PTO: 0

TOTAL OUT: 1 (15−1=14 on)

TOTAL ON: 14 −0.5 BR −0.75 BM = 12.75

~27 auths/MD (350.0÷12.75)

260.5 OUT

AZ-AM: MAL DD HR BR SL RC MS VS

AZ-PM: DD HR BR SL CS RC MS VS

AZ-DoD: DD

AZ-PTO:

AZ-Swing: Marotz

West Clinic: MAL(PM), Bekera(PM)

NV: HR BR

WA-overflow: MAL

WA-P: Popli

WA-J: Ji

OR: Bekera

OR: Harrington

HI: Canonico

────────────────────────────

West Clinic: MAL(PM) = 0.5

AZ PTO: 0

West PTO: 0

TOTAL OUT: 0.5 (15−0.5=14.5 on)

TOTAL ON: 14.5 −0.5 BR −0.75 BM = 13.25

~26 auths/MD (350.0÷13.25)

271.5 OUT

AZ-AM: MAL DD HR BR SL RC VS

AZ-PM: MAL HR BR SL CS RC MS VS

AZ-DoD: HR

AZ-PTO:

AZ-Swing: Marotz

West Clinic: MS(AM), DD(PM), Popli(PM)

NV: HR BR

WA-overflow: MAL

WA-P: AM Popli/PM MAL

WA-J: Ji

OR: Bekera

OR: Harrington

HI: Canonico

────────────────────────────

West Clinic: MS(AM), DD(PM), Popli(PM) = 1.5

AZ PTO: 0

West PTO: 0

TOTAL OUT: 1.5 (15−1.5=13.5 on)

TOTAL ON: 13.5 −0.5 BR −0.75 BM = 12.25

~29 auths/MD (350.0÷12.25)

281 OUT

AZ-AM: MAL DD HR BR SL CS RC MS VS

AZ-PM: MAL DD BR SL CS RC MS VS

AZ-DoD: RC

AZ-PTO:

AZ-Swing: Marotz

West Clinic: HR(PM), Singh(PM)

NV: HR BR

WA-overflow: MAL

WA-P: Popli

WA-J: Ji

OR: Bekera

OR: Harrington

HI: Canonico

────────────────────────────

West Clinic: HR(PM), Singh(PM) = 1.0

AZ PTO: 0

West PTO: 0

TOTAL OUT: 1 (15−1=14 on)

TOTAL ON: 14 −0.5 BR −0.75 BM = 12.75

~27 auths/MD (350.0÷12.75)

291 OUT

AZ-AM: MAL DD HR BR SL CS RC MS VS

AZ-PM: MAL DD BR CS RC MS VS

AZ-DoD: MAL

AZ-PTO:

AZ-Swing: Marotz

West Clinic: VS(AM), SL(PM)

NV: HR BR

WA-overflow: MAL

WA-P: Popli

WA-J: Ji

OR: Bekera

OR: Harrington

HI: Canonico

────────────────────────────

West Clinic: VS(AM), SL(PM) = 1.0

AZ PTO: 0

West PTO: 0

TOTAL OUT: 1 (15−1=14 on)

TOTAL ON: 14 −0.5 BR −0.75 BM = 12.75

~27 auths/MD (350.0÷12.75)

Sat 30 / Sun 31

Projected Auths per MD — Headcount Model

Team = 15 docs | Avg Daily Auths = 350.0 (7,700 ÷ 22)

BR counts 0.5 FTE when on (adj −0.50). BM/Marotz counts 0.25 FTE when on (adj −0.75).
All others count as 1.0 FTE when on.
Effective baseline FTE = 15 − 0.50 (BR) − 0.75 (BM) = 13.75

Provider Reference

Init

Provider

FTE When On

Role

MAL

Lecavalier

1.0

AZ UM + WA overflow

DD

Dunnigan

1.0

AZ UM

HR

H. Roemer

1.0

AZ UM + NV

BR

B. Roemer

0.5

AZ UM (half) + NV

SL

Lewis

1.0

AZ UM

CS

Sterling

1.0

AZ UM

RC

Carranza

1.0

AZ UM

MS

Salah

1.0

AZ UM

VS

Shah

1.0

AZ UM

BM

Marotz

0.25

AZ Swing

Ji

Ji

1.0

WA-J

Popli

Popli

1.0

WA-P

Bekera

Bekera

1.0

OR

MH

Harrington

1.0

OR

Canonico

Canonico

1.0

HI

Auths per MD — Docs Out vs Workload (350.0/day)

Assumes BR + BM both on. Adjusted ON = (15 − out) − 0.50 (BR) − 0.75 (BM)

Docs Out

Raw On (15−out)

Adj (−0.5 BR −0.75 BM)

Avg Auths/Day

Auths/MD (avg÷adj)

Increase

Tier

0 (baseline)

15

13.75

350.0

25.5 (350.0÷13.75)

—

🟢 Green

1

14

12.75

350.0

27.5 (350.0÷12.75)

+2.0

🟢 Green

2

13

11.75

350.0

29.8 (350.0÷11.75)

+4.3

🟢 Green

3

12

10.75

350.0

32.6 (350.0÷10.75)

+7.1

🟢 Green

Docs Out

Raw On (15−out)

Adj (−0.5 BR −0.75 BM)

Avg Auths/Day

Auths/MD (avg÷adj)

Increase

Tier

4

11

9.75

350.0

35.9 (350.0÷9.75)

+10.4

🟢 Green

5

10

8.75

350.0

40.0 (350.0÷8.75)

+14.5

🟡 Yellow

Individual Provider Off — Impact

Provider Off

Docs Out

Raw On

Adj ON

Auths/Day

Auths/MD

Increase

Any 1.0 FTE doc

1

14

12.75

350.0

27.5 (350.0÷12.75)

+2.0

BR (0.5 FTE)

1

14

13.25

350.0

26.4 (350.0÷13.25)

+1.0

BM/Marotz (0.25 FTE)

1

14

13.50

350.0

25.9 (350.0÷13.50)

+0.5

Calculation Rules for Daily Auths/MD

Team: 15 docs | Avg Daily Auths: 350.0 (7,700 ÷ 22)
Effective FTE: 15 − 0.50 (BR) − 0.75 (BM) = 13.75

Core Formula

• TOTAL OUT = West Clinic (excl Bekera) + AZ PTO headcount + West PTO headcount

• TOTAL ON (raw) = 15 − TOTAL OUT

• TOTAL ON (adjusted) = raw − 0.50 (if BR on) − 0.75 (if BM on)

• Auths/MD = Avg Daily Auths ÷ TOTAL ON (adjusted)

• BR counts as 0.5 FTE when on for the day (adjustment = −0.50)

• BM/Marotz counts as 0.25 FTE when on for the day (adjustment = −0.75)

• All other docs count as 1.0 FTE when on

• If BR is OFF (PTO), the −0.50 adjustment does NOT apply (already subtracted as 1 out)

• If BM is OFF (PTO), the −0.75 adjustment does NOT apply (already subtracted as 1 out)

• WA-P Wed rule: Template is AM Popli/PM MAL. If MAL is on PTO, PM MAL → PM [sub].

The PM substitution does NOT add to TOTAL OUT — MAL is already counted as 1 out via AZ PTO.

Use WAP_OVERRIDES to specify who covers PM (e.g. PM MS). Otherwise shows PM [TBD].

Worked Example — Monday (baseline, no PTO)

Step

Calculation

West Clinic

RC(AM) + BR(PM) = 1.0 (Bekera excluded)

AZ PTO

0 (nobody on PTO)

West PTO

0 (no west doc absences)

TOTAL OUT

1.0 + 0 + 0 = 1.0

Raw ON

15 − 1.0 = 14

Adj ON

14 − 0.50 (BR) − 0.75 (BM) = 12.75

Auths/MD

350.0 ÷ 12.75 = 27.5

TOTAL OUT Components

Component

What Counts

Rule

West Clinic

Half-day clinic sessions
(excl. Bekera — outside pool)

Each session = 0.5 out

AZ PTO

Providers on PTO

Each person = 1 out (headcount)

West PTO

West docs absent
(Ji, Popli, Bekera, Harrington, Canonico)

Each absent = 1 out

Bekera Clinic Exclusion

Bekera clinic (Tue PM) is excluded from West Clinic count — covered by outside pool.
All other clinic sessions (RC, BR, MS, DD, HR, Singh, SL, MAL, Popli) count as 0.5 out each.

Tier Thresholds (Auths/MD)

Range

Tier

Color

<40

Green

🟢

40–43

Yellow

🟡

44–47

Orange

🟠

48–52

Red

🔴

53+

Red+

🔴

of 7

Your May 2026 Shift Calendar has been generated successfully . Here's a quick summary of the run:

  • Month: May 2026

  • Prior month auths: 7,700 (April had 22 workdays)

  • Avg daily auths: 350.0/day (7,700 ÷ 22)cal_gen-9.txt

  • Workdays in May: 21

  • Team: 15 docs | Effective FTE: 13.75

  • Highlights: 0 (no PTO, overrides, or coverage changes entered)

The calendar is using all default staffing templates with no PTO, holidays, or overrides configured. If you need to add any PTO, weekend call assignments, holidays (like Memorial Day on May 25), or coverage overrides, let me know and I'll re-run it with those inputs.

Prepared using Claude Opus 4.6 Thinking
populate PTO for may: HI: Fri 5/1: L Gallagher Thu 5/7: S Lewis Fri 5/8: L Gallagher Wed 5/13: R Carranza Fri 5/15: R Carranza Thu 5/21: S Lewis Fri 5/22: D Dunnigan Wed 5/27: L Gallagher Fri 5/29: D Dunnigan. WA-J Fri 5/1: D Dunnigan Mon 5/4: S Lewis Tue 5/5: R Carranza Wed 5/6: S Lewis Thu 5/7: M Salah Fri 5/8: D Dunnigan Mon 5/11: M Salah Tue 5/12: R Carranza Wed 5/13: S Lewis Thu 5/14: D Dunnigan Fri 5/15: M Salah Mon 5/18: S Lewis Tue 5/19: R Carranza Wed 5/20: S Lewis Thu 5/21: D Dunnigan Fri 5/22: M Salah Mon 5/25: M Salah (Holiday) Tue 5/26: R Carranza Wed 5/27: R Carranza Thu 5/28: D Dunnigan. Dr. Susan Lewis   May 23- 27 CME. Dr.  Racquel Carranza  May 20, 21, 22. Dr. MaryAnn Lecavalier  5/20- 6/4
May_2026_Shift_Calendar

May 2026 — AZ PA Shift Assignment Calendar

Team: 15 docs (HR, BR, MAL, DD, RC, SL, MS, BM, CS, VS, Popli, Ji, Bekera, Harrington, Canonico)
Effective FTE: 15 − 0.5 (BR half) − 0.75 (BM quarter) = 13.75 FTE
BR counts 0.5 FTE when on (adj −0.5). BM/Marotz counts 0.25 FTE when on (adj −0.75). All others = 1.0 FTE.
LG = external HI (no FTE impact). Bekera clinic (Tue PM) excluded from clinic count.
Avg Daily Auths: 350.0/day (7,700 ÷ 22)

Monday

Tuesday

Wednesday

Thursday

Friday

Wknd/Notes

12 OUT

AZ-AM: MAL DD HR BR SL CS RC MS VS

AZ-PM: MAL DD BR CS RC MS VS

AZ-DoD: MAL

AZ-PTO:

AZ-Swing: Marotz

West Clinic: VS(AM), SL(PM)

NV: HR BR

WA-overflow: MAL

WA-P: Popli

WA-J: DD

OR: Bekera

OR: Harrington

HI: LG (no FTE impact)

────────────────────────────

West Clinic: VS(AM), SL(PM) = 1.0

AZ PTO: 0

West PTO: Ji = 1

TOTAL OUT: 2 (15−2=13 on)

TOTAL ON: 13 −0.5 BR −0.75 BM = 11.75

~30 auths/MD (350.0÷11.75)

Sat 2 / Sun 3

42 OUT

AZ-AM: MAL DD HR BR SL MS VS

AZ-PM: MAL DD HR SL RC MS VS

AZ-DoD: SL

AZ-PTO:

AZ-Swing: Marotz

West Clinic: RC(AM), BR(PM)

NV: HR BR

WA-overflow: MAL

WA-P: Popli

WA-J: SL

OR: Bekera

OR: Harrington

HI: Canonico

────────────────────────────

West Clinic: RC(AM), BR(PM) = 1.0

AZ PTO: 0

West PTO: Ji = 1

TOTAL OUT: 2 (15−2=13 on)

TOTAL ON: 13 −0.5 BR −0.75 BM = 11.75

~30 auths/MD (350.0÷11.75)

51.5 OUT

AZ-AM: MAL DD HR BR SL RC MS VS

AZ-PM: DD HR BR SL CS RC MS VS

AZ-DoD: DD

AZ-PTO:

AZ-Swing: Marotz

West Clinic: MAL(PM), Bekera(PM)

NV: HR BR

WA-overflow: MAL

WA-P: Popli

WA-J: RC

OR: Bekera

OR: Harrington

HI: Canonico

────────────────────────────

West Clinic: MAL(PM) = 0.5

AZ PTO: 0

West PTO: Ji = 1

TOTAL OUT: 1.5 (15−1.5=13.5 on)

TOTAL ON: 13.5 −0.5 BR −0.75 BM = 12.25

~29 auths/MD (350.0÷12.25)

62.5 OUT

AZ-AM: MAL DD HR BR SL RC VS

AZ-PM: MAL HR BR SL CS RC MS VS

AZ-DoD: HR

AZ-PTO:

AZ-Swing: Marotz

West Clinic: MS(AM), DD(PM), Popli(PM)

NV: HR BR

WA-overflow: MAL

WA-P: AM Popli/PM MAL

WA-J: SL

OR: Bekera

OR: Harrington

HI: Canonico

────────────────────────────

West Clinic: MS(AM), DD(PM), Popli(PM) = 1.5

AZ PTO: 0

West PTO: Ji = 1

TOTAL OUT: 2.5 (15−2.5=12.5 on)

TOTAL ON: 12.5 −0.5 BR −0.75 BM = 11.25

~31 auths/MD (350.0÷11.25)

73 OUT

AZ-AM: MAL DD HR BR CS RC MS VS

AZ-PM: MAL DD BR CS RC MS VS

AZ-DoD: RC

AZ-PTO: SL

AZ-Swing: Marotz

West Clinic: HR(PM), Singh(PM)

NV: HR BR

WA-overflow: MAL

WA-P: Popli

WA-J: MS

OR: Bekera

OR: Harrington

HI: Canonico

────────────────────────────

West Clinic: HR(PM), Singh(PM) = 1.0

AZ PTO: SL = 1

West PTO: Ji = 1

TOTAL OUT: 3 (15−3=12 on)

TOTAL ON: 12 −0.5 BR −0.75 BM = 10.75

~33 auths/MD (350.0÷10.75)

82 OUT

AZ-AM: MAL DD HR BR SL CS RC MS VS

AZ-PM: MAL DD BR CS RC MS VS

AZ-DoD: MAL

AZ-PTO:

AZ-Swing: Marotz

West Clinic: VS(AM), SL(PM)

NV: HR BR

WA-overflow: MAL

WA-P: Popli

WA-J: DD

OR: Bekera

OR: Harrington

HI: LG (no FTE impact)

────────────────────────────

West Clinic: VS(AM), SL(PM) = 1.0

AZ PTO: 0

West PTO: Ji = 1

TOTAL OUT: 2 (15−2=13 on)

TOTAL ON: 13 −0.5 BR −0.75 BM = 11.75

~30 auths/MD (350.0÷11.75)

Sat 9 / Sun 10

Monday

Tuesday

Wednesday

Thursday

Friday

Wknd/Notes

112 OUT

AZ-AM: MAL DD HR BR SL MS VS

AZ-PM: MAL DD HR SL RC MS VS

AZ-DoD: SL

AZ-PTO:

AZ-Swing: Marotz

West Clinic: RC(AM), BR(PM)

NV: HR BR

WA-overflow: MAL

WA-P: Popli

WA-J: MS

OR: Bekera

OR: Harrington

HI: Canonico

────────────────────────────

West Clinic: RC(AM), BR(PM) = 1.0

AZ PTO: 0

West PTO: Ji = 1

TOTAL OUT: 2 (15−2=13 on)

TOTAL ON: 13 −0.5 BR −0.75 BM = 11.75

~30 auths/MD (350.0÷11.75)

121.5 OUT

AZ-AM: MAL DD HR BR SL RC MS VS

AZ-PM: DD HR BR SL CS RC MS VS

AZ-DoD: DD

AZ-PTO:

AZ-Swing: Marotz

West Clinic: MAL(PM), Bekera(PM)

NV: HR BR

WA-overflow: MAL

WA-P: Popli

WA-J: RC

OR: Bekera

OR: Harrington

HI: Canonico

────────────────────────────

West Clinic: MAL(PM) = 0.5

AZ PTO: 0

West PTO: Ji = 1

TOTAL OUT: 1.5 (15−1.5=13.5 on)

TOTAL ON: 13.5 −0.5 BR −0.75 BM = 12.25

~29 auths/MD (350.0÷12.25)

133.5 OUT

AZ-AM: MAL DD HR BR SL VS

AZ-PM: MAL HR BR SL CS MS VS

AZ-DoD: HR

AZ-PTO: RC

AZ-Swing: Marotz

West Clinic: MS(AM), DD(PM), Popli(PM)

NV: HR BR

WA-overflow: MAL

WA-P: AM Popli/PM MAL

WA-J: SL

OR: Bekera

OR: Harrington

HI: Canonico

────────────────────────────

West Clinic: MS(AM), DD(PM), Popli(PM) = 1.5

AZ PTO: RC = 1

West PTO: Ji = 1

TOTAL OUT: 3.5 (15−3.5=11.5 on)

TOTAL ON: 11.5 −0.5 BR −0.75 BM = 10.25

~34 auths/MD (350.0÷10.25)

142 OUT

AZ-AM: MAL DD HR BR SL CS RC MS VS

AZ-PM: MAL DD BR SL CS RC MS VS

AZ-DoD: RC

AZ-PTO:

AZ-Swing: Marotz

West Clinic: HR(PM), Singh(PM)

NV: HR BR

WA-overflow: MAL

WA-P: Popli

WA-J: DD

OR: Bekera

OR: Harrington

HI: Canonico

────────────────────────────

West Clinic: HR(PM), Singh(PM) = 1.0

AZ PTO: 0

West PTO: Ji = 1

TOTAL OUT: 2 (15−2=13 on)

TOTAL ON: 13 −0.5 BR −0.75 BM = 11.75

~30 auths/MD (350.0÷11.75)

153 OUT

AZ-AM: MAL DD HR BR SL CS MS VS

AZ-PM: MAL DD BR CS MS VS

AZ-DoD: MAL

AZ-PTO: RC

AZ-Swing: Marotz

West Clinic: VS(AM), SL(PM)

NV: HR BR

WA-overflow: MAL

WA-P: Popli

WA-J: MS

OR: Bekera

OR: Harrington

HI: Canonico

────────────────────────────

West Clinic: VS(AM), SL(PM) = 1.0

AZ PTO: RC = 1

West PTO: Ji = 1

TOTAL OUT: 3 (15−3=12 on)

TOTAL ON: 12 −0.5 BR −0.75 BM = 10.75

~33 auths/MD (350.0÷10.75)

Sat 16 / Sun 17

182 OUT

AZ-AM: MAL DD HR BR SL MS VS

AZ-PM: MAL DD HR SL RC MS VS

AZ-DoD: SL

AZ-PTO:

AZ-Swing: Marotz

West Clinic: RC(AM), BR(PM)

NV: HR BR

WA-overflow: MAL

WA-P: Popli

WA-J: SL

OR: Bekera

OR: Harrington

HI: Canonico

────────────────────────────

West Clinic: RC(AM), BR(PM) = 1.0

AZ PTO: 0

West PTO: Ji = 1

TOTAL OUT: 2 (15−2=13 on)

TOTAL ON: 13 −0.5 BR −0.75 BM = 11.75

~30 auths/MD (350.0÷11.75)

191.5 OUT

AZ-AM: MAL DD HR BR SL RC MS VS

AZ-PM: DD HR BR SL CS RC MS VS

AZ-DoD: DD

AZ-PTO:

AZ-Swing: Marotz

West Clinic: MAL(PM), Bekera(PM)

NV: HR BR

WA-overflow: MAL

WA-P: Popli

WA-J: RC

OR: Bekera

OR: Harrington

HI: Canonico

────────────────────────────

West Clinic: MAL(PM) = 0.5

AZ PTO: 0

West PTO: Ji = 1

TOTAL OUT: 1.5 (15−1.5=13.5 on)

TOTAL ON: 13.5 −0.5 BR −0.75 BM = 12.25

~29 auths/MD (350.0÷12.25)

204.5 OUT

AZ-AM: DD HR BR SL VS

AZ-PM: HR BR SL CS MS VS

AZ-DoD: HR

AZ-PTO: RC MAL

AZ-Swing: Marotz

West Clinic: MS(AM), DD(PM), Popli(PM)

NV: HR BR

WA-overflow: ⚠ MAL ON PTO

WA-P: AM Popli/PM [TBD]

WA-J: SL

OR: Bekera

OR: Harrington

HI: Canonico

────────────────────────────

West Clinic: MS(AM), DD(PM), Popli(PM) = 1.5

AZ PTO: RC, MAL = 2

West PTO: Ji = 1

TOTAL OUT: 4.5 (15−4.5=10.5 on)

TOTAL ON: 10.5 −0.5 BR −0.75 BM = 9.25

~38 auths/MD (350.0÷9.25)

215 OUT

AZ-AM: DD HR BR CS MS VS

AZ-PM: DD BR CS MS VS

AZ-DoD: RC

AZ-PTO: SL RC MAL

AZ-Swing: Marotz

West Clinic: HR(PM), Singh(PM)

NV: HR BR

WA-overflow: ⚠ MAL ON PTO

WA-P: Popli

WA-J: DD

OR: Bekera

OR: Harrington

HI: Canonico

────────────────────────────

West Clinic: HR(PM), Singh(PM) = 1.0

AZ PTO: SL, RC, MAL = 3

West PTO: Ji = 1

TOTAL OUT: 5 (15−5=10 on)

TOTAL ON: 10 −0.5 BR −0.75 BM = 8.75

~40 auths/MD (350.0÷8.75)

225 OUT

AZ-AM: HR BR SL CS MS VS

AZ-PM: BR CS MS VS

AZ-DoD: MAL

AZ-PTO: DD RC MAL

AZ-Swing: Marotz

West Clinic: VS(AM), SL(PM)

NV: HR BR

WA-overflow: ⚠ MAL ON PTO

WA-P: Popli

WA-J: MS

OR: Bekera

OR: Harrington

HI: Canonico

────────────────────────────

West Clinic: VS(AM), SL(PM) = 1.0

AZ PTO: DD, RC, MAL = 3

West PTO: Ji = 1

TOTAL OUT: 5 (15−5=10 on)

TOTAL ON: 10 −0.5 BR −0.75 BM = 8.75

~40 auths/MD (350.0÷8.75)

Sat 23 / Sun 24

Monday

Tuesday

Wednesday

Thursday

Friday

Wknd/Notes

Memorial Day
On-call: TBD

263 OUT

AZ-AM: DD HR BR RC MS VS

AZ-PM: DD HR BR CS RC MS VS

AZ-DoD: DD

AZ-PTO: SL MAL

AZ-Swing: Marotz

West Clinic: MAL(PM), Bekera(PM)

NV: HR BR

WA-overflow: ⚠ MAL ON PTO

WA-P: Popli

WA-J: RC

OR: Bekera

OR: Harrington

HI: Canonico

────────────────────────────

West Clinic: 0

AZ PTO: SL, MAL = 2

West PTO: Ji = 1

TOTAL OUT: 3 (15−3=12 on)

TOTAL ON: 12 −0.5 BR −0.75 BM = 10.75

~33 auths/MD (350.0÷10.75)

274.5 OUT

AZ-AM: DD HR BR RC VS

AZ-PM: HR BR CS RC MS VS

AZ-DoD: HR

AZ-PTO: SL MAL

AZ-Swing: Marotz

West Clinic: MS(AM), DD(PM), Popli(PM)

NV: HR BR

WA-overflow: ⚠ MAL ON PTO

WA-P: AM Popli/PM [TBD]

WA-J: RC

OR: Bekera

OR: Harrington

HI: LG (no FTE impact)

────────────────────────────

West Clinic: MS(AM), DD(PM), Popli(PM) = 1.5

AZ PTO: SL, MAL = 2

West PTO: Ji = 1

TOTAL OUT: 4.5 (15−4.5=10.5 on)

TOTAL ON: 10.5 −0.5 BR −0.75 BM = 9.25

~38 auths/MD (350.0÷9.25)

283 OUT

AZ-AM: DD HR BR SL CS RC MS VS

AZ-PM: DD BR SL CS RC MS VS

AZ-DoD: RC

AZ-PTO: MAL

AZ-Swing: Marotz

West Clinic: HR(PM), Singh(PM)

NV: HR BR

WA-overflow: ⚠ MAL ON PTO

WA-P: Popli

WA-J: DD

OR: Bekera

OR: Harrington

HI: Canonico

────────────────────────────

West Clinic: HR(PM), Singh(PM) = 1.0

AZ PTO: MAL = 1

West PTO: Ji = 1

TOTAL OUT: 3 (15−3=12 on)

TOTAL ON: 12 −0.5 BR −0.75 BM = 10.75

~33 auths/MD (350.0÷10.75)

293 OUT

AZ-AM: HR BR SL CS RC MS VS

AZ-PM: BR CS RC MS VS

AZ-DoD: MAL

AZ-PTO: DD MAL

AZ-Swing: Marotz

West Clinic: VS(AM), SL(PM)

NV: HR BR

WA-overflow: ⚠ MAL ON PTO

WA-P: Popli

WA-J: Ji

OR: Bekera

OR: Harrington

HI: Canonico

────────────────────────────

West Clinic: VS(AM), SL(PM) = 1.0

AZ PTO: DD, MAL = 2

West PTO: 0

TOTAL OUT: 3 (15−3=12 on)

TOTAL ON: 12 −0.5 BR −0.75 BM = 10.75

~33 auths/MD (350.0÷10.75)

Sat 30 / Sun 31

Projected Auths per MD — Headcount Model

Team = 15 docs | Avg Daily Auths = 350.0 (7,700 ÷ 22)

BR counts 0.5 FTE when on (adj −0.50). BM/Marotz counts 0.25 FTE when on (adj −0.75).
All others count as 1.0 FTE when on.
Effective baseline FTE = 15 − 0.50 (BR) − 0.75 (BM) = 13.75

Provider Reference

Init

Provider

FTE When On

Role

MAL

Lecavalier

1.0

AZ UM + WA overflow

DD

Dunnigan

1.0

AZ UM

HR

H. Roemer

1.0

AZ UM + NV

BR

B. Roemer

0.5

AZ UM (half) + NV

SL

Lewis

1.0

AZ UM

CS

Sterling

1.0

AZ UM

RC

Carranza

1.0

AZ UM

MS

Salah

1.0

AZ UM

VS

Shah

1.0

AZ UM

BM

Marotz

0.25

AZ Swing

Ji

Ji

1.0

WA-J

Popli

Popli

1.0

WA-P

Bekera

Bekera

1.0

OR

MH

Harrington

1.0

OR

Canonico

Canonico

1.0

HI

Auths per MD — Docs Out vs Workload (350.0/day)

Assumes BR + BM both on. Adjusted ON = (15 − out) − 0.50 (BR) − 0.75 (BM)

Docs Out

Raw On (15−out)

Adj (−0.5 BR −0.75 BM)

Avg Auths/Day

Auths/MD (avg÷adj)

Increase

Tier

0 (baseline)

15

13.75

350.0

25.5 (350.0÷13.75)

—

🟢 Green

1

14

12.75

350.0

27.5 (350.0÷12.75)

+2.0

🟢 Green

2

13

11.75

350.0

29.8 (350.0÷11.75)

+4.3

🟢 Green

3

12

10.75

350.0

32.6 (350.0÷10.75)

+7.1

🟢 Green

Docs Out

Raw On (15−out)

Adj (−0.5 BR −0.75 BM)

Avg Auths/Day

Auths/MD (avg÷adj)

Increase

Tier

4

11

9.75

350.0

35.9 (350.0÷9.75)

+10.4

🟢 Green

5

10

8.75

350.0

40.0 (350.0÷8.75)

+14.5

🟡 Yellow

Individual Provider Off — Impact

Provider Off

Docs Out

Raw On

Adj ON

Auths/Day

Auths/MD

Increase

Any 1.0 FTE doc

1

14

12.75

350.0

27.5 (350.0÷12.75)

+2.0

BR (0.5 FTE)

1

14

13.25

350.0

26.4 (350.0÷13.25)

+1.0

BM/Marotz (0.25 FTE)

1

14

13.50

350.0

25.9 (350.0÷13.50)

+0.5

Calculation Rules for Daily Auths/MD

Team: 15 docs | Avg Daily Auths: 350.0 (7,700 ÷ 22)
Effective FTE: 15 − 0.50 (BR) − 0.75 (BM) = 13.75

Core Formula

• TOTAL OUT = West Clinic (excl Bekera) + AZ PTO headcount + West PTO headcount

• TOTAL ON (raw) = 15 − TOTAL OUT

• TOTAL ON (adjusted) = raw − 0.50 (if BR on) − 0.75 (if BM on)

• Auths/MD = Avg Daily Auths ÷ TOTAL ON (adjusted)

• BR counts as 0.5 FTE when on for the day (adjustment = −0.50)

• BM/Marotz counts as 0.25 FTE when on for the day (adjustment = −0.75)

• All other docs count as 1.0 FTE when on

• If BR is OFF (PTO), the −0.50 adjustment does NOT apply (already subtracted as 1 out)

• If BM is OFF (PTO), the −0.75 adjustment does NOT apply (already subtracted as 1 out)

• WA-P Wed rule: Template is AM Popli/PM MAL. If MAL is on PTO, PM MAL → PM [sub].

The PM substitution does NOT add to TOTAL OUT — MAL is already counted as 1 out via AZ PTO.

Use WAP_OVERRIDES to specify who covers PM (e.g. PM MS). Otherwise shows PM [TBD].

Worked Example — Monday (baseline, no PTO)

Step

Calculation

West Clinic

RC(AM) + BR(PM) = 1.0 (Bekera excluded)

AZ PTO

0 (nobody on PTO)

West PTO

0 (no west doc absences)

TOTAL OUT

1.0 + 0 + 0 = 1.0

Raw ON

15 − 1.0 = 14

Adj ON

14 − 0.50 (BR) − 0.75 (BM) = 12.75

Auths/MD

350.0 ÷ 12.75 = 27.5

TOTAL OUT Components

Component

What Counts

Rule

West Clinic

Half-day clinic sessions
(excl. Bekera — outside pool)

Each session = 0.5 out

AZ PTO

Providers on PTO

Each person = 1 out (headcount)

West PTO

West docs absent
(Ji, Popli, Bekera, Harrington, Canonico)

Each absent = 1 out

Bekera Clinic Exclusion

Bekera clinic (Tue PM) is excluded from West Clinic count — covered by outside pool.
All other clinic sessions (RC, BR, MS, DD, HR, Singh, SL, MAL, Popli) count as 0.5 out each.

Tier Thresholds (Auths/MD)

Range

Tier

Color

<40

Green

🟢

40–43

Yellow

🟡

44–47

Orange

🟠

48–52

Red

🔴

53+

Red+

🔴

of 7

The May 2026 Shift Calendar has been generated with all PTO and coverage populated . Here's a summary of what was entered:

PTO Populated

ProviderDays Out
Dr. Susan Lewis (SL)May 7, 21, 26, 27 (CME 5/23–27, workdays = 26–27)
Dr. Racquel Carranza (RC)May 13, 15, 20, 21, 22
Dr. MaryAnn Lecavalier (MAL)May 20, 21, 22, 26, 27, 28, 29 (5/20–6/4)
Dr. Dunnigan (DD)May 22, 29

HI Coverage (Canonico Out)

  • May 1, 8, 27 → L. Gallagher (LG) covers (no FTE impact)cal_gen-9.txt

WA-J Coverage (Ji Out All Month)

Coverage rotates among DD, SL, RC, and MS across all 20 workdays.cal_gen-9.txt

Holidays

  • May 25 (Monday) — Memorial Day (on-call: TBD)

Run Stats

  • 350.0 auths/day (7,700 ÷ 22 April workdays)

  • 20 workdays in May (excluding Memorial Day)

  • 31 yellow highlights flagging deviations from the core staffing template

  • Late May (5/20–5/29) will be the heaviest stretch with MAL, RC, SL, and DD overlapping PTO

Let me know if you need to add weekend call assignments, adjust any coverage, or tweak anything else.

Prepared using Claude Opus 4.6 Thinking
sub doc cannot be on clinic

Good catch — adding the clinic constraint changes things significantly. Here's the revised analysis:

Revised DoD Conflicts

DateDOWTemplate DoDExclusionsProposed Sub
May 21ThuRC (PTO)SL: PTO, MAL: PTO, DD: WA-J, HR: ClinicNo core roster candidate
May 22FriMAL (PTO)DD: PTO, RC: PTO, SL: Clinic, MS: WA-JHR
May 29FriMAL (PTO)DD: PTO, SL: ClinicRC (lowest count)

May 21 Problem

May 21 (Thursday) is fully blocked across the core DoD roster — all 5 regular DoD providers are excluded by PTO, WA-J coverage, or clinic. The available expanded pool candidates are:

  • CS — available

  • MS — available

  • VS — available

Final Proposed Overrides

DateChangeNotes
May 21 (Thu)RC → CS, MS, or VSYour pick — all three are available
May 22 (Fri)MAL → HROnly core roster option
May 29 (Fri)MAL → RCLoad-balanced pick

Resulting DoD Distribution

ProviderBaselineFinalΔ
SL33—
DD44—
HR45+1
RC44—
MAL53−2

Which provider would you like for the May 21 DoD — CS, MS, or VS?

Prepared using Claude Opus 4.6 Thinking
use MS for 21 and 29 HR for other
May_2026_Shift_Calendar

May 2026 — AZ PA Shift Assignment Calendar

Team: 15 docs (HR, BR, MAL, DD, RC, SL, MS, BM, CS, VS, Popli, Ji, Bekera, Harrington, Canonico)
Effective FTE: 15 − 0.5 (BR half) − 0.75 (BM quarter) = 13.75 FTE
BR counts 0.5 FTE when on (adj −0.5). BM/Marotz counts 0.25 FTE when on (adj −0.75). All others = 1.0 FTE.
LG = external HI (no FTE impact). Bekera clinic (Tue PM) excluded from clinic count.
Avg Daily Auths: 350.0/day (7,700 ÷ 22)

Monday

Tuesday

Wednesday

Thursday

Friday

Wknd/Notes

12 OUT

AZ-AM: MAL DD HR BR SL CS RC MS

AZ-PM: MAL DD BR CS RC MS VS

AZ-DoD: MAL

AZ-PTO:

AZ-Swing: Marotz

West Clinic: VS(AM), SL(PM)

NV: HR BR

WA-overflow: MAL

WA-P: Popli

WA-J: DD

OR: Bekera

OR: Harrington

HI: LG (no FTE impact)

────────────────────────────

West Clinic: VS(AM), SL(PM) = 1.0

AZ PTO: 0

West PTO: Ji = 1

TOTAL OUT: 2 (15−2=13 on)

TOTAL ON: 13 −0.5 BR −0.75 BM = 11.75

~30 auths/MD (350.0÷11.75)

Sat 2 / Sun 3

CALL:

Sat 2: DD

Sun 3: DD

42 OUT

AZ-AM: MAL DD HR BR SL MS VS

AZ-PM: MAL DD HR SL RC MS VS

AZ-DoD: SL

AZ-PTO:

AZ-Swing: Marotz

West Clinic: RC(AM), BR(PM)

NV: HR BR

WA-overflow: MAL

WA-P: Popli

WA-J: SL

OR: Bekera

OR: Harrington

HI: Canonico

────────────────────────────

West Clinic: RC(AM), BR(PM) = 1.0

AZ PTO: 0

West PTO: Ji = 1

TOTAL OUT: 2 (15−2=13 on)

TOTAL ON: 13 −0.5 BR −0.75 BM = 11.75

~30 auths/MD (350.0÷11.75)

51.5 OUT

AZ-AM: MAL DD HR BR SL RC MS VS

AZ-PM: DD HR BR SL CS RC MS VS

AZ-DoD: DD

AZ-PTO:

AZ-Swing: Marotz

West Clinic: MAL(PM), Bekera(PM)

NV: HR BR

WA-overflow: MAL

WA-P: Popli

WA-J: RC

OR: Bekera

OR: Harrington

HI: Canonico

────────────────────────────

West Clinic: MAL(PM) = 0.5

AZ PTO: 0

West PTO: Ji = 1

TOTAL OUT: 1.5 (15−1.5=13.5 on)

TOTAL ON: 13.5 −0.5 BR −0.75 BM = 12.25

~29 auths/MD (350.0÷12.25)

62.5 OUT

AZ-AM: MAL DD HR BR SL RC VS

AZ-PM: MAL HR BR SL CS RC MS VS

AZ-DoD: HR

AZ-PTO:

AZ-Swing: Marotz

West Clinic: MS(AM), DD(PM), Popli(PM)

NV: HR BR

WA-overflow: MAL

WA-P: AM Popli/PM MAL

WA-J: SL

OR: Bekera

OR: Harrington

HI: Canonico

────────────────────────────

West Clinic: MS(AM), DD(PM), Popli(PM) = 1.5

AZ PTO: 0

West PTO: Ji = 1

TOTAL OUT: 2.5 (15−2.5=12.5 on)

TOTAL ON: 12.5 −0.5 BR −0.75 BM = 11.25

~31 auths/MD (350.0÷11.25)

73 OUT

AZ-AM: MAL DD HR BR CS RC MS VS

AZ-PM: MAL DD BR CS RC MS VS

AZ-DoD: RC

AZ-PTO: SL

AZ-Swing: Marotz

West Clinic: HR(PM), Singh(PM)

NV: HR BR

WA-overflow: MAL

WA-P: Popli

WA-J: MS

OR: Bekera

OR: Harrington

HI: Canonico

────────────────────────────

West Clinic: HR(PM), Singh(PM) = 1.0

AZ PTO: SL = 1

West PTO: Ji = 1

TOTAL OUT: 3 (15−3=12 on)

TOTAL ON: 12 −0.5 BR −0.75 BM = 10.75

~33 auths/MD (350.0÷10.75)

82 OUT

AZ-AM: MAL DD HR BR SL CS RC MS

AZ-PM: MAL DD BR CS RC MS VS

AZ-DoD: MAL

AZ-PTO:

AZ-Swing: Marotz

West Clinic: VS(AM), SL(PM)

NV: HR BR

WA-overflow: MAL

WA-P: Popli

WA-J: DD

OR: Bekera

OR: Harrington

HI: LG (no FTE impact)

────────────────────────────

West Clinic: VS(AM), SL(PM) = 1.0

AZ PTO: 0

West PTO: Ji = 1

TOTAL OUT: 2 (15−2=13 on)

TOTAL ON: 13 −0.5 BR −0.75 BM = 11.75

~30 auths/MD (350.0÷11.75)

Sat 9 / Sun 10

CALL:

Sat 9: HR

Sun 10: HR

Monday

Tuesday

Wednesday

Thursday

Friday

Wknd/Notes

112 OUT

AZ-AM: MAL DD HR BR SL MS VS

AZ-PM: MAL DD HR SL RC MS VS

AZ-DoD: SL

AZ-PTO:

AZ-Swing: Marotz

West Clinic: RC(AM), BR(PM)

NV: HR BR

WA-overflow: MAL

WA-P: Popli

WA-J: MS

OR: Bekera

OR: Harrington

HI: Canonico

────────────────────────────

West Clinic: RC(AM), BR(PM) = 1.0

AZ PTO: 0

West PTO: Ji = 1

TOTAL OUT: 2 (15−2=13 on)

TOTAL ON: 13 −0.5 BR −0.75 BM = 11.75

~30 auths/MD (350.0÷11.75)

121.5 OUT

AZ-AM: MAL DD HR BR SL RC MS VS

AZ-PM: DD HR BR SL CS RC MS VS

AZ-DoD: DD

AZ-PTO:

AZ-Swing: Marotz

West Clinic: MAL(PM), Bekera(PM)

NV: HR BR

WA-overflow: MAL

WA-P: Popli

WA-J: RC

OR: Bekera

OR: Harrington

HI: Canonico

────────────────────────────

West Clinic: MAL(PM) = 0.5

AZ PTO: 0

West PTO: Ji = 1

TOTAL OUT: 1.5 (15−1.5=13.5 on)

TOTAL ON: 13.5 −0.5 BR −0.75 BM = 12.25

~29 auths/MD (350.0÷12.25)

133.5 OUT

AZ-AM: MAL DD HR BR SL VS

AZ-PM: MAL HR BR SL CS MS VS

AZ-DoD: HR

AZ-PTO: RC

AZ-Swing: Marotz

West Clinic: MS(AM), DD(PM), Popli(PM)

NV: HR BR

WA-overflow: MAL

WA-P: AM Popli/PM MAL

WA-J: SL

OR: Bekera

OR: Harrington

HI: Canonico

────────────────────────────

West Clinic: MS(AM), DD(PM), Popli(PM) = 1.5

AZ PTO: RC = 1

West PTO: Ji = 1

TOTAL OUT: 3.5 (15−3.5=11.5 on)

TOTAL ON: 11.5 −0.5 BR −0.75 BM = 10.25

~34 auths/MD (350.0÷10.25)

142 OUT

AZ-AM: MAL DD HR BR SL CS RC MS VS

AZ-PM: MAL DD BR SL CS RC MS VS

AZ-DoD: RC

AZ-PTO:

AZ-Swing: Marotz

West Clinic: HR(PM), Singh(PM)

NV: HR BR

WA-overflow: MAL

WA-P: Popli

WA-J: DD

OR: Bekera

OR: Harrington

HI: Canonico

────────────────────────────

West Clinic: HR(PM), Singh(PM) = 1.0

AZ PTO: 0

West PTO: Ji = 1

TOTAL OUT: 2 (15−2=13 on)

TOTAL ON: 13 −0.5 BR −0.75 BM = 11.75

~30 auths/MD (350.0÷11.75)

153 OUT

AZ-AM: MAL DD HR BR SL CS MS

AZ-PM: MAL DD BR CS MS VS

AZ-DoD: MAL

AZ-PTO: RC

AZ-Swing: Marotz

West Clinic: VS(AM), SL(PM)

NV: HR BR

WA-overflow: MAL

WA-P: Popli

WA-J: MS

OR: Bekera

OR: Harrington

HI: Canonico

────────────────────────────

West Clinic: VS(AM), SL(PM) = 1.0

AZ PTO: RC = 1

West PTO: Ji = 1

TOTAL OUT: 3 (15−3=12 on)

TOTAL ON: 12 −0.5 BR −0.75 BM = 10.75

~33 auths/MD (350.0÷10.75)

Sat 16 / Sun 17

CALL:

Sat 16: MAL

Sun 17: MAL

182 OUT

AZ-AM: MAL DD HR BR SL MS VS

AZ-PM: MAL DD HR SL RC MS VS

AZ-DoD: SL

AZ-PTO:

AZ-Swing: Marotz

West Clinic: RC(AM), BR(PM)

NV: HR BR

WA-overflow: MAL

WA-P: Popli

WA-J: SL

OR: Bekera

OR: Harrington

HI: Canonico

────────────────────────────

West Clinic: RC(AM), BR(PM) = 1.0

AZ PTO: 0

West PTO: Ji = 1

TOTAL OUT: 2 (15−2=13 on)

TOTAL ON: 13 −0.5 BR −0.75 BM = 11.75

~30 auths/MD (350.0÷11.75)

191.5 OUT

AZ-AM: MAL DD HR BR SL RC MS VS

AZ-PM: DD HR BR SL CS RC MS VS

AZ-DoD: DD

AZ-PTO:

AZ-Swing: Marotz

West Clinic: MAL(PM), Bekera(PM)

NV: HR BR

WA-overflow: MAL

WA-P: Popli

WA-J: RC

OR: Bekera

OR: Harrington

HI: Canonico

────────────────────────────

West Clinic: MAL(PM) = 0.5

AZ PTO: 0

West PTO: Ji = 1

TOTAL OUT: 1.5 (15−1.5=13.5 on)

TOTAL ON: 13.5 −0.5 BR −0.75 BM = 12.25

~29 auths/MD (350.0÷12.25)

204.5 OUT

AZ-AM: DD HR BR SL VS

AZ-PM: HR BR SL CS MS VS

AZ-DoD: HR

AZ-PTO: RC MAL

AZ-Swing: Marotz

West Clinic: MS(AM), DD(PM), Popli(PM)

NV: HR BR

WA-overflow: ⚠ MAL ON PTO

WA-P: AM Popli/PM [TBD]

WA-J: SL

OR: Bekera

OR: Harrington

HI: Canonico

────────────────────────────

West Clinic: MS(AM), DD(PM), Popli(PM) = 1.5

AZ PTO: RC, MAL = 2

West PTO: Ji = 1

TOTAL OUT: 4.5 (15−4.5=10.5 on)

TOTAL ON: 10.5 −0.5 BR −0.75 BM = 9.25

~38 auths/MD (350.0÷9.25)

215 OUT

AZ-AM: DD HR BR CS MS VS

AZ-PM: DD BR CS MS VS

AZ-DoD: MS

AZ-PTO: SL RC MAL

AZ-Swing: Marotz

West Clinic: HR(PM), Singh(PM)

NV: HR BR

WA-overflow: ⚠ MAL ON PTO

WA-P: Popli

WA-J: DD

OR: Bekera

OR: Harrington

HI: Canonico

────────────────────────────

West Clinic: HR(PM), Singh(PM) = 1.0

AZ PTO: SL, RC, MAL = 3

West PTO: Ji = 1

TOTAL OUT: 5 (15−5=10 on)

TOTAL ON: 10 −0.5 BR −0.75 BM = 8.75

~40 auths/MD (350.0÷8.75)

225 OUT

AZ-AM: HR BR SL CS MS

AZ-PM: BR CS MS VS

AZ-DoD: HR

AZ-PTO: DD RC MAL

AZ-Swing: Marotz

West Clinic: VS(AM), SL(PM)

NV: HR BR

WA-overflow: ⚠ MAL ON PTO

WA-P: Popli

WA-J: MS

OR: Bekera

OR: Harrington

HI: Canonico

────────────────────────────

West Clinic: VS(AM), SL(PM) = 1.0

AZ PTO: DD, RC, MAL = 3

West PTO: Ji = 1

TOTAL OUT: 5 (15−5=10 on)

TOTAL ON: 10 −0.5 BR −0.75 BM = 8.75

~40 auths/MD (350.0÷8.75)

Sat 23 / Sun 24

CALL:

Sat 23: RC

Sun 24: RC

Memorial Day 25: RC

Monday

Tuesday

Wednesday

Thursday

Friday

Wknd/Notes

Memorial Day
On-call: RC

263 OUT

AZ-AM: DD HR BR RC MS VS

AZ-PM: DD HR BR CS RC MS VS

AZ-DoD: DD

AZ-PTO: SL MAL

AZ-Swing: Marotz

West Clinic: MAL(PM), Bekera(PM)

NV: HR BR

WA-overflow: ⚠ MAL ON PTO

WA-P: Popli

WA-J: RC

OR: Bekera

OR: Harrington

HI: Canonico

────────────────────────────

West Clinic: 0

AZ PTO: SL, MAL = 2

West PTO: Ji = 1

TOTAL OUT: 3 (15−3=12 on)

TOTAL ON: 12 −0.5 BR −0.75 BM = 10.75

~33 auths/MD (350.0÷10.75)

274.5 OUT

AZ-AM: DD HR BR RC VS

AZ-PM: HR BR CS RC MS VS

AZ-DoD: HR

AZ-PTO: SL MAL

AZ-Swing: Marotz

West Clinic: MS(AM), DD(PM), Popli(PM)

NV: HR BR

WA-overflow: ⚠ MAL ON PTO

WA-P: AM Popli/PM [TBD]

WA-J: RC

OR: Bekera

OR: Harrington

HI: LG (no FTE impact)

────────────────────────────

West Clinic: MS(AM), DD(PM), Popli(PM) = 1.5

AZ PTO: SL, MAL = 2

West PTO: Ji = 1

TOTAL OUT: 4.5 (15−4.5=10.5 on)

TOTAL ON: 10.5 −0.5 BR −0.75 BM = 9.25

~38 auths/MD (350.0÷9.25)

283 OUT

AZ-AM: DD HR BR SL CS RC MS VS

AZ-PM: DD BR SL CS RC MS VS

AZ-DoD: RC

AZ-PTO: MAL

AZ-Swing: Marotz

West Clinic: HR(PM), Singh(PM)

NV: HR BR

WA-overflow: ⚠ MAL ON PTO

WA-P: Popli

WA-J: DD

OR: Bekera

OR: Harrington

HI: Canonico

────────────────────────────

West Clinic: HR(PM), Singh(PM) = 1.0

AZ PTO: MAL = 1

West PTO: Ji = 1

TOTAL OUT: 3 (15−3=12 on)

TOTAL ON: 12 −0.5 BR −0.75 BM = 10.75

~33 auths/MD (350.0÷10.75)

293 OUT

AZ-AM: HR BR SL CS RC MS

AZ-PM: BR CS RC MS VS

AZ-DoD: MS

AZ-PTO: DD MAL

AZ-Swing: Marotz

West Clinic: VS(AM), SL(PM)

NV: HR BR

WA-overflow: ⚠ MAL ON PTO

WA-P: Popli

WA-J: Ji

OR: Bekera

OR: Harrington

HI: Canonico

────────────────────────────

West Clinic: VS(AM), SL(PM) = 1.0

AZ PTO: DD, MAL = 2

West PTO: 0

TOTAL OUT: 3 (15−3=12 on)

TOTAL ON: 12 −0.5 BR −0.75 BM = 10.75

~33 auths/MD (350.0÷10.75)

Sat 30 / Sun 31

CALL:

Sat 30: CY

Sun 31: CY

Projected Auths per MD — Headcount Model

Team = 15 docs | Avg Daily Auths = 350.0 (7,700 ÷ 22)

BR counts 0.5 FTE when on (adj −0.50). BM/Marotz counts 0.25 FTE when on (adj −0.75).
All others count as 1.0 FTE when on.
Effective baseline FTE = 15 − 0.50 (BR) − 0.75 (BM) = 13.75

Provider Reference

Init

Provider

FTE When On

Role

MAL

Lecavalier

1.0

AZ UM + WA overflow

DD

Dunnigan

1.0

AZ UM

HR

H. Roemer

1.0

AZ UM + NV

BR

B. Roemer

0.5

AZ UM (half) + NV

SL

Lewis

1.0

AZ UM

CS

Sterling

1.0

AZ UM

RC

Carranza

1.0

AZ UM

MS

Salah

1.0

AZ UM

VS

Shah

1.0

AZ UM

BM

Marotz

0.25

AZ Swing

Ji

Ji

1.0

WA-J

Popli

Popli

1.0

WA-P

Bekera

Bekera

1.0

OR

MH

Harrington

1.0

OR

Canonico

Canonico

1.0

HI

Auths per MD — Docs Out vs Workload (350.0/day)

Assumes BR + BM both on. Adjusted ON = (15 − out) − 0.50 (BR) − 0.75 (BM)

Docs Out

Raw On (15−out)

Adj (−0.5 BR −0.75 BM)

Avg Auths/Day

Auths/MD (avg÷adj)

Increase

Tier

0 (baseline)

15

13.75

350.0

25.5 (350.0÷13.75)

—

🟢 Green

1

14

12.75

350.0

27.5 (350.0÷12.75)

+2.0

🟢 Green

2

13

11.75

350.0

29.8 (350.0÷11.75)

+4.3

🟢 Green

3

12

10.75

350.0

32.6 (350.0÷10.75)

+7.1

🟢 Green

Docs Out

Raw On (15−out)

Adj (−0.5 BR −0.75 BM)

Avg Auths/Day

Auths/MD (avg÷adj)

Increase

Tier

4

11

9.75

350.0

35.9 (350.0÷9.75)

+10.4

🟢 Green

5

10

8.75

350.0

40.0 (350.0÷8.75)

+14.5

🟡 Yellow

Individual Provider Off — Impact

Provider Off

Docs Out

Raw On

Adj ON

Auths/Day

Auths/MD

Increase

Any 1.0 FTE doc

1

14

12.75

350.0

27.5 (350.0÷12.75)

+2.0

BR (0.5 FTE)

1

14

13.25

350.0

26.4 (350.0÷13.25)

+1.0

BM/Marotz (0.25 FTE)

1

14

13.50

350.0

25.9 (350.0÷13.50)

+0.5

Calculation Rules for Daily Auths/MD

Team: 15 docs | Avg Daily Auths: 350.0 (7,700 ÷ 22)
Effective FTE: 15 − 0.50 (BR) − 0.75 (BM) = 13.75

Core Formula

• TOTAL OUT = West Clinic (excl Bekera) + AZ PTO headcount + West PTO headcount

• TOTAL ON (raw) = 15 − TOTAL OUT

• TOTAL ON (adjusted) = raw − 0.50 (if BR on) − 0.75 (if BM on)

• Auths/MD = Avg Daily Auths ÷ TOTAL ON (adjusted)

• BR counts as 0.5 FTE when on for the day (adjustment = −0.50)

• BM/Marotz counts as 0.25 FTE when on for the day (adjustment = −0.75)

• All other docs count as 1.0 FTE when on

• If BR is OFF (PTO), the −0.50 adjustment does NOT apply (already subtracted as 1 out)

• If BM is OFF (PTO), the −0.75 adjustment does NOT apply (already subtracted as 1 out)

• WA-P Wed rule: Template is AM Popli/PM MAL. If MAL is on PTO, PM MAL → PM [sub].

The PM substitution does NOT add to TOTAL OUT — MAL is already counted as 1 out via AZ PTO.

Use WAP_OVERRIDES to specify who covers PM (e.g. PM MS). Otherwise shows PM [TBD].

Worked Example — Monday (baseline, no PTO)

Step

Calculation

West Clinic

RC(AM) + BR(PM) = 1.0 (Bekera excluded)

AZ PTO

0 (nobody on PTO)

West PTO

0 (no west doc absences)

TOTAL OUT

1.0 + 0 + 0 = 1.0

Raw ON

15 − 1.0 = 14

Adj ON

14 − 0.50 (BR) − 0.75 (BM) = 12.75

Auths/MD

350.0 ÷ 12.75 = 27.5

TOTAL OUT Components

Component

What Counts

Rule

West Clinic

Half-day clinic sessions
(excl. Bekera — outside pool)

Each session = 0.5 out

AZ PTO

Providers on PTO

Each person = 1 out (headcount)

West PTO

West docs absent
(Ji, Popli, Bekera, Harrington, Canonico)

Each absent = 1 out

Bekera Clinic Exclusion

Bekera clinic (Tue PM) is excluded from West Clinic count — covered by outside pool.
All other clinic sessions (RC, BR, MS, DD, HR, Singh, SL, MAL, Popli) count as 0.5 out each.

Tier Thresholds (Auths/MD)

Range

Tier

Color

<40

Green

🟢

40–43

Yellow

🟡

44–47

Orange

🟠

48–52

Red

🔴

53+

Red+

🔴

of 7

Calendar regenerated with the DoD overrides applied :

DateDOWTemplate DoDOverride
May 21ThuRC (PTO)MS
May 22FriMAL (PTO)HR
May 29FriMAL (PTO)MS

All three overrides are now yellow-highlighted in the calendar (34 total highlights, up from 31). No conflicts with PTO, WA-J coverage, or clinic assignments. Let me know if anything else needs adjusting.

Prepared using Claude Opus 4.6 Thinking
screen for any conflicts with PTO-doc needs to be not assigned to any shift. and for clinic-cannot be on for shfit am/pm or covering

All screens pass clean. Here's the full conflict report:

PTO Conflicts

  • AM/PM Shifts: ✅ No real conflicts — the script already strips PTO docs from the rendered shift roster each day (names = [n for n in roster.split() if n not in pto]), so even though the template lists them, the output correctly removes them.cal_gen-9.txt

  • DoD vs PTO: ✅ Clear — the 3 overrides we applied (May 21 → MS, May 22 → HR, May 29 → MS) resolve all DoD/PTO conflicts.

  • WA-J Coverage vs PTO: ✅ Clear — no WA-J cover person is on PTO the same day.

Clinic Conflicts

  • Same-session shift: ✅ No clinic doc appears on the shift roster during their clinic session.

  • DoD during clinic: ✅ No DoD-assigned doc has a clinic that day.

  • WA-J coverage during clinic: ✅ No WA-J cover person has clinic that day.

Everything checks out — no actionable conflicts remain in the May calendar. The current build is clean.

Prepared using Claude Opus 4.6 Thinking
convert to html so i can post on web
May_2026_Shift_Calendar

Here's your May 2026 Shift Calendar converted to HTML . It includes everything from the DOCX version:

  • Full shift rosters (AM/PM/DoD) with PTO docs automatically removed

  • Yellow highlights on all overrides (DoD subs, WA-J coverage, HI coverage, MAL PTO overflow warnings)

  • Below-the-line metrics for each day — West Clinic, AZ PTO, West PTO, TOTAL OUT/ON, and auths/MD with color-coded tier badges (Green/Yellow/Orange/Red)

  • Weekend/Call column showing on-call assignments including Memorial Day

  • Print-friendly — set to landscape with clean margins via @media print

You can open it directly in a browser or post it to your internal site. Let me know if you want any styling tweaks or additional content like the reference tables.

Prepared using Claude Opus 4.6 Thinking
file needs to look same as to right: sava again
May_2026_Shift_Calendar

May 2026 — AZ PA Shift Assignment Calendar

Team:
15 docs (HR, BR, MAL, DD, RC, SL, MS, BM, CS, VS, Popli, Ji, Bekera, Harrington, Canonico)
Effective FTE:
15 − 0.5 (BR half) − 0.75 (BM quarter) = 13.75 FTE
BR counts 0.5 FTE when on (adj −0.5). BM/Marotz counts 0.25 FTE when on (adj −0.75). All others = 1.0 FTE.
LG = external HI (no FTE impact). Bekera clinic (Tue PM) excluded from clinic count.
Avg Daily Auths:
350.0/day (7,700 ÷ 22)

Monday

Tuesday

Wednesday

Thursday

Friday

Wknd / Call

1 2 OUT

AZ-AM: MAL DD HR BR SL CS RC MS

AZ-PM: MAL DD BR CS RC MS VS

AZ-DoD: MAL

AZ-PTO:

AZ-Swing: Marotz

West Clinic: VS(AM), SL(PM)

NV: HR BR

WA-overflow: MAL

WA-P: Popli

WA-J: DD

OR: Bekera

OR: Harrington

HI: LG (no FTE impact)

 

West Clinic: VS(AM), SL(PM) = 1.0

AZ PTO: 0

West PTO: Ji = 1

TOTAL OUT: 2(15−2=13 on)

TOTAL ON: 13 −0.5 BR −0.75 BM = 11.75

~30 auths/MD (350.0÷11.75)

Sat 2
Sun 3

CALL:

Sat 2: DD

Sun 3: DD

4 2 OUT

AZ-AM: MAL DD HR BR SL MS VS

AZ-PM: MAL DD HR SL RC MS VS

AZ-DoD: SL

AZ-PTO:

AZ-Swing: Marotz

West Clinic: RC(AM), BR(PM)

NV: HR BR

WA-overflow: MAL

WA-P: Popli

WA-J: SL

OR: Bekera

OR: Harrington

HI: Canonico

 

West Clinic: RC(AM), BR(PM) = 1.0

AZ PTO: 0

West PTO: Ji = 1

TOTAL OUT: 2(15−2=13 on)

TOTAL ON: 13 −0.5 BR −0.75 BM = 11.75

~30 auths/MD (350.0÷11.75)

5 1.5 OUT

AZ-AM: MAL DD HR BR SL RC MS VS

AZ-PM: DD HR BR SL CS RC MS VS

AZ-DoD: DD

AZ-PTO:

AZ-Swing: Marotz

West Clinic: MAL(PM), Bekera(PM)

NV: HR BR

WA-overflow: MAL

WA-P: Popli

WA-J: RC

OR: Bekera

OR: Harrington

HI: Canonico

 

West Clinic: MAL(PM) = 0.5

AZ PTO: 0

West PTO: Ji = 1

TOTAL OUT: 1.5(15−1.5=13.5 on)

TOTAL ON: 13.5 −0.5 BR −0.75 BM = 12.25

~29 auths/MD (350.0÷12.25)

6 2.5 OUT

AZ-AM: MAL DD HR BR SL RC VS

AZ-PM: MAL HR BR SL CS RC MS VS

AZ-DoD: HR

AZ-PTO:

AZ-Swing: Marotz

West Clinic: MS(AM), DD(PM), Popli(PM)

NV: HR BR

WA-overflow: MAL

WA-P: AM Popli/PM MAL

WA-J: SL

OR: Bekera

OR: Harrington

HI: Canonico

 

West Clinic: MS(AM), DD(PM), Popli(PM) = 1.5

AZ PTO: 0

West PTO: Ji = 1

TOTAL OUT: 2.5(15−2.5=12.5 on)

TOTAL ON: 12.5 −0.5 BR −0.75 BM = 11.25

~31 auths/MD (350.0÷11.25)

7 3 OUT

AZ-AM: MAL DD HR BR CS RC MS VS

AZ-PM: MAL DD BR CS RC MS VS

AZ-DoD: RC

AZ-PTO: SL

AZ-Swing: Marotz

West Clinic: HR(PM), Singh(PM)

NV: HR BR

WA-overflow: MAL

WA-P: Popli

WA-J: MS

OR: Bekera

OR: Harrington

HI: Canonico

 

West Clinic: HR(PM), Singh(PM) = 1.0

AZ PTO: SL = 1

West PTO: Ji = 1

TOTAL OUT: 3(15−3=12 on)

TOTAL ON: 12 −0.5 BR −0.75 BM = 10.75

~33 auths/MD (350.0÷10.75)

8 2 OUT

AZ-AM: MAL DD HR BR SL CS RC MS

AZ-PM: MAL DD BR CS RC MS VS

AZ-DoD: MAL

AZ-PTO:

AZ-Swing: Marotz

West Clinic: VS(AM), SL(PM)

NV: HR BR

WA-overflow: MAL

WA-P: Popli

WA-J: DD

OR: Bekera

OR: Harrington

HI: LG (no FTE impact)

 

West Clinic: VS(AM), SL(PM) = 1.0

AZ PTO: 0

West PTO: Ji = 1

TOTAL OUT: 2(15−2=13 on)

TOTAL ON: 13 −0.5 BR −0.75 BM = 11.75

~30 auths/MD (350.0÷11.75)

Sat 9
Sun 10

CALL:

Sat 9: HR

Sun 10: HR

Monday

Tuesday

Wednesday

Thursday

Friday

Wknd / Call

11 2 OUT

AZ-AM: MAL DD HR BR SL MS VS

AZ-PM: MAL DD HR SL RC MS VS

AZ-DoD: SL

AZ-PTO:

AZ-Swing: Marotz

West Clinic: RC(AM), BR(PM)

NV: HR BR

WA-overflow: MAL

WA-P: Popli

WA-J: MS

OR: Bekera

OR: Harrington

HI: Canonico

 

West Clinic: RC(AM), BR(PM) = 1.0

AZ PTO: 0

West PTO: Ji = 1

TOTAL OUT: 2(15−2=13 on)

TOTAL ON: 13 −0.5 BR −0.75 BM = 11.75

~30 auths/MD (350.0÷11.75)

12 1.5 OUT

AZ-AM: MAL DD HR BR SL RC MS VS

AZ-PM: DD HR BR SL CS RC MS VS

AZ-DoD: DD

AZ-PTO:

AZ-Swing: Marotz

West Clinic: MAL(PM), Bekera(PM)

NV: HR BR

WA-overflow: MAL

WA-P: Popli

WA-J: RC

OR: Bekera

OR: Harrington

HI: Canonico

 

West Clinic: MAL(PM) = 0.5

AZ PTO: 0

West PTO: Ji = 1

TOTAL OUT: 1.5(15−1.5=13.5 on)

TOTAL ON: 13.5 −0.5 BR −0.75 BM = 12.25

~29 auths/MD (350.0÷12.25)

13 3.5 OUT

AZ-AM: MAL DD HR BR SL VS

AZ-PM: MAL HR BR SL CS MS VS

AZ-DoD: HR

AZ-PTO: RC

AZ-Swing: Marotz

West Clinic: MS(AM), DD(PM), Popli(PM)

NV: HR BR

WA-overflow: MAL

WA-P: AM Popli/PM MAL

WA-J: SL

OR: Bekera

OR: Harrington

HI: Canonico

 

West Clinic: MS(AM), DD(PM), Popli(PM) = 1.5

AZ PTO: RC = 1

West PTO: Ji = 1

TOTAL OUT: 3.5(15−3.5=11.5 on)

TOTAL ON: 11.5 −0.5 BR −0.75 BM = 10.25

~34 auths/MD (350.0÷10.25)

14 2 OUT

AZ-AM: MAL DD HR BR SL CS RC MS VS

AZ-PM: MAL DD BR SL CS RC MS VS

AZ-DoD: RC

AZ-PTO:

AZ-Swing: Marotz

West Clinic: HR(PM), Singh(PM)

NV: HR BR

WA-overflow: MAL

WA-P: Popli

WA-J: DD

OR: Bekera

OR: Harrington

HI: Canonico

 

West Clinic: HR(PM), Singh(PM) = 1.0

AZ PTO: 0

West PTO: Ji = 1

TOTAL OUT: 2(15−2=13 on)

TOTAL ON: 13 −0.5 BR −0.75 BM = 11.75

~30 auths/MD (350.0÷11.75)

15 3 OUT

AZ-AM: MAL DD HR BR SL CS MS

AZ-PM: MAL DD BR CS MS VS

AZ-DoD: MAL

AZ-PTO: RC

AZ-Swing: Marotz

West Clinic: VS(AM), SL(PM)

NV: HR BR

WA-overflow: MAL

WA-P: Popli

WA-J: MS

OR: Bekera

OR: Harrington

HI: Canonico

 

West Clinic: VS(AM), SL(PM) = 1.0

AZ PTO: RC = 1

West PTO: Ji = 1

TOTAL OUT: 3(15−3=12 on)

TOTAL ON: 12 −0.5 BR −0.75 BM = 10.75

~33 auths/MD (350.0÷10.75)

Sat 16
Sun 17

CALL:

Sat 16: MAL

Sun 17: MAL

18 2 OUT

AZ-AM: MAL DD HR BR SL MS VS

AZ-PM: MAL DD HR SL RC MS VS

AZ-DoD: SL

AZ-PTO:

AZ-Swing: Marotz

West Clinic: RC(AM), BR(PM)

NV: HR BR

WA-overflow: MAL

WA-P: Popli

WA-J: SL

OR: Bekera

OR: Harrington

HI: Canonico

 

West Clinic: RC(AM), BR(PM) = 1.0

AZ PTO: 0

West PTO: Ji = 1

TOTAL OUT: 2(15−2=13 on)

TOTAL ON: 13 −0.5 BR −0.75 BM = 11.75

~30 auths/MD (350.0÷11.75)

19 1.5 OUT

AZ-AM: MAL DD HR BR SL RC MS VS

AZ-PM: DD HR BR SL CS RC MS VS

AZ-DoD: DD

AZ-PTO:

AZ-Swing: Marotz

West Clinic: MAL(PM), Bekera(PM)

NV: HR BR

WA-overflow: MAL

WA-P: Popli

WA-J: RC

OR: Bekera

OR: Harrington

HI: Canonico

 

West Clinic: MAL(PM) = 0.5

AZ PTO: 0

West PTO: Ji = 1

TOTAL OUT: 1.5(15−1.5=13.5 on)

TOTAL ON: 13.5 −0.5 BR −0.75 BM = 12.25

~29 auths/MD (350.0÷12.25)

20 4.5 OUT

AZ-AM: DD HR BR SL VS

AZ-PM: HR BR SL CS MS VS

AZ-DoD: HR

AZ-PTO: RC MAL

AZ-Swing: Marotz

West Clinic: MS(AM), DD(PM), Popli(PM)

NV: HR BR

WA-overflow: ⚠ MAL ON PTO

WA-P: AM Popli/PM [TBD]

WA-J: SL

OR: Bekera

OR: Harrington

HI: Canonico

 

West Clinic: MS(AM), DD(PM), Popli(PM) = 1.5

AZ PTO: RC, MAL = 2

West PTO: Ji = 1

TOTAL OUT: 4.5(15−4.5=10.5 on)

TOTAL ON: 10.5 −0.5 BR −0.75 BM = 9.25

~38 auths/MD (350.0÷9.25)

21 5 OUT

AZ-AM: DD HR BR CS MS VS

AZ-PM: DD BR CS MS VS

AZ-DoD: MS

AZ-PTO: SL RC MAL

AZ-Swing: Marotz

West Clinic: HR(PM), Singh(PM)

NV: HR BR

WA-overflow: ⚠ MAL ON PTO

WA-P: Popli

WA-J: DD

OR: Bekera

OR: Harrington

HI: Canonico

 

West Clinic: HR(PM), Singh(PM) = 1.0

AZ PTO: SL, RC, MAL = 3

West PTO: Ji = 1

TOTAL OUT: 5(15−5=10 on)

TOTAL ON: 10 −0.5 BR −0.75 BM = 8.75

~40 auths/MD (350.0÷8.75)

22 5 OUT

AZ-AM: HR BR SL CS MS

AZ-PM: BR CS MS VS

AZ-DoD: HR

AZ-PTO: DD RC MAL

AZ-Swing: Marotz

West Clinic: VS(AM), SL(PM)

NV: HR BR

WA-overflow: ⚠ MAL ON PTO

WA-P: Popli

WA-J: MS

OR: Bekera

OR: Harrington

HI: Canonico

 

West Clinic: VS(AM), SL(PM) = 1.0

AZ PTO: DD, RC, MAL = 3

West PTO: Ji = 1

TOTAL OUT: 5(15−5=10 on)

TOTAL ON: 10 −0.5 BR −0.75 BM = 8.75

~40 auths/MD (350.0÷8.75)

Sat 23
Sun 24

CALL:

Sat 23: RC

Sun 24: RC

Monday

Tuesday

Wednesday

Thursday

Friday

Wknd / Call

Memorial Day

26 3 OUT

AZ-AM: DD HR BR RC MS VS

AZ-PM: DD HR BR CS RC MS VS

AZ-DoD: DD

AZ-PTO: SL MAL

AZ-Swing: Marotz

West Clinic: MAL(PM), Bekera(PM)

NV: HR BR

WA-overflow: ⚠ MAL ON PTO

WA-P: Popli

WA-J: RC

OR: Bekera

OR: Harrington

HI: Canonico

 

West Clinic: 0

AZ PTO: SL, MAL = 2

West PTO: Ji = 1

TOTAL OUT: 3(15−3=12 on)

TOTAL ON: 12 −0.5 BR −0.75 BM = 10.75

~33 auths/MD (350.0÷10.75)

27 4.5 OUT

AZ-AM: DD HR BR RC VS

AZ-PM: HR BR CS RC MS VS

AZ-DoD: HR

AZ-PTO: SL MAL

AZ-Swing: Marotz

West Clinic: MS(AM), DD(PM), Popli(PM)

NV: HR BR

WA-overflow: ⚠ MAL ON PTO

WA-P: AM Popli/PM [TBD]

WA-J: RC

OR: Bekera

OR: Harrington

HI: LG (no FTE impact)

 

West Clinic: MS(AM), DD(PM), Popli(PM) = 1.5

AZ PTO: SL, MAL = 2

West PTO: Ji = 1

TOTAL OUT: 4.5(15−4.5=10.5 on)

TOTAL ON: 10.5 −0.5 BR −0.75 BM = 9.25

~38 auths/MD (350.0÷9.25)

28 3 OUT

AZ-AM: DD HR BR SL CS RC MS VS

AZ-PM: DD BR SL CS RC MS VS

AZ-DoD: RC

AZ-PTO: MAL

AZ-Swing: Marotz

West Clinic: HR(PM), Singh(PM)

NV: HR BR

WA-overflow: ⚠ MAL ON PTO

WA-P: Popli

WA-J: DD

OR: Bekera

OR: Harrington

HI: Canonico

 

West Clinic: HR(PM), Singh(PM) = 1.0

AZ PTO: MAL = 1

West PTO: Ji = 1

TOTAL OUT: 3(15−3=12 on)

TOTAL ON: 12 −0.5 BR −0.75 BM = 10.75

~33 auths/MD (350.0÷10.75)

29 3 OUT

AZ-AM: HR BR SL CS RC MS

AZ-PM: BR CS RC MS VS

AZ-DoD: MS

AZ-PTO: DD MAL

AZ-Swing: Marotz

West Clinic: VS(AM), SL(PM)

NV: HR BR

WA-overflow: ⚠ MAL ON PTO

WA-P: Popli

WA-J: Ji

OR: Bekera

OR: Harrington

HI: Canonico

 

West Clinic: VS(AM), SL(PM) = 1.0

AZ PTO: DD, MAL = 2

West PTO: 0

TOTAL OUT: 3(15−3=12 on)

TOTAL ON: 12 −0.5 BR −0.75 BM = 10.75

~33 auths/MD (350.0÷10.75)

Sat 30
Sun 31

CALL:

Sat 30: CY

Sun 31: CY

of 3

The DOCX has been regenerated to match the HTML calendar layout . Here's what it now mirrors:

Layout Match

  • Landscape orientation with the same 6-column table (Mon–Fri + Wknd/Call)

  • Blue header row (#4472C4) with white text matching the HTML exactly

  • Each day cell contains the same line-by-line structure: day number + OUT badge, AZ-AM/PM/DoD rosters, PTO, Swing, West Clinic, NV, WA-overflow, WA-P, WA-J, OR, HI — all color-coded identically

  • Yellow highlights on PTO-affected lines (WA-J coverage, HI coverage, DoD swaps)

  • Metrics block below the separator with clinic count, AZ PTO, West PTO, TOTAL OUT/ON, and the green auth/MD tier badge

  • Weekend cells centered with call assignments in dark red

  • Holiday cell (May 25) with blue background

The colors, font sizing (Arial Narrow ~7pt body), and data are all pulled directly from the validated HTML so everything stays in sync. Open it in Word and it should look like the HTML version on the right.

Prepared using Claude Opus 4.6 Thinking
May_2026_Shift_Calendar