SOP for Preparation of Trends : Pharmaguideline

Online GMP Courses with Certificate


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.


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 a 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 the establishment of alert and action limits or in-house specifications. An annual summary report shall be prepared for the data obtained for the 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 used 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 a 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 the 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 the end of the first month of the subsequent year. It shall be, duly approved by Quality assurance department.


6.1 SOP – Standard Operating Procedure
Get ready to use editable documents in MS-Word FormatView List

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

No comments:

Post a Comment

Please don't spam. Comments having links would not be published.

Popular Categories

QA SOPs QC SOPs Micro SOPs HVAC Production SOPs Stores SOPs Checklists Maintenance SOPs HPLC Sterile GLP Validation Protocols Water System GDP Regulatory Maintenance Calibration Warning Letters Education B.Pharmacy
Online Courses

Follow Pharmaguideline



Editable Pharmaceutical Documents in MS-Word Format. Ready to use SOPs, Protocols, Master Plans, Manuals and more...



Recent Posts