Difference between revisions of "Creating Another New Chart - OnePager Express Add-in for Version 7.0"
| Line 1: | Line 1: | ||
==Overview== | ==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 | + | 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) For example, '''Show IT1''' can be used to produce the OnePager chart for an executive team, while '''Show It2''' can be used as the ''' | + | :a) With OnePager, you can create different charts from the same Microsoft Excel '''source plan'''. |
| + | |||
| + | :b) 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. | ||
| + | |||
| + | 2) 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. | ||
| + | |||
| + | 3) Further, '''Show It3''' can be reserved to produce and update charts for customer. | ||
| + | |||
| + | 4) 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. | ||
==Procedures== | ==Procedures== | ||
| Line 11: | Line 19: | ||
2) Launch Microsoft Excel and bring up the desired Microsoft Excel '''source plan'''. | 2) Launch Microsoft Excel and bring up the desired Microsoft Excel '''source plan'''. | ||
| − | 3) Use any additional ''' | + | 3) Use any additional '''Flag''' fields in the Microsoft Excel '''source plan'''. |
| + | |||
| + | :a) These added '''Flag''' fields are use to determine which Microsoft Excel '''source plan''' rows to import. | ||
| + | |||
| + | :b) 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'''. | ||
4) Click the ''OnePager''' button on the Microsoft Excel tool bar. OnePager accesses the '''OnePager Express Start''' form. Click the '''NEW''' button: | 4) Click the ''OnePager''' button on the Microsoft Excel tool bar. OnePager accesses the '''OnePager Express Start''' form. Click the '''NEW''' button: | ||
| + | |||
| + | <center>[[File:X70-7_4_1-70-(1)-08072019.png]]</center> | ||
| + | <center>X70-7_4_1-70-(1)-08072019.png</center> | ||
<center>[[File:X60-7_2_1-53-(2)-09162016.png]]</center> | <center>[[File:X60-7_2_1-53-(2)-09162016.png]]</center> | ||
Revision as of 19:24, 7 August 2019
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.
- a) With OnePager, you can create different charts from the same Microsoft Excel source plan.
- b) 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.
2) 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.
3) Further, Show It3 can be reserved to produce and update charts for customer.
4) 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.
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.
- a) These added Flag fields are use to determine which Microsoft Excel source plan rows to import.
- b) 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.
4) Click the OnePager' button on the Microsoft Excel tool bar. OnePager accesses the OnePager Express Start form. Click the NEW button:
-08072019.png)
-09162016.png)
5) OnePager displays a OnePager choices (OPC) form as shown below:
-01302017.png)
6) 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. 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.
7) 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. 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 7.13.1-70
Creating a NEW Chart via Pull Operation - OnePager Express 7.13.2-70
REPLACING a Snapshot via Pull Operation - OnePager Pro 7.14.1-70
REPLACING a Snapshot via Pull Operation - OnePager Express 7.14.2-70
ADDING a Snapshot via Pull Operation - OnePager Pro 7.15.1-70
ADDING a Snapshot via Pull Operation - OnePager Express 7.15.2-70
Custom Update (Replacing) of a Snapshot via Pull Operation - OnePager Pro 7.16.1-70
Custom Update (Replacing) of a Snapshot via Pull Operation - OnePager Express 7.16.2-70
Using the OnePager "Data" Tab's "Selected file(s)" Button 7.17.1-70
(7.4.1-70)
