{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sammelbescheinigung","Einverständnis TN Version 1","Einverständnis TN Version 2"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":0,"defined_names":2,"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":281,"n_cols":20,"rows_kept":281,"cut":false,"hidden":false,"merged":[[106,16,106,19],[140,16,140,19],[147,16,147,19],[122,16,124,19],[125,16,125,19],[126,16,126,19],[127,16,127,19],[128,16,128,19],[133,16,133,19],[134,16,134,19],[135,16,135,19],[139,16,139,19],[136,16,136,19],[137,16,137,19],[138,16,138,19],[131,16,131,19],[132,16,132,19],[129,16,129,19],[130,16,130,19],[148,16,148,19],[149,16,149,19],[150,16,150,19],[141,16,141,19],[142,16,142,19],[143,16,143,19],[144,16,144,19],[145,16,145,19],[146,16,146,19],[88,16,88,19],[89,16,89,19],[90,16,90,19],[91,16,91,19],[92,16,92,19],[93,16,93,19],[112,16,112,19],[94,16,94,19],[95,16,95,19],[96,16,96,19],[97,16,97,19],[98,16,98,19],[99,16,99,19],[110,16,110,19],[111,16,111,19],[100,16,100,19],[107,16,107,19],[108,16,108,19],[101,16,101,19],[102,16,102,19],[109,16,109,19],[103,16,103,19],[104,16,104,19],[105,16,105,19],[68,16,68,19],[69,16,69,19],[70,16,70,19],[71,16,71,19],[72,16,72,19],[73,16,73,19],[84,16,86,19],[87,16,87,19],[74,16,74,19],[59,16,59,19],[60,16,60,19],[61,16,61,19],[62,16,62,19],[63,16,63,19],[64,16,64,19],[65,16,65,19],[66,16,66,19],[67,16,67,19],[50,16,50,19],[51,16,51,19],[52,16,52,19],[53,16,53,19],[54,16,54,19],[55,16,55,19],[56,16,56,19],[57,16,57,19],[58,16,58,19],[30,16,30,19],[31,16,31,19],[32,16,32,19],[33,16,33,19],[34,16,34,19],[35,16,35,19],[36,16,36,19],[46,16,48,19],[49,16,49,19],[152,11,152,14],[122,15,124,15],[125,11,125,14],[151,11,151,14],[152,0,153,1],[9,16,11,19],[12,16,12,19],[13,16,13,19],[14,16,14,19],[15,16,15,19],[16,16,16,19],[17,16,17,19],[18,16,18,19],[19,16,19,19],[20,16,20,19],[21,16,21,19],[22,16,22,19],[23,16,23,19],[24,16,24,19],[25,16,25,19],[26,16,26,19],[27,16,27,19],[28,16,28,19],[29,16,29,19],[122,0,124,0],[122,1,124,1],[122,2,122,3],[122,7,122,8],[122,10,122,14],[123,8,124,8],[123,9,124,9],[123,2,124,2],[123,3,124,3],[123,4,124,4],[123,5,124,5],[123,6,124,6],[123,7,124,7],[123,14,124,14],[46,0,48,0],[46,1,48,1],[47,8,48,8],[83,0,83,3],[47,3,48,3],[84,7,84,8],[9,15,11,15],[85,8,86,8],[75,11,75,14],[46,7,46,8],[49,11,49,14],[10,6,11,6],[37,11,37,14],[47,14,48,14],[47,11,48,11],[38,0,39,1],[38,11,38,14],[10,3,11,3],[10,4,11,4],[9,10,9,14],[10,9,11,9],[46,15,48,15],[266,4,266,6],[10,5,11,5],[84,0,86,0],[84,1,86,1],[76,11,76,14],[267,9,267,10],[84,2,84,3],[10,7,11,7],[47,2,48,2],[47,13,48,13],[46,10,46,14],[123,11,124,11],[123,13,124,13],[121,0,121,3],[76,0,77,1],[47,5,48,5],[47,6,48,6],[47,7,48,7],[47,9,48,9],[84,10,84,14],[113,11,113,14],[47,4,48,4],[114,0,115,1],[46,2,46,3],[1,0,1,14],[9,7,9,8],[9,1,11,1],[9,0,11,0],[9,2,9,3],[10,8,11,8],[10,14,11,14],[10,2,11,2],[10,11,11,11],[10,13,11,13],[4,0,4,1],[6,2,6,3],[4,2,4,3],[4,4,4,5],[5,0,5,1],[6,4,6,5],[5,4,5,5],[5,2,5,3],[8,7,8,8],[8,0,8,5],[6,7,6,8],[5,16,5,17],[5,7,5,8],[156,3,157,14],[4,7,4,18],[118,3,119,14],[80,3,81,14],[42,3,43,14],[120,0,120,2],[158,0,158,2],[82,0,82,2],[44,0,44,2],[85,7,86,7],[85,9,86,9],[87,11,87,14],[85,14,86,14],[114,11,114,14],[84,15,86,15],[85,2,86,2],[85,3,86,3],[85,4,86,4],[85,5,86,5],[85,6,86,6],[85,11,86,11],[85,13,86,13]]}
[0]
["Sammelbescheinigung zum Nachweis der Pauschale für Leistungen nach dem Asylbewerberleistungsgesetz"]
["Zur Abrechnung gegenüber der NBank für den Zeitraum:"]
[]
["Zuständige Behörde/Kostenträger:",null,null,null,"Förderprogramm:              ",null,null,"bitte auswählen"]
["Bildungsträger:   ",null,null,null,"         Abrechnungszeitraum vom:   ",null,null,null,null,null,null,null,null,null,null,"bis:"]
[null,null,null,null,"  Antragsnummer NBank:       ",null,null,null,null,null,null,null,null,null,null,"Zuwendungsbescheid NBank vom:  "]
[]
[{"$f":"IF(S7>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,null,"zu bestätigen von der zuständige Behörde / vom Kostenträger:"]
["lfd. \nNr. ","Aktenzeichen","Teilnehmer/in",null,"Beginn Teilnahme\n*1\n\n","ggf. Beendigung Teilnahme im  Zeitraum dieses Nachweises *1\n\n",null,"Bestätigung des Leistungsbezugs  *2\n",null,null,"Ermittlung \nder\nAbrechnungsdaten",null,null,null,null,"Pauschale\n","Anmerkungen / Hinweise"]
[null,null,"Nachname","Vorname","Datum","Datum","Teiln.-Tage","von","bis","Tage",null,"Beginn",null,"Ende","Tage"]
[null,null,null,null,null,null,null,null,null,null,"Prüfung 1",null,"Prüfung 2"]
[1,null,null,null,null,null,{"$f":"(DAY(E13)>1)*(MIN(F13+1,DATE(YEAR(E13), MONTH(E13)+1,1))-E13) + 30*MAX(,12*(YEAR(F13)-YEAR(E13))+MONTH(F13)-MONTH(E13)+(DAY(E13)=1)-(DAY(F13+1)>1)) + DAY(F13)*(DAY(F13+1)>1)*(1-(DAY(E13)>1)*(TEXT(E13,\"JJJJMM\")=TEXT(F13,\"JJJJMM\")))","v":0},null,null,{"$f":"(DAY(H13)>1)*(MIN(I13+1,DATE(YEAR(H13), MONTH(H13)+1,1))-H13) + 30*MAX(,12*(YEAR(I13)-YEAR(H13))+MONTH(I13)-MONTH(H13)+(DAY(H13)=1)-(DAY(I13+1)>1)) + DAY(I13)*(DAY(I13+1)>1)*(1-(DAY(H13)>1)*(TEXT(H13,\"JJJJMM\")=TEXT(I13,\"JJJJMM\")))","v":0},{"$f":"IF(H13>=E13,H13,E13)","v":"00:00:00"},{"$f":"IF($H$6>=K13,$H$6,K13)","v":"00:00:00"},{"$f":"IF(I13<=F13,I13,F13)","v":"00:00:00"},{"$f":"IF($Q$6<=M13,$Q$6,M13)","v":"00:00:00"},{"$f":"IF(L13>N13,\"0\",((DAY(L13)>1)*(MIN(N13+1,DATE(YEAR(L13), MONTH(L13)+1,1))-L13) + 30*MAX(,12*(YEAR(N13)-YEAR(L13))+MONTH(N13)-MONTH(L13)+(DAY(L13)=1)-(DAY(N13+1)>1)) + DAY(N13)*(DAY(N13+1)>1)*(1-(DAY(L13)>1)*(TEXT(L13,\"JJJJMM\")=TEXT(N13,\"JJJJMM\")))))","v":0},{"$f":"O13*$H$268/30","v":0}]
[{"$f":"A13+1","v":2},null,null,null,null,null,0,null,null,{"$f":"(DAY(H14)>1)*(MIN(I14+1,DATE(YEAR(H14), MONTH(H14)+1,1))-H14) + 30*MAX(,12*(YEAR(I14)-YEAR(H14))+MONTH(I14)-MONTH(H14)+(DAY(H14)=1)-(DAY(I14+1)>1)) + DAY(I14)*(DAY(I14+1)>1)*(1-(DAY(H14)>1)*(TEXT(H14,\"JJJJMM\")=TEXT(I14,\"JJJJMM\")))","v":0},"00:00:00","00:00:00","00:00:00","00:00:00",{"$f":"IF(L14>N14,\"0\",((DAY(L14)>1)*(MIN(N14+1,DATE(YEAR(L14), MONTH(L14)+1,1))-L14) + 30*MAX(,12*(YEAR(N14)-YEAR(L14))+MONTH(N14)-MONTH(L14)+(DAY(L14)=1)-(DAY(N14+1)>1)) + DAY(N14)*(DAY(N14+1)>1)*(1-(DAY(L14)>1)*(TEXT(L14,\"JJJJMM\")=TEXT(N14,\"JJJJMM\")))))","v":0},0]
[{"$f":"A14+1","v":3},null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,0]
[4,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,0]
[5,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,0]
[6,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,0]
[7,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,0]
[8,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,0]
[9,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,0]
[10,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,0]
[11,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,0]
[12,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,0]
[13,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,0]
[14,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,0]
[15,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,0]
[16,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,0]
[17,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,0]
[18,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,0]
[19,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,0]
[20,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,0]
[21,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,0]
[22,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,0]
[23,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,0]
[24,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,0]
[25,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,0]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(P38=P76,\"Gesamtsumme:\",\"Zwischensumme\")","v":"Gesamtsumme:"},null,null,null,{"$f":"SUM(P13:P37)","v":0}]
[null,null,null,"Erläuterungen:",null,"Pauschale"]
[null,null,null,"  Pauschalsätze:","2016-01-01",302]
[]
[]
[null,null,null,"*1 Gegenüber der NBank dürfen nur Zeiträume abgerechnet werden, in denen der/die \n     Teilnehmer/in an der Maßnahme teilgenommen hat\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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stand: Juli 2017"]
[]
["lfd. \nNr. ","Aktenzeichen","Teilnehmer/in",null,"Beginn Teilnahme\n*1\n\n","ggf. Beendigung Teilnahme im  Zeitraum dieses Nachweises *1\n\n",null,"Bestätigung des Leistungsbezugs  *2\n",null,null,"Ermittlung \nder\nAbrechnungsdaten",null,null,null,null,"Pauschale","Anmerkungen / Hinweise"]
[null,null,"Nachname","Vorname","Datum","Datum","Teiln.-Tage","von","bis","Tage",null,"Beginn",null,"Ende","Tage"]
[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,"Übertrag von Seite 1:",null,null,null,{"$f":"SUM(P38)","v":0}]
[{"$f":"A37+1","v":26},null,null,null,null,null,{"$f":"(DAY(E51)>1)*(MIN(F51+1,DATE(YEAR(E51), MONTH(E51)+1,1))-E51) + 30*MAX(,12*(YEAR(F51)-YEAR(E51))+MONTH(F51)-MONTH(E51)+(DAY(E51)=1)-(DAY(F51+1)>1)) + DAY(F51)*(DAY(F51+1)>1)*(1-(DAY(E51)>1)*(TEXT(E51,\"JJJJMM\")=TEXT(F51,\"JJJJMM\")))","v":0},null,null,{"$f":"(DAY(H51)>1)*(MIN(I51+1,DATE(YEAR(H51), MONTH(H51)+1,1))-H51) + 30*MAX(,12*(YEAR(I51)-YEAR(H51))+MONTH(I51)-MONTH(H51)+(DAY(H51)=1)-(DAY(I51+1)>1)) + DAY(I51)*(DAY(I51+1)>1)*(1-(DAY(H51)>1)*(TEXT(H51,\"JJJJMM\")=TEXT(I51,\"JJJJMM\")))","v":0},{"$f":"IF(H51>=E51,H51,E51)","v":"00:00:00"},{"$f":"IF($H$6>=K51,$H$6,K51)","v":"00:00:00"},{"$f":"IF(I51<=F51,I51,F51)","v":"00:00:00"},{"$f":"IF($Q$6<=M51,$Q$6,M51)","v":"00:00:00"},{"$f":"IF(L51>N51,\"0\",((DAY(L51)>1)*(MIN(N51+1,DATE(YEAR(L51), MONTH(L51)+1,1))-L51) + 30*MAX(,12*(YEAR(N51)-YEAR(L51))+MONTH(N51)-MONTH(L51)+(DAY(L51)=1)-(DAY(N51+1)>1)) + DAY(N51)*(DAY(N51+1)>1)*(1-(DAY(L51)>1)*(TEXT(L51,\"JJJJMM\")=TEXT(N51,\"JJJJMM\")))))","v":0},{"$f":"O51*$H$268/30","v":0}]
[{"$f":"A51+1","v":27},null,null,null,null,null,{"$f":"(DAY(E52)>1)*(MIN(F52+1,DATE(YEAR(E52), MONTH(E52)+1,1))-E52) + 30*MAX(,12*(YEAR(F52)-YEAR(E52))+MONTH(F52)-MONTH(E52)+(DAY(E52)=1)-(DAY(F52+1)>1)) + DAY(F52)*(DAY(F52+1)>1)*(1-(DAY(E52)>1)*(TEXT(E52,\"JJJJMM\")=TEXT(F52,\"JJJJMM\")))","v":0},null,null,{"$f":"(DAY(H52)>1)*(MIN(I52+1,DATE(YEAR(H52), MONTH(H52)+1,1))-H52) + 30*MAX(,12*(YEAR(I52)-YEAR(H52))+MONTH(I52)-MONTH(H52)+(DAY(H52)=1)-(DAY(I52+1)>1)) + DAY(I52)*(DAY(I52+1)>1)*(1-(DAY(H52)>1)*(TEXT(H52,\"JJJJMM\")=TEXT(I52,\"JJJJMM\")))","v":0},"00:00:00","00:00:00","00:00:00","00:00:00",{"$f":"IF(L52>N52,\"0\",((DAY(L52)>1)*(MIN(N52+1,DATE(YEAR(L52), MONTH(L52)+1,1))-L52) + 30*MAX(,12*(YEAR(N52)-YEAR(L52))+MONTH(N52)-MONTH(L52)+(DAY(L52)=1)-(DAY(N52+1)>1)) + DAY(N52)*(DAY(N52+1)>1)*(1-(DAY(L52)>1)*(TEXT(L52,\"JJJJMM\")=TEXT(N52,\"JJJJMM\")))))","v":0},0]
[{"$f":"A52+1","v":28},null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,0]
[29,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,0]
[30,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,0]
[31,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,0]
[32,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,0]
[33,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,0]
[34,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,0]
[35,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,0]
[36,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,0]
[37,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,0]
[38,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,0]
[39,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,0]
[40,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,0]
[41,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,0]
[42,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,0]
[43,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,0]
[44,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,0]
[45,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,0]
[46,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,0]
[47,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,0]
[48,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,0]
[49,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,0]
[50,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,0]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(P76=P114,\"Gesamtsumme:\",\"Zwischensumme\")","v":"Gesamtsumme:"},null,null,null,{"$f":"SUM(P50:P75)","v":0}]
[null,null,null,"Erläuterungen:",null,"Pauschale"]
[null,null,null,"  Pauschalsätze:","2016-01-01",302]
[]
[]
[null,null,null,"*1 Gegenüber der NBank dürfen nur Zeiträume abgerechnet werden, in denen der/die \n     Teilnehmer/in an der Maßnahme teilgenommen hat\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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stand: Juli 2017"]
[]
["lfd. \nNr. ","Aktenzeichen","Teilnehmer/in",null,"Beginn Teilnahme\n*1\n\n","ggf. Beendigung Teilnahme im  Zeitraum dieses Nachweises *1\n\n",null,"Bestätigung des Leistungsbezugs  *2\n",null,null,"Ermittlung \nder\nAbrechnungsdaten",null,null,null,null,"Pauschale","Anmerkungen / Hinweise"]
[null,null,"Nachname","Vorname","Datum","Datum","Teiln.-Tage","von","bis","Tage",null,"Beginn",null,"Ende","Tage"]
[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,"Übertrag von Seite 2:",null,null,null,{"$f":"SUM(P76)","v":0}]
[{"$f":"A75+1","v":51},null,null,null,null,null,{"$f":"(DAY(E89)>1)*(MIN(F89+1,DATE(YEAR(E89), MONTH(E89)+1,1))-E89) + 30*MAX(,12*(YEAR(F89)-YEAR(E89))+MONTH(F89)-MONTH(E89)+(DAY(E89)=1)-(DAY(F89+1)>1)) + DAY(F89)*(DAY(F89+1)>1)*(1-(DAY(E89)>1)*(TEXT(E89,\"JJJJMM\")=TEXT(F89,\"JJJJMM\")))","v":0},null,null,{"$f":"(DAY(H89)>1)*(MIN(I89+1,DATE(YEAR(H89), MONTH(H89)+1,1))-H89) + 30*MAX(,12*(YEAR(I89)-YEAR(H89))+MONTH(I89)-MONTH(H89)+(DAY(H89)=1)-(DAY(I89+1)>1)) + DAY(I89)*(DAY(I89+1)>1)*(1-(DAY(H89)>1)*(TEXT(H89,\"JJJJMM\")=TEXT(I89,\"JJJJMM\")))","v":0},{"$f":"IF(H89>=E89,H89,E89)","v":"00:00:00"},{"$f":"IF($H$6>=K89,$H$6,K89)","v":"00:00:00"},{"$f":"IF(I89<=F89,I89,F89)","v":"00:00:00"},{"$f":"IF($Q$6<=M89,$Q$6,M89)","v":"00:00:00"},{"$f":"IF(L89>N89,\"0\",((DAY(L89)>1)*(MIN(N89+1,DATE(YEAR(L89), MONTH(L89)+1,1))-L89) + 30*MAX(,12*(YEAR(N89)-YEAR(L89))+MONTH(N89)-MONTH(L89)+(DAY(L89)=1)-(DAY(N89+1)>1)) + DAY(N89)*(DAY(N89+1)>1)*(1-(DAY(L89)>1)*(TEXT(L89,\"JJJJMM\")=TEXT(N89,\"JJJJMM\")))))","v":0},{"$f":"O89*$H$268/30","v":0}]
[{"$f":"A89+1","v":52},null,null,null,null,null,{"$f":"(DAY(E90)>1)*(MIN(F90+1,DATE(YEAR(E90), MONTH(E90)+1,1))-E90) + 30*MAX(,12*(YEAR(F90)-YEAR(E90))+MONTH(F90)-MONTH(E90)+(DAY(E90)=1)-(DAY(F90+1)>1)) + DAY(F90)*(DAY(F90+1)>1)*(1-(DAY(E90)>1)*(TEXT(E90,\"JJJJMM\")=TEXT(F90,\"JJJJMM\")))","v":0},null,null,{"$f":"(DAY(H90)>1)*(MIN(I90+1,DATE(YEAR(H90), MONTH(H90)+1,1))-H90) + 30*MAX(,12*(YEAR(I90)-YEAR(H90))+MONTH(I90)-MONTH(H90)+(DAY(H90)=1)-(DAY(I90+1)>1)) + DAY(I90)*(DAY(I90+1)>1)*(1-(DAY(H90)>1)*(TEXT(H90,\"JJJJMM\")=TEXT(I90,\"JJJJMM\")))","v":0},"00:00:00","00:00:00","00:00:00","00:00:00",{"$f":"IF(L90>N90,\"0\",((DAY(L90)>1)*(MIN(N90+1,DATE(YEAR(L90), MONTH(L90)+1,1))-L90) + 30*MAX(,12*(YEAR(N90)-YEAR(L90))+MONTH(N90)-MONTH(L90)+(DAY(L90)=1)-(DAY(N90+1)>1)) + DAY(N90)*(DAY(N90+1)>1)*(1-(DAY(L90)>1)*(TEXT(L90,\"JJJJMM\")=TEXT(N90,\"JJJJMM\")))))","v":0},0]
[{"$f":"A90+1","v":53},null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,0]
[54,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,0]
[55,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,0]
[56,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,0]
[57,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,0]
[58,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,0]
[59,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,0]
[60,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,0]
[61,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,0]
[62,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,0]
[63,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,0]
[64,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,0]
[65,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,0]
[66,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,0]
[67,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,0]
[68,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,0]
[69,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,0]
[70,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,0]
[71,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,0]
[72,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,0]
[73,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,0]
[74,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,0]
[75,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,0]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(P114=P152,\"Gesamtsumme:\",\"Zwischensumme\")","v":"Gesamtsumme:"},null,null,null,{"$f":"SUM(P88:P113)","v":0}]
[null,null,null,"Erläuterungen:",null,"Pauschale"]
[null,null,null,"  Pauschalsätze:","2016-01-01",302]
[]
[]
[null,null,null,"*1 Gegenüber der NBank dürfen nur Zeiträume abgerechnet werden, in denen der/die \n     Teilnehmer/in an der Maßnahme teilgenommen hat\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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stand: Juli 2017"]
[]
["lfd. \nNr. ","Aktenzeichen","Teilnehmer/in",null,"Beginn Teilnahme\n*1\n\n","ggf. Beendigung Teilnahme im  Zeitraum dieses Nachweises *1\n\n",null,"Bestätigung des Leistungsbezugs  *2\n",null,null,"Ermittlung \nder\nAbrechnungsdaten",null,null,null,null,"Pauschale","Anmerkungen / Hinweise"]
[null,null,"Nachname","Vorname","Datum","Datum","Teiln.-Tage","von","bis","Tage",null,"Beginn",null,"Ende","Tage"]
[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,"Übertrag von Seite 3:",null,null,null,{"$f":"SUM(P114)","v":0}]
[{"$f":"A113+1","v":76},null,null,null,null,null,{"$f":"(DAY(E127)>1)*(MIN(F127+1,DATE(YEAR(E127), MONTH(E127)+1,1))-E127) + 30*MAX(,12*(YEAR(F127)-YEAR(E127))+MONTH(F127)-MONTH(E127)+(DAY(E127)=1)-(DAY(F127+1)>1)) + DAY(F127)*(DAY(F127+1)>1)*(1-(DAY(E127)>1)*(TEXT(E127,\"JJJJMM\")=TEXT(F127,\"JJJJMM\")))","v":0},null,null,{"$f":"(DAY(H127)>1)*(MIN(I127+1,DATE(YEAR(H127), MONTH(H127)+1,1))-H127) + 30*MAX(,12*(YEAR(I127)-YEAR(H127))+MONTH(I127)-MONTH(H127)+(DAY(H127)=1)-(DAY(I127+1)>1)) + DAY(I127)*(DAY(I127+1)>1)*(1-(DAY(H127)>1)*(TEXT(H127,\"JJJJMM\")=TEXT(I127,\"JJJJMM\")))","v":0},{"$f":"IF(H127>=E127,H127,E127)","v":"00:00:00"},{"$f":"IF($H$6>=K127,$H$6,K127)","v":"00:00:00"},{"$f":"IF(I127<=F127,I127,F127)","v":"00:00:00"},{"$f":"IF($Q$6<=M127,$Q$6,M127)","v":"00:00:00"},{"$f":"IF(L127>N127,\"0\",((DAY(L127)>1)*(MIN(N127+1,DATE(YEAR(L127), MONTH(L127)+1,1))-L127) + 30*MAX(,12*(YEAR(N127)-YEAR(L127))+MONTH(N127)-MONTH(L127)+(DAY(L127)=1)-(DAY(N127+1)>1)) + DAY(N127)*(DAY(N127+1)>1)*(1-(DAY(L127)>1)*(TEXT(L127,\"JJJJMM\")=TEXT(N127,\"JJJJMM\")))))","v":0},{"$f":"O127*$H$268/30","v":0}]
[{"$f":"A127+1","v":77},null,null,null,null,null,{"$f":"(DAY(E128)>1)*(MIN(F128+1,DATE(YEAR(E128), MONTH(E128)+1,1))-E128) + 30*MAX(,12*(YEAR(F128)-YEAR(E128))+MONTH(F128)-MONTH(E128)+(DAY(E128)=1)-(DAY(F128+1)>1)) + DAY(F128)*(DAY(F128+1)>1)*(1-(DAY(E128)>1)*(TEXT(E128,\"JJJJMM\")=TEXT(F128,\"JJJJMM\")))","v":0},null,null,{"$f":"(DAY(H128)>1)*(MIN(I128+1,DATE(YEAR(H128), MONTH(H128)+1,1))-H128) + 30*MAX(,12*(YEAR(I128)-YEAR(H128))+MONTH(I128)-MONTH(H128)+(DAY(H128)=1)-(DAY(I128+1)>1)) + DAY(I128)*(DAY(I128+1)>1)*(1-(DAY(H128)>1)*(TEXT(H128,\"JJJJMM\")=TEXT(I128,\"JJJJMM\")))","v":0},"00:00:00","00:00:00","00:00:00","00:00:00",{"$f":"IF(L128>N128,\"0\",((DAY(L128)>1)*(MIN(N128+1,DATE(YEAR(L128), MONTH(L128)+1,1))-L128) + 30*MAX(,12*(YEAR(N128)-YEAR(L128))+MONTH(N128)-MONTH(L128)+(DAY(L128)=1)-(DAY(N128+1)>1)) + DAY(N128)*(DAY(N128+1)>1)*(1-(DAY(L128)>1)*(TEXT(L128,\"JJJJMM\")=TEXT(N128,\"JJJJMM\")))))","v":0},0]
[{"$f":"A128+1","v":78},null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,0]
[79,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,0]
[80,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,0]
[81,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,0]
[82,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,0]
[83,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,0]
[84,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,0]
[85,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,0]
[86,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,0]
[87,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,0]
[88,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,0]
[89,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,0]
[90,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,0]
[91,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,0]
[92,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,0]
[93,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,0]
[94,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,0]
[95,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,0]
[96,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,0]
[97,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,0]
[98,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,0]
[99,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,0]
[100,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,0]
[null,null,null,null,null,null,null,null,null,null,null,"Gesamtsumme:",null,null,null,{"$f":"SUM(P126:P151)","v":0}]
[null,null,null,"Erläuterungen:",null,"Pauschale"]
[null,null,null,"  Pauschalsätze:","2016-01-01",302]
[]
[]
[null,null,null,"*1 Gegenüber der NBank dürfen nur Zeiträume abgerechnet werden, in denen der/die \n     Teilnehmer/in an der Maßnahme teilgenommen hat\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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stand: Juli 2017"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Sammelbescheinigung zum Nachweis der Pauschale für Arbeitslosengeldleistungen"]
["Prüfung der Arbeitslosengeldleistungen"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Zeitraum",null,null,"Betrag pro Monat",null,"Pflichtversicherte"]
[null,null,null,"Pauschalbetrag","1)","2016-01-01","2020-12-31",302,null,302]
[]
[]
["bitte auswählen"]
["Förderung der Integration von Frauen in den Arbeitsmarkt (FIFA)"]
["Unterstützung Regionaler Fachkräftebündnisse - Arbeitslosenmaßnahmen"]
["Qualifizierung und Arbeit (QuA)"]
["Innovative Bildungsprojekte der beruflichen Erstausbildung "]
[]
[]
[]
["ALG II - familienversichert"]
["ALG II - pflichtversichert"]
["ALG I"]

{"sheet":"Einverständnis TN Version 1","index":1,"n_rows":31,"n_cols":5,"rows_kept":31,"cut":false,"hidden":false,"merged":[[3,3,3,5],[4,3,4,5],[5,3,5,5]]}
["Einverständniserklärung der Teilnehmer/innen zur"]
["Weitergabe persönlicher Daten an die NBank"]
[]
["Name der/des Teilnehmerin/Teilnehmers:"]
[null,null,"durchführender Bildungsträger:"]
[null,null,"Maßnahmetitel:"]
[]
["Hiermit erkläre ich mich einverstanden, dass das JobCenter / die Agentur für Arbeit"]
["folgende Informationen über den Bildungsträger 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"]
[]
["c) Angaben, ob ich während der Dauer der o.g. Maßnahme pflicht- oder familienversichert "]
["gewesen bin"]
[]
["Die erhobenen Daten dienen ausschließlich zur Abrechnung der von der Europäischen Union"]
["geförderten 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":2,"n_rows":43,"n_cols":4,"rows_kept":43,"cut":false,"hidden":false,"merged":[[3,2,3,3],[4,2,4,3]]}
["Einverständniserklärung der Teilnehmer/innen zur"]
["Weitergabe persönlicher Daten an die NBank"]
[]
[null,"durchführender Bildungsträger:"]
[null,"Maßnahmetitel:"]
[]
["Hiermit erkläre ich mich einverstanden, dass das JobCenter / die Agentur für Arbeit"]
["folgende Informationen über den Bildungsträger 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"]
[]
["c) Angaben, ob ich während der Dauer der o.g. Maßnahme pflicht- oder familienversichert "]
["gewesen bin"]
[]
["Die erhobenen Daten dienen ausschließlich zur Abrechnung der von der Europäischen Union"]
["geförderten Maßnahme und werden nicht an Dritte weitergegeben"]
[]
["lfd. Nr. ","Name","Vorname","Unterschrift"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Hinweis: Die Einverständniserklärung verbleibt beim Jobcenter / der Agentur für Arbeit"]