Science Fiction Awards Spreadsheet

ectoplasm · 08-22-2011, 10:56 PM

I created a list of the science fiction books that won, or were nominated for, the Hugo, Nebula, Arthur C. Clarke, Philip K. Dick, and Locus awards. As a Sci-Fi fan, I found this helpful in deciding what to read on my Kindle.

Here is the link to the list

The list is sorted by score, and then by title. An award win=2, a nomination=1. The awards are listed with W and N for won or nomination.

I started this list using dugbug's spreadsheet from this post:
https://www.mobileread.com/forums/showthread.php?t=24766

The following are some improvements I'm considering:
1) Add a column indicating if there is an E-book available for the title
2) Link the titles to Amazon
3) Add the nominations for the Arthur C. Clark awards
4) Add other awards

Other thoughts:
-- I'm wondering if the formula should be more complex, for example, add more weight to some awards, like Hugo and Nebula.
-- There are other awards. See this Wikipedia page: http://en.wikipedia.org/wiki/List_of...fiction_awards
I'm not that familiar with how they all compare in terms of value and which ones should be included. I'm open to suggestions.

ChefDude · 08-23-2011, 06:10 AM

I have bookmarked the SciFi Masterworks page on my iPhone

http://en.wikipedia.org/wiki/SF_Masterworks

I don't think it contains nominations though.

ectoplasm · 08-23-2011, 09:02 AM

The SF Masterworks are a series of previously published books chosen by a publisher. It's not really an award, although they do choose good books IMO.

The Hugo Award is an award voted by fans.

The Nebula Award is an award voted by authors.

With the combination of the Hugo, Nebula, Arthur C. Clarke, Philip K. Dick, and Locus awards and their nominations, there are currently 644 distinct titles.

curtw · 08-23-2011, 05:16 PM

Great stuff! However, I would seriously recommend adding the John W. Campbell Memorial Award winners as well.

Not to be confused with the John W. Campbell Award for Best New Writer, which is awarded at the Hugos, but is given to an individual, not to a title.

C.

ectoplasm · 08-23-2011, 10:21 PM

Quote:

Originally Posted by curtw

Great stuff! However, I would seriously recommend adding the John W. Campbell Memorial Award winners as well.
C.

Good suggestion. That looks like a good award to add.

I'm also working on an improved format for the table. I've given up on trying to bend the Google spreadsheet to my will, so I'm writing code to generate the table the way I want. Should be ready soon.

KenJackson · 08-23-2011, 10:51 PM

Very Good! Thank you.

I've never used a google spreadsheet before. Is it possible to sort by column?

When it comes to SciFi, I'm always interested in the most recent stuff first. There are less likely to contain unknowns that are now known (e.g. intelligent life and canals on Mars?), and more likely to incorporate intriguing new real science (carbon allotropes, nanomachines) in plausible, clever ways.

ectoplasm · 08-24-2011, 08:18 AM

Quote:

Originally Posted by KenJackson

Very Good! Thank you.

I've never used a google spreadsheet before. Is it possible to sort by column?

When it comes to SciFi, I'm always interested in the most recent stuff first. There are less likely to contain unknowns that are now known (e.g. intelligent life and canals on Mars?), and more likely to incorporate intriguing new real science (carbon allotropes, nanomachines) in plausible, clever ways.

Sorting by date, and then score, is a good idea, and I plan to implement that. I'm going to have to use one of the award dates for the title, as the 600+ distinct titles in the list do not include their publication dates.

Google spreadsheets can sort columns, but I've given up going in that direction. I think you'll find the new technique will be significantly better. I expect to have the first version online later today.

ectoplasm · 08-24-2011, 07:56 PM

As promised, here is a link to the new version:
http://scifiawards.herobo.com/

This is still rough, but it demonstrates my basic intent, and I think it's much more readable than the Google spreadsheet. It is sorted by score in descending order, then title.

There is still more to do. More award data will be added, and at least one additional sort will be added. The next sort will be primary by award year descending, and secondary by either title or author.

Comments and critiques are welcome.

VicLavigne · 08-24-2011, 11:59 PM

I have really enjoyed looking over this list. Lots of books there that I recall reading. I think that it would be a good idea if you could tag the books that have released as ebooks, give us a chance to find them.

Vic

ectoplasm · 08-25-2011, 06:23 PM

@VicLavigne: I think an ebook indicator is next. I'm at the point where I will only consider a book if there is ebook version.

Nancy Fulda · 08-26-2011, 05:32 AM

Quote:

Originally Posted by ectoplasm

@VicLavigne: I think an ebook indicator is next. I'm at the point where I will only consider a book if there is ebook version.

+1 on the ebook indicator. That would be very handy.

Dazrin · 08-26-2011, 05:27 PM

Quote:

Originally Posted by ectoplasm

As promised, here is a link to the new version:
http://scifiawards.herobo.com/

This is still rough, but it demonstrates my basic intent, and I think it's much more readable than the Google spreadsheet. It is sorted by score in descending order, then title.

There is still more to do. More award data will be added, and at least one additional sort will be added. The next sort will be primary by award year descending, and secondary by either title or author.

Comments and critiques are welcome.

Bummer. I just found this and can't access the new site at work (blocked by work filters). A Google spreadsheet would have been great.

miguel1626 · 08-26-2011, 05:37 PM

Just skimming through your table brought back some fond memories - many of my favorites are there. I'm sure it'll serve as inspiration for further reading (alas, my to-read list is already too long).

ectoplasm · 08-27-2011, 03:27 PM

I started adding ebook indicators. I only got through the first 50 (of 643). It is a manual process. If anyone is willing to help out, let me know.

The ebook column uses the following codes:
+K = Kindle version available
-K = Kindle version not available
+E = EPub version (probably B&N Nook) version available
-E = EPub version not available (or not found)

I decided to break it down this way so it's possible to know if something has or has not been checked. After doing this, I'm starting to think a better way is to make a separate K and E column with Y or N or blank for each column.

@Dazrin: The Google spreadsheet was not even close to being as readable as the current version. I'm guessing your workplace filters out *.herobo.com because it offers free hosting. That's unfortunate, but I can't see making a change unless it's blocked for a large percentage of users.

Dazrin · 08-31-2011, 11:50 AM

Quote:

Originally Posted by ectoplasm

@Dazrin: The Google spreadsheet was not even close to being as readable as the current version. I'm guessing your workplace filters out *.herobo.com because it offers free hosting. That's unfortunate, but I can't see making a change unless it's blocked for a large percentage of users.

Not a problem, I just didn't get to satisfy my "I want to see it now" impulses.

08-22-2011, 10:56 PM	#1
ectoplasm Addict Posts: 255 Karma: 1151364 Join Date: Aug 2009 Device: Aura HD and H2O	Science Fiction Awards Spreadsheet I created a list of the science fiction books that won, or were nominated for, the Hugo, Nebula, Arthur C. Clarke, Philip K. Dick, and Locus awards. As a Sci-Fi fan, I found this helpful in deciding what to read on my Kindle. Here is the link to the list The list is sorted by score, and then by title. An award win=2, a nomination=1. The awards are listed with W and N for won or nomination. I started this list using dugbug's spreadsheet from this post: https://www.mobileread.com/forums/showthread.php?t=24766 The following are some improvements I'm considering: 1) Add a column indicating if there is an E-book available for the title 2) Link the titles to Amazon 3) Add the nominations for the Arthur C. Clark awards 4) Add other awards Other thoughts: -- I'm wondering if the formula should be more complex, for example, add more weight to some awards, like Hugo and Nebula. -- There are other awards. See this Wikipedia page: http://en.wikipedia.org/wiki/List_of...fiction_awards I'm not that familiar with how they all compare in terms of value and which ones should be included. I'm open to suggestions. Last edited by ectoplasm; 08-25-2011 at 06:21 PM.

08-24-2011, 07:56 PM	#8
ectoplasm Addict Posts: 255 Karma: 1151364 Join Date: Aug 2009 Device: Aura HD and H2O	As promised, here is a link to the new version: http://scifiawards.herobo.com/ This is still rough, but it demonstrates my basic intent, and I think it's much more readable than the Google spreadsheet. It is sorted by score in descending order, then title. There is still more to do. More award data will be added, and at least one additional sort will be added. The next sort will be primary by award year descending, and secondary by either title or author. Comments and critiques are welcome. Last edited by ectoplasm; 08-25-2011 at 06:21 PM.

08-27-2011, 03:27 PM	#14
ectoplasm Addict Posts: 255 Karma: 1151364 Join Date: Aug 2009 Device: Aura HD and H2O	I started adding ebook indicators. I only got through the first 50 (of 643). It is a manual process. If anyone is willing to help out, let me know. The ebook column uses the following codes: +K = Kindle version available -K = Kindle version not available +E = EPub version (probably B&N Nook) version available -E = EPub version not available (or not found) I decided to break it down this way so it's possible to know if something has or has not been checked. After doing this, I'm starting to think a better way is to make a separate K and E column with Y or N or blank for each column. @Dazrin: The Google spreadsheet was not even close to being as readable as the current version. I'm guessing your workplace filters out .herobo.com because it offers free hosting. That's unfortunate, but I can't see making a change unless it's blocked for a large percentage of users. Last edited by ectoplasm; 08-27-2011 at 03:30 PM.*

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Science Fiction Awards Spreadsheet	ectoplasm	Reading Recommendations	6	08-24-2011 08:16 PM
Have you voted for the Locus Awards yet? [Science Fiction & Fantasy]	Vintage Season	General Discussions	6	04-10-2011 09:10 AM
Historical Fiction to Science Fiction/Fantasy	Georgiegirl2012	Reading Recommendations	12	11-13-2010 07:22 PM
Seriously thoughtful When science fiction meets science fact	pilotbob	Lounge	51	04-25-2009 03:30 PM
Soft on the Science - Science Fiction	Domokos	Reading Recommendations	0	01-29-2006 09:18 PM

08-23-2011, 06:10 AM	#2
ChefDude PRS505 owner Posts: 15 Karma: 11850 Join Date: Jun 2009 Location: london Device: Sony PRS-350, 505	I have bookmarked the SciFi Masterworks page on my iPhone http://en.wikipedia.org/wiki/SF_Masterworks I don't think it contains nominations though.

08-23-2011, 09:02 AM	#3
ectoplasm Addict Posts: 255 Karma: 1151364 Join Date: Aug 2009 Device: Aura HD and H2O	The SF Masterworks are a series of previously published books chosen by a publisher. It's not really an award, although they do choose good books IMO. The Hugo Award is an award voted by fans. The Nebula Award is an award voted by authors. With the combination of the Hugo, Nebula, Arthur C. Clarke, Philip K. Dick, and Locus awards and their nominations, there are currently 644 distinct titles.

08-23-2011, 05:16 PM	#4
curtw Outside of a dog Posts: 871 Karma: 4457646 Join Date: Dec 2007 Location: Houston, TX Device: Kindle Voyage	Great stuff! However, I would seriously recommend adding the John W. Campbell Memorial Award winners as well. Not to be confused with the John W. Campbell Award for Best New Writer, which is awarded at the Hugos, but is given to an individual, not to a title. C.

08-23-2011, 10:51 PM	#6
KenJackson Addict Posts: 256 Karma: 112042 Join Date: Oct 2010 Location: Maryland, USA Device: Sony PRS-650	Very Good! Thank you. I've never used a google spreadsheet before. Is it possible to sort by column? When it comes to SciFi, I'm always interested in the most recent stuff first. There are less likely to contain unknowns that are now known (e.g. intelligent life and canals on Mars?), and more likely to incorporate intriguing new real science (carbon allotropes, nanomachines) in plausible, clever ways.

08-24-2011, 11:59 PM	#9
VicLavigne e-reading since 2008 Posts: 197 Karma: 112730 Join Date: Oct 2008 Location: Hinesville Georgia Device: Nook STR, Sony PRS-T1	I have really enjoyed looking over this list. Lots of books there that I recall reading. I think that it would be a good idea if you could tag the books that have released as ebooks, give us a chance to find them. Vic

08-25-2011, 06:23 PM	#10
ectoplasm Addict Posts: 255 Karma: 1151364 Join Date: Aug 2009 Device: Aura HD and H2O	@VicLavigne: I think an ebook indicator is next. I'm at the point where I will only consider a book if there is ebook version.

08-26-2011, 05:37 PM	#13
miguel1626 Great Old One Posts: 189 Karma: 998538 Join Date: Sep 2010 Location: L1 Orbit Device: Kindle Oasis 2, iPad Pro, iPhone 8 Plus	Just skimming through your table brought back some fond memories - many of my favorites are there. I'm sure it'll serve as inspiration for further reading (alas, my to-read list is already too long).

Advert

Advert