DOWNLOAD NFL SCHEDULE FILE
I have some problem with my pick them week 1-18.
1. Some of scores in Columns D & H is not showing up. The score is looking a form Input_scores worksheet.
2. in some worksheets have L3 & L6 is having number in cell. should have 0 when are no score in columns D & H
3.* to pick team I think going wiill win look up score in D & H. The scores in input_scores worksheet
color in green is i got right, red in green is i got wrong. light Blue is no * on the worksheet, after I put a * in column D or H will be normal it is using conditional formatting.
4.L10:L15 if you teams in this section will not bein columns C & G will put Bye Team in columns C or G at bottom of list. sample like Pick Them week 6
5. O3:O18 is helper section some worksheets have C or I in cell should not be in cells until the scores is inputed.
I have some problem with my pick them week 1-18.
1. Some of scores in Columns D & H is not showing up. The score is looking a form Input_scores worksheet.
2. in some worksheets have L3 & L6 is having number in cell. should have 0 when are no score in columns D & H
3.* to pick team I think going wiill win look up score in D & H. The scores in input_scores worksheet
color in green is i got right, red in green is i got wrong. light Blue is no * on the worksheet, after I put a * in column D or H will be normal it is using conditional formatting.
4.L10:L15 if you teams in this section will not bein columns C & G will put Bye Team in columns C or G at bottom of list. sample like Pick Them week 6
5. O3:O18 is helper section some worksheets have C or I in cell should not be in cells until the scores is inputed.
NFL SCHEDULE.xlsb | |||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | |||
1 | 6 | NFL GAMES PICK THEM | 2021 | HOME | |||||||||||||||
2 | GAMES | ROAD TEAM PICK | ROAD TEAMS | ROAD SCORES | VS | HOME TEAM PICK | HOME TEAMS | HOME TEAM SCORES | GAME | CORECT/INCORRECT | HOME TEAM OPTION BUTTON VALUE | HOME TEAM W/L | |||||||
3 | 1 | BUCCANEERS | 0 | VS | EAGLES | 0 | GOT RIGHT | 0 | 1 | L | |||||||||
4 | 2 | DOLPHINS | 0 | VS | JAGUARS | 0 | GOT RIGHT % | 0% | 2 | L | |||||||||
5 | 3 | VINKINGS | VS | PANTHERS | 0 | 3 | I | L | |||||||||||
6 | 4 | PACKERS | 0 | VS | BEARS | 0 | GOT WRONG | 2 | 4 | L | |||||||||
7 | 5 | TEXANS | 0 | VS | COLTS | 0 | GOT WRONG% | 100% | 5 | L | |||||||||
8 | 6 | BENGALS | 0 | VS | LIONS | 0 | 6 | L | |||||||||||
9 | 7 | RAMS | 0 | VS | GIANTS | 0 | BYE WEEKS | TEAMS | 7 | L | |||||||||
10 | 8 | CHARGERS | 0 | VS | RAVENS | 0 | 1 | FALCONS | 8 | L | |||||||||
11 | 9 | CHIEFS | 0 | VS | REDSKINS | 0 | 2 | SAINTS | 9 | L | |||||||||
12 | 10 | CARDINALS | 0 | VS | BROWNS | 0 | 3 | JETS | 10 | L | |||||||||
13 | 11 | RAIDERS | 0 | VS | BRONCOS | 0 | 4 | 49ERS | 11 | L | |||||||||
14 | 12 | COWBOYS | 0 | VS | PATRIOTS | 0 | 5 | 12 | L | ||||||||||
15 | 13 | SEAHAWKS | 0 | VS | STELLERS | 6 | 13 | I | W | ||||||||||
16 | 14 | BILLS | 0 | VS | TITANS | 0 | 14 | L | |||||||||||
17 | 15 | BYE WEEK TEAM | VS | BYE WEEK TEAM | 15 | ||||||||||||||
18 | 16 | BYE WEEK TEAM | VS | BYE WEEK TEAM | 16 | ||||||||||||||
PICK THEM WEEK 6 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
H1 | H1 | =YEAR(TODAY()) |
C3:C18 | C3 | =IF('6'!D2<>"",'6'!D2,"BYE WEEK TEAM") |
D3:D18,H3:H18 | D3 | =IFERROR(VLOOKUP(C3,INPUT_SCORES!$A$2:$R$33,7,0),"") |
G3:G18 | G3 | =IF('6'!G2<>"",'6'!G2,"BYE WEEK TEAM") |
O3:O18 | O3 | =IF(Q2="","",IF(D3=H3,"",IF(AND(P3="T",Q3="W"),"C",IF(AND(P3="F",Q3="L"),"C","I")))) |
P3:P18 | P3 | =IF(AND(F3="*",B3=""),"T",IF(AND(F3="",B3="*"),"F","")) |
Q3:Q18 | Q3 | =IF(AND(D3="",H3=""),"",IF(H3>D3,"W","L")) |
L3 | L3 | =COUNTIF($O$2:$O$18,"C") |
L4 | L4 | =IFERROR(L3/(L3+L6),"") |
L6 | L6 | =COUNTIF($O$2:$O$18,"I") |
L7 | L7 | =IFERROR(L6/(L3+L6),"") |
L10:L15 | L10 | =IF('BYE WEEKS'!Q3<>"",'BYE WEEKS'!Q3,"") |