06-10-2023, 07:12 AM
(05-10-2023, 04:00 PM)Koen G Wrote: You are not allowed to view links. Register or Login to view.I would personally have them on one sheet, otherwise there will be no comparison. The comments will just live on their own sheets without any processing going on.
Since I have already written about almost each item, I would take my comments as the basis. Did I really miss something important? Point it out, maybe even mark your comment in red or something. Like that we can find out right away where the difficult points lie, and which items we may have to discuss in depth on the forum.
The alternative will be to hop between tabs and kind of see where there is disagreement. I honestly don't think this will happen.
Okay so I am working on an additional improvement to the workbook. But it will take awhile to finish this one because I don't think there is a quick way in Google Sheets to make it happen. Probably wouldn't be in Excel either. Because the data has to pull from multiple sheets and concatenate some of the data, I don't think a pivot table will work. So yet again, I find myself relying on formulas instead but ones which won't autofill across columns because I'm going from rows to columns. I run into this sort of problem a lot while working in Excel. While I am working on this, take a look at what I am doing and (a) let me know if this will help the process and (b) if you have a quicker and/or better solution.
You will now see that there is a new sheet called Comments Comparison that appears after the wish list and before the individual comments sheets. This new sheet will give everyone a way to view all participant comments for each match number together in one sheet. Once I'm done creating the new sheet, virtually all cells within it will contain formulas that will auto update as their source cells do so please do not edit in this sheet. Instead, add your comments to your individual comments sheet. I have not made any other changes at this time but I do still need to add in the rest of the Folio Browser links for the new matches Rene added.
Once again, I caution all participants to allow all other participants to see their original comments before making changes to either ratings in the ratings sheet or comments in the individual comments sheets so we are able to fully assess valuable insights first.