Excel / Maths problem - please help!

Stuck_1963

I'm a bit of a Backgammon nut and so keep a record of my score (i.e. number of games played, how many wins and losses, percentages etc).

And I keep those all on a spreadsheet.

But....I need help with an Excel formulae and especially the maths for it, as the maths side of it is a bit beyond me

Here's the story;

My Overall Win Rate since I started playing is 53.13%

And I've played 9894 games in total (so 53.13% of those I have won).

However, more recently I've really improved my game and my Current Win Rate is actually 59.36%.

My goal is to get my Overall Win Rate to 54.0% (from 53.13%).

So.... here's my question;

Assuming my Current Win Rate stays at 59.36% how many more games do I need to play for me to reach 54.0% ?

I need that as a formula

Please, if anyone can help I will be very happy and eternally grateful to you !

Many thanks in anticipation

Bobby3210

When you say your "current win rate is 59.36%" what do you mean? Is this over your last 50/100 games? 

Stuck_1963

Yes, it's over the last 322 games and is a more accurate reflection of how I now play the game.

Bobby3210

something like this? 

Bobby3210

The formulae are probably self explanatory from the headings. You could reduce number of games in column e to get cell f5 to read exactly 54%

Stuck_1963

Thanks Bobby and nice try.

I'm looking for a solution that'll give me the exact answer from the numbers I've given.

It looks like your solution is kind of iterative and would require you to try inputting different numbers until you get close.

Make sense ?

Thanks so far though, much appreciated

stragglebod

I make it such a nice round figure (assuming the overall win rate is rounded and wins to date are 5257) that I suspect this a maths homework question so I'm not going to say either what it is or how I did it

debitcardmayhem

stragglebod said:

I make it such a nice round figure (assuming the overall win rate is rounded and wins to date are 5257) that I suspect this a maths homework question so I'm not going to say either what it is or how I did it

Not being fair stragglebod 40^2

Stuck_1963

I need the formula so I can input any figure. I said 54% because I thought that was achievable at first, but at my current new rate it looks very far away.  So I’m actually aiming for a much closer milestone, say 53.5%.

no worries if you think this is school homework.  It isn’t and someone else more helpful will chime in.

ps if you did YOUR homework, you’d see that my only other thread on this site was in 2013 where I, among many others, got scammed by an online law firm.

debitcardmayhem

OK i'll put you out of your misery

.54 = (5257+5936n)/(9894+n)

therefore .54x9894 + .54 n = 5257 + .5936n

.54x9894 - 5257 = .5936n - .54n

85.76 = .0536n

n = 85.76 / .0536 = 1600 (which is 40 squared hence the coded msg to stragglebod 40^2)

HTH

I'd want to aim for 60%

Chino

debitcardmayhem said:

n = 85.76 / .0536 = 1600 (which is 40 squared hence the coded msg to stragglebod 40^2)

I calculate that the OP actually needs to play 1,606 more games ( 9894(0.5313 - 0.54) / (0.54 - 0.5936) ).