Home | Webstore
Latest News: OOTP 26 Available - FHM 11 Available - OOTP Go! Available

Out of the Park Baseball 26 Buy Now!

  

Go Back   OOTP Developments Forums > Prior Versions of Our Games > Earlier versions of Out of the Park Baseball > Earlier versions of OOTP: General Discussions

Earlier versions of OOTP: General Discussions General chat about the game...

Reply
 
Thread Tools
Old 08-11-2009, 12:44 PM   #1
wellsoliver
Major Leagues
 
wellsoliver's Avatar
 
Join Date: Aug 2009
Location: San Diego, CA
Posts: 337
Argh- innings pitched in the sql/csv export

So the 'ip' column in players_game_pitching_stats is a tinyint, which means it shaves off the decimals .333 and .667 (for like 1.2 IP, etc).

Is there some way to obtain the decimals in the exported data that I' maybe missing?
wellsoliver is offline   Reply With Quote
Old 08-11-2009, 12:53 PM   #2
Bluenoser
Hall Of Famer
 
Bluenoser's Avatar
 
Join Date: Mar 2002
Location: In The Moment
Posts: 14,127
It's possibly there but your cells aren't formatted to show decimals. Highlight the cells, right click, and select format. Then choose the number format for decimals and how many places (in this case 3) you want after the point.
Bluenoser is offline   Reply With Quote
Old 08-11-2009, 12:56 PM   #3
wellsoliver
Major Leagues
 
wellsoliver's Avatar
 
Join Date: Aug 2009
Location: San Diego, CA
Posts: 337
Do this where? In my DB server? That won't help with the data not being exported by OOTPx.
wellsoliver is offline   Reply With Quote
Old 08-11-2009, 12:57 PM   #4
fhomess
Hall Of Famer
 
fhomess's Avatar
 
Join Date: Nov 2002
Posts: 3,637
There's two innings fields. IP and IPF. IP is the number of innings. IPF is the fractional number of innings.

To get total IP, you should do (3*IP+IPF)/3.
This is true in EVERY one of the data dumps that contain innings (all the fielding and pitching stats files).

Example:
A pitcher with 234 2/3 innings will have IP=234 and IPF=2.
__________________
StatsLab- PHP/MySQL based utilities for Online Leagues
Baseball Cards - Full list of known templates and documentation on card development.
fhomess is offline   Reply With Quote
Old 08-11-2009, 12:58 PM   #5
Bluenoser
Hall Of Famer
 
Bluenoser's Avatar
 
Join Date: Mar 2002
Location: In The Moment
Posts: 14,127
In excel, or whichever spreadsheet you're using to open the CSV file.
Bluenoser is offline   Reply With Quote
Old 08-11-2009, 01:03 PM   #6
wellsoliver
Major Leagues
 
wellsoliver's Avatar
 
Join Date: Aug 2009
Location: San Diego, CA
Posts: 337
IP and IPF! Beautiful. I figured it was there.
wellsoliver is offline   Reply With Quote
Old 08-11-2009, 01:15 PM   #7
Questdog
Hall Of Famer
 
Questdog's Avatar
 
Join Date: Jun 2006
Location: In a dark, damp cave where I'm training slugs to run the bases......
Posts: 16,142
Quote:
Originally Posted by fhomess View Post
There's two innings fields. IP and IPF. IP is the number of innings. IPF is the fractional number of innings.

To get total IP, you should do (3*IP+IPF)/3.
This is true in EVERY one of the data dumps that contain innings (all the fielding and pitching stats files).

Example:
A pitcher with 234 2/3 innings will have IP=234 and IPF=2.
Not to be picky, but IP + IPF/3 is a little more effecient....
Questdog is offline   Reply With Quote
Old 08-11-2009, 01:19 PM   #8
fhomess
Hall Of Famer
 
fhomess's Avatar
 
Join Date: Nov 2002
Posts: 3,637
Quote:
Originally Posted by Questdog View Post
Not to be picky, but IP + IPF/3 is a little more effecient....
Yep. I wrote the formula as above because I usually calculate the number of outs first to be used in other formulas.
__________________
StatsLab- PHP/MySQL based utilities for Online Leagues
Baseball Cards - Full list of known templates and documentation on card development.
fhomess is offline   Reply With Quote
Reply

Bookmarks


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 03:51 PM.

 

Major League and Minor League Baseball trademarks and copyrights are used with permission of Major League Baseball. Visit MLB.com and MiLB.com.

Officially Licensed Product – MLB Players, Inc.

Out of the Park Baseball is a registered trademark of Out of the Park Developments GmbH & Co. KG

Google Play is a trademark of Google Inc.

Apple, iPhone, iPod touch and iPad are trademarks of Apple Inc., registered in the U.S. and other countries.

COPYRIGHT © 2023 OUT OF THE PARK DEVELOPMENTS. ALL RIGHTS RESERVED.

 

Powered by vBulletin® Version 3.8.10
Copyright ©2000 - 2025, vBulletin Solutions, Inc.
Copyright © 2024 Out of the Park Developments