{"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":27,"n_cols":23,"rows_kept":27,"cut":false,"hidden":false,"merged":[[19,18,19,19],[10,21,17,21],[18,18,18,19],[9,12,9,13],[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],[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],[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]]}
["DD SHEET - FEUILLE DE DIFFICULTÉ - TUMBLING (TUM)"]
[null,"Name/Nom",null,null,null,null,"Club",null,null,null,null,"Event/Epreuve",null,null,null,"Category/Categorie"]
[null,null,null,null,null,null,null,null,null,null,null,"Choose:",null,null,null,"Choose:"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"LEFT(L3,2)","v":"Ch"},null,null,null,{"$f":"LEFT(P3,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,{"$f":"IF(OR(P4=\"L3\",P4=\"L4\"),\"3rd Voluntary/3ème libre\",\"2nd Final / 2ème finale\")","v":"2nd Final / 2ème finale"}]
[]
[null,"Min DD:",{"$f":"MINTUMDD(L3,P4,1)","v":""},"Max DD:",{"$f":"MAXTUMDD(L3,P4,1)","v":""},null,null,"Min DD:",{"$f":"MINTUMDD(L3,P4,2)","v":""},"Max DD:",{"$f":"MAXTUMDD(L3,P4,2)","v":""},null,null,"Min DD:",{"$f":"MINTUMDD(L3,P4,3)","v":""},"Max DD:",{"$f":"MAXTUMDD(L3,P4,3)","v":""},null,null,"Min DD:",{"$f":"MINTUMDD(L3,P4,4)","v":""},"Max DD:",{"$f":"MAXTUMDD(L3,P4,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=\"\",$P$4=\"L1\",$P$4=\"L2\",$P$4=\"L3\",$P$4=\"L4\"),\"\",IF(AND(NUMTWISTS(B11)>1,$P$4=\"Se\"),0,TUMDD(B11)))","v":""},null,null,null,"1.",null,{"$f":"IF(H11=\"\",\"\",IF(AND(H11=B11,H11<>\"(\",H11<>\"f\",H11<>\"^\"),\"\",TUMDD(H11)))","v":""},null,null,null,"1.",null,{"$f":"IF(N11=\"\",\"\",TUMDD(N11))","v":""},null,null,null,"1.",null,{"$f":"IF(T11=\"\",\"\",IF(AND(T11=N11,T11<>\"(\",T11<>\"f\",T11<>\"^\"),\"\",TUMDD(T11)))","v":""}]
["2.",null,{"$f":"IF(OR(B12=\"\",$P$4=\"L1\",$P$4=\"L2\",$P$4=\"L3\",$P$4=\"L4\"),\"\",IF(AND(NUMTWISTS(B12)>1,$P$4=\"Se\"),0,TUMDD(B12)))","v":""},null,null,null,"2.",null,{"$f":"IF(H12=\"\",\"\",IF(AND(OR(AND(H12=B$17,H11=B$16),AND(H12=B$16,H11=B$15),AND(H12=B$15,H11=B$14),AND(H12=B$14,H11=B$13),AND(H12=B$13,H11=B$12),AND(H12=B$12,H11=B$11),AND(H12=B$18,H11=B$17)),H12<>\"(\",H12<>\"f\",H12<>\"^\"),\"\",TUMDD(H12)))","v":""},null,null,null,"2.",null,{"$f":"IF(N12=\"\",\"\",TUMDD(N12))","v":""},null,null,null,"2.",null,{"$f":"IF(T12=\"\",\"\",IF(AND(OR(AND(T12=N$17,T11=N$16),AND(T12=N$16,T11=N$15),AND(T12=N$15,T11=N$14),AND(T12=N$14,T11=N$13),AND(T12=N$13,T11=N$12),AND(T12=N$12,T11=N$11),AND(T12=N$18,T11=N$17)),T12<>\"(\",T12<>\"f\",T12<>\"^\"),\"\",TUMDD(T12)))","v":""}]
["3.",null,{"$f":"IF(OR(B13=\"\",$P$4=\"L1\",$P$4=\"L2\",$P$4=\"L3\",$P$4=\"L4\"),\"\",IF(AND(OR(AND(B13=B12,B12=B11)),B13<>\"(\",B13<>\"f\",B13<>\"^\"),\"\",IF(AND(NUMTWISTS(B13)>1,$P$4=\"Se\"),0,TUMDD(B13))))","v":""},null,null,null,"3.",null,{"$f":"IF(H13=\"\",\"\",IF(AND(OR(AND(H13=B$17,H12=B$16),AND(H13=B$16,H12=B$15),AND(H13=B$15,H12=B$14),AND(H13=B$14,H12=B$13),AND(H13=B$13,H12=B$12),AND(H13=B$12,H12=B$11),AND(H13=B$18,H12=B$17),AND(H13=H12,H12=H11)),H13<>\"(\",H13<>\"f\",H13<>\"^\"),\"\",TUMDD(H13)))","v":""},null,null,null,"3.",null,{"$f":"IF(N13=\"\",\"\",IF(AND(OR(AND(N13=N12,N12=N11)),N13<>\"(\",N13<>\"f\",N13<>\"^\"),\"\",TUMDD(N13)))","v":""},null,null,null,"3.",null,{"$f":"IF(T13=\"\",\"\",IF(AND(OR(AND(T13=N$17,T12=N$16),AND(T13=N$16,T12=N$15),AND(T13=N$15,T12=N$14),AND(T13=N$14,T12=N$13),AND(T13=N$13,T12=N$12),AND(T13=N$12,T12=N$11),AND(T13=N$18,T12=N$17),AND(T13=T12,T12=T11)),T13<>\"(\",T13<>\"f\",T13<>\"^\"),\"\",TUMDD(T13)))","v":""}]
["4.",null,{"$f":"IF(OR(B14=\"\",$P$4=\"L1\",$P$4=\"L2\",$P$4=\"L3\",$P$4=\"L4\"),\"\",IF(AND(OR(AND(B14=B13,B13=B12),AND(B14=B12,B13=B11)),B14<>\"(\",B14<>\"f\",B14<>\"^\"),\"\",IF(AND(NUMTWISTS(B14)>1,$P$4=\"Se\"),0,TUMDD(B14))))","v":""},null,null,null,"4.",null,{"$f":"IF(H14=\"\",\"\",IF(AND(OR(AND(H14=B$17,H13=B$16),AND(H14=B$16,H13=B$15),AND(H14=B$15,H13=B$14),AND(H14=B$14,H13=B$13),AND(H14=B$13,H13=B$12),AND(H14=B$12,H13=B$11),AND(H14=B$18,H13=B$17),AND(H14=H13,H13=H12),AND(H14=H12,H13=H11)),H14<>\"(\",H14<>\"f\",H14<>\"^\"),\"\",TUMDD(H14)))","v":""},null,null,null,"4.",null,{"$f":"IF(N14=\"\",\"\",IF(AND(OR(AND(N14=N13,N13=N12),AND(N14=N12,N13=N11)),N14<>\"(\",N14<>\"f\",N14<>\"^\"),\"\",TUMDD(N14)))","v":""},null,null,null,"4.",null,{"$f":"IF(T14=\"\",\"\",IF(AND(OR(AND(T14=N$17,T13=N$16),AND(T14=N$16,T13=N$15),AND(T14=N$15,T13=N$14),AND(T14=N$14,T13=N$13),AND(T14=N$13,T13=N$12),AND(T14=N$12,T13=N$11),AND(T14=N$18,T13=N$17),AND(T14=T13,T13=T12),AND(T14=T12,T13=T11)),T14<>\"(\",T14<>\"f\",T14<>\"^\"),\"\",TUMDD(T14)))","v":""}]
["5.",null,{"$f":"IF(OR(B15=\"\",$P$4=\"L1\",$P$4=\"L2\",$P$4=\"L3\",$P$4=\"L4\"),\"\",IF(AND(OR(AND(B15=B14,B14=B13),AND(B15=B13,B14=B12),AND(B15=B12,B14=B11)),B15<>\"(\",B15<>\"f\",B15<>\"^\"),\"\",IF(AND(NUMTWISTS(B15)>1,$P$4=\"Se\"),0,TUMDD(B15))))","v":""},null,null,null,"5.",null,{"$f":"IF(H15=\"\",\"\",IF(AND(OR(AND(H15=B$17,H14=B$16),AND(H15=B$16,H14=B$15),AND(H15=B$15,H14=B$14),AND(H15=B$14,H14=B$13),AND(H15=B$13,H14=B$12),AND(H15=B$12,H14=B$11),AND(H15=B$18,H14=B$17),AND(H15=H14,H14=H13),AND(H15=H13,H14=H12),AND(H15=H12,H14=H11)),H15<>\"(\",H15<>\"f\",H15<>\"^\"),\"\",TUMDD(H15)))","v":""},null,null,null,"5.",null,{"$f":"IF(N15=\"\",\"\",IF(AND(OR(AND(N15=N14,N14=N13),AND(N15=N13,N14=N12),AND(N15=N12,N14=N11)),N15<>\"(\",N15<>\"f\",N15<>\"^\"),\"\",TUMDD(N15)))","v":""},null,null,null,"5.",null,{"$f":"IF(T15=\"\",\"\",IF(AND(OR(AND(T15=N$17,T14=N$16),AND(T15=N$16,T14=N$15),AND(T15=N$15,T14=N$14),AND(T15=N$14,T14=N$13),AND(T15=N$13,T14=N$12),AND(T15=N$12,T14=N$11),AND(T15=N$18,T14=N$17),AND(T15=T14,T14=T13),AND(T15=T13,T14=T12),AND(T15=T12,T14=T11)),T15<>\"(\",T15<>\"f\",T15<>\"^\"),\"\",TUMDD(T15)))","v":""}]
["6.",null,{"$f":"IF(OR(B16=\"\",$P$4=\"L1\",$P$4=\"L2\",$P$4=\"L3\",$P$4=\"L4\"),\"\",IF(AND(OR(AND(B16=B15,B15=B14),AND(B16=B14,B15=B13),AND(B16=B13,B15=B12),AND(B16=B12,B15=B11)),B16<>\"(\",B16<>\"f\",B16<>\"^\"),\"\",IF(AND(NUMTWISTS(B16)>1,$P$4=\"Se\"),0,TUMDD(B16))))","v":""},null,null,null,"6.",null,{"$f":"IF(H16=\"\",\"\",IF(AND(OR(AND(H16=B$17,H15=B$16),AND(H16=B$16,H15=B$15),AND(H16=B$15,H15=B$14),AND(H16=B$14,H15=B$13),AND(H16=B$13,H15=B$12),AND(H16=B$12,H15=B$11),AND(H16=B$18,H15=B$17),AND(H16=H15,H15=H14),AND(H16=H14,H15=H13),AND(H16=H13,H15=H12),AND(H16=H12,H15=H11)),H16<>\"(\",H16<>\"f\",H16<>\"^\"),\"\",TUMDD(H16)))","v":""},null,null,null,"6.",null,{"$f":"IF(N16=\"\",\"\",IF(AND(OR(AND(N16=N15,N15=N14),AND(N16=N14,N15=N13),AND(N16=N13,N15=N12),AND(N16=N12,N15=N11)),N16<>\"(\",N16<>\"f\",N16<>\"^\"),\"\",TUMDD(N16)))","v":""},null,null,null,"6.",null,{"$f":"IF(T16=\"\",\"\",IF(AND(OR(AND(T16=N$17,T15=N$16),AND(T16=N$16,T15=N$15),AND(T16=N$15,T15=N$14),AND(T16=N$14,T15=N$13),AND(T16=N$13,T15=N$12),AND(T16=N$12,T15=N$11),AND(T16=N$18,T15=N$17),AND(T16=T15,T15=T14),AND(T16=T14,T15=T13),AND(T16=T13,T15=T12),AND(T16=T12,T15=T11)),T16<>\"(\",T16<>\"f\",T16<>\"^\"),\"\",TUMDD(T16)))","v":""}]
["7.",null,{"$f":"IF(OR(B17=\"\",$P$4=\"L1\",$P$4=\"L2\",$P$4=\"L3\",$P$4=\"L4\"),\"\",IF(AND(OR(AND(B17=B16,B16=B15),AND(B17=B15,B16=B14),AND(B17=B14,B16=B13),AND(B17=B13,B16=B12),AND(B17=B12,B16=B11)),B17<>\"(\",B17<>\"f\",B17<>\"^\"),\"\",IF(AND(NUMTWISTS(B17)>1,$P$4=\"Se\"),0,TUMDD(B17))))","v":""},null,null,null,"7.",null,{"$f":"IF(H17=\"\",\"\",IF(AND(OR(AND(H17=B$17,H16=B$16),AND(H17=B$16,H16=B$15),AND(H17=B$15,H16=B$14),AND(H17=B$14,H16=B$13),AND(H17=B$13,H16=B$12),AND(H17=B$12,H16=B$11),AND(H17=B$18,H16=B$17),AND(H17=H16,H16=H15),AND(H17=H15,H16=H14),AND(H17=H14,H16=H13),AND(H17=H13,H16=H12),AND(H17=H12,H16=H11)),H17<>\"(\",H17<>\"f\",H17<>\"^\"),\"\",TUMDD(H17)))","v":""},null,null,null,"7.",null,{"$f":"IF(N17=\"\",\"\",IF(AND(OR(AND(N17=N16,N16=N15),AND(N17=N15,N16=N14),AND(N17=N14,N16=N13),AND(N17=N13,N16=N12),AND(N17=N12,N16=N11)),N17<>\"(\",N17<>\"f\",N17<>\"^\"),\"\",TUMDD(N17)))","v":""},null,null,null,"7.",null,{"$f":"IF(T17=\"\",\"\",IF(AND(OR(AND(T17=N$17,T16=N$16),AND(T17=N$16,T16=N$15),AND(T17=N$15,T16=N$14),AND(T17=N$14,T16=N$13),AND(T17=N$13,T16=N$12),AND(T17=N$12,T16=N$11),AND(T17=N$18,T16=N$17),AND(T17=T16,T16=T15),AND(T17=T15,T16=T14),AND(T17=T14,T16=T13),AND(T17=T13,T16=T12),AND(T17=T12,T16=T11)),T17<>\"(\",T17<>\"f\",T17<>\"^\"),\"\",TUMDD(T17)))","v":""}]
["8.",null,{"$f":"IF(OR(B18=\"\",$P$4=\"L1\",$P$4=\"L2\",$P$4=\"L3\",$P$4=\"L4\"),\"\",IF(AND(OR(AND(B18=B17,B17=B16),AND(B18=B16,B17=B15),AND(B18=B15,B17=B14),AND(B18=B14,B17=B13),AND(B18=B13,B17=B12),AND(B18=B12,B17=B11)),B18<>\"(\",B18<>\"f\",B18<>\"^\"),\"\",IF(AND(NUMTWISTS(B18)>1,$P$4=\"Se\"),0,TUMDD(B18))))","v":""},null,null,null,"8.",null,{"$f":"IF(H18=\"\",\"\",IF(AND(OR(AND(H18=B$17,H17=B$16),AND(H18=B$16,H17=B$15),AND(H18=B$15,H17=B$14),AND(H18=B$14,H17=B$13),AND(H18=B$13,H17=B$12),AND(H18=B$12,H17=B$11),AND(H18=B$18,H17=B$17),AND(H18=H17,H17=H16),AND(H18=H16,H17=H15),AND(H18=H15,H17=H14),AND(H18=H14,H17=H13),AND(H18=H13,H17=H12),AND(H18=H12,H17=H11)),H18<>\"(\",H18<>\"f\",H18<>\"^\"),\"\",IF(AND(NUMTWISTS(H18)<2,$P$4=\"Se\"),0,TUMDD(H18))))","v":""},null,null,null,"8.",null,{"$f":"IF(N18=\"\",\"\",IF(AND(OR(AND(N18=N17,N17=N16),AND(N18=N16,N17=N15),AND(N18=N15,N17=N14),AND(N18=N14,N17=N13),AND(N18=N13,N17=N12),AND(N18=N12,N17=N11)),N18<>\"(\",N18<>\"f\",N18<>\"^\"),\"\",TUMDD(N18)))","v":""},null,null,null,"8.",null,{"$f":"IF(T18=\"\",\"\",IF(AND(OR(AND(T18=N$17,T17=N$16),AND(T18=N$16,T17=N$15),AND(T18=N$15,T17=N$14),AND(T18=N$14,T17=N$13),AND(T18=N$13,T17=N$12),AND(T18=N$12,T17=N$11),AND(T18=N$18,T17=N$17),AND(T18=T17,T17=T16),AND(T18=T16,T17=T15),AND(T18=T15,T17=T14),AND(T18=T14,T17=T13),AND(T18=T13,T17=T12),AND(T18=T12,T17=T11)),T18<>\"(\",T18<>\"f\",T18<>\"^\"),\"\",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($P$4=\"L5\",SUMPRODUCT(--(LEN(B11:B18)=3),--(C11:C18<>\"\")),IF(OR($P$4=\"L6\",$P$4=\"Ju\",$P$4=\"L7\",AND($L$3=\"Women/Femmes\",$P$4=\"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(OR($P$4=\"L2\",$P$4=\"L3\",$P$4=\"L4\"),IF(I19>=K8,0.3,0),IF(OR($P$4=\"L5\"),SUMPRODUCT(--(LEN(H11:H18)=3),--(I11:I18<>\"\")),IF(OR($P$4=\"L6\",$P$4=\"Ju\",$P$4=\"L7\",AND($L$3=\"Women/Femmes\",$P$4=\"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(OR($P$4=\"L2\",$P$4=\"L3\",$P$4=\"L4\"),IF(O19>=Q8,0.3,0),IF(OR($P$4=\"L5\"),SUMPRODUCT(--(LEN(N11:N18)=3),--(O11:O18<>\"\")),IF(OR($P$4=\"L6\",$P$4=\"Ju\",$P$4=\"L7\",AND($L$3=\"Women/Femmes\",$P$4=\"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($P$4=\"L4\",$P$4=\"L5\"),SUMPRODUCT(--(LEN(T11:T18)=3),--(U11:U18<>\"\")),IF(OR($P$4=\"L6\",$P$4=\"Ju\",$P$4=\"L7\",AND($L$3=\"Women/Femmes\",$P$4=\"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($P$4=\"L1\",\"End with a straight jump\",IF($P$4=\"L5\",\"Element 1.1 or higher (one prelim pass)\",IF(OR($P$4=\"L6\",$P$4=\"L7\"),\"Element with at least 360˚ twist (one prelim pass)\",IF($P$4=\"Ju\",\"Element 2.0 or higher\",IF($P$4=\"Se\",\"1 Double\",\"\")))))","v":""},null,null,null,null,{"$f":"IF(H23<>\"\",\"r\",\"\")","v":""},{"$f":"IF($P$4=\"L1\",\"Maximum 1 salto\",IF($P$4=\"L2\",\"Minimum 1 salto\",IF($P$4=\"L3\",\"Minimum 3 saltos\",IF($P$4=\"L4\",\"Minimum 4 saltos\",IF($P$4=\"L5\",\"Element 1.1 or higher (one prelim pass)\",IF(OR($P$4=\"L6\",$P$4=\"L7\"),\"Element with at least 360˚ twist (one prelim pass)\",IF($P$4=\"Ju\",\"Element with at least 360˚ twist\",IF($P$4=\"Se\",\"1 Double\",\"\"))))))))","v":""},null,null,null,null,{"$f":"IF(N23<>\"\",\"r\",\"\")","v":""},{"$f":"IF($P$4=\"L1\",\"Maximum 1 salto\",IF($P$4=\"L2\",\"Minimum 1 salto\",IF($P$4=\"L3\",\"Minimum 3 saltos\",IF($P$4=\"L4\",\"Minimum 4 saltos\",IF($P$4=\"L5\",\"Element 0.9 or higher\",\"\")))))","v":""},null,null,null,null,{"$f":"IF(T23<>\"\",\"r\",\"\")","v":""},{"$f":"IF(OR($P$4=\"L3\",$P$4=\"L4\"),\"Minimum 1 salto\",IF($P$4=\"L5\",\"Element 1.1 or higher\",\"\"))","v":""}]
[{"$f":"IF(B24<>\"\",\"r\",\"\")","v":""},{"$f":"IF($P$4=\"L5\",\"Element 0.9 or higher (can combine)\",IF($P$4=\"Se\",\"No element with more than 180˚ twist\",\"\"))","v":""},null,null,null,null,{"$f":"IF(H24<>\"\",\"r\",\"\")","v":""},{"$f":"IF($P$4=\"L1\",\"No element with twist\",IF($P$4=\"L2\",\"Maximum 2 saltos\",IF($P$4=\"L3\",\"Maximum 5 saltos\",IF($P$4=\"L4\",\"Maximum 2.0 per element\",IF($P$4=\"L5\",\"Element with at least 360˚ twist (can combine)\",IF($P$4=\"Se\",\"8th element with at least 360˚ twist\",\"\"))))))","v":""},null,null,null,null,{"$f":"IF(N24<>\"\",\"r\",\"\")","v":""},{"$f":"IF($P$4=\"L1\",\"No element with twist\",IF($P$4=\"L2\",\"Maximum 2 saltos\",IF($P$4=\"L3\",\"Maximum 5 saltos\",IF($P$4=\"L4\",\"Maximum 2.0 per element\",\"\"))))","v":""},null,null,null,null,{"$f":"IF(T24<>\"\",\"r\",\"\")","v":""},{"$f":"IF($P$4=\"L3\",\"Maximum 1.3 per element\",IF($P$4=\"L4\",\"Maximum 2.2 per element\",\"\"))","v":""}]
[{"$f":"IF(B25<>\"\",\"r\",\"\")","v":""},null,null,null,null,null,{"$f":"IF(H25<>\"\",\"r\",\"\")","v":""},{"$f":"IF($P$4=\"L1\",\"End with straight jump or salto\",IF(OR($P$4=\"L2\",$P$4=\"L3\"),\"Maximum 0.9 per element\",\"\"))","v":""},null,null,null,null,{"$f":"IF(N25<>\"\",\"r\",\"\")","v":""},{"$f":"IF($P$4=\"L1\",\"End with straight jump or salto\",IF(OR($P$4=\"L2\",$P$4=\"L3\"),\"Maximum 0.9 per element\",\"\"))","v":""},null,null,null,null,{"$f":"IF(T25<>\"\",\"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-<"]