{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Info","NDHSAA 6 Dive","NDHSAA 11 Dive","11 Dive 7 Judge","Dive Table"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":60,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Info","index":0,"n_rows":26,"n_cols":1,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["2022-23 NFHS Dive Sheets"]
["This spreadsheet contains sheets for both a 6 dive and 11 dive meets. The 11 dive sheet comes in both a 5 judge & 7 judge setup.  Do not use the 11 dive sheet for a 6 dive meet."]
["Each sheet checks for errors to insure you enter the dives correctly. Error messages will display in the line 35 of each sheet. The sheets are protected and limit the cells in which you can enter data."]
["For a 6 dive meet, the first dive will be automatically adjusted to a maximum DD of 1.8."]
["To use the dive sheets:"]
[" 1. Enter name, school, meet, site, date, & grade in correct area."]
[" 2. Enter X in correct area for Varsity or JV."]
[" 3. In the dive number column, enter the dive number & position."]
["The position must be entered as a, b, c, or d."]
["Data validation has been added, so the dive number must be in the proper format.  For example: 101A or 101a with no spaces"]
["You can also select the dive from the drop down list."]
[" 4. The dive description, position, & DD will fill in automatically."]
[" 5. The 6 dive sheet will only let you enter up to 6 dives.  Anything less will be labeled\n      as exhibition.  It will prompt for the correct first dive per the dive schedule."]
[" 6. Valid dates for the season & meeet must be entered.  Proper date entry insures the\n      the check for proper voluntary dive on the 6 dive sheet based on the voluntary dive\n      schedule."]
[" 7. For the 11 dive meet sheet, enter a V or O in column P for all 11 dives and code will\n      automatically place circles on the dive number and DD for the Voluntary dives.  To\n      clear the circle from a dive, you must first enter an O to remove it.  This designates\n      the dive as Voluntary or Optional for proper checking of the sheet and adding up\n      the total DD for all Voluntary dives."]
["The automatic circling of the dive number and DD uses visual basic code or a macro.  Please make sure you enable macros to execute.  NDHSAA might strip out the macro.  Send me an email if you want a verson with macros included."]
["As an option, if you can't enable macros for security reasons, the voluntary dives will have a slight gray background also.  You can circle them by hand after printing."]
[" 8. Check for help or error messages in cell C35."]
[" 9. Diver & Coach must both sign the sheet after printing."]
[]
["Optional:"]
["You can also enter the judges scores in the appropriate cell to get the total score. If 5 judges are used, it will automatically drop the high & low score to get the correct total.  For 7 judges it drops the two highest & two lowest scores."]
[]
["I developed this spreadsheet on a voluntary basis to assist coaches with properly filling out a dive sheet. I do not guarantee the accuracy and am not liable for any errors or omissions. The user assumes all risks."]
["If you have any questions or find any errors while using this spreadsheet, please contact me at gpfau2@bis.midco.net."]
[" - Gerry Pfau 7/30/22"]

{"sheet":"NDHSAA 6 Dive","index":1,"n_rows":42,"n_cols":26,"rows_kept":42,"cut":false,"hidden":false,"merged":[[32,0,33,0],[36,1,37,6],[4,10,4,11],[25,2,26,5],[28,2,29,5],[30,2,31,5],[32,2,33,5],[23,9,24,9],[0,13,1,14],[2,13,3,14],[4,13,5,14],[3,1,3,5],[4,1,4,2],[5,1,5,2],[4,4,4,6],[3,7,3,11],[5,6,5,7],[0,0,1,11],[23,10,24,10],[23,11,24,11],[23,1,24,1],[16,0,17,0],[18,0,19,0],[21,0,22,0],[8,0,9,0],[10,0,11,0],[12,0,13,0],[14,0,15,0],[30,1,31,1],[30,6,31,6],[21,2,22,5],[10,1,11,1],[10,6,11,6],[25,0,26,0],[28,0,29,0],[30,0,31,0],[23,0,24,0],[28,1,29,1],[28,6,29,6],[25,1,26,1],[25,6,26,6],[10,2,11,5],[23,6,24,6],[23,2,24,5],[21,6,22,6],[14,6,15,6],[14,2,15,5],[12,1,13,1],[28,7,29,7],[28,8,29,8],[28,9,29,9],[28,10,29,10],[28,11,29,11],[30,7,31,7],[30,8,31,8],[30,9,31,9],[30,10,31,10],[30,11,31,11],[25,7,26,7],[25,8,26,8],[25,9,26,9],[25,10,26,10],[25,11,26,11],[25,12,26,12],[25,13,26,13],[12,11,13,11],[10,8,11,8],[10,9,11,9],[10,10,11,10],[10,11,11,11],[10,7,11,7],[23,7,24,7],[21,7,22,7],[23,8,24,8],[16,9,17,9],[16,10,17,10],[14,7,15,7],[14,11,15,11],[14,12,15,12],[16,12,17,12],[21,9,22,9],[21,10,22,10],[12,6,13,6],[12,7,13,7],[12,2,13,5],[12,8,13,8],[12,9,13,9],[12,10,13,10],[14,1,15,1],[14,8,15,8],[14,9,15,9],[14,10,15,10],[21,11,22,11],[18,9,19,9],[18,10,19,10],[18,11,19,11],[21,8,22,8],[18,2,19,5],[16,1,17,1],[16,6,17,6],[16,7,17,7],[16,2,17,5],[16,8,17,8],[16,11,17,11],[21,1,22,1],[8,14,9,14],[8,13,9,13],[10,13,11,13],[12,13,13,13],[21,13,22,13],[14,13,15,13],[16,13,17,13],[18,13,19,13],[32,1,33,1],[32,6,33,6],[32,7,33,7],[8,1,9,1],[8,6,9,6],[8,7,9,7],[8,2,9,5],[18,1,19,1],[18,6,19,6],[18,7,19,7],[32,8,33,8],[32,9,33,9],[32,10,33,10],[32,11,33,11],[32,12,33,12],[18,8,19,8],[10,12,11,12],[12,12,13,12],[32,13,33,13],[30,13,31,13],[28,13,29,13],[23,12,24,12],[23,13,24,13],[21,12,22,12],[18,12,19,12],[28,12,29,12],[30,12,31,12]]}
["OFFICIAL NDHSAA DIVING SCORESHEET",null,null,null,null,null,null,null,null,null,null,null,null," Diving\n Order"]
[]
[null,null,null,null,{"$f":"IF(TODAY()>$M$3,\"Scoresheet outdated.  Download new scoresheet from ndhsaa.com.\",\"\")","v":""},null,null,null,null,null,null,null,{"$f":"DATE(YEAR(Season_End),5,1)","v":"2023-05-01"}," Total\n Points\n Awarded"]
["Name ",null,null,null,null,null,"School "]
["Meet ",null,null,"Site ",null,null,null,null,null,"Date ",null,null,null," Order\n of\n Finish"]
["Grade ",null,null,"Varsity ",null,"J. V."]
[]
["PRELIMS (Dives1-5: 2 Vol.  3 Opt. in any order)"]
["Dive\nOrder","Dive\nNumber","Dive Description",null,null,null," Dive\nPosition ","Deg.\nOf\nDiff.","JUDGES SCORES",null,null,null,null,"Judges\nTotal","Points\nAwarded",null,"Hide these yellow columns"]
[null,null,null,null,null,null,null,null,1,2,3,4,5,null,null,null,null,null,"Dive #","Position",null,null,"Dive Schedule","Start","End"]
[1,null,{"$f":"IF(ISNUMBER(S11),VLOOKUP(S11,DiveTable,2,0),\"\")","v":""},null,null,null,{"$f":"T12","v":0},{"$f":"IF(AND(ISNUMBER(S11),ISTEXT(D1_Position)),MIN(VLOOKUP(S11,DiveTable,IF(OR(D1_Position=\"T\",D1_Position=\"C\"),3,IF(OR(D1_Position=\"P\",D1_Position=\"B\"),4,IF(OR(D1_Position=\"S\",D1_Position=\"A\"),5,IF(OR(D1_Position=\"F\",D1_Position=\"D\"),6,#N/A)))),0),1.8),\"\")","v":""},null,null,null,null,null,{"$f":"IF(COUNT(I11:M11)=3,SUM(I11:K11),IF(COUNT(I11:M11)=5,SUM(I11:M11)-MAX(I11:M11)-MIN(I11:M11),\"\"))","v":""},null,null,null,null,{"$f":"IF(LEN(D1_Number)>0,VALUE(IF(LEFT(D1_Number,1)=\"5\",IF(LEN(D1_Number)=4,D1_Number,LEFT(D1_Number,4)),IF(LEN(D1_Number)=3,D1_Number,LEFT(D1_Number,3)))),\"\")","v":""},{"$f":"IF(LEN(D1_Number)>0,1,0)","v":0},null,{"$f":"IF(AND($K$5>=Season_Start,$K$5<=Y11),1,0)","v":0},"Forward Group (100 Series)","2022-08-15",{"$f":"Season_Start+19","v":"2022-09-03"},1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(H12:L12)=3,SUM(H12:J12)*G12,IF(COUNT(H12:L12)=5,(SUM(H12:L12)-MAX(H12:L12)-MIN(H12:L12))*G12,\"\"))","v":""},{"$f":"IF(COUNT(I11:M11)=3,SUM(I11:K11)*D1_DD,IF(COUNT(I11:M11)=5,(SUM(I11:M11)-MAX(I11:M11)-MIN(I11:M11))*D1_DD,\"\"))","v":""},null,null,null,{"$f":"IF(LEN(D1_Number)>0,IF(LEFT(D1_Number,1)=\"5\",IF(LEN(D1_Number)=4,\"\",RIGHT(D1_Number,1)),IF(LEN(D1_Number)=3,\"\",RIGHT(D1_Number,1))),\"\")","v":""},{"$f":"IF(S12=\"A\",\"S\",IF(S12=\"B\",\"P\",IF(S12=\"C\",\"T\",IF(S12=\"D\",\"F\",0))))","v":0},null,{"$f":"IF(AND($K$5>=X12,$K$5<=Y12),1,0)","v":0},"Back Group (200 Series)",{"$f":"Y11+2","v":"2022-09-05"},{"$f":"X12+5","v":"2022-09-10"},2]
[2,null,{"$f":"IF(ISNUMBER(S13),VLOOKUP(S13,DiveTable,2,0),\"\")","v":""},null,null,null,{"$f":"T14","v":0},{"$f":"IF(AND(ISNUMBER(S13),ISTEXT(D2_Position)),VLOOKUP(S13,DiveTable,IF(OR(D2_Position=\"T\",D2_Position=\"C\"),3,IF(OR(D2_Position=\"P\",D2_Position=\"B\"),4,IF(OR(D2_Position=\"S\",D2_Position=\"A\"),5,IF(OR(D2_Position=\"F\",D2_Position=\"D\"),6,#N/A)))),0),\"\")","v":""},null,null,null,null,null,{"$f":"IF(COUNT(I13:M13)=3,SUM(I13:K13),IF(COUNT(I13:M13)=5,SUM(I13:M13)-MAX(I13:M13)-MIN(I13:M13),\"\"))","v":""},{"$f":"IF(COUNT(I13:M13)=3,SUM(I13:K13)*D2_DD,IF(COUNT(I13:M13)=5,(SUM(I13:M13)-MAX(I13:M13)-MIN(I13:M13))*D2_DD,\"\"))","v":""},null,{"$f":"IF(LEN(D2_Number)>1,IF(S13>1,VALUE(LEFT(S13)),0),\"\")","v":""},null,{"$f":"IF(LEN(D2_Number)>0,VALUE(IF(LEFT(D2_Number,1)=\"5\",IF(LEN(D2_Number)=4,D2_Number,LEFT(D2_Number,4)),IF(LEN(D2_Number)=3,D2_Number,LEFT(D2_Number,3)))),\"\")","v":""},{"$f":"IF(LEN(D2_Number)>0,1,0)","v":0},null,0,"Inward Group (400 Series)",{"$f":"Y12+2","v":"2022-09-12"},{"$f":"X13+5","v":"2022-09-17"},4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(H14:L14)=3,SUM(H14:J14)*G14,IF(COUNT(H14:L14)=5,(SUM(H14:L14)-MAX(H14:L14)-MIN(H14:L14))*G14,\"\"))","v":""},{"$f":"IF(ISNUMBER(O13),O12+O13,\"\")","v":""},null,{"$f":"IF(AND(Q13<>Q15,Q13<>Q17,Q13<>Q19,Q13<>Q22),1,0)","v":0},null,{"$f":"IF(LEN(D2_Number)>0,IF(LEFT(D2_Number,1)=\"5\",IF(LEN(D2_Number)=4,\"\",RIGHT(D2_Number,1)),IF(LEN(D2_Number)=3,\"\",RIGHT(D2_Number,1))),\"\")","v":""},{"$f":"IF(S14=\"A\",\"S\",IF(S14=\"B\",\"P\",IF(S14=\"C\",\"T\",IF(S14=\"D\",\"F\",0))))","v":0},null,0,"Twisting Group (5000 Series)","2022-09-19","2022-09-24",5]
[3,null,{"$f":"IF(ISNUMBER(S15),VLOOKUP(S15,DiveTable,2,0),\"\")","v":""},null,null,null,{"$f":"T16","v":0},{"$f":"IF(AND(ISNUMBER(S15),ISTEXT(D3_Position)),VLOOKUP(S15,DiveTable,IF(OR(D3_Position=\"T\",D3_Position=\"C\"),3,IF(OR(D3_Position=\"P\",D3_Position=\"B\"),4,IF(OR(D3_Position=\"S\",D3_Position=\"A\"),5,IF(OR(D3_Position=\"F\",D3_Position=\"D\"),6,#N/A)))),0),\"\")","v":""},null,null,null,null,null,{"$f":"IF(COUNT(I15:M15)=3,SUM(I15:K15),IF(COUNT(I15:M15)=5,SUM(I15:M15)-MAX(I15:M15)-MIN(I15:M15),\"\"))","v":""},{"$f":"IF(COUNT(I15:M15)=3,SUM(I15:K15)*D3_DD,IF(COUNT(I15:M15)=5,(SUM(I15:M15)-MAX(I15:M15)-MIN(I15:M15))*D3_DD,\"\"))","v":""},null,{"$f":"IF(LEN(D3_Number)>1,IF(S15>1,VALUE(LEFT(S15)),0),\"\")","v":""},null,{"$f":"IF(LEN(D3_Number)>0,VALUE(IF(LEFT(D3_Number,1)=\"5\",IF(LEN(D3_Number)=4,D3_Number,LEFT(D3_Number,4)),IF(LEN(D3_Number)=3,D3_Number,LEFT(D3_Number,3)))),\"\")","v":""},{"$f":"IF(LEN(D3_Number)>0,1,0)","v":0},null,0,"Reverse Group (300 Series)","2022-09-26","2022-10-01",3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(H16:L16)=3,SUM(H16:J16)*G16,IF(COUNT(H16:L16)=5,(SUM(H16:L16)-MAX(H16:L16)-MIN(H16:L16))*G16,\"\"))","v":""},{"$f":"IF(ISNUMBER(O15),O14+O15,\"\")","v":""},null,{"$f":"IF(AND(Q15<>Q13,Q15<>Q17,Q15<>Q19,Q15<>Q22),1,0)","v":0},null,{"$f":"IF(LEN(D3_Number)>0,IF(LEFT(D3_Number,1)=\"5\",IF(LEN(D3_Number)=4,\"\",RIGHT(D3_Number,1)),IF(LEN(D3_Number)=3,\"\",RIGHT(D3_Number,1))),\"\")","v":""},{"$f":"IF(S16=\"A\",\"S\",IF(S16=\"B\",\"P\",IF(S16=\"C\",\"T\",IF(S16=\"D\",\"F\",0))))","v":0},null,0,{"$f":"W11","v":"Forward Group (100 Series)"},"2022-10-03","2022-10-08",1]
[4,null,{"$f":"IF(ISNUMBER(S17),VLOOKUP(S17,DiveTable,2,0),\"\")","v":""},null,null,null,{"$f":"T18","v":0},{"$f":"IF(AND(ISNUMBER(S17),ISTEXT(D4_Position)),VLOOKUP(S17,DiveTable,IF(OR(D4_Position=\"T\",D4_Position=\"C\"),3,IF(OR(D4_Position=\"P\",D4_Position=\"B\"),4,IF(OR(D4_Position=\"S\",D4_Position=\"A\"),5,IF(OR(D4_Position=\"F\",D4_Position=\"D\"),6,#N/A)))),0),\"\")","v":""},null,null,null,null,null,{"$f":"IF(COUNT(I17:M17)=3,SUM(I17:K17),IF(COUNT(I17:M17)=5,SUM(I17:M17)-MAX(I17:M17)-MIN(I17:M17),\"\"))","v":""},{"$f":"IF(COUNT(I17:M17)=3,SUM(I17:K17)*D4_DD,IF(COUNT(I17:M17)=5,(SUM(I17:M17)-MAX(I17:M17)-MIN(I17:M17))*D4_DD,\"\"))","v":""},null,{"$f":"IF(LEN(D4_Number)>1,IF(S17>1,VALUE(LEFT(S17)),0),\"\")","v":""},null,{"$f":"IF(LEN(D4_Number)>0,VALUE(IF(LEFT(D4_Number,1)=\"5\",IF(LEN(D4_Number)=4,D4_Number,LEFT(D4_Number,4)),IF(LEN(D4_Number)=3,D4_Number,LEFT(D4_Number,3)))),\"\")","v":""},{"$f":"IF(LEN(D4_Number)>0,1,0)","v":0},null,0,{"$f":"W12","v":"Back Group (200 Series)"},"2022-10-10","2022-10-15",2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(H18:L18)=3,SUM(H18:J18)*G18,IF(COUNT(H18:L18)=5,(SUM(H18:L18)-MAX(H18:L18)-MIN(H18:L18))*G18,\"\"))","v":""},{"$f":"IF(ISNUMBER(O17),O16+O17,\"\")","v":""},null,{"$f":"IF(AND(Q17<>Q13,Q17<>Q15,Q17<>Q19,Q17<>Q22),1,0)","v":0},null,{"$f":"IF(LEN(D4_Number)>0,IF(LEFT(D4_Number,1)=\"5\",IF(LEN(D4_Number)=4,\"\",RIGHT(D4_Number,1)),IF(LEN(D4_Number)=3,\"\",RIGHT(D4_Number,1))),\"\")","v":""},{"$f":"IF(S18=\"A\",\"S\",IF(S18=\"B\",\"P\",IF(S18=\"C\",\"T\",IF(S18=\"D\",\"F\",0))))","v":0},null,0,"Inward Group (400 Series)","2022-10-17","2022-10-22",4]
[5,null,{"$f":"IF(ISNUMBER(S19),VLOOKUP(S19,DiveTable,2,0),\"\")","v":""},null,null,null,{"$f":"T20","v":0},{"$f":"IF(AND(ISNUMBER(S19),ISTEXT(D5_Position)),VLOOKUP(S19,DiveTable,IF(OR(D5_Position=\"T\",D5_Position=\"C\"),3,IF(OR(D5_Position=\"P\",D5_Position=\"B\"),4,IF(OR(D5_Position=\"S\",D5_Position=\"A\"),5,IF(OR(D5_Position=\"F\",D5_Position=\"D\"),6,#N/A)))),0),\"\")","v":""},null,null,null,null,null,{"$f":"IF(COUNT(I19:M19)=3,SUM(I19:K19),IF(COUNT(I19:M19)=5,SUM(I19:M19)-MAX(I19:M19)-MIN(I19:M19),\"\"))","v":""},{"$f":"IF(COUNT(I19:M19)=3,SUM(I19:K19)*D5_DD,IF(COUNT(I19:M19)=5,(SUM(I19:M19)-MAX(I19:M19)-MIN(I19:M19))*D5_DD,\"\"))","v":""},null,{"$f":"IF(LEN(D5_Number)>1,IF(S19>1,VALUE(LEFT(S19)),0),\"\")","v":""},null,{"$f":"IF(LEN(D5_Number)>0,VALUE(IF(LEFT(D5_Number,1)=\"5\",IF(LEN(D5_Number)=4,D5_Number,LEFT(D5_Number,4)),IF(LEN(D5_Number)=3,D5_Number,LEFT(D5_Number,3)))),\"\")","v":""},{"$f":"IF(LEN(D5_Number)>0,1,0)","v":0},null,0,"Twisting Group (5000 Series)","2022-10-24","2022-10-29",5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(H20:L20)=3,SUM(H20:J20)*G20,IF(COUNT(H20:L20)=5,(SUM(H20:L20)-MAX(H20:L20)-MIN(H20:L20))*G20,\"\"))","v":""},{"$f":"IF(ISNUMBER(O19),O18+O19,\"\")","v":""},null,{"$f":"IF(AND(Q19<>Q13,Q19<>Q15,Q19<>Q17,Q19<>Q22),1,0)","v":0},null,{"$f":"IF(LEN(D5_Number)>0,IF(LEFT(D5_Number,1)=\"5\",IF(LEN(D5_Number)=4,\"\",RIGHT(D5_Number,1)),IF(LEN(D5_Number)=3,\"\",RIGHT(D5_Number,1))),\"\")","v":""},{"$f":"IF(S20=\"A\",\"S\",IF(S20=\"B\",\"P\",IF(S20=\"C\",\"T\",IF(S20=\"D\",\"F\",0))))","v":0},null,0,"Reverse Group (300 Series)","2022-10-31","2022-11-05",3]
["SEMI-FINALS (Dives 6,7,8 - 2 Vol. & 1 Opt. In any order)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"Forward Group (100 Series)","2022-12-09",{"$f":"X21+8","v":"2022-12-17"},1]
[6,null,{"$f":"IF(ISNUMBER(S22),VLOOKUP(S22,DiveTable,2,0),\"\")","v":""},null,null,null,{"$f":"T23","v":0},{"$f":"IF(AND(ISNUMBER(S22),ISTEXT(D6_Position)),VLOOKUP(S22,DiveTable,IF(OR(D6_Position=\"T\",D6_Position=\"C\"),3,IF(OR(D6_Position=\"P\",D6_Position=\"B\"),4,IF(OR(D6_Position=\"S\",D6_Position=\"A\"),5,IF(OR(D6_Position=\"F\",D6_Position=\"D\"),6,#N/A)))),0),\"\")","v":""},null,null,null,null,null,{"$f":"IF(COUNT(I22:M22)=3,SUM(I22:K22),IF(COUNT(I22:M22)=5,SUM(I22:M22)-MAX(I22:M22)-MIN(I22:M22),\"\"))","v":""},{"$f":"IF(COUNT(I22:M22)=3,SUM(I22:K22)*D6_DD,IF(COUNT(I22:M22)=5,(SUM(I22:M22)-MAX(I22:M22)-MIN(I22:M22))*D6_DD,\"\"))","v":""},null,{"$f":"IF(LEN(D6_Number)>1,IF(S22>1,VALUE(LEFT(S22)),0),\"\")","v":""},null,{"$f":"IF(LEN(D6_Number)>0,VALUE(IF(LEFT(D6_Number,1)=\"5\",IF(LEN(D6_Number)=4,D6_Number,LEFT(D6_Number,4)),IF(LEN(D6_Number)=3,D6_Number,LEFT(D6_Number,3)))),\"\")","v":""},{"$f":"IF(LEN(D6_Number)>0,1,0)","v":0},null,0,"Back Group (200 Series)",{"$f":"Y21+2","v":"2022-12-19"},{"$f":"X22+12","v":"2022-12-31"},2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(H23:L23)=3,SUM(H23:J23)*G23,IF(COUNT(H23:L23)=5,(SUM(H23:L23)-MAX(H23:L23)-MIN(H23:L23))*G23,\"\"))","v":""},{"$f":"IF(ISNUMBER(O22),O20+O22,\"\")","v":""},null,{"$f":"IF(AND(Q22<>Q13,Q22<>Q15,Q22<>Q17,Q22<>Q19),1,0)","v":0},null,{"$f":"IF(LEN(D6_Number)>0,IF(LEFT(D6_Number,1)=\"5\",IF(LEN(D6_Number)=4,\"\",RIGHT(D6_Number,1)),IF(LEN(D6_Number)=3,\"\",RIGHT(D6_Number,1))),\"\")","v":""},{"$f":"IF(S23=\"A\",\"S\",IF(S23=\"B\",\"P\",IF(S23=\"C\",\"T\",IF(S23=\"D\",\"F\",0))))","v":0},null,0,"Inward Group (400 Series)",{"$f":"Y22+2","v":"2023-01-02"},{"$f":"X23+5","v":"2023-01-07"},4]
[7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(LEN(R24)>1,1,0)","v":0},{"$f":"IF(ISNA(D1_Description),\"Illegal Dive No. 1\",IF(ISNA(D2_Description),\"Illegal Dive No. 2\",IF(ISNA(D3_Description),\"Illegal Dive No. 3\",IF(ISNA(D4_Description),\"Illegal Dive No. 4\",IF(ISNA(D5_Description),\"Illegal Dive No. 5\",IF(ISNA(D6_Description),\"Illegal Dive No. 6\",\"\"))))))","v":""},null,{"$f":"SUM(T11,T13,T15,T17,T19,T22)","v":0},null,0,"Twisting Group (5000 Series)","2023-01-09","2023-01-14",5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(OR(AND(T11,S11=S13),AND(T11,S11=S15),AND(T11,S11=S17),AND(T11,S11=S19),AND(T11,S11=S22),AND(T13,S13=S15),AND(T13,S13=S17),AND(T13,S13=S19),AND(T13,S13=S22),AND(T15,S15=S17),AND(T15,S15=S19),AND(T15,S15=S22),AND(T17,S17=S19),AND(T17,S17=S22),AND(T19,S19=S22)),\"Repeated Dive\",IF(AND(SUM(Q14,Q16,Q18,Q20,Q23)<3,T24=6),\"Optional Dives Need 4 of 5 Groups\",\"\"))","v":""},null,null,null,0,"Reverse Group (300 Series)","2023-01-16","2023-01-21",3]
[8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISNA(D1_DD),\"Illegal Position for Dive 1\",IF(ISNA(D2_DD),\"Illegal Position for Dive 2\",IF(ISNA(D3_DD),\"Illegal Position for Dive 3\",IF(ISNA(D4_DD),\"Illegal Position for Dive 4\",IF(ISNA(D5_DD),\"Illegal Position for Dive 5\",IF(ISNA(D6_DD),\"Illegal Position for Dive 6\",\"\"))))))","v":""},null,null,null,0,"Forward Group (100 Series)","2023-01-23","2023-01-28",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(AND(D1_Position=T12,D2_Position=T14,D3_Position=T16,D4_Position=T18,D5_Position=T20,D6_Position=T23),\"\",\"Dive Number does not match Dive Position\")","v":""},null,null,null,0,"Back Group (200 Series)","2023-01-30","2023-02-04",2]
["FINALS (Dives 9,10,11 - 1 Vol. & 2 Opt. in any order)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(X42,\"Enter \"&Y42,\"\")","v":"Enter Name"},null,null,null,0,"Inward Group (400 Series)","2023-02-06","2023-02-11",4]
[9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(AND(T11,T24<6),\"Exhibition Sheet\",\"\")","v":""},null,null,null,0,"Twisting Group (5000 Series)","2023-02-13","2023-02-18",5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(AND(X35,Y34>0),\"First dive must be \"&X33,\"\")","v":""},null,null,null,0,"Reverse Group (300 Series)","2023-02-20","2023-02-25",3]
[10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(Q24:Q30)>0,VLOOKUP(1,Q24:R30,2,0),\"\")","v":"Enter Name"},null,null,null,null,null,null,null,{"$f":"Y30+14","v":"2023-03-11"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Valid Date Entered:",{"$f":"IF(AND(ISNUMBER(Date_6D),SUM(VD_Select)=1),1,0)","v":0}]
[11,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dive Series:",{"$f":"IF(SUM(VD_Select)=1,VLOOKUP(1,VD_Schedule,2,FALSE),0)","v":0},{"$f":"IF(SUM(VD_Select)=1,VLOOKUP(1,VD_Schedule,5,FALSE),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Correct Dive Series Entered:",{"$f":"IF(Y33=Y34,1,0)","v":1},{"$f":"IFERROR(VALUE(LEFT(D1_Number,1)),0)","v":0}]
[null,null,{"$f":"Q31","v":"Enter Name"},null,null,null,null,null,null,null,null,null,null,"TOTAL POINTS AWARDED  ",{"$f":"IF(ISNUMBER(O23),O23,\"\")","v":""},null,null,"Consideration",150,null,null,null,null,{"$f":"IF(AND(X32,X34),0,1)","v":1}]
[null,null,null,null,null,null,null,null,null,null,"Signatures",null,null,null,null,null,null,"Qualifying",170,null,null,null,"Name Entered:",{"$f":"IF(LEN(Name_6D)>0,0,1)","v":1},"Name"]
[null,"T(C) = Tuck, P(B) = Pike, S(A) = Straight, F(D) = Free\nDual Meets: List voluntary dive first. Spaces 2-6 for optional dives\nCHAMPIONSHIP & OTHER 11-DIVE MEETS: List dives in each section as per instructions",null,null,null,null,null,null,null,null,"Diver",null,null,null,null,null,null,null,null,null,null,null,"School Entered:",{"$f":"IF(LEN(School_6D)>0,0,1)","v":1},"School"]
[null,null,null,null,null,null,null,null,null,null,"Coach",null,null,null,null,null,null,null,null,null,null,null,"Meet Entered:",{"$f":"IF(LEN(Meet_6D)>0,0,1)","v":1},"Meet"]
["gvp 7/30/22",null,{"$f":"IFERROR(\"Voluntary Dive Schedule: \"&INDEX(VD_List,MATCH(1,VD_Select,0)),\"Enter Valid Meet Date\")","v":"Enter Valid Meet Date"},null,null,null,null,null,null,null,"Referee",null,null,null,null,null,null,null,null,null,null,null,"Site Entered:",{"$f":"IF(LEN(Site_6D)>0,0,1)","v":1},"Site"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date Entered:",{"$f":"IF(X32,0,1)","v":1},"Valid Meet Date"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grade Entered:",{"$f":"IF(LEN(Grade_6D)>0,0,1)","v":1},"Grade"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(X36:X41)","v":1},{"$f":"VLOOKUP(X42,X36:Y41,2,0)","v":"Name"}]

{"sheet":"NDHSAA 11 Dive","index":2,"n_rows":50,"n_cols":36,"rows_kept":50,"cut":false,"hidden":false,"merged":[[34,2,34,6],[30,13,31,13],[12,12,13,12],[32,13,33,13],[32,12,33,12],[18,8,19,8],[18,9,19,9],[18,10,19,10],[18,11,19,11],[21,9,22,9],[21,10,22,10],[21,11,22,11],[21,12,22,12],[32,8,33,8],[32,9,33,9],[32,10,33,10],[32,11,33,11],[25,11,26,11],[28,13,29,13],[23,6,24,6],[23,7,24,7],[23,2,24,5],[21,6,22,6],[21,7,22,7],[8,14,9,14],[8,13,9,13],[10,13,11,13],[12,13,13,13],[16,8,17,8],[16,9,17,9],[16,10,17,10],[16,11,17,11],[18,2,19,5],[16,6,17,6],[16,7,17,7],[16,2,17,5],[14,13,15,13],[16,13,17,13],[18,13,19,13],[8,6,9,6],[8,7,9,7],[8,2,9,5],[18,6,19,6],[18,7,19,7],[32,1,33,1],[32,6,33,6],[32,7,33,7],[12,10,13,10],[12,11,13,11],[12,1,13,1],[12,6,13,6],[12,7,13,7],[12,2,13,5],[14,1,15,1],[14,6,15,6],[14,7,15,7],[14,2,15,5],[14,8,15,8],[14,9,15,9],[14,10,15,10],[14,11,15,11],[25,1,26,1],[25,6,26,6],[25,7,26,7],[25,8,26,8],[25,9,26,9],[25,10,26,10],[23,8,24,8],[8,0,9,0],[10,0,11,0],[12,0,13,0],[14,0,15,0],[16,0,17,0],[18,0,19,0],[21,0,22,0],[23,0,24,0],[21,1,22,1],[8,1,9,1],[18,1,19,1],[16,1,17,1],[18,15,19,15],[21,15,22,15],[23,15,24,15],[23,12,24,12],[23,13,24,13],[10,15,11,15],[12,15,13,15],[14,15,15,15],[16,15,17,15],[18,12,19,12],[14,12,15,12],[16,12,17,12],[10,12,11,12],[21,13,22,13],[25,0,26,0],[28,0,29,0],[30,0,31,0],[32,0,33,0],[30,15,31,15],[32,15,33,15],[30,9,31,9],[30,10,31,10],[30,11,31,11],[30,12,31,12],[28,12,29,12],[25,15,26,15],[28,15,29,15],[25,12,26,12],[25,13,26,13],[30,1,31,1],[30,6,31,6],[30,7,31,7],[30,8,31,8],[28,1,29,1],[28,6,29,6],[28,7,29,7],[28,8,29,8],[28,9,29,9],[36,1,37,6],[4,10,4,11],[25,2,26,5],[28,2,29,5],[30,2,31,5],[32,2,33,5],[23,9,24,9],[23,10,24,10],[23,11,24,11],[23,1,24,1],[28,10,29,10],[28,11,29,11],[21,2,22,5],[21,8,22,8],[10,1,11,1],[10,6,11,6],[10,7,11,7],[10,2,11,5],[10,8,11,8],[10,9,11,9],[10,10,11,10],[10,11,11,11],[12,8,13,8],[12,9,13,9],[0,13,1,14],[2,13,3,14],[4,13,5,14],[3,1,3,5],[4,1,4,2],[5,1,5,2],[4,4,4,6],[3,7,3,11],[5,6,5,7],[0,0,1,11]]}
["OFFICIAL NDHSAA DIVING SCORESHEET",null,null,null,null,null,null,null,null,null,null,null,null," Diving\n Order",null,null,null,"Hide these yellow columns"]
[]
[null,null,null,null,{"$f":"IF(TODAY()>$M$3,\"Scoresheet outdated.  Download new scoresheet from ndhsaa.com.\",\"\")","v":""},null,null,null,null,null,null,null,{"$f":"'NDHSAA 6 Dive'!M3","v":"2023-05-01"}," Total\n Points\n Awarded"]
["Name ",null,null,null,null,null,"School "]
["Meet ",null,null,"Site ",null,null,null,null,null,"Date ",null,null,null," Order\n of\n Finish"]
["Grade ",null,null,"Varsity ",null,"J. V."]
[]
["PRELIMS (Dives1-5: 2 Vol.  3 Opt. in any order)"]
["Dive\nOrder","Dive\nNumber","Dive Description",null,null,null," Dive\nPosition ","Deg.\nOf\nDiff.","JUDGES SCORES",null,null,null,null,"Judges\nTotal","Points\nAwarded"," Voluntary ",null,"Voluntary",null,null,null,null,null,null,null,null,null,null,null,null,null,">1 Optional from same"]
[null,null,null,null,null,null,null,null,1,2,3,4,5,null,null," Optional ",null,"DD < 9.0","5 Groups in 1st 8 Rounds",null,null,null,null,"2 V & 3 O in prelims",null,"6 Optionals from 5 Groups",null,null,null,null,null,"Group through semis","Dive#","Position","5 Voluntary from each group"]
[1,null,{"$f":"IF(ISNUMBER(AG11),VLOOKUP(AG11,DiveTable,2,0),\"\")","v":""},null,null,null,{"$f":"IF(AH12=0,\"\",AH12)","v":""},{"$f":"IF(AND(ISNUMBER(AG11),ISTEXT(G11)),VLOOKUP(AG11,DiveTable,IF(OR(G11=\"T\",G11=\"C\"),3,IF(OR(G11=\"P\",G11=\"B\"),4,IF(OR(G11=\"S\",G11=\"A\"),5,IF(OR(G11=\"F\",G11=\"D\"),6,#N/A)))),0),\"\")","v":""},null,null,null,null,null,{"$f":"IF(COUNT(I11:M11)=3,SUM(I11:K11),IF(COUNT(I11:M11)=5,SUM(I11:M11)-MAX(I11:M11)-MIN(I11:M11),\"\"))","v":""},null," ",null,{"$f":"IF(P11=\"V\",H11,0)","v":0},{"$f":"IF(LEN($B11)>1,VALUE(LEFT($AG11)),0)","v":0},{"$f":"IF(LEN($B11)>1,VALUE(LEFT($AG11)),0)","v":0},{"$f":"IF(LEN($B11)>1,VALUE(LEFT($AG11)),0)","v":0},{"$f":"IF(LEN($B11)>1,VALUE(LEFT($AG11)),0)","v":0},{"$f":"IF(LEN($B11)>1,VALUE(LEFT($AG11)),0)","v":0},{"$f":"COUNTIF($P$11:$P$20,\"=V\")","v":0},{"$f":"COUNTIF($P$11:$P$20,\"=O\")","v":0},{"$f":"IF(AND(LEN($B11)>1,$P11=\"O\"),VALUE(LEFT($AG11)),0)","v":0},{"$f":"IF(AND(LEN($B11)>1,$P11=\"O\"),VALUE(LEFT($AG11)),0)","v":0},0,0,0,null,{"$f":"AA11","v":0},{"$f":"IF(LEN(B11)>0,VALUE(IF(LEFT(B11,1)=\"5\",IF(LEN(B11)=4,B11,LEFT(B11,4)),IF(LEN(B11)=3,B11,LEFT(B11,3)))),\"\")","v":""},null,{"$f":"IF(AND(LEN($B11)>1,$P11=\"V\"),VALUE(LEFT($AG11)),0)","v":0}," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(H12:L12)=3,SUM(H12:J12)*G12,IF(COUNT(H12:L12)=5,(SUM(H12:L12)-MAX(H12:L12)-MIN(H12:L12))*G12,\"\"))","v":""},{"$f":"IF(COUNT(I11:M11)=3,SUM(I11:K11)*H11,IF(COUNT(I11:M11)=5,(SUM(I11:M11)-MAX(I11:M11)-MIN(I11:M11))*H11,\"\"))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(AND(X11=2,Y11=3),\"\",\"Need 2 Voluntary & 3 Optional Dives in Prelims\")","v":"Need 2 Voluntary & 3 Optional Dives in Prelims"},null,"",null,null,null,null,null,{"$f":"IF(AF11>0,IF(OR(AF11=$AF$13,AF11=$AF$15,AF11=$AF$17,AF11=$AF$19,AF11=$AF$22,AF11=$AF$24,AF11=$AF$26),1,0),0)","v":0},{"$f":"IF(LEN(B11)>0,IF(LEFT(B11,1)=\"5\",IF(LEN(B11)=4,\"\",RIGHT(B11,1)),IF(LEN(B11)=3,\"\",RIGHT(B11,1))),\"\")","v":""},{"$f":"IF(AG12=\"A\",\"S\",IF(AG12=\"B\",\"P\",IF(AG12=\"C\",\"T\",IF(AG12=\"D\",\"F\",0))))","v":0},null,"V"]
[2,null,{"$f":"IF(ISNUMBER(AG13),VLOOKUP(AG13,DiveTable,2,0),\"\")","v":""},null,null,null,{"$f":"IF(AH14=0,\"\",AH14)","v":""},{"$f":"IF(AND(ISNUMBER(AG13),ISTEXT(G13)),VLOOKUP(AG13,DiveTable,IF(OR(G13=\"T\",G13=\"C\"),3,IF(OR(G13=\"P\",G13=\"B\"),4,IF(OR(G13=\"S\",G13=\"A\"),5,IF(OR(G13=\"F\",G13=\"D\"),6,#N/A)))),0),\"\")","v":""},null,null,null,null,null,{"$f":"IF(COUNT(I13:M13)=3,SUM(I13:K13),IF(COUNT(I13:M13)=5,SUM(I13:M13)-MAX(I13:M13)-MIN(I13:M13),\"\"))","v":""},{"$f":"IF(COUNT(I13:M13)=3,SUM(I13:K13)*H13,IF(COUNT(I13:M13)=5,(SUM(I13:M13)-MAX(I13:M13)-MIN(I13:M13))*H13,\"\"))","v":""}," ",null,{"$f":"IF(P13=\"V\",H13,0)","v":0},{"$f":"IF(LEN($B13)>1,VALUE(LEFT($AG13)),0)","v":0},{"$f":"IF(LEN($B13)>1,VALUE(LEFT($AG13)),0)","v":0},0,0,0,null,null,{"$f":"IF(AND(LEN($B13)>1,$P13=\"O\"),VALUE(LEFT($AG13)),0)","v":0},0,0,0,0,null,{"$f":"AA13","v":0},{"$f":"IF(LEN(B13)>0,VALUE(IF(LEFT(B13,1)=\"5\",IF(LEN(B13)=4,B13,LEFT(B13,4)),IF(LEN(B13)=3,B13,LEFT(B13,3)))),\"\")","v":""},null,{"$f":"IF(AND(LEN($B13)>1,$P13=\"V\"),VALUE(LEFT($AG13)),0)","v":0},"O"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(H14:L14)=3,SUM(H14:J14)*G14,IF(COUNT(H14:L14)=5,(SUM(H14:L14)-MAX(H14:L14)-MIN(H14:L14))*G14,\"\"))","v":""},{"$f":"IF(ISNUMBER(O13),O12+O13,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AF13>0,IF(OR(AF13=$AF$11,AF13=$AF$15,AF13=$AF$17,AF13=$AF$19,AF13=$AF$22,AF13=$AF$24,AF13=$AF$26),1,0),0)","v":0},{"$f":"IF(LEN(B13)>0,IF(LEFT(B13,1)=\"5\",IF(LEN(B13)=4,\"\",RIGHT(B13,1)),IF(LEN(B13)=3,\"\",RIGHT(B13,1))),\"\")","v":""},{"$f":"IF(AG14=\"A\",\"S\",IF(AG14=\"B\",\"P\",IF(AG14=\"C\",\"T\",IF(AG14=\"D\",\"F\",0))))","v":0}]
[3,null,{"$f":"IF(ISNUMBER(AG15),VLOOKUP(AG15,DiveTable,2,0),\"\")","v":""},null,null,null,{"$f":"IF(AH16=0,\"\",AH16)","v":""},{"$f":"IF(AND(ISNUMBER(AG15),ISTEXT(G15)),VLOOKUP(AG15,DiveTable,IF(OR(G15=\"T\",G15=\"C\"),3,IF(OR(G15=\"P\",G15=\"B\"),4,IF(OR(G15=\"S\",G15=\"A\"),5,IF(OR(G15=\"F\",G15=\"D\"),6,#N/A)))),0),\"\")","v":""},null,null,null,null,null,{"$f":"IF(COUNT(I15:M15)=3,SUM(I15:K15),IF(COUNT(I15:M15)=5,SUM(I15:M15)-MAX(I15:M15)-MIN(I15:M15),\"\"))","v":""},{"$f":"IF(COUNT(I15:M15)=3,SUM(I15:K15)*H15,IF(COUNT(I15:M15)=5,(SUM(I15:M15)-MAX(I15:M15)-MIN(I15:M15))*H15,\"\"))","v":""}," ",null,{"$f":"IF(P15=\"V\",H15,0)","v":0},{"$f":"IF(LEN($B15)>1,VALUE(LEFT($AG15)),0)","v":0},0,0,0,0,null,null,{"$f":"IF(AND(LEN($B15)>1,$P15=\"O\"),VALUE(LEFT($AG15)),0)","v":0},0,0,0,0,null,{"$f":"AA15","v":0},{"$f":"IF(LEN(B15)>0,VALUE(IF(LEFT(B15,1)=\"5\",IF(LEN(B15)=4,B15,LEFT(B15,4)),IF(LEN(B15)=3,B15,LEFT(B15,3)))),\"\")","v":""},null,{"$f":"IF(AND(LEN($B15)>1,$P15=\"V\"),VALUE(LEFT($AG15)),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(H16:L16)=3,SUM(H16:J16)*G16,IF(COUNT(H16:L16)=5,(SUM(H16:L16)-MAX(H16:L16)-MIN(H16:L16))*G16,\"\"))","v":""},{"$f":"IF(ISNUMBER(O15),O14+O15,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AF15>0,IF(OR(AF15=$AF$13,AF15=$AF$11,AF15=$AF$17,AF15=$AF$19,AF15=$AF$22,AF15=$AF$24,AF15=$AF$26),1,0),0)","v":0},{"$f":"IF(LEN(B15)>0,IF(LEFT(B15,1)=\"5\",IF(LEN(B15)=4,\"\",RIGHT(B15,1)),IF(LEN(B15)=3,\"\",RIGHT(B15,1))),\"\")","v":""},{"$f":"IF(AG16=\"A\",\"S\",IF(AG16=\"B\",\"P\",IF(AG16=\"C\",\"T\",IF(AG16=\"D\",\"F\",0))))","v":0}]
[4,null,{"$f":"IF(ISNUMBER(AG17),VLOOKUP(AG17,DiveTable,2,0),\"\")","v":""},null,null,null,{"$f":"IF(AH18=0,\"\",AH18)","v":""},{"$f":"IF(AND(ISNUMBER(AG17),ISTEXT(G17)),VLOOKUP(AG17,DiveTable,IF(OR(G17=\"T\",G17=\"C\"),3,IF(OR(G17=\"P\",G17=\"B\"),4,IF(OR(G17=\"S\",G17=\"A\"),5,IF(OR(G17=\"F\",G17=\"D\"),6,#N/A)))),0),\"\")","v":""},null,null,null,null,null,{"$f":"IF(COUNT(I17:M17)=3,SUM(I17:K17),IF(COUNT(I17:M17)=5,SUM(I17:M17)-MAX(I17:M17)-MIN(I17:M17),\"\"))","v":""},{"$f":"IF(COUNT(I17:M17)=3,SUM(I17:K17)*H17,IF(COUNT(I17:M17)=5,(SUM(I17:M17)-MAX(I17:M17)-MIN(I17:M17))*H17,\"\"))","v":""}," ",null,{"$f":"IF(P17=\"V\",H17,0)","v":0},{"$f":"IF(LEN($B17)>1,VALUE(LEFT($AG17)),0)","v":0},0,0,0,0,null,null,{"$f":"IF(AND(LEN($B17)>1,$P17=\"O\"),VALUE(LEFT($AG17)),0)","v":0},0,0,0,0,null,{"$f":"AA17","v":0},{"$f":"IF(LEN(B17)>0,VALUE(IF(LEFT(B17,1)=\"5\",IF(LEN(B17)=4,B17,LEFT(B17,4)),IF(LEN(B17)=3,B17,LEFT(B17,3)))),\"\")","v":""},null,{"$f":"IF(AND(LEN($B17)>1,$P17=\"V\"),VALUE(LEFT($AG17)),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(H18:L18)=3,SUM(H18:J18)*G18,IF(COUNT(H18:L18)=5,(SUM(H18:L18)-MAX(H18:L18)-MIN(H18:L18))*G18,\"\"))","v":""},{"$f":"IF(ISNUMBER(O17),O16+O17,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AF17>0,IF(OR(AF17=$AF$13,AF17=$AF$15,AF17=$AF$11,AF17=$AF$19,AF17=$AF$22,AF17=$AF$24,AF17=$AF$26),1,0),0)","v":0},{"$f":"IF(LEN(B17)>0,IF(LEFT(B17,1)=\"5\",IF(LEN(B17)=4,\"\",RIGHT(B17,1)),IF(LEN(B17)=3,\"\",RIGHT(B17,1))),\"\")","v":""},{"$f":"IF(AG18=\"A\",\"S\",IF(AG18=\"B\",\"P\",IF(AG18=\"C\",\"T\",IF(AG18=\"D\",\"F\",0))))","v":0}]
[5,null,{"$f":"IF(ISNUMBER(AG19),VLOOKUP(AG19,DiveTable,2,0),\"\")","v":""},null,null,null,{"$f":"IF(AH20=0,\"\",AH20)","v":""},{"$f":"IF(AND(ISNUMBER(AG19),ISTEXT(G19)),VLOOKUP(AG19,DiveTable,IF(OR(G19=\"T\",G19=\"C\"),3,IF(OR(G19=\"P\",G19=\"B\"),4,IF(OR(G19=\"S\",G19=\"A\"),5,IF(OR(G19=\"F\",G19=\"D\"),6,#N/A)))),0),\"\")","v":""},null,null,null,null,null,{"$f":"IF(COUNT(I19:M19)=3,SUM(I19:K19),IF(COUNT(I19:M19)=5,SUM(I19:M19)-MAX(I19:M19)-MIN(I19:M19),\"\"))","v":""},{"$f":"IF(COUNT(I19:M19)=3,SUM(I19:K19)*H19,IF(COUNT(I19:M19)=5,(SUM(I19:M19)-MAX(I19:M19)-MIN(I19:M19))*H19,\"\"))","v":""}," ",null,{"$f":"IF(P19=\"V\",H19,0)","v":0},{"$f":"IF(LEN($B19)>1,VALUE(LEFT($AG19)),0)","v":0},0,0,0,0,null,null,{"$f":"IF(AND(LEN($B19)>1,$P19=\"O\"),VALUE(LEFT($AG19)),0)","v":0},0,0,0,0,null,{"$f":"AA19","v":0},{"$f":"IF(LEN(B19)>0,VALUE(IF(LEFT(B19,1)=\"5\",IF(LEN(B19)=4,B19,LEFT(B19,4)),IF(LEN(B19)=3,B19,LEFT(B19,3)))),\"\")","v":""},null,{"$f":"IF(AND(LEN($B19)>1,$P19=\"V\"),VALUE(LEFT($AG19)),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(H20:L20)=3,SUM(H20:J20)*G20,IF(COUNT(H20:L20)=5,(SUM(H20:L20)-MAX(H20:L20)-MIN(H20:L20))*G20,\"\"))","v":""},{"$f":"IF(ISNUMBER(O19),O18+O19,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AF19>0,IF(OR(AF19=$AF$13,AF19=$AF$15,AF19=$AF$17,AF19=$AF$11,AF19=$AF$22,AF19=$AF$24,AF19=$AF$26),1,0),0)","v":0},{"$f":"IF(LEN(B19)>0,IF(LEFT(B19,1)=\"5\",IF(LEN(B19)=4,\"\",RIGHT(B19,1)),IF(LEN(B19)=3,\"\",RIGHT(B19,1))),\"\")","v":""},{"$f":"IF(AG20=\"A\",\"S\",IF(AG20=\"B\",\"P\",IF(AG20=\"C\",\"T\",IF(AG20=\"D\",\"F\",0))))","v":0}]
["SEMI-FINALS (Dives 6,7,8 - 2 Vol. & 1 Opt. In any order)"]
[6,null,{"$f":"IF(ISNUMBER(AG22),VLOOKUP(AG22,DiveTable,2,0),\"\")","v":""},null,null,null,{"$f":"IF(AH23=0,\"\",AH23)","v":""},{"$f":"IF(AND(ISNUMBER(AG22),ISTEXT(G22)),VLOOKUP(AG22,DiveTable,IF(OR(G22=\"T\",G22=\"C\"),3,IF(OR(G22=\"P\",G22=\"B\"),4,IF(OR(G22=\"S\",G22=\"A\"),5,IF(OR(G22=\"F\",G22=\"D\"),6,#N/A)))),0),\"\")","v":""},null,null,null,null,null,{"$f":"IF(COUNT(I22:M22)=3,SUM(I22:K22),IF(COUNT(I22:M22)=5,SUM(I22:M22)-MAX(I22:M22)-MIN(I22:M22),\"\"))","v":""},{"$f":"IF(COUNT(I22:M22)=3,SUM(I22:K22)*H22,IF(COUNT(I22:M22)=5,(SUM(I22:M22)-MAX(I22:M22)-MIN(I22:M22))*H22,\"\"))","v":""}," ",null,{"$f":"IF(P22=\"V\",H22,0)","v":0},{"$f":"IF(LEN($B22)>1,VALUE(LEFT($AG22)),0)","v":0},{"$f":"IF(LEN($B22)>1,VALUE(LEFT($AG22)),0)","v":0},{"$f":"IF(LEN($B22)>1,VALUE(LEFT($AG22)),0)","v":0},{"$f":"IF(LEN($B22)>1,VALUE(LEFT($AG22)),0)","v":0},{"$f":"IF(LEN($B22)>1,VALUE(LEFT($AG22)),0)","v":0},"2 V & 1 O in semis",null,{"$f":"IF(AND(LEN($B22)>1,$P22=\"O\"),VALUE(LEFT($AG22)),0)","v":0},{"$f":"IF(AND(LEN($B22)>1,$P22=\"O\"),VALUE(LEFT($AG22)),0)","v":0},{"$f":"IF(AND(LEN($B22)>1,$P22=\"O\"),VALUE(LEFT($AG22)),0)","v":0},{"$f":"IF(AND(LEN($B22)>1,$P22=\"O\"),VALUE(LEFT($AG22)),0)","v":0},{"$f":"IF(AND(LEN($B22)>1,$P22=\"O\"),VALUE(LEFT($AG22)),0)","v":0},null,{"$f":"AA22","v":0},{"$f":"IF(LEN(B22)>0,VALUE(IF(LEFT(B22,1)=\"5\",IF(LEN(B22)=4,B22,LEFT(B22,4)),IF(LEN(B22)=3,B22,LEFT(B22,3)))),\"\")","v":""},null,{"$f":"IF(AND(LEN($B22)>1,$P22=\"V\"),VALUE(LEFT($AG22)),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(H23:L23)=3,SUM(H23:J23)*G23,IF(COUNT(H23:L23)=5,(SUM(H23:L23)-MAX(H23:L23)-MIN(H23:L23))*G23,\"\"))","v":""},{"$f":"IF(ISNUMBER(O22),O20+O22,\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"COUNTIF($P$22:$P$27,\"=V\")","v":0},{"$f":"COUNTIF($P$22:$P$27,\"=O\")","v":0},null,null,null,null,null,null,{"$f":"IF(AF22>0,IF(OR(AF22=$AF$13,AF22=$AF$15,AF22=$AF$17,AF22=$AF$19,AF22=$AF$11,AF22=$AF$24,AF22=$AF$26),1,0),0)","v":0},{"$f":"IF(LEN(B22)>0,IF(LEFT(B22,1)=\"5\",IF(LEN(B22)=4,\"\",RIGHT(B22,1)),IF(LEN(B22)=3,\"\",RIGHT(B22,1))),\"\")","v":""},{"$f":"IF(AG23=\"A\",\"S\",IF(AG23=\"B\",\"P\",IF(AG23=\"C\",\"T\",IF(AG23=\"D\",\"F\",0))))","v":0}]
[7,null,{"$f":"IF(ISNUMBER(AG24),VLOOKUP(AG24,DiveTable,2,0),\"\")","v":""},null,null,null,{"$f":"IF(AH25=0,\"\",AH25)","v":""},{"$f":"IF(AND(ISNUMBER(AG24),ISTEXT(G24)),VLOOKUP(AG24,DiveTable,IF(OR(G24=\"T\",G24=\"C\"),3,IF(OR(G24=\"P\",G24=\"B\"),4,IF(OR(G24=\"S\",G24=\"A\"),5,IF(OR(G24=\"F\",G24=\"D\"),6,#N/A)))),0),\"\")","v":""},null,null,null,null,null,{"$f":"IF(COUNT(I24:M24)=3,SUM(I24:K24),IF(COUNT(I24:M24)=5,SUM(I24:M24)-MAX(I24:M24)-MIN(I24:M24),\"\"))","v":""},{"$f":"IF(COUNT(I24:M24)=3,SUM(I24:K24)*H24,IF(COUNT(I24:M24)=5,(SUM(I24:M24)-MAX(I24:M24)-MIN(I24:M24))*H24,\"\"))","v":""}," ",null,{"$f":"IF(P24=\"V\",H24,0)","v":0},{"$f":"IF(LEN($B24)>1,VALUE(LEFT($AG24)),0)","v":0},{"$f":"IF(LEN($B24)>1,VALUE(LEFT($AG24)),0)","v":0},{"$f":"IF(LEN($B24)>1,VALUE(LEFT($AG24)),0)","v":0},{"$f":"IF(LEN($B24)>1,VALUE(LEFT($AG24)),0)","v":0},{"$f":"IF(LEN($B24)>1,VALUE(LEFT($AG24)),0)","v":0},{"$f":"IF(AND(X23=2,Y23=1),\"\",\"Need 2 Voluntary & 1 Optional Dive in Semis\")","v":"Need 2 Voluntary & 1 Optional Dive in Semis"},null,{"$f":"IF(AND(LEN($B24)>1,$P24=\"O\"),VALUE(LEFT($AG24)),0)","v":0},{"$f":"IF(AND(LEN($B24)>1,$P24=\"O\"),VALUE(LEFT($AG24)),0)","v":0},{"$f":"IF(AND(LEN($B24)>1,$P24=\"O\"),VALUE(LEFT($AG24)),0)","v":0},{"$f":"IF(AND(LEN($B24)>1,$P24=\"O\"),VALUE(LEFT($AG24)),0)","v":0},{"$f":"IF(AND(LEN($B24)>1,$P24=\"O\"),VALUE(LEFT($AG24)),0)","v":0},null,{"$f":"AA24","v":0},{"$f":"IF(LEN(B24)>0,VALUE(IF(LEFT(B24,1)=\"5\",IF(LEN(B24)=4,B24,LEFT(B24,4)),IF(LEN(B24)=3,B24,LEFT(B24,3)))),\"\")","v":""},null,{"$f":"IF(AND(LEN($B24)>1,$P24=\"V\"),VALUE(LEFT($AG24)),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(H25:L25)=3,SUM(H25:J25)*G25,IF(COUNT(H25:L25)=5,(SUM(H25:L25)-MAX(H25:L25)-MIN(H25:L25))*G25,\"\"))","v":""},{"$f":"IF(ISNUMBER(O24),O23+O24,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AF24>0,IF(OR(AF24=$AF$13,AF24=$AF$15,AF24=$AF$17,AF24=$AF$19,AF24=$AF$22,AF24=$AF$11,AF24=$AF$26),1,0),0)","v":0},{"$f":"IF(LEN(B24)>0,IF(LEFT(B24,1)=\"5\",IF(LEN(B24)=4,\"\",RIGHT(B24,1)),IF(LEN(B24)=3,\"\",RIGHT(B24,1))),\"\")","v":""},{"$f":"IF(AG25=\"A\",\"S\",IF(AG25=\"B\",\"P\",IF(AG25=\"C\",\"T\",IF(AG25=\"D\",\"F\",0))))","v":0}]
[8,null,{"$f":"IF(ISNUMBER(AG26),VLOOKUP(AG26,DiveTable,2,0),\"\")","v":""},null,null,null,{"$f":"IF(AH27=0,\"\",AH27)","v":""},{"$f":"IF(AND(ISNUMBER(AG26),ISTEXT(G26)),VLOOKUP(AG26,DiveTable,IF(OR(G26=\"T\",G26=\"C\"),3,IF(OR(G26=\"P\",G26=\"B\"),4,IF(OR(G26=\"S\",G26=\"A\"),5,IF(OR(G26=\"F\",G26=\"D\"),6,#N/A)))),0),\"\")","v":""},null,null,null,null,null,{"$f":"IF(COUNT(I26:M26)=3,SUM(I26:K26),IF(COUNT(I26:M26)=5,SUM(I26:M26)-MAX(I26:M26)-MIN(I26:M26),\"\"))","v":""},{"$f":"IF(COUNT(I26:M26)=3,SUM(I26:K26)*H26,IF(COUNT(I26:M26)=5,(SUM(I26:M26)-MAX(I26:M26)-MIN(I26:M26))*H26,\"\"))","v":""}," ",null,{"$f":"IF(P26=\"V\",H26,0)","v":0},{"$f":"IF(LEN($B26)>1,VALUE(LEFT($AG26)),0)","v":0},{"$f":"IF(LEN($B26)>1,VALUE(LEFT($AG26)),0)","v":0},{"$f":"IF(LEN($B26)>1,VALUE(LEFT($AG26)),0)","v":0},{"$f":"IF(LEN($B26)>1,VALUE(LEFT($AG26)),0)","v":0},{"$f":"IF(LEN($B26)>1,VALUE(LEFT($AG26)),0)","v":0},null,null,{"$f":"IF(AND(LEN($B26)>1,$P26=\"O\"),VALUE(LEFT($AG26)),0)","v":0},{"$f":"IF(AND(LEN($B26)>1,$P26=\"O\"),VALUE(LEFT($AG26)),0)","v":0},{"$f":"IF(AND(LEN($B26)>1,$P26=\"O\"),VALUE(LEFT($AG26)),0)","v":0},{"$f":"IF(AND(LEN($B26)>1,$P26=\"O\"),VALUE(LEFT($AG26)),0)","v":0},{"$f":"IF(AND(LEN($B26)>1,$P26=\"O\"),VALUE(LEFT($AG26)),0)","v":0},null,{"$f":"AA26","v":0},{"$f":"IF(LEN(B26)>0,VALUE(IF(LEFT(B26,1)=\"5\",IF(LEN(B26)=4,B26,LEFT(B26,4)),IF(LEN(B26)=3,B26,LEFT(B26,3)))),\"\")","v":""},null,{"$f":"IF(AND(LEN($B26)>1,$P26=\"V\"),VALUE(LEFT($AG26)),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(H27:L27)=3,SUM(H27:J27)*G27,IF(COUNT(H27:L27)=5,(SUM(H27:L27)-MAX(H27:L27)-MIN(H27:L27))*G27,\"\"))","v":""},{"$f":"IF(ISNUMBER(O26),O25+O26,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AF26>0,IF(OR(AF26=$AF$13,AF26=$AF$15,AF26=$AF$17,AF26=$AF$19,AF26=$AF$22,AF26=$AF$24,AF26=$AF$11),1,0),0)","v":0},{"$f":"IF(LEN(B26)>0,IF(LEFT(B26,1)=\"5\",IF(LEN(B26)=4,\"\",RIGHT(B26,1)),IF(LEN(B26)=3,\"\",RIGHT(B26,1))),\"\")","v":""},{"$f":"IF(AG27=\"A\",\"S\",IF(AG27=\"B\",\"P\",IF(AG27=\"C\",\"T\",IF(AG27=\"D\",\"F\",0))))","v":0}]
["FINALS (Dives 9,10,11 - 1 Vol. & 2 Opt. in any order)"]
[9,null,{"$f":"IF(ISNUMBER(AG29),VLOOKUP(AG29,DiveTable,2,0),\"\")","v":""},null,null,null,{"$f":"IF(AH30=0,\"\",AH30)","v":""},{"$f":"IF(AND(ISNUMBER(AG29),ISTEXT(G29)),VLOOKUP(AG29,DiveTable,IF(OR(G29=\"T\",G29=\"C\"),3,IF(OR(G29=\"P\",G29=\"B\"),4,IF(OR(G29=\"S\",G29=\"A\"),5,IF(OR(G29=\"F\",G29=\"D\"),6,#N/A)))),0),\"\")","v":""},null,null,null,null,null,{"$f":"IF(COUNT(I29:M29)=3,SUM(I29:K29),IF(COUNT(I29:M29)=5,SUM(I29:M29)-MAX(I29:M29)-MIN(I29:M29),\"\"))","v":""},{"$f":"IF(COUNT(I29:M29)=3,SUM(I29:K29)*H29,IF(COUNT(I29:M29)=5,(SUM(I29:M29)-MAX(I29:M29)-MIN(I29:M29))*H29,\"\"))","v":""}," ",null,{"$f":"IF(P29=\"V\",H29,0)","v":0},{"$f":"IF(OR(S11=1,S13=1,S15=1,S17=1,S19=1,S22=1,S24=1,S26=1),1,0)","v":0},{"$f":"IF(OR(T11=2,T13=2,T15=2,T17=2,T19=2,T22=2,T24=2,T26=2),1,0)","v":0},{"$f":"IF(OR(U11=3,U13=3,U15=3,U17=3,U19=3,U22=3,U24=3,U26=3),1,0)","v":0},{"$f":"IF(OR(V11=4,V13=4,V15=4,V17=4,V19=4,V22=4,V24=4,V26=4),1,0)","v":0},{"$f":"IF(OR(W11=5,W13=5,W15=5,W17=5,W19=5,W22=5,W24=5,W26=5),1,0)","v":0},"1 V & 2 O in finals",null,{"$f":"IF(AND(LEN($B29)>1,$P29=\"O\"),VALUE(LEFT($AG29)),0)","v":0},{"$f":"IF(AND(LEN($B29)>1,$P29=\"O\"),VALUE(LEFT($AG29)),0)","v":0},{"$f":"IF(AND(LEN($B29)>1,$P29=\"O\"),VALUE(LEFT($AG29)),0)","v":0},{"$f":"IF(AND(LEN($B29)>1,$P29=\"O\"),VALUE(LEFT($AG29)),0)","v":0},{"$f":"IF(AND(LEN($B29)>1,$P29=\"O\"),VALUE(LEFT($AG29)),0)","v":0},null,{"$f":"SUM(AF12,AF14,AF16,AF18,AF20,AF23,AF25,AF27)","v":0},{"$f":"IF(LEN(B29)>0,VALUE(IF(LEFT(B29,1)=\"5\",IF(LEN(B29)=4,B29,LEFT(B29,4)),IF(LEN(B29)=3,B29,LEFT(B29,3)))),\"\")","v":""},null,{"$f":"IF(AND(LEN($B29)>1,$P29=\"V\"),VALUE(LEFT($AG29)),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(H30:L30)=3,SUM(H30:J30)*G30,IF(COUNT(H30:L30)=5,(SUM(H30:L30)-MAX(H30:L30)-MIN(H30:L30))*G30,\"\"))","v":""},{"$f":"IF(ISNUMBER(O29),O27+O29,\"\")","v":""},null,null,null,{"$f":"SUM(S29:W29)","v":0},null,null,null,null,{"$f":"COUNTIF($P$29:$P$34,\"=V\")","v":0},{"$f":"COUNTIF($P$29:$P$34,\"=O\")","v":0},null,null,null,null,null,null,null,{"$f":"IF(LEN(B29)>0,IF(LEFT(B29,1)=\"5\",IF(LEN(B29)=4,\"\",RIGHT(B29,1)),IF(LEN(B29)=3,\"\",RIGHT(B29,1))),\"\")","v":""},{"$f":"IF(AG30=\"A\",\"S\",IF(AG30=\"B\",\"P\",IF(AG30=\"C\",\"T\",IF(AG30=\"D\",\"F\",0))))","v":0}]
[10,null,{"$f":"IF(ISNUMBER(AG31),VLOOKUP(AG31,DiveTable,2,0),\"\")","v":""},null,null,null,{"$f":"IF(AH32=0,\"\",AH32)","v":""},{"$f":"IF(AND(ISNUMBER(AG31),ISTEXT(G31)),VLOOKUP(AG31,DiveTable,IF(OR(G31=\"T\",G31=\"C\"),3,IF(OR(G31=\"P\",G31=\"B\"),4,IF(OR(G31=\"S\",G31=\"A\"),5,IF(OR(G31=\"F\",G31=\"D\"),6,#N/A)))),0),\"\")","v":""},null,null,null,null,null,{"$f":"IF(COUNT(I31:M31)=3,SUM(I31:K31),IF(COUNT(I31:M31)=5,SUM(I31:M31)-MAX(I31:M31)-MIN(I31:M31),\"\"))","v":""},{"$f":"IF(COUNT(I31:M31)=3,SUM(I31:K31)*H31,IF(COUNT(I31:M31)=5,(SUM(I31:M31)-MAX(I31:M31)-MIN(I31:M31))*H31,\"\"))","v":""}," ",null,{"$f":"IF(P31=\"V\",H31,0)","v":0},null,null,null,null,null,{"$f":"IF(AND(X30=1,Y30=2),\"\",\"Need 1 Voluntary & 2 Optional Dive in Finals\")","v":"Need 1 Voluntary & 2 Optional Dive in Finals"},null,{"$f":"IF(AND(LEN($B31)>1,$P31=\"O\"),VALUE(LEFT($AG31)),0)","v":0},{"$f":"IF(AND(LEN($B31)>1,$P31=\"O\"),VALUE(LEFT($AG31)),0)","v":0},{"$f":"IF(AND(LEN($B31)>1,$P31=\"O\"),VALUE(LEFT($AG31)),0)","v":0},{"$f":"IF(AND(LEN($B31)>1,$P31=\"O\"),VALUE(LEFT($AG31)),0)","v":0},{"$f":"IF(AND(LEN($B31)>1,$P31=\"O\"),VALUE(LEFT($AG31)),0)","v":0},null,null,{"$f":"IF(LEN(B31)>0,VALUE(IF(LEFT(B31,1)=\"5\",IF(LEN(B31)=4,B31,LEFT(B31,4)),IF(LEN(B31)=3,B31,LEFT(B31,3)))),\"\")","v":""},null,{"$f":"IF(AND(LEN($B31)>1,$P31=\"V\"),VALUE(LEFT($AG31)),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(H32:L32)=3,SUM(H32:J32)*G32,IF(COUNT(H32:L32)=5,(SUM(H32:L32)-MAX(H32:L32)-MIN(H32:L32))*G32,\"\"))","v":""},{"$f":"IF(ISNUMBER(O31),O30+O31,\"\")","v":""},null,null,null,null,null,null,null,null,"Total V or O entries",null,null,null,null,null,null,null,null,{"$f":"IF(LEN(B31)>0,IF(LEFT(B31,1)=\"5\",IF(LEN(B31)=4,\"\",RIGHT(B31,1)),IF(LEN(B31)=3,\"\",RIGHT(B31,1))),\"\")","v":""},{"$f":"IF(AG32=\"A\",\"S\",IF(AG32=\"B\",\"P\",IF(AG32=\"C\",\"T\",IF(AG32=\"D\",\"F\",0))))","v":0}]
[11,null,{"$f":"IF(ISNUMBER(AG33),VLOOKUP(AG33,DiveTable,2,0),\"\")","v":""},null,null,null,{"$f":"IF(AH34=0,\"\",AH34)","v":""},{"$f":"IF(AND(ISNUMBER(AG33),ISTEXT(G33)),VLOOKUP(AG33,DiveTable,IF(OR(G33=\"T\",G33=\"C\"),3,IF(OR(G33=\"P\",G33=\"B\"),4,IF(OR(G33=\"S\",G33=\"A\"),5,IF(OR(G33=\"F\",G33=\"D\"),6,#N/A)))),0),\"\")","v":""},null,null,null,null,null,{"$f":"IF(COUNT(I33:M33)=3,SUM(I33:K33),IF(COUNT(I33:M33)=5,SUM(I33:M33)-MAX(I33:M33)-MIN(I33:M33),\"\"))","v":""},{"$f":"IF(COUNT(I33:M33)=3,SUM(I33:K33)*H33,IF(COUNT(I33:M33)=5,(SUM(I33:M33)-MAX(I33:M33)-MIN(I33:M33))*H33,\"\"))","v":""}," ",null,{"$f":"IF(P33=\"V\",H33,0)","v":0},null,null,null,null,null,{"$f":"SUM(X11:Y11,X23:Y23,X30:Y30)","v":0},null,{"$f":"IF(AND(LEN($B33)>1,$P33=\"O\"),VALUE(LEFT($AG33)),0)","v":0},{"$f":"IF(AND(LEN($B33)>1,$P33=\"O\"),VALUE(LEFT($AG33)),0)","v":0},{"$f":"IF(AND(LEN($B33)>1,$P33=\"O\"),VALUE(LEFT($AG33)),0)","v":0},{"$f":"IF(AND(LEN($B33)>1,$P33=\"O\"),VALUE(LEFT($AG33)),0)","v":0},{"$f":"IF(AND(LEN($B33)>1,$P33=\"O\"),VALUE(LEFT($AG33)),0)","v":0},null,null,{"$f":"IF(LEN(B33)>0,VALUE(IF(LEFT(B33,1)=\"5\",IF(LEN(B33)=4,B33,LEFT(B33,4)),IF(LEN(B33)=3,B33,LEFT(B33,3)))),\"\")","v":""},null,{"$f":"IF(AND(LEN($B33)>1,$P33=\"V\"),VALUE(LEFT($AG33)),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(H34:L34)=3,SUM(H34:J34)*G34,IF(COUNT(H34:L34)=5,(SUM(H34:L34)-MAX(H34:L34)-MIN(H34:L34))*G34,\"\"))","v":""},{"$f":"IF(ISNUMBER(O33),O32+O33,\"\")","v":""},null,null,{"$f":"SUM(R11:R33)","v":0},null,null,null,null,null,null,null,{"$f":"IF(OR(Z11=1,Z13=1,Z15=1,Z17=1,Z19=1,Z22=1,Z24=1,Z26=1,Z29=1,Z31=1,Z33=1),1,0)","v":0},{"$f":"IF(OR(AA11=2,AA13=2,AA15=2,AA17=2,AA19=2,AA22=2,AA24=2,AA26=2,AA29=2,AA31=2,AA33=2),1,0)","v":0},{"$f":"IF(OR(AB11=3,AB13=3,AB15=3,AB17=3,AB19=3,AB22=3,AB24=3,AB26=3,AB29=3,AB31=3,AB33=3),1,0)","v":0},{"$f":"IF(OR(AC11=4,AC13=4,AC15=4,AC17=4,AC19=4,AC22=4,AC24=4,AC26=4,AC29=4,AC31=4,AC33=4),1,0)","v":0},{"$f":"IF(OR(AD11=5,AD13=5,AD15=5,AD17=5,AD19=5,AD22=5,AD24=5,AD26=5,AD29=5,AD31=5,AD33=5),1,0)","v":0},null,null,{"$f":"IF(LEN(B33)>0,IF(LEFT(B33,1)=\"5\",IF(LEN(B33)=4,\"\",RIGHT(B33,1)),IF(LEN(B33)=3,\"\",RIGHT(B33,1))),\"\")","v":""},{"$f":"IF(AG34=\"A\",\"S\",IF(AG34=\"B\",\"P\",IF(AG34=\"C\",\"T\",IF(AG34=\"D\",\"F\",0))))","v":0}]
[null,null,{"$f":"R50","v":"Enter Name"},null,null,null,null,{"$f":"SUMIF(P11:P34,\"V\",H11:H34)","v":0},null,null,null,null,null,"TOTAL POINTS AWARDED  ",{"$f":"IF(ISNUMBER(O34),O34,\"\")","v":""},null,null,{"$f":"IF(LEN(S35)>1,1,0)","v":0},{"$f":"IF(ISNA(C11),\"Illegal Dive No. 1\",IF(ISNA(C13),\"Illegal Dive No. 2\",IF(ISNA(C15),\"Illegal Dive No. 3\",IF(ISNA(C17),\"Illegal Dive No. 4\",IF(ISNA(C19),\"Illegal Dive No. 5\",IF(ISNA(C22),\"Illegal Dive No. 6\",IF(ISNA(C24),\"Illegal Dive No. 7\",\"\")))))))","v":""},null,null,null,null,null,null,{"$f":"SUM(Z34:AD34)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(AI11:AI34,1)=1,0,1)+IF(COUNTIF(AI11:AI34,2)=1,0,1)+IF(COUNTIF(AI11:AI34,3)=1,0,1)+IF(COUNTIF(AI11:AI34,4)=1,0,1)+IF(COUNTIF(AI11:AI34,5)=1,0,1)","v":5}]
[null,null,null,null,null,null,null,null,null,null,"Signatures",null,null,null,null,null,null,{"$f":"IF(LEN(S36)>1,1,0)","v":0},{"$f":"IF(ISNA(C26),\"Illegal Dive No. 8\",IF(ISNA(C29),\"Illegal Dive No. 9\",IF(ISNA(C31),\"Illegal Dive No. 10\",IF(ISNA(C33),\"Illegal Dive No. 11\",\"\"))))","v":""}]
[null,"T(C) = Tuck, P(B) = Pike, S(A) = Straight, F(D) = Free\nDual Meets: List voluntary dive first. Spaces 2-6 for optional dives\nCHAMPIONSHIP & OTHER 11-DIVE MEETS: List dives in each section as per instructions",null,null,null,null,null,null,null,null,"Diver",null,null,null,null,null,null,{"$f":"IF(AND(LEN(S37)>1,COUNT(AG11,AG13,AG15,AG17,AG19,AG22,AG24,AG26,AG29,AG31,AG33)=11),1,0)","v":0},{"$f":"IF(OR(AG11=AG13,AG11=AG15,AG11=AG17,AG11=AG19,AG11=AG22,AG11=AG24,AG11=AG26,AG11=AG29,AG11=AG31,AG11=AG33,AG13=AG15,AG13=AG17,AG13=AG19,AG13=AG22,AG13=AG24,AG13=AG26,AG13=AG29,AG13=AG31,AG13=AG33,AG15=AG17,AG15=AG19,AG15=AG22,AG15=AG24,AG15=AG26,AG15=AG29,AG15=AG31,AG15=AG33),\"Repeated Dive No.\",\"\")","v":"Repeated Dive No."}]
[null,null,null,null,null,null,null,null,null,null,"Coach",null,null,null,null,null,null,{"$f":"IF(AND(LEN(S38)>1,COUNT(AG11,AG13,AG15,AG17,AG19,AG22,AG24,AG26,AG29,AG31,AG33)=11),1,0)","v":0},{"$f":"IF(OR(AG17=AG19,AG17=AG22,AG17=AG24,AG17=AG26,AG17=AG29,AG17=AG31,AG17=AG33,AG19=AG22,AG19=AG24,AG19=AG26,AG19=AG29,AG19=AG31,AG19=AG33,AG22=AG24,AG22=AG26,AG22=AG29,AG22=AG31,AG22=AG33,AG24=AG26,AG24=AG29,AG24=AG31,AG24=AG33,AG26=AG29,AG26=AG31,AG26=AG33),\"Repeated Dive No.\",\"\")","v":"Repeated Dive No."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'NDHSAA 6 Dive'!X11","v":"2022-08-15"}]
[{"$f":"'NDHSAA 6 Dive'!A39","v":"gvp 7/30/22"},null,null,null,null,null,null,null,null,null,"Referee",null,null,null,null,null,null,{"$f":"IF(AND(LEN(S39)>1,COUNT(AG11,AG13,AG15,AG17,AG19,AG22,AG24,AG26,AG29,AG31,AG33)=11),1,0)","v":0},{"$f":"IF(OR(AG29=AG31,AG29=AG33,AG31=AG33),\"Repeated Dive No.\",\"\")","v":"Repeated Dive No."},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(K5),1,0)","v":0},null,{"$f":"'NDHSAA 6 Dive'!Y31","v":"2023-03-11"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(LEN(S40)>1,COUNT(AG11,AG13,AG15,AG17,AG19,AG22,AG24,AG26,AG29,AG31,AG33)=11),1,0)","v":0},{"$f":"IF(ISNA(H11),\"Illegal Position for Dive 1\",IF(ISNA(H13),\"Illegal Position for Dive 2\",IF(ISNA(H15),\"Illegal Position for Dive 3\",IF(ISNA(H17),\"Illegal Position for Dive 4\",IF(ISNA(H19),\"Illegal Position for Dive 5\",IF(ISNA(H22),\"Illegal Position for Dive 6\",\"\"))))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,"Name Entered:",{"$f":"IF(LEN(B4)>0,0,1)","v":1},"Name"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(LEN(S41)>1,COUNT(AG11,AG13,AG15,AG17,AG19,AG22,AG24,AG26,AG29,AG31,AG33)=11),1,0)","v":0},{"$f":"IF(ISNA(H24),\"Illegal Position for Dive 7\",IF(ISNA(H26),\"Illegal Position for Dive 8\",IF(ISNA(H29),\"Illegal Position for Dive 9\",IF(ISNA(H31),\"Illegal Position for Dive 10\",IF(ISNA(H33),\"Illegal Position for Dive 11\",\"\")))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,"School Entered:",{"$f":"IF(LEN(H4)>0,0,1)","v":1},"School"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(LEN(S42)>1,COUNT(AG11,AG13,AG15,AG17,AG19,AG22,AG24,AG26,AG29,AG31,AG33)=11),1,0)","v":0},{"$f":"IF(X33<11,\"Enter V or O in column P to specify Dives as Voluntary or Optional\",\"\")","v":"Enter V or O in column P to specify Dives as Voluntary or Optional"},null,null,null,null,null,null,null,null,null,null,null,null,"Meet Entered:",{"$f":"IF(LEN(B5)>0,0,1)","v":1},"Meet"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(LEN(S43)>1,COUNT(AG11,AG13,AG15,AG17,AG19,AG22,AG24,AG26,AG29,AG31,AG33)=11),1,0)","v":0},{"$f":"IF(S30<5,\"Need all 5 Groups in 1st 8 Rounds\",IF(Z35<5,\"Need all 5 Groups in 6 Optional Dives\",\"\"))","v":"Need all 5 Groups in 1st 8 Rounds"},null,null,null,null,null,null,null,null,null,null,null,null,"Site Entered:",{"$f":"IF(LEN(E5)>0,0,1)","v":1},"Site"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(LEN(S44)>1,COUNT(AG11,AG13,AG15,AG17,AG19,AG22,AG24,AG26,AG29,AG31,AG33)=11),1,0)","v":0},{"$f":"IF(LEN(X12)>1,X12,IF(LEN(X24)>1,X24,IF(LEN(X31)>1,X31,\"\")))","v":"Need 2 Voluntary & 3 Optional Dives in Prelims"},null,null,null,null,null,null,null,null,null,null,null,null,"Date Entered:",{"$f":"IF(AG39,0,1)","v":1},"Valid Meet Date"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(LEN(S45)>1,COUNT(AG11,AG13,AG15,AG17,AG19,AG22,AG24,AG26,AG29,AG31,AG33)=11),1,0)","v":0},{"$f":"IF(R34>9,\"Sum of Voluntary DD > 9.0\",IF(AF29>0,\">1 Optional Dive from same Group through Semis\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,"Grade Entered:",{"$f":"IF(LEN(B6)>0,0,1)","v":1},"Grade"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(LEN(S46)>1,COUNT(AG11,AG13,AG15,AG17,AG19,AG22,AG24,AG26,AG29,AG31,AG33)=11),1,0)","v":0},{"$f":"IF(AI35>0,\"Need 5 Voluntary Dives, 1 from each Group\",\"\")","v":"Need 5 Voluntary Dives, 1 from each Group"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(AG40:AG45)","v":1},{"$f":"VLOOKUP(AG46,AG40:AH45,2,0)","v":"Name"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(LEN(S47)>1,COUNT(AG11,AG13,AG15,AG17,AG19,AG22,AG24,AG26,AG29,AG31,AG33)=11),1,0)","v":0},{"$f":"IF(AND(G11=AH12,G13=AH14,G15=AH16,G17=AH18,G19=AH20,G22=AH23,G24=AH25,G26=AH27,G29=AH30,G31=AH32,G33=AH34),\"\",\"Dive Number does not match Dive Position\")","v":"Dive Number does not match Dive Position"},null,null,null,null,null,null,null,null,null,null,null,null,"Consideration",250]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(LEN(S48)>1,1,0)","v":1},{"$f":"IF(AG46,\"Enter \"&AH46,\"\")","v":"Enter Name"},null,null,null,null,null,null,null,null,null,null,null,null,"Qualifying",275]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(LEN(S49)>1,1,0)","v":0},{"$f":"IF(COUNTA(B11,B13,B15,B17,B19,B22,B24,B26,B29,B31,B33)=6,\"If only entering 6 Dives, please use 6 Dive Sheet\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(R35:R49)>0,VLOOKUP(1,R35:S49,2,0),\"\")","v":"Enter Name"}]

{"sheet":"11 Dive 7 Judge","index":3,"n_rows":50,"n_cols":37,"rows_kept":50,"cut":false,"hidden":false,"merged":[[36,1,37,6],[32,11,33,11],[32,12,33,12],[32,13,33,13],[32,14,33,14],[32,15,33,15],[32,17,33,17],[30,15,31,15],[30,17,31,17],[30,11,31,11],[30,12,31,12],[30,13,31,13],[30,14,31,14],[32,0,33,0],[32,1,33,1],[32,2,33,5],[32,6,33,6],[32,7,33,7],[32,8,33,8],[32,9,33,9],[32,10,33,10],[30,9,31,9],[30,10,31,10],[30,0,31,0],[30,1,31,1],[30,2,31,5],[30,6,31,6],[30,7,31,7],[30,8,31,8],[28,11,29,11],[28,12,29,12],[28,13,29,13],[28,14,29,14],[28,15,29,15],[28,17,29,17],[25,15,26,15],[25,17,26,17],[28,0,29,0],[28,1,29,1],[28,2,29,5],[28,6,29,6],[28,7,29,7],[28,8,29,8],[28,9,29,9],[28,10,29,10],[25,9,26,9],[25,10,26,10],[25,11,26,11],[25,12,26,12],[25,13,26,13],[25,14,26,14],[25,0,26,0],[25,1,26,1],[25,2,26,5],[25,6,26,6],[25,7,26,7],[25,8,26,8],[23,11,24,11],[23,12,24,12],[23,13,24,13],[23,14,24,14],[23,15,24,15],[23,17,24,17],[21,15,22,15],[21,17,22,17],[23,0,24,0],[23,1,24,1],[23,2,24,5],[23,6,24,6],[23,7,24,7],[23,8,24,8],[23,9,24,9],[23,10,24,10],[21,9,22,9],[21,10,22,10],[21,11,22,11],[21,12,22,12],[21,13,22,13],[21,14,22,14],[21,0,22,0],[21,1,22,1],[21,2,22,5],[21,6,22,6],[21,7,22,7],[21,8,22,8],[18,11,19,11],[18,12,19,12],[18,13,19,13],[18,14,19,14],[18,15,19,15],[18,17,19,17],[16,15,17,15],[16,17,17,17],[18,0,19,0],[18,1,19,1],[18,2,19,5],[18,6,19,6],[18,7,19,7],[18,8,19,8],[18,9,19,9],[18,10,19,10],[16,9,17,9],[16,10,17,10],[16,11,17,11],[16,12,17,12],[16,13,17,13],[16,14,17,14],[16,0,17,0],[16,1,17,1],[16,2,17,5],[16,6,17,6],[16,7,17,7],[16,8,17,8],[14,11,15,11],[14,12,15,12],[14,13,15,13],[14,14,15,14],[14,15,15,15],[14,17,15,17],[12,15,13,15],[12,17,13,17],[14,0,15,0],[14,1,15,1],[14,2,15,5],[14,6,15,6],[14,7,15,7],[14,8,15,8],[14,9,15,9],[14,10,15,10],[12,9,13,9],[12,10,13,10],[12,11,13,11],[12,12,13,12],[12,13,13,13],[12,14,13,14],[12,0,13,0],[12,1,13,1],[12,2,13,5],[12,6,13,6],[12,7,13,7],[12,8,13,8],[10,11,11,11],[10,12,11,12],[10,13,11,13],[10,14,11,14],[10,15,11,15],[10,17,11,17],[8,16,9,16],[10,0,11,0],[10,1,11,1],[10,2,11,5],[10,6,11,6],[10,7,11,7],[10,8,11,8],[10,9,11,9],[10,10,11,10],[8,0,9,0],[8,1,9,1],[8,2,9,5],[8,6,9,6],[8,7,9,7],[8,15,9,15],[4,1,4,3],[4,5,4,8],[4,11,4,13],[4,15,5,15],[4,16,5,16],[5,1,5,3],[0,0,1,13],[0,15,1,15],[0,16,1,16],[2,15,3,15],[2,16,3,16],[3,1,3,5],[3,9,3,13]]}
["OFFICIAL NDHSAA DIVING SCORESHEET",null,null,null,null,null,null,null,null,null,null,null,null,null,null," Diving\n Order",null,null,null,"Hide these columns"]
[]
[null,null,null,null,null,null,{"$f":"IF(TODAY()>$O$3,\"Scoresheet outdated.  Download new scoresheet from ndhsaa.com.\",\"\")","v":""},null,null,null,null,null,null,null,{"$f":"'NDHSAA 11 Dive'!M3","v":"2023-05-01"}," Total\n Points\n Awarded"]
["Name",null,null,null,null,null,null,null,"School"]
["Meet",null,null,null,"Site",null,null,null,null,null,"Date",null,null,null,null," Order\n of\n Finish"]
["Grade",null,null,null,"Varsity",null,"J. V."]
[]
["PRELIMS (Dives1-5: 2 Vol.  3 Opt. in any order)"]
["Dive\nOrder","Dive\nNumber","Dive Description",null,null,null," Dive\nPosition ","Deg.\nOf\nDiff.","JUDGES SCORES",null,null,null,null,null,null,"Judges\nTotal","Points\nAwarded"," Voluntary ",null,"Voluntary",null,null,null,null,null,null,null,null,null,null,null,null,null,">1 Optional from same"]
[null,null,null,null,null,null,null,null,1,2,3,4,5,6,7,null,null," Optional ",null,"DD < 9.0","5 Groups in 1st 8 Rounds",null,null,null,null,"2 V & 3 O in prelims",null,"6 Optionals from 5 Groups",null,null,null,null,null,"Group through semis","Dive#","Position","5 Voluntary from each group"]
[1,null,{"$f":"IF(ISNUMBER(AI11),VLOOKUP(AI11,DiveTable,2,0),\"\")","v":""},null,null,null,{"$f":"AJ12","v":0},{"$f":"IF(AND(ISNUMBER(AI11),ISTEXT(G11)),VLOOKUP(AI11,DiveTable,IF(OR(G11=\"T\",G11=\"C\"),3,IF(OR(G11=\"P\",G11=\"B\"),4,IF(OR(G11=\"S\",G11=\"A\"),5,IF(OR(G11=\"F\",G11=\"D\"),6,#N/A)))),0),\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(COUNT(I11:O11)=2,SUM(I11:O11)*1.5,IF(COUNT(I11:O11)=3,SUM(I11:O11),IF(COUNT(I11:O11)=5,SUM(I11:O11)-MAX(I11:O11)-MIN(I11:O11),IF(COUNT(I11:O11)=7,SUM($I11:$O12)-LARGE($I11:$O12,1)-LARGE($I11:$O12,2)-SMALL($I11:$O12,1)-SMALL($I11:$O12,2),\"\"))))","v":""},null,null,null,{"$f":"IF(R11=\"V\",H11,0)","v":0},{"$f":"IF(LEN($B11)>1,VALUE(LEFT($AI11)),0)","v":0},{"$f":"IF(LEN($B11)>1,VALUE(LEFT($AI11)),0)","v":0},{"$f":"IF(LEN($B11)>1,VALUE(LEFT($AI11)),0)","v":0},{"$f":"IF(LEN($B11)>1,VALUE(LEFT($AI11)),0)","v":0},{"$f":"IF(LEN($B11)>1,VALUE(LEFT($AI11)),0)","v":0},{"$f":"COUNTIF($R$11:$R$20,\"=V\")","v":0},{"$f":"COUNTIF($R$11:$R$20,\"=O\")","v":0},{"$f":"IF(AND(LEN($B11)>1,$R11=\"O\"),VALUE(LEFT($AI11)),0)","v":0},{"$f":"IF(AND(LEN($B11)>1,$R11=\"O\"),VALUE(LEFT($AI11)),0)","v":0},0,0,0,null,{"$f":"AC11","v":0},{"$f":"IF(LEN(B11)>0,VALUE(IF(LEFT(B11,1)=\"5\",IF(LEN(B11)=4,B11,LEFT(B11,4)),IF(LEN(B11)=3,B11,LEFT(B11,3)))),\"\")","v":""},null,{"$f":"IF(AND(LEN($B11)>1,$R11=\"V\"),VALUE(LEFT($AI11)),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(H12:N12)=3,SUM(H12:L12)*G12,IF(COUNT(H12:N12)=5,(SUM(H12:N12)-MAX(H12:N12)-MIN(H12:N12))*G12,\"\"))","v":""},{"$f":"IF(AND(ISNUMBER(H11),OR(COUNT(I11:O11)=2,COUNT(I11:O11)=3,COUNT(I11:O11)=5,COUNT(I11:O11)=7)),P11*H11,\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(AND(Z11=2,AA11=3),\"\",\"Need 2 Voluntary & 3 Optional Dives in Prelims\")","v":"Need 2 Voluntary & 3 Optional Dives in Prelims"},null,null,null,null,null,null,null,{"$f":"IF(AH11>0,IF(OR(AH11=$AH$13,AH11=$AH$15,AH11=$AH$17,AH11=$AH$19,AH11=$AH$22,AH11=$AH$24,AH11=$AH$26),1,0),0)","v":0},{"$f":"IF(LEN(B11)>0,IF(LEFT(B11,1)=\"5\",IF(LEN(B11)=4,\"\",RIGHT(B11,1)),IF(LEN(B11)=3,\"\",RIGHT(B11,1))),\"\")","v":""},{"$f":"IF(AI12=\"A\",\"S\",IF(AI12=\"B\",\"P\",IF(AI12=\"C\",\"T\",IF(AI12=\"D\",\"F\",0))))","v":0}]
[2,null,{"$f":"IF(ISNUMBER(AI13),VLOOKUP(AI13,DiveTable,2,0),\"\")","v":""},null,null,null,{"$f":"AJ14","v":0},{"$f":"IF(AND(ISNUMBER(AI13),ISTEXT(G13)),VLOOKUP(AI13,DiveTable,IF(OR(G13=\"T\",G13=\"C\"),3,IF(OR(G13=\"P\",G13=\"B\"),4,IF(OR(G13=\"S\",G13=\"A\"),5,IF(OR(G13=\"F\",G13=\"D\"),6,#N/A)))),0),\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(COUNT(I13:O13)=2,SUM(I13:O13)*1.5,IF(COUNT(I13:O13)=3,SUM(I13:O13),IF(COUNT(I13:O13)=5,SUM(I13:O13)-MAX(I13:O13)-MIN(I13:O13),IF(COUNT(I13:O13)=7,SUM($I13:$O14)-LARGE($I13:$O14,1)-LARGE($I13:$O14,2)-SMALL($I13:$O14,1)-SMALL($I13:$O14,2),\"\"))))","v":""},{"$f":"IF(AND(ISNUMBER(H13),OR(COUNT(I13:O13)=2,COUNT(I13:O13)=3,COUNT(I13:O13)=5,COUNT(I13:O13)=7)),P13*H13,\"\")","v":""},null,null,{"$f":"IF(R13=\"V\",H13,0)","v":0},{"$f":"IF(LEN($B13)>1,VALUE(LEFT($AI13)),0)","v":0},{"$f":"IF(LEN($B13)>1,VALUE(LEFT($AI13)),0)","v":0},0,0,0,null,null,{"$f":"IF(AND(LEN($B13)>1,$R13=\"O\"),VALUE(LEFT($AI13)),0)","v":0},0,0,0,0,null,{"$f":"AC13","v":0},{"$f":"IF(LEN(B13)>0,VALUE(IF(LEFT(B13,1)=\"5\",IF(LEN(B13)=4,B13,LEFT(B13,4)),IF(LEN(B13)=3,B13,LEFT(B13,3)))),\"\")","v":""},null,{"$f":"IF(AND(LEN($B13)>1,$R13=\"V\"),VALUE(LEFT($AI13)),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(H14:N14)=3,SUM(H14:L14)*G14,IF(COUNT(H14:N14)=5,(SUM(H14:N14)-MAX(H14:N14)-MIN(H14:N14))*G14,\"\"))","v":""},{"$f":"IF(ISNUMBER(Q13),Q12+Q13,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AH13>0,IF(OR(AH13=$AH$11,AH13=$AH$15,AH13=$AH$17,AH13=$AH$19,AH13=$AH$22,AH13=$AH$24,AH13=$AH$26),1,0),0)","v":0},{"$f":"IF(LEN(B13)>0,IF(LEFT(B13,1)=\"5\",IF(LEN(B13)=4,\"\",RIGHT(B13,1)),IF(LEN(B13)=3,\"\",RIGHT(B13,1))),\"\")","v":""},{"$f":"IF(AI14=\"A\",\"S\",IF(AI14=\"B\",\"P\",IF(AI14=\"C\",\"T\",IF(AI14=\"D\",\"F\",0))))","v":0}]
[3,null,{"$f":"IF(ISNUMBER(AI15),VLOOKUP(AI15,DiveTable,2,0),\"\")","v":""},null,null,null,{"$f":"AJ16","v":0},{"$f":"IF(AND(ISNUMBER(AI15),ISTEXT(G15)),VLOOKUP(AI15,DiveTable,IF(OR(G15=\"T\",G15=\"C\"),3,IF(OR(G15=\"P\",G15=\"B\"),4,IF(OR(G15=\"S\",G15=\"A\"),5,IF(OR(G15=\"F\",G15=\"D\"),6,#N/A)))),0),\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(COUNT(I15:O15)=2,SUM(I15:O15)*1.5,IF(COUNT(I15:O15)=3,SUM(I15:O15),IF(COUNT(I15:O15)=5,SUM(I15:O15)-MAX(I15:O15)-MIN(I15:O15),IF(COUNT(I15:O15)=7,SUM($I15:$O16)-LARGE($I15:$O16,1)-LARGE($I15:$O16,2)-SMALL($I15:$O16,1)-SMALL($I15:$O16,2),\"\"))))","v":""},{"$f":"IF(AND(ISNUMBER(H15),OR(COUNT(I15:O15)=2,COUNT(I15:O15)=3,COUNT(I15:O15)=5,COUNT(I15:O15)=7)),P15*H15,\"\")","v":""},null,null,{"$f":"IF(R15=\"V\",H15,0)","v":0},{"$f":"IF(LEN($B15)>1,VALUE(LEFT($AI15)),0)","v":0},0,0,0,0,null,null,{"$f":"IF(AND(LEN($B15)>1,$R15=\"O\"),VALUE(LEFT($AI15)),0)","v":0},0,0,0,0,null,{"$f":"AC15","v":0},{"$f":"IF(LEN(B15)>0,VALUE(IF(LEFT(B15,1)=\"5\",IF(LEN(B15)=4,B15,LEFT(B15,4)),IF(LEN(B15)=3,B15,LEFT(B15,3)))),\"\")","v":""},null,{"$f":"IF(AND(LEN($B15)>1,$R15=\"V\"),VALUE(LEFT($AI15)),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(H16:N16)=3,SUM(H16:L16)*G16,IF(COUNT(H16:N16)=5,(SUM(H16:N16)-MAX(H16:N16)-MIN(H16:N16))*G16,\"\"))","v":""},{"$f":"IF(ISNUMBER(Q15),Q14+Q15,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AH15>0,IF(OR(AH15=$AH$13,AH15=$AH$11,AH15=$AH$17,AH15=$AH$19,AH15=$AH$22,AH15=$AH$24,AH15=$AH$26),1,0),0)","v":0},{"$f":"IF(LEN(B15)>0,IF(LEFT(B15,1)=\"5\",IF(LEN(B15)=4,\"\",RIGHT(B15,1)),IF(LEN(B15)=3,\"\",RIGHT(B15,1))),\"\")","v":""},{"$f":"IF(AI16=\"A\",\"S\",IF(AI16=\"B\",\"P\",IF(AI16=\"C\",\"T\",IF(AI16=\"D\",\"F\",0))))","v":0}]
[4,null,{"$f":"IF(ISNUMBER(AI17),VLOOKUP(AI17,DiveTable,2,0),\"\")","v":""},null,null,null,{"$f":"AJ18","v":0},{"$f":"IF(AND(ISNUMBER(AI17),ISTEXT(G17)),VLOOKUP(AI17,DiveTable,IF(OR(G17=\"T\",G17=\"C\"),3,IF(OR(G17=\"P\",G17=\"B\"),4,IF(OR(G17=\"S\",G17=\"A\"),5,IF(OR(G17=\"F\",G17=\"D\"),6,#N/A)))),0),\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(COUNT(I17:O17)=2,SUM(I17:O17)*1.5,IF(COUNT(I17:O17)=3,SUM(I17:O17),IF(COUNT(I17:O17)=5,SUM(I17:O17)-MAX(I17:O17)-MIN(I17:O17),IF(COUNT(I17:O17)=7,SUM($I17:$O18)-LARGE($I17:$O18,1)-LARGE($I17:$O18,2)-SMALL($I17:$O18,1)-SMALL($I17:$O18,2),\"\"))))","v":""},{"$f":"IF(AND(ISNUMBER(H17),OR(COUNT(I17:O17)=2,COUNT(I17:O17)=3,COUNT(I17:O17)=5,COUNT(I17:O17)=7)),P17*H17,\"\")","v":""},null,null,{"$f":"IF(R17=\"V\",H17,0)","v":0},{"$f":"IF(LEN($B17)>1,VALUE(LEFT($AI17)),0)","v":0},0,0,0,0,null,null,{"$f":"IF(AND(LEN($B17)>1,$R17=\"O\"),VALUE(LEFT($AI17)),0)","v":0},0,0,0,0,null,{"$f":"AC17","v":0},{"$f":"IF(LEN(B17)>0,VALUE(IF(LEFT(B17,1)=\"5\",IF(LEN(B17)=4,B17,LEFT(B17,4)),IF(LEN(B17)=3,B17,LEFT(B17,3)))),\"\")","v":""},null,{"$f":"IF(AND(LEN($B17)>1,$R17=\"V\"),VALUE(LEFT($AI17)),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(H18:N18)=3,SUM(H18:L18)*G18,IF(COUNT(H18:N18)=5,(SUM(H18:N18)-MAX(H18:N18)-MIN(H18:N18))*G18,\"\"))","v":""},{"$f":"IF(ISNUMBER(Q17),Q16+Q17,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AH17>0,IF(OR(AH17=$AH$13,AH17=$AH$15,AH17=$AH$11,AH17=$AH$19,AH17=$AH$22,AH17=$AH$24,AH17=$AH$26),1,0),0)","v":0},{"$f":"IF(LEN(B17)>0,IF(LEFT(B17,1)=\"5\",IF(LEN(B17)=4,\"\",RIGHT(B17,1)),IF(LEN(B17)=3,\"\",RIGHT(B17,1))),\"\")","v":""},{"$f":"IF(AI18=\"A\",\"S\",IF(AI18=\"B\",\"P\",IF(AI18=\"C\",\"T\",IF(AI18=\"D\",\"F\",0))))","v":0}]
[5,null,{"$f":"IF(ISNUMBER(AI19),VLOOKUP(AI19,DiveTable,2,0),\"\")","v":""},null,null,null,{"$f":"AJ20","v":0},{"$f":"IF(AND(ISNUMBER(AI19),ISTEXT(G19)),VLOOKUP(AI19,DiveTable,IF(OR(G19=\"T\",G19=\"C\"),3,IF(OR(G19=\"P\",G19=\"B\"),4,IF(OR(G19=\"S\",G19=\"A\"),5,IF(OR(G19=\"F\",G19=\"D\"),6,#N/A)))),0),\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(COUNT(I19:O19)=2,SUM(I19:O19)*1.5,IF(COUNT(I19:O19)=3,SUM(I19:O19),IF(COUNT(I19:O19)=5,SUM(I19:O19)-MAX(I19:O19)-MIN(I19:O19),IF(COUNT(I19:O19)=7,SUM($I19:$O20)-LARGE($I19:$O20,1)-LARGE($I19:$O20,2)-SMALL($I19:$O20,1)-SMALL($I19:$O20,2),\"\"))))","v":""},{"$f":"IF(AND(ISNUMBER(H19),OR(COUNT(I19:O19)=2,COUNT(I19:O19)=3,COUNT(I19:O19)=5,COUNT(I19:O19)=7)),P19*H19,\"\")","v":""},null,null,{"$f":"IF(R19=\"V\",H19,0)","v":0},{"$f":"IF(LEN($B19)>1,VALUE(LEFT($AI19)),0)","v":0},0,0,0,0,null,null,{"$f":"IF(AND(LEN($B19)>1,$R19=\"O\"),VALUE(LEFT($AI19)),0)","v":0},0,0,0,0,null,{"$f":"AC19","v":0},{"$f":"IF(LEN(B19)>0,VALUE(IF(LEFT(B19,1)=\"5\",IF(LEN(B19)=4,B19,LEFT(B19,4)),IF(LEN(B19)=3,B19,LEFT(B19,3)))),\"\")","v":""},null,{"$f":"IF(AND(LEN($B19)>1,$R19=\"V\"),VALUE(LEFT($AI19)),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(H20:N20)=3,SUM(H20:L20)*G20,IF(COUNT(H20:N20)=5,(SUM(H20:N20)-MAX(H20:N20)-MIN(H20:N20))*G20,\"\"))","v":""},{"$f":"IF(ISNUMBER(Q19),Q18+Q19,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AH19>0,IF(OR(AH19=$AH$13,AH19=$AH$15,AH19=$AH$17,AH19=$AH$11,AH19=$AH$22,AH19=$AH$24,AH19=$AH$26),1,0),0)","v":0},{"$f":"IF(LEN(B19)>0,IF(LEFT(B19,1)=\"5\",IF(LEN(B19)=4,\"\",RIGHT(B19,1)),IF(LEN(B19)=3,\"\",RIGHT(B19,1))),\"\")","v":""},{"$f":"IF(AI20=\"A\",\"S\",IF(AI20=\"B\",\"P\",IF(AI20=\"C\",\"T\",IF(AI20=\"D\",\"F\",0))))","v":0}]
["SEMI-FINALS (Dives 6,7,8 - 2 Vol. & 1 Opt. In any order)"]
[6,null,{"$f":"IF(ISNUMBER(AI22),VLOOKUP(AI22,DiveTable,2,0),\"\")","v":""},null,null,null,{"$f":"AJ23","v":0},{"$f":"IF(AND(ISNUMBER(AI22),ISTEXT(G22)),VLOOKUP(AI22,DiveTable,IF(OR(G22=\"T\",G22=\"C\"),3,IF(OR(G22=\"P\",G22=\"B\"),4,IF(OR(G22=\"S\",G22=\"A\"),5,IF(OR(G22=\"F\",G22=\"D\"),6,#N/A)))),0),\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(COUNT(I22:O22)=2,SUM(I22:O22)*1.5,IF(COUNT(I22:O22)=3,SUM(I22:O22),IF(COUNT(I22:O22)=5,SUM(I22:O22)-MAX(I22:O22)-MIN(I22:O22),IF(COUNT(I22:O22)=7,SUM($I22:$O23)-LARGE($I22:$O23,1)-LARGE($I22:$O23,2)-SMALL($I22:$O23,1)-SMALL($I22:$O23,2),\"\"))))","v":""},{"$f":"IF(AND(ISNUMBER(H22),OR(COUNT(I22:O22)=2,COUNT(I22:O22)=3,COUNT(I22:O22)=5,COUNT(I22:O22)=7)),P22*H22,\"\")","v":""},null,null,{"$f":"IF(R22=\"V\",H22,0)","v":0},{"$f":"IF(LEN($B22)>1,VALUE(LEFT($AI22)),0)","v":0},{"$f":"IF(LEN($B22)>1,VALUE(LEFT($AI22)),0)","v":0},{"$f":"IF(LEN($B22)>1,VALUE(LEFT($AI22)),0)","v":0},{"$f":"IF(LEN($B22)>1,VALUE(LEFT($AI22)),0)","v":0},{"$f":"IF(LEN($B22)>1,VALUE(LEFT($AI22)),0)","v":0},"2 V & 1 O in semis",null,{"$f":"IF(AND(LEN($B22)>1,$R22=\"O\"),VALUE(LEFT($AI22)),0)","v":0},{"$f":"IF(AND(LEN($B22)>1,$R22=\"O\"),VALUE(LEFT($AI22)),0)","v":0},{"$f":"IF(AND(LEN($B22)>1,$R22=\"O\"),VALUE(LEFT($AI22)),0)","v":0},{"$f":"IF(AND(LEN($B22)>1,$R22=\"O\"),VALUE(LEFT($AI22)),0)","v":0},{"$f":"IF(AND(LEN($B22)>1,$R22=\"O\"),VALUE(LEFT($AI22)),0)","v":0},null,{"$f":"AC22","v":0},{"$f":"IF(LEN(B22)>0,VALUE(IF(LEFT(B22,1)=\"5\",IF(LEN(B22)=4,B22,LEFT(B22,4)),IF(LEN(B22)=3,B22,LEFT(B22,3)))),\"\")","v":""},null,{"$f":"IF(AND(LEN($B22)>1,$R22=\"V\"),VALUE(LEFT($AI22)),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(H23:N23)=3,SUM(H23:L23)*G23,IF(COUNT(H23:N23)=5,(SUM(H23:N23)-MAX(H23:N23)-MIN(H23:N23))*G23,\"\"))","v":""},{"$f":"IF(ISNUMBER(Q22),Q20+Q22,\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"COUNTIF($R$22:$R$27,\"=V\")","v":0},{"$f":"COUNTIF($R$22:$R$27,\"=O\")","v":0},null,null,null,null,null,null,{"$f":"IF(AH22>0,IF(OR(AH22=$AH$13,AH22=$AH$15,AH22=$AH$17,AH22=$AH$19,AH22=$AH$11,AH22=$AH$24,AH22=$AH$26),1,0),0)","v":0},{"$f":"IF(LEN(B22)>0,IF(LEFT(B22,1)=\"5\",IF(LEN(B22)=4,\"\",RIGHT(B22,1)),IF(LEN(B22)=3,\"\",RIGHT(B22,1))),\"\")","v":""},{"$f":"IF(AI23=\"A\",\"S\",IF(AI23=\"B\",\"P\",IF(AI23=\"C\",\"T\",IF(AI23=\"D\",\"F\",0))))","v":0}]
[7,null,{"$f":"IF(ISNUMBER(AI24),VLOOKUP(AI24,DiveTable,2,0),\"\")","v":""},null,null,null,{"$f":"AJ25","v":0},{"$f":"IF(AND(ISNUMBER(AI24),ISTEXT(G24)),VLOOKUP(AI24,DiveTable,IF(OR(G24=\"T\",G24=\"C\"),3,IF(OR(G24=\"P\",G24=\"B\"),4,IF(OR(G24=\"S\",G24=\"A\"),5,IF(OR(G24=\"F\",G24=\"D\"),6,#N/A)))),0),\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(COUNT(I24:O24)=2,SUM(I24:O24)*1.5,IF(COUNT(I24:O24)=3,SUM(I24:O24),IF(COUNT(I24:O24)=5,SUM(I24:O24)-MAX(I24:O24)-MIN(I24:O24),IF(COUNT(I24:O24)=7,SUM($I24:$O25)-LARGE($I24:$O25,1)-LARGE($I24:$O25,2)-SMALL($I24:$O25,1)-SMALL($I24:$O25,2),\"\"))))","v":""},{"$f":"IF(AND(ISNUMBER(H24),OR(COUNT(I24:O24)=2,COUNT(I24:O24)=3,COUNT(I24:O24)=5,COUNT(I24:O24)=7)),P24*H24,\"\")","v":""},null,null,{"$f":"IF(R24=\"V\",H24,0)","v":0},{"$f":"IF(LEN($B24)>1,VALUE(LEFT($AI24)),0)","v":0},{"$f":"IF(LEN($B24)>1,VALUE(LEFT($AI24)),0)","v":0},{"$f":"IF(LEN($B24)>1,VALUE(LEFT($AI24)),0)","v":0},{"$f":"IF(LEN($B24)>1,VALUE(LEFT($AI24)),0)","v":0},{"$f":"IF(LEN($B24)>1,VALUE(LEFT($AI24)),0)","v":0},{"$f":"IF(AND(Z23=2,AA23=1),\"\",\"Need 2 Voluntary & 1 Optional Dive in Semis\")","v":"Need 2 Voluntary & 1 Optional Dive in Semis"},null,{"$f":"IF(AND(LEN($B24)>1,$R24=\"O\"),VALUE(LEFT($AI24)),0)","v":0},{"$f":"IF(AND(LEN($B24)>1,$R24=\"O\"),VALUE(LEFT($AI24)),0)","v":0},{"$f":"IF(AND(LEN($B24)>1,$R24=\"O\"),VALUE(LEFT($AI24)),0)","v":0},{"$f":"IF(AND(LEN($B24)>1,$R24=\"O\"),VALUE(LEFT($AI24)),0)","v":0},{"$f":"IF(AND(LEN($B24)>1,$R24=\"O\"),VALUE(LEFT($AI24)),0)","v":0},null,{"$f":"AC24","v":0},{"$f":"IF(LEN(B24)>0,VALUE(IF(LEFT(B24,1)=\"5\",IF(LEN(B24)=4,B24,LEFT(B24,4)),IF(LEN(B24)=3,B24,LEFT(B24,3)))),\"\")","v":""},null,{"$f":"IF(AND(LEN($B24)>1,$R24=\"V\"),VALUE(LEFT($AI24)),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(H25:N25)=3,SUM(H25:L25)*G25,IF(COUNT(H25:N25)=5,(SUM(H25:N25)-MAX(H25:N25)-MIN(H25:N25))*G25,\"\"))","v":""},{"$f":"IF(ISNUMBER(Q24),Q23+Q24,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AH24>0,IF(OR(AH24=$AH$13,AH24=$AH$15,AH24=$AH$17,AH24=$AH$19,AH24=$AH$22,AH24=$AH$11,AH24=$AH$26),1,0),0)","v":0},{"$f":"IF(LEN(B24)>0,IF(LEFT(B24,1)=\"5\",IF(LEN(B24)=4,\"\",RIGHT(B24,1)),IF(LEN(B24)=3,\"\",RIGHT(B24,1))),\"\")","v":""},{"$f":"IF(AI25=\"A\",\"S\",IF(AI25=\"B\",\"P\",IF(AI25=\"C\",\"T\",IF(AI25=\"D\",\"F\",0))))","v":0}]
[8,null,{"$f":"IF(ISNUMBER(AI26),VLOOKUP(AI26,DiveTable,2,0),\"\")","v":""},null,null,null,{"$f":"AJ27","v":0},{"$f":"IF(AND(ISNUMBER(AI26),ISTEXT(G26)),VLOOKUP(AI26,DiveTable,IF(OR(G26=\"T\",G26=\"C\"),3,IF(OR(G26=\"P\",G26=\"B\"),4,IF(OR(G26=\"S\",G26=\"A\"),5,IF(OR(G26=\"F\",G26=\"D\"),6,#N/A)))),0),\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(COUNT(I26:O26)=2,SUM(I26:O26)*1.5,IF(COUNT(I26:O26)=3,SUM(I26:O26),IF(COUNT(I26:O26)=5,SUM(I26:O26)-MAX(I26:O26)-MIN(I26:O26),IF(COUNT(I26:O26)=7,SUM($I26:$O27)-LARGE($I26:$O27,1)-LARGE($I26:$O27,2)-SMALL($I26:$O27,1)-SMALL($I26:$O27,2),\"\"))))","v":""},{"$f":"IF(AND(ISNUMBER(H26),OR(COUNT(I26:O26)=2,COUNT(I26:O26)=3,COUNT(I26:O26)=5,COUNT(I26:O26)=7)),P26*H26,\"\")","v":""},null,null,{"$f":"IF(R26=\"V\",H26,0)","v":0},{"$f":"IF(LEN($B26)>1,VALUE(LEFT($AI26)),0)","v":0},{"$f":"IF(LEN($B26)>1,VALUE(LEFT($AI26)),0)","v":0},{"$f":"IF(LEN($B26)>1,VALUE(LEFT($AI26)),0)","v":0},{"$f":"IF(LEN($B26)>1,VALUE(LEFT($AI26)),0)","v":0},{"$f":"IF(LEN($B26)>1,VALUE(LEFT($AI26)),0)","v":0},null,null,{"$f":"IF(AND(LEN($B26)>1,$R26=\"O\"),VALUE(LEFT($AI26)),0)","v":0},{"$f":"IF(AND(LEN($B26)>1,$R26=\"O\"),VALUE(LEFT($AI26)),0)","v":0},{"$f":"IF(AND(LEN($B26)>1,$R26=\"O\"),VALUE(LEFT($AI26)),0)","v":0},{"$f":"IF(AND(LEN($B26)>1,$R26=\"O\"),VALUE(LEFT($AI26)),0)","v":0},{"$f":"IF(AND(LEN($B26)>1,$R26=\"O\"),VALUE(LEFT($AI26)),0)","v":0},null,{"$f":"AC26","v":0},{"$f":"IF(LEN(B26)>0,VALUE(IF(LEFT(B26,1)=\"5\",IF(LEN(B26)=4,B26,LEFT(B26,4)),IF(LEN(B26)=3,B26,LEFT(B26,3)))),\"\")","v":""},null,{"$f":"IF(AND(LEN($B26)>1,$R26=\"V\"),VALUE(LEFT($AI26)),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(H27:N27)=3,SUM(H27:L27)*G27,IF(COUNT(H27:N27)=5,(SUM(H27:N27)-MAX(H27:N27)-MIN(H27:N27))*G27,\"\"))","v":""},{"$f":"IF(ISNUMBER(Q26),Q25+Q26,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AH26>0,IF(OR(AH26=$AH$13,AH26=$AH$15,AH26=$AH$17,AH26=$AH$19,AH26=$AH$22,AH26=$AH$24,AH26=$AH$11),1,0),0)","v":0},{"$f":"IF(LEN(B26)>0,IF(LEFT(B26,1)=\"5\",IF(LEN(B26)=4,\"\",RIGHT(B26,1)),IF(LEN(B26)=3,\"\",RIGHT(B26,1))),\"\")","v":""},{"$f":"IF(AI27=\"A\",\"S\",IF(AI27=\"B\",\"P\",IF(AI27=\"C\",\"T\",IF(AI27=\"D\",\"F\",0))))","v":0}]
["FINALS (Dives 9,10,11 - 1 Vol. & 2 Opt. in any order)"]
[9,null,{"$f":"IF(ISNUMBER(AI29),VLOOKUP(AI29,DiveTable,2,0),\"\")","v":""},null,null,null,{"$f":"AJ30","v":0},{"$f":"IF(AND(ISNUMBER(AI29),ISTEXT(G29)),VLOOKUP(AI29,DiveTable,IF(OR(G29=\"T\",G29=\"C\"),3,IF(OR(G29=\"P\",G29=\"B\"),4,IF(OR(G29=\"S\",G29=\"A\"),5,IF(OR(G29=\"F\",G29=\"D\"),6,#N/A)))),0),\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(COUNT(I29:O29)=2,SUM(I29:O29)*1.5,IF(COUNT(I29:O29)=3,SUM(I29:O29),IF(COUNT(I29:O29)=5,SUM(I29:O29)-MAX(I29:O29)-MIN(I29:O29),IF(COUNT(I29:O29)=7,SUM($I29:$O30)-LARGE($I29:$O30,1)-LARGE($I29:$O30,2)-SMALL($I29:$O30,1)-SMALL($I29:$O30,2),\"\"))))","v":""},{"$f":"IF(AND(ISNUMBER(H29),OR(COUNT(I29:O29)=2,COUNT(I29:O29)=3,COUNT(I29:O29)=5,COUNT(I29:O29)=7)),P29*H29,\"\")","v":""},null,null,{"$f":"IF(R29=\"V\",H29,0)","v":0},{"$f":"IF(OR(U11=1,U13=1,U15=1,U17=1,U19=1,U22=1,U24=1,U26=1),1,0)","v":0},{"$f":"IF(OR(V11=2,V13=2,V15=2,V17=2,V19=2,V22=2,V24=2,V26=2),1,0)","v":0},{"$f":"IF(OR(W11=3,W13=3,W15=3,W17=3,W19=3,W22=3,W24=3,W26=3),1,0)","v":0},{"$f":"IF(OR(X11=4,X13=4,X15=4,X17=4,X19=4,X22=4,X24=4,X26=4),1,0)","v":0},{"$f":"IF(OR(Y11=5,Y13=5,Y15=5,Y17=5,Y19=5,Y22=5,Y24=5,Y26=5),1,0)","v":0},"1 V & 2 O in finals",null,{"$f":"IF(AND(LEN($B29)>1,$R29=\"O\"),VALUE(LEFT($AI29)),0)","v":0},{"$f":"IF(AND(LEN($B29)>1,$R29=\"O\"),VALUE(LEFT($AI29)),0)","v":0},{"$f":"IF(AND(LEN($B29)>1,$R29=\"O\"),VALUE(LEFT($AI29)),0)","v":0},{"$f":"IF(AND(LEN($B29)>1,$R29=\"O\"),VALUE(LEFT($AI29)),0)","v":0},{"$f":"IF(AND(LEN($B29)>1,$R29=\"O\"),VALUE(LEFT($AI29)),0)","v":0},null,{"$f":"SUM(AH12,AH14,AH16,AH18,AH20,AH23,AH25,AH27)","v":0},{"$f":"IF(LEN(B29)>0,VALUE(IF(LEFT(B29,1)=\"5\",IF(LEN(B29)=4,B29,LEFT(B29,4)),IF(LEN(B29)=3,B29,LEFT(B29,3)))),\"\")","v":""},null,{"$f":"IF(AND(LEN($B29)>1,$R29=\"V\"),VALUE(LEFT($AI29)),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(H30:N30)=3,SUM(H30:L30)*G30,IF(COUNT(H30:N30)=5,(SUM(H30:N30)-MAX(H30:N30)-MIN(H30:N30))*G30,\"\"))","v":""},{"$f":"IF(ISNUMBER(Q29),Q27+Q29,\"\")","v":""},null,null,null,{"$f":"SUM(U29:Y29)","v":0},null,null,null,null,{"$f":"COUNTIF($R$29:$R$34,\"=V\")","v":0},{"$f":"COUNTIF($R$29:$R$34,\"=O\")","v":0},null,null,null,null,null,null,null,{"$f":"IF(LEN(B29)>0,IF(LEFT(B29,1)=\"5\",IF(LEN(B29)=4,\"\",RIGHT(B29,1)),IF(LEN(B29)=3,\"\",RIGHT(B29,1))),\"\")","v":""},{"$f":"IF(AI30=\"A\",\"S\",IF(AI30=\"B\",\"P\",IF(AI30=\"C\",\"T\",IF(AI30=\"D\",\"F\",0))))","v":0}]
[10,null,{"$f":"IF(ISNUMBER(AI31),VLOOKUP(AI31,DiveTable,2,0),\"\")","v":""},null,null,null,{"$f":"AJ32","v":0},{"$f":"IF(AND(ISNUMBER(AI31),ISTEXT(G31)),VLOOKUP(AI31,DiveTable,IF(OR(G31=\"T\",G31=\"C\"),3,IF(OR(G31=\"P\",G31=\"B\"),4,IF(OR(G31=\"S\",G31=\"A\"),5,IF(OR(G31=\"F\",G31=\"D\"),6,#N/A)))),0),\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(COUNT(I31:O31)=2,SUM(I31:O31)*1.5,IF(COUNT(I31:O31)=3,SUM(I31:O31),IF(COUNT(I31:O31)=5,SUM(I31:O31)-MAX(I31:O31)-MIN(I31:O31),IF(COUNT(I31:O31)=7,SUM($I31:$O32)-LARGE($I31:$O32,1)-LARGE($I31:$O32,2)-SMALL($I31:$O32,1)-SMALL($I31:$O32,2),\"\"))))","v":""},{"$f":"IF(AND(ISNUMBER(H31),OR(COUNT(I31:O31)=2,COUNT(I31:O31)=3,COUNT(I31:O31)=5,COUNT(I31:O31)=7)),P31*H31,\"\")","v":""},null,null,{"$f":"IF(R31=\"V\",H31,0)","v":0},null,null,null,null,null,{"$f":"IF(AND(Z30=1,AA30=2),\"\",\"Need 1 Voluntary & 2 Optional Dive in Finals\")","v":"Need 1 Voluntary & 2 Optional Dive in Finals"},null,{"$f":"IF(AND(LEN($B31)>1,$R31=\"O\"),VALUE(LEFT($AI31)),0)","v":0},{"$f":"IF(AND(LEN($B31)>1,$R31=\"O\"),VALUE(LEFT($AI31)),0)","v":0},{"$f":"IF(AND(LEN($B31)>1,$R31=\"O\"),VALUE(LEFT($AI31)),0)","v":0},{"$f":"IF(AND(LEN($B31)>1,$R31=\"O\"),VALUE(LEFT($AI31)),0)","v":0},{"$f":"IF(AND(LEN($B31)>1,$R31=\"O\"),VALUE(LEFT($AI31)),0)","v":0},null,null,{"$f":"IF(LEN(B31)>0,VALUE(IF(LEFT(B31,1)=\"5\",IF(LEN(B31)=4,B31,LEFT(B31,4)),IF(LEN(B31)=3,B31,LEFT(B31,3)))),\"\")","v":""},null,{"$f":"IF(AND(LEN($B31)>1,$R31=\"V\"),VALUE(LEFT($AI31)),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(H32:N32)=3,SUM(H32:L32)*G32,IF(COUNT(H32:N32)=5,(SUM(H32:N32)-MAX(H32:N32)-MIN(H32:N32))*G32,\"\"))","v":""},{"$f":"IF(ISNUMBER(Q31),Q30+Q31,\"\")","v":""},null,null,null,null,null,null,null,null,"Total V or O entries",null,null,null,null,null,null,null,null,{"$f":"IF(LEN(B31)>0,IF(LEFT(B31,1)=\"5\",IF(LEN(B31)=4,\"\",RIGHT(B31,1)),IF(LEN(B31)=3,\"\",RIGHT(B31,1))),\"\")","v":""},{"$f":"IF(AI32=\"A\",\"S\",IF(AI32=\"B\",\"P\",IF(AI32=\"C\",\"T\",IF(AI32=\"D\",\"F\",0))))","v":0}]
[11,null,{"$f":"IF(ISNUMBER(AI33),VLOOKUP(AI33,DiveTable,2,0),\"\")","v":""},null,null,null,{"$f":"AJ34","v":0},{"$f":"IF(AND(ISNUMBER(AI33),ISTEXT(G33)),VLOOKUP(AI33,DiveTable,IF(OR(G33=\"T\",G33=\"C\"),3,IF(OR(G33=\"P\",G33=\"B\"),4,IF(OR(G33=\"S\",G33=\"A\"),5,IF(OR(G33=\"F\",G33=\"D\"),6,#N/A)))),0),\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(COUNT(I33:O33)=2,SUM(I33:O33)*1.5,IF(COUNT(I33:O33)=3,SUM(I33:O33),IF(COUNT(I33:O33)=5,SUM(I33:O33)-MAX(I33:O33)-MIN(I33:O33),IF(COUNT(I33:O33)=7,SUM($I33:$O34)-LARGE($I33:$O34,1)-LARGE($I33:$O34,2)-SMALL($I33:$O34,1)-SMALL($I33:$O34,2),\"\"))))","v":""},{"$f":"IF(AND(ISNUMBER(H33),OR(COUNT(I33:O33)=2,COUNT(I33:O33)=3,COUNT(I33:O33)=5,COUNT(I33:O33)=7)),P33*H33,\"\")","v":""},null,null,{"$f":"IF(R33=\"V\",H33,0)","v":0},null,null,null,null,null,{"$f":"SUM(Z11:AA11,Z23:AA23,Z30:AA30)","v":0},null,{"$f":"IF(AND(LEN($B33)>1,$R33=\"O\"),VALUE(LEFT($AI33)),0)","v":0},{"$f":"IF(AND(LEN($B33)>1,$R33=\"O\"),VALUE(LEFT($AI33)),0)","v":0},{"$f":"IF(AND(LEN($B33)>1,$R33=\"O\"),VALUE(LEFT($AI33)),0)","v":0},{"$f":"IF(AND(LEN($B33)>1,$R33=\"O\"),VALUE(LEFT($AI33)),0)","v":0},{"$f":"IF(AND(LEN($B33)>1,$R33=\"O\"),VALUE(LEFT($AI33)),0)","v":0},null,null,{"$f":"IF(LEN(B33)>0,VALUE(IF(LEFT(B33,1)=\"5\",IF(LEN(B33)=4,B33,LEFT(B33,4)),IF(LEN(B33)=3,B33,LEFT(B33,3)))),\"\")","v":""},null,{"$f":"IF(AND(LEN($B33)>1,$R33=\"V\"),VALUE(LEFT($AI33)),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(H34:N34)=3,SUM(H34:L34)*G34,IF(COUNT(H34:N34)=5,(SUM(H34:N34)-MAX(H34:N34)-MIN(H34:N34))*G34,\"\"))","v":""},{"$f":"IF(ISNUMBER(Q33),Q32+Q33,\"\")","v":""},null,null,{"$f":"SUM(T11:T33)","v":0},null,null,null,null,null,null,null,{"$f":"IF(OR(AB11=1,AB13=1,AB15=1,AB17=1,AB19=1,AB22=1,AB24=1,AB26=1,AB29=1,AB31=1,AB33=1),1,0)","v":0},{"$f":"IF(OR(AC11=2,AC13=2,AC15=2,AC17=2,AC19=2,AC22=2,AC24=2,AC26=2,AC29=2,AC31=2,AC33=2),1,0)","v":0},{"$f":"IF(OR(AD11=3,AD13=3,AD15=3,AD17=3,AD19=3,AD22=3,AD24=3,AD26=3,AD29=3,AD31=3,AD33=3),1,0)","v":0},{"$f":"IF(OR(AE11=4,AE13=4,AE15=4,AE17=4,AE19=4,AE22=4,AE24=4,AE26=4,AE29=4,AE31=4,AE33=4),1,0)","v":0},{"$f":"IF(OR(AF11=5,AF13=5,AF15=5,AF17=5,AF19=5,AF22=5,AF24=5,AF26=5,AF29=5,AF31=5,AF33=5),1,0)","v":0},null,null,{"$f":"IF(LEN(B33)>0,IF(LEFT(B33,1)=\"5\",IF(LEN(B33)=4,\"\",RIGHT(B33,1)),IF(LEN(B33)=3,\"\",RIGHT(B33,1))),\"\")","v":""},{"$f":"IF(AI34=\"A\",\"S\",IF(AI34=\"B\",\"P\",IF(AI34=\"C\",\"T\",IF(AI34=\"D\",\"F\",0))))","v":0}]
[null,null,{"$f":"T50","v":"Enter Name"},null,null,null,null,{"$f":"SUMIF(R11:R34,\"V\",H11:H34)","v":0},null,null,null,null,null,null,null,"TOTAL POINTS AWARDED  ",{"$f":"IF(ISNUMBER(Q34),Q34,\"\")","v":""},null,null,{"$f":"IF(LEN(U35)>1,1,0)","v":0},{"$f":"IF(ISNA(C11),\"Illegal Dive No. 1\",IF(ISNA(C13),\"Illegal Dive No. 2\",IF(ISNA(C15),\"Illegal Dive No. 3\",IF(ISNA(C17),\"Illegal Dive No. 4\",IF(ISNA(C19),\"Illegal Dive No. 5\",IF(ISNA(C22),\"Illegal Dive No. 6\",IF(ISNA(C24),\"Illegal Dive No. 7\",\"\")))))))","v":""},null,null,null,null,null,null,{"$f":"SUM(AB34:AF34)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(AK11:AK34,1)=1,0,1)+IF(COUNTIF(AK11:AK34,2)=1,0,1)+IF(COUNTIF(AK11:AK34,3)=1,0,1)+IF(COUNTIF(AK11:AK34,4)=1,0,1)+IF(COUNTIF(AK11:AK34,5)=1,0,1)","v":5}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Signatures",null,null,null,null,null,null,{"$f":"IF(LEN(U36)>1,1,0)","v":0},{"$f":"IF(ISNA(C26),\"Illegal Dive No. 8\",IF(ISNA(C29),\"Illegal Dive No. 9\",IF(ISNA(C31),\"Illegal Dive No. 10\",IF(ISNA(C33),\"Illegal Dive No. 11\",\"\"))))","v":""}]
[null,"T(C) = Tuck, P(B) = Pike, S(A) = Straight, F(D) = Free\nDual Meets: List voluntary dive first. Spaces 2-6 for optional dives\nCHAMPIONSHIP & OTHER 11-DIVE MEETS: List dives in each section as per instructions",null,null,null,null,null,null,null,null,null,null,"Diver",null,null,null,null,null,null,{"$f":"IF(AND(LEN(U37)>1,COUNT(AI11,AI13,AI15,AI17,AI19,AI22,AI24,AI26,AI29,AI31,AI33)=11),1,0)","v":0},{"$f":"IF(OR(AI11=AI13,AI11=AI15,AI11=AI17,AI11=AI19,AI11=AI22,AI11=AI24,AI11=AI26,AI11=AI29,AI11=AI31,AI11=AI33,AI13=AI15,AI13=AI17,AI13=AI19,AI13=AI22,AI13=AI24,AI13=AI26,AI13=AI29,AI13=AI31,AI13=AI33,AI15=AI17,AI15=AI19,AI15=AI22,AI15=AI24,AI15=AI26,AI15=AI29,AI15=AI31,AI15=AI33),\"Repeated Dive No.\",\"\")","v":"Repeated Dive No."}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Coach",null,null,null,null,null,null,{"$f":"IF(AND(LEN(U38)>1,COUNT(AI11,AI13,AI15,AI17,AI19,AI22,AI24,AI26,AI29,AI31,AI33)=11),1,0)","v":0},{"$f":"IF(OR(AI17=AI19,AI17=AI22,AI17=AI24,AI17=AI26,AI17=AI29,AI17=AI31,AI17=AI33,AI19=AI22,AI19=AI24,AI19=AI26,AI19=AI29,AI19=AI31,AI19=AI33,AI22=AI24,AI22=AI26,AI22=AI29,AI22=AI31,AI22=AI33,AI24=AI26,AI24=AI29,AI24=AI31,AI24=AI33,AI26=AI29,AI26=AI31,AI26=AI33),\"Repeated Dive No.\",\"\")","v":"Repeated Dive No."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'NDHSAA 6 Dive'!X11","v":"2022-08-15"}]
[{"$f":"'NDHSAA 6 Dive'!A39","v":"gvp 7/30/22"},null,null,null,null,null,null,null,null,null,null,null,"Referee",null,null,null,null,null,null,{"$f":"IF(AND(LEN(U39)>1,COUNT(AI11,AI13,AI15,AI17,AI19,AI22,AI24,AI26,AI29,AI31,AI33)=11),1,0)","v":0},{"$f":"IF(OR(AI29=AI31,AI29=AI33,AI31=AI33),\"Repeated Dive No.\",\"\")","v":"Repeated Dive No."},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(L5),1,0)","v":0},null,{"$f":"'NDHSAA 6 Dive'!Y31","v":"2023-03-11"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(LEN(U40)>1,COUNT(AI11,AI13,AI15,AI17,AI19,AI22,AI24,AI26,AI29,AI31,AI33)=11),1,0)","v":0},{"$f":"IF(ISNA(H11),\"Illegal Position for Dive 1\",IF(ISNA(H13),\"Illegal Position for Dive 2\",IF(ISNA(H15),\"Illegal Position for Dive 3\",IF(ISNA(H17),\"Illegal Position for Dive 4\",IF(ISNA(H19),\"Illegal Position for Dive 5\",IF(ISNA(H22),\"Illegal Position for Dive 6\",\"\"))))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,"Name Entered:",{"$f":"IF(LEN(B4)>0,0,1)","v":1},"Name"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(LEN(U41)>1,COUNT(AI11,AI13,AI15,AI17,AI19,AI22,AI24,AI26,AI29,AI31,AI33)=11),1,0)","v":0},{"$f":"IF(ISNA(H24),\"Illegal Position for Dive 7\",IF(ISNA(H26),\"Illegal Position for Dive 8\",IF(ISNA(H29),\"Illegal Position for Dive 9\",IF(ISNA(H31),\"Illegal Position for Dive 10\",IF(ISNA(H33),\"Illegal Position for Dive 11\",\"\")))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,"School Entered:",{"$f":"IF(LEN(J4)>0,0,1)","v":1},"School"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(LEN(U42)>1,COUNT(AI11,AI13,AI15,AI17,AI19,AI22,AI24,AI26,AI29,AI31,AI33)=11),1,0)","v":0},{"$f":"IF(Z33<11,\"Enter V or O in column P to specify Dives as Voluntary or Optional\",\"\")","v":"Enter V or O in column P to specify Dives as Voluntary or Optional"},null,null,null,null,null,null,null,null,null,null,null,null,"Meet Entered:",{"$f":"IF(LEN(B5)>0,0,1)","v":1},"Meet"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(LEN(U43)>1,COUNT(AI11,AI13,AI15,AI17,AI19,AI22,AI24,AI26,AI29,AI31,AI33)=11),1,0)","v":0},{"$f":"IF(U30<5,\"Need all 5 Groups in 1st 8 Rounds\",IF(AB35<5,\"Need all 5 Groups in 6 Optional Dives\",\"\"))","v":"Need all 5 Groups in 1st 8 Rounds"},null,null,null,null,null,null,null,null,null,null,null,null,"Site Entered:",{"$f":"IF(LEN(F5)>0,0,1)","v":1},"Site"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(LEN(U44)>1,COUNT(AI11,AI13,AI15,AI17,AI19,AI22,AI24,AI26,AI29,AI31,AI33)=11),1,0)","v":0},{"$f":"IF(LEN(Z12)>1,Z12,IF(LEN(Z24)>1,Z24,IF(LEN(Z31)>1,Z31,\"\")))","v":"Need 2 Voluntary & 3 Optional Dives in Prelims"},null,null,null,null,null,null,null,null,null,null,null,null,"Date Entered:",{"$f":"IF(AI39,0,1)","v":1},"Valid Meet Date"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(LEN(U45)>1,COUNT(AI11,AI13,AI15,AI17,AI19,AI22,AI24,AI26,AI29,AI31,AI33)=11),1,0)","v":0},{"$f":"IF(T34>9,\"Sum of Voluntary DD > 9.0\",IF(AH29>0,\">1 Optional Dive from same Group through Semis\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,"Grade Entered:",{"$f":"IF(LEN(B6)>0,0,1)","v":1},"Grade"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(LEN(U46)>1,COUNT(AI11,AI13,AI15,AI17,AI19,AI22,AI24,AI26,AI29,AI31,AI33)=11),1,0)","v":0},{"$f":"IF(AK35>0,\"Need 5 Voluntary Dives, 1 from each Group\",\"\")","v":"Need 5 Voluntary Dives, 1 from each Group"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(AI40:AI45)","v":1},{"$f":"VLOOKUP(AI46,AI40:AJ45,2,0)","v":"Name"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(LEN(U47)>1,COUNT(AI11,AI13,AI15,AI17,AI19,AI22,AI24,AI26,AI29,AI31,AI33)=11),1,0)","v":0},{"$f":"IF(AND(G11=AJ12,G13=AJ14,G15=AJ16,G17=AJ18,G19=AJ20,G22=AJ23,G24=AJ25,G26=AJ27,G29=AJ30,G31=AJ32,G33=AJ34),\"\",\"Dive Number does not match Dive Position\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(LEN(U48)>1,1,0)","v":1},{"$f":"IF(AI46,\"Enter \"&AJ46,\"\")","v":"Enter Name"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(LEN(U49)>1,1,0)","v":0},{"$f":"IF(COUNTA(B11,B13,B15,B17,B19,B22,B24,B26,B29,B31,B33)=6,\"If only entering 6 Dives, please use 6 Dive Sheet\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(T35:T49)>0,VLOOKUP(1,T35:U49,2,0),\"\")","v":"Enter Name"}]

{"sheet":"Dive Table","index":4,"n_rows":117,"n_cols":8,"rows_kept":117,"cut":false,"hidden":false,"merged":[]}
["2022-2023 NFHS Rule Book",null,"Degree of Difficulty"]
[null,null,"C","B","A","D"]
[null,null,"T","P","S","F"]
["Dive No.","Dive Description","Tuck","Pike","Straight","Free",null,"Dive Selection"]
[101,"Forward Dive",1.2,1.3,1.4,{"$error":"#N/A"},null,"101A"]
[102,"Forward 1 SS",1.4,1.5,1.6,{"$error":"#N/A"},null,"101B"]
[103,"Forward 1½ SS",1.6,1.7,2,{"$error":"#N/A"},null,"101C"]
[104,"Forward 2 SS",2.2000000000000002,2.2999999999999998,2.6,{"$error":"#N/A"},null,"102A"]
[105,"Forward 2½ SS",2.4,2.6,{"$error":"#N/A"},{"$error":"#N/A"},null,"102B"]
[106,"Forward 3 SS",2.9,3.2,{"$error":"#N/A"},{"$error":"#N/A"},null,"102C"]
[107,"Forward 3½ SS",3,3.3,{"$error":"#N/A"},{"$error":"#N/A"},null,"103A"]
[112,"Forward Flying 1 SS",1.6,1.7,{"$error":"#N/A"},{"$error":"#N/A"},null,"103B"]
[113,"Forward Flying 1½ SS",1.8,1.9,{"$error":"#N/A"},{"$error":"#N/A"},null,"103C"]
[201,"Back Dive",1.5,1.6,1.7,{"$error":"#N/A"},null,"104A"]
[202,"Back 1 SS",1.5,1.6,1.7,{"$error":"#N/A"},null,"104B"]
[203,"Back 1½ SS",2,2.2999999999999998,2.5,{"$error":"#N/A"},null,"104C"]
[204,"Back 2 SS",2,2.2999999999999998,{"$error":"#N/A"},{"$error":"#N/A"},null,"105B"]
[205,"Back 2½ SS",3,3.2,{"$error":"#N/A"},{"$error":"#N/A"},null,"105C"]
[301,"Reverse Dive",1.6,1.7,1.8,{"$error":"#N/A"},null,"106B"]
[302,"Reverse 1 SS",1.6,1.7,1.8,{"$error":"#N/A"},null,"106C"]
[303,"Reverse 1½ SS",2.1,2.4,2.7,{"$error":"#N/A"},null,"107B"]
[304,"Reverse 2 SS",2.1,2.4,2.9,{"$error":"#N/A"},null,"107C"]
[305,"Reverse 2½ SS",3,3.2,{"$error":"#N/A"},{"$error":"#N/A"},null,"112B"]
[401,"Inward Dive",1.4,1.5,1.8,{"$error":"#N/A"},null,"112C"]
[402,"Inward 1 SS",1.6,1.7,2,{"$error":"#N/A"},null,"113B"]
[403,"Inward 1½ SS",2.2000000000000002,2.4,{"$error":"#N/A"},{"$error":"#N/A"},null,"113C"]
[404,"Inward 2 SS",2.8,3,{"$error":"#N/A"},{"$error":"#N/A"},null,"201A"]
[405,"Inward 2½ SS",3.1,3.4,{"$error":"#N/A"},{"$error":"#N/A"},null,"201B"]
[412,"Inward Flying SS",2,2.1,{"$error":"#N/A"},{"$error":"#N/A"},null,"201C"]
[413,"Inward Flying 1½ SS",2.7,2.9,{"$error":"#N/A"},{"$error":"#N/A"},null,"202A"]
[5111,"Forward Dive, ½ Twist",1.6,1.7,1.8,{"$error":"#N/A"},null,"202B"]
[5112,"Forward Dive, 1 Twist",{"$error":"#N/A"},1.9,2,{"$error":"#N/A"},null,"202C"]
[5121,"Forward 1 SS, ½ Twist",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},1.7,null,"203A"]
[5122,"Forward 1 SS, 1 Twist",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},1.9,null,"203B"]
[5124,"Forward 1 SS, 2 Twists",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},2.2999999999999998,null,"203C"]
[5126,"Forward 1 SS, 3 Twists",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},2.8,null,"204B"]
[5131,"Forward 1½ SS, ½ Twist",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},2,null,"204C"]
[5132,"Forward 1½ SS, 1 Twist",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},2.2000000000000002,null,"205B"]
[5134,"Forward 1½ SS, 2 Twists",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},2.6,null,"205C"]
[5136,"Forward 1½ SS, 3 Twists",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},3.1,null,"301A"]
[5142,"Forward 2 SS, 1 Twist",2.6,2.7,{"$error":"#N/A"},{"$error":"#N/A"},null,"301B"]
[5152,"Forward 2½ SS, 1 Twist",3,3.2,{"$error":"#N/A"},{"$error":"#N/A"},null,"301C"]
[5211,"Back Dive, ½ Twist",{"$error":"#N/A"},{"$error":"#N/A"},1.8,{"$error":"#N/A"},null,"302A"]
[5212,"Back Dive, 1 Twist",{"$error":"#N/A"},{"$error":"#N/A"},2,{"$error":"#N/A"},null,"302B"]
[5221,"Back 1 SS, ½ Twist",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},1.7,null,"302C"]
[5222,"Back 1 SS, 1 Twist",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},1.9,null,"303A"]
[5223,"Back 1 SS, 1½ Twists",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},2.2999999999999998,null,"303B"]
[5225,"Back 1 SS, 2½ Twists",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},2.7,null,"303C"]
[5227,"Back 1 SS, 3½ Twists",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},3.2,null,"304A"]
[5231,"Back 1½ SS, ½ Twist",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},2.1,null,"304B"]
[5233,"Back 1½ SS, 1½ Twists",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},2.5,null,"304C"]
[5235,"Back 1½ SS, 2½ Twists",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},2.9,null,"305B"]
[5251,"Back 2½ SS, ½ Twist",2.7,2.9,{"$error":"#N/A"},{"$error":"#N/A"},null,"305C"]
[5311,"Reverse Dive, ½ Twist",{"$error":"#N/A"},{"$error":"#N/A"},1.9,{"$error":"#N/A"},null,"401A"]
[5312,"Reverse Dive, 1 Twist",{"$error":"#N/A"},{"$error":"#N/A"},2.1,{"$error":"#N/A"},null,"401B"]
[5321,"Reverse 1 SS, ½ Twist",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},1.8,null,"401C"]
[5322,"Reverse 1 SS, 1 Twist",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},2,null,"402A"]
[5323,"Reverse 1 SS, 1½ Twists",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},2.4,null,"402B"]
[5325,"Reverse 1 SS, 2½ Twists",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},2.8,null,"402C"]
[5331,"Reverse 1½ SS, ½ Twist",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},2.2000000000000002,null,"403B"]
[5333,"Reverse 1½ SS, 1½ Twists",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},2.6,null,"403C"]
[5335,"Reverse 1½ SS, 2½ Twists",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},3,null,"404B"]
[5351,"Reverse 2½ SS, ½ Twist",2.7,2.9,{"$error":"#N/A"},{"$error":"#N/A"},null,"404C"]
[5411,"Inward Dive, ½ Twist",{"$error":"#N/A"},1.7,2,{"$error":"#N/A"},null,"405B"]
[5412,"Inward Dive, 1 Twist",{"$error":"#N/A"},1.9,2.2000000000000002,{"$error":"#N/A"},null,"405C"]
[5421,"Inward 1 SS, ½ Twist",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},1.9,null,"412B"]
[5422,"Inward 1 SS, 1 Twist",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},2.1,null,"412C"]
[5432,"Inward 1½ SS, 1 Twist",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},2.7,null,"413B"]
[5434,"Inward 1½ SS, 2 Twists",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},3.1,null,"413C"]
[null,null,null,null,null,null,null,"5111A"]
[null,null,null,null,null,null,null,"5111B"]
[null,null,null,null,null,null,null,"5111C"]
[null,null,null,null,null,null,null,"5112A"]
[null,null,null,null,null,null,null,"5112B"]
[null,null,null,null,null,null,null,"5121D"]
[null,null,null,null,null,null,null,"5122D"]
[null,null,null,null,null,null,null,"5124D"]
[null,null,null,null,null,null,null,"5126D"]
[null,null,null,null,null,null,null,"5131D"]
[null,null,null,null,null,null,null,"5132D"]
[null,null,null,null,null,null,null,"5134D"]
[null,null,null,null,null,null,null,"5136D"]
[null,null,null,null,null,null,null,"5142B"]
[null,null,null,null,null,null,null,"5142C"]
[null,null,null,null,null,null,null,"5152B"]
[null,null,null,null,null,null,null,"5152C"]
[null,null,null,null,null,null,null,"5211A"]
[null,null,null,null,null,null,null,"5212A"]
[null,null,null,null,null,null,null,"5221D"]
[null,null,null,null,null,null,null,"5222D"]
[null,null,null,null,null,null,null,"5223D"]
[null,null,null,null,null,null,null,"5225D"]
[null,null,null,null,null,null,null,"5227D"]
[null,null,null,null,null,null,null,"5231D"]
[null,null,null,null,null,null,null,"5233D"]
[null,null,null,null,null,null,null,"5235D"]
[null,null,null,null,null,null,null,"5251B"]
[null,null,null,null,null,null,null,"5251C"]
[null,null,null,null,null,null,null,"5311A"]
[null,null,null,null,null,null,null,"5312A"]
[null,null,null,null,null,null,null,"5321D"]
[null,null,null,null,null,null,null,"5322D"]
[null,null,null,null,null,null,null,"5323D"]
[null,null,null,null,null,null,null,"5325D"]
[null,null,null,null,null,null,null,"5331D"]
[null,null,null,null,null,null,null,"5333D"]
[null,null,null,null,null,null,null,"5335D"]
[null,null,null,null,null,null,null,"5351B"]
[null,null,null,null,null,null,null,"5351C"]
[null,null,null,null,null,null,null,"5411A"]
[null,null,null,null,null,null,null,"5411B"]
[null,null,null,null,null,null,null,"5412A"]
[null,null,null,null,null,null,null,"5412B"]
[null,null,null,null,null,null,null,"5421D"]
[null,null,null,null,null,null,null,"5422D"]
[null,null,null,null,null,null,null,"5432D"]
[null,null,null,null,null,null,null,"5434D"]