DeletedUser3157
I was just semi-trolling the thread title man. It says "simple" way of calcing smth and then u just post the actual formula. Not like there is a more difficult way of calcing it as alternative, it's not a multiple choice thing
Gate2 bought 4253 forgepoints with a total cost of 453 million coins (453157150)
As a math guy - It would be easier for most folks to use:
n=(x-200)/50
Thanks for the math.
Excel is much easier: my excel spreadsheet looks like this
Column A: Amount of forgepoints Column B Cost of 1 single forgepoint Column C: Total Forgepoint cost
and now, in A1 you fill in 1, B1 you fill in the amount of coins it cost for the first single one, and C1: +=B1
For A2 =A1+1 B2=B1+50 C2= B2+C1
Now you scroll these formulas down until about 1000 fields deep, then you check the total amount of coins you have, (or want to spend as maximum), scroll down where you see that number in the C column and read the amount of forgepoints you get for it in A
And easy thing about it: you only have to change field B1 and everything recalculates
and for us folks who aren't most folks? I have no idea what your post means.
solving for n from the original equation x = n (25n + s - 25) gets you this
View attachment 7451
which allows you to figure out the maximum fps you can buy with your current gold amount and fp cost which was far more useful to me than the original equation (once I set up excel to solve the new equation for me anyways)
make it a google doc/excel sheet, then share the link here and everyone can use it (make sure it's editable by everyone so they can plug in their x, s and n values--which is all I know about any of that). My rewritten formula works well in excel if add the 'round down' function before the actual equation.if I make from these 2 equations a very simple excel spreadsheet, is there a website to publish so everyone can download?