NFL Scores and Point spread Spreadsheet

[Mykro]

I'm Trying to build a spreadsheet that will tell me if a team has "won" or "lost" against the point spread.What you do is Enter in the team you want to play and the points. EX:

Teams Spread Score Result

SF -7 14 "LOST"
SD 21

SD +10 22 "WON"
NYJ 10

I Understand the IF Function But I'm missing something...I'm such a novice

 

[Yogi Anand]

On 2002-10-19 18:26, Mykro wrote:
Thanks for the reply.. But.. "won" is in the field when no data has been entered..

Thankx

Hi Mykro:

use the following formula for entries in cells A4:A8

'=IF(ISNUMBER(MATCH("Lose",A4:A8,0)),"Lose",IF(COUNTA(A4:A8)<5,"Don’t Know Yet","Win"))

Also see the following worksheet simulation ...

y021019h1.xls
	A	B	C	D	E	F
1
2	DontKnowYet	Lose	Win
3
4	Win	Win	Win
5	Win	Win	Win			sourcedata
6		Win	Win			result
7	Win	Lose	Win
8	Win	Win	Win
Sheet5

</SPAN>

Regards!

Yogi
This message was edited by Yogi Anand on 2002-10-20 00:06

 

[Yogi Anand]

Hi Mike:

For the NFL Sport 7 Team Parlay win/lose (based on the file you emailed to me), I have used the following array-based formula (in cell I20) ...

'{=IF(SUM(IF($A$9:$A$14=C20:H20,IF($G$9:$G$14="WON",1,0)))=6,"WON","LOST")}

see the following worksheet simulation ...

nfldemo_2.xls
	A	B	C	D	E	F	G	H	I
1				TeamonTop(Optional)
2	Number	Favorite	Line	Score	Underdog	Score	Result
3	112	PITT	4.0	16	HOU	4	WON
4
5
6				TeamsToWheel
7
8	Number	Favorite	Line	Score	Underdog	Score	Result
9	201	NY	-4.0	15	SF	7	WON
10	95	SD	10.0	14	AZ	14	WON
11	142	MIA	-6.0	27	NE	20	WON
12	131	DAL	-3.5	15	DEN	11	WON
13	127	SF	-10.0	29	SEA	12	WON
14	119	NYG	2.0	7	BALT	5	WON
15	111	TB	20.0	15	JAC	49	LOST
16	109	HOU	12.0	8	PHIL	10	LOST
17
18
19	TeamonTop								ParlayResult
20		112	201	95	142	131	127	119	WON
21		112	201	95	142	131	119	111	LOST
22		112	201	95	142	127	119	111	LOST
Sheet1

</SPAN>

Please post back if it works for you ... otherwise explain a little further and let us take it from there.

Regards!

Yogi Anand

 

[Jupiter6]

I'm Trying to build a spreadsheet that will tell me if a team has "won" or "lost" against the point spread.What you do is Enter in the team you want to play and the points. EX:

Teams Spread Score Result

SF -7 14 "LOST"
SD 21

SD +10 22 "WON"
NYJ 10

I Understand the IF Function But I'm missing something...I'm such a novice

I think this format will hepl you
S+/- (Score Differential)
S +/- E=B-D
if(e2>0,1," ") W
if(e2<0,1," ") L
If e2=0,1," ") T

S +/-M=L-K
if(m2>0,1," ") W
if(m2<0,1," ") L
if(m2=0,1," ") T

Away =Home Team Away or Road
Home Score, Opponent Score S+/- W L T /Opponent Score, Away Score S+/- W L T
Then you continue with summatory function to obtain the total W L T,

 

[Jupiter6]

HOME	Score	Opponent	Score	S+/-	W	L	T	Year	Opponent	Score	Road/Away	Score	S+/-	W	L	T
Arizona Cardinals	27	Detroit Lions	27	0			1	19	Baltimore Ravens	23	Arizona Cardinals	17	-6		1
Arizona Cardinals	20	Carolina Panthers	38	-18		1		19	Cincinnati Bengals	23	Arizona Cardinals	26	3	1
Arizona Cardinals	10	Seattle Seahawks	27	-17		1		19	New York Giants	21	Arizona Cardinals	27	6	1
Arizona Cardinals	34	Atlanta Falcons	33	1	1			19	New Orleans Saints	31	Arizona Cardinals	9	-22		1
Arizona Cardinals	25	San Francisco 49ers	28	-3		1		19	Tampa Bay Buccaneers	30	Arizona Cardinals	27	-3		1
Arizona Cardinals	7	Los Angeles Rams	34	-27		1		19	San Francisco 49ers	36	Arizona Cardinals	26	-10		1
Arizona Cardinals		Pittsburgh Steelers		0			1	19	Seattle Seahawks		Arizona Cardinals		0			1
Arizona Cardinals		Cleveland Browns		0			1	19	Los Angeles Rams		Arizona Cardinals		0			1
21	123	31	187	-64	1	4	3	-11	27	164	22	132	-32	2	4	2
22	132	27	164	-32	2	4	2	-5
Points Favor	255	Opponent Points	351	-96	3	8	5	-8	Margin Of Victory
Points Per Game	21	Points per Game	29	Net Pts					Season 2019

 

[Jupiter6]

W D T
Home Score, Opponent Score (Score Differential)SD+/- =IF(D2>0,1," ") =IF(D2<0,1," ") =IF(D2=0,1," ")
San Francisco 7 San Diego 21 =B2-D2 -14 1

if you keep this excel format and formulas, you will get more Data(Statistics) Points per game , Mov Margin of Victory+Net Points