{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sammelbescheinigung"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":1,"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","index":0,"n_rows":206,"n_cols":38,"rows_kept":206,"cut":false,"hidden":false,"merged":[[4,8,4,40],[10,34,12,34],[10,35,12,35],[10,33,12,33],[11,29,12,29],[11,30,12,30],[11,26,12,26],[6,33,6,38],[5,4,5,5],[5,2,5,3],[11,19,12,19],[8,8,8,9],[11,6,12,6],[8,0,8,5],[8,18,8,32],[11,20,12,20],[11,21,12,21],[10,26,10,27],[5,6,5,8],[10,18,10,19],[5,10,5,33],[9,8,9,9],[9,4,9,5],[6,8,6,9],[1,0,1,19],[10,8,10,9],[10,1,12,1],[10,0,12,0],[10,2,10,3],[11,9,12,9],[11,15,12,15],[11,2,12,2],[11,12,12,12],[11,14,12,14],[4,0,4,1],[6,2,6,3],[4,2,4,3],[4,4,4,5],[5,0,5,1],[6,4,6,5],[122,5,122,7],[120,4,120,7],[122,10,122,11],[11,5,12,5],[10,11,10,15],[45,5,45,33],[43,2,43,37],[32,37,32,40],[33,37,33,40],[34,37,34,40],[35,37,35,40],[36,37,36,40],[37,37,37,40],[45,0,45,3],[121,10,121,11],[121,6,121,7],[39,0,40,1],[39,12,39,15],[11,3,12,3],[11,4,12,4],[11,28,12,28],[11,10,12,10],[11,8,12,8],[38,12,38,15],[11,7,12,7],[11,27,12,27],[10,17,12,17],[10,20,10,23],[10,16,12,16],[11,18,12,18],[11,24,12,24],[11,25,12,25],[18,37,18,40],[19,37,19,40],[20,37,20,40],[11,22,12,22],[11,23,12,23],[10,37,12,40],[13,37,13,40],[10,36,12,36],[14,37,14,40],[15,37,15,40],[16,37,16,40],[17,37,17,40],[10,32,12,32],[10,24,10,25],[10,28,10,31],[30,37,30,40],[31,37,31,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]]}
[0]
["Sammelbescheinigung zum Nachweis der Teilnehmerausgaben (Tageshaftkosten)"]
["Zur Abrechnung gegenüber der NBank:"]
[]
[{"$f":"IF(A2=\"Prüfung der Arbeitslosengeldleistungen (ALG I/ ALG II inkl. Sozialversicherungsbeiträge)\",\"\",\" Justizvollzugsanstalt:\")","v":" Justizvollzugsanstalt:"},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","Richtlinie über die Gewährung von Zuwendungen zur Förderung der Wiedereingliederung von Inhaftierten und Haftentlassenen in die Gesellschaft und den Arbeitsmarkt 2021 - 2027"]
["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:   "]
[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,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"]
[null,null,null,null,"Zu bestätigen vom Projektträger und der Justizvollzugsanstalt",null,null,null,"Zu bestätigen von der Justizvollzugsanstalt"]
["Lfd. \nNr. ","Teilnehmenden-nummer Monitoring","Teilnehmende(r) ",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 Inhaftierungszeitraums\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","Tageshaftkosten","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(I14>0,J14>0),DAYS360(I14,J14,TRUE)+1,0)","v":0},{"$f":"IF(I14>=E14,I14,E14)","v":"00:00:00"},{"$f":"IF($G$6>=L14,$G$6,L14)","v":"00:00:00"},{"$f":"IF(AND(F14=\"\",J14<>\"\"),J14,IF(J14<=F14,J14,F14))","v":"00:00:00"},{"$f":"IF($K$6<=N14,$K$6,N14)","v":"00:00:00"},{"$f":"IF(AND(M14>0,O14>0,E14>0,F14>0),NETWORKDAYS(M14,O14,$A$144:$A$206))","v":false},{"$f":"IF(P14>I14,P14,I14)","v":"00:00:00"},{"$f":"SUM(S14:Z14)","v":0},{"$f":"IF(AND(O14<$F$123,H14=\"ALG II - familienversichert\",,$H$5<>\"Richtlinie über die Gewährung von Zuwendungen zur Förderung von Jugendwerkstätten\"),P14*($I$122/30),\"\")","v":""},{"$f":"IF(AND(O14>$G$122,H14=\"ALG II - familienversichert\",,$H$5<>\"Richtlinie über die Gewährung von Zuwendungen zur Förderung von Jugendwerkstätten\"),P14*($I$123/30),\"\")","v":""},{"$f":"IF(AND(O14<$F$123,H14=\"ALG II - pflichtversichert\"),P14*($K$122/30),\"\")","v":""},{"$f":"IF(AND(O14>$G$122,H14=\"ALG II - pflichtversichert\"),P14*($K$123/30),\"\")","v":""},{"$f":"IF(AND(O14<$F$123,H14=\"ALG I\"),P14*($K$122/30),\"\")","v":""},{"$f":"IF(AND(O14>$G$122,H14=\"ALG I\"),P14*($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\"),$P14*($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\"),$P14*($I$123/30),\"\")","v":""},{"$f":"IF(AND($AN$7>=$F$123,$H14=\"ALG II - familienversichert\"),$P14*($I$123/30),\"\")","v":""},{"$f":"IF(AND($AN$7<$F$123,$H14=\"ALG II - familienversichert\"),$P14*($I$122/30),)","v":0},{"$f":"IF(AND($AN$7>=$F$123,$H14=\"ALG II - pflichtversichert\"),$P14*($K$123/30),\"\")","v":""},{"$f":"IF(AND($AN$7<$F$123,$H14=\"ALG II - pflichtversichert\"),$P14*($K$122/30),\"\")","v":""},{"$f":"IF(AND($AN$7>=$F$123,$H14=\"ALG I\"),$P14*($K$123/30),\"\")","v":""},{"$f":"IF(AND($AN$7<$F$123,$H14=\"ALG I\"),$P14*($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)\"),$I$123/30*P14,0)","v":0},{"$f":"$F$41*AK14","v":0},null,{"$f":"AH14-AI14","v":0},{"$f":"IF(ISNUMBER(P14),P14,0)","v":0}]
[{"$f":"A14+1","v":2},null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(I15>0,J15>0),DAYS360(I15,J15,TRUE)+1,0)","v":0},{"$f":"IF(I15>=E15,I15,E15)","v":"00:00:00"},{"$f":"IF($G$6>=L15,$G$6,L15)","v":"00:00:00"},{"$f":"IF(AND(F15=\"\",J15<>\"\"),J15,IF(J15<=F15,J15,F15))","v":"00:00:00"},{"$f":"IF($K$6<=N15,$K$6,N15)","v":"00:00:00"},{"$f":"IF(AND(M15>0,O15>0,E15>0,F15>0),NETWORKDAYS(M15,O15,$A$144:$A$206))","v":false},{"$f":"IF(P15>I15,P15,I15)","v":"00:00:00"},{"$f":"SUM(S15:Z15)","v":0},{"$f":"IF(AND(O15<$F$123,H15=\"ALG II - familienversichert\",,$H$5<>\"Richtlinie über die Gewährung von Zuwendungen zur Förderung von Jugendwerkstätten\"),P15*($I$122/30),\"\")","v":""},{"$f":"IF(AND(O15>$G$122,H15=\"ALG II - familienversichert\",,$H$5<>\"Richtlinie über die Gewährung von Zuwendungen zur Förderung von Jugendwerkstätten\"),P15*($I$123/30),\"\")","v":""},{"$f":"IF(AND(O15<$F$123,H15=\"ALG II - pflichtversichert\"),P15*($K$122/30),\"\")","v":""},{"$f":"IF(AND(O15>$G$122,H15=\"ALG II - pflichtversichert\"),P15*($K$123/30),\"\")","v":""},{"$f":"IF(AND(O15<$F$123,H15=\"ALG I\"),P15*($K$122/30),\"\")","v":""},{"$f":"IF(AND(O15>$G$122,H15=\"ALG I\"),P15*($K$123/30),\"\")","v":""},"","","",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)\"),$I$123/30*P15,0)","v":0},{"$f":"$F$41*AK15","v":0},null,{"$f":"AH15-AI15","v":0},{"$f":"IF(ISNUMBER(P15),P15,0)","v":0}]
[{"$f":"A15+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",false,"00:00:00",{"$f":"SUM(S16:Z16)","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",false,"00:00:00",0,"","","","","","","","","",0,"","","","",0,0,null,0,{"$f":"IF(ISNUMBER(P17),P17,0)","v":0}]
[5,null,null,null,null,null,null,null,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",false,"00:00:00",0,"","","","","","","","","",0,"","","","",0,0,null,0,{"$f":"IF(ISNUMBER(P18),P18,0)","v":0}]
[6,null,null,null,null,null,null,null,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",false,"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",false,"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",false,"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",false,"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",false,"00:00:00",{"$f":"SUM(S23:Z23)","v":0},"","","","","","","","","",0,"","","","",0,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",false,"00:00:00",{"$f":"SUM(S24:Z24)","v":0},"","","","","","","","","",0,"","","","",0,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",false,"00:00:00",{"$f":"SUM(S25:Z25)","v":0},"","","","","","","","","",0,"","","","",0,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",false,"00:00:00",{"$f":"SUM(S26:Z26)","v":0},"","","","","","","","","",0,"","","","",0,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",false,"00:00:00",{"$f":"SUM(S27:Z27)","v":0},"","","","","","","","","",0,"","","","",0,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",false,"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",false,"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",false,"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",false,"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",false,"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",false,"00:00:00",{"$f":"SUM(S33:Z33)","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",false,"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",false,"00:00:00",0,"","","","","","","","","",0,"","","","",0,0,null,0,0]
[23,null,null,null,null,null,null,null,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",false,"00:00:00",0,"","","","","","","","","",0,"","","","",0,0,null,0,0]
[24,null,null,null,null,null,null,null,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",false,"00:00:00",0,"","","","","","","","","",0,"","","","",0,0,null,0,0]
[25,null,null,null,null,null,null,null,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",{"$f":"IF(AND(M38>0,O38>0,E38>0,F38>0),NETWORKDAYS(M38,O38,$A$144:$A$206))","v":false},"00:00:00",0,"","","","","","","","","",0,"","","","",0,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"Gesamtsumme:",null,null,null,"00:00:00",null,{"$f":"IF(AND(O39<$F$123,H39=\"familienversichert\"),P39*($I$122/30),\"\")","v":""},{"$f":"IF(AND(O39>$G$122,H39=\"familienversichert\"),P39*($I$123/30),\"\")","v":""},{"$f":"IF(AND(O39<$F$123,J39=\"pflichtversichert\"),P39*($K$122/30),\"\")","v":""},{"$f":"IF(AND(O39>$G$122,H39=\"pflichtversichert\"),P39*($K$123/30),\"\")","v":""},null,null,{"$f":"IF(AND($Q39<$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($Q39>$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,$H39=\"familienversichert\"),P39*($I$122/30),\"\")","v":""},null,{"$f":"IF(AND($AN$7>$G$123,$H39=\"pflichtversichert\"),$P39*($K$122/30),\"\")","v":""},{"$f":"IF(AND($AN$7>$G$123,$H39=\"pflichtversichert\"),$P39*($K$122/30),\"\")","v":""},null,null,{"$f":"SUMIF(AG14:AG38,\">0\",AG14:AG38)","v":0},{"$f":"SUM(AH14:AH38)","v":0},{"$f":"SUM(AI14:AI38)","v":0},{"$f":"SUM(AJ14:AJ38)","v":0},{"$f":"SUM(AK14:AK38)","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(AG39)","v":0}]
[null,null,"  Standardeinheitskostensatz:",null,"2024-07-01",54.97]
[]
[]
[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       Zeiten vor Beginn oder nach Ende der Maßnahme dürfen nicht angegeben werden."]
[]
["Datum,  Stempel  /  Unterschrift der Justizvollzugsanstalt",null,null,null,null,"Datum,  Stempel  /  Unterschrift des Projektträgers"]
[]
[]
[]
[]
[]
[]
[]
["Sammelbescheinigung zum Nachweis der Teilnehmerausgaben (Tageshaftkosten)"]
["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,52.81,null,386]
[]
[]
["bitte auswählen"]
["Richtlinie über die Gewährung von Zuwendungen zur Förderung der Wiedereingliederung von Inhaftierten und Haftentlassenen in die Gesellschaft und den Arbeitsmarkt 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"]
[]
[]
[]
[]
[]
[]
[]
["2022-01-01"]
["2022-04-15"]
["2022-04-17"]
["2022-04-18"]
["2022-05-01"]
["2022-05-26"]
["2022-06-06"]
["2022-10-03"]
["2022-10-31"]
["2022-12-25"]
["2022-12-26"]
["2023-01-01"]
["2023-04-07"]
["2023-04-09"]
["2023-04-10"]
["2023-05-01"]
["2023-05-18"]
["2023-05-29"]
["2023-10-03"]
["2023-10-31"]
["2023-12-25"]
["2023-12-26"]
["2024-01-01"]
["2024-03-29"]
["2024-03-31"]
["2024-04-01"]
["2024-05-01"]
["2024-05-09"]
["2024-05-20"]
["2024-10-03"]
["2024-10-31"]
["2024-12-25"]
["2024-12-26"]
["2025-01-01"]
["2025-04-18"]
["2025-04-21"]
["2025-05-01"]
["2025-05-29"]
["2025-06-09"]
["2025-10-03"]
["2025-03-31"]
["2025-12-25"]
["2025-12-26"]
["2026-01-01"]
["2026-04-03"]
["2026-04-06"]
["2026-05-01"]
["2026-05-14"]
["2026-05-25"]
["2026-10-03"]
["2026-10-31"]
["2026-12-25"]
["2026-12-26"]
["2027-01-01"]
["2027-03-26"]
["2027-03-29"]
["2027-05-01"]
["2027-05-06"]
["2027-05-17"]
["2027-10-03"]
["2027-10-31"]
["2027-12-25"]
["2027-12-26"]