{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["MENU","CR-JP-ED-Cumul","CR-JP-ED-PP","CR-JP-Poule-Cumul ","CR-JP-Poule-PP"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":3,"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-JP-ED-Cumul","index":1,"n_rows":184,"n_cols":6,"rows_kept":184,"cut":false,"hidden":false,"merged":[[174,0,174,1],[175,0,175,1],[176,0,176,1],[177,0,177,1],[166,0,166,1],[167,0,167,1],[168,0,168,1],[169,0,169,1],[170,0,170,1],[171,0,171,1],[218,4,220,4],[221,4,223,4],[224,4,226,4],[227,4,229,4],[230,4,232,4],[234,0,234,5],[200,4,202,4],[203,4,205,4],[206,4,208,4],[209,4,211,4],[212,4,214,4],[215,4,217,4],[184,0,184,5],[185,4,187,4],[188,4,190,4],[191,4,193,4],[194,4,196,4],[197,4,199,4],[156,0,156,5],[157,0,157,5],[158,0,158,5],[159,3,159,5],[181,0,181,5],[182,2,183,2],[182,4,183,4],[182,5,183,5],[161,0,161,5],[165,0,165,1],[160,3,160,5],[179,0,179,5],[162,0,162,5],[163,0,163,1],[163,2,163,5],[164,0,164,5],[172,0,172,1],[173,0,173,1],[149,0,149,1],[149,4,149,5],[151,0,151,1],[152,0,152,1],[153,0,154,5],[155,0,155,5],[140,3,140,5],[141,3,141,5],[142,3,142,5],[143,3,143,5],[145,0,145,1],[147,1,147,2],[147,4,147,5],[145,3,145,4],[133,0,133,5],[134,3,134,5],[135,3,136,5],[137,3,137,5],[138,3,138,5],[139,3,139,5],[102,0,102,2],[102,7,102,9],[119,0,119,3],[120,0,120,5],[122,2,123,2],[122,4,123,4],[122,5,123,5],[103,0,103,1],[103,2,103,5],[100,0,100,2],[100,7,100,9],[101,0,101,1],[101,7,101,8],[101,10,101,12],[98,0,98,2],[98,3,98,5],[99,0,99,1],[99,7,99,8],[99,10,99,12],[88,0,88,5],[92,0,92,5],[93,0,93,1],[93,3,93,5],[94,0,94,1],[96,0,96,1],[95,3,95,5],[95,0,95,1],[55,4,57,4],[58,4,60,4],[61,4,63,4],[64,0,64,5],[77,0,77,5],[84,0,84,5],[39,0,39,5],[40,4,42,4],[43,4,45,4],[46,4,48,4],[49,4,51,4],[52,4,54,4],[34,0,34,1],[34,2,34,3],[36,0,36,5],[37,2,38,2],[37,4,38,4],[37,5,38,5],[29,0,29,1],[29,2,29,3],[31,0,31,5],[32,0,32,5],[33,0,33,1],[33,2,33,3],[24,0,24,5],[25,0,25,5],[26,0,26,5],[27,0,27,5],[28,0,28,1],[28,2,28,3],[17,0,17,1],[18,0,18,1],[18,2,18,4],[19,2,20,4],[22,0,22,5],[23,0,23,2],[21,0,21,1],[17,3,17,5],[13,3,13,5],[14,3,14,5],[15,3,15,5],[16,0,16,1],[16,2,16,3],[16,4,16,5],[9,0,9,2],[10,0,10,1],[10,4,10,5],[11,1,11,3],[11,4,11,5],[12,3,12,5],[7,0,7,2],[8,0,8,2],[0,0,2,0],[0,1,0,5],[1,1,1,5],[2,1,2,5],[4,0,4,5],[6,1,6,4]]}
[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 JEU PROVENCAL"]
[]
["VERSION ","V22022018      TRIPLETTE ELIMINATION DIRECTE AU CUMUL"]
["INTERNATIONAL - EVENEMENTIEL",null,null,null,"*"]
["NATIONAL",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é :"]
[]
["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 :"]
["Qualité de l’arbitrage dispensé :"]
[]
["Avis sur la qualité de l’organisation "]
[]
["L'Arbitre FFPJP désigné :",null,{"$f":"C15","v":0}]
["(nom, prénom, signature",null,{"$f":"C29","v":0}]
[]
["OBSERVATIONS GENERALE DU DELEGUE"]
[]
["Le Délégué FFPJP ou C.R. désigné :",null,{"$f":"C14","v":0}]
["(signature)",null,{"$f":"C34","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"]
[]
[]
[]
[]
[]
[]
["Finaliste"]
[]
[]
[]
["Gagnant"]
[]
[]
[]
["INDEMNITES (article 8 du règlement des concours Internationaux et Nationaux)"]
["Dotation de l'organisation",null,null,{"$f":"C94","v":0}]
["Frais de participation"]
["Nombre d'équipes inscrites",null,null,{"$f":"C95*C96","v":0}]
["Nombre d'équipes présentes"]
[]
["TOTAL DES INDEMNITES DISTRIBUEES",null,null,{"$f":"D94+D96","v":0}]
["CUMUL AU VAINQUEUR",null,null,{"$f":"SUM(C106:C115)","v":0}]
["L’indemnité globale perçue par le vainqueur ne doit pas dépasser 25% du total des indemnités ",null,null,{"$f":"D99*E101","v":0},0.25]
["CUMUL AUX FINALISTES ",null,null,{"$f":"E114","v":0}]
["L’indemnité globale perçue devra être supérieure ou égale à 60 % de celle du gagnant",null,null,{"$f":"D100*E103","v":0},0.6]
["FORMULE RETENUE CR-JP-ED-Cumul",null," Compte rendu Jeu Provençal en élimination directe au cumul   "]
["PARTIE","Nb. Équipe","Indemnité","Total","Cumulé"]
["1ère partie",null,null,{"$f":"B106*C106","v":0},{"$f":"C106","v":0},{"$f":"D99-D106","v":0}]
["2ème partie",null,null,{"$f":"B107*C107","v":0},{"$f":"E106+C107","v":0},{"$f":"F106-D107","v":0}]
["Cadrage",null,null,{"$f":"B108*C108","v":0},{"$f":"E107+C108","v":0},0]
["1/64ème ",null,null,0,{"$f":"E108+C109","v":0},0]
["1/32ème",null,null,0,{"$f":"E109-C110","v":0},0]
["1/16ème",null,null,0,{"$f":"E110+C111","v":0},0]
["1/8ème",8,null,0,{"$f":"E111+C112","v":0},0]
["1/4 de finale",4,null,0,{"$f":"E112+C113","v":0},0]
["1/2 finales",2,null,0,{"$f":"E113+C114","v":0},0]
["Finale",1,{"$f":"F114","v":0},{"$f":"C115","v":0},{"$f":"E114+C115","v":0},{"$f":"F114-C115","v":0}]
[null,"NOMBRE","MONTANT "]
["1/2 FINALE ","6 CHEQUES DE:",{"$f":"D114/6","v":0}]
["GAGNANT ","3 CHEQUES DE : ",{"$f":"C115/3","v":0}]
[]
[{"$f":"C11","v":0},null,null,null,"N°",{"$f":"E12","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":"A79","v":0},{"$f":"B79","v":0},{"$f":"C79","v":0},{"$f":"D79","v":0},{"$f":"C117","v":0}]
[{"$f":"A80","v":0},0,0,0,{"$f":"C117","v":0}]
[0,0,0,0,{"$f":"C117","v":0}]
[0,0,0,0,{"$f":"C117","v":0}]
[0,0,{"$f":"C83","v":0},{"$f":"D83","v":0},{"$f":"C117","v":0}]
[0,0,{"$f":"C84","v":0},{"$f":"D84","v":0},{"$f":"C117","v":0}]
[{"$f":"A90","v":0},{"$f":"B90","v":0},{"$f":"C90","v":0},{"$f":"D90","v":0},{"$f":"C118","v":0}]
[{"$f":"A91","v":0},0,0,0,{"$f":"C118","v":0}]
[0,0,0,0,{"$f":"C118","v":0}]
["SIGNATURE"]
[null,{"$f":"B125","v":0},{"$f":"B135","v":0},"BANQUE "]
[null,0,{"$f":"B136","v":0}]
[null,0,0]
[null,0,0]
[null,0,0]
[null,0,0]
[null,0,0]
[null,0,{"$f":"B142","v":0}]
[null,0,{"$f":"B143","v":0}]
[]
[]
["TOTAL DES INDEMNITES ",null,{"$f":"SUM(E125:E133)","v":0},"EN CHEQUE"]
[]
["FAIT A :",null,null,"LE :"]
[]
["Signature de l'Organisateur ",null,{"$f":"C16","v":0}]
[]
["Signature du Délégué",null,{"$f":"C14","v":0}]
[]
["1/ Un exemplaire de ce compte-rendu DUMENT REMPLI est à transmettre PAR LE DELEGUE dans la semaine qui suit, au siège social de la F.F.P.J.P.   PAR MAIL   ffpjp.siege@petanque.fr     "]
[]
["2 / une copie au Président du C.R. concerné "]
["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. "]
[null,null,null,"Dernière mise à jour V22022018"]
[]
["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-JP-ED-PP","index":2,"n_rows":192,"n_cols":6,"rows_kept":192,"cut":false,"hidden":false,"merged":[[235,4,237,4],[238,4,240,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],[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],[226,4,228,4],[229,4,231,4],[232,4,234,4],[189,0,189,5],[190,2,191,2],[190,4,191,4],[190,5,191,5],[169,0,169,5],[170,0,170,5],[171,0,171,1],[171,2,171,5],[172,0,172,5],[173,0,173,1],[177,0,177,1],[184,0,184,1],[185,0,185,1],[187,0,187,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],[161,0,162,5],[163,0,163,5],[164,0,164,5],[165,0,165,5],[166,0,166,5],[167,3,167,5],[168,3,168,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],[153,3,153,4],[159,0,159,1],[160,0,160,1],[146,3,146,5],[147,3,147,5],[148,3,148,5],[149,3,149,5],[150,3,150,5],[151,3,151,5],[139,0,139,5],[140,3,140,5],[141,3,142,5],[143,3,143,5],[144,3,144,5],[145,3,145,5],[102,0,102,2],[102,7,102,9],[121,0,121,3],[122,0,122,5],[124,2,125,2],[124,4,125,4],[124,5,125,5],[103,0,103,1],[103,2,103,5],[99,10,99,12],[100,0,100,2],[100,7,100,9],[101,0,101,1],[101,7,101,8],[101,10,101,12],[84,0,84,5],[96,0,96,1],[98,0,98,2],[98,3,98,5],[99,0,99,1],[99,7,99,8],[88,0,88,5],[92,0,92,5],[93,0,93,1],[93,3,93,5],[85,4,87,4],[89,4,91,4],[46,4,48,4],[49,4,51,4],[52,4,54,4],[95,0,95,1],[95,3,95,5],[55,4,57,4],[58,4,60,4],[61,4,63,4],[64,0,64,5],[77,0,77,5],[94,0,94,1],[65,4,67,4],[68,4,70,4],[71,4,73,4],[74,4,76,4],[78,4,80,4],[81,4,83,4],[39,0,39,5],[40,4,42,4],[43,4,45,4],[32,0,32,5],[33,0,33,1],[33,2,33,3],[34,0,34,1],[34,2,34,3],[36,0,36,5],[31,0,31,5],[22,0,22,5],[17,3,17,5],[23,0,23,2],[24,0,24,5],[25,0,25,5],[26,0,26,5],[37,2,38,2],[37,4,38,4],[37,5,38,5],[11,4,11,5],[12,3,12,5],[13,3,13,5],[14,3,14,5],[27,0,27,5],[28,0,28,1],[28,2,28,3],[29,0,29,1],[29,2,29,3],[0,0,2,0],[0,1,0,5],[1,1,1,5],[2,1,2,5],[4,0,4,5],[5,0,5,5],[174,0,174,1],[175,0,175,1],[176,0,176,1],[6,0,6,5],[7,0,7,2],[8,0,8,2],[9,0,9,2],[10,0,10,1],[15,3,15,5],[16,0,16,1],[17,0,17,1],[18,0,18,1],[18,2,18,4],[19,2,20,4],[16,2,16,3],[16,4,16,5],[10,4,10,5],[11,1,11,3]]}
[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 JEU PROVENCAL"]
["EXEMPLE 138 EQUIPES EN E. D. A LA PARTIE PERDUE voir chapitre Indemnites"]
["VERSION V24012018             ELIMINATION DIRECTE A LA PARTIE PERDUE"]
["INTERNATIONAL EVENEMENTIEL",null,null,null,"*"]
["NATIONAL",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é :"]
[]
["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 :"]
["Qualité de l’arbitrage dispensé :"]
[]
["Avis sur la qualité de l’organisation "]
[]
["L'Arbitre FFPJP désigné :",null,{"$f":"C15","v":0}]
["(nom, prénom, signature",null,{"$f":"C29","v":0}]
[]
["OBSERVATIONS GENERALE DU DELEGUE"]
[]
["Le Délégué FFPJP ou C.R. désigné :",null,{"$f":"C14","v":0}]
["(signature)",null,{"$f":"C34","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,null,{"$f":"C94","v":0}]
["Frais de participation"]
["Nombre d'équipes inscrites",null,null,{"$f":"C95*C96","v":0}]
["Nombre d'équipes présentes"]
[]
["TOTAL DES INDEMNITES DISTRIBUEES",null,null,{"$f":"D94+D96","v":0}]
["CUMUL AU VAINQUEUR",null,null,{"$f":"C116","v":0}]
["L’indemnité globale perçue par le vainqueur ne doit pas dépasser 25% du total des indemnités ",null,null,{"$f":"D99*E101","v":0},0.25]
["Finaliste",null,null,{"$f":"E115","v":0}]
["L’indemnité globale perçue devra être supérieure ou égale à 60 % de celle du gagnant",null,null,{"$f":"D100*E103","v":0},0.6]
["FORMULE RETENUE CR-JP-ED-PP",null," Compte rendu Jeu Provençal en Elimination directe à la partie perdue"]
["PARTIE","Nb. Équipe","Indemnité","Total"]
["1ére partie",null,null,null,null,{"$f":"D99-C106","v":0}]
["2ème partie",null,null,{"$f":"B107*C107","v":0},{"$f":"E106+C107","v":0},{"$f":"F106-D107","v":0}]
["Cadrage",null,null,{"$f":"B108*C108","v":0},{"$f":"C108","v":0},0]
["1/64ème ",null,null,0,{"$f":"C109","v":0},0]
["1/32ème",null,null,0,0,0]
["1/16ème",null,null,0,0,0]
["1/8ème",8,null,0,0,0]
["1/4 de finale",4,null,0,0,0]
["1/2 finales",2,null,0,0,0]
["Finaliste",1,null,0,0,{"$f":"F114-D115","v":0}]
["Finale",1,{"$f":"F115","v":0},{"$f":"C116","v":0},0,{"$f":"F115-D116","v":0}]
[null,"NOMBRE","MONTANT "]
["1/2 FINALE ","6 CHEQUES DE:",{"$f":"D114/6","v":0}]
["FINALISTE","3 CHEQUE DE :",{"$f":"C115/3","v":0}]
["GAGNANT ","3 CHEQUES DE : ",{"$f":"C116/3","v":0}]
[]
[{"$f":"C11","v":0},null,null,null,"N°",{"$f":"E12","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":"A79","v":0},0,0,0,{"$f":"C118","v":0}]
[0,0,0,0,{"$f":"C118","v":0}]
[0,0,0,0,{"$f":"C118","v":0}]
[0,0,0,0,{"$f":"C118","v":0}]
[0,0,0,0,{"$f":"C118","v":0}]
[0,0,0,0,{"$f":"C118","v":0}]
[{"$f":"A86","v":0},0,0,0,{"$f":"C119","v":0}]
[0,0,0,0,{"$f":"C119","v":0}]
[0,0,0,0,{"$f":"C119","v":0}]
[{"$f":"A90","v":0},0,0,0,{"$f":"C120","v":0}]
[0,0,0,0,{"$f":"C120","v":0}]
[0,0,0,0,{"$f":"C120","v":0}]
[]
["SIGNATURE"]
[null,{"$f":"B127","v":0},{"$f":"B141","v":0},"BANQUE "]
[null,{"$f":"B128","v":0},{"$f":"B142","v":0}]
[null,0,0]
[null,0,0]
[null,0,0]
[null,0,0]
[null,0,0]
[null,0,0]
[null,0,0]
[null,0,0]
[null,0,{"$f":"B151","v":0}]
[null,0,{"$f":"B152","v":0}]
[]
["TOTAL DES INDEMNITES ",null,{"$f":"SUM(E127:E138)","v":0},"EN CHEQUE "]
[]
["FAIT A :",null,null,"LE :"]
[]
["Signature de l'Organisateur ",null,{"$f":"C16","v":0}]
[]
["Signature du Délégué",null,{"$f":"C14","v":0}]
[]
["1/ Un exemplaire de ce compte-rendu DUMENT REMPLI est à transmettre PAR LE DELEGUE dans la semaine qui suit, au siège social de la F.F.P.J.P.  PAR MAIL   ffpjp.siege@petanque.fr     "]
[]
["2 / une copie au Président du C.R. concerné"]
["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. "]
[null,null,null,"Dernière mise à jour V24012018"]
[]
["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-JP-Poule-Cumul ","index":3,"n_rows":183,"n_cols":6,"rows_kept":183,"cut":false,"hidden":false,"merged":[[159,3,159,5],[139,3,139,5],[142,3,142,5],[143,3,143,5],[146,1,146,2],[150,0,150,1],[141,3,141,5],[181,5,182,5],[181,2,182,2],[151,0,151,1],[140,3,140,5],[155,0,155,5],[144,0,144,1],[154,0,154,5],[156,0,156,5],[148,0,148,1],[160,0,160,5],[180,0,180,5],[172,0,172,1],[173,0,173,1],[174,0,174,1],[175,0,175,1],[176,0,176,1],[171,0,171,1],[133,0,133,5],[8,0,8,2],[40,4,42,4],[33,0,33,1],[33,2,33,3],[46,4,48,4],[122,2,123,2],[10,0,10,2],[120,0,120,5],[95,0,95,1],[98,0,98,2],[95,3,95,5],[93,3,93,5],[64,0,64,5],[49,4,51,4],[93,0,93,1],[92,0,92,5],[119,0,119,3],[103,0,103,1],[103,2,103,5],[88,0,88,5],[58,4,60,4],[84,0,84,5],[61,4,63,4],[233,0,233,5],[223,4,225,4],[226,4,228,4],[229,4,231,4],[220,4,222,4],[184,4,186,4],[202,4,204,4],[196,4,198,4],[187,4,189,4],[211,4,213,4],[217,4,219,4],[214,4,216,4],[199,4,201,4],[205,4,207,4],[208,4,210,4],[190,4,192,4],[193,4,195,4],[183,0,183,5],[181,4,182,4],[138,3,138,5],[157,0,157,5],[152,0,153,5],[122,4,123,4],[122,5,123,5],[148,4,148,5],[134,3,134,5],[135,3,136,5],[146,4,146,5],[137,3,137,5],[166,0,166,1],[167,0,167,1],[168,0,168,1],[161,0,161,5],[162,0,162,1],[162,2,162,5],[163,0,163,5],[164,0,164,1],[165,0,165,1],[169,0,169,1],[170,0,170,1],[178,0,178,5],[2,1,2,5],[9,0,9,2],[12,4,12,5],[12,0,12,1],[6,1,6,4],[7,0,7,5],[0,1,0,5],[37,4,38,4],[19,2,19,4],[4,0,4,5],[36,0,36,5],[0,0,2,0],[13,1,13,3],[1,1,1,5],[22,0,22,5],[28,0,28,1],[15,3,15,5],[19,0,19,1],[23,0,23,2],[13,4,13,5],[24,0,24,5],[77,0,77,5],[43,4,45,4],[55,4,57,4],[29,0,29,1],[37,2,38,2],[31,0,31,5],[96,0,96,1],[98,3,98,5],[37,5,38,5],[34,0,34,1],[34,2,34,3],[32,0,32,5],[29,2,29,3],[94,0,94,1],[99,7,99,8],[99,10,99,12],[14,3,14,5],[17,3,17,5],[158,3,158,5],[52,4,54,4],[27,0,27,5],[26,0,26,5],[25,0,25,5],[20,2,20,4],[18,2,18,3],[39,0,39,5],[18,4,18,5],[101,7,101,8],[101,10,101,12],[102,7,102,9],[99,0,99,1],[100,0,100,2],[101,0,101,1],[102,0,102,2],[16,3,16,5],[100,7,100,9],[28,2,28,3],[18,0,18,1]]}
["Documents Marathon du 06 janvier 2018 au Pouzin","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 JEU PROVENCAL"]
[]
["VERSION ","V25012018          TRIPLETTE EN POULE AU CUMUL"]
["EXEMPLE 98 EQUIPES EN POULE AU CUMUL voir chapitre Indemnites"]
["INTERNATIONAL - EVENEMENTIEL",null,null,null,"*"]
["NATIONAL",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. LIG.","Nom et Prénom","QUALITE"]
["Délégué :"]
["Arbitre :"]
["Organisateur : "]
["ADRESSE E-mail et Tél. du Délégué :"]
["Tirage au sort effectué le :",null,"En présence"]
["Date "]
[]
["OBSERVATIONS DE L'ARBITRE DELEGUE"]
["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":"C17","v":0}]
["(nom, prénom, signature",null,{"$f":"C29","v":0}]
[]
["OBSERVATIONS GENERALE DU DELEGUE"]
[]
["Le Délégué FFPJP ou LIGUE désigné :",null,{"$f":"C16","v":0}]
["(signature)",null,{"$f":"C34","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"]
[]
[]
[]
[]
[]
[]
["Finaliste"]
[]
[]
[]
["Gagnant"]
[]
[]
[]
["INDEMNITES : (article 8 du règlement des concours Internationaux et Nationaux)"]
["Dotation de l'organisation",null,null,{"$f":"C94","v":0}]
["Frais de participation"]
["Nombre d'équipes inscrites",null,null,{"$f":"C95*C96","v":0}]
["Nombre d'équipes présentes"]
[]
["TOTAL DES INDEMNITES DISTRIBUEES",null,null,{"$f":"D94+D96","v":0}]
["CUMUL AU VAINQUEUR",null,null,{"$f":"E114","v":0}]
["L’indemnité globale perçue par le vainqueur ne doit pas dépasser 25% du total des indemnités ",null,null,{"$f":"D99*E101","v":0},0.25]
["Finaliste",null,null,{"$f":"E115","v":0}]
["L’indemnité globale perçue devra être supérieure ou égale à 60 % de celle du gagnant",null,null,{"$f":"D102*E103","v":0},0.6]
["FORMULE RETENUE CR-JP-Poule-Cumul",null," Compte rendu Jeu Provençal en poule au cumul"]
["PARTIE","Nb. Équipe","Indemnité","Total"]
["Sortie poule ",null,null,{"$f":"B106*C106","v":0},{"$f":"C106","v":0},{"$f":"D99-D106","v":0}]
["1ère partie après poule ",null,null,{"$f":"B107*C107","v":0},{"$f":"E106+C107","v":0},{"$f":"F106-D107","v":0}]
["Cadrage",null,null,{"$f":"B108*C108","v":0},{"$f":"E107+C108","v":0},0]
["1/64ème ",null,null,0,{"$f":"E108+C109","v":0},0]
["1/32ème",null,null,0,{"$f":"E109-C110","v":0},0]
["1/16ème",null,null,0,{"$f":"E110+C111","v":0},0]
["1/8ème",8,null,0,{"$f":"E111+C112","v":0},0]
["1/4 de finale",4,null,0,{"$f":"E112+C113","v":0},0]
["1/2 finales",2,null,0,{"$f":"E113+C114","v":0},0]
["Finale",1,{"$f":"F114","v":0},{"$f":"C115","v":0},{"$f":"E114+C115","v":0},{"$f":"F114-C115","v":0}]
[null,"NOMBRE","MONTANT "]
["1/2 FINALE ","6 CHEQUES DE:",{"$f":"D114/6","v":0}]
["GAGNANT ","3 CHEQUES DE : ",{"$f":"C115/3","v":0}]
[]
[{"$f":"C13","v":0},null,null,null,"N°",{"$f":"E14","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":"A79","v":0},0,0,0,{"$f":"C117","v":0}]
[0,0,0,0,{"$f":"C117","v":0}]
[0,0,0,0,{"$f":"C117","v":0}]
[0,0,0,0,{"$f":"C117","v":0}]
[0,0,0,0,{"$f":"C117","v":0}]
[0,0,0,0,{"$f":"C117","v":0}]
[{"$f":"A90","v":0},0,0,0,{"$f":"C118","v":0}]
[0,0,0,0,{"$f":"C118","v":0}]
[0,0,0,0,{"$f":"C118","v":0}]
["SIGNATURE"]
[null,{"$f":"B125","v":0},{"$f":"B135","v":0},"BANQUE "]
[null,0,{"$f":"B136","v":0}]
[null,0,0]
[null,0,0]
[null,0,0]
[null,0,0]
[null,0,0]
[null,0,{"$f":"B142","v":0}]
[null,0,{"$f":"B143","v":0}]
[]
["TOTAL DES INDEMNITES ",null,{"$f":"SUM(E125:E133)","v":0}]
[]
["FAIT A :",null,null,"LE :"]
[]
["Signature de l'Organisateur ",null,{"$f":"C18","v":0}]
[]
["Signature du Délégué",null,{"$f":"C16","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.   SI POSSIBLE PAR MAIL   ffpjp.siege@petanque.fr     "]
[]
["2 / une copie au Président de la Ligue "]
["3 / une copie au Responsable de la Ligue concernée par les Nationaux."]
["4 / une copie au Président du Comité concerné. "]
["5 / une copie au Président de l'organisation. "]
[null,null,null,"Dernière mise à jour V30122015"]
[]
["CLASSIFICATION DE LA MANIFESTATION"]
["NATIONAL "]
["Comité : ",null,"Ligue :"]
["Bilan des équipes engagées"]
["Equipe(s) Non Homogène(s) :"]
["Equipe(s) de la Ligue :"]
["Equipe(s) du Comité :"]
["Joueurs de la Ligue :"]
["Joueurs du Comité :"]
["Joueurs Elite :"]
["Joueurs Honneur :"]
["Joueurs Classés :"]
["Joueurs Promotion :"]
["Joueurs Inconnus ou Etranger :"]
["Critère X (Joueurs Classés) ="]
["Critère Y (% Extérieur CD) ="]
["Critère Z (% Extérieur Ligue) ="]
[]
["Manifestation Classée Grille"]
[]
["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-JP-Poule-PP","index":4,"n_rows":191,"n_cols":6,"rows_kept":191,"cut":false,"hidden":false,"merged":[[192,4,194,4],[195,4,197,4],[198,4,200,4],[201,4,203,4],[204,4,206,4],[207,4,209,4],[228,4,230,4],[231,4,233,4],[234,4,236,4],[237,4,239,4],[241,0,241,5],[210,4,212,4],[213,4,215,4],[216,4,218,4],[219,4,221,4],[222,4,224,4],[225,4,227,4],[166,3,166,5],[188,0,188,5],[189,2,190,2],[189,4,190,4],[189,5,190,5],[191,0,191,5],[168,0,168,5],[169,0,169,5],[170,0,170,1],[170,2,170,5],[174,0,174,1],[175,0,175,1],[176,0,176,1],[183,0,183,1],[184,0,184,1],[186,0,186,5],[177,0,177,1],[178,0,178,1],[179,0,179,1],[180,0,180,1],[181,0,181,1],[182,0,182,1],[167,3,167,5],[159,0,159,1],[160,0,161,5],[162,0,162,5],[163,0,163,5],[164,0,164,5],[165,0,165,5],[171,0,171,5],[172,0,172,1],[173,0,173,1],[152,0,152,1],[154,1,154,2],[154,4,154,5],[156,0,156,1],[156,4,156,5],[158,0,158,1],[146,3,146,5],[147,3,147,5],[148,3,148,5],[149,3,149,5],[150,3,150,5],[151,3,151,5],[143,3,143,5],[144,3,144,5],[139,0,139,5],[140,3,140,5],[141,3,142,5],[145,3,145,5],[103,0,103,2],[103,7,103,9],[121,0,121,3],[122,0,122,5],[124,2,125,2],[124,4,125,4],[124,5,125,5],[100,10,100,12],[101,0,101,2],[101,7,101,9],[102,0,102,1],[102,7,102,8],[102,10,102,12],[97,0,97,1],[99,0,99,2],[99,3,99,5],[100,0,100,1],[100,7,100,8],[89,0,89,5],[93,0,93,5],[94,0,94,1],[94,3,94,5],[95,0,95,1],[96,0,96,1],[96,3,96,5],[56,4,58,4],[59,4,61,4],[62,4,64,4],[65,0,65,5],[78,0,78,5],[85,0,85,5],[40,0,40,5],[41,4,43,4],[44,4,46,4],[47,4,49,4],[50,4,52,4],[53,4,55,4],[34,0,34,1],[34,2,34,3],[35,0,35,1],[35,2,35,3],[37,0,37,5],[38,2,39,2],[38,4,39,4],[38,5,39,5],[29,0,29,1],[29,2,29,3],[30,0,30,1],[30,2,30,3],[32,0,32,5],[33,0,33,5],[26,0,26,5],[27,0,27,5],[28,0,28,5],[15,3,15,5],[16,3,16,5],[17,3,17,5],[7,0,7,5],[8,0,8,2],[9,0,9,2],[10,0,10,2],[12,0,12,1],[12,4,12,5],[0,0,2,0],[0,1,0,5],[1,1,1,5],[2,1,2,5],[4,0,4,5],[6,1,6,4],[13,1,13,3],[13,4,13,5],[14,3,14,5],[23,0,23,5],[24,0,24,2],[25,0,25,5],[18,0,18,1],[19,0,19,1],[19,2,19,4],[20,2,21,4],[18,2,18,3],[18,4,18,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 JEU PROVENCAL"]
[]
["VERSION ","V30122015            TRIPLETTE EN POULE A LA PARTIE PERDUE"]
["EXEMPLE 141 EQUIPES EN POULE A LA PARTIE PERDUEvoir chapitre Indemnites"]
["INTERNATIONAL - EVENEMENTIEL",null,null,null,"*"]
["NATIONAL",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. LIG.","Nom et Prénom","QUALITE"]
["Délégué :"]
["Arbitre :"]
["Organisateur : "]
["ADRESSE E-mail et Tél. du Délégué :"]
["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,5]
["Qualité de l’arbitrage dispensé :"]
[]
["Avis sur la qualité de l’organisation "]
[]
["L'Arbitre FFPJP désigné :",null,{"$f":"C17","v":0}]
["(nom, prénom, signature",null,{"$f":"C30","v":0}]
[]
["OBSERVATIONS GENERALE DU DELEGUE"]
[]
["Le Délégué FFPJP ou LIGUE désigné :",null,{"$f":"C16","v":0}]
["(signature)",null,{"$f":"C35","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"]
[]
[]
[]
[]
[]
[]
["Finaliste"]
[]
[]
[]
["Gagnant"]
[]
[]
[]
["INDEMNITES AU CUMUL : (article 8 du règlement des concours Internationaux et Nationaux)"]
["Dotation de l'organisation",null,null,{"$f":"C95","v":0}]
["Frais de participation"]
["Nombre d'équipes inscrites",null,null,{"$f":"C96*C97","v":0}]
["Nombre d'équipes présentes"]
[]
["TOTAL DES INDEMNITES DISTRIBUEES",null,null,{"$f":"D95+D97","v":0}]
["CUMUL AU VAINQUEUR",null,null,{"$f":"C116","v":0}]
["L’indemnité globale perçue par le vainqueur ne doit pas dépasser 25% du total des indemnités ",null,null,{"$f":"D100*E102","v":0},0.25]
["Finaliste",null,null,{"$f":"E115","v":0}]
["L’indemnité globale perçue devra être supérieure ou égale à 60 % de celle du gagnant",null,null,{"$f":"D101*E104","v":0},0.6]
["PARTIE","Nb. Équipe","Indemnité","Total"]
["Sortie poule ",null,null,{"$f":"B106*C106","v":0},{"$f":"C106","v":0},{"$f":"D100-D106","v":0}]
["1ère partie après poule ",null,null,{"$f":"B107*C107","v":0},{"$f":"E106+C107","v":0},{"$f":"F106-D107","v":0}]
["Cadrage",null,null,{"$f":"B108*C108","v":0},{"$f":"E107+C108","v":0},0]
["1/64ème ",null,null,0,{"$f":"E108+C109","v":0},0]
["1/32ème",null,null,0,{"$f":"E109-C110","v":0},0]
["1/16ème",null,null,0,{"$f":"C111","v":0},0]
["1/8ème",8,null,0,0,0]
["1/4 de finale",4,null,0,0,0]
["1/2 finales",2,null,0,0,0]
[null,1,null,0,0,{"$f":"F114-D115","v":0}]
["Finale",1,{"$f":"F115","v":0},{"$f":"C116","v":0},0,{"$f":"F115-C116","v":0}]
[null,"NOMBRE","MONTANT "]
["1/2 FINALE ","6 CHEQUES DE:",{"$f":"D114/6","v":0}]
["FINALISTE","3 CHEQUES DE : ",{"$f":"D115/3","v":0}]
["GAGNANT ","3 CHEQUES DE : ",{"$f":"C116/3","v":0}]
[]
[{"$f":"C13","v":0},null,null,null,"N°",{"$f":"E14","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":"A80","v":0},0,0,0,{"$f":"C118","v":0}]
[0,0,0,0,{"$f":"C118","v":0}]
[0,0,0,0,{"$f":"C118","v":0}]
[0,0,0,0,{"$f":"C118","v":0}]
[0,0,0,0,{"$f":"C118","v":0}]
[0,0,0,0,{"$f":"C118","v":0}]
[{"$f":"A87","v":0},0,0,0,{"$f":"C119","v":0}]
[0,0,0,0,{"$f":"C119","v":0}]
[0,0,0,0,{"$f":"C119","v":0}]
[{"$f":"A91","v":0},0,0,0,{"$f":"C120","v":0}]
[0,0,0,0,{"$f":"C120","v":0}]
[0,0,0,0,{"$f":"C120","v":0}]
[]
["SIGNATURE"]
[null,{"$f":"B127","v":0},{"$f":"B141","v":0},"BANQUE "]
[null,{"$f":"B128","v":0},{"$f":"B142","v":0}]
[null,0,0]
[null,0,0]
[null,0,0]
[null,0,0]
[null,0,0]
[null,0,0]
[null,0,0]
[null,0,0]
[null,0,{"$f":"B151","v":0}]
[null,0,{"$f":"B152","v":0}]
["TOTAL DES INDEMNITES ",null,{"$f":"SUM(E127:E135)","v":0}]
[]
["FAIT A :",null,null,"LE :"]
[]
["Signature de l'Organisateur ",null,{"$f":"C18","v":0}]
[]
["Signature du Délégué",null,{"$f":"C16","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.   SI POSSIBLE PAR MAIL   ffpjp.siege@petanque.fr     "]
[]
["2 / une copie au Président de la Ligue "]
["3 / une copie au Responsable de la Ligue concernée par les Nationaux."]
["4 / une copie au Président du Comité concerné. "]
["5 / une copie au Président de l'organisation. "]
[null,null,null,"Dernière mise à jour V30122015"]
[]
["CLASSIFICATION DE LA MANIFESTATION"]
["NATIONAL "]
["Comité : ",null,"Ligue : "]
["Bilan des équipes engagées"]
["Equipe(s) Non Homogène(s) :"]
["Equipe(s) de la Ligue :"]
["Equipe(s) du Comité :"]
["Joueurs de la Ligue :"]
["Joueurs du Comité :"]
["Joueurs Elite :"]
["Joueurs Honneur :"]
["Joueurs Classés :"]
["Joueurs Promotion :"]
["Joueurs Inconnus ou Etranger :"]
["Critère X (Joueurs Classés) ="]
["Critère Y (% Extérieur CD) ="]
["Critère Z (% Extérieur Ligue) ="]
[]
["Manifestation Classée Grille"]
[]
["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."]