We have two Excel workbooks that are attached containing financial and cost centre data. The reports need enhancements to improve their usability, automation, and dynamic visualisation. Below are the specific tasks:
1. Dynamic Date Selection:
a) Add "From" and "To" date pickers or dropdowns in each workbook.
b) Configure the worksheets to dynamically filter data based on the selected date range.
2. Automated Calculations:
Ensure all calculations in the sheets are automated, including totals for invoices and cost centres when new rows (invoices) or columns (cost centres) are added.
3. Dynamic Graph Updates:
Configure the existing graphs to automatically adjust and update as new data (rows or columns) are added.
4. Future-Proof Design:
As mentioned above, the reports will have additional rows for invoices and new columns for cost centres added over time. Ensure that all calculations, summaries, and visualisations incorporate these updates automatically without manual intervention.
Video Looping and Transparency -- 2 Category: After Effects, Final Cut Pro, Video Editing, Video Post Editing, Video Processing, Video Production, Video Services Budget: $30 - $250 USD
25-Aug-2025 21:48 GMT
Video Looping and Transparency Category: After Effects, Final Cut Pro, Video Editing, Video Post Editing, Video Processing, Video Production, Video Services Budget: $30 - $250 USD
Email Campaigns for Service Sales Category: Analytics, Content Creation, Copywriting, Email Campaign, Email Marketing, Google Adwords, Internet Marketing, Marketing, Marketing Strategy, Visual Design Budget: $15 - $25 USD
25-Aug-2025 21:45 GMT
Professional Recreation of Approved Logo Category: Adobe Illustrator, Photoshop, Digital Design, Graphic Design, Illustration, Logo Design, Print Design Budget: ₹600 - ₹1500 INR
25-Aug-2025 21:45 GMT
WHMCS Hooks Development Category: API Integration, Automation, HTML, MySQL, PHP, Software Development, Web Development, WHMCS Budget: $250 - $750 USD
25-Aug-2025 21:45 GMT
Enhance Existing PWA Design Category: CSS, Frontend Development, HTML, JavaScript, PHP, Web Design, Web Development Budget: $30 - $250 USD
25-Aug-2025 21:45 GMT
Fix Zapier-JudgeMe Google Reviews Category: API Integration, Automation, Google APIs, Google Chrome, JavaScript, PHP, Software Architecture, Zapier Budget: $15 - $25 AUD
25-Aug-2025 21:45 GMT
Diverse Clothing Brand Development Category: Fashion Design, Graphic Design, Logo Design, Photoshop, Product Design, Product Development Budget: ₹12500 - ₹37500 INR
