I need a robust yet easy-to-navigate Excel workbook that lets me see, at a glance, how our hardware prices stack up against the market. The focus is on tools and equipment only, and the competitors I want covered are both the brick-and-mortar stores located in Madrid and the major online retailers that ship anywhere in Spain. Here is what I expect: • Data capture and automation Set up a repeatable process—whether through Power Query, VBA, Python, or a mix—that gathers fresh prices once a month. For Madrid shops you may need manual or semi-automated collection; for online stores, scraping or API calls are fine as long as they stay within the sites’ terms of use. • Clean, structured dataset Consolidate every product’s description, SKU, our current price, each competitor’s price, date captured, and source. All columns must be uniform so I can append future months without re-work. • Dynamic analysis layer Inside the same file, create pivot tables and comparative dashboards that let me filter by product, store type, and date to spot immediate gaps. Conditional-formatting cues (e.g., red when we are higher, green when lower) would be very helpful. • Documentation Brief instructions on how to refresh the data and add new competitors later. Once the workbook proves reliable for one monthly cycle, the project is complete and we can extend the scope if needed.