AseptSoft Core Documentation
AseptSoft Core Documentation
Breadcrumbs

Export Processes to Excel - Algorithm

The Algorithm export is one of the Excel Tabular Exports containing the sequence of Conditions for each Step in a consecutive form for each Process.

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

🏭 Pharma Example — Exporting SIP Sequence Logic for Design Review

When preparing a Steam-In-Place (SIP) design review, the automation team needs to verify every transition condition in the sequence: temperature thresholds, timer expirations, instrument readings, and parameter references. Export the algorithm to Excel so that the control engineer and process engineer can review the SIP conditions side by side, mark up any discrepancies (e.g., incorrect temperature setpoints), and return the annotated file. On re-export, AseptSoft updates the condition data while preserving the engineers' comments.

📊 Columns

The exported table contains the following column types:

Column Type

Content

Condition Fields

All fields from the Algorithm Design

Extracted Data

References found within condition fields, grouped by category

🔍 Extracted Data Categories

The export automatically detects and extracts references used in condition fields:

🖥️ Export Window

In the Export Processes to Excel window, select the Algorithm 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 Algorithm Conditions for Review

  1. Open the Export Processes to Excel window and select the Algorithm tab

  2. Check the processes you need to review (e.g., "SIP Main Vessel", "SIP Transfer Line")

  3. Choose One document per Process if each process will be reviewed by a different engineer, or One document for a consolidated review

  4. Click Export — each worksheet lists all conditions in sequence with their field values and extracted references

  5. Share the Excel file with reviewers, who can annotate directly in the file

  6. After corrections are made in AseptSoft, re-export — the data updates while reviewer annotations are preserved

🔗 Data Association

This export follows the Excel Tabular Exports data association pattern:

Element

Maps To

Worksheet

One Process

Dominant column

"Tag"

Other columns

Condition fields or Extracted Data categories

Each row

One Condition in the current Process

Each cell

The field value or extracted data for that Condition

✅ 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.