NBRC: Tower Teams Read 2013, Round II discussion
Cerulean (AKA “Hobbit Blue”)
>
Captains' Chat
For the first post, I copied and pasted the duties for Team Captains, then added notes from our discussion in the previous thread. If anything needs to be changed, please comment.
Details about the duties and other issues to be dealt with by the Team Captains can be done in this thread.
I am still working on a second spreadsheet to keep track of issues and when they have been resolved.
Okay, just discovered I can either add your individual emails so only you two can edit it, or I can change it so anyone with the link can edit it. Then any team member who views it could potentially change it by mistake, though, and it would be more difficult to figure out what went wrong.
G' morning/day!Nice work with spreadsheets. :D
I'll send you my email. We don't want everyone to fix things. Who'll keep track of who done what!
I'll be away today for few hours, and most of the day tomorrow (probably). We are celebrating cousin's first birthday :D
And we have 1349 books to go :D
Tea- I added your email address and it lists you as an editor when I click on the Share button. I think it sent you an email and there are instructions there on how to confirm and access it as well. There are two of them, so you may get two emails.General Info on using spreadsheet
Nothing needs to be entered on the Team Summary sheet. All the information we change on the Team Data sheet will automatically update the Team Summary sheet. I have at least temporarily put the Team Member names on the spreadsheet. Since they haven't actually joined the challenge yet, I have not added the links.
There is a short formula to follow for making the names link to their profile page in green at the bottom of the page, but if you can't figure it out, I can do it later and you can leave it as is for now and just add the other information to the columns as they are signed in.
Mod
Oh, I'm interesting in learning how to do that, Turtlecollector.
I guess I'm still sleeping (it's only 10am). I wanted to ask what happened with member list, and than I discovered other sheets.*bangs head at the table*
@Lisa Kay, Karen and me as Hobbits? Really?! :D
Mod
I also see on the list that Karen has captain next to her name, but she wasn't on the list to be let in early for discussion?
Mod
Moderators of Nothing but Reading Challenges wrote: "Did you ever watch the behind the scenes when Jackson referred to the door color as "Cerulean, or 'Hobbit Blue.""Is that on Hobbit or LoTR? My LoTR verion doesn't have behind the scenes.
Karen is studying for exams, so she probably wouldn't be able to do much. I guess she signed in before all that started. I'll add her to the spreadsheet.
Short tutorial on linking name to profile page:This is what needs to be typed into the cell exactly
=hyperlink("web address of member profile page";"name of member")
Using my profile:
=hyperlink("http://www.goodreads.com/user/show/66...")
I went to the member's profile page and copied the web address, then pasted it into the formula. Don't forget the quotation marks or it doesn't work right. You can select the cell with a linked name then look at the top of the page where it shows what is actually typed in the cell to see an example. I can't get my direct example to show up correctly in this post. It always cuts it off after most of the link to profile page.
Moderators of Nothing but Reading Challenges wrote: "I thought you'd be happy. If I was to assign myself a Team, it would be "Hobbit's Blue." Love that door and that color."And we would love to have you :D You can be our honorable member (is that how you say it?)
Definitely an honorary(I think) member. Tea-were you able to access and edit the file? If so, I think we are ready to have the main thread opened for us.
Yes, I did access and edit the file :)I'll be leaving in an hour and be back in 5h. So if you don't want to handle it alone, wait until I'm back.
Hey everyone , and yes I will be mostly MIA , I could maximium sign in once a week or something .
Like Tea said i have my exams soon and I signed up before I knew that there would be so much pressure , so wont be able to be active much :(
Like Tea said i have my exams soon and I signed up before I knew that there would be so much pressure , so wont be able to be active much :(
And love being on the hobbit team , thanks lisa kay :)
do join in as our honorary member :)
do join in as our honorary member :)
5 hr would be good. It is almost 2am here and I should probably get some sleep before my brain gets too fried. I will probably be up again by then anyway and more alert. I tend to wake up between 6 and 7 no matter what time I go to bed.Okay, off to bed I go. I will figure out why the profile link doesn't transfer to the summary page like everything else tomorrow(later today:). It is not hard to copy and paste that one column if need be.
It's me copying, anything could have happened. :)Since I already have Karen, I'll be monitoring her books. And since she lowered her goal, I'll increase mine to 200. That 160 would be changed few times by the end of the year in any case :D
Night and sweet dreams. :)
And don't get me wrong Lisa Kay, I'm glad Karen and I are on the same team (and it's Hobbit!). Problem is, we tend to 'steal' the thread when we start talking. :)(as you can see by example)
Mod
With Karen's and mine number change, our team goal now is 1354.
❀Tea❀ wrote: "With Karen's and mine number change, our team goal now is 1354."Thanks Tea, I've highlighted you both so LK can do her magic after her well deserved sleep.
Night :D
Haha! We do tend to steal threads don't we ! *missing it*
Haha! We do tend to steal threads don't we ! *missing it*
Like Karen, I'm likely to be MIA for a lot of the time, but I'll try to help where I can
Okay, I am back. My 4 hr nap/sleep has refreshed my brain. I think the updating problem on the Team Summary Page has to do with the hyperlink. So once the link is added on the Team Data sheet, just copy and paste that to the Team Summary sheet. Otherwise, everything else should update automatically.
I also just added hyperlinks to the main challenge page for each team so that we can update the team totals directly from our spreadsheet without needing to find them through the thread on Goodreads.
I'm back, too. Why aren't you still sleeping?!
Melissa and md have private profiles so one of us should friend them. Since Jojiwoji said she'll be MIA, we can split team between two of us, or give her those with low book goals.
My body clock wakes me up. I will be tired today and probably will go to bed early tonight though. This is the second night in a row I was up that late, and usually that does not happen. I am usually going to bed around 10-11pm.I am going to post on the thread to have our discussion thread opened now. I think maybe you should reserve the first two posts and I will reserve the next two posts.
Since you already know how to add images, maybe you could make a welcome post in the first one and I will use one of mine to add the link to the spreadsheet.
Then we will still have 2 more posts reserved at the beginning if something else comes up.
Turtlecollector wrote: "I also just added hyperlinks to the main challenge page for each team so that we can update the team totals directly from our spreadsheet without needing to find them through the thread on Goodreads."Just one question - yes, I'm shamelly snooping on your thread for ideas - how does this work, it allows to go to the link, or it displays the number of books?
Feel free to look at the spreadsheets and copy and paste ideas you like. Clicking on the link goes to the main page where you can see the team's members and total goal and where each member joins to add their shelf to the challenge. I know there may be a little discrepancy in when these numbers get updated, but it just like using the link in the Check In Thread to get to your team's main page.
Thanks. You actually have very good ideas here.. I've borrow a few :)
And the links to the shelves is pretty useful, since besides the number we have to check if the book is valid (page numbers, pictures &comic books, etc)
Tea - are there specific members you would like to check? I can friend Melissa and md-Mabel. They are the only other two not on our original Team B.(besides Karen)
Sorry, looking for welcome signs on google :DNo, I'm fine with anyone. The only one I know from before is Karen. We should try to split them by number of books.
If you take Melissa and md-Mabel, I'll take Ezinwanyi. we could live Dee and Gemma to Jojiwoji (they don't have that many books, so she won't have much work). Or I'll take them too, and you take Sanz.
*that really sounds terrible!*
Going to take a short break and start to get ready for work. I start work in 2.5 hrs at 10 until 5. During that time, I can check in often(every hr or so) but it won't be constant like it is now at home. I hope the mod gets back soon and can open our thread so our team members can join us. People seem to be getting impatient.For now, back in about 20-30 min.
Okay, our thread is open. For now, I think we can give Dee and Gemma to Jojiwoji and I will also take Sanz. That should even out number of books pretty well. We can split the other two later if it is too much for Jojiwoji.I know that sounds bad but I don't know how to word it better.
Mine are reserved as well:)Do you think we should add a link to this thread on the discussion thread in case members need to talk to us specifically and not the whole team?
I love the welcome image. Where do you find your images? Are there rules about whether the pictures you find can be copied or not?
I just googled welcome image and then went through pages of them :) I was trying to find something in our color (I'll never remember the word!) but only that resembled were very sparkly :D exampleMost pictures can be saved. Right click on it - view image - save as...
To post them here, there is difference. If image is animated (moving) you need to upload it first to some site (imageshack, phobucket,..) and take link from there. If it's just image, you can copy link here (for now). Those pics that are copyrighted have something on them so you don't have clear pic.
Off to work now. I will be back in 2 hrs for my lunch break and will try to check in again between now and then.
I'm here. Working in another window :DBTW love that turtle :)
Thanks about the turtle, I went google and searched for turtle book and found several I liked. I decided it was time to learn how to add the avatar to my profile as well as how to insert images onto posts. The avatar was easy, I haven't had time yet to play around with images.I added the link to Ezi's profile and shortened her name since she seems to change the last part of it. I don't know if it will affect the link if she changes it again during the challenge.
I'm signing off. I'm going to bed to read for awhile. GR is too distracting :DSee ya tomorrow. Don't stay up to late/early again :D
I hope your book is good. If I try to read in bed tonight I will definitely fall asleep. I definitely plan to go to bed on time tonight, if not a little early.Sleep well.
Jojiwoji - you should now be set up to edit the spreadsheets as well. You might want to check and make sure when you get a chance, if not I will try to add you again. I did the same thing for Tea and it worked for her.
I've added list (names, goals, links) to main discussion thread.@Turtlecollector - could you in that post with links, add some rules - books over 160pg, no graphic novels, no children's books, re-reads over 6 months, books after April 12th count, play nice... (I can't think of anything else at the moment ☺)
I'm leaving to celebrate relatives' 1st birthday, so I'll be away for few hours (hopefully).
Just a quick reminder, for this round is the FINISH DATE that counts, not the STARTING DATE.
NBRC: Tower Teams Read 2013, Round II
Books mentioned in this topic
Dragonfly in Amber (other topics)Caleb's Crossing (other topics)
Eclipse (other topics)
Astor Place Vintage (other topics)
Curiosity Killed the Cat Sitter (other topics)
More...
Authors mentioned in this topic
Anne Rice (other topics)Janet Evanovich (other topics)
Kristin Cashore (other topics)
Liz Simpson (other topics)
Richelle Mead (other topics)
+ keeping a Google Spreadsheet that all members can view
~created by Turtlecollector, has team summary and other team updates
~added Tea and Jojiwoji as editors
+ communicating with a NBRC Moderator
~assigned to Turtlecollector
~if necessary or in emergency, co-captains can step in
+ communicating with all Team Members
~Tea for adding images to posts
+ making sure Team Members are staying active
~members assigned to specific co-captain for checking
~weekly/biweekly checks on books tagged by members
+ notifying the NBRC Mod if someone drops out
~assigned to Turtlecollector
+ have effective and kind (this is a game, remember) on-line communication skills to help members having trouble
~shared by all co-captains
+ making sure Team Members belong on your team
~shared by all co-captains?
~check list from Mods to match member names on thread
~check list from Mods to match member names on signup
+ posting weekly status updates/reminders
~shared among co-captains
~spreadsheet to track totals for groups
~spreadsheet to track team member totals
+ dealing with minor issues that arise
~spreadsheet to track issues and dates resolved
~assigned to co-captain according to knowledge or ability to resolve
+ post little challenges within challenges, if desired
~assigned to Jojiwoji, with backup of co-captains
~monthly mini challenges?
~read-a-thons?
Summary Spreadsheet
Issue Spreadsheet
Discussion Thread