Fantasy Buddy Reads discussion
Archive [General]
>
Team Reading Competition Rules
Arkadeb wrote: "Ok this is a very cool sheet, and excellent idea. Should save the mods and team leaders a lot of trouble in calculating stuff. In addition to what Iain is asking I assume one uses it by signing i..."
you type "y" or "n" the formula will take care of the rest. check out the example sheet.
Thank you Rob!!! The Sheets are amazing! More time to read :)
How do I get permission to edit my tab?
If you go to the sheet, at the top their is the "edit" option. This should let you request to edit. Not sure that made any sense...
C.P. wrote: "If you go to the sheet, at the top their is the "edit" option. This should let you request to edit. Not sure that made any sense..."
It was set up different for me but I figured it out 😁
Hacen wrote: "C.P. wrote: "If you go to the sheet, at the top their is the "edit" option. This should let you request to edit. Not sure that made any sense..."
It was set up different for me but I figured it ..."
Good idea prepopulating it with some of the books you're going to read Hacen (w/0 filling in the pages yet so it doesn't generate unearned points).
Got my permissions set. Thanks Rob. Should make things easier.
Rob wrote: "Hacen wrote: "C.P. wrote: "If you go to the sheet, at the top their is the "edit" option. This should let you request to edit. Not sure that made any sense..."
It was set up different for me but..."
Thanks! I figured I'd go ahead and put them in.
Love the spreadsheet Rob just sent my request to edit I think I mostly get it fortunately I worked with spreadsheets in GCSE ICT so I know basic stuff about sells and formulas (that is if I haven't already forgotten it haha)
Mod
Not sure that made any sense..."
It was set up different for me but..."
I read too much to start pre-populating my list too far out, if I want my list to be in chronological reading order... so I started using column K to pre-count pages...
Question: Am I going to have to re-request edit access every day?... I slept for 6-8hrs and I'm back in view mode and I need to ask for edit privileges again for some reason... I'm still logged into google... with some searching, I'm wondering if you set an expiration timer on it or something?
Mod
Access denied
You no longer have permission to access this document, so your changes can't be saved. If you believe this is an error, contact the document owner. If your access is restored, you will be able to continue working.
The problem is probably occuring because each person is setting the protection when I should probably be the only one setting it.I think, since this is all on the honor system, will simplify and just give everyone write access. What this means though is that I highly recommend everyone back up their sheet when make edits to it.
Update=as far as I can tell it looks correct. Each sheet that becomes locked should have access for me and the sheet owner only.
Mod
It should have worked. For what it's worth, it is set as "anyone who has the link can edit" it since not everyone has a gmail account. It may be the protecting the sheets on top of it might be messing things up.If you're having issues, email me directly here for a quicker response. (Though I may or may not be that responsive the rest of the night since its like new years eve or something).
Mod
Rob this is brilliant. I'm kind of jealous that I didn't think of it first. Thank you for putting it together!
Thank you, Rob!You saved me the trouble of creating one to track my own reads for the challenge. :)
This is really good, Rob! Thank you :)
Mod
Most English editions are between 1007 and 1258 pages... but there's an ebook edition listed as 2401 and a Nook edition listed as 3159 pages... I don't think they're really measuring pages, tho... I think we should ignore them in this case... thoughts?
I don't see Words of Radiance or Oathbringer editions exceeding 1600 pages...
I think you can go with the English editions? I have no experience with the other editions, but it's strange that there's such a difference.
Mod
Mod
Regarding the page count for the team reading challenge. After realizing all of the mess this is causing, the mods have decided that we will be going with the page count of the most popular edition on Goodreads.
The exception to this would be if you actually do read it in another language, then go with the most popular edition for that language.
The reasoning behind it: go check out the book page count thread. It says it all... too much work... We do thank Iain for organizing it all, but we realize that it will just cause more and more work as time goes by.
Just some quick notes about the google sheet. Two ways I can set it.1) Everyone with the link can edit. This is the honor system and all already, so doing it this way does not require everyone to have a google account. BUT, everyone has to be careful not to accidentally edit the wrong sheet.
2) I can set it so that it is exclusive and set up so that people have access to edit only their sheet and their team capt, but then anyone without a google/gmail account might not be able to set the sheet at all. I guess i pays to be an android user?
For now, I'm keeping it at #1. Let me know if you have any issues. You can always go to the "file" menu and download or make a copy of it to back up your work as well. I'll see what I can do about keeping it backed up regularly regardless.
oh and again that link is:
Here
Thanks, and enjoy!
-Rob
Love the Google form Rob. Thanks for putting that together. Great way of keeping track of all the stats quickly and easily.
The scoreboard tab is really awesome.
Mod
Mod
Dang, you found out my master plan.....
Thanks to someone's suggestion, I linked everyone's tab directly to the main page of the sheet. So should be easier to navigate about.And now I shall read or something as I don't earn points for the Blood Eagles for my spreadsheet skillz.
Mod
"
You just might actually earn points, though. ;) We're discussing a couple things over in mod-land.
Mod
And now I shall read or something as I don't earn points for ..."
Jenna wrote: "Rob wrote: "And now I shall read or something as I don't earn points for the Blood Eagles for my spreadsheet skillz.
"
You just might actually earn points, though. ;) We're discussing a couple th..."
As a reward, you get credit for reading Excel for Dummies :P
Hi guys - FYI - you need not request access to the sheet. I think everytime someone does and I grant it, it resets the permissions. So follow the public link instead.https://docs.google.com/spreadsheets/d/1ve1GLOuf5njnrQ23X6RjHIrKY8I-3PG8OysPm7v4fyo/edit?usp=sharing
Rob wrote: "Hi guys - FYI - you need not request access to the sheet. I think everytime someone does and I grant it, it resets the permissions. So follow the public link instead.https://docs.google.com/sprea..."
Thanks Rob, it was making me request access on the old link, wouldn't open. Problem now solved! :D
Mod
I will endeavor not to change it anymore.
Mod
I'm not sure if your link changed a setting or something, because once I started moving around the sheet, my bookmark still matched the URL I saved before...
Mod
Niki Hawkes wrote: "At some point today I'm going to compose a "hub" thread specifically for easy access to the tracker, if that helps."Poifect. thanks Niki!
I've already bookmarked it :-D
Mod
I just think this group has us in the habit of leaving thread creation to the mods :)
Mod
Actually, Rob, if you wouldn't mind copying that same post into a new thread in this folder, that would be stellar. That way if any changes happen in the future you can just update that thread and the original comment and you don't have to go through a mod.
One query - I take it we can only apply one challenge per book used? Should we be requiring persons to put in their log or the google sheet a note on the far right what challenge the book is meeting?Just a nitpicky thought :)
Mod
Mod
Iain wrote: "I repurposed the graphic novel column in my sheet, since I doubt I'll be reading any graphic novels this year..."heh - I wanted to get on the board so I read a graphic novel. Woohoo 0.3 points!
A little question: does it need to be SF or Fantasy or are other genres allowed? Besides SF/F I also read other things...
Guys, I really think you guys shouldn't put the page number on the scoresheet till you're truly done with the book. The score is a mess! It's not even accurate right now because almost everything is still on progress and the pages are already there. Just my opinion though... I mean if we're doing it this way, I can just put all my TBR for this year immediately and the points would blow up!
Yes, Petrik, I follow you on that. The simplest way is to put the page number when you've finished the book. So you see an actual score.
Fantasy Buddy Reads
Books mentioned in this topic
The Raven and Other Poems (other topics)Owl Babies (other topics)
A Die Hard Christmas: The Illustrated Holiday Classic (other topics)
Owl Babies (other topics)
Go the Fuck to Sleep (other topics)
More...
and I really need to update that thing... I've logged my books through December 19th, but I haven't edited the official lists at the top since October/November...