# mathematician dummy needing assistance

1. ## 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  Register To Reply

2. ## Re: 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?
<jevoudraisdire@yahoo.fr> wrote in message
> 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
>
>  Register To Reply

3. ## Re: 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.  Register To Reply