Discussion in 'The Experience' started by Nautica, Jul 18, 2011.
JCspartan2 can you sticky this please
Nautica would you guys mind if I used this lay-out for record keeping in Orange Crush? It's a really nice set-up. Sorry if this post clutters up things, feel free to delete it if need be.
Your free to use it if you would like to
Only 4 team's pages are update date. About half haven't even been touched.
How do I edit it?
PMed it to you so it's not public here.
I've updated the almanac to show our teams' prestige changes. Here's a summary.
I was shocked to see that Michigan managed to hold on to their 5* rating. They actually finished as the 23rd ranked team which was very surprising to me.
Ole Miss (4*)
No big surprises here as all of these teams had solid years.
Georgia and Wisconsin are going in the wrong direction, but this isn't a surprise after this season. 'Sconsin got screwed by EA in the Rose Bowl, but they got stroked by EA in the CCG so they probably finished right where they were supposed to. As if things weren't bad enough for Washington and Northwestern, they're getting even tougher as a lowly 2*. They need to regain that star immediately next year. I was really surprised to see them drop to a 2* as you have to do a lot to lose that 3rd star (finish outside of the top 75). I can see a 3-9 Washington team being out of the top 75, but I'm really, really surprised that a 6-7(4-4) Northwestern team lost their 3rd star. An 8-5 Michigan team finishes in the top 25 and keeps their 5th star while a 6-7 Northwestern team can't finish in the top 75 and loses their 3rd star.
JCspartan2 Big Suge Knight dakota7 GoGators edge7771 texacotea blLL flo Nautica Randiesel75 MaslerBoros16 UofCWildcat
Ya we didn't have a good season by any means, but a vacation and some sim losses hurt us.
I couldn't play Nautica, texacotea, or edge and I lost all 3 of those games. Not saying I would have beat Nautica, but I was close with SC and beating up on Ole Miss before having to take the sim and the loss. Then I win my bowl game, but have to settle for another sim because EA sucks and I'm handed another loss.
Should have been more like 8-5 this season, maybe 9-4, and if I could have played all my user games, possibly 10-3.
Anyways, I was just downgrading myself for all you guys who said Wow, Georgia is a 5*! Lol
God... I think if i would of won my bowl i could of jumped a prestige. O well
I've created a new page in the almanac for 2012. I've updated the prestiges and added the top 25. I'm at work so I don't have access to the All Americans, so could someone add that?
I've updated the Almanac for 2012.
jello man you rock!
Arizona State's team page has been updated for 2012. The other 11 teams still need to be updated.
Did you type out your entire roster? I have to be honest, I don't have time for that.
Go to Dynasty Wire.
Download your roster.
Sort the columns in the .csv file it creates by position and then OVR (I have a custom sort that I use in a lot of spreadsheets that sorts by QB -> HB -> FB -> etc). Once you have the custom sort, it'll always be in excel for you to use at a later time.
Copy/paste from the .csv file into the google spreadsheet.
It should take 2 minutes, tops.
2 minutes for a guy who uses spreadsheets.........which I don't. I will give it a shot, thanks.
Just in case you guys don't know much about excel:
Go to Data and then Sort
Select sort by Position or you can do it by column (C in this case) if you prefer.
Sort on Values
Order select Custom List
If you don't have a list set up, click on NEW LIST
Then fill out the order you want to sort to use. See the column List entries in the lower right window for my custom position sorting list.
If you've already set up this list, just click on your custom list (mine's highlighted in blue above).
After you're sorting the positions, in this example we want to then sort by OVR.
Click Add Level in the middle window above.
Select the new Sort by as Overall (or choose the column if you prefer)
Order is Highest to Lowest
That's all there is to sorting.
jello1717 how do i paste this sucker into the google spreadsheet? I've been trying for twenty mins but i can't figure it out at all. I've copied it from the Excel file on my computer and now can't paste into the Google Doc.
CTRL/v should do it.
Yeah thats not work =/
Nevermind. It wasn't working for twenty minutes but now it works all of a sudden. Thanks
Haha........I played with it, I got something there but it ain't pretty.
I've updated the Almanac. I've added a 2013 tab and included our teams' prestige changes.
jello1717 , Nautica , and edge7771 gained a star for the 2nd season in a row.
UofCWildcat , blLL flo , GoGators , Randiesel75 , and dakota7 gained a star for the first time
JCspartan2 , MaslerBoros16 both stayed put
Big Suge Knight was the only one to lose a star.
I'm not sure what Darkwing 's prestige was, but he's @ now.
I also added all award winners to both the 2012 and 2011 tabs. (well not all, as avid doesn't have an entry for the new awards, the Nagurski, and the other one).
Thanks for doing this stuff bud.
Separate names with a comma.