{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["informations","méthode d'attribution sièges"],"not_rendered":{"charts":0,"images":1,"macros":1,"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":"informations","index":0,"n_rows":5,"n_cols":7,"rows_kept":5,"cut":false,"hidden":false,"merged":[[4,0,4,2],[4,3,4,5],[4,6,4,8]]}
[]
[null,null," CLIQUER ICI POUR REVENIR A LA FEUILLE DE CALCUL"]
[]
[]
["Calcul du quotient électoral.                                                                                                  Le calcul du quotient électoral, calculé jusqu'au deuxième chiffre après la virgule, est égal au nombre total des suffrages exprimés divisé par le nombre de sièges à pourvoir.",null,null,"Première répartition des sièges.                                                                                        Chaque liste \"a droit à autant de sièges que la moyenne des voix recueillies par elle contient de fois le quotient électoral\"",null,null,"Méthode de la plus forte moyenne.                                                                                    Après un premier tour d’attribution des sièges au quotient, on calculera pour chaque siège restant à attribuer, la moyenne de chaque liste en divisant la moyenne des voix de chaque liste par le nombre de siège obtenus + 1 . La liste qui a la plus grande moyenne se voit attribuer le siège du tour. On continue ainsi jusqu’à l’attribution complète des sièges.Dans la répartition à la plus forte moyenne, il s'agit de calculer quelle serait pour chaque liste, la moyenne des suffrages obtenus par sièges attribués si on accordait fictivement à chacune d'elle un siège supplémentaire. La liste qui obtient la plus forte moyenne reçoit un siège. L'opération se répète autant de fois qu'il reste de sièges à pourvoir,\n"]

{"sheet":"méthode d'attribution sièges","index":1,"n_rows":53,"n_cols":14,"rows_kept":53,"cut":false,"hidden":false,"merged":[[10,8,10,9],[10,12,14,14],[2,3,2,4],[6,12,8,14],[7,8,7,9],[3,3,3,4],[27,4,30,4],[22,5,26,5],[16,9,17,11],[27,9,31,13],[16,12,16,14],[17,12,17,13],[0,8,0,14],[1,8,1,14],[2,12,4,14],[5,8,5,9],[0,0,0,6],[1,0,1,6],[4,0,4,1],[21,1,21,2],[24,4,25,4],[10,1,11,3],[10,0,12,0],[21,0,23,0]]}
["CALCUL D'ATTRIBUTION DES SIEGES AUX ELECTIONS PROFESSIONNELLES D'ENTREPRISE"]
[]
["SUFFRAGES VALABLEMENT EXPRIMES",null,null,"QUOTIENT ELECTORAL "]
[null,null,null,{"$f":"IFERROR(A4/A7,\"\")","v":""}]
["1- Saisir dans la case blanche ci-dessus le nombre de suffrages exprimés."]
["NOMBRE DE SIEGES A REPARTIR"]
[]
["2- Saisir dans la case blanche ci-dessus le nombre de sièges à répartir."]
[]
["3- Saisir dans les cases blanches ci-dessous, les moyennes de chaque liste des organisations syndicales qui se sont présentées aux élections professionnelles."]
["LISTES","Calcul de la 1ère répartition des sièges"]
[]
[null,"Moyenne des voix de chaque liste*","Voix/QE","Sièges obtenus au quotient"]
["CGT",null,{"$f":"IFERROR(B14/D4,\"\")","v":""},{"$f":"IFERROR(ROUNDDOWN(C14,0),\"\")","v":""}]
["CFDT",null,{"$f":"IFERROR(B15/D4,\"\")","v":""},{"$f":"IFERROR(ROUNDDOWN(C15,0),\"\")","v":""}]
["FO",null,{"$f":"IFERROR(B16/D4,\"\")","v":""},{"$f":"IFERROR(ROUNDDOWN(C16,0),\"\")","v":""}]
["CFTC",null,{"$f":"IFERROR(B17/D4,\"\")","v":""},{"$f":"IFERROR(ROUNDDOWN(C17,0),\"\")","v":""}]
["UNSA",null,{"$f":"IFERROR(B18/D4,\"\")","v":""},{"$f":"IFERROR(ROUNDDOWN(C18,0),\"\")","v":""}]
["CFE-CGC",null,{"$f":"IFERROR(B19/D4,\"\")","v":""},{"$f":"IFERROR(ROUNDDOWN(C19,0),\"\")","v":""}]
[null,{"$f":"IF(SUM(B14:B19)=A4,\"\",\"ERREUR\")","v":""},"Total :",{"$f":"SUM(D14:D19)","v":0}]
["* Pour obtenir la moyenne des voix de chaque liste ci dessus, il faut diviser le total des voix recueillies par tous les candidats de la liste par le nombre de candidats présentés sur cette liste."]
["LISTES","Calcul de la 2ème répartition des sièges"]
[null,"Nb de siège restant à pourvoir après 1ère répartition:",{"$f":"A7-D20","v":0},null,null,{"$f":"IF(SUM(B46:B51)>A7,\"ERREUR\nCas des listes obtenant la même plus forte moyenne.\nLe siège doit revenir à la liste qui a obtenu le plus grand nombre de suffrages \",\" \")","v":" "}]
[null,"Moyenne pour le 1er siège restant","Sièges obtenus à la + forte moyenne"]
["CGT",{"$f":"IFERROR(B14/(D14+1),\"\")","v":""},{"$f":"IF(N36=A7,\"\",N36*1)","v":""},null,"Cliquer içi pour informations        sur les calculs"]
["CFDT",{"$f":"IFERROR(B15/(D15+1),\"\")","v":""},{"$f":"IF(N37=A7,\"\",N37*1)","v":""}]
["FO",{"$f":"IFERROR(B16/(D16+1),\"\")","v":""},{"$f":"IF(N38=A7,\"\",N38*1)","v":""}]
["CFTC",{"$f":"IFERROR(B17/(D17+1),\"\")","v":""},{"$f":"IF(N39=A7,\"\",N39*1)","v":""},null,{"$f":"IF(SUM(O20:O25)>K8,\"ERREUR\nEn cas d'égalité des restes, le siège à pourvoir est attribué à la liste qui a obtenue le plus grand nombre de suffrage\",\" \")","v":" "}]
["UNSA",{"$f":"IFERROR(B18/(D18+1),\"\")","v":""},{"$f":"IF(N40=A7,\"\",N40*1)","v":""}]
["CFE-CGC",{"$f":"IFERROR(B19/(D19+1),\"\")","v":""},{"$f":"IF(N41=A7,\"\",N41*1)","v":""}]
[null,"Total :",{"$f":"SUM(C25:C30)","v":0},null,null,null,{"$f":"IF(SUM(J20:J25)=K6,\"\",\"ERREUR\")","v":""}]
[]
[]
["2eme tour plus forte moyenne"]
["1er siège",null,"2eme",null,"3eme",null,"4eme"," ","5eme",null,"6eme",null,"7eme","total"]
[{"$f":"IF((RANK(B25,B25:B30,0)<=1),\"1\",\"0\")","v":{"$error":"#VALUE!"}},{"$f":"B14/((D14+A36)+1)","v":{"$error":"#VALUE!"}},{"$f":"IF((RANK(B36,B36:B42,0)<=1),\"1\",\"0\")","v":{"$error":"#VALUE!"}},{"$f":"B14/((D14+A36+C36)+1)","v":{"$error":"#VALUE!"}},{"$f":"IF((RANK(D36,D36:D42,0)<=1),\"1\",\"0\")","v":{"$error":"#VALUE!"}},{"$f":"B14/((D14+A36+C36+E36)+1)","v":{"$error":"#VALUE!"}},{"$f":"IF((RANK(F36,F36:F42,0)<=1),\"1\",\"0\")","v":{"$error":"#VALUE!"}},{"$f":"B14/((D14+A36+C36+E36+G36)+1)","v":{"$error":"#VALUE!"}},{"$f":"IF((RANK(H36,H36:H42,0)<=1),\"1\",\"0\")","v":{"$error":"#VALUE!"}},{"$f":"B14/((D14+A36+C36+E36+G36+I36)+1)","v":{"$error":"#VALUE!"}},{"$f":"IF((RANK(J36,J36:J42,0)<=1),\"1\",\"0\")","v":{"$error":"#VALUE!"}},{"$f":"B14/((D14+A36+C36+E36+G36+I36+K36)+1)","v":{"$error":"#VALUE!"}},{"$f":"IF((RANK(L36,L36:L42,0)<=1),\"1\",\"0\")","v":{"$error":"#VALUE!"}},{"$f":"SUM(IF(C23=1,A36*1,\"0\"),IF(C23=2,A36+C36,\"0\"),IF(C23=3,A36+C36+E36,\"0\"),IF(C23=4,A36+C36+E36+G36,\"0\"),IF(C23=5,A36+C36+E36+G36+I36,\"0\"),IF(C23=6,A36+C36+E36+G36+I36+K36,\"0\"),IF(C23=7,A36+C36+E36+G36+I36+K36+M36,\"0\"))","v":0}]
[{"$f":"IF((RANK(B26,B25:B30,0)<=1),\"1\",\"0\")","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF((RANK(B37,B36:B42,0)<=1),\"1\",\"0\")","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF((RANK(D37,D36:D42,0)<=1),\"1\",\"0\")","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF((RANK(F37,F36:F42,0)<=1),\"1\",\"0\")","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF((RANK(H37,H36:H42,0)<=1),\"1\",\"0\")","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF((RANK(J37,J36:J42,0)<=1),\"1\",\"0\")","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF((RANK(L37,L36:L42,0)<=1),\"1\",\"0\")","v":{"$error":"#VALUE!"}},{"$f":"SUM(IF(C23=1,A37*1,\"0\"),IF(C23=2,A37+C37,\"0\"),IF(C23=3,A37+C37+E37,\"0\"),IF(C23=4,A37+C37+E37+G37,\"0\"),IF(C23=5,A37+C37+E37+G37+I37,\"0\"),IF(C23=6,A37+C37+E37+G37+I37+K37,\"0\"),IF(C23=7,A37+C37+E37+G37+I37+K37+M37,\"0\"))","v":0}]
[{"$f":"IF((RANK(B27,B25:B30,0)<=1),\"1\",\"0\")","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF((RANK(B38,B36:B42,0)<=1),\"1\",\"0\")","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF((RANK(D38,D36:D42,0)<=1),\"1\",\"0\")","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF((RANK(F38,F36:F42,0)<=1),\"1\",\"0\")","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF((RANK(H38,H36:H42,0)<=1),\"1\",\"0\")","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF((RANK(J38,J36:J42,0)<=1),\"1\",\"0\")","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF((RANK(L38,L36:L42,0)<=1),\"1\",\"0\")","v":{"$error":"#VALUE!"}},{"$f":"SUM(IF(C23=1,A38*1,\"0\"),IF(C23=2,A38+C38,\"0\"),IF(C23=3,A38+C38+E38,\"0\"),IF(C23=4,A38+C38+E38+G38,\"0\"),IF(C23=5,A38+C38+E38+G38+I38,\"0\"),IF(C23=6,A38+C38+E38+G38+I38+K38,\"0\"),IF(C23=7,A38+C38+E38+G38+I38+K38+M38,\"0\"))","v":0}]
[{"$f":"IF((RANK(B28,B25:B30,0)<=1),\"1\",\"0\")","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF((RANK(B39,B36:B42,0)<=1),\"1\",\"0\")","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF((RANK(D39,D36:D42,0)<=1),\"1\",\"0\")","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF((RANK(F39,F36:F42,0)<=1),\"1\",\"0\")","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF((RANK(H39,H36:H42,0)<=1),\"1\",\"0\")","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF((RANK(J39,J36:J42,0)<=1),\"1\",\"0\")","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF((RANK(L39,L36:L42,0)<=1),\"1\",\"0\")","v":{"$error":"#VALUE!"}},{"$f":"SUM(IF(C23=1,A39*1,\"0\"),IF(C23=2,A39+C39,\"0\"),IF(C23=3,A39+C39+E39,\"0\"),IF(C23=4,A39+C39+E39+G39,\"0\"),IF(C23=5,A39+C39+E39+G39+I39,\"0\"),IF(C23=6,A39+C39+E39+G39+I39+K39,\"0\"),IF(C23=7,A39+C39+E39+G39+I39+K39+M39,\"0\"))","v":0}]
[{"$f":"IF((RANK(B29,B25:B30,0)<=1),\"1\",\"0\")","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF((RANK(B40,B36:B42,0)<=1),\"1\",\"0\")","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF((RANK(D40,D36:D42,0)<=1),\"1\",\"0\")","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF((RANK(F40,F36:F42,0)<=1),\"1\",\"0\")","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF((RANK(H40,H36:H42,0)<=1),\"1\",\"0\")","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF((RANK(J40,J36:J42,0)<=1),\"1\",\"0\")","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF((RANK(L40,L36:L42,0)<=1),\"1\",\"0\")","v":{"$error":"#VALUE!"}},{"$f":"SUM(IF(C23=1,A40*1,\"0\"),IF(C23=2,A40+C40,\"0\"),IF(C23=3,A40+C40+E40,\"0\"),IF(C23=4,A40+C40+E40+G40,\"0\"),IF(C23=5,A40+C40+E40+G40+I40,\"0\"),IF(C23=6,A40+C40+E40+G40+I40+K40,\"0\"),IF(C23=7,A40+C40+E40+G40+I40+K40+M40,\"0\"))","v":0}]
[{"$f":"IF((RANK(B30,B25:B30,0)<=1),\"1\",\"0\")","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF((RANK(B41,B36:B42,0)<=1),\"1\",\"0\")","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF((RANK(D41,D36:D42,0)<=1),\"1\",\"0\")","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF((RANK(F41,F36:F42,0)<=1),\"1\",\"0\")","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF((RANK(H41,H36:H42,0)<=1),\"1\",\"0\")","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF((RANK(J41,J36:J42,0)<=1),\"1\",\"0\")","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF((RANK(L41,L36:L42,0)<=1),\"1\",\"0\")","v":{"$error":"#VALUE!"}},{"$f":"SUM(IF(C23=1,A41*1,\"0\"),IF(C23=2,A41+C41,\"0\"),IF(C23=3,A41+C41+E41,\"0\"),IF(C23=4,A41+C41+E41+G41,\"0\"),IF(C23=5,A41+C41+E41+G41+I41,\"0\"),IF(C23=6,A41+C41+E41+G41+I41+K41,\"0\"),IF(C23=7,A41+C41+E41+G41+I41+K41+M41,\"0\"))","v":0}]
[{"$f":"IF((RANK(#REF!,B25:B30,0)<=1),\"1\",\"0\")","v":{"$error":"#REF!"}},{"$f":"#REF!/((#REF!+A42)+1)","v":{"$error":"#REF!"}},{"$f":"IF((RANK(B42,B36:B42,0)<=1),\"1\",\"0\")","v":{"$error":"#REF!"}},{"$f":"#REF!/((#REF!+A42+C42)+1)","v":{"$error":"#REF!"}},{"$f":"IF((RANK(D42,D36:D42,0)<=1),\"1\",\"0\")","v":{"$error":"#REF!"}},{"$f":"#REF!/((#REF!+A42+C42+E42)+1)","v":{"$error":"#REF!"}},{"$f":"IF((RANK(F42,F36:F42,0)<=1),\"1\",\"0\")","v":{"$error":"#REF!"}},{"$f":"#REF!/((#REF!+A42+C42+E42+G42)+1)","v":{"$error":"#REF!"}},{"$f":"IF((RANK(H42,H36:H42,0)<=1),\"1\",\"0\")","v":{"$error":"#REF!"}},{"$f":"#REF!/((#REF!+A42+C42+E42+G42+I42)+1)","v":{"$error":"#REF!"}},{"$f":"IF((RANK(J42,J36:J42,0)<=1),\"1\",\"0\")","v":{"$error":"#REF!"}},{"$f":"#REF!/((#REF!+A42+C42+E42+G42+I42+K42)+1)","v":{"$error":"#REF!"}},{"$f":"IF((RANK(L42,L36:L42,0)<=1),\"1\",\"0\")","v":{"$error":"#REF!"}},{"$f":"SUM(IF(C23=1,A42*1,\"0\"),IF(C23=2,A42+C42,\"0\"),IF(C23=3,A42+C42+E42,\"0\"),IF(C23=4,A42+C42+E42+G42,\"0\"),IF(C23=5,A42+C42+E42+G42+I42,\"0\"),IF(C23=6,A42+C42+E42+G42+I42+K42,\"0\"),IF(C23=7,A42+C42+E42+G42+I42+K42+M42,\"0\"))","v":0}]
[{"$f":"SUM(A36:A42)","v":{"$error":"#VALUE!"}},null,{"$f":"SUM(C36:C42)","v":{"$error":"#VALUE!"}}]
[]
["LISTES","SIEGES"]
["CGT",{"$f":"IFERROR(D14+C25,\"\")","v":""}]
["CFDT",{"$f":"IFERROR(D15+C26,\"\")","v":""}]
["FO",{"$f":"IFERROR(D16+C27,\"\")","v":""}]
["CFTC",{"$f":"IFERROR(D17+C28,\"\")","v":""}]
["UNSA",{"$f":"IFERROR(D18+C29,\"\")","v":""}]
["CFE-CGC",{"$f":"IFERROR(D19+C30,\"\")","v":""}]
[]
["Fédération CGT THCB 2019"]