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,
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.
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.
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)
Jeff - what all do you need the program to do?
There are some files found here (http://discontinuum.org/index.php?option=com_smf&Itemid=26&topic=2796.0) 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 :)
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
Quote from: pickax on February 07, 2009, 06:08:19 AM
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.
Bruce,
I'll guess $51,500.
If i get ten guesses, the winner will get a prize! ;D
I'm in for prizes.
$37,501
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.
im going to go with 41,000
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.
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?
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....
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.
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.
I'm guessing that the numbers aren't numbers. Let me try a couple of things here.
Add another column that coverts them to numbers. Define the column this way
=VALUE(E1)
=VALUE(E2)
...
Then use the formulas earlier recommended.
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.
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! ;D
;D
The values look like they are in the E column when i click on individual cells.
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.
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.
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.
I'll guess $19,500.
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! ;D
Umm.... 25,001
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.
$34,343
$39,250
$27330.00
$35850.37
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.
wow, now I'm scared to finish running my numbers lol.