Excel Contract Tracking Dashboard
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
Polygon Splitting Task
I need two shapefiles processed in ArcMap. The task involves splitting vegetation patches where they are less than 200m wide. Requirements: - Split polygons should maintain their original area - Use ArcMap for processing - Deliver two shapefiles Ideal skills: - Profic...
View JobWord Doc Data Entry -- 2
I need textual data entered from digital files. The data is currently in Word documents. Ideal skills and experience: - Proficiency in Microsoft Word - Attention to detail - Experience with data entry tasks - Ability to work efficiently and meet deadlines
View Job