{"text_format":"1","workbook":"xlsx","n_sheets":14,"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","Plan de financement global","Recapitulatif","Détail des dépenses du projet","Détail des ressources du projet","Feuil1"],"not_rendered":{"charts":0,"images":11,"macros":0,"external_links":0,"defined_names":16,"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,17]]}
["Instrument de soutien financier à la gestion des frontières et à la politique des visas\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ées"]
["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 financements 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":35,"n_cols":10,"rows_kept":35,"cut":false,"hidden":false,"merged":[[21,5,21,6],[0,0,0,9],[1,1,1,3]]}
["Instrument de soutien financier à la gestion des frontières et à la politique des visas\nProgrammation 2021-2027\n Plan de financement prévisionnel"]
["\nDé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,"c) Autofinancement (y compris 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]
["TOTAL DES COÛTS DIRECTS ÉLIGIBLES",{"$f":"B31+B27+B23+B19+B4","v":0},{"$f":"IF(B35<>0,D35/B35,\"-\")","v":"-"},{"$f":"D4+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]]}
["Instrument de soutien financier à la gestion des frontières et à la politique des visas\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":35,"n_cols":10,"rows_kept":35,"cut":false,"hidden":false,"merged":[[21,5,21,6],[0,0,0,9],[1,1,1,3]]}
["Instrument de soutien financier à la gestion des frontières et à la politique des visas\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,"c) 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]
["TOTAL DES COÛTS DIRECTS ÉLIGIBLES",{"$f":"B31+B27+B23+B19+B4","v":0},{"$f":"IF(B35<>0,D35/B35,\"-\")","v":"-"},{"$f":"D4+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]]}
["Instrument de soutien financier à la gestion des frontières et à la politique des visas\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":35,"n_cols":10,"rows_kept":35,"cut":false,"hidden":false,"merged":[[21,5,21,6],[0,0,0,9],[1,1,1,3]]}
["Instrument de soutien financier à la gestion des frontières et à la politique des visas\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,"c) Autofinancement (y compris 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]
["TOTAL DES COÛTS DIRECTS ÉLIGIBLES",{"$f":"B31+B27+B23+B19+B4","v":0},{"$f":"IF(B35<>0,D35/B35,\"-\")","v":"-"},{"$f":"D4+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]]}
["Instrument de soutien financier à la gestion des frontières et à la politique des visas\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":35,"n_cols":10,"rows_kept":35,"cut":false,"hidden":false,"merged":[[21,5,21,6],[0,0,0,9],[1,1,1,3]]}
["Instrument de soutien financier à la gestion des frontières et à la politique des visas\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\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 _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,"c) Autofinancement (y compris 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]
["TOTAL DES COÛTS DIRECTS ÉLIGIBLES",{"$f":"B31+B27+B23+B19+B4","v":0},{"$f":"IF(B35<>0,D35/B35,\"-\")","v":"-"},{"$f":"D4+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]]}
["Instrument de soutien financier à la gestion des frontières et à la politique des visas\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":"Plan de financement global","index":9,"n_rows":136,"n_cols":10,"rows_kept":136,"cut":false,"hidden":false,"merged":[[0,0,0,9],[139,0,139,2],[133,0,134,0],[133,1,134,1],[133,2,134,2],[133,3,134,3]]}
["Instrument de soutien financier à la gestion des frontières et à la politique des visas\n\nNom du porteur de projet :\nIntitulé du projet :\nN° SYNERGIE :\n\nPlan de financement prévisionnel du projet"]
["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","% sur ressources totales affectées au projet éligible "]
["a) Frais de personnels",{"$f":"B4+B19+B49","v":0},{"$f":"D3/B3","v":{"$error":"#DIV/0!"}},{"$f":"D4+D19+D49","v":0},null,"a) Contribution IGFV",{"$f":"B136-G4-G33-G62","v":0},{"$f":"C132","v":{"$error":"#DIV/0!"}},{"$f":"H3*G3","v":{"$error":"#DIV/0!"}},{"$f":"I3/$D$136","v":{"$error":"#DIV/0!"}}]
[{"$f":"'Dépenses prév._chef de file'!B2","v":"Chef de file (le nommer)"},{"$f":"SUM(B5:B18)","v":0},{"$f":"D4/B4","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D5:D18)","v":0},null,"b) Cofinanceurs externes publics",{"$f":"G5+G12+G19+G26","v":0},{"$f":"I4/G4","v":{"$error":"#DIV/0!"}},{"$f":"I5+I12+I19+I26","v":0},{"$f":"I4/$D$136","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étails frais perso_chef file'!C3","v":0},{"$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(G6:G11)","v":0},{"$f":"SUM(H6:H11)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(I6:I11)","v":0},{"$f":"I5/$D$136","v":{"$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étails frais perso_chef file'!C4","v":0},{"$f":"'Dépenses prév._chef de file'!D6","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},{"$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étails frais perso_chef file'!C5","v":0},{"$f":"'Dépenses prév._chef de file'!D7","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},{"$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étails frais perso_chef file'!C6","v":0},{"$f":"'Dépenses prév._chef de file'!D8","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},{"$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étails frais perso_chef file'!C7","v":0},{"$f":"'Dépenses prév._chef de file'!D9","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},{"$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étails frais perso_chef file'!C8","v":0},{"$f":"'Dépenses prév._chef de file'!D10","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},{"$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étails frais perso_chef file'!C9","v":0},{"$f":"'Dépenses prév._chef de file'!D11","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},{"$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étails frais perso_chef file'!C10","v":0},{"$f":"'Dépenses prév._chef de file'!D12","v":"-"},null,{"$f":"'Dépenses prev. _part1'!B2","v":"Partenaire 1 (le nommer)"},{"$f":"SUM(G13:G18)","v":0},{"$f":"SUM(H13:H18)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(I13:I18)","v":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étails frais perso_chef file'!C11","v":0},{"$f":"'Dépenses prév._chef de file'!D13","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},{"$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étails frais perso_chef file'!C12","v":0},{"$f":"'Dépenses prév._chef de file'!D14","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},{"$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étails frais perso_chef file'!C13","v":0},{"$f":"'Dépenses prév._chef de file'!D15","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},{"$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étails frais perso_chef file'!C14","v":0},{"$f":"'Dépenses prév._chef de file'!D16","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},{"$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étails frais perso_chef file'!C15","v":0},{"$f":"'Dépenses prév._chef de file'!D17","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},{"$f":"I17/$D$136","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étails frais perso_chef file'!C16","v":0},{"$f":"'Dépenses prév._chef de file'!D18","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},{"$error":"#DIV/0!"}]
[{"$f":"'Dépenses prev. _part1'!B2","v":"Partenaire 1 (le nommer)"},{"$f":"SUM(B20:B33)","v":0},{"$f":"D19/B19","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D20:D33)","v":0},null,{"$f":"'Dépenses prev. _part2'!B2","v":"Partenaire 2 (le nommer)"},{"$f":"SUM(G20:G25)","v":0},{"$f":"SUM(H20:H25)","v":{"$error":"#DIV/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},{"$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},{"$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},{"$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},{"$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},{"$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},{"$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(G27:G32)","v":0},{"$f":"SUM(H27:H32)","v":{"$error":"#DIV/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},{"$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},{"$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},{"$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},{"$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},{"$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},{"$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,"c) Cofinanceurs externes privés",{"$f":"G34+G41+G48+G55","v":0},{"$f":"I33/G33","v":{"$error":"#DIV/0!"}},{"$f":"I34+I41+I48+I55","v":0},{"$error":"#DIV/0!"}]
[{"$f":"'Dépenses prev. _part2'!B2","v":"Partenaire 2 (le nommer)"},{"$f":"SUM(B35:B48)","v":0},{"$f":"D34/B34","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D35:D48)","v":0},null,{"$f":"'Dépenses prév._chef de file'!B2","v":"Chef de file (le nommer)"},{"$f":"SUM(G35:G40)","v":0},{"$f":"SUM(H35:H40)","v":{"$error":"#DIV/0!"}},0,{"$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 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},{"$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 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},{"$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 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},{"$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 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},{"$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 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},{"$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 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},{"$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. _part1'!B2","v":"Partenaire 1 (le nommer)"},{"$f":"SUM(G42:G48)","v":0},{"$f":"SUM(H42:H48)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(I42:I48)","v":0},{"$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. _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},{"$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. _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},{"$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. _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},{"$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. _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},{"$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. _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},{"$f":"I46/$D$136","v":{"$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,{"$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},{"$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 prev. _part2'!B2","v":"Partenaire 2 (le nommer)"},{"$f":"SUM(G49:G54)","v":0},{"$f":"SUM(H49:H54)","v":{"$error":"#DIV/0!"}},0,{"$error":"#DIV/0!"}]
[{"$f":"'Dépenses prev. _part3'!B2","v":"Partenaire 3 (le nommer)"},{"$f":"SUM(B50:B63)","v":0},{"$f":"D49/B49","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D50:D63)","v":0},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},{"$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 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},{"$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 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},{"$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 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},{"$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 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},{"$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 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},{"$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. _part3'!B2","v":"Partenaire 3 (le nommer)"},{"$f":"SUM(G56:G62)","v":0},{"$f":"SUM(H56:H62)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(I56:I62)","v":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. _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},{"$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. _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},{"$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. _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},{"$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. _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},{"$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. _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},{"$f":"I60/$D$136","v":{"$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. _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},{"$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,"e) Autofinancement (dont les recettes générées par le projet) ",{"$f":"G63+G67+G71+G75","v":0},{"$f":"I62/G62","v":{"$error":"#DIV/0!"}},{"$f":"I63+I67+I71+I75","v":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 prév._chef de file'!B2","v":"Chef de file (le nommer)"},{"$f":"SUM(G64:G66)","v":0},{"$f":"SUM(H64:H66)","v":{"$error":"#DIV/0!"}},0,{"$error":"#DIV/0!"}]
["b) Frais de voyage et de séjour",{"$f":"B65+B69+B73+B77","v":0},{"$f":"D64/B64","v":{"$error":"#DIV/0!"}},{"$f":"D65+D69+D73+D77","v":0},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},{"$error":"#DIV/0!"}]
[{"$f":"'Dépenses prév._chef de file'!B2","v":"Chef de file (le nommer)"},{"$f":"SUM(B66:B68)","v":0},{"$f":"D65/B65","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D66:D68)","v":0},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},{"$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 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},{"$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'!B2","v":"Partenaire 1 (le nommer)"},{"$f":"SUM(G68:G70)","v":0},{"$f":"SUM(H68:H70)","v":{"$error":"#DIV/0!"}},0,{"$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'!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},{"$error":"#DIV/0!"}]
[{"$f":"'Dépenses prev. _part1'!B2","v":"Partenaire 1 (le nommer)"},{"$f":"SUM(B70:B72)","v":0},{"$f":"D69/B69","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D70:D72)","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},{"$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. _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},{"$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'!B2","v":"Partenaire 2 (le nommer)"},{"$f":"SUM(G72:G74)","v":0},{"$f":"SUM(H72:H74)","v":{"$error":"#DIV/0!"}},0,{"$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'!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":"I72/$D$136","v":{"$error":"#DIV/0!"}}]
[{"$f":"'Dépenses prev. _part2'!B2","v":"Partenaire 2 (le nommer)"},{"$f":"SUM(B74:B76)","v":0},{"$f":"D73/B73","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D74:D76)","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},{"$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. _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},{"$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'!B2","v":"Partenaire 3 (le nommer)"},{"$f":"SUM(G76:G78)","v":0},{"$f":"SUM(H76:H78)","v":{"$error":"#DIV/0!"}},0,{"$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'!F19","v":0},{"$f":"'Dépenses prev. _part3'!G19","v":0},{"$f":"'Dépenses prev. _part3'!H19","v":{"$error":"#DIV/0!"}},{"$f":"'Dépenses prev. _part3'!I19","v":0},{"$error":"#DIV/0!"}]
[{"$f":"'Dépenses prev. _part3'!B2","v":"Partenaire 3 (le nommer)"},{"$f":"SUM(B78:B80)","v":0},{"$f":"D77/B77","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D78:D80)","v":0},null,{"$f":"'Dépenses prev. _part3'!F20","v":0},{"$f":"'Dépenses prev. _part3'!G20","v":0},{"$f":"'Dépenses prev. _part3'!H20","v":{"$error":"#DIV/0!"}},{"$f":"'Dépenses prev. _part3'!I20","v":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. _part3'!F21","v":0},{"$f":"'Dépenses prev. _part3'!G21","v":0},{"$f":"'Dépenses prev. _part3'!H21","v":{"$error":"#DIV/0!"}},{"$f":"'Dépenses prev. _part3'!I21","v":0},{"$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,"TOTAL DES RESSOURCES ELIGIBLES ",{"$f":"SUM(G62,G3,G4,G33)","v":0},{"$f":"SUM(H62,H3,H4,H33)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(I62,I3,I4,I33)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(J62,J3,J4,J33)","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}]
["c) Frais d'équipement",{"$f":"B82+B86+B90+B94","v":0},{"$f":"D81/B81","v":{"$error":"#DIV/0!"}},{"$f":"D82+D86+D90+D94","v":0}]
[{"$f":"'Dépenses prév._chef de file'!B2","v":"Chef de file (le nommer)"},{"$f":"SUM(B83:B85)","v":0},{"$f":"D82/B82","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D83:D85)","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(B87:B89)","v":0},{"$f":"D86/B86","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D87:D89)","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(B91:B93)","v":0},{"$f":"D90/B90","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D91:D93)","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(B95:B97)","v":0},{"$f":"D94/B94","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D95:D97)","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}]
["d) Biens immobiliers",{"$f":"B99+B103+B107+B111","v":0},{"$f":"D98/B98","v":{"$error":"#DIV/0!"}},{"$f":"D99+D103+D107+D111","v":0}]
[{"$f":"'Dépenses prév._chef de file'!B2","v":"Chef de file (le nommer)"},{"$f":"SUM(B100:B102)","v":0},{"$f":"D99/B99","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D100:D102)","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(B104:B106)","v":0},{"$f":"D103/B103","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D104:D106)","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(B108:B110)","v":0},{"$f":"D107/B107","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D108:D110)","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(B112:B114)","v":0},{"$f":"D111/B111","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D112:D114)","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}]
["e) Frais de sous-traitance",{"$f":"B116+B120+B124+B128","v":0},{"$f":"D115/B115","v":{"$error":"#DIV/0!"}},{"$f":"D116+D120+D124+D128","v":0}]
[{"$f":"'Dépenses prév._chef de file'!B2","v":"Chef de file (le nommer)"},{"$f":"SUM(B117:B119)","v":0},{"$f":"D116/B116","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D117:D119)","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(B121:B123)","v":0},{"$f":"D120/B120","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D121:D123)","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(B125:B127)","v":0},{"$f":"D124/B124","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D125:D127)","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(B129:B131)","v":0},{"$f":"D128/B128","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D129:D131)","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}]
["TOTAL DES COÛTS DIRECTS ÉLIGIBLES",{"$f":"B115+B98+B81+B64+B3","v":0},{"$f":"D132/B132","v":{"$error":"#DIV/0!"}},{"$f":"D115+D98+D81+D64+D3","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":"B134","v":0},null,{"$f":"D134","v":0}]
["Menu déroulant : choisir le taux forfaitaire",{"$f":"IF($A$134=0.07,$A$134*B132,IF($A$134=0.15,$A$134*B3,IF($A$134=0.02,$A$134*B132,IF($A$134=0.4,$A$134*B3,IF($A$134=0.01,$A$134*B132,0)))))","v":0},null,{"$f":"IF($A$134=0.07,$A$134*D132,IF($A$134=0.15,$A$134*D3,IF($A$134=0.02,$A$134*D132,IF($A$134=0.4,$A$134*D3,IF($A$134=0.01,$A$134*D132,0)))))","v":0}]
[]
["TOTAL DES COUTS ÉLIGIBLES (directs et indirects)  \nHT ou TTC (Supprimer la mention inutile)",{"$f":"IF($A$134=0.4,B133+B3,B132+B133)","v":0},null,{"$f":"IF($A$134=0.4,D133+D3,D132+D133)","v":0}]

{"sheet":"Recapitulatif","index":10,"n_rows":29,"n_cols":7,"rows_kept":29,"cut":false,"hidden":false,"merged":[[26,0,26,6],[28,0,28,5],[17,0,17,3],[1,0,1,6],[3,0,3,6],[5,2,5,5],[5,6,6,6]]}
[]
["Instrument de soutien financier à la gestion des frontières et à la politique des visas\nProgrammation 2021-2027\n Plan de financement - Récapitulatif"]
[]
["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'!A3","v":"a) Frais de personnels"},{"$f":"ROUND('Plan de financement global'!D3,2)","v":0},null,null,null,null,{"$f":"IF(SUM(C8:F8)=B8,0,1)","v":0}]
[{"$f":"'Plan de financement global'!A64","v":"b) Frais de voyage et de séjour"},{"$f":"ROUND('Plan de financement global'!D64,2)","v":0},null,null,null,null,0]
[{"$f":"'Plan de financement global'!A81","v":"c) Frais d'équipement"},{"$f":"ROUND('Plan de financement global'!D81,2)","v":0},null,null,null,null,0]
[{"$f":"'Plan de financement global'!A98","v":"d) Biens immobiliers"},{"$f":"ROUND('Plan de financement global'!D98,2)","v":0},null,null,null,null,0]
[{"$f":"'Plan de financement global'!A115","v":"e) Frais de sous-traitance"},{"$f":"ROUND('Plan de financement global'!D115,2)","v":0},null,null,null,null,{"$f":"IF(SUM(C12:F12)=B12,0,1)","v":0}]
["f) Option de coûts simplifiés",{"$f":"ROUND('Plan de financement global'!D133,2)","v":0},null,null,null,null,{"$f":"IF(SUM(C13:F13)=B13,0,1)","v":0}]
["Dépenses totales",{"$f":"SUM(B7:B13)","v":0},{"$f":"SUM(C7:C13)","v":0},{"$f":"SUM(D7:D13)","v":0},{"$f":"SUM(E7:E13)","v":0},{"$f":"SUM(F7:F13)","v":0},0]
["TOTAL",{"$f":"ROUND(B14,2)","v":0},{"$f":"ROUND(C14,2)","v":0},0,0,0,0]
[]
[]
["RESSOURCES"]
[]
["Financeurs","Montant","Commentaires (le cas échéant","Taux"]
[{"$f":"'Plan de financement global'!F3","v":"a) Contribution IGFV"},{"$f":"'Plan de financement global'!I3","v":{"$error":"#DIV/0!"}},null,{"$f":"B21/B25","v":{"$error":"#DIV/0!"}}]
[{"$f":"'Plan de financement global'!F4","v":"b) Cofinanceurs externes publics"},{"$f":"'Plan de financement global'!I4","v":0},null,{"$f":"B22/B25","v":{"$error":"#DIV/0!"}}]
[{"$f":"'Plan de financement global'!F33","v":"c) Cofinanceurs externes privés"},{"$f":"+'Plan de financement global'!I33","v":0},null,{"$f":"B23/B25","v":{"$error":"#DIV/0!"}}]
["d) Autofinancement, dont les recettes générées par le projet",{"$f":"+'Plan de financement global'!I63","v":0},null,{"$f":"B24/B25","v":{"$error":"#DIV/0!"}}]
["TOTAL",{"$f":"ROUND(SUM(B21:B24),2)","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM(D21:D24)","v":{"$error":"#DIV/0!"}}]
[]
["EQUILIBRE DU PLAN DE FINANCEMENT"]
[]
[{"$f":"IF(B25=B15,\"Le plan de financement est équilibré en dépenses et en ressources\",IF(B25>B15,\"Le plan de financement présente un surfinancement\",IF(B25>B15,\"Le plan de financement présente un défaut de ressources\",\"\")))","v":{"$error":"#DIV/0!"}},null,null,null,null,null,{"$f":"IF(B25=B15,0,IF(B25>B15,1,1))","v":{"$error":"#DIV/0!"}}]

{"sheet":"Détail des dépenses du projet","index":11,"n_rows":18,"n_cols":4,"rows_kept":18,"cut":false,"hidden":false,"merged":[[17,0,17,3],[0,0,0,3],[2,0,2,3],[6,1,6,3],[14,0,14,1],[14,2,14,3],[15,0,15,1],[15,2,15,3]]}
["Instrument de soutien financier à la gestion des frontières et à la politique des visas \nProgrammation 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* é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éjou 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…)"]
["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. \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%. "]

{"sheet":"Détail des ressources du projet","index":12,"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]]}
["Instrument de soutien financier à la gestion des frontières et à la politique des visas\nProgrammation 2021-2027\n Détail des ressources du projet\nCofinancements publics (autres que l'IGFV) 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 IGFV."]

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