Argh- innings pitched in the sql/csv export

wellsoliver · 08-11-2009, 12:44 PM

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?

Bluenoser · 08-11-2009, 12:53 PM

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.

wellsoliver · 08-11-2009, 12:56 PM

Do this where? In my DB server? That won't help with the data not being exported by OOTPx.

fhomess · 08-11-2009, 12:57 PM

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.

Bluenoser · 08-11-2009, 12:58 PM

In excel, or whichever spreadsheet you're using to open the CSV file.

wellsoliver · 08-11-2009, 01:03 PM

IP and IPF! Beautiful. I figured it was there.

Questdog · 08-11-2009, 01:15 PM

Quote:

Originally Posted by fhomess

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....

fhomess · 08-11-2009, 01:19 PM

Quote:

Originally Posted by Questdog

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.

08-11-2009, 12:44 PM	#1
wellsoliver Major Leagues 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?

08-11-2009, 12:57 PM	#4
fhomess Hall Of Famer 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.

08-11-2009, 12:53 PM	#2
Bluenoser Hall Of Famer 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.

08-11-2009, 12:56 PM	#3
wellsoliver Major Leagues 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.

08-11-2009, 12:58 PM	#5
Bluenoser Hall Of Famer Join Date: Mar 2002 Location: In The Moment Posts: 14,127	In excel, or whichever spreadsheet you're using to open the CSV file.

08-11-2009, 01:03 PM	#6
wellsoliver Major Leagues Join Date: Aug 2009 Location: San Diego, CA Posts: 337	IP and IPF! Beautiful. I figured it was there.