Interesting, thanks! IMO, testing in Excel can often be done similarly to how an accountant checks a new set of accounts to ensure that PnL and Balance Sheet actually do "balance". ... i.e. find alternative routes through the numbers that ought to give you the same result at the end, and then check that they actually do ...
Yeah. You'd think that what with hiring people from Harvard and the best schools they might actually, oh, I don't know, do some double checking TO PREVENT MULTI-BILLION DOLLAR LOSSES?
if its not strict about what imput it allows.. you could post your penis on twitter.. pay attention to what your doing.. haha validation... pretty cool way to bury a shit ton of risk.. between two worksheets.. haha