{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["DD TRA SYN"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"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 TRA SYN","index":0,"n_rows":31,"n_cols":24,"rows_kept":31,"cut":false,"hidden":false,"merged":[[0,0,0,20],[2,9,2,11],[27,3,27,6],[20,0,20,20],[2,1,2,3],[2,5,2,7],[2,13,2,15],[5,14,6,20],[7,14,7,16],[7,17,7,20],[19,14,19,15],[19,17,19,19],[8,14,8,15],[8,17,8,19],[26,3,26,6],[21,2,21,6],[9,5,18,5],[7,5,7,6],[8,2,8,3],[5,0,5,6],[6,0,6,6],[7,0,7,4],[5,8,6,12],[9,11,18,11],[8,8,8,9],[9,17,18,19],[25,3,25,6],[19,8,19,9],[7,8,7,10],[7,11,7,12],[21,8,21,12],[22,9,22,12],[23,8,23,12],[24,9,24,12],[22,3,22,6],[23,3,23,6],[24,3,24,6],[19,0,19,3]]}
["DD SHEET - FEUILLE DE DIFFICULTÉ - TRAMPOLINE (TRA and SYN)"]
[null,"Name/Nom",null,null,null,"Club",null,null,null,"Event/Epreuve",null,null,null,"Category/Categorie",null,null,null,"Min DD",null,"Max DD"]
[null,null,null,null,null,null,null,null,null,"Choose:",null,null,null,"Choose:",null,null,null,{"$f":"MINDD(J3,LEFT(N3,2))","v":""},null,{"$f":"MAXDD(J3,LEFT(N3,2))","v":""}]
[]
[]
["1st Voluntary / 1ère libre",null,null,null,null,null,null,null,"2nd Voluntary / 2ème libre",null,null,null,null,null,"Final / Finale"]
["10 DD Skills for L7 and  Senior"]
["Athlete / Athlète",null,null,null,null,"Judges / Juges",null,null,"Athlete / Athlète",null,null,"Judges / Juges",null,null,"Athlete / Athlète",null,null,"Judges / Juges"]
["Req(*)","DD(*)","Elements",null,"DD",null,"DD",null,"Elements",null,"DD",null,"DD",null,"Elements",null,"DD",null,null,null,"DD"]
[null,null,"1.","7--o",{"$f":"IF(AND(D10<>\"\",B10<>\"\",OR(LEFT(N3,2)=\"L7\",LEFT(N3,2)=\"Se\")),DD(D10),\"\")","v":""},null,null,null,"1.",null,{"$f":"IF(OR(J10=\"\",AND(LEFT(N3,2)<>\"L7\",LEFT(N3,2)<>\"Se\",COUNTIFS(D$10:D$19,J10,E$10:E$19,\">0\"))),\"\",DD(J10))","v":""},null,null,null,"1.",null,{"$f":"IF(P10=\"\",\"\",DD(P10))","v":""},null,null,null,null,{"$f":"NUMFLIPS(D10)","v":7},{"$f":"NUMFLIPS(J10)","v":""},{"$f":"NUMFLIPS(P10)","v":""}]
[null,null,"2.","51o",{"$f":"IF(AND(B11<>\"\",D11<>\"\",COUNT(E$10:E10)<IF(LEFT(N$3,2)=\"L7\",10,IF(LEFT(N$3,2)=\"Se\",10,0))),IF(COUNTIFS(D$10:D10,D11,E$10:E10,\">0\"),\"\",DD(D11)),\"\")","v":""},null,null,null,"2.",null,{"$f":"IF(OR(J11=\"\",AND(LEFT(N3,2)<>\"L7\",LEFT(N3,2)<>\"Se\",COUNTIFS(D$10:D$19,J11,E$10:E$19,\">0\")),COUNTIFS(J$10:J10,J11)),\"\",DD(J11))","v":""},null,null,null,"2.",null,{"$f":"IF(OR(P11=\"\",COUNTIFS(P$10:P10,P11)),\"\",DD(P11))","v":""},null,null,null,null,{"$f":"NUMFLIPS(D11)","v":5},{"$f":"NUMFLIPS(J11)","v":""},{"$f":"NUMFLIPS(P11)","v":""}]
[null,null,"3.","4-o",{"$f":"IF(AND(B12<>\"\",D12<>\"\",COUNT(E$10:E11)<IF(LEFT(N$3,2)=\"L7\",10,IF(LEFT(N$3,2)=\"Se\",10,0))),IF(COUNTIFS(D$10:D11,D12,E$10:E11,\">0\"),\"\",DD(D12)),\"\")","v":""},null,null,null,"3.",null,{"$f":"IF(OR(J12=\"\",AND(LEFT(N3,2)<>\"L7\",LEFT(N3,2)<>\"Se\",COUNTIFS(D$10:D$19,J12,E$10:E$19,\">0\")),COUNTIFS(J$10:J11,J12)),\"\",DD(J12))","v":""},null,null,null,"3.",null,{"$f":"IF(OR(P12=\"\",COUNTIFS(P$10:P11,P12)),\"\",DD(P12))","v":""},null,null,null,null,{"$f":"NUMFLIPS(D12)","v":4},{"$f":"NUMFLIPS(J12)","v":""},{"$f":"NUMFLIPS(P12)","v":""}]
[null,null,"4.","41/",{"$f":"IF(AND(B13<>\"\",D13<>\"\",COUNT(E$10:E12)<IF(LEFT(N$3,2)=\"L7\",10,IF(LEFT(N$3,2)=\"Se\",10,0))),IF(COUNTIFS(D$10:D12,D13,E$10:E12,\">0\"),\"\",DD(D13)),\"\")","v":""},null,null,null,"4.",null,{"$f":"IF(OR(J13=\"\",AND(LEFT(N3,2)<>\"L7\",LEFT(N3,2)<>\"Se\",COUNTIFS(D$10:D$19,J13,E$10:E$19,\">0\")),COUNTIFS(J$10:J12,J13)),\"\",DD(J13))","v":""},null,null,null,"4.",null,{"$f":"IF(OR(P13=\"\",COUNTIFS(P$10:P12,P13)),\"\",DD(P13))","v":""},null,null,null,null,{"$f":"NUMFLIPS(D13)","v":4},{"$f":"NUMFLIPS(J13)","v":""},{"$f":"NUMFLIPS(P13)","v":""}]
[null,null,"5.","4-/",{"$f":"IF(AND(B14<>\"\",D14<>\"\",COUNT(E$10:E13)<IF(LEFT(N$3,2)=\"L7\",10,IF(LEFT(N$3,2)=\"Se\",10,0))),IF(COUNTIFS(D$10:D13,D14,E$10:E13,\">0\"),\"\",DD(D14)),\"\")","v":""},null,null,null,"5.",null,{"$f":"IF(OR(J14=\"\",AND(LEFT(N3,2)<>\"L7\",LEFT(N3,2)<>\"Se\",COUNTIFS(D$10:D$19,J14,E$10:E$19,\">0\")),COUNTIFS(J$10:J13,J14)),\"\",DD(J14))","v":""},null,null,null,"5.",null,{"$f":"IF(OR(P14=\"\",COUNTIFS(P$10:P13,P14)),\"\",DD(P14))","v":""},null,null,null,null,{"$f":"NUMFLIPS(D14)","v":4},{"$f":"NUMFLIPS(J14)","v":""},{"$f":"NUMFLIPS(P14)","v":""}]
[null,null,"6.","4-<",{"$f":"IF(AND(B15<>\"\",D15<>\"\",COUNT(E$10:E14)<IF(LEFT(N$3,2)=\"L7\",10,IF(LEFT(N$3,2)=\"Se\",10,0))),IF(COUNTIFS(D$10:D14,D15,E$10:E14,\">0\"),\"\",DD(D15)),\"\")","v":""},null,null,null,"6.",null,{"$f":"IF(OR(J15=\"\",AND(LEFT(N3,2)<>\"L7\",LEFT(N3,2)<>\"Se\",COUNTIFS(D$10:D$19,J15,E$10:E$19,\">0\")),COUNTIFS(J$10:J14,J15)),\"\",DD(J15))","v":""},null,null,null,"6.",null,{"$f":"IF(OR(P15=\"\",COUNTIFS(P$10:P14,P15)),\"\",DD(P15))","v":""},null,null,null,null,{"$f":"NUMFLIPS(D15)","v":4},{"$f":"NUMFLIPS(J15)","v":""},{"$f":"NUMFLIPS(P15)","v":""}]
[null,null,"7.","41<",{"$f":"IF(AND(B16<>\"\",D16<>\"\",COUNT(E$10:E15)<IF(LEFT(N$3,2)=\"L7\",10,IF(LEFT(N$3,2)=\"Se\",10,0))),IF(COUNTIFS(D$10:D15,D16,E$10:E15,\">0\"),\"\",DD(D16)),\"\")","v":""},null,null,null,"7.",null,{"$f":"IF(OR(J16=\"\",AND(LEFT(N3,2)<>\"L7\",LEFT(N3,2)<>\"Se\",COUNTIFS(D$10:D$19,J16,E$10:E$19,\">0\")),COUNTIFS(J$10:J15,J16)),\"\",DD(J16))","v":""},null,null,null,"7.",null,{"$f":"IF(OR(P16=\"\",COUNTIFS(P$10:P15,P16)),\"\",DD(P16))","v":""},null,null,null,null,{"$f":"NUMFLIPS(D16)","v":4},{"$f":"NUMFLIPS(J16)","v":""},{"$f":"NUMFLIPS(P16)","v":""}]
[null,null,"8.","--o",{"$f":"IF(AND(B17<>\"\",D17<>\"\",COUNT(E$10:E16)<IF(LEFT(N$3,2)=\"L7\",10,IF(LEFT(N$3,2)=\"Se\",10,0))),IF(COUNTIFS(D$10:D16,D17,E$10:E16,\">0\"),\"\",DD(D17)),\"\")","v":""},null,null,null,"8.",null,{"$f":"IF(OR(J17=\"\",AND(LEFT(N3,2)<>\"L7\",LEFT(N3,2)<>\"Se\",COUNTIFS(D$10:D$19,J17,E$10:E$19,\">0\")),COUNTIFS(J$10:J16,J17)),\"\",DD(J17))","v":""},null,null,null,"8.",null,{"$f":"IF(OR(P17=\"\",COUNTIFS(P$10:P16,P17)),\"\",DD(P17))","v":""},null,null,null,null,{"$f":"NUMFLIPS(D17)","v":0},{"$f":"NUMFLIPS(J17)","v":""},{"$f":"NUMFLIPS(P17)","v":""}]
[null,null,"9.","3-/",{"$f":"IF(AND(B18<>\"\",D18<>\"\",COUNT(E$10:E17)<IF(LEFT(N$3,2)=\"L7\",10,IF(LEFT(N$3,2)=\"Se\",10,0))),IF(COUNTIFS(D$10:D17,D18,E$10:E17,\">0\"),\"\",DD(D18)),\"\")","v":""},null,null,null,"9.",null,{"$f":"IF(OR(J18=\"\",AND(LEFT(N3,2)<>\"L7\",LEFT(N3,2)<>\"Se\",COUNTIFS(D$10:D$19,J18,E$10:E$19,\">0\")),COUNTIFS(J$10:J17,J18)),\"\",DD(J18))","v":""},null,null,null,"9.",null,{"$f":"IF(OR(P18=\"\",COUNTIFS(P$10:P17,P18)),\"\",DD(P18))","v":""},null,null,null,null,{"$f":"NUMFLIPS(D18)","v":3},{"$f":"NUMFLIPS(J18)","v":""},{"$f":"NUMFLIPS(P18)","v":""}]
[null,null,"10.","5-o",{"$f":"IF(AND(B19<>\"\",D19<>\"\",COUNT(E$10:E18)<IF(LEFT(N$3,2)=\"L7\",10,IF(LEFT(N$3,2)=\"Se\",10,0))),IF(COUNTIFS(D$10:D18,D19,E$10:E18,\">0\"),\"\",DD(D19)),\"\")","v":""},null,null,null,"10.",null,{"$f":"IF(OR(J19=\"\",AND(LEFT(N3,2)<>\"L7\",LEFT(N3,2)<>\"Se\",COUNTIFS(D$10:D$19,J19,E$10:E$19,\">0\")),COUNTIFS(J$10:J18,J19)),\"\",DD(J19))","v":""},null,null,null,"10.",null,{"$f":"IF(OR(P19=\"\",COUNTIFS(P$10:P18,P19)),\"\",DD(P19))","v":""},null,null,null,null,{"$f":"NUMFLIPS(D19)","v":5},{"$f":"NUMFLIPS(J19)","v":""},{"$f":"NUMFLIPS(P19)","v":""}]
["Total DD",null,null,null,{"$f":"IF(SUM(E10:E19)=0,\"\",SUM(E10:E19))","v":""},"Official DD",null,null,"Total DD",null,{"$f":"IF(SUM(K10:K19)=0,\"\",SUM(K10:K19))","v":""},"Official DD",null,null,"Total DD",null,{"$f":"IF(SUM(Q10:Q19)=0,\"\",SUM(Q10:Q19))","v":""},"Official DD"]
["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"]
[null,null,"Requirements:",null,null,null,null,null,"Requirements:"]
[null,null,{"$f":"IF(D23<>\"\",\"r\",\"\")","v":""},{"$f":"IF(AND(OR(LEFT(N3,2)=\"L5\",LEFT(N3,2)=\"L6\",LEFT(N3,2)=\"Ju\"),LEFT(J3,3)=\"Ind\"),\"9 skills with at least 270˚ of rotation\",\"\")","v":""},null,null,null,null,{"$f":"IF(J23<>\"\",\"r\",\"\")","v":""},{"$f":"IF(LEFT(J3,3)=\"Syn\",\"\",IF(LEFT(N3,2)=\"L5\",\"One double\",\"\"))","v":""},null,null,null,null,null,{"$f":"IF(OR(AND(E20<>\"\",E20<R3,OR(LEFT(N3,2)=\"L7\",LEFT(N3,2)=\"Se\")),AND(K20<>\"\",K20<R3),AND(Q20<>\"\",Q20<R3)),\"Under Min\",\"\")","v":""}]
[null,null,{"$f":"IF(D24<>\"\",\"r\",\"\")","v":""},{"$f":"IF(AND(OR(LEFT(N3,2)=\"L5\",LEFT(N3,2)=\"L6\",LEFT(N3,2)=\"Ju\"),LEFT(J3,3)=\"Ind\"),\"1 element landing on the front or back\",\"\")","v":""},null,null,null,null,"Mobility Element:"]
[null,null,{"$f":"IF(D25<>\"\",\"r\",\"\")","v":""},{"$f":"IF(AND(OR(LEFT(N3,2)=\"L5\",LEFT(N3,2)=\"L6\",LEFT(N3,2)=\"Ju\"),LEFT(J3,3)=\"Ind\"),\"1 element taking off from the front or back\",\"\")","v":""},null,null,null,null,{"$f":"IF(J25<>\"\",\"r\",\"\")","v":""},{"$f":"IF(LEFT(J3,3)=\"Syn\",\"\",IF(OR(LEFT(N3,2)=\"L4\"),\"One double\",\"\"))","v":""},null,null,null,null,null,{"$f":"IF(OR(AND(K20<>\"\",K20>T3),AND(Q20<>\"\",Q20>T3)),\"Over Max\",\"\")","v":""}]
[null,null,{"$f":"IF(D26<>\"\",\"r\",\"\")","v":""},{"$f":"IF(LEFT(J3,3)=\"Syn\",\"\",IF(LEFT(N3,2)=\"L5\",\"42       (Back Full)\",IF(OR(LEFT(N3,2)=\"L6\",LEFT(N3,2)=\"Ju\"),\"1 double salto\",\"\")))","v":""}]
[null,null,{"$f":"IF(D27<>\"\",\"r\",\"\")","v":""},{"$f":"IF(LEFT(J3,3)=\"Syn\",\"\",IF(LEFT(N3,2)=\"L5\",\"43       (Rudi)\",IF(OR(LEFT(N3,2)=\"L6\",LEFT(N3,2)=\"Ju\"),\"1 element with at least 540˚ twist\",\"\")))","v":""}]
[null,null,{"$f":"IF(D28<>\"\",\"r\",\"\")","v":""},{"$f":"IF(LEFT(J3,3)=\"Syn\",\"\",IF(LEFT(N3,2)=\"L5\",\"41<     (Barani Pike)\",\"\"))","v":""},null,null,null,null,null,{"$f":"IF(AND(NOT(OR(LEFT(N3,2)=\"L1\",LEFT(N3,2)=\"L2\",LEFT(N3,2)=\"L3\",LEFT(N3,2)=\"L4\")),OR(IF(AND($D10<>\"\",SUMPRODUCT(--($D$9:$D9=$D10))),1,0),IF(AND($D11<>\"\",SUMPRODUCT(--($D$9:$D10=$D11))),1,0),IF(AND($D12<>\"\",SUMPRODUCT(--($D$9:$D11=$D12))),1,0),IF(AND($D13<>\"\",SUMPRODUCT(--($D$9:$D12=$D13))),1,0),IF(AND($D14<>\"\",SUMPRODUCT(--($D$9:$D13=$D14))),1,0),IF(AND($D15<>\"\",SUMPRODUCT(--($D$9:$D14=$D15))),1,0),IF(AND($D16<>\"\",SUMPRODUCT(--($D$9:$D15=$D16))),1,0),IF(AND($D17<>\"\",SUMPRODUCT(--($D$9:$D16=$D17))),1,0),IF(AND($D18<>\"\",SUMPRODUCT(--($D$9:$D17=$D18))),1,0),IF(AND($D19<>\"\",SUMPRODUCT(--($D$9:$D18=$D19))),1,0),SUMPRODUCT(--(J10:J19<>\"\"),--(K10:K19=\"\")),SUMPRODUCT(--(P10:P19<>\"\"),--(Q10:Q19=\"\")))),\"Repetitions\",\"\")","v":""},null,{"$f":"IF(COUNTIF(E10:E19,\"N/A\")+COUNTIF(K10:K19,\"N/A\")+COUNTIF(Q10:Q19,\"N/A\"),\"Unknown Skills\",\"\")","v":""},null,null,null,{"$f":"IF(OR(AND(LEFT(N3,2)=\"Se\",OR(NUMFLIPS(J10)<3,NUMFLIPS(J11)<3,NUMFLIPS(J12)<3,NUMFLIPS(J13)<3,NUMFLIPS(J14)<3,NUMFLIPS(J15)<3,NUMFLIPS(J16)<3,NUMFLIPS(J17)<3,NUMFLIPS(J18)<3,NUMFLIPS(J19)<3)),AND(OR(LEFT(N3,2)=\"L5\",LEFT(N3,2)=\"L6\",LEFT(N3,2)=\"Ju\",LEFT(N3,2)=\"L7\"),SUM(NUMFLIPS(D10)<3,NUMFLIPS(D11)<3,NUMFLIPS(D12)<3,NUMFLIPS(D13)<3,NUMFLIPS(D14)<3,NUMFLIPS(D15)<3,NUMFLIPS(D16)<3,NUMFLIPS(D17)<3,NUMFLIPS(D18)<3,NUMFLIPS(D19)<3)>1),AND(LEFT(N3,2)=\"Se\",SUM(NUMFLIPS(D10)<3,NUMFLIPS(D11)<3,NUMFLIPS(D12)<3,NUMFLIPS(D13)<3,NUMFLIPS(D14)<3,NUMFLIPS(D15)<3,NUMFLIPS(D16)<3,NUMFLIPS(D17)<3,NUMFLIPS(D18)<3,NUMFLIPS(D19)<3)>0)),\"< 270˚\",\"\")","v":""}]
[]
[null,null,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,null,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"]