Aspen Simulation Workbook™
Deploy models and automate conceptual design workflows using Microsoft® Excel
Aspen Simulation Workbook provides easy and robust integration between AspenTech’s process simulators and Microsoft Excel, allowing you to deploy models to a wider range of users without writing a single line of code. As a core element of AspenTech’s aspenONE® Engineering applications, Aspen Simulation Workbook is tightly integrated with the Aspen Plus®, Aspen HYSYS®, Aspen Custom Modeler®, and the Aspen EDR product families.
Features
- Rapidly Develop User Interfaces: Enables rapid development of Excel-based user interfaces to your process simulation or heat exchanger models without programming. Users follow a simple copy/paste workflow to attach model variables to tables in Excel. The interfaces can be enhanced with buttons and other form controls to make it easy to initialize, run, and view the results within Excel.
- Link Models to Plant Data: Plant data tags can be linked to Excel using the standard features of most process historians.
- Run Scenarios: Leverage Aspen Simulation Workbook’s Scenario Table feature to rapidly run hundreds of scenarios through your model to analyze historical data, analyze process sensitivity, check design cases, etc.
- Full Support for Dynamic Models: Develop interfaces to batch models or dynamic models of continuous processes and display the model results in profile tables or Excel-based strip charts. Users can interact with the models as they run and see the results in real-time.
- Workflow Automation: Easily automate repetitive tasks, such as extracting data from simulations to rapidly generate reports and charts using Microsoft Excel.
- Link Models to Third-Party Tools: Nearly all engineering and analysis tools can be linked to MS Excel; with Aspen Simulation Workbook you can link your models to these tools using Excel as an integration environment. Typical applications include linking models to risk management software, equipment design tools, Monte-Carlo optimization engines, or cost estimation tools.
Related Products
Aspen Simulation Workbook is compatible with the following products:
- Aspen Plus®, including Aspen Polymers, Aspen Rate-Based Distillation, and Aspen Plus Dynamics® (all simulation modes)
- Aspen HYSYS®, including Aspen HYSYS Dynamics™ and Aspen HYSYS Upstream™ options
- Aspen HYSYS Petroleum Refining, including reactor calibration environments
- Aspen Custom Modeler® and related products, including Aspen Adsorption and Aspen Chromatography (all run modes are supported)
- Aspen HTFS+™-based products including Aspen Shell & Tube Exchanger, Aspen Air Cooled Exchanger, Aspen Plate Exchanger, and Aspen Shell & Tube Mechanical
- Aspen Simulation Workbook is designed to work closely with Aspen Online Deployment™, enabling continuous on-line deployment of process models into plant operations.
Benefits
Customers have reported significant benefits from deploying models into operations using Excel-based model interfaces. Typical benefits include:
- Up to 5% increases in throughput resulting from improved operations
- Better operator decisions resulting in greater product consistency
- Up to 10% reduced energy use by avoiding over-refluxing columns
- Months of saved labor by avoiding the need to use Visual Basic programs