d2jsp
Log InRegister
d2jsp Forums > Off-Topic > General Chat > General Archive > 100 Fg For Excel Solver Help
Closed New Topic
Member
Posts: 10,955
Joined: Apr 4 2009
Gold: 25,714.70
Aug 16 2016 07:00am
So this seems very basic, but I can't figure it out.

Here is a simple example:

John 12,000 1.2
Dan 9,000 1.1
Matt 8,100 1
Eric 5,500 0.75
Evan 7,300 0.89
Ron 11,100 1.25
Mike 6,400 1
Al 8,800 0 .9

Basically, I want to maximize column C while picking 6 people in column A, and so that column B sums to 50,000 (or less).

Anyone know how to do this?

Thanks
Member
Posts: 15,154
Joined: Feb 3 2015
Gold: 20.69
Aug 16 2016 07:02am
need 500fg lmk
Member
Posts: 10,955
Joined: Apr 4 2009
Gold: 25,714.70
Aug 16 2016 07:06am
Quote (Toasty4 @ Aug 16 2016 08:02am)
need 500fg lmk


Only have 100 man sorry.
Member
Posts: 17,959
Joined: Jul 3 2007
Gold: 0.00
Aug 16 2016 07:06am
Use an algorithm
Member
Posts: 31,702
Joined: Mar 21 2007
Gold: 4.00
Aug 16 2016 07:08am
spam several gaming forums
Member
Posts: 10,955
Joined: Apr 4 2009
Gold: 25,714.70
Aug 16 2016 07:16am
Quote (IXKingXI @ Aug 16 2016 08:06am)
Use an algorithm


How would you go about doing this?
Member
Posts: 12,303
Joined: May 15 2008
Gold: 38.54
Aug 16 2016 07:18am
Have you tried shouting at it?
Go Back To General Archive Topic List
Closed New Topic