{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Aide","Dépenses prévisionnelles","Ressources","Frais de personnel ","Ventilation par années","Fiche Navette 2","Listes","liste déroulante","FN1 ","Feuil3"],"not_rendered":{"charts":0,"images":8,"macros":1,"external_links":2,"defined_names":6,"comments":1,"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":"Aide","index":0,"n_rows":85,"n_cols":9,"rows_kept":85,"cut":false,"hidden":false,"merged":[[12,8,13,12],[18,3,22,8],[14,8,15,10]]}
["Comment remplir l'annexe Plan de financement ?"]
[]
["Cette annexe est composée de quatre onglets interdépendants :"]
[null,"1/ dépenses prévisionnelles"]
[null,"2/ ressources"]
[null,"3/ frais de personnel"]
[null,"4/ ventilation par années"]
[]
["Dans chaque onglet, le porteur de projet peut insérer de nouvelles lignes lorsque cela s'avère nécessaire. Les formules toutefois sont pré-définies et ne peuvent pas être modifiées."]
["Des explications précises sur les modalités de justifications des dépenses et des ressources (et notamment des formules de calculs) sont disponibles dans les fiches pratiques du Guide du porteur."]
[]
[]
["Dans la plupart des onglets, il est possible : ",null,null,null,null,null,null,null,"1/ de développer ou réduire des champs en cliquant sur les \"+\" apparaissant à gauche de l'écran :"]
[]
[null,null,null,null,null,null,null,null,"Cette fonctionnalité permet d'obtenir des tableaux synthétiques."]
[]
[]
[]
[null,null,null,"2/ De sélectionner une réponse parmi une liste déroulante de choix. Dans ce cas, un commentaire en jaune apparaît pour vous indiquer la réponse attendue. Pour sélectionner une des options de la liste, cliquer sur la flèche apparaissant en  bas à droite de la cellule."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Dans certains onglets, des montants sont renseignés automatiquement lorsque les autres sont remplis. Par exemple :"]
[]
["La ligne dépenses directes de personnel est renseignée automatiquement à partir de l'onglet \"frais de personnel\". Aucun montant ne peut être saisi à la main dans cette case."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["La partie \"dépenses\" de l'onglet \"ressources\" est automatiquement renseignée à partir des informations issues de l'onget \"dépenses prévisionnelles\" :"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["N'hésitez pas à vous appuyer sur votre animateur référent sur le Massif central, ainsi que l'instructeur FEDER du GIP Massif central pour les points les plus complexes de votre demande de subvention."]

{"sheet":"Dépenses prévisionnelles","index":1,"n_rows":288,"n_cols":32,"rows_kept":288,"cut":false,"hidden":false,"merged":[[12,8,12,27],[12,29,12,31],[1,3,1,4],[2,3,2,4],[3,3,3,4],[4,3,4,4],[10,3,10,4],[1,6,3,27],[4,6,4,27],[8,1,8,27],[14,1,14,27],[46,1,46,27],[80,1,80,27],[144,2,144,5],[145,1,145,27],[273,2,273,5],[274,1,274,5],[112,2,112,5],[45,2,45,5],[79,2,79,5],[113,1,113,27],[177,2,177,5],[210,1,210,27],[241,2,241,5],[242,1,242,27],[178,1,178,27],[209,2,209,5],[47,1,53,1],[54,1,60,1],[287,3,287,4],[277,3,277,4],[279,3,279,4],[281,3,281,4],[283,3,283,4],[285,3,285,4]]}
[]
[null,null,"Intitulé de l'opération",null,null,null,"Annexe 1 : Plan de financement\nProgrammation FEDER Massif central 2014-2020\nConvention interrégionale du Massif central"]
[null,null,"Bénéficiaire"]
[null,null,"N° administratif du dossier"]
[null,null,"Dates de début et de fin de l'opération",null,null,null,"Cadre règlementaire : Programme Opérationnel Interrégionnal FEDER Massif central 2014-2020, Convention interrégionale du Massif central"]
[]
[]
[]
[null,"Onglet 1 - Tableau récapitulatif des dépenses prévisionnelles de l'opération"]
[]
[null,"Le montant des dépenses est déclaré :",null,"-"]
[]
[null,null,null,null,null,null,null,null,"Ventilation par action\n(le cas échéant)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A renseigner par le service instructeur\n(lors de l'instruction du dossier)"]
[null,"Poste de dépenses","Sous catégories de dépense","N° de facture ou de devis","Coût unitaire\n(reporter le coût unitaire, sa méthode de calcul le cas échéant et sa nature (prestation, barème kilométrique, forfait repas…))","Nombre d'unités (Temps ou pourcentage prévisionnel consacré au projet, nombre de prestations prévues, nombre de KM parcourus, etc)","Explication de la base de calcul et de la clé de répartition retenue","Montant prévisionnel total","Action\n1","Action\n2","Action\n3","Action\n4","Action\n5","Action\n6","Action\n7","Action\n8","Action\n9","Action\n10","Action\n11","Action\n12","Action\n13","Action\n14","Action\n15","Action\n16","Action\n17","Action\n18","Action\n19","Action\n20",null,"Montant proposé en vue de la programmation","Motif en cas d'écart (ex : dépenses inéligibles)","Postes de dépenses forfaitisées : O/N"]
[null,"Dépenses directes de personnel "]
[null,null,"Salaires bruts chargés",null,null,null,"Cf onglet \"Frais de personnel\"",{"$f":"'[1]Frais de personnel (2)'!I123","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Total du poste",null,null,null,null,{"$f":"SUM(H16:H45)","v":0},{"$f":"SUM(I16:I45)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(AD16:AD45)","v":0}]
[null,"Frais de mission du personnel"]
[null,null,"Déplacements transports en commun",null,"\n\n\n\n\n",null,""]
[null,null,"Déplacements véhicules personnels ou de service"]
[null,null,"Location de voiture spécifique à l'action"]
[null,null,"Frais d'essence pour la location voiture spécifique à l'action"]
[null,null,"Repas"]
[null,null,"Nuitées"]
[null,null,"Péages"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,"Total du poste",null,null,null,null,{"$f":"SUM(H48:H79)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(AD48:AD79)","v":0}]
[null,"Coûts indirects"]
[null,null,"Taux forfaitaire (associations exclusivement - hors fonds Etat)",null,null,"15% des dépenses directes de personnel (ligne 17)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Total du poste",null,null,null,null,{"$f":"SUM(H82:H112)","v":0},{"$f":"SUM(I82:I112)","v":0},{"$f":"SUM(J82:J112)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(AD82:AD112)","v":0}]
[null,"Prestations externes"]
[null,null,"Communication"]
[]
[null,null,"Conseil"]
[]
[null,null,"Etudes"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Total du poste",null,null,null,null,{"$f":"SUM(H115:H144)","v":0},{"$f":"SUM(I115:I144)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(AD115:AD144)","v":0}]
[null,"Investissements matériels et immatériels"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Total du poste",null,null,null,null,{"$f":"SUM(H147:H177)","v":0},{"$f":"SUM(I147:I177)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(AD147:AD177)","v":0}]
[null,"Acquisitions foncières et immobilières"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Total du poste",null,null,null,null,{"$f":"SUM(H180:H209)","v":0},{"$f":"SUM(I180:I209)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(AD180:AD209)","v":0}]
[null,"Apports en nature"]
[null,null,"Bénévolat, mise à disposition gracieuse de personnel, prêt de salle, etc"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Total du poste",null,null,null,null,{"$f":"SUM(H212:H241)","v":0},{"$f":"SUM(I212:I241)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(AD212:AD241)","v":0}]
[null,"Autres dépenses (à spécifier)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Total du poste",null,null,null,null,{"$f":"SUM(H244:H273)","v":0},{"$f":"SUM(I244:I273)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(AD244:AD273)","v":0}]
[null,"TOTAL dépenses prévisionnelles",null,null,null,null,null,{"$f":"H46+H80+H113+H145+H178+H210+H242+H274","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"AD274+AD242+AD210+AD178+AD145+AD113+AD80+AD46","v":0}]
[]
[null,null,"Prise en compte des frais "]
[null,null,"Les frais de personnel :","-"]
[]
[null,null,"Les frais kilométriques :","-"]
[]
[null,null,"Les autres frais de déplacement (péages, transport en commun, etc.) :","-"]
[]
[null,null,"Les repas :","-"]
[]
[null,null,"Nuitées :","-"]
[]
[null,null,"frais de structure :","-"]

{"sheet":"Ressources","index":2,"n_rows":51,"n_cols":18,"rows_kept":51,"cut":false,"hidden":false,"merged":[[47,12,47,13],[48,12,48,13],[13,12,13,17],[30,12,36,12],[37,12,37,13],[38,12,38,17],[41,12,41,13],[42,12,42,17],[14,12,14,17],[16,12,21,12],[22,12,23,12],[24,12,29,12],[1,6,3,10],[4,6,4,10],[7,1,7,10],[13,5,13,10],[13,1,13,3],[50,1,50,10],[37,5,37,6],[41,5,41,6],[47,5,47,6],[14,5,14,10],[38,5,38,10],[42,5,42,10],[48,5,48,6],[22,5,23,5],[24,5,29,5],[30,5,36,5],[16,5,21,5]]}
[]
[null,null,"Intitulé de l'opération",{"$f":"'Dépenses prévisionnelles'!D2:E2","v":0},null,null,"Annexe 1 : Plan de financement\nProgrammation FEDER Massif central 2014-2020\nConvention interrégionale du Massif central"]
[null,null,"Bénéficiaire",{"$f":"'Dépenses prévisionnelles'!D3:E3","v":0}]
[null,null,"N° administratif du dossier",{"$f":"'Dépenses prévisionnelles'!D4:E4","v":0}]
[null,null,"Dates de début et de fin de l'opération",{"$f":"'Dépenses prévisionnelles'!D5:E5","v":0},null,null," Cadre réglementaire : Programme Opérationnel Interrégionnal FEDER Massif central, Convention interrégionale du Massif central"]
[]
[]
[null,"Onglet 2 - Tableau des ressources prévisionnelles de l'opération"]
[]
[null,"Les co-financements sollicités couvrent-ils la même période d'exécution et la même assiette de dépenses éligibles ? "]
[]
[]
[null,"Catégories de dépenses","Montant","%",null,"Nature des financements","Nom du financeur","Précisions (date et références d'obtention de l'aide : délibération, arrêté, convention...)","Montant (euros)","Assiette retenue par le cofinanceur","%",null,"Nature des financements","Nom du financeur","Précisions (date et références d'obtention de l'aide : délibération, arrêté, convention...)","Montant (euros)","Assiette retenue par le cofinanceur","%"]
[null,"Informations reportées automatiquement à partir de l'onglet \"Dépenses prévisionnelles\"",null,null,null,"Informations à remplir par le porteur de projet",null,null,null,null,null,null,"A renseigner par le service instructeur"]
[null,{"$f":"'Dépenses prévisionnelles'!B15:AB15","v":"Dépenses directes de personnel "},{"$f":"'Dépenses prévisionnelles'!H46","v":0},{"$f":"IF(C$49=0,\"-\",C15/(C$49))","v":"-"},null,"FINANCEMENTS PUBLICS",null,null,null,null,null,null,"FINANCEMENTS PUBLICS"]
[null,{"$f":"'Dépenses prévisionnelles'!B47:AB47","v":"Frais de mission du personnel"},{"$f":"'Dépenses prévisionnelles'!H80","v":0},"-",null,"FEDER","POI Massif central",null,null,{"$f":"C49","v":0},{"$f":"IF(I$49=0,\"-\",I16/(I$49))","v":"-"},null,"FEDER","POI Massif central",null,null,{"$f":"J49","v":0},{"$f":"IF(P$49=0,\"-\",P16/(P$49))","v":"-"}]
[null,{"$f":"'Dépenses prévisionnelles'!B81:AB81","v":"Coûts indirects"},{"$f":"'Dépenses prévisionnelles'!H113","v":0},"-",null,"REGIONS",null,null,null,null,"-",null,"REGIONS",null,null,null,null,"-"]
[null,{"$f":"'Dépenses prévisionnelles'!B114:AB114","v":"Prestations externes"},{"$f":"'Dépenses prévisionnelles'!H145","v":0},"-",null,null,null,null,null,null,"-",null,null,null,null,null,null,"-"]
[null,{"$f":"'Dépenses prévisionnelles'!B146:AB146","v":"Investissements matériels et immatériels"},{"$f":"'Dépenses prévisionnelles'!H178","v":0},"-",null,null,null,null,null,null,"-",null,null,null,null,null,null,"-"]
[null,{"$f":"'Dépenses prévisionnelles'!B179:AB179","v":"Acquisitions foncières et immobilières"},{"$f":"'Dépenses prévisionnelles'!H210","v":0},"-",null,null,null,null,null,null,"-",null,null,null,null,null,null,"-"]
[null,{"$f":"'Dépenses prévisionnelles'!B211:AB211","v":"Apports en nature"},{"$f":"'Dépenses prévisionnelles'!H242","v":0},"-",null,null,null,null,null,null,"-",null,null,null,null,null,null,"-"]
[null,{"$f":"'Dépenses prévisionnelles'!B243:AB243","v":"Autres dépenses (à spécifier)"},{"$f":"'Dépenses prévisionnelles'!H274","v":0},"-",null,null,null,null,null,null,"-",null,null,null,null,null,null,"-"]
[null,"Total des dépenses ",{"$f":"SUM(C15:C22)","v":0},{"$f":"IF(C23=0,0,C23/C23)","v":0},null,"ETAT",null,null,null,null,"-",null,"ETAT",null,null,null,null,"-"]
[null,"Recettes nettes générées par l'opération (*)",null,0,null,null,null,null,null,null,"-",null,null,null,null,null,null,"-"]
[null,"Total des recettes nettes",{"$f":"C24","v":0},{"$f":"IF(C25=0,0,C25/D23)","v":0},null,"DEPARTEMENTS",null,null,null,null,"-",null,"DEPARTEMENTS",null,null,null,null,"-"]
[null,null,null,null,null,null,null,null,null,null,"-",null,null,null,null,null,null,"-"]
[null,null,null,null,null,null,null,null,null,null,"-",null,null,null,null,null,null,"-"]
[null,null,null,null,null,null,null,null,null,null,"-",null,null,null,null,null,null,"-"]
[null,null,null,null,null,null,null,null,null,null,"-",null,null,null,null,null,null,"-"]
[null,null,null,null,null,null,null,null,null,null,"-",null,null,null,null,null,null,"-"]
[null,null,null,null,null,"Autres financeurs publics (à préciser)",null,null,null,null,"-",null,"Autres financeurs publics (à préciser)",null,null,null,null,"-"]
[null,null,null,null,null,null,null,null,null,null,"-",null,null,null,null,null,null,"-"]
[null,null,null,null,null,null,null,null,null,null,"-",null,null,null,null,null,null,"-"]
[null,null,null,null,null,null,null,null,null,null,"-",null,null,null,null,null,null,"-"]
[null,null,null,null,null,null,null,null,null,null,"-",null,null,null,null,null,null,"-"]
[null,null,null,null,null,null,null,null,null,null,"-",null,null,null,null,null,null,"-"]
[null,null,null,null,null,null,null,null,null,null,"-",null,null,null,null,null,null,"-"]
[null,null,null,null,null,"TOTAL FINANCEMENTS PUBLICS",null,null,{"$f":"SUM(I16:I37)","v":0},null,"-",null,"TOTAL FINANCEMENTS PUBLICS",null,null,{"$f":"SUM(P16:P37)","v":0},null,"-"]
[null,null,null,null,null,"FINANCEMENTS PRIVES",null,null,null,null,null,null,"FINANCEMENTS PRIVES"]
[null,null,null,null,null,"Financement privé (à préciser)",null,null,null,null,{"$f":"IF(I$49=0,\"-\",I40/(I$49))","v":"-"},null,"Financement privé (à préciser)",null,null,null,null,{"$f":"IF(P$49=0,\"-\",P40/(P$49))","v":"-"}]
[null,null,null,null,null,"Financement privé (à préciser)",null,null,null,null,{"$f":"IF(I$49=0,\"-\",I41/(I$49))","v":"-"},null,"Financement privé (à préciser)",null,null,null,null,{"$f":"IF(P$49=0,\"-\",P41/(P$49))","v":"-"}]
[null,null,null,null,null,"TOTAL FINANCEMENTS PRIVES",null,null,{"$f":"SUM(I40:I41)","v":0},null,{"$f":"IF(I$49=0,\"-\",I42/(I$49))","v":"-"},null,"TOTAL FINANCEMENTS PRIVES",null,null,{"$f":"SUM(P40:P41)","v":0},null,{"$f":"IF(P$49=0,\"-\",P42/(P$49))","v":"-"}]
[null,null,null,null,null,"AUTOFINANCEMENT",null,null,null,null,null,null,"AUTOFINANCEMENT"]
[null,null,null,null,null,"Ressources propres",null,null,null,null,{"$f":"IF(I$49=0,\"-\",I44/(I$49))","v":"-"},null,"Ressources propres",null,null,null,null,{"$f":"IF(P$49=0,\"-\",P44/(P$49))","v":"-"}]
[null,null,null,null,null,"Emprunts",null,null,null,null,"-",null,"Emprunts",null,null,null,null,{"$f":"IF(P$49=0,\"-\",P45/(P$49))","v":"-"}]
[null,null,null,null,null,"Apports en nature",null,null,null,null,"-",null,"Apports en nature",null,null,null,null,{"$f":"IF(P$49=0,\"-\",P46/(P$49))","v":"-"}]
[null,null,null,null,null,"Recettes",null,null,null,null,"-",null,"Recettes",null,null,null,null,{"$f":"IF(P$49=0,\"-\",P47/(P$49))","v":"-"}]
[null,null,null,null,null,"TOTAL AUTOFINANCEMENT",null,null,{"$f":"SUM(I44:I47)","v":0},null,"-",null,"TOTAL AUTOFINANCEMENT",null,null,{"$f":"SUM(P44:P47)","v":0},null,{"$f":"IF(P$49=0,\"-\",P48/(P$49))","v":"-"}]
[null,"Coût total éligible",{"$f":"C23-C24","v":0},{"$f":"IF(C$49=0,\"-\",C49/(C$49))","v":"-"},null,"Total des ressources",null,null,{"$f":"I38+I42+I48","v":0},null,"-",null,"Total des ressources",null,null,{"$f":"'Dépenses prévisionnelles'!AD275","v":0},null,1]
[null,null,null,null,null,null,null,null,{"$f":"I49-C49","v":0}]
[null,"(*) Le traitement des recettes nettes générées par l'opération varie selon le coût total éligible de l'opération ainsi que de la période durant laquelle elles sont générées.                                                                                                                                                                                                                              \nDans le cas où le projet devrait générer des recettes uniquement durant la période d'exécution de l'opération et que le coût total éligible dépasse 50 000€, alors les recettes prévisionnelles totales doivent être saisies dans cette case, sur la base de l'estimation des recettes réalisée dans l'annexe 5 - Méthode 2. \nDans le cas où le projet devrait générer des recettes au-delà de la période d'exécution de l'opération et si le coût total dépasse un million d'euros, l'assiette éligible doit être définie selon la méthode dite du \"déficit de financement\" (méthode 1 annexe 5). L'assiette éligible du projet est alors estimée dans l'annexe 5 et il n'est pas utile de renseigner la case \"recettes\" du tableau ci-dessus."]

{"sheet":"Frais de personnel ","index":3,"n_rows":123,"n_cols":18,"rows_kept":123,"cut":false,"hidden":false,"merged":[[1,3,1,5],[1,7,3,15],[2,3,2,5],[3,3,3,5],[4,3,4,5],[4,7,4,15],[5,6,5,15],[7,1,7,15],[10,1,10,15],[14,1,15,1],[14,2,15,2],[14,3,15,3],[14,4,15,4],[14,5,15,5],[14,6,15,6],[14,7,15,7],[14,8,15,8],[14,9,15,9],[14,10,15,10],[14,11,15,11],[17,1,17,2],[17,4,17,5],[17,7,17,8],[50,12,51,12],[50,1,51,1],[50,2,51,2],[50,3,51,3],[50,4,51,4],[50,5,51,5],[50,6,51,6],[50,7,51,7],[50,8,51,8],[50,9,51,9],[50,10,51,10],[50,11,51,11],[53,1,53,2],[53,4,53,5],[53,7,53,8],[86,1,87,1],[86,2,87,2],[86,3,87,3],[86,4,87,4],[86,5,87,5],[86,6,87,6],[86,7,87,7],[120,1,120,15],[122,1,122,7],[122,8,122,9],[86,14,87,14],[86,15,87,15],[89,1,89,2],[89,4,89,5],[89,7,89,8],[89,10,89,12],[86,8,87,8],[86,9,87,9],[86,10,87,10],[86,11,87,11],[86,12,87,12],[86,13,87,13]]}
[]
[null,null,"Intitulé de l'opération",{"$f":"'Dépenses prévisionnelles'!D2:E2","v":0},null,null,null,"Annexe 1 : Plan de financement\nProgrammation FEDER Massif central 2014-2020\nConvention interrégionale du Massif central",null,null,null,null,null,null,null,null,null,"-"]
[null,null,"Bénéficiaire",{"$f":"'Dépenses prévisionnelles'!D3:E3","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"Mensuelle"]
[null,null,"N° administratif du dossier",{"$f":"'Dépenses prévisionnelles'!D4:E4","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"Annuelle"]
[null,null,"Dates de début et de fin de l'opération",{"$f":"'Dépenses prévisionnelles'!D5:E5","v":0},null,null,null,"Cadre règlementaire : Programme Opérationnel Interrégionnal FEDER Massif central 2014-2020, Convention interrégionale du Massif central"]
[]
[]
[null,"Cette annexe permet au porteur de projet d'estimer les dépenses de personnel liées à l'opération. Une fois rempli, ce tableau permet de renseigner la ligne \"dépenses de personnel\" dans les onglets \"dépenses prévisionnelles\" et \"ressources\".\nNe remplir que les zones colorés en vert clair."]
[]
[]
[null,"Onglet 3 - Tableau récapitulatif des dépenses directes de personnel prévisionnelles"]
[]
[]
[null,"Salariés à temps plein sur l'opération"]
[null,"Intitulé du poste","Nom de la personne en poste le cas échéant","Base mensuelle ou annuelle","Salaire brut","Charges patronales","Salaire brut chargé","Emplois aidés : préciser le montant de l'aide","Taxe sur les salaires","Part du salaire à prendre en compte","Nombre de mois sur l'opération","Coût prévisionnel total par poste"]
[]
[null,null,null,null,"(1)","(2)","(3)","(4)","(5)","(6)","(7)","(10)"]
[null,null,null,"Sélectionner dans la liste déroulante","Référence : dernier coût annuel ou prévisionnelsi nouvelle embauche",null,"(1) + (2)","A remplir le cas échéant",null,"(3) - (4) - (5)","Référence : prévisionnel","(8) x (9)"]
[null,null,null,"-",null,null,{"$f":"E19+F19","v":0},0,0,{"$f":"G19-H19-I19","v":0},null,{"$f":"IF(J19=0,0,J19*K19)","v":0}]
[null,null,null,"-",0,0,0,0,0,0,null,0]
[null,null,null,"-",0,0,0,0,0,0,null,0]
[null,null,null,"-",0,0,0,0,0,0,null,0]
[null,null,null,"-",0,0,0,0,0,0,null,0]
[null,null,null,"-",0,0,0,0,0,0,null,0]
[null,null,null,"-",0,0,0,0,0,0,null,0]
[null,null,null,"-",0,0,0,0,0,0,null,0]
[null,null,null,"-",0,0,0,0,0,0,null,0]
[null,null,null,"-",0,0,0,0,0,0,null,0]
[null,null,null,"-",0,0,0,0,0,0,null,0]
[null,null,null,"-",0,0,0,0,0,0,null,0]
[null,null,null,"-",0,0,0,0,0,0,null,0]
[null,null,null,"-",0,0,0,0,0,0,null,0]
[null,null,null,"-",0,0,0,0,0,0,null,0]
[null,null,null,"-",0,0,0,0,0,0,null,0]
[null,null,null,"-",0,0,0,0,0,0,null,0]
[null,null,null,"-",0,0,0,0,0,0,null,0]
[null,null,null,"-",0,0,0,0,0,0,null,0]
[null,null,null,"-",0,0,0,0,0,0,null,0]
[null,null,null,"-",0,0,0,0,0,0,null,0]
[null,null,null,"-",0,0,0,0,0,0,null,0]
[null,null,null,"-",0,0,0,0,0,0,null,0]
[null,null,null,"-",0,0,0,0,0,0,null,0]
[null,null,null,"-",0,0,0,0,0,0,null,0]
[null,null,null,"-",0,0,0,0,0,0,null,0]
[null,null,null,"-",0,0,0,0,0,0,null,0]
[null,null,null,"-",0,0,0,0,0,0,null,0]
[null,null,null,"-",0,0,0,0,0,0,null,0]
[null,null,null,"-",0,0,0,0,0,0,null,0]
[]
[null,"Salariés dont le temps de travail est affecté en partie à l'opération et dont le prorata est prédéfini dans le contrat de travail ou la lettre de mission"]
[null,"Intitulé du poste","Nom de la personne en poste le cas échéant","Base mensuelle ou annuelle","Salaire brut","Charges patronales","Salaire brut chargé","Emplois aidés : préciser le montant de l'aide","Taxe sur les salaires","Part du salaire à prendre en compte","Nombre de mois sur l'opération","% temps de travail prévu sur l'opération","Coût prévisionnel total par poste"]
[]
[null,null,null,null,"(1)","(2)","(3)","(4)","(5)","(6)","(7)","(8)","(9)"]
[null,null,null,"Sélectionner dans la liste déroulante","Référence : dernier coût annuel ou prévisionnelsi nouvelle embauche",null,"(1) + (2)","A remplir le cas échéant",null,"(3) - (4) - (5)","A remplir si base mensuelle uniquement","A remplir si base mensuelle ou annuelle","(6) x (7) x (8)"]
[null,null,null,"-",0,0,{"$f":"E55+F55","v":0},0,0,{"$f":"G55-H55-I55","v":0},null,null,{"$f":"IF(D55=Listes!$A$69,'Frais de personnel '!J55*'Frais de personnel '!K55*'Frais de personnel '!L55,'Frais de personnel '!J55*'Frais de personnel '!L55)","v":0}]
[null,null,null,"-",0,0,0,0,0,0,null,null,{"$f":"IF(D56=Listes!$A$69,'Frais de personnel '!J56*'Frais de personnel '!K56*'Frais de personnel '!L56,'Frais de personnel '!J56*'Frais de personnel '!L56)","v":0}]
[null,null,null,"-",0,0,0,0,0,0,null,null,{"$f":"IF(D57=Listes!$A$69,'Frais de personnel '!J57*'Frais de personnel '!K57*'Frais de personnel '!L57,'Frais de personnel '!J57*'Frais de personnel '!L57)","v":0}]
[null,null,null,"-",0,0,0,0,0,0,null,null,{"$f":"IF(D58=Listes!$A$69,'Frais de personnel '!J58*'Frais de personnel '!K58*'Frais de personnel '!L58,'Frais de personnel '!J58*'Frais de personnel '!L58)","v":0}]
[null,null,null,"-",0,0,0,0,0,0,null,null,{"$f":"IF(D59=Listes!$A$69,'Frais de personnel '!J59*'Frais de personnel '!K59*'Frais de personnel '!L59,'Frais de personnel '!J59*'Frais de personnel '!L59)","v":0}]
[null,null,null,"-",0,0,0,0,0,0,null,null,{"$f":"IF(D60=Listes!$A$69,'Frais de personnel '!J60*'Frais de personnel '!K60*'Frais de personnel '!L60,'Frais de personnel '!J60*'Frais de personnel '!L60)","v":0}]
[null,null,null,"-",0,0,0,0,0,0,null,null,{"$f":"IF(D61=Listes!$A$69,'Frais de personnel '!J61*'Frais de personnel '!K61*'Frais de personnel '!L61,'Frais de personnel '!J61*'Frais de personnel '!L61)","v":0}]
[null,null,null,"-",0,0,0,0,0,0,null,null,{"$f":"IF(D62=Listes!$A$69,'Frais de personnel '!J62*'Frais de personnel '!K62*'Frais de personnel '!L62,'Frais de personnel '!J62*'Frais de personnel '!L62)","v":0}]
[null,null,null,"-",0,0,0,0,0,0,null,null,{"$f":"IF(D63=Listes!$A$69,'Frais de personnel '!J63*'Frais de personnel '!K63*'Frais de personnel '!L63,'Frais de personnel '!J63*'Frais de personnel '!L63)","v":0}]
[null,null,null,"-",0,0,0,0,0,0,null,null,{"$f":"IF(D64=Listes!A63,'Frais de personnel '!J64*'Frais de personnel '!K64*'Frais de personnel '!L64,'Frais de personnel '!J64*'Frais de personnel '!L64)","v":0}]
[null,null,null,"-",0,0,0,0,0,0,null,null,{"$f":"IF(D65=Listes!A64,'Frais de personnel '!J65*'Frais de personnel '!K65*'Frais de personnel '!L65,'Frais de personnel '!J65*'Frais de personnel '!L65)","v":0}]
[null,null,null,"-",0,0,0,0,0,0,null,null,{"$f":"IF(D66=Listes!A65,'Frais de personnel '!J66*'Frais de personnel '!K66*'Frais de personnel '!L66,'Frais de personnel '!J66*'Frais de personnel '!L66)","v":0}]
[null,null,null,"-",0,0,0,0,0,0,null,null,{"$f":"IF(D67=Listes!A66,'Frais de personnel '!J67*'Frais de personnel '!K67*'Frais de personnel '!L67,'Frais de personnel '!J67*'Frais de personnel '!L67)","v":0}]
[null,null,null,"-",0,0,0,0,0,0,null,null,{"$f":"IF(D68=Listes!A67,'Frais de personnel '!J68*'Frais de personnel '!K68*'Frais de personnel '!L68,'Frais de personnel '!J68*'Frais de personnel '!L68)","v":0}]
[null,null,null,"-",0,0,0,0,0,0,null,null,{"$f":"IF(D69=Listes!A68,'Frais de personnel '!J69*'Frais de personnel '!K69*'Frais de personnel '!L69,'Frais de personnel '!J69*'Frais de personnel '!L69)","v":0}]
[null,null,null,"-",0,0,0,0,0,0,null,null,{"$f":"IF(D70=Listes!A69,'Frais de personnel '!J70*'Frais de personnel '!K70*'Frais de personnel '!L70,'Frais de personnel '!J70*'Frais de personnel '!L70)","v":0}]
[null,null,null,"-",0,0,0,0,0,0,null,null,{"$f":"IF(D71=Listes!A70,'Frais de personnel '!J71*'Frais de personnel '!K71*'Frais de personnel '!L71,'Frais de personnel '!J71*'Frais de personnel '!L71)","v":0}]
[null,null,null,"-",0,0,0,0,0,0,null,null,{"$f":"IF(D72=Listes!A71,'Frais de personnel '!J72*'Frais de personnel '!K72*'Frais de personnel '!L72,'Frais de personnel '!J72*'Frais de personnel '!L72)","v":0}]
[null,null,null,"-",0,0,0,0,0,0,null,null,{"$f":"IF(D73=Listes!A72,'Frais de personnel '!J73*'Frais de personnel '!K73*'Frais de personnel '!L73,'Frais de personnel '!J73*'Frais de personnel '!L73)","v":0}]
[null,null,null,"-",0,0,0,0,0,0,null,null,{"$f":"IF(D74=Listes!A73,'Frais de personnel '!J74*'Frais de personnel '!K74*'Frais de personnel '!L74,'Frais de personnel '!J74*'Frais de personnel '!L74)","v":0}]
[null,null,null,"-",0,0,0,0,0,0,null,null,{"$f":"IF(D75=Listes!A74,'Frais de personnel '!J75*'Frais de personnel '!K75*'Frais de personnel '!L75,'Frais de personnel '!J75*'Frais de personnel '!L75)","v":0}]
[null,null,null,"-",0,0,0,0,0,0,null,null,{"$f":"IF(D76=Listes!A75,'Frais de personnel '!J76*'Frais de personnel '!K76*'Frais de personnel '!L76,'Frais de personnel '!J76*'Frais de personnel '!L76)","v":0}]
[null,null,null,"-",0,0,0,0,0,0,null,null,{"$f":"IF(D77=Listes!A76,'Frais de personnel '!J77*'Frais de personnel '!K77*'Frais de personnel '!L77,'Frais de personnel '!J77*'Frais de personnel '!L77)","v":0}]
[null,null,null,"-",0,0,0,0,0,0,null,null,{"$f":"IF(D78=Listes!A70,'Frais de personnel '!J78*'Frais de personnel '!K78*'Frais de personnel '!L78,'Frais de personnel '!J78*'Frais de personnel '!L78)","v":0}]
[null,null,null,"-",0,0,0,0,0,0,null,null,{"$f":"IF(D79=Listes!A71,'Frais de personnel '!J79*'Frais de personnel '!K79*'Frais de personnel '!L79,'Frais de personnel '!J79*'Frais de personnel '!L79)","v":0}]
[null,null,null,"-",0,0,0,0,0,0,null,null,{"$f":"IF(D80=Listes!A72,'Frais de personnel '!J80*'Frais de personnel '!K80*'Frais de personnel '!L80,'Frais de personnel '!J80*'Frais de personnel '!L80)","v":0}]
[null,null,null,"-",0,0,0,0,0,0,null,null,{"$f":"IF(D81=Listes!A73,'Frais de personnel '!J81*'Frais de personnel '!K81*'Frais de personnel '!L81,'Frais de personnel '!J81*'Frais de personnel '!L81)","v":0}]
[null,null,null,"-",0,0,0,0,0,0,null,null,{"$f":"IF(D82=Listes!A74,'Frais de personnel '!J82*'Frais de personnel '!K82*'Frais de personnel '!L82,'Frais de personnel '!J82*'Frais de personnel '!L82)","v":0}]
[null,null,null,"-",0,0,0,0,0,0,null,null,{"$f":"IF(D83=Listes!A75,'Frais de personnel '!J83*'Frais de personnel '!K83*'Frais de personnel '!L83,'Frais de personnel '!J83*'Frais de personnel '!L83)","v":0}]
[null,null,null,"-",0,0,0,0,0,0,null,null,{"$f":"IF(D84=Listes!A76,'Frais de personnel '!J84*'Frais de personnel '!K84*'Frais de personnel '!L84,'Frais de personnel '!J84*'Frais de personnel '!L84)","v":0}]
[]
[null,"Salariés dont le temps de travail est affecté en partie à l'opération et dont le prorata est calculé au réel sur la base de fiches de temps"]
[null,"Intitulé du poste","Nom de la personne en poste le cas échéant","Base mensuelle ou annuelle","Salaire brut","Charges patronales","Salaire brut chargé","Emplois aidés : préciser le montant de l'aide","Taxe sur les salaires","Part du salaire à prendre en compte","Nombre d'heures payées annuelles","Nombre d'heures de congés payés par an","Nombre d'heures de RTT par an","Taux horaire applicable","Nombre d'heures prévues sur l'opération","Coût prévisionnel total par poste"]
[]
[null,null,null,null,"(1)","(2)","(3)","(4)","(5)","(6)","(7)","(8)","(9)","(10)","(11)","(12)"]
[null,null,null,"Base annuelle obligatoire","Référence : dernier coût annuel ou prévisionnel si nouvelle embauche",null,"(1) + (2)","A remplir le cas échéant",null,"(3) - (4) - (5)","Références : contrats de travail, bulletins de paie et conventions collectives Voir note de bas de page (**)",null,null,"(6) / [(7)-(8)-(9)]","Référence : prévisionnel annuel","(10) x (11)"]
[null,null,null,"-",0,0,{"$f":"E91+F91","v":0},0,0,{"$f":"G91-H91-I91","v":0},null,null,null,{"$f":"IF(J91=0,0,J91/(K91-L91-M91))","v":0},null,{"$f":"IF(N91=0,0,N91*O91)","v":0}]
[null,null,null,"-",0,0,0,0,0,0,null,null,null,0,null,0]
[null,null,null,"-",0,0,0,0,0,0,null,null,null,0,null,0]
[null,null,null,"-",0,0,0,0,0,0,null,null,null,0,null,0]
[null,null,null,"-",0,0,0,0,0,0,null,null,null,0,null,0]
[null,null,null,"-",0,0,0,0,0,0,null,null,null,0,null,0]
[null,null,null,"-",0,0,0,0,0,0,null,null,null,0,null,0]
[null,null,null,"-",0,0,0,0,0,0,null,null,null,0,null,0]
[null,null,null,"-",0,0,0,0,0,0,null,null,null,0,null,0]
[null,null,null,"-",0,0,0,0,0,0,null,null,null,0,null,0]
[null,null,null,"-",0,0,0,0,0,0,null,null,null,0,null,0]
[null,null,null,"-",0,0,0,0,0,0,null,null,null,0,null,0]
[null,null,null,"-",0,0,0,0,0,0,null,null,null,0,null,0]
[null,null,null,"-",0,0,0,0,0,0,null,null,null,0,null,0]
[null,null,null,"-",0,0,0,0,0,0,null,null,null,0,null,0]
[null,null,null,"-",0,0,0,0,0,0,null,null,null,0,null,0]
[null,null,null,"-",0,0,0,0,0,0,null,null,null,0,null,0]
[null,null,null,"-",0,0,0,0,0,0,null,null,null,0,null,0]
[null,null,null,"-",0,0,0,0,0,0,null,null,null,0,null,0]
[null,null,null,"-",0,0,0,0,0,0,null,null,null,0,null,0]
[null,null,null,"-",0,0,0,0,0,0,null,null,null,0,null,0]
[null,null,null,"-",0,0,0,0,0,0,null,null,null,0,null,0]
[null,null,null,"-",0,0,0,0,0,0,null,null,null,0,null,0]
[null,null,null,"-",0,0,0,0,0,0,null,null,null,0,null,0]
[null,null,null,"-",0,0,0,0,0,0,null,null,null,0,null,0]
[null,null,null,"-",0,0,0,0,0,0,null,null,null,0,null,0]
[null,null,null,"-",0,0,0,0,0,0,null,null,null,0,null,0]
[null,null,null,"-",0,0,0,0,0,0,null,null,null,0,null,0]
[null,null,null,"-",0,0,0,0,0,0,null,null,null,0,null,0]
[null,null,null,"-",0,0,0,0,0,0,null,null,null,0,null,0]
[null,"(**) Le taux horaire applicable est calculé sur la base des heures de travail effectif. Celles-sont sont estiméesà partir du calcul suivant : heures annuelles payées par l'employeur - congés payés annuels - RTT annuels"]
[]
[null,"Montant prévisionnel des frais directs de personnel (reporté dans l'onglet \"dépenses prévisionnelles\") =",null,null,null,null,null,null,{"$f":"SUM(L19:L48)+SUM(M55:M84)+SUM(P91:P120)","v":0}]

{"sheet":"Ventilation par années","index":4,"n_rows":23,"n_cols":15,"rows_kept":23,"cut":false,"hidden":false,"merged":[[65,1,66,5],[56,1,57,3],[9,1,10,7],[13,1,13,2],[13,3,13,10],[5,7,5,10],[1,11,3,14],[5,11,5,14],[7,1,7,14],[1,2,1,3],[2,2,2,3],[3,2,3,3],[4,2,4,3],[1,4,1,5],[2,4,2,5],[3,4,3,5],[4,4,4,5],[1,7,3,10]]}
[]
[null,null,"Intitulé de l'opération",null,{"$f":"'Dépenses prévisionnelles'!D2","v":0},null,null,"Annexe 1 : Plan de financement\nProgrammation FEDER Massif central 2014-2020\nConvention interrégionale du Massif central"]
[null,null,"Porteur de projet",null,{"$f":"'Dépenses prévisionnelles'!D3","v":0}]
[null,null,"N° administratif du dossier",null,{"$f":"'Dépenses prévisionnelles'!D4","v":0}]
[null,null,"Dates de début et de fin de l'opération",null,{"$f":"'Dépenses prévisionnelles'!D5","v":0}]
[null,null,null,null,null,null,null," Cadre réglementaire : Programme Opérationnel Interrégionnal FEDER Massif central\nConvention interrégionale du Massif central"]
[]
[null,"Onglet 4 - Ventilation des dépenses prévisionnelles par année"]
[]
[]
[]
[]
[null,"Catégories de dépenses","Montant sur la durée de l'opération","Année\n20__","%","Année\n20__","%","Année\n20__","%","Année\n20__","%","Année\n20__","%","Année\n20__","%"]
[null,"Informations reportées automatiquement à partir de l'onglet \"Dépenses prévisionnelles\"",null," Champs des colonnes en vert à remplir par le porteur de projet"]
[null,{"$f":"'Dépenses prévisionnelles'!B15:AB15","v":"Dépenses directes de personnel "},{"$f":"'Dépenses prévisionnelles'!H46","v":0},null,{"$f":"IF($C15=0,\"-\",D15/(D$23))","v":"-"},null,{"$f":"IF($C15=0,\"-\",F15/(F$23))","v":"-"},null,{"$f":"IF($C15=0,\"-\",H15/(H$23))","v":"-"},null,{"$f":"IF($C15=0,\"-\",J15/(J$23))","v":"-"},null,{"$f":"IF($C15=0,\"-\",L15/(L$23))","v":"-"},null,{"$f":"IF($C15=0,\"-\",N15/(N$23))","v":"-"}]
[null,{"$f":"'Dépenses prévisionnelles'!B47:AB47","v":"Frais de mission du personnel"},{"$f":"'Dépenses prévisionnelles'!H80","v":0},null,{"$f":"IF($C16=0,\"-\",D16/(D$23))","v":"-"},null,"-",null,{"$f":"IF($C16=0,\"-\",H16/(H$23))","v":"-"},null,{"$f":"IF($C16=0,\"-\",J16/(J$23))","v":"-"},null,{"$f":"IF($C16=0,\"-\",L16/(L$23))","v":"-"},null,{"$f":"IF($C16=0,\"-\",N16/(N$23))","v":"-"}]
[null,{"$f":"'Dépenses prévisionnelles'!B81:AB81","v":"Coûts indirects"},{"$f":"'Dépenses prévisionnelles'!H113","v":0},null,"-",null,"-",null,{"$f":"IF($C17=0,\"-\",H17/(H$23))","v":"-"},null,{"$f":"IF($C17=0,\"-\",J17/(J$23))","v":"-"},null,"-",null,"-"]
[null,{"$f":"'Dépenses prévisionnelles'!B114:AB114","v":"Prestations externes"},{"$f":"'Dépenses prévisionnelles'!H145","v":0},null,"-",null,"-",null,{"$f":"IF($C18=0,\"-\",H18/(H$23))","v":"-"},null,{"$f":"IF($C18=0,\"-\",J18/(J$23))","v":"-"},null,"-",null,"-"]
[null,{"$f":"'Dépenses prévisionnelles'!B146:AB146","v":"Investissements matériels et immatériels"},{"$f":"'Dépenses prévisionnelles'!H178","v":0},null,"-",null,"-",null,{"$f":"IF($C19=0,\"-\",H19/(H$23))","v":"-"},null,{"$f":"IF($C19=0,\"-\",J19/(J$23))","v":"-"},null,"-",null,"-"]
[null,{"$f":"'Dépenses prévisionnelles'!B179:AB179","v":"Acquisitions foncières et immobilières"},{"$f":"'Dépenses prévisionnelles'!H210","v":0},null,"-",null,"-",null,{"$f":"IF($C20=0,\"-\",H20/(H$23))","v":"-"},null,{"$f":"IF($C20=0,\"-\",J20/(J$23))","v":"-"},null,"-",null,"-"]
[null,{"$f":"'Dépenses prévisionnelles'!B211:AB211","v":"Apports en nature"},{"$f":"'Dépenses prévisionnelles'!H242","v":0},null,"-",null,"-",null,{"$f":"IF($C21=0,\"-\",H21/(H$23))","v":"-"},null,{"$f":"IF($C21=0,\"-\",J21/(J$23))","v":"-"},null,"-",null,"-"]
[null,{"$f":"'Dépenses prévisionnelles'!B243:AB243","v":"Autres dépenses (à spécifier)"},{"$f":"'Dépenses prévisionnelles'!H274","v":0},null,"-",null,"-",null,{"$f":"IF($C22=0,\"-\",H22/(H$23))","v":"-"},null,{"$f":"IF($C22=0,\"-\",J22/(J$23))","v":"-"},null,"-",null,"-"]
[null,"Total des dépenses ",{"$f":"SUM(C15:C22)","v":0},{"$f":"SUM(D15:D22)","v":0},"-",{"$f":"SUM(F15:F22)","v":0},"-",{"$f":"SUM(H15:H22)","v":0},{"$f":"IF($C23=0,\"-\",H23/(H$23))","v":"-"},{"$f":"SUM(J15:J22)","v":0},{"$f":"IF($C23=0,\"-\",J23/(J$23))","v":"-"},{"$f":"SUM(L15:L22)","v":0},"-",{"$f":"SUM(N15:N22)","v":0},"-"]

{"sheet":"Fiche Navette 2","index":5,"n_rows":154,"n_cols":12,"rows_kept":154,"cut":false,"hidden":true,"merged":[[11,1,17,5],[25,1,25,5],[0,2,1,5],[3,4,3,5],[5,1,5,5],[6,2,6,5],[7,2,7,5],[8,2,8,5],[19,1,19,5],[20,2,20,5],[21,2,21,5],[22,2,22,5],[24,1,24,5],[10,1,10,5],[35,2,35,5],[37,1,37,5],[153,1,153,2],[26,2,26,5],[29,3,29,5],[31,2,31,5],[32,2,32,5],[33,2,33,5],[34,3,34,5]]}
[null,"« Fiche navette » n°2","Financement d’une opération présentée au titre des programmes Massif central 2014-2020",null,null,null,null,null,null,null,null,"-"]
[null,null,null,null,null,null,null,null,null,null,null,"Oui"]
[null,null,null,null,null,null,null,null,"Légende :",null,null,"Non"]
[null,null,null,"Date",null,null,null,null,"Détail des dépenses","Champs remplis par le GIP Massif central"]
[null,null,null,null,null,null,null,null,"Eligible / Inéligible","Champs à remplir par le cofinanceur partenaire",null,"-"]
[null,"Informations générales sur l’opération",null,null,null,null,null,null,null,null,null,"CIMAC"]
[null,"Numéro d’opération",{"$f":"'Dépenses prévisionnelles'!D4","v":0},null,null,null,null,null,null,null,null,"Hors CIMAC"]
[null,"Maître d’ouvrage",{"$f":"'Dépenses prévisionnelles'!$D$3","v":0}]
[null,"Intitulé de l’opération",{"$f":"'Dépenses prévisionnelles'!$D$2","v":0},null,null,null,null,null,null,null,null,"-"]
[]
[null,"Description de l'opération"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Hors Taxes (HT)"]
[null,"Service “expert”",null,null,null,null,null,null,null,null,null,"TVA partielle"]
[null,"Structure",null,null,null,null,null,null,null,null,null,"Toutes Taxes Comprises (TTC)"]
[null,"Service"]
[null,"Nom du rédacteur",null,null,null,null,null,null,null,null,null,"-"]
[null,null,null,null,null,null,null,null,null,null,null,"Eligible"]
[null,"Avis du service sur l’opération",null,null,null,null,null,null,null,null,null,"Inéligible"]
[]
[null,"Conclusion :","-",null,null,null,null,null,null,null,null,"-"]
[null,null,null,null,null,null,null,null,null,null,null,"Hors aides d'état"]
[null,"Financement de l’opération",null,null,null,null,null,null,null,null,null,"Recherche Développement et Innovation (RDI)"]
[null,"Financement envisagé :","-","Si \"non\", ne pas remplir la suite du formulaire",null,null,null,null,null,null,null,"Aide à Finalité Régionale (AFR)"]
[null,"Si oui, ",null,null,null,null,null,null,null,null,null,"PME"]
[null,"Délibération acquise :","-",null,null,null,null,null,null,null,null,"Actions collectives"]
[null,"Si non, date de passage en CP :",null,null,null,null,null,null,null,null,null,"Environnement"]
[null,"Montant de subvention :",null,null,null,null,null,null,null,null,null,"Service d'Intérêt Economique Général (SIEG)"]
[null,"Assiette éligible (préciser HT/TTC) :",{"$f":"F154","v":0},"Hors Taxes (HT)",null,null,null,null,null,null,null,"De minimis"]
[null,"Régime d’aide d'état (le cas échéant) :","-",null,null,null,null,null,null,null,null,"Autre"]
[]
[null,"Détails des postes de dépenses éligibles/inéligibles au financement",null,null,null,null,null,null,null,null,null,"-"]
[null,"Poste de dépenses","Détail des dépenses","Montant présenté","Eligible / Inéligible","Montant éligible",null,null,null,null,null,"Favorable"]
[null,{"$f":"'Dépenses prévisionnelles'!$B$15:$AB$15","v":"Dépenses directes de personnel "},{"$f":"'[1]Frais de personnel (2)'!B19","v":0},{"$f":"'[1]Frais de personnel (2)'!$L19","v":0},null,null,null,null,null,null,null,"Favorable sous réserve"]
[null,null,{"$f":"'[1]Frais de personnel (2)'!B20","v":0},{"$f":"'[1]Frais de personnel (2)'!$L20","v":0},null,null,null,null,null,null,null,"Ajournement"]
[null,null,{"$f":"'[1]Frais de personnel (2)'!B21","v":0},{"$f":"'[1]Frais de personnel (2)'!$L21","v":0},null,null,null,null,null,null,null,"Défavorable"]
[null,null,{"$f":"'[1]Frais de personnel (2)'!B22","v":0},{"$f":"'[1]Frais de personnel (2)'!$L22","v":0}]
[null,null,{"$f":"'[1]Frais de personnel (2)'!B23","v":0},{"$f":"'[1]Frais de personnel (2)'!$L23","v":0},null,null,null,null,null,null,null,"-"]
[null,null,{"$f":"'[1]Frais de personnel (2)'!B24","v":0},{"$f":"'[1]Frais de personnel (2)'!$L24","v":0},null,null,null,null,null,null,null,"Auvergne"]
[null,null,{"$f":"'[1]Frais de personnel (2)'!B25","v":0},{"$f":"'[1]Frais de personnel (2)'!$L25","v":0},null,null,null,null,null,null,null,"Bourgogne"]
[null,null,{"$f":"'[1]Frais de personnel (2)'!B26","v":0},{"$f":"'[1]Frais de personnel (2)'!$L26","v":0},null,null,null,null,null,null,null,"Languedoc-Roussillon"]
[null,null,{"$f":"'[1]Frais de personnel (2)'!B27","v":0},{"$f":"'[1]Frais de personnel (2)'!$L27","v":0},null,null,null,null,null,null,null,"Limousin"]
[null,null,{"$f":"'[1]Frais de personnel (2)'!B28","v":0},{"$f":"'[1]Frais de personnel (2)'!$L28","v":0}]
[null,null,{"$f":"'[1]Frais de personnel (2)'!B29","v":0},{"$f":"'[1]Frais de personnel (2)'!$L29","v":0},null,null,null,null,null,null,null,"Midi-Pyrénées"]
[null,null,{"$f":"'[1]Frais de personnel (2)'!B30","v":0},{"$f":"'[1]Frais de personnel (2)'!$L30","v":0},null,null,null,null,null,null,null,"Rhône-Alpes"]
[null,null,{"$f":"'[1]Frais de personnel (2)'!B31","v":0},{"$f":"'[1]Frais de personnel (2)'!$L31","v":0}]
[null,null,{"$f":"'[1]Frais de personnel (2)'!B32","v":0},{"$f":"'[1]Frais de personnel (2)'!$L32","v":0}]
[null,null,{"$f":"'[1]Frais de personnel (2)'!B33","v":0},{"$f":"'[1]Frais de personnel (2)'!$L33","v":0},null,null,null,null,null,null,null,"03 Allier"]
[null,null,{"$f":"'[1]Frais de personnel (2)'!B34","v":0},{"$f":"'[1]Frais de personnel (2)'!$L34","v":0},null,null,null,null,null,null,null,"07 Ardèche"]
[null,null,{"$f":"'[1]Frais de personnel (2)'!B35","v":0},{"$f":"'[1]Frais de personnel (2)'!$L35","v":0},null,null,null,null,null,null,null,"11 Aude"]
[null,null,{"$f":"'[1]Frais de personnel (2)'!B36","v":0},{"$f":"'[1]Frais de personnel (2)'!$L36","v":0},null,null,null,null,null,null,null,"12 Aveyron"]
[null,null,{"$f":"'[1]Frais de personnel (2)'!B37","v":0},{"$f":"'[1]Frais de personnel (2)'!$L37","v":0},null,null,null,null,null,null,null,"15 Cantal"]
[null,null,{"$f":"'[1]Frais de personnel (2)'!B38","v":0},{"$f":"'[1]Frais de personnel (2)'!$L38","v":0},null,null,null,null,null,null,null,"19 Corrèze"]
[null,null,{"$f":"'[1]Frais de personnel (2)'!B39","v":0},{"$f":"'[1]Frais de personnel (2)'!$L39","v":0},null,null,null,null,null,null,null,"21 Côte d’Or"]
[null,null,{"$f":"'[1]Frais de personnel (2)'!B40","v":0},{"$f":"'[1]Frais de personnel (2)'!$L40","v":0},null,null,null,null,null,null,null,"23 Creuse"]
[null,null,{"$f":"'[1]Frais de personnel (2)'!B41","v":0},{"$f":"'[1]Frais de personnel (2)'!$L41","v":0},null,null,null,null,null,null,null,"30 Gard"]
[null,null,{"$f":"'[1]Frais de personnel (2)'!B42","v":0},{"$f":"'[1]Frais de personnel (2)'!$L42","v":0},null,null,null,null,null,null,null,"34 Hérault"]
[null,null,{"$f":"'[1]Frais de personnel (2)'!B43","v":0},{"$f":"'[1]Frais de personnel (2)'!$L43","v":0},null,null,null,null,null,null,null,"42 Loire"]
[null,null,{"$f":"'[1]Frais de personnel (2)'!B44","v":0},{"$f":"'[1]Frais de personnel (2)'!$L44","v":0},null,null,null,null,null,null,null,"43 Haute-Loire"]
[null,null,{"$f":"'[1]Frais de personnel (2)'!B45","v":0},{"$f":"'[1]Frais de personnel (2)'!$L45","v":0},null,null,null,null,null,null,null,"46 Lot"]
[null,null,{"$f":"'[1]Frais de personnel (2)'!B46","v":0},{"$f":"'[1]Frais de personnel (2)'!$L46","v":0},null,null,null,null,null,null,null,"48 Lozère"]
[null,null,{"$f":"'[1]Frais de personnel (2)'!B47","v":0},{"$f":"'[1]Frais de personnel (2)'!$L47","v":0}]
[null,null,{"$f":"'[1]Frais de personnel (2)'!B48","v":0},{"$f":"'[1]Frais de personnel (2)'!$L48","v":0}]
[null,null,{"$f":"'[1]Frais de personnel (2)'!B55","v":0},{"$f":"'[1]Frais de personnel (2)'!M55","v":0}]
[null,null,{"$f":"'[1]Frais de personnel (2)'!B56","v":0},{"$f":"'[1]Frais de personnel (2)'!M56","v":0}]
[null,null,{"$f":"'[1]Frais de personnel (2)'!B57","v":0},{"$f":"'[1]Frais de personnel (2)'!M57","v":0}]
[null,null,{"$f":"'[1]Frais de personnel (2)'!B58","v":0},{"$f":"'[1]Frais de personnel (2)'!M58","v":0}]
[null,null,{"$f":"'[1]Frais de personnel (2)'!B59","v":0},{"$f":"'[1]Frais de personnel (2)'!M59","v":0}]
[null,null,{"$f":"'[1]Frais de personnel (2)'!B60","v":0},{"$f":"'[1]Frais de personnel (2)'!M60","v":0}]
[null,null,{"$f":"'[1]Frais de personnel (2)'!B61","v":0},{"$f":"'[1]Frais de personnel (2)'!M61","v":0}]
[null,null,{"$f":"'[1]Frais de personnel (2)'!B62","v":0},{"$f":"'[1]Frais de personnel (2)'!M62","v":0}]
[null,null,{"$f":"'[1]Frais de personnel (2)'!B63","v":0},{"$f":"'[1]Frais de personnel (2)'!M63","v":0}]
[null,null,{"$f":"'[1]Frais de personnel (2)'!B64","v":0},{"$f":"'[1]Frais de personnel (2)'!M64","v":0}]
[null,null,{"$f":"'[1]Frais de personnel (2)'!B65","v":0},{"$f":"'[1]Frais de personnel (2)'!M65","v":0}]
[null,null,{"$f":"'[1]Frais de personnel (2)'!B66","v":0},{"$f":"'[1]Frais de personnel (2)'!M66","v":0}]
[null,null,{"$f":"'[1]Frais de personnel (2)'!B67","v":0},{"$f":"'[1]Frais de personnel (2)'!M67","v":0}]
[null,null,{"$f":"'[1]Frais de personnel (2)'!B68","v":0},{"$f":"'[1]Frais de personnel (2)'!M68","v":0}]
[null,null,{"$f":"'[1]Frais de personnel (2)'!B69","v":0},{"$f":"'[1]Frais de personnel (2)'!M69","v":0}]
[null,null,{"$f":"'[1]Frais de personnel (2)'!B70","v":0},{"$f":"'[1]Frais de personnel (2)'!M70","v":0}]
[null,null,{"$f":"'[1]Frais de personnel (2)'!B71","v":0},{"$f":"'[1]Frais de personnel (2)'!M71","v":0}]
[null,null,{"$f":"'[1]Frais de personnel (2)'!B72","v":0},{"$f":"'[1]Frais de personnel (2)'!M72","v":0}]
[null,null,{"$f":"'[1]Frais de personnel (2)'!B73","v":0},{"$f":"'[1]Frais de personnel (2)'!M73","v":0}]
[null,null,{"$f":"'[1]Frais de personnel (2)'!B74","v":0},{"$f":"'[1]Frais de personnel (2)'!M74","v":0}]
[null,null,{"$f":"'[1]Frais de personnel (2)'!B75","v":0},{"$f":"'[1]Frais de personnel (2)'!M75","v":0}]
[null,null,{"$f":"'[1]Frais de personnel (2)'!B76","v":0},{"$f":"'[1]Frais de personnel (2)'!M76","v":0}]
[null,null,{"$f":"'[1]Frais de personnel (2)'!B77","v":0},{"$f":"'[1]Frais de personnel (2)'!M77","v":0}]
[null,null,{"$f":"'[1]Frais de personnel (2)'!B78","v":0},{"$f":"'[1]Frais de personnel (2)'!M78","v":0}]
[null,null,{"$f":"'[1]Frais de personnel (2)'!B79","v":0},{"$f":"'[1]Frais de personnel (2)'!M79","v":0}]
[null,null,{"$f":"'[1]Frais de personnel (2)'!B80","v":0},{"$f":"'[1]Frais de personnel (2)'!M80","v":0}]
[null,null,{"$f":"'[1]Frais de personnel (2)'!B81","v":0},{"$f":"'[1]Frais de personnel (2)'!M81","v":0}]
[null,null,{"$f":"'[1]Frais de personnel (2)'!B82","v":0},{"$f":"'[1]Frais de personnel (2)'!M82","v":0}]
[null,null,{"$f":"'[1]Frais de personnel (2)'!B83","v":0},{"$f":"'[1]Frais de personnel (2)'!M83","v":0}]
[null,null,{"$f":"'[1]Frais de personnel (2)'!B84","v":0},{"$f":"'[1]Frais de personnel (2)'!M84","v":0}]
[null,null,{"$f":"'[1]Frais de personnel (2)'!B91","v":0},{"$f":"'[1]Frais de personnel (2)'!P91","v":0}]
[null,null,{"$f":"'[1]Frais de personnel (2)'!B92","v":0},{"$f":"'[1]Frais de personnel (2)'!P92","v":0}]
[null,null,{"$f":"'[1]Frais de personnel (2)'!B93","v":0},{"$f":"'[1]Frais de personnel (2)'!P93","v":0}]
[null,null,{"$f":"'[1]Frais de personnel (2)'!B94","v":0},{"$f":"'[1]Frais de personnel (2)'!P94","v":0}]
[null,null,{"$f":"'[1]Frais de personnel (2)'!B95","v":0},{"$f":"'[1]Frais de personnel (2)'!P95","v":0}]
[null,null,{"$f":"'[1]Frais de personnel (2)'!B96","v":0},{"$f":"'[1]Frais de personnel (2)'!P96","v":0}]
[null,null,{"$f":"'[1]Frais de personnel (2)'!B97","v":0},{"$f":"'[1]Frais de personnel (2)'!P97","v":0}]
[null,null,{"$f":"'[1]Frais de personnel (2)'!B98","v":0},{"$f":"'[1]Frais de personnel (2)'!P98","v":0}]
[null,null,{"$f":"'[1]Frais de personnel (2)'!B99","v":0},{"$f":"'[1]Frais de personnel (2)'!P99","v":0}]
[null,null,{"$f":"'[1]Frais de personnel (2)'!B100","v":0},{"$f":"'[1]Frais de personnel (2)'!P100","v":0}]
[null,null,{"$f":"'[1]Frais de personnel (2)'!B101","v":0},{"$f":"'[1]Frais de personnel (2)'!P101","v":0}]
[null,null,{"$f":"'[1]Frais de personnel (2)'!B102","v":0},{"$f":"'[1]Frais de personnel (2)'!P102","v":0}]
[null,null,{"$f":"'[1]Frais de personnel (2)'!B103","v":0},{"$f":"'[1]Frais de personnel (2)'!P103","v":0}]
[null,null,{"$f":"'[1]Frais de personnel (2)'!B104","v":0},{"$f":"'[1]Frais de personnel (2)'!P104","v":0}]
[null,null,{"$f":"'[1]Frais de personnel (2)'!B105","v":0},{"$f":"'[1]Frais de personnel (2)'!P105","v":0}]
[null,null,{"$f":"'[1]Frais de personnel (2)'!B106","v":0},{"$f":"'[1]Frais de personnel (2)'!P106","v":0}]
[null,null,{"$f":"'[1]Frais de personnel (2)'!B107","v":0},{"$f":"'[1]Frais de personnel (2)'!P107","v":0}]
[null,null,{"$f":"'[1]Frais de personnel (2)'!B108","v":0},{"$f":"'[1]Frais de personnel (2)'!P108","v":0}]
[null,null,{"$f":"'[1]Frais de personnel (2)'!B109","v":0},{"$f":"'[1]Frais de personnel (2)'!P109","v":0}]
[null,null,{"$f":"'[1]Frais de personnel (2)'!B110","v":0},{"$f":"'[1]Frais de personnel (2)'!P110","v":0}]
[null,null,{"$f":"'[1]Frais de personnel (2)'!B111","v":0},{"$f":"'[1]Frais de personnel (2)'!P111","v":0}]
[null,null,{"$f":"'[1]Frais de personnel (2)'!B112","v":0},{"$f":"'[1]Frais de personnel (2)'!P112","v":0}]
[null,null,{"$f":"'[1]Frais de personnel (2)'!B113","v":0},{"$f":"'[1]Frais de personnel (2)'!P113","v":0}]
[null,null,{"$f":"'[1]Frais de personnel (2)'!B114","v":0},{"$f":"'[1]Frais de personnel (2)'!P114","v":0}]
[null,null,{"$f":"'[1]Frais de personnel (2)'!B115","v":0},{"$f":"'[1]Frais de personnel (2)'!P115","v":0}]
[null,null,{"$f":"'[1]Frais de personnel (2)'!B116","v":0},{"$f":"'[1]Frais de personnel (2)'!P116","v":0}]
[null,null,{"$f":"'[1]Frais de personnel (2)'!B117","v":0},{"$f":"'[1]Frais de personnel (2)'!P117","v":0}]
[null,null,{"$f":"'[1]Frais de personnel (2)'!B118","v":0},{"$f":"'[1]Frais de personnel (2)'!P118","v":0}]
[null,null,{"$f":"'[1]Frais de personnel (2)'!B119","v":0},{"$f":"'[1]Frais de personnel (2)'!P119","v":0}]
[null,null,{"$f":"'[1]Frais de personnel (2)'!B120","v":0},{"$f":"'[1]Frais de personnel (2)'!P120","v":0}]
[null,{"$f":"'Dépenses prévisionnelles'!$B$47:$AB$47","v":"Frais de mission du personnel"},{"$f":"'Dépenses prévisionnelles'!C48","v":"Déplacements transports en commun"},{"$f":"'Dépenses prévisionnelles'!H48","v":0},null,null,null,null,null,null,null,"63 Puy-de-Dôme"]
[null,null,{"$f":"'Dépenses prévisionnelles'!C49","v":"Déplacements véhicules personnels ou de service"},{"$f":"'Dépenses prévisionnelles'!H49","v":0},null,null,null,null,null,null,null,"69 Rhône"]
[null,null,{"$f":"'Dépenses prévisionnelles'!C52","v":"Repas"},{"$f":"'Dépenses prévisionnelles'!H52","v":0},null,null,null,null,null,null,null,"71 Saône-et-Loire"]
[null,null,{"$f":"'Dépenses prévisionnelles'!C53","v":"Nuitées"},{"$f":"'Dépenses prévisionnelles'!H53","v":0},null,null,null,null,null,null,null,"81 Tarn"]
[null,null,{"$f":"'Dépenses prévisionnelles'!C54","v":"Péages"},{"$f":"'Dépenses prévisionnelles'!H54","v":0},null,null,null,null,null,null,null,"82 Tarn-et-Garonne"]
[null,{"$f":"'Dépenses prévisionnelles'!$B$81:$AB$81","v":"Coûts indirects"},{"$f":"'Dépenses prévisionnelles'!$C$82","v":"Taux forfaitaire (associations exclusivement - hors fonds Etat)"},{"$f":"'Dépenses prévisionnelles'!$H82","v":0},null,null,null,null,null,null,null,"87 Haute-Vienne"]
[null,{"$f":"'Dépenses prévisionnelles'!$B$114:$AB$114","v":"Prestations externes"},{"$f":"'Dépenses prévisionnelles'!C115","v":"Communication"},{"$f":"'Dépenses prévisionnelles'!H115","v":0},null,null,null,null,null,null,null,"89 Yonne"]
[null,null,{"$f":"'Dépenses prévisionnelles'!C116","v":0},{"$f":"'Dépenses prévisionnelles'!H116","v":0}]
[null,null,{"$f":"'Dépenses prévisionnelles'!C117","v":"Conseil"},{"$f":"'Dépenses prévisionnelles'!H117","v":0}]
[null,null,{"$f":"'Dépenses prévisionnelles'!C118","v":0},{"$f":"'Dépenses prévisionnelles'!H118","v":0},null,null,null,null,null,null,null,"-"]
[null,null,{"$f":"'Dépenses prévisionnelles'!C119","v":"Etudes"},{"$f":"'Dépenses prévisionnelles'!H119","v":0}]
[null,null,{"$f":"'Dépenses prévisionnelles'!C120","v":0},{"$f":"'Dépenses prévisionnelles'!H120","v":0}]
[null,{"$f":"'Dépenses prévisionnelles'!B146:AB146","v":"Investissements matériels et immatériels"},{"$f":"'Dépenses prévisionnelles'!C147","v":0},{"$f":"'Dépenses prévisionnelles'!H147","v":0},null,null,null,null,null,null,null,"Mensuelle"]
[null,null,{"$f":"'Dépenses prévisionnelles'!C148","v":0},{"$f":"'Dépenses prévisionnelles'!H148","v":0}]
[null,null,{"$f":"'Dépenses prévisionnelles'!C149","v":0},{"$f":"'Dépenses prévisionnelles'!H149","v":0}]
[null,null,{"$f":"'Dépenses prévisionnelles'!C150","v":0},{"$f":"'Dépenses prévisionnelles'!H150","v":0}]
[null,{"$f":"'Dépenses prévisionnelles'!B179:AB179","v":"Acquisitions foncières et immobilières"},{"$f":"'Dépenses prévisionnelles'!C180","v":0},{"$f":"'Dépenses prévisionnelles'!H180","v":0}]
[null,null,{"$f":"'Dépenses prévisionnelles'!C181","v":0},{"$f":"'Dépenses prévisionnelles'!H181","v":0},null,null,null,null,null,null,null,"-"]
[null,{"$f":"'Dépenses prévisionnelles'!B211:AB211","v":"Apports en nature"},{"$f":"'Dépenses prévisionnelles'!C212","v":"Bénévolat, mise à disposition gracieuse de personnel, prêt de salle, etc"},{"$f":"'Dépenses prévisionnelles'!H212","v":0},null,null,null,null,null,null,null,"Temps plein"]
[null,null,{"$f":"'Dépenses prévisionnelles'!C213","v":0},{"$f":"'Dépenses prévisionnelles'!H213","v":0},null,null,null,null,null,null,null,"Prorata prédéfini"]
[null,{"$f":"'Dépenses prévisionnelles'!B243:AB243","v":"Autres dépenses (à spécifier)"},{"$f":"'Dépenses prévisionnelles'!C244","v":0},{"$f":"'Dépenses prévisionnelles'!H244","v":0},null,null,null,null,null,null,null,"Prorata calculé au réel"]
[null,null,{"$f":"'Dépenses prévisionnelles'!C245","v":0},{"$f":"'Dépenses prévisionnelles'!H245","v":0}]
[null,null,{"$f":"'Dépenses prévisionnelles'!C246","v":0},{"$f":"'Dépenses prévisionnelles'!H246","v":0}]
[null,null,{"$f":"'Dépenses prévisionnelles'!C247","v":0},{"$f":"'Dépenses prévisionnelles'!H247","v":0}]
[null,"TOTAUX",null,{"$f":"SUM(D40:D153)","v":0},null,{"$f":"SUM(F40:F153)","v":0}]

{"sheet":"Listes","index":6,"n_rows":75,"n_cols":1,"rows_kept":75,"cut":false,"hidden":true,"merged":[]}
["-"]
["Oui"]
["Non"]
[]
["-"]
["CIMAC"]
["Hors CIMAC"]
[]
["-"]
["Hors Taxes (HT)"]
["TVA partielle"]
["Toutes Taxes Comprises (TTC)"]
[]
["-"]
["Eligible"]
["Inéligible"]
[]
["-"]
["Hors aides d'état"]
["Recherche Développement et Innovation (RDI)"]
["Aide à Finalité Régionale (AFR)"]
["PME"]
["Actions collectives"]
["Environnement"]
["Service d'Intérêt Economique Général (SIEG)"]
["De minimis"]
["Autre"]
[]
["-"]
["Favorable"]
["Favorable sous réserve"]
["Ajournement"]
["Défavorable"]
[]
["-"]
["Auvergne"]
["Bourgogne"]
["Languedoc-Roussillon"]
["Limousin"]
["Midi-Pyrénées"]
["Rhône-Alpes"]
[]
[]
["03 Allier"]
["07 Ardèche"]
["11 Aude"]
["12 Aveyron"]
["15 Cantal"]
["19 Corrèze"]
["21 Côte d’Or"]
["23 Creuse"]
["30 Gard"]
["34 Hérault"]
["42 Loire"]
["43 Haute-Loire"]
["46 Lot"]
["48 Lozère"]
["58 Nièvre"]
["63 Puy-de-Dôme"]
["69 Rhône"]
["71 Saône-et-Loire"]
["81 Tarn"]
["82 Tarn-et-Garonne"]
["87 Haute-Vienne"]
["89 Yonne"]
[]
[]
["-"]
["Mensuelle"]
["Annuelle"]
[]
["-"]
["Temps plein"]
["Prorata prédéfini"]
["Prorata calculé au réel"]

{"sheet":"liste déroulante","index":7,"n_rows":24,"n_cols":1,"rows_kept":24,"cut":false,"hidden":true,"merged":[]}
["-"]
["Temps complet 100%"]
["Temps partiel pré-affecté en pourcentage par lettre de mission ou contrat de travail "]
["Temps partiel justifié par fiches de temps"]
[]
[]
["-"]
["Barème kilométriques"]
["Calcul et clé de répartition définis par le bénéficiaire (véhicule de service ou de fonction)"]
[]
[]
["-"]
["Indemnité forfaitaire définie par le bénéficiaire pour ses salariés"]
["Frais réels"]
[]
[]
["-"]
["Indemnité forfaitaire définie par le bénéficiaire pour ses salariés"]
["Frais réels"]
[]
[]
["-"]
["Taux forfaitaire maximal de 15% des frais de personnel directs éligibles (article 68 du règlement UE 1303-2013)"]
["Frais réels (location d’un bien immobilier consacré à la réalisation de l’opération)"]

{"sheet":"FN1 ","index":8,"n_rows":39,"n_cols":12,"rows_kept":39,"cut":false,"hidden":true,"merged":[[37,0,37,4],[38,1,38,4],[27,0,27,4],[28,1,28,4],[29,1,29,4],[30,1,30,4],[32,0,34,4],[36,0,36,4],[25,1,25,4],[0,1,1,4],[3,3,3,4],[8,0,8,4],[9,1,9,4],[10,1,10,4],[11,1,11,4],[13,0,13,4],[14,0,20,4],[22,0,22,4],[23,1,23,4],[24,1,24,4]]}
["« Fiche navette » n°1","Avis technique d'opportunité pour le financement d'une opération présentée au titre du programme FEDER Massif central 2014-2020"]
[null,null,null,null,null,null,null,null,null,null,null,"Oui"]
[null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,"Date",null,null,null,null,null,null,null,null,"-"]
[]
["L'avis technique d'opportunité est à remplir par la région référente sur le projet. "]
["Toutefois les autres régions sont invitées à produire leurs avis si elles sont concernées par le projet."]
[null,null,null,null,null,null,null,null,null,null,null,"Biodiversité- Milieux ouverts herbacés"]
["Informations générales sur l’opération",null,null,null,null,null,null,null,null,null,null,"Biodiversité- Tourbières"]
["Numéro d’opération",{"$f":"'Dépenses prévisionnelles'!D4","v":0},null,null,null,null,null,null,null,null,null,"Biodiversité- Forêts anciennes"]
["Maître d’ouvrage",{"$f":"'Dépenses prévisionnelles'!D3","v":0},null,null,null,null,null,null,null,null,null,"Environnement- Valorisation des services environnementaux"]
["Intitulé de l’opération",{"$f":"'Dépenses prévisionnelles'!D2","v":0},null,null,null,null,null,null,null,null,null,"Tourisme- Pôles de pleine nature"]
[]
["Description de l'opération",null,null,null,null,null,null,null,null,null,null,"Tourisme- Itinérance"]
[null,null,null,null,null,null,null,null,null,null,null,"Bois construction- Positionnement sur les marchés"]
[null,null,null,null,null,null,null,null,null,null,null,"Bois construction- Qualification des produits"]
[null,null,null,null,null,null,null,null,null,null,null,"Bois construction- Caractérisation des bois"]
[null,null,null,null,null,null,null,null,null,null,null,"Bois construction- Equipement de formation"]
[null,null,null,null,null,null,null,null,null,null,null,"Bois- Prospection de nouveaux marchés"]
[null,null,null,null,null,null,null,null,null,null,null,"Innovation territoriale- Politiques d'accueil"]
[null,null,null,null,null,null,null,null,null,null,null,"Innovation territoriale- Expérimentations"]
[null,null,null,null,null,null,null,null,null,null,null,"Innovation territoriale- Services innovants à la population"]
["Service “expert”",null,null,null,null,null,null,null,null,null,null,"Innovation territoriale- Amélioration des connaissances"]
["Structure",null,null,null,null,null,null,null,null,null,null,"-"]
["Service"]
["Nom du rédacteur",null,null,null,null,null,null,null,null,null,null,"Avis favorable"]
[null,null,null,null,null,null,null,null,null,null,null,"Avis défavorable"]
["Eligibilité",null,null,null,null,null,null,null,null,null,null,"Avis favorable sous réserve"]
["Eligible au PO?",null,null,null,null,null,null,null,null,null,null,"-"]
["Axe"]
["Activité économique?"]
[]
["Au sens communautaire, une activité est dite économique si elle entraîne la fourniture d’un bien et/ou d’un service, et ce, peu importe la nature du maître d’ouvrage (public/privé, entreprise/collectivité/association/etc). Toute aide à une activité économique doit se conformer aux conditions du régime d’aide correspondant."]
[]
[]
[]
["Opportunité technique de l'opération pour un financement FEDER"]
[]
["Conclusion :","-"]

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