{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["DD TUM"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":"DD TUM","index":0,"n_rows":51,"n_cols":17,"rows_kept":51,"cut":false,"hidden":false,"merged":[[47,1,47,4],[33,3,40,3],[28,6,29,10],[31,6,31,8],[31,9,31,10],[31,0,31,2],[31,3,31,4],[28,0,29,4],[42,6,42,7],[33,9,40,9],[41,0,41,1],[32,0,32,1],[47,7,47,10],[46,1,46,4],[46,7,46,10],[44,6,44,10],[21,0,21,1],[21,6,21,7],[42,0,42,1],[32,6,32,7],[41,6,41,7],[24,1,24,4],[24,7,24,10],[45,7,45,10],[26,1,26,4],[26,7,26,10],[25,1,25,4],[25,7,25,10],[44,0,44,4],[45,1,45,4],[25,13,25,16],[26,13,26,16],[7,12,8,16],[10,12,10,14],[10,15,10,16],[11,12,11,13],[12,15,19,15],[20,12,20,13],[21,12,21,13],[22,0,22,16],[20,0,20,1],[12,3,19,3],[12,9,19,9],[10,6,10,8],[10,9,10,10],[11,0,11,1],[4,11,4,13],[4,6,4,9],[0,0,0,16],[23,12,23,16],[24,13,24,16],[11,6,11,7],[10,0,10,2],[2,1,2,3],[2,6,2,9],[7,0,8,4],[7,6,8,10],[10,3,10,4],[4,1,4,3],[20,6,20,7],[23,0,23,4],[23,6,23,10]]}
["DD SHEET - FEUILLE DE DIFFICULTÉ - TUMBLING (TUM)"]
[null,"Name/Nom",null,null,null,null,"Club"]
[]
[null,"Gender/Genre",null,null,null,null,"Category/Categorie",null,null,null,null,"Event/Epreuve"]
[null,"Choose:",null,null,null,null,"Choose:",null,null,null,null,"Choose:"]
[null,{"$f":"LEFT(B4,2)","v":"Ge"}]
[]
["1st Pass / 1er passage (prelim.)",null,null,null,null,null,"2nd Pass / 2ème passage (prelim.)",null,null,null,null,null,"3rd Pass / 3ème passage (prelim.)"]
[]
[null,"Min DD:",{"$f":"MINTUMDD(B5,LEFT(G5,2),1)","v":""},"Max DD:",{"$f":"MAXTUMDD(B5,LEFT(G5,2),1)","v":""},null,null,"Min DD:",{"$f":"MINTUMDD(B5,LEFT(G5,2),2)","v":""},"Max DD:",{"$f":"MAXTUMDD(B5,LEFT(G5,2),2)","v":""},null,null,"Min DD:",{"$f":"MINTUMDD(B5,LEFT(G5,2),3)","v":""},"Max DD:",{"$f":"MAXTUMDD(B5,LEFT(G5,2),3)","v":""}]
["Athlete / Athlète",null,null,"Judges / Juges",null,null,"Athlete / Athlète",null,null,"Judges / Juges",null,null,"Athlete / Athlète",null,null,"Judges / Juges"]
["Elements",null,"DD",null,"DD",null,"Elements",null,"DD",null,"DD",null,"Elements",null,"DD",null,"DD"]
["1.",null,{"$f":"IF(OR(B13=\"\",LEFT($G$5,2)=\"L1\",LEFT($G$5,2)=\"L2\",LEFT($G$5,2)=\"L3\",LEFT($G$5,2)=\"L4\"),\"\",TUMDD(B13))","v":""},null,null,null,"1.",null,{"$f":"IF(OR(H13=\"\",AND(AND(H13<>\"(\",H13<>\"2\",H13<>\"^\",H13<>\"f\"),AND(AND(LEFT($G$5,2)<>\"L1\",LEFT($G$5,2)<>\"L2\",LEFT($G$5,2)<>\"L3\",LEFT($G$5,2)<>\"L4\"),OR(H13=B$20,H13=B$19,H13=B$18,H13=B$17,H13=B$16,H13=B$15,H13=B$14,H13=B$13)))),\"\",TUMDD(H13))","v":""},null,null,null,"1.",null,{"$f":"IF(N13=\"\",\"\",TUMDD(N13))","v":""}]
["2.",null,{"$f":"IF(OR(B14=\"\",LEFT($G$5,2)=\"L1\",LEFT($G$5,2)=\"L2\",LEFT($G$5,2)=\"L3\",LEFT($G$5,2)=\"L4\",AND(AND(B14<>\"(\",B14<>\"2\",B14<>\"^\",B14<>\"f\"),OR(B14=B13))),\"\",TUMDD(B14))","v":""},null,null,null,"2.",null,{"$f":"IF(OR(H14=\"\",AND(AND(H14<>\"(\",H14<>\"2\",H14<>\"^\",H14<>\"f\"),AND(AND(LEFT($G$5,2)<>\"L1\",LEFT($G$5,2)<>\"L2\",LEFT($G$5,2)<>\"L3\",LEFT($G$5,2)<>\"L4\"),OR(H14=H13,H14=B$20,H14=B$19,H14=B$18,H14=B$17,H14=B$16,H14=B$15,H14=B$14,H14=B$13)))),\"\",TUMDD(H14))","v":""},null,null,null,"2.",null,{"$f":"IF(OR(N14=\"\",AND(AND(N14<>\"(\",N14<>\"2\",N14<>\"^\",N14<>\"f\"),OR(N14=N13))),\"\",TUMDD(N14))","v":""}]
["3.",null,{"$f":"IF(OR(B15=\"\",LEFT($G$5,2)=\"L1\",LEFT($G$5,2)=\"L2\",LEFT($G$5,2)=\"L3\",LEFT($G$5,2)=\"L4\",AND(AND(B15<>\"(\",B15<>\"2\",B15<>\"^\",B15<>\"f\"),OR(B15=B14,B15=B13))),\"\",TUMDD(B15))","v":""},null,null,null,"3.",null,{"$f":"IF(OR(H15=\"\",AND(AND(H15<>\"(\",H15<>\"2\",H15<>\"^\",H15<>\"f\"),AND(AND(LEFT($G$5,2)<>\"L1\",LEFT($G$5,2)<>\"L2\",LEFT($G$5,2)<>\"L3\",LEFT($G$5,2)<>\"L4\"),OR(H15=H13,H15=H14,H15=B$20,H15=B$19,H15=B$18,H15=B$17,H15=B$16,H15=B$15,H15=B$14,H15=B$13)))),\"\",TUMDD(H15))","v":""},null,null,null,"3.",null,{"$f":"IF(OR(N15=\"\",AND(AND(N15<>\"(\",N15<>\"2\",N15<>\"^\",N15<>\"f\"),OR(N15=N13,N15=N14,))),\"\",TUMDD(N15))","v":""}]
["4.",null,{"$f":"IF(OR(B16=\"\",LEFT($G$5,2)=\"L1\",LEFT($G$5,2)=\"L2\",LEFT($G$5,2)=\"L3\",LEFT($G$5,2)=\"L4\",AND(AND(B16<>\"(\",B16<>\"2\",B16<>\"^\",B16<>\"f\"),OR(B16=B15,B16=B14,B16=B13))),\"\",TUMDD(B16))","v":""},null,null,null,"4.",null,{"$f":"IF(OR(H16=\"\",AND(AND(H16<>\"(\",H16<>\"2\",H16<>\"^\",H16<>\"f\"),AND(AND(LEFT($G$5,2)<>\"L1\",LEFT($G$5,2)<>\"L2\",LEFT($G$5,2)<>\"L3\",LEFT($G$5,2)<>\"L4\"),OR(H16=H13,H16=H14,H16=H15,H16=B$20,H16=B$19,H16=B$18,H16=B$17,H16=B$16,H16=B$15,H16=B$14,H16=B$13)))),\"\",TUMDD(H16))","v":""},null,null,null,"4.",null,{"$f":"IF(OR(N16=\"\",AND(AND(N16<>\"(\",N16<>\"2\",N16<>\"^\",N16<>\"f\"),OR(N16=N13,N16=N14,N16=N15))),\"\",TUMDD(N16))","v":""}]
["5.",null,{"$f":"IF(OR(B17=\"\",LEFT($G$5,2)=\"L1\",LEFT($G$5,2)=\"L2\",LEFT($G$5,2)=\"L3\",LEFT($G$5,2)=\"L4\",AND(AND(B17<>\"(\",B17<>\"2\",B17<>\"^\",B17<>\"f\"),OR(B17=B16,B17=B15,B17=B14,B17=B13))),\"\",TUMDD(B17))","v":""},null,null,null,"5.",null,{"$f":"IF(OR(H17=\"\",AND(AND(H17<>\"(\",H17<>\"2\",H17<>\"^\",H17<>\"f\"),AND(AND(LEFT($G$5,2)<>\"L1\",LEFT($G$5,2)<>\"L2\",LEFT($G$5,2)<>\"L3\",LEFT($G$5,2)<>\"L4\"),OR(H17=H13,H17=H14,H17=H15,H17=H16,H17=B$20,H17=B$19,H17=B$18,H17=B$17,H17=B$16,H17=B$15,H17=B$14,H17=B$13)))),\"\",TUMDD(H17))","v":""},null,null,null,"5.",null,{"$f":"IF(OR(N17=\"\",AND(AND(N17<>\"(\",N17<>\"2\",N17<>\"^\",N17<>\"f\"),OR(N17=N13,N17=N14,N17=N15,N17=N16))),\"\",TUMDD(N17))","v":""}]
["6.","",{"$f":"IF(OR(B18=\"\",LEFT($G$5,2)=\"L1\",LEFT($G$5,2)=\"L2\",LEFT($G$5,2)=\"L3\",LEFT($G$5,2)=\"L4\",AND(AND(B18<>\"(\",B18<>\"2\",B18<>\"^\",B18<>\"f\"),OR(B18=B17,B18=B16,B18=B15,B18=B14,B18=B13))),\"\",TUMDD(B18))","v":""},null,null,null,"6.",null,{"$f":"IF(OR(H18=\"\",AND(AND(H18<>\"(\",H18<>\"2\",H18<>\"^\",H18<>\"f\"),AND(AND(LEFT($G$5,2)<>\"L1\",LEFT($G$5,2)<>\"L2\",LEFT($G$5,2)<>\"L3\",LEFT($G$5,2)<>\"L4\"),OR(H18=H13,H18=H14,H18=H15,H18=H16,H18=H17,H18=B$20,H18=B$19,H18=B$18,H18=B$17,H18=B$16,H18=B$15,H18=B$14,H18=B$13)))),\"\",TUMDD(H18))","v":""},null,null,null,"6.",null,{"$f":"IF(OR(N18=\"\",AND(AND(N18<>\"(\",N18<>\"2\",N18<>\"^\",N18<>\"f\"),OR(N18=N13,N18=N14,N18=N15,N18=N16,N18=N17))),\"\",TUMDD(N18))","v":""}]
["7.","",{"$f":"IF(OR(B19=\"\",LEFT($G$5,2)=\"L1\",LEFT($G$5,2)=\"L2\",LEFT($G$5,2)=\"L3\",LEFT($G$5,2)=\"L4\",AND(AND(B19<>\"(\",B19<>\"2\",B19<>\"^\",B19<>\"f\"),OR(B19=B18,B19=B17,B19=B16,B19=B15,B19=B14,B19=B13))),\"\",TUMDD(B19))","v":""},null,null,null,"7.",null,{"$f":"IF(OR(H19=\"\",AND(AND(H19<>\"(\",H19<>\"2\",H19<>\"^\",H19<>\"f\"),AND(AND(LEFT($G$5,2)<>\"L1\",LEFT($G$5,2)<>\"L2\",LEFT($G$5,2)<>\"L3\",LEFT($G$5,2)<>\"L4\"),OR(H19=H13,H19=H14,H19=H15,H19=H16,H19=H17,H19=H18,H19=B$20,H19=B$19,H19=B$18,H19=B$17,H19=B$16,H19=B$15,H19=B$14,H19=B$13)))),\"\",TUMDD(H19))","v":""},null,null,null,"7.",null,{"$f":"IF(OR(N19=\"\",AND(AND(N19<>\"(\",N19<>\"2\",N19<>\"^\",N19<>\"f\"),OR(N19=N13,N19=N14,N19=N15,N19=N16,N19=N17,N19=N18))),\"\",TUMDD(N19))","v":""}]
["8.","",{"$f":"IF(OR(B20=\"\",LEFT($G$5,2)=\"L1\",LEFT($G$5,2)=\"L2\",LEFT($G$5,2)=\"L3\",LEFT($G$5,2)=\"L4\",AND(AND(B20<>\"(\",B20<>\"2\",B20<>\"^\",B20<>\"f\"),OR(B20=B19,B20=B18,B20=B17,B20=B16,B20=B15,B20=B14,B20=B13))),\"\",TUMDD(B20))","v":""},null,null,null,"8.",null,{"$f":"IF(OR(H20=\"\",AND(AND(H20<>\"(\",H20<>\"2\",H20<>\"^\",H20<>\"f\"),AND(AND(LEFT($G$5,2)<>\"L1\",LEFT($G$5,2)<>\"L2\",LEFT($G$5,2)<>\"L3\",LEFT($G$5,2)<>\"L4\"),OR(H20=H13,H20=H14,H20=H15,H20=H16,H20=H17,H20=H18,H20=H19,H20=B$20,H20=B$19,H20=B$18,H20=B$17,H20=B$16,H20=B$15,H20=B$14,H20=B$13)))),\"\",TUMDD(H20))","v":""},null,null,null,"8.",null,{"$f":"IF(OR(N20=\"\",AND(AND(N20<>\"(\",N20<>\"2\",N20<>\"^\",N20<>\"f\"),OR(N20=N13,N20=N14,N20=N15,N20=N16,N20=N17,N20=N18,N20=N19))),\"\",TUMDD(N20))","v":""}]
[{"$f":"IF(AND($B$5=\"Women/Femmes\",COUNTIF(C13:C20,\">=2\")>1),\"Total DD*\",\"Total DD\")","v":"Total DD"},null,{"$f":"IF(SUM(C13:C20)=0,\"\",SUM(C13:C20)+IF(AND($B$5=\"Women/Femmes\",COUNTIF(C13:C20,\">=2\")>1),COUNTIF(C13:C20,\">=2\")-1,0))","v":""},"Official DD",null,null,{"$f":"IF(AND($B$5=\"Women/Femmes\",COUNTIF(I13:I20,\">=2\")>1),\"Total DD*\",\"Total DD\")","v":"Total DD"},null,{"$f":"IF(SUM(I13:I20)=0,\"\",SUM(I13:I20)+IF(AND($B$5=\"Women/Femmes\",COUNTIF(I13:I20,\">=2\")>1),COUNTIF(I13:I20,\">=2\")-1,0))","v":""},"Official DD",null,null,{"$f":"IF(AND($B$5=\"Women/Femmes\",COUNTIF(O13:O20,\">=2\")>1),\"Total DD*\",\"Total DD\")","v":"Total DD"},null,{"$f":"IF(SUM(O13:O20)=0,\"\",SUM(O13:O20)+IF(AND($B$5=\"Women/Femmes\",COUNTIF(O13:O20,\">=2\")>1),COUNTIF(O13:O20,\">=2\")-1,0))","v":""},"Official DD"]
["Bonus",null,{"$f":"IF(C21=\"\",\"\",IF(LEFT($G$5,2)=\"L5\",SUMPRODUCT(--(LEN(B13:B20)=3),--(C13:C20<>\"\")),IF(OR(LEFT($G$5,2)=\"L6\",LEFT($G$5,2)=\"Ju\",LEFT($G$5,2)=\"L7\",AND($B$5=\"Women/Femmes\",LEFT($G$5,2)=\"Se\")),IF((SUMPRODUCT(--(B13:B19=\"1/\"),--(C13:C19<>\"\"))+SUMPRODUCT(--(B13:B19=\".1/\"),--(C13:C19<>\"\"))+SUMPRODUCT(--(B13:B19=\"1\"),--(C13:C19<>\"\"))+SUMPRODUCT(--(B13:B19=\".1\"),--(C13:C19<>\"\"))+SUMPRODUCT(--(B13:B19=\"2\"),--(C13:C19<>\"\"))+SUMPRODUCT(--(B13:B19=\"2.\"),--(C13:C19<>\"\"))+SUMPRODUCT(--(LEN(B13:B19)=3),--(C13:C19<>\"\")))*0.3>0.6,0.6,(SUMPRODUCT(--(B13:B19=\"1/\"),--(C13:C19<>\"\"))+SUMPRODUCT(--(B13:B19=\".1/\"),--(C13:C19<>\"\"))+SUMPRODUCT(--(B13:B19=\"1\"),--(C13:C19<>\"\"))+SUMPRODUCT(--(B13:B19=\".1\"),--(C13:C19<>\"\"))+SUMPRODUCT(--(B13:B19=\"2\"),--(C13:C19<>\"\"))+SUMPRODUCT(--(B13:B19=\"2.\"),--(C13:C19<>\"\"))+SUMPRODUCT(--(LEN(B13:B19)=3),--(C13:C19<>\"\")))*0.3),0)))","v":""},"Official Bonus",null,null,"Bonus",null,{"$f":"IF(I21=\"\",\"\",IF(LEFT($G$5,2)=\"L1\",IF(OR(COUNTIF(H14:H17,\"-o\")+COUNTIF(H14:H17,\"-<\")+COUNTIF(H14:H17,\"-/\")+COUNTIF(H14:H17,\"2\")),0.5,0),IF(OR(LEFT($G$5,2)=\"L2\",LEFT($G$5,2)=\"L3\",LEFT($G$5,2)=\"L4\"),IF(I21>=K10,0.3,0),IF(OR(LEFT($G$5,2)=\"L5\"),SUMPRODUCT(--(LEN(H13:H20)=3),--(I13:I20<>\"\")),IF(OR(LEFT($G$5,2)=\"L6\",LEFT($G$5,2)=\"Ju\",LEFT($G$5,2)=\"L7\",AND($B$5=\"Women/Femmes\",LEFT($G$5,2)=\"Se\")),IF((SUMPRODUCT(--(H13:H19=\"1/\"),--(I13:I19<>\"\"))+SUMPRODUCT(--(H13:H19=\".1/\"),--(I13:I19<>\"\"))+SUMPRODUCT(--(H13:H19=\"1\"),--(I13:I19<>\"\"))+SUMPRODUCT(--(H13:H19=\".1\"),--(I13:I19<>\"\"))+SUMPRODUCT(--(H13:H19=\"2\"),--(I13:I19<>\"\"))+SUMPRODUCT(--(H13:H19=\"2.\"),--(I13:I19<>\"\"))+SUMPRODUCT(--(LEN(H13:H19)=3),--(I13:I19<>\"\")))*0.3>0.6,0.6,(SUMPRODUCT(--(H13:H19=\"1/\"),--(I13:I19<>\"\"))+SUMPRODUCT(--(H13:H19=\".1/\"),--(I13:I19<>\"\"))+SUMPRODUCT(--(H13:H19=\"1\"),--(I13:I19<>\"\"))+SUMPRODUCT(--(H13:H19=\".1\"),--(I13:I19<>\"\"))+SUMPRODUCT(--(H13:H19=\"2\"),--(I13:I19<>\"\"))+SUMPRODUCT(--(H13:H19=\"2.\"),--(I13:I19<>\"\"))+SUMPRODUCT(--(LEN(H13:H19)=3),--(I13:I19<>\"\")))*0.3),0)))))","v":""},"Official Bonus",null,null,"Bonus",null,{"$f":"IF(O21=\"\",\"\",IF(LEFT($G$5,2)=\"L1\",IF(OR(COUNTIF(N14:N17,\"-o\")+COUNTIF(N14:N17,\"-<\")+COUNTIF(N14:N17,\"-/\")+COUNTIF(N14:N17,\"2\")),0.5,0),IF(OR(LEFT($G$5,2)=\"L2\",LEFT($G$5,2)=\"L3\",LEFT($G$5,2)=\"L4\"),IF(O21>=Q10,0.3,0),IF(OR(LEFT($G$5,2)=\"L5\"),SUMPRODUCT(--(LEN(N13:N20)=3),--(O13:O20<>\"\")),IF(OR(LEFT($G$5,2)=\"L6\",LEFT($G$5,2)=\"Ju\",LEFT($G$5,2)=\"L7\",AND($B$5=\"Women/Femmes\",LEFT($G$5,2)=\"Se\")),IF((SUMPRODUCT(--(N13:N19=\"1/\"),--(O13:O19<>\"\"))+SUMPRODUCT(--(N13:N19=\".1/\"),--(O13:O19<>\"\"))+SUMPRODUCT(--(N13:N19=\"1\"),--(O13:O19<>\"\"))+SUMPRODUCT(--(N13:N19=\".1\"),--(O13:O19<>\"\"))+SUMPRODUCT(--(N13:N19=\"2\"),--(O13:O19<>\"\"))+SUMPRODUCT(--(N13:N19=\"2.\"),--(O13:O19<>\"\"))+SUMPRODUCT(--(LEN(N13:N19)=3),--(O13:O19<>\"\")))*0.3>0.6,0.6,(SUMPRODUCT(--(N13:N19=\"1/\"),--(O13:O19<>\"\"))+SUMPRODUCT(--(N13:N19=\".1/\"),--(O13:O19<>\"\"))+SUMPRODUCT(--(N13:N19=\"1\"),--(O13:O19<>\"\"))+SUMPRODUCT(--(N13:N19=\".1\"),--(O13:O19<>\"\"))+SUMPRODUCT(--(N13:N19=\"2\"),--(O13:O19<>\"\"))+SUMPRODUCT(--(N13:N19=\"2.\"),--(O13:O19<>\"\"))+SUMPRODUCT(--(LEN(N13:N19)=3),--(O13:O19<>\"\")))*0.3),0)))))","v":""},"Official Bonus"]
["S E C T I O N   F O R   J U D G E S   O N L Y   -   S E C T I O N   P O U R   L E S   J U G E S   S E U L E M E N T"]
["Requirements:",null,null,null,null,null,"Requirements:",null,null,null,null,null,"Requirements:"]
[{"$f":"IF(B25<>\"\",\"r\",\"\")","v":""},{"$f":"IF(LEFT($G$5,2)=\"L1\",\"End with a straight jump\",IF(OR(LEFT($G$5,2)=\"L5\",LEFT($G$5,2)=\"L6\",LEFT($G$5,2)=\"L7\",LEFT($G$5,2)=\"Ju\"),\"Element with at least 360˚ twist (one prelim pass)\",IF(LEFT($G$5,2)=\"Se\",\"Minimum 1 Double\",\"\")))","v":""},null,null,null,null,{"$f":"IF(H25<>\"\",\"r\",\"\")","v":""},{"$f":"IF(LEFT($G$5,2)=\"L1\",\"Maximum 1 salto\",IF(LEFT($G$5,2)=\"L2\",\"Minimum 1 salto\",IF(LEFT($G$5,2)=\"L3\",\"Minimum 3 saltos\",IF(LEFT($G$5,2)=\"L4\",\"Minimum 4 saltos\",IF(OR(LEFT($G$5,2)=\"L5\",LEFT($G$5,2)=\"L6\",LEFT($G$5,2)=\"L7\",LEFT($G$5,2)=\"Ju\"),\"Element with at least 360˚ twist (one prelim pass)\",IF(LEFT($G$5,2)=\"Se\",\"Minimum 1 Double\",\"\"))))))","v":""},null,null,null,null,{"$f":"IF(N25<>\"\",\"r\",\"\")","v":""}]
[{"$f":"IF(B26<>\"\",\"r\",\"\")","v":""},{"$f":"IF(LEFT($G$5,2)=\"L5\",\"Element 1.1 or higher (one prelim pass, can combine)\",IF(AND(LEFT($G$5,2)=\"L7\",$B$5=\"Women/Femmes\"),\"Minimum 1 double (one prelim pass)\",IF(AND(LEFT($G$5,2)=\"L7\",$B$5=\"Men/Hommes\"),\"Minimum 1 double\",IF(LEFT($G$5,2)=\"Ju\",\"Element 2.0 or higher\",IF(AND(LEFT($G$5,2)=\"Se\",$B$5=\"Women/Femmes\"),\"Element 2.4 or higher (one prelim pass)\",IF(AND(LEFT($G$5,2)=\"Se\",$B$5=\"Men/Hommes\"),\"Element 2.4 or higher\",\"\"))))))","v":""},null,null,null,null,{"$f":"IF(H26<>\"\",\"r\",\"\")","v":""},{"$f":"IF(LEFT($G$5,2)=\"L1\",\"No element with twist\",IF(LEFT($G$5,2)=\"L2\",\"Maximum 2 saltos\",IF(LEFT($G$5,2)=\"L3\",\"Maximum 5 saltos\",IF(LEFT($G$5,2)=\"L4\",\"Maximum 2.0 per element\",IF(LEFT($G$5,2)=\"L5\",\"Element 1.1 or higher (one prelim pass, can combine)\",IF(AND(LEFT($G$5,2)=\"L7\",$B$5=\"Women/Femmes\"),\"Minimum 1 double (one prelim pass)\",IF(AND(LEFT($G$5,2)=\"L7\",$B$5=\"Men/Hommes\"),\"Minimum 1 double\",IF(AND(LEFT($G$5,2)=\"Se\",$B$5=\"Women/Femmes\"),\"Element 2.4 or higher (one prelim pass)\",IF(AND(LEFT($G$5,2)=\"Se\",$B$5=\"Men/Hommes\"),\"Element 2.4 or higher\",\"\")))))))))","v":""},null,null,null,null,{"$f":"IF(N26<>\"\",\"r\",\"\")","v":""}]
[{"$f":"IF(B27<>\"\",\"r\",\"\")","v":""},{"$f":"IF(LEFT($G$5,2)=\"L5\",\"Element 0.9 or higher (can combine)\",\"\")","v":""},null,null,null,null,{"$f":"IF(H27<>\"\",\"r\",\"\")","v":""},{"$f":"IF(LEFT($G$5,2)=\"L1\",\"End with straight jump or salto\",IF(OR(LEFT($G$5,2)=\"L2\",LEFT($G$5,2)=\"L3\"),\"Maximum 0.9 per element\",\"\"))","v":""},null,null,null,null,{"$f":"IF(N27<>\"\",\"r\",\"\")","v":""}]
[]
["1st Pass / 1er passage (finals)",null,null,null,null,null,"2nd Pass / 2ème passage (finals)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AND(AND(LEFT($G$5,2)<>\"L1\",LEFT($G$5,2)<>\"L2\",LEFT($G$5,2)<>\"L3\",LEFT($G$5,2)<>\"L4\"),SUMPRODUCT(--(B13:B20<>\"\"),--(C13:C20=\"\"))),SUMPRODUCT(--(H13:H20<>\"\"),--(I13:I20=\"\")),SUMPRODUCT(--(N13:N20<>\"\"),--(O13:O20=\"\")),SUMPRODUCT(--(B34:B41<>\"\"),--(C34:C41=\"\")),SUMPRODUCT(--(H34:H41<>\"\"),--(I34:I41=\"\"))),\"Repetitions\",\"\")","v":""}]
[null,"Min DD:",{"$f":"MINTUMDD(B5,LEFT(G5,2),4)","v":""},"Max DD:",{"$f":"MAXTUMDD(B5,LEFT(G5,2),4)","v":""},null,null,"Min DD:",{"$f":"MINTUMDD(B5,LEFT(G5,2),5)","v":""},"Max DD:",{"$f":"MAXTUMDD(B5,LEFT(G5,2),5)","v":""}]
["Athlete / Athlète",null,null,"Judges / Juges",null,null,"Athlete / Athlète",null,null,"Judges / Juges",null,null,null,null,null,{"$f":"IF(OR(AND(C21<>\"\",C21<C10),AND(I21<>\"\",I21<I10),AND(O21<>\"\",O21<O10),AND(C42<>\"\",C42<C31),AND(I42<>\"\",I42<I31)),\"Under Min\",\"\")","v":""}]
["Elements",null,"DD",null,"DD",null,"Elements",null,"DD",null,"DD"]
["1.",null,{"$f":"IF(B34=\"\",\"\",TUMDD(B34))","v":""},null,null,null,"1.",null,{"$f":"IF(OR(H34=\"\",AND(AND(H34<>\"(\",H34<>\"2\",H34<>\"^\",H34<>\"f\"),AND(LEFT($G$5,2)<>\"L3\",OR(H34=B$41,H34=B$40,H34=B$39,H34=B$38,H34=B$37,H34=B$36,H34=B$35,H34=B$34)))),\"\",TUMDD(H34))","v":""},null,null,null,null,null,null,{"$f":"IF(OR(AND(C21<>\"\",C21>E10),AND(I21<>\"\",I21>K10),AND(O21<>\"\",O21>Q10),AND(C42<>\"\",C42>E31),AND(I42<>\"\",I42>K31)),\"Over Max\",\"\")","v":""}]
["2.",null,{"$f":"IF(OR(B35=\"\",AND(AND(B35<>\"(\",B35<>\"2\",B35<>\"^\",B35<>\"f\"),OR(B35=B34))),\"\",TUMDD(B35))","v":""},null,null,null,"2.",null,{"$f":"IF(OR(H35=\"\",AND(AND(H35<>\"(\",H35<>\"2\",H35<>\"^\",H35<>\"f\"),AND(LEFT($G$5,2)<>\"L3\",OR(H35=B$41,H35=B$40,H35=B$39,H35=B$38,H35=B$37,H35=B$36,H35=B$35,H35=B$34,H35=H34)))),\"\",TUMDD(H35))","v":""}]
["3.",null,{"$f":"IF(OR(B36=\"\",AND(AND(B36<>\"(\",B36<>\"2\",B36<>\"^\",B36<>\"f\"),OR(B36=B35,B36=B34))),\"\",TUMDD(B36))","v":""},null,null,null,"3.",null,{"$f":"IF(OR(H36=\"\",AND(AND(H36<>\"(\",H36<>\"2\",H36<>\"^\",H36<>\"f\"),AND(LEFT($G$5,2)<>\"L3\",OR(H36=B$41,H36=B$40,H36=B$39,H36=B$38,H36=B$37,H36=B$36,H36=B$35,H36=B$34,H36=H35,H36=H34)))),\"\",TUMDD(H36))","v":""}]
["4.",null,{"$f":"IF(OR(B37=\"\",AND(AND(B37<>\"(\",B37<>\"2\",B37<>\"^\",B37<>\"f\"),OR(B37=B36,B37=B35,B37=B34))),\"\",TUMDD(B37))","v":""},null,null,null,"4.",null,{"$f":"IF(OR(H37=\"\",AND(AND(H37<>\"(\",H37<>\"2\",H37<>\"^\",H37<>\"f\"),OR(H37=B$41,H37=B$40,H37=B$39,H37=B$38,H37=B$37,H37=B$36,H37=B$35,H37=B$34,H37=H36,H37=H35,H37=H34))),\"\",TUMDD(H37))","v":""}]
["5.",null,{"$f":"IF(OR(B38=\"\",AND(AND(B38<>\"(\",B38<>\"2\",B38<>\"^\",B38<>\"f\"),OR(B38=B37,B38=B36,B38=B35,B38=B34))),\"\",TUMDD(B38))","v":""},null,null,null,"5.",null,{"$f":"IF(OR(H38=\"\",AND(AND(H38<>\"(\",H38<>\"2\",H38<>\"^\",H38<>\"f\"),OR(H38=B$41,H38=B$40,H38=B$39,H38=B$38,H38=B$37,H38=B$36,H38=B$35,H38=B$34,H38=H37,H38=H36,H38=H35,H38=H34))),\"\",TUMDD(H38))","v":""}]
["6.",null,{"$f":"IF(OR(B39=\"\",AND(AND(B39<>\"(\",B39<>\"2\",B39<>\"^\",B39<>\"f\"),OR(B39=B38,B39=B37,B39=B36,B39=B35,B39=B34))),\"\",TUMDD(B39))","v":""},null,null,null,"6.",null,{"$f":"IF(OR(H39=\"\",AND(AND(H39<>\"(\",H39<>\"2\",H39<>\"^\",H39<>\"f\"),OR(H39=B$41,H39=B$40,H39=B$39,H39=B$38,H39=B$37,H39=B$36,H39=B$35,H39=B$34,H39=H38,H39=H37,H39=H36,H39=H35,H39=H34))),\"\",TUMDD(H39))","v":""}]
["7.",null,{"$f":"IF(OR(B40=\"\",AND(AND(B40<>\"(\",B40<>\"2\",B40<>\"^\",B40<>\"f\"),OR(B40=B39,B40=B38,B40=B37,B40=B36,B40=B35,B40=B34))),\"\",TUMDD(B40))","v":""},null,null,null,"7.",null,{"$f":"IF(OR(H40=\"\",AND(AND(H40<>\"(\",H40<>\"2\",H40<>\"^\",H40<>\"f\"),OR(H40=B$41,H40=B$40,H40=B$39,H40=B$38,H40=B$37,H40=B$36,H40=B$35,H40=B$34,H40=H39,H40=H38,H40=H37,H40=H36,H40=H35,H40=H34))),\"\",TUMDD(H40))","v":""}]
["8.",null,{"$f":"IF(OR(B41=\"\",AND(AND(B41<>\"(\",B41<>\"2\",B41<>\"^\",B41<>\"f\"),OR(B41=B40,B41=B39,B41=B38,B41=B37,B41=B36,B41=B35,B41=B34))),\"\",TUMDD(B41))","v":""},null,null,null,"8.",null,{"$f":"IF(OR(H41=\"\",AND(AND(H41<>\"(\",H41<>\"2\",H41<>\"^\",H41<>\"f\"),OR(H41=B$41,H41=B$40,H41=B$39,H41=B$38,H41=B$37,H41=B$36,H41=B$35,H41=B$34,H41=H40,H41=H39,H41=H38,H41=H37,H41=H36,H41=H35,H41=H34))),\"\",TUMDD(H41))","v":""}]
[{"$f":"IF(AND($B$5=\"Women/Femmes\",COUNTIF(C34:C41,\">=2\")>1),\"Total DD*\",\"Total DD\")","v":"Total DD"},null,{"$f":"IF(SUM(C34:C41)=0,\"\",SUM(C34:C41)+IF(AND($B$5=\"Women/Femmes\",COUNTIF(C34:C41,\">=2\")>1),COUNTIF(C34:C41,\">=2\")-1,0))","v":""},"Official DD",null,null,{"$f":"IF(AND($B$5=\"Women/Femmes\",COUNTIF(I34:I41,\">=2\")>1),\"Total DD*\",\"Total DD\")","v":"Total DD"},null,{"$f":"IF(SUM(I34:I41)=0,\"\",SUM(I34:I41)+IF(AND($B$5=\"Women/Femmes\",COUNTIF(I34:I41,\">=2\")>1),COUNTIF(I34:I41,\">=2\")-1,0))","v":""},"Official DD"]
["Bonus",null,{"$f":"IF(C42=\"\",\"\",IF(LEFT($G$5,2)=\"L1\",IF(OR(COUNTIFS(B35:B38,\"-o\")+COUNTIF(B35:B38,\"-<\")+COUNTIF(B35:B38,\"-/\")+COUNTIF(B35:B38,\"2\")),0.5,0),IF(OR(LEFT($G$5,2)=\"L2\",LEFT($G$5,2)=\"L3\",LEFT($G$5,2)=\"L4\"),IF(C42>=E31,0.3,0),IF(OR(LEFT($G$5,2)=\"L5\"),SUMPRODUCT(--(LEN(B34:B41)=3),--(C34:C41<>\"\")),IF(OR(LEFT($G$5,2)=\"L6\",LEFT($G$5,2)=\"Ju\",LEFT($G$5,2)=\"L7\",AND($B$5=\"Women/Femmes\",LEFT($G$5,2)=\"Se\")),IF((SUMPRODUCT(--(B34:B40=\"1/\"),--(C34:C40<>\"\"))+SUMPRODUCT(--(B34:B40=\".1/\"),--(C34:C40<>\"\"))+SUMPRODUCT(--(B34:B40=\"1\"),--(C34:C40<>\"\"))+SUMPRODUCT(--(B34:B40=\".1\"),--(C34:C40<>\"\"))+SUMPRODUCT(--(B34:B40=\"2\"),--(C34:C40<>\"\"))+SUMPRODUCT(--(B34:B40=\"2.\"),--(C34:C40<>\"\"))+SUMPRODUCT(--(LEN(B34:B40)=3),--(C34:C40<>\"\")))*0.3>0.6,0.6,(SUMPRODUCT(--(B34:B40=\"1/\"),--(C34:C40<>\"\"))+SUMPRODUCT(--(B34:B40=\".1/\"),--(C34:C40<>\"\"))+SUMPRODUCT(--(B34:B40=\"1\"),--(C34:C40<>\"\"))+SUMPRODUCT(--(B34:B40=\".1\"),--(C34:C40<>\"\"))+SUMPRODUCT(--(B34:B40=\"2\"),--(C34:C40<>\"\"))+SUMPRODUCT(--(B34:B40=\"2.\"),--(C34:C40<>\"\"))+SUMPRODUCT(--(LEN(B34:B40)=3),--(C34:C40<>\"\")))*0.3),0)))))","v":""},"Official Bonus",null,null,"Bonus",null,{"$f":"IF(I42=\"\",\"\",IF(OR(LEFT($G$5,2)=\"L4\",LEFT($G$5,2)=\"L5\"),SUMPRODUCT(--(LEN(H34:H41)=3),--(I34:I41<>\"\")),IF(OR(LEFT($P$3,2)=\"L6\",LEFT($P$3,2)=\"Ju\",LEFT($P$3,2)=\"L7\",AND($B$5=\"Women/Femmes\",LEFT($P$3,2)=\"Se\")),IF((SUMPRODUCT(--(H34:H40=\"1/\"),--(I34:I40<>\"\"))+SUMPRODUCT(--(H34:H40=\".1/\"),--(I34:I40<>\"\"))+SUMPRODUCT(--(H34:H40=\"1\"),--(I34:I40<>\"\"))+SUMPRODUCT(--(H34:H40=\".1\"),--(I34:I40<>\"\"))+SUMPRODUCT(--(H34:H40=\"2\"),--(I34:I40<>\"\"))+SUMPRODUCT(--(H34:H40=\"2.\"),--(I34:I40<>\"\"))+SUMPRODUCT(--(LEN(H34:H40)=3),--(I34:I40<>\"\")))*0.3>0.6,0.6,(SUMPRODUCT(--(H34:H40=\"1/\"),--(I34:I40<>\"\"))+SUMPRODUCT(--(H34:H40=\".1/\"),--(I34:I40<>\"\"))+SUMPRODUCT(--(H34:H40=\"1\"),--(I34:I40<>\"\"))+SUMPRODUCT(--(H34:H40=\".1\"),--(I34:I40<>\"\"))+SUMPRODUCT(--(H34:H40=\"2\"),--(I34:I40<>\"\"))+SUMPRODUCT(--(H34:H40=\"2.\"),--(I34:I40<>\"\"))+SUMPRODUCT(--(LEN(H34:H40)=3),--(I34:I40<>\"\")))*0.3),0)))","v":""},"Official Bonus"]
["S E C T I O N   F O R   J U D G E S   O N L Y   -   S E C T I O N   P O U R   L E S   J U G E S   S E U L E M E N T"]
["Requirements:",null,null,null,null,null,"Requirements:"]
[{"$f":"IF(B46<>\"\",\"r\",\"\")","v":""},{"$f":"IF(LEFT($G$5,2)=\"L1\",\"Maximum 1 salto\",IF(LEFT($G$5,2)=\"L2\",\"Minimum 1 salto\",IF(LEFT($G$5,2)=\"L3\",\"Minimum 3 saltos\",IF(LEFT($G$5,2)=\"L4\",\"Minimum 4 saltos\",IF(LEFT($G$5,2)=\"L5\",\"Element 0.9 or higher\",\"\")))))","v":""},null,null,null,null,{"$f":"IF(H46<>\"\",\"r\",\"\")","v":""},{"$f":"IF(OR(LEFT($G$5,2)=\"L3\",LEFT($G$5,2)=\"L4\"),\"Minimum 1 salto\",IF(LEFT($G$5,2)=\"L5\",IF($L$5=\"Provincial\",\"Element 1.1 or higher\",\"Element 1.1 or higher (one finals pass)\"),\"\"))","v":""}]
[{"$f":"IF(B47<>\"\",\"r\",\"\")","v":""},{"$f":"IF(LEFT($G$5,2)=\"L1\",\"No element with twist\",IF(LEFT($G$5,2)=\"L2\",\"Maximum 2 saltos\",IF(LEFT($G$5,2)=\"L3\",\"Maximum 5 saltos\",IF(LEFT($G$5,2)=\"L4\",\"Maximum 2.0 per element\",IF(LEFT($G$5,2)=\"L5\",IF($L$5=\"Provincial\",\"\",\"Element 1.1 or higher (one finals pass, can combine)\"),\"\")))))","v":""},null,null,null,null,{"$f":"IF(H47<>\"\",\"r\",\"\")","v":""},{"$f":"IF(LEFT($G$5,2)=\"L3\",\"Maximum 1.3 per element\",IF(LEFT($G$5,2)=\"L4\",\"Maximum 2.2 per element\",\"\"))","v":""}]
[{"$f":"IF(B48<>\"\",\"r\",\"\")","v":""},{"$f":"IF(LEFT($G$5,2)=\"L1\",\"End with straight jump or salto\",IF(OR(LEFT($G$5,2)=\"L2\",LEFT($G$5,2)=\"L3\"),\"Maximum 0.9 per element\",\"\"))","v":""},null,null,null,null,{"$f":"IF(H48<>\"\",\"r\",\"\")","v":""}]
[]
[null,"Note: If using front and back skills with the same FIG code, use a period in front of front skills. For example, for front pike use .4-<"]
[null,"***DD Cards require macros to function, if you are not prompted by a message when opening you may need to enable macros under File > Info > Enable Content"]