The Algorithm export (also known as the Conditions 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 (also labeled Conditions).
🏭 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 two types of columns:
Condition Fields
These are the fields from the Algorithm Design panel:
|
Column |
Content |
|---|---|
|
Tag |
Identification tag (e.g., "Step 1 Condition 1") |
|
Type |
Condition type |
|
Description |
Condition description |
|
Condition |
The condition expression |
|
Success Action |
Action on success |
|
Fail Action |
Action on failure (column hidden if empty across all conditions) |
|
Success Transition |
Step to transition to on success |
|
Fail Transition |
Step to transition to on failure (column hidden if empty across all conditions) |
|
Prompt |
Operator prompt text |
🔍 Aggregation Columns (Extracted References)
The export automatically detects and extracts all references used within condition fields. These aggregation columns provide a summary of what each condition uses:
|
Aggregation Column |
Content |
|---|---|
|
Instruments |
Instruments referenced in the condition |
|
Parameters |
Parameters referenced in the condition |
|
Variables |
Variables referenced in the condition |
|
Dialogs |
Dialogs referenced in the condition |
|
Controls |
Controls referenced in the condition |
|
Steps |
Steps referenced (e.g., in transitions) |
💡 Think of aggregation columns as a quick summary — they show you at a glance which instruments, parameters, variables, dialogs, and controls are involved in each condition, without having to read the full condition expression.
📄 Row Structure
Each row represents one condition. If a step has multiple conditions, each gets its own row. For example:
|
Tag |
Type |
Description |
Condition |
... |
Instruments |
Parameters |
|---|---|---|---|---|---|---|
|
Step 1, Condition 1 |
Timer |
Pre-rinse complete |
T101 > 30s |
... |
T101 |
P_Rinse_Time |
|
Step 1, Condition 2 |
Threshold |
Temperature reached |
TT201 >= SP1 |
... |
TT201 |
SP1 |
|
Step 2, Condition 1 |
Timer |
Caustic wash done |
T102 > 120s |
... |
T102 |
P_Wash_Time |
The last column, Steps (or Phases), tells you which step each condition leads to upon success.
🖥️ 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 |
|
Include phases without conditions |
When checked, all steps appear in the export — both those with and without conditions. When unchecked, only steps that have conditions are included |
|
Compact algorithm |
When enabled, uses a simplified two-column format (Step and Humanized Algorithm) instead of the full condition field table |
|
Colour algorithm tokens |
Color-codes references in the condition text (instruments, parameters, variables, etc.) for easier reading |
🔄 Reimport — Updating Your P&IDs from Excel
The conditions export is reimportable. This means you can edit the exported Excel file and import it back into AseptSoft to update your P&IDs.
How to Reimport Conditions
-
Export your conditions to Excel using the steps above
-
Open the Excel file and make changes — add, modify, or delete conditions
-
Click the Import button (next to the export button in the Module Ribbon)
-
A preview window opens showing all proposed changes:
-
Items marked in grey are unchanged
-
New or modified items are highlighted so you can see exactly what will change
-
-
Use the checkboxes to select which changes to apply — you can accept some changes and reject others
-
Click Import to apply the selected changes
💡 Tip: This two-way workflow lets you work on your P&IDs in AutoCAD and in Excel simultaneously. You can export, hand the Excel file to a colleague for review, incorporate their feedback in the spreadsheet, and reimport the corrections — all without manually re-entering data.
🎨 Layout Persistence
AseptSoft remembers the layout of your exported Excel files:
-
First export: Creates the file with a default table layout
-
Customize: Open the Excel file, adjust table formatting, colors, column widths, etc., and save
-
Subsequent exports: AseptSoft preserves your custom layout and only updates the data
⚠️ Important: When customizing the table layout, make sure there is no text directly above or next to the table. If there is content adjacent to the table, AseptSoft may not recognize the table boundaries on the next export. Leave at least one empty row above and one empty column to the left of the table.
💡 Tip: You only need to customize the layout for one process — export a single process, adjust the table to your liking, and save. The next time you export all processes, every worksheet will use the same layout.
📋 How To: Export Algorithm Conditions for Review
-
Open the Export Processes to Excel window and select the Algorithm tab
-
Check the processes you need to review (e.g., "SIP Main Vessel", "SIP Transfer Line")
-
Check Include phases without conditions for a complete view of all steps
-
Choose One document per Process if each process will be reviewed by a different engineer, or One document for a consolidated review
-
Click Export — each worksheet lists all conditions in sequence with their field values and aggregation columns
-
Share the Excel file with reviewers, who can annotate directly in the file
-
After corrections are made in the Excel file, reimport them back into AseptSoft using the Import button
🔗 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 and Aggregation columns |
|
Each row |
One Condition in the current Process |
|
Each cell |
The field value or extracted reference 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.
🔗 Related Pages
-
Export Processes to Excel — parent export window
-
Export Processes to Excel - Standard — template-based export
-
Export Processes to Excel - Tabular — valve status matrix
-
Export Processes to Excel - Validations — validation status export
-
Export Processes to PDF — visual PDF export
-
Algorithm Design — the conditions being exported
-
Excel Tabular Exports — shared tabular export framework
-
File System — export output location