• (919) 844 2494
  • Excel Spreadsheets


    Page 2 of 212
    1. Warning Letter: Spreadsheet Calculations not Verified or Documented (ucm174100)

      Tags: | | |

      Your laboratory records did not include a record of all calculations performed in connection with laboratory tests as required by 21 CFR § 211.194(a)(5). For example, laboratory notebook #7, page 49, documents the assay results, but not the calculations performed in Test number DSFS D-13 and Test number TG 521 for the analysis of [redacted], lot #HI7908. The notebook does not document reference to the spreadsheet calculation used to generate the results. In addition, the assay results generated by the spreadsheet were not verified for accuracy. Your response dated February 16, 2009, states that you have established procedures to ensure that calculations of method validation studies are recorded. The Records Management SOP, Section 5.7.4.7, states that the procedures shall define what and how data is to be recorded in respective logbooks. However, this SOP omits instructions to include in the notebook the reference to the spreadsheet calculation used to generate the results, as well as the raw data and calculations. In addition, you continued to release products based on assay results generated by the spreadsheet that have not been verified for accuracy.

      View the original warning letter.


      Recommended Solutions

      Compliance Training >>

      Recommended Solutions

      ExcelSafe >>

      Recommended Solutions

      Ofni Clinical >>

      Recommended Solutions

      Part 11 Toolkit >>

      Recommended Solutions

      Part 11 Advisor >>

      Recommended Solutions

      MedWatch Reporter >>

      Recommended Solutions

      Computer Validation >>

      Recommended Solutions

      Custom Programming >>

      Recommended Solutions

      Validating MS Excel Spreadsheets >>

      Recommended Solutions

      Access Databases >>

    2. Warning Letter: Computer systems not validated (s6381c)

      Tags: | | |

       
      "Software used as part of the production quality system
      was not validated
      for its intended use according to an established protocol [21 C.F.R. 820.70(i)]. Specifically,
       
      (a)
      Spreadsheets
      intended to check for outliers and calculate mean, SC, % CV, value assignments for finished devices.
      (b) Complaint handling software
      (c) Quantrol database program"

       

      View the original warning letter.


      Recommended Solutions

      Compliance Training >>

      Recommended Solutions

      ExcelSafe >>

      Recommended Solutions

      Ofni Clinical >>

      Recommended Solutions

      Part 11 Toolkit >>

      Recommended Solutions

      Part 11 Advisor >>

      Recommended Solutions

      MedWatch Reporter >>

      Recommended Solutions

      Computer Validation >>

      Recommended Solutions

      Custom Programming >>

      Recommended Solutions

      Validating MS Excel Spreadsheets >>

      Recommended Solutions

      Access Databases >>

    3. Warning Letter: Failure to Validate MS Excel Spreadsheets (s6366c)

      Tags: | | |

      Failure to adequately validate the intended use of this PC and its software, as required by 21 CFR 820.70(i). “For example: the dedicated PC [redacted] attached to the [redacted] was not secure in that access to the data on [redacted] was not granted by a unique username and password or equivalent method; there as no documentation associated with the electronic data for whom was responsible for collection of the analytical results as several quality control personnel have access to the [redacted] no software changes in the study data could be detected as there was no audit trail capability ; and finally, the electronic data did not correlate with the paper records.”

      View the original warning letter.


      Recommended Solutions

      Compliance Training >>

      Recommended Solutions

      ExcelSafe >>

      Recommended Solutions

      Ofni Clinical >>

      Recommended Solutions

      Part 11 Toolkit >>

      Recommended Solutions

      Part 11 Advisor >>

      Recommended Solutions

      MedWatch Reporter >>

      Recommended Solutions

      Computer Validation >>

      Recommended Solutions

      Custom Programming >>

      Recommended Solutions

      Validating MS Excel Spreadsheets >>

      Recommended Solutions

      Access Databases >>

    4. Warning Letter: Failure to Create Validation and CAPA Procedures (g4452d)

      Tags: | | | |

      Failure to establish and maintain adequate procedures for implementing corrective and preventive action, as required by 21 CFR 820.100(a) and (b). For-example:

      a. The procedure titled corrective Action Handling [redacted] was not approved and implemented to address corrective and preventive action and no established procedure was found to have been in place.

      b. Microsoft 2000 Excel spreadsheet software used manufacturing has not been validated for the purpose of generating a worksheet for formulation of reagents. No documentation was found to establish or verify corrections made to the program.

      A report dated November 11, 2002 on non-conforming material on [redacted] was filed and a possible cause for the [redacted] was given; however no documentation was provided to verify or validate the adequacy of the corrective and preventive actions.

      Problems were recorded relating to the use of the new dosing/dispensing machine [redacted]; however no documentation/evidence was provided
      to verify or validate the adequacy of the corrective and preventive actions.”

      View the original warning letter.


      Recommended Solutions

      Compliance Training >>

      Recommended Solutions

      ExcelSafe >>

      Recommended Solutions

      Ofni Clinical >>

      Recommended Solutions

      Part 11 Toolkit >>

      Recommended Solutions

      Part 11 Advisor >>

      Recommended Solutions

      MedWatch Reporter >>

      Recommended Solutions

      Computer Validation >>

      Recommended Solutions

      Custom Programming >>

      Recommended Solutions

      Validating MS Excel Spreadsheets >>

      Recommended Solutions

      Access Databases >>

    5. Warning Letter: MS Access and MS Excel Not Validated (g1483d)

      Tags: | |

      Your firm failed to validate several computer databases that are used for quality functions including your Access database , your [redacted] software, and your MS Excel spreadsheet program as required by 21 CFR 820.70(i).

      View the original warning letter.


      Recommended Solutions

      Compliance Training >>

      Recommended Solutions

      ExcelSafe >>

      Recommended Solutions

      Ofni Clinical >>

      Recommended Solutions

      Part 11 Toolkit >>

      Recommended Solutions

      Part 11 Advisor >>

      Recommended Solutions

      MedWatch Reporter >>

      Recommended Solutions

      Computer Validation >>

      Recommended Solutions

      Custom Programming >>

      Recommended Solutions

      Validating MS Excel Spreadsheets >>

      Recommended Solutions

      Access Databases >>

    6. Warning Letter: Spreadsheets not Validated (g5699d)

      Tags: | | |

      There are no data to demonstrate that the quality control/quality assurance spreadsheets used for tracking and trending various quality metrics have been properly validated (installation qualification, operational qualification, and performance qualification) and are performing as intended.

      View the original warning letter.


      Recommended Solutions

      Compliance Training >>

      Recommended Solutions

      ExcelSafe >>

      Recommended Solutions

      Ofni Clinical >>

      Recommended Solutions

      Part 11 Toolkit >>

      Recommended Solutions

      Part 11 Advisor >>

      Recommended Solutions

      MedWatch Reporter >>

      Recommended Solutions

      Computer Validation >>

      Recommended Solutions

      Custom Programming >>

      Recommended Solutions

      Validating MS Excel Spreadsheets >>

      Recommended Solutions

      Access Databases >>


    Page 2 of 212