{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Formeln","Feiertage","NETTOARBEITSTAGE()"],"not_rendered":{"charts":0,"images":0,"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":"Formeln","index":0,"n_rows":19,"n_cols":8,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Jahr","Formel","Ergebnis"]
[2020,{"$f":"_xlfn.FORMULATEXT(C2)","v":"=OsterSonntag1(A2)"},{"$f":"OsterSonntag1(A2)","v":"2020-04-12"}]
[null,{"$f":"_xlfn.FORMULATEXT(C3)","v":"=OsterSonntag2(A2)"},{"$f":"OsterSonntag2(A2)","v":"2020-04-12"}]
[null,{"$f":"_xlfn.FORMULATEXT(C4)","v":"=OsterSonntag3(A2)"},{"$f":"OsterSonntag3(A2)","v":"2020-04-12"}]
[null,{"$f":"_xlfn.FORMULATEXT(C5)","v":"=EasterUSNO(A2)"},{"$f":"EasterUSNO(A2)","v":"2020-04-12"}]
[null,{"$f":"_xlfn.FORMULATEXT(C6)","v":"=OsterSonntagEinzeiler(A2)"},{"$f":"OsterSonntagEinzeiler(A2)","v":"2020-04-12"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"NETWORKDAYS(DATE(2020,4,11),DATE(2020,4,21))","v":7}]

{"sheet":"Feiertage","index":1,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Feiertage (in Bayern)","Formel","Ergebnis","WoT"]
["Neujahrstag",{"$f":"_xlfn.FORMULATEXT(C2)","v":"=DATUM(Formeln!$A$2;1;1)"},{"$f":"DATE(Formeln!$A$2,1,1)","v":"2020-01-01"},{"$f":"WEEKDAY(C2)","v":"1900-01-04"}]
["Dreikönigstag",{"$f":"_xlfn.FORMULATEXT(C3)","v":"=DATUM(Formeln!$A$2;1;6)"},{"$f":"DATE(Formeln!$A$2,1,6)","v":"2020-01-06"},{"$f":"WEEKDAY(C3)","v":"1900-01-02"}]
["Karfreitag","=OsterSonntag1(Formeln!$A$2)-2",{"$f":"OsterSonntag1(Formeln!$A$2)-2","v":"2020-04-10"},"1900-01-06"]
["Ostermontag","=OsterSonntag1(Formeln!$A$2)+1",{"$f":"OsterSonntag1(Formeln!$A$2)+1","v":"2020-04-13"},"1900-01-02"]
["Tag der Arbeit","=DATUM(Formeln!$A$2;5;1)",{"$f":"DATE(Formeln!$A$2,5,1)","v":"2020-05-01"},"1900-01-06"]
["Christi Himmelfahrt","=OsterSonntag1(Formeln!$A$2)+39",{"$f":"OsterSonntag1(Formeln!$A$2)+39","v":"2020-05-21"},"1900-01-05"]
["Pfingstmontag","=OsterSonntag1(Formeln!$A$2)+50",{"$f":"OsterSonntag1(Formeln!$A$2)+50","v":"2020-06-01"},"1900-01-02"]
["Fronleichnam","=OsterSonntag1(Formeln!$A$2)+60",{"$f":"OsterSonntag1(Formeln!$A$2)+60","v":"2020-06-11"},"1900-01-05"]
["Maria Himmelfahrt","=DATUM(Formeln!$A$2;8;15)",{"$f":"DATE(Formeln!$A$2,8,15)","v":"2020-08-15"},"1900-01-07"]
["Tag der Deutschen Einheit","=DATUM(Formeln!$A$2;10;3)",{"$f":"DATE(Formeln!$A$2,10,3)","v":"2020-10-03"},"1900-01-07"]
["1. Weihnachtsfeiertag","=DATUM(Formeln!$A$2;12;25)",{"$f":"DATE(Formeln!$A$2,12,25)","v":"2020-12-25"},"1900-01-06"]
["2. Weihnachtsfeiertag","=DATUM(Formeln!$A$2;12;26)",{"$f":"DATE(Formeln!$A$2,12,26)","v":"2020-12-26"},"1900-01-07"]

{"sheet":"NETTOARBEITSTAGE()","index":2,"n_rows":4,"n_cols":4,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[null,null,"ohne Berücksichtigung von Feiertagen","mit Berücksichtigung von Feiertagen"]
["Anfangsdatum","2020-01-01"]
["Enddatum","2020-08-31"]
["Nettoarbeitstage",null,{"$f":"NETWORKDAYS($B2,$B3)","v":174},{"$f":"NETWORKDAYS($B2,$B3,Feiertage!C2:C13)","v":166}]