{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Cover","Belegung","Losgröße"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":20,"n_cols":3,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Excel + VBA"]
[]
[]
[null,"Kapitel",7]
[null,"Thema","Wirtschaftliche Berechnungen"]
[]
[null,"Inhalt","Maschinenbelegung"]
[null,null,"Optimale Losgröße"]
[]
[]
[]
[]
[null,"Autor","Harald Nahrstedt"]
[null,"Datum","2017-03-01"]
[null,"Version","5.0"]
[]
[]
[null,"Springer Vieweg Verlag"]

{"sheet":"Belegung","index":1,"n_rows":10,"n_cols":15,"rows_kept":10,"cut":false,"hidden":false,"merged":[[2,9,2,10],[2,11,2,12],[2,13,2,14]]}
["Maschinen",3]
["Produkte",5]
[null,null,"M01","M02","M03","FARBE","Gesetzte Reihenfolge","Optimierte Reihenfolge","FOLGE","M01",null,"M02",null,"M03"]
[null,"P01",5,3,8,null,16,21,2,4,9,9,12,13,21]
[null,"P02",5,3,4,null,20,34,4,17,22,22,25,30,34]
[null,"P03",12,4,2,null,28,40,5,22,34,34,38,38,40]
[null,"P04",4,2,7,null,35,13,1,0,4,4,6,6,13]
[null,"P05",8,2,9,null,45,30,3,9,17,17,19,21,30]
[null,null,null,null,null,null,"Durchlaufzeit: 45","Durchlaufzeit: 40"]
[null,null,null,null,null,null,null,"Einsparung: 11,00 %"]

{"sheet":"Losgröße","index":2,"n_rows":101,"n_cols":5,"rows_kept":101,"cut":false,"hidden":false,"merged":[]}
["Losgröße\n[Stück]","Gesamt-\nRüstkosten\n[Euro]","Gesamt-\nLagerkosten\n[Euro]","Gesamt-\nKosten\n[Euro]","Gesamt-\nKosten/Stück\n[Euro]"]
[10,45000,29.7,45029.7,45.03]
[20,22500,59.4,22559.4,22.56]
[30,15000,89.1,15089.1,15.09]
[40,11250,118.8,11368.8,11.37]
[50,9000,148.5,9148.5,9.15]
[60,7500,178.2,7678.2,7.68]
[70,6428.57,207.9,6636.47,6.64]
[80,5625,237.6,5862.6,5.86]
[90,5000,267.3,5267.3,5.27]
[100,4500,297,4797,4.8]
[110,4090.91,326.7,4417.6099999999997,4.42]
[120,3750,356.4,4106.3999999999996,4.1100000000000003]
[130,3461.54,386.1,3847.64,3.85]
[140,3214.29,415.8,3630.09,3.63]
[150,3000,445.5,3445.5,3.45]
[160,2812.5,475.2,3287.7,3.29]
[170,2647.06,504.9,3151.96,3.15]
[180,2500,534.6,3034.6,3.03]
[190,2368.42,564.29999999999995,2932.72,2.93]
[200,2250,594,2844,2.84]
[210,2142.86,623.70000000000005,2766.56,2.77]
[220,2045.45,653.4,2698.85,2.7]
[230,1956.52,683.1,2639.62,2.64]
[240,1875,712.8,2587.8000000000002,2.59]
[250,1800,742.5,2542.5,2.54]
[260,1730.77,772.2,2502.9699999999998,2.5]
[270,1666.67,801.9,2468.5700000000002,2.4700000000000002]
[280,1607.14,831.6,2438.7399999999998,2.44]
[290,1551.72,861.3,2413.02,2.41]
[300,1500,891,2391,2.39]
[310,1451.61,920.7,2372.31,2.37]
[320,1406.25,950.4,2356.65,2.36]
[330,1363.64,980.1,2343.7399999999998,2.34]
[340,1323.53,1009.8,2333.33,2.33]
[350,1285.71,1039.5,2325.21,2.33]
[360,1250,1069.2,2319.1999999999998,2.3199999999999998]
[370,1216.22,1098.9000000000001,2315.12,2.3199999999999998]
[380,1184.21,1128.5999999999999,2312.81,2.31]
[390,1153.8499999999999,1158.3,2312.15,2.31]
[400,1125,1188,2313,2.31]
[410,1097.56,1217.7,2315.2600000000002,2.3199999999999998]
[420,1071.43,1247.4000000000001,2318.83,2.3199999999999998]
[430,1046.51,1277.0999999999999,2323.61,2.3199999999999998]
[440,1022.73,1306.8,2329.5300000000002,2.33]
[450,1000,1336.5,2336.5,2.34]
[460,978.26,1366.2,2344.46,2.34]
[470,957.45,1395.9,2353.35,2.35]
[480,937.5,1425.6,2363.1,2.36]
[490,918.37,1455.3,2373.67,2.37]
[500,900,1485,2385,2.38]
[510,882.35,1514.7,2397.0500000000002,2.4]
[520,865.38,1544.4,2409.7800000000002,2.41]
[530,849.06,1574.1,2423.16,2.42]
[540,833.33,1603.8,2437.13,2.44]
[550,818.18,1633.5,2451.6799999999998,2.4500000000000002]
[560,803.57,1663.2,2466.77,2.4700000000000002]
[570,789.47,1692.9,2482.37,2.48]
[580,775.86,1722.6,2498.46,2.5]
[590,762.71,1752.3,2515.0100000000002,2.52]
[600,750,1782,2532,2.5299999999999998]
[610,737.7,1811.7,2549.4,2.5499999999999998]
[620,725.81,1841.4,2567.21,2.57]
[630,714.29,1871.1,2585.39,2.59]
[640,703.12,1900.8,2603.9299999999998,2.6]
[650,692.31,1930.5,2622.81,2.62]
[660,681.82,1960.2,2642.02,2.64]
[670,671.64,1989.9,2661.54,2.66]
[680,661.76,2019.6,2681.36,2.68]
[690,652.16999999999996,2049.3000000000002,2701.47,2.7]
[700,642.86,2079,2721.86,2.72]
[710,633.79999999999995,2108.6999999999998,2742.5,2.74]
[720,625,2138.4,2763.4,2.76]
[730,616.44000000000005,2168.1,2784.54,2.78]
[740,608.11,2197.8000000000002,2805.91,2.81]
[750,600,2227.5,2827.5,2.83]
[760,592.11,2257.1999999999998,2849.31,2.85]
[770,584.41999999999996,2286.9,2871.32,2.87]
[780,576.91999999999996,2316.6,2893.52,2.89]
[790,569.62,2346.3000000000002,2915.92,2.92]
[800,562.5,2376,2938.5,2.94]
[810,555.55999999999995,2405.6999999999998,2961.26,2.96]
[820,548.78,2435.4,2984.18,2.98]
[830,542.16999999999996,2465.1,3007.27,3.01]
[840,535.71,2494.8000000000002,3030.51,3.03]
[850,529.41,2524.5,3053.91,3.05]
[860,523.26,2554.1999999999998,3077.46,3.08]
[870,517.24,2583.9,3101.14,3.1]
[880,511.36,2613.6,3124.96,3.12]
[890,505.62,2643.3,3148.92,3.15]
[900,500,2673,3173,3.17]
[910,494.51,2702.7,3197.21,3.2]
[920,489.13,2732.4,3221.53,3.22]
[930,483.87,2762.1,3245.97,3.25]
[940,478.72,2791.8,3270.52,3.27]
[950,473.68,2821.5,3295.18,3.3]
[960,468.75,2851.2,3319.95,3.32]
[970,463.92,2880.9,3344.82,3.34]
[980,459.18,2910.6,3369.78,3.37]
[990,454.55,2940.3,3394.85,3.39]
[1000,450,2970,3420,3.42]