{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Cover","Simulation"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":1,"defined_names":8,"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",8]
[null,"Thema","Operatives Prozess-Controlling"]
[]
[null,"Inhalt","Optimale Losgröße"]
[]
[null,null," "]
[]
[]
[]
[]
[]
[null,"Version","1.0"]
[null,"Autor","Harald Nahrstedt"]
[null,"Datum","2025-04-27"]
[]
[]
[null,"Springer Verlag"]

{"sheet":"Simulation","index":1,"n_rows":92,"n_cols":8,"rows_kept":92,"cut":false,"hidden":false,"merged":[]}
["Rüstkosten",450,null,"n [Stk]","GR","GL","G","GS"]
["Herstellkosten",22,null,100,4500,297,4797,4.7969999999999997]
["Jahresbedarf",1000,null,110,4090.909090909091,326.7,4417.6090909090908,4.4176090909090906]
["Bankzinssatz",0.12,null,120,3750,356.4,4106.3999999999996,4.1063999999999998]
["Lagerzinssatz",0.15,null,130,3461.5384615384614,386.09999999999997,3847.6384615384613,3.8476384615384616]
[null,null,null,140,3214.2857142857142,415.8,3630.0857142857144,3.6300857142857144]
[null,null,null,150,3000,445.5,3445.5,3.4455]
[null,null,null,160,2812.5,475.2,3287.7,3.2876999999999996]
[null,null,null,170,2647.0588235294117,504.9,3151.9588235294118,3.1519588235294118]
[null,null,null,180,2500,534.6,3034.6,3.0345999999999997]
[null,null,null,190,2368.4210526315787,564.29999999999995,2932.7210526315785,2.9327210526315786]
[null,null,null,200,2250,594,2844,2.8439999999999999]
[null,null,null,210,2142.8571428571427,623.69999999999993,2766.5571428571425,2.7665571428571423]
[null,null,null,220,2045.4545454545455,653.4,2698.8545454545456,2.6988545454545454]
[null,null,null,230,1956.5217391304348,683.1,2639.6217391304349,2.6396217391304351]
[null,null,null,240,1875,712.8,2587.8000000000002,2.5878000000000001]
[null,null,null,250,1800,742.5,2542.5,2.5425]
[null,null,null,260,1730.7692307692307,772.19999999999993,2502.9692307692308,2.5029692307692306]
[null,null,null,270,1666.6666666666667,801.9,2468.5666666666666,2.4685666666666668]
[null,null,null,280,1607.1428571428571,831.6,2438.7428571428572,2.4387428571428571]
[null,null,null,290,1551.7241379310344,861.3,2413.0241379310346,2.4130241379310347]
[null,null,null,300,1500,891,2391,2.391]
[null,null,null,310,1451.6129032258063,920.69999999999993,2372.3129032258062,2.3723129032258061]
[null,null,null,320,1406.25,950.4,2356.65,2.3566500000000001]
[null,null,null,330,1363.6363636363637,980.09999999999991,2343.7363636363634,2.3437363636363635]
[null,null,null,340,1323.5294117647059,1009.8,2333.3294117647056,2.3333294117647054]
[null,null,null,350,1285.7142857142858,1039.5,2325.2142857142858,2.3252142857142859]
[null,null,null,360,1250,1069.2,2319.1999999999998,2.3191999999999999]
[null,null,null,370,1216.2162162162163,1098.8999999999999,2315.1162162162163,2.3151162162162162]
[null,null,null,380,1184.2105263157894,1128.5999999999999,2312.8105263157895,2.3128105263157894]
[null,null,null,390,1153.8461538461538,1158.3,2312.1461538461535,2.3121461538461534]
[null,null,null,400,1125,1188,2313,2.3130000000000002]
[null,null,null,410,1097.560975609756,1217.7,2315.2609756097563,2.3152609756097564]
[null,null,null,420,1071.4285714285713,1247.3999999999999,2318.8285714285712,2.318828571428571]
[null,null,null,430,1046.5116279069769,1277.0999999999999,2323.6116279069765,2.3236116279069767]
[null,null,null,440,1022.7272727272727,1306.8,2329.5272727272727,2.3295272727272729]
[null,null,null,450,1000,1336.5,2336.5,2.3365]
[null,null,null,460,978.26086956521738,1366.2,2344.4608695652173,2.3444608695652174]
[null,null,null,470,957.44680851063833,1395.8999999999999,2353.3468085106383,2.3533468085106382]
[null,null,null,480,937.5,1425.6,2363.1,2.3630999999999998]
[null,null,null,490,918.36734693877554,1455.3,2373.6673469387756,2.3736673469387757]
[null,null,null,500,900,1485,2385,2.3849999999999998]
[null,null,null,510,882.35294117647061,1514.7,2397.0529411764705,2.3970529411764705]
[null,null,null,520,865.38461538461536,1544.3999999999999,2409.7846153846153,2.4097846153846154]
[null,null,null,530,849.05660377358492,1574.1,2423.1566037735847,2.4231566037735845]
[null,null,null,540,833.33333333333337,1603.8,2437.1333333333332,2.4371333333333332]
[null,null,null,550,818.18181818181813,1633.5,2451.681818181818,2.4516818181818181]
[null,null,null,560,803.57142857142856,1663.2,2466.7714285714287,2.4667714285714286]
[null,null,null,570,789.47368421052636,1692.8999999999999,2482.3736842105263,2.4823736842105264]
[null,null,null,580,775.86206896551721,1722.6,2498.4620689655171,2.4984620689655173]
[null,null,null,590,762.71186440677968,1752.3,2515.0118644067798,2.5150118644067798]
[null,null,null,600,750,1782,2532,2.532]
[null,null,null,610,737.70491803278685,1811.7,2549.404918032787,2.5494049180327871]
[null,null,null,620,725.80645161290317,1841.3999999999999,2567.206451612903,2.5672064516129032]
[null,null,null,630,714.28571428571433,1871.1,2585.3857142857141,2.5853857142857142]
[null,null,null,640,703.125,1900.8,2603.9250000000002,2.6039250000000003]
[null,null,null,650,692.30769230769226,1930.5,2622.8076923076924,2.6228076923076924]
[null,null,null,660,681.81818181818187,1960.1999999999998,2642.0181818181818,2.6420181818181816]
[null,null,null,670,671.64179104477614,1989.8999999999999,2661.5417910447759,2.6615417910447761]
[null,null,null,680,661.76470588235293,2019.6,2681.3647058823526,2.6813647058823524]
[null,null,null,690,652.17391304347825,2049.2999999999997,2701.4739130434782,2.7014739130434782]
[null,null,null,700,642.85714285714289,2079,2721.8571428571431,2.721857142857143]
[null,null,null,710,633.80281690140851,2108.6999999999998,2742.5028169014086,2.7425028169014087]
[null,null,null,720,625,2138.4,2763.4,2.7634000000000003]
[null,null,null,730,616.43835616438355,2168.1,2784.5383561643835,2.7845383561643833]
[null,null,null,740,608.10810810810813,2197.7999999999997,2805.9081081081076,2.8059081081081074]
[null,null,null,750,600,2227.5,2827.5,2.8275000000000001]
[null,null,null,760,592.10526315789468,2257.1999999999998,2849.3052631578944,2.8493052631578943]
[null,null,null,770,584.41558441558436,2286.9,2871.3155844155845,2.8713155844155844]
[null,null,null,780,576.92307692307691,2316.6,2893.5230769230766,2.8935230769230764]
[null,null,null,790,569.62025316455697,2346.2999999999997,2915.9202531645569,2.9159202531645567]
[null,null,null,800,562.5,2376,2938.5,2.9384999999999999]
[null,null,null,810,555.55555555555554,2405.6999999999998,2961.2555555555555,2.9612555555555553]
[null,null,null,820,548.78048780487802,2435.4,2984.1804878048779,2.9841804878048781]
[null,null,null,830,542.16867469879514,2465.1,3007.2686746987952,3.0072686746987953]
[null,null,null,840,535.71428571428567,2494.7999999999997,3030.5142857142855,3.0305142857142857]
[null,null,null,850,529.41176470588232,2524.5,3053.9117647058824,3.0539117647058824]
[null,null,null,860,523.25581395348843,2554.1999999999998,3077.4558139534884,3.0774558139534882]
[null,null,null,870,517.24137931034488,2583.9,3101.1413793103447,3.1011413793103446]
[null,null,null,880,511.36363636363637,2613.6,3124.9636363636364,3.1249636363636366]
[null,null,null,890,505.61797752808991,2643.2999999999997,3148.9179775280895,3.1489179775280896]
[null,null,null,900,500,2673,3173,3.173]
[null,null,null,910,494.50549450549448,2702.7,3197.2054945054942,3.1972054945054942]
[null,null,null,920,489.13043478260869,2732.4,3221.5304347826086,3.2215304347826086]
[null,null,null,930,483.87096774193549,2762.1,3245.9709677419355,3.2459709677419357]
[null,null,null,940,478.72340425531917,2791.7999999999997,3270.5234042553188,3.2705234042553188]
[null,null,null,950,473.68421052631578,2821.5,3295.1842105263158,3.2951842105263158]
[null,null,null,960,468.75,2851.2,3319.95,3.31995]
[null,null,null,970,463.91752577319585,2880.9,3344.8175257731959,3.344817525773196]
[null,null,null,980,459.18367346938777,2910.6,3369.7836734693878,3.3697836734693878]
[null,null,null,990,454.54545454545456,2940.2999999999997,3394.8454545454542,3.3948454545454543]
[null,null,null,1000,450,2970,3420,3.42]