ProShop Automatic Machine Utilization Reports
Every night, WebRun opens ProShop ERP, pulls each machine's spindle hours and logged downtime for the day, calculates utilization against available shift hours, and posts the ranked report to Microsoft Teams while logging every day's numbers to a running Google Sheet.
How do I automatically track machine utilization across my shop?
WebRun pulls each machine's run hours and downtime from ProShop ERP every night, calculates utilization against available shift hours, and posts a ranked report to Microsoft Teams naming the lowest performing machine and its top downtime reason. Every day's numbers are also logged to a running Google Sheet, so leadership sees both the snapshot and the trend.
- Leadership sees utilization every morning without pulling a report by hand
- Idle machines and their downtime reason get surfaced daily
- 30 days of trend data builds automatically in one sheet
Built for CNC machine shops · precision manufacturers · plant managers · operations leadership
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
proshoperp.comin a real browser with your saved login - no setup, no API keys. -
1
ProShop ERP - pull spindle hours and downtime by machine
proshoperp.com
WebRun opens ProShop ERP to pull spindle hours and downtime by machine. - Open ProShop ERP and pull logged run hours and downtime by machine for the day
- Calculate utilization as run hours divided by available shift hours
- Note the reason code for any significant downtime
Done when Every machine's utilization percentage for the day is calculated.
-
2
Google Sheets - log utilization to a running trend sheet
google.com
WebRun opens Google Sheets to log utilization to a running trend sheet. - Append a row per machine with the date, run hours, downtime, and utilization
- Keep the running trend visible across the last 30 days
Done when The trend sheet includes today's utilization for every machine.
-
3
Microsoft Teams - post the ranked report to leadership
teams.microsoft.com
WebRun opens Microsoft Teams to post the ranked report to leadership. - Post the ranked utilization report to the leadership channel
- Call out the lowest performing machine and its top downtime reason
Done when Leadership has today's utilization report in Teams.
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
Does it change anything on the shop floor?
No. WebRun only reads run hours and downtime already logged in ProShop ERP. It reports on utilization, it does not schedule jobs or touch machine settings.
Where do the downtime reasons come from?
It reads the downtime reason codes your operators already log against each machine in ProShop ERP, so the report reflects your own shop's data.
Can I see trends over time, not just today?
Yes. Every day's utilization is appended to a running Google Sheet, so you can see the last 30 days of trend alongside the daily Teams report.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.