<body>
<p>This page uses frames, but your browser doesn't support them.</p>
</body>

Scoresheet

Sheet2

Sheet1

SortLookup

Help

FRIDPA

Pikes Peak

Main Match

July 21, 2019

Rank?

Promote?

Sort Keys

Match Totals

Bay
1

Middlebrook Encampment

Bay 2

Buddy System

Bay 3

Old North Church

Bay 4

Boston Massacre

Bay
5

Gang Dog

Bay
6

Shoot'em Again

Stage p

Stage 8

Stage 9

Stage 10

Stage 11

Stage 12

Stage 13

Stage 14

Stage 15

Stage 16

Stage 17

Stage 18

Stage 19

Stage 20

Place

First
Last Initial

IDPA #

L
C

A R

B E

O D

R I

T

Div

Class

Finger

n

n

Sort Div

Sort Class

Total Match Score

Tot Raw Time

Tot Pen Time

Tot Pts Dn/2

Tot Pts Dn

Str 1 Raw Time

Str
2 Raw Time

Str 3 Raw
Time

Str 4 Raw
Time

Str 5 Raw
Time

Str 6 Raw
Time

Str 7 Raw
Time

Pts
Dn

PE

F

P

HNT

FTDR

Stage Raw Time

Pts
Dn

Pen
Sec

Total
Stage Score

Str 1 Raw Time

Str 2 Raw
Time

Str 3 Raw
Time

Str 4 Raw
Time

Pts
Dn

PE

F

P

HNT

FTDR

Stage Raw Time

Pts
Dn

Pen
Sec

Total
Stage Score

Str 1

Raw

Time

Str 2 Raw
Time

Str 3 Raw
Time

Pts
Dn

PE

F

P

HNT

FTDR

Stage Raw Time

Pts
Dn

Pen
Sec

Total
Stage Score

Stage 4

Str
1 Raw Time

Pts
Dn

PE

FTN

HNS

FTDR

Stage Raw Time

Pts Dn

Pen Sec

Total
Stage Score

Str 1

Raw

Time

Str 2 Raw
Time

Str 3 Raw
Time

Str 4 Raw
Time

Pts
Dn

PE

F

P

HNT

FTDR

Stage Raw Time

Pts
Dn

Pen
Sec

Total
Stage Score

Str 1 Raw Time

Str 2 Raw
Time

Pts
Dn

PE

F

P

HNT

FTDR

Stage Raw Time

Pts
Dn

Pen
Sec

Total
Stage Score

1

Dennis C

CCP

SS

#REF!

#REF!

2

#####

#####

10

30.0

30

6.44

###

16

0

0

0

0

16.79

##

0

32.79

21.87

1

0

0

0

0

####

1.0

0

####

36.05

2

0

0

0

36.05

2.0

0

38.05

20.9

4

0

0

0

0

####

4.0

0

24.89

####

3

0

0

0

0

####

3.0

0

####

20.64

4

0

0

2

0

####

4.0

10

####

2

Mark S

CCP

SS

#REF!

#REF!

2

#####

#####

5

23.0

23

9.35

8.65

11

0

0

0

0

18.00

##

0

29.00

23.15

7

0

0

0

0

####

7.0

0

####

40.24

1

0

0

0

40.24

1.0

0

41.24

25.5

1

0

0

1

0

####

1.0

5

31.49

####

0

0

0

0

0

####

0.0

0

####

23.53

3

0

0

0

0

####

3.0

0

####

3

Jay G

CCP

SS

#REF!

#REF!

2

#####

#####

5

17.0

17

####

8.09

4

0

0

0

0

20.01

4.0

0

24.01

28.49

4

0

0

0

0

####

4.0

0

####

30.61

4

0

0

0

30.61

4.0

5

39.61

44.6

2

0

0

0

0

####

2.0

0

46.63

####

1

0

0

0

0

####

1.0

0

####

30.23

2

0

0

0

0

####

2.0

0

####

4

Mark C

CCP

SS

#REF!

#REF!

2

#####

#####

8

23.0

23

####

9.33

4

0

0

0

0

21.92

4.0

0

25.92

24.26

2

1

0

0

0

####

2.0

3

####

42.62

5

0

0

0

42.62

5.0

0

47.62

40.1

5

0

0

1

0

####

5.0

5

50.11

####

6

0

0

0

0

####

6.0

0

####

28.14

1

0

0

0

0

####

1.0

0

####

1

Rob D

CDP

MM

#REF!

#REF!

2

3

#####

#####

18

47.0

47

####

###

27

0

0

0

0

23.00

##

0

50.00

30.85

6

1

0

1

0

####

6.0

8

####

23.23

2

0

0

0

23.23

2.0

0

25.23

41

1

0

0

0

0

####

1.0

0

41.96

####

2

0

0

2

0

####

2.0

10

####

29.50

9

0

0

0

0

####

9.0

0

####

2

Mick M

CDP

MM

#REF!

#REF!

2

3

#####

#####

25

31.0

31

####

###

15

0

0

0

0

35.40

##

0

50.40

33.08

8

0

0

1

0

####

8.0

5

####

49.09

2

0

0

0

49.09

2.0

5

56.09

39.4

1

0

0

1

0

####

1.0

5

45.42

####

2

0

0

1

0

####

2.0

5

####

28.77

3

0

0

1

0

####

3.0

5

####

1

Cole P

CO

MM

#REF!

#REF!

3

#####

#####

5

20.0

20

####

###

6

0

0

0

0

24.93

6.0

0

30.93

29.11

4

0

0

0

0

####

4.0

0

####

45.07

0

0

0

0

45.07

0.0

0

45.07

32.1

1

0

0

0

0

####

1.0

0

33.06

####

7

0

0

0

0

####

7.0

0

####

25.15

2

0

0

1

0

####

2.0

5

####

2

Will H

7

CO

MM

#REF!

#REF!

3

#####

#####

0

11.0

11

####

###

5

0

0

0

0

26.26

5.0

0

31.26

40.38

1

0

0

0

0

####

1.0

0

####

28.05

2

0

0

0

28.05

2.0

0

30.05

44.8

1

0

0

0

0

####

1.0

0

45.83

####

0

0

0

0

0

####

0.0

0

####

35.16

2

0

0

0

0

####

2.0

0

####

1

Joe H

ESP

MM

#REF!

#REF!

1

3

#####

#####

13

19.0

19

8.17

###

8

0

0

0

0

24.56

8.0

0

32.56

29.09

4

0

0

0

0

####

4.0

0

####

50.32

2

0

0

0

50.32

2.0

5

57.32

30

0

0

0

0

0

####

0.0

0

29.96

####

3

0

0

0

0

####

3.0

0

####

27.13

2

1

0

1

0

####

2.0

8

####

2

Mark S

ESP

MM

#REF!

#REF!

1

3

#####

#####

20

53.0

53

####

###

15

0

0

0

0

24.17

##

0

39.17

28.68

3

0

0

0

0

####

3.0

0

####

54.78

4

0

0

0

54.78

4.0

5

63.78

33.1

10

0

0

1

0

####

##

5

48.11

####

6

0

0

2

0

####

6.0

10

####

30.27

15

0

0

0

0

####

###

0

####

1

Jerry Di

1

SSP

EX

#REF!

#REF!

0

1

#####

#####

5

17.0

17

5.67

6.66

6

0

0

0

0

12.33

6.0

0

18.33

17.68

1

0

0

0

0

####

1.0

0

####

18.40

2

0

0

0

18.40

2.0

0

20.40

20.6

1

0

0

0

0

####

1.0

0

21.59

####

0

0

0

0

0

####

0.0

0

####

13.40

7

0

0

1

0

####

7.0

5

####

2

Ron C

SSP

SS

#REF!

#REF!

0

2

#####

#####

0

13.0

13

8.20

8.80

4

0

0

0

0

17.00

4.0

0

21.00

19.05

4

0

0

0

0

####

4.0

0

####

16.68

1

0

0

0

16.68

1.0

0

17.68

19.3

1

0

0

0

0

####

1.0

0

20.28

####

3

0

0

0

0

####

3.0

0

####

17.36

0

0

0

0

0

####

0.0

0

####

3

Fred G

SSP

SS

#REF!

#REF!

0

2

#####

#####

18

24.0

24

7.81

7.17

5

0

0

0

0

14.98

5.0

0

19.98

15.22

3

1

0

0

0

####

3.0

3

####

20.44

3

0

0

0

20.44

3.0

0

23.44

18.7

4

0

0

0

0

####

4.0

0

22.68

####

1

0

0

1

0

####

1.0

5

####

16.48

8

0

0

2

0

####

8.0

10

####

4

Jay M

SSP

MM

#REF!

#REF!

0

3

#####

#####

3

21.0

21

7.18

8.15

6

0

0

0

0

15.33

6.0

0

21.33

20.66

2

0

0

0

0

####

2.0

0

####

27.01

2

0

0

0

27.01

2.0

0

29.01

23.3

2

0

0

0

0

####

2.0

0

25.30

####

2

0

0

0

0

####

2.0

0

####

28.00

7

1

0

0

0

####

7.0

3

####

5

Joe D

SSP

SS

#REF!

#REF!

0

2

#####

#####

5

17.0

17

####

###

7

0

0

0

0

23.95

7.0

0

30.95

18.30

4

0

0

0

0

####

4.0

0

####

47.74

3

0

0

0

47.74

3.0

5

55.74

24.1

1

0

0

0

0

####

1.0

0

25.12

####

0

0

0

0

0

####

0.0

0

####

24.08

2

0

0

0

0

####

2.0

0

####

6

Bonnie R

SSP

SS

#REF!

#REF!

0

2

#####

#####

3

20.0

20

####

###

9

0

0

0

0

24.56

9.0

0

33.56

26.62

4

0

0

0

0

####

4.0

0

####

26.42

4

0

0

0

26.42

4.0

0

30.42

35.7

0

1

0

0

0

####

0.0

3

38.65

####

0

0

0

0

0

####

0.0

0

####

26.99

3

0

0

0

0

####

3.0

0

####

7

Josh P

16

SSP

UN

#REF!

#REF!

0

#####

#####

8

13.0

13

####

8.38

5

0

0

0

0

21.00

5.0

0

26.00

28.86

3

1

0

0

0

####

3.0

3

####

44.96

2

0

0

0

44.96

2.0

0

46.96

28.8

0

0

0

0

0

####

0.0

0

28.84

####

1

0

0

0

0

####

1.0

0

####

20.48

2

0

0

1

0

####

2.0

5

####

8

Rob C

SSP

UN

#REF!

#REF!

0

#####

#####

3

13.0

13

####

0.00

0

0

0

0

0

28.68

0.0

0

28.68

30.14

0

0

0

0

0

####

0.0

0

####

28.63

0

0

0

0

28.63

0.0

0

28.63

32.6

0

1

0

0

0

####

0.0

3

35.61

####

1

0

0

0

0

####

1.0

0

####

31.00

12

0

0

0

0

####

###

0

####

9

Bob A

SSP

UN

#REF!

#REF!

0

#####

#####

11

29.0

29

7.99

###

11

0

0

0

0

18.52

##

0

29.52

31.33

3

1

0

0

0

####

3.0

3

####

27.02

3

0

0

0

27.02

3.0

0

30.02

37.4

1

0

0

0

0

####

1.0

0

38.42

####

1

1

0

0

0

####

1.0

3

####

25.33

10

0

0

1

0

####

###

5

####

10

Jeremy L

16

SSP

UN

#REF!

#REF!

0

#####

#####

8

17.0

17

9.62

7.87

2

0

0

0

0

17.49

2.0

0

19.49

36.99

10

0

0

0

0

####

##

0

####

33.74

3

0

0

0

33.74

3.0

0

36.74

40.3

0

1

0

0

0

####

0.0

3

43.30

####

0

0

0

0

0

####

0.0

0

####

29.50

2

0

0

1

0

####

2.0

5

####

11

Rusty H

3

SSP

MM

#REF!

#REF!

0

3

#####

#####

5

30.0

30

####

9.98

16

0

0

0

0

21.63

##

0

37.63

20.00

2

0

0

0

0

####

2.0

0

####

22.33

1

0

0

0

22.33

1.0

0

23.33

60.7

4

0

0

0

0

####

4.0

0

64.69

####

0

0

0

0

0

####

0.0

0

####

31.62

7

0

0

1

0

####

7.0

5

####

12

Erik H

3

SSP

MM

#REF!

#REF!

0

3

#####

#####

3

21.0

21

####

###

10

0

0

0

0

24.06

##

0

34.06

39.88

2

0

0

0

0

####

2.0

0

####

43.10

2

0

0

0

43.10

2.0

0

45.10

36.3

1

1

0

0

0

####

1.0

3

40.32

####

0

0

0

0

0

####

0.0

0

####

29.79

6

0

0

0

0

####

6.0

0

####

13

Mark W

16

SSP

UN

#REF!

#REF!

0

#####

#####

3

13.0

13

####

###

4

0

0

0

0

22.44

4.0

0

26.44

40.03

1

0

0

0

0

####

1.0

0

####

45.55

1

0

0

0

45.55

1.0

0

46.55

37.7

4

0

0

0

0

####

4.0

0

41.70

####

0

1

0

0

0

####

0.0

3

####

33.93

3

0

0

0

0

####

3.0

0

####

14

Terrence E

1

SSP

UN

#REF!

#REF!

0

#####

#####

10

31.0

31

8.76

###

6

0

0

0

0

23.16

6.0

0

29.16

29.74

4

0

0

0

0

####

4.0

0

####

73.02

8

0

0

0

73.02

8.0

5

86.02

32.2

4

0

0

0

0

####

4.0

0

36.21

####

3

0

0

0

0

####

3.0

0

####

23.20

6

0

0

1

0

####

6.0

5

####

15

Kalin L

16

SSP

UN

#REF!

#REF!

0

#####

#####

0

33.0

33

####

###

16

0

0

0

0

25.65

##

0

41.65

33.98

7

0

0

0

0

####

7.0

0

####

41.70

1

0

0

0

41.70

1.0

0

42.70

48.3

0

0

0

0

0

####

0.0

0

48.26

####

2

0

0

0

0

####

2.0

0

####

36.16

7

0

0

0

0

####

7.0

0

####

16

Bob L

SSP

SS

#REF!

#REF!

0

2

#####

#####

30

9.0

9

####

###

4

0

0

0

0

30.74

4.0

0

34.74

37.85

0

0

0

0

0

####

0.0

0

####

40.56

1

0

0

0

40.56

1.0

5

46.56

43.1

2

0

0

3

0

####

2.0

15

60.07

####

0

0

0

0

0

####

0.0

0

####

30.55

2

0

0

2

0

####

2.0

10

####

17

Ken B

SSP

SS

#REF!

#REF!

0

2

#####

#####

23

21.0

21

####

###

12

0

0

0

0

23.12

##

0

35.12

34.23

3

0

0

0

0

####

3.0

0

####

43.78

2

0

0

0

43.78

2.0

5

50.78

59.1

0

0

0

1

0

####

0.0

5

64.10

####

1

0

0

0

0

####

1.0

0

####

27.39

3

1

0

2

0

####

3.0

13

####

18

Chuck G

SSP

MM

#REF!

#REF!

0

3

#####

#####

0

13.0

13

####

###

3

0

0

0

0

37.56

3.0

0

40.56

45.37

3

0

0

0

0

####

3.0

0

####

79.80

3

0

0

0

79.80

3.0

0

82.80

32.9

1

0

0

0

0

####

1.0

0

33.86

####

0

0

0

0

0

####

0.0

0

####

34.38

3

0

0

0

0

####

3.0

0

####

19

Jonny C

16

SSP

UN

#REF!

#REF!

0

#####

#####

20

62.0

62

####

###

12

0

0

0

0

31.70

##

0

43.70

51.62

5

0

0

0

0

####

5.0

0

####

74.50

14

0

0

0

74.50

##

20

108.50

69.8

7

0

0

0

0

####

7.0

0

76.79

####

3

0

0

0

0

####

3.0

0

####

31.74

21

0

0

0

0

####

###

0

####

Shylow D

SSP

UN

#REF!

#REF!

0

DNF

0.0

DNF

DNF

#####

20

0

0

0

#####

##

15

147.54

81.6

11

0

0

1

0

####

##

5

97.57

DNF

DNF

#REF!

#REF!

0.00

0.00

0

0.0

0

0.00

0.0

0

0.00

0.00

0.0

0

0.00

0.00

0.0

0

0.00

0.00

0.0

0

0.00

0.00

0.0

0

0.00

0.00

0.0

0

0.00

#REF!

#REF!

0.00

0.00

0

0.0

0

0.00

0.0

0

0.00

0.00

0.0

0

0.00

0.00

0.0

0

0.00

0.00

0.0

0

0.00

0.00

0.0

0

0.00

0.00

0.0

0

0.00

#REF!

#REF!

0.00

0.00

0

0.0

0

0.00

0.0

0

0.00

0.00

0.0

0

0.00

0.00

0.0

0

0.00

0.00

0.0

0

0.00

0.00

0.0

0

0.00

0.00

0.0

0

0.00

#REF!

#REF!

0.00

0.00

0

0.0

0

0.00

0.0

0

0.00

0.00

0.0

0

0.00

0.00

0.0

0

0.00

0.00

0.0

0

0.00

0.00

0.0

0

0.00

0.00

0.0

0

0.00

#REF!

#REF!

0.00

0.00

0

0.0

0

0.00

0.0

0

0.00

0.00

0.0

0

0.00

0.00

0.0

0

0.00

0.00

0.0

0

0.00

0.00

0.0

0

0.00

0.00

0.0

0

0.00

#REF!

#REF!

0.00

0.00

0

0.0

0

0.00

0.0

0

0.00

0.00

0.0

0

0.00

0.00

0.0

0

0.00

0.00

0.0

0

0.00

0.00

0.0

0

0.00

0.00

0.0

0

0.00

#REF!

#REF!

0.00

0.00

0

0.0

0

0.00

0.0

0

0.00

0.00

0.0

0

0.00

0.00

0.0

0

0.00

0.00

0.0

0

0.00

0.00

0.0

0

0.00

0.00

0.0

0

0.00

#REF!

#REF!

0.00

0.00

0

0.0

0

0.00

0.0

0

0.00

0.00

0.0

0

0.00

0.00

0.0

0

0.00

0.00

0.0

0

0.00

0.00

0.0

0

0.00

0.00

0.0

0

0.00

#REF!

#REF!

0.00

0.00

0

0.0

0

0.00

0.0

0

0.00

0.00

0.0

0

0.00

0.00

0.0

0

0.00

0.00

0.0

0

0.00

0.00

0.0

0

0.00

0.00

0.0

0

0.00

#REF!

#REF!

0.00

0.00

0

0.0

0

0.00

0.0

0

0.00

0.00

0.0

0

0.00

0.00

0.0

0

0.00

0.00

0.0

0

0.00

0.00

0.0

0

0.00

0.00

0.0

0

0.00

#REF!

#REF!

0.00

0.00

0

0.0

0

0.00

0.0

0

0.00

0.00

0.0

0

0.00

0.00

0.0

0

0.00

0.00

0.0

0

0.00

0.00

0.0

0

0.00

0.00

0.0

0

0.00

#REF!

#REF!

0.00

0.00

0

0.0

0

0.00

0.0

0

0.00

0.00

0.0

0

0.00

0.00

0.0

0

0.00

0.00

0.0

0

0.00

0.00

0.0

0

0.00

0.00

0.0

0

0.00

#REF!

#REF!

0.00

0.00

0

0.0

0

0.00

0.0

0

0.00

0.00

0.0

0

0.00

0.00

0.0

0

0.00

0.00

0.0

0

0.00

0.00

0.0

0

0.00

0.00

0.0

0

0.00

Range Member Labor Credit Sum: 1-Member, 2-Setup, 4-SO, 8-CoF, 16-New
Shooter

*  - Division not indicated, shooter must
complete their scoresheet

BUG - R or S

Rev - ER or SR

** - Class not indicated, shooter
must complete their scoresheet

@ - Contact [email-masked]
concerning status of Range Membership

1 - Trigger Violation

ICS - Improperly Completed
Scoresheet, shooter must verify their recorded scores

TNR - Time Not Recorded

DNF - Did Not Finish

DQ - Disqualified

M-Muzzle

S- Steel

F-Finger

C-Cold Range

W-Sweep

D-Dropped

Weapon

N-Negligent

Discharge

E-Equipment

DNFW - Did Not Finish, Weather

SSP

0

IDPA Match Scoring Spreadsheet
Sort Key lookup table

ESP

1

Table used to convert IDPA Divisions and classes into numeric
sort keys.

CDP

2

The sort keys can then be
used with the total match scores to produce a sort by score within division
and class.

ESR

3

The shooter's division is looked up in the upper table and
converted to anumber.

SSR

4

Then his or her class is looked up in the lower table and
converted to a number.

MA

0

A three-column sort on
the division sort key first, class sort key next, and total match score third
will yield a properly-ordered report.

EX

1

SS

2

MM

3

NV

4

0

MA

This table is used to
look up IDPA Classes using the numeric Class Sort Key value for purposes of
promotions at sanctioned matches.

1

EX

2

SS

3

MM

4

Invalid Shooter Class entered on spreadsheet!

Help
and instructions for this spreadsheet are available on the CCIDPA web site at
http://www.ccidpa.org/scoring/spreadsheets.html

If you
delete rows in the scoring spreadsheet, and column H "blows up"
with #REF! errors, replace the formulas in column H:

(Remember
to add the equal sign at the beginning of this formula!)

1. Unprotect the scoring
worksheet using Tools->Protection->Unprotect Sheet.

2. Select this Help worksheet,
and copy the formula below.

3. Return to the scoring
worksheet.

4. Paste the copied formula into
cell H3, and add an equal sign to the beginning of it.

5. Left-click and select the
cell at location H3.

6. Place the cursor on the
little black box that appears at the bottom right of cell H3.

7. Press and hold the left mouse
button, and drag the little black box all the way down to the last active row
of your spreadsheet.

8. Re-protect the worksheet
using Tools->Protection->Protect Sheet. Uncheck all boxes, except for
"Select unlocked cells."

IF(AND($H$2="Y",J3>0,OR(AND(G3=1,G12=10),AND(G3=2,G21=20),AND(G3=3,G30=30),AND(G3=4,G39=40),AND(G3=5,G48=50),AND(G3=6,G57=60),AND(G3=7,G66=70),AND(G3=8,G75=80),AND(G3=9,G84=90),AND(G3=10,G93=100))),VLOOKUP(J3-1,SortLookup!$A$12:$B$15,2,FALSE),"")

The
Match Ranking and Match Promotion features (columns G and H) won't work
properly until you have sorted your results by Division, Class, and Total
Match Score.

Columns
I and J (Sort Div and Sort Class) are provided to allow a quick, three-column
sort for final match results.

1. Unprotect the scoring
worksheet using Tools->Protection->Unprotect Sheet.

2. Select any cell in the
spreadsheet.

3. Select Data->Sort

4. In the Sort By box, select
Sort Div.

5. In the first Then By box,
select Sort Class.

6. In the second Then By box,
select Total Match Score.

7. In most cases, you will want
to select Ascending order in all three radio buttons.

8. Click OK to sort your match
results.

9. Re-protect the worksheet
using Tools->Protection->Protect Sheet. Uncheck all boxes, except for
"Select unlocked cells."