{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Cover","Team","Produktion","Sonstiges","Kostenplan"],"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","Strategisches Projekt-Controlling"]
[]
[null,"Inhalt","Kosten-Planung"]
[]
[null,null," "]
[]
[]
[]
[]
[]
[null,"Version","1.0"]
[null,"Autor","Harald Nahrstedt"]
[null,"Datum","2025-04-27"]
[]
[]
[null,"Springer Verlag"]

{"sheet":"Team","index":1,"n_rows":21,"n_cols":4,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Nr","Name","Vorname","Satz"]
[1,"Weidenfeller","Andrea",84]
[2,"Hornschuh","Thomas",56]
[3,"Subotic","Marian",45]
[4,"Hummels","Marc",62]
[5,"Kirch","Leo",49]
[6,"Schmelzer","Otto",58]
[7,"Koray","Maria ",72]
[8,"Kehl","Franz",46]
[9,"Bender","Rene",64]
[10,"Leitner","Zoe",82]
[11,"Sahin","Hans",76]
[12,"Reus","Peter",66]
[13,"Schieber","Wolfgang",87]
[14,"Beck","Anna",66]
[15,"Setzmann","Sonja",92]
[16,"Kunt","Marco",84]
[17,"Kühn","Gitte",86]
[18,"Knop","Julian",76]
[19,"Schuster","Betina",75]
[20,"Engels","Robert",79]

{"sheet":"Produktion","index":2,"n_rows":21,"n_cols":3,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Nr","Bezeichnung","Satz"]
[1,"Maschinen Bereich A1",23.5]
[2,"Maschinen Bereich A2",28.4]
[3,"Maschinen Bereich A3",26.9]
[4,"Maschinen Bereich A4",32.799999999999997]
[5,"Maschinen Bereich A5",34.299999999999997]
[6,"Maschinen Bereich A6",41.7]
[7,"Maschinen Bereich B1",60.2]
[8,"Maschinen Bereich B2",58.8]
[9,"Maschinen Bereich B3",56.7]
[10,"Maschinen Bereich B4",63.2]
[11,"Maschinen Bereich C1",80.5]
[12,"Maschinen Bereich C2",83.5]
[13,"Maschinen Bereich C3",86.8]
[14,"Maschinen Bereich C4",87.1]
[15,"Maschinen Bereich C5",88.8]
[16,"Maschinen Bereich C6",89.5]
[17,"Maschinen Bereich D1",41.1]
[18,"Maschinen Bereich D2",45.8]
[19,"Maschinen Bereich D3",44.9]
[20,"Maschinen Bereich D4",41.4]

{"sheet":"Sonstiges","index":3,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Nr","Bezeichnung","Satz"]
[1,"Sonstiges 1",76.819999999999993]
[2,"Sonstiges 2",38.409999999999997]
[3,"Sonstiges 3",20.27]
[4,"Sonstiges 4",33.1]
[5,"Sonstiges 5",41.69]
[6,"Sonstiges 6",25.61]
[7,"Sonstiges 7",59.37]
[8,"Sonstiges 8",20.260000000000002]
[9,"Sonstiges 9",79.819999999999993]
[10,"Sonstiges 10",22.49]

{"sheet":"Kostenplan","index":4,"n_rows":40,"n_cols":24,"rows_kept":40,"cut":false,"hidden":false,"merged":[[4,22,6,22],[4,23,6,23],[5,0,6,0],[5,1,6,1],[4,2,4,7],[4,8,6,8],[4,9,4,14],[4,15,6,15],[4,16,4,21]]}
[]
["Projekt","XYZ"]
["Leiter","Mustermann"]
[]
[null,null,"PERSONALKOSTEN",null,null,null,null,null,"Personalkosten\nGesamt","PRODUKTIONSKOSTEN",null,null,null,null,null,"Produktionskosten\nGesamt","SONSTIGE KOSTEN",null,null,null,null,null,"Sonstige Kosten\nGesamt","Gesamtkosten"]
["Code","Teilaufgaben\nArbeitspakete\nResourcen",{"$f":"IF(C7>0,CONCATENATE(VLOOKUP(C7,Team,3),\" \",VLOOKUP(C7,Team,2),\" \"))","v":"Sonja Setzmann "},{"$f":"IF(D7>0,CONCATENATE(VLOOKUP(D7,Team,3),\" \",VLOOKUP(D7,Team,2),\" \"))","v":"Thomas Hornschuh "},"Marian Subotic ","Marc Hummels ","Leo Kirch ","Otto Schmelzer ",null,{"$f":"IF(J7>0,VLOOKUP(J7,Produktion,2),\" \")","v":"Maschinen Bereich A1"},"Maschinen Bereich A3","Maschinen Bereich C5","Maschinen Bereich B3","Maschinen Bereich A5"," ",null,{"$f":"IF(Q7>0,VLOOKUP(Q7,Sonstiges,2),\" \")","v":"Sonstiges 3"},"Sonstiges 4","Sonstiges 2","Sonstiges 7"," "," "]
[null,null,15,2,3,4,5,6,null,1,3,15,9,5,null,null,3,4,2,7]
[null,null,{"$f":"IF(C7=\"\",\"\",VLOOKUP(C7,Team,4))","v":92},56,45,62,49,58,null,{"$f":"IF(J7=\"\",\"\",VLOOKUP(J7,Produktion,3))","v":23.5},26.9,88.8,56.7,34.299999999999997,"",null,{"$f":"IF(Q7=\"\",\"\",VLOOKUP(Q7,Sonstiges,3))","v":20.27},33.1,38.409999999999997,59.37,"",""]
["1","Projektmanagement",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"I9+P9+W9","v":0}]
["1.1","Planung",40,8,8,8,8,8,{"$f":"SUMPRODUCT(C10:H10,C$8:H$8)","v":5840},2,2,2,1,1,null,{"$f":"SUMPRODUCT(J10:O10,J$8:O$8)","v":369.4},4,5,9,16,null,null,{"$f":"SUMPRODUCT(Q10:V10,Q$8:V$8)","v":1542.19},7751.59]
["1.2","Controlling",60,2,2,2,2,2,{"$f":"SUMPRODUCT(C11:H11,C$8:H$8)","v":6060},4,1,1,1,1,null,{"$f":"SUMPRODUCT(J11:O11,J$8:O$8)","v":300.7},3,6,18,3,null,null,{"$f":"SUMPRODUCT(Q11:V11,Q$8:V$8)","v":1128.8999999999999},7489.5999999999995]
["1.3","Koordination",4,1,1,1,1,null,580,3,2,2,2,2,null,483.9,12,17,16,6,null,null,1776.72,2840.62]
["1.4 ","Marketing",5,1,1,1,1,null,672,4,2,2,2,2,null,507.4,2,15,11,19,null,null,2087.58,3266.98]
["1.5","Dokumentation",4,null,null,null,null,2,484,1,1,1,1,1,null,230.2,7,12,8,6,null,null,1202.5899999999999,1916.79]
["1.6","Abschluss",6,2,2,2,2,2,1092,1,1,1,1,1,null,230.2,7,13,10,6,null,null,1312.51,2634.71]
[null,"Teilsumme",{"$f":"SUM(C10:C15)","v":119},{"$f":"SUM(D10:D15)","v":14},14,14,14,14,14728,{"$f":"SUM(J10:J15)","v":15},{"$f":"SUM(K10:K15)","v":9},9,8,8,0,2121.8000000000002,{"$f":"SUM(Q10:Q15)","v":35},{"$f":"SUM(R10:R15)","v":68},72,56,{"$f":"SUM(U10:U15)","v":0},{"$f":"SUM(V10:V15)","v":0},9050.49,25900.29]
["2","Ist-Analyse",null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
["2.1","(Arbeitspaket)",15,50,12,57,3,38,10605,42,59,71,18,85,null,{"$f":"SUMPRODUCT(J18:O18,J$8:O$8)","v":12815},17,20,1,0,null,null,1045,{"$f":"I18+P18+W18","v":24465}]
["2.2",null,7,28,3,26,14,54,7777,89,95,55,28,98,null,{"$f":"SUMPRODUCT(J19:O19,J$8:O$8)","v":14480},3,11,19,14,null,null,1985.88,{"$f":"I19+P19+W19","v":24242.880000000001}]
["2.3",null,27,18,52,60,35,45,13877,58,27,45,68,40,null,11312.900000000001,10,10,8,8,null,null,1315.94,26505.84]
["2.4",null,24,38,14,38,48,7,10080,96,19,14,85,27,null,9755.9,13,6,3,19,null,null,1705.37,21541.27]
["2.5",null,60,18,25,50,19,14,12496,21,51,95,80,77,null,17478.5,10,17,7,15,null,null,1924.82,31899.32]
[null,"Teilsumme",{"$f":"SUM(C18:C22)","v":133},{"$f":"SUM(D18:D22)","v":152},106,231,119,158,54835,{"$f":"SUM(J18:J22)","v":306},{"$f":"SUM(K18:K22)","v":251},280,279,327,0,65842.3,{"$f":"SUM(Q18:Q22)","v":53},{"$f":"SUM(R18:R22)","v":64},38,56,{"$f":"SUM(U18:U22)","v":0},{"$f":"SUM(V18:V22)","v":0},7977.01,128654.31]
["3","Teilaufgabe",null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
["3.1",null,17,38,32,8,10,12,{"$f":"SUMPRODUCT(C25:H25,C$8:H$8)","v":6814},66,62,34,72,2,null,{"$f":"SUMPRODUCT(J25:O25,J$8:O$8)","v":10389},13,4,10,11,null,null,1433.08,18636.080000000002]
["3.2",null,31,3,27,23,15,23,7730,74,87,25,64,21,null,{"$f":"SUMPRODUCT(J26:O26,J$8:O$8)","v":10648.399999999998},16,9,18,13,null,null,2085.41,20463.809999999998]
["3.3",null,11,7,35,26,30,19,7163,81,24,50,60,90,null,13478.1,14,15,3,1,null,null,954.88,21595.98]
["3.4",null,29,28,13,26,20,23,8747,18,28,42,2,28,null,5979.5999999999985,5,4,10,10,null,null,1211.5499999999997,15938.149999999998]
["3.5",null,24,39,29,12,36,39,10467,55,65,61,69,95,null,15628.599999999999,7,6,12,18,null,null,1870.0699999999997,27965.67]
["3.6",null,10,39,7,26,4,6,5575,47,43,69,93,72,null,16131.1,16,2,2,1,null,null,526.70999999999992,22232.809999999998]
[null,"Teilsumme",{"$f":"SUM(C25:C30)","v":122},{"$f":"SUM(D25:D30)","v":154},143,121,115,122,46496,{"$f":"SUM(J25:J30)","v":341},{"$f":"SUM(K25:K30)","v":309},281,360,308,{"$f":"SUM(O25:O30)","v":0},72254.8,{"$f":"SUM(Q25:Q30)","v":71},{"$f":"SUM(R25:R30)","v":40},55,54,{"$f":"SUM(U25:U30)","v":0},{"$f":"SUM(V25:V30)","v":0},8081.6999999999989,126832.5]
["4","Teilaufgabe",null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
["4.1",null,3,12,28,29,34,26,7180,57,68,71,24,79,null,{"$f":"SUMPRODUCT(J33:O33,J$8:O$8)","v":13544},10,16,10,12,null,null,1828.8399999999997,22552.84]
["4.2",null,25,0,33,13,21,27,7186,8,89,89,40,32,null,{"$f":"SUMPRODUCT(J34:O34,J$8:O$8)","v":13850.9},13,8,7,2,null,null,915.92,21952.82]
["4.3",null,19,27,14,2,32,10,6162,83,81,4,17,39,null,6786.2,5,2,11,12,null,null,1302.5,14250.7]
["4.4",null,19,22,39,2,1,18,5952,55,77,71,48,64,null,14585.400000000001,10,17,3,14,null,null,1711.81,22249.210000000003]
["4.5",null,null,null,null,null,null,null,0,23,22,30,6,98,null,7497.9,8,11,4,17,null,null,1689.19,9187.09]
["4.6",null,39,13,2,11,20,10,6648,72,82,58,40,34,null,12482.399999999998,7,9,6,10,null,null,1263.9499999999998,20394.349999999999]
[null,"Teilsumme",{"$f":"SUM(C33:C38)","v":105},{"$f":"SUM(D33:D38)","v":74},116,57,108,91,33128,{"$f":"SUM(J33:J38)","v":298},{"$f":"SUM(K33:K38)","v":419},323,175,346,0,{"$f":"SUMPRODUCT(J39:O39,J$8:O$8)","v":68746.8},{"$f":"SUM(Q33:Q38)","v":53},{"$f":"SUM(R33:R38)","v":63},41,67,{"$f":"SUM(U33:U38)","v":0},{"$f":"SUM(V33:V38)","v":0},8712.2099999999991,110587.01000000001]
[null,"Gesamtsumme",{"$f":"SUM(C10:C15,C18:C22,C25:C30,C33:C38)","v":479},{"$f":"SUM(D10:D15,D18:D22,D25:D30,D33:D38)","v":394},379,423,356,385,{"$f":"SUMPRODUCT(C40:H40,C38:H38)","v":40184},{"$f":"SUM(J10:J15,J18:J22,J25:J30,J33:J38)","v":960},{"$f":"SUM(K10:K15,K18:K22,K25:K30,K33:K38)","v":988},893,822,989,0,208965.7,{"$f":"SUM(Q10:Q15,Q18:Q22,Q25:Q30,Q33:Q38)","v":212},{"$f":"SUM(R10:R15,R18:R22,R25:R30,R33:R38)","v":235},206,233,0,0,33821.409999999996,282971.11]