Automated QGenda Block Utilization Report
Every Monday, WebRun opens QGenda, calculates the prior week's block utilization for every surgeon and service, logs the full breakdown to a Google Sheet, emails a summary with the lowest utilized blocks to leadership in Outlook, and posts the headline numbers to Slack.
How do I get a weekly OR block utilization report?
WebRun calculates last week's OR block utilization for every surgeon and service from QGenda, logging the full breakdown with a rolling four week average to a Google Sheet. It emails OR leadership a summary of the lowest utilized blocks in Outlook and posts the headline numbers to Slack, turning raw scheduling data into a decision-ready weekly report.
- Leadership gets a ranked utilization report every Monday instead of pulling it manually
- Blocks trending down for three straight weeks get flagged automatically
- One Sheet holds a rolling four week average alongside each week's number
Built for OR leadership · surgical services directors · perioperative operations managers · hospital administrators
What does WebRun do on every run?
The exact actions WebRun takes, in order - in plain language, so you can adjust anything.
-
WebRun signs in and gets to work
Opens
www.qgenda.comin a real browser with your saved login - no setup, no API keys. -
1
QGenda - calculate last week's block utilization
qgenda.com
WebRun opens QGenda to calculate last week's block utilization. - Open QGenda and pull last week's block schedule for every surgeon and service
- Calculate booked case hours against total allotted block hours for each
- Rank every block by utilization percentage, lowest first
Done when Last week's utilization percentage is calculated for every block.
-
2
Google Sheets - log the full utilization breakdown
google.com
WebRun opens Google Sheets to log the full utilization breakdown. - Open the Block Utilization Report sheet
- Append a row per block with surgeon, service, and utilization percentage for the week
- Keep a rolling four week average alongside this week's number
Done when The report sheet reflects this week's full utilization breakdown and rolling average.
-
3
Outlook - email a summary to leadership
microsoft.com
WebRun opens Outlook to email a summary to leadership. - Email a summary to OR leadership naming the five lowest utilized blocks
- Include each block's percentage and its four week rolling average
- Link to the full Google Sheet for further detail
Done when OR leadership has this week's utilization summary in their inbox.
-
4
Slack - post the headline numbers
slack.com
WebRun opens Slack to post the headline numbers. - Post the headline utilization numbers to the OR leadership Slack channel
- Flag any block whose rolling average has dropped for three straight weeks
Done when The OR leadership Slack channel has this week's utilization headline.
How is each run configured?
Secure by default
Connect once, stays signed in
WebRun signs in once and keeps each session in a persistent environment, so every run picks up right where it left off.
Every action is checked against this policy before it runs.
Questions, answered
How is utilization calculated?
As booked case hours divided by each block's total allotted hours in QGenda, for the prior week. Every surgeon and service gets its own percentage.
Does it recommend taking block time away from anyone?
No. It only reports the numbers and the trend. Any decision about reassigning or reducing block time stays with OR leadership.
Can it show a longer term trend, not just one week?
Yes. The Google Sheet keeps a rolling four week average alongside each week's number, and Slack flags any block trending down for three straight weeks.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.