| Author |
 Replies: 419 / Views: 25,907 |
|
|
|
Valued Member
 United States
370 Posts |
Sure, might make things easier.
|
|
Pillar of the Community
United States
2049 Posts |
Ok working on it now. It will take some time but I already have the base spreadsheet set up. Once I have the week 1 page done, then it's pretty easy to make for all the weeks. From there I would just need to add the scoring function to add up the totals year to date.
Are you planning to run it all the way through the last weekend with the conference championship games?
|
|
Pillar of the Community
United States
2049 Posts |
Ok I have it just about it done. I have it set for 14 weeks, based on including games for the conference championship game weekend (I hope you do because those are some huge games and there are other regular season games that 1st weekend of December).
Also I (I should say the spreadsheet) came up with 6 points for JackB for getting the Michigan St, Northwestern, Virginia Tech and Alabama picks right.
|
|
Valued Member
United States
370 Posts |
Cool and yeah, was planning on including the conference championship games. Good catch, I did short him a point
|
|
Valued Member
United States
370 Posts |
Games for week 2
Week 2
Game 1 #16 Nebraska vs UCLA
Game 2 North Carolina vs Wake Forest
Game 3 Miami vs #21 Kansas St
Game 4 Illinois vs Arizona St
*Game 5* #7 Georgia vs Missouri
All games are on Saturday, so the deadline for the picks is 12pm Friday.
|
|
Pillar of the Community
United States
1064 Posts |
Quote:
Also I (I should say the spreadsheet) came up with 6 points for JackB for getting the Michigan St, Northwestern, Virginia Tech and Alabama picks right. Thank you very much! I obviously didn't catch it, and can use every point!  |
|
Pillar of the Community
United States
2049 Posts |
Ok sounds good. Are you good with spreadsheets? The set up is all done, it just needs to have the weekly games input, the picks, and the results, and it will automatically tabulate the scores for the week, and season to date. I can send it to whomever wants it. It's in Microsoft Excel 2003 format but I am sure it will work on later versions too.
|
|
Pillar of the Community
United States
2049 Posts |
My picks so I don't miss the deadline (thank you to Lion4Life for giving me a pass the 1st week)
Game 1 Nebraska
Game 2 North Carolina
Game 3 Kansas St
Game 4 Arizona St
Game 5 Georgia 62 points
|
|
Valued Member
United States
370 Posts |
Quote:
Ok sounds good. Are you good with spreadsheets? The set up is all done, it just needs to have the weekly games input, the picks, and the results, and it will automatically tabulate the scores for the week, and season to date. I can send it to whomever wants it. It's in Microsoft Excel 2003 format but I am sure it will work on later versions too. Not really familiar with them, should be able to figure it out though. |
|
Valued Member
United States
240 Posts |
Just have to say, I'm going to be marching along side Valley Christian Marching Band during the rosebowl parade :D
|
|
Pillar of the Community
United States
538 Posts |
Hopefully that spreadsheet will save you some time Lion. Here are my picks:
Game 1: Nebraska
Game 2: North Carolina
Game 3: Miami
Game 4: Arizona State
*Game 5*: Georgia total points 42
|
|
Pillar of the Community
United States
1151 Posts |
1)UCLA
2)North Carolina
3)Kansas St.
4)Arizona S.
5)Georgia 34 points total
|
|
Pillar of the Community
United States
1064 Posts |
Week 2
Game 1 Nebraska
Game 2 Wake Forest
Game 3 Miami
Game 4 Arizona St
*Game 5* Georgia total points 53
|
|
Pillar of the Community
United States
2049 Posts |
Ok how about I send it to you after this week is over. That way I can verify the formulas for year to date scoring work as they should.
|
|
Pillar of the Community
United States
1080 Posts |
Game 1 Nebraska
Game 2 North Carolina
Game 3 Kansas St
Game 4 Arizona St
*Game 5* Georgia 54 points
|
| |
Replies: 419 / Views: 25,907 |
First Page
Previous Page
Posted 09/04/2012 5:18 pm
