{"text_format":"2","workbook":"xls","n_sheets":3,"sheets":["Feuil1","Feuil2","Feuil3"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":"Feuil1","index":0,"n_rows":293,"n_cols":12,"rows_kept":293,"cut":false,"hidden":false,"merged":[[160,2,160,3],[157,4,157,6],[292,0,292,1],[1,0,1,10],[5,0,5,10],[7,0,7,1],[8,0,8,1],[9,0,9,1],[12,0,12,10],[19,0,19,10],[156,0,156,11],[21,2,21,4],[154,0,154,10],[159,2,159,3]],"flags":["formulas_cached_only"]}
[]
["Module de simulation de répartition dérogatoire \"à la majorité des 2/3\" du FPIC 2014 au sein d'un ensemble intercommunal (métropole ou DOM)"]
[]
["Excercice",null,null,"Ensemble intercommunal :"]
[]
["Données relatives à l'Ensemble Intercommunal (EI)"]
[]
["Montant Prélevé Ensemble intercommunal",null,null,null,"Population DGF de l'EI",null,null,"Rev/hab moyen des communes de l'EI (rev/hab de l'EI)"]
["Montant reversé Ensemble intercommunal",null,null,null,"CIF de l'EI",null,null,"Potentiel fiscal moyen des communes de l'EI"]
["Solde FPIC Ensemble intercommunal",null,0,{"$nulls":4},"Potentiel financier moyen des communes de l'EI"]
[]
[]
["Répartion du FPIC entre l'EPCI et l'ensemble de ses communes membres (en fonction du CIF)"]
[]
[{"$nulls":4},"Prélèvement de droit commun = répartition du prélèvement à la majorité des 2/3","Reversement de droit commun = répartition du reversement à la majorité des 2/3"]
[null,null,null,"Part EPCI"]
[null,null,null,"Part communes membres"]
[null,null,null,"TOTAL",0,0]
[]
["Répartition de droit commun et données nécessaires à la répartition dérogatoire à la majortié des 2/3 du FPIC entre les communes membres du même EPCI"]
[]
[null,null,"Répartition du FPIC de droit commun"]
["Code INSEE","Nom Communes","Prélèvement de droit commun","Reversement de droit commun","SOLDE","Population DGF de la commune","Revenu  par habitant de la commune","Potentiel fiscal par habitant de la commune","Potentiel financier  par habitant de la commune"]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
["TOTAL",null,0,0,0,0]
[]
["Répartition dérogatoire du FPIC à la majorité des 2/3 entre les communes membres (\"multicritères\")"]
[]
["Choix des critères et de la pondération par l'EI pour la répartition dérogatoire : la collectivité doit pondérer a minima ou bien \"le revenu par habitant et le Pfi/hab\" ou bien \"le revenu par habitant et le Pf/hab\" (L.2336-3 et -5)."]
[{"$nulls":4},"Pondération des critères"]
[{"$nulls":4},"Revenu par habitant","Potentiel fiscal par habitant (Pf/hab)","Potentiel financier par habitant (Pfi/hab)"]
[null,null,"Pondération critères pour prélèvement",null,null,null,1]
[null,null,"Pondération critères pour reversement",null,null,null,1]
[]
["Code INSEE","Nom Communes","Indice de répartition du prélèvement","Prélèvement dérogatoire avec multi-critères","Variation par rapport au prélèvement de droit commun (%)","Conformité du prélèvement dérogatoire à la limite maximale d'une hausse de 20% du prélèvement de droit commun","Indice de répartition du reversement","Reversement dérogatoire avec multi-critères","Variation par rapport au reversement de droit commun (%)","Conformité du reversement à la limite minimale d'une baisse de 20% du reversement de droit commun","Solde ","Différence avec solde de droit commun"]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["","",0,0,0,"valable",0,0,0,"valable",0,0]
["TOTAL",null,0,0,0,null,0,0,0,null,0,0]

{"sheet":"Feuil2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}

{"sheet":"Feuil3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}