{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Cover","Kapazitätsplanung"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":11,"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","Kapazitätsplanung"]
[]
[null,null," "]
[]
[]
[]
[]
[]
[null,"Version","1.0"]
[null,"Autor","Harald Nahrstedt"]
[null,"Datum","2025-04-27"]
[]
[]
[null,"Springer Verlag"]

{"sheet":"Kapazitätsplanung","index":1,"n_rows":50,"n_cols":11,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
[]
["Arbeitszeit",8]
["Aktuelles Datum","2017-05-12"]
["Offset",0]
["Kapazität",40]
[]
["Aufgabe","A","B","C","D","E","F","G","H","∑","Auslastung"]
["Beginn","2017-05-17","2017-05-17","2017-05-15","2017-05-17","2017-05-17","2017-05-17","2017-05-20"]
["Stunden",76,25,55,48,256,65,122,null,{"$f":"SUM(B9:I9)","v":647}]
["Dauer (Tage)",{"$f":"Stunden/Arbeitszeit","v":9.5},3.125,6.875,6,32,8.125,15.25,0,80.875]
[{"$f":"IF(WEEKDAY(MIN(Aktuelles_Datum+Offset-1),2)=6,MIN(Aktuelles_Datum+Offset+1),IF(WEEKDAY(MIN(Aktuelles_Datum+Offset-1),2)=7,MIN(Aktuelles_Datum+Offset),MIN(Aktuelles_Datum+Offset-1)))","v":"2017-05-11"},{"$f":"IF(OR(B$9<=0,$A11<B$8),\"\",IF(B$9-IF(NETWORKDAYS(B$8,$A11,2)<0,0,(NETWORKDAYS(B$8,$A11,2)-1)*$B$2)>$B$2,$B$2,IF(B$9-(NETWORKDAYS(B$8,$A11,2)-1)*$B$2>0,B$9-(NETWORKDAYS(B$8,$A11,2)-1)*$B$2,\"\")))","v":""},"","","","","","","",0,{"$f":"J11/$B$5","v":0}]
[{"$f":"IF(WEEKDAY(A11,2)=5,A11+3,A11+1)","v":"2017-05-12"},"","","","","","","","",0,{"$f":"J12/$B$5","v":0}]
[{"$f":"IF(WEEKDAY(A12,2)=5,A12+3,A12+1)","v":"2017-05-15"},"","",8,"","","","","",8,0.2]
["2017-05-16","","",8,"","","","","",8,0.2]
["2017-05-17",8,8,8,8,8,8,"","",48,1.2]
["2017-05-18",8,8,8,8,8,8,"","",48,1.2]
["2017-05-19",8,8,8,8,8,8,"","",48,1.2]
["2017-05-22",8,1,8,8,8,8,8,"",49,1.2250000000000001]
["2017-05-23",8,"",7,8,8,8,8,"",47,1.175]
["2017-05-24",8,"","",8,8,8,8,"",40,1]
["2017-05-25",{"$f":"IF(OR(B$9<=0,$A21<B$8),\"\",IF(B$9-IF(NETWORKDAYS(B$8,$A21,2)<0,0,(NETWORKDAYS(B$8,$A21,2)-1)*$B$2)>$B$2,$B$2,IF(B$9-(NETWORKDAYS(B$8,$A21,2)-1)*$B$2>0,B$9-(NETWORKDAYS(B$8,$A21,2)-1)*$B$2,\"\")))","v":8},"","","",8,8,8,"",32,0.8]
["2017-05-26",8,"","","",8,8,8,"",32,0.8]
["2017-05-29",8,"","","",8,1,8,"",25,0.625]
["2017-05-30",4,"","","",8,"",8,"",20,0.5]
["2017-05-31","","","","",8,"",8,"",16,0.4]
["2017-06-01","","","","",8,"",8,"",16,0.4]
["2017-06-02",null,"","","",8,"",8,"",16,0.4]
["2017-06-05","","","","",8,"",8,"",16,0.4]
["2017-06-06","","","","",8,"",8,"",16,0.4]
["2017-06-07","","","","",8,"",8,"",16,0.4]
["2017-06-08","","","","",8,"",8,"",16,0.4]
["2017-06-09","","","","",8,"",8,"",16,0.4]
["2017-06-12","","","","",8,"",2,"",10,0.25]
["2017-06-13","","","","",8,"","","",8,0.2]
["2017-06-14",{"$f":"IF(OR(B$9<=0,$A35<B$8),\"\",IF(B$9-IF(NETWORKDAYS(B$8,$A35,2)<0,0,(NETWORKDAYS(B$8,$A35,2)-1)*$B$2)>$B$2,$B$2,IF(B$9-(NETWORKDAYS(B$8,$A35,2)-1)*$B$2>0,B$9-(NETWORKDAYS(B$8,$A35,2)-1)*$B$2,\"\")))","v":""},"","","",8,"","","",8,0.2]
["2017-06-15",{"$f":"IF(OR(B$9<=0,$A36<B$8),\"\",IF(B$9-IF(NETWORKDAYS(B$8,$A36,2)<0,0,(NETWORKDAYS(B$8,$A36,2)-1)*$B$2)>$B$2,$B$2,IF(B$9-(NETWORKDAYS(B$8,$A36,2)-1)*$B$2>0,B$9-(NETWORKDAYS(B$8,$A36,2)-1)*$B$2,\"\")))","v":""},"","","",8,"","","",8,0.2]
["2017-06-16",{"$f":"IF(OR(B$9<=0,$A37<B$8),\"\",IF(B$9-IF(NETWORKDAYS(B$8,$A37,2)<0,0,(NETWORKDAYS(B$8,$A37,2)-1)*$B$2)>$B$2,$B$2,IF(B$9-(NETWORKDAYS(B$8,$A37,2)-1)*$B$2>0,B$9-(NETWORKDAYS(B$8,$A37,2)-1)*$B$2,\"\")))","v":""},"","","",8,"","","",8,0.2]
["2017-06-19","","","","",8,"","","",8,0.2]
["2017-06-20","","","","",8,"","","",8,0.2]
["2017-06-21","","","","",8,"","","",8,0.2]
["2017-06-22","","","","",8,"","","",{"$f":"SUM(B41:I41)","v":8},0.2]
["2017-06-23","","","","",8,"","","",8,0.2]
["2017-06-26","","","","",8,"","","",8,0.2]
["2017-06-27","","","","",8,"","","",8,0.2]
["2017-06-28","","","","",8,"","","",8,0.2]
["2017-06-29","","","","",8,"","","",8,0.2]
["2017-06-30","","","","","","","","",0,0]
["2017-07-03","","","","","","","","",0,0]
["2017-07-04","","","","","","","","",0,0]
["2017-07-05","","","","","","","","",0,0]