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.
Full Spectrum QA Testing Category: CI / CD, Python, Regression Testing, Selenium, Software Testing, Test Automation, Test Plan Writing, Testing / QA, Website Testing Budget: ₹600 - ₹1500 INR
22-Nov-2025 11:01 GMT
PHP App Customization -- 2 Category: AI Development, Data Visualization, HTML, MySQL, PHP, Security, Web Development, WordPress Budget: $30 - $250 USD
22-Nov-2025 11:00 GMT
Data Review, Logo, Mobile Editing Category: Adobe Premiere Pro, Data Analysis, Excel, Graphic Design, Illustration, Logo Design, Photoshop, Video Editing Budget: ₹750 - ₹1250 INR
22-Nov-2025 11:00 GMT
Laravel Lead-Gen Portal Development Category: API Integration, Graphic Design, HTML, Laravel, PHP, SEO, Web Development, Web Design Budget: ₹12500 - ₹37500 INR
22-Nov-2025 10:59 GMT
NCERT Textbook Proof & Typing Category: Content Writing, Copy Typing, Data Entry, Editing, LaTeX, Microsoft Word, Proofreading, Transcription, Word Budget: ₹3500 - ₹6000 INR
22-Nov-2025 10:58 GMT
Mixed Data Entry Needed -- 2 Category: Data Analysis, Data Cleansing, Data Collection, Data Entry, Data Management, Data Processing, Database Management, Excel, Google Sheets, Web Scraping Budget: $15 - $25 USD
