chacusha (![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png)
chacusha) wrote in ![[community profile]](https://www.dreamwidth.org/img/silk/identity/community.png)
latetreatbonanza2024-03-23 08:57 pm
chacusha) wrote in latetreatbonanza2024-03-23 08:57 pm
Entry tags:
Spreadsheet correction requests
Hi all, this year, we have a spreadsheet (two spreadsheets, actually: one for searching and one with the original data) that lists out all of the fandoms each participant has requested in the past. Putting together this spreadsheet was a mix of automated and manual effort, both of which introduce errors in their own way.
Please comment here if you notice any issues with your data in the spreadsheet, such as:
- Your username is spelled wrong.
- The links associated with your sign-up go to the wrong place or are broken.
- The list of fandoms associated with your username just looks totally wrong.
- The list of fandoms associated with your username is largely correct but you would like to add or remove some fandoms from the list.
If adding/removing fandoms, please give me a list with one fandom on each line.
Please note that extracting all the fandoms someone has ever requested is easy/trivial for me to do, but manually cleaning up fandom names to remove nearby variations is difficult and time-consuming, so I have not done this and it may not be practical for me to do much fandom name clean-up. When searching, I recommend using the text entry search to hit as many variations on a fandom name as possible and get around the issue of fandom name variations. However, if you think there is a severe issue with the fandom names that affects searching, feel free to bring it up here.
Please comment here if you notice any issues with your data in the spreadsheet, such as:
- Your username is spelled wrong.
- The links associated with your sign-up go to the wrong place or are broken.
- The list of fandoms associated with your username just looks totally wrong.
- The list of fandoms associated with your username is largely correct but you would like to add or remove some fandoms from the list.
If adding/removing fandoms, please give me a list with one fandom on each line.
Please note that extracting all the fandoms someone has ever requested is easy/trivial for me to do, but manually cleaning up fandom names to remove nearby variations is difficult and time-consuming, so I have not done this and it may not be practical for me to do much fandom name clean-up. When searching, I recommend using the text entry search to hit as many variations on a fandom name as possible and get around the issue of fandom name variations. However, if you think there is a severe issue with the fandom names that affects searching, feel free to bring it up here.
no subject
-Dune (Movies - Villeneuve)
-Fiddler on the Roof (1971)
-The Artful Dodger (TV 2023)
-The Marvelous Mrs. Maisel (TV)
Also, not sure if it matters, but there are listings for "Crossover Fandom" and "crossover - Fandom" that could probably be merged, if that's possible.
Thank you for putting this together!
no subject
For the crossover fandom tags, I'm still not sure what to do about duplicates to fandom names like that. For now, I'm leaving them all in, as some people might have signed up to different events that used different versions of that tag, and so each tag alone might not pick up everyone who is requesting crossovers. But in the future, ideally, it would be good if I could standardize the fandom names and automatically convert the variations into the standard name. I'll look into it next time!