Jump to content

hockyplr

Members
  • Content Count

    3
  • Joined

  • Last visited

Community Reputation

0 Neutral

About hockyplr

  • Rank
    FF Rookie
  1. hockyplr

    Getting #NUM! Error

    The number is 1 for both min bid and min increment. However on the rules page I am seeing ##### for some reason and it is a small number and plenty of cell space.
  2. hockyplr

    Getting #NUM! Error

    The Max bid column all over the cheat sheet has #NUM!, which generally means the cell is not large enough to display the value, is there a simple way of fixing it on all sheets?
  3. hockyplr

    Dead Cap

    Mike, First time user... So looking to get a question answered as to "Dead Cap". At first I thought this was the cap space the team has spent. An example is my league allows 5 keepers, with no cost of draft picks. We have 12 teams, I input everyone's keepers, inputting, Position, Name, and then the cost of the player. I assumed Dead Cap was the amount they spent, which as powerful as your spreadsheet is I couldn't imagine why it didn't just add those columns up. none-the-less, I put that value there. However, looking at the summary it adds the dead cap and the amount spent together. Okay, that can't be right, so I zeroed out the dead cap. Which does give a correct value now, HOWEVER, Players like Aaron Rogers go from a total market value of $31 max bid, to $149. That doesn't seem right, since my entire cap space is $260, his salary being over half my space. I guess I am just not understanding the dead cap, and why the huge jump if it in max bid salary.... Thank you
×