{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["DD DMT"],"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 DMT","index":0,"n_rows":24,"n_cols":25,"rows_kept":24,"cut":false,"hidden":false,"merged":[[18,18,18,24],[19,19,19,24],[18,0,18,4],[19,1,19,4],[18,6,18,10],[19,7,19,10],[18,12,18,16],[19,13,19,16],[8,21,8,23],[9,9,11,9],[9,15,11,15],[9,21,11,23],[12,21,12,23],[7,15,7,16],[7,18,7,20],[5,12,6,16],[5,18,6,24],[7,12,7,14],[7,21,7,24],[9,3,11,3],[16,13,16,16],[16,19,16,24],[17,13,17,16],[17,19,17,24],[15,12,15,16],[15,18,15,24],[13,21,13,23],[1,18,1,19],[16,1,16,4],[17,1,17,4],[16,7,16,10],[17,7,17,10],[2,6,2,9],[2,1,2,3],[12,0,12,1],[12,6,12,7],[8,0,8,1],[8,6,8,7],[7,0,7,2],[15,0,15,4],[15,6,15,10],[13,6,13,7],[13,0,13,1],[21,1,21,3],[2,18,2,19],[0,0,0,24],[14,0,14,24],[5,0,6,4],[5,6,6,10],[7,3,7,4],[7,6,7,8],[7,9,7,10],[2,11,2,13],[8,12,8,13],[8,18,8,19],[13,12,13,13],[13,18,13,19],[12,12,12,13],[12,18,12,19]]}
["DD SHEET - FEUILLE DE DIFFICULTÉ - DOUBLE MINI (DMT)"]
[null,"Name/Nom",null,null,null,null,"Club",null,null,null,null,"Event/Epreuve",null,null,null,"Category/Categorie",null,null,"Rules / Règle",null,null,"Min DD",null,"Max DD"]
[null,null,null,null,null,null,null,null,null,null,null,"Choose:",null,null,null,"Choose:",null,null,"Choose:",null,null,{"$f":"MINDMTDD(L3,P4)","v":""},null,{"$f":"MAXDMTDD(L3,P4)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LEFT(P3,2)","v":"Ch"}]
[]
["1st pass / 1er passage (prelim.)",null,null,null,null,null,"2nd Pass / 2ème passage (prelim.)",null,null,null,null,null,"1st Pass / 1er passage (finals)",null,null,null,null,null,"2nd Pass / 2ème passage (finals)"]
[]
["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,null,null,"DD"]
["M",null,{"$f":"IF(B10=\"\",\"\",DMTDD(B10))","v":""},null,null,null,"M","",{"$f":"IF(OR(H10=\"\",H10=B10),\"\",DMTDD(H10))","v":""},null,null,null,"M","",{"$f":"IF(OR(N10=\"\",N10=B10,N10=H10),\"\",DMTDD(N10))","v":""},null,null,null,"M","",{"$f":"IF(OR(T10=\"\",T10=B10,T10=H10,T10=N10),\"\",DMTDD(T10))","v":""}]
["S",null,{"$f":"IF(OR(B11=\"\",C10<>\"\",P4=\"Ju\",P4=\"Se\"),\"\",DMTDD(B11))","v":""},null,null,null,"S",null,{"$f":"IF(OR(H11=\"\",I10<>\"\",P4=\"Ju\",P4=\"Se\",H11=B11,AND(OR(P4=\"L3\",P4=\"L4\",P4=\"L5\",P4=\"L6\",P4=\"L7\"),C11<>\"\",C11>0)),\"\",DMTDD(H11))","v":""},null,null,null,"S","",{"$f":"IF(OR(N11=\"\",O10<>\"\",N11=B11,N11=H11),\"\",DMTDD(N11))","v":""},null,null,null,"S","",{"$f":"IF(OR(T11=\"\",U10<>\"\",T11=B11,T11=H11,T11=N11),\"\",DMTDD(T11))","v":""}]
["D",null,{"$f":"IF(B12=\"\",\"\",DMTDD(B12))","v":""},null,null,null,"D","",{"$f":"IF(OR(H12=\"\",H12=B12),\"\",DMTDD(H12))","v":""},null,null,null,"D","",{"$f":"IF(OR(N12=\"\",N12=B12,N12=H12),\"\",DMTDD(N12))","v":""},null,null,null,"D","",{"$f":"IF(OR(T12=\"\",T12=B12,T12=H12,T12=N12),\"\",DMTDD(T12))","v":""}]
["Total DD",null,{"$f":"IF(SUM(C10:C12)=0,\"\",SUM(C10:C12))","v":""},"Official DD",null,null,"Total DD",null,{"$f":"IF(SUM(I10:I12)=0,\"\",SUM(I10:I12))","v":""},"Official DD",null,null,"Total DD",null,{"$f":"IF(SUM(O10:O12)=0,\"\",SUM(O10:O12))","v":""},"Official DD",null,null,"Total DD",null,{"$f":"IF(SUM(U10:U12)=0,\"\",SUM(U10:U12))","v":""},"Official DD"]
["Bonus",null,{"$f":"IF(C13=\"\",\"\",IF($P$4=\"L2\",IF(AND(MID(B10,1,2)=\"41\",C10<>\"\"),0.7,0),IF(AND($L$3=\"Women/Femmes\",OR($P$4=\"L6\",$P$4=\"L7\")),IF(AND(C10<>\"\",OR(B10=\"8-1<\",B10=\"801<\")),0.3,0),IF(AND($L$3=\"Women/Femmes\",$P$4=\"Se\"),IF(DUBTWISTS(B10)>2,0.3,0)+IF(DUBTWISTS(B12)>2,0.3,0),IF(AND($L$3=\"Men/Hommes\",$P$4=\"Se\"),COUNTIF(C10:C12,\">=4.8\")*0.3,0)))))","v":""},"Official Bonus",null,null,"Bonus",null,{"$f":"IF(I13=\"\",\"\",IF($P$4=\"L2\",IF(AND(MID(H10,1,2)=\"41\",I10<>\"\"),0.7,0),IF(AND($L$3=\"Women/Femmes\",OR($P$4=\"L6\",$P$4=\"L7\")),IF(AND(I10<>\"\",OR(H10=\"8-1<\",H10=\"801<\")),0.3,0),IF(AND($L$3=\"Women/Femmes\",$P$4=\"Se\"),IF(DUBTWISTS(H10)>2,0.3,0)+IF(DUBTWISTS(H12)>2,0.3,0),IF(AND($L$3=\"Men/Hommes\",$P$4=\"Se\"),COUNTIF(I10:I12,\">=4.8\")*0.3,0)))))","v":""},"Official Bonus",null,null,"Bonus",null,{"$f":"IF(O13=\"\",\"\",IF($P$4=\"L2\",IF(AND(MID(N10,1,2)=\"41\",O10<>\"\"),0.7,0),IF(AND($L$3=\"Women/Femmes\",OR($P$4=\"L6\",$P$4=\"L7\")),IF(AND(O10<>\"\",OR(N10=\"8-1<\",N10=\"801<\")),0.3,0),IF(AND($L$3=\"Women/Femmes\",$P$4=\"Se\"),IF(DUBTWISTS(N10)>2,0.3,0)+IF(DUBTWISTS(N12)>2,0.3,0),IF(AND($L$3=\"Men/Hommes\",$P$4=\"Se\"),COUNTIF(O10:O12,\">=4.8\")*0.3,0)))))","v":""},"Official Bonus",null,null,"Bonus",null,{"$f":"IF(U13=\"\",\"\",IF($P$4=\"L2\",IF(AND(MID(T10,1,2)=\"41\",U10<>\"\"),0.7,0),IF(AND($L$3=\"Women/Femmes\",OR($P$4=\"L6\",$P$4=\"L7\")),IF(AND(U10<>\"\",OR(T10=\"8-1<\",T10=\"801<\")),0.3,0),IF(AND($L$3=\"Women/Femmes\",$P$4=\"Se\"),IF(DUBTWISTS(T10)>2,0.3,0)+IF(DUBTWISTS(T12)>2,0.3,0),IF(AND($L$3=\"Men/Hommes\",$P$4=\"Se\"),COUNTIF(U10:U12,\">=4.8\")*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(B17<>\"\",\"r\",\"\")","v":""},{"$f":"IF($P$4=\"L1\",\"Element 0.5 or higher\",IF($P$4=\"L2\",\"Two saltos (one prelim pass)\",IF($P$4=\"L3\",\"Two saltos\",IF($P$4=\"L4\",\"Salto to salto or better\",IF($P$4=\"L5\",\"One double salto (one prelim pass)\",IF(OR($P$4=\"L6\",$P$4=\"L7\",$P$4=\"Ju\"),\"One double salto\",\"\"))))))","v":""},null,null,null,null,{"$f":"IF(H17<>\"\",\"r\",\"\")","v":""},{"$f":"IF(P4=\"L1\",\"Element 0.5 or higher\",IF($P$4=\"L2\",\"Two saltos (one prelim pass)\",IF($P$4=\"L3\",\"Two saltos\",IF($P$4=\"L4\",\"Salto to salto or better\",IF($P$4=\"L5\",\"One double salto (one prelim pass)\",IF(OR($P$4=\"L6\",$P$4=\"L7\",$P$4=\"Ju\"),\"One double salto\",\"\"))))))","v":""},null,null,null,null,{"$f":"IF(N17<>\"\",\"r\",\"\")","v":""},{"$f":"IF(P4=\"L1\",\"Element 0.5 or higher\",IF($P$4=\"L2\",\"Two saltos (one finals pass)\",IF(OR($P$4=\"L3\",$P$4=\"L4\"),\"Two saltos or one double\",IF($P$4=\"L5\",\"Element 1.2 or higher\",IF(OR($P$4=\"L6\",$P$4=\"L7\",$P$4=\"Ju\"),\"One double salto\",\"\")))))","v":""},null,null,null,null,{"$f":"IF(T17<>\"\",\"r\",\"\")","v":""},{"$f":"IF(P4=\"L1\",\"Element 0.5 or higher\",IF($P$4=\"L2\",\"Two saltos (one finals pass)\",IF(OR($P$4=\"L3\",$P$4=\"L4\"),\"Two saltos or one double\",IF($P$4=\"L5\",\"Element 1.2 or higher\",IF(OR($P$4=\"L6\",$P$4=\"L7\",$P$4=\"Ju\"),\"One double salto\",\"\")))))","v":""}]
[{"$f":"IF(B18<>\"\",\"r\",\"\")","v":""},{"$f":"IF($P$4=\"L2\",\"Element 0.7 or higher\",IF($P$4=\"L3\",\"Element 0.9 or higher (one prelim pass)\",IF($P$4=\"L4\",\"Element 0.9 or higher\",IF($P$4=\"Ju\",\"Double to double (one prelims pass)\",\"\"))))","v":""},null,null,null,null,{"$f":"IF(H18<>\"\",\"r\",\"\")","v":""},{"$f":"IF($P$4=\"L2\",\"Element 0.7 or higher\",IF($P$4=\"L3\",\"Element 0.9 or higher (one prelim pass)\",IF($P$4=\"L4\",\"Element 0.9 or higher\",IF($P$4=\"Ju\",\"Double to double (one prelims pass)\",\"\"))))","v":""},null,null,null,null,{"$f":"IF(N18<>\"\",\"r\",\"\")","v":""},{"$f":"IF($P$4=\"L2\",\"One salto\",IF($P$4=\"L3\",\"Element 0.9 or higher (one finals pass)\",IF($P$4=\"L4\",\"Element 0.9 or higher\",IF($P$4=\"Ju\",\"Double to double (one finals pass)\",\"\"))))","v":""},null,null,null,null,{"$f":"IF(T18<>\"\",\"r\",\"\")","v":""},{"$f":"IF($P$4=\"L2\",\"One salto\",IF($P$4=\"L3\",\"Element 0.9 or higher (one finals pass)\",IF($P$4=\"L4\",\"Element 0.9 or higher\",IF($P$4=\"Ju\",\"Double to double (one finals pass)\",\"\"))))","v":""}]
["Mobility Element:",null,null,null,null,null,"Mobility Element:",null,null,null,null,null,"Mobility Element:",null,null,null,null,null,"Mobility Element:"]
[{"$f":"IF(B20<>\"\",\"r\",\"\")","v":""},{"$f":"IF($P$4=\"L4\",\"1 Double (across four passes)\",\"\")","v":""},null,null,null,null,{"$f":"IF(H20<>\"\",\"r\",\"\")","v":""},{"$f":"IF($P$4=\"L4\",\"1 Double (across four passes)\",\"\")","v":""},null,null,null,null,{"$f":"IF(N20<>\"\",\"r\",\"\")","v":""},{"$f":"IF($P$4=\"L4\",\"1 Double (across four passes)\",\"\")","v":""},null,null,null,null,{"$f":"IF(T20<>\"\",\"r\",\"\")","v":""},{"$f":"IF($P$4=\"L4\",\"1 Double (across four passes)\",\"\")","v":""}]
[]
[null,{"$f":"IF(OR(SUMPRODUCT(--(B10:B12<>\"\"),--(C10:C12=\"\")),SUMPRODUCT(--(H10:H12<>\"\"),--(I10:I12=\"\")),SUMPRODUCT(--(N10:N12<>\"\"),--(O10:O12=\"\")),SUMPRODUCT(--(T10:T12<>\"\"),--(U10:U12=\"\"))),\"Repetition/Extra Spotter\",\"\")","v":""},null,null,null,null,null,{"$f":"IF(OR(AND(C13<>\"\",C13<V3),AND(I13<>\"\",I13<V3),AND(O13<>\"\",O13<V3),AND(U13<>\"\",U13<V3)),\"Under Min\",\"\")","v":""},null,{"$f":"IF(AND(X3<>\"∞\",OR(AND(C13<>\"\",C13>X3),AND(I13<>\"\",I13>X3),AND(O13<>\"\",O13>X3),AND(U13<>\"\",U13>X3))),\"Over Max\",\"\")","v":""},null,null,null,{"$f":"IF(AND(OR($P$4=\"L5\",$P$4=\"L6\",$P$4=\"Ju\",$P$4=\"Se\"),OR(NUMFLIPS(B10)<3,NUMFLIPS(B11)<3,NUMFLIPS(B12)<3,NUMFLIPS(H10)<3,NUMFLIPS(H11)<3,NUMFLIPS(H12)<3,NUMFLIPS(N10)<3,NUMFLIPS(N11)<3,NUMFLIPS(N12)<3,NUMFLIPS(T10)<3,NUMFLIPS(T11)<3,NUMFLIPS(T12)<3)),\"< 270˚\",\"\")","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-<"]