{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Start","unvollkommenerMarkt","FunktionenunvollkommenerMark","Monopol","FunktionenMonopol"],"not_rendered":{"charts":2,"images":1,"macros":1,"external_links":0,"defined_names":0,"comments":2,"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":"Start","index":0,"n_rows":23,"n_cols":2,"rows_kept":23,"cut":false,"hidden":false,"merged":[[1,1,1,7],[3,1,3,7]]}
[]
[null,"Preisdifferenzierung"]
[]
[null,"Welche Marktform liegt vor?"]
[]
[]
[]
[]
[null,"Hinweise:"]
[null,"Mit der voliegenden Anwendungen können die Auswirkungen von Preisdifferenzierungen"]
[null,"im einem unvollkommenen Markt und bei einer monopolistischen Markform"]
[null,"simliert werden."]
[]
[null,"Bei vorliegenden Preis-Absatz- und Kostenfunktionen wird in jeder Marktform zunächst"]
[null,"das Gewinnmaximum (Cournotscher Punkt) für eine Preis-Mengen-Kombination"]
[null,"ermittelt."]
[null,"Von dem Cournotschen Preis können in jeder Marktform zwei abweichende Preise"]
[null,"angegeben und die Auswirkungen auf den Gesamtgewinn simuliert werden."]
[]
[null,"Preis-Absatz- und Kostenfunktionen können in die entsprechenden Zellen eingegeben"]
[null,"werden. "]
[null,"Musterfunktionen können jeweils von der Seite \"Funktionen\" kopiert und in die"]
[null,"entsprechenden Zellen bei den beiden Marktformen eingefügt werden."]

{"sheet":"unvollkommenerMarkt","index":1,"n_rows":105,"n_cols":35,"rows_kept":105,"cut":false,"hidden":false,"merged":[[3,15,7,17],[8,15,9,17],[13,15,14,17],[2,24,2,34],[1,1,1,12],[3,31,3,34],[19,10,19,12],[20,10,20,12],[21,10,21,12],[3,8,3,12],[8,11,8,12],[8,8,8,10],[14,11,14,12],[14,8,14,10],[20,15,21,17],[31,15,31,18],[34,15,34,18],[37,15,37,18],[9,20,9,22],[15,20,15,22],[29,15,30,18]]}
[]
[null,"Preisdifferenzierung im unvollkommen Markt und Oligopol"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tabellen für die graphische Darstellung der Preis-Absatz-Funktion"]
[null,null,null,null,null,null,null,null,"Gewinnmaximum ohne Preisdifferenzierung",null,null,null,null,null,null,"Notwendige Berechnungen zur Zuweisung der Preise p2 und p3 zu den definierten Abschnitten der Preis-Absatz-Funktion und Berechnung der zugehörigen Absatzmengen. ",null,null,null,null,"Erlöse in Abhängikeit von der Preisstruktur",null,null,null,"X","PAF1","PAF2","PAF3","PAF","X","Zeilen","Definitionsbereiche"]
[null,"Funktionen",null,"bX2","cX","d","d/X",null,null,null,"Gewinn","   Preis","   Menge",null,null,null,null,null,null,null,"pch-p2m-p3n","p2h-pcm-p3n","p3h-pcm-p2n",null,0,{"$f":"$F$7+$E$7*Y5","v":92},{"$f":"$F$8+$E$8*Y5","v":125},{"$f":"$F$9+$E$9*Y5","v":55},{"$f":"IF(AND($Z5<$AA5,$AA5>$AB5),Z5,IF(AND($AA5>$AB5,$Z5>$AB5),AA5,AB5))","v":92},{"$f":"Y5","v":0},0,{"$f":"IF(AC5=Z5,\"PAF1\",IF(AC5=AA5,\"PAF2\",\"PAF3\"))","v":"PAF1"},{"$f":"IF(AF5=\"PAF1\",AD5,\"\")","v":0}]
[null,"Gesamtkosten","K=",null,5.8,1900,null,null,"PAF1",{"$f":"IF(AND(M6<K11,M6>J11),\"definiert\",\"nicht definiert\")","v":"nicht definiert"},{"$f":"IF(J6=\"definiert\",(M6*L6)-(F6+(E6*M6)),\"\")","v":""},{"$f":"IF(J6=\"definiert\",F7+(E7*M6),\"\")","v":""},{"$f":"ROUND((F17-F13)/(E17*-1),0)","v":96},null,null,null,null,null,null,null,{"$f":"(J18*N18)+((J16*N16)-(J16*N18))+((J17*N17)-(J17*N16))","v":3920},{"$f":"(J16*N16)+((J18*N18)-(J18*N16))+((J17*N17)-(J17*N18))","v":4800},{"$f":"(J17*N17)+((J18*N18)-(J18*N17))+((J16*N16)-(J16*N18))","v":-1630},null,{"$f":"F22/100","v":1.83},{"$f":"$F$7+$E$7*Y6","v":91.176500000000004},{"$f":"$F$8+$E$8*Y6","v":122.71250000000001},{"$f":"$F$9+$E$9*Y6","v":54.451000000000001},{"$f":"IF(AND($Z6<$AA6,$AA6>$AB6),Z6,IF(AND($AA6>$AB6,$Z6>$AB6),AA6,AB6))","v":91.176500000000004},{"$f":"Y6","v":1.83},1,"PAF1",{"$f":"IF(AF6=\"PAF1\",AD6,\"\")","v":1.83},{"$f":"IF(AF6=\"PAF2\",AD6,\"\")","v":""},{"$f":"IF(AF6=\"PAF3\",AD6,\"\")","v":""}]
[null,"Preis-Absatz-Funktion 1","p1=",null,-0.45,92,null,null,"PAF2",{"$f":"IF(AND(M7<K12,M7>J12),\"definiert\",\"nicht definiert\")","v":"definiert"},{"$f":"IF(J7=\"definiert\",(M7*L7)-(F6+(E6*M7)),\"\")","v":941.59999999999991},{"$f":"IF(J7=\"definiert\",F8+(E8*M7),\"\")","v":65},{"$f":"ROUND((F19-F13)/(E19*-1),0)","v":48},null,null,null,null,null,null,null,"pch-p3m-p2n","p2h-p3m-pcn","p3h-p2m-pcn",null,{"$f":"Y6+$Y$6","v":3.66},90.352999999999994,120.425,53.902000000000001,{"$f":"IF(AND($Z7<$AA7,$AA7>$AB7),Z7,IF(AND($AA7>$AB7,$Z7>$AB7),AA7,AB7))","v":90.352999999999994},3.66,2,"PAF1",{"$f":"IF(AF7=\"PAF1\",AD7,\"\")","v":3.66},{"$f":"IF(AF7=\"PAF2\",AD7,\"\")","v":""},{"$f":"IF(AF7=\"PAF3\",AD7,\"\")","v":""}]
[null,"Preis-Absatz-Funktion 2","p2=",null,-1.25,125,null,null,"PAF3",{"$f":"IF(AND(M8<K13,M8>J13),\"definiert\",\"nicht definiert\")","v":"definiert"},{"$f":"IF(J8=\"definiert\",(M8*L8)-(F6+(E6*M8)),\"\")","v":117.20000000000027},{"$f":"IF(J8=\"definiert\",F9+(E9*M8),\"\")","v":30.400000000000002},{"$f":"ROUND((F21-F13)/(E21*-1),0)","v":82},null,null,null,null,null,null,null,{"$f":"(J18*N18)+((J17*N17)-(J17*N18))+((J16*N16)-(J16*N17))","v":-230},{"$f":"(J16*N16)+((J17*N17)-(J17*N16))+((J18*N18)-(J18*N17))","v":1020},{"$f":"(J17*N17)+((J16*N16)-(J16*N17))+((J18*N18)-(J18*N16))","v":-1500},null,{"$f":"Y7+$Y$6","v":5.49},89.529499999999999,118.1375,53.353000000000002,89.529499999999999,5.49,3,"PAF1",5.49,"",""]
[null,"Preis-Absatz-Funktion 3","p3=",null,-0.3,55,null,null,"Definitionsbereiche",null,null,"Cournotscher Punkt",null,null,null,"Preise an den Knickpunkte der Preis-Absatz-Funktionen",null,null,null,null,null,null,null,null,7.32,88.706000000000003,115.85,52.804000000000002,88.706000000000003,7.32,4,"PAF1",7.32,"",""]
[null,"variable Gesamtkosten","Kv=",null,{"$f":"E6","v":5.8},null,null,null,null,"xmin","xmax",null,null,null,null,null,null,null,null,null,"Kosten in Abhängigkeit von der Preisstruktur",null,null,null,9.15,87.882499999999993,113.5625,52.255000000000003,87.882499999999993,9.15,5,"PAF1",9.15,"",""]
[null,"Stückkosten","k=",null,null,{"$f":"E6","v":5.8},{"$f":"F6","v":1900},null,"PAF1",0,{"$f":"ROUND((F8-F7)/(E7+E8*-1),0)","v":41},"Gmax",{"$f":"MAX(K6:K8)","v":941.59999999999991},null,null,{"$f":"F7","v":92},{"$f":"F7+(E7*K11)","v":73.55},null,null,null,"pch-p2m-p3n","p2h-pcm-p3n","p3h-pcm-p2n",null,10.98,87.058999999999997,111.27500000000001,51.706000000000003,87.058999999999997,10.98,6,"PAF1",10.98,"",""]
[null,"variable Stückkosten","kv=",null,null,{"$f":"E6","v":5.8},null,null,"PAF2",{"$f":"ROUND(K11,0)","v":41},{"$f":"ROUND((F9-F8)/(E8+E9*-1),0)","v":74},"XGmax",{"$f":"ROUND(VLOOKUP(M11,K6:M8,3),0)","v":48},null,null,{"$f":"F8+(E8*J12)","v":73.75},{"$f":"F8+(E8*K12)","v":32.5},null,null,null,{"$f":"F6+(E6*N17)","v":2480},{"$f":"F6+(E6*N17)","v":2480},{"$f":"F6+(E6*N16)","v":2120.4},null,12.81,86.235500000000002,108.9875,51.156999999999996,86.235500000000002,12.81,7,"PAF1",12.81,"",""]
[null,"Grenzkosten","K'=",null,null,{"$f":"E6","v":5.8},null,null,"PAF3",{"$f":"K12","v":74},{"$f":"F22","v":183},"PGmax",{"$f":"VLOOKUP(M11,K6:M8,2)","v":65},null,null,{"$f":"F9+(E9*J13)","v":32.799999999999997},{"$f":"F9+(E9*F22)","v":0.10000000000000142},null,null,null,"pch-p3m-p2n","p2h-p3m-pcn","p3h-p2m-pcn",null,14.64,85.412000000000006,106.7,50.607999999999997,85.412000000000006,14.64,8,"PAF1",14.64,"",""]
[null,"fixe Gesamtkosten","Kf=",null,null,{"$f":"F6","v":1900},null,null,null,null,null,null,null,null,null,"Mengen in Abhängigkeit von der Preisstruktur",null,null,null,null,{"$f":"F6+(E6*N16)","v":2120.4},{"$f":"F6+(E6*N18)","v":2178.4},{"$f":"F6+(E6*N18)","v":2178.4},null,16.47,84.588499999999996,104.41249999999999,50.058999999999997,84.588499999999996,16.47,9,"PAF1",16.47,"",""]
[null,"fixe Stückkosten","kf=",null,null,null,{"$f":"F6","v":1900},null,"Preisdifferenzierung",null,null,"Preisstruktur",null,"Menge",null,null,null,null,null,null,null,null,null,null,18.299999999999997,83.765000000000001,102.125,49.51,83.765000000000001,18.299999999999997,10,"PAF1",18.299999999999997,"",""]
[null,"Erlös 1","E1=",{"$f":"E7","v":-0.45},{"$f":"F7","v":92},null,null,null,"p2",75,{"$f":"IF(OR(J16>P11,N16<0),\"nicht definiert\",\"definiert\")","v":"definiert"},{"$f":"IF(AND(J16>J18,J16>J17),\"Hochpreis\",IF(AND(J16<J18,J16<J17),\"Niedrigpreis\",\"Mittelpreis\"))","v":"Hochpreis"},{"$f":"IF(L16=\"Hochpreis\",1,IF(L16=\"Mittelpreis\",2,3))","v":1},{"$f":"INT(ROUND(IF(AND(P17>=0,P17<=K11),P17,IF(AND(Q17>J12,Q17<=K12),Q17,R17)),0))","v":38},null,"x(p1)","x(p2)","x(p3)",null,null,"Gewinn in Abhängigkeit von der Preisstruktur",null,null,null,20.129999999999995,82.941500000000005,99.837500000000006,48.960999999999999,82.941500000000005,20.129999999999995,11,"PAF1",20.129999999999995,"",""]
[null,"Grenzerlös 1","E1'=",null,{"$f":"2*D16","v":-0.9},{"$f":"E16","v":92},null,null,"p3",25,{"$f":"IF(OR(J17>P11,N17<0),\"nicht definiert\",\"definiert\")","v":"definiert"},{"$f":"IF(AND(J17>J18,J17>J16),\"Hochpreis\",IF(AND(J17<J18,J17<J16),\"Niedrigpreis\",\"Mittelpreis\"))","v":"Niedrigpreis"},{"$f":"IF(L17=\"Hochpreis\",1,IF(L17=\"Mittelpreis\",2,3))","v":3},{"$f":"INT(ROUND(IF(AND(P18>=0,P18<=K11),P18,IF(AND(Q18>J12,Q18<=K12),Q18,R18)),0))","v":100},null,{"$f":"(F7-J16)/(E7*-1)","v":37.777777777777779},{"$f":"(F8-J16)/(E8*-1)","v":40},{"$f":"(F9-J16)/(E9*-1)","v":-66.666666666666671},null,null,"pch-p2m-p3n","p2h-pcm-p3n","p3h-pcm-p2n",null,21.959999999999994,82.117999999999995,97.550000000000011,48.411999999999999,82.117999999999995,21.959999999999994,12,"PAF1",21.959999999999994,"",""]
[null,"Erlös 2","E2=",{"$f":"E8","v":-1.25},{"$f":"F8","v":125},null,null,null,"pc",{"$f":"M13","v":65},"definiert",{"$f":"IF(AND(J18>J16,J18>J17),\"Hochpreis\",IF(AND(J18<J16,J18<J17),\"Niedrigpreis\",\"Mittelpreis\"))","v":"Mittelpreis"},{"$f":"IF(L18=\"Hochpreis\",1,IF(L18=\"Mittelpreis\",2,3))","v":2},{"$f":"ROUND(M12,0)","v":48},null,{"$f":"(F7-J17)/(E7*-1)","v":148.88888888888889},{"$f":"(F8-J17)/(E8*-1)","v":80},{"$f":"(F9-J17)/(E9*-1)","v":100},null,null,{"$f":"U6-U12","v":1440},{"$f":"V6-V12","v":2320},{"$f":"W6-W12","v":-3750.4},null,23.789999999999992,81.294499999999999,95.262500000000017,47.863,81.294499999999999,23.789999999999992,13,"PAF1",23.789999999999992,"",""]
[null,"Grenzerlös 2","E2'=",null,{"$f":"2*D18","v":-2.5},{"$f":"E18","v":125},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pch-p3m-p2n","p2h-p3m-pcn","p3h-p2m-pcn",null,25.61999999999999,80.471000000000004,92.975000000000009,47.314000000000007,80.471000000000004,25.61999999999999,14,"PAF1",25.61999999999999,"",""]
[null,"Erlös 3","E3=",{"$f":"E9","v":-0.3},{"$f":"F9","v":55},null,null,null,"Umsatz",{"$f":"IF(AND($M$18=1,$M$16=2),U6,IF(AND($M$18=1,$M$17=2),U8,IF(AND($M$16=1,$M$18=2),V6,IF(AND($M$16=1,$M$17=2),V8,IF(AND($M$17=1,$M$18=2),W6,W8)))))","v":4800},"Gewinn mit Preisdifferenzierung",null,null,{"$f":"J22","v":2320},null,null,null,null,null,null,{"$f":"U8-U14","v":-2350.4},{"$f":"V8-V14","v":-1158.4000000000001},{"$f":"W8-W14","v":-3678.4},null,27.449999999999989,79.647500000000008,90.687500000000014,46.765000000000001,79.647500000000008,27.449999999999989,15,"PAF1",27.449999999999989,"",""]
[null,"Grenzerlös 3","E3'=",null,{"$f":"2*D20","v":-0.6},{"$f":"E20","v":55},null,null,"Kosten",{"$f":"IF(AND($M$18=1,$M$16=2),U12,IF(AND($M$18=1,$M$17=2),U14,IF(AND($M$16=1,$M$18=2),V12,IF(AND($M$16=1,$M$17=2),V14,IF(AND($M$17=1,$M$18=2),W12,W14)))))","v":2480},"Gewinn ohne Preisdifferenzierung",null,null,{"$f":"M11","v":941.59999999999991},null,"Matrix der Preis-Absatz-Funktion (Datenreihen für dasPunktdiagramm)",null,null,null,null,null,null,null,null,29.279999999999987,78.824000000000012,88.40000000000002,46.216000000000008,78.824000000000012,29.279999999999987,16,"PAF1",29.279999999999987,"",""]
[null,"Sättigungsmenge","xmax=",null,null,{"$f":"ROUND((F9/E9)*-1,0)","v":183},null,null,"Gewinn",{"$f":"IF(AND($M$18=1,$M$16=2),U18,IF(AND($M$18=1,$M$17=2),U20,IF(AND($M$16=1,$M$18=2),V18,IF(AND($M$16=1,$M$17=2),V20,IF(AND($M$17=1,$M$18=2),W18,W20)))))","v":2320},"Differenz",null,null,{"$f":"N20-N21","v":1378.4},null,null,null,null,null,null,null,null,null,null,31.109999999999985,78.000500000000002,86.112500000000011,45.667000000000002,78.000500000000002,31.109999999999985,17,"PAF1",31.109999999999985,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PAF1",0,{"$f":"P11","v":92},null,null,null,null,null,null,32.939999999999984,77.177000000000007,83.825000000000017,45.118000000000009,77.177000000000007,32.939999999999984,18,"PAF1",32.939999999999984,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"K11","v":41},{"$f":"Q11","v":73.55},null,null,null,null,null,null,34.769999999999982,76.353500000000011,81.537500000000023,44.569000000000003,76.353500000000011,34.769999999999982,19,"PAF1",34.769999999999982,"",""]
[null,"Hinweise: Die Kostenfunktion wird in die Zellen E6 - F6 eingetragen. (E6: mengenabhängiger Teil, variable Stückkosten; F6: konstanter Teil, fixe Kosten)",null,null,null,null,null,null,null,null,null,null,null,null,null,"PAF2",{"$f":"J12","v":41},{"$f":"P12","v":73.75},null,null,null,null,null,null,36.59999999999998,75.53,79.250000000000028,44.02000000000001,75.53,36.59999999999998,20,"PAF1",36.59999999999998,"",""]
[null,"Die Preis-Absatz-Funktionen (p1, p2, p3) werden in die Zellen E7 - F9 eingetragen. (mengenabhängiger Teil in Spalte E, konstanter Teil in Spalte F)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"K12","v":74},{"$f":"Q12","v":32.5},null,null,null,null,null,null,38.429999999999978,74.706500000000005,76.962500000000034,43.471000000000004,74.706500000000005,38.429999999999978,21,"PAF1",38.429999999999978,"",""]
[null,"Gewinnänderungen aufgrund der Preisdifferenzierung werden in Zelle N22 angezeigt. ",null,null,null,null,null,null,null,null,null,null,null,null,null,"PAF§",{"$f":"K12","v":74},{"$f":"P13","v":32.799999999999997},null,null,null,null,null,null,40.259999999999977,73.88300000000001,74.675000000000026,42.922000000000011,73.88300000000001,40.259999999999977,22,"PAF1",40.259999999999977,"",""]
[null,"Musterfunktionen können von der Seite \"Funktionen\" kopiert und in die Zellen E6 - F9 eingefügt werden.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"K13","v":183},0,null,null,null,null,null,null,42.089999999999975,73.059500000000014,72.387500000000031,42.373000000000005,72.387500000000031,42.089999999999975,23,"PAF2","",42.089999999999975,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,43.919999999999973,72.236000000000018,70.100000000000037,41.824000000000012,70.100000000000037,43.919999999999973,24,"PAF2","",43.919999999999973,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Matrix der Preis-Mengen-Kombinationen (Datenreihen für das Punktdiagramm)",null,null,null,null,null,null,null,null,45.749999999999972,71.412500000000009,67.812500000000028,41.275000000000006,67.812500000000028,45.749999999999972,25,"PAF2","",45.749999999999972,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,47.57999999999997,70.589000000000013,65.525000000000034,40.726000000000013,65.525000000000034,47.57999999999997,26,"PAF2","",47.57999999999997,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cournotscher Punkt",null,null,null,null,null,null,null,null,49.409999999999968,69.765500000000017,63.23750000000004,40.177000000000007,63.23750000000004,49.409999999999968,27,"PAF2","",49.409999999999968,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M12","v":48},0,0,{"$f":"M13","v":65},null,null,null,null,null,51.239999999999966,68.942000000000007,60.950000000000045,39.628000000000014,60.950000000000045,51.239999999999966,28,"PAF2","",51.239999999999966,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M12","v":48},{"$f":"M13","v":65},{"$f":"M12","v":48},{"$f":"M13","v":65},null,null,null,null,null,53.069999999999965,68.118500000000012,58.662500000000051,39.079000000000008,58.662500000000051,53.069999999999965,29,"PAF2","",53.069999999999965,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Preis 2, Menge 2",null,null,null,null,null,null,null,null,54.899999999999963,67.295000000000016,56.375000000000043,38.530000000000015,56.375000000000043,54.899999999999963,30,"PAF2","",54.899999999999963,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"N16","v":38},0,0,{"$f":"J16","v":75},null,null,null,null,null,56.729999999999961,66.47150000000002,54.087500000000048,37.981000000000009,54.087500000000048,56.729999999999961,31,"PAF2","",56.729999999999961,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"N16","v":38},{"$f":"J16","v":75},{"$f":"N16","v":38},{"$f":"J16","v":75},null,null,null,null,null,58.55999999999996,65.648000000000025,51.800000000000054,37.432000000000016,51.800000000000054,58.55999999999996,32,"PAF2","",58.55999999999996,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Preis 3, Menge 3",null,null,null,null,null,null,null,null,60.389999999999958,64.824500000000015,49.512500000000045,36.88300000000001,49.512500000000045,60.389999999999958,33,"PAF2","",60.389999999999958,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"N17","v":100},0,0,{"$f":"J17","v":25},null,null,null,null,null,62.219999999999956,64.001000000000019,47.225000000000051,36.334000000000017,47.225000000000051,62.219999999999956,34,"PAF2","",62.219999999999956,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"N17","v":100},{"$f":"J17","v":25},{"$f":"N17","v":100},{"$f":"J17","v":25},null,null,null,null,null,64.049999999999955,63.177500000000023,44.937500000000057,35.785000000000011,44.937500000000057,64.049999999999955,35,"PAF2","",64.049999999999955,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,65.879999999999953,62.354000000000021,42.650000000000063,35.236000000000018,42.650000000000063,65.879999999999953,36,"PAF2","",65.879999999999953,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,67.709999999999951,61.530500000000018,40.362500000000068,34.687000000000012,40.362500000000068,67.709999999999951,37,"PAF2","",67.709999999999951,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,69.539999999999949,60.707000000000022,38.07500000000006,34.138000000000019,38.07500000000006,69.539999999999949,38,"PAF2","",69.539999999999949,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,71.369999999999948,59.883500000000019,35.787500000000065,33.589000000000013,35.787500000000065,71.369999999999948,39,"PAF2","",71.369999999999948,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,73.199999999999946,59.060000000000024,33.500000000000071,33.04000000000002,33.500000000000071,73.199999999999946,40,"PAF2","",73.199999999999946,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,75.029999999999944,58.236500000000021,31.212500000000063,32.491000000000014,32.491000000000014,75.029999999999944,41,"PAF3","","",75.029999999999944]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,76.859999999999943,57.413000000000025,28.925000000000068,31.942000000000018,31.942000000000018,76.859999999999943,42,"PAF3","","",76.859999999999943]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,78.689999999999941,56.589500000000022,26.637500000000074,31.393000000000018,31.393000000000018,78.689999999999941,43,"PAF3","","",78.689999999999941]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,80.519999999999939,55.766000000000027,24.35000000000008,30.844000000000019,30.844000000000019,80.519999999999939,44,"PAF3","","",80.519999999999939]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,82.349999999999937,54.942500000000024,22.062500000000085,30.295000000000019,30.295000000000019,82.349999999999937,45,"PAF3","","",82.349999999999937]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,84.179999999999936,54.119000000000028,19.775000000000077,29.74600000000002,29.74600000000002,84.179999999999936,46,"PAF3","","",84.179999999999936]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,86.009999999999934,53.295500000000025,17.487500000000082,29.19700000000002,29.19700000000002,86.009999999999934,47,"PAF3","","",86.009999999999934]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,87.839999999999932,52.47200000000003,15.200000000000088,28.648000000000021,28.648000000000021,87.839999999999932,48,"PAF3","","",87.839999999999932]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,89.669999999999931,51.648500000000027,12.91250000000008,28.099000000000022,28.099000000000022,89.669999999999931,49,"PAF3","","",89.669999999999931]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,91.499999999999929,50.825000000000031,10.625000000000085,27.550000000000022,27.550000000000022,91.499999999999929,50,"PAF3","","",91.499999999999929]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,93.329999999999927,50.001500000000028,8.3375000000000909,27.001000000000023,27.001000000000023,93.329999999999927,51,"PAF3","","",93.329999999999927]
[null,"Berechnungen: Spalte P - AI; Schriftfarbe: weiß",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,95.159999999999926,49.178000000000033,6.0500000000000966,26.452000000000023,26.452000000000023,95.159999999999926,52,"PAF3","","",95.159999999999926]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,96.989999999999924,48.35450000000003,3.7625000000001023,25.903000000000024,25.903000000000024,96.989999999999924,53,"PAF3","","",96.989999999999924]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,98.819999999999922,47.531000000000034,1.4750000000000938,25.354000000000024,25.354000000000024,98.819999999999922,54,"PAF3","","",98.819999999999922]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100.64999999999992,46.707500000000032,-0.81249999999990052,24.805000000000025,24.805000000000025,100.64999999999992,55,"PAF3","","",100.64999999999992]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,102.47999999999992,45.884000000000036,-3.0999999999999091,24.256000000000025,24.256000000000025,102.47999999999992,56,"PAF3","","",102.47999999999992]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,104.30999999999992,45.060500000000033,-5.3874999999999034,23.707000000000026,23.707000000000026,104.30999999999992,57,"PAF3","","",104.30999999999992]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,106.13999999999992,44.237000000000037,-7.6749999999998977,23.158000000000026,23.158000000000026,106.13999999999992,58,"PAF3","","",106.13999999999992]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,107.96999999999991,43.413500000000035,-9.962499999999892,22.60900000000003,22.60900000000003,107.96999999999991,59,"PAF3","","",107.96999999999991]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,109.79999999999991,42.590000000000039,-12.249999999999886,22.060000000000031,22.060000000000031,109.79999999999991,60,"PAF3","","",109.79999999999991]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,111.62999999999991,41.766500000000036,-14.537499999999881,21.511000000000031,21.511000000000031,111.62999999999991,61,"PAF3","","",111.62999999999991]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,113.45999999999991,40.94300000000004,-16.824999999999875,20.962000000000032,20.962000000000032,113.45999999999991,62,"PAF3","","",113.45999999999991]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,115.28999999999991,40.119500000000038,-19.112499999999898,20.413000000000032,20.413000000000032,115.28999999999991,63,"PAF3","","",115.28999999999991]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,117.11999999999991,39.296000000000042,-21.399999999999892,19.864000000000033,19.864000000000033,117.11999999999991,64,{"$f":"IF(AC69=Z69,\"PAF1\",IF(AC69=AA69,\"PAF2\",\"PAF3\"))","v":"PAF3"},"","",117.11999999999991]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,118.9499999999999,{"$f":"$F$7+$E$7*Y70","v":38.472500000000039},{"$f":"$F$8+$E$8*Y70","v":-23.687499999999886},{"$f":"$F$9+$E$9*Y70","v":19.315000000000033},19.315000000000033,{"$f":"Y70","v":118.9499999999999},65,"PAF3","","",118.9499999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,120.7799999999999,37.649000000000044,-25.974999999999881,18.766000000000034,{"$f":"IF(AND($Z71<$AA71,$AA71>$AB71),Z71,IF(AND($AA71>$AB71,$Z71>$AB71),AA71,AB71))","v":18.766000000000034},120.7799999999999,66,"PAF3",{"$f":"IF(AF71=\"PAF1\",AD71,\"\")","v":""},{"$f":"IF(AF71=\"PAF2\",AD71,\"\")","v":""},{"$f":"IF(AF71=\"PAF3\",AD71,\"\")","v":120.7799999999999}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Y71+$Y$6","v":122.6099999999999},36.825500000000041,-28.262499999999875,18.217000000000034,18.217000000000034,122.6099999999999,67,"PAF3","","",122.6099999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,124.4399999999999,36.002000000000045,-30.549999999999869,17.668000000000035,17.668000000000035,124.4399999999999,68,"PAF3","","",124.4399999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,126.2699999999999,35.178500000000042,-32.837499999999864,17.119000000000035,17.119000000000035,126.2699999999999,69,"PAF3","","",126.2699999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,128.09999999999991,34.35500000000004,-35.124999999999886,16.570000000000029,16.570000000000029,128.09999999999991,70,"PAF3","","",128.09999999999991]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,129.92999999999992,33.531500000000037,-37.412499999999909,16.021000000000022,16.021000000000022,129.92999999999992,71,"PAF3","","",129.92999999999992]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,131.75999999999993,32.708000000000027,-39.699999999999932,15.472000000000023,15.472000000000023,131.75999999999993,72,"PAF3","","",131.75999999999993]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,133.58999999999995,31.884500000000024,-41.987499999999926,14.923000000000016,14.923000000000016,133.58999999999995,73,"PAF3","","",133.58999999999995]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,135.41999999999996,31.061000000000014,-44.274999999999949,14.374000000000017,14.374000000000017,135.41999999999996,74,"PAF3","","",135.41999999999996]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,137.24999999999997,30.237500000000011,-46.562499999999972,13.82500000000001,13.82500000000001,137.24999999999997,75,"PAF3","","",137.24999999999997]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,139.07999999999998,29.414000000000009,-48.849999999999966,13.276000000000003,13.276000000000003,139.07999999999998,76,"PAF3","","",139.07999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,140.91,28.590499999999999,-51.137499999999989,12.727000000000004,12.727000000000004,140.91,77,"PAF3","","",140.91]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,142.74,27.766999999999996,-53.425000000000011,12.177999999999997,12.177999999999997,142.74,78,"PAF3","","",142.74]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,144.57000000000002,26.943499999999986,-55.712500000000034,11.628999999999998,11.628999999999998,144.57000000000002,79,"PAF3","","",144.57000000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,146.40000000000003,26.119999999999976,-58.000000000000057,11.079999999999991,11.079999999999991,146.40000000000003,80,"PAF3","","",146.40000000000003]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,148.23000000000005,25.29649999999998,-60.287500000000051,10.530999999999985,10.530999999999985,148.23000000000005,81,"PAF3","","",148.23000000000005]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,150.06000000000006,24.472999999999971,-62.575000000000074,9.9819999999999851,9.9819999999999851,150.06000000000006,82,"PAF3","","",150.06000000000006]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,151.89000000000007,23.649499999999961,-64.862500000000097,9.4329999999999785,9.4329999999999785,151.89000000000007,83,"PAF3","","",151.89000000000007]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,153.72000000000008,22.825999999999965,-67.150000000000091,8.883999999999979,8.883999999999979,153.72000000000008,84,"PAF3","","",153.72000000000008]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,155.5500000000001,22.002499999999955,-69.437500000000114,8.3349999999999724,8.3349999999999724,155.5500000000001,85,"PAF3","","",155.5500000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,157.38000000000011,21.178999999999945,-71.725000000000136,7.7859999999999658,7.7859999999999658,157.38000000000011,86,"PAF3","","",157.38000000000011]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,159.21000000000012,20.35549999999995,-74.012500000000159,7.2369999999999663,7.2369999999999663,159.21000000000012,87,"PAF3","","",159.21000000000012]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,161.04000000000013,19.53199999999994,-76.300000000000182,6.6879999999999598,6.6879999999999598,161.04000000000013,88,"PAF3","","",161.04000000000013]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,162.87000000000015,18.70849999999993,-78.587500000000176,6.1389999999999603,6.1389999999999603,162.87000000000015,89,"PAF3","","",162.87000000000015]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,164.70000000000016,17.88499999999992,-80.875000000000199,5.5899999999999537,5.5899999999999537,164.70000000000016,90,"PAF3","","",164.70000000000016]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,166.53000000000017,17.061499999999924,-83.162500000000222,5.0409999999999471,5.0409999999999471,166.53000000000017,91,"PAF3","","",166.53000000000017]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,168.36000000000018,16.237999999999914,-85.450000000000216,4.4919999999999476,4.4919999999999476,168.36000000000018,92,"PAF3","","",168.36000000000018]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,170.1900000000002,15.414499999999904,-87.737500000000239,3.942999999999941,3.942999999999941,170.1900000000002,93,"PAF3","","",170.1900000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,172.02000000000021,14.590999999999909,-90.025000000000261,3.3939999999999415,3.3939999999999415,172.02000000000021,94,"PAF3","","",172.02000000000021]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,173.85000000000022,13.767499999999899,-92.312500000000284,2.8449999999999349,2.8449999999999349,173.85000000000022,95,"PAF3","","",173.85000000000022]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,175.68000000000023,12.943999999999889,-94.600000000000307,2.2959999999999283,2.2959999999999283,175.68000000000023,96,"PAF3","","",175.68000000000023]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,177.51000000000025,12.120499999999893,-96.887500000000301,1.7469999999999288,1.7469999999999288,177.51000000000025,97,"PAF3","","",177.51000000000025]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,179.34000000000026,11.296999999999883,-99.175000000000324,1.1979999999999222,1.1979999999999222,179.34000000000026,98,"PAF3","","",179.34000000000026]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,181.17000000000027,10.473499999999873,-101.46250000000035,0.64899999999992275,0.64899999999992275,181.17000000000027,99,"PAF3","","",181.17000000000027]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"F22","v":183},9.6499999999999915,-103.75,0.10000000000000142,0.10000000000000142,183,100,"PAF3","","",183]

{"sheet":"FunktionenunvollkommenerMark","index":2,"n_rows":24,"n_cols":17,"rows_kept":24,"cut":false,"hidden":false,"merged":[[15,13,15,14],[15,15,15,16],[15,1,15,2],[15,3,15,4],[15,5,15,6],[15,7,15,8],[15,9,15,10],[15,11,15,12],[3,13,3,14],[3,15,3,16],[9,1,9,2],[9,3,9,4],[9,5,9,6],[9,7,9,8],[9,9,9,10],[9,11,9,12],[9,13,9,14],[9,15,9,16],[3,1,3,2],[3,3,3,4],[3,5,3,6],[3,7,3,8],[3,9,3,10],[3,11,3,12]]}
[]
[]
[]
[null,"Aufgabe 1",null,"Aufgabe 2",null,"Aufgabe 3",null,"Aufgabe 4",null,"Aufgabe 5",null,"Aufgabe 6",null,"Aufgabe 7",null,"Aufgabe 8"]
["K",4,5100,2,2450,14,5000,5,450,5,450,4,2950,6.8,580,9,3250]
["PAF1",-1.25E-3,15,-0.45,92,-0.2,100,-0.2,200,-0.45,1000,-0.35499999999999998,85,-1.1499999999999999,85,-0.19850000000000001,100]
["PAF2",-0.01,22,-0.85,110.8,-0.5,120,-0.5,280,-0.85,1200,-0.94499999999999995,120,-2.4,105,-0.50149999999999995,120]
["PAF3",-2E-3,12,-0.3,60,-0.1,60,-0.1,100,-0.55000000000000004,900,-0.29499999999999998,65,-0.95,65,-0.1055,60]
[]
[null,"Aufgabe 9",null,"Aufgabe 10",null,"Aufgabe 10",null,"Aufgabe 11",null,"Aufgabe 12",null,"Aufgabe 13",null,"Aufgabe 14",null,"Aufgabe 15"]
["K",5.8,1900,89,29950,12,5100,65,650,45,4500,477.5,120000,25,15,4,2500]
["PAF1",-0.45,92,-2.2000000000000002,920,-0.25,150,-0.4,115,-0.5,210,-0.2,1200,-2,50,-2E-3,16]
["PAF2",-1.25,125,-4.4000000000000004,1100,-0.5,190,-1,130,-0.75,225,-0.85,1400,-5,80,-0.01,22]
["PAF3",-0.3,55,-3.1,925,-0.25,120,-0.4,109,-0.3,171,-0.55000000000000004,1000,-1,30,-2E-3,15]
[]
[]
["K"]
["PAF1"]
["PAF2"]
["PAF3"]
[]
[]
[]
["Hinweis: Sie können Funktionen markieren und kopieren und dann in die Felder E6 - F9 in der Tabelle \"unvollkommener Markt\" einfügen. Das Gewinnmaximum (Cournotscher Punkt) wird dann ermittelt."]

{"sheet":"Monopol","index":3,"n_rows":105,"n_cols":19,"rows_kept":105,"cut":false,"hidden":false,"merged":[[45,13,47,14],[41,12,41,15],[1,1,1,10],[29,3,29,5],[9,13,9,15],[15,13,15,15],[33,12,34,15],[35,12,35,15],[38,12,38,15],[17,2,18,6],[22,1,22,3],[22,4,22,5],[27,3,27,5],[28,3,28,5]]}
[]
[null,"Preisdifferenzierung im Monopol"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Erlöse in Abhängikeit von der Preisstruktur",null,null,null,"X","PAF"]
[null,"Funktionen",null,"bX2","cX","d","d/X",null,null,null,null,null,null,"pch-p2m-p3n","p2h-pcm-p3n","p3h-pcm-p2n",null,0,{"$f":"$F$7+$E$7*R5","v":6}]
[null,"Gesamtkosten","K=",null,1.5,150,null,null,null,null,null,null,null,{"$f":"(C26*G26)+((C24*G24)-(C24*G26))+((C25*G25)-(C25*G24))","v":618.65497649134886},{"$f":"(C24*G24)+((C26*G26)-(C26*G24))+((C25*G25)-(C25*G26))","v":868.69720916186043},{"$f":"(C25*G25)+((C26*G26)-(C26*G25))+((C24*G24)-(C24*G26))","v":268.73944183237211},null,{"$f":"R105/100","v":6},{"$f":"$F$7+$E$7*R6","v":5.93998873795453}]
[null,"Preis-Absatz-Funktion ","p=",null,-1.0001877007578295E-2,6,null,null,null,null,null,null,null,"pch-p3m-p2n","p2h-p3m-pcn","p3h-p2m-pcn",null,{"$f":"R6+$R$6","v":12},{"$f":"$F$7+$E$7*R7","v":5.8799774759090608}]
[null,"variable Gesamtkosten","Kv=",null,{"$f":"E6","v":1.5},null,null,null,null,null,null,null,null,{"$f":"(C26*G26)+((C25*G25)-(C25*G26))+((C24*G24)-(C24*G25))","v":243.65497649134886},{"$f":"(C24*G24)+((C25*G25)-(C25*G24))+((C26*G26)-(C26*G25))","v":993.73944183237211},{"$f":"(C25*G25)+((C24*G24)-(C24*G25))+((C26*G26)-(C26*G24))","v":768.69720916186043},null,{"$f":"R7+$R$6","v":18},5.8199662138635908]
[null,"Stückkosten","k=",null,null,{"$f":"E6","v":1.5},{"$f":"F6","v":150},null,null,null,null,null,null,null,null,null,null,24,5.7599549518181208]
[null,"variable Stückkosten","kv=",null,null,{"$f":"E6","v":1.5},null,"Hinweise: Die Kostenfunktion wird in die Zellen E6 - F6 ",null,null,null,null,null,"Kosten in Abhängigkeit von der Preisstruktur",null,null,null,30,5.6999436897726508]
[null,"Grenzkosten","K'=",null,null,{"$f":"E6","v":1.5},null,"eingetragen. (E6: mengenabhängiger Teil, ",null,null,null,null,null,"pch-p2m-p3n","p2h-pcm-p3n","p3h-pcm-p2n",null,36,5.6399324277271816]
[null,"fixe Gesamtkosten","Kf=",null,null,{"$f":"F6","v":150},null,"variable Stückkosten; F6: konstanter Teil, fixe Kosten)",null,null,null,null,null,{"$f":"F6+(E6*G25)","v":450},{"$f":"F6+(E6*G25)","v":450},{"$f":"F6+(E6*G24)","v":300},null,42,5.5799211656817116]
[null,"fixe Stückkosten","kf=",null,null,null,{"$f":"F6","v":150},"Die Preis-Absatz-Funktion wird in die Zellen ",null,null,null,null,null,"pch-p3m-p2n","p2h-p3m-pcn","p3h-p2m-pcn",null,48,5.5199099036362416]
[null,"Erlös ","E=",{"$f":"E7","v":-1.0001877007578295E-2},{"$f":"F7","v":6},null,null,"E7 - F7 eingetragen. (mengenabhängiger Teil in Spalte E, ",null,null,null,null,null,{"$f":"F6+(E6*G24)","v":300},{"$f":"F6+(E6*G26)","v":487.5},{"$f":"F6+(E6*G26)","v":487.5},null,54,5.4598986415907724]
[null,"Grenzerlös ","E'=",null,{"$f":"D14*2","v":-2.000375401515659E-2},{"$f":"E14","v":6},null,"konstanter Teil in Spalte F)",null,null,null,null,null,null,null,null,null,60,5.3998873795453024]
[null,"Sättigungsmenge","xmax=",null,null,{"$f":"ROUND(F7/E7*-1,0)","v":600},null,"Gewinnänderungen aufgrund der Preisdifferenzierung ",null,null,null,null,null,"Gewinn in Abhängigkeit von der Preisstruktur",null,null,null,66,5.3398761174998324]
[null,null,null,null,null,null,null,"werden in Zelle G30 angezeigt. ",null,null,null,null,null,"pch-p2m-p3n","p2h-pcm-p3n","p3h-pcm-p2n",null,72,5.2798648554543632]
[null,null,"Gewinnmaximum (Cournotscher Punkt)",null,null,null,null,"Musterfunktionen können von der Seite \"Funktionen\" ",null,null,null,null,null,{"$f":"N6-N12","v":168.65497649134886},{"$f":"O6-O12","v":418.69720916186043},{"$f":"P6-P12","v":-31.260558167627892},null,78,5.2198535934088932]
[null,null,null,null,null,null,null,"kopiert und in die Zellen E6 - F7 eingefügt werden.",null,null,null,null,null,"pch-p3m-p2n","p2h-p3m-pcn","p3h-p2m-pcn",null,84,5.1598423313634232]
[null,null,"XGmax","PGmax","Gmax","E","K",null,null,null,null,null,null,{"$f":"N8-N14","v":-56.345023508651138},{"$f":"O8-O14","v":506.23944183237211},{"$f":"P8-P14","v":281.19720916186043},null,90,5.0998310693179532]
[null,null,{"$f":"ROUND((F15-F11)/(E15*-1),0)","v":225},{"$f":"F7+(E7*C21)","v":3.7495776732948838},{"$f":"F21-G21","v":356.15497649134886},{"$f":"(D14*C21*C21)+(E14*C21)","v":843.65497649134886},{"$f":"(E6*C21)+F6","v":487.5},null,null,null,null,null,null,null,null,null,null,96,5.039819807272484]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,102,4.979808545227014]
[null,"Preisdifferenzierung",null,null,"Preisstruktur",null,"Menge",null,null,null,null,null,null,null,null,null,null,108,4.919797283181544]
[null,"p2",5,{"$f":"IF(OR(C24>F7,G24<0),\"nicht definiert\",\"definiert\")","v":"definiert"},{"$f":"IF(AND(C24>C26,C24>C25),\"Hochpreis\",IF(AND(C24<C26,C24<C25),\"Niedrigpreis\",\"Mittelpreis\"))","v":"Hochpreis"},{"$f":"IF(E24=\"Hochpreis\",1,IF(E24=\"Mittelpreis\",2,3))","v":1},{"$f":"ROUND((C24-F7)/(E7),0)","v":100},null,null,null,null,null,null,null,null,null,null,114,4.8597860211360739]
[null,"p3",4,{"$f":"IF(OR(C25>F7,G25<0),\"nicht definiert\",\"definiert\")","v":"definiert"},{"$f":"IF(AND(C25>C26,C25>C24),\"Hochpreis\",IF(AND(C25<C26,C25<C24),\"Niedrigpreis\",\"Mittelpreis\"))","v":"Mittelpreis"},{"$f":"IF(E25=\"Hochpreis\",1,IF(E25=\"Mittelpreis\",2,3))","v":2},{"$f":"ROUND((C25-F7)/E7,0)","v":200},null,null,null,null,null,null,null,null,null,null,120,4.7997747590906048]
[null,"pc",{"$f":"D21","v":3.7495776732948838},"definiert",{"$f":"IF(AND(C26>C24,C26>C25),\"Hochpreis\",IF(AND(C26<C24,C26<C25),\"Niedrigpreis\",\"Mittelpreis\"))","v":"Niedrigpreis"},{"$f":"IF(E26=\"Hochpreis\",1,IF(E26=\"Mittelpreis\",2,3))","v":3},{"$f":"C21","v":225},null,null,null,null,null,null,null,null,null,null,126,4.7397634970451348]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,132,4.6797522349996648]
[null,"Umsatz",{"$f":"IF(AND(F26=1,F24=2),N6,IF(AND(F26=1,F25=2),N8,IF(AND(F24=1,F26=2),O6,IF(AND(F24=1,F25=2),O8,IF(AND(F25=1,F26=2),P6,P8)))))","v":993.73944183237211},"Gewinn mit Preisdifferenzierung",null,null,{"$f":"C30","v":506.23944183237211},null,null,null,null,null,null,null,null,null,null,138,4.6197409729541956]
[null,"Kosten",{"$f":"IF(AND(F26=1,F24=2),N12,IF(AND(F26=1,F25=2),N14,IF(AND(F24=1,F26=2),O12,IF(AND(F24=1,F25=2),O14,IF(AND(F25=1,F26=2),P12,P14)))))","v":487.5},"Gewinn ohne Preisdifferenzierung",null,null,{"$f":"E21","v":356.15497649134886},null,null,null,null,null,null,null,null,null,null,144,4.5597297109087256]
[null,"Gewinn",{"$f":"C28-C29","v":506.23944183237211},"Differenz",null,null,{"$f":"G28-G29","v":150.08446534102325},null,null,null,null,null,null,null,null,null,null,150,4.4997184488632556]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,156,4.4397071868177864]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,162,4.3796959247723164]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,168,4.3196846627268464]
[null,null,null,null,null,null,null,null,null,null,null,null,"Matrix der Preis-Mengen-Kombinationen (Datenreihen für das Punktdiagramm)",null,null,null,null,174,4.2596734006813772]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,180,4.1996621386359072]
[null,null,null,null,null,null,null,null,null,null,null,null,"Cournotscher Punkt",null,null,null,null,186,4.1396508765904372]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C21","v":225},0,0,{"$f":"D21","v":3.7495776732948838},null,192,4.0796396145449672]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C21","v":225},{"$f":"D21","v":3.7495776732948838},{"$f":"C21","v":225},{"$f":"D21","v":3.7495776732948838},null,198,4.0196283524994971]
[null,null,null,null,null,null,null,null,null,null,null,null,"Preis 2, Menge 2",null,null,null,null,204,3.959617090454028]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"G24","v":100},0,0,{"$f":"C24","v":5},null,210,3.899605828408558]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"G24","v":100},{"$f":"C24","v":5},{"$f":"G24","v":100},{"$f":"C24","v":5},null,216,3.8395945663630884]
[null,null,null,null,null,null,null,null,null,null,null,null,"Preis 3, Menge 3",null,null,null,null,222,3.7795833043176184]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"G25","v":200},0,0,{"$f":"C25","v":4},null,228,3.7195720422721488]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"G25","v":200},{"$f":"C25","v":4},{"$f":"G25","v":200},{"$f":"C25","v":4},null,234,3.6595607802266792]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,240,3.5995495181812092]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Matrix der Preis-Absatz-Funktion (Datenreihen für dasPunktdiagramm)",null,null,null,246,3.5395382561357396]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,252,3.4795269940902696]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,258,3.4195157320448]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"F7","v":6},null,null,264,3.3595044699993299]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"F16","v":600},0,null,null,270,3.2994932079538604]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,276,3.2394819459083908]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,282,3.1794706838629208]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,288,3.1194594218174512]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,294,3.0594481597719811]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,300,2.9994368977265116]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,306,2.9394256356810415]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,312,2.879414373635572]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,318,2.8194031115901024]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,324,2.7593918495446323]
[null,"Berechnungen: Spalte N - S; Schriftfarbe: weiß",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,330,2.6993805874991628]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,336,2.6393693254536927]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,342,2.5793580634082232]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,348,2.5193468013627536]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,354,2.4593355393172835]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,360,2.399324277271814]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,366,2.3393130152263439]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,372,2.2793017531808744]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,378,2.2192904911354043]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,384,2.1592792290899347]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,390,2.0992679670444652]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,396,{"$f":"$F$7+$E$7*R71","v":2.0392567049989951}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R71+$R$6","v":402},1.9792454429535251]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,408,1.919234180908056]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,414,1.8592229188625859]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,420,1.7992116568171159]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,426,1.7392003947716468]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,432,1.6791891327261768]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,438,1.6191778706807067]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,444,1.5591666086352367]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,450,1.4991553465897676]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,456,1.4391440845442975]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,462,1.3791328224988275]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,468,1.3191215604533584]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,474,1.2591102984078884]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,480,1.1990990363624183]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,486,1.1390877743169483]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,492,1.0790765122714792]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,498,1.0190652502260091]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,504,0.95905398818053911]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,510,0.89904272613506997]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,516,0.83903146408959994]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,522,0.77902020204412992]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,528,0.71900893999865989]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,534,0.65899767795319075]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,540,0.59898641590772073]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,546,0.5389751538622507]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,552,0.47896389181678156]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,558,0.41895262977131154]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,564,0.35894136772584151]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,570,0.29893010568037148]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,576,0.23891884363490234]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,582,0.17890758158943232]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,588,0.11889631954396229]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,594,5.8885057498493154E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"F16","v":600},-1.1262045469768722E-3]

{"sheet":"FunktionenMonopol","index":4,"n_rows":25,"n_cols":20,"rows_kept":25,"cut":false,"hidden":false,"merged":[[19,13,19,14],[19,15,19,16],[19,1,19,2],[19,3,19,4],[19,5,19,6],[19,7,19,8],[19,9,19,10],[19,11,19,12],[11,13,11,14],[11,15,11,16],[15,1,15,2],[15,3,15,4],[15,5,15,6],[15,7,15,8],[15,9,15,10],[15,11,15,12],[15,13,15,14],[15,15,15,16],[11,1,11,2],[11,3,11,4],[11,5,11,6],[11,7,11,8],[11,9,11,10],[11,11,11,12],[3,13,3,14],[3,15,3,16],[7,1,7,2],[7,3,7,4],[7,5,7,6],[7,7,7,8],[7,9,7,10],[7,11,7,12],[7,13,7,14],[7,15,7,16],[3,1,3,2],[3,3,3,4],[3,5,3,6],[3,7,3,8],[3,9,3,10],[3,11,3,12]]}
[]
[]
[]
[null,"Aufgabe 1",null,"Aufgabe 2",null,"Aufgabe 3",null,"Aufgabe 4",null,"Aufgabe 5",null,"Aufgabe 6",null,"Aufgabe 7",null,"Aufgabe 8",null,"1/25",0.04,25]
["K",300,10000,4,5100,4,5100,4,5100,2,2450,14,5000,14,5000,4,2950,"1/75",1.3333333333333334E-2,75]
["PAF",-15,1200,-1.25E-3,15,-0.01,22,-2E-3,12,-0.45,92,-0.2,100,-0.5,120,-0.35499999999999998,85,"1/125",8.0000000000000002E-3,125]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1/40",2.5000000000000001E-2,40]
[null,"Aufgabe 9",null,"Aufgabe 10",null,"Aufgabe 11",null,"Aufgabe 12",null,"Aufgabe 13",null,"Aufgabe 14",null,"Aufgabe 15",null,"Aufgabe 16",null,"1/60",1.6666666666666666E-2,60]
["K",6.8,580,9,3250,9,3250,9,3250,5.8,1900,5.8,1900,5.8,1900,89,29950,"1/80",1.2500000000000001E-2,80]
["PAF",-1.1499999999999999,85,-0.19850000000000001,100,-0.50149999999999995,120,-0.1055,60,-0.45,92,-1.25,125,-0.3,55,-2.2000000000000002,920,"1/90",1.1111111111111112E-2,90]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1/20",0.05,20]
[null,"Aufgabe 17",null,"Aufgabe 18",null,"Aufgabe 19",null,"Aufgabe 20",null,"Aufgabe 21",null,"Aufgabe 22",null,"Aufgabe 23",null,"Aufgabe 24",null,"1/30",3.3333333333333333E-2,30]
["K",89,29950,89,29950,12,5100,12,5100,12,5100,40,2950,40,75500,20,20000,"1/300",3.3333333333333335E-3,300]
["PAF",-4.4000000000000004,1100,-3.1,925,-0.25,150,-0.5,190,-0.25,120,-0.125,92,-0.125,300,-3.3300000000000001E-3,40,"1/125",4.4444444444444444E-3,225]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1/45",2.2222222222222223E-2,45]
[null,"Aufgabe 17",null,"Aufgabe 18",null,"Aufgabe 19",null,"Aufgabe 20",null,"Aufgabe 21",null,"Aufgabe 22",null,"Aufgabe 23",null,"Aufgabe 24",null,"1/150",6.6666666666666671E-3,150]
["K",89,29950,89,29950,12,5100,12,5100,12,5100,40,2950,40,75500,null,null,"1/250",4.0000000000000001E-3,250]
["PAF",-4.4000000000000004,1100,-3.1,925,-0.25,150,-0.5,190,-0.25,120,-0.125,92,-0.125,300,null,null,"1/15",6.6666666666666666E-2,15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1/8",0.125,8]
[null,"Aufgabe 25",null,"Aufgabe 26",null,"Aufgabe 27",null,"Aufgabe 28",null,"Aufgabe 29",null,"Aufgabe 30",null,"Aufgabe 31",null,"Aufgabe 32",null,"1/16",6.25E-2,16]
["K",400,29950,1.5,150,null,null,null,null,null,null,null,null,null,null,null,null,"1/32",3.125E-2,32]
["PAF",-4.4000000000000004,1100,-1.0001877007578295E-2,6,null,null,null,null,null,null,null,null,null,null,null,null,"1/64",1.5625E-2,64]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1/500",2E-3,500]
[]
["Hinweis: Sie können Funktionen markieren und kopieren und dann in die Felder E6 - F7 in der Tabelle \"Monopol\" einfügen. Das Gewinnmaximum (Cournotscher Punkt) wird dann ermittelt."]