Fantasy Buddy Reads discussion
Archive [General]
>
2019 Team Competition Tracker/Google Sheet Central
Timelord Iain (Eeyawn) wrote: "Siobhan wrote: "Let us know if you hear? Hope she's alright."Got a response. She's alive. Dealing with family health stuff. Will return when she's in the mood to read & be social again.
No freak..."
That's good to hear, I'm glad she's okay. Thanks for the update.
Timelord Iain (Eeyawn) wrote: "Siobhan wrote: "Let us know if you hear? Hope she's alright."Got a response. She's alive. Dealing with family health stuff. Will return when she's in the mood to read & be social again.
No freak..."
Good to hear! I have been fearing the worst.
Ah thanks Iain. I'm such a worrier. Glad she's OK and hope she comes back to us soon! ❤️
Mod
Glad to hear she's okay. As someone who also had a rough start to 2019 that kept me from reading for about a month and a half, I can attest to the fact that sometimes real life can be a drag.
That's good to hear, I've been worrying about a possible accident or something like that.Hope you'll come back soon, Virginie!
Mod
Mod
You probably need to copy a ton of formulas to fix it, from somebody else's sheet... but I dunno who has a matching sheet you can use, since you need someone with identical columns & month data in the same hidden column.
Your numbers are low enough you could probably just hard-code... but I'd hate to have to try and go back and figure out Julia's numbers from 3 weeks ago, manually...
Thanks for your kind words, everyone, and sorry to have worried you.
Mod
Welcome back, Virginie :) and no need to be sorry at all - we just missed you <3
Welcome back Virginie - Glad you're back and well.Also - I need to check this thread more frequently (you all advanced it so much I'd have to reverse engineer it to be of assistance again). -
Iain - the overall totals are still correct on my and Julia's page?
Mod
Also - I need to check this thread more frequently (you all advanced it so much I'd have to reverse engineer it to be of assistance again). -
I..."
The top row stuff getting funneled to the team totals is fine... it's the collapsable monthly stuff... everything is just funneling into January, still... so your graphs and monthly stats don't work... not sure if you care...
Mod
Also - I need to check this thread more frequently (you all advanced it so much I'd have to reverse engineer it to be of assistance again). -
I..."
I left most of it to Virginie until she went MIA... then I needed to step up with requests... and nearly broke the whole thing when errors with the Form entries arose...
You weren't even around when we turned the Buddy Read requests into a new spreadsheet, really...
The top row stuff getting funneled to the team totals is fine... it's the collapsable monthly stuff... everything is just funneling into January, still... so your graphs and monthly stats don't work... not sure if you care... reply | flag *
....
Not really. Julia doesn't even look at her sheet. To keep it not homework-like I just have her stack books on my desk next to my computer when she's done. :)
The biggest thing I care about is pages/day as a goal setting tool.
Mod
WELCOME BACK!!!
Hey guys, can someone have a look at line 70 on my sheet? There's something wrong with the points formula. Thanks :)
On it :)EDIT: Fixed. Simply copied the cells from a line that worked :)
There was a missing reference in the points formulas, which is usually due to a line being deleted.
Thanks, virginie :) I'm always too afraid to try anything, in case i end up breaking it even more...I also commented this a while back, maybe you could take a look at it for me?
Quick question: is it possible to add a rereads/new books tracker, next to the other two trackers i have on my sheet?
And I'd love if e-books could also be added to the audiobook/physical book tracker.
Since i have no idea how to use sheets except type in book info, could someone have a look at it? Thanks in advance :)
Hey, is anyone else having prob with their totals not updating to the Main Page?Or is it my dang internetz???
Mod
There's always been a bit of a delay... generally until someone fiddles with a cell and triggers another calculation of the whole sheet... it's why the rankings end up as #NA so often on personal sheets...
EDIT: looks accurate now, so I think it's just the slowness... if you want to see an update, just fiddle with some non-essential cells off and on, and you can force a calculation... I do it all the time, but I'm mostly interested in the monthly stats on my own page, so I dunno how well it works on connected pages...
Timelord Iain (Eeyawn) wrote: "how long of a problem?There's always been a bit of a delay... generally until someone fiddles with a cell and triggers another calculation of the whole sheet... it's why the rankings end up as #N..."
Must’ve fixed itself after 2 hrs. Thanks!
Guys! I've received a certain package an hour ago and...THANK YOU ALL! I LOVE YOU!
I read all the postcards and letters, admired all the drawings and read the amazing story! You guys are the best! Thank you thank you thank you!
*currently munching on the chocolate included in the package*
Virginie wrote: "Guys! I've received a certain package an hour ago and...THANK YOU ALL! I LOVE YOU!
I read all the postcards and letters, admired all the drawings and read the amazing story! You guys are the best..."
❤️❤️❤️
Mod
THANK YOU ALL! I LOVE YOU!
I read all the postcards and letters, admired all the drawings and read the amazing story! You guys are the best..."
It was fun to write and brainstorm... I think Anni plans to link the story on here soon (probably without the images), now that you have the hardcopy...
As fun/funny as I thought it was to tease a cheesy PNR sequel at the end, I leave that to you (and Anni) to write, if it really becomes a thing :D
Virginie wrote: "Guys! I've received a certain package an hour ago and...THANK YOU ALL! I LOVE YOU!
I read all the postcards and letters, admired all the drawings and read the amazing story! You guys are the best..."
We take our job as your subjects very seriously! 😘
Mod
THANK YOU ALL! I LOVE YOU!
I read all the postcards and letters, admired all the drawings and read the amazing story! You guys are the best..."
Yay! I'm glad it arrived <3
Virginie wrote: "Guys! I've received a certain package an hour ago and...THANK YOU ALL! I LOVE YOU!
I read all the postcards and letters, admired all the drawings and read the amazing story! You guys are the best..."
You're welcome :) And thanks again for putting it together Anni!
Rob wrote: "Virginie wrote: "Guys! I've received a certain package an hour ago and...THANK YOU ALL! I LOVE YOU!
I read all the postcards and letters, admired all the drawings and read the amazing story! You ..."
My pleasure and it wouldn't have worked without you guys :)
And uhm... Here's the story 😅
https://docs.google.com/document/d/1R...
For the record, I laughed like a madwoman when I read the "BOW BEFORE ME, HUMANS!", and wondered if I actually wrote that somewhere.Then I realized... Yup, I did. And it's still there. On the main page of the competition spreadsheet :D
Virginie wrote: "Guys! I've received a certain package an hour ago and...THANK YOU ALL! I LOVE YOU!
I read all the postcards and letters, admired all the drawings and read the amazing story! You guys are the best..."
Yay glad it arrived safely!!! 😊🍫
And uhm... Here's the story 😅https://docs.google.com/document/d/1R...
Fantastic, take a bow :) I almost fell out of my chair I was laughing so much.
Rob wrote: "And uhm... Here's the story 😅https://docs.google.com/document/d/1R...
Fantastic, take a bow :) I almost fell out of my chair I was laughing so much."
I can only agree - hilarious 😂
Virginie wrote: "For the record, I laughed like a madwoman when I read the "BOW BEFORE ME, HUMANS!", and wondered if I actually wrote that somewhere.Then I realized... Yup, I did. And it's still there. On the mai..."
Haha, yeah, we added a few quotes (Hailee, Kathrine talking about the how to train your dragon movie and Diana, Soo, Iain, and a few others from this thread 😂)
Rob wrote: "Fantastic, take a bow :) I almost fell out of my chair I was laughing so much."Angela Jr. wrote: "I can only agree - hilarious 😂"
Thanks :) I'm glad you like it!
I hope you don't mind being included as the voice of reason, Rob 😂
Is spreadsheet down? Only have black screen
It's working okay for me at the moment.
Sir Anni wrote: "Rob wrote: "Virginie wrote: "Guys! I've received a certain package an hour ago and...THANK YOU ALL! I LOVE YOU!
I read all the postcards and letters, admired all the drawings and read the amazing..."
That is adorable and very sweet!!! Love the story, may have been able to pick out some of you!
Brian wrote: "Is spreadsheet down? Only have black screen"It is working fine for me Brian.
can someone look into row 82 & 83 in my sheet? when I add date read, the total is off...
Mod
The month number was also missing from row 79, so you might not have been getting those points correctly, before, unless someone did a workaround...
I've broken my sheet, row 78 can someone who has a clue please have a look? I'll be super grateful!
Charlie wrote: "I've broken my sheet, row 78 can someone who has a clue please have a look? I'll be super grateful!"I'm only on my phone, so I'm not sure everything is back to normal, but there was something wrong with your page point formula, should be fixed now :)
Mod
EDIT: I see Anni fixed it... was the formula adding the book points with the month number?... Manju had that problem... we might need to doublecheck all the sheets around row 75-100, if so... some people might have had the problem and not even know....
Fantasy Buddy Reads
Books mentioned in this topic
The Way of Kings, Part 1 (other topics)The Way of Kings, Part 2 (other topics)
The Way of Kings, Part 1 (other topics)
The Way of Kings, Part 2 (other topics)
The Way of Kings, Part 1 (other topics)
More...
Got a response. She's alive. Dealing with family health stuff. Will return when she's in the mood to read & be social again.
No freak car accident. (That's what came to my mind with the sudden disappearance)