Overview & Terminology
DO NOT SKIP THIS
This document is to help you begin using MYGIDE. The steps outlined here are intended to give you a basic understanding of the MYGIDE software and its fundamental aspects.
If you find you are having trouble following this document, do not hesitate to contact us and a member of our team will actively help you with transition.
Working Sections
The key working sections are Dataroom and Poweroom.
Dataroom is for deterministic financial modelling.
Poweroom is a multi-dimensional analytics tool. It is not available with green and purple editions
Database
While working with MYGIDE, you also automatically create and maintain an ms sql or sqlite database in the background. There is no need to press save to store data.
Projects
In MYGIDE we handle databases as Projects. Each Project has its own calculation service that runs in the background independently from other calculation services and synchronises data calculations for other concurrent users.
If something seems strange with your data, check whether the server for your project is on (the colour of the indicator is green).
Model
The model is the building block of MYGIDE. A Model can be anything; an entire company, business unit, product, business function (production, engineering, marketing) or a set of calculations (HR, capex).
Cells
MYGIDE use cells to display data only. All key creation steps are done at project, model or account levels and in bulks steps.
Accounts
A model consists of items that we call Accounts. Accounts can represent anything that can be expressed as a number; data from accounting books, number of employees, and quantities of products, market share or anything that your business model needs to work with.
Statements
Statements help you to organize the inner structure of your model (similar to sheets in Excel). In MYGIDE, however, one Account can be displayed in multiple Statements concurrently with no need to create links.
Accounts can be text formatted which enables you to create distinct statements.
When creating a Statement it is good to assign it not only a name but also a category code, which later makes navigation easier.
Model Accounts is a built-in Statement that shows all the Accounts that were created within its Model. It cannot be deleted, changed or otherwise formatted.
Error Statement is a built-in Statement that is created only when you try to do something which would compromise calculation integrity of your models. It shows all the Accounts that need to be double-checked and fixed, before you are allowed to proceed with the action that triggered this Error Statement to appear.
Timeframe
Timeframe is a model period and time related structure that you can adjust any time.
It identifies the starting year and number of years you wish to work with;
Current year and month – tells MYGIDE calculation engine when to apply formulas applicable to historical data and formulas for future calculations.
Year settings – months – changes from annual data to monthly data.
Year settings – data version – set which data versions shall be calculated by default in a given year. The most frequent set up is Actuals and Forecast. It is not necessary to change it initially. This setting is actually pretty important as it defines what data enters the overall calculation.
See Set Timeframe and Default Model Calculation.
Views
MYGIDE displays data in a time series.
Predefined views are Annual, Monthly, Quarterly and Reporting. Custom views enable you to create your own views.
Reporting view provides monthly, YTD and Annual information on budget performance vs forecast and actual results. It works in the current year only when monthly data is allowed. See Timeframe.
Any formatting done on accounts and statements is applied for all views.
MYGIDE handles data display automatically and you do not need to worry about this when e.g. adding new accounts, data, or assigning formulas.
Data Version
On an individual cell level, MYGIDE works with ‘A’, ‘F’ or ‘B’ standing for actual, forecast and budget. On a model level, you will then see a combination of As and/or Fs and/or Bs.
Default Model Calculation
Default Model calculation is a combination of ‘A’, ‘F’ or ‘B’ as set in Timeframe’s Year settings – data version. It is displayed as ‘D’. ‘D’ is selected by default in Views as it shows the results of the Default Model calculation. Select ‘A’, ‘F’ or ‘B’ only when you wish to see the fragments of the entire model.
Work Place
MYGIDE is best viewed on a resolution of 1920 x 1080 or higher. In order to maximise the user experience and realise the full potential of the application, we highly suggest using two screens when working with MYGIDE.
Many things in MYGIDE are created automatically, created in bulk, or drag and drop enabled to save users’ time.
In each part of the application you can typically display the context menu to see relevant options by clicking the right mouse button.
Although we have some shortcuts, the best would be to start from scratch. We suggest starting with Dataroom functionality as it is easier and pretty similar to what you would find in a spreadsheet.
We would start with a simple model and leave building the ‘cathedral’ model for later.
Just a reminder, anything you will do in MYGIDE will be stored automatically, save for a few actions where we prompt users to press save on purpose.