Closed Thread
Results 1 to 3 of 3

mathematician dummy needing assistance

  1. #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

    Thanks for your help


  2. #2
    Barb Reinhardt
    Guest

    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?
    <[email protected]> wrote in message
    news:[email protected]...
    > 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
    >




  3. #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.


Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1