ProjectLoad Blog

The Personnel Availability Report allows users to easily spot overloaded or underutilized personnel. It displays one row per person showing the normal work hours into the future (by day, week, month, or year) and subtracts the forecasted hours to show how much time each person has “available” during the period. To aid in spotting trends, problems, or opportunities, the report cells are color coded so that when a person has available time, the cell is green and the intensity of the green gets deeper based on the percentage of their time that is available. When a person has little available time, the cell is white. If the forecasted hours exceed the normal work hours, a negative number is displayed and the cell turns yellow with deeper shades indicating higher levels of overtime. Once the system determines a person will need to work more than 50% of their normally scheduled hours in the period, the cell is turned red to highlight the problem.

The daily timesheet is the most commonly used page in the system. It is important to make it include as many of the regularly used functions as possible and yet still be easy to operate. Some customers had noted that with multiple input fields it would be helpful to make the “Today’s Hours” column stand out since it is used more often than any other field. This change highlights that column on all versions of the timesheet.