{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["TNL","ABN","RS LK","RS AK","Data"],"not_rendered":{"charts":0,"images":8,"macros":1,"external_links":0,"defined_names":5,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"TNL","index":0,"n_rows":55,"n_cols":34,"rows_kept":55,"cut":false,"hidden":false,"merged":[[2,2,3,16],[53,2,53,20],[54,2,54,9],[54,11,54,18],[54,19,54,20],[11,24,12,24],[11,25,12,25],[11,26,12,26],[9,24,10,26],[49,4,49,7],[49,11,49,13],[48,2,49,2],[48,4,48,7],[48,11,48,13],[48,15,48,18],[48,19,49,19],[48,8,49,9],[42,11,42,13],[42,15,42,18],[42,19,43,19],[43,4,43,7],[45,4,45,7],[42,8,43,9],[43,15,43,18],[7,28,7,32],[9,8,9,9],[10,8,11,9],[11,15,11,18],[13,4,13,7],[13,15,13,18],[9,15,9,18],[46,2,47,2],[46,4,46,7],[46,11,46,13],[46,15,46,18],[46,19,47,19],[47,11,47,13],[47,4,47,7],[46,8,47,9],[44,2,45,2],[44,4,44,7],[44,11,44,13],[44,15,44,18],[44,19,45,19],[44,20,45,20],[44,8,45,9],[42,2,43,2],[42,4,42,7],[45,15,45,18],[43,11,43,13],[45,11,45,13],[40,2,41,2],[40,4,40,7],[40,11,40,13],[40,15,40,18],[40,19,41,19],[40,20,41,20],[38,2,39,2],[38,4,38,7],[38,11,38,13],[38,15,38,18],[38,19,39,19],[41,4,41,7],[38,8,39,9],[40,8,41,9],[39,4,39,7],[39,11,39,13],[41,11,41,13],[36,2,37,2],[36,4,36,7],[36,11,36,13],[36,15,36,18],[36,19,37,19],[36,20,37,20],[34,2,35,2],[34,4,34,7],[34,11,34,13],[34,15,34,18],[34,19,35,19],[34,8,35,9],[36,8,37,9],[35,4,35,7],[37,4,37,7],[35,11,35,13],[37,11,37,13],[34,20,35,20],[32,2,33,2],[32,4,32,7],[32,11,32,13],[32,15,32,18],[32,19,33,19],[32,20,33,20],[30,8,31,9],[32,8,33,9],[30,2,31,2],[30,4,30,7],[30,11,30,13],[30,15,30,18],[30,19,31,19],[31,15,31,18],[33,15,33,18],[31,4,31,7],[33,4,33,7],[31,11,31,13],[33,11,33,13],[28,2,29,2],[28,4,28,7],[28,11,28,13],[28,15,28,18],[28,19,29,19],[28,20,29,20],[26,2,27,2],[26,4,26,7],[26,11,26,13],[26,15,26,18],[26,19,27,19],[27,4,27,7],[27,11,27,13],[26,8,27,9],[28,8,29,9],[27,15,27,18],[29,15,29,18],[29,4,29,7],[29,11,29,13],[24,2,25,2],[24,4,24,7],[24,11,24,13],[24,15,24,18],[24,19,25,19],[24,20,25,20],[22,2,23,2],[22,4,22,7],[22,11,22,13],[22,15,22,18],[22,19,23,19],[23,4,23,7],[25,4,25,7],[22,8,23,9],[24,8,25,9],[23,15,23,18],[25,15,25,18],[23,11,23,13],[25,11,25,13],[20,2,21,2],[20,4,20,7],[20,11,20,13],[20,15,20,18],[20,19,21,19],[20,20,21,20],[18,8,19,9],[20,8,21,9],[18,2,19,2],[18,4,18,7],[18,11,18,13],[18,15,18,18],[18,19,19,19],[19,4,19,7],[21,4,21,7],[19,11,19,13],[21,11,21,13],[18,20,19,20],[19,15,19,18],[21,15,21,18],[2,20,3,20],[10,19,11,19],[10,20,11,20],[47,15,47,18],[49,15,49,18],[12,19,13,19],[12,20,13,20],[12,4,12,7],[12,11,12,13],[12,15,12,18],[12,8,13,9],[7,2,7,4],[5,6,5,11],[7,6,7,11],[9,4,9,7],[4,13,4,16],[5,13,5,16],[6,13,6,16],[7,13,7,16],[6,10,6,11],[5,18,5,19],[6,18,6,20],[7,18,7,20],[17,15,17,18],[12,2,13,2],[35,15,35,18],[37,15,37,18],[39,15,39,18],[41,15,41,18],[4,18,4,19],[16,2,17,2],[16,4,16,7],[16,11,16,13],[16,15,16,18],[16,19,17,19],[14,2,15,2],[6,7,6,8],[4,6,4,11],[9,11,9,13],[14,19,15,19],[17,4,17,7],[15,11,15,13],[17,11,17,13],[15,4,15,7],[15,15,15,18],[4,2,4,4],[5,2,5,4],[6,2,6,4],[52,19,52,20],[10,4,10,7],[10,11,10,13],[10,15,10,18],[51,19,51,20],[16,20,17,20],[14,8,15,9],[16,8,17,9],[38,20,39,20],[42,20,43,20],[51,2,52,18],[11,4,11,7],[11,11,11,13],[13,11,13,13],[46,20,47,20],[48,20,49,20],[14,20,15,20],[22,20,23,20],[26,20,27,20],[30,20,31,20],[10,2,11,2],[14,4,14,7],[14,11,14,13],[14,15,14,18]]}
[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(AA3:AA9)","v":0},{"$f":"IF(X1<>0,VLOOKUP(X1,AC3:AE6,3,FALSE),\"\")","v":""},{"$f":"IF(K7<>\"\",CONCATENATE(TEXT(K7,\"JJ\"),\"\"),IF(K7<>\"\",\"Kein Eintrag\",\"\"))","v":""}]
[]
[null,null,"Teilnehmerliste – RUND-Leiter | RUND-Ausbilder",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G5<>\"RUND-Leiter\",\"\",\"X\")","v":""}," RUND-Grundkurs",null,{"$f":"IF(X3<>\"\",1,\"\")","v":""},null,1,"RUND-Leiter",353,16,1460,{"$f":"IF($K$7<>\"\",$K$7+AG3,0)","v":"00:00:00"}]
[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,2,"RUND-Ausbilder",383,4,1460,{"$f":"IF($K$7<>\"\",$K$7+AG4,0)","v":"00:00:00"}]
[null,null," Lehrgangstitel",null,null,null,null,null,null,null,null,null,null," Name und Nr. der Gliederung",null,null,null,null,null,null,null,null,null,{"$f":"IF(G5<>\"RUND-Ausbilder\",\"\",\"X\")","v":""}," RUND-Aufbaukurs",null,{"$f":"IF(X5<>\"\",2,\"\")","v":""},null,3,"Sanitätsausbildung C",333,{"$f":"IF(AC1<>\"\",AC1,24)","v":24},1460,"00:00:00"]
[null,null," Lehrgangs-Nummer",null,null,null,null,null,null,null,null,null,null," Name und Nr. des Ausbilders",null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"Sanitätsfortbildung",341,{"$f":"IF(AC1<>\"\",AC1,10)","v":10},1460,"00:00:00"]
[null,null," Lehrgangsdatum",null,null,null,"vom",null,null,"bis",null,null,null," Name des Ausbildungshelfers",null,null,null,null,null,null,null,null,null,null," Sanitätsfortbildung",null,{"$f":"IF(X7<>\"\",4,\"\")","v":""}]
[null,null," Lehrgangsort",null,null,null,null,null,null,null,null,null,null," Name des Hospitanten/Assistenten"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," Sanitätsausbildung C",null,{"$f":"IF(X9<>\"\",3,\"\")","v":""}]
[null,null,"Lfd.\nNr.",null,"Name\nVorname",null,null,null,"Geburts-\ndatum",null,null,"Straße und Hausnummer\nPLZ und Wohnort",null,null,null,"Telefon\nE-Mail",null,null,null," Reg.-Nr."," Unterschrift des\n Teilnehmers",null,null,null,"Lfd-Nr. der Bescheinigung\nBeginn mit der Nummer?"]
[null,null,1,null,"1a",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E11<>\"\",CONCATENATE(\" \",TEXT($U$5,\"00 00 000\"),\" / \",$Y$1,\" / \",TEXT(Z14,\"000\"),\" / \",$Z$1),\"\")","v":" 00 00 000 /  / 001 / "}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"bis",{"$f":"IF(NOT(ISBLANK(Y12)),MAX(Z14:Z33),\"\")","v":3}]
[null,null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E13<>\"\",CONCATENATE(\" \",TEXT($U$5,\"00 00 000\"),\" / \",$Y$1,\" / \",TEXT(Z15,\"000\"),\" / \",$Z$1),\"\")","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,0,{"$f":"IF(E11<>\"\",$Y$12+Y14,0)","v":1}]
[null,null,3,null,"3a",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E15<>\"\",CONCATENATE(\" \",TEXT($U$5,\"00 00 000\"),\" / \",$Y$1,\" / \",TEXT(Z16,\"000\"),\" / \",$Z$1),\"\")","v":" 00 00 000 /  / 003 / "},null,null,null,null,1,{"$f":"IF(E13<>\"\",$Y$12+Y15,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,{"$f":"IF(E15<>\"\",$Y$12+Y16,0)","v":3}]
[null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E17<>\"\",CONCATENATE(\" \",TEXT($U$5,\"00 00 000\"),\" / \",$Y$1,\" / \",TEXT(Z17,\"000\"),\" / \",$Z$1),\"\")","v":""},null,null,null,null,3,{"$f":"IF(E17<>\"\",$Y$12+Y17,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,{"$f":"IF(E19<>\"\",$Y$12+Y18,0)","v":0}]
[null,null,5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E19<>\"\",CONCATENATE(\" \",TEXT($U$5,\"00 00 000\"),\" / \",$Y$1,\" / \",TEXT(Z18,\"000\"),\" / \",$Z$1),\"\")","v":""},null,null,null,null,5,{"$f":"IF(E21<>\"\",$Y$12+Y19,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,{"$f":"IF(E23<>\"\",$Y$12+Y20,0)","v":0}]
[null,null,6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E21<>\"\",CONCATENATE(\" \",TEXT($U$5,\"00 00 000\"),\" / \",$Y$1,\" / \",TEXT(Z19,\"000\"),\" / \",$Z$1),\"\")","v":""},null,null,null,null,7,{"$f":"IF(E25<>\"\",$Y$12+Y21,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,{"$f":"IF(E27<>\"\",$Y$12+Y22,0)","v":0}]
[null,null,7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E23<>\"\",CONCATENATE(\" \",TEXT($U$5,\"00 00 000\"),\" / \",$Y$1,\" / \",TEXT(Z20,\"000\"),\" / \",$Z$1),\"\")","v":""},null,null,null,null,9,{"$f":"IF(E29<>\"\",$Y$12+Y23,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,{"$f":"IF(E31<>\"\",$Y$12+Y24,0)","v":0}]
[null,null,8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E25<>\"\",CONCATENATE(\" \",TEXT($U$5,\"00 00 000\"),\" / \",$Y$1,\" / \",TEXT(Z21,\"000\"),\" / \",$Z$1),\"\")","v":""},null,null,null,null,11,{"$f":"IF(E33<>\"\",$Y$12+Y25,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,{"$f":"IF(E35<>\"\",$Y$12+Y26,0)","v":0}]
[null,null,9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E27<>\"\",CONCATENATE(\" \",TEXT($U$5,\"00 00 000\"),\" / \",$Y$1,\" / \",TEXT(Z22,\"000\"),\" / \",$Z$1),\"\")","v":""},null,null,null,null,13,{"$f":"IF(E37<>\"\",$Y$12+Y27,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,{"$f":"IF(E39<>\"\",$Y$12+Y28,0)","v":0}]
[null,null,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E29<>\"\",CONCATENATE(\" \",TEXT($U$5,\"00 00 000\"),\" / \",$Y$1,\" / \",TEXT(Z23,\"000\"),\" / \",$Z$1),\"\")","v":""},null,null,null,null,15,{"$f":"IF(E41<>\"\",$Y$12+Y29,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,{"$f":"IF(E43<>\"\",$Y$12+Y30,0)","v":0}]
[null,null,11,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E31<>\"\",CONCATENATE(\" \",TEXT($U$5,\"00 00 000\"),\" / \",$Y$1,\" / \",TEXT(Z24,\"000\"),\" / \",$Z$1),\"\")","v":""},null,null,null,null,17,{"$f":"IF(E45<>\"\",$Y$12+Y31,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,{"$f":"IF(E47<>\"\",$Y$12+Y32,0)","v":0}]
[null,null,12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E33<>\"\",CONCATENATE(\" \",TEXT($U$5,\"00 00 000\"),\" / \",$Y$1,\" / \",TEXT(Z25,\"000\"),\" / \",$Z$1),\"\")","v":""},null,null,null,null,19,{"$f":"IF(E49<>\"\",$Y$12+Y33,0)","v":0}]
[]
[null,null,13,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E35<>\"\",CONCATENATE(\" \",TEXT($U$5,\"00 00 000\"),\" / \",$Y$1,\" / \",TEXT(Z26,\"000\"),\" / \",$Z$1),\"\")","v":""}]
[]
[null,null,14,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E37<>\"\",CONCATENATE(\" \",TEXT($U$5,\"00 00 000\"),\" / \",$Y$1,\" / \",TEXT(Z27,\"000\"),\" / \",$Z$1),\"\")","v":""}]
[]
[null,null,15,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E39<>\"\",CONCATENATE(\" \",TEXT($U$5,\"00 00 000\"),\" / \",$Y$1,\" / \",TEXT(Z28,\"000\"),\" / \",$Z$1),\"\")","v":""}]
[]
[null,null,16,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E41<>\"\",CONCATENATE(\" \",TEXT($U$5,\"00 00 000\"),\" / \",$Y$1,\" / \",TEXT(Z29,\"000\"),\" / \",$Z$1),\"\")","v":""}]
[]
[null,null,17,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E43<>\"\",CONCATENATE(\" \",TEXT($U$5,\"00 00 000\"),\" / \",$Y$1,\" / \",TEXT(Z30,\"000\"),\" / \",$Z$1),\"\")","v":""}]
[]
[null,null,18,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E45<>\"\",CONCATENATE(\" \",TEXT($U$5,\"00 00 000\"),\" / \",$Y$1,\" / \",TEXT(Z31,\"000\"),\" / \",$Z$1),\"\")","v":""}]
[]
[null,null,19,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E47<>\"\",CONCATENATE(\" \",TEXT($U$5,\"00 00 000\"),\" / \",$Y$1,\" / \",TEXT(Z32,\"000\"),\" / \",$Z$1),\"\")","v":""}]
[]
[null,null,20,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E49<>\"\",CONCATENATE(\" \",TEXT($U$5,\"00 00 000\"),\" / \",$Y$1,\" / \",TEXT(Z33,\"000\"),\" / \",$Z$1),\"\")","v":""}]
[]
[]
[null,null,"Die genannten Personen haben an dem gesamten Lehrgang teilgenommen, die Ausbildung abgeschlossen und die Teilnahmebescheinigung erhalten.\n\nDatenschutzerklärung: \nDie von den Teilnehmern gemachten Angaben werden nur für den Zweck verwendet und gesichert für den sie erhoben wurden und werden nicht an unberechtigte Dritte übermittelt."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Unterschrift des Ausbilders | Stempel der Gliederung"]
[]
[null,null,{"$f":"IF(G5<>\"\",G5&\" – \"&G6,\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(H7<>\"\",CONCATENATE(\"Lehrgang vom \",TEXT(H7,\"TT.MM.JJJJ\"),\" bis \",TEXT(K7,\"TT.MM.JJJJ\")))","v":false},null,null,null,null,null,null,null,{"$f":"IF(S5<>\"\",S5,\"\")","v":""}]

{"sheet":"ABN","index":1,"n_rows":32,"n_cols":22,"rows_kept":32,"cut":false,"hidden":false,"merged":[[29,2,30,2],[13,2,13,5],[2,2,2,5],[3,2,3,5],[4,2,4,5],[5,2,5,5],[7,2,7,5],[8,2,8,5],[9,2,9,5],[10,2,10,5],[11,2,11,5],[12,2,12,5],[6,2,6,5],[3,8,4,10],[6,8,7,8],[22,2,22,3],[23,2,23,3],[28,2,28,3],[28,4,30,5],[20,2,20,5],[21,2,21,5],[14,2,14,5],[15,2,15,5],[16,2,16,5],[17,2,17,5],[17,7,20,8],[24,4,26,5],[18,2,18,5],[19,2,19,5]]}
[{"$f":"IF(TNL!E11<>\"\",1,0)","v":1},null,null,null,null,null,null,null,{"$f":"SUM(Data!H2:H5)","v":0}]
[{"$f":"IF(TNL!E13<>\"\",2,0)","v":0}]
[{"$f":"IF(TNL!E15<>\"\",3,0)","v":3},null,{"$f":"IF(I1<>0,VLOOKUP(I1,Data!H2:S5,2,FALSE),\"\")","v":""}]
[{"$f":"IF(TNL!E17<>\"\",4,0)","v":0},null,null,null,null,null,null,null,"Lfd-Nr. für den Einzeldruck\nNummer aus der Teilnehmerliste"]
[{"$f":"IF(TNL!E19<>\"\",5,0)","v":0},null,{"$f":"IF(I1<>0,VLOOKUP(I1,Data!H2:S5,3,FALSE),\"\")","v":""}]
[{"$f":"IF(TNL!E21<>\"\",6,0)","v":0},null,{"$f":"IF(I1<>0,\"(Realistische Unfall- und Notfall-Darstellung)\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[{"$f":"IF(TNL!E23<>\"\",7,0)","v":0}]
[{"$f":"IF(TNL!E25<>\"\",8,0)","v":0},null,{"$f":"IF(I7<>0,IF(ISERROR(VLOOKUP(I7,Data!A2:E21,5,FALSE)),\"\",VLOOKUP(I7,Data!A2:E21,5,FALSE)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[{"$f":"IF(TNL!E27<>\"\",9,0)","v":0}]
[{"$f":"IF(TNL!E29<>\"\",10,0)","v":0},null,{"$f":"IF(I7<>0,IF(ISERROR(VLOOKUP(I7,Data!A2:E21,2,FALSE)),\"\",VLOOKUP(I7,Data!A2:E21,2,FALSE)),\"\")","v":""}]
[{"$f":"IF(TNL!E31<>\"\",11,0)","v":0},null,{"$f":"IF(I1<>0,\"Name\",\"\")","v":""}]
[{"$f":"IF(TNL!E33<>\"\",12,0)","v":0},null,null,null,null,null,null,"\nCode:\n=WENN(ISTFEHLER(SVERWEIS(B18;LV!A7:C775;3;FALSCH));\"\";SVERWEIS(B18;LV!A7:C775;3;FALSCH))\nCode:\n=WENN(ISTFEHLER(SVERWEIS(B18;LV!A7:C775;3;FALSCH));\"\";SVERWEIS(B18;LV!A7:C775;3;FALSCH))\nCode:\n=WENN(ISTFEHLER(SVERWEIS(B18;LV!A7:C775;3;FALSCH));\"\";SVERWEIS(B18;LV!A7:C775;3;FALSCH))\nCode:\n=WENN(ISTFEHLER(SVERWEIS(B18;LV!A7:C775;3;FALSCH));\"\";SVERWEIS(B18;LV!A7:C775;3;FALSCH))"]
[{"$f":"IF(TNL!E35<>\"\",13,0)","v":0},null,{"$f":"IF(I7<>0,IF(ISERROR(VLOOKUP(I7,Data!A2:E21,3,FALSE)),\"\",VLOOKUP(I7,Data!A2:E21,3,FALSE)),\"\")","v":""}]
[{"$f":"IF(TNL!E37<>\"\",14,0)","v":0},null,{"$f":"IF(I1<>0,\"Vorname\",\"\")","v":""}]
[{"$f":"IF(TNL!E39<>\"\",15,0)","v":0}]
[{"$f":"IF(TNL!E41<>\"\",16,0)","v":0},null,{"$f":"IF(I7<>0,IF(ISERROR(VLOOKUP(I7,Data!A2:E21,4,FALSE)),\"\",VLOOKUP(I7,Data!A2:E21,4,FALSE)),\"\")","v":""}]
[{"$f":"IF(TNL!E43<>\"\",17,0)","v":0},null,{"$f":"IF(I1<>0,\"Geburtsdatum\",\"\")","v":""}]
[{"$f":"IF(TNL!E45<>\"\",18,0)","v":0},null,null,null,null,null,null," Hinweis:\n Anzahl der LE für \n San C auf der TNL \n änderbar!\n (Angaben für die \n Bescheinigungen)"]
[{"$f":"IF(TNL!E47<>\"\",19,0)","v":0},null,{"$f":"IF(I1<>0,VLOOKUP(I1,Data!H2:S5,5,FALSE),\"\")","v":""}]
[{"$f":"IF(TNL!E49<>\"\",20,0)","v":0},null,{"$f":"IF(I1<>0,VLOOKUP(I1,Data!H2:S5,6,FALSE),\"\")","v":""}]
[null,null,{"$f":"IF(I1<>0,VLOOKUP(I1,Data!H2:S5,7,FALSE),\"\")","v":""}]
[]
[null,null,{"$f":"IF(I1<>0,TNL!G8,\"\")","v":""},null,{"$f":"IF(I1<>0,TNL!H7,\"\")","v":""},{"$f":"IF(I1<>0,TNL!K7,\"\")","v":""}]
[null,null,{"$f":"IF(I1<>0,VLOOKUP(I1,Data!H2:S5,12,FALSE),\"\")","v":""},null,{"$f":"IF(I1<>0,\"vom\",\"\")","v":""},{"$f":"IF(I1<>0,\"bis\",\"\")","v":""}]
[]
[null,null,{"$f":"IF(I1<>0,TNL!S6,\"\")","v":""}]
[null,null,{"$f":"IF(I1<>0,TNL!U6,\"\")","v":""}]
[null,null,{"$f":"IF(I1<>0,\"Name und Nr. des Ausbilders\",\"\")","v":""},null,null,{"$f":"IF(I1<>0,\"Unterschrift des Ausbilders\",\"\")","v":""}]
[]
[null,null,{"$f":"IF(I1<>0,TNL!S5,\"\")","v":""}]
[null,null,null,{"$f":"IF(I1<>0,TNL!K7,\"\")","v":""}]
[null,null,{"$f":"IF(I1<>0,\"Ausfertigungsstelle\",\"\")","v":""},{"$f":"IF(I1<>0,\"Datum\",\"\")","v":""},null,{"$f":"IF(I1<>0,\"Stempel | Unterschrift\",\"\")","v":""}]

{"sheet":"RS LK","index":2,"n_rows":37,"n_cols":6,"rows_kept":37,"cut":false,"hidden":true,"merged":[[2,0,3,1],[2,4,3,5],[36,4,37,5]]}
[]
[]
["Aufzählungs-\nzeichen (X)",null,null,null,"Folgende Ausbildungsinhalte wurden im RUND-Leiterkurs vermittelt:"]
[]
[]
[null,"X",null,null,{"$f":"IF(B6<>0,\"•\",\"\")","v":"•"},"Die Struktur der RUND"]
[null,"X",null,null,{"$f":"IF(B7<>0,\"•\",\"\")","v":"•"},"Relevante Rechtsgebiete für den RUND-Leiter & RUND-Ausbilder"]
[null,"X",null,null,"•","Für welche Bereiche kann das Versicherungsrecht für den"]
[null,null,null,null,"","RUND-Leiter oder RUND-Ausbilder relevant werden?"]
[null,"X",null,null,"•","Kosten und Darstellungsklassen"]
[null,"X",null,null,"•","Organisation von Übungen"]
[null,"X",null,null,"•","Objektorientierte Planung"]
[null,"X",null,null,"•","Sicherheit bei der Durchführung von Übungen bzw. Großübungen"]
[null,"X",null,null,"•","Begrifflichkeiten MANV"]
[null,"X",null,null,"•","Was ist Schadensdarstellung?"]
[null,"X",null,null,"•","Welche Faktoren bestimmen die Schadensgestaltung?"]
[null,"X",null,null,"•","Requisiten"]
[null,"X",null,null,"•","Die Lageskizze"]
[null,"X",null,null,"•","Welche Aufgaben hat der RUND-Leiter hinsichtlich "]
[null,null,null,null,"","der Schadensgestaltung?"]
[null,"X",null,null,"•","Mittel zur Schadensgestaltung"]
[null,"X",null,null,"•","Erprobung von Darstellungsmitteln in der Praxis"]
[null,"X",null,null,"•","Menschenführung"]
[null,"X",null,null,"•","Führungsstile, Führungspersönlichkeit, Führungsverhalten"]
[null,"X",null,null,"•","Kommunikationsmittel"]
[null,"X",null,null,"•","Kommunikationsverluste"]
[null,"X",null,null,"•","Einige (vermeidbare) Kommunikationssünden"]
[null,"X",null,null,"•","Kommunikation während der Übung"]
[null,"X",null,null,"•","Steuerung von Übungen"]
[null,"X",null,null,"•","Übungsplanung"]
[null,"X",null,null,"•","Gebärden innerhalb der RUND (Leiter)"]
[null,"X",null,null,"•","Grundlagen der Pressearbeit"]
[null,"X",null,null,"•","Grundkenntnisse im Umgang mit Medien"]
[null,"X",null,null,"•","Auswertung von Übungen"]
[null,"X",null,null,"•","Schiedsrichterdienst"]
[null,null,null,null,""]
[null,null,null,null,"Die Realistische Unfall- und Notfall-Darstellung  (RUND) ist ein spezieller Aufgaben- bereich der DLRG, um Einsatzkräfte in der Ausbildung und bei Übungen realitätsnah für den Ernstfall zu trainieren."]

{"sheet":"RS AK","index":3,"n_rows":36,"n_cols":6,"rows_kept":36,"cut":false,"hidden":true,"merged":[[2,0,3,1],[2,4,3,5],[35,4,37,5]]}
[]
[]
["Aufzählungs-\nzeichen (X)",null,null,null,"Folgende Ausbildungsinhalte wurden in der Ausbildung zum RUND-Ausbilder vermittelt:"]
[]
[null,null,null,null,"Vorausbildungen (gesonderte Nachweise)"]
[null,"X",null,null,{"$f":"IF(B6<>0,\"•\",\"\")","v":"•"},"Gemeinsamer Grundausbildungsblock oder "]
[null,null,null,null,{"$f":"IF(B7<>0,\"•\",\"\")","v":""},"DLRG-Ausbilder-Urkunde"]
[null,"X",null,null,"•","Erste Hilfe- und Sanitätsausbildung A und B oder "]
[null,null,null,null,"","Rettungsdienstliche Ausbildung | ärztliche Approbation"]
[null,"X",null,null,"•","RUND-Grundkurs"]
[null,"X",null,null,"•","RUND-Aufbaukurs"]
[null,"X",null,null,"•","RUND-Leiterkurs"]
[null,null,null,null,""]
[null,null,null,null,"Themen"]
[null,"X",null,null,"•","Ausbildungen für die Deutsche Lebens-Rettungs-Gesellschaft"]
[null,"X",null,null,"•","Ausbildungs- und Prüfungsordnung Medizin der DLRG"]
[null,"X",null,null,"•","Einweisung in die Lehrunterlagen (AV 5 und AV 6)"]
[null,"X",null,null,"•","Einweisung in die Bildpräsentationen zu den Lehrunterlagen"]
[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,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,null,null,""]
[null,null,null,null,"Hinweis:\nDer Inhaber dieser Urkunde ist nur in Verbindung mit einem Lehrauftrag des zuständigen Landes- oder des Bundesverbandes berechtigt, als Ausbilder innerhalb der DLRG tätig zu werden."]

{"sheet":"Data","index":4,"n_rows":21,"n_cols":19,"rows_kept":21,"cut":false,"hidden":true,"merged":[]}
["Nr.","Name","Vorname","Geb.","Reg.-Nr.:",null,0,1,2,3,4,5,6,7,8,9,10,11,12]
[{"$f":"IF(B2<>\"\",1,\"\")","v":1},{"$f":"IF(TNL!E11<>0,TNL!E11,\"\")","v":"1a"},{"$f":"IF(A2<>\"\",CONCATENATE(TNL!E12),\"\")","v":""},{"$f":"IF(TNL!I11<>\"\",IF(A2<>\"\",TNL!I11,\"\"),\"\")","v":""},{"$f":"IF(A2<>\"\",CONCATENATE($E$1,TNL!T11,\"\"),\"\")","v":"Reg.-Nr.: 00 00 000 /  / 001 / "},null,1,{"$f":"IF(TNL!X3<>\"\",G2,0)","v":0},"Urkunde","RUND-Leiter",{"$f":"IF(ABN!I7<>0,CONCATENATE(\"Reg.-Nr.: \",VLOOKUP(ABN!I7,ABN!B38:F57,5,FALSE)),\"\")","v":""},"hat den RUND-Leiterkurs mit",{"$f":"CONCATENATE(\"mindestens \",TEXT(TNL!AF3,\"0\"),\" Lerneinheiten\")","v":"mindestens 16 Lerneinheiten"},"erfolgreich abgeschlossen.","(Realistische Unfall- und Notfall-Darstellung)","Die Realistische Unfall- und Notfall-Darstellung (RUND) ist ein spezieller \nAufgabenbereich der DLRG, um Einsatzkräfte in der Ausbildung und \nbei Übungen realitätsnah für den Ernstfall zu trainieren.",{"$f":"IF(ABN!I1<>0,\"Nur gültig mit aufgedruckter Rückseite!\",\"\")","v":""},{"$f":"CONCATENATE(\"Die Ausbildung wurde unter der Lehrgangs-Nummer \",TNL!G6,\" registriert.\")","v":"Die Ausbildung wurde unter der Lehrgangs-Nummer  registriert."},"Lehrgangsort"]
[{"$f":"IF(B3<>\"\",2,\"\")","v":""},{"$f":"IF(TNL!E13<>0,TNL!E13,\"\")","v":""},{"$f":"IF(A3<>\"\",CONCATENATE(TNL!E14),\"\")","v":""},{"$f":"IF(TNL!I13<>\"\",IF(A3<>\"\",TNL!I13,\"\"),\"\")","v":""},{"$f":"IF(A3<>\"\",CONCATENATE($E$1,TNL!T13,\"\"),\"\")","v":""},null,2,{"$f":"IF(TNL!X5<>\"\",G3,0)","v":0},"Urkunde","RUND-Ausbilder",{"$f":"IF(ABN!I7<>0,CONCATENATE(\"Reg.-Nr.: \",VLOOKUP(ABN!I7,ABN!B38:F57,5,FALSE)),\"\")","v":""},"hat den RUND-Ausbilderkurs mit",{"$f":"CONCATENATE(\"mindestens \",TEXT(TNL!AF4,\"0\"),\" Lerneinheiten\")","v":"mindestens 4 Lerneinheiten"},"erfolgreich abgeschlossen.","(Realistische Unfall- und Notfall-Darstellung)","Der Inhaber dieser Urkunde ist nur in Verbindung mit einem Lehrauftrag \ndes zuständigen Landes- oder des Bundesverbandes \nberechtigt, als Ausbilder tätig zu werden.",{"$f":"IF(ABN!I1<>0,\"Nur gültig mit aufgedruckter Rückseite!\",\"\")","v":""},{"$f":"CONCATENATE(\"Die Ausbildung wurde unter der Lehrgangs-Nummer \",TNL!G6,\" registriert.\")","v":"Die Ausbildung wurde unter der Lehrgangs-Nummer  registriert."},"Lehrgangsort"]
[{"$f":"IF(B4<>\"\",3,\"\")","v":3},{"$f":"IF(TNL!E15<>0,TNL!E15,\"\")","v":"3a"},{"$f":"IF(A4<>\"\",CONCATENATE(TNL!E16),\"\")","v":""},{"$f":"IF(TNL!I15<>\"\",IF(A4<>\"\",TNL!I15,\"\"),\"\")","v":""},{"$f":"IF(A4<>\"\",CONCATENATE($E$1,TNL!T15,\"\"),\"\")","v":"Reg.-Nr.: 00 00 000 /  / 003 / "},null,3,{"$f":"IF(TNL!X9<>\"\",G4,0)","v":0},"Ausbildungsnachweis","Sanitätsausbildung C",{"$f":"IF(ABN!I7<>0,CONCATENATE(\"Reg.-Nr.: \",VLOOKUP(ABN!I7,ABN!B38:F57,5,FALSE)),\"\")","v":""},"hat die Sanitätsausbildung C mit",{"$f":"CONCATENATE(\"mindestens \",TEXT(TNL!AF5,\"0\"),\" Lerneinheiten\")","v":"mindestens 24 Lerneinheiten"},"erfolgreich abgeschlossen.","(Sanitäter-WRD/KatS)",null,null,null,"Lehrgangsort"]
[{"$f":"IF(B5<>\"\",4,\"\")","v":""},{"$f":"IF(TNL!E17<>0,TNL!E17,\"\")","v":""},{"$f":"IF(A5<>\"\",CONCATENATE(TNL!E18),\"\")","v":""},{"$f":"IF(TNL!I17<>\"\",IF(A5<>\"\",TNL!I17,\"\"),\"\")","v":""},{"$f":"IF(A5<>\"\",CONCATENATE($E$1,TNL!T17,\"\"),\"\")","v":""},null,4,{"$f":"IF(TNL!X7<>\"\",G5,0)","v":0},"Fortbildungsnachweis","Sanitätsfortbildung",{"$f":"IF(TNL!K7<>\"\",CONCATENATE(\"Dieser Nachweis ist gültig bis \",TEXT(TNL!AH6,\"TT.MM.JJJJ\")),\"Dieser Nachweis ist unbegrenzt gültig!\")","v":"Dieser Nachweis ist unbegrenzt gültig!"},"hat an einer Sanitätsfortbildung mit",{"$f":"CONCATENATE(\"mindestens \",TEXT(TNL!AF6,\"0\"),\" Lerneinheiten\")","v":"mindestens 10 Lerneinheiten"},"erfolgreich teilgenommen.","(für sämtliche Sanitätsausbildungen)",null,null,null,"Fortbildungsort"]
[{"$f":"IF(B6<>\"\",5,\"\")","v":""},{"$f":"IF(TNL!E19<>0,TNL!E19,\"\")","v":""},{"$f":"IF(A6<>\"\",CONCATENATE(TNL!E20),\"\")","v":""},{"$f":"IF(TNL!I19<>\"\",IF(A6<>\"\",TNL!I19,\"\"),\"\")","v":""},{"$f":"IF(A6<>\"\",CONCATENATE($E$1,TNL!T19,\"\"),\"\")","v":""},null,null,null,null,null,null,365,4,{"$f":"L6*M6","v":1460}," "]
[{"$f":"IF(B7<>\"\",6,\"\")","v":""},{"$f":"IF(TNL!E21<>0,TNL!E21,\"\")","v":""},{"$f":"IF(A7<>\"\",CONCATENATE(TNL!E22),\"\")","v":""},{"$f":"IF(TNL!I21<>\"\",IF(A7<>\"\",TNL!I21,\"\"),\"\")","v":""},{"$f":"IF(A7<>\"\",CONCATENATE($E$1,TNL!T21,\"\"),\"\")","v":""}]
[{"$f":"IF(B8<>\"\",7,\"\")","v":""},{"$f":"IF(TNL!E23<>0,TNL!E23,\"\")","v":""},{"$f":"IF(A8<>\"\",CONCATENATE(TNL!E24),\"\")","v":""},{"$f":"IF(TNL!I23<>\"\",IF(A8<>\"\",TNL!I23,\"\"),\"\")","v":""},{"$f":"IF(A8<>\"\",CONCATENATE($E$1,TNL!T23,\"\"),\"\")","v":""}]
[{"$f":"IF(B9<>\"\",8,\"\")","v":""},{"$f":"IF(TNL!E25<>0,TNL!E25,\"\")","v":""},{"$f":"IF(A9<>\"\",CONCATENATE(TNL!E26),\"\")","v":""},{"$f":"IF(TNL!I25<>\"\",IF(A9<>\"\",TNL!I25,\"\"),\"\")","v":""},{"$f":"IF(A9<>\"\",CONCATENATE($E$1,TNL!T25,\"\"),\"\")","v":""},null,null,null,null,null,null,"(WRD/KatS)"]
[{"$f":"IF(B10<>\"\",9,\"\")","v":""},{"$f":"IF(TNL!E27<>0,TNL!E27,\"\")","v":""},{"$f":"IF(A10<>\"\",CONCATENATE(TNL!E28),\"\")","v":""},{"$f":"IF(TNL!I27<>\"\",IF(A10<>\"\",TNL!I27,\"\"),\"\")","v":""},{"$f":"IF(A10<>\"\",CONCATENATE($E$1,TNL!T27,\"\"),\"\")","v":""}]
[{"$f":"IF(B11<>\"\",10,\"\")","v":""},{"$f":"IF(TNL!E29<>0,TNL!E29,\"\")","v":""},{"$f":"IF(A11<>\"\",CONCATENATE(TNL!E30),\"\")","v":""},{"$f":"IF(TNL!I29<>\"\",IF(A11<>\"\",TNL!I29,\"\"),\"\")","v":""},{"$f":"IF(A11<>\"\",CONCATENATE($E$1,TNL!T29,\"\"),\"\")","v":""},null,null,null,null,null,null,"Sanitäter-WRD/KatS"]
[{"$f":"IF(B12<>\"\",11,\"\")","v":""},{"$f":"IF(TNL!E31<>0,TNL!E31,\"\")","v":""},{"$f":"IF(A12<>\"\",CONCATENATE(TNL!E32),\"\")","v":""},{"$f":"IF(TNL!I31<>\"\",IF(A12<>\"\",TNL!I31,\"\"),\"\")","v":""},{"$f":"IF(A12<>\"\",CONCATENATE($E$1,TNL!T31,\"\"),\"\")","v":""}]
[{"$f":"IF(B13<>\"\",12,\"\")","v":""},{"$f":"IF(TNL!E33<>0,TNL!E33,\"\")","v":""},{"$f":"IF(A13<>\"\",CONCATENATE(TNL!E34),\"\")","v":""},{"$f":"IF(TNL!I33<>\"\",IF(A13<>\"\",TNL!I33,\"\"),\"\")","v":""},{"$f":"IF(A13<>\"\",CONCATENATE($E$1,TNL!T33,\"\"),\"\")","v":""},null,null,null,null,null,{"$f":"IF(TNL!K7<>\"\",CONCATENATE(\"Reg.-Nr.: \",TEXT(Data!E2,\"00\")))","v":false}]
[{"$f":"IF(B14<>\"\",13,\"\")","v":""},{"$f":"IF(TNL!E35<>0,TNL!E35,\"\")","v":""},{"$f":"IF(A14<>\"\",CONCATENATE(TNL!E36),\"\")","v":""},{"$f":"IF(TNL!I35<>\"\",IF(A14<>\"\",TNL!I35,\"\"),\"\")","v":""},{"$f":"IF(A14<>\"\",CONCATENATE($E$1,TNL!T35,\"\"),\"\")","v":""}]
[{"$f":"IF(B15<>\"\",14,\"\")","v":""},{"$f":"IF(TNL!E37<>0,TNL!E37,\"\")","v":""},{"$f":"IF(A15<>\"\",CONCATENATE(TNL!E38),\"\")","v":""},{"$f":"IF(TNL!I37<>\"\",IF(A15<>\"\",TNL!I37,\"\"),\"\")","v":""},{"$f":"IF(A15<>\"\",CONCATENATE($E$1,TNL!T37,\"\"),\"\")","v":""}]
[{"$f":"IF(B16<>\"\",15,\"\")","v":""},{"$f":"IF(TNL!E39<>0,TNL!E39,\"\")","v":""},{"$f":"IF(A16<>\"\",CONCATENATE(TNL!E40),\"\")","v":""},{"$f":"IF(TNL!I39<>\"\",IF(A16<>\"\",TNL!I39,\"\"),\"\")","v":""},{"$f":"IF(A16<>\"\",CONCATENATE($E$1,TNL!T39,\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"am \",TEXT(ABN!F23,\"TT.MM.JJJJ\"),\" durch eine Prüfung\")","v":"am  durch eine Prüfung"}]
[{"$f":"IF(B17<>\"\",16,\"\")","v":""},{"$f":"IF(TNL!E41<>0,TNL!E41,\"\")","v":""},{"$f":"IF(A17<>\"\",CONCATENATE(TNL!E42),\"\")","v":""},{"$f":"IF(TNL!I41<>\"\",IF(A17<>\"\",TNL!I41,\"\"),\"\")","v":""},{"$f":"IF(A17<>\"\",CONCATENATE($E$1,TNL!T41,\"\"),\"\")","v":""}]
[{"$f":"IF(B18<>\"\",17,\"\")","v":""},{"$f":"IF(TNL!E43<>0,TNL!E43,\"\")","v":""},{"$f":"IF(A18<>\"\",CONCATENATE(TNL!E44),\"\")","v":""},{"$f":"IF(TNL!I43<>\"\",IF(A18<>\"\",TNL!I43,\"\"),\"\")","v":""},{"$f":"IF(A18<>\"\",CONCATENATE($E$1,TNL!T43,\"\"),\"\")","v":""}]
[{"$f":"IF(B19<>\"\",18,\"\")","v":""},{"$f":"IF(TNL!E45<>0,TNL!E45,\"\")","v":""},{"$f":"IF(A19<>\"\",CONCATENATE(TNL!E46),\"\")","v":""},{"$f":"IF(TNL!I45<>\"\",IF(A19<>\"\",TNL!I45,\"\"),\"\")","v":""},{"$f":"IF(A19<>\"\",CONCATENATE($E$1,TNL!T45,\"\"),\"\")","v":""}]
[{"$f":"IF(B20<>\"\",19,\"\")","v":""},{"$f":"IF(TNL!E47<>0,TNL!E47,\"\")","v":""},{"$f":"IF(A20<>\"\",CONCATENATE(TNL!E48),\"\")","v":""},{"$f":"IF(TNL!I47<>\"\",IF(A20<>\"\",TNL!I47,\"\"),\"\")","v":""},{"$f":"IF(A20<>\"\",CONCATENATE($E$1,TNL!T47,\"\"),\"\")","v":""}]
[{"$f":"IF(B21<>\"\",20,\"\")","v":""},{"$f":"IF(TNL!E49<>0,TNL!E49,\"\")","v":""},{"$f":"IF(A21<>\"\",CONCATENATE(TNL!E50),\"\")","v":""},{"$f":"IF(TNL!I49<>\"\",IF(A21<>\"\",TNL!I49,\"\"),\"\")","v":""},{"$f":"IF(A21<>\"\",CONCATENATE($E$1,TNL!T49,\"\"),\"\")","v":""}]