Excel Operations Dashboard Automation

I’m consolidating several workflows into one master Excel workbook and need it built so anyone on the team can open it, enter data, and instantly see the story behind the numbers. Core workbook requirements • Structured data-entry sheets with drop-down validation to stop typos at the source. • Behind-the-scenes formulas that calculate costs, timelines, and performance metrics automatically—no manual math should be necessary. • Built-in analysis tools (pivot tables, Power Query or similar) so I can slice the data by date, service line, or team member without touching the raw sheets. Operational coverage The file must accommodate three parallel tracks: project-management tasks, client-service tracking, and inventory management. Each record should carry service type and date stamps so we can filter or chart any combination later. Interactive dashboard On a dedicated tab, I need a visually engaging dashboard featuring: • KPI summary cards for key metrics we’ll define together • Real-time updating graphs that refresh the moment new data is entered • Customisable report views controlled by slicers or drop-downs, allowing stakeholders to build their own reports without breaking the layout Quality bar & hand-off 1. Workbook delivered fully unlocked (no hidden VBA passwords) and ready for me to test with sample data. 2. Brief user guide or screencast so new staff can understand where to input data and how to refresh the dashboard. 3. Everything should stay performant even after a year’s worth of records. If you’ve built similar integrated Excel solutions—and can keep formulas tidy and the interface intuitive—let’s get started. More INFO detailed below Create an executive-level interactive operations dashboard using the uploaded Excel workbook as the DATA SOURCE and the uploaded dashboard image as the VISUAL SPECIFICATION. • IMPORTANT: The uploaded dashboard image is not general inspiration. Reproduce its visual design, proportions, hierarchy, spacing, dark theme, and overall appearance as closely as possible. Do not redesign it into your own style. • PURPOSE • This dashboard will be used by management to review UK & Europe drilling operations across a selected date range. • The dashboard must immediately answer: • Where are we operating? • How many rigs/projects are active, upcoming, or planned? • Which clients are involved? • Which services are being provided? • What is the operational timeline? • What are the main highlights, watchouts, milestones, and HSE issues? • DATA • Use the uploaded workbook as the source. • The working data should come from: • Operations Data • Map Data • Do not change the underlying operational information. • The dashboard should dynamically update from these datasets whenever possible. • OVERALL DESIGN • Reproduce the uploaded mockup. • Use a professional style executive dashboard: • Full-screen dark navy background • Dark navy/blue cards and panels • White primary text • Muted light gray/blue secondary text • Green = Active • Amber/orange = Upcoming • Blue = Planned • CRITICAL: • There must be NO white chart backgrounds. • There must be NO default Excel-style white rectangles behind charts. • There must be NO large unused white worksheet areas. • Charts should visually blend into the dark dashboard. • Keep spacing tight, balanced, clean and executive-level. • HEADER • At the top: • UK & EUROPE OPERATIONS DASHBOARD • Use a dark header -red accent line underneath. • DATE FILTER • Provide: • SELECTED START DATE • and • SELECTED END DATE • The user must be able to change the reporting period. • ALL dashboard elements should respond to the selected period wherever technically possible. • This includes: • Map • KPIs • Client analysis • Service analysis • Country analysis • Rig/project timeline • EUROPE OPERATIONS MAP • The large upper-left visual must be a geographic map of Europe. • This is extremely important. • DO NOT create a grid of country boxes. • DO NOT create square tiles representing countries. • DO NOT substitute the map with a country list. • Use a real geographic / filled map visualization. • Countries with operations during the selected period should be highlighted. • Countries without operations should remain visually subdued. • The operational countries currently include, depending on the selected period: • United Kingdom • Norway • Netherlands • Germany • Denmark • Romania • Italy • Spain • Where supported, hovering or selecting a country should expose operational information such as: • Country • Client • Rig / Asset • Well / Project • Services • Start Date • End Date • Status • The map should occupy approximately the same large near-square area shown in the uploaded mockup. • KPI CARDS • Upper-right section: • Create four professional KPI cards: • TOTAL RIGS • ACTIVE • UPCOMING • PLANNED • Calculate these dynamically from Operations Data and the selected reporting period. • Use the status colors consistently: • Active = Green • Upcoming = Amber/Orange • Planned = Blue • OPERATIONS BY CLIENT • Create a professional dark-background DONUT chart. • Title: • OPERATIONS BY CLIENT • Show the distribution of operations/rigs by client. • Do not use a white chart canvas. • Keep labels/legend compact and readable. • OPERATIONS BY SERVICE • Create a second professional dark-background DONUT chart. • Title: • OPERATIONS BY SERVICE • Use service information from Operations Data. • Examples may include MLWD, LWD, DD and other services appearing in the source data. • Again, no white chart background. • OPERATIONS BY COUNTRY • Create a compact horizontal bar chart: • OPERATIONS BY COUNTRY • Show the number of operations/rigs by country during the selected period. • Use a dark background and clean executive formatting. • RIG / PROJECT TIMELINE • The lower-middle section should be a full-width Gantt-style operational timeline. • Title: • RIG / PROJECT TIMELINE • Each row should represent a rig/project. • Show important information such as: • Country • Client • Rig / Asset •