Excel Macros

• A DSM Excel macro that performs Partitioning, Tearing, Banding, and Simulation: (click to download)

When you open the Excel file, you will be warned that the file contains macros and asked if you want to open them; say YES.

Warning

Speed of the partitioning algorithm. The partitioning algorithm was tested using a 600MHZ Pentium III processor. For a 60 tasks DSM, it took around a minute. For a 100tasks DSM it took a little less than 10 minutes. For a 150 tasks DSM it took almost 1 hour.

Introduction on how to start using this DSM Excel macro. click.

NEW & IMPROVED VERSION

• A DSM macro with MS Project interface

An Updated DSM macro (V 1.9) that was posted on 11/27/2007. This is a zipped file that contains all necessary files to install and run the macro, including an elaborate user's guide. Please read the guide carefully and follow the installation procedure. Click here to download the zip file. Thanks to Soo-Haeng Cho for the update!

*** Note that all of the above macros are still under development and are intended for educational and experimentation purposes only.

Back to DSM Tools Index