How to create a scenario (game win/loss percentage).

[Burrgogi]

Here's my current stats in Free Cell.



My win percentage is currently 96.1%. I'd like to have a little excel chart or table whatever that will tell me how many more games I need to win in order to make it 97%. I've noticed that Free Cell will round up so if my win percentage happens to be at 96.51%, Free Cell will round that up to 97%.

Is there a way to have Excel fill this in automatically?

 

[Cubist]

Are you asking more many more win consecutively, assuming no loss? If so, then try,

Book1
	A	B	C	D	E	F
1			97%	98%	99%
2	Win	51	14	47	147
3	Loss	2
4	Total	53
5
Sheet2

Cell Formulas
Range	Formula
C2:E2	C2	=ROUNDUP(($B$2-C$1*$B$4)/(C$1-1),0)

 

[Burrgogi]

Are you asking more many more win consecutively....

Sorry no, I should have specified that I'm looking for a win/loss percentage based on the current stats with the number of wins and losses dynamically changing. I can easily calculate how many more wins I need to jump up to 97%. However, my losses will not always be 2 (as shown in the screenshot).

 

[Cubist]

Sorry no, I should have specified that I'm looking for a win/loss percentage based on the current stats with the number of wins and losses dynamically changing. I can easily calculate how many more wins I need to jump up to 97%. However, my losses will not always be 2 (as shown in the screenshot).

If you're winning/losing are uncertain then you're dealing with probability. You can find the expected number of games but not exact.

 

[Burrgogi]

If you're winning/losing are uncertain then you're dealing with probability. You can find the expected number of games but not exact.

It's not like we're taking a complete stab in the dark. 2 things are known with certainty: current # of wins and current # of losses. Isn't there some sort of a macro or formula that can evaluate:
If cell B3 (# of losses) remains constant, how many more wins will it take to jump up to 97%?

 

[Cubist]

It's not like we're taking a complete stab in the dark. 2 things are known with certainty: current # of wins and current # of losses.

Are you assuming that this pattern will continue? For every 2 loss, there are 51 wins?
Either way you can't find the exact number, it's still an expected value because the past isn't 100% predictive of the future.

 

[Cubist]

If cell B3 (# of losses) remains constant, how many more wins will it take to jump up to 97%?

That's what I gave you in post#2.