OnePager Express Project Timeline
This project timeline features:
- Swimlanes based on the delivery system so that injectables, controlled release, topicals, and orals are all grouped together in the same section.
- Assignment of unique colors to each CMC phase: clinical batch, pilot batch, engineering batch, process validation batch, commercial batch.
- All CMC activities for a given drug are lined up left-to-right in a single row, creating a timeline view of each project.
- The time axis shows a long-range drug development plan that spans almost ten years.
- The legend makes it easy to identify the same CMC activity across multiple projects.
This CMC Process Timeline was created in OnePager Express, timeline software for Excel, using data exported from Excel.
To learn more about how OnePager can help you keep track of your CMC requirements, get started today by downloading a free trial.15-Day
This CMC Process Timeline was built using the following files, which you can download if you'd like to create something similar:For Excel users:
- CMC Process Timeline.xlsx (Excel Plan)
- CMC Process Timeline (Excel).tat (OnePager Template for Excel)
To build a CMC Process Timeline like the example above, follow these instructions:
Download the sample files listed above. The Excel files contains the CMC activities themselves, and the matching OnePager template file has most of the settings that drive the look and feel of the timeline based on the data from or Excel. Save both files to your desktop.
Open the Excel plan.
Once the project plan is open, go to Add-Ins and click the OnePager button.
When the start screen appears, click NEW to build a new chart.
- Change OnePager's default template to the one downloaded above, making sure that you pick the template that matches the Excel plan that you downloaded. To do this, click on Change, and then BROWSE FILES to the OnePager template (*.tat) file. This OnePager template contains most of the data-driven formatting (colors, layout, etc.) that give this CMC Process Timeline its specific look.
With the template loaded, click on Create New Chart. It should closely match the example at the top of this article.