Well, it's all a kind of work in progress so I do appreciate the feedback.
I can't remember the reason that had a drop down list for volume.
I don't often create these using only formulas. I usually have loads of VBA but I know a lot of people don't like running
spreadsheets with macros. So in absolute truth, it was a bit of an experiment.
Hence the "if you break it just download it again" comment
In double truth, you can see the nonsense that goes through my head with the "message bar" and changing the current through
the drop down list options (if you haven't done it yet, have a go).
I could have used swear words but I thought I better be grown up about it!
perhaps it can be a community project. From the den, do you have your revised version so I can take a look and see if I can implement anything?
The BV part has literally only just got added and I do know that some of the calcs and dependancies are off at the moment. Again, trying to give this the brain space it needs at the moment is a little tricky, I think it may have to be my Christmas Break project again! (after the ST3 manual of course - Boss
)
I haven't looked at this in a while and only popped it up to help with the thread.
Wayne's calculator is way more polished but I do appreciate that some may also appreciate an excel version and that was the reason for having a go.
I will keep working on it (because it's fun and I'm an idiot!) but please bear with me while I get a few other bits out the way first.
Keep posting thoughts too and I will try to accommodate if possible.
Right now I can't even open it because I'm on the mac with not office installed! Oh the Joys!