Aubin Environmental
Aubin Ops
Everything for running the workshop, the sites and the team, in one place.
Use the menu on the left to move between sections, or ask Professor AUBOT bottom-right.
Inventory & Production Overview
Real bill of materials imported from the HYDROS BOM spreadsheet — 251 unique parts across 449 line items.
Shortest-supply parts
The parts furthest below what's needed to build the target quantity set on the Bill of Materials tab.
Recent builds
Latest production activity across all staff. Full log and time tracking on the Production Time tab.
Bill of Materials
HYDROS-ST-ASM-001 · Standard 20ft Container, imported from the BOM spreadsheet. Requirements below are driven by your production forecast — see exactly what's short.
Quick check
A one-off "what if I built N units right now" check — separate from the forecast, doesn't change anything else on this page.
Target build
Raw materials — stock vs. requirements
Purchased parts only — the things you actually order from a supplier. Available, cost, and lead time (weeks) are editable per part. "Unavailable" is stock already committed to a built sub-assembly — tracked automatically from the Build actions below.
Assemblies — what needs to be built
Sub-components built from raw materials (some are themselves built from other sub-components). "Outstanding" is how many more you need to build for the current production run; "Buildable now" checks whether you currently hold enough components to cover that. Expand the matching row on the BOM structure tree below to actually build it.
Import stock listing spreadsheet
Upload an updated stock listing (.xlsx) — part number, name, quantity, price per unit and lead time are matched automatically by column heading. Nothing is written until you review the preview and confirm.
Bulk-update stock, cost & lead time
Paste rows copied from a spreadsheet — Part Number, Available qty, then optionally Cost and Lead time (weeks) — tab- or comma-separated, one part per line. The last two columns can be left off.
BOM structure
The full assembly tree. Expand an assembly to see what it's built from; dashed rows are individually-stocked parts. Solid rows can be built directly from their listed children — record the quantity built and the time it took.
Stock adjustments
Automatic log of every available-quantity correction, most recent first.
Purchases
Record incoming stock with quantity and purchase price. New purchases add straight to available stock.
Record a purchase
Purchase history
Production Time
Log the time taken to build any component or sub-assembly, and nominate everyone who worked on it. This is the same "Build" action as on the Bill of Materials tab.
Log a build
Pick anything with a bill of materials, the quantity completed, how long it took, and who built it — hold Ctrl (or Cmd) to select more than one person.
Build & time log
Workshop KPIs
Build-time stats from every logged build with a time recorded — the same average build times also drive the workshop-hours estimate on the Forecast & Ordering tab.
By staff member
By part / assembly
Forecast & Ordering
Set a monthly build forecast for HYDROS-ST-ASM-001. Every part's own lead time is worked backward from each month's build date to tell you when to place the order.
Monthly production forecast
Units of the finished container to complete, by month. Leave a month at 0 to skip it.
Monthly purchasing plan
Ordering schedule (full detail)
Reports
A copyable shortfall list for the target build quantity set on the Bill of Materials tab, and a full stocktake valuation.
Shortfall shopping list
Stocktake valuation
Every tracked item — raw material or assembly — at available + committed-to-a-build quantity, valued at its entered unit cost. Materials consumed into a sub-assembly stay on this list so the count reconciles at stocktake.
Sell finished units
Removes the finished unit(s) from stock, and backs out a proportional share of every component embedded in them from the stocktake — they've left the business for good.
🎓 Professor AUBOT
Ask in plain language — inventory/production or Care Plans. Answers are grounded in your live data, not guesses. Say "Hey Professor AUBOT" from anywhere to ask hands-free (toggle in the sidebar).
Care Plans
Annual management plans for every site — schedule, checklists, odour surveys and visit sign-off, grounded in Aubin's Field Technician Guideline.
Add a site
Sites
Reminder emails
Site details
Annual overview
Every scheduled maintenance, monitoring and reporting activity for this site (Section 1 of the Annual Management Plan).
Overdue
Upcoming
Odour survey locations
Defined once per site, then reused every time an odour survey is recorded (Section 4.1).
Log an ad hoc visit
Septic tank de-sludge, alarm investigation & response, or any other one-off maintenance visit that isn't on the fixed schedule.
Site log
A permanent record for this site — anything worth keeping, not tied to a specific visit. Entries can't be edited or deleted once added.
Completed visits
Odour survey
Complete immediately on arrival, before disturbing tanks, opening lids or undertaking maintenance works (Section 4).
Checklist
Notes & observations
Site visit details
Header details for the maintenance report — from PART B of the Site Visit Planning and Reporting policy.
Post-visit interview
Complete after the visit — this feeds the maintenance report below.
Water monitoring results
Parameters are fixed by the reporting template — fill in what was tested; blank rows are left out of the report.
Issues identified
Each issue carries its own severity and action trail on the client report.
Additional works required but not completed
Works found on site that still need doing — the quotable follow-up list, separate from planned tasks left undone.
Client / site communication
What was discussed on site — appears on the client report.
Spares & consumables used
Feeds both the maintenance report and the invoice line-item list below.
Site visit maintenance report
Formatted to Aubin's Site Visit Maintenance Template and ready to send to the client.
Visit status
Staff
Admin only. Create a login for each staff member so their stock changes, purchases, and build/time entries are attributed to them.
Add staff member
All accounts
Training Modules
Aubin's controlled policy documents. Read each one that applies to you, then confirm you understand it and agree to abide by it. Your sign-off is recorded in the training matrix.
My training
Training matrix
Admin only — who has signed what, across every published policy.
Add a policy or training module
Upload a new document as you create it. PDFs open in the browser so staff can read and sign in one place; Word and PowerPoint files download instead. Use an existing title with a new revision number to publish a revision — everyone assigned will be asked to re-sign it.
Policy library
Admin only — set who has to acknowledge each policy, and whether it's published to staff. Assignments save as you tick them. To load a new or revised document, drop it on the G: drive and run node import-policies.js.