excel spreadsheet for production monitoring

I need an Excel spreadsheet designed to track production output, quality metrics, and inventory levels, and to perform detailed analysis on a daily basis. Ideally the spreadsheet should be organized in an intuitive way so I can quickly access and analyze the data. It must be custom-made for my specific needs, and should have features that will make it easy to use and manipulate the data. Any formulas or scripts created should be well documented so I can make further modifications or enhancements on my own. Finally, the spreadsheet should be designed to help me detect any patterns or trends in the data.