
Algebra PreAlgebra and Basic Algebra Math Forum 
 LinkBack  Thread Tools  Display Modes 
March 10th, 2013, 04: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 
March 10th, 2013, 04: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)/(40003000) 
March 10th, 2013, 06: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 

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 04:31 PM 
How many days?  mathLover  Advanced Statistics  0  April 17th, 2012 01:57 AM 
Log problem thats been bothering me for days  wiseguy68  Algebra  14  June 2nd, 2009 03: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 