Project Control Dashboard – Python Edition

  • Project Control Dashboard Python Edition: the light and dark Excel dashboards next to the build_project_control_dashboard.py script and a terminal that builds them
  • Light theme of the Project Control Excel dashboard in violet and white, showing projects value, working hours, FTE saving, filters, project details, status, type, priorities and a milestone pipeline
  • Dark theme of the Project Control Excel dashboard in violet and navy, showing projects value, working hours, FTE saving, filters, project details, status, type, priorities and a milestone pipeline
  • Data Entry form in the Project Control Excel dashboard, with required-field, name, date and figure checks and a one-click Add project button
$79.00 USD
$79.00 USD
Sale Sold out
Tax included. Shipping calculated at checkout.
Choose your licence
DescriptionFAQs

The Project Control Dashboard plus the Python script that builds it. Open the finished workbooks and start tracking your projects straight away, or run build_project_control_dashboard.py to rebuild the whole dashboard from scratch with your own colours, lists and sample data.

Project Control Dashboard Python Edition: the light and dark Excel dashboards next to the build_project_control_dashboard.py script and a terminal that builds them

What's in the download (one .zip): two macro-enabled .xlsm workbooks (light and dark theme), build_project_control_dashboard.py, requirements.txt and a README with step-by-step instructions.

The dashboard: projects value, total projects, working hours, FTE saving and developers across the top. Filter by year, month and project manager, and every card follows: projects by status (Completed, On Going, On Hold, Cancelled), projects by type, priorities, active vs. not active, a milestone pipeline from intake to deployment, projects per developer and a By Manager table with portfolio averages. Pick a project in the Projects list to see its dates, people, milestone, hours, FTE saving, value and manager comments, with a status badge that changes colour. 72 sample projects (2023 to 2025) are filled in. The Data Entry form checks the required fields, the name, the dates and the figures, then adds the project to the Data table in one click. Each workbook has 4 sheets (Dashboard, Data Entry, Pivot, Data).

The Python script: about 1,800 lines of readable Python that drive Excel through COM automation. In about 15 seconds it builds the Excel table, 9 pivot tables, 4 slicers, the cards, 4 charts, the Data Entry form and its macros. Change the THEMES palette, the project types, priorities, milestones and people lists, or the generated sample data, then run one command, for example python build_project_control_dashboard.py "My Projects.xlsm" preview.png dark.

About the macros: Add project moves the ready row into the Data table inside the workbook, refreshes the pivots and stamps the Last updated date, and a small routine recolours the status badge on the Project Details card. They run only inside the workbook. Click Enable Content when Excel asks; if Excel shows a red Security Risk bar, close the file, right-click it, choose Properties, tick Unblock and reopen. Prefer no macros? Copy the form's ready row instead, then use Data > Refresh All. The filters work without macros.

Requirements: the workbooks open in desktop Microsoft Excel (Microsoft 365 or Excel 2016 and later, Windows or Mac). The Add project button needs desktop Excel, as macros don't run in Excel for the web. The script needs Windows with desktop Excel, Python 3.8 or later and pywin32 (pip install pywin32), and Excel's "Trust access to the VBA project object model" setting turned on while you build. It doesn't run on macOS, Linux or Excel for the web. Instant digital download, nothing is shipped.

Licences: 1 ➜ Personal Use for one person, for your own business or hobby. 2 ➜ Commercial Use for a business or organisation of any size, including client work by consultants and agencies. Every licence covers the workbooks, the script and the workbooks you build with it. You may change the script for your own use, but not resell or share it.

Frequently asked questions

What do I get when I buy a template?

A download link for the Excel workbook, sent as soon as checkout completes. Each template is a finished dashboard page plus a Data sheet loaded with sample data, so you can see how it works before you add your own numbers.

Which licence do I need?

1 ➜ Personal Use for one person, for your own business or hobby.

2 ➜ Commercial Use for a business or organisation of any size, including client work by consultants and agencies.

Which version of Excel do I need?

Templates work in Microsoft 365 and in Excel 2016 or later. Nothing extra needs to be installed: the dashboards are built with native Excel charts, pivot tables and slicers, no add-ins.

How do I put my own numbers in?

Swap your data into the Data sheet, keeping the column headers as they are. Pivot-driven templates update when you refresh (Data > Refresh All); formula-driven ones update on their own.

Do you build custom dashboards?

Yes. There are three packages: Starter, Interactive and Automated, all quoted on request. Get in touch with the data you have and the questions the dashboard needs to answer.