{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Bestandsliste"],"read":"whole","date_system":"1900"}

{"sheet":"Bestandsliste","index":0,"n_rows":206,"n_cols":18,"rows_kept":206,"merged":[[0,0,0,12],[1,0,1,12],[2,0,2,2],[2,3,2,5],[2,6,2,8],[2,9,2,11],[3,0,3,2],[3,3,3,5],[3,6,3,8],[3,9,3,11]]}
["              Bestandsliste (Lagerbestand)",{"$nulls":13},"Liste_Kategorie","Liste_Lagerort","Liste_Einheit","Liste_Status"]
["Trage deine Artikel in die Tabelle ein. Filter oben nutzen. Mindestbestand zeigt Nachbestellbedarf.",{"$nulls":13},"Büro","Lager 1","Stk","neu"]
["Positionen",null,null,"Gesamtbestand",null,null,"Gesamtwert (€)",null,null,"Unter Mindestbestand",{"$nulls":4},"IT","Lager 2","Karton","gebraucht"]
[{"$f":"COUNTA(tblBestand[Artikelnummer])","v":5},null,null,{"$f":"SUM(tblBestand[Bestand])","v":68},null,null,{"$f":"SUM(tblBestand[Gesamtwert (€)])","v":{"v":9461,"d":"€ 9,461.00"}},null,null,{"$f":"COUNTIF(tblBestand[Nachbestellmenge],\">0\")","v":2},{"$nulls":4},"Werkzeuge","Regal A","kg","defekt"]
[{"$nulls":14},"Verbrauchsmaterial","Regal B","m","bestellt"]
["Artikelnummer","Bezeichnung","Kategorie","Lagerort","Einheit","Status","Bestand","Mindestbestand","Nachbestellmenge","Einstandspreis (€)","Gesamtwert (€)","Lieferant","Notizen",null,"Ersatzteile","Büro","l","eingetroffen"]
["A001","Laptop 14 Zoll","IT","Büro","Stk","neu",10,5,{"$f":"MAX(0,H7-G7)","v":0},{"v":850,"d":"€ 850.00"},{"$f":"G7*J7","v":{"v":8500,"d":"€ 8,500.00"}},"Lieferant X","Standardgerät für Mitarbeitende",null,"Sonstiges","Werkstatt","Set"]
["A002","Maus kabellos","IT","Büro","Stk","neu",50,20,0,{"v":12,"d":"€ 12.00"},{"v":600,"d":"€ 600.00"},"Lieferant Y"]
["A003","Druckerpapier A4","Verbrauchsmaterial","Regal A","Karton","neu",6,8,2,{"v":28.5,"d":"€ 28.50"},{"v":171,"d":"€ 171.00"},"Office Supply GmbH","Nachfüllen bis Mindestbestand"]
["A004","Akkuschrauber","Werkzeuge","Werkstatt","Stk","gebraucht",2,1,0,{"v":95,"d":"€ 95.00"},{"v":190,"d":"€ 190.00"},"ToolShop"]
["A005","Monitor 24 Zoll","IT","Lager 1","Stk","defekt",0,2,2,{"v":150,"d":"€ 150.00"},{"v":0,"d":"€ 0.00"},"Lieferant X","Aussondern / Ersatz bestellen"]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},{"$f":"MAX(0,H39-G39)","v":0},null,{"$f":"G39*J39","v":{"v":0,"d":"€ 0.00"}}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},{"$f":"MAX(0,H71-G71)","v":0},null,{"$f":"G71*J71","v":{"v":0,"d":"€ 0.00"}}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},{"$f":"MAX(0,H103-G103)","v":0},null,{"$f":"G103*J103","v":{"v":0,"d":"€ 0.00"}}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},{"$f":"MAX(0,H135-G135)","v":0},null,{"$f":"G135*J135","v":{"v":0,"d":"€ 0.00"}}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},{"$f":"MAX(0,H167-G167)","v":0},null,{"$f":"G167*J167","v":{"v":0,"d":"€ 0.00"}}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},{"$f":"MAX(0,H199-G199)","v":0},null,{"$f":"G199*J199","v":{"v":0,"d":"€ 0.00"}}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":8},0,null,{"v":0,"d":"€ 0.00"}]