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.

Setting a Task’s Finish Time in Excel

When creating a schedule in an Excel spreadsheet, you will have a Start date and Finish date. But there is also a time associated with those dates, and if you don’t set it, your tasks may appear to finish earlier than expected. In the example below, both tasks finish on the seventh day, but the blue task finishes at 12:00 a.m. and the red task finishes at 11:59 p.m., almost a full day later. Paying attention to the times associated with your dates in Excel will help you ensure that a task is scheduled correctly.

This blog will go over an addition to make to the formula in your Excel spreadsheet to change the time of your task Finish date.

Continue reading

Conditionally Displaying Baselines

OnePager’s baseline display is a great way to compare your original project plan to the way things are now. But what if you want to only show baselines where there has actually been a change in the underlying schedule? This blog article will show you how to conditionally display Baseline Markers when there is variance between Start/Finish and Baseline Start/Baseline Finish.

To display Baseline Markers conditionally, we first need to have our data set up correctly in our Microsoft Project file. We assume you already have a Task Name with Start/Finish dates. You will also need to have Baseline Start and Baseline Finish entries.

Continue reading

Timeline without Dates

With a Gantt chart, you can display Start/Finish dates that show exactly when a task starts and finishes. However, in this blog, we will be creating a dateless chart to show a graphical representation of your schedule without any specific dates displayed. 

We will start at the top of the chart with the Time Axis representing different tic units. In the example, we utilize the Month and Week units of the Time Axis.

Continue reading

Identifying Late and Very Late Tasks with Finish Variance

In Microsoft Project, a field called Finish Variance shows how many days there are between the Finish and the Baseline Finish fields. Using this data can be helpful when trying to determine if your tasks are finishing on, before, or after their planned finish dates.

If you want to use the Finish Variance field in your OnePager Conditional Formatting Rules to show visually if your tasks are late, you’ll run into an issue: Microsoft Project treats Finish Variance as a string field instead of a number.

Continue reading

Using Separate Fields for Task vs. Milestone Text

When creating a chart in OnePager, we want to make sure that the audience knows what the tasks and milestones represent. This is why the labels in a chart are so important.

Most of the time, using the same text field from MS Project will suffice for both your tasks and your milestones, but there are situations where you need to label tasks one way and milestones another. In this article, we are going to discuss how you can import data from two different Microsoft Project fields so that you can use the first field to label your tasks and the second field to label your milestones.

Continue reading