AseptSoft Core Documentation
AseptSoft Core Documentation
Breadcrumbs

Export Equipment Modules to Excel

The tabular Equipment Modules export is one of the Excel Tabular Exports, producing a workbook containing all Equipment Modules of the current Module.

:clipboard: Overview

Equipment Modules define the physical valve and instrument configurations for process equipment — such as a CIP skid, a WFI distribution panel, or a product transfer manifold. Each Equipment Module contains a set of engineering items (valves, instruments) and their states across multiple configurations (e.g., "CIP Supply", "CIP Return", "Isolated").

Exporting these configurations to Excel lets you review, adjust, or share valve state matrices with your engineering and validation teams outside of the drawing environment.

:page_facing_up: Worksheets

Each Equipment Module is exported as its own worksheet. The worksheet name is the Equipment Module name.

:bar_chart: Columns

Each worksheet contains the following columns:

Column

Description

Name

The Engineering Item name (dominant column — used for row matching)

Configuration columns

One column per Configuration (e.g., "CIP Supply", "CIP Return", "Isolated")

:jigsaw: Data Association

Element

Mapping

Each worksheet

One Equipment Module

Dominant column

Name — the engineering item identifier

Other columns

Configuration names

Each row

One Engineering Item within the Equipment Module

Each cell

The State of that engineering item in that configuration

:test_tube: Pharma Example

A CIP skid Equipment Module "EM-CIP-SKID-01" might export as follows, showing valve positions for each cleaning configuration:

Name

CIP Supply

CIP Return

Isolated

Drain

XV-CIP-101 (Supply Valve)

Open

Closed

Closed

Closed

XV-CIP-102 (Return Valve)

Closed

Open

Closed

Closed

XV-CIP-103 (Drain Valve)

Closed

Closed

Closed

Open

XV-CIP-104 (Isolation Valve)

Open

Open

Closed

Closed

This matrix gives the validation team a clear picture of every valve position in every CIP configuration — essential for IQ/OQ documentation.

:arrow_down: Import

The exported file can be edited and re-imported using the Import Equipment Modules from Excel functionality. This allows you to:

  • Modify valve states in configurations

  • Add or remove engineering items

  • Add or remove configurations

  • Create entirely new equipment modules

:wrench: Tabular Export Options

This export type uses the following Excel Tabular Export options:

Option

Used

Worksheet Creation

Yes

Worksheet Reorder

Yes

Column Reorder

Yes

Column Creation

Yes

Column Deletion

Yes

Row Creation

Yes

Row Reorder

Yes

Row Deletion

Yes

Workbook Deletion

No

Worksheet Deletion

No