3/30/2024 0 Comments Expense tracker excel formulasThe approach used across the sheets in this template have more room for improvement, I think. The table now computes in about 0.15 seconds on my machine, down from just over 6. This row is copied down for about 200 rows, so this reduced the time by a lot. The idea being: skip the very expensive COUNTIF call if the prior row is empty – in other words, when there are no more account IDs to find. I found that if I modified the formula in column B from this: I found that about half of the computing time was coming from the TillerBalTable sheet (which is normally hidden). I decided to look into this and found it pretty easy to find some easy optimizations. I’ve only got about 5000 rows in my Balance History and 2500 transactions representing two years of data across about six accounts. It takes roughly 14 seconds to recalculate my spreadsheet. Is anybody using this template for every day use? I was surprised to find that my data loaded into the Tiller-Money-Tracker excel template resulted in a very slow spreadsheet. I’m exploring switching to Excel from Google Sheets.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |