[email protected] +1.303.779.0344

Home Examples By Industry Manufacturing

Site Production Roadmaps from Excel with OnePager Express

This site production roadmap, planned in OnePager Express, was created from a simple Excel spreadsheet. It was designed to help a manufacturing company optimize its global production assets over a diverse and evolving line of consumer electronics products.

This site production roadmap shows allocation of manufacturing assets worldwide across a diverse line of electronics products for a fictional manufacturer.


Download Site Production Roadmap as PDF      Download Site Production Roadmap as Image


OnePager Express Site Production Roadmap Features

This site production roadmap features:

  • Collection of manufacturing activities by assembly line, which shows allocation of manufacturing assets
  • Grouping of assembly lines by manufacturing site, showing concurrent activities in each plant or division
  • Conditional formatting of each product manufacturing activity by the product category (e.g. chips, batteries, etc.)
  • Links to show movement of manufacturing activities from one plant to another as established products are outsourced overseas, and cutting-edge products are manufactured locally

This site production roadmap was created using OnePager Express, product roadmapping software from Chronicle Graphics that integrates with Microsoft Excel.

To learn more about OnePager, and see how it can help your product roadmapping activities, get started today by downloading a free trial or attending one of our demonstration webinars.

15-Day
Free Trial

Sample Files

This site production roadmap was created using the following files, which you can download in either Microsoft Project or Excel format to create something similar for your own team:

For Microsoft Project users:

For Excel users:

Instructions

To build a site production roadmap like the example above, follow these instructions:

  1. Download one of the two sets of sample files listed above. There is a Microsoft Project or Excel plan containing all of the manufacturing timelines for each site, plus a matching OnePager template for Excel or Microsoft Project that will help define the layout of the roadmap itself. Save both files to your desktop.

  2. Open the Microsoft Project or Excel file.

  3. Once the file is open, go to Add-Ins and click the OnePager button.

  4. On the OnePager start screen, click NEW to build a new Gantt chart.

  5. We need to change OnePager's default template to the one downloaded above. To do this, click on Change, and then BROWSE FILES to the OnePager template (*.tat) file. This OnePager template contains all of the data-driven formatting (styles, layout, etc.) that give this roadmap its unique look. Make sure that you use the OnePager template that matches your Microsoft Project or Excel source file.

    Template for Site Production Roadmap

  6. Once the custom OnePager template is selected, click on Create New Project View to build your project schedule. It should look identical to the example at the top of this article.
15-Day
Free Trial