{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Cover","Auftragsliste"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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,"für Controller"]
[]
[]
[null,"Kapitel",4]
[null,"Thema","Methoden der Datenaufbereitung"]
[]
[null,"Inhalt","Variable Spalten in SVERWEIS und INDEX"]
[null,null,"Beispiel Auftragsliste"]
[]
[]
[]
[]
[]
[]
[null,"Autor","Harald Nahrstedt"]
[null,"Datum","2019-01-01"]
[null,"Version","1.0"]
[]
[]
[null,"Springer Verlag"]

{"sheet":"Auftragsliste","index":1,"n_rows":24,"n_cols":8,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["Kunde","Verkäufer","Auftragswert","Auftragseingang","AuftragsNr",null,"AuftragNr:","A2010021"]
["Hobel GmbH","Sandmann",7921,"2010-01-08","A2010002",null,"Auftragswert:",{"$f":"VLOOKUP(AuftragNr,CHOOSE({2,1},Auftragswert,AuftragsNr),2,0)","v":4433.58}]
["Fischer GmbH","Sandmann",8757.64,"2010-07-16","A2010003",null,"Auftragswert:",{"$f":"INDEX(Auftragswert,MATCH(AuftragNr,AuftragsNr,0))","v":4433.58}]
["Rottmann GmbH","Hauer",6469.14,"2010-04-20","A2010004"]
["Neibel GmbH & Co.","Sandmann",3051.55,"2010-08-28","A2010005"]
["Bartmann KG","Hauer",685.68,"2010-05-02","A2010006"]
["Friedrichs GmbH","Holzer",5910.87,"2010-03-16","A2010007"]
["Enkel & Nachfolger","Holzer",9529.23,"2010-01-10","A2010008"]
["Lange & Partner","Holzer",3637.8,"2010-09-09","A2010009"]
["Asshoff KG","Holzmann",3273.32,"2010-06-07","A2010012"]
["Ross oHG","Altmann",1928.51,"2010-05-18","A2010013"]
["Dunkel KG","Sandmann",396.16,"2010-07-26","A2010014"]
["Uhlmann GmbH","Hauer",6825.74,"2010-07-04","A2010015"]
["Fischer GmbH","Brenner",4853.8599999999997,"2010-06-30","A2010016"]
["Neibel GmbH & Co.","Bauer",2844.86,"2010-02-03","A2010017"]
["Uhlmann GmbH","Renner",637.5,"2010-08-21","A2010018"]
["Pieper & Co.","Filzer",6542.32,"2010-02-13","A2010019"]
["Pollen GmbH","Weber",7891.77,"2010-01-21","A2010020"]
["Tamm KG","Sandmann",4433.58,"2010-08-07","A2010021"]
["Anderer & Sohn","Holzer",4031.58,"2010-11-25","A2010022"]
["Neibel GmbH & Co.","Gärtner",5410.36,"2010-04-25","A2010023"]
["Rühring GmbH","Altmann",8408.8700000000008,"2010-09-05","A2010024"]
["Lange & Partner","Lehmann",5890.83,"2010-10-06","A2010025"]
["Münch GmbH","Amtmann",6005.31,"2010-03-13","A2010026"]