In this video, we see how we can use the Team Vacation Planner Excel template to calculate team’s capacity (availability) over a planning period.
The template can be downloaded from https://indzara.com/product/teamvaca...

For step by step instructions on how to use the template, please visit https://indzara.com/2017/02/teamvaca...

We will go over each sheet in the file and demonstrate how the template works.

The template will calculate number of employees available on a day and compare with number of employees needed. This is done by taking into account vacations planned by employees. This will help us identify if there are any days where we are understaffed. By planning ahead of time, we can take actions to remedy the situation.


FEATURES OF TEMPLATE

Customize to suit your company’s needs
Any planning Period of up to 1 year
Any number of company holidays
Each employee can have different availability
Demand (Employees Needed) can be set differently by weekday
Employees can have different employment periods
Automated capacity calculations
Calendar view of Employee and Team Availability
Monthly Summary Report
Easy and organized data management


BENEFITS

Improved data management
Save precious time
Automated Report and Calendar
All within familiar Excel – Easy to learn and extend




Simple and Effective Excel Templates: http://indzara.com/
Free Excel Templates: http://indzara.com/freeexceltemplates/
Premium Excel Templates: http://indzara.com/shop/
Project Management Templates: http://indzara.com/projectmanagement...
HR Templates: http://indzara.com/hrexceltemplates/

Free Excel Course: http://indzara.com/usefulexcelforb...

Social:
Subscribe to YouTube: http://www.youtube.com/user/theindzar...
Facebook:   / theindzara  
YouTube:    / theindzara  
LinkedIn:   / indzara  
Twitter:    / theindzara  

~~~~~~~~~
Please watch my latest video: "Highlight events, weekends and holidays on calendar in Excel"    • Highlight events, weekends and holida...  
~~~~~~~~~