Fantasy Buddy Reads discussion

Niki Hawkes wrote: "I just did my first book update - 22 pts. :) My personal goal is to improve on my page count every month by getting more consistent at choosing books over other forms of entertainment. So far so good."

Well done Niki! :) :)

Can someone look at my sheet? I want the row of 'The name of the wind' moved between row 15 and 16 and there's something wrong with the date of the book. I want it in the same format as the other dates.

Done!

If you want to move rows again, take a look at that comment: https://www.goodreads.com/topic/show/...

I explain how to select an entire row and 'slide' it :)

Okay, thanks, Virginie! Normally I know how to do that, but I'm not used to work with spreadsheets.

My interesting stat for 2020... making even teams:

Me & Soo combined = 3020.9 points
3rd thru 9th place = 3110.3 points
10th thru 19th place = 3004.5 points
20th thru 44th/46th place = 3097.4 points (2 people haven't input any books)

I was kinda impressed how close the scores ended up, considering I didn't rearrange anything, just picked 3000 point minimum, and noted beforehand that me & Soo were 24% of the points for the year...

Math done by highlighting cells with Shift-Click, and viewing the sum in the bottom bar on PC browser...

I like 3 as a number. =D haha

I may yet enter in Julia's reading history and my own.

Rob wrote: "I may yet enter in Julia's reading history and my own."

Please do Rob!!

We're losing ground! 😂

Siobhan wrote: "We're losing ground! 😂"

Did the easy part, got myself up to date! Jumped 9 places and added about 60 or so points.

Started working with Julia to get up to date. It's going to be an effort :)

Rob wrote: "Siobhan wrote: "We're losing ground! 😂"

Did the easy part, got myself up to date! Jumped 9 places and added about 60 or so points.

Started working with Julia to get up to date. It's going to be a..."

Good luck! Stay strong! 💪😅

Something's wrong with the spreadsheet guys - broken formulas allover the front page.

[image error]

Siobhan wrote: "Something's wrong with the spreadsheet guys - broken formulas allover the front page.

"

FIXED... All Sha's fault... somehow... chain reaction really... one cell's formula broke (from back in February), which broke all her points formulas, which broke the rankings...

Seeing her as the only #REF error in the points column was the first clue...

You're a star :D

Haha I noticed that Sha might be the source, but would dare try to fix it! XD

Oh wow! Bloody Tome raiders have reached 7K! Who fills in the achievements chart?

Ooh, and we crossed 1 million total pages you guys! Nice going everyone!

Siobhan wrote: "Oh wow! Bloody Tome raiders have reached 7K! Who fills in the achievements chart?"

It's basically just me, when I remember, but I haven't even been filling in my own sheet...

I did my best to fill in everything... it's easier to accurately date Soo's stuff than the team stuff...

Hope it's not too salty to say the solo/team milestones are less interesting, when it's basically just a record of one person/team... part of that is me & Soo's outlier numbers, and the other is the 2 team format this year...

Virginie's changes to the ranking page, to track % was a great change-up...

The tracking of everyone reading 1 million & 2 million pages is still great, tho :D

Timelord Iain wrote: "Siobhan wrote: "Something's wrong with the spreadsheet guys - broken formulas allover the front page.

"

FIXED... All Sha's fault... somehow... chain reaction really... one cell's formula broke (f..."
T_T I don't know why this keeps happening when I add stuff to get sheet I feel like there is a curse.

Timelord Iain wrote: "Siobhan wrote: "Oh wow! Bloody Tome raiders have reached 7K! Who fills in the achievements chart?"

It's basically just me, when I remember, but I haven't even been filling in my own sheet...

I di..."

I love the percentages most, and the total pages! :)

Sha wrote: "Timelord Iain wrote: "Siobhan wrote: "Something's wrong with the spreadsheet guys - broken formulas allover the front page.

"

FIXED... All Sha's fault... somehow... chain reaction really... one c..."

Haha bless ya! ❤️

Whoa, I missed all the fun! Thanks for fixing everything, Iain :)
I kind of ignored this spreadsheet for a while, hoping that nothing (big) would break... So far, so good!

I still have a ton of unfinished/half-implemented improvements on my own scoresheet 😰

Yeah, I agree that milestones are less interesting with only two teams. The % change was self-motivated. I wanted a way to worm my way to top ranks without being one of the reading powerhouses LOL.

Minor tweak request - on the Short Story/Novella/Novel/Tome breakdown bar, could I get the threshold between novella and novel adjusted from 250 to 200 pages please? I think that's a better fit, as some of those shorter romance novels are throwing things off.

Done!

Thank you Virginie! (^_^)

Asking this here...

Today I was happy to see the the new The Sandman audiobook was out on Audible and downloaded it. I'll be listening to it soon enough, but when looking at it for the challenge I was like, page counts...ummm. There is not a print edition of this thing.

But. I saw that it's an adaptation of the comics that is covered by The Absolute Sandman, Volume One, so using the page count from there at 616, does this seem fair? Also, it's 11 hours of audio so not sure how that translates over.

I'm gonna use 450 as the page count. I looked up other books that are around 11 hours. =)

In the rules thread, we decided audio-only books were 30 pages/hr, or a page every 2 minutes... that's the average book narration rate at 1x speed...

~330 pages is better than the Graphic Novel Rule, which would be 616/4 = 154 pages...

Ok, will update to that.

Ok, that makes sense. I'll go with that too.

Thanks!

Hey guys!
Can someone please add november and december to my sheet? Thanks :)

Angela Jr. wrote: "Hey guys!
Can someone please add november and december to my sheet? Thanks :)"

I did what I could with it...

November/December rows have been added... I think I fixed all the formula errors when i copied them... just message again if you notice something...

Basically what I gave Soo last week...

I changed the Total Pages/Points to only track thru Halloween for competition tracking... and added a column on the far right to give you the accurate 2020 pages...

Yay! I'm not the only one that likes the tracker and wants it for the whole year. lol =D

can I have it too please?

Could I as well, please? I love all that data!

Me too, please, thank you in advance!

Thanks iain :)

Soo wrote: "Yay! I'm not the only one that likes the tracker and wants it for the whole year. lol =D"

Yes, it's great! I had it for the whole year in 2019 as well (even though i hit a severe reading slump and didn't read a single book in nov and dec LOL)

Went in and gave everyone that asked the changes... the more I did it the faster I got at it... and I found a real annoying issue with the month formulas...

Someone setup January to be fully draggable, but left February-October hardcoded... once I realized that, I could just drag January down and all the monthly formulas adjusted themselves...

I also finally realized the issue Soo was having with Double December... it's because the month name is also a formula, but needs a month number in the hidden column on the right (11/12)... otherwise it defaults to December for some reason...

And I moved everyone's 2020 page total to the boxed section on the left, so I no longer needed to add a column on the right..

Thanks! Glad you found the error. =)

Thanks Iain!

My page count is being weird. If I use the blocking and drop down to see the amount it shows 42.340 pages but top box now only shows 33,717.

I’ll go in and check when I get home... sounds like a formula problem in the monthly section... the top formula just grabs the numbers from January to October, to keep competition numbers separate from 2020 numbers... is the 2020 number on the left accurate, below the short story/book/tome tracker?

Timelord Iain wrote: "I’ll go in and check when I get home... sounds like a formula problem in the monthly section... the top formula just grabs the numbers from January to October, to keep competition numbers separate ..."

Nope, it's the same as the top box next to total pages.
I am pretty sure it is more than 33k since my GR bookshelf stat shows 39k and the FBR sheet is much more accurate since I also included books I did not put in GR.

I fixed it... I don't think I broke it...

It's actually a common problem when adding rows to the sheet... the formulas don't copy when you insert rows... and it's easy to notice that in the point section...

What's less obvious, is the hidden column on the far right, where we parse out the month so we can assign points/pages to each month correctly at the top... to fix that, you need to unhide the column and drag the formula, basically any time you add rows to the sheet...

Doing this, boosted your totals by 6000 pages and nearly 100 points... I think the rest of your summed pages are for books you haven't listed as finished yet...

I've been gone for so long, but I've been updating my reads. Hopefully nothing's amiss with my numbers.

Timelord Iain wrote: "I fixed it... I don't think I broke it...

It's actually a common problem when adding rows to the sheet... the formulas don't copy when you insert rows... and it's easy to notice that in the point ..."

Hmm I thought I copied the formula when adding rows but maybe I did not. I also just found out that hidden column. Thank you, Iain, really appreciate the help :)

Just a small bug, but I noticed Niki's page points seem to be off. The total points seem to add up though.

Melissa wrote: "Just a small bug, but I noticed Niki's page points seem to be off. The total points seem to add up though."

Whoever input Niki's September books input the date as text (Sept 7) instead of a date (9/7/2020)... fixed...

Hey, it looks like someone messed around on my Tracker page. Hopefully nothing was deleted because that would be very long & frustrating process for me to fix.

It's kinda weird to go on my Tracker and see it different from how I left it. Font colors are easy to fix but other things may not be as easy to fix because I don't know what happened on the page.

I know we can all look on each other's trackers but please be kind & not actually try to move stuff around.

You should be able to go to the version history and see what was changed. I'm sure Iain will be able to tell you more.

Total book count looks right. So I'm going to guess it's ok. Honestly, I use the Tracker more to keep track of what I read and what I want to read than for the points. lol

I love the summary log parts that notes now many books I read & page count, etc. Kudos to our Tracker Gurus.

Points for the Team is just a nice bonus. =)