Fantasy Buddy Reads discussion
Archive [General]
>
2018 Team Competition Tracker/Google Sheet Central

EDIT: Ah! So it was you I saw fixing t..."
Haha yeah, I already guessed it was you ;) I would have done it like a barbarian too, it's way more effective than copy-pasting but my phone wouldn't let me! 😂




Tab order doesn't matter as long as the name didn't change... you can drag it back or I can in the morning...
On the average points per day my rank is shown as zero. Just letting you know


If you did it yourself (to avoid people messing with it), just check you're still logged in (with your Google account). If you didn't... You'll have to wait for Rob (or Iain) to unlock it.
Sorry I can't help you any more than that :/
Not me... some padlocked tabs I can mess with, others I can't... Pendra and Hacen I can't... only thing I/anyone can do until Rob shows up is duplicate the tab so you have an unlocked tab to play with... it's probably a login issue tho...

I quickly removed individual sheet permissions on personal pages. I'll look into the actual issue later unless someone else wants to tackle it.

fixed i think

fixed i think"
YAY, it's working again. Thank you so much Rob. :)

fixed i think"
YAY, it's working aga..."
Pendra wrote: "Rob wrote: "Pendra wrote: "Something is wrong with my sheet too. I can't insert anything in the "date completed" column. :(.......... or in any other column!"
fixed i think"
YAY, it's working aga..."
you're welcome :)
I just updated my spreadsheet but it’s not calculating points. Thank you

or just bite the bullet and reload the page to get calculations to start working again... we have so many calculations built-in to the spreadsheet, that sometimes the browser has issues loading them all...
Thank you. On the second page on the farthest right column is shows my rank as zero. I know that its not important but it bothers me and I would appreciate it if you could get it fixed.

Thanks!
I DID IT!!! :D
2001 points and counting, with 38hrs remaining in the competition...
https://www.youtube.com/watch?v=04854...
So what if Blood Eagles fell to 3rd... the royal We are the champions, nonetheless...
2001 points and counting, with 38hrs remaining in the competition...
https://www.youtube.com/watch?v=04854...
So what if Blood Eagles fell to 3rd... the royal We are the champions, nonetheless...

2001 points and counting, with 38hrs remaining in the competition...
https://www.youtube.com/watch?v=04854...
So what if Blood Eagles fell to 3rd... the royal We are the champi..."
Wow!! congratulations!
Jess wrote: "The competition is over?"
It was announced back in August that it was ending on Halloween at midnight, to give a breather before next year's competition... and for the mods to draft new teams...
It was announced back in August that it was ending on Halloween at midnight, to give a breather before next year's competition... and for the mods to draft new teams...
Manju wrote: "Timelord Iain wrote: "I DID IT!!! :D
2001 points and counting, with 38hrs remaining in the competition...
https://www.youtube.com/watch?v=04854...
So what if Blood Eagles fell to 3rd... the r..."
Thanks... I put in a concerted push to accomplish this, after reading 25% less in August and September...
2001 points and counting, with 38hrs remaining in the competition...
https://www.youtube.com/watch?v=04854...
So what if Blood Eagles fell to 3rd... the r..."
Thanks... I put in a concerted push to accomplish this, after reading 25% less in August and September...
Charlie wrote: "Well done Iain!! That's an amazing amount of points."
I'm not sure the new rules will let anyone hit 2000 points next year... With Buddy Reads and Challenges having less of an effect (50/25% -> 25/10%), and reading physical books earning 25-33% bonus points over my audiobook points, I think everybody in the top 5 right now would be fighting for position around 1700-1800 points...
I'm not sure the new rules will let anyone hit 2000 points next year... With Buddy Reads and Challenges having less of an effect (50/25% -> 25/10%), and reading physical books earning 25-33% bonus points over my audiobook points, I think everybody in the top 5 right now would be fighting for position around 1700-1800 points...

2001 points and counting, with 38hrs remaining in the competition...
That's wonderful Iain...congrats...2001 is a phenomenal amt of points, as was sustaining that tireless superhuman pace all thru the year.
And not the least of your achievements was (additionally) dealing with all my wordy rubbish throughout the year...haha, I had such fun indulging my superhyper impersonation of Colin Creevey on 'Roids...totally trashed your tracker, man...*CRINGE* sorry for that!
And you were really were so tolerant and enduring thru it all...
I know I must've severely tried the limits of your patience several times but you were never less than polite and kind, you never got annoyed or offended, and you were always such a sport. Thanks for that.
Truly, you're ALSO indefatigably nice.
😊
Best of luck for next year...defending champion now!
And...
(view spoiler)
Damn, should've been here sooner...read for 24 hours straight and then overslept. It's evening almost here. I'm not even gonna attempt the timezone math.["br"]>["br"]>["br"]>["br"]>["br"]>["br"]>["br"]>["br"]>["br"]>["br"]>["br"]>["br"]>["br"]>["br"]>["br"]>
Zaara wrote: "Timelord Iain wrote: "I DID IT!!! :D
2001 points and counting, with 38hrs remaining in the competition...
That's wonderful Iain...congrats...2001 is a phenomenal amt of points, as was sustaining t..."
2001 points and counting, with 38hrs remaining in the competition...
That's wonderful Iain...congrats...2001 is a phenomenal amt of points, as was sustaining t..."

Everyone will be happy to know I finally went in and plugged in challenges for the last 2 weeks of October, so my final tally of 2005.8 points is official, and not a placeholder... and then I made those numbers permanent, so I can continue using the spreadsheet without skewing the Draft...
Virginie wrote: "You're a machine! :O"
I basically made a point a couple weeks ago about leeway, so I would have some leeway in making my spreadsheet data final... I realized a couple months ago that I got full challenge points for blank spots, since the cell checks for Ns to zero out... so my points didn't go up any, they just became official...
I'm curious what my points will look like next year... I'm planning less re-reads and more Incomplete Series catch-up reads, and this might lead to less Buddy Reads... all with the points changes... who knows?
I basically made a point a couple weeks ago about leeway, so I would have some leeway in making my spreadsheet data final... I realized a couple months ago that I got full challenge points for blank spots, since the cell checks for Ns to zero out... so my points didn't go up any, they just became official...
I'm curious what my points will look like next year... I'm planning less re-reads and more Incomplete Series catch-up reads, and this might lead to less Buddy Reads... all with the points changes... who knows?
Arkadeb wrote: "Speaking of the draft, when is it supposed to happen?"
I think it's Super Secret... it's private anyway... all I know about it is that the mods are going to do a Skype group call... they have a couple weeks to plan it... I assume it's going to get harder to plan the closer to the holidays it gets...
People joked about wanting to commentate like a sports draft...
I think it's Super Secret... it's private anyway... all I know about it is that the mods are going to do a Skype group call... they have a couple weeks to plan it... I assume it's going to get harder to plan the closer to the holidays it gets...
People joked about wanting to commentate like a sports draft...
Arkadeb wrote: "Speaking of the draft, when is it supposed to happen?"
It's looking like the weekend of Dec 8-9 because of all of our schedules.
It's looking like the weekend of Dec 8-9 because of all of our schedules.
Timelord Iain wrote: "I think it's Super Secret... it's private anyway... all I know about it is that the mods are going to do a Skype group call... they have a couple weeks to plan it... I assume it's going to get harder to plan the closer to the holidays it gets...
People joked about wanting to commentate like a sports draft..."
More or less accurate. It's not really secret and the reason for doing the live draft was twofold. First to cut down on Niki's admin time to choose the teams. Second we thought it would be a treat for the mods to get together and have a few laughs while picking the teams.
People joked about wanting to commentate like a sports draft..."
More or less accurate. It's not really secret and the reason for doing the live draft was twofold. First to cut down on Niki's admin time to choose the teams. Second we thought it would be a treat for the mods to get together and have a few laughs while picking the teams.

I think it is a superb idea!
Books mentioned in this topic
Gardens of the Moon (other topics)Tower Lord (other topics)
White Sand, Volume 2 (other topics)
Dead Until Dark (other topics)
The Warrior's Apprentice (other topics)
More...
EDIT: Ah! So it was you I saw fixing the formulas, Anni. Before I went and dragged down the cells like a barbarian ^_^