This app calculates each person’s real, plannable capacity for a Program Increment (PI) automatically — you set up who and when once, layer in public holidays, vacations, and other absences, and every calendar, report, and export updates on its own.

Recommended order, top to bottom in the tabs:

1. Plan Setup — teams, roles, countries, absence types, your roster, and the PI/Sprint calendar itself.
2. Public Holiday Setup — each country’s holidays, inherited automatically by everyone assigned there.
3. Vacation Setup — planned time off, per person.
4. Effort & Net Capacity — fine-tune with partial-day deductions and see the real numbers, per sprint and rolled up.
5. Live Preview — build a filtered view to present or share.

Nothing here is one-way: go back and adjust Plan Setup at any point and everything downstream recalculates.

This is where every other page gets its data from — get it right here first.

• Teams and Roles — simple named lists with a color, used everywhere else.
• Countries — which countries your people work from; each one gets its own Public Holiday calendar.
• Absence Types — the short codes you’ll see on calendars (e.g. PH, A, TR), each with a color and a "counts as present" flag for compressed-schedule days that shouldn’t reduce capacity.
• Team Roster — one row per person per assignment: team, role, country, FTE, and a date range (typed by hand, or linked to a PI/Sprint so it follows that period’s dates automatically). A person can have more than one row — split across teams, or moved partway through the year.
• PI Periods & Sprints — your actual planning calendar: each PI’s start/end date and its sprints.

Input: names, colors, FTE, and date ranges you type in. Output: the roster and calendar every other tab builds on — plus a read-only Live Preview at the bottom of this tab showing it all laid out already.

Add each country’s public holidays for whichever years you need — click a date directly on the calendar, or use "Import PH Excel" to load a prepared list. Every member assigned to that country inherits its holidays automatically; you never mark them one person at a time.

Input: a country, a year, and specific dates. Output: those dates show as PH everywhere in the app (every calendar, every report) and are excluded from that country’s people’s capacity automatically.

Same idea as Public Holiday Setup, but per person instead of per country — add planned vacation days for each team member, by hand or via "Import Vacation Excel." Weekends and that person’s own country’s public holidays are never accepted as vacation, by hand or by import — there’s nothing to mark on those days.

Input: a person, a year, and specific dates. Output: those days reduce that person’s Net Capacity in Effort & Net Capacity, shown as A (Absence/Vacation) everywhere.

This is where the real numbers live. For every sprint, each person’s Capacity (working days × FTE, after holidays and vacation) shows as "achieved / max possible." You can additionally type in Effort — time spent on things that aren’t a full-day absence (a training afternoon, a few hours of support work) — sprint by sprint, per person; Net = Capacity − Effort.

Totals roll up automatically by team, by team-and-role, and as one Grand Total for the whole project, each with a utilization percentage next to the total.

Input: manual Effort entries where relevant. Output: the real, plannable capacity numbers for the PI, ready to compare against what the team is committing to.

Build your own filtered views for sharing or presenting — pick a PI, optionally narrow to specific sprints, teams, or roles, and you get a calendar plus a stats panel (members, total FTE, net/max capacity, utilization, a days-by-type breakdown) for just that slice.

Sections are Locked by default (read-only, safest for presenting). Uncheck "Locked" to stage edits to Vacation or other absence types right from the section’s own calendar — Public Holidays always stay read-only here, edited only from Public Holiday Setup. Staged edits don’t touch your real project until you click "Save changes and propagate to project" at the bottom of the page.

Everything lives in one file, managed from the File menu (top left): New starts a blank plan, Open… loads an existing file, Save / Save As… writes it back to disk. The app also autosaves a draft locally in your browser as a safety net, offered back to you if you reopen without having saved.

A plan’s status (top right) is Draft while you’re working on it; switch it to Final to lock every input against further edits. Undo/Redo (the two arrows next to File) covers most edits, including a full staged-edits propagate from Live Preview, in one step.

Every list in Plan Setup (Teams, Roles, Countries, Absence Types, Team Roster), plus Public Holiday and Vacation Setup, has its own Download … Excel Template + Import … Excel pair — download the blank template (pre-filled with valid values where relevant, e.g. a "Valid values" sheet listing your current Teams/Roles/Countries), fill it in your own spreadsheet software, then import it back. The app always shows a preview of what it found before committing anything.

Each Live Preview calendar also has its own Download Excel (plain .xlsx, typed numbers) and Download Colored (.xls) (matches the on-screen colors) buttons. For the whole project at once, use File → Export .xlsx or Export CSV.