Results 1 to 19 of 19

NFL Fantasy best projections with salary cap HELP

Threaded View

  1. #1
    Registered User
    Join Date
    09-25-2014
    Location
    united states
    MS-Off Ver
    excel
    Posts
    33

    NFL Fantasy best projections with salary cap HELP

    Ok so this may or may not be possible, and if it is possible, i dont know if someone is willing to help....but here we go

    I want to set up a spreadsheet to get the best possible fantasy football lineup based on projections while staying under a salary cap. A salary cap is placed on each player, by position, and also has a projected point total for each player. I will only be able to have a certain amount of each player on my roster. By staying under a certain total salary cap, i want to pick the players that will provide the highest total projected points...making sense? So i would have a table with QBs that have their name, projected points, and salary. The same for RB, WR, TE, K, and DEF. I want to pull information from all these tables to a new table that will give me 1 QB, 2 RB, 3 WR, 1 TE, 1 K, and 1 DEF with the highest total projected points while staying under a certain total salary. Even better, if I can get different combinations to see my options...for instance, the top 5 lists based on highest projected points while staying under certain salary.

    I know this is very advanced, ive been looking up things about excel solver, lookup functions...i cant seem to add it all together to do what i need....is this possible?

    any help would be awesome!!!

    Thank you...
    Last edited by lbofbb; 09-25-2014 at 10:01 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Advanced Filter Problem
    By dhaval123 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-27-2013, 02:17 AM
  2. Advanced Filter Problem
    By bjwade62 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-23-2012, 10:47 AM
  3. Advanced Filter problem
    By LisaK in forum Excel General
    Replies: 1
    Last Post: 04-03-2008, 11:09 AM
  4. [SOLVED] Advanced Filter problem
    By R. Choate in forum Excel General
    Replies: 14
    Last Post: 05-28-2006, 04:15 PM
  5. Advanced Lookup problem
    By timmyc in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-08-2006, 04:31 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1