Excel Unit Operations provide you with the convenience of using a professional spreadsheet directly inside VMGSim. No programming is required, you simply drag the Excel icon from the unit operation palette to add Excel workbooks to the model. Select import/export to attach information from a stream or another unit operation to the worksheet. The Excel operations will behave exactly like any other operation, for example when a value changes that is attached to the spreadsheet the spreadsheet recalculates and results are propagated to the model. There are no limits to the number of Excel worksheets in a model.

In addition, since you are working directly inside Microsoft Excel you have full access to Visual Basic for Applications (VBA) without the need of writing a single line of automation code. If you are used to program spreadsheets using complex cell formulas and macros you can be immediately productive using Excel unit operations.

Some example applications of the spreadsheet operation include:

• Create custom unit models such as well models, reactor models, etc. fully linked in your model
  
• Automatically transfer plant data from your data historian into a VMGSim model
  
• Allocation of oil and gas from a facility that processes fluids from multiple wells with multiple ownership
  
• Create easy to use offline or on line interfaces to you VMGSim model
  
• Create custom models that use thCompressor surge control modeling
  

• General information
• Thermophysical Properties
• Unit Operations
• Acid Gas Treating
• Claus and Tailgas Treating
• Embedded Applications, Customization and Realtime Interfaces
• Reporting Results
• Equipment Rating and Design
• Automation Links to 3rd Party Design Software