{"product_id":"multi-project-tracker-portfolio-dashboard","title":"Multi Project Tracker and Portfolio Dashboard","description":"\u003cp\u003eThis multi project tracker puts every project on one row and shows whether it is truly ahead or behind. It is for project and program managers who run several projects at once and need to know which one to walk into on Monday morning.\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 portfolio view\u003c\/h2\u003e\u003cp\u003eA project that is 40% done a third of the way through is ahead. One that is 40% done four fifths of the way through is not, and a progress bar alone cannot tell them apart. The Portfolio tab compares how much of the work is done with how much of the calendar has gone, and that gap turns a project amber before anyone has to admit it is slipping.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eEvery project on one row, with ahead or behind calculated\u003c\/li\u003e\n\u003cli\u003eFive status states driven by the numbers, not by how the week felt\u003c\/li\u003e\n\u003cli\u003eDelivery budget and annual operating impact for each project, with totals across the portfolio\u003c\/li\u003e\n\u003cli\u003eThe demo holds eight projects, 72 tasks and 478,000 of delivery budget, with exactly one project at risk, named, and the number that says why\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eThe full project engine underneath\u003c\/h2\u003e\u003cp\u003eBehind the project portfolio dashboard sits a complete project management workbook. Everything reads one task list and one charter, so nothing is typed twice or moved from one tab to another.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eA charter and a task register with room for 1,000 tasks and 100 projects\u003c\/li\u003e\n\u003cli\u003eA real Gantt chart drawn from your own start and end dates\u003c\/li\u003e\n\u003cli\u003eA Kanban board and an Eisenhower matrix over the same task list\u003c\/li\u003e\n\u003cli\u003eDeliverables, a risk register for risks and issues, resources, stakeholders and costs\u003c\/li\u003e\n\u003cli\u003eA single-project dashboard with a picker at the top\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eCalculated, not typed\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eEvery percentage, count, day and total is calculated for you\u003c\/li\u003e\n\u003cli\u003eCharts redraw from your own numbers, not static pictures\u003c\/li\u003e\n\u003cli\u003eFourteen connected tabs, with a Start Here tab that walks you through setup in a few minutes\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eFilled in from the start\u003c\/h2\u003e\u003cp\u003eThe filled copy opens with eight projects and 72 tasks already running, so the portfolio view is populated the moment you open it and you can see how each status is reached. The blank copy is ready for your own projects.\u003c\/p\u003e\u003ch2\u003eWorks with\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eMicrosoft Excel 2016 or later, on Windows or Mac\u003c\/li\u003e\n\u003cli\u003eGoogle Sheets with a free Google account. The Google Sheets version is a real workbook, not a PDF with a link in it.\u003c\/li\u003e\n\u003cli\u003eNo dynamic arrays, no macros and no add-ins, so it behaves the same on Excel 2016, 2019, 2021 and Microsoft 365 and in LibreOffice. No Microsoft 365 subscription is required.\u003c\/li\u003e\n\u003cli\u003eNo subscription\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eWhat you download\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eTwo Excel files: one with eight projects and 72 tasks already running, and a blank one\u003c\/li\u003e\n\u003cli\u003eThe instruction guide, which has one-click links to the Google Sheets versions (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 to download as soon as payment clears. 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 or Google Sheets?\u003c\/h3\u003e\u003cp\u003eBoth. The Excel files run on Excel 2016 or later on Windows or Mac, and the instruction guide has one-click links to the Google Sheets versions for a free Google account.\u003c\/p\u003e\u003ch3\u003eHow does it decide whether a project is on track?\u003c\/h3\u003e\u003cp\u003eIt compares the share of work done with the share of the schedule that has passed. The gap between the two drives one of five status states.\u003c\/p\u003e\u003ch3\u003eHow many projects and tasks can it hold?\u003c\/h3\u003e\u003cp\u003eUp to 100 projects and 1,000 tasks, all in one task list.\u003c\/p\u003e\u003ch3\u003eIs there a Gantt chart?\u003c\/h3\u003e\u003cp\u003eYes. A real Gantt is drawn from your own start and end dates, and the same tasks also feed a Kanban board and an Eisenhower matrix.\u003c\/p\u003e\u003ch3\u003eCan I see a single project in detail?\u003c\/h3\u003e\u003cp\u003eYes. The dashboard has a project picker at the top, and the charter, deliverables, risks, resources and costs sit in their own tabs.\u003c\/p\u003e","brand":"OPXVIA","offers":[{"title":"Default Title","offer_id":67597864534110,"sku":"OPX-083","price":29.0,"currency_code":"CAD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0769\/2094\/6782\/files\/multi-project-tracker-portfolio-dashboard-01.jpg?v=1790832402","url":"https:\/\/opxviashop.com\/products\/multi-project-tracker-portfolio-dashboard","provider":"OPXVIA","version":"1.0","type":"link"}