Resource Capacity Planner – Excel Template – Support

Posted on

This page will host supporting information for the Resource Capacity Planner Excel Template which can be used to plan resource capacity, compare versus demand and identify over-utilization and under-utilization.

To know the features of this template, please visit the product page.

The latest version (v2) was published in July 2018.

The following are the support articles to help you get started with using the template. If there are any questions not addressed here, please drop a comment and I will add article/video demo about that topic.

  • Please see this article on Important Tips before using the template
    1. Do not edit calculated cells
    2. Input Data is always visible & can be edited easily
    3. Backup by saving file regularly
    4. Refresh Calculations when Pivot Tables are used
  • This template uses Excel tables for data entry. If you are not very familiar with Excel tables, please see this article on How to enter data using Excel Tables?
    • What is a Table?
    • Why do we use Tables?
    • Components of a Table
    • 3 Basic Data Entry Operations
    • 5 Essential Tips to avoid mistakes
  • Step by Step¬†User Guide
    • Step by step user guide to Resource Capacity Planner Excel template.
    • Learn how to enter input data on capacity and demand.
    • Find how to use the Capacity planning Dashboard and Calendar to identify over-utilization and under-utilization.
    • Learn how to address over-utilization and under-utilization to improve the plan


If you have any questions on the template, please post them in the comments section below. I will respond as soon as I can. If it will benefit others, I will also publish a blog post and video answering your question.

151 thoughts on “Resource Capacity Planner – Excel Template – Support

  1. Hello, I have multiple resources and multiple projects that they will be assigned to so I am unclear of the best method for entering the data for capacity and demand. Can someone advise the following:
    Capacity : should I only enter the hours of availability of a full workday or the hours they are just available to work on the specific projects?
    Demand : I am entering the tasks
    Dashboard : I am only seeing the surplus…not the deficits
    Need to understand the best methodology to ensure I am getting the right output…thanks

    1. Thanks for purchasing.
      1. In the Capacity sheet, you will have to enter the hours a resource is available to work on a specific project using a specific skill for each weekday during a period (between Start and End Date). Please see examples in
      2. Same with Demand sheet. Here we have to enter specific demand. Example – On Apr 4, 2020, 6 hours of development work should be done by Resource A as part of Project One.
      3. Dashboard: if the capacity entered is greater than demand, then only surplus will display.
      Please review the guide in
      If there are further questions, please email me ( the file and questions. We will address them as soon as we can.
      Best wishes.

  2. Resource Capacity Planner template has a default of 100 resources. I need to increase this default to 200 resources. What do I need to do?

    1. Please email for a version that supports 200 resources. The file is large and could be slower. But I will be glad to share. Please email with order number.
      Thanks & Best wishes.

  3. Any way to convert this from individual resource (person) to resource type (Dept)?
    we have teams of each skill. for us its not practical to assign individuals to each project/task we are looking to assign work to a department and based on the head count determine our capacity constraints for that type of work.
    instead of assigning to each individual?

    1. Thanks for your interest.
      I have not tested that input option so far. But logically it should still work. Are you expecting any different output than what is currently available in the dashboard? If you would like to try the template and find that it does not meet your needs please let us know and we will issue a full refund. Please email if you have any questions or need assistance.
      Best wishes.

  4. Resource Capacity Planner template:

    The Capacity Vz Demand dashboard does not show data for projects or resources. I did several refreshes after entering data in the Capacity and Demand sheets, but no data is shown on dashboards. I have followed all the steps in the guideline and other resources listed in this support section. Is it possible for me to upload my file for you to take a look at it?


    1. Thanks for using our template.

      Please email your file with the list of issues to

      Best wishes

  5. I have a resource (John) that is schedule to work 3 hours a day (five days) on a given project (Project 1) for a specific length of time (start date and end date). When I enter the “Task” (Task 1) for John (associated to Project 1) it comes back as a deficit showing on the due date. Because there isn’t an actual “start date” to Task 1 it does not evenly distribute the workload when I view it on the “Calendar” sheet filtered for “Resource” and “Hourly”. It shows as a deficit of time on the “Date Due” not accounting for the time allowed to complete the task.

    How can this be resolved because it not projecting accurate deficit? Thanks

    1. Thanks for using our template.

      Please share the file along with the list of issues to

      Best wishes

  6. I’m working on the Vacation/OT page. My resources are all on many projects. I do not understand why I must repeat my entries for every project the person is on. A resource is going to be out. So all 10 assigned projects should understand the employee is unavailable those days. How can I do this with one entry per person per vacation? It’s just like the holidays! You don’t make us add a holiday for every project. The person simply isn’t available for scheduling.


    If you have assigned a resource to multiple skills and/or projects, you will have to enter vacation or overtime separately for each combination. This allows more flexibility in capacity planning as you can enter overtime only for a certain project instead of both projects (assuming resource assigned to 2 projects).

    1. Thanks for your feedback.
      In your scenario, when the employee is completely on Vacation, I understand that this would result in multiple entries. There are some other cases where an employee is only taking off from one project on a day but will work on other projects. Or the employee may do overtime on a specific project but not on others. There are different possible scenarios. As I tried to consolidate all such entries into one table for all vacation/overtime, partial and full, I had to make that compromise. Otherwise, I would have to have separate tables (Full Vacation, Project Specific Vacation, Overtime tracking) to do different scenarios that may become more complex with more sheets and so on. Holidays are considered like full time off for all employees in organization. That’s why they don’t have this restriction.
      I am fully agreeing with you that this results in more data entries in scenarios like yours. I hope that my explanation clarifies the need to balance different scenarios as well as complexity/simplicity. I will continue to explore better methods of solving this problem in future as the software and computing power advances.
      Please let me know your thoughts.
      Thanks & Best wishes.

Leave a Reply

Your email address will not be published. Required fields are marked *