Resource Capacity Planner (Excel)

Resource Capacity Planner (Excel) - v3 - How to use?
Overview of steps: Enter Settings Enter Resource list with standard availability and allocate Capacity to Skills and Projects Enter vacation and overtim...
Sat, 7 Aug, 2021 at 8:23 PM
Limitations
For v4, Default: Maximum 200 Resources, 100 Skill Groups, 100 Projects and 200 Holidays. 200 entries in Capacity sheet: For example, if you ha...
Wed, 11 Aug, 2021 at 10:54 PM
How to change currency?
To change the currency from US$ to another currency, please follow the steps below: Press Ctrl+G and select CURR named range. Changing Currency – Press Ct...
Mon, 20 Apr, 2020 at 7:38 PM
Resource Capacity Planner v4 - User Guide
Step by Step User Guide Overview of steps: Enter Settings (Projects, Skills, Resources, Holidays). Allocate Capacity of Resources to Skills and Proje...
Fri, 4 Aug, 2023 at 7:01 PM
How to extend beyond 200 rows in Capacity sheet?
Unprotect the ‘Capacity’ sheet with indzara as password.  steps to unprotect Continue to type in more rows of data as needed. When c...
Wed, 11 Aug, 2021 at 10:54 PM
Why Demand is not included in calculations?
A couple of scenarios where Demand calculation will not include all demand data entries. In both these cases, Calendar and Dashboard will have different res...
Wed, 11 Aug, 2021 at 11:04 PM
Expand Resource/Skill/Project/Holiday limit
Following are the steps to increase the limit of Resource or Skill or Project or Holiday limit: 1. Unhide hidden TABLES tab: 2. The TABLES ta...
Thu, 24 Feb, 2022 at 11:46 PM
How to specify capacity without assigning skill or a project?
If there's a scenario where capacity is known at a resource level and not to any particular project or skill, follow the given steps to assign capacitie...
Tue, 21 Mar, 2023 at 11:20 AM
Which template to use: Resource Capacity Template or the Resource Capacity Lite Template?
Not sure whether to choose from the premium Resource Capacity Planner Excel Template or the Resource Capacity Planner Lite Excel Template.  Read along to k...
Mon, 11 Sep, 2023 at 10:14 AM