{"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,"simuliert 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":[[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],[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],[3,15,7,17],[8,15,9,17],[13,15,14,17],[2,24,2,34],[1,1,1,12],[3,31,3,34]]}
[]
[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":15},{"$f":"$F$8+$E$8*Y5","v":22},{"$f":"$F$9+$E$9*Y5","v":12},{"$f":"IF(AND($Z5<$AA5,$AA5>$AB5),Z5,IF(AND($AA5>$AB5,$Z5>$AB5),AA5,AB5))","v":15},{"$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,4,5100,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":4400},null,null,null,null,null,null,null,{"$f":"(J18*N18)+((J16*N16)-(J16*N18))+((J17*N17)-(J17*N16))","v":15925},{"$f":"(J16*N16)+((J18*N18)-(J18*N16))+((J17*N17)-(J17*N18))","v":19525},{"$f":"(J17*N17)+((J18*N18)-(J18*N17))+((J16*N16)-(J16*N18))","v":-3425},null,{"$f":"F22/100","v":60},{"$f":"$F$7+$E$7*Y6","v":14.925000000000001},{"$f":"$F$8+$E$8*Y6","v":21.4},{"$f":"$F$9+$E$9*Y6","v":11.88},{"$f":"IF(AND($Z6<$AA6,$AA6>$AB6),Z6,IF(AND($AA6>$AB6,$Z6>$AB6),AA6,AB6))","v":14.925000000000001},{"$f":"Y6","v":60},1,"PAF1",{"$f":"IF(AF6=\"PAF1\",AD6,\"\")","v":60},{"$f":"IF(AF6=\"PAF2\",AD6,\"\")","v":""},{"$f":"IF(AF6=\"PAF3\",AD6,\"\")","v":""}]
[null,"Preis-Absatz-Funktion 1","p1=",null,-1.25E-3,15,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":3000},{"$f":"IF(J7=\"definiert\",F8+(E8*M7),\"\")","v":13},{"$f":"ROUND((F19-F13)/(E19*-1),0)","v":900},null,null,null,null,null,null,null,"pch-p3m-p2n","p2h-p3m-pcn","p3h-p2m-pcn",null,{"$f":"Y6+$Y$6","v":120},14.85,20.8,11.76,{"$f":"IF(AND($Z7<$AA7,$AA7>$AB7),Z7,IF(AND($AA7>$AB7,$Z7>$AB7),AA7,AB7))","v":14.85},120,2,"PAF1",{"$f":"IF(AF7=\"PAF1\",AD7,\"\")","v":120},{"$f":"IF(AF7=\"PAF2\",AD7,\"\")","v":""},{"$f":"IF(AF7=\"PAF3\",AD7,\"\")","v":""}]
[null,"Preis-Absatz-Funktion 2","p2=",null,-0.01,22,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":2900},{"$f":"IF(J8=\"definiert\",F9+(E9*M8),\"\")","v":8},{"$f":"ROUND((F21-F13)/(E21*-1),0)","v":2000},null,null,null,null,null,null,null,{"$f":"(J18*N18)+((J17*N17)-(J17*N18))+((J16*N16)-(J16*N17))","v":-650},{"$f":"(J16*N16)+((J17*N17)-(J17*N16))+((J18*N18)-(J18*N17))","v":6225},{"$f":"(J17*N17)+((J16*N16)-(J16*N17))+((J18*N18)-(J18*N16))","v":1800},null,{"$f":"Y7+$Y$6","v":180},14.775,20.2,11.64,14.775,180,3,"PAF1",180,"",""]
[null,"Preis-Absatz-Funktion 3","p3=",null,-2E-3,12,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,240,14.7,19.600000000000001,11.52,14.7,240,4,"PAF1",240,"",""]
[null,"variable Gesamtkosten","Kv=",null,{"$f":"E6","v":4},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,300,14.625,19,11.4,14.625,300,5,"PAF1",300,"",""]
[null,"Stückkosten","k=",null,null,{"$f":"E6","v":4},{"$f":"F6","v":5100},null,"PAF1",0,{"$f":"ROUND((F8-F7)/(E7+E8*-1),0)","v":800},"Gmax",{"$f":"MAX(K6:K8)","v":3000},null,null,{"$f":"F7","v":15},{"$f":"F7+(E7*K11)","v":14},null,null,null,"pch-p2m-p3n","p2h-pcm-p3n","p3h-pcm-p2n",null,360,14.55,18.399999999999999,11.28,14.55,360,6,"PAF1",360,"",""]
[null,"variable Stückkosten","kv=",null,null,{"$f":"E6","v":4},null,null,"PAF2",{"$f":"ROUND(K11,0)","v":800},{"$f":"ROUND((F9-F8)/(E8+E9*-1),0)","v":1250},"XGmax",{"$f":"ROUND(VLOOKUP(M11,K6:M8,3),0)","v":900},null,null,{"$f":"F8+(E8*J12)","v":14},{"$f":"F8+(E8*K12)","v":9.5},null,null,null,{"$f":"F6+(E6*N17)","v":12100},{"$f":"F6+(E6*N17)","v":12100},{"$f":"F6+(E6*N16)","v":6700},null,420,14.475,17.8,11.16,14.475,420,7,"PAF1",420,"",""]
[null,"Grenzkosten","K'=",null,null,{"$f":"E6","v":4},null,null,"PAF3",{"$f":"K12","v":1250},{"$f":"F22","v":6000},"PGmax",{"$f":"VLOOKUP(M11,K6:M8,2)","v":13},null,null,{"$f":"F9+(E9*J13)","v":9.5},{"$f":"F9+(E9*F22)","v":0},null,null,null,"pch-p3m-p2n","p2h-p3m-pcn","p3h-p2m-pcn",null,480,14.4,17.2,11.04,14.4,480,8,"PAF1",480,"",""]
[null,"fixe Gesamtkosten","Kf=",null,null,{"$f":"F6","v":5100},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":6700},{"$f":"F6+(E6*N18)","v":8700},{"$f":"F6+(E6*N18)","v":8700},null,540,14.324999999999999,16.600000000000001,10.92,14.324999999999999,540,9,"PAF1",540,"",""]
[null,"fixe Stückkosten","kf=",null,null,null,{"$f":"F6","v":5100},null,"Preisdifferenzierung",null,null,"Preisstruktur",null,"Menge",null,null,null,null,null,null,null,null,null,null,600,14.25,16,10.8,14.25,600,10,"PAF1",600,"",""]
[null,"Erlös 1","E1=",{"$f":"E7","v":-1.25E-3},{"$f":"F7","v":15},null,null,null,"p2",14.5,{"$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":400},null,"x(p1)","x(p2)","x(p3)",null,null,"Gewinn in Abhängigkeit von der Preisstruktur",null,null,null,660,14.175000000000001,15.399999999999999,10.68,14.175000000000001,660,11,"PAF1",660,"",""]
[null,"Grenzerlös 1","E1'=",null,{"$f":"2*D16","v":-2.5000000000000001E-3},{"$f":"E16","v":15},null,null,"p3",8.5,{"$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":1750},null,{"$f":"(F7-J16)/(E7*-1)","v":400},{"$f":"(F8-J16)/(E8*-1)","v":750},{"$f":"(F9-J16)/(E9*-1)","v":-1250},null,null,"pch-p2m-p3n","p2h-pcm-p3n","p3h-pcm-p2n",null,720,14.1,14.8,10.56,14.1,720,12,"PAF1",720,"",""]
[null,"Erlös 2","E2=",{"$f":"E8","v":-0.01},{"$f":"F8","v":22},null,null,null,"pc",{"$f":"M13","v":13},"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":900},null,{"$f":"(F7-J17)/(E7*-1)","v":5200},{"$f":"(F8-J17)/(E8*-1)","v":1350},{"$f":"(F9-J17)/(E9*-1)","v":1750},null,null,{"$f":"U6-U12","v":3825},{"$f":"V6-V12","v":7425},{"$f":"W6-W12","v":-10125},null,780,14.025,14.2,10.44,14.025,780,13,"PAF1",780,"",""]
[null,"Grenzerlös 2","E2'=",null,{"$f":"2*D18","v":-0.02},{"$f":"E18","v":22},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pch-p3m-p2n","p2h-p3m-pcn","p3h-p2m-pcn",null,840,13.95,13.6,10.32,13.6,840,14,"PAF2","",840,""]
[null,"Erlös 3","E3=",{"$f":"E9","v":-2E-3},{"$f":"F9","v":12},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":19525},"Gewinn mit Preisdifferenzierung",null,null,{"$f":"J22","v":7425},null,null,null,null,null,null,{"$f":"U8-U14","v":-7350},{"$f":"V8-V14","v":-2475},{"$f":"W8-W14","v":-6900},null,900,13.875,13,10.199999999999999,13,900,15,"PAF2","",900,""]
[null,"Grenzerlös 3","E3'=",null,{"$f":"2*D20","v":-4.0000000000000001E-3},{"$f":"E20","v":12},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":12100},"Gewinn ohne Preisdifferenzierung",null,null,{"$f":"M11","v":3000},null,"Matrix der Preis-Absatz-Funktion (Datenreihen für dasPunktdiagramm)",null,null,null,null,null,null,null,null,960,13.8,12.4,10.08,12.4,960,16,"PAF2","",960,""]
[null,"Sättigungsmenge","xmax=",null,null,{"$f":"ROUND((F9/E9)*-1,0)","v":6000},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":7425},"Differenz",null,null,{"$f":"N20-N21","v":4425},null,null,null,null,null,null,null,null,null,null,1020,13.725,11.799999999999999,9.9600000000000009,11.799999999999999,1020,17,"PAF2","",1020,""]
[null,null,null,null,null,null,null,null,"UP2","UP2","UP3","Kv","Kf",null,null,"PAF1",0,{"$f":"P11","v":15},null,null,null,null,null,null,1080,13.65,11.2,9.84,11.2,1080,18,"PAF2","",1080,""]
[null,null,null,null,null,null,null,null,{"$f":"J16*N16","v":5800},{"$f":"J18*(N18-N16)","v":6500},{"$f":"J17*(N17-N18)","v":7225},{"$f":"E6*N17","v":7000},{"$f":"F6","v":5100},null,null,null,{"$f":"K11","v":800},{"$f":"Q11","v":14},null,null,null,null,null,null,1140,13.574999999999999,10.6,9.7199999999999989,10.6,1140,19,"PAF2","",1140,""]
[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":800},{"$f":"P12","v":14},null,null,null,{"$f":"16-(-E7*K11)","v":15},null,null,1200,13.5,10,9.6,10,1200,20,"PAF2","",1200,""]
[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":1250},{"$f":"Q12","v":9.5},null,null,null,{"$f":"F8-(-E8*K12)","v":9.5},null,null,1260,13.425000000000001,9.4,9.48,9.48,1260,21,"PAF3","","",1260]
[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":1250},{"$f":"P13","v":9.5},null,null,null,null,null,null,1320,13.35,8.7999999999999989,9.36,9.36,1320,22,"PAF3","","",1320]
[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":6000},0,null,null,null,null,null,null,1380,13.275,8.1999999999999993,9.24,9.24,1380,23,"PAF3","","",1380]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1440,13.2,7.6,9.120000000000001,9.120000000000001,1440,24,"PAF3","","",1440]
[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,1500,13.125,7,9,9,1500,25,"PAF3","","",1500]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1560,13.05,6.4,8.879999999999999,8.879999999999999,1560,26,"PAF3","","",1560]
[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,1620,12.975,5.8000000000000007,8.76,8.76,1620,27,"PAF3","","",1620]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M12","v":900},0,0,{"$f":"M13","v":13},null,null,null,null,null,1680,12.9,5.1999999999999993,8.64,8.64,1680,28,"PAF3","","",1680]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M12","v":900},{"$f":"M13","v":13},{"$f":"M12","v":900},{"$f":"M13","v":13},null,null,null,null,null,1740,12.824999999999999,4.5999999999999979,8.52,8.52,1740,29,"PAF3","","",1740]
[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,1800,12.75,4,8.4,8.4,1800,30,"PAF3","","",1800]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"N16","v":400},0,0,{"$f":"J16","v":14.5},null,null,null,null,null,1860,12.675000000000001,3.3999999999999986,8.2799999999999994,8.2799999999999994,1860,31,"PAF3","","",1860]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"N16","v":400},{"$f":"J16","v":14.5},{"$f":"N16","v":400},{"$f":"J16","v":14.5},null,null,null,null,null,1920,12.6,2.8000000000000007,8.16,8.16,1920,32,"PAF3","","",1920]
[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,1980,12.525,2.1999999999999993,8.0399999999999991,8.0399999999999991,1980,33,"PAF3","","",1980]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"N17","v":1750},0,0,{"$f":"J17","v":8.5},null,null,null,null,null,2040,12.45,1.5999999999999979,7.92,7.92,2040,34,"PAF3","","",2040]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"N17","v":1750},{"$f":"J17","v":8.5},{"$f":"N17","v":1750},{"$f":"J17","v":8.5},null,null,null,null,null,2100,12.375,1,7.8,7.8,2100,35,"PAF3","","",2100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2160,12.3,0.39999999999999858,7.68,7.68,2160,36,"PAF3","","",2160]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2220,12.225,-0.19999999999999929,7.56,7.56,2220,37,"PAF3","","",2220]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2280,12.15,-0.80000000000000071,7.4399999999999995,7.4399999999999995,2280,38,"PAF3","","",2280]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2340,12.074999999999999,-1.4000000000000021,7.32,7.32,2340,39,"PAF3","","",2340]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2400,12,-2,7.2,7.2,2400,40,"PAF3","","",2400]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2460,11.925000000000001,-2.6000000000000014,7.08,7.08,2460,41,"PAF3","","",2460]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2520,11.85,-3.1999999999999993,6.96,6.96,2520,42,"PAF3","","",2520]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2580,11.775,-3.8000000000000007,6.84,6.84,2580,43,"PAF3","","",2580]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2640,11.7,-4.4000000000000021,6.72,6.72,2640,44,"PAF3","","",2640]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2700,11.625,-5,6.6,6.6,2700,45,"PAF3","","",2700]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2760,11.55,-5.6000000000000014,6.4799999999999995,6.4799999999999995,2760,46,"PAF3","","",2760]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2820,11.475,-6.1999999999999993,6.36,6.36,2820,47,"PAF3","","",2820]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2880,11.4,-6.8000000000000007,6.24,6.24,2880,48,"PAF3","","",2880]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2940,11.324999999999999,-7.4000000000000021,6.12,6.12,2940,49,"PAF3","","",2940]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3000,11.25,-8,6,6,3000,50,"PAF3","","",3000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3060,11.175000000000001,-8.6000000000000014,5.88,5.88,3060,51,"PAF3","","",3060]
[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,3120,11.1,-9.1999999999999993,5.76,5.76,3120,52,"PAF3","","",3120]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3180,11.025,-9.8000000000000007,5.64,5.64,3180,53,"PAF3","","",3180]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3240,10.95,-10.399999999999999,5.52,5.52,3240,54,"PAF3","","",3240]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3300,10.875,-11,5.3999999999999995,5.3999999999999995,3300,55,"PAF3","","",3300]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3360,10.8,-11.600000000000001,5.28,5.28,3360,56,"PAF3","","",3360]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3420,10.725,-12.200000000000003,5.16,5.16,3420,57,"PAF3","","",3420]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3480,10.649999999999999,-12.800000000000004,5.04,5.04,3480,58,"PAF3","","",3480]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3540,10.574999999999999,-13.399999999999999,4.92,4.92,3540,59,"PAF3","","",3540]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3600,10.5,-14,4.8,4.8,3600,60,"PAF3","","",3600]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3660,10.425000000000001,-14.600000000000001,4.68,4.68,3660,61,"PAF3","","",3660]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3720,10.35,-15.200000000000003,4.5599999999999996,4.5599999999999996,3720,62,"PAF3","","",3720]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3780,10.274999999999999,-15.800000000000004,4.4399999999999995,4.4399999999999995,3780,63,"PAF3","","",3780]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3840,10.199999999999999,-16.399999999999999,4.32,4.32,3840,64,{"$f":"IF(AC69=Z69,\"PAF1\",IF(AC69=AA69,\"PAF2\",\"PAF3\"))","v":"PAF3"},"","",3840]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3900,{"$f":"$F$7+$E$7*Y70","v":10.125},{"$f":"$F$8+$E$8*Y70","v":-17},{"$f":"$F$9+$E$9*Y70","v":4.2},4.2,{"$f":"Y70","v":3900},65,"PAF3","","",3900]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3960,10.050000000000001,-17.600000000000001,4.08,{"$f":"IF(AND($Z71<$AA71,$AA71>$AB71),Z71,IF(AND($AA71>$AB71,$Z71>$AB71),AA71,AB71))","v":4.08},3960,66,"PAF3",{"$f":"IF(AF71=\"PAF1\",AD71,\"\")","v":""},{"$f":"IF(AF71=\"PAF2\",AD71,\"\")","v":""},{"$f":"IF(AF71=\"PAF3\",AD71,\"\")","v":3960}]
[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":4020},9.9749999999999996,-18.200000000000003,3.9599999999999991,3.9599999999999991,4020,67,"PAF3","","",4020]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4080,9.8999999999999986,-18.800000000000004,3.84,3.84,4080,68,"PAF3","","",4080]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4140,9.8249999999999993,-19.399999999999999,3.7200000000000006,3.7200000000000006,4140,69,"PAF3","","",4140]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4200,9.75,-20,3.5999999999999996,3.5999999999999996,4200,70,"PAF3","","",4200]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4260,9.6750000000000007,-20.6,3.4800000000000004,3.4800000000000004,4260,71,"PAF3","","",4260]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4320,9.6,-21.200000000000003,3.3599999999999994,3.3599999999999994,4320,72,"PAF3","","",4320]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4380,9.5249999999999986,-21.800000000000004,3.24,3.24,4380,73,"PAF3","","",4380]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4440,9.4499999999999993,-22.4,3.1199999999999992,3.1199999999999992,4440,74,"PAF3","","",4440]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4500,9.375,-23,3,3,4500,75,"PAF3","","",4500]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4560,9.3000000000000007,-23.6,2.879999999999999,2.879999999999999,4560,76,"PAF3","","",4560]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4620,9.2249999999999996,-24.200000000000003,2.76,2.76,4620,77,"PAF3","","",4620]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4680,9.1499999999999986,-24.800000000000004,2.6400000000000006,2.6400000000000006,4680,78,"PAF3","","",4680]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4740,9.0749999999999993,-25.4,2.5199999999999996,2.5199999999999996,4740,79,"PAF3","","",4740]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4800,9,-26,2.4000000000000004,2.4000000000000004,4800,80,"PAF3","","",4800]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4860,8.9250000000000007,-26.6,2.2799999999999994,2.2799999999999994,4860,81,"PAF3","","",4860]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4920,8.85,-27.200000000000003,2.16,2.16,4920,82,"PAF3","","",4920]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4980,8.7749999999999986,-27.800000000000004,2.0399999999999991,2.0399999999999991,4980,83,"PAF3","","",4980]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5040,8.6999999999999993,-28.4,1.92,1.92,5040,84,"PAF3","","",5040]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5100,8.625,-29,1.7999999999999989,1.7999999999999989,5100,85,"PAF3","","",5100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5160,8.5500000000000007,-29.6,1.6799999999999997,1.6799999999999997,5160,86,"PAF3","","",5160]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5220,8.4749999999999996,-30.200000000000003,1.5600000000000005,1.5600000000000005,5220,87,"PAF3","","",5220]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5280,8.3999999999999986,-30.800000000000004,1.4399999999999995,1.4399999999999995,5280,88,"PAF3","","",5280]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5340,8.3249999999999993,-31.4,1.3200000000000003,1.3200000000000003,5340,89,"PAF3","","",5340]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5400,8.25,-32,1.1999999999999993,1.1999999999999993,5400,90,"PAF3","","",5400]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5460,8.1750000000000007,-32.6,1.08,1.08,5460,91,"PAF3","","",5460]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5520,8.1,-33.200000000000003,0.95999999999999908,0.95999999999999908,5520,92,"PAF3","","",5520]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5580,8.0249999999999986,-33.800000000000004,0.83999999999999986,0.83999999999999986,5580,93,"PAF3","","",5580]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5640,7.95,-34.4,0.72000000000000064,0.72000000000000064,5640,94,"PAF3","","",5640]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5700,7.875,-35,0.59999999999999964,0.59999999999999964,5700,95,"PAF3","","",5700]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5760,7.8,-35.6,0.48000000000000043,0.48000000000000043,5760,96,"PAF3","","",5760]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5820,7.7249999999999996,-36.200000000000003,0.35999999999999943,0.35999999999999943,5820,97,"PAF3","","",5820]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5880,7.6499999999999995,-36.800000000000004,0.24000000000000021,0.24000000000000021,5880,98,"PAF3","","",5880]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5940,7.5750000000000002,-37.4,0.11999999999999922,0.11999999999999922,5940,99,"PAF3","","",5940]
[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":6000},7.5,-38,0,0,6000,100,"PAF3","","",6000]

{"sheet":"FunktionenunvollkommenerMark","index":2,"n_rows":24,"n_cols":17,"rows_kept":24,"cut":false,"hidden":false,"merged":[[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],[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]]}
[]
[]
[]
[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":[[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],[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],[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]]}
[]
[]
[]
[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."]