It also seems faster too.Another template from Gorilla ROI (copy this Amazon FBA spreadsheet template here), this is a good option if all you’re looking for is a better way to manage your FBA inventory. Guess which one I find easier to understand. This left me quite impressed.Ĭase in point. In contrast, the Excel formulas can have useful names that make it clear what the formula is trying to accomplish, and I find them much easier to understand when revisiting them. I find some of the logic related to how INDIRECT is used almost incomprehensible as used in the Google Sheet Tiller templates. The Excel features like tables and named ranges are much more fleshed out and useful than what is in Google Sheets. I’m sure there are more areas for improvement. The resulting formulas were both faster and easier to understand than anything I’ve seen in Google Sheets. I wasn’t shy about using newer features found in Microsoft Excel 365. All I did was figure out what each formula was doing and re-write it in a more “modern” way, as far as I could decipher from tutorials on the web.

It now feels snappier than the equivalent Google Sheets Tiller template. I was able to get the Tiller-Money-Tracker template calculation time to 0.5 seconds, down from about 14 seconds as provided by Tiller. To do this, I had to make the data in the Balance History sheet a table, which let me reference the data in it with a readable name. Taking the last example, the final formula I came up with in the TillerBalTable sheet was actually this: Using Excel tables and structured references could make the formulas more readable and faster by eliminating the use of INDIRECT().The COUNTIF() trick used above could possibly be much faster if newer Excel features are used, like UNIQUE() and perhaps XLOOKUP().Heavy use of INDIRECT(), which is a volatile function in Excel and so causes recomputation of essentially everything in the sheet when anything changes.The 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.

Money and weight tracker excel