Data Modella
  • Introduction
  • Concepts
    • Models
    • Calendar
    • Lists
    • Structure
    • Scenarios
    • Inputs
    • Variables
    • Capital
    • Elements
      • Fixed
      • Variable
      • Event
      • Matrix
    • Templates
    • Schedule
    • Pivot Views
    • Calculator
    • Actuals
  • Explanations
    • Tag Matching
    • MARC Costing
  • FAQs
    • Common FAQs
    • Support and Feedback
  • Blog
    • Improved Calculator and Variable System
    • New Inputs Page
  • Tutorials
    • Using the PowerBI Connector
    • The Building Blocks
    • Elements and the Rule of Four
Powered by GitBook
On this page

Was this helpful?

  1. Concepts

Schedule

PreviousTemplatesNextPivot Views

Last updated 7 months ago

Was this helpful?

The Schedule is the primary output of a scenario for a model. It is the result of applying the inputs for a particular scenario against the structure and configuration of a model.

There are two primary aspects to the schedule. First there is the Pivot View which defines the List Hierarchy of the model, which is the same hierarchy built in the Structure area. And Secondly the Calculated Period Values which show the values for each cost element and respective sum for each list item in the hierarchy.

Using Pivot Views with the schedule you're able to analyze costs across any list in the model. In our example above you could pivot aground the Oganisation, Equipment or Employee Type lists. Costs Elements will be automatically placed into the appropriate sections of the hierarchy.