{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Tabelle1","Formular","ListeVeranstaltungen"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":1},"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":"Tabelle1","index":0,"n_rows":21,"n_cols":1,"rows_kept":21,"cut":false,"hidden":true,"merged":[]}
[]
[]
["Zeilenbeschriftungen"]
["Accounting"]
["Administration"]
["Automation & AI"]
["Compliance"]
["Direct Reports Kai"]
["HR"]
["Kai"]
["Operations"]
["PMO"]
["Regionalvertrieb"]
["SAP"]
["SMD"]
["SMS"]
["Ströer Core"]
["SVP"]
["Zentraler Einkauf"]
["(Leer)"]
["Gesamtergebnis"]

{"sheet":"Formular","index":1,"n_rows":53,"n_cols":6,"rows_kept":53,"cut":false,"hidden":false,"merged":[[52,2,53,6],[30,5,30,6],[32,5,32,6],[36,5,36,6],[44,5,44,6],[46,5,46,6],[50,5,50,6],[26,5,26,6],[0,5,3,7],[6,5,6,6],[8,2,8,6],[10,5,10,6],[20,5,20,6]]}
[null,"Veranstaltung",null,null,null,"Speichern"]
[]
[null,"lfd. Nr.","2025-003"]
[]
[null,"Titel"]
[]
[null,"Titel",{"$f":"VLOOKUP($C$3,ListeVeranstaltungen!A:AI,2,FALSE)","v":"Titel3"},null,"Untertitel",{"$f":"VLOOKUP($C$3,ListeVeranstaltungen!A:AI,3,FALSE)","v":"Untertitel3"}]
[]
[null,"Titel komplett",{"$f":"VLOOKUP($C$3,ListeVeranstaltungen!A:AI,4,FALSE)","v":"Titel3 Untertitel3"}]
[]
[null,"Art",{"$f":"VLOOKUP($C$3,ListeVeranstaltungen!A:AI,5,FALSE)","v":"Schulung"},null,"Verantwortlich",{"$f":"VLOOKUP($C$3,ListeVeranstaltungen!A:AI,17,FALSE)","v":"Monika"}]
[]
[null,"Termin/Dauer"]
[]
[null,"Datum Start",{"$f":"VLOOKUP($C$3,ListeVeranstaltungen!A:AI,6,FALSE)","v":"2025-01-27"},null,"Uhrzeit Start",{"$f":"VLOOKUP($C$3,ListeVeranstaltungen!A:AI,7,FALSE)","v":"10:00:00"}]
[]
[null,"Datum Ende",{"$f":"VLOOKUP($C$3,ListeVeranstaltungen!A:AI,8,FALSE)","v":"2025-01-27"},null,"Uhrzeit Ende",{"$f":"VLOOKUP($C$3,ListeVeranstaltungen!A:AI,9,FALSE)","v":"12:00:00"}]
[]
[null,"Dauer in Tagen",{"$f":"VLOOKUP($C$3,ListeVeranstaltungen!A:AI,10,FALSE)","v":0.5}]
[]
[null,"Interner ASP",{"$f":"VLOOKUP($C$3,ListeVeranstaltungen!A:AI,20,FALSE)","v":"Klaus"},null,"Ext.Dienstleister/Trainer",{"$f":"VLOOKUP($C$3,ListeVeranstaltungen!A:AI,21,FALSE)","v":"Trainer"}]
[]
[null,"Kosten"]
[]
[null,"Kosten DL ",{"$f":"VLOOKUP($C$3,ListeVeranstaltungen!A:AI,22,FALSE)","v":3000}]
[]
[null,"Gesamt-Kosten",{"$f":"C25+F37","v":3000},null,"Kosten DL Pro TN",{"$f":"C25/C41","v":300}]
[]
[null,"Veranstaltungsort & Catering"]
[]
[null,"Status Vorbereitung",{"$f":"VLOOKUP($C$3,ListeVeranstaltungen!A:AI,19,FALSE)","v":"offen"},null,"Status Veranstaltung",{"$f":"IF(C9=\"\",\"\",IF(C17<TODAY(),\"abgeschlossen\",IF(AND(F33=\"erledigt\",C37=\"erledigt\",C47=\"erledigt\"),\"komplett vorbereitet\",\"offen\")))","v":"abgeschlossen"}]
[]
[null,"Veranstaltungsort",{"$f":"VLOOKUP($C$3,ListeVeranstaltungen!A:AI,23,FALSE)","v":"Raum3"},null,"Raumbuchung",{"$f":"VLOOKUP($C$3,ListeVeranstaltungen!A:AI,25,FALSE)","v":"offen"}]
[]
[null,"Art des Caterings",{"$f":"VLOOKUP($C$3,ListeVeranstaltungen!A:AI,29,FALSE)","v":"keine"},null,"Uhrzeit des Caterings",{"$f":"VLOOKUP($C$3,ListeVeranstaltungen!A:AI,30,FALSE)","v":"12:30:00"}]
[]
[null,"Catering gebucht?",{"$f":"VLOOKUP($C$3,ListeVeranstaltungen!A:AI,32,FALSE)","v":"erledigt"},null,"Kosten Raum + Catering",{"$f":"VLOOKUP($C$3,ListeVeranstaltungen!A:AI,31,FALSE)","v":0}]
[]
[null,"Teilnehmerorganisation"]
[]
[null,"Max TN-Zahl",{"$f":"VLOOKUP($C$3,ListeVeranstaltungen!A:AI,11,FALSE)","v":10},null,"Anmeldungen",{"$f":"VLOOKUP($C$3,ListeVeranstaltungen!A:AI,12,FALSE)","v":7}]
[]
[null,"freie Plätze",{"$f":"C41-F41","v":3},null,"Tats. TN-Zahl",{"$f":"VLOOKUP($C$3,ListeVeranstaltungen!A:AI,14,FALSE)","v":8}]
[]
[null,"Save-the-date versendet?",{"$f":"VLOOKUP($C$3,ListeVeranstaltungen!A:AI,26,FALSE)","v":"erledigt"},null,"Rückmeldung Teilnahme bis",{"$f":"VLOOKUP($C$3,ListeVeranstaltungen!A:AI,28,FALSE)","v":"00:00:00"}]
[]
[null,"Finale Einladung versendet?",{"$f":"VLOOKUP($C$3,ListeVeranstaltungen!A:AI,34,FALSE)","v":"erledigt"},null,"Reminder versendet",{"$f":"VLOOKUP($C$3,ListeVeranstaltungen!A:AI,27,FALSE)","v":"00:00:00"}]
[]
[null,"Sonstiges"]
[]
[null,"Präsentation",{"$f":"VLOOKUP($C$3,ListeVeranstaltungen!A:AI,24,FALSE)","v":"Nicht erforderlich"},null,"Kai einladen",{"$f":"VLOOKUP($C$3,ListeVeranstaltungen!A:AI,33,FALSE)","v":"Nicht erforderlich"}]
[]
[null,"Notizen",{"$f":"VLOOKUP($C$3,ListeVeranstaltungen!A:AI,35,FALSE)","v":0}]

{"sheet":"ListeVeranstaltungen","index":2,"n_rows":7,"n_cols":35,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["lfd. Nr.","Titel","Untertitel","Titel komplett","Art","Datum\nStart","Uhrzeit\nStart","Datum\nEnde","Uhrzeit\nEnde","Dauer in Tagen","Max \nTN-Zahl","Anmeld-ungen","freie Plätze","Tats. \nTN-Zahl","Gesamt-Kosten","Kosten DL Pro TN","Verantwortlich","Status","Status Vorbereitung","Interner ASP","Ext.DL","Kosten DL","Veranstaltungsort","Präsentation fertig","Raum gebucht?","Save-the-date versendet?","Reminder versendet","Rückmeldung Teilnahme bis","Art des Caterings","Uhrzeit","Kosten Raum + Catering","Catering gebucht?","Chef einladen","Finale Einladung versendet?","Notizen"]
["2025-001","Titel1","Untertitel1",{"$f":"CONCATENATE(B2,\" \",C2)","v":"Titel1 Untertitel1"},"Schulung","2025-01-14","09:00:00","2025-01-15","17:30:00",2,10,8,{"$f":"K2-L2","v":2},9,{"$f":"V2+AE2","v":5500},{"$f":"IF(F2>0,V2/N2,\"\")","v":555.55555555555554},"Monika","abgeschlossen",{"$f":"IF(F2=\"\",\"\",IF(AND(Y2=\"erledigt\",Z2=\"erledigt\",AF2=\"erledigt\",AH2=\"erledigt\"),\"erledigt\",\"offen\"))","v":"erledigt"},"Klaus","Dienstleister",5000,"Raum1","Nicht erforderlich","erledigt","erledigt",null,null,"Kantine","12:30:00",500,"erledigt","Nicht erforderlich","erledigt"]
["2025-002","Titel2","Untertitel2",{"$f":"CONCATENATE(B3,\" \",C3)","v":"Titel2 Untertitel2"},"Schulung","2025-01-20","09:00:00","2025-07-21","17:00:00",2,10,null,{"$f":"K3-L3","v":10},10,9900,100,"Louisa","abgeschlossen","erledigt","Klaus","Trainer",1000,"Raum2","Nicht erforderlich","erledigt","erledigt",null,null,"Kantine","12:30:00",0,"erledigt","Nicht erforderlich","erledigt","langweilige Schulung"]
["2025-003","Titel3","Untertitel3","Titel3 Untertitel3","Schulung","2025-01-27","10:00:00","2025-01-27","12:00:00",0.5,10,7,7,8,null,375,"Monika","abgeschlossen","offen","Klaus","Trainer",3000,"Raum3","Nicht erforderlich","offen","erledigt",null,null,"keine","12:30:00",0,"erledigt","Nicht erforderlich","erledigt"]
["2025-004","Titel4","Untertitel4","Titel4 Untertitel4","Schulung","2025-01-27","09:00:00","2025-01-28","17:00:00",2,10,null,{"$f":"K5-L5","v":10},10,9900,100,"Louisa","abgeschlossen","erledigt","Klaus","Dienstleister",1000,"Raum4","Nicht erforderlich","erledigt","erledigt",null,null,"Kantine","12:30:00",350,"erledigt","Nicht erforderlich","erledigt"]
["2025-005","Titel5","Untertitel5","Titel5 Untertitel5","TeamEvent","2025-01-29","09:00:00","2025-01-29","17:30:00",1,18,14,4,8,{"$f":"V6+AE6","v":2750},312.5,"Monika","abgeschlossen","offen","Klaus","Trainer",2500,"Raum5","Ja","erledigt","offen",null,null,"Kantine","12:30:00",250,"erledigt","Ja","erledigt"]
["2025-006","Titel6","Untertitel6","Titel6 Untertitel6","Schulung","2025-02-11","09:00:00","2025-02-11","17:00:00",1,12,11,1,9,{"$f":"V7+AE7","v":6600},666.66666666666663,"Louisa","abgeschlossen","erledigt","Klaus","Trainer",6000,"Raum6","Nicht erforderlich","erledigt","erledigt",null,null,"Kantine","13:00:00",600,"erledigt","Nicht erforderlich","erledigt"]