{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["MENU","Poule cumul (PC)","Affichage PC","ED-Cumul","Affichage ED-cumul","ED-Partie-Perdue (PP)","Affichage ED-PP","Poule (PP)","Affichage P PP"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":0,"defined_names":1,"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":"MENU","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Poule cumul (PC)","index":1,"n_rows":32,"n_cols":12,"rows_kept":32,"cut":false,"hidden":false,"merged":[[0,0,0,10],[4,0,4,1],[4,2,4,4],[4,5,4,7],[1,0,1,1],[1,2,1,4],[1,5,1,7],[1,9,1,10],[2,0,2,1],[2,2,2,4],[5,0,5,1],[5,5,5,7],[2,5,2,7],[3,0,3,1],[3,2,3,4],[3,5,3,7],[5,2,5,4],[6,0,6,8],[11,0,11,3],[12,8,12,10],[16,1,16,3],[14,0,14,9],[7,0,7,7],[9,0,9,3],[10,0,10,3],[12,0,12,5],[13,0,13,5],[32,0,32,7],[32,8,32,11],[29,6,29,7],[29,9,29,10],[30,0,30,3],[30,4,30,5],[31,0,31,7],[30,7,30,10]]}
["CALCUL AUTOMATIQUE DES INDEMNITES AUX JOUEURS    INDIVIDUEL, DOUBLETTE & TRIPLETTE EN POULE AU CUMUL V21012018"]
["DELEGUE :",null,null,null,null,"Dotation de l'organisateurs :",null,null,null,"Indemnités "]
[" N° INTERNATIONAL :",null,null,null,null,null,null,null,null,null,{"$f":"I2","v":0}]
["N° NATIONAL :",null,null,null,null,"Nombre d'équipes engagées :",null,null,null,{"$f":"F10*G10","v":15},{"$f":"I4*J4","v":0},4]
["LIEU :",null,null,null,null,"Nombre de poule :",null,null,{"$f":"ROUNDUP($I$4/4,0)","v":0},"Total",{"$f":"SUM(K3:K4)","v":0}]
["RESPONSABLE ",null,null,null,null,"Nombre équipes sortie de Poule :",null,null,{"$f":"I5*2","v":0}]
["Attention ce tableau ne fonctionne qu'a partir de 61 équipes "]
["I. Calcul du maximum à verser aux vainqueurs des 8ème de finale "]
[null,null,null,null,null,"Ind. Doub. Trip.","Part/joueur"]
["Participation",null,null,null,{"$f":"I4","v":0},3,5,{"$f":"F10*G10","v":15}]
["Dotation ",null,null,null,null,null,{"$f":"I2","v":0},{"$f":"G11","v":0}]
["Total indemnités",null,null,null,null,null,null,{"$f":"K5","v":0}]
["50% maxi de la dotation globale ",null,null,null,null,null,0.5,{"$f":"H12*G13","v":0}]
["25% mini de la dotation globale ",null,null,null,null,null,0.25,{"$f":"H12*G14","v":0}]
["II. On renseigne uniquement les cellules bleutées "]
[]
[null,"Total indemnités",null,null,{"$f":"H12","v":0}]
[null,"Equipes indemnisées","Indemnités par équipe","Cumul par partie","Reste indemnités à répartir","Cumulé"]
["Sortie poule",{"$f":"I6","v":0},null,{"$f":"B19*C19","v":0},{"$f":"E17-D19","v":0},{"$f":"IF(B19=0,0,C19)","v":0},null,"= engagement"]
["1° partie après les poules",{"$f":"B19/2","v":0},null,0,{"$f":"E19-D20","v":0},{"$f":"F19+C20","v":0},"nbre equipes à faire le cadrage","= engagement ou C20 + 5€"]
["Cadrage ",{"$f":"IF(B20>=128,B20-128,IF(B20>=64,B20-\"64\",IF(B20>=32,B20-\"32\",IF(B20>=16,B20-16,0))))","v":0},null,0,0,{"$f":"F20+C21","v":0},{"$f":"B*2","v":{"$error":"#NAME?"}},"= C21 + 5€"]
["64ème",{"$f":"IF(B20-B21=128,128/2,0)","v":0},null,0,0,{"$f":"F21+C22","v":0}]
["32ème",{"$f":"IF(B20-B21=64,32,IF(B22=64,B22/2,0))","v":0},null,0,0,{"$f":"IF(B23=0,F22,C23+F22)","v":0}]
["16ème",{"$f":"IF(B20-B21=32,\"16\",IF(B23=32,B23/2,\"0\"))","v":"0"},null,{"$f":"B24*C24","v":0},0,{"$f":"IF(B24=0,F23,C24+F23)","v":0}]
["8ème ",8,null,{"$f":"B25*C25","v":0},0,{"$f":"IF(B25=0,F24,C25+F24)","v":0}]
["1/4 de fin",4,null,0,{"$f":"E25-D26","v":0},{"$f":"F25+C26","v":0}]
["1/2 et finale ",4,{"$f":"E26/B27","v":0},{"$f":"B27*C27","v":0},{"$f":"E26-D27","v":0},{"$f":"F26+C27","v":0}]
[]
[null,null,null,null,null,null,"> ou = à 25%",{"$f":"H14","v":0},"% Répartition","< ou = 50 %",{"$f":"H13","v":0}]
[null,null,null,{"$f":"SUM(D19:D29)","v":0},null,null,{"$f":"IF(I30<0.25,0,IF(I30>0.5,0,1))","v":{"$error":"#DIV/0!"}},null,{"$f":"J30/H12","v":{"$error":"#DIV/0!"}},{"$f":"E25","v":0}]
[{"$f":"IF(F10=3,\"TRIPLETTE : 12 CHEQUES DE : \",IF(F10=2,\"DOUBLETTE : 8 CHEQUES DE : \",IF(F10=1,\"TETE A TETE : 4 CHEQUES de : \",\"\")))","v":"TRIPLETTE : 12 CHEQUES DE : "},null,null,null,{"$f":"IF(F10=3,E26/12,IF(F10=2,E26/8,IF(F10=1,E26/4,0)))","v":0},null,12,{"$f":"IF(G30=1,\"La répartition est correcte\",IF(I30<0.25,\"Le pourcentage doit être > ou = à 25%\",IF(I30>0.5,\"Le pourcentage ne doit pas dépasser 50%\",\"\")))","v":{"$error":"#DIV/0!"}}]
["On renseigne uniquement les cellules bleutées et on adapte au % désiré.",null,null,null,null,null,null,null,"Dernière mise à jour V21012018"]

{"sheet":"Affichage PC","index":2,"n_rows":26,"n_cols":5,"rows_kept":26,"cut":false,"hidden":false,"merged":[[0,0,0,4],[2,1,2,2],[3,1,3,2],[1,1,1,2],[4,1,4,2],[23,0,23,2],[10,0,10,4],[8,1,8,2],[9,1,9,2],[11,0,11,4],[6,3,8,4],[9,3,9,4]]}
["INDEMNITES DES JOUEURS   POULE AU CUMUL"]
["DELEGUE",{"$f":"'Poule cumul (PC)'!C2","v":0}]
["N° INTERNATIONAL :",{"$f":"'Poule cumul (PC)'!C3","v":0}]
["N° NATIONAL :",{"$f":"'Poule cumul (PC)'!C4","v":0}]
["LIEU :",{"$f":"'Poule cumul (PC)'!C5","v":0}]
[]
["Inscrits ","Inscription","Total"," Attention! Les 1/4 de finale sont réglés en espèce.                                                                        % compris entre 25% et 50%"]
[{"$f":"'Poule cumul (PC)'!I4","v":0},{"$f":"'Poule cumul (PC)'!J4","v":15},{"$f":"'Poule cumul (PC)'!K4","v":0}]
["DOTATION ",{"$f":"'Poule cumul (PC)'!K3","v":0}]
["TOTAL INDEMNITES ",{"$f":"C8+B9","v":0},null,{"$f":"'Poule cumul (PC)'!I30","v":{"$error":"#DIV/0!"}}]
[]
["REPARTITION DES INDEMNITES "]
["PARTIES ","Equipes indemnisées","Indemnités par équipe","Total ","Indemnité cumulées "]
[{"$f":"'Poule cumul (PC)'!A19","v":"Sortie poule"},{"$f":"'Poule cumul (PC)'!B19","v":0},{"$f":"'Poule cumul (PC)'!C19","v":0},{"$f":"'Poule cumul (PC)'!D19","v":0},{"$f":"'Poule cumul (PC)'!F19","v":0}]
[{"$f":"'Poule cumul (PC)'!A20","v":"1° partie après les poules"},{"$f":"'Poule cumul (PC)'!B20","v":0},{"$f":"'Poule cumul (PC)'!C20","v":0},{"$f":"'Poule cumul (PC)'!D20","v":0},{"$f":"'Poule cumul (PC)'!F20","v":0}]
[{"$f":"'Poule cumul (PC)'!A21","v":"Cadrage "},{"$f":"'Poule cumul (PC)'!B21","v":0},{"$f":"'Poule cumul (PC)'!C21","v":0},{"$f":"'Poule cumul (PC)'!D21","v":0},{"$f":"'Poule cumul (PC)'!F21","v":0}]
[{"$f":"'Poule cumul (PC)'!A22","v":"64ème"},{"$f":"'Poule cumul (PC)'!B22","v":0},{"$f":"'Poule cumul (PC)'!C22","v":0},{"$f":"'Poule cumul (PC)'!D22","v":0},{"$f":"'Poule cumul (PC)'!F22","v":0}]
[{"$f":"'Poule cumul (PC)'!A23","v":"32ème"},{"$f":"'Poule cumul (PC)'!B23","v":0},{"$f":"'Poule cumul (PC)'!C23","v":0},{"$f":"'Poule cumul (PC)'!D23","v":0},{"$f":"'Poule cumul (PC)'!F23","v":0}]
[{"$f":"'Poule cumul (PC)'!A24","v":"16ème"},{"$f":"'Poule cumul (PC)'!B24","v":"0"},{"$f":"'Poule cumul (PC)'!C24","v":0},{"$f":"'Poule cumul (PC)'!D24","v":0},{"$f":"'Poule cumul (PC)'!F24","v":0}]
[{"$f":"'Poule cumul (PC)'!A25","v":"8ème "},{"$f":"'Poule cumul (PC)'!B25","v":8},{"$f":"'Poule cumul (PC)'!C25","v":0},{"$f":"'Poule cumul (PC)'!D25","v":0},{"$f":"'Poule cumul (PC)'!F25","v":0}]
[{"$f":"'Poule cumul (PC)'!A26","v":"1/4 de fin"},{"$f":"'Poule cumul (PC)'!B26","v":4},{"$f":"'Poule cumul (PC)'!C26","v":0},{"$f":"'Poule cumul (PC)'!D26","v":0},{"$f":"'Poule cumul (PC)'!F26","v":0}]
[{"$f":"'Poule cumul (PC)'!A27","v":"1/2 et finale "},{"$f":"'Poule cumul (PC)'!B27","v":4},{"$f":"'Poule cumul (PC)'!C27","v":0},{"$f":"'Poule cumul (PC)'!D27","v":0},{"$f":"'Poule cumul (PC)'!F27","v":0}]
[null,null,null,{"$f":"SUM(D14:D22)","v":0}]
[{"$f":"IF('Poule cumul (PC)'!F10=3,\"TRIPLETTE  Montant des 12 chèques des gagnants des 4 dernieres équipes\",IF('Poule cumul (PC)'!F10=2,\"DOUBLETTE  Montant des 8 chèques des gagnants des 4 dernieres équipes\",IF('Poule cumul (PC)'!F10=1,\"TETE A TETE  Montant des 4 chèques des gagnants des 4 derniers joueurs\",\"\")))","v":"TRIPLETTE  Montant des 12 chèques des gagnants des 4 dernieres équipes"},null,null,{"$f":"IF('Poule cumul (PC)'!F10=3,D22/12,IF('Poule cumul (PC)'!F10=2,D22/8,IF('Poule cumul (PC)'!F10=1,D22/4,\"\")))","v":0},8]
[]
[null,null,null,{"$f":"'Poule cumul (PC)'!I32","v":"Dernière mise à jour V21012018"}]

{"sheet":"ED-Cumul","index":3,"n_rows":32,"n_cols":11,"rows_kept":32,"cut":false,"hidden":false,"merged":[[31,0,31,7],[29,0,29,3],[29,4,29,5],[29,6,29,7],[29,9,29,10],[30,0,30,3],[30,4,30,5],[30,7,30,10],[13,0,13,5],[14,0,14,9],[16,1,16,3],[27,6,27,7],[27,9,27,10],[16,6,16,8],[7,0,7,9],[9,0,9,3],[10,0,10,3],[11,0,11,3],[12,0,12,5],[4,0,4,1],[4,2,4,4],[4,5,4,7],[5,0,5,1],[5,2,5,4],[5,5,5,7],[2,0,2,1],[2,2,2,4],[2,5,2,7],[3,0,3,1],[3,2,3,4],[3,5,3,7],[0,0,0,10],[1,0,1,1],[1,2,1,4],[1,5,1,7],[1,9,1,10]]}
["CALCUL AUTOMATIQUES DES INDEMNITES AUX JOUEURS   INDIVIDUEL, DOUBLETTE ET TRIPLETTE EN ELIMINATION DIRECTE AU CUMUL V21012018"]
["DELEGUE :",null,null,null,null,"Dotation de l'organisateurs :",null,null,null,"Indemnités "]
[" N° INTERNATIONAL :",null,null,null,null,null,null,null,null,null,{"$f":"I2","v":0}]
["N° NATIONAL :",null,null,null,null,"Nombres d'équipes engagées :",null,null,null,{"$f":"F10*G10","v":15},{"$f":"H10","v":0}]
["LIEU :",null,null,null,null,"Nombre équipe après première partie ",null,null,{"$f":"ROUNDUP($I$4/2,0)","v":0},"Total",{"$f":"SUM(K3:K4)","v":0}]
["RESPONSABLE "]
[]
[" I  Calcul du maximum au vainqueurs et du mininum 1/2 finale (Exemple) "]
[null,null,null,null,"Nbs équipe ","Ind. Doub. Trip.","Part/joueur"]
["Participation",null,null,null,{"$f":"I4","v":0},3,5,{"$f":"F10*G10*E10","v":0}]
["Dotation ",null,null,null,null,null,{"$f":"I2","v":0},{"$f":"I2","v":0}]
["Total indemnités",null,null,null,null,null,null,{"$f":"SUM(H10:H11)","v":0}]
["50% maxi de la dotation globale ",null,null,null,null,null,0.5,{"$f":"H12*G13","v":0}]
["25% mini de la dotation globale ",null,null,null,null,null,0.25,{"$f":"H12*G14","v":0}]
["II On informe uniquement les cellules grisées  "]
[]
[null,"Total indemnités",null,null,{"$f":"H12","v":0},null,"Parties d'offices non payées"]
[null,"Equipes indemnisés","Indemnités par équipe","Cumul par partie","Reste indemnités à répartir","Cumulé"]
["1ère partie ",{"$f":"I5","v":0},null,0,{"$f":"+E17","v":0},0]
["2éme partie",{"$f":"ROUNDUP($B$19/2,0)","v":0},null,{"$f":"B20*C20","v":0},{"$f":"E19-D20","v":0},{"$f":"C20","v":0}]
["cadrage ",{"$f":"IF(B20>=128,B20-128,IF(B20>=64,B20-\"64\",IF(B20>=32,B20-\"32\",IF(B20>=16,B20-16,0))))","v":0},null,{"$f":"B21*C21","v":0},{"$f":"E20-D21","v":0},{"$f":"C20+C21","v":0}]
["64ème",{"$f":"IF(B20-B21=128,128/2,0)","v":0},null,0,0,{"$f":"F21+C22","v":0}]
["32ème",{"$f":"IF(B20-B21=64,32,IF(B22=64,B22/2,0))","v":0},null,0,0,0]
["16ème",{"$f":"IF(B20-B21=32,\"16\",IF(B23=32,B23/2,\"0\"))","v":"0"},null,0,0,0]
["8ème ",8,null,0,0,0]
["1/4 ",4,null,0,0,0]
["1/2 & finale",4,{"$f":"E26/B27","v":0},{"$f":"B27*C27","v":0},{"$f":"E26-D27","v":0},0]
[]
[12,8,null,{"$f":"SUM(D19:D28)","v":0},null,null,"> ou à 25%",{"$f":"H14","v":0},"% Répartition","< ou = 50%",{"$f":"H13","v":0}]
[{"$f":"IF(F10=3,\"TRIPLETTE : 12 CHEQUES DE : \",IF(F10=2,\"DOUBLETTE : 8 CHEQUES DE : \",IF(F10=1,\"TETE A TETE : 4 CHEQUES de : \",\"\")))","v":"TRIPLETTE : 12 CHEQUES DE : "},null,null,null,{"$f":"IF(F10=3,E26/12,IF(F10=2,E26/8,IF(F10=1,E26/4,0)))","v":0},null,{"$f":"IF(I30<0.25,0,IF(I30>0.5,0,1))","v":{"$error":"#DIV/0!"}},null,{"$f":"J30/H12","v":{"$error":"#DIV/0!"}},{"$f":"E25","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(G30=1,\"La répartition est correcte\",IF(I30<0.25,\"Le pourcentage doit être > ou = à 25%\",IF(I30>0.5,\"Le pourcentage ne doit pas dépasser 50%\",\"\")))","v":{"$error":"#DIV/0!"}}]
["On renseigne uniquement les cellules bleutées et on adapte au % désiré.",null,null,null,null,null,null,null,{"$f":"'Poule cumul (PC)'!I32:K32","v":"Dernière mise à jour V21012018"}]

{"sheet":"Affichage ED-cumul","index":4,"n_rows":27,"n_cols":5,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,0,0,4],[9,1,9,2],[9,3,9,4],[11,0,11,4],[24,0,24,2],[10,0,10,4],[1,1,1,2],[2,1,2,2],[3,1,3,2],[4,1,4,2],[6,3,8,4],[8,1,8,2]]}
["INDEMNITES DES JOUEURS       ELIMINATION DIRECTE AU CUMUL"]
["DELEGUE",{"$f":"'ED-Cumul'!C2","v":0}]
["N° INTERNATIONAL :",{"$f":"'ED-Cumul'!C3","v":0}]
["N° NATIONAL :",{"$f":"'ED-Cumul'!C4","v":0}]
["LIEU :",{"$f":"'ED-Cumul'!C5","v":0}]
[]
["Inscrits ","Inscription","Total"," Attention! Les 1/4 de finale sont réglés en espèce.                                                                        % compris entre 25% et 50%"]
[{"$f":"'ED-Cumul'!I4","v":0},{"$f":"'ED-Cumul'!J4","v":15},{"$f":"'ED-Cumul'!H10","v":0}]
["DOTATION ",{"$f":"'ED-Cumul'!K3","v":0}]
["TOTAL INDEMNITES ",{"$f":"'ED-Cumul'!K5","v":0},null,{"$f":"'ED-Cumul'!I30","v":{"$error":"#DIV/0!"}}]
[]
["REPARTITION DES INDEMNITES "]
["PARTIES ","Equipes indemnisées","Indemnités par équipe","Total ","Indemnités cumulées "]
[{"$f":"'ED-Cumul'!A19","v":"1ère partie "},{"$f":"'ED-Cumul'!B19","v":0},{"$f":"'ED-Cumul'!C19","v":0},{"$f":"'ED-Cumul'!D19","v":0},{"$f":"'ED-Cumul'!F19","v":0}]
[{"$f":"'ED-Cumul'!A20","v":"2éme partie"},{"$f":"'ED-Cumul'!B20","v":0},{"$f":"'ED-Cumul'!C20","v":0},{"$f":"'ED-Cumul'!D20","v":0},{"$f":"'ED-Cumul'!F20","v":0}]
[{"$f":"'ED-Cumul'!A21","v":"cadrage "},{"$f":"'ED-Cumul'!B21","v":0},{"$f":"'ED-Cumul'!C21","v":0},{"$f":"'ED-Cumul'!D21","v":0},{"$f":"'ED-Cumul'!F21","v":0}]
[{"$f":"'ED-Cumul'!A22","v":"64ème"},{"$f":"'ED-Cumul'!B22","v":0},{"$f":"'ED-Cumul'!C22","v":0},{"$f":"'ED-Cumul'!D22","v":0},{"$f":"'ED-Cumul'!F22","v":0}]
[{"$f":"'ED-Cumul'!A23","v":"32ème"},{"$f":"'ED-Cumul'!B23","v":0},{"$f":"'ED-Cumul'!C23","v":0},{"$f":"'ED-Cumul'!D23","v":0},{"$f":"'ED-Cumul'!F23","v":0}]
[{"$f":"'ED-Cumul'!A24","v":"16ème"},{"$f":"'ED-Cumul'!B24","v":"0"},{"$f":"'ED-Cumul'!C24","v":0},{"$f":"'ED-Cumul'!D24","v":0},{"$f":"'ED-Cumul'!F24","v":0}]
[{"$f":"'ED-Cumul'!B25","v":8},{"$f":"'ED-Cumul'!B25","v":8},{"$f":"'ED-Cumul'!C25","v":0},{"$f":"'ED-Cumul'!D25","v":0},{"$f":"'ED-Cumul'!F25","v":0}]
[{"$f":"'ED-Cumul'!A26","v":"1/4 "},{"$f":"'ED-Cumul'!B26","v":4},{"$f":"'ED-Cumul'!C26","v":0},{"$f":"'ED-Cumul'!D26","v":0},{"$f":"'ED-Cumul'!F26","v":0}]
[{"$f":"'ED-Cumul'!A27","v":"1/2 & finale"},{"$f":"'ED-Cumul'!B27","v":4},{"$f":"'ED-Cumul'!C27","v":0},{"$f":"'ED-Cumul'!D27","v":0},{"$f":"'ED-Cumul'!F27","v":0}]
[]
[null,null,null,{"$f":"SUM(D14:D23)","v":0}]
[{"$f":"IF('ED-Cumul'!F10=3,\"TRIPLETTE  Montant des 12 chèques des gagnants des 4 dernieres équipes\",IF('ED-Cumul'!F10=2,\"DOUBLETTE  Montant des 8 chèques des gagnants des 4 dernieres équipes\",IF('ED-Cumul'!F10=1,\"TETE A TETE  Montant des 4 chèques des gagnants des 4 derniers joueurs\",\"\")))","v":"TRIPLETTE  Montant des 12 chèques des gagnants des 4 dernieres équipes"},null,null,{"$f":"IF('ED-Cumul'!F10=3,D22/12,IF('ED-Cumul'!F10=2,D22/8,IF('ED-Cumul'!F10=1,D22/4,\"\")))","v":0},8]
[]
[null,null,null,{"$f":"'Poule cumul (PC)'!I32","v":"Dernière mise à jour V21012018"}]

{"sheet":"ED-Partie-Perdue (PP)","index":5,"n_rows":32,"n_cols":11,"rows_kept":32,"cut":false,"hidden":false,"merged":[[32,0,32,11],[31,0,31,7],[29,0,29,3],[29,4,29,5],[29,6,29,7],[29,9,29,10],[30,0,30,3],[30,4,30,5],[30,7,30,10],[13,0,13,5],[14,0,14,9],[16,1,16,3],[27,6,27,7],[27,9,27,10],[16,6,16,8],[7,0,7,9],[9,0,9,3],[10,0,10,3],[11,0,11,3],[12,0,12,5],[4,0,4,1],[4,2,4,4],[4,5,4,7],[5,0,5,1],[5,2,5,4],[5,5,5,7],[2,0,2,1],[2,2,2,4],[2,5,2,7],[3,0,3,1],[3,2,3,4],[3,5,3,7],[0,0,0,10],[1,0,1,1],[1,2,1,4],[1,5,1,7],[1,9,1,10]]}
["CALCUL AUTOMATIQUES DES INDEMNITES AUX JOUEURS   INDIVIDUEL, DOUBLETTE ET TRIPLETTE EN ELIMINATION DIRECTE PARTIE PERDUE V21012018"]
["DELEGUE :",null,null,null,null,"Dotation de l'organisateurs :",null,null,null,"Indemnités "]
[" N° INTERNATIONAL :",null,null,null,null,null,null,null,null,null,{"$f":"I2","v":0}]
["N° NATIONAL :",null,null,null,null,"Nombre d'équipes engagées :",null,null,null,{"$f":"F10*G10","v":15},{"$f":"H10","v":0}]
["LIEU :",null,null,null,null,"Nombre équipes après première partie ",null,null,{"$f":"ROUNDUP($I$4/2,0)","v":0},"Total",{"$f":"SUM(K3:K4)","v":0}]
["RESPONSABLE "]
[]
[" I  Calcul du maximum au vainqueurs et du mininum 1/2 finale (Exemple) "]
[null,null,null,null,"Nbs équipe ","Ind. Doub. Trip.","Part/joueur"]
["Participation",null,null,null,{"$f":"I4","v":0},3,5,{"$f":"F10*G10*E10","v":0}]
["Dotation ",null,null,null,null,null,{"$f":"I2","v":0},{"$f":"I2","v":0}]
["Total indemnités",null,null,null,null,null,null,{"$f":"SUM(H10:H11)","v":0}]
["50% maxi de la dotation globale ",null,null,null,null,null,0.5,{"$f":"H12*G13","v":0}]
["25% mini de la dotation globale ",null,null,null,null,null,0.25,{"$f":"H12*G14","v":0}]
["II On informe uniquement les cellules grisées  "]
[]
[null,"Total indemnités",null,null,{"$f":"H12","v":0},null,"Parties d'offices non payées"]
[null,"Equipes indemnisés","Indemnités par équipe","Cumul par partie","Reste indemnités à répartir"]
["1ère partie ",{"$f":"I5","v":0},null,0,{"$f":"+E17","v":0}]
["2éme partie",{"$f":"ROUNDUP($B$19/2,0)","v":0},null,{"$f":"B20*C20","v":0},{"$f":"E19-D20","v":0}]
["cadrage ",{"$f":"IF(B20>=128,B20-128,IF(B20>=64,B20-\"64\",IF(B20>=32,B20-\"32\",IF(B20>=16,B20-16,0))))","v":0},null,{"$f":"B21*C21","v":0},{"$f":"E20-D21","v":0}]
["64ème",{"$f":"IF(B20-B21=128,128/2,0)","v":0},null,0,0]
["32ème",{"$f":"IF(B20-B21=64,32,IF(B22=64,B22/2,0))","v":0},null,0,0]
["16ème",{"$f":"IF(B20-B21=32,\"16\",IF(B23=32,B23/2,\"0\"))","v":"0"},null,0,0]
["8ème ",8,null,0,0]
["1/4 ",4,null,0,0]
["1/2 & finale",4,{"$f":"E26/B27","v":0},{"$f":"B27*C27","v":0},{"$f":"E26-D27","v":0}]
[]
[12,8,null,{"$f":"SUM(D19:D28)","v":0},null,null,"< ou = à 25%",{"$f":"H14","v":0},"% Répartition","> ou = à 50%",{"$f":"H13","v":0}]
[{"$f":"IF(F10=3,\"TRIPLETTE : 12 CHEQUES DE : \",IF(F10=2,\"DOUBLETTE : 8 CHEQUES DE : \",IF(F10=1,\"TETE A TETE : 4 CHEQUES de : \",\"\")))","v":"TRIPLETTE : 12 CHEQUES DE : "},null,null,null,{"$f":"IF(F10=3,D27/12,IF(F10=2,D27/8,IF(F10=1,D27/4,0)))","v":0},null,{"$f":"IF(I30<0.25,0,IF(I30>0.5,0,1))","v":{"$error":"#DIV/0!"}},null,{"$f":"J30/H12","v":{"$error":"#DIV/0!"}},{"$f":"E25","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(G30=1,\"La répartition est correcte\",IF(I30<0.25,\"Le pourcentage doit être > ou = à 25%\",IF(I30>0.5,\"Le pourcentage ne doit pas dépasser 50%\",\"\")))","v":{"$error":"#DIV/0!"}}]
["On renseigne uniquement les cellules bleutées et on adapte au % désiré.",null,null,null,null,null,null,null,{"$f":"'Poule cumul (PC)'!I32:K32","v":"Dernière mise à jour V21012018"}]

{"sheet":"Affichage ED-PP","index":6,"n_rows":27,"n_cols":5,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,0,0,4],[9,1,9,2],[9,3,9,4],[10,0,10,4],[11,0,11,4],[6,3,8,4],[24,0,24,2],[1,1,1,2],[2,1,2,2],[3,1,3,2],[4,1,4,2],[8,1,8,2]]}
["INDEMNITES DES JOUEURS           ELIMINATION DIRECTE A LA PARTIE PERDUE"]
["DELEGUE",{"$f":"'ED-Partie-Perdue (PP)'!C2","v":0}]
["N° INTERNATIONAL :",{"$f":"'ED-Partie-Perdue (PP)'!C3","v":0}]
["N° NATIONAL :",{"$f":"'ED-Partie-Perdue (PP)'!C4","v":0}]
["LIEU :",{"$f":"'ED-Partie-Perdue (PP)'!C5","v":0}]
[]
["Inscrits ","Inscription","Total"," Attention! Les 1/4 de finale sont réglés en espèce.                                                                        % compris entre 25% et 50%"]
[{"$f":"'ED-Partie-Perdue (PP)'!I4","v":0},{"$f":"'ED-Partie-Perdue (PP)'!J4","v":15},{"$f":"'ED-Partie-Perdue (PP)'!K4","v":0}]
["DOTATION ",{"$f":"'ED-Partie-Perdue (PP)'!K3","v":0}]
["TOTAL INDEMNITES ",{"$f":"'ED-Partie-Perdue (PP)'!K5","v":0},null,{"$f":"'ED-Partie-Perdue (PP)'!I30","v":{"$error":"#DIV/0!"}}]
[]
["REPARTITION DES INDEMNITES "]
["PARTIES ","Equipes indemnisées","Indemnités par équipe","Total "]
[{"$f":"'ED-Partie-Perdue (PP)'!A19","v":"1ère partie "},{"$f":"'ED-Partie-Perdue (PP)'!B19","v":0},{"$f":"'ED-Partie-Perdue (PP)'!C19","v":0},{"$f":"'ED-Partie-Perdue (PP)'!D19","v":0}]
[{"$f":"'ED-Partie-Perdue (PP)'!A20","v":"2éme partie"},{"$f":"'ED-Partie-Perdue (PP)'!B20","v":0},{"$f":"'ED-Partie-Perdue (PP)'!C20","v":0},{"$f":"'ED-Partie-Perdue (PP)'!D20","v":0}]
[{"$f":"'ED-Partie-Perdue (PP)'!A21","v":"cadrage "},{"$f":"'ED-Partie-Perdue (PP)'!B21","v":0},{"$f":"'ED-Partie-Perdue (PP)'!C21","v":0},{"$f":"'ED-Partie-Perdue (PP)'!D21","v":0}]
[{"$f":"'ED-Partie-Perdue (PP)'!A22","v":"64ème"},{"$f":"'ED-Partie-Perdue (PP)'!B22","v":0},{"$f":"'ED-Partie-Perdue (PP)'!C22","v":0},{"$f":"'ED-Partie-Perdue (PP)'!D22","v":0}]
[{"$f":"'ED-Partie-Perdue (PP)'!A23","v":"32ème"},{"$f":"'ED-Partie-Perdue (PP)'!B23","v":0},{"$f":"'ED-Partie-Perdue (PP)'!C23","v":0},{"$f":"'ED-Partie-Perdue (PP)'!D23","v":0}]
[{"$f":"'ED-Partie-Perdue (PP)'!A24","v":"16ème"},{"$f":"'ED-Partie-Perdue (PP)'!B24","v":"0"},{"$f":"'ED-Partie-Perdue (PP)'!C24","v":0},{"$f":"'ED-Partie-Perdue (PP)'!D24","v":0}]
[{"$f":"'ED-Partie-Perdue (PP)'!A25","v":"8ème "},{"$f":"'ED-Partie-Perdue (PP)'!B25","v":8},{"$f":"'ED-Partie-Perdue (PP)'!C25","v":0},{"$f":"'ED-Partie-Perdue (PP)'!D25","v":0}]
[{"$f":"'ED-Partie-Perdue (PP)'!A26","v":"1/4 "},{"$f":"'ED-Partie-Perdue (PP)'!B26","v":4},{"$f":"'ED-Partie-Perdue (PP)'!C26","v":0},{"$f":"'ED-Partie-Perdue (PP)'!D26","v":0}]
[{"$f":"'ED-Partie-Perdue (PP)'!A27","v":"1/2 & finale"},{"$f":"'ED-Partie-Perdue (PP)'!B27","v":4},{"$f":"'ED-Partie-Perdue (PP)'!C27","v":0},{"$f":"'ED-Partie-Perdue (PP)'!D27","v":0}]
[]
[null,null,null,{"$f":"SUM(D14:D23)","v":0}]
[{"$f":"IF('ED-Partie-Perdue (PP)'!F10=3,\"TRIPLETTE  Montant des 12 chèques des gagnants des 4 dernieres équipes\",IF('ED-Partie-Perdue (PP)'!F10=2,\"DOUBLETTE  Montant des 8 chèques des gagnants des 4 dernieres équipes\",IF('ED-Partie-Perdue (PP)'!F10=1,\"TETE A TETE  Montant des 4 chèques des gagnants des 4 derniers joueurs\",\"\")))","v":"TRIPLETTE  Montant des 12 chèques des gagnants des 4 dernieres équipes"},null,null,{"$f":"IF('ED-Partie-Perdue (PP)'!F10=3,D22/12,IF('ED-Partie-Perdue (PP)'!F10=2,D22/8,IF('ED-Partie-Perdue (PP)'!F10=1,D22/4,\"\")))","v":0},8]
[]
[null,null,null,{"$f":"'Poule cumul (PC)'!I32","v":"Dernière mise à jour V21012018"}]

{"sheet":"Poule (PP)","index":7,"n_rows":32,"n_cols":12,"rows_kept":32,"cut":false,"hidden":false,"merged":[[31,0,31,7],[32,0,32,7],[32,8,32,11],[29,6,29,7],[29,9,29,10],[30,0,30,3],[30,4,30,5],[30,7,30,10],[12,0,12,5],[12,8,12,10],[13,0,13,5],[14,0,14,9],[16,1,16,3],[6,0,6,8],[7,0,7,7],[9,0,9,3],[10,0,10,3],[11,0,11,3],[4,0,4,1],[4,2,4,4],[4,5,4,7],[5,0,5,1],[5,2,5,4],[5,5,5,7],[2,0,2,1],[2,2,2,4],[2,5,2,7],[3,0,3,1],[3,2,3,4],[3,5,3,7],[0,0,0,10],[1,0,1,1],[1,2,1,4],[1,5,1,7],[1,9,1,10]]}
["CALCUL AUTOMATIQUE DES INDEMNITES AUX JOUEURS     INDIVIDUEL, DOUBLETTE & TRIPLETTE EN POULE A LA PARTIE PERDUE  V21012018"]
["DELEGUE :",null,null,null,null,"Dotation de l'organisateurs :",null,null,null,"Indemnités "]
[" N° INTERNATIONAL :",null,null,null,null,null,null,null,null,null,{"$f":"I2","v":0}]
["N° NATIONAL :",null,null,null,null,"Nombre d'équipes engagées :",null,null,null,{"$f":"H10","v":15},{"$f":"I4*J4","v":0},4]
["LIEU :",null,null,null,null,"Nombre de poule :",null,null,{"$f":"ROUNDUP($I$4/4,0)","v":0},"Total",{"$f":"SUM(K3:K4)","v":0}]
["RESPONSABLE ",null,null,null,null,"Nombre équipes sortie de Poule :",null,null,{"$f":"I5*2","v":0}]
["Attention ce tableau ne fonctionne qu'a partir de 61 équipes "]
["I. Calcul du maximum à verser aux vainqueurs des 8ème de finale "]
[null,null,null,null,"Nbs équipe ","Ind. Doub. Trip.","Part/joueur"]
["Participation",null,null,null,1,3,5,{"$f":"E10*F10*G10","v":15}]
["Dotation ",null,null,null,null,null,{"$f":"I2","v":0},{"$f":"G11","v":0}]
["Total indemnités",null,null,null,null,null,null,{"$f":"K5","v":0}]
["50% maxi de la dotation globale ",null,null,null,null,null,0.5,{"$f":"H12*G13","v":0}]
["25% mini de la dotation globale ",null,null,null,null,null,0.25,{"$f":"H12*G14","v":0}]
["II. On renseigne uniquement les cellules bleutées "]
[]
[null,"Total indemnités",null,null,{"$f":"H12","v":0}]
["PAIEMENT AU CUMUL","Equipes indemnisées","Indemnités par équipe","Cumul par partie","Reste indemnités à répartir"]
["Sortie poule",{"$f":"I6","v":0},null,{"$f":"B19*C19","v":0},{"$f":"E17-D19","v":0},null,null,"= engagement"]
["1° partie après les poules",{"$f":"B19/2","v":0},null,0,{"$f":"E19-D20","v":0},null,"nbre equipes à faire le cadrage","= engagement ou C20 + 5€"]
["Cadrage ",{"$f":"IF(B20>=128,B20-128,IF(B20>=64,B20-\"64\",IF(B20>=32,B20-\"32\",IF(B20>=16,B20-16,0))))","v":0},null,0,0,null,{"$f":"B*2","v":{"$error":"#NAME?"}},"= C21 + 5€"]
["64ème",{"$f":"IF(B20-B21=128,128/2,0)","v":0},null,0,0]
["32ème",{"$f":"IF(B20-B21=64,32,IF(B22=64,B22/2,0))","v":0},null,0,0]
["16ème",{"$f":"IF(B20-B21=32,\"16\",IF(B23=32,B23/2,\"0\"))","v":"0"},null,{"$f":"B24*C24","v":0},0]
["8ème ",8,null,{"$f":"B25*C25","v":0},0]
["1/4 de fin",4,null,0,{"$f":"E25-D26","v":0}]
["1/2 et finale ",4,{"$f":"E26/B27","v":0},{"$f":"B27*C27","v":0},{"$f":"E26-D27","v":0}]
[]
[null,null,null,null,null,null,"> ou = à 25%",{"$f":"H14","v":0},"% Répartition","< ou = 50 %",{"$f":"H13","v":0}]
[null,null,null,{"$f":"SUM(D19:D29)","v":0},null,null,{"$f":"IF(I30<0.25,0,IF(I30>0.5,0,1))","v":{"$error":"#DIV/0!"}},null,{"$f":"J30/H12","v":{"$error":"#DIV/0!"}},{"$f":"E25","v":0}]
[{"$f":"IF(F10=3,\"TRIPLETTE : 12 CHEQUES DE : \",IF(F10=2,\"DOUBLETTE : 8 CHEQUES DE : \",IF(F10=1,\"TETE A TETE : 4 CHEQUES de : \",\"\")))","v":"TRIPLETTE : 12 CHEQUES DE : "},null,null,null,{"$f":"IF(F10=3,E26/12,IF(F10=2,E26/8,IF(F10=1,E26/4,0)))","v":0},null,12,{"$f":"IF(G30=1,\"La répartition est correcte\",IF(I30<0.25,\"Le pourcentage doit être > ou = à 25%\",IF(I30>0.5,\"Le pourcentage ne doit pas dépasser 50%\",\"\")))","v":{"$error":"#DIV/0!"}}]
["On renseigne uniquement les cellules bleutées et on adapte au % désiré.",null,null,null,null,null,null,null,{"$f":"'Poule cumul (PC)'!I32","v":"Dernière mise à jour V21012018"}]

{"sheet":"Affichage P PP","index":8,"n_rows":26,"n_cols":5,"rows_kept":26,"cut":false,"hidden":false,"merged":[[10,0,10,4],[11,0,11,4],[23,0,23,2],[0,0,0,4],[1,1,1,2],[2,1,2,2],[3,1,3,2],[4,1,4,2],[6,3,8,4],[8,1,8,2],[9,1,9,2],[9,3,9,4]]}
["INDEMNITES DES JOUEURS   POULE A LA PARTIE PERDUE"]
["DELEGUE",{"$f":"'Poule (PP)'!C2","v":0}]
["N° INTERNATIONAL :",{"$f":"'Poule (PP)'!C3","v":0}]
["N° NATIONAL :",{"$f":"'Poule (PP)'!C4","v":0}]
["LIEU :",{"$f":"'Poule (PP)'!C5","v":0}]
[]
["Inscrits ","Inscription","Total"," Attention! Les 1/4 de finale sont réglés en espèce.                                                                        % compris entre 25% et 50%"]
[{"$f":"'Poule (PP)'!I4","v":0},{"$f":"'Poule (PP)'!J4","v":15},{"$f":"A8*B8","v":0}]
["DOTATION ",{"$f":"'Poule (PP)'!I2","v":0}]
["TOTAL INDEMNITES ",{"$f":"C8+B9","v":0},null,{"$f":"'Poule (PP)'!I30","v":{"$error":"#DIV/0!"}}]
[]
["REPARTITION DES INDEMNITES "]
["PARTIES ","Equipes indemnisées","Indemnités par équipe","Total "]
[{"$f":"'Poule cumul (PC)'!A19","v":"Sortie poule"},{"$f":"'Poule (PP)'!B19","v":0},{"$f":"'Poule (PP)'!C19","v":0},{"$f":"'Poule (PP)'!D19","v":0}]
[{"$f":"'Poule cumul (PC)'!A20","v":"1° partie après les poules"},{"$f":"'Poule (PP)'!B20","v":0},{"$f":"'Poule (PP)'!C20","v":0},{"$f":"'Poule (PP)'!D20","v":0}]
[{"$f":"'Poule cumul (PC)'!A21","v":"Cadrage "},{"$f":"'Poule (PP)'!B21","v":0},{"$f":"'Poule (PP)'!C21","v":0},{"$f":"'Poule (PP)'!D21","v":0}]
[{"$f":"'Poule cumul (PC)'!A22","v":"64ème"},{"$f":"'Poule (PP)'!B22","v":0},{"$f":"'Poule (PP)'!C22","v":0},{"$f":"'Poule (PP)'!D22","v":0}]
[{"$f":"'Poule cumul (PC)'!A23","v":"32ème"},{"$f":"'Poule (PP)'!B23","v":0},{"$f":"'Poule (PP)'!C23","v":0},{"$f":"'Poule (PP)'!D23","v":0}]
[{"$f":"'Poule cumul (PC)'!A24","v":"16ème"},{"$f":"'Poule (PP)'!B24","v":"0"},{"$f":"'Poule (PP)'!C24","v":0},{"$f":"'Poule (PP)'!D24","v":0}]
[{"$f":"'Poule cumul (PC)'!A25","v":"8ème "},{"$f":"'Poule (PP)'!B25","v":8},{"$f":"'Poule (PP)'!C25","v":0},{"$f":"'Poule (PP)'!D25","v":0}]
[{"$f":"'Poule cumul (PC)'!A26","v":"1/4 de fin"},{"$f":"'Poule (PP)'!B26","v":4},{"$f":"'Poule (PP)'!C26","v":0},{"$f":"'Poule (PP)'!D26","v":0}]
[{"$f":"'Poule cumul (PC)'!A27","v":"1/2 et finale "},{"$f":"'Poule (PP)'!B27","v":4},{"$f":"'Poule (PP)'!C27","v":0},{"$f":"'Poule (PP)'!D27","v":0}]
[null,null,null,{"$f":"SUM(D14:D22)","v":0}]
[{"$f":"IF('Poule (PP)'!F10=3,\"TRIPLETTE  Montant des 12 chèques des gagnants des 4 dernieres équipes\",IF('Poule (PP)'!F10=2,\"DOUBLETTE  Montant des 8 chèques des gagnants des 4 dernieres équipes\",IF('Poule (PP)'!F10=1,\"TETE A TETE  Montant des 4 chèques des gagnants des 4 derniers joueurs\",\"\")))","v":"TRIPLETTE  Montant des 12 chèques des gagnants des 4 dernieres équipes"},null,null,{"$f":"IF('Poule (PP)'!F10=3,D22/12,IF('Poule (PP)'!F10=2,D22/8,IF('Poule (PP)'!F10=1,D22/4,\"\")))","v":0},8]
[]
[null,null,null,{"$f":"'Poule cumul (PC)'!I32","v":"Dernière mise à jour V21012018"}]