title: Reporting and scheduling in-study inspections with the study director using microsoft Excel.
abstract: Our Environmental and Metabolic Fate division conducts a variety of different studies that can require between 1 month and 3 years to complete. Our master schedule for this division can contain as many as 50-75 of these studies. Since the Good Laboratory Practices (GLP) regulations require in-study inspections at intervals adequate to assure study integrity and our quality assurance unit (QAU) standard operating procedure (SOP) requires us to monitor studies that last longer than 3 months at least once a quarter, in-study inspection scheduling can be challenging. In order to keep up with the work load described we have developed a method using a spreadsheet program, Excel, to facilitate in-study inspection scheduling through periodic reporting of all QAU inspection activity to the study director. This report makes the scheduling of critical phase and quarterly inspections a cooperative effort between the study director and QAU auditor. The details of the development and utilization of Excel for these "in-study inspection tracking reports" are presented.
authors.affiliation: Ricerca, Inc., Painesville, OH 44077, USA.
authors.forename: T T
authors.initials: TT
authors.lastname: Kilcoin
authors.forename: D E
authors.initials: DE
authors.lastname: Mayer
mesh_terms: D005161:Facility Regulation and Control / Q000458:organization & administration*; D005568:Forms and Records Control / Q000379:methods*; D006801:Humans; D008838:Microcomputers; D010562:Personnel Staffing and Scheduling Information Systems; D011785:Quality Assurance, Health Care; D012984:Software