Counting Wins And Losses

Daviboy30 · Nov 7, 2021

I'm running a scoresheet for my league and I need to track each player's wins and losses record throughout the season, including the previous season, so that I can assign a proper player ranking. If a player wins or loses 7 out of 10 matches his ranking goes up or down, depending on how he (or she) does. Players often do not play every week, but I still need to track their wins and losses through multiple seasons. More often than not player ranking don't change because they don't meet the 7 out of ten threshold, but when they do, I want the spreadsheet to automatically post the new ranking.

In the attached Mini-sheet example Joe's ranking remained the same because over a period of 13 weeks he played 10 matches, but did not meet the 7 out of 10 wins or losses threshold. Meanwhile Jack's ranking went from 6 up to 7 because over a period of 15 weeks he played 10 matches and won 7 of them. In Mary's example, her ranking went down because over a period of 14 weeks she played 10 matches and lost 7 times. If a player rank goes up then the counting of wins and losses starts fresh.

The problem I'm having is how to automatically track a player's last 10 matches whether he plays the matches in 10 weeks, 10 months or even 10 years.

IFTestBook2.xlsx

A

B

C

D

E

F

G

H

I

J

K

L

M

N

O

P

Q

R

S

T

U

V

W

3

Player

Current Rank

Current Wins

Current Losses

New Rank

1/1

1/8

1/15

1/22

1/29

2/5

2/12

2/19

2/26

3/5

3/12

3/19

3/26

4/2

4/9

4/16

4/23

4/30

4

Joe

4

6

5

4

W

L

W

L

W

L

W

L

5

Jack

6

7

3

7

W

L

W

L

W

L

W

6

Mary

3

7

2

L

W

L

W

L

W

L

Sheet1

Cell Formulas
Range	Formula
C4	C4	=COUNTIF(K4:W4,"W")
D4:D5	D4	=COUNTIF(H4:W4,"L")
E4:E6	E4	=IF(C4>6, B4+1, IF(D4>6, B4-1, IF(B4=2, 2, IF(B4=3, 3, IF(B4=4, 4, IF(B4=5, 5, IF(B4=6, 6, IF(B4=7, 7))))))))
C5	C5	=COUNTIF(I5:W5,"W")
C6	C6	=COUNTIF(J6:W6,"W")
D6	D6	=COUNTIF(J6:W6,"L")

Peter_SSs · Nov 13, 2021

Daviboy30 said:
Would something like this work for you?

It may, but ... (this is the third time that I have posted this

)

Peter_SSs said:
unless we can resolve the process for people with a single row there is not much use worrying about the 2-row scenario at this stage.

So, could you please revisit my last post and go from (near the bottom of my post)

Peter_SSs said:
.. back to the error you reported in this line of code

Daviboy30 · Nov 14, 2021

I created a new sheet with all the Wins and Losses data entered on one row for each player. When I typed a W in the first column under Joe (G5), I still get the error message reported before on the following line:

a = Split(" " & Join(Application.Index(Range(Cells(r, LastReset + FirstDataCol), Cells(r, lc)).Value, 1, 0)))

The following are the values you requested on post #29:
r = 5
LastReset = 0
FirstDataCol = 7
lc = 7

IFTestBook6-Peter.xlsm

A

B

C

D

E

F

G

H

I

J

K

L

M

N

O

P

Q

R

S

T

U

V

W

X

Y

Z

AA

AB

AC

AD

AE

AF

AG

AH

AI

AJ

AK

AL

AM

AN

AO

AP

AQ

AR

AS

AT

AU

AV

AW

AX

AY

AZ

BA

BB

BC

BD

BE

BF

BG

BH

BI

BJ

BK

BL

BM

BN

BO

BP

BQ

BR

BS

BT

BU

BV

BW

BX

BY

BZ

CA

CB

CC

CD

CE

CF

CG

CH

CI

CJ

CK

CL

CM

CN

CO

CP

CQ

CR

CS

CT

CU

CV

CW

CX

CY

CZ

DA

DB

DC

DD

DE

DF

DG

DH

DI

DJ

DK

DL

DM

DN

DO

DP

DQ

DR

DS

DT

DU

DV

DW

DX

DY

DZ

EA

EB

EC

ED

EE

EF

EG

EH

EI

EJ

EK

EL

EM

EN

EO

EP

EQ

ER

ES

ET

EU

EV

EW

EX

EY

EZ

FA

FB

FC

FD

FE

FF

FG

FH

FI

FJ

FK

FL

FM

FN

FO

FP

FQ

FR

FS

FT

FU

FV

1

2021

2

July

August

September

3

Player

Current Rank

Current Wins

Current Losses

New Rank

Last Reset

Tu

We

Th

Fr

Sa

Su

Mo

Tu

We

Th

Fr

Sa

Su

Mo

Tu

We

Th

Fr

Sa

Su

Mo

Tu

We

Th

Fr

Sa

Su

Mo

Tu

We

Th

Fr

Sa

Su

Mo

Tu

We

Th

Fr

Sa

Su

Mo

Tu

We

Th

Fr

Sa

Su

Mo

Tu

We

Th

Fr

Sa

Su

Mo

Tu

We

Th

Fr

Sa

Su

Mo

Tu

We

Th

Fr

Sa

Su

Mo

Tu

We

Th

Fr

Sa

Su

Mo

Tu

We

Th

Mo

Tu

We

Th

Fr

Sa

Su

Mo

Tu

We

Th

Fr

4

First Name

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

19

20

21

22

23

24

25

26

27

28

29

30

5

Joe

6

1

0

W

6

Jon

4

0

7

Rich

2

0

Sheet1

Cell Formulas
Range	Formula
C5:C7	C5	=LEN(RIGHT(CONCAT(G5:AVY5),10))-LEN(SUBSTITUTE(RIGHT(CONCAT(G5:AVY5),10),"W",""))
D5:D7	D5	=LEN(RIGHT(CONCAT(G5:AVZ5),10))-C5

Peter_SSs · Nov 14, 2021

Daviboy30 said:
I created a new sheet with all the Wins and Losses data entered on one row for each player. When I typed a W in the first column under Joe (G5), I still get the error message reported before on the following line:

a = Split(" " & Join(Application.Index(Range(Cells(r, LastReset + FirstDataCol), Cells(r, lc)).Value, 1, 0)))

The following are the values you requested on post #29:
r = 5
LastReset = 0
FirstDataCol = 7
lc = 7

Thank you for those details.
I do get that error if I delete a single entry in G5 but not when I enter it. I don't see that it should be the case but perhaps it could relate to you using a Mac.
Can you try the version below but please try it with this single-result-per-week layout that I have shown below* as I have not attempted to adapt to multiple results yet.
I know that you have said 2 results per day is a must, but one step at a time for this development please!

* You can copy this layout to a blank worksheet by clicking this icon

at the top left of my mini-sheet below, select cell A1 in a blank worksheet and Paste.

Also, please do not enter those formulas in columns C & D. As I have stated before: They will not work to correctly give you current wins and losses.

Daviboy30_1.xlsm

A

B

C

D

E

F

G

H

I

J

K

L

M

N

O

P

Q

R

S

T

U

V

W

X

Y

Z

1

2

3

Player

Current Rank

Current Wins

Current Losses

New Rank

Last Reset

4

First Name

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

5

Joe

6

Jon

7

Rich

P32 (2)

New code to try in this worksheet's module.

VBA Code:

Private Sub Worksheet_Change(ByVal Target As Range)
  Dim a As Variant
  Dim W As Long, L As Long, K As Long, i As Long, j As Long, r As Long, wk As Long, lc
  Dim OldRank As Long, NewRank As Long, UpDown As Long, LastReset As Long
 
  Const FirstDataRow As Long = 5
  Const FirstDataCol As Long = 7
  Const CurrentRankCol As Long = 2
 
  If Target.CountLarge = 1 And Target.Column >= FirstDataCol And Target.Row >= FirstDataRow Then
    r = Target.Row
    LastReset = Cells(r, CurrentRankCol + 4).Value
    wk = Target.Column - FirstDataCol + 1
    If wk > LastReset Then
    OldRank = Cells(r, CurrentRankCol).Value
    lc = Cells(r, Columns.Count).End(xlToLeft).Column + 1
    If lc <= Target.Column Then lc = Target.Column + 1
    a = Split(" " & Join(Application.Index(Range(Cells(r, LastReset + FirstDataCol), Cells(r, lc)).Value, 1, 0)))
      For i = 1 To UBound(a)
        Do
          If Len(a(i + j)) > 0 Then
            If UCase(a(i + j)) = "W" Then
              W = W + 1
            Else
              L = L + 1
            End If
            K = K + 1
            If K = 10 Then
              If W > 6 Then
                UpDown = UpDown + 1
                LastReset = LastReset + i + j
                i = i + j
              ElseIf L > 6 Then
                UpDown = UpDown - 1
                LastReset = LastReset + i + j
                i = i + j
              End If
              Exit Do
            End If
          End If
          j = j + 1
        Loop Until i + j = UBound(a) + 1 Or K = 10
        If i + j = UBound(a) + 1 Then
          i = UBound(a)
        Else
          W = 0
          L = 0
          K = 0
          j = 0
        End If
      Next i
      NewRank = Cells(r, CurrentRankCol).Value + UpDown
      If NewRank < 2 Then NewRank = 2
      If NewRank > 7 Then NewRank = 7
      Application.EnableEvents = False
      Cells(r, CurrentRankCol + 1).Resize(, 4).Value = Array(W, L, NewRank, LastReset)
      If NewRank <> OldRank Then MsgBox "New Rank for " & Range("A" & r) & " will now be moved to Current Rank and New Rank cell cleared"
      Cells(r, CurrentRankCol).Value = NewRank
      Cells(r, CurrentRankCol + 3).ClearContents
      Application.EnableEvents = True
    End If
  End If
End Sub

Daviboy30 · Nov 15, 2021

I think it's starting to work! The ranks changed when they were supposed to and the counting was reset back to 0. Great!

I didn't merge any cells in Rows 1, 2 and 3 to indicate Years, Months and Days, but eventually that will need to be done.
Now I'm going throw in a wrinkle: what if the scorer makes an error in filling in Ws or Ls and has erase a few weeks of scores. Will the rank automatically go back to the previous rank, or would you have to manually change the rank? (I didn't test this out for fear of blowing everything up.)
Now I'm going to get greedy: Can you code it so that when a player moves up or down, the date (cell) is color-coded to indicate that this is the date that he or she moved?

IFTestBook7-Peter.xlsm

A

B

C

D

E

F

G

H

I

J

K

L

M

N

O

P

Q

R

S

T

U

V

W

X

Y

Z

1

2

3

Player

Current Rank

Current Wins

Current Losses

New Rank

Last Reset

4

First Name

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

5

Joe

3

0

15

W

L

W

L

W

6

Jon

3

0

11

L

W

7

Rich

Sheet1

Peter_SSs · Nov 16, 2021

Daviboy30 said:
I didn't merge any cells in Rows 1, 2 and 3 to indicate Years, Months and Days, but eventually that will need to be done.

Doing that sort of thing in rows above row 4 should not be a problem

Daviboy30 said:
Now I'm going throw in a wrinkle: what if the scorer makes an error in filling in Ws or Ls and has erase a few weeks of scores. Will the rank automatically go back to the previous rank, or would you have to manually change the rank?

With the current code the rank will not automatically go back to what is was. After all, there is no direct record of what the previous values in the row were. Further, erasing or changing earlier data could also affect current wins & losses and also Last Reset. This is partly why I asked earlier:

Peter_SSs said:
** Does every player start this sheet with no current rank (or I guess that is the min rank of 2)? I am asking because this whole process (vba or formulas) may be simpler if we ignored that 'Last Reset' and just calculated all the players changes right from the start each time and published their current rank and current wins/losses.

If anything was deleted or changed anywhere before the last entry in the row, would it be feasible to effectively erase all calculations for that player and recalculate everything right from FirstDataCol after assuming that the player's initial rank was the minimum of 2 to start with?

Daviboy30 said:
Now I'm going to get greedy: Can you code it so that when a player moves up or down, the date (cell) is color-coded to indicate that this is the date that he or she moved?

Highlighting the date cell does not make sense to me. The date cell is in row 3 or 4 isn't it? If a date cell was highlighted, how would you know which player it related to?

I have not tried to put it into effect yet but I am thinking that when a player plays more than once per day, the best way of recording to assist the result calculation may be to simply enter both values in the cell like in H5 and K5 below. Would that be acceptable from your point of view? .. or possibly the two values could be entered with a comma or space delimiter but still in the same cell?

Also note that within the next 24 hours, I will be going away for a week or 10 days and may not have access to the forum or Excel so if I don't respond in that time you'll understand that I have not just abandoned the thread.

Daviboy30_1.xlsm

A

G

H

I

J

K

L

4

First Name

1

2

3

4

5

6

5

Joe

W

LW

W

WW

W

P32 (2)

Daviboy30 · Nov 16, 2021

Peter_SSs said:
Highlighting the date cell does not make sense to me. The date cell is in row 3 or 4 isn't it? If a date cell was highlighted, how would you know which player it related to?

Whenever a player goes up or down you currently get message that his rank is changing. Can you also code it so that you fill the cell where the update has occurred with a color? This what I was thinking:

PlayerRankingSystem_211115.xlsm

A

B

C

D

E

F

G

H

I

J

K

L

M

N

O

P

Q

R

S

T

U

V

W

X

Y

Z

AA

AB

AC

AD

AE

AF

AG

AH

AI

AJ

AK

AL

AM

AN

AO

AP

AQ

AR

AS

AT

AU

AV

AW

AX

AY

AZ

BA

BB

BC

BD

BE

BF

BG

BH

BI

BJ

BK

BL

BM

BN

BO

BP

BQ

BR

BS

BT

BU

BV

BW

BX

BY

BZ

CA

CB

CC

CD

CE

CF

CG

CH

CI

CJ

CK

CL

CM

CN

CO

CP

CQ

CR

CS

CT

CU

CV

CW

CX

CY

CZ

DA

DB

DC

DD

DE

DF

DG

DH

DI

DJ

DK

DL

DM

DN

DO

DP

DQ

DR

DS

DT

DU

DV

DW

DX

DY

DZ

EA

EB

EC

ED

EE

EF

EG

EH

EI

EJ

EK

EL

EM

EN

EO

EP

EQ

ER

ES

ET

EU

EV

EW

EX

EY

EZ

FA

FB

FC

FD

FE

FF

FG

FH

FI

FJ

FK

FL

FM

FN

FO

FP

FQ

FR

FS

FT

FU

FV

FW

FX

FY

FZ

GA

GB

GC

GD

GE

GF

GG

GH

GI

GJ

GK

GL

GM

GN

GO

GP

GQ

GR

GS

GT

GU

GV

GW

GX

GY

GZ

HA

HB

HC

HD

HE

HF

HG

HH

HI

HJ

HK

HL

HM

HN

HO

HP

HQ

HR

HS

HT

HU

HV

HW

HX

HY

HZ

IA

IB

IC

ID

IE

IF

IG

IH

II

IJ

IK

IL

IM

IN

IO

IP

IQ

IR

IS

IT

IU

IV

IW

IX

IY

IZ

JA

JB

JC

JD

JE

JF

JG

JH

JI

JJ

JK

JL

JM

JN

JO

JP

JQ

JR

JS

JT

JU

JV

JW

JX

JY

JZ

KA

KB

KC

KD

KE

KF

KG

KH

KI

KJ

KK

KL

KM

KN

KO

KP

KQ

KR

KS

KT

KU

KV

KW

KX

KY

KZ

LA

LB

LC

LD

LE

LF

LG

LH

LI

LJ

LK

LL

LM

LN

LO

LP

LQ

LR

LS

LT

LU

LV

LW

LX

LY

LZ

MA

MB

MC

MD

ME

MF

MG

MH

MI

MJ

MK

ML

MM

MN

MO

MP

MQ

MR

MS

MT

MU

MV

MW

MX

MY

MZ

NA

NB

NC

ND

NE

NF

NG

NH

NI

NJ

1

2021

2

July

August

September

October

November

December

3

Player Name

Current Rank

Current Wins

Current Losses

New Rank

Last Reset

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

4

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

54

55

56

57

58

59

60

61

62

63

64

65

66

67

68

69

70

71

72

73

74

75

76

77

78

79

80

81

82

83

84

85

86

87

88

89

90

91

92

93

94

95

96

97

98

99

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

189

190

191

192

193

194

195

196

197

198

199

200

201

202

203

204

205

206

207

208

209

210

211

212

213

214

215

216

217

218

219

220

221

222

223

224

225

226

227

228

229

230

231

232

233

234

235

236

237

238

239

240

241

242

243

244

245

246

247

248

249

250

251

252

253

254

255

256

257

258

259

260

261

262

263

264

265

266

267

268

269

270

271

272

273

274

275

276

277

278

279

280

281

282

283

284

285

286

287

288

289

290

291

292

293

294

295

296

297

298

299

300

301

302

303

304

305

306

307

308

309

310

311

312

313

314

315

316

317

318

319

320

321

322

323

324

325

326

327

328

329

330

331

332

333

334

335

336

337

338

339

340

341

342

343

344

345

346

347

348

349

350

351

352

353

354

355

356

357

358

359

360

361

362

363

364

365

366

367

368

5

Joe

2

3

2

31

W

L

W

L

W

L

W

L

W

L

W

L

W

L

W

L

W

L

W

L

6

Jon

5

3

1

29

W

L

W

L

W

L

W

L

W

L

W

L

W

L

W

7

Rich

3

0

41

L

W

L

W

L

W

L

W

Sheet1

Peter_SSs · Nov 16, 2021

Daviboy30 said:
Whenever a player goes up or down you currently get message that his rank is changing. Can you also code it so that you fill the cell where the update has occurred with a color? This what I was thinking:

OK, I will think about that - probably should be doable.

What about my other questions?

Peter_SSs said:
If anything was deleted or changed anywhere before the last entry in the row, would it be feasible to effectively erase all calculations for that player and recalculate everything right from FirstDataCol after assuming that the player's initial rank was the minimum of 2 to start with?

Peter_SSs said:
when a player plays more than once per day, the best way of recording to assist the result calculation may be to simply enter both values in the cell like in H5 and K5 below. Would that be acceptable from your point of view? .. or possibly the two values could be entered with a comma or space delimiter but still in the same cell?

Daviboy30 · Nov 16, 2021

Peter_SSs said:
I have not tried to put it into effect yet but I am thinking that when a player plays more than once per day, the best way of recording to assist the result calculation may be to simply enter both values in the cell like in H5 and K5 below. Would that be acceptable from your point of view? .. or possibly the two values could be entered with a comma or space delimiter but still in the same cell?

I'm not crazy about putting the W and L values in the same cell. Attached is a screen capture of what I'm envisioning now. Row 1 is for the Years, Row 2 is for the Months, Row 3 is for the Days of the Month, and Row 4 is counting the Cells. In this scenario for each player, there are two cells available each day, whether he plays two matches or not.

Peter_SSs said:
OK, I will think about that - probably should be doable.

What about my other questions?

Peter_SSs said:
If anything was deleted or changed anywhere before the last entry in the row, would it be feasible to effectively erase all calculations for that player and recalculate everything right from FirstDataCol after assuming that the player's initial rank was the minimum of 2 to start with?

Are you asking if a player's row gets messed up, for whatever reason, do we have backup? We have score sheets for each day's matches, that are filled in with pencil and paper. I've been photographing and collecting these score sheets on my iPhone. Not the best solution, but it works. I'm hoping we would not have to start from the FirstDataCol, if things got messed up. Starting from the last known "good" entry, we should be able to clear the inputs for the Current Wins and Losses, reset the Current Rank and Last Reset to the proper count, then rebuild from there. (Does that answer your question?)

Peter_SSs · Nov 24, 2021

Daviboy30 said:
Attached is a screen capture of what I'm envisioning now.

That layout should be fine.

Daviboy30 said:
Are you asking if a player's row gets messed up, for whatever reason, do we have backup?

No, that is not what I am asking.

I'll try explaining again. Take your example of Joe in your post 38 screen shot (better to use XL2BB though so I can easily copy to test).
As you have shown, his last reset was in cell 31 with a current win/loss count of 3/2. Looking through Joe's row I can calculate that he moved up 1 rank at cell 19 and down 1 rank at cell 31, leaving him on a rank of 2.

What I getting at is, let's suppose we realise that the first 'L' in cell 3 (really cell I5) should have been a 'W'. Can I just say: "OK, Joe is starting again with a default rank of 2 and with that change in cell I5 Joe would have had a rank increase of 1 in cell 12, another rank increase of 1 in cell 23 and a rank decrease of 1 in cell 37 so that would leave him with a rank of 3 with last reset in cell 37 and a current win/loss count of 0/1?

Daviboy30 · Nov 24, 2021

I think what you are saying is: if an error occurs, you want to manually reset his Current Rank, Current Wins and Current Losses to what they should be instead of making the computer recalculate all the Ws and Ls in order to reset his ranking to the proper rank. If this is what you mean, then yes I think I would prefer that.
But currently with the existing VBA code (I think), the counting gets messed up. They don't seem to start counting again if you erase Ws and Ls and start entering new Ws and Ls. I haven't fully tested this. The code needs to accept whatever the numbers are in the Current Rank, Current Wins and Current Losses columns and build from there. Does that make sense?

Below is the XL2BB minisheet from my spreadsheet with your latest VBA code that I used to create the screen capture in #38:

PlayerRankingSystem_211115.xlsm
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z AA AB AC AD AE AF AG AH AI AJ AK AL AM AN AO AP AQ AR AS AT AU AV AW AX AY AZ BA BB BC BD BE BF BG BH BI BJ BK BL BM BN BO BP BQ BR BS BT BU BV BW BX BY BZ CA CB CC CD CE CF CG CH CI CJ CK CL CM CN CO CP CQ CR CS CT CU CV CW CX CY CZ DA DB DC DD DE DF DG DH DI DJ DK DL DM DN DO DP DQ DR DS DT DU DV DW DX DY DZ EA EB EC ED EE EF EG EH EI EJ EK EL EM EN EO EP EQ ER ES ET EU EV EW EX EY EZ FA FB FC FD FE FF FG FH FI FJ FK FL FM FN FO FP FQ FR FS FT FU FV FW FX FY FZ GA GB GC GD GE GF GG GH GI GJ GK GL GM GN GO GP GQ GR GS GT GU GV GW GX GY GZ HA HB HC HD HE HF HG HH HI HJ HK HL HM HN HO HP HQ HR HS HT HU HV HW HX HY HZ IA IB IC ID IE IF IG IH II IJ IK IL IM IN IO IP IQ IR IS IT IU IV IW IX IY IZ JA JB JC JD JE JF JG JH JI JJ JK JL JM JN JO JP JQ JR JS JT JU JV JW JX JY JZ KA KB KC KD KE KF KG KH KI KJ KK KL KM KN KO KP KQ KR KS KT KU KV KW KX KY KZ LA LB LC LD LE LF LG LH LI LJ LK LL LM LN LO LP LQ LR LS LT LU LV LW LX LY LZ MA MB MC MD ME MF MG MH MI MJ MK ML MM MN MO MP MQ MR MS MT MU MV MW MX MY MZ NA NB NC ND NE NF NG NH NI NJ
1 2021
2 July August September October November December
3 Player Name Current Rank Current Wins Current Losses New Rank Last Reset 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31
4 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 346 347 348 349 350 351 352 353 354 355 356 357 358 359 360 361 362 363 364 365 366 367 368
5 Joe 2 3 2 31 W W L W L W L W L W L W L W W W W L W L W L L L L L L W W W L L
6 Jon 5 3 1 29 W W W L W L W W W L L W L W L W L L L L W W L W
7 Rich 3 0 0 41 L L L W L W L L L L W W W W W W L W W W
Sheet1

Counting Wins And Losses

Daviboy30

New Member

Attachments

Peter_SSs

MrExcel MVP, Moderator

Excel Facts

Daviboy30

New Member

Peter_SSs

MrExcel MVP, Moderator

Daviboy30

New Member

Peter_SSs

MrExcel MVP, Moderator

Daviboy30

New Member

Peter_SSs

MrExcel MVP, Moderator

Daviboy30

New Member

Attachments

Peter_SSs

MrExcel MVP, Moderator

Daviboy30

New Member

Similar threads

Forum statistics

Share this page

Counting Wins And Losses

New Member

Attachments

MrExcel MVP, Moderator

Excel Facts

New Member

MrExcel MVP, Moderator

New Member

MrExcel MVP, Moderator

New Member

MrExcel MVP, Moderator

New Member

Attachments

MrExcel MVP, Moderator

New Member

Similar threads

Forum statistics

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock