Why is my sheet running so slow??

I removed all conditional formatting (there was a huge amount of overlapping formatting) by copying the rows and pasting special first the values then paste special formulae while the selection was maintained.

As noted, the Rank formula is very strange in that the whole range isn't selected for the ranking.

The workbook at least reacts in a normal fashion time-wise.