Ask Experts Questions for FREE Help !
    Cloud91's Avatar
    Cloud91 Posts: 3, Reputation: 1
    New Member

    Mar 6, 2017, 08:36 PM
    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:

    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

    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:
    ebaines's Avatar
    ebaines Posts: 12,132, Reputation: 1307

    Mar 6, 2017, 09:09 PM
    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?
    Cloud91's Avatar
    Cloud91 Posts: 3, Reputation: 1
    New Member

    Mar 6, 2017, 10:12 PM
    This link is to view an excel file with much information:!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)
    Cloud91's Avatar
    Cloud91 Posts: 3, Reputation: 1
    New Member

    Mar 6, 2017, 10:32 PM
    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)
    ebaines's Avatar
    ebaines Posts: 12,132, Reputation: 1307

    Mar 6, 2017, 10:33 PM
    I would suggest simply multiplying the old points by 5/3. Would that work for you?

Not your question? Ask your question View similar questions


Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.

Check out some similar questions!

Grams to formula units [ 0 Answers ]

How do you convert grams to formula units... Ex. How many formula units are in 1.98g of MgSO4

Equivalent units of production formula? [ 3 Answers ]

Please help me can you at least give me formula for getting the equivalent units of production for the year. Thank you!:confused::confused::confused::confused:

What is the total mass of a mixture of 1.5 X 10^23 formula units Na2So4, 0.132 mol H2 [ 1 Answers ]

I Don't know what to do.. I need like all the work and answer. Just to like have an example

View more questions Search