Others

How to Set Resource Availability and Calendars in Microsoft Project

Maira Mehtab Sep 20, 2026 869 views

Question details

The user needs to learn how to model an as-needed resource and a highly restricted resource in Microsoft Project.

Product: Microsoft Project
Device & OS: not provided
Scenario: Configuring resource allocation for project team members who either have sporadic availability or strictly limited working hours.
Observed behavior: The user wants to use Max Units, assignments, and resource calendars to reflect actual resource availability, noting that sporadic availability can be difficult to represent accurately with a percentage.

Before you start

Before configuring resource availability, ensure all project resources are added to the Resource Sheet and have a default base calendar assigned.

Solution 1Recommended

Model As-Needed Resources with Task Assignments

For resources that are used on an as-needed basis, keep their overall availability at 100% and manage their actual workload through targeted task assignments.

Instead of reducing an as-needed resource's global capacity, it is better to assume they are fully available when called upon. This prevents Microsoft Project from unnecessarily spreading out their task durations.

Set Max Units

Open the Resource Sheet view. Locate the as-needed resource and ensure their 'Max.' field is set to 100%.

Assign Specific Tasks

Navigate to the Gantt Chart view. Assign the resource only to the specific tasks where they are required, ensuring they are not double-booked across concurrent tasks.

Best Practice: This method ensures the scheduling engine calculates task durations accurately without applying an artificial bottleneck to the resource's working hours.

Solution 2

Limit Availability Using Custom Resource Calendars

For highly restricted resources who can only work on specific days or times, create a customized resource calendar to block out their non-working hours.

Solution 3

Handling Sporadic Availability Limitations

Understand how to approach highly unpredictable schedules that cannot be easily modeled with standard project management software tools.

Free Microsoft Office alternative

Track Sporadic Project Resources flexibly with WPS Spreadsheet

Microsoft Project can be overly rigid and complex for tracking resources with highly sporadic or unpredictable availability. WPS Office provides a free, lightweight alternative. Using customizable spreadsheet templates, you can easily track dynamic team schedules, task assignments, and working hours without fighting against rigid calendar constraints.

1. Open WPS Spreadsheet: Launch WPS Office and open a new Spreadsheet workspace.
2. Find a Project Tracker Template: Click 'New' and search the template library for 'Resource Tracker' or 'Project Schedule' to instantly set up your document.
3. Customize and Share: Adapt the columns to fit your team's sporadic availability and save the file in .xlsx format for seamless sharing with Microsoft Office users.

Easily track sporadic resource availability using flexible, customizable grid formats.Free, lightweight, and highly adaptable compared to rigid project management software.Fully compatible with Microsoft Excel (.xlsx) project tracking and timesheet templates.Familiar spreadsheet interface with absolutely no steep learning curve.

Frequently Asked Questions

What does Max Units mean in Microsoft Project?

Max Units represents the maximum capacity of a resource to work on assigned tasks within their defined working time. A value of 100% means the resource is available full-time based on their calendar, while 50% means they can only dedicate half their working hours to project tasks.

How do I change a specific resource's working calendar?

In the Resource Sheet view, double-click the resource to open the Resource Information dialog. Click 'Change Working Time', where you can create exceptions for time off or modify the 'Work Weeks' to set specific working hours for that individual.

Can I assign a project resource to work only on specific days?

Yes. By modifying their specific Resource Calendar under 'Change Working Time', you can mark certain days of the week as non-working time. Microsoft Project will then automatically avoid scheduling tasks for them on those blocked days.

Office Quick Solutions