Crowd-sourcing HD fan-fair: Progress Report

[snowgall]

This is just to update those interested in the status of the HD-fan-fair Crowd-Sourcing Data Project where we're hoping to find the answer to the burning question: Who tops more?

Background: Inspired by the comments on my Who Tops More post, I have decided to try running the same analysis just on the fics written for the hd_fan_fair fest from 2009-2014. But I need to get the complete set of data first, so I set up a public Google spreadsheet in the hopes of crowd-sourcing it. Anyone who wants to can add to the spreadsheet and help fill in the gaps in the data. (Note: my original post suggesting the crowd-sourcing is f-locked to hide the spreadsheet URL from vandals, but if anyone is interested in helping with this project, just PM me so I can send you the link).

My original spreadsheet only contained data for 111 fics from the fests, out of 228 231. I didn't even have the titles or URLs for the rest. But after my call for help, cagnurit came through like a champ and over the weekend entered the rest of the needed title/author/URL/date/summary data for the 120 missing fics. She also added topping and bottoming information for several of these fics and others as well. birdsofshore also added some top/bottom info, and I went through and made sure all the data was consistently formatted and clearer for visitors.

So at this point, we have complete information on 'who tops' for 64 fics rated R or NC-17. For another 20 R/NC-17 fics, capitu gave no 'bottom' tags in her recs, so I have assumed there was no penetration. What we're still missing is top/bottom information on 66 remaining fics rated R or NC-17.

That's it. Just 66 fics. I have highlighted in light red the records in the spreadsheet we still need info for. I invite you to take a look at the spreadsheet (find the link in this post, or PM me) and enter data for any fics you may have read.

**If you add or change any data, it would be helpful to leave a note in the "data entry by" column so I know who to thank and what has been added. You can also add a comment right in the same cell if there's data you disagree with. Just highlight anything you do so I can see it and make a note of it. Thanks so much for all the help so far!

More in this series:
Crowd-sourcing Fan-fair Proposal - Spreadsheet link (f-locked)
Progress Report #1
Progress Report #2 - My f-list rocks!
Progress Report #3 - Take a Poll
Progress Report #4 - Poll Results and Spreadsheet Complete!
Who Tops More in HD-fan-fair: Final Results

Comments

[eidheann_writes]

what does the color coding mean? If i'm updating with top/bottom info on a colored cell, should I turn it white?

[snowgall]

Light red = need top/bottom info
Light green = no info from capitu's rec, need confirmation
Light blue = optional stuff you can just ignore :)

If you add anything in a colored cell, you can leave the color as-is. I'll see the difference in the content easily. But if you don't mind adding your name to the "data entry by" field, that would make it easier for me to thank you :)

If you wanted to change any other info on the table, or wanted to call attention to something that could be wrong, then if you boldface your changes, or color the cell in some way (almost any way) I'll see it too.

Does that make sense? I was trying to keep it simple. I go back in everyday and clean up anything that looks messy, so don't worry about formatting. I'll fix that if needed.

Thanks!

[snowgall]

Thank you so much for your input! I just noticed that you had added info to the chart already, so I guess my color-coding wasn't *too* confusing :) I should have added a key somewhere, but I wasn't sure where to do that on the sheet without making it look cluttered.

Thanks again, you're awesome!

[eidheann_writes]

I checked the second page (comments) to see if there was a color key before I asked. I just did a quick pass what I remembered well enough to know where to look for smut.

[snowgall]

The second page (*slaps head*)! Yes, that's where I should put a key. I didn't know if anyone would even look there :) I'll go do that...
♥

[eidheann_writes]

(And I just ignored the colors figuring I could go back later if needed. But if you're going to I will totally let you do it XD)

[vaysh]

I added a bit more info. Thanks for the update. (I cannot wait for your final results.) ;)

[snowgall]

Thank *you* for adding info! I'm very happy by how much has been added even since last night. It's fun to watch the chart get filled in :)

[khalulu]

So I have read or skimmed 3 and left bolded notes which are probably too wordy.

My own fic Beekeeping (#121) is listed as bottom Draco but I've also seen it described as "implied possible switching but Draco bottoms". Which I think is accurate, in the graphic scene Draco bottoms but it isn't an established role. (Harry says "Me in you or you in me" and Draco says "anything".)

I'll do a few more if I get a chance!

[snowgall]

Thank you so much! And wordiness is just fine :)

You know, this is why the question of 'who tops' is so tricky. Because different people will have different definitions of what that means, even despite what may seem like a rather clear distinction. Because for me, "implied possible switching but Draco bottoms" sounds exactly right for that sort of situation, and just labelling it "bottom!Draco" doesn't quite capture it. But at the same time, it would be a lot harder to do any kind of statistical analysis if we allowed 17 different categories of topping and bottoming :) So giving it a simple label but then adding explanatory notes as well for anyone who cares is probably the way to go.

Thanks again!

[snowgall]

Oh, and just so you know, you can sort the table based on any of the column headings, so I don't think your story will always be #121 :) But you can always easily find it by sorting by author or title, and there's probably a search function too. ♥

[snowgall]

I'm so excited by how much is getting filled in - I saw you had done some more this evening. Thank you! I'm going through and editing slightly to make sure the formatting is consistent, but don't worry, I haven't substantially changed anything you've added :)