{"product_id":"profit-and-loss-dashboard-python-edition","title":"Profit and Loss Dashboard – Python Edition","description":"\u003cp\u003eThe Profit and Loss Dashboard plus the Python script that builds it. Open the finished workbooks and start using them straight away, or run \u003ccode\u003ebuild_dashboard.py\u003c\/code\u003e to rebuild the whole dashboard from scratch with your own colours, sample data and labels.\u003c\/p\u003e\n\u003cp\u003e\u003cimg src=\"https:\/\/cdn.shopify.com\/s\/files\/1\/0790\/7701\/5743\/files\/profit-and-loss-dashboard-python-edition.jpg?v=1792014910\" alt=\"Profit and Loss Dashboard Python Edition: the light and dark Excel dashboards next to the build_dashboard.py script and a terminal that builds them\" width=\"2716\" height=\"1545\" style=\"width: 100%; height: auto;\"\u003e\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eWhat's in the download (one .zip):\u003c\/strong\u003e two macro-enabled .xlsm workbooks (light and dark theme), build_dashboard.py, requirements.txt and a README with step-by-step instructions.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eThe dashboard:\u003c\/strong\u003e net revenue, gross profits, debts and corporation tax at a glance, with monthly gross profit, income against expenses, CAPEX vs. OPEX and a breakdown of operating expenses for each department. Click a department on the slicer and every card and chart follows it, including a Business Info card. A full year of sample figures for three departments (Headquarter, Web Store and Branches) is filled in. The Data Entry form checks your month, then adds it to the Data table and refreshes the dashboard in one click. Each workbook has 4 sheets (Dashboard, Data Entry, Pivot, Data). Figures in USD.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eThe Python script:\u003c\/strong\u003e about 1,300 lines of readable Python that drive Excel through COM automation. In about 10 seconds it builds the Excel tables, pivot tables, slicer, cards, 6 charts, the Data Entry form and its macro. Change the THEMES palette, the sample figures, the department names or the labels, then run one command, for example \u003ccode\u003epython build_dashboard.py \"My P\u0026amp;L.xlsm\" preview.png dark\u003c\/code\u003e.\u003c\/p\u003e\n\u003cp\u003eAbout the macros: the only macro, Add entry, moves the ready row into the Data table inside the workbook and refreshes the pivots. It runs only when you click the button. 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 \u0026gt; Refresh All. The department slicer works without macros.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eRequirements:\u003c\/strong\u003e the workbooks open in desktop Microsoft Excel (Microsoft 365 or Excel 2016 and later, Windows or Mac). The Add entry 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 (\u003ccode\u003epip install pywin32\u003c\/code\u003e), 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.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eLicences:\u003c\/strong\u003e 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.\u003c\/p\u003e","brand":"Sky Dashboards","offers":[{"title":"1 ➜ Personal Use","offer_id":67669792293055,"sku":"VCD-PY-PROFIT-LOSS-P","price":79.0,"currency_code":"USD","in_stock":true},{"title":"2 ➜ Commercial Use","offer_id":67669792325823,"sku":"VCD-PY-PROFIT-LOSS-C","price":149.0,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0790\/7701\/5743\/files\/profit-and-loss-dashboard-python-edition.jpg?v=1792014910","url":"https:\/\/skydashboards.com\/products\/profit-and-loss-dashboard-python-edition","provider":"Sky Dashboards","version":"1.0","type":"link"}