My Math Forum  

Go Back   My Math Forum > High School Math Forum > Algebra

Algebra Pre-Algebra and Basic Algebra Math Forum


Reply
 
LinkBack Thread Tools Display Modes
March 10th, 2013, 05:21 AM   #1
Newbie
 
Joined: Mar 2013

Posts: 2
Thanks: 0

Calculating days until next rank

Hello people,

I am new here and I apologize if my question is not in the right section.

I have a problem and I hope I can get some help here.
For a game, I am trying to work out a formula to calculate how many days it would take for one player to outrank another, based on a percentage or amount of points per day. The growth rate differs per day and per player of course. Growth rates and points growth are already calculated by my excel sheet.

So player 1 has 200.000 points and grows every day with 3000 points.
Player 2 has 180.000 points and grows every day with 4000 points.

Now I can calculate how many days it would take before player 2 has more points then player 1. But is there a way to calculate this with a mathematical formula?

I hope you can shed some light on this

Greetings : Jeroen
JeroenMioch is offline  
 
March 10th, 2013, 05:54 AM   #2
Senior Member
 
Joined: Feb 2013

Posts: 281
Thanks: 0

Re: Calculating days until next rank

t: time in days
p1(t): points of player1 at t
p2(t): points of player2 at t

p1(t) = 200 000 + 3000*t
p2(t) = 180 000 + 4000*t

The question is the t when p1 = p2
200 000 + 3000t = 180 000 + 4000t
i.e.
t = (200 000 - 180 000)/(4000-3000)
csak is offline  
March 10th, 2013, 07:55 AM   #3
Newbie
 
Joined: Mar 2013

Posts: 2
Thanks: 0

Re: Calculating days until next rank

That works great!
I made my excel sheet so that values between parentheses are the days until next rank.
Like this:

0
100
(54)
5
(15)
(3)
(1)
2
(27)
10
(1)

Now all I have to do is make excel discard or "o" the values not between parentheses.
But that is more a matter for an Excel based forum :P

I thank you gracefully for your help

Greetings : Jeroen
JeroenMioch is offline  
Reply

  My Math Forum > High School Math Forum > Algebra

Tags
calculating, days, rank



Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Modeling 4 pl same place (3 options) 5 days minimum asd1 Linear Algebra 0 November 10th, 2013 05:31 PM
How many days? mathLover Advanced Statistics 0 April 17th, 2012 02:57 AM
Log problem thats been bothering me for days wiseguy68 Algebra 14 June 2nd, 2009 04:59 PM
Assesment Test In a Few Days...Numerical Skills/Prealgebra.. SML Number Theory 0 December 31st, 1969 04:00 PM
Calculating days untill next rank JeroenMioch Calculus 1 December 31st, 1969 04:00 PM





Copyright © 2018 My Math Forum. All rights reserved.