Project Portfolio Tracker with Resource Allocation and Budget Burn-Down,\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n

Create a project portfolio tracker in Excel for [COMPANY NAME] managing [NUMBER] simultaneous projects with a total portfolio budget of $[AMOUNT].\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n**Tab 1 — Project Registry:**\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n- Columns: Project ID, Name, Client, PM, Start Date, End Date, Status (Planning/Active/On Hold/Complete), Budget, Actual Spend, % Complete, Health (R/Y/G)\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n- Auto-calculated: Days remaining, Budget variance $, Budget variance %\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n**Tab 2 — Budget Burn-Down:**\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n- Weekly burn rate per project\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n- Planned vs. actual spend line chart\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n- Remaining budget forecast: (Budget - Actual) / Weekly Burn Rate = Estimated weeks remaining\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n- Conditional formatting: red when forecast < remaining timeline\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n- Portfolio-level burn-down chart\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n**Tab 3 — Resource Allocation:**\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n- Resource matrix: rows = team members, columns = weeks\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n- Hours allocated per project per week\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n- Utilization rate: allocated hours / available hours\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n- Overallocation alerts (>40 hours/week)\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n- Bench/available capacity\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n**Tab 4 — Timeline and Milestones:**\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n- Gantt-style view (conditional formatting on date columns)\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n- Key milestones with planned vs. actual dates\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n- Delay tracking: days behind schedule\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n- Critical path indicators\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n**Tab 5 — Portfolio Health Dashboard:**\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n- RAG status summary (count by color)\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n- Budget health: % of projects within 10% of budget\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n- Timeline health: % of projects on schedule\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n- Resource health: % of team members within capacity\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n- Top 5 risks across portfolio\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n- Executive summary: 3-5 bullet points\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\nUse XLOOKUP, SUMIFS, and conditional formatting for the Gantt chart.