{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Cover","Tabelle2","Tabelle3","Tabelle1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":4,"comments":0,"pivot_tables":1},"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":20,"n_cols":3,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Excel + VBA"]
[null,"für Controller"]
[]
[]
[null,"Kapitel",5]
[null,"Thema","Datenmodelle"]
[]
[null,"Inhalt","m:n Beziehung"]
[]
[]
[]
[]
[null,"Version","1.0"]
[null,"Autor","Harald Nahrstedt"]
[null,"Letzte Bearbeitung","2025-04-25"]
[]
[]
[null,"Springer Vieweg Verlag"]

{"sheet":"Tabelle2","index":1,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Summe von Std"]
[null,"Bezeichnung","Nachname","Ergebnis"]
[null,"Architektur","Bauer",96]
[null,null,"Schmid",132]
[null,"Design","Kramer",114]
[null,"Entwicklung","Müller",136]
[null,"Netzwerk","Becker",200]
[null,"(Leer)","Lehrer",116]
[null,"Gesamtergebnis",null,794]

{"sheet":"Tabelle3","index":2,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[{"$f":"CUBESET(\"ThisWorkbookDataModel\",\"[Tabelle1].[Produktkategorie].[All].Children\",\"Produkte\")","v":{"$error":"#N/A"}}]
[{"$f":"CUBESETCOUNT(A1)","v":{"$error":"#N/A"}}]

{"sheet":"Tabelle1","index":3,"n_rows":13,"n_cols":15,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["AbtNr","Bezeichnung",null,"PerNr","Nachname","Vorname","AbtNr",null,"ProNr","Bezeichnung",null,"ID","PerNr","ProNr","Std"]
[1,"Entwicklung ",null,1,"Müller","Hans",1,null,1,"Planung",null,1,1,2,136]
[2,"Architektur",null,2,"Schmid","Anna",2,null,2,"Marketing",null,2,2,1,87]
[3,"Netzwerk",null,3,"Bauer","Doris",2,null,3,"Umsatz",null,3,2,2,45]
[4,"Design",null,4,"Becker","Bernd",3,null,4,"Qualität",null,4,4,3,67]
[null,null,null,5,"Lehrer","Eva",5,null,5,"Kosten",null,5,4,1,32]
[null,null,null,6,"Kramer","Suse",4,null,null,null,null,6,4,5,101]
[null,null,null,null,null,null,null,null,null,null,null,7,5,4,73]
[null,null,null,null,null,null,null,null,null,null,null,8,6,4,22]
[null,null,null,null,null,null,null,null,null,null,null,9,6,5,92]
[null,null,null,null,null,null,null,null,null,null,null,10,5,5,43]
[null,null,null,null,null,null,null,null,null,null,null,11,3,2,65]
[null,null,null,null,null,null,null,null,null,null,null,12,3,3,31]