Capacity Planning – QuickStart Webinar Part 2


If this video has not yet rendered or you wish to see live chat, then you can view it on Zoom here.


Here is the download link.


  • Watch the webinar replay first. The system will make much more sense.
  • Download the zip file and extract the contents directly to your C Drive. You should have these folders:
    • C:\P-S_Quickstart
    • C:\P-S_Quickstart\Data
  • If you have not run macros or used external data before then do this:
  • File > Options > Trust Center > Trust Center Settings >
    • .. Macro Settings >
      • ..Check “Enable All Macros (this is highly recommended as useful code can run)”..
      • Check “Trust Access to the VBA Project Object Model”..
    • External Content > Check “Enable All Data Connections (also recommended)”
    • OK > OK
  • You will only have to do this once per machine
  • Open the file Capacity_Planning_Training_Data_Model_v01.xlsm
  • View the slides and data (blue tabs)
  • Run the tool from the Menu Sheet “Update from Local”
  • Change the data in the Demand_NEW, Routing_NEW, Workcenters_NEW, Items_NEW
  • View results in Reports (yellow tabs).
Scroll to Top