Product Mixer Statistics Export to Excel in AnyLogic Refinery Simulation

       Exporter Series:
       1 Export Simulation Results to XLSX: Complete Guide
       2 Source Exporter in AnyLogic: Export Source Statistics to Excel
       3 Process Unit Statistics Export to Excel in AnyLogic
       4 Tank Farm Statistics Export to Excel in AnyLogic
       5 How to Add Custom Rows to an AnyLogic Exporter Report
       6 Petroleum Refining Library Exporter: Configuration, Reporting and API
       7 Custom Flow Statistics in AnyLogic Refinery Simulation
       8 Product Mixer Statistics Export to Excel in AnyLogic Refinery Simulation

       Product Mixer statistics export to Excel in AnyLogic enables engineers to analyze product output, additive consumption, and blending performance in petroleum refining simulation models. The Petroleum Refining Library provides a dedicated ProductMixerExporter that converts recorded Product Mixer statistics into a structured Excel (XLSX) report, including product-level output mass and separate additive time series for detailed refinery blending analysis.
       The Petroleum Refining Library implements this functionality through two cooperating components. ProductMixerExportStatistics records time-series data for output flows and additive-related quantities at each simulation step, while ProductMixerExporter organizes the collected data into structured Excel rows. This separation of data collection and report generation provides a consistent approach to refinery blending simulation reporting, making detailed results accessible for analysis in Excel without manually extracting data from the AnyLogic model. The exporter also supports custom product names and additional rows, allowing users to customize Excel reports to meet specific refinery reporting requirements.

       The Petroleum Refining Library separates Product Mixer statistics collection from Excel report generation. The ProductMixerExportStatistics class records time-series data during simulation execution, while ProductMixerExporter retrieves eligible Product Mixer objects and writes their statistics to an XLSX worksheet. The exporter applies configuration settings, respects object exclusions, and prevents duplicate exports. For each eligible mixer, it generates the total-output row, exports detailed output data, writes additive statistics, and appends configured additional rows. This architecture provides a consistent mechanism for exporting Product Mixer simulation results to Excel in AnyLogic, separating statistics collection from XLSX report generation.

       The Product Mixer exporter records output mass by product identifier and calculates an aggregate output series across the recorded product streams. This Excel export provides both total output statistics and product-level output data, enabling engineers to analyze blending performance and track changes in petroleum product production throughout the simulation. When total-output export is enabled, the corresponding Excel row combines the recorded output series with the recorded product-additive, input-flow-additive, and balance-additive values for each simulation step. The resulting aggregate provides a consolidated reporting metric, while the product-level series preserve the detail needed to investigate changes in blending output.

       The Product Mixer exporter records additive consumption statistics in three categories: additives incorporated into the resulting product, additives introduced through input flows, and the balance additive. These separate time series allow engineers to analyze additive usage in petroleum product blending and distinguish the contributions included in the reported total output. Input-flow additive quantities are aggregated by additive identifier across the relevant input streams. Balance-additive statistics are recorded only when the Product Mixer operates in automatic mode, balance-additive inclusion is enabled, and a valid balance-additive identifier is configured. Each recorded additive series is written to a separate Excel row, allowing engineers to analyze additive contributions independently.

       The Product Mixer Excel report organizes each mixer into a structured block containing total-output statistics, product-level output data, and additive consumption series. Values are aligned across columns by simulation step, enabling time-series analysis of blending results in Excel. The shared exporter infrastructure also supports custom report rows and product-name overrides, allowing the report to be adapted to specific refinery reporting requirements. The shared exporter infrastructure also supports custom report rows and product-name overrides. Additional rows can be configured for placement at the end of a Product Mixer block, while product-name overrides allow customized names to appear in the report instead of default product names. These features make it possible to adapt the exported report to specific refinery reporting requirements.

       Product Mixer statistics export to Excel supports refinery blending analysis by making product-level output and additive consumption data available outside AnyLogic. Engineers can use the exported time series to investigate blending performance, review additive usage, compare separately exported simulation scenarios, and prepare production reports. Combined with Process Unit, Tank Farm, and Source exporters, Product Mixer reporting contributes to a more comprehensive analysis of refinery material flows and production operations.

       Product Mixer statistics export to Excel in AnyLogic refinery simulation provides engineers with time-series data for analyzing product output, additive consumption, and blending performance. The Petroleum Refining Library exporter combines aggregate output statistics, product-level mass data, and separate additive series in a structured XLSX report, supporting detailed refinery blending analysis. Integrated with the Petroleum Refining Library exporters for process units, tank farms, and feedstock sources, this functionality supports comprehensive refinery simulation reporting and analysis of material flows and production operations.

1. What Product Mixer data can be exported to Excel in AnyLogic?
The Petroleum Refining Library exports total output statistics, output mass by product, product additives, input-flow additives, and balance-additive statistics when the relevant recording conditions are met.

2. How does the Product Mixer exporter track additive consumption?
The exporter records separate time series for additives incorporated into the resulting product, additives introduced through input flows, and the balance additive when its recording conditions are satisfied. These data support detailed additive consumption analysis in Excel.

3. Does the Product Mixer exporter support automatic blending?
Yes. Balance-additive statistics are recorded when the Product Mixer operates in automatic mode, balance-additive inclusion is enabled, and a valid balance-additive identifier is configured.

4. How are Product Mixer statistics organized in the Excel report?
The report organizes total-output statistics, product-level output data, and additive series into structured rows aligned by simulation step. Custom rows and product-name overrides are also supported by the shared exporter infrastructure.

5. Can exported Product Mixer statistics be used to compare refinery blending scenarios?
Yes. Exported time-series data can be analyzed in Excel to investigate product output, additive consumption, and blending performance. Comparing scenarios requires separately exported results for the corresponding simulation runs.