Archive for March 12th, 2008
Spreadsheet Hash
I’ve worn my brain down on the simplest but most tangled spreadsheet. And I have to run off here on yet another version of it, another version that once again will necessitate virtually re-building everything from scratch. The building blocks of our calculations in this one remain the same from version to version; but the way those blocks are stacked up gets so complicated, it’s not worth trying to build on earier versions. At the same time, for comparison against the other versions’ results, it is helpful to have those earlier calculations running concurrently through each of several scenarios being thrown at our model.
As good a place as any to salt the spreadsheet rather heavily with hash symbols.