Directions:

1.Unzip all files to any directory.

2.You will need to enable the content (2007) or enable the macros (2003) 
  upon opening the Inventory Dashboard.xls(m) file.

3.Upon opening the Dashboard (no need to open inventory files!) you will 
  get #ref errors in the Count column.


Repeat steps below the first time you choose a different Day:


4.Change the Day from 20 to 24.....files are for December, 2010. Changing 
  the month or year will not work for the files provided.

5.Then click on cells D12-D16......each time you will get an error, click 
  on OK (or press Enter). You will see the #ref error disappear and formula 
  appear.

6.Change Part # from anywhere between 1 and 25. To test formulas, change 
  Part # as many times as you like (1-25)!