Reverse Engineering Formula Using Result and Input Values

[rob51852]

Hi,

The matrix below contains input values in B2:B22 ("ResourceA") and input values in C1:L1 ("ResourceB"). Each is expressed as the % of each resource remaining. N2 is the "Total". C2:L22 are the results based on the resources remaining in progress to the Total.

Is it possible to reverse engineer the results to generate the formula used to calculate them?

Thanks

Book1
	B	C	D	E	F	G	H	I	J	K	L	M	N
1	resourceA	100	90	80	70	60	50	40	30	20	10		Total
2	100	0	7	15	26	40	58	80	104	128	146		160
3	99.16666667	1	7	16	26	40	58	80	105	128	146
4	98.33333333	2	8	16	27	41	59	80	105	128	146
5	97.5	3	9	17	28	41	59	80	105	128	146
6	96.66666667	4	10	18	28	42	59	80	105	128	146
7	95.83333333	5	11	19	29	42	59	81	105	128	146
8	95	6	12	20	30	43	60	81	105	128	146
9	94.16666667	7	13	20	30	43	60	81	105	128	146
10	93.33333333	8	14	21	31	44	60	81	105	128	146
11	92.5	9	14	22	32	44	61	81	105	128	146
12	91.66666667	10	15	23	32	45	61	81	105	128	146
13	90.83333333	11	16	24	33	46	62	82	105	128	146
14	90	12	17	24	34	46	62	82	105	128	146
15	89.16666667	13	18	25	34	47	62	82	105	128	146
16	88.33333333	14	19	26	35	47	63	82	105	128	146
17	87.5	15	20	27	36	48	63	82	105	128	146
18	86.66666667	16	21	28	37	48	63	83	105	128	146
19	85.83333333	17	22	29	37	49	64	83	105	128	146
20	85	18	23	29	38	49	64	83	105	128	146
21	84.16666667	19	24	30	39	50	65	83	105	128	146
22	83.33333333	20	25	31	39	51	65	83	105	128	146
ParScores BB

 

[KRice]

Could you say a little more about these resources and the values in the body of the table? How are the resources related, and does the "total" of 160 represent the sum of resources A and B, or is 160 related to the values in the body of the table?...I'm not following what the table values are supposed to represent. For example, looking at cell D8, when 95 % of resource A remains and 90 % of resource B remains, what does "12" mean?