CSV Exporter questions

MNBob · 10-21-2004, 09: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, 09:36 AM

Is this v5 or v6?

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

v6

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

Does anyone know?

gubaru · 10-21-2004, 10: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-21-2004, 11:44 PM

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, 12: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, 09:05 AM	#1 (permalink)
MNBob Minors (Rookie Ball) Join Date: Feb 2003 Posts: 45 Thanks: 0 Thanked 0x in 0 posts	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, 09:36 AM	#2 (permalink)
CommishJoe Global Moderator Join Date: Feb 2002 Location: Minneapolis, MN Posts: 5,009 Thanks: 30 Thanked 69x in 40 posts	Is this v5 or v6? __________________ Joe Question to fiance -- How much do you love me? Answer -- So much that we can get our legs tied together, walking 3 legged for the rest of our lives and I'd love it.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

10-21-2004, 09:45 AM	#3 (permalink)
MNBob Minors (Rookie Ball) Join Date: Feb 2003 Posts: 45 Thanks: 0 Thanked 0x in 0 posts	v6

10-21-2004, 07:19 PM	#4 (permalink)
MNBob Minors (Rookie Ball) Join Date: Feb 2003 Posts: 45 Thanks: 0 Thanked 0x in 0 posts	Does anyone know?

10-21-2004, 10:32 PM	#5 (permalink)
gubaru Major Leagues Join Date: Apr 2004 Location: Tyrone, PA Posts: 326 Thanks: 0 Thanked 0x in 0 posts	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, 12:46 AM	#7 (permalink)
gubaru Major Leagues Join Date: Apr 2004 Location: Tyrone, PA Posts: 326 Thanks: 0 Thanked 0x in 0 posts	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.