{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Cover","Produktionsdaten","Maschinendaten","Kosten"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":9,"comments":0,"pivot_tables":1},"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",5]
[null,"Thema","Datenmodelle"]
[]
[null,"Inhalt","Produktionsdaten"]
[null,null,"dienen zur Erstellung einer Beziehung zwischen"]
[null,null,"Personalkosten und Maschinenkosten"]
[null,null,"zur Übergabe in eine Pivot-Tabelle"]
[]
[]
[]
[]
[null,"Version","2.0"]
[null,"Autor","Harald Nahrstedt"]
[null,"Datum","2023-08-03"]
[]
[]
[null,"Springer Verlag"]

{"sheet":"Produktionsdaten","index":1,"n_rows":52,"n_cols":6,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
["Produkt","Bauteil","Anzahl","Std","Lohn","MNr"]
["A",1,7,3.5,29.8,6]
["A",2,1,4.3,69.52,1]
["A",1,4,2.5,27.45,5]
["A",3,2,4.4000000000000004,76.31,14]
["A",4,1,6.9,57.09,16]
["A",5,17,9.5,85.88,16]
["A",6,1,7.5,79.510000000000005,1]
["A",7,7,4.8,86.93,15]
["A",8,19,1.4,27.68,15]
["A",9,14,2.8,9.2200000000000006,14]
["A",10,2,10.6,57.02,9]
["A",11,3,5.9,98.69,1]
["A",12,17,18.7,37.25,17]
["A",13,1,10.5,21.45,8]
["A",14,2,17.899999999999999,1.57,18]
["A",15,9,3.8,2.39,5]
["B",1,17,2.4,96.02,9]
["B",2,19,6.7,51.6,12]
["B",3,1,10.6,20.37,6]
["B",4,8,4.8,29.28,2]
["B",5,14,2.2000000000000002,16.38,7]
["B",6,14,10.1,87.71,9]
["B",7,15,1.4,77.64,13]
["C",1,2,2.2000000000000002,13.07,17]
["C",2,9,19.8,29.82,11]
["C",3,14,7.8,47.73,3]
["C",4,8,14.7,13.95,13]
["C",5,7,6.9,79.97,5]
["C",6,18,6.7,27.53,14]
["C",7,1,11.3,70.7,3]
["C",8,13,11.3,87.97,12]
["C",9,8,4.7,28.97,18]
["C",10,4,11.9,58.61,13]
["C",11,6,2.6,21.31,16]
["D",1,1,4.8,19.5,1]
["D",2,2,5,12.95,15]
["D",3,1,18.2,99.01,6]
["D",4,18,9,57.26,13]
["D",5,3,11.3,57.83,18]
["D",6,11,10.5,5.8,8]
["E",1,15,12.6,59.56,1]
["E",2,4,3.1,71,2]
["E",3,15,19.2,78.84,19]
["E",4,20,6.5,50.5,12]
["E",5,1,0.8,40.619999999999997,15]
["E",6,11,12.8,79.03,2]
["E",7,9,15.1,44.28,13]
["E",8,6,9.3000000000000007,29.42,20]
["E",9,12,16,93.79,12]
["E",10,9,6.9,22.3,11]
["E",11,6,5.7,49.37,20]

{"sheet":"Maschinendaten","index":2,"n_rows":21,"n_cols":2,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["MNr","Satz"]
[1,31.25]
[2,45.77]
[3,69.87]
[4,55.26]
[5,39.96]
[6,41.28]
[7,21.42]
[8,67.34]
[9,58.17]
[10,53.98]
[11,30.73]
[12,43.09]
[13,53.76]
[14,53.4]
[15,50.73]
[16,30.78]
[17,33.869999999999997]
[18,62.29]
[19,51.47]
[20,44.28]

{"sheet":"Kosten","index":3,"n_rows":56,"n_cols":10,"rows_kept":56,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Kostenrechnung"]
["Produkt","Bauteil","Std","Lohn","Satz","Ergebnis","Lohnkosten","Maschinenkosten","Gesamtkosten","Kosten/Stück"]
["A",1,2.5,27.45,39.96,4,{"$f":"Std*Lohn","v":68.625},{"$f":"Std*Satz","v":99.9},{"$f":"Lohnkosten+Maschinenkosten","v":168.52500000000001},{"$f":"Gesamtkosten/Anzahl","v":42.131250000000001}]
[null,null,3.5,29.8,41.28,7,104.3,144.48000000000002,248.78000000000003,35.540000000000006]
[null,2,4.3,69.52,31.25,1,298.93599999999998,134.375,433.31099999999998,433.31099999999998]
[null,3,4.4000000000000004,76.31,53.4,2,335.76400000000001,234.96,570.72400000000005,285.36200000000002]
[null,4,6.9,57.09,30.78,1,393.92100000000005,212.38200000000001,606.30300000000011,606.30300000000011]
[null,5,9.5,85.88,30.78,17,815.8599999999999,292.41000000000003,1108.27,65.192352941176466]
[null,6,7.5,79.510000000000005,31.25,1,596.32500000000005,234.375,830.7,830.7]
[null,7,4.8,86.93,50.73,7,417.26400000000001,243.50399999999996,660.76800000000003,94.395428571428582]
[null,8,1.4,27.68,50.73,19,38.751999999999995,71.021999999999991,109.77399999999999,5.7775789473684203]
[null,9,2.8,9.2200000000000006,53.4,14,25.815999999999999,149.51999999999998,175.33599999999998,12.523999999999999]
[null,10,10.6,57.02,58.17,2,604.41200000000003,616.60199999999998,1221.0140000000001,610.50700000000006]
[null,11,5.9,98.69,31.25,3,582.27100000000007,184.375,766.64600000000007,255.54866666666669]
[null,12,18.7,37.25,33.869999999999997,17,696.57499999999993,633.36899999999991,1329.944,78.231999999999999]
[null,13,10.5,21.45,67.34,1,225.22499999999999,707.07,932.29500000000007,932.29500000000007]
[null,14,17.899999999999999,1.57,62.29,2,28.102999999999998,1114.991,1143.0940000000001,571.54700000000003]
[null,15,3.8,2.39,39.96,9,9.0820000000000007,151.84799999999998,160.92999999999998,17.88111111111111]
["B",1,2.4,96.02,58.17,17,230.44799999999998,139.608,370.05599999999998,21.768000000000001]
[null,2,6.7,51.6,43.09,19,345.72,288.70300000000003,634.423,33.390684210526317]
[null,3,10.6,20.37,41.28,1,215.922,437.56799999999998,653.49,653.49]
[null,4,4.8,29.28,45.77,8,140.54400000000001,219.696,360.24,45.03]
[null,5,2.2000000000000002,16.38,21.42,14,36.036000000000001,47.124000000000009,83.160000000000011,5.94]
[null,6,10.1,87.71,58.17,14,885.87099999999987,587.51700000000005,1473.3879999999999,105.24199999999999]
[null,7,1.4,77.64,53.76,15,108.696,75.263999999999996,183.95999999999998,12.263999999999999]
["C",1,2.2000000000000002,13.07,33.869999999999997,2,28.754000000000001,74.513999999999996,103.268,51.634]
[null,2,19.8,29.82,30.73,9,590.43600000000004,608.45400000000006,1198.8900000000001,133.21]
[null,3,7.8,47.73,69.87,14,372.29399999999998,544.98599999999999,917.28,65.52]
[null,4,14.7,13.95,53.76,8,205.06499999999997,790.27199999999993,995.33699999999988,124.41712499999998]
[null,5,6.9,79.97,39.96,7,551.79300000000001,275.72400000000005,827.51700000000005,118.21671428571429]
[null,6,6.7,27.53,53.4,18,184.45100000000002,357.78,542.23099999999999,30.123944444444444]
[null,7,11.3,70.7,69.87,1,798.91000000000008,789.53100000000006,1588.4410000000003,1588.4410000000003]
[null,8,11.3,87.97,43.09,13,994.06100000000004,486.91700000000009,1480.9780000000001,113.92138461538462]
[null,9,4.7,28.97,62.29,8,136.15899999999999,292.76300000000003,428.92200000000003,53.615250000000003]
[null,10,11.9,58.61,53.76,4,697.45900000000006,639.74400000000003,1337.203,334.30074999999999]
[null,11,2.6,21.31,30.78,6,55.405999999999999,80.028000000000006,135.434,22.572333333333333]
["D",1,4.8,19.5,31.25,1,93.6,150,243.6,243.6]
[null,2,5,12.95,50.73,2,64.75,253.64999999999998,318.39999999999998,159.19999999999999]
[null,3,18.2,99.01,41.28,1,1801.982,751.29599999999994,2553.2779999999998,2553.2779999999998]
[null,4,9,57.26,53.76,18,515.34,483.84,999.18000000000006,55.510000000000005]
[null,5,11.3,57.83,62.29,3,653.47900000000004,703.87700000000007,1357.3560000000002,452.45200000000006]
[null,6,10.5,5.8,67.34,11,60.9,707.07,767.97,69.815454545454543]
["E",1,12.6,59.56,31.25,15,750.45600000000002,393.75,1144.2060000000001,76.280400000000014]
[null,2,3.1,71,45.77,4,220.1,141.887,361.98699999999997,90.496749999999992]
[null,3,19.2,78.84,51.47,15,1513.7280000000001,988.22399999999993,2501.9520000000002,166.79680000000002]
[null,4,6.5,50.5,43.09,20,328.25,280.08500000000004,608.33500000000004,30.41675]
[null,5,0.8,40.619999999999997,50.73,1,32.496000000000002,40.584000000000003,73.080000000000013,73.080000000000013]
[null,6,12.8,79.03,45.77,11,1011.5840000000001,585.85600000000011,1597.44,145.22181818181818]
[null,7,15.1,44.28,53.76,9,668.62800000000004,811.77599999999995,1480.404,164.48933333333332]
[null,8,9.3000000000000007,29.42,44.28,6,273.60600000000005,411.80400000000003,685.41000000000008,114.23500000000001]
[null,9,16,93.79,43.09,12,1500.64,689.44,2190.08,182.50666666666666]
[null,10,6.9,22.3,30.73,9,153.87,212.03700000000001,365.90700000000004,40.656333333333336]
[null,11,5.7,49.37,44.28,6,281.40899999999999,252.39600000000002,533.80500000000006,88.967500000000015]
["Gesamtergebnis",null,null,null,null,429,{"$f":"SUM(G5:G21)","v":5471.6790000000001},{"$f":"SUM(H5:H21)","v":5364.7909999999993},{"$f":"SUM(I5:I21)","v":10836.470000000001},{"$f":"SUM(J5:J55)","v":13097.347380187763}]