Help and instructions for this spreadsheet are available on the CCIDPA web site at http://www.ccidpa.org/scoresht.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 slect 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."