{"product_id":"fleet-management-excel-dashboard","title":"Fleet Management Dashboard – Excel Template","description":"\u003cp\u003eA fleet management dashboard for transport and logistics businesses, fleet managers and dispatchers. See total expenses, salaries, wages and trips at a glance, with expenses and trips by month, trip classes (close, regular and far), distance travelled, cargo types, driver and buddy income, owned fleet against hired transport and a per-driver summary.\u003c\/p\u003e\n\u003cp\u003e\u003cimg src=\"https:\/\/cdn.shopify.com\/s\/files\/1\/0790\/7701\/5743\/files\/fleet-management-dashboard-light-and-dark.jpg?v=1792073344\" alt=\"Fleet Management Excel dashboard shown in its light and dark themes, with expenses, salaries, wages, trips by month, trip classes and the fleet split\" width=\"2716\" height=\"2799\" style=\"width: 100%; height: auto;\"\u003e\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eLight and dark themes included:\u003c\/strong\u003e every licence comes with both workbooks, a clean light version and a dark version with the same features, so you can use whichever suits your screen or your brand.\u003c\/p\u003e\n\u003cp\u003eWhat's included: two macro-enabled .xlsm workbooks (light and dark), each with 5 sheets (Dashboard, Schedule, Data Entry, Pivot, Data). 24 sample trips with two drivers, their buddies and two trucks are already filled in. Pick a driver or months on the slicers and every card, chart and the Trips Schedule follow it. The Schedule lists every trip with driver, buddy, truck, route, goods and distance, highlights far trips and hired transport, and has space for dispatcher notes. The Data Entry form checks your trip, works out salaries and trip expenses, then adds it to the Data table in one click. The currency is one cell on the Data sheet (Thai baht in the sample), so you can switch it to yours. Colourway: indigo \u0026amp; white (light) and indigo \u0026amp; charcoal (dark).\u003c\/p\u003e\n\u003cp\u003eAbout the macros: the only macro, Add trip, 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? The form has a ready row you can copy and paste instead, then use Data \u0026gt; Refresh All. The driver and month slicers work without macros.\u003c\/p\u003e\n\u003cp\u003eWorks in desktop Microsoft Excel (Microsoft 365 or Excel 2016 and later, Windows or Mac). The Add trip button needs desktop Excel, as macros don't run in 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.\u003c\/p\u003e","brand":"Sky Dashboards","offers":[{"title":"1 ➜ Personal Use","offer_id":67677139959999,"sku":"VCD-FLEET-MGMT-P","price":49.0,"currency_code":"USD","in_stock":true},{"title":"2 ➜ Commercial Use","offer_id":67677139992767,"sku":"VCD-FLEET-MGMT-C","price":99.0,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0790\/7701\/5743\/files\/fleet-management-dashboard-light-and-dark.jpg?v=1792073344","url":"https:\/\/skydashboards.com\/products\/fleet-management-excel-dashboard","provider":"Sky Dashboards","version":"1.0","type":"link"}