- 0

## 13 answers to this question

## Recommended Posts

## Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

The time has come! The new website is up and running https://www.excelwtf.com/learn/ Check it out if you want to learn VBA or brush up on your Excel skills with some more advanced Excel tutorials!

News Ticker

- Welcome to the Community
- Use the forum to troubleshoot your Excel & VBA Problems
- We will be launching a new website soon! www.ExcelWTF.com/Learn ! Join us to learn VBA from the ground up!

- 0

You can post now and register later. If you have an account, sign in now to post with your account.

I'm creating a fantasy drafting tool to use in fantasy football. I have it setup how I want it, but I am lost with all things VBA. Currently, I'm just recording Macros on each checkbox click, but I'm pretty sure some VBA code would work a lot better.

Background on the tool, it is a VBD (Value-Based Drafting) drafting tool. The way it works is you input your player projections for the season and your leagues scoring, and it totals the fantasy points for that player. The VBD part comes in by taking a baseline number for each position and subtracting each player's total fantasy points from that baseline number. The way to get that baseline number is by counting/guessing/figuring out how many players at each position will be drafted in the first 100 pick selections. For instance, I'm estimating 11 quarterbacks will be selected in the first 100 picks, so the total fantasy points for the 11th quarterback on the list becomes the baseline number. Every quarterback's fantasy points are subtracted from this figure giving you an X-Value, this is done for each position. The 11th QB on my list is Eli Manning, and I project him to get 332.72 points, 332.72 is the baseline for QBs, and Eli Mannings x-value would be zero. The 4th ranked QB on my list is Drew Brees, and I project him to get 381.08 points. 381.08 points minus the baseline set by Eli Manning of 332.72 points gives Brees an x-value of 47.36. When a quarterback is drafted, he is removed from the equation, and every quarterback below him moves up, so the baseline changes to the new 11th ranked quarterback and all x-values will adjust.

I've got an excel sheet representing this but the only way I know how to make it all work is by putting a macro enabled check box for all 500 players, when a box is ticked next to the player it deletes the fantasy point projection for that player and sorts the list by x-value. Very clunky and sloppy and I know there's an easier way to do this I just don't know how or it requires VBA which is out of my league (at least until I get my computer science degree).

I should also mention that I have posted this question for help on another site, https://www.mrexcel.com/forum/excel-questions/1019659-excel-project-has-me-loss.html. Have a look; input is very welcomed. Thank You

Until I figure out how to attach files here is a dropbox link to the excel sheet.

https://www.dropbox.com/s/7y6b36bitdyno0f/Fantasy Tool_test.xlsm?dl=0

## Share this post

## Link to post

## Share on other sites