{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Cover","Tabelle1","Kunden"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":6,"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":23,"n_cols":3,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Excel + VBA "]
[null,"für Controller"]
[]
[]
[null,"Kapitel",5]
[null,"Thema","Datenmodelle"]
[]
[null,"Inhalt","Lagerverwaltung"]
[null,null,"Erstellung eines Datenmodells"]
[]
[]
[]
[]
[]
[]
[null,"Version","1.0"]
[null,"Autor","Harald Nahrstedt"]
[null,"Datum","2025-04-25"]
[]
[]
[null,"Springer Verlag"]

{"sheet":"Tabelle1","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Kunden","index":2,"n_rows":18,"n_cols":8,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["Menge",null,"Region"]
["Produkt","Preis","Nord","Ost","Süd","West","Summen","Umsatz"]
["Dichtung",10.73,472,166,237,495,1370,{"$f":"Preis*Summen","v":14700.1}]
["Druckfeder",12.03,772,null,404,791,1967,23663.01]
["Gelenkbolzen",7.36,443,135,728,816,2122,15617.92]
["Gleitlager",5.18,180,246,250,665,1341,6946.3799999999992]
["Kegelrad",10.039999999999999,null,288,974,208,1470,14758.8]
["Kettenglied",2.99,170,287,189,152,798,2386.02]
["Kupplung",11.51,853,812,1557,323,3545,40802.949999999997]
["Metallschraube",5.58,414,null,159,1031,1604,8950.32]
["Niete",1.53,null,199,423,162,784,1199.52]
["Stirnrad",10.39,1486,440,null,980,2906,30193.34]
["Tellerfeder",4.22,335,null,813,309,1457,6148.54]
["Vierkant",0.54,null,null,236,343,579,312.66000000000003]
["Wälzlager",7.33,917,661,null,584,2162,15847.460000000001]
["Zahnrad",1.0900000000000001,541,null,592,835,1968,2145.1200000000003]
["Zugfeder",3.25,1141,604,954,300,2999,9746.75]
["Summen",null,7724,3838,7516,7994,27072,{"$f":"SUM(_xlfn.ANCHORARRAY(H3))","v":193418.89}]