Get the latest updates from us for free
Android App

SOP for Preparation of Trends

Standard operating procedure to prepare the trends for Water Analysis, Environment Monitoring, Microbial limit test Results.


       To lay down the procedure for the preparation of trends.

2.0  SCOPE

       This is applicable for Water Analysis results, Environment Monitoring Results, Microbial limit test Results.




       Head of Department


5.1  The trends shall be prepared for the following test Results
1.  Water Analysis results

2.  Environment Monitoring Results
3.  Microbial limit test Results

5.1.1  Water Analysis results Trend  The trend for water analysis results shall be prepared for the following type of Water
S. No.
Type of water
Raw water
pH, Hardness, Microbial count, Coliforms
Potable water
pH, TDS, Microbial count, Coliforms
Drinking water
pH, Microbial count, Coliforms
Soft water
Hardness, Microbial count
RO water
Hardness, Microbial count
Purified water
pH, Conductivity, TOC, Microbial count
Water for injection
pH, Conductivity, TOC, Microbial count
Pure Steam
Conductivity, TOC, Microbial count  The daily-acquired data of each parameter for each sampling point shall be taken for trend on a real time basis.  Trend results shall be reported every month in a cumulative form for all sample results / locations.  The monthly report shall contain the results of the current month and also it must contain cumulative data of the previous dates for the year.  To draw meaningful conclusion, from the acquired data, all the results shall be subjected to the basic calculations, (But not limited to these) minimum, maximum and average (mean) and Standard deviation from mean shall be determined.  For all the statistical results shall be reported for the current month and cumulative period / year till date.  If any data is crossing the limit determined, then the comments must be given in the respective trend.  The data obtained can be used in establishment of alert and action limits or in house specifications.  An annual summary report shall be prepared for the data obtained for entire year.  The report shall at least contain the following Table of Contents.
•  Approval Signatures
•  Objective
•  Methods
•  Procedure
•  Schedule for Environmental monitoring
•  Recommended limit
•  Locations for Environmental monitoring
•  Summary of the Environmental monitoring result
•  Summary
•  Contamination rate
•  Deviation
•  Conclusion  The unique document no. for the annual Summary Report shall be given as follows
AT stands for the code for Annual Trend and is fixed.
EM stands for the code for Environment Monitoring and is fixed.
XXX stands for the serial number, which starts from 001.   This annual summary shall consist of maximum readings of the year and minimum readings of the year.   This summary may be useful for establishment of seasonal variation or to revise existing alert and action limits.

Related: 3-Sigma Formula for Trend Analysis Limits

5.1.2  Environment monitoring Results Trend  The trends for environmental monitoring results shall be prepared for the production facilities and microbiological testing facility.  The trend shall be prepared for the parameters mentioned in their respective SOPs and the data acquired against the parameters.  As mentioned in point No. to the data shall be plotted as trend and the same shall be reviewed for its correctness and the CAPA required if any.

Related: Difference Between Out of Specification and Out of Trend

5.1.3  Microbial limit test Results  The trends for Microbial Limit Test Results of Raw Material and finished products shall be prepared for ”Total aerobic microbial count” and “Total yeast and mold count”.  The data acquired for entire year shall be trended for each product.  As mentioned in point No. to trend shall be prepared.  Annual trend summary shall be prepared for environmental monitoring program and water analysis program. It shall be completed before end of the first month of subsequent year. It shall be, duly approved by Quality assurance department.


6.1  SOP – Standard Operating Procedure

Ankur Choudhary is India's first professional pharmaceutical blogger, author and founder of Pharmaceutical Guidelines, a widely-read pharmaceutical blog since 2008. Sign-up for the free email updates for your daily dose of pharmaceutical tips.
.moc.enilediugamrahp@ofni :liamE Need Help: Ask Question

Be the first to comment!

Post a Comment