Crew Active

Use this when someone asks how many working days (Arbeitstage) a year, a month or any period has in Germany, for a Bundesland and the weekdays someone works, or how many target hours (Sollstunden) that makes. For example "Arbeitstage 2027 Bayern", "Wie viele Arbeitstage hat der Dezember 2026 in NRW?", "Arbeitstage im Monat bei 4-Tage-Woche", "Sollstunden 2027 bei 38,5 Stunden", "working days in Germany 2027". Counts every day of the year or period that is one of the weekdays worked (Monday to Friday unless given), minus the public holidays of the Bundesland on those days (without a Bundesland only the 9 nationwide ones; local ones like Mariä Himmelfahrt or the Augsburger Friedensfest only when given), minus 24 and 31 December when they are company days off. Returns the working days, the holidays that cost a working day and those on days off anyway, one row per month, and with weekly hours the target hours (weekly hours / weekdays worked x working days) per month and in total, plus hints when the weekly hours break the basic limits of the German Working Hours Act (more than 10 hours a day or 48 a week, § 3 ArbZG) or Sunday is a working day (§§ 9 to 11). Also an Excel file with the months. Only days in 2026 and 2027, the years whose holidays were checked. Do not use it for vacation planning or the vacation days a period costs (use plan_vacation), bridge days (use find_bridge_days), tax deductions such as the commuter allowance (Pendlerpauschale), school holidays, or other countries. It saves nothing.

count_working_days

Adds up one person's working hours for one week (Monday to Sunday) from start, end and break per day, as a German timesheet (Stundennachweis), and checks them against the German Working Hours Act (Arbeitszeitgesetz): at most 10 hours of work per day (§ 3), at least 30 minutes of break after more than 6 hours and 45 minutes after more than 9 hours (§ 4), at least 11 hours of rest between working days (§ 5), and a day that starts before the one before has ended. Working time is end minus start minus break; an end before the start is on the next day. Returns the hours per day and for the week in hours:minutes and decimal hours, overtime or minus hours against an optional weekly target, the broken rules in German, and an Excel file of the timesheet. Use it when someone wants to add up, record or check the hours one person worked in a week. One person, one week and one start and end per day per call; for a split shift give the first start, the last end and the time in between as break. It knows only the day's total break, so it does not check break blocks of at least 15 minutes or more than 6 hours of work in a row; the rest before Monday is checked only when previousSunday is given. It does not check collective agreements (Tarifverträge), Sunday and holiday work, the 8-hour average over six months, the exceptions in § 5 (2) and § 7 ArbZG, or the rules for minors (Jugendarbeitsschutzgesetz). It saves nothing.

calculate_working_hours

Use this when someone asks for the bridge days (Brückentage) of a year in Germany: the one or two working days between a public holiday and the weekend or other days off that turn a few days of vacation into a long stretch off. For example "Brückentage 2027", "Brückentage 2027 Bayern", "Wann lohnt sich Urlaub 2027 in NRW?", "lange Wochenenden 2026 Berlin", "bridge days Germany 2027". For a year (2026 and 2027), a Bundesland and the weekdays a team works (Monday to Friday unless given), returns every Brückentag with the holiday next to it, the vacation days it costs, the days off in a row it gives and that stretch's dates, marks those already over, and lists the year's public holidays with whether each falls on a working day. The days are those crew-active.de's Urlaubsplaner marks (the same holiday table plan_vacation uses), and for 2027 on a Monday to Friday week those of its Brückentage 2027 page. Also an Excel file. Only 2026 and 2027, the years whose holidays were checked; local holidays of single towns only when given in localHolidays. Do not use it to plan or count a team's vacation (use plan_vacation), to count working days (use count_working_days), for school holidays, or for other countries. It saves nothing.

find_bridge_days

Builds a weekly shift schedule (Dienstplan) for a small team in Germany and checks it against the German Working Hours Act (Arbeitszeitgesetz): at most 10 hours of work per day (§ 3), 30 or 45 minutes of break after 6 or 9 hours (§ 4), 11 hours of rest between shifts (§ 5), and overlapping shifts. Returns hours per person and per day, the broken rules in German, and an Excel file of the week. Use it when someone wants to plan, write down or check who works which shift in a week. It plans one week per call; for several weeks, call it once per week. It does not save the plan anywhere and does not check collective agreements (Tarifverträge) or the exceptions in § 5 (2) and § 7 ArbZG.

create_shift_plan

Use this when someone asks what an employer in Germany must pay at least per hour: the statutory minimum wage (gesetzlicher Mindestlohn) or a sector minimum wage (Branchenmindestlohn) for cleaning (Gebäudereinigung), care (Pflege), roofing, painting, electrical trades, scaffolding, temporary work or SGB II/III training, in 2026 and 2027. For example "Mindestlohn 2027", "Mindestlohn Gebäudereinigung 2026 Lohngruppe 1", "Pflegemindestlohn ab Juli", "Wie viele Stunden darf ein Minijobber 2027 arbeiten?", "Ist ein Stundenlohn von 14 Euro erlaubt?", "minimum wage Germany 2027". Returns the minimum per hour for the sector and wage group (Lohngruppe) on a given day, always with the day the rate starts (and ends), its source with a link (the regulation, or the published wage table), and the day the rates were checked ("Stand"); every rate of that year; with weekly or monthly hours the minimum gross pay per month (weekly hours x 13/3) and per year; the Minijob earnings limit and the most hours a Minijobber can work at that wage; and, with an hourly wage, whether it reaches the minimum (for a Tariflohn group also the statutory one) and how much is missing per month. When a sector has no agreed wage yet for the time asked (e.g. Gebäudereinigung 2027) it says so with the date it was checked, and that the statutory minimum applies. Also an Excel file of the result. Only 2026 and 2027: for other years it refuses instead of guessing. Do not use it for net pay, taxes or social security contributions, supplements (Zuschläge), wages from collective agreements other than the listed groups, other countries, or legal advice; for a timesheet with pay use create_timesheet. It saves nothing.

calculate_minimum_wage

Builds a snow clearing and gritting log (Räumprotokoll Winterdienst) for one site in Germany: one row per run with date, arrival and departure, who did it, what was done (cleared, gritted, or checked without action), de-icing material and amount, weather and a note. Returns the duration of each run, the total hours, the runs per activity, warnings in German (a missing date, a departure before the arrival, a run entered twice) and an Excel file of the log. Use it when someone wants to write down, collect or export the winter service runs (Winterdienst) at a property, for example as the record a snow clearing company or caretaker keeps of its duty of care (Verkehrssicherungspflicht). One site per call, up to 400 runs; for several sites, call it once per site. The tool stores nothing and remembers no earlier call, so send the whole log each time, including the runs from before. It is a record the user keeps, not legal advice: it does not check when or how often clearing is required, which depends on the local bylaw (Satzung) and the contract.

create_snow_clearing_log

Builds the monthly timesheet (Stundenzettel, Stundennachweis) of one or more employees in Germany: start, end, break and duration of each working day, the record § 17 MiLoG asks for. Per person it adds up the working days and hours (h:mm and decimal) and the days of vacation or holiday off, and with an hourly wage it gives the gross pay and says when the wage is below the statutory minimum wage of that year. It checks each day against the German Working Hours Act (Arbeitszeitgesetz): 30 or 45 minutes of break after 6 or 9 hours (§ 4; the time between two blocks of a split shift counts as break), at most 10 hours a day (§ 3), 11 hours of rest between working days (§ 5), and overlapping times. Public holidays of the chosen Bundesland are marked. Returns the totals and hints in German and an Excel file with one sheet per person. Use it when someone wants to record, add up or check the working hours of employees for a month. Only vacation and a public holiday off can be marked as absences: leave any other absence as a day without entries, and do not record why someone is absent (no sick days or other health information). One month per call, only months in 2026 and 2027; for several months, call it once per month. A shift that ends after midnight counts in full on the day it starts. It does not save anything, does not compute surcharges for night, Sunday or holiday work, taxes or social insurance, does not check collective agreements (Tarifverträge), and checks the rest time only within the month.

create_timesheet

Plans a team's vacation (Urlaub) for one calendar year in Germany. Counts the vacation days each period costs: only the team's working days, without weekends and without the public holidays of the chosen Bundesland. Returns per person the entitlement, the days planned and the days left, the days with the most people away, and warnings in German: more people away at once than allowed, more planned than the entitlement, an entitlement below the legal minimum of § 3 BUrlG (20 days on a 5-day week, 24 on a 6-day week), and periods that overlap, are reversed or lie outside the year. Also returns an Excel file with an overview and a day-by-day calendar. Use it when someone wants to plan, write down or check a team's vacation for a year, or asks how many vacation days a period costs or how many are left. Only the years 2026 and 2027; up to 60 people with up to 40 periods each. It does not save the plan anywhere, does not prorate the entitlement for people who join or leave during the year, and does not know collective agreements (Tarifverträge), school holidays, or holidays of single towns unless they are given in localHolidays.

plan_vacation