{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Muster-Bauzeitenplan-BauMaster","Feiertage"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":2,"defined_names":13,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Muster-Bauzeitenplan-BauMaster","index":0,"n_rows":30,"n_cols":45,"rows_kept":30,"cut":false,"hidden":false,"merged":[[26,2,27,2],[26,3,27,3],[26,4,27,4],[26,5,27,5],[26,6,27,6],[13,6,14,6],[13,7,14,7],[13,8,14,8],[18,3,19,3],[18,4,19,4],[18,5,19,5],[18,6,19,6],[18,7,19,7],[18,8,19,8],[15,8,16,8],[15,7,16,7],[15,6,16,6],[15,5,16,5],[15,4,16,4],[15,3,16,3],[9,6,10,6],[9,7,10,7],[9,8,10,8],[11,1,12,1],[11,2,12,2],[11,3,12,3],[11,4,12,4],[11,5,12,5],[11,6,12,6],[11,7,12,7],[11,8,12,8],[3,6,3,7],[4,6,4,7],[5,31,5,37],[5,38,5,44],[5,24,5,30],[5,10,5,16],[5,17,5,23],[4,17,4,23],[4,24,4,30],[4,31,4,37],[4,38,4,44],[4,10,4,16],[3,10,3,16],[3,17,3,23],[3,24,3,30],[3,31,3,37],[3,38,3,44],[3,4,3,5],[4,4,4,5],[5,4,5,5],[9,1,10,1],[9,2,10,2],[9,3,10,3],[9,4,10,4],[9,5,10,5],[13,1,14,1],[13,2,14,2],[13,3,14,3],[13,4,14,4],[13,5,14,5],[18,1,19,1],[18,2,19,2],[24,1,25,1],[24,2,25,2],[24,3,25,3],[24,4,25,4],[24,5,25,5],[24,6,25,6],[24,7,25,7],[24,8,25,8],[28,1,29,1],[28,2,29,2],[28,3,29,3],[28,4,29,4],[28,5,29,5],[28,6,29,6],[28,7,29,7],[28,8,29,8],[26,1,27,1],[26,7,27,7],[15,2,16,2],[15,1,16,1],[22,1,23,1],[22,2,23,2],[22,3,23,3],[22,4,23,4],[22,5,23,5],[22,6,23,6],[22,7,23,7],[20,2,21,2],[20,1,21,1],[22,8,23,8],[20,8,21,8],[20,7,21,7],[20,6,21,6],[20,5,21,5],[20,4,21,4],[20,3,21,3],[26,8,27,8]]}
[null,"BV Kneisl Ronald"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"K7","v":"2025-06-16"},{"$f":"K2+1","v":"2025-06-17"},{"$f":"L2+1","v":"2025-06-18"},"2025-06-19",{"$f":"N2+1","v":"2025-06-20"},{"$f":"O2+1","v":"2025-06-21"},"2025-06-22","2025-06-23",{"$f":"R2+1","v":"2025-06-24"},{"$f":"S2+1","v":"2025-06-25"},"2025-06-26","2025-06-27",{"$f":"V2+1","v":"2025-06-28"},{"$f":"W2+1","v":"2025-06-29"},"2025-06-30",{"$f":"Y2+1","v":"2025-07-01"},{"$f":"Z2+1","v":"2025-07-02"},{"$f":"AA2+1","v":"2025-07-03"},{"$f":"AB2+1","v":"2025-07-04"},{"$f":"AC2+1","v":"2025-07-05"},{"$f":"AD2+1","v":"2025-07-06"},"2025-07-07",{"$f":"AF2+1","v":"2025-07-08"},{"$f":"AG2+1","v":"2025-07-09"},{"$f":"AH2+1","v":"2025-07-10"},{"$f":"AI2+1","v":"2025-07-11"},{"$f":"AJ2+1","v":"2025-07-12"},{"$f":"AK2+1","v":"2025-07-13"},"2025-07-14",{"$f":"AM2+1","v":"2025-07-15"},{"$f":"AN2+1","v":"2025-07-16"},{"$f":"AO2+1","v":"2025-07-17"},{"$f":"AP2+1","v":"2025-07-18"},{"$f":"AQ2+1","v":"2025-07-19"},{"$f":"AR2+1","v":"2025-07-20"}]
[null,"Firma:","HAID & FALKNER"]
[null,"Projektleiter:","Caroline Santer",null,"Projektanfang:",null,"2025-06-16",null,null,null,{"$f":"Anzeigewoche","v":1},null,null,null,null,null,null,{"$f":"K4+1","v":2},null,null,null,null,null,null,{"$f":"R4+1","v":3},null,null,null,null,null,null,{"$f":"Y4+1","v":4},null,null,null,null,null,null,{"$f":"AF4+1","v":5}]
[null,"Bauleitung:","Simon Jeitner",null,"Projektende:",null,"2025-10-23",null,{"$f":"MAX(I18:I191)","v":"00:00:00"},null,{"$f":"WEEKNUM(K6)","v":25},null,null,null,null,null,null,{"$f":"WEEKNUM(R6)","v":26},null,null,null,null,null,null,{"$f":"WEEKNUM(Y6)","v":27},null,null,null,null,null,null,{"$f":"WEEKNUM(AF6)","v":28},null,null,null,null,null,null,{"$f":"WEEKNUM(AM6)","v":29}]
[null,"Datum heute",{"$f":"Heute","v":"2025-03-13"},null,"Projektwoche:",null,1,null,null,null,{"$f":"K7","v":"2025-06-16"},null,null,null,null,null,null,{"$f":"R7","v":"2025-06-23"},null,null,null,null,null,null,{"$f":"Y7","v":"2025-06-30"},null,null,null,null,null,null,{"$f":"AF7","v":"2025-07-07"},null,null,null,null,null,null,{"$f":"AM7","v":"2025-07-14"}]
[null,"Übersicht_Gewerke",null,null,null,"Feiertage:",null,null,null,null,{"$f":"Projektanfang-WEEKDAY(Projektanfang,1)+2+7*(Anzeigewoche-1)","v":"2025-06-16"},{"$f":"K7+1","v":"2025-06-17"},"2025-06-18","2025-06-19",{"$f":"N7+1","v":"2025-06-20"},{"$f":"O7+1","v":"2025-06-21"},"2025-06-22","2025-06-23","2025-06-24","2025-06-25","2025-06-26","2025-06-27",{"$f":"V7+1","v":"2025-06-28"},{"$f":"W7+1","v":"2025-06-29"},"2025-06-30",{"$f":"Y7+1","v":"2025-07-01"},{"$f":"Z7+1","v":"2025-07-02"},{"$f":"AA7+1","v":"2025-07-03"},{"$f":"AB7+1","v":"2025-07-04"},{"$f":"AC7+1","v":"2025-07-05"},{"$f":"AD7+1","v":"2025-07-06"},"2025-07-07",{"$f":"AF7+1","v":"2025-07-08"},{"$f":"AG7+1","v":"2025-07-09"},{"$f":"AH7+1","v":"2025-07-10"},{"$f":"AI7+1","v":"2025-07-11"},{"$f":"AJ7+1","v":"2025-07-12"},{"$f":"AK7+1","v":"2025-07-13"},"2025-07-14",{"$f":"AM7+1","v":"2025-07-15"},{"$f":"AN7+1","v":"2025-07-16"},{"$f":"AO7+1","v":"2025-07-17"},{"$f":"AP7+1","v":"2025-07-18"},{"$f":"AQ7+1","v":"2025-07-19"},{"$f":"AR7+1","v":"2025-07-20"}]
[null,"AUFGABE","Positionssummen","Tage (ohne SA u. SO)","Fortschritt IST","Fortschritt SOLL","START","ENDE","Verzög.","TAGE",{"$f":"LEFT(TEXT(K7,\"TTT\"),1)","v":"M"},"D","M","D","F",{"$f":"LEFT(TEXT(P7,\"TTT\"),2)","v":"Sa"},{"$f":"LEFT(TEXT(Q7,\"TTT\"),2)","v":"So"},"M","D","M","D","F",{"$f":"LEFT(TEXT(W7,\"TTT\"),2)","v":"Sa"},{"$f":"LEFT(TEXT(X7,\"TTT\"),2)","v":"So"},"M","D","M","D","F",{"$f":"LEFT(TEXT(AD7,\"TTT\"),2)","v":"Sa"},{"$f":"LEFT(TEXT(AE7,\"TTT\"),2)","v":"So"},"M","D","M","D","F",{"$f":"LEFT(TEXT(AK7,\"TTT\"),2)","v":"Sa"},{"$f":"LEFT(TEXT(AL7,\"TTT\"),2)","v":"So"},"M","D","M","D","F",{"$f":"LEFT(TEXT(AR7,\"TTT\"),2)","v":"Sa"},{"$f":"LEFT(TEXT(AS7,\"TTT\"),2)","v":"So"}]
[1,"Erdbau/Spritzbeton",{"$f":"COUNTIF(B10:C17,\"*\")","v":1},{"$f":"SUM(D10:D17)","v":0},{"$f":"SUM(E10:E17)/C9","v":0},{"$f":"SUM(F10:F17)/C9","v":0},{"$f":"MIN(G10:G17)","v":"00:00:00"},{"$f":"MAX(H10:H17)","v":"00:00:00"},{"$f":"IF(H9+SUM(I10:I15)=0,\"\",H9+SUM(I10:I15))","v":""},{"$f":"IF(OR(ISBLANK('[2]Muster-Bauzeitenplan-BauMaster'!task_start),ISBLANK('[2]Muster-Bauzeitenplan-BauMaster'!task_end)),\"\",'[2]Muster-Bauzeitenplan-BauMaster'!task_end-'[2]Muster-Bauzeitenplan-BauMaster'!task_start+1)","v":{"$error":"#NAME?"}},{"$f":"IF(OR($G9>K$2,$H9<K$2),\"\",\"-\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[{"$f":"A9","v":1},null,null,{"$f":"IF(G10=\"\",\"\",IF(NETWORKDAYS($G10,$H10)=0,\"\",NETWORKDAYS($G10,$H10,(Feiertage!$C$5:$C$17))))","v":""},0,{"$f":"IF(G10=0,\"\",IF($C$6>=H10,\"Erl\",IF(AND($C$6>G10,$C$6<H10),100-(100/D10*NETWORKDAYS($C$6,$H10)),\"\")))","v":""},null,{"$f":"IF(G10=\"\",\"\",G10)","v":""},null,{"$f":"IF(OR(ISBLANK('Muster-Bauzeitenplan-BauMaster'!task_start),ISBLANK('Muster-Bauzeitenplan-BauMaster'!task_end)),\"\",'Muster-Bauzeitenplan-BauMaster'!task_end-'Muster-Bauzeitenplan-BauMaster'!task_start+1)","v":{"$error":"#REF!"}},{"$f":"IF($G10=\"\",\"\",IF(AND(K$2>$H10,K$2<=$I10),50,IF(OR($G10>K$2,$H10<K$2),\"\",$A9)))","v":""},{"$f":"IF($G10=\"\",\"\",IF(AND(L$2>$H10,L$2<=$I10),50,IF(OR($G10>L$2,$H10<L$2),\"\",$A9)))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[{"$f":"A10","v":1},null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(K$2:Q$2,$H10)=1,$B10,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(COUNTIF(R$2:X$2,$H10)=1,$B10,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(COUNTIF(Y$2:AE$2,$H10)=1,$B10,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(COUNTIF(AF$2:AL$2,$H10)=1,$B10,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(COUNTIF(AM$2:AS$2,$H10)=1,$B10,\"\")","v":""}]
[{"$f":"A11","v":1},null,null,{"$f":"IF(G12=\"\",\"\",IF(NETWORKDAYS($G12,$H12)=0,\"\",NETWORKDAYS($G12,$H12,(Feiertage!$C$5:$C$17))))","v":""},0,{"$f":"IF(G12=0,\"\",IF($C$6>=H12,\"Erl\",IF(AND($C$6>G12,$C$6<H12),100-(100/D12*NETWORKDAYS($C$6,$H12)),\"\")))","v":""},null,{"$f":"IF(G12=\"\",\"\",G12)","v":""},null,{"$f":"IF(OR(ISBLANK('Muster-Bauzeitenplan-BauMaster'!task_start),ISBLANK('Muster-Bauzeitenplan-BauMaster'!task_end)),\"\",'Muster-Bauzeitenplan-BauMaster'!task_end-'Muster-Bauzeitenplan-BauMaster'!task_start+1)","v":{"$error":"#REF!"}},{"$f":"IF($G12=\"\",\"\",IF(AND(K$2>$H12,K$2<=$I12),50,IF(OR($G12>K$2,$H12<K$2),\"\",$A11)))","v":""},{"$f":"IF($G12=\"\",\"\",IF(AND(L$2>$H12,L$2<=$I12),50,IF(OR($G12>L$2,$H12<L$2),\"\",$A11)))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[1,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(K$2:Q$2,$H12)=1,$B12,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(COUNTIF(R$2:X$2,$H12)=1,$B12,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(COUNTIF(Y$2:AE$2,$H12)=1,$B12,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(COUNTIF(AF$2:AL$2,$H12)=1,$B12,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(COUNTIF(AM$2:AS$2,$H12)=1,$B12,\"\")","v":""}]
[1,null,null,{"$f":"IF(G14=\"\",\"\",IF(NETWORKDAYS($G14,$H14)=0,\"\",NETWORKDAYS($G14,$H14,(Feiertage!$C$5:$C$17))))","v":""},0,{"$f":"IF(G14=0,\"\",IF($C$6>=H14,\"Erl\",IF(AND($C$6>G14,$C$6<H14),100-(100/D14*NETWORKDAYS($C$6,$H14)),\"\")))","v":""},null,"",null,{"$f":"IF(OR(ISBLANK('Muster-Bauzeitenplan-BauMaster'!task_start),ISBLANK('Muster-Bauzeitenplan-BauMaster'!task_end)),\"\",'Muster-Bauzeitenplan-BauMaster'!task_end-'Muster-Bauzeitenplan-BauMaster'!task_start+1)","v":{"$error":"#REF!"}},{"$f":"IF($G14=\"\",\"\",IF(AND(K$2>$H14,K$2<=$I14),50,IF(OR($G14>K$2,$H14<K$2),\"\",$A13)))","v":""},{"$f":"IF($G14=\"\",\"\",IF(AND(L$2>$H14,L$2<=$I14),50,IF(OR($G14>L$2,$H14<L$2),\"\",$A13)))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[1,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(K$2:Q$2,$H14)=1,$B14,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(COUNTIF(R$2:X$2,$H14)=1,$B14,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(COUNTIF(Y$2:AE$2,$H14)=1,$B14,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(COUNTIF(AF$2:AL$2,$H14)=1,$B14,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(COUNTIF(AM$2:AS$2,$H14)=1,$B14,\"\")","v":""}]
[1,"beim Hinzufügen beide Zellen",null,{"$f":"IF(G16=\"\",\"\",IF(NETWORKDAYS($G16,$H16)=0,\"\",NETWORKDAYS($G16,$H16,(Feiertage!$C$5:$C$17))))","v":""},0,{"$f":"IF(G16=0,\"\",IF($C$6>=H16,\"Erl\",IF(AND($C$6>G16,$C$6<H16),100-(100/D16*NETWORKDAYS($C$6,$H16)),\"\")))","v":""},null,{"$f":"IF(G16=\"\",\"\",G16)","v":""},null,{"$f":"IF(OR(ISBLANK('Muster-Bauzeitenplan-BauMaster'!task_start),ISBLANK('Muster-Bauzeitenplan-BauMaster'!task_end)),\"\",'Muster-Bauzeitenplan-BauMaster'!task_end-'Muster-Bauzeitenplan-BauMaster'!task_start+1)","v":{"$error":"#REF!"}},{"$f":"IF(COUNTIF(K$2:Q$2,$H15)=1,$B15,\"\")","v":""},{"$f":"IF(COUNTIF(L$2:R$2,$H15)=1,$B15,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[1,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(K$2:Q$2,$H16)=1,$B16,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(COUNTIF(R$2:X$2,$H16)=1,$B16,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(COUNTIF(Y$2:AE$2,$H16)=1,$B16,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(COUNTIF(AF$2:AL$2,$H16)=1,$B16,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(COUNTIF(AM$2:AS$2,$H16)=1,$B16,\"\")","v":""}]
[2,"Baumeister",{"$f":"COUNTIF(B19:C30,\"*\")","v":1},{"$f":"SUM(D19:D30)","v":0},{"$f":"SUM(E19:E30)/C18","v":0},{"$f":"SUM(F19:F30)/C18","v":0},{"$f":"MIN(G19:G30)","v":"00:00:00"},{"$f":"MAX(H19:H30)","v":"00:00:00"},{"$f":"IF(H18+SUM(I19:I24)=0,\"\",H18+SUM(I19:I24))","v":""},{"$f":"IF(OR(ISBLANK('Muster-Bauzeitenplan-BauMaster'!task_start),ISBLANK('Muster-Bauzeitenplan-BauMaster'!task_end)),\"\",'Muster-Bauzeitenplan-BauMaster'!task_end-'Muster-Bauzeitenplan-BauMaster'!task_start+1)","v":{"$error":"#REF!"}},{"$f":"IF(OR($G18>K$2,$H18<K$2),\"\",\"-\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[{"$f":"A18","v":2},null,null,{"$f":"IF(G19=\"\",\"\",IF(NETWORKDAYS($G19,$H19)=0,\"\",NETWORKDAYS($G19,$H19,(Feiertage!$C$5:$C$17))))","v":""},0,{"$f":"IF(G19=0,\"\",IF($C$6>=H19,\"Erl\",IF(AND($C$6>G19,$C$6<H19),100-(100/D19*NETWORKDAYS($C$6,$H19)),\"\")))","v":""},null,{"$f":"IF(G19=\"\",\"\",G19)","v":""},null,{"$f":"IF(OR(ISBLANK('Muster-Bauzeitenplan-BauMaster'!task_start),ISBLANK('Muster-Bauzeitenplan-BauMaster'!task_end)),\"\",'Muster-Bauzeitenplan-BauMaster'!task_end-'Muster-Bauzeitenplan-BauMaster'!task_start+1)","v":{"$error":"#REF!"}},{"$f":"IF($G19=\"\",\"\",IF(AND(K$2>$H19,K$2<=$I19),50,IF(OR($G19>K$2,$H19<K$2),\"\",$A18)))","v":""},{"$f":"IF($G19=\"\",\"\",IF(AND(L$2>$H19,L$2<=$I19),50,IF(OR($G19>L$2,$H19<L$2),\"\",$A18)))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[{"$f":"A19","v":2},null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(K$2:Q$2,$H19)=1,$B19,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(COUNTIF(R$2:X$2,$H19)=1,$B19,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(COUNTIF(Y$2:AE$2,$H19)=1,$B19,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(COUNTIF(AF$2:AL$2,$H19)=1,$B19,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(COUNTIF(AM$2:AS$2,$H19)=1,$B19,\"\")","v":""}]
[{"$f":"A20","v":2},null,null,{"$f":"IF(G21=\"\",\"\",IF(NETWORKDAYS($G21,$H21)=0,\"\",NETWORKDAYS($G21,$H21,(Feiertage!$C$5:$C$17))))","v":""},0,{"$f":"IF(G21=0,\"\",IF($C$6>=H21,\"Erl\",IF(AND($C$6>G21,$C$6<H21),100-(100/D21*NETWORKDAYS($C$6,$H21)),\"\")))","v":""},null,"",null,{"$f":"IF(OR(ISBLANK('Muster-Bauzeitenplan-BauMaster'!task_start),ISBLANK('Muster-Bauzeitenplan-BauMaster'!task_end)),\"\",'Muster-Bauzeitenplan-BauMaster'!task_end-'Muster-Bauzeitenplan-BauMaster'!task_start+1)","v":{"$error":"#REF!"}},{"$f":"IF($G21=\"\",\"\",IF(AND(K$2>$H21,K$2<=$I21),50,IF(OR($G21>K$2,$H21<K$2),\"\",$A20)))","v":""},{"$f":"IF($G21=\"\",\"\",IF(AND(L$2>$H21,L$2<=$I21),50,IF(OR($G21>L$2,$H21<L$2),\"\",$A20)))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[2,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(K$2:Q$2,$H21)=1,$B21,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(COUNTIF(R$2:X$2,$H21)=1,$B21,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(COUNTIF(Y$2:AE$2,$H21)=1,$B21,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(COUNTIF(AF$2:AL$2,$H21)=1,$B21,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(COUNTIF(AM$2:AS$2,$H21)=1,$B21,\"\")","v":""}]
[2,null,null,{"$f":"IF(G23=\"\",\"\",IF(NETWORKDAYS($G23,$H23)=0,\"\",NETWORKDAYS($G23,$H23,(Feiertage!$C$5:$C$17))))","v":""},0,{"$f":"IF(G23=0,\"\",IF($C$6>=H23,\"Erl\",IF(AND($C$6>G23,$C$6<H23),100-(100/D23*NETWORKDAYS($C$6,$H23)),\"\")))","v":""},null,{"$f":"IF(G23=\"\",\"\",G23)","v":""},null,{"$f":"IF(OR(ISBLANK('Muster-Bauzeitenplan-BauMaster'!task_start),ISBLANK('Muster-Bauzeitenplan-BauMaster'!task_end)),\"\",'Muster-Bauzeitenplan-BauMaster'!task_end-'Muster-Bauzeitenplan-BauMaster'!task_start+1)","v":{"$error":"#REF!"}},{"$f":"IF($G23=\"\",\"\",IF(AND(K$2>$H23,K$2<=$I23),50,IF(OR($G23>K$2,$H23<K$2),\"\",$A22)))","v":""},{"$f":"IF($G23=\"\",\"\",IF(AND(L$2>$H23,L$2<=$I23),50,IF(OR($G23>L$2,$H23<L$2),\"\",$A22)))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[2,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(K$2:Q$2,$H23)=1,$B23,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(COUNTIF(R$2:X$2,$H23)=1,$B23,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(COUNTIF(Y$2:AE$2,$H23)=1,$B23,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(COUNTIF(AF$2:AL$2,$H23)=1,$B23,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(COUNTIF(AM$2:AS$2,$H23)=1,$B23,\"\")","v":""}]
[2,null,null,{"$f":"IF(G25=\"\",\"\",IF(NETWORKDAYS($G25,$H25)=0,\"\",NETWORKDAYS($G25,$H25,(Feiertage!$C$5:$C$17))))","v":""},0,{"$f":"IF(G25=0,\"\",IF($C$6>=H25,\"Erl\",IF(AND($C$6>G25,$C$6<H25),100-(100/D25*NETWORKDAYS($C$6,$H25)),\"\")))","v":""},null,{"$f":"IF(G25=\"\",\"\",G25)","v":""},null,{"$f":"IF(OR(ISBLANK('Muster-Bauzeitenplan-BauMaster'!task_start),ISBLANK('Muster-Bauzeitenplan-BauMaster'!task_end)),\"\",'Muster-Bauzeitenplan-BauMaster'!task_end-'Muster-Bauzeitenplan-BauMaster'!task_start+1)","v":{"$error":"#REF!"}},{"$f":"IF($G25=\"\",\"\",IF(AND(K$2>$H25,K$2<=$I25),50,IF(OR($G25>K$2,$H25<K$2),\"\",$A24)))","v":""},{"$f":"IF($G25=\"\",\"\",IF(AND(L$2>$H25,L$2<=$I25),50,IF(OR($G25>L$2,$H25<L$2),\"\",$A24)))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[2,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(K$2:Q$2,$H25)=1,$B25,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(COUNTIF(R$2:X$2,$H25)=1,$B25,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(COUNTIF(Y$2:AE$2,$H25)=1,$B25,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(COUNTIF(AF$2:AL$2,$H25)=1,$B25,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(COUNTIF(AM$2:AS$2,$H25)=1,$B25,\"\")","v":""}]
[2,null,null,{"$f":"IF(G27=\"\",\"\",IF(NETWORKDAYS($G27,$H27)=0,\"\",NETWORKDAYS($G27,$H27,(Feiertage!$C$5:$C$17))))","v":""},0,{"$f":"IF(G27=0,\"\",IF($C$6>=H27,\"Erl\",IF(AND($C$6>G27,$C$6<H27),100-(100/D27*NETWORKDAYS($C$6,$H27)),\"\")))","v":""},null,{"$f":"IF(G27=\"\",\"\",G27)","v":""},null,{"$f":"IF(OR(ISBLANK('Muster-Bauzeitenplan-BauMaster'!task_start),ISBLANK('Muster-Bauzeitenplan-BauMaster'!task_end)),\"\",'Muster-Bauzeitenplan-BauMaster'!task_end-'Muster-Bauzeitenplan-BauMaster'!task_start+1)","v":{"$error":"#REF!"}},{"$f":"IF($G27=\"\",\"\",IF(AND(K$2>$H27,K$2<=$I27),50,IF(OR($G27>K$2,$H27<K$2),\"\",$A26)))","v":""},{"$f":"IF($G27=\"\",\"\",IF(AND(L$2>$H27,L$2<=$I27),50,IF(OR($G27>L$2,$H27<L$2),\"\",$A26)))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[2,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(K$2:Q$2,$H27)=1,$B27,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(COUNTIF(R$2:X$2,$H27)=1,$B27,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(COUNTIF(Y$2:AE$2,$H27)=1,$B27,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(COUNTIF(AF$2:AL$2,$H27)=1,$B27,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(COUNTIF(AM$2:AS$2,$H27)=1,$B27,\"\")","v":""}]
[2,"beim Hinzufügen beide Zellen",null,{"$f":"IF(G29=\"\",\"\",IF(NETWORKDAYS($G29,$H29)=0,\"\",NETWORKDAYS($G29,$H29,(Feiertage!$C$5:$C$17))))","v":""},0,{"$f":"IF(G29=0,\"\",IF($C$6>=H29,\"Erl\",IF(AND($C$6>G29,$C$6<H29),100-(100/D29*NETWORKDAYS($C$6,$H29)),\"\")))","v":""},null,{"$f":"IF(G29=\"\",\"\",G29)","v":""},null,{"$f":"IF(OR(ISBLANK('Muster-Bauzeitenplan-BauMaster'!task_start),ISBLANK('Muster-Bauzeitenplan-BauMaster'!task_end)),\"\",'Muster-Bauzeitenplan-BauMaster'!task_end-'Muster-Bauzeitenplan-BauMaster'!task_start+1)","v":{"$error":"#REF!"}},{"$f":"IF($G29=\"\",\"\",IF(AND(K$2>$H29,K$2<=$I29),50,IF(OR($G29>K$2,$H29<K$2),\"\",$A28)))","v":""},{"$f":"IF($G29=\"\",\"\",IF(AND(L$2>$H29,L$2<=$I29),50,IF(OR($G29>L$2,$H29<L$2),\"\",$A28)))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[2,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(K$2:Q$2,$H29)=1,$B29,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(COUNTIF(R$2:X$2,$H29)=1,$B29,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(COUNTIF(Y$2:AE$2,$H29)=1,$B29,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(COUNTIF(AF$2:AL$2,$H29)=1,$B29,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(COUNTIF(AM$2:AS$2,$H29)=1,$B29,\"\")","v":""}]

{"sheet":"Feiertage","index":1,"n_rows":17,"n_cols":4,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"Tag","Datum","Feiertag"]
[null,"Mittwoch","2025-01-01","Neujahrstag"]
[null,"Montag","2025-01-06","Heilige Drei Könige"]
[null,"Montag","2025-04-21","Ostermontag"]
[null,"Donnerstag","2025-05-01","Staatsfeiertag"]
[null,"Donnerstag","2025-05-29","Christi Himmelfahrt"]
[null,"Montag","2025-06-09","Pfingstmontag"]
[null,"Donnerstag","2025-06-19","Fronleichnam"]
[null,"Freitag","2025-08-15","Maria Himmelfahrt"]
[null,"Sonntag","2025-10-26","Nationalfeiertag"]
[null,"Samstag","2025-11-01","Allerheiligen"]
[null,"Montag","2025-12-08","Maria Empfängnis"]
[null,"Donnerstag","2025-12-25","Christtag"]
[null,"Freitag","2025-12-26","Stephanstag"]