What is also very easy, is to include a view inside an Excel table.
If you have a view what shows what you want then you can use the csv export link together with an automation user and secret to insert this data in an Excel sheet. There you can update the shown data as you want and you can use the whole calculations as you know it from Excel.
3 Likes