Ranks and Exceptions that "Bubble Up" to Subtotals

Every now and then, I find myself training someone who I just KNOW is going to be teaching ME things in the near future. The questions they ask are the dead giveaways. And the next time we meet, they will be Darth Vader, telling my Ben Kenobi about how the circuit is complete. I had the pleasure of teaching someone like this quite recently. He forced me to write some pretty nifty calcs, or at least some that *I* think are nifty.