I used it once to run a Monte-Carlo simulation in a spreadsheet.

After enabling iterative calculation and manual calculation, every press of refresh runs a loop. Fun stuff.