{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Cover","Abfrage","Ergebnis"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"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":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","Relationen"]
[null,null,"am Beispiel zwischen"]
[null,null,"Personalkosten und Maschinenkosten"]
[]
[]
[]
[]
[]
[null,"Autor","Harald Nahrstedt"]
[null,"Datum","2019-01-01"]
[null,"Version","1.0"]
[]
[]
[null,"Springer Verlag"]

{"sheet":"Abfrage","index":1,"n_rows":35,"n_cols":7,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
["Produkt","Bauteil","Anzahl","Std","Lohnkosten","Maschinenkosten","Gesamtkosten"]
["A",1,4,2.5,68.625,99.9,168.52499999999998]
["A",1,7,3.5,104.3,144.48000000000002,248.78]
["A",2,1,4.3,298.93599999999998,134.375,433.31099999999998]
["A",3,2,4.4000000000000004,335.76400000000001,234.96,570.72400000000005]
["A",4,0,6.9,393.92100000000005,212.38200000000001,606.30300000000011]
["A",5,17,9.5,815.8599999999999,292.41000000000003,1108.27]
["A",6,1,7.5,596.32500000000005,234.375,830.7]
["A",7,7,4.8,417.26400000000001,243.50399999999996,660.76799999999992]
["A",8,19,1.4,38.751999999999995,71.021999999999991,109.77399999999999]
["A",9,14,2.8,25.815999999999999,149.51999999999998,175.33599999999998]
["A",10,2,10.6,604.41200000000003,616.60199999999998,1221.0139999999999]
["A",11,3,5.9,582.27100000000007,184.375,766.64600000000007]
["A",12,17,18.7,696.57499999999993,633.36899999999991,1329.944]
["A",13,1,10.5,225.22499999999999,707.07,932.29500000000007]
["A",14,2,17.899999999999999,28.102999999999998,1114.991,1143.0939999999998]
["A",15,9,3.8,9.0820000000000007,151.84799999999998,160.93]
["B",1,17,2.4,230.44799999999998,139.608,370.05599999999998]
["B",2,19,6.7,345.72,288.70300000000003,634.423]
["B",3,0,10.6,215.922,437.56799999999998,653.49]
["B",4,8,4.8,140.54400000000001,219.696,360.23999999999995]
["B",5,14,2.2000000000000002,36.036000000000001,47.124000000000009,83.16]
["B",6,14,10.1,885.87099999999987,587.51700000000005,1473.3879999999999]
["B",7,15,1.4,108.696,75.263999999999996,183.96]
["C",1,2,2.2000000000000002,28.754000000000001,74.513999999999996,103.268]
["C",2,9,19.8,590.43600000000004,608.45400000000006,1198.8900000000001]
["C",3,14,7.8,372.29399999999998,544.98599999999999,917.28]
["C",4,8,14.7,205.06499999999997,790.27199999999993,995.33699999999988]
["C",5,7,6.9,551.79300000000001,275.72400000000005,827.51700000000005]
["C",6,18,6.7,184.45100000000002,357.78,542.23100000000011]
["C",7,0,11.3,798.91000000000008,789.53100000000006,1588.441]
["C",8,13,11.3,994.06100000000004,486.91700000000009,1480.9780000000001]
["C",9,8,4.7,136.15899999999999,292.76300000000003,428.92200000000003]
["C",10,4,11.9,697.45900000000006,639.74400000000003,1337.2030000000002]
["C",11,6,2.6,55.405999999999999,80.028000000000006,135.43400000000003]

{"sheet":"Ergebnis","index":2,"n_rows":42,"n_cols":6,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,null,"Kosten"]
["Produkt","Bauteil","Anzahl","Personal","Maschine","Gesamt"]
["A",1,4,68.625,99.9,168.52499999999998]
[null,null,7,104.3,144.48000000000002,248.78]
[null,2,1,298.93599999999998,134.375,433.31099999999998]
[null,3,2,335.76400000000001,234.96,570.72400000000005]
[null,4,0,393.92100000000005,212.38200000000001,606.30300000000011]
[null,5,17,815.8599999999999,292.41000000000003,1108.27]
[null,6,1,596.32500000000005,234.375,830.7]
[null,7,7,417.26400000000001,243.50399999999996,660.76799999999992]
[null,8,19,38.751999999999995,71.021999999999991,109.77399999999999]
[null,9,14,25.815999999999999,149.51999999999998,175.33599999999998]
[null,10,2,604.41200000000003,616.60199999999998,1221.0139999999999]
[null,11,3,582.27100000000007,184.375,766.64600000000007]
[null,12,17,696.57499999999993,633.36899999999991,1329.944]
[null,13,1,225.22499999999999,707.07,932.29500000000007]
[null,14,2,28.102999999999998,1114.991,1143.0939999999998]
[null,15,9,9.0820000000000007,151.84799999999998,160.93]
["A Ergebnis",null,null,5241.2309999999998,5225.1829999999991,10466.414000000001]
["B",1,17,230.44799999999998,139.608,370.05599999999998]
[null,2,19,345.72,288.70300000000003,634.423]
[null,3,0,215.922,437.56799999999998,653.49]
[null,4,8,140.54400000000001,219.696,360.23999999999995]
[null,5,14,36.036000000000001,47.124000000000009,83.16]
[null,6,14,885.87099999999987,587.51700000000005,1473.3879999999999]
[null,7,15,108.696,75.263999999999996,183.96]
["B Ergebnis",null,null,1963.2369999999999,1795.48,3758.7170000000001]
["C",1,2,28.754000000000001,74.513999999999996,103.268]
[null,2,9,590.43600000000004,608.45400000000006,1198.8900000000001]
[null,3,14,372.29399999999998,544.98599999999999,917.28]
[null,4,8,205.06499999999997,790.27199999999993,995.33699999999988]
[null,5,7,551.79300000000001,275.72400000000005,827.51700000000005]
[null,6,18,184.45100000000002,357.78,542.23100000000011]
[null,7,0,798.91000000000008,789.53100000000006,1588.441]
[null,8,13,994.06100000000004,486.91700000000009,1480.9780000000001]
[null,9,8,136.15899999999999,292.76300000000003,428.92200000000003]
[null,10,4,697.45900000000006,639.74400000000003,1337.2030000000002]
[null,11,6,55.405999999999999,80.028000000000006,135.43400000000003]
["C Ergebnis",null,null,4614.7880000000005,4940.7130000000006,9555.5009999999984]
["Gesamtergebnis",null,null,11819.255999999999,11961.376000000002,23780.631999999998]