{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Budget du projet et financement","Décompte 1ère année","Décompte 2ème année","Décompte 3ème année","Abrechnung 3. Jahr","Décompte fin du projet","Décompte 4me année"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":42,"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":"Budget du projet et financement","index":0,"n_rows":71,"n_cols":21,"rows_kept":71,"cut":false,"hidden":false,"merged":[[29,2,29,3],[29,4,29,15],[34,2,34,3],[34,4,34,15],[2,12,2,13],[2,14,2,21],[3,14,3,21],[13,2,13,3],[14,2,14,3],[27,2,27,3],[28,2,28,3],[27,4,27,15],[28,4,28,15],[26,2,26,3],[21,2,21,3],[26,4,26,15],[21,4,21,15],[22,4,22,15],[23,4,23,15],[9,2,9,20],[11,16,11,20],[11,2,11,3],[1,12,1,20],[5,2,5,20],[6,6,6,11],[6,14,6,18],[7,2,8,21],[6,2,6,4],[30,13,30,15],[59,13,59,15],[52,13,52,15],[53,13,53,15],[54,2,54,3],[56,2,56,12],[58,2,58,3],[58,4,58,12],[59,2,59,3],[59,4,59,12],[58,13,58,15],[57,13,57,15],[51,13,51,20],[56,13,56,20],[32,2,32,3],[33,2,33,3],[32,4,32,15],[33,4,33,15],[46,2,46,12],[71,2,71,6],[71,9,71,10],[71,13,71,14],[69,2,69,15],[70,2,70,15],[66,2,66,15],[67,2,67,15],[20,2,20,3],[13,4,13,15],[14,4,14,15],[15,4,15,15],[19,4,19,15],[20,4,20,15],[19,2,19,3],[15,2,15,3],[16,2,16,3],[16,4,16,15],[41,4,41,12],[41,13,41,15],[53,2,53,3],[49,13,49,15],[54,13,54,15],[52,4,52,12],[43,13,43,15],[12,2,12,3],[12,4,12,15],[11,4,11,15],[22,2,22,3],[23,2,23,3],[17,13,17,15],[24,13,24,15],[67,16,67,20],[70,16,70,20],[68,2,68,20],[41,16,41,20],[42,13,42,15],[53,4,53,12],[54,4,54,12],[45,13,45,15],[47,4,47,12],[46,13,46,15],[47,13,47,15],[49,2,49,3],[49,4,49,12],[57,2,57,3],[57,4,57,12],[50,13,50,15],[55,13,55,15],[71,16,71,20],[65,16,65,20],[69,16,69,20],[65,2,65,15],[52,2,52,3],[60,13,60,15],[63,2,63,20],[31,2,31,3],[61,2,61,12],[66,16,66,20],[51,2,51,12],[39,2,39,20],[42,2,42,12],[41,2,41,3],[35,13,35,15],[48,2,48,3],[48,4,48,12],[48,13,48,15],[44,13,44,15],[43,2,43,3],[43,4,43,12],[44,2,44,3],[44,4,44,12],[47,2,47,3]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Département fédéral de justice et police DFJP\nSecrétariat d'Etat aux migrations SEM\nDomaine de direction Immigration et intégration\nDivision Intégration"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Numéro de projet:",null,"Nr. "]
[null,null,null,null,null,null,null,null,null,null,null,null,"Division Intégration:",null,"Text"]
[]
[null,null,"Budget du projet et financement \nEncouragement de l'intégration par la Confédération - Programmes et projets d'importance nationale"]
[null,null,"Durée du projet\n(Date, par ex. 01.01.2021)",null,null,"du:",null,null,null,null,null,null,null,"au:"]
[null,null,"Merci de ne remplir que les champs à fond bleu. Excel calcule automatiquement les montants intermédiaires. Des lignes supplémentaires peuvent être ajoutées en cas de besoin (ctrl+u)."]
[]
[null,null,"Coûts totaux budgétisés pour le projet"]
[]
[null,null,"Type de coût",null,"Description",null,null,null,null,null,null,null,null,null,null,null,"Montant"]
[null,null,"Coûts de personnel",null,"Indiquez la fonction, le taux d'occupation/heures de travail, salaire/tarif horaire. Inscrire sur des lignes séparées les personnes ou groupes de personnes ayant des tarifs horaires différents.",null,null,null,null,null,null,null,null,null,null,null,"Année 1","Année 2","Année 3","Année 4","Total"]
[null,null,"Personne ou groupe 1",null,"Exemple : administrateur sans diplôme, tarif horaire CHF 80, total 1000 heures",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q14:T14)","v":0}]
[null,null,"Personne ou groupe 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q15:T15)","v":0}]
[null,null,"Prestations sociales",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q16:T16)","v":0}]
[null,null,"Frais et indemnisations",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q17:T17)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,{"$f":"SUM(Q14:Q17)","v":0},{"$f":"SUM(R14:R17)","v":0},{"$f":"SUM(S14:S17)","v":0},{"$f":"SUM(T14:T17)","v":0},{"$f":"SUM(U14:U17)","v":0}]
[null,null,"Coûts de biens et services"]
[null,null,"Prestations de service externes",null,"Exemple : chargé de cours externe, tarif horaire CHF 120 incl. prestations sociales et TVA, total 200 heures",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q20:T20)","v":0}]
[null,null,"Publicité",null,"Exemple : brochure",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q21:T21)","v":0}]
[null,null,"Manifestations",null,"Exemple : location de la salle de cours",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q22:T22)","v":0}]
[null,null,"Matériel",null,"Exemple : matériel de cours",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q23:T23)","v":0}]
[null,null,"Autres charges de biens et services",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q24:T24)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,{"$f":"SUM(Q20:Q24)","v":0},{"$f":"SUM(R20:R24)","v":0},{"$f":"SUM(S20:S24)","v":0},{"$f":"SUM(T20:T24)","v":0},{"$f":"SUM(U20:U24)","v":0}]
[null,null,"Coûts d'infrastructure"]
[null,null,"Acquisitions/investissements",null,"Exemple : infrastructure de bureau",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q27:T27)","v":0}]
[null,null,"Location infrastructure",null,"Exemple : location des locaux",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q28:T28)","v":0}]
[null,null,"Entretien et réparations",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q29:T29)","v":0}]
[null,null,"Autres charges d'infrastructure",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q30:T30)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,{"$f":"SUM(Q27:Q30)","v":0},{"$f":"SUM(R27:R30)","v":0},{"$f":"SUM(S27:S30)","v":0},{"$f":"SUM(T27:T30)","v":0},{"$f":"SUM(U27:U30)","v":0}]
[null,null,"Coûts divers"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q33:T33)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q34:T34)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q35:T35)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,{"$f":"SUM(Q33:Q35)","v":0},{"$f":"SUM(R33:R35)","v":0},{"$f":"SUM(S33:S35)","v":0},{"$f":"SUM(T33:T35)","v":0},{"$f":"SUM(U33:U35)","v":0}]
[null,null,"Coûts totaux budgétisés pour le projet",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q18+Q25+Q31+Q36","v":0},{"$f":"R18+R25+R31+R36","v":0},{"$f":"S18+S25+S31+S36","v":0},{"$f":"T18+T25+T31+T36","v":0},{"$f":"U18+U25+U31+U36","v":0}]
[]
[]
[null,null,"Recettes budgétisées pour le projet"]
[]
[null,null,"Type de recette",null,"Description",null,null,null,null,null,null,null,null,"Montant"]
[null,null,"Contribution Confédération",null,null,null,null,null,null,null,null,null,null,"Montant alloué\n(OUI/NON)",null,null,"Année 1","Année 2","Année 3","Année 4","Total"]
[null,null,"Contribution demandée SEM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q44:T44)","v":0}]
[null,null,"Exemple : contribution office xy",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q45:T45)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,{"$f":"SUM(Q44:Q45)","v":0},{"$f":"SUM(R44:R45)","v":0},{"$f":"SUM(S44:S45)","v":0},{"$f":"SUM(T44:T45)","v":0},{"$f":"SUM(U44:U45)","v":0}]
[null,null,"Contributions de tiers (y compris de cantons et communes)"]
[null,null,"Exemple : contribution allouée canton xy",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q48:T48)","v":0}]
[null,null,"Exemple : contribution ONG xy",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q49:T49)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q50:T50)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,{"$f":"SUM(Q48:Q50)","v":0},{"$f":"SUM(R48:R50)","v":0},{"$f":"SUM(S48:S50)","v":0},{"$f":"SUM(T48:T50)","v":0},{"$f":"SUM(U48:U50)","v":0}]
[null,null,"Prestations propres"]
[null,null,"Contributions financières",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q53:T53)","v":0}]
[null,null,"Travail",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q54:T54)","v":0}]
[null,null,"Offres d'infrastructure",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q55:T55)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,{"$f":"SUM(Q53:Q55)","v":0},{"$f":"SUM(R53:R55)","v":0},{"$f":"SUM(S53:S55)","v":0},{"$f":"SUM(T53:T55)","v":0},{"$f":"SUM(U53:U55)","v":0}]
[null,null,"Recettes tirées d'activités liées au projet"]
[null,null,"Exemple : taxes de cours",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q58:T58)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q59:T59)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q60:T60)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,{"$f":"SUM(Q58:Q60)","v":0},{"$f":"SUM(R58:R60)","v":0},{"$f":"SUM(S58:S60)","v":0},{"$f":"SUM(T58:T60)","v":0},{"$f":"SUM(U58:U60)","v":0}]
[null,null,"Total recettes pour le projet",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q46+Q51+Q56+Q61","v":0},{"$f":"R46+R51+R56+R61","v":0},{"$f":"S46+S51+S56+S61","v":0},{"$f":"T46+T51+T56+T61","v":0},{"$f":"U46+U51+U56+U61","v":0}]
[]
[null,null,"Aperçu budget du projet et financement"]
[]
[null,null,"Total recettes budgétisées pour le projet",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U62","v":0}]
[null,null,"Total coûts budgétisés pour le projet",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U37","v":0}]
[null,null,"Excédent/défaut de financement",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q66-Q67","v":0}]
[]
[null,null,"Part cofinancement en CHF",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(U51,U56,U61,)","v":0}]
[null,null,"Part cofinancement en %",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q70/Q67","v":{"$error":"#DIV/0!"}}]

{"sheet":"Décompte 1ère année","index":1,"n_rows":71,"n_cols":19,"rows_kept":71,"cut":false,"hidden":false,"merged":[[41,2,41,3],[32,2,32,3],[32,4,32,15],[41,16,41,18],[41,4,41,14],[35,13,35,14],[1,12,1,19],[7,2,8,20],[9,2,9,19],[5,2,5,18],[6,14,6,19],[6,2,6,4],[6,6,6,12],[2,12,2,13],[3,12,3,13],[2,14,2,20],[3,14,3,20],[71,16,71,18],[65,2,65,15],[59,2,59,3],[66,2,66,15],[67,2,67,15],[69,16,69,18],[70,16,70,18],[71,9,71,10],[71,13,71,14],[69,2,69,15],[61,2,61,14],[59,4,59,15],[70,2,70,15],[71,2,71,6],[58,4,58,15],[13,2,13,3],[11,2,11,3],[12,2,12,3],[52,4,52,14],[53,4,53,14],[55,13,55,14],[15,2,15,3],[23,2,23,3],[11,4,11,15],[51,2,51,14],[50,13,50,14],[16,2,16,3],[22,2,22,3],[20,2,20,3],[21,2,21,3],[13,4,13,15],[14,2,14,3],[14,4,14,15],[46,2,46,18],[34,4,34,15],[30,13,30,14],[17,13,17,14],[24,13,24,14],[31,2,31,18],[15,4,15,15],[16,4,16,15],[22,4,22,15],[20,4,20,15],[18,2,18,18],[29,4,29,14],[39,2,39,18],[42,2,42,14],[52,2,52,3],[43,4,43,15],[44,2,44,3],[44,4,44,15],[12,4,12,15],[11,16,11,18],[65,16,65,18],[66,16,66,18],[67,16,67,18],[63,2,63,18],[47,4,47,15],[48,2,48,3],[48,4,48,15],[53,2,53,3],[54,2,54,3],[54,4,54,14],[49,4,49,15],[60,13,60,14],[57,2,57,3],[57,4,57,15],[58,2,58,3],[45,13,45,14],[43,2,43,3],[19,2,19,3],[19,4,19,15],[34,2,34,3],[21,4,21,15],[23,4,23,15],[26,4,26,14],[27,4,27,14],[28,4,28,14],[56,2,56,18],[33,2,33,3],[33,4,33,15],[49,2,49,3],[47,2,47,3]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Département fédéral de justice et police DFJP\nSecrétariat d'Etat aux migrations SEM\nDomaine de direction Immigration et intégration\nDivision Intégration"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Numéro de projet:",null,{"$f":"'Budget du projet et financement'!O3:V3","v":"Nr. "}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Division Intégration:",null,{"$f":"'Budget du projet et financement'!O4:V4","v":"Text"}]
[]
[null,null,"Décompte année de projet 1\nEncouragement de l'intégration par la Confédération - Programmes et projets d'importance nationale"]
[null,null,"Période de décompte\n(Date, par ex. 01.01.2021)",null,null,"du:",null,null,null,null,null,null,null,"au:"]
[null,null,"Merci de ne remplir que les champs à fond bleu. Excel calcule automatiquement les montants intermédiaires. Des lignes supplémentaires peuvent être ajoutées en cas de besoin (ctrl+u)."]
[]
[null,null,"Coûts totaux du projet"]
[]
[null,null,"Type de coût",null,"Description",null,null,null,null,null,null,null,null,null,null,null,"Montant"]
[null,null,"Coûts de personnel",null,"Indiquez la fonction, le taux d'occupation/heures de travail, salaire/tarif horaire. Inscrire sur des lignes séparées les personnes ou groupes de personnes ayant des tarifs horaires différents.",null,null,null,null,null,null,null,null,null,null,null,"Coûts budgétisés","Coûts effectifs","Différence"]
[null,null,"Personne ou groupe 1",null,"Exemple : administrateur sans diplôme, tarif horaire CHF 80, total 1000 heures",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!Q14","v":0},null,{"$f":"Q14-R14","v":0}]
[null,null,"Personne ou groupe 2",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!Q15","v":0},null,{"$f":"Q15-R15","v":0}]
[null,null,"Prestations sociales",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!Q16","v":0},null,{"$f":"Q16-R16","v":0}]
[null,null,"Frais et indemnisations",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!Q17","v":0},null,{"$f":"Q17-R17","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,{"$f":"SUM(Q14:Q17)","v":0},{"$f":"SUM(R14:R17)","v":0},{"$f":"SUM(S14:S17)","v":0}]
[null,null,"Coûts de biens et services"]
[null,null,"Prestations de service externes",null,"Exemple : chargé de cours externe, tarif horaire CHF 120 incl. prestations sociales et TVA, total 200 heures",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!Q20","v":0},null,{"$f":"Q20-R20","v":0}]
[null,null,"Publicité",null,"Exemple : brochure",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!Q21","v":0},null,{"$f":"Q21-R21","v":0}]
[null,null,"Manifestations",null,"Exemple : location de la salle de cours",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!Q22","v":0},null,{"$f":"Q22-R22","v":0}]
[null,null,"Matériel",null,"Exemple : matériel de cours",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!Q23","v":0},null,{"$f":"Q23-R23","v":0}]
[null,null,"Autres charges de biens et services",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!Q24","v":0},null,{"$f":"Q24-R24","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,{"$f":"SUM(Q20:Q24)","v":0},{"$f":"SUM(R20:R24)","v":0},{"$f":"SUM(S20:S24)","v":0}]
[null,null,"Coûts d'infrastructure"]
[null,null,"Acquisitions/investissements",null,"Exemple : infrastructure de bureau",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!Q27","v":0},null,{"$f":"Q27-R27","v":0}]
[null,null,"Location infrastructure",null,"Exemple : location des locaux",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!Q28","v":0},null,{"$f":"Q28-R28","v":0}]
[null,null,"Entretien et réparations",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!Q29","v":0},null,{"$f":"Q29-R29","v":0}]
[null,null,"Autres charges d'infrastructure",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!Q30","v":0},null,{"$f":"Q30-R30","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,{"$f":"SUM(Q27:Q30)","v":0},{"$f":"SUM(R27:R30)","v":0},{"$f":"SUM(S27:S30)","v":0}]
[null,null,"Coûts divers"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!Q33","v":0},null,{"$f":"Q33-R33","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!Q34","v":0},null,{"$f":"Q34-R34","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!Q35","v":0},null,{"$f":"Q35-R35","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,{"$f":"SUM(Q33:Q35)","v":0},{"$f":"SUM(R33:R35)","v":0},{"$f":"SUM(S33:S35)","v":0}]
[null,null,"Coût total du projet",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q18+Q25+Q31+Q36","v":0},{"$f":"R18+R25+R31+R36","v":0},{"$f":"S18+S25+S31+S36","v":0}]
[]
[]
[null,null,"Recettes du projet"]
[]
[null,null,"Type de recette",null,"Description",null,null,null,null,null,null,null,null,null,null,null,"Montant"]
[null,null,"Contribution Confédération",null,null,null,null,null,null,null,null,null,null,null,null,null,"Recettes budgétisées","Recettes effectives","Différence"]
[null,null,"Contribution demandée SEM",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!Q44","v":0},null,{"$f":"Q44-R44","v":0}]
[null,null,"Exemple : contribution autres offices fédéraux",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!Q45","v":0},null,{"$f":"Q45-R45","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,{"$f":"SUM(Q44:Q45)","v":0},{"$f":"SUM(R44:R45)","v":0},{"$f":"SUM(S44:S45)","v":0}]
[null,null,"Contributions de tiers (y compris de cantons et communes)"]
[null,null,"Exemple : contribution allouée canton xy",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!Q48","v":0},null,{"$f":"Q48-R48","v":0}]
[null,null,"Exemple : contribution ONG",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!Q49","v":0},null,{"$f":"Q49-R49","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!Q50","v":0},null,{"$f":"Q50-R50","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,{"$f":"SUM(Q48:Q50)","v":0},{"$f":"SUM(R48:R50)","v":0},{"$f":"SUM(S48:S50)","v":0}]
[null,null,"Prestations propres"]
[null,null,"Contributions financières",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!Q53","v":0},null,{"$f":"Q53-R53","v":0}]
[null,null,"Travail",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!Q54","v":0},null,{"$f":"Q54-R54","v":0}]
[null,null,"Offres d'infrastructure",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!Q55","v":0},null,{"$f":"Q55-R55","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,{"$f":"SUM(Q53:Q55)","v":0},{"$f":"SUM(R53:R55)","v":0},{"$f":"SUM(S53:S55)","v":0}]
[null,null,"Recettes tirées d'activités liées au projet"]
[null,null,"Exemple : taxes de cours",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!Q58","v":0},null,{"$f":"Q58-R58","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!Q59","v":0},null,{"$f":"Q59-R59","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!Q60","v":0},null,{"$f":"Q60-R60","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,{"$f":"SUM(Q58:Q60)","v":0},{"$f":"SUM(R58:R60)","v":0},{"$f":"SUM(S58:S60)","v":0}]
[null,null,"Total recettes pour le projet",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q46+Q51+Q56+Q61","v":0},{"$f":"R46+R51+R56+R61","v":0},{"$f":"S46+S51+S56+S61","v":0}]
[]
[null,null,"Aperçu décompte année de projet 1"]
[]
[null,null,"Total recettes effectives",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R62","v":0}]
[null,null,"Total coûts effectifs",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R37","v":0}]
[null,null,"Excédent/défaut de financement",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q66-Q67","v":0}]
[]
[null,null,"Part cofinancement en CHF",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R51,R56,R61,)","v":0}]
[null,null,"Part cofinancement en %",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q70/Q67","v":{"$error":"#DIV/0!"}}]

{"sheet":"Décompte 2ème année","index":2,"n_rows":71,"n_cols":19,"rows_kept":71,"cut":false,"hidden":false,"merged":[[5,2,5,18],[6,2,6,4],[6,6,6,12],[6,14,6,19],[1,12,1,19],[2,12,2,13],[3,12,3,13],[2,14,2,20],[3,14,3,20],[11,16,11,18],[12,2,12,3],[12,4,12,15],[7,2,8,20],[9,2,9,19],[13,2,13,3],[13,4,13,15],[11,2,11,3],[11,4,11,15],[14,2,14,3],[14,4,14,15],[15,2,15,3],[15,4,15,15],[16,2,16,3],[16,4,16,15],[17,13,17,14],[18,2,18,18],[19,2,19,3],[19,4,19,15],[20,2,20,3],[20,4,20,15],[21,2,21,3],[21,4,21,15],[22,2,22,3],[22,4,22,15],[23,2,23,3],[23,4,23,15],[24,13,24,14],[30,13,30,14],[31,2,31,18],[32,2,32,3],[32,4,32,15],[26,4,26,14],[27,4,27,14],[28,4,28,14],[29,4,29,14],[33,2,33,3],[33,4,33,15],[34,2,34,3],[34,4,34,15],[35,13,35,14],[39,2,39,18],[41,2,41,3],[41,4,41,14],[41,16,41,18],[42,2,42,14],[43,2,43,3],[43,4,43,15],[44,2,44,3],[44,4,44,15],[45,13,45,14],[46,2,46,18],[47,2,47,3],[47,4,47,15],[48,2,48,3],[48,4,48,15],[49,2,49,3],[49,4,49,15],[50,13,50,14],[51,2,51,14],[52,4,52,14],[53,2,53,3],[53,4,53,14],[54,2,54,3],[54,4,54,14],[52,2,52,3],[55,13,55,14],[56,2,56,18],[57,2,57,3],[57,4,57,15],[58,2,58,3],[58,4,58,15],[59,2,59,3],[59,4,59,15],[60,13,60,14],[61,2,61,14],[63,2,63,18],[65,2,65,15],[65,16,65,18],[66,2,66,15],[66,16,66,18],[67,2,67,15],[67,16,67,18],[69,2,69,15],[69,16,69,18],[70,2,70,15],[70,16,70,18],[71,2,71,6],[71,9,71,10],[71,13,71,14],[71,16,71,18]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Département fédéral de justice et police DFJP\nSecrétariat d'Etat aux migrations SEM\nDomaine de direction Immigration et intégration\nDivision Intégration"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Numéro de projet:",null,{"$f":"'Budget du projet et financement'!O3:V3","v":"Nr. "}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Division Intégration:",null,{"$f":"'Budget du projet et financement'!O4:V4","v":"Text"}]
[]
[null,null,"Décompte année de projet 2\nEncouragement de l'intégration par la Confédération - Programmes et projets d'importance nationale"]
[null,null,"Période de décompte\n(Date, par ex. 01.01.2021)",null,null,"du:",null,null,null,null,null,null,null,"au:"]
[null,null,"Merci de ne remplir que les champs à fond bleu. Excel calcule automatiquement les montants intermédiaires. Des lignes supplémentaires peuvent être ajoutées en cas de besoin (ctrl+u)."]
[]
[null,null,"Coûts totaux du projet"]
[]
[null,null,"Type de coût",null,"Description",null,null,null,null,null,null,null,null,null,null,null,"Montant"]
[null,null,"Coûts de personnel",null,"Indiquez la fonction, le taux d'occupation/heures de travail, salaire/tarif horaire. Inscrire sur des lignes séparées les personnes ou groupes de personnes ayant des tarifs horaires différents. ",null,null,null,null,null,null,null,null,null,null,null,"Coûts budgétisés","Coûts effectifs","Différence"]
[null,null,"Personne ou groupe 1",null,"Exemple : administrateur sans diplôme, tarif horaire CHF 80, total 1000 heures",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!R14","v":0},null,{"$f":"Q14-R14","v":0}]
[null,null,"Personne ou groupe 2",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!R15","v":0},null,{"$f":"Q15-R15","v":0}]
[null,null,"Prestations sociales",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!R16","v":0},null,{"$f":"Q16-R16","v":0}]
[null,null,"Frais et indemnisations",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!R17","v":0},null,{"$f":"Q17-R17","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,{"$f":"SUM(Q14:Q17)","v":0},{"$f":"SUM(R14:R17)","v":0},{"$f":"SUM(S14:S17)","v":0}]
[null,null,"Coûts de biens et services"]
[null,null,"Prestations de service externes",null,"Exemple : chargé de cours externe, tarif horaire CHF 120 incl. prestations sociales et TVA, total 200 heures",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!R20","v":0},null,{"$f":"Q20-R20","v":0}]
[null,null,"Publicité",null,"Exemple : brochure",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!R21","v":0},null,{"$f":"Q21-R21","v":0}]
[null,null,"Manifestations",null,"Exemple : location de la salle de cours",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!R22","v":0},null,{"$f":"Q22-R22","v":0}]
[null,null,"Matériel",null,"Exemple : matériel de cours",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!R23","v":0},null,{"$f":"Q23-R23","v":0}]
[null,null,"Autres charges de biens et services",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!R24","v":0},null,{"$f":"Q24-R24","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,{"$f":"SUM(Q20:Q24)","v":0},{"$f":"SUM(R20:R24)","v":0},{"$f":"SUM(S20:S24)","v":0}]
[null,null,"Coûts d'infrastructure"]
[null,null,"Acquisitions/investissements",null,"Exemple : infrastructure de bureau",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!R27","v":0},null,{"$f":"Q27-R27","v":0}]
[null,null,"Location infrastructure",null,"Exemple : location des locaux",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!R28","v":0},null,{"$f":"Q28-R28","v":0}]
[null,null,"Entretien et réparations",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!R29","v":0},null,{"$f":"Q29-R29","v":0}]
[null,null,"Autres charges d'infrastructure",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!R30","v":0},null,{"$f":"Q30-R30","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,{"$f":"SUM(Q27:Q30)","v":0},{"$f":"SUM(R27:R30)","v":0},{"$f":"SUM(S27:S30)","v":0}]
[null,null,"Coûts divers"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!R33","v":0},null,{"$f":"Q33-R33","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!R34","v":0},null,{"$f":"Q34-R34","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!R35","v":0},null,{"$f":"Q35-R35","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,{"$f":"SUM(Q33:Q35)","v":0},{"$f":"SUM(R33:R35)","v":0},{"$f":"SUM(S33:S35)","v":0}]
[null,null,"Coût total du projet",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q18+Q25+Q31+Q36","v":0},{"$f":"R18+R25+R31+R36","v":0},{"$f":"S18+S25+S31+S36","v":0}]
[]
[]
[null,null,"Recettes du projet"]
[]
[null,null,"Type de recette",null,"Description",null,null,null,null,null,null,null,null,null,null,null,"Montant"]
[null,null,"Contribution Confédération",null,null,null,null,null,null,null,null,null,null,null,null,null,"Recettes budgétisées","Recettes effectives","Différence"]
[null,null,"Contribution demandée SEM",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!R44","v":0},null,{"$f":"Q44-R44","v":0}]
[null,null,"Exemple : contribution autres office fédéraux",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!R45","v":0},null,{"$f":"Q45-R45","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,{"$f":"SUM(Q44:Q45)","v":0},{"$f":"SUM(R44:R45)","v":0},{"$f":"SUM(S44:S45)","v":0}]
[null,null,"Contributions de tiers (y compris de cantons et communes)"]
[null,null,"Exemple : contribution allouée canton xy",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!R48","v":0},null,{"$f":"Q48-R48","v":0}]
[null,null,"Exemple : contribution ONG",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!R49","v":0},null,{"$f":"Q49-R49","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!R50","v":0},null,{"$f":"Q50-R50","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,{"$f":"SUM(Q48:Q50)","v":0},{"$f":"SUM(R48:R50)","v":0},{"$f":"SUM(S48:S50)","v":0}]
[null,null,"Prestations propres"]
[null,null,"Contributions financières",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!R53","v":0},null,{"$f":"Q53-R53","v":0}]
[null,null,"Travail",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!R54","v":0},null,{"$f":"Q54-R54","v":0}]
[null,null,"Offres d'infrastructure",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!R55","v":0},null,{"$f":"Q55-R55","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,{"$f":"SUM(Q53:Q55)","v":0},{"$f":"SUM(R53:R55)","v":0},{"$f":"SUM(S53:S55)","v":0}]
[null,null,"Recettes tirées d'activités liées au projet"]
[null,null,"Exemple : taxes de cours",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!R58","v":0},null,{"$f":"Q58-R58","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!R59","v":0},null,{"$f":"Q59-R59","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!R60","v":0},null,{"$f":"Q60-R60","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,{"$f":"SUM(Q58:Q60)","v":0},{"$f":"SUM(R58:R60)","v":0},{"$f":"SUM(S58:S60)","v":0}]
[null,null,"Total recettes pour le projet",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q46+Q51+Q56+Q61","v":0},{"$f":"R46+R51+R56+R61","v":0},{"$f":"S46+S51+S56+S61","v":0}]
[]
[null,null,"Aperçu décompte année de projet 2"]
[]
[null,null,"Total recettes effectives",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R62","v":0}]
[null,null,"Total coûts effectifs",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R37","v":0}]
[null,null,"Excédent/défaut de financement",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q66-Q67","v":0}]
[]
[null,null,"Part cofinancement en CHF",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R51,R56,R61,)","v":0}]
[null,null,"Part cofinancement en %",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q70/Q67","v":{"$error":"#DIV/0!"}}]

{"sheet":"Décompte 3ème année","index":3,"n_rows":71,"n_cols":19,"rows_kept":71,"cut":false,"hidden":false,"merged":[[3,12,3,13],[3,14,3,20],[69,2,69,15],[69,16,69,18],[70,2,70,15],[70,16,70,18],[71,2,71,6],[71,9,71,10],[71,13,71,14],[71,16,71,18],[67,2,67,15],[67,16,67,18],[58,2,58,3],[58,4,58,15],[59,2,59,3],[59,4,59,15],[60,13,60,14],[61,2,61,14],[63,2,63,18],[65,2,65,15],[65,16,65,18],[66,2,66,15],[66,16,66,18],[54,2,54,3],[54,4,54,14],[55,13,55,14],[56,2,56,18],[57,2,57,3],[57,4,57,15],[50,13,50,14],[51,2,51,14],[52,2,52,3],[52,4,52,14],[53,2,53,3],[53,4,53,14],[49,2,49,3],[49,4,49,15],[42,2,42,14],[43,2,43,3],[43,4,43,15],[44,2,44,3],[44,4,44,15],[45,13,45,14],[46,2,46,18],[47,2,47,3],[47,4,47,15],[48,2,48,3],[48,4,48,15],[34,2,34,3],[34,4,34,15],[35,13,35,14],[39,2,39,18],[41,2,41,3],[41,4,41,14],[41,16,41,18],[33,2,33,3],[33,4,33,15],[23,2,23,3],[23,4,23,15],[24,13,24,14],[26,4,26,14],[27,4,27,14],[28,4,28,14],[29,4,29,14],[30,13,30,14],[31,2,31,18],[32,2,32,3],[32,4,32,15],[20,2,20,3],[20,4,20,15],[21,2,21,3],[21,4,21,15],[22,2,22,3],[22,4,22,15],[16,2,16,3],[16,4,16,15],[17,13,17,14],[18,2,18,18],[19,2,19,3],[19,4,19,15],[13,2,13,3],[13,4,13,15],[14,2,14,3],[14,4,14,15],[15,2,15,3],[15,4,15,15],[12,2,12,3],[12,4,12,15],[1,12,1,19],[5,2,5,18],[6,2,6,4],[6,6,6,12],[6,14,6,19],[7,2,8,20],[9,2,9,19],[11,2,11,3],[11,4,11,15],[11,16,11,18],[2,12,2,13],[2,14,2,20]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Département fédéral de justice et police DFJP\nSecrétariat d'Etat aux migrations SEM\nDomaine de direction Immigration et intégration\nDivision Intégration"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Numéro de projet:",null,{"$f":"'Budget du projet et financement'!O3:V3","v":"Nr. "}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Division Intégration:",null,{"$f":"'Budget du projet et financement'!O4:V4","v":"Text"}]
[]
[null,null,"Décompte année de projet 3\nEncouragement de l'intégration par la Confédération - Programmes et projets d'importance nationale"]
[null,null,"Période de décompte\n(Date, par ex. 01.01.2021)",null,null,"du:",null,null,null,null,null,null,null,"au:"]
[null,null,"Merci de ne remplir que les champs à fond bleu. Excel calcule automatiquement les montants intermédiaires. Des lignes supplémentaires peuvent être ajoutées en cas de besoin (ctrl+u)."]
[]
[null,null,"Coûts totaux du projet"]
[]
[null,null,"Type de coût",null,"Description",null,null,null,null,null,null,null,null,null,null,null,"Montant"]
[null,null,"Coûts de personnel",null,"Indiquez la fonction, le taux d'occupation/heures de travail, salaire/tarif horaire. Inscrire sur des lignes séparées les personnes ou groupes de personnes ayant des tarifs horaires différents. ",null,null,null,null,null,null,null,null,null,null,null,"Coûts budgétisés","Coûts effectifs","Différence"]
[null,null,"Personne ou groupe 1",null,"Exemple : administrateur sans diplôme, tarif horaire CHF 80, total 1000 heures",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!R14","v":0},null,{"$f":"Q14-R14","v":0}]
[null,null,"Personne ou groupe 2",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!R15","v":0},null,{"$f":"Q15-R15","v":0}]
[null,null,"Prestations sociales",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!R16","v":0},null,{"$f":"Q16-R16","v":0}]
[null,null,"Frais et indemnisations",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!R17","v":0},null,{"$f":"Q17-R17","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,{"$f":"SUM(Q14:Q17)","v":0},{"$f":"SUM(R14:R17)","v":0},{"$f":"SUM(S14:S17)","v":0}]
[null,null,"Coûts de biens et services"]
[null,null,"Prestations de service externes",null,"Exemple : chargé de cours externe, tarif horaire CHF 120 incl. prestations sociales et TVA, total 200 heures",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!R20","v":0},null,{"$f":"Q20-R20","v":0}]
[null,null,"Publicité",null,"Exemple : brochure",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!R21","v":0},null,{"$f":"Q21-R21","v":0}]
[null,null,"Manifestations",null,"Exemple : location de la salle de cours",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!R22","v":0},null,{"$f":"Q22-R22","v":0}]
[null,null,"Matériel",null,"Exemple : matériel de cours",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!R23","v":0},null,{"$f":"Q23-R23","v":0}]
[null,null,"Autres charges de biens et services",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!R24","v":0},null,{"$f":"Q24-R24","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,{"$f":"SUM(Q20:Q24)","v":0},{"$f":"SUM(R20:R24)","v":0},{"$f":"SUM(S20:S24)","v":0}]
[null,null,"Coûts d'infrastructure"]
[null,null,"Acquisitions/investissements",null,"Exemple : infrastructure de bureau",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!R27","v":0},null,{"$f":"Q27-R27","v":0}]
[null,null,"Location infrastructure",null,"Exemple : location des locaux",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!R28","v":0},null,{"$f":"Q28-R28","v":0}]
[null,null,"Entretien et réparations",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!R29","v":0},null,{"$f":"Q29-R29","v":0}]
[null,null,"Autres charges d'infrastructure",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!R30","v":0},null,{"$f":"Q30-R30","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,{"$f":"SUM(Q27:Q30)","v":0},{"$f":"SUM(R27:R30)","v":0},{"$f":"SUM(S27:S30)","v":0}]
[null,null,"Coûts divers"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!R33","v":0},null,{"$f":"Q33-R33","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!R34","v":0},null,{"$f":"Q34-R34","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!R35","v":0},null,{"$f":"Q35-R35","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,{"$f":"SUM(Q33:Q35)","v":0},{"$f":"SUM(R33:R35)","v":0},{"$f":"SUM(S33:S35)","v":0}]
[null,null,"Coût total du projet",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q18+Q25+Q31+Q36","v":0},{"$f":"R18+R25+R31+R36","v":0},{"$f":"S18+S25+S31+S36","v":0}]
[]
[]
[null,null,"Recettes du projet"]
[]
[null,null,"Type de recette",null,"Description",null,null,null,null,null,null,null,null,null,null,null,"Montant"]
[null,null,"Contribution Confédération",null,null,null,null,null,null,null,null,null,null,null,null,null,"Recettes budgétisées","Recettes effectives","Différence"]
[null,null,"Contribution demandée SEM",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!R44","v":0},null,{"$f":"Q44-R44","v":0}]
[null,null,"Exemple : contribution autres office fédéraux",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!R45","v":0},null,{"$f":"Q45-R45","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,{"$f":"SUM(Q44:Q45)","v":0},{"$f":"SUM(R44:R45)","v":0},{"$f":"SUM(S44:S45)","v":0}]
[null,null,"Contributions de tiers (y compris de cantons et communes)"]
[null,null,"Exemple : contribution allouée canton xy",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!R48","v":0},null,{"$f":"Q48-R48","v":0}]
[null,null,"Exemple : contribution ONG",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!R49","v":0},null,{"$f":"Q49-R49","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!R50","v":0},null,{"$f":"Q50-R50","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,{"$f":"SUM(Q48:Q50)","v":0},{"$f":"SUM(R48:R50)","v":0},{"$f":"SUM(S48:S50)","v":0}]
[null,null,"Prestations propres"]
[null,null,"Contributions financières",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!R53","v":0},null,{"$f":"Q53-R53","v":0}]
[null,null,"Travail",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!R54","v":0},null,{"$f":"Q54-R54","v":0}]
[null,null,"Offres d'infrastructure",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!R55","v":0},null,{"$f":"Q55-R55","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,{"$f":"SUM(Q53:Q55)","v":0},{"$f":"SUM(R53:R55)","v":0},{"$f":"SUM(S53:S55)","v":0}]
[null,null,"Recettes tirées d'activités liées au projet"]
[null,null,"Exemple : taxes de cours",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!R58","v":0},null,{"$f":"Q58-R58","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!R59","v":0},null,{"$f":"Q59-R59","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!R60","v":0},null,{"$f":"Q60-R60","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,{"$f":"SUM(Q58:Q60)","v":0},{"$f":"SUM(R58:R60)","v":0},{"$f":"SUM(S58:S60)","v":0}]
[null,null,"Total recettes pour le projet",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q46+Q51+Q56+Q61","v":0},{"$f":"R46+R51+R56+R61","v":0},{"$f":"S46+S51+S56+S61","v":0}]
[]
[null,null,"Aperçu décompte année de projet 2"]
[]
[null,null,"Total recettes effectives",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R62","v":0}]
[null,null,"Total coûts effectifs",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R37","v":0}]
[null,null,"Excédent/défaut de financement",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q66-Q67","v":0}]
[]
[null,null,"Part cofinancement en CHF",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R51,R56,R61,)","v":0}]
[null,null,"Part cofinancement en %",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q70/Q67","v":{"$error":"#DIV/0!"}}]

{"sheet":"Abrechnung 3. Jahr","index":4,"n_rows":71,"n_cols":19,"rows_kept":71,"cut":false,"hidden":true,"merged":[[1,12,1,18],[2,12,2,18],[3,12,3,18],[5,2,5,18],[6,2,6,4],[6,6,6,12],[6,14,6,19],[7,2,8,19],[9,2,9,18],[11,2,11,3],[11,4,11,15],[11,16,11,18],[12,2,12,3],[12,4,12,15],[13,2,13,3],[13,4,13,15],[14,2,14,3],[14,4,14,15],[15,2,15,3],[15,4,15,15],[16,2,16,3],[16,4,16,15],[17,13,17,14],[18,2,18,18],[19,2,19,3],[19,4,19,15],[20,2,20,3],[20,4,20,15],[21,2,21,3],[21,4,21,15],[22,2,22,3],[22,4,22,15],[23,2,23,3],[23,4,23,15],[24,13,24,14],[25,2,25,18],[26,2,26,3],[26,4,26,15],[27,2,27,3],[27,4,27,15],[28,2,28,3],[28,4,28,15],[29,2,29,3],[29,4,29,15],[30,13,30,14],[31,2,31,18],[32,2,32,3],[32,4,32,15],[33,2,33,3],[33,4,33,15],[34,2,34,3],[34,4,34,15],[35,13,35,14],[39,2,39,18],[41,2,41,3],[41,4,41,14],[41,16,41,18],[42,2,42,14],[43,2,43,3],[43,4,43,15],[44,2,44,3],[44,4,44,15],[45,13,45,14],[46,2,46,18],[47,2,47,3],[47,4,47,15],[48,2,48,3],[48,4,48,15],[49,2,49,3],[49,4,49,15],[50,13,50,14],[51,2,51,14],[52,4,52,14],[53,2,53,3],[53,4,53,14],[54,2,54,3],[54,4,54,14],[55,13,55,14],[56,2,56,18],[57,2,57,3],[57,4,57,15],[58,2,58,3],[58,4,58,15],[59,2,59,3],[59,4,59,15],[69,2,69,15],[69,16,69,18],[70,2,70,15],[70,16,70,18],[71,2,71,6],[71,9,71,10],[71,13,71,14],[71,16,71,18],[60,13,60,14],[61,2,61,14],[63,2,63,18],[65,2,65,15],[65,16,65,18],[66,2,66,15],[66,16,66,18],[67,2,67,15],[67,16,67,18]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Eidgenössisches Justiz- und Polizeidepartement EJPD\nBundesamt für Migration BFM\nDirektionsbereich Zuwanderung und Integration\nAbteilung Integration"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Projektnummer:"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Abteilung Integration:"]
[]
[null,null,"Abrechnung Projektjahr 3\nIntegrationsförderung des Bundes - Programme und Projekte von nationaler Bedeutung"]
[null,null,"Abrechnungszeitraum:\n(Datum, z.B. 01.01.2015)",null,null,"von:",null,null,null,null,null,null,null,"bis:"]
[null,null,"Bitte füllen Sie nur die blau hinterlegten Felder aus. Excel addiert die Zwischentotale automatisch. Bei Bedarf können weitere Zeilen eingefügt werden."]
[]
[null,null,"Gesamtkosten für das Projekt"]
[]
[null,null,"Kostenart",null,"Beschreibung",null,null,null,null,null,null,null,null,null,null,null,"Betrag"]
[null,null,"Personalkosten ",null,"Geben Sie bitte die Funktion, den Beschäftigungsgrad/Arbeitsstunden, Lohn/Stundenansatz an.Pro Person oder Personengruppe mit unterschiedlichen Stundenansätzen separate Zeile ausfüllen. ",null,null,null,null,null,null,null,null,null,null,null,"Budgetierte Kosten","Effektive Kosten","Differenz"]
[null,null,"Person oder Personengruppe 1",null,"Beispiel: Administrator ohne Diplom, Stundenansatz 80, Total 1000 Stunden",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!S14","v":0},null,{"$f":"Q14-R14","v":0}]
[null,null,"Person oder Personengruppe 2",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!S15","v":0},null,{"$f":"Q15-R15","v":0}]
[null,null,"Sozialleistungen",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!S16","v":0},null,{"$f":"Q16-R16","v":0}]
[null,null,"Spesen und Vergütungen",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!S17","v":0},null,{"$f":"Q17-R17","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,{"$f":"SUM(Q14:Q17)","v":0},{"$f":"SUM(R14:R17)","v":0},{"$f":"SUM(S14:S17)","v":0}]
[null,null,"Sachkosten und Dienstleistungen"]
[null,null,"Externe Dienstleistungen",null,"Beispiel: Externer Kursleiter, Stundensatz CHF 120 inkl. Sozialleistungen und MWSt, Totall 200 Stunden",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!S20","v":0},null,{"$f":"Q20-T20","v":0}]
[null,null,"Werbung",null,"Beispiel: Broschüre",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!S21","v":0},null,{"$f":"Q21-T21","v":0}]
[null,null,"Veranstaltungen",null,"Beispiel: Miete Kursraum",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!S22","v":0},null,{"$f":"Q22-T22","v":0}]
[null,null,"Materialien",null,"Beispiel: Kursmaterial",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!S23","v":0},null,{"$f":"Q23-T23","v":0}]
[null,null,"Andere Sachkosten und Dienstleistungen",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!S24","v":0},null,{"$f":"Q24-T24","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,{"$f":"SUM(Q20:Q24)","v":0},{"$f":"SUM(R20:R24)","v":0},{"$f":"SUM(S20:S24)","v":0}]
[null,null,"Infrastrukturkosten"]
[null,null,"Anschaffungen/Investitionen",null,"Beispiel: Büroinfrastruktur",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!S27","v":0},null,{"$f":"Q27-R27","v":0}]
[null,null,"Miete Infrastruktur",null,"Beispiel: Miete Büroräumlichkeiten",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!S28","v":0},null,{"$f":"Q28-R28","v":0}]
[null,null,"Unterhalt und Reparaturen",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!S29","v":0},null,{"$f":"Q29-R29","v":0}]
[null,null,"Andere Infrastrukturkosten",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!S30","v":0},null,{"$f":"Q30-R30","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,{"$f":"SUM(Q27:Q30)","v":0},{"$f":"SUM(R27:R30)","v":0},{"$f":"SUM(S27:S30)","v":0}]
[null,null,"Diverse Kosten"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!S33","v":0},null,{"$f":"Q33-R33","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!S34","v":0},null,{"$f":"Q34-R34","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!S35","v":0},null,{"$f":"Q35-R35","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,{"$f":"SUM(Q33:Q35)","v":0},{"$f":"SUM(R33:R35)","v":0},{"$f":"SUM(S33:S35)","v":0}]
[null,null,"Total Kosten für das Projekt",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q18+Q25+Q31+Q36","v":0},{"$f":"R18+R25+R31+R36","v":0},{"$f":"S18+S25+S31+S36","v":0}]
[]
[]
[null,null,"Einnahmen für das Projekt"]
[]
[null,null,"Einnahmeart",null,"Beschreibung",null,null,null,null,null,null,null,null,null,null,null,"Betrag"]
[null,null,"Subvention Bund",null,null,null,null,null,null,null,null,null,null,null,null,null,"Budgetierte Einnahmen","Effektive Einnahmen","Differenz"]
[null,null,"Beantragter Beitrag BFM",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!S44","v":0},null,{"$f":"Q44-R44","v":0}]
[null,null,"Beispiel: Beiträge von anderen Bundesämter",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!S45","v":0},null,{"$f":"Q45-R45","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,{"$f":"SUM(Q44:Q45)","v":0},{"$f":"SUM(R44:R45)","v":0},{"$f":"SUM(S44:S45)","v":0}]
[null,null,"Beiträge von Dritten (auch Beiträge von Kantonen und Gemeinden)"]
[null,null,"Beispiel: Zugesicherter Beitrag Kanton xy",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!R48","v":0},null,{"$f":"Q48-R48","v":0}]
[null,null,"Beispiel: Beitrag NGO",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!R49","v":0},null,{"$f":"Q49-R49","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!R50","v":0},null,{"$f":"Q50-R50","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,{"$f":"SUM(Q48:R50)","v":0},{"$f":"SUM(R48:S50)","v":0},{"$f":"SUM(S48:T50)","v":0}]
[null,null,"Eigenleistungen"]
[null,null,"Finanzielle Beiträge",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!S53","v":0},null,{"$f":"Q53-R53","v":0}]
[null,null,"Arbeitsleistung",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!S54","v":0},null,{"$f":"Q54-R54","v":0}]
[null,null,"Infrastrukturangebote",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!S55","v":0},null,{"$f":"Q55-R55","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,{"$f":"SUM(Q53:Q55)","v":0},{"$f":"SUM(R53:R55)","v":0},{"$f":"SUM(S53:S55)","v":0}]
[null,null,"Einnahmen aus projektbezogenen Aktivitäten"]
[null,null,"Beispiel: Kursgebühren",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!S58","v":0},null,{"$f":"Q58-R58","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!S59","v":0},null,{"$f":"Q59-R59","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!S60","v":0},null,{"$f":"Q60-R60","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,{"$f":"SUM(Q58:Q60)","v":0},{"$f":"SUM(R58:R60)","v":0},{"$f":"SUM(S58:S60)","v":0}]
[null,null,"Total Einnahmen für das Projekt",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q45+Q51+Q56+Q61","v":0},{"$f":"R45+R51+R56+R61","v":0},{"$f":"S45+S51+S56+S61","v":0}]
[]
[null,null,"Übersicht Abrechnung Projektjahr 3"]
[]
[null,null,"Total effektive Einnahmen",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R62","v":0}]
[null,null,"Total effektive Kosten",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R37","v":0}]
[null,null,"Finanzierungsüberschuss/ -defizit",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q66-Q67","v":0}]
[]
[null,null,"Anteil Ko-Finanzierung in CHF",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R51,R56,R61,)","v":0}]
[null,null,"Anteil Ko-Finanzierung in %",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"100/R67*R70","v":{"$error":"#DIV/0!"}}]

{"sheet":"Décompte fin du projet","index":5,"n_rows":71,"n_cols":23,"rows_kept":71,"cut":false,"hidden":false,"merged":[[1,12,1,22],[5,2,5,22],[6,2,6,4],[6,6,6,12],[6,14,6,23],[2,12,2,13],[2,14,2,22],[3,12,3,13],[3,14,3,22],[7,2,8,23],[9,2,9,22],[11,2,11,3],[11,4,11,15],[11,16,11,22],[12,2,12,3],[12,4,12,15],[13,2,13,3],[13,4,13,15],[14,2,14,3],[14,4,14,15],[15,2,15,3],[15,4,15,15],[16,2,16,3],[16,4,16,15],[17,13,17,14],[18,2,18,22],[19,2,19,3],[19,4,19,15],[20,2,20,3],[20,4,20,15],[21,2,21,3],[21,4,21,15],[22,2,22,3],[22,4,22,15],[23,2,23,3],[23,4,23,15],[24,13,24,14],[25,2,25,22],[26,4,26,15],[52,2,52,3],[27,4,27,15],[28,4,28,15],[29,4,29,15],[30,13,30,14],[31,2,31,22],[32,2,32,3],[32,4,32,15],[33,2,33,3],[33,4,33,15],[34,2,34,3],[34,4,34,15],[35,13,35,14],[39,2,39,22],[41,2,41,3],[41,4,41,14],[41,16,41,22],[42,2,42,14],[43,2,43,3],[43,4,43,15],[44,2,44,3],[44,4,44,15],[45,13,45,14],[46,2,46,22],[47,2,47,3],[47,4,47,15],[48,2,48,3],[48,4,48,15],[49,2,49,3],[49,4,49,15],[50,13,50,14],[51,2,51,14],[52,4,52,14],[53,2,53,3],[53,4,53,14],[54,2,54,3],[54,4,54,14],[55,13,55,14],[56,2,56,22],[57,2,57,3],[57,4,57,15],[58,2,58,3],[58,4,58,15],[59,2,59,3],[59,4,59,15],[60,13,60,14],[61,2,61,14],[63,2,63,22],[65,2,65,15],[65,16,65,22],[66,2,66,15],[66,16,66,22],[67,2,67,15],[67,16,67,22],[69,2,69,15],[69,16,69,22],[70,2,70,15],[70,16,70,22],[71,2,71,6],[71,9,71,10],[71,13,71,14],[71,16,71,22]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Département fédéral de justice et police DFJP\nSecrétariat d'Etat aux migrations SEM\nDomaine de direction Immigration et intégration\nDivision Intégration"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Numéro de projet:",null,{"$f":"'Budget du projet et financement'!O3:V3","v":"Nr. "}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Division Intégration:",null,{"$f":"'Budget du projet et financement'!O4:V4","v":"Text"}]
[]
[null,null,"Décompte fin du projet\nEncouragement de l'intégration par la Confédération - Programmes et projets d'importance nationale"]
[null,null," ",null,null,"du:",null,null,null,null,null,null,null,"au:"]
[null,null,"Merci de ne remplir que les champs à fond bleu. Excel calcule automatiquement les montants intermédiaires. Des lignes supplémentaires peuvent être ajoutées en cas de besoin (ctrl+u)."]
[]
[null,null,"Coûts totaux du projet"]
[]
[null,null,"Type de coût",null,"Description",null,null,null,null,null,null,null,null,null,null,null,"Montant"]
[null,null,"Coûts de personnel",null,"Indiquez la fonction, le taux d'occupation/heures de travail, salaire/tarif horaire. Inscrire sur des lignes séparées les personnes ou groupes de personnes ayant des tarifs horaires différents. ",null,null,null,null,null,null,null,null,null,null,null,"Total coûts budgétisés","Année 1 coûts effectifs","Année 2 coûts effectifs","Année 3 coûts effectifs","Année 4 coûts effectifs","Total \ncoûts effectifs","Différence"]
[null,null,"Personne ou groupe 1",null,"Exemple : administrateur sans diplôme, tarif horaire CHF 80, total 1000 heures",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!U14","v":0},{"$f":"'Décompte 1ère année'!R14","v":0},{"$f":"'Décompte 2ème année'!R14","v":0},{"$f":"'Décompte 3ème année'!R14","v":0},{"$f":"'Décompte 4me année'!R14","v":0},{"$f":"SUM(R14:U14)","v":0},{"$f":"Q14-V14","v":0}]
[null,null,"Personne ou groupe 2",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!U15","v":0},{"$f":"'Décompte 1ère année'!R15","v":0},{"$f":"'Décompte 2ème année'!R15","v":0},{"$f":"'Décompte 3ème année'!R15","v":0},{"$f":"'Décompte 4me année'!R15","v":0},{"$f":"SUM(R15:U15)","v":0},{"$f":"Q15-V15","v":0}]
[null,null,"Prestations sociales",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!U16","v":0},{"$f":"'Décompte 1ère année'!R16","v":0},{"$f":"'Décompte 2ème année'!R16","v":0},{"$f":"'Décompte 3ème année'!R16","v":0},{"$f":"'Décompte 4me année'!R16","v":0},{"$f":"SUM(R16:U16)","v":0},{"$f":"Q16-V16","v":0}]
[null,null,"Frais et indemnisations",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!U17","v":0},{"$f":"'Décompte 1ère année'!R17","v":0},{"$f":"'Décompte 2ème année'!R17","v":0},{"$f":"'Décompte 3ème année'!R17","v":0},{"$f":"'Décompte 4me année'!R17","v":0},{"$f":"SUM(R17:U17)","v":0},{"$f":"Q17-V17","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,{"$f":"SUM(Q14:Q17)","v":0},0,0,{"$f":"SUM(T14:T17)","v":0},0,{"$f":"SUM(V14:V17)","v":0},0]
[null,null,"Coûts de biens et services"]
[null,null,"Prestations de service externes",null,"Exemple : chargé de cours externe, tarif horaire CHF 120 incl. prestations sociales et TVA, total 200 heures",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!U20","v":0},{"$f":"'Décompte 1ère année'!R20","v":0},{"$f":"'Décompte 2ème année'!R20","v":0},{"$f":"'Décompte 3ème année'!R20","v":0},{"$f":"'Décompte 4me année'!R20","v":0},{"$f":"SUM(R20:U20)","v":0},{"$f":"Q20-V20","v":0}]
[null,null,"Publicité",null,"Exemple : brochure",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!U21","v":0},{"$f":"'Décompte 1ère année'!R21","v":0},{"$f":"'Décompte 2ème année'!R21","v":0},{"$f":"'Décompte 3ème année'!R21","v":0},{"$f":"'Décompte 4me année'!R21","v":0},{"$f":"SUM(R21:U21)","v":0},{"$f":"Q21-V21","v":0}]
[null,null,"Manifestations",null,"Exemple : location de la salle de cours",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!U22","v":0},{"$f":"'Décompte 1ère année'!R22","v":0},{"$f":"'Décompte 2ème année'!R22","v":0},{"$f":"'Décompte 3ème année'!R22","v":0},{"$f":"'Décompte 4me année'!R22","v":0},{"$f":"SUM(R22:U22)","v":0},{"$f":"Q22-V22","v":0}]
[null,null,"Matériel",null,"Exemple : matériel de cours",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!U23","v":0},{"$f":"'Décompte 1ère année'!R23","v":0},{"$f":"'Décompte 2ème année'!R23","v":0},{"$f":"'Décompte 3ème année'!R23","v":0},{"$f":"'Décompte 4me année'!R23","v":0},{"$f":"SUM(R23:U23)","v":0},{"$f":"Q23-V23","v":0}]
[null,null,"Autres charges de biens et services",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!U24","v":0},{"$f":"'Décompte 1ère année'!R24","v":0},{"$f":"'Décompte 2ème année'!R24","v":0},{"$f":"'Décompte 3ème année'!R24","v":0},{"$f":"'Décompte 4me année'!R24","v":0},{"$f":"SUM(R24:U24)","v":0},{"$f":"Q24-V24","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,{"$f":"SUM(Q20:Q24)","v":0},0,0,{"$f":"SUM(T20:T24)","v":0},0,{"$f":"SUM(V20:V24)","v":0},0]
[null,null,"Coûts d'infrastructure"]
[null,null,"Acquisitions/investissements",null,"Exemple : infrastructure de bureau",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!U27","v":0},{"$f":"'Décompte 1ère année'!R27","v":0},{"$f":"'Décompte 2ème année'!R27","v":0},{"$f":"'Décompte 3ème année'!R27","v":0},{"$f":"'Décompte 4me année'!R27","v":0},{"$f":"SUM(R27:U27)","v":0},{"$f":"Q27-V27","v":0}]
[null,null,"Location infrastructure",null,"Exemple : location des locaux",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!U28","v":0},{"$f":"'Décompte 1ère année'!R28","v":0},{"$f":"'Décompte 2ème année'!R28","v":0},{"$f":"'Décompte 3ème année'!R28","v":0},{"$f":"'Décompte 4me année'!R28","v":0},{"$f":"SUM(R28:U28)","v":0},{"$f":"Q28-V28","v":0}]
[null,null,"Entretien et réparations",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!U29","v":0},{"$f":"'Décompte 1ère année'!R29","v":0},{"$f":"'Décompte 2ème année'!R29","v":0},{"$f":"'Décompte 3ème année'!R29","v":0},{"$f":"'Décompte 4me année'!R29","v":0},{"$f":"SUM(R29:U29)","v":0},{"$f":"Q29-V29","v":0}]
[null,null,"Autres charges d'infrastructure",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!U30","v":0},{"$f":"'Décompte 1ère année'!R30","v":0},{"$f":"'Décompte 2ème année'!R30","v":0},{"$f":"'Décompte 3ème année'!R30","v":0},{"$f":"'Décompte 4me année'!R30","v":0},{"$f":"SUM(R30:U30)","v":0},{"$f":"Q30-V30","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,{"$f":"SUM(Q27:Q30)","v":0},0,0,{"$f":"SUM(T27:T30)","v":0},0,{"$f":"SUM(V27:V30)","v":0},0]
[null,null,"Coûts divers"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!U33","v":0},{"$f":"'Décompte 1ère année'!R33","v":0},{"$f":"'Décompte 2ème année'!R33","v":0},{"$f":"'Décompte 3ème année'!R33","v":0},{"$f":"'Décompte 4me année'!R33","v":0},{"$f":"SUM(R33:U33)","v":0},{"$f":"Q33-V33","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!U34","v":0},{"$f":"'Décompte 1ère année'!R34","v":0},{"$f":"'Décompte 2ème année'!R34","v":0},{"$f":"'Décompte 3ème année'!R34","v":0},{"$f":"'Décompte 4me année'!R34","v":0},{"$f":"SUM(R34:U34)","v":0},{"$f":"Q34-V34","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!U35","v":0},{"$f":"'Décompte 1ère année'!R35","v":0},{"$f":"'Décompte 2ème année'!R35","v":0},{"$f":"'Décompte 3ème année'!R35","v":0},{"$f":"'Décompte 4me année'!R35","v":0},{"$f":"SUM(R35:U35)","v":0},{"$f":"Q35-V35","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,{"$f":"SUM(Q33:Q35)","v":0},0,0,{"$f":"SUM(T33:T35)","v":0},{"$f":"SUM(U33:U35)","v":0},{"$f":"SUM(V33:V35)","v":0},0]
[null,null,"Coût total du projet",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q18+Q25+Q31+Q36","v":0},0,0,{"$f":"T18+T25+T31+T36","v":0},0,{"$f":"V18+V25+V31+V36","v":0},0]
[]
[]
[null,null,"Recettes du projet"]
[]
[null,null,"Type de recette",null,"Description",null,null,null,null,null,null,null,null,null,null,null,"Montant"]
[null,null,"Contribution Confédération",null,null,null,null,null,null,null,null,null,null,null,null,null,"Total recettes budgétisées","Année 1 recettes effectives","Année 2 recettes effectives","Année 3 recettes effectives","Année 4 recettes effectives","Total \nrecettes effectives","Différence"]
[null,null,"Contribution demandée SEM",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!U44","v":0},{"$f":"'Décompte 1ère année'!R44","v":0},{"$f":"'Décompte 2ème année'!R44","v":0},{"$f":"'Décompte 3ème année'!R44","v":0},{"$f":"'Décompte 4me année'!R44","v":0},{"$f":"SUM(R44:U44)","v":0},{"$f":"Q44-V44","v":0}]
[null,null,"Exemple : contribution autres offices fédéraux",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!U45","v":0},{"$f":"'Décompte 1ère année'!R45","v":0},{"$f":"'Décompte 2ème année'!R45","v":0},{"$f":"'Décompte 3ème année'!R45","v":0},{"$f":"'Décompte 4me année'!R45","v":0},{"$f":"SUM(R45:U45)","v":0},{"$f":"Q45-V45","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,{"$f":"SUM(Q44:Q45)","v":0},0,0,{"$f":"SUM(T44:T45)","v":0},{"$f":"SUM(U44:U45)","v":0},{"$f":"SUM(V44:V45)","v":0},0]
[null,null,"Contributions de tiers (y compris de cantons et communes)"]
[null,null,"Exemple : contribution allouée canton xy",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!U48","v":0},{"$f":"'Décompte 1ère année'!R48","v":0},{"$f":"'Décompte 2ème année'!R48","v":0},{"$f":"'Décompte 3ème année'!R48","v":0},{"$f":"'Décompte 4me année'!R48","v":0},{"$f":"SUM(R48:U48)","v":0},{"$f":"Q48-V48","v":0}]
[null,null,"Exemple : contribution ONG",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!U49","v":0},{"$f":"'Décompte 1ère année'!R49","v":0},{"$f":"'Décompte 2ème année'!R49","v":0},{"$f":"'Décompte 3ème année'!R49","v":0},{"$f":"'Décompte 4me année'!R49","v":0},{"$f":"SUM(R49:U49)","v":0},{"$f":"Q49-V49","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!U50","v":0},{"$f":"'Décompte 1ère année'!R50","v":0},{"$f":"'Décompte 2ème année'!R50","v":0},{"$f":"'Décompte 3ème année'!R50","v":0},{"$f":"'Décompte 4me année'!R50","v":0},{"$f":"SUM(R50:U50)","v":0},{"$f":"Q50-V50","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,{"$f":"SUM(Q48:R50)","v":0},{"$f":"SUM(R48:R50)","v":0},0,{"$f":"SUM(T48:T50)","v":0},{"$f":"SUM(U48:U50)","v":0},0,0]
[null,null,"Prestations propres"]
[null,null,"Contributions financières",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!U53","v":0},{"$f":"'Décompte 1ère année'!R53","v":0},{"$f":"'Décompte 2ème année'!R53","v":0},{"$f":"'Décompte 3ème année'!R53","v":0},{"$f":"'Décompte 4me année'!R53","v":0},{"$f":"SUM(R53:U53)","v":0},{"$f":"Q53-V53","v":0}]
[null,null,"Travail",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!U54","v":0},{"$f":"'Décompte 1ère année'!R54","v":0},{"$f":"'Décompte 2ème année'!R54","v":0},{"$f":"'Décompte 3ème année'!R54","v":0},{"$f":"'Décompte 4me année'!R54","v":0},{"$f":"SUM(R54:U54)","v":0},{"$f":"Q54-V54","v":0}]
[null,null,"Offres d'infrastructure",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!U55","v":0},{"$f":"'Décompte 1ère année'!R55","v":0},{"$f":"'Décompte 2ème année'!R55","v":0},{"$f":"'Décompte 3ème année'!R55","v":0},{"$f":"'Décompte 4me année'!R55","v":0},{"$f":"SUM(R55:U55)","v":0},{"$f":"Q55-V55","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,{"$f":"SUM(Q53:Q55)","v":0},0,0,{"$f":"SUM(T53:T55)","v":0},{"$f":"SUM(U53:U55)","v":0},0,0]
[null,null,"Recettes tirées d'activités liées au projet"]
[null,null,"Exemple : taxes de cours",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!U58","v":0},{"$f":"'Décompte 1ère année'!R58","v":0},{"$f":"'Décompte 2ème année'!R58","v":0},{"$f":"'Décompte 3ème année'!R58","v":0},{"$f":"'Décompte 4me année'!R58","v":0},{"$f":"SUM(R58:U58)","v":0},{"$f":"Q58-V58","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!U59","v":0},{"$f":"'Décompte 1ère année'!R59","v":0},{"$f":"'Décompte 2ème année'!R59","v":0},{"$f":"'Décompte 3ème année'!R59","v":0},{"$f":"'Décompte 4me année'!R59","v":0},{"$f":"SUM(R59:U59)","v":0},{"$f":"Q59-V59","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!U60","v":0},{"$f":"'Décompte 1ère année'!R60","v":0},{"$f":"'Décompte 2ème année'!R60","v":0},{"$f":"'Décompte 3ème année'!R60","v":0},{"$f":"'Décompte 4me année'!R60","v":0},{"$f":"SUM(R60:U60)","v":0},{"$f":"Q60-V60","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,{"$f":"SUM(Q58:Q60)","v":0},0,0,{"$f":"SUM(T58:T60)","v":0},{"$f":"SUM(U58:U60)","v":0},{"$f":"SUM(V58:V60)","v":0},0]
[null,null,"Total recettes pour le projet",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q46+Q51+Q56+Q61","v":0},0,0,{"$f":"T46+T51+T56+T61","v":0},{"$f":"U46+U51+U56+U61","v":0},{"$f":"V46+V51+V56+V61","v":0},0]
[]
[null,null,"Aperçu décompte fin du projet"]
[]
[null,null,"Total recettes effectives",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"V62","v":0}]
[null,null,"Total coûts effectifs",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"V37","v":0}]
[null,null,"Excédent/défaut de financement",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q66-Q67","v":0}]
[]
[null,null,"Part cofinancement en CHF",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"V51+V56+V61","v":0}]
[null,null,"Part cofinancement en %",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q70/Q67","v":{"$error":"#DIV/0!"}}]

{"sheet":"Décompte 4me année","index":6,"n_rows":71,"n_cols":19,"rows_kept":71,"cut":false,"hidden":false,"merged":[[1,12,1,19],[5,2,5,18],[6,2,6,4],[6,6,6,12],[6,14,6,19],[2,12,2,13],[3,12,3,13],[2,14,2,19],[3,14,3,19],[7,2,8,20],[9,2,9,19],[11,2,11,3],[11,4,11,15],[11,16,11,18],[12,2,12,3],[12,4,12,15],[13,2,13,3],[13,4,13,15],[14,2,14,3],[14,4,14,15],[15,2,15,3],[15,4,15,15],[16,2,16,3],[16,4,16,15],[17,13,17,14],[18,2,18,18],[19,2,19,3],[19,4,19,15],[20,2,20,3],[20,4,20,15],[21,2,21,3],[21,4,21,15],[22,2,22,3],[22,4,22,15],[23,2,23,3],[23,4,23,15],[24,13,24,14],[26,4,26,14],[27,4,27,14],[28,4,28,14],[29,4,29,14],[30,13,30,14],[31,2,31,18],[32,2,32,3],[32,4,32,15],[33,2,33,3],[33,4,33,15],[34,2,34,3],[34,4,34,15],[35,13,35,14],[39,2,39,18],[41,2,41,3],[41,4,41,14],[41,16,41,18],[42,2,42,14],[43,2,43,3],[43,4,43,15],[44,2,44,3],[44,4,44,15],[45,13,45,14],[46,2,46,18],[47,2,47,3],[47,4,47,15],[48,2,48,3],[48,4,48,15],[49,2,49,3],[49,4,49,15],[50,13,50,14],[51,2,51,14],[52,2,52,3],[52,4,52,14],[53,2,53,3],[53,4,53,14],[54,2,54,3],[54,4,54,14],[55,13,55,14],[56,2,56,18],[57,2,57,3],[57,4,57,15],[58,2,58,3],[58,4,58,15],[59,2,59,3],[59,4,59,15],[60,13,60,14],[61,2,61,14],[63,2,63,18],[65,2,65,15],[65,16,65,18],[66,2,66,15],[66,16,66,18],[67,2,67,15],[67,16,67,18],[69,2,69,15],[69,16,69,18],[70,2,70,15],[70,16,70,18],[71,2,71,6],[71,9,71,10],[71,13,71,14],[71,16,71,18]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Département fédéral de justice et police DFJP\nSecrétariat d'Etat aux migrations SEM\nDomaine de direction Immigration et intégration\nDivision Intégration"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Numéro de projet:",null,{"$f":"'Budget du projet et financement'!O3:V3","v":"Nr. "}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Division Intégration:",null,{"$f":"'Budget du projet et financement'!O4:V4","v":"Text"}]
[]
[null,null,"Décompte année de projet 4\nEncouragement de l'intégration par la Confédération - Programmes et projets d'importance nationale"]
[null,null,"Période de décompte\n(Date, par ex. 01.01.2021)",null,null,"du:",null,null,null,null,null,null,null,"au:"]
[null,null,"Merci de ne remplir que les champs à fond bleu. Excel calcule automatiquement les montants intermédiaires. Des lignes supplémentaires peuvent être ajoutées en cas de besoin (ctrl+u)."]
[]
[null,null,"Coûts totaux du projet"]
[]
[null,null,"Type de coût",null,"Description",null,null,null,null,null,null,null,null,null,null,null,"Montant"]
[null,null,"Coûts de personnel",null,"Indiquez la fonction, le taux d'occupation/heures de travail, salaire/tarif horaire. Inscrire sur des lignes séparées les personnes ou groupes de personnes ayant des tarifs horaires différents. ",null,null,null,null,null,null,null,null,null,null,null,"Coûts budgétisés","Coûts effectifs","Différence"]
[null,null,"Personne ou groupe 1",null,"Exemple : administrateur sans diplôme, tarif horaire CHF 80, total 1000 heures",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!R14","v":0},null,{"$f":"Q14-R14","v":0}]
[null,null,"Personne ou groupe 2",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!R15","v":0},null,{"$f":"Q15-R15","v":0}]
[null,null,"Prestations sociales",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!R16","v":0},null,{"$f":"Q16-R16","v":0}]
[null,null,"Frais et indemnisations",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!R17","v":0},null,{"$f":"Q17-R17","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,{"$f":"SUM(Q14:Q17)","v":0},{"$f":"SUM(R14:R17)","v":0},{"$f":"SUM(S14:S17)","v":0}]
[null,null,"Coûts de biens et services"]
[null,null,"Prestations de service externes",null,"Exemple : chargé de cours externe, tarif horaire CHF 120 incl. prestations sociales et TVA, total 200 heures",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!R20","v":0},null,{"$f":"Q20-R20","v":0}]
[null,null,"Publicité",null,"Exemple : brochure",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!R21","v":0},null,{"$f":"Q21-R21","v":0}]
[null,null,"Manifestations",null,"Exemple : location de la salle de cours",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!R22","v":0},null,{"$f":"Q22-R22","v":0}]
[null,null,"Matériel",null,"Exemple : matériel de cours",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!R23","v":0},null,{"$f":"Q23-R23","v":0}]
[null,null,"Autres charges de biens et services",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!R24","v":0},null,{"$f":"Q24-R24","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,{"$f":"SUM(Q20:Q24)","v":0},{"$f":"SUM(R20:R24)","v":0},{"$f":"SUM(S20:S24)","v":0}]
[null,null,"Coûts d'infrastructure"]
[null,null,"Acquisitions/investissements",null,"Exemple : infrastructure de bureau",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!R27","v":0},null,{"$f":"Q27-R27","v":0}]
[null,null,"Location infrastructure",null,"Exemple : location des locaux",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!R28","v":0},null,{"$f":"Q28-R28","v":0}]
[null,null,"Entretien et réparations",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!R29","v":0},null,{"$f":"Q29-R29","v":0}]
[null,null,"Autres charges d'infrastructure",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!R30","v":0},null,{"$f":"Q30-R30","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,{"$f":"SUM(Q27:Q30)","v":0},{"$f":"SUM(R27:R30)","v":0},{"$f":"SUM(S27:S30)","v":0}]
[null,null,"Coûts divers"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!R33","v":0},null,{"$f":"Q33-R33","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!R34","v":0},null,{"$f":"Q34-R34","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!R35","v":0},null,{"$f":"Q35-R35","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,{"$f":"SUM(Q33:Q35)","v":0},{"$f":"SUM(R33:R35)","v":0},{"$f":"SUM(S33:S35)","v":0}]
[null,null,"Coût total du projet",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q18+Q25+Q31+Q36","v":0},{"$f":"R18+R25+R31+R36","v":0},{"$f":"S18+S25+S31+S36","v":0}]
[]
[]
[null,null,"Recettes du projet"]
[]
[null,null,"Type de recette",null,"Description",null,null,null,null,null,null,null,null,null,null,null,"Montant"]
[null,null,"Contribution Confédération",null,null,null,null,null,null,null,null,null,null,null,null,null,"Recettes budgétisées","Recettes effectives","Différence"]
[null,null,"Contribution demandée SEM",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!R44","v":0},null,{"$f":"Q44-R44","v":0}]
[null,null,"Exemple : contribution autres office fédéraux",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!R45","v":0},null,{"$f":"Q45-R45","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,{"$f":"SUM(Q44:Q45)","v":0},{"$f":"SUM(R44:R45)","v":0},{"$f":"SUM(S44:S45)","v":0}]
[null,null,"Contributions de tiers (y compris de cantons et communes)"]
[null,null,"Exemple : contribution allouée canton xy",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!R48","v":0},null,{"$f":"Q48-R48","v":0}]
[null,null,"Exemple : contribution ONG",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!R49","v":0},null,{"$f":"Q49-R49","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!R50","v":0},null,{"$f":"Q50-R50","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,{"$f":"SUM(Q48:Q50)","v":0},{"$f":"SUM(R48:R50)","v":0},{"$f":"SUM(S48:S50)","v":0}]
[null,null,"Prestations propres"]
[null,null,"Contributions financières",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!R53","v":0},null,{"$f":"Q53-R53","v":0}]
[null,null,"Travail",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!R54","v":0},null,{"$f":"Q54-R54","v":0}]
[null,null,"Offres d'infrastructure",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!R55","v":0},null,{"$f":"Q55-R55","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,{"$f":"SUM(Q53:Q55)","v":0},{"$f":"SUM(R53:R55)","v":0},{"$f":"SUM(S53:S55)","v":0}]
[null,null,"Recettes tirées d'activités liées au projet"]
[null,null,"Exemple : taxes de cours",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!R58","v":0},null,{"$f":"Q58-R58","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!R59","v":0},null,{"$f":"Q59-R59","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget du projet et financement'!R60","v":0},null,{"$f":"Q60-R60","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,{"$f":"SUM(Q58:Q60)","v":0},{"$f":"SUM(R58:R60)","v":0},{"$f":"SUM(S58:S60)","v":0}]
[null,null,"Total recettes pour le projet",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q46+Q51+Q56+Q61","v":0},{"$f":"R46+R51+R56+R61","v":0},{"$f":"S46+S51+S56+S61","v":0}]
[]
[null,null,"Aperçu décompte année de projet 2"]
[]
[null,null,"Total recettes effectives",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R62","v":0}]
[null,null,"Total coûts effectifs",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R37","v":0}]
[null,null,"Excédent/défaut de financement",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q66-Q67","v":0}]
[]
[null,null,"Part cofinancement en CHF",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R51,R56,R61,)","v":0}]
[null,null,"Part cofinancement en %",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q70/Q67","v":{"$error":"#DIV/0!"}}]