Is anyone else obsessed with Excel spreadsheets? I make them for just about anything. So of course, I have made one to keep my progress with my 100 books up to date. Here's a link to it, in case you want to use it yourself:
Fill in the Gaps Project Excel Spreadsheet
It updates automatically, so it's really easy. Plus, it's kinda pretty ;)
Jenna.
skip to main |
skip to sidebar
Search This Blog
The 100 List
Labels
The Books: Just a Click Away
Blog Archive
-
▼
2009
(335)
-
▼
April
(99)
- Complete List of Books...
- finished: MIDDLESEX, Jeffrey Eugenides
- Alyce, Book Review, *Suzanne Collins, *The Hunger ...
- eBook Reading on the Rise
- Mercedes Thompson Series by Patricia Briggs
- Project Fill-in-the-Gaps
- Statistical Update!
- Many Apologies!
- The Biblio Brat's List
- Nancy, Book Review, *I Am The Messenger, *Markus Z...
- Steven, Book Review, *J. M. Coetzee, *Waiting for ...
- Hello Ello 2: Contest to Win an Autographed Copy o...
- Excel Spreadsheet
- The Red Queen - Margaret Drabble
- We hit 50 lists!
- Finished #2, The Member of the Wedding
- Comments and Statistics
- Jenna's 100 List
- The Secret History by Donna Tartt
- Glengarry Glen Ross Review
- Aerin's List
- Becky's First Three Books
- Kelly's List
- Linda's 75 In Five Years
- Matthew, Book Review, *Stanislaw Lem, *Solaris, *F...
- Lucky Jim, Lucky Reader
- Native Son, by Richard Wright
- Matthew, Book Review, *Evelyn Waugh, *A Handful of...
- Megan O, *Watership Down, *Richard Adams
- Middlemay!
- Melissa W.'s list
- Crystal's Fill-in-the-Gaps List
- Moby Dick - Herman Melville
- Beth's List
- Cheer Up, Phil (a review)
- New Nabokov to be published
- Alyce's List
- The Pulitzer Prizes: 10 Forgotten Winning Novels
- Matthew's List
- Lesley's List
- Kristina's List
- Nancy's List
- Finished Odyssey and Ragtime
- Lauren's List
- Katrina's List
- Woopsies (Zadie Smith, WHITE TEETH)
- Mya Barrett *An Old Fashion Girl *Louisa May Alcott
- Liver Exercises and Willie Voltaire
- Great Gatsby
- Alyssa's World Lit List
- Leslie
- Finished The Awakening
- Steven's List
- Susan's list
- Goedi's List
- Whitney's List
- Lara's List
- Middlemarch, George Eliot
- Laza's List
- Time: 100 all-time Novels
- Tammy's list
- Review: Shakespeare's Macbeth
- little 5-title update (Moonrat)
- Rachel, Acceptable Gaps
- Rachel's List
- iasa 5 Down *The ZooKeeper's Wife
- Shelly's List
- Jason's List
- Stephanie's List
- Amanda Snow's List
- Julie, Let's read this together, *Tolstoy, *War an...
- first book down!
- verdict, please
- Most Common Books and Authors
- Michelle's List
- Amy's List
- Myza's 100
- Megan's List
- Becky's List
- Trixie
- Mya Barrett
- Nom de Gare's List
- Briony's List
- Julie's List
- Books in Common
- Jennie's List
- Dana's Project "Fill in the Gaps" List
- Andromeda's List
- Vasilly's List
- Merry Monteleone's List
- Jen at Corrodentia Weekly's List
- PurpleClover
- Editorial Ass: oh hey, we found us that resident m...
- Lisa's List
- Amanda's Fill-in-the-Gaps List
- iasa's 100
- Moonrat's Fill-in-the-Gaps List
- Emily's 100
- Welcome!
-
▼
April
(99)
Book Review Sites
Want to Join?
Just drop me an email at emilycross09@gmail.com
Show Your Support
<a href=”http://fillinthegaps100.blogspot.com/”><img src=”http://i223.photobucket.com/albums/dd257/RensFeathers/Graphics/100books2.jpg” /></a>
The Authors
Members BlogRoll
Fellow FITGers!
FITG GOODREADS
Fill in the Gaps Project's bookshelf: read
5 members
WELCOME to the FILL THE GAPS 100 PROJECT Ever have a book on your bookcase that you always say yo...
5 membersWELCOME to the FILL THE GAPS 100 PROJECT Ever have a book on your bookcase that you always say yo...
Copyright The Fill in the Gaps: 100 project. Powered by Blogger
Blogger Templates created by Deluxe Templates. Wordpress designed by Simplywp
Blogger Templates created by Deluxe Templates. Wordpress designed by Simplywp
6 comments:
Wow, Jenna what a nice spreadsheet. Good work!
What do you put in the read column to make it count the book.
You use a couple of formulas.
1. a total at the bottom, which is just a SUM of the entire read column.
2. at the top I added that the total number of books was 100
3. the total read was just a copy of the total from the bottom
4. the books remaining is 100 - the total read.
Hope this makes sense! You can see the formulas if you click on the individual cells.
Sorry. I understand that part but apparently you have to put a check or X or something in the "READ?" column in order for it to populate the Total Read at the top and the bottom. Not sure if that makes sense. If I put a 1 in the read column it puts a 1 at the bottom and so forth but it doesn't add it up at the top. This might just be too confusing to use that column the way it is meant to be. Sorry for the confusion.
Sorry I though you were asking about the formulas. You should just have to put a 1 next to what you've read in the read column.
Perhaps something got mixed up when it was uploaded, because it updates in the books read / books remaining cells in the original that I have here. If you shoot me your email I can try sending it to you directly, if you want.
Okay. I got it. Thanks again for the help!!
Post a Comment