Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Mathematics (https://www.askmehelpdesk.com/forumdisplay.php?f=199)
-   -   How can I make a formula to transfer a type of units to different amout with my data? (https://www.askmehelpdesk.com/showthread.php?t=830984)

  • Mar 6, 2017, 08:36 PM
    Cloud91
    How can I make a formula to transfer a type of units to different amout with my data?
    P is the currency which just stands for points.
    I need an equation to transfer old points to new points. If I were to input 150 (X = Old) I would get 250 (Y = New) out. This needs to continue for any value excluding negatives (Unless it comes with the equation then it is okay of course)


    Two Tables:


    Old:
    50P (33% of normal) = 0.000825
    100P (66% of normal) = 0.00165
    150P (Normal 100%) = 0.0025
    200P (133% of normal) = 0.003325
    250P (166% of normal) = 0.00415


    New:
    80P (33% of normal) = 0.000825
    170P (66% of normal) = 0.00165
    250P (Normal 100%) = 0.0025
    335P (133% of normal) = 0.003325
    415P (166% of normal) = 0.00415


    I can provide for information if needed c:
  • Mar 6, 2017, 09:09 PM
    ebaines
    Please clarify a few things:

    1. Are the values in your tables just examples? In other words, do you want to be able to enter any value for X, or is it restricted to just the 5 values in your table?
    2. What do the values following the equal signs signify?

    At first glance it looks like the Y values are simply the X values increased by 67%, then rounded. So that can be approximated by Y = (5/3)X. If you want to more precisely match the exact values, then given the 5 data points that you provided we can construct a 4th order polynomial the precisely hits all five data points - is that what you're looking for?
  • Mar 6, 2017, 10:12 PM
    Cloud91
    This link is to view an excel file with much information:
    https://1drv.ms/x/s!Ajo2dBtYwVoKgQfIPxgKF1JawoP_


    This project all has to do with monetization. People watch advertisements to earn points which are redeemable for cash. Recently I noticed that I was actually giving more than I was getting because of the lower CPM (I thought it was $5.00) I changed to a new system to meet those standards and make it look at bit nicer with the payouts. For example, 10,000P is worth 10 cents. But I need to transfer all the previous points from users into this new system. Mainly if a user had 150 points it would transfer to 250 points. What I gave earlier were examples of how a certain amount of points from the old system were transferred into a certain amount in the new system. This can be repeated infinitely forward. Those decimal values are U.S. Dollars down to small increments.


    So overall, I would like to be able to enter any value for X and get the correct output.
    The values following the equal signs are U.S. dollars to represent the fact that when the points change they must equal that amount in dollars.


    150 points in the old system equals a quarter of a cent (0.0025)
    250 points in the new system still equals a quarter of a cent (0.0025)
  • Mar 6, 2017, 10:32 PM
    Cloud91
    Okay, I noticed my excel project was a bit messed up with the percentages. I keep changing it from 66% to 67% and just need it to be exactly 1/3. There is a simple way to do what I wanted and most of the things I had put on the table were wrong. I am answering my own question saying I need to multiple the old value by 1 and 2/3. Sorry for over-complicating this I had no idea it would be so simple. My basic equation is:

    Y = 5/3(X)
  • Mar 6, 2017, 10:33 PM
    ebaines
    I would suggest simply multiplying the old points by 5/3. Would that work for you?

  • All times are GMT -7. The time now is 04:35 PM.