Snapshot-Dependent Text Columns for OnePager Pro for Version 7.0
Overview
1) Certain Microsoft Project source plan fields typically change as the project progresses forward.
2) The source plan data fields that are treated as snapshot-dependent include:
- Percent Complete (%Complete)
- Duration
- Start Date
- Finish Date
- Baseline Start Date
- Baseline Finish Date
- Deadline Date
- Any field used for round-robin color assignment
- Any field used for conditional-formatting
- Any field used for endpoints
3) By snapshot-dependent we mean that the value, style, or format of an object (i.e., task bar or milestone symbol property) can change from one snapshot to another as the underlying project source plan data field changes.
4) The focus of this article is on the ten (10) categories of source plan data fields shown above.
3) When using OnePager to show these changes as they are made to the Microsoft Project source plan on a regular basis, One Pager can add snapshots to the chart using the updated data from the current source plan.
5) For a more in depth discussion of charts and snapshots, please see the article at: Understanding Charts and Snapshots for OnePager Pro 4.0.1.1-70.
6) Often it is important in schedule presentations to emphasize the some of the above data items by collecting task bars/milestone symbols into rows and identify rows using one of the above source plan fields.
7) Using the processes of updating the chart with periodic snapshots, you can show how the any of the above source plan fields change when shown in text columns accompanying rows in the chart.
8) OnePager Pro automatically updates your chart with the latest source plan field data and shows the data in the appropriate text column cells accompanying each row.
9) When this is done, the chart's text column contents and the rows continue to be associated with one of the above source plan data fields and the snapshots change to show the most current source plan field data in the chart and in the text column as successive snapshots are taken over time.
10) For more information on adding snapshots to your charts, please see the articles at: Basic Workflows (Portal) 7.0.1-70.
11) The example that follows uses the source plan %Complete field to demonstrate how text columns are used to represent changing data through the progress of a project.
12) The example illustrates how text columns represent changes in the contents of the source plan data fields listed at the beginning of this section above.
Example
1) To provide a simple illustration of the snapshot-dependency of text column contents, we construct a Microsoft Project source plan with a focus on the %Complete field column.
2) The Microsoft Project source plan below shows all the data field names mentioned in the above list plus the Task Name, Resource Names, and Flag20:
-07082020.png)
-11012017.png)
3) Note the specific %Complete data for each task bar.
4) When the OnePager Pro (OPP) is launch to create a NEW chart, you have an opportunity to select the functions of the various Microsoft Project source plandata fields as described elsewhere by examining and modifying the OnePager Choices (OPC) form.
5) The example is such that each row's text column contents, row ordering, and collection of task bars into rows are set to use the %Complete field to organize the chart.
4) When these controls are set in the Template through the Row and Swimlanes tab, the following snapshot is created:
-11012017.png)
5) In the first snapshot, the text column cells are created with the % Done data in ascending order so that the tasks with the lowest % Done task is at the top of the swimlane set of rows. The tasks/milestones is not reordered in subsequent snapshots as this would violate a basic principle of OnePager to maintain consistency of look and feel between snapshots.
6) If the project’s Microsoft Project source plan is updated, say on 6/30/2020 for this example, with the latest % Done data, that Microsoft Project source plan might look like this:
-11012017.png)
7) The updates to the %Complete data, shown above, as compared to the Microsoft Project source plan captured on 412/8/2018, shows that the project is progressing but the tasks of interest, those with a Flag20 flag of Yes.
8) If we create the snapshot on 6/30/2020, it looks like this:
-11012017.png)
9) The tasks/milestones are updated with the latest % DONE data and the new percent complete information from the Microsoft Project source plan is shown in the text column for each row. OPP does not reorder rows between snapshots but retains the row ordering originally established for the chart. The Microsoft Project source plan did not change the Finish Dates of any of the tasks to reflect their current % DONE.
Related Links
Understanding Charts and Snapshots for OnePager Pro 4.0.1.1-70
Basic Workflows (Portal) 7.0.1-70
(12.4.1-70)
