About Josh

Josh has over a decade worth of experience in IT. Eight years of that was in healthcare doing IT Security (IAM) and Clinical Application Support. He now brings that experience to OnePager, where he provides support and brings new users up to speed with training sessions. Josh is an avid backpacker and enjoys spending nights deep in the woods outside of work.

OnePager Regional Settings

OnePager supports a variety of regional settings for our many customers around the world. This means we will show dates in the local format/language and switch to metric templates that use centimeters instead of inches when appropriate.

In this article, we will show examples of how this works in OnePager by reviewing the scenarios listed below. If you’d like to follow along, go to Control Panel > Region on your device and select each of these options to see how they change OnePager’s display:

  • English language & US Region
  • English language & UK Region
  • French language & France Region
Continue reading

Importing Fonts into OnePager

When it comes to timelines and Gantt charts, appearance matters. The whole point of creating a chart in OnePager is for it to be a visual project report. In addition to colors and shapes, the font you use can make a big impact on the overall look and feel of your chart.

The first step in adding a new font to OnePager is to add it to Windows. Microsoft has put together detailed step-by-step instructions on how to do this:

Add a font – Microsoft Support

After you have added the font(s) to Windows, launch OnePager and go to Chart Properties. Open any form that has a font control. In this example, we will change the Task Label to a custom font called “KG Chasing Cars.” Once you have selected the font, click OK and OK.

Continue reading

Resource Usage Across Multiple Microsoft Project Files

Hello again to all my fellow OnePager users! I have a question for you today. Have you ever wondered what an easy way would be for you to track resource usage across multiple schedules? If you have ever asked yourself that, you are in for a treat. If you have not, you are still in for a treat. This article will discuss using Conditional Formatting Rules (CFR) to display available resource hours within your OnePager chart.

The first thing to do here is to ensure you have a schedule with hours entered into the Work field. This is the field we will use in the OnePager chart to create rules and track resource hours.

Continue reading

Baselining and Variance Analysis

If you are someone who regularly reads our blog, you will know that most of the time, our articles cover OnePager and how to use it more efficiently. However, here at OnePager we like to keep things fresh and exciting, so instead of discussing OnePager, this article will cover Baselining and Variance Analysis in your Microsoft Project file.

The best way to get into this discussion is to review what a Baseline and Variance are and what they represent in your schedule.

The Baseline in your schedule can be a kind of snapshot of your project. This snapshot has five categories from which it captures data for every task: start, finish, duration, cost, and work. With this data, you can compare actual vs. planned progress, allowing you to identify areas where the project could use extra attention.

The Variance depends on the baselines as it represents the difference between your original and current schedule. Microsoft Project calculates this by using a formula that I have placed below. Within your project are five types of Variances: start, finish, duration, cost, and work.

Continue reading

Weekend Work on an Hourly Scale

Most schedules show work that takes place during the work week, but in this article, we will explore creating a Gantt chart that displays, on an hourly scale, work done over the weekend.

Below is a schedule with tasks for Saturday and Sunday between 8:00 am and 3:00 pm.

The next step is to launch OnePager and create the chart by going to Add-ins > OnePager > New. After clicking New, you should see the “OnePager choices” window; we will select an out-of-the-box template designed for an hourly view. To do this, click Change… and then Browse, which will bring you to the template folder. Select the “Hourly View” template, and then finish creating your chart.

Continue reading

Milestone Types using Project Online

If your project has lots of different milestones, you may benefit from defining a Milestone Type in Project Online so that different families of milestones are easier to distinguish.

Examples of different milestone types include major, minor, payment, and review, to name a few. In this article, we will share how to create enterprise custom fields and lookup tables in Project Online to catalog our milestone types and how to use them in your OnePager chart. 

Continue reading

Percent Complete Color Coding

For anyone who has created a schedule, one of the essential things to know is percent complete. Users of OnePager know we already offer ways to show percent complete via a yellow bar, text, or a checkmark. However, we will dive into another method: color coding different tasks based on a percent complete range.

We will first want to determine what percent complete ranges we want to create rules for and what color will represent them. In this example, I will be using the following ranges.

0% – 25% | 26% – 50% | 51% – 75% | 76% – 100%

Once you have decided on your rules, create a chart from your source file.
Continue reading

Filtering your Task Links (3/3): Key Milestones

Welcome to part 3 of the task link filtering trilogy! Through our task link journey, we have covered how to display dependencies that are on a Critical Path (Part 1) and also dependencies that are set for Future Dates (Part 2). If you missed either of those two blog posts, I highly suggest you treat yourself to the wealth of knowledge it offers regarding task link filtering.

We will discuss how to filter your task links so that only ones with a milestone as a successor are displayed. To do this, we will first need to create a chart with task links enabled. You can enable the task links by going into Chart Properties > Task Links and checking the box “Show data-driven links.”

Continue reading

Filtering your Task Links (2/3): Future Tasks

Welcome to part 2 of the task link filtering trilogy! Our last blog article discussed how to show task links on a Critical Path (Part 1). This portion will explore how you can filter your task links in two more ways, both relating to future dates. The first will go over how to filter task links with a status of “Future Tasks,” while the second will be how to filter task links to only show when they are to the right of your Time Cursor, which is another way of looking at future dependencies.

Continue reading

Filtering your Task Links (1/3): Critical Path

We will be doing a three-part blog series that explores smart ways to filter your task links in a OnePager chart. This first article will discuss how to display dependencies for only the tasks that are on the critical path. We will use the Microsoft Project example below, where Site 1 and all of its subtasks are on the critical path, and all of the tasks underneath Site 2 are non-critical:

Continue reading