Project Timeline & Capacity Planner

Create a simple timeline and capacity planner in spreadsheets. This prompt pack guides ChatGPT to design a projects tab and a team capacity tab.

Key features:
- Projects tab: project name, client, start and end dates, owner, hours budgeted.
- Team tab listing each member and weekly capacity.
- Formulas to sum assigned hours per person per week.
- Gantt-style timeline using conditional formatting across dates.
- Warning formula when capacity exceeds 100%.
- Usage notes to avoid broken references.
- Includes Google Sheets and Excel variants.