{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Cover","Status","50-50","0-100","Step-To-Step","Relativ"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":6,"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",10]
[null,"Thema","Operatives Projekt-Controlling"]
[]
[null,"Inhalt","Fortschrittsgrad"]
[]
[null,null," "]
[]
[]
[]
[]
[]
[null,"Version","1.0"]
[null,"Autor","Harald Nahrstedt"]
[null,"Datum","2025-04-29"]
[]
[]
[null,"Springer Verlag"]

{"sheet":"Status","index":1,"n_rows":8,"n_cols":6,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Aufgabe","Aufwand\nPlan","Aufwand\nIst","Aufwand\nRest","Fertigungsgrad","kumulierter FG"]
["A ",0.25,0.25,{"$f":"Plan-Ist","v":4},{"$f":"IF(Plan>0,Ist/Plan,0)","v":0.6},{"$f":"B2*E2","v":0.15}]
["B",0.2,0,10,0.5,{"$f":"F2+B3*E3","v":0.25}]
["C",0.1,0.1,17,0.15,{"$f":"F3+B4*E4","v":0.26500000000000001}]
["D",0.15,0.1,10,0.33333333333333331,0.315]
["E",0.2,0.1,25,0,0.315]
["F",0.1,0,10,0,0.315]
["Gesamt",{"$f":"SUM(Plan)","v":100},{"$f":"SUM(Ist)","v":24},{"$f":"SUM(Rest)","v":80},null,{"$f":"F7","v":0.315}]

{"sheet":"50-50","index":2,"n_rows":8,"n_cols":6,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Aufgabe","Aufwand\nPlan","Aufwand\nIst","Aufwand\nRest","Fertigungsgrad","kumulierter FG"]
["A ",0.25,0.25,{"$f":"B2-C2","v":0},{"$f":"IF(Plan>0,IF(Ist/Plan=1,1,IF(Ist/Plan>=0.5,0.5,0)),0)","v":0.5},{"$f":"B2*E2","v":0.125}]
["B",0.2,0,{"$f":"B3-C3","v":0.2},0.5,{"$f":"F2+B3*E3","v":0.22500000000000001}]
["C",0.1,0.1,0,0,{"$f":"F3+B4*E4","v":0.22500000000000001}]
["D",0.15,0.1,4.9999999999999989E-2,0,0.22500000000000001]
["E",0.2,0.1,0.1,0,0.22500000000000001]
["F",0.1,0,0.1,0,0.22500000000000001]
["Gesamt",{"$f":"SUM(B2:B7)","v":1.0000000000000002},{"$f":"SUM(C2:C7)","v":0.54999999999999993},{"$f":"SUM(D2:D7)","v":0.44999999999999996},null,{"$f":"F7","v":0.22500000000000001}]

{"sheet":"0-100","index":3,"n_rows":8,"n_cols":6,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Aufgabe","Aufwand\nPlan","Aufwand\nIst","Aufwand\nRest","Fertigungsgrad","kumulierter FG"]
["A ",0.25,0.25,{"$f":"B2-C2","v":0},{"$f":"IF(Plan>0,IF(Ist/Plan=1,1,0),0)","v":0},{"$f":"B2*E2","v":0}]
["B",0.2,0,{"$f":"B3-C3","v":0.2},0,{"$f":"F2+B3*E3","v":0}]
["C",0.1,0.1,0,0,{"$f":"F3+B4*E4","v":0}]
["D",0.15,0.1,4.9999999999999989E-2,0,0]
["E",0.2,0.1,0.1,0,0]
["F",0.1,0,0.1,0,0]
["Gesamt",{"$f":"SUM(B2:B7)","v":1.0000000000000002},{"$f":"SUM(C2:C7)","v":0.54999999999999993},{"$f":"SUM(D2:D7)","v":0.44999999999999996},null,{"$f":"F7","v":0}]

{"sheet":"Step-To-Step","index":4,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Meilenstein","Aufwand","Fertigungsgrad","kumulierter FG"]
["MS 1",80,{"$f":"Aufwand/Gesamt","v":{"$error":"#NAME?"}},{"$f":"C2","v":{"$error":"#NAME?"}}]
["MS 2",60,{"$error":"#NAME?"},{"$f":"D2+C3","v":{"$error":"#NAME?"}}]
["MS 3",100,{"$error":"#NAME?"},{"$f":"D3+C4","v":{"$error":"#NAME?"}}]
["MS 4",130,{"$error":"#NAME?"},{"$error":"#NAME?"}]
["MS 5",110,{"$error":"#NAME?"},{"$error":"#NAME?"}]
["MS 6",20,{"$error":"#NAME?"},{"$error":"#NAME?"}]
["Gesamt",{"$f":"SUM(B2:B7)","v":500}]

{"sheet":"Relativ","index":5,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Arbeitspaket","Aufwand\nPlan","Aufwand\nIst","Aufwand\nRest","Fertigungsgrad"]
["A 1",10,6,4,{"$f":"Ist/(Ist+Rest)","v":0.6}]
["A 2",20,10,12,0.45454545454545453]
["A 3",20,3,14,0.17647058823529413]
["A 4",15,5,15,0.25]
["A 5",25,0,25,0]
["A 6",10,0,10,0]
["Gesamt",{"$f":"SUM(Plan)","v":100},{"$f":"SUM(Ist)","v":24},{"$f":"SUM(Rest)","v":80},{"$f":"C8/(C8+D8)","v":0.23076923076923078}]