Fantasy Buddy Reads discussion
Archive [General]
>
2019 Team Competition Tracker/Google Sheet Central
Mod
Timelord Iain (Eeyawn) wrote: "What's going on with Rob's M2 formula?... it says 0.3 = 113% of 0.3"Page points are not rounded at that stage, but when summed with BR/Challenge points. So his page points are actually 0.34, and his total points 0.30...
Mod
I fixed mine and Kari's :)EDIT: and Lundos'
I modified my sheet and I think I didn't break anything (at least I hope so...)Still I'm not sure what P14 is supposed to do, is there something wrong?
Mod
Still I'm not sure what P14 is supposed to do, is there something wrong?"
Pretty sure P14 was the link used in A14 to take you to your last book entry...
Yes it is, I found Virginie stalking my sheet :) But thanks, anyway!
Mod
Yea... I just stared at it for a minute, now that my weekly call from my grandma is done, and it just returns 0 right now, since you haven't read any books yet, so all the cells are blank...
Plug in a Date in the Date column... months start appearing in the month column... link starts pointing to the first blank row...
It's a useful link for people that read a lot and don't group their rows by month or anything, but since I generally do month groupings so my current row is less than 1 page down, it was unneeded and I deleted it from my sheet (and added in November/December, with formula limiters to not count them in the top row competition points... this is much easier with this year's layout, since I set it up for the competition tally to just add up the monthly rows instead of the whole sheet... =sum(G4:G13) vs =sum(G4:G15) vs =sum(G16:G)
Timelord Iain (Eeyawn) wrote: "Sir Anni wrote: "Yes it is, I found Virginie stalking my sheet :) But thanks, anyway!"Yea... I just stared at it for a minute, now that my weekly call from my grandma is done, and it just returns..."
Haha yes, I tried it out a few times by adding dates and books with higher pagecounts and it looked ok.
I'm at work today and if it's quiet in the morning, I can use the computer here, I maybe was a little too excited to finally work on my sheet on a computer 😂
Mod
Coul..."
This just solved a dilemma for me, THANKS... with Data Validation, and the month column being important, I can just enter Buddy Read Dates as text (January 8th) and the invalid inputs means that the points won't be added to my tallies, which is great...
Aaaah, I didn't think of this being applied that way! Very clever, Timelord :)
Timelord Iain (Eeyawn) wrote: "It's a useful link for people that read a lot and don't group their rows by month or anything, but since I generally do month groupings so my current row is less than 1 page down, it was unneeded and I deleted it from my sheet"Yeah, I mainly made the link (and the monthly ones) to avoid having to go around and create monthly headers for several people (like I did last year).
Mod
Anything to avoid adding more and more columns... I WAS using the author column as a temporary read date column for pre-filled BRs, but this is better... I think we're in some kind of loophole... as validated dates, January 8th is technically a date, but the Month() formula can't parse it... I remember there being a problem with data validation not letting me input invalid inputs last week... maybe I checked a checkbox that I didn't in my own sheet, or something...
Yup. In the Data Validation menu, you can choose either to get a warning when you input invalid data, or it refused altogether.
Mod
Timelord Iain (Eeyawn) wrote: "Kind of annoying how charts can't be in frozen or hidden areas..."+1
Mod
Then Yanique's donut chart got me thinking about the unique function... I tried several permutations and google searches and ended up with:
=countunique(iferror(filter($C$18:C, $Q$18:Q=1)))
This formula filters my series column to get a list of all series I read in January, then counts uniques to tell me how many different series I read... the iferror is the only way to return 0 instead of 1, when there are no entries yet (February thru October)... this works best if you have the setup me and Karishma have, where there's a separate column for book # in series... so that Hercule Poirot #1 & #2 don't count twice, for example...
I loved that donut chart with genre but I don't know where to put it on my sheet. my sheet already looks so full. :(
Mod
I created a new column off to the side, past everything else, including the hidden monthly column... made it wide enough to hold the chart, and basically consider it a holding area for any new charts I decide to add... it leave a bit of a hole in the frozen area at the top, since I need that to be frozen, but it's off my screen, anyway, so I'm not too worried, anyway...
I'm probably going to add that publication date scatterplot chart, at some point, as well...
Mod
Timelord Iain (Eeyawn) wrote: "Em Lost In Books wrote: "I loved that donut chart with genre but I don't know where to put it on my sheet. my sheet already looks so full. :("I created a new column off to the side, past everythi..."
can you put that donut chart with genre in my sheet? after column P?
Mod
I don't think so... finding Julia's points too crazy?
Main books I can think of that would have affected the majority of us, last year, are the Percy Jackson / Magnus Chase / Camp Halfblood books, Narnia, and maybe Harry Potter...
It's interesting how differently Julia & Soo are earning their points... Soo is earning a lot more BR & Challenge points, but losing some points to audio... Julia is 97% pages... they're both averaging over 650 pages at the moment... meanwhile, I only recently broke 400 after a slow start, and most people are lucky to read 200-300 a day...
At the moment, they're on track to read 220,000 pages this year, but I dunno that they can maintain this pace for 300 days...
Mod
Only thing I found, searching discussions, was a suggestion Lundos brought up back in March:
https://www.goodreads.com/group/comme...
https://www.goodreads.com/topic/show/...
Me and Virginie found this steep, and were open to making YA count 50-66% as much... counting them at 25% like Graphic Novels seemed steep, considering they're not THAT much faster to read than an "adult" book... not like Graphic Novels with their handful of words/page anyway...
I think, what's making YA books so crazy right now, is pairing it with the non-audio bonus...
The other thing we brought up, in the Lundos discussion, was where to make the cut-off for this new points ruling... Harry Potter is a good example... the early books are Middle-Grade/YA, but the series gets darker as it progresses, and has a real turning point at the end of Goblet of Fire, when people start dying...
Timelord Iain (Eeyawn) wrote: "Niki Hawkes wrote: "I should know this, but I’m to tired to fish through all the dialogue to refresh my memory... did we introduce a point reduction for middle grade books? I think we meant to."O..."
I think YA should not count for lower points - most of them take as much time to read as any other book.
Children's books yes - there could be point reduction for them.
Mod
I created a new column..."
Implemented!
I added 2 new columns, and put the Genre List & Genre Totals there (this is better than my setup, since at that time, I wasn't adding anymore rows)... You have room to adjust and add genres... but you're limited to 10-11 options... if you need more, you'll need to adjust the chart range and formulas...
Genre is a blank-slate setting... mostly because i implemented EVERYTHING from my sheet... this includes a conditional formatting that highlights which books you've read that match your current selected genre at the top... the monthly section also changes it's totals based on which genre is currently selected, so you can figure out which genres you preferred each month...
Anyway, the Genre option is because I didn't always want those conditional rows highlighted... have fun...
Mod
Yea... that was our basic consensus, as well... I think children's books just aren't allowed... if they're full-on picture books you read to get your kids to learn to read & go to sleep, anyway... not talking middle-grade...
Timelord Iain (Eeyawn) wrote: "Em Lost In Books wrote: "Timelord Iain (Eeyawn) wrote: "Em Lost In Books wrote: "I loved that donut chart with genre but I don't know where to put it on my sheet. my sheet already looks so full. :(..."it's fantastic. I loved it! Thanks! :D:D
Karishma wrote: "Timelord Iain (Eeyawn) wrote: "Niki Hawkes wrote: "I should know this, but I’m to tired to fish through all the dialogue to refresh my memory... did we introduce a point reduction for middle grade ..."I agree.
There are some books where you could argue wether they are adult or YA. Additionally, not every adult book can be read at the same reading speed. If we take classics for example, they probably take most people longer to read than your average fantasy book.
I really wish each book had its word-count printed with it - I think that would make tracking reading-time so much more accurate!
Niki Hawkes wrote: "I should know this, but I’m to tired to fish through all the dialogue to refresh my memory... did we introduce a point reduction for middle grade books? I think we meant to."Talked about it, but it went nowhere in the end 'cause the line between MG, YA and adult books isn't clear-cut.
...i want to join the challenge just for the spreadsheet
Sha wrote: "...i want to join the challenge just for the spreadsheet"Sign up. 😊
Seán wrote: "I really wish each book had its word-count printed with it - I think that would make tracking reading-time so much more accurate!"We all do. If there only were a database somewhere
Hello Excel gods and goddesses,Just wanna know if there’s a lag when people fill in the book using the form? I tried using the form about 10-15 minutes ago, since I’m on apps and it’s not showing up yet.
Mod
Just wanna know if there’s a lag when people fill in the book using the form? I tried using the form about 10-15 minutes ago, since I’m on apps and it’s not showing..."
You seem to be the first to use the form since the competition started... something seems to have broken down, since Virginie added the checkbox column and removed the test values from the responses...
Best thing I've found with google is this: https://stackoverflow.com/questions/1...
I don't want to break anything further, but someone might have to unlink the form and link it again to create a Form Responses 2 tab, then find and replace all instances of Form Responses 1 with Form Responses 2...
This should repopulate the new spreadsheet with all responses saved to the Form... to facilitate this, I went in and hard-deleted all the fake responses me/Rob/Virginie made last month... still need to delete the newest test Virginie did an hour ago, first, if no other solution is found...
Barry wrote: "Hello Excel gods and goddesses,Just wanna know if there’s a lag when people fill in the book using the form? I tried using the form about 10-15 minutes ago, since I’m on apps and it’s not showing..."
It should fill the Form Response tab immediately. I went and did a test entry as well... Doesn't seem to work :/
I haven't really worked on this, so I'm not sure what to do... Maybe Iain or Rob will have more info.
In the meantime, I added your book to your personal scoresheet. Bam, 23.2 points for you! :p
EDIT: And yet again, Iain was faster! :D
Ok, I don't know if Iain did something or if the fact I switched OFF then ON immediatly the 'responses accepted' toggle thingy on the form settings did the trick, but it's working again... :O
Mod
Wasn't me, I don't think...
Mmmh. I think my manip had the same effect as unlinking/relinking the form to the sheet, then.I switched the toggle just to see what would happen, but it all worked out in the end! All is well! :p
(pfiou, I'm so relieved I didn't break anything by pressing all the buttons like a 5-years-old...)
Mod
I switched the toggle just to see what would happen, but it all worked out in the end! All is well! :..."
Re-enactment: https://www.youtube.com/watch?v=Ti3mW...
Mod
I definitely think Middle grade and YA books should count for less. The format allows them to have bloated page numbers which do not correspond to actual word count. We can see this when you compare an audiobook of an adult book and a YA book of the same page count, the adult books are sometimes twice as long.
Since other formats have penalties (Graphic, audio) then I personally think this should be considered.
There are lots of books that are in YA that aren't YA in writing style or content. I can understand the penalty for audio but I think configuring the differences between YA/NA/Adult are too subjective. There are fantasy books in the Literature section of the bookstore because that's what the publishers decided for whatever reason. Wordcount does not affect my reading speed. Content and how much I want to think about the words affect my reading speed. Kindle books can have extra content that's not a part of the book and that would be a part of the wordcount.
I had contacted Goodreads on the whole word count issue last year and was told that simply that not every publishing house reports them and there are consistency issues. In other words, its probably never going to happen.
Rob wrote: "I had contacted Goodreads on the whole word count issue last year and was told that simply that not every publishing house reports them and there are consistency issues. In other words, its probabl..."Julia finished her blaze through Harry Potter..so the whopper point totals should slow down. Drives me crazy how much time she has to read during her day and how little I have :) Two-hour delay today, so she woke up around 6:30 and grabbed Harry Potter and the Cursed Child and read it till she was done a few hours later.
Trying to get her to read the Wheel of Time, Feist and Eddings this year.
Virginie wrote: "Barry wrote: "Hello Excel gods and goddesses,Just wanna know if there’s a lag when people fill in the book using the form? I tried using the form about 10-15 minutes ago, since I’m on apps and it..."
Thank you Excel Goddess 👍.
Timelord Iain (Eeyawn) wrote: "Re-enactment: https://www.youtube.com/watch?v=Ti3mW..."BWAHAHA! That's exactly it :p
What Soo said. Its too subjective.I read a 300 odd page YA book the other day in 2 sittings, flew through it. Then I started another 300 odd page YA book and it feels like a lot more words per page, definitely a bit longer read. But there's so much variation you can't do anything about it.
And that's not just the case with YA.
Mod
I guess we’ll leave it the same this year since we never actually initiated a change and see how it goes. There are a few robust middle grade books, so maybe that’ll balance out the small ones.
Mod
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...
Ah, I remember that change being decided - thanks for clearing that up Iain :)