BowlingFans.com, The site for the fans, by the fans....
Sponsored Links




ChatBox:

Sponsored Links


Topic Options
Rate This Topic
#178498 - 05/05/13 09:49 PM Bowling applications of Excel: A primer
Richie V. Offline
Virtual League Secretary,
Virtual League Champion x4


Registered: 02/21/08
Posts: 4686
A/S/L: 52/M/Brockton, MA
I've been planning this thread for some time. smile

I assume most of you have at least a basic knowledge of Excel, and, for these purposes, I will also assume you have Excel 2010, which is the version I use.

My first post will address the basic formulas and functions used when tracking your scores. Obviously, the SUM and AVERAGE functions are involved, but, if you're building a log that doesn't track fractions of a whole pin in it, you do have the TRUNC function available to you, making the formula you'll use for the average column as follows:

TRUNC(AVERAGE(range))

where range is the range of cells containing your games.

Also, remember that formulas can be copied and pasted as you add scores, but the pitfall is related to cell references, of which there are two types, relative and absolute. A normal cell reference of D3 is relative, so when you copy down the formula AVERAGE(D3:F3), it will paste as AVERAGE(D4:F4) and only give you that night's average. To get your full average, you'll need an absolute reference to D3, entered in the formula as $D$3.

Finally, a lot of you might want to track what series score you need next week to raise your average to the next full pin. The formula for calculating it is more involved, but exists, as follows:

(TRUNC(AVERAGE(range))+1)*(COUNT(range)+3)-SUM(range)

Trust me, it's tricky for me to build it...it does involve your knowledge of pre-algebra math (namely the order of operations). The 3 in this formula can be replaced with whatever number of games you bowl in a series (4 for most of you for whom it is not 3)


Edited by Richie V. (05/05/13 11:04 PM)
_________________________
Arsenal (all 15 lb.)
Alpha Crux
Marvel Pearl
IQ Tour Fusion
Reign of Fire
Tropical Breeze
Fast
T-Zone

Career Highs
Avg.: 197 (Summer 2008)
Book: 186
Series: 707
Game: 288

Current
Brunswick Mixed - Avg: 168 HS: 615 HG: 255
Composite avg. (w/ Sun. night sub): 170

The Tenth Board: My bowling blog
Richie's BowlSK profile

Top
#10100 - 1 second ago Sponsored Links
Sponsored Links Online   content
Legend

Registered: Fri Aug 27 2004
Posts: 10100
A/S/L: Mountain View, CA
Top



Entire topic
Subject Posted by Posted
Bowling applications of Excel: A primer Richie V. 05/05/13 09:49 PM
Re: Bowling applications of Excel, a primer Richie V. 05/05/13 10:10 PM
Re: Bowling applications of Excel, a primer Richie V. 05/05/13 10:26 PM
Re: Bowling applications of Excel, a primer Richie V. 05/05/13 10:38 PM
Re: Bowling applications of Excel, a primer Richie V. 05/05/13 11:55 PM
Re: Bowling applications of Excel: A primer Richie V. 05/06/13 03:45 AM
Re: Bowling applications of Excel: A primer FuriousSam 05/07/13 02:10 AM
Re: Bowling applications of Excel: A primer Richie V. 05/08/13 03:41 AM
Re: Bowling applications of Excel: A primer FuriousSam 05/08/13 10:49 PM
Re: Bowling applications of Excel: A primer Richie V. 05/08/13 04:06 AM
Re: Bowling applications of Excel: A primer sk8shorty01 05/08/13 03:00 PM
Re: Bowling applications of Excel: A primer Dan300 05/08/13 03:22 PM
Re: Bowling applications of Excel: A primer Richie V. 05/08/13 04:24 PM
Re: Bowling applications of Excel: A primer Mkirchie 05/09/13 10:13 AM
Re: Bowling applications of Excel: A primer sk8shorty01 05/09/13 08:19 AM
Re: Bowling applications of Excel: A primer sk8shorty01 05/09/13 10:16 AM
Re: Bowling applications of Excel: A primer Richie V. 05/09/13 02:35 PM
Re: Bowling applications of Excel: A primer Mkirchie 05/09/13 04:29 PM
Re: Bowling applications of Excel: A primer Richie V. 05/09/13 04:55 PM
Re: Bowling applications of Excel: A primer Richie V. 05/11/13 12:45 AM
Re: Bowling applications of Excel: A primer Richie V. 05/16/13 05:41 PM
Re: Bowling applications of Excel: A primer Richie V. 09/05/13 05:16 PM
Re: Bowling applications of Excel: A primer Richie V. 01/02/14 09:07 PM
Re: Bowling applications of Excel: A primer Richie V. 02/27/14 09:02 PM
Re: Bowling applications of Excel: A primer Richie V. 08/09/14 07:20 PM
Re: Bowling applications of Excel: A primer mmalsed 08/09/14 08:08 PM
Re: Bowling applications of Excel: A primer Richie V. 08/13/14 04:27 AM
Re: Bowling applications of Excel: A primer Richie V. 09/09/15 05:50 AM
Re: Bowling applications of Excel: A primer Richie V. 09/07/16 03:47 PM

Moderator:  Angel, Community Manager 
Savings That Support BowlingCommunity.com
We need your help!
Rather than begging for donations we're asking you to do one simple thing to help keep these forums running smooth:
When shopping for anything on Amazon.com or eBay please use these links to go to the web sites.

This won't cost you a cent!
You'll still get the exact same low prices, deals and free or low cost shipping; it doesn't change anything for you at all! The items do not have to be bowling related; all purchases made through these links help us! Amazon.com and eBay will pay us a small commission for every sale and it's helping us cover the expenses.

BowlingCommunity.com Recent Posts
Our Bowling Ally is now Chuckie Cheese
by djp1080 - Yesterday at 07:59 PM
Major News in the Industry
by Mkirchie - 11/17/19 04:35 PM
Good morning everyone...
by djp1080 - 11/17/19 12:50 PM
Plastic or Urethane?
by Dennis Michael - 11/17/19 12:45 PM
What is the best ball to get?
by djp1080 - 11/10/19 09:02 PM
Which fork on the Hy-Road should I take?
by Mkirchie - 11/02/19 07:05 AM
End of Days
by BOSStull - 11/02/19 06:44 AM
Terms Of Use
Use of this community signifies your agreement to the Community Standards and Conditions of Use.

About BowlingFans.com | Contact Us | Advertise With Us | Site Map
Use of this website constitutes acceptance of our Terms of Use and Privacy Policy. | Material Connection Disclosure

Copyright © 1998 - 2019 - usrbingeek LLC | Copyright Policy
BowlingFans.com, BowlingFans, The Right Approach, Kegler's Connection, Tour411, BallBeat, BowlingCommunity.com, BowlSearch.com, and Bowling News You Can Use are trademarks of usrbingeek LLC. All other trademarks and tradenames are property of their respective owners.