|
| Posted by: tduncan
- [423452813] Fri, Oct 25, 2002, 16:59
I was wondering if someone could please e-mail me an excel spreadsheet with last year's row stats. nothing big, only the regular stuff, name, position, games and the main scoring and statistic categories.
thanks is advence. |
| | | 1 | biliruben
Sustainer
ID: 3502218
Fri, Oct 25, 2002, 17:06
|
You can download it yourself from yahoo, if you like. I have an excel spreadsheet as well, but it is pretty marked up.
|
|
| | | 2 | tduncan
ID: 423452813
Fri, Oct 25, 2002, 17:17
|
thanks biliruben. this looks great, only all the stats come into 1 cell, and I don't know how to make excel seprate them... ?
|
|
| | | 3 | biliruben
Sustainer
ID: 3502218
Fri, Oct 25, 2002, 17:23
|
In excel:
Data->text to columns->comma delimited
Also, I think I recall a double comma in there, so just click the box for multiple delimiters.
Let me know if that doesn't work.
|
|
| | | 4 | biliruben
Sustainer
ID: 3502218
Fri, Oct 25, 2002, 17:24
|
Do all that after highlighting the whole column with with the data in it, and deleting the row(s?) at the top with the time stamp et. al.
|
|
| | | 5 | tduncan
ID: 423452813
Fri, Oct 25, 2002, 17:27
|
wow... it worked! thanks a lot biliruben. much appreciated.
|
|
| | | 6 | biliruben
Sustainer
ID: 3502218
Fri, Oct 25, 2002, 17:28
|
Great! No problem.
|
|
| | | 7 | Tosh
Donor
ID: 23650284
Fri, Oct 25, 2002, 17:29
|
Oops. I'm a minute late. Stats sent
|
|
|
|