![]() |
|
Matching Plant Images Internally - Printable Version +- The Voynich Ninja (https://www.voynich.ninja) +-- Forum: Voynich Research (https://www.voynich.ninja/forum-27.html) +--- Forum: Imagery (https://www.voynich.ninja/forum-43.html) +--- Thread: Matching Plant Images Internally (/thread-4067.html) |
RE: Matching Plant Images Internally - merrimacga - 06-10-2023 (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. 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. RE: Matching Plant Images Internally - Koen G - 06-10-2023 RE: Matching Plant Images Internally - merrimacga - 06-10-2023 RE: Matching Plant Images Internally - ReneZ - 06-10-2023 RE: Matching Plant Images Internally - Mark Knowles - 06-10-2023 RE: Matching Plant Images Internally - Ruby Novacna - 06-10-2023 RE: Matching Plant Images Internally - merrimacga - 06-10-2023 RE: Matching Plant Images Internally - ReneZ - 07-10-2023 RE: Matching Plant Images Internally - merrimacga - 07-10-2023 RE: Matching Plant Images Internally - ReneZ - 07-10-2023 |