{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["PageDeGarde","E0 FEDER","E.1.2","E.1.2.1","E.1.1","E.1.2.1bis","E.1.2.2","E.1.2.3","E.1.2.4","E.1","E.2.1","E.2","Impression","Feuil12"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":13,"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":"PageDeGarde","index":0,"n_rows":40,"n_cols":6,"rows_kept":40,"cut":false,"hidden":false,"merged":[[37,4,37,9],[34,4,34,10],[33,4,33,10],[36,4,36,11],[21,2,21,4],[24,2,24,4],[31,4,31,9],[32,4,32,9],[35,4,35,9],[39,4,39,10],[8,5,8,9],[6,5,6,9],[1,5,1,10],[2,5,2,10],[3,5,3,10],[4,5,4,10],[11,5,13,9],[15,5,17,9],[27,4,28,9],[30,4,30,9],[11,2,11,4],[15,2,15,4],[38,4,38,9],[19,2,19,4],[20,2,20,4]]}
[]
[null,null,null,null,null,"Annexe 1a : Dossier de demande de subvention"]
[null,null,null,null,null,"FEDER/FSE"]
[null,null,null,null,null,"Programme Opérationnel Languedoc Roussillon"]
[null,null,null,null,null,"2014/2020"]
[]
[null,null,null,null,null,"Plan de financement \nFonds Européen de Développement Régional FEDER uniquement \n(données chiffrées)"]
[]
[]
[]
[]
[null,null,"►    Intitulé de l’opération"]
[]
[]
[]
[null,null,"►    Bénéficiaire"]
[]
[]
[]
[null,null,"►    Axe"]
[null,null,"Objectif thématique"]
[null,null,"Priorité d'investissement"]
[]
[]
[null,null,"►    Contenu"]
[]
[]
[null,null,null,null,"Dans les différents onglets, seules les cases vertes sont à compléter par le porteur de projet."]
[]
[]
[null,null,null,"E.0","Application du régime de forfaitisation des coûts"]
[null,null,null,"E.1.2.0","Dépenses d'investissement"]
[null,null,null,"E.1.2.1","Dépenses directes de personnel"]
[null,null,null,"E.1.2.2","Dépenses de fonctionnement directement rattachable à l'opération"]
[null,null,null,"E.1.2.3","Prestations externes directement liées et nécessaires à l'opération"]
[null,null,null,"E.1.2.4","Contributions en nature"]
[null,null,null,"E.1","Tableau récapitulatif des dépenses prévisionnelles par année et par postes de dépense"]
[null,null,null,"E.2.1","Tableau de calcul des recettes nettes"]
[null,null,null,"E.2","Ressources prévisionnelles"]
[null,null,null,"Impression","Application permettant d'imprimer le formulaire actif"]

{"sheet":"E0 FEDER","index":1,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[[14,1,14,5],[12,1,12,5],[13,1,13,5],[7,3,7,5],[9,3,9,5],[11,1,11,5],[4,3,4,5],[5,3,5,5],[0,1,0,5],[1,0,2,0],[1,1,1,5],[2,1,2,5]]}
[null,"E.0 Application d'option de coûts simplifiés FEDER"]
[null,"La simplification des coûts consiste à calculer certains coûts selon une méthode prédéfinie reposant sur d'autres catégories de coûts et non plus sur la justification de chaque dépense. Cela permet de réduire considérablement la charge administrative de justification des dépenses pour le bénéficiaire.                                                                                                                                                                                                                                                                                                                                                                                                   \n\nConformément à l'option ouverte par l'article 67 du règlement cadre 1303/2013, la Région Occitanie applique, pour le programme opérationnel Languedoc Roussillon, le financement à taux forfaitaire. Cette méthode consiste à calculer des catégories spécifiques de coûts éligibles identifiées à l'avance par application d'un pourcentage fixé ex ante à une ou plusieurs autres catégories de coûts éligibles.                                                                                                                                                                            Ces coûts simplifiés ne peuvent concerner que les subventions et ne pourront pas s'appliquer aux opérations ou parties d'opération mises en œuvre exclusivement sur la base de marchés publics."]
[]
[]
[null,null,null,"Cocher la case appropriée"]
[null,null,null,"Si l'opération est mise en œuvre directement par le bénéficiaire, une option de coûts simplifiés s'applique* SAUF EN CAS DE REGIME D'AIDE D'ETAT : \nUn taux forfaitaire de 15% sera appliqué aux frais directs de personnels pour calculer les coûts indirects**.\n \nDans ce cas, les coûts indirects n'auront pas à être justifiés. \n\n* sous réserve de l'accord de l'autorité de gestion et de la compatibilité avec le régime d'aide, le cas échéant. \n** sous réserve de l'éligibilité des coûts indirects, certains types d'action les excluant d'office. Rapprochez-vous du Service Gestion des programmes européens pour plus de renseignements."]
[]
[null,null,null,"Si l’opération est mise en œuvre exclusivement sur la base de marchés de travaux, de biens ou de services, les coûts simplifiés ne s'appliquent pas et les frais indirects ne sont pas éligibles."]
[]
[null,null,null,"Si l’opération est mise en œuvre partiellement sur la base de marchés de travaux, de biens ou de services, ou en cas de régime d'aides d'état, les coûts simplifiés pourront dans certains cas et sur décision du Service Gestion, s'appliquer à une partie de l'opération. Renseignez-vous auprès de l'Autorité de Gestion"]
[]
[null,"On entend par dépenses directes, les dépenses directement rattachable à l'opération."]
[null,"Les coûts indirects sont des dépenses de fonctionnement courant interne à la structure bénéficiaire, qui contribuent à l'opération mais ne sont pas directement générés par elle et sont difficilement individualisable. Ils comprennent par exemple : les frais de gestion, de recrutement, de téléphone, d'eau, d'électricité, de comptabilité, de nettoyage."]
[null,"En cas d’incertitude sur le caractère de certains coûts, il y aura lieu d’examiner le lien fonctionnel rattachant la dépense à l’opération ; \nune dépense sera considérée comme directe si elle contribue principalement à sa réalisation. Si un tel lien ne peut être établi, on jugera que la dépense est directe dans la mesure où elle a été engendrée par l’opération, et n’aurait pas eu lieu en l’absence de celle-ci."]
[null,"Les frais directs de personnel comprennent les rémunérations des personnels directement affectés à l'opération ainsi que les taxes et cotisation de sécurité sociale des employés, et cotisation sociales volontaires et obligatoires des employeurs."]

{"sheet":"E.1.2","index":2,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,7],[3,1,3,3],[3,4,3,7],[2,1,2,3]]}
[]
[null,"E 1.2. : Dépenses d'investissement "]
[null,"Veuillez sélectionner les années concernées dans la liste de case grisées"]
[null,null,null,null,"Montants ventilés par année"]
[null,"Objet *","Détailler la nature des dépenses prévues","Détailler les bases de calcul",null,null,null,"Total"]
[null,"Acquisitions foncières et immobilières",null,null,null,null,null,{"$f":"SUM(E6:G6)","v":0}]
[null,"Construction, extension de bâtiment",null,null,null,null,null,{"$f":"SUM(E7:G7)","v":0}]
[null,"Autres travaux",null,null,null,null,null,{"$f":"SUM(E8:G8)","v":0}]
[null,"Équipements",null,null,null,null,null,{"$f":"SUM(E9:G9)","v":0}]
[null,"Études et expertises",null,null,null,null,null,{"$f":"SUM(E10:G10)","v":0}]
[null,"Divers",null,null,null,null,null,0]
[null,"Total",null,null,{"$f":"SUM(E6:E11)","v":0},{"$f":"SUM(F6:F11)","v":0},0,{"$f":"SUM(E12:G12)","v":0}]

{"sheet":"E.1.2.1","index":3,"n_rows":43,"n_cols":8,"rows_kept":43,"cut":false,"hidden":false,"merged":[[2,1,2,7]]}
[]
[]
[null,"E 1.2.1 - Dépenses directes de personnel"]
[]
[null,"Type de fonction\n(directeur, formateur,\nchargé de mission,\nassistant, …) + Nom","Base\nde dépenses\n(Salaires annuels chargés)","Activité liée à l'opération (Nombre d'heures)","Activité Totale à calculer sur la base du nombre d'heure travaillées","Part de l'activité liée à l'opération","Dépenses liées à l'opération","A titre indicatif : coût unitaire"]
[null,"(saisir une ligne par personne)","(1)","(2)","(3)","(4)=(2)/(3)","(5)=(1)x(4)","(6)=(1)/(3)"]
[1,null,null,null,null,{"$f":"IF(E7=0,\"-\",D7/E7)","v":"-"},{"$f":"IF(E7=0,\"-\",C7*F7)","v":"-"},{"$f":"IF(D7=0,\"-\",C7/E7)","v":"-"}]
[2,null,null,null,null,{"$f":"IF(E8=0,\"-\",D8/E8)","v":"-"},{"$f":"IF(E8=0,\"-\",C8*F8)","v":"-"},{"$f":"IF(D8=0,\"-\",C8/E8)","v":"-"}]
[3,null,null,null,null,"-","-","-"]
[4,null,null,null,null,"-","-","-"]
[5,null,null,null,null,"-","-","-"]
[6,null,null,null,null,"-","-","-"]
[7,null,null,null,null,"-","-","-"]
[8,null,null,null,null,"-","-","-"]
[9,null,null,null,null,"-","-","-"]
[10,null,null,null,null,"-",{"$f":"IF(E16=0,\"-\",C16*F16)","v":"-"},"-"]
[null,"report onglet E.1.2.1 bis saisie complète",{"$f":"E.1.2.1bis!C6","v":0},{"$f":"E.1.2.1bis!D6","v":0},{"$f":"E.1.2.1bis!E6","v":0},null,{"$f":"E.1.2.1bis!G6","v":0}]
[null,{"$f":"\"Sous-total de \" & E.1.2!E5","v":"Sous-total de "},{"$f":"SUM(C7:C17)","v":0},{"$f":"SUM(D7:D17)","v":0},0,"-",{"$f":"SUM(G7:G17)","v":0},"-"]
[1,null,null,null,null,"-",{"$f":"IF(E19=0,\"-\",C19*F19)","v":"-"},"-"]
[2,null,null,null,null,"-",{"$f":"IF(E20=0,\"-\",C20*F20)","v":"-"},"-"]
[3,null,null,null,null,"-","-","-"]
[4,null,null,null,null,"-","-","-"]
[5,null,null,null,null,"-","-","-"]
[6,null,null,null,null,"-","-","-"]
[7,null,null,null,null,"-","-","-"]
[8,null,null,null,null,"-","-","-"]
[9,null,null,null,null,"-","-","-"]
[10,null,null,null,null,"-",{"$f":"IF(E28=0,\"-\",C28*F28)","v":"-"},"-"]
[null,"report onglet E.1.2.1 bis saisie complète",{"$f":"E.1.2.1bis!L6","v":0},{"$f":"E.1.2.1bis!M6","v":0},{"$f":"E.1.2.1bis!N6","v":0},null,{"$f":"E.1.2.1bis!P6","v":0}]
[null,{"$f":"\"Sous-total de \" & E.1.2!F5","v":"Sous-total de "},{"$f":"SUM(C19:C29)","v":0},{"$f":"SUM(D19:D29)","v":0},0,"-",{"$f":"SUM(G19:G29)","v":0},"-"]
[1,null,null,null,null,"-",{"$f":"IF(E31=0,\"-\",C31*F31)","v":"-"},"-"]
[2,null,null,null,null,"-",{"$f":"IF(E32=0,\"-\",C32*F32)","v":"-"},"-"]
[3,null,null,null,null,"-","-","-"]
[4,null,null,null,null,"-","-","-"]
[5,null,null,null,null,"-","-","-"]
[6,null,null,null,null,"-","-","-"]
[7,null,null,null,null,"-","-","-"]
[8,null,null,null,null,"-","-","-"]
[9,null,null,null,null,"-","-","-"]
[10,null,null,null,null,"-","-","-"]
[null,"report onglet E.1.2.1 bis saisie complète",{"$f":"E.1.2.1bis!U6","v":0},{"$f":"E.1.2.1bis!V6","v":0},{"$f":"E.1.2.1bis!W6","v":0},null,{"$f":"E.1.2.1bis!Y6","v":0}]
[null,{"$f":"\"Sous-total de \" & E.1.2!G5","v":"Sous-total de "},{"$f":"SUM(C31:C41)","v":0},{"$f":"SUM(D31:D41)","v":0},0,"-",{"$f":"SUM(G31:G41)","v":0},"-"]
[null,"Total pour l'opération",{"$f":"C18+C30+C42","v":0},{"$f":"D18+D30+D42","v":0},0,"-",{"$f":"G18+G30+G42","v":0},"-"]

{"sheet":"E.1.1","index":4,"n_rows":24,"n_cols":6,"rows_kept":24,"cut":false,"hidden":false,"merged":[[15,2,15,4],[1,1,1,5],[3,1,3,5],[5,2,5,4],[6,2,6,4],[7,2,7,4],[9,1,9,5],[10,2,10,4],[11,2,11,4],[12,1,12,5],[13,2,13,4],[14,2,14,4],[22,2,22,4],[23,2,23,4],[16,2,16,4],[17,2,17,4],[18,2,18,4],[19,2,19,4],[20,2,20,4],[21,2,21,4]]}
[]
[null,"►  E 1.1 - Nature des taux d'affectation des personnels"]
[]
[null,"Dépenses directes - charges de personnel"]
[]
[null,null,"Nature de la clé d'affectation",null,null,"Unité"]
[null,null,null,null,null,"Heures"]
[null,"Exemples :","• Temps travaillé sur l'opération par les agents concernés / temps total de ces agents\n• Temps de formation dispensé pour l'opération / temps total de formation dispensé par la structure\n• Nombre de prestations assurées dans le cadre de l'opération / nb total de prestations assurées par la structure",null,null,"Journées                       k                           Heures                                    k                          Nombre"]
[]
[null,"Si une seule clé de répartition est utilisée pour toutes les dépenses indirectes, remplir ce tableau :"]
[null,null,"Nature de la clé de répartition",null,null,"Unité"]
[]
[null,"Si plusieurs clés de répartition sont utilisés en fonction de la nature de la dépense, remplir ce tableau :"]
[null,"Postes de dépenses indirectes","Nature des clés de répartition",null,null,"Unité"]
[null,"Charges de personnel"]
[null,"Achats"]
[null,"Prestations de services, honoraires"]
[null,"Matériels, équipements, travaux"]
[null,"Services extérieurs"]
[null,"Locaux : locations, entretien"]
[null,"Déplacements, missions"]
[null,"Frais postaux et de télécom."]
[null,"Impôts et taxes"]
[null,"Dotations aux amortissements"]

{"sheet":"E.1.2.1bis","index":5,"n_rows":156,"n_cols":26,"rows_kept":156,"cut":false,"hidden":false,"merged":[[1,1,1,26],[2,1,2,7],[2,10,2,16],[2,19,2,25]]}
[]
[null,"E 1.2.1 bis - Dépenses directes de personnel - Saisie complète"]
[null,{"$f":"\"Année \" & E.1.2!E5","v":"Année "},null,null,null,null,null,null,null,null,{"$f":"\"Année \" & E.1.2!F5","v":"Année "},null,null,null,null,null,null,null,null,{"$f":"\"Année \" & E.1.2!G5","v":"Année "}]
[null,"Type de fonction\n(directeur, formateur,\nchargé de mission,\nassistant, …) + Nom","Base\nde dépenses\n(Salaires annuels chargés)","Activité liée à l'opération (Nombre d'heures)","Activité Totale à calculer sur la base du nombre d'heure travaillées","Part de l'activité liée à l'opération","Dépenses liées à l'opération","A titre indicatif : coût unitaire",null,null,"Type de fonction\n(directeur, formateur,\nchargé de mission,\nassistant, …) + Nom","Base\nde dépenses\n(Salaires annuels chargés)","Activité liée à l'opération (Nombre d'heures)","Activité Totale à calculer sur la base du nombre d'heure travaillées","Part de l'activité liée à l'opération","Dépenses liées à l'opération","A titre indicatif : coût unitaire",null,null,"Type de fonction\n(directeur, formateur,\nchargé de mission,\nassistant, …) + Nom","Base\nde dépenses\n(Salaires annuels chargés)","Activité liée à l'opération (Nombre d'heures)","Activité Totale à calculer sur la base du nombre d'heure travaillées","Part de l'activité liée à l'opération","Dépenses liées à l'opération","A titre indicatif : coût unitaire"]
[null,"(saisir une ligne par personne)","(1)","(2)","(3)","(4)=(2)/(3)","(5)=(1)x(4)","(6)=(1)/(3)",null,null,"(saisir une ligne par personne)","(1)","(2)","(3)","(4)=(2)/(3)","(5)=(1)x(4)","(6)=(1)/(3)",null,null,"(saisir une ligne par personne)","(1)","(2)","(3)","(4)=(2)/(3)","(5)=(1)x(4)","(6)=(1)/(3)"]
[null,{"$f":"\"Sous-total de \" & E.1.2!E5","v":"Sous-total de "},{"$f":"SUM(C7:C156)","v":0},{"$f":"SUM(D7:D156)","v":0},0,{"$f":"IF(E6=0,\"-\",D6/E6)","v":"-"},{"$f":"SUM(G7:G156)","v":0},{"$f":"IF(D6=0,\"-\",C6/E6)","v":"-"},null,null,{"$f":"\"Sous-total de \" & E.1.2!F5","v":"Sous-total de "},{"$f":"SUM(L7:L156)","v":0},{"$f":"SUM(M7:M156)","v":0},{"$f":"SUM(N7:N156)","v":0},{"$f":"IF(N6=0,\"-\",M6/N6)","v":"-"},{"$f":"SUM(P7:P156)","v":0},{"$f":"IF(M6=0,\"-\",L6/N6)","v":"-"},null,null,{"$f":"\"Sous-total de \" &  E.1.2!G5","v":"Sous-total de "},{"$f":"SUM(U7:U156)","v":0},{"$f":"SUM(V7:V156)","v":0},0,{"$f":"IF(W6=0,\"-\",V6/W6)","v":"-"},0,{"$f":"IF(V6=0,\"-\",U6/W6)","v":"-"}]
[1,null,null,null,null,{"$f":"IF(E7=0,\"-\",D7/E7)","v":"-"},{"$f":"IF(E7=0,\"-\",C7*F7)","v":"-"},{"$f":"IF(D7=0,\"-\",C7/E7)","v":"-"},null,1,null,null,null,null,{"$f":"IF(N7=0,\"-\",M7/N7)","v":"-"},{"$f":"IF(N7=0,\"-\",L7*O7)","v":"-"},{"$f":"IF(M7=0,\"-\",L7/N7)","v":"-"},null,1,null,null,null,null,"-",{"$f":"IF(W7=0,\"-\",U7*X7)","v":"-"},{"$f":"IF(V7=0,\"-\",U7/W7)","v":"-"}]
[2,null,null,null,null,{"$f":"IF(E8=0,\"-\",D8/E8)","v":"-"},"-",{"$f":"IF(D8=0,\"-\",C8/E8)","v":"-"},null,2,null,null,null,null,{"$f":"IF(N8=0,\"-\",M8/N8)","v":"-"},"-",{"$f":"IF(M8=0,\"-\",L8/N8)","v":"-"},null,2,null,null,null,null,"-","-",{"$f":"IF(V8=0,\"-\",U8/W8)","v":"-"}]
[3,null,null,null,null,"-","-","-",null,3,null,null,null,null,"-","-","-",null,3,null,null,null,null,{"$f":"IF(W9=0,\"-\",V9/W9)","v":"-"},"-","-"]
[4,null,null,null,null,"-","-","-",null,4,null,null,null,null,"-","-","-",null,4,null,null,null,null,"-","-","-"]
[5,null,null,null,null,"-","-","-",null,5,null,null,null,null,"-","-","-",null,5,null,null,null,null,"-","-","-"]
[6,null,null,null,null,"-","-","-",null,6,null,null,null,null,"-","-","-",null,6,null,null,null,null,"-","-","-"]
[7,null,null,null,null,"-","-","-",null,7,null,null,null,null,"-","-","-",null,7,null,null,null,null,"-","-","-"]
[8,null,null,null,null,"-","-","-",null,8,null,null,null,null,"-","-","-",null,8,null,null,null,null,"-","-","-"]
[9,null,null,null,null,"-","-","-",null,9,null,null,null,null,"-","-","-",null,9,null,null,null,null,"-","-","-"]
[10,null,null,null,null,"-","-","-",null,10,null,null,null,null,"-","-","-",null,10,null,null,null,null,"-","-","-"]
[11,null,null,null,null,"-","-","-",null,11,null,null,null,null,"-","-","-",null,11,null,null,null,null,"-","-","-"]
[12,null,null,null,null,"-","-","-",null,12,null,null,null,null,"-","-","-",null,12,null,null,null,null,"-","-","-"]
[13,null,null,null,null,"-","-","-",null,13,null,null,null,null,"-","-","-",null,13,null,null,null,null,"-","-","-"]
[14,null,null,null,null,"-","-","-",null,14,null,null,null,null,"-","-","-",null,14,null,null,null,null,"-","-","-"]
[15,null,null,null,null,"-","-","-",null,15,null,null,null,null,"-","-","-",null,15,null,null,null,null,"-","-","-"]
[16,null,null,null,null,"-","-","-",null,16,null,null,null,null,"-","-","-",null,16,null,null,null,null,"-","-","-"]
[17,null,null,null,null,"-","-","-",null,17,null,null,null,null,"-","-","-",null,17,null,null,null,null,"-","-","-"]
[18,null,null,null,null,"-","-","-",null,18,null,null,null,null,"-","-","-",null,18,null,null,null,null,"-","-","-"]
[19,null,null,null,null,"-","-","-",null,19,null,null,null,null,"-","-","-",null,19,null,null,null,null,"-","-","-"]
[20,null,null,null,null,"-","-","-",null,20,null,null,null,null,"-","-","-",null,20,null,null,null,null,"-","-","-"]
[21,null,null,null,null,"-","-","-",null,21,null,null,null,null,"-","-","-",null,21,null,null,null,null,"-","-","-"]
[22,null,null,null,null,"-","-","-",null,22,null,null,null,null,"-","-","-",null,22,null,null,null,null,"-","-","-"]
[23,null,null,null,null,"-","-","-",null,23,null,null,null,null,"-","-","-",null,23,null,null,null,null,"-","-","-"]
[24,null,null,null,null,"-","-","-",null,24,null,null,null,null,"-","-","-",null,24,null,null,null,null,"-","-","-"]
[25,null,null,null,null,"-","-","-",null,25,null,null,null,null,"-","-","-",null,25,null,null,null,null,"-","-","-"]
[26,null,null,null,null,"-","-","-",null,26,null,null,null,null,"-","-","-",null,26,null,null,null,null,"-","-","-"]
[27,null,null,null,null,"-","-","-",null,27,null,null,null,null,"-","-","-",null,27,null,null,null,null,"-","-","-"]
[28,null,null,null,null,"-","-","-",null,28,null,null,null,null,"-","-","-",null,28,null,null,null,null,"-","-","-"]
[29,null,null,null,null,"-","-","-",null,29,null,null,null,null,"-","-","-",null,29,null,null,null,null,"-","-","-"]
[30,null,null,null,null,"-","-","-",null,30,null,null,null,null,"-","-","-",null,30,null,null,null,null,"-","-","-"]
[31,null,null,null,null,"-","-","-",null,31,null,null,null,null,"-","-","-",null,31,null,null,null,null,"-","-","-"]
[32,null,null,null,null,"-","-","-",null,32,null,null,null,null,"-","-","-",null,32,null,null,null,null,"-","-","-"]
[33,null,null,null,null,"-","-","-",null,33,null,null,null,null,"-","-","-",null,33,null,null,null,null,"-","-","-"]
[34,null,null,null,null,"-","-","-",null,34,null,null,null,null,"-","-","-",null,34,null,null,null,null,"-","-","-"]
[35,null,null,null,null,"-","-","-",null,35,null,null,null,null,"-","-","-",null,35,null,null,null,null,"-","-","-"]
[36,null,null,null,null,"-","-","-",null,36,null,null,null,null,"-","-","-",null,36,null,null,null,null,"-","-","-"]
[37,null,null,null,null,"-","-","-",null,37,null,null,null,null,"-","-","-",null,37,null,null,null,null,"-","-","-"]
[38,null,null,null,null,"-","-","-",null,38,null,null,null,null,"-","-","-",null,38,null,null,null,null,"-","-","-"]
[39,null,null,null,null,"-","-","-",null,39,null,null,null,null,"-","-","-",null,39,null,null,null,null,"-","-","-"]
[40,null,null,null,null,"-","-","-",null,40,null,null,null,null,"-","-","-",null,40,null,null,null,null,"-","-","-"]
[41,null,null,null,null,"-","-","-",null,41,null,null,null,null,"-","-","-",null,41,null,null,null,null,"-","-","-"]
[42,null,null,null,null,"-","-","-",null,42,null,null,null,null,"-","-","-",null,42,null,null,null,null,"-","-","-"]
[43,null,null,null,null,"-","-","-",null,43,null,null,null,null,"-","-","-",null,43,null,null,null,null,"-","-","-"]
[44,null,null,null,null,"-","-","-",null,44,null,null,null,null,"-","-","-",null,44,null,null,null,null,"-","-","-"]
[45,null,null,null,null,"-","-","-",null,45,null,null,null,null,"-","-","-",null,45,null,null,null,null,"-","-","-"]
[46,null,null,null,null,"-","-","-",null,46,null,null,null,null,"-","-","-",null,46,null,null,null,null,"-","-","-"]
[47,null,null,null,null,"-","-","-",null,47,null,null,null,null,"-","-","-",null,47,null,null,null,null,"-","-","-"]
[48,null,null,null,null,"-","-","-",null,48,null,null,null,null,"-","-","-",null,48,null,null,null,null,"-","-","-"]
[49,null,null,null,null,"-","-","-",null,49,null,null,null,null,"-","-","-",null,49,null,null,null,null,"-","-","-"]
[50,null,null,null,null,"-","-","-",null,50,null,null,null,null,"-","-","-",null,50,null,null,null,null,"-","-","-"]
[51,null,null,null,null,"-","-","-",null,51,null,null,null,null,"-","-","-",null,51,null,null,null,null,"-","-","-"]
[52,null,null,null,null,"-","-","-",null,52,null,null,null,null,"-","-","-",null,52,null,null,null,null,"-","-","-"]
[53,null,null,null,null,"-","-","-",null,53,null,null,null,null,"-","-","-",null,53,null,null,null,null,"-","-","-"]
[54,null,null,null,null,"-","-","-",null,54,null,null,null,null,"-","-","-",null,54,null,null,null,null,"-","-","-"]
[55,null,null,null,null,"-","-","-",null,55,null,null,null,null,"-","-","-",null,55,null,null,null,null,"-","-","-"]
[56,null,null,null,null,"-","-","-",null,56,null,null,null,null,"-","-","-",null,56,null,null,null,null,"-","-","-"]
[57,null,null,null,null,"-","-","-",null,57,null,null,null,null,"-","-","-",null,57,null,null,null,null,"-","-","-"]
[58,null,null,null,null,"-","-","-",null,58,null,null,null,null,"-","-","-",null,58,null,null,null,null,"-","-","-"]
[59,null,null,null,null,"-","-","-",null,59,null,null,null,null,"-","-","-",null,59,null,null,null,null,"-","-","-"]
[60,null,null,null,null,"-","-","-",null,60,null,null,null,null,"-","-","-",null,60,null,null,null,null,"-","-","-"]
[61,null,null,null,null,"-","-","-",null,61,null,null,null,null,"-","-","-",null,61,null,null,null,null,"-","-","-"]
[62,null,null,null,null,"-","-","-",null,62,null,null,null,null,"-","-","-",null,62,null,null,null,null,"-","-","-"]
[63,null,null,null,null,"-","-","-",null,63,null,null,null,null,"-","-","-",null,63,null,null,null,null,"-","-","-"]
[64,null,null,null,null,"-","-","-",null,64,null,null,null,null,"-","-","-",null,64,null,null,null,null,"-","-","-"]
[65,null,null,null,null,{"$f":"IF(E71=0,\"-\",D71/E71)","v":"-"},{"$f":"IF(E71=0,\"-\",C71*F71)","v":"-"},{"$f":"IF(D71=0,\"-\",C71/E71)","v":"-"},null,65,null,null,null,null,{"$f":"IF(N71=0,\"-\",M71/N71)","v":"-"},{"$f":"IF(N71=0,\"-\",L71*O71)","v":"-"},{"$f":"IF(M71=0,\"-\",L71/N71)","v":"-"},null,65,null,null,null,null,{"$f":"IF(W71=0,\"-\",V71/W71)","v":"-"},{"$f":"IF(W71=0,\"-\",U71*X71)","v":"-"},{"$f":"IF(V71=0,\"-\",U71/W71)","v":"-"}]
[66,null,null,null,null,"-","-","-",null,66,null,null,null,null,"-","-","-",null,66,null,null,null,null,"-","-","-"]
[67,null,null,null,null,"-","-","-",null,67,null,null,null,null,"-","-","-",null,67,null,null,null,null,"-","-","-"]
[68,null,null,null,null,"-","-","-",null,68,null,null,null,null,"-","-","-",null,68,null,null,null,null,"-","-","-"]
[69,null,null,null,null,"-","-","-",null,69,null,null,null,null,"-","-","-",null,69,null,null,null,null,"-","-","-"]
[70,null,null,null,null,"-","-","-",null,70,null,null,null,null,"-","-","-",null,70,null,null,null,null,"-","-","-"]
[71,null,null,null,null,"-","-","-",null,71,null,null,null,null,"-","-","-",null,71,null,null,null,null,"-","-","-"]
[72,null,null,null,null,"-","-","-",null,72,null,null,null,null,"-","-","-",null,72,null,null,null,null,"-","-","-"]
[73,null,null,null,null,"-","-","-",null,73,null,null,null,null,"-","-","-",null,73,null,null,null,null,"-","-","-"]
[74,null,null,null,null,"-","-","-",null,74,null,null,null,null,"-","-","-",null,74,null,null,null,null,"-","-","-"]
[75,null,null,null,null,"-","-","-",null,75,null,null,null,null,"-","-","-",null,75,null,null,null,null,"-","-","-"]
[76,null,null,null,null,"-","-","-",null,76,null,null,null,null,"-","-","-",null,76,null,null,null,null,"-","-","-"]
[77,null,null,null,null,"-","-","-",null,77,null,null,null,null,"-","-","-",null,77,null,null,null,null,"-","-","-"]
[78,null,null,null,null,"-","-","-",null,78,null,null,null,null,"-","-","-",null,78,null,null,null,null,"-","-","-"]
[79,null,null,null,null,"-","-","-",null,79,null,null,null,null,"-","-","-",null,79,null,null,null,null,"-","-","-"]
[80,null,null,null,null,"-","-","-",null,80,null,null,null,null,"-","-","-",null,80,null,null,null,null,"-","-","-"]
[81,null,null,null,null,"-","-","-",null,81,null,null,null,null,"-","-","-",null,81,null,null,null,null,"-","-","-"]
[82,null,null,null,null,"-","-","-",null,82,null,null,null,null,"-","-","-",null,82,null,null,null,null,"-","-","-"]
[83,null,null,null,null,"-","-","-",null,83,null,null,null,null,"-","-","-",null,83,null,null,null,null,"-","-","-"]
[84,null,null,null,null,"-","-","-",null,84,null,null,null,null,"-","-","-",null,84,null,null,null,null,"-","-","-"]
[85,null,null,null,null,"-","-","-",null,85,null,null,null,null,"-","-","-",null,85,null,null,null,null,"-","-","-"]
[86,null,null,null,null,"-","-","-",null,86,null,null,null,null,"-","-","-",null,86,null,null,null,null,"-","-","-"]
[87,null,null,null,null,"-","-","-",null,87,null,null,null,null,"-","-","-",null,87,null,null,null,null,"-","-","-"]
[88,null,null,null,null,"-","-","-",null,88,null,null,null,null,"-","-","-",null,88,null,null,null,null,"-","-","-"]
[89,null,null,null,null,"-","-","-",null,89,null,null,null,null,"-","-","-",null,89,null,null,null,null,"-","-","-"]
[90,null,null,null,null,"-","-","-",null,90,null,null,null,null,"-","-","-",null,90,null,null,null,null,"-","-","-"]
[91,null,null,null,null,"-","-","-",null,91,null,null,null,null,"-","-","-",null,91,null,null,null,null,"-","-","-"]
[92,null,null,null,null,"-","-","-",null,92,null,null,null,null,"-","-","-",null,92,null,null,null,null,"-","-","-"]
[93,null,null,null,null,"-","-","-",null,93,null,null,null,null,"-","-","-",null,93,null,null,null,null,"-","-","-"]
[94,null,null,null,null,"-","-","-",null,94,null,null,null,null,"-","-","-",null,94,null,null,null,null,"-","-","-"]
[95,null,null,null,null,"-","-","-",null,95,null,null,null,null,"-","-","-",null,95,null,null,null,null,"-","-","-"]
[96,null,null,null,null,"-","-","-",null,96,null,null,null,null,"-","-","-",null,96,null,null,null,null,"-","-","-"]
[97,null,null,null,null,"-","-","-",null,97,null,null,null,null,"-","-","-",null,97,null,null,null,null,"-","-","-"]
[98,null,null,null,null,"-","-","-",null,98,null,null,null,null,"-","-","-",null,98,null,null,null,null,"-","-","-"]
[99,null,null,null,null,"-","-","-",null,99,null,null,null,null,"-","-","-",null,99,null,null,null,null,"-","-","-"]
[100,null,null,null,null,"-","-","-",null,100,null,null,null,null,"-","-","-",null,100,null,null,null,null,"-","-","-"]
[101,null,null,null,null,"-","-","-",null,101,null,null,null,null,"-","-","-",null,101,null,null,null,null,"-","-","-"]
[102,null,null,null,null,"-","-","-",null,102,null,null,null,null,"-","-","-",null,102,null,null,null,null,"-","-","-"]
[103,null,null,null,null,"-","-","-",null,103,null,null,null,null,"-","-","-",null,103,null,null,null,null,"-","-","-"]
[104,null,null,null,null,"-","-","-",null,104,null,null,null,null,"-","-","-",null,104,null,null,null,null,"-","-","-"]
[105,null,null,null,null,"-","-","-",null,105,null,null,null,null,"-","-","-",null,105,null,null,null,null,"-","-","-"]
[106,null,null,null,null,"-","-","-",null,106,null,null,null,null,"-","-","-",null,106,null,null,null,null,"-","-","-"]
[107,null,null,null,null,"-","-","-",null,107,null,null,null,null,"-","-","-",null,107,null,null,null,null,"-","-","-"]
[108,null,null,null,null,"-","-","-",null,108,null,null,null,null,"-","-","-",null,108,null,null,null,null,"-","-","-"]
[109,null,null,null,null,"-","-","-",null,109,null,null,null,null,"-","-","-",null,109,null,null,null,null,"-","-","-"]
[110,null,null,null,null,"-","-","-",null,110,null,null,null,null,"-","-","-",null,110,null,null,null,null,"-","-","-"]
[111,null,null,null,null,"-","-","-",null,111,null,null,null,null,"-","-","-",null,111,null,null,null,null,"-","-","-"]
[112,null,null,null,null,"-","-","-",null,112,null,null,null,null,"-","-","-",null,112,null,null,null,null,"-","-","-"]
[113,null,null,null,null,"-","-","-",null,113,null,null,null,null,"-","-","-",null,113,null,null,null,null,"-","-","-"]
[114,null,null,null,null,"-","-","-",null,114,null,null,null,null,"-","-","-",null,114,null,null,null,null,"-","-","-"]
[115,null,null,null,null,"-","-","-",null,115,null,null,null,null,"-","-","-",null,115,null,null,null,null,"-","-","-"]
[116,null,null,null,null,"-","-","-",null,116,null,null,null,null,"-","-","-",null,116,null,null,null,null,"-","-","-"]
[117,null,null,null,null,"-","-","-",null,117,null,null,null,null,"-","-","-",null,117,null,null,null,null,"-","-","-"]
[118,null,null,null,null,"-","-","-",null,118,null,null,null,null,"-","-","-",null,118,null,null,null,null,"-","-","-"]
[119,null,null,null,null,"-","-","-",null,119,null,null,null,null,"-","-","-",null,119,null,null,null,null,"-","-","-"]
[120,null,null,null,null,"-","-","-",null,120,null,null,null,null,"-","-","-",null,120,null,null,null,null,"-","-","-"]
[121,null,null,null,null,"-","-","-",null,121,null,null,null,null,"-","-","-",null,121,null,null,null,null,"-","-","-"]
[122,null,null,null,null,"-","-","-",null,122,null,null,null,null,"-","-","-",null,122,null,null,null,null,"-","-","-"]
[123,null,null,null,null,"-","-","-",null,123,null,null,null,null,"-","-","-",null,123,null,null,null,null,"-","-","-"]
[124,null,null,null,null,"-","-","-",null,124,null,null,null,null,"-","-","-",null,124,null,null,null,null,"-","-","-"]
[125,null,null,null,null,"-","-","-",null,125,null,null,null,null,"-","-","-",null,125,null,null,null,null,"-","-","-"]
[126,null,null,null,null,"-","-","-",null,126,null,null,null,null,"-","-","-",null,126,null,null,null,null,"-","-","-"]
[127,null,null,null,null,"-","-","-",null,127,null,null,null,null,"-","-","-",null,127,null,null,null,null,"-","-","-"]
[128,null,null,null,null,"-","-","-",null,128,null,null,null,null,"-","-","-",null,128,null,null,null,null,"-","-","-"]
[129,null,null,null,null,{"$f":"IF(E135=0,\"-\",D135/E135)","v":"-"},{"$f":"IF(E135=0,\"-\",C135*F135)","v":"-"},{"$f":"IF(D135=0,\"-\",C135/E135)","v":"-"},null,129,null,null,null,null,{"$f":"IF(N135=0,\"-\",M135/N135)","v":"-"},{"$f":"IF(N135=0,\"-\",L135*O135)","v":"-"},{"$f":"IF(M135=0,\"-\",L135/N135)","v":"-"},null,129,null,null,null,null,{"$f":"IF(W135=0,\"-\",V135/W135)","v":"-"},{"$f":"IF(W135=0,\"-\",U135*X135)","v":"-"},{"$f":"IF(V135=0,\"-\",U135/W135)","v":"-"}]
[130,null,null,null,null,"-","-","-",null,130,null,null,null,null,"-","-","-",null,130,null,null,null,null,"-","-","-"]
[131,null,null,null,null,"-","-","-",null,131,null,null,null,null,"-","-","-",null,131,null,null,null,null,"-","-","-"]
[132,null,null,null,null,"-","-","-",null,132,null,null,null,null,"-","-","-",null,132,null,null,null,null,"-","-","-"]
[133,null,null,null,null,"-","-","-",null,133,null,null,null,null,"-","-","-",null,133,null,null,null,null,"-","-","-"]
[134,null,null,null,null,"-","-","-",null,134,null,null,null,null,"-","-","-",null,134,null,null,null,null,"-","-","-"]
[135,null,null,null,null,"-","-","-",null,135,null,null,null,null,"-","-","-",null,135,null,null,null,null,"-","-","-"]
[136,null,null,null,null,"-","-","-",null,136,null,null,null,null,"-","-","-",null,136,null,null,null,null,"-","-","-"]
[137,null,null,null,null,"-","-","-",null,137,null,null,null,null,"-","-","-",null,137,null,null,null,null,"-","-","-"]
[138,null,null,null,null,"-","-","-",null,138,null,null,null,null,"-","-","-",null,138,null,null,null,null,"-","-","-"]
[139,null,null,null,null,"-","-","-",null,139,null,null,null,null,"-","-","-",null,139,null,null,null,null,"-","-","-"]
[140,null,null,null,null,"-","-","-",null,140,null,null,null,null,"-","-","-",null,140,null,null,null,null,"-","-","-"]
[141,null,null,null,null,"-","-","-",null,141,null,null,null,null,"-","-","-",null,141,null,null,null,null,"-","-","-"]
[142,null,null,null,null,"-","-","-",null,142,null,null,null,null,"-","-","-",null,142,null,null,null,null,"-","-","-"]
[143,null,null,null,null,"-","-","-",null,143,null,null,null,null,"-","-","-",null,143,null,null,null,null,"-","-","-"]
[144,null,null,null,null,"-","-","-",null,144,null,null,null,null,"-","-","-",null,144,null,null,null,null,"-","-","-"]
[145,null,null,null,null,"-","-","-",null,145,null,null,null,null,"-","-","-",null,145,null,null,null,null,"-","-","-"]
[146,null,null,null,null,"-","-","-",null,146,null,null,null,null,"-","-","-",null,146,null,null,null,null,"-","-","-"]
[147,null,null,null,null,"-","-","-",null,147,null,null,null,null,"-","-","-",null,147,null,null,null,null,"-","-","-"]
[148,null,null,null,null,"-","-","-",null,148,null,null,null,null,"-","-","-",null,148,null,null,null,null,"-","-","-"]
[149,null,null,null,null,"-","-","-",null,149,null,null,null,null,"-","-","-",null,149,null,null,null,null,"-","-","-"]
[150,null,null,null,null,"-","-","-",null,150,null,null,null,null,"-","-","-",null,150,null,null,null,null,"-","-","-"]

{"sheet":"E.1.2.2","index":6,"n_rows":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,7],[3,1,3,3],[3,4,3,7]]}
[]
[null,"E 1.2.2 : Dépenses de fonctionnement directement rattachables à l'opération "]
[]
[null,"Les dotations aux amortissements seront éligibles prioritairement pour les projets collaboratifs",null,null,"Montants ventilés par année"]
[null,"Objet *","Détailler la naturedes dépenses prévues","Détailler les bases de calcul",{"$f":"\"Année \" & E.1.2!E5","v":"Année "},{"$f":"\"Année \" & E.1.2!F5","v":"Année "},{"$f":"\"Année \" & E.1.2!G5","v":"Année "},"Total"]
[null,"Achats et fournitures (consommables, petits équipements)",null,null,null,null,null,{"$f":"SUM(E6:G6)","v":0}]
[null,"Publications, communication",null,null,null,null,null,{"$f":"SUM(E7:G7)","v":0}]
[null,"Locaux : locations, entretien",null,null,null,null,null,0]
[null,"Déplacements, missions (hors participants)",null,null,null,null,null,0]
[null,"Dotations aux amortissements liées à l'opération et non financées par des financements publics)",null,null,null,null,null,0]
[null,"Total",null,null,{"$f":"SUM(E6:E10)","v":0},{"$f":"SUM(F6:F10)","v":0},0,{"$f":"SUM(E11:G11)","v":0}]

{"sheet":"E.1.2.3","index":7,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,7],[3,4,3,7]]}
[]
[null,"E 1.2.3 : Prestations externes et frais de sous traitance directement liées et nécessaires à l'opération"]
[]
[null,null,null,null,"Montants ventilés par année"]
[null,"Objet de la prestation externe","Détailler la nature               des dépenses prévues","Détailler le cas échéant        les bases de calcul",{"$f":"\"Année \" & E.1.2!E5","v":"Année "},{"$f":"\"Année \" & E.1.2!F5","v":"Année "},{"$f":"\"Année \" & E.1.2!G5","v":"Année "},"Total"]
[null,"Consultants formateurs",null,null,null,null,null,{"$f":"SUM(E6:G6)","v":0}]
[null,"Missions réceptions",null,null,null,null,null,{"$f":"SUM(E7:G7)","v":0}]
[null,"Communication – Publicité, impression de documents",null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,"Total",null,null,{"$f":"SUM(E6:E11)","v":0},{"$f":"SUM(F6:F11)","v":0},0,{"$f":"SUM(E12:G12)","v":0}]

{"sheet":"E.1.2.4","index":8,"n_rows":8,"n_cols":8,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,6],[3,4,3,7]]}
[]
[null,"E 1.2.4 : Dépenses en nature "]
[]
[null,null,null,null,"Montants valorisés par année"]
[null,"Objet","Détailler la nature des dépenses prévues","Détailler les bases de calcul",{"$f":"\"Année \" & E.1.2!E5","v":"Année "},{"$f":"\"Année \" & E.1.2!F5","v":"Année "},{"$f":"\"Année \" & E.1.2!G5","v":"Année "},"Total"]
[null,"Mise à disposition de biens immobiliers, d'équipement, de matières premières, …",null,null,null,null,null,{"$f":"SUM(E6:G6)","v":0}]
[null,"Mise à disposition de prestations, de personnels, travail bénévole, …",null,null,null,null,null,{"$f":"SUM(E7:G7)","v":0}]
[null,null,null,"Total",{"$f":"SUM(E6:E7)","v":0},{"$f":"SUM(F6:F7)","v":0},0,{"$f":"SUM(E8:G8)","v":0}]

{"sheet":"E.1","index":9,"n_rows":31,"n_cols":11,"rows_kept":31,"cut":false,"hidden":false,"merged":[[30,1,30,5],[32,2,37,11],[14,10,14,11],[16,10,16,11],[17,10,17,11],[27,7,28,7],[27,1,27,5],[28,1,28,5],[29,1,29,5],[27,6,28,6],[24,1,24,5],[25,1,25,5],[1,1,1,11],[3,1,3,11],[5,1,5,11],[11,10,11,11],[12,10,12,11],[7,2,7,3],[7,4,7,5],[7,6,7,7],[7,8,7,9],[7,10,7,11],[8,2,8,3],[8,4,8,5],[8,6,8,7],[8,8,8,9],[13,10,13,11],[22,2,22,3],[22,4,22,5],[22,6,22,7],[22,8,22,9],[22,10,22,11],[15,10,15,11]]}
[]
[null,"E - Budget prévisionnel de l'opération"]
[]
[null,"E 1 - Tableau récapitulatif des dépenses prévisionnelles *"]
[]
[null,"(hormis les champs en vert, les données sont renseignées automatiquement à partir des montants détaillés saisis dans les tableaux E1.2 à E1.2.4 et E.2.1)"]
[]
[]
[null,"Années / Exercices ",{"$f":"\"Année \" & E.1.2!E5","v":"Année "},null,{"$f":"\"Année \" & E.1.2!F5","v":"Année "},null,{"$f":"\"Année \" & E.1.2!G5","v":"Année "},null,"Total"]
[null,"Postes de dépenses","€","%","€","%","€","%","€","%"]
[null,"Dépenses directes (1+2+3+4)",{"$f":"SUM(C12:C15)","v":0},{"$f":"IF($C$19>0,C11/$C$19,0)","v":0},{"$f":"SUM(E12:E15)","v":0},{"$f":"IF($E$19>0,E11/$E$19,0)","v":0},{"$f":"SUM(G12:G15)","v":0},{"$f":"IF($G$19>0,G11/$G$19,0)","v":0},{"$f":"C11+E11+G11","v":0},{"$f":"IF($I$19>0,I11/$I$19,0)","v":0}]
[null,"1. Investissement",{"$f":"E.1.2!E12","v":0},{"$f":"IF($C$19>0,C12/$C$19,0)","v":0},{"$f":"E.1.2!F12","v":0},{"$f":"IF($E$19>0,E12/$E$19,0)","v":0},{"$f":"E.1.2!G12","v":0},{"$f":"IF($G$19>0,G12/$G$19,0)","v":0},{"$f":"C12+E12+G12","v":0},{"$f":"IF($I$19>0,I12/$I$19,0)","v":0},"cf onglet E 1.2"]
[null,"2. Personnel",{"$f":"E.1.2.1!G18","v":0},0,{"$f":"E.1.2.1!G30","v":0},0,{"$f":"E.1.2.1!G42","v":0},0,0,0,"cf onglet E 1.2.1"]
[null,"3. Fonctionnement",{"$f":"E.1.2.2!E11","v":0},0,{"$f":"E.1.2.2!F11","v":0},0,{"$f":"E.1.2.2!G11","v":0},0,0,0,"cf onglet E 1.2.2"]
[null,"4. Prestations externes",{"$f":"E.1.2.3!E12","v":0},0,{"$f":"E.1.2.3!F12","v":0},0,{"$f":"E.1.2.3!G12","v":0},0,0,0,"cf onglet E 1.2.3"]
[null,"5. Dépenses indirectes (forfait de 15 % des dépenses directes de personnel)",{"$f":"C13*0.15","v":0},null,{"$f":"E13*0.15","v":0},null,{"$f":"G13*0.15","v":0},null,0,null,"cf choix de l’onglet E0 FEDER"]
[null,"6. Dépenses en nature",{"$f":"E.1.2.4!E8","v":0},0,{"$f":"E.1.2.4!F8","v":0},0,{"$f":"E.1.2.4!G8","v":0},0,0,0,"cf onglet E 1.2.4"]
[null,"Recettes nettes déductibles (E.2.1)",{"$f":"E.2.1!B14","v":0},0,{"$f":"E.2.1!C14","v":0},0,{"$f":"E.2.1!D14","v":0},0,0,0,"cf onglet E 2.1"]
[null,"Dépenses totales",{"$f":"C11+C21","v":0},null,{"$f":"E11+E21","v":0},null,{"$f":"G11+G21","v":0},null,{"$f":"I11+I21","v":0}]
[]
[null,"choix15",{"$f":"IF(B21=\"choix15\",C16,0)","v":0},null,{"$f":"IF(B21=\"choix15\",E16,0)","v":0},null,{"$f":"IF(B21=\"choix15\",G16,0)","v":0},null,{"$f":"IF(B21=\"choix15\",I16,0)","v":0}]
[null,"Pour mémoire :"]
[null,"Coût du projet global dans lequel s'inscrit l'opération",null,null,null,null,null,null,{"$f":"C23+E23+G23","v":0}]
[]
[null,"► ces dépenses prévisionnelles sont présentées hors taxe : répondre par oui ou par non"]
[null,"Si l'organisme est assujetti à la TVA pour l'opération, les dépenses doivent être présentées HT."]
[]
[null,"► toutes ces dépenses sont elles supportées par votre organisme : répondre par oui ou par non"]
[null,"Contacter l'autorité de gestion"]
[null,"Si non indiquer les partenaires envisagés :"]
[null,"(pour rappel : le plan de financement pour chacun des bénéficiaires doit être équilibré)"]

{"sheet":"E.2.1","index":10,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[11,1,11,4],[15,2,15,3],[0,1,0,4],[1,1,1,5],[3,1,3,4],[5,1,5,4],[9,1,9,4]]}
[null,"E.2.1 - Calcul des recettes nettes"]
[null,"Ce tableau est à compléter par le porteur de projet, avec l'appui du service gestion,\n\nCas 1 : pour les opérations < 1M€ de coût total ou pour les opérations générant des recettes exclusivement durant la période de réalisation : les recettes sont à inscrire en auto financement (compléter le tableau n°1) \nExceptions - les recettes n'ont pas à apparaître lorsque : \n- un régime d'aides'applique ;\n- le coût total de l'opération est inférieure à 50 000 €.\n\nCas n°2 : pour les opérations > 1M€ qui génèrent des recettes nettes pendant et après la réalisation : les recettes nettes actualisées (voir mode de calcul avec le service gestion) sont à déduire des dépenses éligibles (compléter le tableau n°2)\nExceptions - les recettes n'ont pas à apparaître lorsque :\n- opération FSE ;\n- application De Minimis ;\n- aide d'Etat en faveur des PME ;\n- aide d'état compatible avec la vérification individuelle des besoins."]
[]
[null,"Tableau n°1 : Recettes à inscrire en auto financement"]
[]
[null,"Montants recettes nettes ventilés par année"]
[null,{"$f":"\"Année \" & E.1.2!E5","v":"Année "},{"$f":"\"Année \" & E.1.2!F5","v":"Année "},{"$f":"\"Année \" & E.1.2!G5","v":"Année "},"Total"]
[null,null,null,null,{"$f":"SUM(B8:D8)","v":0},"Ces montants sont reportés en E.2 sur la ligne ‘recettes générées’"]
[]
[null,"Tableau n°2 :Recettes nettes déductibles des dépenses éligibles"]
[]
[null,"Montants recettes nettes ventilés par année"]
[null,{"$f":"\"Année \" & E.1.2!E5","v":"Année "},{"$f":"\"Année \" & E.1.2!F5","v":"Année "},{"$f":"\"Année \" & E.1.2!G5","v":"Année "},"Total"]
[null,null,null,null,{"$f":"SUM(B14:D14)","v":0},"Ces montants sont reportés en E.1 sur la ligne ‘recettes nettes déductibles’"]

{"sheet":"E.2","index":11,"n_rows":65,"n_cols":11,"rows_kept":65,"cut":false,"hidden":false,"merged":[[62,10,62,11],[64,1,64,10],[1,1,1,9],[3,1,3,11],[6,8,6,9],[42,1,42,9],[44,1,44,9],[61,2,61,3],[61,4,61,5],[61,6,61,7],[61,8,61,9],[61,10,61,11],[62,2,62,3],[62,4,62,5],[62,6,62,7],[62,8,62,9],[56,2,56,3],[56,4,56,5],[56,6,56,7],[56,8,56,9],[56,10,56,11],[60,2,60,3],[60,4,60,5],[60,6,60,7],[60,8,60,9],[60,10,60,11],[54,2,54,3],[54,4,54,5],[54,6,54,7],[54,8,54,9],[54,10,54,11],[55,2,55,3],[55,4,55,5],[55,6,55,7],[55,8,55,9],[55,10,55,11],[52,2,52,3],[52,4,52,5],[52,6,52,7],[52,8,52,9],[52,10,52,11],[53,2,53,3],[53,4,53,5],[53,6,53,7],[53,8,53,9],[53,10,53,11],[50,2,50,3],[50,4,50,5],[50,6,50,7],[50,8,50,9],[50,10,50,11],[51,2,51,3],[51,4,51,5],[51,6,51,7],[51,8,51,9],[51,10,51,11],[48,2,48,3],[48,4,48,5],[48,6,48,7],[48,8,48,9],[48,10,48,11],[49,2,49,3],[49,4,49,5],[49,6,49,7],[49,8,49,9],[49,10,49,11],[31,1,40,11],[46,1,47,1],[46,2,46,5],[46,6,47,7],[46,8,47,9],[47,2,47,3],[47,4,47,5],[46,10,47,11],[28,1,28,11],[29,1,29,8],[6,2,6,3],[6,4,6,5],[6,6,6,7],[27,1,27,11],[24,10,24,12],[22,10,22,12]]}
[]
[null,"E.2 - Ressources prévisionnelles"]
[]
[null,"(hormis les champs en vert, les données sont renseignées automatiquement à partir des montants détaillés saisis dans les tableaux E2.1. et E.1.2.4)"]
[]
[]
[null,"Année/Exercice",{"$f":"\"Année \" & E.1.2!E5","v":"Année "},null,{"$f":"\"Année \" & E.1.2!F5","v":"Année "},null,{"$f":"\"Année \" & E.1.2!G5","v":"Année "},null,"Total"]
[null,"Financeurs (a)","€","%","€","%","€","%","€","%"]
[null,"1. Fonds européen",{"$f":"(E.1!C19-E.1!C17)-(C23+C24+C18+C10)","v":0},{"$f":"IF(C$26=0,\"-\",C9/C$26)","v":"-"},{"$f":"(E.1!E19-E.1!E17)-(E23+E24+E18+E10)","v":0},{"$f":"IF(E$26=0,\"-\",E9/E$26)","v":"-"},{"$f":"(E.1!G19-E.1!G17)-(G23+G24+G18+G10)","v":0},{"$f":"IF(G$26=0,\"-\",G9/G$26)","v":"-"},{"$f":"C9+E9+G9","v":0},{"$f":"IF(I$26=0,\"-\",I9/(I$26-$I$23))","v":"-"}]
[null,"2. Autres financements publics",{"$f":"SUM(C11:C17)","v":0},{"$f":"IF(C$26=0,\"-\",C10/C$26)","v":"-"},{"$f":"SUM(E11:E17)","v":0},{"$f":"IF(E$26=0,\"-\",E10/E$26)","v":"-"},{"$f":"SUM(G11:G17)","v":0},{"$f":"IF(G$26=0,\"-\",G10/G$26)","v":"-"},{"$f":"C10+E10+G10","v":0},{"$f":"IF(I$26=0,\"-\",I10/(I$26-$I$23))","v":"-"}]
[null,"     Région Languedoc-Roussillon",null,{"$f":"IF(C$26=0,\"-\",C11/C$26)","v":"-"},null,"-",null,"-",0,"-"]
[null,null,null,"-",null,"-",null,"-",0,"-"]
[null,null,null,"-",null,"-",null,"-",0,"-"]
[null,null,null,"-",null,"-",null,"-",0,"-"]
[null,null,null,"-",null,"-",null,"-",0,"-"]
[null,null,null,"-",null,"-",null,"-",0,"-"]
[null,null,null,"-",null,"-",null,"-",0,"-"]
[null,"3. Financements externes privés",{"$f":"SUM(C19:C21)","v":0},"-",{"$f":"SUM(E19:E21)","v":0},"-",{"$f":"SUM(G19:G21)","v":0},"-",0,"-"]
[null,null,null,"-",null,"-",null,"-",0,"-"]
[null,null,null,"-",null,"-",null,"-",0,"-"]
[null,null,null,"-",null,"-",null,"-",0,"-"]
[null,"4. Autofinancement",{"$f":"C24+C23","v":0},"-",{"$f":"E24+E23","v":0},"-",{"$f":"G24+G23","v":0},"-",0,"-"]
[null,"     Recettes générées (b)",{"$f":"E.2.1!B8","v":0},"-",{"$f":"E.2.1!C8","v":0},"-",{"$f":"E.2.1!D8","v":0},"-",0,"-","sommes récupérées en E.2.1"]
[null,"     Autre autofinancement",null,"-",null,"-",null,"-",0,"-"]
[null,"5. Apports en nature (c)",{"$f":"E.1.2.4!E8","v":0},"-",{"$f":"E.1.2.4!F8","v":0},"-",{"$f":"E.1.2.4!G8","v":0},"-",0,"-","sommes récupérées en E.1.2.4"]
[null,"Total des ressources (1+2+3+4+5) (d)",{"$f":"C9+C10+C18+C22+C25","v":0},"-",{"$f":"E9+E10+E18+E22+E25","v":0},"-",{"$f":"G9+G10+G18+G22+G25","v":0},"-",{"$f":"C26+E26+G26","v":0},"-"]
[]
[]
[null,"(a) Détailler une ligne par source de financement, y compris pour les apports privés externes (fondation, mécène, sponsor, ...)                                                                                                                                                                                                                 (b) Ex. : droits d'inscription, droits d'entrée, ventes,... Expliquer l'origine et la base de calcul ci-dessous.                                                                                                                                                                                                                                               (c) Le montant des apports en nature doit être identique à celui mentionné à la ligne \"Dépenses en nature\" du tableau de synthèse des dépenses prévisionnelles.                                                                                                                                                                    (d) Pour chaque année, le total des ressources doit être identique à celui des dépenses totales prévisionnelles (E1)"]
[null,"► le cas échéant, préciser l'origine des recettes, le mode de calcul et la période au cours de laquelle elle seront générées :                                                                                         En cas d'exclusion justifier le cas de figure."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"► les autres financements externes sollicités couvrent-ils la même période d'exécution et la même assiette de dépenses éligibles ? (oui/non)"]
[]
[null,"Si non, préciser les périodes et les assiettes par financeur :"]
[]
[null,"Financeurs","Période couverte",null,null,null,"Coût total subventionné",null,"Montant total de la subvention",null,"Observations\n(distorsions d'assiette)"]
[null,null,"Début",null,"Fin"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"► Tableau récapitulatif général"]
[]
[null,"Années",{"$f":"E.1.2!E5","v":0},null,{"$f":"E.1.2!F5","v":0},null,{"$f":"E.1.2!G5","v":0},null,"Total"]
[null,"Total des dépenses",{"$f":"E.1!C19","v":0},null,{"$f":"E.1!E19","v":0},null,{"$f":"E.1!G19","v":0},null,{"$f":"E.1!I19","v":0},null,"données récupérées en E.1 "]
[null,"Total des ressources",{"$f":"C26","v":0},null,{"$f":"E26","v":0},null,{"$f":"G26","v":0},null,{"$f":"I26","v":0},null,"données récupérées ci-dessus "]
[]
[null,"Le total des ressources doit obligatoirement être équilibré avec le total des dépenses éligibles (tableau E1), pour chaque année et globalement"]

{"sheet":"Impression","index":12,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,4,1,6],[4,1,4,6],[6,1,6,6],[8,1,8,6],[1,1,1,2],[2,2,3,5]]}
[]
[null,null,null,null,"FEDER/FSE\nProgramme Opérationnel Languedoc Roussillon\n2014/2020"]
[null,null,"Finalisation et impression du plan de financement FEDER"]
[]
[null,"Vous êtes désormais sur la page qui vous permet d'imprimer votre plan de financement. A ce stade, vous pouvez toujours modifier les informations renseignées.\n\nUne fois votre saisie terminée, il ne vous reste plus qu'à joindre ce document à votre dossier de demande de subvention FEDER en l'ayant préalablement enregistré au format XLS ou XLSX  ( en effet le portail e-Synergie refuse les documents XLSM ). Merci"]
[]
[]
[]
[null,"Attention. Veuillez ne pas  imprimer via les cheminements habituels de Microsoft :\nraccourci clavier ou menu fichier / imprimer. \nEn effet, cela aurait pour effet d'imprimer toutes les feuilles de ce classeur  et non pas seulement celles dont vous avez réellement besoin."]

{"sheet":"Feuil12","index":13,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
[]
["Oui",null,2014]
["Non",null,2015]
[null,null,2016]
[null,null,2017]
[null,null,2018]
[null,null,2019]
[null,null,2020]