AseptSoft Core Documentation
AseptSoft Core Documentation
Breadcrumbs

Export Processes to Excel - Validations

The Validations export is one of the Excel Tabular Exports containing the Validation status of each Engineering Item in each Step for each Process.

Access: From the Export Processes to Excel window -> Validations tab.

🏭 Pharma Example — Exporting Validation Progress for a GMP Audit

During a GMP audit, the quality assurance team needs evidence that every valve state in every CIP/SIP step has been reviewed and formally validated. Export the validation status to Excel to produce a clear matrix showing which items have been validated and which are still pending. The auditor can see at a glance that "VP-101 in Step 3: Pre-rinse" is validated while "VP-205 in Step 5: Drain" is still awaiting review. This export serves as documentary evidence for the Review Session completion.

📊 Columns

Column

Content

Tag

The Engineering Item's tag identifier

Step columns

One column per Step in the Process

Each cell shows whether that Engineering Item has been validated in that Step within the active Review Session.

🖥️ Export Window

In the Export Processes to Excel window, select the Validations tab.

  • Left side: Check the Processes you want to export

  • Right side: Configure export options:

Option

Description

One document

Single file named after the current Module, with one worksheet per Process

One document per Process

Separate file for each Process, named after the Process

📋 How To: Export Validation Status for Audit Evidence

  1. Ensure you have an active Review Session with validations in progress

  2. Open the Export Processes to Excel window and select the Validations tab

  3. Check the processes relevant to your audit scope

  4. Choose One document for a consolidated audit evidence file

  5. Click Export — the resulting workbook shows validation status for every item in every step

  6. Include the exported file in your audit documentation package

🔗 Data Association

This export follows the Excel Tabular Exports data association pattern:

Element

Maps To

Worksheet

One Process

Dominant column

"Tag"

Other columns

Steps

Each row

An Engineering Item

Each cell

Whether that item is validated in that Step

✅ Supported Tabular Options

Option

Supported

Worksheet Creation / Reorder / Deletion

Yes

Row Creation / Reorder / Deletion

Yes

Workbook Deletion

No

Column Creation / Reorder / Deletion

No

See Excel Tabular Exports for details on how these options work.