All templates

Odyssey ERP Automated Sand Reclamation Reports

Every Monday, WebRun opens Odyssey ERP, pulls last week's sand reclamation, additive usage, and new sand purchase figures, calculates the reclaim rate against total sand used, and compiles a report in Google Sheets so your sand system's performance is visible week over week.

Runs on WebRun · Strict Lockdown policy
Every Monday at 6:45 AM WebRunorchestrates each step
1 Odyssey ERP pull sand reclamation and new sand figures
2 Google Sheets compile the weekly reclaim rate report
In short

How do I track my foundry's sand reclamation rate weekly?

WebRun reports on your sand system every week. Every Monday, it opens Odyssey ERP, pulls last week's sand reclamation volume, additive usage, and new sand purchases, calculates the reclaim rate against total sand used, and compiles the numbers into a Google Sheets report with an eight week trend, so a slipping reclaim rate shows up early.

  • Reclaim rate is tracked weekly instead of noticed only when new sand costs spike
  • An eight week trend shows a slipping reclaim rate before it becomes a cost problem
  • Additive usage and new sand purchases stay tied to the same weekly report

Built for sand casting foundries · green sand foundries · foundry engineers · sand system operators

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.blinfo.com in a real browser with your saved login - no setup, no API keys.

  2. 1
    Odyssey ERP - pull sand reclamation and new sand figures
    blinfo.com
    WebRun in Odyssey ERP: pull sand reclamation and new sand figures
    WebRun opens Odyssey ERP to pull sand reclamation and new sand figures.
    • Open Odyssey ERP and pull last week's sand reclamation volume, additive usage, and new sand purchases
    • Tie the figures to the molding volume for the week where recorded
    • Calculate the reclaim rate as reclaimed sand against total sand used

    Done when Last week's reclamation, additive, and new sand figures are pulled with a reclaim rate calculated.

  3. 2
    Google Sheets - compile the weekly reclaim rate report
    google.com
    WebRun in Google Sheets: compile the weekly reclaim rate report
    WebRun opens Google Sheets to compile the weekly reclaim rate report.
    • Add this week's figures as a new row in the reclaim rate tracker
    • Chart the reclaim rate trend against the prior eight weeks
    • Flag a week where new sand purchases jumped against a flat molding volume

    Done when This week's reclaim rate report is compiled in Google Sheets with the trend visible.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
www.blinfo.com
ScheduleRuns automatically on this cadence
Every Monday at 6:45 AM
DeliveryHow each run's result reaches you
Reclaim rate report · Google Sheets
OutputWhat each run produces - A weekly sand reclamation report in Google Sheets with reclaim rate, additive usage, and new sand purchases, tracked against an eight week trend.
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 it control the sand system or additive mix?

No. It only reports the figures already recorded in Odyssey ERP. Any change to the sand system or additive mix stays with your foundry engineer.

What counts toward the reclaim rate?

It divides the sand reclaimed and reused by the total sand used for the week, using the volumes already logged in Odyssey ERP, so the rate reflects your own recorded figures.

Will it catch a jump in new sand purchases?

Yes. It flags a week where new sand purchases rise against a flat molding volume, since that combination usually points to a slipping reclaim rate worth a closer look.

Put this on autopilot.

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