squidgestatus | The Jinjurly Missing Files Spreadsheet!

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.

Page 1 of 2 << [1] [2] >>

Flat | Top-Level Comments Only | Expand All

From:

bluedreaming

Thanks for putting this together!
Any change you could freeze the top labels and left labels? It would help with navigation in the middle of the sheet. Thanks!

From:

squidgestatus

Done!

The Jinjurly Missing Files Spreadsheet!

Page Summary

Active Entries

Style Credit

Expand Cut Tags