What happens when, who works when, and how long they worked: a calendar that redraws itself for any month with your events in the days, a weekly planner with time slots and planned hours, a travel itinerary with costs per day, a meal plan with cost and prep per day, a rota with shift codes that turn into hours and pay, and a timesheet that turns times in and out into hours, overtime and billable amounts.
Type any date and the week lays itself out: seven day columns with real dates, fifteen time slots from the hour you start, weekends shaded, today highlighted. Planned and free hours per day are counted. Pro adds a Priorities sheet whose top three show on the week, a Friday Review sheet, and a formulas walkthrough. No macros.
Chores down the side, seven days across, and a rotation that says whose turn each one is this week — change the date and the chart re-deals itself. Ticks, minutes and what's still owed are calculated, and each person's share is worked out on minutes, not on the number of chores. Pro adds eight weeks of the rotation printed ahead and a People sheet comparing everyone against a fair share. No macros.
Type in and out as times and a break in hours; hours and overtime are calculated, night shifts past midnight included. Pro adds a log with projects and hourly rates, billable amounts per project and per week, distinct days worked, and a formulas walkthrough. No macros.
A week of meals picked from your recipe list, with cost and prep minutes per day worked out from the recipes, and a shopping list with ticks. Pro moves the recipes to their own sheet with categories, and the shopping list to one with aisles and what's left per aisle. No macros.
A week of shifts: people down the side, seven days across, a shift code per cell from a dropdown — hours and pay per person come from the code table, headcount per day is counted. Pro adds coverage against required staffing per shift, payroll with overtime, and a formulas walkthrough. No macros.
One row per day of the trip: dates from the start date, where you are, what you plan, and what it costs by kind. Daily and trip totals, per day and per person, against a budget. Pro adds a Budget sheet by kind, Bookings with confirmations and what's still to pay, and a Packing checklist. No macros.
Type a year and a month and the calendar redraws itself: weekends shaded, today blue, other months greyed, and your events written into the right days from a list. Pro adds the whole year on one sheet, a week planner, holidays, and a formulas walkthrough. No macros.
Slate turns a year and a month into a printable grid with your events in the right days — and, in Pro, a whole year on one page and a week planner. Rota reads a shift code per person per day and turns it into hours and pay through a code table you control. Clock reads times in and out — fractions of a day in Excel — and turns them into hours, with a daily or weekly overtime threshold.
For the calendar: the Year sheet, the Week planner, holidays highlighted and named, two hundred event rows with categories. For the rota: a Coverage sheet that compares scheduled against required per shift per day and colours the gaps, and a Payroll sheet with overtime at your multiplier. For the timesheet: a log with projects and hourly rates, billable amounts per project and per week, and distinct days worked.
The month calendar with a fifty-row event list, or the week sheet with hours, with a credit line kept. Pro adds the rest and the formulas walkthrough.
Yes. Every cell in the grid is a formula: the first of the month stepped back to the start of its week, plus an offset. Change the year or the month and the grid, the weekend shading and the events redraw. Week can start on Monday or Sunday.
From a code table on Setup: M, E, N, D, O with hours each. One SUMPRODUCT(SUMIF) formula looks up all seven days at once — no XLOOKUP needed, so Excel 2016 and Numbers are fine.
Yes. If the out time is earlier than the in time, the formula adds a day before subtracting, so 22:00 to 06:00 is 8 hours.
The week sheet — rota with hours and headcount, or timesheet with daily overtime — with a credit line kept. Pro adds coverage, payroll, project logs and the formulas walkthrough.