{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["MENU","REPARTITION POULES","AFFICHAGE POULES","CR POULES"," REPARTITION ED","AFFICHAGE ED","CR ED "],"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":"REPARTITION POULES","index":1,"n_rows":34,"n_cols":12,"rows_kept":34,"cut":false,"hidden":false,"merged":[[0,0,0,10],[32,4,32,5],[13,0,13,3],[14,0,14,5],[8,0,8,8],[11,0,11,3],[12,0,12,3],[9,0,9,9],[6,5,6,7],[7,0,7,1],[7,2,7,4],[7,5,7,7],[1,9,1,10],[2,0,2,1],[1,0,1,1],[1,2,1,4],[1,5,1,7],[4,0,4,1],[5,0,5,1],[2,2,2,4],[2,5,2,7],[3,0,3,1],[3,2,3,4],[3,5,3,7],[4,2,4,4],[5,2,5,4],[34,8,34,11],[33,1,33,3],[33,4,33,5],[34,1,34,3],[34,4,34,5],[18,1,18,3],[31,6,31,7],[31,9,31,10],[32,1,32,3],[32,7,32,10],[6,0,6,1],[6,2,6,4],[14,8,14,10],[15,0,15,5],[16,0,16,9]]}
["CALCUL AUTOMATIQUE DES INDEMNITES AUX JOUEURS (INDIVIDUEL, DOUBLETTES & TRIPLETTES) EN POULES AU CUMUL "]
["DELEGUE :",null,null,null,null,"Dotation de l'organisateurs :",null,null,7000,"Indemnités "]
[" N° SUPRA NATIONAL :",null,12,null,null,null,null,null,null,null,{"$f":"I2","v":7000}]
["N° INTERNATIONAL :",null,null,null,null,"Nombre d'équipes engagées :",null,null,600,{"$f":"F12*G12","v":24},{"$f":"I4*J4","v":14400},4]
["N° NATIONAL :"]
["N° EVENEMENTIEL :"]
["LIEU :",null,null,null,null,"Nombre de poules :",null,null,{"$f":"ROUNDUP($I$4/4,0)","v":150},"Total",{"$f":"SUM(K3:K4)","v":21400}]
["RESPONSABLE /  ",null,null,null,null,"Nombre équipes sortie de Poule :",null,null,{"$f":"I7*2","v":300}]
["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":600},3,{"$f":"IF(ISNUMBER(C5),6,0)+IF(ISNUMBER(C3),8,0)+IF(ISNUMBER(C4),8,0)+IF(ISNUMBER(C6),8,0)","v":8},{"$f":"F12*G12","v":24}]
["Dotation ",null,null,null,null,null,{"$f":"I2","v":7000},{"$f":"G13","v":7000}]
["Total indemnités",null,null,null,null,null,null,{"$f":"K7","v":21400}]
["50% maxi de la dotation globale ",null,null,null,null,null,0.5,{"$f":"H14*G15","v":10700}]
["25% mini de la dotation globale ",null,null,null,null,null,0.25,{"$f":"H14*G16","v":5350}]
["II On informe uniquement les cellules grisées  "]
[]
[null,"Total indemnités",null,null,{"$f":"H14","v":21400}]
[null,"Equipes indemnisées","Indemnités par équipe","Cumul par partie","Reste indemnités à répartir","Cumulé"]
["Sortie poules",{"$f":"SUM(I8)","v":300},0,{"$f":"B21*C21","v":0},{"$f":"E19-D21","v":21400},{"$f":"IF(B21=0,0,C21)","v":0},null,"= engagement"]
["1° partie après les poules",{"$f":"B21/2","v":150},0,0,{"$f":"E21-D22","v":21400},{"$f":"F21+C22","v":0},"nbre equipes à faire le cadrage","= engagement ou C20 + 5€"]
["cadrage ",{"$f":"IF(B22>=128,B22-128,IF(B22>=64,B22-\"64\",IF(B22>=32,B22-\"32\",IF(B22>=16,B22-16,0))))","v":22},0,0,21400,{"$f":"F22+C23","v":0},{"$f":"B*2","v":{"$error":"#NAME?"}},"= C21 + 5€"]
["64ème",{"$f":"IF(B22-B23=128,128/2,0)","v":64},0,0,21400,{"$f":"F23+C24","v":0}]
["32ème",{"$f":"IF(B22-B23=64,32,IF(B24=64,B24/2,0))","v":32},0,0,21400,{"$f":"IF(B25=0,F24,C25+F24)","v":0}]
["16ème",{"$f":"IF(B22-B23=32,\"16\",IF(B25=32,B25/2,\"0\"))","v":16},0,{"$f":"B26*C26","v":0},21400,{"$f":"IF(B26=0,F25,C26+F25)","v":0}]
["8ème ",8,0,{"$f":"B27*C27","v":0},21400,{"$f":"IF(B27=0,F26,C27+F26)","v":0}]
["1/4 de finale",4,0,0,{"$f":"E27-D28","v":21400},{"$f":"F27+C28","v":0}]
["1/2 finale",2,0,{"$f":"B29*C29","v":0},{"$f":"E28-D29","v":21400},{"$f":"F28+C29","v":0}]
["finale",1,{"$f":"SUM(E29)","v":21400},21400,{"$f":"E29-D30","v":0},{"$f":"F29+C30","v":21400}]
[null,null,null,null,null,null,"> ou = à 25%",{"$f":"H16","v":5350},"% Répartition","< ou = 50 %",{"$f":"H15","v":10700}]
[null,null,null,{"$f":"SUM(D21:D31)","v":21400},null,null,{"$f":"IF(I32<0.25,0,IF(I32>0.5,0,1))","v":0},null,{"$f":"J32/H14","v":1},{"$f":"E27","v":21400}]
["VAINQUEUR",{"$f":"IF(F12=3,\"TRIPLETTE : 3 chèques de : \",IF(F12=2,\"DOUBLETTE : 2 chèques de : \",IF(F12=1,\"TETE A TETE : 1 chèque de : \",\"\")))","v":"TRIPLETTE : 3 chèques de : "},null,null,{"$f":"IF(F12=3,(C29+C30)/3,IF(F12=2,(C29+C30)/2,IF(F12=1,(C29+C30)/1,0)))","v":7133.333333333333},null,12,{"$f":"IF(G32=1,\"La répartition est correcte\",IF(I32<0.25,\"Le pourcentage doit être > ou = à 25%\",IF(I32>0.5,\"Le pourcentage ne doit pas dépasser 50%\",\"\")))","v":"Le pourcentage ne doit pas dépasser 50%"}]
["FINALISTE",{"$f":"IF(F12=3,\"TRIPLETTES : 3 chèques de : \",IF(F12=2,\"DOUBLETTES : 1 chèques de : \",IF(F12=1,\"TETE A TETE : 1 chèque de : \",\"\")))","v":"TRIPLETTES : 3 chèques de : "},null,null,{"$f":"IF(F12=3,(C29)/3,IF(F12=2,(C29)/2,IF(F12=1,(C29)/1,0)))","v":0},null,null,null,"Dernière mise à jour V11102018"]

{"sheet":"AFFICHAGE POULES","index":2,"n_rows":29,"n_cols":5,"rows_kept":29,"cut":false,"hidden":false,"merged":[[11,1,11,2],[11,3,11,4],[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],[8,3,10,4],[10,1,10,2],[3,1,3,2],[4,1,4,2]]}
["INDEMNITES DES JOUEURS - POULES AU CUMUL"]
["DELEGUE",{"$f":"IF('REPARTITION POULES'!C2=0,\"\",'REPARTITION POULES'!C2)","v":""}]
["N° SUPRA NATIONAL :",{"$f":"IF('REPARTITION POULES'!C3=0,\"\",'REPARTITION POULES'!C3)","v":12}]
["N° INTERNATIONAL :",{"$f":"IF('REPARTITION POULES'!C4=0,\"\",'REPARTITION POULES'!C4)","v":""}]
["N° NATIONAL :",{"$f":"IF('REPARTITION POULES'!C5=0,\"\",'REPARTITION POULES'!C5)","v":""}]
["N° EVENEMENTIEL :",{"$f":"IF('REPARTITION POULES'!C6=0,\"\",'REPARTITION POULES'!C6)","v":""}]
["LIEU :",{"$f":"IF('REPARTITION POULES'!C7=0,\"\",'REPARTITION POULES'!C7)","v":""}]
[]
["Inscrits ","Inscription","Total"," Attention! Les 1/4 de finale sont réglés en espèces.                                                                        % compris entre 25% et 50%"]
[{"$f":"SUM('REPARTITION POULES'!I4)","v":600},{"$f":"SUM('REPARTITION POULES'!J4)","v":24},{"$f":"SUM('REPARTITION POULES'!K4)","v":14400}]
["DOTATION ",{"$f":"SUM('REPARTITION POULES'!I2)","v":7000}]
["TOTAL INDEMNITES ",{"$f":"SUM('REPARTITION POULES'!K7)","v":21400},null,{"$f":"SUM('REPARTITION POULES'!I32)","v":1}]
[]
["REPARTITION DES INDEMNITES "]
["PARTIES ","Equipes indemnisées","Indemnités par équipe","Total ","Indemnités cumulées "]
["Sortie poules",{"$f":"SUM('REPARTITION POULES'!B21)","v":300},{"$f":"SUM('REPARTITION POULES'!C21)","v":0},{"$f":"SUM('REPARTITION POULES'!D21)","v":0},{"$f":"SUM('REPARTITION POULES'!F21)","v":0}]
["1° partie après les poules",{"$f":"SUM('REPARTITION POULES'!B22)","v":150},{"$f":"SUM('REPARTITION POULES'!C22)","v":0},{"$f":"SUM('REPARTITION POULES'!D22)","v":0},{"$f":"SUM('REPARTITION POULES'!F22)","v":0}]
["cadrage ",{"$f":"SUM('REPARTITION POULES'!B23)","v":22},{"$f":"SUM('REPARTITION POULES'!C23)","v":0},{"$f":"SUM('REPARTITION POULES'!D23)","v":0},{"$f":"SUM('REPARTITION POULES'!F23)","v":0}]
["64ème",{"$f":"SUM('REPARTITION POULES'!B24)","v":64},{"$f":"SUM('REPARTITION POULES'!C24)","v":0},{"$f":"SUM('REPARTITION POULES'!D24)","v":0},{"$f":"SUM('REPARTITION POULES'!F24)","v":0}]
["32ème",{"$f":"SUM('REPARTITION POULES'!B25)","v":32},{"$f":"SUM('REPARTITION POULES'!C25)","v":0},{"$f":"SUM('REPARTITION POULES'!D25)","v":0},{"$f":"SUM('REPARTITION POULES'!F25)","v":0}]
["16ème",{"$f":"SUM('REPARTITION POULES'!B26)","v":16},{"$f":"SUM('REPARTITION POULES'!C26)","v":0},{"$f":"SUM('REPARTITION POULES'!D26)","v":0},{"$f":"SUM('REPARTITION POULES'!F26)","v":0}]
["8ème ",{"$f":"SUM('REPARTITION POULES'!B27)","v":8},{"$f":"SUM('REPARTITION POULES'!C27)","v":0},{"$f":"SUM('REPARTITION POULES'!D27)","v":0},{"$f":"SUM('REPARTITION POULES'!F27)","v":0}]
["1/4 de finale",{"$f":"SUM('REPARTITION POULES'!B28)","v":4},{"$f":"SUM('REPARTITION POULES'!C28)","v":0},{"$f":"SUM('REPARTITION POULES'!D28)","v":0},{"$f":"SUM('REPARTITION POULES'!F28)","v":0}]
["1/2 finale",{"$f":"SUM('REPARTITION POULES'!B29)","v":2},{"$f":"SUM('REPARTITION POULES'!C29)","v":0},{"$f":"SUM('REPARTITION POULES'!D29)","v":0},{"$f":"SUM('REPARTITION POULES'!F29)","v":0}]
["finale",{"$f":"SUM('REPARTITION POULES'!B30)","v":1},{"$f":"SUM('REPARTITION POULES'!C30)","v":21400},{"$f":"SUM('REPARTITION POULES'!D30)","v":21400},{"$f":"SUM('REPARTITION POULES'!F30)","v":21400}]
[null,null,null,{"$f":"SUM(D16:D25)","v":21400}]
[]
[null,"VAINQUEUR","Chèque par joueur",{"$f":"SUM('REPARTITION POULES'!E33:F33)","v":7133.333333333333}]
[null,"FINALISTE","Chèque par joueur",{"$f":"SUM('REPARTITION POULES'!E34:F34)","v":0}]

{"sheet":"CR POULES","index":3,"n_rows":192,"n_cols":6,"rows_kept":192,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,0,1,5],[2,0,2,5],[6,0,6,2],[7,0,7,2],[8,0,8,2],[9,0,9,2],[11,0,11,1],[4,0,4,5],[5,0,5,5],[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,1,12,3],[12,4,12,5],[13,3,13,5],[14,3,14,5],[15,3,15,5],[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],[130,0,130,3],[134,0,134,5],[136,2,137,2],[136,4,137,4],[136,5,137,5],[108,4,108,5],[110,0,110,5],[111,1,111,4],[116,2,116,3],[112,2,115,3],[131,2,131,3],[131,4,131,5],[132,2,132,3],[132,4,132,5],[159,0,159,1],[160,0,160,1],[161,0,162,5],[163,0,163,5],[164,0,164,5],[165,0,165,5],[152,3,152,5],[153,0,153,1],[155,1,155,2],[155,4,155,5],[157,0,157,1],[157,4,157,5],[172,0,172,1],[173,0,173,1],[174,0,174,1],[175,0,175,1],[176,0,176,1],[177,0,177,1],[166,0,166,5],[167,3,167,5],[169,0,169,5],[170,0,170,1],[170,2,170,5],[171,0,171,5],[184,0,184,1],[186,0,186,5],[187,0,187,5],[189,0,189,5],[190,2,191,2],[190,4,191,4],[190,5,191,5],[178,0,178,1],[179,0,179,1],[180,0,180,1],[181,0,181,1],[182,0,182,1],[183,0,183,1],[145,0,145,5],[146,3,146,5],[147,3,148,5],[149,3,149,5],[150,3,150,5],[151,3,151,5],[242,0,242,5],[208,4,210,4],[211,4,213,4],[214,4,216,4],[217,4,219,4],[220,4,222,4],[223,4,225,4],[192,0,192,5],[193,4,195,4],[196,4,198,4],[199,4,201,4],[202,4,204,4],[205,4,207,4],[226,4,228,4],[229,4,231,4],[232,4,234,4],[235,4,237,4],[238,4,240,4]]}
["FEDERATION FRANÇAISE DE PETANQUE  ET DE JEU PROVENÇAL"]
["Agréée par le Ministère des Sports"]
["Siège social : 13, rue Trigance – 13002  MARSEILLE"]
[]
["RAPPORT DE DELEGATION & D’ARBITRAGE"]
["Concours nationaux  IND. TRIP. DOUB. en poules au cumul "]
["SUPRA NATIONAL",null,null,{"$f":"IF('REPARTITION POULES'!C3=0,\"\",'REPARTITION POULES'!C3)","v":12}]
["INTERNATIONAL",null,null,{"$f":"IF('REPARTITION POULES'!C4=0,\"\",'REPARTITION POULES'!C4)","v":""}]
["NATIONAL",null,null,{"$f":"IF('REPARTITION POULES'!C5=0,\"\",'REPARTITION POULES'!C5)","v":""}]
["EVENEMENTIEL ",null,null,{"$f":"IF('REPARTITION POULES'!C6=0,\"\",'REPARTITION POULES'!C6)","v":""}]
[]
["INTITULE DU CONCOURS : ",null,null,"LIEU :"]
["Date","N° d’identification au calendrier national : "]
[null,"C. D. et C.R.","Nom et Prénom","QUALITE"]
["Délégué :",null,{"$f":"IF('REPARTITION POULES'!C2=0,\"\",'REPARTITION POULES'!C2)","v":""}]
["Arbitre :"]
["Organisateur : ",null,{"$f":"IF('REPARTITION POULES'!C8=0,\"\",'REPARTITION POULES'!C8)","v":""}]
["ADRESSE E-mail et Tél. du Délégué :"]
["FORMULE RETENUE *"]
["Triplettes",{"$f":"IF('REPARTITION POULES'!F12=3,\"X\",\"\")","v":"X"},"Sénior"]
["Doublettes",{"$f":"IF('REPARTITION POULES'!F12=2,\"X\",\"\")","v":""},"Féminines"]
["Individuel",{"$f":"IF('REPARTITION POULES'!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":"C16","v":0}]
["(nom, prénom, signature",null,{"$f":"C36","v":0}]
[]
["OBSERVATIONS GENERALE DU DELEGUE"]
[]
["Le délégué F.F.P.J.P. ou C.R.",null,{"$f":"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('REPARTITION POULES'!I2)","v":7000},{"$f":"C101","v":7000}]
["Frais de participation",null,{"$f":"SUM('REPARTITION POULES'!J4)","v":24}]
["Nombre d'équipes inscrites",null,{"$f":"SUM('REPARTITION POULES'!I4)","v":600},{"$f":"C102*C103","v":14400}]
["Nombre d'équipes présentes",null,0]
[]
["TOTAL DES INDEMNITES DISTRIBUEES",null,null,{"$f":"D101+D103","v":21400}]
[0.5,{"$f":"D106*A107","v":10700},"Somme restante après les 8ème",{"$f":"F126","v":21400}]
[0.25,{"$f":"D106*A108","v":5350},"Somme totale attribuée aux 8 équipes",{"$f":"SUM(D120:D126)","v":0}]
[null,null,null,"% Attribuée ",{"$f":"D107/D106","v":1}]
[]
[]
[]
[null,null,"Poules au cumul"]
[]
[]
[]
[]
[]
["Partie ","Nb équipe ","Indemnités","Total","Cumulé",{"$f":"D106","v":21400}]
["Sortie poules",{"$f":"SUM('REPARTITION POULES'!B21)","v":300},{"$f":"SUM('REPARTITION POULES'!C21)","v":0},{"$f":"B120*C120","v":0},{"$f":"SUM('REPARTITION POULES'!F21)","v":0},{"$f":"F119-D120","v":21400}]
["1° partie après    les poules",{"$f":"SUM('REPARTITION POULES'!B22)","v":150},{"$f":"SUM('REPARTITION POULES'!C22)","v":0},{"$f":"B121*C121","v":0},{"$f":"SUM('REPARTITION POULES'!F22)","v":0},21400]
["cadrage ",{"$f":"SUM('REPARTITION POULES'!B23)","v":22},{"$f":"SUM('REPARTITION POULES'!C23)","v":0},0,{"$f":"SUM('REPARTITION POULES'!F23)","v":0},21400]
["64ème",{"$f":"SUM('REPARTITION POULES'!B24)","v":64},{"$f":"SUM('REPARTITION POULES'!C24)","v":0},0,{"$f":"SUM('REPARTITION POULES'!F24)","v":0},21400]
["32ème",{"$f":"SUM('REPARTITION POULES'!B25)","v":32},{"$f":"SUM('REPARTITION POULES'!C25)","v":0},0,{"$f":"SUM('REPARTITION POULES'!F25)","v":0},21400]
["16ème",{"$f":"SUM('REPARTITION POULES'!B26)","v":16},{"$f":"SUM('REPARTITION POULES'!C26)","v":0},0,{"$f":"SUM('REPARTITION POULES'!F26)","v":0},21400]
["8ème ",{"$f":"SUM('REPARTITION POULES'!B27)","v":8},{"$f":"SUM('REPARTITION POULES'!C27)","v":0},0,{"$f":"SUM('REPARTITION POULES'!F27)","v":0},21400]
["1/4 de finale",{"$f":"SUM('REPARTITION POULES'!B28)","v":4},{"$f":"SUM('REPARTITION POULES'!C28)","v":0},0,{"$f":"SUM('REPARTITION POULES'!F28)","v":0},21400]
["1/2 finale",{"$f":"SUM('REPARTITION POULES'!B29)","v":2},{"$f":"SUM('REPARTITION POULES'!C29)","v":0},{"$f":"B128*C128","v":0},{"$f":"SUM('REPARTITION POULES'!F29)","v":0}]
["finale",{"$f":"SUM('REPARTITION POULES'!B30)","v":1},{"$f":"SUM('REPARTITION POULES'!C30)","v":21400},{"$f":"B129*C129","v":21400},{"$f":"SUM('REPARTITION POULES'!F30)","v":21400}]
[4,null,{"$f":"IF(B20<>\"\",12,IF(B21<>\"\",8,IF(B22<>\"\",4,0)))","v":12},{"$f":"SUM(D120:D129)","v":21400}]
[{"$f":"C12","v":0},null,null,null,"N°",{"$f":"E13","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('REPARTITION POULES'!E33:F33)","v":7133.333333333333}]
[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('REPARTITION POULES'!E34:F34)","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('REPARTITION POULES'!F12=3,B97,B97)","v":0},{"$f":"IF('REPARTITION POULES'!F12=3,C97,C97)","v":0},{"$f":"IF('REPARTITION POULES'!F12=3,C97,C97)","v":0},{"$f":"IF('REPARTITION POULES'!F12=3,D97,D97)","v":0},{"$f":"IF('REPARTITION POULES'!F12=3,E132,E132)","v":7133.333333333333}]
[{"$f":"IF('REPARTITION POULES'!F12=3,B98,B98)","v":0},{"$f":"IF('REPARTITION POULES'!F12<>1,C98,\"\")","v":0},{"$f":"IF('REPARTITION POULES'!F12<>1,C98,\"\")","v":0},{"$f":"IF('REPARTITION POULES'!F12<>1,D98,\"\")","v":0},{"$f":"IF('REPARTITION POULES'!F12<>1,E132,\"\")","v":7133.333333333333}]
[{"$f":"IF('REPARTITION POULES'!F12=3,B99,B99)","v":0},{"$f":"IF('REPARTITION POULES'!F12=3,C99,\"\")","v":0},{"$f":"IF('REPARTITION POULES'!F12=3,C99,\"\")","v":0},{"$f":"IF('REPARTITION POULES'!F12=3,D99,\"\")","v":0},{"$f":"IF('REPARTITION POULES'!F12=3,E132,\"\")","v":7133.333333333333}]
[{"$f":"IF('REPARTITION POULES'!F12=3,B93,B93)","v":0},{"$f":"IF('REPARTITION POULES'!F12=3,C93,C93)","v":0},{"$f":"IF('REPARTITION POULES'!F12=3,C93,C93)","v":0},{"$f":"IF('REPARTITION POULES'!F12=3,D93,D93)","v":0},{"$f":"IF('REPARTITION POULES'!F12=3,E133,E133)","v":0}]
[{"$f":"IF('REPARTITION POULES'!F12=3,B94,B94)","v":0},{"$f":"IF('REPARTITION POULES'!F12<>1,C94,\"\")","v":0},{"$f":"IF('REPARTITION POULES'!F12<>1,C94,\"\")","v":0},{"$f":"IF('REPARTITION POULES'!F12<>1,D94,\"\")","v":0},{"$f":"IF('REPARTITION POULES'!F12<>1,E133,\"\")","v":0}]
[{"$f":"IF('REPARTITION POULES'!F12=3,B95,B95)","v":0},{"$f":"IF('REPARTITION POULES'!F12=3,C95,\"\")","v":0},{"$f":"IF('REPARTITION POULES'!F12=3,C95,\"\")","v":0},{"$f":"IF('REPARTITION POULES'!F12=3,D95,\"\")","v":0},{"$f":"IF('REPARTITION POULES'!F12=3,E133,\"\")","v":0}]
[]
["SIGNATURE"]
[null,{"$f":"IF('REPARTITION POULES'!F12=3,C97,C97)","v":0},{"$f":"B147","v":0},"BANQUE "]
[null,{"$f":"IF('REPARTITION POULES'!F12<>1,C98,\"\")","v":0},{"$f":"B148","v":0}]
[null,{"$f":"IF('REPARTITION POULES'!F12=3,C99,\"\")","v":0},{"$f":"IF(C130=12,B149,\"\")","v":0}]
[null,{"$f":"IF('REPARTITION POULES'!F12=3,C93,C93)","v":0},0]
[null,{"$f":"IF('REPARTITION POULES'!F12<>1,C94,\"\")","v":0},0]
[null,{"$f":"IF('REPARTITION POULES'!F12=3,C95,\"\")","v":0},0]
[]
["TOTAL DES INDEMNITES ",null,{"$f":"SUM(E139:E144)","v":21400}]
[]
["FAIT A :",{"$f":"E12","v":0},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":" REPARTITION ED","index":4,"n_rows":34,"n_cols":11,"rows_kept":34,"cut":false,"hidden":false,"merged":[[4,0,4,1],[4,2,4,4],[5,0,5,1],[5,2,5,4],[33,1,33,3],[33,4,33,5],[13,0,13,6],[14,0,14,5],[15,0,15,5],[16,0,16,9],[18,1,18,3],[31,6,31,7],[31,9,31,10],[32,1,32,3],[32,4,32,5],[32,7,32,10],[17,6,17,7],[7,0,7,1],[7,2,7,4],[7,5,7,7],[9,0,9,9],[11,0,11,3],[2,0,2,1],[2,2,2,4],[2,5,2,7],[18,6,18,7],[0,0,0,10],[1,0,1,1],[1,2,1,4],[1,5,1,7],[1,9,1,10],[12,0,12,6],[3,0,3,1],[3,2,3,4],[3,5,3,7],[6,0,6,1],[6,2,6,4],[6,5,6,7]]}
["CALCUL AUTOMATIQUE DES INDEMNITES AUX JOUEURS (INDIVIDUEL, DOUBLETTES ET TRIPLETTES) PETANQUE EN ELIMINATION DIRECTE AU CUMUL "]
["DELEGUE :",null,null,null,null,"Dotation de l'organisateurs :",null,null,null,"Indemnités "]
[" N° SUPRA NATIONAL :",null,null,null,null,null,null,null,null,null,{"$f":"I2","v":0}]
["N° INTERNATIONAL :",null,null,null,null,"Nombres d'équipes engagées :",null,null,null,{"$f":"F12*G12","v":0},{"$f":"H12","v":0}]
[" N° NATIONAL :"]
["N° EVENEMENTIEL :"]
["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,{"$f":"IF(ISNUMBER(C5),6,0)+IF(ISNUMBER(C3),8,0)++IF(ISNUMBER(C4),8,0)++IF(ISNUMBER(C6),8,0)","v":0},{"$f":"F12*G12*E12","v":0}]
["Dotation ",null,null,null,null,null,null,{"$f":"I2","v":0}]
["Total indemnités",null,null,null,null,null,null,{"$f":"SUM(H12:H13)","v":0}]
["50% maxi de la dotation globale ",null,null,null,null,null,0.5,{"$f":"H14*G15","v":0}]
["25% mini de la dotation globale ",null,null,null,null,null,0.25,{"$f":"H14*G16","v":0}]
["II On informe uniquement les cellules grisées  "]
[null,null,null,null,null,null,"Parties d'office non payées"]
[null,"Total indemnités",null,null,{"$f":"H14","v":0}]
[null,"Equipes indemnisées","Indemnités par équipe","Cumul par partie","Reste indemnités à répartir","Cumulé"]
["1ère partie ",{"$f":"I7","v":0},0,0,{"$f":"+E19","v":0},0]
["2ème partie",{"$f":"ROUNDUP($B$21/2,0)","v":0},0,{"$f":"B22*C22","v":0},{"$f":"E21-D22","v":0},{"$f":"C22","v":0}]
["cadrage ",{"$f":"IF(B22>=128,B22-128,IF(B22>=64,B22-\"64\",IF(B22>=32,B22-\"32\",IF(B22>=16,B22-16,0))))","v":0},0,{"$f":"B23*C23","v":0},{"$f":"E22-D23","v":0},{"$f":"C22+C23","v":0}]
["64ème",{"$f":"IF(B22-B23=128,128/2,0)","v":0},0,0,0,{"$f":"F23+C24","v":0}]
["32ème",{"$f":"IF(B22-B23=64,32,IF(B24=64,B24/2,0))","v":0},0,0,0,0]
["16ème",{"$f":"IF(B22-B23=32,\"16\",IF(B25=32,B25/2,\"0\"))","v":"0"},0,0,0,0]
["8ème ",8,0,0,0,0]
["1/4 de finale",4,0,0,0,0]
["1/2 finale",2,0,{"$f":"B29*C29","v":0},0,0]
["finale",1,{"$f":"SUM(E29)","v":0},{"$f":"B30*C30","v":0},{"$f":"E29-D30","v":0},0]
[null,null,null,null,null,null,"> ou = à 25%",{"$f":"H16","v":0},"% Répartition","< ou = 50 %",{"$f":"H15","v":0}]
[null,null,null,{"$f":"SUM(D21:D31)","v":0},null,null,"Calcul règle des 25%-50%",null,{"$f":"J32/H14","v":{"$error":"#DIV/0!"}},{"$f":"E27","v":0}]
["VAINQUEUR",{"$f":"IF(F12=3,\"TRIPLETTE : 3 CHEQUES DE : \",IF(F12=2,\"DOUBLETTE : 2 CHEQUES DE : \",IF(F12=1,\"TETE A TETE : 1 CHEQUES de : \",\"\")))","v":"TRIPLETTE : 3 CHEQUES DE : "},null,null,{"$f":"IF(F12=3,(C29+C30)/3,IF(F12=2,(C29+C30)/2,IF(F12=1,(C29+C30)/1,0)))","v":0},null,{"$f":"IF(I32<0.25,0,IF(I32>0.5,0,1))","v":{"$error":"#DIV/0!"}},{"$f":"IF(G33=1,\"La répartition est correcte\",IF(I32<0.25,\"Le pourcentage doit être > ou = à 25%\",IF(I32>0.5,\"Le pourcentage ne doit pas dépasser 50%\",\"\")))","v":{"$error":"#DIV/0!"}}]
["FINALISTE",{"$f":"IF(F12=3,\"TRIPLETTE : 3 CHEQUES DE : \",IF(F12=2,\"DOUBLETTE : 2 CHEQUES DE : \",IF(F12=1,\"TETE A TETE : 1 CHEQUES de : \",\"\")))","v":"TRIPLETTE : 3 CHEQUES DE : "},null,null,{"$f":"IF(F12=3,C29/3,IF(F12=2,C29/2,IF(F12=1,C29/1,0)))","v":0}]

{"sheet":"AFFICHAGE ED","index":5,"n_rows":30,"n_cols":5,"rows_kept":30,"cut":false,"hidden":false,"merged":[[11,1,11,2],[11,3,11,4],[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],[8,3,10,4],[10,1,10,2],[3,1,3,2],[4,1,4,2]]}
["INDEMNITES DES JOUEURS"]
["DELEGUE",{"$f":"IF(' REPARTITION ED'!C2=0,\"\",' REPARTITION ED'!C2)","v":""}]
["N° SUPRANATIONAL :",{"$f":"IF(' REPARTITION ED'!C3=0,\"\",' REPARTITION ED'!C3)","v":""}]
["N° INTERNATIONAL",{"$f":"IF(' REPARTITION ED'!C4=0,\"\",' REPARTITION ED'!C4)","v":""}]
["N° NATIONAL :",{"$f":"IF(' REPARTITION ED'!C5=0,\"\",' REPARTITION ED'!C5)","v":""}]
["N° EVENEMENTIEL :",{"$f":"IF(' REPARTITION ED'!C6=0,\"\",' REPARTITION ED'!C6)","v":""}]
["LIEU :",{"$f":"IF(' REPARTITION ED'!C7=0,\"\",' REPARTITION ED'!C7)","v":""}]
[]
["Inscrits ","Inscription","Total"," Attention! Les 1/4 de finale sont réglés en espèce.                                                                        % compris entre 25% et 50%"]
[{"$f":"SUM(' REPARTITION ED'!I4)","v":0},{"$f":"SUM(' REPARTITION ED'!J4)","v":0},{"$f":"SUM(' REPARTITION ED'!K4)","v":0}]
["DOTATION ",{"$f":"SUM(' REPARTITION ED'!I2)","v":0}]
["TOTAL INDEMNITES ",{"$f":"SUM(' REPARTITION ED'!K7)","v":0},null,{"$f":"SUM(' REPARTITION ED'!I32)","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(' REPARTITION ED'!B21)","v":0},{"$f":"SUM(' REPARTITION ED'!C21)","v":0},{"$f":"SUM(' REPARTITION ED'!D21)","v":0},{"$f":"SUM(' REPARTITION ED'!F21)","v":0}]
["2ème partie",{"$f":"SUM(' REPARTITION ED'!B22)","v":0},{"$f":"SUM(' REPARTITION ED'!C22)","v":0},{"$f":"SUM(' REPARTITION ED'!D22)","v":0},{"$f":"SUM(' REPARTITION ED'!F22)","v":0}]
["cadrage ",{"$f":"SUM(' REPARTITION ED'!B23)","v":0},{"$f":"SUM(' REPARTITION ED'!C23)","v":0},{"$f":"SUM(' REPARTITION ED'!D23)","v":0},{"$f":"SUM(' REPARTITION ED'!F23)","v":0}]
["64ème",{"$f":"SUM(' REPARTITION ED'!B24)","v":0},{"$f":"SUM(' REPARTITION ED'!C24)","v":0},{"$f":"SUM(' REPARTITION ED'!D24)","v":0},{"$f":"SUM(' REPARTITION ED'!F24)","v":0}]
["32ème",{"$f":"SUM(' REPARTITION ED'!B25)","v":0},{"$f":"SUM(' REPARTITION ED'!C25)","v":0},{"$f":"SUM(' REPARTITION ED'!D25)","v":0},{"$f":"SUM(' REPARTITION ED'!F25)","v":0}]
["16ème",{"$f":"SUM(' REPARTITION ED'!B26)","v":0},{"$f":"SUM(' REPARTITION ED'!C26)","v":0},{"$f":"SUM(' REPARTITION ED'!D26)","v":0},{"$f":"SUM(' REPARTITION ED'!F26)","v":0}]
["8ème ",{"$f":"SUM(' REPARTITION ED'!B27)","v":8},{"$f":"SUM(' REPARTITION ED'!C27)","v":0},{"$f":"SUM(' REPARTITION ED'!D27)","v":0},{"$f":"SUM(' REPARTITION ED'!F27)","v":0}]
["1/4 de finale",{"$f":"SUM(' REPARTITION ED'!B28)","v":4},{"$f":"SUM(' REPARTITION ED'!C28)","v":0},{"$f":"SUM(' REPARTITION ED'!D28)","v":0},{"$f":"SUM(' REPARTITION ED'!F28)","v":0}]
["1/2 finale",{"$f":"SUM(' REPARTITION ED'!B29)","v":2},{"$f":"SUM(' REPARTITION ED'!C29)","v":0},{"$f":"SUM(' REPARTITION ED'!D29)","v":0},{"$f":"SUM(' REPARTITION ED'!F29)","v":0}]
["finale",{"$f":"SUM(' REPARTITION ED'!B30)","v":1},{"$f":"SUM(' REPARTITION ED'!C30)","v":0},{"$f":"SUM(' REPARTITION ED'!D30)","v":0},{"$f":"SUM(' REPARTITION ED'!F30)","v":0}]
[null,null,null,{"$f":"SUM(D15:D25)","v":0}]
[]
[null,"VAINQUEUR","Chèque par joueur",{"$f":"SUM(' REPARTITION ED'!E33)","v":0},8]
[null,"FINALISTE","Chèque par joueur",{"$f":"SUM(' REPARTITION ED'!E34)","v":0}]
[null,null,null,{"$f":"'[1]Poule cumul (PC)'!I34","v":"Dernière mise à jour V04102018"}]

{"sheet":"CR ED ","index":6,"n_rows":189,"n_cols":6,"rows_kept":189,"cut":false,"hidden":false,"merged":[[8,0,8,2],[9,0,9,2],[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],[7,0,7,2],[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],[41,2,41,3],[6,0,6,2],[12,1,12,3],[163,0,163,5],[1,1,1,5],[2,1,2,5],[12,4,12,5],[11,4,11,5],[15,3,15,5],[17,2,17,3],[41,0,41,1],[44,5,45,5],[84,0,84,5],[95,0,95,5],[100,0,100,1],[47,4,49,4],[59,4,61,4],[103,0,103,1],[105,3,105,5],[50,4,52,4],[5,0,5,5],[110,2,113,3],[158,0,159,5],[105,0,105,2],[100,3,100,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],[223,4,225,4],[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],[168,0,168,5],[167,2,167,5],[127,0,127,1],[130,4,130,5],[131,4,131,5],[35,2,35,3],[130,2,130,3],[131,2,131,3],[211,4,213,4],[214,4,216,4],[169,0,169,1],[183,0,183,5],[109,1,109,4],[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],[129,0,129,3],[147,3,147,5],[17,0,17,1],[18,0,18,3],[46,0,46,5],[56,4,58,4],[65,4,67,4],[88,4,90,4],[102,3,102,5],[31,0,31,5],[17,4,17,5],[99,0,99,5],[33,0,33,5],[32,0,32,5],[68,4,70,4],[71,0,71,5],[96,4,98,4],[92,4,94,4],[91,0,91,5],[40,2,40,3],[53,4,55,4],[40,0,40,1],[35,0,35,1],[134,4,135,4],[134,5,135,5],[132,0,132,5],[142,0,142,5],[160,0,160,5],[162,0,162,5],[134,2,135,2],[149,3,149,5],[143,3,143,5],[144,3,145,5],[154,0,154,1],[156,0,156,1]]}
[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 "]
["SUPRA NATIONAL",null,null,{"$f":"IF(' REPARTITION ED'!C3=0,\"\",' REPARTITION ED'!C3)","v":""}]
["INTERNATIONAL",null,null,{"$f":"IF(' REPARTITION ED'!C4=0,\"\",' REPARTITION ED'!C4)","v":""}]
["NATIONAL",null,null,{"$f":"IF(' REPARTITION ED'!C5=0,\"\",' REPARTITION ED'!C5)","v":""}]
["EVENEMENTIEL",null,null,{"$f":"IF(' REPARTITION ED'!C6=0,\"\",' REPARTITION ED'!C6)","v":""}]
[]
["INTITULE DU CONCOURS : ",null,null,"LIEU :"]
["Date","N° d’identification au calendrier national : ",null,null,{"$f":"SUM(' REPARTITION ED'!C3:E4)","v":0}]
[null,"C. D. et C.R.","Nom et Prénom","QUALITE"]
["Délégué :",null,{"$f":"IF(' REPARTITION ED'!C2=0,\"\",' REPARTITION ED'!C2)","v":""}]
["Arbitre :"]
["Organisateur : ",null,{"$f":"IF(' REPARTITION ED'!C8=0,\"\",' REPARTITION ED'!C8)","v":""}]
["ADRESSE E-mail et Tél. du Délégué :"]
["FORMULE RETENUE *"]
["Triplettes",{"$f":"IF(' REPARTITION ED'!F12=3,\"X\",\"\")","v":"X"},"Sénior"]
["Doublettes",{"$f":"IF(' REPARTITION ED'!F12=2,\"X\",\"\")","v":""},"Féminines"]
["Individuel",{"$f":"IF(' REPARTITION ED'!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":"C16","v":0}]
["(nom, prénom, signature",null,{"$f":"C36","v":0}]
[]
["OBSERVATIONS GENERALE DU DELEGUE"]
[]
["Le délégué F.F.P.J.P. ou C.R.",null,{"$f":"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(' REPARTITION ED'!I2)","v":0},{"$f":"C101","v":0}]
["Frais de participation",null,{"$f":"SUM(' REPARTITION ED'!J4)","v":0}]
["Nombre d'équipes inscrites",null,{"$f":"SUM(' REPARTITION ED'!I4)","v":0},{"$f":"C102*C103","v":0}]
["Nombre d'équipes présentes"]
[]
["TOTAL DES INDEMNITES DISTRIBUEES",null,null,{"$f":"D101+D103","v":0}]
[null,null,0.5,{"$f":"SUM(' REPARTITION ED'!H15)","v":0}]
[null,null,0.25,{"$f":"SUM(' REPARTITION ED'!H16)","v":0}]
[null,null,null,"% Attribuée ",{"$f":"SUM(D124/D106)","v":{"$error":"#DIV/0!"}}]
[]
[null,null,"Elimination directe          au cumul "]
[]
[]
[]
[]
[]
["Partie ","Nb équipe ","Indemnité","Reste à répartir","Cumulé",{"$f":"D106","v":0}]
["1ere partie ",{"$f":"SUM(' REPARTITION ED'!B21)","v":0},{"$f":"SUM(' REPARTITION ED'!C21)","v":0},{"$f":"SUM(' REPARTITION ED'!D21:D30)","v":0},{"$f":"C118","v":0},{"$f":"F117-D118","v":0}]
["2ème partie",{"$f":"SUM(' REPARTITION ED'!B22)","v":0},{"$f":"SUM(' REPARTITION ED'!C22)","v":0},{"$f":"SUM(' REPARTITION ED'!E22)","v":0},{"$f":"E118+C119","v":0},0]
["Cadrage",{"$f":"SUM(' REPARTITION ED'!B23)","v":0},{"$f":"SUM(' REPARTITION ED'!C23)","v":0},{"$f":"SUM(' REPARTITION ED'!E23)","v":0},0,0]
["1/64ème ",{"$f":"SUM(' REPARTITION ED'!B24)","v":0},{"$f":"SUM(' REPARTITION ED'!C24)","v":0},{"$f":"SUM(' REPARTITION ED'!E24)","v":0},0,0]
["1/32ème de finale",{"$f":"SUM(' REPARTITION ED'!B25)","v":0},{"$f":"SUM(' REPARTITION ED'!C25)","v":0},{"$f":"SUM(' REPARTITION ED'!E25)","v":0},0,0]
["1/16ème de finale",{"$f":"SUM(' REPARTITION ED'!B26)","v":0},{"$f":"SUM(' REPARTITION ED'!C26)","v":0},{"$f":"SUM(' REPARTITION ED'!E26)","v":0},0,0]
["1/8ème de finale",8,{"$f":"SUM(' REPARTITION ED'!C27)","v":0},{"$f":"SUM(' REPARTITION ED'!E27)","v":0},0,0]
["1/4  finale",4,{"$f":"SUM(' REPARTITION ED'!C28)","v":0},{"$f":"SUM(' REPARTITION ED'!E28)","v":0},0,0]
["1/2 finale",2,{"$f":"SUM(' REPARTITION ED'!C29)","v":0},{"$f":"SUM(' REPARTITION ED'!E29)","v":0},{"$f":"E125+C126","v":0}]
["Vainqueur",1,{"$f":"SUM(' REPARTITION ED'!C30)","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":"E13","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(' REPARTITION ED'!E33)","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(' REPARTITION ED'!E34)","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":"SUM(A97)","v":0},{"$f":"IF(' REPARTITION ED'!F12=3,B97,B97)","v":0},{"$f":"IF(' REPARTITION ED'!F12=3,C97,C97)","v":0},{"$f":"IF(' REPARTITION ED'!F12=3,D97,D97)","v":0},{"$f":"IF(' REPARTITION ED'!F12=3,E131,E131)","v":0}]
[{"$f":"SUM(A98)","v":0},{"$f":"IF(' REPARTITION ED'!F12<>1,B98,\"\")","v":0},{"$f":"IF(' REPARTITION ED'!F12<>1,C98,\"\")","v":0},{"$f":"IF(' REPARTITION ED'!F12<>1,D98,\"\")","v":0},{"$f":"IF(' REPARTITION ED'!F12<>1,E131,\"\")","v":0}]
[{"$f":"SUM(A99)","v":0},{"$f":"IF(' REPARTITION ED'!F12=3,B99,\"\")","v":0},{"$f":"IF(' REPARTITION ED'!F12=3,C99,\"\")","v":0},{"$f":"IF(' REPARTITION ED'!F12=3,D99,\"\")","v":0},{"$f":"IF(' REPARTITION ED'!F12=3,E131,\"\")","v":0}]
[{"$f":"SUM(A93)","v":0},{"$f":"IF(' REPARTITION ED'!F12=3,B93,B93)","v":0},{"$f":"IF(' REPARTITION ED'!F12=3,C93,C93)","v":0},{"$f":"IF(' REPARTITION ED'!F12=3,D93,D93)","v":0},{"$f":"IF(' REPARTITION ED'!F12=3,E132,E132)","v":0}]
[{"$f":"SUM(A94)","v":0},{"$f":"IF(' REPARTITION ED'!F12<>1,B94,\"\")","v":0},{"$f":"IF(' REPARTITION ED'!F12<>1,C94,\"\")","v":0},{"$f":"IF(' REPARTITION ED'!F12<>1,D94,\"\")","v":0},{"$f":"IF(' REPARTITION ED'!F12<>1,E132,\"\")","v":0}]
[{"$f":"SUM(A95)","v":0},{"$f":"IF(' REPARTITION ED'!F12=3,B95,\"\")","v":0},{"$f":"IF(' REPARTITION ED'!F12=3,C95,\"\")","v":0},{"$f":"IF(' REPARTITION ED'!F12=3,D95,\"\")","v":0},{"$f":"IF(' REPARTITION ED'!F12=3,E132,\"\")","v":0}]
["SIGNATURE"]
[null,{"$f":"B137","v":0},{"$f":"B144","v":0},"BANQUE "]
[null,0,{"$f":"B145","v":0}]
[null,0,0]
[null,0,0]
[null,0,0]
[null,0,0]
[]
["TOTAL DES INDEMNITES ",null,{"$f":"SUM(E137:E142)","v":0}]
[]
["FAIT A :",{"$f":"E12","v":0},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."]