Welcome to THETAWIKI. If you like to create or edit a page please make sure to login or register an account. All registered users please make sure to provide a valid email address.

Excel Bridge

From ThetaWiki
Jump to: navigation, search

What is the Excel Bridge?

Runthisathome logo.png

The Excel Bridge is the esiest way to run a model at home. Any model marked with the "Run This At Home" icon can be run directly from within your Excel. You only need to install the Excel Bridge add-in into Excel.

There are two ways to start your simulations. You can run the prepared models from our wiki. All the simulations are performed in our Thetaris cloud. Alternatively, you can download and install the Theta Suite XL and create your own simulation models. In that case, your models are calculated locally, completely independent of the Thetaris cloud.


Installation


Ready to use models

There is a list of ready to use models. Each model is extensively documented in this wiki. You can run them after installing the Excel Bridge. If you want to modify these models you can install the Theta Suite to do so.


How to use the Excel Bridge

You can either create your own Excel sheet or use one of the Excel sheet templates we already prepared for you as part of the Excel Bridge package. For example, you can open an empty Excel workbook and follow the steps below:

The Excel Bridge Toolbar

After installation a new entry is shown in your Excel ribbon: Thetaris. From there you can connect to a running Theta Suite installation. By default you are direcly connected to our Theta Suite cloud service.

To trigger your own simulation you can start and select an empty cell in your Excel work sheet. Then press the "Run ThetaSuite" button in the "Thetaris" tab of the ribbon.

caption


The Excel Bridge Configurator Window

With a click on the "Run ThetaSuite" button, the Theta Configurator window appears. If you have not yet done so, we must first configure the ThetaML script containing your model. Simply type the web address of the online model, then press the "OK" button. Using a locally installed Theta Suite, you could also simply open a file from your hard disk.

In this example, the model we use is to calculate the sum of two input parameters.

caption

This example assumes that the referenced file is a simple ThetaML model with the following content:

model SumOf2
    import a "the first parameter"
    import b "the second parameter"
    export x "the sum of a and b"
 
        x = a + b
end


Select Your Model

Because ThetaML files may contain multiple models, we must click the combo box and select the model we want to run. In our example this is the model "SumOf2". Again, the model can export multiple variables. We choose the output as "x". The other combo box offering "scenario" or "mean" refers to the choice between output types that is relevant for Monte Carlo simulations.

caption


Set Your Parameters

In order to set all the parameters, we can either simply type the proper value in the text box or select a value from Excel by pressing the button right of the text box and selecting the cell to reference.

caption


See Your Simulation Result

After all the parameters are set up, press the "OK" button. This action closes the configurator window and sets a new formula in the Excel cell, something like "=ThetaCall(…)". As a matter of fact, you could have directly typed that formula into the cell, but that would have been more complicated. Anyway, the formula is in the cell now and Excel triggers its execution. Depending on the complexity of your model and our cloud speed we wait a certain time for the calculation to complete. As expected the value 5 appears in the cell.

caption