These are the only spreadsheet templates we know of that are recalculated in LibreOffice as part of the build: every formula in every workbook is evaluated by Calc, compared with figures worked out outside any spreadsheet, and scanned for error cells before the file ships. Open the .xlsx and it works.
A week of trading, one row a day: card, cash, how much of it carried VAT, and how many people came in. Takings, the VAT already inside those sales and the spend per head are calculated. Pro adds the month's running costs with a budget, a variance and an On plan / Watch / Over status on every line, plus a summary that reads the week back to you. 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.
One row per medicine with its strength, dose and the times of day it's taken; the week grid records doses actually taken and works out adherence against what was due. Pro adds a refill planner — units used a day, days left, the date it runs out and the date to order — and a dated dose log. A tracker, not medical advice. No macros.
One row per goal or KPI: start, target, current, dates, owner. Progress, expected progress from the calendar, days left and a status — Done, On track, Behind, Overdue — are calculated. Pro adds monthly check-ins that feed the current value, and a view by area and by owner. No macros.
One row per service or repair with the odometer and the next-due the garage gave you; days and km to each, overdue and due-soon flags, cost this year. Pro adds a Vehicles sheet with cost per km and tax, insurance and inspection reminders, and a service schedule that reads last-done from the log. No macros.
Thirteen weeks across, cash in and out down: the balance carries forward, weeks below your buffer turn red, and the lowest point and its week are found for you. Pro fills the grid from a dated list of expected receipts and payments and shows what's still outstanding from past weeks. No macros.
One row per unit: property, tenant, rent, due day, lease dates, deposit. Vacancies, leases ending in ninety days, occupancy and monthly rent are calculated. Pro adds the rent payment log with a balance per tenant, an expense log, and a month-by-month view of rent due, collected and spent. No macros.
Students down the side, assessments across, with max points and a weight for each; the weighted percentage and letter grade follow, with class average, median, highest, lowest and missing per assessment and a grade distribution. Pro adds a per-student Report with rank and an Assessments sheet showing which was hardest. No macros.
One row per trip with the odometer at the start and end; distance is the difference and business trips are valued at your rate. Totals by purpose, business share and the claim for the year. Pro adds a fuel log with consumption and cost per mile between full tanks, and a monthly view. No macros.
One row per purchase order: supplier, amount, status, expected and received dates, paid. Days open or lead time, a Late flag, open value, unpaid invoices. Pro adds line items per PO with what's still to arrive, a supplier view with lead times, and a monthly view. No macros.
One row per set: date, exercise, weight, reps. Volume per set, this week's sessions, sets and volume, and the best weight and best set per exercise. Pro adds an Exercises sheet with bests, last done and days since, a twelve-week view, and a body-weight log with change. 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 wedding budget by category — estimated, actual, paid — with what's still to pay, over or under, and the honest budget left. Pro adds vendors with quotes, contracts, deposits and balance-due flags that feed the actuals, and a timeline whose dates follow the wedding date. No macros.
One row per recurring payment with its amount and frequency; the sheet turns them into a monthly and yearly cost, counts the days to each next due date, and flags what's overdue and due this week. Pro lays every bill across the next twelve months so the expensive months show, and totals by category. No macros.
One row per application: company, role, stage, dates, next step. Days waiting and which applications need a nudge are calculated; active, interviews, offers and response rate are kept at the top. Pro adds a Pipeline sheet with conversion between stages and results by source, and a Follow-ups sheet that lists what needs doing. No macros.
One row per invitation: adults and kids, RSVP, meal, table, gift and thank-you. Invited, responded, coming, meals per choice and what's missing for each Yes are counted. Pro adds tables with free seats, a budget with cost per head, and a timeline of tasks with what's late. No macros.
One row per transaction; the category decides whether it's income or an expense, so amounts stay positive and every total is a plain SUMIFS. Year totals and margin at the top, a category summary beside the log. Pro adds a Monthly sheet with quarters, a P&L by category with shares, and a formulas walkthrough. No macros.
Each savings goal gets a target, what you've saved and what you put in monthly; the sheet works out what's left, months to go, the projected date and whether it beats the date you wanted — plus the contribution that would hit every date. Pro adds net worth by account and type, and twelve months of snapshots with the change month by month. No macros.
A CRM for a small business or a freelancer: one row per deal with stage, value and next action. Probability comes from the stage, so every deal has a weighted value; days since contact show what's gone quiet; open value, weighted value, won and win rate at the top. Pro adds a Board by stage, owner and source, and a Follow-ups sheet. No macros.
List your debts, pick snowball or avalanche, type the extra you can pay each month: the payoff order, the interest per month and the months each debt takes on its minimum alone. Pro runs the whole payoff month by month — the extra rolls from each paid-off debt to the next — with payoff dates and total interest. 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 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.
One row per request — who, what kind, from, to — and the working days are counted for you, weekends out. Balances per person against an annual allowance. Pro excludes public holidays, adds an approval status, a Balances sheet per person and type, and a month calendar showing who's off on which day. 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.
A to-do list that knows what's late: task, category, priority, due date and a ✓ when done; status (Done, Overdue, Today, Soon, Open), days left and a progress bar are calculated. Pro adds a Focus sheet listing what's overdue and due this week, a Board with counts per category, person and priority, and a formulas walkthrough. No macros.
An invoice that adds itself up and prints on one page: line items, discount, tax, total, due date from terms. Pro fills the client's details and item prices from lists, and keeps a register of every invoice — outstanding, days overdue, status, aging buckets, next number. 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.
An expense log for Excel and Google Sheets that totals itself: this month by category with data bars, twelve months back, and spending against the limits you set — every formula visible. Pro adds the Monthly and Limits sheets, a Setup sheet with limits, and a formulas walkthrough.
Amount, rate, term, first payment: the monthly payment and a full schedule where interest is computed month by month from the balance, rounded to cents like a lender, so every figure is visible. Pro adds extra payments with payoff date and interest saved, a rate-and-term comparison grid, and a formulas walkthrough.
Names down the side, days across, one letter per cell — P, A, L, E, H — from a dropdown, coloured. Counts per person, attendance % that counts Late as present and leaves holidays out, present per day, weekends shaded. Pro adds a Summary with bars and flags, holidays from Setup, and a formulas walkthrough. 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.
Stock levels, reorder points and stock value for Excel and Google Sheets, every number a visible formula. Status turns yellow at the reorder point and red at zero. Pro adds a Movements log that updates quantities, a Reorder list with the cost to restock, a Dashboard by category, and a formulas walkthrough.
Habits down the side, days across the top, a mark when you did it. Done counts, a monthly target scaled from your weekly one, completion bars, weekends shaded. Pro adds current and best streaks with the running count on its own sheet, a by-week view, and a formulas walkthrough. No macros.
A task list with a Gantt chart drawn entirely by conditional formatting — no shapes, no macros. Start and end dates make the bar, Done % fills it, Blocked turns it red, a line marks this week. Pro adds a 26-week timeline, a Dashboard, Milestones and a formulas walkthrough.
A monthly budget for Excel and Google Sheets with every formula visible: planned vs actual by category, red/green differences, savings rate. Pro adds a transactions log that fills the budget automatically, a twelve-month view with a chart, and a sheet explaining each formula.
Most "works in LibreOffice" labels mean somebody opened the file once. Ours means the build script does: each workbook is loaded headless in LibreOffice Calc, recalculated, and its results are checked against expected values computed in Python — the same check runs in a second, independent formula engine. A single #NAME? or #VALUE! anywhere in the file fails the build. The screenshots on every product page are rendered from those LibreOffice results.
No macros (so no VBA that Calc would ignore), no FILTER, XLOOKUP, LET or dynamic arrays, no whole-column ranges, no add-ins. Where a modern function would be shorter, the workbook uses the portable form and explains it on a Formulas sheet — SUMPRODUCT(MAX(…)) instead of MAXIFS, a running COUNTIF instead of FILTER. The guide to building without macros lists every rule.
Yellow cells are inputs, everything else is a formula. Data validation shows as a dropdown arrow on the cell; conditional formats are under Format → Conditional → Manage if you want to see or change the rules. To keep a native copy, Save As → ODF Spreadsheet; to hand the file back to an Excel user, leave it as .xlsx.
No. LibreOffice Calc opens .xlsx directly — File → Open, or double-click. Keep it as .xlsx if you share it with Excel users, or File → Save As → ODF Spreadsheet (.ods) for a native copy.
Yes: data-validation lists become Calc validity lists, conditional formatting stays conditional, named ranges keep their names. The previews on every product page are rendered from the LibreOffice recalculation, so what you see there is what Calc shows.
Our build pipeline runs LibreOffice 7 on macOS. Anything from 6.x onwards has the functions these workbooks use.
Yes — one .xlsx per workbook, built from code, checked in two engines. There is no separate "LibreOffice edition" to keep in sync, which is the point.