Model Blocks in Capex Strategy

Model Blocks are fundamental components used to define calculations and manage data within the Weissr model structure. This document provides an overview of their functionality, structure, and types.

What Is a Model Block?

Capex Strategy specific Blocks

A Model Block defines the calculations for specific node types in the Weissr hierarchy. It enables:

• Aggregation of data from lower levels of the hierarchy to higher levels.

• References to other blocks by following specific referencing rules.
  

1. Blocks connected to node hierarchy in Capex Strategy

   1. Division Blocks (Type 50)

      1. Represent Division nodes.

      2. Automatically assigned.

      3. Limited to one per project.

   2. Mill Blocks (Type 40)

      1. Represent Mill nodes.

      2. Automatically assigned.

      3. Limited to one per project.

   3. Sub-Industry Blocks (Type 20)

      1. Represent Sub-Industry nodes.

      2. Automatically assigned.

      3. Limited to one per sub-industry defined in the project administration.

      4. In the project, Sub-Industry blocks and their sub-blocks resolve into a single sheet, though they are presented as separate entities in the builder.

   4. Machine Subindustry Sub-Blocks

      1. These blocks are manually created and assigned to Category nodes in the project. Each block can have its unique set of rows.

      2. Types:

         1. Machine Block

            1. Represent Machine nodes.

            2. Data flows from the Machine level upward in the hierarchy.

         2. External data Block

            1. Extra sheet specifically designed to cater to Categories with Machine blocks assigned to add data carousels

   5. Material Subindustry Sub-Block

      1. Automatically replicated for each material handled.

      2. All materials share the same rows within the scope of one Material Sub-Industry.

      3. Material blocks are automatically created and assigned alongside the Material Sub-Industry block.
         

2. Additional model blocks in Capex strategy

   1. Settings Blocks

      1. Define global settings for the model, such as prices, volumes, and reference data.

      2. Automatically include exchange rate rows at the end.

      3. Only one Settings Block exists per project.

   2. System-Generated Blocks

      1. Created automatically based on user-defined blocks:

      2. Group Blocks.

         • Exact copy of Division block.

         • Cannot be edited by users.

         • Appear at the group level inside the project.

      3. Sensitivity Blocks (Standard and Ad-Hoc)

         • Generated as part of the Sensitivity function.

         • Use predefined (Standard Sensitivity) or user-created (Ad-Hoc Sensitivity) parameters for rows with Sensitivity options enabled.

Capex Management blocks

• Represent models used in Capex Management (CM).

• Consist of single-sheet blocks with no referencing allowed outside the block.

Assigning Model Blocks

Assigning Model Blocks in Capex Strategy

• Once the organizational structure is defined in the project scope, automatically assigned blocks generate sheets in the Cash Flow Model module.

• These sheets translate expressions built in the Model Builder into Excel formulas.

Assignment Types

1. Type 50 (Division), Type 40 (Mill), and Type 20 (Sub-Industry) Blocks:

   • Automatically assigned to the respective nodes.

2. Type 20 Sub-Blocks:

   • Machines: Assigned manually to categories by the user.

   • Materials: Assigned automatically and filtered using material filters.

3. Settings Block:

   • Always available, even if no rows are added.

   • By default, includes exchange rates for all currencies used in the project administration.

Assigning Investment model in Capex Management

• In each request, the Investment Model is assigned via the Model property on forms.

• The Model property automatically displays all Model Blocks available in the project under the current strategy (indicated by a green checkmark in the project list).

• Once a Model Block is selected, the Investment Model sheet becomes accessible under a designated menu item within the project.

For more details, visit: Investment Model Documentation.