Math puzzle

[iknowu99]

There are pairings and values are received one from each scale. Small scale numbers are always unique. We have sum of values that are used. We know that pairings are either summed or not. Based on sum we need the function to return which index in the array was used.

The goal is to build deciphering function to return which pairings were used to create the sum. For ex: Can you figure out which pairings were used to make the sum?

Excel
	A	B	C	D	E
1	large scale:	600	400	800	800
2	small scale:	50	51	63	64
3
4	sum:	1965
Sheet1

<br/>

 

[mikerickson]

Sum of what?

What does small scale or Large scale matter to the question?

 

[iknowu99]

Sum of pairings that were used. Edited the original post. mikerickson, does that make sense?

 

[B___P]

Each couple (pairings) may be inolved in the sum (1) or not (0). You have to implement a distribution with repetition method to cicle all possible solutions and keep only those matching your sum. I think the light is on but turns off if the pairing are a lot: for 12 pairings you have to test 2^12 possible solutions.

Bye

 

[iknowu99]

Each couple (pairings) may be inolved in the sum (1) or not (0). You have to implement a distribution with repetition method to cicle all possible solutions and keep only those matching your sum. I think the light is on but turns off if the pairing are a lot: for 12 pairings you have to test 2^12 possible solutions.

Bye

how to build recursion function that returns the index of the array that is (1)?

 

[B___P]

Here you find examples and explanations:

Which numbers add up to total? « EXCELXOR

Which numbers add up to total? (2): Multiple Solutions « EXCELXOR

Hope this helps.

 

[iknowu99]

Here you find examples and explanations:

Which numbers add up to total? « EXCELXOR

Which numbers add up to total? (2): Multiple Solutions « EXCELXOR

Hope this helps.

Thanks for reply B_P. That is the correct direction but was this possible with VBA solution (pseudocode) in cases when there are many more permutations?

It would have 3 parameters =DecipherFunction("B1:E1","B2:E2","B4") and it would return array "1,2,4"

 

[shg]

The vertical pairs are irrlevent, right? So it just reduces to finding the combination of a set of numbers that add to a given total, a problem that has been well explored on this and other forums.

 

[iknowu99]

Hello shg, not sure why you said vertical pairs were irrelevant. some of them might not count toward the sum. The task is to use code to decipher the sum to the pairings (one from large scale one from small scale).

 

[shg]

Right. But for a given vertical pair, you either use both or neither, so it is only their sum that matters, yes?