{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Sammelbescheinigung Seite 1","Sammelbescheinigung Seite 2","Sammelbescheinigung Seite 3","Einverständnis TN Version 1","Einverständnis TN Version 2"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":0,"defined_names":4,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sammelbescheinigung Seite 1","index":0,"n_rows":136,"n_cols":38,"rows_kept":136,"cut":false,"hidden":false,"merged":[[9,28,9,31],[10,22,11,22],[10,23,11,23],[9,37,11,40],[9,36,11,36],[1,0,1,19],[9,8,9,9],[9,1,11,1],[9,0,11,0],[9,2,9,3],[10,9,11,9],[10,15,11,15],[10,2,11,2],[10,12,11,12],[10,14,11,14],[4,0,4,1],[6,2,6,3],[4,2,4,3],[4,4,4,5],[4,8,4,40],[9,34,11,34],[5,0,5,1],[6,4,6,5],[5,4,5,5],[5,2,5,3],[10,19,11,19],[8,8,8,9],[10,6,11,6],[8,0,8,5],[6,8,6,9],[5,6,5,8],[9,18,9,19],[5,10,5,33],[8,18,8,32],[9,33,11,33],[10,29,11,29],[10,30,11,30],[122,5,122,7],[120,4,120,7],[122,10,122,11],[10,5,11,5],[45,0,45,3],[121,10,121,11],[121,6,121,7],[10,8,11,8],[38,0,39,1],[10,7,11,7],[43,2,43,37],[37,12,37,15],[9,35,11,35],[10,26,11,26],[9,32,11,32],[9,24,9,25],[38,12,38,15],[10,3,11,3],[10,4,11,4],[10,28,11,28],[9,11,9,15],[10,27,11,27],[9,17,11,17],[9,20,9,23],[9,16,11,16],[10,10,11,10],[10,18,11,18],[10,24,11,24],[10,25,11,25],[10,20,11,20],[10,21,11,21],[9,26,9,27],[12,37,12,40],[13,37,13,40],[14,37,14,40],[15,37,15,40],[16,37,16,40],[17,37,17,40],[18,37,18,40],[19,37,19,40],[20,37,20,40],[21,37,21,40],[22,37,22,40],[23,37,23,40],[24,37,24,40],[25,37,25,40],[26,37,26,40],[27,37,27,40],[28,37,28,40],[29,37,29,40],[30,37,30,40],[31,37,31,40],[32,37,32,40],[33,37,33,40],[34,37,34,40],[35,37,35,40],[36,37,36,40]]}
[0]
["Sammelbescheinigung zum Nachweis der Pauschale für Arbeitslosengeldleistungen"]
["Zur Abrechnung gegenüber der NBank:"]
[]
[{"$f":"IF(A2=\"Prüfung der Arbeitslosengeldleistungen (ALG I/ ALG II inkl. Sozialversicherungsbeiträge)\",\"\",\" Jobcenter/        \nAgentur für Arbeit:\")","v":" Jobcenter/        \nAgentur für Arbeit:"},null,null,null,"Förderprogramm:              ",null,null,"Richtlinie über die Gewährung von Zuwendungen zur Unterstützung Regionaler Fachkräftebündnisse durch Förderung von Fachkräfteprojekten für die Region 2021 - 2027","bitte auswählen"]
["Bildungseinrichtung:",null,null,null,"         Abrechnungszeitraum vom:   ",null,null,null,null,"bis:"]
[null,null,null,null,"  Antragsnummer NBank:       ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Zuwendungsbescheid NBank vom:  "]
[]
[{"$f":"IF(AN7>0,\"\",\"Bitte denken Sie daran, das Datum des NBank-Zuwendungsbescheides einzutragen.\")","v":"Bitte denken Sie daran, das Datum des NBank-Zuwendungsbescheides einzutragen."},null,null,null,null,null,"aus-blenden","Alt - Ausblenden","zu bestätigen vom Jobcenter/\nvon der Agentur für Arbeit",null,null,"ausblenden",null,"ausblenden",null,null,"ausblenden",null,"für  die Darstellung genutzte Berechungsfelder\n (ausblenden)"]
["lfd. \nNr. ","Bedarfsgemein-schaftsnummer/ \nKundennummer","Teilnehmende",null,"Beginn Teilnahme\n*1\n\n","ggf. Beendigung Teilnahme im  Zeitraum dieses Nachweises *1\n\n",null,"Bestätigung des Versicherungs-\nstatus","Bestätigung des Leistungsbezugs\n",null,null,"Ermittlung \nder\nAbrechnungsdaten",null,null,null,null,"Abrech-nungs-beginn","Pauschale","Pauschalberechnung\nallgemein\n",null,"ALTE FÖRDERPERIODE",null,null,null,"Sonderberechnung\nJugendwerkstätten",null,"Datum des\nZuwendungs-\nbescheides bestimmt die Pauschale (Q7)",null,"ALTE FÖRDERPERIODE",null,null,null,"Berechnung\nder \nPauschale","Pauschale","geltend gemacht gemäß Belegliste","Differenz\n\n(lediglich\n Kürzungen\n werden\n summiert)","Einheiten","Anmerkungen / Hinweise"]
[null,null,"Nachname","Vorname","Datum","Datum","Teiln.-Tage","(bitte auswählen)\n\nentfällt bei Jugendwerkstätten","von","bis","Tage",null,"Beginn",null,"Ende","Tage",null,null,"(familien-\nversichert)\nDatum 1","(familien-\nversichert)\nDatum 2","pflicht-\nvers bis\n30.06.11","pflicht-\nvers \nab 01.07.11","ALG I\nbis 30.06.11","ALG I\n01.07.11","Pauschal-satz bis\n30.06.11","Pauschal-satz ab\n01.07.11","\nversichert\nab XXX","\nversichert\n01.01.2016 bis XXX","pflicht-\nvers \nab 01.07.11","pflicht-\nvers\nbis 30.06.11 ","ALG I\n01.07.11","ALG I"]
[null,null,null,null,null,null,null,null,null,null,null,"Beg.-Ausw\nLeist <->Teiln",null,"Ende-Ausw\nLeist <->Teiln",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"bis 30.06.11"]
[1,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(I13>0,J13>0),DAYS360(I13,J13,TRUE)+1,0)","v":0},{"$f":"IF(I13>=E13,I13,E13)","v":"00:00:00"},{"$f":"IF($G$6>=L13,$G$6,L13)","v":"00:00:00"},{"$f":"IF(AND(F13=\"\",J13<>\"\"),J13,IF(J13<=F13,J13,F13))","v":"00:00:00"},{"$f":"IF($K$6<=N13,$K$6,N13)","v":"00:00:00"},{"$f":"IF(AND(M13=0,O13=0),0,IF(AND(MONTH(O13)=2,DAY(O13)=28,OR(YEAR(O13)=2022,YEAR(O13)=2023,YEAR(O13)=2025,YEAR(O13)=2026,YEAR(O13)=2027,YEAR(O13)=2029,YEAR(O13)*2030,YEAR(O13)*2031)),DAYS360(M13,O13,TRUE)+3,IF(AND(MONTH(O13)=2,DAY(O13)=29,OR(YEAR(O13)=2024,YEAR(O13)=2028,YEAR(O13)=2032)),DAYS360(M13,O13,TRUE)+2,DAYS360(M13,O13,TRUE)+1)))","v":0},{"$f":"IF(P13>I13,P13,I13)","v":"00:00:00"},{"$f":"SUM(S13:Z13)","v":0},{"$f":"IF(AND(O13<$F$123,H13=\"ALG II - familienversichert\",,$H$5<>\"Richtlinie über die Gewährung von Zuwendungen zur Förderung von Jugendwerkstätten\"),P13*($I$122/30),\"\")","v":""},{"$f":"IF(AND(O13>$G$122,H13=\"ALG II - familienversichert\",,$H$5<>\"Richtlinie über die Gewährung von Zuwendungen zur Förderung von Jugendwerkstätten\"),P13*($I$123/30),\"\")","v":""},{"$f":"IF(AND(O13<$F$123,H13=\"ALG II - pflichtversichert\"),P13*($K$122/30),\"\")","v":""},{"$f":"IF(AND(O13>$G$122,H13=\"ALG II - pflichtversichert\"),P13*($K$123/30),\"\")","v":""},{"$f":"IF(AND(O13<$F$123,H13=\"ALG I\"),P13*($K$122/30),\"\")","v":""},{"$f":"IF(AND(O13>$G$122,H13=\"ALG I\"),P13*($K$123/30),\"\")","v":""},{"$f":"IF(AND($AN$7<$F$123,$H$5=\"Richtlinie über die Gewährung von Zuwendungen zur Förderung von Jugendwerkstätten\"),$P13*($I$122/30),\"\")","v":""},{"$f":"IF(AND($AN$7>=$F$123,$H$5=\"Richtlinie über die Gewährung von Zuwendungen zur Förderung von Jugendwerkstätten\"),$P13*($I$123/30),\"\")","v":""},{"$f":"IF(AND($AN$7>=$F$123,$H13=\"ALG II - familienversichert\"),$P13*($I$123/30),\"\")","v":""},{"$f":"IF(AND($AN$7<$F$123,$H13=\"ALG II - familienversichert\"),$P13*($I$122/30),)","v":0},{"$f":"IF(AND($AN$7>=$F$123,$H13=\"ALG II - pflichtversichert\"),$P13*($K$123/30),\"\")","v":""},{"$f":"IF(AND($AN$7<$F$123,$H13=\"ALG II - pflichtversichert\"),$P13*($K$122/30),\"\")","v":""},{"$f":"IF(AND($AN$7>=$F$123,$H13=\"ALG I\"),$P13*($K$123/30),\"\")","v":""},{"$f":"IF(AND($AN$7<$F$123,$H13=\"ALG I\"),$P13*($K$122/30),\"\")","v":""},{"$f":"IF(OR($H$5=\"Richtlinie über die Gewährung von Zuwendungen zur Unterstützung Regionaler Fachkräftebündnisse durch Förderung von Fachkräfteprojekten für die Region 2021 - 2027\", $H$5=\"Richtlinie über die Gewährung von Zuwendungen zur Förderung von Regionalen Initiativen und Kooperationen für Frauen am Arbeitsmarkt (RIKA)\"),ROUND(1/30*P13,2)*(IF($AN$7>=$E$41,$F$41,$F$40)),0)","v":0},{"$f":"IF(AG13<0,0,AG13)","v":0},null,{"$f":"AH13-AI13","v":0},{"$f":"IF(P13>0,P13/30,0)","v":0}]
[{"$f":"A13+1","v":2},null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(I14>0,J14>0),DAYS360(I14,J14,TRUE)+1,0)","v":0},"00:00:00","00:00:00","00:00:00",{"$f":"IF($K$6<=N14,$K$6,N14)","v":"00:00:00"},{"$f":"IF(AND(M14=0,O14=0),0,IF(AND(MONTH(O14)=2,DAY(O14)=28,OR(YEAR(O14)=2022,YEAR(O14)=2023,YEAR(O14)=2025,YEAR(O14)=2026,YEAR(O14)=2027,YEAR(O14)=2029,YEAR(O14)*2030,YEAR(O14)*2031)),DAYS360(M14,O14,TRUE)+3,IF(AND(MONTH(O14)=2,DAY(O14)=29,OR(YEAR(O14)=2024,YEAR(O14)=2028,YEAR(O14)=2032)),DAYS360(M14,O14,TRUE)+2,DAYS360(M14,O14,TRUE)+1)))","v":0},"00:00:00",{"$f":"SUM(S14:Z14)","v":0},"","","","","","","","","",0,"","","","",{"$f":"IF(OR($H$5=\"Richtlinie über die Gewährung von Zuwendungen zur Unterstützung Regionaler Fachkräftebündnisse durch Förderung von Fachkräfteprojekten für die Region 2021 - 2027\", $H$5=\"Richtlinie über die Gewährung von Zuwendungen zur Förderung von Regionalen Initiativen und Kooperationen für Frauen am Arbeitsmarkt (RIKA)\"),ROUND(1/30*P14,2)*(IF($AN$7>=$E$41,$F$41,$F$40)),0)","v":0},{"$f":"IF(AG14<0,0,AG14)","v":0},null,{"$f":"AH14-AI14","v":0},{"$f":"IF(P14>0,P14/30,0)","v":0}]
[{"$f":"A14+1","v":3},null,null,null,null,null,null,null,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,"00:00:00",{"$f":"SUM(S15:Z15)","v":0},"","","","","","","","","",0,"","","","",0,0,null,0,0]
[4,null,null,null,null,null,null,null,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,"00:00:00",0,"","","","","","","","","",0,"","","","",0,0,null,0,0]
[5,null,null,null,null,null,null,null,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,"00:00:00",0,"","","","","","","","","",0,"","","","",0,0,null,0,0]
[6,null,null,null,null,null,null,null,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,"00:00:00",0,"","","","","","","","","",0,"","","","",0,0,null,0,0]
[7,null,null,null,null,null,null,null,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,"00:00:00",0,"","","","","","","","","",0,"","","","",0,0,null,0,0]
[8,null,null,null,null,null,null,null,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,"00:00:00",0,"","","","","","","","","",0,"","","","",0,0,null,0,0]
[9,null,null,null,null,null,null,null,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,"00:00:00",0,"","","","","","","","","",0,"","","","",0,0,null,0,0]
[10,null,null,null,null,null,null,null,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,"00:00:00",{"$f":"SUM(S22:Z22)","v":0},"","","","","","","","","",0,"","","","",0,{"$f":"IF(AG22<0,0,AG22)","v":0},null,0,0]
[11,null,null,null,null,null,null,null,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,"00:00:00",{"$f":"SUM(S23:Z23)","v":0},"","","","","","","","","",0,"","","","",0,{"$f":"IF(AG23<0,0,AG23)","v":0},null,0,0]
[12,null,null,null,null,null,null,null,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,"00:00:00",{"$f":"SUM(S24:Z24)","v":0},"","","","","","","","","",0,"","","","",0,{"$f":"IF(AG24<0,0,AG24)","v":0},null,0,0]
[13,null,null,null,null,null,null,null,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,"00:00:00",{"$f":"SUM(S25:Z25)","v":0},"","","","","","","","","",0,"","","","",0,{"$f":"IF(AG25<0,0,AG25)","v":0},null,0,0]
[14,null,null,null,null,null,null,null,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,"00:00:00",{"$f":"SUM(S26:Z26)","v":0},"","","","","","","","","",0,"","","","",0,{"$f":"IF(AG26<0,0,AG26)","v":0},null,0,0]
[15,null,null,null,null,null,null,null,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,"00:00:00",0,"","","","","","","","","",0,"","","","",0,0,null,0,0]
[16,null,null,null,null,null,null,null,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,"00:00:00",0,"","","","","","","","","",0,"","","","",0,0,null,0,0]
[17,null,null,null,null,null,null,null,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,"00:00:00",0,"","","","","","","","","",0,"","","","",0,0,null,0,0]
[18,null,null,null,null,null,null,null,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,"00:00:00",0,"","","","","","","","","",0,"","","","",0,0,null,0,0]
[19,null,null,null,null,null,null,null,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,"00:00:00",0,"","","","","","","","","",0,"","","","",0,0,null,0,0]
[20,null,null,null,null,null,null,null,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,"00:00:00",{"$f":"SUM(S32:Z32)","v":0},"","","","","","","","","",0,"","","","",0,0,null,0,0]
[21,null,null,null,null,null,null,null,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,"00:00:00",0,"","","","","","","","","",0,"","","","",0,0,null,0,0]
[22,null,null,null,null,null,null,null,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,"00:00:00",0,"","","","","","","","","",0,"","","","",0,0,null,0,0]
[23,null,null,null,null,null,{"$f":"IF(AND(E35>0,F35>0),DAYS360(E35,F35,TRUE)+1,0)","v":0},"ALG II - familienversichert",null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,"00:00:00",0,"","","","","","","","","",0,"","","","",0,0,null,0,0]
[24,null,null,null,null,null,0,"ALG II - familienversichert",null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,"00:00:00",0,"","","","","","","","","",0,"","","","",0,0,null,0,0]
[25,null,null,null,null,null,0,"ALG II - familienversichert",null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,"00:00:00",0,"","","","","","","","","",0,"","","","",0,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AH38=#REF!,\"Gesamtsumme:\",\"Zwischensumme\")","v":{"$error":"#REF!"}},null,null,null,"00:00:00",null,{"$f":"IF(AND(O38<$F$123,H38=\"familienversichert\"),P38*($I$122/30),\"\")","v":""},{"$f":"IF(AND(O38>$G$122,H38=\"familienversichert\"),P38*($I$123/30),\"\")","v":""},{"$f":"IF(AND(O38<$F$123,J38=\"pflichtversichert\"),P38*($K$122/30),\"\")","v":""},{"$f":"IF(AND(O38>$G$122,H38=\"pflichtversichert\"),P38*($K$123/30),\"\")","v":""},null,null,{"$f":"IF(AND($Q38<$G$122,$H$5=\"Richtlinie über die Gewährung von Zuwendungen zur Förderung von Jugendwerkstätten\"),#REF!*($I$122/30),\"\")","v":""},{"$f":"IF(AND($Q38>$G$122,$H$5=\"Richtlinie über die Gewährung von Zuwendungen zur Förderung von Jugendwerkstätten\"),#REF!*($I$123/30),\"\")","v":""},{"$f":"IF(AND($AN$7>$G$123,$H38=\"familienversichert\"),P38*($I$122/30),\"\")","v":""},null,{"$f":"IF(AND($AN$7>$G$123,$H38=\"pflichtversichert\"),$P38*($K$122/30),\"\")","v":""},{"$f":"IF(AND($AN$7>$G$123,$H38=\"pflichtversichert\"),$P38*($K$122/30),\"\")","v":""},null,null,{"$f":"SUMIF(AG13:AG37,\">0\",AG13:AG37)","v":0},{"$f":"SUM(AH13:AH37)","v":0},{"$f":"SUM(AI13:AI37)","v":0},{"$f":"SUM(AJ13:AJ37)","v":0},{"$f":"SUMPRODUCT((ROUND(AK13:AK37,2))*1)","v":0}]
[null,null,"Erläuterungen:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AG38)","v":0}]
[null,null,"  Standardeinheitskostensatz:",null,"2022-03-02",432]
[null,null,null,null,"2024-11-01",489]
[]
[]
[null,null,"     *1 Gegenüber der NBank dürfen nur Zeiträume abgerechnet werden, in denen die oben genannten Personen an der Maßnahme teilgenommen haben\n   *2 Zeiten vor Beginn oder nach Ende der Maßnahme dürfen nicht angegeben werden"]
[]
["Datum,  Stempel  /  Unterschrift des Jobcenters/der Agentur für Arbeit"]
[]
[]
[]
[]
[]
[]
[]
["Sammelbescheinigung zum Nachweis der Pauschale für Arbeitslosengeldleistungen"]
["Prüfung der Arbeitslosengeldleistungen"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Zeitraum",null,null,null,"Familienversicherte",null,"Pflichtversicherte"]
[null,null,null,"Pauschalbetrag","1)","2016-01-01","2020-12-31",null,432,null,386]
[null,null,null,null,"2)","2020-01-01",null,null,432,null,386]
[]
[]
["bitte auswählen"]
["Richtlinie über die Gewährung von Zuwendungen zur Unterstützung Regionaler Fachkräftebündnisse durch Förderung von Fachkräfteprojekten für die Region 2021 - 2027"]
["Richtlinie über die Gewährung von Zuwendungen zur Förderung von Regionalen Initiativen und Kooperationen für Frauen am Arbeitsmarkt (RIKA)"]
["Richtlinie über die Gewährung von Zuwendungen zur Förderung von innovativen Bildungsprojekten der beruflichen Erstausbildung"]
[]
[]
[]
[]
["ALG II - familienversichert"]
["ALG II - pflichtversichert"]
["ALG I"]

{"sheet":"Sammelbescheinigung Seite 2","index":1,"n_rows":136,"n_cols":40,"rows_kept":136,"cut":false,"hidden":false,"merged":[[121,6,121,7],[121,10,121,11],[122,5,122,7],[122,10,122,11],[37,12,37,15],[38,0,39,1],[38,12,38,15],[43,2,43,37],[45,0,45,3],[120,4,120,7],[36,37,36,40],[25,37,25,40],[26,37,26,40],[27,37,27,40],[28,37,28,40],[29,37,29,40],[30,37,30,40],[31,37,31,40],[32,37,32,40],[33,37,33,40],[34,37,34,40],[35,37,35,40],[24,37,24,40],[13,37,13,40],[14,37,14,40],[15,37,15,40],[16,37,16,40],[17,37,17,40],[18,37,18,40],[19,37,19,40],[20,37,20,40],[21,37,21,40],[22,37,22,40],[23,37,23,40],[12,37,12,40],[10,14,11,14],[10,15,11,15],[10,18,11,18],[10,19,11,19],[10,20,11,20],[10,21,11,21],[10,26,11,26],[10,27,11,27],[10,28,11,28],[10,29,11,29],[10,30,11,30],[9,16,11,16],[9,32,11,32],[9,34,11,34],[9,35,11,35],[9,37,11,40],[9,17,11,17],[9,18,9,19],[9,20,9,23],[9,24,9,25],[9,26,9,27],[9,28,9,31],[10,22,11,22],[10,23,11,23],[10,24,11,24],[10,25,11,25],[9,0,11,0],[9,1,11,1],[9,2,9,3],[9,8,9,9],[9,11,9,15],[10,2,11,2],[10,3,11,3],[10,4,11,4],[10,5,11,5],[10,12,11,12],[10,6,11,6],[10,7,11,7],[10,8,11,8],[10,9,11,9],[10,10,11,10],[8,18,8,32],[1,0,1,19],[4,0,4,1],[4,2,4,3],[4,4,4,5],[4,8,4,40],[5,0,5,1],[5,2,5,3],[5,4,5,5],[5,6,5,8],[5,10,5,33],[6,2,6,3],[6,4,6,5],[6,8,6,9],[8,0,8,5],[8,8,8,9]]}
[0]
["Sammelbescheinigung zum Nachweis der Pauschale für Arbeitslosengeldleistungen"]
["Zur Abrechnung gegenüber der NBank:"]
[]
[{"$f":"IF(A2=\"Prüfung der Arbeitslosengeldleistungen (ALG I/ ALG II inkl. Sozialversicherungsbeiträge)\",\"\",\" Jobcenter/        \nAgentur für Arbeit:\")","v":" Jobcenter/        \nAgentur für Arbeit:"},null,{"$f":"IF('Sammelbescheinigung Seite 1'!C5:D5=\"\",\"\",'Sammelbescheinigung Seite 1'!C5:D5)","v":""},null,"Förderprogramm:              ",null,null,"Richtlinie über die Gewährung von Zuwendungen zur Unterstützung Regionaler Fachkräftebündnisse durch Förderung von Fachkräfteprojekten für die Region 2021 - 2027",{"$f":"IF('Sammelbescheinigung Seite 1'!I5:AO5=\"bitte auswählen\",\"bitte auf erster Seite auswählen\",'Sammelbescheinigung Seite 1'!I5:AO5)","v":"bitte auf erster Seite auswählen"}]
["Bildungseinrichtung:",null,{"$f":"IF('Sammelbescheinigung Seite 1'!C6:D6=\"\",\"\",'Sammelbescheinigung Seite 1'!C6:D6)","v":""},null,"         Abrechnungszeitraum vom:   ",null,{"$f":"'Sammelbescheinigung Seite 1'!G6:I6","v":"00:00:00"},null,null,"bis:",{"$f":"'Sammelbescheinigung Seite 1'!K6:AH6","v":"00:00:00"}]
[null,null,null,null,"  Antragsnummer NBank:       ",null,null,null,{"$f":"IF('Sammelbescheinigung Seite 1'!I7:J7=\"\",\"\",'Sammelbescheinigung Seite 1'!I7:J7)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Zuwendungsbescheid NBank vom:  ",null,null,null,null,null,{"$f":"'Sammelbescheinigung Seite 1'!AN7","v":"00:00:00"}]
[]
[null,null,null,null,null,null,"aus-blenden","Alt - Ausblenden","zu bestätigen vom Jobcenter/\nvon der Agentur für Arbeit",null,null,"ausblenden",null,"ausblenden",null,null,"ausblenden",null,"für  die Darstellung genutzte Berechungsfelder\n (ausblenden)"]
["lfd. \nNr. ","Bedarfsgemein-schaftsnummer/ \nKundennummer","Teilnehmende",null,"Beginn Teilnahme\n*1\n\n","ggf. Beendigung Teilnahme im  Zeitraum dieses Nachweises *1\n\n",null,"Bestätigung des Versicherungs-\nstatus","Bestätigung des Leistungsbezugs\n",null,null,"Ermittlung \nder\nAbrechnungsdaten",null,null,null,null,"Abrech-nungs-beginn","Pauschale","Pauschalberechnung\nallgemein\n",null,"ALTE FÖRDERPERIODE",null,null,null,"Sonderberechnung\nJugendwerkstätten",null,"Datum des\nZuwendungs-\nbescheides bestimmt die Pauschale (Q7)",null,"ALTE FÖRDERPERIODE",null,null,null,"Berechnung\nder \nPauschale","Pauschale","geltend gemacht gemäß Belegliste","Differenz\n\n(lediglich\n Kürzungen\n werden\n summiert)","Einheiten","Anmerkungen / Hinweise"]
[null,null,"Nachname","Vorname","Datum","Datum","Teiln.-Tage","(bitte auswählen)\n\nentfällt bei Jugendwerkstätten","von","bis","Tage",null,"Beginn",null,"Ende","Tage",null,null,"(familien-\nversichert)\nDatum 1","(familien-\nversichert)\nDatum 2","pflicht-\nvers bis\n30.06.11","pflicht-\nvers \nab 01.07.11","ALG I\nbis 30.06.11","ALG I\n01.07.11","Pauschal-satz bis\n30.06.11","Pauschal-satz ab\n01.07.11","\nversichert\nab XXX","\nversichert\n01.01.2016 bis XXX","pflicht-\nvers \nab 01.07.11","pflicht-\nvers\nbis 30.06.11 ","ALG I\n01.07.11","ALG I",null,"Übertrag Seite 1:",null,null,"Übertrag Seite 1:"]
[null,null,null,null,null,null,null,null,null,null,null,"Beg.-Ausw\nLeist <->Teiln",null,"Ende-Ausw\nLeist <->Teiln",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"bis 30.06.11",null,{"$f":"'Sammelbescheinigung Seite 1'!AH38","v":0},null,null,{"$f":"'Sammelbescheinigung Seite 1'!AK38","v":0}]
[26,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(I13>0,J13>0),DAYS360(I13,J13,TRUE)+1,0)","v":0},{"$f":"IF(I13>=E13,I13,E13)","v":"00:00:00"},{"$f":"IF($G$6>=L13,$G$6,L13)","v":"00:00:00"},{"$f":"IF(AND(F13=\"\",J13<>\"\"),J13,IF(J13<=F13,J13,F13))","v":"00:00:00"},{"$f":"IF($K$6<=N13,$K$6,N13)","v":"00:00:00"},{"$f":"IF(AND(M13=0,O13=0),0,IF(AND(MONTH(O13)=2,DAY(O13)=28,OR(YEAR(O13)=2022,YEAR(O13)=2023,YEAR(O13)=2025,YEAR(O13)=2026,YEAR(O13)=2027,YEAR(O13)=2029,YEAR(O13)*2030,YEAR(O13)*2031)),DAYS360(M13,O13,TRUE)+3,IF(AND(MONTH(O13)=2,DAY(O13)=29,OR(YEAR(O13)=2024,YEAR(O13)=2028,YEAR(O13)=2032)),DAYS360(M13,O13,TRUE)+2,DAYS360(M13,O13,TRUE)+1)))","v":0},{"$f":"IF(P13>I13,P13,I13)","v":"00:00:00"},{"$f":"SUM(S13:Z13)","v":0},{"$f":"IF(AND(O13<$F$123,H13=\"ALG II - familienversichert\",,$H$5<>\"Richtlinie über die Gewährung von Zuwendungen zur Förderung von Jugendwerkstätten\"),P13*($I$122/30),\"\")","v":""},{"$f":"IF(AND(O13>$G$122,H13=\"ALG II - familienversichert\",,$H$5<>\"Richtlinie über die Gewährung von Zuwendungen zur Förderung von Jugendwerkstätten\"),P13*($I$123/30),\"\")","v":""},{"$f":"IF(AND(O13<$F$123,H13=\"ALG II - pflichtversichert\"),P13*($K$122/30),\"\")","v":""},{"$f":"IF(AND(O13>$G$122,H13=\"ALG II - pflichtversichert\"),P13*($K$123/30),\"\")","v":""},{"$f":"IF(AND(O13<$F$123,H13=\"ALG I\"),P13*($K$122/30),\"\")","v":""},{"$f":"IF(AND(O13>$G$122,H13=\"ALG I\"),P13*($K$123/30),\"\")","v":""},{"$f":"IF(AND($AN$7<$F$123,$H$5=\"Richtlinie über die Gewährung von Zuwendungen zur Förderung von Jugendwerkstätten\"),$P13*($I$122/30),\"\")","v":""},{"$f":"IF(AND($AN$7>=$F$123,$H$5=\"Richtlinie über die Gewährung von Zuwendungen zur Förderung von Jugendwerkstätten\"),$P13*($I$123/30),\"\")","v":""},{"$f":"IF(AND($AN$7>=$F$123,$H13=\"ALG II - familienversichert\"),$P13*($I$123/30),\"\")","v":""},{"$f":"IF(AND($AN$7<$F$123,$H13=\"ALG II - familienversichert\"),$P13*($I$122/30),)","v":0},{"$f":"IF(AND($AN$7>=$F$123,$H13=\"ALG II - pflichtversichert\"),$P13*($K$123/30),\"\")","v":""},{"$f":"IF(AND($AN$7<$F$123,$H13=\"ALG II - pflichtversichert\"),$P13*($K$122/30),\"\")","v":""},{"$f":"IF(AND($AN$7>=$F$123,$H13=\"ALG I\"),$P13*($K$123/30),\"\")","v":""},{"$f":"IF(AND($AN$7<$F$123,$H13=\"ALG I\"),$P13*($K$122/30),\"\")","v":""},{"$f":"IF(OR($H$5=\"Richtlinie über die Gewährung von Zuwendungen zur Unterstützung Regionaler Fachkräftebündnisse durch Förderung von Fachkräfteprojekten für die Region 2021 - 2027\", $H$5=\"Richtlinie über die Gewährung von Zuwendungen zur Förderung von Regionalen Initiativen und Kooperationen für Frauen am Arbeitsmarkt (RIKA)\"),ROUND(1/30*P13,2)*(IF($AN$7>=$E$41,$F$41,$F$40)),0)","v":0},{"$f":"IF(AG13<0,0,AG13)","v":0},null,{"$f":"AH13-AI13","v":0},{"$f":"IF(P13>0,P13/30,0)","v":0}]
[27,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(I14>0,J14>0),DAYS360(I14,J14,TRUE)+1,0)","v":0},"00:00:00","00:00:00","00:00:00",{"$f":"IF($K$6<=N14,$K$6,N14)","v":"00:00:00"},{"$f":"IF(AND(M14=0,O14=0),0,IF(AND(MONTH(O14)=2,DAY(O14)=28,OR(YEAR(O14)=2022,YEAR(O14)=2023,YEAR(O14)=2025,YEAR(O14)=2026,YEAR(O14)=2027,YEAR(O14)=2029,YEAR(O14)*2030,YEAR(O14)*2031)),DAYS360(M14,O14,TRUE)+3,IF(AND(MONTH(O14)=2,DAY(O14)=29,OR(YEAR(O14)=2024,YEAR(O14)=2028,YEAR(O14)=2032)),DAYS360(M14,O14,TRUE)+2,DAYS360(M14,O14,TRUE)+1)))","v":0},"00:00:00",{"$f":"SUM(S14:Z14)","v":0},"","","","","","","","","",0,"","","","",{"$f":"IF(OR($H$5=\"Richtlinie über die Gewährung von Zuwendungen zur Unterstützung Regionaler Fachkräftebündnisse durch Förderung von Fachkräfteprojekten für die Region 2021 - 2027\", $H$5=\"Richtlinie über die Gewährung von Zuwendungen zur Förderung von Regionalen Initiativen und Kooperationen für Frauen am Arbeitsmarkt (RIKA)\"),ROUND(1/30*P14,2)*(IF($AN$7>=$E$41,$F$41,$F$40)),0)","v":0},{"$f":"IF(AG14<0,0,AG14)","v":0},null,{"$f":"AH14-AI14","v":0},{"$f":"IF(P14>0,P14/30,0)","v":0}]
[28,null,null,null,null,null,null,null,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,"00:00:00",{"$f":"SUM(S15:Z15)","v":0},"","","","","","","","","",0,"","","","",0,0,null,0,0]
[29,null,null,null,null,null,null,null,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,"00:00:00",0,"","","","","","","","","",0,"","","","",0,0,null,0,0]
[30,null,null,null,null,null,null,null,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,"00:00:00",0,"","","","","","","","","",0,"","","","",0,0,null,0,0]
[31,null,null,null,null,null,null,null,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,"00:00:00",0,"","","","","","","","","",0,"","","","",0,0,null,0,0]
[32,null,null,null,null,null,null,null,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,"00:00:00",0,"","","","","","","","","",0,"","","","",0,0,null,0,0]
[33,null,null,null,null,null,null,null,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,"00:00:00",0,"","","","","","","","","",0,"","","","",0,0,null,0,0]
[34,null,null,null,null,null,null,null,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,"00:00:00",0,"","","","","","","","","",0,"","","","",0,0,null,0,0]
[35,null,null,null,null,null,null,null,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,"00:00:00",{"$f":"SUM(S22:Z22)","v":0},"","","","","","","","","",0,"","","","",0,{"$f":"IF(AG22<0,0,AG22)","v":0},null,0,0]
[36,null,null,null,null,null,null,null,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,"00:00:00",{"$f":"SUM(S23:Z23)","v":0},"","","","","","","","","",0,"","","","",0,{"$f":"IF(AG23<0,0,AG23)","v":0},null,0,0]
[37,null,null,null,null,null,null,null,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,"00:00:00",{"$f":"SUM(S24:Z24)","v":0},"","","","","","","","","",0,"","","","",0,{"$f":"IF(AG24<0,0,AG24)","v":0},null,0,0]
[38,null,null,null,null,null,null,null,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,"00:00:00",{"$f":"SUM(S25:Z25)","v":0},"","","","","","","","","",0,"","","","",0,{"$f":"IF(AG25<0,0,AG25)","v":0},null,0,0]
[39,null,null,null,null,null,null,null,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,"00:00:00",{"$f":"SUM(S26:Z26)","v":0},"","","","","","","","","",0,"","","","",0,{"$f":"IF(AG26<0,0,AG26)","v":0},null,0,0]
[40,null,null,null,null,null,null,null,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,"00:00:00",0,"","","","","","","","","",0,"","","","",0,0,null,0,0]
[41,null,null,null,null,null,null,null,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,"00:00:00",0,"","","","","","","","","",0,"","","","",0,0,null,0,0]
[42,null,null,null,null,null,null,null,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,"00:00:00",0,"","","","","","","","","",0,"","","","",0,0,null,0,0]
[43,null,null,null,null,null,null,null,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,"00:00:00",0,"","","","","","","","","",0,"","","","",0,0,null,0,0]
[44,null,null,null,null,null,null,null,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,"00:00:00",0,"","","","","","","","","",0,"","","","",0,0,null,0,0]
[45,null,null,null,null,null,null,null,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,"00:00:00",{"$f":"SUM(S32:Z32)","v":0},"","","","","","","","","",0,"","","","",0,0,null,0,0]
[46,null,null,null,null,null,null,null,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,"00:00:00",0,"","","","","","","","","",0,"","","","",0,0,null,0,0]
[47,null,null,null,null,null,null,null,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,"00:00:00",0,"","","","","","","","","",0,"","","","",0,0,null,0,0]
[48,null,null,null,null,null,{"$f":"IF(AND(E35>0,F35>0),DAYS360(E35,F35,TRUE)+1,0)","v":0},"ALG II - familienversichert",null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,"00:00:00",0,"","","","","","","","","",0,"","","","",0,0,null,0,0]
[49,null,null,null,null,null,0,"ALG II - familienversichert",null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,"00:00:00",0,"","","","","","","","","",0,"","","","",0,0,null,0,0]
[50,null,null,null,null,null,0,"ALG II - familienversichert",null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,"00:00:00",0,"","","","","","","","","",0,"","","","",0,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AH38=#REF!,\"Gesamtsumme:\",\"Zwischensumme\")","v":{"$error":"#REF!"}},null,null,null,"00:00:00",null,{"$f":"IF(AND(O38<$F$123,H38=\"familienversichert\"),P38*($I$122/30),\"\")","v":""},{"$f":"IF(AND(O38>$G$122,H38=\"familienversichert\"),P38*($I$123/30),\"\")","v":""},{"$f":"IF(AND(O38<$F$123,J38=\"pflichtversichert\"),P38*($K$122/30),\"\")","v":""},{"$f":"IF(AND(O38>$G$122,H38=\"pflichtversichert\"),P38*($K$123/30),\"\")","v":""},null,null,{"$f":"IF(AND($Q38<$G$122,$H$5=\"Richtlinie über die Gewährung von Zuwendungen zur Förderung von Jugendwerkstätten\"),#REF!*($I$122/30),\"\")","v":""},{"$f":"IF(AND($Q38>$G$122,$H$5=\"Richtlinie über die Gewährung von Zuwendungen zur Förderung von Jugendwerkstätten\"),#REF!*($I$123/30),\"\")","v":""},{"$f":"IF(AND($AN$7>$G$123,$H38=\"familienversichert\"),P38*($I$122/30),\"\")","v":""},null,{"$f":"IF(AND($AN$7>$G$123,$H38=\"pflichtversichert\"),$P38*($K$122/30),\"\")","v":""},{"$f":"IF(AND($AN$7>$G$123,$H38=\"pflichtversichert\"),$P38*($K$122/30),\"\")","v":""},null,null,{"$f":"SUMIF(AG13:AG37,\">0\",AG13:AG37)","v":0},{"$f":"SUM(AH12:AH37)","v":0},{"$f":"SUM(AI13:AI37)","v":0},{"$f":"SUM(AJ13:AJ37)","v":0},{"$f":"SUMPRODUCT((ROUND(AK12:AK37,2))*1)","v":0}]
[null,null,"Erläuterungen:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AG38)","v":0}]
[null,null,"  Standardeinheitskostensatz:",null,{"$f":"'Sammelbescheinigung Seite 1'!E40","v":"2022-03-02"},432]
[null,null,null,null,{"$f":"'Sammelbescheinigung Seite 1'!E41","v":"2024-11-01"},489]
[]
[]
[null,null,"     *1 Gegenüber der NBank dürfen nur Zeiträume abgerechnet werden, in denen die oben genannten Personen an der Maßnahme teilgenommen haben\n   *2 Zeiten vor Beginn oder nach Ende der Maßnahme dürfen nicht angegeben werden"]
[]
["Datum,  Stempel  /  Unterschrift des Jobcenters/der Agentur für Arbeit"]
[]
[]
[]
[]
[]
[]
[]
["Sammelbescheinigung zum Nachweis der Pauschale für Arbeitslosengeldleistungen"]
["Prüfung der Arbeitslosengeldleistungen"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Zeitraum",null,null,null,"Familienversicherte",null,"Pflichtversicherte"]
[null,null,null,"Pauschalbetrag","1)","2016-01-01","2020-12-31",null,432,null,386]
[null,null,null,null,"2)","2020-01-01",null,null,432,null,386]
[]
[]
["bitte auswählen"]
["Richtlinie über die Gewährung von Zuwendungen zur Unterstützung Regionaler Fachkräftebündnisse durch Förderung von Fachkräfteprojekten für die Region 2021 - 2027"]
["Richtlinie über die Gewährung von Zuwendungen zur Förderung von Regionalen Initiativen und Kooperationen für Frauen am Arbeitsmarkt (RIKA)"]
[]
[]
[]
[]
[]
["ALG II - familienversichert"]
["ALG II - pflichtversichert"]
["ALG I"]

{"sheet":"Sammelbescheinigung Seite 3","index":2,"n_rows":136,"n_cols":40,"rows_kept":136,"cut":false,"hidden":false,"merged":[[121,6,121,7],[121,10,121,11],[122,5,122,7],[122,10,122,11],[37,12,37,15],[38,0,39,1],[38,12,38,15],[43,2,43,37],[45,0,45,3],[120,4,120,7],[36,37,36,40],[25,37,25,40],[26,37,26,40],[27,37,27,40],[28,37,28,40],[29,37,29,40],[30,37,30,40],[31,37,31,40],[32,37,32,40],[33,37,33,40],[34,37,34,40],[35,37,35,40],[10,29,11,29],[10,30,11,30],[24,37,24,40],[13,37,13,40],[14,37,14,40],[15,37,15,40],[16,37,16,40],[17,37,17,40],[18,37,18,40],[19,37,19,40],[20,37,20,40],[21,37,21,40],[22,37,22,40],[23,37,23,40],[12,37,12,40],[10,15,11,15],[10,18,11,18],[10,19,11,19],[10,20,11,20],[9,16,11,16],[9,17,11,17],[9,18,9,19],[10,21,11,21],[9,32,11,32],[9,34,11,34],[9,35,11,35],[9,37,11,40],[9,26,9,27],[9,28,9,31],[10,26,11,26],[10,27,11,27],[10,28,11,28],[9,20,9,23],[9,24,9,25],[10,22,11,22],[10,23,11,23],[10,24,11,24],[10,25,11,25],[9,0,11,0],[9,1,11,1],[9,2,9,3],[9,8,9,9],[9,11,9,15],[10,8,11,8],[10,9,11,9],[10,10,11,10],[10,12,11,12],[10,7,11,7],[10,2,11,2],[10,3,11,3],[10,4,11,4],[10,5,11,5],[10,6,11,6],[10,14,11,14],[8,18,8,32],[1,0,1,19],[4,0,4,1],[4,2,4,3],[4,4,4,5],[4,8,4,40],[5,0,5,1],[5,2,5,3],[5,4,5,5],[5,6,5,8],[5,10,5,33],[6,2,6,3],[6,4,6,5],[6,8,6,9],[8,0,8,5],[8,8,8,9]]}
[0]
["Sammelbescheinigung zum Nachweis der Pauschale für Arbeitslosengeldleistungen"]
["Zur Abrechnung gegenüber der NBank:"]
[]
[{"$f":"IF(A2=\"Prüfung der Arbeitslosengeldleistungen (ALG I/ ALG II inkl. Sozialversicherungsbeiträge)\",\"\",\" Jobcenter/        \nAgentur für Arbeit:\")","v":" Jobcenter/        \nAgentur für Arbeit:"},null,{"$f":"IF('Sammelbescheinigung Seite 1'!C5:D5=\"\",\"\",'Sammelbescheinigung Seite 1'!C5:D5)","v":""},null,"Förderprogramm:              ",null,null,"Richtlinie über die Gewährung von Zuwendungen zur Unterstützung Regionaler Fachkräftebündnisse durch Förderung von Fachkräfteprojekten für die Region 2021 - 2027",{"$f":"IF('Sammelbescheinigung Seite 1'!I5:AO5=\"bitte auswählen\",\"bitte auf erster Seite auswählen\",'Sammelbescheinigung Seite 1'!I5:AO5)","v":"bitte auf erster Seite auswählen"}]
["Bildungseinrichtung:",null,{"$f":"IF('Sammelbescheinigung Seite 1'!C6:D6=\"\",\"\",'Sammelbescheinigung Seite 1'!C6:D6)","v":""},null,"         Abrechnungszeitraum vom:   ",null,{"$f":"'Sammelbescheinigung Seite 1'!G6:I6","v":"00:00:00"},null,null,"bis:",{"$f":"'Sammelbescheinigung Seite 1'!K6:AH6","v":"00:00:00"}]
[null,null,null,null,"  Antragsnummer NBank:       ",null,null,null,{"$f":"IF('Sammelbescheinigung Seite 1'!I7:J7=\"\",\"\",'Sammelbescheinigung Seite 1'!I7:J7)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Zuwendungsbescheid NBank vom:  ",null,null,null,null,null,{"$f":"'Sammelbescheinigung Seite 1'!AN7","v":"00:00:00"}]
[]
[null,null,null,null,null,null,"aus-blenden","Alt - Ausblenden","zu bestätigen vom Jobcenter/\nvon der Agentur für Arbeit",null,null,"ausblenden",null,"ausblenden",null,null,"ausblenden",null,"für  die Darstellung genutzte Berechungsfelder\n (ausblenden)"]
["lfd. \nNr. ","Bedarfsgemein-schaftsnummer/ \nKundennummer","Teilnehmende",null,"Beginn Teilnahme\n*1\n\n","ggf. Beendigung Teilnahme im  Zeitraum dieses Nachweises *1\n\n",null,"Bestätigung des Versicherungs-\nstatus","Bestätigung des Leistungsbezugs\n",null,null,"Ermittlung \nder\nAbrechnungsdaten",null,null,null,null,"Abrech-nungs-beginn","Pauschale","Pauschalberechnung\nallgemein\n",null,"ALTE FÖRDERPERIODE",null,null,null,"Sonderberechnung\nJugendwerkstätten",null,"Datum des\nZuwendungs-\nbescheides bestimmt die Pauschale (Q7)",null,"ALTE FÖRDERPERIODE",null,null,null,"Berechnung\nder \nPauschale","Pauschale","geltend gemacht gemäß Belegliste","Differenz\n\n(lediglich\n Kürzungen\n werden\n summiert)","Einheiten","Anmerkungen / Hinweise"]
[null,null,"Nachname","Vorname","Datum","Datum","Teiln.-Tage","(bitte auswählen)\n\nentfällt bei Jugendwerkstätten","von","bis","Tage",null,"Beginn",null,"Ende","Tage",null,null,"(familien-\nversichert)\nDatum 1","(familien-\nversichert)\nDatum 2","pflicht-\nvers bis\n30.06.11","pflicht-\nvers \nab 01.07.11","ALG I\nbis 30.06.11","ALG I\n01.07.11","Pauschal-satz bis\n30.06.11","Pauschal-satz ab\n01.07.11","\nversichert\nab XXX","\nversichert\n01.01.2016 bis XXX","pflicht-\nvers \nab 01.07.11","pflicht-\nvers\nbis 30.06.11 ","ALG I\n01.07.11","ALG I",null,"Übertrag Seite 2:",null,null,"Übertrag Seite 2:"]
[null,null,null,null,null,null,null,null,null,null,null,"Beg.-Ausw\nLeist <->Teiln",null,"Ende-Ausw\nLeist <->Teiln",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"bis 30.06.11",null,{"$f":"'Sammelbescheinigung Seite 2'!AH38","v":0},null,null,{"$f":"'Sammelbescheinigung Seite 2'!AK38","v":0}]
[51,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(I13>0,J13>0),DAYS360(I13,J13,TRUE)+1,0)","v":0},{"$f":"IF(I13>=E13,I13,E13)","v":"00:00:00"},{"$f":"IF($G$6>=L13,$G$6,L13)","v":"00:00:00"},{"$f":"IF(AND(F13=\"\",J13<>\"\"),J13,IF(J13<=F13,J13,F13))","v":"00:00:00"},{"$f":"IF($K$6<=N13,$K$6,N13)","v":"00:00:00"},{"$f":"IF(AND(M13=0,O13=0),0,IF(AND(MONTH(O13)=2,DAY(O13)=28,OR(YEAR(O13)=2022,YEAR(O13)=2023,YEAR(O13)=2025,YEAR(O13)=2026,YEAR(O13)=2027,YEAR(O13)=2029,YEAR(O13)*2030,YEAR(O13)*2031)),DAYS360(M13,O13,TRUE)+3,IF(AND(MONTH(O13)=2,DAY(O13)=29,OR(YEAR(O13)=2024,YEAR(O13)=2028,YEAR(O13)=2032)),DAYS360(M13,O13,TRUE)+2,DAYS360(M13,O13,TRUE)+1)))","v":0},{"$f":"IF(P13>I13,P13,I13)","v":"00:00:00"},{"$f":"SUM(S13:Z13)","v":0},{"$f":"IF(AND(O13<$F$123,H13=\"ALG II - familienversichert\",,$H$5<>\"Richtlinie über die Gewährung von Zuwendungen zur Förderung von Jugendwerkstätten\"),P13*($I$122/30),\"\")","v":""},{"$f":"IF(AND(O13>$G$122,H13=\"ALG II - familienversichert\",,$H$5<>\"Richtlinie über die Gewährung von Zuwendungen zur Förderung von Jugendwerkstätten\"),P13*($I$123/30),\"\")","v":""},{"$f":"IF(AND(O13<$F$123,H13=\"ALG II - pflichtversichert\"),P13*($K$122/30),\"\")","v":""},{"$f":"IF(AND(O13>$G$122,H13=\"ALG II - pflichtversichert\"),P13*($K$123/30),\"\")","v":""},{"$f":"IF(AND(O13<$F$123,H13=\"ALG I\"),P13*($K$122/30),\"\")","v":""},{"$f":"IF(AND(O13>$G$122,H13=\"ALG I\"),P13*($K$123/30),\"\")","v":""},{"$f":"IF(AND($AN$7<$F$123,$H$5=\"Richtlinie über die Gewährung von Zuwendungen zur Förderung von Jugendwerkstätten\"),$P13*($I$122/30),\"\")","v":""},{"$f":"IF(AND($AN$7>=$F$123,$H$5=\"Richtlinie über die Gewährung von Zuwendungen zur Förderung von Jugendwerkstätten\"),$P13*($I$123/30),\"\")","v":""},{"$f":"IF(AND($AN$7>=$F$123,$H13=\"ALG II - familienversichert\"),$P13*($I$123/30),\"\")","v":""},{"$f":"IF(AND($AN$7<$F$123,$H13=\"ALG II - familienversichert\"),$P13*($I$122/30),)","v":0},{"$f":"IF(AND($AN$7>=$F$123,$H13=\"ALG II - pflichtversichert\"),$P13*($K$123/30),\"\")","v":""},{"$f":"IF(AND($AN$7<$F$123,$H13=\"ALG II - pflichtversichert\"),$P13*($K$122/30),\"\")","v":""},{"$f":"IF(AND($AN$7>=$F$123,$H13=\"ALG I\"),$P13*($K$123/30),\"\")","v":""},{"$f":"IF(AND($AN$7<$F$123,$H13=\"ALG I\"),$P13*($K$122/30),\"\")","v":""},{"$f":"IF(OR($H$5=\"Richtlinie über die Gewährung von Zuwendungen zur Unterstützung Regionaler Fachkräftebündnisse durch Förderung von Fachkräfteprojekten für die Region 2021 - 2027\", $H$5=\"Richtlinie über die Gewährung von Zuwendungen zur Förderung von Regionalen Initiativen und Kooperationen für Frauen am Arbeitsmarkt (RIKA)\"),ROUND(1/30*P13,2)*(IF($AN$7>=$E$41,$F$41,$F$40)),0)","v":0},{"$f":"IF(AG13<0,0,AG13)","v":0},null,{"$f":"AH13-AI13","v":0},{"$f":"IF(P13>0,P13/30,0)","v":0}]
[52,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(I14>0,J14>0),DAYS360(I14,J14,TRUE)+1,0)","v":0},"00:00:00","00:00:00","00:00:00",{"$f":"IF($K$6<=N14,$K$6,N14)","v":"00:00:00"},{"$f":"IF(AND(M14=0,O14=0),0,IF(AND(MONTH(O14)=2,DAY(O14)=28,OR(YEAR(O14)=2022,YEAR(O14)=2023,YEAR(O14)=2025,YEAR(O14)=2026,YEAR(O14)=2027,YEAR(O14)=2029,YEAR(O14)*2030,YEAR(O14)*2031)),DAYS360(M14,O14,TRUE)+3,IF(AND(MONTH(O14)=2,DAY(O14)=29,OR(YEAR(O14)=2024,YEAR(O14)=2028,YEAR(O14)=2032)),DAYS360(M14,O14,TRUE)+2,DAYS360(M14,O14,TRUE)+1)))","v":0},"00:00:00",{"$f":"SUM(S14:Z14)","v":0},"","","","","","","","","",0,"","","","",{"$f":"IF(OR($H$5=\"Richtlinie über die Gewährung von Zuwendungen zur Unterstützung Regionaler Fachkräftebündnisse durch Förderung von Fachkräfteprojekten für die Region 2021 - 2027\", $H$5=\"Richtlinie über die Gewährung von Zuwendungen zur Förderung von Regionalen Initiativen und Kooperationen für Frauen am Arbeitsmarkt (RIKA)\"),ROUND(1/30*P14,2)*(IF($AN$7>=$E$41,$F$41,$F$40)),0)","v":0},{"$f":"IF(AG14<0,0,AG14)","v":0},null,{"$f":"AH14-AI14","v":0},{"$f":"IF(P14>0,P14/30,0)","v":0}]
[53,null,null,null,null,null,null,null,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,"00:00:00",{"$f":"SUM(S15:Z15)","v":0},"","","","","","","","","",0,"","","","",0,0,null,0,0]
[54,null,null,null,null,null,null,null,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,"00:00:00",0,"","","","","","","","","",0,"","","","",0,0,null,0,0]
[55,null,null,null,null,null,null,null,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,"00:00:00",0,"","","","","","","","","",0,"","","","",0,0,null,0,0]
[56,null,null,null,null,null,null,null,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,"00:00:00",0,"","","","","","","","","",0,"","","","",0,0,null,0,0]
[57,null,null,null,null,null,null,null,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,"00:00:00",0,"","","","","","","","","",0,"","","","",0,0,null,0,0]
[58,null,null,null,null,null,null,null,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,"00:00:00",0,"","","","","","","","","",0,"","","","",0,0,null,0,0]
[59,null,null,null,null,null,null,null,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,"00:00:00",0,"","","","","","","","","",0,"","","","",0,0,null,0,0]
[60,null,null,null,null,null,null,null,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,"00:00:00",{"$f":"SUM(S22:Z22)","v":0},"","","","","","","","","",0,"","","","",0,{"$f":"IF(AG22<0,0,AG22)","v":0},null,0,0]
[61,null,null,null,null,null,null,null,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,"00:00:00",{"$f":"SUM(S23:Z23)","v":0},"","","","","","","","","",0,"","","","",0,{"$f":"IF(AG23<0,0,AG23)","v":0},null,0,0]
[62,null,null,null,null,null,null,null,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,"00:00:00",{"$f":"SUM(S24:Z24)","v":0},"","","","","","","","","",0,"","","","",0,{"$f":"IF(AG24<0,0,AG24)","v":0},null,0,0]
[63,null,null,null,null,null,null,null,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,"00:00:00",{"$f":"SUM(S25:Z25)","v":0},"","","","","","","","","",0,"","","","",0,{"$f":"IF(AG25<0,0,AG25)","v":0},null,0,0]
[64,null,null,null,null,null,null,null,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,"00:00:00",{"$f":"SUM(S26:Z26)","v":0},"","","","","","","","","",0,"","","","",0,{"$f":"IF(AG26<0,0,AG26)","v":0},null,0,0]
[65,null,null,null,null,null,null,null,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,"00:00:00",0,"","","","","","","","","",0,"","","","",0,0,null,0,0]
[66,null,null,null,null,null,null,null,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,"00:00:00",0,"","","","","","","","","",0,"","","","",0,0,null,0,0]
[67,null,null,null,null,null,null,null,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,"00:00:00",0,"","","","","","","","","",0,"","","","",0,0,null,0,0]
[68,null,null,null,null,null,null,null,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,"00:00:00",0,"","","","","","","","","",0,"","","","",0,0,null,0,0]
[69,null,null,null,null,null,null,null,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,"00:00:00",0,"","","","","","","","","",0,"","","","",0,0,null,0,0]
[70,null,null,null,null,null,null,null,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,"00:00:00",{"$f":"SUM(S32:Z32)","v":0},"","","","","","","","","",0,"","","","",0,0,null,0,0]
[71,null,null,null,null,null,null,null,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,"00:00:00",0,"","","","","","","","","",0,"","","","",0,0,null,0,0]
[72,null,null,null,null,null,null,null,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,"00:00:00",0,"","","","","","","","","",0,"","","","",0,0,null,0,0]
[73,null,null,null,null,null,{"$f":"IF(AND(E35>0,F35>0),DAYS360(E35,F35,TRUE)+1,0)","v":0},"ALG II - familienversichert",null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,"00:00:00",0,"","","","","","","","","",0,"","","","",0,0,null,0,0]
[74,null,null,null,null,null,0,"ALG II - familienversichert",null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,"00:00:00",0,"","","","","","","","","",0,"","","","",0,0,null,0,0]
[75,null,null,null,null,null,0,"ALG II - familienversichert",null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,"00:00:00",0,"","","","","","","","","",0,"","","","",0,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AH38=#REF!,\"Gesamtsumme:\",\"Zwischensumme\")","v":{"$error":"#REF!"}},null,null,null,"00:00:00",null,{"$f":"IF(AND(O38<$F$123,H38=\"familienversichert\"),P38*($I$122/30),\"\")","v":""},{"$f":"IF(AND(O38>$G$122,H38=\"familienversichert\"),P38*($I$123/30),\"\")","v":""},{"$f":"IF(AND(O38<$F$123,J38=\"pflichtversichert\"),P38*($K$122/30),\"\")","v":""},{"$f":"IF(AND(O38>$G$122,H38=\"pflichtversichert\"),P38*($K$123/30),\"\")","v":""},null,null,{"$f":"IF(AND($Q38<$G$122,$H$5=\"Richtlinie über die Gewährung von Zuwendungen zur Förderung von Jugendwerkstätten\"),#REF!*($I$122/30),\"\")","v":""},{"$f":"IF(AND($Q38>$G$122,$H$5=\"Richtlinie über die Gewährung von Zuwendungen zur Förderung von Jugendwerkstätten\"),#REF!*($I$123/30),\"\")","v":""},{"$f":"IF(AND($AN$7>$G$123,$H38=\"familienversichert\"),P38*($I$122/30),\"\")","v":""},null,{"$f":"IF(AND($AN$7>$G$123,$H38=\"pflichtversichert\"),$P38*($K$122/30),\"\")","v":""},{"$f":"IF(AND($AN$7>$G$123,$H38=\"pflichtversichert\"),$P38*($K$122/30),\"\")","v":""},null,null,{"$f":"SUMIF(AG13:AG37,\">0\",AG13:AG37)","v":0},{"$f":"SUM(AH12:AH37)","v":0},{"$f":"SUM(AI13:AI37)","v":0},{"$f":"SUM(AJ13:AJ37)","v":0},{"$f":"SUMPRODUCT((ROUND(AK12:AK37,2))*1)","v":0}]
[null,null,"Erläuterungen:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AG38)","v":0}]
[null,null,"  Standardeinheitskostensatz:",null,{"$f":"'Sammelbescheinigung Seite 1'!E40","v":"2022-03-02"},432]
[null,null,null,null,{"$f":"'Sammelbescheinigung Seite 1'!E41","v":"2024-11-01"},489]
[]
[]
[null,null,"     *1 Gegenüber der NBank dürfen nur Zeiträume abgerechnet werden, in denen die oben genannten Personen an der Maßnahme teilgenommen haben\n   *2 Zeiten vor Beginn oder nach Ende der Maßnahme dürfen nicht angegeben werden"]
[]
["Datum,  Stempel  /  Unterschrift des Jobcenters/der Agentur für Arbeit"]
[]
[]
[]
[]
[]
[]
[]
["Sammelbescheinigung zum Nachweis der Pauschale für Arbeitslosengeldleistungen"]
["Prüfung der Arbeitslosengeldleistungen"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Zeitraum",null,null,null,"Familienversicherte",null,"Pflichtversicherte"]
[null,null,null,"Pauschalbetrag","1)","2016-01-01","2020-12-31",null,432,null,386]
[null,null,null,null,"2)","2020-01-01",null,null,432,null,386]
[]
[]
["bitte auswählen"]
["Richtlinie über die Gewährung von Zuwendungen zur Unterstützung Regionaler Fachkräftebündnisse durch Förderung von Fachkräfteprojekten für die Region 2021 - 2027"]
["Richtlinie über die Gewährung von Zuwendungen zur Förderung von Regionalen Initiativen und Kooperationen für Frauen am Arbeitsmarkt (RIKA)"]
[]
[]
[]
[]
[]
["ALG II - familienversichert"]
["ALG II - pflichtversichert"]
["ALG I"]

{"sheet":"Einverständnis TN Version 1","index":3,"n_rows":30,"n_cols":5,"rows_kept":30,"cut":false,"hidden":false,"merged":[[3,3,3,5],[4,3,4,5],[5,3,5,5],[3,0,3,2],[6,0,6,2]]}
["Einverständniserklärung der teilnehmenden Person zur"]
["Weitergabe persönlicher Daten an die NBank"]
[]
["Name der teilnehmenden Person:"]
[null,null,"durchführende Bildungseinrichtung:",{"$f":"'Sammelbescheinigung Seite 1'!C6:D6","v":0}]
[null,null,"Projektbezeichnung/ Projekttitel:"]
["Antragsnummer:",null,null,null,{"$f":"'Sammelbescheinigung Seite 1'!I7","v":0}]
[]
["Hiermit erkläre ich mich einverstanden, dass das Jobcenter / die Agentur für Arbeit"]
["folgende Informationen über die Bildungseinrichtung an die NBank weiterleitet:"]
[]
["a) Angaben zur Person (Name, Vorname, Bedarfsgemeinschaftsnummer/Kundennummer)"]
[]
["b) Angabe, dass ich während der Dauer der o.g. Maßnahme im Leistungsbezug gewesen bin"]
[]
[]
["Die erhobenen Daten dienen ausschließlich zur Abrechnung der von der Europäischen Union"]
["geförderte Maßnahme und werden nicht an Dritte weitergegeben."]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Unterschrift "]
[]
[]
[]
["Hinweis: Die Einverständniserklärung verbleibt beim Jobcenter / der Agentur für Arbeit"]

{"sheet":"Einverständnis TN Version 2","index":4,"n_rows":41,"n_cols":4,"rows_kept":41,"cut":false,"hidden":false,"merged":[[3,2,3,3],[4,2,4,3]]}
["Einverständniserklärung der teilnehmenden Personen zur"]
["Weitergabe persönlicher Daten an die NBank"]
[]
[null,"durchführende Bildungseinrichtung:",{"$f":"'Sammelbescheinigung Seite 1'!C6:D6","v":0}]
[null,"Projektbezeichnung/ Projekttitel:"]
[null,"Antragsnummer:",{"$f":"'Sammelbescheinigung Seite 1'!I7","v":0}]
[]
["Hiermit erkläre ich mich einverstanden, dass das JobCenter / die Agentur für Arbeit"]
["folgende Informationen über die Bildungseinrichtung an die NBank weiterleitet:"]
[]
["a) Angaben zur Person (Name, Vorname, Bedarfsgemeinschaftsnummer/Kundennummer)"]
[]
["b) Angabe, dass ich während der Dauer der o.g. Maßnahme im Leistungsbezug gewesen bin"]
[]
["Die erhobenen Daten dienen ausschließlich zur Abrechnung der von der Europäischen Union"]
["geförderten Maßnahmen und werden nicht an Dritte weitergegeben."]
[]
["lfd. Nr. ","Name","Vorname","Unterschrift"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Hinweis: Die Einverständniserklärung verbleibt beim Jobcenter / der Agentur für Arbeit"]