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.
Christian Tamil Music Lyric Video Creation Category: Adobe Premiere Pro, After Effects, Animation, Commercials, Motion Graphics, Typography, Video Editing, Video Production Budget: ₹600 - ₹1500 INR
29-Dec-2025 17:04 GMT
Urban Full-Service Carwash Concept Category: AutoCAD, Building Architecture, Business Consulting, CAD / CAM, Financial Analysis, Home Design, Market Research, Operations Management Budget: $30 - $250 USD
29-Dec-2025 17:03 GMT
Weight Loss Transformation Reel Category: Adobe Premiere Pro, After Effects, Animation, Audio Editing, Audio Services, Video Editing, Video Post Editing, Video Production, Video Services, Videography Budget: $250 - $750 USD
Web-based Delivery Company Management System Category: API Development, Database Management, HTML, MySQL, PHP, Project Management, Web Development, Web Design Budget: $250 - $750 USD
29-Dec-2025 17:01 GMT
LinkedIn Network Growth Plan -- 2 Category: Article Writing, Content Strategy, Content Writing, Event Management, Leadership Development, Research Writing, Social Media Management, Technical Writing Budget: $15 - $25 USD
29-Dec-2025 17:00 GMT
Technical SEO Specialist Needed Category: Analytics, Internet Marketing, Link Building, PHP, SEO, Web Development, Web Security, Website Optimization Budget: €8 - €30 EUR
29-Dec-2025 17:00 GMT
Humorous Podcast Logo Caricature Category: Caricature & Cartoons, Creative Design, Digital Art, Graphic Design, Illustration, Logo Design, Vector Design, Visual Arts Budget: $30 - $250 USD
Fintech Shopify Platform Build Category: API Integration, HTML, JavaScript, Payment Processing, PHP, Security, Shopify, UI / User Interface, Web Development, Web Design Budget: £20 - £250 GBP
29-Dec-2025 16:57 GMT
Outbound Calling - Human Pickup Verification Category: Customer Service, Data Entry, Data Management, Google Sheets, Lead Generation, Phone Support, Telemarketing, Time Management, Virtual Assistant, VoIP Budget: ₹100 - ₹400 INR
