{"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":29,"n_cols":23,"rows_kept":29,"cut":false,"hidden":false,"merged":[[18,0,18,1],[18,12,18,13],[18,6,18,7],[22,19,22,22],[24,1,24,4],[24,7,24,10],[23,1,23,4],[23,7,23,10],[21,12,21,16],[22,13,22,16],[21,0,21,4],[21,6,21,10],[20,0,20,22],[19,0,19,1],[19,6,19,7],[19,12,19,13],[10,3,17,3],[10,9,17,9],[8,6,8,8],[9,18,9,19],[24,19,24,22],[23,13,23,16],[23,19,23,22],[21,18,21,22],[22,1,22,4],[22,7,22,10],[24,13,24,16],[10,15,17,15],[8,9,8,10],[9,0,9,1],[9,6,9,7],[8,0,8,2],[0,0,0,22],[5,18,6,22],[8,18,8,20],[8,21,8,22],[2,1,2,3],[8,12,8,14],[8,15,8,16],[2,6,2,9],[2,11,2,13],[5,0,6,4],[5,6,6,10],[8,3,8,4],[5,12,6,16],[19,18,19,19],[10,21,17,21],[18,18,18,19],[9,12,9,13],[2,18,2,20]]}
["DD SHEET - FEUILLE DE DIFFICULTÉ - TUMBLING (TUM)"]
[null,"Name/Nom",null,null,null,null,"Club",null,null,null,null,"Gender/Genre",null,null,null,"Category/Categorie",null,null,"Event/Epreuve"]
[null,null,null,null,null,null,null,null,null,null,null,"Choose:",null,null,null,"Choose:",null,null,"Choose:"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"LEFT(L3,2)","v":"Ch"}]
[]
["1st Voluntary / 1ère libre",null,null,null,null,null,"2nd Voluntary / 2ème libre",null,null,null,null,null,"1st Final / 1ère finale",null,null,null,null,null,"2nd Final / 2ème finale"]
[]
[null,"Min DD:",{"$f":"MINTUMDD(L3,LEFT(P3,2),1)","v":""},"Max DD:",{"$f":"MAXTUMDD(L3,LEFT(P3,2),1)","v":""},null,null,"Min DD:",{"$f":"MINTUMDD(L3,LEFT(P3,2),2)","v":""},"Max DD:",{"$f":"MAXTUMDD(L3,LEFT(P3,2),2)","v":""},null,null,"Min DD:",{"$f":"MINTUMDD(L3,LEFT(P3,2),3)","v":""},"Max DD:",{"$f":"MAXTUMDD(L3,LEFT(P3,2),3)","v":""},null,null,"Min DD:",{"$f":"MINTUMDD(L3,LEFT(P3,2),4)","v":""},"Max DD:",{"$f":"MAXTUMDD(L3,LEFT(P3,2),4)","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",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",null,"Elements",null,"DD",null,"DD"]
["1.",null,{"$f":"IF(OR(B11=\"\",LEFT($P$3,2)=\"L1\",LEFT($P$3,2)=\"L2\",LEFT($P$3,2)=\"L3\",LEFT($P$3,2)=\"L4\"),\"\",TUMDD(B11))","v":""},null,null,null,"1.",null,{"$f":"IF(OR(H11=\"\",AND(AND(H11<>\"(\",H11<>\"2\",H11<>\"^\",H11<>\"f\"),AND(AND(LEFT($P$3,2)<>\"L1\",LEFT($P$3,2)<>\"L2\",LEFT($P$3,2)<>\"L3\",LEFT($P$3,2)<>\"L4\"),OR(H11=B$18,H11=B$17,H11=B$16,H11=B$15,H11=B$14,H11=B$13,H11=B$12,H11=B$11)))),\"\",TUMDD(H11))","v":""},null,null,null,"1.",null,{"$f":"IF(N11=\"\",\"\",TUMDD(N11))","v":""},null,null,null,"1.",null,{"$f":"IF(OR(T11=\"\",AND(AND(T11<>\"(\",T11<>\"2\",T11<>\"^\",T11<>\"f\"),AND(LEFT($P$3,2)<>\"L3\",OR(T11=N$18,T11=N$17,T11=N$16,T11=N$15,T11=N$14,T11=N$13,T11=N$12,T11=N$11)))),\"\",TUMDD(T11))","v":""}]
["2.",null,{"$f":"IF(OR(B12=\"\",LEFT($P$3,2)=\"L1\",LEFT($P$3,2)=\"L2\",LEFT($P$3,2)=\"L3\",LEFT($P$3,2)=\"L4\",AND(AND(B12<>\"(\",B12<>\"2\",B12<>\"^\",B12<>\"f\"),OR(B12=B11))),\"\",TUMDD(B12))","v":""},null,null,null,"2.",null,{"$f":"IF(OR(H12=\"\",AND(AND(H12<>\"(\",H12<>\"2\",H12<>\"^\",H12<>\"f\"),AND(AND(LEFT($P$3,2)<>\"L1\",LEFT($P$3,2)<>\"L2\",LEFT($P$3,2)<>\"L3\",LEFT($P$3,2)<>\"L4\"),OR(H12=H11,H12=B$18,H12=B$17,H12=B$16,H12=B$15,H12=B$14,H12=B$13,H12=B$12,H12=B$11)))),\"\",TUMDD(H12))","v":""},null,null,null,"2.",null,{"$f":"IF(OR(N12=\"\",AND(AND(N12<>\"(\",N12<>\"2\",N12<>\"^\",N12<>\"f\"),OR(N12=N11))),\"\",TUMDD(N12))","v":""},null,null,null,"2.",null,{"$f":"IF(OR(T12=\"\",AND(AND(T12<>\"(\",T12<>\"2\",T12<>\"^\",T12<>\"f\"),AND(LEFT($P$3,2)<>\"L3\",OR(T12=N$18,T12=N$17,T12=N$16,T12=N$15,T12=N$14,T12=N$13,T12=N$12,T12=N$11,T12=T11)))),\"\",TUMDD(T12))","v":""}]
["3.",null,{"$f":"IF(OR(B13=\"\",LEFT($P$3,2)=\"L1\",LEFT($P$3,2)=\"L2\",LEFT($P$3,2)=\"L3\",LEFT($P$3,2)=\"L4\",AND(AND(B13<>\"(\",B13<>\"2\",B13<>\"^\",B13<>\"f\"),OR(B13=B12,B13=B11))),\"\",TUMDD(B13))","v":""},null,null,null,"3.",null,{"$f":"IF(OR(H13=\"\",AND(AND(H13<>\"(\",H13<>\"2\",H13<>\"^\",H13<>\"f\"),AND(AND(LEFT($P$3,2)<>\"L1\",LEFT($P$3,2)<>\"L2\",LEFT($P$3,2)<>\"L3\",LEFT($P$3,2)<>\"L4\"),OR(H13=H11,H13=H12,H13=B$18,H13=B$17,H13=B$16,H13=B$15,H13=B$14,H13=B$13,H13=B$12,H13=B$11)))),\"\",TUMDD(H13))","v":""},null,null,null,"3.",null,{"$f":"IF(OR(N13=\"\",AND(AND(N13<>\"(\",N13<>\"2\",N13<>\"^\",N13<>\"f\"),OR(N13=N12,N13=N11))),\"\",TUMDD(N13))","v":""},null,null,null,"3.",null,{"$f":"IF(OR(T13=\"\",AND(AND(T13<>\"(\",T13<>\"2\",T13<>\"^\",T13<>\"f\"),AND(LEFT($P$3,2)<>\"L3\",OR(T13=N$18,T13=N$17,T13=N$16,T13=N$15,T13=N$14,T13=N$13,T13=N$12,T13=N$11,T13=T12,T13=T11)))),\"\",TUMDD(T13))","v":""}]
["4.",null,{"$f":"IF(OR(B14=\"\",LEFT($P$3,2)=\"L1\",LEFT($P$3,2)=\"L2\",LEFT($P$3,2)=\"L3\",LEFT($P$3,2)=\"L4\",AND(AND(B14<>\"(\",B14<>\"2\",B14<>\"^\",B14<>\"f\"),OR(B14=B13,B14=B12,B14=B11))),\"\",TUMDD(B14))","v":""},null,null,null,"4.",null,{"$f":"IF(OR(H14=\"\",AND(AND(H14<>\"(\",H14<>\"2\",H14<>\"^\",H14<>\"f\"),AND(AND(LEFT($P$3,2)<>\"L1\",LEFT($P$3,2)<>\"L2\",LEFT($P$3,2)<>\"L3\",LEFT($P$3,2)<>\"L4\"),OR(H14=H11,H14=H12,H14=H13,H14=B$18,H14=B$17,H14=B$16,H14=B$15,H14=B$14,H14=B$13,H14=B$12,H14=B$11)))),\"\",TUMDD(H14))","v":""},null,null,null,"4.",null,{"$f":"IF(OR(N14=\"\",AND(AND(N14<>\"(\",N14<>\"2\",N14<>\"^\",N14<>\"f\"),OR(N14=N13,N14=N12,N14=N11))),\"\",TUMDD(N14))","v":""},null,null,null,"4.",null,{"$f":"IF(OR(T14=\"\",AND(AND(T14<>\"(\",T14<>\"2\",T14<>\"^\",T14<>\"f\"),OR(T14=N$18,T14=N$17,T14=N$16,T14=N$15,T14=N$14,T14=N$13,T14=N$12,T14=N$11,T14=T13,T14=T12,T14=T11))),\"\",TUMDD(T14))","v":""}]
["5.",null,{"$f":"IF(OR(B15=\"\",LEFT($P$3,2)=\"L1\",LEFT($P$3,2)=\"L2\",LEFT($P$3,2)=\"L3\",LEFT($P$3,2)=\"L4\",AND(AND(B15<>\"(\",B15<>\"2\",B15<>\"^\",B15<>\"f\"),OR(B15=B14,B15=B13,B15=B12,B15=B11))),\"\",TUMDD(B15))","v":""},null,null,null,"5.",null,{"$f":"IF(OR(H15=\"\",AND(AND(H15<>\"(\",H15<>\"2\",H15<>\"^\",H15<>\"f\"),AND(AND(LEFT($P$3,2)<>\"L1\",LEFT($P$3,2)<>\"L2\",LEFT($P$3,2)<>\"L3\",LEFT($P$3,2)<>\"L4\"),OR(H15=H11,H15=H12,H15=H13,H15=H14,H15=B$18,H15=B$17,H15=B$16,H15=B$15,H15=B$14,H15=B$13,H15=B$12,H15=B$11)))),\"\",TUMDD(H15))","v":""},null,null,null,"5.",null,{"$f":"IF(OR(N15=\"\",AND(AND(N15<>\"(\",N15<>\"2\",N15<>\"^\",N15<>\"f\"),OR(N15=N14,N15=N13,N15=N12,N15=N11))),\"\",TUMDD(N15))","v":""},null,null,null,"5.",null,{"$f":"IF(OR(T15=\"\",AND(AND(T15<>\"(\",T15<>\"2\",T15<>\"^\",T15<>\"f\"),OR(T15=N$18,T15=N$17,T15=N$16,T15=N$15,T15=N$14,T15=N$13,T15=N$12,T15=N$11,T15=T14,T15=T13,T15=T12,T15=T11))),\"\",TUMDD(T15))","v":""}]
["6.","",{"$f":"IF(OR(B16=\"\",LEFT($P$3,2)=\"L1\",LEFT($P$3,2)=\"L2\",LEFT($P$3,2)=\"L3\",LEFT($P$3,2)=\"L4\",AND(AND(B16<>\"(\",B16<>\"2\",B16<>\"^\",B16<>\"f\"),OR(B16=B15,B16=B14,B16=B13,B16=B12,B16=B11))),\"\",TUMDD(B16))","v":""},null,null,null,"6.",null,{"$f":"IF(OR(H16=\"\",AND(AND(H16<>\"(\",H16<>\"2\",H16<>\"^\",H16<>\"f\"),AND(AND(LEFT($P$3,2)<>\"L1\",LEFT($P$3,2)<>\"L2\",LEFT($P$3,2)<>\"L3\",LEFT($P$3,2)<>\"L4\"),OR(H16=H11,H16=H12,H16=H13,H16=H14,H16=H15,H16=B$18,H16=B$17,H16=B$16,H16=B$15,H16=B$14,H16=B$13,H16=B$12,H16=B$11)))),\"\",TUMDD(H16))","v":""},null,null,null,"6.",null,{"$f":"IF(OR(N16=\"\",AND(AND(N16<>\"(\",N16<>\"2\",N16<>\"^\",N16<>\"f\"),OR(N16=N15,N16=N14,N16=N13,N16=N12,N16=N11))),\"\",TUMDD(N16))","v":""},null,null,null,"6.",null,{"$f":"IF(OR(T16=\"\",AND(AND(T16<>\"(\",T16<>\"2\",T16<>\"^\",T16<>\"f\"),OR(T16=N$18,T16=N$17,T16=N$16,T16=N$15,T16=N$14,T16=N$13,T16=N$12,T16=N$11,T16=T15,T16=T14,T16=T13,T16=T12,T16=T11))),\"\",TUMDD(T16))","v":""}]
["7.","",{"$f":"IF(OR(B17=\"\",LEFT($P$3,2)=\"L1\",LEFT($P$3,2)=\"L2\",LEFT($P$3,2)=\"L3\",LEFT($P$3,2)=\"L4\",AND(AND(B17<>\"(\",B17<>\"2\",B17<>\"^\",B17<>\"f\"),OR(B17=B16,B17=B15,B17=B14,B17=B13,B17=B12,B17=B11))),\"\",TUMDD(B17))","v":""},null,null,null,"7.",null,{"$f":"IF(OR(H17=\"\",AND(AND(H17<>\"(\",H17<>\"2\",H17<>\"^\",H17<>\"f\"),AND(AND(LEFT($P$3,2)<>\"L1\",LEFT($P$3,2)<>\"L2\",LEFT($P$3,2)<>\"L3\",LEFT($P$3,2)<>\"L4\"),OR(H17=H11,H17=H12,H17=H13,H17=H14,H17=H15,H17=H16,H17=B$18,H17=B$17,H17=B$16,H17=B$15,H17=B$14,H17=B$13,H17=B$12,H17=B$11)))),\"\",TUMDD(H17))","v":""},null,null,null,"7.",null,{"$f":"IF(OR(N17=\"\",AND(AND(N17<>\"(\",N17<>\"2\",N17<>\"^\",N17<>\"f\"),OR(N17=N16,N17=N15,N17=N14,N17=N13,N17=N12,N17=N11))),\"\",TUMDD(N17))","v":""},null,null,null,"7.",null,{"$f":"IF(OR(T17=\"\",AND(AND(T17<>\"(\",T17<>\"2\",T17<>\"^\",T17<>\"f\"),OR(T17=N$18,T17=N$17,T17=N$16,T17=N$15,T17=N$14,T17=N$13,T17=N$12,T17=N$11,T17=T16,T17=T15,T17=T14,T17=T13,T17=T12,T17=T11))),\"\",TUMDD(T17))","v":""}]
["8.","",{"$f":"IF(OR(B18=\"\",LEFT($P$3,2)=\"L1\",LEFT($P$3,2)=\"L2\",LEFT($P$3,2)=\"L3\",LEFT($P$3,2)=\"L4\",AND(AND(B18<>\"(\",B18<>\"2\",B18<>\"^\",B18<>\"f\"),OR(B18=B17,B18=B16,B18=B15,B18=B14,B18=B13,B18=B12,B18=B11))),\"\",TUMDD(B18))","v":""},null,null,null,"8.",null,{"$f":"IF(OR(H18=\"\",AND(AND(H18<>\"(\",H18<>\"2\",H18<>\"^\",H18<>\"f\"),AND(AND(LEFT($P$3,2)<>\"L1\",LEFT($P$3,2)<>\"L2\",LEFT($P$3,2)<>\"L3\",LEFT($P$3,2)<>\"L4\"),OR(H18=H11,H18=H12,H18=H13,H18=H14,H18=H15,H18=H16,H18=H17,H18=B$18,H18=B$17,H18=B$16,H18=B$15,H18=B$14,H18=B$13,H18=B$12,H18=B$11)))),\"\",TUMDD(H18))","v":""},null,null,null,"8.",null,{"$f":"IF(OR(N18=\"\",AND(AND(N18<>\"(\",N18<>\"2\",N18<>\"^\",N18<>\"f\"),OR(N18=N17,N18=N16,N18=N15,N18=N14,N18=N13,N18=N12,N18=N11))),\"\",TUMDD(N18))","v":""},null,null,null,"8.",null,{"$f":"IF(OR(T18=\"\",AND(AND(T18<>\"(\",T18<>\"2\",T18<>\"^\",T18<>\"f\"),OR(T18=N$18,T18=N$17,T18=N$16,T18=N$15,T18=N$14,T18=N$13,T18=N$12,T18=N$11,T18=T17,T18=T16,T18=T15,T18=T14,T18=T13,T18=T12,T18=T11))),\"\",TUMDD(T18))","v":""}]
[{"$f":"IF(AND($L$3=\"Women/Femmes\",COUNTIF(C11:C18,\">=2\")>1),\"Total DD*\",\"Total DD\")","v":"Total DD"},null,{"$f":"IF(SUM(C11:C18)=0,\"\",SUM(C11:C18)+IF(AND($L$3=\"Women/Femmes\",COUNTIF(C11:C18,\">=2\")>1),COUNTIF(C11:C18,\">=2\")-1,0))","v":""},"Official DD",null,null,{"$f":"IF(AND($L$3=\"Women/Femmes\",COUNTIF(I11:I18,\">=2\")>1),\"Total DD*\",\"Total DD\")","v":"Total DD"},null,{"$f":"IF(SUM(I11:I18)=0,\"\",SUM(I11:I18)+IF(AND($L$3=\"Women/Femmes\",COUNTIF(I11:I18,\">=2\")>1),COUNTIF(I11:I18,\">=2\")-1,0))","v":""},"Official DD",null,null,{"$f":"IF(AND($L$3=\"Women/Femmes\",COUNTIF(O11:O18,\">=2\")>1),\"Total DD*\",\"Total DD\")","v":"Total DD"},null,{"$f":"IF(SUM(O11:O18)=0,\"\",SUM(O11:O18)+IF(AND($L$3=\"Women/Femmes\",COUNTIF(O11:O18,\">=2\")>1),COUNTIF(O11:O18,\">=2\")-1,0))","v":""},"Official DD",null,null,{"$f":"IF(AND($L$3=\"Women/Femmes\",COUNTIF(U11:U18,\">=2\")>1),\"Total DD*\",\"Total DD\")","v":"Total DD"},null,{"$f":"IF(SUM(U11:U18)=0,\"\",SUM(U11:U18)+IF(AND($L$3=\"Women/Femmes\",COUNTIF(U11:U18,\">=2\")>1),COUNTIF(U11:U18,\">=2\")-1,0))","v":""},"Official DD"]
["Bonus",null,{"$f":"IF(C19=\"\",\"\",IF(LEFT($P$3,2)=\"L5\",SUMPRODUCT(--(LEN(B11:B18)=3),--(C11:C18<>\"\")),IF(OR(LEFT($P$3,2)=\"L6\",LEFT($P$3,2)=\"Ju\",LEFT($P$3,2)=\"L7\",AND($L$3=\"Women/Femmes\",LEFT($P$3,2)=\"Se\")),IF((SUMPRODUCT(--(B11:B17=\"1/\"),--(C11:C17<>\"\"))+SUMPRODUCT(--(B11:B17=\".1/\"),--(C11:C17<>\"\"))+SUMPRODUCT(--(B11:B17=\"1\"),--(C11:C17<>\"\"))+SUMPRODUCT(--(B11:B17=\".1\"),--(C11:C17<>\"\"))+SUMPRODUCT(--(B11:B17=\"2\"),--(C11:C17<>\"\"))+SUMPRODUCT(--(B11:B17=\"2.\"),--(C11:C17<>\"\"))+SUMPRODUCT(--(LEN(B11:B17)=3),--(C11:C17<>\"\")))*0.3>0.6,0.6,(SUMPRODUCT(--(B11:B17=\"1/\"),--(C11:C17<>\"\"))+SUMPRODUCT(--(B11:B17=\".1/\"),--(C11:C17<>\"\"))+SUMPRODUCT(--(B11:B17=\"1\"),--(C11:C17<>\"\"))+SUMPRODUCT(--(B11:B17=\".1\"),--(C11:C17<>\"\"))+SUMPRODUCT(--(B11:B17=\"2\"),--(C11:C17<>\"\"))+SUMPRODUCT(--(B11:B17=\"2.\"),--(C11:C17<>\"\"))+SUMPRODUCT(--(LEN(B11:B17)=3),--(C11:C17<>\"\")))*0.3),0)))","v":""},"Official Bonus",null,null,"Bonus",null,{"$f":"IF(I19=\"\",\"\",IF(LEFT($P$3,2)=\"L1\",IF(OR(COUNTIFS(H12:H15,\"-o\")+COUNTIF(H12:H15,\"-<\")+COUNTIF(H12:H15,\"-/\")+COUNTIF(H12:H15,\"2\")),0.5,0),IF(OR(LEFT($P$3,2)=\"L2\",LEFT($P$3,2)=\"L3\",LEFT($P$3,2)=\"L4\"),IF(I19>=K8,0.3,0),IF(OR(LEFT($P$3,2)=\"L5\"),SUMPRODUCT(--(LEN(H11:H18)=3),--(I11:I18<>\"\")),IF(OR(LEFT($P$3,2)=\"L6\",LEFT($P$3,2)=\"Ju\",LEFT($P$3,2)=\"L7\",AND($L$3=\"Women/Femmes\",LEFT($P$3,2)=\"Se\")),IF((SUMPRODUCT(--(H11:H17=\"1/\"),--(I11:I17<>\"\"))+SUMPRODUCT(--(H11:H17=\".1/\"),--(I11:I17<>\"\"))+SUMPRODUCT(--(H11:H17=\"1\"),--(I11:I17<>\"\"))+SUMPRODUCT(--(H11:H17=\".1\"),--(I11:I17<>\"\"))+SUMPRODUCT(--(H11:H17=\"2\"),--(I11:I17<>\"\"))+SUMPRODUCT(--(H11:H17=\"2.\"),--(I11:I17<>\"\"))+SUMPRODUCT(--(LEN(H11:H17)=3),--(I11:I17<>\"\")))*0.3>0.6,0.6,(SUMPRODUCT(--(H11:H17=\"1/\"),--(I11:I17<>\"\"))+SUMPRODUCT(--(H11:H17=\".1/\"),--(I11:I17<>\"\"))+SUMPRODUCT(--(H11:H17=\"1\"),--(I11:I17<>\"\"))+SUMPRODUCT(--(H11:H17=\".1\"),--(I11:I17<>\"\"))+SUMPRODUCT(--(H11:H17=\"2\"),--(I11:I17<>\"\"))+SUMPRODUCT(--(H11:H17=\"2.\"),--(I11:I17<>\"\"))+SUMPRODUCT(--(LEN(H11:H17)=3),--(I11:I17<>\"\")))*0.3),0)))))","v":""},"Official Bonus",null,null,"Bonus",null,{"$f":"IF(O19=\"\",\"\",IF(LEFT($P$3,2)=\"L1\",IF(OR(COUNTIFS(N12:N15,\"-o\")+COUNTIF(N12:N15,\"-<\")+COUNTIF(N12:N15,\"-/\")+COUNTIF(N12:N15,\"2\")),0.5,0),IF(OR(LEFT($P$3,2)=\"L2\",LEFT($P$3,2)=\"L3\",LEFT($P$3,2)=\"L4\"),IF(O19>=Q8,0.3,0),IF(OR(LEFT($P$3,2)=\"L5\"),SUMPRODUCT(--(LEN(N11:N18)=3),--(O11:O18<>\"\")),IF(OR(LEFT($P$3,2)=\"L6\",LEFT($P$3,2)=\"Ju\",LEFT($P$3,2)=\"L7\",AND($L$3=\"Women/Femmes\",LEFT($P$3,2)=\"Se\")),IF((SUMPRODUCT(--(N11:N17=\"1/\"),--(O11:O17<>\"\"))+SUMPRODUCT(--(N11:N17=\".1/\"),--(O11:O17<>\"\"))+SUMPRODUCT(--(N11:N17=\"1\"),--(O11:O17<>\"\"))+SUMPRODUCT(--(N11:N17=\".1\"),--(O11:O17<>\"\"))+SUMPRODUCT(--(N11:N17=\"2\"),--(O11:O17<>\"\"))+SUMPRODUCT(--(N11:N17=\"2.\"),--(O11:O17<>\"\"))+SUMPRODUCT(--(LEN(N11:N17)=3),--(O11:O17<>\"\")))*0.3>0.6,0.6,(SUMPRODUCT(--(N11:N17=\"1/\"),--(O11:O17<>\"\"))+SUMPRODUCT(--(N11:N17=\".1/\"),--(O11:O17<>\"\"))+SUMPRODUCT(--(N11:N17=\"1\"),--(O11:O17<>\"\"))+SUMPRODUCT(--(N11:N17=\".1\"),--(O11:O17<>\"\"))+SUMPRODUCT(--(N11:N17=\"2\"),--(O11:O17<>\"\"))+SUMPRODUCT(--(N11:N17=\"2.\"),--(O11:O17<>\"\"))+SUMPRODUCT(--(LEN(N11:N17)=3),--(O11:O17<>\"\")))*0.3),0)))))","v":""},"Official Bonus",null,null,"Bonus",null,{"$f":"IF(U19=\"\",\"\",IF(OR(LEFT($P$3,2)=\"L4\",LEFT($P$3,2)=\"L5\"),SUMPRODUCT(--(LEN(T11:T18)=3),--(U11:U18<>\"\")),IF(OR(LEFT($P$3,2)=\"L6\",LEFT($P$3,2)=\"Ju\",LEFT($P$3,2)=\"L7\",AND($L$3=\"Women/Femmes\",LEFT($P$3,2)=\"Se\")),IF((SUMPRODUCT(--(T11:T17=\"1/\"),--(U11:U17<>\"\"))+SUMPRODUCT(--(T11:T17=\".1/\"),--(U11:U17<>\"\"))+SUMPRODUCT(--(T11:T17=\"1\"),--(U11:U17<>\"\"))+SUMPRODUCT(--(T11:T17=\".1\"),--(U11:U17<>\"\"))+SUMPRODUCT(--(T11:T17=\"2\"),--(U11:U17<>\"\"))+SUMPRODUCT(--(T11:T17=\"2.\"),--(U11:U17<>\"\"))+SUMPRODUCT(--(LEN(T11:T17)=3),--(U11:U17<>\"\")))*0.3>0.6,0.6,(SUMPRODUCT(--(T11:T17=\"1/\"),--(U11:U17<>\"\"))+SUMPRODUCT(--(T11:T17=\".1/\"),--(U11:U17<>\"\"))+SUMPRODUCT(--(T11:T17=\"1\"),--(U11:U17<>\"\"))+SUMPRODUCT(--(T11:T17=\".1\"),--(U11:U17<>\"\"))+SUMPRODUCT(--(T11:T17=\"2\"),--(U11:U17<>\"\"))+SUMPRODUCT(--(T11:T17=\"2.\"),--(U11:U17<>\"\"))+SUMPRODUCT(--(LEN(T11:T17)=3),--(U11:U17<>\"\")))*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:",null,null,null,null,null,"Requirements:"]
[{"$f":"IF(B23<>\"\",\"r\",\"\")","v":""},{"$f":"IF(LEFT($P$3,2)=\"L1\",\"End with a straight jump\",IF(OR(LEFT($P$3,2)=\"L5\",LEFT($P$3,2)=\"L6\",LEFT($P$3,2)=\"L7\",LEFT($P$3,2)=\"Ju\"),\"Element with at least 360˚ twist (one prelim pass)\",IF(LEFT($P$3,2)=\"Se\",\"Minimum 1 Double\",\"\")))","v":""},null,null,null,null,{"$f":"IF(H23<>\"\",\"r\",\"\")","v":""},{"$f":"IF(LEFT($P$3,2)=\"L1\",\"Maximum 1 salto\",IF(LEFT($P$3,2)=\"L2\",\"Minimum 1 salto\",IF(LEFT($P$3,2)=\"L3\",\"Minimum 3 saltos\",IF(LEFT($P$3,2)=\"L4\",\"Minimum 4 saltos\",IF(OR(LEFT($P$3,2)=\"L5\",LEFT($P$3,2)=\"L6\",LEFT($P$3,2)=\"L7\",LEFT($P$3,2)=\"Ju\"),\"Element with at least 360˚ twist (one prelim pass)\",IF(LEFT($P$3,2)=\"Se\",\"Minimum 1 Double\",\"\"))))))","v":""},null,null,null,null,{"$f":"IF(N23<>\"\",\"r\",\"\")","v":""},{"$f":"IF(LEFT($P$3,2)=\"L1\",\"Maximum 1 salto\",IF(LEFT($P$3,2)=\"L2\",\"Minimum 1 salto\",IF(LEFT($P$3,2)=\"L3\",\"Minimum 3 saltos\",IF(LEFT($P$3,2)=\"L4\",\"Minimum 4 saltos\",IF(LEFT($P$3,2)=\"L5\",\"Element 0.9 or higher\",\"\")))))","v":""},null,null,null,null,{"$f":"IF(T23<>\"\",\"r\",\"\")","v":""},{"$f":"IF(OR(LEFT($P$3,2)=\"L3\",LEFT($P$3,2)=\"L4\"),\"Minimum 1 salto\",IF(LEFT($P$3,2)=\"L5\",IF($S$3=\"Provincial\",\"Element 1.1 or higher\",\"Element 1.1 or higher (one finals pass)\"),\"\"))","v":""}]
[{"$f":"IF(B24<>\"\",\"r\",\"\")","v":""},{"$f":"IF(LEFT($P$3,2)=\"L5\",\"Element 1.1 or higher (one prelim pass, can combine)\",IF(AND(LEFT($P$3,2)=\"L7\",$L$3=\"Women/Femmes\"),\"Minimum 1 double (one prelim pass)\",IF(AND(LEFT($P$3,2)=\"L7\",$L$3=\"Men/Hommes\"),\"Minimum 1 double\",IF(LEFT($P$3,2)=\"Ju\",\"Element 2.0 or higher\",IF(AND(LEFT($P$3,2)=\"Se\",$L$3=\"Women/Femmes\"),\"Element 2.4 or higher (one prelim pass)\",IF(AND(LEFT($P$3,2)=\"Se\",$L$3=\"Men/Hommes\"),\"Element 2.4 or higher\",\"\"))))))","v":""},null,null,null,null,{"$f":"IF(H24<>\"\",\"r\",\"\")","v":""},{"$f":"IF(LEFT($P$3,2)=\"L1\",\"No element with twist\",IF(LEFT($P$3,2)=\"L2\",\"Maximum 2 saltos\",IF(LEFT($P$3,2)=\"L3\",\"Maximum 5 saltos\",IF(LEFT($P$3,2)=\"L4\",\"Maximum 2.0 per element\",IF(LEFT($P$3,2)=\"L5\",\"Element 1.1 or higher (one prelim pass, can combine)\",IF(AND(LEFT($P$3,2)=\"L7\",$L$3=\"Women/Femmes\"),\"Minimum 1 double (one prelim pass)\",IF(AND(LEFT($P$3,2)=\"L7\",$L$3=\"Men/Hommes\"),\"Minimum 1 double\",IF(AND(LEFT($P$3,2)=\"Se\",$L$3=\"Women/Femmes\"),\"Element 2.4 or higher (one prelim pass)\",IF(AND(LEFT($P$3,2)=\"Se\",$L$3=\"Men/Hommes\"),\"Element 2.4 or higher\",\"\")))))))))","v":""},null,null,null,null,{"$f":"IF(N24<>\"\",\"r\",\"\")","v":""},{"$f":"IF(LEFT($P$3,2)=\"L1\",\"No element with twist\",IF(LEFT($P$3,2)=\"L2\",\"Maximum 2 saltos\",IF(LEFT($P$3,2)=\"L3\",\"Maximum 5 saltos\",IF(LEFT($P$3,2)=\"L4\",\"Maximum 2.0 per element\",IF(LEFT($P$3,2)=\"L5\",IF($S$3=\"Provincial\",\"\",\"Element 1.1 or higher (one finals pass, can combine)\"),\"\")))))","v":""},null,null,null,null,{"$f":"IF(T24<>\"\",\"r\",\"\")","v":""},{"$f":"IF(LEFT($P$3,2)=\"L3\",\"Maximum 1.3 per element\",IF(LEFT($P$3,2)=\"L4\",\"Maximum 2.2 per element\",\"\"))","v":""}]
[{"$f":"IF(B25<>\"\",\"r\",\"\")","v":""},{"$f":"IF(LEFT($P$3,2)=\"L5\",\"Element 0.9 or higher (can combine)\",\"\")","v":""},null,null,null,null,{"$f":"IF(H25<>\"\",\"r\",\"\")","v":""},{"$f":"IF(LEFT($P$3,2)=\"L1\",\"End with straight jump or salto\",IF(OR(LEFT($P$3,2)=\"L2\",LEFT($P$3,2)=\"L3\"),\"Maximum 0.9 per element\",\"\"))","v":""},null,null,null,null,{"$f":"IF(N25<>\"\",\"r\",\"\")","v":""},{"$f":"IF(LEFT($P$3,2)=\"L1\",\"End with straight jump or salto\",IF(OR(LEFT($P$3,2)=\"L2\",LEFT($P$3,2)=\"L3\"),\"Maximum 0.9 per element\",\"\"))","v":""},null,null,null,null,{"$f":"IF(T25<>\"\",\"r\",\"\")","v":""}]
[]
[null,{"$f":"IF(OR(AND(AND(LEFT($P$3,2)<>\"L1\",LEFT($P$3,2)<>\"L2\",LEFT($P$3,2)<>\"L3\",LEFT($P$3,2)<>\"L4\"),SUMPRODUCT(--(B11:B18<>\"\"),--(C11:C18=\"\"))),SUMPRODUCT(--(H11:H18<>\"\"),--(I11:I18=\"\")),SUMPRODUCT(--(N11:N18<>\"\"),--(O11:O18=\"\")),SUMPRODUCT(--(T11:T18<>\"\"),--(U11:U18=\"\"))),\"Repetitions\",\"\")","v":""},null,{"$f":"IF(OR(AND(C19<>\"\",C19<C8),AND(I19<>\"\",I19<I8),AND(O19<>\"\",O19<O8),AND(U19<>\"\",U19<U8)),\"Under Min\",\"\")","v":""},null,null,null,{"$f":"IF(OR(AND(C19<>\"\",C19>E8),AND(I19<>\"\",I19>K8),AND(O19<>\"\",O19>Q8),AND(U19<>\"\",U19>W8)),\"Over Max\",\"\")","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-<"]