{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Projektbudg. und Finanzierung","Abrechnung 1. Jahr","Abrechnung 2. Jahr","Abrechnung 3. Jahr","Abrechnung 4. Jahr","Abrechnung Projektabschluss"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":31,"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":"Projektbudg. und Finanzierung","index":0,"n_rows":71,"n_cols":21,"rows_kept":71,"cut":false,"hidden":false,"merged":[[2,12,2,14],[3,12,3,14],[2,15,2,21],[3,15,3,21],[49,2,49,3],[49,4,49,12],[57,2,57,3],[57,4,57,12],[50,13,50,15],[55,13,55,15],[53,2,53,3],[49,13,49,15],[54,13,54,15],[52,4,52,12],[53,4,53,12],[54,4,54,12],[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],[60,13,60,15],[63,2,63,20],[25,2,25,3],[31,2,31,3],[61,2,61,12],[29,4,29,15],[34,2,34,3],[34,4,34,15],[30,13,30,15],[35,13,35,15],[33,4,33,15],[29,2,29,3],[42,2,42,12],[41,2,41,3],[59,2,59,3],[59,4,59,12],[58,13,58,15],[46,2,46,12],[43,13,43,15],[45,13,45,15],[48,2,48,3],[47,4,47,12],[46,13,46,15],[47,13,47,15],[58,2,58,3],[58,4,58,12],[67,16,67,20],[70,16,70,20],[68,2,68,20],[41,16,41,20],[42,13,42,15],[71,16,71,20],[65,16,65,20],[69,16,69,20],[65,2,65,15],[52,2,52,3],[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],[59,13,59,15],[52,13,52,15],[53,13,53,15],[54,2,54,3],[56,2,56,12],[66,16,66,20],[51,2,51,12],[6,2,6,4],[41,4,41,12],[41,13,41,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],[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],[33,2,33,3],[32,4,32,15],[39,2,39,20],[1,12,1,20],[5,2,5,20],[6,6,6,11],[6,14,6,18],[7,2,8,21],[57,13,57,15],[51,13,51,20],[56,13,56,20],[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],[32,2,32,3],[9,2,9,20],[11,16,11,20],[11,2,11,3]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Eidgenössisches Justiz- und Polizeidepartement EJPD\nStaatssekretariat für Migration SEM\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,"Projektbudget und Finanzierung\nIntegrationsförderung des Bundes - Programme und Projekte von nationaler Bedeutung"]
[null,null,"Projektlaufzeit\n(Datum, z.B. 01.01.2021)",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, indem Sie eine Zeile markieren und ctrl+u drücken.\nWenn Sie Zeilen einfügen, müssen Sie diese auch bei den Abrechnungen einfügen."]
[]
[null,null,"Budgetierte 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,"Jahr 1","Jahr 2","Jahr 3","Jahr 4","Total"]
[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,null,null,null,null,{"$f":"SUM(Q14:T14)","v":0}]
[null,null,"Person oder Personengruppe 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,"Sozialleistungen",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,"Spesen und Vergütungen",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,"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,null,null,null,null,{"$f":"SUM(Q20:T20)","v":0}]
[null,null,"Werbung",null,"Beispiel: Broschüre",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q21:T21)","v":0}]
[null,null,"Veranstaltungen",null,"Beispiel: Miete Kursraum",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q22:T22)","v":0}]
[null,null,"Materialien",null,"Beispiel: Kursmaterial",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q23:T23)","v":0}]
[null,null,"Andere Sachkosten und Dienstleistungen",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,"Infrastrukturkosten"]
[null,null,"Anschaffungen/Investitionen",null,"Beispiel: Büroinfrastruktur",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q27:T27)","v":0}]
[null,null,"Miete Infrastruktur",null,"Beispiel: Miete Büroräumlichkeiten",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q28:T28)","v":0}]
[null,null,"Unterhalt und Reparaturen",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,"Andere Infrastrukturkosten",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,"Diverse Kosten"]
[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,"Total budgetierte 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},{"$f":"T18+T25+T31+T36","v":0},{"$f":"U18+U25+U31+U36","v":0}]
[]
[]
[null,null,"Budgetierte Einnahmen für das Projekt"]
[]
[null,null,"Einnahmeart",null,"Beschreibung",null,null,null,null,null,null,null,null,"Betrag"]
[null,null,"Subvention Bund",null,null,null,null,null,null,null,null,null,null,"Beitrag zugesichert\n(JA/NEIN)",null,null,"Jahr 1","Jahr 2","Jahr 3","Jahr 4","Total"]
[null,null,"Beantragter Beitrag 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,"Beispiel: Beitrag Bundesamt 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,"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,null,null,null,null,{"$f":"SUM(Q48:T48)","v":0}]
[null,null,"Beispiel: Beitrag NGO 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,"Eigenleistungen"]
[null,null,"Finanzielle Beiträge",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,"Arbeitsleistung",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,"Infrastrukturangebote",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,"Einnahmen aus projektbezogenen Aktivitäten"]
[null,null,"Beispiel: Kursgebühren",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 Einnahmen für das Projekt",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,"Übersicht Projektbudget und Finanzierung"]
[]
[null,null,"Total budgetierte Einnahmen für das Projekt",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U62","v":0}]
[null,null,"Total budgetierte Kosten für das Projekt",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U37","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(U51,U56,U61,)","v":0}]
[null,null,"Anteil Ko-Finanzierung in %",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q70/Q67","v":{"$error":"#DIV/0!"}}]

{"sheet":"Abrechnung 1. Jahr","index":1,"n_rows":71,"n_cols":19,"rows_kept":71,"cut":false,"hidden":false,"merged":[[12,2,12,3],[16,2,16,3],[22,2,22,3],[20,2,20,3],[11,4,11,15],[23,4,23,15],[26,4,26,15],[15,4,15,15],[49,4,49,15],[47,2,47,3],[46,2,46,18],[41,16,41,18],[41,4,41,14],[35,13,35,14],[50,13,50,14],[42,2,42,14],[2,12,2,14],[3,12,3,14],[2,16,2,19],[3,16,3,19],[6,14,6,19],[6,2,6,4],[34,2,34,3],[34,4,34,15],[30,13,30,14],[14,2,14,3],[14,4,14,15],[19,2,19,3],[19,4,19,15],[23,2,23,3],[21,2,21,3],[21,4,21,15],[1,12,1,18],[52,4,52,14],[53,4,53,14],[55,13,55,14],[15,2,15,3],[26,2,26,3],[5,2,5,18],[7,2,8,19],[9,2,9,18],[51,2,51,14],[27,4,27,15],[54,2,54,3],[11,16,11,18],[17,13,17,14],[24,13,24,14],[43,4,43,15],[44,2,44,3],[44,4,44,15],[31,2,31,18],[18,2,18,18],[25,2,25,18],[6,6,6,12],[13,2,13,3],[11,2,11,3],[70,16,70,18],[69,2,69,15],[16,4,16,15],[22,4,22,15],[20,4,20,15],[13,4,13,15],[32,2,32,3],[32,4,32,15],[33,2,33,3],[33,4,33,15],[39,2,39,18],[57,4,57,15],[28,2,28,3],[28,4,28,15],[29,2,29,3],[29,4,29,15],[56,2,56,18],[45,13,45,14],[43,2,43,3],[47,4,47,15],[48,2,48,3],[48,4,48,15],[49,2,49,3],[54,4,54,14],[61,2,61,14],[57,2,57,3],[12,4,12,15],[27,2,27,3],[63,2,63,18],[71,16,71,18],[65,2,65,15],[59,2,59,3],[41,2,41,3],[66,2,66,15],[67,2,67,15],[60,13,60,14],[59,4,59,15],[58,2,58,3],[58,4,58,15],[53,2,53,3],[70,2,70,15],[71,2,71,6],[71,9,71,10],[71,13,71,14],[65,16,65,18],[66,16,66,18],[67,16,67,18],[69,16,69,18]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Eidgenössisches Justiz- und Polizeidepartement EJPD\nStaatssekretariat für Migration SEM\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 1\nIntegrationsförderung des Bundes - Programme und Projekte von nationaler Bedeutung"]
[null,null,"Abrechnungszeitraum:\n(Datum, z.B. 01.01.2021)",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 (ctrl+u)."]
[]
[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":"'Projektbudg. und Finanzierung'!Q14","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":"'Projektbudg. und Finanzierung'!Q15","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":"'Projektbudg. und Finanzierung'!Q16","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":"'Projektbudg. und Finanzierung'!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,"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":"'Projektbudg. und Finanzierung'!Q20","v":0},null,{"$f":"Q20-R20","v":0}]
[null,null,"Werbung",null,"Beispiel: Broschüre",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Projektbudg. und Finanzierung'!Q21","v":0},null,{"$f":"Q21-R21","v":0}]
[null,null,"Veranstaltungen",null,"Beispiel: Miete Kursraum",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Projektbudg. und Finanzierung'!Q22","v":0},null,{"$f":"Q22-R22","v":0}]
[null,null,"Materialien",null,"Beispiel: Kursmaterial",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Projektbudg. und Finanzierung'!Q23","v":0},null,{"$f":"Q23-R23","v":0}]
[null,null,"Andere Sachkosten und Dienstleistungen",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Projektbudg. und Finanzierung'!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,"Infrastrukturkosten"]
[null,null,"Anschaffungen/Investitionen",null,"Beispiel: Büroinfrastruktur",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Projektbudg. und Finanzierung'!Q27","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":"'Projektbudg. und Finanzierung'!Q28","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":"'Projektbudg. und Finanzierung'!Q29","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":"'Projektbudg. und Finanzierung'!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,"Diverse Kosten"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Projektbudg. und Finanzierung'!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":"'Projektbudg. und Finanzierung'!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":"'Projektbudg. und Finanzierung'!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,"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 SEM",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Projektbudg. und Finanzierung'!Q44","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":"'Projektbudg. und Finanzierung'!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,"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":"'Projektbudg. und Finanzierung'!Q48","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":"'Projektbudg. und Finanzierung'!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":"'Projektbudg. und Finanzierung'!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,"Eigenleistungen"]
[null,null,"Finanzielle Beiträge",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Projektbudg. und Finanzierung'!Q53","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":"'Projektbudg. und Finanzierung'!Q54","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":"'Projektbudg. und Finanzierung'!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,"Einnahmen aus projektbezogenen Aktivitäten"]
[null,null,"Beispiel: Kursgebühren",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Projektbudg. und Finanzierung'!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":"'Projektbudg. und Finanzierung'!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":"'Projektbudg. und Finanzierung'!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 Einnahmen für das Projekt",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,"Übersicht Abrechnung Projektjahr 1"]
[]
[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":"Q70/Q67","v":{"$error":"#DIV/0!"}}]

{"sheet":"Abrechnung 2. Jahr","index":2,"n_rows":71,"n_cols":19,"rows_kept":71,"cut":false,"hidden":false,"merged":[[70,2,70,15],[70,16,70,18],[71,2,71,6],[71,9,71,10],[71,13,71,14],[71,16,71,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],[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],[55,13,55,14],[56,2,56,18],[57,2,57,3],[57,4,57,15],[58,2,58,3],[58,4,58,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],[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],[42,2,42,14],[43,2,43,3],[43,4,43,15],[44,2,44,3],[44,4,44,15],[45,13,45,14],[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],[30,13,30,14],[31,2,31,18],[32,2,32,3],[32,4,32,15],[33,2,33,3],[33,4,33,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],[23,2,23,3],[23,4,23,15],[24,13,24,14],[25,2,25,18],[26,2,26,3],[26,4,26,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],[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],[1,12,1,18],[5,2,5,18],[6,2,6,4],[6,6,6,12],[6,14,6,19],[2,12,2,14],[3,12,3,14],[2,16,2,19],[3,16,3,19]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Eidgenössisches Justiz- und Polizeidepartement EJPD\nStaatssekretariat für Migration SEM\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 2\nIntegrationsförderung des Bundes - Programme und Projekte von nationaler Bedeutung"]
[null,null,"Abrechnungszeitraum:\n(Datum, z.B. 01.01.2021)",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 (ctrl+u)."]
[]
[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":"'Projektbudg. und Finanzierung'!R14","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":"'Projektbudg. und Finanzierung'!R15","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":"'Projektbudg. und Finanzierung'!R16","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":"'Projektbudg. und Finanzierung'!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,"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":"'Projektbudg. und Finanzierung'!R20","v":0},null,{"$f":"Q20-R20","v":0}]
[null,null,"Werbung",null,"Beispiel: Broschüre",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Projektbudg. und Finanzierung'!R21","v":0},null,{"$f":"Q21-R21","v":0}]
[null,null,"Veranstaltungen",null,"Beispiel: Miete Kursraum",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Projektbudg. und Finanzierung'!R22","v":0},null,{"$f":"Q22-R22","v":0}]
[null,null,"Materialien",null,"Beispiel: Kursmaterial",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Projektbudg. und Finanzierung'!R23","v":0},null,{"$f":"Q23-R23","v":0}]
[null,null,"Andere Sachkosten und Dienstleistungen",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Projektbudg. und Finanzierung'!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,"Infrastrukturkosten"]
[null,null,"Anschaffungen/Investitionen",null,"Beispiel: Büroinfrastruktur",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Projektbudg. und Finanzierung'!R27","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":"'Projektbudg. und Finanzierung'!R28","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":"'Projektbudg. und Finanzierung'!R29","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":"'Projektbudg. und Finanzierung'!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,"Diverse Kosten"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Projektbudg. und Finanzierung'!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":"'Projektbudg. und Finanzierung'!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":"'Projektbudg. und Finanzierung'!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,"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 SEM",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Projektbudg. und Finanzierung'!R44","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":"'Projektbudg. und Finanzierung'!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,"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":"'Projektbudg. und Finanzierung'!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":"'Projektbudg. und Finanzierung'!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":"'Projektbudg. und Finanzierung'!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,"Eigenleistungen"]
[null,null,"Finanzielle Beiträge",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Projektbudg. und Finanzierung'!R53","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":"'Projektbudg. und Finanzierung'!R54","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":"'Projektbudg. und Finanzierung'!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,"Einnahmen aus projektbezogenen Aktivitäten"]
[null,null,"Beispiel: Kursgebühren",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Projektbudg. und Finanzierung'!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":"'Projektbudg. und Finanzierung'!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":"'Projektbudg. und Finanzierung'!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 Einnahmen für das Projekt",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,"Übersicht Abrechnung Projektjahr 2"]
[]
[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":"Q70/Q67","v":{"$error":"#DIV/0!"}}]

{"sheet":"Abrechnung 3. Jahr","index":3,"n_rows":71,"n_cols":19,"rows_kept":71,"cut":false,"hidden":false,"merged":[[70,2,70,15],[70,16,70,18],[71,2,71,6],[71,9,71,10],[71,13,71,14],[71,16,71,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],[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],[55,13,55,14],[56,2,56,18],[57,2,57,3],[57,4,57,15],[58,2,58,3],[58,4,58,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],[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],[42,2,42,14],[43,2,43,3],[43,4,43,15],[44,2,44,3],[44,4,44,15],[45,13,45,14],[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],[30,13,30,14],[31,2,31,18],[32,2,32,3],[32,4,32,15],[33,2,33,3],[33,4,33,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],[23,2,23,3],[23,4,23,15],[24,13,24,14],[25,2,25,18],[26,2,26,3],[26,4,26,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],[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],[1,12,1,18],[5,2,5,18],[6,2,6,4],[6,6,6,12],[6,14,6,19],[2,12,2,14],[3,12,3,14],[2,16,2,19],[3,16,3,19]]}
[]
[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.2021",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 (ctrl+u)."]
[]
[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":"'Projektbudg. und Finanzierung'!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":"'Projektbudg. und Finanzierung'!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":"'Projektbudg. und Finanzierung'!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":"'Projektbudg. und Finanzierung'!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":"'Projektbudg. und Finanzierung'!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":"'Projektbudg. und Finanzierung'!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":"'Projektbudg. und Finanzierung'!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":"'Projektbudg. und Finanzierung'!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":"'Projektbudg. und Finanzierung'!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":"'Projektbudg. und Finanzierung'!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":"'Projektbudg. und Finanzierung'!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":"'Projektbudg. und Finanzierung'!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":"'Projektbudg. und Finanzierung'!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":"'Projektbudg. und Finanzierung'!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":"'Projektbudg. und Finanzierung'!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":"'Projektbudg. und Finanzierung'!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":"'Projektbudg. und Finanzierung'!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":"'Projektbudg. und Finanzierung'!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":"'Projektbudg. und Finanzierung'!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":"'Projektbudg. und Finanzierung'!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":"'Projektbudg. und Finanzierung'!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:R50)","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":"'Projektbudg. und Finanzierung'!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":"'Projektbudg. und Finanzierung'!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":"'Projektbudg. und Finanzierung'!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":"'Projektbudg. und Finanzierung'!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":"'Projektbudg. und Finanzierung'!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":"'Projektbudg. und Finanzierung'!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":"R46+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":"Q70/Q67","v":{"$error":"#DIV/0!"}}]

{"sheet":"Abrechnung 4. Jahr","index":4,"n_rows":71,"n_cols":19,"rows_kept":71,"cut":false,"hidden":false,"merged":[[1,12,1,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],[2,12,2,14],[3,12,3,14],[2,16,2,19],[3,16,3,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],[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 4\nIntegrationsförderung des Bundes - Programme und Projekte von nationaler Bedeutung"]
[null,null,"Abrechnungszeitraum:\n(Datum, z.B. 01.01.2021)",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 (ctrl+u)."]
[]
[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":"'Projektbudg. und Finanzierung'!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":"'Projektbudg. und Finanzierung'!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":"'Projektbudg. und Finanzierung'!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":"'Projektbudg. und Finanzierung'!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":"'Projektbudg. und Finanzierung'!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":"'Projektbudg. und Finanzierung'!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":"'Projektbudg. und Finanzierung'!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":"'Projektbudg. und Finanzierung'!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":"'Projektbudg. und Finanzierung'!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":"'Projektbudg. und Finanzierung'!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":"'Projektbudg. und Finanzierung'!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":"'Projektbudg. und Finanzierung'!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":"'Projektbudg. und Finanzierung'!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":"'Projektbudg. und Finanzierung'!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":"'Projektbudg. und Finanzierung'!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":"'Projektbudg. und Finanzierung'!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":"'Projektbudg. und Finanzierung'!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":"'Projektbudg. und Finanzierung'!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":"'Projektbudg. und Finanzierung'!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":"'Projektbudg. und Finanzierung'!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":"'Projektbudg. und Finanzierung'!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:R50)","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":"'Projektbudg. und Finanzierung'!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":"'Projektbudg. und Finanzierung'!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":"'Projektbudg. und Finanzierung'!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":"'Projektbudg. und Finanzierung'!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":"'Projektbudg. und Finanzierung'!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":"'Projektbudg. und Finanzierung'!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":"R46+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":"Q70/Q67","v":{"$error":"#DIV/0!"}}]

{"sheet":"Abrechnung Projektabschluss","index":5,"n_rows":71,"n_cols":23,"rows_kept":71,"cut":false,"hidden":false,"merged":[[70,2,70,15],[70,16,70,22],[71,2,71,6],[71,9,71,10],[71,13,71,14],[71,16,71,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],[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],[55,13,55,14],[56,2,56,22],[57,2,57,3],[57,4,57,15],[58,2,58,3],[58,4,58,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],[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],[42,2,42,14],[43,2,43,3],[43,4,43,15],[44,2,44,3],[44,4,44,15],[45,13,45,14],[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],[30,13,30,14],[31,2,31,22],[32,2,32,3],[32,4,32,15],[33,2,33,3],[33,4,33,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],[23,2,23,3],[23,4,23,15],[24,13,24,14],[25,2,25,22],[26,2,26,3],[26,4,26,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,22],[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],[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],[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]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Eidgenössisches Justiz- und Polizeidepartement EJPD\nStaatssekretariat für Migration SEM\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 Projektabschluss\nIntegrationsförderung des Bundes - Programme und Projekte von nationaler Bedeutung"]
[null,null,"Abrechnungszeitraum:\n(Datum, z.B. 01.01.2021)",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 (ctrl+u)."]
[]
[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,"Total budgetierte Kosten","Jahr 1 effektive Kosten","Jahr 2 effektive Kosten","Jahr 3\neffektive Kosten","Jahr 4 effektive Kosten","Total 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":"'Projektbudg. und Finanzierung'!U14","v":0},{"$f":"'Abrechnung 1. Jahr'!R14","v":0},{"$f":"'Abrechnung 2. Jahr'!R14","v":0},{"$f":"'Abrechnung 3. Jahr'!R14","v":0},{"$f":"'Abrechnung 4. Jahr'!R14","v":0},{"$f":"SUM(R14:U14)","v":0},{"$f":"Q14-V14","v":0}]
[null,null,"Person oder Personengruppe 2",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Projektbudg. und Finanzierung'!U15","v":0},{"$f":"'Abrechnung 1. Jahr'!R15","v":0},{"$f":"'Abrechnung 2. Jahr'!R15","v":0},{"$f":"'Abrechnung 3. Jahr'!R15","v":0},{"$f":"'Abrechnung 4. Jahr'!R15","v":0},{"$f":"SUM(R15:U15)","v":0},{"$f":"Q15-V15","v":0}]
[null,null,"Sozialleistungen",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Projektbudg. und Finanzierung'!U16","v":0},{"$f":"'Abrechnung 1. Jahr'!R16","v":0},{"$f":"'Abrechnung 2. Jahr'!R16","v":0},{"$f":"'Abrechnung 3. Jahr'!R16","v":0},{"$f":"'Abrechnung 4. Jahr'!R16","v":0},{"$f":"SUM(R16:U16)","v":0},{"$f":"Q16-V16","v":0}]
[null,null,"Spesen und Vergütungen",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Projektbudg. und Finanzierung'!U17","v":0},{"$f":"'Abrechnung 1. Jahr'!R17","v":0},{"$f":"'Abrechnung 2. Jahr'!R17","v":0},{"$f":"'Abrechnung 3. Jahr'!R17","v":0},{"$f":"'Abrechnung 4. Jahr'!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},{"$f":"SUM(U14:U17)","v":0},{"$f":"SUM(V14:V17)","v":0},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":"'Projektbudg. und Finanzierung'!U20","v":0},{"$f":"'Abrechnung 1. Jahr'!R20","v":0},{"$f":"'Abrechnung 2. Jahr'!R20","v":0},{"$f":"'Abrechnung 3. Jahr'!R20","v":0},{"$f":"'Abrechnung 4. Jahr'!R20","v":0},{"$f":"SUM(R20:U20)","v":0},{"$f":"Q20-V20","v":0}]
[null,null,"Werbung",null,"Beispiel: Broschüre",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Projektbudg. und Finanzierung'!U21","v":0},{"$f":"'Abrechnung 1. Jahr'!R21","v":0},{"$f":"'Abrechnung 2. Jahr'!R21","v":0},{"$f":"'Abrechnung 3. Jahr'!R21","v":0},{"$f":"'Abrechnung 4. Jahr'!R21","v":0},{"$f":"SUM(R21:U21)","v":0},{"$f":"Q21-V21","v":0}]
[null,null,"Veranstaltungen",null,"Beispiel: Miete Kursraum",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Projektbudg. und Finanzierung'!U22","v":0},{"$f":"'Abrechnung 1. Jahr'!R22","v":0},{"$f":"'Abrechnung 2. Jahr'!R22","v":0},{"$f":"'Abrechnung 3. Jahr'!R22","v":0},{"$f":"'Abrechnung 4. Jahr'!R22","v":0},{"$f":"SUM(R22:U22)","v":0},{"$f":"Q22-V22","v":0}]
[null,null,"Materialien",null,"Beispiel: Kursmaterial",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Projektbudg. und Finanzierung'!U23","v":0},{"$f":"'Abrechnung 1. Jahr'!R23","v":0},{"$f":"'Abrechnung 2. Jahr'!R23","v":0},{"$f":"'Abrechnung 3. Jahr'!R23","v":0},{"$f":"'Abrechnung 4. Jahr'!R23","v":0},{"$f":"SUM(R23:U23)","v":0},{"$f":"Q23-V23","v":0}]
[null,null,"Andere Sachkosten und Dienstleistungen",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Projektbudg. und Finanzierung'!U24","v":0},{"$f":"'Abrechnung 1. Jahr'!R24","v":0},{"$f":"'Abrechnung 2. Jahr'!R24","v":0},{"$f":"'Abrechnung 3. Jahr'!R24","v":0},{"$f":"'Abrechnung 4. Jahr'!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},{"$f":"SUM(U20:U24)","v":0},{"$f":"SUM(V20:V24)","v":0},0]
[null,null,"Infrastrukturkosten"]
[null,null,"Anschaffungen/Investitionen",null,"Beispiel: Büroinfrastruktur",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Projektbudg. und Finanzierung'!U27","v":0},{"$f":"'Abrechnung 1. Jahr'!R27","v":0},{"$f":"'Abrechnung 2. Jahr'!R27","v":0},{"$f":"'Abrechnung 3. Jahr'!R27","v":0},{"$f":"'Abrechnung 4. Jahr'!R27","v":0},{"$f":"SUM(R27:U27)","v":0},{"$f":"Q27-V27","v":0}]
[null,null,"Miete Infrastruktur",null,"Beispiel: Miete Büroräumlichkeiten",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Projektbudg. und Finanzierung'!U28","v":0},{"$f":"'Abrechnung 1. Jahr'!R28","v":0},{"$f":"'Abrechnung 2. Jahr'!R28","v":0},{"$f":"'Abrechnung 3. Jahr'!R28","v":0},{"$f":"'Abrechnung 4. Jahr'!R28","v":0},{"$f":"SUM(R28:U28)","v":0},{"$f":"Q28-V28","v":0}]
[null,null,"Unterhalt und Reparaturen",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Projektbudg. und Finanzierung'!U29","v":0},{"$f":"'Abrechnung 1. Jahr'!R29","v":0},{"$f":"'Abrechnung 2. Jahr'!R29","v":0},{"$f":"'Abrechnung 3. Jahr'!R29","v":0},{"$f":"'Abrechnung 4. Jahr'!R29","v":0},{"$f":"SUM(R29:U29)","v":0},{"$f":"Q29-V29","v":0}]
[null,null,"Andere Infrastrukturkosten",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Projektbudg. und Finanzierung'!U30","v":0},{"$f":"'Abrechnung 1. Jahr'!R30","v":0},{"$f":"'Abrechnung 2. Jahr'!R30","v":0},{"$f":"'Abrechnung 3. Jahr'!R30","v":0},{"$f":"'Abrechnung 4. Jahr'!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},{"$f":"SUM(U27:U30)","v":0},{"$f":"SUM(V27:V30)","v":0},0]
[null,null,"Diverse Kosten"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Projektbudg. und Finanzierung'!U33","v":0},{"$f":"'Abrechnung 1. Jahr'!R33","v":0},{"$f":"'Abrechnung 2. Jahr'!R33","v":0},{"$f":"'Abrechnung 3. Jahr'!R33","v":0},{"$f":"'Abrechnung 4. Jahr'!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":"'Projektbudg. und Finanzierung'!U34","v":0},{"$f":"'Abrechnung 1. Jahr'!R34","v":0},{"$f":"'Abrechnung 2. Jahr'!R34","v":0},{"$f":"'Abrechnung 3. Jahr'!R34","v":0},{"$f":"'Abrechnung 4. Jahr'!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":"'Projektbudg. und Finanzierung'!U35","v":0},{"$f":"'Abrechnung 1. Jahr'!R35","v":0},{"$f":"'Abrechnung 2. Jahr'!R35","v":0},{"$f":"'Abrechnung 3. Jahr'!R35","v":0},{"$f":"'Abrechnung 4. Jahr'!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},0,{"$f":"SUM(V33:V35)","v":0},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},0,0,{"$f":"T18+T25+T31+T36","v":0},0,0,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,"Total Budgetierte Einnahmen","Jahr 1 Effektive Einnahmen","Jahr 2 Effektive Einnahmen","Jahr 3\nEffektive Einnahmen","Jahr 4 Effektive Einnahmen","Total Effektive Einnahmen","Differenz"]
[null,null,"Beantragter Beitrag SEM",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Projektbudg. und Finanzierung'!U44","v":0},{"$f":"'Abrechnung 1. Jahr'!R44","v":0},{"$f":"'Abrechnung 2. Jahr'!R44","v":0},{"$f":"'Abrechnung 3. Jahr'!R44","v":0},{"$f":"'Abrechnung 4. Jahr'!R44","v":0},{"$f":"SUM(R44:U44)","v":0},{"$f":"Q44-V44","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":"'Projektbudg. und Finanzierung'!U45","v":0},{"$f":"'Abrechnung 1. Jahr'!R45","v":0},{"$f":"'Abrechnung 2. Jahr'!R45","v":0},{"$f":"'Abrechnung 3. Jahr'!R45","v":0},{"$f":"'Abrechnung 4. Jahr'!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,"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":"'Projektbudg. und Finanzierung'!U48","v":0},{"$f":"'Abrechnung 1. Jahr'!R48","v":0},{"$f":"'Abrechnung 2. Jahr'!R48","v":0},{"$f":"'Abrechnung 3. Jahr'!R48","v":0},{"$f":"'Abrechnung 4. Jahr'!R48","v":0},{"$f":"SUM(R48:U48)","v":0},{"$f":"Q48-V48","v":0}]
[null,null,"Beispiel: Beitrag NGO",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Projektbudg. und Finanzierung'!U49","v":0},{"$f":"'Abrechnung 1. Jahr'!R49","v":0},{"$f":"'Abrechnung 2. Jahr'!R49","v":0},{"$f":"'Abrechnung 3. Jahr'!R49","v":0},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":"'Projektbudg. und Finanzierung'!U50","v":0},{"$f":"'Abrechnung 1. Jahr'!R50","v":0},{"$f":"'Abrechnung 2. Jahr'!R50","v":0},{"$f":"'Abrechnung 3. Jahr'!R50","v":0},{"$f":"'Abrechnung 4. Jahr'!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:Q50)","v":0},0,0,{"$f":"SUM(T48:T50)","v":0},0,{"$f":"SUM(V48:V50)","v":0},0]
[null,null,"Eigenleistungen"]
[null,null,"Finanzielle Beiträge",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Projektbudg. und Finanzierung'!U53","v":0},{"$f":"'Abrechnung 1. Jahr'!R53","v":0},{"$f":"'Abrechnung 2. Jahr'!R53","v":0},{"$f":"'Abrechnung 3. Jahr'!R53","v":0},{"$f":"'Abrechnung 4. Jahr'!R53","v":0},{"$f":"SUM(R53:U53)","v":0},{"$f":"Q53-V53","v":0}]
[null,null,"Arbeitsleistung",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Projektbudg. und Finanzierung'!U54","v":0},{"$f":"'Abrechnung 1. Jahr'!R54","v":0},{"$f":"'Abrechnung 2. Jahr'!R54","v":0},{"$f":"'Abrechnung 3. Jahr'!R54","v":0},{"$f":"'Abrechnung 4. Jahr'!R54","v":0},{"$f":"SUM(R54:U54)","v":0},{"$f":"Q54-V54","v":0}]
[null,null,"Infrastrukturangebote",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Projektbudg. und Finanzierung'!U55","v":0},{"$f":"'Abrechnung 1. Jahr'!R55","v":0},{"$f":"'Abrechnung 2. Jahr'!R55","v":0},{"$f":"'Abrechnung 3. Jahr'!R55","v":0},{"$f":"'Abrechnung 4. Jahr'!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},0,{"$f":"SUM(V53:V55)","v":0},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":"'Projektbudg. und Finanzierung'!U58","v":0},{"$f":"'Abrechnung 1. Jahr'!R58","v":0},{"$f":"'Abrechnung 2. Jahr'!R58","v":0},{"$f":"'Abrechnung 3. Jahr'!R58","v":0},{"$f":"'Abrechnung 4. Jahr'!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":"'Projektbudg. und Finanzierung'!U59","v":0},{"$f":"'Abrechnung 1. Jahr'!R59","v":0},{"$f":"'Abrechnung 2. Jahr'!R59","v":0},{"$f":"'Abrechnung 3. Jahr'!R59","v":0},{"$f":"'Abrechnung 4. Jahr'!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":"'Projektbudg. und Finanzierung'!U60","v":0},{"$f":"'Abrechnung 1. Jahr'!R60","v":0},{"$f":"'Abrechnung 2. Jahr'!R60","v":0},{"$f":"'Abrechnung 3. Jahr'!R60","v":0},{"$f":"'Abrechnung 4. Jahr'!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 Einnahmen für das Projekt",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,"Übersicht Abrechnung Projektabschluss"]
[]
[null,null,"Total effektive Einnahmen",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"V62","v":0}]
[null,null,"Total effektive Kosten",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"V37","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":"V51+V56+V61","v":0}]
[null,null,"Anteil Ko-Finanzierung in %",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q70/Q67","v":{"$error":"#DIV/0!"}}]