Here is the download and replay from the Webinar –
Webinar Replays
How to Build Your Own Capacity Planning Tools in Excel
Webinar Replay: 13:00 GMT, Thursday 12 March, 2020
Click here to watch replay
Webinar Replay: 19:00 GMT, Thursday 12 March, 2020
Click here to watch replay
Webinar Replay: 08:00 GMT, Tuesday 17 March, 2020
Click here to watch replay
NOTE: Each webinar was recorded live and covers the same content for the first 50 minutes. The Q&A goes on for another 24 minutes (13:00 GMT). Naturally the Q&A is unique to each so you may get extra content!
Download the Capacity Planning Tool and Template
Click here to download the Capacity Planning Tool and Template
This zip folder includes:
- The Development Template
- The Twenty Minute Capacity Planning Tool that we started with
- The Twenty Minute Capacity Planning Tool that we ended with
- Source data
Capacity Planning Tool – Instructions for Use
- Enable macros to run on your computer (if you haven’t already done this). Here is a guide for enabling macros.
- Unzip the folder directly to your C Drive. You should have a folder on your computer called C:\P-S_Capacity_Planning/Data
- Open the Capacity Planning Tool and hit the “Update” button on the Menu sheet.
- Use the “Output” button on each Query Sheet (SalesOrders, Routing, Workcenters and Calendar) to save any data changes.
Preregistration Signup
This form is for people who are interested in our upcoming Build Excel Tools Course. There is no commitment. Sign up and get a special early-bird offer when registration opens.
We have developed a draft of the course and here is the overview so far:
- Key Design Concepts for Building Excel Planning Tools
- Templates, Tools and Systems – How and when to use them
- The complete guide to the Fast Excel Development Template
- Designing a Data Flow for Planning Processes
- Build the Material Planning Tool
- Build the Capacity Planning Tool
- Design concepts for Reporting