Asset Write off calculation Automation

Question

How do I show all the write-off values in the year of the write-off?

I have the below model were in: The formula in cell(O,29) is =

-SUM(OFFSET(O14,,,1,-MIN($G$20,P$3))/$G$20)+IF(O23=1,0,SUM(OFFSET(O14,,,1,-MIN($G$20,P$3))/$G$20)).

This gives me the flag-year depreciation but I wanted all the remaining depreciation so it should be $120.

Answer 1

How about this in O29:

=LET(period,     5,
     value,      I14:W14,
     flag,       I23:W23,
     startvalue, FILTER(value,value<>""),
     start,      FILTER(COLUMN(value),value<>""),
     writtenoff, startvalue/period*(COLUMN()-start),
IF(O23="",
   "",
   startvalue-writtenoff))

If you would drag this down/left/right, this would also take into account the 2 values for the convertor belts, for instance.