T T Kilcoin | PubMed Health

PubMedDate not supplied

Data organization for soil metabolism and soil degradation studies with microsoft Excel spreadsheets.

Certain steps for soil metabolism and soil degradation studies are repetitive and must transpire for each study. These steps are the data on initial combustion of soil, the extraction data, volatile-recovery data, and postextraction soil combustion data. A summary page that includes all these data has been developed and used successfully to document all the raw data associated with these steps on one form. Weights, volumes, and liquid scintillation data can then be entered into an Excel spreadsheet formatted to accept and process these raw data to provide the calculated data required for reporting. This information is centrally located for each sampling time period, which facilitates and streamlines quality assurance (QA) review of this study file. An explanation of the process and examples of the forms is provided.

Data Collection↗

PubMedDate not supplied

Reporting and scheduling in-study inspections with the study director using microsoft Excel.

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.

Facility Regulation and Control↗