2018 Team Competition Tracker/Google Sheet Central

[Timelord Iain, Tech Support]

Sir Anni wrote: "Margret wrote: "No worries Anni, Julia is a titan when it comes to reading"

I know, I know... I don't want to sound ungrateful, I had just hoped for a team a little more active/ talkative... And n..."

You're always welcome over at the Cool Kids Table ;) (Tome Raiders)

[Siobhan]

(view spoiler)[#teampillowfightclub (hide spoiler)]

😁

[Jenna, I'd be free if not for Temper & Edgewalker]

Sir Anni wrote: "Margret wrote: "No worries Anni, Julia is a titan when it comes to reading"

I know, I know... I don't want to sound ungrateful, I had just hoped for a team a little more active/ talkative... And n..."

You'll always have a place with the Jaghuts! :)

[Chris]

Anni and I can come visit the Jaghut camp and see how the new kids are doing.

[Margret, Caladan Brood Face]

I apologize Anni, I unfortunately have a mental illness that showed it’s ugly face this year, so I had to unplug for quite a bit of time and was not there to start conversation with my mates. But I’m doing so much better now. I think you’ll be pleasantly surprised with our team and the level of conversation this year

[Yanique, Thread Master]

Sir Anni wrote: "Margret wrote: "No worries Anni, Julia is a titan when it comes to reading"

I know, I know... I don't want to sound ungrateful, I had just hoped for a team a little more active/ talkative... And n..."

Two members?

[Timelord Iain, Tech Support]

Yanique wrote: "Sir Anni wrote: "Margret wrote: "No worries Anni, Julia is a titan when it comes to reading"

I know, I know... I don't want to sound ungrateful, I had just hoped for a team a little more active/ t..."

Rob's daughter (Julia) & Bill's sister (Jessica 3)

[Jenna, I'd be free if not for Temper & Edgewalker]

Yanique wrote: "Sir Anni wrote: "Margret wrote: "No worries Anni, Julia is a titan when it comes to reading"

I know, I know... I don't want to sound ungrateful, I had just hoped for a team a little more active/ t..."

I think she meant Bill's sister, Jessica, who until about 30 min ago was just Bill's sister and we had no idea who she was.

[Niki Hawkes, I made it past GOTM... barely]

Lol jenna

[Scott , Karsa Orlong]

Timelord Iain (Eeyawn) wrote: "Scott wrote: "So we ended up swapping Julia to Margret's team to keep her with Rob and I get Choko in return."

Looking at the numbers, that was gonna be my suggestion :)

The closest person to Rob..."

We talked about a couple of two for two swaps to even it out as well but Margret wasn't parting with the the one person who's point total made that plausible from her team.

[Anni]

Thank you all, that's very sweet :)
So Jessica will join us as well then, or will she just add her points like Julia did last year?

I guess, I will just make it my holy mission to get my team talking!
If necessary I will threaten or bribe them and if nothing else help I will talk to myself 😂

[Margret, Caladan Brood Face]

Don’t worry Anni it won’t be difficult. When I’m doing well I’m quite chatty and I’m feeling great! I’ll be posting questions etc about the books we’re all reading to get the conversation flowing. I think I might have to add in some incentive for top team points for some handmade apparel too ;)

[Anni]

Margret wrote: "Don’t worry Anni it won’t be difficult. When I’m doing well I’m quite chatty and I’m feeling great! I’ll be posting questions etc about the books we’re all reading to get the conversation flowing. ..."

Sounds great! :)
And we would totally rock that category!

[Bill]

Sir Anni wrote: "Thank you all, that's very sweet :)
So Jessica will join us as well then, or will she just add her points like Julia did last year?

I guess, I will just make it my holy mission to get my team ta..."

She is actually in the group but beyond using GR to track her books she doesn’t really know how to navigate to the discussions. I’m going to see her tomorrow night so will show her how to join in and nag her until she does.

[Rob]

Timelord Iain (Eeyawn) wrote: "Rob wrote: "We would like to have a primer ready and are toying with an audio instructions podcast ;) but not likely."

That's news to me..."

I think Virginie cleared that conversation from the sheet :)

[Virginie]

It's still there, simply hidden. I think we got to 500 lines of conversation on that spreadsheet :O

[Siobhan]

Bill wrote: "Sir Anni wrote: "Thank you all, that's very sweet :)
So Jessica will join us as well then, or will she just add her points like Julia did last year?

I guess, I will just make it my holy mission ..."

Yessss! Nag poor Jessica until she lives, sleeps and breathes FBR!! 😂😂

[Virginie]

Ok, I feel the need to share the latest Scoresheet Development Team crisis:

I was happily writing the last of the explanations on how to use the spreadsheet when Iain popped up to announce that the formulas for the points calculations were all wrong, and "no, not just here but on ALL 51 SCORESHEET".

A moment of disbelief followed by a (longer) moment of loudly swearing and cursing (so loud my poor cat was startled awake and then run away) later, I went to fix the offending formulas. And copy-pasted them 50 times on the other sheet. Then realized the new formula was still wrong, and did another round of 50 copy-pasting...

So... The spreadsheet is done and ready, but I'll have Iain triple-check everything before we share it :P

[Siobhan]

Hahahaha 😂
Just laughing at you offending your cat with your swearing! 😂

Hope it ends up OK, thanks for all your hard work! ❤️

[Timelord Iain, Tech Support]

And here I was, merrily sleeping the day away, after I dropped the bombshell........... I knew I'd just thrown a wrench into the works, but it couldn't be helped :(

[Timelord Iain, Tech Support]

I don't see anything immediately wrong... best way to know for sure is to probably let people in and start fiddling around... create a bunch of fake book entries, and see what happens... we have 3 weeks to fix anything we missed... and if we missed anything, it's probably with the Bells & Whistles, not the main formulas, at this point...

[Rob]

Virginie wrote: "Ok, I feel the need to share the latest Scoresheet Development Team crisis:

I was happily writing the last of the explanations on how to use the spreadsheet when Iain popped up to announce that th..."

Eep and I was missing in action all day visiting relatives! Sorry I wasn't around to help out Virginie!

[Angela, I'm Silverfox lost]

I just want to say how amazing you guys are for organising the spreadsheet. I'm looking forward to seeing what it looks like.

[Jenna, I'd be free if not for Temper & Edgewalker]

Virginie wrote: "I went to fix the offending formulas. And copy-pasted them 50 times on the other sheet. Then realized the new formula was still wrong, and did another round of 50 copy-pasting..."

This reminds me of the annoying task of creating folders in this group....which is seriously my least favourite mod job. So tedious (but no formulas so that's a plus). We really really appreciate you guys taking the time and effort to make the spreadsheet. We know it's a ton of work <3

[Timelord Iain, Tech Support]

Except for me... half the work... all the praise... I joined late, and supplied some layout ideas & Form Calculation integration, but left the bulk of the formulas & coloring to Virginie, who had more experience playing with really long formulas last year... I prefer shorter formulas, and maybe storing intermediate steps in hidden cells...

[Virginie]

@Rob: don't worry about it; I got all worked up while copy-pasting theformulas, thinking "Aaah, that's what happens when you rush and don't do enough testing" before realizing, as I got to the last scoresheet, that I actually never tested the new formula I was implementing xD

And sure enough, there was a problem... My own fault, really :p

[Rob]

We are officially launched!

Please bookmark the following link as you'll be using it....for 10 straight months!

2019 Fantasy Buddy Reads - Tracking System

This year we do have an alternative if you do not wish to mess with the sheet or in addition to the sheet if you're on a phone and don't want to have the load thing. Just use this handy-dandy form. The data you enter will go into a special sheet right in the workbook to be added into your points totals!

Handy Dandy Book Entry Form Bookmark me too!

Please go to the Primer tab first to get started. Any questions, Virginie, Iain, or myself can help you out right here.

Special thanks to Ms. V who did the lion's share of the work this year and thanks to Iain who took my idea with the form and ran with it to make it happen.

[Virginie]

I'm nervous xD

[Rob]

Virginie wrote: "I'm nervous xD"

Precisely why we're launching 3 weeks before we start. Beta testing time!

Actually, I'm geeking out and might add a few of my planned buddy reads to my sheet just for fun (without the date read of course).

[Timelord Iain, Tech Support]

Rob wrote: "Virginie wrote: "I'm nervous xD"

Precisely why we're launching 3 weeks before we start. Beta testing time!

Actually, I'm geeking out and might add a few of my planned buddy reads to my sheet just..."

I'll be pre-adding my first 3 months, sooner than later... I've got like 22,000 pages planned already... I'm booked...

[Timelord Iain, Tech Support]

Rob wrote: "We are officially launched!

Please bookmark the following link as you'll be using it....for 10 straight months!

2019 Fantasy Buddy Reads - Tracking System

This year we do have an alternative if ..."

Some of the nifty Bells & Whistles look weird right now, showing negative numbers... that's because their formulas involve the difference between today's date & January 1st, 2019... so they are negative numbers instead of positive ones... this will look normal once the competition starts... (you won't notice this until you start putting sample book entries into your spreadsheet/form)

[Rob]

Timelord Iain (Eeyawn) wrote: "Rob wrote: "Virginie wrote: "I'm nervous xD"

Precisely why we're launching 3 weeks before we start. Beta testing time!

Actually, I'm geeking out and might add a few of my planned buddy reads to m..."

Ugh and this year I don't get to root for you doing that :)

[Virginie]

Rob wrote: "Ugh and this year I don't get to root for you doing that :)"

But I do! Muhahahaha!

[Rob]

Virginie wrote: "Rob wrote: "Ugh and this year I don't get to root for you doing that :)"

But I do! Muhahahaha!"

Oh it's like that is it !?!?! - it's on like donkey kong!!!

[Yanique, Thread Master]

You Guys!!!

Great job on the spread sheet, I love it!

[Virginie]

@Rob: all you've got to do to neutralize both me and Iain for a few days is send us on a spreadsheet rabbithole :p

[Timelord Iain, Tech Support]

I love how we released the sheet... you guys deleted all our fake form entries and stuff (I told Niki about the 10k page Dragons Everywhere book already)... but left Virginie's world domination stuff in the news section of the main page :D

[Timelord Iain, Tech Support]

Virginie wrote: "@Rob: all you've got to do to neutralize both me and Iain for a few days is send us on a spreadsheet rabbithole :p"

Time to improve the 2020 spreadsheet >:D ... it reads the books for you...

[Virginie]

Timelord Iain (Eeyawn) wrote: "I love how we released the sheet... you guys deleted all our fake form entries and stuff (I told Niki about the 10k page Dragons Everywhere book already)... but left Virginie's world domination stu..."

Argh, it's still here?!? 😅

[Kathrine]

I'm super intimidated by the entire thing right now. I'm scared to even look at it in case I mess something up. But it looks awesome and super advanced – well done, guys!

[Karishma]

Noooooo the nerd chat is hidden!!

[Karishma]

Looks like your world domination plans are out Virginie!

[Karishma]

And btw the sheet is amazing, great job all of you!
Can't wait to use it next year!

[Diana Stormblessed]

Yay! Thanks or the hard work guys. Are we still allowed to personalize our sheets with colors, etc?

[Timelord Iain, Tech Support]

Diana Stormblessed wrote: "Yay! Thanks or the hard work guys. Are we still allowed to personalize our sheets with colors, etc?"

Yup... the formulas are the only important part...

[Timelord Iain, Tech Support]

Kathrine wrote: "I'm super intimidated by the entire thing right now. I'm scared to even look at it in case I mess something up. But it looks awesome and super advanced – well done, guys!"

This is the time to practice... Rob and maybe others will have backups... and you can make a copy yourself, to your Google Drive if you have a Google account... and fiddle around without risking the main sheet if you're worried...

[Timelord Iain, Tech Support]

Day 1, and Virginie already has double the stats on her sheet...

[Diana Stormblessed]

Why can't I change the color for the point cells? (L-N) Whenever I try to change the color nothing happens. I mean if it is what it is I'll live, but if I'm just doing something wrong I'd rather be set straight :-)

[Virginie]

Diana Stormblessed wrote: "Yay! Thanks or the hard work guys. Are we still allowed to personalize our sheets with colors, etc?"

Like Iain said, color away! Tell me if you need help with the conditional formatting (the cells that stay stubbornly green)

EDIT: Argh, too slow!

[Rob]

Virginie wrote: "@Rob: all you've got to do to neutralize both me and Iain for a few days is send us on a spreadsheet rabbithole :p"

hmmmm....ok interactive live chat function inside google docs with video that counts the number of words you say as you speak. Go.