Excel Contract Tracking Dashboard

$52.00

I need a simple, functional Excel dashboard to track contracts. Requirements: - Replicate the attached image layout. - Sections: Contract Count, Open Tasks, Pending/Expiring Contracts, Contract Amount vs Budget (Bar Chart), Donut Charts (Status, Type, Department), Contract Table (Title, Number, Vendor, Start Date, End Date, Value, Status, Notes). Formulas: - Auto-calculate: Remaining days (DATEDIF, TODAY), Expiry alerts (IF), Value usage. - Conditional formatting for deadlines/status. Interactivity: - Drop-downs and filters. - Clickable notes/links. Visuals Add-Ons: - Required: Contract Remaining Period graph, Value Consumption Rate graph. - Add more if helpful. Design: - Basic formatting (junior-style). - Editable inputs, protected formulas. - Easy to update/expand. Deliverables: -...

Keyword: Data Processing

Delivery Time: 3 days left days

Price: $52.0

Contracts Data Analysis Data Processing Excel Visual Basic

I want to apply

Excel Data Layout Reorganization

I need an Excel worksheet modified to reorganize columns and rows based on a specific order I will provide. Ideal Skills and Experience: - Proficient in Excel - Experience with data layout modification - Attention to detail - Ability to follow specific instructions P...

View Job

Upstox API Live Data Excel Integration

I need a solution to fetch live tick-by-tick data using the Upstox API and display it in Excel. The data should automatically update. Requirements: - Input selection from Excel for indices or stocks (Nifty 50, Sensex, Bank Nifty, and various stocks). - Expiry date filt...

View Job

Android and web system development

DESCRIPTION We are looking for an engineer with a diversified background to help us develop both a native Android application and a set of web applications. This is a long-term project, with a monthly retainer and averaging 40 hours of work a week. Duration 9-12 months ...

View Job