I have an excel sheet which I want to develop into a well designed, visually appealing dashboard.
The sheet takes 5 numbers per day to be input - these cannot be extracted so require a manual input. Cash, Card, Dept A, Dept B and Dept C.
There are fields for number of staff hours at rate A, B and C per day, which is input per week - or populated from the previous week if no change.
There are also fields for a monthly input of rent value, utilities, other costs, which are divided by the number of days in the month.
The data is displayed in a table showing +/- on the previous week, and the true value of profit of Dept B and everything else by day. The days are summarized for the week. A seperate table shows the average of year to date and last 4 weeks of the daily percentages as part of a 100% week.
The weekly takings is also shown in a graph, compared to previous years.
At present it's clunky, unappealing. It needs updating and a visually appealing dashboard created which takes no maintenance other than the daily sales input and monthly costs change.
YouTube Product Review Video Category: Content Creation, Video Ads, Video Editing, Video Post Editing, Video Production, Video Services, Video Streaming, Videography Budget: $250 - $750 AUD
23-Oct-2025 22:04 GMT
Modern Home Interior 3D Visualization Category: 3D Animation, 3D Modelling, 3D Rendering, 3D Studio Max, 3D Visualization, 3ds Max, Blender, Interior Design Budget: £20 - £250 GBP
23-Oct-2025 22:02 GMT
Steering System Go-to-Market Consulting Category: Business Consulting, Business Development, Consulting, Data Analysis, Logistics, Market Research, Marketing Strategy, Product Development, Project Management, Supplier Sourcing Budget: £250 - £750 GBP
23-Oct-2025 22:00 GMT
Veteran Story Interview Series Category: Audio Services, Video Conferencing, Video Editing, Video Hardware, Video Production, Video Services, Video Streaming Budget: $3000 - $5000 USD
23-Oct-2025 22:00 GMT
Swiss Business Lead Generation Category: Business Analysis, Data Entry, Excel, Lead Generation, Leads, Market Research, Sales, Web Search Budget: $30 - $250 USD
Ongoing STEP/CAD File Refresh and Minor Modification Category: 2D Drafting, 3D CAD, 3D Design, AutoCAD, Autodesk, Industrial Design, Industrial Engineering, Machinery, Mechanical Design, Solidworks Budget: $8 - $15 CAD
23-Oct-2025 21:58 GMT
PDF Creation with Pictures Category: Data Entry, Graphic Design, Image Processing, PDF, Photoshop, Project Management, Technical Writing, Visual Design Budget: $10 - $30 USD
23-Oct-2025 21:57 GMT
Google Sheets INDEX-MATCH Setup Category: Data Analysis, Data Management, Data Processing, Data Visualization, Excel, Google Sheets, Visual Basic Budget: $15 - $25 USD
ROK Assurances Campaign Category: Facebook Marketing, Graphic Design, Internet Marketing, Logo Design, Social Media Marketing Budget: $15 - $25 CAD
23-Oct-2025 21:48 GMT
Protein Phylogenetic Tree Construction Category: Bioinformatics, Computational Analysis, Data Analysis, Infographic And Powerpoint Slide Designing, PDF, Software Documentation Budget: $30 - $250 AUD
23-Oct-2025 21:47 GMT
SharePoint Task Automation with Power Tools Category: .NET, ASP.NET, C#, Programming, Data Visualization, Power Automate, Power BI, Project Management, Sharepoint Budget: $25 - $70 USD
