2011 Projection-Based Rosters: Methods, Formulas, & Discussion ...

[rgp913]

Re: 2011 Projection-Based Rosters: Methods, Formulas, & Discussion ...

I think i speak for the masses when i say that what your doing is incredible. I cant imagine the time and dedication it takes for this. I do my own rosters for NBA2K11 and know how difficult it can be, this is that on steroids and hgh with a hit of lsd. I cant wait for this roster.

[TripleThreat1973]

Re: 2011 Projection-Based Rosters: Methods, Formulas, & Discussion ...

Nice work, interesting, are you punching them into a spreadsheet then?

It goes like this ...

[1] Copy the projections stats from website into spreadsheet, adjust the formatting.
[2] Incoporate batting split adjustements (the game really needs pitcher splits too).
[3] Calculate stats that needs to be in the "550 at bats form".
[4] Apply formulas (average them in my case).
[5] Print and get busy on the d-pad.

[Kritter77]

Re: 2011 Projection-Based Rosters: Methods, Formulas, & Discussion ...

I realize this may be asking a lot, but are you at all considering putting a program together with these formulas like Bahnzo did so we can use them?

[TripleThreat1973]

Re: 2011 Projection-Based Rosters: Methods, Formulas, & Discussion ...

I realize this may be asking a lot, but are you at all considering putting a program together with these formulas like Bahnzo did so we can use them?

Brother, if I could I would. Me no speak computer language.

Bahnzo's spreadsheet seems to suffer from the same thing as his program. The thing that seems to be messing it up is the switch to the year 2010. It was set up to work for 2009 and before.

If one could come up with a way of importing spreadsheets into that baby, it would work like a dream. Import stats, export ratings ... without having to pull the info from BR.com

It does appear that MLB11 with have a player vault where multiple people can work on the same roster files (or take different divisions/teams to work on) and then merge into one. This will move the process from weeks to days.

It's been my experience that guys like Knight, Carew and co have a database or spreadsheet full of all the values that go into a player, including facial features, accessories, etc. So, they could get almost anyone to help punch in the information.

2K is on PC, and guys have made programs that edit the rosters, and they're outstanding. Unfortunately 2K just sucks *** as a baseball game, which is unfortunate because I was having fun making all sorts of jersey for 2k9 using the same ifbb editor that's used for 2k basketball on pc.

If 2K would release some of their code, the modders could probably turn the PC version of thatgame into playable.

[TripleThreat1973]

Re: 2011 Projection-Based Rosters: Methods, Formulas, & Discussion ...

Very interesting and nice. How do you figure pitcher's pitch speeds with there pitch types?

Fangraphs and other sites like that can tell you everything you need to know.

Generally, as been my experience in other games .... walk and hits factor into control. Homers and Ks are movement ... or break in this game. One could just use walks if they wanted, since hits are only affected by pitchers in limited amounts (and only certain guys ... the whole BABIP stuff).

Basically, you're looking at the components of FIP.

If the pitch data was not available to me, I would just convert walks into control, then subtract points from each successive pitch.

Example ...

Control (Walks) = 83.

Pitch 1 Control:85 (Fastball control is +2 over control rating)
Pitch 2 Control:83 (-2 from pitch 1)
Pitch 3 Control:80 (-3 from pitch 2)
Pitch 4 Control:76 (-4 from pitch 3)
Pitch 5 Control:71 (-5 from pitch 4)

The average of the top 3 pitches = the overall control rating.

That's how I'd do it for guys that we would not have pitch FX or FG pitch values for.

My roster making/editing days go all the way back to MicroLeague for Apple 2e (it was an early personal computer, look it up *grin*) and Earl Weaver Baseball (IBM), then to Tony2, Sierra Baseball Pro (loved it), High Heat, 2K, MVP, and now here.

They all basically work the same. "Find average" rating, find average stat, work from there. Assume anything like a 73 HR season is going to be well over 100 on your scale.

[Joey]

Re: 2011 Projection-Based Rosters: Methods, Formulas, & Discussion ...

TripleThreat, awesome posts, man! This can/will help many roster editors, I'm sure! We may even try to incorporate these into our classic roster sets (that is, or course, if you are cool with it). Curious though, where did you find Bahnzo's spreadsheet info? I was actually looking for it last night!

[Rwings832]

Re: 2011 Projection-Based Rosters: Methods, Formulas, & Discussion ...

TripleThreat, awesome posts, man! This can/will help many roster editors, I'm sure! We may even try to incorporate these into our classic roster sets (that is, or course, if you are cool with it). Curious though, where did you find Bahnzo's spreadsheet info? I was actually looking for it last night!

yeah I have been trying to disect a lot of this, and if we could get this to a spreadsheet some how we could use this for the classics....that is like you said is ok with Triple....Joey would you have any idea how to do it?

[Joey]

Re: 2011 Projection-Based Rosters: Methods, Formulas, & Discussion ...

Spreadsheets like TT is doing here, yes. Program like Bahnzo's, no. Wish I did though!!

yeah I have been trying to disect a lot of this, and if we could get this to a spreadsheet some how we could use this for the classics....that is like you said is ok with Triple....Joey would you have any idea how to do it?

[Rwings832]

Re: 2011 Projection-Based Rosters: Methods, Formulas, & Discussion ...

Spreadsheets like TT is doing here, yes. Program like Bahnzo's, no. Wish I did though!!

Should we put one together for us to use then???? Hopefully it will be ok with TT.

[Joey]

Re: 2011 Projection-Based Rosters: Methods, Formulas, & Discussion ...

Definitely a possibility. We'll see what TT has to say about it.

Should we put one together for us to use then???? Hopefully it will be ok with TT.

[Knight165]

Re: 2011 Projection-Based Rosters: Methods, Formulas, & Discussion ...

TripleThreat...

Fantastic.
I gotta say...you and I think alike...but you wind up doing a lot more work!(I mean that in a good way....that's some dedication right there. Nice)
This is some project.
If you run into any snags...hit me up. Sounds like you've got it covered though.

M.K.
Knight165

[TripleThreat1973]

Re: 2011 Projection-Based Rosters: Methods, Formulas, & Discussion ...

TripleThreat...

Fantastic.
I gotta say...you and I think alike...but you wind up doing a lot more work!(I mean that in a good way....that's some dedication right there. Nice)
This is some project.
If you run into any snags...hit me up. Sounds like you've got it covered though.

M.K.
Knight165

If you see anyting that is off, please let me know. By that, I mean anything that is going to skew gameplay and results to a degree that it ruins it.

For example, early on I was using Runs Created for Clutch, but the results would have been Pujols with a cluth of 99, etc. So, my thinking was that anytime guys were on base, he'd be automatic runs, and that would ruin the gameplay. So, I scaled it to be between 55-75 for the most part, for both batters and pitchers.

What is your thought of relievers having K9 ratings in the 90s? Many of them will just because their K9 stats are above league average. I thought of having a sepearte scale/formula for relievers, but then that might have the opposite effect where they don;t strike out as many as they should, and you'd be better off just leaving in a tired starter, which we know is not good management.

---------------------------------------

To the other guys ... anythng I post should be considered "donation to the community". Use it however, whenever, you want. Improve it, alter it, whatever you want to do.

The more people making rosters, current, classic or otherwise just strengthens the community and the enjoyment of the game.

The way I understand the player vault for MLB11 is that once someone makes "Mookie Wilson", anyone can import him into their rosters. Then we'd just need to change his ratings for whatever year we were making. Theoretically, there could be a roster for every year of baseball, and it wouldn;t be impossible to do so. That would be awesome.

It is however customary to give credit to whatever roster you're using.So, for example, if one were tweaking Knight's rosters, they had better give him credit for the base work (or even ask for permission to use ... even though I forgot to). I posted Bahnzo's formulas under the premise that he relesed those to the public in his spreadshet.

I also posted them in such a way that you could just copy them into the formula bar in excel and double click on the stat abbreviation (or highlight it) and then click on the cell you want to use it on and it would change it in the formula bar. Then just copy that cell and paste it into the whole column and change the ratings for thousands of players in mere seconds.

The more poeple making rosters, the better. Lots of people have contributed to the process over the years, starting with Robert Glass and Paul W (and Swinging Soriano, P-Diddy, KG, Totte, and others) from the MVP and MVP edit days.

I'd love to hear RCarew's full thoughts on ratings and such, but I understand why he is reserved in revealing his methods.

Having an established and well-known consensus on the scales and formulas would be critical to all future roster endeavors. Quality control, so to speak.

[TripleThreat1973]

Re: 2011 Projection-Based Rosters: Methods, Formulas, & Discussion ...

bahnzo's spreadsheet is still in thsi forum.

When you search type in something like "Bahnzo editor" or "Bahnzo Spreadsheet" and it's something like version 3, and you can download it from there.

When I found that, I felt like I had hit the jackpot.

What I noticed though was that his power, contact, vision, and discipline, were a little lower than Knights. I chose to go with Knights, because that is the scale that I had my sliders tuned to, and I wa getting incredibly accurate results.

I was worried it I used Bahnzo's complete formulas that I might get gameplay to titled toward the pitchers ... or have to redo my sliders completely (which is laborsome process to test in 20-game segments ... 4 times through the rotation, series against 6 different teams).

I'd be curious to hear from Knight if he saw something to, and made some adjustments to his, or if he is just using the same methods he always has (why fix it if it ain't broken?).

I think one could probably just use Bahnzo's complete formulas for a classic roster and have consistency and accuracy all the way around. Just looking at his formulas, he did some thorough research and testing to arrive at the modifiers that he did.

I understand that guys have put a lot of work into their formulas, scales, etc and may not wish to divuldge everything. I'm not really in that position since I did not do any of the foundational work. Nor can I really make any "intellectual property" claims on anything. Like I said I worked of the average starter rating from the OSFM rosters. I could/would have done the same thing with the SCEA rosters, but gentlemen already improved on those ratings, so why re-invent the wheel?

That's what killed MVP rosters. It got to the point where if anyone new wanted to make rosters they had to go back and edit the original rosters that came with the 2005 game, and no one was going to go back and create 5 years worth of new players, etc.

[TripleThreat1973]

Re: 2011 Projection-Based Rosters: Methods, Formulas, & Discussion ...

Bahnzo's complete suite ...

http://www.operationsports.com/forum...available.html

Here's the spreadsheets you're looking for.

Again, much credit to Bahnzo, Knight, RCarew, and all of the others I am missing. Great work that makes a very good game, a great game. Shame on me for wasting 3 years trying to get 2k7-9 to "work right".

[gtm]

Re: 2011 Projection-Based Rosters: Methods, Formulas, & Discussion ...

TT, will you be fitting all this formula stuff and make a final version of a spreadsheet so the attribute ratings come out the same for everyone? Thanks for doing this.