View Single Post
 
Old 03-07-2014, 02:17 AM
macropod's Avatar
macropod macropod is offline Windows 7 32bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Calculating the values from series that sum to a given value is difficult enough, with the resources to calculate expanding exponentially as the number of terms increases. Obviously, when you have multiple possible number series that can add to that number, the calculation load also increases. But, here's the problem with what you want: What are you going to do about the fact that some of the same values can be part of two or more solutions? For example, you say:
Quote:
Note that 8881.92 + - 6003.60 + - 2878.32 = zero
and - 196,546.73 + 211,632.56 + - 10,229.00 + - 4856.83 = zero
but so does:
Quote:
+ 8881.92 + - 196,546.73 + - 10,229.00 + - 6003.60 + 211,632.56 + - 2878.32 + - 4856.83 = zero
Clearly, if there's more than one solution, every solution you find can also be part of another solution.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote