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.
App Marketplace con Comisión 2 % Category: Android, App Design, Encryption, Flutter, IPhone, Mobile App Development, Payment Gateway Integration, PHP, React Native, Web Security Budget: $30 - $250 USD
31-Jan-2026 23:03 GMT
Medication Market Share Spreadsheet Category: Data Analysis, Data Collection, Data Entry, Data Management, Data Processing, Data Visualization, Excel, Word Budget: $250 - $750 USD
Daily Thought Creator Category: Article Writing, Blog Writing, Content Creation, Content Writing, Creative Writing, Ghostwriting, Research Writing, Writing Budget: £20 - £250 GBP
31-Jan-2026 22:53 GMT
Blender Landscape Walkway Visualization -- 3 Category: 3D Animation, 3D Design, 3D Modelling, 3D Rendering, 3D Visualization, 3ds Max, Architectural Visualization, Blender Budget: $15 - $25 USD
31-Jan-2026 22:52 GMT
Air Brakes Class Syllabus Development Category: Article Writing, Content Writing, Copywriting, Education & Tutoring, Ghostwriting, Instructional Design, Training, Training Development Budget: $250 - $750 USD