{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Cover","Kalkulation 1","Kalkulation 2","Kalkulation 3","Kalkulation Mittelwerte"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":22,"n_cols":3,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Excel + VBA"]
[]
[]
[]
[null,"Thema","3D-Bezug"]
[]
[null,"Inhalt","Preis-Kalkulation"]
[null,null,"3D Bezüge mit Zelladressen"]
[]
[]
[]
[]
[]
[]
[null,"Autor","Harald Nahrstedt"]
[null,"Datum","2023-11-29"]
[null,"Version","2023-03-01"]
[]
[]
[null,"Springer Vieweg Verlag"]

{"sheet":"Kalkulation 1","index":1,"n_rows":17,"n_cols":3,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[null,"Einzelkosten","%-Anteil"]
["Entwicklung",7800,{"$f":"B2/B$9","v":0.20051413881748073}]
["Material",6400,{"$f":"B3/B$9","v":0.16452442159383032}]
["Fertigung",7200,0.18508997429305912]
["Verwaltung",3400,8.7403598971722368E-2]
["Marketing",5900,0.15167095115681234]
["Vertrieb",8200,0.21079691516709512]
[]
["Gesamtkosten",{"$f":"SUM(B2:B7)","v":38900}]
[]
[]
["Stückzahl",100]
["Herstellpreis",{"$f":"B9/B12","v":389}]
["Gewinn",{"$f":"B13*C14","v":116.69999999999999},0.3]
["Nettopreis",{"$f":"B13+B14","v":505.7}]
["MWSteuer",96.08,0.19]
["Verkaufspreis",{"$f":"B15+B16","v":601.78}]

{"sheet":"Kalkulation 2","index":2,"n_rows":17,"n_cols":3,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[null,"Einzelkosten","%-Anteil"]
["Entwicklung",7200,{"$f":"B2/B$9","v":0.19889502762430938}]
["Material",6100,{"$f":"B3/B$9","v":0.16850828729281769}]
["Fertigung",6800,0.18784530386740331]
["Verwaltung",3100,8.5635359116022103E-2]
["Marketing",5400,0.14917127071823205]
["Vertrieb",7600,0.20994475138121546]
[]
["Gesamtkosten",{"$f":"SUM(B2:B7)","v":36200}]
[]
[]
["Stückzahl",100]
["Herstellpreis",{"$f":"B9/B12","v":362}]
["Gewinn",{"$f":"B13*C14","v":108.6},0.3]
["Nettopreis",{"$f":"B13+B14","v":470.6}]
["MWSteuer",96.08,0.19]
["Verkaufspreis",{"$f":"B15+B16","v":566.68000000000006}]

{"sheet":"Kalkulation 3","index":3,"n_rows":17,"n_cols":3,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[null,"Einzelkosten","%-Anteil"]
["Entwicklung",8200,{"$f":"B2/B$9","v":0.19902912621359223}]
["Material",6800,{"$f":"B3/B$9","v":0.1650485436893204}]
["Fertigung",7600,0.18446601941747573]
["Verwaltung",3800,9.2233009708737865E-2]
["Marketing",6300,0.15291262135922329]
["Vertrieb",8500,0.20631067961165048]
[]
["Gesamtkosten",{"$f":"SUM(B2:B7)","v":41200}]
[]
[]
["Stückzahl",100]
["Herstellpreis",{"$f":"B9/B12","v":412}]
["Gewinn",{"$f":"B13*C14","v":123.6},0.3]
["Nettopreis",{"$f":"B13+B14","v":535.6}]
["MWSteuer",96.08,0.19]
["Verkaufspreis",{"$f":"B15+B16","v":631.68000000000006}]

{"sheet":"Kalkulation Mittelwerte","index":4,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[null,"Einzelkosten","%-Anteil"]
["Entwicklung",{"$f":"MEK","v":7733.333333333333},{"$f":"B2/B$9","v":0.19948409286328461}]
["Material",{"$f":"MEK","v":6433.333333333333},{"$f":"B3/B$9","v":0.16595012897678418}]
["Fertigung",{"$f":"MEK","v":7200},0.18572656921754085]
["Verwaltung",{"$f":"MEK","v":3433.3333333333335},8.8564058469475501E-2]
["Marketing",{"$f":"MEK","v":5866.666666666667},0.15133276010318145]
["Vertrieb",{"$f":"MEK","v":8100},0.20894239036973347]
[]
["Gesamtkosten",{"$f":"SUM(B2:B7)","v":38766.666666666664}]