Dart Stats Sheet

**bmgaspard** · 01-20-2009, 12:14 PM

This is my scenario.

I am captain of a Dart Team in 2 different leagues. I have a excel spreadsheet that does some calculation for me (Wins, Losses, Percentage) when I manually enter the numbers. I have just created a workbook with multiple worksheets for each week of the season, including playoffs, and a sheet for overall and print. I want to be able to input the data for each week and have it auto calculate on the overall page and auto populate the print page. The overall page will have all the stats, wins singles games, wins doubles games and wins 3 man games, along with percentage in each category. I am pretty sure I can accomplish this task. The problems I am having is:

1. Adding wins and losses based on player number, I have one cell with a players number and I will put a 1 or 0 in that cell based on a win or loss. Off to the side I have the player roster with card numbers and a win column and loss column. I would like excel to see the 1 or 0 in the main column and add the appropriate to the roster column, calculating total for the night. Then adding that to the overall page.

2. The print page, I want a easy to read page that displays each players, wins and losses for each category described earlier and averages through each week displayed nicely to distribute each week. Would I have to export that page to word? I want to display wins and losses as 14-7 without it calculating it.

If someone can point me in the right direction that would be awesome. I can do simple stuff in excel, never had to do anything like this before, wanted to do it for a while and just didn't know where to start. What formulas to look up, not familiar enough with the nomenclature to look for the correct functions to accomplish this task, or if it's even possible.

**Cheeky Charlie** · 01-20-2009, 01:56 PM

Hey there,

Perhaps you could post what you have (with the majority of the data taken out to reduce size) your description is a little too abstract to make suggestions from.

If you want things to search for, the COUNTIF and SUMIF functions will both solve your first question.

The second question is normally achieved by restructuring your data and creating a pivot table, but this may not be worth it as your data is disparate across many sheets. Again, summary functions like countif/sumif and perhaps lookups (vlookup, hlookup, lookup, index, match) will probably be of use.

HTH

**bmgaspard** · 01-20-2009, 03:53 PM

I have attached the xls. All of the week sheets and playoff sheets is the league format, where I will input the results each night. The overall sheet shows me who is doing what on my team. The print sheet will be a report for each individual player each week. I have a drop down menu in there to select each players name and it will input their data in the appropriate cells (Trying to figure that out as well.) The list sheet will be the global data sheet with all the stats calculated and pulled from. I hope I have this setup right. One issue I am thinking I will have, correct me if I'm wrong, with weeks alternating Home and Away I couldn't pull stats from the same cells on each page, will that be a problem?

**Cheeky Charlie** · 01-21-2009, 06:11 AM

big... I'm going to have to come back to this later today when I have a little more time.

My toes are too small to tread on, anyone else who feels inclined.

CC

**bmgaspard** · 01-21-2009, 06:54 PM

Hey man,

Actually I am getting it, the sumif and countif works wonders. I am getting the major part down, just a few minor things I might need help with.

For instance, on the Print Sheet, I have a drop down menu with the players names using a range. I want to select a name with the drop down menu and have it populate the List sheet with all the data. Is this possible using a Data Validation list, or do I need to use something else or is it even possible? I can do it with more work, but looking for something easier.

But thanks again man, those two terms helped me out a bunch.

**bmgaspard** · 01-22-2009, 01:17 AM

One more question. If I want to display a players wins and losses in one cell as say 14-3 (14 wins with 3 losses) and the data comes from 2 different cells. How would I perform that without it being subtracted? I have attached what I have worked on so far, have some more work to do, but you will get the idea. Eyes were getting tired.

**Cheeky Charlie** · 01-22-2009, 05:27 AM

I'm not sure what you want to see, so I've answered two possible interpretations:

Option 1: Want to see net difference:
Put =<wins>-<losses> (i.e. pointing to cell references) in the cell, then applying custom number formatting thus: (select cell, Ctrl+1, number, custom, paste in)
# "W";# "L";"evens"
The help on custom number formats will explain how this works

Option 2: Want to see both numbers in ratio
Put =<wins>&":"&<losses>

HTH

PS As a general tip (as has been shown here - breaking your questions up a bit helps people to help you - I think we might all be a bit ADD...)

**bmgaspard** · 01-22-2009, 02:15 PM

I can't get the last one to work, maybe something I am wrong. In any of the Week pages, columns E & F 7-15 and J & K 7-15 totals each players wins and losses. I want to take the win column and the loss column for each player combine them into one cell displayed as Wins - Losses without any calculation.

Example
W L
3 1

Each in different cell, displays as 3 - 1 in a cell on the print page.

I tried the formatting you told me to do and it displays "evens" in the cell.

**bmgaspard** · 01-22-2009, 02:20 PM

Sorry, I wasn't pointing it to the page with the data, I figured that out, except it's only displaying #"W" value, not #"L".

**Cheeky Charlie** · 01-22-2009, 02:42 PM

You need the second thing - the first is very clever, but not neccessary - try this:
=A1&" - "&B1
Where A1 contains wins and B1 contains losses

HTH

PS the first option gives a net score - i.e. wins-losses, if there are more wins, it puts a W after, more losses it puts an L after, evens, it says "evens" - try it and see what happens when you change the win and loss totals - like I said, clever, but not what you wanted

**bmgaspard** · 01-23-2009, 12:28 AM

Works great. Just wish there was an easier way to do the other stuff, But oh well I am having fun with this, thanks a bunch. I have been using excel since office 95 or 98 somewhere around there, doing simple calculations. I have learned more about excel in the past couple days with your help than I have learned in the many years prior. Thanks again! I have several more cells to fill, so I'm sure I will be picking your brain before I am done.

**Magnerss** · 02-12-2013, 12:27 PM

Is there any way you still have this spreadsheet? I am trying to put one together for my dart team and I am ignorant as far as excel is concerned. If you could that would a great help! Thanks either way!

Originally Posted by bmgaspard

This is my scenario.

I am captain of a Dart Team in 2 different leagues. I have a excel spreadsheet that does some calculation for me (Wins, Losses, Percentage) when I manually enter the numbers. I have just created a workbook with multiple worksheets for each week of the season, including playoffs, and a sheet for overall and print. I want to be able to input the data for each week and have it auto calculate on the overall page and auto populate the print page. The overall page will have all the stats, wins singles games, wins doubles games and wins 3 man games, along with percentage in each category. I am pretty sure I can accomplish this task. The problems I am having is:

1. Adding wins and losses based on player number, I have one cell with a players number and I will put a 1 or 0 in that cell based on a win or loss. Off to the side I have the player roster with card numbers and a win column and loss column. I would like excel to see the 1 or 0 in the main column and add the appropriate to the roster column, calculating total for the night. Then adding that to the overall page.

2. The print page, I want a easy to read page that displays each players, wins and losses for each category described earlier and averages through each week displayed nicely to distribute each week. Would I have to export that page to word? I want to display wins and losses as 14-7 without it calculating it.

If someone can point me in the right direction that would be awesome. I can do simple stuff in excel, never had to do anything like this before, wanted to do it for a while and just didn't know where to start. What formulas to look up, not familiar enough with the nomenclature to look for the correct functions to accomplish this task, or if it's even possible.

**Jprovencher** · 10-16-2013, 06:40 AM

Originally Posted by Cheeky Charlie

You need the second thing - the first is very clever, but not neccessary - try this:
=A1&" - "&B1
Where A1 contains wins and B1 contains losses

HTH

PS the first option gives a net score - i.e. wins-losses, if there are more wins, it puts a W after, more losses it puts an L after, evens, it says "evens" - try it and see what happens when you change the win and loss totals - like I said, clever, but not what you wanted

I know this is old, but this can also be done using 'CONCATENATE'. In the target cell, =Concatenate(a1," - ", b1)