fantasy football

Hi there, It's been a while since I have posted here. I've had great help in the past so fingers crossed the same can be said for this time. Anyway, I have a fantasy premier league league which I am the league admin of. This season we are doing a head-to-head format which is posing new...

Anyone else into fantasy sports? This year for our fantasy football draft, I'm attempting to use similar methodology to the NHL and NBA drafts. I posted about it on Reddit just trying to get the general methodology understood, but now I need to figure out the "how-to" portion. Can anyone...

Hi everyone, I have a very basic understanding of Excel and have seen a few YouTube tutorials on formulas etc. however what I am looking for is some help on this fantasy league I've created, It's a 10 team league based on the 2021/22 Premier League fixtures. I want to be able to input the office...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...