YA Buddy Readers' Corner ♥ discussion
note: This topic has been closed to new comments.
Team Threads Archive
>
Team Days (M)- Chat ✔
So I made an SS with Board to easily see our lines and spots for bonuses. As on option for use. But no pressure. :) https://docs.google.com/spreadsheets/...
I do have several BRs planned already but if anyone wants to BR anything from this shelf https://www.goodreads.com/review/list... let me know. :)
Thanks Jamie! That looks great! It’s my first time doing a reading challenge.
Hi! Checking in...
Ok, different SS. A couple other teams are using it and it is much easier to use and even calculates each books pts. I couldn't get the totals to work but if someone else knows how to do that great.https://docs.google.com/spreadsheets/...
Although, for some reason the points totals aren't always accurate with modifiers/brs added in... so it might be off be a point and manually adjusted sometimes ( it tried to give me 23 pts for Trickster's choice for example).
So if we want to use either of these SS let me know. I linked both at the top. Figure whichever is preferred is the one we can use.
@Diedra I put the title in for yours but wasn't 100% it was the Libba Bray one or if it was a BR, etc.
So quiet here... :( Hopefully our last 2 members check in soon and planning starts.
I can always pop over and chat Jamie! ^_^
Anna 'Bookbuyer' wrote: "I can always pop over and chat Jamie! ^_^"Yes! Things have been too quiet lately! :)
Jamie wrote: "Anna 'Bookbuyer' wrote: "I can always pop over and chat Jamie! ^_^"Yes! Things have been too quiet lately! :)"
They have! I hate being six hours ahead. I miss most of the action!
I would hate being on a time so separate. Although at least we do have a decent mix of time zoned people in this group as a whole. And I am not the chattiest but my February group has been super quiet and now this. And I have to avoid twitter and FB lately since that is just political talk and I don't wanna hear any of that so I am limited in my socialization.
It can be hard at times but it has also worked out decently since I don't get on till the evening now.I miss a lot of the early morning action though. :(
We do! That's one of the things I love most about this group.
I am always open to chat as you know. lol. I'm typically on from about 4pm-4am spain time so that's about 9 hours ahead of you?
So it's 2 am there? You are keeping crazy hours! lol. Its okay mine are always all over the place.And yeah mornings are always the busiest as UK is in evening mode and US is just getting up.
Yes. 2 am. I'm much more of a night owl. lol. Weirdly I am basically keeping the same hours I do at home just 6 hours ahead.
Yup. I always get on to tons of notifications.
Haha I am a night owl too but not that much. But that is likely due to work lol.
It’s 4 AM here trying to decide which book to start first
Hi guys! Sorry I'm late checking in!What do we need to do? Sorry I've been sick all week and am just catching up with Goodreads stuff.
I like the second SS best...I'll add my info there.ETA: I can't update, but I will be reading this book tomorrow (and possibly two more):
Savage Run, first published in 2002
Did I not open for edits? Sorry. Will fix in the morning. Glad you made it!
I’m thinking of starting The Toll by Neal Shusterman first to knock one of the most recent years off early then I may move to the harder ones
Did this challenge actually start on Feb 29? If so, I read 3 books already, and I think I made a review for each one.
Thanks! Well, we'll hopefully get to count my book.
I added my information to the first spreadsheet for now and will transfer to the second once it’s opened for edits
I think I got it open for edits from my phone. Can’t fall asleep so figure I’d try. If it doesn’t work I’ll get in first thing when I get up. Meanwhile wish me luck on a few hours of sleep lol. I need it.
Lol yes Jamie I agree about the sleep I’m about to try to get another nap in
OMG...I LOVE THE NEW SPREADSHEET!! What does MG stand for??
Yeah I liked the new one so much better too. It’s why after seeing a few others using it I made a copy and edited it for us.
I actually really like the new one because I’m terrible with spreadsheets. I’ve been in a few team challenges in other groups and for me spreadsheets have always been hard to use and this one seems pretty simple (and I love the colour scheme).
Jamie I saw earlier you were interested in a formula for your sheet. I don't know if I found exactly what you are looking for but try this sitehttps://smallbusiness.chron.com/forwa...
I tried the second one on a blank SS and it worked.
Anna 'Bookbuyer' wrote: "Jamie I saw earlier you were interested in a formula for your sheet. I don't know if I found exactly what you are looking for but try this sitehttps://smallbusiness.chron.com/forwa......"
The other SS's have a way of totaling each person indivually and that is what I couldn't figure out. It counted our books but not pts for whatever reason gave error message, and I don't know how that was done. Sum totals to another sheet I can sorta do. But I will actually bookmark that link. Thanks!
I think you kind of can with that formula. I haven't tinkered with it a lot.NP. ^_^
I’ve managed to get the N/A to disappear, but for some reason whenever I’ve tried it out on the sheet it gives me 16 instead of 7 points.
I’ve figured out why it’s giving me 16, I just have to find a way to fix it :(
What seems to be the problem? I'm not a spreadsheet expert but I might be able to help. ^_^
Do you want to hop on the sheet and we can figure out what happened??
Using Defined Names In Conditional FormattingAs noted above, custom functions in Conditional Formatting cannot reference cells in other worksheets in the same workbook, and cannot reference cells in other workbooks. However, you can get around this limitation by using defined names. Create a defined name which refers to the list in the other workbook or worksheet, and then use that name in your custom function.
For example, suppose you want to make cell A1 on Sheet1 red if that cell's entry is not found on a list on Sheet2, cells B1:B10. If you tried to use the formula =COUNTIF(Sheet2!$B$1:$B$10,A1)=0 as your formula, you would receive an error message from Conditional Formatting. To get around this error, create a defined name called MyList which refers to the range =Sheet2!$B$1:$B$10 and use the name in your custom formula:
=COUNTIF(MyList,A1)=0
This topic has been frozen by the moderator. No new comments can be posted.
YA Buddy Readers' Corner ♥
Books mentioned in this topic
The Marvelous Land of Oz (other topics)Meet Cute (other topics)
Kiss the Stars (other topics)
Boys of Brayshaw High (other topics)
The Toll (other topics)
More...
✔ Jammin Jenny
✔ Vanessa
✔ Vicki
✔ Diedra
✔ Amelia
✔ Jamie
✔ Abby
✔María
✔Heather
Reviews: https://www.goodreads.com/topic/show/...
Spreadsheet: https://docs.google.com/spreadsheets/...