{"text_format":"1","workbook":"xlsx","n_sheets":18,"sheets":["Notice de saisie","Dépenses prév._chef de file"," Détails frais perso_chef file","Dépenses prev. _part1"," Détails frais de perso _part1","Dépenses prev. _part2"," Détails frais de perso _part2","Dépenses prev. _part3"," Détails frais de perso _part3","Dépenses prev. _part4"," Détails frais de perso _part4","Dépenses prev. _part5"," Détails frais de perso _part5","Plan de financement global","Recapitulatif","Détail des dépenses du projet","Détail des ressources du projet","Feuil1"],"not_rendered":{"charts":0,"images":19,"macros":0,"external_links":0,"defined_names":24,"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":"Notice de saisie","index":0,"n_rows":19,"n_cols":1,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,0,0,18]]}
["Fonds Asile, migration et intégration\nProgrammation 2021-2027\nNotice de saisie du plan de financement"]
[]
["Saisir le nom du chef de file dans la cellule B2 de l'onglet dépenses prev"]
["Saisir les données relatives aux frais de personnels dans l'onglet \"détails frais perso\" du chef de file qui abonderont automatiquement l'onglet \"dépenses prév\""]
["Saisir les autres dépenses dans l'onglet \"depenses prév\""]
["Appliquer les taux d'affectation relatifs aux dépenses de personnel"]
["Faire de même pour chaque partenaire dans les onglets prévus"]
["Dans l'onglet \"plan de financement global\", saisir les informations suivantes : le taux de décote le cas échéant (C851), la participation UE demandée"]
["Saisir la ventilation dans l'onglet \"recap\""]
["Ne pas saisir de montant dans la colonne \"B\" de l'onglet \"recap\". Ces montants sont issus des saisies dans les onglets précédents. Si une erreur est constatée modifier dans l'onglet adéquat."]
["Envoyer au service instructeur pour relecture"]
["Validation du service instructeur"]
["Mise à la signature de l'annexe"]
[]
[]
[]
[]
["Ne modifier les tableaux qu'en collaboration avec le service instructeur."]
["Les plans de financement doivent être équilibrés. Si ce n'est pas le cas, appliquer les modifications adéquates."]

{"sheet":"Dépenses prév._chef de file","index":1,"n_rows":39,"n_cols":10,"rows_kept":39,"cut":false,"hidden":false,"merged":[[21,5,21,6],[0,0,0,9],[1,1,1,3]]}
["Fonds Asile, migration et intégration\nProgrammation 2021-2027\n Plan de financement"]
["Dépenses prévisionnelles :","Chef de file (le nommer)"]
[null,"Montant total\n( € )","Taux d'affectation","Coût affecté au projet",null,"RESSOURCES ","Montant total de la ressource ","Taux d'affectation  au projet éligible ","Montant affecté au projet éligible","% sur ressources totales affectées au projet éligible "]
["a) Frais de personnels\nNe pas saisir directement les informations en gris ci-dessous mais renseigner l'onglet \"Détail des frais de personnel\" de ce fichier.Les informations renseignées s'incrémenteront automatiquement.",{"$f":"SUM(B5:B18)","v":0},{"$f":"D4/B4","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D5:D18)","v":0},null,"a) Cofinanceurs externes publics\n",{"$f":"SUM(G5:G10)","v":0},{"$f":"I4/G4","v":{"$error":"#DIV/0!"}},{"$f":"SUM(I5:I10)","v":0},{"$f":"I4/$I$22","v":{"$error":"#DIV/0!"}}]
[{"$f":"' Détails frais perso_chef file'!A3","v":"1)"},{"$f":"' Détails frais perso_chef file'!E3","v":0},{"$f":"IF(B5<>0,D5/B5,\"-\")","v":"-"},{"$f":"' Détails frais perso_chef file'!F3","v":"-"},null,null,null,{"$f":"I5/G5","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"}]
[{"$f":"' Détails frais perso_chef file'!A4","v":"2)"},{"$f":"' Détails frais perso_chef file'!E4","v":0},"-",{"$f":"' Détails frais perso_chef file'!F4","v":"-"},null,null,null,{"$f":"I6/G6","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"}]
[{"$f":"' Détails frais perso_chef file'!A5","v":"3)"},{"$f":"' Détails frais perso_chef file'!E5","v":0},"-",{"$f":"' Détails frais perso_chef file'!F5","v":"-"},null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[{"$f":"' Détails frais perso_chef file'!A6","v":"4)"},{"$f":"' Détails frais perso_chef file'!E6","v":0},"-",{"$f":"' Détails frais perso_chef file'!F6","v":"-"},null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[{"$f":"' Détails frais perso_chef file'!A7","v":"5)"},{"$f":"' Détails frais perso_chef file'!E7","v":0},"-",{"$f":"' Détails frais perso_chef file'!F7","v":"-"},null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[{"$f":"' Détails frais perso_chef file'!A8","v":"6)"},{"$f":"' Détails frais perso_chef file'!E8","v":0},"-",{"$f":"' Détails frais perso_chef file'!F8","v":"-"},null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[{"$f":"' Détails frais perso_chef file'!A9","v":"7)"},{"$f":"' Détails frais perso_chef file'!E9","v":0},"-",{"$f":"' Détails frais perso_chef file'!F9","v":"-"},null,"b) Cofinanceurs externes privés",{"$f":"SUM(G12:G17)","v":0},{"$f":"I11/G11","v":{"$error":"#DIV/0!"}},{"$f":"SUM(I12:I17)","v":0},{"$error":"#DIV/0!"}]
[{"$f":"' Détails frais perso_chef file'!A10","v":"8)"},{"$f":"' Détails frais perso_chef file'!E10","v":0},"-",{"$f":"' Détails frais perso_chef file'!F10","v":"-"},null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[{"$f":"' Détails frais perso_chef file'!A11","v":"9)"},{"$f":"' Détails frais perso_chef file'!E11","v":0},"-",{"$f":"' Détails frais perso_chef file'!F11","v":"-"},null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[{"$f":"' Détails frais perso_chef file'!A12","v":"10)"},{"$f":"' Détails frais perso_chef file'!E12","v":0},"-",{"$f":"' Détails frais perso_chef file'!F12","v":"-"},null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[{"$f":"' Détails frais perso_chef file'!A13","v":"11)"},{"$f":"' Détails frais perso_chef file'!E13","v":0},"-",{"$f":"' Détails frais perso_chef file'!F13","v":"-"},null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[{"$f":"' Détails frais perso_chef file'!A14","v":"12)"},{"$f":"' Détails frais perso_chef file'!E14","v":0},"-",{"$f":"' Détails frais perso_chef file'!F14","v":"-"},null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[{"$f":"' Détails frais perso_chef file'!A15","v":"13)"},{"$f":"' Détails frais perso_chef file'!E15","v":0},"-",{"$f":"' Détails frais perso_chef file'!F15","v":"-"},null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[{"$f":"' Détails frais perso_chef file'!A16","v":"14)"},{"$f":"' Détails frais perso_chef file'!E16","v":0},"-",{"$f":"' Détails frais perso_chef file'!F16","v":"-"},null,"d) Autofinancement (dont les recettes générées par le projet)",{"$f":"SUM(G19:G21)","v":0},{"$f":"I18/G18","v":{"$error":"#DIV/0!"}},{"$f":"SUM(I19:I21)","v":0},{"$error":"#DIV/0!"}]
["b) Frais de voyage et de séjour ",{"$f":"SUM(B20:B22)","v":0},{"$f":"D19/B19","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D20:D22)","v":0},null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[null,null,1,{"$f":"B20*C20","v":0},null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[null,null,1,0,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[null,null,1,0,null,"TOTAL DES RESSOURCES ELIGIBLES ",null,null,{"$f":"I18+I11+I4","v":0}]
["c) Frais d’équipement ",{"$f":"SUM(B24:B26)","v":0},{"$f":"D23/B23","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D24:D26)","v":0}]
[null,null,1,{"$f":"B24*C24","v":0}]
[null,null,1,0]
[null,null,1,0]
["d) Biens immobiliers",{"$f":"SUM(B28:B30)","v":0},{"$f":"D27/B27","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D28:D30)","v":0}]
[null,null,1,{"$f":"B28*C28","v":0}]
[null,null,1,{"$f":"B29*C29","v":0}]
[null,null,1,{"$f":"B30*C30","v":0}]
["e) Frais de sous-traitance ",{"$f":"SUM(B32:B34)","v":0},{"$f":"D31/B31","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D32:D34)","v":0}]
[null,null,1,{"$f":"B32*C32","v":0}]
[null,null,1,0]
[null,null,1,0]
["f) Dépenses spécifiques en relation avec les groupes cibles ",{"$f":"SUM(B36:B38)","v":0},{"$f":"D35/B35","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D36:D38)","v":0}]
[null,null,1,{"$f":"B36*C36","v":0}]
[null,null,1,{"$f":"B37*C37","v":0}]
[null,null,1,{"$f":"B38*C38","v":0}]
["TOTAL DES COÛTS DIRECTS ÉLIGIBLES",{"$f":"B35+B31+B27+B23+B19+B4","v":0},{"$f":"IF(B39<>0,D39/B39,\"-\")","v":"-"},{"$f":"D4+D35+D31+D27+D23+D19","v":0}]

{"sheet":" Détails frais perso_chef file","index":2,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,0,0,5],[16,0,16,3]]}
["Fonds Asile, migration et intégration\nProgrammation 2021-2027\n Plan de financement - Détail des frais de personnel  chef de file (le nommer)"]
["Fonction - Libellé","Nature du contrat\n(CDI, CDD, Contrat aidé, convention de stage, etc)","Taux d'affectation \nau projet","Expliquez le taux d'affectation\n(indiquer s'il est fixe ou variable)","Coût total employeur projet(€)\n(salaire brut + charges employeur)","Dépenses affectées au projet (€)"]
["1)",null,null,null,null,{"$f":"IF(E3<>0,C3*E3,\"-\")","v":"-"}]
["2)",null,null,null,null,"-"]
["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,"-"]
["11)",null,null,null,null,"-"]
["12)",null,null,null,null,"-"]
["13)",null,null,null,null,"-"]
["14)",null,null,null,null,"-"]
["Coût total",null,null,null,{"$f":"SUM(E3:E16)","v":0},{"$f":"SUM(F3:F16)","v":0}]

{"sheet":"Dépenses prev. _part1","index":3,"n_rows":39,"n_cols":10,"rows_kept":39,"cut":false,"hidden":false,"merged":[[21,5,21,6],[0,0,0,9],[1,1,1,3]]}
["Fonds Asile, migration et intégration\nProgrammation 2021-2027\n Plan de financement"]
["Dépenses prévisionnelles ","Partenaire 1 (le nommer)"]
[null,"Montant total\n( € )","Taux d'affectation","Coût affecté au projet",null,"RESSOURCES ","Montant total de la ressource ","Taux d'affectation  au projet éligible ","Montant affecté au projet éligible","% sur ressources totales affectées au projet éligible "]
["a) Frais de personnels\nNe pas saisir directement les informations en gris ci-dessous mais renseigner l'onglet \"Détail des frais de personnel\" de ce fichier. Les informations renseignées s'incrémenteront automatiquement",{"$f":"SUM(B5:B18)","v":0},{"$f":"D4/B4","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D5:D18)","v":0},null,"a) Cofinanceurs externes publics\n",{"$f":"SUM(G5:G10)","v":0},{"$f":"I4/G4","v":{"$error":"#DIV/0!"}},{"$f":"SUM(I5:I10)","v":0},{"$f":"I4/$I$22","v":{"$error":"#DIV/0!"}}]
["1)",{"$f":"' Détails frais de perso _part1'!E3","v":0},{"$f":"' Détails frais de perso _part1'!C3","v":0},{"$f":"' Détails frais de perso _part1'!F3","v":"-"},null,null,null,{"$f":"I5/G5","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"}]
["2)",{"$f":"' Détails frais de perso _part1'!E4","v":0},{"$f":"' Détails frais de perso _part1'!C4","v":0},{"$f":"' Détails frais de perso _part1'!F4","v":"-"},null,null,null,{"$f":"I6/G6","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"}]
[{"$f":"' Détails frais de perso _part1'!A5","v":"3)"},{"$f":"' Détails frais de perso _part1'!E5","v":0},{"$f":"' Détails frais de perso _part1'!C5","v":0},{"$f":"' Détails frais de perso _part1'!F5","v":"-"},null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[{"$f":"' Détails frais de perso _part1'!A6","v":"4)"},{"$f":"' Détails frais de perso _part1'!E6","v":0},{"$f":"' Détails frais de perso _part1'!C6","v":0},{"$f":"' Détails frais de perso _part1'!F6","v":"-"},null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[{"$f":"' Détails frais de perso _part1'!A7","v":"5)"},{"$f":"' Détails frais de perso _part1'!E7","v":0},{"$f":"' Détails frais de perso _part1'!C7","v":0},{"$f":"' Détails frais de perso _part1'!F7","v":"-"},null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[{"$f":"' Détails frais de perso _part1'!A8","v":"6)"},{"$f":"' Détails frais de perso _part1'!E8","v":0},{"$f":"' Détails frais de perso _part1'!C8","v":0},{"$f":"' Détails frais de perso _part1'!F8","v":"-"},null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[{"$f":"' Détails frais de perso _part1'!A9","v":"7)"},{"$f":"' Détails frais de perso _part1'!E9","v":0},{"$f":"' Détails frais de perso _part1'!C9","v":0},{"$f":"' Détails frais de perso _part1'!F9","v":"-"},null,"b) Cofinanceurs externes privés",{"$f":"SUM(G12:G17)","v":0},{"$f":"I11/G11","v":{"$error":"#DIV/0!"}},{"$f":"SUM(I12:I17)","v":0},{"$error":"#DIV/0!"}]
[{"$f":"' Détails frais de perso _part1'!A10","v":"8)"},{"$f":"' Détails frais de perso _part1'!E10","v":0},{"$f":"' Détails frais de perso _part1'!C10","v":0},{"$f":"' Détails frais de perso _part1'!F10","v":"-"},null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[{"$f":"' Détails frais de perso _part1'!A11","v":"9)"},{"$f":"' Détails frais de perso _part1'!E11","v":0},{"$f":"' Détails frais de perso _part1'!C11","v":0},{"$f":"' Détails frais de perso _part1'!F11","v":"-"},null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[{"$f":"' Détails frais de perso _part1'!A12","v":"10)"},{"$f":"' Détails frais de perso _part1'!E12","v":0},{"$f":"' Détails frais de perso _part1'!C12","v":0},{"$f":"' Détails frais de perso _part1'!F12","v":"-"},null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[{"$f":"' Détails frais de perso _part1'!A13","v":"11)"},{"$f":"' Détails frais de perso _part1'!E13","v":0},{"$f":"' Détails frais de perso _part1'!C13","v":0},{"$f":"' Détails frais de perso _part1'!F13","v":"-"},null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[{"$f":"' Détails frais de perso _part1'!A14","v":"12)"},{"$f":"' Détails frais de perso _part1'!E14","v":0},{"$f":"' Détails frais de perso _part1'!C14","v":0},{"$f":"' Détails frais de perso _part1'!F14","v":"-"},null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[{"$f":"' Détails frais de perso _part1'!A15","v":"13)"},{"$f":"' Détails frais de perso _part1'!E15","v":0},{"$f":"' Détails frais de perso _part1'!C15","v":0},{"$f":"' Détails frais de perso _part1'!F15","v":"-"},null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[{"$f":"' Détails frais de perso _part1'!A16","v":"14)"},{"$f":"' Détails frais de perso _part1'!E16","v":0},{"$f":"' Détails frais de perso _part1'!C16","v":0},{"$f":"' Détails frais de perso _part1'!F16","v":"-"},null,"d) Autofinancement (dont les recettes générées par le projet)",{"$f":"SUM(G19:G21)","v":0},{"$f":"I18/G18","v":{"$error":"#DIV/0!"}},{"$f":"SUM(I19:I21)","v":0},{"$error":"#DIV/0!"}]
["b) Frais de voyage et de séjour ",{"$f":"SUM(B20:B22)","v":0},{"$f":"D19/B19","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D20:D22)","v":0},null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[null,null,1,{"$f":"B20*C20","v":0},null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[null,null,1,0,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[null,null,1,0,null,"TOTAL DES RESSOURCES ELIGIBLES ",null,null,{"$f":"I18+I11+I4","v":0}]
["c) Frais d’équipement ",{"$f":"SUM(B24:B26)","v":0},{"$f":"D23/B23","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D24:D26)","v":0}]
[null,null,1,{"$f":"B24*C24","v":0}]
[null,null,1,0]
[null,null,1,0]
["d) Biens immobiliers",{"$f":"SUM(B28:B30)","v":0},{"$f":"D27/B27","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D28:D30)","v":0}]
[null,null,1,{"$f":"B28*C28","v":0}]
[null,null,1,{"$f":"B29*C29","v":0}]
[null,null,1,{"$f":"B30*C30","v":0}]
["e) Frais de sous-traitance ",{"$f":"SUM(B32:B34)","v":0},{"$f":"D31/B31","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D32:D34)","v":0}]
[null,null,1,{"$f":"B32*C32","v":0}]
[null,null,1,0]
[null,null,1,0]
["f) Dépenses spécifiques en relation avec les groupes cibles ",{"$f":"SUM(B36:B38)","v":0},{"$f":"D35/B35","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D36:D38)","v":0}]
[null,null,1,{"$f":"B36*C36","v":0}]
[null,null,1,{"$f":"B37*C37","v":0}]
[null,null,1,{"$f":"B38*C38","v":0}]
["TOTAL DES COÛTS DIRECTS ÉLIGIBLES",{"$f":"B35+B31+B27+B23+B19+B4","v":0},{"$f":"IF(B39<>0,D39/B39,\"-\")","v":"-"},{"$f":"D4+D35+D31+D27+D23+D19","v":0}]

{"sheet":" Détails frais de perso _part1","index":4,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,0,0,5],[16,0,16,3]]}
["Fonds Asile, migration et intégration\nProgrammation 2021-2027\n Plan de financement - Détail des frais de personnel  Partenaire 1 (le nommer)"]
["Fonction - Libellé","Nature du contrat\n(CDI, CDD, Contrat aidé, convention de stage, etc)","Taux d'affectation \nau projet","Expliquez le taux d'affectation\n(indiquer s'il est fixe ou variable)","Coût total employeur annuel (€)\n(salaire brut + charges employeur)","Dépenses affectées au projet (€)"]
["1)",null,null,null,0,{"$f":"IF(E3<>0,C3*E3,\"-\")","v":"-"}]
["2)",null,null,null,null,"-"]
["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,"-"]
["11)",null,null,null,null,"-"]
["12)",null,null,null,null,"-"]
["13)",null,null,null,null,"-"]
["14)",null,null,null,null,"-"]
["Coût total",null,null,null,{"$f":"SUM(E3:E16)","v":0},{"$f":"SUM(F3:F16)","v":0}]

{"sheet":"Dépenses prev. _part2","index":5,"n_rows":39,"n_cols":10,"rows_kept":39,"cut":false,"hidden":false,"merged":[[21,5,21,6],[0,0,0,9],[1,1,1,3]]}
["Fonds Asile, migration et intégration\nProgrammation 2021-2027\n Plan de financement"]
["Dépenses prévisionnelles ","Partenaire 2 (le nommer)"]
[null,"Montant total\n( € )","Taux d'affectation","Coût affecté au projet",null,"RESSOURCES ","Montant total de la ressource ","Taux d'affectation  au projet éligible ","Montant affecté au projet éligible","% sur ressources totales affectées au projet éligible "]
["a) Frais de personnels\nNe pas saisir directement les informations en gris ci-dessous mais renseigner l'onglet \"Détail des frais de personnel\" de ce fichier. Les informations renseignées s'incrémenteront automatiquement",{"$f":"SUM(B5:B18)","v":0},{"$f":"D4/B4","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D5:D18)","v":0},null,"a) Cofinanceurs externes publics\n",{"$f":"SUM(G5:G10)","v":0},{"$f":"I4/G4","v":{"$error":"#DIV/0!"}},{"$f":"SUM(I5:I10)","v":0},{"$f":"I4/$I$22","v":{"$error":"#DIV/0!"}}]
[{"$f":"' Détails frais de perso _part2'!A3","v":"1)"},{"$f":"' Détails frais de perso _part2'!E3","v":0},{"$f":"' Détails frais de perso _part2'!C3","v":0},{"$f":"' Détails frais de perso _part2'!F3","v":"-"},null,null,null,{"$f":"I5/G5","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"}]
[{"$f":"' Détails frais de perso _part2'!A4","v":"2)"},{"$f":"' Détails frais de perso _part2'!E4","v":0},{"$f":"' Détails frais de perso _part2'!C4","v":0},{"$f":"' Détails frais de perso _part2'!F4","v":"-"},null,null,null,{"$f":"I6/G6","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"}]
[{"$f":"' Détails frais de perso _part2'!A5","v":"3)"},{"$f":"' Détails frais de perso _part2'!E5","v":0},{"$f":"' Détails frais de perso _part2'!C5","v":0},{"$f":"' Détails frais de perso _part2'!F5","v":"-"},null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[{"$f":"' Détails frais de perso _part2'!A6","v":"4)"},{"$f":"' Détails frais de perso _part2'!E6","v":0},{"$f":"' Détails frais de perso _part2'!C6","v":0},{"$f":"' Détails frais de perso _part2'!F6","v":"-"},null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[{"$f":"' Détails frais de perso _part2'!A7","v":"5)"},{"$f":"' Détails frais de perso _part2'!E7","v":0},{"$f":"' Détails frais de perso _part2'!C7","v":0},{"$f":"' Détails frais de perso _part2'!F7","v":"-"},null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[{"$f":"' Détails frais de perso _part2'!A8","v":"6)"},{"$f":"' Détails frais de perso _part2'!E8","v":0},{"$f":"' Détails frais de perso _part2'!C8","v":0},{"$f":"' Détails frais de perso _part2'!F8","v":"-"},null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[{"$f":"' Détails frais de perso _part2'!A9","v":"7)"},{"$f":"' Détails frais de perso _part2'!E9","v":0},{"$f":"' Détails frais de perso _part2'!C9","v":0},{"$f":"' Détails frais de perso _part2'!F9","v":"-"},null,"b) Cofinanceurs externes privés",{"$f":"SUM(G12:G17)","v":0},{"$f":"I11/G11","v":{"$error":"#DIV/0!"}},{"$f":"SUM(I12:I17)","v":0},{"$error":"#DIV/0!"}]
[{"$f":"' Détails frais de perso _part2'!A10","v":"8)"},{"$f":"' Détails frais de perso _part2'!E10","v":0},{"$f":"' Détails frais de perso _part2'!C10","v":0},{"$f":"' Détails frais de perso _part2'!F10","v":"-"},null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[{"$f":"' Détails frais de perso _part2'!A11","v":"9)"},{"$f":"' Détails frais de perso _part2'!E11","v":0},{"$f":"' Détails frais de perso _part2'!C11","v":0},{"$f":"' Détails frais de perso _part2'!F11","v":"-"},null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[{"$f":"' Détails frais de perso _part2'!A12","v":"10)"},{"$f":"' Détails frais de perso _part2'!E12","v":0},{"$f":"' Détails frais de perso _part2'!C12","v":0},{"$f":"' Détails frais de perso _part2'!F12","v":"-"},null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[{"$f":"' Détails frais de perso _part2'!A13","v":"11)"},{"$f":"' Détails frais de perso _part2'!E13","v":0},{"$f":"' Détails frais de perso _part2'!C13","v":0},{"$f":"' Détails frais de perso _part2'!F13","v":"-"},null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[{"$f":"' Détails frais de perso _part2'!A14","v":"12)"},{"$f":"' Détails frais de perso _part2'!E14","v":0},{"$f":"' Détails frais de perso _part2'!C14","v":0},{"$f":"' Détails frais de perso _part2'!F14","v":"-"},null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[{"$f":"' Détails frais de perso _part2'!A15","v":"13)"},{"$f":"' Détails frais de perso _part2'!E15","v":0},{"$f":"' Détails frais de perso _part2'!C15","v":0},{"$f":"' Détails frais de perso _part2'!F15","v":"-"},null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[{"$f":"' Détails frais de perso _part2'!A16","v":"14)"},{"$f":"' Détails frais de perso _part2'!E16","v":0},{"$f":"' Détails frais de perso _part2'!C16","v":0},{"$f":"' Détails frais de perso _part2'!F16","v":"-"},null,"d) Autofinancement (dont les recettes générées par le projet)",{"$f":"SUM(G19:G21)","v":0},{"$f":"I18/G18","v":{"$error":"#DIV/0!"}},{"$f":"SUM(I19:I21)","v":0},{"$error":"#DIV/0!"}]
["b) Frais de voyage et de séjour ",{"$f":"SUM(B20:B22)","v":0},{"$f":"D19/B19","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D20:D22)","v":0},null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[null,null,1,{"$f":"B20*C20","v":0},null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[null,null,1,0,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[null,null,1,0,null,"TOTAL DES RESSOURCES ELIGIBLES ",null,null,{"$f":"I18+I11+I4","v":0}]
["c) Frais d’équipement ",{"$f":"SUM(B24:B26)","v":0},{"$f":"D23/B23","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D24:D26)","v":0}]
[null,null,1,{"$f":"B24*C24","v":0}]
[null,null,1,0]
[null,null,1,0]
["d) Biens immobiliers",{"$f":"SUM(B28:B30)","v":0},{"$f":"D27/B27","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D28:D30)","v":0}]
[null,null,1,{"$f":"B28*C28","v":0}]
[null,null,1,{"$f":"B29*C29","v":0}]
[null,null,1,{"$f":"B30*C30","v":0}]
["e) Frais de sous-traitance ",{"$f":"SUM(B32:B34)","v":0},{"$f":"D31/B31","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D32:D34)","v":0}]
[null,null,1,{"$f":"B32*C32","v":0}]
[null,null,1,0]
[null,null,1,0]
["f) Dépenses spécifiques en relation avec les groupes cibles ",{"$f":"SUM(B36:B38)","v":0},{"$f":"D35/B35","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D36:D38)","v":0}]
[null,null,1,{"$f":"B36*C36","v":0}]
[null,null,1,{"$f":"B37*C37","v":0}]
[null,null,1,{"$f":"B38*C38","v":0}]
["TOTAL DES COÛTS DIRECTS ÉLIGIBLES",{"$f":"B35+B31+B27+B23+B19+B4","v":0},{"$f":"IF(B39<>0,D39/B39,\"-\")","v":"-"},{"$f":"D4+D35+D31+D27+D23+D19","v":0}]

{"sheet":" Détails frais de perso _part2","index":6,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,0,0,5],[16,0,16,3]]}
["Fonds Asile, migration et intégration\nProgrammation 2021-2027\n Plan de financement - Détail des frais de personnel  Partenaire 2 (le nommer)"]
["Fonction - Libellé","Nature du contrat\n(CDI, CDD, Contrat aidé, convention de stage, etc)","Taux d'affectation \nau projet","Expliquez le taux d'affectation\n(indiquer s'il est fixe ou variable)","Coût total employeur annuel (€)\n(salaire brut + charges employeur)","Dépenses affectées au projet (€)"]
["1)",null,null,null,0,{"$f":"IF(E3<>0,C3*E3,\"-\")","v":"-"}]
["2)",null,null,null,null,"-"]
["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,"-"]
["11)",null,null,null,null,"-"]
["12)",null,null,null,null,"-"]
["13)",null,null,null,null,"-"]
["14)",null,null,null,null,"-"]
["Coût total",null,null,null,{"$f":"SUM(E3:E16)","v":0},{"$f":"SUM(F3:F16)","v":0}]

{"sheet":"Dépenses prev. _part3","index":7,"n_rows":39,"n_cols":10,"rows_kept":39,"cut":false,"hidden":false,"merged":[[21,5,21,6],[0,0,0,9],[1,1,1,3]]}
["Fonds Asile, migration et intégration\nProgrammation 2021-2027\n Plan de financement"]
["Dépenses prévisionnelles ","Partenaire 3 (le nommer)"]
[null,"Montant total\n( € )","Taux d'affectation","Coût affecté au projet",null,"RESSOURCES ","Montant total de la ressource ","Taux d'affectation  au projet éligible ","Montant affecté au projet éligible","% sur ressources totales affectées au projet éligible "]
["a) Frais de personnels affectés au projet ayant un rôle direct et déterminant\nNe pas saisir directement les informations en gris ci-dessous mais renseigner l'onglet \"Détail des frais de personnel\" de ce fichier. Les informations renseignées s'incrémenteront automatiquement",{"$f":"SUM(B5:B18)","v":0},{"$f":"D4/B4","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D5:D18)","v":0},null,"a) Cofinanceurs externes publics",{"$f":"SUM(G5:G10)","v":0},{"$f":"I4/G4","v":{"$error":"#DIV/0!"}},{"$f":"SUM(I5:I10)","v":0},{"$f":"I4/$I$22","v":{"$error":"#DIV/0!"}}]
[{"$f":"' Détails frais de perso _part3'!A3","v":"1)"},{"$f":"' Détails frais de perso _part3'!E3","v":0},{"$f":"' Détails frais de perso _part3'!C3","v":0},{"$f":"' Détails frais de perso _part3'!F3","v":"-"},null,null,null,{"$f":"I5/G5","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"}]
[{"$f":"' Détails frais de perso _part3'!A4","v":"2)"},{"$f":"' Détails frais de perso _part3'!E4","v":0},{"$f":"' Détails frais de perso _part3'!C4","v":0},{"$f":"' Détails frais de perso _part3'!F4","v":"-"},null,null,null,{"$f":"I6/G6","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"}]
[{"$f":"' Détails frais de perso _part3'!A5","v":"3)"},{"$f":"' Détails frais de perso _part3'!E5","v":0},{"$f":"' Détails frais de perso _part3'!C5","v":0},{"$f":"' Détails frais de perso _part3'!F5","v":"-"},null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[{"$f":"' Détails frais de perso _part3'!A6","v":"4)"},{"$f":"' Détails frais de perso _part3'!E6","v":0},{"$f":"' Détails frais de perso _part3'!C6","v":0},{"$f":"' Détails frais de perso _part3'!F6","v":"-"},null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[{"$f":"' Détails frais de perso _part3'!A7","v":"5)"},{"$f":"' Détails frais de perso _part3'!E7","v":0},{"$f":"' Détails frais de perso _part3'!C7","v":0},{"$f":"' Détails frais de perso _part3'!F7","v":"-"},null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[{"$f":"' Détails frais de perso _part3'!A8","v":"6)"},{"$f":"' Détails frais de perso _part3'!E8","v":0},{"$f":"' Détails frais de perso _part3'!C8","v":0},{"$f":"' Détails frais de perso _part3'!F8","v":"-"},null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[{"$f":"' Détails frais de perso _part3'!A9","v":"7)"},{"$f":"' Détails frais de perso _part3'!E9","v":0},{"$f":"' Détails frais de perso _part3'!C9","v":0},{"$f":"' Détails frais de perso _part3'!F9","v":"-"},null,"b) Cofinanceurs externes privés",{"$f":"SUM(G12:G17)","v":0},{"$f":"I11/G11","v":{"$error":"#DIV/0!"}},{"$f":"SUM(I12:I17)","v":0},{"$error":"#DIV/0!"}]
[{"$f":"' Détails frais de perso _part3'!A10","v":"8)"},{"$f":"' Détails frais de perso _part3'!E10","v":0},{"$f":"' Détails frais de perso _part3'!C10","v":0},{"$f":"' Détails frais de perso _part3'!F10","v":"-"},null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[{"$f":"' Détails frais de perso _part3'!A11","v":"9)"},{"$f":"' Détails frais de perso _part3'!E11","v":0},{"$f":"' Détails frais de perso _part3'!C11","v":0},{"$f":"' Détails frais de perso _part3'!F11","v":"-"},null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[{"$f":"' Détails frais de perso _part3'!A12","v":"10)"},{"$f":"' Détails frais de perso _part3'!E12","v":0},{"$f":"' Détails frais de perso _part3'!C12","v":0},{"$f":"' Détails frais de perso _part3'!F12","v":"-"},null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[{"$f":"' Détails frais de perso _part3'!A13","v":"11)"},{"$f":"' Détails frais de perso _part3'!E13","v":0},{"$f":"' Détails frais de perso _part3'!C13","v":0},{"$f":"' Détails frais de perso _part3'!F13","v":"-"},null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[{"$f":"' Détails frais de perso _part3'!A14","v":"12)"},{"$f":"' Détails frais de perso _part3'!E14","v":0},{"$f":"' Détails frais de perso _part3'!C14","v":0},{"$f":"' Détails frais de perso _part3'!F14","v":"-"},null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[{"$f":"' Détails frais de perso _part3'!A15","v":"13)"},{"$f":"' Détails frais de perso _part3'!E15","v":0},{"$f":"' Détails frais de perso _part3'!C15","v":0},{"$f":"' Détails frais de perso _part3'!F15","v":"-"},null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[{"$f":"' Détails frais de perso _part3'!A16","v":"14)"},{"$f":"' Détails frais de perso _part3'!E16","v":0},{"$f":"' Détails frais de perso _part3'!C16","v":0},{"$f":"' Détails frais de perso _part3'!F16","v":"-"},null,"d) Autofinancement (dont les recettes générées par le projet)",{"$f":"SUM(G19:G21)","v":0},{"$f":"I18/G18","v":{"$error":"#DIV/0!"}},{"$f":"SUM(I19:I21)","v":0},{"$error":"#DIV/0!"}]
["b) Frais de voyage et de séjour ",{"$f":"SUM(B20:B22)","v":0},{"$f":"D19/B19","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D20:D22)","v":0},null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[null,null,1,{"$f":"B20*C20","v":0},null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[null,null,1,0,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[null,null,1,0,null,"TOTAL DES RESSOURCES ELIGIBLES ",null,null,{"$f":"I18+I11+I4","v":0}]
["c) Frais d’équipement ",{"$f":"SUM(B24:B26)","v":0},{"$f":"D23/B23","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D24:D26)","v":0}]
[null,null,1,{"$f":"B24*C24","v":0}]
[null,null,1,0]
[null,null,1,0]
["d) Biens immobiliers",{"$f":"SUM(B28:B30)","v":0},{"$f":"D27/B27","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D28:D30)","v":0}]
[null,null,1,{"$f":"B28*C28","v":0}]
[null,null,1,{"$f":"B29*C29","v":0}]
[null,null,1,{"$f":"B30*C30","v":0}]
["e) Frais de sous-traitance ",{"$f":"SUM(B32:B34)","v":0},{"$f":"D31/B31","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D32:D34)","v":0}]
[null,null,1,{"$f":"B32*C32","v":0}]
[null,null,1,0]
[null,null,1,0]
["f) Dépenses spécifiques en relation avec les groupes cibles ",{"$f":"SUM(B36:B38)","v":0},{"$f":"D35/B35","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D36:D38)","v":0}]
[null,null,1,{"$f":"B36*C36","v":0}]
[null,null,1,{"$f":"B37*C37","v":0}]
[null,null,1,{"$f":"B38*C38","v":0}]
["TOTAL DES COÛTS DIRECTS ÉLIGIBLES",{"$f":"B35+B31+B27+B23+B19+B4","v":0},{"$f":"IF(B39<>0,D39/B39,\"-\")","v":"-"},{"$f":"D4+D35+D31+D27+D23+D19","v":0}]

{"sheet":" Détails frais de perso _part3","index":8,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,0,0,5],[16,0,16,3]]}
["Fonds Asile, migration et intégration\nProgrammation 2021-2027\n Plan de financement - Détail des frais de personnel  Partenaire 3 (le nommer)"]
["Fonction - Libellé","Nature du contrat\n(CDI, CDD, Contrat aidé, convention de stage, etc)","Taux d'affectation \nau projet","Expliquez le taux d'affectation\n(indiquer s'il est fixe ou variable)","Coût total employeur annuel (€)\n(salaire brut + charges employeur)","Dépenses affectées au projet (€)"]
["1)",null,null,null,0,{"$f":"IF(E3<>0,C3*E3,\"-\")","v":"-"}]
["2)",null,null,null,null,"-"]
["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,"-"]
["11)",null,null,null,null,"-"]
["12)",null,null,null,null,"-"]
["13)",null,null,null,null,"-"]
["14)",null,null,null,null,"-"]
["Coût total",null,null,null,{"$f":"SUM(E3:E16)","v":0},{"$f":"SUM(F3:F16)","v":0}]

{"sheet":"Dépenses prev. _part4","index":9,"n_rows":39,"n_cols":10,"rows_kept":39,"cut":false,"hidden":false,"merged":[[21,5,21,6],[0,0,0,9],[1,1,1,3]]}
["Fonds Asile, migration et intégration\nProgrammation 2021-2027\n Plan de financement"]
["Dépenses prévisionnelles ","Partenaire 4 (le nommer)"]
[null,"Montant total\n( € )","Taux d'affectation","Coût affecté au projet",null,"RESSOURCES ","Montant total de la ressource ","Taux d'affectation  au projet éligible ","Montant affecté au projet éligible","% sur ressources totales affectées au projet éligible "]
["a) Frais de personnels\nNe pas saisir directement les informations en gris ci-dessous mais renseigner l'onglet \"Détail des frais de personnel\" de ce fichier. Les informations renseignées s'incrémenteront automatiquement",{"$f":"SUM(B5:B18)","v":0},{"$f":"D4/B4","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D5:D18)","v":0},null,"a) Cofinanceurs externes publics\n",{"$f":"SUM(G5:G10)","v":0},{"$f":"I4/G4","v":{"$error":"#DIV/0!"}},{"$f":"SUM(I5:I10)","v":0},{"$f":"I4/$I$22","v":{"$error":"#DIV/0!"}}]
[{"$f":"' Détails frais de perso _part4'!A3","v":"1)"},{"$f":"' Détails frais de perso _part4'!E3","v":0},{"$f":"' Détails frais de perso _part4'!C3","v":0},{"$f":"' Détails frais de perso _part4'!F3","v":"-"},null,null,null,{"$f":"I5/G5","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"}]
[{"$f":"' Détails frais de perso _part4'!A4","v":"2)"},{"$f":"' Détails frais de perso _part4'!E4","v":0},{"$f":"' Détails frais de perso _part4'!C4","v":0},{"$f":"' Détails frais de perso _part4'!F4","v":"-"},null,null,null,{"$f":"I6/G6","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"}]
[{"$f":"' Détails frais de perso _part4'!A5","v":"3)"},{"$f":"' Détails frais de perso _part4'!E5","v":0},{"$f":"' Détails frais de perso _part4'!C5","v":0},{"$f":"' Détails frais de perso _part4'!F5","v":"-"},null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[{"$f":"' Détails frais de perso _part4'!A6","v":"4)"},{"$f":"' Détails frais de perso _part4'!E6","v":0},{"$f":"' Détails frais de perso _part4'!C6","v":0},{"$f":"' Détails frais de perso _part4'!F6","v":"-"},null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[{"$f":"' Détails frais de perso _part4'!A7","v":"5)"},{"$f":"' Détails frais de perso _part4'!E7","v":0},{"$f":"' Détails frais de perso _part4'!C7","v":0},{"$f":"' Détails frais de perso _part4'!F7","v":"-"},null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[{"$f":"' Détails frais de perso _part4'!A8","v":"6)"},{"$f":"' Détails frais de perso _part4'!E8","v":0},{"$f":"' Détails frais de perso _part4'!C8","v":0},{"$f":"' Détails frais de perso _part4'!F8","v":"-"},null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[{"$f":"' Détails frais de perso _part4'!A9","v":"7)"},{"$f":"' Détails frais de perso _part4'!E9","v":0},{"$f":"' Détails frais de perso _part4'!C9","v":0},{"$f":"' Détails frais de perso _part4'!F9","v":"-"},null,"b) Cofinanceurs externes privés",{"$f":"SUM(G12:G17)","v":0},{"$f":"I11/G11","v":{"$error":"#DIV/0!"}},{"$f":"SUM(I12:I17)","v":0},{"$error":"#DIV/0!"}]
[{"$f":"' Détails frais de perso _part4'!A10","v":"8)"},{"$f":"' Détails frais de perso _part4'!E10","v":0},{"$f":"' Détails frais de perso _part4'!C10","v":0},{"$f":"' Détails frais de perso _part4'!F10","v":"-"},null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[{"$f":"' Détails frais de perso _part4'!A11","v":"9)"},{"$f":"' Détails frais de perso _part4'!E11","v":0},{"$f":"' Détails frais de perso _part4'!C11","v":0},{"$f":"' Détails frais de perso _part4'!F11","v":"-"},null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[{"$f":"' Détails frais de perso _part4'!A12","v":"10)"},{"$f":"' Détails frais de perso _part4'!E12","v":0},{"$f":"' Détails frais de perso _part4'!C12","v":0},{"$f":"' Détails frais de perso _part4'!F12","v":"-"},null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[{"$f":"' Détails frais de perso _part4'!A13","v":"11)"},{"$f":"' Détails frais de perso _part4'!E13","v":0},{"$f":"' Détails frais de perso _part4'!C13","v":0},{"$f":"' Détails frais de perso _part4'!F13","v":"-"},null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[{"$f":"' Détails frais de perso _part4'!A14","v":"12)"},{"$f":"' Détails frais de perso _part4'!E14","v":0},{"$f":"' Détails frais de perso _part4'!C14","v":0},{"$f":"' Détails frais de perso _part4'!F14","v":"-"},null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[{"$f":"' Détails frais de perso _part4'!A15","v":"13)"},{"$f":"' Détails frais de perso _part4'!E15","v":0},{"$f":"' Détails frais de perso _part4'!C15","v":0},{"$f":"' Détails frais de perso _part4'!F15","v":"-"},null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[{"$f":"' Détails frais de perso _part4'!A16","v":"14)"},{"$f":"' Détails frais de perso _part4'!E16","v":0},{"$f":"' Détails frais de perso _part4'!C16","v":0},{"$f":"' Détails frais de perso _part4'!F16","v":"-"},null,"d) Autofinancement (dont les recettes générées par le projet)",{"$f":"SUM(G19:G21)","v":0},{"$f":"I18/G18","v":{"$error":"#DIV/0!"}},{"$f":"SUM(I19:I21)","v":0},{"$error":"#DIV/0!"}]
["b) Frais de voyage et de séjour ",{"$f":"SUM(B20:B22)","v":0},{"$f":"D19/B19","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D20:D22)","v":0},null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[null,null,1,{"$f":"B20*C20","v":0},null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[null,null,1,0,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[null,null,1,0,null,"TOTAL DES RESSOURCES ELIGIBLES ",null,null,{"$f":"I18+I11+I4","v":0}]
["c) Frais d’équipement ",{"$f":"SUM(B24:B26)","v":0},{"$f":"D23/B23","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D24:D26)","v":0}]
[null,null,1,{"$f":"B24*C24","v":0}]
[null,null,1,0]
[null,null,1,0]
["d) Biens immobiliers",{"$f":"SUM(B28:B30)","v":0},{"$f":"D27/B27","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D28:D30)","v":0}]
[null,null,1,{"$f":"B28*C28","v":0}]
[null,null,1,{"$f":"B29*C29","v":0}]
[null,null,1,{"$f":"B30*C30","v":0}]
["e) Frais de sous-traitance ",{"$f":"SUM(B32:B34)","v":0},{"$f":"D31/B31","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D32:D34)","v":0}]
[null,null,1,{"$f":"B32*C32","v":0}]
[null,null,1,0]
[null,null,1,0]
["f) Dépenses spécifiques en relation avec les groupes cibles ",{"$f":"SUM(B36:B38)","v":0},{"$f":"D35/B35","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D36:D38)","v":0}]
[null,null,1,{"$f":"B36*C36","v":0}]
[null,null,1,{"$f":"B37*C37","v":0}]
[null,null,1,{"$f":"B38*C38","v":0}]
["TOTAL DES COÛTS DIRECTS ÉLIGIBLES",{"$f":"B35+B31+B27+B23+B19+B4","v":0},{"$f":"IF(B39<>0,D39/B39,\"-\")","v":"-"},{"$f":"D4+D35+D31+D27+D23+D19","v":0}]

{"sheet":" Détails frais de perso _part4","index":10,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,0,0,5],[16,0,16,3]]}
["Fonds Asile, migration et intégration\nProgrammation 2021-2027\n Plan de financement - Détail des frais de personnel  Partenaire 4 (le nommer)"]
["Fonction - Libellé","Nature du contrat\n(CDI, CDD, Contrat aidé, convention de stage, etc)","Taux d'affectation \nau projet","Expliquez le taux d'affectation\n(indiquer s'il est fixe ou variable)","Coût total employeur annuel (€)\n(salaire brut + charges employeur)","Dépenses affectées au projet (€)"]
["1)",null,null,null,0,{"$f":"IF(E3<>0,C3*E3,\"-\")","v":"-"}]
["2)",null,null,null,null,"-"]
["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,"-"]
["11)",null,null,null,null,"-"]
["12)",null,null,null,null,"-"]
["13)",null,null,null,null,"-"]
["14)",null,null,null,null,"-"]
["Coût total",null,null,null,{"$f":"SUM(E3:E16)","v":0},{"$f":"SUM(F3:F16)","v":0}]

{"sheet":"Dépenses prev. _part5","index":11,"n_rows":39,"n_cols":10,"rows_kept":39,"cut":false,"hidden":false,"merged":[[21,5,21,6],[0,0,0,9],[1,1,1,3]]}
["Fonds Asile, migration et intégration\nProgrammation 2021-2027\n Plan de financement"]
["Dépenses prévisionnelles ","Partenaire 5 (le nommer)"]
[null,"Montant total\n( € )","Taux d'affectation","Coût affecté au projet",null,"RESSOURCES ","Montant total de la ressource ","Taux d'affectation  au projet éligible ","Montant affecté au projet éligible","% sur ressources totales affectées au projet éligible "]
["a) Frais de personnels\nNe pas saisir directement les informations en gris ci-dessous mais renseigner l'onglet \"Détail des frais de personnel\" de ce fichier. Les informations renseignées s'incrémenteront automatiquement",{"$f":"SUM(B5:B18)","v":0},{"$f":"D4/B4","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D5:D18)","v":0},null,"a) Cofinanceurs externes publics\n",{"$f":"SUM(G5:G10)","v":0},{"$f":"I4/G4","v":{"$error":"#DIV/0!"}},{"$f":"SUM(I5:I10)","v":0},{"$f":"I4/$I$22","v":{"$error":"#DIV/0!"}}]
[{"$f":"' Détails frais de perso _part5'!A3","v":"1)"},{"$f":"' Détails frais de perso _part5'!E3","v":0},{"$f":"' Détails frais de perso _part5'!C3","v":0},{"$f":"' Détails frais de perso _part5'!F3","v":"-"},null,null,null,{"$f":"I5/G5","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"}]
[{"$f":"' Détails frais de perso _part5'!A4","v":"2)"},{"$f":"' Détails frais de perso _part5'!E4","v":0},{"$f":"' Détails frais de perso _part5'!C4","v":0},{"$f":"' Détails frais de perso _part5'!F4","v":"-"},null,null,null,{"$f":"I6/G6","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"}]
[{"$f":"' Détails frais de perso _part5'!A5","v":"3)"},{"$f":"' Détails frais de perso _part5'!E5","v":0},{"$f":"' Détails frais de perso _part5'!C5","v":0},{"$f":"' Détails frais de perso _part5'!F5","v":"-"},null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[{"$f":"' Détails frais de perso _part5'!A6","v":"4)"},{"$f":"' Détails frais de perso _part5'!E6","v":0},{"$f":"' Détails frais de perso _part5'!C6","v":0},{"$f":"' Détails frais de perso _part5'!F6","v":"-"},null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[{"$f":"' Détails frais de perso _part5'!A7","v":"5)"},{"$f":"' Détails frais de perso _part5'!E7","v":0},{"$f":"' Détails frais de perso _part5'!C7","v":0},{"$f":"' Détails frais de perso _part5'!F7","v":"-"},null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[{"$f":"' Détails frais de perso _part5'!A8","v":"6)"},{"$f":"' Détails frais de perso _part5'!E8","v":0},{"$f":"' Détails frais de perso _part5'!C8","v":0},{"$f":"' Détails frais de perso _part5'!F8","v":"-"},null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[{"$f":"' Détails frais de perso _part5'!A9","v":"7)"},{"$f":"' Détails frais de perso _part5'!E9","v":0},{"$f":"' Détails frais de perso _part5'!C9","v":0},{"$f":"' Détails frais de perso _part5'!F9","v":"-"},null,"b) Cofinanceurs externes privés",{"$f":"SUM(G12:G17)","v":0},{"$f":"I11/G11","v":{"$error":"#DIV/0!"}},{"$f":"SUM(I12:I17)","v":0},{"$error":"#DIV/0!"}]
[{"$f":"' Détails frais de perso _part5'!A10","v":"8)"},{"$f":"' Détails frais de perso _part5'!E10","v":0},{"$f":"' Détails frais de perso _part5'!C10","v":0},{"$f":"' Détails frais de perso _part5'!F10","v":"-"},null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[{"$f":"' Détails frais de perso _part5'!A11","v":"9)"},{"$f":"' Détails frais de perso _part5'!E11","v":0},{"$f":"' Détails frais de perso _part5'!C11","v":0},{"$f":"' Détails frais de perso _part5'!F11","v":"-"},null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[{"$f":"' Détails frais de perso _part5'!A12","v":"10)"},{"$f":"' Détails frais de perso _part5'!E12","v":0},{"$f":"' Détails frais de perso _part5'!C12","v":0},{"$f":"' Détails frais de perso _part5'!F12","v":"-"},null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[{"$f":"' Détails frais de perso _part5'!A13","v":"11)"},{"$f":"' Détails frais de perso _part5'!E13","v":0},{"$f":"' Détails frais de perso _part5'!C13","v":0},{"$f":"' Détails frais de perso _part5'!F13","v":"-"},null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[{"$f":"' Détails frais de perso _part5'!A14","v":"12)"},{"$f":"' Détails frais de perso _part5'!E14","v":0},{"$f":"' Détails frais de perso _part5'!C14","v":0},{"$f":"' Détails frais de perso _part5'!F14","v":"-"},null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[{"$f":"' Détails frais de perso _part5'!A15","v":"13)"},{"$f":"' Détails frais de perso _part5'!E15","v":0},{"$f":"' Détails frais de perso _part5'!C15","v":0},{"$f":"' Détails frais de perso _part5'!F15","v":"-"},null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[{"$f":"' Détails frais de perso _part5'!A16","v":"14)"},{"$f":"' Détails frais de perso _part5'!E16","v":0},{"$f":"' Détails frais de perso _part5'!C16","v":0},{"$f":"' Détails frais de perso _part5'!F16","v":"-"},null,"d) Autofinancement (dont les recettes générées par le projet)",{"$f":"SUM(G19:G21)","v":0},{"$f":"I18/G18","v":{"$error":"#DIV/0!"}},{"$f":"SUM(I19:I21)","v":0},{"$error":"#DIV/0!"}]
["b) Frais de voyage et de séjour ",{"$f":"SUM(B20:B22)","v":0},{"$f":"D19/B19","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D20:D22)","v":0},null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[null,null,1,null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[null,null,1,{"$f":"B21*C21","v":0},null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[null,null,1,0,null,"TOTAL DES RESSOURCES ELIGIBLES ",null,null,{"$f":"I18+I11+I4","v":0}]
["c) Frais d’équipement ",{"$f":"SUM(B24:B26)","v":0},{"$f":"D23/B23","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D24:D26)","v":0}]
[null,null,1,0]
[null,null,1,{"$f":"B25*C25","v":0}]
[null,null,1,{"$f":"B26*C26","v":0}]
["d) Biens immobiliers",{"$f":"SUM(B28:B30)","v":0},{"$f":"D27/B27","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D28:D30)","v":0}]
[null,null,1,0]
[null,null,1,{"$f":"B29*C29","v":0}]
[null,null,1,{"$f":"B30*C30","v":0}]
["e) Frais de sous-traitance ",{"$f":"SUM(B32:B34)","v":0},{"$f":"D31/B31","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D32:D34)","v":0}]
[null,null,1,0]
[null,null,1,{"$f":"B33*C33","v":0}]
[null,null,1,0]
["f) Dépenses spécifiques en relation avec les groupes cibles ",{"$f":"SUM(B36:B38)","v":0},{"$f":"D35/B35","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D36:D38)","v":0}]
[null,null,1,{"$f":"B36*C36","v":0}]
[null,null,1,{"$f":"B37*C37","v":0}]
[null,null,1,{"$f":"B38*C38","v":0}]
["TOTAL DES COÛTS DIRECTS ÉLIGIBLES",{"$f":"B35+B31+B27+B23+B19+B4","v":0},{"$f":"IF(B39<>0,D39/B39,\"-\")","v":"-"},{"$f":"D4+D35+D31+D27+D23+D19","v":0}]

{"sheet":" Détails frais de perso _part5","index":12,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,0,0,5],[16,0,16,3]]}
["Fonds Asile, migration et intégration\nProgrammation 2021-2027\n Plan de financement - Détail des frais de personnel  Partenaire 5 (le nommer)"]
["Fonction - Libellé","Nature du contrat\n(CDI, CDD, Contrat aidé, convention de stage, etc)","Taux d'affectation \nau projet","Expliquez le taux d'affectation\n(indiquer s'il est fixe ou variable)","Coût total employeur annuel (€)\n(salaire brut + charges employeur)","Dépenses affectées au projet (€)"]
["1)",null,null,null,null,{"$f":"IF(E3<>0,C3*E3,\"-\")","v":"-"}]
["2)",null,null,null,null,"-"]
["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,"-"]
["11)",null,null,null,null,"-"]
["12)",null,null,null,null,"-"]
["13)",null,null,null,null,"-"]
["14)",null,null,null,null,"-"]
["Coût total",null,null,null,{"$f":"SUM(E3:E16)","v":0},{"$f":"SUM(F3:F16)","v":0}]

{"sheet":"Plan de financement global","index":13,"n_rows":230,"n_cols":12,"rows_kept":230,"cut":false,"hidden":false,"merged":[[2,9,2,11],[1,5,2,6],[1,7,1,8],[2,7,2,8],[0,0,0,11],[1,9,1,11],[122,5,122,11],[229,0,229,3],[222,0,223,0],[222,1,223,1],[222,2,223,2],[222,3,223,3],[226,0,227,1]]}
["Fonds Asile, migration et intégration - Programmation 2021-2027\n\nNom du porteur de projet :\nIntitulé du projet :\nN° SYNERGIE : \nPériode de réalisation :\n\nPlan de financement prévisionnel du projet"]
[null,null,null,null,null,"Pour la contribution du FAMI, le porteur de projet privé peut bénéficier d'une avance de 20% de la subvention prévisionnelle à la signature de l'acte attributif initial, souhaitez vous en bénéficier ? ",null,"OUI",null,"NON"]
[]
["POSTES DE DEPENSES","Coût total \n(€)\n","Taux d'affectation au projet (à justifier dans le descriptif du projet)","Coût éligible affecté au projet \n",null,"RESSOURCES ","Montant total de la ressource ","Taux d'affectation  au projet éligible ","Montant affecté au projet éligible","Decote applicable à la ressource","Montant affecté au projet éligible\naprès décote","% sur ressources totales affectées au projet éligible "]
["a) Frais de personnels",{"$f":"B6+B21+B51+B66+B81+B36","v":0},{"$f":"D5/B5","v":{"$error":"#DIV/0!"}},{"$f":"D6+D21+D51+D66+D81+D36","v":0},null,"a) Contribution FAMI",{"$f":"B225-G6-G49-G92","v":0},null,{"$f":"H5*G5","v":0},{"$f":"$C$228","v":0},{"$f":"(1-J5)*I5","v":0},{"$f":"K5/K117","v":{"$error":"#DIV/0!"}}]
[{"$f":"'Dépenses prév._chef de file'!B2","v":"Chef de file (le nommer)"},{"$f":"SUM(B7:B20)","v":0},{"$f":"D6/B6","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D7:D20)","v":0},null,"b) Cofinanceurs externes publics",{"$f":"SUM(G7:G48)","v":0},{"$f":"I6/G6","v":{"$error":"#DIV/0!"}},{"$f":"SUM(I7:I48)","v":0},{"$f":"$C$228","v":0},{"$f":"SUM(K7:K48)","v":0},{"$f":"K6/$K$117","v":{"$error":"#DIV/0!"}}]
[{"$f":"'Dépenses prév._chef de file'!A5","v":"1)"},{"$f":"'Dépenses prév._chef de file'!B5","v":0},{"$f":"'Dépenses prév._chef de file'!C5","v":"-"},{"$f":"'Dépenses prév._chef de file'!D5","v":"-"},null,{"$f":"'Dépenses prév._chef de file'!B2","v":"Chef de file (le nommer)"},{"$f":"SUM(G8:G13)","v":0},{"$f":"SUM(H8:H13)","v":{"$error":"#DIV/0!"}},0,0,0,{"$error":"#DIV/0!"}]
[{"$f":"'Dépenses prév._chef de file'!A6","v":"2)"},{"$f":"'Dépenses prév._chef de file'!B6","v":0},{"$f":"'Dépenses prév._chef de file'!C6","v":"-"},{"$f":"'Dépenses prev. _part1'!D5","v":"-"},null,{"$f":"'Dépenses prév._chef de file'!F5","v":0},{"$f":"'Dépenses prév._chef de file'!G5","v":0},{"$f":"'Dépenses prév._chef de file'!H5","v":{"$error":"#DIV/0!"}},{"$f":"'Dépenses prév._chef de file'!I5","v":0},{"$f":"$C$228","v":0},{"$f":"(1-J8)*I8","v":0},{"$f":"K8/$K$117","v":{"$error":"#DIV/0!"}}]
[{"$f":"'Dépenses prév._chef de file'!A7","v":"3)"},{"$f":"'Dépenses prév._chef de file'!B7","v":0},{"$f":"'Dépenses prév._chef de file'!C7","v":"-"},{"$f":"'Dépenses prev. _part1'!D6","v":"-"},null,{"$f":"'Dépenses prév._chef de file'!F6","v":0},{"$f":"'Dépenses prév._chef de file'!G6","v":0},{"$f":"'Dépenses prév._chef de file'!H6","v":{"$error":"#DIV/0!"}},{"$f":"'Dépenses prév._chef de file'!I6","v":0},{"$f":"$C$228","v":0},{"$f":"(1-J9)*I9","v":0},{"$error":"#DIV/0!"}]
[{"$f":"'Dépenses prév._chef de file'!A8","v":"4)"},{"$f":"'Dépenses prév._chef de file'!B8","v":0},{"$f":"'Dépenses prév._chef de file'!C8","v":"-"},{"$f":"'Dépenses prev. _part1'!D7","v":"-"},null,{"$f":"'Dépenses prév._chef de file'!F7","v":0},{"$f":"'Dépenses prév._chef de file'!G7","v":0},{"$f":"'Dépenses prév._chef de file'!H7","v":{"$error":"#DIV/0!"}},{"$f":"'Dépenses prév._chef de file'!I7","v":0},{"$f":"$C$228","v":0},0,{"$error":"#DIV/0!"}]
[{"$f":"'Dépenses prév._chef de file'!A9","v":"5)"},{"$f":"'Dépenses prév._chef de file'!B9","v":0},{"$f":"'Dépenses prév._chef de file'!C9","v":"-"},{"$f":"'Dépenses prev. _part1'!D8","v":"-"},null,{"$f":"'Dépenses prév._chef de file'!F8","v":0},{"$f":"'Dépenses prév._chef de file'!G8","v":0},{"$f":"'Dépenses prév._chef de file'!H8","v":{"$error":"#DIV/0!"}},{"$f":"'Dépenses prév._chef de file'!I8","v":0},0,0,{"$error":"#DIV/0!"}]
[{"$f":"'Dépenses prév._chef de file'!A10","v":"6)"},{"$f":"'Dépenses prév._chef de file'!B10","v":0},{"$f":"'Dépenses prév._chef de file'!C10","v":"-"},{"$f":"'Dépenses prev. _part1'!D9","v":"-"},null,{"$f":"'Dépenses prév._chef de file'!F9","v":0},{"$f":"'Dépenses prév._chef de file'!G9","v":0},{"$f":"'Dépenses prév._chef de file'!H9","v":{"$error":"#DIV/0!"}},{"$f":"'Dépenses prév._chef de file'!I9","v":0},0,0,{"$error":"#DIV/0!"}]
[{"$f":"'Dépenses prév._chef de file'!A11","v":"7)"},{"$f":"'Dépenses prév._chef de file'!B11","v":0},{"$f":"'Dépenses prév._chef de file'!C11","v":"-"},{"$f":"'Dépenses prev. _part1'!D10","v":"-"},null,{"$f":"'Dépenses prév._chef de file'!F10","v":0},{"$f":"'Dépenses prév._chef de file'!G10","v":0},{"$f":"'Dépenses prév._chef de file'!H10","v":{"$error":"#DIV/0!"}},{"$f":"'Dépenses prév._chef de file'!I10","v":0},0,0,{"$error":"#DIV/0!"}]
[{"$f":"'Dépenses prév._chef de file'!A12","v":"8)"},{"$f":"'Dépenses prév._chef de file'!B12","v":0},{"$f":"'Dépenses prév._chef de file'!C12","v":"-"},{"$f":"'Dépenses prev. _part1'!D11","v":"-"},null,{"$f":"'Dépenses prev. _part1'!B2","v":"Partenaire 1 (le nommer)"},{"$f":"SUM(G15:G20)","v":0},{"$f":"SUM(H15:H20)","v":{"$error":"#DIV/0!"}},0,0,0,{"$error":"#DIV/0!"}]
[{"$f":"'Dépenses prév._chef de file'!A13","v":"9)"},{"$f":"'Dépenses prév._chef de file'!B13","v":0},{"$f":"'Dépenses prév._chef de file'!C13","v":"-"},{"$f":"'Dépenses prev. _part1'!D12","v":"-"},null,{"$f":"'Dépenses prev. _part1'!F5","v":0},{"$f":"'Dépenses prev. _part1'!G5","v":0},{"$f":"'Dépenses prev. _part1'!H5","v":{"$error":"#DIV/0!"}},{"$f":"'Dépenses prev. _part1'!I5","v":0},{"$f":"$C$228","v":0},{"$f":"(1-J15)*I15","v":0},{"$f":"K15/$K$117","v":{"$error":"#DIV/0!"}}]
[{"$f":"'Dépenses prév._chef de file'!A14","v":"10)"},{"$f":"'Dépenses prév._chef de file'!B14","v":0},{"$f":"'Dépenses prév._chef de file'!C14","v":"-"},{"$f":"'Dépenses prev. _part1'!D13","v":"-"},null,{"$f":"'Dépenses prev. _part1'!F6","v":0},{"$f":"'Dépenses prev. _part1'!G6","v":0},{"$f":"'Dépenses prev. _part1'!H6","v":{"$error":"#DIV/0!"}},{"$f":"'Dépenses prev. _part1'!I6","v":0},{"$f":"$C$228","v":0},{"$f":"(1-J16)*I16","v":0},{"$f":"K16/$K$117","v":{"$error":"#DIV/0!"}}]
[{"$f":"'Dépenses prév._chef de file'!A15","v":"11)"},{"$f":"'Dépenses prév._chef de file'!B15","v":0},{"$f":"'Dépenses prév._chef de file'!C15","v":"-"},{"$f":"'Dépenses prev. _part1'!D14","v":"-"},null,{"$f":"'Dépenses prev. _part1'!F7","v":0},{"$f":"'Dépenses prev. _part1'!G7","v":0},{"$f":"'Dépenses prev. _part1'!H7","v":{"$error":"#DIV/0!"}},{"$f":"'Dépenses prev. _part1'!I7","v":0},0,0,{"$f":"K17/$K$117","v":{"$error":"#DIV/0!"}}]
[{"$f":"'Dépenses prév._chef de file'!A16","v":"12)"},{"$f":"'Dépenses prév._chef de file'!B16","v":0},{"$f":"'Dépenses prév._chef de file'!C16","v":"-"},{"$f":"'Dépenses prev. _part1'!D15","v":"-"},null,{"$f":"'Dépenses prev. _part1'!F8","v":0},{"$f":"'Dépenses prev. _part1'!G8","v":0},{"$f":"'Dépenses prev. _part1'!H8","v":{"$error":"#DIV/0!"}},{"$f":"'Dépenses prev. _part1'!I8","v":0},0,0,{"$f":"K18/$K$117","v":{"$error":"#DIV/0!"}}]
[{"$f":"'Dépenses prév._chef de file'!A17","v":"13)"},{"$f":"'Dépenses prév._chef de file'!B17","v":0},{"$f":"'Dépenses prév._chef de file'!C17","v":"-"},{"$f":"'Dépenses prev. _part1'!D16","v":"-"},null,{"$f":"'Dépenses prev. _part1'!F9","v":0},{"$f":"'Dépenses prev. _part1'!G9","v":0},{"$f":"'Dépenses prev. _part1'!H9","v":{"$error":"#DIV/0!"}},{"$f":"'Dépenses prev. _part1'!I9","v":0},0,{"$f":"(1-J19)*I19","v":0},{"$f":"K19/$K$117","v":{"$error":"#DIV/0!"}}]
[{"$f":"'Dépenses prév._chef de file'!A18","v":"14)"},{"$f":"'Dépenses prév._chef de file'!B18","v":0},{"$f":"'Dépenses prév._chef de file'!C18","v":"-"},{"$f":"'Dépenses prev. _part1'!D17","v":"-"},null,{"$f":"'Dépenses prev. _part1'!F10","v":0},{"$f":"'Dépenses prev. _part1'!G10","v":0},{"$f":"'Dépenses prev. _part1'!H10","v":{"$error":"#DIV/0!"}},{"$f":"'Dépenses prev. _part1'!I10","v":0},0,0,{"$error":"#DIV/0!"}]
[{"$f":"'Dépenses prev. _part1'!B2","v":"Partenaire 1 (le nommer)"},{"$f":"SUM(B22:B35)","v":0},{"$f":"D21/B21","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D22:D35)","v":0},null,{"$f":"'Dépenses prev. _part2'!B2","v":"Partenaire 2 (le nommer)"},{"$f":"SUM(G22:G27)","v":0},{"$f":"SUM(H22:H27)","v":{"$error":"#DIV/0!"}},0,0,0,{"$error":"#DIV/0!"}]
[{"$f":"'Dépenses prev. _part1'!A5","v":"1)"},{"$f":"'Dépenses prev. _part1'!B5","v":0},{"$f":"'Dépenses prev. _part1'!C5","v":0},{"$f":"'Dépenses prev. _part1'!D5","v":"-"},null,{"$f":"'Dépenses prev. _part2'!F5","v":0},{"$f":"'Dépenses prev. _part2'!G5","v":0},{"$f":"'Dépenses prev. _part2'!H5","v":{"$error":"#DIV/0!"}},{"$f":"'Dépenses prev. _part2'!I5","v":0},{"$f":"$C$228","v":0},0,{"$f":"K22/$K$117","v":{"$error":"#DIV/0!"}}]
[{"$f":"'Dépenses prev. _part1'!A6","v":"2)"},{"$f":"'Dépenses prev. _part1'!B6","v":0},{"$f":"'Dépenses prev. _part1'!C6","v":0},{"$f":"'Dépenses prev. _part1'!D6","v":"-"},null,{"$f":"'Dépenses prev. _part2'!F6","v":0},{"$f":"'Dépenses prev. _part2'!G6","v":0},{"$f":"'Dépenses prev. _part2'!H6","v":{"$error":"#DIV/0!"}},{"$f":"'Dépenses prev. _part2'!I6","v":0},{"$f":"$C$228","v":0},0,{"$error":"#DIV/0!"}]
[{"$f":"'Dépenses prev. _part1'!A7","v":"3)"},{"$f":"'Dépenses prev. _part1'!B7","v":0},{"$f":"'Dépenses prev. _part1'!C7","v":0},{"$f":"'Dépenses prev. _part1'!D7","v":"-"},null,{"$f":"'Dépenses prev. _part2'!F7","v":0},{"$f":"'Dépenses prev. _part2'!G7","v":0},{"$f":"'Dépenses prev. _part2'!H7","v":{"$error":"#DIV/0!"}},{"$f":"'Dépenses prev. _part2'!I7","v":0},0,0,{"$error":"#DIV/0!"}]
[{"$f":"'Dépenses prev. _part1'!A8","v":"4)"},{"$f":"'Dépenses prev. _part1'!B8","v":0},{"$f":"'Dépenses prev. _part1'!C8","v":0},{"$f":"'Dépenses prev. _part1'!D8","v":"-"},null,{"$f":"'Dépenses prev. _part2'!F8","v":0},{"$f":"'Dépenses prev. _part2'!G8","v":0},{"$f":"'Dépenses prev. _part2'!H8","v":{"$error":"#DIV/0!"}},{"$f":"'Dépenses prev. _part2'!I8","v":0},0,0,{"$error":"#DIV/0!"}]
[{"$f":"'Dépenses prev. _part1'!A9","v":"5)"},{"$f":"'Dépenses prev. _part1'!B9","v":0},{"$f":"'Dépenses prev. _part1'!C9","v":0},{"$f":"'Dépenses prev. _part1'!D9","v":"-"},null,{"$f":"'Dépenses prev. _part2'!F9","v":0},{"$f":"'Dépenses prev. _part2'!G9","v":0},{"$f":"'Dépenses prev. _part2'!H9","v":{"$error":"#DIV/0!"}},{"$f":"'Dépenses prev. _part2'!I9","v":0},0,0,{"$error":"#DIV/0!"}]
[{"$f":"'Dépenses prev. _part1'!A10","v":"6)"},{"$f":"'Dépenses prev. _part1'!B10","v":0},{"$f":"'Dépenses prev. _part1'!C10","v":0},{"$f":"'Dépenses prev. _part1'!D10","v":"-"},null,{"$f":"'Dépenses prev. _part2'!F10","v":0},{"$f":"'Dépenses prev. _part2'!G10","v":0},{"$f":"'Dépenses prev. _part2'!H10","v":{"$error":"#DIV/0!"}},{"$f":"'Dépenses prev. _part2'!I10","v":0},0,0,{"$error":"#DIV/0!"}]
[{"$f":"'Dépenses prev. _part1'!A11","v":"7)"},{"$f":"'Dépenses prev. _part1'!B11","v":0},{"$f":"'Dépenses prev. _part1'!C11","v":0},{"$f":"'Dépenses prev. _part1'!D11","v":"-"},null,{"$f":"'Dépenses prev. _part3'!B2","v":"Partenaire 3 (le nommer)"},{"$f":"SUM(G29:G34)","v":0},{"$f":"SUM(H29:H34)","v":{"$error":"#DIV/0!"}},0,0,0,{"$error":"#DIV/0!"}]
[{"$f":"'Dépenses prev. _part1'!A12","v":"8)"},{"$f":"'Dépenses prev. _part1'!B12","v":0},{"$f":"'Dépenses prev. _part1'!C12","v":0},{"$f":"'Dépenses prev. _part1'!D12","v":"-"},null,{"$f":"'Dépenses prev. _part3'!F5","v":0},{"$f":"'Dépenses prev. _part3'!G5","v":0},{"$f":"'Dépenses prev. _part3'!H5","v":{"$error":"#DIV/0!"}},{"$f":"'Dépenses prev. _part3'!I5","v":0},{"$f":"$C$228","v":0},0,{"$f":"K29/$K$117","v":{"$error":"#DIV/0!"}}]
[{"$f":"'Dépenses prev. _part1'!A13","v":"9)"},{"$f":"'Dépenses prev. _part1'!B13","v":0},{"$f":"'Dépenses prev. _part1'!C13","v":0},{"$f":"'Dépenses prev. _part1'!D13","v":"-"},null,{"$f":"'Dépenses prev. _part3'!F6","v":0},{"$f":"'Dépenses prev. _part3'!G6","v":0},{"$f":"'Dépenses prev. _part3'!H6","v":{"$error":"#DIV/0!"}},{"$f":"'Dépenses prev. _part3'!I6","v":0},{"$f":"$C$228","v":0},0,{"$error":"#DIV/0!"}]
[{"$f":"'Dépenses prev. _part1'!A14","v":"10)"},{"$f":"'Dépenses prev. _part1'!B14","v":0},{"$f":"'Dépenses prev. _part1'!C14","v":0},{"$f":"'Dépenses prev. _part1'!D14","v":"-"},null,{"$f":"'Dépenses prev. _part3'!F7","v":0},{"$f":"'Dépenses prev. _part3'!G7","v":0},{"$f":"'Dépenses prev. _part3'!H7","v":{"$error":"#DIV/0!"}},{"$f":"'Dépenses prev. _part3'!I7","v":0},0,0,{"$error":"#DIV/0!"}]
[{"$f":"'Dépenses prev. _part1'!A15","v":"11)"},{"$f":"'Dépenses prev. _part1'!B15","v":0},{"$f":"'Dépenses prev. _part1'!C15","v":0},{"$f":"'Dépenses prev. _part1'!D15","v":"-"},null,{"$f":"'Dépenses prev. _part3'!F8","v":0},{"$f":"'Dépenses prev. _part3'!G8","v":0},{"$f":"'Dépenses prev. _part3'!H8","v":{"$error":"#DIV/0!"}},{"$f":"'Dépenses prev. _part3'!I8","v":0},0,0,{"$error":"#DIV/0!"}]
[{"$f":"'Dépenses prev. _part1'!A16","v":"12)"},{"$f":"'Dépenses prev. _part1'!B16","v":0},{"$f":"'Dépenses prev. _part1'!C16","v":0},{"$f":"'Dépenses prev. _part1'!D16","v":"-"},null,{"$f":"'Dépenses prev. _part3'!F9","v":0},{"$f":"'Dépenses prev. _part3'!G9","v":0},{"$f":"'Dépenses prev. _part3'!H9","v":{"$error":"#DIV/0!"}},{"$f":"'Dépenses prev. _part3'!I9","v":0},0,0,{"$error":"#DIV/0!"}]
[{"$f":"'Dépenses prev. _part1'!A17","v":"13)"},{"$f":"'Dépenses prev. _part1'!B17","v":0},{"$f":"'Dépenses prev. _part1'!C17","v":0},{"$f":"'Dépenses prev. _part1'!D17","v":"-"},null,{"$f":"'Dépenses prev. _part3'!F10","v":0},{"$f":"'Dépenses prev. _part3'!G10","v":0},{"$f":"'Dépenses prev. _part3'!H10","v":{"$error":"#DIV/0!"}},{"$f":"'Dépenses prev. _part3'!I10","v":0},0,0,{"$error":"#DIV/0!"}]
[{"$f":"'Dépenses prev. _part1'!A18","v":"14)"},{"$f":"'Dépenses prev. _part1'!B18","v":0},{"$f":"'Dépenses prev. _part1'!C18","v":0},{"$f":"'Dépenses prev. _part1'!D18","v":"-"},null,{"$f":"'Dépenses prev. _part4'!B2","v":"Partenaire 4 (le nommer)"},{"$f":"SUM(G36:G41)","v":0},{"$f":"SUM(H36:H41)","v":{"$error":"#DIV/0!"}},0,0,0,{"$error":"#DIV/0!"}]
[{"$f":"'Dépenses prev. _part2'!B2","v":"Partenaire 2 (le nommer)"},{"$f":"SUM(B37:B50)","v":0},{"$f":"D36/B36","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D37:D50)","v":0},null,{"$f":"'Dépenses prev. _part4'!F5","v":0},{"$f":"'Dépenses prev. _part4'!G5","v":0},{"$f":"'Dépenses prev. _part4'!H5","v":{"$error":"#DIV/0!"}},{"$f":"'Dépenses prev. _part4'!I5","v":0},{"$f":"$C$228","v":0},0,{"$f":"K36/$K$117","v":{"$error":"#DIV/0!"}}]
[{"$f":"'Dépenses prev. _part2'!A5","v":"1)"},{"$f":"'Dépenses prev. _part2'!B5","v":0},{"$f":"'Dépenses prev. _part2'!C5","v":0},{"$f":"'Dépenses prev. _part2'!D5","v":"-"},null,{"$f":"'Dépenses prev. _part4'!F6","v":0},{"$f":"'Dépenses prev. _part4'!G6","v":0},{"$f":"'Dépenses prev. _part4'!H6","v":{"$error":"#DIV/0!"}},{"$f":"'Dépenses prev. _part4'!I6","v":0},{"$f":"$C$228","v":0},0,{"$error":"#DIV/0!"}]
[{"$f":"'Dépenses prev. _part2'!A6","v":"2)"},{"$f":"'Dépenses prev. _part2'!B6","v":0},{"$f":"'Dépenses prev. _part2'!C6","v":0},{"$f":"'Dépenses prev. _part2'!D6","v":"-"},null,{"$f":"'Dépenses prev. _part4'!F7","v":0},{"$f":"'Dépenses prev. _part4'!G7","v":0},{"$f":"'Dépenses prev. _part4'!H7","v":{"$error":"#DIV/0!"}},{"$f":"'Dépenses prev. _part4'!I7","v":0},0,0,{"$error":"#DIV/0!"}]
[{"$f":"'Dépenses prev. _part2'!A7","v":"3)"},{"$f":"'Dépenses prev. _part2'!B7","v":0},{"$f":"'Dépenses prev. _part2'!C7","v":0},{"$f":"'Dépenses prev. _part2'!D7","v":"-"},null,{"$f":"'Dépenses prev. _part4'!F8","v":0},{"$f":"'Dépenses prev. _part4'!G8","v":0},{"$f":"'Dépenses prev. _part4'!H8","v":{"$error":"#DIV/0!"}},{"$f":"'Dépenses prev. _part4'!I8","v":0},0,0,{"$error":"#DIV/0!"}]
[{"$f":"'Dépenses prev. _part2'!A8","v":"4)"},{"$f":"'Dépenses prev. _part2'!B8","v":0},{"$f":"'Dépenses prev. _part2'!C8","v":0},{"$f":"'Dépenses prev. _part2'!D8","v":"-"},null,{"$f":"'Dépenses prev. _part4'!F9","v":0},{"$f":"'Dépenses prev. _part4'!G9","v":0},{"$f":"'Dépenses prev. _part4'!H9","v":{"$error":"#DIV/0!"}},{"$f":"'Dépenses prev. _part4'!I9","v":0},0,0,{"$error":"#DIV/0!"}]
[{"$f":"'Dépenses prev. _part2'!A9","v":"5)"},{"$f":"'Dépenses prev. _part2'!B9","v":0},{"$f":"'Dépenses prev. _part2'!C9","v":0},{"$f":"'Dépenses prev. _part2'!D9","v":"-"},null,{"$f":"'Dépenses prev. _part4'!F10","v":0},{"$f":"'Dépenses prev. _part4'!G10","v":0},{"$f":"'Dépenses prev. _part4'!H10","v":{"$error":"#DIV/0!"}},{"$f":"'Dépenses prev. _part4'!I10","v":0},0,0,{"$error":"#DIV/0!"}]
[{"$f":"'Dépenses prev. _part2'!A10","v":"6)"},{"$f":"'Dépenses prev. _part2'!B10","v":0},{"$f":"'Dépenses prev. _part2'!C10","v":0},{"$f":"'Dépenses prev. _part2'!D10","v":"-"},null,{"$f":"'Dépenses prev. _part5'!B2","v":"Partenaire 5 (le nommer)"},{"$f":"SUM(G43:G48)","v":0},{"$f":"SUM(H43:H48)","v":{"$error":"#DIV/0!"}},0,0,0,{"$error":"#DIV/0!"}]
[{"$f":"'Dépenses prev. _part2'!A11","v":"7)"},{"$f":"'Dépenses prev. _part2'!B11","v":0},{"$f":"'Dépenses prev. _part2'!C11","v":0},{"$f":"'Dépenses prev. _part2'!D11","v":"-"},null,{"$f":"'Dépenses prev. _part5'!F5","v":0},{"$f":"'Dépenses prev. _part5'!G5","v":0},{"$f":"'Dépenses prev. _part5'!H5","v":{"$error":"#DIV/0!"}},{"$f":"'Dépenses prev. _part5'!I5","v":0},{"$f":"$C$228","v":0},0,{"$f":"K43/$K$117","v":{"$error":"#DIV/0!"}}]
[{"$f":"'Dépenses prev. _part2'!A12","v":"8)"},{"$f":"'Dépenses prev. _part2'!B12","v":0},{"$f":"'Dépenses prev. _part2'!C12","v":0},{"$f":"'Dépenses prev. _part2'!D12","v":"-"},null,{"$f":"'Dépenses prev. _part5'!F6","v":0},{"$f":"'Dépenses prev. _part5'!G6","v":0},{"$f":"'Dépenses prev. _part5'!H6","v":{"$error":"#DIV/0!"}},{"$f":"'Dépenses prev. _part5'!I6","v":0},{"$f":"$C$228","v":0},0,{"$error":"#DIV/0!"}]
[{"$f":"'Dépenses prev. _part2'!A13","v":"9)"},{"$f":"'Dépenses prev. _part2'!B13","v":0},{"$f":"'Dépenses prev. _part2'!C13","v":0},{"$f":"'Dépenses prev. _part2'!D13","v":"-"},null,{"$f":"'Dépenses prev. _part5'!F7","v":0},{"$f":"'Dépenses prev. _part5'!G7","v":0},{"$f":"'Dépenses prev. _part5'!H7","v":{"$error":"#DIV/0!"}},{"$f":"'Dépenses prev. _part5'!I7","v":0},0,0,{"$error":"#DIV/0!"}]
[{"$f":"'Dépenses prev. _part2'!A14","v":"10)"},{"$f":"'Dépenses prev. _part2'!B14","v":0},{"$f":"'Dépenses prev. _part2'!C14","v":0},{"$f":"'Dépenses prev. _part2'!D14","v":"-"},null,{"$f":"'Dépenses prev. _part5'!F8","v":0},{"$f":"'Dépenses prev. _part5'!G8","v":0},{"$f":"'Dépenses prev. _part5'!H8","v":{"$error":"#DIV/0!"}},{"$f":"'Dépenses prev. _part5'!I8","v":0},0,0,{"$error":"#DIV/0!"}]
[{"$f":"'Dépenses prev. _part2'!A15","v":"11)"},{"$f":"'Dépenses prev. _part2'!B15","v":0},{"$f":"'Dépenses prev. _part2'!C15","v":0},{"$f":"'Dépenses prev. _part2'!D15","v":"-"},null,{"$f":"'Dépenses prev. _part5'!F9","v":0},{"$f":"'Dépenses prev. _part5'!G9","v":0},{"$f":"'Dépenses prev. _part5'!H9","v":{"$error":"#DIV/0!"}},{"$f":"'Dépenses prev. _part5'!I9","v":0},0,0,{"$error":"#DIV/0!"}]
[{"$f":"'Dépenses prev. _part2'!A16","v":"12)"},{"$f":"'Dépenses prev. _part2'!B16","v":0},{"$f":"'Dépenses prev. _part2'!C16","v":0},{"$f":"'Dépenses prev. _part2'!D16","v":"-"},null,{"$f":"'Dépenses prev. _part5'!F10","v":0},{"$f":"'Dépenses prev. _part5'!G10","v":0},{"$f":"'Dépenses prev. _part5'!H10","v":{"$error":"#DIV/0!"}},{"$f":"'Dépenses prev. _part5'!I10","v":0},0,0,{"$error":"#DIV/0!"}]
[{"$f":"'Dépenses prev. _part2'!A17","v":"13)"},{"$f":"'Dépenses prev. _part2'!B17","v":0},{"$f":"'Dépenses prev. _part2'!C17","v":0},{"$f":"'Dépenses prev. _part2'!D17","v":"-"},null,"c) Cofinanceurs externes privés",{"$f":"SUM(G50:G91)","v":0},{"$f":"I49/G49","v":{"$error":"#DIV/0!"}},{"$f":"SUM(I50:I91)","v":0},{"$f":"I49*$B$229","v":0},{"$f":"SUM(K50:K91)","v":0},{"$error":"#DIV/0!"}]
[{"$f":"'Dépenses prev. _part2'!A18","v":"14)"},{"$f":"'Dépenses prev. _part2'!B18","v":0},{"$f":"'Dépenses prev. _part2'!C18","v":0},{"$f":"'Dépenses prev. _part2'!D18","v":"-"},null,{"$f":"'Dépenses prév._chef de file'!B2","v":"Chef de file (le nommer)"},{"$f":"SUM(G51:G56)","v":0},{"$f":"SUM(H51:H56)","v":{"$error":"#DIV/0!"}},0,0,0,{"$error":"#DIV/0!"}]
[{"$f":"'Dépenses prev. _part3'!B2","v":"Partenaire 3 (le nommer)"},{"$f":"SUM(B52:B65)","v":0},{"$f":"D51/B51","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D52:D65)","v":0},null,{"$f":"'Dépenses prév._chef de file'!F12","v":0},{"$f":"'Dépenses prév._chef de file'!G12","v":0},{"$f":"'Dépenses prév._chef de file'!H12","v":{"$error":"#DIV/0!"}},{"$f":"'Dépenses prév._chef de file'!I12","v":0},{"$f":"$C$228","v":0},{"$f":"(1-J51)*I51","v":0},{"$f":"K51/$K$117","v":{"$error":"#DIV/0!"}}]
[{"$f":"'Dépenses prev. _part3'!A5","v":"1)"},{"$f":"'Dépenses prev. _part3'!B5","v":0},{"$f":"'Dépenses prev. _part3'!C5","v":0},{"$f":"'Dépenses prev. _part3'!D5","v":"-"},null,{"$f":"'Dépenses prév._chef de file'!F13","v":0},{"$f":"'Dépenses prév._chef de file'!G13","v":0},{"$f":"'Dépenses prév._chef de file'!H13","v":{"$error":"#DIV/0!"}},{"$f":"'Dépenses prév._chef de file'!I13","v":0},{"$f":"$C$228","v":0},0,{"$error":"#DIV/0!"}]
[{"$f":"'Dépenses prev. _part3'!A6","v":"2)"},{"$f":"'Dépenses prev. _part3'!B6","v":0},{"$f":"'Dépenses prev. _part3'!C6","v":0},{"$f":"'Dépenses prev. _part3'!D6","v":"-"},null,{"$f":"'Dépenses prév._chef de file'!F14","v":0},{"$f":"'Dépenses prév._chef de file'!G14","v":0},{"$f":"'Dépenses prév._chef de file'!H14","v":{"$error":"#DIV/0!"}},{"$f":"'Dépenses prév._chef de file'!I14","v":0},0,0,{"$error":"#DIV/0!"}]
[{"$f":"'Dépenses prev. _part3'!A7","v":"3)"},{"$f":"'Dépenses prev. _part3'!B7","v":0},{"$f":"'Dépenses prev. _part3'!C7","v":0},{"$f":"'Dépenses prev. _part3'!D7","v":"-"},null,{"$f":"'Dépenses prév._chef de file'!F15","v":0},{"$f":"'Dépenses prév._chef de file'!G15","v":0},{"$f":"'Dépenses prév._chef de file'!H15","v":{"$error":"#DIV/0!"}},{"$f":"'Dépenses prév._chef de file'!I15","v":0},0,0,{"$error":"#DIV/0!"}]
[{"$f":"'Dépenses prev. _part3'!A8","v":"4)"},{"$f":"'Dépenses prev. _part3'!B8","v":0},{"$f":"'Dépenses prev. _part3'!C8","v":0},{"$f":"'Dépenses prev. _part3'!D8","v":"-"},null,{"$f":"'Dépenses prév._chef de file'!F16","v":0},{"$f":"'Dépenses prév._chef de file'!G16","v":0},{"$f":"'Dépenses prév._chef de file'!H16","v":{"$error":"#DIV/0!"}},{"$f":"'Dépenses prév._chef de file'!I16","v":0},0,0,{"$error":"#DIV/0!"}]
[{"$f":"'Dépenses prev. _part3'!A9","v":"5)"},{"$f":"'Dépenses prev. _part3'!B9","v":0},{"$f":"'Dépenses prev. _part3'!C9","v":0},{"$f":"'Dépenses prev. _part3'!D9","v":"-"},null,{"$f":"'Dépenses prév._chef de file'!F17","v":0},{"$f":"'Dépenses prév._chef de file'!G17","v":0},{"$f":"'Dépenses prév._chef de file'!H17","v":{"$error":"#DIV/0!"}},{"$f":"'Dépenses prév._chef de file'!I17","v":0},0,0,{"$error":"#DIV/0!"}]
[{"$f":"'Dépenses prev. _part3'!A10","v":"6)"},{"$f":"'Dépenses prev. _part3'!B10","v":0},{"$f":"'Dépenses prev. _part3'!C10","v":0},{"$f":"'Dépenses prev. _part3'!D10","v":"-"},null,{"$f":"'Dépenses prev. _part1'!B2","v":"Partenaire 1 (le nommer)"},{"$f":"SUM(G58:G63)","v":0},{"$f":"SUM(H58:H63)","v":{"$error":"#DIV/0!"}},0,0,0,{"$error":"#DIV/0!"}]
[{"$f":"'Dépenses prev. _part3'!A11","v":"7)"},{"$f":"'Dépenses prev. _part3'!B11","v":0},{"$f":"'Dépenses prev. _part3'!C11","v":0},{"$f":"'Dépenses prev. _part3'!D11","v":"-"},null,{"$f":"'Dépenses prev. _part1'!F12","v":0},{"$f":"'Dépenses prev. _part1'!G12","v":0},{"$f":"'Dépenses prev. _part1'!H12","v":{"$error":"#DIV/0!"}},{"$f":"'Dépenses prev. _part1'!I12","v":0},{"$f":"$C$228","v":0},0,{"$f":"K58/$K$117","v":{"$error":"#DIV/0!"}}]
[{"$f":"'Dépenses prev. _part3'!A12","v":"8)"},{"$f":"'Dépenses prev. _part3'!B12","v":0},{"$f":"'Dépenses prev. _part3'!C12","v":0},{"$f":"'Dépenses prev. _part3'!D12","v":"-"},null,{"$f":"'Dépenses prev. _part1'!F13","v":0},{"$f":"'Dépenses prev. _part1'!G13","v":0},{"$f":"'Dépenses prev. _part1'!H13","v":{"$error":"#DIV/0!"}},{"$f":"'Dépenses prev. _part1'!I13","v":0},{"$f":"$C$228","v":0},0,{"$error":"#DIV/0!"}]
[{"$f":"'Dépenses prev. _part3'!A13","v":"9)"},{"$f":"'Dépenses prev. _part3'!B13","v":0},{"$f":"'Dépenses prev. _part3'!C13","v":0},{"$f":"'Dépenses prev. _part3'!D13","v":"-"},null,{"$f":"'Dépenses prev. _part1'!F14","v":0},{"$f":"'Dépenses prev. _part1'!G14","v":0},{"$f":"'Dépenses prev. _part1'!H14","v":{"$error":"#DIV/0!"}},{"$f":"'Dépenses prev. _part1'!I14","v":0},0,0,{"$error":"#DIV/0!"}]
[{"$f":"'Dépenses prev. _part3'!A14","v":"10)"},{"$f":"'Dépenses prev. _part3'!B14","v":0},{"$f":"'Dépenses prev. _part3'!C14","v":0},{"$f":"'Dépenses prev. _part3'!D14","v":"-"},null,{"$f":"'Dépenses prev. _part1'!F15","v":0},{"$f":"'Dépenses prev. _part1'!G15","v":0},{"$f":"'Dépenses prev. _part1'!H15","v":{"$error":"#DIV/0!"}},{"$f":"'Dépenses prev. _part1'!I15","v":0},0,0,{"$error":"#DIV/0!"}]
[{"$f":"'Dépenses prev. _part3'!A15","v":"11)"},{"$f":"'Dépenses prev. _part3'!B15","v":0},{"$f":"'Dépenses prev. _part3'!C15","v":0},{"$f":"'Dépenses prev. _part3'!D15","v":"-"},null,{"$f":"'Dépenses prev. _part1'!F16","v":0},{"$f":"'Dépenses prev. _part1'!G16","v":0},{"$f":"'Dépenses prev. _part1'!H16","v":{"$error":"#DIV/0!"}},{"$f":"'Dépenses prev. _part1'!I16","v":0},0,0,{"$error":"#DIV/0!"}]
[{"$f":"'Dépenses prev. _part3'!A16","v":"12)"},{"$f":"'Dépenses prev. _part3'!B16","v":0},{"$f":"'Dépenses prev. _part3'!C16","v":0},{"$f":"'Dépenses prev. _part3'!D16","v":"-"},null,{"$f":"'Dépenses prev. _part1'!F17","v":0},{"$f":"'Dépenses prev. _part1'!G17","v":0},{"$f":"'Dépenses prev. _part1'!H17","v":{"$error":"#DIV/0!"}},{"$f":"'Dépenses prev. _part1'!I17","v":0},0,0,{"$error":"#DIV/0!"}]
[{"$f":"'Dépenses prev. _part3'!A17","v":"13)"},{"$f":"'Dépenses prev. _part3'!B17","v":0},{"$f":"'Dépenses prev. _part3'!C17","v":0},{"$f":"'Dépenses prev. _part3'!D17","v":"-"},null,{"$f":"'Dépenses prev. _part2'!B2","v":"Partenaire 2 (le nommer)"},{"$f":"SUM(G65:G70)","v":0},{"$f":"SUM(H65:H70)","v":{"$error":"#DIV/0!"}},0,0,0,{"$error":"#DIV/0!"}]
[{"$f":"'Dépenses prev. _part3'!A18","v":"14)"},{"$f":"'Dépenses prev. _part3'!B18","v":0},{"$f":"'Dépenses prev. _part3'!C18","v":0},{"$f":"'Dépenses prev. _part3'!D18","v":"-"},null,{"$f":"'Dépenses prev. _part2'!F12","v":0},{"$f":"'Dépenses prev. _part2'!G12","v":0},{"$f":"'Dépenses prev. _part2'!H12","v":{"$error":"#DIV/0!"}},{"$f":"'Dépenses prev. _part2'!I12","v":0},{"$f":"$C$228","v":0},0,{"$f":"K65/$K$117","v":{"$error":"#DIV/0!"}}]
[{"$f":"'Dépenses prev. _part4'!B2","v":"Partenaire 4 (le nommer)"},{"$f":"SUM(B67:B80)","v":0},{"$f":"D66/B66","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D67:D80)","v":0},null,{"$f":"'Dépenses prev. _part2'!F13","v":0},{"$f":"'Dépenses prev. _part2'!G13","v":0},{"$f":"'Dépenses prev. _part2'!H13","v":{"$error":"#DIV/0!"}},{"$f":"'Dépenses prev. _part2'!I13","v":0},{"$f":"$C$228","v":0},0,{"$error":"#DIV/0!"}]
[{"$f":"'Dépenses prev. _part4'!A5","v":"1)"},{"$f":"'Dépenses prev. _part4'!B5","v":0},{"$f":"'Dépenses prev. _part4'!C5","v":0},{"$f":"'Dépenses prev. _part4'!D5","v":"-"},null,{"$f":"'Dépenses prev. _part2'!F14","v":0},{"$f":"'Dépenses prev. _part2'!G14","v":0},{"$f":"'Dépenses prev. _part2'!H14","v":{"$error":"#DIV/0!"}},{"$f":"'Dépenses prev. _part2'!I14","v":0},0,0,{"$error":"#DIV/0!"}]
[{"$f":"'Dépenses prev. _part4'!A6","v":"2)"},{"$f":"'Dépenses prev. _part4'!B6","v":0},{"$f":"'Dépenses prev. _part4'!C6","v":0},{"$f":"'Dépenses prev. _part4'!D6","v":"-"},null,{"$f":"'Dépenses prev. _part2'!F15","v":0},{"$f":"'Dépenses prev. _part2'!G15","v":0},{"$f":"'Dépenses prev. _part2'!H15","v":{"$error":"#DIV/0!"}},{"$f":"'Dépenses prev. _part2'!I15","v":0},0,0,{"$error":"#DIV/0!"}]
[{"$f":"'Dépenses prev. _part4'!A7","v":"3)"},{"$f":"'Dépenses prev. _part4'!B7","v":0},{"$f":"'Dépenses prev. _part4'!C7","v":0},{"$f":"'Dépenses prev. _part4'!D7","v":"-"},null,{"$f":"'Dépenses prev. _part2'!F16","v":0},{"$f":"'Dépenses prev. _part2'!G16","v":0},{"$f":"'Dépenses prev. _part2'!H16","v":{"$error":"#DIV/0!"}},{"$f":"'Dépenses prev. _part2'!I16","v":0},0,0,{"$error":"#DIV/0!"}]
[{"$f":"'Dépenses prev. _part4'!A8","v":"4)"},{"$f":"'Dépenses prev. _part4'!B8","v":0},{"$f":"'Dépenses prev. _part4'!C8","v":0},{"$f":"'Dépenses prev. _part4'!D8","v":"-"},null,{"$f":"'Dépenses prev. _part2'!F17","v":0},{"$f":"'Dépenses prev. _part2'!G17","v":0},{"$f":"'Dépenses prev. _part2'!H17","v":{"$error":"#DIV/0!"}},{"$f":"'Dépenses prev. _part2'!I17","v":0},0,0,{"$error":"#DIV/0!"}]
[{"$f":"'Dépenses prev. _part4'!A9","v":"5)"},{"$f":"'Dépenses prev. _part4'!B9","v":0},{"$f":"'Dépenses prev. _part4'!C9","v":0},{"$f":"'Dépenses prev. _part4'!D9","v":"-"},null,{"$f":"'Dépenses prev. _part3'!B2","v":"Partenaire 3 (le nommer)"},{"$f":"SUM(G72:G77)","v":0},{"$f":"SUM(H72:H77)","v":{"$error":"#DIV/0!"}},0,0,0,{"$error":"#DIV/0!"}]
[{"$f":"'Dépenses prev. _part4'!A10","v":"6)"},{"$f":"'Dépenses prev. _part4'!B10","v":0},{"$f":"'Dépenses prev. _part4'!C10","v":0},{"$f":"'Dépenses prev. _part4'!D10","v":"-"},null,{"$f":"'Dépenses prev. _part3'!F12","v":0},{"$f":"'Dépenses prev. _part3'!G12","v":0},{"$f":"'Dépenses prev. _part3'!H12","v":{"$error":"#DIV/0!"}},{"$f":"'Dépenses prev. _part3'!I12","v":0},{"$f":"$C$228","v":0},0,{"$f":"K72/$K$117","v":{"$error":"#DIV/0!"}}]
[{"$f":"'Dépenses prev. _part4'!A11","v":"7)"},{"$f":"'Dépenses prev. _part4'!B11","v":0},{"$f":"'Dépenses prev. _part4'!C11","v":0},{"$f":"'Dépenses prev. _part4'!D11","v":"-"},null,{"$f":"'Dépenses prev. _part3'!F13","v":0},{"$f":"'Dépenses prev. _part3'!G13","v":0},{"$f":"'Dépenses prev. _part3'!H13","v":{"$error":"#DIV/0!"}},{"$f":"'Dépenses prev. _part3'!I13","v":0},{"$f":"$C$228","v":0},{"$f":"(1-J73)*I73","v":0},{"$error":"#DIV/0!"}]
[{"$f":"'Dépenses prev. _part4'!A12","v":"8)"},{"$f":"'Dépenses prev. _part4'!B12","v":0},{"$f":"'Dépenses prev. _part4'!C12","v":0},{"$f":"'Dépenses prev. _part4'!D12","v":"-"},null,{"$f":"'Dépenses prev. _part3'!F14","v":0},{"$f":"'Dépenses prev. _part3'!G14","v":0},{"$f":"'Dépenses prev. _part3'!H14","v":{"$error":"#DIV/0!"}},{"$f":"'Dépenses prev. _part3'!I14","v":0},0,0,{"$error":"#DIV/0!"}]
[{"$f":"'Dépenses prev. _part4'!A13","v":"9)"},{"$f":"'Dépenses prev. _part4'!B13","v":0},{"$f":"'Dépenses prev. _part4'!C13","v":0},{"$f":"'Dépenses prev. _part4'!D13","v":"-"},null,{"$f":"'Dépenses prev. _part3'!F15","v":0},{"$f":"'Dépenses prev. _part3'!G15","v":0},{"$f":"'Dépenses prev. _part3'!H15","v":{"$error":"#DIV/0!"}},{"$f":"'Dépenses prev. _part3'!I15","v":0},0,0,{"$error":"#DIV/0!"}]
[{"$f":"'Dépenses prev. _part4'!A14","v":"10)"},{"$f":"'Dépenses prev. _part4'!B14","v":0},{"$f":"'Dépenses prev. _part4'!C14","v":0},{"$f":"'Dépenses prev. _part4'!D14","v":"-"},null,{"$f":"'Dépenses prev. _part3'!F16","v":0},{"$f":"'Dépenses prev. _part3'!G16","v":0},{"$f":"'Dépenses prev. _part3'!H16","v":{"$error":"#DIV/0!"}},{"$f":"'Dépenses prev. _part3'!I16","v":0},0,0,{"$error":"#DIV/0!"}]
[{"$f":"'Dépenses prev. _part4'!A15","v":"11)"},{"$f":"'Dépenses prev. _part4'!B15","v":0},{"$f":"'Dépenses prev. _part4'!C15","v":0},{"$f":"'Dépenses prev. _part4'!D15","v":"-"},null,{"$f":"'Dépenses prev. _part3'!F17","v":0},{"$f":"'Dépenses prev. _part3'!G17","v":0},{"$f":"'Dépenses prev. _part3'!H17","v":{"$error":"#DIV/0!"}},{"$f":"'Dépenses prev. _part3'!I17","v":0},0,0,{"$error":"#DIV/0!"}]
[{"$f":"'Dépenses prev. _part4'!A16","v":"12)"},{"$f":"'Dépenses prev. _part4'!B16","v":0},{"$f":"'Dépenses prev. _part4'!C16","v":0},{"$f":"'Dépenses prev. _part4'!D16","v":"-"},null,{"$f":"'Dépenses prev. _part4'!B2","v":"Partenaire 4 (le nommer)"},{"$f":"SUM(G79:G84)","v":0},{"$f":"SUM(H79:H84)","v":{"$error":"#DIV/0!"}},0,0,0,{"$error":"#DIV/0!"}]
[{"$f":"'Dépenses prev. _part4'!A17","v":"13)"},{"$f":"'Dépenses prev. _part4'!B17","v":0},{"$f":"'Dépenses prev. _part4'!C17","v":0},{"$f":"'Dépenses prev. _part4'!D17","v":"-"},null,{"$f":"'Dépenses prev. _part4'!F12","v":0},{"$f":"'Dépenses prev. _part4'!G12","v":0},{"$f":"'Dépenses prev. _part4'!H12","v":{"$error":"#DIV/0!"}},{"$f":"'Dépenses prev. _part4'!I12","v":0},{"$f":"$C$228","v":0},0,{"$f":"K79/$K$117","v":{"$error":"#DIV/0!"}}]
[{"$f":"'Dépenses prev. _part4'!A18","v":"14)"},{"$f":"'Dépenses prev. _part4'!B18","v":0},{"$f":"'Dépenses prev. _part4'!C18","v":0},{"$f":"'Dépenses prev. _part4'!D18","v":"-"},null,{"$f":"'Dépenses prev. _part4'!F13","v":0},{"$f":"'Dépenses prev. _part4'!G13","v":0},{"$f":"'Dépenses prev. _part4'!H13","v":{"$error":"#DIV/0!"}},{"$f":"'Dépenses prev. _part4'!I13","v":0},{"$f":"$C$228","v":0},0,{"$error":"#DIV/0!"}]
[{"$f":"'Dépenses prev. _part5'!B2","v":"Partenaire 5 (le nommer)"},{"$f":"SUM(B82:B95)","v":0},{"$f":"D81/B81","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D82:D95)","v":0},null,{"$f":"'Dépenses prev. _part4'!F14","v":0},{"$f":"'Dépenses prev. _part4'!G14","v":0},{"$f":"'Dépenses prev. _part4'!H14","v":{"$error":"#DIV/0!"}},{"$f":"'Dépenses prev. _part4'!I14","v":0},0,0,{"$error":"#DIV/0!"}]
[{"$f":"'Dépenses prev. _part5'!A5","v":"1)"},{"$f":"'Dépenses prev. _part5'!B5","v":0},{"$f":"'Dépenses prev. _part5'!C5","v":0},{"$f":"'Dépenses prev. _part5'!D5","v":"-"},null,{"$f":"'Dépenses prev. _part4'!F15","v":0},{"$f":"'Dépenses prev. _part4'!G15","v":0},{"$f":"'Dépenses prev. _part4'!H15","v":{"$error":"#DIV/0!"}},{"$f":"'Dépenses prev. _part4'!I15","v":0},0,0,{"$error":"#DIV/0!"}]
[{"$f":"'Dépenses prev. _part5'!A6","v":"2)"},{"$f":"'Dépenses prev. _part5'!B6","v":0},{"$f":"'Dépenses prev. _part5'!C6","v":0},{"$f":"'Dépenses prev. _part5'!D6","v":"-"},null,{"$f":"'Dépenses prev. _part4'!F16","v":0},{"$f":"'Dépenses prev. _part4'!G16","v":0},{"$f":"'Dépenses prev. _part4'!H16","v":{"$error":"#DIV/0!"}},{"$f":"'Dépenses prev. _part4'!I16","v":0},0,0,{"$error":"#DIV/0!"}]
[{"$f":"'Dépenses prev. _part5'!A7","v":"3)"},{"$f":"'Dépenses prev. _part5'!B7","v":0},{"$f":"'Dépenses prev. _part5'!C7","v":0},{"$f":"'Dépenses prev. _part5'!D7","v":"-"},null,{"$f":"'Dépenses prev. _part4'!F17","v":0},{"$f":"'Dépenses prev. _part4'!G17","v":0},{"$f":"'Dépenses prev. _part4'!H17","v":{"$error":"#DIV/0!"}},{"$f":"'Dépenses prev. _part4'!I17","v":0},0,0,{"$error":"#DIV/0!"}]
[{"$f":"'Dépenses prev. _part5'!A8","v":"4)"},{"$f":"'Dépenses prev. _part5'!B8","v":0},{"$f":"'Dépenses prev. _part5'!C8","v":0},{"$f":"'Dépenses prev. _part5'!D8","v":"-"},null,{"$f":"'Dépenses prev. _part5'!B2","v":"Partenaire 5 (le nommer)"},{"$f":"SUM(G86:G91)","v":0},{"$f":"SUM(H86:H91)","v":{"$error":"#DIV/0!"}},0,0,0,{"$error":"#DIV/0!"}]
[{"$f":"'Dépenses prev. _part5'!A9","v":"5)"},{"$f":"'Dépenses prev. _part5'!B9","v":0},{"$f":"'Dépenses prev. _part5'!C9","v":0},{"$f":"'Dépenses prev. _part5'!D9","v":"-"},null,{"$f":"'Dépenses prev. _part5'!F12","v":0},{"$f":"'Dépenses prev. _part5'!G12","v":0},{"$f":"'Dépenses prev. _part5'!H12","v":{"$error":"#DIV/0!"}},{"$f":"'Dépenses prev. _part5'!I12","v":0},{"$f":"$C$228","v":0},0,{"$f":"K86/$K$117","v":{"$error":"#DIV/0!"}}]
[{"$f":"'Dépenses prev. _part5'!A10","v":"6)"},{"$f":"'Dépenses prev. _part5'!B10","v":0},{"$f":"'Dépenses prev. _part5'!C10","v":0},{"$f":"'Dépenses prev. _part5'!D10","v":"-"},null,{"$f":"'Dépenses prev. _part5'!F13","v":0},{"$f":"'Dépenses prev. _part5'!G13","v":0},{"$f":"'Dépenses prev. _part5'!H13","v":{"$error":"#DIV/0!"}},{"$f":"'Dépenses prev. _part5'!I13","v":0},{"$f":"$C$228","v":0},0,{"$error":"#DIV/0!"}]
[{"$f":"'Dépenses prev. _part5'!A11","v":"7)"},{"$f":"'Dépenses prev. _part5'!B11","v":0},{"$f":"'Dépenses prev. _part5'!C11","v":0},{"$f":"'Dépenses prev. _part5'!D11","v":"-"},null,{"$f":"'Dépenses prev. _part5'!F14","v":0},{"$f":"'Dépenses prev. _part5'!G14","v":0},{"$f":"'Dépenses prev. _part5'!H14","v":{"$error":"#DIV/0!"}},{"$f":"'Dépenses prev. _part5'!I14","v":0},0,0,{"$error":"#DIV/0!"}]
[{"$f":"'Dépenses prev. _part5'!A12","v":"8)"},{"$f":"'Dépenses prev. _part5'!B12","v":0},{"$f":"'Dépenses prev. _part5'!C12","v":0},{"$f":"'Dépenses prev. _part5'!D12","v":"-"},null,{"$f":"'Dépenses prev. _part5'!F15","v":0},{"$f":"'Dépenses prev. _part5'!G15","v":0},{"$f":"'Dépenses prev. _part5'!H15","v":{"$error":"#DIV/0!"}},{"$f":"'Dépenses prev. _part5'!I15","v":0},0,0,{"$error":"#DIV/0!"}]
[{"$f":"'Dépenses prev. _part5'!A13","v":"9)"},{"$f":"'Dépenses prev. _part5'!B13","v":0},{"$f":"'Dépenses prev. _part5'!C13","v":0},{"$f":"'Dépenses prev. _part5'!D13","v":"-"},null,{"$f":"'Dépenses prev. _part5'!F16","v":0},{"$f":"'Dépenses prev. _part5'!G16","v":0},{"$f":"'Dépenses prev. _part5'!H16","v":{"$error":"#DIV/0!"}},{"$f":"'Dépenses prev. _part5'!I16","v":0},0,0,{"$error":"#DIV/0!"}]
[{"$f":"'Dépenses prev. _part5'!A14","v":"10)"},{"$f":"'Dépenses prev. _part5'!B14","v":0},{"$f":"'Dépenses prev. _part5'!C14","v":0},{"$f":"'Dépenses prev. _part5'!D14","v":"-"},null,{"$f":"'Dépenses prev. _part5'!F17","v":0},{"$f":"'Dépenses prev. _part5'!G17","v":0},{"$f":"'Dépenses prev. _part5'!H17","v":{"$error":"#DIV/0!"}},{"$f":"'Dépenses prev. _part5'!I17","v":0},0,0,{"$error":"#DIV/0!"}]
[{"$f":"'Dépenses prev. _part5'!A15","v":"11)"},{"$f":"'Dépenses prev. _part5'!B15","v":0},{"$f":"'Dépenses prev. _part5'!C15","v":0},{"$f":"'Dépenses prev. _part5'!D15","v":"-"},null,"d) Autofinancement (dont les recettes générées par le projet)",{"$f":"SUM(G93:G116)","v":0},{"$f":"I92/G92","v":{"$error":"#DIV/0!"}},{"$f":"SUM(I93:I116)","v":0},{"$f":"I92*$B$229","v":0},{"$f":"SUM(K93:K116)","v":0},{"$error":"#DIV/0!"}]
[{"$f":"'Dépenses prev. _part5'!A16","v":"12)"},{"$f":"'Dépenses prev. _part5'!B16","v":0},{"$f":"'Dépenses prev. _part5'!C16","v":0},{"$f":"'Dépenses prev. _part5'!D16","v":"-"},null,{"$f":"'Dépenses prév._chef de file'!B2","v":"Chef de file (le nommer)"},{"$f":"SUM(G94:G96)","v":0},{"$f":"SUM(H94:H96)","v":{"$error":"#DIV/0!"}},0,0,0,{"$error":"#DIV/0!"}]
[{"$f":"'Dépenses prev. _part5'!A17","v":"13)"},{"$f":"'Dépenses prev. _part5'!B17","v":0},{"$f":"'Dépenses prev. _part5'!C17","v":0},{"$f":"'Dépenses prev. _part5'!D17","v":"-"},null,{"$f":"'Dépenses prév._chef de file'!F19","v":0},{"$f":"'Dépenses prév._chef de file'!G19","v":0},{"$f":"'Dépenses prév._chef de file'!H19","v":{"$error":"#DIV/0!"}},{"$f":"'Dépenses prév._chef de file'!I19","v":0},{"$f":"$C$228","v":0},{"$f":"(1-J94)*I94","v":0},{"$f":"K94/$K$117","v":{"$error":"#DIV/0!"}}]
[{"$f":"'Dépenses prev. _part5'!A18","v":"14)"},{"$f":"'Dépenses prev. _part5'!B18","v":0},{"$f":"'Dépenses prev. _part5'!C18","v":0},{"$f":"'Dépenses prev. _part5'!D18","v":"-"},null,{"$f":"'Dépenses prév._chef de file'!F20","v":0},{"$f":"'Dépenses prév._chef de file'!G20","v":0},{"$f":"'Dépenses prév._chef de file'!H20","v":{"$error":"#DIV/0!"}},{"$f":"'Dépenses prév._chef de file'!I20","v":0},{"$f":"$C$228","v":0},{"$f":"(1-J95)*I95","v":0},{"$f":"K95/$K$117","v":{"$error":"#DIV/0!"}}]
["b) Frais de voyage et de séjour",{"$f":"B97+B101+B105+B109+B113+B117","v":0},{"$f":"D96/B96","v":{"$error":"#DIV/0!"}},{"$f":"D97+D101+D105+D109+D113+D117","v":0},null,{"$f":"'Dépenses prév._chef de file'!F21","v":0},{"$f":"'Dépenses prév._chef de file'!G21","v":0},{"$f":"'Dépenses prév._chef de file'!H21","v":{"$error":"#DIV/0!"}},{"$f":"'Dépenses prév._chef de file'!I21","v":0},{"$f":"$C$228","v":0},{"$f":"(1-J96)*I96","v":0},{"$f":"K96/$K$117","v":{"$error":"#DIV/0!"}}]
[{"$f":"'Dépenses prév._chef de file'!B2","v":"Chef de file (le nommer)"},{"$f":"SUM(B98:B100)","v":0},{"$f":"D97/B97","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D98:D100)","v":0},null,{"$f":"'Dépenses prev. _part1'!B2","v":"Partenaire 1 (le nommer)"},{"$f":"SUM(G98:G100)","v":0},{"$f":"SUM(H98:H100)","v":{"$error":"#DIV/0!"}},0,0,0,{"$error":"#DIV/0!"}]
[{"$f":"'Dépenses prév._chef de file'!A20","v":0},{"$f":"'Dépenses prév._chef de file'!B20","v":0},{"$f":"'Dépenses prév._chef de file'!C20","v":1},{"$f":"'Dépenses prév._chef de file'!D20","v":0},null,{"$f":"'Dépenses prev. _part1'!F19","v":0},{"$f":"'Dépenses prev. _part1'!G19","v":0},{"$f":"'Dépenses prev. _part1'!H19","v":{"$error":"#DIV/0!"}},{"$f":"'Dépenses prev. _part1'!I19","v":0},{"$f":"$C$228","v":0},0,{"$f":"K98/$K$117","v":{"$error":"#DIV/0!"}}]
[{"$f":"'Dépenses prév._chef de file'!A21","v":0},{"$f":"'Dépenses prév._chef de file'!B21","v":0},{"$f":"'Dépenses prév._chef de file'!C21","v":1},{"$f":"'Dépenses prév._chef de file'!D21","v":0},null,{"$f":"'Dépenses prev. _part1'!F20","v":0},{"$f":"'Dépenses prev. _part1'!G20","v":0},{"$f":"'Dépenses prev. _part1'!H20","v":{"$error":"#DIV/0!"}},{"$f":"'Dépenses prev. _part1'!I20","v":0},{"$f":"$C$228","v":0},0,{"$f":"K99/$K$117","v":{"$error":"#DIV/0!"}}]
[{"$f":"'Dépenses prév._chef de file'!A22","v":0},{"$f":"'Dépenses prév._chef de file'!B22","v":0},{"$f":"'Dépenses prév._chef de file'!C22","v":1},{"$f":"'Dépenses prév._chef de file'!D22","v":0},null,{"$f":"'Dépenses prev. _part1'!F21","v":0},{"$f":"'Dépenses prev. _part1'!G21","v":0},{"$f":"'Dépenses prev. _part1'!H21","v":{"$error":"#DIV/0!"}},{"$f":"'Dépenses prev. _part1'!I21","v":0},0,0,{"$f":"K100/$K$117","v":{"$error":"#DIV/0!"}}]
[{"$f":"'Dépenses prev. _part1'!B2","v":"Partenaire 1 (le nommer)"},{"$f":"SUM(B102:B104)","v":0},{"$f":"D101/B101","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D102:D104)","v":0},null,{"$f":"'Dépenses prev. _part2'!B2","v":"Partenaire 2 (le nommer)"},{"$f":"SUM(G102:G104)","v":0},{"$f":"SUM(H102:H104)","v":{"$error":"#DIV/0!"}},0,0,0,{"$error":"#DIV/0!"}]
[{"$f":"'Dépenses prev. _part1'!A20","v":0},{"$f":"'Dépenses prev. _part1'!B20","v":0},{"$f":"'Dépenses prev. _part1'!C20","v":1},{"$f":"'Dépenses prev. _part1'!D20","v":0},null,{"$f":"'Dépenses prev. _part2'!F19","v":0},{"$f":"'Dépenses prev. _part2'!G19","v":0},{"$f":"'Dépenses prev. _part2'!H19","v":{"$error":"#DIV/0!"}},{"$f":"'Dépenses prev. _part2'!I19","v":0},{"$f":"$C$228","v":0},0,{"$f":"K102/$K$117","v":{"$error":"#DIV/0!"}}]
[{"$f":"'Dépenses prev. _part1'!A21","v":0},{"$f":"'Dépenses prev. _part1'!B21","v":0},{"$f":"'Dépenses prev. _part1'!C21","v":1},{"$f":"'Dépenses prev. _part1'!D21","v":0},null,{"$f":"'Dépenses prev. _part2'!F20","v":0},{"$f":"'Dépenses prev. _part2'!G20","v":0},{"$f":"'Dépenses prev. _part2'!H20","v":{"$error":"#DIV/0!"}},{"$f":"'Dépenses prev. _part2'!I20","v":0},{"$f":"$C$228","v":0},0,{"$f":"K103/$K$117","v":{"$error":"#DIV/0!"}}]
[{"$f":"'Dépenses prev. _part1'!A22","v":0},{"$f":"'Dépenses prev. _part1'!B22","v":0},{"$f":"'Dépenses prev. _part1'!C22","v":1},{"$f":"'Dépenses prev. _part1'!D22","v":0},null,{"$f":"'Dépenses prev. _part2'!F21","v":0},{"$f":"'Dépenses prev. _part2'!G21","v":0},{"$f":"'Dépenses prev. _part2'!H21","v":{"$error":"#DIV/0!"}},{"$f":"'Dépenses prev. _part2'!I21","v":0},0,0,{"$f":"K104/$K$117","v":{"$error":"#DIV/0!"}}]
[{"$f":"'Dépenses prev. _part2'!B2","v":"Partenaire 2 (le nommer)"},{"$f":"SUM(B106:B108)","v":0},{"$f":"D105/B105","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D106:D108)","v":0},null,{"$f":"'Dépenses prev. _part3'!B2","v":"Partenaire 3 (le nommer)"},{"$f":"SUM(G106:G108)","v":0},{"$f":"SUM(H106:H108)","v":0},0,0,0,{"$error":"#DIV/0!"}]
[{"$f":"'Dépenses prev. _part2'!A20","v":0},{"$f":"'Dépenses prev. _part2'!B20","v":0},{"$f":"'Dépenses prev. _part2'!C20","v":1},{"$f":"'Dépenses prev. _part2'!D20","v":0},null,{"$f":"'Dépenses prev. _part3'!F19","v":0},{"$f":"'Dépenses prev. _part3'!F19","v":0},{"$f":"'Dépenses prev. _part3'!F19","v":0},{"$f":"'Dépenses prev. _part3'!F19","v":0},{"$f":"$C$228","v":0},0,{"$f":"K106/$K$117","v":{"$error":"#DIV/0!"}}]
[{"$f":"'Dépenses prev. _part2'!A21","v":0},{"$f":"'Dépenses prev. _part2'!B21","v":0},{"$f":"'Dépenses prev. _part2'!C21","v":1},{"$f":"'Dépenses prev. _part2'!D21","v":0},null,{"$f":"'Dépenses prev. _part3'!F20","v":0},{"$f":"'Dépenses prev. _part3'!F20","v":0},{"$f":"'Dépenses prev. _part3'!F20","v":0},{"$f":"'Dépenses prev. _part3'!F20","v":0},{"$f":"$C$228","v":0},0,{"$f":"K107/$K$117","v":{"$error":"#DIV/0!"}}]
[{"$f":"'Dépenses prev. _part2'!A22","v":0},{"$f":"'Dépenses prev. _part2'!B22","v":0},{"$f":"'Dépenses prev. _part2'!C22","v":1},{"$f":"'Dépenses prev. _part2'!D22","v":0},null,{"$f":"'Dépenses prev. _part3'!F21","v":0},{"$f":"'Dépenses prev. _part3'!F21","v":0},{"$f":"'Dépenses prev. _part3'!F21","v":0},{"$f":"'Dépenses prev. _part3'!F21","v":0},0,0,{"$error":"#DIV/0!"}]
[{"$f":"'Dépenses prev. _part3'!B2","v":"Partenaire 3 (le nommer)"},{"$f":"SUM(B110:B112)","v":0},{"$f":"D109/B109","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D110:D112)","v":0},null,{"$f":"'Dépenses prev. _part4'!B2","v":"Partenaire 4 (le nommer)"},{"$f":"SUM(G110:G112)","v":0},{"$f":"SUM(H110:H112)","v":{"$error":"#DIV/0!"}},0,0,0,{"$error":"#DIV/0!"}]
[{"$f":"'Dépenses prev. _part3'!A20","v":0},{"$f":"'Dépenses prev. _part3'!B20","v":0},{"$f":"'Dépenses prev. _part3'!C20","v":1},{"$f":"'Dépenses prev. _part3'!D20","v":0},null,{"$f":"'Dépenses prev. _part4'!F19","v":0},{"$f":"'Dépenses prev. _part4'!G19","v":0},{"$f":"'Dépenses prev. _part4'!H19","v":{"$error":"#DIV/0!"}},{"$f":"'Dépenses prev. _part4'!I19","v":0},{"$f":"$C$228","v":0},0,{"$f":"K110/$K$117","v":{"$error":"#DIV/0!"}}]
[{"$f":"'Dépenses prev. _part3'!A21","v":0},{"$f":"'Dépenses prev. _part3'!B21","v":0},{"$f":"'Dépenses prev. _part3'!C21","v":1},{"$f":"'Dépenses prev. _part3'!D21","v":0},null,{"$f":"'Dépenses prev. _part4'!F20","v":0},{"$f":"'Dépenses prev. _part4'!G20","v":0},{"$f":"'Dépenses prev. _part4'!H20","v":{"$error":"#DIV/0!"}},{"$f":"'Dépenses prev. _part4'!I20","v":0},{"$f":"$C$228","v":0},0,{"$f":"K111/$K$117","v":{"$error":"#DIV/0!"}}]
[{"$f":"'Dépenses prev. _part3'!A22","v":0},{"$f":"'Dépenses prev. _part3'!B22","v":0},{"$f":"'Dépenses prev. _part3'!C22","v":1},{"$f":"'Dépenses prev. _part3'!D22","v":0},null,{"$f":"'Dépenses prev. _part4'!F21","v":0},{"$f":"'Dépenses prev. _part4'!G21","v":0},{"$f":"'Dépenses prev. _part4'!H21","v":{"$error":"#DIV/0!"}},{"$f":"'Dépenses prev. _part4'!I21","v":0},0,{"$f":"(1-J112)*I112","v":0},{"$f":"K112/$K$117","v":{"$error":"#DIV/0!"}}]
[{"$f":"'Dépenses prev. _part4'!B2","v":"Partenaire 4 (le nommer)"},{"$f":"SUM(B114:B116)","v":0},{"$f":"D113/B113","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D114:D116)","v":0},null,{"$f":"'Dépenses prev. _part5'!B2","v":"Partenaire 5 (le nommer)"},{"$f":"SUM(G114:G116)","v":0},{"$f":"SUM(H114:H116)","v":{"$error":"#DIV/0!"}},0,0,0,{"$error":"#DIV/0!"}]
[{"$f":"'Dépenses prev. _part4'!A20","v":0},{"$f":"'Dépenses prev. _part4'!B20","v":0},{"$f":"'Dépenses prev. _part4'!C20","v":1},{"$f":"'Dépenses prev. _part4'!D20","v":0},null,{"$f":"'Dépenses prev. _part5'!F19","v":0},{"$f":"'Dépenses prev. _part5'!G19","v":0},{"$f":"'Dépenses prev. _part5'!H19","v":{"$error":"#DIV/0!"}},{"$f":"'Dépenses prev. _part5'!I19","v":0},{"$f":"$C$228","v":0},{"$f":"(1-J114)*I114","v":0},{"$f":"K114/$K$117","v":{"$error":"#DIV/0!"}}]
[{"$f":"'Dépenses prev. _part4'!A21","v":0},{"$f":"'Dépenses prev. _part4'!B21","v":0},{"$f":"'Dépenses prev. _part4'!C21","v":1},{"$f":"'Dépenses prev. _part4'!D21","v":0},null,{"$f":"'Dépenses prev. _part5'!F20","v":0},{"$f":"'Dépenses prev. _part5'!G20","v":0},{"$f":"'Dépenses prev. _part5'!H20","v":{"$error":"#DIV/0!"}},{"$f":"'Dépenses prev. _part5'!I20","v":0},{"$f":"$C$228","v":0},0,{"$error":"#DIV/0!"}]
[{"$f":"'Dépenses prev. _part4'!A22","v":0},{"$f":"'Dépenses prev. _part4'!B22","v":0},{"$f":"'Dépenses prev. _part4'!C22","v":1},{"$f":"'Dépenses prev. _part4'!D22","v":0},null,{"$f":"'Dépenses prev. _part5'!F21","v":0},{"$f":"'Dépenses prev. _part5'!G21","v":0},{"$f":"'Dépenses prev. _part5'!H21","v":{"$error":"#DIV/0!"}},{"$f":"'Dépenses prev. _part5'!I21","v":0},0,0,{"$f":"K116/$K$117","v":{"$error":"#DIV/0!"}}]
[{"$f":"'Dépenses prev. _part5'!B2","v":"Partenaire 5 (le nommer)"},null,{"$f":"D117/B117","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D118:D120)","v":0},null,"TOTAL DES RESSOURCES ELIGIBLES ",{"$f":"G92+G49+G6+G5","v":0},null,{"$f":"I92+I49+I6+I5","v":0},null,{"$f":"K92+K49+K6+K5","v":0}]
[{"$f":"'Dépenses prev. _part5'!A20","v":0},{"$f":"'Dépenses prev. _part5'!B20","v":0},{"$f":"'Dépenses prev. _part5'!C20","v":1},{"$f":"'Dépenses prev. _part5'!D20","v":0}]
[{"$f":"'Dépenses prev. _part5'!A21","v":0},{"$f":"'Dépenses prev. _part5'!B21","v":0},{"$f":"'Dépenses prev. _part5'!C21","v":1},{"$f":"'Dépenses prev. _part5'!D21","v":0}]
[{"$f":"'Dépenses prev. _part5'!A22","v":0},{"$f":"'Dépenses prev. _part5'!B22","v":0},{"$f":"'Dépenses prev. _part5'!C22","v":1},{"$f":"'Dépenses prev. _part5'!D22","v":0}]
["c) Frais d'équipement",{"$f":"B122+B126+B130+B134+B138+B142","v":0},{"$f":"D121/B121","v":{"$error":"#DIV/0!"}},{"$f":"D122+D126+D130+D134+D138+D142","v":0}]
[{"$f":"'Dépenses prév._chef de file'!B2","v":"Chef de file (le nommer)"},{"$f":"SUM(B123:B125)","v":0},{"$f":"D122/B122","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D123:D125)","v":0}]
[{"$f":"'Dépenses prév._chef de file'!A24","v":0},{"$f":"'Dépenses prév._chef de file'!B24","v":0},{"$f":"'Dépenses prév._chef de file'!C24","v":1},{"$f":"'Dépenses prév._chef de file'!D24","v":0}]
[{"$f":"'Dépenses prév._chef de file'!A25","v":0},{"$f":"'Dépenses prév._chef de file'!B25","v":0},{"$f":"'Dépenses prév._chef de file'!C25","v":1},{"$f":"'Dépenses prév._chef de file'!D25","v":0}]
[{"$f":"'Dépenses prév._chef de file'!A26","v":0},{"$f":"'Dépenses prév._chef de file'!B26","v":0},{"$f":"'Dépenses prév._chef de file'!C26","v":1},{"$f":"'Dépenses prév._chef de file'!D26","v":0}]
[{"$f":"'Dépenses prev. _part1'!B2","v":"Partenaire 1 (le nommer)"},{"$f":"SUM(B127:B129)","v":0},{"$f":"D126/B126","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D127:D129)","v":0}]
[{"$f":"'Dépenses prev. _part1'!A24","v":0},{"$f":"'Dépenses prev. _part1'!B24","v":0},{"$f":"'Dépenses prev. _part1'!C24","v":1},{"$f":"'Dépenses prev. _part1'!D24","v":0}]
[{"$f":"'Dépenses prev. _part1'!A25","v":0},{"$f":"'Dépenses prev. _part1'!B25","v":0},{"$f":"'Dépenses prev. _part1'!C25","v":1},{"$f":"'Dépenses prev. _part1'!D25","v":0}]
[{"$f":"'Dépenses prev. _part1'!A26","v":0},{"$f":"'Dépenses prev. _part1'!B26","v":0},{"$f":"'Dépenses prev. _part1'!C26","v":1},{"$f":"'Dépenses prev. _part1'!D26","v":0}]
[{"$f":"'Dépenses prev. _part2'!B2","v":"Partenaire 2 (le nommer)"},{"$f":"SUM(B131:B133)","v":0},{"$f":"D130/B130","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D131:D133)","v":0}]
[{"$f":"'Dépenses prev. _part2'!A24","v":0},{"$f":"'Dépenses prev. _part2'!B24","v":0},{"$f":"'Dépenses prev. _part2'!C24","v":1},{"$f":"'Dépenses prev. _part2'!D24","v":0}]
[{"$f":"'Dépenses prev. _part2'!A25","v":0},{"$f":"'Dépenses prev. _part2'!B25","v":0},{"$f":"'Dépenses prev. _part2'!C25","v":1},{"$f":"'Dépenses prev. _part2'!D25","v":0}]
[{"$f":"'Dépenses prev. _part2'!A26","v":0},{"$f":"'Dépenses prev. _part2'!B26","v":0},{"$f":"'Dépenses prev. _part2'!C26","v":1},{"$f":"'Dépenses prev. _part2'!D26","v":0}]
[{"$f":"'Dépenses prev. _part3'!B2","v":"Partenaire 3 (le nommer)"},{"$f":"SUM(B135:B137)","v":0},{"$f":"D134/B134","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D135:D137)","v":0}]
[{"$f":"'Dépenses prev. _part3'!A24","v":0},{"$f":"'Dépenses prev. _part3'!B24","v":0},{"$f":"'Dépenses prev. _part3'!C24","v":1},{"$f":"'Dépenses prev. _part3'!D24","v":0}]
[{"$f":"'Dépenses prev. _part3'!A25","v":0},{"$f":"'Dépenses prev. _part3'!B25","v":0},{"$f":"'Dépenses prev. _part3'!C25","v":1},{"$f":"'Dépenses prev. _part3'!D25","v":0}]
[{"$f":"'Dépenses prev. _part3'!A26","v":0},{"$f":"'Dépenses prev. _part3'!B26","v":0},{"$f":"'Dépenses prev. _part3'!C26","v":1},{"$f":"'Dépenses prev. _part3'!D26","v":0}]
[{"$f":"'Dépenses prev. _part4'!B2","v":"Partenaire 4 (le nommer)"},{"$f":"SUM(B139:B141)","v":0},{"$f":"D138/B138","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D139:D141)","v":0}]
[{"$f":"'Dépenses prev. _part4'!A24","v":0},{"$f":"'Dépenses prev. _part4'!B24","v":0},{"$f":"'Dépenses prev. _part4'!C24","v":1},{"$f":"'Dépenses prev. _part4'!D24","v":0}]
[{"$f":"'Dépenses prev. _part4'!A25","v":0},{"$f":"'Dépenses prev. _part4'!B25","v":0},{"$f":"'Dépenses prev. _part4'!C25","v":1},{"$f":"'Dépenses prev. _part4'!D25","v":0}]
[{"$f":"'Dépenses prev. _part4'!A26","v":0},{"$f":"'Dépenses prev. _part4'!B26","v":0},{"$f":"'Dépenses prev. _part4'!C26","v":1},{"$f":"'Dépenses prev. _part4'!D26","v":0}]
[{"$f":"'Dépenses prev. _part5'!B2","v":"Partenaire 5 (le nommer)"},{"$f":"SUM(B143:B145)","v":0},{"$f":"D142/B142","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D143:D145)","v":0}]
[{"$f":"'Dépenses prev. _part5'!A24","v":0},{"$f":"'Dépenses prev. _part5'!B24","v":0},{"$f":"'Dépenses prev. _part5'!C24","v":1},{"$f":"'Dépenses prev. _part5'!D24","v":0}]
[{"$f":"'Dépenses prev. _part5'!A25","v":0},{"$f":"'Dépenses prev. _part5'!B25","v":0},{"$f":"'Dépenses prev. _part5'!C25","v":1},{"$f":"'Dépenses prev. _part5'!D25","v":0}]
[{"$f":"'Dépenses prev. _part5'!A26","v":0},{"$f":"'Dépenses prev. _part5'!B26","v":0},{"$f":"'Dépenses prev. _part5'!C26","v":1},{"$f":"'Dépenses prev. _part5'!D26","v":0}]
["d) Biens immobiliers",{"$f":"B147+B151+B155+B159+B163+B167","v":0},{"$f":"D146/B146","v":{"$error":"#DIV/0!"}},{"$f":"D147+D151+D155+D159+D163+D167","v":0}]
[{"$f":"'Dépenses prév._chef de file'!B2","v":"Chef de file (le nommer)"},{"$f":"SUM(B148:B150)","v":0},{"$f":"D147/B147","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D148:D150)","v":0}]
[{"$f":"'Dépenses prév._chef de file'!A28","v":0},{"$f":"'Dépenses prév._chef de file'!B28","v":0},{"$f":"'Dépenses prév._chef de file'!C28","v":1},{"$f":"'Dépenses prév._chef de file'!D28","v":0}]
[{"$f":"'Dépenses prév._chef de file'!A29","v":0},{"$f":"'Dépenses prév._chef de file'!B29","v":0},{"$f":"'Dépenses prév._chef de file'!C29","v":1},{"$f":"'Dépenses prév._chef de file'!D29","v":0}]
[{"$f":"'Dépenses prév._chef de file'!A30","v":0},{"$f":"'Dépenses prév._chef de file'!B30","v":0},{"$f":"'Dépenses prév._chef de file'!C30","v":1},{"$f":"'Dépenses prév._chef de file'!D30","v":0}]
[{"$f":"'Dépenses prev. _part1'!B2","v":"Partenaire 1 (le nommer)"},{"$f":"SUM(B152:B154)","v":0},{"$f":"D151/B151","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D152:D154)","v":0}]
[{"$f":"'Dépenses prev. _part1'!A28","v":0},{"$f":"'Dépenses prev. _part1'!B28","v":0},{"$f":"'Dépenses prev. _part1'!C28","v":1},{"$f":"'Dépenses prev. _part1'!D28","v":0}]
[{"$f":"'Dépenses prev. _part1'!A29","v":0},{"$f":"'Dépenses prev. _part1'!B29","v":0},{"$f":"'Dépenses prev. _part1'!C29","v":1},{"$f":"'Dépenses prev. _part1'!D29","v":0}]
[{"$f":"'Dépenses prev. _part1'!A30","v":0},{"$f":"'Dépenses prev. _part1'!B30","v":0},{"$f":"'Dépenses prev. _part1'!C30","v":1},{"$f":"'Dépenses prev. _part1'!D30","v":0}]
[{"$f":"'Dépenses prev. _part2'!B2","v":"Partenaire 2 (le nommer)"},{"$f":"SUM(B156:B158)","v":0},{"$f":"D155/B155","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D156:D158)","v":0}]
[{"$f":"'Dépenses prev. _part2'!A28","v":0},{"$f":"'Dépenses prev. _part2'!B28","v":0},{"$f":"'Dépenses prev. _part2'!C28","v":1},{"$f":"'Dépenses prev. _part2'!D28","v":0}]
[{"$f":"'Dépenses prev. _part2'!A29","v":0},{"$f":"'Dépenses prev. _part2'!B29","v":0},{"$f":"'Dépenses prev. _part2'!C29","v":1},{"$f":"'Dépenses prev. _part2'!D29","v":0}]
[{"$f":"'Dépenses prev. _part2'!A30","v":0},{"$f":"'Dépenses prev. _part2'!B30","v":0},{"$f":"'Dépenses prev. _part2'!C30","v":1},{"$f":"'Dépenses prev. _part2'!D30","v":0}]
[{"$f":"'Dépenses prev. _part3'!B2","v":"Partenaire 3 (le nommer)"},{"$f":"SUM(B160:B162)","v":0},{"$f":"D159/B159","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D160:D162)","v":0}]
[{"$f":"'Dépenses prev. _part3'!A28","v":0},{"$f":"'Dépenses prev. _part3'!B28","v":0},{"$f":"'Dépenses prev. _part3'!C28","v":1},{"$f":"'Dépenses prev. _part3'!D28","v":0}]
[{"$f":"'Dépenses prev. _part3'!A29","v":0},{"$f":"'Dépenses prev. _part3'!B29","v":0},{"$f":"'Dépenses prev. _part3'!C29","v":1},{"$f":"'Dépenses prev. _part3'!D29","v":0}]
[{"$f":"'Dépenses prev. _part3'!A30","v":0},{"$f":"'Dépenses prev. _part3'!B30","v":0},{"$f":"'Dépenses prev. _part3'!C30","v":1},{"$f":"'Dépenses prev. _part3'!D30","v":0}]
[{"$f":"'Dépenses prev. _part4'!B2","v":"Partenaire 4 (le nommer)"},{"$f":"SUM(B164:B166)","v":0},{"$f":"D163/B163","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D164:D166)","v":0}]
[{"$f":"'Dépenses prev. _part4'!A28","v":0},{"$f":"'Dépenses prev. _part4'!B28","v":0},{"$f":"'Dépenses prev. _part4'!C28","v":1},{"$f":"'Dépenses prev. _part4'!D28","v":0}]
[{"$f":"'Dépenses prev. _part4'!A29","v":0},{"$f":"'Dépenses prev. _part4'!B29","v":0},{"$f":"'Dépenses prev. _part4'!C29","v":1},{"$f":"'Dépenses prev. _part4'!D29","v":0}]
[{"$f":"'Dépenses prev. _part4'!A30","v":0},{"$f":"'Dépenses prev. _part4'!B30","v":0},{"$f":"'Dépenses prev. _part4'!C30","v":1},{"$f":"'Dépenses prev. _part4'!D30","v":0}]
[{"$f":"'Dépenses prev. _part5'!B2","v":"Partenaire 5 (le nommer)"},{"$f":"SUM(B168:B170)","v":0},{"$f":"D167/B167","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D168:D170)","v":0}]
[{"$f":"'Dépenses prev. _part5'!A28","v":0},{"$f":"'Dépenses prev. _part5'!B28","v":0},{"$f":"'Dépenses prev. _part5'!C28","v":1},{"$f":"'Dépenses prev. _part5'!D28","v":0}]
[{"$f":"'Dépenses prev. _part5'!A29","v":0},{"$f":"'Dépenses prev. _part5'!B29","v":0},{"$f":"'Dépenses prev. _part5'!C29","v":1},{"$f":"'Dépenses prev. _part5'!D29","v":0}]
[{"$f":"'Dépenses prev. _part5'!A30","v":0},{"$f":"'Dépenses prev. _part5'!B30","v":0},{"$f":"'Dépenses prev. _part5'!C30","v":1},{"$f":"'Dépenses prev. _part5'!D30","v":0}]
["e) Frais de sous-traitance",{"$f":"B172+B176+B180+B184+B188+B192","v":0},{"$f":"D171/B171","v":{"$error":"#DIV/0!"}},{"$f":"D172+D176+D180+D184+D188+D192","v":0}]
[{"$f":"'Dépenses prév._chef de file'!B2","v":"Chef de file (le nommer)"},{"$f":"SUM(B173:B175)","v":0},{"$f":"D172/B172","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D173:D175)","v":0}]
[{"$f":"'Dépenses prév._chef de file'!A32","v":0},{"$f":"'Dépenses prév._chef de file'!B32","v":0},{"$f":"'Dépenses prév._chef de file'!C32","v":1},{"$f":"'Dépenses prév._chef de file'!D32","v":0}]
[{"$f":"'Dépenses prév._chef de file'!A33","v":0},{"$f":"'Dépenses prév._chef de file'!B33","v":0},{"$f":"'Dépenses prév._chef de file'!C33","v":1},{"$f":"'Dépenses prév._chef de file'!D33","v":0}]
[{"$f":"'Dépenses prév._chef de file'!A34","v":0},{"$f":"'Dépenses prév._chef de file'!B34","v":0},{"$f":"'Dépenses prév._chef de file'!C34","v":1},{"$f":"'Dépenses prév._chef de file'!D34","v":0}]
[{"$f":"'Dépenses prev. _part1'!B2","v":"Partenaire 1 (le nommer)"},{"$f":"SUM(B177:B179)","v":0},{"$f":"D176/B176","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D177:D179)","v":0}]
[{"$f":"'Dépenses prev. _part1'!A32","v":0},{"$f":"'Dépenses prev. _part1'!B32","v":0},{"$f":"'Dépenses prev. _part1'!C32","v":1},{"$f":"'Dépenses prev. _part1'!D32","v":0}]
[{"$f":"'Dépenses prev. _part1'!A33","v":0},{"$f":"'Dépenses prev. _part1'!B33","v":0},{"$f":"'Dépenses prev. _part1'!C33","v":1},{"$f":"'Dépenses prev. _part1'!D33","v":0}]
[{"$f":"'Dépenses prev. _part1'!A34","v":0},{"$f":"'Dépenses prev. _part1'!B34","v":0},{"$f":"'Dépenses prev. _part1'!C34","v":1},{"$f":"'Dépenses prev. _part1'!D34","v":0}]
[{"$f":"'Dépenses prev. _part2'!B2","v":"Partenaire 2 (le nommer)"},{"$f":"SUM(B181:B183)","v":0},{"$f":"D180/B180","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D181:D183)","v":0}]
[{"$f":"'Dépenses prev. _part2'!A32","v":0},{"$f":"'Dépenses prev. _part2'!B32","v":0},{"$f":"'Dépenses prev. _part2'!C32","v":1},{"$f":"'Dépenses prev. _part2'!D32","v":0}]
[{"$f":"'Dépenses prev. _part2'!A33","v":0},{"$f":"'Dépenses prev. _part2'!B33","v":0},{"$f":"'Dépenses prev. _part2'!C33","v":1},{"$f":"'Dépenses prev. _part2'!D33","v":0}]
[{"$f":"'Dépenses prev. _part2'!A34","v":0},{"$f":"'Dépenses prev. _part2'!B34","v":0},{"$f":"'Dépenses prev. _part2'!C34","v":1},{"$f":"'Dépenses prev. _part2'!D34","v":0}]
[{"$f":"'Dépenses prev. _part3'!B2","v":"Partenaire 3 (le nommer)"},{"$f":"SUM(B185:B187)","v":0},{"$f":"D184/B184","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D185:D187)","v":0}]
[{"$f":"'Dépenses prev. _part3'!A32","v":0},{"$f":"'Dépenses prev. _part3'!B32","v":0},{"$f":"'Dépenses prev. _part3'!C32","v":1},{"$f":"'Dépenses prev. _part3'!D32","v":0}]
[{"$f":"'Dépenses prev. _part3'!A33","v":0},{"$f":"'Dépenses prev. _part3'!B33","v":0},{"$f":"'Dépenses prev. _part3'!C33","v":1},{"$f":"'Dépenses prev. _part3'!D33","v":0}]
[{"$f":"'Dépenses prev. _part3'!A34","v":0},{"$f":"'Dépenses prev. _part3'!B34","v":0},{"$f":"'Dépenses prev. _part3'!C34","v":1},{"$f":"'Dépenses prev. _part3'!D34","v":0}]
[{"$f":"'Dépenses prev. _part4'!B2","v":"Partenaire 4 (le nommer)"},{"$f":"SUM(B189:B191)","v":0},{"$f":"D188/B188","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D189:D191)","v":0}]
[{"$f":"'Dépenses prev. _part4'!A32","v":0},{"$f":"'Dépenses prev. _part4'!B32","v":0},{"$f":"'Dépenses prev. _part4'!C32","v":1},{"$f":"'Dépenses prev. _part4'!D32","v":0}]
[{"$f":"'Dépenses prev. _part4'!A33","v":0},{"$f":"'Dépenses prev. _part4'!B33","v":0},{"$f":"'Dépenses prev. _part4'!C33","v":1},{"$f":"'Dépenses prev. _part4'!D33","v":0}]
[{"$f":"'Dépenses prev. _part4'!A34","v":0},{"$f":"'Dépenses prev. _part4'!B34","v":0},{"$f":"'Dépenses prev. _part4'!C34","v":1},{"$f":"'Dépenses prev. _part4'!D34","v":0}]
[{"$f":"'Dépenses prev. _part5'!B2","v":"Partenaire 5 (le nommer)"},null,{"$f":"D192/B192","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D193:D195)","v":0}]
[{"$f":"'Dépenses prev. _part5'!A32","v":0},{"$f":"'Dépenses prev. _part5'!B32","v":0},{"$f":"'Dépenses prev. _part5'!C32","v":1},{"$f":"'Dépenses prev. _part5'!D32","v":0}]
[{"$f":"'Dépenses prev. _part5'!A33","v":0},{"$f":"'Dépenses prev. _part5'!B33","v":0},{"$f":"'Dépenses prev. _part5'!C33","v":1},{"$f":"'Dépenses prev. _part5'!D33","v":0}]
[{"$f":"'Dépenses prev. _part5'!A34","v":0},{"$f":"'Dépenses prev. _part5'!B34","v":0},{"$f":"'Dépenses prev. _part5'!C34","v":1},{"$f":"'Dépenses prev. _part5'!D34","v":0}]
["f) Dépenses spécifiques en relation avec les groupes cibles",{"$f":"B197+B201+B205+B209+B213+B217","v":0},{"$f":"D196/B196","v":{"$error":"#DIV/0!"}},{"$f":"D197+D201+D205+D209+D213+D217","v":0}]
[{"$f":"'Dépenses prév._chef de file'!B2","v":"Chef de file (le nommer)"},{"$f":"SUM(B198:B200)","v":0},{"$f":"D197/B197","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D198:D200)","v":0}]
[{"$f":"'Dépenses prév._chef de file'!A36","v":0},{"$f":"'Dépenses prév._chef de file'!B36","v":0},{"$f":"'Dépenses prév._chef de file'!C36","v":1},{"$f":"'Dépenses prév._chef de file'!D36","v":0}]
[{"$f":"'Dépenses prév._chef de file'!A37","v":0},{"$f":"'Dépenses prév._chef de file'!B37","v":0},{"$f":"'Dépenses prév._chef de file'!C37","v":1},{"$f":"'Dépenses prév._chef de file'!D37","v":0}]
[{"$f":"'Dépenses prév._chef de file'!A38","v":0},{"$f":"'Dépenses prév._chef de file'!B38","v":0},{"$f":"'Dépenses prév._chef de file'!C38","v":1},{"$f":"'Dépenses prév._chef de file'!D38","v":0}]
[{"$f":"'Dépenses prev. _part1'!B2","v":"Partenaire 1 (le nommer)"},{"$f":"SUM(B202:B204)","v":0},{"$f":"D201/B201","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D202:D204)","v":0}]
[{"$f":"'Dépenses prev. _part1'!A36","v":0},{"$f":"'Dépenses prev. _part1'!B36","v":0},{"$f":"'Dépenses prev. _part1'!C36","v":1},{"$f":"'Dépenses prev. _part1'!D36","v":0}]
[{"$f":"'Dépenses prev. _part1'!A37","v":0},{"$f":"'Dépenses prev. _part1'!B37","v":0},{"$f":"'Dépenses prev. _part1'!C37","v":1},{"$f":"'Dépenses prev. _part1'!D37","v":0}]
[{"$f":"'Dépenses prev. _part1'!A38","v":0},{"$f":"'Dépenses prev. _part1'!B38","v":0},{"$f":"'Dépenses prev. _part1'!C38","v":1},{"$f":"'Dépenses prev. _part1'!D38","v":0}]
[{"$f":"'Dépenses prev. _part2'!B2","v":"Partenaire 2 (le nommer)"},{"$f":"SUM(B206:B208)","v":0},{"$f":"D205/B205","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D206:D208)","v":0}]
[{"$f":"'Dépenses prev. _part2'!A36","v":0},{"$f":"'Dépenses prev. _part2'!B36","v":0},{"$f":"'Dépenses prev. _part2'!C36","v":1},{"$f":"'Dépenses prev. _part2'!D36","v":0}]
[{"$f":"'Dépenses prev. _part2'!A37","v":0},{"$f":"'Dépenses prev. _part2'!B37","v":0},{"$f":"'Dépenses prev. _part2'!C37","v":1},{"$f":"'Dépenses prev. _part2'!D37","v":0}]
[{"$f":"'Dépenses prev. _part2'!A38","v":0},{"$f":"'Dépenses prev. _part2'!B38","v":0},{"$f":"'Dépenses prev. _part2'!C38","v":1},{"$f":"'Dépenses prev. _part2'!D38","v":0}]
[{"$f":"'Dépenses prev. _part3'!B2","v":"Partenaire 3 (le nommer)"},{"$f":"SUM(B210:B212)","v":0},{"$f":"D209/B209","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D210:D212)","v":0}]
[{"$f":"'Dépenses prev. _part3'!A36","v":0},{"$f":"'Dépenses prev. _part3'!B36","v":0},{"$f":"'Dépenses prev. _part3'!C36","v":1},{"$f":"'Dépenses prev. _part3'!D36","v":0}]
[{"$f":"'Dépenses prev. _part3'!A37","v":0},{"$f":"'Dépenses prev. _part3'!B37","v":0},{"$f":"'Dépenses prev. _part3'!C37","v":1},{"$f":"'Dépenses prev. _part3'!D37","v":0}]
[{"$f":"'Dépenses prev. _part3'!A38","v":0},{"$f":"'Dépenses prev. _part3'!B38","v":0},{"$f":"'Dépenses prev. _part3'!C38","v":1},{"$f":"'Dépenses prev. _part3'!D38","v":0}]
[{"$f":"'Dépenses prev. _part4'!B2","v":"Partenaire 4 (le nommer)"},{"$f":"SUM(B214:B216)","v":0},{"$f":"D213/B213","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D214:D216)","v":0}]
[{"$f":"'Dépenses prev. _part4'!A120","v":0},{"$f":"'Dépenses prev. _part4'!B120","v":0},{"$f":"'Dépenses prev. _part4'!C120","v":0},{"$f":"'Dépenses prev. _part4'!D120","v":0}]
[{"$f":"'Dépenses prev. _part4'!A121","v":0},{"$f":"'Dépenses prev. _part4'!B121","v":0},{"$f":"'Dépenses prev. _part4'!C121","v":0},{"$f":"'Dépenses prev. _part4'!D121","v":0}]
[{"$f":"'Dépenses prev. _part4'!A122","v":0},{"$f":"'Dépenses prev. _part4'!B122","v":0},{"$f":"'Dépenses prev. _part4'!C122","v":0},{"$f":"'Dépenses prev. _part4'!D122","v":0}]
[{"$f":"'Dépenses prev. _part5'!B2","v":"Partenaire 5 (le nommer)"},{"$f":"SUM(B218:B220)","v":0},{"$f":"D217/B217","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D218:D220)","v":0}]
[{"$f":"'Dépenses prev. _part5'!A36","v":0},{"$f":"'Dépenses prev. _part5'!B120","v":0},{"$f":"'Dépenses prev. _part5'!C120","v":0},{"$f":"'Dépenses prev. _part5'!D120","v":0}]
[{"$f":"'Dépenses prev. _part5'!A37","v":0},{"$f":"'Dépenses prev. _part5'!B121","v":0},{"$f":"'Dépenses prev. _part5'!C121","v":0},{"$f":"'Dépenses prev. _part5'!D121","v":0}]
[{"$f":"'Dépenses prev. _part5'!A38","v":0},{"$f":"'Dépenses prev. _part5'!B122","v":0},{"$f":"'Dépenses prev. _part5'!C122","v":0},{"$f":"'Dépenses prev. _part5'!D122","v":0}]
["TOTAL DES COÛTS DIRECTS ÉLIGIBLES",{"$f":"B196+B171+B146+B121+B96+B5","v":0},{"$f":"D221/B221","v":{"$error":"#DIV/0!"}},{"$f":"D196+D171+D146+D121+D96+D5","v":0}]
["g) Options de coûts simplifiées - imputés au projet et définis par l'appel à projet selon la catégorie de votre projet. Ils sont calculés par application d'un taux forfaitaire sur :\n- soit les frais de personnel (15% ou 40%)\n- soit les coûts directs éligibles (7%, ou modulé à 1% ou à 2%)",{"$f":"B223","v":0},null,{"$f":"D223","v":0}]
["Menu déroulant : choisir le taux forfaitaire",{"$f":"IF($A$223=0.07,$A$223*B221,IF($A$223=0.15,$A$223*B5,IF($A$223=0.02,$A$223*B221,IF($A$3755%,#REF!*B5,IF($A$223=0.01,$A$223*B221,0)))))","v":0},null,{"$f":"IF($A$223=0.07,$A$223*D221,IF($A$223=0.15,$A$223*D5,IF($A$223=0.02,$A$223*D221,IF($A$223=0.4,$A$223*D5,IF($A$223=0.01,$A$223*D221,0)))))","v":0}]
["    ou 7% des coûts directs éligibles"]
["COUTS TOTAUX (directs et indirects)  \nHT ou TTC (Supprimer la mention inutile)",{"$f":"IF(A223=0.4,B5+B222,B221+B222)","v":0},{"$f":"D225/B225","v":{"$error":"#DIV/0!"}},{"$f":"IF(A223=0.4,D5+D222,D221+D222)","v":0}]
[]
["*Décote à appliquer sur le coût total éligible",null,"Taux de la décote*","Montant de la décote "]
[null,null,null,{"$f":"D225*C228","v":0}]
["TOTAL DES COÛTS ELIGIBLES APRES DECOTE \nHT ou TTC (Supprimer la mention inutile)",{"$f":"B225*C228","v":0},null,{"$f":"D225-D228","v":0}]
["(*) La décote est un taux représentant la part de l’action qui ne répond pas aux objectifs des fonds, et qui doit donc être défalquée du coût total éligible.  A la différence du taux d'affectation, lequel s'applique individuellement aux postes de dépenses, la décote est appliquée sur le coût total éligible du projet.  Le calcul du taux de la décote devra être justifié et vérifiable"]

{"sheet":"Recapitulatif","index":14,"n_rows":31,"n_cols":7,"rows_kept":31,"cut":false,"hidden":false,"merged":[[28,0,28,6],[30,0,30,5],[19,0,19,3],[1,0,1,6],[3,0,3,6],[5,2,5,5],[5,6,6,6]]}
[]
["Fonds Asile, migration et intégration\nProgrammation 2021-2027\n Plan de financement - Recapitulatif"]
[]
["DEPENSES"]
[]
[null,null,"Ventilation du montant par année",null,null,null,"Cohérence"]
["Nature de la dépense","Montant total","Année en cours","Année n+1","Année n+2","Année n+3"]
[{"$f":"'Plan de financement global'!A5","v":"a) Frais de personnels"},{"$f":"ROUND('Plan de financement global'!D5,2)","v":0},null,null,null,null,{"$f":"IF(SUM(C8:F8)=B8,0,1)","v":0}]
[{"$f":"'Plan de financement global'!A96","v":"b) Frais de voyage et de séjour"},{"$f":"ROUND('Plan de financement global'!D96,2)","v":0},null,null,null,null,0]
[{"$f":"'Plan de financement global'!A121","v":"c) Frais d'équipement"},{"$f":"ROUND('Plan de financement global'!D121,2)","v":0},null,null,null,null,0]
[{"$f":"'Plan de financement global'!A146","v":"d) Biens immobiliers"},{"$f":"ROUND('Plan de financement global'!D146,2)","v":0},null,null,null,null,0]
[{"$f":"'Plan de financement global'!A171","v":"e) Frais de sous-traitance"},{"$f":"ROUND('Plan de financement global'!D171,2)","v":0},null,null,null,null,{"$f":"IF(SUM(C12:F12)=B12,0,1)","v":0}]
[{"$f":"'Plan de financement global'!A196","v":"f) Dépenses spécifiques en relation avec les groupes cibles"},{"$f":"ROUND('Plan de financement global'!D196,2)","v":0},null,null,null,null,{"$f":"IF(SUM(C13:F13)=B13,0,1)","v":0}]
[{"$f":"'Plan de financement global'!A197","v":"Chef de file (le nommer)"},{"$f":"ROUND('Plan de financement global'!D222,2)","v":0},null,null,null,null,0]
["Dépenses totales avant décote",{"$f":"SUM(B7:B14)","v":0},{"$f":"SUM(C7:C14)","v":0},{"$f":"SUM(D7:D14)","v":0},{"$f":"SUM(E7:E14)","v":0},{"$f":"SUM(F7:F14)","v":0},0]
["Dépenses totales après décote",{"$f":"B15*'Plan de financement global'!C228","v":0},{"$f":"C15*'Plan de financement global'!D229","v":0},{"$f":"D15*'Plan de financement global'!E229","v":0},{"$f":"E15*'Plan de financement global'!F230","v":0},{"$f":"F15*'Plan de financement global'!G230","v":0},0]
["TOTAL APRES DECOTE",{"$f":"ROUND(B16,2)","v":0},{"$f":"ROUND(C16,2)","v":0},0,0,0,0]
[]
[]
["RESSOURCES"]
[]
["Financeurs","Montant","Commentaires (le cas échéant)","Taux"]
[{"$f":"'Plan de financement global'!F5","v":"a) Contribution FAMI"},{"$f":"'Plan de financement global'!K5","v":0},null,{"$f":"B23/B27","v":{"$error":"#DIV/0!"}}]
[{"$f":"'Plan de financement global'!F6","v":"b) Cofinanceurs externes publics"},{"$f":"'Plan de financement global'!K6","v":0},null,{"$f":"B24/B27","v":{"$error":"#DIV/0!"}}]
[{"$f":"'Plan de financement global'!F49","v":"c) Cofinanceurs externes privés"},{"$f":"+'Plan de financement global'!K49","v":0},null,{"$f":"B25/B27","v":{"$error":"#DIV/0!"}}]
[{"$f":"'Plan de financement global'!F92","v":"d) Autofinancement (dont les recettes générées par le projet)"},{"$f":"+'Plan de financement global'!K92","v":0},null,{"$f":"B26/B27","v":{"$error":"#DIV/0!"}}]
["TOTAL APRES DECOTE",{"$f":"ROUND(SUM(B23:B26),2)","v":0},null,{"$f":"SUM(D23:D26)","v":{"$error":"#DIV/0!"}}]
[]
["EQUILIBRE DU PLAN DE FINANCEMENT"]
[]
[{"$f":"IF(B27=B17,\"Le plan de financement est équilibré en dépenses et en ressources\",IF(B27>B17,\"Le plan de financement présente un surfinancement\",IF(B27>B17,\"Le plan de financement présente un défaut de ressources\",\"\")))","v":"Le plan de financement est équilibré en dépenses et en ressources"},null,null,null,null,null,{"$f":"IF(B27=B17,0,IF(B27>B17,1,1))","v":0}]

{"sheet":"Détail des dépenses du projet","index":15,"n_rows":21,"n_cols":4,"rows_kept":21,"cut":false,"hidden":false,"merged":[[18,0,18,3],[19,0,19,3],[20,0,20,3],[0,0,0,3],[2,0,2,3],[6,1,6,3],[15,0,15,1],[15,2,15,3],[16,0,16,1],[16,2,16,3]]}
["Fonds \"Asile, migration et intégration\" - 2021-2027\n Détail des dépenses du projet"]
[]
["Description des différents coûts (y compris ceux des partenaires, le cas échéant) et justification de(s) taux d’affectation* et/ou décote** éventuellement applicables aux dépenses. "]
[]
[null,"Expliquer la nature de chaque dépense et justifier le mode de détermination des montants indiqués dans l'onglet plan de financement","Taux d'affectation*","Explication du taux d'affectation"]
["Coûts directs liés au projet"]
["a) Frais de personnels affectés au projet ayant un rôle direct et déterminant ","Compléter l'onglet \"détail des frais de personnel\""]
["b) Frais de voyage et de séjour nécessaires à l'exécution du projet"]
["c) Frais d'équipement \n(crédit-bail, location, achat…)"]
["d) Bien immobiliers \n(achats, contructions, rénovtions)"]
["e) Frais de sous-traitance \n(prestation de service, publicité, communication, évaluation du projet…)"]
["f) Dépenses spécifiques en relation avec le groupe cible"]
["Coûts indirectement liés au projet"]
["Options de couts simplifiés retenus dans le cadre de l'appel à projet","lister les dépenses financées en coûts indirects"]
[]
["Taux de décote éventuel applicable au coût total éligible**",null,"Explication du taux de la décote (Justificatifs à l'appui)**"]
[]
[]
["(*) Le taux d’affectation est un taux qui s’applique aux postes de dépenses directes lorsque celles-ci ne sont pas intégralement affectées au projet afin de déterminer la part des dépenses directement consacrées à la mise en œuvre du projet. Le taux d’affectation doit être justifié et vérifiable. \n\nExemple : salariés qui ne sont pas entièrement mobilisés à la mise en œuvre du projet cofinancé, ou des locaux qui n’y sont pas affectés à 100%. "]
["(**) La décote est un taux représentant la part de l’action qui ne répond pas aux objectifs des fonds, et qui doit donc être défalquée du coût total éligible. A la différence du taux d'affectation, lequel s'applique individuellement aux postes de dépenses, la décote est appliquée sur le coût total éligible du projet. "]
["Exemple : projets d’intégration qui s’adressent à la fois à des publics cible éligibles - migrants ressortissants de pays tiers de l’Union européenne –  et à des publics non éligibles – migrants intra-communautaires.  Le taux de la décote doit être justifié et vérifiable."]

{"sheet":"Détail des ressources du projet","index":16,"n_rows":23,"n_cols":9,"rows_kept":23,"cut":false,"hidden":false,"merged":[[12,0,16,0],[17,0,20,0],[22,0,22,8],[0,0,9,8],[10,0,11,0],[10,1,11,1],[10,2,11,2],[10,3,11,3],[10,4,10,5],[10,6,10,7],[10,8,11,8]]}
["Fonds \"Asile, migration et intégration\" - 2021-2027\n Détail des ressources du projet\nCofinancements publics (autres que FAMI) et privés reportés du plan de financement"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Type de ressources","Nom du cofinanceur sollicité (en toutes lettres)","Date de sollicitation","Montants sollicités*","Date",null,"Si connu, indiquez",null,"Période de financement concernée"]
[null,null,null,null," Lettre d'intention du co-financeur \n(le cas échéant)","Notification d'attribution du cofinanceur \n(le cas échéant)","le montant total accordé","le montant affecté au projet*"]
["b) Contributions des tiers publics \n(y compris celles perçues par les partenaires impliqués dans le projet, le cas échéant) "]
[]
[]
[]
[]
["c) Contributions des tiers privés\n(y compris celles perçues par les partenaires impliqués dans le projet, le cas échéant)"]
[]
[]
[]
[]
["(*) La part du cofinancement affectée au projet doit être attestée par le cofinanceur lui-même et non par le porteur de projet. A défaut, la totalité du cofinancement accordé sera affectée au projet FAMI."]

{"sheet":"Feuil1","index":17,"n_rows":10,"n_cols":1,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
["Taux forfaitaire"]
["Menu déroulant : choisir le taux forfaitaire"]
[0.01]
[0.02]
[7.0000000000000007E-2]
[0.15]
[0.4]