Finding 2 variables

[Shudb007]

Hello

I've been trying for hours to solve this, and my math level is not that good and i don't know if it's even possible

A x B = C then C – B = I then I - E – H = L
D x E = F then F – E = J then J - B – H = M
G x H = F then F – H = K then K - B – E = N

Constants:

A, B, C, I, D, G, M, N

Need to find E and H

Is it posible?

thank you!

 

[Deleted member 4993]

Hello

I've been trying for hours to solve this, and my math level is not that good and i don't know if it's even possible

A x B = C then C – B = I then I - E – H = L
D x E = F then F – E = J then J - B – H = M
G x H = F then F – H = K then K - B – E = N

Constants:

A, B, C, I, D, G, M, N

Need to find E and H

Is it posible?

thank you!

Please post the exact problem as it was presented to you.

 

[Shudb007]

Hello,

is as follows



I need to find the yellow values starting from the green values which will be always known

to perform the operation normally i adjust manually the 2 yellow values until i get the dessired final comb values on each cell; so, i don't know if there is a way to calculate automatically the needed input value from the desired final comb value

Thank you!

 

[Dr.Peterson]

I'm assuming this is not a school assignment, so I'm just doing it for you, and showing what I found.

Here is your table, with variable names I've assigned:

multiplier	input	gross	net	final
a	b	ab	ab-b	ab-b-x-y
c	x	cx	ex-x	cx-b-x-y=e
d	y	dy	fy-y	dy-b-x-y=f

Solving the equations under Final for x and y in terms of a, b, c, d, e, and f, I get

x=(bd+de+f-e)/(cd-c-d)​

y=(bc+cf+e-f)/(cd-c-d)​

I put these into cells x and y, with e and f in a new column "target", and got these results:

multiplier	input	gross	net	final	target
3.25​	20​	65​	45​	65​
2.9​	17.355​	50.331​	32.975​	-5​	-5​
2.8​	17.975​	50.331​	32.355​	-5​	-5​

The final matches the target, and my values for x and y match yours.

Here are the actual cell contents:

multiplier	input	gross	net	final	target
3.25	20	=A2*B2	=C2-B2	=D2-B$5+B2
2.9	=(B2*A4+A4*F3+F4-F3)/(A3*A4-A3-A4)	=A3*B3	=C3-B3	=A3*B3-B2-B3-B4	-5
2.8	=(B2*A3+A3*F4+F3-F4)/(A3*A4-A3-A4)	=A4*B4	=C4-B4	=A4*B4-B2-B3-B4	-5

 

[Shudb007]

Hello,

thank you so much it works! sincerely i've been trying to solve it for hours and always ended ip with a circular reference

i think this can be applied to matched betting, so, mayhelp some1 in future