{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Produktionsplan"],"not_rendered":{"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"Produktionsplan","index":0,"n_rows":200,"n_cols":17,"rows_kept":200,"merged":[[0,0,0,12],[3,0,3,12]]}
["Produktionsplan"]
["Planungsbeginn","2026-02-10",null,"Planungsende","2026-03-12",null,"Heute",{"$f":"TODAY()","v":"2026-02-10"},null,"Aufträge",{"$f":"SUBTOTAL(3,$B$7:$B$200)","v":15}]
[{"$nulls":9},"Überfällig",{"$f":"SUMPRODUCT(--($F$7:$F$200>0),--($F$7:$F$200<TODAY()),--($H$7:$H$200<>\"Fertig\"),--($H$7:$H$200<>\"Storniert\"))","v":3}]
["Trage Aufträge ein, wähle Status, und überprüfe Abweichungen. Filter sind aktiv."]
[]
["Auftrags-ID","Produkt","Geplante\nMenge","Einheit","Fertigungszeit\n(Tage)","Geplanter\nAbschluss","Geplanter\nStart","Status","Priorität","Verantwortlich","Tatsächlicher\nAbschluss","Abweichung\n(Tage)","Notizen",null,"LIST_Status","LIST_Priorität","LIST_Einheit"]
["P-001","Laptop",1000,"Stk",10,"2026-02-28",{"$f":"IF(OR(F7=\"\",E7=\"\"),\"\",F7-E7+1)","v":"2026-02-19"},"Geplant","Mittel","M. Keller",null,{"$f":"IF(F7=\"\",\"\",IF(K7=\"\",IF(OR(H7=\"Fertig\",H7=\"Storniert\"),\"\",MAX(0,TODAY()-F7)),K7-F7))","v":0},"Erstserie",null,"Geplant","Hoch","Stk"]
["P-002","Monitor",500,"Stk",7,"2026-02-20","2026-02-14","Geplant","Mittel","S. Brandt",null,0,null,null,"In Produktion","Mittel","kg"]
["P-003","Drucker",300,"Stk",5,"2026-02-18","2026-02-14","Geplant","Niedrig","T. Vogel",null,0,null,null,"Fertig","Niedrig","m"]
["P-004","Kabelsatz",1200,"Satz",3,"2026-02-12","2026-02-10","In Produktion","Hoch","A. Neumann",null,0,"Material eingetroffen",null,"Verzögert",null,"Satz"]
["P-005","Gehäuse",800,"Stk",6,"2026-02-05","2026-01-31","Verzögert","Hoch","L. Schmitt",null,5,"Lieferant verspätet",null,"Storniert"]
["P-006","Netzteil",650,"Stk",4,"2026-02-09","2026-02-06","In Produktion","Mittel","J. Braun",null,1]
["P-007","Sensor-Modul",200,"Stk",8,"2026-03-02","2026-02-23","Geplant","Hoch","K. Fischer",null,0,"Qualitätsprüfung einplanen"]
["P-008","Verpackung",1500,"Stk",2,"2026-02-08","2026-02-07","Fertig","Niedrig","P. Lange","2026-02-07",-1]
["P-009","Platine",400,"Stk",9,"2026-02-06","2026-01-29","Verzögert","Hoch","N. Weiss",null,4,"Testlauf fehlgeschlagen"]
["P-010","Rahmen",900,"Stk",5,"2026-02-24","2026-02-20","Geplant","Mittel","D. Hartmann",null,0]
["P-011","Kühlkörper",700,"Stk",4,"2026-02-04","2026-02-01","Fertig","Mittel","F. König","2026-02-05",1,"1 Tag später"]
["P-012","Motor",120,"Stk",12,"2026-03-10","2026-02-27","Geplant","Hoch","R. Maier",null,0,"Langläufer"]
["P-013","Schrauben",5000,"Stk",1,"2026-02-03","2026-02-03","Fertig","Niedrig","B. Winter","2026-02-03",0]
["P-014","Dichtung",1100,"Stk",2,"2026-02-11","2026-02-10","In Produktion","Mittel","C. Walter",null,0]
["P-015","Karton",1800,"Stk",2,"2026-02-02","2026-02-01","Storniert","Niedrig","E. Becker",null,"","Auftrag storniert"]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},{"$f":"IF(OR(F39=\"\",E39=\"\"),\"\",F39-E39+1)","v":""},{"$nulls":4},{"$f":"IF(F39=\"\",\"\",IF(K39=\"\",IF(OR(H39=\"Fertig\",H39=\"Storniert\"),\"\",MAX(0,TODAY()-F39)),K39-F39))","v":""}]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},{"$f":"IF(OR(F71=\"\",E71=\"\"),\"\",F71-E71+1)","v":""},{"$nulls":4},{"$f":"IF(F71=\"\",\"\",IF(K71=\"\",IF(OR(H71=\"Fertig\",H71=\"Storniert\"),\"\",MAX(0,TODAY()-F71)),K71-F71))","v":""}]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},{"$f":"IF(OR(F103=\"\",E103=\"\"),\"\",F103-E103+1)","v":""},{"$nulls":4},{"$f":"IF(F103=\"\",\"\",IF(K103=\"\",IF(OR(H103=\"Fertig\",H103=\"Storniert\"),\"\",MAX(0,TODAY()-F103)),K103-F103))","v":""}]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},{"$f":"IF(OR(F135=\"\",E135=\"\"),\"\",F135-E135+1)","v":""},{"$nulls":4},{"$f":"IF(F135=\"\",\"\",IF(K135=\"\",IF(OR(H135=\"Fertig\",H135=\"Storniert\"),\"\",MAX(0,TODAY()-F135)),K135-F135))","v":""}]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},{"$f":"IF(OR(F167=\"\",E167=\"\"),\"\",F167-E167+1)","v":""},{"$nulls":4},{"$f":"IF(F167=\"\",\"\",IF(K167=\"\",IF(OR(H167=\"Fertig\",H167=\"Storniert\"),\"\",MAX(0,TODAY()-F167)),K167-F167))","v":""}]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},"",{"$nulls":4},""]
[{"$nulls":6},{"$f":"IF(OR(F199=\"\",E199=\"\"),\"\",F199-E199+1)","v":""},{"$nulls":4},{"$f":"IF(F199=\"\",\"\",IF(K199=\"\",IF(OR(H199=\"Fertig\",H199=\"Storniert\"),\"\",MAX(0,TODAY()-F199)),K199-F199))","v":""}]
[{"$nulls":6},"",{"$nulls":4},""]