Rewrote old Formulary system written in excel 20 years ago - and ported it to SQL Server, integrating with legacy ERP. Added tons of new tools and features. Since launch iterative improvements.

Team Members

Tagged MSPs

Categories

Problem with the old system was no central database, a lot of errors, no updated ingredients from the ERP system.

Enabled an ingredient palette that automatically updated from the ERP system via SQL Server into Excel. Enabled simple macro to copy ingredient into trials. Ran all calculations on price and quantity rolling up to quickly see the differences. Created a lab sheet, upload final formula to ERP for production. Import current formula directly from ERP, import from old formulary system. Show changes, etc...

I can't go into too many specifics as most of this is proprietary.

I ended up using VBA in Excel as a path of least resistance due to the tools at hand. It works well and is deployed throughout our labs.

It was developed closely with the entire lab team from the perfumers and flavorists to the compounders and technicians to ensure the tool I was creating was what they truly needed. You can't develop in a vacuum!