axmo: '1.0'
name: Walkthrough demo
description: The finished model from the "Build your first model" guide on axmo.it
exportedAt: '2026-09-17T03:55:58.953Z'
dimensions:
  Company:
    type: categorical
    layers:
      - Top_Company
      - Directorate
      - Department
    tree:
      All_Company:
        Alpha:
          - Alpha-1
          - Alpha-2
        Beta:
          - Beta-1
          - Beta-2
          - Beta-3
  Time:
    type: sequential
    sequentialType: axmo_time
    parameters:
      selected_levels:
        - year
      start: '2024'
      end_mode: end_point
      end: '2027'
series:
  Average Salary:
    type: calculated
    formula: Staff Cost / Headcount
    dimensions:
      - Company:
          rollUp: FORMULA
      - Time:
          rollUp: FORMULA
  Average Salary Change To Previous Year, %:
    type: calculated
    formula: IF(Year@ <> 1, (Average Salary - Average Salary[Year[-1]]) / Average Salary[Year[-1]])
    dimensions:
      - Company:
          rollUp: FORMULA
      - Time:
          rollUp: AVG
  Headcount:
    type: calculated
    formula: Nz(Headcount[Year[-1]], 0) + Joiners Persons - Leavers Persons
    dimensions:
      - Company:
          rollUp: SUM
      - Time:
          rollUp: AVG
  Joiners Persons:
    type: input
    dimensions:
      - Company
      - Time
  Joiners Salary:
    type: input
    dimensions:
      - Company
      - Time
  Leavers Persons:
    type: input
    dimensions:
      - Company
      - Time
  Leavers Salary:
    type: input
    dimensions:
      - Company
      - Time
  Staff Cost:
    type: calculated
    formula: Nz(Staff Cost[Year[-1]] * (1 + [Year End Salary Increase, %][Year[-1]]), 0) + Joiners Salary - Leavers Salary
    dimensions:
      - Company:
          rollUp: SUM
      - Time:
          rollUp: AVG
  Staff Cost Change To Previous Year, %:
    type: calculated
    formula: IF(Year@ <> 1, (Staff Cost - Staff Cost[Year[-1]]) / Staff Cost[Year[-1]])
    dimensions:
      - Company:
          rollUp: FORMULA
      - Time:
          rollUp: AVG
  Staff Cost Share:
    type: calculated
    formula: Staff Cost / Staff Cost[All_Company]
    dimensions:
      - Company:
          rollUp: FORMULA
      - Time:
          rollUp: FORMULA
  Year End Salary Increase, %:
    type: input
    dimensions:
      - Time:
          rollUp: NONE
dataSources:
  Department Year data:
    sourceType: excel-range
    rangeRef: InputData!A1:F21
    hasHeaders: true
    shape: table
  Salary Increase Data:
    sourceType: excel-range
    rangeRef: InputData!I1:J4
    hasHeaders: true
    shape: table
dataLoaders:
  loader_1:
    type: seriesLoader
    source: Department Year data
    loadMode: table
    targets:
      - target: Joiners Persons
        valueColumn: Joiners Persons
        duplicateHandling: BLOCK
      - target: Joiners Salary
        valueColumn: Joiners Salary
        duplicateHandling: BLOCK
      - target: Leavers Persons
        valueColumn: Leavers Persons
        duplicateHandling: BLOCK
      - target: Leavers Salary
        valueColumn: Leavers Salary
        duplicateHandling: BLOCK
    dimensionMappings:
      Company:
        column: Department
      Time:
        column: Year
  loader_2:
    type: seriesLoader
    source: Salary Increase Data
    target: Year End Salary Increase, %
    loadMode: table
    valueColumn: YE Salary Increase
    duplicateHandling: BLOCK
    dimensionMappings:
      Time:
        column: Year
outputRanges:
  Staff Cost report:
    cell: Report!A1
    rowDef:
      blocks:
        - dimensionAll: Company
        - series: Headcount
          format: '0'
          newLine: true
        - series: Staff Cost
          format: '#,##0'
        - series: Average Salary
          format: '#,##0'
        - series: Staff Cost Share
          format: 0%
        - series: Staff Cost Change To Previous Year, %
          format: 0.0%
        - series: Average Salary Change To Previous Year, %
          format: 0.0%
        - series: AS_Joiners := IF(Joiners Persons <> 0, Joiners Salary / Joiners Persons)
          format: '#,##0'
        - series: AS_Leavers := IF(Leavers Persons <> 0, Leavers Salary / Leavers Persons)
          format: '#,##0'
    colDef:
      blocks:
        - dimension: Time/Year
    dropSet:
      Company:
        - Alpha-1
        - Alpha-2
        - Beta-1
        - Beta-2
        - Beta-3
data:
  InputData!A1:F4:
    values:
      - - Year
        - Department
        - Joiners Persons
        - Leavers Persons
        - Joiners Salary
        - Leavers Salary
      - - 2024
        - Alpha-1
        - 20
        - 0
        - 1000000
        - 0
      - - 2024
        - Alpha-2
        - 15
        - 0
        - 810000
        - 0
      - - 2024
        - Beta-1
        - 12
        - 0
        - 720000
        - 0
  InputData!A5:F21:
    values:
      - - 2024
        - Beta-2
        - 10
        - 0
        - 640000
        - 0
      - - 2024
        - Beta-3
        - 8
        - 0
        - 544000
        - 0
      - - 2025
        - Alpha-1
        - 5
        - 2
        - 250000
        - 104000
      - - 2025
        - Alpha-2
        - 4
        - 2
        - 216000
        - 112000
      - - 2025
        - Beta-1
        - 3
        - 3
        - 225000
        - 186000
      - - 2025
        - Beta-2
        - 2
        - 2
        - 164000
        - 132000
      - - 2025
        - Beta-3
        - 2
        - 2
        - 172000
        - 140000
      - - 2026
        - Alpha-1
        - 5
        - 2
        - 245000
        - 106000
      - - 2026
        - Alpha-2
        - 4
        - 2
        - 220000
        - 114000
      - - 2026
        - Beta-1
        - 3
        - 3
        - 240000
        - 201000
      - - 2026
        - Beta-2
        - 2
        - 2
        - 174000
        - 144000
      - - 2026
        - Beta-3
        - 2
        - 2
        - 188000
        - 154000
      - - 2027
        - Alpha-1
        - 6
        - 2
        - 294000
        - 108000
      - - 2027
        - Alpha-2
        - 4
        - 2
        - 220000
        - 118000
      - - 2027
        - Beta-1
        - 3
        - 3
        - 258000
        - 219000
      - - 2027
        - Beta-2
        - 2
        - 2
        - 186000
        - 154000
      - - 2027
        - Beta-3
        - 2
        - 2
        - 200000
        - 168000
  InputData!I1:J4:
    values:
      - - Year
        - YE Salary Increase
      - - 2024
        - 0.03
      - - 2025
        - 0.04
      - - 2026
        - 0.05