Hi there,
I am trying to pull together some simple analysis on performance in a game. Each week we mix up the teams and I have recorded who won, lost, drew etc and have scored people the same way that football teams are scored (3,1,0)
The analysis looks like below. What i want to do though is be able to put in a range of dates in two cells (eg 3/1/2013 to 14/3/2013) and the data will summarise for performance between those dates.
How would i go about doing this? I thought about numbering the 52 weeks 1 to 52 instead of the dates but im still not sure how to do it!
So you know what i have done:
Thanks
Pete
<TBODY>
</TBODY>
I am trying to pull together some simple analysis on performance in a game. Each week we mix up the teams and I have recorded who won, lost, drew etc and have scored people the same way that football teams are scored (3,1,0)
The analysis looks like below. What i want to do though is be able to put in a range of dates in two cells (eg 3/1/2013 to 14/3/2013) and the data will summarise for performance between those dates.
How would i go about doing this? I thought about numbering the 52 weeks 1 to 52 instead of the dates but im still not sure how to do it!
So you know what i have done:
- the number of number of draws and wins etc i have used countif.
- N= did not play
- w=win
- d=draw
- L=lost
Thanks
Pete
Quarter | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | Overall Totals | ||||||||
Date | 14-Jun | 21-Jun | 28-Jun | 05-Jul | 12-Jul | 19-Jul | 26-Jul | 02-Aug | 09-Aug | 16-Aug | 23-Aug | 30-Aug | 06-Sep | 13-Sep | 20-Sep | 27-Sep | 04-Oct | 11-Oct | 18-Oct | 25-Oct | 01-Nov | 08-Nov | 15-Nov | 22-Nov | 29-Nov | 06-Dec | 13-Dec | 20-Dec | 27-Dec | 03-Jan | 10-Jan | 17-Jan | 24-Jan | 31-Jan | 07-Feb | 14-Feb | 21-Feb | 28-Feb | 07-Mar | 14-Mar | 21-Mar | 28-Mar | 04-Apr | 11-Apr | 18-Apr | 25-Apr | 02-May | 09-May | 16-May | 23-May | 30-May | 06-Jun | Total wins | Total draws | Total losses | DNP | Total games | Should equal game week | Win % | Total points | Average points per game |
Ben | N | D | L | N | N | L | L | W | L | L | L | N | W | L | N | N | L | W | W | D | N | L | L | L | L | N | W | N | N | N | L | N | N | N | L | L | 5 | 2 | 15 | 14 | 22 | 36 | 22.73% | 17 | 0.77 | ||||||||||||||||
Chris | N | N | N | N | N | L | N | L | L | W | W | N | N | N | N | N | L | W | N | D | L | N | L | L | L | N | N | N | N | N | W | N | N | N | N | W | 5 | 1 | 8 | 22 | 14 | 36 | 35.71% | 16 | 1.14 | ||||||||||||||||
Sagar | N | D | L | W | N | N | L | W | W | N | L | L | W | N | D | N | N | N | L | D | W | L | W | W | L | N | N | N | N | N | N | N | N | W | W | W | 10 | 3 | 7 | 16 | 20 | 36 | 50.00% | 33 | 1.65 | ||||||||||||||||
Tom M | N | D | W | N | N | W | N | N | W | W | N | W | N | L | D | W | L | N | W | D | L | L | N | N | N | N | N | N | N | N | L | L | N | N | N | N | 7 | 3 | 6 | 20 | 16 | 36 | 43.75% | 24 | 1.50 |
<TBODY>
</TBODY>