{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Cover","JAHR.MONAT.TAG","DATUM","KALENDERWOCHE","HEUTE","JETZT"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"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":26,"n_cols":3,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Excel + VBA "]
[null,"für Controller"]
[]
[]
[null,"Kapitel",3]
[null,"Thema","Formeln und Funktionen"]
[]
[null,"Inhalt","Datumsfunktionen"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Version","1.0"]
[null,"Autor","Harald Nahrstedt"]
[null,"Datum","2025-04-25"]
[]
[]
[null,"Springer Verlag"]

{"sheet":"JAHR.MONAT.TAG","index":1,"n_rows":7,"n_cols":7,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Datum","Umsatz","Produkt","Jahr","Monat","Tag","Wochentag"]
["2023-02-13",21300,"P2",{"$f":"YEAR(Datum)","v":{"$error":"#NAME?"}},{"$f":"MONTH(Datum)","v":{"$error":"#NAME?"}},{"$f":"DAY(Datum)","v":{"$error":"#NAME?"}},{"$f":"Datum","v":{"$error":"#NAME?"}}]
["2023-03-16",35600,"P1",{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
["2023-04-11",32700,"P3",{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
["2023-05-15",28900,"P1",{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
["2023-06-13",31200,"P2",{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
["2023-07-17",29700,"P3",{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]

{"sheet":"DATUM","index":2,"n_rows":5,"n_cols":7,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Kunde","Wert","Datum","Skonto","Dauer","Zahlungshöhe","Fälligkeit"]
["A",24300,"2023-02-13",0.02,34,{"$f":"Wert*(1-Skonto)","v":{"$error":"#NAME?"}},{"$f":"Datum+Dauer","v":{"$error":"#NAME?"}}]
["B",26700,"2023-03-16",0.03,12,{"$f":"Wert*(1-Skonto)","v":{"$error":"#NAME?"}},{"$f":"Datum+Dauer","v":{"$error":"#NAME?"}}]
["C",19800,"2023-04-11",0.02,18,{"$f":"Wert*(1-Skonto)","v":{"$error":"#NAME?"}},{"$f":"Datum+Dauer","v":{"$error":"#NAME?"}}]
["D",32100,"2023-05-15",0.04,9,{"$f":"Wert*(1-Skonto)","v":{"$error":"#NAME?"}},{"$f":"Datum+Dauer","v":{"$error":"#NAME?"}}]

{"sheet":"KALENDERWOCHE","index":3,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Datum","Umsatz","Produkt","Kalenderwoche"]
["2023-02-13",21300,"P2",{"$f":"WEEKNUM(DATEVALUE(TEXT(Datum,\"TT.MM.JJJJ\")))","v":{"$error":"#NAME?"}}]
["2023-03-16",35600,"P1",{"$error":"#NAME?"}]
["2023-04-11",32700,"P3",{"$error":"#NAME?"}]
["2023-05-15",28900,"P1",{"$error":"#NAME?"}]
["2023-06-13",31200,"P2",{"$error":"#NAME?"}]
["2023-07-17",29700,"P3",{"$error":"#NAME?"}]

{"sheet":"HEUTE","index":4,"n_rows":4,"n_cols":5,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["ToDo",{"$f":"TODAY()","v":"2025-04-25"},{"$f":"TODAY()+7","v":"2025-05-02"},{"$f":"TODAY()+14","v":"2025-05-09"},{"$f":"TODAY()+21","v":"2025-05-16"}]
["A"]
["B"]
["C"]

{"sheet":"JETZT","index":5,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,{"$f":"NOW()","v":"2025-04-25T08:32:21.990"}]
[null,{"$f":"NOW()","v":"2025-04-25T08:32:21.990"}]