Getting Started with OnePager Express Version 5.3 Desktop

From OnePager Documentation
Jump to: navigation, search

Overview

As mentioned in the article What's New with OnePager Release 5.3? version 5.3 of OPX can be launched from a desktop icon as well as from within Microsoft Excel.

This article covers the Getting Started process when you launch OPX the desktop.

The article which provides Getting Started guidance when launching OPX from Microsoft Excel is at Getting Started with OnePager Express Add-in.

Launching OnePager Express for the First Time from the Desktop

1) OPX version 5.3 may be installed so that it can be launched either from Microsoft Excel’s Add-in tab on its tool bar or from a desktop icon or both. Additionally, you may also locate and double-click a .TAM file to bring up the desktop OPX version 5.3.

2) The desktop icon for launching OPX version 5.3 looks like this:

X53-3 0 4-53-(1)-11222015.png

3) Before you launch OPX, however, you must have certain scheduling columns in your Microsoft Excel spreadsheet. There is a lot of flexibility in how these columns can be named. A typical example is shown below. The only mandatory columns are columns representing Start, Finish, and Name. In this example, however, we are also including three optional columns:

a) A category column (Category) that we will use to assign colors to tasks.
b) A selection column (Show It) that we will use to choose which tasks to graph.
c) A Task ID field that OnePager will use to keep track of tasks/milestones as your Microsoft Excel plan is change through additions or deletions over the course of the project.
X53-3 0 3-53-(2)-11092015.png

4) To control which tasks get graphed, you must specify a flag column (e.g. Show It) that you wish to use. Numeric fields may also be used the same as the text fields where a 1 in a Number field indicates Yes and a 0 in a Number field indicates No. See how this is done in the illustration above.

a) When making your first project view, we strongly recommend that you mark 50 or fewer tasks with Yes.
b) Please note that OPX is shipped with a number of fully populated templates that are based on the Microsoft Excel file used in the tutorial also shipped with the product – BlueGrass Project 2J-303.

5) The following table describes column-heading types that OPX uses and shows variations on the heading titles that OnePager recognizes.

a) It is not mandatory that you used these column names, since OPX gives you a chance to choose the actual Microsoft Excel plan columns that it will employ. However, using these names will speed things up because it will help OPX make reasonable guesses on which columns to use as its default selections.
b) Note that it shows that three of the column heading types must always be present: Name, Start, and Finish.
c) We recommend the inclusion of an ID field with sequential numbering from top to bottom. This assists OnePager maintain a correspondence with Microsoft Excel’s rows after the Microsoft Excel plan is updated.
X53-3 0 3-53-(3)-11092015.png

6) Clicking the OnePager Express button on the desktop will first display a splash page and then take you to the Project View Editor (PVE).

X53-3 0 4-53-(2A)-11222015.png


X53-3 0 4-53-(3)-11222015.png

7) The OnePager Express Start form provides you with three options:

a) NEW Clicking the NEW button will bring up the OnePager choices (OPC) form.
b) UPDATE Clicking the UPDATE button will allow you to BROWSE FILES for an existing project view file or select a recently-opened project view file.
c) OPEN Clicking the OPEN button will allow you to BROWSE FILES for an existing project view file or select a recently-opened project view file. Once selected and opened, the project view is available for editing.

Creating a New Project View

8) Clicking the NEW button brings up the OPC form as shown below:

X53-3 0 4-53-(4)-11222015.png

Options on the New OnePager Choices form

9) We’ve enhanced the OPC form to give you more options for selecting source files.

a) Clicking the Select... button displays a dropdown menu with a BROWSE FILES... option as well as a list of recently accessed Microsoft Excel source files as shown here:
X53-3 0 4-53-(5)-11222015.png
b) When you click the Select... option, a Windows Open form appears from which you can select the desired Microsoft Excel source file:
X53-3 0 4-53-(6)-11222015.png
c) When you select the Microsoft Excel source file and click the Open button on the Windows Open form, OPX loads the Microsoft Excel source file and expands the “OPC form as shown below:
X53-3 0 4-53-(7)-11222015.png

10) At this point you have additional options with respect to the expanded of the OPC form. The Add/Remove button gives you the capability to add more files to the source packet or, for multiple file, to remove files.

a) Clicking the Add/Remove button brings up the Data source selection form as shown below:
X53-3 0 3-53-(6)-02122016.png
b) The Data source selection form displays the current source file that was loaded with Microsoft Excel when you clicked the OnePager Express... button. This form lets you Add more source Microsoft Excel source files to create a multi-project project view or Remove a file from a multi-file source packet. These options are detailed below.

Adding a New Source File

c) Add a new source file to the source packet When you click the Add button, OPX will give you the option to bring up a Windows Open form when you select the BROWSE FILES… option as shown here:
X53-3 0 3-53-(7)-02122016.png
i) Clicking the BROWSE FILES… option will display a Window’s Open from which you may select a Microsoft Excel file to add to the source packet. A sample Open form is shown below:
X53-3 0 3-53-(8)-11222015.png
ii) When you select a desired Microsoft Excel source file and click the Open button as shown above, OPX will add the file to the source packet and display it in the Data source selection window as shown below:
X53-3 0 3-53-(9)-02122016.png
iii) The selected file is added to the source packet as shown above. OPX shows the path name of the files in the window if you hover the mouse over the file name.
iv) If you select a recently used file from the dropdown menu displayed with the Add button is clicked in the Data source selection form, OPX will add that file to the source packet.

Removing a Source File

d) Remove source from source packet The Remove button allows you to remove a source file from a source packet. if that file is not needed to create the new project view. To remove a file, first select the file in the Data source selection form’s window so that it is highlighted in blue then click the Remove button as shown in the sequence below:
X53-3 0 3-53-(10)-02122016.png


X53-3 0 3-53-(11)-02122016.png

Other Choices to Make

11) Moving on to the other groups of the OPC form asks you to confirm a few things before you build the project view. It will make good guesses for each of these choices, but you can change any of them:

X53-3 0 3-53-(14)-11222015.png
a) Starting Template The current template determines which columns get imported from Microsoft Excel and how the initial project view looks. OPX ships with many sample templates, but you can also customize your own templates.
i) To choose which template to use in building your project view, click the Change… button in the top group of the OPC form.
ii) For now, just stick with the default template entitled Single Project Gantt View – Detailed, but you can always use a different template to get a different type of project view.
b) Title of the New Project View This is the title of the graph and also the suggested file name in which it will be saved. You can change the file name when you save it. We recommend that you enter a title that helps you identify the view later on.
i) For each project view that you create, OnePager remembers colors, titles, legends, font sizes, and all other graph properties so that your work is saved for future use.
ii) Later, you can update the project view with a snapshot of how the project looks on a different date. Then you can browse through the snapshots to see how the project is changing over time.
iii) OPX version 5.3 also saves the path name associated with the file (.TAM). Path names are not available in .TAM files produced with previous version of OPX.
c) Task Selection This is how you tell OPX which tasks from your Microsoft Excel plan to include. Either click the Select all tasks radio button to graph everything or choose a flag column. You can make several project views from a single Microsoft Excel plan, each using a different flag or number column. In OPX version 5.3 if no flags are set to Yes, OPX will provide the user with a warning message.
d) Snapshot Date: This is the date of the report and lets you keep track of how schedules change over time. Each project view can have several snapshots.

12) Since the Show column mappings checkbox near the bottom of the form is checked in the OPC form above, you now have a chance to review and change the Microsoft Excel column mappings to OPX before you make your first project view. To do this, click the Next> button. You will now see the following screen:

X53-3 0 3-53-(15)-11222015.png

13) Notice in the graphic above that OPX has relied on the current template to make some guesses on what Microsoft Excel columns should be used in making the graph. You can easily change any of these column mappings by making selections from the dropdown menus. For example, we show below how to change the Finish Date:

X53-3 0 3-53-(16)-11222015.png

Making the Graph

14) Once you are satisfied with the column mappings, click on Create new project view button to import your selected data and create a project view. After a very few moments you will see a screen that looks like this:

X53-3 0 3-53-(17)-11092015.png

15) Note that each task or milestone was color coded based on the value in the Category column.

a) The legend contains an optional diagram near the bottom, explaining that the bars inside the Gantt bars represent percent complete extracted from Microsoft Excel.
b) Percent complete comes from a Microsoft Excel column that you specified in the column mapping screen.
c) Note that the current template, when you press the Create new project view button, is the template for how things look in the new project view. The template’s Task Bars tab showing where the color control is located is shown below:
X53-3 0 3-53-(18)-11222015.png

Opening a Project View

16) The right-most button on the OPC form is the OPEN button. Clicking the OPEN button displays a dropdown menu which happens to be the same for the NEW and UPDATE buttons. The options in the dropdown are discussed below:

X53-3 0 3-53-(17E)-11222015.png
a) Clicking the BROWSE FILES... option will bring up a Windows Open form from which you can select a .TAM file that you want to open. Selecting the desired .TAM file will cause OPX to display the selected project view. From this position, you may edit the project view, save it, or share it with others.
b) Clicking any of the RECENT project view items in the dropdown menu above will cause OPX to load the associated .TAM file into the PVE where you may also edit the project view, save it, or share it with others.

Updating a Project View with Changes Made to the Microsoft Excel Source File Data

17) Suppose after examining the project view you created before you realize that it would be best to show more task bars. This, you think, would greatly improve the schedule discussion you are about to attend. Updating the project view at this point is a simple matter. Recall that OPX is active and the PVE is displaying the current project view you want to update. Additionally, the Microsoft Excel source file and the application are active. The original project view looked like this:

X53-3 0 3-53-(17)-11092015.png
a) Since Microsoft Excel is still an active program and the Microsoft Excel source file you are using is still being displayed, go back to the Microsoft Excel application and change the Show It column setting for the rows you want to now display from No to Yes. As section of the Microsoft Excel source file where this is done is shown below:
X53-3 0 3-53-(17A)-11092015.png
b) Once you’ve made the Show It column changes lines 7 through 15 in the Microsoft Excel the source file will look like this:
X53-3 0 3-53-(17B)-11092015.png
c) With the Microsoft Excel source file updated, go back to OPX and navigate to the Data tab on the ribbon where you’ll see several buttons. To update your project view to now show the additional rows from your Microsoft Excel source file click the Replace Snapshot button as shown below:
X53-3 0 3-53-(17C)-11092015.png
d) When you click the Replace Snapshot button, OPX will go back to the associated Microsoft Excel source file that you just changed, bring in all the rows that changed, and update your project view.
e) At the conclusion of the operation, the updated project view will look like this:
X53-3 0 3-53-(17D)-11092015.png

18) The example above is just one of many uses of the Data tab’s Replace Snapshot button when you need to update a project view. And, you can do this as many times as necessary until the project view is the way you need it. In addition to adding and removing rows by changing the Show It field, you may need to change Start Dates, Finish Dates, or Resource Names' and display these data changes in the project view. Using the procedure above you can do this very efficiently.

19) At this point you may save the project view by giving it a file name. When you save the project view in OPX, OnePager will save the .TAM file and within will save the Microsoft Excel file name and path information. This is useful when you want to further update the project view or when you want to add a snapshot later on. In the examples below we will assume that the project view was saved as BlueGrass Project 2J-303-Revised.

Adding a Snapshot to a Project View

20) The power of OPX is illustrated when, after a period of progress on the project, it is time to produce another project view. OnePager produces your next snapshot with the same look and feel as the original. Assuming that the Microsoft Excel plan was updated with actual start and finish, percent complete, and other relevant data during the reporting interval, OPX can easily generate a new snapshot. Launch OPV either from Microsoft Excel or from the desktop icon and click the UPDATE button on the OnePager Express Start form. Doing so will bring up the following OnePager choices (OPC) form:

X53-3 0 3-53-(19)-11222015.png
a) In the OPC form select the NEW snapshot at date: as shown above. You will want to select a current date for the snapshot so that this snapshot will represent the project at the status date point in time. To see which snapshot dates already exist, just position your mouse over the NEW snapshot-date: window to see a list of the existing dates. Use the built in calendar dropdown or type in the new snapshot’s month, day, and year in the window provided as shown below:
X53-3 0 3-53-(20)-11222015.png
b) Uncheck the Show column mappings checkbox if you want to use the same mappings as you used before. The bottom of the screen now looks like this:
X53-3 0 3-53-(21)-11222015.png
c) Pressing the large New button creates a new snapshot for the project view. The project view opens at the new snapshot. The color, fonts, title, and swimlane assignments are consistent between the two snapshots:
X53-3 0 3-53-(22)-11092015.png
d) You can go back and forth between the two snapshots by using the snapshot forward/backward buttons on the View tab as shown below:
X53-3 0 3-53-(23)-11092015.png

Editing the Project View

21) Sooner or later, most of you will edit the font sizes and text position to optimize readability. To do this, hold down the left mouse button and drag a selection box that encloses many tasks/milestones at once:

X53-3 0 3-53-(24)-11092015.png
a) When you release the mouse, the enclosed tasks/milestones will all be selected:
X53-3 0 3-53-(25)-11092015.png
b) Click on the Increase Font Size button on the tool bar shown below:
X53-3 0 3-53-(26)-11092015.png
c) The project view will now look something like this:
X53-3 0 3-53-(27)-11092015.png
d) Repeating this operation for the remaining tasks/milestones (we could have done Select All and done it all at once!), we obtain a project view with larger fonts on all the tasks/milestones:
X53-3 0 3-53-(28)-11092015.png

22) Another common editing action is to move the task names from their current positions to a positions elsewhere around or on the task bar. To do this, select a set of tasks/milestones as before, but this time click one of the text-positioning buttons on the tool bar:

X53-3 0 3-53-(29)-11092015.png
a) Doing this on several batches of tasks/milestones results in the following edited project view. (We have also dragged the legend to a new position and have adjusted some of its font sizes):
X53-3 0 3-53-(30)-11092015.png
b) In case you change your mind about the last editing action you took, you can undo the last editing action by clicking the UNDO button above the OnePager tool bar. Successive clicking the UNDO button will undo editing actions in the reverse order that they were applied.
X53-3 0 3-53-(31)-11092015.png

23) Save the edited project view by clicking the Save button above the tool bar next to the UNDO button. All of the font size changes, text-position edits, and the new legend position are now saved in the file structure in case you need to update this project view with new data at a later time.

Copying the Project View to PowerPoint

24) Finally copy the current snapshot of the project view to the clipboard by clicking the Copy button on the Home ribbon. Then paste the graph into a PowerPoint slide, as shown below:

X53-3 0 3-53-(32)-11092015.png

25) That’s it! You have now created a professional 1-page schedule summary from a complex Microsoft Excel schedule and have copied it into a PowerPoint presentation. You can also print the graph by selecting the Print button on the File tab. OnePager has other features that let you move tasks vertically to different rows and swimlanes, change the number of swimlanes, add swimlane titles, show dependencies among tasks, change task colors, hide tasks, add floating comment boxes, and standardize on graph styles across organizations. To learn more about these features, read about the specific workflows in this Wiki at Basic Workflows (Portal).

(3.0.4-53)