Dozens of new products are added to LMS monthly, each having a unique ingredient list, testing schedule, and specifications that must be carefully set up in LIMS before samples and results can be added. I created automation scripts to consolidate and calculate information across various directories and input the data into LIMS. This turned an hour-long undertaking into a simple three-minute task.
What retrieved from from outside logs after Entering the Formulation code in [B1]
What gets calculated after pasting Ingredients from Nutrition Label
Source Template
[] work in progress [] show GIFs