Fantasy Buddy Reads discussion

Timelord Iain wrote: "Sha wrote: "Would a monthly data sheet from Jan-Dec with Genre tracking be possible?

//sorry I'm late I missed this thread

Non-American for the dates, please. I don't want to mess anything up by ..."

:D Yeah I saw that so I thought it might be possible without too much trouble.

I just really love the spreadsheet the spreadsheet is the best i felt a little bereft without it in Nov/Dec.

Sha wrote: "Timelord Iain wrote: "Sha wrote: "Would a monthly data sheet from Jan-Dec with Genre tracking be possible?

//sorry I'm late I missed this thread

Non-American for the dates, please. I don't want t..."

I LIVE in the spreadsheet... the spreadsheet is more up-to-date than my GR shelves, always...

Virginie wrote: "Maria wrote: "Actually, I'd like the dates that way too, I'm not used to the American way of writing dates. Thanks!"

Done! :)"

Thank you! 😊

You guys think YOU'RE asking alot, and you aren't...

I'm IN the sheet with Virginie, coming up with new bells and whistles for my sheet, AS Virginie is trying to streamline it, to remove half the duct tape solutions I came up with last year...

Turning my BR Yes/No column into a column that tracks BR start dates and uses that to trigger bonus points...

Using my Challenge column to track Series progress (Started, Incomplete, Up-To-Date/Finished/Abandoned)

Ways to keep the 10 month competition points separate from 12 month points, without needing extra hidden rows...

etc, etc, etc...

:D (Don't worry, I say Thank You often)

We're in the home stretch now...

TODO List is down to:

1) Creating sheets for people that haven't responded with their preference yet (giving them a couple more hours)

2) Finishing the Primer with updated How-To information

3) Filling in special requests

4) Solve any math problems I invented to keep Virginie busy (I want the predicted points/pages formula to work for people that use the sheet for the 2 months after the competition ends)

FBR Spreadsheet Empire:

CEO / Lead Developer = Empress Virginie
Communications Director = Timelord Iain

Hahahaha!

The way I see it, the time you're spending keeping me company/inventing new problems is time you're not reading.

Then you might still have current books when 2020 hits. Which means less point for your team.

:p

Virginie wrote: "Hahahaha!

The way I see it, the time you're spending keeping me company/inventing new problems is time you're not reading.

Then you might still have current books when 2020 hits. Which means less..."

https://www.youtube.com/watch?v=oHg5S...

Could I have a Monthly Data Sheet again like I had last year? I loved being able to track my reading throughout the months :D I guess my sheet from last year is perfectly reusable for me this year xD

Also, thank you, spreadsheet Gods! This is such a cool feature of the comp :D

I signed up yesterday and haven't been assigned to a team yet, but I'd like the monthly version please.

For 2020, we've renamed the old Best Buddy/Challenger rankings to Biggest Buddy/Challenger (since they tracked by total points) and added a new Best Buddy/Challenger stat, that tracks a percent...

This percent is how close you came to earning max bonus points for the amount of books you read... basically, if every book you read is a Buddy Read and qualifies for a challenge, you're 100%... we doubt anyone will be at 100% year-round, but there will probably be some in the 75-95% range, especially challenges... people with less reading time will definitely be higher on the % list, since I can only do so many BRs in a month ;)

Great job guys.

Angela Jr. wrote: "I signed up yesterday and haven't been assigned to a team yet, but I'd like the monthly version please."

Noted! :)

Virginie wrote: ", you're right, all the sheets have the little calendar thingy when you double-click. You can thank Iain for it, he's the one that found out about this (I think?).

The templates are set up so that the date..."

That's perfect, thank you both!!

When can we see the sheets?

Huuuum... When I finish what I'm supposed to do instead of chatting with Iain xD

Thanks for putting so much work into the sheet Iain and Virginie. Can I get the monthly sheet please.

(just kidding, I wanted to wait a bit more to see if more people were going to post their choice of template)

It'll be up soon-ish.

EDIT: Well, only half-kidding actually. I DID spend a couple hours chatting instead of working on the spreadsheet 😂

I want to change my preference from monthly to something that i had this year with chart and graph. 😅

Ooh Virginie can you please change mine and Charlie's to the day/month/year date format too?

Can I get this too please Virginie? Another Brit here lol.

Em Lost In Books wrote: "I want to change my preference from monthly to something that i had this year with chart and graph. 😅"

Done!
I was surprised you requested the Monthly since your 2019 scoresheet was so advanced and pretty :)

I'm fine with what I had last year. Thanks!

Alright my loyal subjects! Your wait is over! I present to you the 2020 Spreadsheet Empire:
*sweeping gesture*

https://docs.google.com/spreadsheets/...

Everything probably works!

Please take a look at the primer first; it details the different parts of your scoresheet:
https://docs.google.com/spreadsheets/...

The Main Page has two new features this year:

- on the right (before my wonderful self-portrait), your have two tables. The first one concerns BRs, the second challenges. It shows who are the Top 3 Best Buddy / Challenger (who has the highest percentage of books being BRs/part of a challenge) or the Top 3 Biggest Buddy / Challenger (who has the most BR / challenge points). You can choose which one to display by clicking on the little arrow, and choose between Points and Percentage.



(Please don't mind the wobbly circles, I'm kinda drunk xD)

- the Main Page will recolor depending on which team is currently on top. If you want to paint it crimson for the Bloody Tome Raiders or noble blue for the House of Jaghuts, you only have one choice: read more! :D

I gave my sheet a test drive and seems to work perfect. Thanks for the hard work!

The spreadsheet looks incredible! Thank you!

Virginie wrote: "- the Main Page will recolor depending on which team is currently on top. If you want to paint it crimson for the Bloody Tome Raiders or noble blue for the House of Jaghuts, you only have one choice: read more! :D"

This is by far my favourite feature!

Virginie wrote: "Alright my loyal subjects! Your wait is over! I present to you the 2020 Spreadsheet Empire:
*sweeping gesture*

https://docs.google.com/spreadsheets/......"

Yewwah I'm #1 for now 🎉

Sir Anni wrote: "Virginie wrote: "Alright my loyal subjects! Your wait is over! I present to you the 2020 Spreadsheet Empire:
*sweeping gesture*

https://docs.google.com/spreadsheets/......"

Haha me too. We'll all have to enjoy it while we can. By the end of the 1st Iain will have a couple of hundred point on the spreadsheet ;-)

WOW!! Great job! Works perfectly for me.

Brian wrote: "WOW!! Great job! Works perfectly for me."

While it's definitly feature-heavy at this point, it's been a 3 year labor of love... the 2018 version started out so modestly, and each year we've just added cool things to it... then at the start of the next competition we've taken those cobbled together ideas and refined them...

Lundos created the first version of advanced stats... then we added the secondary stats tab... then the tertiary one for Page Rankings and Milestones... then Virginie made the Participant Data and Ranking tabs in 2019 to cut down on repetitive formulas... then all the graphs and monthly stat section last year... and extra graphs/columns... it goes on and on...

For people seeing it for the first time (I know you've participated before), it seems like we just did this all at once in 3 day :D

Iain, can you edit the first post in the thread with the official link?

Narilka wrote: "Iain, can you edit the first post in the thread with the official link?"

Done... edited at the topline, then the original post below...

Timelord Iain wrote: "Narilka wrote: "Iain, can you edit the first post in the thread with the official link?"

Done... edited at the topline, then the original post below..."

Sweet! Thanks :)

Virginie wrote: "Alright my loyal subjects! Your wait is over! I present to you the 2020 Spreadsheet Empire:
*sweeping gesture*

https://docs.google.com/spreadsheets/......"

SQUEE

Thank you so much. :) This is even better than I expected, and I was expecting loads.

It's beautiful! Thank you for all the hard work Nerd Squad :)

Hey guys, happy new year :D
I forgot to ask for the daily/predicted points and pages feature! Unfortunately i have no idea how to do that.
Thanks in advance for adding it :)
And of course the spreadsheet looks awesome as always!

Lol i love how I'm first in every category by default just cause I'm the first in the alphabet 😂😂😂

Hi guys, can I get mine changed to the fancy one please? Thanks!

Elizabeth wrote: "Hi guys, can I get mine changed to the fancy one please? Thanks!"

Done!

My sheet is almost sorted for the year...

You should imagine me and Virginie staring at this formula, trying to get the error to go away:

=round(sumif($R$16:R,A68,H$16:H)/(MIN(DAYS(TODAY(),B68)+1,DAYS(B119,B68))),0)&" pgs/day"

The parentheses at the end were in the wrong place/missing...

This formula removes alot of the hardcoding I was using to track pages/day per month... B119, B68, A68, are stored locations for months and 1st day of the month...

This is a more complicated than usual formula to automate leap years, for future-proofing...

Congrats but I'm not even going to try and understand it. You are literally speaking another language with that formula. Even the simple formulas go straight over my head

Hailee wrote: "Congrats but I'm not even going to try and understand it. You are literally speaking another language with that formula. Even the simple formulas go straight over my head"

(sumif($R$16:R,A68,H$16:H)
(If column R matches, cell A68, sum column H)

column R is the helper column that tracks the month of Date Read
A68 holds current month info for my secondary monthly stats
column H is page counts

So count all the pages read in a month

(MIN(DAYS(TODAY(),B68)+1,DAYS(B119,B68)))

Return the smallest result of Days between today and the first of this month, and the first of next month and the first of this month

This is so you can find out how many pages/day you read in February and be accurate on February 3rd and April 4th... it stops adding days at 28 (29 in a leap year)...

To facilitate this, we use B68 (Feb 1, 2020) and B119 (Mar 1, 2020) and TODAY()...

Last step, we round it to 0 decimals, and add the text " pgs/day"

All done... 6 formulas rolled together...

We did this in a couple other places, so I can just duplicate my sheet in 2021 with basically 0 changes, outside of changing one cell from 2020 to 2021... this isn't an issue for most people with less intensive stats on their page...

Check your syllabus, my office hours are....... :D

NOTE: I actually noticed an error while writing all this... one of the B68s was incorrectly an A68, and we didn't notice because it didn't break the formula the same way the parentheses did...

Haha I'll try my best to keep on top of all my homework, but my GCSE IT teacher tried his best as well during the Excel lessons. It ended with me sticking my hand up at the beginning of most lessons and him sitting with me doing most of the work himself. But even so I still only managed a C grade. Maybe he was just a rubbish teacher 😉

Great job! I will have to peraonalize the colors and set it up the way I want when I get to my laptop tonight.

😎👌👍

Looks amazing! Thank you!

Thank you, guys, so much for the hard work! It looks amazing!

Can you check something in my sheet? On the previous one I could see how many books I've read in each month. Now, there's only 4 months on the sheet. Is it possible to add the other months? Thanks!

I would love a monthly data sheet if possible please!

Heyo! Sorry for the late ask, but would it be possible to get my sheet changed to the new monthly version? If not not worries, ^~^

I’ve only just joined, so sorry for being late. Could I have the monthly sheet please? Very grateful for your hard work on this amazing sheet.