Vertical List Downloads

Vertical List Data Files

Instructions (Read this before you do anything with your file)

• Download your XLS file from the net if you don't have one already. Otherwise, you can just keep modifying one on your system.
• The XLS file will have a name of VLTPP.XLS, where T, is your team number (your position in the AL draft), and the PP, is the current period (2 digits). So team 3's vertical list in period 4 would be VL304.XLS. Get it?

• Open the file in Excel. It should look something like this ...

  

  Here's the scoop on the columns ...

  Edit?	Column	Explanation
  YES	LIST	This is which list this player is in. ALH is "AL Hitting", NLP is "NL Pitching" and so on.
  YES	#	This is which number they are in the list. You'll use this to sort the list.
  YES	ID	This is the player's ID as assigned by STATS, Inc.
  NO	NAME	Players' name - automatically filled in.
  NO	TM	Players' team - automatically filled in.
  YES	P1 - P7	Positions for this player, in the order you want to use 'em.
  NO	Positions	Players' eligible positions - automatically filled in. Positions listed in parens, like "(LF)", mean that the player has played at least one game at that position, but not enough yet to qualify. For new players, that'll give you a hint as to where to play 'em. For veterans, it's a "coming attraction" of sorts.
  NO	Check Pos	Check Position - automatically filled in. This will be "--" in normal cases. If you've forgotten to fill in P1, then this will show "POSITION?" Fill in P1 and that warning will go away.
  NO	Check Lg	Check League - automatically filled in. This will be "--" in normal cases. If this is an NL player and you've got him in the AL, then this will show "LEAGUE?" Move him to the right list and that warning will go away.

  The fields with YES under Edit? are the ones you can change. Leave the others alone. Don't add any columns, and don't delete any either. Don't make me hurt you. I know where you live.

• TO CHANGE THE ORDER OF PLAYERS IN YOUR LIST:
  Simply change the # field and sort by List and #.

• TO ADD A PLAYER:
  Go to the bottom of the player list, down around line 70. Use one of the lines that has "--" in the name field. Add the List, #, and ID fields, and the player's name and team will show up. Then go to the P1-P7 fields and add positions. Finally, sort the list by List and #.

• TO DELETE A PLAYER:
  Delete the List, #, ID, and P1-P7 fields for that player. Sort the list by List and #. You'll probably need to fix the numbering in the # column.

• TO CHANGE A PLAYER:
  Just change the List, #, ID, and P1-P7 fields for that player. Change the List if he gets traded across leagues. Sort the list by List and #. And like with the delete, you may need to fix the numbering.

• (Yes, you can do a whole bunch of edits at once and then just sort the whole thing once at the end).

• When you're done, mail the new VL file (VLtpp.XLS) to your the RRBL Stat Geek.