CSV Exporter questions

MNBob · 10-21-2004, 10:05 AM

Does this utility only export actual ratings?

I want to export data that matches http://mattfuller14.phpwebhosting.com/bbl/rookies.html (i.e. through the eyes of the league scout). Is that possible?

Is there any documentation that maps the exported numbers into text descriptions? For example, durability comes out as 0, 1, 2. How does that map to Prone, Normal, Durable?

Thanks.

CommishJoe · 10-21-2004, 10:36 AM

Is this v5 or v6?

MNBob · 10-21-2004, 10:45 AM

v6

MNBob · 10-21-2004, 08:19 PM

Does anyone know?

gubaru · 10-21-2004, 11:32 PM

Here are the Excel formulas I use to translate the numeric code for those fields:

Pressure/Clutch: =IF(M2=2,"Great",IF(M2=1,"Suffers","Normal"))
Hitter Type: =IF(N2=2,"Spray",IF(N2=1,"Pull","Normal"))
Consistency: =IF(O2=2,"Very Inconsistent",IF(O2=1,"Average","Good"))
Loyalty: =IF(Q2=2,"Loyal",IF(Q2=1,"Normal","Minimal"))
Need Winner: =IF(R2=2,"Yes",IF(R2=1,"Sometimes","No"))
Leadership: =IF(S2=2,"Great",IF(S2=1,"Some","None"))
Durability: =IF(Z2=2,"Prone",IF(Z2=1,"Normal","Durable"))

If you want mph ranges for Velocity, you'll need to use the VLOOKUP function. Here are the two columns you'll need for the lookup:
0
1 84-87 MPH
2 85-88 MPH
3 86-89 MPH
4 87-90 MPH
5 88-91 MPH
6 89-92 MPH
7 91-94 MPH
8 93-96 MPH
9 95-99 MPH
10 98-100 MPH

Regarding your other question, it exports what you see in the game which may or may not be the actual rating.

MNBob · 10-22-2004, 12:44 AM

Quote:

Originally Posted by gubaru

Regarding your other question, it exports what you see in the game which may or may not be the actual rating.

Thanks for the answers. Regarding the above quote, I exported 1st year players and they did not match what I see in game or in the html that I link to above.

gubaru · 10-22-2004, 01:46 AM

Interesting. It's always been the same for me whether I have coaches on or not. Maybe Joe can give you an idea of what's going on.

10-21-2004, 10:05 AM	#1
MNBob Minors (Rookie Ball) Join Date: Feb 2003 Posts: 45	CSV Exporter questions Does this utility only export actual ratings? I want to export data that matches http://mattfuller14.phpwebhosting.com/bbl/rookies.html (i.e. through the eyes of the league scout). Is that possible? Is there any documentation that maps the exported numbers into text descriptions? For example, durability comes out as 0, 1, 2. How does that map to Prone, Normal, Durable? Thanks.

10-21-2004, 10:36 AM	#2
CommishJoe Global Moderator Join Date: Feb 2002 Location: Minneapolis, MN Posts: 5,238	Is this v5 or v6? __________________ Joe Success isn’t owned. It’s leased. And rent is due every day.

10-21-2004, 10:45 AM	#3
MNBob Minors (Rookie Ball) Join Date: Feb 2003 Posts: 45	v6

10-21-2004, 08:19 PM	#4
MNBob Minors (Rookie Ball) Join Date: Feb 2003 Posts: 45	Does anyone know?

10-21-2004, 11:32 PM	#5
gubaru Major Leagues Join Date: Apr 2004 Location: Camp Hill, PA Posts: 326	Here are the Excel formulas I use to translate the numeric code for those fields: Pressure/Clutch: =IF(M2=2,"Great",IF(M2=1,"Suffers","Normal")) Hitter Type: =IF(N2=2,"Spray",IF(N2=1,"Pull","Normal")) Consistency: =IF(O2=2,"Very Inconsistent",IF(O2=1,"Average","Good")) Loyalty: =IF(Q2=2,"Loyal",IF(Q2=1,"Normal","Minimal")) Need Winner: =IF(R2=2,"Yes",IF(R2=1,"Sometimes","No")) Leadership: =IF(S2=2,"Great",IF(S2=1,"Some","None")) Durability: =IF(Z2=2,"Prone",IF(Z2=1,"Normal","Durable")) If you want mph ranges for Velocity, you'll need to use the VLOOKUP function. Here are the two columns you'll need for the lookup: 0 1 84-87 MPH 2 85-88 MPH 3 86-89 MPH 4 87-90 MPH 5 88-91 MPH 6 89-92 MPH 7 91-94 MPH 8 93-96 MPH 9 95-99 MPH 10 98-100 MPH Regarding your other question, it exports what you see in the game which may or may not be the actual rating.

10-22-2004, 01:46 AM	#7
gubaru Major Leagues Join Date: Apr 2004 Location: Camp Hill, PA Posts: 326	Interesting. It's always been the same for me whether I have coaches on or not. Maybe Joe can give you an idea of what's going on.