{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Abfrage","Stammdaten","Verkaeufe","Zusammenfassung"],"not_rendered":{"charts":0,"images":10,"macros":1,"external_links":0,"defined_names":1,"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":"Abfrage","index":0,"n_rows":19,"n_cols":8,"rows_kept":19,"cut":false,"hidden":false,"merged":[[2,0,2,4],[8,4,8,7]]}
[]
[]
[20]
[]
["Personalnummer",{"$f":"VLOOKUP($A$3,Stammdaten!$A:$D,2,FALSE)","v":200},null,{"$f":"IF(ISERROR(B5),\"Mitarbeiter nicht bekannt - Bitte wenden Sie sich an die Bäckerei\",\" \")","v":" "}]
["Vorname",{"$f":"VLOOKUP($A$3,Stammdaten!$A:$D,3,FALSE)","v":"Vorname 6"},null,{"$f":"IF(ISERROR(B6),\"Der Verkauf ist unzulässig und darf nicht fortgesetzt werden\",\" \")","v":" "}]
["Nachname",{"$f":"VLOOKUP($A$3,Stammdaten!$A:$D,4,FALSE)","v":"Nachname 6"}]
[]
[null,null,null,null,"Aktueller Bon"]
["             Hinzufügen",null,"Entfernen",null,"Anzahl","Artikel","Einzelpreis","Gesamtpreis"]
[null,null,null,null,null,"Brötchen á",0.2,{"$f":"IF(E11>=0,G11*E11,\"Wert darf nicht kleiner als 0 sein\")","v":0}]
[null,null,null,null,null,"Brötchen á",0.6,{"$f":"G12*E12","v":0}]
[null,null,null,null,null,"Brot á",2.2000000000000002,0]
[null,null,null,null,null,"Gebäck á ",0.6,0]
[]
[]
[]
[]
[null,null,null,null,null,"Gesamt",null,{"$f":"SUM(H11:H18)","v":0}]

{"sheet":"Stammdaten","index":1,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Dongle ID","Personalnummer","Vorname ","Nachname"]
[15,150,"Vorname 1","Nachname 1"]
[16,160,"Vorname 2","Nachname 2"]
[17,170,"Vorname 3","Nachname 3"]
[18,180,"Vorname 4","Nachname 4"]
[19,190,"Vorname 5","Nachname 5"]
[20,200,"Vorname 6","Nachname 6"]
[21,210,"Vorname 7","Nachname 7"]
[22,220,"Vorname 8","Nachname 8"]
[23,230,"Vorname 9","Nachname 9"]
[24,240,"Vorname 10","Nachname 10"]
[25,250,"Vorname 11","Nachname 11"]

{"sheet":"Verkaeufe","index":2,"n_rows":5,"n_cols":17,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Datum","Uhrzeit","Personalnummer","Dongle ID","Vorname","Name",null,"Brötchen 0,20","Brötchen 0,60","Brot 2,20 ","Gebäck 0,60",null,null,null,null,null,"Gesamtbetrag"]
["16.10.2025","18:10:14",200,20,"Vorname 6","Nachname 6",null,1,2,3,4,null,null,null,null,null,10.4]
["16.10.2025","18:08:15",200,20,"Vorname 6","Nachname 6",null,1,2,3,4,null,null,null,null,null,10.4]
["16.10.2025","17:48:13",210,21,"Vorname 7","Nachname 7",null,1,2,3,4,null,null,null,null,null,10.4]
["16.10.2025","17:43:43",210,21,"Vorname 7","Nachname 7",null,1,2,3,4]

{"sheet":"Zusammenfassung","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}