{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Cover","Produkte","Stundensätze"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":21,"n_cols":3,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"Die Welt der VBA-Objekte"]
[null,"3. Auflage"]
[]
[]
[null,"Kapitel","Excel Objekte"]
[null,null,"Excel Blätter"]
[]
[]
[null,"Inhalt","Tabellen-Objekte"]
[null,null,"Strukturierte Verweise"]
[null,null,"Beziehungen"]
[]
[null,"Version","1.0"]
[null,"Autor","Harald Nahrstedt"]
[null,"Datum","2025-03-01"]
[]
[]
[null,"Springer Vieweg Verlag"]

{"sheet":"Produkte","index":1,"n_rows":53,"n_cols":7,"rows_kept":53,"cut":false,"hidden":false,"merged":[]}
["Produkt","Bauteil","Anzahl","Std","Schnitt","Satz","Kosten"]
["A",1,7,3.5,{"$f":"Fertigung[[#This Row],[Std]] / Fertigung[[#This Row],[Anzahl]]","v":0.5},{"$f":"VLOOKUP(Fertigung[[#This Row],[Produkt]],Kosten[],2)","v":54.3},{"$f":"Fertigung[[#This Row],[Satz]]*Fertigung[[#This Row],[Std]]","v":190.04999999999998}]
["A",2,1,4.3,{"$f":"Fertigung[[#This Row],[Std]] / Fertigung[[#This Row],[Anzahl]]","v":4.3},{"$f":"VLOOKUP(Fertigung[[#This Row],[Produkt]],Kosten[],2)","v":54.3},{"$f":"Fertigung[[#This Row],[Satz]]*Fertigung[[#This Row],[Std]]","v":233.48999999999998}]
["A",1,4,2.5,{"$f":"Fertigung[[#This Row],[Std]] / Fertigung[[#This Row],[Anzahl]]","v":0.625},{"$f":"VLOOKUP(Fertigung[[#This Row],[Produkt]],Kosten[],2)","v":54.3},{"$f":"Fertigung[[#This Row],[Satz]]*Fertigung[[#This Row],[Std]]","v":135.75}]
["A",3,2,4.4000000000000004,{"$f":"Fertigung[[#This Row],[Std]] / Fertigung[[#This Row],[Anzahl]]","v":2.2000000000000002},{"$f":"VLOOKUP(Fertigung[[#This Row],[Produkt]],Kosten[],2)","v":54.3},{"$f":"Fertigung[[#This Row],[Satz]]*Fertigung[[#This Row],[Std]]","v":238.92000000000002}]
["A",4,1,6.9,{"$f":"Fertigung[[#This Row],[Std]] / Fertigung[[#This Row],[Anzahl]]","v":6.9},{"$f":"VLOOKUP(Fertigung[[#This Row],[Produkt]],Kosten[],2)","v":54.3},{"$f":"Fertigung[[#This Row],[Satz]]*Fertigung[[#This Row],[Std]]","v":374.67}]
["A",5,17,9.5,{"$f":"Fertigung[[#This Row],[Std]] / Fertigung[[#This Row],[Anzahl]]","v":0.55882352941176472},{"$f":"VLOOKUP(Fertigung[[#This Row],[Produkt]],Kosten[],2)","v":54.3},{"$f":"Fertigung[[#This Row],[Satz]]*Fertigung[[#This Row],[Std]]","v":515.85}]
["A",6,1,7.5,{"$f":"Fertigung[[#This Row],[Std]] / Fertigung[[#This Row],[Anzahl]]","v":7.5},{"$f":"VLOOKUP(Fertigung[[#This Row],[Produkt]],Kosten[],2)","v":54.3},{"$f":"Fertigung[[#This Row],[Satz]]*Fertigung[[#This Row],[Std]]","v":407.25}]
["A",7,7,4.8,{"$f":"Fertigung[[#This Row],[Std]] / Fertigung[[#This Row],[Anzahl]]","v":0.68571428571428572},{"$f":"VLOOKUP(Fertigung[[#This Row],[Produkt]],Kosten[],2)","v":54.3},{"$f":"Fertigung[[#This Row],[Satz]]*Fertigung[[#This Row],[Std]]","v":260.64}]
["A",8,19,1.4,{"$f":"Fertigung[[#This Row],[Std]] / Fertigung[[#This Row],[Anzahl]]","v":7.3684210526315783E-2},{"$f":"VLOOKUP(Fertigung[[#This Row],[Produkt]],Kosten[],2)","v":54.3},{"$f":"Fertigung[[#This Row],[Satz]]*Fertigung[[#This Row],[Std]]","v":76.02}]
["A",9,14,2.8,{"$f":"Fertigung[[#This Row],[Std]] / Fertigung[[#This Row],[Anzahl]]","v":0.19999999999999998},{"$f":"VLOOKUP(Fertigung[[#This Row],[Produkt]],Kosten[],2)","v":54.3},{"$f":"Fertigung[[#This Row],[Satz]]*Fertigung[[#This Row],[Std]]","v":152.04}]
["A",10,2,10.6,{"$f":"Fertigung[[#This Row],[Std]] / Fertigung[[#This Row],[Anzahl]]","v":5.3},{"$f":"VLOOKUP(Fertigung[[#This Row],[Produkt]],Kosten[],2)","v":54.3},{"$f":"Fertigung[[#This Row],[Satz]]*Fertigung[[#This Row],[Std]]","v":575.57999999999993}]
["A",11,3,5.9,{"$f":"Fertigung[[#This Row],[Std]] / Fertigung[[#This Row],[Anzahl]]","v":1.9666666666666668},{"$f":"VLOOKUP(Fertigung[[#This Row],[Produkt]],Kosten[],2)","v":54.3},{"$f":"Fertigung[[#This Row],[Satz]]*Fertigung[[#This Row],[Std]]","v":320.37}]
["A",12,17,18.7,{"$f":"Fertigung[[#This Row],[Std]] / Fertigung[[#This Row],[Anzahl]]","v":1.0999999999999999},{"$f":"VLOOKUP(Fertigung[[#This Row],[Produkt]],Kosten[],2)","v":54.3},{"$f":"Fertigung[[#This Row],[Satz]]*Fertigung[[#This Row],[Std]]","v":1015.4099999999999}]
["A",13,1,10.5,{"$f":"Fertigung[[#This Row],[Std]] / Fertigung[[#This Row],[Anzahl]]","v":10.5},{"$f":"VLOOKUP(Fertigung[[#This Row],[Produkt]],Kosten[],2)","v":54.3},{"$f":"Fertigung[[#This Row],[Satz]]*Fertigung[[#This Row],[Std]]","v":570.15}]
["A",14,2,17.899999999999999,{"$f":"Fertigung[[#This Row],[Std]] / Fertigung[[#This Row],[Anzahl]]","v":8.9499999999999993},{"$f":"VLOOKUP(Fertigung[[#This Row],[Produkt]],Kosten[],2)","v":54.3},{"$f":"Fertigung[[#This Row],[Satz]]*Fertigung[[#This Row],[Std]]","v":971.96999999999991}]
["A",15,9,3.8,{"$f":"Fertigung[[#This Row],[Std]] / Fertigung[[#This Row],[Anzahl]]","v":0.42222222222222222},{"$f":"VLOOKUP(Fertigung[[#This Row],[Produkt]],Kosten[],2)","v":54.3},{"$f":"Fertigung[[#This Row],[Satz]]*Fertigung[[#This Row],[Std]]","v":206.33999999999997}]
["B",1,17,2.4,{"$f":"Fertigung[[#This Row],[Std]] / Fertigung[[#This Row],[Anzahl]]","v":0.14117647058823529},{"$f":"VLOOKUP(Fertigung[[#This Row],[Produkt]],Kosten[],2)","v":60.2},{"$f":"Fertigung[[#This Row],[Satz]]*Fertigung[[#This Row],[Std]]","v":144.47999999999999}]
["B",2,19,6.7,{"$f":"Fertigung[[#This Row],[Std]] / Fertigung[[#This Row],[Anzahl]]","v":0.35263157894736841},{"$f":"VLOOKUP(Fertigung[[#This Row],[Produkt]],Kosten[],2)","v":60.2},{"$f":"Fertigung[[#This Row],[Satz]]*Fertigung[[#This Row],[Std]]","v":403.34000000000003}]
["B",3,1,10.6,{"$f":"Fertigung[[#This Row],[Std]] / Fertigung[[#This Row],[Anzahl]]","v":10.6},{"$f":"VLOOKUP(Fertigung[[#This Row],[Produkt]],Kosten[],2)","v":60.2},{"$f":"Fertigung[[#This Row],[Satz]]*Fertigung[[#This Row],[Std]]","v":638.12}]
["B",4,8,4.8,{"$f":"Fertigung[[#This Row],[Std]] / Fertigung[[#This Row],[Anzahl]]","v":0.6},{"$f":"VLOOKUP(Fertigung[[#This Row],[Produkt]],Kosten[],2)","v":60.2},{"$f":"Fertigung[[#This Row],[Satz]]*Fertigung[[#This Row],[Std]]","v":288.95999999999998}]
["B",5,14,2.2000000000000002,{"$f":"Fertigung[[#This Row],[Std]] / Fertigung[[#This Row],[Anzahl]]","v":0.15714285714285717},{"$f":"VLOOKUP(Fertigung[[#This Row],[Produkt]],Kosten[],2)","v":60.2},{"$f":"Fertigung[[#This Row],[Satz]]*Fertigung[[#This Row],[Std]]","v":132.44000000000003}]
["B",6,14,10.1,{"$f":"Fertigung[[#This Row],[Std]] / Fertigung[[#This Row],[Anzahl]]","v":0.72142857142857142},{"$f":"VLOOKUP(Fertigung[[#This Row],[Produkt]],Kosten[],2)","v":60.2},{"$f":"Fertigung[[#This Row],[Satz]]*Fertigung[[#This Row],[Std]]","v":608.02}]
["B",7,15,1.4,{"$f":"Fertigung[[#This Row],[Std]] / Fertigung[[#This Row],[Anzahl]]","v":9.3333333333333324E-2},{"$f":"VLOOKUP(Fertigung[[#This Row],[Produkt]],Kosten[],2)","v":60.2},{"$f":"Fertigung[[#This Row],[Satz]]*Fertigung[[#This Row],[Std]]","v":84.28}]
["C",1,2,2.2000000000000002,{"$f":"Fertigung[[#This Row],[Std]] / Fertigung[[#This Row],[Anzahl]]","v":1.1000000000000001},{"$f":"VLOOKUP(Fertigung[[#This Row],[Produkt]],Kosten[],2)","v":48.9},{"$f":"Fertigung[[#This Row],[Satz]]*Fertigung[[#This Row],[Std]]","v":107.58000000000001}]
["C",2,9,19.8,{"$f":"Fertigung[[#This Row],[Std]] / Fertigung[[#This Row],[Anzahl]]","v":2.2000000000000002},{"$f":"VLOOKUP(Fertigung[[#This Row],[Produkt]],Kosten[],2)","v":48.9},{"$f":"Fertigung[[#This Row],[Satz]]*Fertigung[[#This Row],[Std]]","v":968.22}]
["C",3,14,7.8,{"$f":"Fertigung[[#This Row],[Std]] / Fertigung[[#This Row],[Anzahl]]","v":0.55714285714285716},{"$f":"VLOOKUP(Fertigung[[#This Row],[Produkt]],Kosten[],2)","v":48.9},{"$f":"Fertigung[[#This Row],[Satz]]*Fertigung[[#This Row],[Std]]","v":381.41999999999996}]
["C",4,8,14.7,{"$f":"Fertigung[[#This Row],[Std]] / Fertigung[[#This Row],[Anzahl]]","v":1.8374999999999999},{"$f":"VLOOKUP(Fertigung[[#This Row],[Produkt]],Kosten[],2)","v":48.9},{"$f":"Fertigung[[#This Row],[Satz]]*Fertigung[[#This Row],[Std]]","v":718.82999999999993}]
["C",5,7,6.9,{"$f":"Fertigung[[#This Row],[Std]] / Fertigung[[#This Row],[Anzahl]]","v":0.98571428571428577},{"$f":"VLOOKUP(Fertigung[[#This Row],[Produkt]],Kosten[],2)","v":48.9},{"$f":"Fertigung[[#This Row],[Satz]]*Fertigung[[#This Row],[Std]]","v":337.41}]
["C",6,18,6.7,{"$f":"Fertigung[[#This Row],[Std]] / Fertigung[[#This Row],[Anzahl]]","v":0.37222222222222223},{"$f":"VLOOKUP(Fertigung[[#This Row],[Produkt]],Kosten[],2)","v":48.9},{"$f":"Fertigung[[#This Row],[Satz]]*Fertigung[[#This Row],[Std]]","v":327.63}]
["C",7,1,11.3,{"$f":"Fertigung[[#This Row],[Std]] / Fertigung[[#This Row],[Anzahl]]","v":11.3},{"$f":"VLOOKUP(Fertigung[[#This Row],[Produkt]],Kosten[],2)","v":48.9},{"$f":"Fertigung[[#This Row],[Satz]]*Fertigung[[#This Row],[Std]]","v":552.57000000000005}]
["C",8,13,11.3,{"$f":"Fertigung[[#This Row],[Std]] / Fertigung[[#This Row],[Anzahl]]","v":0.86923076923076925},{"$f":"VLOOKUP(Fertigung[[#This Row],[Produkt]],Kosten[],2)","v":48.9},{"$f":"Fertigung[[#This Row],[Satz]]*Fertigung[[#This Row],[Std]]","v":552.57000000000005}]
["C",9,8,4.7,{"$f":"Fertigung[[#This Row],[Std]] / Fertigung[[#This Row],[Anzahl]]","v":0.58750000000000002},{"$f":"VLOOKUP(Fertigung[[#This Row],[Produkt]],Kosten[],2)","v":48.9},{"$f":"Fertigung[[#This Row],[Satz]]*Fertigung[[#This Row],[Std]]","v":229.83}]
["C",10,4,11.9,{"$f":"Fertigung[[#This Row],[Std]] / Fertigung[[#This Row],[Anzahl]]","v":2.9750000000000001},{"$f":"VLOOKUP(Fertigung[[#This Row],[Produkt]],Kosten[],2)","v":48.9},{"$f":"Fertigung[[#This Row],[Satz]]*Fertigung[[#This Row],[Std]]","v":581.91}]
["C",11,6,2.6,{"$f":"Fertigung[[#This Row],[Std]] / Fertigung[[#This Row],[Anzahl]]","v":0.43333333333333335},{"$f":"VLOOKUP(Fertigung[[#This Row],[Produkt]],Kosten[],2)","v":48.9},{"$f":"Fertigung[[#This Row],[Satz]]*Fertigung[[#This Row],[Std]]","v":127.14}]
["D",1,1,4.8,{"$f":"Fertigung[[#This Row],[Std]] / Fertigung[[#This Row],[Anzahl]]","v":4.8},{"$f":"VLOOKUP(Fertigung[[#This Row],[Produkt]],Kosten[],2)","v":33.700000000000003},{"$f":"Fertigung[[#This Row],[Satz]]*Fertigung[[#This Row],[Std]]","v":161.76000000000002}]
["D",2,2,5,{"$f":"Fertigung[[#This Row],[Std]] / Fertigung[[#This Row],[Anzahl]]","v":2.5},{"$f":"VLOOKUP(Fertigung[[#This Row],[Produkt]],Kosten[],2)","v":33.700000000000003},{"$f":"Fertigung[[#This Row],[Satz]]*Fertigung[[#This Row],[Std]]","v":168.5}]
["D",3,1,18.2,{"$f":"Fertigung[[#This Row],[Std]] / Fertigung[[#This Row],[Anzahl]]","v":18.2},{"$f":"VLOOKUP(Fertigung[[#This Row],[Produkt]],Kosten[],2)","v":33.700000000000003},{"$f":"Fertigung[[#This Row],[Satz]]*Fertigung[[#This Row],[Std]]","v":613.34}]
["D",4,18,9,{"$f":"Fertigung[[#This Row],[Std]] / Fertigung[[#This Row],[Anzahl]]","v":0.5},{"$f":"VLOOKUP(Fertigung[[#This Row],[Produkt]],Kosten[],2)","v":33.700000000000003},{"$f":"Fertigung[[#This Row],[Satz]]*Fertigung[[#This Row],[Std]]","v":303.3}]
["D",5,3,11.3,{"$f":"Fertigung[[#This Row],[Std]] / Fertigung[[#This Row],[Anzahl]]","v":3.7666666666666671},{"$f":"VLOOKUP(Fertigung[[#This Row],[Produkt]],Kosten[],2)","v":33.700000000000003},{"$f":"Fertigung[[#This Row],[Satz]]*Fertigung[[#This Row],[Std]]","v":380.81000000000006}]
["D",6,11,10.5,{"$f":"Fertigung[[#This Row],[Std]] / Fertigung[[#This Row],[Anzahl]]","v":0.95454545454545459},{"$f":"VLOOKUP(Fertigung[[#This Row],[Produkt]],Kosten[],2)","v":33.700000000000003},{"$f":"Fertigung[[#This Row],[Satz]]*Fertigung[[#This Row],[Std]]","v":353.85}]
["E",1,15,12.6,{"$f":"Fertigung[[#This Row],[Std]] / Fertigung[[#This Row],[Anzahl]]","v":0.84},{"$f":"VLOOKUP(Fertigung[[#This Row],[Produkt]],Kosten[],2)","v":72.099999999999994},{"$f":"Fertigung[[#This Row],[Satz]]*Fertigung[[#This Row],[Std]]","v":908.45999999999992}]
["E",2,4,3.1,{"$f":"Fertigung[[#This Row],[Std]] / Fertigung[[#This Row],[Anzahl]]","v":0.77500000000000002},{"$f":"VLOOKUP(Fertigung[[#This Row],[Produkt]],Kosten[],2)","v":72.099999999999994},{"$f":"Fertigung[[#This Row],[Satz]]*Fertigung[[#This Row],[Std]]","v":223.51}]
["E",3,15,19.2,{"$f":"Fertigung[[#This Row],[Std]] / Fertigung[[#This Row],[Anzahl]]","v":1.28},{"$f":"VLOOKUP(Fertigung[[#This Row],[Produkt]],Kosten[],2)","v":72.099999999999994},{"$f":"Fertigung[[#This Row],[Satz]]*Fertigung[[#This Row],[Std]]","v":1384.32}]
["E",4,20,6.5,{"$f":"Fertigung[[#This Row],[Std]] / Fertigung[[#This Row],[Anzahl]]","v":0.32500000000000001},{"$f":"VLOOKUP(Fertigung[[#This Row],[Produkt]],Kosten[],2)","v":72.099999999999994},{"$f":"Fertigung[[#This Row],[Satz]]*Fertigung[[#This Row],[Std]]","v":468.65}]
["E",5,1,0.8,{"$f":"Fertigung[[#This Row],[Std]] / Fertigung[[#This Row],[Anzahl]]","v":0.8},{"$f":"VLOOKUP(Fertigung[[#This Row],[Produkt]],Kosten[],2)","v":72.099999999999994},{"$f":"Fertigung[[#This Row],[Satz]]*Fertigung[[#This Row],[Std]]","v":57.68}]
["E",6,11,12.8,{"$f":"Fertigung[[#This Row],[Std]] / Fertigung[[#This Row],[Anzahl]]","v":1.1636363636363638},{"$f":"VLOOKUP(Fertigung[[#This Row],[Produkt]],Kosten[],2)","v":72.099999999999994},{"$f":"Fertigung[[#This Row],[Satz]]*Fertigung[[#This Row],[Std]]","v":922.88}]
["E",7,9,15.1,{"$f":"Fertigung[[#This Row],[Std]] / Fertigung[[#This Row],[Anzahl]]","v":1.6777777777777778},{"$f":"VLOOKUP(Fertigung[[#This Row],[Produkt]],Kosten[],2)","v":72.099999999999994},{"$f":"Fertigung[[#This Row],[Satz]]*Fertigung[[#This Row],[Std]]","v":1088.7099999999998}]
["E",8,6,9.3000000000000007,{"$f":"Fertigung[[#This Row],[Std]] / Fertigung[[#This Row],[Anzahl]]","v":1.55},{"$f":"VLOOKUP(Fertigung[[#This Row],[Produkt]],Kosten[],2)","v":72.099999999999994},{"$f":"Fertigung[[#This Row],[Satz]]*Fertigung[[#This Row],[Std]]","v":670.53}]
["E",9,12,16,{"$f":"Fertigung[[#This Row],[Std]] / Fertigung[[#This Row],[Anzahl]]","v":1.3333333333333333},{"$f":"VLOOKUP(Fertigung[[#This Row],[Produkt]],Kosten[],2)","v":72.099999999999994},{"$f":"Fertigung[[#This Row],[Satz]]*Fertigung[[#This Row],[Std]]","v":1153.5999999999999}]
["E",10,9,6.9,{"$f":"Fertigung[[#This Row],[Std]] / Fertigung[[#This Row],[Anzahl]]","v":0.76666666666666672},{"$f":"VLOOKUP(Fertigung[[#This Row],[Produkt]],Kosten[],2)","v":72.099999999999994},{"$f":"Fertigung[[#This Row],[Satz]]*Fertigung[[#This Row],[Std]]","v":497.49}]
["E",11,6,5.7,{"$f":"Fertigung[[#This Row],[Std]] / Fertigung[[#This Row],[Anzahl]]","v":0.95000000000000007},{"$f":"VLOOKUP(Fertigung[[#This Row],[Produkt]],Kosten[],2)","v":72.099999999999994},{"$f":"Fertigung[[#This Row],[Satz]]*Fertigung[[#This Row],[Std]]","v":410.96999999999997}]
[{"$f":"SUBTOTAL(103,Fertigung[Produkt])","v":51},{"$f":"SUBTOTAL(104,Fertigung[Bauteil])","v":15},{"$f":"SUBTOTAL(101,Fertigung[Anzahl])","v":8.4117647058823533},{"$f":"SUBTOTAL(101,Fertigung[Std])","v":8.2333333333333343},{"$f":"SUBTOTAL(101,Fertigung[Schnitt])","v":2.5460410481617912},{"$f":"SUBTOTAL(101,Fertigung[Satz])","v":55.360784313725503},{"$f":"SUBTOTAL(109,Fertigung[Kosten])","v":23197.609999999997}]

{"sheet":"Stundensätze","index":2,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Produkt","Satz"]
["A",54.3]
["B",60.2]
["C",48.9]
["D",33.700000000000003]
["E",72.099999999999994]