So having 1 bad year causes you to drop down to a 5* even after winning 3 national titles in a row?(counting the one IRL) They may want to fix that next year for NCAA 14.
So having 1 bad year causes you to drop down to a 5* even after winning 3 national titles in a row?(counting the one IRL) They may want to fix that next year for NCAA 14.
You set the bar really high - the fans wont stand for one bad year! You must be in the running EVERY YEAR!
It is crazy how that is set up. I will be interested to see how NCAA 14 has Auburn rated.
Well, if memory serves, one GREAT year (like a MNC) will move you up. So ...Originally Posted by ryby6969
Twitter: @3YardsandACloud
Touchdown Jesus had to intervene..
That's a pretty nice ace in the hole to have.
I posted this up above but thought I'd post it here as well since it's specific to this OD and also so that psuexv & Jeff will see it as I imagine they'll at least have a passing interest in it.
I've put together a spreadsheet on Google Docs that I use to track my roster (particularly for the next season) and my recruiting.
This should be readable for everyone, but let me know if it's not.
https://docs.google.com/spreadsheet/...UxPbk9mU0JrOWc
The latest revisions are mostly only on S4-Roster, S4-Depth, and S3-Recruits. This was all used during the 3rd season so it allowed me to plan for the next season to determine where I would have holes not only next year but for the future. It also lets me plan out my redshirts (with red text), player cuts (with a strikethrough), and position changes. We're finishing up Season 3 now so since it's more or less finalized, I wanted to share it with everyone to get any kind of feedback you guys wanted to share, even if just to say I have too much time on my hands.
On the roster tab (S4-Roster), The first 5 columns are self-explanatory, Name, Position, Year, OVR, and Tendency. The PosYr column is a concatenation of Pos & Year in order to build the roster breakdown that you see to the right (I'll get to that in a minute). The PosSort is so that I can sort it by a normal roster (QB, HB, etc.) and the YrSort is essentially the same, just sorting by SrRS, Sr, JrRS, etc. PosYr, PosSort, & YrSort are calculated columns, thus they are greyed; PosYr as explained is a concatenation, whereas PosSort and YrSort are lookups from the Resources tab (last one). The ones that have their Year highlighted means that they were a new recruit for that season (Freshman & JUCOs).
As for the Roster breakdown on the right, it's actually a nice little calculated section I put together that tracks the yearly breakdown for each position as well as the two highest rated OVR players at each position. The positional breakdown is actually pulling unique values from the Pos column on the roster so if you don't care to track FBs, it won't list them or if you only care to track WRs (not arrangement specific), you can list them all as WRs and see the breakdown that way.
On the depth tab (S4-Depth), this is just a visual break down of a 2-deep depth chart. The Positions are manually entered as are the Names but based on the name, it will do a lookup of the Year and OVR. This page will help you determine how "old" your team is based on contributors. If you have a really senior-heavy team, then this will tell you that you need to make sure you're ready for the future. It also highlights those Seniors as well as Freshman to point out those players.
On the recruits tab (S3-Recruits), this is a fairly straight-forward recruits tracker. The first column is the order they appear (the 99s are just a buffer), the OVR is their post-scouting OVR, their Scout column is a percentage of the next two columns, the first is how many attributes you have scouted, the second is how many attributes they have (it's a lookup from Resources). Next is their original OVR, so you can see how they finished versus where they started using the Diff column (simple subtraction from OVR), and then finally are the remainder of the manual columns, Prestige, Position (default), possible Position Changes (particularly for ATHs & Right vs Left positions), Interest level, when they visit, whether you've offered a Scholarship, and then Competition (particularly fellow User teams). The final is just a Notes column, sometimes I'll highlight most important traits for an ATH or what traits I haven't scouted, or whatever.
You'll also see previous years which will also give you an idea of how this thing started and how it got to where it is. As well is a S5 set for the next season we're getting ready to start.
Finally, there is the Training Results and the Resources tabs. The Resources tab is just simply used for other pages to lookup information such as PosSort, number of ratings to scout for each position, and so on.
On the Training Results, it's also a little creation I put together for me to be able to see how each player I've had over the years has progressed. The first four columns are pulled from the Resources page, which is just a list of every seasons roster... the lookup will only pull unique values so there will only be one record for each player. The next columns is a breakdown of each player for that year (2013, 2014, 2015, 2016, etc.) including their year and their OVR for that year. Then finally is a Progression column which shows how much they've grown over the years (min - max) and their MaxOVR which is the highest point they reached. It's not a very friendly sorting on the default spreadsheet page but if you look at it in List View you can sort it by year, position, etc. quite easily.
You can make a copy to your own Google Docs by doing File > Make a Copy. Once you have it in your own, you'll have to update named ranges, calculations, etc. but in about 10 minutes worth of work you should be able to have your own version up & running. For the roster, I just do a download from the OD site, then concatenate the player names into one column.
Hopefully this will end up helping someone else out and will be valuable to someone else. Obviously if you share your own version with anyone else I would appreciate some kind of credit as I have spent way too much time working on this.
Good stuff G. I started doing something like this during season 1 in Word, but it became too much work.
I, for one, am very glad that Johnny Manziel was inaccurately rated in NCAA 13.
Twitter: @3YardsandACloud
G, that spreadsheet is pretty awesome. I definitely need to do something, if not by next season or two, at least by NCAA 14 to track stuff a little better. For NCAA 11 I was mainly tracking my recruiting, week to week point totals, points behind, etc. After fighting in Powerhouse this year, I've realized that stuff doesn't matter as much, and I need to do a better job of planning my roster. I spend way too much time at the end of the year planning my roster. I could save myself a lot of time with a system like what you've got.
As for "too much time on my hands", at least yours is in a spreadsheet. Until this year, I've been doing 99% of my work with pen and paper. So while I can refer back to it and copy old ideas pretty easily, the reusability was nil. That's a huge reason why I spend so much time on NCAA ..... and I really need to cut down on that, if I'm going to get anything else done
Twitter: @3YardsandACloud
I was just telling snoop, I think my players are overrated!
That is awesome G! Thanks for putting in the leg work on it. I'm am definitely going to start plugging my info in to this. Very good stuff.
Awesome. Let me know if you need any help... it has a lot of stuff but it's organized for my brain so not sure if getting it setup makes much sense. One thing to be mindful of, the Yr fields have to at least start with the same choices I start with... Fr, Jr, etc. You can call them FrR or FrRS or FrRedshirt or whatever, but the breakdown by position/year uses the first two characters of that designation.
Other than that, it should be fairly straight-forward but happy to help if you need it.
ND- Ohio State
ND-Michigan
Watching the SECCG really makes me hope they redo line interactions for NCAA 14. Really would like to be able to just pound the ball like that because of an elite oline. Hopefully they will find a balance between the different styles of play so 1 or 2 are not so much more effective then the others.
What would everybody else think about, for NCAA 14, changing from "Powerhouse" teams to "Rise of the Powerhouse" teams? Basically, teams that either used to be great and are now just below that level, or teams that aren't quite there yet. Maybe limited to 4-star teams? Something like that. Anyway, just an idea bouncing in my head that I wanted to throw out there. I'm always personally more interested in taking over lower-level programs, but doing that in PH would be intentionally screwing myself
Last edited by JeffHCross; 12-06-2012 at 09:46 PM.
Twitter: @3YardsandACloud
As long as at worst I could us Miami, I am fine!
True. Though one reason I'm suggesting this now is that the dynamic conference pitches make a big difference for teams that are on the rise.
Twitter: @3YardsandACloud
I'm sure Papa and Oneback are loving this ...
Though I do think you have to give them credit for the advertising
Twitter: @3YardsandACloud
It should say something along the lines that the Longhorns have the best defensive backs playing quarterback for other teams... I'm sure it's somewhat well known by now but Brown & company wanted both Griffin III & Manziel to play DB for them.
Posting Permissions
Reply With Quote
Bookmarks