{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Daten","Suche","HL Tab"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"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":"Daten","index":0,"n_rows":6,"n_cols":13,"rows_kept":6,"cut":false,"hidden":false,"merged":[[0,0,0,12]]}
["Meine Datenbank"]
[null,null,null,null,null,null,{"$f":"SUBTOTAL(9,DatenB[Aufwand in h])","v":17.5},null,null,null,null,{"$f":"SUBTOTAL(9,DatenB[Erlös])","v":-45}]
[null,"Nr.","Datum","Artikel","Beschreibung","Bearbeitet","Aufwand in h","Gekauft","EK-Preis","Einkauf Zus","VKP für","Erlös","Datum-VK"]
[null,{"$f":"ROW(A1)","v":1},"2025-08-03","Notebook","nicht neu","SSD Festplatte",5.5,"GDFE",0,45,0,{"$f":"IF(K4<=0,K4-(I4+J4),0)","v":-45},"."]
[null,{"$f":"ROW(A2)","v":2},"2025-08-04","Drucker","Canon",".",".",".",".",".",".",0,"."]
[null,{"$f":"ROW(A3)","v":3},"2025-08-05","Stuhl","Designerstück","Lack",12,".",".",".",".",{"$f":"IF(K6<=0,K6-(I6+J6),0)","v":0},"."]

{"sheet":"Suche","index":1,"n_rows":21,"n_cols":13,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,null,null,{"$f":"TRANSPOSE(DatenB[#Headers])","v":"Nr."}]
[null,null,null,null,"Datum"]
[null,null,null,null,"Artikel"]
[null,null,null,null,"Beschreibung"]
[null,null,null,null,"Bearbeitet"]
[null,null,null,null,"Aufwand in h"]
[null,null,null,null,"Gekauft"]
[null,null,null,null,"EK-Preis"]
[null,null,null,null,"Einkauf Zus"]
[null,null,null,null,"VKP für"]
[null,null,null,null,"Erlös"]
[null,null,null,null,"Datum-VK"]
[]
[]
[null,null,"Problemformel"]
[null,{"$f":"DatenB[#Headers]","v":"Nr."},"Datum","Artikel","Beschreibung","Bearbeitet","Aufwand in h","Gekauft","EK-Preis","Einkauf Zus","VKP für","Erlös","Datum-VK"]
[null,{"$f":"_xlfn._xlws.FILTER(DatenB[#Data],(F3=DatenB[Nr.])+(F4=DatenB[Datum])+(F5=DatenB[Artikel])+(F6=DatenB[Beschreibung])+(F7=DatenB[Bearbeitet])+(F8=DatenB[Aufwand in h])+(F9=DatenB[Gekauft])+(F10=DatenB[EK-Preis])+(F11=DatenB[Einkauf Zus])+(F12=DatenB[VKP für])+(F13=DatenB[Erlös])+(F14=DatenB[Datum-VK]),\"\")","v":1},"2025-08-03","Notebook","nicht neu","SSD Festplatte",5.5,"GDFE",0,45,0,-45,"."]
[null,2,"2025-08-04","Drucker","Canon",".",".",".",".",".",".",0,"."]
[null,3,"2025-08-05","Stuhl","Designerstück","Lack",12,".",".",".",".",0,"."]

{"sheet":"HL Tab","index":2,"n_rows":6,"n_cols":13,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,{"$f":"DatenB[#Headers]","v":"Nr."},"Datum","Artikel","Beschreibung","Bearbeitet","Aufwand in h","Gekauft","EK-Preis","Einkauf Zus","VKP für","Erlös","Datum-VK"]
[null,{"$f":"_xlfn._xlws.SORT(_xlfn.UNIQUE(DatenB[Nr.]))","v":1},{"$f":"_xlfn._xlws.SORT(_xlfn.UNIQUE(DatenB[Datum]))","v":"2025-08-03"},{"$f":"_xlfn._xlws.SORT(_xlfn.UNIQUE(DatenB[Artikel]))","v":"Drucker"},{"$f":"_xlfn._xlws.SORT(_xlfn.UNIQUE(DatenB[Beschreibung]))","v":"Canon"},{"$f":"_xlfn._xlws.SORT(_xlfn.UNIQUE(DatenB[Bearbeitet]))","v":"."},{"$f":"_xlfn._xlws.SORT(_xlfn.UNIQUE(DatenB[Aufwand in h]))","v":5.5},{"$f":"_xlfn._xlws.SORT(_xlfn.UNIQUE(DatenB[Gekauft]))","v":"."},{"$f":"_xlfn._xlws.SORT(_xlfn.UNIQUE(DatenB[EK-Preis]))","v":0},{"$f":"_xlfn._xlws.SORT(_xlfn.UNIQUE(DatenB[Einkauf Zus]))","v":45},{"$f":"_xlfn._xlws.SORT(_xlfn.UNIQUE(DatenB[VKP für]))","v":0},{"$f":"_xlfn._xlws.SORT(_xlfn.UNIQUE(DatenB[Erlös]))","v":-45},{"$f":"_xlfn._xlws.SORT(_xlfn.UNIQUE(DatenB[Datum-VK]))","v":"."}]
[null,2,"2025-08-04","Notebook","Designerstück","Lack",12,"GDFE",".",".",".",0]
[null,3,"2025-08-05","Stuhl","nicht neu","SSD Festplatte","."]