{"product_id":"project-management-spreadsheet","title":"Project Portfolio Dashboard Spreadsheet","description":"\u003cp\u003eThis project management spreadsheet keeps every project you run in one workbook. You enter a task once, and the Gantt timeline, the Kanban board, the Eisenhower matrix and the dashboard all update from it. There are no pivot tables to refresh and no subscription to pay.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003ePlease read:\u003c\/strong\u003e This is a tracker tool only, not financial, tax, legal, medical or any other professional advice or advisory service. It records and calculates what you enter; you are solely responsible for checking all figures, rates, dates and results and for every decision you make. By purchasing, downloading or using it, you accept these terms (your statutory consumer rights are not affected).\u003c\/p\u003e\u003ch2\u003eThe dashboard\u003c\/h2\u003e\u003cp\u003eChoose All or a single project from one dropdown and the whole page follows your choice. You never type on it; it fills itself from the other tabs.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eLive KPIs for open tasks, completed tasks, overdue tasks, open risks and spend, each charted per project\u003c\/li\u003e\n\u003cli\u003eA portfolio timeline that shows every project as a Gantt bar, with work done, deliverables and today marked\u003c\/li\u003e\n\u003cli\u003eWork done against time gone, so the project that is slipping stands out\u003c\/li\u003e\n\u003cli\u003eOpen tasks due each week for the next two months, split by priority\u003c\/li\u003e\n\u003cli\u003eSpend against budget by project, or by cost type for one project\u003c\/li\u003e\n\u003cli\u003eTasks by status: not started, in progress, on hold and completed\u003c\/li\u003e\n\u003cli\u003eTeam workload: open tasks per person, split into overdue, due this week and later\u003c\/li\u003e\n\u003cli\u003eThe next open tasks by due date, with late ones flagged in red\u003c\/li\u003e\n\u003cli\u003eA risk matrix of open risks and issues by impact and likelihood\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eThirteen connected tabs\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003eTask Manager:\u003c\/strong\u003e 1,000 rows, the one place every other tab reads from\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eProject Charter:\u003c\/strong\u003e scope, objectives, sponsor, budget and RAG status\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eSchedule:\u003c\/strong\u003e a 120-day Gantt timeline drawn with conditional formatting, a gantt chart Excel draws without any add-in\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eKanban Board:\u003c\/strong\u003e a kanban board with four columns, fed straight from the status column\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eEisenhower Matrix:\u003c\/strong\u003e an Eisenhower matrix that sorts urgent against important automatically\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eDeliverables Tracker:\u003c\/strong\u003e 300 rows with due dates, approvers and approval dates\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eRisks and Issues Register:\u003c\/strong\u003e 250 rows with impact, likelihood, owner and treatment plan\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eResource Allocation:\u003c\/strong\u003e 200 rows of workload across your team\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eStakeholder Analysis:\u003c\/strong\u003e 200 rows scoring influence against engagement\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eBudget and Cost Tracker:\u003c\/strong\u003e 500 cost lines with budget, actual, variance, paid and left to pay\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eProject Dashboard, Setup and Start Here:\u003c\/strong\u003e the live overview, your projects, phases and owners for every dropdown, and a quick start with the color legend\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eWhat it does for you\u003c\/h2\u003e\u003cp\u003eMost templates are a project tracker with a task list and little else. Risk registers, stakeholder analysis and deliverable approvals are where projects are really controlled, and here they are built in.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eHandle multi project work: up to 100 projects and 1,000 tasks in one file\u003c\/li\u003e\n\u003cli\u003eOverdue dates turn red on their own\u003c\/li\u003e\n\u003cli\u003eColor follows status on every tab\u003c\/li\u003e\n\u003cli\u003e20 charts and 56 dropdown lists, all native and all live\u003c\/li\u003e\n\u003cli\u003eFilter any view by project, phase, owner or priority\u003c\/li\u003e\n\u003cli\u003eEvery figure is calculated, so nothing is typed twice\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eLight and dark editions\u003c\/h2\u003e\u003cp\u003eEach download has a light edition and a dark edition with every tab restyled, not only the dashboard. Both use the same formulas, and both come filled with a worked example and as a blank copy, in Excel and in Google Sheets.\u003c\/p\u003e\u003ch2\u003eWorks with\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eMicrosoft Excel 2016, 2019, 2021 and Microsoft 365, on Windows and Mac\u003c\/li\u003e\n\u003cli\u003eGoogle Sheets with a free Google account, as its own separate build tuned to stay responsive\u003c\/li\u003e\n\u003cli\u003eLibreOffice\u003c\/li\u003e\n\u003cli\u003eBuilt without dynamic arrays, spill ranges, macros or add-ins, so it behaves the same everywhere. No plugins and no subscription.\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eWhat you download\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eLight edition: the Excel workbook filled with a worked example, and a blank one\u003c\/li\u003e\n\u003cli\u003eDark edition: the same two files in the dark design\u003c\/li\u003e\n\u003cli\u003eThe instruction guide, with one-click links to the Google Sheets versions (light and dark, filled and blank)\u003c\/li\u003e\n\u003cli\u003eThe terms of use as a PDF\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003eYour files are ready the moment payment clears. Use it for personal and business work, on your own devices and with your own team, but please do not share or resell the files. Questions before or after you buy? Use our contact page and we will help.\u003c\/p\u003e\u003ch2\u003eFrequently asked questions\u003c\/h2\u003e\u003ch3\u003eDoes it work in Excel, Google Sheets or both?\u003c\/h3\u003e\u003cp\u003eBoth. You get Excel workbooks for Excel 2016 or later on Windows and Mac, and the instruction guide has one-click links to the Google Sheets versions, which are a separate build tuned to stay responsive.\u003c\/p\u003e\u003ch3\u003eHow many projects and tasks can it hold?\u003c\/h3\u003e\u003cp\u003eUp to 100 projects and 1,000 tasks in one file. The Task Manager tab is the single list that feeds everything else.\u003c\/p\u003e\u003ch3\u003eDo I have to draw the Gantt chart myself?\u003c\/h3\u003e\u003cp\u003eNo. The Schedule tab draws a 120-day Gantt timeline with conditional formatting from the dates in your tasks, and the dashboard adds a portfolio timeline for every project.\u003c\/p\u003e\u003ch3\u003eWill it work on an older Excel or on a Mac?\u003c\/h3\u003e\u003cp\u003eYes. It is built without dynamic arrays, spill ranges, macros or add-ins, so it behaves the same on Excel 2016, Excel for Mac, Microsoft 365, LibreOffice and Google Sheets.\u003c\/p\u003e\u003ch3\u003eCan my team use it?\u003c\/h3\u003e\u003cp\u003eYes. It is licensed for personal and business use with your own team. The Resource Allocation tab and the team workload panel show open tasks per person.\u003c\/p\u003e","brand":"OPXVIA","offers":[{"title":"Default Title","offer_id":67597859651678,"sku":"OPX-001","price":29.0,"currency_code":"CAD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0769\/2094\/6782\/files\/project-management-spreadsheet-01.jpg?v=1790831928","url":"https:\/\/opxviashop.com\/products\/project-management-spreadsheet","provider":"OPXVIA","version":"1.0","type":"link"}