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

[Rwings832]

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

Is anyone reworking Bahnzos formulas, if not would someone post all the formulas he used for pitching and batting. This will be going to excel so I need the correct way to enter the formula. I will then need to know what numbers I will need to input to get the correct aatribute numbers. Since we can't access Baseball-Reference with his roster tool.

I think all the formula's are on the first page that Bahnzo used....he kind of runs down how Bahnzo did it, and then how he is doing it.

[gtm]

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

I think all the formula's are on the first page that Bahnzo used....he kind of runs down how Bahnzo did it, and then how he is doing it.

Thanks Rwings. I didn't know if someone was going to make any changes. I heard they are off to what Knight's numbers are.

[Rwings832]

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

Thanks Rwings. I didn't know if someone was going to make any changes. I heard they are off to what Knight's numbers are.

Are you thinking about doing a spreadsheet?

[gtm]

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

Are you thinking about doing a spreadsheet?

I hope someone will that know's how to calculate the formulas and such. My wife will help me only when she has time. She's a professional working woman and her work is endless but we will work on the information that TT posted. Please don't think in any way that this will happen soon. Let's still hope someone will jump on it sooner than later.

[TripleThreat1973]

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

I think all the formula's are on the first page that Bahnzo used....he kind of runs down how Bahnzo did it, and then how he is doing it.

What?

I think Bahnzo's formulas are awesome, and said so.

What I said was that I noticed his ratings for batting contact, power, vision, and discipline were about 10 points lower than Knights.

I stated that my sliders were geared towards the OSFM ratings, so I averaged bahnzo's rating with my own ratings.

This wasn't because I don't think Bahnzo's formulas are not great, but because I did not want to go through the slider tweaking process again. I just want to be able to start my franchise once the ratings are done.

I think Bahnzo is a damn genius.

I was concerned that if I used his ratings, with my sliders, the offense might be light. That's it.

I think one could use Bahnzo's formulas and get a great set of rosters.

[Jaffa]

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

What?

I think Bahnzo's formulas are awesome, and said so.

What I said was that I noticed his ratings for batting contact, power, vision, and discipline were about 10 points lower than Knights.

I stated that my sliders were geared towards the OSFM ratings, so I averaged bahnzo's rating with my own ratings.

This wasn't because I don't think Bahnzo's formulas are not great, but because I did not want to go through the slider tweaking process again. I just want to be able to start my franchise once the ratings are done.

I think Bahnzo is a damn genius.

I was concerned that if I used his ratings, with my sliders, the offense might be light. That's it.

I think one could use Bahnzo's formulas and get a great set of rosters.

I can't access Bahnzo's formulas. Can you post your formulas for pitch movements/breaks.

[Kritter77]

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

I think when he says "runs down" he means you go over them, post them if you will, not disrespects...

[Rwings832]

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

What?

I think Bahnzo's formulas are awesome, and said so.

What I said was that I noticed his ratings for batting contact, power, vision, and discipline were about 10 points lower than Knights.

I stated that my sliders were geared towards the OSFM ratings, so I averaged bahnzo's rating with my own ratings.

This wasn't because I don't think Bahnzo's formulas are not great, but because I did not want to go through the slider tweaking process again. I just want to be able to start my franchise once the ratings are done.

I think Bahnzo is a damn genius.

I was concerned that if I used his ratings, with my sliders, the offense might be light. That's it.

I think one could use Bahnzo's formulas and get a great set of rosters.

Yeah like Kritter77 said, that is not what I meant, I don't see where you thought I disrespected you??? gtm asked about his formula's and I pointed him in that direction...but take it how you may...don't worry I won't lose sleep over it!

[gtm]

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

Fella's, please don't start having negative feelings with each other. TT, I'm glad you shared your thoughts and how you used Bahnzos roster tool and made your own changes for slider purposes. This very much put this topic in perspective. Most of us are use to Knights ratings but then again, there are also plenty of us that have no clue on how to do ratings and that is where Bahnzos roster tool helped immensely. So let's make peace before we start a war.

[Joey]

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

I'll add that I used Bahnzo's ratings almost exclusively in my '86 set I did and the numbers came out very close to the real-life stats. Bahnzo definitely knew what he was doing, and after going through all of TT's posts I'll say he definitely knows what he's doing, as well. I say the more discussion about this, the better, as we're all after the same thing in the end - accurate ratings.

We'll take all the insight you can give us, TT!

[Dave151]

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

I have just recently purchased a PS3 and The Show, and am really enjoying getting used to the game play and trying to become a better hitter. I stumbled across this thread, and I just wanted TT, and anyone else who is willing to put in this kind of time and effort, know how much his work is appreciated. This roster set sounds like it will be really great and enhance the playing experience for many of us. You have clearly put a lot of thought, time, and effort into this project, and it doesn't go unnoticed. Thanks a lot!

[TripleThreat1973]

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

Fella's, please don't start having negative feelings with each other. TT, I'm glad you shared your thoughts and how you used Bahnzos roster tool and made your own changes for slider purposes. This very much put this topic in perspective. Most of us are use to Knights ratings but then again, there are also plenty of us that have no clue on how to do ratings and that is where Bahnzos roster tool helped immensely. So let's make peace before we start a war.

I'm not at all upset. I just didn;t want the idea to be out there that I was somehow disparaging Bahnzo's formulas/ratings.

[1] That's not my style.
[2] If I am able to get his spreadsheet working, I'll likely need to ask his help/advice. If he thinks, for whatever reason, I have slammed his work .... he's not likely to help.

I'm currently running a comparison of Bahnzo v. OSFM/Knight ratings to see if there is, a quantifiable, difference.

Like I said, I wanted the ratings to be congruent with OSFM/Knights, because that is where my sliders are set. So, I averaged Bahnzo's ratings with my own, to achieve that.

[gtm]

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

I'm not at all upset. I just didn;t want the idea to be out there that I was somehow disparaging Bahnzo's formulas/ratings.

[1] That's not my style.
[2] If I am able to get his spreadsheet working, I'll likely need to ask his help/advice. If he thinks, for whatever reason, I have slammed his work .... he's not likely to help.

I'm currently running a comparison of Bahnzo v. OSFM/Knight ratings to see if there is, a quantifiable, difference.

Like I said, I wanted the ratings to be congruent with OSFM/Knights, because that is where my sliders are set. So, I averaged Bahnzo's ratings with my own, to achieve that.

Wow, so you have already started? Thanks for posting the formulas and detailed information. It may be that you'll have something for us concrete in the not too distant future. I say that because you seem to understand and know how to arrange the formulas. Please keep us informed.

[TripleThreat1973]

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

have my own spreadsheet that I use to convert stats into ratings via formulas.

I don;t think anyone will be able to get Bahnzo's spreadsheet to work in regards to being able to "pull stats from baseball-reference" and other websites. Most likely, they are blocking such things, which is why he "can;t fix it". There's nothing to fix.

What I would look at, after I finish these rosters, is if there is a way to copy and past stats into his spreadsheet so that it calculates ratings. What that would likely require is a new "sheet" in his worksheets that one could copy stats into, and then edit all of the other worksheets so that the stats from those cells go into the cells that Bahnzo's formulas need them in.

Even then, it's going to be a whole lot of copying and pasting ... and it may not be worth it. What I could do that might be much simpler for those not excel-savy (I'm only moderate), is to produce a table for tall the stats using his formulas that show what each stat correlate to what rating.

For example, 99 through 1 listed on the left, the various stats/categories on the top (BA, HR, etc), and then in the cells are the sta that would correspond to that rating (i.e., 87 = 319 BA).

He did so much work and had the skill to be able to pull the data and have the computer sort it into how he needed it, that I'm not sure anyone else can (or would) be interested in figuring out a way to do it.

One oculd also use a workaround where stats are pulled into a non-spreadsheet program (spiders?) and then altered somehow (multiplied by one?) to where the value stays the same but loses any tags (I may just be makikng crap up at this point), and then another way of getting that into a spreadsheet that feeds into a program and blah blah blah.

Basically we've been sent back to the 1950s. Not quite the stone age, but far enough back that we'll be doing a lot of busy work.

[Joey]

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

"(I may just be making crap up at this point)"

That's hilarious, TT! Anyway, yeah, I think any form of pulling the info off of Baseball Reference and into a spreadsheet in copy and paste form is going to require a ton of work (as you alluded to). I guess the simple (and somewhat archaic) way would be to manually input stats into a spreadsheet and let it calculate the ratings that way.

have my own spreadsheet that I use to convert stats into ratings via formulas.

I don;t think anyone will be able to get Bahnzo's spreadsheet to work in regards to being able to "pull stats from baseball-reference" and other websites. Most likely, they are blocking such things, which is why he "can;t fix it". There's nothing to fix.

What I would look at, after I finish these rosters, is if there is a way to copy and past stats into his spreadsheet so that it calculates ratings. What that would likely require is a new "sheet" in his worksheets that one could copy stats into, and then edit all of the other worksheets so that the stats from those cells go into the cells that Bahnzo's formulas need them in.

Even then, it's going to be a whole lot of copying and pasting ... and it may not be worth it. What I could do that might be much simpler for those not excel-savy (I'm only moderate), is to produce a table for tall the stats using his formulas that show what each stat correlate to what rating.

For example, 99 through 1 listed on the left, the various stats/categories on the top (BA, HR, etc), and then in the cells are the sta that would correspond to that rating (i.e., 87 = 319 BA).

He did so much work and had the skill to be able to pull the data and have the computer sort it into how he needed it, that I'm not sure anyone else can (or would) be interested in figuring out a way to do it.

One oculd also use a workaround where stats are pulled into a non-spreadsheet program (spiders?) and then altered somehow (multiplied by one?) to where the value stays the same but loses any tags (I may just be makikng crap up at this point), and then another way of getting that into a spreadsheet that feeds into a program and blah blah blah.

Basically we've been sent back to the 1950s. Not quite the stone age, but far enough back that we'll be doing a lot of busy work.