BallReviews

General Category => Miscellaneous => Topic started by: NBKD52D on September 16, 2017, 01:04:07 PM

Title: EXCEL 2013 FORMULA
Post by: NBKD52D on September 16, 2017, 01:04:07 PM
Does anyone have the formula to track what one would have to roll to decrease their average by one pin?  The formula I use will be dead on the money to show an increase in average by one pin, but the decrease by one pin is totally off.
I track all my averages and everything associated with bowling in my own spreadsheet, but cannot get the average to work that shows what one would have to roll to show a decrease in average for the next week of bowling.

Thanks,
Gene Quidley
GQuidley@carolina.rr.com
Title: Re: EXCEL 2013 FORMULA
Post by: Impending Doom on September 16, 2017, 01:55:30 PM
Why would you want this?
Title: Re: EXCEL 2013 FORMULA
Post by: Aloarjr810 on September 16, 2017, 02:13:23 PM
Does anyone have the formula to track what one would have to roll to decrease their average by one pin?  The formula I use will be dead on the money to show an increase in average by one pin, but the decrease by one pin is totally off.


It's the same formula, just use minus one instead of plus one.


To raise average by one pin =((current Number of games+3)X(current average+1))-current total pins

Sandbagger forumula:
To lower average by one pin =((current Number of games+3)X(current average-1))-current total pins
Title: Re: EXCEL 2013 FORMULA
Post by: HackJandy on September 16, 2017, 02:24:07 PM
>Sandbagger forumula:

The truth emerges.
Title: Re: EXCEL 2013 FORMULA
Post by: Impending Doom on September 16, 2017, 02:48:51 PM
>Sandbagger forumula:

The truth emerges.

This is brazen.
Title: Re: EXCEL 2013 FORMULA
Post by: Walking E on September 16, 2017, 03:19:37 PM
What's the formula for lowering average by two pins? ... Asking for a friend.

 ::)
Title: Re: EXCEL 2013 FORMULA
Post by: Aloarjr810 on September 16, 2017, 03:29:32 PM
What's the formula for lowering average by two pins? ... Asking for a friend.

 ::)

The same, just change the -1 to a -2 or whatever number you wish to lower it by.