RBU Release thread

[blackhawksfan4ever19]

JTommy> have a problem. I'm trying to use your latest "custom calculator" for my College Roster and when I type in some STATS it goes to a pop up asking for a "PASSWORD" to continue and I cant get past it unless I turn it off using control panel.

The ONLY calculator I've been able to use freely is your 2017 version.

Anything you can do?

[JTommy67]

Quote: Originally Posted by theoriginal561

My question if you still are around, does the HR/9 rating affect anything for pitchers? I notice even in the custom player sheet I've had guys have a HR/9 at 0 and that seems...odd? I like that its lower or higher depending the year. But I wanted to be sure that wasn't some error in the sheet or that it doesn't matter. I don't think it affects anything in actual gameplay but sim I just never know.

If you're seeing this in the custom player sheet, I would have to see what, specifically, you input. Can you post a screenshot?

[JTommy67]

Quote: Originally Posted by blackhawksfan4ever19

JTommy> have a problem. I'm trying to use your latest "custom calculator" for my College Roster and when I type in some STATS it goes to a pop up asking for a "PASSWORD" to continue and I cant get past it unless I turn it off using control panel. The ONLY calculator I've been able to use freely is your 2017 version. Anything you can do?

I'm unable to reproduce this in 21v1 or 20v2. Can you provide more details or upload your custom calculator file so I can troubleshoot where/how the corruption happened?

[theoriginal561]

Quote: Originally Posted by JTommy67

If you're seeing this in the custom player sheet, I would have to see what, specifically, you input. Can you post a screenshot?

I'm assuming that issue is just a weird quirk with the player calculator and my data. I'll get a screenshot to replicate it.



Maybe this answers that issue but is there a reason for HR/9 being so low in the "historic" rosters? Does that not create a very weird problem where Starters are giving up TOO many homeruns or they give up a more realistic amount and I'm panicking for nothing?

[blackhawksfan4ever19]

Quote: Originally Posted by JTommy67

I'm unable to reproduce this in 21v1 or 20v2. Can you provide more details or upload your custom calculator file so I can troubleshoot where/how the corruption happened?

JTommy here is a link to the file I talked about.

https://docs.google.com/spreadsheets...f=true&sd=true

[JTommy67]

Quote: Originally Posted by blackhawksfan4ever19

JTommy here is a link to the file I talked about.

Well I can say the problem is almost certainly arising from the fact that the standalone calculator was uploaded to google docs, which prohibits the VBA code from functioning properly. An entirely different set of scripts would have to be written to get around this, of which I have no experience. This is why I posted that my tool is not compatible with online versions of excel.

That said, I entered a full screen of stats and saw no errors, but of course the macro buttons don't work so the player cannot be exported to the output page, so I am unsure what specifically you're doing. to trigger the password prompt.

[JTommy67]

Quote: Originally Posted by theoriginal561

Maybe this answers that issue but is there a reason for HR/9 being so low in the "historic" rosters? Does that not create a very weird problem where Starters are giving up TOO many homeruns or they give up a more realistic amount and I'm panicking for nothing?

I'm going to repost what I posted some time ago when questioned about this. Hope it helps:


With each new version of the game, the sim engine calibration changes based on what's happened the past few years in MLB. This is done (I believe) to keep their ratings scales from shifting too much. There's been a significant uptick in HR numbers the past few years and I think this was finally reflected in the this past year's game, because the previous scale was producing way too few HRs in my 2021 testing.

My mind's not on it like it was when I made the adjustments, but I recall being very surprised myself at how low the HR ratings needed to be to reproduce the same outcomes as before. For some years, the swing was a many as 10+ points, and while this was alarming, when I created my 1983 roster based off the new scales, it worked perfectly in the sim engine, and the subsequent franchise season I played out was fine.

I test meticulously; when I create a test roster I will sim as many as 10 seasons and average out the results b/c there can be quite a bit of variability even between individual seasons. The whole thing is quite a headache. And I have no way of testing all historical eras at once, so certain years might be off, as I suspect the most recent seasons (2016+) probably are, but since my utility is primarily for historical roster makers, I'm not as concerned about that.

I would still recommend when you create a roster to sim out some seasons and note HR totals (I use avg HR per team as a metric) and compare with MLB totals for that year. If it's off you can add or subtract a few points from the HR/9 ratings.

All of this is one reason I have to readjust with each new game release, but is also why I recommend only using the RBU version that corresponds to game release you're playing.

[blackhawksfan4ever19]

Quote: Originally Posted by JTommy67

Well I can say the problem is almost certainly arising from the fact that the standalone calculator was uploaded to google docs, which prohibits the VBA code from functioning properly. An entirely different set of scripts would have to be written to get around this, of which I have no experience. This is why I posted that my tool is not compatible with online versions of excel. That said, I entered a full screen of stats and saw no errors, but of course the macro buttons don't work so the player cannot be exported to the output page, so I am unsure what specifically you're doing. to trigger the password prompt.

ok tommy thanks for checking it out. appreciate your time