{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Cover","ANZAHL","KGRÖSSTE","KKLEINSTE","MAX","MIN","ZÄHLENWENN","ZÄHLENWENNS"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":36,"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":"Cover","index":0,"n_rows":23,"n_cols":3,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Excel + VBA "]
[null,"Stochastik"]
[]
[]
[null,"Kapitel",3]
[null,"Thema","Grundlagen"]
[]
[null,"Inhalt","Grundfunktionen"]
[null,null,"zur Stochastik"]
[null,null," "]
[]
[]
[]
[]
[]
[null,"Version","2.0"]
[null,"Autor","Harald Nahrstedt"]
[null,"Letzte Bearbeitung","2023-03-04"]
[]
[]
[null,"Springer Vieweg Verlag"]

{"sheet":"ANZAHL","index":1,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Datum","Umsatz","Produkt"]
["17.02.2021",21300,"P2"]
["18.03.2021",35600,"P1"]
["19.04.2021",22700,"P3"]
["29.04.2021","storniert","P2"]
["13.05.2021",27800,"P1"]
["15.06.2021",31200,"P2"]
["02.07.2021",28500,"P3"]
[]
["Zählhilfe"]
["Anzahl Werte",{"$f":"COUNT(Umsatz)","v":6}]
["Anzahl Umsätze",{"$f":"COUNTA(Umsatz)","v":7}]
["Anzahl Produkte",{"$f":"COUNTA(Produkt)","v":7}]

{"sheet":"KGRÖSSTE","index":2,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Warengruppe","Januar","Februar","März"]
["A",13450,14560,16340]
["B",18230,17450,15980]
["C",15440,16210,15390]
["D",9870,8730,8920]
["E",12600,10300,11600]
["F",16700,12500,13300]
["Gesamtumsatz",{"$f":"SUM(Januar)","v":86290},{"$f":"SUM(Februar)","v":79750},{"$f":"SUM(März)","v":81530}]
[]
["Umsatzanalyse"]
["größter Umsatz",{"$f":"LARGE(Matrix,1)","v":18230}]
["zweitgrößter Umsatz",{"$f":"LARGE(Matrix,2)","v":17450}]
["drittgrößter Umsatz",{"$f":"LARGE(Matrix,3)","v":16700}]
["Top 3",{"$f":"SUM(Top_3)","v":52380}]

{"sheet":"KKLEINSTE","index":3,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Warengruppe","Januar","Februar","März"]
["A",13450,14560,16340]
["B",18230,17450,15980]
["C",15440,16210,15390]
["D",9870,8730,8920]
["E",12600,10300,11600]
["F",16700,12500,13300]
["Gesamtumsatz",{"$f":"SUM(Januar)","v":86290},{"$f":"SUM(Februar)","v":79750},{"$f":"SUM(März)","v":81530}]
[]
["Umsatzanalyse"]
["kleinster Umsatz",{"$f":"SMALL(Matrix,1)","v":8730}]
["zweitkleinster Umsatz",{"$f":"SMALL(Matrix,2)","v":8920}]
["drittkleinster Umsatz",{"$f":"SMALL(Matrix,3)","v":9870}]
["Down 3",{"$f":"SUM(Down_3)","v":27520}]

{"sheet":"MAX","index":4,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Monat","Produkt1","Produkt2","Produkt3"]
["Jan",432,1120,1436]
["Feb",382,89,234]
["Nrz",622,105,656]
["Apr",160,213,98]
["Mai",988,899,256]
["Jun",743,654,347]
[]
["Stückanalyse"]
["größter Wert",{"$f":"MAX(Mengen)","v":1436}]
["größter Wert von P1 u. P3",{"$f":"MAX(Produkt_1,Produkt_2)","v":1120}]
["größter Wert < 300",{"$f":"MAX(IF(Mengen<300,Mengen))","v":256}]
["größter Wert aus [650, 830]",{"$f":"MAX(IF(Mengen>=650,IF(Mengen<=830,Mengen),))","v":743}]

{"sheet":"MIN","index":5,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Monat","Produkt1","Produkt2","Produkt3"]
["Jan",432,1120,1436]
["Feb",382,89,234]
["Mrz",622,105,656]
["Apr",160,213,98]
["Mai",988,899,256]
["Jun",743,654,347]
[]
["Stückanalyse"]
["kleinster Wert",{"$f":"MIN(Mengen)","v":89}]
["kleinster Wert von P1 u. P3",{"$f":"MIN(Produkt_1,Produkt_3)","v":98}]
["kleinster Wert > 300",{"$f":"MIN(IF(Mengen>300,Mengen))","v":347}]

{"sheet":"ZÄHLENWENN","index":6,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Datum","Umsatz","Produkt"]
["17.02.2021",21300,"P2"]
["18.03.2021",35600,"P1"]
["19.04.2021",22700,"P3"]
["29.04.2021","storniert","P2"]
["13.05.2021",27800,"P1"]
["15.06.2021",31200,"P2"]
["02.07.2021",28500,"P3"]
[]
["Zählhilfe"]
["Anzahl P2",{"$f":"COUNTIF(Produkt,\"P2\")","v":3}]
["Anzahl Umsatz > 25.000",{"$f":"COUNTIF(Umsatz,\">25000\")","v":4}]

{"sheet":"ZÄHLENWENNS","index":7,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Warengruppe","Januar","Februar","März"]
["A",13450,14560,16340]
["B",18230,17450,15980]
["C",15440,16210,15390]
["D",9870,8730,8920]
["E",12600,10300,11600]
["F",16700,12500,13300]
["Gesamtumsatz",{"$f":"SUM(Januar)","v":86290},{"$f":"SUM(Februar)","v":79750},{"$f":"SUM(März)","v":81530}]
[]
["Anzahl Umsätze"]
["Jan >= 15.000 €; Feb <= 15.000 €",{"$f":"COUNTIFS(Januar,\">=15000\",Februar,\"<=15000\")","v":1}]
["Jan >= 15.000 €; Mrz >= 12000 € ",{"$f":"COUNTIFS(Januar,\">=15000\",März,\">=12000\")","v":3}]