{"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":2,"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":283,"n_cols":24,"rows_kept":283,"cut":false,"hidden":false,"merged":[[194,20,194,23],[195,20,195,23],[196,20,196,23],[197,20,197,23],[198,20,198,23],[199,20,199,23],[200,20,200,23],[201,11,201,14],[185,20,185,23],[186,20,186,23],[187,20,187,23],[188,20,188,23],[189,20,189,23],[190,20,190,23],[191,20,191,23],[192,20,192,23],[193,20,193,23],[176,20,176,23],[177,20,177,23],[178,20,178,23],[179,20,179,23],[180,20,180,23],[181,20,181,23],[182,20,182,23],[183,20,183,23],[184,20,184,23],[173,0,175,0],[173,1,175,1],[173,2,173,3],[173,7,173,8],[173,10,173,14],[173,18,175,18],[173,20,175,23],[174,2,175,2],[174,3,175,3],[174,4,175,4],[174,5,175,5],[174,6,175,6],[174,7,175,7],[174,8,175,8],[174,9,175,9],[174,11,175,11],[174,13,175,13],[174,14,175,14],[42,3,42,18],[108,20,108,23],[142,20,142,23],[149,20,149,23],[124,20,126,23],[127,20,127,23],[128,20,128,23],[129,20,129,23],[130,20,130,23],[135,20,135,23],[136,20,136,23],[137,20,137,23],[141,20,141,23],[138,20,138,23],[139,20,139,23],[140,20,140,23],[133,20,133,23],[134,20,134,23],[131,20,131,23],[132,20,132,23],[90,20,90,23],[114,20,114,23],[96,20,96,23],[97,20,97,23],[98,20,98,23],[99,20,99,23],[100,20,100,23],[101,20,101,23],[112,20,112,23],[113,20,113,23],[102,20,102,23],[150,20,150,23],[151,20,151,23],[103,20,103,23],[104,20,104,23],[105,20,105,23],[106,20,106,23],[107,20,107,23],[152,20,152,23],[143,20,143,23],[144,20,144,23],[145,20,145,23],[146,20,146,23],[147,20,147,23],[148,20,148,23],[109,20,109,23],[110,20,110,23],[111,20,111,23],[91,20,91,23],[92,20,92,23],[93,20,93,23],[94,20,94,23],[95,20,95,23],[61,20,61,23],[62,20,62,23],[63,20,63,23],[64,20,64,23],[65,20,65,23],[66,20,66,23],[67,20,67,23],[68,20,68,23],[69,20,69,23],[70,20,70,23],[71,20,71,23],[72,20,72,23],[73,20,73,23],[74,20,74,23],[75,20,75,23],[86,20,88,23],[89,20,89,23],[76,20,76,23],[52,20,52,23],[53,20,53,23],[54,20,54,23],[55,20,55,23],[56,20,56,23],[57,20,57,23],[58,20,58,23],[59,20,59,23],[60,20,60,23],[30,20,30,23],[31,20,31,23],[32,20,32,23],[33,20,33,23],[34,20,34,23],[35,20,35,23],[36,20,36,23],[48,20,50,23],[51,20,51,23],[154,11,154,14],[124,18,126,18],[127,11,127,14],[153,11,153,14],[154,0,155,1],[9,20,11,23],[12,20,12,23],[13,20,13,23],[14,20,14,23],[15,20,15,23],[16,20,16,23],[17,20,17,23],[18,20,18,23],[19,20,19,23],[20,20,20,23],[21,20,21,23],[22,20,22,23],[23,20,23,23],[24,20,24,23],[25,20,25,23],[26,20,26,23],[27,20,27,23],[28,20,28,23],[29,20,29,23],[124,0,126,0],[124,1,126,1],[124,2,124,3],[124,7,124,8],[124,10,124,14],[125,8,126,8],[125,9,126,9],[125,2,126,2],[125,3,126,3],[125,4,126,4],[125,5,126,5],[125,6,126,6],[125,7,126,7],[125,14,126,14],[48,1,50,1],[49,8,50,8],[85,0,85,3],[49,3,50,3],[86,7,86,8],[9,18,11,18],[87,8,88,8],[77,11,77,14],[48,7,48,8],[51,11,51,14],[10,6,11,6],[37,11,37,14],[49,14,50,14],[49,11,50,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],[48,18,50,18],[43,3,43,17],[44,3,44,17],[45,3,45,17],[268,4,268,6],[10,5,11,5],[86,0,88,0],[86,1,88,1],[78,11,78,14],[269,9,269,10],[86,2,86,3],[10,7,11,7],[49,2,50,2],[49,13,50,13],[48,10,48,14],[125,11,126,11],[125,13,126,13],[123,0,123,3],[78,0,79,1],[49,5,50,5],[49,6,50,6],[49,7,50,7],[49,9,50,9],[86,10,86,14],[115,11,115,14],[49,4,50,4],[116,0,117,1],[48,2,48,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,17,5,18],[5,7,5,8],[158,3,159,14],[4,7,4,22],[120,3,121,14],[82,3,83,14],[122,0,122,2],[160,0,160,2],[84,0,84,2],[46,0,46,2],[87,7,88,7],[87,9,88,9],[89,11,89,14],[87,14,88,14],[116,11,116,14],[86,18,88,18],[87,2,88,2],[87,3,88,3],[87,4,88,4],[87,5,88,5],[87,6,88,6],[87,11,88,11],[87,13,88,13],[48,0,50,0]]}
[0]
["Sammelbescheinigung zum Nachweis der Pauschale für Leistungen nach dem Asylbewerberleistungsgesetz"]
["Zur Abrechnung gegenüber der NBank:"]
[]
["Zuständige Behörde/Kostenträger:",null,null,null,"Förderprogramm:              ",null,null,"bitte auswählen"]
["Bildungseinrichtung:",null,null,null,"         Abrechnungszeitraum vom:   "]
[null,null,null,null,"  Antragsnummer NBank:       ",null,null,null,null,null,null,null,null,null,null,null,null,null,"Zuwendungsbescheid NBank vom:  "]
[]
[{"$f":"IF(U7>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","Teilnehmende",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,"Geburtsdatum*3","Alter","Wohnhaft in Erstaufnahme-einrichtung?*4","Pauschale\n","Anteil","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":"IF(AND(E13>0,F13>0),DAYS360(E13+1,F13+1,TRUE)+1,0)","v":0},null,null,{"$f":"IF(AND(H13>0,I13>0),DAYS360(E13+1,F13+1,TRUE)+1,0)","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($R$6<=M13,$R$6,M13)","v":"00:00:00"},{"$f":"IF(AND(L13>0,N13>0,E13>0,F13>0),DAYS360(L13,N13+1,TRUE),0)","v":0},null,{"$f":"IF(P13=0,0,DATEDIF(P13,TODAY(),\"Y\"))","v":0},"bitte auswählen",{"$f":"IF(AND(Q13>=15,Q13<=65,R13=\"nein\",O13>0),ROUND(1/30*O13,2)*$F$40,0)","v":0},{"$f":"IF(S13=0,0,ROUND(1/30*O13,2))","v":0}]
[{"$f":"A13+1","v":2},null,null,null,null,null,{"$f":"IF(AND(E14>0,F14>0),DAYS360(E14+1,F14+1,TRUE)+1,0)","v":0},null,null,0,{"$f":"IF(H14>=E14,H14,E14)","v":"00:00:00"},{"$f":"IF($H$6>=K14,$H$6,K14)","v":"00:00:00"},{"$f":"IF(I14<=F14,I14,F14)","v":"00:00:00"},{"$f":"IF($R$6<=M14,$R$6,M14)","v":"00:00:00"},{"$f":"IF(AND(L14>0,N14>0,E14>0,F14>0),DAYS360(L14,N14+1,TRUE),0)","v":0},null,{"$f":"IF(P14=0,0,DATEDIF(P14,TODAY(),\"Y\"))","v":0},"bitte auswählen",{"$f":"IF(AND(Q14>=15,Q14<=65,R14=\"nein\",O14>0),ROUND(1/30*O14,2)*$F$40,0)","v":0},{"$f":"IF(S14=0,0,ROUND(1/30*O14,2))","v":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,null,0,"bitte auswählen",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,null,0,"bitte auswählen",0,0]
[5,null,null,null,null,null,0,null,null,0,{"$f":"IF(H17>=E17,H17,E17)","v":"00:00:00"},{"$f":"IF($H$6>=K17,$H$6,K17)","v":"00:00:00"},{"$f":"IF(I17<=F17,I17,F17)","v":"00:00:00"},"00:00:00",0,null,0,"bitte auswählen",0,0]
[6,null,null,null,null,null,0,null,null,0,"00:00:00",{"$f":"IF($H$6>=K18,$H$6,K18)","v":"00:00:00"},"00:00:00","00:00:00",0,null,0,"bitte auswählen",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,null,0,"bitte auswählen",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,null,0,"bitte auswählen",0,0]
[9,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00",{"$f":"IF($R$6<=M21,$R$6,M21)","v":"00:00:00"},0,null,0,"bitte auswählen",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,null,0,"bitte auswählen",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,null,0,"bitte auswählen",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,null,0,"bitte auswählen",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,null,0,"bitte auswählen",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,null,0,"bitte auswählen",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,null,0,"bitte auswählen",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,null,0,"bitte auswählen",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,null,0,"bitte auswählen",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,null,0,"bitte auswählen",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,null,0,"bitte auswählen",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,null,0,"bitte auswählen",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,null,0,"bitte auswählen",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,null,0,"bitte auswählen",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,null,0,"bitte auswählen",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,null,0,"bitte auswählen",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,null,0,"bitte auswählen",0,0]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(S38=S78,\"Gesamtsumme:\",\"Zwischensumme\")","v":"Gesamtsumme:"},null,null,null,null,null,"Gesamt",{"$f":"SUM(S13:S37)","v":0},{"$f":"SUM(T13:T37)","v":0}]
[null,null,null,"Erläuterungen:"]
[null,null,null,"Standardeinheitskostensatz","ab 02.03.2022",329]
[]
[]
[null,null,null,"*1 Gegenüber der NBank dürfen nur Zeiträume abgerechnet werden, in denen oben aufgeführten Personen an der Maßnahme teilgenommen haben."]
[null,null,null,"*2 Zeiten vor Beginn oder nach Ende der Maßnahme dürfen nicht angegeben werden."]
[null,null,null,"*3 Nur für Teilnehmende/Leistungsbeziehende im Alter zwischen 15 und 65 Jahren kann der Pauschalsatz anerkannt werden."]
[null,null,null,"*4 Nur für Teilnehmende/Leistungsbeziehende, die nicht in einer Erstaufnahmeeinrichtung wohnen, kann der Pauschalersatz anerkannt werden."]
["Datum,  Stempel  /  Unterschrift der zuständigen Behörde/ des zuständigen Kostenträgers"]
[]
["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,null,null,null,"Pauschale",null,"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,null,null,null,{"$f":"SUM(S38)","v":0}]
[{"$f":"A37+1","v":26},null,null,null,null,null,{"$f":"(DAY(E53)>1)*(MIN(F53+1,DATE(YEAR(E53), MONTH(E53)+1,1))-E53) + 30*MAX(,12*(YEAR(F53)-YEAR(E53))+MONTH(F53)-MONTH(E53)+(DAY(E53)=1)-(DAY(F53+1)>1)) + DAY(F53)*(DAY(F53+1)>1)*(1-(DAY(E53)>1)*(TEXT(E53,\"JJJJMM\")=TEXT(F53,\"JJJJMM\")))","v":0},null,null,{"$f":"(DAY(H53)>1)*(MIN(I53+1,DATE(YEAR(H53), MONTH(H53)+1,1))-H53) + 30*MAX(,12*(YEAR(I53)-YEAR(H53))+MONTH(I53)-MONTH(H53)+(DAY(H53)=1)-(DAY(I53+1)>1)) + DAY(I53)*(DAY(I53+1)>1)*(1-(DAY(H53)>1)*(TEXT(H53,\"JJJJMM\")=TEXT(I53,\"JJJJMM\")))","v":0},{"$f":"IF(H53>=E53,H53,E53)","v":"00:00:00"},{"$f":"IF($H$6>=K53,$H$6,K53)","v":"00:00:00"},{"$f":"IF(I53<=F53,I53,F53)","v":"00:00:00"},{"$f":"IF($R$6<=M53,$R$6,M53)","v":"00:00:00"},{"$f":"IF(L53>N53,\"0\",((DAY(L53)>1)*(MIN(N53+1,DATE(YEAR(L53), MONTH(L53)+1,1))-L53) + 30*MAX(,12*(YEAR(N53)-YEAR(L53))+MONTH(N53)-MONTH(L53)+(DAY(L53)=1)-(DAY(N53+1)>1)) + DAY(N53)*(DAY(N53+1)>1)*(1-(DAY(L53)>1)*(TEXT(L53,\"JJJJMM\")=TEXT(N53,\"JJJJMM\")))))","v":0},null,null,null,{"$f":"O53*$H$270/30","v":0}]
[{"$f":"A53+1","v":27},null,null,null,null,null,0,null,null,{"$f":"(DAY(H54)>1)*(MIN(I54+1,DATE(YEAR(H54), MONTH(H54)+1,1))-H54) + 30*MAX(,12*(YEAR(I54)-YEAR(H54))+MONTH(I54)-MONTH(H54)+(DAY(H54)=1)-(DAY(I54+1)>1)) + DAY(I54)*(DAY(I54+1)>1)*(1-(DAY(H54)>1)*(TEXT(H54,\"JJJJMM\")=TEXT(I54,\"JJJJMM\")))","v":0},"00:00:00","00:00:00","00:00:00","00:00:00",{"$f":"IF(L54>N54,\"0\",((DAY(L54)>1)*(MIN(N54+1,DATE(YEAR(L54), MONTH(L54)+1,1))-L54) + 30*MAX(,12*(YEAR(N54)-YEAR(L54))+MONTH(N54)-MONTH(L54)+(DAY(L54)=1)-(DAY(N54+1)>1)) + DAY(N54)*(DAY(N54+1)>1)*(1-(DAY(L54)>1)*(TEXT(L54,\"JJJJMM\")=TEXT(N54,\"JJJJMM\")))))","v":0},null,null,null,0]
[{"$f":"A54+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,null,null,null,0]
[29,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,null,null,null,0]
[30,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,null,null,null,0]
[31,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,null,null,null,0]
[32,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,null,null,null,0]
[33,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,null,null,null,0]
[34,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,null,null,null,0]
[35,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,null,null,null,0]
[36,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,null,null,null,0]
[37,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,null,null,null,0]
[38,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,null,null,null,0]
[39,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,null,null,null,0]
[40,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,null,null,null,0]
[41,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,null,null,null,0]
[42,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,null,null,null,0]
[43,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,null,null,null,0]
[44,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,null,null,null,0]
[45,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,null,null,null,0]
[46,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,null,null,null,0]
[47,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,null,null,null,0]
[48,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,null,null,null,0]
[49,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,null,null,null,0]
[50,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(S78=S116,\"Gesamtsumme:\",\"Zwischensumme\")","v":"Gesamtsumme:"},null,null,null,null,null,null,{"$f":"SUM(S52:S77)","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,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,null,null,null,"Pauschale",null,"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,null,null,null,{"$f":"SUM(S78)","v":0}]
[{"$f":"A77+1","v":51},null,null,null,null,null,{"$f":"(DAY(E91)>1)*(MIN(F91+1,DATE(YEAR(E91), MONTH(E91)+1,1))-E91) + 30*MAX(,12*(YEAR(F91)-YEAR(E91))+MONTH(F91)-MONTH(E91)+(DAY(E91)=1)-(DAY(F91+1)>1)) + DAY(F91)*(DAY(F91+1)>1)*(1-(DAY(E91)>1)*(TEXT(E91,\"JJJJMM\")=TEXT(F91,\"JJJJMM\")))","v":0},null,null,{"$f":"(DAY(H91)>1)*(MIN(I91+1,DATE(YEAR(H91), MONTH(H91)+1,1))-H91) + 30*MAX(,12*(YEAR(I91)-YEAR(H91))+MONTH(I91)-MONTH(H91)+(DAY(H91)=1)-(DAY(I91+1)>1)) + DAY(I91)*(DAY(I91+1)>1)*(1-(DAY(H91)>1)*(TEXT(H91,\"JJJJMM\")=TEXT(I91,\"JJJJMM\")))","v":0},{"$f":"IF(H91>=E91,H91,E91)","v":"00:00:00"},{"$f":"IF($H$6>=K91,$H$6,K91)","v":"00:00:00"},{"$f":"IF(I91<=F91,I91,F91)","v":"00:00:00"},{"$f":"IF($R$6<=M91,$R$6,M91)","v":"00:00:00"},{"$f":"IF(L91>N91,\"0\",((DAY(L91)>1)*(MIN(N91+1,DATE(YEAR(L91), MONTH(L91)+1,1))-L91) + 30*MAX(,12*(YEAR(N91)-YEAR(L91))+MONTH(N91)-MONTH(L91)+(DAY(L91)=1)-(DAY(N91+1)>1)) + DAY(N91)*(DAY(N91+1)>1)*(1-(DAY(L91)>1)*(TEXT(L91,\"JJJJMM\")=TEXT(N91,\"JJJJMM\")))))","v":0},null,null,null,{"$f":"O91*$H$270/30","v":0}]
[{"$f":"A91+1","v":52},null,null,null,null,null,0,null,null,{"$f":"(DAY(H92)>1)*(MIN(I92+1,DATE(YEAR(H92), MONTH(H92)+1,1))-H92) + 30*MAX(,12*(YEAR(I92)-YEAR(H92))+MONTH(I92)-MONTH(H92)+(DAY(H92)=1)-(DAY(I92+1)>1)) + DAY(I92)*(DAY(I92+1)>1)*(1-(DAY(H92)>1)*(TEXT(H92,\"JJJJMM\")=TEXT(I92,\"JJJJMM\")))","v":0},"00:00:00","00:00:00","00:00:00","00:00:00",{"$f":"IF(L92>N92,\"0\",((DAY(L92)>1)*(MIN(N92+1,DATE(YEAR(L92), MONTH(L92)+1,1))-L92) + 30*MAX(,12*(YEAR(N92)-YEAR(L92))+MONTH(N92)-MONTH(L92)+(DAY(L92)=1)-(DAY(N92+1)>1)) + DAY(N92)*(DAY(N92+1)>1)*(1-(DAY(L92)>1)*(TEXT(L92,\"JJJJMM\")=TEXT(N92,\"JJJJMM\")))))","v":0},null,null,null,0]
[{"$f":"A92+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,null,null,null,0]
[54,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,null,null,null,0]
[55,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,null,null,null,0]
[56,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,null,null,null,0]
[57,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,null,null,null,0]
[58,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,null,null,null,0]
[59,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,null,null,null,0]
[60,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,null,null,null,0]
[61,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,null,null,null,0]
[62,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,null,null,null,0]
[63,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,null,null,null,0]
[64,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,null,null,null,0]
[65,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,null,null,null,0]
[66,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,null,null,null,0]
[67,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,null,null,null,0]
[68,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,null,null,null,0]
[69,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,null,null,null,0]
[70,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,null,null,null,0]
[71,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,null,null,null,0]
[72,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,null,null,null,0]
[73,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,null,null,null,0]
[74,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,null,null,null,0]
[75,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(S116=S154,\"Gesamtsumme:\",\"Zwischensumme\")","v":"Gesamtsumme:"},null,null,null,null,null,null,{"$f":"SUM(S90:S115)","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,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,null,null,null,"Pauschale",null,"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,null,null,null,{"$f":"SUM(S116)","v":0}]
[{"$f":"A115+1","v":76},null,null,null,null,null,{"$f":"(DAY(E129)>1)*(MIN(F129+1,DATE(YEAR(E129), MONTH(E129)+1,1))-E129) + 30*MAX(,12*(YEAR(F129)-YEAR(E129))+MONTH(F129)-MONTH(E129)+(DAY(E129)=1)-(DAY(F129+1)>1)) + DAY(F129)*(DAY(F129+1)>1)*(1-(DAY(E129)>1)*(TEXT(E129,\"JJJJMM\")=TEXT(F129,\"JJJJMM\")))","v":0},null,null,{"$f":"(DAY(H129)>1)*(MIN(I129+1,DATE(YEAR(H129), MONTH(H129)+1,1))-H129) + 30*MAX(,12*(YEAR(I129)-YEAR(H129))+MONTH(I129)-MONTH(H129)+(DAY(H129)=1)-(DAY(I129+1)>1)) + DAY(I129)*(DAY(I129+1)>1)*(1-(DAY(H129)>1)*(TEXT(H129,\"JJJJMM\")=TEXT(I129,\"JJJJMM\")))","v":0},{"$f":"IF(H129>=E129,H129,E129)","v":"00:00:00"},{"$f":"IF($H$6>=K129,$H$6,K129)","v":"00:00:00"},{"$f":"IF(I129<=F129,I129,F129)","v":"00:00:00"},{"$f":"IF($R$6<=M129,$R$6,M129)","v":"00:00:00"},{"$f":"IF(L129>N129,\"0\",((DAY(L129)>1)*(MIN(N129+1,DATE(YEAR(L129), MONTH(L129)+1,1))-L129) + 30*MAX(,12*(YEAR(N129)-YEAR(L129))+MONTH(N129)-MONTH(L129)+(DAY(L129)=1)-(DAY(N129+1)>1)) + DAY(N129)*(DAY(N129+1)>1)*(1-(DAY(L129)>1)*(TEXT(L129,\"JJJJMM\")=TEXT(N129,\"JJJJMM\")))))","v":0},null,null,null,{"$f":"O129*$H$270/30","v":0}]
[{"$f":"A129+1","v":77},null,null,null,null,null,0,null,null,{"$f":"(DAY(H130)>1)*(MIN(I130+1,DATE(YEAR(H130), MONTH(H130)+1,1))-H130) + 30*MAX(,12*(YEAR(I130)-YEAR(H130))+MONTH(I130)-MONTH(H130)+(DAY(H130)=1)-(DAY(I130+1)>1)) + DAY(I130)*(DAY(I130+1)>1)*(1-(DAY(H130)>1)*(TEXT(H130,\"JJJJMM\")=TEXT(I130,\"JJJJMM\")))","v":0},"00:00:00","00:00:00","00:00:00","00:00:00",{"$f":"IF(L130>N130,\"0\",((DAY(L130)>1)*(MIN(N130+1,DATE(YEAR(L130), MONTH(L130)+1,1))-L130) + 30*MAX(,12*(YEAR(N130)-YEAR(L130))+MONTH(N130)-MONTH(L130)+(DAY(L130)=1)-(DAY(N130+1)>1)) + DAY(N130)*(DAY(N130+1)>1)*(1-(DAY(L130)>1)*(TEXT(L130,\"JJJJMM\")=TEXT(N130,\"JJJJMM\")))))","v":0},null,null,null,0]
[{"$f":"A130+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,null,null,null,0]
[79,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,null,null,null,0]
[80,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,null,null,null,0]
[81,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,null,null,null,0]
[82,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,null,null,null,0]
[83,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,null,null,null,0]
[84,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,null,null,null,0]
[85,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,null,null,null,0]
[86,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,null,null,null,0]
[87,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,null,null,null,0]
[88,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,null,null,null,0]
[89,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,null,null,null,0]
[90,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,null,null,null,0]
[91,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,null,null,null,0]
[92,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,null,null,null,0]
[93,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,null,null,null,0]
[94,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,null,null,null,0]
[95,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,null,null,null,0]
[96,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,null,null,null,0]
[97,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,null,null,null,0]
[98,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,null,null,null,0]
[99,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,null,null,null,0]
[100,null,null,null,null,null,0,null,null,0,"00:00:00","00:00:00","00:00:00","00:00:00",0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,"Gesamtsumme:",null,null,null,null,null,null,{"$f":"SUM(S128:S153)","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,null,null,null,null,"Stand: Juli 2017"]
[]
[]
[]
[]
[]
[]
[]
["bitte auswählen"]
["ja"]
["nein"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Zeitraum",null,null,"Betrag pro Monat",null,"Pflichtversicherte"]
[null,null,null,"Pauschalbetrag","1)","2016-01-01","2020-12-31",329,null,329]
[]
[]
["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":"Einverständnis TN Version 1","index":1,"n_rows":30,"n_cols":5,"rows_kept":30,"cut":false,"hidden":false,"merged":[[6,0,6,2],[11,0,11,6],[3,3,3,5],[4,3,4,5],[5,3,5,5],[3,0,3,2],[4,0,4,2],[5,0,5,2]]}
["Einverständniserklärung der teilnehmenden Person zur"]
["Weitergabe persönlicher Daten an die NBank"]
[]
["Name der teilnehmenden Person:"]
["durchführende Bildungseinrichtung:"]
["Projektbezeichnung/Projekttitel:"]
["Antragsnummer:",null,null,null,{"$f":"Sammelbescheinigung!H7","v":0}]
[]
["Hiermit erkläre ich mich einverstanden, dass die zuständige Behörde/ der zuständige Kostenträger"]
["folgende Informationen über die Bildungseinrichtung an die NBank weiterleitet:"]
[]
["a) Angaben zur Person (Name, Vorname, Aktenzeichen sowie Geburtsdatum und Hinweise zum Wohnort)"]
[]
["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ßnahme und werden nicht an Dritte weitergegeben"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Unterschrift "]
[]
[]
[]
["Hinweis: Die Einverständniserklärung verbleibt bei der zuständigen Behörde/dem Kostenträger "]

{"sheet":"Einverständnis TN Version 2","index":2,"n_rows":42,"n_cols":4,"rows_kept":42,"cut":false,"hidden":false,"merged":[[41,0,41,3],[5,0,5,1],[5,2,5,3],[3,2,3,3],[4,2,4,3],[4,0,4,1],[3,0,3,1],[10,0,10,6]]}
["Einverständniserklärung der teilnehmenden Person zur"]
["Weitergabe persönlicher Daten an die NBank"]
[]
["durchführende Bildungseinrichtung:"]
["Projektbezeichnung/Projekttitel:"]
["Antragsnummer:",null,{"$f":"Sammelbescheinigung!H7","v":0}]
[]
["Hiermit erkläre ich mich einverstanden, dass die zuständige Behörde/der zuständige Kostenträger"]
["folgende Informationen über die Bildungseinrichtung an die NBank weiterleitet:"]
[]
["a) Angaben zur Person (Name, Vorname, Aktenzeichen sowie Geburtsdatum und Hinweise zum Wohnort)"]
[]
["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ßnahme und werden nicht an Dritte weitergegeben"]
[]
["lfd. Nr. ","Name","Vorname","Unterschrift"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Hinweis: Die Einverständniserklärung verbleibt bei der zuständigen Behörde/dem Kostenträger."]