hello!
I have more than 10 years of experience with Excel, creating different types of dashboards and other tools for the high management.
I understand your request, and the complication that you describe. In order to build the dashboard, however, there's some basic información I shold know (for instance, all the titles of the colums, which type of info they contain, and the criteria that needes to be reflected in the dashboard (of max capacity, etc...))
From the output I deliver you can expect:
✅ to be useful for the decision maker and easy to use (in case is a dynamic dashboard)
✅ to be aesthetically nice. visually harmonious
✅ to be automatically or easily updated.
Since the work will be done "blind", I will need you to try the tool and give me feedback during the course of the project.
That's all.
have a nice day!