{"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":41,"n_cols":21,"rows_kept":41,"cut":false,"hidden":false,"merged":[[25,13,25,15],[32,0,32,10],[36,0,36,4],[37,1,37,4],[23,6,24,10],[25,9,25,10],[27,9,29,9],[33,6,33,10],[34,7,34,10],[35,7,35,10],[36,6,36,10],[37,7,37,10],[33,0,33,4],[34,1,34,4],[35,1,35,4],[30,0,30,1],[31,0,31,1],[25,6,25,8],[26,6,26,7],[30,6,30,7],[31,6,31,7],[23,0,24,4],[25,0,25,2],[25,3,25,4],[26,0,26,1],[27,3,29,3],[20,0,20,4],[21,1,21,4],[20,6,20,10],[21,7,21,10],[20,12,20,17],[21,13,21,17],[18,13,18,17],[19,13,19,17],[17,12,17,17],[18,1,18,4],[19,1,19,4],[18,7,18,10],[19,7,19,10],[9,3,9,4],[9,6,9,8],[9,9,9,10],[17,0,17,4],[17,6,17,10],[15,6,15,7],[15,0,15,1],[11,3,13,3],[14,0,14,1],[14,6,14,7],[10,0,10,1],[10,6,10,7],[9,0,9,2],[11,9,13,9],[16,0,16,17],[14,15,14,16],[4,1,4,2],[4,6,4,8],[0,0,0,17],[7,0,8,4],[7,6,8,10],[2,6,2,9],[2,1,2,3],[7,12,8,17],[15,15,15,16],[14,12,14,13],[3,10,3,12],[4,10,4,12],[15,12,15,13],[9,15,9,17],[9,12,9,14],[10,12,10,13],[10,15,10,16],[11,15,13,16]]}
["DD SHEET - FEUILLE DE DIFFICULTÉ - DOUBLE MINI (DMT)"]
[null,"Name/Nom",null,null,null,null,"Club"]
[]
[null,"Gender/Genre",null,null,null,null,"Category/Categorie",null,null,null,"Rules / Règle",null,null,null,"Min DD",null,"Max DD"]
[null,"Choose:",null,null,null,null,"Choose:",null,null,null,"Choose:",null,null,null,{"$f":"MINDMTDD(B5,LEFT($G$5,2))","v":""},null,{"$f":"MAXDMTDD(B5,LEFT($G$5,2))","v":""}]
[]
[]
["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.)"]
[]
["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,null,"DD"]
["M","",{"$f":"IF(B12=\"\",\"\",DMTDD(B12))","v":""},null,null,null,"M","",{"$f":"IF(OR(LEFT($G$5,2)=\"Ju\",LEFT($G$5,2)=\"L7\",LEFT($G$5,2)=\"Se\"),IF(OR(H12=\"\",H12=B12,H12=B13,H12=B14),\"\",DMTDD(H12)),IF(OR(H12=\"\",H12=B12),\"\",DMTDD(H12)))","v":""},null,null,null,"M","",{"$f":"IF(OR(N12=\"\",N12=B12,N12=H12),\"\",DMTDD(N12))","v":""},null,null,null,{"$f":"NUMFLIPS(B12)","v":""},{"$f":"NUMFLIPS(H12)","v":""},{"$f":"NUMFLIPS(N12)","v":""}]
["S","",{"$f":"IF(OR(B13=\"\",C12<>\"\",AND(B5=\"Men/Hommes\",OR(LEFT($G$5,2)=\"Ju\",LEFT($G$5,2)=\"L7\",LEFT($G$5,2)=\"Se\"))),\"\",DMTDD(B13))","v":""},null,null,null,"S","",{"$f":"IF(OR(LEFT($G$5,2)=\"Ju\",LEFT($G$5,2)=\"L7\",LEFT($G$5,2)=\"Se\"),IF(OR(B5=\"Men/Hommes\",H13=\"\",I12<>\"\",C13<>\"\",H13=B12,H13=B13,H13=B14),\"\",DMTDD(H13)),IF(OR(H13=\"\",I12<>\"\",H13=B13,AND(OR(LEFT($G$5,2)=\"L3\",LEFT($G$5,2)=\"L4\",LEFT($G$5,2)=\"L5\",LEFT($G$5,2)=\"L6\"),C13<>\"\",C13>0)),\"\",DMTDD(H13)))","v":""},null,null,null,"S","",{"$f":"IF(OR(N13=\"\",C13<>\"\",I13<>\"\",O12<>\"\",$B$5=\"Men/Hommes\"),\"\",DMTDD(N13))","v":""},null,null,null,{"$f":"NUMFLIPS(B13)","v":""},{"$f":"NUMFLIPS(H13)","v":""},{"$f":"NUMFLIPS(N13)","v":""}]
["D","",{"$f":"IF(OR(LEFT($G$5,2)=\"Ju\",LEFT($G$5,2)=\"L7\",LEFT($G$5,2)=\"Se\"),IF(OR(B14=\"\",B14=B12,B14=B13),\"\",DMTDD(B14)),IF(B14=\"\",\"\",DMTDD(B14)))","v":""},null,null,null,"D","",{"$f":"IF(OR(LEFT($G$5,2)=\"Ju\",LEFT($G$5,2)=\"L7\",LEFT($G$5,2)=\"Se\"),IF(OR(H14=\"\",H14=B12,H14=B13,H14=B14,H14=H12,H14=H13),\"\",DMTDD(H14)),IF(OR(H14=\"\",H14=B14),\"\",DMTDD(H14)))","v":""},null,null,null,"D","",{"$f":"IF(OR(N14=\"\",N14=B14,N14=H14),\"\",DMTDD(N14))","v":""},null,null,null,{"$f":"NUMFLIPS(B14)","v":""},{"$f":"NUMFLIPS(H14)","v":""},{"$f":"NUMFLIPS(N14)","v":""}]
["Total DD",null,{"$f":"IF(SUM(C12:C14)=0,\"\",SUM(C12:C14))","v":""},"Official DD",null,null,"Total DD",null,{"$f":"IF(SUM(I12:I14)=0,\"\",SUM(I12:I14))","v":""},"Official DD",null,null,"Total DD",null,{"$f":"IF(SUM(O12:O14)=0,\"\",SUM(O12:O14))","v":""},"Official DD"]
["Bonus",null,{"$f":"IF(C15=\"\",\"\",IF(LEFT($G$5,2)=\"L2\",IF(AND(MID(B12,1,2)=\"41\",C12<>\"\"),0.7,0),IF(AND($B$5=\"Women/Femmes\",OR(LEFT($G$5,2)=\"L6\",LEFT($G$5,2)=\"L7\")),IF(AND(C12<>\"\",OR(B12=\"8-1<\",B12=\"801<\")),0.3,0),IF(AND($B$5=\"Women/Femmes\",LEFT($G$5,2)=\"Se\"),IF(DUBTWISTS(B12)>2,0.3,0)+IF(DUBTWISTS(B14)>2,0.3,0),IF(AND($B$5=\"Men/Hommes\",LEFT($G$5,2)=\"Se\"),COUNTIF(C12:C14,\">=4.8\")*0.3,0)))))","v":""},"Official Bonus",null,null,"Bonus",null,{"$f":"IF(I15=\"\",\"\",IF(LEFT($G$5,2)=\"L2\",IF(AND(MID(H12,1,2)=\"41\",I12<>\"\"),0.7,0),IF(AND($B$5=\"Women/Femmes\",OR(LEFT($G$5,2)=\"L6\",LEFT($G$5,2)=\"L7\")),IF(AND(I12<>\"\",OR(H12=\"8-1<\",H12=\"801<\")),0.3,0),IF(AND($B$5=\"Women/Femmes\",LEFT($G$5,2)=\"Se\"),IF(DUBTWISTS(H12)>2,0.3,0)+IF(DUBTWISTS(H14)>2,0.3,0),IF(AND($B$5=\"Men/Hommes\",LEFT($G$5,2)=\"Se\"),COUNTIF(I12:I14,\">=4.8\")*0.3,0)))))","v":""},"Official Bonus",null,null,"Bonus",null,{"$f":"IF(O15=\"\",\"\",IF(LEFT($G$5,2)=\"L2\",IF(AND(MID(N12,1,2)=\"41\",O12<>\"\"),0.7,0),IF(AND($B$5=\"Women/Femmes\",OR(LEFT($G$5,2)=\"L6\",LEFT($G$5,2)=\"L7\")),IF(AND(O12<>\"\",OR(N12=\"8-1<\",N12=\"801<\")),0.3,0),IF(AND($B$5=\"Women/Femmes\",LEFT($G$5,2)=\"Se\"),IF(DUBTWISTS(N12)>2,0.3,0)+IF(DUBTWISTS(N14)>2,0.3,0),IF(AND($B$5=\"Men/Hommes\",LEFT($G$5,2)=\"Se\"),COUNTIF(O12:O14,\">=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:"]
[{"$f":"IF(B19<>\"\",\"r\",\"\")","v":""},{"$f":"IF(LEFT($G$5,2)=\"L1\",\"Element 0.5 or higher\",IF(LEFT($G$5,2)=\"L2\",\"Two saltos (one prelim pass)\",IF(LEFT($G$5,2)=\"L3\",\"Two saltos\",IF(LEFT($G$5,2)=\"L4\",\"Two saltos or one double\",IF(LEFT($G$5,2)=\"L5\",\"One double salto (one prelim pass)\",IF(OR(LEFT($G$5,2)=\"L6\",LEFT($G$5,2)=\"L7\",LEFT($G$5,2)=\"Ju\"),\"One double salto\",\"\"))))))","v":""},null,null,null,null,{"$f":"IF(H19<>\"\",\"r\",\"\")","v":""},{"$f":"IF(LEFT($G$5,2)=\"L1\",\"Element 0.5 or higher\",IF(LEFT($G$5,2)=\"L2\",\"Two saltos (one prelim pass)\",IF(LEFT($G$5,2)=\"L3\",\"Two saltos\",IF(LEFT($G$5,2)=\"L4\",\"Two saltos or one double\",IF(LEFT($G$5,2)=\"L5\",\"One double salto (one prelim pass)\",IF(OR(LEFT($G$5,2)=\"L6\",LEFT($G$5,2)=\"L7\",LEFT($G$5,2)=\"Ju\"),\"One double salto\",\"\"))))))","v":""},null,null,null,null,{"$f":"IF(N19<>\"\",\"r\",\"\")","v":""},{"$f":"IF(LEFT($G$5,2)=\"Ju\",\"One double salto\",IF(LEFT($G$5,2)=\"L7\",\"One double salto\",\"\"))","v":""}]
[{"$f":"IF(B20<>\"\",\"r\",\"\")","v":""},{"$f":"IF(LEFT($G$5,2)=\"L2\",\"Element 0.7 or higher\",IF(LEFT($G$5,2)=\"L3\",\"Element 0.9 or higher (one prelim pass)\",IF(LEFT($G$5,2)=\"L4\",\"Element 0.9 or higher\",IF(LEFT($G$5,2)=\"Ju\",\"Double to double (one prelims pass)\",\"\"))))","v":""},null,null,null,null,{"$f":"IF(H20<>\"\",\"r\",\"\")","v":""},{"$f":"IF(LEFT($G$5,2)=\"L2\",\"Element 0.7 or higher\",IF(LEFT($G$5,2)=\"L3\",\"Element 0.9 or higher (one prelim pass)\",IF(LEFT($G$5,2)=\"L4\",\"Element 0.9 or higher\",IF(LEFT($G$5,2)=\"Ju\",\"Double to double (one prelims pass)\",\"\"))))","v":""},null,null,null,null,{"$f":"IF(N20<>\"\",\"r\",\"\")","v":""}]
["Mobility Element:",null,null,null,null,null,"Mobility Element:",null,null,null,null,null,"Mobility Element:"]
[{"$f":"IF(B22<>\"\",\"r\",\"\")","v":""},{"$f":"IF(LEFT($G$5,2)=\"L4\",\"1 Double (across four passes)\",\"\")","v":""},null,null,null,null,{"$f":"IF(H22<>\"\",\"r\",\"\")","v":""},{"$f":"IF(LEFT($G$5,2)=\"L4\",\"1 Double (across four passes)\",\"\")","v":""},null,null,null,null,{"$f":"IF(N22<>\"\",\"r\",\"\")","v":""}]
[]
["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,null,{"$f":"IF(OR(SUMPRODUCT(--(B12:B14<>\"\"),--(C12:C14=\"\")),SUMPRODUCT(--(H12:H14<>\"\"),--(I12:I14=\"\")),SUMPRODUCT(--(N12:N14<>\"\"),--(O12:O14=\"\")),SUMPRODUCT(--(B28:B30<>\"\"),--(C28:C30=\"\")),SUMPRODUCT(--(H28:H30<>\"\"),--(I28:I30=\"\"))),\"Repetition/Extra Spotter\",\"\")","v":""}]
["Elements",null,"DD",null,"DD",null,"Elements",null,"DD",null,"DD"]
["M","",{"$f":"IF(OR(LEFT($G$5,2)=\"Ju\",LEFT($G$5,2)=\"L7\",LEFT($G$5,2)=\"Se\"),IF(B28=\"\",\"\",DMTDD(B28)),IF(OR(B28=\"\",B28=B12,B28=H12),\"\",DMTDD(B28)))","v":""},null,null,null,"M","",{"$f":"IF(OR(LEFT($G$5,2)=\"Ju\",LEFT($G$5,2)=\"L7\",LEFT($G$5,2)=\"Se\"),IF(OR(H28=\"\",H28=B28,H28=B29,H28=B30),\"\",DMTDD(H28)),IF(OR(H28=\"\",H28=B12,H28=H12,H28=B28),\"\",DMTDD(H28)))","v":""},null,null,null,null,{"$f":"IF(OR(AND(C15<>\"\",C15<O5),AND(I15<>\"\",I15<O5),AND(O15<>\"\",O15<O5),AND(C31<>\"\",C31<O5),AND(I31<>\"\",I31<O5)),\"Under Min\",\"\")","v":""},null,null,null,null,{"$f":"NUMFLIPS(B28)","v":""},{"$f":"NUMFLIPS(H28)","v":""}]
["S","",{"$f":"IF(OR(LEFT($G$5,2)=\"Ju\",LEFT($G$5,2)=\"L7\",LEFT($G$5,2)=\"Se\"),\"\",IF(OR(B29=\"\",C28<>\"\",B29=B13,B29=H13),\"\",DMTDD(B29)))","v":""},null,null,null,"S","",{"$f":"IF(OR(LEFT($G$5,2)=\"Ju\",LEFT($G$5,2)=\"L7\",LEFT($G$5,2)=\"Se\"),\"\",IF(OR(H29=\"\",I28<>\"\",H29=B13,H29=I13,H29=B29),\"\",DMTDD(H29)))","v":""},null,null,null,null,null,null,null,null,null,{"$f":"NUMFLIPS(B29)","v":""},{"$f":"NUMFLIPS(H29)","v":""}]
["D","",{"$f":"IF(OR(LEFT($G$5,2)=\"Ju\",LEFT($G$5,2)=\"L7\",LEFT($G$5,2)=\"Se\"),IF(OR(B30=\"\",B30=B28,B30=B29),\"\",DMTDD(B30)),IF(OR(B30=\"\",B30=B14,B30=H14),\"\",DMTDD(B30)))","v":""},null,null,null,"D","",{"$f":"IF(OR(LEFT($G$5,2)=\"Ju\",LEFT($G$5,2)=\"L7\",LEFT($G$5,2)=\"Se\"),IF(OR(H30=\"\",H30=B28,H30=B29,H30=B30,H30=H28,H30=H29),\"\",DMTDD(H30)),IF(OR(H30=\"\",H30=B14,H30=H14,H30=B30),\"\",DMTDD(H30)))","v":""},null,null,null,null,{"$f":"IF(AND(Q5<>\"∞\",OR(AND(C15<>\"\",C15>Q5),AND(I15<>\"\",I15>Q5),AND(O15<>\"\",O15>Q5),AND(C31<>\"\",C31>Q5),AND(I31<>\"\",I31>Q5))),\"Over Max\",\"\")","v":""},null,null,null,null,{"$f":"NUMFLIPS(B30)","v":""},{"$f":"NUMFLIPS(H30)","v":""}]
["Total DD",null,{"$f":"IF(SUM(C28:C30)=0,\"\",SUM(C28:C30))","v":""},"Official DD",null,null,"Total DD",null,{"$f":"IF(SUM(I28:I30)=0,\"\",SUM(I28:I30))","v":""},"Official DD"]
["Bonus",null,{"$f":"IF(C31=\"\",\"\",IF(LEFT($G$5,2)=\"L2\",IF(AND(MID(B28,1,2)=\"41\",C28<>\"\"),0.7,0),IF(AND($B$5=\"Women/Femmes\",OR(LEFT($G$5,2)=\"L6\",LEFT($G$5,2)=\"L7\")),IF(AND(C28<>\"\",OR(B28=\"8-1<\",B28=\"801<\")),0.3,0),IF(AND($B$5=\"Women/Femmes\",LEFT($G$5,2)=\"Se\"),IF(DUBTWISTS(B28)>2,0.3,0)+IF(DUBTWISTS(B30)>2,0.3,0),IF(AND($B$5=\"Men/Hommes\",LEFT($G$5,2)=\"Se\"),COUNTIF(C28:C30,\">=4.8\")*0.3,0)))))","v":""},"Official Bonus",null,null,"Bonus",null,{"$f":"IF(I31=\"\",\"\",IF(LEFT($G$5,2)=\"L2\",IF(AND(MID(H28,1,2)=\"41\",I28<>\"\"),0.7,0),IF(AND($B$5=\"Women/Femmes\",OR(LEFT($G$5,2)=\"L6\",LEFT($G$5,2)=\"L7\")),IF(AND(I28<>\"\",OR(H28=\"8-1<\",H28=\"801<\")),0.3,0),IF(AND($B$5=\"Women/Femmes\",LEFT($G$5,2)=\"Se\"),IF(DUBTWISTS(H28)>2,0.3,0)+IF(DUBTWISTS(H30)>2,0.3,0),IF(AND($B$5=\"Men/Hommes\",LEFT($G$5,2)=\"Se\"),COUNTIF(I28:I30,\">=4.8\")*0.3,0)))))","v":""},"Official Bonus",null,null,null,{"$f":"IF(AND(OR(LEFT($G$5,2)=\"L5\",LEFT($G$5,2)=\"L6\",LEFT($G$5,2)=\"L7\",LEFT($G$5,2)=\"Ju\",LEFT($G$5,2)=\"Se\"),OR(NUMFLIPS(B12)<4,NUMFLIPS(B13)<4,NUMFLIPS(B14)<4,NUMFLIPS(H12)<4,NUMFLIPS(H13)<4,NUMFLIPS(H14)<4,NUMFLIPS(N12)<4,NUMFLIPS(N13)<4,NUMFLIPS(N14)<4,NUMFLIPS(B28)<4,NUMFLIPS(B29)<4,NUMFLIPS(B30)<4,NUMFLIPS(H28)<4,NUMFLIPS(H29)<4,NUMFLIPS(H30)<4)),\"< 360˚\",\"\")","v":""}]
["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(B35<>\"\",\"r\",\"\")","v":""},{"$f":"IF(LEFT($G$5,2)=\"L1\",\"Element 0.5 or higher\",IF(LEFT($G$5,2)=\"L2\",\"Two saltos (one finals pass)\",IF(LEFT($G$5,2)=\"L3\",\"Two saltos or one double\",IF(LEFT($G$5,2)=\"L4\",\"Two saltos or one double\",IF(LEFT($G$5,2)=\"L5\",\"Element 1.2 or higher\",IF(OR(LEFT($G$5,2)=\"L6\",LEFT($G$5,2)=\"L7\",LEFT($G$5,2)=\"Ju\"),\"One double salto\",\"\"))))))","v":""},null,null,null,null,{"$f":"IF(H35<>\"\",\"r\",\"\")","v":""},{"$f":"IF(LEFT($G$5,2)=\"L1\",\"Element 0.5 or higher\",IF(LEFT($G$5,2)=\"L2\",\"Two saltos (one finals pass)\",IF(LEFT($G$5,2)=\"L3\",\"Two saltos or one double\",IF(LEFT($G$5,2)=\"L4\",\"Two saltos or one double\",IF(LEFT($G$5,2)=\"L5\",\"Element 1.2 or higher\",IF(OR(LEFT($G$5,2)=\"L6\",LEFT($G$5,2)=\"L7\",LEFT($G$5,2)=\"Ju\"),\"One double salto\",\"\"))))))","v":""}]
[{"$f":"IF(B36<>\"\",\"r\",\"\")","v":""},{"$f":"IF(LEFT($G$5,2)=\"L2\",\"One salto\",IF(LEFT($G$5,2)=\"L3\",\"Element 0.9 or higher (one finals pass)\",IF(LEFT($G$5,2)=\"L4\",\"Element 0.9 or higher\",IF(LEFT($G$5,2)=\"Ju\",\"Double to double (one finals pass)\",\"\"))))","v":""},null,null,null,null,{"$f":"IF(H36<>\"\",\"r\",\"\")","v":""},{"$f":"IF(LEFT($G$5,2)=\"L2\",\"One salto\",IF(LEFT($G$5,2)=\"L3\",\"Element 0.9 or higher (one finals pass)\",IF(LEFT($G$5,2)=\"L4\",\"Element 0.9 or higher\",IF(LEFT($G$5,2)=\"Ju\",\"Double to double (one finals pass)\",\"\"))))","v":""}]
["Mobility Element:",null,null,null,null,null,"Mobility Element:"]
[{"$f":"IF(B38<>\"\",\"r\",\"\")","v":""},{"$f":"IF(LEFT($G$5,2)=\"L4\",\"1 Double (across four passes)\",\"\")","v":""},null,null,null,null,{"$f":"IF(H38<>\"\",\"r\",\"\")","v":""},{"$f":"IF(LEFT($G$5,2)=\"L4\",\"1 Double (across four passes)\",\"\")","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"]