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

{"sheet":"Produktionsplan","index":0,"n_rows":206,"n_cols":10,"rows_kept":206,"merged":[[0,0,0,9]]}
["             Produktionsplan"]
["Plan-Start (Datum)",{"$f":"TODAY()","v":"2026-02-10"},"Horizont (Tage)",31,"Stand",{"$f":"TODAY()","v":"2026-02-10"}]
["Anzahl Produkte",{"$f":"COUNTA($A$7:$A$206)","v":10},"Gesamtmenge",{"$f":"SUM($B$7:$B$206)","v":7110},"Überfällig",{"$f":"COUNTIFS($D$7:$D$206,\"<\"&TODAY(),$F$7:$F$206,\"<>Fertig\",$F$7:$F$206,\"<>Storniert\")","v":0}]
[]
[]
["Produkt","Geplante\nMenge","Fertigungszeit\n(Tage)","Geplanter\nçAbschluss","Geplanter\nStart","Status","% Fertig","Tatsächlicher Abschluss","Abweichung (Tage)","Kommentar"]
["Laptop",1000,10,"2026-03-07",{"$f":"IF($D7=\"\",\"\",WORKDAY($D7,-($C7-1)))","v":"2026-02-24"},"In Arbeit",{"v":0.35,"d":"35%"},null,{"$f":"IF($D7=\"\",\"\",IF($H7<>\"\",$H7-$D7,IF(AND(TODAY()>$D7,$F7<>\"Fertig\",$F7<>\"Storniert\"),TODAY()-$D7,\"\")))","v":""}]
["Monitor",500,7,"2026-02-28","2026-02-20","Geplant",{"v":0,"d":"0%"},null,""]
["Drucker",300,5,"2026-02-25","2026-02-19","Fertig",{"v":1,"d":"100%"},"2026-02-24",-1,"1 Tag früher fertig"]
["Tastatur",1500,3,"2026-02-15","2026-02-12","Pausiert",{"v":0.4,"d":"40%"},null,"","Material fehlt"]
["Maus",2000,2,"2026-02-12","2026-02-11","Storniert",{"v":0,"d":"0%"},null,"","Kunde storniert"]
["Dockingstation",250,8,"2026-03-20","2026-03-11","Geplant",{"v":0,"d":"0%"},null,""]
["Webcam",800,4,"2026-02-18","2026-02-13","In Arbeit",{"v":0.6,"d":"60%"},null,""]
["Headset",600,6,"2026-02-22","2026-02-16","In Arbeit",{"v":0.25,"d":"25%"},null,""]
["Router",120,9,"2026-03-02","2026-02-18","Geplant",{"v":0,"d":"0%"},null,""]
["Beamer",40,12,"2026-03-30","2026-03-13","Geplant",{"v":0,"d":"0%"},null,""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},{"$f":"IF($D39=\"\",\"\",WORKDAY($D39,-($C39-1)))","v":""},{"$nulls":3},{"$f":"IF($D39=\"\",\"\",IF($H39<>\"\",$H39-$D39,IF(AND(TODAY()>$D39,$F39<>\"Fertig\",$F39<>\"Storniert\"),TODAY()-$D39,\"\")))","v":""}]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},{"$f":"IF($D71=\"\",\"\",WORKDAY($D71,-($C71-1)))","v":""},{"$nulls":3},{"$f":"IF($D71=\"\",\"\",IF($H71<>\"\",$H71-$D71,IF(AND(TODAY()>$D71,$F71<>\"Fertig\",$F71<>\"Storniert\"),TODAY()-$D71,\"\")))","v":""}]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},{"$f":"IF($D103=\"\",\"\",WORKDAY($D103,-($C103-1)))","v":""},{"$nulls":3},{"$f":"IF($D103=\"\",\"\",IF($H103<>\"\",$H103-$D103,IF(AND(TODAY()>$D103,$F103<>\"Fertig\",$F103<>\"Storniert\"),TODAY()-$D103,\"\")))","v":""}]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},{"$f":"IF($D135=\"\",\"\",WORKDAY($D135,-($C135-1)))","v":""},{"$nulls":3},{"$f":"IF($D135=\"\",\"\",IF($H135<>\"\",$H135-$D135,IF(AND(TODAY()>$D135,$F135<>\"Fertig\",$F135<>\"Storniert\"),TODAY()-$D135,\"\")))","v":""}]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},{"$f":"IF($D167=\"\",\"\",WORKDAY($D167,-($C167-1)))","v":""},{"$nulls":3},{"$f":"IF($D167=\"\",\"\",IF($H167<>\"\",$H167-$D167,IF(AND(TODAY()>$D167,$F167<>\"Fertig\",$F167<>\"Storniert\"),TODAY()-$D167,\"\")))","v":""}]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},{"$f":"IF($D199=\"\",\"\",WORKDAY($D199,-($C199-1)))","v":""},{"$nulls":3},{"$f":"IF($D199=\"\",\"\",IF($H199<>\"\",$H199-$D199,IF(AND(TODAY()>$D199,$F199<>\"Fertig\",$F199<>\"Storniert\"),TODAY()-$D199,\"\")))","v":""}]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]
[{"$nulls":4},"",{"$nulls":3},""]