Untitled

import pandas as pd

# Creating the structure of the scoring template
data = {
    'Document Title': [
        'Vendor Questionnaire',
        'Process Flow Diagram',
        'TSE/BSE Declaration',
        'Residual Solvent Declaration',
        'Stability Data / Shelf Life',
        'Regulatory Certificates',
        'Certificate of Analysis (CoA)',
        'Certificate of Compliance (CoC)',
        'Material Safety Data Sheet (MSDS)',
        'Nitrosamine Risk Assessment',
        'Elemental Impurity Risk Assessment',
        'Change Control History',
        'Declaration of Absence of Allergens/Gluten/GMO',
        'Cleaning Validation Report',
        'Calibration Records of Critical Equipment',
        'Packaging and Labeling Compliance',
        'Water Testing Report (if applicable)',
        'Microbial Contamination Risk Assessment'
    ],
    'Criteria': [
        'Complete, accurate, and up-to-date information',
        'Detailed, includes all critical process steps',
        'Provided and compliant with guidelines',
        'Meets ICH guidelines (Q3C)',
        'Provided with supporting data',
        'Valid GMP/ISO/other regulatory approvals',
        'Complete, compliant with specifications',
        'Matches product description',
        'Clear and up-to-date',
        'Compliant with regulatory guidance',
        'Meets ICH Q3D requirements',
        'Documented changes with impact assessment',
        'Provided and compliant with requirements',
        'If applicable, provided and compliant',
        'Valid and traceable',
        'Meets regulatory requirements',
        'Provided and compliant',
        'Relevant to material or process'
    ],
    'Maximum Score': [5, 5, 4, 4, 5, 5, 5, 4, 4, 4, 3, 3, 3, 3, 3, 3, 2, 2],
    'Achieved Score': [''] * 18,
    'Comments': [''] * 18
}

# Creating a DataFrame and exporting it to an Excel file
df = pd.DataFrame(data)
file_path = '/mnt/data/Vendor_Desk_Audit_Scoring_Template.xlsx'
df.to_excel(file_path, index=False, sheet_name='Document Verification')

file_path