 Ask Remember Me? Cloud91 Posts: 3, Reputation: 1 New Member #1 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:

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: ebaines Posts: 12,130, Reputation: 1307 Expert #2 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 Posts: 3, Reputation: 1 New Member #3 Mar 6, 2017, 10:12 PM
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) Cloud91 Posts: 3, Reputation: 1 New Member #4 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 Posts: 12,130, Reputation: 1307 Expert #5 Mar 6, 2017, 10:33 PM
I would suggest simply multiplying the old points by 5/3. Would that work for you?

 Question Tools Search this Question Show Printable Version Email this Page Search this Question: Advanced Search