Adam,
I have to admit that I'm overwhelmed by your file!
What you are doing is somewhat complicated to start off with but I think you
are making it more complicated than it needs to be. Look how big the file
is!
There are a lot of things that can be improved but I don't know where to
start!
I'll get back to you tomorrow with some specific suggestions. Most of the
formulas can be greatly reduced in size and "complexity". That's where
you're getting "jammed up" by the calc time. Too many volatile function
calls!
Biff