Matlab that shitI'm doing an analysis of inventory management performance over time. the workbook I have uses ~150,000 COUNTIFS() formulas w/2 conditions in each, evaluating across a 10,000 row table. I knew it was going to be ugly, so I turned off automatic calculations.
After I got everything in order, I started the workbook calculation, walked to a store a few blocks away to get a four pack, came back, and workbook was only about 60% computed . I long for the day Excel on Mac supports Data Model & Power Query - would have been so much easier.