Research Spreadsheets
From time to time it’s useful to compile spreadsheets of an author’s oeuvre. This page lists some of the spreadsheets our volunteers have created.
Creating a new spreadsheet
If you’d like to create a spreadsheet to catalog possible items to include in one or more omnibuses, please start by copying our omnibus research template.
You can see an example of how this spreadsheet might be filled out.
-
Change the title of the spreadsheet to something relevant to your research, like “Oscar Wilde Poetry.”
-
When copy and pasting or moving rows or columns, make sure to paste values only (with ctrl + shift + v) to prevent damaging the automatic formatting in the spreadsheet.
-
Include the author’s entire corpus, even if some items aren’t in the U.S. public domain yet, or if transcriptions or scans aren’t available, or if you feel items don’t fit the S.E. collections policy. This will help us to better understand the author’s entire corpus, and to continue adding to omnibuses over time as items gradually enter the public domain. If an item isn’t in the public domain yet, it’ll be automatically colored red.
-
You may add additional columns after “Notes,” but leave the basic columns intact.
-
Once you’ve actually added an item to an omnibus, check the “In omnibus?” field to indicate that it’s been included in a real S.E. omnibus and future producers no longer have to consider it.
-
Remember that you’re creating a spreadsheet for future producers, not just for yourself. Don’t include notes to yourself, obscure abbreviations, or information that would clutter the overall vision; don’t significantly stray from the template, or overwhelm future producers. Oftentimes, less is more.
Spreadsheets
Ebooks that can be worked on immediately
These spreadsheets are for ebooks that can be worked on today. Rows in yellow are items that can be added to an omnibus immediately.
Help wanted
These spreadsheets are known to be incomplete, and we need help to complete them.
-
Algernon Blackwood — Works (transcriptions and page scans needed)
-
Langston Hughes — Poetry (spreadsheet only contains work up to 1927; we have to update it for his entire corpus)
-
Georgia Douglas Johnson — Poetry (spreadsheet only contains work up to 1928; we have to update it for her entire corpus)
-
Frank Belknap Long — Short Fiction (see this full bibliography)
Incomplete because not fully P.D. yet
These spreadsheets are for ebooks that we host that we consider to be currently complete, but whose author still has more work that is not yet in the public domain. Therefore, we’ll have to continue adding to these ebooks in the future as more work enters the public domain.
Rows in yellow or white are items which may possibly be added to existing omnibuses immediately. Some may be missing information, usually page scan sources to verify their text and publication date; we need help to fill in that missing information so we can complete these omnibuses.
Rows in red are items which are not yet in the public domain.
Complete
These spreadsheets are for ebooks that are complete, and in which the author’s entire corpus is in the public domain. We don’t expect to add any more items to these ebooks.
Legacy
These spreadsheets haven’t been converted to the new spreadsheet template yet. They’re for ebooks which we have already produced, but may still need more work.