All templates

Automated Care Logistics Staffed Bed Reporting

Every Monday, WebRun opens Care Logistics, records each unit's licensed bed capacity and currently staffed bed count, logs the gap to Google Sheets alongside last week's numbers, and posts a weekly report to Microsoft Teams leading with the units carrying the widest staffed to licensed gap.

Runs on WebRun · Strict Lockdown policy
Every Monday at 8:00 AM WebRunorchestrates each step
1 Care Logistics compare staffed vs licensed beds
2 Google Sheets log the weekly gap by unit
3 Microsoft Teams post the weekly report
In short

How do I track staffed beds against licensed capacity weekly?

WebRun compares each unit's staffed bed count against its licensed capacity in Care Logistics every Monday, logs the gap to Google Sheets alongside last week's numbers, and posts a weekly report to Microsoft Teams leading with the widest gaps. Leadership sees exactly how much licensed capacity is sitting unstaffed without pulling the numbers by hand.

  • Leadership sees the widest staffed to licensed gaps every Monday without pulling a report by hand
  • A week over week trend builds automatically for every unit
  • Unstaffed licensed capacity is quantified instead of left as a vague impression

Built for hospital operations leadership · nursing administration · hospital capacity managers · finance and staffing planners

Step by step

What does WebRun do on every run?

The exact actions WebRun takes, in order - in plain language, so you can adjust anything.

  1. WebRun signs in and gets to work

    Opens www.carelogistics.com in a real browser with your saved login - no setup, no API keys.

  2. 1
    Care Logistics - compare staffed vs licensed beds
    carelogistics.com
    WebRun in Care Logistics: compare staffed vs licensed beds
    WebRun opens Care Logistics to compare staffed vs licensed beds.
    • Open the CareEdge unit configuration view
    • Record each unit's licensed bed capacity and its currently staffed bed count
    • Calculate the gap between staffed and licensed for every unit
    • Note any unit where the gap widened or narrowed from last week

    Done when Every unit's staffed count, licensed count, and gap are captured for this week.

  3. 2
    Google Sheets - log the weekly gap by unit
    google.com
    WebRun in Google Sheets: log the weekly gap by unit
    WebRun opens Google Sheets to log the weekly gap by unit.
    • Open the Staffed vs Licensed Bed report
    • Append this week's row per unit with staffed count, licensed count, and gap
    • Keep a running column comparing this week's gap to last week's

    Done when The report has a current week row for every unit with a week over week comparison.

  4. 3
    Microsoft Teams - post the weekly report
    microsoft.com
    WebRun in Microsoft Teams: post the weekly report
    WebRun opens Microsoft Teams to post the weekly report.
    • Post the weekly report to the leadership Teams channel
    • Lead with the units carrying the widest staffed to licensed gap
    • Link to the Google Sheet for the full unit by unit breakdown

    Done when Leadership has this week's staffed versus licensed report posted with the widest gaps called out first.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
www.carelogistics.com
ScheduleRuns automatically on this cadence
Every Monday at 8:00 AM
DeliveryHow each run's result reaches you
Staffed vs licensed report · Microsoft Teams
OutputWhat each run produces - A logged row per unit comparing staffed to licensed beds, with a Teams report leading on the widest gaps.
Weekly report
Setup & safety

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.

Your credentials stay in your own private environment - WebRun never stores your passwords.
Strict Lockdown

Every action is checked against this policy before it runs.

Domains ALLOWLIST
Typed input ALLOW
Shell command BLOCK
File uploads BLOCK
Runs in a contained environment More on policies
Good to know

Questions, answered

Does this report include any patient information?

No. It only compares bed counts, staffed against licensed, by unit. No patient data is part of this report.

Where do the licensed and staffed numbers come from?

Both come directly from each unit's configuration already recorded in Care Logistics, so the report always matches what your team has entered there, not a separate WebRun estimate.

What if a unit's staffed count changes mid week?

The report reflects Care Logistics as of Monday morning. Set it to run again later in the week if your team wants a mid week check as well.

Put this on autopilot.

Turn it on in minutes - or have our team set it up for you.