Boys U12-U8 Planet Cup 2022

1

Rank

Boys Planet Cup 2022 (Unofficial Standings)

Spirit 1-8

Lax 1-22

Powder Ridge

PAJC 3-6

PC Final

Spirit 1-9

Lax 1-23

GP 2-5

GP 2-6

PAJC 3-6

PC Final

OVERALL

SL

GS

Overall Tiebreak

OVERALL

SL Tiebreak

SL

GS Tiebreak

GS

2

OA tiebreak

SL tiebreak

GS tiebreak

Overall

SL

GS

USSA #

Last Name

First Name

Class

Club

SL1

SL2

SL1

SL2

SL3

SL 1

SL2

GS1

GS2

GS1

GS2

GS1

GS2

11 of 18

Rank

1sts

2nds

3rds

5 of 9

Rank

1sts

2nds

3rds

5 of 9

Rank

1sts

2nds

3rds

Winner .5

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

Winner .5

1

2

3

4

5

6

7

8

9

Winner .5

1

2

3

4

5

6

7

8

9

3

01 U08

02 U08

01 U08

7102519

Peltz

Reid

U08

BKH

0

90

60

100

80

100

90

0

70

90

100

1070

1

8

4

2

480

2

3

2

500

1

5

2

0

100

90

80

70

60

0

100

90

80

60

0

100

90

70

0

4

02 U08

01 U08

05 U08

7140797

Marchesi

Milo

U08

BKH

0

100

90

100

0

100

90

0

80

0

950

2

6

3

1

490

1

4

2

0

370

5

2

1

100

90

80

0

100

90

0

100

90

80

0

5

03 U08

7033941

Brunsvold

Carter

U08

AFT

100

70

90

60

80

90

70

80

55

80

90

0

90

80

940

3

1

4

6

440

3

1

2

420

3

0

2

4

100

90

80

70

60

55

0

100

90

80

70

60

55

90

80

0

6

04 U08

7086044

Benson

Soren

U08

AFT

90

0

70

60

0

70

80

0

90

80

0

60

70

830

4

0

2

3

380.5

4

0

1

380

4

0

1

2

90

80

70

60

0

0.5

90

80

70

60

0

90

80

70

60

0

7

05 U08

06 U08

02 U08

7013888

Zellmer

Samuel

U08

AFT

80

0

90

100

0

70

90

810

5

3

4

1

360

6

1

2

1

450

2

0

100

90

80

70

0

100

90

80

0

100

90

70

0

8

06 U08

05 U08

06 U08

7012809

O'Grady

Henryk

U08

AFT

70

80

60

70

55

70

0

60

70

0

60

55

755

6

0

3

380

5

0

3

300

6

0

80

70

60

55

0

80

70

60

55

70

60

55

0

9

07 U08

7159818

Comstock

Waylon

U08

FST

0

60

0

90

0

70

60

400

7

0

1

0

180

7

0

220

7

0

1

0

90

70

60

0

60

0

90

70

60

0

10

n/a

7155010

Hinrichs

Jack

U08

GIL

0

8

0

8

0

8

0

11

01 U10

02 U10

6679237

Titler

Teddy

U10

BKH

0

100

50

90

100

90

100

80

90

80

1060

1

7

5

4

500

1

5

2

0

470

2

3

4

100

90

80

50

0

100

90

50

0

100

90

80

12

02 U10

01 U10

6931622

Houle

John Luc

U10

AFT

0

80

90

0

90

33

0

100

0

100

90

100

90

1050

2

6

1

450

2

1

3

1

500

1

5

3

0

100

90

80

33

0

100

90

80

33

0

100

90

0

13

03 U10

7035289

Rambow

Magnus

U10

FST

60

90

80

0

100

0

70

80

70

80

90

100

950

3

2

5

430

3

2

1

430

3

1

4

100

90

80

70

60

0

100

90

80

60

0

100

90

80

70

14

04 U10

6903702

Stinnett

Jack

U10

BKH

0

70

80

90

80

31

80

90

0

60

55

70

860

4

0

2

5

410

4

0

1

4

370

4

0

1

90

80

70

60

55

31

0

90

80

70

31

0

90

80

70

60

55

0

15

05 U10

7012176

Simon

Spencer

U10

GIL

0

60

70

0

80

70

0

70

60

70

50

45

50

55

735

5

0

1

360

5

0

1

310

5

0

80

70

60

55

50

45

0

80

70

60

0

70

60

55

50

45

0

16

06 U10

07 U10

06 U10

7031191

Lodermeier

Graham

U10

AFT

90

50

45

0

60

55

45

55

50

45

40

60

650

6

0

1

0

310

7

0

1

0

290

6

0

90

60

55

50

45

40

0

90

60

55

50

45

0

60

55

50

45

40

17

07 U10

10 U10

07 U10

7013674

Molinaro

Peter

U10

AFT

0

50

0

90

60

0

70

55

40

45

625

7

0

1

0

260

10

0

1

0

280

7

0

90

70

60

55

50

45

40

0

90

60

50

0

70

55

45

40

0

18

08 U10

09 U10

6933951

O'Grady

Bohdan

U10

AFT

80

45

40

60

55

45

50

60

45

40

35

0

33

50

605

8

0

1

305

8

0

1

245

9

0

80

60

55

50

45

40

35

33

0

80

60

55

50

45

40

60

50

45

40

35

33

0

19

09 U10

10 U10

7106748

Underhill

Viggo

U10

BKH

70

55

0

50

60

0

50

45

55

50

45

40

0

40

585

9

0

290

9

0

240

10

0

70

60

55

50

45

40

0

70

60

55

50

45

0

55

50

45

40

0

20

10 U10

06 U10

12 U10

7037253

Richardson

Graham

U10

GIL

100

0

55

60

70

0

60

0

35

50

45

0

545

10

1

0

355

6

1

0

190

12

0

100

70

60

55

50

45

35

0

100

70

60

55

0

60

50

45

35

0

21

11 U10

14 U10

7083495

Miller

Ryder

U10

BKH

45

29

35

50

45

50

45

40

35

40

0

29

31

33

27

31

449

11

0

235

11

0

166

14

0

50

45

40

35

33

31

29

27

0

50

45

40

35

29

40

33

31

29

27

0

22

12 U10

11 U10

7117542

Bristlin

Rhys

U10

FST

55

40

29

31

40

35

33

50

40

35

27

0

31

33

427

12

0

203

12

0

191

11

0

55

50

40

35

33

31

29

27

0

55

40

35

33

31

29

50

40

35

33

31

27

0

23

13 U10

7091437

Saewert

Otto

U10

GIL

50

31

33

35

33

0

35

45

0

33

35

0

35

402

13

0

198

13

0

171

13

0

50

45

35

33

31

0

50

45

35

33

31

0

35

33

0

24

14 U10

15 U10

08 U10

7085049

Richardson

Anders

U10

GIL

0

80

0

29

0

100

90

70

0

369

14

1

109

15

0

1

260

8

1

0

100

90

80

70

29

0

80

29

0

100

90

70

0

25

15 U10

18 U10

15 U10

7144398

Micko

Dominic

U10

AFT

0

35

31

0

35

31

0

163

15

0

66

18

0

97

15

0

35

31

0

35

31

0

35

31

0

26

16 U10

17 U10

7145180

Chalekian

Sullivan

U10

GIL

0

45

33

0

27

0

35

0

140

16

0

105

16

0

35

17

0

45

35

33

27

0

45

33

27

0

35

0

27

17 U10

14 U10

n/a

7166356

Maslev

Rad

U10

GIL

0

40

45

0

125

17

0

125

14

0

19

0

45

40

0

45

40

0

28

18 U10

20 U10

16 U10

6926387

Scharrer

Torsten

U10

BKH

0

33

0

45

40

0

118

18

0

33

20

0

85

16

0

45

40

33

0

33

0

45

40

0

29

19 U10

17 U10

n/a

7167238

Chou

Emmett

U10

GIL

0

35

29

35

0

99

19

0

99

17

0

19

0

35

29

0

35

29

0

30

20 U10

19 U10

18 U10

7167832

Soldan

Asher

U10

AFT

0

40

0

29

0

69

20

0

40

19

0

29

18

0

40

29

0

40

0

29

0

31

01 U12

02 U12

01 U12

6679153

Mjanger

Luke

U12

AFT

100

90

80

90

22

80

100

80

90

100

90

1030

1

4

7

6

450

2

1

3

4

480.5

1

3

4

2

100

90

80

22

100

90

80

22

0.5

100

90

80

32

02 U12

01 U12

02 U12

6941815

Pope

Reed

U12

FST

60

100

60

20

90

55

0

100

90

70

100

0

50

60

100

90

100

1000

2

6

3

0

450.5

1

3

1

0

480

2

3

2

0

100

90

70

60

55

50

20

0

0.5

100

90

60

55

20

0

100

90

70

60

50

0

33

03 U12

04 U12

6751067

Zadvornykh

Roman

U12

BKH

70

60

100

90

70

50

40

70

90

80

60

55

100

80

70

50

60

880

3

2

420

4

1

2

0

390

4

1

0

2

100

90

80

70

60

55

50

40

100

90

70

60

50

40

100

80

70

60

55

50

34

04 U12

05 U12

03 U12

6678643

Levander

Everett

U12

AFT

80

70

55

100

24

33

0

80

70

0

55

70

100

70

55

0

80

855

4

2

0

4

400

5

1

0

2

400

3

1

0

2

100

80

70

55

33

24

0

100

80

70

55

33

24

0

100

80

70

55

0

35

05 U12

03 U12

07 U12

6983174

Peltz

Cole

U12

BKH

55

80

60

100

60

45

40

55

0

45

60

80

100

60

40

45

835

5

3

0

3

420.5

3

2

0

2

355

7

1

0

1

100

80

60

55

45

40

0

0.5

100

80

60

55

45

40

100

80

60

55

45

40

0

36

06 U12

6778054

Burns

William

U12

AFT

90

55

50

60

70

80

90

60

26

90

55

70

60

50

45

70

810

6

0

3

1

390

6

0

2

1

360

6

0

1

0

90

80

70

60

55

50

45

26

90

80

70

60

55

50

90

70

60

55

50

45

26

37

07 U12

05 U12

6953275

Hopke

Brexten

U12

BKH

0

50

70

40

90

70

55

45

0

90

55

70

55

60

26

775

7

0

3

0

355

7

0

1

0

365

5

0

2

0

90

70

60

55

50

45

40

26

0

90

70

55

50

45

40

0

90

70

60

55

26

0

38

08 U12

09 U12

08 U12

7002342

Sampson

Reef

U12

FST

45

0

55

10

50

70

80

0

45

0

50

55

50

610

8

0

1

260

9

0

305

8

0

1

80

70

55

50

45

10

0

55

50

45

10

0

80

70

55

50

45

0

39

09 U12

08 U12

09 U12

6779490

Schaeppi

Asa

U12

BKH

50

45

40

27

50

60

55

60

55

0

35

50

35

40

0

45

55

575

9

0

280

8

0

240

9

0

60

55

50

45

40

35

27

0

60

55

50

45

40

27

55

50

45

40

35

0

40

10 U12

13 U12

10 U12

6944250

Jakobe

Benjamin

U12

GIL

23

15

29

23

45

35

33

0

60

50

0

31

27

0

395

10

0

165

13

0

203

10

0

60

50

45

35

33

31

29

27

23

15

0

45

35

33

29

23

15

0

60

50

31

27

0

41

11 U12

13 U12

7103072

King-Ellison

Roenen

U12

BKH

29

27

31

40

33

45

0

35

29

35

40

45

0

391

11

0

178

11

0

184

13

0

45

40

35

33

31

29

27

0

45

40

33

31

29

27

0

45

40

35

29

0

42

12 U12

18 U12

11 U12

7036119

Stueve

Gavin

U12

GIL

27

0

15

0

31

33

35

50

45

0

19

35

33

35

358

12

0

141.5

18

0

198.5

11

0

50

45

35

33

31

27

19

15

0

0.5

35

33

31

27

15

0

0.5

50

45

35

33

19

0

43

13 U12

12 U12

19 U12

7032006

Geelan

Jack

U12

GIL

31

35

25

35

27

29

45

0

40

0

26

29

0

33

0

355

13

0

175

12

0

128.5

19

0

45

40

35

33

31

29

27

26

25

0

45

35

31

29

27

25

0

0.5

40

33

29

26

0

44

14 U12

19 U12

14 U12

6771406

Cryer

Carson

U12

BKH

0

21

45

0

35

33

0

31

33

35

0

35

40

341

14

0

134

19

0

176

14

0

45

40

35

33

31

21

0

45

35

33

21

0

40

35

33

31

0

45

15 U12

10 U12

18 U12

7106837

Underhill

Griffin

U12

BKH

0

35

45

29

40

0

31

0

23

22

26

0

31

27

340

15

0

182

10

0

129

18

0

45

40

35

31

29

27

26

23

22

0

45

40

35

31

29

0

31

27

26

23

22

0

46

16 U12

26 U12

12 U12

6983375

Demars

Milo

U12

FST

40

29

27

0

45

40

35

45

29

33

0

323

16

0

96.5

26

0

198

12

0

45

40

35

33

29

27

0

0.5

40

29

27

0

45

40

35

33

29

0

47

17 U12

16 U12

15 U12

6952905

Johnson

Soren

U12

BKH

0

22

31

27

29

27

0

27

25

29

23

29

33

317

17

0

145

16

0

145

15

0

33

31

29

27

25

23

22

0

31

29

27

22

0

33

29

27

25

23

0

48

18 U12

15 U12

20 U12

6970496

Barbeau

Avery

U12

FST

35

31

26

29

25

31

29

26

27

22

24

17

25

20

23

25

312

18

0

155

15

0

128

20

0

35

31

29

27

26

25

24

23

22

20

17

35

31

29

26

25

27

25

24

23

22

20

17

49

19 U12

20 U12

16 U12

7022048

Negi

Saivya

U12

GIL

0

25

35

0

40

29

0

31

0

20

24

31

25

31

291

19

0

129

20

0

142

16

0

40

35

31

29

25

24

20

0

40

35

29

25

0

31

25

24

20

0

50

20 U12

17 U12

21 U12

7003414

Glancy

Liam

U12

AFT

33

26

24

13

20

25

35

0

33

0

21

25

0

29

0

284

20

0

143

17

0

108

21

0

35

33

29

26

25

24

21

20

13

0

35

33

26

25

24

20

13

0

33

29

25

21

0

51

21 U12

23 U12

17 U12

7129523

Barott

Laken

U12

FST

25

0

9

23

0

25

0

25

21

19

16

27

22

26

25

269

21

0

105

23

0

130

17

0

27

26

25

23

22

21

19

16

9

0

25

23

9

0

27

26

25

22

21

19

16

52

22 U12

21 U12

26 U12

7012913

Halverson

Chase

U12

AFT

20

19

26

22

0

26

0

20

17

20

0

21

0

230

22

0

113

21

0

98

26

0

26

22

21

20

19

17

0

26

22

20

19

0

21

20

17

0

53

23 U12

22 U12

6944248

Kim

Charlie

U12

GIL

24

23

20

15

17

0

23

0

23

24

21

16

22

15

0

228

23

0

107

22

0

106

22

0

24

23

22

21

20

17

16

15

0

24

23

20

17

15

0

24

23

22

21

16

15

0

54

24 U12

14 U12

36 U12

7090610

Ruoho

Jack

U12

BKH

0

40

33

26

0

40

26

0

224

24

0

158

14

0

66

36

0

40

33

26

0

40

33

26

0

40

26

0

55

25 U12

27 U12

29 U12

7144247

Johhnson

Eli

U12

GIL

16

14

15

19

0

17

21

23

0

15

13

14

0

17

16

21

201

25

0

96

27

0

90

29

0

23

21

19

17

16

15

14

13

0

23

21

19

17

16

15

14

0

21

17

16

15

14

13

0

56

26 U12

28 U12

25 U12

7091855

Swanke

Ivan

U12

GIL

15

0

8

11

13

0

24

18

16

0

19

15

0

22

23

200

26

0

87

28

0

98.3

25

0

24

23

22

19

18

16

15

13

11

8

0

24

15

13

11

8

0

0.3

23

22

19

18

16

15

0

57

27 U12

25 U12

32 U12

6775209

Jones

Reid

U12

TBY

0

100

0

80

0

180

27

1

0

1

100

25

1

0

80

32

0

1

100

80

0

100

0

80

0

58

28 U12

32 U12

23 U12

7086207

Johnson

Caden

U12

AFT

22

25

0

25

0

31

0

25

23

0

25

0

176

28

0

72

32

0

104

23

0

31

25

23

22

0

25

22

0

31

25

23

0

59

29 U12

33 U12

7144570

Hinrichs

Ben

U12

GIL

26

33

23

0

33

45

0

161

29

0

82

29

0

78.5

33

0

0.5

45

33

26

23

0

33

26

23

0

0.5

45

33

0

60

30 U12

34 U12

24 U12

7145532

Johnson

Kolt

U12

DUL

19

0

21

0

24

26

0

23

26

0

160

30

0

61

34

0

99.5

24

0

0.3

26

24

23

21

19

0

21

19

0

0.5

26

24

23

0

61

31 U12

30 U12

31 U12

7142995

Hagen

Tommy

U12

GIL

0

24

17

18

0

20

0

18

22

23

0

160

31

0

79

30

0

81

31

0

24

23

22

20

18

17

0

24

20

18

17

0

23

22

18

0

62

32 U12

36 U12

27 U12

6773139

Richardson

Sawyer

U12

GIL

0

14

16

0

24

0

29

25

0

24

0

19

0

151

32

0

54.5

36

0

97

27

0

29

25

24

19

16

14

0

0.5

24

16

14

0

29

25

24

19

0

63

33 U12

31 U12

35 U12

6926242

Brown

Griffin

U12

GIL

0

16

0

17

0

19

22

0

24

14

15

0

18

0

145

33

0

74

31

0

71

35

0

24

22

19

18

17

16

15

14

0

22

19

17

16

0

24

18

15

14

0

64

34 U12

24 U12

43 U12

7103128

Grandell

Nelson

U12

GIL

0

20

19

22

18

22

0

17

19

0

137

34

0

101

24

0

36

43

0

22

20

19

18

17

0

22

20

19

18

0

19

17

0

65

35 U12

42 U12

28 U12

7099664

Radner

Cole

U12

BKH

17

13

0

22

18

15

17

21

0

136

35

0

43

42

0

93

28

0

22

21

18

17

15

13

0

17

13

0

22

21

18

17

15

0

66

36 U12

37 U12

34 U12

7021691

Kyle

Jackson

U12

GIL

21

17

16

0

21

19

0

18

0

130

36

0

54.3

37

0

76

34

0

21

19

18

17

16

0

0.3

21

17

16

0

21

19

18

0

67

37 U12

46 U12

30 U12

6944207

Larson

Finn

U12

GIL

14

0

20

0

23

20

0

12

14

0

118

37

0

34

46

0

83

30

0

0.5

23

20

14

12

0

20

14

0

23

20

14

12

0

68

38 U12

35 U12

37 U12

7107847

Marthaler

Donek

U12

BKH

0

18

14

12

0

15

0

16

13

16

0

117

38

0

59

35

0

58

37

0

18

16

15

14

13

12

0

18

15

14

12

0

16

13

0

69

39 U12

38 U12

7032999

Mayerle

Wes

U12

AFT

0

27

25

0

27

29

108

39

0

52.5

38

0

56

38

0

29

27

25

0

0.5

27

25

0

29

27

0

70

40 U12

39 U12

40 U12

7135036

Balsimo

Micco

U12

GIL

0

12

7

10

11

0

24

22

98

40

0

52

39

0

46

40

0

24

22

12

11

10

7

0

12

11

10

7

0

24

22

0

71

41 U12

45 U12

39 U12

7091243

Margolin

Samuel

U12

GIL

0

10

13

12

0

14

21

17

0

87

41

0

35.3

45

0

52.5

39

0

21

17

14

13

12

10

0

0.3

13

12

10

0

0.5

21

17

14

0

72

42 U12

41 U12

44 U12

7115799

Mallery

Rigby

U12

GIL

0

23

21

0

15

20

0

79

42

0

44.5

41

0

35

44

0

23

21

20

15

0

0.5

23

21

0

20

15

0

73

43 U12

33 U12

n/a

6853961

Wohlrabe

Collins

U12

GIL

0

24

19

24

0

67

43

0

67

33

0

49

0

24

19

0

24

19

0

74

44 U12

43 U12

46 U12

7143146

Matchinsky

Andrew

U12

GIL

0

21

0

18

0

26

0

65

44

0

39

43

0

26.5

46

0

26

21

18

0

21

18

0

0.5

26

0

75

45 U12

47 U12

41 U12

7143194

Ellis

Brody

U12

AFT

18

0

19

22

0

59

45

0

18.5

47

0

41

0

22

19

18

0

0.5

18

0

22

19

0

76

46 U12

48 U12

42 U12

7167376

Moertel

William

U12

GIL

0

9

0

40

0

58

46

0

18

48

0

40

42

0

40

9

0

9

0

40

0

77

47 U12

40 U12

n/a

7157857

Basgen

Sullivan

U12

GIL

0

16

14

16

0

46

47

0

46

40

0

49

0

16

14

0

16

14

0

78

48 U12

49 U12

47 U12

7107538

Krause

Aden

U12

AFT

13

0

14

0

12

0

39

48

0

13

49

0

26

47

0

14

13

12

0

13

0

14

12

0

79

49 U12

44 U12

n/a

7086945

Monson

Chase

U12

GIL

0

11

12

14

0

37

49

0

37

44

0

49

0

14

12

11

0

14

12

11

0

80

50 U12

n/a

45 U12

7144614

Laughlin

Connor

U12

GIL

0

33

0

33

50

0

50

0

33

45

0

33

0

33

0

81

51 U12

n/a

48 U12

6960263

Jones

Ross

U12

TBY

0

24

0

24

51

0

50

0

24.5

48

0

24

0

0.5

24

0

82

n/a

6983223

Bert

Wyatt

U12

AFT

0

52

0

50

0

49

0

83

n/a

7116119

Lutz

Jake

U12

GIL

0

52

0

50

0

49

0

84

n/a

6944285

Skinner

Joey

U12

GIL

0

52

0

50

0

49

0

85

n/a

0

1

0

1

0

1

0

86

n/a

0

1

0

1

0

1

0

87

n/a

0

1

0

1

0

1

0

88

n/a

0

1

0

1

0

1

0

89

n/a

0

1

0

1

0

1

0

90

n/a

0

1

0

1

0

1

0

91

n/a

0

1

0

1

0

1

0

92

n/a

0

1

0

1

0

1

0

93

n/a

0

1

0

1

0

1

0

94

n/a

0

1

0

1

0

1

0

95

n/a

0

1

0

1

0

1

0

96

n/a

0

1

0

1

0

1

0

97

n/a

0

1

0

1

0

1

0

98

n/a

0

1

0

1

0

1

0

99

n/a

0

1

0

1

0

1

0

100

n/a

0

1

0

1

0

1

0

101

n/a

0

1

0

1

0

1

0

102

n/a

0

1

0

1

0

1

0

103

n/a

0

1

0

1

0

1

0

104

n/a

0

1

0

1

0

1

0

105

n/a

0

1

0

1

0

1

0

106

n/a

0

1

0

1

0

1

0

107

n/a

0

1

0

1

0

1

0

108

n/a

0

1

0

1

0

1

0

109

n/a

0

1

0

1

0

1

0

110

n/a

0

1

0

1

0

1

0

111

n/a

0

1

0

1

0

1

0

112

n/a

0

1

0

1

0

1

0

113

n/a

0

1

0

1

0

1

0

114

n/a

0

1

0

1

0

1

0

115

n/a

0

1

0

1

0

1

0

116

n/a

0

1

0

1

0

1

0

117

n/a

0

1

0

1

0

1

0

118

n/a

0

1

0

1

0

1

0

119

n/a

0

1

0

1

0

1

0

120

n/a

0

1

0

1

0

1

0

121

n/a

0

1

0

1

0

1

0

122

n/a

0

1

0

1

0

1

0

123

n/a

0

1

0

1

0

1

0

124

n/a

0

1

0

1

0

1

0

125

n/a

0

1

0

1

0

1

0

126

n/a

0

1

0

1

0

1

0

127

n/a

0

1

0

1

0

1

0

128

n/a

0

1

0

1

0

1

0

129

n/a

0

1

0

1

0

1

0

130

n/a

0

1

0

1

0

1

0

131

n/a

0

1

0

1

0

1

0

132

n/a

0

1

0

1

0

1

0

133

n/a

0

1

0

1

0

1

0

134

n/a

0

1

0

1

0

1

0

135

n/a

0

1

0

1

0

1

0

136

n/a

0

1

0

1

0

1

0

137

n/a

0

1

0

1

0

1

0

138

n/a

0

1

0

1

0

1

0

139

n/a

0

1

0

1

0

1

0

140

n/a

0

1

0

1

0

1

0

141

n/a

0

1

0

1

0

1

0

142

n/a

0

1

0

1

0

1

0

143

n/a

0

1

0

1

0

1

0

144

n/a

0

1

0

1

0

1

0

145

n/a

0

1

0

1

0

1

0

146

n/a

0

1

0

1

0

1

0

147

n/a

0

1

0

1

0

1

0

148

n/a

0

1

0

1

0

1

0

149

n/a

0

1

0

1

0

1

0

150

n/a

0

1

0

1

0

1

0

151

n/a

0

1

0

1

0

1

0

152

n/a

0

1

0

1

0

1

0

153

n/a

0

1

0

1

0

1

0

154

n/a

0

1

0

1

0

1

0

155

n/a

0

1

0

1

0

1

0

156

n/a

0

1

0

1

0

1

0

157

n/a

0

1

0

1

0

1

0

158

n/a

0

1

0

1

0

1

0

159

n/a

0

1

0

1

0

1

0

160

n/a

0

1

0

1

0

1

0

161

n/a

0

1

0

1

0

1

0

162

n/a

0

1

0

1

0

1

0

163

n/a

0

1

0

1

0

1

0

164

n/a

0

1

0

1

0

1

0

165

n/a

0

1

0

1

0

1

0

166

n/a

0

1

0

1

0

1

0

167

n/a

0

1

0

1

0

1

0

168

n/a

0

1

0

1

0

1

0

169

n/a

0

1

0

1

0

1

0

170

n/a

0

1

0

1

0

1

0

171

n/a

0

1

0

1

0

1

0

172

n/a

0

1

0

1

0

1

0

173

n/a

0

1

0

1

0

1

0

174

n/a

0

1

0

1

0

1

0

175

n/a

0

1

0

1

0

1

0

176

n/a

0

1

0

1

0

1

0

177

n/a

0

1

0

1

0

1

0

178

n/a

0

1

0

1

0

1

0

179

n/a

0

1

0

1

0

1

0

180

n/a

0

1

0

1

0

1

0

181

n/a

0

1

0

1

0

1

0

182

n/a

0

1

0

1

0

1

0

183

n/a

0

1

0

1

0

1

0

184

n/a

0

1

0

1

0

1

0

185

n/a

0

1

0

1

0

1

0

186

n/a

0

1

0

1

0

1

0

187

n/a

0

1

0

1

0

1

0

188

n/a

0

1

0

1

0

1

0

189

n/a

0

1

0

1

0

1

0

190

n/a

0

1

0

1

0

1

0

191

n/a

0

1

0

1

0

1

0

192

n/a

0

1

0

1

0

1

0

193

n/a

0

1

0

1

0

1

0

194

n/a

0

1

0

1

0

1

0

195

n/a

0

1

0

1

0

1

0

196

0

197

0

198

0

199

0


1	Spirit Mtn Non-Scored Race B SL							UPDATED FORMULAS	Adjust forumla if needed	Adjust forumla if needed	Adjust forumla if needed		Quality Control Checks			time				rank in category
2	Slalom (U8-U16 / Men)								ID	Category (u8, u10...)	Time	ID on Summary?	Check Name (shows as listed on summary, differences highlighted)	Check Age Category (shows as listed on summary)	Rank in Category	U08	U10	U12	U14	U08	U10	U12	U14
3	Run Ranking 1																								Copy source data starting at Column A (don't go beyond Column O)	Copy source data starting at Column A (don't go beyond Column O)
4									0						0					0	0	0	0		Check that the formula in Column P refers to ID; change it if needed	Check that the formula in Column P refers to ID; change it if needed
5	Rank	Bib	USA ID	Name	Category	Club	Time		#VALUE!	Category	Time				0					0	0	0	0	USA ID Name Category Club	Check that the formula in Column Q gives Category (U14, U12...). If Category isn't in the source data, use the formula below to get it from Year	Check that the formula in Column Q gives Category (U14, U12...). If Category isn't in the source data, use the formula below to get it from Year
6									0						0					0	0	0	0		Check that the forumla in Column R refers to the time column; change it if needed.	Check that the forumla in Column R refers to the time column; change it if needed.
7									0						0					0	0	0	0		Make sure that any times greater than a minute (1:00.0) are converting to seconds properly in Column R	Make sure that any times greater than a minute (1:00.0) are converting to seconds properly in Column R
8	Category: U8								0						0					0	0	0	0		Check that names are as expected	Check that names are as expected
9	1	3	C7033941	Brunsvold Carter	U8	AFT	65.53		7033941	U08	65.53	TRUE	Brunsvold Carter	U08	1	65.53				1	0	0	0		Check that all the Region 1 racers IDs are on Summary. If the ID should be in the summary but it's not -- add it.	Check that all the Region 1 racers IDs are on Summary. If the ID should be in the summary but it's not -- add it.
10	2	1	C7086044	Benson Soren	U8	AFT	67.51		7086044	U08	67.51	TRUE	Benson Soren	U08	2	67.51				2	0	0	0		Check that rankings in category look correct (Rank In Category is in Column U; the summary tab looks for it there)	Check that rankings in category look correct (Rank In Category is in Column U; the summary tab looks for it there)
11	3	2	C7013888	Zellmer Samuel	U8	AFT	67.56		7013888	U08	67.56	TRUE	Zellmer Samuel	U08	3	67.56				3	0	0	0		On the summary, copy the formula from a completed race to this race, but change the sheet name to match this tab	On the summary, copy the formula from a completed race to this race, but change the sheet name to match this tab
12	4	4	C7012809	O'Grady Henryk	U8	AFT	72.24		7012809	U08	72.24	TRUE	O'Grady Henryk	U08	4	72.24				4	0	0	0
13									0						0					0	0	0	0
14									0						0					0	0	0	0
15	Did Not Finish (1)								0						0					0	0	0	0		Formula for Category if only Year, not Category, are given in the source data:	Formula for Category if only Year, not Category, are given in the source data:
16		5	C7102519	Peltz Reid	U8	BKH			7102519	U08		TRUE	Peltz Reid	U08	0					0	0	0	0		=IFERROR(VLOOKUP(Value(E16),Category!$A$1:$B$8,2,0),"")	=IFERROR(VLOOKUP(Value(E16),Category!$A$1:$B$8,2,0),"")
17									0						0					0	0	0	0
18									0						0					0	0	0	0
19	Category: U10								0						0					0	0	0	0
20	1	12	C7037253	Richardson Graham	U10	GIL	55.16		7037253	U10	55.16	TRUE	Richardson Graham	U10	1		55.16			0	1	0	0
21	2	10	C7031191	Lodermeier Graham	U10	AFT	56.17		7031191	U10	56.17	TRUE	Lodermeier Graham	U10	2		56.17			0	2	0	0
22	3	9	C6933951	O'Grady Bohdan	U10	AFT	56.3		6933951	U10	56.30	TRUE	O'Grady Bohdan	U10	3		56.30			0	3	0	0
23	4	8	C7106748	Underhill Viggo	U10	BKH	56.51		7106748	U10	56.51	TRUE	Underhill Viggo	U10	4		56.51			0	4	0	0
24	5	7	C7035289	Rambow Magnus	U10	FST	61		7035289	U10	61.00	TRUE	Rambow Magnus	U10	5		61.00			0	5	0	0
25	6	6	C7118379	Knadle Parker	U10		63.92		7118379	U10	63.92				0					0	0	0	0	C7118379 Knadle Parker U10
26	7	15	C7117542	Bristlin Rhys	U10	FST	64.92		7117542	U10	64.92	TRUE	Bristlin Rhys	U10	6		64.92			0	6	0	0
27	8	17	C7091437	Saewert Otto	U10	GIL	67.19		7091437	U10	67.19	TRUE	Saewert Otto	U10	7		67.19			0	7	0	0
28	9	13	C7083495	Miller Ryder	U10	BKH	67.7		7083495	U10	67.70	TRUE	Miller Ryder	U10	8		67.70			0	8	0	0
29									0						0					0	0	0	0
30									0						0					0	0	0	0
31	Did Not Start (2)								0						0					0	0	0	0
32		16	C6938427	Moore Tait	U10	CAR			6938427	U10					0					0	0	0	0	C6938427 Moore Tait U10 CAR
33		21	C7013674	Molinaro Peter	U10	AFT			7013674	U10		TRUE	Molinaro Peter	U10	0					0	0	0	0
34									0						0					0	0	0	0
35									0						0					0	0	0	0
36	Did Not Finish (3)								0						0					0	0	0	0
37		14	C6903702	Stinnett Jack	U10	BKH			6903702	U10		TRUE	Stinnett Jack	U10	0					0	0	0	0
38		19	C7012176	Simon Spencer	U10	GIL			7012176	U10		TRUE	Simon Spencer	U10	0					0	0	0	0
39		20	C6679237	Titler Teddy	U10	BKH			6679237	U10		TRUE	Titler Teddy	U10	0					0	0	0	0
40									0						0					0	0	0	0
41									0						0					0	0	0	0
42	Disqualified (2)								0						0					0	0	0	0
43		11	7144398	Micko Dominic	U10		Rule missed gate		7144398	U10	Rule missed gate	TRUE	Micko Dominic	U10	0		Rule missed gate			0	0	0	0
44		18	C6931622	Houle John Luc	U10	AFT	Rule missed gate		6931622	U10	Rule missed gate	TRUE	Houle John Luc	U10	0		Rule missed gate			0	0	0	0
45									0						0					0	0	0	0
46									0						0					0	0	0	0
47	Category: U12								0						0					0	0	0	0
48	1	56	C6679153	Mjanger Luke	U12	AFT	38.02		6679153	U12	38.02	TRUE	Mjanger Luke	U12	1			38.02		0	0	1	0
49	2	35	C6778054	Burns William	U12	AFT	38.2		6778054	U12	38.20	TRUE	Burns William	U12	2			38.20		0	0	2	0
50	3	52	C6678643	Levander Everett	U12	AFT	39.1		6678643	U12	39.10	TRUE	Levander Everett	U12	3			39.10		0	0	3	0
51	4	41	X6751067	Zadvornykh Roman	U12	BKH	39.69		6751067	U12	39.69	TRUE	Zadvornykh Roman	U12	4			39.69		0	0	4	0
52	5	23	C6941815	Pope Reed	U12	FST	39.79		6941815	U12	39.79	TRUE	Pope Reed	U12	5			39.79		0	0	5	0
53	6	60	C6983174	Peltz Cole	U12	BKH	39.82		6983174	U12	39.82	TRUE	Peltz Cole	U12	6			39.82		0	0	6	0
54	7	43	R6712468	Campian Alexander	U12	SUM	40.31		6712468	U12	40.31				0					0	0	0	0	R6712468 Campian Alexander U12 SUM
55	8	57	C6779490	Schaeppi Asa	U12	BKH	41.04		6779490	U12	41.04	TRUE	Schaeppi Asa	U12	7			41.04		0	0	7	0
56	9	39	C7002342	Sampson Reef	U12	FST	41.25		7002342	U12	41.25	TRUE	Sampson Reef	U12	8			41.25		0	0	8	0
57	10	48	C6983375	Demars Milo	U12	FST	47.06		6983375	U12	47.06	TRUE	Demars Milo	U12	9			47.06		0	0	9	0
58	11	30	C6970496	Barbeau Avery	U12	FST	48.74		6970496	U12	48.74	TRUE	Barbeau Avery	U12	10			48.74		0	0	10	0
59	12	45	C7003414	Glancy Liam	U12	AFT	49.47		7003414	U12	49.47	TRUE	Glancy Liam	U12	11			49.47		0	0	11	0
60	13	25	C7032006	Geelan Jack	U12	GIL	49.77		7032006	U12	49.77	TRUE	Geelan Jack	U12	12			49.77		0	0	12	0
61	14	54	C7103072	King-Ellison Roenen	U12	BKH	50.87		7103072	U12	50.87	TRUE	King-Ellison Roenen	U12	13			50.87		0	0	13	0
62	15	46	C7018104	Lee Keya	U12	CAR	51.12		7018104	U12	51.12				0					0	0	0	0	C7018104 Lee Keya U12 CAR
63	16	26	C7036119	Stueve Gavin	U12	GIL	52.09		7036119	U12	52.09	TRUE	Stueve Gavin	U12	14			52.09		0	0	14	0
64	17	40	C7144570	Hinrichs Ben	U12	GIL	52.91		7144570	U12	52.91	TRUE	Hinrichs Ben	U12	15			52.91		0	0	15	0
65	18	37	C7129523	Barott Laken	U12	FST	54.25		7129523	U12	54.25	TRUE	Barott Laken	U12	16			54.25		0	0	16	0
66	19	34	C6944248	Kim Charlie	U12	GIL	54.59		6944248	U12	54.59	TRUE	Kim Charlie	U12	17			54.59		0	0	17	0
67	20	50	C6944250	Jakobe Benjamin	U12	GIL	55.08		6944250	U12	55.08	TRUE	Jakobe Benjamin	U12	18			55.08		0	0	18	0
68	21	49	C7086207	Johnson Caden	U12	AFT	55.74		7086207	U12	55.74	TRUE	Johnson Caden	U12	19			55.74		0	0	19	0
69	22	22	C7021691	Kyle Jackson	U12	GIL	57.48		7021691	U12	57.48	TRUE	Kyle Jackson	U12	20			57.48		0	0	20	0
70	23	59	C7012913	Halverson Chase	U12	AFT	60.37		7012913	U12	60.37	TRUE	Halverson Chase	U12	21			60.37		0	0	21	0
71	24	44	C7145532	Johnson Kolt	U12	DUL	60.63		7145532	U12	60.63	TRUE	Johnson Kolt	U12	22			60.63		0	0	22	0
72	25	58	C7143194	Ellis Brody	U12	AFT	60.73		7143194	U12	60.73	TRUE	Ellis Brody	U12	23			60.73		0	0	23	0
73	26	29	C7099664	Radner Cole	U12	BKH	63.44		7099664	U12	63.44	TRUE	Radner Cole	U12	24			63.44		0	0	24	0
74	27	53	C7144247	Johhnson Eli	U12	GIL	64.22		7144247	U12	64.22	TRUE	Johhnson Eli	U12	25			64.22		0	0	25	0
75	28	36	C7091855	Swanke Ivan	U12	GIL	64.63		7091855	U12	64.63	TRUE	Swanke Ivan	U12	26			64.63		0	0	26	0
76	29	38	C6944207	Larson Finn	U12	GIL	85.08		6944207	U12	85.08	TRUE	Larson Finn	U12	27			85.08		0	0	27	0
77	30	24	C7107538	Krause Aden	U12	AFT	85.21		7107538	U12	85.21	TRUE	Krause Aden	U12	28			85.21		0	0	28	0
78									0						0					0	0	0	0
79									0						0					0	0	0	0
80	Did Not Start (4)								0						0					0	0	0	0
81		28	C7103128	Grandell Nelson	U12	GIL			7103128	U12		TRUE	Grandell Nelson	U12	0					0	0	0	0
82		33	C6938468	Dahl Jackson	U12	CAR			6938468	U12					0					0	0	0	0	C6938468 Dahl Jackson U12 CAR
83		42	C6952905	Johnson Soren	U12	BKH			6952905	U12		TRUE	Johnson Soren	U12	0					0	0	0	0
84		47	C7091243	Margolin Samuel	U12	GIL			7091243	U12		TRUE	Margolin Samuel	U12	0					0	0	0	0
85									0						0					0	0	0	0
86									0						0					0	0	0	0
87	Did Not Finish (4)								0						0					0	0	0	0
88		27	C6824610	Moore Aleksander	U12	CAR			6824610	U12					0					0	0	0	0	C6824610 Moore Aleksander U12 CAR
89		31	C6926242	Brown Griffin	U12	GIL			6926242	U12		TRUE	Brown Griffin	U12	0					0	0	0	0
90		32	C7144614	Laughlin Connor	U12	GIL			7144614	U12		TRUE	Laughlin Connor	U12	0					0	0	0	0
91		55	C6773139	Richardson Sawyer	U12	GIL			6773139	U12		TRUE	Richardson Sawyer	U12	0					0	0	0	0
92									0						0					0	0	0	0
93									0						0					0	0	0	0
94	Disqualified (1)								0						0					0	0	0	0
95		51	X7022048	Negi Saivya	U12	GIL	Rule missed gate		7022048	U12	Rule missed gate	TRUE	Negi Saivya	U12	0			Rule missed gate		0	0	0	0
96									0						0					0	0	0	0
97									0						0					0	0	0	0
98									0						0					0	0	0	0
99									0						0					0	0	0	0
100									0						0					0	0	0	0
101									0						0					0	0	0	0
102									0						0					0	0	0	0
103									0						0					0	0	0	0
104									0						0					0	0	0	0
105									0						0					0	0	0	0
106									0						0					0	0	0	0
107									0						0					0	0	0	0
108									0						0					0	0	0	0
109									0						0					0	0	0	0
110									0						0					0	0	0	0
111									0						0					0	0	0	0
112									0						0					0	0	0	0
113									0						0					0	0	0	0
114									0						0					0	0	0	0
115									0						0					0	0	0	0
116									0						0					0	0	0	0
117									0						0					0	0	0	0
118									0						0					0	0	0	0
119									0						0					0	0	0	0
120									0						0					0	0	0	0
121									0						0					0	0	0	0
122									0						0					0	0	0	0
123									0						0					0	0	0	0
124									0						0					0	0	0	0
125									0						0					0	0	0	0
126									0						0					0	0	0	0
127									0						0					0	0	0	0
128									0						0					0	0	0	0
129									0						0					0	0	0	0
130									0						0					0	0	0	0
131									0						0					0	0	0	0
132									0						0					0	0	0	0
133									0						0					0	0	0	0
134									0						0					0	0	0	0
135									0						0					0	0	0	0
136									0						0					0	0	0	0
137									0						0					0	0	0	0
138									0						0					0	0	0	0
139									0						0					0	0	0	0
140									0						0					0	0	0	0
141									0						0					0	0	0	0
142									0						0					0	0	0	0
143									0						0					0	0	0	0
144									0						0					0	0	0	0
145									0						0					0	0	0	0
146									0						0					0	0	0	0
147									0						0					0	0	0	0
148									0						0					0	0	0	0
149									0						0					0	0	0	0
150									0						0					0	0	0	0
151									0						0					0	0	0	0
152									0						0					0	0	0	0
153									0						0					0	0	0	0
154									0						0					0	0	0	0
155									0						0					0	0	0	0
156									0						0					0	0	0	0
157									0						0					0	0	0	0
158									0						0					0	0	0	0
159									0						0					0	0	0	0
160									0						0					0	0	0	0
161									0						0					0	0	0	0
162									0						0					0	0	0	0
163									0						0					0	0	0	0
164									0						0					0	0	0	0
165									0						0					0	0	0	0
166									0						0					0	0	0	0
167									0						0					0	0	0	0
168									0						0					0	0	0	0
169									0						0					0	0	0	0
170									0						0					0	0	0	0
171									0						0					0	0	0	0
172									0						0					0	0	0	0
173									0						0					0	0	0	0
174									0						0					0	0	0	0
175									0						0					0	0	0	0
176									0						0					0	0	0	0
177									0						0					0	0	0	0
178									0						0					0	0	0	0
179									0						0					0	0	0	0
180									0						0					0	0	0	0
181									0						0					0	0	0	0
182									0						0					0	0	0	0
183									0						0					0	0	0	0
184									0						0					0	0	0	0
185									0						0					0	0	0	0
186									0						0					0	0	0	0
187									0						0					0	0	0	0
188									0						0					0	0	0	0
189									0						0					0	0	0	0
190									0						0					0	0	0	0
191									0						0					0	0	0	0
192									0						0					0	0	0	0
193									0						0					0	0	0	0
194									0						0					0	0	0	0
195									0						0					0	0	0	0
196									0						0					0	0	0	0
197									0						0					0	0	0	0
198									0						0					0	0	0	0
199									0						0					0	0	0	0
200									0						0					0	0	0	0


1	Dan Nagy Memorial NS Boys SL								UPDATED FORMULAS	Adjust forumla if needed	Adjust forumla if needed	Adjust forumla if needed		Quality Control Checks			time				rank in category
2	Slalom (U8-U16 / Men)									ID	Category (u8, u10...)	Time	ID on Summary?	Check Name (shows as listed on summary, differences highlighted)	Check Age Category (shows as listed on summary)	Rank in Category	U08	U10	U12	U14	U08	U10	U12	U14
3	Run Ranking 1																									Copy source data starting at Column A (don't go beyond Column O)
4										0						0					0	0	0	0		Check that the formula in Column P refers to ID; change it if needed
5	Rank	Bib	USA ID	Name	Category	Club	Time			#VALUE!	Category	Time				0					0	0	0	0	USA ID Name Category Club	Check that the formula in Column Q gives Category (U14, U12...). If Category isn't in the source data, use the formula below to get it from Year
6										0						0					0	0	0	0		Check that the forumla in Column R refers to the time column; change it if needed.
7										0						0					0	0	0	0		Make sure that any times greater than a minute (1:00.0) are converting to seconds properly in Column R
8	Category: U8									0						0					0	0	0	0		Check that names are as expected
9	1	62	C7140797	Marchesi Milo	U08	BKH	55.48			7140797	U08	55.48	TRUE	Marchesi Milo	U08	1	55.48				1	0	0	0		Check that all the Region 1 racers IDs are on Summary. If the ID should be in the summary but it's not -- add it.
10	2	5	C7102519	Peltz Reid	U08	BKH	61.21			7102519	U08	61.21	TRUE	Peltz Reid	U08	2	61.21				2	0	0	0		Check that rankings in category look correct (Rank In Category is in Column U; the summary tab looks for it there)
11	3	4	C7012809	O'Grady Henryk	U08	AFT	63.21			7012809	U08	63.21	TRUE	O'Grady Henryk	U08	3	63.21				3	0	0	0		On the summary, copy the formula from a completed race to this race, but change the sheet name to match this tab
12	4	3	C7033941	Brunsvold Carter	U08	AFT	65.12			7033941	U08	65.12	TRUE	Brunsvold Carter	U08	4	65.12				4	0	0	0
13										0						0					0	0	0	0
14										0						0					0	0	0	0
15	Did Not Start (1)									0						0					0	0	0	0		Formula for Category if only Year, not Category, are given in the source data:
16		61	C7155010	Hinrichs Jack	U08	GIL				7155010	U08		TRUE	Hinrichs Jack	U08	0					0	0	0	0		=IFERROR(VLOOKUP(Value(E16),Category!$A$1:$B$8,2,0),"")
17										0						0					0	0	0	0
18										0						0					0	0	0	0
19	Disqualified (1)									0						0					0	0	0	0
20		1	C7086044	Benson Soren	U08	AFT	Rule MG			7086044	U08	Rule MG	TRUE	Benson Soren	U08	0	Rule MG				0	0	0	0
21										0						0					0	0	0	0
22										0						0					0	0	0	0
23	Category: U10									0						0					0	0	0	0
24	1	20	C6679237	Titler Teddy	U10	BKH	39.51			6679237	U10	39.51	TRUE	Titler Teddy	U10	1		39.51			0	1	0	0
25	2	7	C7035289	Rambow Magnus	U10	FST	41.96			7035289	U10	41.96	TRUE	Rambow Magnus	U10	2		41.96			0	2	0	0
26	3	18	C6931622	Houle John Luc	U10	AFT	42.44			6931622	U10	42.44	TRUE	Houle John Luc	U10	3		42.44			0	3	0	0
27	4	68	C6886340	Harrington Mickelson	U10	CNT	43.47			6886340	U10	43.47				0					0	0	0	0	C6886340 Harrington Mickelson U10 CNT
28	5	14	C6903702	Stinnett Jack	U10	BKH	45.55			6903702	U10	45.55	TRUE	Stinnett Jack	U10	4		45.55			0	4	0	0
29	6	19	C7012176	Simon Spencer	U10	GIL	48.34			7012176	U10	48.34	TRUE	Simon Spencer	U10	5		48.34			0	5	0	0
30	7	8	C7106748	Underhill Viggo	U10	BKH	53.54			7106748	U10	53.54	TRUE	Underhill Viggo	U10	6		53.54			0	6	0	0
31	8	10	C7031191	Lodermeier Graham	U10	AFT	54.56			7031191	U10	54.56	TRUE	Lodermeier Graham	U10	7		54.56			0	7	0	0
32	9	9	C6933951	O'Grady Bohdan	U10	AFT	55.04			6933951	U10	55.04	TRUE	O'Grady Bohdan	U10	8		55.04			0	8	0	0
33	10	15	C7117542	Bristlin Rhys	U10	FST	57.49			7117542	U10	57.49	TRUE	Bristlin Rhys	U10	9		57.49			0	9	0	0
34	11	63	C7144398	Micko Dominic	U10	AFT	57.98	NEW		7144398	U10	57.98	TRUE	Micko Dominic	U10	10		57.98			0	10	0	0
35	12	66	C6926387	Scharrer Torsten	U10	BKH	58.52			6926387	U10	58.52	TRUE	Scharrer Torsten	U10	11		58.52			0	11	0	0
36	13	17	C7091437	Saewert Otto	U10	GIL	58.87			7091437	U10	58.87	TRUE	Saewert Otto	U10	12		58.87			0	12	0	0
37	14	13	C7083495	Miller Ryder	U10	BKH	61.53			7083495	U10	61.53	TRUE	Miller Ryder	U10	13		61.53			0	13	0	0
38	15	6	C7118379	Knadle Parker	U10		75.41			7118379	U10	75.41				0					0	0	0	0	C7118379 Knadle Parker U10
39										0						0					0	0	0	0
40										0						0					0	0	0	0
41	Did Not Start (3)									0						0					0	0	0	0
42		16	C6938427	Moore Tait	U10	CAR				6938427	U10					0					0	0	0	0	C6938427 Moore Tait U10 CAR
43		64	C6845605	Hazzard Henry	U10	CNT				6845605	U10					0					0	0	0	0	C6845605 Hazzard Henry U10 CNT
44		65	C6845610	Hazzard Johnny	U10	CNT				6845610	U10					0					0	0	0	0	C6845610 Hazzard Johnny U10 CNT
45										0						0					0	0	0	0
46										0						0					0	0	0	0
47	Disqualified (1)									0						0					0	0	0	0
48		21	C7013674	Molinaro Peter	U10	AFT	Rule MG			7013674	U10	Rule MG	TRUE	Molinaro Peter	U10	0		Rule MG			0	0	0	0
49										0						0					0	0	0	0
50										0						0					0	0	0	0
51	Category: U12									0						0					0	0	0	0
52	1	23	C6941815	Pope Reed	U12	FST	37.18			6941815	U12	37.18	TRUE	Pope Reed	U12	1			37.18		0	0	1	0
53	2	56	C6679153	Mjanger Luke	U12	AFT	37.34			6679153	U12	37.34	TRUE	Mjanger Luke	U12	2			37.34		0	0	2	0
54	3	60	C6983174	Peltz Cole	U12	BKH	37.54			6983174	U12	37.54	TRUE	Peltz Cole	U12	3			37.54		0	0	3	0
55	4	76	C6884860	Carpenter Ty	U12	LKR	37.55	R2		6884860	U12	37.55				0					0	0	0	0	C6884860 Carpenter Ty U12 LKR
56	5	52	C6678643	Levander Everett	U12	AFT	37.89			6678643	U12	37.89	TRUE	Levander Everett	U12	4			37.89		0	0	4	0
57	6	41	X6751067	Zadvornykh Roman	U12	BKH	38.97			6751067	U12	38.97	TRUE	Zadvornykh Roman	U12	5			38.97		0	0	5	0
58	7	72	C6867501	Nelson Jacob	U12	SWA	39.05	R2		6867501	U12	39.05				0					0	0	0	0	C6867501 Nelson Jacob U12 SWA
59	8	35	C6778054	Burns William	U12	AFT	39.27			6778054	U12	39.27	TRUE	Burns William	U12	6			39.27		0	0	6	0
60	9	74	C6953275	Hopke Brexten	U12	BKH	39.9			6953275	U12	39.90	TRUE	Hopke Brexten	U12	7			39.90		0	0	7	0
61	10	88	C6821645	Daams Van	U12	SWA	41.21	R2		6821645	U12	41.21				0					0	0	0	0	C6821645 Daams Van U12 SWA
62	11	27	C6824610	Moore Aleksander	U12	CAR	41.8	R2		6824610	U12	41.80				0					0	0	0	0	C6824610 Moore Aleksander U12 CAR
63	12	57	C6779490	Schaeppi Asa	U12	BKH	41.88			6779490	U12	41.88	TRUE	Schaeppi Asa	U12	8			41.88		0	0	8	0
64	13	81	C7090610	Ruoho Jack	U12	BKH	43.94			7090610	U12	43.94	TRUE	Ruoho Jack	U12	9			43.94		0	0	9	0
65	14	25	C7032006	Geelan Jack	U12	GIL	44.52			7032006	U12	44.52	TRUE	Geelan Jack	U12	10			44.52		0	0	10	0
66	15	87	C7017726	Anderson Logan	U12	CAR	44.84	R2		7017726	U12	44.84				0					0	0	0	0	C7017726 Anderson Logan U12 CAR
67	16	40	C7144570	Hinrichs Ben	U12	GIL	45.45			7144570	U12	45.45	TRUE	Hinrichs Ben	U12	11			45.45		0	0	11	0
68	17	75	C7062602	Eiseman Ivar	U12	SWA	45.72	R2		7062602	U12	45.72				0					0	0	0	0	C7062602 Eiseman Ivar U12 SWA
69	18	30	C6970496	Barbeau Avery	U12	FST	45.99			6970496	U12	45.99	TRUE	Barbeau Avery	U12	12			45.99		0	0	12	0
70	19	48	C6983375	Demars Milo	U12	FST	46.2			6983375	U12	46.20	TRUE	Demars Milo	U12	13			46.20		0	0	13	0
71	20	46	C7018104	Lee Keya	U12	CAR	46.51	R2		7018104	U12	46.51				0					0	0	0	0	C7018104 Lee Keya U12 CAR
72	21	54	C7103072	King-Ellison Roenen	U12	BKH	47.65			7103072	U12	47.65	TRUE	King-Ellison Roenen	U12	14			47.65		0	0	14	0
73	22	45	C7003414	Glancy Liam	U12	AFT	48.03			7003414	U12	48.03	TRUE	Glancy Liam	U12	15			48.03		0	0	15	0
74	23	33	C6938468	Dahl Jackson	U12	CAR	48.52	R2		6938468	U12	48.52				0					0	0	0	0	C6938468 Dahl Jackson U12 CAR
75	24	49	C7086207	Johnson Caden	U12	AFT	49.66			7086207	U12	49.66	TRUE	Johnson Caden	U12	16			49.66		0	0	16	0
76	25	83	C7142995	Hagen Tommy	U12	GIL	49.85			7142995	U12	49.85	TRUE	Hagen Tommy	U12	17			49.85		0	0	17	0
77	26	84	C7115799	Mallery Rigby	U12	GIL	50.94			7115799	U12	50.94	TRUE	Mallery Rigby	U12	18			50.94		0	0	18	0
78	26	34	C6944248	Kim Charlie	U12	GIL	50.94			6944248	U12	50.94	TRUE	Kim Charlie	U12	18			50.94		0	0	18	0
79	28	85	C6771406	Cryer Carson	U12	BKH	52.57			6771406	U12	52.57	TRUE	Cryer Carson	U12	20			52.57		0	0	20	0
80	29	80	C6823843	Byrnes Thomas	U12	MAD	53.65	R2		6823843	U12	53.65				0					0	0	0	0	C6823843 Byrnes Thomas U12 MAD
81	30	28	C7103128	Grandell Nelson	U12	GIL	53.7			7103128	U12	53.70	TRUE	Grandell Nelson	U12	21			53.70		0	0	21	0
82	31	59	C7012913	Halverson Chase	U12	AFT	54.32			7012913	U12	54.32	TRUE	Halverson Chase	U12	22			54.32		0	0	22	0
83	32	79	C7107847	Marthaler Donek	U12	BKH	54.95			7107847	U12	54.95	TRUE	Marthaler Donek	U12	23			54.95		0	0	23	0
84	33	22	C7021691	Kyle Jackson	U12	GIL	55.35			7021691	U12	55.35	TRUE	Kyle Jackson	U12	24			55.35		0	0	24	0
85	34	31	C6926242	Brown Griffin	U12	GIL	56.66			6926242	U12	56.66	TRUE	Brown Griffin	U12	25			56.66		0	0	25	0
86	35	50	C6944250	Jakobe Benjamin	U12	GIL	57.7			6944250	U12	57.70	TRUE	Jakobe Benjamin	U12	26			57.70		0	0	26	0
87	36	82	C7076592	Coutre Mason	U12	MAD	60.2	R2		7076592	U12	60.20				0					0	0	0	0	C7076592 Coutre Mason U12 MAD
88	37	53	C7144247	Johhnson Eli	U12	GIL	60.57			7144247	U12	60.57	TRUE	Johhnson Eli	U12	27			60.57		0	0	27	0
89	38	29	C7099664	Radner Cole	U12	BKH	60.93			7099664	U12	60.93	TRUE	Radner Cole	U12	28			60.93		0	0	28	0
90	39	73	C7135036	Balsimo Micco	U12	GIL	63.22			7135036	U12	63.22	TRUE	Balsimo Micco	U12	29			63.22		0	0	29	0
91										0						0					0	0	0	0
92										0						0					0	0	0	0
93	Did Not Start (4)									0						0					0	0	0	0
94		24	C7107538	Krause Aden	U12	AFT				7107538	U12		TRUE	Krause Aden	U12	0					0	0	0	0
95		38	C6944207	Larson Finn	U12	GIL				6944207	U12		TRUE	Larson Finn	U12	0					0	0	0	0
96		43	R6712468	Campian Alexander	U12	SUM		Rocky		6712468	U12					0					0	0	0	0	R6712468 Campian Alexander U12 SUM
97		44	C7145532	Johnson Kolt	U12	DUL				7145532	U12		TRUE	Johnson Kolt	U12	0					0	0	0	0
98										0						0					0	0	0	0
99										0						0					0	0	0	0
100	Did Not Finish (3)									0						0					0	0	0	0
101		42	C6952905	Johnson Soren	U12	BKH				6952905	U12		TRUE	Johnson Soren	U12	0					0	0	0	0
102		70	C6898335	Britton Kobe	U12			R2		6898335	U12					0					0	0	0	0	C6898335 Britton Kobe U12
103		77	C7106837	Underhill Griffin	U12	BKH		NEW		7106837	U12		TRUE	Underhill Griffin	U12	0					0	0	0	0
104										0						0					0	0	0	0
105										0						0					0	0	0	0
106	Disqualified (1)									0						0					0	0	0	0
107		78	C6905066	Hausmann Carter	U12	ASB	Rule MG	R2		6905066	U12	Rule MG				0					0	0	0	0	C6905066 Hausmann Carter U12 ASB
108										0						0					0	0	0	0
109										0						0					0	0	0	0
110										0						0					0	0	0	0
111										0						0					0	0	0	0
112										0						0					0	0	0	0
113										0						0					0	0	0	0
114										0						0					0	0	0	0
115										0						0					0	0	0	0
116										0						0					0	0	0	0
117										0						0					0	0	0	0
118										0						0					0	0	0	0
119										0						0					0	0	0	0
120										0						0					0	0	0	0
121										0						0					0	0	0	0
122										0						0					0	0	0	0
123										0						0					0	0	0	0
124										0						0					0	0	0	0
125										0						0					0	0	0	0
126										0						0					0	0	0	0
127										0						0					0	0	0	0
128										0						0					0	0	0	0
129										0						0					0	0	0	0
130										0						0					0	0	0	0
131										0						0					0	0	0	0
132										0						0					0	0	0	0
133										0						0					0	0	0	0
134										0						0					0	0	0	0
135										0						0					0	0	0	0
136										0						0					0	0	0	0
137										0						0					0	0	0	0
138										0						0					0	0	0	0
139										0						0					0	0	0	0
140										0						0					0	0	0	0
141										0						0					0	0	0	0
142										0						0					0	0	0	0
143										0						0					0	0	0	0
144										0						0					0	0	0	0
145										0						0					0	0	0	0
146										0						0					0	0	0	0
147										0						0					0	0	0	0
148										0						0					0	0	0	0
149										0						0					0	0	0	0
150										0						0					0	0	0	0
151										0						0					0	0	0	0
152										0						0					0	0	0	0
153										0						0					0	0	0	0
154										0						0					0	0	0	0
155										0						0					0	0	0	0
156										0						0					0	0	0	0
157										0						0					0	0	0	0
158										0						0					0	0	0	0
159										0						0					0	0	0	0
160										0						0					0	0	0	0
161										0						0					0	0	0	0
162										0						0					0	0	0	0
163										0						0					0	0	0	0
164										0						0					0	0	0	0
165										0						0					0	0	0	0
166										0						0					0	0	0	0
167										0						0					0	0	0	0
168										0						0					0	0	0	0
169										0						0					0	0	0	0
170										0						0					0	0	0	0
171										0						0					0	0	0	0
172										0						0					0	0	0	0
173										0						0					0	0	0	0
174										0						0					0	0	0	0
175										0						0					0	0	0	0
176										0						0					0	0	0	0
177										0						0					0	0	0	0
178										0						0					0	0	0	0
179										0						0					0	0	0	0
180										0						0					0	0	0	0
181										0						0					0	0	0	0
182										0						0					0	0	0	0
183										0						0					0	0	0	0
184										0						0					0	0	0	0
185										0						0					0	0	0	0
186										0						0					0	0	0	0
187										0						0					0	0	0	0
188										0						0					0	0	0	0
189										0						0					0	0	0	0
190										0						0					0	0	0	0
191										0						0					0	0	0	0
192										0						0					0	0	0	0
193										0						0					0	0	0	0
194										0						0					0	0	0	0
195										0						0					0	0	0	0
196										0						0					0	0	0	0
197										0						0					0	0	0	0
198										0						0					0	0	0	0
199										0						0					0	0	0	0
200										0						0					0	0	0	0


1	Dan Nagy Memorial NS Boys GS								UPDATED FORMULAS	Adjust forumla if needed	Adjust forumla if needed	Adjust forumla if needed		Quality Control Checks			time				rank in category
2	Giant Slalom (U8-U16 / Men)									ID	Category (u8, u10...)	Time	ID on Summary?	Check Name (shows as listed on summary, differences highlighted)	Check Age Category (shows as listed on summary)	Rank in Category	U08	U10	U12	U14	U08	U10	U12	U14
3	Run Ranking 1																									Copy source data starting at Column A (don't go beyond Column O)
4										0						0					0	0	0	0		Check that the formula in Column P refers to ID; change it if needed
5	Rank	Bib	USA ID	Name	Category	Club	Time			#VALUE!	Category	Time				0					0	0	0	0	USA ID Name Category Club	Check that the formula in Column Q gives Category (U14, U12...). If Category isn't in the source data, use the formula below to get it from Year
6										0						0					0	0	0	0		Check that the forumla in Column R refers to the time column; change it if needed.
7										0						0					0	0	0	0		Make sure that any times greater than a minute (1:00.0) are converting to seconds properly in Column R
8	Category: U8									0						0					0	0	0	0		Check that names are as expected
9	1	62	C7140797	Marchesi Milo	U08	BKH	49.16			7140797	U08	49.16	TRUE	Marchesi Milo	U08	1	49.16				1	0	0	0		Check that all the Region 1 racers IDs are on Summary. If the ID should be in the summary but it's not -- add it.
10	2	3	C7033941	Brunsvold Carter	U08	AFT	53.94			7033941	U08	53.94	TRUE	Brunsvold Carter	U08	2	53.94				2	0	0	0		Check that rankings in category look correct (Rank In Category is in Column U; the summary tab looks for it there)
11	3	1	C7086044	Benson Soren	U08	AFT	56.74			7086044	U08	56.74	TRUE	Benson Soren	U08	3	56.74				3	0	0	0		On the summary, copy the formula from a completed race to this race, but change the sheet name to match this tab
12	4	5	C7102519	Peltz Reid	U08	BKH	58.43			7102519	U08	58.43	TRUE	Peltz Reid	U08	4	58.43				4	0	0	0
13	5	4	C7012809	O'Grady Henryk	U08	AFT	60			7012809	U08	60.00	TRUE	O'Grady Henryk	U08	5	60.00				5	0	0	0
14										0						0					0	0	0	0
15										0						0					0	0	0	0		Formula for Category if only Year, not Category, are given in the source data:
16	Did Not Start (1)									0						0					0	0	0	0		=IFERROR(VLOOKUP(Value(E16),Category!$A$1:$B$8,2,0),"")
17		61	C7155010	Hinrichs Jack	U08			NEW		7155010	U08		TRUE	Hinrichs Jack	U08	0					0	0	0	0
18										0						0					0	0	0	0
19										0						0					0	0	0	0
20	Category: U10									0						0					0	0	0	0
21	1	68	C6886340	Harrington Mickelson	U10	CNT	40.66			6886340	U10	40.66				0					0	0	0	0	C6886340 Harrington Mickelson U10 CNT
22	2	18	C6931622	Houle John Luc	U10	AFT	42.17			6931622	U10	42.17	TRUE	Houle John Luc	U10	1		42.17			0	1	0	0
23	3	20	C6679237	Titler Teddy	U10	BKH	42.57			6679237	U10	42.57	TRUE	Titler Teddy	U10	2		42.57			0	2	0	0
24	4	6	C7118379	Knadle Parker	U10		42.86			7118379	U10	42.86				0					0	0	0	0	C7118379 Knadle Parker U10
25	5	7	C7035289	Rambow Magnus	U10	FST	43.83			7035289	U10	43.83	TRUE	Rambow Magnus	U10	3		43.83			0	3	0	0
26	6	64	C6845605	Hazzard Henry	U10	CNT	45.43			6845605	U10	45.43				0					0	0	0	0	C6845605 Hazzard Henry U10 CNT
27	7	21	C7013674	Molinaro Peter	U10	AFT	45.78			7013674	U10	45.78	TRUE	Molinaro Peter	U10	4		45.78			0	4	0	0
28	8	67	C7026296	Peret Jax	U10	LKR	46.19			7026296	U10	46.19				0					0	0	0	0	C7026296 Peret Jax U10 LKR
29	9	19	C7012176	Simon Spencer	U10	GIL	46.49			7012176	U10	46.49	TRUE	Simon Spencer	U10	5		46.49			0	5	0	0
30	10	16	C6938427	Moore Tait	U10	CAR	47.95			6938427	U10	47.95				0					0	0	0	0	C6938427 Moore Tait U10 CAR
31	11	10	C7031191	Lodermeier Graham	U10	AFT	48.38			7031191	U10	48.38	TRUE	Lodermeier Graham	U10	6		48.38			0	6	0	0
32	12	8	C7106748	Underhill Viggo	U10	BKH	48.9			7106748	U10	48.90	TRUE	Underhill Viggo	U10	7		48.90			0	7	0	0
33	13	69	C7027224	Wilke W.	U10	LKR	51.66			7027224	U10	51.66				0					0	0	0	0	C7027224 Wilke W. U10 LKR
34	14	66	C6926387	Scharrer Torsten	U10	BKH	53.59			6926387	U10	53.59	TRUE	Scharrer Torsten	U10	8		53.59			0	8	0	0
35	15	9	C6933951	O'Grady Bohdan	U10	AFT	54.16			6933951	U10	54.16	TRUE	O'Grady Bohdan	U10	9		54.16			0	9	0	0
36	16	15	C7117542	Bristlin Rhys	U10	FST	55.54			7117542	U10	55.54	TRUE	Bristlin Rhys	U10	10		55.54			0	10	0	0
37	17	17	C7091437	Saewert Otto	U10	GIL	55.65			7091437	U10	55.65	TRUE	Saewert Otto	U10	11		55.65			0	11	0	0
38	18	63	C7144398	Micko Dominic	U10	AFT	56.37	NEW		7144398	U10	56.37	TRUE	Micko Dominic	U10	12		56.37			0	12	0	0
39	19	13	C7083495	Miller Ryder	U10	BKH	56.88			7083495	U10	56.88	TRUE	Miller Ryder	U10	13		56.88			0	13	0	0
40										0						0					0	0	0	0
41										0						0					0	0	0	0
42	Did Not Finish (2)									0						0					0	0	0	0
43		14	C6903702	Stinnett Jack	U10	BKH				6903702	U10		TRUE	Stinnett Jack	U10	0					0	0	0	0
44		65	C6845610	Hazzard Johnny	U10	CNT				6845610	U10					0					0	0	0	0	C6845610 Hazzard Johnny U10 CNT
45										0						0					0	0	0	0
46										0						0					0	0	0	0
47	Category: U12									0						0					0	0	0	0
48	1	76	C6884860	Carpenter Ty	U12	LKR	37.21			6884860	U12	37.21				0					0	0	0	0	C6884860 Carpenter Ty U12 LKR
49	2	23	C6941815	Pope Reed	U12	FST	37.53			6941815	U12	37.53	TRUE	Pope Reed	U12	1			37.53		0	0	1	0
50	3	74	C6953275	Hopke Brexten	U12	BKH	37.67			6953275	U12	37.67	TRUE	Hopke Brexten	U12	2			37.67		0	0	2	0
51	4	56	C6679153	Mjanger Luke	U12	AFT	38.21			6679153	U12	38.21	TRUE	Mjanger Luke	U12	3			38.21		0	0	3	0
52	5	72	C6867501	Nelson Jacob	U12	SWA	38.37			6867501	U12	38.37				0					0	0	0	0	C6867501 Nelson Jacob U12 SWA
53	6	52	C6678643	Levander Everett	U12	AFT	38.46			6678643	U12	38.46	TRUE	Levander Everett	U12	4			38.46		0	0	4	0
54	7	41	X6751067	Zadvornykh Roman	U12	BKH	38.47			6751067	U12	38.47	TRUE	Zadvornykh Roman	U12	5			38.47		0	0	5	0
55	8	27	C6824610	Moore Aleksander	U12	CAR	38.55			6824610	U12	38.55				0					0	0	0	0	C6824610 Moore Aleksander U12 CAR
56	9	35	C6778054	Burns William	U12	AFT	39.51			6778054	U12	39.51	TRUE	Burns William	U12	6			39.51		0	0	6	0
57	10	86	C6920544	Katzfuss Mason	U12	ASB	40.47			6920544	U12	40.47				0					0	0	0	0	C6920544 Katzfuss Mason U12 ASB
58	11	88	C6821645	Daams Van	U12	SWA	40.78			6821645	U12	40.78				0					0	0	0	0	C6821645 Daams Van U12 SWA
59	12	78	C6905066	Hausmann Carter	U12	ASB	41.14			6905066	U12	41.14				0					0	0	0	0	C6905066 Hausmann Carter U12 ASB
60	13	57	C6779490	Schaeppi Asa	U12	BKH	41.57			6779490	U12	41.57	TRUE	Schaeppi Asa	U12	7			41.57		0	0	7	0
61	14	60	C6983174	Peltz Cole	U12	BKH	41.73			6983174	U12	41.73	TRUE	Peltz Cole	U12	8			41.73		0	0	8	0
62	15	81	C7090610	Ruoho Jack	U12	BKH	41.92			7090610	U12	41.92	TRUE	Ruoho Jack	U12	9			41.92		0	0	9	0
63	16	46	C7018104	Lee Keya	U12	CAR	41.94			7018104	U12	41.94				0					0	0	0	0	C7018104 Lee Keya U12 CAR
64	17	48	C6983375	Demars Milo	U12	FST	41.99			6983375	U12	41.99	TRUE	Demars Milo	U12	10			41.99		0	0	10	0
65	18	87	C7017726	Anderson Logan	U12	CAR	42.82			7017726	U12	42.82				0					0	0	0	0	C7017726 Anderson Logan U12 CAR
66	19	40	C7144570	Hinrichs Ben	U12	GIL	43.18			7144570	U12	43.18	TRUE	Hinrichs Ben	U12	11			43.18		0	0	11	0
67	20	85	C6771406	Cryer Carson	U12	BKH	43.32			6771406	U12	43.32	TRUE	Cryer Carson	U12	12			43.32		0	0	12	0
68	21	54	C7103072	King-Ellison Roenen	U12	BKH	43.51			7103072	U12	43.51	TRUE	King-Ellison Roenen	U12	13			43.51		0	0	13	0
69	22	42	C6952905	Johnson Soren	U12	BKH	43.58			6952905	U12	43.58	TRUE	Johnson Soren	U12	14			43.58		0	0	14	0
70	23	75	C7062602	Eiseman Ivar	U12	SWA	43.64			7062602	U12	43.64				0					0	0	0	0	C7062602 Eiseman Ivar U12 SWA
71	24	33	C6938468	Dahl Jackson	U12	CAR	44.01			6938468	U12	44.01				0					0	0	0	0	C6938468 Dahl Jackson U12 CAR
72	25	25	C7032006	Geelan Jack	U12	GIL	44.35			7032006	U12	44.35	TRUE	Geelan Jack	U12	15			44.35		0	0	15	0
73	26	49	C7086207	Johnson Caden	U12	AFT	45.97			7086207	U12	45.97	TRUE	Johnson Caden	U12	16			45.97		0	0	16	0
74	27	34	C6944248	Kim Charlie	U12	GIL	46			6944248	U12	46.00	TRUE	Kim Charlie	U12	17			46.00		0	0	17	0
75	28	77	C7106837	Underhill Griffin	U12	BKH	46.01	NEW		7106837	U12	46.01	TRUE	Underhill Griffin	U12	18			46.01		0	0	18	0
76	29	30	C6970496	Barbeau Avery	U12	FST	46.1			6970496	U12	46.10	TRUE	Barbeau Avery	U12	19			46.10		0	0	19	0
77	30	45	C7003414	Glancy Liam	U12	AFT	46.43			7003414	U12	46.43	TRUE	Glancy Liam	U12	20			46.43		0	0	20	0
78	31	59	C7012913	Halverson Chase	U12	AFT	46.8			7012913	U12	46.80	TRUE	Halverson Chase	U12	21			46.80		0	0	21	0
79	32	37	C7129523	Barott Laken	U12	FST	47.26			7129523	U12	47.26	TRUE	Barott Laken	U12	22			47.26		0	0	22	0
80	33	83	C7142995	Hagen Tommy	U12	GIL	48.61			7142995	U12	48.61	TRUE	Hagen Tommy	U12	23			48.61		0	0	23	0
81	34	28	C7103128	Grandell Nelson	U12	GIL	49.45			7103128	U12	49.45	TRUE	Grandell Nelson	U12	24			49.45		0	0	24	0
82	35	80	C6823843	Byrnes Thomas	U12	MAD	49.82			6823843	U12	49.82				0					0	0	0	0	C6823843 Byrnes Thomas U12 MAD
83	36	79	C7107847	Marthaler Donek	U12	BKH	50.24			7107847	U12	50.24	TRUE	Marthaler Donek	U12	25			50.24		0	0	25	0
84	37	82	C7076592	Coutre Mason	U12	MAD	50.4			7076592	U12	50.40				0					0	0	0	0	C7076592 Coutre Mason U12 MAD
85	38	29	C7099664	Radner Cole	U12	BKH	51.07			7099664	U12	51.07	TRUE	Radner Cole	U12	26			51.07		0	0	26	0
86	39	31	C6926242	Brown Griffin	U12	GIL	51.92			6926242	U12	51.92	TRUE	Brown Griffin	U12	27			51.92		0	0	27	0
87	40	53	C7144247	Johhnson Eli	U12	GIL	55.57			7144247	U12	55.57	TRUE	Johhnson Eli	U12	28			55.57		0	0	28	0
88										0						0					0	0	0	0
89										0						0					0	0	0	0
90	Did Not Start (6)									0						0					0	0	0	0
91		22	C7021691	Kyle Jackson	U12	GIL				7021691	U12		TRUE	Kyle Jackson	U12	0					0	0	0	0
92		38	C6944207	Larson Finn	U12	GIL				6944207	U12		TRUE	Larson Finn	U12	0					0	0	0	0
93		43	R6712468	Campian Alexander	U12	SUM				6712468	U12					0					0	0	0	0	R6712468 Campian Alexander U12 SUM
94		44	C7145532	Johnson Kolt	U12	DUL				7145532	U12		TRUE	Johnson Kolt	U12	0					0	0	0	0
95		71	C7131417	Bury Patryk	U12	SWA				7131417	U12					0					0	0	0	0	C7131417 Bury Patryk U12 SWA
96		84	C7115799	Mallery Rigby	U12	GIL				7115799	U12		TRUE	Mallery Rigby	U12	0					0	0	0	0
97										0						0					0	0	0	0
98										0						0					0	0	0	0
99	Did Not Finish (3)									0						0					0	0	0	0
100		24	C7107538	Krause Aden	U12	AFT				7107538	U12		TRUE	Krause Aden	U12	0					0	0	0	0
101		50	C6944250	Jakobe Benjamin	U12	GIL				6944250	U12		TRUE	Jakobe Benjamin	U12	0					0	0	0	0
102		70	C6898335	Britton Kobe	U12					6898335	U12					0					0	0	0	0	C6898335 Britton Kobe U12
103										0						0					0	0	0	0
104										0						0					0	0	0	0
105										0						0					0	0	0	0
106	Disqualified (1)									0						0					0	0	0	0
107		78	C6905066	Hausmann Carter	U12	ASB	Rule MG			6905066	U12	Rule MG				0					0	0	0	0	C6905066 Hausmann Carter U12 ASB
108										0						0					0	0	0	0
109										0						0					0	0	0	0
110										0						0					0	0	0	0
111										0						0					0	0	0	0
112										0						0					0	0	0	0
113										0						0					0	0	0	0
114										0						0					0	0	0	0
115										0						0					0	0	0	0
116										0						0					0	0	0	0
117										0						0					0	0	0	0
118										0						0					0	0	0	0
119										0						0					0	0	0	0
120										0						0					0	0	0	0
121										0						0					0	0	0	0
122										0						0					0	0	0	0
123										0						0					0	0	0	0
124										0						0					0	0	0	0
125										0						0					0	0	0	0
126										0						0					0	0	0	0
127										0						0					0	0	0	0
128										0						0					0	0	0	0
129										0						0					0	0	0	0
130										0						0					0	0	0	0
131										0						0					0	0	0	0
132										0						0					0	0	0	0
133										0						0					0	0	0	0
134										0						0					0	0	0	0
135										0						0					0	0	0	0
136										0						0					0	0	0	0
137										0						0					0	0	0	0
138										0						0					0	0	0	0
139										0						0					0	0	0	0
140										0						0					0	0	0	0
141										0						0					0	0	0	0
142										0						0					0	0	0	0
143										0						0					0	0	0	0
144										0						0					0	0	0	0
145										0						0					0	0	0	0
146										0						0					0	0	0	0
147										0						0					0	0	0	0
148										0						0					0	0	0	0
149										0						0					0	0	0	0
150										0						0					0	0	0	0
151										0						0					0	0	0	0
152										0						0					0	0	0	0
153										0						0					0	0	0	0
154										0						0					0	0	0	0
155										0						0					0	0	0	0
156										0						0					0	0	0	0
157										0						0					0	0	0	0
158										0						0					0	0	0	0
159										0						0					0	0	0	0
160										0						0					0	0	0	0
161										0						0					0	0	0	0
162										0						0					0	0	0	0
163										0						0					0	0	0	0
164										0						0					0	0	0	0
165										0						0					0	0	0	0
166										0						0					0	0	0	0
167										0						0					0	0	0	0
168										0						0					0	0	0	0
169										0						0					0	0	0	0
170										0						0					0	0	0	0
171										0						0					0	0	0	0
172										0						0					0	0	0	0
173										0						0					0	0	0	0
174										0						0					0	0	0	0
175										0						0					0	0	0	0
176										0						0					0	0	0	0
177										0						0					0	0	0	0
178										0						0					0	0	0	0
179										0						0					0	0	0	0
180										0						0					0	0	0	0
181										0						0					0	0	0	0
182										0						0					0	0	0	0
183										0						0					0	0	0	0
184										0						0					0	0	0	0
185										0						0					0	0	0	0
186										0						0					0	0	0	0
187										0						0					0	0	0	0
188										0						0					0	0	0	0
189										0						0					0	0	0	0
190										0						0					0	0	0	0
191										0						0					0	0	0	0
192										0						0					0	0	0	0
193										0						0					0	0	0	0
194										0						0					0	0	0	0
195										0						0					0	0	0	0
196										0						0					0	0	0	0
197										0						0					0	0	0	0
198										0						0					0	0	0	0
199										0						0					0	0	0	0
200										0						0					0	0	0	0


1	Powder Ridge Non-Scored Race								UPDATED FORMULAS	Adjust forumla if needed	Adjust forumla if needed	Adjust forumla if needed		Quality Control Checks			time				rank in category
2	Slalom (U8-U16 / Men)									ID	Category (u8, u10...)	Time	ID on Summary?	Check Name (shows as listed on summary, differences highlighted)	Check Age Category (shows as listed on summary)	Rank in Category	U08	U10	U12	U14	U08	U10	U12	U14
3	Run Ranking 1																									Copy source data starting at Column A (don't go beyond Column O)
4										0						0					0	0	0	0		Check that the formula in Column P refers to ID; change it if needed
5	Rank	Bib	USA ID	Name	Category	Club	Time			#VALUE!	Category	Time				0					0	0	0	0	USA ID Name Category Club	Check that the formula in Column Q gives Category (U14, U12...). If Category isn't in the source data, use the formula below to get it from Year

6	1	52	C6678643	Levander Everett	U12	AFT	27.76			6678643	U12	27.76	TRUE	Levander Everett	U12	1			27.76		0	0	1	0		Check that the forumla in Column R refers to the time column; change it if needed.
7	2	41	X6751067	Zadvornykh Roman	U12	BKH	27.8			6751067	U12	27.80	TRUE	Zadvornykh Roman	U12	2			27.80		0	0	2	0		Make sure that any times greater than a minute (1:00.0) are converting to seconds properly in Column R
8	3	56	C6679153	Mjanger Luke	U12	AFT	28.43			6679153	U12	28.43	TRUE	Mjanger Luke	U12	3			28.43		0	0	3	0		Check that names are as expected
9	4	74	C6953275	Hopke Brexten	U12	BKH	28.99			6953275	U12	28.99	TRUE	Hopke Brexten	U12	4			28.99		0	0	4	0		Check that all the Region 1 racers IDs are on Summary. If the ID should be in the summary but it's not -- add it.
10	5	60	C6983174	Peltz Cole	U12	BKH	29.1			6983174	U12	29.10	TRUE	Peltz Cole	U12	5			29.10		0	0	5	0		Check that rankings in category look correct (Rank In Category is in Column U; the summary tab looks for it there)
11	6	20	C6679237	Titler Teddy	U10	BKH	29.76			6679237	U10	29.76	TRUE	Titler Teddy	U10	1		29.76			0	1	0	0		On the summary, copy the formula from a completed race to this race, but change the sheet name to match this tab
12	7	18	C6931622	Houle John Luc	U10	AFT	29.87			6931622	U10	29.87	TRUE	Houle John Luc	U10	2		29.87			0	2	0	0
13	8	39	C7002342	Sampson Reef	U12	FST	30.15			7002342	U12	30.15	TRUE	Sampson Reef	U12	6			30.15		0	0	6	0
14	9	35	C6778054	Burns William	U12	AFT	30.84			6778054	U12	30.84	TRUE	Burns William	U12	7			30.84		0	0	7	0
15	10	299	C6884860	Carpenter Ty	U12	LKR	31.4	R2		6884860	U12	31.40				0					0	0	0	0	C6884860 Carpenter Ty U12 LKR	Formula for Category if only Year, not Category, are given in the source data:
16	11	65	C7106837	Underhill Griffin	U12	BKH	32.12			7106837	U12	32.12	TRUE	Underhill Griffin	U12	8			32.12		0	0	8	0		=IFERROR(VLOOKUP(Value(E16),Category!$A$1:$B$8,2,0),"")
17	12	54	C7103072	King-Ellison Roenen	U12	BKH	33.21			7103072	U12	33.21	TRUE	King-Ellison Roenen	U12	9			33.21		0	0	9	0
18	13	14	C6903702	Stinnett Jack	U10	BKH	33.56			6903702	U10	33.56	TRUE	Stinnett Jack	U10	3		33.56			0	3	0	0
19	14	25	C7032006	Geelan Jack	U12	GIL	33.78			7032006	U12	33.78	TRUE	Geelan Jack	U12	10			33.78		0	0	10	0
20	15	81	C7090610	Ruoho Jack	U12	BKH	35.36			7090610	U12	35.36	TRUE	Ruoho Jack	U12	11			35.36		0	0	11	0
21	16	42	C6952905	Johnson Soren	U12	BKH	35.73			6952905	U12	35.73	TRUE	Johnson Soren	U12	12			35.73		0	0	12	0
22	17	30	C6970496	Barbeau Avery	U12	FST	35.96			6970496	U12	35.96	TRUE	Barbeau Avery	U12	13			35.96		0	0	13	0
23	18	57	C6779490	Schaeppi Asa	U12	BKH	36.08			6779490	U12	36.08	TRUE	Schaeppi Asa	U12	14			36.08		0	0	14	0
24	19	59	C7012913	Halverson Chase	U12	AFT	37.1			7012913	U12	37.10	TRUE	Halverson Chase	U12	15			37.10		0	0	15	0
25	20	51	X7022048	Negi Saivya	U12	GIL	37.27			7022048	U12	37.27	TRUE	Negi Saivya	U12	16			37.27		0	0	16	0
26	21	302	C6853961	Wohlrabe Collins	U12	GIL	37.32	xxx		6853961	U12	37.32	TRUE	Wohlrabe Collins	U12	17			37.32		0	0	17	0
27	22	50	C6944250	Jakobe Benjamin	U12	GIL	37.34			6944250	U12	37.34	TRUE	Jakobe Benjamin	U12	18			37.34		0	0	18	0
28	23	19	C7012176	Simon Spencer	U10	GIL	37.58			7012176	U10	37.58	TRUE	Simon Spencer	U10	4		37.58			0	4	0	0
29	24	28	C7103128	Grandell Nelson	U12	GIL	37.77			7103128	U12	37.77	TRUE	Grandell Nelson	U12	19			37.77		0	0	19	0
30	25	33	C7143146	Matchinsky Andrew	U12	GIL	37.94	xxx		7143146	U12	37.94	TRUE	Matchinsky Andrew	U12	20			37.94		0	0	20	0
31	26	23	C6941815	Pope Reed	U12	FST	38.49			6941815	U12	38.49	TRUE	Pope Reed	U12	21			38.49		0	0	21	0
32	27	53	C7144247	Johhnson Eli	U12	GIL	38.63			7144247	U12	38.63	TRUE	Johhnson Eli	U12	22			38.63		0	0	22	0
33	28	83	C7142995	Hagen Tommy	U12	GIL	38.72			7142995	U12	38.72	TRUE	Hagen Tommy	U12	23			38.72		0	0	23	0
34	29	31	C6926242	Brown Griffin	U12	GIL	38.78			6926242	U12	38.78	TRUE	Brown Griffin	U12	24			38.78		0	0	24	0
35	30	11	C7157857	Basgen Sullivan	U12	GIL	39.01	xxx		7157857	U12	39.01	TRUE	Basgen Sullivan	U12	25			39.01		0	0	25	0
36	31	9	C6933951	O'Grady Bohdan	U10	AFT	39.05			6933951	U10	39.05	TRUE	O'Grady Bohdan	U10	5		39.05			0	5	0	0
37	32	34	C6944248	Kim Charlie	U12	GIL	39.19			6944248	U12	39.19	TRUE	Kim Charlie	U12	26			39.19		0	0	26	0
38	33	55	C6773139	Richardson Sawyer	U12	GIL	39.73			6773139	U12	39.73	TRUE	Richardson Sawyer	U12	27			39.73		0	0	27	0
39	34	12	C7037253	Richardson Graham	U10	GIL	39.84			7037253	U10	39.84	TRUE	Richardson Graham	U10	6		39.84			0	6	0	0
40	35	45	C7003414	Glancy Liam	U12	AFT	40.13			7003414	U12	40.13	TRUE	Glancy Liam	U12	28			40.13		0	0	28	0
41	36	79	C7107847	Marthaler Donek	U12	BKH	40.65			7107847	U12	40.65	TRUE	Marthaler Donek	U12	29			40.65		0	0	29	0
42	37	61	C7086945	Monson Chase	U12	GIL	40.85			7086945	U12	40.85	TRUE	Monson Chase	U12	30			40.85		0	0	30	0
43	37	5	C7102519	Peltz Reid	U8	BKH	40.85			7102519	U08	40.85	TRUE	Peltz Reid	U08	1	40.85				1	0	0	0
44	39	47	C7091243	Margolin Samuel	U12	GIL	41.52			7091243	U12	41.52	TRUE	Margolin Samuel	U12	31			41.52		0	0	31	0
45	40	13	C7083495	Miller Ryder	U10	BKH	43			7083495	U10	43.00	TRUE	Miller Ryder	U10	7		43.00			0	7	0	0
46	41	37	C7129523	Barott Laken	U12	FST	43.48			7129523	U12	43.48	TRUE	Barott Laken	U12	32			43.48		0	0	32	0
47	42	36	C7091855	Swanke Ivan	U12	GIL	44.27			7091855	U12	44.27	TRUE	Swanke Ivan	U12	33			44.27		0	0	33	0
48	43	6	C7135036	Balsimo Micco	U12	GIL	44.52			7135036	U12	44.52	TRUE	Balsimo Micco	U12	34			44.52		0	0	34	0
49	44	27	C7145180	Chalekian Sullivan	U10	GIL	44.87	xx		7145180	U10	44.87	TRUE	Chalekian Sullivan	U10	8		44.87			0	8	0	0
50	45	319	C7166356	Maslev Rad	U10	GIL	44.88	xx		7166356	U10	44.88	TRUE	Maslev Rad	U10	9		44.88			0	9	0	0
51	46	62	C7140797	Marchesi Milo	U8	BKH	46.01			7140797	U08	46.01	TRUE	Marchesi Milo	U08	2	46.01				2	0	0	0
52	47	324	C7167238	Chou Emmett	U10	GIL	46.37	xx		7167238	U10	46.37	TRUE	Chou Emmett	U10	10		46.37			0	10	0	0
53	48	4	C7012809	O'Grady Henryk	U8	AFT	48.3			7012809	U08	48.30	TRUE	O'Grady Henryk	U08	3	48.30				3	0	0	0
54	49	1	C7086044	Benson Soren	U8	AFT	48.52			7086044	U08	48.52	TRUE	Benson Soren	U08	4	48.52				4	0	0	0
55	50	3	C7033941	Brunsvold Carter	U8	AFT	49.02			7033941	U08	49.02	TRUE	Brunsvold Carter	U08	5	49.02				5	0	0	0
56	51	17	C7091437	Saewert Otto	U10	GIL	49.36			7091437	U10	49.36	TRUE	Saewert Otto	U10	11		49.36			0	11	0	0
57	52	15	C7117542	Bristlin Rhys	U10	FST	49.62			7117542	U10	49.62	TRUE	Bristlin Rhys	U10	12		49.62			0	12	0	0
58										0						0					0	0	0	0
59										0						0					0	0	0	0
60	Did Not Start (2)									0						0					0	0	0	0
61		10	C7031191	Lodermeier Graham	U10	AFT				7031191	U10		TRUE	Lodermeier Graham	U10	0					0	0	0	0
62		22	C7021691	Kyle Jackson	U12	GIL				7021691	U12		TRUE	Kyle Jackson	U12	0					0	0	0	0
63										0						0					0	0	0	0
64										0						0					0	0	0	0
65	Did Not Finish (4)									0						0					0	0	0	0
66		8	C7106748	Underhill Viggo	U10	BKH				7106748	U10		TRUE	Underhill Viggo	U10	0					0	0	0	0
67		26	C7036119	Stueve Gavin	U12	GIL				7036119	U12		TRUE	Stueve Gavin	U12	0					0	0	0	0
68		44	C7145532	Johnson Kolt	U12	DUL				7145532	U12		TRUE	Johnson Kolt	U12	0					0	0	0	0
69		64	C7085049	Richardson Anders	U10	GIL				7085049	U10		TRUE	Richardson Anders	U10	0					0	0	0	0
70										0						0					0	0	0	0
71										0						0					0	0	0	0
72	Disqualified (1)									0						0					0	0	0	0
73		46	C7167376	Moertel William	U12	GIL	Rule Improper HikeGate 17	xx		7167376	U12	Rule Improper HikeGate 17	TRUE	Moertel William	U12	0			Rule Improper HikeGate 17		0	0	0	0
74										0						0					0	0	0	0
75										0						0					0	0	0	0
76										0						0					0	0	0	0
77										0						0					0	0	0	0
78										0						0					0	0	0	0
79										0						0					0	0	0	0
80										0						0					0	0	0	0
81										0						0					0	0	0	0
82										0						0					0	0	0	0
83										0						0					0	0	0	0
84										0						0					0	0	0	0
85										0						0					0	0	0	0
86										0						0					0	0	0	0
87										0						0					0	0	0	0
88										0						0					0	0	0	0
89										0						0					0	0	0	0
90										0						0					0	0	0	0
91										0						0					0	0	0	0
92										0						0					0	0	0	0
93										0						0					0	0	0	0
94										0						0					0	0	0	0
95										0						0					0	0	0	0
96										0						0					0	0	0	0
97										0						0					0	0	0	0
98										0						0					0	0	0	0
99										0						0					0	0	0	0
100										0						0					0	0	0	0
101										0						0					0	0	0	0
102										0						0					0	0	0	0
103										0						0					0	0	0	0
104										0						0					0	0	0	0
105										0						0					0	0	0	0
106										0						0					0	0	0	0
107										0						0					0	0	0	0
108										0						0					0	0	0	0
109										0						0					0	0	0	0
110										0						0					0	0	0	0
111										0						0					0	0	0	0
112										0						0					0	0	0	0
113										0						0					0	0	0	0
114										0						0					0	0	0	0
115										0						0					0	0	0	0
116										0						0					0	0	0	0
117										0						0					0	0	0	0
118										0						0					0	0	0	0
119										0						0					0	0	0	0
120										0						0					0	0	0	0
121										0						0					0	0	0	0
122										0						0					0	0	0	0
123										0						0					0	0	0	0
124										0						0					0	0	0	0
125										0						0					0	0	0	0
126										0						0					0	0	0	0
127										0						0					0	0	0	0
128										0						0					0	0	0	0
129										0						0					0	0	0	0
130										0						0					0	0	0	0
131										0						0					0	0	0	0
132										0						0					0	0	0	0
133										0						0					0	0	0	0
134										0						0					0	0	0	0
135										0						0					0	0	0	0
136										0						0					0	0	0	0
137										0						0					0	0	0	0
138										0						0					0	0	0	0
139										0						0					0	0	0	0
140										0						0					0	0	0	0
141										0						0					0	0	0	0
142										0						0					0	0	0	0
143										0						0					0	0	0	0
144										0						0					0	0	0	0
145										0						0					0	0	0	0
146										0						0					0	0	0	0
147										0						0					0	0	0	0
148										0						0					0	0	0	0
149										0						0					0	0	0	0
150										0						0					0	0	0	0
151										0						0					0	0	0	0
152										0						0					0	0	0	0
153										0						0					0	0	0	0
154										0						0					0	0	0	0
155										0						0					0	0	0	0
156										0						0					0	0	0	0
157										0						0					0	0	0	0
158										0						0					0	0	0	0
159										0						0					0	0	0	0
160										0						0					0	0	0	0
161										0						0					0	0	0	0
162										0						0					0	0	0	0
163										0						0					0	0	0	0
164										0						0					0	0	0	0
165										0						0					0	0	0	0
166										0						0					0	0	0	0
167										0						0					0	0	0	0
168										0						0					0	0	0	0
169										0						0					0	0	0	0
170										0						0					0	0	0	0
171										0						0					0	0	0	0
172										0						0					0	0	0	0
173										0						0					0	0	0	0
174										0						0					0	0	0	0
175										0						0					0	0	0	0
176										0						0					0	0	0	0
177										0						0					0	0	0	0
178										0						0					0	0	0	0
179										0						0					0	0	0	0
180										0						0					0	0	0	0
181										0						0					0	0	0	0
182										0						0					0	0	0	0
183										0						0					0	0	0	0
184										0						0					0	0	0	0
185										0						0					0	0	0	0
186										0						0					0	0	0	0
187										0						0					0	0	0	0
188										0						0					0	0	0	0
189										0						0					0	0	0	0
190										0						0					0	0	0	0
191										0						0					0	0	0	0
192										0						0					0	0	0	0
193										0						0					0	0	0	0
194										0						0					0	0	0	0
195										0						0					0	0	0	0
196										0						0					0	0	0	0
197										0						0					0	0	0	0
198										0						0					0	0	0	0
199										0						0					0	0	0	0
200										0						0					0	0	0	0


1	Paste source data here	UPDATED FORMULAS	Adjust forumla if needed	Adjust forumla if needed	Adjust forumla if needed		Quality Control Checks			time				rank in category
2			ID	Category (u8, u10...)	Time	ID on Summary?	Check Name (shows as listed on summary, differences highlighted)	Check Age Category (shows as listed on summary)	Rank in Category	U08	U10	U12	U14	U08	U10	U12	U14
3																		Copy source data starting at Column A (don't go beyond Column O)
4			0						0					0	0	0	0	Check that the formula in Column P refers to ID; change it if needed
5			0						0					0	0	0	0	Check that the formula in Column Q gives Category (U14, U12...). If Category isn't in the source data, use the formula below to get it from Year
6			0						0					0	0	0	0	Check that the forumla in Column R refers to the time column; change it if needed.

7			0						0					0	0	0	0	Make sure that any times greater than a minute (1:00.0) are converting to seconds properly in Column R
8			0						0					0	0	0	0	Check that names are as expected
9			0						0					0	0	0	0	Check that all the Region 1 racers IDs are on Summary. If the ID should be in the summary but it's not -- add it.
10			0						0					0	0	0	0	Check that rankings in category look correct (Rank In Category is in Column U; the summary tab looks for it there)
11			0						0					0	0	0	0	On the summary, copy the formula from a completed race to this race, but change the sheet name to match this tab
12			0						0					0	0	0	0
13			0						0					0	0	0	0
14			0						0					0	0	0	0
15			0						0					0	0	0	0	Formula for Category if only Year, not Category, are given in the source data:
16			0						0					0	0	0	0	=IFERROR(VLOOKUP(Value(E16),Category!$A$1:$B$8,2,0),"")
17			0						0					0	0	0	0
18			0						0					0	0	0	0
19			0						0					0	0	0	0
20			0						0					0	0	0	0
21			0						0					0	0	0	0
22			0						0					0	0	0	0
23			0						0					0	0	0	0
24			0						0					0	0	0	0
25			0						0					0	0	0	0
26			0						0					0	0	0	0
27			0						0					0	0	0	0
28			0						0					0	0	0	0
29			0						0					0	0	0	0
30			0						0					0	0	0	0
31			0						0					0	0	0	0
32			0						0					0	0	0	0
33			0						0					0	0	0	0
34			0						0					0	0	0	0
35			0						0					0	0	0	0
36			0						0					0	0	0	0
37			0						0					0	0	0	0
38			0						0					0	0	0	0
39			0						0					0	0	0	0
40			0						0					0	0	0	0
41			0						0					0	0	0	0
42			0						0					0	0	0	0
43			0						0					0	0	0	0
44			0						0					0	0	0	0
45			0						0					0	0	0	0
46			0						0					0	0	0	0
47			0						0					0	0	0	0
48			0						0					0	0	0	0
49			0						0					0	0	0	0
50			0						0					0	0	0	0
51			0						0					0	0	0	0
52			0						0					0	0	0	0
53			0						0					0	0	0	0
54			0						0					0	0	0	0
55			0						0					0	0	0	0
56			0						0					0	0	0	0
57			0						0					0	0	0	0
58			0						0					0	0	0	0
59			0						0					0	0	0	0
60			0						0					0	0	0	0
61			0						0					0	0	0	0
62			0						0					0	0	0	0
63			0						0					0	0	0	0
64			0						0					0	0	0	0
65			0						0					0	0	0	0
66			0						0					0	0	0	0
67			0						0					0	0	0	0
68			0						0					0	0	0	0
69			0						0					0	0	0	0
70			0						0					0	0	0	0
71			0						0					0	0	0	0
72			0						0					0	0	0	0
73			0						0					0	0	0	0
74			0						0					0	0	0	0
75			0						0					0	0	0	0
76			0						0					0	0	0	0
77			0						0					0	0	0	0
78			0						0					0	0	0	0
79			0						0					0	0	0	0
80			0						0					0	0	0	0
81			0						0					0	0	0	0
82			0						0					0	0	0	0
83			0						0					0	0	0	0
84			0						0					0	0	0	0
85			0						0					0	0	0	0
86			0						0					0	0	0	0
87			0						0					0	0	0	0
88			0						0					0	0	0	0
89			0						0					0	0	0	0
90			0						0					0	0	0	0
91			0						0					0	0	0	0
92			0						0					0	0	0	0
93			0						0					0	0	0	0
94			0						0					0	0	0	0
95			0						0					0	0	0	0
96			0						0					0	0	0	0
97			0						0					0	0	0	0
98			0						0					0	0	0	0
99			0						0					0	0	0	0
100			0						0					0	0	0	0
101			0						0					0	0	0	0
102			0						0					0	0	0	0
103			0						0					0	0	0	0
104			0						0					0	0	0	0
105			0						0					0	0	0	0
106			0						0					0	0	0	0
107			0						0					0	0	0	0
108			0						0					0	0	0	0
109			0						0					0	0	0	0
110			0						0					0	0	0	0
111			0						0					0	0	0	0
112			0						0					0	0	0	0
113			0						0					0	0	0	0
114			0						0					0	0	0	0
115			0						0					0	0	0	0
116			0						0					0	0	0	0
117			0						0					0	0	0	0
118			0						0					0	0	0	0
119			0						0					0	0	0	0
120			0						0					0	0	0	0
121			0						0					0	0	0	0
122			0						0					0	0	0	0
123			0						0					0	0	0	0
124			0						0					0	0	0	0
125			0						0					0	0	0	0
126			0						0					0	0	0	0
127			0						0					0	0	0	0
128			0						0					0	0	0	0
129			0						0					0	0	0	0
130			0						0					0	0	0	0
131			0						0					0	0	0	0
132			0						0					0	0	0	0
133			0						0					0	0	0	0
134			0						0					0	0	0	0
135			0						0					0	0	0	0
136			0						0					0	0	0	0
137			0						0					0	0	0	0
138			0						0					0	0	0	0
139			0						0					0	0	0	0
140			0						0					0	0	0	0
141			0						0					0	0	0	0
142			0						0					0	0	0	0
143			0						0					0	0	0	0
144			0						0					0	0	0	0
145			0						0					0	0	0	0
146			0						0					0	0	0	0
147			0						0					0	0	0	0
148			0						0					0	0	0	0
149			0						0					0	0	0	0
150			0						0					0	0	0	0
151			0						0					0	0	0	0
152			0						0					0	0	0	0
153			0						0					0	0	0	0
154			0						0					0	0	0	0
155			0						0					0	0	0	0
156			0						0					0	0	0	0
157			0						0					0	0	0	0
158			0						0					0	0	0	0
159			0						0					0	0	0	0
160			0						0					0	0	0	0
161			0						0					0	0	0	0
162			0						0					0	0	0	0
163			0						0					0	0	0	0
164			0						0					0	0	0	0
165			0						0					0	0	0	0
166			0						0					0	0	0	0
167			0						0					0	0	0	0
168			0						0					0	0	0	0
169			0						0					0	0	0	0
170			0						0					0	0	0	0
171			0						0					0	0	0	0
172			0						0					0	0	0	0
173			0						0					0	0	0	0
174			0						0					0	0	0	0
175			0						0					0	0	0	0
176			0						0					0	0	0	0
177			0						0					0	0	0	0
178			0						0					0	0	0	0
179			0						0					0	0	0	0
180			0						0					0	0	0	0
181			0						0					0	0	0	0
182			0						0					0	0	0	0
183			0						0					0	0	0	0
184			0						0					0	0	0	0
185			0						0					0	0	0	0
186			0						0					0	0	0	0
187			0						0					0	0	0	0
188			0						0					0	0	0	0
189			0						0					0	0	0	0
190			0						0					0	0	0	0
191			0						0					0	0	0	0
192			0						0					0	0	0	0
193			0						0					0	0	0	0
194			0						0					0	0	0	0
195			0						0					0	0	0	0
196			0						0					0	0	0	0
197			0						0					0	0	0	0
198			0						0					0	0	0	0
199			0						0					0	0	0	0
200			0						0					0	0	0	0


1	Paul Augustine JR Champs U8-U10 Boys							UPDATED FORMULAS	Adjust forumla if needed	Adjust forumla if needed	Adjust forumla if needed		Quality Control Checks			time				rank in category
2	1 Giant Slalom and 1 Slalom (U8-U16 / Men)								ID	Category (u8, u10...)	Time	ID on Summary?	Check Name (shows as listed on summary, differences highlighted)	Check Age Category (shows as listed on summary)	Rank in Category	U08	U10	U12	U14	U08	U10	U12	U14
3	Run Ranking 2																								Copy source data starting at Column A (don't go beyond Column O)
4									0						0					0	0	0	0		Check that the formula in Column P refers to ID; change it if needed
5	Rank	Bib	USA ID	Name	Category	Club	Time		#VALUE!	Category	Time				0					0	0	0	0	USA ID Name Category Club	Check that the formula in Column Q gives Category (U14, U12...). If Category isn't in the source data, use the formula below to get it from Year
6	1	159	C7035289	Rambow Magnus	U10	FST	34.26		7035289	U10	34.26	TRUE	Rambow Magnus	U10	1		34.26			0	1	0	0		Check that the forumla in Column R refers to the time column; change it if needed.
7	2	149	C7013674	Molinaro Peter	U10	AFT	37.35		7013674	U10	37.35	TRUE	Molinaro Peter	U10	2		37.35			0	2	0	0		Make sure that any times greater than a minute (1:00.0) are converting to seconds properly in Column R
8	3	160	C7012176	Simon Spencer	U10	GIL	37.69		7012176	U10	37.69	TRUE	Simon Spencer	U10	3		37.69			0	3	0	0		Check that names are as expected
9	4	163	C7037253	Richardson Graham	U10	GIL	39.76		7037253	U10	39.76	TRUE	Richardson Graham	U10	4		39.76			0	4	0	0		Check that all the Region 1 racers IDs are on Summary. If the ID should be in the summary but it's not -- add it.
10	5	153	C7031191	Lodermeier Graham	U10	AFT	40.17		7031191	U10	40.17	TRUE	Lodermeier Graham	U10	5		40.17			0	5	0	0		Check that rankings in category look correct (Rank In Category is in Column U; the summary tab looks for it there)
11	6	162	C6933951	O'Grady Bohdan	U10	AFT	41.15		6933951	U10	41.15	TRUE	O'Grady Bohdan	U10	6		41.15			0	6	0	0		On the summary, copy the formula from a completed race to this race, but change the sheet name to match this tab
12	7	148	C6679237	Titler Teddy	U10	BKH	42.3		6679237	U10	42.30	TRUE	Titler Teddy	U10	7		42.30			0	7	0	0
13	8	143	C7140797	Marchesi Milo	U8	BKH	42.84		7140797	U08	42.84	TRUE	Marchesi Milo	U08	1	42.84				1	0	0	0
14	9	146	C7013888	Zellmer Samuel	U8	AFT	43.11		7013888	U08	43.11	TRUE	Zellmer Samuel	U08	2	43.11				2	0	0	0
15	10	145	C7102519	Peltz Reid	U8	BKH	44.11		7102519	U08	44.11	TRUE	Peltz Reid	U08	3	44.11				3	0	0	0		Formula for Category if only Year, not Category, are given in the source data:
16	11	154	C7171854	Chupp Grant	U10		44.39		7171854	U10	44.39				0					0	0	0	0	C7171854 Chupp Grant U10	=IFERROR(VLOOKUP(Value(E16),Category!$A$1:$B$8,2,0),"")
17	12	157	C7167191	Welshans Victor	U10	AFT	44.92		7167191	U10	44.92				0					0	0	0	0	C7167191 Welshans Victor U10 AFT
18	13	141	C7033941	Brunsvold Carter	U8	AFT	45.7		7033941	U08	45.70	TRUE	Brunsvold Carter	U08	4	45.70				4	0	0	0
19	14	152	C7170968	Suchy George	U10		45.74		7170968	U10	45.74				0					0	0	0	0	C7170968 Suchy George U10
20	15	156	C7083495	Miller Ryder	U10	BKH	46.56		7083495	U10	46.56	TRUE	Miller Ryder	U10	8		46.56			0	8	0	0
21	16	147	C7167832	Soldan Asher	U10	AFT	47.37		7167832	U10	47.37	TRUE	Soldan Asher	U10	9		47.37			0	9	0	0
22	17	142	C7159818	Comstock Waylon	U8	FST	47.4		7159818	U08	47.40	TRUE	Comstock Waylon	U08	5	47.40				5	0	0	0
23	18	144	C7012809	O'Grady Henryk	U8	AFT	47.65		7012809	U08	47.65	TRUE	O'Grady Henryk	U08	6	47.65				6	0	0	0
24	19	150	C7117542	Bristlin Rhys	U10	FST	48.26		7117542	U10	48.26	TRUE	Bristlin Rhys	U10	10		48.26			0	10	0	0
25	20	151	C6931622	Houle John Luc	U10	AFT	50.3		6931622	U10	50.30	TRUE	Houle John Luc	U10	11		50.30			0	11	0	0
26	21	155	C6903702	Stinnett Jack	U10	BKH	52.51		6903702	U10	52.51	TRUE	Stinnett Jack	U10	12		52.51			0	12	0	0
27	22	161	C7085049	Richardson Anders	U10	GIL	54.08		7085049	U10	54.08	TRUE	Richardson Anders	U10	13		54.08			0	13	0	0
28	23	158	C7145180	Chalekian Sullivan	U10	GIL	70.72		7145180	U10	70.72	TRUE	Chalekian Sullivan	U10	14		70.72			0	14	0	0
29									0						0					0	0	0	0
30									0						0					0	0	0	0
31	Paul Augustine JR Champs U14-U12 Boys								0						0					0	0	0	0
32	1 Giant Slalom and 1 Slalom (U8-U16 / Men)								0						0					0	0	0	0
33	Run Ranking 2								0						0					0	0	0	0
34									0						0					0	0	0	0
35	Rank	Bib	USA ID	Name	Category	Club	Time		#VALUE!	Category	Time				0					0	0	0	0	USA ID Name Category Club
36	1	224	R6679229	Pooley Garrett	U14	SSCV	34.27		6679229	U14	34.27				0					0	0	0	0	R6679229 Pooley Garrett U14 SSCV
37	2	212	C6771877	Ferrales Julian	U14	BKH	34.34		6771877	U14	34.34				0					0	0	0	0	C6771877 Ferrales Julian U14 BKH
38	3	194	X6775209	Jones Reid	U12	TBY	34.72		6775209	U12	34.72	TRUE	Jones Reid	U12	1			34.72		0	0	1	0
39	4	229	C6708412	Parker Jack	U14	GIL	35.07		6708412	U14	35.07				0					0	0	0	0	C6708412 Parker Jack U14 GIL
40	5	205	C6862560	Kinzer Daniel	U14	GIL	35.23		6862560	U14	35.23				0					0	0	0	0	C6862560 Kinzer Daniel U14 GIL
41	6	165	C6679153	Mjanger Luke	U12	AFT	35.43		6679153	U12	35.43	TRUE	Mjanger Luke	U12	2			35.43		0	0	2	0
42	7	231	C6930921	Bristlin Tristan	U14	FST	35.49		6930921	U14	35.49				0					0	0	0	0	C6930921 Bristlin Tristan U14 FST
43	8	214	C6944522	Scott Chipper	U14	GIL	36.04		6944522	U14	36.04				0					0	0	0	0	C6944522 Scott Chipper U14 GIL
44	9	222	C6599500	Lobanoff Luke	U14	AFT	36.2		6599500	U14	36.20				0					0	0	0	0	C6599500 Lobanoff Luke U14 AFT
45	10	219	C6944238	Jakobe Michael	U14	GIL	36.47		6944238	U14	36.47				0					0	0	0	0	C6944238 Jakobe Michael U14 GIL
46	11	170	C6778054	Burns William	U12	AFT	36.57		6778054	U12	36.57	TRUE	Burns William	U12	3			36.57		0	0	3	0
47	12	191	R6712468	Campian Alexander	U12	SUM	36.73		6712468	U12	36.73				0					0	0	0	0	R6712468 Campian Alexander U12 SUM
48	13	235	C6958964	Monico Vincent	U14	GIL	36.88		6958964	U14	36.88				0					0	0	0	0	C6958964 Monico Vincent U14 GIL
49	14	238	C6771216	Burns Carley	U14	GIL	36.91		6771216	U14	36.91				0					0	0	0	0	C6771216 Burns Carley U14 GIL
50	15	175	C6953275	Hopke Brexten	U12	BKH	37.01		6953275	U12	37.01	TRUE	Hopke Brexten	U12	4			37.01		0	0	4	0
51	16	196	C6983174	Peltz Cole	U12	BKH	37.03		6983174	U12	37.03	TRUE	Peltz Cole	U12	5			37.03		0	0	5	0
52	17	234	C6868000	Gray Zane	U14	BKH	37.13		6868000	U14	37.13				0					0	0	0	0	C6868000 Gray Zane U14 BKH
53	18	227	C6768303	Braton Noah	U14	FST	37.15		6768303	U14	37.15				0					0	0	0	0	C6768303 Braton Noah U14 FST
54	19	187	C6884860	Carpenter Ty	U12	LKR	37.54		6884860	U12	37.54				0					0	0	0	0	C6884860 Carpenter Ty U12 LKR
55	20	186	C6779490	Schaeppi Asa	U12	BKH	37.73		6779490	U12	37.73	TRUE	Schaeppi Asa	U12	6			37.73		0	0	6	0
56	21	176	C7002342	Sampson Reef	U12	FST	37.88		7002342	U12	37.88	TRUE	Sampson Reef	U12	7			37.88		0	0	7	0
57	22	223	C7072485	Corbett Sam	U14	BKH	38		7072485	U14	38.00				0					0	0	0	0	C7072485 Corbett Sam U14 BKH
58	23	209	C6771232	Wolter Bergen	U14	GIL	38.54		6771232	U14	38.54				0					0	0	0	0	C6771232 Wolter Bergen U14 GIL
59	24	240	C6678999	Pierce Tanner	U14	GIL	38.59		6678999	U14	38.59				0					0	0	0	0	C6678999 Pierce Tanner U14 GIL
60	25	217	C7033108	Wiessner Jackson	U14	GIL	38.84		7033108	U14	38.84				0					0	0	0	0	C7033108 Wiessner Jackson U14 GIL
61	26	168	C7032006	Geelan Jack	U12	GIL	39.03		7032006	U12	39.03	TRUE	Geelan Jack	U12	8			39.03		0	0	8	0
62	27	171	X6751067	Zadvornykh Roman	U12	BKH	39.05		6751067	U12	39.05	TRUE	Zadvornykh Roman	U12	9			39.05		0	0	9	0
63	28	201	C6772628	Kim Henry	U14	GIL	39.88		6772628	U14	39.88				0					0	0	0	0	C6772628 Kim Henry U14 GIL
64	29	218	C6966707	Sasanfar Benno	U14	GIL	39.97		6966707	U14	39.97				0					0	0	0	0	C6966707 Sasanfar Benno U14 GIL
65	30	199	C6577752	Jones Pete	U14	FST	40.66		6577752	U14	40.66				0					0	0	0	0	C6577752 Jones Pete U14 FST
66	31	236	C6903466	Ranum Nathan	U14	AFT	41.11		6903466	U14	41.11				0					0	0	0	0	C6903466 Ranum Nathan U14 AFT
67	32	179	C7003414	Glancy Liam	U12	AFT	42.51		7003414	U12	42.51	TRUE	Glancy Liam	U12	10			42.51		0	0	10	0
68	33	183	C6944250	Jakobe Benjamin	U12	GIL	42.79		6944250	U12	42.79	TRUE	Jakobe Benjamin	U12	11			42.79		0	0	11	0
69	34	174	C7036119	Stueve Gavin	U12	GIL	43.2		7036119	U12	43.20	TRUE	Stueve Gavin	U12	12			43.20		0	0	12	0
70	35	232	C7036107	Stueve Wyatt	U14	GIL	43.25		7036107	U14	43.25				0					0	0	0	0	C7036107 Stueve Wyatt U14 GIL
71	36	185	C6970496	Barbeau Avery	U12	FST	43.46		6970496	U12	43.46	TRUE	Barbeau Avery	U12	13			43.46		0	0	13	0
72	37	230	C6771539	Dennison Bryce	U14	GIL	43.7		6771539	U14	43.70				0					0	0	0	0	C6771539 Dennison Bryce U14 GIL
73	38	204	C6862466	Hinkie Coleman	U14	GIL	44.8		6862466	U14	44.80				0					0	0	0	0	C6862466 Hinkie Coleman U14 GIL
74	39	192	C6952905	Johnson Soren	U12	BKH	44.9		6952905	U12	44.90	TRUE	Johnson Soren	U12	14			44.90		0	0	14	0
75	40	180	C7012913	Halverson Chase	U12	AFT	46.53		7012913	U12	46.53	TRUE	Halverson Chase	U12	15			46.53		0	0	15	0
76	41	167	C7086207	Johnson Caden	U12	AFT	46.89		7086207	U12	46.89	TRUE	Johnson Caden	U12	16			46.89		0	0	16	0
77	42	202	C6678965	Piltingsrud Toren	U14	BKH	47.31		6678965	U14	47.31				0					0	0	0	0	C6678965 Piltingsrud Toren U14 BKH
78	43	211	C6772776	Larson Zane	U14	GIL	47.57		6772776	U14	47.57				0					0	0	0	0	C6772776 Larson Zane U14 GIL
79	44	210	C6773006	Schultes Prior	U14	GIL	47.61		6773006	U14	47.61				0					0	0	0	0	C6773006 Schultes Prior U14 GIL
80	45	188	C6773139	Richardson Sawyer	U12	GIL	47.65		6773139	U12	47.65	TRUE	Richardson Sawyer	U12	17			47.65		0	0	17	0
81	46	237	C6937424	Amirayan Artin	U14	BKH	48		6937424	U14	48.00				0					0	0	0	0	C6937424 Amirayan Artin U14 BKH
82	47	181	C6944248	Kim Charlie	U12	GIL	48.23		6944248	U12	48.23	TRUE	Kim Charlie	U12	18			48.23		0	0	18	0
83	48	173	C7014877	Kocian Liam	U12	AFT	49.24		7014877	U12	49.24				0					0	0	0	0	C7014877 Kocian Liam U12 AFT
84	49	164	C6926242	Brown Griffin	U12	GIL	50.32		6926242	U12	50.32	TRUE	Brown Griffin	U12	19			50.32		0	0	19	0
85	50	207	C6863208	Turcotte John	U14	FST	51.41		6863208	U14	51.41				0					0	0	0	0	C6863208 Turcotte John U14 FST
86	51	215	C7171489	Lee Nolan	U14		51.83		7171489	U14	51.83				0					0	0	0	0	C7171489 Lee Nolan U14
87	52	172	C7170974	Suchy Henry	U12		51.89		7170974	U12	51.89				0					0	0	0	0	C7170974 Suchy Henry U12
88	53	177	C7144247	Johnson Eli	U12	GIL	52.76		7144247	U12	52.76	TRUE	Johhnson Eli	U12	20			52.76		0	0	20	0
89	54	178	C6944207	Larson Finn	U12	GIL	53.53		6944207	U12	53.53	TRUE	Larson Finn	U12	21			53.53		0	0	21	0
90									0						0					0	0	0	0
91									0						0					0	0	0	0
92	Did Not Start (31)								0						0					0	0	0	0
93		190	C7103072	King-Ellison Roenen	U12	BKH			7103072	U12		TRUE	King-Ellison Roenen	U12	0					0	0	0	0
94		208	C6644728	Barkwell Zachary	U14	BKH			6644728	U14					0					0	0	0	0	C6644728 Barkwell Zachary U14 BKH
95		213	C6678619	Hornig Will	U14	GIL			6678619	U14					0					0	0	0	0	C6678619 Hornig Will U14 GIL
96		221	C7161814	Komarek Logan	U14				7161814	U14					0					0	0	0	0	C7161814 Komarek Logan U14
97		225	C6644710	Barkwell Ethan	U14	BKH			6644710	U14					0					0	0	0	0	C6644710 Barkwell Ethan U14 BKH
98		226	C7050800	Parent Cullen	U14	GIL			7050800	U14					0					0	0	0	0	C7050800 Parent Cullen U14 GIL
99		228	C6934870	Indovina Andrew	U14	BKH			6934870	U14					0					0	0	0	0	C6934870 Indovina Andrew U14 BKH
100		239	C6983368	Wisniewski Nicholas	U14	AFT			6983368	U14					0					0	0	0	0	C6983368 Wisniewski Nicholas U14 AFT
101									0						0					0	0	0	0
102									0						0					0	0	0	0
103	Did Not Finish (7)								0						0					0	0	0	0
104		169	C7129523	Barott Laken	U12	FST			7129523	U12		TRUE	Barott Laken	U12	0					0	0	0	0
105		182	X7022048	Negi Saivya	U12	GIL			7022048	U12		TRUE	Negi Saivya	U12	0					0	0	0	0
106		195	C6941815	Pope Reed	U12	FST			6941815	U12		TRUE	Pope Reed	U12	0					0	0	0	0
107		206	C7043309	Wood Dominic	U14	FST			7043309	U14					0					0	0	0	0	C7043309 Wood Dominic U14 FST
108		216	C6951567	Provencher Jonah	U14	BKH			6951567	U14					0					0	0	0	0	C6951567 Provencher Jonah U14 BKH
109		220	C7094609	Dornik William	U14	GIL			7094609	U14					0					0	0	0	0	C7094609 Dornik William U14 GIL
110		233	C6773030	Schultes Mason	U14	GIL			6773030	U14					0					0	0	0	0	C6773030 Schultes Mason U14 GIL
111									0						0					0	0	0	0
112									0						0					0	0	0	0
113	Disqualified (8)								0						0					0	0	0	0
114		166	C7143146	Matchinsky Andrew	U12	GIL	Gate 14		7143146	U12	Gate 14	TRUE	Matchinsky Andrew	U12	0			Gate 14		0	0	0	0
115		184	C7167376	Moertel William	U12	GIL	Gate 14		7167376	U12	Gate 14	TRUE	Moertel William	U12	0			Gate 14		0	0	0	0
116		189	C7068488	Braton Isaiah	U12	FST	Gate 14		7068488	U12	Gate 14				0					0	0	0	0	C7068488 Braton Isaiah U12 FST
117		193	C7091243	Margolin Samuel	U12	GIL	Gate 14		7091243	U12	Gate 14	TRUE	Margolin Samuel	U12	0			Gate 14		0	0	0	0
118		197	X6960263	Jones Ross	U12	TBY	Gate 14		6960263	U12	Gate 14	TRUE	Jones Ross	U12	0			Gate 14		0	0	0	0
119		198	C7171699	Augustine Leopold	U12	AFT	Gate 19		7171699	U12	Gate 19				0					0	0	0	0	C7171699 Augustine Leopold U12 AFT
120		200	X6844973	Nichols Orran	U14	TBY	Gate 21		6844973	U14	Gate 21				0					0	0	0	0	X6844973 Nichols Orran U14 TBY
121		203	C6950089	McCoy Jasper	U14	GIL	Gate 21		6950089	U14	Gate 21				0					0	0	0	0	C6950089 McCoy Jasper U14 GIL
122									0						0					0	0	0	0
123									0						0					0	0	0	0
124									0						0					0	0	0	0
125									0						0					0	0	0	0
126									0						0					0	0	0	0
127									0						0					0	0	0	0
128									0						0					0	0	0	0
129									0						0					0	0	0	0
130									0						0					0	0	0	0
131									0						0					0	0	0	0
132									0						0					0	0	0	0
133									0						0					0	0	0	0
134									0						0					0	0	0	0
135									0						0					0	0	0	0
136									0						0					0	0	0	0
137									0						0					0	0	0	0
138									0						0					0	0	0	0
139									0						0					0	0	0	0
140									0						0					0	0	0	0
141									0						0					0	0	0	0
142									0						0					0	0	0	0
143									0						0					0	0	0	0
144									0						0					0	0	0	0
145									0						0					0	0	0	0
146									0						0					0	0	0	0
147									0						0					0	0	0	0
148									0						0					0	0	0	0
149									0						0					0	0	0	0
150									0						0					0	0	0	0
151									0						0					0	0	0	0
152									0						0					0	0	0	0
153									0						0					0	0	0	0
154									0						0					0	0	0	0
155									0						0					0	0	0	0
156									0						0					0	0	0	0
157									0						0					0	0	0	0
158									0						0					0	0	0	0
159									0						0					0	0	0	0
160									0						0					0	0	0	0
161									0						0					0	0	0	0
162									0						0					0	0	0	0
163									0						0					0	0	0	0
164									0						0					0	0	0	0
165									0						0					0	0	0	0
166									0						0					0	0	0	0
167									0						0					0	0	0	0
168									0						0					0	0	0	0
169									0						0					0	0	0	0
170									0						0					0	0	0	0
171									0						0					0	0	0	0
172									0						0					0	0	0	0
173									0						0					0	0	0	0
174									0						0					0	0	0	0
175									0						0					0	0	0	0
176									0						0					0	0	0	0
177									0						0					0	0	0	0
178									0						0					0	0	0	0
179									0						0					0	0	0	0
180									0						0					0	0	0	0
181									0						0					0	0	0	0
182									0						0					0	0	0	0
183									0						0					0	0	0	0
184									0						0					0	0	0	0
185									0						0					0	0	0	0
186									0						0					0	0	0	0
187									0						0					0	0	0	0
188									0						0					0	0	0	0
189									0						0					0	0	0	0
190									0						0					0	0	0	0
191									0						0					0	0	0	0
192									0						0					0	0	0	0
193									0						0					0	0	0	0
194									0						0					0	0	0	0
195									0						0					0	0	0	0
196									0						0					0	0	0	0
197									0						0					0	0	0	0
198									0						0					0	0	0	0
199									0						0					0	0	0	0
200									0						0					0	0	0	0


1	Planet Cup Finale U8-U12 Boys SL							UPDATED FORMULAS	Adjust forumla if needed	Adjust forumla if needed	Adjust forumla if needed		Quality Control Checks			time				rank in category
2	Slalom (U8-U16 / Men)								ID	Category (u8, u10...)	Time	ID on Summary?	Check Name (shows as listed on summary, differences highlighted)	Check Age Category (shows as listed on summary)	Rank in Category	U08	U10	U12	U14	U08	U10	U12	U14
3	Run Ranking 1																								Copy source data starting at Column A (don't go beyond Column O)
4									0						0					0	0	0	0		Check that the formula in Column P refers to ID; change it if needed
5	Rank	Bib	USA ID	Name	Category	Club	Time		#VALUE!	Category	Time				0					0	0	0	0	USA ID Name Category Club	Check that the formula in Column Q gives Category (U14, U12...). If Category isn't in the source data, use the formula below to get it from Year
6	1	23	C6941815	Pope Reed	U12	FST	29.45		6941815	U12	29.45	TRUE	Pope Reed	U12	1			29.45		0	0	1	0		Check that the forumla in Column R refers to the time column; change it if needed.
7	2	35	C6778054	Burns William	U12	AFT	30.35		6778054	U12	30.35	TRUE	Burns William	U12	2			30.35		0	0	2	0		Make sure that any times greater than a minute (1:00.0) are converting to seconds properly in Column R
8	3	52	C6678643	Levander Everett	U12	AFT	30.63		6678643	U12	30.63	TRUE	Levander Everett	U12	3			30.63		0	0	3	0		Check that names are as expected
9	4	41	X6751067	Zadvornykh Roman	U12	BKH	31.13		6751067	U12	31.13	TRUE	Zadvornykh Roman	U12	4			31.13		0	0	4	0		Check that all the Region 1 racers IDs are on Summary. If the ID should be in the summary but it's not -- add it.
10	5	57	C6779490	Schaeppi Asa	U12	BKH	31.35		6779490	U12	31.35	TRUE	Schaeppi Asa	U12	5			31.35		0	0	5	0		Check that rankings in category look correct (Rank In Category is in Column U; the summary tab looks for it there)
11	6	74	C6953275	Hopke Brexten	U12	BKH	31.56		6953275	U12	31.56	TRUE	Hopke Brexten	U12	6			31.56		0	0	6	0		On the summary, copy the formula from a completed race to this race, but change the sheet name to match this tab
12	7	39	C7002342	Sampson Reef	U12	FST	32.34		7002342	U12	32.34	TRUE	Sampson Reef	U12	7			32.34		0	0	7	0
13	8	60	C6983174	Peltz Cole	U12	BKH	32.9		6983174	U12	32.90	TRUE	Peltz Cole	U12	8			32.90		0	0	8	0
14	9	51	X7022048	Negi Saivya	U12	GIL	33.28		7022048	U12	33.28	TRUE	Negi Saivya	U12	9			33.28		0	0	9	0
15	10	7	C7035289	Rambow Magnus	U10	FST	33.72		7035289	U10	33.72	TRUE	Rambow Magnus	U10	1		33.72			0	1	0	0		Formula for Category if only Year, not Category, are given in the source data:
16	11	85	C6771406	Cryer Carson	U12	BKH	34.06		6771406	U12	34.06	TRUE	Cryer Carson	U12	10			34.06		0	0	10	0		=IFERROR(VLOOKUP(Value(E16),Category!$A$1:$B$8,2,0),"")
17	12	26	C7036119	Stueve Gavin	U12	GIL	34.09		7036119	U12	34.09	TRUE	Stueve Gavin	U12	11			34.09		0	0	11	0
18	13	20	C6679237	Titler Teddy	U10	BKH	34.35		6679237	U10	34.35	TRUE	Titler Teddy	U10	2		34.35			0	2	0	0
19	14	14	C6903702	Stinnett Jack	U10	BKH	34.83		6903702	U10	34.83	TRUE	Stinnett Jack	U10	3		34.83			0	3	0	0
20	15	65	C7106837	Underhill Griffin	U12	BKH	35.86		7106837	U12	35.86	TRUE	Underhill Griffin	U12	12			35.86		0	0	12	0
21	16	19	C7012176	Simon Spencer	U10	GIL	36.63		7012176	U10	36.63	TRUE	Simon Spencer	U10	4		36.63			0	4	0	0
22	17	21	C7013674	Molinaro Peter	U10	AFT	36.91		7013674	U10	36.91	TRUE	Molinaro Peter	U10	5		36.91			0	5	0	0
23	18	10	C7031191	Lodermeier Graham	U10	AFT	37.52		7031191	U10	37.52	TRUE	Lodermeier Graham	U10	6		37.52			0	6	0	0
24	19	42	C6952905	Johnson Soren	U12	BKH	37.72		6952905	U12	37.72	TRUE	Johnson Soren	U12	13			37.72		0	0	13	0
25	20	70	C7032999	Mayerle Wes	U12	AFT	38.69		7032999	U12	38.69	TRUE	Mayerle Wes	U12	14			38.69		0	0	14	0
26	21	8	C7106748	Underhill Viggo	U10	BKH	39.66		7106748	U10	39.66	TRUE	Underhill Viggo	U10	7		39.66			0	7	0	0
27	22	30	C6970496	Barbeau Avery	U12	FST	39.96		6970496	U12	39.96	TRUE	Barbeau Avery	U12	15			39.96		0	0	15	0
28	23	9	C6933951	O'Grady Bohdan	U10	AFT	40.09		6933951	U10	40.09	TRUE	O'Grady Bohdan	U10	8		40.09			0	8	0	0
29	24	37	C7129523	Barott Laken	U12	FST	40.57		7129523	U12	40.57	TRUE	Barott Laken	U12	16			40.57		0	0	16	0
30	25	5	C7102519	Peltz Reid	U8	BKH	40.82		7102519	U08	40.82	TRUE	Peltz Reid	U08	1	40.82				1	0	0	0
31	26	36	C7091855	Swanke Ivan	U12	GIL	41.31		7091855	U12	41.31	TRUE	Swanke Ivan	U12	17			41.31		0	0	17	0
32	27	2	C7013888	Zellmer Samuel	U8	AFT	42.46		7013888	U08	42.46	TRUE	Zellmer Samuel	U08	2	42.46				2	0	0	0
33	28	53	C7144247	Johnson Eli	U12	GIL	43.15		7144247	U12	43.15	TRUE	Johhnson Eli	U12	18			43.15		0	0	18	0
34	29	13	C7083495	Miller Ryder	U10	BKH	44.84		7083495	U10	44.84	TRUE	Miller Ryder	U10	9		44.84			0	9	0	0
35	30	17	C7091437	Saewert Otto	U10	GIL	44.99		7091437	U10	44.99	TRUE	Saewert Otto	U10	10		44.99			0	10	0	0
36	31	3	C7033941	Brunsvold Carter	U8	AFT	45.81		7033941	U08	45.81	TRUE	Brunsvold Carter	U08	3	45.81				3	0	0	0
37	32	56	C6679153	Mjanger Luke	U12	AFT	45.94		6679153	U12	45.94	TRUE	Mjanger Luke	U12	19			45.94		0	0	19	0
38	33	1	C7086044	Benson Soren	U8	AFT	46.8		7086044	U08	46.80	TRUE	Benson Soren	U08	4	46.80				4	0	0	0
39	34	16	C7159818	Comstock Waylon	U8	FST	47.09		7159818	U08	47.09	TRUE	Comstock Waylon	U08	5	47.09				5	0	0	0
40	35	15	C7117542	Bristlin Rhys	U10	FST	49.31		7117542	U10	49.31	TRUE	Bristlin Rhys	U10	11		49.31			0	11	0	0
41	36	4	C7012809	O'Grady Henryk	U8	AFT	49.52		7012809	U08	49.52	TRUE	O'Grady Henryk	U08	6	49.52				6	0	0	0
42									0						0					0	0	0	0
43									0						0					0	0	0	0
44	Did Not Start (5)								0						0					0	0	0	0
45		6	C7135036	Balsimo Micco	U12	GIL			7135036	U12		TRUE	Balsimo Micco	U12	0					0	0	0	0
46		54	C7103072	King-Ellison Roenen	U12	BKH			7103072	U12		TRUE	King-Ellison Roenen	U12	0					0	0	0	0
47		64	C7085049	Richardson Anders	U10	GIL			7085049	U10		TRUE	Richardson Anders	U10	0					0	0	0	0
48		71	C7167832	Soldan Asher	U10	AFT			7167832	U10		TRUE	Soldan Asher	U10	0					0	0	0	0
49		84	C7115799	Mallery Rigby	U12	GIL			7115799	U12		TRUE	Mallery Rigby	U12	0					0	0	0	0
50									0						0					0	0	0	0
51									0						0					0	0	0	0
52	Did Not Finish (1)								0						0					0	0	0	0
53		18	C6931622	Houle John Luc	U10	AFT			6931622	U10		TRUE	Houle John Luc	U10	0					0	0	0	0
54									0						0					0	0	0	0
55									0						0					0	0	0	0
56									0						0					0	0	0	0
57									0						0					0	0	0	0
58									0						0					0	0	0	0
59									0						0					0	0	0	0
60									0						0					0	0	0	0
61									0						0					0	0	0	0
62									0						0					0	0	0	0
63									0						0					0	0	0	0
64									0						0					0	0	0	0
65									0						0					0	0	0	0
66									0						0					0	0	0	0
67									0						0					0	0	0	0
68									0						0					0	0	0	0
69									0						0					0	0	0	0
70									0						0					0	0	0	0
71									0						0					0	0	0	0
72									0						0					0	0	0	0
73									0						0					0	0	0	0
74									0						0					0	0	0	0
75									0						0					0	0	0	0
76									0						0					0	0	0	0
77									0						0					0	0	0	0
78									0						0					0	0	0	0
79									0						0					0	0	0	0
80									0						0					0	0	0	0
81									0						0					0	0	0	0
82									0						0					0	0	0	0
83									0						0					0	0	0	0
84									0						0					0	0	0	0
85									0						0					0	0	0	0
86									0						0					0	0	0	0
87									0						0					0	0	0	0
88									0						0					0	0	0	0
89									0						0					0	0	0	0
90									0						0					0	0	0	0
91									0						0					0	0	0	0
92									0						0					0	0	0	0
93									0						0					0	0	0	0
94									0						0					0	0	0	0
95									0						0					0	0	0	0
96									0						0					0	0	0	0
97									0						0					0	0	0	0
98									0						0					0	0	0	0
99									0						0					0	0	0	0
100									0						0					0	0	0	0
101									0						0					0	0	0	0
102									0						0					0	0	0	0
103									0						0					0	0	0	0
104									0						0					0	0	0	0
105									0						0					0	0	0	0
106									0						0					0	0	0	0
107									0						0					0	0	0	0
108									0						0					0	0	0	0
109									0						0					0	0	0	0
110									0						0					0	0	0	0
111									0						0					0	0	0	0
112									0						0					0	0	0	0
113									0						0					0	0	0	0
114									0						0					0	0	0	0
115									0						0					0	0	0	0
116									0						0					0	0	0	0
117									0						0					0	0	0	0
118									0						0					0	0	0	0
119									0						0					0	0	0	0
120									0						0					0	0	0	0
121									0						0					0	0	0	0
122									0						0					0	0	0	0
123									0						0					0	0	0	0
124									0						0					0	0	0	0
125									0						0					0	0	0	0
126									0						0					0	0	0	0
127									0						0					0	0	0	0
128									0						0					0	0	0	0
129									0						0					0	0	0	0
130									0						0					0	0	0	0
131									0						0					0	0	0	0
132									0						0					0	0	0	0
133									0						0					0	0	0	0
134									0						0					0	0	0	0
135									0						0					0	0	0	0
136									0						0					0	0	0	0
137									0						0					0	0	0	0
138									0						0					0	0	0	0
139									0						0					0	0	0	0
140									0						0					0	0	0	0
141									0						0					0	0	0	0
142									0						0					0	0	0	0
143									0						0					0	0	0	0
144									0						0					0	0	0	0
145									0						0					0	0	0	0
146									0						0					0	0	0	0
147									0						0					0	0	0	0
148									0						0					0	0	0	0
149									0						0					0	0	0	0
150									0						0					0	0	0	0
151									0						0					0	0	0	0
152									0						0					0	0	0	0
153									0						0					0	0	0	0
154									0						0					0	0	0	0
155									0						0					0	0	0	0
156									0						0					0	0	0	0
157									0						0					0	0	0	0
158									0						0					0	0	0	0
159									0						0					0	0	0	0
160									0						0					0	0	0	0
161									0						0					0	0	0	0
162									0						0					0	0	0	0
163									0						0					0	0	0	0
164									0						0					0	0	0	0
165									0						0					0	0	0	0
166									0						0					0	0	0	0
167									0						0					0	0	0	0
168									0						0					0	0	0	0
169									0						0					0	0	0	0
170									0						0					0	0	0	0
171									0						0					0	0	0	0
172									0						0					0	0	0	0
173									0						0					0	0	0	0
174									0						0					0	0	0	0
175									0						0					0	0	0	0
176									0						0					0	0	0	0
177									0						0					0	0	0	0
178									0						0					0	0	0	0
179									0						0					0	0	0	0
180									0						0					0	0	0	0
181									0						0					0	0	0	0
182									0						0					0	0	0	0
183									0						0					0	0	0	0
184									0						0					0	0	0	0
185									0						0					0	0	0	0
186									0						0					0	0	0	0
187									0						0					0	0	0	0
188									0						0					0	0	0	0
189									0						0					0	0	0	0
190									0						0					0	0	0	0
191									0						0					0	0	0	0
192									0						0					0	0	0	0
193									0						0					0	0	0	0
194									0						0					0	0	0	0
195									0						0					0	0	0	0
196									0						0					0	0	0	0
197									0						0					0	0	0	0
198									0						0					0	0	0	0
199									0						0					0	0	0	0
200									0						0					0	0	0	0


1	Spirit Mtn Non-Scored Race B GS							UPDATED FORMULAS	Adjust forumla if needed	Adjust forumla if needed	Adjust forumla if needed		Quality Control Checks			time				rank in category
2	Giant Slalom (U8-U16 / Men)								ID	Category (u8, u10...)	Time	ID on Summary?	Check Name (shows as listed on summary, differences highlighted)	Check Age Category (shows as listed on summary)	Rank in Category	U08	U10	U12	U14	U08	U10	U12	U14
3	Run Ranking 1																								Copy source data starting at Column A (don't go beyond Column O)
4									0						0					0	0	0	0		Check that the formula in Column P refers to ID; change it if needed
5	Rank	Bib	USA ID	Name	Category	Club	Time		#VALUE!	Category	Time				0					0	0	0	0	USA ID Name Category Club	Check that the formula in Column Q gives Category (U14, U12...). If Category isn't in the source data, use the formula below to get it from Year
6									0						0					0	0	0	0		Check that the forumla in Column R refers to the time column; change it if needed.
7									0						0					0	0	0	0		Make sure that any times greater than a minute (1:00.0) are converting to seconds properly in Column R
8	Category: U8								0						0					0	0	0	0		Check that names are as expected
9	1	2	C7013888	Zellmer Samuel	U8	AFT	38.24		7013888	U08	38.24	TRUE	Zellmer Samuel	U08	1	38.24				1	0	0	0		Check that all the Region 1 racers IDs are on Summary. If the ID should be in the summary but it's not -- add it.
10	2	5	C7102519	Peltz Reid	U8	BKH	43.86		7102519	U08	43.86	TRUE	Peltz Reid	U08	2	43.86				2	0	0	0		Check that rankings in category look correct (Rank In Category is in Column U; the summary tab looks for it there)
11	3	3	C7033941	Brunsvold Carter	U8	AFT	49.39		7033941	U08	49.39	TRUE	Brunsvold Carter	U08	3	49.39				3	0	0	0		On the summary, copy the formula from a completed race to this race, but change the sheet name to match this tab
12									0						0					0	0	0	0
13									0						0					0	0	0	0
14	Disqualified (2)								0						0					0	0	0	0
15		1	C7086044	Benson Soren	U8	AFT	Rule missed gate		7086044	U08	Rule missed gate	TRUE	Benson Soren	U08	0	Rule missed gate				0	0	0	0		Formula for Category if only Year, not Category, are given in the source data:
16		4	C7012809	O'Grady Henryk	U8	AFT	Rule missed gate		7012809	U08	Rule missed gate	TRUE	O'Grady Henryk	U08	0	Rule missed gate				0	0	0	0		=IFERROR(VLOOKUP(Value(E16),Category!$A$1:$B$8,2,0),"")
17									0						0					0	0	0	0
18									0						0					0	0	0	0
19	Category: U10								0						0					0	0	0	0
20	1	18	C6931622	Houle John Luc	U10	AFT	33.53		6931622	U10	33.53	TRUE	Houle John Luc	U10	1		33.53			0	1	0	0
21	2	20	C6679237	Titler Teddy	U10	BKH	35.93		6679237	U10	35.93	TRUE	Titler Teddy	U10	2		35.93			0	2	0	0
22	3	14	C6903702	Stinnett Jack	U10	BKH	36.07		6903702	U10	36.07	TRUE	Stinnett Jack	U10	3		36.07			0	3	0	0
23	4	7	C7035289	Rambow Magnus	U10	FST	36.52		7035289	U10	36.52	TRUE	Rambow Magnus	U10	4		36.52			0	4	0	0
24	5	16	C6938427	Moore Tait	U10	CAR	39.4		6938427	U10	39.40				0					0	0	0	0	C6938427 Moore Tait U10 CAR
25	6	9	C6933951	O'Grady Bohdan	U10	AFT	40.75		6933951	U10	40.75	TRUE	O'Grady Bohdan	U10	5		40.75			0	5	0	0
26	7	8	C7106748	Underhill Viggo	U10	BKH	41.46		7106748	U10	41.46	TRUE	Underhill Viggo	U10	6		41.46			0	6	0	0
27	8	15	C7117542	Bristlin Rhys	U10	FST	41.84		7117542	U10	41.84	TRUE	Bristlin Rhys	U10	7		41.84			0	7	0	0
28	9	10	C7031191	Lodermeier Graham	U10	AFT	42.34		7031191	U10	42.34	TRUE	Lodermeier Graham	U10	8		42.34			0	8	0	0
29	10	13	C7083495	Miller Ryder	U10	BKH	51.51		7083495	U10	51.51	TRUE	Miller Ryder	U10	9		51.51			0	9	0	0
30									0						0					0	0	0	0
31									0						0					0	0	0	0
32	Did Not Start (1)								0						0					0	0	0	0
33		21	C7013674	Molinaro Peter	U10	AFT			7013674	U10		TRUE	Molinaro Peter	U10	0					0	0	0	0
34									0						0					0	0	0	0
35									0						0					0	0	0	0
36	Did Not Finish (2)								0						0					0	0	0	0
37		6	C7118379	Knadle Parker	U10				7118379	U10					0					0	0	0	0	C7118379 Knadle Parker U10
38		12	C7037253	Richardson Graham	U10	GIL			7037253	U10		TRUE	Richardson Graham	U10	0					0	0	0	0
39									0						0					0	0	0	0
40									0						0					0	0	0	0
41	Disqualified (3)								0						0					0	0	0	0
42		11	7144398	Micko Dominic	U10		Rule missed gate		7144398	U10	Rule missed gate	TRUE	Micko Dominic	U10	0		Rule missed gate			0	0	0	0
43		17	C7091437	Saewert Otto	U10	GIL	Rule missed gate		7091437	U10	Rule missed gate	TRUE	Saewert Otto	U10	0		Rule missed gate			0	0	0	0
44		19	C7012176	Simon Spencer	U10	GIL	Rule missed gate		7012176	U10	Rule missed gate	TRUE	Simon Spencer	U10	0		Rule missed gate			0	0	0	0
45									0						0					0	0	0	0
46									0						0					0	0	0	0
47	Category: U12								0						0					0	0	0	0
48	1	56	C6679153	Mjanger Luke	U12	AFT	31.11		6679153	U12	31.11	TRUE	Mjanger Luke	U12	1			31.11		0	0	1	0
49	2	23	C6941815	Pope Reed	U12	FST	32.41		6941815	U12	32.41	TRUE	Pope Reed	U12	2			32.41		0	0	2	0
50	3	41	X6751067	Zadvornykh Roman	U12	BKH	32.72		6751067	U12	32.72	TRUE	Zadvornykh Roman	U12	3			32.72		0	0	3	0
51	4	39	C7002342	Sampson Reef	U12	FST	32.87		7002342	U12	32.87	TRUE	Sampson Reef	U12	4			32.87		0	0	4	0
52	5	50	C6944250	Jakobe Benjamin	U12	GIL	33.27		6944250	U12	33.27	TRUE	Jakobe Benjamin	U12	5			33.27		0	0	5	0
53	6	43	R6712468	Campian Alexander	U12	SUM	33.73		6712468	U12	33.73				0					0	0	0	0	R6712468 Campian Alexander U12 SUM
54	7	60	C6983174	Peltz Cole	U12	BKH	33.77		6983174	U12	33.77	TRUE	Peltz Cole	U12	6			33.77		0	0	6	0
55	8	26	C7036119	Stueve Gavin	U12	GIL	33.85		7036119	U12	33.85	TRUE	Stueve Gavin	U12	7			33.85		0	0	7	0
56	9	48	C6983375	Demars Milo	U12	FST	34.17		6983375	U12	34.17	TRUE	Demars Milo	U12	8			34.17		0	0	8	0
57	10	25	C7032006	Geelan Jack	U12	GIL	36.02		7032006	U12	36.02	TRUE	Geelan Jack	U12	9			36.02		0	0	9	0
58	11	54	C7103072	King-Ellison Roenen	U12	BKH	36.44		7103072	U12	36.44	TRUE	King-Ellison Roenen	U12	10			36.44		0	0	10	0
59	12	46	C7018104	Lee Keya	U12	CAR	36.57		7018104	U12	36.57				0					0	0	0	0	C7018104 Lee Keya U12 CAR
60	13	45	C7003414	Glancy Liam	U12	AFT	37.11		7003414	U12	37.11	TRUE	Glancy Liam	U12	11			37.11		0	0	11	0
61	14	49	C7086207	Johnson Caden	U12	AFT	37.31		7086207	U12	37.31	TRUE	Johnson Caden	U12	12			37.31		0	0	12	0
62	15	55	C6773139	Richardson Sawyer	U12	GIL	38.19		6773139	U12	38.19	TRUE	Richardson Sawyer	U12	13			38.19		0	0	13	0
63	16	30	C6970496	Barbeau Avery	U12	FST	38.31		6970496	U12	38.31	TRUE	Barbeau Avery	U12	14			38.31		0	0	14	0
64	17	35	C6778054	Burns William	U12	AFT	39.01		6778054	U12	39.01	TRUE	Burns William	U12	15			39.01		0	0	15	0
65	18	37	C7129523	Barott Laken	U12	FST	39.45		7129523	U12	39.45	TRUE	Barott Laken	U12	16			39.45		0	0	16	0
66	19	44	C7145532	Johnson Kolt	U12	DUL	39.48		7145532	U12	39.48	TRUE	Johnson Kolt	U12	17			39.48		0	0	17	0
67	20	38	C6944207	Larson Finn	U12	GIL	40.58		6944207	U12	40.58	TRUE	Larson Finn	U12	18			40.58		0	0	18	0
68	21	29	C7099664	Radner Cole	U12	BKH	40.69		7099664	U12	40.69	TRUE	Radner Cole	U12	19			40.69		0	0	19	0
69	22	22	C7021691	Kyle Jackson	U12	GIL	40.78		7021691	U12	40.78	TRUE	Kyle Jackson	U12	20			40.78		0	0	20	0
70	23	59	C7012913	Halverson Chase	U12	AFT	40.87		7012913	U12	40.87	TRUE	Halverson Chase	U12	21			40.87		0	0	21	0
71	24	58	C7143194	Ellis Brody	U12	AFT	41.28		7143194	U12	41.28	TRUE	Ellis Brody	U12	22			41.28		0	0	22	0
72	25	36	C7091855	Swanke Ivan	U12	GIL	43.43		7091855	U12	43.43	TRUE	Swanke Ivan	U12	23			43.43		0	0	23	0
73									0						0					0	0	0	0
74									0						0					0	0	0	0
75	Did Not Start (4)								0						0					0	0	0	0
76		28	C7103128	Grandell Nelson	U12	GIL			7103128	U12		TRUE	Grandell Nelson	U12	0					0	0	0	0
77		33	C6938468	Dahl Jackson	U12	CAR			6938468	U12					0					0	0	0	0	C6938468 Dahl Jackson U12 CAR
78		42	C6952905	Johnson Soren	U12	BKH			6952905	U12		TRUE	Johnson Soren	U12	0					0	0	0	0
79		47	C7091243	Margolin Samuel	U12	GIL			7091243	U12		TRUE	Margolin Samuel	U12	0					0	0	0	0
80									0						0					0	0	0	0
81									0						0					0	0	0	0
82	Did Not Finish (4)								0						0					0	0	0	0
83		27	C6824610	Moore Aleksander	U12	CAR			6824610	U12					0					0	0	0	0	C6824610 Moore Aleksander U12 CAR
84		34	C6944248	Kim Charlie	U12	GIL			6944248	U12		TRUE	Kim Charlie	U12	0					0	0	0	0
85		52	C6678643	Levander Everett	U12	AFT			6678643	U12		TRUE	Levander Everett	U12	0					0	0	0	0
86		57	C6779490	Schaeppi Asa	U12	BKH			6779490	U12		TRUE	Schaeppi Asa	U12	0					0	0	0	0
87									0						0					0	0	0	0
88									0						0					0	0	0	0
89	Disqualified (6)								0						0					0	0	0	0
90		24	C7107538	Krause Aden	U12	AFT	Rule missed gate		7107538	U12	Rule missed gate	TRUE	Krause Aden	U12	0			Rule missed gate		0	0	0	0
91		31	C6926242	Brown Griffin	U12	GIL	Rule missed gate		6926242	U12	Rule missed gate	TRUE	Brown Griffin	U12	0			Rule missed gate		0	0	0	0
92		32	C7144614	Laughlin Connor	U12	GIL	Rule missed gate		7144614	U12	Rule missed gate	TRUE	Laughlin Connor	U12	0			Rule missed gate		0	0	0	0
93		40	C7144570	Hinrichs Ben	U12	GIL	Rule missed gate		7144570	U12	Rule missed gate	TRUE	Hinrichs Ben	U12	0			Rule missed gate		0	0	0	0
94		51	X7022048	Negi Saivya	U12	GIL	Rule missed gate		7022048	U12	Rule missed gate	TRUE	Negi Saivya	U12	0			Rule missed gate		0	0	0	0
95		53	C7144247	Johhnson Eli	U12	GIL	Rule missed gate		7144247	U12	Rule missed gate	TRUE	Johhnson Eli	U12	0			Rule missed gate		0	0	0	0
96									0						0					0	0	0	0
97									0						0					0	0	0	0
98									0						0					0	0	0	0
99									0						0					0	0	0	0
100									0						0					0	0	0	0
101									0						0					0	0	0	0
102									0						0					0	0	0	0
103									0						0					0	0	0	0
104									0						0					0	0	0	0
105									0						0					0	0	0	0
106									0						0					0	0	0	0
107									0						0					0	0	0	0
108									0						0					0	0	0	0
109									0						0					0	0	0	0
110									0						0					0	0	0	0
111									0						0					0	0	0	0
112									0						0					0	0	0	0
113									0						0					0	0	0	0
114									0						0					0	0	0	0
115									0						0					0	0	0	0
116									0						0					0	0	0	0
117									0						0					0	0	0	0
118									0						0					0	0	0	0
119									0						0					0	0	0	0
120									0						0					0	0	0	0
121									0						0					0	0	0	0
122									0						0					0	0	0	0
123									0						0					0	0	0	0
124									0						0					0	0	0	0
125									0						0					0	0	0	0
126									0						0					0	0	0	0
127									0						0					0	0	0	0
128									0						0					0	0	0	0
129									0						0					0	0	0	0
130									0						0					0	0	0	0
131									0						0					0	0	0	0
132									0						0					0	0	0	0
133									0						0					0	0	0	0
134									0						0					0	0	0	0
135									0						0					0	0	0	0
136									0						0					0	0	0	0
137									0						0					0	0	0	0
138									0						0					0	0	0	0
139									0						0					0	0	0	0
140									0						0					0	0	0	0
141									0						0					0	0	0	0
142									0						0					0	0	0	0
143									0						0					0	0	0	0
144									0						0					0	0	0	0
145									0						0					0	0	0	0
146									0						0					0	0	0	0
147									0						0					0	0	0	0
148									0						0					0	0	0	0
149									0						0					0	0	0	0
150									0						0					0	0	0	0
151									0						0					0	0	0	0
152									0						0					0	0	0	0
153									0						0					0	0	0	0
154									0						0					0	0	0	0
155									0						0					0	0	0	0
156									0						0					0	0	0	0
157									0						0					0	0	0	0
158									0						0					0	0	0	0
159									0						0					0	0	0	0
160									0						0					0	0	0	0
161									0						0					0	0	0	0
162									0						0					0	0	0	0
163									0						0					0	0	0	0
164									0						0					0	0	0	0
165									0						0					0	0	0	0
166									0						0					0	0	0	0
167									0						0					0	0	0	0
168									0						0					0	0	0	0
169									0						0					0	0	0	0
170									0						0					0	0	0	0
171									0						0					0	0	0	0
172									0						0					0	0	0	0
173									0						0					0	0	0	0
174									0						0					0	0	0	0
175									0						0					0	0	0	0
176									0						0					0	0	0	0
177									0						0					0	0	0	0
178									0						0					0	0	0	0
179									0						0					0	0	0	0
180									0						0					0	0	0	0
181									0						0					0	0	0	0
182									0						0					0	0	0	0
183									0						0					0	0	0	0
184									0						0					0	0	0	0
185									0						0					0	0	0	0
186									0						0					0	0	0	0
187									0						0					0	0	0	0
188									0						0					0	0	0	0
189									0						0					0	0	0	0
190									0						0					0	0	0	0
191									0						0					0	0	0	0
192									0						0					0	0	0	0
193									0						0					0	0	0	0
194									0						0					0	0	0	0
195									0						0					0	0	0	0
196									0						0					0	0	0	0
197									0						0					0	0	0	0
198									0						0					0	0	0	0
199									0						0					0	0	0	0
200									0						0					0	0	0	0


1	Granite Peak NS Races Boys GS Sat								UPDATED FORMULAS	Adjust forumla if needed	Adjust forumla if needed	Adjust forumla if needed		Quality Control Checks			time				rank in category
2	Giant Slalom (Men)									ID	Category (u8, u10...)	Time	ID on Summary?	Check Name (shows as listed on summary, differences highlighted)	Check Age Category (shows as listed on summary)	Rank in Category	U08	U10	U12	U14	U08	U10	U12	U14
3	Run Ranking 1																									Copy source data starting at Column A (don't go beyond Column O)
4										0						0					0	0	0	0		Check that the formula in Column P refers to ID; change it if needed
5	Rank	Bib	USA ID	Name	Category	Club	Time			#VALUE!	Category	Time				0					0	0	0	0	USA ID Name Category Club	Check that the formula in Column Q gives Category (U14, U12...). If Category isn't in the source data, use the formula below to get it from Year
6	1	68	X6751067	Zadvornykh Roman	U12	BKH	48.34			6751067	U12	48.34	TRUE	Zadvornykh Roman	U12	1			48.34		0	0	1	0		Check that the forumla in Column R refers to the time column; change it if needed.

7	2	72	C6884860	Carpenter Ty	U12	LKR	49.06	R2		6884860	U12	49.06				0					0	0	0	0	C6884860 Carpenter Ty U12 LKR	Make sure that any times greater than a minute (1:00.0) are converting to seconds properly in Column R
8	3	36	C6679153	Mjanger Luke	U12	AFT	49.44			6679153	U12	49.44	TRUE	Mjanger Luke	U12	2			49.44		0	0	2	0		Check that names are as expected
9	4	45	C6983174	Peltz Cole	U12	BKH	49.98			6983174	U12	49.98	TRUE	Peltz Cole	U12	3			49.98		0	0	3	0		Check that all the Region 1 racers IDs are on Summary. If the ID should be in the summary but it's not -- add it.
10	5	42	C6678643	Levander Everett	U12	AFT	50.2			6678643	U12	50.20	TRUE	Levander Everett	U12	4			50.20		0	0	4	0		Check that rankings in category look correct (Rank In Category is in Column U; the summary tab looks for it there)
11	6	79	C6821645	Daams Van	U12	SWA	51.1	R2		6821645	U12	51.10				0					0	0	0	0	C6821645 Daams Van U12 SWA	On the summary, copy the formula from a completed race to this race, but change the sheet name to match this tab
12	7	49	C6778054	Burns William	U12	AFT	51.23			6778054	U12	51.23	TRUE	Burns William	U12	5			51.23		0	0	5	0
13	8	30	C6953275	Hopke Brexten	U12	BKH	51.51			6953275	U12	51.51	TRUE	Hopke Brexten	U12	6			51.51		0	0	6	0
14	9	27	C6867501	Nelson Jacob	U12	SWA	51.67	R2		6867501	U12	51.67				0					0	0	0	0	C6867501 Nelson Jacob U12 SWA
15	10	65	C6941815	Pope Reed	U12	FST	51.73			6941815	U12	51.73	TRUE	Pope Reed	U12	7			51.73		0	0	7	0		Formula for Category if only Year, not Category, are given in the source data:
16	11	40	C7002342	Sampson Reef	U12	FST	52.19			7002342	U12	52.19	TRUE	Sampson Reef	U12	8			52.19		0	0	8	0		=IFERROR(VLOOKUP(Value(E16),Category!$A$1:$B$8,2,0),"")
17	12	67	C7103072	King-Ellison Roenen	U12	BKH	52.24			7103072	U12	52.24	TRUE	King-Ellison Roenen	U12	9			52.24		0	0	9	0
18	13	29	C6824610	Moore Aleksander	U12	CAR	52.37	R2		6824610	U12	52.37				0					0	0	0	0	C6824610 Moore Aleksander U12 CAR
19	14	24	C6779490	Schaeppi Asa	U12	BKH	52.57			6779490	U12	52.57	TRUE	Schaeppi Asa	U12	10			52.57		0	0	10	0
20	15	62	C6893211	Brandenburg Bridger	U12	GPK	53.17	R2		6893211	U12	53.17				0					0	0	0	0	C6893211 Brandenburg Bridger U12 GPK
21	16	25	C6905066	Hausmann Carter	U12	ASB	53.39	R2		6905066	U12	53.39				0					0	0	0	0	C6905066 Hausmann Carter U12 ASB
22	17	22	C7085049	Richardson Anders	U10	GIL	54.39			7085049	U10	54.39	TRUE	Richardson Anders	U10	1		54.39			0	1	0	0
23	18	13	C6931622	Houle John Luc	U10	AFT	54.44			6931622	U10	54.44	TRUE	Houle John Luc	U10	2		54.44			0	2	0	0
24	19	66	C6771406	Cryer Carson	U12	BKH	55.37			6771406	U12	55.37	TRUE	Cryer Carson	U12	11			55.37		0	0	11	0
25	20	23	C6679237	Titler Teddy	U10	BKH	55.67			6679237	U10	55.67	TRUE	Titler Teddy	U10	3		55.67			0	3	0	0
26	21	35	C6944250	Jakobe Benjamin	U12	GIL	56.51			6944250	U12	56.51	TRUE	Jakobe Benjamin	U12	12			56.51		0	0	12	0
27	22	41	C6983375	Demars Milo	U12	FST	56.77			6983375	U12	56.77	TRUE	Demars Milo	U12	13			56.77		0	0	13	0
28	23	17	C7118379	Knadle Parker	U10		56.79	R2		7118379	U10	56.79				0					0	0	0	0	C7118379 Knadle Parker U10
29	24	15	C7035289	Rambow Magnus	U10	FST	56.98			7035289	U10	56.98	TRUE	Rambow Magnus	U10	4		56.98			0	4	0	0
30	25	77	C7018104	Lee Keya	U12	CAR	56.99	R2		7018104	U12	56.99				0					0	0	0	0	C7018104 Lee Keya U12 CAR
31	26	11	C6903702	Stinnett Jack	U10	BKH	57.02			6903702	U10	57.02	TRUE	Stinnett Jack	U10	5		57.02			0	5	0	0
32	27	74	C6718411	Main William	U12	GPK	57.11	R2		6718411	U12	57.11				0					0	0	0	0	C6718411 Main William U12 GPK
33	28	52	C6752483	Laudenbach Cyrus	U12	GPK	58.7	R2		6752483	U12	58.70				0					0	0	0	0	C6752483 Laudenbach Cyrus U12 GPK
34	29	55	C7129523	Barott Laken	U12	FST	58.76	R2		7129523	U12	58.76	TRUE	Barott Laken	U12	14			58.76		0	0	14	0
35	30	78	C7106837	Underhill Griffin	U12	BKH	58.84			7106837	U12	58.84	TRUE	Underhill Griffin	U12	15			58.84		0	0	15	0
36	31	56	C6938468	Dahl Jackson	U12	CAR	59.58	R2		6938468	U12	59.58				0					0	0	0	0	C6938468 Dahl Jackson U12 CAR
37	32	39	C6952905	Johnson Soren	U12	BKH	59.65			6952905	U12	59.65	TRUE	Johnson Soren	U12	16			59.65		0	0	16	0
38	33	53	C6659098	Hynes Ethan	U12	GPK	60.78	R2		6659098	U12	60.78				0					0	0	0	0	C6659098 Hynes Ethan U12 GPK
39	34	16	C6938427	Moore Tait	U10	CAR	61.33	R2		6938427	U10	61.33				0					0	0	0	0	C6938427 Moore Tait U10 CAR
40	35	61	C6773139	Richardson Sawyer	U12	GIL	61.35			6773139	U12	61.35	TRUE	Richardson Sawyer	U12	17			61.35		0	0	17	0
41	36	64	C7017726	Anderson Logan	U12	CAR	61.6	R2		7017726	U12	61.60				0					0	0	0	0	C7017726 Anderson Logan U12 CAR
42	37	37	C7145532	Johnson Kolt	U12	DUL	61.64			7145532	U12	61.64	TRUE	Johnson Kolt	U12	18			61.64		0	0	18	0
43	38	19	C7013674	Molinaro Peter	U10	AFT	61.72			7013674	U10	61.72	TRUE	Molinaro Peter	U10	6		61.72			0	6	0	0
44	39	46	C7142995	Hagen Tommy	U12	GIL	63.35			7142995	U12	63.35	TRUE	Hagen Tommy	U12	19			63.35		0	0	19	0
45	40	20	C7012176	Simon Spencer	U10	GIL	63.51			7012176	U10	63.51	TRUE	Simon Spencer	U10	7		63.51			0	7	0	0
46	41	10	C7031191	Lodermeier Graham	U10	AFT	63.96			7031191	U10	63.96	TRUE	Lodermeier Graham	U10	8		63.96			0	8	0	0
47	42	14	C6849038	Main Samuel	U10	GPK	64.38	R2		6849038	U10	64.38				0					0	0	0	0	C6849038 Main Samuel U10 GPK
48	43	63	C7099664	Radner Cole	U12	BKH	65.08			7099664	U12	65.08	TRUE	Radner Cole	U12	20			65.08		0	0	20	0
49	44	58	X7022048	Negi Saivya	U12	GIL	65.24			7022048	U12	65.24	TRUE	Negi Saivya	U12	21			65.24		0	0	21	0
50	45	73	C7091855	Swanke Ivan	U12	GIL	65.56			7091855	U12	65.56	TRUE	Swanke Ivan	U12	22			65.56		0	0	22	0
51	46	28	C7021691	Kyle Jackson	U12	GIL	67.08			7021691	U12	67.08	TRUE	Kyle Jackson	U12	23			67.08		0	0	23	0
52	47	60	C6970496	Barbeau Avery	U12	FST	67.11			6970496	U12	67.11	TRUE	Barbeau Avery	U12	24			67.11		0	0	24	0
53	48	5	C7102519	Peltz Reid	U8	BKH	67.14			7102519	U08	67.14	TRUE	Peltz Reid	U08	1	67.14				1	0	0	0
54	49	26	C6944248	Kim Charlie	U12	GIL	67.57			6944248	U12	67.57	TRUE	Kim Charlie	U12	25			67.57		0	0	25	0
55	50	69	C7115799	Mallery Rigby	U12	GIL	67.93			7115799	U12	67.93	TRUE	Mallery Rigby	U12	26			67.93		0	0	26	0
56	51	1	C6893228	Brandenburg Ryder	U8	GPK	68.77	R2		6893228	U08	68.77				0					0	0	0	0	C6893228 Brandenburg Ryder U8 GPK
57	52	75	C7091243	Margolin Samuel	U12	GIL	69.34			7091243	U12	69.34	TRUE	Margolin Samuel	U12	27			69.34		0	0	27	0
58	53	18	C7106748	Underhill Viggo	U10	BKH	69.48			7106748	U10	69.48	TRUE	Underhill Viggo	U10	9		69.48			0	9	0	0
59	54	7	C7140797	Marchesi Milo	U8	BKH	69.87			7140797	U08	69.87	TRUE	Marchesi Milo	U08	2	69.87				2	0	0	0
60	55	54	C7107847	Marthaler Donek	U12	BKH	70.5			7107847	U12	70.50	TRUE	Marthaler Donek	U12	28			70.50		0	0	28	0
61	56	8	C7037253	Richardson Graham	U10	GIL	70.78			7037253	U10	70.78	TRUE	Richardson Graham	U10	10		70.78			0	10	0	0
62	57	81	C7159692	Rice Bridger	U12	GPK	72.47	R2		7159692	U12	72.47				0					0	0	0	0	C7159692 Rice Bridger U12 GPK
63	58	12	C7091437	Saewert Otto	U10	GIL	73.66			7091437	U10	73.66	TRUE	Saewert Otto	U10	11		73.66			0	11	0	0
64	59	9	C7083495	Miller Ryder	U10	BKH	74.45			7083495	U10	74.45	TRUE	Miller Ryder	U10	12		74.45			0	12	0	0
65	60	57	C6944207	Larson Finn	U12	GIL	74.77			6944207	U12	74.77	TRUE	Larson Finn	U12	29			74.77		0	0	29	0
66										0						0					0	0	0	0
67										0						0					0	0	0	0
68	Did Not Start (3)									0						0					0	0	0	0
69		3	C7159818	Comstock Waylon	U8			R2		7159818	U08		TRUE	Comstock Waylon	U08	0					0	0	0	0
70		38	C7062602	Eiseman Ivar	U12	SWA		R2		7062602	U12					0					0	0	0	0	C7062602 Eiseman Ivar U12 SWA
71		70	C6926242	Brown Griffin	U12	GIL				6926242	U12		TRUE	Brown Griffin	U12	0					0	0	0	0
72										0						0					0	0	0	0
73										0						0					0	0	0	0
74	Did Not Finish (2)									0						0					0	0	0	0
75		31	R6712468	Campian Alexander	U12	SUM		Rocky		6712468	U12					0					0	0	0	0	R6712468 Campian Alexander U12 SUM
76		47	C7036119	Stueve Gavin	U12	GIL				7036119	U12		TRUE	Stueve Gavin	U12	0					0	0	0	0
77										0						0					0	0	0	0
78										0						0					0	0	0	0
79										0						0					0	0	0	0
80										0						0					0	0	0	0
81										0						0					0	0	0	0
82										0						0					0	0	0	0
83										0						0					0	0	0	0
84										0						0					0	0	0	0
85										0						0					0	0	0	0
86										0						0					0	0	0	0
87										0						0					0	0	0	0
88										0						0					0	0	0	0
89										0						0					0	0	0	0
90										0						0					0	0	0	0
91										0						0					0	0	0	0
92										0						0					0	0	0	0
93										0						0					0	0	0	0
94										0						0					0	0	0	0
95										0						0					0	0	0	0
96										0						0					0	0	0	0
97										0						0					0	0	0	0
98										0						0					0	0	0	0
99										0						0					0	0	0	0
100										0						0					0	0	0	0
101										0						0					0	0	0	0
102										0						0					0	0	0	0
103										0						0					0	0	0	0
104										0						0					0	0	0	0
105										0						0					0	0	0	0
106										0						0					0	0	0	0
107										0						0					0	0	0	0
108										0						0					0	0	0	0
109										0						0					0	0	0	0
110										0						0					0	0	0	0
111										0						0					0	0	0	0
112										0						0					0	0	0	0
113										0						0					0	0	0	0
114										0						0					0	0	0	0
115										0						0					0	0	0	0
116										0						0					0	0	0	0
117										0						0					0	0	0	0
118										0						0					0	0	0	0
119										0						0					0	0	0	0
120										0						0					0	0	0	0
121										0						0					0	0	0	0
122										0						0					0	0	0	0
123										0						0					0	0	0	0
124										0						0					0	0	0	0
125										0						0					0	0	0	0
126										0						0					0	0	0	0
127										0						0					0	0	0	0
128										0						0					0	0	0	0
129										0						0					0	0	0	0
130										0						0					0	0	0	0
131										0						0					0	0	0	0
132										0						0					0	0	0	0
133										0						0					0	0	0	0
134										0						0					0	0	0	0
135										0						0					0	0	0	0
136										0						0					0	0	0	0
137										0						0					0	0	0	0
138										0						0					0	0	0	0
139										0						0					0	0	0	0
140										0						0					0	0	0	0
141										0						0					0	0	0	0
142										0						0					0	0	0	0
143										0						0					0	0	0	0
144										0						0					0	0	0	0
145										0						0					0	0	0	0
146										0						0					0	0	0	0
147										0						0					0	0	0	0
148										0						0					0	0	0	0
149										0						0					0	0	0	0
150										0						0					0	0	0	0
151										0						0					0	0	0	0
152										0						0					0	0	0	0
153										0						0					0	0	0	0
154										0						0					0	0	0	0
155										0						0					0	0	0	0
156										0						0					0	0	0	0
157										0						0					0	0	0	0
158										0						0					0	0	0	0
159										0						0					0	0	0	0
160										0						0					0	0	0	0
161										0						0					0	0	0	0
162										0						0					0	0	0	0
163										0						0					0	0	0	0
164										0						0					0	0	0	0
165										0						0					0	0	0	0
166										0						0					0	0	0	0
167										0						0					0	0	0	0
168										0						0					0	0	0	0
169										0						0					0	0	0	0
170										0						0					0	0	0	0
171										0						0					0	0	0	0
172										0						0					0	0	0	0
173										0						0					0	0	0	0
174										0						0					0	0	0	0
175										0						0					0	0	0	0
176										0						0					0	0	0	0
177										0						0					0	0	0	0
178										0						0					0	0	0	0
179										0						0					0	0	0	0
180										0						0					0	0	0	0
181										0						0					0	0	0	0
182										0						0					0	0	0	0
183										0						0					0	0	0	0
184										0						0					0	0	0	0
185										0						0					0	0	0	0
186										0						0					0	0	0	0
187										0						0					0	0	0	0
188										0						0					0	0	0	0
189										0						0					0	0	0	0
190										0						0					0	0	0	0
191										0						0					0	0	0	0
192										0						0					0	0	0	0
193										0						0					0	0	0	0
194										0						0					0	0	0	0
195										0						0					0	0	0	0
196										0						0					0	0	0	0
197										0						0					0	0	0	0
198										0						0					0	0	0	0
199										0						0					0	0	0	0
200										0						0					0	0	0	0


1	Granite Peak NS Races Boys GS Sun							UPDATED FORMULAS	Adjust forumla if needed	Adjust forumla if needed	Adjust forumla if needed		Quality Control Checks			time				rank in category
2	Giant Slalom (Men)								ID	Category (u8, u10...)	Time	ID on Summary?	Check Name (shows as listed on summary, differences highlighted)	Check Age Category (shows as listed on summary)	Rank in Category	U08	U10	U12	U14	U08	U10	U12	U14
3	Run Ranking 1																								Copy source data starting at Column A (don't go beyond Column O)
4									0						0					0	0	0	0		Check that the formula in Column P refers to ID; change it if needed
5	Rank	Bib	USA ID	Name	Category	Club	Time		#VALUE!	Category	Time				0					0	0	0	0	USA ID Name Category Club	Check that the formula in Column Q gives Category (U14, U12...). If Category isn't in the source data, use the formula below to get it from Year
6	1	45	C6983174	Peltz Cole	U12	BKH	46.6		6983174	U12	46.60	TRUE	Peltz Cole	U12	1			46.60		0	0	1	0		Check that the forumla in Column R refers to the time column; change it if needed.

7	2	36	C6679153	Mjanger Luke	U12	AFT	47.04		6679153	U12	47.04	TRUE	Mjanger Luke	U12	2			47.04		0	0	2	0		Make sure that any times greater than a minute (1:00.0) are converting to seconds properly in Column R
8	3	68	X6751067	Zadvornykh Roman	U12	BKH	47.58		6751067	U12	47.58	TRUE	Zadvornykh Roman	U12	3			47.58		0	0	3	0		Check that names are as expected
9	4	30	C6953275	Hopke Brexten	U12	BKH	48.08		6953275	U12	48.08	TRUE	Hopke Brexten	U12	4			48.08		0	0	4	0		Check that all the Region 1 racers IDs are on Summary. If the ID should be in the summary but it's not -- add it.
10	5	65	C6941815	Pope Reed	U12	FST	48.33		6941815	U12	48.33	TRUE	Pope Reed	U12	5			48.33		0	0	5	0		Check that rankings in category look correct (Rank In Category is in Column U; the summary tab looks for it there)
11	6	42	C6678643	Levander Everett	U12	AFT	48.41		6678643	U12	48.41	TRUE	Levander Everett	U12	6			48.41		0	0	6	0		On the summary, copy the formula from a completed race to this race, but change the sheet name to match this tab
12	7	49	C6778054	Burns William	U12	AFT	48.82		6778054	U12	48.82	TRUE	Burns William	U12	7			48.82		0	0	7	0
13	8	29	C6824610	Moore Aleksander	U12	CAR	49.28		6824610	U12	49.28				0					0	0	0	0	C6824610 Moore Aleksander U12 CAR
14	9	79	C6821645	Daams Van	U12	SWA	49.36		6821645	U12	49.36				0					0	0	0	0	C6821645 Daams Van U12 SWA
15	10	101	C6920544	Katzfuss Mason	U12	ASB	49.49		6920544	U12	49.49				0					0	0	0	0	C6920544 Katzfuss Mason U12 ASB	Formula for Category if only Year, not Category, are given in the source data:
16	11	27	C6867501	Nelson Jacob	U12	SWA	49.86		6867501	U12	49.86				0					0	0	0	0	C6867501 Nelson Jacob U12 SWA	=IFERROR(VLOOKUP(Value(E16),Category!$A$1:$B$8,2,0),"")
17	12	13	C6931622	Houle John Luc	U10	AFT	50.4		6931622	U10	50.40	TRUE	Houle John Luc	U10	1		50.40			0	1	0	0
18	13	67	C7103072	King-Ellison Roenen	U12	BKH	50.76		7103072	U12	50.76	TRUE	King-Ellison Roenen	U12	8			50.76		0	0	8	0
19	14	62	C6893211	Brandenburg Bridger	U12	GPK	50.89		6893211	U12	50.89				0					0	0	0	0	C6893211 Brandenburg Bridger U12 GPK
20	15	31	R6712468	Campian Alexander	U12	SUM	50.93		6712468	U12	50.93				0					0	0	0	0	R6712468 Campian Alexander U12 SUM
21	16	24	C6779490	Schaeppi Asa	U12	BKH	51.28		6779490	U12	51.28	TRUE	Schaeppi Asa	U12	9			51.28		0	0	9	0
22	17	22	C7085049	Richardson Anders	U10	GIL	51.69		7085049	U10	51.69	TRUE	Richardson Anders	U10	2		51.69			0	2	0	0
23	18	23	C6679237	Titler Teddy	U10	BKH	51.74		6679237	U10	51.74	TRUE	Titler Teddy	U10	3		51.74			0	3	0	0
24	19	66	C6771406	Cryer Carson	U12	BKH	52.58		6771406	U12	52.58	TRUE	Cryer Carson	U12	10			52.58		0	0	10	0
25	20	15	C7035289	Rambow Magnus	U10	FST	53.49		7035289	U10	53.49	TRUE	Rambow Magnus	U10	4		53.49			0	4	0	0
26	21	17	C7118379	Knadle Parker	U10		53.69		7118379	U10	53.69				0					0	0	0	0	C7118379 Knadle Parker U10
27	22	56	C6938468	Dahl Jackson	U12	CAR	54.09		6938468	U12	54.09				0					0	0	0	0	C6938468 Dahl Jackson U12 CAR
28	23	41	C6983375	Demars Milo	U12	FST	54.36		6983375	U12	54.36	TRUE	Demars Milo	U12	11			54.36		0	0	11	0
29	24	35	C6944250	Jakobe Benjamin	U12	GIL	54.44		6944250	U12	54.44	TRUE	Jakobe Benjamin	U12	12			54.44		0	0	12	0
30	25	74	C6718411	Main William	U12	GPK	54.47		6718411	U12	54.47				0					0	0	0	0	C6718411 Main William U12 GPK
31	26	39	C6952905	Johnson Soren	U12	BKH	54.7		6952905	U12	54.70	TRUE	Johnson Soren	U12	13			54.70		0	0	13	0
32	27	77	C7018104	Lee Keya	U12	CAR	54.85		7018104	U12	54.85				0					0	0	0	0	C7018104 Lee Keya U12 CAR
33	28	11	C6903702	Stinnett Jack	U10	BKH	54.98		6903702	U10	54.98	TRUE	Stinnett Jack	U10	5		54.98			0	5	0	0
34	29	19	C7013674	Molinaro Peter	U10	AFT	55.8		7013674	U10	55.80	TRUE	Molinaro Peter	U10	6		55.80			0	6	0	0
35	30	64	C7017726	Anderson Logan	U12	CAR	56.04		7017726	U12	56.04				0					0	0	0	0	C7017726 Anderson Logan U12 CAR
36	31	38	C7062602	Eiseman Ivar	U12	SWA	56.58		7062602	U12	56.58				0					0	0	0	0	C7062602 Eiseman Ivar U12 SWA
37	32	55	C7129523	Barott Laken	U12	FST	56.7		7129523	U12	56.70	TRUE	Barott Laken	U12	14			56.70		0	0	14	0
38	33	37	C7145532	Johnson Kolt	U12	DUL	57.51		7145532	U12	57.51	TRUE	Johnson Kolt	U12	15			57.51		0	0	15	0
39	34	8	C7037253	Richardson Graham	U10	GIL	58		7037253	U10	58.00	TRUE	Richardson Graham	U10	7		58.00			0	7	0	0
40	35	53	C6659098	Hynes Ethan	U12	GPK	58.64		6659098	U12	58.64				0					0	0	0	0	C6659098 Hynes Ethan U12 GPK
41	36	102	C7026296	Peret Jax	U10	LKR	59.2		7026296	U10	59.20				0					0	0	0	0	C7026296 Peret Jax U10 LKR
42	37	60	C6970496	Barbeau Avery	U12	FST	59.81		6970496	U12	59.81	TRUE	Barbeau Avery	U12	16			59.81		0	0	16	0
43	38	58	X7022048	Negi Saivya	U12	GIL	59.85		7022048	U12	59.85	TRUE	Negi Saivya	U12	17			59.85		0	0	17	0
44	39	20	C7012176	Simon Spencer	U10	GIL	60.42		7012176	U10	60.42	TRUE	Simon Spencer	U10	8		60.42			0	8	0	0
45	40	16	C6938427	Moore Tait	U10	CAR	60.51		6938427	U10	60.51				0					0	0	0	0	C6938427 Moore Tait U10 CAR
46	41	14	C6849038	Main Samuel	U10	GPK	60.59		6849038	U10	60.59				0					0	0	0	0	C6849038 Main Samuel U10 GPK
47	42	46	C7142995	Hagen Tommy	U12	GIL	60.64		7142995	U12	60.64	TRUE	Hagen Tommy	U12	18			60.64		0	0	18	0
48	43	26	C6944248	Kim Charlie	U12	GIL	61.7		6944248	U12	61.70	TRUE	Kim Charlie	U12	19			61.70		0	0	19	0
49	44	10	C7031191	Lodermeier Graham	U10	AFT	61.93		7031191	U10	61.93	TRUE	Lodermeier Graham	U10	9		61.93			0	9	0	0
50	45	75	C7091243	Margolin Samuel	U12	GIL	62.07		7091243	U12	62.07	TRUE	Margolin Samuel	U12	20			62.07		0	0	20	0
51	46	69	C7115799	Mallery Rigby	U12	GIL	62.34		7115799	U12	62.34	TRUE	Mallery Rigby	U12	21			62.34		0	0	21	0
52	47	5	C7102519	Peltz Reid	U8	BKH	62.4		7102519	U08	62.40	TRUE	Peltz Reid	U08	1	62.40				1	0	0	0
53	48	47	C7036119	Stueve Gavin	U12	GIL	63.24		7036119	U12	63.24	TRUE	Stueve Gavin	U12	22			63.24		0	0	22	0
54	49	28	C7021691	Kyle Jackson	U12	GIL	63.9		7021691	U12	63.90	TRUE	Kyle Jackson	U12	23			63.90		0	0	23	0
55	50	146	C7144247	Johhnson Eli	U12	GIL	64.49		7144247	U12	64.49	TRUE	Johhnson Eli	U12	24			64.49		0	0	24	0
56	51	1	C6893228	Brandenburg Ryder	U8	GPK	65.08		6893228	U08	65.08				0					0	0	0	0	C6893228 Brandenburg Ryder U8 GPK
57	52	12	C7091437	Saewert Otto	U10	GIL	65.4		7091437	U10	65.40	TRUE	Saewert Otto	U10	10		65.40			0	10	0	0
58	53	54	C7107847	Marthaler Donek	U12	BKH	65.81		7107847	U12	65.81	TRUE	Marthaler Donek	U12	25			65.81		0	0	25	0
59	54	73	C7091855	Swanke Ivan	U12	GIL	65.86		7091855	U12	65.86	TRUE	Swanke Ivan	U12	26			65.86		0	0	26	0
60	55	57	C6944207	Larson Finn	U12	GIL	67.11		6944207	U12	67.11	TRUE	Larson Finn	U12	27			67.11		0	0	27	0
61	56	103	C7027224	Wilke W.	U10	LKR	67.88		7027224	U10	67.88				0					0	0	0	0	C7027224 Wilke W. U10 LKR
62	57	9	C7083495	Miller Ryder	U10	BKH	70.72		7083495	U10	70.72	TRUE	Miller Ryder	U10	11		70.72			0	11	0	0
63	58	3	C7159818	Comstock Waylon	U8		74.33		7159818	U08	74.33	TRUE	Comstock Waylon	U08	2	74.33				2	0	0	0
64									0						0					0	0	0	0
65									0						0					0	0	0	0
66	Did Not Start (6)								0						0					0	0	0	0
67		18	C7106748	Underhill Viggo	U10	BKH			7106748	U10		TRUE	Underhill Viggo	U10	0					0	0	0	0
68		61	C6773139	Richardson Sawyer	U12	GIL			6773139	U12		TRUE	Richardson Sawyer	U12	0					0	0	0	0
69		63	C7099664	Radner Cole	U12	BKH			7099664	U12		TRUE	Radner Cole	U12	0					0	0	0	0
70		70	C6926242	Brown Griffin	U12	GIL			6926242	U12		TRUE	Brown Griffin	U12	0					0	0	0	0
71		78	C7106837	Underhill Griffin	U12	BKH			7106837	U12		TRUE	Underhill Griffin	U12	0					0	0	0	0
72		81	C7159692	Rice Bridger	U12	GPK			7159692	U12					0					0	0	0	0	C7159692 Rice Bridger U12 GPK
73									0						0					0	0	0	0
74									0						0					0	0	0	0
75	Did Not Finish (4)								0						0					0	0	0	0
76		25	C6905066	Hausmann Carter	U12	ASB			6905066	U12					0					0	0	0	0	C6905066 Hausmann Carter U12 ASB
77		40	C7002342	Sampson Reef	U12	FST			7002342	U12		TRUE	Sampson Reef	U12	0					0	0	0	0
78		52	C6752483	Laudenbach Cyrus	U12	GPK			6752483	U12					0					0	0	0	0	C6752483 Laudenbach Cyrus U12 GPK
79		72	C6884860	Carpenter Ty	U12	LKR			6884860	U12					0					0	0	0	0	C6884860 Carpenter Ty U12 LKR
80									0						0					0	0	0	0
81									0						0					0	0	0	0
82	Disqualified (1)								0						0					0	0	0	0
83		7	C7140797	Marchesi Milo	U8	BKH	Rule 661.4.1		7140797	U08	Rule 661.4.1	TRUE	Marchesi Milo	U08	0	Rule 661.4.1				0	0	0	0
84									0						0					0	0	0	0
85									0						0					0	0	0	0
86									0						0					0	0	0	0
87									0						0					0	0	0	0
88									0						0					0	0	0	0
89									0						0					0	0	0	0
90									0						0					0	0	0	0
91									0						0					0	0	0	0
92									0						0					0	0	0	0
93									0						0					0	0	0	0
94									0						0					0	0	0	0
95									0						0					0	0	0	0
96									0						0					0	0	0	0
97									0						0					0	0	0	0
98									0						0					0	0	0	0
99									0						0					0	0	0	0
100									0						0					0	0	0	0
101									0						0					0	0	0	0
102									0						0					0	0	0	0
103									0						0					0	0	0	0
104									0						0					0	0	0	0
105									0						0					0	0	0	0
106									0						0					0	0	0	0
107									0						0					0	0	0	0
108									0						0					0	0	0	0
109									0						0					0	0	0	0
110									0						0					0	0	0	0
111									0						0					0	0	0	0
112									0						0					0	0	0	0
113									0						0					0	0	0	0
114									0						0					0	0	0	0
115									0						0					0	0	0	0
116									0						0					0	0	0	0
117									0						0					0	0	0	0
118									0						0					0	0	0	0
119									0						0					0	0	0	0
120									0						0					0	0	0	0
121									0						0					0	0	0	0
122									0						0					0	0	0	0
123									0						0					0	0	0	0
124									0						0					0	0	0	0
125									0						0					0	0	0	0
126									0						0					0	0	0	0
127									0						0					0	0	0	0
128									0						0					0	0	0	0
129									0						0					0	0	0	0
130									0						0					0	0	0	0
131									0						0					0	0	0	0
132									0						0					0	0	0	0
133									0						0					0	0	0	0
134									0						0					0	0	0	0
135									0						0					0	0	0	0
136									0						0					0	0	0	0
137									0						0					0	0	0	0
138									0						0					0	0	0	0
139									0						0					0	0	0	0
140									0						0					0	0	0	0
141									0						0					0	0	0	0
142									0						0					0	0	0	0
143									0						0					0	0	0	0
144									0						0					0	0	0	0
145									0						0					0	0	0	0
146									0						0					0	0	0	0
147									0						0					0	0	0	0
148									0						0					0	0	0	0
149									0						0					0	0	0	0
150									0						0					0	0	0	0
151									0						0					0	0	0	0
152									0						0					0	0	0	0
153									0						0					0	0	0	0
154									0						0					0	0	0	0
155									0						0					0	0	0	0
156									0						0					0	0	0	0
157									0						0					0	0	0	0
158									0						0					0	0	0	0
159									0						0					0	0	0	0
160									0						0					0	0	0	0
161									0						0					0	0	0	0
162									0						0					0	0	0	0
163									0						0					0	0	0	0
164									0						0					0	0	0	0
165									0						0					0	0	0	0
166									0						0					0	0	0	0
167									0						0					0	0	0	0
168									0						0					0	0	0	0
169									0						0					0	0	0	0
170									0						0					0	0	0	0
171									0						0					0	0	0	0
172									0						0					0	0	0	0
173									0						0					0	0	0	0
174									0						0					0	0	0	0
175									0						0					0	0	0	0
176									0						0					0	0	0	0
177									0						0					0	0	0	0
178									0						0					0	0	0	0
179									0						0					0	0	0	0
180									0						0					0	0	0	0
181									0						0					0	0	0	0
182									0						0					0	0	0	0
183									0						0					0	0	0	0
184									0						0					0	0	0	0
185									0						0					0	0	0	0
186									0						0					0	0	0	0
187									0						0					0	0	0	0
188									0						0					0	0	0	0
189									0						0					0	0	0	0
190									0						0					0	0	0	0
191									0						0					0	0	0	0
192									0						0					0	0	0	0
193									0						0					0	0	0	0
194									0						0					0	0	0	0
195									0						0					0	0	0	0
196									0						0					0	0	0	0
197									0						0					0	0	0	0
198									0						0					0	0	0	0
199									0						0					0	0	0	0
200									0						0					0	0	0	0


1	Planet Cup Finale U8-U12 Boys GS							UPDATED FORMULAS	Adjust forumla if needed	Adjust forumla if needed	Adjust forumla if needed		Quality Control Checks			time				rank in category
2	Giant Slalom (U8-U16 / Men)								ID	Category (u8, u10...)	Time	ID on Summary?	Check Name (shows as listed on summary, differences highlighted)	Check Age Category (shows as listed on summary)	Rank in Category	U08	U10	U12	U14	U08	U10	U12	U14
3	Run Ranking 1																								Copy source data starting at Column A (don't go beyond Column O)
4									0						0					0	0	0	0		Check that the formula in Column P refers to ID; change it if needed
5	Rank	Bib	USA ID	Name	Category	Club	Time		#VALUE!	Category	Time				0					0	0	0	0	USA ID Name Category Club	Check that the formula in Column Q gives Category (U14, U12...). If Category isn't in the source data, use the formula below to get it from Year
6	1	56	C6679153	Mjanger Luke	U12	AFT	23.22		6679153	U12	23.22	TRUE	Mjanger Luke	U12	1			23.22		0	0	1	0		Check that the forumla in Column R refers to the time column; change it if needed.

7	2	23	C6941815	Pope Reed	U12	FST	23.31		6941815	U12	23.31	TRUE	Pope Reed	U12	2			23.31		0	0	2	0		Make sure that any times greater than a minute (1:00.0) are converting to seconds properly in Column R
8	3	52	C6678643	Levander Everett	U12	AFT	24.1		6678643	U12	24.10	TRUE	Levander Everett	U12	3			24.10		0	0	3	0		Check that names are as expected
9	4	35	C6778054	Burns William	U12	AFT	24.14		6778054	U12	24.14	TRUE	Burns William	U12	4			24.14		0	0	4	0		Check that all the Region 1 racers IDs are on Summary. If the ID should be in the summary but it's not -- add it.
10	5	74	C6953275	Hopke Brexten	U12	BKH	24.34		6953275	U12	24.34	TRUE	Hopke Brexten	U12	5			24.34		0	0	5	0		Check that rankings in category look correct (Rank In Category is in Column U; the summary tab looks for it there)
11	6	39	C7002342	Sampson Reef	U12	FST	24.38		7002342	U12	24.38	TRUE	Sampson Reef	U12	6			24.38		0	0	6	0		On the summary, copy the formula from a completed race to this race, but change the sheet name to match this tab
12	7	41	X6751067	Zadvornykh Roman	U12	BKH	24.5		6751067	U12	24.50	TRUE	Zadvornykh Roman	U12	7			24.50		0	0	7	0
13	8	57	C6779490	Schaeppi Asa	U12	BKH	24.58		6779490	U12	24.58	TRUE	Schaeppi Asa	U12	8			24.58		0	0	8	0
14	9	60	C6983174	Peltz Cole	U12	BKH	24.62		6983174	U12	24.62	TRUE	Peltz Cole	U12	9			24.62		0	0	9	0
15	10	18	C6931622	Houle John Luc	U10	AFT	25.03		6931622	U10	25.03	TRUE	Houle John Luc	U10	1		25.03			0	1	0	0		Formula for Category if only Year, not Category, are given in the source data:
16	11	7	C7035289	Rambow Magnus	U10	FST	25.05		7035289	U10	25.05	TRUE	Rambow Magnus	U10	2		25.05			0	2	0	0		=IFERROR(VLOOKUP(Value(E16),Category!$A$1:$B$8,2,0),"")
17	12	20	C6679237	Titler Teddy	U10	BKH	25.51		6679237	U10	25.51	TRUE	Titler Teddy	U10	3		25.51			0	3	0	0
18	13	85	C6771406	Cryer Carson	U12	BKH	25.52		6771406	U12	25.52	TRUE	Cryer Carson	U12	10			25.52		0	0	10	0
19	14	14	C6903702	Stinnett Jack	U10	BKH	26.62		6903702	U10	26.62	TRUE	Stinnett Jack	U10	4		26.62			0	4	0	0
20	15	26	C7036119	Stueve Gavin	U12	GIL	26.94		7036119	U12	26.94	TRUE	Stueve Gavin	U12	11			26.94		0	0	11	0
21	16	10	C7031191	Lodermeier Graham	U10	AFT	26.95		7031191	U10	26.95	TRUE	Lodermeier Graham	U10	5		26.95			0	5	0	0
22	17	65	C7106837	Underhill Griffin	U12	BKH	26.97		7106837	U12	26.97	TRUE	Underhill Griffin	U12	12			26.97		0	0	12	0
23	18	42	C6952905	Johnson Soren	U12	BKH	27.08		6952905	U12	27.08	TRUE	Johnson Soren	U12	13			27.08		0	0	13	0
24	19	70	C7032999	Mayerle Wes	U12	AFT	27.34		7032999	U12	27.34	TRUE	Mayerle Wes	U12	14			27.34		0	0	14	0
25	20	19	C7012176	Simon Spencer	U10	GIL	27.6		7012176	U10	27.60	TRUE	Simon Spencer	U10	6		27.60			0	6	0	0
26	21	37	C7129523	Barott Laken	U12	FST	27.74		7129523	U12	27.74	TRUE	Barott Laken	U12	15			27.74		0	0	15	0
27	22	5	C7102519	Peltz Reid	U8	BKH	28.87		7102519	U08	28.87	TRUE	Peltz Reid	U08	1	28.87				1	0	0	0
28	23	9	C6933951	O'Grady Bohdan	U10	AFT	29.03		6933951	U10	29.03	TRUE	O'Grady Bohdan	U10	7		29.03			0	7	0	0
29	24	21	C7013674	Molinaro Peter	U10	AFT	29.07		7013674	U10	29.07	TRUE	Molinaro Peter	U10	8		29.07			0	8	0	0
30	25	51	X7022048	Negi Saivya	U12	GIL	29.12		7022048	U12	29.12	TRUE	Negi Saivya	U12	16			29.12		0	0	16	0
31	26	2	C7013888	Zellmer Samuel	U8	AFT	29.38		7013888	U08	29.38	TRUE	Zellmer Samuel	U08	2	29.38				2	0	0	0
32	27	8	C7106748	Underhill Viggo	U10	BKH	30.14		7106748	U10	30.14	TRUE	Underhill Viggo	U10	9		30.14			0	9	0	0
33	28	17	C7091437	Saewert Otto	U10	GIL	30.25		7091437	U10	30.25	TRUE	Saewert Otto	U10	10		30.25			0	10	0	0
34	29	6	C7135036	Balsimo Micco	U12	GIL	30.31		7135036	U12	30.31	TRUE	Balsimo Micco	U12	17			30.31		0	0	17	0
35	30	30	C6970496	Barbeau Avery	U12	FST	30.44		6970496	U12	30.44	TRUE	Barbeau Avery	U12	18			30.44		0	0	18	0
36	31	15	C7117542	Bristlin Rhys	U10	FST	30.87		7117542	U10	30.87	TRUE	Bristlin Rhys	U10	11		30.87			0	11	0	0
37	32	36	C7091855	Swanke Ivan	U12	GIL	30.93		7091855	U12	30.93	TRUE	Swanke Ivan	U12	19			30.93		0	0	19	0
38	33	3	C7033941	Brunsvold Carter	U8	AFT	31.16		7033941	U08	31.16	TRUE	Brunsvold Carter	U08	3	31.16				3	0	0	0
39	34	53	C7144247	Johnson Eli	U12	GIL	31.47		7144247	U12	31.47	TRUE	Johhnson Eli	U12	20			31.47		0	0	20	0
40	35	13	C7083495	Miller Ryder	U10	BKH	32.07		7083495	U10	32.07	TRUE	Miller Ryder	U10	12		32.07			0	12	0	0
41	36	16	C7159818	Comstock Waylon	U8	FST	32.75		7159818	U08	32.75	TRUE	Comstock Waylon	U08	4	32.75				4	0	0	0
42	37	1	C7086044	Benson Soren	U8	AFT	33.16		7086044	U08	33.16	TRUE	Benson Soren	U08	5	33.16				5	0	0	0
43	38	4	C7012809	O'Grady Henryk	U8	AFT	35.3		7012809	U08	35.30	TRUE	O'Grady Henryk	U08	6	35.30				6	0	0	0
44									0						0					0	0	0	0
45									0						0					0	0	0	0
46	Did Not Start (4)								0						0					0	0	0	0
47		54	C7103072	King-Ellison Roenen	U12	BKH			7103072	U12		TRUE	King-Ellison Roenen	U12	0					0	0	0	0
48		64	C7085049	Richardson Anders	U10	GIL			7085049	U10		TRUE	Richardson Anders	U10	0					0	0	0	0
49		71	C7167832	Soldan Asher	U10	AFT			7167832	U10		TRUE	Soldan Asher	U10	0					0	0	0	0
50		84	C7115799	Mallery Rigby	U12	GIL			7115799	U12		TRUE	Mallery Rigby	U12	0					0	0	0	0
51									0						0					0	0	0	0
52									0						0					0	0	0	0
53									0						0					0	0	0	0
54									0						0					0	0	0	0
55									0						0					0	0	0	0
56									0						0					0	0	0	0
57									0						0					0	0	0	0
58									0						0					0	0	0	0
59									0						0					0	0	0	0
60									0						0					0	0	0	0
61									0						0					0	0	0	0
62									0						0					0	0	0	0
63									0						0					0	0	0	0
64									0						0					0	0	0	0
65									0						0					0	0	0	0
66									0						0					0	0	0	0
67									0						0					0	0	0	0
68									0						0					0	0	0	0
69									0						0					0	0	0	0
70									0						0					0	0	0	0
71									0						0					0	0	0	0
72									0						0					0	0	0	0
73									0						0					0	0	0	0
74									0						0					0	0	0	0
75									0						0					0	0	0	0
76									0						0					0	0	0	0
77									0						0					0	0	0	0
78									0						0					0	0	0	0
79									0						0					0	0	0	0
80									0						0					0	0	0	0
81									0						0					0	0	0	0
82									0						0					0	0	0	0
83									0						0					0	0	0	0
84									0						0					0	0	0	0
85									0						0					0	0	0	0
86									0						0					0	0	0	0
87									0						0					0	0	0	0
88									0						0					0	0	0	0
89									0						0					0	0	0	0
90									0						0					0	0	0	0
91									0						0					0	0	0	0
92									0						0					0	0	0	0
93									0						0					0	0	0	0
94									0						0					0	0	0	0
95									0						0					0	0	0	0
96									0						0					0	0	0	0
97									0						0					0	0	0	0
98									0						0					0	0	0	0
99									0						0					0	0	0	0
100									0						0					0	0	0	0
101									0						0					0	0	0	0
102									0						0					0	0	0	0
103									0						0					0	0	0	0
104									0						0					0	0	0	0
105									0						0					0	0	0	0
106									0						0					0	0	0	0
107									0						0					0	0	0	0
108									0						0					0	0	0	0
109									0						0					0	0	0	0
110									0						0					0	0	0	0
111									0						0					0	0	0	0
112									0						0					0	0	0	0
113									0						0					0	0	0	0
114									0						0					0	0	0	0
115									0						0					0	0	0	0
116									0						0					0	0	0	0
117									0						0					0	0	0	0
118									0						0					0	0	0	0
119									0						0					0	0	0	0
120									0						0					0	0	0	0
121									0						0					0	0	0	0
122									0						0					0	0	0	0
123									0						0					0	0	0	0
124									0						0					0	0	0	0
125									0						0					0	0	0	0
126									0						0					0	0	0	0
127									0						0					0	0	0	0
128									0						0					0	0	0	0
129									0						0					0	0	0	0
130									0						0					0	0	0	0
131									0						0					0	0	0	0
132									0						0					0	0	0	0
133									0						0					0	0	0	0
134									0						0					0	0	0	0
135									0						0					0	0	0	0
136									0						0					0	0	0	0
137									0						0					0	0	0	0
138									0						0					0	0	0	0
139									0						0					0	0	0	0
140									0						0					0	0	0	0
141									0						0					0	0	0	0
142									0						0					0	0	0	0
143									0						0					0	0	0	0
144									0						0					0	0	0	0
145									0						0					0	0	0	0
146									0						0					0	0	0	0
147									0						0					0	0	0	0
148									0						0					0	0	0	0
149									0						0					0	0	0	0
150									0						0					0	0	0	0
151									0						0					0	0	0	0
152									0						0					0	0	0	0
153									0						0					0	0	0	0
154									0						0					0	0	0	0
155									0						0					0	0	0	0
156									0						0					0	0	0	0
157									0						0					0	0	0	0
158									0						0					0	0	0	0
159									0						0					0	0	0	0
160									0						0					0	0	0	0
161									0						0					0	0	0	0
162									0						0					0	0	0	0
163									0						0					0	0	0	0
164									0						0					0	0	0	0
165									0						0					0	0	0	0
166									0						0					0	0	0	0
167									0						0					0	0	0	0
168									0						0					0	0	0	0
169									0						0					0	0	0	0
170									0						0					0	0	0	0
171									0						0					0	0	0	0
172									0						0					0	0	0	0
173									0						0					0	0	0	0
174									0						0					0	0	0	0
175									0						0					0	0	0	0
176									0						0					0	0	0	0
177									0						0					0	0	0	0
178									0						0					0	0	0	0
179									0						0					0	0	0	0
180									0						0					0	0	0	0
181									0						0					0	0	0	0
182									0						0					0	0	0	0
183									0						0					0	0	0	0
184									0						0					0	0	0	0
185									0						0					0	0	0	0
186									0						0					0	0	0	0
187									0						0					0	0	0	0
188									0						0					0	0	0	0
189									0						0					0	0	0	0
190									0						0					0	0	0	0
191									0						0					0	0	0	0
192									0						0					0	0	0	0
193									0						0					0	0	0	0
194									0						0					0	0	0	0
195									0						0					0	0	0	0
196									0						0					0	0	0	0
197									0						0					0	0	0	0
198									0						0					0	0	0	0
199									0						0					0	0	0	0
200									0						0					0	0	0	0


1							2022 Boys U8 -U12 Planet Cup
2								USSA Central Region 1
3
4			Boys Slalom								Boys Giant Slalom						Boys Overall
5
6	Age		Place	Name	Club	Points			Age		Place	Name	Club	Points	Age		Place	Name	Club	Points	place-age

7
8	U08	0	10th	#N/A	#N/A	#N/A			U08	0	10th	#N/A	#N/A	#N/A	U08	0	10th	#N/A	#N/A	#N/A	10 U08
9	U08	0	9th	#N/A	#N/A	#N/A			U08	0	9th	#N/A	#N/A	#N/A	U08	0	9th	#N/A	#N/A	#N/A	09 U08
10	U08	0	8th	#N/A	#N/A	#N/A			U08	0	8th	#N/A	#N/A	#N/A	U08	0	8th	#N/A	#N/A	#N/A	08 U08
11	U08		7th	Waylon Comstock	FST	180			U08		7th	Waylon Comstock	FST	220	U08		7th	Waylon Comstock	FST	400	07 U08
12	U08		6th	Samuel Zellmer	AFT	360			U08		6th	Henryk O'Grady	AFT	300	U08		6th	Henryk O'Grady	AFT	755	06 U08
13	U08		5th	Henryk O'Grady	AFT	380			U08		5th	Milo Marchesi	BKH	370	U08		5th	Samuel Zellmer	AFT	810	05 U08
14	U08		4th	Soren Benson	AFT	380.5			U08		4th	Soren Benson	AFT	380	U08		4th	Soren Benson	AFT	830	04 U08
15	U08		3rd	Carter Brunsvold	AFT	440			U08		3rd	Carter Brunsvold	AFT	420	U08		3rd	Carter Brunsvold	AFT	940	03 U08
16	U08		2nd	Reid Peltz	BKH	480			U08		2nd	Samuel Zellmer	AFT	450	U08		2nd	Milo Marchesi	BKH	950	02 U08
17	U08		1st	Milo Marchesi	BKH	490			U08		1st	Reid Peltz	BKH	500	U08		1st	Reid Peltz	BKH	1070	01 U08
18
19	U10		10th	Peter Molinaro	AFT	260			U10		10th	Viggo Underhill	BKH	240	U10		10th	Graham Richardson	GIL	545	10 U10
20	U10		9th	Viggo Underhill	BKH	290			U10		9th	Bohdan O'Grady	AFT	245	U10		9th	Viggo Underhill	BKH	585	09 U10
21	U10		8th	Bohdan O'Grady	AFT	305			U10		8th	Anders Richardson	GIL	260	U10		8th	Bohdan O'Grady	AFT	605	08 U10
22	U10		7th	Graham Lodermeier	AFT	310			U10		7th	Peter Molinaro	AFT	280	U10		7th	Peter Molinaro	AFT	625	07 U10
23	U10		6th	Graham Richardson	GIL	355			U10		6th	Graham Lodermeier	AFT	290	U10		6th	Graham Lodermeier	AFT	650	06 U10
24	U10		5th	Spencer Simon	GIL	360			U10		5th	Spencer Simon	GIL	310	U10		5th	Spencer Simon	GIL	735	05 U10
25	U10		4th	Jack Stinnett	BKH	410			U10		4th	Jack Stinnett	BKH	370	U10		4th	Jack Stinnett	BKH	860	04 U10
26	U10		3rd	Magnus Rambow	FST	430			U10		3rd	Magnus Rambow	FST	430	U10		3rd	Magnus Rambow	FST	950	03 U10
27	U10		2nd	John Luc Houle	AFT	450			U10		2nd	Teddy Titler	BKH	470	U10		2nd	John Luc Houle	AFT	1050	02 U10
28	U10		1st	Teddy Titler	BKH	500			U10		1st	John Luc Houle	AFT	500	U10		1st	Teddy Titler	BKH	1060	01 U10
29
30	U12		10th	Griffin Underhill	BKH	182			U12		10th	Benjamin Jakobe	GIL	203	U12		10th	Benjamin Jakobe	GIL	395	10 U12
31	U12		9th	Reef Sampson	FST	260			U12		9th	Asa Schaeppi	BKH	240	U12		9th	Asa Schaeppi	BKH	575	09 U12
32	U12		8th	Asa Schaeppi	BKH	280			U12		8th	Reef Sampson	FST	305	U12		8th	Reef Sampson	FST	610	08 U12
33	U12		7th	Brexten Hopke	BKH	355			U12		7th	Cole Peltz	BKH	355	U12		7th	Brexten Hopke	BKH	775	07 U12
34	U12		6th	William Burns	AFT	390			U12		6th	William Burns	AFT	360	U12		6th	William Burns	AFT	810	06 U12
35	U12		5th	Everett Levander	AFT	400			U12		5th	Brexten Hopke	BKH	365	U12		5th	Cole Peltz	BKH	835	05 U12
36	U12		4th	Roman Zadvornykh	BKH	420			U12		4th	Roman Zadvornykh	BKH	390	U12		4th	Everett Levander	AFT	855	04 U12
37	U12		3rd	Cole Peltz	BKH	420.5			U12		3rd	Everett Levander	AFT	400	U12		3rd	Roman Zadvornykh	BKH	880	03 U12
38	U12		2nd	Luke Mjanger	AFT	450			U12		2nd	Reed Pope	FST	480	U12		2nd	Reed Pope	FST	1000	02 U12
39	U12		1st	Reed Pope	FST	450.5			U12		1st	Luke Mjanger	AFT	480.5	U12		1st	Luke Mjanger	AFT	1030	01 U12
40
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66												Red indicates a tie by points. See the "About" tab for scoring rules.


1
7
8	Boys SL	U08	10th	#N/A	Boys GS	U08	0	10th	#N/A	Boys OA	U08	10th	#N/A
9	#N/A				#N/A					#N/A
10	Boys SL	U08	9th	#N/A	Boys GS	U08	0	9th	#N/A	Boys OA	U08	9th	#N/A
11	#N/A				#N/A					#N/A
12	Boys SL	U08	8th	#N/A	Boys GS	U08	0	8th	#N/A	Boys OA	U08	8th	#N/A
13	#N/A				#N/A					#N/A
14	Boys SL	U08	7th	FST	Boys GS	U08		7th	FST	Boys OA	U08	7th	FST
15	Waylon Comstock				Waylon Comstock					Waylon Comstock
16	Boys SL	U08	6th	AFT	Boys GS	U08		6th	AFT	Boys OA	U08	6th	AFT
17	Samuel Zellmer				Henryk O'Grady					Henryk O'Grady
18	Boys SL	U08	5th	AFT	Boys GS	U08		5th	BKH	Boys OA	U08	5th	AFT
19	Henryk O'Grady				Milo Marchesi					Samuel Zellmer
20	Boys SL	U08	4th	AFT	Boys GS	U08		4th	AFT	Boys OA	U08	4th	AFT
21	Soren Benson				Soren Benson					Soren Benson
22	Boys SL	U08	3rd	AFT	Boys GS	U08		3rd	AFT	Boys OA	U08	3rd	AFT
23	Carter Brunsvold				Carter Brunsvold					Carter Brunsvold
24	Boys SL	U08	2nd	BKH	Boys GS	U08		2nd	AFT	Boys OA	U08	2nd	BKH
25	Reid Peltz				Samuel Zellmer					Milo Marchesi
26	Boys SL	U08	1st	BKH	Boys GS	U08		1st	BKH	Boys OA	U08	1st	BKH
27	Milo Marchesi				Reid Peltz					Reid Peltz
28
29	Boys SL	U10	10th	AFT	Boys GS	U10		10th	BKH	Boys OA	U10	10th	GIL
30	Peter Molinaro				Viggo Underhill					Graham Richardson
31	Boys SL	U10	9th	BKH	Boys GS	U10		9th	AFT	Boys OA	U10	9th	BKH
32	Viggo Underhill				Bohdan O'Grady					Viggo Underhill
33	Boys SL	U10	8th	AFT	Boys GS	U10		8th	GIL	Boys OA	U10	8th	AFT
34	Bohdan O'Grady				Anders Richardson					Bohdan O'Grady
35	Boys SL	U10	7th	AFT	Boys GS	U10		7th	AFT	Boys OA	U10	7th	AFT
36	Graham Lodermeier				Peter Molinaro					Peter Molinaro
37	Boys SL	U10	6th	GIL	Boys GS	U10		6th	AFT	Boys OA	U10	6th	AFT
38	Graham Richardson				Graham Lodermeier					Graham Lodermeier
39	Boys SL	U10	5th	GIL	Boys GS	U10		5th	GIL	Boys OA	U10	5th	GIL
40	Spencer Simon				Spencer Simon					Spencer Simon
41	Boys SL	U10	4th	BKH	Boys GS	U10		4th	BKH	Boys OA	U10	4th	BKH
42	Jack Stinnett				Jack Stinnett					Jack Stinnett
43	Boys SL	U10	3rd	FST	Boys GS	U10		3rd	FST	Boys OA	U10	3rd	FST
44	Magnus Rambow				Magnus Rambow					Magnus Rambow
45	Boys SL	U10	2nd	AFT	Boys GS	U10		2nd	BKH	Boys OA	U10	2nd	AFT
46	John Luc Houle				Teddy Titler					John Luc Houle
47	Boys SL	U10	1st	BKH	Boys GS	U10		1st	AFT	Boys OA	U10	1st	BKH
48	Teddy Titler				John Luc Houle					Teddy Titler
49
50	Boys SL	U12	10th	BKH	Boys GS	U12		10th	GIL	Boys OA	U12	10th	GIL
51	Griffin Underhill				Benjamin Jakobe					Benjamin Jakobe
52	Boys SL	U12	9th	FST	Boys GS	U12		9th	BKH	Boys OA	U12	9th	BKH
53	Reef Sampson				Asa Schaeppi					Asa Schaeppi
54	Boys SL	U12	8th	BKH	Boys GS	U12		8th	FST	Boys OA	U12	8th	FST
55	Asa Schaeppi				Reef Sampson					Reef Sampson
56	Boys SL	U12	7th	BKH	Boys GS	U12		7th	BKH	Boys OA	U12	7th	BKH
57	Brexten Hopke				Cole Peltz					Brexten Hopke
58	Boys SL	U12	6th	AFT	Boys GS	U12		6th	AFT	Boys OA	U12	6th	AFT
59	William Burns				William Burns					William Burns
60	Boys SL	U12	5th	AFT	Boys GS	U12		5th	BKH	Boys OA	U12	5th	BKH
61	Everett Levander				Brexten Hopke					Cole Peltz
62	Boys SL	U12	4th	BKH	Boys GS	U12		4th	BKH	Boys OA	U12	4th	AFT
63	Roman Zadvornykh				Roman Zadvornykh					Everett Levander
64	Boys SL	U12	3rd	BKH	Boys GS	U12		3rd	AFT	Boys OA	U12	3rd	BKH
65	Cole Peltz				Everett Levander					Roman Zadvornykh
66	Boys SL	U12	2nd	AFT	Boys GS	U12		2nd	FST	Boys OA	U12	2nd	FST
67	Luke Mjanger				Reed Pope					Reed Pope
68	Boys SL	U12	1st	FST	Boys GS	U12		1st	AFT	Boys OA	U12	1st	AFT
69	Reed Pope				Luke Mjanger					Luke Mjanger