CSFBL Excel Draft Tool
This tool is an aide for those who run drafts in CSFBL and would like an easier, less time consuming option. With this tool, you can:
To get started you'll need to make sure you've logged into the CSFBL site using the built in excel browser. To do that first open a new blank excel file (Workbook). Click on any cell and go to the "Data" tab at top and select "From Web". This will open the built in excel web browser tool, navigate to www.csfbl.com and login using your username & password and check the login automatically box and press the "Log On" button. Once you've logged in you can click the X at the top right to close the window or click the cancel button below.
If you have problems logging on in excel, use this link in the web query to log on.
- Automatically upload your league's draft order and draftee list
- Easily track which players have been taken and are still available
- Manage lists submitted by owners
- Look up draftees by name
- Simply cut and paste to post on the forums
- Identify highest and lowest salaried players remaining at any time
- Adapt the tool to your league. Works for full or block drafts and any number of rounds.
To get started you'll need to make sure you've logged into the CSFBL site using the built in excel browser. To do that first open a new blank excel file (Workbook). Click on any cell and go to the "Data" tab at top and select "From Web". This will open the built in excel web browser tool, navigate to www.csfbl.com and login using your username & password and check the login automatically box and press the "Log On" button. Once you've logged in you can click the X at the top right to close the window or click the cancel button below.
If you have problems logging on in excel, use this link in the web query to log on.
With that done, you can now open or go back to the draft tool sheet and start using it by simply entering the SeasonID of the current season and hitting enter will pull up the draft order. Once you've reached the 5/6 date you can enter your TeamID and extract the players list. If you would like to use owners names for the cut and paste, you can then enter a leagueID, if you don't plan to use it then you don't have to change the value.
At this point you're ready to use it. The draft order will be displayed, and for each pick there are 6 columns for entering the owners list with different request types found in the drop down menu. Players will be crossed off on the Sortable Draftess sheet as you make each owners "Selection" to the right of the teams. Making it easier to track what players are next up for each following owner off their list.
At this point you're ready to use it. The draft order will be displayed, and for each pick there are 6 columns for entering the owners list with different request types found in the drop down menu. Players will be crossed off on the Sortable Draftess sheet as you make each owners "Selection" to the right of the teams. Making it easier to track what players are next up for each following owner off their list.
This also includes a copy and paste sheet that will generate a ready to paste table for the forums. To do this you only have to select a few options and click the Copy Draft Table button then go to the forums and paste as plain text (Use the button on the text editor of the forums when posting, or use the keyboard shortcut of Ctrl-Shift-V). You can decide what format you want (Full round, Blocks of 4, Blocks of 6, Blocks of 8) and how many rounds you'd like copied (1, 2, 3). For block formats, you can set the date and time the first block is due and It will auto fill in the remaining blocks. You can also toggle on or off if salary is included in the copy and paste and owner names.
Also included is a player search function. You can use the excel wildcards (? = One character wildcard, and * = Any number of characters wildcard - even none) and find players, positions, ages, or any combo of the 3. You can do something like j?d and find "Jud" or if you did j*d you could find someone named Jud and John Doe. You can mix it up and do something like J*17 and you'd find all players who have a J in their name and are 17 years old or J*2B and you'd find all players who have a J in their name and 2B or combine all 3 for J*2B*17 and find any players with a J in their name who play 2B and are 17. There is plenty of uses for you.
You can use the new "Search & Input Tool", or edit the search cell with the values you'd like to search for. Either way is acceptable use.
You can use the new "Search & Input Tool", or edit the search cell with the values you'd like to search for. Either way is acceptable use.