fantasy football

  1. D

    Need help creating an excel sheet for historical finishes in my fantasy football league

    Hello there, I am hoping this place can help me with what I am trying to do. I have the top 3 finishes since 2004 for our fantasy football league. I want to create a basic function where 1st place gets 3 points, 2nd place gets 2 points and 3rd place gets 1 point. I want to see the total...
  2. T

    Fantasy Football Team Selector

    Hi Guys. I am trying to make a fantasy football team selector that will look at the list of my players and pick the best option for the position i want to pick and i am wondering if you guys could help. I have a sheet (named squadsheet) with all my player's ratings in each and every position...
  3. K

    Head to head win % fantasy football

    Hey guys, I've been trying to find somewhere where I can plug in my fantasy team and my opponents team and calculate what the likelihood of me winning is, based off floors and ceilings of a player. I can pretty easily find floors and ceilings, I just don't know how to make excel work for me to...
  4. H

    Statistics Question to Figure Out Playoff Odds for Fantasy Football

    Hi Everybody, I'm trying to figure out the percentage chance my team has of making the playoffs in my league this week. I will make the playoffs if one of the following 3 scenarios happens: I win (35% chance) Team A wins (49% chance) Team B loses (42% chance) The percentages I listed above...
  5. T

    Using Solver Add-in for a Linear Program: For Fun Fantasy Football!

    I thought it would be fun to make a linear program for fantasy football. Background information: You pick 9 players; 2 quarterbacks, 2 running backs, 3 wide receivers, 1 tight end, and 1 flex (running back, wide receiver, or tight end). Each player has an associated cost. You're capped...
  6. S

    Logical Sequencing Problem

    I have a spreadsheet we use to display our Fantasy Football auction on a big screen in a conference room. Ten guys take turns 'nominating' a player, who can then be 'bought' by anyone. My sheet lists every nomination, 1-160, going through a logical sequence (Team A, Team B, Team C, Team D...
  7. P

    Beginner Help - UserForm to modify table

    I'm trying to learn some VBA to set up a draft board for fantasy football and was hoping for some help. I currently have a table with the Player Name (column G), as well as two sets of check boxes (columns C & D) indicating whether they've been drafted by an opposing team or myself. The check...
  8. D

    Help needed to update old Fantasy Football table

    Hi - I have just taken over the Fantasy Football at work this, the table itself is about 5-6 years old, their is some significant improvements needed on the spreadsheet that I would to have sorted before the 2014/15 season starts, but it's a lot more complicated than I was expecting. It would...
  9. H

    VBA noob needs help.

    I need excel to insert a formula into a row i.e. (A3:G3) then skip down to Row 5 and insert the same formula. I need Excel to do this all the way down to row 10080. I have tried combining a few VBA codes but nothing has worked. The code that shows the most promise is: Sub xyz() Dim i As...
  10. T

    Count Number of Maximums- Fantasy Football

    I don't think this one is too crazy, but I am having trouble finding any info about this type of problem. The goal is to count the number of times in a season that each team scored the highest points in a given week. The columns are labeled by weeks, the maximum per week is below. The end...
  11. K

    Excel Solver - Optimal Fantasy Football Lineup - "Solver could not find a feasible solution"

    I am working with the Excel Solver to find the optimal fantasy football roster (maximum projected points). The constraints are: - Salary Cap of $100,000 - Roster Constraints: - 1 QB - 2 to 4 WR - 2 to 4 WR - 1 to 3 TE - 1 Defense - Total roster size must be 10 I have set up the...
  12. S

    Fantasy football calculators

    Newbie here, I apologize if this has been covered and/or is a stupid question: I'm trying to set up a sheet that will allow me to enter statistics from NFL games and generate the fantasy points earned by each player. This is not hard on the surface, but the problem is calculating the points...
  13. M

    PlaySound issue with Windows 7 64 bit

    I have a popular fantasy football spreadsheet package which I've sold for years. One of the features (frills) in one of the files is the ability to play "trash talking" sound effects. Someone in your fantasy draft makes a pick you want to laugh at, click the appropriate sound file, and hit play...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top