Fantasy Buddy Reads discussion
note: This topic has been closed to new comments.
Archive [General]
>
2023 Team Competition Tracker / Google Sheet Central
Dittoing Mel--Navi I hope everything goes well with you!
Mod
There’s a reason it’s a team competition, and not solo…
Heh, I remember I used to think I was a fast reader, then I met Soo and Iain and Choko...
Mod
Just do what you can.
Um... @Iain, oh Master of Spreadsheet Manipulation... I had some more thoughts about changing my spreadsheet, if it's not too much trouble...I know I asked you to change the Y/N audiobook one to recognize L,H,A for audiobook, and p/e for eyebook, but I'm wondering if I could change that again?
I was thinking of making that format column also work for graphic novels, and then change the graphic novel column into a where? column that isn't connected to any statistics...
Like, the format column could recognize a for audiobook, e/p for eyebook, and g for graphic novel, with the accompanying math.
Then the graphic novel column could be disconnected from the math, and I can put on which platform I read the book there!
Is that acceptable?
Thank you so much in advance!
Mod
Thank you! I hope you get some good rest this weekend...
Mod
I know I asked you to change the Y/N audiobook one to ..."
The math changes work now... not sure what you want to do with the monthly section of the Where? column, tho...
I should probably clean it up at some point... the formulas support the old y/n answers and your newer ahl/ep/g answers... which don't make sense with the headers... don't even have to change anything to make the audiobook change you mentioned, since A is already supported... but I can remove HL later, too, when you start using the where column...
Started filling it in already, thank you! I saw you'd changed things up, and I had already removed the h&l from the format column in preparation. ^_^
I've added a row between books, because I've forgot a book, but my points aren't showing up. Can someone take a look at my sheet? Thanks!
Mod
The problem with adding rows tends to be formulas need to be copied from existing rows... to do that, I generally highly 2 rows of formula/point cells, then drag the bottom right corner where the cursor changes, to copy the formulas down into new rows...
Alternately, in this case, you could have just highlighted an empty row further down and dragged it where you needed it, to use a row with existing formulas to insert the missing book... the sheet is pretty intelligent about modifying formulas when you drag things around... to drag a row you click the row number on the side, and when you click down, your cursor turns into a grabby hand...
Anyway, fixed!
Aha, I will do that next time. I knew I had the same problem last year too. Thanks for fixing it.
O Sorcerer Supreme of Spreadsheets, I have another humble request for thee...I think I have noticed a simple checkbox column in some spreadsheets--maybe on the far-left? I was wondering if I could have one added to mine? I'm having trouble keeping track of what books I have reviewed and what I haven't yet, and think this would be a nifty way to do so...
Thank you so much in advance!
Mod
That's doable (if one of the more annoying additions)... just need to adjust some formulas in the Participant Data tab, to accomodate alot of info being one column to the right of where it usually is, without that column, and merge some cells for Team Name/Player Name, etc...
(It's not annoying to do... it's annoying that it makes less of the rows in the Participant Data sheet copyable, when setting up new players in future years, since I generally need to copy a row with basic setup without the checkbox column, or I screw things up)
Mod
Thank you!!! I will try to be vigilant...
Mod
Or things I don't use often tend to be broken... I changed the terminology I use for Series Progress a year or 2 ago, from Started, Incomplete, Finished, to Started, Continued, Finished... but I never updated by Bar Graph, so it was missing every book that was in the middle of a series until last week :D
Oh Master of Spreadsheets...! I seek your assistance.Cell E166 is acting a little strange... usually when I input dates like 5/20/23, they auto change into May 20 etc. But this cell isn't. I'm not sure if it's just something weird about the date, or if there's something else wonky in the underlying formulas and figure I should ask...
Mod
Cell E166 is acting a little strange... usually when I input dates like 5/20/23, they auto change into May 20 etc. But this cell isn't. I'm no..."
Added rows tend to lose special formatting... fixed it...
Also, you had the read date set to May 2028, but I don't think that was the issue, just a coincidence...
Thank you! >.< I keep forgetting what year it is...
So I finally got caught up on my sheet but had to add rows to this month and last. I pulled down the points column to add up the points but they are not showing up top.
Um... I'm getting near the bottom of my spreadsheet... and I'm not sure what will happen if I click the "add another xxx rows" to the bottom... help?
Mod
Mod
Mod
That time of year already... things go by fast...Curious--do the "winners" of the competition ever get officially announced?
Mod
Curious--do the "winners" of the competition ever get officially announced?"
Not in a separate thread or anything, we'll have to do that for 2024. Most people just talk about it in the group threads.
Mod
Mod
I usually leave this thread open until the next year spreadsheet is ready, then the final post can be a link to the new thread/spreadsheet.
That won't happen until right around New Years...
Mod
LOL If that's cheating, then what is playing fair?And thank you for the information, Jenna!
Mod
Truthfully, if I really wanted to be competitive about it all, I could have squeezed in more reading, 24/7, at even faster speeds, and maybe reading a bunch of lopsided audiobooks (where the page counts are high, compared to audiobook length, for easy points)...
But I wasn't willing to damage reading enjoyment, risk burnout, and took breaks to watch TV/listen to music, as needed...
If you keep up, at your current speeds, you'll just lead all of next year... like when Soo participates and reads at her max speeds... I can compete for about a week, then the gap just continues to grow...
The main thing I have going for me is year-long consistency...
Congrats Tome Raiders! 🎉Better luck next time, Iain 😁😁
Timelord Iain wrote: "Putting up a valiant effort, and not managing more than 90% of my numbers ;)Truthfully, if I really wanted to be competitive about it all, I could have squeezed in more reading, 24/7, at even fas..."
Maybe they should just put the two of us on a team together, and everyone else on the other team. Then it wouldn't be cheating... right?
@Siobhan, lol!
Nirkatze wrote: "Maybe they should just put the two of us on a team together, and everyone else on the other team. Then it wouldn't be cheating... right?..."LOL
Mod
I mostly overcare about the solo race...
It's kind of lonely being the only insane reader on your team too... I wish I'd tried to read with the people on my team more...
I've be not-so-secretly conspiring every year to try to do a Team BR. Mei said that she'll join in the competition next year, so I'm determined to rope her into being my conspirator and henchgoblin to bring these wily plottings to fruition!From the Mr. Lovenstein comic:
Mod
I feel like Starter Villain would have been a good evil BR...We didn't read any of those Tome/Raider themed books last year... but there's always next year...
Last few days change request to spreadsheet...Is it possible to make the series/standalone recognize a specific word instead of a blank spot? I'd like standalone to count for anything I typed "none" into...
It's nice to be able to use the autofill function for tracking series, but that only works if there are no blank boxes in the column.
Thank you!
Mod
LOL I was thinking of going through and deleting the "none" after Dec 31st, but figured I'd ask here if there was a better fix first...
This topic has been frozen by the moderator. No new comments can be posted.
No, or, I certainly wouldn't feel guilty at least. If we all tried to hold ourselves to that standard the whole group would disband! 😅 We mere mortals appreciate having some reliable company in the threads.
Anyway, it's easy to see on the spreadsheet that most members have only done a couple BRs so far, or none at all. If anything, the nice thing about the competition is that it provides another way to interact even when you aren't participating in BRs.
It may be just a New Year's burnout. We've been active as a group recently what with the New Year's rush, and seeing a bunch of tempting BRs pass you by can be frustrating. I hope she can enjoy her reading more without the pressure to BR, but also hope that eventually she feels comfortable to come back. <3