Creating Another New Chart using Microsoft Excel Data for Version 7.1

From OnePager Documentation
Jump to: navigation, search

Introduction

Overview

1) Often, there is more than one audience that is interested in seeing a schedule presented for a project and each audience wants to see different elements of the schedule.

2) With OnePager, you can create different charts from the same Microsoft Excel source plan.

3) This is accomplished by inserting two or more Flag fields into Microsoft Excel source plan’s fields and instructing OnePager to produce additional charts using these alternative Flag fields.

4) For example, Show IT1 can be used to produce the OnePager chart for an executive team, while Show It2 can be used as the Flag for internal presentations.

5) Further, Show It3 can be reserved to produce and update charts for customer.

6) By inserting these three Flag fields into the Microsoft Excel source plan and appropriately populating the cells with "Yes” and “No", three different charts can be prepared, have snapshots added to them, and updated or replaced as needed.

Links to Add-in and Standalone Sub-Sections

This article has two major sections below. The first major section is for OnePager Express Add-in Procedures and the second major section is for OnePager Express Standalone Procedures. Please use these links to navigate to the appropriate section based on how you are using OnePager.

OnePager Express Add-in Procedures

1) The steps to accomplish this process are similar to creating a NEW chart, but differ slightly:

2) Launch Microsoft Excel and bring up the desired Microsoft Excel source plan.

3) Use any additional Flag fields in the Microsoft Excel source plan.

4) These added Flag fields are use to determine which Microsoft Excel source plan rows to import.

5) Determine which of the task/milestone rows in the Microsoft Excel source plan are to be included and set the Flag field cell to Yes leaving the remainder of the task/milestone row’s Flag field set to No.

6) Click the OnePager' button on the Microsoft Excel tool bar. OnePager accesses the OnePager Express Start form. Click the NEW button:

X70-7 4 1-70-(1)-08072019.png

7) OnePager displays a OnePager choices (OPC) form as shown below:

X70-7 4 1-70-(2-1)-08072019.png

8) When you create another chart we suggest that you give the new chart with the alternate Flag a new name that is suggestive of the different audience.

9) Each chart or .TAM file has its own unique file name and path name so to avoid confusion it is best to create unique file names when creating another chart from the same Microsoft Project source plan that uses an alternative Flag field.

10) Once satisfied with the chart name and selection of Flag field, click the Create new chart button (if you did not check the Show field mappings checkbox) or the Next> button (if you did check the Show field mappings checkbox) to create the chart.

11) OnePager imports the data from the Microsoft Excel source plan under the control of Show It2.

OnePager Express Standalone Procedures

1) The steps to accomplish this process are similar to creating a NEW chart, but differ slightly:

2) Use any additional Flag/Number fields in the Microsoft Project source plan.

3) These added Flag/Number fields are used to determine which plan rows to import into OnePager.

4) Determine which of the task/milestone rows in the plan are to be included and set the Flag/Number cell to “Yes” leaving the remainder of the task/milestone row’s Flag field set to “No.”

5) Launch OnePager from the desktop icon.

6) The OnePager splash page appears briefly followed by the OnePager Chart Editor form displaying the OnePager Express Start form as shown below:

X70-7 2 2-70-(2)-08062019.png

7) At the completion of step 3) when you click the NEW button, OnePager displays an abbreviated OnePager choices (OPC) form as shown below:

X70-7 2 2-70-(4)-08062019.png

8) After you've made your source file selections, OnePager displays an expanded OPC form as shown below:

X70-7 4 1-70-(2-1)-08072019.png

9) When you create another chart we suggest that you give the new chart with the alternate Flag a new name that is suggestive of the different audience.

10) Each chart or .TAM file has its own unique file name and path name so to avoid confusion it is best to create unique file names when creating another chart from the same Microsoft Express source plan that uses an alternative Flag field.

11) Once satisfied with the chart name and selection of Flag field, click the Create new chart button (if you did not check the Show field mappings checkbox) or the Next> button (if you did check the Show field mappings checkbox) to create the chart.

12) OnePager imports the data from the Microsoft Excel source plan under the control of Show It2.

Related Links

Creating a NEW Chart via Pull Operation - OnePager Pro

Creating a NEW Chart via Pull Operation - OnePager Express

REPLACING a Snapshot via Pull Operation - OnePager Pro

REPLACING a Snapshot via Pull Operation - OnePager Express

ADDING a Snapshot via Pull Operation - OnePager Pro

ADDING a Snapshot via Pull Operation - OnePager Express

Custom Update (Replacing) of a Snapshot via Pull Operation - OnePager Pro

Custom Update (Replacing) of a Snapshot via Pull Operation - OnePager Express

Using the OnePager "Data" Tab's "Selected file(s)" Button

(7.4.1-71, 7.4.2-71)