2018 Team Competition Tracker/Google Sheet Central

[Diana Stormblessed]

Iain wrote: "I figured it out, since it's not deleted, just neutralized, from his spreadsheet...

I think me, Siobhan, and everybody who spent all of Sunday in the Venting and Random chatter threads, could use ..."

You made me go check. Lol

[Siobhan]

Do we get points for reading ridiculously long threads on FBR now? XD

[Siobhan]

Haha just seen what he did 😂 😂

[Rob]

Iain wrote: "Rob wrote: "Good rule I've learned over the years of running fantasy baseball leagues - you can't change the rules once the contest has started. Every year has to be seen as an experiment. You use ..."

It has more to do with the fact that not all publishers list "word count" as part of their information. If it was standard industry pubishing practice to list word count as well as page count, we'd be golden.

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

It sounds like we need to rally against to publishers to make it standard lol. They're really cramping our style.

[Rob]

Niki Hawkes wrote: "It sounds like we need to rally against to publishers to make it standard lol. They're really cramping our style."

Just need to get everyone on Goodreads to do challenge competitions like us...create demand :) Then again, I've always wondered why the Sword & Laser group/podcast/videocast hasn't always been able to generate an amazon monthly deal for their bookclub pick on that basis with over 22k members.

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

Clearly they're missing a good marketing strategist lol.

[Margret, Caladan Brood Face]

I’m going to start holding buddy reads hostage for points..

You want me to set up this 10 book series? 10 points to me now 😂

[Timelord Iain, Tech Support]

Margret wrote: "I’m going to start holding buddy reads hostage for points..

You want me to set up this 10 book series? 10 points to me now 😂"

Mods DO participate in all Buddy Reads... they make the first post... start a mad dash to create the thread :)

Ope... that book is 680 pages... 3.4 Buddy Read bonus points to me...

[Rob]

Iain wrote: "Margret wrote: "I’m going to start holding buddy reads hostage for points..

You want me to set up this 10 book series? 10 points to me now 😂"

Mods DO participate in all Buddy Reads... they make t..."

Talk about true gamesmanship!

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

Ha! Participation points for mod setups and mod archiving. Brilliant! Haha

[Margret, Caladan Brood Face]

Well played Niki.. sneaking in the archiving like it was my idea 😉

[Timelord Iain, Tech Support]

Finally took the time to make the one change I wished I could before I had edit privileges on the scorecard... updating people's tab links... the ones that broke when we duplicated tabs to give people my sheet layout... I fixed Choko and Siobhan (so you can click on their names in the leaderboard and view their tab)... if anyone else's doesn't work, just let me know...

[Rob]

Iain wrote: "Finally took the time to make the one change I wished I could before I had edit privileges on the scorecard... updating people's tab links... the ones that broke when we duplicated tabs to give peo..."

Thanks, Iain. Didn't know there were broken links.

[Siobhan]

Thanks Iain!

[Timelord Iain, Tech Support]

It wasn't that important... I think I mentioned it at the time, but it got lost in the flurry of activity...

[Siobhan]

While you're editing... The colours are the wrong way round for House of Chains and Tome Raiders on the score summary! I think Tome Raiders should be purple? Their tabs are, and their score is xD

[Anni]

Thank you Siobhan!!! Every time I look at it, it bothered me a little bit, but I wouldn't want to sound nit-picky so I kept my mouth shut 😂

[Diana Stormblessed]

Anni wrote: "Thank you Siobhan!!! Every time I look at it, it bothered me a little bit, but I wouldn't want to sound nit-picky so I kept my mouth shut 😂"

Lol, me too. But I'm afraid of touching anything on the public tabs.

[Timelord Iain, Tech Support]

Siobhan wrote: "While you're editing... The colours are the wrong way round for House of Chains and Tome Raiders on the score summary! I think Tome Raiders should be purple? Their tabs are, and their score is xD"

Fixed... that happened when Rob tried to start making the team scoreboard sort itself by ranking... I think he ran into trouble and just manually rearranged them... so the ranking is accurate right now, but isn't always...

[Timelord Iain, Tech Support]

Diana Stormblessed wrote: "Anni wrote: "Thank you Siobhan!!! Every time I look at it, it bothered me a little bit, but I wouldn't want to sound nit-picky so I kept my mouth shut 😂"

Lol, me too. But I'm afraid of touching an..."

How do you think I feel?... Rob gave me access to the locked scoreboard a week or 2 ago... more tabs I can mess up... at least there are backups... both on Rob's Drive, and just in the sheet itself... you can click the "all changes save in Drive" text and view revisions...

[Siobhan]

Anni wrote: "Thank you Siobhan!!! Every time I look at it, it bothered me a little bit, but I wouldn't want to sound nit-picky so I kept my mouth shut 😂"

Hehe its been bothering me for a while so I thought while Iain was on he could maybe sort it... :) Thanks Iain!!

[Anni]

Yes thanks Iain! Now I can stare at the scoreboard all day 😂

[Virginie]

Siobhan wrote: "While you're editing... The colours are the wrong way round for House of Chains and Tome Raiders on the score summary! I think Tome Raiders should be purple? Their tabs are, and their score is xD"

Ha! It was driving me crazy lol. Thank you Iain :)

[Timelord Iain, Tech Support]

Lundos added pages/day to the Pages Read tab, I think (looks like his formula)... thanks... great stat to have...

[Rob]

I was playing with a pages/books read per day tab (sheet 19 all the way at the end. Haven't had the time to go back and really figure it out. Wanted to see our reading trends as a whole and as a team.

[Virginie]

Ooooh nice. I'll tweak the formula for Aristea and myself since we were added to the challenge later.

[Timelord Iain, Tech Support]

Biggest problem with your book counter is people type their dates differently

2/14/18
14/2/18
2018-2-14
etc

[Rob]

Iain wrote: "Biggest problem with your book counter is people type their dates differently

2/14/18
14/2/18
2018-2-14
etc"

Yes, i was putting a lot of faith into google to recognize the difference in formating. Might have to go back to each sheet and make sure it is identifying the format.

[Timelord Iain, Tech Support]

Rob wrote: "Iain wrote: "Biggest problem with your book counter is people type their dates differently

2/14/18
14/2/18
2018-2-14
etc"

Yes, i was putting a lot of faith into google to recognize the difference..."

Most date fields can be quickly reformated... just highlight the cells you want then click:

Format -> Number -> Date

OR

Format -> Number -> More Formats -> More Date and Time Formats

[Lundos]

Iain wrote: "Lundos added pages/day to the Pages Read tab, I think (looks like his formula)... thanks... great stat to have..."

It's mine. I cannot get it to be in one formula, so we will have to have some 'help' cells in AF1 and AF2.

[Lundos]

Iain wrote: "Most date fields can be quickly reformated... just highlight the cells you want then click:

Format -> Number -> Date

OR

Format -> Number -> More Formats -> More Date and Time Formats "

Yes, but sometimes Excel doesn't work like you want it to. So what we can do is add 'help coloums' in each sheet and SUMIF(S) from there. However, I'm still mindful of not overloading the sheet, but of course we can test it.

It's the same with the book count. Not every sheet has one, but we can it in the above 'help column' and COUNTIF(S) from there.

If you know what I mean.

[Virginie]

Ok, I made the change for Aristea and myself. I'm actually n°4 in pages/day, behind the three reading monsters. Too bad 4500 of my pages are from graphic novels... ;)

[Lundos]

Virginie wrote: "Ok, I made the change for Aristea and myself. I'm actually n°4 in pages/day, behind the three reading monsters. Too bad 4500 of my pages are from graphic novels... ;)"

Yes, you are. And n°7 in points pr. day.

We added some new features.

If you look at Virginie or my sheets, you can see a lot more data available if we want to add it. But it will take some manual work in each sheet at some point.

[Timelord Iain, Tech Support]

Lundos wrote: "Iain wrote: "Most date fields can be quickly reformated... just highlight the cells you want then click:

Format -> Number -> Date

OR

Format -> Number -> More Formats -> More Date and Time Format..."

We're creeping back into the things we were going to wait to fiddle with until the holiday seasons...

90% of sheets have page counts now... book count is something me and a few others added later... we don't tend to go around adding things to other people's sheets unasked anymore... since some people don't like it...

[Timelord Iain, Tech Support]

Virginie wrote: "Ok, I made the change for Aristea and myself. I'm actually n°4 in pages/day, behind the three reading monsters. Too bad 4500 of my pages are from graphic novels... ;)"

You probably need a more complicated formulat that takes the "Graphic Novel?" field into account and divides by 4... you actually added so many extra data cells you could do it yourself...

Change L1's formula to match L2 with y=n instead... and then make K1's formula = L1 + (L2 / 4)

[Virginie]

Iain wrote: "90% of sheets have page counts now... book count is something me and a few others added later... we don't tend to go around adding things to other people's sheets unasked anymore... since some people don't like it..."

I may have added a book count to Zaara's and Melissa's scoresheets without asking them. I'm counting on the nice colors to distract them 😈

[Virginie]

Iain wrote: "Change L1's formula to match L2 with y=n instead... and then make K1's formula = L1 + (L2 / 4) "

Yup, going to do just that. It'll be more representative of my reading habits :)

EDIT: Did it. I lost a few places :(
Also, you made me realize I had screwed up my GN page count. I was considering the "Buddy Read?" column. I actually read 6700 pages of graphic novels :o

[Bill]

I'm finishing that the spreadsheet takes several minutes to open my tab. The main scorecards data is also outdated until I update my tab. Are others experiencing this or just me?

[Scott , Karsa Orlong]

Bill wrote: "I'm finishing that the spreadsheet takes several minutes to open my tab. The main scorecards data is also outdated until I update my tab. Are others experiencing this or just me?"

It opens in under 5 seconds for me. Updates in under 10. I have a feeling as the spreadsheet gets larger and given the number of aggregates we are calculating it will continue to slow down.

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

It takes forever to load for me. To the point where I say hell with it and close it out for later. Patient, I am not.

[Virginie]

Bill wrote: "I'm finishing that the spreadsheet takes several minutes to open my tab. The main scorecards data is also outdated until I update my tab. Are others experiencing this or just me?"

Same as Scott. I was thinking of getting rid of the formulas for the points for previous books at the end of the month (doing a copy-paste only values) and tweaking some formulas to reflect this.
But... I'm not sure it'll actually "lighten" my spreadsheet ><

[Olivia]

Loads instantly for me still. I’m assuming people work older computers get hit earlier.

[Lundos]

Olivia wrote: "Loads instantly for me still. I’m assuming people work older computers get hit earlier."

Or on the phone.

It also works fine for me, though, it is slower than in the beginning.

[Bill]

I’m usually using my iPad which is the newest model out. I’m using Google Sheets instead of Excel so wonder if that could be it. Going to fire up my pc and see how it does there.

[Siobhan]

It loads slow on my phone. Same as Bill, I have to make a change on my tab before everything else seems to update itself.

[Bill]

Works fine from my PC. So maybe I’ll have to start doing weekly updates from there.

[Hacen]

Siobhan wrote: "It loads slow on my phone. Same as Bill, I have to make a change on my tab before everything else seems to update itself."

Same here

[Timelord Iain, Tech Support]

I think it depends how fast your computer/internet is... and how many books you've read... it's getting slower for me... I have 63 books read and another 67 pre-filled into my sheet... sometimes I have to reload the sheet for calculations to be done and to update my books/pages read and total points...

I didn't know anyone was successfully using the sheet from their phone, MY phone won't switch between tabs, it just reloads the first tab with the tallies any time I click anything...

[Timelord Iain, Tech Support]

Virginie wrote: "Bill wrote: "I'm finishing that the spreadsheet takes several minutes to open my tab. The main scorecards data is also outdated until I update my tab. Are others experiencing this or just me?"

Sam..."

I did a bunch of formula work on my sheet last month... then I copied my sheet to my Google Drive account as a backup and deleted all the extra formulas (books/month, pages/day, expected end-of-year totals if I don't slow down, longest book, shortest book, average book, etc)