2326Views11Replies

Author Options:

import NFL win/loss data in to Excel? Answered

hi,
i have 2 Sheets in excel with the team names going Across & Down to form a matrix. 1 Sheet for Home Games, 1 Sheet for Away.

is there any way to import that data into excel.

(Picture to Show Layout)

Discussions

The forums are retiring in 2021 and are now closed for new topics and comments.
0
canucksgirl
canucksgirl

Best Answer 8 years ago

I'm a little confused by your question. You said the data is already in Excel (as shown by your image), but you want to export to Excel???

Are you trying to put both the home and away data into the same spreadsheet (such as a page 1 and page 2)?

0
furby
furby

Answer 8 years ago

i have the team names in there in Alphabetical order.
i want to get the Win/Loss so i can put
eg. Arizona vs Denver it puts W or L in the appropriate cell.
then repeat that for the away sheet

"Are you trying to put both the home and away data into the same spreadsheet (such as a page 1 and page 2)?"
Same Workbook different sheets.

if i can't do it is there any site that show the results for ALL weeks

0
canucksgirl
canucksgirl

Answer 8 years ago

I think you may have some issues with the way your spreadsheet has been organized...

If D3 is the result of Arizona VS Atlanta, what information should show in that cell? Should it just say "Win" or "Loss"? How does this information relate to the corresponding column or row? If a "Win" is placed in D3, is that a win for Arizona or a win for Atlanta? and which team is the home team based on your spreadsheet?

0
furby
furby

Answer 8 years ago

/facepalm

but
column Home \/
row Away >

separate sheets for Home Games and Away Games

0
furby
furby

Answer 8 years ago

/thought-train

if i can get the data in the format of

HOME Team - AWAY Team - HOME score - AWAY score.

i could probably work something out
that way i don't NEED to know who won. ( i can do that with excel)

0
furby
furby

Answer 8 years ago

this is the Data feed that i'm using

http://www.repole.com/sun4cast/data.html
the XML feed for "Regular Season game scores and lines:"

0
canucksgirl
canucksgirl

Answer 8 years ago

I'm working on it...

0
furby
furby

Answer 8 years ago

sending you a link with my current book in it

0
Jupiter6
Jupiter6

1 year ago

Home score Opponent score s+/- W L T Opponent score Away score s+/- W L T
s+/- = Score differential
=If(h2>0,1," ") W
=iF(h2<0,1," ") L
=iF(H2=0,1," 2) T
Then if you already know excel you can apply simples formulas like summation and some others formulas to obtain total points, score average,points per game even margin of victory MOV. so in this way you will have and see much better statistics of every team
This Format can be use even for NFL,NBA,Soccer.
By the way I have in EXCEL every NFL season since the 20´s until now
including NFL Preseason since the 2000´s even NBA since the 40´s
It took me a lot of time (over a Year) to do it and at last Those Project are allready finished, Done,completed.

0
Jupiter6
Jupiter6

1 year ago

think I have the answer for that Doubt in excel.
but First I need to know how the place an excel file and show it.

0
furby
furby

8 years ago

i've decided to go a different way.

0
canucksgirl
canucksgirl

Answer 8 years ago

I'm sure you figured out that what you're trying to achieve isn't a fast job...

I managed to re-do the spreadsheet so that both home and away are in one sheet and then the data from that sheet populates another sheet with a full summary of the teams (so that you can see the total home wins/losses, total away wins/loses, points total, points margin/differential, total wins/losses etc) AND rank the teams according to their standings...

The only part I didn't get done was coding the sheet that populates the game table. The reason I didn't, is to be honest, its a big job! If the spreadsheet is going to be reused for future years, it has to be done right. There's also a HUGE number of cells on the games table that have to be coded. Right now, you could manually enter in all the scores and it would populate the summary page, but that's not what you asked for... To set things up the way you wanted would require MANY more hours of work (and its not something I'm prepared to do for free); but can it be done? Absolutely.

Nonetheless, I'm glad you found another way... :-)

0
furby
furby

Answer 8 years ago

i ended up doing something something similar.
i also added 2 sheets for Historical data.
concatenating YearTeamLocation(h or v) winner and loser are in separate columns.

i'll upload a copy when i get home from holidays because i forgot to bring it with me :(