Project Planner & Gantt Chart
A launch plan with more than a hundred tasks. Tasks, owners, priorities and dates are entered in the planner and the Gantt chart, progress counters and status colours update automatically.
- Industry
- Pharmaceutical Launch
- Deliverable
- Project Planner Gantt.xlsb
- Built with
- Excel VBA, Conditional formatting, UserForms
Before
More than a hundred launch tasks were tracked in a static list.
After
Tasks, owners and dates drive the Gantt chart, progress counters and status colours automatically.
More like this
Related projects
Luggage Transport Booking System
Travel & Tourism
Built for a hiking tour operator. Each booking is entered once with its stretches, dates and luggage count, and the system distributes it to every supplier…
View project
Team Resource Planner
IT / Project Management
A weekly capacity planner for a team. Members and tasks are added through forms, hours are planned week by week and the planner shows available FTE,…
View project
Baseball Roster & Lineup Generator
Sports
Creates fair fielding lineups for a youth baseball team. Positions are randomised inning by inning while the equalizer rules make sure every player sits, catches and…
View project