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




ChatBox:

Sponsored Links


Page 2 of 3 < 1 2 3 >
Topic Options
Rate This Topic
#178542 - 05/08/13 03:22 PM Re: Bowling applications of Excel: A primer [Re: Richie V.]
Dan300 Offline
Regional Pro Contender

Registered: 10/15/07
Posts: 574
A/S/L: 40s/M/Woodbridge, VA
I'll post a link to my own google spreadsheet. I implement many of the techniques Richie outlines in this post.

https://docs.google.com/spreadsheet/ccc?...amp;usp=sharing
_________________________
Career:
----
800s: 836, 814, 802, 822
300s: 13 total

Season (14-15):
----
HSS: 822
HSG: 300(2)

Averages(1/8/15):
----
Composite: 225
WMCL: 235
Stan Soaper: 219
Men's Automotive: 220

Balls(15#):
----
HyperCell Skid
HyperCell
Infinite Theory
Wrecker

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
#178543 - 05/08/13 04:24 PM Re: Bowling applications of Excel: A primer [Re: Richie V.]
Richie V. Offline
Virtual League Secretary,
Virtual League Champion x4


Registered: 02/21/08
Posts: 4686
A/S/L: 52/M/Brockton, MA
sk8, I've also found that, after a time, when I enter my games and tab over to my total column, it will automatically insert the formula to sum the columns in that row.
_________________________
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
#178544 - 05/08/13 10:49 PM Re: Bowling applications of Excel: A primer [Re: Richie V.]
FuriousSam Offline
Action Bowler

Registered: 09/29/03
Posts: 299
A/S/L: 32/M/Lodi, NJ
Originally Posted By: Richie V.
I hope you got something out of this thread, FuriousSam. If you have any questions about something with Excel, post (this goes for anyone else, too).

"floating" in my previous post should really be "moving" smile


Generally speaking, what's a good range for "moving" averages? 3 weeks? 5 weeks?

-- Sam
_________________________
Bowling keeps me sane, yet I am crazy about bowling...

Motiv Forza
Motiv Venom Shock
White Dot

BowlSK

Top
#178546 - 05/09/13 08:19 AM Re: Bowling applications of Excel: A primer [Re: Richie V.]
sk8shorty01 Offline
Virtual League Champion x2

Registered: 01/05/09
Posts: 5163
A/S/L: 30/M/Merritt Island, FL
I would say the last 21 games is a good round number. There must be a reason the USBC selected that number as what it takes to classify your average as a "real" book average.
_________________________
Storm Amatuer Staff Member
BowlersMart.com Staff Member
Logo Infusion Staff Member
IAB Staff Member

PBA Member
USBC Level 1 Certified Coach
Head Coach - Cocoa High School

Career 300 games - 5
Career 800 series - 6
High Scratch Series - 823

Top
#178547 - 05/09/13 10:13 AM Re: Bowling applications of Excel: A primer [Re: Richie V.]
Mkirchie Offline
Hall of Famer Contender

Registered: 01/14/07
Posts: 873
A/S/L: 39/M/New Jersey
Richie, thanks mentioning floating averages. For some reason, I never thought to include it in my sheet. I still need to get around to adding average +/- 1 to my sheet, but I haven't felt like tinkering around with it lately. One thing that I have on mine is tracking the average for each individual game in a series, so I have a game 1 average, a game 2 average, and a game 3 average. All of my game scores are all in the same column due to how my sheet is structured, so it was trickier to take the average for every 3rd game. I forget exactly how I accomplished this, I looked it up on excelforum myself and I don't have the file on me right now, but I know it does involve arrays. I tend to tweak it over the summer when I'm not adding league scores.

Mark
_________________________
Current Average - 225
HG-300(12)
HS-799

Top
#178548 - 05/09/13 10:16 AM Re: Bowling applications of Excel: A primer [Re: Richie V.]
sk8shorty01 Offline
Virtual League Champion x2

Registered: 01/05/09
Posts: 5163
A/S/L: 30/M/Merritt Island, FL
I tend to just use bowlsk to do all my stat tracking lol.
_________________________
Storm Amatuer Staff Member
BowlersMart.com Staff Member
Logo Infusion Staff Member
IAB Staff Member

PBA Member
USBC Level 1 Certified Coach
Head Coach - Cocoa High School

Career 300 games - 5
Career 800 series - 6
High Scratch Series - 823

Top
#178549 - 05/09/13 02:35 PM Re: Bowling applications of Excel: A primer [Re: Richie V.]
Richie V. Offline
Virtual League Secretary,
Virtual League Champion x4


Registered: 02/21/08
Posts: 4686
A/S/L: 52/M/Brockton, MA
sk8, I use 9 games (3 weeks) as my moving average b/c that's the number of games most leagues require to establish your average in the league.

Mkirchie, if you go to my log (I linked it in a previous post), you'll see I do Game 1, Game 2, etc., averages, as well.
_________________________
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
#178551 - 05/09/13 04:29 PM Re: Bowling applications of Excel: A primer [Re: Richie V.]
Mkirchie Offline
Hall of Famer Contender

Registered: 01/14/07
Posts: 873
A/S/L: 39/M/New Jersey
Originally Posted By: Richie V.
Mkirchie, if you go to my log (I linked it in a previous post), you'll see I do Game 1, Game 2, etc., averages, as well.

Guess it would have helped if I scrolled down to the bottom. I put my average and other such stats at the top of the sheet to the right of my scores.

Mark
_________________________
Current Average - 225
HG-300(12)
HS-799

Top
#178552 - 05/09/13 04:55 PM Re: Bowling applications of Excel: A primer [Re: Mkirchie]
Richie V. Offline
Virtual League Secretary,
Virtual League Champion x4


Registered: 02/21/08
Posts: 4686
A/S/L: 52/M/Brockton, MA
Originally Posted By: Mkirchie
Originally Posted By: Richie V.
Mkirchie, if you go to my log (I linked it in a previous post), you'll see I do Game 1, Game 2, etc., averages, as well.

Guess it would have helped if I scrolled down to the bottom. I put my average and other such stats at the top of the sheet to the right of my scores.

Mark


I just thought at the bottom of the respective columns would be a natural place to do the game averages. smile
_________________________
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
#178568 - 05/11/13 12:45 AM Re: Bowling applications of Excel: A primer [Re: Richie V.]
Richie V. Offline
Virtual League Secretary,
Virtual League Champion x4


Registered: 02/21/08
Posts: 4686
A/S/L: 52/M/Brockton, MA
A thing to keep in mind when setting up per-pair averages is that you can bold your starting lane (I did in my prototype log), but the COUNTIF and SUMIF functions only look at the value in the cell and disregard formatting.
_________________________
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
Page 2 of 3 < 1 2 3 >



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
Bowler turns 100
by Dennis Michael - Yesterday at 05:04 PM
Our Bowling Ally is now Chuckie Cheese
by djp1080 - 11/18/19 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.