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

{"sheet":"Bauzeitenplan","index":0,"n_rows":50,"n_cols":129,"rows_kept":50,"merged":[[0,0,1,10],[2,3,2,4],[2,5,2,6],[2,7,2,8],[2,9,2,10],[3,3,3,4],[3,5,3,6],[3,7,3,8],[3,9,3,10],[4,3,4,6],[4,7,4,10],[4,12,4,14],[5,12,5,14]]}
["Bauzeitenplan"]
[]
["Projekt","Proyecto Demo",null,"Arbeiten",null,"Abgeschlossen",null,"In Bearbeitung",null,"Im Verzug",null,null,"Ausgeschlossene Daten (Feiertage/Urlaub):",null,null,"Liste der Verantwortlichen →"]
["Aktuelles Datum","2025-10-04",null,{"$f":"COUNTA(B10:B50)","v":13},null,{"$f":"COUNTIF(H10:H50,\"Abgeschlossen\")","v":1},null,{"$f":"COUNTIF(H10:H50,\"In Bearbeitung\")","v":0},null,{"$f":"COUNTIF(H10:H50,\"Im Verzug\")","v":11},{"$nulls":5},"Ana Ruiz"]
["Projektbeginn",{"$f":"IFERROR(MIN(D10:D50),\"\")","v":"2025-10-04"},null,"Gesamtfortschritt",{"$nulls":3},{"$f":"IFERROR(AVERAGEIF(B10:B50,\"*\",G10:G50),0)","v":{"v":0.26666666666666666,"d":"27%"}},{"$nulls":4},"2025-12-25",null,null,"Carlos Gil"]
["Projektende",{"$f":"IFERROR(MAX(F10:F50),\"\")","v":"2025-11-13"},{"$nulls":10},"2025-12-31",null,null,"Lucía Vega"]
["Ausgeschlossene Tage",{"$f":"COUNTA(Excluidos)","v":3},{"$nulls":13},"Javier M."]
[{"$nulls":15},"Equipo"]
[{"$nulls":15},"Mario López"]
["Bauabschnitt","Tätigkeit","Verantwortlich","Startdatum","Dauer (Tage)","Enddatum","Fortschritt","Status",null,{"$f":"$B$5+0","v":"2025-10-04"},{"$f":"$B$5+1","v":"2025-10-05"},{"$f":"$B$5+2","v":"2025-10-06"},{"$f":"$B$5+3","v":"2025-10-07"},{"$f":"$B$5+4","v":"2025-10-08"},{"$f":"$B$5+5","v":"2025-10-09"},{"$f":"$B$5+6","v":"2025-10-10"},{"$f":"$B$5+7","v":"2025-10-11"},{"$f":"$B$5+8","v":"2025-10-12"},{"$f":"$B$5+9","v":"2025-10-13"},{"$f":"$B$5+10","v":"2025-10-14"},{"$f":"$B$5+11","v":"2025-10-15"},{"$f":"$B$5+12","v":"2025-10-16"},{"$f":"$B$5+13","v":"2025-10-17"},{"$f":"$B$5+14","v":"2025-10-18"},{"$f":"$B$5+15","v":"2025-10-19"},{"$f":"$B$5+16","v":"2025-10-20"},{"$f":"$B$5+17","v":"2025-10-21"},{"$f":"$B$5+18","v":"2025-10-22"},{"$f":"$B$5+19","v":"2025-10-23"},{"$f":"$B$5+20","v":"2025-10-24"},{"$f":"$B$5+21","v":"2025-10-25"},{"$f":"$B$5+22","v":"2025-10-26"},{"$f":"$B$5+23","v":"2025-10-27"},{"$f":"$B$5+24","v":"2025-10-28"},{"$f":"$B$5+25","v":"2025-10-29"},{"$f":"$B$5+26","v":"2025-10-30"},{"$f":"$B$5+27","v":"2025-10-31"},{"$f":"$B$5+28","v":"2025-11-01"},{"$f":"$B$5+29","v":"2025-11-02"},{"$f":"$B$5+30","v":"2025-11-03"},{"$f":"$B$5+31","v":"2025-11-04"},{"$f":"$B$5+32","v":"2025-11-05"},{"$f":"$B$5+33","v":"2025-11-06"},{"$f":"$B$5+34","v":"2025-11-07"},{"$f":"$B$5+35","v":"2025-11-08"},{"$f":"$B$5+36","v":"2025-11-09"},{"$f":"$B$5+37","v":"2025-11-10"},{"$f":"$B$5+38","v":"2025-11-11"},{"$f":"$B$5+39","v":"2025-11-12"},{"$f":"$B$5+40","v":"2025-11-13"},{"$f":"$B$5+41","v":"2025-11-14"},{"$f":"$B$5+42","v":"2025-11-15"},{"$f":"$B$5+43","v":"2025-11-16"},{"$f":"$B$5+44","v":"2025-11-17"},{"$f":"$B$5+45","v":"2025-11-18"},{"$f":"$B$5+46","v":"2025-11-19"},{"$f":"$B$5+47","v":"2025-11-20"},{"$f":"$B$5+48","v":"2025-11-21"},{"$f":"$B$5+49","v":"2025-11-22"},{"$f":"$B$5+50","v":"2025-11-23"},{"$f":"$B$5+51","v":"2025-11-24"},{"$f":"$B$5+52","v":"2025-11-25"},{"$f":"$B$5+53","v":"2025-11-26"},{"$f":"$B$5+54","v":"2025-11-27"},{"$f":"$B$5+55","v":"2025-11-28"},{"$f":"$B$5+56","v":"2025-11-29"},{"$f":"$B$5+57","v":"2025-11-30"},{"$f":"$B$5+58","v":"2025-12-01"},{"$f":"$B$5+59","v":"2025-12-02"},{"$f":"$B$5+60","v":"2025-12-03"},{"$f":"$B$5+61","v":"2025-12-04"},{"$f":"$B$5+62","v":"2025-12-05"},{"$f":"$B$5+63","v":"2025-12-06"},{"$f":"$B$5+64","v":"2025-12-07"},{"$f":"$B$5+65","v":"2025-12-08"},{"$f":"$B$5+66","v":"2025-12-09"},{"$f":"$B$5+67","v":"2025-12-10"},{"$f":"$B$5+68","v":"2025-12-11"},{"$f":"$B$5+69","v":"2025-12-12"},{"$f":"$B$5+70","v":"2025-12-13"},{"$f":"$B$5+71","v":"2025-12-14"},{"$f":"$B$5+72","v":"2025-12-15"},{"$f":"$B$5+73","v":"2025-12-16"},{"$f":"$B$5+74","v":"2025-12-17"},{"$f":"$B$5+75","v":"2025-12-18"},{"$f":"$B$5+76","v":"2025-12-19"},{"$f":"$B$5+77","v":"2025-12-20"},{"$f":"$B$5+78","v":"2025-12-21"},{"$f":"$B$5+79","v":"2025-12-22"},{"$f":"$B$5+80","v":"2025-12-23"},{"$f":"$B$5+81","v":"2025-12-24"},{"$f":"$B$5+82","v":"2025-12-25"},{"$f":"$B$5+83","v":"2025-12-26"},{"$f":"$B$5+84","v":"2025-12-27"},{"$f":"$B$5+85","v":"2025-12-28"},{"$f":"$B$5+86","v":"2025-12-29"},{"$f":"$B$5+87","v":"2025-12-30"},{"$f":"$B$5+88","v":"2025-12-31"},{"$f":"$B$5+89","v":"2026-01-01"},{"$f":"$B$5+90","v":"2026-01-02"},{"$f":"$B$5+91","v":"2026-01-03"},{"$f":"$B$5+92","v":"2026-01-04"},{"$f":"$B$5+93","v":"2026-01-05"},{"$f":"$B$5+94","v":"2026-01-06"},{"$f":"$B$5+95","v":"2026-01-07"},{"$f":"$B$5+96","v":"2026-01-08"},{"$f":"$B$5+97","v":"2026-01-09"},{"$f":"$B$5+98","v":"2026-01-10"},{"$f":"$B$5+99","v":"2026-01-11"},{"$f":"$B$5+100","v":"2026-01-12"},{"$f":"$B$5+101","v":"2026-01-13"},{"$f":"$B$5+102","v":"2026-01-14"},{"$f":"$B$5+103","v":"2026-01-15"},{"$f":"$B$5+104","v":"2026-01-16"},{"$f":"$B$5+105","v":"2026-01-17"},{"$f":"$B$5+106","v":"2026-01-18"},{"$f":"$B$5+107","v":"2026-01-19"},{"$f":"$B$5+108","v":"2026-01-20"},{"$f":"$B$5+109","v":"2026-01-21"},{"$f":"$B$5+110","v":"2026-01-22"},{"$f":"$B$5+111","v":"2026-01-23"},{"$f":"$B$5+112","v":"2026-01-24"},{"$f":"$B$5+113","v":"2026-01-25"},{"$f":"$B$5+114","v":"2026-01-26"},{"$f":"$B$5+115","v":"2026-01-27"},{"$f":"$B$5+116","v":"2026-01-28"},{"$f":"$B$5+117","v":"2026-01-29"},{"$f":"$B$5+118","v":"2026-01-30"},{"$f":"$B$5+119","v":"2026-01-31"}]
["Fase 1","Anforderungsanalyse","Ana Ruiz","2025-10-04",4,{"$f":"IF(AND(D11>0,E11>0),WORKDAY.INTL(D11,E11,1,Excluidos),\"\")","v":"2025-10-10"},{"v":0.8,"d":"80%"},{"$f":"IF(B11=\"\",\"\",IF(G11>=1,\"Abgeschlossen\",IF(AND(D11>0,E11>0,TODAY()>F11),\"Im Verzug\",IF(TODAY()>=D11,\"In Bearbeitung\",\"Nicht begonnen\"))))","v":"Im Verzug"}]
["Fase 1","Prozessmodellierung","Carlos Gil","2025-10-06",3,"2025-10-10",{"v":0.5,"d":"50%"},"Im Verzug"]
["Fase 1","Wireframe-Design","Lucía Vega","2025-10-09",5,"2025-10-16",{"v":0.3,"d":"30%"},"Im Verzug"]
["Fase 1","Kundenprüfung","Equipo","2025-10-15",2,"2025-10-17",{"v":0,"d":"0%"},"Im Verzug"]
["Fase 2","Umgebungseinrichtung","Javier M.","2025-10-07",3,"2025-10-10",{"v":1,"d":"100%"},"Abgeschlossen"]
["Fase 2","Backend-Entwicklung","Javier M.","2025-10-10",10,"2025-10-24",{"v":0.4,"d":"40%"},"Im Verzug"]
["Fase 2","Frontend-Entwicklung","Lucía Vega","2025-10-12",9,"2025-10-23",{"v":0.2,"d":"20%"},"Im Verzug"]
["Fase 2","API-Integration","Carlos Gil","2025-10-21",6,"2025-10-29",{"v":0,"d":"0%"},"Im Verzug"]
["Fase 3","Funktionstests","Equipo","2025-10-26",5,"2025-10-31",{"v":0,"d":"0%"},"Im Verzug"]
["Fase 3","Fehlerbehebung","Equipo","2025-11-01",4,"2025-11-06",{"v":0,"d":"0%"},"Im Verzug"]
["Fase 3","Benutzerakzeptanztest (UAT) mit dem Kunden","Ana Ruiz","2025-11-06",3,"2025-11-11",{"v":0,"d":"0%"},"Im Verzug"]
["Fase 3","Lieferung und Projektabschluss","Equipo","2025-11-11",2,"2025-11-13",{"v":0,"d":"0%"},"Im Verzug"]
[{"$nulls":5},"",null,""]
[{"$nulls":5},"",null,""]
[{"$nulls":5},"",null,""]
[{"$nulls":5},"",null,""]
[{"$nulls":5},"",null,""]
[{"$nulls":5},"",null,""]
[{"$nulls":5},"",null,""]
[{"$nulls":5},"",null,""]
[{"$nulls":5},"",null,""]
[{"$nulls":5},"",null,""]
[{"$nulls":5},"",null,""]
[{"$nulls":5},"",null,""]
[{"$nulls":5},"",null,""]
[{"$nulls":5},"",null,""]
[{"$nulls":5},"",null,""]
[{"$nulls":5},"",null,""]
[{"$nulls":5},"",null,""]
[{"$nulls":5},"",null,""]
[{"$nulls":5},"",null,""]
[{"$nulls":5},"",null,""]
[{"$nulls":5},"",null,""]
[{"$nulls":5},"",null,""]
[{"$nulls":5},"",null,""]
[{"$nulls":5},"",null,""]
[{"$nulls":5},"",null,""]
[{"$nulls":5},"",null,""]
[{"$nulls":5},"",null,""]
[{"$nulls":5},"",null,""]