{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Stückanalyse","Gesamtanalyse","Funktionen"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Stückanalyse","index":0,"n_rows":32,"n_cols":11,"rows_kept":32,"cut":false,"hidden":false,"merged":[[7,2,7,6],[12,2,12,4],[12,5,12,6],[14,1,15,1]]}
[]
[null,"Funktionen",null,"bX2","cX","d","d/X",null,null,"X-Werte","Y-Werte"]
[null,"Gesamtkosten","K=",null,6.8,580,null,null,"PAF1"]
[null,"Preis-Absatz-Funktion 1","p1=",null,-1.1499999999999999,85]
[null,"Preis-Absatz-Funktion 2","p2=",null,-2.4,105,null,null,"PAF2",16,66.599999999999994]
[null,"Preis-Absatz-Funktion 3","p3=",null,-0.95,65,null,null,null,28,37.799999999999997]
[null,null,null,null,null,null,null,null,"PAF3"]
[null,null,"Gewinnmaximum"]
[null,null,null,null,"Gewinn","   Preis","   Menge",null,"K'"]
[null,null,"PAF1"]
[null,null,"PAF2",null,null,null,null,null,"E'1"]
[null,null,"PAF3"]
[null,null,"Definitionsbereiche",null,null,"Cournotscher Punkt",null,null,"E'1/E'2",16,48.2]
[null,null,null,"xmin","xmax",null,null,null,null,16,28.2]
[null,{"$f":"IF(AND(F5>F4,F5>F6),\"PAF-Reihe OK\",\"PAF-Reihe falsch\")","v":"PAF-Reihe OK"},"PAF1",null,null,null,null,null,"E'2"]
[null,null,"PAF2"]
[null,null,"PAF3",null,null,null,null,null,"E'2/E'3"]
[]
[null,"Funktionen",null,"bX2","cX","d","d/X",null,"E'3"]
[null,"variable Gesamtkosten","Kv=",null,{"$f":"E3","v":6.8}]
[null,"Stückkosten","k=",null,null,{"$f":"E3","v":6.8},{"$f":"F3","v":580},null,"XGmax"]
[null,"variable Stückkosten","kv=",null,null,{"$f":"E3","v":6.8}]
[null,"Grenzkosten","K'=",null,null,{"$f":"E3","v":6.8},null,null,"PGmax"]
[null,"fixe Gesamtkosten","Kf=",null,null,{"$f":"F3","v":580}]
[null,"fixe Stückkosten","kf=",null,null,null,{"$f":"F3","v":580}]
[null,"Erlös 1","E1=",{"$f":"E4","v":-1.1499999999999999},{"$f":"F4","v":85}]
[null,"Grenzerlös 1","E1'=",null,{"$f":"2*D26","v":-2.2999999999999998},{"$f":"E26","v":85}]
[null,"Erlös 2","E2=",{"$f":"E5","v":-2.4},{"$f":"F5","v":105}]
[null,"Grenzerlös 2","E2'=",null,{"$f":"2*D28","v":-4.8},{"$f":"E28","v":105}]
[null,"Erlös 3","E3=",{"$f":"E6","v":-0.95},{"$f":"F6","v":65}]
[null,"Grenzerlös 3","E3'=",null,{"$f":"2*D30","v":-1.9},{"$f":"E30","v":65}]
[null,"Sättigungsmenge","xmax=",null,null,{"$f":"(F6/E6)*-1","v":68.421052631578945}]

{"sheet":"Gesamtanalyse","index":1,"n_rows":12,"n_cols":19,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,null,null,null,"X","K","E1","E2","E3","E-K","E","K+G","K+G"]
[null,null,null,null,null,null,null,null,null,null,0]
[]
[]
[null,null,null,"X-Werte","Y-Werte"]
[null,null,"XGmax"]
[]
[null,null,"EGmax"]
[]
[]
[null,null,"Gmax"]

{"sheet":"Funktionen","index":2,"n_rows":20,"n_cols":17,"rows_kept":20,"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]
[]
[null,"Aufgabe 16",null,"Aufgabe 17",null,"Aufgabe 18",null,"Aufgabe 19",null,"Aufgabe 20",null,"Aufgabe 21",null,"Aufgabe 22",null,"Aufgabe 23"]
["K",40,500,4,4500,9,1900]
["PAF1",-0.5,105,-0.42,15,-0.45,92]
["PAF2",-1,120,-0.85,22,-1.25,125]
["PAF3",-0.4,90,-0.35,12,-0.3,55]