Labor Distribution Tools Using Excel on Windows 2000

Please ensure all previous LD tool versions have been removed before continuing with installation. For removal instructions, click here.

Labor Distribution Tool INSTALL INSTRUCTIONS (This is a one-Time Setup in EXCEL per machine)

  1. Open Excel – Click on Start, Programs then find and click on Microsoft Excel in list.
  2. Click on Tools, select Macros which will open another menu, click on security in this menu.

 

  1. Select Medium Security then click OK.

 

Adding Excel AddIns

1. Right Click on LD Utilities.xla and select Save As" .

 

2. Select Desktop in Save In pull down box.

 

3. Click on  new folder icon to right of “Save In” pull down and then type in LD Utilities in  New folder name box.

 

4. Double click on LD Utility folder you have just created and click on Save to save file to this folder.

 

  1. Open Excel – Click on Start, Programs then find and click on Microsoft Excel in list.
  1. Click on Tools menu – select Add-Ins

 

  1. Check Analysis ToolPak, Analysis ToolPak – VBA and click on Browse.
  2.  

  3. Select Desktop in “Look In” drop down menu.

     

  4. Find and double click LD Utilities Folder,  then click on OK

     

  5. Click OK to close Add-In window.

  6. The Excel menu bar should now have a menu at the end called “LD Tools”.

Download and Running instructions for LD Forward workbook