Launch Readiness Tracker
A product launch readiness tracker with grouped task buckets. Add and delete task buttons keep the structure intact, a double-click calendar fills dates, and the Gantt chart shows planned, in-progress, delayed and completed bars.
- Industry
- Pharmaceutical Launch
- Deliverable
- Launch Readiness Tracker.xlsb
- Built with
- Excel VBA, UserForms, Conditional formatting
Before
Adding or removing tasks broke the tracker layout and dates were typed in by hand.
After
Buttons add and delete tasks without breaking the structure and a calendar fills dates for the Gantt bars.
More like this
Related projects
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
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
Project Planner & Gantt Chart
Pharmaceutical Launch
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…
View project