The Jinjurly Missing Files Spreadsheet!

[squidgestatus]

All,

We've come to the part of the Jinjurly restore project where we need your help!  If you go to the link below, you'll see the 5,400+ entries in the Jinjurly Audiofic Archive that are missing MP3/M4B files.   

First off, the link: https://docs.google.com/spreadsheets/d/1n7sLNnTLECHHZfxpMqzWEkEOwSurqypuGDLaqFyTSpQ/edit?usp=sharing

Second, here are some notes to understand:

• The spreadsheet is editable by anyone with this link in columns I and J only.  If there are other edits/notes (like "Hey, the author on this says X but it should be Y" or the like), please note that you can leave a comment on a cell in just about any cell that you want.  However, if you want me to notice a comment, please keep it in either column I or column J.
• Column H is marked "podfic located by mods" and is something that mific  was able to fill out before I published this spreadsheet based on either podfics that she personally has, or from a list that we have gathered from other people. For those, unless we say otherwise, you can consider them already found so we don't need another copy.  
• IF you have a copy of either an MP3 or M4B for something on the spreadsheet that is in need (anything with a blank column H) then PLEASE fill out your username and where that username is from (DW/JL/Twitter/Tumblr) so that one of us can contact you should we have questions. In column J, please put the publically downloadable link where we can download the work. 
• The columns are self explanatory, and most of them contain only one value (one URL, one Title, etc). However, if there is more than one Fandom, Author, Reader, or Relationship, those are concatednated together in the same column.  Therefore, if there is a "Stargate Atlantis" and "Leverage" crossover, it won't be listed with either fandom, but will be instead listed by the fandoms in the order they were spit out by the database. Hopefully they are in alphabetical order, but I cannot guarantee this. Spotchecking, I found crossovers like "chronicles of narnia, supernatural" which is in order, but "harry potter, american idol, hawaii five-0, queer as folk (us), stargate atlantis" - which is not.  If in doubt, create a temporary filter and filter the column you want by "contains" and then the fandom/reader/author/relationship that you want.
• If you try and edit any of the headers, or any data in columns A through H, you'll get an ugly "Hey, you can't edit a protected cell!" message. Don't worry about that - just know you can only edit columns I and J.

Questions?  Concerns?  Let me know!

EDIT: If you can signalboost this somewhere, please and thank you!  And let me and others know where so it can be tracked (so it's not boosted to the same community multiple times, etc).

EDIT 2: I froze the top row and column A per request.

EDIT 3: If a row is completely shaded GREEN that means one of two things: Dark green means that the issue is resolved (the file is in the archive, and the archive entry has been updated with the new link). Light green means that it's something that the archivists have already found and you needn't worry about it.

EDIT 4: If column J is shaded TAN that means that someone has located that podfic and filled in a location for the MP3/M4B.

Comments

[squidgiepdx]

In the morning I will color code the ones mific logged, yes. :)

[cathexys]

Thank you!!!!

[cathexys]

I hate to be the squeaky wheel, but it's so much easier to just look for the ones still missing. Could you possibly color all of the found ones? (It also helps to keep the lines. Is there a way to globally alternate with a slight highlight on every other line so as to know where everything is?)

I still have a couple of my big fandoms to go through and fill in, but staring at the spreadsheet and trying to find the correct line while I search my drives is straining my eyes something fierce...

[squidgestatus]

I've colored column J if it's filled in.

[cathexys]

Yeah, but that doesn't help when I'm looking through the names. When I'm on the left side of the sheet with the title and fandom, I can't see if it's already found and need to move to the right for every line (I had it really tiny to have both in my field of vision at the same time, but that's where the tiny lines messed me up...)

It's OK. I'll slowly work my way through. Clearly no one else seems to have accessibility issues with the spread sheet, so I'll just have to stop more often.

Thanks for responding so quickly!

[squidgestatus]

Done! I had to do a lot of Google to figure that out.

[cathexys]

You rock so hard!!! I think you might have seen how fast I could get through stuff having only to search for what was missing (esp in SGA!)

I'll leave SPN/J2 for tomorrow :)

THANK YOU!!!

[aceoftigers]

THANK YOU!!!! cathexys is right, that helps SO much!