{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["MENU"," ED PARTIE PERDUE","AFFICHAGE PP","CR ED PP","ED CUMUL","AFFICHAGE CUMUL","CR ED CUMUL"],"not_rendered":{"charts":0,"images":3,"macros":0,"external_links":1,"defined_names":1,"comments":2,"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":" ED PARTIE PERDUE","index":1,"n_rows":38,"n_cols":11,"rows_kept":38,"cut":false,"hidden":false,"merged":[[37,5,37,12],[36,6,36,9],[20,1,20,3],[4,0,4,1],[4,2,4,4],[7,0,7,1],[7,2,7,4],[15,0,15,5],[14,0,14,5],[9,0,9,9],[33,0,33,2],[33,6,33,10],[7,5,7,7],[12,0,12,6],[11,0,11,4],[5,2,5,4],[0,0,0,10],[1,0,1,1],[1,2,1,4],[1,5,1,7],[1,9,1,10],[2,0,2,1],[3,0,3,1],[3,2,3,4],[2,2,2,4],[2,5,2,7],[5,5,5,7],[6,0,6,1],[6,2,6,4],[6,5,6,7],[5,0,5,1],[13,0,13,6],[31,6,32,7],[31,8,32,8],[31,9,32,9],[20,6,20,10],[31,10,32,10],[34,9,34,10],[35,9,35,10],[16,0,16,12],[30,6,30,7],[18,0,18,9]]}
["CALCUL AUTOMATIQUE DES INDEMNITES AUX JOUEURS - JEU PROVENÇAL EN ELIMINATION DIRECTE A LA PARTIE PERDUE  "]
["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":"SUM(I2)","v":0}]
[" N°  SUPRANATIONAL :"]
[" N° EVENENEMENTIEL :"]
["N° NATIONAL :",null,null,null,null,"Nombre d'équipes engagées :",null,null,null,{"$f":"F12*G12","v":0},{"$f":"SUM(I6*J6)","v":0}]
["LIEU :",null,null,null,null,"Nombre équipes à la première partie",null,null,{"$f":"ROUNDUP($I$6/2,0)","v":0},"Total",{"$f":"SUM(K3:K6)","v":0}]
["RESPONSABLE :"]
[]
[" I  Calcul du maximum au vainqueurs et du minium 1/2 finale (Exemple) "]
[null,null,null,null,null,"Doub. Trip.","Part/joueur"]
["Formation",null,null,null,null,3,{"$f":"IF(ISNUMBER(C6),6,0)+IF(ISNUMBER(C3),8,0)+IF(ISNUMBER(C4),8,0)+IF(ISNUMBER(C5),8,0)","v":0},{"$f":"SUM(F12*G12*I6)","v":0}]
["Dotation ",null,null,null,null,null,null,{"$f":"SUM(I2)","v":0}]
["Total indemnités",null,null,null,null,null,null,{"$f":"SUM(H12:H13)","v":0}]
["REGLEMENT : Vainqueur < ou = 25% de la dotation globale ",null,null,null,null,null,0.25,{"$f":"SUM(H14*G15)","v":0}]
["REGLEMENT  : Finaliste > ou = 60% de l'indemnité du vainqueur",null,null,null,null,null,0.6,{"$f":"SUM(H15*G16)","v":0}]
[]
[]
["II On informe uniquement les cellules bleutées"]
[]
[null,"Total indemnités",null,null,{"$f":"SUM(K7)","v":0},null,"Parties gagnées  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":"SUM(I7)","v":0},0,{"$f":"SUM(B23*C23)","v":0},{"$f":"SUM(E21)","v":0}]
["2ème partie",{"$f":"ROUNDUP($B$23/2,0)","v":0},0,{"$f":"SUM(B24*C24)","v":0},{"$f":"SUM(E23-D24)","v":0}]
["cadrage ",{"$f":"IF(B24>=128,B24-128,IF(B24>=64,B24-\"64\",IF(B24>=32,B24-\"32\",IF(B24>=16,B24-16,0))))","v":0},0,0,{"$f":"SUM(E24-D25)","v":0}]
["64ème",{"$f":"IF(B24-B25=128,128/2,0)","v":0},0,0,{"$f":"SUM(E25-D26)","v":0}]
["32ème",{"$f":"IF(B24-B25=64,32,IF(B26=64,B26/2,0))","v":0},0,0,0]
["16ème",{"$f":"IF(B24-B25=32,16,IF(B27=32,B27/2,0))","v":0},0,0,0]
["8ème ",8,0,0,0]
["1/4 ",4,0,0,0]
["1/2",2,0,0,0]
["Finaliste",1,0,0,0,null,"L'indemnité réelle du vainqueur ",null,{"$f":"SUM(C33)","v":0},"< ou =",{"$f":"SUM(H15)","v":0}]
["Vainqueur",1,{"$f":"SUM(E32)","v":0},0,{"$f":"SUM(E32-D33)","v":0}]
[null,null,null,{"$f":"SUM(D23:D33)","v":0}]
[null,null,null,null,null,{"$f":"IF(I32<0.25*D34,0,1)","v":1},"Vainqueur",{"$f":"SUM(C33)","v":0},{"$f":"SUM(H35/D34)","v":{"$error":"#DIV/0!"}},{"$f":"IF(F35=0,\"Répartition correcte\",\"Répartition incorrecte\")","v":"Répartition incorrecte"}]
[null,null,null,null,null,{"$f":"IF(H36>=0.6*H35,0,1)","v":0},"Finaliste",{"$f":"SUM(C32)","v":0},{"$f":"SUM(H36/H35)","v":{"$error":"#DIV/0!"}},{"$f":"IF(F36=0,\"Répartition correcte\",\"Répartition incorrecte\")","v":"Répartition correcte"}]
["VAINQUEUR",{"$f":"IF(F12=3,\"TRIPLETTES : 3 chèques de : \",IF(F12=2,\"DOUBLETTES : 2 chèques deE : \",IF(F12=1,\"TETE A TETE : 1 chèque de : \",\"\")))","v":"TRIPLETTES : 3 chèques de : "},null,{"$f":"IF(F12=3,(C33)/3,IF(F12=2,(C33)/2,IF(F12=1,(C33)/1,0)))","v":0}]
["FINALISTE",{"$f":"IF(F12=3,\"TRIPLETTES : 3 chèques de : \",IF(F12=2,\"DOUBLETTES : 2 chèques de : \",IF(F12=1,\"TETE A TETE : 1 chèque de : \",\"\")))","v":"TRIPLETTES : 3 chèques de : "},null,{"$f":"IF(F12=3,C32/3,IF(F12=2,C32/2,IF(F12=1,C32/1,0)))","v":0}]

{"sheet":"AFFICHAGE PP","index":2,"n_rows":29,"n_cols":5,"rows_kept":29,"cut":false,"hidden":false,"merged":[[3,1,3,2],[4,1,4,2],[11,1,11,2],[13,0,13,4],[0,0,0,4],[1,1,1,2],[2,1,2,2],[5,1,5,2],[6,1,6,2],[10,1,10,2],[1,3,6,4],[8,3,8,4],[9,3,9,4]]}
["INDEMNITES - JEU PROVENÇAL - ELIMINATION DIRECTE PARTIE PERDUE "]
["DELEGUE",{"$f":"IF(' ED PARTIE PERDUE'!C2=0,\"\",' ED PARTIE PERDUE'!C2)","v":""}]
["  N° INTERNATIONAL :",{"$f":"IF(' ED PARTIE PERDUE'!C3=0,\"\",' ED PARTIE PERDUE'!C3)","v":""}]
[" N°  SUPRANATIONAL :",{"$f":"IF(' ED PARTIE PERDUE'!C4=0,\"\",' ED PARTIE PERDUE'!C4)","v":""}]
[" N° EVENENEMENTIEL :",{"$f":"IF(' ED PARTIE PERDUE'!C5=0,\"\",' ED PARTIE PERDUE'!C5)","v":""}]
["N° NATIONAL :",{"$f":"IF(' ED PARTIE PERDUE'!C6=0,\"\",' ED PARTIE PERDUE'!C6)","v":""}]
["LIEU :",{"$f":"IF(' ED PARTIE PERDUE'!C7=0,\"\",' ED PARTIE PERDUE'!C7)","v":""}]
[]
["INSCRITS","Inscription","Total","REGLEMENT : Vainqueur < ou = 25% de la dotation globale "]
[{"$f":"SUM(' ED PARTIE PERDUE'!I6)","v":0},{"$f":"SUM(' ED PARTIE PERDUE'!J6)","v":0},{"$f":"SUM(' ED PARTIE PERDUE'!K6)","v":0},"REGLEMENT  : Finaliste > ou = 60% de l'indemnité du vainqueur"]
["DOTATION ",{"$f":"SUM(' ED PARTIE PERDUE'!I2)","v":0},null,"Vainqueur",{"$f":"C26/B12","v":{"$error":"#DIV/0!"}}]
["TOTAL INDEMNITES ",{"$f":"SUM(' ED PARTIE PERDUE'!K7)","v":0},null,"Finaliste",{"$f":"C25/C26","v":{"$error":"#DIV/0!"}}]
[]
["REPARTITION DES INDEMNITES "]
["PARTIES ","Equipes indemnisées","Indemnités par équipe","Indemnité par partie","Reste indemnités     à répartir"]
["1ère partie",{"$f":"(' ED PARTIE PERDUE'!B23)","v":0},{"$f":"SUM(' ED PARTIE PERDUE'!C23)","v":0},{"$f":"SUM(' ED PARTIE PERDUE'!D23)","v":0},{"$f":"SUM(' ED PARTIE PERDUE'!E23)","v":0}]
["2ème partie",{"$f":"(' ED PARTIE PERDUE'!B24)","v":0},{"$f":"SUM(' ED PARTIE PERDUE'!C24)","v":0},{"$f":"SUM(' ED PARTIE PERDUE'!D24)","v":0},{"$f":"SUM(' ED PARTIE PERDUE'!E24)","v":0}]
["cadrage ",{"$f":"(' ED PARTIE PERDUE'!B25)","v":0},{"$f":"SUM(' ED PARTIE PERDUE'!C25)","v":0},{"$f":"SUM(' ED PARTIE PERDUE'!D25)","v":0},{"$f":"SUM(' ED PARTIE PERDUE'!E25)","v":0}]
["64ème",{"$f":"(' ED PARTIE PERDUE'!B26)","v":0},{"$f":"SUM(' ED PARTIE PERDUE'!C26)","v":0},{"$f":"SUM(' ED PARTIE PERDUE'!D26)","v":0},{"$f":"SUM(' ED PARTIE PERDUE'!E26)","v":0}]
["32ème",{"$f":"(' ED PARTIE PERDUE'!B27)","v":0},{"$f":"SUM(' ED PARTIE PERDUE'!C27)","v":0},{"$f":"SUM(' ED PARTIE PERDUE'!D27)","v":0},{"$f":"SUM(' ED PARTIE PERDUE'!E27)","v":0}]
["16ème",{"$f":"(' ED PARTIE PERDUE'!B28)","v":0},{"$f":"SUM(' ED PARTIE PERDUE'!C28)","v":0},{"$f":"SUM(' ED PARTIE PERDUE'!D28)","v":0},{"$f":"SUM(' ED PARTIE PERDUE'!E28)","v":0}]
["8ème ",{"$f":"(' ED PARTIE PERDUE'!B29)","v":8},{"$f":"SUM(' ED PARTIE PERDUE'!C29)","v":0},{"$f":"SUM(' ED PARTIE PERDUE'!D29)","v":0},{"$f":"SUM(' ED PARTIE PERDUE'!E29)","v":0}]
["1/4 ",{"$f":"(' ED PARTIE PERDUE'!B30)","v":4},{"$f":"SUM(' ED PARTIE PERDUE'!C30)","v":0},{"$f":"SUM(' ED PARTIE PERDUE'!D30)","v":0},{"$f":"SUM(' ED PARTIE PERDUE'!E30)","v":0}]
["1/2",{"$f":"(' ED PARTIE PERDUE'!B31)","v":2},{"$f":"SUM(' ED PARTIE PERDUE'!C31)","v":0},{"$f":"SUM(' ED PARTIE PERDUE'!D31)","v":0},{"$f":"SUM(' ED PARTIE PERDUE'!E31)","v":0}]
["Finaliste",{"$f":"(' ED PARTIE PERDUE'!B32)","v":1},{"$f":"SUM(' ED PARTIE PERDUE'!C32)","v":0},{"$f":"SUM(' ED PARTIE PERDUE'!D32)","v":0},{"$f":"SUM(' ED PARTIE PERDUE'!E32)","v":0}]
["Vainqueur",{"$f":"(' ED PARTIE PERDUE'!B33)","v":1},{"$f":"SUM(' ED PARTIE PERDUE'!C33)","v":0},{"$f":"SUM(' ED PARTIE PERDUE'!D33)","v":0},{"$f":"SUM(' ED PARTIE PERDUE'!E33)","v":0}]
[null,null,null,{"$f":"SUM(D16:D26)","v":0},8]
["VAINQUEUR :","chèque par joueur",{"$f":"SUM(' ED PARTIE PERDUE'!D37)","v":0}]
["FINALISTE :","chèque par joueur",{"$f":"SUM(' ED PARTIE PERDUE'!D38)","v":0}]

{"sheet":"CR ED PP","index":3,"n_rows":193,"n_cols":6,"rows_kept":193,"cut":false,"hidden":false,"merged":[[10,0,10,2],[11,0,11,1],[0,0,2,0],[0,1,0,5],[1,1,1,5],[2,1,2,5],[4,0,4,5],[5,0,5,5],[6,1,9,1],[16,3,16,5],[17,0,17,1],[17,2,17,3],[17,4,17,5],[18,0,18,3],[24,0,24,1],[11,4,11,5],[12,4,12,5],[13,3,13,5],[14,3,14,5],[15,3,15,5],[12,0,12,3],[32,0,32,5],[33,0,33,5],[34,0,34,5],[35,0,35,1],[35,2,35,3],[36,0,36,1],[36,2,36,3],[25,0,25,1],[25,2,25,4],[26,2,27,4],[29,0,29,5],[30,0,30,2],[31,0,31,5],[43,0,43,5],[44,2,45,2],[44,4,45,4],[44,5,45,5],[46,0,46,5],[47,4,49,4],[38,0,38,5],[39,0,39,5],[40,0,40,1],[40,2,40,3],[41,0,41,1],[41,2,41,3],[68,4,70,4],[71,0,71,5],[84,0,84,5],[85,4,87,4],[88,4,90,4],[91,0,91,5],[50,4,52,4],[53,4,55,4],[56,4,58,4],[59,4,61,4],[62,4,64,4],[65,4,67,4],[101,0,101,1],[102,0,102,1],[102,3,102,5],[103,0,103,1],[105,0,105,2],[105,3,105,5],[92,4,94,4],[95,0,95,5],[96,4,98,4],[99,0,99,5],[100,0,100,1],[100,3,100,5],[151,3,151,5],[152,3,152,5],[108,4,108,5],[110,0,110,5],[111,1,111,4],[116,2,116,3],[112,2,115,3],[132,2,132,3],[132,4,132,5],[133,2,133,3],[133,4,133,5],[131,0,131,3],[135,0,135,5],[137,2,138,2],[137,4,138,4],[137,5,138,5],[146,0,146,5],[147,3,147,5],[148,3,149,5],[150,3,150,5],[160,0,160,1],[161,0,161,1],[162,0,163,5],[164,0,164,5],[165,0,165,5],[166,0,166,5],[153,3,153,5],[154,0,154,1],[156,1,156,2],[156,4,156,5],[158,0,158,1],[158,4,158,5],[173,0,173,1],[174,0,174,1],[175,0,175,1],[176,0,176,1],[177,0,177,1],[178,0,178,1],[167,0,167,5],[168,3,168,5],[170,0,170,5],[171,0,171,1],[171,2,171,5],[172,0,172,5],[191,2,192,2],[191,4,192,4],[191,5,192,5],[179,0,179,1],[180,0,180,1],[181,0,181,1],[182,0,182,1],[183,0,183,1],[184,0,184,1],[106,0,106,2],[107,0,107,2],[243,0,243,5],[209,4,211,4],[212,4,214,4],[215,4,217,4],[218,4,220,4],[221,4,223,4],[224,4,226,4],[193,0,193,5],[194,4,196,4],[197,4,199,4],[200,4,202,4],[203,4,205,4],[206,4,208,4],[227,4,229,4],[230,4,232,4],[233,4,235,4],[236,4,238,4],[239,4,241,4],[185,0,185,1],[187,0,187,5],[188,0,188,5],[190,0,190,5]]}
[null,"FEDERATION FRANÇAISE DE PETANQUE  ET JEU PROVENÇAL"]
[null,"Agréée par le Ministère des Sports"]
[null,"Siège social : 13, rue Trigance – 13002  MARSEILLE"]
[]
["RAPPORT DE DELEGATION & D’ARBITRAGE"]
["Concours nationaux  IND. TRIP. DOUB. en élimination directe à la partie perdue"]
[null,"N° Identification","SUPRA NATIONAL",{"$f":"IF(' ED PARTIE PERDUE'!C4=0,\"\",' ED PARTIE PERDUE'!C4)","v":""},"*"]
[null,null,"INTERNATIONAL",{"$f":"IF(' ED PARTIE PERDUE'!C3=0,\"\",' ED PARTIE PERDUE'!C3)","v":""},"*"]
[null,null,"NATIONAL",{"$f":"IF(' ED PARTIE PERDUE'!C6=0,\"\",' ED PARTIE PERDUE'!C6)","v":""},"*"]
[null,null,"EVENEMENTIEL ",{"$f":"IF(' ED PARTIE PERDUE'!C5=0,\"\",' ED PARTIE PERDUE'!C5)","v":""},"*"]
[]
["INTITULE DU CONCOURS : ",null,null,"LIEU :",{"$f":"IF(' ED PARTIE PERDUE'!C7=0,\"\",' ED PARTIE PERDUE'!C7)","v":""}]
["Date",null,null,null,{"$f":"IF(' ED PARTIE PERDUE'!C3=0,\"\",' ED PARTIE PERDUE'!C3)","v":""}]
[null,"C. D. et C.R.","Nom et Prénom","QUALITE"]
["Délégué :",null,{"$f":"IF(' ED PARTIE PERDUE'!C2=0,\"\",' ED PARTIE PERDUE'!C2)","v":""}]
["Arbitre :"]
["Organisateur : ",null,{"$f":"IF(' ED PARTIE PERDUE'!C8=0,\"\",' ED PARTIE PERDUE'!C8)","v":""}]
["ADRESSE E-mail et Tél. du Délégué :"]
["FORMULE RETENUE "]
["Triplettes",{"$f":"IF(' ED PARTIE PERDUE'!F12=3,\"X\",\"\")","v":"X"},"Sénior"]
["Doublettes",{"$f":"IF(' ED PARTIE PERDUE'!F12=2,\"X\",\"\")","v":""},"Féminines"]
["Individuel",{"$f":"IF(' ED PARTIE PERDUE'!F12=1,\"X\",\"\")","v":""},"Vétérans "]
[null,null,"Mixte"]
[]
[]
["Tirage au sort effectué le :",null,"En présence"]
["Date "]
["Informatique"]
[]
["OBSERVATIONS DE L'ARBITRE PRINCIPAL"]
["Nombre d’arbitres ayant officié à ses côtés :"]
["Qualité de l’arbitrage dispensé :"]
[]
["Avis sur la qualité de l’organisation "]
[]
["L'Arbitre FFPJP désigné :",null,{"$f":"IF(C16=0,\"\",C16)","v":""}]
["(nom, prénom, signature",null,{"$f":"IF(C16=0,\"\",C16)","v":""}]
[]
["OBSERVATIONS GENERALE DU DELEGUE"]
[]
["Le délégué F.F.P.J.P. ou C.R.",null,{"$f":"IF(C15=0,\"\",C15)","v":""}]
["(signature)",null,{"$f":"IF(C15=0,\"\",C15)","v":""}]
[]
["RESULTAT DU CONCOURS (à remplir par le délégué)"]
["N°","Nom, Prénom","Association ou Club","N°","N° D'équipe"]
["Licence","en lettres majuscules",null,"Dép."]
["Perdants 1/8 Finale"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Perdants ¼ Finale"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Perdants ½ Finale"]
[]
[]
[]
[]
[]
[]
["Finalistes"]
[]
[]
[]
["Vainqueurs"]
[]
[]
[]
["INDEMNITES  : (article 8 du règlement des concours Internationaux et Nationaux)"]
["Dotation de l'organisation",null,{"$f":"SUM(' ED PARTIE PERDUE'!I2)","v":0},{"$f":"C101","v":0}]
["Frais de participation",null,{"$f":"SUM(' ED PARTIE PERDUE'!J6)","v":0}]
["Nombre d'équipes inscrites",null,{"$f":"SUM(' ED PARTIE PERDUE'!I6)","v":0},{"$f":"C102*C103","v":0}]
["Nombre d'équipes présentes"]
[]
["TOTAL DES INDEMNITES DISTRIBUEES",null,null,{"$f":"D101+D103","v":0}]
["REGLEMENT : Vainqueur < ou = 25% de la dotation globale ",null,null,0.25,{"$f":"SUM(D106)*D107","v":0},{"$f":"SUM(C130)/D131","v":{"$error":"#DIV/0!"}}]
["REGLEMENT  : Finaliste > ou = 60% de l'indemnité du vainqueur",null,null,0.6,{"$f":"SUM(E107)*D108","v":0},{"$f":"SUM(C129)/C130","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[]
[null,null,"Elimination directe Partie perdue"]
[]
[]
[]
[]
[]
["Partie ","Nb équipe ","Indemnité","Cumul par partie",null,{"$f":"D106","v":0}]
["1ère partie",{"$f":"(' ED PARTIE PERDUE'!B23)","v":0},{"$f":"SUM(' ED PARTIE PERDUE'!C23)","v":0},{"$f":"SUM(' ED PARTIE PERDUE'!D23)","v":0},null,{"$f":"F119-D120","v":0}]
["2ème partie",{"$f":"(' ED PARTIE PERDUE'!B24)","v":0},{"$f":"SUM(' ED PARTIE PERDUE'!C24)","v":0},{"$f":"SUM(' ED PARTIE PERDUE'!D24)","v":0},null,0]
["cadrage ",{"$f":"(' ED PARTIE PERDUE'!B25)","v":0},{"$f":"SUM(' ED PARTIE PERDUE'!C25)","v":0},{"$f":"SUM(' ED PARTIE PERDUE'!D25)","v":0},null,0]
["64ème",{"$f":"(' ED PARTIE PERDUE'!B26)","v":0},{"$f":"SUM(' ED PARTIE PERDUE'!C26)","v":0},{"$f":"SUM(' ED PARTIE PERDUE'!D26)","v":0},null,0]
["32ème",{"$f":"(' ED PARTIE PERDUE'!B27)","v":0},{"$f":"SUM(' ED PARTIE PERDUE'!C27)","v":0},{"$f":"SUM(' ED PARTIE PERDUE'!D27)","v":0},null,0]
["16ème",{"$f":"(' ED PARTIE PERDUE'!B28)","v":0},{"$f":"SUM(' ED PARTIE PERDUE'!C28)","v":0},{"$f":"SUM(' ED PARTIE PERDUE'!D28)","v":0},null,0]
["8ème ",{"$f":"(' ED PARTIE PERDUE'!B29)","v":8},{"$f":"SUM(' ED PARTIE PERDUE'!C29)","v":0},{"$f":"SUM(' ED PARTIE PERDUE'!D29)","v":0},null,0]
["1/4 ",{"$f":"(' ED PARTIE PERDUE'!B30)","v":4},{"$f":"SUM(' ED PARTIE PERDUE'!C30)","v":0},{"$f":"SUM(' ED PARTIE PERDUE'!D30)","v":0},null,0]
["1/2",{"$f":"(' ED PARTIE PERDUE'!B31)","v":2},{"$f":"SUM(' ED PARTIE PERDUE'!C31)","v":0},{"$f":"SUM(' ED PARTIE PERDUE'!D31)","v":0}]
["Finaliste",{"$f":"(' ED PARTIE PERDUE'!B32)","v":1},{"$f":"SUM(' ED PARTIE PERDUE'!C32)","v":0},{"$f":"SUM(' ED PARTIE PERDUE'!D32)","v":0}]
["Vainqueur",{"$f":"(' ED PARTIE PERDUE'!B33)","v":1},{"$f":"SUM(' ED PARTIE PERDUE'!C33)","v":0},{"$f":"SUM(' ED PARTIE PERDUE'!D33)","v":0}]
[4,null,{"$f":"IF(B20<>\"\",12,IF(B21<>\"\",8,IF(B22<>\"\",4,0)))","v":12},{"$f":"SUM(' ED PARTIE PERDUE'!D34)","v":0}]
[{"$f":"C12","v":0},null,null,null,"N°",{"$f":"SUM(' ED PARTIE PERDUE'!C3:E6)","v":0}]
[null,"VAINQUEUR",{"$f":"IF(B20=\"X\",\"TRIPLETTES : 3 chèques de : \",IF(B21=\"X\",\"DOUBLETTES : 2 chèques de : \",IF(B22=\"X\",\"TETE A TETE : 1 chèque de : \",\"\")))","v":"TRIPLETTES : 3 chèques de : "},null,{"$f":"SUM(' ED PARTIE PERDUE'!D37)","v":0}]
[null,"FINALISTE",{"$f":"IF(B20=\"X\",\"TRIPLETTES : 3 chèques de : \",IF(B21=\"X\",\"DOUBLETTES : 2 chèques de : \",IF(B22=\"X\",\"TETE A TETE : 1 chèque de : \",\"\")))","v":"TRIPLETTES : 3 chèques de : "},null,{"$f":"SUM(' ED PARTIE PERDUE'!D38)","v":0}]
[]
["ETAT DE VERSEMENT DES INDEMNITES"]
[]
["N°","Nom, Prénom","Association ou Club","N°","Montant du Chèque ","N° du chèque "]
["Licence",null,null,"Dép."]
[{"$f":"IF(' ED PARTIE PERDUE'!F12=3,A97,A97)","v":0},{"$f":"IF(' ED PARTIE PERDUE'!F12=3,B97,B97)","v":0},{"$f":"IF(' ED PARTIE PERDUE'!F12=3,C97,C97)","v":0},{"$f":"IF(' ED PARTIE PERDUE'!F12=3,D97,D97)","v":0},{"$f":"IF(' ED PARTIE PERDUE'!F12=3,E133,E133)","v":0}]
[{"$f":"IF(' ED PARTIE PERDUE'!F12=3,A98,A98)","v":0},{"$f":"IF(' ED PARTIE PERDUE'!F12<>1,B98,\"\")","v":0},{"$f":"IF(' ED PARTIE PERDUE'!F12<>1,C98,\"\")","v":0},{"$f":"IF(' ED PARTIE PERDUE'!F12<>1,D98,\"\")","v":0},{"$f":"IF(' ED PARTIE PERDUE'!F12<>1,E133,\"\")","v":0}]
[{"$f":"IF(' ED PARTIE PERDUE'!F12=3,A99,A99)","v":0},{"$f":"IF(' ED PARTIE PERDUE'!F12=3,B99,\"\")","v":0},{"$f":"IF(' ED PARTIE PERDUE'!F12=3,C99,\"\")","v":0},{"$f":"IF(' ED PARTIE PERDUE'!F12=3,D99,\"\")","v":0},{"$f":"IF(' ED PARTIE PERDUE'!F12=3,E133,\"\")","v":0}]
[{"$f":"IF(' ED PARTIE PERDUE'!F12=3,A93,A93)","v":0},{"$f":"IF(' ED PARTIE PERDUE'!F12=3,B93,B93)","v":0},{"$f":"IF(' ED PARTIE PERDUE'!F12=3,C93,C93)","v":0},{"$f":"IF(' ED PARTIE PERDUE'!F12=3,D93,D93)","v":0},{"$f":"IF(' ED PARTIE PERDUE'!F12=3,E134,E134)","v":0}]
[{"$f":"IF(' ED PARTIE PERDUE'!F12=3,A94,A94)","v":0},{"$f":"IF(' ED PARTIE PERDUE'!F12<>1,B94,\"\")","v":0},{"$f":"IF(' ED PARTIE PERDUE'!F12<>1,C94,\"\")","v":0},{"$f":"IF(' ED PARTIE PERDUE'!F12<>1,D94,\"\")","v":0},{"$f":"IF(' ED PARTIE PERDUE'!F12<>1,E134,\"\")","v":0}]
[{"$f":"IF(' ED PARTIE PERDUE'!F12=3,A95,A95)","v":0},{"$f":"IF(' ED PARTIE PERDUE'!F12=3,B95,\"\")","v":0},{"$f":"IF(' ED PARTIE PERDUE'!F12=3,C95,\"\")","v":0},{"$f":"IF(' ED PARTIE PERDUE'!F12=3,D95,\"\")","v":0},{"$f":"IF(' ED PARTIE PERDUE'!F12=3,E134,\"\")","v":0}]
[]
["SIGNATURE"]
[null,{"$f":"IF(' ED PARTIE PERDUE'!F12=3,B97,B97)","v":0},{"$f":"B148","v":0},"BANQUE "]
[null,{"$f":"IF(' ED PARTIE PERDUE'!F12<>1,B98,\"\")","v":0},{"$f":"B149","v":0}]
[null,{"$f":"IF(' ED PARTIE PERDUE'!F12=3,B99,\"\")","v":0},{"$f":"IF(C131=12,B150,\"\")","v":0}]
[null,{"$f":"IF(' ED PARTIE PERDUE'!F12=3,B93,B93)","v":0},0]
[null,{"$f":"IF(' ED PARTIE PERDUE'!F12<>1,B94,\"\")","v":0},0]
[null,{"$f":"IF(' ED PARTIE PERDUE'!F12=3,B95,\"\")","v":0},0]
[]
["TOTAL DES INDEMNITES ",null,{"$f":"SUM(E140:E145)","v":0}]
[]
["FAIT A :",{"$f":"E12","v":""},null,"LE :"]
[]
["Signature de l'Organisateur ",null,{"$f":"C17","v":""}]
[]
["Signature du Délégué",null,{"$f":"C42","v":""}]
[]
["1/ Un exemplaire de ce compte-rendu DUMENT REMPLI est à transmettre PAR LE DELEGUE dans les 48 heures au siège social de la F.F.P.J.P.    PAR MAIL   ffpjp.siege@petanque.fr      "]
[]
["2 / une copie au Président du Comité Régional"]
["3 / une copie au Responsable du C.R. concerné par les Nationaux."]
["4 / une copie au Président du Comité concerné. "]
["5 / une copie au Président de l'organisation. "]
[]
[]
["CLASSIFICATION DE LA MANIFESTATION"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Liste des équipes en 8ème"]
["N°","Nom, Prénom","Association ou Club","N°","N° des équipes ","Point (3)"]
["Licence","en lettres majuscules",null,"Dép."]

{"sheet":"ED CUMUL","index":4,"n_rows":38,"n_cols":11,"rows_kept":38,"cut":false,"hidden":false,"merged":[[9,0,9,9],[11,0,11,4],[12,0,12,6],[13,0,13,6],[14,0,14,5],[5,5,5,7],[6,0,6,1],[6,2,6,4],[6,5,6,7],[7,0,7,1],[7,2,7,4],[7,5,7,7],[3,0,3,1],[3,2,3,4],[4,0,4,1],[4,2,4,4],[5,0,5,1],[5,2,5,4],[2,0,2,1],[2,2,2,4],[2,5,2,7],[0,0,0,10],[1,0,1,1],[1,2,1,4],[1,5,1,7],[1,9,1,10],[30,6,30,7],[15,0,15,5],[16,0,16,12],[18,0,18,9],[20,1,20,3],[20,6,20,9],[37,5,37,12],[36,1,36,2],[37,1,37,2],[33,6,33,7],[33,0,33,2],[34,9,34,10],[35,9,35,10],[36,6,36,9]]}
["CALCUL AUTOMATIQUE DES INDEMNITES AUX JOUEURS - JEU PROVENÇAL EN ELIMINATION DIRECTE  AU CUMUL"]
["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":"SUM(I2)","v":0}]
[" N°  SUPRANATIONAL :"]
[" N° EVENENEMENTIEL :"]
["N° NATIONAL :",null,null,null,null,"Nombre d'équipes engagées :",null,null,null,{"$f":"F12*G12","v":0},{"$f":"SUM(I6*J6)","v":0}]
["LIEU :",null,null,null,null,"Nombre d'équipes à la première partie",null,null,{"$f":"ROUNDUP($I$6/2,0)","v":0},"Total",{"$f":"SUM(K3:K6)","v":0}]
["RESPONSABLE :"]
[]
[" I  Calcul du maximum au vainqueurs et du minium 1/2 finale (Exemple) "]
[null,null,null,null,null,"Doub. Trip.","Part/joueur"]
["Formation",null,null,null,null,3,{"$f":"IF(ISNUMBER(C6),6,0)+IF(ISNUMBER(C3),8,0)+IF(ISNUMBER(C4),8,0)+IF(ISNUMBER(C5),8,0)","v":0},{"$f":"SUM(F12*G12*I6)","v":0}]
["Dotation ",null,null,null,null,null,null,{"$f":"SUM(I2)","v":0}]
["Total indemnités",null,null,null,null,null,null,{"$f":"SUM(H12:H13)","v":0}]
["REGLEMENT : Vainqueur < ou = 25% de la dotation globale ",null,null,null,null,null,0.25,{"$f":"SUM(H14*G15)","v":0}]
["REGLEMENT  : Finaliste > ou = 60% de l'indemnité du vainqueur",null,null,null,null,null,0.6,{"$f":"SUM(H15*G16)","v":0}]
[]
[]
["II On informe uniquement les cellules bleutées"]
[]
[null,"Total indemnités",null,null,{"$f":"SUM(K7)","v":0},null,"Parties gagnées  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":"SUM(I7)","v":0},0,{"$f":"SUM(B23*C23)","v":0},{"$f":"SUM(E21)","v":0},{"$f":"SUM(D23)","v":0}]
["2ème partie",{"$f":"ROUNDUP($B$23/2,0)","v":0},0,{"$f":"SUM(B24*C24)","v":0},{"$f":"SUM(E23-D24)","v":0},{"$f":"SUM(F23+C24)","v":0}]
["cadrage ",{"$f":"IF(B24>=128,B24-128,IF(B24>=64,B24-\"64\",IF(B24>=32,B24-\"32\",IF(B24>=16,B24-16,0))))","v":0},0,0,{"$f":"SUM(E24-D25)","v":0},0]
["64ème",{"$f":"IF(B24-B25=128,128/2,0)","v":0},0,0,{"$f":"SUM(E25-D26)","v":0},0]
["32ème",{"$f":"IF(B24-B25=64,32,IF(B26=64,B26/2,0))","v":0},0,0,0,0]
["16ème",{"$f":"IF(B24-B25=32,16,IF(B27=32,B27/2,0))","v":0},0,0,0,0]
["8ème ",8,0,0,0,0]
["1/4 ",4,0,0,0,0]
["1/2",2,0,0,0,0]
["Vainqueur",1,{"$f":"SUM(E31)","v":0},{"$f":"SUM(B32*C32)","v":0},{"$f":"SUM(E31-D32)","v":0},0]
[null,null,null,{"$f":"SUM(D22:D32)","v":0}]
[null,null,null,null,null,null,"Indemnité réelle du vainqueur ",null,{"$f":"SUM(F32)","v":0},"< = 25% DU TOTAL",{"$f":"SUM(H15)","v":0}]
[null,null,null,null,null,{"$f":"IF(F32<0.25*D33,0,1)","v":1},"Vainqueur",{"$f":"SUM(F32)","v":0},{"$f":"SUM(F32/K7)","v":{"$error":"#DIV/0!"}},{"$f":"IF(F35=0,\"Répartition correcte\",\"Répartition incorrecte\")","v":"Répartition incorrecte"}]
[null,null,null,null,null,{"$f":"IF(H36>=0.6*H35,0,1)","v":0},"Finaliste",{"$f":"SUM(F31)","v":0},{"$f":"SUM(H36/H35)","v":{"$error":"#DIV/0!"}},{"$f":"IF(F36=0,\"Répartition correcte\",\"Répartition incorrecte\")","v":"Répartition correcte"}]
["VAINQUEUR",{"$f":"IF(F12=3,\"TRIPLETTES : 3 chèques de : \",IF(F12=2,\"DOUBLETTES : 2 chèques de : \",IF(F12=1,\"TETE A TETE : 1 chèque de : \",\"\")))","v":"TRIPLETTES : 3 chèques de : "},null,{"$f":"SUM(C31:C32)/3","v":0}]
["FINALISTE",{"$f":"IF(F12=3,\"TRIPLETTES : 3 chèques de : \",IF(F12=2,\"DOUBLETTES : 2 chèques de : \",IF(F12=1,\"TETE A TETE : 1 chèque de : \",\"\")))","v":"TRIPLETTES : 3 chèques de : "},null,{"$f":"SUM(C31)/3","v":0}]

{"sheet":"AFFICHAGE CUMUL","index":5,"n_rows":30,"n_cols":5,"rows_kept":30,"cut":false,"hidden":false,"merged":[[11,1,11,2],[12,0,12,4],[13,0,13,4],[0,0,0,4],[1,1,1,2],[2,1,2,2],[5,1,5,2],[6,1,6,2],[10,1,10,2],[3,1,3,2],[4,1,4,2],[8,3,8,4],[9,3,9,4]]}
["INDEMNITES - JEU PROVENÇAL - ELIMINATION DIRECTE AU CUMUL"]
["DELEGUE",{"$f":"IF('ED CUMUL'!C2=0,\"\",'ED CUMUL'!C2)","v":""}]
["  N° INTERNATIONAL :",{"$f":"IF('ED CUMUL'!C3=0,\"\",'ED CUMUL'!C3)","v":""}]
[" N°  SUPRANATIONAL :",{"$f":"IF('ED CUMUL'!C4=0,\"\",'ED CUMUL'!C4)","v":""}]
[" N° EVENENEMENTIEL :",{"$f":"IF('ED CUMUL'!C5=0,\"\",'ED CUMUL'!C5)","v":""}]
["N° NATIONAL :",{"$f":"IF('ED CUMUL'!C6=0,\"\",'ED CUMUL'!C6)","v":""}]
["LIEU :",{"$f":"IF('ED CUMUL'!C7=0,\"\",'ED CUMUL'!C7)","v":""}]
[]
["Inscrits ","Inscription","Total","REGLEMENT : Vainqueur < ou = 25% de la dotation globale "]
[{"$f":"SUM('ED CUMUL'!I6)","v":0},{"$f":"SUM('ED CUMUL'!J6)","v":0},{"$f":"SUM('ED CUMUL'!K6)","v":0},"REGLEMENT  : Finaliste > ou = 60% de l'indemnité du vainqueur"]
["DOTATION ",{"$f":"SUM('ED CUMUL'!I2)","v":0},null,"Vainqueur",{"$f":"SUM(E25/D26)","v":{"$error":"#DIV/0!"}}]
["TOTAL INDEMNITES ",{"$f":"SUM('ED CUMUL'!K7)","v":0},null,"Finaliste",{"$f":"SUM(E24/E25)","v":{"$error":"#DIV/0!"}}]
[]
["REPARTITION DES INDEMNITES "]
["PARTIES ","Equipes indemnisées","Indemnités par équipe","Total ","Indemnités cumulées "]
["1ère partie ",{"$f":"SUM('ED CUMUL'!B23)","v":0},{"$f":"SUM('ED CUMUL'!C23)","v":0},{"$f":"SUM('ED CUMUL'!D23)","v":0},{"$f":"SUM('ED CUMUL'!F23)","v":0}]
["2ème partie",{"$f":"SUM('ED CUMUL'!B24)","v":0},{"$f":"SUM('ED CUMUL'!C24)","v":0},{"$f":"SUM('ED CUMUL'!D24)","v":0},{"$f":"SUM('ED CUMUL'!F24)","v":0}]
["cadrage ",{"$f":"SUM('ED CUMUL'!B25)","v":0},{"$f":"SUM('ED CUMUL'!C25)","v":0},{"$f":"SUM('ED CUMUL'!D25)","v":0},{"$f":"SUM('ED CUMUL'!F25)","v":0}]
["64ème",{"$f":"SUM('ED CUMUL'!B26)","v":0},{"$f":"SUM('ED CUMUL'!C26)","v":0},{"$f":"SUM('ED CUMUL'!D26)","v":0},{"$f":"SUM('ED CUMUL'!F26)","v":0}]
["32ème",{"$f":"SUM('ED CUMUL'!B27)","v":0},{"$f":"SUM('ED CUMUL'!C27)","v":0},{"$f":"SUM('ED CUMUL'!D27)","v":0},{"$f":"SUM('ED CUMUL'!F27)","v":0}]
["16ème",{"$f":"SUM('ED CUMUL'!B28)","v":0},{"$f":"SUM('ED CUMUL'!C28)","v":0},{"$f":"SUM('ED CUMUL'!D28)","v":0},{"$f":"SUM('ED CUMUL'!F28)","v":0}]
["8ème ",{"$f":"SUM('ED CUMUL'!B29)","v":8},{"$f":"SUM('ED CUMUL'!C29)","v":0},{"$f":"SUM('ED CUMUL'!D29)","v":0},{"$f":"SUM('ED CUMUL'!F29)","v":0}]
["1/4 de finale",{"$f":"SUM('ED CUMUL'!B30)","v":4},{"$f":"SUM('ED CUMUL'!C30)","v":0},{"$f":"SUM('ED CUMUL'!D30)","v":0},{"$f":"SUM('ED CUMUL'!F30)","v":0}]
["1/2 finale",{"$f":"SUM('ED CUMUL'!B31)","v":2},{"$f":"SUM('ED CUMUL'!C31)","v":0},{"$f":"SUM('ED CUMUL'!D31)","v":0},{"$f":"SUM('ED CUMUL'!F31)","v":0}]
["finale",{"$f":"SUM('ED CUMUL'!B32)","v":1},{"$f":"SUM('ED CUMUL'!C32)","v":0},{"$f":"SUM('ED CUMUL'!D32)","v":0},{"$f":"SUM('ED CUMUL'!F32)","v":0}]
[null,null,null,{"$f":"SUM(D15:D25)","v":0}]
[]
[null,"VAINQUEUR","Chèque par joueur",{"$f":"SUM('ED CUMUL'!D37)","v":0},8]
[null,"FINALISTE","Chèque par joueur",{"$f":"SUM('ED CUMUL'!D38)","v":0}]
[null,null,null,{"$f":"'[1]Poule cumul (PC)'!I34","v":"Dernière mise à jour V04102018"}]

{"sheet":"CR ED CUMUL","index":6,"n_rows":189,"n_cols":6,"rows_kept":189,"cut":false,"hidden":false,"merged":[[1,1,1,5],[2,1,2,5],[12,4,12,5],[56,4,58,4],[65,4,67,4],[53,4,55,4],[40,0,40,1],[0,1,0,5],[44,4,45,4],[25,2,25,4],[4,0,4,5],[43,0,43,5],[10,0,10,2],[38,0,38,5],[0,0,2,0],[13,3,13,5],[25,0,25,1],[30,0,30,2],[39,0,39,5],[11,0,11,1],[34,0,34,5],[14,3,14,5],[36,0,36,1],[44,2,45,2],[24,0,24,1],[36,2,36,3],[29,0,29,5],[50,4,52,4],[17,0,17,1],[18,0,18,3],[31,0,31,5],[17,4,17,5],[33,0,33,5],[32,0,32,5],[12,0,12,3],[35,0,35,1],[41,2,41,3],[5,0,5,5],[239,0,239,5],[229,4,231,4],[232,4,234,4],[235,4,237,4],[226,4,228,4],[208,4,210,4],[217,4,219,4],[16,3,16,5],[114,2,114,3],[220,4,222,4],[205,4,207,4],[186,0,186,5],[202,4,204,4],[193,4,195,4],[196,4,198,4],[199,4,201,4],[166,0,166,5],[108,4,108,5],[62,4,64,4],[102,0,102,1],[101,0,101,1],[85,4,87,4],[26,2,27,4],[214,4,216,4],[223,4,225,4],[147,3,147,5],[154,0,154,1],[187,5,188,5],[187,2,188,2],[157,0,157,1],[161,0,161,5],[189,0,189,5],[187,4,188,4],[190,4,192,4],[164,3,164,5],[184,0,184,5],[174,0,174,1],[173,0,173,1],[172,0,172,1],[171,0,171,1],[170,0,170,1],[176,0,176,1],[175,0,175,1],[167,0,167,1],[156,0,156,1],[169,0,169,1],[211,4,213,4],[143,3,143,5],[144,3,145,5],[127,0,127,1],[130,4,130,5],[131,4,131,5],[130,2,130,3],[131,2,131,3],[95,0,95,5],[100,0,100,1],[103,0,103,1],[105,3,105,5],[105,0,105,2],[100,3,100,5],[102,3,102,5],[99,0,99,5],[96,4,98,4],[134,2,135,2],[109,1,113,2],[6,0,9,0],[106,0,106,2],[107,0,107,2],[129,0,129,3],[134,4,135,4],[134,5,135,5],[132,0,132,5],[142,0,142,5],[35,2,35,3],[46,0,46,5],[88,4,90,4],[68,4,70,4],[71,0,71,5],[92,4,94,4],[91,0,91,5],[40,2,40,3],[11,4,11,5],[15,3,15,5],[17,2,17,3],[41,0,41,1],[44,5,45,5],[84,0,84,5],[47,4,49,4],[59,4,61,4],[183,0,183,5],[181,0,181,1],[180,0,180,1],[179,0,179,1],[178,0,178,1],[177,0,177,1],[146,3,146,5],[152,1,152,2],[152,4,152,5],[148,3,148,5],[154,4,154,5],[150,0,150,1],[160,0,160,5],[168,0,168,5],[167,2,167,5],[163,0,163,5],[158,0,159,5],[162,0,162,5],[149,3,149,5]]}
[null,"FEDERATION FRANÇAISE DE PETANQUE  ET DE JEU PROVENÇAL"]
[null,"Agréée par le Ministère des Sports"]
[null,"Siège social : 13, rue Trigance – 13002  MARSEILLE"]
[]
["RAPPORT DE DELEGATION & D’ARBITRAGE"]
["Concours nationaux  IND. TRIP. DOUB. en élimination directe au  cumul "]
["N° IDENTIFICATION","SUPRA NATIONAL",{"$f":"IF('ED CUMUL'!C3=0,\"\",'ED CUMUL'!C3)","v":""}]
[null,"INTERNATIONAL",{"$f":"IF('ED CUMUL'!C4=0,\"\",'ED CUMUL'!C4)","v":""}]
[null,"EVENEMENTIEL ",{"$f":"IF('ED CUMUL'!C5=0,\"\",'ED CUMUL'!B5)","v":""}]
[null,"NATIONAL",{"$f":"IF('ED CUMUL'!C6=0,\"\",'ED CUMUL'!C6)","v":""}]
[]
["INTITULE DU CONCOURS : ",null,null,"LIEU :",{"$f":"IF('ED CUMUL'!C7=0,\"\",'ED CUMUL'!C7)","v":""}]
["Date"]
[null,"C. D. et C.R.","Nom et Prénom","QUALITE"]
["Délégué :",null,{"$f":"IF('ED CUMUL'!C2=0,\"\",'ED CUMUL'!C2)","v":""}]
["Arbitre :"]
["Organisateur : ",null,{"$f":"IF('ED CUMUL'!C8=0,\"\",'ED CUMUL'!C8)","v":""}]
["ADRESSE E-mail et Tél. du Délégué :"]
["FORMULE RETENUE *"]
["Triplettes",{"$f":"IF('ED CUMUL'!F12=3,\"X\",\"\")","v":"X"},"Sénior"]
["Doublettes",{"$f":"IF('ED CUMUL'!F12=2,\"X\",\"\")","v":""},"Féminines"]
["Individuel",{"$f":"IF('ED CUMUL'!F12=1,\"X\",\"\")","v":""},"Vétérans "]
[null,null,"Mixte"]
[]
[]
["Tirage au sort effectué le :",null,"En présence"]
["Date "]
["Informatique"]
[]
["OBSERVATIONS DE L'ARBITRE PRINCIPAL"]
["Nombres d’arbitres ayant officié à ses côtés :"]
["Qualité de l’arbitrage dispensé :"]
[]
["Avis sur la qualité de l’organisation "]
[]
["L'Arbitre FFPJP désigné :",null,{"$f":"IF(C16=0,\"\",C16)","v":""}]
["(nom, prénom, signature",null,{"$f":"C36","v":""}]
[]
["OBSERVATIONS GENERALE DU DELEGUE"]
[]
["Le délégué F.F.P.J.P. ou C.R.",null,{"$f":"IF(C15=0,\"\",C15)","v":""}]
["(signature)",null,{"$f":"C41","v":""}]
[]
["RESULTAT DU CONCOURS (à remplir par le délégué)"]
["N°","Nom, Prénom","Association ou Club","N°","N° D'équipe"]
["Licence","en lettres majuscules",null,"Dép."]
["Perdants 1/8 Finale"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Perdants ¼ Finale"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Perdants ½ Finale"]
[]
[]
[]
[]
[]
[]
["Finalistes"]
[]
[]
[]
["Vainqueurs"]
[]
[]
[]
["INDEMNITES  : (article 8 du règlement des concours Internationaux et Nationaux)"]
["Dotation de l'organisation",null,{"$f":"SUM('ED CUMUL'!I2)","v":0},{"$f":"C101","v":0}]
["Frais de participation",null,{"$f":"SUM('ED CUMUL'!J6)","v":0}]
["Nombre d'équipes inscrites",null,{"$f":"SUM('ED CUMUL'!I6)","v":0},{"$f":"C102*C103","v":0}]
["Nombre d'équipes présentes"]
[]
["TOTAL DES INDEMNITES DISTRIBUEES",null,null,{"$f":"D101+D103","v":0}]
["REGLEMENT : Vainqueur < ou = 25% de la dotation globale ",null,null,{"$f":"SUM(D106)*0.25","v":0},{"$f":"SUM(E127/D106)","v":{"$error":"#DIV/0!"}}]
["REGLEMENT  : Finaliste > ou = 60% de l'indemnité du vainqueur",null,null,{"$f":"SUM(D107*0.6)","v":0},{"$f":"SUM(E126/E127)","v":{"$error":"#DIV/0!"}}]
[]
[null,"Elimination directe    au cumul"]
[]
[]
[]
[]
[]
[]
["Partie ","Nb équipe ","Indemnité","Reste à répartir","Cumulé",{"$f":"D106","v":0}]
["1ere partie ",{"$f":"SUM('ED CUMUL'!B23)","v":0},{"$f":"SUM('ED CUMUL'!C23)","v":0},{"$f":"SUM('ED CUMUL'!D19:D28)","v":0},{"$f":"C118","v":0},{"$f":"F117-D118","v":0}]
["2ème partie",{"$f":"SUM('ED CUMUL'!B24)","v":0},{"$f":"SUM('ED CUMUL'!C24)","v":0},{"$f":"SUM('ED CUMUL'!E20)","v":0},{"$f":"E118+C119","v":0},0]
["Cadrage",{"$f":"SUM('ED CUMUL'!B25)","v":0},{"$f":"SUM('ED CUMUL'!C25)","v":0},{"$f":"SUM('ED CUMUL'!E21)","v":0},0,0]
["1/64ème ",{"$f":"SUM('ED CUMUL'!B26)","v":0},{"$f":"SUM('ED CUMUL'!C26)","v":0},{"$f":"SUM('ED CUMUL'!E22)","v":0},0,0]
["1/32ème de finale",{"$f":"SUM('ED CUMUL'!B27)","v":0},{"$f":"SUM('ED CUMUL'!C27)","v":0},{"$f":"SUM('ED CUMUL'!E23)","v":0},0,0]
["1/16ème de finale",{"$f":"SUM('ED CUMUL'!B28)","v":0},{"$f":"SUM('ED CUMUL'!C28)","v":0},{"$f":"SUM('ED CUMUL'!E24)","v":0},0,0]
["1/8ème de finale",{"$f":"SUM('ED CUMUL'!B29)","v":8},{"$f":"SUM('ED CUMUL'!C29)","v":0},{"$f":"SUM('ED CUMUL'!E25)","v":0},0,0]
["1/4  finale",{"$f":"SUM('ED CUMUL'!B30)","v":4},{"$f":"SUM('ED CUMUL'!C30)","v":0},{"$f":"SUM('ED CUMUL'!E26)","v":0},0,0]
["1/2 finale",{"$f":"SUM('ED CUMUL'!B31)","v":2},{"$f":"SUM('ED CUMUL'!C31)","v":0},{"$f":"SUM('ED CUMUL'!E27)","v":0},{"$f":"E125+C126","v":0}]
["Vainqueur",{"$f":"SUM('ED CUMUL'!B32)","v":1},{"$f":"SUM('ED CUMUL'!C32)","v":0},{"$f":"F126","v":0},0]
["SI DOUBLETTE Montant des 8 chèques",null,{"$f":"C126/B129","v":{"$error":"#DIV/0!"}}]
[4,null,{"$f":"IF(B20<>\"\",12,IF(B21<>\"\",8,IF(B22<>\"\",4,0)))","v":12}]
[{"$f":"C12","v":0},null,null,null,"N°",{"$f":"SUM('ED CUMUL'!C3:E6)","v":0}]
[null,"VAINQUEUR",{"$f":"IF(B20=\"X\",\"TRIPLETTES : 3 chèques de : \",IF(B21=\"X\",\"DOUBLETTES : 2 chèques de : \",IF(B22=\"X\",\"TETE A TETE : 1 chèque de : \",\"\")))","v":"TRIPLETTES : 3 chèques de : "},null,{"$f":"SUM('ED CUMUL'!D37)","v":0}]
[null,"FINALISTE",{"$f":"IF(B20=\"X\",\"TRIPLETTES : 3 chèques de : \",IF(B21=\"X\",\"DOUBLETTES : 2 chèques de : \",IF(B22=\"X\",\"TETE A TETE : 1 chèque de : \",\"\")))","v":"TRIPLETTES : 3 chèques de : "},null,{"$f":"SUM('ED CUMUL'!D38)","v":0}]
["ETAT DE VERSEMENT DES INDEMNITES"]
[]
["N°","Nom, Prénom","Association ou Club","N°","Montant du Chèque ","N° du chèque "]
["Licence",null,null,"Dép."]
[{"$f":"IF('ED CUMUL'!F12=3,A97,A97)","v":0},{"$f":"IF('ED CUMUL'!F12=3,B97,B97)","v":0},{"$f":"IF('ED CUMUL'!F12=3,C97,C97)","v":0},{"$f":"IF('ED CUMUL'!F12=3,D97,D97)","v":0},{"$f":"IF('ED CUMUL'!F12=3,E131,E131)","v":0}]
[{"$f":"IF('ED CUMUL'!F12<>1,A98,\"\")","v":0},{"$f":"IF('ED CUMUL'!F12<>1,B98,\"\")","v":0},{"$f":"IF('ED CUMUL'!F12<>1,C98,\"\")","v":0},{"$f":"IF('ED CUMUL'!F12<>1,D98,\"\")","v":0},{"$f":"IF('ED CUMUL'!F12<>1,E131,\"\")","v":0}]
[{"$f":"IF('ED CUMUL'!F12=3,A99,\"\")","v":0},{"$f":"IF('ED CUMUL'!F12=3,B99,\"\")","v":0},{"$f":"IF('ED CUMUL'!F12=3,C99,\"\")","v":0},{"$f":"IF('ED CUMUL'!F12=3,D99,\"\")","v":0},{"$f":"IF('ED CUMUL'!F12=3,E131,\"\")","v":0}]
[{"$f":"IF('ED CUMUL'!F12=3,A93,A93)","v":0},{"$f":"IF('ED CUMUL'!F12=3,B93,B93)","v":0},{"$f":"IF('ED CUMUL'!F12=3,C93,C93)","v":0},{"$f":"IF('ED CUMUL'!F12=3,D93,D93)","v":0},{"$f":"IF('ED CUMUL'!F12=3,E132,E132)","v":0}]
[{"$f":"IF('ED CUMUL'!F12<>1,A94,\"\")","v":0},{"$f":"IF('ED CUMUL'!F12<>1,B94,\"\")","v":0},{"$f":"IF('ED CUMUL'!F12<>1,C94,\"\")","v":0},{"$f":"IF('ED CUMUL'!F12<>1,D94,\"\")","v":0},{"$f":"IF('ED CUMUL'!F12<>1,E132,\"\")","v":0}]
[{"$f":"IF('ED CUMUL'!F12=3,A95,\"\")","v":0},{"$f":"IF('ED CUMUL'!F12=3,B95,\"\")","v":0},{"$f":"IF('ED CUMUL'!F12=3,C95,\"\")","v":0},{"$f":"IF('ED CUMUL'!F12=3,D95,\"\")","v":0},{"$f":"IF('ED CUMUL'!F12=3,E132,\"\")","v":0}]
["SIGNATURE"]
[null,{"$f":"IF('ED CUMUL'!F12=3,B97,B97)","v":0},{"$f":"IF(B144=0,\"\",B144)","v":""},"BANQUE "]
[null,{"$f":"IF('ED CUMUL'!F12=3,B98,B98)","v":0},{"$f":"IF(B145=0,\"\",B145)","v":""}]
[null,{"$f":"IF('ED CUMUL'!F12=3,B99,B99)","v":0},""]
[null,{"$f":"IF('ED CUMUL'!F12=3,B100,B100)","v":0},""]
[null,{"$f":"IF('ED CUMUL'!F12=3,B101,B101)","v":0},""]
[null,{"$f":"IF('ED CUMUL'!F12=3,B102,B102)","v":0},""]
[]
["TOTAL DES INDEMNITES ",null,{"$f":"SUM(E137:E142)","v":0}]
[]
["FAIT A :",{"$f":"E12","v":""},null,"LE :"]
[]
["Signature de l'Organisateur ",null,{"$f":"C17","v":""}]
[]
["Signature du Délégué",null,{"$f":"C42","v":""}]
[]
["1/ Un exemplaire de ce compte-rendu DUMENT REMPLI est à transmettre PAR LE DELEGUE dans les 48 heures au siège social de la F.F.P.J.P.    PAR MAIL   ffpjp.siege@petanque.fr      "]
[]
["2 / une copie au Président du Comité Régional"]
["3 / une copie au Responsable du C.R. concerné par les Nationaux."]
["4 / une copie au Président du Comité concerné. "]
["5 / une copie au Président de l'organisation. "]
[]
[]
["CLASSIFICATION DE LA MANIFESTATION"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Liste des équipes en 8ème"]
["N°","Nom, Prénom","Association ou Club","N°","N° des équipes ","Point (3)"]
["Licence","en lettres majuscules",null,"Dép."]