Page 1 of 1
RAPM won't copy and paste nicely, tried text to columns
Posted: Mon Jul 02, 2012 5:16 am
by Kathoro
I can't get RAPM to paste into xcel into separate columns. I tried text to columns and delimited and all that stuff, but this will only work for two out of the six years I need. I am not sure why four of them paste into xcel so weirdly. Any help would be greatly appreciated.
Re: RAPM won't copy and paste nicely, tried text to columns
Posted: Mon Jul 02, 2012 10:11 am
by J.E.
Kathoro wrote:I can't get RAPM to paste into xcel into separate columns. I tried text to columns and delimited and all that stuff, but this will only work for two out of the six years I need. I am not sure why four of them paste into xcel so weirdly. Any help would be greatly appreciated.
From my site or somewhere else? Which years are you having trouble with?
If you can't fix it on your end I can upload txt/csv files
Re: RAPM won't copy and paste nicely, tried text to columns
Posted: Mon Jul 02, 2012 11:51 am
by Kathoro
Yes from your site. I need 2006-2012. 2012 and 2009 are the only two that currently paste into xcel into separate columns when I use paste special. Also, I noticed that some very low minute players are entirely excluded from both 2012 and 2009, and I am assuming maybe other years as well. Is this because they didn't play enough minutes to reach a certain threshold?
Also I noticed that the names of several of the players for the 2006 year only include either a first or last name, but not both. Either that or the first name is represented by only an initial and not a full name.
The text files would be greatly appreciated!
Re: RAPM won't copy and paste nicely, tried text to columns
Posted: Mon Jul 02, 2012 12:35 pm
by J.E.
I have no problems with formatting when using Libre Office Calc.
Players that aren't listed did not play at all in the available matchupfiles, which either Aaron (2006 and on) or I (before 2006) created.
Names are weird for players that played in '06 and not after because those are the names they were given in bbv's '06 playerfile
Re: RAPM won't copy and paste nicely, tried text to columns
Posted: Mon Jul 02, 2012 2:28 pm
by Kathoro
I got it to work for me now. Thanks. I don't know why it wasn't working previously.
Re: RAPM won't copy and paste nicely, tried text to columns
Posted: Wed Jul 04, 2012 2:13 pm
by Kathoro
Do you happen to have DRAPM for only the regular season? Or do you only have it with playoffs included?