The Seasonal Reading Challenge discussion
OLD TASK HELP THREADS
>
Spreadsheet
date
newest »
newest »
Here's a link to my spreadsheet, as saved on Googledocs. I do have two tabs - one showing the listing of the tasks (and the books I'm thinking of reading for each), and one tab that shows the books, including ones I haven't assigned to a test yet. I'm still working on my plan, so don't mind the blanks!http://spreadsheets.google.com/ccc?ke...
Hope that helps!
Michelle
Solargalaxy_6 wrote: "Here's a link to my spreadsheet, as saved on Googledocs. I do have two tabs - one showing the listing of the tasks (and the books I'm thinking of reading for each), and one tab that shows the book..."oooh I so borrowing this, thanks for sharing
Thanks, Solar. I'm using your spreadsheet as my template as well.
Kathryn wrote: "Hey,For those of you who make a spreadsheet for the tasks in order to keep them organized, I was wondering if any of your might make it available to me that I might use??? If not, that is fine! T..."
Hi Kathryn - I tried to post my spreadsheet, but Goodreads accepts Excel's commands funk-ily. What I did was set up three columns: 1. Name of book and author 2. # of pages (left blank if I'm reading the audiobook) and 3. Date Posted to Goodreads. What's nice about Excel is that I can tally up my total pages read if my A-type personality decides to rear its ugly head.
I do similar to Amy in Excel - except I have a few more columns ... I have the task (shortened version of it), book and author, points, date read, rating out 5 and number of pages ... and this time I've added in a column for whether I own the book already, will do a swap for it, mooch it, borrow it from the library or buy it! I'll just use either an O, S, M, L or B (I'm not sure why really lol) ... so I get Excel to add up my points and number of pages for me.
I've got one. It's... a bit complicated... I've been tweaking it since last Christmas-ish. But I really like it because it's condensed enough to print out and take to the library with you... ;) If you'd like a copy, I'm willing to share, though—just PM me.There are other things I want to do with it (like have it automatically change the formatting when you check off a task), but I would need to re-learn how to use Visual Basic in Excel... and that's a bit much...
http://spreadsheets.google.com/pub?ke...Feel free to copy mine. I loved using the spreadsheet from the Summer Challenge. This time around, I altered it slightly.
Kathryn wrote: "Hey,For those of you who make a spreadsheet for the tasks in order to keep them organized, I was wondering if any of your might make it available to me that I might use??? If not, that is fine! T..."
Hey Katheryn, I'm happy to send you a copy of my Excel spreadsheet if you like. Contact me with your email info and I'll get it to you.
I have multiple columns, color-coding (multiple book tasks are color coded with the same shading, etc) and auto totals for pages read, books read, and point totals for completed tasks. It might be a bit confusing, but I find the colors help me identify stuff quickly.
I know, I'm a bit of a wonk, but I'm a business analyst. What can I say?
I'm happy to share if you'd like it.
Krista wrote: "Kathryn wrote: "Hey,For those of you who make a spreadsheet for the tasks in order to keep them organized, I was wondering if any of your might make it available to me that I might use??? If not,..."
What is a wonk? That's the second time someone in this group has used that word (the other time may have been you, too). Is that a regionalism?
Sara wrote: "I've got one. It's... a bit complicated... I've been tweaking it since last Christmas-ish. But I really like it because it's condensed enough to print out and take to the library with you... ;) ..."I've color coded mine--I make the shade darker as the book comes in from the library and then darker again when I finish the book. Because I am so absent-minded I also have a column to put the date that I posted the task to Cynthia.
It adds my pages and my points and calculates how many points I have left to earn (just because I can).
SuzieR wrote: "I do similar to Amy in Excel - except I have a few more columns ... I have the task (shortened version of it), book and author, points, date read, rating out 5 and number of pages ... and this time..."I never thought to have it tally my points - off to amend my spreadsheet. Thanks, Suzie !!
Hi there.Here is the link to the spreadsheet I made using Google Docs: http://spreadsheets.google.com/ccc?ke...
If it works for you, please feel free to use it. I have to go in and code which books are library, owned, mooched or bought, although I am trying to use what I have or the library.
Jennifer
Tanja wrote: "http://spreadsheets.google.com/pub?ke...Feel free to copy mine. I loved using the spreadsheet from the Summer Challenge. This time around, I altered it slightly."
I really like your spreadsheet, but I can't figure out how to copy it.
Sara wrote: "I've got one. It's... a bit complicated... I've been tweaking it since last Christmas-ish. But I really like it because it's condensed enough to print out and take to the library with you... ;) If you'd like a copy, I'm willing to share, though—just PM me.There are other things I want to do with it (like have it automatically change the formatting when you check off a task), but I would need to re-learn how to use Visual Basic in Excel... and that's a bit much..."
Okay, it's official. I'm the hugest nerd in the universe. Apparently VB in Excel is NOT too much for me to spend 2.5 hours doing for my spreadsheet.
So, my spreadsheet now has really crazy features... It detects (either by check mark or by inputting the number of pages read) which tasks have been completed and changes partially completed tasks to pink and fully completed tasks to purple. It's pretty sweet...
Cait wrote: "Tanja wrote: "http://spreadsheets.google.com/pub?ke...
Feel free to copy mine. I loved using the spreadsheet from the Summer Challenge. This time around, I altere..."
If you go to file, then click on export, then click on .xls you will be able to open the document, edit it and save it. :)
Feel free to copy mine. I loved using the spreadsheet from the Summer Challenge. This time around, I altere..."
If you go to file, then click on export, then click on .xls you will be able to open the document, edit it and save it. :)
Sara - I sent you a PM with my e-mail. I would love a copy if you are willing to share.
I also have a spreadsheet that anyone is welcome to. PM me if you would like a copy. I was going to post it as a google doc but it doesn't save my formatting.
Lyn wrote: "Sara - I sent you a PM with my e-mail. I would love a copy if you are willing to share. "I just sent it. Apparently goodreads doesn't e-mail me when I get a message! How rude!
Sara, your spreadsheet sounds totally sweet...I don't think you are the biggest nerd in the universe at all! Just thorough! LOL! Does the fact that I am excited about the description of your spreadsheet make me a nerd too? Actually, I accepted my geekiness a long time ago. Being a nerd rocks! :P
Jennifer wrote: "Sara, your spreadsheet sounds totally sweet...I don't think you are the biggest nerd in the universe at all! Just thorough! LOL! Does the fact that I am excited about the description of your spreadsheet make me a nerd too? Actually, I accepted my geekiness a long time ago. Being a nerd rocks! :P "Yes, it probably makes you a nerd, too... ;) I had LOTS of fun making it...
Cait => I'll make a copied version that'll let anyone be an editor. This way it can be copied-pasted into any spreadsheet! http://spreadsheets.google.com/pub?ke...
OR
http://spreadsheets.google.com/ccc?ke...
Yeah Rachel - that's the one downside to Google Docs, it doesn't have the same formatting as an excel spreadsheet. But I make due. This way I can update no matter what PC I am on ^.^
Wow, you guys are all so talented!!! Thank you all so much! I like using excel, but the template I made for the Spring Challenge took me forever to make and put together!
Ooo...Your spreadsheets make my mine look like a sad, gray, Soviet era spreadsheet. I'm off to add columns and color code things, er...I mean, read my challenge books like I am supposed to be doing. Why do I love spreadsheets so much?
Spreadsheets are a wonderful thing for those of us who love order! I taught a girl how to use excel last night and it was so exciting! I think I might have confused her more, but I just got so excited about everything that excel can do!
Spreadsheets are also for disorganized people like me who can't add or subtract. It's so nice to type in my numbers and tell it what to do--no adding the same column three times and getting three different answers. And then changing one of the numbers so I have to re-add. Yay, spreadsheets.
Katie wrote: "Krista wrote: "Kathryn wrote: "Hey,What is a wonk? That's the second time someone in this group has used that word (the other time may have been you, too). Is that a regionalism?
..."
From Webster's Dictionary -
Wonk: a person preoccupied with arcane details or procedures in a specialized field; broadly : nerd
I'm a political 'wonk' so the word has found it's way into my vocabulary.
Krista wrote: "Katie wrote: "Krista wrote: "Kathryn wrote: "Hey,What is a wonk? That's the second time someone in this group has used that word (the other time may have been you, too). Is that a regionalism?
..."
What a great word! That's so funny that the dictionary actually says "broadly: nerd." :)
Katie wrote: What is a wonk? That's the second time someone in this group has used that word (the other time may have been you, too). Is that a regionalism? ..."
What a great word! That's so funny that the dictionary actually says "broadly: nerd." :)
..."
Yes, I have used it somewhere else on this site recently. (So nice to know you read my posts so closely.) :-) And YES, I do fit the broad sense of the word 'nerd' too. But I wear that label much more proudly now than I did a seventeen.
Krista wrote: "Katie wrote: What is a wonk? That's the second time someone in this group has used that word (the other time may have been you, too). Is that a regionalism? ..."
What a great word! That's so f..."
Esh, yeah. I read everyone's posts closely. I'm stalking this board a little too much. I need to go read...
Katie wrote: "Krista wrote: "Katie wrote: What is a wonk? That's the second time someone in this group has used that word (the other time may have been you, too). Is that a regionalism? ..."
What a great word!
Esh, yeah. I read everyone's posts closely. I'm stalking this board a little too much. I need to go read..."
LOL! I told myself to 'Go Read' ... about an hour ago. I just can't seem to pull myself away from these boards.
Krista, you can go read your book now. I will watch the boards for you.
Donna Jo wrote: "Krista, you can go read your book now. I will watch the boards for you."Okay, whew that's a relief!
Krista wrote: "From Webster's Dictionary - Wonk: a person preoccupied with arcane details or procedures in a specialized field; broadly : nerd
I'm a political 'wonk' so the word has found it's way into my vocabulary. "
That's a cool word! I use the word "wonky"... which is a great alternate to "askew" or "lop-sided" (although I use it for more applications than that... ;)
Tanja wrote: "Cait => I'll make a copied version that'll let anyone be an editor. This way it can be copied-pasted into any spreadsheet! http://spreadsheets.google.com/pub?ke......"
Thank you so much!
NP Cait!And yeah if I didn't have a spreadsheet, I may lose my place or flip-flop my numbers. Happens if I'm rushing around. Hee!
Kathryn wrote: "Hey,For those of you who make a spreadsheet for the tasks in order to keep them organized, I was wondering if any of your might make it available to me that I might use??? If not, that is fine! T..."
This is wonderful! Thank you! :)
For those of you who make a spreadsheet for the tasks in order to keep them organized, I was wondering if any of your might make it available to me that I might use??? If not, that is fine! Thanks!!!