{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["aktuell"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":1,"defined_names":2,"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":"aktuell","index":0,"n_rows":226,"n_cols":152,"rows_kept":226,"cut":false,"hidden":false,"merged":[[187,126,187,132],[180,6,180,17],[180,18,180,29],[180,30,180,41],[180,42,180,53],[180,54,180,65],[180,66,180,77],[181,126,181,132],[182,6,182,17],[182,18,182,29],[182,30,182,41],[182,42,182,53],[182,54,182,65],[182,66,182,77],[182,78,182,89],[182,90,182,101],[182,102,182,113],[182,114,182,125],[187,6,187,17],[187,18,187,29],[187,30,187,41],[187,42,187,53],[187,54,187,65],[187,66,187,77],[188,126,188,132],[189,126,189,132],[188,6,188,17],[188,18,188,29],[188,30,188,41],[188,42,188,53],[188,54,188,65],[188,102,188,113],[188,114,188,125],[188,66,188,77],[188,78,188,89],[188,90,188,101],[5,6,5,21],[6,6,6,8],[178,6,178,17],[178,18,178,29],[178,30,178,41],[187,90,187,101],[187,102,187,113],[187,114,187,125],[185,6,185,17],[185,18,185,29],[181,102,181,113],[181,6,181,17],[181,18,181,29],[181,30,181,41],[181,42,181,53],[181,54,181,65],[181,66,181,77],[181,114,181,125],[179,6,179,17],[179,18,179,29],[179,30,179,41],[179,42,179,53],[179,54,179,65],[179,66,179,77],[180,90,180,101],[178,114,178,125],[180,114,180,125],[187,78,187,89],[3,95,3,120],[5,89,5,120],[3,89,3,94],[178,102,178,113],[180,102,180,113],[180,78,180,89],[179,78,179,89],[179,90,179,101],[179,102,179,113],[179,114,179,125],[185,78,185,89],[185,90,185,101],[185,102,185,113],[186,114,186,125],[157,134,157,139],[157,146,157,151],[157,140,157,145],[168,126,168,132],[167,126,167,132],[166,126,166,132],[165,126,165,132],[164,126,164,132],[163,126,163,132],[162,126,162,132],[160,126,160,132],[159,126,159,132],[167,140,167,145],[166,140,166,145],[165,140,165,145],[164,140,164,145],[163,140,163,145],[162,140,162,145],[160,140,160,145],[159,140,159,145],[165,146,165,151],[168,146,168,151],[168,134,168,139],[158,134,158,139],[186,6,186,17],[186,18,186,29],[186,30,186,41],[186,42,186,53],[186,54,186,65],[186,66,186,77],[186,78,186,89],[186,90,186,101],[186,102,186,113],[186,126,186,132],[176,146,176,151],[175,146,175,151],[174,146,174,151],[173,146,173,151],[172,146,172,151],[171,146,171,151],[168,140,168,145],[185,30,185,41],[185,42,185,53],[185,54,185,65],[185,66,185,77],[170,126,170,132],[178,90,178,101],[185,114,185,125],[182,126,182,132],[181,78,181,89],[181,90,181,101],[180,126,180,132],[179,126,179,132],[178,42,178,53],[178,54,178,65],[178,66,178,77],[178,78,178,89],[192,114,192,125],[192,126,192,132],[192,133,192,151],[193,6,193,17],[193,18,193,29],[193,30,193,41],[193,42,193,53],[193,54,193,65],[193,66,193,77],[193,78,193,89],[193,90,193,101],[193,102,193,113],[193,114,193,125],[193,126,193,132],[193,133,193,151],[192,6,192,17],[192,18,192,29],[192,30,192,41],[192,42,192,53],[192,54,192,65],[192,66,192,77],[192,78,192,89],[192,90,192,101],[192,102,192,113],[194,114,194,125],[194,126,194,132],[194,133,194,151],[195,6,195,17],[195,18,195,29],[195,30,195,41],[195,42,195,53],[195,54,195,65],[195,66,195,77],[195,78,195,89],[195,90,195,101],[195,102,195,113],[195,114,195,125],[195,126,195,132],[195,133,195,151],[194,6,194,17],[194,18,194,29],[194,30,194,41],[194,42,194,53],[194,54,194,65],[194,66,194,77],[194,78,194,89],[194,90,194,101],[194,102,194,113],[196,114,196,125],[196,126,196,132],[196,133,196,151],[197,6,197,17],[197,18,197,29],[197,30,197,41],[197,42,197,53],[197,54,197,65],[197,66,197,77],[197,78,197,89],[197,90,197,101],[197,102,197,113],[197,114,197,125],[197,126,197,132],[197,133,197,151],[196,6,196,17],[196,18,196,29],[196,30,196,41],[196,42,196,53],[196,54,196,65],[196,66,196,77],[196,78,196,89],[196,90,196,101],[196,102,196,113],[198,114,198,125],[198,126,198,132],[198,133,198,151],[199,6,199,17],[199,18,199,29],[199,30,199,41],[199,42,199,53],[199,54,199,65],[199,66,199,77],[199,78,199,89],[199,90,199,101],[199,102,199,113],[199,114,199,125],[199,126,199,132],[199,133,199,151],[198,6,198,17],[198,18,198,29],[198,30,198,41],[198,42,198,53],[198,54,198,65],[198,66,198,77],[198,78,198,89],[198,90,198,101],[198,102,198,113],[200,114,200,125],[200,126,200,132],[200,133,200,151],[201,6,201,17],[201,18,201,29],[201,30,201,41],[201,42,201,53],[201,54,201,65],[201,66,201,77],[201,78,201,89],[201,90,201,101],[201,102,201,113],[201,114,201,125],[201,126,201,132],[201,133,201,151],[200,6,200,17],[200,18,200,29],[200,30,200,41],[200,42,200,53],[200,54,200,65],[200,66,200,77],[200,78,200,89],[200,90,200,101],[200,102,200,113],[202,114,202,125],[202,126,202,132],[202,133,202,151],[203,6,203,17],[203,18,203,29],[203,30,203,41],[203,42,203,53],[203,54,203,65],[203,66,203,77],[203,78,203,89],[203,90,203,101],[203,102,203,113],[203,114,203,125],[203,126,203,132],[203,133,203,151],[202,6,202,17],[202,18,202,29],[202,30,202,41],[202,42,202,53],[202,54,202,65],[202,66,202,77],[202,78,202,89],[202,90,202,101],[202,102,202,113],[204,114,204,125],[204,126,204,132],[204,133,204,151],[205,6,205,17],[205,18,205,29],[205,30,205,41],[205,42,205,53],[205,54,205,65],[205,66,205,77],[205,78,205,89],[205,90,205,101],[205,102,205,113],[205,114,205,125],[205,126,205,132],[205,133,205,151],[204,6,204,17],[204,18,204,29],[204,30,204,41],[204,42,204,53],[204,54,204,65],[204,66,204,77],[204,78,204,89],[204,90,204,101],[204,102,204,113],[206,114,206,125],[206,126,206,132],[206,133,206,151],[207,6,207,17],[207,18,207,29],[207,30,207,41],[207,42,207,53],[207,54,207,65],[207,66,207,77],[207,78,207,89],[207,90,207,101],[207,102,207,113],[207,114,207,125],[207,126,207,132],[207,133,207,151],[206,6,206,17],[206,18,206,29],[206,30,206,41],[206,42,206,53],[206,54,206,65],[206,66,206,77],[206,78,206,89],[206,90,206,101],[206,102,206,113],[208,114,208,125],[208,126,208,132],[208,133,208,151],[209,6,209,17],[209,18,209,29],[209,30,209,41],[209,42,209,53],[209,54,209,65],[209,66,209,77],[209,78,209,89],[209,90,209,101],[209,102,209,113],[209,114,209,125],[209,126,209,132],[209,133,209,151],[208,6,208,17],[208,18,208,29],[208,30,208,41],[208,42,208,53],[208,54,208,65],[208,66,208,77],[208,78,208,89],[208,90,208,101],[208,102,208,113],[210,114,210,125],[210,126,210,132],[210,133,210,151],[211,6,211,17],[211,18,211,29],[211,30,211,41],[211,42,211,53],[211,54,211,65],[211,66,211,77],[211,78,211,89],[211,90,211,101],[211,102,211,113],[211,114,211,125],[211,126,211,132],[211,133,211,151],[210,6,210,17],[210,18,210,29],[210,30,210,41],[210,42,210,53],[210,54,210,65],[210,66,210,77],[210,78,210,89],[210,90,210,101],[210,102,210,113],[212,114,212,125],[212,126,212,132],[212,133,212,151],[213,6,213,17],[213,18,213,29],[213,30,213,41],[213,42,213,53],[213,54,213,65],[213,66,213,77],[213,78,213,89],[213,90,213,101],[213,102,213,113],[213,114,213,125],[213,126,213,132],[213,133,213,151],[212,6,212,17],[212,18,212,29],[212,30,212,41],[212,42,212,53],[212,54,212,65],[212,66,212,77],[212,78,212,89],[212,90,212,101],[212,102,212,113],[214,114,214,125],[214,126,214,132],[214,133,214,151],[215,6,215,17],[215,18,215,29],[215,30,215,41],[215,42,215,53],[215,54,215,65],[215,66,215,77],[215,78,215,89],[215,90,215,101],[215,102,215,113],[215,114,215,125],[215,126,215,132],[215,133,215,151],[214,6,214,17],[214,18,214,29],[214,30,214,41],[214,42,214,53],[214,54,214,65],[214,66,214,77],[214,78,214,89],[214,90,214,101],[214,102,214,113],[216,114,216,125],[216,126,216,132],[216,133,216,151],[217,6,217,17],[217,18,217,29],[217,30,217,41],[217,42,217,53],[217,54,217,65],[217,66,217,77],[217,78,217,89],[217,90,217,101],[217,102,217,113],[217,114,217,125],[217,126,217,132],[217,133,217,151],[216,6,216,17],[216,18,216,29],[216,30,216,41],[216,42,216,53],[216,54,216,65],[216,66,216,77],[216,78,216,89],[216,90,216,101],[216,102,216,113],[218,114,218,125],[218,126,218,132],[218,133,218,151],[219,6,219,17],[219,18,219,29],[219,30,219,41],[219,42,219,53],[219,54,219,65],[219,66,219,77],[219,78,219,89],[219,90,219,101],[219,102,219,113],[219,114,219,125],[219,126,219,132],[219,133,219,151],[218,6,218,17],[218,18,218,29],[218,30,218,41],[218,42,218,53],[218,54,218,65],[218,66,218,77],[218,78,218,89],[218,90,218,101],[218,102,218,113],[220,114,220,125],[220,126,220,132],[220,133,220,151],[221,6,221,17],[221,18,221,29],[221,30,221,41],[221,42,221,53],[221,54,221,65],[221,66,221,77],[221,78,221,89],[221,90,221,101],[221,102,221,113],[221,114,221,125],[221,126,221,132],[221,133,221,151],[220,6,220,17],[220,18,220,29],[220,30,220,41],[220,42,220,53],[220,54,220,65],[220,66,220,77],[220,78,220,89],[220,90,220,101],[220,102,220,113],[222,114,222,125],[222,126,222,132],[222,133,222,151],[223,6,223,17],[223,18,223,29],[223,30,223,41],[223,42,223,53],[223,54,223,65],[223,66,223,77],[223,78,223,89],[223,90,223,101],[223,102,223,113],[223,114,223,125],[223,126,223,132],[223,133,223,151],[222,6,222,17],[222,18,222,29],[222,30,222,41],[222,42,222,53],[222,54,222,65],[222,66,222,77],[222,78,222,89],[222,90,222,101],[222,102,222,113],[11,126,11,151],[17,126,17,151],[16,126,16,151],[15,126,15,151],[14,126,14,151],[13,126,13,151],[12,126,12,151],[24,126,24,151],[23,126,23,151],[22,126,22,151],[21,126,21,151],[20,126,20,151],[19,126,19,151],[18,126,18,151],[29,126,29,151],[28,126,28,151],[27,126,27,151],[26,126,26,151],[25,126,25,151],[36,126,36,151],[35,126,35,151],[34,126,34,151],[33,126,33,151],[32,126,32,151],[31,126,31,151],[30,126,30,151],[37,126,37,151],[38,126,38,151],[39,126,39,151],[40,126,40,151],[41,126,41,151],[42,126,42,151],[43,126,43,151],[44,126,44,151],[45,126,45,151],[46,126,46,151],[47,126,47,151],[48,126,48,151],[49,126,49,151],[50,126,50,151],[51,126,51,151],[52,126,52,151],[53,126,53,151],[54,126,54,151],[55,126,55,151],[56,126,56,151],[57,126,57,151],[58,126,58,151],[59,126,59,151],[60,126,60,151],[61,126,61,151],[62,126,62,151],[63,126,63,151],[64,126,64,151],[65,126,65,151],[66,126,66,151],[67,126,67,151],[68,126,68,151],[69,126,69,151],[70,126,70,151],[71,126,71,151],[72,126,72,151],[73,126,73,151],[74,126,74,151],[75,126,75,151],[76,126,76,151],[77,126,77,151],[78,126,78,151],[79,126,79,151],[80,126,80,151],[81,126,81,151],[82,126,82,151],[83,126,83,151],[90,126,90,151],[91,126,91,151],[92,126,92,151],[95,126,95,151],[96,126,96,151],[97,126,97,151],[98,126,98,151],[99,126,99,151],[100,126,100,151],[103,126,103,151],[104,126,104,151],[105,126,105,151],[106,126,106,151],[107,126,107,151],[108,126,108,151],[109,126,109,151],[110,126,110,151],[113,126,113,151],[114,126,114,151],[115,126,115,151],[116,126,116,151],[117,126,117,151],[118,126,118,151],[119,126,119,151],[122,126,122,151],[123,126,123,151],[124,126,124,151],[125,126,125,151],[126,126,126,151],[127,126,127,151],[147,126,147,151],[148,126,148,151],[149,126,149,151],[128,126,128,151],[129,126,129,151],[130,126,130,151],[131,126,131,151],[132,126,132,151],[133,126,133,151],[134,126,134,151],[137,126,137,151],[138,126,138,151],[153,126,153,151],[150,126,150,151],[151,126,151,151],[152,126,152,151],[84,126,84,151],[85,126,85,151],[93,126,93,151],[94,126,94,151],[101,126,101,151],[102,126,102,151],[111,126,111,151],[112,126,112,151],[120,126,120,151],[121,126,121,151],[135,126,135,151],[136,126,136,151],[142,126,142,151],[143,126,143,151],[139,126,139,151],[140,126,140,151],[141,126,141,151],[144,126,144,151],[145,126,145,151],[146,126,146,151]]}
[]
[null,"Eingabefelder",null,null,null,null,"Legende Projektphasen (Spalte F)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Version 4 vom 27.06.2022"]
[null,null,null,null,null,null,1,null,"Planung (SIA 11-21)",null,null,null,null,null,null,null,null,null,null,2,null,"Projektierung (SIA 31-33)",null,null,null,null,null,null,null,null,null,null,null,null,3,null,"Kreditbeschaffung",null,null,null,null,null,null,null,null,null,null,4,null,"Ausführung (SIA 41-53)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Projektnr.",null,null,null,null,null,"Bezeichnung",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"xxx.xxxxx",null,null,null,null,null,"Projekt X"]
["Startjahr Projekt",2021,null,null,null,null,5,null,"Mitwirkung/Vernehmlassung/Auflage/Submission",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,null,"Risiko",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kantonsstrasse / Kantonales Gewässer"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nr. "]
["Stand Terminplanung: ","2022-06-27",null,null,null,null,0]
[]
["Tätigkeit *",null,null,null,null,null,{"$f":"B5+G7","v":2021},null,null,null,null,null,null,null,null,null,null,null,{"$f":"G9+1","v":2022},null,null,null,null,null,null,null,null,null,null,null,{"$f":"S9+1","v":2023},null,null,null,null,null,null,null,null,null,null,null,{"$f":"AE9+1","v":2024},null,null,null,null,null,null,null,null,null,null,null,{"$f":"AQ9+1","v":2025},null,null,null,null,null,null,null,null,null,null,null,{"$f":"BC9+1","v":2026},null,null,null,null,null,null,null,null,null,null,null,{"$f":"BO9+1","v":2027},null,null,null,null,null,null,null,null,null,null,null,{"$f":"CA9+1","v":2028},null,null,null,null,null,null,null,null,null,null,null,{"$f":"CM9+1","v":2029},null,null,null,null,null,null,null,null,null,null,null,{"$f":"CY9+1","v":2030},null,null,null,null,null,null,null,null,null,null,null,"Bemerkungen"]
[null,"Anfang","Ende","Dauer","shift","Phase","J","F","M","A","M","J","J","A","S","O","N","D","J","F","M","A","M","J","J","A","S","O","N","D","J","F","M","A","M","J","J","A","S","O","N","D","J","F","M","A","M","J","J","A","S","O","N","D","J","F","M","A","M","J","J","A","S","O","N","D","J","F","M","A","M","J","J","A","S","O","N","D","J","F","M","A","M","J","J","A","S","O","N","D","J","F","M","A","M","J","J","A","S","O","N","D","J","F","M","A","M","J","J","A","S","O","N","D","J","F","M","A","M","J","J","A","S","O","N","D"]
[null,null,null,null,null,null,{"$f":"DATE(G9,1,1)","v":"2021-01-01"},{"$f":"EDATE(G11,1)","v":"2021-02-01"},{"$f":"EDATE(H11,1)","v":"2021-03-01"},{"$f":"EDATE(I11,1)","v":"2021-04-01"},"2021-05-01","2021-06-01","2021-07-01","2021-08-01","2021-09-01","2021-10-01","2021-11-01","2021-12-01","2022-01-01","2022-02-01","2022-03-01","2022-04-01","2022-05-01","2022-06-01","2022-07-01","2022-08-01","2022-09-01","2022-10-01","2022-11-01","2022-12-01","2023-01-01","2023-02-01","2023-03-01","2023-04-01","2023-05-01","2023-06-01","2023-07-01","2023-08-01","2023-09-01","2023-10-01","2023-11-01","2023-12-01","2024-01-01","2024-02-01","2024-03-01","2024-04-01","2024-05-01","2024-06-01","2024-07-01","2024-08-01","2024-09-01","2024-10-01","2024-11-01","2024-12-01","2025-01-01","2025-02-01","2025-03-01","2025-04-01","2025-05-01","2025-06-01","2025-07-01","2025-08-01","2025-09-01","2025-10-01","2025-11-01","2025-12-01","2026-01-01","2026-02-01","2026-03-01","2026-04-01","2026-05-01","2026-06-01","2026-07-01",{"$f":"EDATE(BU11,1)","v":"2026-08-01"},"2026-09-01","2026-10-01","2026-11-01","2026-12-01",{"$f":"EDATE(BZ11,1)","v":"2027-01-01"},{"$f":"EDATE(CA11,1)","v":"2027-02-01"},{"$f":"EDATE(CB11,1)","v":"2027-03-01"},{"$f":"EDATE(CC11,1)","v":"2027-04-01"},{"$f":"EDATE(CD11,1)","v":"2027-05-01"},{"$f":"EDATE(CE11,1)","v":"2027-06-01"},{"$f":"EDATE(CF11,1)","v":"2027-07-01"},{"$f":"EDATE(CG11,1)","v":"2027-08-01"},{"$f":"EDATE(CH11,1)","v":"2027-09-01"},{"$f":"EDATE(CI11,1)","v":"2027-10-01"},{"$f":"EDATE(CJ11,1)","v":"2027-11-01"},{"$f":"EDATE(CK11,1)","v":"2027-12-01"},{"$f":"EDATE(CL11,1)","v":"2028-01-01"},{"$f":"EDATE(CM11,1)","v":"2028-02-01"},{"$f":"EDATE(CN11,1)","v":"2028-03-01"},{"$f":"EDATE(CO11,1)","v":"2028-04-01"},{"$f":"EDATE(CP11,1)","v":"2028-05-01"},{"$f":"EDATE(CQ11,1)","v":"2028-06-01"},{"$f":"EDATE(CR11,1)","v":"2028-07-01"},{"$f":"EDATE(CS11,1)","v":"2028-08-01"},{"$f":"EDATE(CT11,1)","v":"2028-09-01"},{"$f":"EDATE(CU11,1)","v":"2028-10-01"},{"$f":"EDATE(CV11,1)","v":"2028-11-01"},{"$f":"EDATE(CW11,1)","v":"2028-12-01"},{"$f":"EDATE(CX11,1)","v":"2029-01-01"},{"$f":"EDATE(CY11,1)","v":"2029-02-01"},{"$f":"EDATE(CZ11,1)","v":"2029-03-01"},{"$f":"EDATE(DA11,1)","v":"2029-04-01"},{"$f":"EDATE(DB11,1)","v":"2029-05-01"},{"$f":"EDATE(DC11,1)","v":"2029-06-01"},{"$f":"EDATE(DD11,1)","v":"2029-07-01"},{"$f":"EDATE(DE11,1)","v":"2029-08-01"},{"$f":"EDATE(DF11,1)","v":"2029-09-01"},{"$f":"EDATE(DG11,1)","v":"2029-10-01"},{"$f":"EDATE(DH11,1)","v":"2029-11-01"},{"$f":"EDATE(DI11,1)","v":"2029-12-01"},{"$f":"EDATE(DJ11,1)","v":"2030-01-01"},{"$f":"EDATE(DK11,1)","v":"2030-02-01"},{"$f":"EDATE(DL11,1)","v":"2030-03-01"},{"$f":"EDATE(DM11,1)","v":"2030-04-01"},{"$f":"EDATE(DN11,1)","v":"2030-05-01"},{"$f":"EDATE(DO11,1)","v":"2030-06-01"},{"$f":"EDATE(DP11,1)","v":"2030-07-01"},{"$f":"EDATE(DQ11,1)","v":"2030-08-01"},{"$f":"EDATE(DR11,1)","v":"2030-09-01"},{"$f":"EDATE(DS11,1)","v":"2030-10-01"},{"$f":"EDATE(DT11,1)","v":"2030-11-01"},{"$f":"EDATE(DU11,1)","v":"2030-12-01"}]
["Vorlauf",{"$f":"MIN(B13:B18)","v":"2021-01-01"},{"$f":"MAX(C13:C18)","v":"2021-01-31"},null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"evtl. Planer beauftragen"]
["Schwachstellen, Handlungsbedarf dokumentieren",{"$f":"EDATE(DATE(B5,1,1),E13)","v":"2021-01-01"},{"$f":"EDATE(B13,ABS(D13))-1","v":"2021-01-31"},1]
["Entscheid Projekt auslösen (Planungsstudie oder VP)",{"$f":"EDATE(C13+1,E14)","v":"2021-02-01"},{"$f":"EDATE(B14,ABS(D14))-1","v":"2021-01-31"}]
[null,{"$f":"EDATE(C14+1,E15)","v":"2021-02-01"},{"$f":"EDATE(B15,ABS(D15))-1","v":"2021-01-31"}]
[null,{"$f":"EDATE(C15+1,E16)","v":"2021-02-01"},{"$f":"EDATE(B16,ABS(D16))-1","v":"2021-01-31"}]
[null,{"$f":"EDATE(C16+1,E17)","v":"2021-02-01"},{"$f":"EDATE(B17,ABS(D17))-1","v":"2021-01-31"}]
[null,{"$f":"EDATE(C17+1,E18)","v":"2021-02-01"},"2021-01-31"]
["Projektstart",{"$f":"MIN(B20:B25)","v":"2021-02-01"},{"$f":"MAX(C20:C25)","v":"2021-03-31"},null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grundlagen usw."]
["Projekteröffnung (SAP, OAW, GEVER etc.)",{"$f":"EDATE(C18+1,E20)","v":"2021-02-01"},{"$f":"EDATE(B20,ABS(D20))-1","v":"2021-03-31"},2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Projektorganisation, Finanzplanung"]
["Vergabekonzept Dienstleistungen",{"$f":"EDATE(C20+1,E21)","v":"2021-04-01"},{"$f":"EDATE(B21,ABS(D21))-1","v":"2021-03-31"}]
[null,{"$f":"EDATE(C21+1,E22)","v":"2021-04-01"},"2021-03-31"]
[null,{"$f":"EDATE(C22+1,E23)","v":"2021-04-01"},"2021-03-31"]
[null,{"$f":"EDATE(C23+1,E24)","v":"2021-04-01"},"2021-03-31"]
[null,{"$f":"EDATE(C24+1,E25)","v":"2021-04-01"},"2021-03-31"]
["Planungsstudie",{"$f":"MIN(B27:B37)","v":"2021-04-01"},{"$f":"MAX(C27:C37)","v":"2021-05-31"},null,null,1]
["Projektziele definieren",{"$f":"EDATE(C25+1,E27)","v":"2021-04-01"},{"$f":"EDATE(B27,ABS(D27))-1","v":"2021-05-31"},2]
["Projektorganisation / Termin- und Finanzplanung etc.",{"$f":"EDATE(C27+1,E28)","v":"2021-06-01"},{"$f":"EDATE(B28,ABS(D28))-1","v":"2021-05-31"}]
["Planungskredit",{"$f":"EDATE(C28+1,E29)","v":"2021-06-01"},"2021-05-31"]
["Ausschreibung / Vergabe / Auftrag Planer","2021-06-01","2021-05-31"]
["Genehmigung Pflichtenheft","2021-06-01","2021-05-31",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OIK, Gemeinde"]
["Erarbeiten Studie(n)","2021-06-01","2021-05-31",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Risikoanalyse"]
["Phasenreview","2021-06-01","2021-05-31"]
[null,"2021-06-01","2021-05-31"]
[null,"2021-06-01","2021-05-31"]
[null,"2021-06-01","2021-05-31"]
[null,"2021-06-01","2021-05-31"]
["Vorprojekt",{"$f":"MIN(B39:B60)","v":"2021-06-01"},{"$f":"MAX(C39:C60)","v":"2021-10-31"},null,null,2]
["Schwachstellen, Handlungsbedarf dokumentieren",{"$f":"EDATE(C37+1,E39)","v":"2021-06-01"},{"$f":"EDATE(B39,ABS(D39))-1","v":"2021-10-31"},5]
["Vergabekonzept Dienstleistungen",{"$f":"EDATE(C39+1,E40)","v":"2021-11-01"},{"$f":"EDATE(B40,ABS(D40))-1","v":"2021-10-31"}]
["Projektziele definieren","2021-11-01","2021-10-31"]
["Projektorganisation / Termin- und Finanzplanung etc.","2021-11-01","2021-10-31"]
["Projektierungskredit","2021-11-01",{"$f":"EDATE(B43,ABS(D43))-1","v":"2021-10-31"}]
["Ausschreibung / Vergabe / Auftrag Planer","2021-11-01",{"$f":"EDATE(B44,ABS(D44))-1","v":"2021-10-31"}]
["Grundlagen ergänzen","2021-11-01","2021-10-31",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Verkehr, Zustand etc."]
["Genehmigung Zielvereinbarung","2021-11-01","2021-10-31",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OIK, Gemeinde, Projektverf."]
["Erarbeiten Vorprojekt und Wirkungsnachweis",{"$f":"EDATE(C46+1,E47)","v":"2021-11-01"},"2021-10-31",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"evtl. Pflichtenheft UVB"]
["A-Projekt Agglo: einreichen an ARE, ASTRA","2021-11-01","2021-10-31",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2 Jahre vor Baubeginn"]
["Nachhaltigkeitsbeurteilung ?","2021-11-01","2021-10-31",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"wenn > Fr. 2 Mio. netto"]
["Road Safety Audit","2021-11-01","2021-10-31"]
["Ämterkonsultation (30 Tage)","2021-11-01","2021-10-31",null,null,5]
["Überarbeitung Projekt (Risiko)","2021-11-01","2021-10-31",null,null,6]
["Mitwirkung (30 Tage)","2021-11-01","2021-10-31",null,null,5]
["Mitwirkungsbericht","2021-11-01","2021-10-31"]
["Überarbeitung Projekt (Risiko)","2021-11-01",{"$f":"EDATE(B55,ABS(D55))-1","v":"2021-10-31"},null,null,6]
["Phasenreview",{"$f":"EDATE(C55+1,E56)","v":"2021-11-01"},{"$f":"EDATE(B56,ABS(D56))-1","v":"2021-10-31"}]
[null,{"$f":"EDATE(C56+1,E57)","v":"2021-11-01"},{"$f":"EDATE(B57,ABS(D57))-1","v":"2021-10-31"}]
[null,{"$f":"EDATE(C57+1,E58)","v":"2021-11-01"},{"$f":"EDATE(B58,ABS(D58))-1","v":"2021-10-31"}]
[null,{"$f":"EDATE(C58+1,E59)","v":"2021-11-01"},"2021-10-31"]
[null,{"$f":"EDATE(C59+1,E60)","v":"2021-11-01"},"2021-10-31"]
["Bauprojekt / Strassenplan",{"$f":"MIN(B62:B85)","v":"2021-11-01"},{"$f":"MAX(C62:C85)","v":"2023-02-28"},null,null,2]
["Projektierungskredit ",{"$f":"EDATE(C60+1,E62)","v":"2021-11-01"},{"$f":"EDATE(B62,ABS(D62))-1","v":"2022-03-31"},5]
["Ausschreibung / Vergabe / Auftrag Planer",{"$f":"EDATE(C62+1,E63)","v":"2022-04-01"},{"$f":"EDATE(B63,ABS(D63))-1","v":"2022-03-31"}]
["Grundlagen abschliessend ergänzen",{"$f":"EDATE(C63+1,E64)","v":"2022-04-01"},{"$f":"EDATE(B64,ABS(D64))-1","v":"2022-03-31"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Baugrund etc. - 4-Augen-Prinzip"]
["Strassenplan (Bauprojekt+KV), Wirkungsnachweis",{"$f":"EDATE(C64+1,E65)","v":"2022-04-01"},"2022-03-31",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"evtl. UVB"]
["Road Safety Audit",{"$f":"EDATE(C65+1,E66)","v":"2022-04-01"},"2022-03-31"]
["Amtsberichte einholen (30 Tage)","2022-04-01","2022-03-31",null,null,5]
["Anhörung Bund ?","2022-04-01","2022-03-31",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"bei UVB"]
["Bereinigung","2022-04-01","2022-03-31"]
["Fertigstellen Auflagedossier","2022-04-01","2022-03-31"]
["Planauflage (30 Tage)","2022-04-01","2022-03-31",null,null,5]
["Einspracheverhandlungen","2022-04-01","2022-09-30",6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Standardmässig 6 Monate"]
["Projektänderung vor Erlass (Risiko)","2022-10-01","2022-09-30",null,null,6]
["Planauflage Projektänderung (30 Tage)","2022-10-01","2022-09-30",null,null,5]
["Strassenplanerlass erarbeiten inkl. Genehmigung","2022-10-01","2023-02-28",5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vorbereiten 1 Mt, Rechtsdienst 4 Mt"]
["mögliche Beschwerden","2023-03-01","2023-02-28",null,null,6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DIJ + 1.5 Jahre, Verwaltungsgericht + 1 Jahr, BG+ 1.5 Jahre"]
["Publikation (30 Tage)","2023-03-01","2023-02-28",null,null,5]
["Landerwerbsverfahren","2023-03-01","2023-02-28",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Leistungsvereinbarung"]
["Enteignungsverfahren (Risiko)","2023-03-01","2023-02-28",null,null,6]
["A-Projekt Agglo: Gesuch an Bund","2023-03-01","2023-02-28"]
["Phasenreview",{"$f":"EDATE(C80+1,E81)","v":"2023-03-01"},"2023-02-28"]
[null,{"$f":"EDATE(C81+1,E82)","v":"2023-03-01"},{"$f":"EDATE(B82,ABS(D82))-1","v":"2023-02-28"}]
[null,{"$f":"EDATE(C82+1,E83)","v":"2023-03-01"},"2023-02-28"]
[null,{"$f":"EDATE(C83+1,E84)","v":"2023-03-01"},"2023-02-28"]
[null,{"$f":"EDATE(C84+1,E85)","v":"2023-03-01"},"2023-02-28"]
["Kredit für die Ausführung",{"$f":"MIN(B87:B94)","v":"2023-04-01"},{"$f":"MAX(C87:C94)","v":"2024-04-30"},null,null,3]
["Kreditvorlage ausarbeiten",{"$f":"EDATE(C85+1,E87)","v":"2023-04-01"},{"$f":"EDATE(B87,ABS(D87))-1","v":"2023-06-30"},3,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GR: 3 Mt",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RRB: 1 Mt"]
["Kreditgenehmigung",{"$f":"EDATE(C87+1,E88)","v":"2023-07-01"},{"$f":"EDATE(B88,ABS(D88))-1","v":"2023-12-31"},6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GR: 6 Mt vor Sessionsbeginn",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RRB: 3 Mt"]
["Fakultatives Finanzreferendum (Frist: 3 Monate)",{"$f":"EDATE(C88+1,E89)","v":"2024-01-01"},{"$f":"EDATE(B89,ABS(D89))-1","v":"2024-04-30"},4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GR: 4 Mt",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RRB: -"]
["Phasenreview","2024-05-01",{"$f":"EDATE(B90,ABS(D90))-1","v":"2024-04-30"}]
[null,{"$f":"EDATE(C90+1,E91)","v":"2024-05-01"},{"$f":"EDATE(B91,ABS(D91))-1","v":"2024-04-30"}]
[null,{"$f":"EDATE(C91+1,E92)","v":"2024-05-01"},{"$f":"EDATE(B92,ABS(D92))-1","v":"2024-04-30"}]
[null,{"$f":"EDATE(C92+1,E93)","v":"2024-05-01"},"2024-04-30"]
[null,{"$f":"EDATE(C93+1,E94)","v":"2024-05-01"},"2024-04-30"]
["Ausführungsprojekt (Phase 1)",{"$f":"MIN(B96:B102)","v":"2024-05-01"},{"$f":"MAX(C96:C102)","v":"2024-09-30"},null,null,4]
["Ausführungsprojekt",{"$f":"EDATE(C94+1,E96)","v":"2024-05-01"},{"$f":"EDATE(B96,ABS(D96))-1","v":"2024-09-30"},5]
["Prüfung Auflagen, Vernehmlassung",{"$f":"EDATE(C96+1,E97)","v":"2024-10-01"},{"$f":"EDATE(B97,ABS(D97))-1","v":"2024-09-30"}]
["Phasenreview",{"$f":"EDATE(C97+1,E98)","v":"2024-10-01"},{"$f":"EDATE(B98,ABS(D98))-1","v":"2024-09-30"}]
[null,"2024-10-01","2024-09-30"]
[null,"2024-10-01","2024-09-30"]
[null,"2024-10-01","2024-09-30"]
[null,"2024-10-01","2024-09-30"]
["Submission Bauarbeiten",{"$f":"MIN(B104:B112)","v":"2024-10-01"},{"$f":"MAX(C104:C112)","v":"2025-02-28"},null,null,4]
["Submissionsprojekt und -unterlagen erarbeiten",{"$f":"EDATE(C102+1,E104)","v":"2024-10-01"},{"$f":"EDATE(B104,ABS(D104))-1","v":"2025-02-28"},5]
["Unterlagen prüfen (4-Augen-Prinzip)",{"$f":"EDATE(C104+1,E105)","v":"2025-03-01"},{"$f":"EDATE(B105,ABS(D105))-1","v":"2025-02-28"}]
["Submissions- und Vergabeverfahren",{"$f":"EDATE(C105+1,E106)","v":"2025-03-01"},{"$f":"EDATE(B106,ABS(D106))-1","v":"2025-02-28"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fristen beachten, genügend Zeit für AVOR Unternehmer"]
["Submissionsbeschwerde (Risiko)","2025-03-01","2025-02-28",null,null,6]
["Phasenreview","2025-03-01","2025-02-28"]
[null,{"$f":"EDATE(C108+1,E109)","v":"2025-03-01"},{"$f":"EDATE(B109,ABS(D109))-1","v":"2025-02-28"}]
[null,"2025-03-01","2025-02-28"]
[null,{"$f":"EDATE(C110+1,E111)","v":"2025-03-01"},"2025-02-28"]
[null,"2025-03-01","2025-02-28"]
["Ausführungsprojekt (Phase 2)",{"$f":"MIN(B114:B121)","v":"2025-03-01"},{"$f":"MAX(C114:C121)","v":"2025-07-31"},null,null,4]
["Ausführungsprojekt",{"$f":"EDATE(C112+1,E114)","v":"2025-03-01"},{"$f":"EDATE(B114,ABS(D114))-1","v":"2025-07-31"},5]
["Ausführungsprojekt",{"$f":"EDATE(C114+1,E115)","v":"2025-08-01"},{"$f":"EDATE(B115,ABS(D115))-1","v":"2025-07-31"}]
["Ausführungsprojekt",{"$f":"EDATE(C115+1,E116)","v":"2025-08-01"},{"$f":"EDATE(B116,ABS(D116))-1","v":"2025-07-31"}]
["Ausführungsprojekt","2025-08-01","2025-07-31"]
[null,"2025-08-01","2025-07-31"]
[null,"2025-08-01","2025-07-31"]
[null,"2025-08-01","2025-07-31"]
[null,"2025-08-01","2025-07-31"]
["Ausführung / Bau",{"$f":"MIN(B123:B136)","v":"2025-08-01"},{"$f":"MAX(C123:C136)","v":"2025-12-31"},null,null,4]
["Arbeitsvorbereitung (AVOR)",{"$f":"EDATE(C121+1,E123)","v":"2025-08-01"},{"$f":"EDATE(B123,ABS(D123))-1","v":"2025-12-31"},5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Informationsveranstaltung, Flyer, Medienanlass usw."]
["Baubeginn",{"$f":"EDATE(C123+1,E124)","v":"2026-01-01"},{"$f":"EDATE(B124,ABS(D124))-1","v":"2025-12-31"}]
["Bauphase 1",{"$f":"EDATE(C124+1,E125)","v":"2026-01-01"},{"$f":"EDATE(B125,ABS(D125))-1","v":"2025-12-31"}]
["Bauphase 2",{"$f":"EDATE(C125+1,E126)","v":"2026-01-01"},"2025-12-31"]
["Bauphase 3",{"$f":"EDATE(C126+1,E127)","v":"2026-01-01"},"2025-12-31"]
["Bauphase 4","2026-01-01","2025-12-31"]
["Bauabnahme","2026-01-01","2025-12-31",null,null,6]
["Nachforderungen (Risiko)","2026-01-01","2025-12-31"]
["Schlussabrechnung","2026-01-01","2025-12-31"]
[null,"2026-01-01","2025-12-31"]
[null,{"$f":"EDATE(C132+1,E133)","v":"2026-01-01"},{"$f":"EDATE(B133,ABS(D133))-1","v":"2025-12-31"}]
[null,"2026-01-01","2025-12-31"]
[null,{"$f":"EDATE(C134+1,E135)","v":"2026-01-01"},"2025-12-31"]
[null,"2026-01-01","2025-12-31"]
["Inbetriebnahme, Eröffnung",{"$f":"MIN(B138:B143)","v":"2026-01-01"},{"$f":"MAX(C138:C143)","v":"2026-05-31"},null,null,4]
["Erfolgskontrolle",{"$f":"EDATE(C136+1,E138)","v":"2026-01-01"},{"$f":"EDATE(B138,ABS(D138))-1","v":"2026-05-31"},5]
["Handänderungsverfahren",{"$f":"EDATE(C138+1,E139)","v":"2026-06-01"},{"$f":"EDATE(B139,ABS(D139))-1","v":"2026-05-31"}]
[null,{"$f":"EDATE(C139+1,E140)","v":"2026-06-01"},{"$f":"EDATE(B140,ABS(D140))-1","v":"2026-05-31"}]
[null,"2026-06-01","2026-05-31"]
[null,"2026-06-01","2026-05-31"]
[null,"2026-06-01","2026-05-31"]
["Projektabschluss",{"$f":"MIN(B145:B154)","v":"2026-06-01"},{"$f":"MAX(C145:C154)","v":"2026-10-31"},null,null,4]
["Abschlussakten (PAW)",{"$f":"EDATE(C143+1,E145)","v":"2026-06-01"},{"$f":"EDATE(B145,ABS(D145))-1","v":"2026-10-31"},5]
["Projektabrechnung",{"$f":"EDATE(C145+1,E146)","v":"2026-11-01"},{"$f":"EDATE(B146,ABS(D146))-1","v":"2026-10-31"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KUBA, LOGO, Entw., Bel. etc."]
["Nachführen Datenbanken",{"$f":"EDATE(C146+1,E147)","v":"2026-11-01"},"2026-10-31"]
["Projektabschlussbericht (bei A-Projekten)","2026-11-01","2026-10-31"]
["Archivierung",{"$f":"EDATE(C148+1,E149)","v":"2026-11-01"},{"$f":"EDATE(B149,ABS(D149))-1","v":"2026-10-31"}]
["Phasenreview","2026-11-01","2026-10-31"]
[null,"2026-11-01","2026-10-31"]
[null,"2026-11-01","2026-10-31"]
[null,"2026-11-01","2026-10-31"]
[null,"2026-11-01","2026-10-31"]
[]
["Aggregiert nach Phasen"]
["Vorlauf",{"$f":"B12","v":"2021-01-01"},{"$f":"C12","v":"2021-01-31"},{"$f":"D12","v":0},{"$f":"E12","v":0},{"$f":"F12","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kostenkontrolltabelle"]
["Projektstart",{"$f":"B19","v":"2021-02-01"},{"$f":"C19","v":"2021-03-31"},null,null,{"$f":"F19","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Planung",null,null,null,null,null,"Projektierung",null,null,null,null,null,"Baukosten"]
["Planungsstudie",{"$f":"B26","v":"2021-04-01"},{"$f":"C26","v":"2021-05-31"},{"$f":"D26","v":0},{"$f":"E26","v":0},{"$f":"F26","v":1},{"$f":"IF($B159<$C159,ROUND($EE159/(DATEDIF($B159,$C159,\"m\")+1)*((MONTH(MIN((1&-G$9-1)-1,$C159))-MONTH(MAX(1&-G$9,$B159))+1)*(YEAR($B159)<=G$9)*(YEAR($C159)>=G$9)),-3),0)","v":60000},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($B159<$C159,ROUND($EE159/(DATEDIF($B159,$C159,\"m\")+1)*((MONTH(MIN((1&-S$9-1)-1,$C159))-MONTH(MAX(1&-S$9,$B159))+1)*(YEAR($B159)<=S$9)*(YEAR($C159)>=S$9)),-3),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($B159<$C159,ROUND($EE159/(DATEDIF($B159,$C159,\"m\")+1)*((MONTH(MIN((1&-AE$9-1)-1,$C159))-MONTH(MAX(1&-AE$9,$B159))+1)*(YEAR($B159)<=AE$9)*(YEAR($C159)>=AE$9)),-3),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($B159<$C159,ROUND($EE159/(DATEDIF($B159,$C159,\"m\")+1)*((MONTH(MIN((1&-AQ$9-1)-1,$C159))-MONTH(MAX(1&-AQ$9,$B159))+1)*(YEAR($B159)<=AQ$9)*(YEAR($C159)>=AQ$9)),-3),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($B159<$C159,ROUND($EE159/(DATEDIF($B159,$C159,\"m\")+1)*((MONTH(MIN((1&-BC$9-1)-1,$C159))-MONTH(MAX(1&-BC$9,$B159))+1)*(YEAR($B159)<=BC$9)*(YEAR($C159)>=BC$9)),-3),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($B159<$C159,ROUND($EE159/(DATEDIF($B159,$C159,\"m\")+1)*((MONTH(MIN((1&-BO$9-1)-1,$C159))-MONTH(MAX(1&-BO$9,$B159))+1)*(YEAR($B159)<=BO$9)*(YEAR($C159)>=BO$9)),-3),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($B159<$C159,ROUND($EE159/(DATEDIF($B159,$C159,\"m\")+1)*((MONTH(MIN((1&-CA$9-1)-1,$C159))-MONTH(MAX(1&-CA$9,$B159))+1)*(YEAR($B159)<=CA$9)*(YEAR($C159)>=CA$9)),-3),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($B159<$C159,ROUND($EE159/(DATEDIF($B159,$C159,\"m\")+1)*((MONTH(MIN((1&-CM$9-1)-1,$C159))-MONTH(MAX(1&-CM$9,$B159))+1)*(YEAR($B159)<=CM$9)*(YEAR($C159)>=CM$9)),-3),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($B159<$C159,ROUND($EE159/(DATEDIF($B159,$C159,\"m\")+1)*((MONTH(MIN((1&-CY$9-1)-1,$C159))-MONTH(MAX(1&-CY$9,$B159))+1)*(YEAR($B159)<=CY$9)*(YEAR($C159)>=CY$9)),-3),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($B159<$C159,ROUND($EE159/(DATEDIF($B159,$C159,\"m\")+1)*((MONTH(MIN((1&-DK$9-1)-1,$C159))-MONTH(MAX(1&-DK$9,$B159))+1)*(YEAR($B159)<=DK$9)*(YEAR($C159)>=DK$9)),-3),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,"Leistungen SIA",null,null,null,null,null,null,null,{"$f":"EQ172","v":60000}]
["Vorprojekt",{"$f":"B38","v":"2021-06-01"},{"$f":"C38","v":"2021-10-31"},{"$f":"D38","v":0},{"$f":"E38","v":0},{"$f":"F38","v":2},{"$f":"IF($B160<$C160,ROUND($EK160/(DATEDIF($B160,$C160,\"m\")+1)*((MONTH(MIN((1&-G$9-1)-1,$C160))-MONTH(MAX(1&-G$9,$B160))+1)*(YEAR($B160)<=G$9)*(YEAR($C160)>=G$9)),-3),0)","v":54000},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($B160<$C160,ROUND($EK160/(DATEDIF($B160,$C160,\"m\")+1)*((MONTH(MIN((1&-S$9-1)-1,$C160))-MONTH(MAX(1&-S$9,$B160))+1)*(YEAR($B160)<=S$9)*(YEAR($C160)>=S$9)),-3),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($B160<$C160,ROUND($EK160/(DATEDIF($B160,$C160,\"m\")+1)*((MONTH(MIN((1&-AE$9-1)-1,$C160))-MONTH(MAX(1&-AE$9,$B160))+1)*(YEAR($B160)<=AE$9)*(YEAR($C160)>=AE$9)),-3),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($B160<$C160,ROUND($EK160/(DATEDIF($B160,$C160,\"m\")+1)*((MONTH(MIN((1&-AQ$9-1)-1,$C160))-MONTH(MAX(1&-AQ$9,$B160))+1)*(YEAR($B160)<=AQ$9)*(YEAR($C160)>=AQ$9)),-3),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($B160<$C160,ROUND($EK160/(DATEDIF($B160,$C160,\"m\")+1)*((MONTH(MIN((1&-BC$9-1)-1,$C160))-MONTH(MAX(1&-BC$9,$B160))+1)*(YEAR($B160)<=BC$9)*(YEAR($C160)>=BC$9)),-3),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($B160<$C160,ROUND($EK160/(DATEDIF($B160,$C160,\"m\")+1)*((MONTH(MIN((1&-BO$9-1)-1,$C160))-MONTH(MAX(1&-BO$9,$B160))+1)*(YEAR($B160)<=BO$9)*(YEAR($C160)>=BO$9)),-3),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($B160<$C160,ROUND($EK160/(DATEDIF($B160,$C160,\"m\")+1)*((MONTH(MIN((1&-CA$9-1)-1,$C160))-MONTH(MAX(1&-CA$9,$B160))+1)*(YEAR($B160)<=CA$9)*(YEAR($C160)>=CA$9)),-3),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($B160<$C160,ROUND($EK160/(DATEDIF($B160,$C160,\"m\")+1)*((MONTH(MIN((1&-CM$9-1)-1,$C160))-MONTH(MAX(1&-CM$9,$B160))+1)*(YEAR($B160)<=CM$9)*(YEAR($C160)>=CM$9)),-3),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($B160<$C160,ROUND($EK160/(DATEDIF($B160,$C160,\"m\")+1)*((MONTH(MIN((1&-CY$9-1)-1,$C160))-MONTH(MAX(1&-CY$9,$B160))+1)*(YEAR($B160)<=CY$9)*(YEAR($C160)>=CY$9)),-3),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($B160<$C160,ROUND($EK160/(DATEDIF($B160,$C160,\"m\")+1)*((MONTH(MIN((1&-DK$9-1)-1,$C160))-MONTH(MAX(1&-DK$9,$B160))+1)*(YEAR($B160)<=DK$9)*(YEAR($C160)>=DK$9)),-3),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,0.09,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$EQ$173*DW160","v":54000}]
["Bauprojekt / Strassenplan",{"$f":"B61","v":"2021-11-01"},{"$f":"C61","v":"2023-02-28"},{"$f":"D61","v":0},{"$f":"E61","v":0},{"$f":"F61","v":2},{"$f":"IF($B161<$C161,ROUND($EK161/(DATEDIF($B161,$C161,\"m\")+1)*((MONTH(MIN((1&-G$9-1)-1,$C161))-MONTH(MAX(1&-G$9,$B161))+1)*(YEAR($B161)<=G$9)*(YEAR($C161)>=G$9)),-3),0)","v":18000},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($B161<$C161,ROUND($EK161/(DATEDIF($B161,$C161,\"m\")+1)*((MONTH(MIN((1&-S$9-1)-1,$C161))-MONTH(MAX(1&-S$9,$B161))+1)*(YEAR($B161)<=S$9)*(YEAR($C161)>=S$9)),-3),0)","v":108000},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($B161<$C161,ROUND($EK161/(DATEDIF($B161,$C161,\"m\")+1)*((MONTH(MIN((1&-AE$9-1)-1,$C161))-MONTH(MAX(1&-AE$9,$B161))+1)*(YEAR($B161)<=AE$9)*(YEAR($C161)>=AE$9)),-3),0)","v":18000},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($B161<$C161,ROUND($EK161/(DATEDIF($B161,$C161,\"m\")+1)*((MONTH(MIN((1&-AQ$9-1)-1,$C161))-MONTH(MAX(1&-AQ$9,$B161))+1)*(YEAR($B161)<=AQ$9)*(YEAR($C161)>=AQ$9)),-3),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($B161<$C161,ROUND($EK161/(DATEDIF($B161,$C161,\"m\")+1)*((MONTH(MIN((1&-BC$9-1)-1,$C161))-MONTH(MAX(1&-BC$9,$B161))+1)*(YEAR($B161)<=BC$9)*(YEAR($C161)>=BC$9)),-3),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($B161<$C161,ROUND($EK161/(DATEDIF($B161,$C161,\"m\")+1)*((MONTH(MIN((1&-BO$9-1)-1,$C161))-MONTH(MAX(1&-BO$9,$B161))+1)*(YEAR($B161)<=BO$9)*(YEAR($C161)>=BO$9)),-3),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($B161<$C161,ROUND($EK161/(DATEDIF($B161,$C161,\"m\")+1)*((MONTH(MIN((1&-CA$9-1)-1,$C161))-MONTH(MAX(1&-CA$9,$B161))+1)*(YEAR($B161)<=CA$9)*(YEAR($C161)>=CA$9)),-3),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($B161<$C161,ROUND($EK161/(DATEDIF($B161,$C161,\"m\")+1)*((MONTH(MIN((1&-CM$9-1)-1,$C161))-MONTH(MAX(1&-CM$9,$B161))+1)*(YEAR($B161)<=CM$9)*(YEAR($C161)>=CM$9)),-3),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($B161<$C161,ROUND($EK161/(DATEDIF($B161,$C161,\"m\")+1)*((MONTH(MIN((1&-CY$9-1)-1,$C161))-MONTH(MAX(1&-CY$9,$B161))+1)*(YEAR($B161)<=CY$9)*(YEAR($C161)>=CY$9)),-3),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($B161<$C161,ROUND($EK161/(DATEDIF($B161,$C161,\"m\")+1)*((MONTH(MIN((1&-DK$9-1)-1,$C161))-MONTH(MAX(1&-DK$9,$B161))+1)*(YEAR($B161)<=DK$9)*(YEAR($C161)>=DK$9)),-3),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,0.24,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$EQ$173*DW161","v":144000}]
["Kredit für die Ausführung",{"$f":"B86","v":"2023-04-01"},{"$f":"C86","v":"2024-04-30"},{"$f":"D86","v":0},{"$f":"E86","v":0},{"$f":"F86","v":3},{"$f":"ROUND($EL162/(DATEDIF($B162,$C162,\"m\")+1)*((MONTH(MIN((1&-G$9-1)-1,$C162))-MONTH(MAX(1&-G$9,$B162))+1)*(YEAR($B162)<=G$9)*(YEAR($C162)>=G$9)),-3)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND($EL162/(DATEDIF($B162,$C162,\"m\")+1)*((MONTH(MIN((1&-S$9-1)-1,$C162))-MONTH(MAX(1&-S$9,$B162))+1)*(YEAR($B162)<=S$9)*(YEAR($C162)>=S$9)),-3)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND($EL162/(DATEDIF($B162,$C162,\"m\")+1)*((MONTH(MIN((1&-AE$9-1)-1,$C162))-MONTH(MAX(1&-AE$9,$B162))+1)*(YEAR($B162)<=AE$9)*(YEAR($C162)>=AE$9)),-3)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND($EL162/(DATEDIF($B162,$C162,\"m\")+1)*((MONTH(MIN((1&-AQ$9-1)-1,$C162))-MONTH(MAX(1&-AQ$9,$B162))+1)*(YEAR($B162)<=AQ$9)*(YEAR($C162)>=AQ$9)),-3)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND($EL162/(DATEDIF($B162,$C162,\"m\")+1)*((MONTH(MIN((1&-BC$9-1)-1,$C162))-MONTH(MAX(1&-BC$9,$B162))+1)*(YEAR($B162)<=BC$9)*(YEAR($C162)>=BC$9)),-3)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND($EL162/(DATEDIF($B162,$C162,\"m\")+1)*((MONTH(MIN((1&-BO$9-1)-1,$C162))-MONTH(MAX(1&-BO$9,$B162))+1)*(YEAR($B162)<=BO$9)*(YEAR($C162)>=BO$9)),-3)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND($EL162/(DATEDIF($B162,$C162,\"m\")+1)*((MONTH(MIN((1&-CA$9-1)-1,$C162))-MONTH(MAX(1&-CA$9,$B162))+1)*(YEAR($B162)<=CA$9)*(YEAR($C162)>=CA$9)),-3)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND($EL162/(DATEDIF($B162,$C162,\"m\")+1)*((MONTH(MIN((1&-CM$9-1)-1,$C162))-MONTH(MAX(1&-CM$9,$B162))+1)*(YEAR($B162)<=CM$9)*(YEAR($C162)>=CM$9)),-3)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND($EL162/(DATEDIF($B162,$C162,\"m\")+1)*((MONTH(MIN((1&-CY$9-1)-1,$C162))-MONTH(MAX(1&-CY$9,$B162))+1)*(YEAR($B162)<=CY$9)*(YEAR($C162)>=CY$9)),-3)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND($EL162/(DATEDIF($B162,$C162,\"m\")+1)*((MONTH(MIN((1&-DK$9-1)-1,$C162))-MONTH(MAX(1&-DK$9,$B162))+1)*(YEAR($B162)<=DK$9)*(YEAR($C162)>=DK$9)),-3)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$EQ$173*DW162","v":0}]
["Ausführungsprojekt (Phase 1)",{"$f":"B95","v":"2024-05-01"},{"$f":"C95","v":"2024-09-30"},null,null,{"$f":"F95","v":4},{"$f":"IF($B163<$C163,ROUND($EK163/(DATEDIF($B163,$C163,\"m\")+1)*((MONTH(MIN((1&-G$9-1)-1,$C163))-MONTH(MAX(1&-G$9,$B163))+1)*(YEAR($B163)<=G$9)*(YEAR($C163)>=G$9)),-3),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($B163<$C163,ROUND($EK163/(DATEDIF($B163,$C163,\"m\")+1)*((MONTH(MIN((1&-S$9-1)-1,$C163))-MONTH(MAX(1&-S$9,$B163))+1)*(YEAR($B163)<=S$9)*(YEAR($C163)>=S$9)),-3),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($B163<$C163,ROUND($EK163/(DATEDIF($B163,$C163,\"m\")+1)*((MONTH(MIN((1&-AE$9-1)-1,$C163))-MONTH(MAX(1&-AE$9,$B163))+1)*(YEAR($B163)<=AE$9)*(YEAR($C163)>=AE$9)),-3),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($B163<$C163,ROUND($EK163/(DATEDIF($B163,$C163,\"m\")+1)*((MONTH(MIN((1&-AQ$9-1)-1,$C163))-MONTH(MAX(1&-AQ$9,$B163))+1)*(YEAR($B163)<=AQ$9)*(YEAR($C163)>=AQ$9)),-3),0)","v":54000},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($B163<$C163,ROUND($EK163/(DATEDIF($B163,$C163,\"m\")+1)*((MONTH(MIN((1&-BC$9-1)-1,$C163))-MONTH(MAX(1&-BC$9,$B163))+1)*(YEAR($B163)<=BC$9)*(YEAR($C163)>=BC$9)),-3),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($B163<$C163,ROUND($EK163/(DATEDIF($B163,$C163,\"m\")+1)*((MONTH(MIN((1&-BO$9-1)-1,$C163))-MONTH(MAX(1&-BO$9,$B163))+1)*(YEAR($B163)<=BO$9)*(YEAR($C163)>=BO$9)),-3),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($B163<$C163,ROUND($EK163/(DATEDIF($B163,$C163,\"m\")+1)*((MONTH(MIN((1&-CA$9-1)-1,$C163))-MONTH(MAX(1&-CA$9,$B163))+1)*(YEAR($B163)<=CA$9)*(YEAR($C163)>=CA$9)),-3),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($B163<$C163,ROUND($EK163/(DATEDIF($B163,$C163,\"m\")+1)*((MONTH(MIN((1&-CM$9-1)-1,$C163))-MONTH(MAX(1&-CM$9,$B163))+1)*(YEAR($B163)<=CM$9)*(YEAR($C163)>=CM$9)),-3),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($B163<$C163,ROUND($EK163/(DATEDIF($B163,$C163,\"m\")+1)*((MONTH(MIN((1&-CY$9-1)-1,$C163))-MONTH(MAX(1&-CY$9,$B163))+1)*(YEAR($B163)<=CY$9)*(YEAR($C163)>=CY$9)),-3),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($B163<$C163,ROUND($EK163/(DATEDIF($B163,$C163,\"m\")+1)*((MONTH(MIN((1&-DK$9-1)-1,$C163))-MONTH(MAX(1&-DK$9,$B163))+1)*(YEAR($B163)<=DK$9)*(YEAR($C163)>=DK$9)),-3),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,0.09,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$EQ$173*DW163","v":54000}]
["Submission Bauarbeiten",{"$f":"B103","v":"2024-10-01"},{"$f":"C103","v":"2025-02-28"},{"$f":"D103","v":0},{"$f":"E103","v":0},{"$f":"F103","v":4},{"$f":"IF($B164<$C164,ROUND($EK164/(DATEDIF($B164,$C164,\"m\")+1)*((MONTH(MIN((1&-G$9-1)-1,$C164))-MONTH(MAX(1&-G$9,$B164))+1)*(YEAR($B164)<=G$9)*(YEAR($C164)>=G$9)),-3),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($B164<$C164,ROUND($EK164/(DATEDIF($B164,$C164,\"m\")+1)*((MONTH(MIN((1&-S$9-1)-1,$C164))-MONTH(MAX(1&-S$9,$B164))+1)*(YEAR($B164)<=S$9)*(YEAR($C164)>=S$9)),-3),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($B164<$C164,ROUND($EK164/(DATEDIF($B164,$C164,\"m\")+1)*((MONTH(MIN((1&-AE$9-1)-1,$C164))-MONTH(MAX(1&-AE$9,$B164))+1)*(YEAR($B164)<=AE$9)*(YEAR($C164)>=AE$9)),-3),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($B164<$C164,ROUND($EK164/(DATEDIF($B164,$C164,\"m\")+1)*((MONTH(MIN((1&-AQ$9-1)-1,$C164))-MONTH(MAX(1&-AQ$9,$B164))+1)*(YEAR($B164)<=AQ$9)*(YEAR($C164)>=AQ$9)),-3),0)","v":58000},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($B164<$C164,ROUND($EK164/(DATEDIF($B164,$C164,\"m\")+1)*((MONTH(MIN((1&-BC$9-1)-1,$C164))-MONTH(MAX(1&-BC$9,$B164))+1)*(YEAR($B164)<=BC$9)*(YEAR($C164)>=BC$9)),-3),0)","v":38000},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($B164<$C164,ROUND($EK164/(DATEDIF($B164,$C164,\"m\")+1)*((MONTH(MIN((1&-BO$9-1)-1,$C164))-MONTH(MAX(1&-BO$9,$B164))+1)*(YEAR($B164)<=BO$9)*(YEAR($C164)>=BO$9)),-3),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($B164<$C164,ROUND($EK164/(DATEDIF($B164,$C164,\"m\")+1)*((MONTH(MIN((1&-CA$9-1)-1,$C164))-MONTH(MAX(1&-CA$9,$B164))+1)*(YEAR($B164)<=CA$9)*(YEAR($C164)>=CA$9)),-3),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($B164<$C164,ROUND($EK164/(DATEDIF($B164,$C164,\"m\")+1)*((MONTH(MIN((1&-CM$9-1)-1,$C164))-MONTH(MAX(1&-CM$9,$B164))+1)*(YEAR($B164)<=CM$9)*(YEAR($C164)>=CM$9)),-3),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($B164<$C164,ROUND($EK164/(DATEDIF($B164,$C164,\"m\")+1)*((MONTH(MIN((1&-CY$9-1)-1,$C164))-MONTH(MAX(1&-CY$9,$B164))+1)*(YEAR($B164)<=CY$9)*(YEAR($C164)>=CY$9)),-3),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($B164<$C164,ROUND($EK164/(DATEDIF($B164,$C164,\"m\")+1)*((MONTH(MIN((1&-DK$9-1)-1,$C164))-MONTH(MAX(1&-DK$9,$B164))+1)*(YEAR($B164)<=DK$9)*(YEAR($C164)>=DK$9)),-3),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,0.16,null,null,null,null,null,null,null,null,null,null,null,null,null,96000]
["Ausführungsprojekt (Phase 2)",{"$f":"B113","v":"2025-03-01"},{"$f":"C113","v":"2025-07-31"},null,null,{"$f":"F113","v":4},0,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,54000,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0.09,null,null,null,null,null,null,null,null,null,null,null,null,null,54000]
["Bauausführung / Bau",{"$f":"B122","v":"2025-08-01"},{"$f":"C122","v":"2025-12-31"},{"$f":"D122","v":0},{"$f":"E122","v":0},{"$f":"F122","v":4},{"$f":"IF($B166<$C166,ROUND(($EK166+$EQ166)/(DATEDIF($B166,$C166,\"m\")+1)*((MONTH(MIN((1&-G$9-1)-1,$C166))-MONTH(MAX(1&-G$9,$B166))+1)*(YEAR($B166)<=G$9)*(YEAR($C166)>=G$9)),-3),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($B166<$C166,ROUND(($EK166+$EQ166)/(DATEDIF($B166,$C166,\"m\")+1)*((MONTH(MIN((1&-S$9-1)-1,$C166))-MONTH(MAX(1&-S$9,$B166))+1)*(YEAR($B166)<=S$9)*(YEAR($C166)>=S$9)),-3),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($B166<$C166,ROUND(($EK166+$EQ166)/(DATEDIF($B166,$C166,\"m\")+1)*((MONTH(MIN((1&-AE$9-1)-1,$C166))-MONTH(MAX(1&-AE$9,$B166))+1)*(YEAR($B166)<=AE$9)*(YEAR($C166)>=AE$9)),-3),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($B166<$C166,ROUND(($EK166+$EQ166)/(DATEDIF($B166,$C166,\"m\")+1)*((MONTH(MIN((1&-AQ$9-1)-1,$C166))-MONTH(MAX(1&-AQ$9,$B166))+1)*(YEAR($B166)<=AQ$9)*(YEAR($C166)>=AQ$9)),-3),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($B166<$C166,ROUND(($EK166+$EQ166)/(DATEDIF($B166,$C166,\"m\")+1)*((MONTH(MIN((1&-BC$9-1)-1,$C166))-MONTH(MAX(1&-BC$9,$B166))+1)*(YEAR($B166)<=BC$9)*(YEAR($C166)>=BC$9)),-3),0)","v":5174000},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($B166<$C166,ROUND(($EK166+$EQ166)/(DATEDIF($B166,$C166,\"m\")+1)*((MONTH(MIN((1&-BO$9-1)-1,$C166))-MONTH(MAX(1&-BO$9,$B166))+1)*(YEAR($B166)<=BO$9)*(YEAR($C166)>=BO$9)),-3),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($B166<$C166,ROUND(($EK166+$EQ166)/(DATEDIF($B166,$C166,\"m\")+1)*((MONTH(MIN((1&-CA$9-1)-1,$C166))-MONTH(MAX(1&-CA$9,$B166))+1)*(YEAR($B166)<=CA$9)*(YEAR($C166)>=CA$9)),-3),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($B166<$C166,ROUND(($EK166+$EQ166)/(DATEDIF($B166,$C166,\"m\")+1)*((MONTH(MIN((1&-CM$9-1)-1,$C166))-MONTH(MAX(1&-CM$9,$B166))+1)*(YEAR($B166)<=CM$9)*(YEAR($C166)>=CM$9)),-3),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($B166<$C166,ROUND(($EK166+$EQ166)/(DATEDIF($B166,$C166,\"m\")+1)*((MONTH(MIN((1&-CY$9-1)-1,$C166))-MONTH(MAX(1&-CY$9,$B166))+1)*(YEAR($B166)<=CY$9)*(YEAR($C166)>=CY$9)),-3),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($B166<$C166,ROUND(($EK166+$EQ166)/(DATEDIF($B166,$C166,\"m\")+1)*((MONTH(MIN((1&-DK$9-1)-1,$C166))-MONTH(MAX(1&-DK$9,$B166))+1)*(YEAR($B166)<=DK$9)*(YEAR($C166)>=DK$9)),-3),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,0.28999999999999998,null,null,null,null,null,null,null,null,null,null,null,null,null,174000,null,null,null,null,null,{"$f":"EQ176","v":5000000}]
["Inbetriebnahme, Eröffnung",{"$f":"B137","v":"2026-01-01"},{"$f":"C137","v":"2026-05-31"},{"$f":"D137","v":0},{"$f":"E137","v":0},{"$f":"F137","v":4},0,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,12000,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0.02,null,null,null,null,null,null,null,null,null,null,null,null,null,12000]
["Projektabschluss",{"$f":"B144","v":"2026-06-01"},{"$f":"C144","v":"2026-10-31"},{"$f":"D144","v":0},{"$f":"E144","v":0},{"$f":"F144","v":4},0,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,12000,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0.02,null,null,null,null,null,null,null,null,null,null,null,null,null,12000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(DW160:DY168)","v":1},null,null,null,null,null,null,null,{"$f":"SUM(EE159:EJ168)","v":60000},null,null,null,null,null,{"$f":"SUM(EF160:EL168)","v":600000},null,null,null,null,null,{"$f":"SUM(EQ159:EV168)","v":5000000}]
[]
["Aggregiert nach Hauptphasen",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eingabemaske Budget"]
["Planung (SIA 11-21)",{"$f":"MIN(B12,B19,B26)","v":"2021-01-01"},{"$f":"MAX(C12,C19,C26)","v":"2021-05-31"},null,null,{"$f":"MIN(F10:F12,F19,F26)","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Planungsstudie total",null,null,null,null,null,null,null,null,null,null,null,60000]
["Projektierung (SIA 31-33)",{"$f":"MIN(B38,B61)","v":"2021-06-01"},{"$f":"MAX(C38,C61)","v":"2023-02-28"},null,null,{"$f":"MIN(F38,F61)","v":2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Projektierungskosten total",null,null,null,null,null,null,null,null,null,null,null,600000]
["Kreditbeschaffung",{"$f":"MIN(B86)","v":"2023-04-01"},{"$f":"MAX(C86)","v":"2024-04-30"},null,null,{"$f":"MIN(F86)","v":3},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Anteil Projektierung (SIA 31-33)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(DW160:DY161)","v":0.32999999999999996}]
["Ausführung (SIA 41-53)",{"$f":"MIN(B95,B103,B122,B137,B144)","v":"2024-05-01"},{"$f":"MAX(C95,C103,C122,C137,C144)","v":"2026-10-31"},null,null,{"$f":"MIN(F95,F103,F122,F137,F144)","v":4},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Anteil Projektierung (SIA 41-53)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"1-EQ174","v":0.67}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Baukosten Ausführung",null,null,null,null,null,null,null,null,null,null,null,5000000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kosten total",null,null,null,null,null,null,null,null,null,null,null,{"$f":"EQ176+EQ173+EQ172","v":5660000}]
[]
["Mittlere Budgetverteilung berechnet",null,null,null,null,null,{"$f":"G9","v":2021},null,null,null,null,null,null,null,null,null,null,null,{"$f":"G179+1","v":2022},null,null,null,null,null,null,null,null,null,null,null,{"$f":"S179+1","v":2023},null,null,null,null,null,null,null,null,null,null,null,{"$f":"AE179+1","v":2024},null,null,null,null,null,null,null,null,null,null,null,{"$f":"AQ179+1","v":2025},null,null,null,null,null,null,null,null,null,null,null,{"$f":"BC179+1","v":2026},null,null,null,null,null,null,null,null,null,null,null,{"$f":"BO179+1","v":2027},null,null,null,null,null,null,null,null,null,null,null,{"$f":"CA179+1","v":2028},null,null,null,null,null,null,null,null,null,null,null,{"$f":"CM179+1","v":2029},null,null,null,null,null,null,null,null,null,null,null,{"$f":"CY179+1","v":2030}]
["Planung (SIA 11-21)",null,null,null,null,null,{"$f":"SUM(G157:G159)","v":60000},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(S157:S159)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AE157:AE159)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AQ157:AQ159)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(BC157:BC159)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(BO157:BO159)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(CA157:CA159)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(CM157:CM159)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(CY157:CY159)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(DK157:DK159)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G180:DV180)","v":60000}]
["Projektierung (SIA 31-33)",null,null,null,null,null,{"$f":"SUM(G160:G161)","v":72000},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(S160:S161)","v":108000},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AE160:AE161)","v":18000},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AQ160:AQ161)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(BC160:BC161)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(BO160:BO161)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(CA160:CA161)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(CM160:CM161)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(CY160:CY161)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(DK160:DK161)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G181:DV181)","v":198000}]
["Projektierung und Ausführung (SIA 41-53)",null,null,null,null,null,{"$f":"SUM(G163:G168)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(S163:S168)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AE163:AE168)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AQ163:AQ168)","v":112000},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(BC163:BC168)","v":5266000},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(BO163:BO168)","v":24000},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(CA163:CA168)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(CM163:CM168)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(CY163:CY168)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(DK163:DK168)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G182:DV182)","v":5402000}]
[null,null,null,null,null,null,{"$f":"SUM(G180:R182)","v":132000},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(S180:AD182)","v":108000},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AE180:AP182)","v":18000},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AQ180:BB182)","v":112000},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(BC180:BN182)","v":5266000},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(BO180:BZ182)","v":24000},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(CA180:CL182)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(CM180:CX182)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(CY180:DJ182)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(DK180:DV182)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G183:DV183)","v":5660000}]
[]
[]
["Budgeverteilung PL",null,null,null,null,null,{"$f":"B5","v":2021},null,null,null,null,null,null,null,null,null,null,null,{"$f":"G186+1","v":2022},null,null,null,null,null,null,null,null,null,null,null,{"$f":"S186+1","v":2023},null,null,null,null,null,null,null,null,null,null,null,{"$f":"AE186+1","v":2024},null,null,null,null,null,null,null,null,null,null,null,{"$f":"AQ186+1","v":2025},null,null,null,null,null,null,null,null,null,null,null,{"$f":"BC186+1","v":2026},null,null,null,null,null,null,null,null,null,null,null,{"$f":"BO186+1","v":2027},null,null,null,null,null,null,null,null,null,null,null,{"$f":"CA186+1","v":2028},null,null,null,null,null,null,null,null,null,null,null,{"$f":"CM186+1","v":2029},null,null,null,null,null,null,null,null,null,null,null,{"$f":"CY186+1","v":2030}]
["Planung (SIA 11-21)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G187:DV187)","v":0}]
["Projektierung (SIA 31-33)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G188:DV188)","v":0}]
["Ausführung (SIA 41-53)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G189:DV189)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(DW187:EC189)","v":0}]
[]
["Bereich für eigene Beitragsberechnungen"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["*Die vorliegenden Tätigkeiten bilden die Prozessschritte in reduzierter Form ab. Die gültigen Prozesse sind im IST publiziert."]