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.
Strategi Penjualan Pakaian Homemade Category: Branding, Content Strategy, Digital Marketing, Fashion Design, Market Research, Marketing Strategy, Product Development, Social Media Marketing Budget: $250 - $750 USD
03-Oct-2025 10:04 GMT
Email Logo GIF Animation Category: Adobe Animate, Adobe Creative Cloud, After Effects, Animation, GIF Animation, Graphic Design, Logo Animation, Logo Design Budget: $30 - $250 AUD
03-Oct-2025 10:03 GMT
API Integration for Job Status Updates Category: API, API Integration, Construction Management, Database Management, HTML, MySQL, PHP, Software Architecture, Software Development, Web Development Budget: £3000 - £5000 GBP
03-Oct-2025 10:03 GMT
Mobile App with AI Scoring Category: Android, Flutter, Graphic Design, IPhone, Mobile App Development, React Native, SQLite, Video Streaming Budget: ₹12500 - ₹37500 INR
03-Oct-2025 10:03 GMT
Custom AdLinkFly URL Shortener Build Category: Analytics, API Development, HTML, JavaScript, PHP, UI / User Interface, User Experience Research, Web Application, Web Development, Web Design Budget: ₹1500 - ₹12500 INR
03-Oct-2025 10:02 GMT
STEM Educator (Lucknow) Category: 3D Printing, Arduino, Blog Writing, C, Programming, C++, Electronics, Mechatronics, Python, Robotics, Training Budget: ₹100 - ₹400 INR
03-Oct-2025 10:02 GMT
Search Ranking SEO Overhaul Category: Content Strategy, Digital Marketing, Internet Marketing, Keyword Research, Link Building, Marketing, SEO, Website Audit Budget: ₹1500 - ₹12500 INR
03-Oct-2025 10:02 GMT
Professional AI LinkedIn Banner -- 2 Category: Photoshop, AI Design, AI Graphic Design, Banner Design, Figma, Graphic Design, Logo Design Budget: ₹600 - ₹1500 INR
03-Oct-2025 10:02 GMT
Corporate Trainer for Maloo Group Category: Business Analysis, Business Writing, Conflict Resolution, Leadership Development, Management, Research Writing, Time Management, Training Budget: ₹12500 - ₹37500 INR
03-Oct-2025 10:01 GMT
Course Automation Platform Development Category: AngularJS, API Development, Automation, Backend Development, Frontend Development, Full Stack Development, HTML, JavaScript, Node.js, Web Development Budget: ₹37500 - ₹75000 INR
Architecture Website & Social Media Category: Content Creation, Graphic Design, HTML, PHP, SEO, Social Media Management, Web Design, Web Development Budget: ₹150000 - ₹250000 INR
03-Oct-2025 09:59 GMT
Turbocharge Client AdWords Leads Category: Conversion Rate Optimization, Digital Marketing, Google Ads, Google Adwords, Google Analytics, Internet Marketing, Keyword Research, Lead Generation, Search Engine Marketing (SEM), SEO Budget: $10 - $20 NZD
