0

enter image description here

I have attached a link to the image of my spreadsheet!

This is a list of influencers, I have a 5000 budget for Column F, and id like to assemble a group of any number of influencers, having the groups sum for column F not exceed 5000, and with the group having the highest possible sum for engagement rate (column D) andtotal viewership (column E)

In other words, I'm wondering if a function or formula can take every possible combination of influencers that I could afford for 5000, and find the group with the highest total viewership and engagement

  • I created the pricing at a rate of $0.02 per view
  • 1
    Please tell us more on your problem. – styrofoam fly Jun 27 '17 at 18:39
  • D is always smaller than E from your image. Please provide more detail as to what you are trying to do – Eric F Jun 27 '17 at 18:44
  • I added this to the description: This is a list of influencers, I have a 5000 budget for Column F, and id like to assemble a group of any number of influencers, having the groups sum for column F not exceed 5000, and with the group having the highest possible sum for engagement rate (column D) andtotal viewership (column E) – user742903 Jun 27 '17 at 18:45
  • hopefully that makes sense – user742903 Jun 27 '17 at 18:45
  • 1
    So what did you try and why didn't it work? – Dave Jun 27 '17 at 18:55
0

Actually I think I found a simple solution...

  • Sort by view/rate,
  • and then buy as many of the cheapest as I can! (starting from the bottom, buying up as much as I can)
    It seems to get me the highest possible engagement rate
| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.