2003 & 2007

The list of numbers below is just for an example.

I am attempting to find a set of numbers that add up to a given amount i.e.; In this case, I know
the answer because I created the amount.

I realize that this could be a real processor hog- but is it reasonably possible in the PC world?

2,767.16
62.75
308.00
60.66
1,745.70
791.20
(2,767.16)
(180.00)
(90.00)
(180.00)
(104.86)
(104.86)
(65.38)
(43.65)
(112.09)
(13.48)
(200.01)
(19.91)
(12.68)
(6.12)
(99.52)
(23.40)
(1.24)
(32.12)
(12.26)
(4.35)
(0.12)
(0.06)
(0.06)
(1,745.70)
(791.20)
(44.16)
(730.29)

Total (1,649.21)

What combination of the above will add up to i.e.: 1,539.45?

Answer:
-200.01
-.0.12
-6.12
1745.20

Any help or ideas is very helpful.

TIA EagleOne

Couple of approaches here...
http://www.tushar-mehta.com/excel/te...olver_Template
Moe




wrote in message
2003 & 2007
The list of numbers below is just for an example.
I am attempting to find a set of numbers that add up to a given amount i.e.; In this case, I know
the answer because I created the amount.
I realize that this could be a real processor hog- but is it reasonably possible in the PC world?

2,767.16
........
(730.29)

Total (1,649.21)
What combination of the above will add up to i.e.: 1,539.45?
Answer:
-200.01
-.0.12
-6.12
1745.20
Any help or ideas is very helpful.
TIA EagleOne

Usually, negative numbers add to the complexity, and number of solutions.

Did you want this...
{1745.7, -200.01, -6.12, -0.12}

or this?
{1745.7, -200.01, -6.12, -0.06, -0.06}


Some others...
{2767.16, 1745.7, -2767.16, -200.01, -6.12, -0.12},
{2767.16, -104.86, -200.01, -99.52, -32.12, -791.2},
{2767.16, -104.86, -200.01, -99.52, -32.12, -791.2},
{1745.7, 791.2, -200.01, -6.12, -0.12, -791.2},
{1745.7, -90, -99.52, -12.26, -4.35, -0.12}

There are many more solutions...

{-112.09, -44.16, -19.91, -13.48, -12.26, -4.35, 1745.7},
{-104.86, -104.86, -43.65, -13.48, -0.06, 60.66, 1745.7},
{-104.86, -44.16, -23.4, -19.91, -12.68, -1.24, 1745.7},
{-99.52, -90, -12.26, -4.35, -0.06, -0.06, 1745.7},
{-99.52, -65.38, -23.4, -13.48, -4.35, -0.12, 1745.7},
{-99.52, -44.16, -43.65, -12.68, -6.12, -0.12, 1745.7}
etc...

--
Dana DeLouis


wrote in message ...

2003 & 2007

The list of numbers below is just for an example.

I am attempting to find a set of numbers that add up to a given amount i.e.; In this case, I know
the answer because I created the amount.

I realize that this could be a real processor hog- but is it reasonably possible in the PC world?

2,767.16
62.75
308.00
60.66
1,745.70
791.20
(2,767.16)
(180.00)
(90.00)
(180.00)
(104.86)
(104.86)
(65.38)
(43.65)
(112.09)
(13.48)
(200.01)
(19.91)
(12.68)
(6.12)
(99.52)
(23.40)
(1.24)
(32.12)
(12.26)
(4.35)
(0.12)
(0.06)
(0.06)
(1,745.70)
(791.20)
(44.16)
(730.29)

Total (1,649.21)

What combination of the above will add up to i.e.: 1,539.45?

Answer:
-200.01
-.0.12
-6.12
1745.20

Any help or ideas is very helpful.

TIA EagleOne