{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["MENU","CR-Trip-Doub ","CR Jeune"],"not_rendered":{"charts":0,"images":1,"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":"CR-Trip-Doub ","index":1,"n_rows":202,"n_cols":6,"rows_kept":202,"cut":false,"hidden":false,"merged":[[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],[8,0,8,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],[26,2,27,4],[35,2,35,3],[9,0,9,2],[12,1,12,3],[128,0,128,1],[176,0,176,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,0,110,5],[180,2,180,5],[252,0,252,5],[242,4,244,4],[245,4,247,4],[248,4,250,4],[239,4,241,4],[221,4,223,4],[230,4,232,4],[16,3,16,5],[116,2,116,3],[233,4,235,4],[218,4,220,4],[199,0,199,5],[215,4,217,4],[206,4,208,4],[209,4,211,4],[212,4,214,4],[179,0,179,5],[108,4,108,5],[62,4,64,4],[109,4,109,5],[102,0,102,1],[101,0,101,1],[85,4,87,4],[171,0,172,5],[224,4,226,4],[227,4,229,4],[236,4,238,4],[154,3,154,5],[167,0,167,1],[200,5,201,5],[200,2,201,2],[170,0,170,1],[159,3,159,5],[174,0,174,5],[202,0,202,5],[200,4,201,4],[203,4,205,4],[177,3,177,5],[197,0,197,5],[187,0,187,1],[186,0,186,1],[185,0,185,1],[184,0,184,1],[183,0,183,1],[189,0,189,1],[188,0,188,1],[180,0,180,1],[169,0,169,1],[134,2,135,2],[160,3,160,5],[158,3,158,5],[161,3,161,5],[162,3,162,5],[150,3,150,5],[151,3,152,5],[129,0,129,1],[17,0,17,1],[18,0,18,3],[46,0,46,5],[109,2,109,3],[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],[105,0,105,2],[100,3,100,5],[35,0,35,1],[181,0,181,5],[182,0,182,1],[196,0,196,5],[111,1,111,4],[194,0,194,1],[193,0,193,1],[192,0,192,1],[191,0,191,1],[190,0,190,1],[153,3,153,5],[157,3,157,5],[165,1,165,2],[165,4,165,5],[155,3,155,5],[167,4,167,5],[163,0,163,1],[131,0,131,3],[156,3,156,5],[134,4,135,4],[134,5,135,5],[132,0,132,5],[149,0,149,5],[173,0,173,5],[175,0,175,5]]}
[null,"FEDERATION FRANCAISE DE PETANQUE  ET JEU PROVENCAL"]
[null,"Agréée par le Ministère des Sports"]
[null,"Siège social : 13, rue Trigance – 13002  MARSEILLE"]
[]
["RAPPORTS DE DELEGATION & D’ARBITRAGE"]
["VERSION V22022018  IND. TRIP. DOUB. En poule au cumul et PP, en élim. dir. au  cumul et PP"]
["SUPRA NATIONAL",null,null,null,"*"]
["INTERNATIONAL",null,null,null,"*"]
["NATIONAL",null,null,null,"*"]
["EVENEMENTIEL ",null,null,null,"*"]
["*Mettre une croix dans la case correspondante"]
["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é :"]
["Arbitre :"]
["Organisateur : "]
["ADRESSE E-mail et Tél. du Délégué :"]
["FORMULE RETENUE *"]
["Triplette","X","Sénior"]
["Doublette",null,"Féminine"]
["Individuel",null,"Vétérans "]
[null,null,"Mixte"]
[]
["*Mettre une croix dans la case correspondante"]
["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":0}]
["(signature)",null,{"$f":"C41","v":0}]
[]
["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,0,{"$f":"C101","v":0}]
["Frais de participation",null,0]
["Nombre d'équipes inscrites",null,0,{"$f":"C102*C103","v":0}]
["Nombre d'équipes présentes",null,0]
[]
["TOTAL DES INDEMNITES DISTRIBUEES",null,null,{"$f":"D101+D103","v":0}]
[0.5,{"$f":"D106*A107","v":0},"Somme restante après les 8ème",{"$f":"F126","v":0}]
[0.25,{"$f":"D106*A108","v":0},"Somme totale attribuée aux 8 équipes",{"$f":"SUM(D120:D126)","v":0}]
[null,null,null,"% Attribuée ",{"$f":"D107/D106","v":{"$error":"#DIV/0!"}}]
[{"$f":"C128","v":0},"Cumul aux 4 équipes ",{"$f":"IF(C131=12,\"TRIPLETTE Montant des 12 chèques\",IF(C131=8,\"DOUBLETTE Montant des 8 chèques\",IF(C131=4,\"TETE A TETE Montant des 4 chèques\",\"\")))","v":"TRIPLETTE Montant des 12 chèques"},null,{"$f":"C129","v":0}]
["Mode de calcul des 4 prix identiques. Voir règlement Article 8"]
[null,"Mettre obligatoirement un X  dans la cellule  concernée  *"]
[null,null,"Poule au cumul","*"]
[null,null,"Poule à la partie perdue","*"]
[null,null,"Elimination directe cumul","*"]
[null,null,"Elimination directe partie perdue","*"]
[]
[]
["Partie ","Nb équipe ","Indemnité","Total","Cumulé",{"$f":"D106","v":0}]
["1ere partie ou Sortie de poule",null,null,{"$f":"B120*C120","v":0},{"$f":"C120","v":0},{"$f":"F119-D120","v":0}]
["2ème partie ou 1ère par. ap.poule",null,null,{"$f":"B121*C121","v":0},{"$f":"E120+C121","v":0},0]
["Cadrage",null,null,0,0,0]
["1/64ème ",null,null,0,0,0]
["1/32ème de finale",null,null,0,0,0]
["1/16ème de finale",null,null,0,0,0]
["1/8ème de finale",8,null,0,0,0]
["1/4  fin.",4,null,0,0,0]
["1/2 fin. & fin. (finaliste PP)",4,{"$f":"D128/4","v":0},{"$f":"F127","v":0},{"$f":"E127+C128","v":0}]
[{"$f":"IF(C131=12,\"TRIPLETTE Montant des 12 chèques\",IF(C131=8,\"DOUBLETTE Montant des 8 chèques\",IF(C131=4,\"TETE A TETE Montant des 4 chèques\",\"\")))","v":"TRIPLETTE Montant des 12 chèques"},null,{"$f":"D128/C131","v":0},null,4]
["SI DOUBLETTE Montant des 8 chèques",null,{"$f":"C128/B131","v":{"$error":"#DIV/0!"}}]
[4,null,{"$f":"IF(B20<>\"\",12,IF(B21<>\"\",8,IF(B22<>\"\",4,0)))","v":12},{"$f":"SUM(D120:D128)","v":0}]
[{"$f":"C12","v":0},null,null,null,"N°",{"$f":"E13","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":"A86","v":0},{"$f":"B86","v":0},{"$f":"C86","v":0},{"$f":"D86","v":0},{"$f":"C129","v":0}]
[{"$f":"A87","v":0},0,0,0,{"$f":"C129","v":0}]
[{"$f":"IF(C131=12,A88,\"\")","v":0},{"$f":"IF(C131=12,B88,\"\")","v":0},{"$f":"IF(C131=12,C88,\"\")","v":0},{"$f":"IF(C131=12,D88,\"\")","v":0},{"$f":"IF(C131=12,C129,\"\")","v":0}]
[0,0,0,0,{"$f":"C129","v":0}]
[0,0,0,0,{"$f":"C129","v":0}]
[{"$f":"IF(C131=12,A91,\"\")","v":0},{"$f":"IF(C131=12,B91,\"\")","v":0},{"$f":"IF(C131=12,C91,\"\")","v":0},{"$f":"IF(C131=12,D91,\"\")","v":0},{"$f":"IF(C131=12,C129,\"\")","v":0}]
[{"$f":"A93","v":0},0,0,0,{"$f":"C129","v":0}]
[0,0,0,0,{"$f":"C129","v":0}]
[{"$f":"IF(C131=12,A95,\"\")","v":0},{"$f":"IF(C131=12,B95,\"\")","v":0},{"$f":"IF(C131=12,C95,\"\")","v":0},{"$f":"IF(C131=12,D95,\"\")","v":0},{"$f":"IF(C131=12,C129,\"\")","v":0}]
[{"$f":"A97","v":0},0,0,0,{"$f":"C129","v":0}]
[0,0,0,0,{"$f":"C129","v":0}]
[{"$f":"IF(C131=12,A99,\"\")","v":0},{"$f":"IF(C131=12,B99,\"\")","v":0},{"$f":"IF(C131=12,C99,\"\")","v":0},{"$f":"IF(C131=12,D99,\"\")","v":0},{"$f":"IF(C131=12,C129,\"\")","v":0}]
[]
["SIGNATURE"]
[null,{"$f":"B137","v":0},{"$f":"B151","v":0},"BANQUE "]
[null,{"$f":"B138","v":0},{"$f":"B152","v":0}]
[null,{"$f":"IF(C131=12,B139,\"\")","v":0},{"$f":"IF(C131=12,B153,\"\")","v":0}]
[null,0,0]
[null,0,0]
[null,{"$f":"IF(C131=12,B142,\"\")","v":0},{"$f":"IF(C131=12,B156,\"\")","v":0}]
[null,0,0]
[null,0,0]
[null,{"$f":"IF(C131=12,B145,\"\")","v":0},{"$f":"IF(C131=12,B159,\"\")","v":0}]
[null,0,0]
[null,0,{"$f":"B161","v":0}]
[null,{"$f":"IF(C131=12,B148,\"\")","v":0},{"$f":"IF(C131=12,B162,\"\")","v":0}]
[]
["TOTAL DES INDEMNITES ",null,{"$f":"SUM(E137:E148)","v":0}]
[]
["FAIT A :",{"$f":"E12","v":0},null,"LE :"]
[]
["Signature de l'Organisateur ",null,{"$f":"C17","v":0}]
[]
["Signature du Délégué",null,{"$f":"C42","v":0}]
[]
["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":"CR Jeune","index":2,"n_rows":283,"n_cols":10,"rows_kept":283,"cut":false,"hidden":false,"merged":[[64,0,64,1],[65,0,66,5],[213,0,213,1],[225,0,225,5],[228,0,228,5],[214,0,214,1],[215,0,215,1],[216,0,216,1],[217,0,217,1],[67,0,67,5],[68,0,68,5],[69,0,69,5],[113,0,113,5],[129,0,129,5],[70,0,70,5],[72,0,72,5],[73,4,74,4],[75,0,75,5],[100,0,100,5],[71,2,71,5],[209,0,209,1],[210,0,210,1],[211,0,211,1],[212,0,212,1],[56,0,56,1],[56,2,56,5],[57,0,57,1],[57,2,57,5],[59,1,59,2],[59,4,59,5],[61,0,61,1],[61,4,61,5],[63,0,63,1],[49,0,49,1],[49,3,49,5],[50,0,50,1],[52,0,52,5],[53,0,53,1],[53,2,53,5],[54,0,54,1],[54,2,54,5],[55,0,55,1],[55,2,55,5],[44,0,44,1],[44,2,44,3],[47,0,47,5],[48,0,48,1],[48,3,48,5],[39,0,39,1],[39,2,39,3],[41,0,41,5],[42,0,42,5],[43,0,43,1],[29,2,30,4],[32,0,32,5],[33,0,33,2],[43,2,43,3],[34,0,34,5],[35,0,35,5],[36,0,36,5],[37,0,37,5],[38,0,38,1],[38,2,38,3],[15,3,15,5],[17,0,17,3],[23,0,23,5],[16,0,16,1],[16,2,16,3],[16,4,16,5],[24,0,24,1],[28,0,28,1],[28,2,28,4],[208,0,208,5],[139,0,139,1],[140,0,140,1],[141,0,141,1],[142,0,142,1],[143,0,143,1],[144,0,144,1],[218,0,218,1],[0,0,2,0],[0,1,0,5],[1,1,1,5],[2,1,2,5],[4,0,4,5],[6,0,6,1],[6,3,6,4],[7,0,7,1],[7,3,7,4],[8,0,8,2],[10,0,10,1],[10,4,10,5],[11,1,11,2],[12,3,12,5],[13,3,13,5],[14,3,14,5],[219,0,219,1],[293,0,293,1],[220,0,220,1],[221,0,221,1],[283,0,283,1],[284,0,284,5],[253,0,253,5],[266,0,266,5],[282,0,282,5],[287,0,287,1],[285,0,285,1],[286,0,286,1],[223,0,223,5],[283,2,283,5],[299,0,299,5],[297,0,297,1],[288,0,288,1],[289,0,289,1],[290,0,290,1],[291,0,291,1],[292,0,292,1],[294,0,294,1],[295,0,295,1],[296,0,296,1],[130,0,130,1],[130,2,130,5],[131,0,131,5],[132,0,132,1],[146,0,146,5],[207,2,207,5],[147,0,147,4],[149,0,149,5],[150,4,151,4],[152,0,152,5],[207,0,207,1],[133,0,133,1],[134,0,134,1],[135,0,135,1],[136,0,136,1],[137,0,137,1],[138,0,138,1],[206,0,206,5],[177,0,177,5],[190,0,190,5]]}
[null,"FEDERATION FRANCAISE DE PETANQUE  ET JEU PROVENCAL"]
[null,"Agréée par le Ministère des Sports"]
[null,"Siège social : 13, rue Trigance – 13002  MARSEILLE"]
[]
["VERSION V22022018  RAPPORTS DE DELEGATION  CONCOURS JEUNES DOTATION EN LOTS "]
[]
["INTERNATIONAL*"]
["NATIONAL*"]
["*Mettre une croix dans la case correspondante"]
[]
["INTITULE DU CONCOURS : ",null,null,"LIEU :"]
["Date","N° d’identification au calendrier national : "]
[null,"C. D. et C.R.","NOM ET PRENOM","QUALITE"]
["Délégué :"]
["Arbitre :"]
["Organisateur : "]
["Adresse e-mail et Tél. du Délégué :"]
["FORMULE RETENUE"]
["Pétanque",null,"Junior"]
["Jeu Provençal",null,"Cadet"]
["Triplette",null,"Minime"]
["Doublette",null,"Poule"]
["Mixte ",null,"Elimination directe "]
["*Mettre une croix dans la case correspondante"]
["NOMBRE D'EQUIPES INCRITES ",null,"NOMBRE D'EQUIPES PRESENTES"]
["JUNIORS"]
["CADETS"]
["MINIMES "]
["Tirage au sort effectué le :",null,"En présence"]
["Date "]
["Informatique"]
[]
["OBSERVATIONS DE L'ARBITRE DELEGUE"]
["Nombres d’arbitres ayant officié à ses côtés :",null,null,4]
["QUALITE DE L'ARBITRAGE "]
[]
["AVIS SUR LA QUALITE DE L'ORGANISATION "]
[]
["L'Arbitre FFPJP désigné :",null,{"$f":"C15","v":0}]
["(signature)",null,{"$f":"C39","v":0}]
[]
["OBSERVATIONS GENERALE DU DELEGUE"]
[]
["Le Délégué FFPJP ou C.R. désigné :",null,{"$f":"C14","v":0}]
["(signature)",null,{"$f":"C44","v":0}]
[]
[]
["      INDEMNITES : LOTS EN NATURE "]
["Dotation de l'organisation"]
["Nombre d'équipes inscrites"]
["Nombre d'équipes présentes",null,null,null,null,null,null,null,null," "]
[]
["LOTS PRINCIPAUX A PARTIR DES 1/4 DE FINALE "]
["1/4 de finale "]
["1/2 finale"]
["Finaliste"]
["Gagnant "]
["Observations éventuelles"]
[]
["FAIT A :",null,null,"LE :"]
[]
["Signature de l'Organisateur ",null,{"$f":"C16","v":0}]
[]
["Signature du Délégué",null,{"$f":"C45","v":0}]
[]
["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.            "]
[]
["2 / une copie au Président du C.R."]
["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. "]
[]
["RESULTAT DU CONCOURS JUNIORS (à 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"]
[]
[]
[]
[]
[]
[]
[null,null,"Finaliste"]
[]
[]
[]
[null,null,"Champion"]
[]
[]
[]
[]
["CLASSIFICATION DE LA MANIFESTATION JUNIOR"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["RESULTAT DU CONCOURS CADETS (à 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"]
[]
[]
[]
[]
[]
[]
[null,null,"Finaliste"]
[]
[]
[]
[null,null,"Champion"]
[]
[]
[]
[]
["CLASSIFICATION DE LA MANIFESTATION CADET"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["RESULTAT DU CONCOURS MINIMES (à 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"]
[]
[]
[]
[]
[]
[]
[null,null,"Finaliste"]
[]
[]
[]
[null,null,"Chanpion"]
[]
[]
[]
[]
["CLASSIFICATION DE LA MANIFESTATION MINIME"]