Spreadsheet v3.3
Thanks to all of you and your feedback, I’m rolling out v3 of the spreadsheet today a month short of the spreadsheet’s 2nd anniversary. This edition includes
- Wikipedia/Google Books hyperlinks: updated these where new information had become available.
- Amazon links: deleted these because, quite frankly, they bring in virtually nothing and clutter up the spreadsheet. The only people making money from links to Amazon are Amazon.
- Toned down graphics: Not as garish as it used to be!
- Better filtering: your feedback means the new version filters tbr and r columns along with your titles.
- Frozen top section: Headings and totals at the top are now frozen in place so that you can see them when you scroll down.
- Totals sheet: Another request that I’ve included is that now you get a separate sheet that lists progress with both lists together for the die hard reading challengers among us.
I’ve just pipped the 200 mark at 205 books with 86 to be read. What about you?
DOWNLOAD INSTRUCTIONS – READ THIS AND SAVE THE SUPPORT!
Just click the button you need below or right click and Save Target As…. You should get a zip file (because IE7 can’t cope with Excel 2007 files being downloaded any other way). You’ll need to unzip the file to get a save-able copy. If not, it will be a read-only copy. That’s no problem either. If it’s read only then use Save As… and give it your own filename.
Please note that if you can’t figure it out and want me to email you a copy, you’ll need to provide me with as much info as possible about why you can’t open the spreadsheet and what program, OS, browser etc you’re using before I’ll oblige. Help me to help you! Cheers.
FAQs
I’ve entered in all my r and tbr cells but the totals don’t change. Why is this?
You need to save the file. Once you do, it will calculate the values at the top of the spreadsheet.
Why can’t I save the file?
Did you read the instructions above? You need to extract it first before you can save it.
If you truly cannot get either version to work, comment on this thread. Include your email and let me know which version you want. I’ll send you one as an attachment.
If anyone wants to thank me for this, get in touch. That tbr list can hold more!
Version History:
- v1.0 – released 30 May 2007
- v2.0 – released 30 August 2008
- v2.1 – released 30 December 2008 – 2008 list reordered to actual updated edition, 2 books added that were missed off 2008 list, 2 books moved from 2008 list to 2006 list.
- v3.0 – released 30 April 2009 – removed amazon links, improved filtering, added frozen panes, added totals sheet, changed graphics
- v3.1 – released 01 May 2009 – dealt with some typos, corrected formulas to actually give reading rates for those lists alone, changed feedback link to v3 page (all thanks to Plekter!)
- v3.2 – released 19 May 2009 – removed an erroneous entry to Ken Kesey from the removed list (thanks to Steven!)
- v3.3 – released 19 June 2009 – changed totals that formulas were using to calculate – my bad (thanks to Daniel for pointing this out. Great attention to detail man.)
Hopefully that’s it for a while!
Download Totals:
version 1 – Excel 03 – 05/07 to end 08/08: 17,953
version 2 – Excel 07 – 08/08 to end 03/09: 6478
version 2 – Excel 03 – 08/08 to end 03/09: 3790
version 3 – Excel 07 – 04/09 to end 05/09: 992
version 3 – Excel 03 – 04/09 to end 05/09: 601
TOTAL: 29814
[...] 1001 Books spreadsheet v3 [...]
Pingback by Arukiyomi » 1001 Books Spreadsheet v3 released — May 1, 2009 @ 8:03 am Quote this comment
Thanks heaps! My mom’s happily typing away (r, tbr)
Does anyone know if there’s such a list for mystery/detective books??
Comment by Corien — May 1, 2009 @ 8:54 pm Quote this comment
I’m one of the 93 RSS readers
I found a few “top 100″ detective book lists online and I’m replacing your titles/authors in the xlsx. Works fine and I can still keep count with ‘r’ and ‘tbr’, thanks again, this time from me as well !!
Comment by Corien — May 2, 2009 @ 8:21 am Quote this comment
Yes! I love these updates. You are amazing.
Comment by Lu — May 2, 2009 @ 7:45 pm Quote this comment
Hi, I love your spreadsheets! Love em!
Couple of things on the 2003 sheetv3:
+ Love the totals! Great!
+ frozen panes: Makes it so much more easy to work with!
+ the tbr pile count: inspiring!!
- On the 2008 sheet it says: “To complete the books removed from the 2006 list, you need to read an average of
” (I can offcourse fix this text for my self…no biggie.) And this text seems to be missing altogether on the totals sheet.
- b10 and b11 in both 2008 and removed 2006 seems to refer to the total, and not the amount of books needed to read to complete the 2008, and 2006 seperately.
- The link in faq goes to the v2 page on here…
Keep up the good work!
Comment by Plekter — May 14, 2009 @ 4:06 pm Quote this comment
you are a star… thanks for the praise and excellent feedback. I was in a bit of a rush getting this out hence the errors. I’ve fixed them all now though.
Comment by Arukiyomi — May 14, 2009 @ 6:00 pm Quote this comment
Beautiful! Thank you so much!
Comment by Plekter — May 15, 2009 @ 9:20 am Quote this comment
Please note that Sometimes a Great Notion by Ken Kesey is erroneously listed in the “removed books” in the v.3 spreadsheet, item #151. (It also appears in the 2008 Edition tab #410.) I checked the publisher’s website, and it is still in the 2008 edition. I don’t think anything else should be listed in its place. I did an independent listing of the two editions and came up with a total of 1283 books, so there should be only 282 on the removed list.
Comment by Steven — May 19, 2009 @ 3:11 am Quote this comment
thanks for letting me know… sorted and saved. I thought I’d got rid of that mistake ages ago!
Comment by Arukiyomi — May 19, 2009 @ 7:42 am Quote this comment
This is amazing! I came across the book listing these recently and was definitely daunted by the task of creating my own spreadsheet – and I’m definitely a spreadsheet person! Thanks so much for not only doing all the work, but also for sharing it with us!
Comment by Bucket — May 22, 2009 @ 10:13 pm Quote this comment
This could be a stupid question. Do you re-enter all your data every time you have a newly updated 1001 excel file? It just seems like a lot of work for me (the user, that is). Just wondering if people have a better way to transfer the data over. Simple copy-paste? Thanks for sharing the spreadsheets, they’re wonderful!
Comment by mee — May 25, 2009 @ 3:04 am Quote this comment
I personally don’t change spreadsheets. I’ve got my own version which I hack as I want. I have thought about the fact that anyone switching from version to version would need to reenter data but I personally don’t have time or inclination to figure out a way to udpate automatically. Copy and paste would work and some of the colours might change but that’s a small price to pay.
Let’s face it though mee, re-entering your data may seem like a lot of work for you the user, but you might want to think about the work it took to create and then update this spreadsheet in the first place. It certainly seems like a lot of work to me
Comment by Arukiyomi — May 25, 2009 @ 1:09 pm Quote this comment
[...] using the fantastically awesome spreadsheet by Arukiyomi to keep track of those books I’ve read and will be posting reviews on books as I [...]
Pingback by 1001 Books Challenge « Immersed In the Written Word — May 27, 2009 @ 8:47 pm Quote this comment
Great spreadsheet! I was actually making my own one, but it was just too much work with the 2nd edition
I found 2 small errors though:
- In v3.2, you removed the erroneous entry. However, the formulas in the 2006 sheet (cells B10 & B11) are still based on 283 books. Same goes for the formulas in cells B13, B14, D8 & D10. These should be 1283 instead of 1284.
- The cells D5 & D7 in the 2006 sheet are based on 1001 books. These should also be 282 books of course!
Comment by Daniel — June 6, 2009 @ 10:07 pm Quote this comment
Daniel… thanks so much for the detailed feedback on the errors. When I have time, I’ll set about fixing them.
Comment by Arukiyomi — June 9, 2009 @ 3:27 pm Quote this comment
Thank you soooooo much for creating this spreadsheet! It has saved me a lot of time in trying to create one myself.
Comment by Elizabeth — June 10, 2009 @ 4:43 am Quote this comment
This spreadsheet looks great, but I think I would prefer to use the 2006 list of books, rather than 2008. So for me it would be better to list the 2006 list and then in a separate tab the additions in 2008; instead of the 2008 list and removals from 2006. If that made any sense…Or just the two lists without comparing what’s been added/removed.
Comment by Constance — June 16, 2009 @ 4:38 pm Quote this comment
Here’s an idea. Three tabs: 1) Common books in both 2008 and 2006 lists, with additional books to read for 2) 2008 version and 3) 2006 version.
Comment by Constance — June 16, 2009 @ 4:45 pm Quote this comment
wow… suggestions for v4 coming in already! That’s one for the future Constance for sure. I like the suggestion but, right now, the thought of putting the work in is just not nice…
Comment by Arukiyomi — June 19, 2009 @ 7:45 pm Quote this comment
@ Daniel… those changes made mate and v3.3 is now available with those corrections.
Comment by Arukiyomi — June 19, 2009 @ 8:04 pm Quote this comment
[...] In the meantime, however, I will share with you as my pal over at Regular Rumination has shared with me, an amazing list of 1000 books to read in one’s lifetime. Click here. [...]
Pingback by Reading Fail « A Book Blog. Period. — July 10, 2009 @ 10:13 pm Quote this comment
Hello…love the spreadsheet, and thanks for all your hard work!!
Quick question, though – I used the first spreadsheet (I think) but I’m now a Mac user. Is there anyway to get a copy that will work on a Mac?
Unfortunately, I have no idea what this will entail, since I don’t have Microsoft Office for Mac…would a pdf work? If it can’t be done, no biggie, but I do miss having it.
Anyway, thanks again!
Comment by Bibliolatrist — July 14, 2009 @ 11:44 am Quote this comment
@Bibliolatrist: hmmm… well, when it comes to Macs I really have no idea either. I think the only way to go would be Office for Mac. pdf files are not interactive so you’d only get an image of the spreadsheet AFAIK. You could keep a cheap pc dedicated to just running your 1001 list – now that’s commitment!
Comment by Arukiyomi — July 14, 2009 @ 6:22 pm Quote this comment
@Bibliolatrist with regard to the Mac issue, save the spread sheet as a .csv file and the you can open it with any spreadsheet program such as OpenOffice, which will also, mostly, handle all the macros etc as well. The cell formulas work fine it’s just the macros which struggle sometimes.
You could always get a virtual PC on the Mac and the MS office excel viewer, that’d work as well.
I am not aware of an excel viewer for the mac but ther might be one, search the MS site.
Comment by Imani — July 15, 2009 @ 2:32 pm Quote this comment
Still no Ayn Rand or Ray Bradbury. Fahrenheit 451 is what got me into reading again. (After high school ruined it for me)
Comment by Amanda — August 6, 2009 @ 4:22 pm Quote this comment
[...] of a list is this 1001 Books You Must Read Before You Die. To help you along, some people created a spreadsheet for it! I love lists but I don’t think I want my reading to be dictated by something like [...]
Pingback by For the Listless Bookworms « The Literary Pursuit — August 13, 2009 @ 1:23 am Quote this comment
This is a great list. I don’t think I’ll read them all, but a lot would be on my list.
Comment by Kelly — August 14, 2009 @ 12:27 am Quote this comment
heck out Google Docs also.
On 15 Jul 09, Imani wrote:
Comment by Imani — August 14, 2009 @ 2:30 pm Quote this comment
Can you give me a copy of the old version since I prefer my list with amazon links?
Comment by Kathlyn — September 17, 2009 @ 10:00 pm Quote this comment
Awesome spreadsheet! I bought the book last year, but am committing to finally reading at least twenty of the books from the 1990s/2000s and was looking for a spreadsheet with which to track my progress. You’ve saved me hours of prep work! Cheers.
Comment by RJ — September 19, 2009 @ 2:34 am Quote this comment
Thanks Arukiyomi! You’re the best, hehe. Keep up with this awesome site!
Comment by Kathlyn — September 19, 2009 @ 6:56 am Quote this comment
This spreadsheet is just so cool!
Im super excited of having this big listing of titles to go out and grab.
Thanks tons!
M
Comment by meli — September 19, 2009 @ 9:35 pm Quote this comment
[...] site kun je een excel-bestand downloaden waarop je kunt bijhouden welke boeken je al gelezen hebt : http://johnandsheena.co.uk/books/?page_id=730 Volgens dat ding heb ik er nu 33 gelezen en moet ik er 25 per jaar lezen om die lijst af te werken [...]
Pingback by 1001 boeken die je gelezen moet hebben... - Zita Forums — September 20, 2009 @ 9:34 pm Quote this comment
On 14 Jul 09, Bibliolatrist wrote:
@Bibliolatrist. I use a MacBook Pro with Office for Mac – which doesn’t open xlsx or docx files! So what I do is use Zamzar to convert these files online to xls or doc. As for Office software, as a couple of people suggested here, try OpenOffice and Google Docs (I use the latter a lot).
Comment by Ankita — October 9, 2009 @ 4:03 pm Quote this comment
Is there a search function for the spreadsheet? Pardon my ignorance but I just don’t know how to search for the books within the list.
Comment by Kathlyn — October 15, 2009 @ 4:39 pm Quote this comment
well, you could just download the list…
or go here: http://www.listology.com/list/1001-books-you-must-read-you-die
or (shock!) buy the 1001 books book
Comment by Arukiyomi — October 19, 2009 @ 7:35 am Quote this comment
I typed some ‘r’s, then I filtered the books by their authors names, typed some more ‘r’s, and no none of my ‘r’s match with the books I’ve read O__o Why?
Comment by Oatmeal — November 6, 2009 @ 2:39 pm Quote this comment
On 6 Nov 09, Oatmeal wrote:
which version of the spreadsheet are you using? This glitch was fixed in version 3.3 so if you’re not using that, please download it and try it. If you are, get back to me.
Comment by Arukiyomi — November 6, 2009 @ 5:17 pm Quote this comment
On 6 Nov 09, Arukiyomi wrote:
I was using v3.3. Then I deleted and re-downloaded it, and everything seems to work fine so far ^_~ But I have question – how do I cancel the sorting (A to Z, Z to A)?
Thanks ^_^
Comment by Oatmeal — November 6, 2009 @ 5:58 pm Quote this comment
I know when glitch appears! When I clicked on the link while using filter all data mixed up and now I have authors like Jonathan Dostoevsky (X_X) Btw, I found out how to cancel sorting… (^_^)/~~
Comment by Oatmeal — November 6, 2009 @ 6:34 pm Quote this comment
I’ve input my r’s and tbr’s AND saved, but my Totals formula doesn’t update
One thing: I’m using OpenOffice. Could that have something to do with it? Or is it merely OE (operator error)?
Comment by Crystal W — November 24, 2009 @ 10:53 pm Quote this comment
sorry to hear you’re having problems. I did try Calc for Open Office but I found it really couldn’t handle the spreadsheet well at all so it could well be that by opening the Excel file in Calc some of the formulae won’t work for you.
Sorry I can’t suggest any workaround.
Comment by Arukiyomi — November 25, 2009 @ 9:21 am Quote this comment
Hi. I really appreciate all the work you do on this, and, as a masochist, I keep this humiliating list on my computer. In spite of looking a gift horse in the mouth, is there any, any hope of alphabetizing the sections? It’s so hard to plow thru and when I do a search, I can’t insert it back into the master list.
Comment by M Bader — November 30, 2009 @ 4:40 pm Quote this comment
bom, com eu sou brasileira, terei que escrever em português, mesmo sendo fluente em ingles ;D
para começo, muitas pessoas dão ao comentario de que está lista seja só de livros de Romance ou até uma lista que DEVEMOS ler.
eu penso que, esses livros sejam pra podermos abrir nossas mentes pra outras coisas, sabermos mais que outras pessoas, aquelas que não leram .
obrigada ,thanks
Comment by Karine Elise — December 11, 2009 @ 8:36 pm Quote this comment
On 16 Jun 09, Constance wrote:
As a sort of followup to my earlier comment. I sort of implemented the suggestions myself, although, there’s a discrepancy somewhere (I come out one book off!) But perhaps it would be a good starting point or something…
Comment by Constance — December 16, 2009 @ 2:46 am Quote this comment
I dowloaded it on my mac computer. And I went to File>save>entered a name. I entered the rs but nothing seemed to happen.. please help me!
Comment by anon — December 17, 2009 @ 4:24 pm Quote this comment
Hi Constance… thanks for the suggestion. Your idea works, but only for those who are interested in what’s been removed. Most people are interested in the actual 1001 list as it stands for many reasons; that they feel the original 1001 list was too WASPcentric for example. We’ve got a new edition of the list due for March 2010 and, if things carry on the way they are, the spreadsheet as you suggest it will have less and less on the ‘common books’ tab over the years. So, for those reasons, I’ve decided to stick with the 1001 list as current and then add a tab for whatever’s removed for each edition. I do, however, have an idea up my sleeve for common books over the years but you’ll have to wait until the 4th edition of the list is published hopefully in late spring.
Comment by Arukiyomi — December 18, 2009 @ 10:53 am Quote this comment
you’re going to have to provide more info before I can help you at all. Bear in mind that I do not have a mac and have no idea how the spreadsheet performs on a mac. Others on this thread may be more help to you.
1. what version of the spreadsheet did you download – office 07 or 03
2. what program are you using to open the spreadsheet?
3. what have you done since posting the comment to get it to work?
Comment by Arukiyomi — December 18, 2009 @ 11:01 am Quote this comment
Wow… my first comment in Portuguese – great! Totally happy for you to post in whatever language you want. I’m a linguist and love languages. I did my best to understand your comment and then asked my mother, who lives in Portugal, to translate it as best she could. Glad you find the list helpful. What romance have you read off it?
Comment by Arukiyomi — December 18, 2009 @ 11:11 am Quote this comment
I have the same OpenOfficeproblem mentioned above. I find the calculations will only update if I put my cursor in the squares of the formulas and move it around a bit there, and THEN push CTRL+S,,, and then only the formula I messed with will update, and I have to repeat the process ofr all of them – and in a correct order. So whenever I enter a book now (had to reinstall my Excel but have lost the registration key
) there’s a lot more work than before to get it to update. Surely someone must have thought of some solution to this by now?
Can’t believe how much work you must have put down, by the way.
Vib
Comment by Vibeke — December 25, 2009 @ 3:35 pm Quote this comment
It works perfectly. Thank you so much!
Comment by Ee Hwee — January 3, 2010 @ 10:49 am Quote this comment
This list sounds amazing, unfortunately i can’t for the life of me get it to open, would you be able to e mail me a copy?
Thanks
Comment by Jon — January 21, 2010 @ 5:34 pm Quote this comment
Hey!
I’m trying to find an old version of the list from the 2006 edition. I think you used to have it available on your website. Do you still have a copy of it available? I’d really like a copy of it.
Thanks!
Comment by cmarcy — January 29, 2010 @ 3:15 am Quote this comment
the old editions of the spreadsheet are no longer available. The new edition has the 2008 list and the ones that were removed from the 2006 so all the books from the original list are there. My next edition will tell you which books were left on the 2008 list from 2006. In the meantime, if you want the 2006 list, you can find that at http://www.listology.com/list/1001-books-you-must-read-you-die
Comment by Arukiyomi — January 29, 2010 @ 5:59 pm Quote this comment