Amateur Draft Ratings Spreadsheet Design - Question on G/F rating and Scout vs OSA Potential

jturner421 · 08-20-2016, 05:20 PM

I'm in the process of developing out a spreadsheet for use during the annual amateur draft. I'm using OOTP 17. I'm using this post from 2010 as a reference: http://www.ootpdevelopments.com/boar...ml#post3003473. For pitchers, the following criteria is used:

PITCHERS
PITCHING (P+6)
Stuff
Movement
Control
Stamina
G/F
Hold

I'm having trouble locating the G/F stat in the draft pool screen. All that shows is text such as NEU, FLY, etc. Apparently in previous versions, it was a ratio like 62/38. Can someone confirm if this stat still exists for draft prospects and if so, how do I extract it?

In developing the formula for the spreadsheet, should I rely on my scout's potential ratings, OSA, or compare them to each other for a broader perspective? For reference, my scout is rated excellent, favors ability.

ShaneCarson · 08-21-2016, 04:08 PM

Quote:

Originally Posted by jturner421

I'm in the process of developing out a spreadsheet for use during the annual amateur draft. I'm using OOTP 17. I'm using this post from 2010 as a reference: http://www.ootpdevelopments.com/boar...ml#post3003473. For pitchers, the following criteria is used:

PITCHERS
PITCHING (P+6)
Stuff
Movement
Control
Stamina
G/F
Hold

I'm having trouble locating the G/F stat in the draft pool screen. All that shows is text such as NEU, FLY, etc. Apparently in previous versions, it was a ratio like 62/38. Can someone confirm if this stat still exists for draft prospects and if so, how do I extract it?

In developing the formula for the spreadsheet, should I rely on my scout's potential ratings, OSA, or compare them to each other for a broader perspective? For reference, my scout is rated excellent, favors ability.

I don't believe the ratio exists anymore as a part of ratings. It's just the labels, as you've found. You could turn those labels into dummy variables if you planned on doing some sort of regression with the data.

drhay53 · 08-21-2016, 08:03 PM

In my personal spreadsheet I turn the text for GB% into a rating between 40 and 60, i.e. like this (google sheets api):

Quote:

=IF(S3="EX FB",40,IF(S3="FB T",43,IF(S3="FB",46,IF(S3="NEU",50,IF(S3="GB",53,I F(S3="GB T",56,IF(S3="EX GB",60)))))))

NoOne · 08-22-2016, 12:32 AM

if you spend on that particular scouting budget and have a good scout, expect them to be better than OSA.

if you are near average or worse, use them together and average the ratings. (i'd only do that if you are near baselines and average scout in your league... if worse, use OSA on its own).

the "favors" probably only affects overall potential, I think. they various preferences weight things slightly different for the overall/potential rating. if you are making your own formula, i wouldn't even use overall/potential except for filtering a list you intend to input into spreadsheet. i'm assuming you are making your own equation to apply the weights you want on various individual ratings then using that product to decide between players?

pretty sure you can export draft lists... hope that has all the data you need, because inputing all that crap would be time-consuming. hopefully you can link directly to teh exported file... then use formulas to get that data onto your worksheet / output sheet => "=sheet.import:a1" or somethign like that.. never work directly on the imported data.. it ruins the whole idea / benefit of using a spreadsheet). then each time you export the draft list, everythign gets updated when the link to that file is updated in the spreadsheet.

silverwolf · 08-22-2016, 07:05 PM

You can write a report to HTML, and then some people paste it into Excel, and others (myself included) have scripts that parse the HTML and put it into a database or some other form to create draft spreadsheets.

I do similar to what was suggested by @drhay53 above, convert the text strings for the G/F ratings into something on a scale that works for me.

The G/F ratio is available on each player report page as the actual %, but for no apparent reason, there's no way for a regular user to export it easily.

08-20-2016, 05:20 PM	#1
jturner421 Bat Boy Join Date: Aug 2016 Posts: 7	Amateur Draft Ratings Spreadsheet Design - Question on G/F rating and Scout vs OSA Potential I'm in the process of developing out a spreadsheet for use during the annual amateur draft. I'm using OOTP 17. I'm using this post from 2010 as a reference: http://www.ootpdevelopments.com/boar...ml#post3003473. For pitchers, the following criteria is used: PITCHERS PITCHING (P+6) Stuff Movement Control Stamina G/F Hold I'm having trouble locating the G/F stat in the draft pool screen. All that shows is text such as NEU, FLY, etc. Apparently in previous versions, it was a ratio like 62/38. Can someone confirm if this stat still exists for draft prospects and if so, how do I extract it? In developing the formula for the spreadsheet, should I rely on my scout's potential ratings, OSA, or compare them to each other for a broader perspective? For reference, my scout is rated excellent, favors ability.

08-22-2016, 12:32 AM	#4
NoOne Banned Join Date: Apr 2015 Posts: 7,273 Infractions: 0/2 (4)	if you spend on that particular scouting budget and have a good scout, expect them to be better than OSA. if you are near average or worse, use them together and average the ratings. (i'd only do that if you are near baselines and average scout in your league... if worse, use OSA on its own). the "favors" probably only affects overall potential, I think. they various preferences weight things slightly different for the overall/potential rating. if you are making your own formula, i wouldn't even use overall/potential except for filtering a list you intend to input into spreadsheet. i'm assuming you are making your own equation to apply the weights you want on various individual ratings then using that product to decide between players? pretty sure you can export draft lists... hope that has all the data you need, because inputing all that crap would be time-consuming. hopefully you can link directly to teh exported file... then use formulas to get that data onto your worksheet / output sheet => "=sheet.import:a1" or somethign like that.. never work directly on the imported data.. it ruins the whole idea / benefit of using a spreadsheet). then each time you export the draft list, everythign gets updated when the link to that file is updated in the spreadsheet. Last edited by NoOne; 08-22-2016 at 12:40 AM.

08-22-2016, 07:05 PM	#5
silverwolf Minors (Double A) Join Date: Sep 2012 Posts: 187	You can write a report to HTML, and then some people paste it into Excel, and others (myself included) have scripts that parse the HTML and put it into a database or some other form to create draft spreadsheets. I do similar to what was suggested by @drhay53 above, convert the text strings for the G/F ratings into something on a scale that works for me. The G/F ratio is available on each player report page as the actual %, but for no apparent reason, there's no way for a regular user to export it easily.