|
Post by GoDogs on Sept 8, 2013 7:27:51 GMT -7
This week, Cdel58, JaxLion82, Linus 2727 and Smokey all got 8 out of 10 correct. Overall, JaxLion82 is in the lead with 17 points, followed by Alumni96 and Smokey with 16 points, and Cdel58 and Linus 2727 with 15 points. Please let me know if you have any questions or find any errors or omissions. Thanks! Had a few problems this week. Please see the corrected attachment.
RocketLab, TexasOil and anyone else with "wonky" totals: I found the problem. The formula I used for the fwd column was linked to the totals column on sheet 1. It was easier to do that by alphabetizing both sheets and then filling in the formula. Then, when I sorted Sheet 2 by points instead of the name, it still worked because I left Sheet 1 alphabetized. When I decided to go back and sort Sheet 1 again by points, it messed up the formula. To make a long story short, I need to make sure and NOT sort the sheet that the fwd column is based on. In a way, that’s better because it will be easier to find your name on the alphabetical list. I'll try another trial run this week (with me double checking the numbers by “hand”) and we’ll see how it goes. I may decide it just isn’t worth being lazy. See the corrected worksheet below.Please let me know if you find any other problems or have any suggestions. Thanx! Bulldogs Weekly.xlsx (21.75 KB)
|
|
|
Post by rocketlab on Sept 8, 2013 15:14:02 GMT -7
If I had 8 pts last week & 6 this week, shouldn't I be at 14 total now?
|
|
|
Post by TexasOil on Sept 8, 2013 19:08:14 GMT -7
I had 9 points the 1st week and 5 points this week.... shouldn't I be at 14 total now as well? It has me at 10 total....
|
|
|
Post by GoDogs on Sept 8, 2013 21:24:03 GMT -7
You mean I was supposed to add those points? Sorry, just joking. I probably made an error in the formula. This is the first year that I decided to let the formulas do my work for me. I'll go through them again tomorrow and get them all straightened out. That's what I get for trying to use new fangled technology and go high tech. I plan on keeping all the weekly results in one workbook. That way it'll be easy for me (and everyone else) to go back and check points, etc. Week 1 is Sheet 1, Week 2 is Sheet 2, etc. It may have been a sort problem. I'll recheck everyone's to be on the safe side. Thanx!
But ... listen ... if you guys keep watching me this close, I'll probably never get to be champ again, LOL!
|
|
|
Post by jaxlion82 on Sept 9, 2013 12:24:59 GMT -7
Let's end the season!
Too much pressure!
|
|
|
Post by Agent Orange on Sept 9, 2013 14:03:37 GMT -7
Let's end the season! Too much pressure! lol
|
|