{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Schichtbuch","Ölverbrauch","Sammeln"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":2,"defined_names":13,"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":"Schichtbuch","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Ölverbrauch","index":1,"n_rows":36,"n_cols":14,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[null,"Ölverbrauch Bsp.xlsx",null,null,null,null,null,null,null,"C:\\Users\\niemand\\Downloads"]
[]
[null,"DGM 3",null,null,"Presse 3",null,null,null,null,null,null,null,"DGM 3","Presse 3"]
["Datum","Früh Angabe in L","Spät  Angabe in L","Nacht Angabe in L","Früh Angabe in L","Spät  Angabe in L","Nacht Angabe in L",null,null,null,null,"Summe:",{"$f":"SUM(M5:M200)","v":2150},{"$f":"SUM(N5:N200)","v":650}]
["2024-01-01",{"$f":"[2]Ölverbrauch!B5","v":500},{"$f":"[2]Ölverbrauch!C5","v":0},{"$f":"[2]Ölverbrauch!D5","v":0},{"$f":"[2]Ölverbrauch!E5","v":0},{"$f":"[2]Ölverbrauch!F5","v":0},{"$f":"[2]Ölverbrauch!G5","v":200},null,1,"Ölverbrauch Bsp.xlsx",14410,"2025-01-17T17:43:01",2150,650]
["2024-01-02",{"$f":"[2]Ölverbrauch!B6","v":1200},{"$f":"[2]Ölverbrauch!C6","v":0},{"$f":"[2]Ölverbrauch!D6","v":0},{"$f":"[2]Ölverbrauch!E6","v":0},{"$f":"[2]Ölverbrauch!F6","v":200},{"$f":"[2]Ölverbrauch!G6","v":100}]
["2024-01-03",{"$f":"[2]Ölverbrauch!B7","v":0},{"$f":"[2]Ölverbrauch!C7","v":0},{"$f":"[2]Ölverbrauch!D7","v":0},{"$f":"[2]Ölverbrauch!E7","v":0},{"$f":"[2]Ölverbrauch!F7","v":0},{"$f":"[2]Ölverbrauch!G7","v":0}]
["2024-01-04",{"$f":"[2]Ölverbrauch!B8","v":0},{"$f":"[2]Ölverbrauch!C8","v":0},{"$f":"[2]Ölverbrauch!D8","v":0},{"$f":"[2]Ölverbrauch!E8","v":0},{"$f":"[2]Ölverbrauch!F8","v":0},{"$f":"[2]Ölverbrauch!G8","v":0}]
["2024-01-05",{"$f":"[2]Ölverbrauch!B9","v":0},{"$f":"[2]Ölverbrauch!C9","v":0},{"$f":"[2]Ölverbrauch!D9","v":0},{"$f":"[2]Ölverbrauch!E9","v":0},{"$f":"[2]Ölverbrauch!F9","v":0},{"$f":"[2]Ölverbrauch!G9","v":0}]
["2024-01-06",{"$f":"[2]Ölverbrauch!B10","v":0},{"$f":"[2]Ölverbrauch!C10","v":0},{"$f":"[2]Ölverbrauch!D10","v":0},{"$f":"[2]Ölverbrauch!E10","v":0},{"$f":"[2]Ölverbrauch!F10","v":0},{"$f":"[2]Ölverbrauch!G10","v":0}]
["2024-01-07",{"$f":"[2]Ölverbrauch!B11","v":0},{"$f":"[2]Ölverbrauch!C11","v":0},{"$f":"[2]Ölverbrauch!D11","v":0},{"$f":"[2]Ölverbrauch!E11","v":0},{"$f":"[2]Ölverbrauch!F11","v":0},{"$f":"[2]Ölverbrauch!G11","v":0}]
["2024-01-08",{"$f":"[2]Ölverbrauch!B12","v":0},{"$f":"[2]Ölverbrauch!C12","v":0},{"$f":"[2]Ölverbrauch!D12","v":0},{"$f":"[2]Ölverbrauch!E12","v":0},{"$f":"[2]Ölverbrauch!F12","v":0},{"$f":"[2]Ölverbrauch!G12","v":0}]
["2024-01-09",{"$f":"[2]Ölverbrauch!B13","v":0},{"$f":"[2]Ölverbrauch!C13","v":0},{"$f":"[2]Ölverbrauch!D13","v":0},{"$f":"[2]Ölverbrauch!E13","v":0},{"$f":"[2]Ölverbrauch!F13","v":0},{"$f":"[2]Ölverbrauch!G13","v":0}]
["2024-01-10",{"$f":"[2]Ölverbrauch!B14","v":0},{"$f":"[2]Ölverbrauch!C14","v":0},{"$f":"[2]Ölverbrauch!D14","v":0},{"$f":"[2]Ölverbrauch!E14","v":0},{"$f":"[2]Ölverbrauch!F14","v":0},{"$f":"[2]Ölverbrauch!G14","v":0}]
["2024-01-11",{"$f":"[2]Ölverbrauch!B15","v":0},{"$f":"[2]Ölverbrauch!C15","v":0},{"$f":"[2]Ölverbrauch!D15","v":0},{"$f":"[2]Ölverbrauch!E15","v":0},{"$f":"[2]Ölverbrauch!F15","v":0},{"$f":"[2]Ölverbrauch!G15","v":0}]
["2024-01-12",{"$f":"[2]Ölverbrauch!B16","v":0},{"$f":"[2]Ölverbrauch!C16","v":450},{"$f":"[2]Ölverbrauch!D16","v":0},{"$f":"[2]Ölverbrauch!E16","v":150},{"$f":"[2]Ölverbrauch!F16","v":0},{"$f":"[2]Ölverbrauch!G16","v":0}]
["2024-01-13",{"$f":"[2]Ölverbrauch!B17","v":0},{"$f":"[2]Ölverbrauch!C17","v":0},{"$f":"[2]Ölverbrauch!D17","v":0},{"$f":"[2]Ölverbrauch!E17","v":0},{"$f":"[2]Ölverbrauch!F17","v":0},{"$f":"[2]Ölverbrauch!G17","v":0}]
["2024-01-14",{"$f":"[2]Ölverbrauch!B18","v":0},{"$f":"[2]Ölverbrauch!C18","v":0},{"$f":"[2]Ölverbrauch!D18","v":0},{"$f":"[2]Ölverbrauch!E18","v":0},{"$f":"[2]Ölverbrauch!F18","v":0},{"$f":"[2]Ölverbrauch!G18","v":0}]
["2024-01-15",{"$f":"[2]Ölverbrauch!B19","v":0},{"$f":"[2]Ölverbrauch!C19","v":0},{"$f":"[2]Ölverbrauch!D19","v":0},{"$f":"[2]Ölverbrauch!E19","v":0},{"$f":"[2]Ölverbrauch!F19","v":0},{"$f":"[2]Ölverbrauch!G19","v":0}]
["2024-01-16",{"$f":"[2]Ölverbrauch!B20","v":0},{"$f":"[2]Ölverbrauch!C20","v":0},{"$f":"[2]Ölverbrauch!D20","v":0},{"$f":"[2]Ölverbrauch!E20","v":0},{"$f":"[2]Ölverbrauch!F20","v":0},{"$f":"[2]Ölverbrauch!G20","v":0}]
["2024-01-17",{"$f":"[2]Ölverbrauch!B21","v":0},{"$f":"[2]Ölverbrauch!C21","v":0},{"$f":"[2]Ölverbrauch!D21","v":0},{"$f":"[2]Ölverbrauch!E21","v":0},{"$f":"[2]Ölverbrauch!F21","v":0},{"$f":"[2]Ölverbrauch!G21","v":0}]
["2024-01-18",{"$f":"[2]Ölverbrauch!B22","v":0},{"$f":"[2]Ölverbrauch!C22","v":0},{"$f":"[2]Ölverbrauch!D22","v":0},{"$f":"[2]Ölverbrauch!E22","v":0},{"$f":"[2]Ölverbrauch!F22","v":0},{"$f":"[2]Ölverbrauch!G22","v":0}]
["2024-01-19",{"$f":"[2]Ölverbrauch!B23","v":0},{"$f":"[2]Ölverbrauch!C23","v":0},{"$f":"[2]Ölverbrauch!D23","v":0},{"$f":"[2]Ölverbrauch!E23","v":0},{"$f":"[2]Ölverbrauch!F23","v":0},{"$f":"[2]Ölverbrauch!G23","v":0}]
["2024-01-20",{"$f":"[2]Ölverbrauch!B24","v":0},{"$f":"[2]Ölverbrauch!C24","v":0},{"$f":"[2]Ölverbrauch!D24","v":0},{"$f":"[2]Ölverbrauch!E24","v":0},{"$f":"[2]Ölverbrauch!F24","v":0},{"$f":"[2]Ölverbrauch!G24","v":0}]
["2024-01-21",{"$f":"[2]Ölverbrauch!B25","v":0},{"$f":"[2]Ölverbrauch!C25","v":0},{"$f":"[2]Ölverbrauch!D25","v":0},{"$f":"[2]Ölverbrauch!E25","v":0},{"$f":"[2]Ölverbrauch!F25","v":0},{"$f":"[2]Ölverbrauch!G25","v":0}]
["2024-01-22",{"$f":"[2]Ölverbrauch!B26","v":0},{"$f":"[2]Ölverbrauch!C26","v":0},{"$f":"[2]Ölverbrauch!D26","v":0},{"$f":"[2]Ölverbrauch!E26","v":0},{"$f":"[2]Ölverbrauch!F26","v":0},{"$f":"[2]Ölverbrauch!G26","v":0}]
["2024-01-23",{"$f":"[2]Ölverbrauch!B27","v":0},{"$f":"[2]Ölverbrauch!C27","v":0},{"$f":"[2]Ölverbrauch!D27","v":0},{"$f":"[2]Ölverbrauch!E27","v":0},{"$f":"[2]Ölverbrauch!F27","v":0},{"$f":"[2]Ölverbrauch!G27","v":0}]
["2024-01-24",{"$f":"[2]Ölverbrauch!B28","v":0},{"$f":"[2]Ölverbrauch!C28","v":0},{"$f":"[2]Ölverbrauch!D28","v":0},{"$f":"[2]Ölverbrauch!E28","v":0},{"$f":"[2]Ölverbrauch!F28","v":0},{"$f":"[2]Ölverbrauch!G28","v":0}]
["2024-01-25",{"$f":"[2]Ölverbrauch!B29","v":0},{"$f":"[2]Ölverbrauch!C29","v":0},{"$f":"[2]Ölverbrauch!D29","v":0},{"$f":"[2]Ölverbrauch!E29","v":0},{"$f":"[2]Ölverbrauch!F29","v":0},{"$f":"[2]Ölverbrauch!G29","v":0}]
["2024-01-26",{"$f":"[2]Ölverbrauch!B30","v":0},{"$f":"[2]Ölverbrauch!C30","v":0},{"$f":"[2]Ölverbrauch!D30","v":0},{"$f":"[2]Ölverbrauch!E30","v":0},{"$f":"[2]Ölverbrauch!F30","v":0},{"$f":"[2]Ölverbrauch!G30","v":0}]
["2024-01-27",{"$f":"[2]Ölverbrauch!B31","v":0},{"$f":"[2]Ölverbrauch!C31","v":0},{"$f":"[2]Ölverbrauch!D31","v":0},{"$f":"[2]Ölverbrauch!E31","v":0},{"$f":"[2]Ölverbrauch!F31","v":0},{"$f":"[2]Ölverbrauch!G31","v":0}]
["2024-01-28",{"$f":"[2]Ölverbrauch!B32","v":0},{"$f":"[2]Ölverbrauch!C32","v":0},{"$f":"[2]Ölverbrauch!D32","v":0},{"$f":"[2]Ölverbrauch!E32","v":0},{"$f":"[2]Ölverbrauch!F32","v":0},{"$f":"[2]Ölverbrauch!G32","v":0}]
["2024-01-29",{"$f":"[2]Ölverbrauch!B33","v":0},{"$f":"[2]Ölverbrauch!C33","v":0},{"$f":"[2]Ölverbrauch!D33","v":0},{"$f":"[2]Ölverbrauch!E33","v":0},{"$f":"[2]Ölverbrauch!F33","v":0},{"$f":"[2]Ölverbrauch!G33","v":0}]
["2024-01-30",{"$f":"[2]Ölverbrauch!B34","v":0},{"$f":"[2]Ölverbrauch!C34","v":0},{"$f":"[2]Ölverbrauch!D34","v":0},{"$f":"[2]Ölverbrauch!E34","v":0},{"$f":"[2]Ölverbrauch!F34","v":0},{"$f":"[2]Ölverbrauch!G34","v":0}]
["2024-01-31",{"$f":"[2]Ölverbrauch!B35","v":0},{"$f":"[2]Ölverbrauch!C35","v":0},{"$f":"[2]Ölverbrauch!D35","v":0},{"$f":"[2]Ölverbrauch!E35","v":0},{"$f":"[2]Ölverbrauch!F35","v":0},{"$f":"[2]Ölverbrauch!G35","v":0}]
["Summe","Ölverbrauch DGM",null,{"$f":"SUM(B5:D35)","v":2150},"Ölverbrauch Presse",null,{"$f":"SUM(E5:G35)","v":650}]

{"sheet":"Sammeln","index":2,"n_rows":24,"n_cols":11,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[]
["DGM 3","2024-01-01",500,null,null,null,"DGM 3","2024-01-01",500]
["Presse 3","2024-01-01",200,null,null,null,"Presse 3","2024-01-01",200]
["DGM 3","2024-01-02",1200,null,null,null,"DGM 3","2024-01-02",1200]
["Presse 3","2024-01-02",300,null,null,null,"Presse 3","2024-01-02",300,null,"Bernd_"]
["DGM 3","2024-01-12",450,null,null,null,"DGM 3","2024-01-12",450,null,"2025-01-17T13:46:45"]
["Presse 3","2024-01-12",150,null,null,null,"Presse 3","2024-01-12",100,null,"Daten sammeln für Ölverbrauch"]
[null,null,null,null,null,null,null,null,null,null,"Hallo Zusammen,"]
[]
[null,null,null,null,null,null,null,null,null,null,"in meiner Beispieldatei gibt es das Sheet Ölverbrauch."]
[null,null,null,null,null,null,null,null,null,null,"Dort werden Ölverbräuche pro Tag und Schicht für eine Anlage DGM und eine Anlage Presse eingetragen."]
[]
[null,null,null,null,null,null,null,null,null,null,"Dieses Sheet gibt es in mehreren Dateien die sich in Unterordnern befinden. Die Unterorder befinden sich alle in einem Order."]
[null,null,null,null,null,null,null,null,null,null,"Die Dateien die das Sheet Ölverbrauch enthalten heißen alle ähnlich. Es sind xlsm und xlsx Dateien."]
[]
[null,null,null,null,null,null,null,null,null,null,"Das Sheet heiß aber in jeder Datei gleich und die Struktur ist immer die gleichen."]
[]
[null,null,null,null,null,null,null,null,null,null,"Gerne würde ich die Werte alle in einem Sheet sammeln."]
[null,null,null,null,null,null,null,null,null,null,"Auf dem Sheet Sammeln ( welches nur zum Beispiel dient und dann demnächst in einer anderen Datei ist ) habe ich es mal händisch eingetragen wie ich es mir Vorstelle."]
[]
[null,null,null,null,null,null,null,null,null,null,"Ist das mit einem Makro zu lösen ? Würde mich über Hilfe sehr freuen."]
[]
[null,null,null,null,null,null,null,null,null,null,"https://www.herber.de/bbs/user/174912.xlsx"]
[null,null,null,null,null,null,null,null,null,null,"Gruß Bernd_"]