{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Cover","Terminplanung"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":5,"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":"Cover","index":0,"n_rows":23,"n_cols":3,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Excel + VBA "]
[null,"für Controller"]
[]
[]
[null,"Kapitel",9]
[null,"Thema","Strategisches Projekt-Controlling"]
[]
[null,"Inhalt","Termin-Planung"]
[]
[null,null," "]
[]
[]
[]
[]
[]
[null,"Version","1.0"]
[null,"Autor","Harald Nahrstedt"]
[null,"Datum","2025-04-27"]
[]
[]
[null,"Springer Verlag"]

{"sheet":"Terminplanung","index":1,"n_rows":60,"n_cols":10,"rows_kept":60,"cut":false,"hidden":false,"merged":[]}
[]
["Aktuelles Datum","2019-06-12"]
["Offset",3]
[]
["Aufgabe","A","B","C","D","E","F","G","H","∑"]
["Beginn","2019-06-14","2019-06-17","2019-06-15","2019-06-17","2019-06-17","2019-06-17","2019-06-20"]
["Ende","2019-07-17","2019-07-10","2019-08-20","2019-07-22","2019-08-15","2019-07-09","2019-07-08"]
["Stunden",74,25,55,48,256,65,122,null,{"$f":"SUM(B8:I8)","v":645}]
["Kapazität (h/Tag)",4,2,2,2,3,4,12,null,{"$f":"SUM(B9:I9)","v":29}]
["Resttage",{"$f":"IF(B$9>0,B$7-WORKDAY(B$6,B$8/B$9,2)-2,\"\")","v":5},{"$f":"IF(C$9>0,C$7-WORKDAY(C$6,C$8/C$9,2)-2,\"\")","v":5},26,1,-62,-2,2,""]
[{"$f":"IF(WEEKDAY(MIN(Aktuelles_Datum+Offset-1),2)=6,MIN(Aktuelles_Datum+Offset-2),IF(WEEKDAY(MIN(Aktuelles_Datum+Offset-1),2)=7,MIN(Aktuelles_Datum+Offset-3),MIN(Aktuelles_Datum+Offset-1)))","v":"2019-06-14"},{"$f":"IF(OR(B$8<=0,$A11<B$6),0,IF(B$8-IF(NETWORKDAYS(B$6,$A11,2)<0,0,(NETWORKDAYS(B$6,$A11,2)-1)*B$9)>B$9,(NETWORKDAYS(B$6,$A11,2))*B$9/B$8,IF(B$8-(NETWORKDAYS(B$6,$A11,2)-1)*B$9>0,1,0)))","v":5.4054054054054057E-2},0,0,0,0,0,0,0]
[{"$f":"IF(WEEKDAY(A11,2)=5,A11+3,A11+1)","v":"2019-06-17"},0.10810810810810811,0.08,3.6363636363636362E-2,4.1666666666666664E-2,1.171875E-2,6.1538461538461542E-2,0,0,{"$f":"(B12-B11>0)*((B12-B11)*B$8)+(C12-C11>0)*((C12-C11)*C$8)+(D12-D11>0)*((D12-D11)*D$8)+(E12-E11>0)*((E12-E11)*E$8)+(F12-F11>0)*((F12-F11)*F$8)+(G12-G11>0)*((G12-G11)*G$8)+(H12-H11>0)*((H12-H11)*H$8)+(I12-I11>0)*((I12-I11)*I$8)","v":17}]
[{"$f":"IF(WEEKDAY(A12,2)=5,A12+3,A12+1)","v":"2019-06-18"},0.16216216216216217,{"$f":"IF(OR(C$8<=0,$A13<C$6),0,IF(C$8-IF(NETWORKDAYS(C$6,$A13,2)<0,0,(NETWORKDAYS(C$6,$A13,2)-1)*C$9)>C$9,(NETWORKDAYS(C$6,$A13,2))*C$9/C$8,IF(C$8-(NETWORKDAYS(C$6,$A13,2)-1)*C$9>0,1,0)))","v":0.16},7.2727272727272724E-2,8.3333333333333329E-2,2.34375E-2,0.12307692307692308,0,0,{"$f":"(B13-B12>0)*((B13-B12)*B$8)+(C13-C12>0)*((C13-C12)*C$8)+(D13-D12>0)*((D13-D12)*D$8)+(E13-E12>0)*((E13-E12)*E$8)+(F13-F12>0)*((F13-F12)*F$8)+(G13-G12>0)*((G13-G12)*G$8)+(H13-H12>0)*((H13-H12)*H$8)+(I13-I12>0)*((I13-I12)*I$8)","v":17}]
["2019-06-19",0.21621621621621623,0.24,0.10909090909090909,0.125,3.515625E-2,0.18461538461538463,0,0,17]
["2019-06-20",0.27027027027027029,0.32,0.14545454545454545,0.16666666666666666,4.6875E-2,0.24615384615384617,9.8360655737704916E-2,0,29]
["2019-06-21",0.32432432432432434,0.4,0.18181818181818182,0.20833333333333334,5.859375E-2,0.30769230769230771,0.19672131147540983,0,29]
["2019-06-24",0.3783783783783784,0.48,0.21818181818181817,0.25,7.03125E-2,0.36923076923076925,0.29508196721311475,0,29]
["2019-06-25",0.43243243243243246,0.56000000000000005,0.25454545454545452,0.29166666666666669,8.203125E-2,0.43076923076923079,0.39344262295081966,0,29]
["2019-06-26",0.48648648648648651,0.64,0.29090909090909089,0.33333333333333331,9.375E-2,0.49230769230769234,0.49180327868852458,0,29]
["2019-06-27",0.54054054054054057,0.72,0.32727272727272727,0.375,0.10546875,0.55384615384615388,0.5901639344262295,0,29]
["2019-06-28",0.59459459459459463,0.8,0.36363636363636365,0.41666666666666669,0.1171875,0.61538461538461542,0.68852459016393441,0,29.000000000000004]
["2019-07-01",0.64864864864864868,0.88,0.4,0.45833333333333331,0.12890625,0.67692307692307696,0.78688524590163933,0,29]
["2019-07-02",0.70270270270270274,0.96,0.43636363636363634,0.5,0.140625,0.7384615384615385,0.88524590163934425,0,28.999999999999996]
["2019-07-03",0.7567567567567568,1,0.47272727272727272,0.54166666666666663,0.15234375,0.8,0.98360655737704916,0,28]
["2019-07-04",0.81081081081081086,0,0.50909090909090904,0.58333333333333337,0.1640625,0.86153846153846159,1,0,17.000000000000004]
["2019-07-05",0.86486486486486491,0,0.54545454545454541,0.625,0.17578125,0.92307692307692313,0,0,15]
["2019-07-08",0.91891891891891897,0,0.58181818181818179,0.66666666666666663,0.1875,0.98461538461538467,0,0,15]
["2019-07-09",0.97297297297297303,0,0.61818181818181817,0.70833333333333337,0.19921875,1,0,0,12]
["2019-07-10",1,0,0.65454545454545454,0.75,0.2109375,0,0,0,8.9999999999999947]
["2019-07-11",0,0,0.69090909090909092,0.79166666666666663,0.22265625,0,0,0,6.9999999999999991]
["2019-07-12",0,0,0.72727272727272729,0.83333333333333337,0.234375,0,0,0,7.0000000000000044]
["2019-07-15",0,0,0.76363636363636367,0.875,0.24609375,0,0,0,6.9999999999999991]
["2019-07-16",0,0,0.8,0.91666666666666663,0.2578125,0,0,0,6.9999999999999991]
["2019-07-17",0,0,0.83636363636363631,0.95833333333333337,0.26953125,0,0,0,6.9999999999999982]
["2019-07-18",0,0,0.87272727272727268,1,0.28125,0,0,0,6.9999999999999991]
["2019-07-19",0,0,0.90909090909090906,0,0.29296875,0,0,0,5.0000000000000009]
["2019-07-22",0,0,0.94545454545454544,0,0.3046875,0,0,0,5.0000000000000009]
["2019-07-23",0,0,0.98181818181818181,0,0.31640625,0,0,0,5.0000000000000009]
["2019-07-24",0,0,1,0,0.328125,0,0,0,4]
["2019-07-25",0,0,0,0,0.33984375,0,0,0,3]
["2019-07-26",0,0,0,0,0.3515625,0,0,0,3]
["2019-07-29",0,0,0,0,0.36328125,0,0,0,3]
["2019-07-30",0,0,0,0,0.375,0,0,0,3]
["2019-07-31",{"$f":"IF(OR(B$8<=0,$A44<B$6),0,IF(B$8-IF(NETWORKDAYS(B$6,$A44,2)<0,0,(NETWORKDAYS(B$6,$A44,2)-1)*B$9)>B$9,(NETWORKDAYS(B$6,$A44,2))*B$9/B$8,IF(B$8-(NETWORKDAYS(B$6,$A44,2)-1)*B$9>0,1,0)))","v":0},0,0,0,0.38671875,0,0,0,3]
["2019-08-01",0,0,0,0,0.3984375,0,0,0,3]
["2019-08-02",0,0,0,0,0.41015625,0,0,0,3]
["2019-08-05",0,0,0,0,0.421875,0,0,0,3]
["2019-08-06",0,0,0,0,0.43359375,0,0,0,3]
["2019-08-07",0,0,0,0,0.4453125,0,0,0,3]
["2019-08-08",0,0,0,0,0.45703125,0,0,0,3]
["2019-08-09",0,0,0,0,0.46875,0,0,0,3]
["2019-08-12",0,0,0,0,0.48046875,0,0,0,3]
["2019-08-13",0,0,0,0,0.4921875,0,0,0,3]
["2019-08-14",0,0,0,0,0.50390625,0,0,0,3]
["2019-08-15",0,0,0,0,0.515625,0,0,0,3]
["2019-08-16",0,0,0,0,0.52734375,0,0,0,3]
["2019-08-19",0,0,0,0,0.5390625,0,0,0,3]
["2019-08-20",0,0,0,0,0.55078125,0,0,0,3]
["2019-08-21",0,0,0,0,0.5625,0,0,0,3]
["2019-08-22",0,0,0,0,0.57421875,0,0,0,3]