How To Create A Capacity Planning Manager In Excel From Scratch + FREE TEMPLATE

In this week’s training, I will show you how to create an incredible capacity planning manager complete with unlimited resources and resource types, custom colors, and fully customizable User Interface. Learn how to build this incredible application from scratch during this training video.

⬇𝗗𝗢𝗪𝗡𝗟𝗢𝗔𝗗 𝗧𝗛𝗜𝗦 𝗪𝗘𝗘𝗞'𝗦 𝗪𝗢𝗥𝗞𝗕𝗢𝗢𝗞 𝗧𝗘𝗠𝗣𝗟𝗔𝗧𝗘 𝗛𝗘𝗥𝗘:

GET AN UPDATED TRAINING AND TEMPLATE WITH THE FOLLOWING FEATURES:
• Userform Date Picker
• Resources By Shift
• Monthly Capacity Trend Chart

TIMESTAMPS:
0:00 – Introduction
0:44 – Overview
8:48 – Worksheet Design
43:50 – Selection Change Event
53:02 – Add New Resource
56:57 – Cancel and Save Button
59:04 – Change Resource Type
1:02:32 – Add Picture Resource
1:07:58 – Save and Update Resource
1:14:37 – Edit Resource
1:20:09 – Edit Demand
1:24:17 – Save Demand Details
1:36:58 – Edit Capacity
1:42:33 – Update Resource List
1:46:50 – Save Capacity Details
1:56:36 – Refresh Capacity Schedule
2:29:45 – Creating Chart

#exceltraining #Capacityplanner #resourcemanagement

[ghalekhani]

يتعلم معظم الناس أنك "تحتاج فقط إلى وظيفة جيدة لكي تصبح ثريًا". هؤلاء المليارديرات يعملون في كتاب قواعد اللعبة الذي لا يعرفه الكثيرون بوجوده.

[shivangi]

Hey, seeing you this tues(i mean today i.e 1st aug), notification on, marked ✔️in calendar 📆 too. Love from INDIA 🫶

[sufenlim]

can this apply on the DC capacity planning?

[Abondio]

any chance you can show how to exclude weekends from the date range
(Saturday and sunday)? Thank you!

[sasifexcelsolutions]

I'm planning my capacity for Tuesday, notification on

[abdopower]

Do we need experience in vba to do those projects?🤔😊

[josemariaperezgutierrez]

You are simply the best. Thanks so much

[emiliaholmgren]

Hi, thanks for a great template! When editing the hours of a driver it adds it as a new resource in the CapacityDB, which is then added to the SUMIFS function in the capacity bar making the total capacity of drivers incorrect. I cant seem to fix it in the code - any chance you could explain it? :)

[HenryLopezmatos]

I’d like to have one for manufacturing purposes.

[T]

Kinda mimicked your capacity planner. I have a few errors that have popped up.

1. The def. daily capacity doesn’t auto change when selecting the resource type.
2. The ‘browse’ picture picks the image however, pictures disappears from the picture folder
3. Adding resource doesn’t work when selecting a picture and the MsgBox pops up ‘please make sure to add at least one resource type in the admin sheet’

[igorbrouwers]

☹Getting your emails, but not the capacity planning I enlisted for.