mathematician dummy needing assistance
 

Do someone could help me solving the following problem

U E C
2'000'000.- 1'000'000.- 5'00'000.- Initial amounts

-20'000 -12'000.- -53'000.- Amounts variation

-1.00% -1.20% -1.06% % in pourcentage


100.00% 120.00% 106.00% poucentage ratio beween
themselves

100.00% 96.00% 98.00% pourcentage ratio wished

-1641.5 (0) (a)1621.5 (b)20 amounts add or
soustracte in order to
.................................................. ........................reach
the wishes ratio

-21641.5 -10378.5 -52980 modified amounts by line above

-1.08% -1.04% -1.06% % gain/loss with modified
variations

100.00% 95.91% 97.92% ratio with the modified
amounts between %


How can I reach the % ratio wished , with changing only the (a) and (b)
amounts which influence the (0) amount with this formula =-(a+b)

My aim is to find a way to automatically calculate (a) and (b) knowing
only the wished ratio and the real ratio betwen % gain / loss

Thanks for your help

mathematician dummy needing assistance
 

I'm not clear on what you want to do. Can you show an equation to get what
you want and we can help convert it to an EXCEL formula?
wrote in message
oups.com...
Do someone could help me solving the following problem

U E C
2'000'000.- 1'000'000.- 5'00'000.- Initial amounts

-20'000 -12'000.- -53'000.- Amounts variation

-1.00% -1.20% -1.06% % in pourcentage


100.00% 120.00% 106.00% poucentage ratio beween
themselves

100.00% 96.00% 98.00% pourcentage ratio wished

-1641.5 (0) (a)1621.5 (b)20 amounts add or
soustracte in order to
.................................................. .......................reach
the wishes ratio

-21641.5 -10378.5 -52980 modified amounts by line above

-1.08% -1.04% -1.06% % gain/loss with modified
variations

100.00% 95.91% 97.92% ratio with the modified
amounts between %


How can I reach the % ratio wished , with changing only the (a) and (b)
amounts which influence the (0) amount with this formula =-(a+b)

My aim is to find a way to automatically calculate (a) and (b) knowing
only the wished ratio and the real ratio betwen % gain / loss

Thanks for your help

mathematician dummy needing assistance
 

In fact I m unable to put that in equation I m affraid,
the aim of this calucation is to smooth a result by a given ratio. To
find the good amounts I have to try hundreds of combinations.
to resume what i m looking for I can only put it like this.
IF 0 = 1% B= 1.20% C=1.06% how much should I take from 0 and give to B
and C in order that B= 96% of 0 and C = 98% of 0 . Of course 0 won't
'stay at 1% .
Hope it's a litte bit clearer . Otherwise I have an excel spreadsheet I
can forward to you if you wishe.