This is the worksheet I created and developed throughout my career as an external auditor.
It is still need more development but this should be helpful for most of the use cases.
Feel free to DM me for advice or request other fuction for this worksheet🙏🏻
Updated version for >>> ✅ disposal items during the period<<<
***Please noted that this still needs more update to the depreciaiton recalcuation formular.
There are more and more scenarios for me to face and it took me a lot of times to add those "=if()" in it 😂