{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Cover","Personalkosten","Tabelle1","Maschinenkosten"],"not_rendered":{"charts":0,"images":0,"macros":0,"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":23,"n_cols":3,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Excel + VBA "]
[null,"für Controller"]
[]
[]
[null,"Kapitel",4]
[null,"Thema","Methoden der Datenaufbereitung"]
[]
[null,"Inhalt","SVERWEIS + WAHL"]
[null,null,"Zusammenstellung von Daten"]
[null,null,"mit SVERWEIS + WAHL"]
[]
[]
[]
[]
[]
[null,"Autor","Harald Nahrstedt"]
[null,"Datum","2019-01-01"]
[null,"Version","1.0"]
[]
[]
[null,"Springer Verlag"]

{"sheet":"Personalkosten","index":1,"n_rows":52,"n_cols":11,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
["Produkt","Bauteil","Anzahl","Std","Lohn","MNr","WNr","MSatz","LKosten","MKosten","GKosten"]
["A",1,7,3.5,29.8,6,1,{"$f":"VLOOKUP(Personalkosten!$F2&Personalkosten!$G2,CHOOSE({1,2},Maschinen[MNr]&Maschinen[WNr],Maschinen[Stundensatz]),2,0)","v":41.28},{"$f":"Tabelle1[Std]*Tabelle1[Lohn]","v":104.3},{"$f":"Tabelle1[Std]*Tabelle1[MSatz]","v":144.48000000000002},{"$f":"Tabelle1[LKosten]+Tabelle1[MKosten]","v":248.78000000000003}]
["A",2,1,4.3,69.52,1,2,{"$f":"VLOOKUP(Personalkosten!$F3&Personalkosten!$G3,CHOOSE({1,2},Maschinen[MNr]&Maschinen[WNr],Maschinen[Stundensatz]),2,0)","v":33.520000000000003},{"$f":"Tabelle1[Std]*Tabelle1[Lohn]","v":298.93599999999998},{"$f":"Tabelle1[Std]*Tabelle1[MSatz]","v":144.136},{"$f":"Tabelle1[LKosten]+Tabelle1[MKosten]","v":443.072}]
["A",1,4,2.5,27.45,5,2,{"$f":"VLOOKUP(Personalkosten!$F4&Personalkosten!$G4,CHOOSE({1,2},Maschinen[MNr]&Maschinen[WNr],Maschinen[Stundensatz]),2,0)","v":36.450000000000003},{"$f":"Tabelle1[Std]*Tabelle1[Lohn]","v":68.625},{"$f":"Tabelle1[Std]*Tabelle1[MSatz]","v":91.125},{"$f":"Tabelle1[LKosten]+Tabelle1[MKosten]","v":159.75}]
["A",3,2,4.4000000000000004,76.31,14,1,{"$f":"VLOOKUP(Personalkosten!$F5&Personalkosten!$G5,CHOOSE({1,2},Maschinen[MNr]&Maschinen[WNr],Maschinen[Stundensatz]),2,0)","v":53.4},{"$f":"Tabelle1[Std]*Tabelle1[Lohn]","v":335.76400000000001},{"$f":"Tabelle1[Std]*Tabelle1[MSatz]","v":234.96},{"$f":"Tabelle1[LKosten]+Tabelle1[MKosten]","v":570.72400000000005}]
["A",4,0,6.9,57.09,16,2,{"$f":"VLOOKUP(Personalkosten!$F6&Personalkosten!$G6,CHOOSE({1,2},Maschinen[MNr]&Maschinen[WNr],Maschinen[Stundensatz]),2,0)","v":31.27},{"$f":"Tabelle1[Std]*Tabelle1[Lohn]","v":393.92100000000005},{"$f":"Tabelle1[Std]*Tabelle1[MSatz]","v":215.76300000000001},{"$f":"Tabelle1[LKosten]+Tabelle1[MKosten]","v":609.68400000000008}]
["A",5,17,9.5,85.88,16,2,{"$f":"VLOOKUP(Personalkosten!$F7&Personalkosten!$G7,CHOOSE({1,2},Maschinen[MNr]&Maschinen[WNr],Maschinen[Stundensatz]),2,0)","v":31.27},{"$f":"Tabelle1[Std]*Tabelle1[Lohn]","v":815.8599999999999},{"$f":"Tabelle1[Std]*Tabelle1[MSatz]","v":297.065},{"$f":"Tabelle1[LKosten]+Tabelle1[MKosten]","v":1112.925}]
["A",6,1,7.5,79.510000000000005,1,1,{"$f":"VLOOKUP(Personalkosten!$F8&Personalkosten!$G8,CHOOSE({1,2},Maschinen[MNr]&Maschinen[WNr],Maschinen[Stundensatz]),2,0)","v":31.25},{"$f":"Tabelle1[Std]*Tabelle1[Lohn]","v":596.32500000000005},{"$f":"Tabelle1[Std]*Tabelle1[MSatz]","v":234.375},{"$f":"Tabelle1[LKosten]+Tabelle1[MKosten]","v":830.7}]
["A",7,7,4.8,86.93,15,1,{"$f":"VLOOKUP(Personalkosten!$F9&Personalkosten!$G9,CHOOSE({1,2},Maschinen[MNr]&Maschinen[WNr],Maschinen[Stundensatz]),2,0)","v":50.73},{"$f":"Tabelle1[Std]*Tabelle1[Lohn]","v":417.26400000000001},{"$f":"Tabelle1[Std]*Tabelle1[MSatz]","v":243.50399999999996},{"$f":"Tabelle1[LKosten]+Tabelle1[MKosten]","v":660.76800000000003}]
["A",8,19,1.4,27.68,15,1,{"$f":"VLOOKUP(Personalkosten!$F10&Personalkosten!$G10,CHOOSE({1,2},Maschinen[MNr]&Maschinen[WNr],Maschinen[Stundensatz]),2,0)","v":50.73},{"$f":"Tabelle1[Std]*Tabelle1[Lohn]","v":38.751999999999995},{"$f":"Tabelle1[Std]*Tabelle1[MSatz]","v":71.021999999999991},{"$f":"Tabelle1[LKosten]+Tabelle1[MKosten]","v":109.77399999999999}]
["A",9,14,2.8,9.2200000000000006,14,2,{"$f":"VLOOKUP(Personalkosten!$F11&Personalkosten!$G11,CHOOSE({1,2},Maschinen[MNr]&Maschinen[WNr],Maschinen[Stundensatz]),2,0)","v":55.79},{"$f":"Tabelle1[Std]*Tabelle1[Lohn]","v":25.815999999999999},{"$f":"Tabelle1[Std]*Tabelle1[MSatz]","v":156.21199999999999},{"$f":"Tabelle1[LKosten]+Tabelle1[MKosten]","v":182.02799999999999}]
["A",10,2,10.6,57.02,9,1,{"$f":"VLOOKUP(Personalkosten!$F12&Personalkosten!$G12,CHOOSE({1,2},Maschinen[MNr]&Maschinen[WNr],Maschinen[Stundensatz]),2,0)","v":58.17},{"$f":"Tabelle1[Std]*Tabelle1[Lohn]","v":604.41200000000003},{"$f":"Tabelle1[Std]*Tabelle1[MSatz]","v":616.60199999999998},{"$f":"Tabelle1[LKosten]+Tabelle1[MKosten]","v":1221.0140000000001}]
["A",11,3,5.9,98.69,1,2,{"$f":"VLOOKUP(Personalkosten!$F13&Personalkosten!$G13,CHOOSE({1,2},Maschinen[MNr]&Maschinen[WNr],Maschinen[Stundensatz]),2,0)","v":33.520000000000003},{"$f":"Tabelle1[Std]*Tabelle1[Lohn]","v":582.27100000000007},{"$f":"Tabelle1[Std]*Tabelle1[MSatz]","v":197.76800000000003},{"$f":"Tabelle1[LKosten]+Tabelle1[MKosten]","v":780.0390000000001}]
["A",12,17,18.7,37.25,17,1,{"$f":"VLOOKUP(Personalkosten!$F14&Personalkosten!$G14,CHOOSE({1,2},Maschinen[MNr]&Maschinen[WNr],Maschinen[Stundensatz]),2,0)","v":33.869999999999997},{"$f":"Tabelle1[Std]*Tabelle1[Lohn]","v":696.57499999999993},{"$f":"Tabelle1[Std]*Tabelle1[MSatz]","v":633.36899999999991},{"$f":"Tabelle1[LKosten]+Tabelle1[MKosten]","v":1329.944}]
["A",13,1,10.5,21.45,8,2,{"$f":"VLOOKUP(Personalkosten!$F15&Personalkosten!$G15,CHOOSE({1,2},Maschinen[MNr]&Maschinen[WNr],Maschinen[Stundensatz]),2,0)","v":59.83},{"$f":"Tabelle1[Std]*Tabelle1[Lohn]","v":225.22499999999999},{"$f":"Tabelle1[Std]*Tabelle1[MSatz]","v":628.21500000000003},{"$f":"Tabelle1[LKosten]+Tabelle1[MKosten]","v":853.44}]
["A",14,2,17.899999999999999,1.57,18,1,{"$f":"VLOOKUP(Personalkosten!$F16&Personalkosten!$G16,CHOOSE({1,2},Maschinen[MNr]&Maschinen[WNr],Maschinen[Stundensatz]),2,0)","v":62.29},{"$f":"Tabelle1[Std]*Tabelle1[Lohn]","v":28.102999999999998},{"$f":"Tabelle1[Std]*Tabelle1[MSatz]","v":1114.991},{"$f":"Tabelle1[LKosten]+Tabelle1[MKosten]","v":1143.0940000000001}]
["A",15,9,3.8,2.39,5,1,{"$f":"VLOOKUP(Personalkosten!$F17&Personalkosten!$G17,CHOOSE({1,2},Maschinen[MNr]&Maschinen[WNr],Maschinen[Stundensatz]),2,0)","v":39.96},{"$f":"Tabelle1[Std]*Tabelle1[Lohn]","v":9.0820000000000007},{"$f":"Tabelle1[Std]*Tabelle1[MSatz]","v":151.84799999999998},{"$f":"Tabelle1[LKosten]+Tabelle1[MKosten]","v":160.92999999999998}]
["B",1,17,2.4,96.02,9,2,{"$f":"VLOOKUP(Personalkosten!$F18&Personalkosten!$G18,CHOOSE({1,2},Maschinen[MNr]&Maschinen[WNr],Maschinen[Stundensatz]),2,0)","v":55.76},{"$f":"Tabelle1[Std]*Tabelle1[Lohn]","v":230.44799999999998},{"$f":"Tabelle1[Std]*Tabelle1[MSatz]","v":133.82399999999998},{"$f":"Tabelle1[LKosten]+Tabelle1[MKosten]","v":364.27199999999993}]
["B",2,19,6.7,51.6,12,2,{"$f":"VLOOKUP(Personalkosten!$F19&Personalkosten!$G19,CHOOSE({1,2},Maschinen[MNr]&Maschinen[WNr],Maschinen[Stundensatz]),2,0)","v":45.87},{"$f":"Tabelle1[Std]*Tabelle1[Lohn]","v":345.72},{"$f":"Tabelle1[Std]*Tabelle1[MSatz]","v":307.32900000000001},{"$f":"Tabelle1[LKosten]+Tabelle1[MKosten]","v":653.04899999999998}]
["B",3,0,10.6,20.37,6,1,{"$f":"VLOOKUP(Personalkosten!$F20&Personalkosten!$G20,CHOOSE({1,2},Maschinen[MNr]&Maschinen[WNr],Maschinen[Stundensatz]),2,0)","v":41.28},{"$f":"Tabelle1[Std]*Tabelle1[Lohn]","v":215.922},{"$f":"Tabelle1[Std]*Tabelle1[MSatz]","v":437.56799999999998},{"$f":"Tabelle1[LKosten]+Tabelle1[MKosten]","v":653.49}]
["B",4,8,4.8,29.28,2,2,{"$f":"VLOOKUP(Personalkosten!$F21&Personalkosten!$G21,CHOOSE({1,2},Maschinen[MNr]&Maschinen[WNr],Maschinen[Stundensatz]),2,0)","v":44.64},{"$f":"Tabelle1[Std]*Tabelle1[Lohn]","v":140.54400000000001},{"$f":"Tabelle1[Std]*Tabelle1[MSatz]","v":214.27199999999999},{"$f":"Tabelle1[LKosten]+Tabelle1[MKosten]","v":354.81600000000003}]
["B",5,14,2.2000000000000002,16.38,7,1,{"$f":"VLOOKUP(Personalkosten!$F22&Personalkosten!$G22,CHOOSE({1,2},Maschinen[MNr]&Maschinen[WNr],Maschinen[Stundensatz]),2,0)","v":21.42},{"$f":"Tabelle1[Std]*Tabelle1[Lohn]","v":36.036000000000001},{"$f":"Tabelle1[Std]*Tabelle1[MSatz]","v":47.124000000000009},{"$f":"Tabelle1[LKosten]+Tabelle1[MKosten]","v":83.160000000000011}]
["B",6,14,10.1,87.71,9,2,{"$f":"VLOOKUP(Personalkosten!$F23&Personalkosten!$G23,CHOOSE({1,2},Maschinen[MNr]&Maschinen[WNr],Maschinen[Stundensatz]),2,0)","v":55.76},{"$f":"Tabelle1[Std]*Tabelle1[Lohn]","v":885.87099999999987},{"$f":"Tabelle1[Std]*Tabelle1[MSatz]","v":563.17599999999993},{"$f":"Tabelle1[LKosten]+Tabelle1[MKosten]","v":1449.0469999999998}]
["B",7,15,1.4,77.64,13,1,{"$f":"VLOOKUP(Personalkosten!$F24&Personalkosten!$G24,CHOOSE({1,2},Maschinen[MNr]&Maschinen[WNr],Maschinen[Stundensatz]),2,0)","v":53.76},{"$f":"Tabelle1[Std]*Tabelle1[Lohn]","v":108.696},{"$f":"Tabelle1[Std]*Tabelle1[MSatz]","v":75.263999999999996},{"$f":"Tabelle1[LKosten]+Tabelle1[MKosten]","v":183.95999999999998}]
["C",1,2,2.2000000000000002,13.07,17,1,{"$f":"VLOOKUP(Personalkosten!$F25&Personalkosten!$G25,CHOOSE({1,2},Maschinen[MNr]&Maschinen[WNr],Maschinen[Stundensatz]),2,0)","v":33.869999999999997},{"$f":"Tabelle1[Std]*Tabelle1[Lohn]","v":28.754000000000001},{"$f":"Tabelle1[Std]*Tabelle1[MSatz]","v":74.513999999999996},{"$f":"Tabelle1[LKosten]+Tabelle1[MKosten]","v":103.268}]
["C",2,9,19.8,29.82,11,2,{"$f":"VLOOKUP(Personalkosten!$F26&Personalkosten!$G26,CHOOSE({1,2},Maschinen[MNr]&Maschinen[WNr],Maschinen[Stundensatz]),2,0)","v":34.56},{"$f":"Tabelle1[Std]*Tabelle1[Lohn]","v":590.43600000000004},{"$f":"Tabelle1[Std]*Tabelle1[MSatz]","v":684.28800000000012},{"$f":"Tabelle1[LKosten]+Tabelle1[MKosten]","v":1274.7240000000002}]
["C",3,14,7.8,47.73,3,2,{"$f":"VLOOKUP(Personalkosten!$F27&Personalkosten!$G27,CHOOSE({1,2},Maschinen[MNr]&Maschinen[WNr],Maschinen[Stundensatz]),2,0)","v":71.23},{"$f":"Tabelle1[Std]*Tabelle1[Lohn]","v":372.29399999999998},{"$f":"Tabelle1[Std]*Tabelle1[MSatz]","v":555.59400000000005},{"$f":"Tabelle1[LKosten]+Tabelle1[MKosten]","v":927.88800000000003}]
["C",4,8,14.7,13.95,13,2,{"$f":"VLOOKUP(Personalkosten!$F28&Personalkosten!$G28,CHOOSE({1,2},Maschinen[MNr]&Maschinen[WNr],Maschinen[Stundensatz]),2,0)","v":53.21},{"$f":"Tabelle1[Std]*Tabelle1[Lohn]","v":205.06499999999997},{"$f":"Tabelle1[Std]*Tabelle1[MSatz]","v":782.18700000000001},{"$f":"Tabelle1[LKosten]+Tabelle1[MKosten]","v":987.25199999999995}]
["C",5,7,6.9,79.97,5,2,{"$f":"VLOOKUP(Personalkosten!$F29&Personalkosten!$G29,CHOOSE({1,2},Maschinen[MNr]&Maschinen[WNr],Maschinen[Stundensatz]),2,0)","v":36.450000000000003},{"$f":"Tabelle1[Std]*Tabelle1[Lohn]","v":551.79300000000001},{"$f":"Tabelle1[Std]*Tabelle1[MSatz]","v":251.50500000000002},{"$f":"Tabelle1[LKosten]+Tabelle1[MKosten]","v":803.298}]
["C",6,18,6.7,27.53,14,1,{"$f":"VLOOKUP(Personalkosten!$F30&Personalkosten!$G30,CHOOSE({1,2},Maschinen[MNr]&Maschinen[WNr],Maschinen[Stundensatz]),2,0)","v":53.4},{"$f":"Tabelle1[Std]*Tabelle1[Lohn]","v":184.45100000000002},{"$f":"Tabelle1[Std]*Tabelle1[MSatz]","v":357.78},{"$f":"Tabelle1[LKosten]+Tabelle1[MKosten]","v":542.23099999999999}]
["C",7,0,11.3,70.7,3,1,{"$f":"VLOOKUP(Personalkosten!$F31&Personalkosten!$G31,CHOOSE({1,2},Maschinen[MNr]&Maschinen[WNr],Maschinen[Stundensatz]),2,0)","v":69.87},{"$f":"Tabelle1[Std]*Tabelle1[Lohn]","v":798.91000000000008},{"$f":"Tabelle1[Std]*Tabelle1[MSatz]","v":789.53100000000006},{"$f":"Tabelle1[LKosten]+Tabelle1[MKosten]","v":1588.4410000000003}]
["C",8,13,11.3,87.97,12,2,{"$f":"VLOOKUP(Personalkosten!$F32&Personalkosten!$G32,CHOOSE({1,2},Maschinen[MNr]&Maschinen[WNr],Maschinen[Stundensatz]),2,0)","v":45.87},{"$f":"Tabelle1[Std]*Tabelle1[Lohn]","v":994.06100000000004},{"$f":"Tabelle1[Std]*Tabelle1[MSatz]","v":518.33100000000002},{"$f":"Tabelle1[LKosten]+Tabelle1[MKosten]","v":1512.3920000000001}]
["C",9,8,4.7,28.97,18,1,{"$f":"VLOOKUP(Personalkosten!$F33&Personalkosten!$G33,CHOOSE({1,2},Maschinen[MNr]&Maschinen[WNr],Maschinen[Stundensatz]),2,0)","v":62.29},{"$f":"Tabelle1[Std]*Tabelle1[Lohn]","v":136.15899999999999},{"$f":"Tabelle1[Std]*Tabelle1[MSatz]","v":292.76300000000003},{"$f":"Tabelle1[LKosten]+Tabelle1[MKosten]","v":428.92200000000003}]
["C",10,4,11.9,58.61,13,2,{"$f":"VLOOKUP(Personalkosten!$F34&Personalkosten!$G34,CHOOSE({1,2},Maschinen[MNr]&Maschinen[WNr],Maschinen[Stundensatz]),2,0)","v":53.21},{"$f":"Tabelle1[Std]*Tabelle1[Lohn]","v":697.45900000000006},{"$f":"Tabelle1[Std]*Tabelle1[MSatz]","v":633.19900000000007},{"$f":"Tabelle1[LKosten]+Tabelle1[MKosten]","v":1330.6580000000001}]
["C",11,6,2.6,21.31,16,2,{"$f":"VLOOKUP(Personalkosten!$F35&Personalkosten!$G35,CHOOSE({1,2},Maschinen[MNr]&Maschinen[WNr],Maschinen[Stundensatz]),2,0)","v":31.27},{"$f":"Tabelle1[Std]*Tabelle1[Lohn]","v":55.405999999999999},{"$f":"Tabelle1[Std]*Tabelle1[MSatz]","v":81.302000000000007},{"$f":"Tabelle1[LKosten]+Tabelle1[MKosten]","v":136.708}]
["D",1,1,4.8,19.5,1,1,{"$f":"VLOOKUP(Personalkosten!$F36&Personalkosten!$G36,CHOOSE({1,2},Maschinen[MNr]&Maschinen[WNr],Maschinen[Stundensatz]),2,0)","v":31.25},{"$f":"Tabelle1[Std]*Tabelle1[Lohn]","v":93.6},{"$f":"Tabelle1[Std]*Tabelle1[MSatz]","v":150},{"$f":"Tabelle1[LKosten]+Tabelle1[MKosten]","v":243.6}]
["D",2,2,5,12.95,15,1,{"$f":"VLOOKUP(Personalkosten!$F37&Personalkosten!$G37,CHOOSE({1,2},Maschinen[MNr]&Maschinen[WNr],Maschinen[Stundensatz]),2,0)","v":50.73},{"$f":"Tabelle1[Std]*Tabelle1[Lohn]","v":64.75},{"$f":"Tabelle1[Std]*Tabelle1[MSatz]","v":253.64999999999998},{"$f":"Tabelle1[LKosten]+Tabelle1[MKosten]","v":318.39999999999998}]
["D",3,1,18.2,99.01,6,1,{"$f":"VLOOKUP(Personalkosten!$F38&Personalkosten!$G38,CHOOSE({1,2},Maschinen[MNr]&Maschinen[WNr],Maschinen[Stundensatz]),2,0)","v":41.28},{"$f":"Tabelle1[Std]*Tabelle1[Lohn]","v":1801.982},{"$f":"Tabelle1[Std]*Tabelle1[MSatz]","v":751.29599999999994},{"$f":"Tabelle1[LKosten]+Tabelle1[MKosten]","v":2553.2779999999998}]
["D",4,18,9,57.26,13,2,{"$f":"VLOOKUP(Personalkosten!$F39&Personalkosten!$G39,CHOOSE({1,2},Maschinen[MNr]&Maschinen[WNr],Maschinen[Stundensatz]),2,0)","v":53.21},{"$f":"Tabelle1[Std]*Tabelle1[Lohn]","v":515.34},{"$f":"Tabelle1[Std]*Tabelle1[MSatz]","v":478.89},{"$f":"Tabelle1[LKosten]+Tabelle1[MKosten]","v":994.23}]
["D",5,3,11.3,57.83,18,1,{"$f":"VLOOKUP(Personalkosten!$F40&Personalkosten!$G40,CHOOSE({1,2},Maschinen[MNr]&Maschinen[WNr],Maschinen[Stundensatz]),2,0)","v":62.29},{"$f":"Tabelle1[Std]*Tabelle1[Lohn]","v":653.47900000000004},{"$f":"Tabelle1[Std]*Tabelle1[MSatz]","v":703.87700000000007},{"$f":"Tabelle1[LKosten]+Tabelle1[MKosten]","v":1357.3560000000002}]
["D",6,11,10.5,5.8,8,2,{"$f":"VLOOKUP(Personalkosten!$F41&Personalkosten!$G41,CHOOSE({1,2},Maschinen[MNr]&Maschinen[WNr],Maschinen[Stundensatz]),2,0)","v":59.83},{"$f":"Tabelle1[Std]*Tabelle1[Lohn]","v":60.9},{"$f":"Tabelle1[Std]*Tabelle1[MSatz]","v":628.21500000000003},{"$f":"Tabelle1[LKosten]+Tabelle1[MKosten]","v":689.11500000000001}]
["E",1,15,12.6,59.56,1,2,{"$f":"VLOOKUP(Personalkosten!$F42&Personalkosten!$G42,CHOOSE({1,2},Maschinen[MNr]&Maschinen[WNr],Maschinen[Stundensatz]),2,0)","v":33.520000000000003},{"$f":"Tabelle1[Std]*Tabelle1[Lohn]","v":750.45600000000002},{"$f":"Tabelle1[Std]*Tabelle1[MSatz]","v":422.35200000000003},{"$f":"Tabelle1[LKosten]+Tabelle1[MKosten]","v":1172.808}]
["E",2,4,3.1,71,2,1,{"$f":"VLOOKUP(Personalkosten!$F43&Personalkosten!$G43,CHOOSE({1,2},Maschinen[MNr]&Maschinen[WNr],Maschinen[Stundensatz]),2,0)","v":45.77},{"$f":"Tabelle1[Std]*Tabelle1[Lohn]","v":220.1},{"$f":"Tabelle1[Std]*Tabelle1[MSatz]","v":141.887},{"$f":"Tabelle1[LKosten]+Tabelle1[MKosten]","v":361.98699999999997}]
["E",3,15,19.2,78.84,19,2,{"$f":"VLOOKUP(Personalkosten!$F44&Personalkosten!$G44,CHOOSE({1,2},Maschinen[MNr]&Maschinen[WNr],Maschinen[Stundensatz]),2,0)","v":53.12},{"$f":"Tabelle1[Std]*Tabelle1[Lohn]","v":1513.7280000000001},{"$f":"Tabelle1[Std]*Tabelle1[MSatz]","v":1019.9039999999999},{"$f":"Tabelle1[LKosten]+Tabelle1[MKosten]","v":2533.6320000000001}]
["E",4,20,6.5,50.5,12,2,{"$f":"VLOOKUP(Personalkosten!$F45&Personalkosten!$G45,CHOOSE({1,2},Maschinen[MNr]&Maschinen[WNr],Maschinen[Stundensatz]),2,0)","v":45.87},{"$f":"Tabelle1[Std]*Tabelle1[Lohn]","v":328.25},{"$f":"Tabelle1[Std]*Tabelle1[MSatz]","v":298.15499999999997},{"$f":"Tabelle1[LKosten]+Tabelle1[MKosten]","v":626.40499999999997}]
["E",5,0,0.8,40.619999999999997,15,2,{"$f":"VLOOKUP(Personalkosten!$F46&Personalkosten!$G46,CHOOSE({1,2},Maschinen[MNr]&Maschinen[WNr],Maschinen[Stundensatz]),2,0)","v":49.88},{"$f":"Tabelle1[Std]*Tabelle1[Lohn]","v":32.496000000000002},{"$f":"Tabelle1[Std]*Tabelle1[MSatz]","v":39.904000000000003},{"$f":"Tabelle1[LKosten]+Tabelle1[MKosten]","v":72.400000000000006}]
["E",6,11,12.8,79.03,2,1,{"$f":"VLOOKUP(Personalkosten!$F47&Personalkosten!$G47,CHOOSE({1,2},Maschinen[MNr]&Maschinen[WNr],Maschinen[Stundensatz]),2,0)","v":45.77},{"$f":"Tabelle1[Std]*Tabelle1[Lohn]","v":1011.5840000000001},{"$f":"Tabelle1[Std]*Tabelle1[MSatz]","v":585.85600000000011},{"$f":"Tabelle1[LKosten]+Tabelle1[MKosten]","v":1597.44}]
["E",7,9,15.1,44.28,13,1,{"$f":"VLOOKUP(Personalkosten!$F48&Personalkosten!$G48,CHOOSE({1,2},Maschinen[MNr]&Maschinen[WNr],Maschinen[Stundensatz]),2,0)","v":53.76},{"$f":"Tabelle1[Std]*Tabelle1[Lohn]","v":668.62800000000004},{"$f":"Tabelle1[Std]*Tabelle1[MSatz]","v":811.77599999999995},{"$f":"Tabelle1[LKosten]+Tabelle1[MKosten]","v":1480.404}]
["E",8,6,9.3000000000000007,29.42,20,2,{"$f":"VLOOKUP(Personalkosten!$F49&Personalkosten!$G49,CHOOSE({1,2},Maschinen[MNr]&Maschinen[WNr],Maschinen[Stundensatz]),2,0)","v":43.78},{"$f":"Tabelle1[Std]*Tabelle1[Lohn]","v":273.60600000000005},{"$f":"Tabelle1[Std]*Tabelle1[MSatz]","v":407.15400000000005},{"$f":"Tabelle1[LKosten]+Tabelle1[MKosten]","v":680.7600000000001}]
["E",9,12,16,93.79,12,2,{"$f":"VLOOKUP(Personalkosten!$F50&Personalkosten!$G50,CHOOSE({1,2},Maschinen[MNr]&Maschinen[WNr],Maschinen[Stundensatz]),2,0)","v":45.87},{"$f":"Tabelle1[Std]*Tabelle1[Lohn]","v":1500.64},{"$f":"Tabelle1[Std]*Tabelle1[MSatz]","v":733.92},{"$f":"Tabelle1[LKosten]+Tabelle1[MKosten]","v":2234.56}]
["E",10,9,6.9,22.3,11,1,{"$f":"VLOOKUP(Personalkosten!$F51&Personalkosten!$G51,CHOOSE({1,2},Maschinen[MNr]&Maschinen[WNr],Maschinen[Stundensatz]),2,0)","v":30.73},{"$f":"Tabelle1[Std]*Tabelle1[Lohn]","v":153.87},{"$f":"Tabelle1[Std]*Tabelle1[MSatz]","v":212.03700000000001},{"$f":"Tabelle1[LKosten]+Tabelle1[MKosten]","v":365.90700000000004}]
["E",11,6,5.7,49.37,20,1,{"$f":"VLOOKUP(Personalkosten!$F52&Personalkosten!$G52,CHOOSE({1,2},Maschinen[MNr]&Maschinen[WNr],Maschinen[Stundensatz]),2,0)","v":44.28},{"$f":"Tabelle1[Std]*Tabelle1[Lohn]","v":281.40899999999999},{"$f":"Tabelle1[Std]*Tabelle1[MSatz]","v":252.39600000000002},{"$f":"Tabelle1[LKosten]+Tabelle1[MKosten]","v":533.80500000000006}]

{"sheet":"Tabelle1","index":2,"n_rows":4,"n_cols":6,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["Matrix",null,null,null,"Σ","Formel"]
[1,3,5,null,{"$f":"SUM(A2:C4)","v":45},"=SUMME(A2:C4)"]
[2,4,6,null,{"$f":"SUM(1,3,5,2,4,6,7,9,8)","v":45},"=SUMME(1;3;5;2;4;6;7;9;8)"]
[7,9,8,null,{"$f":"SUM({1,3,5;2,4,6;7,9,8})","v":45},"=SUMME({1.3.5;2.4.6;7.9.8})"]

{"sheet":"Maschinenkosten","index":3,"n_rows":41,"n_cols":3,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
["MNr","WNr","Stundensatz"]
[1,1,31.25]
[1,2,33.520000000000003]
[2,1,45.77]
[2,2,44.64]
[3,1,69.87]
[3,2,71.23]
[4,1,55.26]
[4,2,53.22]
[5,1,39.96]
[5,2,36.450000000000003]
[6,1,41.28]
[6,2,43.28]
[7,1,21.42]
[7,2,24.38]
[8,1,67.34]
[8,2,59.83]
[9,1,58.17]
[9,2,55.76]
[10,1,53.98]
[10,2,54.87]
[11,1,30.73]
[11,2,34.56]
[12,1,43.09]
[12,2,45.87]
[13,1,53.76]
[13,2,53.21]
[14,1,53.4]
[14,2,55.79]
[15,1,50.73]
[15,2,49.88]
[16,1,30.78]
[16,2,31.27]
[17,1,33.869999999999997]
[17,2,31.29]
[18,1,62.29]
[18,2,60.56]
[19,1,51.47]
[19,2,53.12]
[20,1,44.28]
[20,2,43.78]