{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["MENU","JP-ED-Cumul","Affiche-ED-Cumul","JP-ED- PP","Affiche -ED-Partie-Perdue","JP-Poule-au-cumul","Affiche-Poule-cum","JP-Poule-PP","Affiche-Poule-Partie-Perdue"],"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":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[10,4,10,5],[17,4,17,5],[26,4,26,5],[3,4,3,5]]}
[]
[]
[]
[null,null,null,null,"       Peu utilisé"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"          Le plus utilisé"]

{"sheet":"JP-ED-Cumul","index":1,"n_rows":37,"n_cols":11,"rows_kept":37,"cut":false,"hidden":false,"merged":[[13,0,13,5],[14,0,14,5],[0,0,0,10],[18,6,18,10],[8,0,8,9],[3,2,3,4],[18,1,18,3],[4,5,4,7],[5,0,5,1],[12,0,12,3],[11,0,11,3],[4,2,4,4],[3,5,3,7],[4,0,4,1],[6,0,6,1],[5,2,5,4],[10,0,10,3],[6,2,6,4],[6,5,6,7],[5,5,5,7],[3,0,3,1],[1,0,1,10],[2,9,2,10],[2,2,2,4],[2,0,2,1],[2,5,2,7],[28,6,28,7],[30,6,30,10],[16,0,16,9],[29,6,29,7],[30,0,30,2],[37,6,37,10],[32,6,32,7],[31,6,31,7],[33,5,33,9],[36,0,36,1]]}
["EXEMPLE AVEC 128 EQUIPES 5000 € ELIMINATION DIRECTE AU CUMUL"]
["CALCUL AUTOMATIQUE DES INDEMNITES AUX JOUEURS JEU PROVENCAL EN E. D. CUMUL  V24012018"]
["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":"I3","v":0}]
["N° NATIONAL :",null,null,null,null,"Nombre d'équipes engagées :",null,null,null,{"$f":"F11*G11","v":15},{"$f":"I5*J5","v":0}]
["LIEU :",null,null,null,null,"Nombre équipes après la 1ère partie :",null,null,{"$f":"ROUNDUP($I$5/2,0)","v":0},"Total",{"$f":"SUM(K4:K5)","v":0}]
["RESPONSABLE :"]
[]
[" I  Calcul du maximum au vainqueurs et du mininum 1/2 finale (Exemple) "]
[null,null,null,null,null,"Doub. Trip.","Part/joueur"]
["Participation",null,null,null,null,3,5,{"$f":"F11*G11","v":15}]
["Dotation ",null,null,null,null,null,{"$f":"I3","v":0},{"$f":"K5","v":0}]
["Total indemnités",null,null,null,null,null,null,{"$f":"K6","v":0}]
["REGLEMENT : Vainqueur < ou = 25% de la dotation globale ",null,null,null,null,null,0.25,{"$f":"H13*G14","v":0}]
["REGLEMENT  : Finaliste > ou = 60% de l'indemnité du vainqueur",null,null,null,null,null,0.6,{"$f":"H14*G15","v":0}]
[]
["II On informe uniquement les cellules bleutées"]
[]
[null,"Total indemnités",null,null,{"$f":"H13","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":"I6","v":0},0,{"$f":"B21*C21","v":0},{"$f":"H13-D21","v":0}]
["2ème partie",{"$f":"ROUNDUP($B$21/2,0)","v":0},null,{"$f":"B22*C22","v":0},{"$f":"E21-D22","v":0},{"$f":"C21+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},null,0,{"$f":"E22-D23","v":0},{"$f":"SUM(C22:C23)","v":0}]
["64ème",{"$f":"IF(B22-B23=128,128/2,0)","v":0},null,0,0,{"$f":"SUM(C21:C24)","v":0}]
["32ème",{"$f":"IF(B22-B23=64,32,IF(B24=64,B24/2,0))","v":0},null,0,0,{"$f":"SUM(C21:C25)","v":0}]
["16ème",{"$f":"IF(B22-B23=32,\"16\",IF(B25=32,B25/2,\"0\"))","v":"0"},null,0,0,{"$f":"SUM(C21:C26)","v":0}]
["8ème ",8,null,0,0,{"$f":"SUM(C21:C27)","v":0}]
["1/4 ",4,null,0,0,{"$f":"SUM(C21:C28)","v":0}]
["1/2",2,null,0,0,{"$f":"SUM(C21:C29)","v":0},"Les indem. Cumulé des 1/2",null,{"$f":"F29","v":0},"> ou =",{"$f":"I30*G15","v":0}]
["Finale",1,{"$f":"E29","v":0},0,0,{"$f":"SUM(C21:C30)","v":0},"L'indem. du vainqueur cumulé",null,{"$f":"F30","v":0},"< ou =",{"$f":"H14","v":0}]
[{"$f":"IF(C30<C29,\"Indem.Finale doit être > indem. Finaliste\",\"\")","v":""},null,null,{"$f":"SUM(D21:D30)","v":0},null,{"$f":"IF(I29>=K29,IF(I30<=K30,1,0),0)","v":1},{"$f":"IF(F31=1,\"La répartition est correcte\",\"La répartition est incorrecte\")","v":"La répartition est correcte"}]
[null,null,"Nombre","Montant",null,null,"Prix du vainqueur",null,{"$f":"I30","v":0},{"$f":"I32/D31","v":{"$error":"#DIV/0!"}}]
["Chèque ","1/2 finale",6,{"$f":"D29/6","v":0},null,null,"Prix des 1/2 finale",null,{"$f":"I29","v":0},{"$f":"I33/I32","v":{"$error":"#DIV/0!"}}]
["Chèque ","Finale",3,{"$f":"D30/3","v":0},null,"ATTENTION ! Faire une correction : si message"]
[null,null,null,null,null,"Indemnités de la Finale doit être > indemnités du Finaliste "]
[]
["Mis  à jour 22/02/2018"]

{"sheet":"Affiche-ED-Cumul","index":2,"n_rows":26,"n_cols":5,"rows_kept":26,"cut":false,"hidden":false,"merged":[[0,0,0,4],[1,3,3,4],[5,3,7,4],[8,1,8,2],[9,1,9,2],[9,3,9,4],[11,0,11,4],[1,1,1,2],[2,1,2,2],[3,1,3,2],[4,1,4,2]]}
["INDEMNITES DES JOUEURS AU  JEU PROVENCAL EN E. D. CUMUL"]
["DELEGUE",{"$f":"'JP-ED-Cumul'!C3","v":0},null,"Le montant de l'indemnité globale perçue par le vainqueur ne devra pas dépasser 25% du total des indemnités distribuées.                                                                       "]
["N° INTERNATIONAL :",{"$f":"'JP-ED-Cumul'!C4","v":0}]
["N° NATIONAL :",{"$f":"'JP-ED-Cumul'!C5","v":0}]
["LIEU :",{"$f":"'JP-ED-Cumul'!C6","v":0},null,"Inférieure à :",{"$f":"'JP-ED-Cumul'!K30","v":0}]
[null,null,null,"Le montant de l'indemnité globale perçue par le finaliste devra être supérieure ou égale à 60% de celui du gagnant  "]
["INSCRITS","Inscription","Total"]
[{"$f":"'JP-ED-Cumul'!I5","v":0},{"$f":"'JP-ED-Cumul'!J5","v":15},{"$f":"'JP-ED-Cumul'!K5","v":0}]
["DOTATION ",{"$f":"'JP-ED-Cumul'!K4","v":0},null,"Supérieure à :",{"$f":"'JP-ED-Cumul'!K29","v":0}]
["TOTAL INDEMNITES ",{"$f":"'JP-ED-Cumul'!K6","v":0}]
[]
["REPARTITION DES INDEMNITES "]
["PARTIES ","Equipes indemnisées","Indemnités par équipe","Total ","Indemnités cumulées"]
[{"$f":"'JP-ED-Cumul'!A21","v":"1ère partie"},{"$f":"'JP-ED-Cumul'!B21","v":0},{"$f":"'JP-ED-Cumul'!C21","v":0},{"$f":"'JP-ED-Cumul'!D21","v":0},{"$f":"'JP-ED-Cumul'!F21","v":0}]
[{"$f":"'JP-ED-Cumul'!A22","v":"2ème partie"},{"$f":"'JP-ED-Cumul'!B22","v":0},{"$f":"'JP-ED-Cumul'!C22","v":0},{"$f":"'JP-ED-Cumul'!D22","v":0},{"$f":"'JP-ED-Cumul'!F22","v":0}]
[{"$f":"'JP-ED-Cumul'!A23","v":"cadrage "},{"$f":"'JP-ED-Cumul'!B23","v":0},{"$f":"'JP-ED-Cumul'!C23","v":0},{"$f":"'JP-ED-Cumul'!D23","v":0},{"$f":"'JP-ED-Cumul'!F23","v":0}]
[{"$f":"'JP-ED-Cumul'!A24","v":"64ème"},{"$f":"'JP-ED-Cumul'!B24","v":0},{"$f":"'JP-ED-Cumul'!C24","v":0},{"$f":"'JP-ED-Cumul'!D24","v":0},{"$f":"'JP-ED-Cumul'!F24","v":0}]
[{"$f":"'JP-ED-Cumul'!A25","v":"32ème"},{"$f":"'JP-ED-Cumul'!B25","v":0},{"$f":"'JP-ED-Cumul'!C25","v":0},{"$f":"'JP-ED-Cumul'!D25","v":0},{"$f":"'JP-ED-Cumul'!F25","v":0}]
[{"$f":"'JP-ED-Cumul'!A26","v":"16ème"},{"$f":"'JP-ED-Cumul'!B26","v":"0"},{"$f":"'JP-ED-Cumul'!C26","v":0},{"$f":"'JP-ED-Cumul'!D26","v":0},{"$f":"'JP-ED-Cumul'!F26","v":0}]
[{"$f":"'JP-ED-Cumul'!A27","v":"8ème "},{"$f":"'JP-ED-Cumul'!B27","v":8},{"$f":"'JP-ED-Cumul'!C27","v":0},{"$f":"'JP-ED-Cumul'!D27","v":0},{"$f":"'JP-ED-Cumul'!F27","v":0}]
[{"$f":"'JP-ED-Cumul'!A28","v":"1/4 "},{"$f":"'JP-ED-Cumul'!B28","v":4},{"$f":"'JP-ED-Cumul'!C28","v":0},{"$f":"'JP-ED-Cumul'!D28","v":0},{"$f":"'JP-ED-Cumul'!F28","v":0}]
[{"$f":"'JP-ED-Cumul'!A29","v":"1/2"},{"$f":"'JP-ED-Cumul'!B29","v":2},{"$f":"'JP-ED-Cumul'!C29","v":0},{"$f":"'JP-ED-Cumul'!D29","v":0},{"$f":"'JP-ED-Cumul'!F29","v":0}]
[{"$f":"'JP-ED-Cumul'!A30","v":"Finale"},{"$f":"'JP-ED-Cumul'!B30","v":1},{"$f":"'JP-ED-Cumul'!C30","v":0},{"$f":"'JP-ED-Cumul'!D30","v":0},{"$f":"'JP-ED-Cumul'!F30","v":0}]
[null,null,null,null,8]
["6 CHEQUES ","1/2 FINALE ",{"$f":"'JP-ED-Cumul'!D33","v":0},null,12]
["3 CHEQUES ","GAGNANT",{"$f":"'JP-ED-Cumul'!D34","v":0}]

{"sheet":"JP-ED- PP","index":3,"n_rows":38,"n_cols":11,"rows_kept":38,"cut":false,"hidden":false,"merged":[[31,0,31,2],[31,6,31,10],[18,6,18,10],[4,2,4,4],[4,5,4,7],[5,0,5,1],[5,2,5,4],[5,5,5,7],[11,0,11,3],[4,0,4,1],[6,5,6,7],[30,6,30,7],[29,6,29,7],[12,0,12,3],[28,6,28,7],[16,0,16,9],[18,1,18,3],[14,0,14,5],[13,0,13,5],[0,0,0,10],[8,0,8,9],[10,0,10,3],[3,0,3,1],[3,2,3,4],[3,5,3,7],[1,0,1,10],[2,0,2,1],[2,2,2,4],[2,5,2,7],[2,9,2,10],[6,0,6,1],[6,2,6,4],[35,6,35,11],[32,6,32,7],[33,6,33,7],[37,0,37,1],[34,6,34,10]]}
["EXEMPLE AVEC 128 EQUIPES 5000 € ELIMINATION DIRECTE A LA PARTIE PERDUE"]
["CALCUL AUTOMATIQUE DES INDEMNITES AUX JOUEURS JEU PROVENCAL EN E. D. PARTIE PERDUE  V24012018"]
["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":"I3","v":0}]
["N° NATIONAL :",null,null,null,null,"Nombre d'équipes engagées :",null,null,null,{"$f":"F11*G11","v":15},{"$f":"I5*J5","v":0}]
["LIEU :",null,null,null,null,"Nombre équipes en sortie de poule",null,null,{"$f":"ROUNDUP($I$5/2,0)","v":0},"Total",{"$f":"SUM(K4:K5)","v":0}]
["RESPONSABLE :",null,null,null,null,null,null,null,{"$f":"I5/4","v":0}]
[]
[" I  Calcul du maximum au vainqueurs et du minium 1/2 finale (Exemple) "]
[null,null,null,null,null,"Doub. Trip.","Part/joueur"]
["Participation",null,null,null,null,3,5,{"$f":"F11*G11","v":15}]
["Dotation ",null,null,null,null,null,{"$f":"I3","v":0},{"$f":"K5","v":0}]
["Total indemnités",null,null,null,null,null,null,{"$f":"K6","v":0}]
["REGLEMENT : Vainqueur < ou = 25% de la dotation globale ",null,null,null,null,null,0.25,{"$f":"H13*G14","v":0}]
["REGLEMENT  : Finaliste > ou = 60% de l'indemnité du vainqueur",null,null,null,null,null,0.6,{"$f":"H14*G15","v":0}]
[]
["II On informe uniquement les cellules bleutées"]
[]
[null,"Total indemnités",null,null,{"$f":"H13","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":"I6","v":0},null,{"$f":"B21*C21","v":0},{"$f":"H13-D21","v":0},0]
["2ème partie",{"$f":"ROUNDUP($B$21/2,0)","v":0},null,{"$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},null,0,{"$f":"E22-D23","v":0},{"$f":"C22+C23","v":0}]
["64ème",{"$f":"IF(B22-B23=128,128/2,0)","v":0},null,0,0,{"$f":"C24","v":0}]
["32ème",{"$f":"IF(B22-B23=64,32,IF(B24=64,B24/2,0))","v":0},null,0,0,0]
["16ème",{"$f":"IF(B22-B23=32,\"16\",IF(B25=32,B25/2,\"0\"))","v":"0"},null,0,0,0]
["8ème ",8,null,0,0,0]
["1/4 ",4,null,0,0,0]
["1/2",2,null,0,0,0]
["Finaliste",1,null,{"$f":"B30*C30","v":0},{"$f":"E29-D30","v":0},0,"l'indemnité du finaliste",null,{"$f":"D30","v":0},"> ou =",{"$f":"I31*G15","v":0}]
["Finale",1,{"$f":"E30","v":0},0,{"$f":"E30-D31","v":0},0,"L'indem. du vainqueur ",null,{"$f":"F31","v":0},"< ou =",{"$f":"H14","v":0}]
[{"$f":"IF(C31<C30,\"Indem.Finale doit être > indem. Finaliste\",\"\")","v":""},null,null,{"$f":"SUM(D21:D31)","v":0},null,{"$f":"IF(I30>=K30,IF(I31<=K31,1,0),0)","v":1},{"$f":"IF(F32=1,\"La répartition est correcte\",\"La répartition est incorrecte\")","v":"La répartition est correcte"}]
[null,null,"Nombre","Montant",null,null,"Prix du vainqueur",null,{"$f":"E30","v":0},{"$f":"I33/D32","v":{"$error":"#DIV/0!"}}]
["Chèque ","1/2 finale",6,{"$f":"D29/6","v":0},null,null,"Prix du finaliste",null,{"$f":"D30","v":0},{"$f":"I34/I33","v":{"$error":"#DIV/0!"}}]
["Chèque ","Finaliste",3,{"$f":"D30/3","v":0},null,null,"ATTENTION ! Faire une correction : si message"]
["Chèque ","Finale",3,{"$f":"D31/3","v":0},null,null,"Indemnités de la Finale doit être > indemnités du Finaliste "]
[]
[{"$f":"'JP-ED-Cumul'!A37:B37","v":"Mis  à jour 22/02/2018"}]

{"sheet":"Affiche -ED-Partie-Perdue","index":4,"n_rows":28,"n_cols":5,"rows_kept":28,"cut":false,"hidden":false,"merged":[[0,0,0,4],[1,1,1,2],[2,1,2,2],[3,1,3,2],[1,3,4,4],[8,1,8,2],[9,1,9,2],[11,0,11,4],[7,3,7,4],[4,1,4,2],[6,3,6,4]]}
["INDEMNITES AUX JOUEURS JEU PROVENCAL EN ELIMINATION DIRECTE PART. PERD. "]
["DELEGUE",{"$f":"'JP-ED- PP'!C3","v":0}]
["N° INTERNATIONAL :",{"$f":"'JP-ED- PP'!C4","v":0}]
["N° NATIONAL :",{"$f":"'JP-ED- PP'!C5","v":0}]
["LIEU :",{"$f":"'JP-ED- PP'!C6","v":0}]
[]
["INSCRITS","Inscription","Total","REGLEMENT : Vainqueur < ou = 25% de la dotation globale "]
[{"$f":"'JP-ED- PP'!I5","v":0},{"$f":"'JP-ED- PP'!J5","v":15},{"$f":"'JP-ED- PP'!K5","v":0},"REGLEMENT  : Finaliste > ou = 60% de l'indemnité du vainqueur"]
["DOTATION ",{"$f":"'JP-ED- PP'!K4","v":0},null,"Finaliste ",{"$f":"C23/C24","v":{"$error":"#DIV/0!"}}]
["TOTAL INDEMNITES ",{"$f":"'JP-ED- PP'!K6","v":0},null,"Vainqueur",{"$f":"C24/B10","v":{"$error":"#DIV/0!"}}]
[]
["REPARTITION DES INDEMNITES "]
["PARTIES ","Equipes indemnisées","Indemnités par équipe","Total ","Indemnité par partie"]
[{"$f":"'JP-ED- PP'!A21","v":"1ère partie"},{"$f":"'JP-ED- PP'!B21","v":0},{"$f":"'JP-ED- PP'!C21","v":0},{"$f":"'JP-ED- PP'!D21","v":0},{"$f":"'JP-ED- PP'!F21","v":0}]
[{"$f":"'JP-ED- PP'!A22","v":"2ème partie"},{"$f":"'JP-ED- PP'!B22","v":0},{"$f":"'JP-ED- PP'!C22","v":0},{"$f":"'JP-ED- PP'!D22","v":0},{"$f":"'JP-ED- PP'!F22","v":0}]
[{"$f":"'JP-ED- PP'!A23","v":"cadrage "},{"$f":"'JP-ED- PP'!B23","v":0},{"$f":"'JP-ED- PP'!C23","v":0},{"$f":"'JP-ED- PP'!D23","v":0},{"$f":"'JP-ED- PP'!F23","v":0}]
[{"$f":"'JP-ED- PP'!A24","v":"64ème"},{"$f":"'JP-ED- PP'!B24","v":0},{"$f":"'JP-ED- PP'!C24","v":0},{"$f":"'JP-ED- PP'!D24","v":0},{"$f":"'JP-ED- PP'!F24","v":0}]
[{"$f":"'JP-ED- PP'!A25","v":"32ème"},{"$f":"'JP-ED- PP'!B25","v":0},{"$f":"'JP-ED- PP'!C25","v":0},{"$f":"'JP-ED- PP'!D25","v":0},{"$f":"'JP-ED- PP'!F25","v":0}]
[{"$f":"'JP-ED- PP'!A26","v":"16ème"},{"$f":"'JP-ED- PP'!B26","v":"0"},{"$f":"'JP-ED- PP'!C26","v":0},{"$f":"'JP-ED- PP'!D26","v":0},{"$f":"'JP-ED- PP'!F26","v":0}]
[{"$f":"'JP-ED- PP'!A27","v":"8ème "},{"$f":"'JP-ED- PP'!B27","v":8},{"$f":"'JP-ED- PP'!C27","v":0},{"$f":"'JP-ED- PP'!D27","v":0},{"$f":"'JP-ED- PP'!F27","v":0}]
[{"$f":"'JP-ED- PP'!A28","v":"1/4 "},{"$f":"'JP-ED- PP'!B28","v":4},{"$f":"'JP-ED- PP'!C28","v":0},{"$f":"'JP-ED- PP'!D28","v":0},{"$f":"'JP-ED- PP'!F28","v":0}]
[{"$f":"'JP-ED- PP'!A29","v":"1/2"},{"$f":"'JP-ED- PP'!B29","v":2},{"$f":"'JP-ED- PP'!C29","v":0},{"$f":"'JP-ED- PP'!D29","v":0},{"$f":"'JP-ED- PP'!F29","v":0}]
[{"$f":"'JP-ED- PP'!A30","v":"Finaliste"},{"$f":"'JP-ED- PP'!B30","v":1},{"$f":"'JP-ED- PP'!C30","v":0},{"$f":"'JP-ED- PP'!D30","v":0},{"$f":"'JP-ED- PP'!F30","v":0}]
[{"$f":"'JP-ED- PP'!A31","v":"Finale"},{"$f":"'JP-ED- PP'!B31","v":1},{"$f":"'JP-ED- PP'!C31","v":0},{"$f":"'JP-ED- PP'!D31","v":0},{"$f":"'JP-ED- PP'!F31","v":0}]
[null,null,null,null,8]
["6 CHEQUES ","1/2 FINALE ",{"$f":"'JP-ED- PP'!D34","v":0},null,12]
["3 CHEQUES ","FINALISTE",{"$f":"'JP-ED- PP'!D35","v":0}]
["3 CHEQUES ","GAGNANT",{"$f":"'JP-ED- PP'!D36","v":0}]

{"sheet":"JP-Poule-au-cumul","index":5,"n_rows":38,"n_cols":13,"rows_kept":38,"cut":false,"hidden":false,"merged":[[30,0,30,2],[30,6,30,10],[31,6,31,10],[29,6,29,7],[10,0,10,3],[12,0,12,3],[16,0,16,9],[18,1,18,3],[28,6,28,7],[13,0,13,4],[5,2,5,4],[1,0,1,10],[2,0,2,1],[2,2,2,4],[2,5,2,7],[2,9,2,10],[3,0,3,1],[3,2,3,4],[35,0,35,1],[32,6,32,10],[33,6,33,10],[3,5,3,7],[0,0,0,10],[6,0,6,1],[6,2,6,4],[6,5,6,7],[8,0,8,9],[4,0,4,1],[4,2,4,4],[4,5,4,7],[5,0,5,1],[14,0,14,4],[11,0,11,3],[5,5,5,7]]}
[]
["CALCUL AUTOMATIQUE DES INDEMNITES AUX JOUEURS JEU PROVENCAL EN POULE CUMUL   V30122015"]
["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":"I3","v":0}]
["N° NATIONAL",null,null,null,null,"Nombre d'équipes engagées :",null,null,null,{"$f":"F11*G11","v":15},{"$f":"I5*J5","v":0}]
["LIEU",null,null,null,null,"Nombre équipes en sortie de poule",null,null,{"$f":"ROUNDUP($I$5/2,0)","v":0},"Total",{"$f":"SUM(K4:K5)","v":0}]
["RESPONSABLE",null,null,null,null,null,null,null,{"$f":"I5/4","v":0}]
[]
[" I  Calcul du maximum au vainqueurs et du mininum 1/2 finale (Exemple) "]
[null,null,null,null,null,"Doub. Trip.","Part/joueur"]
["Participation",null,null,null,null,3,5,{"$f":"F11*G11","v":15}]
["Dotation ",null,null,null,null,null,{"$f":"I3","v":0},{"$f":"K5","v":0}]
["Total indemnités",null,null,null,null,null,null,{"$f":"K6","v":0}]
["Montant des indem. maxi du vainqueur 25 % du total des indemnités",null,null,null,null,0.25,0.25,{"$f":"H13*G14","v":0}]
["Montant des indem. des 1/2 doit être = ou supèrieur 60 % de indemnité percue par le vainqueur",null,null,null,null,0.6,0.6,{"$f":"H14*G15","v":0}]
[]
["II On informe uniquement les cellules grisées  "]
[]
[null,"Total indemnités",null,null,{"$f":"H13","v":0}]
[null,"Equipes indemnisés","Indemnités par équipe","Cumul par partie","Reste indemnités à répartir","Cumulé"]
["Sortie de poule",{"$f":"I6","v":0},null,{"$f":"B21*C21","v":0},{"$f":"E19-D21","v":0},{"$f":"C21","v":0}]
["1ére partie après poule",{"$f":"ROUNDUP($B$21/2,0)","v":0},null,{"$f":"B22*C22","v":0},{"$f":"E21-D22","v":0},{"$f":"F21+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},null,0,0,{"$f":"F22+C23","v":0}]
["64ème",{"$f":"IF(B22-B23=128,128/2,0)","v":0},null,0,0,{"$f":"F23+C24","v":0}]
["32ème",{"$f":"IF(B22-B23=64,32,IF(B24=64,B24/2,0))","v":0},null,0,0,0]
["16ème",{"$f":"IF(B22-B23=32,\"16\",IF(B25=32,B25/2,\"0\"))","v":"0"},null,0,0,0]
["8ème ",8,null,0,0,0]
["1/4 ",4,null,0,0,0]
["1/2",2,null,0,0,0,"Les indem. cumulés des 1/2",null,{"$f":"F29","v":0},"> ou =",{"$f":"I30*G15","v":0}]
["Finale",1,{"$f":"E29","v":0},0,0,0,"L'indem. du vainqueur cumulé",null,{"$f":"F30","v":0},"< ou =",{"$f":"H14","v":0}]
[{"$f":"IF(C30<C29,\"Indem.Finale doit être > indem. Finaliste\",\"\")","v":""},null,null,{"$f":"SUM(D21:D30)","v":0},null,{"$f":"IF(I29>=K29,IF(I30<=K30,1,0),0)","v":1},{"$f":"IF(F31=1,\"La répartition est correcte\",\"La répartition est incorrecte\")","v":"La répartition est correcte"}]
[null,null,"Nombre","Montant",null,null,{"$f":"A31","v":""}]
["Chéque ","1/2 finale",6,{"$f":"D29/6","v":0},null,null,"ATTENTION ! Faire une correction : si message"]
["Chéque ","Finale",3,{"$f":"D30/3","v":0},null,null,"Indemnités de la Finale doit être > indemnités du Finaliste "]
[]
[{"$f":"'JP-ED-Cumul'!A37:B37","v":"Mis  à jour 22/02/2018"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"ç+"]

{"sheet":"Affiche-Poule-cum","index":6,"n_rows":26,"n_cols":5,"rows_kept":26,"cut":false,"hidden":false,"merged":[[0,0,0,4],[1,1,1,2],[1,3,3,4],[2,1,2,2],[3,1,3,2],[8,1,8,2],[9,1,9,2],[9,3,9,4],[11,0,11,4],[4,1,4,2],[5,3,7,4]]}
["INDEMNITES AUX JOUEURS JEU PROVENCAL EN POULE CUMUL"]
["DELEGUE",{"$f":"'JP-Poule-au-cumul'!C3","v":0},null,"Le montant de l'indemnité globale percue par le vainqueur ne devra pas dépasser 25% du total des indemnités distribuées.                                                                       "]
["N° INTERNATIONAL :",{"$f":"'JP-Poule-au-cumul'!C4","v":0}]
["N° NATIONAL :",{"$f":"'JP-Poule-au-cumul'!C5","v":0}]
["LIEU :",{"$f":"'JP-Poule-au-cumul'!C6","v":0},null,"Inférieure à :",{"$f":"'JP-Poule-au-cumul'!K30","v":0}]
[null,null,null,"Le montant de l'indemnité globale percue par le finaliste devra être supérieure ou égale à 60% de celui du gagnant  "]
["INSCRITS","Inscription","Total"]
[{"$f":"'JP-Poule-au-cumul'!I5","v":0},{"$f":"'JP-Poule-au-cumul'!J5","v":15},{"$f":"'JP-Poule-au-cumul'!K5","v":0}]
["DOTATION ",{"$f":"'JP-Poule-au-cumul'!K4","v":0},null,"Supérieure à :",{"$f":"'JP-Poule-au-cumul'!K29","v":0}]
["TOTAL INDEMNITES ",{"$f":"'JP-Poule-au-cumul'!K6","v":0}]
[]
["REPARTITION DES INDEMNITES "]
["PARTIES ","Equipes indemnisées","Indemnités par équipe","Total ","Indemnités cumulées "]
[{"$f":"'JP-Poule-au-cumul'!A21","v":"Sortie de poule"},{"$f":"'JP-Poule-au-cumul'!B21","v":0},{"$f":"'JP-Poule-au-cumul'!C21","v":0},{"$f":"'JP-Poule-au-cumul'!D21","v":0},{"$f":"'JP-Poule-au-cumul'!F21","v":0}]
[{"$f":"'JP-Poule-au-cumul'!A22","v":"1ére partie après poule"},{"$f":"'JP-Poule-au-cumul'!B22","v":0},{"$f":"'JP-Poule-au-cumul'!C22","v":0},{"$f":"'JP-Poule-au-cumul'!D22","v":0},{"$f":"'JP-Poule-au-cumul'!F22","v":0}]
[{"$f":"'JP-Poule-au-cumul'!A23","v":"cadrage "},{"$f":"'JP-Poule-au-cumul'!B23","v":0},{"$f":"'JP-Poule-au-cumul'!C23","v":0},{"$f":"'JP-Poule-au-cumul'!D23","v":0},{"$f":"'JP-Poule-au-cumul'!F23","v":0}]
[{"$f":"'JP-Poule-au-cumul'!A24","v":"64ème"},{"$f":"'JP-Poule-au-cumul'!B24","v":0},{"$f":"'JP-Poule-au-cumul'!C24","v":0},{"$f":"'JP-Poule-au-cumul'!D24","v":0},{"$f":"'JP-Poule-au-cumul'!F24","v":0}]
[{"$f":"'JP-Poule-au-cumul'!A25","v":"32ème"},{"$f":"'JP-Poule-au-cumul'!B25","v":0},{"$f":"'JP-Poule-au-cumul'!C25","v":0},{"$f":"'JP-Poule-au-cumul'!D25","v":0},{"$f":"'JP-Poule-au-cumul'!F25","v":0}]
[{"$f":"'JP-Poule-au-cumul'!A26","v":"16ème"},{"$f":"'JP-Poule-au-cumul'!B26","v":"0"},{"$f":"'JP-Poule-au-cumul'!C26","v":0},{"$f":"'JP-Poule-au-cumul'!D26","v":0},{"$f":"'JP-Poule-au-cumul'!F26","v":0}]
[{"$f":"'JP-Poule-au-cumul'!A27","v":"8ème "},{"$f":"'JP-Poule-au-cumul'!B27","v":8},{"$f":"'JP-Poule-au-cumul'!C27","v":0},{"$f":"'JP-Poule-au-cumul'!D27","v":0},{"$f":"'JP-Poule-au-cumul'!F27","v":0}]
[{"$f":"'JP-Poule-au-cumul'!A28","v":"1/4 "},{"$f":"'JP-Poule-au-cumul'!B28","v":4},{"$f":"'JP-Poule-au-cumul'!C28","v":0},{"$f":"'JP-Poule-au-cumul'!D28","v":0},{"$f":"'JP-Poule-au-cumul'!F28","v":0}]
[{"$f":"'JP-Poule-au-cumul'!A29","v":"1/2"},{"$f":"'JP-Poule-au-cumul'!B29","v":2},{"$f":"'JP-Poule-au-cumul'!C29","v":0},{"$f":"'JP-Poule-au-cumul'!D29","v":0},{"$f":"'JP-Poule-au-cumul'!F29","v":0}]
[{"$f":"'JP-Poule-au-cumul'!A30","v":"Finale"},{"$f":"'JP-Poule-au-cumul'!B30","v":1},{"$f":"'JP-Poule-au-cumul'!C30","v":0},{"$f":"'JP-Poule-au-cumul'!D30","v":0},{"$f":"'JP-Poule-au-cumul'!F30","v":0}]
[null,null,null,null,8]
["6 CHEQUES ","1/2 FINALE ",{"$f":"'JP-Poule-au-cumul'!D33","v":0},null,12]
["3 CHEQUES ","GAGNANT",{"$f":"'JP-Poule-au-cumul'!D34","v":0}]

{"sheet":"JP-Poule-PP","index":7,"n_rows":38,"n_cols":11,"rows_kept":38,"cut":false,"hidden":false,"merged":[[32,6,32,10],[16,0,16,9],[18,1,18,3],[18,6,18,10],[28,6,28,7],[29,6,29,7],[30,6,30,7],[31,0,31,2],[3,0,3,1],[3,5,3,7],[4,0,4,1],[4,5,4,7],[3,2,3,4],[4,2,4,4],[0,0,0,10],[1,0,1,10],[2,0,2,1],[2,5,2,7],[2,9,2,10],[2,2,2,4],[37,0,37,1],[33,6,33,10],[34,6,34,10],[5,0,5,1],[5,5,5,7],[6,0,6,1],[6,5,6,7],[5,2,5,4],[6,2,6,4],[8,0,8,9],[10,0,10,3],[11,0,11,3],[12,0,12,3],[13,0,13,4],[14,0,14,4],[31,6,31,10]]}
[]
["CALCUL AUTOMATIQUE DES INDEMNITES AUX JOUEURS JEU PROVENCAL EN POULE PARTIE PERDUE  V30122015"]
["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":"I3","v":0}]
["N° NATIONAL :",null,null,null,null,"Nombre d'équipes engagées :",null,null,null,{"$f":"F11*G11","v":15},{"$f":"I5*J5","v":0}]
["LIEU :",null,null,null,null,"Nombre équipes en sortie de poule",null,null,{"$f":"ROUNDUP($I$5/2,0)","v":0},"Total",{"$f":"SUM(K4:K5)","v":0}]
["RESPONSABLE :",null,null,null,null,null,null,null,{"$f":"I5/4","v":0}]
[]
[" I  Calcul du maximum au vainqueurs et du minium 1/2 finale (Exemple) "]
[null,null,null,null,null,"Doub. Trip.","Part/joueur"]
["Participation",null,null,null,null,3,5,{"$f":"F11*G11","v":15}]
["Dotation ",null,null,null,null,null,{"$f":"I3","v":0},{"$f":"K5","v":0}]
["Total indemnités",null,null,null,null,null,null,{"$f":"K6","v":0}]
["Montant des indem. maxi du vainqueur 25 % du total des indemnités",null,null,null,null,0.25,0.25,{"$f":"H13*G14","v":0}]
["Montant des indem. des 1/2 doit être = ou supérieur 60 % de indemnité perçue par le vainqueur",null,null,null,null,0.6,0.6,{"$f":"H14*G15","v":0}]
[]
["II On informe uniquement les cellules bleutées"]
[]
[null,"Total indemnités",null,null,{"$f":"H13","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"]
["Sortie de poule",{"$f":"I6","v":0},null,{"$f":"B21*C21","v":0},{"$f":"H13-D21","v":0},0]
["1ère Partie",{"$f":"ROUNDUP($B$21/2,0)","v":0},null,{"$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},null,0,{"$f":"E22-D23","v":0},{"$f":"C22+C23","v":0}]
["64ème",{"$f":"IF(B22-B23=128,128/2,0)","v":0},null,0,0,{"$f":"C24","v":0}]
["32ème",{"$f":"IF(B22-B23=64,32,IF(B24=64,B24/2,0))","v":0},null,0,0,0]
["16ème",{"$f":"IF(B22-B23=32,\"16\",IF(B25=32,B25/2,\"0\"))","v":"0"},null,0,0,0]
["8ème ",8,null,0,0,0]
["1/4 ",4,null,0,0,0]
["1/2",2,null,0,0,0]
["Finaliste",1,null,{"$f":"B30*C30","v":0},{"$f":"E29-D30","v":0},0,"l'indemnité du finaliste",null,{"$f":"D30","v":0},"> ou =",{"$f":"I31*G15","v":0}]
["Finale",1,{"$f":"E30","v":0},0,{"$f":"E30-D31","v":0},0,"L'indem. du vainqueur ",null,{"$f":"F31","v":0},"< ou =",{"$f":"H14","v":0}]
[{"$f":"IF(C31<C30,\"Indem.Finale doit être > indem. Finaliste\",\"\")","v":""},null,null,{"$f":"SUM(D21:D31)","v":0},null,{"$f":"IF(I30>=K30,IF(I31<=K31,1,0),0)","v":1},{"$f":"IF(F32=1,\"La répartition est correcte\",\"La répartition est incorrecte\")","v":"La répartition est correcte"}]
[null,null,"Nombre","Montant",null,null,{"$f":"A32","v":""}]
["Chèque ","1/2 finale",6,{"$f":"D29/6","v":0},null,null,"ATTENTION ! Faire une correction : si message"]
["Chèque ","Finaliste",3,{"$f":"D30/3","v":0},null,null,"Indemnités de la Finale doit être > indemnités du Finaliste "]
["Chèque ","Finale",3,{"$f":"D31/3","v":0}]
[]
["Mis  à jour 30/12/2015"]

{"sheet":"Affiche-Poule-Partie-Perdue","index":8,"n_rows":28,"n_cols":5,"rows_kept":28,"cut":false,"hidden":false,"merged":[[11,0,11,4],[0,0,0,4],[1,1,1,2],[1,3,3,4],[2,1,2,2],[3,1,3,2],[4,1,4,2],[5,3,7,4],[8,1,8,2],[9,1,9,2],[9,3,9,4]]}
["CALCUL AUTOMATIQUE DES INDEMNITES AUX JOUEURS JEU PROVENCAL EN POULE PARTIE PERDUE"]
["DELEGUE",{"$f":"'JP-Poule-PP'!C3","v":0},null,"Le montant de l'indemnité globale percue par le vainqueur ne drevra pas dépasser 25% du total des indemnités distribuées.                                                                       "]
["N° INTERNATIONAL :",{"$f":"'JP-Poule-PP'!C4","v":0}]
["N° NATIONAL :",{"$f":"'JP-Poule-PP'!C5","v":0}]
["LIEU :",{"$f":"'JP-Poule-PP'!C6","v":0},null,"Inférieure à :",{"$f":"'JP-Poule-PP'!K31","v":0}]
[null,null,null,"Le montant de l'indemnité globale percue par le finaliste devra être supérieure ou égale à 60% de celui du gagnant  "]
["INSCRITS","Inscription","Total"]
[{"$f":"'JP-Poule-PP'!I5","v":0},{"$f":"'JP-Poule-PP'!J5","v":15},{"$f":"'JP-Poule-PP'!K5","v":0}]
["DOTATION ",{"$f":"'JP-Poule-PP'!I3","v":0},null,"Supérieure à :",{"$f":"'JP-Poule-PP'!K30","v":0}]
["TOTAL INDEMNITES ",{"$f":"'JP-Poule-PP'!K6","v":0}]
[]
["REPARTITION DES INDEMNITES "]
["PARTIES ","Equipes indemnisées","Indemnités par équipe","Total ","Indemnité par partie"]
[{"$f":"'JP-ED- PP'!A21","v":"1ère partie"},{"$f":"'JP-Poule-PP'!B21","v":0},{"$f":"'JP-Poule-PP'!C21","v":0},{"$f":"B14*C14","v":0},{"$f":"C14","v":0}]
[{"$f":"'JP-ED- PP'!A22","v":"2ème partie"},{"$f":"'JP-Poule-PP'!B22","v":0},{"$f":"'JP-Poule-PP'!C22","v":0},{"$f":"B15*C15","v":0},{"$f":"C15","v":0}]
[{"$f":"'JP-ED- PP'!A23","v":"cadrage "},{"$f":"'JP-Poule-PP'!B23","v":0},{"$f":"'JP-Poule-PP'!C23","v":0},0,0]
[{"$f":"'JP-ED- PP'!A24","v":"64ème"},{"$f":"'JP-Poule-PP'!B24","v":0},{"$f":"'JP-Poule-PP'!C24","v":0},0,0]
[{"$f":"'JP-ED- PP'!A25","v":"32ème"},{"$f":"'JP-Poule-PP'!B25","v":0},{"$f":"'JP-Poule-PP'!C25","v":0},0,0]
[{"$f":"'JP-ED- PP'!A26","v":"16ème"},{"$f":"'JP-Poule-PP'!B26","v":"0"},{"$f":"'JP-Poule-PP'!C26","v":0},0,0]
[{"$f":"'JP-ED- PP'!A27","v":"8ème "},{"$f":"'JP-Poule-PP'!B27","v":8},{"$f":"'JP-Poule-PP'!C27","v":0},0,0]
[{"$f":"'JP-ED- PP'!A28","v":"1/4 "},{"$f":"'JP-Poule-PP'!B28","v":4},{"$f":"'JP-Poule-PP'!C28","v":0},0,0]
[{"$f":"'JP-ED- PP'!A29","v":"1/2"},{"$f":"'JP-Poule-PP'!B29","v":2},{"$f":"'JP-Poule-PP'!C29","v":0},0,0]
[{"$f":"'JP-ED- PP'!A30","v":"Finaliste"},{"$f":"'JP-Poule-PP'!B30","v":1},{"$f":"'JP-Poule-PP'!C30","v":0},0,0]
[{"$f":"'JP-ED- PP'!A31","v":"Finale"},{"$f":"'JP-Poule-PP'!B31","v":1},{"$f":"'JP-Poule-PP'!C31","v":0},0,0]
[null,null,null,null,8]
["6 CHEQUES ","1/2 FINALE ",{"$f":"'JP-Poule-PP'!D34","v":0},{"$f":"SUM(D14:D24)","v":0},12]
["3 CHEQUES ","FINALISTE",{"$f":"'JP-Poule-PP'!D35","v":0}]
["3 CHEQUES ","GAGNANT",{"$f":"'JP-Poule-PP'!D36","v":0}]