c++ projecg asap

I’m looking to have a single, well-structured Excel workbook that lets me stay on top of my raw-materials inventory at a glance. The sheet needs to record every item, its current stock level. Inlcuding stock entry and exit at a complex level.

Here’s what I expect from the finished file:
• A clean input area where I can add, edit, or deactivate materials without breaking formulas
• Automatic stock-on-hand calculations and clear visual cues for low or out-of-stock items
• Location fields that accept only valid entries (drop-downs or similar data-validation) so mistakes are minimized
• A summary view that aggregates totals and lets me filter or sort by material type, location, or status

I’m comfortable updating raw data; what I need is the underlying structure—tables, formulas, conditional formatting, and any helpful pivot summaries—ready to go so I can simply plug in numbers and trust the outputs.

If you have an approach that keeps everything fast and fool-proof in standard desktop Excel, let’s talk and get this built.