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.

Next, we need to create a formula (below) in one of your chosen number fields. The divide by 60 is due to the Work coming through in minutes and not hours, so we must take the value and convert it into an hour:

(Work)/60

We are working with five different schedules in this exercise, so the above formula must be added to each schedule. When that is complete, you can then start the chart creation process by clicking on the Add-ins tab and selecting OnePager Pro or OnePager Bundle.

In the OnePager Start screen, select New, and in the Selected Files portion, make sure to add all your needed schedules. Once all other options are confirmed, click on Create new chart.

Go to Chart Properties > Task Bars > Manage Rules; from here, we will create three rules. The rules will be used to color code based on the hours worked for each resource in a day. This will allow you to determine if the resource is available with the resource only working 8hrs a day. You can see how these rules are set up below in the screenshot.

Once the rules have been created, you can click OK > OK, and you will see that your chart is now color-coded based on the resource’s availability of an 8 hr day.

I invite you to reply below with comments that might have come to mind while reading this article.