I want to make my excel inventory more powerful by adding a few apps and GUIs. The way I use the system now there is lot of manual entry and updating. I want to minimize this. I would like to enhance the system in regards to what it can do. As it stands my inventory tracks consumption of a product over a weeks time I want to use this in conjunction with inventory levels to generate POs. Additionally I want to generate prep lists (work orders) based on historical sales data per day of the week. Overall I want to better utilize the data I am collecting and entering.