{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Bestandsliste","Listen"],"not_rendered":{"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"Bestandsliste","index":0,"n_rows":200,"n_cols":15,"rows_kept":200,"merged":[[0,0,0,14],[1,0,1,2],[2,0,2,2],[3,0,3,2],[4,0,4,3]]}
["Bestandsliste"]
["Anzahl Artikel (SKU)",null,null,{"$f":"COUNTA(A7:A200)","v":7}]
["Artikel unter Mindestbestand",null,null,{"$f":"COUNTIF(J7:J200,\"Nachbestellen\")","v":3}]
["Gesamtwert Lager (€)",null,null,{"$f":"SUM(M7:M200)","v":{"v":213.12,"d":"€213.12"}}]
["Trage Artikel zeilenweise ein. Spalten mit Dropdown nutzen. Filter in der Kopfzeile verwenden."]
["Artikel\nnummer","Bezeichnung","Kategorie","Lagerort","Einheit","Lieferant","Zustand","Bestand","Mindestbestand","Bestellstatus","Bestellmenge","Einzelpreis (€)","Gesamtwert (€)","Letzte Aktualisierung","Notizen"]
["B-0001","Kugelschreiber Blau","Büro","Regal 1","Stück","Lieferant A","Neu",120,50,{"$f":"IF(OR(H7=\"\",I7=\"\"),\"\",IF(H7=0,\"Nicht verfügbar\",IF(H7<I7,\"Nachbestellen\",\"OK\")))","v":"OK"},{"$f":"IF(J7=\"Nachbestellen\",MAX(0,I7-H7),0)","v":0},{"v":0.49,"d":"€0.49"},{"$f":"IF(OR(H7=\"\",L7=\"\"),\"\",H7*L7)","v":{"v":58.8,"d":"€58.80"}},"2026-02-01"]
["B-0002","A4 Kopierpapier 80g","Büro","Lager A","Pack","Lieferant B","Neu",18,25,"Nachbestellen",7,{"v":4.99,"d":"€4.99"},{"v":89.82000000000001,"d":"€89.82"},"2026-01-28","5er Pack je Einheit"]
["IT-0100","USB-C Kabel 1m","IT","Regal 2","Stück","Lieferant C","Neu",9,15,"Nachbestellen",6,{"v":2.9,"d":"€2.90"},{"v":26.099999999999998,"d":"€26.10"},"2026-02-02"]
["W-0200","Schrauben Set M4","Werkstatt","Lager B","Set","Lieferant A","Neu",0,10,"Nicht verfügbar",0,{"v":6.5,"d":"€6.50"},{"v":0,"d":"€0.00"},"2026-01-30","Set à 200"]
["R-1000","Allzweckreiniger 1l","Reinigung","Lager A","l","Lieferant B","Kühlware",6,5,"OK",0,{"v":3.2,"d":"€3.20"},{"v":19.200000000000003,"d":"€19.20"},"2026-02-03","Nach Öffnung schnell verbrauchen"]
["V-0300","Stretchfolie 30cm","Verpackung","Lager B","m","Lieferant C","Neu",40,30,"OK",0,{"v":0.15,"d":"€0.15"},{"v":6,"d":"€6.00"},"2026-01-25"]
["L-0500","Milch 1l","Lebensmittel","Kühlraum","l","Lieferant A","Kühlware",12,20,"Nachbestellen",8,{"v":1.1,"d":"€1.10"},{"v":13.200000000000001,"d":"€13.20"},"2026-02-04","MHD prüfen"]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},{"$f":"IF(OR(H39=\"\",I39=\"\"),\"\",IF(H39=0,\"Nicht verfügbar\",IF(H39<I39,\"Nachbestellen\",\"OK\")))","v":""},{"$f":"IF(J39=\"Nachbestellen\",MAX(0,I39-H39),0)","v":0},null,{"$f":"IF(OR(H39=\"\",L39=\"\"),\"\",H39*L39)","v":""}]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},{"$f":"IF(OR(H71=\"\",I71=\"\"),\"\",IF(H71=0,\"Nicht verfügbar\",IF(H71<I71,\"Nachbestellen\",\"OK\")))","v":""},{"$f":"IF(J71=\"Nachbestellen\",MAX(0,I71-H71),0)","v":0},null,{"$f":"IF(OR(H71=\"\",L71=\"\"),\"\",H71*L71)","v":""}]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},{"$f":"IF(OR(H103=\"\",I103=\"\"),\"\",IF(H103=0,\"Nicht verfügbar\",IF(H103<I103,\"Nachbestellen\",\"OK\")))","v":""},{"$f":"IF(J103=\"Nachbestellen\",MAX(0,I103-H103),0)","v":0},null,{"$f":"IF(OR(H103=\"\",L103=\"\"),\"\",H103*L103)","v":""}]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},{"$f":"IF(OR(H135=\"\",I135=\"\"),\"\",IF(H135=0,\"Nicht verfügbar\",IF(H135<I135,\"Nachbestellen\",\"OK\")))","v":""},{"$f":"IF(J135=\"Nachbestellen\",MAX(0,I135-H135),0)","v":0},null,{"$f":"IF(OR(H135=\"\",L135=\"\"),\"\",H135*L135)","v":""}]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},{"$f":"IF(OR(H167=\"\",I167=\"\"),\"\",IF(H167=0,\"Nicht verfügbar\",IF(H167<I167,\"Nachbestellen\",\"OK\")))","v":""},{"$f":"IF(J167=\"Nachbestellen\",MAX(0,I167-H167),0)","v":0},null,{"$f":"IF(OR(H167=\"\",L167=\"\"),\"\",H167*L167)","v":""}]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},"",0,null,""]
[{"$nulls":9},{"$f":"IF(OR(H199=\"\",I199=\"\"),\"\",IF(H199=0,\"Nicht verfügbar\",IF(H199<I199,\"Nachbestellen\",\"OK\")))","v":""},{"$f":"IF(J199=\"Nachbestellen\",MAX(0,I199-H199),0)","v":0},null,{"$f":"IF(OR(H199=\"\",L199=\"\"),\"\",H199*L199)","v":""}]
[{"$nulls":9},"",0,null,""]

{"sheet":"Listen","index":1,"n_rows":7,"n_cols":5,"rows_kept":7}
["Kategorie","Lagerort","Einheit","Zustand","Lieferant"]
["Büro","Lager A","Stück","Neu","Lieferant A"]
["IT","Lager B","Pack","Gebraucht","Lieferant B"]
["Werkstatt","Regal 1","Set","Defekt","Lieferant C"]
["Reinigung","Regal 2","kg","Kühlware"]
["Verpackung","Kühlraum","l"]
["Lebensmittel",null,"m"]