{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Eingaben","Tabellen","Gesamtkosten","Stückkosten","Gewinn","Funktionen"],"not_rendered":{"charts":3,"images":7,"macros":1,"external_links":0,"defined_names":17,"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":"Eingaben","index":0,"n_rows":27,"n_cols":12,"rows_kept":27,"cut":false,"hidden":false,"merged":[[23,1,23,12],[24,1,24,12],[25,1,25,12],[19,4,19,9],[20,4,20,9],[21,4,21,9],[18,4,18,9],[1,1,1,12],[3,10,3,12],[4,10,4,12],[5,11,5,12],[6,11,6,12]]}
[]
[null,"Preisbildung im Polypol (vollkommener Markt)"]
[]
[null,null,"Kapazitäts-",null,null,"Produktions-",null,null,"Stück-",null,"Toleranzbereich"]
[null,null,"grenze (Xmax)",null,null,"menge",null,null,"preis",null,"für den Betriebserfolg"]
[null,null,null,null,null,null,null,"Erlös",null,{"$f":"Tabellen!H5","v":95040.000000000073},"Verlust","0"]
[null,"Funktionen","aX3","bX2","cX","d","d/X","Gesamtkosten",null,{"$f":"Tabellen!H4","v":54186.315936000065},"Gewinn",10000]
[null,"Gesamtkosten",3.7999999999999999E-2,-8.0399999999999991,824.45,6000,null,"variable Gesamtkosten",null,{"$f":"Tabellen!H7","v":48186.315936000065}]
[null,"variable Gesamtkosten",{"$f":"C8","v":3.7999999999999999E-2},{"$f":"D8","v":-8.0399999999999991},{"$f":"E8","v":824.45},null,null,"Stückkosten",null,{"$f":"Tabellen!H6","v":456.11377050505064}]
[null,"Stückkosten",null,{"$f":"C8","v":3.7999999999999999E-2},{"$f":"D8","v":-8.0399999999999991},{"$f":"E8","v":824.45},{"$f":"F8","v":6000},"variable Stückkosten",null,{"$f":"Tabellen!H9","v":405.60872000000018}]
[null,"variable Stückkosten",null,{"$f":"D10","v":3.7999999999999999E-2},{"$f":"E10","v":-8.0399999999999991},{"$f":"F10","v":824.45},null,"Grenzkosten",null,{"$f":"Tabellen!H10","v":51155.708928000109}]
[null,"Grenzkosten",null,{"$f":"Tabellen!C9","v":0.11399999999999999},{"$f":"Tabellen!D9","v":-16.079999999999998},{"$f":"Tabellen!E9","v":824.45},null,"Gewinn/Verlust",null,{"$f":"Tabellen!H3","v":40853.684064000008}]
[]
[null,"  Tabellen und Grafiken"]
[]
[]
[]
[]
[null,"Extrempunkte","€","Menge"]
[null,"Gewinnmaximum",{"$f":"Tabellen!J3","v":43884.291071999964},{"$f":"Tabellen!K3","v":138.60000000000005},"größter Gesamtgewinn; größte Differenz zwischen Erlös und Kosten"]
[null,"Betriebsminimum",{"$f":"Tabellen!J4","v":399.17768000000012},{"$f":"Tabellen!K4","v":105.60000000000008},"Minimum der variablen Stückkosten; Deckung der fixen Kosten"]
[null,"Betriebsoptimum",{"$f":"Tabellen!J5","v":454.21385582887712},{"$f":"Tabellen!K5","v":455.40176000000088},"Minimum der gesamten Stückkosten; geringste Kostensteigung"]
[]
[null,"Klicken Sie auf den Button \"Kostenfunktion\" und tragen Sie die Funktion entsprechend den Potenzen in die dafür vorgesehenen Felder ein."]
[null,"Sie können einen Toleranzbereich für Gewinnerwartungen (akzeptierter Verlust bzw. Mindestgewinn) angeben."]
[null,"Durch Eingabe einer Kapazitätsgrenze bestimmen Sie den Ausgabebereich der Tabellen und Grafiken."]
[null,"Nach Festlegung der Produktionsmenge und des Stückpreises können Sie Erlöse, Kosten und Gewinne ablesen."]

{"sheet":"Tabellen","index":1,"n_rows":113,"n_cols":19,"rows_kept":113,"cut":false,"hidden":false,"merged":[[12,14,12,15],[2,11,2,12],[1,14,1,15],[2,14,2,15],[4,11,4,12],[6,17,6,18],[10,17,10,18],[1,17,1,18],[2,17,2,18],[7,11,7,12],[1,11,1,12],[4,14,4,15],[7,14,7,15],[8,14,8,15]]}
[null,"aX3","bX2","cX","d","d/X","Ausgabewerte ",null,null,"€","Mengen"]
["K=",{"$f":"Eingaben!C8","v":3.7999999999999999E-2},{"$f":"Eingaben!D8","v":-8.0399999999999991},{"$f":"Eingaben!E8","v":824.45},{"$f":"Eingaben!F8","v":6000},null,"X",120,"p",800,null,"Gesamtanalyse",null,null,"Stückanalyse",null,null,"Gewinnanalyse"]
["Kv=",{"$f":"B2","v":3.7999999999999999E-2},{"$f":"C2","v":-8.0399999999999991},{"$f":"D2","v":824.45},null,null,"G",{"$f":"VLOOKUP(H2,A13:K113,11)","v":40853.684064000008},"Gmax",{"$f":"MAX(K13:K113)","v":43884.291071999964},{"$f":"VLOOKUP(J3,K13:L113,2,FALSE)","v":138.60000000000005},"Gewinnmaximum",null,null,"Gewinnmaximum",null,null,"gewinnmaximlae Menge"]
["Kf=",null,null,null,{"$f":"E2","v":6000},null,"K",{"$f":"VLOOKUP(H2,A13:K113,2)","v":54186.315936000065},"kvmin",{"$f":"MIN(H13:H113)","v":399.17768000000012},{"$f":"VLOOKUP(J4,H14:L113,5,FALSE)","v":105.60000000000008},"X-Werte","Y-Werte",null,"X-Werte","Y-Werte",null,"X-Werte","Y-Werte"]
["E=",null,null,{"$f":"J2","v":800},null,null,"E",{"$f":"VLOOKUP(H2,A13:K113,3)","v":95040.000000000073},"kmin",{"$f":"MIN(F13:F113)","v":454.21385582887712},{"$f":"VLOOKUP(J5,F14:L113,5,FALSE)","v":455.40176000000088},"Menge",null,null,"Menge",null,null,{"$f":"K3","v":138.60000000000005},0]
["k=",null,{"$f":"$B$2","v":3.7999999999999999E-2},{"$f":"$C$2","v":-8.0399999999999991},{"$f":"$D$2","v":824.45},{"$f":"$E$2","v":6000},"k",{"$f":"VLOOKUP(H2,A13:K113,6)","v":456.11377050505064},null,null,null,{"$f":"K3","v":138.60000000000005},0,null,{"$f":"K3","v":138.60000000000005},0,null,{"$f":"K3","v":138.60000000000005},{"$f":"J3","v":43884.291071999964}]
["kv=",null,{"$f":"$B$2","v":3.7999999999999999E-2},{"$f":"$C$2","v":-8.0399999999999991},{"$f":"$D$2","v":824.45},null,"Kv",{"$f":"VLOOKUP(H2,A13:K113,4)","v":48186.315936000065},null,null,null,{"$f":"K3","v":138.60000000000005},{"$f":"VLOOKUP(L7,A13:C113,3,FALSE)","v":110880.00000000004},null,{"$f":"K3","v":138.60000000000005},{"$f":"J2","v":800},null,"maximaler Gewinn"]
["kf=",null,null,null,null,{"$f":"$E$2","v":6000},"Kf",{"$f":"VLOOKUP(H2,A13:K113,5)","v":6000},null,null,null,"Erlös",null,null,"Betriebsminimum",null,null,"X-Werte","Y-Werte"]
["K'",null,{"$f":"3*$B$2","v":0.11399999999999999},{"$f":"2*$C$2","v":-16.079999999999998},{"$f":"$D$2","v":824.45},null,"kv",{"$f":"VLOOKUP(H2,A13:K113,8)","v":405.60872000000018},null,null,null,{"$f":"K6","v":0},{"$f":"M7","v":110880.00000000004},null,"Menge",null,null,{"$f":"N4","v":0},{"$f":"J3","v":43884.291071999964}]
["Xmax",220,null,null,null,null,"K'",{"$f":"VLOOKUP(H2,A13:K113,9)","v":51155.708928000109},null,null,null,{"$f":"K3","v":138.60000000000005},{"$f":"VLOOKUP(L10,A16:C116,3,FALSE)","v":110880.00000000004},null,"X-Werte","Y-Werte",null,{"$f":"K3","v":138.60000000000005},{"$f":"J3","v":43884.291071999964}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"K4","v":105.60000000000008},0]
["X","K","E","Kv","Kf","k","p","kv","E-Gmax","K'","E-K","X",null,null,{"$f":"K4","v":105.60000000000008},{"$f":"J4","v":399.17768000000012}]
[0,{"$f":"($B$2*(A13*A13*A13))+($C$2*(A13*A13))+($D$2*A13)+($E$2)","v":6000},{"$f":"$D$5*A13","v":0},{"$f":"B13-$E$4","v":0},{"$f":"$E$4","v":6000},null,null,null,{"$f":"C13-$J$3","v":-43884.291071999964},null,{"$f":"C13-B13","v":-6000},0,null,null,"minimale variable Stückkosten"]
[{"$f":"B10/100","v":2.2000000000000002},{"$f":"($B$2*(A14*A14*A14))+($C$2*(A14*A14))+($D$2*A14)+($E$2)","v":7775.2810239999999},{"$f":"$D$5*A14","v":1760.0000000000002},{"$f":"B14-$E$4","v":1775.2810239999999},{"$f":"$E$4","v":6000},{"$f":"($C$6*(A14*A14))+($D$6*A14)+($E$6)+($F$6/A14)","v":3534.2186472727271},{"$f":"$J$2","v":800},{"$f":"($C$7*(A14*A14))+($D$7*A14)+($E$7)","v":806.94592},{"$f":"C14-$J$3","v":-42124.291071999964},{"$f":"($C$9*(A14*A14))+($D$9*A14)+($E$9)","v":789.62576000000001},-6015.2810239999999,{"$f":"L113/100","v":2.2000000000000002},null,null,"X-Werte","Y-Werte"]
[{"$f":"A14+$A$14","v":4.4000000000000004},{"$f":"($B$2*(A15*A15*A15))+($C$2*(A15*A15))+($D$2*A15)+($E$2)","v":9475.1625920000006},3520.0000000000005,{"$f":"B15-$E$4","v":3475.1625920000006},{"$f":"$E$4","v":6000},{"$f":"($C$6*(A15*A15))+($D$6*A15)+($E$6)+($F$6/A15)","v":2153.4460436363634},{"$f":"$J$2","v":800},{"$f":"($C$7*(A15*A15))+($D$7*A15)+($E$7)","v":789.80968000000007},-40364.291071999964,755.9050400000001,-5955.1625920000006,{"$f":"L14+$L$14","v":4.4000000000000004},null,null,0,{"$f":"J4","v":399.17768000000012}]
[{"$f":"A15+$A$14","v":6.6000000000000005},{"$f":"($B$2*(A16*A16*A16))+($C$2*(A16*A16))+($D$2*A16)+($E$2)","v":11102.072448000001},{"$f":"$D$5*A16","v":5280},{"$f":"B16-$E$4","v":5102.0724480000008},{"$f":"$E$4","v":6000},{"$f":"($C$6*(A16*A16))+($D$6*A16)+($E$6)+($F$6/A16)","v":1682.1321890909089},800,{"$f":"($C$7*(A16*A16))+($D$7*A16)+($E$7)","v":773.04128000000003},-38604.291071999964,723.28784000000007,-5822.0724480000008,6.6000000000000005,null,null,{"$f":"K4","v":105.60000000000008},{"$f":"J4","v":399.17768000000012}]
[8.8000000000000007,{"$f":"($B$2*(A17*A17*A17))+($C$2*(A17*A17))+($D$2*A17)+($E$2)","v":12658.438336000001},7040.0000000000009,{"$f":"B17-$E$4","v":6658.4383360000011},{"$f":"$E$4","v":6000},{"$f":"($C$6*(A17*A17))+($D$6*A17)+($E$6)+($F$6/A17)","v":1438.4589018181819},800,{"$f":"($C$7*(A17*A17))+($D$7*A17)+($E$7)","v":756.6407200000001},-36844.291071999964,691.77416000000005,-5618.4383360000002,8.8000000000000007]
[11,{"$f":"($B$2*(A18*A18*A18))+($C$2*(A18*A18))+($D$2*A18)+($E$2)","v":14146.688000000002},{"$f":"$D$5*A18","v":8800},{"$f":"B18-$E$4","v":8146.6880000000019},{"$f":"$E$4","v":6000},{"$f":"($C$6*(A18*A18))+($D$6*A18)+($E$6)+($F$6/A18)","v":1286.0625454545457},800,{"$f":"($C$7*(A18*A18))+($D$7*A18)+($E$7)","v":740.60800000000006},-35084.291071999964,661.36400000000003,-5346.6880000000019,11]
[13.2,15569.249184,10560,9569.2491840000002,6000,1179.4885745454546,800,724.94312000000002,-33324.291071999964,632.05736000000002,-5009.2491840000002,13.2]
[15.399999999999999,{"$f":"($B$2*(A20*A20*A20))+($C$2*(A20*A20))+($D$2*A20)+($E$2)","v":16928.549631999998},{"$f":"$D$5*A20","v":12319.999999999998},{"$f":"B20-$E$4","v":10928.549631999998},{"$f":"$E$4","v":6000},{"$f":"($C$6*(A20*A20))+($D$6*A20)+($E$6)+($F$6/A20)","v":1099.2564696103898},800,{"$f":"($C$7*(A20*A20))+($D$7*A20)+($E$7)","v":709.6460800000001},-31564.291071999964,603.85424000000012,-4608.5496320000002,15.399999999999999]
[17.599999999999998,18227.017088000001,14079.999999999998,12227.017088000001,6000,1035.6259709090909,800,694.71688000000006,-29804.291071999964,576.75464000000011,-4147.0170880000023,17.599999999999998]
[19.799999999999997,{"$f":"($B$2*(A22*A22*A22))+($C$2*(A22*A22))+($D$2*A22)+($E$2)","v":19467.079296},{"$f":"$D$5*A22","v":15839.999999999998},{"$f":"B22-$E$4","v":13467.079296},{"$f":"$E$4","v":6000},{"$f":"($C$6*(A22*A22))+($D$6*A22)+($E$6)+($F$6/A22)","v":983.18582303030303},800,{"$f":"($C$7*(A22*A22))+($D$7*A22)+($E$7)","v":680.15552000000002},-28044.291071999964,550.7585600000001,-3627.0792960000017,19.799999999999997]
[21.999999999999996,20651.163999999997,17599.999999999996,14651.163999999997,6000,938.68927272727285,800,665.9620000000001,-26284.291071999967,525.86600000000021,-3051.1640000000007,21.999999999999996]
[24.199999999999996,{"$f":"($B$2*(A24*A24*A24))+($C$2*(A24*A24))+($D$2*A24)+($E$2)","v":21781.698944},{"$f":"$D$5*A24","v":19359.999999999996},{"$f":"B24-$E$4","v":15781.698944},{"$f":"$E$4","v":6000},{"$f":"($C$6*(A24*A24))+($D$6*A24)+($E$6)+($F$6/A24)","v":900.07020429752083},800,{"$f":"($C$7*(A24*A24))+($D$7*A24)+($E$7)","v":652.13632000000007},-24524.291071999967,502.0769600000001,-2421.6989440000034,24.199999999999996]
[26.399999999999995,22861.111871999998,21119.999999999996,16861.111871999998,6000,865.95120727272729,800,638.67848000000004,-22764.291071999967,479.3914400000001,-1741.1118720000013,26.399999999999995]
[28.599999999999994,{"$f":"($B$2*(A26*A26*A26))+($C$2*(A26*A26))+($D$2*A26)+($E$2)","v":23891.830527999999},{"$f":"$D$5*A26","v":22879.999999999996},{"$f":"B26-$E$4","v":17891.830527999999},{"$f":"$E$4","v":6000},{"$f":"($C$6*(A26*A26))+($D$6*A26)+($E$6)+($F$6/A26)","v":835.37868979020993},800,{"$f":"($C$7*(A26*A26))+($D$7*A26)+($E$7)","v":625.58848000000012},-21004.291071999967,457.80944000000011,-1011.8305280000022,28.599999999999994]
[30.799999999999994,24876.282656000003,24639.999999999996,18876.282656000003,6000,807.67151480519487,800,612.86632000000009,-19244.291071999967,437.33096000000018,-236.28265600000668,30.799999999999994]
[32.999999999999993,{"$f":"($B$2*(A28*A28*A28))+($C$2*(A28*A28))+($D$2*A28)+($E$2)","v":25816.895999999997},{"$f":"$D$5*A28","v":26399.999999999993},{"$f":"B28-$E$4","v":19816.895999999997},{"$f":"$E$4","v":6000},{"$f":"($C$6*(A28*A28))+($D$6*A28)+($E$6)+($F$6/A28)","v":782.33018181818193},800,{"$f":"($C$7*(A28*A28))+($D$7*A28)+($E$7)","v":600.51200000000006},-17484.291071999971,417.95600000000013,583.10399999999572,32.999999999999993]
[35.199999999999996,{"$f":"($B$2*(A29*A29*A29))+($C$2*(A29*A29))+($D$2*A29)+($E$2)","v":26716.098303999999},{"$f":"$D$5*A29","v":28159.999999999996},{"$f":"B29-$E$4","v":20716.098303999999},{"$f":"$E$4","v":6000},{"$f":"($C$6*(A29*A29))+($D$6*A29)+($E$6)+($F$6/A29)","v":758.98006545454564},800,{"$f":"($C$7*(A29*A29))+($D$7*A29)+($E$7)","v":588.52552000000014},-15724.291071999967,399.68456000000015,1443.9016959999972,35.199999999999996]
[37.4,{"$f":"($B$2*(A30*A30*A30))+($C$2*(A30*A30))+($D$2*A30)+($E$2)","v":27576.317312000003},{"$f":"$D$5*A30","v":29920},{"$f":"B30-$E$4","v":21576.317312000003},{"$f":"$E$4","v":6000},{"$f":"($C$6*(A30*A30))+($D$6*A30)+($E$6)+($F$6/A30)","v":737.33468748663108},800,{"$f":"($C$7*(A30*A30))+($D$7*A30)+($E$7)","v":576.90688},-13964.291071999964,382.51664000000005,2343.6826879999971,37.4]
[{"$f":"A30+$A$14","v":39.6},28399.980768000001,31680,22399.980768000001,6000,717.17123151515159,800,565.65608000000009,-12204.291071999964,366.45224000000013,3280.0192319999987,39.6]
[41.800000000000004,29189.516415999999,33440,23189.516415999999,6000,698.31378985645938,800,554.77312000000006,-10444.291071999964,351.4913600000001,4250.4835840000014,41.800000000000004]
[44.000000000000007,29947.352000000006,35200.000000000007,23947.352000000006,6000,680.62163636363641,800,544.25800000000004,-8684.2910719999563,337.63400000000001,5252.648000000001,44.000000000000007]
[46.20000000000001,30675.915264000007,36960.000000000007,24675.915264000007,6000,663.98084987012987,800,534.11072000000001,-6924.2910719999563,324.88016000000005,6284.0847360000007,46.20000000000001]
[48.400000000000013,31377.633952000007,38720.000000000007,25377.633952000007,6000,648.29822214876026,800,524.33127999999999,-5164.2910719999563,313.22984000000002,7342.3660479999999,48.400000000000013]
[50.600000000000016,32054.935808000009,40480.000000000015,26054.935808000009,6000,633.49675509881422,800,514.91967999999997,-3404.2910719999491,302.68304000000012,8425.0641920000053,50.600000000000016]
[52.800000000000018,32710.248576000013,42240.000000000015,26710.248576000013,6000,619.51228363636358,800,505.87592000000001,-1644.2910719999491,293.23975999999993,9529.7514240000019,52.800000000000018]
[55.000000000000021,33346.000000000015,44000.000000000015,27346.000000000015,6000,606.29090909090905,800,497.20000000000005,115.70892800005095,284.90000000000009,10654,55.000000000000021]
[57.200000000000024,33964.617824000008,45760.000000000022,27964.617824000008,6000,593.78702489510488,800,488.89192000000003,1875.7089280000582,277.66376000000002,11795.382176000014,57.200000000000024]
[59.400000000000027,34568.529792000016,47520.000000000022,28568.529792000016,6000,581.96178101010094,800,480.95168000000001,3635.7089280000582,271.53104000000008,12951.470208000006,59.400000000000027]
[61.60000000000003,35160.163648000016,49280.000000000022,29160.163648000016,6000,570.78187740259739,800,473.37927999999999,5395.7089280000582,266.50184000000013,14119.836352000006,61.60000000000003]
[63.800000000000033,35741.947136000017,51040.000000000029,29741.947136000017,6000,560.21860714733532,800,466.17471999999998,7155.7089280000655,262.57616000000007,15298.052864000012,63.800000000000033]
[66.000000000000028,36316.308000000012,52800.000000000022,30316.308000000012,6000,550.24709090909084,800,459.33799999999997,8915.7089280000582,259.75399999999991,16483.69200000001,66.000000000000028]
[68.200000000000031,36885.673984000008,54560.000000000022,30885.673984000008,6000,540.84565958944279,800,452.86912000000001,10675.708928000058,258.03536000000008,17674.326016000014,68.200000000000031]
[{"$f":"A44+$A$14","v":70.400000000000034},37452.472832000014,56320.000000000029,31452.472832000014,6000,531.9953527272728,800,446.76808000000005,12435.708928000065,257.42024000000015,{"$f":"C45-B45","v":18867.527168000015},70.400000000000034]
[72.600000000000037,38019.132288000015,58080.000000000029,32019.132288000015,6000,523.6795080991734,800,441.03487999999993,14195.708928000065,{"$f":"($C$9*(A46*A46))+($D$9*A46)+($E$9)","v":257.9086400000001},20060.867712000014,72.600000000000037]
[74.80000000000004,38588.080096000012,59840.000000000029,32588.080096000012,6000,515.88342374331546,800,435.66952000000003,15955.708928000065,259.50056000000018,21251.919904000017,{"$f":"L46+$L$14","v":74.80000000000004}]
[77.000000000000043,39161.744000000021,61600.000000000036,33161.744000000021,6000,508.59407792207787,800,430.67200000000003,17715.708928000073,262.19600000000014,22438.256000000016,77.000000000000043]
[79.200000000000045,39742.551744000011,63360.000000000036,33742.551744000011,6000,501.79989575757577,800,426.04232000000007,19475.708928000073,265.99496000000033,23617.448256000025,79.200000000000045]
[81.400000000000048,40332.931072000014,65120.000000000036,34332.931072000014,6000,495.4905537100737,800,421.78048000000001,21235.708928000073,270.89744000000019,24787.068928000022,81.400000000000048]
[83.600000000000051,40935.309728000022,66880.000000000044,34935.309728000022,6000,489.65681492822961,800,417.88648000000001,22995.70892800008,276.90344000000027,25944.690272000022,83.600000000000051]
[85.800000000000054,41552.115456000014,68640.000000000044,35552.115456000014,6000,484.29038993006998,800,414.36032000000006,24755.70892800008,284.01296000000036,27087.88454400003,85.800000000000054]
[88.000000000000057,42185.776000000027,70400.000000000044,36185.776000000027,6000,479.38381818181813,800,411.202,26515.70892800008,292.22600000000023,28214.224000000017,88.000000000000057]
[90.20000000000006,42838.719104000033,72160.000000000044,36838.719104000033,6000,474.93036700665186,800,408.41152000000005,28275.70892800008,301.54256000000032,29321.280896000011,90.20000000000006]
[92.400000000000063,43513.372512000024,73920.000000000044,37513.372512000024,6000,470.92394493506492,800,405.98888000000005,30035.70892800008,311.96264000000042,30406.62748800002,92.400000000000063]
[94.600000000000065,44212.163968000037,75680.000000000058,38212.163968000037,6000,467.35902714587746,800,403.93408000000011,31795.708928000095,323.48624000000063,31467.836032000021,94.600000000000065]
[96.800000000000068,44937.521216000045,77440.000000000058,38937.521216000045,6000,464.23059107438013,800,402.24712,33555.708928000095,336.11336000000028,32502.478784000014,96.800000000000068]
[99.000000000000071,45691.872000000032,79200.000000000058,39691.872000000032,6000,461.53406060606068,800,400.92800000000011,35315.708928000095,349.84400000000073,33508.128000000026,99.000000000000071]
[101.20000000000007,46477.644064000044,80960.000000000058,40477.644064000044,6000,459.26525754940718,800,399.97672000000011,37075.708928000095,364.67816000000062,34482.355936000014,101.20000000000007]
[103.40000000000008,47297.265152000044,82720.000000000058,41297.265152000044,6000,457.42035930367507,800,399.39328000000006,38835.708928000095,380.61584000000062,35422.734848000015,103.40000000000008]
[{"$f":"A60+$A$14","v":105.60000000000008},48153.163008000047,84480.000000000058,42153.163008000047,6000,455.99586181818188,800,399.17768000000012,40595.708928000095,397.65704000000073,36326.836992000011,105.60000000000008]
[107.80000000000008,49047.765376000061,86240.000000000073,43047.765376000061,6000,454.98854708719864,800,399.32992000000019,42355.708928000109,415.80176000000097,37192.234624000012,107.80000000000008]
[110.00000000000009,49983.500000000058,88000.000000000073,43983.500000000058,6000,454.3954545454547,800,399.85000000000019,44115.708928000109,435.05000000000086,38016.500000000015,110.00000000000009]
[112.20000000000009,50962.79462400006,89760.000000000073,44962.79462400006,6000,454.21385582887712,800,400.73792000000014,45875.708928000109,455.40176000000088,38797.205376000013,112.20000000000009]
[114.40000000000009,51988.076992000046,91520.000000000073,45988.076992000046,6000,454.44123244755258,800,401.99368000000015,47635.708928000109,476.85704000000101,39531.923008000027,114.40000000000009]
[116.60000000000009,53061.774848000066,93280.000000000073,47061.774848000066,6000,455.07525598627797,800,403.61728000000016,49395.708928000109,499.41584000000103,40218.225152000006,116.60000000000009]
[118.8000000000001,54186.315936000065,95040.000000000073,48186.315936000065,6000,456.11377050505064,800,405.60872000000018,51155.708928000109,523.07816000000093,40853.684064000008,118.8000000000001]
[121.0000000000001,55364.12800000007,96800.000000000073,49364.12800000007,6000,457.55477685950427,800,407.96800000000019,52915.708928000109,547.84400000000119,41435.872000000003,121.0000000000001]
[123.2000000000001,56597.638784000083,98560.000000000087,50597.638784000083,6000,459.39641870129896,800,410.69512000000032,54675.708928000124,573.71336000000133,41962.361216000005,123.2000000000001]
[125.40000000000011,57889.276032000082,100320.00000000009,51889.276032000082,6000,461.63696995215338,800,413.79008000000033,56435.708928000124,600.68624000000159,42430.723968000006,125.40000000000011]
[127.60000000000011,59241.467488000082,102080.00000000009,53241.467488000082,6000,464.27482357366802,800,417.25288000000035,58195.708928000124,628.76264000000174,42838.532512000005,127.60000000000011]
[129.8000000000001,60656.640896000084,103840.00000000007,54656.640896000084,6000,467.3084814791992,800,421.08352000000048,59955.708928000109,657.94256000000178,43183.359103999988,129.8000000000001]
[{"$f":"A72+$A$14","v":132.00000000000009},62137.224000000075,105600.00000000007,56137.224000000075,6000,470.73654545454559,800,425.28200000000015,61715.708928000109,688.22600000000102,43462.775999999998,132.00000000000009]
[134.20000000000007,63685.644544000068,107360.00000000006,57685.644544000068,6000,474.55770897168429,800,429.84832000000029,63475.708928000095,719.61296000000107,43674.35545599999,134.20000000000007]
[136.40000000000006,65304.33027200005,109120.00000000004,59304.33027200005,6000,478.77074979472172,800,434.78248000000031,65235.70892800008,752.103440000001,43815.669727999993,136.40000000000006]
[138.60000000000005,66995.70892800008,110880.00000000004,60995.70892800008,6000,483.3745232900435,800,440.08448000000021,66995.70892800008,785.69744000000105,43884.291071999964,138.60000000000005]
[140.80000000000004,68762.208256000056,112640.00000000003,62762.208256000056,6000,488.36795636363661,800,445.75432000000023,68755.708928000065,820.39496000000076,{"$f":"C77-B77","v":43877.791743999973},140.80000000000004]
[143.00000000000003,70606.256000000038,114400.00000000003,64606.256000000038,6000,493.75004195804223,800,451.79200000000026,{"$f":"C78-$J$3","v":70515.708928000065},{"$f":"($C$9*(A78*A78))+($D$9*A78)+($E$9)","v":856.19600000000059},43793.743999999992,143.00000000000003]
[145.20000000000002,72530.279904000025,116160.00000000001,66530.279904000025,6000,499.51983404958708,{"$f":"$J$2","v":800},458.19752000000028,72275.708928000051,893.10056000000054,43629.72009599999,{"$f":"L78+$L$14","v":145.20000000000002}]
[{"$f":"A79+$A$14","v":147.4},74536.707712000047,117920,68536.707712000047,6000,505.67644309362288,800,464.97088000000008,74035.708928000036,931.10864000000015,43383.292287999953,147.4]
[149.6,76627.967168000017,119680,70627.967168000017,6000,512.21903187165788,800,472.11208000000011,75795.708928000036,970.22023999999988,43052.032831999983,149.6]
[151.79999999999998,78806.486015999995,121439.99999999999,72806.486015999995,6000,519.14681169960477,800,479.62112000000002,77555.708928000022,1010.4353599999997,42633.51398399999,151.79999999999998]
[153.99999999999997,81074.691999999981,123199.99999999997,75074.691999999981,6000,526.45903896103914,800,487.49800000000016,79315.708928000007,1051.7539999999997,42125.30799999999,153.99999999999997]
[156.19999999999996,83435.01286399996,124959.99999999997,77435.01286399996,6000,534.15501193341879,800,495.74272000000008,81075.708928000007,1094.1761599999993,41524.987136000011,156.19999999999996]
[158.39999999999995,85889.876351999977,126719.99999999996,79889.876351999977,6000,542.23406787878787,800,504.35527999999999,82835.708927999993,1137.701839999999,40830.123647999979,158.39999999999995]
[160.59999999999994,88441.710207999946,128479.99999999996,82441.710207999946,6000,550.69558037359889,800,513.33567999999991,84595.708927999993,1182.3310399999989,40038.28979200001,160.59999999999994]
[162.79999999999993,91092.942175999924,130239.99999999994,85092.942175999924,6000,559.53895685503653,800,522.68391999999972,86355.708927999978,1228.0637599999984,39147.057824000018,162.79999999999993]
[164.99999999999991,93845.999999999913,131999.99999999994,87845.999999999913,6000,568.76363636363601,800,532.39999999999964,88115.708927999978,1274.899999999998,38154.000000000029,164.99999999999991]
[{"$f":"A88+$A$14","v":167.1999999999999},96703.311423999869,133759.99999999991,90703.311423999869,6000,578.3690874641145,800,542.48391999999967,89875.708927999949,1322.8397599999978,37056.688576000044,167.1999999999999]
[169.39999999999989,99667.304191999894,135519.99999999991,93667.304191999894,6000,588.35480632821691,800,552.93567999999959,91635.708927999949,1371.8830399999977,35852.695808000019,169.39999999999989]
[171.59999999999988,102740.40604799986,137279.99999999991,96740.406047999859,6000,598.72031496503462,800,563.75527999999963,93395.708927999949,1422.0298399999972,34539.593952000054,171.59999999999988]
[173.79999999999987,105925.04473599981,139039.99999999988,99925.044735999807,6000,609.46515958573036,800,574.94271999999955,95155.70892799992,1473.2801599999973,33114.955264000077,173.79999999999987]
[175.99999999999986,109223.64799999981,140799.99999999988,103223.64799999981,6000,620.58890909090871,800,586.49799999999959,96915.70892799992,1525.6339999999966,31576.352000000072,175.99999999999986]
[178.19999999999985,{"$f":"($B$2*(A94*A94*A94))+($C$2*(A94*A94))+($D$2*A94)+($E$2)","v":112638.64358399977},{"$f":"$D$5*A94","v":142559.99999999988},{"$f":"B94-$E$4","v":106638.64358399977},{"$f":"$E$4","v":6000},{"$f":"($C$6*(A94*A94))+($D$6*A94)+($E$6)+($F$6/A94)","v":632.09115367003301},800,{"$f":"($C$7*(A94*A94))+($D$7*A94)+($E$7)","v":598.42111999999929},98675.70892799992,1579.0913599999965,29921.356416000111,178.19999999999985]
[{"$f":"A94+$A$14","v":180.39999999999984},116172.45923199976,144319.99999999985,110172.45923199976,6000,643.97150350332527,800,610.71207999999933,100435.70892799989,1633.652239999996,28147.540768000094,180.39999999999984]
[{"$f":"A95+$A$14","v":182.59999999999982},119827.52268799971,146079.99999999985,113827.52268799971,6000,656.22958755750199,800,623.37087999999926,102195.70892799989,1689.3166399999957,26252.477312000148,182.59999999999982]
[184.79999999999981,123606.26169599965,147839.99999999985,117606.26169599965,6000,668.86505246753131,800,636.39751999999885,103955.70892799989,1746.084559999995,24233.738304000202,184.79999999999981]
[186.9999999999998,127511.1039999997,149599.99999999985,121511.1039999997,6000,681.87756149732525,800,649.79199999999901,105715.70892799989,1803.9559999999949,22088.896000000153,186.9999999999998]
[189.19999999999979,131544.47734399964,151359.99999999983,125544.47734399964,6000,695.26679357293756,800,663.55431999999882,107475.70892799986,1862.9309599999945,19815.52265600019,189.19999999999979]
[191.39999999999978,135708.80947199962,153119.99999999983,129708.80947199962,6000,709.03244238244395,800,677.68447999999876,109235.70892799986,1923.0094399999937,17411.19052800021,191.39999999999978]
[193.59999999999977,140006.5281279996,154879.99999999983,134006.5281279996,6000,723.17421553718873,800,692.18247999999858,110995.70892799986,1984.1914399999935,14873.471872000227,193.59999999999977]
[195.79999999999976,144440.06105599951,156639.9999999998,138440.06105599951,6000,737.69183378957973,800,707.04831999999851,112755.70892799983,2046.4769599999934,12199.938944000285,195.79999999999976]
[197.99999999999974,149011.83599999949,158399.9999999998,143011.83599999949,6000,752.5850303030287,800,722.28199999999833,114515.70892799983,2109.8659999999918,9388.1640000003099,197.99999999999974]
[200.19999999999973,153724.28070399945,160159.9999999998,147724.28070399945,6000,767.85354997002833,800,737.88351999999827,116275.70892799983,2174.3585599999924,6435.7192960003449,200.19999999999973]
[202.39999999999972,158579.82291199945,161919.99999999977,152579.82291199945,6000,783.49714877470171,800,753.85287999999809,118035.7089279998,2239.9546399999908,3340.1770880003169,202.39999999999972]
[204.59999999999971,163580.89036799941,163679.99999999977,157580.89036799941,6000,799.51559319647902,800,770.19007999999803,119795.7089279998,2306.6542399999917,99.109632000356214,204.59999999999971]
[206.7999999999997,168729.91081599929,165439.99999999977,162729.91081599929,6000,815.90865965183548,800,786.89511999999786,121555.7089279998,2374.4573599999903,-3289.910815999523,206.7999999999997]
[208.99999999999969,174029.31199999928,167199.99999999974,168029.31199999928,6000,832.67613397128946,800,803.96799999999757,123315.70892799977,2443.3639999999896,-6829.3119999995397,208.99999999999969]
[211.19999999999968,179481.52166399918,168959.99999999974,173481.52166399918,6000,849.81781090908862,800,821.40871999999763,125075.70892799977,2513.3741599999894,-10521.521663999447,211.19999999999968]
[213.39999999999966,185088.96755199923,170719.99999999974,179088.96755199923,6000,867.3334936832216,800,839.21727999999757,126835.70892799977,2584.4878399999889,-14368.967551999493,213.39999999999966]
[{"$f":"A110+$A$14","v":215.59999999999965},190854.07740799911,172479.99999999971,184854.07740799911,6000,885.22299354359643,800,857.39367999999718,128595.70892799975,2656.705039999988,-18374.077407999401,215.59999999999965]
[217.79999999999964,196779.27897599901,174239.99999999971,190779.27897599901,6000,903.48612936638835,800,875.93791999999712,130355.70892799975,2730.0257599999877,-22539.278975999303,217.79999999999964]
[{"$f":"B10","v":220},202867.00000000006,176000,196867.00000000006,6000,922.12272727272762,800,894.85000000000036,132115.70892800004,2804.45,-26867.000000000058,{"$f":"B10","v":220}]

{"sheet":"Gesamtkosten","index":2,"n_rows":2,"n_cols":10,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,null,null,"8"]

{"sheet":"Stückkosten","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Gewinn","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Funktionen","index":5,"n_rows":36,"n_cols":15,"rows_kept":36,"cut":false,"hidden":false,"merged":[[5,11,5,12],[1,5,1,6],[1,11,1,12],[21,11,21,12],[13,1,13,4],[17,1,17,4],[1,1,1,4],[5,1,5,4],[1,7,1,10],[5,7,5,10],[17,5,17,6],[17,11,17,12],[13,5,13,6],[13,11,13,12],[9,5,9,6],[9,11,9,12],[9,1,9,4],[9,7,9,10],[5,5,5,6],[13,7,13,10],[17,7,17,10],[21,1,21,4],[21,5,21,6],[21,7,21,10],[33,1,33,4],[33,5,33,6],[33,7,33,10],[33,11,33,12],[25,1,25,4],[25,5,25,6],[25,7,25,10],[25,11,25,12],[29,1,29,4],[29,5,29,6],[29,7,29,10],[29,11,29,12]]}
[]
[null,"Aufgabe 1",null,null,null,"harmonisierende Werte",null,"Aufgabe 2",null,null,null,"harmonisierende Werte"]
["Funktion","aX3","bX2","cX","d","Preis","Xmax","aX3","bX2","cX","d","Preis","Xmax"]
["K",0.1,-2,15,50,8,16,0.5,-4,70,400,150,16]
[]
[null,"Aufgabe 3",null,null,null,"harmonisierende Werte",null,"Aufgabe 4",null,null,null,"harmonisierende Werte"]
["Funktion","aX3","bX2","cX","d","Preis","Xmax","aX3","bX2","cX","d","Preis","Xmax"]
["K",0.33333333300000001,-10,115,272.25,70,25,1,-9,30,16,16,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"1/25",{"$f":"1/25","v":0.04}]
[null,"Aufgabe 5",null,null,null,"harmonisierende Werte",null,"Aufgabe 6",null,null,null,"harmonisierende Werte",null,"1/75",{"$f":"1/75","v":1.3333333333333334E-2}]
["Funktion","aX3","bX2","cX","d","Preis","Xmax","aX3","bX2","cX","d","Preis","Xmax","1/40",{"$f":"1/40","v":2.5000000000000001E-2}]
["K",5,-60,250,200,140,10,3.7999999999999999E-2,-8.0399999999999991,824.45,6000,600,220,"1/60",{"$f":"1/60","v":1.6666666666666666E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"1/80",{"$f":"1/80","v":1.2500000000000001E-2}]
[null,"Aufgabe 7",null,null,null,"harmonisierende Werte",null,"Aufgabe 8",null,null,null,"harmonisierende Werte",null,"1/90",{"$f":"1/90","v":1.1111111111111112E-2}]
["Funktion","aX3","bX2","cX","d","Preis","Xmax","aX3","bX2","cX","d","Preis","Xmax","1/20",0.05]
["K",8.3000000000000004E-2,-8.4,790,5900,800,100,0.25,-2,10,100,40,16,"1/60",1.6666666666666666E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"1/80",1.2500000000000001E-2]
[null,"Aufgabe 9",null,null,null,"harmonisierende Werte",null,"Aufgabe 10",null,null,null,"harmonisierende Werte",null,"1/90",1.1111111111111112E-2]
["Funktion","aX3","bX2","cX","d","Preis","Xmax","aX3","bX2","cX","d","Preis","Xmax","1/45",{"$f":"1/45","v":2.2222222222222223E-2}]
["K",5,-60,250,200,200,12,3.3E-3,-0.25,10,1016,30,120,"1/8",0.125]
[]
[null,"Aufgabe 11",null,null,null,"harmonisierende Werte",null,"Aufgabe 12",null,null,null,"harmonisierende Werte"]
["Funktion","aX3","bX2","cX","d","Preis","Xmax","aX3","bX2","cX","d","Preis","Xmax"]
["K",0.01,-1,100,720,100,100,1E-3,-0.5,100,720,75,500]
[]
[null,"Aufgabe 3",null,null,null,"harmonisierende Werte",null,"Aufgabe 14",null,null,null,"harmonisierende Werte"]
["Funktion","aX3","bX2","cX","d","Preis","Xmax","aX3","bX2","cX","d","Preis","Xmax"]
["K",null,null,0.5,3,1,10,0.1,-5.3,120,300,75,45]
[]
[null,"Aufgabe 15",null,null,null,"harmonisierende Werte",null,"Aufgabe 16",null,null,null,"harmonisierende Werte"]
["Funktion","aX3","bX2","cX","d","Preis","Xmax","aX3","bX2","cX","d","Preis","Xmax"]
["K",0.01,-1.3,70,400,90,150,null,null,20,10000,200,200]
[]
[null,"Aufgabe 15",null,null,null,"harmonisierende Werte",null,"Aufgabe 16",null,null,null,"harmonisierende Werte"]
["Funktion","aX3","bX2","cX","d","Preis","Xmax","aX3","bX2","cX","d","Preis","Xmax"]
["K"]