Process Unit Statistics Export to Excel in AnyLogic

       Process Unit statistics export to Excel provides a standardized way to analyze refinery process unit simulation results directly from an AnyLogic simulation. The Exporter automatically collects process flow statistics and organizes Process Unit simulation data into a structured Excel report that reflects the actual process configuration. Statistics are collected as the refinery simulation progresses and aggregated by the selected time period: hour, day, month, or year. This makes it possible to analyze Process Unit performance, production output, and process flow changes over time. The same reporting principle is applied to Process Line statistics within each Process Unit. The resulting Excel report therefore combines overall Process Unit statistics with detailed Process Line-level data in a single consistent structure. Losses are included in the Process Unit material balance, while Gas Own Needs (GON) is reported separately as an incoming process flow to the installation.

       Once enabled, the Exporter accesses the required Process Unit and Process Line statistics from the corresponding Petroleum Refining Library components. The selected interval determines the time periods shown in the Excel report, while the rows preserve the Process Unit and Process Line structure. The Exporter does not calculate or modify process flows. The simulation model determines the process behavior and flow values; the Exporter only collects the resulting process statistics for Excel reporting.

       The Excel report starts with the Input and Production Output, Total of each Process Unit. The Exporter automatically expands these entries according to the actual flow structure of the model. A single incoming stream is shown as one entry.When several input streams enter the Process Unit, the input is automatically expanded into the individual process streams.Production output follows the same hierarchy: Production Output, Total can be broken down by product streams, products, and destinations. For example, the output of a Process Unit may be presented as:
        - production Output, TotalStable Condensate (SC)
        - natural Gas Liquids (NGL)
        - gas Mixture for NGL Processing
       If a product is sent to different destinations, those flows can be shown at the next level of detail. This hierarchy allows users to move from the overall production balance to individual products and flow directions without manually configuring the report.

       A Process Unit can contain one or more Process Lines, each with its own input flows, output flows, and operating mode. For each Process Line, the report shows its input, operating mode, production output, and product flows. This makes it possible to distinguish material flows and production output belonging to different technological lines within the same Process Unit. The report therefore provides two levels of detail: the overall Process Unit balance and the individual Process Line statistics. This is particularly useful when different lines operate in different modes or send products to different destinations.\
       Process Unit statistics can be aggregated by hour, day, month, or year. The selected time resolution determines the reporting periods shown in the Excel columns, while the rows preserve the Process Unit and Process Line structure.

       For each Process Unit and Process Line, the report reflects the material balance generated by the refinery simulation. The Process Unit material balance is represented by the relationship between input, production output, and losses:

Input = Production Output + Losses

       GON is reported separately and is not included in this balance.
       Losses are determined by the process simulation model according to the configured process logic and loss parameters. The Exporter only collects the resulting loss flow and includes it in the statistical report.This allows the Excel report to show the material balance at both the Process Unit level and, where applicable, for individual Process Lines, providing a direct view of how the incoming material is distributed between products and losses.
       Gas Own Needs (GON) is reported separately as an incoming gas flow that supplies the installation's own needs. The GON value is taken directly from the corresponding flow in the simulation model. The Exporter records and presents the resulting value in the same statistical structure as other Process Unit flows.

       The Excel structure is generated automatically from the Process Unit configuration. Users do not need to define individual rows for inputs, products, destinations, or Process Lines. The Exporter reads the structure of Petroleum Refining Library Process Unit and Process Line objects and reproduces it in the Excel report. The reporting hierarchy expands automatically according to the Process Unit configuration, including additional input streams, products, destinations, and Process Lines. This provides a consistent reporting structure across Process Units with different numbers of inputs, products, destinations, and Process Lines.

       Process Unit statistics can be exported during the AnyLogic simulation or after the simulation has finished. During the run, the Exporter continues collecting data according to the selected time resolution; the accumulated results can then be exported as an Excel report. During a simulation run, the Exporter continues collecting statistics according to the selected time resolution. At the end of the run, the accumulated results can be exported as a complete Excel report. The user receives one consolidated Excel file containing the statistics of the modeled Process Units. This makes it possible to analyze the operation of the entire refinery model in a single report rather than working with separate files for individual installations.

       Statistics from multiple refinery Process Units are combined into one standardized Excel statistics report. Each installation is presented sequentially using the same reporting logic while retaining its own inputs, products, Process Lines, and flow directions. This unified format makes it possible to review the refinery as a whole while retaining the detail of individual installations. Users can sort and filter the exported Process Unit statistics to analyze specific installations, material flows, products, Process Lines, or time periods.

       Process Unit statistics export to Excel provides a standardized way to analyze refinery process simulation data from an AnyLogic simulation. The Exporter preserves the hierarchy of Process Units and Process Lines while reporting input flows, production output, products, losses, GON, and time-based process statistics in a single Excel report. Because the report structure is generated directly from the modeled process, the same export mechanism can be applied across different Process Units without manually rebuilding the report.

1. What is Process Unit statistics export to Excel?
It is the automatic collection of Process Unit and Process Line flow statistics during an AnyLogic simulation and their export to a structured Excel report.

2. What data is included in Process Unit statistics?
The report includes input flows, Production Output, individual products, destinations, Process Line statistics, operating modes, losses, and Gas Own Needs (GON).

3. How are Process Line statistics presented?
Each Process Line is reported with its input, operating mode, output, and associated product flows, allowing the operation of individual technological lines to be analyzed.

4. What time periods are supported?
Process Unit statistics can be aggregated hourly, daily, monthly, or yearly, with the selected time period represented in the Excel report columns.

5. Is GON included in the material balance?
No. Gas Own Needs (GON) is reported separately from the material balance, which consists of input, production output, and losses.

6. Can statistics from multiple Process Units be exported to one Excel file?
Yes. The Exporter combines the statistics of multiple Process Units into one standardized Excel report, while preserving the individual structure of each installation.