During my work in the Quality Control lab, I evaluated approximately 150 spreadsheets, identified redundant calculations, and consolidated similar spreadsheets. Following the evaluation, 30 spreadsheets required further development and validation. To improve the process, I standardized the calculations, formatted input cells and formula cells separately for easier identification, and implemented locks for security. To ensure version control and prevent unauthorized access or editing, I also established storage security requirements.
In addition to these measures, I created a usage and management procedure, a user acceptance document, and a validation procedure aligned with the Good Manufacturing Practice (GMP), Good Clinical Practice (GCP), and/or Good Laboratory Practice (GLP) guidelines. By implementing these actions, the quality control lab’s spreadsheet accuracy and reliability were enhanced, enabling compliance with internal standards and regulatory requirements.
Let's Work Together
With the ongoing technological revolution changing our lives, society, and learning methods, my versatile technical expertise in pharmaceutical sciences, software design, and web development can help you accomplish complex projects efficiently.
© www.webrajiv.ca