RAPM won't copy and paste nicely, tried text to columns

Home for all your discussion of basketball statistical analysis.
Post Reply
Kathoro
Posts: 137
Joined: Mon Apr 09, 2012 4:12 am

RAPM won't copy and paste nicely, tried text to columns

Post 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.
J.E.
Posts: 852
Joined: Fri Apr 15, 2011 8:28 am

Re: RAPM won't copy and paste nicely, tried text to columns

Post 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
Kathoro
Posts: 137
Joined: Mon Apr 09, 2012 4:12 am

Re: RAPM won't copy and paste nicely, tried text to columns

Post 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!
J.E.
Posts: 852
Joined: Fri Apr 15, 2011 8:28 am

Re: RAPM won't copy and paste nicely, tried text to columns

Post 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
Kathoro
Posts: 137
Joined: Mon Apr 09, 2012 4:12 am

Re: RAPM won't copy and paste nicely, tried text to columns

Post by Kathoro »

I got it to work for me now. Thanks. I don't know why it wasn't working previously.
Kathoro
Posts: 137
Joined: Mon Apr 09, 2012 4:12 am

Re: RAPM won't copy and paste nicely, tried text to columns

Post by Kathoro »

Do you happen to have DRAPM for only the regular season? Or do you only have it with playoffs included?
Post Reply