hi people! my file has the description of how i manually do up this.
basically, i have a table with date, category and Amount. This is downloaded from the system and cannot be changed.
but there are different rates for different categories. and these rates may change over time. i placed them under another table that you can change if you deem necessary.
it also has different formulas for different combinations; some averages the numbers directly, some must be summed up before averaging, and some must be summed up and divided by total percentage before averaging.
Bookmarks