{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Start","varKurs","fixKurs"],"not_rendered":{"charts":0,"images":13,"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":"Start","index":0,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,2,8],[16,1,28,3]]}
[]
[null,"Prinzip der Kursberechnung von Aktien"]
[]
[]
[null,null,null,null,null,"Nach Klick auf den Button \"Eingabe\" können Sie bis zu"]
[null,null,null,null,null,"21 Kurse (incl. bestens und billigst) und deren Kauf-"]
[null,null,null,null,null,"bzw. Verkaufsaufträge eingeben."]
[null,"Die Kurse können frei gewählt werden.",null,null,null,"Nach Klick auf Kursberechnung wird der neue Kurs unter"]
[null,null,null,null,null,"Berücksichtigung der vorliegenden Aufträge ermittelt."]
[]
[null,null,null,null,null,"Nach Klick auf den Button \"Eingabe\" können Sie einen"]
[null,null,null,null,null,"Ausgangskurs und eine Kursvariation eingeben."]
[null,null,null,null,null,"Sie können dann Kauf- Verkaufsträge für bis zu 21 "]
[null,"Die Kurse sind durch Ausgangskurs und",null,null,null,"verschiedene feste Kurse (incl. bestens und billigst)"]
[null,"Kursvariation bestimmt.",null,null,null,"eingeben."]

{"sheet":"varKurs","index":1,"n_rows":29,"n_cols":11,"rows_kept":29,"cut":false,"hidden":false,"merged":[[3,1,4,7]]}
[]
[]
[]
[null,"Prinzip der Kursberechnung von Aktien",null,null,null,null,null,null,null,"Nach Klick auf den Button \"Eingabe\" können Sie bis zu"]
[null,null,null,null,null,null,null,null,null,"21 Kurse (incl. bestens und billigst) und deren Kauf-"]
[null,"bei variablen Kursen",null,null,null,null,null,null,null,"bzw. Verkaufsaufträge eingeben. Nach Klick auf "]
[null,null,"Kauf-","möglich","Verkaufs-","mögliche",null,null,null,"\"Berechnung\" werden die Aufträge sortiert und der"]
[null,"Limit","aufträge","Käufe","aufträge","Verkäufe","Umsatz","Limit",null,"neuer Kurs ermittelt."]
[null,"bestens",null,{"$f":"D10+C9","v":6069},90,{"$f":"E9","v":90},{"$f":"IF(D9>F9,F9,D9)","v":90},"bestens"]
[null,15,100,6069,0,{"$f":"F9+E10","v":90},{"$f":"IF(D10>F10,F10,D10)","v":90},{"$f":"B10","v":15}]
[null,17,50,5969,null,90,90,{"$f":"B11","v":17}]
[null,18,50,5919,90,180,180,18]
[null,20,null,5869,60,240,240,20,null,"neuer Kurs",{"$f":"VLOOKUP(K14,G9:H29,2,FALSE)","v":24.5}]
[null,21.5,80,5869,null,{"$f":"F13+E14","v":240},240,21.5,null,"Umsatz",{"$f":"MAX(G9:G29)","v":1080}]
[null,21.6,30,5789,60,300,300,21.6]
[null,21.75,110,5759,140,440,440,21.75]
[null,21.8,40,5649,190,630,630,21.8]
[null,22,210,5609,110,740,740,22]
[null,22.25,null,5399,40,780,780,22.25]
[null,22.3,null,5399,50,830,830,22.3]
[null,22.35,60,5399,null,830,830,22.35]
[null,22.5,60,5339,150,980,980,22.5]
[null,23.7,null,5279,60,1040,1040,23.7]
[null,24.25,19,5279,null,1040,1040,24.25]
[null,24.5,5000,5260,40,1080,1080,24.5]
[null,27,30,260,null,1080,260,27]
[null,28,null,{"$f":"D28+C27","v":230},100,1180,230,28]
[null,29,40,230,50,1230,230,29]
[null,"billigst",190,{"$f":"C29","v":190},null,1230,190,"billigst"]

{"sheet":"fixKurs","index":2,"n_rows":29,"n_cols":11,"rows_kept":29,"cut":false,"hidden":false,"merged":[[3,1,4,7]]}
[]
[]
[]
[null,"Prinzip der Kursberechnung von Aktien",null,null,null,null,null,null,null,"Nach Klick auf den Button \"Eingabe\" können Sie einen"]
[null,null,null,null,null,null,null,null,null,"Ausgangskurs und eine Kursvariation eingeben."]
[null,"bei festen Kursen",null,null,null,null,null,null,null,"Geben Sie die entsprechenden "]
[null,null,"Kauf-","möglich","Verkaufs-","mögliche",null,null,null,"Kauf- und Verkaufsaufträge "]
[null,"Limit","aufträge","Käufe","aufträge","Verkäufe","Umsatz","Limit",null,"für bis zu 21 verschiedene Kurse (incl. bestens und "]
[null,"bestens",null,{"$f":"D10+C9","v":4516},15,{"$f":"E9","v":15},{"$f":"IF(D9>F9,F9,D9)","v":15},"bestens",null,"billigst) in die gelben Felder ein."]
[null,{"$f":"B11-$K$12","v":51},80,4516,80,{"$f":"F9+E10","v":95},{"$f":"IF(D10>F10,F10,D10)","v":95},{"$f":"H11-$K$12","v":51}]
[null,52,900,4436,56,{"$f":"F10+E11","v":151},151,52,null,"Ausgangskurs",60]
[null,53,45,3536,43,194,194,53,null,"Kursvariation",1]
[null,54,78,3491,78,272,272,54,null,"neuer Kurs",{"$f":"VLOOKUP(K14,G9:H29,2,FALSE)","v":66}]
[null,55,110,3413,210,482,482,55,null,"Umsatz",{"$f":"MAX(G9:G29)","v":1498}]
[null,56,98,3303,190,672,672,56]
[null,57,110,3205,30,702,702,57]
[null,58,200,3095,48,750,750,58]
[null,{"$f":"B19-$K$12","v":59},134,2895,70,820,820,59]
[null,{"$f":"K11","v":60},100,2761,10,830,830,{"$f":"$K$11","v":60}]
[null,{"$f":"B19+$K$12","v":61},245,2661,80,910,910,{"$f":"H19+$K$12","v":61}]
[null,{"$f":"B20+$K$12","v":62},300,2416,85,995,995,62]
[null,63,30,2116,78,1073,1073,63]
[null,64,400,2086,80,1153,1153,64]
[null,65,68,1686,300,1453,1453,65]
[null,66,700,1618,45,1498,1498,66]
[null,67,600,918,300,1798,918,67]
[null,68,68,318,45,1843,318,68]
[null,69,60,{"$f":"D29+C28","v":250},150,1993,250,69]
[null,"billigst",190,{"$f":"C29","v":190},null,1993,190,"billigst"]