Disc Golf Software/Excel Spreadsheets

[amdiscgolfer]

Does anyone know of some software that can be used for disc golf leagues/tournaments?

I am tired of entering everything by hand, but also need to have a printable version for the course.

I am also not as fluent as I would like to be in Excel so I am not sure as how to get the spreadsheet to do what I would like as well.

Thanks in advance,  

[Bruce Brakel]

For my taxes I need to add up the wholesale value of my inventory.  So I sorted my inventory first by Sold/unsold then by manufacturer and then by plastic type and quickly assigned the dollar cost average to every disc in my inventory by plastic type.  Now I need to total that column.  For some reason the dude who reinstalled Excel for me did not install the help files.

How do I total a column from J2 to J1133?  Anybody? 

I tried reading some on-line help files, but they directed me to use the fx button and then SUM, and SUM will only do 30 cells and you have to enter each cell in J2, J3, J4 ... J31.  I just want to do the summation of column J from J2 to J1133.  J1 is in the header row, and would be a fine place to put the total. 

[Bruce Brakel]

And, if you read this and like to play guessing games, guess how much I spent on disc golf last year.  "spent on disc golf" means all discs and disc golf equipment, gas and tolls to and from tournaments I ran, popstand supplies, entry fees, PDGA sanctioning, insurance and fees, and miscellaneous office supplies like cardstock and sharpies, but not meals.  I would have had to eat, disc golf or not, so don't count meals.  Gross expenditures, not profit or loss. 

[stpitner]

including gas and all that? hmm.. $22,000

Yes, it stops after 30 numbers if you enter them individually, but =SUM(J2:J1133) should total the entire thing (that's a colon in between the two cells)

[stpitner]

Jeff - what all do you need the program to do?

There are some files found here in this thread that might be helpful.

Excel is a powerful tool, not too difficult to learn.  What do you need it to do?  I know that Mike is very good with Excel, and I know quite a bit too.  Additional info would be appreciated

[pickax]

You can also type =sum( and then highlight all of the cells that you want to add up. Finish it with a ) and you are done.

I'm guess it is North of $30k

[Bruce Brakel]

You can also type =sum( and then highlight all of the cells that you want to add up. Finish it with a ) and you are done.

I'm guess it is North of $30k

Thanks, I'll try that.  On the other computer.  And tell you how it goes.

[CEValkyrie]

Bruce,

  I'll guess $51,500.

[Bruce Brakel]

If i get ten guesses, the winner will get a prize!   

[Mike Clark]

I'm in for prizes.

$37,501

[Jon Brakel]

I'm guessing you spent about $36,000 and were compensated by the IOS, Big D and cash sales about $33,000 giving you a yearly net loss of $3,000.

[jdunk]

im going to go with 41,000

[Bruce Brakel]

I did the numbers on my total expenses this last Thursday night and they are on paper on the dining room table.  One of the guesses is so close it is uncanny.  At first I thought, "Did he remote hack my computer?" and then I remembered it was on a yellow tab, not on the computer. 

Mike:

=SUM( highlight cells ) worked fine. 

[Bruce Brakel]

O.k., now I'm trying to take the average of a long column of numbers, E1 to E637, not for taxes, for disc golf stats purposes.  The help files say to type " =AVERAGE(E1:E637) " in the cell where you want the value to appear.  Every time I do that I get #DIV/0! which is the divide by zero error message.  Any clues what I'm doing wrong here? 

[whitechocolate]

when i do averages i input =(E1:10)/10

so i believe =(E1:E637)/637 should do the trick.  let me know if it's doesn't work, but it should be okay unless you have some blank lines inbetween....

[pickax]

If your column has no data yet, you will get #DIV/0! errors. What you should do (so that you handle blank entries correctly) is IF(COUNT(E1:E637),AVERAGE(E1:E637),"No Average")

I would not hardcode the divisor. That's asking for trouble.

[Bruce Brakel]

Well, neither of those suggestions worked.    

I'm trying to fiure out the rating of the average rated Michigan PDGA member.  I have an Excel spreadsheet that I made by copying and pasting from the PDGA.com ratings page.  Is it possible that by copying and pasting from PDGA.com I've imported some formatting thing that is disabling formulas? 

Typing in =SUM(E1:E637) gets me 0. 

[pickax]

I'm guessing that the numbers aren't numbers. Let me try a couple of things here.

[pickax]

Add another column that coverts them to numbers. Define the column this way
=VALUE(E1)
=VALUE(E2)
...
Then use the formulas earlier recommended.

[stpitner]

if your sum is equaling 0, then your data isn't right.  It's possible that it LOOKS like it's in column E, but all of the information is actually stored in column A and not split across the cells.  To check that, just click in one of the Column E values, look at where you would type in the value - if it's blank, move to another field to see where the entire string value is stored.

If you find out that it's not stored in column E like you think, try this:

I don't know if there's a way within excel to do this without going this route first: take all that you copied, dump it into notepad and save it as a text file. (to open notepad you can click Start -> Run, type in notepad and click ok)

In excel click to open a file.  Under where the file name would appear make sure you set the filter to say all files *.* or else you wouldn't see the text file.  Open the text file.

Now you'll get a wizard asking how you want to open this file.  You can say that you want it delimited by a character or fixed width.  Because the names of people can very, I'd say pick delimited by a character and then on the next screen use the space key as the separator.  This will display MOST of the data properly.  You'll have to go down the list and manually fix the ones that have 3 names to their name (like the Jr's, Sr's, III's, or those with a nickname on the list).  After that I think you'll be able to work with your data the way you need to.