Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Von: https://www.karl-voit.at/Feiertage/
- | Jahr | Feiertage Mo-Fr | Feiertage Sa/So | Urlaubstage 24.12.-6.1. Folgejahr |
- |------+-----------------+-----------------+-----------------------------------|
- | 2020 | 11 | 3 | 6 |
- | 2021 | 10 | *4* | 8 |
- | 2022 | 10 | *4* | 8 |
- | 2023 | *12* | 2 | 7 |
- | 2024 | 11 | 3 | *5* |
- | 2025 | *12* | 2 | *5* |
- | 2026 | 11 | 3 | 6 |
- | 2027 | 10 | *4* | 8 |
- | 2028 | *12* | 2 | 7 |
- | 2029 | *12* | 2 | 6 |
- | 2030 | 11 | 3 | *5* |
- - Kontrolle der Feiertage: https://www.feiertage-oesterreich.at/2025/ usw.
- - process
- 1. untere Tabelle: Jahr in =year=-variable eintragen
- 2. untere Tabelle aktualisieren
- 3. @17$7, @17$8, @27$7 in Tabelle oben als $2, $3, $4 manuell dazuschreiben
- | $ | year=2024 | | | | | | |
- | ! | Feiertag | Tag | Monat | Wochentag | DOW | Unter der Woche | Wochenende |
- |---+---------------------------+-----+-------+-----------+-----+-----------------+------------|
- | | Neujahr | 1 | 1 | Monday | 1 | 1 | 0 |
- | | Heilige Drei Könige | 6 | 1 | Saturday | 6 | 0 | 1 |
- | | Staatsfeiertag | 1 | 5 | Wednesday | 3 | 1 | 0 |
- | | Mariä Himmelfahrt | 15 | 8 | Thursday | 4 | 1 | 0 |
- | | Nationalfeiertag | 26 | 10 | Saturday | 6 | 0 | 1 |
- | | Allerheiligen | 1 | 11 | Friday | 5 | 1 | 0 |
- | | Mariä Empfängnis | 8 | 12 | Sunday | 7 | 0 | 1 |
- | | Heiliger Abend | 24 | 12 | Tuesday | 2 | 1 | 0 |
- | | Weihnachten | 25 | 12 | Wednesday | 3 | 1 | 0 |
- | | Stefanitag | 26 | 12 | Thursday | 4 | 1 | 0 |
- |---+---------------------------+-----+-------+-----------+-----+-----------------+------------|
- | | Ostermontag | - | - | Monday | 1 | 1 | 0 |
- | | Christi Himmelfahrt | - | - | Thursday | 4 | 1 | 0 |
- | | Pfingstmontag | - | - | Monday | 1 | 1 | 0 |
- | | Fronleichnam | - | - | Thursday | 4 | 1 | 0 |
- |---+---------------------------+-----+-------+-----------+-----+-----------------+------------|
- | | *Feiertage Woche/WE* | | | | | 11 | 3 |
- |---+---------------------------+-----+-------+-----------+-----+-----------------+------------|
- | | | 27 | 12 | Friday | 5 | 1 | 0 |
- | | | 28 | 12 | Saturday | 6 | 0 | 1 |
- | | | 29 | 12 | Sunday | 7 | 0 | 1 |
- | | | 30 | 12 | Monday | 1 | 1 | 0 |
- | | | 31 | 12 | Tuesday | 2 | 1 | 0 |
- | | Folgejahr | 2 | 1 | Thursday | 4 | 1 | 0 |
- | | Folgejahr | 3 | 1 | Friday | 5 | 1 | 0 |
- | | Folgejahr | 4 | 1 | Saturday | 6 | 0 | 1 |
- | | Folgejahr | 5 | 1 | Sunday | 7 | 0 | 1 |
- |---+---------------------------+-----+-------+-----------+-----+-----------------+------------|
- | | *Arbeitstage 24.12.-6.1.* | | | | | 5 | |
- #+TBLFM: @3$5..@12$5='(format-time-string "%A" (encode-time 0 0 0 (string-to-number $3) (string-to-number $4) $year nil nil nil))::@3$6..@12$6='(format-time-string "%u" (encode-time 0 0 0 (string-to-number $3) (string-to-number $4) $year nil nil nil))::@3$7..@12$7='(if (> 5.1 (string-to-number $6)) "1" "0")::@3$8..@12$8='(if (< 5.1 (string-to-number $6)) "1" "0")::@13$7..@16$7='(if (> 5.1 (string-to-number $6)) "1" "0")::@13$8..@16$8='(if (< 5.1 (string-to-number $6)) "1" "0")::@17$7=vsum(@3$7..@16$7)::@17$8=vsum(@3$8..@16$8)::@18$5..@22$5='(format-time-string "%A" (encode-time 0 0 0 (string-to-number $3) (string-to-number $4) $year nil nil nil))::@18$6..@22$6='(format-time-string "%u" (encode-time 0 0 0 (string-to-number $3) (string-to-number $4) $year nil nil nil))::@18$7..@22$7='(if (> 5.1 (string-to-number $6)) "1" "0")::@18$8..@22$8='(if (< 5.1 (string-to-number $6)) "1" "0")::@23$5..@26$5='(format-time-string "%A" (encode-time 0 0 0 (string-to-number $3) (string-to-number $4) (+ 1 $year) nil nil nil))::@23$6..@26$6='(format-time-string "%u" (encode-time 0 0 0 (string-to-number $3) (string-to-number $4) (+ 1 $year) nil nil nil))::@23$7..@26$7='(if (> 5.1 (string-to-number $6)) "1" "0")::@27$7=vsum(@18$7..@26$7)
Advertisement
Add Comment
Please, Sign In to add comment