Building with performance in mind also sets you up with a more efficient and user-friendly doc, so it’s a win-win.
Making use of lookup columns and aggregating everything that was in common into one column meant adding an additional data point only required 1,000 calculations whereas the original setup in strategy one required 1,000,000 calculations for every additional column.
The TL;DR is consolidate and re-use and you’ll end up setting yourself up on an easy path that’s open to more options moving forward.
Calculations total with each additional column
Filter in place: filtering every row in the table every time
Total calculations: 5,000,000
Adding an additional data point adds 1,000,000 calculations
Aggregate common data points: creating a lookup summary table
Total calculations: 925,000
Adding an additional data point adds 189,000 calculations
Re-use instead of repeat: creating a worker column to outsource repeated parts of formulas
Total calculations: 189,000
Adding an additional data point adds 1,000 calculations
Want to print your doc? This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (