This past week, I was playing around with the World Cup Spreadsheet that I posted for download on the last blog, and I wound up running across a huge error. As I was popping in numbers in the score section to test it out, I realized that it was taking the wrong teams from the first round and placing them incorrectly into the second round. I tried to follow the string of functions to see if I could correct the issue, but whoever wrote the thing appears to have only learned a few choice functions in Excel and doesn't like to stray from what he knows. I would finally figure out what one function did only to find that it pointed to the results of three other functions that pointed to results of two more. It went on like that about 5 functions deep and I gave up.
I'm no Excel guru. Trust me. I think I know the program really well, but some forums have shown me that I know very little. Guy's are on there talking about pivot tables and background coding and I just have to ignore it from lack of understanding. However, I decided to take a crack at redoing the World Cup sheet because I couldn't help but think that whoever wrote this one was over-complicating the whole thing. I do admit, though, that some of the situations I got into when coding the functions seemed to paint me into a corner, if you will. I was a little stumped a couple times, but it all finally came to me.
This spreadsheet is much better. It's more attractive, in my opinion. It's simpler. And, most importantly, it works right. So, in case you were one of the seven people who downloaded the old one from last week, I suggest that you download this one again, here. I also changed the old link so that people wouldn't get one that doesn't work right. Enjoy!
Excel-lent Fun
0 comments:
Post a Comment