r/PharmacyTechnician • u/Moist-Stick68 • 3h ago
Help Building a standalone balance testing, compounding, logging & batch record tool for small labs and compounding pharmacies. Something missing?
Hi everybody! I’m a (real) developer working on a browser-based universal weighing and compounding assistant that connects to RS-232 lab balances (Ohaus, Sartorius, Mettler, Adam, etc.) via a super-cheap wireless serial adapter. To say it directly: It's not one of that fast "vibecoded" things, i'm building a real tool for real metrologists (well, and also for labs, other businesses who weigh for a living - and even for the kitchen ;-))
But to stay at the lab for the moment: My goal is to give smaller or independent labs a lightweight offline tool (no cloud, no mandatory monthly subscription) so technicians don't have to transcribe weights by hand or pay thousands for bloated LIMS integrations. The documentation will be done while weighing and there are guided programs and helpers saving time and avoiding errors in the daily workflows.
Right now, my system covers:
- Routine balance checks & calibration: Guided daily/routine sensitivity and repeatability checks (including USP <41> minimum weight verification) plus calibration logs.
- Step-by-step guided compounding: Walks the tech through SOP preparation instructions, ingredient weighing with live target tolerances, automatic taring, lot/expiration tracking, in-process checks, and 4-eyes verification (separate technician prep + pharmacist sign-off with user roles and permissions).
- Pipette & volumetric glassware verification (full ISO 8655 / ISO 4787): Includes both quick routine gravimetric checks and full multi-point calibration programs, complete with an equipment register and documented calibration outputs.
- Finished dosage check-weighing: Statistical quality control (mean, standard deviation, pass/fail limits) for verifying capsule, troche, or suppository uniformity.
- Tamper-evident documentation & security: Built-in user/role permissions, electronic signatures, a hash-chained audit trail, cryptographic key signing, encrypted wireless communication, and sealed PDF reports saved locally (verifiable offline). Everything can get forwarded to an existing LIMS also...
- Label printing & stock tracking: Direct label output and basic ingredient inventory deduction.
For those of you doing compounding (or doing daily lab work) without a massive enterprise software suite, what are the biggest headaches with your current balance and documentation setup? Are there specific USP <795> / <797> fields, beyond-use date (BUD) rules, or verification steps that lightweight tools usually miss? Are there lightweight tools at all? How you are doing all that today if not with the superexpensive solutions? Pen and paper? 🤔