This flow chart will help me make a if then equation in an excel spread sheet for predicting college football games
|
|
|
|
|
|
|
|
|
|
is team in row a on a bye
| YES
|
then 0
|
|
then find opponent in progression range T263:ai390
|
|
vlookup of opponent in columnv reference column 3
|
| |
NO
|
|
|
YES
|
|
|
|
|
|
is team in row a at home
| YES
|
if the difference of c-d in Sheet 1 Positive
| NO
|
then find opponent in progression range t263:ai390
|
|
vlookup of opponent column v refernce column 6
|
| |
NO
|
|
|
|
|
|
|
|
|
is team in row a away
| YES
|
is the difference of c-d in shee1 positive
| YES
|
find opponent in progression range t263:ai390
|
|
vlookup of opponent column v reference column 5
|
| |
NO
|
|
|
NO
|
|
|
|
|
|
team in row a is neutral
|
|
is the difference of c-d in sheet 1 positive
|
|
find opponent in progression range t263:ai390
|
|
vlookup of opponent column v reference column 8
|
| |
|
|
NO
|
YES
|
|
|
|
|
|
|
|
find opponent in progression range t263:ai390
|
|
find opponent in progression range t263:ai390
|
|
vlookup of opponent column v reference column 4
|
| |
|
|
|
|
|
|
|
|
|
|
| |
|
vlookup of opponent column v reference column 7
|
| |
| |
|
|
|
|
|
|
|
|
|
|
| |
| |
| |
| |
|
|
|
|
|
|
|
|
|