Home > GIDE Dataroom > Working with Models

Working with Models

A model is an independent, complete data unit. It displays accounts in one or more currencies or various units of measure.

A model can be divided into a user–defined number of permanent or temporary statements. Statements contain groups of interconnected or logically–related accounts, created from model data according to user preference. .

In GIDE, you can create an unlimited number of models, limited only by your access rights and hardware performance.

The following operations are allowed:

 

Creating a New Model

A new model is created in Dataroom. Right–click on the Models tab, and from the context menu select Create Model. A window opens, in which you enter the new model’s name. After you confirm with the OK button, the model appears in the models list.

 

Re–naming a Model

You can re–name a model at any time, by double–clicking on the model whose name you want to change. Save the changed name by pressing the Enter key or clicking outside the Model name area.

 

Deleting a Model

When you right–click on a model, a context menu will appear in the Models window, where you can select Delete Model. This removes the model from the database, and from the models list, including the accounts and statements created within that model. If links to this model exist, they have to be removed before the model is deleted. If this is not done, a window will display explaining that this model cannot be deleted. Accounts related to these links are displayed in the specific Errors statement.

 

Copying a Model

In the Models window, select Copy Model by right–clicking the desired model from the context menu. A window opens, in which you enter the new model’s name. After you confirm with the OK button, the copied model appears in the models list as an independent and autonomous model. This copied model contains all the same settings, formulas and links to other models as the original model copied.

 

Model Properties

This basic model settings are available to you in the working section of Home, in Model Properties.

Information about Model – Here you can edit the model’s Name and Description (on the right side of the work area).

Time Range – Here you can set the model’s time range in years (from lower to upper limits).

Current Periods – This edits the current period. At the yearly or the monthly level, it changes the limits between historical and planned periods. In other words, it switches the current month or year from the plan period to history.

Shifting the model’s time line will cause the following changes:

  • When the year closes, the model’s Time Range will be extended by one year, and what had been the planned year becomes a historical year.
  • When the month closes, what had been the planned month becomes a historical month.
  • When the month closes, what had been the planned month becomes a historical month.
  • Predefinition of formulas in cells take place: in the newly–created history or plan, those formulas will apply which the user assigned originally for the history or plan.

 

Shifting the model’s time line can function the same way but in reverse, by using the function Return to last year or Return to last month.

General – You can set the Number of days in year for a given model, as well as Number of days in month and Model language.

Year Settings – Every year in the model contains at least the annual historical data. By ticking the relevant monthly check box, you can select a model year in which you would also like to work with monthly data. In Data Version, you can select the data set for every year to be calculated by default (Budget, Actual or Forecast).

Copy Budget to Forecast – If you want to copy all values of all accounts established for the budget into the forecast for the current year, you can simply click on the Apply button.

Copy forecast to budget – If you want to copy all values of all accounts from forecast to the following year’s budget, you can simply click on the Apply button.

Copy forecast to strategic plan – If you want to copy all values of all accounts from the annual forecast plan to the strategic plan, you can simply click on the Apply button.

 

Currencies

Under Currencies, in the working section of Home, you can set the basic model menu and the ‘Currency Account’, which serves for calculating all model accounts such that data in financial statements displays in a unified manner.

Model Currency – This shows the currency currently being used for a given model.

Reset Values – By clicking on the arrow, in the roll–down menu you can find available orders of magnitude (in units, thousands and millions). After you click on a value, the order of magnitude will change for all the model’s accounts, except for accounts for which this shift has been blocked.

Change Currency Symbol – By clicking on the arrow, in the roll–down menu you can find available currencies (EUR, USD, etc). After you choose a currency, the currency will change (but the values will not).

Recalculate Model – By clicking on the arrow, in the roll–down menu you can find all available currencies (EUR, USD, etc). After you choose a currency, all the accounts with the original currency are recalculated to the new currency. For the recalculation, the Currency Account and its values must be entered for all the time periods with which you are working, including monthly periods if applicable.

 

Models Management

Models Management is in the Home tab, under Models. It lets you change settings for a group of models all at once and in one place.

 

To change multiple models, mark the group of models by holding down Shift, or to mark all models click on the Mark All icon in the tool bar.

Closing a Year

This function allows you to change the limits between a historical period and plan period at the year level. In the window, mark a specific model, and enter the value or shift the frame using the arrows in the field next to the model. Alternatively, click on the Close Year icon in the tool bar.

Closing a Month

This function allows you to change the limits between a historical period and plan period at the month level. In the window, mark a specific model, and enter the value or shift the frame using the arrows in the field next to the model. Alternatively, click on the Close Month icon in the tool bar.

Activating a Previous Year

This function allows you to change the limits between a historical period and plan period at the year level. In the window, mark a specific model, and enter the value or shift the frame using the arrows in the field next to the model. Alternatively, click on the Previous Year icon in the tool bar.

Activating a Previous Month

This function allows you to change the limits between a historical period and plan period at the month level. In the window, mark a specific model, and enter the value or shift the frame using the arrows in the field next to the model. Alternatively, click on the Previous Month icon in the tool bar.

Changing a Model’s Currency

This function allows you to change the model’s default currency. Mark a specific model in the window, and select the desired currency in the Currency column.

Changing a Numeric Scale

This function allows you to change the model’s default numeric scale. Mark a specific model in the window, and select the desired numeric scale in the Numeric Scale column.

Changing a Data Version

This function allows you to change the model’s data type (Actual, Forecast or Budget) to be displayed in Dataroom for the relevant year. Mark a specific model in the window, and select the desired version of the data in the column for a specific year.

Changing a Time Structure

This function allows you to change the model’s date structure to Yearly or Monthly. Every year in a model contains at least the annual historical data. By choosing Monthly, you can set years for which you also want to work with monthly data. Mark a specific model in the window, and select the desired time structure in the column for a specific year.

Copying Budget into Plan

This function allows you to copy all values for all accounts that have been set for the current year’s budget into forecast. Mark a specific model in the window, click on the arrow by the icon in the tool bar, and from the context menu select Copy Budget to Plan (in the current year).

Copying Forecast into Budget

This function allows you to copy all values for all accounts from forecast into the budget for the following year. Mark a specific model in the window, click on the on the arrow by the icon in the tool bar, and from the context menu select Copy Forecast to Budget (in the following year).

Copying Forecast into Strategic Plan

This function allows you to copy all values for all accounts from the yearly plan into the strategic plan. Mark a specific model in the window, click on the on the arrow by the icon in the tool bar, and from the context menu select Copy Forecast to Strategic Plan.

 

 

People who read this post also read:

Working with Projects Working with Statements Working with Accounts