Step 4: Solve the RASON Simulation model
With the BusinessForecast.json tab selected, solve the model by clicking Solve RASON Model, in the bottom left corner. Solving the model runs the simulation, generating values for each uncertain variable across all trials and computing the resulting outputs.
Figure 4: Click Solve RASON Model to run a simulation
Step 5: Console Panel
After clicking Solve RASON Model, the Console pane appears and displays information about the solve process as well as the results ready for export. Upon successful completion, the console displays a message such as “Simulation finished successfully.”, indicating that the simulation was successful.
When the model is executed in the RASON Desktop extension, within Visual Studio Code, the solve process is performed on the RASON.net server. The model and its associated data are sent to the server, where the simulation is carried out, and the results are then returned to the RASON Desktop extension. This is true even when RASON Solver Mode is set to Local.
Figure 5: Console pane showing solver progress and the final message indicating that the simulation was successful.
Step 6: View the Results
RASON Desktop returns results as dataframes, structured tables of data made up of rows and columns, beneath Solver Results in the Console tab.
Each dataframe represents a specific part of the model output. For example, in a simulation model, statistics such as mean, standard deviation, percentiles, or a list of all trial values. These dataframes are generated automatically when the model is solved and can be viewed directly in the VS Code extension, by clicking View, or they can be exported to Microsoft Excel or Microsoft Power BI.
Figure 6: CSV file containing newProfit_trials dataframe
Figure 7: Solver Results as shown in the Dataframe viewer
The simulation results include the mean and target(100000) statistics for the uncertain function, newProfit, in addition to the values for this uncertain function in each of the trials. Recall that these statistics and trial values are included in the results because they were explicitly specified as properties in the RASON model. Note: The model is configured to run 1000 trials, meaning the simulation generates 1000 possible outcomes. For more information on how to model a simulation model using the RASON modeling language, see the RASON User Guide.
Click View next to newProfit_statistics to view the two statistics requested in the RASON model: mean and target(100000). Click View next to newProfit_trials to view all 1000 trial values for this uncertain function. The first 10 are displayed here.
Figure 8: Output displayed in JSON form
Step 7: Export Results to Microsoft Power BI or Excel
As discussed earlier, RASON Desktop is designed to integrate fully with both Power BI and Excel. The extension connects directly to active instances of these applications, allowing you to read inputs and write results without leaving VS Code. Once your RASON model is complete, you can export the entire model to Power BI or Excel and solve it entirely within those environments, without needing to return to Visual Studio Code.
Next: Export the Results
Continue to the next page to export the results from RASON Desktop into Microsoft Power BI or Excel for reporting and visualization.