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.
Ahli Perbaikan Rumah Dibutuhkan Category: Carpentry, Flooring, General Labor, Handyman, Painting, Plumbing, Roofing, Tiling Budget: $10 - $30 USD
05-Mar-2026 05:04 GMT
Instagram Social Video Editing ASAP Category: After Effects, Social Media Marketing, Video Editing, Video Production, Video Services Budget: ₹12500 - ₹37500 INR
05-Mar-2026 05:04 GMT
Doctor-Patient Consultation App Development Category: AngularJS, JavaScript, MERN Stack, MongoDB, Node.js, NoSQL Couch & Mongo, React.js, Web Development Budget: ₹1500 - ₹12500 INR
05-Mar-2026 05:03 GMT
Separate Two Icons from SVG Category: Adobe Illustrator, Graphic Design, Icon Design, Illustration, Image Processing, Photoshop, SVG, Vector Design Budget: $10 - $30 USD
05-Mar-2026 05:03 GMT
Navigation Revamp for Dune Ryte Category: Content Writing, Graphic Design, Logo Design, Photoshop, Web Design, Web Development Budget: $30 - $250 USD
Copy PDF Text into Google Category: Data Entry, Data Management, Data Processing, Excel, Google Docs, Google Sheets, PDF, Text Recognition Budget: $25 - $50 USD
05-Mar-2026 05:00 GMT
Fun Raw Footage: Advanced Editing Category: Adobe Premiere Pro, After Effects, DaVinci Resolve, Final Cut Pro, Motion Graphics, Video Editing, Video Production, Video Services Budget: ₹600 - ₹1500 INR
05-Mar-2026 04:59 GMT
Romantic Save-the-Date Video Category: After Effects, Animation, Motion Graphics, Video Ads, Video Editing, Video Post Editing, Video Services, Video Streaming Budget: ₹600 - ₹1500 INR
05-Mar-2026 04:59 GMT
Dual Destination Wedding Website Suite Category: CSS, Graphic Design, HTML, UI / User Interface, Web Design, Web Development, Weddings Budget: $250 - $750 USD
Classic Office Fitout 3D Fly-Throughs Category: 3D Animation, 3D Modelling, 3D Rendering, 3D Studio Max, 3D Visualization, After Effects, Blender, V Ray Budget: ₹600 - ₹1500 INR
05-Mar-2026 04:54 GMT
Creatives for EdTech Digital Marketing & Content Creation Category: Adobe Illustrator, Photoshop, Canva, Content Creation, Content Writing, Copywriting, Digital Marketing, Graphic Design, Social Media Marketing, Video Editing Budget: ₹100 - ₹400 INR
05-Mar-2026 04:54 GMT
Garden and Lawn Maintenance Category: 3D Rendering, Building Architecture, Gardening, General Labor, Graphic Design, Handyman, Landscaping, Lawn Mowing, Painting, Pest Control Budget: $250 - $750 AUD