Data Extraction

[DanTaylor]

My end goal is to use this data and automatically produce a weekly summary to say "week beginning the 20/03/23, rooms ___ are due for completion at the stage QA3-6 and rooms ___ are due for completion at stage Final" etc. Obviously this data would be in a table of some sort but I can't think of how to do it without manually going through the dates.

Does anyone have any ideas, please?

[#2]

@DanTaylor 

Does anyone have any ideas, please?

Ideas? Yes.

Is it possible for you to post the actual spreadsheet you used to create that image? Post it on OneDrive or GoogleDrive, and paste a link here that grants edit access to the file. 

The image illustrates the problem and the need, but access to the actual spreadsheet would enable the demonstration of how it can be accomplished.

[#3]

Hey there! Data extraction can be a game-changer for automating tasks like producing weekly summaries. One approach could be to use web scraping techniques to extract data with the help of https://www.nannostomus.com/ and store it in a tabular format. Then, you can use scripting or programming languages like Python to process the extracted data and generate the weekly summary you mentioned. You can leverage libraries like BeautifulSoup or Scrapy for web scraping and Pandas for data manipulation. With a little bit of coding, you can save yourself from manually going through the dates and have a neat and automated solution in no time! Good luck!