Manning Sheet

This is a spreadsheet that is used to project future employee assignment locations.  This is mostly useful in a work environment where employees are moved around to various work locations on a regular basis.  What made this project especially powerful was the ability to represent the data in a heirachical fashion using a treeview on a form.  

The treeview also allows the ability to filter the data on the spreadsheet by location and month.  I was able to gain experience with customizing the MS Excel ribbon through the use of RibbonUI.  This report was distributed regularly through the organization and all features are built into the spreadsheet with no need to install additional addons or libraries.

I've had to santize this online copy to ensure that actual employee names and locations aren't included.  This is only a demo copy.

 download
Download
excelicon
Preview image