{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Cover","Arbeitspaket"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":1,"defined_names":8,"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","Kostenvergleichs-Tabelle"]
[]
[null,null," "]
[]
[]
[]
[]
[]
[null,"Version","2.0"]
[null,"Autor","Harald Nahrstedt"]
[null,"Datum","2023-08-04"]
[]
[]
[null,"Springer Verlag"]

{"sheet":"Arbeitspaket","index":1,"n_rows":12,"n_cols":7,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[null,"Plan","Status","Anteil","Ist","Abw.","Abw. %"]
["Erhebung",4600,1,{"$f":"Plan*Status","v":4600},6320,{"$f":"Ist-Anteil","v":1720},{"$f":"IF(Anteil>0,Abw./Anteil,0)","v":0.37391304347826088}]
["Analyse",2800,1,2800,4230,1430,0.51071428571428568]
["Entwurf",1900,1,1900,1470,-430,-0.22631578947368422]
["Bewertung",1300,1,1300,980,-320,-0.24615384615384617]
["Auswahl",800,1,800,460,-340,-0.42499999999999999]
["Ende Vorstudie",300,1,300,1060,760,2.5333333333333332]
["Vorstudie",{"$f":"SUM(B2:B7)","v":11700},null,{"$f":"SUM(D2:D7)","v":11700},{"$f":"SUM(E2:E7)","v":14520},{"$f":"SUM(F2:F7)","v":2820},0.24102564102564103]
["Prozess",32500,0.7,{"$f":"Plan*Status","v":22750},17900,{"$f":"Ist-Anteil","v":-4850},-0.21318681318681318]
["Software",43600,0.6,{"$f":"Plan*Status","v":26160},28300,{"$f":"Ist-Anteil","v":2140},8.1804281345565749E-2]
["Tests",14700,0.45,{"$f":"Plan*Status","v":6615},5900,{"$f":"Ist-Anteil","v":-715},-0.10808767951625095]
["Abnahme",3500,0,{"$f":"Plan*Status","v":0},0,{"$f":"Ist-Anteil","v":0},0]