{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Cover","Dialog","Merkmale","Objekte","Startliste"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":22,"n_cols":3,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Algorithmen"]
[null,"für Ingenieure"]
[]
[]
[null,"Kapitel",13]
[null,"Thema","Data Science"]
[]
[null,"Inhalt","Einfacher Lernalgorithmus mit einer Hashfunktion"]
[]
[]
[]
[]
[]
[]
[null,"Version","1.0"]
[null,"Autor","Harald Nahrstedt"]
[null,"Datum","2025-06-16"]
[]
[]
[null,"Springer Vieweg Verlag"]

{"sheet":"Dialog","index":1,"n_rows":7,"n_cols":6,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Key","Objekt","Key","Merkmal","Text"]
[956,"Worksheet",51,"SummeWenns","Application.WorksheetFunction.SumIfs (Summe_Bereichj, Kriterien_Bereich; Kriterien[, Kriterien_Bereich_2, Kriterien2, …]"," "]
[null,null,82,"Mittelwert","Application.Worksheetfunction.Average (Wert1,[Wert2, …])"]
[null,null,124,"IstUngerade","Application.WorksheetFunction.IsOdd(Wert)"]
[null,null,158,"ZählenWenn","Application.WorksheetFunction.CountIf (Bereich,Suchkriterium)"]
[null,null,185,"Pi","Application.WorksheetFunction.Pi()"]
[null,null,186,"Ln","Application.WorksheetFunction.Ln(Wert)"]

{"sheet":"Merkmale","index":2,"n_rows":1074,"n_cols":67,"rows_kept":1074,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["SummeWenns","Application.WorksheetFunction.SumIfs (Summe_Bereichj, Kriterien_Bereich; Kriterien[, Kriterien_Bereich_2, Kriterien2, …]"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Autofilter","Autofilter([Field][,Criteria1],\nOperator As XlAutoFilterOperator = \nxlAnd][,Criteria2][VisibleDropDown])"]
[]
[]
["Auszahlung"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Mittelwert","Application.Worksheetfunction.Average (Wert1,[Wert2, …])"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["IstUngerade","Application.WorksheetFunction.IsOdd(Wert)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["ZählenWenn","Application.WorksheetFunction.CountIf (Bereich,Suchkriterium)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Pi","Application.WorksheetFunction.Pi()"]
["Ln","Application.WorksheetFunction.Ln(Wert)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["BeforeDelete","Event BeforeDelete()"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Teilergebnis","Application.WorksheetFunction.SubTotal\n(Funktion,Bezug1[,Bezug2,…])\n1 = Mittelwert / 2 = Anzahl / 3 = Anzahl2 /\n4 = Max / 5 = Min / 6 = Produkt / 7 = Stabw.S /\n8 = Stabw.N / 9 = Summe / 10 = Var.S / 11 = Var.P /\n101 = Mittelwert "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["ZählenWenns"]
[]
[]
[]
[]
[]
["Asc"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Log"]
[]
["Min"]
[]
["Max"]
["Und"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["KalenderWoche"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["SummenProdukt"]
[]
[]
[]
["Log10"]
[]
[]
[]
[]
["Rang"]
[]
["Oder"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Takt"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Text"]
[]
[]
[]
[]
["DBMin"]
[]
["DBMax"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["IstNV"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Cells"]
[]
[]
[]
[]
["Index"]
[]
[]
[]
[]
["Trend"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Summe"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["ArcCos"]
[]
[]
[]
[]
["ArcSin"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["IstLog"]
[]
["TanHyp"]
[]
["CosHyp"]
[]
[]
[]
[]
["SinHyp"]
[]
[]
["Anzahl"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["ArcTan2"]
["Runden"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Potenz"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["DBSumme"]
[]
[]
["Anzahl2"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["IstZahl"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["IstText"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["DBAnzahl"]
["Verweis"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["BinInDez"]
[]
["BinInHex"]
[]
[]
[]
[]
[]
[]
[]
[]
["BinInOkt"]
["DezInHex"]
[]
[]
[]
[]
[]
["DBAuszug"]
[]
[]
["DezInOkt"]
[]
["HexInOkt"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["DBAnzahl2"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["IstKText"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Abrunden"]
[]
["Activate","Event Activate() / Sub Activate()"]
[]
[]
[]
[]
[]
[]
["SVerweis"]
[]
[]
[]
["WVerweis"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Ersetzen"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["ArcTanHyp"]
[]
["AcrCosHyp"]
[]
[]
["DBProdukt"]
[]
["ArcSinHyp"]
[]
[]
[]
[]
[]
[]
["IstGerade"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["IstFehler"]
[]
[]
[]
["KKleinste"]
[]
[]
[]
["Calculate","Sub Calculate()"]
[]
[]
[]
[]
[]
[]
[]
[]
["DBMITTELWERT"]
[]
[]
[]
[]
[]
[]
[]
["Bogenmass"]
["Wochentag"]
[]
[]
[]
[]
[]
[]
[]
["Aufrunden"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Worksheet",51,67,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,928,936]
[]
[]
["Fakultät"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Kgrösste"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["DezInBin"]
["HexInBin"]
["HexInDez"]
["OktInBin"]
["OktInDez"]
["OktInHex"]
["SummeWenn"]
["Abrunden"]
["AcrCosHyp"]
["Anzahl"]
["Anzahl2"]
["ArcCos"]
["ArcSin"]
["ArcSinHyp"]
["ArcTan2"]
["ArcTanHyp"]
["Asc"]
["Aufrunden"]
["BinInDez"]
["BinInHex"]
["BinInOkt"]
["Bogenmass"]
["CosHyp"]
["DBAnzahl"]
["DBAnzahl2"]
["DBAuszug"]
["DBMax"]
["DBMin"]
["DBMITTELWERT"]
["DBProdukt"]
["DBSumme"]
["DezInHex"]
["DezInOkt"]
["Ersetzen"]
["Fakultät"]
["HexInOkt"]
["Index"]
["IstFehler"]
["IstGerade"]
["IstKText"]
["IstLog"]
["IstNV"]
["IstText"]
["IstUngerade"]
["IstZahl"]
["KalenderWoche"]
["Kgrösste"]
["KKleinste"]
["Ln"]
["Log"]
["Log10"]
["Max"]
["Min"]
["Mittelwert"]
["Oder"]
["Pi"]
["Potenz"]
["Rang"]
["Runden"]
["SinHyp"]
["Summe"]
["SummenProdukt"]
["SummeWenns"]
["SVerweis"]
["TanHyp"]
["Teilergebnis"]
["Text"]
["Trend"]
["Und"]
["Verweis"]
["Wochentag"]
["WVerweis"]
["ZählenWenn"]
["ZählenWenns"]
["Auszahlung"]

{"sheet":"Objekte","index":3,"n_rows":956,"n_cols":74,"rows_kept":956,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Cells",817,64,199,910]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Worksheet",51,82,124,158,185,186,254,273,279,290,292,294,295,317,383,387,392,394,421,426,428,468,504,509,519,571,576,594,596,598,603,606,619,620,640,653,656,703,725,740,741,755,757,766,767,773,776,778,790,800,815,824,828,848,874,876,879,881,888,902,906,919,927,928,936,1000,1001,1002,1003,1004,1005,1006,404]

{"sheet":"Startliste","index":4,"n_rows":75,"n_cols":7,"rows_kept":75,"cut":false,"hidden":false,"merged":[]}
[815,"Abrunden",1,null,{"$f":"MAX(A:A)","v":985},{"$f":"COUNTIF(C:C,\">1\")","v":14},{"$f":"COUNTIF(C:C,\">2\")","v":0}]
[876,"AcrCosHyp",1]
[606,"Anzahl",1]
[656,"Anzahl2",1]
[571,"ArcCos",1]
[576,"ArcSin",1]
[881,"ArcSinHyp",1]
[619,"ArcTan2",1]
[874,"ArcTanHyp",1]
[279,"Asc",1]
[936,"Aufrunden",1]
[67,"Auszahlung",1]
[755,"BinInDez",2]
[757,"BinInHex",2]
[766,"BinInOkt",2]
[927,"Bogenmass",2]
[598,"CosHyp",1]
[740,"DBAnzahl",1]
[790,"DBAnzahl2",1]
[773,"DBAuszug",1]
[428,"DBMax",1]
[426,"DBMin",1]
[919,"DBMITTELWERT",1]
[879,"DBProdukt",1]
[653,"DBSumme",1]
[755,"DezInBin",2]
[767,"DezInHex",2]
[776,"DezInOkt",2]
[848,"Ersetzen",1]
[959,"Fakultät",1]
[757,"HexInBin",2]
[767,"HexInDez",2]
[778,"HexInOkt",2]
[504,"Index",1]
[902,"IstFehler",1]
[888,"IstGerade",1]
[800,"IstKText",1]
[594,"IstLog",1]
[468,"IstNV",1]
[725,"IstText",1]
[124,"IstUngerade",1]
[703,"IstZahl",1]
[317,"KalenderWoche",1]
[985,"Kgrösste",1]
[906,"KKleinste",1]
[186,"Ln",1]
[290,"Log",1]
[387,"Log10",1]
[294,"Max",1]
[292,"Min",1]
[82,"Mittelwert",1]
[394,"Oder",1]
[766,"OktInBin",2]
[776,"OktInDez",2]
[778,"OktInHex",2]
[185,"Pi",1]
[640,"Potenz",1]
[392,"Rang",1]
[620,"Runden",1]
[603,"SinHyp",1]
[519,"Summe",1]
[383,"SummenProdukt",1]
[927,"SummeWenn",2]
[51,"SummeWenns",1]
[824,"SVerweis",1]
[596,"TanHyp",1]
[254,"Teilergebnis",1]
[421,"Text",1]
[509,"Trend",1]
[295,"Und",1]
[741,"Verweis",1]
[928,"Wochentag",1]
[828,"WVerweis",1]
[158,"ZählenWenn",1]
[273,"ZählenWenns",1]