@Cirripedius re: random number health generator
What you need is a macro. If you're using excel 07, you can create a button and assign a macro to it. The macro you record should copy the cell the health total is in, and then in a new (permanent hps cell) paste special (right click on the cell...