🎓
Models University
  • Alpha Testing
    • 👋Welcome to Alpha
    • Installation and Setup
    • Support and Help
    • Terms and Licence
  • Start Here
    • What is Models?
    • Quick start
    • Tutorials
  • Using Taglo Software
    • The Taglo Interface
      • Navigating in Models
      • List Views
      • Adding Items
      • Deleting Items
      • Searching and Filtering
      • Previewing and Editing
      • Using Wizards
      • Save/Undo/Redo
      • Keyboard Shortcuts
    • Data Storage
    • Namespaces
    • Inbuilt data
  • Tags
    • Introduction to Tags
    • Tag Basics
    • Tags Applet
    • Advanced Tags
  • Models
    • Home Tab
      • Creating a Model
        • Timings
      • Version History
      • Application Settings
    • Model Editor
  • Variables
    • Variable Basics
      • Variable Setup
      • Unit and Calculations
    • Time Segments
      • Time Segment Setup
    • Summaries
    • Default Assumptions
  • Units
    • Introduction to Units
    • Key Unit Concepts
    • Advanced Units
    • Defining a Unit
    • Unit Factors
  • Dimensions
    • Introduction to Dimensions
    • Dimension Setup
    • Defining Unit Variance by Dimension
  • Data Types
    • Data Types
  • Assumptions
    • Introduction to Assumptions
    • Creating/Referencing Assumptions
    • Assumptions Wizard
      • Assumption Dates Step
      • Assumption Values Step
      • Linking to external Data
      • Linking to Excel Inserts
      • Sensitivity Values
  • Calculations
    • Introduction to Calculations
    • The Calculation Page
      • The Formula Entry Bar
      • Unit Analysis
    • Calculation Parts
      • Variable References
        • Referencing Time
        • Referencing Dimensions
        • Lookups
        • Summarising Variables
      • Period References
      • Functions
        • Advanced Functions
  • Aggregation
    • Introduction to Aggregation
    • Creating Aggregations
  • Rearranging
    • Introduction to Rearranging
    • Rearranging Example
    • Rearranging Tips
  • Cases
    • Introduction to Cases
    • Managing Scenarios
    • Managing Sensitivities
  • Layout
    • Generating Excel
    • Auto Layout
    • Sheets
      • Sheet Content
      • Adding and Editing Content
    • Excel Formatting
      • Excel Themes and Styles
      • Line Formatting
    • Data Tables
    • Excel Generation Troubleshooting
  • Excel Inserts and Outputs
    • Excel Inserts
    • Excel Outputs
  • Number Formats
    • Number Formats
  • Dashboards
    • Dashboards Basics
    • Dashboard Layout
    • Dashboard Items
    • Excel Dashboards
  • Metrics
    • Metrics
  • Charts
    • Introduction to Charts
    • Chart Customisation
  • Importing Models
    • Importing Models
  • Data
    • Introduction to Data
    • Creating Data
    • Data Sources
Powered by GitBook
On this page
  • Overview
  • Importing a Model
  • Replacing Variables
  • Creating Template Models
  • Make all Assumptions Constant
  • Make the Model independent of Interval Type
  1. Importing Models

Importing Models

How to save time and improve quality by re-using Models

PreviousChart CustomisationNextIntroduction to Data

Last updated 1 year ago

Overview

allows you to take an existing Model, and duplicate it inside another one. In this way you can create templates for commonly re-used sections, generating huge time-savings and improving consistency of your Models.

Importing a Model

The process for importing a Model is straightforward: simply navigate through the menu to Edit > Import Model. This will open a wizard showing available Models to import. Select the Model you want to import, and it will be duplicated and inserted into your Model, including its Layout and Dashboards.

Only Models within available will be shown. Before importing, make sure that your Model's Namespace references the Namespace of the Model you want to import.

Replacing Variables

When importing a Model, you will often want to connect it to the structure of your current Model. This can be done manually, by editing Calculations in the imported Model, but Models provides a shortcut for this process, the Replace Variable function.

In the example below, we have a Variable, Revenues (2), in our current Model, which reflects the specific revenue line of the business that we are modelling. When we import the Financial Statements template Model, a second placeholder Revenues Variable (1) is added. We want to override all instances of this second Revenues Variable with our original. To do so, we perform the following:

  • Select the new Revenues Variable

  • Press the Replace button

  • Select the original Revenues Variable, and press Finish

Note that after we replace the new Variable, it appears as a top-level node in the Variable tree-view (4), because it is no longer referenced by any other Variables. This tells us that it is safe to delete.

Creating Template Models

You can import any Model into any other Model. However, if there are Models you want to use only as Templates, like the Financial Statements Model in the examples above, there are steps you can take to make them easier to import - we list some of these below.

Make all Assumptions Constant

This can be achieved in two ways:

  • For any Assumptions Variable that is genuinely Constant (e.g. Number of months per year), make sure the Unit is Constant

It is not always possible to make all Assumptions Constant. For instance, if you had a template Model including a country's population over time, the population figures would reflect specific points in time. In this case, you will just need to add or remove Assumptions after importing to update the Variable in question to the Timings of the new Model. Time Segment warnings will help you determine where updates need to be made.

Make the Model independent of Interval Type

To ensure that a template Model will work across multiple Interval Types, you should use time conversion Variables, as shown in the example below.

Here, our template Model is in Years, but instead of just using the Variable Years of depreciation/amortization directly in our depreciation calculation, we first convert it into a time-generic Variable, Periods of depreciation/amortization using a conversion Variable of Periods per year. In our template Model, Periods per year has a constant value 1, but if we import it into a Model with Interval Type Months, we can simply change the value of the Periods per year Assumption to 12 and our Model will work as intended.

All instances of the new Revenues Variable have now been replaced (3), including in and the . We can now remove the new Revenues Variable and associated .

Generally a template Model will have different from the Model you want to import it into. That means it's a good idea to use a for any Assumptions in the template Model - this way, when you import the Model, it will be immediately fully-working, regardless of the Timings of the target Model.

For any Assumptions Variable that is not Constant, but acts as a placeholder for a Variable in the target Model (e.g. Revenues), use a single . Default Assumptions are always of Constant Unit.

A template Model may have a different from the Model you want to import it into (e.g. a template Model in Years imported into a Model in Quarters).

Dashboards
Layout
Assumptions
Timings
Constant Unit
Default Assumption
Interval Type
Models
Namespaces
Replacing a Variable
Using time conversion Variables to make a template Model compatible with different Interval Types