{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Kontrolle","Tabellen","Gesamtanalyse","Stückbetrachtung","Gewinn und Verlust","Funktionen"],"not_rendered":{"charts":5,"images":3,"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":"Kontrolle","index":0,"n_rows":30,"n_cols":10,"rows_kept":30,"cut":false,"hidden":false,"merged":[[20,3,20,9],[21,3,21,9],[22,3,24,9],[14,1,18,2],[11,7,12,8],[11,9,12,9],[10,7,10,8],[1,1,1,9],[6,7,6,8],[3,7,3,8],[8,7,8,8],[9,7,9,8],[7,7,7,8],[29,3,30,14],[27,3,27,6],[26,3,26,6],[28,3,28,6],[26,7,28,14]]}
[]
[null,"Preisbildung im Monopol"]
[]
[null,null,null,null,null,null,null,"Erlös",null,{"$f":"Tabellen!J10","v":2620.686880507104}]
[null,"Funktionen","aX3","bX2","cx","d","d/x","Gesamtkosten",null,{"$f":"Tabellen!K10","v":1413.7808280515942}]
[null,"Gesamtkosten",0.33333333300000001,-10,150,500,null,"variable Gesamtkosten",null,{"$f":"Kontrolle!J5-Kontrolle!E6","v":1263.7808280515942}]
[null,"Preis-Absatz-Funktion ",null,null,-15,400,null,"fixe Gesamtkosten",null,{"$f":"Tabellen!D4","v":150}]
[null,"variable Gesamtkosten",{"$f":"C6","v":0.33333333300000001},{"$f":"D6","v":-10},{"$f":"E6","v":150},null,null,"Stückkosten",null,{"$f":"Tabellen!G12","v":122.06150675896221}]
[null,"Stückkosten",null,{"$f":"C6","v":0.33333333300000001},{"$f":"D6","v":-10},{"$f":"E6","v":150},{"$f":"F6","v":500},"variable Stückkosten",null,{"$f":"Tabellen!D7","v":-10}]
[null,"variable Stückkosten",null,{"$f":"C6","v":0.33333333300000001},{"$f":"E9","v":-10},{"$f":"E6","v":150},null,"fixe Stückkosten",null,{"$f":"Tabellen!I12","v":500}]
[null,"Grenzkosten",null,{"$f":"3*C6","v":0.99999999900000003},{"$f":"2*D6","v":-20},{"$f":"E6","v":150},null,"Grenzkosten",null,{"$f":"Tabellen!D9","v":-20}]
[null,"Erlös ",null,{"$f":"E7","v":-15},{"$f":"F7","v":400},null,null,"Absatzgrenze (Xmax)",null,{"$f":"(F7/E7)*-1","v":26.666666666666668}]
[null,"Grenzerlös ",null,null,{"$f":"2*D12","v":-30},{"$f":"E12","v":400}]
[]
[null,"Geben Sie nach Klick auf \"Eingabe\" die Kostenfunktion und die Preis-Absatz-Funktion ein. Oder kopieren Sie Beispielfunktionen in die entsprechenden Felder"]
[]
[]
[]
[]
[]
[null,"Extrempunkte","€"]
[null,"Gewinnmaximum",{"$f":"Tabellen!I10","v":1206.9060524555098},"größter Gesamtgewinn; größte Differenz zwischen Erlös und Kosten"]
[null,"Courtnotscher Punkt",null,"Die Cournotsche Menge ergibt sich aus dem Schnittpunkt zwischen Grenzkosten und Grenzerlös für die den definierten gewinnmaximalen Bereich. Eingesetzt in die entsprechende Preis-Absatz-Funktion wird der gewinnmaximale Preis ermittelt."]
[null,"   Preis",{"$f":"Tabellen!H10","v":226.26207898079352}]
[null,"   Menge",{"$f":"Tabellen!G10","v":11.582528067947099}]
[]
[null,null,null,"Plausibilitätskontrolle",null,null,null,"Im betriebswirtschaftlichen Unterricht ist es eine Herausforderung, harmonisierende Kosten- und Preis-Absatz-Funktionen zu finden. Wenn diese Funktionen nicht harmonieren, erhalten Sie einen Hinweis. Gründe könnten z.B. negative variable Stück- oder Grenzkosten, oder nicht eindeutig definierte Cournotpunkte sein. "]
[null,null,null,{"$f":"IF(OR(Tabellen!F116<=0,Kontrolle!F11>Kontrolle!F13,Tabellen!H116<=0),\"keine Funktionsharmonie!\",\"Funktionen harmonieren\")","v":"Funktionen harmonieren"}]
[null,null,null,{"$f":"IF(Tabellen!F116<=0,\"negative variable Stückkosten\",IF(F11>F13,\"Cournotpunkt nich eindeutig definiert'\",IF(Tabellen!H116<=0,\"negative Grenzkosten\",\"\")))","v":""}]
[null,null,null,"Bei kubischen Kostenfunktionen der Form ax3-bx2+cx+d müssen Sie auf der Seite 'Tabellen' die Berechnung der Cournotmenge durch Klick auf den Button 'Cournotsche Menge' aktivieren, da sie analystisch berechnet wird. Andernfalls wird die Cournotmenge nicht korrekt angezeigt."]

{"sheet":"Tabellen","index":1,"n_rows":116,"n_cols":15,"rows_kept":116,"cut":false,"hidden":false,"merged":[[0,6,0,10],[4,10,5,10],[1,6,3,8],[6,6,7,10],[24,14,25,14],[18,14,19,14],[21,13,21,15],[22,13,23,15],[0,13,2,15],[13,13,13,15],[14,14,15,14],[17,13,17,15],[3,13,11,15]]}
[null,"aX3","bX2","cx","d","d/x","Ausgabewerte ",null,null,null,null,null,null,"Analytische Berechnungen bei unterschiededlichen Grundformen der Kostenfunktion"]
["K=",{"$f":"Kontrolle!C6","v":0.33333333300000001},{"$f":"Kontrolle!D6","v":-10},{"$f":"Kontrolle!E6","v":150},{"$f":"Kontrolle!F6","v":500},null,"Gewinnmaximum tabellarisch",null,null,"Gmax",{"$f":"MAX(I15:I115)","v":1206.6816795149089}]
["Kv=",{"$f":"Kontrolle!C8","v":0.33333333300000001},{"$f":"Kontrolle!D8","v":-10},{"$f":"Kontrolle!E8","v":150},null,null,null,null,null,"XGmax",{"$f":"VLOOKUP(K2,I15:M115,5,FALSE)","v":11.466666666666676}]
["Kf=",null,null,{"$f":"D2","v":150},null,null,null,null,null,"PGmax",{"$f":"VLOOKUP(K2,I15:M115,4,FALSE)","v":227.99999999999986},null,null,"Bei kubischer Kostenfunktion wirddie Cournotmenge nach Klick auf 'Cournotsche Menge' berechnet. Bei Linearen und quadratische Kostenfunktionen wir die Cournotmenge dirket berechnet. (Quadratische Kostenfunktionen sind allerdings unrealtistisch und dienen nur dazu, den Lehrenden 'das Leben' leicht zu machenJ)"]
["E1=",null,{"$f":"Kontrolle!D12","v":-15},{"$f":"Kontrolle!E12","v":400},null,null,"Abweichungen der tabellarischen von der analystischen",null,null,null,{"$f":"100%-(K3/G10)","v":1.0003118542060929E-2}]
["k=",null,{"$f":"Kontrolle!D9","v":0.33333333300000001},{"$f":"Kontrolle!E9","v":-10},{"$f":"D2","v":150},{"$f":"Kontrolle!G9","v":500},"Gewinnermittlung. (analytischer Gewinn = 100%)"]
["kv=",null,{"$f":"Kontrolle!D10","v":0.33333333300000001},{"$f":"Kontrolle!E10","v":-10},{"$f":"Kontrolle!F10","v":150},null,"Gewinnmaximum analytisch / Cournotscher Punkt"]
["kf=",null,null,null,null,{"$f":"E2","v":500}]
["K'",null,{"$f":"Kontrolle!D11","v":0.99999999900000003},{"$f":"Kontrolle!E11","v":-20},{"$f":"Kontrolle!F11","v":150},null,"XGmax","PGmax","Gmax","E","K"]
["E'",null,null,{"$f":"Kontrolle!E13","v":-30},{"$f":"Kontrolle!F13","v":400},null,{"$f":"IF(AND(C9=0,D9=0),O15,IF(AND(C9=0,D9>0),O19,O25))","v":11.582528067947099},{"$f":"(G10*D11)+E11","v":226.26207898079352},{"$f":"J10-K10","v":1206.9060524555098},{"$f":"G10*H10","v":2620.686880507104},{"$f":"(B2*(G10*G10*G10))+(C2*(G10*G10))+(D2*G10)+E2","v":1413.7808280515942}]
["PAF",null,null,{"$f":"Kontrolle!E7","v":-15},{"$f":"Kontrolle!F7","v":400},null,"k","kv","kf","E'","K'"]
["Xmax",{"$f":"Kontrolle!J12","v":26.666666666666668},null,null,null,null,{"$f":"(C6*(G10*G10))+(D6*(G10))+(E6)+(F6/G10)","v":122.06150675896221},{"$f":"(C7*(G10*G10))+(D7*G10)+E7","v":78.893038090738159},{"$f":"F8","v":500},{"$f":"(D10*G10)+E10","v":52.524157961587036},{"$f":"(C9*(G10*G10))+(D9*G10)+E9","v":52.504394951685441}]
[]
["X","K","Kv","Kf","k","kv","kf","K'","E-K","E","E'","PAF1","X","K = cx + d"]
[0,{"$f":"($B$2*(A15*A15*A15))+($C$2*(A15*A15))+($D$2*A15)+($E$2)","v":500},{"$f":"($B$2*(A15*A15*A15))+($C$2*(A15*A15))+($D$2*A15)","v":0},{"$f":"$E$2","v":500},null,null,null,null,{"$f":"J15-B15","v":-500},{"$f":"($C$5*(A15*A15))+($D$5*A15)","v":0},{"$f":"($D$10*A15)+$E$10","v":400},{"$f":"($D$11*A15)+$E$11","v":400},0,null,{"$f":"IF(AND(C9=0,D9=0),(E10-E9)/(D10*-1),\"\")","v":""}]
[{"$f":"$B$12/100","v":0.26666666666666666},{"$f":"($B$2*(A16*A16*A16))+($C$2*(A16*A16))+($D$2*A16)+($E$2)","v":539.29520987653689},39.295209876536887,{"$f":"$E$2","v":500},{"$f":"B16/A16","v":2022.3570370370132},{"$f":"C16/A16","v":147.35703703701333},{"$f":"$F$6/A16","v":1875},{"$f":"($C$9*(A16*A16))+($D$9*(A16))+$E$9","v":144.73777777770667},-433.69520987653686,{"$f":"($C$5*(A16*A16))+($D$5*A16)","v":105.60000000000001},{"$f":"($D$10*A16)+$E$10","v":392},{"$f":"($D$11*A16)+$E$11","v":396},{"$f":"B12/100","v":0.26666666666666666}]
[{"$f":"A16+$A$16","v":0.53333333333333333},{"$f":"($B$2*(A17*A17*A17))+($C$2*(A17*A17))+($D$2*A17)+($E$2)","v":577.20612345673953},77.206123456739562,500,1082.2614814813867,144.76148148138668,937.5,{"$f":"($C$9*(A17*A17))+($D$9*(A17))+$E$9","v":139.61777777749333},-368.13945679007287,209.06666666666666,384,392,{"$f":"M16+$M$16","v":0.53333333333333333}]
[{"$f":"A17+$A$16","v":0.8},613.77066666649603,113.770666666496,500,767.21333333311998,142.21333333311998,625,134.63999999935999,-303.37066666649605,310.39999999999998,376,388,0.8,"K = bx2 + cx + d"]
[{"$f":"A18+$A$16","v":1.0666666666666667},649.02676543169423,149.02676543169423,500,608.46259259221335,139.71259259221335,468.75,129.80444444330666,-239.42676543169421,409.6,368,384,1.0666666666666667,null,{"$f":"IF(D9>0,(E10-E9)/(D9+(D10*-1)),\"\")","v":""}]
[1.3333333333333333,683.01234567822223,183.01234567822223,500,512.2592592586667,137.25925925866667,375,125.11111110933334,-176.34567901155566,506.66666666666657,360,380,1.3333333333333333]
[1.5999999999999999,715.76533333196801,215.76533333196798,500,447.35333333248002,134.85333333247999,312.5,120.55999999744,-114.16533333196799,601.6,352,376,1.5999999999999999]
[1.8666666666666665,747.32365431881954,247.32365431881951,500,400.3519576707962,132.49481481365333,267.85714285714289,116.15111110762666,-52.923654318819558,694.4,344,372,1.8666666666666665,"K = ax3 - bx2 + cx + d"]
[2.1333333333333333,777.7252345646649,277.7252345646649,500,364.55870370218668,130.18370370218668,234.375,111.88444443989334,7.3414321020018178,785.06666666666672,336,368,2.1333333333333333]
[2.4,807.00799999539208,307.00799999539203,500,336.25333333141339,127.91999999808002,208.33333333333334,107.75999999423999,66.592000004607939,873.6,328,364,2.4]
[2.6666666666666665,835.20987653688894,335.20987653688888,500,313.20370370133338,125.70370370133334,187.5,103.77777777066667,124.79012346311094,959.99999999999989,320,360,2.6666666666666665,null,11.582528067947099]
[2.9333333333333331,862.36879011504357,362.36879011504351,500,293.98936026649216,123.53481481194666,170.45454545454547,99.937777769173337,181.89787655162309,1044.2666666666667,312,356,2.9333333333333331]
[3.1999999999999997,888.52266665574393,388.52266665574393,500,277.66333332992002,121.41333332991999,156.25,96.239999989760008,237.87733334425616,1126.4000000000001,304,352,3.1999999999999997,null,{"$f":"((D10*O25)+(D9*-1*O25)+E10-E9)/C9","v":134.17471945470371}]
[3.4666666666666663,913.70943208487824,413.70943208487824,500,263.57002848602258,119.33925925525335,144.23076923076925,92.684444432426673,292.69056791512162,1206.3999999999999,296,348,3.4666666666666663,null,{"$f":"SQRT(O27)","v":11.583381175403998}]
[3.7333333333333329,937.96701232833414,437.96701232833414,500,251.2411640165181,117.31259258794665,133.92857142857144,89.271111097173332,346.29965433833252,1284.2666666666667,288,344,3.7333333333333329,null,{"$f":"O28/O25","v":1.0000736546850475}]
[3.9999999999999996,961.33333331199992,461.33333331199992,500,240.33333332800001,115.33333332799999,125.00000000000001,85.999999984000013,398.66666668799985,1359.9999999999998,280,340,3.9999999999999996]
[4.2666666666666666,983.84632096176358,483.84632096176358,500,230.58898147541333,113.40148147541333,117.1875,82.871111092906673,449.75367903823656,1433.6000000000001,272,336,4.2666666666666666]
[4.5333333333333332,1005.5439012035129,505.54390120351292,500,221.8111546772455,111.51703703018667,110.29411764705883,79.884444423893342,499.52276546315375,1505.0666666666666,264,332,4.5333333333333332]
[4.8,1026.4639999631361,526.46399996313608,500,213.84666665898669,109.67999999232002,104.16666666666667,77.039999976960004,547.93600003686402,1574.4,256,328,4.8]
[5.0666666666666664,1046.6445431665209,546.64454316652086,500,206.57458088812913,107.89037036181334,98.684210526315795,74.337777752106675,594.95545683347905,1641.6,248,324,5.0666666666666664]
[5.333333333333333,1066.1234567395554,566.12345673955554,500,199.89814813866664,106.14814813866667,93.75,71.777777749333339,640.54320992711109,1706.6666666666665,240,320,5.333333333333333]
[5.6,1084.938666608128,584.93866660812796,500,193.73904760859429,104.45333332288,89.285714285714292,69.359999968639997,684.66133339187218,1769.6000000000001,232,316,5.6]
[5.8666666666666663,1103.1280986981262,603.12809869812622,500,188.03319864172607,102.80592591445334,85.227272727272734,67.084444410026663,727.27190130187387,1830.4,224,312,5.8666666666666663]
[6.1333333333333329,1120.7296789354382,620.72967893543819,500,182.72766504382145,101.20592591338666,81.521739130434796,64.951111073493337,768.33698773122819,1889.0666666666664,216,308,6.1333333333333329]
[6.3999999999999995,1137.7813332459518,637.78133324595194,500,177.77833331968,99.653333319680002,78.125,62.959999959040005,807.81866675404831,1945.6000000000001,208.00000000000003,304,6.3999999999999995]
[6.6666666666666661,1154.3209875555556,654.32098755555558,500,173.14814813333336,98.148148133333351,75,61.11111106666668,845.67901244444442,2000,200.00000000000003,300,6.6666666666666661]
[6.9333333333333327,1170.386567790137,670.38656779013695,500,168.80575496973131,96.690370354346683,72.115384615384627,59.404444396373336,881.88009887652947,2052.2666666666664,192.00000000000003,296,6.9333333333333327]
[7.1999999999999993,1186.0159998755842,686.01599987558416,500,164.72444442716449,95.279999982720028,69.444444444444457,57.839999948159999,916.38400012441548,2102.3999999999996,184.00000000000003,292,7.1999999999999993]
[7.4666666666666659,1201.2472097377847,701.24720973778471,500,160.88132273273905,93.917037018453314,66.964285714285722,56.417777722026671,949.15279026221538,2150.4,176.00000000000003,288,7.4666666666666659]
[7.7333333333333325,1216.1181233026275,716.11812330262751,500,157.25665387533979,92.601481461546669,64.65517241379311,55.137777717973336,980.14854336403891,2196.2666666666664,168.00000000000003,284,7.7333333333333325]
[7.9999999999999991,1230.6666664959998,730.66666649599983,500,153.83333331200001,91.333333311999993,62.500000000000007,53.999999936000023,1009.3333335040002,2240,160.00000000000003,280,7.9999999999999991]
[8.2666666666666657,1244.9307652437901,744.93076524379012,500,150.59646353755528,90.11259256981333,60.483870967741943,53.004444376106676,1036.6692347562093,2281.5999999999995,152.00000000000003,276,8.2666666666666657]
[8.5333333333333332,1258.9483454718861,{"$f":"($B$2*(A47*A47*A47))+($C$2*(A47*A47))+($D$2*A47)","v":758.94834547188623},500,147.53300923498665,88.939259234986665,58.59375,52.151111038293351,{"$f":"J47-B47","v":1062.1183211947805},2321.0666666666666,144,272,8.5333333333333332]
[8.8000000000000007,1272.757333106176,772.75733310617602,500,{"$f":"B48/A48","v":144.63151512570181},{"$f":"C48/A48","v":87.813333307519997},56.818181818181813,51.43999992256002,1085.6426668938245,2358.4000000000005,136,268,8.8000000000000007]
[9.0666666666666682,1286.3956540725476,786.3956540725477,500,141.88187361094273,86.734814787413328,55.147058823529406,50.871111028906668,1107.2043459274528,2393.6000000000004,127.99999999999994,264,{"$f":"M48+$M$16","v":9.0666666666666682}]
[9.3333333333333357,1299.901234296889,799.90123429688913,500,139.27513224609521,85.70370367466667,53.571428571428555,50.444444357333339,1126.765432369778,2426.666666666667,119.99999999999994,260,9.3333333333333357]
[9.6000000000000032,1313.3119997050881,813.31199970508806,500,136.80333330261328,84.719999969279982,52.083333333333314,50.159999907840017,1144.2880002949123,2457.6000000000004,111.99999999999989,255.99999999999994,9.6000000000000032]
[9.8666666666666707,1326.6658762230331,826.66587622303314,500,134.45937934692898,83.783703671253321,50.675675675675656,50.017777680426661,1159.7341237769674,2486.4000000000005,103.99999999999989,251.99999999999994,9.8666666666666707]
[10.133333333333338,1340.0007897766118,840.00078977661178,500,132.23692004374453,82.894814780586643,49.342105263157869,50.017777675093328,1173.0658768900557,2513.0666666666675,95.999999999999829,247.99999999999991,10.133333333333338]
[10.400000000000006,1353.3546662917122,853.35466629171219,500,130.13025637420301,82.053333297279977,48.076923076923052,50.159999891840016,1184.2453337082877,2537.6,87.999999999999829,243.99999999999991,10.400000000000006]
[10.666666666666673,1366.7654316942226,866.76543169422246,500,128.13425922133328,81.259259221333309,46.874999999999972,50.444444330666684,1193.2345683057783,2560.0000000000009,79.999999999999829,239.99999999999991,10.666666666666673]
[10.933333333333341,1380.2710119100307,880.27101191003067,500,126.2442998698198,80.512592552746653,45.731707317073138,50.87111099157336,1199.9956547566371,2580.2666666666678,71.999999999999773,235.99999999999989,10.933333333333341]
[11.200000000000008,1393.9093328650242,893.90933286502423,500,124.45619043437708,79.813333291519967,44.64285714285711,51.439999874560016,1204.4906671349768,2598.400000000001,63.999999999999773,231.99999999999989,11.200000000000008]
[11.466666666666676,1407.7183204850921,907.71832048509214,500,122.76613260044398,79.161481437653322,43.604651162790667,52.151110979626708,1206.6816795149089,2614.400000000001,55.999999999999716,227.99999999999986,11.466666666666676]
[11.733333333333343,1421.7359006961212,921.73590069612123,500,121.17067335478296,78.557036991146632,42.613636363636331,53.004444306773394,1206.5307659705461,2628.2666666666673,47.999999999999716,223.99999999999986,11.733333333333343]
[12.000000000000011,1435.9999994240006,935.99999942400063,500,119.66666661866661,77.999999951999982,41.666666666666629,53.999999856000045,1204.0000005760003,2640.0000000000009,39.999999999999659,219.99999999999983,12.000000000000011]
[12.266666666666678,1450.5485425946176,950.54854259461763,500,118.25123988543068,77.490370320213316,40.760869565217355,55.137777627306718,1199.0514574053832,2649.6000000000008,31.999999999999659,215.99999999999983,12.266666666666678]
[12.533333333333346,1465.4194561338602,965.41945613386019,500,116.9217651170632,77.028148095786648,39.893617021276555,56.417777620693414,1191.6472105328069,2657.0666666666671,23.999999999999659,211.99999999999983,12.533333333333346]
[12.800000000000013,1480.6506659676165,980.65066596761665,500,115.67583327871992,76.613333278719978,39.062499999999957,57.839999836160075,1181.7493340323836,2662.4,15.999999999999602,207.9999999999998,12.800000000000013]
[13.066666666666681,1496.2800980217751,996.28009802177507,500,114.51123199146225,76.24592586901332,38.265306122448941,59.404444273706787,1169.3199019782253,2665.6000000000004,7.9999999999996021,203.9999999999998,13.066666666666681]
[13.333333333333348,1512.3456782222233,1012.3456782222232,500,113.42592586666663,75.92592586666666,37.499999999999957,61.111110933333435,1154.3209884444436,2666.666666666667,-4.5474735088646412E-13,199.99999999999977,13.333333333333348]
[13.600000000000016,1528.8853324948486,1028.8853324948486,500,112.41803915403285,75.653333271679955,36.764705882352899,62.959999815040106,1136.7146675051513,2665.6,-8.0000000000004547,195.99999999999977,13.600000000000016]
[13.866666666666683,1545.9369867655405,1045.9369867655405,500,111.48584039174558,75.428148084053305,36.057692307692264,64.951110918826799,1116.4630132344596,2662.4,-16.000000000000512,191.99999999999974,13.866666666666683]
[14.133333333333351,1563.538566960186,1063.538566960186,500,110.62772879435265,75.250370303786653,35.377358490565996,67.084444244693486,1093.5280997064801,2657.0666666666662,-24.000000000000512,187.99999999999974,14.133333333333351]
[14.400000000000018,1581.7279990046732,1081.7279990046732,500,109.84222215310217,75.119999930879985,34.722222222222179,69.359999792640195,1067.8720009953263,2649.5999999999995,-32.000000000000568,183.99999999999972,14.400000000000018]
[14.666666666666686,1600.5432088248899,1100.5432088248899,500,109.12794605624235,75.0370369653333,34.090909090909044,71.777777562666842,1039.4567911751096,2639.9999999999995,-40.000000000000568,179.99999999999972,14.666666666666686]
[14.933333333333353,1620.0221223467254,1120.0221223467254,500,108.4836242642895,75.001481407146684,33.482142857142811,74.33777755477351,1008.2445443199406,2628.266666666666,-48.000000000000568,175.99999999999972,14.933333333333353]
[15.200000000000021,1640.2026654960659,1140.2026654960659,500,107.90807009842524,75.013333256320024,32.894736842105218,77.039999768960229,974.19733450393278,2614.3999999999987,-56.000000000000625,171.99999999999969,15.200000000000021]
[15.466666666666688,1661.1227641988,1161.1227641988,500,107.40017871974986,75.072592512853348,32.327586206896505,79.884444205226913,937.27723580119823,2598.3999999999983,-64.000000000000625,167.99999999999969,15.466666666666688]
[15.733333333333356,1682.8203443808161,1182.8203443808161,500,106.95892019369579,75.179259176746683,31.779661016949106,82.87111086357362,897.44632228584896,2580.2666666666651,-72.000000000000682,163.99999999999966,15.733333333333356]
[16.000000000000021,1705.3333319680019,1205.3333319680019,500,106.58333324799997,75.333333248000017,31.249999999999957,85.999999744000235,854.66666803199632,2559.9999999999982,-80.000000000000625,159.99999999999969,16.000000000000021]
[16.266666666666687,1728.6996528862455,1228.6996528862455,500,106.27251964464611,75.534814726613362,30.737704918032748,89.271110846506986,808.90034711375301,2537.5999999999985,-88.000000000000625,155.99999999999969,16.266666666666687]
[16.533333333333353,1752.9572330614344,1252.9572330614344,500,106.0256390964576,75.783703612586663,30.241935483870932,92.684444171093617,760.10943360523038,2513.0666666666648,-96.000000000000568,151.99999999999972,16.533333333333353]
[16.800000000000018,1778.1439984194576,1278.1439984194576,500,105.84190466782474,76.079999905920005,29.761904761904731,96.239999717760327,708.25600158054021,2486.3999999999978,-104.00000000000057,147.99999999999972,16.800000000000018]
[17.066666666666684,1804.2978748862029,{"$f":"($B$2*(A79*A79*A79))+($C$2*(A79*A79))+($D$2*A79)","v":1304.2978748862029},500,105.72057860661334,76.423703606613373,29.296874999999972,99.937777486506945,{"$f":"J79-B79","v":653.30212511379477},2457.5999999999976,-112.00000000000057,143.99999999999972,17.066666666666684]
[17.33333333333335,1831.4567883875573,1331.4567883875573,{"$f":"$E$2","v":500},{"$f":"B80/A80","v":105.66096856082051},{"$f":"C80/A80","v":76.814814714666696},{"$f":"$F$6/A80","v":28.846153846153818},103.77777747733364,595.2098782791079,{"$f":"($C$5*(A80*A80))+($D$5*A80)","v":2426.6666666666652},{"$f":"($D$10*A80)+$E$10","v":-120.00000000000045},{"$f":"($D$11*A80)+$E$11","v":139.99999999999977},17.33333333333335]
[17.600000000000016,{"$f":"($B$2*(A81*A81*A81))+($C$2*(A81*A81))+($D$2*A81)+($E$2)","v":1859.6586648494092},1359.6586648494092,500,105.66242413917088,77.253333230080003,28.409090909090885,{"$f":"($C$9*(A81*A81))+($D$9*(A81))+$E$9","v":107.75999969024025},533.94133515058843,2393.5999999999976,-128.00000000000045,135.99999999999977,{"$f":"M80+$M$16","v":17.600000000000016}]
[17.866666666666681,1888.9414301976481,1388.9414301976481,500,105.72433377971902,77.739259152853379,27.98507462686565,111.88444412522693,469.45856980234976,2358.3999999999978,-136.00000000000045,131.99999999999977,17.866666666666681]
[{"$f":"A82+$A$16","v":18.133333333333347},1919.34301035816,1419.34301035816,500,105.84612189475139,78.27259248298671,27.573529411764685,116.15111078229359,401.72365630850391,2321.0666666666639,-144.00000000000045,127.99999999999977,18.133333333333347]
[18.400000000000013,1950.9013312568336,1450.9013312568336,500,106.02724626395828,78.853333220480039,27.17391304347824,120.55999966144026,330.69866874316494,2281.5999999999985,-152.00000000000034,123.99999999999983,18.400000000000013]
[18.666666666666679,1983.6543188195574,1483.6543188195574,500,106.26719565104764,79.48148136533338,26.78571428571427,125.1111107626669,256.34568118044081,2239.9999999999982,-160.00000000000034,119.99999999999983,18.666666666666679]
[18.933333333333344,2017.6398989722188,1517.6398989722188,500,106.56548762177206,80.157036917546719,26.408450704225338,129.80444408597356,178.6267676944467,2196.2666666666655,-168.00000000000034,115.99999999999983,18.933333333333344]
[19.20000000000001,2052.8959976407054,1552.8959976407054,500,106.92166654378669,80.879999877120028,26.041666666666654,134.63999963136018,97.504002359292372,2150.3999999999978,-176.00000000000034,111.99999999999983,19.20000000000001]
[19.466666666666676,2089.4605407509061,1589.4605407509061,500,107.33530175090266,81.650370244053363,25.684931506849303,139.61777739882689,12.939459249092579,2102.3999999999987,-184.00000000000023,107.99999999999989,19.466666666666676]
[19.733333333333341,2127.3714542287089,1627.3714542287089,500,107.80598585618453,82.468148018346696,25.337837837837828,144.7377773883735,-75.104787562044294,2052.2666666666646,-192.00000000000023,103.99999999999989,19.733333333333341]
[20.000000000000007,2166.6666640000008,1666.6666640000008,500,108.3333332,83.333333200000013,24.999999999999993,149.99999960000019,-166.66666400000258,1999.9999999999982,-200.00000000000023,99.999999999999886,20.000000000000007]
[20.266666666666673,2207.3840959906711,1707.3840959906711,500,108.91697842059229,84.245925789013356,24.671052631578942,155.4044440337068,-261.78409599067254,1945.5999999999985,-208.00000000000023,95.999999999999886,20.266666666666673]
[20.533333333333339,2249.5616761266069,1749.5616761266069,500,109.55657513603602,85.205925785386682,24.350649350649345,160.95111068949348,-360.49500945994123,1889.0666666666657,-216.00000000000011,91.999999999999943,20.533333333333339]
[20.800000000000004,2293.2373303336972,1793.2373303336972,500,110.25179472758157,86.213333189120036,24.038461538461533,166.63999956736006,-462.83733033369754,1830.3999999999996,-224.00000000000011,87.999999999999943,20.800000000000004]
[21.06666666666667,2338.4489845378284,1838.4489845378284,500,111.00232521540323,87.268148000213358,23.73417721518987,172.47111066730679,-568.84898453782898,1769.5999999999995,-232.00000000000011,83.999999999999943,21.06666666666667]
[21.333333333333336,2385.2345646648891,1885.2345646648891,500,111.80787021866666,88.370370218666665,23.437499999999996,178.44444398933337,-678.56789799822309,1706.6666666666661,-240.00000000000011,79.999999999999943,21.333333333333336]
[21.6,2433.6319966407682,1933.6319966407682,500,112.66814799262815,89.519999844479997,23.148148148148145,184.55999953344008,-792.03199664076874,1641.5999999999995,-248,76,21.6]
[21.866666666666667,2483.6792063913535,1983.6792063913535,500,113.58289053618995,90.717036877653356,22.865853658536587,190.81777729962664,-909.27920639135391,1574.3999999999996,-256,72,21.866666666666667]
[22.133333333333333,2535.4141198425318,2035.4141198425318,500,114.55184276396982,91.961481318186685,22.590361445783135,197.21777728789334,-1030.3474531758643,1505.0666666666675,-264,68,22.133333333333333]
[22.4,2588.8746629201919,2088.8746629201919,500,115.57476173750858,93.253333166079997,22.321428571428573,203.75999949823995,-1155.2746629201906,1433.6000000000013,-272,64,22.4]
[22.666666666666664,2644.0987615502218,2144.0987615502218,500,116.65141595074509,94.592592421333322,22.058823529411768,210.44444393066669,-1284.0987615502218,1360,-279.99999999999989,60.000000000000057,22.666666666666664]
[22.93333333333333,2701.1243416585094,2201.1243416585094,500,117.781584665342,95.979259083946644,21.802325581395351,217.27111058517323,-1416.8576749918411,1284.2666666666682,-287.99999999999989,56.000000000000057,22.93333333333333]
[23.199999999999996,2759.9893291709436,2259.9893291709436,500,118.96505729185104,97.413333153920007,21.551724137931039,224.23999946175991,-1553.5893291709422,1206.4000000000015,-295.99999999999989,52.000000000000057,23.199999999999996]
[23.466666666666661,2820.7316500134102,2320.7316500134102,500,120.20163281307148,98.894814631253297,21.306818181818187,231.3511105604266,-1694.3316500134088,1126.4000000000015,-303.99999999999989,48.000000000000057,23.466666666666661]
[23.733333333333327,2883.3892301117994,2383.3892301117994,500,121.49111924628372,100.42370351594663,21.067415730337085,238.60444388117321,-1839.1225634451312,1044.2666666666682,-311.99999999999977,44.000000000000114,23.733333333333327]
[23.999999999999993,2947.9999953919987,2447.9999953919987,500,122.83333314133331,101.99999980799997,20.833333333333339,245.99999942399984,-1987.9999953919969,960.00000000000182,-319.99999999999977,40.000000000000114,23.999999999999993]
[24.266666666666659,3014.6018717798947,2514.6018717798947,500,124.22809911180889,103.62370350741328,20.604395604395613,253.53777718890649,-2141.0018717798907,873.600000000004,-327.99999999999977,36.000000000000114,24.266666666666659]
[24.533333333333324,3083.2327852013773,2583.2327852013773,500,125.67524939679532,105.29481461418661,20.380434782608702,261.21777717589316,-2298.1661185347079,785.06666666666933,-335.99999999999977,32.000000000000114,24.533333333333324]
[24.79999999999999,3153.9306615823339,2653.9306615823339,500,127.17462345090061,107.01333312831996,20.161290322580655,269.03999938495974,-2459.5306615823306,694.40000000000327,-343.99999999999966,28.000000000000171,24.79999999999999]
[25.066666666666656,3226.7334268486511,2726.7334268486511,500,128.72606756045155,108.77925904981326,19.946808510638306,277.00444381610635,-2625.1334268486471,601.600000000004,-351.99999999999966,24.000000000000171,25.066666666666656]
[25.333333333333321,3301.6790069262188,2801.6790069262188,500,130.32943448392976,110.59259237866658,19.736842105263168,285.11111046933297,-2795.0123402595473,506.66666666667152,-359.99999999999966,20.000000000000171,25.333333333333321]
[25.599999999999987,3378.8053277409244,2878.8053277409244,500,131.98458311487994,112.45333311487991,19.531250000000011,293.35999934463962,{"$f":"J111-B111","v":-2969.2053277409204},409.600000000004,-367.99999999999966,16.000000000000171,25.599999999999987]
[25.866666666666653,3458.1503152186547,2958.1503152186547,500,133.6913781656697,114.36148125845321,19.329896907216504,301.75111044202629,-3147.7503152186496,310.40000000000509,-375.99999999999955,12.000000000000227,25.866666666666653]
[26.133333333333319,3539.7518952853002,3039.7518952853002,500,135.44968987061105,116.31703680938655,19.132653061224502,310.28444376149287,-3330.685228618629,209.06666666667115,-383.99999999999955,8.0000000000002274,26.133333333333319]
[26.399999999999984,3623.6479938667476,3123.6479938667476,500,137.25939370707385,118.3199997676799,18.939393939393952,318.95999930303947,-3518.0479938667399,105.60000000000764,-391.99999999999955,4.0000000000002274,26.399999999999984]
[26.66666666666665,3709.8765368888839,3209.8765368888839,500,139.12037013333324,120.37037013333322,18.750000000000011,327.77777706666609,-3709.8765368888839,0,-399.99999999999955,0,26.66666666666665]
[null,null,null,null,null,{"$f":"MIN(F16:F115)","v":75.001481407146684},null,{"$f":"MIN(H16:H115)","v":50.017777675093328},null,{"$f":"MAX(I15:I115)","v":1206.6816795149089},{"$f":"MAX(J15:J115)","v":2666.666666666667}]

{"sheet":"Gesamtanalyse","index":2,"n_rows":8,"n_cols":9,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"Tabellen!G10","v":11.582528067947099},0]
[null,null,null,null,null,null,null,{"$f":"H7","v":11.582528067947099},{"$f":"Tabellen!#REF!","v":{"$error":"#REF!"}}]

{"sheet":"Stückbetrachtung","index":3,"n_rows":6,"n_cols":11,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"Tabellen!G10","v":11.582528067947099},0,0,{"$f":"I6","v":226.26207898079352}]
[null,null,null,null,null,null,null,{"$f":"H5","v":11.582528067947099},{"$f":"Tabellen!H10","v":226.26207898079352},{"$f":"H5","v":11.582528067947099},{"$f":"I6","v":226.26207898079352}]

{"sheet":"Gewinn und Verlust","index":4,"n_rows":6,"n_cols":9,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"Tabellen!G10","v":11.582528067947099},0]
[null,null,null,null,null,null,null,{"$f":"H5","v":11.582528067947099},{"$f":"Tabellen!J116","v":1206.6816795149089}]

{"sheet":"Funktionen","index":5,"n_rows":79,"n_cols":16,"rows_kept":79,"cut":false,"hidden":false,"merged":[[70,9,70,12],[75,9,75,12],[50,9,50,12],[55,9,55,12],[60,9,60,12],[65,9,65,12],[35,9,35,12],[40,1,40,4],[40,5,40,8],[40,9,40,12],[45,9,45,12],[45,1,45,4],[45,5,45,8],[55,1,55,4],[55,5,55,8],[5,9,5,12],[10,1,10,4],[10,5,10,8],[10,9,10,12],[15,1,15,4],[15,5,15,8],[15,9,15,12],[20,9,20,12],[25,1,25,4],[25,5,25,8],[25,9,25,12],[30,1,30,4],[30,5,30,8],[30,9,30,12],[50,1,50,4],[50,5,50,8],[75,1,75,4],[75,5,75,8],[5,1,5,4],[5,5,5,8],[20,1,20,4],[20,5,20,8],[35,1,35,4],[35,5,35,8],[65,1,65,4],[65,5,65,8],[70,1,70,4],[70,5,70,8],[60,1,60,4],[60,5,60,8]]}
[]
[]
[]
[]
[]
[null,"Aufgabe 1",null,null,null,"Aufgabe 2",null,null,null,"Aufgabe 3",null,null,null,"1/25",{"$f":"1/P6","v":0.04},25]
["Funktion","aX3","bX2","cX","d","aX3","bX2","cX","d","aX3","bX2","cX","d","1/75",{"$f":"1/P7","v":1.3333333333333334E-2},75]
["K",null,null,300,10000,null,null,4,5100,null,null,4,5100,"1/125",8.0000000000000002E-3,125]
["PAF",null,null,-15,1200,null,null,1.25E-3,15,null,null,-0.01,22,"1/40",2.5000000000000001E-2,40]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"1/60",1.6666666666666666E-2,60]
[null,"Aufgabe 4",null,null,null,"Aufgabe 5",null,null,null,"Aufgabe 6",null,null,null,"1/80",1.2500000000000001E-2,80]
["Funktion","aX3","bX2","cX","d","aX3","bX2","cX","d","aX3","bX2","cX","d","1/90",1.1111111111111112E-2,90]
["K",null,null,4,5100,null,null,2,2450,null,null,14,5000,"1/20",0.05,20]
["PAF",null,null,-2E-3,12,null,null,-0.45,92,null,null,-0.2,100,"1/30",3.3333333333333333E-2,30]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"1/300",3.3333333333333335E-3,300]
[null,"Aufgabe 7",null,null,null,"Aufgabe 8",null,null,null,"Aufgabe 9",null,null,null,"1/125",4.4444444444444444E-3,225]
["Funktion","aX3","bX2","cX","d","aX3","bX2","cX","d","aX3","bX2","cX","d","1/45",2.2222222222222223E-2,45]
["K",null,null,14,5000,null,null,4,2950,null,null,6.8,580,"1/150",6.6666666666666671E-3,150]
["PAF",null,null,-0.5,120,null,null,-0.35499999999999998,85,null,null,-1.1499999999999999,85,"1/250",4.0000000000000001E-3,250]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"1/15",6.6666666666666666E-2,15]
[null,"Aufgabe 10",null,null,null,"Aufgabe 11",null,null,null,"Aufgabe 12",null,null,null,"1/8",0.125,8]
["Funktion","aX3","bX2","cX","d","aX3","bX2","cX","d","aX3","bX2","cX","d","1/16",6.25E-2,16]
["K",null,null,9,3250,null,null,9,3250,null,null,9,3250,"1/32",3.125E-2,32]
["PAF",null,null,-0.19850000000000001,100,null,null,-0.50149999999999995,120,null,null,-0.1055,60,"1/64",1.5625E-2,64]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"1/500",2E-3,500]
[null,"Aufgabe 13",null,null,null,"Aufgabe 14",null,null,null,"Aufgabe 15"]
["Funktion","aX3","bX2","cX","d","aX3","bX2","cX","d","aX3","bX2","cX","d"]
["K",null,null,5.8,1900,null,null,5.8,1900,null,null,5.8,1900]
["PAF",null,null,-0.45,92,null,null,-1.25,125,null,null,-0.3,55]
[]
[null,"Aufgabe 16",null,null,null,"Aufgabe 17",null,null,null,"Aufgabe 18"]
["Funktion","aX3","bX2","cX","d","aX3","bX2","cX","d","aX3","bX2","cX","d"]
["K",null,null,89,29950,null,null,89,29950,null,null,89,29950]
["PAF",null,null,-2.2000000000000002,920,null,null,-4.4000000000000004,1100,null,null,-3.1,925]
[]
[null,"Aufgabe 19",null,null,null,"Aufgabe 20",null,null,null,"Aufgabe 21"]
["Funktion","aX3","bX2","cX","d","aX3","bX2","cX","d","aX3","bX2","cX","d"]
["K",null,null,12,5100,null,null,12,5100,null,null,12,5100]
["PAF",null,null,-25,150,null,null,-0.5,190,null,null,-0.25,120]
[]
[null,"Aufgabe 22",null,null,null,"Aufgabe 23",null,null,null,"Aufgabe 24"]
["Funktion","aX3","bX2","cX","d","aX3","bX2","cX","d","aX3","bX2","cX","d"]
["K",null,null,40,2950,null,null,40,75500,null,null,20,20000]
["PAF",null,null,-0.125,92,null,null,-0.125,300,null,null,-3.3300000000000001E-3,40]
[]
[null,"Aufgabe 25",null,null,null,"Aufgabe 26",null,null,null,"Aufgabe 27"]
["Funktion","aX3","bX2","cX","d","aX3","bX2","cX","d","aX3","bX2","cX","d"]
["K",0.1,-2,15,10,1.5,-12,60,50,0.33333333300000001,-10,150,500]
["PAF",null,null,-0.8,16,null,null,-25,150,null,null,-15,400]
[]
[null,"Aufgabe 28",null,null,null,"Aufgabe 29",null,null,null,"Aufgabe 30"]
["Funktion","aX3","bX2","cX","d","aX3","bX2","cX","d","aX3","bX2","cX","d"]
["K",0.5,-5,20,50,5,-50,250,200,3.7999999999999999E-2,-8.0399999999999991,824.45,6000]
["PAF",null,null,-10,100,null,null,-100,800,null,null,-6,1200]
[]
[null,"Aufgabe 31",null,null,null,"Aufgabe 32",null,null,null,"Aufgabe 33"]
["Funktion","aX3","bX2","cX","d","aX3","bX2","cX","d","aX3","bX2","cX","d"]
["K",8.3000000000000004E-2,-8.4,790,5900,0.25,-1.5,20,100,4,-50,240,680]
["PAF",null,null,-16,1500,null,null,-10,120,null,null,-90,900]
[]
[null,"Aufgabe 34",null,null,null,"Aufgabe 35",null,null,null,"Aufgabe 36"]
["Funktion","aX3","bX2","cX","d","aX3","bX2","cX","d","aX3","bX2","cX","d"]
["K",3,-5,50,500,0.55000000000000004,-4.5,25,60,1E-3,-0.5,90,720]
["PAF",null,null,-90,600,null,null,-9,90,null,null,-0.18,90]
[]
[null,"Aufgabe 37",null,null,null,"Aufgabe 38",null,null,null,"Aufgabe 39"]
["Funktion","aX3","bX2","cX","d","aX3","bX2","cX","d","aX3","bX2","cX","d"]
["K",null,null,0.5,3,0.1,-5.3,120,20,0.01,-1.3,70,200]
["PAF",null,null,null,null,null,null,-3,120,null,null,-0.6,80]
[]
[null,"Aufgabe 40",null,null,null,"Aufgabe 41",null,null,null,"Aufgabe 42"]
["Funktion","aX3","bX2","cX","d","aX3","bX2","cX","d","aX3","bX2","cX","d"]
["K",null,null,20,10000,3.3E-3,-0.25,10,1016,null,0.5,2,50]
["PAF",null,null,null,null,null,null,-0.5,60,null,null,-3,30]
[]
[null,"Aufgabe 43",null,null,null,"Aufgabe 44",null,null,null,"Aufgabe 45"]
["Funktion","aX3","bX2","cX","d","aX3","bX2","cX","d","aX3","bX2","cX","d"]
["K",null,0.66666700000000001,10,15]
["PAF",null,null,-0.66666999999999998,30]