RBI 3 - updated 2013 version with CSV!

[BravesPaul]

CSV is attached and corrected. Simply rename the TXT extension back to CSV, and go! (My first posts where this started are here: https://forums.dee-nee.com/index.php?topic=29092.40.  Feedback is welcome, contact info is below.)

Rosters:
Fourteen most used batters and ten most used pitchers chosen for each team, with multi-team players going to the team they played for most (if they're still in that team's 14 or 10). Very few liberties were taken, but occasionally where playing time was close I grabbed the next guy instead.  This was more common for pitchers, but wasn't all that common. I also reviewed every team's 2013 batting orders to set lineups as accurately as I could, with the fifth IF or fourth OF necessarily hitting 9th, since they're the odd man out in an NL park.  And for switch hitters, the default stance is usually whichever he had the higher OPS from.

Values for Player Abilities:
HITTERS: Contact is based on batting average, as in the 1990 original. Speed and power are based on home runs and steals per plate appearance so, for example, a power hitter like Evan Gattis has the power of a 35-HR hitter since he hit 21 HR in somewhat limited playing time.  PITCHERS:  Stamina is variable based on a pitcher's innings per start or innings per relief appearance.  Instead of the 48 default, most starters are in the 52-60 range.  Instead of the 15 default, most relievers are in the 15-18 range.  The Sink and LCurve/RCurve values based somewhat on ERA, and strikeouts/walks/HBP per inning.  I looked up every pitcher's pitch speeds, so those should be very accurate, and Aroldis Chapman throws slightly harder than the hardest thrower in the 1990 game.

How I got the values (I'll share the formulas later):  I sorted each rating in the 1990 original to determine the minimum, maximum, and normal values, then devised algebraic formulas based on 2013 stats to match them. Hitting is very straight forward (home runs and stolen bases!), while the major gameplay-relevant values for pitching (Sink and LCurve/RCurve) have nothing to do with a pitcher's actual pitch selection and much more to do with their real-life tendency to be difficult to hit.

Defense:
Team defenses adjusted based on each team defense's outs per ball in play, with a minor adjustment for fielding percentage.  The percentages for most teams is slightly better than the 1990 original, because I don't like errors all that much, but I don't want them at 0% either.

Feedback? Errors?
It should feel like the original, but with 2013 rosters and stats!  I tried to make everything perfect, but it's hard to proofread my own work, especially after gathering stats for 420 hitters and 300 pitchers.  Please report any errors to me here or @Braves_Paul on twitter (or just follow me for fun if you like LOTS of baseball talk)... Or just share an update.

Other projects:
I have a playable All-Time Rosters version, but I have not yet added pitchers.  Each team plays like the All-Star teams from the 1990 game, but slightly better.  More on player selection and stats later.  I should be ready to share this one in the next week or so, and I'll probably have to guess a lot on pitch speeds... And, good news, the formulas of the 2013 version are very easy to work with, so it's just a matter of inputting data.  A 2012 version may be coming soon, and an end-of-2014 version will be done in early October if the site is still up!

[BravesPaul]

Ha. I updated the my first test version of the CSV instead of the corrected one.  The one in the previous entry originally had three 9-letter names, and ERAs below 1.38. Both files are now corrected, but it's attached here too to find it more easily.

[Gantry]

Not on first glance, may want to try a free file validator program:

http://blog.flat-file.net/2010/04/how-to-validate-csv-file.html

[BravesPaul]

I fixed the problem. I had it working once, but then copied columns wrong a wrong CSV in my last run through. All better now.

[VEGAS]

I blame the volume of tequila consumed today (or maybe my rbi editor noob status), but I am struggling to convert this to a csv file, then run it through the rbi3 editor an d produce a functioning ROM to fire up and keep me from doing any real work for the rest of the week.. Can someone help a drunk RBI fan and convert BravesPaul's work into a ROM that I an other can download and play?
PLEASE.

[BravesPaul]

Go to http://rbi3.ca/. Read that page, then click "Create RBI 3 Gamefile" at the top. You'll need to upload my CSV and an original RBI 3 ROM, then suggest a filename for the new creation, then click Upload - and download the new ROM on the next page.

Keep that in mind in case you want to build one yourself, but I've attached the working .nes version to this post. Enjoy!

[VEGAS]

you beautiful beautiful man. My day will now be filled with RBI 3. thanks.

Go to http://rbi3.ca/. Read that page, then click "Create RBI 3 Gamefile" at the top. You'll need to upload my CSV and an original RBI 3 ROM, then suggest a filename for the new creation, then click Upload - and download the new ROM on the next page.

Keep that in mind in case you want to build one yourself, but I've attached the working .nes version to this post. Enjoy!

[BravesPaul]

And, finally, here's the spreadsheet with the formulas.  Ask questions, make suggestions, etc.  Hitters on sheet 1, pitchers on sheet 2, defense not included (I closed without saving, oops).

This copy is saved using Microsoft Office 2010 Excel.  And zipped.

[BravesPaul]

Updated again. I noticed that all the San Diego pitchers were righties because I didn't fill that in for them (R is my default in my spreadsheet formula), so I fixed that... and while I was at it, I added the sidearm stance to the six sidearmers who made the cut based on playing time, and I made adjustments to maybe four or five starting rotations to get a terrible starter out of the #1 slot.  Basically, for gameplay's sake, I put the best pitcher at #1.

ALSO!  I toyed with all of the jersey colors and picked the combos I thought fit most naturally.  They're what I want them to be, anyway.  Try different teams out!

v5 attached as TXT (change to CSV) (.nes available upon request)

I also spent a lot of today trying to figure out what the CPU1/CPU2 values meant.  I've noticed that, for each pitcher, they center around the number 127/128, which is a common number in 2-bit programming, but I couldn't figuer out what it meant.  For a moment I thought that a slightly lower CPU1 number meant a pitcher barely moved and barely threw curveballs or sinkers, but when I went even lower, it broke my theory.  Maybe I need to stick within 16 or 32 of 128 and see what happens.  But, for now, no solid theories.  I'll keep trying to figure it out.

[VEGAS]

.nes version requested.

thanks in advance!

Updated again. I noticed that all the San Diego pitchers were righties because I didn't fill that in for them (R is my default in my spreadsheet formula), so I fixed that... and while I was at it, I added the sidearm stance to the six sidearmers who made the cut based on playing time, and I made adjustments to maybe four or five starting rotations to get a terrible starter out of the #1 slot.  Basically, for gameplay's sake, I put the best pitcher at #1.

ALSO!  I toyed with all of the jersey colors and picked the combos I thought fit most naturally.  They're what I want them to be, anyway.  Try different teams out!

v5 attached as TXT (change to CSV) (.nes available upon request)

I also spent a lot of today trying to figure out what the CPU1/CPU2 values meant.  I've noticed that, for each pitcher, they center around the number 127/128, which is a common number in 2-bit programming, but I couldn't figuer out what it meant.  For a moment I thought that a slightly lower CPU1 number meant a pitcher barely moved and barely threw curveballs or sinkers, but when I went even lower, it broke my theory.  Maybe I need to stick within 16 or 32 of 128 and see what happens.  But, for now, no solid theories.  I'll keep trying to figure it out.

[BravesPaul]

.nes of the fifth attempt of my 2013 version of RBI Baseball 3. I think it's set now.