Day Counter

[ori kobi]

hi i have a table with date and games and i want to count the days before each game so i know how many days rest they had between each game and also see which day is the hardest.

column 1 = date
column 2 = game
column 3 = should be a day counter (-3,-2,-1...,game=0)

i cant figure it out, any idea?

 

[oldbrewer]

[TABLE="width: 334"]
<colgroup><col><col><col><col span="2"></colgroup><tbody>[TR]
[TD]date[/TD]
[TD]game[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]01/07/2017[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]04/07/2017[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]10/07/2017[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]6[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]20/07/2017[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]10[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="colspan: 3"]is this what you mean ?[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[ori kobi]

[TABLE="width: 334"]
<tbody>[TR]
[TD]date[/TD]
[TD]game[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]01/07/2017[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]04/07/2017[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]10/07/2017[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]6[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]20/07/2017[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]10[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="colspan: 3"]is this what you mean ?[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

no,
Date Name game day counter
24/9/17 player 1 game 1 0
23/9/17 player 1 -1
24/9/17 player 2 game 1 0
22/9/17 player 1 -2


thanks

 

[Peter_SSs]

Is this it? If not, please provide a more representative set of sample data and expected results.

Book1
	A	B	C	D
1	Date	Name	game	day counter
2	24/09/2017	player 1	game 1	0
3	23/09/2017	player 1		-1
4	24/09/2017	player 2	game 1	0
5	22/09/2017	player 1		-2
Day counter

Cell Formulas
Range	Formula
D2	=IF(C2="",A2-A1,0)

 

[ori kobi]

[TABLE="width: 295"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD]Name[/TD]
[TD]Date[/TD]
[TD]Game[/TD]
[TD]Day Counter[/TD]
[/TR]
[TR]
[TD]Player 1[/TD]
[TD="align: right"]28/09/17[/TD]
[TD]Game 1[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Player 1[/TD]
[TD="align: right"]28/09/17[/TD]
[TD]Game 1[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Player 2[/TD]
[TD="align: right"]28/09/17[/TD]
[TD]Game 1[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Player 3[/TD]
[TD="align: right"]28/09/17[/TD]
[TD]Game 1[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Player 4[/TD]
[TD="align: right"]28/09/17[/TD]
[TD]Game 1[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Player 4[/TD]
[TD="align: right"]28/09/17[/TD]
[TD]Game 1[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Player 1[/TD]
[TD="align: right"]29/09/17[/TD]
[TD][/TD]
[TD="align: right"]-1[/TD]
[/TR]
[TR]
[TD]Player 2[/TD]
[TD="align: right"]29/09/17[/TD]
[TD][/TD]
[TD="align: right"]-1[/TD]
[/TR]
[TR]
[TD]Player 3[/TD]
[TD="align: right"]29/09/17[/TD]
[TD][/TD]
[TD="align: right"]-1[/TD]
[/TR]
[TR]
[TD]Player 4[/TD]
[TD="align: right"]29/09/17[/TD]
[TD][/TD]
[TD="align: right"]-1[/TD]
[/TR]
[TR]
[TD]Player 5[/TD]
[TD="align: right"]29/09/17[/TD]
[TD][/TD]
[TD="align: right"]-1[/TD]
[/TR]
[TR]
[TD]Player 6[/TD]
[TD="align: right"]29/09/17[/TD]
[TD][/TD]
[TD="align: right"]-1[/TD]
[/TR]
[TR]
[TD]Player 7[/TD]
[TD="align: right"]29/09/17[/TD]
[TD][/TD]
[TD="align: right"]-1[/TD]
[/TR]
[TR]
[TD]Player 8[/TD]
[TD="align: right"]29/09/17[/TD]
[TD][/TD]
[TD="align: right"]-1[/TD]
[/TR]
[TR]
[TD]Player 9[/TD]
[TD="align: right"]29/09/17[/TD]
[TD][/TD]
[TD="align: right"]-1[/TD]
[/TR]
[TR]
[TD]Player 10[/TD]
[TD="align: right"]29/09/17[/TD]
[TD][/TD]
[TD="align: right"]-1[/TD]
[/TR]
[TR]
[TD]Player 11[/TD]
[TD="align: right"]29/09/17[/TD]
[TD][/TD]
[TD="align: right"]-1[/TD]
[/TR]
[TR]
[TD]Player 12[/TD]
[TD="align: right"]29/09/17[/TD]
[TD][/TD]
[TD="align: right"]-1[/TD]
[/TR]
[TR]
[TD]Player 13[/TD]
[TD="align: right"]29/09/17[/TD]
[TD][/TD]
[TD="align: right"]-1[/TD]
[/TR]
[TR]
[TD]Player 14[/TD]
[TD="align: right"]29/09/17[/TD]
[TD][/TD]
[TD="align: right"]-1[/TD]
[/TR]
[TR]
[TD]Player 15[/TD]
[TD="align: right"]29/09/17[/TD]
[TD][/TD]
[TD="align: right"]-1[/TD]
[/TR]
[TR]
[TD]Player 16[/TD]
[TD="align: right"]29/09/17[/TD]
[TD][/TD]
[TD="align: right"]-1[/TD]
[/TR]
[TR]
[TD]Player 17[/TD]
[TD="align: right"]29/09/17[/TD]
[TD][/TD]
[TD="align: right"]-1[/TD]
[/TR]
[TR]
[TD]Player 1[/TD]
[TD="align: right"]30/09/17[/TD]
[TD][/TD]
[TD="align: right"]-1[/TD]
[/TR]
[TR]
[TD]Player 1[/TD]
[TD="align: right"]30/09/17[/TD]
[TD]Game 2[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Player 2[/TD]
[TD="align: right"]30/09/17[/TD]
[TD]Game 2[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Player 3[/TD]
[TD="align: right"]30/09/17[/TD]
[TD]Game 2[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Player 4[/TD]
[TD="align: right"]30/09/17[/TD]
[TD]Game 2[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Player 4[/TD]
[TD="align: right"]30/09/17[/TD]
[TD]Game 2[/TD]
[TD="align: right"]0[/TD]
[/TR]
</tbody>[/TABLE]

Is this it? If not, please provide a more representative set of sample data and expected results.

	A	B	C	D
Name	game
player 1	game 1
player 1
player 2	game 1
player 1

<colgroup><col style="width: 25pxpx"><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]
[TD="align: right"]Date[/TD]

[TD="align: right"]day counter[/TD]

[TD="align: center"]2[/TD]
[TD="align: right"]24/09/2017[/TD]

[TD="align: right"]0[/TD]

[TD="align: center"]3[/TD]
[TD="align: right"]23/09/2017[/TD]

[TD="align: right"][/TD]
[TD="align: right"]-1[/TD]

[TD="align: center"]4[/TD]
[TD="align: right"]24/09/2017[/TD]

[TD="align: right"]0[/TD]

[TD="align: center"]5[/TD]
[TD="align: right"]22/09/2017[/TD]

[TD="align: right"][/TD]
[TD="align: right"]-2[/TD]

</tbody>

Day counter​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]D2[/TH]
[TD="align: left"]=IF(C2="",A2-A1,0)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

 

[Peter_SSs]

So you have changed the order of the columns, you now have the dates ascending instead of descending & no further explanation so this is a guess.

=IF(C2="",IF(C3="",D3,D3-B2+B1),0)

 

[ori kobi]

thanks allot but its not doing what i need as some time i have the same player doing 2 training in the same date.

So you have changed the order of the columns, you now have the dates ascending instead of descending & no further explanation so this is a guess.

=IF(C2="",IF(C3="",D3,D3-B2+B1),0)

 

[Peter_SSs]

thanks allot but its not doing what i need as some time i have the same player doing 2 training in the same date.

Sample data with expected results and explanation of how those results are obtained manually?

 

[ori kobi]

Sample data with expected results and explanation of how those results are obtained manually?

every day i get data from the GPS system and load it to an excel table but some times the players have more then one training a day and so i get 2 records for the same date. as for the games, we play in different days of the week so there is no routine.
we have 26 player and not all train all the time.

 

[ori kobi]

[TABLE="width: 372"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD="align: left"]Name[/TD]
[TD="align: left"]Date[/TD]
[TD="align: left"]Game[/TD]
[TD="align: left"]Day Counter[/TD]
[/TR]
[TR]
[TD="align: left"]Player 8[/TD]
[TD="align: right"]23/09/17[/TD]
[TD][/TD]
[TD="align: right"]-1[/TD]
[/TR]
[TR]
[TD="align: left"]Player 17[/TD]
[TD="align: right"]23/09/17[/TD]
[TD][/TD]
[TD="align: right"]-1[/TD]
[/TR]
[TR]
[TD="align: left"]Player 17[/TD]
[TD="align: right"]24/09/17[/TD]
[TD="align: left"]Game 1[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: left"]Player 3[/TD]
[TD="align: right"]24/09/17[/TD]
[TD="align: left"]Game 1[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: left"]Player 3[/TD]
[TD="align: right"]24/09/17[/TD]
[TD="align: left"]Game 1[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: left"]Player 10[/TD]
[TD="align: right"]24/09/17[/TD]
[TD="align: left"]Game 1[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: left"]Player 10[/TD]
[TD="align: right"]24/09/17[/TD]
[TD="align: left"]Game 1[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: left"]Player 21[/TD]
[TD="align: right"]24/09/17[/TD]
[TD="align: left"]Game 1[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: left"]Player 21[/TD]
[TD="align: right"]24/09/17[/TD]
[TD="align: left"]Game 1[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: left"]Player 5[/TD]
[TD="align: right"]24/09/17[/TD]
[TD="align: left"]Game 1[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: left"]Player 5[/TD]
[TD="align: right"]24/09/17[/TD]
[TD="align: left"]Game 1[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: left"]Player 4[/TD]
[TD="align: right"]24/09/17[/TD]
[TD="align: left"]Game 1[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: left"]Player 4[/TD]
[TD="align: right"]24/09/17[/TD]
[TD="align: left"]Game 1[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: left"]Player 12[/TD]
[TD="align: right"]24/09/17[/TD]
[TD="align: left"]Game 1[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: left"]Player 12[/TD]
[TD="align: right"]24/09/17[/TD]
[TD="align: left"]Game 1[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: left"]Player 22[/TD]
[TD="align: right"]24/09/17[/TD]
[TD="align: left"]Game 1[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: left"]Player 22[/TD]
[TD="align: right"]24/09/17[/TD]
[TD="align: left"]Game 1[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: left"]Player 23[/TD]
[TD="align: right"]24/09/17[/TD]
[TD="align: left"]Game 1[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: left"]Player 13[/TD]
[TD="align: right"]24/09/17[/TD]
[TD="align: left"]Game 1[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: left"]Player 24[/TD]
[TD="align: right"]24/09/17[/TD]
[TD="align: left"]Game 1[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: left"]Player 9[/TD]
[TD="align: right"]24/09/17[/TD]
[TD="align: left"]Game 1[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: left"]Player 6[/TD]
[TD="align: right"]24/09/17[/TD]
[TD="align: left"]Game 1[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: left"]Player 6[/TD]
[TD="align: right"]24/09/17[/TD]
[TD="align: left"]Game 1[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: left"]Player 20[/TD]
[TD="align: right"]24/09/17[/TD]
[TD="align: left"]Game 1[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: left"]Player 7[/TD]
[TD="align: right"]24/09/17[/TD]
[TD="align: left"]Game 1[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: left"]Player 7[/TD]
[TD="align: right"]24/09/17[/TD]
[TD="align: left"]Game 1[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: left"]Player 19[/TD]
[TD="align: right"]26/09/17[/TD]
[TD][/TD]
[TD="align: right"]-2[/TD]
[/TR]
[TR]
[TD="align: left"]Player 3[/TD]
[TD="align: right"]26/09/17[/TD]
[TD][/TD]
[TD="align: right"]-2[/TD]
[/TR]
[TR]
[TD="align: left"]Player 7[/TD]
[TD="align: right"]26/09/17[/TD]
[TD][/TD]
[TD="align: right"]-2[/TD]
[/TR]
[TR]
[TD="align: left"]Player 6[/TD]
[TD="align: right"]26/09/17[/TD]
[TD][/TD]
[TD="align: right"]-2[/TD]
[/TR]
[TR]
[TD="align: left"]Player 21[/TD]
[TD="align: right"]26/09/17[/TD]
[TD][/TD]
[TD="align: right"]-2[/TD]
[/TR]
[TR]
[TD="align: left"]Player 5[/TD]
[TD="align: right"]26/09/17[/TD]
[TD][/TD]
[TD="align: right"]-2[/TD]
[/TR]
[TR]
[TD="align: left"]Player 4[/TD]
[TD="align: right"]26/09/17[/TD]
[TD][/TD]
[TD="align: right"]-2[/TD]
[/TR]
[TR]
[TD="align: left"]Player 12[/TD]
[TD="align: right"]26/09/17[/TD]
[TD][/TD]
[TD="align: right"]-2[/TD]
[/TR]
[TR]
[TD="align: left"]Player 22[/TD]
[TD="align: right"]26/09/17[/TD]
[TD][/TD]
[TD="align: right"]-2[/TD]
[/TR]
[TR]
[TD="align: left"]Player 17[/TD]
[TD="align: right"]26/09/17[/TD]
[TD][/TD]
[TD="align: right"]-2[/TD]
[/TR]
[TR]
[TD="align: left"]Player 23[/TD]
[TD="align: right"]26/09/17[/TD]
[TD][/TD]
[TD="align: right"]-2[/TD]
[/TR]
[TR]
[TD="align: left"]Player 20[/TD]
[TD="align: right"]26/09/17[/TD]
[TD][/TD]
[TD="align: right"]-2[/TD]
[/TR]
[TR]
[TD="align: left"]Player 9[/TD]
[TD="align: right"]26/09/17[/TD]
[TD][/TD]
[TD="align: right"]-2[/TD]
[/TR]
[TR]
[TD="align: left"]Player 15[/TD]
[TD="align: right"]26/09/17[/TD]
[TD][/TD]
[TD="align: right"]-2[/TD]
[/TR]
[TR]
[TD="align: left"]Player 13[/TD]
[TD="align: right"]26/09/17[/TD]
[TD][/TD]
[TD="align: right"]-2[/TD]
[/TR]
[TR]
[TD="align: left"]Player 16[/TD]
[TD="align: right"]26/09/17[/TD]
[TD][/TD]
[TD="align: right"]-2[/TD]
[/TR]
[TR]
[TD="align: left"]Player 24[/TD]
[TD="align: right"]26/09/17[/TD]
[TD][/TD]
[TD="align: right"]-2[/TD]
[/TR]
[TR]
[TD="align: left"]Player 8[/TD]
[TD="align: right"]26/09/17[/TD]
[TD][/TD]
[TD="align: right"]-2[/TD]
[/TR]
[TR]
[TD="align: left"]Player 19[/TD]
[TD="align: right"]27/09/17[/TD]
[TD][/TD]
[TD="align: right"]-1[/TD]
[/TR]
[TR]
[TD="align: left"]Player 23[/TD]
[TD="align: right"]27/09/17[/TD]
[TD][/TD]
[TD="align: right"]-1[/TD]
[/TR]
[TR]
[TD="align: left"]Player 20[/TD]
[TD="align: right"]27/09/17[/TD]
[TD][/TD]
[TD="align: right"]-1[/TD]
[/TR]
[TR]
[TD="align: left"]Player 10[/TD]
[TD="align: right"]27/09/17[/TD]
[TD][/TD]
[TD="align: right"]-1[/TD]
[/TR]
[TR]
[TD="align: left"]Player 6[/TD]
[TD="align: right"]27/09/17[/TD]
[TD][/TD]
[TD="align: right"]-1[/TD]
[/TR]
[TR]
[TD="align: left"]Player 21[/TD]
[TD="align: right"]27/09/17[/TD]
[TD][/TD]
[TD="align: right"]-1[/TD]
[/TR]
[TR]
[TD="align: left"]Player 9[/TD]
[TD="align: right"]27/09/17[/TD]
[TD][/TD]
[TD="align: right"]-1[/TD]
[/TR]
[TR]
[TD="align: left"]Player 15[/TD]
[TD="align: right"]27/09/17[/TD]
[TD][/TD]
[TD="align: right"]-1[/TD]
[/TR]
[TR]
[TD="align: left"]Player 5[/TD]
[TD="align: right"]27/09/17[/TD]
[TD][/TD]
[TD="align: right"]-1[/TD]
[/TR]
[TR]
[TD="align: left"]Player 4[/TD]
[TD="align: right"]27/09/17[/TD]
[TD][/TD]
[TD="align: right"]-1[/TD]
[/TR]
[TR]
[TD="align: left"]Player 12[/TD]
[TD="align: right"]27/09/17[/TD]
[TD][/TD]
[TD="align: right"]-1[/TD]
[/TR]
[TR]
[TD="align: left"]Player 24[/TD]
[TD="align: right"]27/09/17[/TD]
[TD][/TD]
[TD="align: right"]-1[/TD]
[/TR]
[TR]
[TD="align: left"]Player 8[/TD]
[TD="align: right"]27/09/17[/TD]
[TD][/TD]
[TD="align: right"]-1[/TD]
[/TR]
[TR]
[TD="align: left"]Player 17[/TD]
[TD="align: right"]27/09/17[/TD]
[TD][/TD]
[TD="align: right"]-1[/TD]
[/TR]
[TR]
[TD="align: left"]Player 3[/TD]
[TD="align: right"]27/09/17[/TD]
[TD][/TD]
[TD="align: right"]-1[/TD]
[/TR]
[TR]
[TD="align: left"]Player 7[/TD]
[TD="align: right"]27/09/17[/TD]
[TD][/TD]
[TD="align: right"]-1[/TD]
[/TR]
[TR]
[TD="align: left"]Player 16[/TD]
[TD="align: right"]27/09/17[/TD]
[TD][/TD]
[TD="align: right"]-1[/TD]
[/TR]
[TR]
[TD="align: left"]Player 22[/TD]
[TD="align: right"]27/09/17[/TD]
[TD][/TD]
[TD="align: right"]-1[/TD]
[/TR]
[TR]
[TD="align: left"]Player 8[/TD]
[TD="align: right"]28/09/17[/TD]
[TD="align: left"]Game 2[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: left"]Player 3[/TD]
[TD="align: right"]28/09/17[/TD]
[TD="align: left"]Game 2[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: left"]Player 3[/TD]
[TD="align: right"]28/09/17[/TD]
[TD="align: left"]Game 2[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: left"]Player 20[/TD]
[TD="align: right"]28/09/17[/TD]
[TD="align: left"]Game 2[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: left"]Player 20[/TD]
[TD="align: right"]28/09/17[/TD]
[TD="align: left"]Game 2[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: left"]Player 10[/TD]
[TD="align: right"]28/09/17[/TD]
[TD="align: left"]Game 2[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: left"]Player 10[/TD]
[TD="align: right"]28/09/17[/TD]
[TD="align: left"]Game 2[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: left"]Player 21[/TD]
[TD="align: right"]28/09/17[/TD]
[TD="align: left"]Game 2[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: left"]Player 21[/TD]
[TD="align: right"]28/09/17[/TD]
[TD="align: left"]Game 2[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: left"]Player 9[/TD]
[TD="align: right"]28/09/17[/TD]
[TD="align: left"]Game 2[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: left"]Player 9[/TD]
[TD="align: right"]28/09/17[/TD]
[TD="align: left"]Game 2[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: left"]Player 4[/TD]
[TD="align: right"]28/09/17[/TD]
[TD="align: left"]Game 2[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: left"]Player 4[/TD]
[TD="align: right"]28/09/17[/TD]
[TD="align: left"]Game 2[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: left"]Player 22[/TD]
[TD="align: right"]28/09/17[/TD]
[TD="align: left"]Game 2[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: left"]Player 22[/TD]
[TD="align: right"]28/09/17[/TD]
[TD="align: left"]Game 2[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: left"]Player 24[/TD]
[TD="align: right"]28/09/17[/TD]
[TD="align: left"]Game 2[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: left"]Player 12[/TD]
[TD="align: right"]28/09/17[/TD]
[TD="align: left"]Game 2[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: left"]Player 12[/TD]
[TD="align: right"]28/09/17[/TD]
[TD="align: left"]Game 2[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: left"]Player 6[/TD]
[TD="align: right"]28/09/17[/TD]
[TD="align: left"]Game 2[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: left"]Player 23[/TD]
[TD="align: right"]28/09/17[/TD]
[TD="align: left"]Game 2[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: left"]Player 7[/TD]
[TD="align: right"]28/09/17[/TD]
[TD="align: left"]Game 2[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: left"]Player 7[/TD]
[TD="align: right"]28/09/17[/TD]
[TD="align: left"]Game 2[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: left"]Player 19[/TD]
[TD="align: right"]29/09/17[/TD]
[TD][/TD]
[TD="align: right"]-3[/TD]
[/TR]
[TR]
[TD="align: left"]Player 3[/TD]
[TD="align: right"]29/09/17[/TD]
[TD][/TD]
[TD="align: right"]-3[/TD]
[/TR]
[TR]
[TD="align: left"]Player 7[/TD]
[TD="align: right"]29/09/17[/TD]
[TD][/TD]
[TD="align: right"]-3[/TD]
[/TR]
[TR]
[TD="align: left"]Player 23[/TD]
[TD="align: right"]29/09/17[/TD]
[TD][/TD]
[TD="align: right"]-3[/TD]
[/TR]
[TR]
[TD="align: left"]Player 20[/TD]
[TD="align: right"]29/09/17[/TD]
[TD][/TD]
[TD="align: right"]-3[/TD]
[/TR]
[TR]
[TD="align: left"]Player 21[/TD]
[TD="align: right"]29/09/17[/TD]
[TD][/TD]
[TD="align: right"]-3[/TD]
[/TR]
[TR]
[TD="align: left"]Player 4[/TD]
[TD="align: right"]29/09/17[/TD]
[TD][/TD]
[TD="align: right"]-3[/TD]
[/TR]
[TR]
[TD="align: left"]Player 12[/TD]
[TD="align: right"]29/09/17[/TD]
[TD][/TD]
[TD="align: right"]-3[/TD]
[/TR]
[TR]
[TD="align: left"]Player 22[/TD]
[TD="align: right"]29/09/17[/TD]
[TD][/TD]
[TD="align: right"]-3[/TD]
[/TR]
[TR]
[TD="align: left"]Player 6[/TD]
[TD="align: right"]29/09/17[/TD]
[TD][/TD]
[TD="align: right"]-3[/TD]
[/TR]
[TR]
[TD="align: left"]Player 15[/TD]
[TD="align: right"]29/09/17[/TD]
[TD][/TD]
[TD="align: right"]-3[/TD]
[/TR]
[TR]
[TD="align: left"]Player 5[/TD]
[TD="align: right"]29/09/17[/TD]
[TD][/TD]
[TD="align: right"]-3[/TD]
[/TR]
[TR]
[TD="align: left"]Player 13[/TD]
[TD="align: right"]29/09/17[/TD]
[TD][/TD]
[TD="align: right"]-3[/TD]
[/TR]
[TR]
[TD="align: left"]Player 16[/TD]
[TD="align: right"]29/09/17[/TD]
[TD][/TD]
[TD="align: right"]-3[/TD]
[/TR]
[TR]
[TD="align: left"]Player 24[/TD]
[TD="align: right"]29/09/17[/TD]
[TD][/TD]
[TD="align: right"]-3[/TD]
[/TR]
[TR]
[TD="align: left"]Player 8[/TD]
[TD="align: right"]29/09/17[/TD]
[TD][/TD]
[TD="align: right"]-3[/TD]
[/TR]
[TR]
[TD="align: left"]Player 17[/TD]
[TD="align: right"]29/09/17[/TD]
[TD][/TD]
[TD="align: right"]-3[/TD]
[/TR]
[TR]
[TD="align: left"]Player 19[/TD]
[TD="align: right"]01/10/17[/TD]
[TD][/TD]
[TD="align: right"]-1[/TD]
[/TR]
[TR]
[TD="align: left"]Player 3[/TD]
[TD="align: right"]01/10/17[/TD]
[TD][/TD]
[TD="align: right"]-1[/TD]
[/TR]
[TR]
[TD="align: left"]Player 7[/TD]
[TD="align: right"]01/10/17[/TD]
[TD][/TD]
[TD="align: right"]-1[/TD]
[/TR]
[TR]
[TD="align: left"]Player 23[/TD]
[TD="align: right"]01/10/17[/TD]
[TD][/TD]
[TD="align: right"]-1[/TD]
[/TR]
[TR]
[TD="align: left"]Player 10[/TD]
[TD="align: right"]01/10/17[/TD]
[TD][/TD]
[TD="align: right"]-1[/TD]
[/TR]
[TR]
[TD="align: left"]Player 21[/TD]
[TD="align: right"]01/10/17[/TD]
[TD][/TD]
[TD="align: right"]-1[/TD]
[/TR]
[TR]
[TD="align: left"]Player 9[/TD]
[TD="align: right"]01/10/17[/TD]
[TD][/TD]
[TD="align: right"]-1[/TD]
[/TR]
[TR]
[TD="align: left"]Player 5[/TD]
[TD="align: right"]01/10/17[/TD]
[TD][/TD]
[TD="align: right"]-1[/TD]
[/TR]
[TR]
[TD="align: left"]Player 4[/TD]
[TD="align: right"]01/10/17[/TD]
[TD][/TD]
[TD="align: right"]-1[/TD]
[/TR]
[TR]
[TD="align: left"]Player 12[/TD]
[TD="align: right"]01/10/17[/TD]
[TD][/TD]
[TD="align: right"]-1[/TD]
[/TR]
[TR]
[TD="align: left"]Player 13[/TD]
[TD="align: right"]01/10/17[/TD]
[TD][/TD]
[TD="align: right"]-1[/TD]
[/TR]
[TR]
[TD="align: left"]Player 16[/TD]
[TD="align: right"]01/10/17[/TD]
[TD][/TD]
[TD="align: right"]-1[/TD]
[/TR]
[TR]
[TD="align: left"]Player 24[/TD]
[TD="align: right"]01/10/17[/TD]
[TD][/TD]
[TD="align: right"]-1[/TD]
[/TR]
[TR]
[TD="align: left"]Player 22[/TD]
[TD="align: right"]01/10/17[/TD]
[TD][/TD]
[TD="align: right"]-1[/TD]
[/TR]
[TR]
[TD="align: left"]Player 8[/TD]
[TD="align: right"]01/10/17[/TD]
[TD][/TD]
[TD="align: right"]-1[/TD]
[/TR]
[TR]
[TD="align: left"]Player 17[/TD]
[TD="align: right"]01/10/17[/TD]
[TD][/TD]
[TD="align: right"]-1[/TD]
[/TR]
[TR]
[TD="align: left"]Player 6[/TD]
[TD="align: right"]01/10/17[/TD]
[TD][/TD]
[TD="align: right"]-1[/TD]
[/TR]
[TR]
[TD="align: left"]Player 15[/TD]
[TD="align: right"]01/10/17[/TD]
[TD][/TD]
[TD="align: right"]-1[/TD]
[/TR]
[TR]
[TD="align: left"]Player 17[/TD]
[TD="align: right"]01/10/17[/TD]
[TD][/TD]
[TD="align: right"]-1[/TD]
[/TR]
[TR]
[TD="align: left"]Player 8[/TD]
[TD="align: right"]01/10/17[/TD]
[TD][/TD]
[TD="align: right"]-1[/TD]
[/TR]
[TR]
[TD="align: left"]Player 22[/TD]
[TD="align: right"]01/10/17[/TD]
[TD][/TD]
[TD="align: right"]-1[/TD]
[/TR]
[TR]
[TD="align: left"]Player 22[/TD]
[TD="align: right"]01/10/17[/TD]
[TD][/TD]
[TD="align: right"]-1[/TD]
[/TR]
[TR]
[TD="align: left"]Player 3[/TD]
[TD="align: right"]01/10/17[/TD]
[TD][/TD]
[TD="align: right"]-1[/TD]
[/TR]
[TR]
[TD="align: left"]Player 3[/TD]
[TD="align: right"]01/10/17[/TD]
[TD][/TD]
[TD="align: right"]-1[/TD]
[/TR]
[TR]
[TD="align: left"]Player 10[/TD]
[TD="align: right"]01/10/17[/TD]
[TD][/TD]
[TD="align: right"]-1[/TD]
[/TR]
[TR]
[TD="align: left"]Player 10[/TD]
[TD="align: right"]01/10/17[/TD]
[TD][/TD]
[TD="align: right"]-1[/TD]
[/TR]
[TR]
[TD="align: left"]Player 6[/TD]
[TD="align: right"]01/10/17[/TD]
[TD][/TD]
[TD="align: right"]-1[/TD]
[/TR]
[TR]
[TD="align: left"]Player 6[/TD]
[TD="align: right"]01/10/17[/TD]
[TD][/TD]
[TD="align: right"]-1[/TD]
[/TR]
[TR]
[TD="align: left"]Player 21[/TD]
[TD="align: right"]01/10/17[/TD]
[TD][/TD]
[TD="align: right"]-1[/TD]
[/TR]
[TR]
[TD="align: left"]Player 21[/TD]
[TD="align: right"]01/10/17[/TD]
[TD][/TD]
[TD="align: right"]-1[/TD]
[/TR]
[TR]
[TD="align: left"]Player 5[/TD]
[TD="align: right"]01/10/17[/TD]
[TD][/TD]
[TD="align: right"]-1[/TD]
[/TR]
[TR]
[TD="align: left"]Player 5[/TD]
[TD="align: right"]01/10/17[/TD]
[TD][/TD]
[TD="align: right"]-1[/TD]
[/TR]
[TR]
[TD="align: left"]Player 4[/TD]
[TD="align: right"]01/10/17[/TD]
[TD][/TD]
[TD="align: right"]-1[/TD]
[/TR]
[TR]
[TD="align: left"]Player 4[/TD]
[TD="align: right"]01/10/17[/TD]
[TD][/TD]
[TD="align: right"]-1[/TD]
[/TR]
[TR]
[TD="align: left"]Player 13[/TD]
[TD="align: right"]01/10/17[/TD]
[TD][/TD]
[TD="align: right"]-1[/TD]
[/TR]
[TR]
[TD="align: left"]Player 13[/TD]
[TD="align: right"]01/10/17[/TD]
[TD][/TD]
[TD="align: right"]-1[/TD]
[/TR]
[TR]
[TD="align: left"]Player 9[/TD]
[TD="align: right"]01/10/17[/TD]
[TD][/TD]
[TD="align: right"]-1[/TD]
[/TR]
[TR]
[TD="align: left"]Player 9[/TD]
[TD="align: right"]01/10/17[/TD]
[TD][/TD]
[TD="align: right"]-1[/TD]
[/TR]
[TR]
[TD="align: left"]Player 23[/TD]
[TD="align: right"]01/10/17[/TD]
[TD][/TD]
[TD="align: right"]-1[/TD]
[/TR]
[TR]
[TD="align: left"]Player 7[/TD]
[TD="align: right"]01/10/17[/TD]
[TD][/TD]
[TD="align: right"]-1[/TD]
[/TR]
[TR]
[TD="align: left"]Player 7[/TD]
[TD="align: right"]01/10/17[/TD]
[TD][/TD]
[TD="align: right"]-1[/TD]
[/TR]
[TR]
[TD="align: left"]Player 23[/TD]
[TD="align: right"]02/10/17[/TD]
[TD="align: left"]Game 3[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: left"]Player 15[/TD]
[TD="align: right"]02/10/17[/TD]
[TD="align: left"]Game 3[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: left"]Player 16[/TD]
[TD="align: right"]02/10/17[/TD]
[TD="align: left"]Game 3[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: left"]Player 24[/TD]
[TD="align: right"]02/10/17[/TD]
[TD="align: left"]Game 3[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: left"]Player 8[/TD]
[TD="align: right"]02/10/17[/TD]
[TD="align: left"]Game 3[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: left"]Player 17[/TD]
[TD="align: right"]02/10/17[/TD]
[TD="align: left"]Game 3[/TD]
[TD="align: right"]0[/TD]
[/TR]
</tbody>[/TABLE]