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.
Build My Portfolio Website Category: Content Writing, CSS, Data Entry, Excel, HTML, JavaScript, PHP, SEO, Web Design, Web Development Budget: ₹1250 - ₹2500 INR
Google Script CRM Automation Category: Automation, CRM, Data Entry, Google App Engine, Google Cloud Platform, Google Sheets, PHP, Software Architecture Budget: $25 - $50 USD
26 Dec 2025 04:58 GMT
Part-Time Product Design Collaboration⁴ Category: 3D CAD, 3D Modelling, Adobe Illustrator, Photoshop, CAD / CAM, DFM (Design For Manufacturing), Fusion 360, Illustration, Product Design, Solidworks Budget: $15 - $25 USD
26 Dec 2025 04:57 GMT
UI.Vision ile Sohbet Otomasyonu Category: Automation, Chatbot, CSS, HTML, JavaScript, PHP, Selenium, Web Scraping Budget: $20 - $100 USD
26 Dec 2025 04:57 GMT
NovaCore Visual Identity Refresh Category: Business Management, Content Writing, Contracts, Drafting, Editing, Graphic Design, Invoicing, Logo Design, Proposal Writing, Research Budget: ₹12500 - ₹37500 INR
Full-Stack AI Developer for SaaS MVP Category: AI Chatbot Development, AI Content Creation, AI Model Development, Azure, Django, Git, Node.js, Python Budget: ₹12500 - ₹37500 INR
26 Dec 2025 04:55 GMT
Covert Privacy App Development Category: Android, Android App Development, App Design, Encryption, IOS Development, IPad, IPhone, Mobile App Development Budget: $250 - $750 NZD
26 Dec 2025 04:51 GMT
Complete Zoho One CRM Integration Category: API Integration, Electronic Forms, Flow, Process Automation, Zoho Creator, Zoho CRM Budget: $10 - $30 AUD
