Skip to content

herebran/wag-zone-assignment

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

3 Commits
 
 
 
 
 
 

Repository files navigation

ZoneAssignment
Walgreens Priority Zone Assignment board for pharmacy operations managers

A single HTML file that replaces the paper Walgreens Priority Zone Assignment sheet. You assign technicians to zones by time slot, keep your store roster in one place, print the sheet when you need it on the wall, and export plain text you can paste into the core pharmacy workflow board. Fully offline and never uploads anything.


Why This Tool Exists

The physical Walgreens Priority Zone Assignment board is gone. New Walgreens SOP now points to the core pharmacy workflow board instead, and that board is missing most of what the old Priority Zone Assignment board did.

The core pharmacy workflow board gives you three time slots. The old Priority Zone Assignment board had eight. The core pharmacy workflow board has Green, Blue, and Yellow, with no way to split them, so there is no Green Zone Out Window, no Green Zone Drive Thru, no Blue Zone Fill 1 or Fill 2. There is no Purple or Red zone, no CPW Lead column, and no Other notes and priorities section at all.

If you ran the old Priority Zone Assignment board, you already know what the day needs to look like and the core pharmacy workflow board has nowhere to put it.

The one thing the core pharmacy workflow board does allow is custom text in its fields. That is the opening this app uses. You build the full board here the way you always did, then export it as plain text and paste it into the three slots the core pharmacy workflow board gives you. It is a workaround, not a replacement for a real board, but it gets your actual assignments in front of the team.

What It Does

  • Full zone grid with Green Zone (Out Window, Drive Thru), Blue Zone (Fill 1, Fill 2), Purple, Red, Yellow, and CPW Lead
  • Time slots you add and remove as needed, with start and end times from dropdowns
  • More than one technician per cell, for when two people cover the same station
  • Phlomometer under and above thresholds for F1, F4, FILL, and REV
  • Call for IC3 with the amount and who to call
  • Other notes and priorities with the standard rows already filled in (Exception counts, WCB/CMD, PCP, OOS/PFL, TPR, Deletes, MQ, MSC, DUR, Immunizer) plus your own rows
  • Technician roster with first name, last name, optional abbreviation, and role
  • Undo and redo with Ctrl+Z and Ctrl+Y, so a mis-click does not cost you the board
  • Saved boards by date, and a copy function to pull a previous day forward instead of starting over
  • Print that fits the whole board on one letter page and keeps the zone colors
  • Text export in two styles, a simple list for pasting into the core pharmacy workflow board or a chat, and an ASCII grid for anywhere with a fixed width font
  • Settings for store hours, 15 or 30 minute or hourly time steps, 12 or 24 hour clock, how names show on the board, and which sections your store actually uses

Everything runs inside the browser tab. Nothing is sent anywhere.

Screenshots

Zone board Technicians
Zone board with technicians assigned by time slot Store roster
Text export Print view
Plain text export One page print output

Installation

  1. Download ZoneAssignment.html from this repo
  2. Save it in your Rxdocuments folder
  3. Double click the file to open it in your browser
  4. Bookmark it to your browser bookmark bar for easy convenience

First Run

The database file is not included in this repo. The app creates it for you.

  1. Open ZoneAssignment.html
  2. Go to the Technicians tab and add your team
  3. Click Save .db in the top right and save it as zone_assignment.db in the same Rxdocuments folder
  4. The badge in the top right turns green and reads "Saved"

From that point on every change writes to that file on its own. Your roster, every saved board, and your settings all live in it.

After you fully close and reopen the browser, Edge asks for permission to the file again. A yellow bar appears with a Reconnect button. One click and you are back.

If you skip step 3 the app still works and keeps a backup inside the browser, but a real file is safer and it can sit in OneDrive with the rest of your pharmacy documents.

How to Use

  1. Set the Board date at the top of the Zone Board tab
  2. Pick a start and end time on the first row
  3. Hover a cell and click the + to assign a technician, and repeat for as many as that station needs
  4. Add more time slots with Add time slot at the bottom right of the grid
  5. Fill in the Phlomometer numbers, Call for IC3, and anything under Other notes and priorities
  6. Click Print for a paper copy, or Export to get plain text

To paste into the core pharmacy workflow board, click Export, leave it on Simple list, click Copy, then paste into the custom text fields on the core pharmacy workflow board.

To build tomorrow off today, change the board date, click Copy from, and pick the day you want to start from.

Settings Worth Knowing

  • Operating hours controls which times show in the dropdowns. Default is 8:00 AM to 10:00 PM. There is a 24 hour store option.
  • Time increment switches the dropdowns between 15 minutes, 30 minutes, and 1 hour.
  • Time format switches between 1:30 PM and 13:30. It carries into printing and export.
  • Board display controls how names read in the cells, either the abbreviation, Last First, First Last, or first name only. Text export always uses full names.
  • Board sections turns off Phlomometer, Call for IC3, or Other notes if your store does not use them. Hidden sections drop out of the board, the print, and the export.
  • Zones in the board toolbar turns off Purple, Red, Yellow, or CPW Lead. Anything already assigned to a hidden zone is kept, so turning it back on brings the names back.

Backup

zone_assignment.db is a normal SQLite file. Keep it in OneDrive or on a shared drive and all of your boards and your roster are backed up with it. Opening the same file from two computers at once is not supported, last save wins.

About

A single HTML file that rebuilds the Walgreens Priority Zone Assignment board. Assign techs to zones by time slot, keep a store roster, print the sheet, and export plain text to paste into the core pharmacy workflow board.

Topics

Resources

Stars

Watchers

Forks

Releases

Contributors

Languages