Recruiting with Excel Topic

alblack56
Posts: 3329 (0)
Hall of Famer
490
Pro
Hi-
  I've always copied and pasted recruits into Excel with no problem.

  Today, however, I'm losing the color.  Instead of red and blue (formerly green) , all the numbers are black and gray. It looks like the blue numbers are now bold black.  This happens with both my desktop and laptop.

Any ideas?
12/14/2011 2:41 PM
cornfused
Posts: 1492 (0)
Hall of Famer
2 235 11
Prospect
seeeebbbblllleeee

actually no it works for me (on Chrome)
12/16/2011 10:06 AM (edited)
rogelio
Posts: 1122 (0)
Hall of Famer
26 355 18 20
Pro

I use the logic formula and have one ugly long function that computes, for instance, = B2 + ..... + IF (C2 = "Low",3,0).  Just define each potential as you please.  There's probably an elegant way to do it, but...meh.

12/14/2011 5:04 PM
hughesjr
Posts: 3175 (0)
Hall of Famer
492 154 8 2
Prospect
If you use chrome, it will paste with color ... at least it does for me.
12/14/2011 6:48 PM
chapelhillne
Posts: 2492 (0)
Hall of Famer
3 772 17 2
Veteran
How do you get the numbers to paste in Excel? I have to copy each player, then paste, but it only pastes in one square, so then I end up having to type each rating in. Takes me about an hour every time I am planning on recruiting. If someone knows how to do this, please let me know. I would really appreciate it a lot!
12/14/2011 11:57 PM
alblack56
Posts: 3329 (0)
Hall of Famer
490
Pro
Posted by chapelhillne on 12/14/2011 11:57:00 PM (view original):
How do you get the numbers to paste in Excel? I have to copy each player, then paste, but it only pastes in one square, so then I end up having to type each rating in. Takes me about an hour every time I am planning on recruiting. If someone knows how to do this, please let me know. I would really appreciate it a lot!

If you only highlight one square in Excel,  you can't paste an entire page.   Your highlighted area in Excel needs to be larger than the data you're pasting.  Even still, you'll get a message that says, "Data on the Clipboard is not the same size and shape of the selected area. Do you want to paste the data anyway?"  If you say 'OK', it'll paste.

I'm still only able to paste in black-and-white, though. Something must've changed with the last update. I sent a ticket

 

12/15/2011 4:05 AM
rogelio
Posts: 1122 (0)
Hall of Famer
26 355 18 20
Pro
What works for me is to open Word & Excel.  Copy the FSS report page into Word, then cut the right hand column and paste beneath the left hand column.  Then cut again and paste into three excel columns and type in WE manually in a separate row.  Obviously, if you define, for instance, "High High" in your logic, then you will have to manually type that extra "High".
12/15/2011 8:23 AM
chapelhillne
Posts: 2492 (0)
Hall of Famer
3 772 17 2
Veteran
Thanks for the tips - I will try that next recruiting period. That will save a ton of time.

12/16/2011 9:58 AM
jdno
Posts: 655 (0)
Hall of Famer
152
Rookie
Posted by chapelhillne on 12/14/2011 11:57:00 PM (view original):
How do you get the numbers to paste in Excel? I have to copy each player, then paste, but it only pastes in one square, so then I end up having to type each rating in. Takes me about an hour every time I am planning on recruiting. If someone knows how to do this, please let me know. I would really appreciate it a lot!
copy and paste as text, works great, but the colors don't carry over.  Then I shade in each box w/the appropriate color for potential.  Ditto for your own teampage.
12/16/2011 10:57 AM
mullycj
Posts: 2737 (0)
Hall of Famer
214 1
Prospect
if you figure it out alblack please post.  I have the same issue.
12/16/2011 10:09 PM
alblack56
Posts: 3329 (0)
Hall of Famer
490
Pro
CS told me that they only changed the font colors, nothing else.  I suspect the the orange is too light; the blue is too  close to black.  That's why Excel doesn't recognize them. 
I've never used Chrome before but am going to experiment with it this afternoon.
12/17/2011 3:58 AM
alblack56
Posts: 3329 (0)
Hall of Famer
490
Pro
I downloaded Chrome and the colors transfer to Excel properly, just as hughesjr said. Thanks
12/17/2011 2:50 PM
dahsdebater
Posts: 10046 (0)
Hall of Famer
284 293 18
Pro
You should be able to just slightly adjust your spreadsheets anyway and have them recognize grey and the bold format instead of the colors they were initially programmed for...
12/17/2011 2:55 PM
Recruiting with Excel Topic
△Top△Bottom

Search Criteria

Terms of Use Customer Support Privacy Statement

© 1999-2026 WhatIfSports.com, Inc. All rights reserved. WhatIfSports is a trademark of WhatIfSports.com, Inc. SimLeague, SimMatchup and iSimNow are trademarks or registered trademarks of Electronic Arts, Inc. Used under license. The names of actual companies and products mentioned herein may be the trademarks of their respective owners.