Home > GIDE Dataroom > Modelling and Data Simulation

Modelling and Data Simulation

Modelling is a process during which the user changes modelling parameters for the purpose of estimating the development of an account during the modelling period. The term Account Modelling means the user’s working with the calculation of account values as follows:

  • by Manual Input of the account’s value
  • manually inputting forecast calculation of the account’s value. Examples of this, depending on the type of calculation, include a manual forecast rate of increase between two periods, a manual forecast percentage of share compared to another account, etc

 

Modelling account values is only available to users with the appropriate user rights and working mode in GIDE.

Modelling (i.e. changing values or derived auxiliary parameters, such as rate of increase and the like) can only be active for a user if the given account is not marked Restrict Modelling in the Account Properties tool bar.

 

Manual Input

The user can change a calculation in the Dataroom working section, in the main work area, directly in the cells of the relevant line of the modelled account. After you input a value for a period, the values of subsequent periods for the given account will automatically be calculated using that formula.

Double–clicking on a specific cell allows you to enter values. You can save this value by pressing any of the arrow keys or the Enter key, or clicking on any other cell in the main work area.

Tip: You can also manually input values to external accounts, i.e. accounts of another model. Right-click on an external account and from the context menu select Edit External Account. You can then change the external account’s values just like one of the model’s accounts.

 

Manual Input of Forecast

Modelling account values using forecasts is available in the Assumption Detail window, in the Dataroom working section. Clicking on the desired account will display Auxiliary Rows (if any have been assigned) in the Assumption Detail window. After you input a value for a period, the values of subsequent periods for the given account and forecast will automatically be calculated using that formula.

Mark the account for which the Auxiliary Row has been assigned, and double–click on a specific cell to input a value. You can save this value by pressing any of the arrow keys or the Enter key, or clicking on any other cell in the main work area or the Forecast window.

 

Resetting Formulas

Setting initial account values according to the formula used is available in the working section Dataroom, in the main work area. Right–click on the desired account and from the context menu select Reset Formulas. All manually–set values or forecasts will be erased and replaced with calculations in accordance with the function used.

Tip: If manual import of values is set for some of the given account’s period, these values will be erased and become zero.

 

People who read this post also read:

 

Importing Data from a Local File Displaying Account Parameters & Modelling Rows Snapshots