Download our database-in-progress. Also, information on how to view it.
|Home | By Author | By Title | By Filename | What's New | Help|
What's new with the May 11, 2013 version? It's current to the April 29 update, indexing 3,605 stories. Again, there is now a field for story word count (Column E), which is sort of accurate, using a formula based on text file size in kilobytes. If you're searching and filtering on themes, please use the combined themes field (now Column T).
We're working on a fanfic database that will perform two main functions: help you to pinpoint just the stories you're looking for, by searching on a variety of criteria; and also to drive the fanfic archive, to make updating the site a more streamlined, automated process. But it's taking longer than we had planned.
* UPDATED May 11, 2013 Download the database:
OpenOffice Calc version Excel version Text-delimited version
If you don't want to download a file, try looking at the sheet as a Google doc.
Click to view full-size screen shot of OpenOffice Calc, a free Excel clone
We're sitting on a pile of data, though. Editor-in-Chief LabRat has been entering story records into an Excel spreadsheet, and we'd like to make a recent version of the sheet available to you to download.
You could load the data into your own software for some offline searching. What kind of software? A spreadsheet like Microsoft Excel, OpenOffice Calc or LibreOffice Calc would work. Basically anything that will accept a delimited text file.
If you're not interested in loading the data offline, we've put a version of the sheet online in a Google Docs spreadsheet.
Don't have a spreadsheet or database program already? Consider giving OpenOffice Calc a try. It's part of an open-source, completely free office suite called OpenOffice, which is available for download at openoffice.org. OpenOffice is compatible with Microsoft Office and offers a counterpart for all the major components in the Microsoft Office suite of programs. You can read and write Microsoft Word files in OpenOffice Writer and read/write Excel files in OOo's Calc.
OpenOffice is cross-platform, offering versions for Windows, Macintosh, Linux and Unix. It's a rather large download, though.
If you have an older G3, G4 or G5 Macintosh computer, you won't be able to run OpenOffice on your Mac, author Marcus Rowland tells us. He advises you use a copy of LibreOffice, a fork of OpenOffice which is file-compatible and supports older Macs.
Need help on searching, sorting and filtering all that data? We've typed up some tips and solicited more over on the Lois & Clark Fanfic message boards in this thread.
Story count discrepancy
Wondering why the story count on the data sheet doesn't match the count on the home page? One reason is that this version of the sheet is a bit behind the weekly updates. Another is that over the years some authors have withdrawn stories for various reasons, and we haven't changed the count to match. That'll happen when the archive is finally database-driven and the story count is calculated by the database.
|Home | By Author | By Title | By Filename | What's New | Help||^^ To Top|