Overview

The spreadsheet templates supplied with Chemical Solutions™ HSQ™ and PQ™ Qualification Kits are designed to support qualification activities while maintaining calculation accuracy and document integrity.

To protect validated formulas, calculations, and report structures, portions of the spreadsheet are locked against modification. Users are permitted to enter qualification data only into designated input cells.

Why Certain Cells Are Locked

Protected cells help ensure that:

• Validated calculations remain unchanged
• Qualification results are generated consistently
• Formula integrity is maintained
• Report formats remain standardized
• Qualification documentation remains reliable

By restricting access to calculation and reporting functions, the spreadsheet can be used as intended without the risk of accidental modification.

Accessing Protected Areas

Editing locked cells requires the worksheet password.

While access can be provided upon request, modifying protected cells changes the validation status of the spreadsheet.

Once protected formulas, calculations, or worksheet structures are altered, the spreadsheet should no longer be considered validated in its original form.

Impact on Validation Status

Users should understand that modifying protected portions of the spreadsheet may:

• Void the spreadsheet validation status
• Alter calculation performance
• Affect qualification documentation
• Require additional verification activities
• Impact compliance programs that rely on validated tools

Organizations operating under regulated quality systems should carefully evaluate any modifications before making changes.

Warranty Considerations

Modifying protected spreadsheet components may also affect product support and warranty coverage associated with the qualification workbook.

For this reason, users should maintain an unmodified master copy whenever possible.

Non-Regulated Laboratory Use

Laboratories not operating under strict GMP or similar controlled environments may choose to modify spreadsheet functionality for internal purposes.

Users considering modifications should understand that any changes become the responsibility of the organization making those modifications.

Key Takeaways

• HSQ™ and PQ™ qualification spreadsheets contain protected cells.
• Only designated user-entry fields are intended for routine data input.
• Access to locked cells requires a password.
• Modifying protected areas removes the workbook's validated status.
• Spreadsheet modifications may affect warranty coverage and support.
• Regulated laboratories should carefully evaluate any proposed changes.

For Chemical Solutions™ HSQ™ and PQ™ Qualification Kit Specifications, Product Images, Qualification Resources, and Ordering Information, view Chemical Solutions™ HSQ™ and PQ™ Qualification Kit Specifications, Product Images, Qualification Resources, and Ordering Information.