Due to the exorbitant holiday price at Albany Bowl today, I only bowled a single (inglorious) game. Still, it was noteworthy occasion. I've been keeping track of my bowling scores (and those of some of my bowling buddies) since August 2003--almost five years. 256 weeks to be precise. As veteran users of Excel (2003 or earlier) will now, each worksheet has up to 65,536 (2^16) rows and 256 (2^8) columns. With each week inserted in a new column, the oldest week has now finally hit the rightward wall: Column IV.
Where to go from here? I've known for quite some time that this day would come, but I haven't been looking forward to it. I now have to completely revamp my bowling spreadsheet, which in addition to storing the scoring data also graphs the games and averages and outputs the relevant statistics for my bowling website. The most likely solution is to store weeks vertically instead of horizontally. It will take a bit of work to reprogram the macros, but there will be an upside.
With 65,536 rows, I won't have to overhaul the new spreadsheet for another 1251 years. :-)
1 comment:
Mike, I feel your pain. Fortunately, I haven’t run into the “out-of-columns” situation you have with the DOZENS (you know I’m not exaggerating) of spreadsheets and databases I keep of personal stuff. Not yet anyway. Hope your transposing (and macro rebuilding) goes well. But like you said, you won’t have to worry about it for a few lifetimes of bowling. -Dad
Post a Comment