Icon

Asset Depreciation Project

Filter on depreciating assets only
Rule-based Row Filter
Total Assets to depreciate
Statistics
Join Rate Adj
Joiner
p1: Active fully written down
Row Splitter
Delete cat L and W
Column Filter
p2: Active not dep
Rule-based Row Splitter
Rate Adj Factor
Excel Reader
MEAV Asset Adj
Excel Reader
String to Date&Time
Join MEAV Adj
Joiner
Column added for life in Days
Math Formula
Total
GroupBy
Excel Writer
Double to Integer
p4: Active 1 mth out
Rule-based Row Splitter
Filter on all retired assets
GroupBy
Total
GroupBy
p3: Active dep stopped
Row Splitter
Colum added with asset retired date
Date Shifter
Total
GroupBy
Filter on retired assets with a NBV
Row Filter
Total
GroupBy
Filter of all retired assets
Date&Time-based Row Filter
Renamed retired asset column
Column Renamer
Total
GroupBy
Table Transposer
Totals of activeassets
GroupBy
Filter of all active assets
Date&Time-based Row Filter
Totals of retired assets with a NBV
GroupBy
JERL
Excel Reader
Table Splitter
Row to Column Names
Filter on all matchingdepreciation values(All match)
Rule-based Row Filter
Added column with recalculated depreciation
Math Formula
Round recalculateddepreciation
Number Rounder
Round recalculateddep reserves
Number Rounder
Added column with asset life from dateplaced in service to 31/12/2025
Date&Time Difference
Added column withrecalculated dep reserves
Math Formula
Dep Reserve minus recalculated dep reserve
Math Formula
Filter on difference
Row Filter
Added column withrecalculated NBV
Math Formula
Filter ondifference
Row Filter
Filter onmatches
Row Filter
Rounding allvalues
Number Rounder
NBV minusrecalculated NBV
Math Formula
Deleted total value row
Row Filter
Total of NBVno match
GroupBy
Total of NBVmatches
GroupBy
Filter data by cat and life to find num of anomolies
GroupBy
Totals for each cat
GroupBy
Filter data by cat, adding value for new totals
GroupBy

Nodes

Extensions

Links