Disc Golf Software/Excel Spreadsheets

[Jon Brakel]

Then while crime scene cleanup is cleaning up the mess have Diana post up the step in Scott's directions during which your head exploded! 

[Bruce Brakel]

 

[Bruce Brakel]

The values look like they are in the E column when i click on individual cells. 

[Bruce Brakel]

For what I want it for, I could use the median.  It is just frustrating that coding it is not working.  

.........


The median, Mr. 319, is 917.  That works fine.  

Similar to what Scott was suggesting, but different, I copied the data from Column E, then did a Paste Special, unformatted text, into a Word document.  Then I copied it from Word and did a paste special, unformatted text, into a new column on a new spreadsheet and did the sum and average.  That worked.  Then i copied it from there into the original spreadsheet and it now works fine in the original spreadsheet. 

The Average player is 895, rounding up. 

For my puposes, I think the median is a more relevant number. 

[pickax]

For future reference, you can also save the web page as text and then open that file in excel. You might have better luck extracting tables as the typically the tables will end up tab delimited in the saved file.

[Bruce Brakel]

The second, third and fourth times i did this tonight, with smaller spreadsheets, I copied the data from PDGA.com into Excel.  Then I copied the Excel data and pasted it as unformated values-only data on the second page.  That was sufficient to strip it of whatever was preventing the data from submitting to formatting.

[Dan Michler]

I'll guess $19,500.

[Bruce Brakel]

What I was doing with those spreadsheets was trying to get an idea for what the average skill level is for a Michigan PDGA member so I could set a team skill cap on a team tournament I want to run.  From memory, the results were something like

917 - Median - All Michigan rated members
906 - Mean - All Michigan rated members
907, 904, 897 - Mean - Actual rated members at three local tournaments offering all divisions.

After thinking about it I decided to go to the high end of those numbers because I'm not really marketing this to the juniors and rec women who drag the median down to the mean.  There could be a really clever team strategy reason for including a Rec Woman on the team, but she isn't really my target market.  I'm thinking my target market is the lower rated Open players who don't often cash and the lower rated ams they can recruit to get under the team cap. 
-------------------

Back to the guessing game:

Michler -- $19,500
Pitner -- $22,000
Krupicka -- $30,001
Jon -- $33,000
Clark -- $37,501
JDunk -- $41,000
Brett -- $51,500

When I notice that I have ten guesses, we'll announce a winner from all the guesses and the prize.  The prize is better than nothing and it is free.  So if you see this, throw in a guess.  Since I dropped a big hint-bomb before Michler guessed, and he seemed to miss it, I'll drop another:  the answer is higher than the lowest guess and lower than the highest guess.  Knowing that, you can now guess without even knowing what we're guessing at!    

[mirth]

Umm.... 25,001

[Bruce Brakel]

Michler -- $19,500
Pitner -- $22,000
Mirth -- $25,000
Krupicka -- $30,001
Damon -- $34,343
Jon -- $36,000
Clark -- $37,501
JDunk -- $41,000
Brett -- $51,500

No more hints. 

[damonshort]

$34,343

[Chainmeister]

$39,250

[Team Wilken]

$27330.00

[can't putt]

$35850.37

[Bruce Brakel]

These are the final guesses:

Michler -- $19,500
Pitner -- $22,000
Mirth -- $25,000
Team Wilken -- $27,330
Krupicka -- $30,001
Damon -- $34,343
can't putt -- $35,850.37
Jon -- $36,000
Clark -- $37,501
Barish -- $39,250
JDunk -- $41,000
Brett -- $51,500

Before we go check the yellow tab for the winning answer, let's talk about prizes.

Our winning contestant will get a dyed disc of his or her choice from anything in my repetoire, including the new Superman and new Ghostbusters that none of us have seen me do yet.  You can pick it up at any IOS. 

\\\\\\\\\\\\\\\\\drum roll////////////////////

$37,119 in total expenses not counting meals.  Our winner is Mike Clark!

$30,351 was discs. 
I had $32,402 in income. 

Out of control inventory growth made up for most of the difference so the loss was not as bad as it looks. 

[stpitner]

wow, now I'm scared to finish running my numbers lol.