Tank Farm Statistics Export to Excel in AnyLogic

       Tank Farm Statistics Export to Excel in AnyLogic provides a standardized way to analyze tank farm simulation results from an AnyLogic refinery simulation. The Exporter automatically collects Tank Farm flow, residual, and tank storage statistics and organizes them into a structured Excel report. Statistics are aggregated by hour, day, month, or year and include input flows, product shipments, losses, total ending residuals, and individual tank residuals and states. This allows users to analyze Tank Farm operation at both the overall and tank level. The Exporter collects statistics generated by the Petroleum Refining Library during the simulation without modifying the modeled flows or process logic.

       The Excel report starts with the Input Tank Farm, total and Product Shipment, total for each Tank Farm. The total values provide an overall view of the tank farm material flows and can be broken down into individual input and shipment streams according to the actual flow structure of the simulation model. For example, a Tank Farm can have multiple incoming streams and multiple product shipment flows. Each flow is presented as a separate entry in the Excel report, while the corresponding total provides an overall view of the Tank Farm operation. This structure makes it possible to analyze both the total material flow through the Tank Farm and the individual streams contributing to the result.

       At the Tank Farm level, the report shows total input, individual input flows, total product shipment, individual shipment flows, losses, and total ending residual. The report then provides tank-level information, allowing the residual of each tank to be tracked across the same reporting periods. The columns represent the selected reporting periods, while the rows contain the corresponding Tank Farm statistics. At the Tank Farm level, the report shows total input, individual input flows, total product shipment, individual shipment flows, losses, and total ending residual. The report then provides tank-level information, allowing the residual of each tank to be tracked across the same reporting periods. This structure provides a direct connection between overall Tank Farm performance and the condition of individual tanks. Changes in the Total ending residual can therefore be analyzed together with changes in individual tank residuals and tank states.

       The Tank Farm report shows the Total ending residual for each reporting period, providing a direct view of the tank farm material balance. This value represents the total amount of material remaining in all tanks at the end of the reporting period. The report also includes Loss, total, which represents the total losses from the Tank Farm during the corresponding period. Together with input and product shipment statistics, these values provide a view of the Tank Farm material balance and changes in stored material over time. For detailed analysis, the total ending residual can be examined at the individual tank level.

       The Excel report also provides detailed tank-level statistics for individual storage tanks within the Tank Farm. Each tank is presented separately, allowing users to track its ending residual across the selected reporting periods. For each tank, the report also includes its State, showing the tank's operating state for the corresponding reporting period. This provides a more detailed view of Tank Farm operation and makes it possible to analyze changes in individual tank residuals together with their operating states.

       Time-based Tank Farm statistics allow users to track how material flows, shipments, losses, and tank residuals change across reporting periods. Users can compare input and shipment volumes across reporting periods and track how the total residual changes as material enters and leaves the Tank Farm. At the tank level, the same time-based structure allows users to follow changes in individual tank residuals and states and relate them to changes in the total Tank Farm residual. This is particularly useful when analyzing how material is distributed between tanks during different stages of the simulation. By combining aggregate Tank Farm statistics with detailed tank-level data, the Excel report provides a consistent view of both overall material movement and individual tank operation.

       Tank Farm statistics can be exported to Excel during an AnyLogic simulation or after the simulation has finished, providing a consolidated Excel report of the simulated tank farm operation. During the simulation run, the Exporter continues collecting statistics according to the selected time resolution. At the end of the simulation, the accumulated results can be exported as a single Excel report containing the Tank Farm statistics for the modeled period.

       Statistics from multiple Tank Farms in a refinery simulation can be combined into a single standardized Excel report. Each Tank Farm is presented separately while preserving its input flows, product shipment flows, losses, ending residuals, and individual tank statistics. This unified format makes it possible to analyze multiple Tank Farms in one report while retaining the detailed structure of each tank farm.

       The Excel report also provides a detailed view of material distribution across individual tanks during the simulation. The overall Input Tank Farm, total and Product Shipment, total show the main material flows, while the Total ending residual provides the total amount remaining in the Tank Farm. The tank-level statistics provide additional detail by showing the residual of each individual tank. This allows users to compare residual levels between tanks within the same reporting period and track how material distribution changes over time. Combining Tank Farm-level and tank-level statistics provides a detailed view of material distribution without requiring separate reports for individual tanks.

       Tank Farm Statistics Export to Excel in AnyLogic provides a standardized way to analyze tank farm simulation results and tank-level operation in a structured Excel report. The Exporter preserves the structure of the modeled Tank Farm while reporting input flows, product shipments, losses, ending residuals, and detailed tank-level statistics. By combining Tank Farm input and shipment statistics, losses, total ending residuals, and individual tank residuals and states, the report provides a consistent view of Tank Farm operation throughout the simulation.

1. What is Tank Farm Statistics Export to Excel in AnyLogic?
It is the automatic collection of Tank Farm flow and tank-level statistics during an AnyLogic simulation and their export to a structured Excel report.

2. What data is included in Tank Farm simulation statistics?
The report includes input flows, product shipment flows, losses, ending residuals, individual tank residuals, and tank states.

3. How are Tank Farm input flows presented?
Input Tank Farm, total can be broken down into individual incoming flows according to the actual flow structure of the simulation model.

4. How are product shipments presented?
Product Shipment, total can be broken down into individual shipment flows, allowing different products or material streams to be analyzed separately according to the Tank Farm flow structure.

5. What is Total ending residual?
Total ending residual represents the total amount of material remaining in all tanks in the Tank Farm at the end of the reporting period.

6. Are individual tank statistics included in the Excel report?
Yes. The report provides statistics for individual tanks, including their ending residual and State across the selected reporting periods.

7. What time periods are supported for Tank Farm simulation statistics?
Tank Farm statistics can be aggregated hourly, daily, monthly, or yearly. The selected time period is represented in the Excel report columns.

8. Can statistics be exported during or after the simulation?
Yes. The Exporter can collect statistics during the AnyLogic simulation, and the accumulated results can be exported to Excel after the simulation has finished.

9. Can multiple Tank Farms be exported to one Excel report?
Yes. Statistics from multiple Tank Farms can be combined into a single Excel report while preserving the individual structure of each Tank Farm.