Simulation Event

The Simulation event allows you to execute Excel Data Table simulations directly within a SpreadsheetWeb application. This event is automatically activated when a workbook containing one or more Data Tables is uploaded to the Designer.

Unlike other event types, the Simulations event does not appear as a separate module in the Designer interface. Instead, it becomes available only when the system detects Data Tables in your Excel file.

Behavior

Once the system identifies the Data Tables feature in your workbook, a Simulations event is added to the list of available events in the Designer. You can then bind this event to a button control.

When the associated button is clicked during application runtime, SpreadsheetWeb executes all simulations corresponding to the formula cells that reference Data Tables in the underlying Excel file. The results are then automatically displayed in the application’s user interface.

Usage Notes

• The Simulations event can only be triggered through a button click.
• It cannot be executed automatically or through autocalculations.
• Multiple Data Tables within the same workbook will all be processed when the event is triggered.
• Simulation results update dynamically in the app interface after the calculations are complete.

Example

To enable and use the Simulations event:

1. Include one or more Data Tables in your Excel workbook.
2. Upload the workbook to your SpreadsheetWeb Designer workspace.
3. Once detected, the Simulations event becomes available.
4. Add a button control and bind the Simulations event to it.
5. At runtime, clicking the button will execute all simulations and display the results on screen.