Guest User

Untitled

a guest
Jan 1st, 2023
578
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 5.62 KB | None | 0 0
  1. Von: https://www.karl-voit.at/Feiertage/
  2.  
  3. | Jahr | Feiertage Mo-Fr | Feiertage Sa/So | Urlaubstage 24.12.-6.1. Folgejahr |
  4. |------+-----------------+-----------------+-----------------------------------|
  5. | 2020 | 11 | 3 | 6 |
  6. | 2021 | 10 | *4* | 8 |
  7. | 2022 | 10 | *4* | 8 |
  8. | 2023 | *12* | 2 | 7 |
  9. | 2024 | 11 | 3 | *5* |
  10. | 2025 | *12* | 2 | *5* |
  11. | 2026 | 11 | 3 | 6 |
  12. | 2027 | 10 | *4* | 8 |
  13. | 2028 | *12* | 2 | 7 |
  14. | 2029 | *12* | 2 | 6 |
  15. | 2030 | 11 | 3 | *5* |
  16.  
  17. - Kontrolle der Feiertage: https://www.feiertage-oesterreich.at/2025/ usw.
  18.  
  19. - process
  20. 1. untere Tabelle: Jahr in =year=-variable eintragen
  21. 2. untere Tabelle aktualisieren
  22. 3. @17$7, @17$8, @27$7 in Tabelle oben als $2, $3, $4 manuell dazuschreiben
  23.  
  24. | $ | year=2024 | | | | | | |
  25. | ! | Feiertag | Tag | Monat | Wochentag | DOW | Unter der Woche | Wochenende |
  26. |---+---------------------------+-----+-------+-----------+-----+-----------------+------------|
  27. | | Neujahr | 1 | 1 | Monday | 1 | 1 | 0 |
  28. | | Heilige Drei Könige | 6 | 1 | Saturday | 6 | 0 | 1 |
  29. | | Staatsfeiertag | 1 | 5 | Wednesday | 3 | 1 | 0 |
  30. | | Mariä Himmelfahrt | 15 | 8 | Thursday | 4 | 1 | 0 |
  31. | | Nationalfeiertag | 26 | 10 | Saturday | 6 | 0 | 1 |
  32. | | Allerheiligen | 1 | 11 | Friday | 5 | 1 | 0 |
  33. | | Mariä Empfängnis | 8 | 12 | Sunday | 7 | 0 | 1 |
  34. | | Heiliger Abend | 24 | 12 | Tuesday | 2 | 1 | 0 |
  35. | | Weihnachten | 25 | 12 | Wednesday | 3 | 1 | 0 |
  36. | | Stefanitag | 26 | 12 | Thursday | 4 | 1 | 0 |
  37. |---+---------------------------+-----+-------+-----------+-----+-----------------+------------|
  38. | | Ostermontag | - | - | Monday | 1 | 1 | 0 |
  39. | | Christi Himmelfahrt | - | - | Thursday | 4 | 1 | 0 |
  40. | | Pfingstmontag | - | - | Monday | 1 | 1 | 0 |
  41. | | Fronleichnam | - | - | Thursday | 4 | 1 | 0 |
  42. |---+---------------------------+-----+-------+-----------+-----+-----------------+------------|
  43. | | *Feiertage Woche/WE* | | | | | 11 | 3 |
  44. |---+---------------------------+-----+-------+-----------+-----+-----------------+------------|
  45. | | | 27 | 12 | Friday | 5 | 1 | 0 |
  46. | | | 28 | 12 | Saturday | 6 | 0 | 1 |
  47. | | | 29 | 12 | Sunday | 7 | 0 | 1 |
  48. | | | 30 | 12 | Monday | 1 | 1 | 0 |
  49. | | | 31 | 12 | Tuesday | 2 | 1 | 0 |
  50. | | Folgejahr | 2 | 1 | Thursday | 4 | 1 | 0 |
  51. | | Folgejahr | 3 | 1 | Friday | 5 | 1 | 0 |
  52. | | Folgejahr | 4 | 1 | Saturday | 6 | 0 | 1 |
  53. | | Folgejahr | 5 | 1 | Sunday | 7 | 0 | 1 |
  54. |---+---------------------------+-----+-------+-----------+-----+-----------------+------------|
  55. | | *Arbeitstage 24.12.-6.1.* | | | | | 5 | |
  56. #+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)
  57.  
Advertisement
Add Comment
Please, Sign In to add comment