(21-10-2023, 01:30 PM)Wladimir D Wrote: You are not allowed to view links. Register or Login to view.I want to ast merrimacga if it is possible to add my matches that I published in 2017 to the table. You are not allowed to view links. Register or Login to view.
Although the project started as an attempt to match the small plants to the large plants, it has been opened up to all internal plant matches now and all participants are welcome to add not only their own ratings and comments to the workbook but also to add their own matches that haven't already been included. We have 2 columns currently for new participants to be added (columns M and N) and more columns can be added if needed. New participants simply need to login to their Google account first (free to register and get one if you don't already have one) and then change the (enter your name) header to their own name (e.g. Wladimir D or you could shorten it to WD).
Before adding your own matches, first check to see if they have already been added. Use the filter button on column E (VN Folio Browser), then click Clear, then type the first folio number you wish to check for in the search field, then select each of the matching options listed below the search field, then click OK.
If you don't see your match listed, first clear the filter (by clicking the column E filter button again, then click Clear again, the click Select All, then click OK) and then add your new match to the next blank row at the bottom. You may want to wait until you are the only one in the workbook (you can tell if you see their profile icon in the top right of the workbook to the left of the last edit clock icon) before adding new matches, especially if you have several you wish to add and if it will take awhile. For each of your matches that aren't already in the ratings sheet:
- you will need to complete entries in columns A-D:
- Folio # 1
- Folio # 2
- and for Folio # 2
- the row #
- and position # on the page
- if only 1 plant on the page, row will be 1 and position will be 1
- if there is only a left plant and a right plant on the page, it can still be listed in Folio # 1 but with an L or an R appended to the folio #
- Type WD in column F (short form for the person originating the match; MK=Mark, ThP=Theodore Petersen, RZ=Rene)
- and a match number in column G (1,2,3, etc.; Rene numbered all his and ThP's matches first then removed the ones that were duplicates of Mark's, which is why those numbers have gaps in the sequence)
Don't worry about the filter button on your ratings column nor the column E or other column links nor the formulas in columns O and P nor your individual comments sheet nor the comments comparison. As these are structural changes I added or have fixed before, each time I go into the workbook (when others are not editing), I look for any row additions and will adjust or correct the structure accordingly. Once you see in the ratings sheet a link on your ratings column header, you will know I have completed setup of your individual comments sheet and you can start entering your comments as well as your ratings (it may take longer for me to add your comments to the comments comparison). If you have plant match images, like Mark and Rene added in this thread, I can add links to those in the ratings sheet, same as I did for Mark's and Rene's. Simply post the match number and the link to the match image (if external of this site) or post the image itself (if uploaded to this site) here in this thread and I can take it from there.
Note that our ratings sheet only compares 2 images at a time and I'm not sure if it is viable to change it structurally so as to compare 3 or more images at a time. So if there are any suggestions for matching more than 2 at a time, as I noticed in yours and I think also Rene's, then each match of 2 would need to be added separately to the ratings sheet (i.e. plant A vs plant B on 1 row, plant B vs plant C on the next, and plant A vs plant C on the next, and so on).
This may sound like a lot but it really isn't once you get started. But if you would prefer I add the matches for you, I can as time permits and then have you check them when I'm done.
I included all of these instructions here not only for your use but also any new participant to reference. Let me know if this helps.