Here is a little something I have. It's on PowerPoint so I think I would have to email it to anyone who wanted to try it.
Here is what it looks like, nothing pretty, but it gets the job done.
http://docs.google.com/Presentation?...k69_11dv2fj2gs
If anyone is interested shoot me a PM.
Edit: And the Total cell automatically takes the values from the On Hand, Expended, and Purchased cells and does all the math for you.