Fantasy Buddy Reads discussion
Archive [General]
>
2019 Team Competition Tracker/Google Sheet Central
Mod
Might be annoying when people go to change things like we've done, but it will protect the calculations (obviously, it's in the name :)
Mod
Hey virginie, could you change the pages and points daily/predicted on my sheet to the one you have? I like it much better your way!Don't know if i can just copy-paste that in, so I'd rather not try and possibly mess something up... Thank you :)
Timelord Iain (Eeyawn) wrote: "@Virginie: Maybe we should protect the first 15 rows of everyone's sheet... I looked into the rules, and we don't have to block access, we can just make a warning appear anytime people try to mess with it..."I wanted to do this when we were first setting up the spreadsheet but protecting the cells means you get a warning every-time you open the hidden rows. Apparently, showing/hiding grouped rows is considered a modification... :/
Angela Jr. wrote: "Hey virginie, could you change the pages and points daily/predicted on my sheet to the one you have? I like it much better your way!Don't know if i can just copy-paste that in, so I'd rather not t..."
Done! Copy-pasted with only a small modification of the formula :)
Mod
Oh... that's annoying...
Mod
I'm wondering why the spreadsheet says I have 0 buddy read points when I've done a buddy read?
Tammie wrote: "I'm wondering why the spreadsheet says I have 0 buddy read points when I've done a buddy read?"Fixed :)
Niki Hawkes wrote: "Could we please get a tracker for Chris M. For team blood eagles? Thank you!"Done :)
Hi, since my main goal for 2019 is trying to finish up a lot of my open series I wondered if there was a way for me to track it in my spreadsheet? If you have to get rid of any info that currently exists then I barely read graphic novels, 2 or 3 a year max.I know all the spreadsheet experts are busy so I'm not expecting anyone to rush on this since its not critical but if any of you are feeling bored in the next month or two...
Thanks 😊
Hailee wrote: "Hi, since my main goal for 2019 is trying to finish up a lot of my open series I wondered if there was a way for me to track it in my spreadsheet? If you have to get rid of any info that currently ..."Iain created a series tracker for himself on his scoresheet, so it's def possible. I'll take a look when I have some time, or maybe Iain'll be faster. Anyway, we can do it! :)
I used Iains formulas as well to create a series tracker, I can add my version to your sheet if you like it, or Iain/Virginie could do the original one. I just like pie charts. Pie and Pie Charts :)
Virginie wrote: "Iain created a series tracker for himself on his scoresheet, so it's def possible. I'll take a look when I have some time, or maybe Iain'll be faster. Anyway, we can do it! :)"Brilliant thanks Virginie!!
Sir Anni wrote: "I used Iains formulas as well to create a series tracker, I can add my version to your sheet if you like it, or Iain/Virginie could do the original one. I just like pie charts. Pie and Pie Charts :)"Haha pies in any form are always a winner!! I honesty don't mind which form the series tracker takes. Whoever has the time/inclination to do it can do with my spreadsheet whatever they want 😊
Mod
Mod
Mod
No problem... just trying to make the fix easier on you in the future...
Scott wrote: "Can you please add a tab for Sha to Hoc, thanks in advance."Done :)
Mod
Done :)"
TY!
A question for the spreadsheet Gods: why can't I get my cells 14D to 14K to summarize the cells above them? I really can't see why it shouldn't be able to :(Also I moved around on my sheet and that Monthly Progress graph broke. I took one look at the formula and said "nope!" Too advanced for a spreadsheet peasant like me. Would it be possible for someone to fix it? :D
Kathrine wrote: "A question for the spreadsheet Gods: why can't I get my cells 14D to 14K to summarize the cells above them? I really can't see why it shouldn't be able to :(Also I moved around on my sheet and th..."
I think the SUM formula has problems with the text that is also in your cells (BR:, Challenge:, Points: etc...). I edited it and everything should work now :)
Sir Anni wrote: "I think the SUM formula has problems with the text that is also in your cells (BR:, Challenge:, Points: etc...). I edited it and everything should work now :)"Thank you so much! Yeah that was my conclusion too but I wasn't sure because odds were pretty high it was something I did that made it not work xD But thanks for making it work! :D
Why isn't our Team listed as first Team with 100% Team Participation anymore? It's not something that describes an actual status, but a goal that has to be reached... It's not like it will be taken away everytime a new team member will be added throughout the year, so why now?I mean, I don't want to throw a tantrum it's a competition just for fun after all, but I don't think it makes sense that way...
Yah, what Anni said. I noticed that too.
Sir Anni wrote: "Why isn't our Team listed as first Team with 100% Team Participation anymore? It's not something that describes an actual status, but a goal that has to be reached... It's not like it will be taken..."Didn't Chris sign up before 2019, and was overlooked somehow? So technically, he was on Blood Eagles team from the beginning, and the team never really reached 100% participation..?
I agree with you otherwise.
Mod
Virginie wrote: "Sir Anni wrote: "Why isn't our Team listed as first Team with 100% Team Participation anymore? It's not something that describes an actual status, but a goal that has to be reached... It's not like..."No, he asked to join in the sign up thread after christmas and as the draft already happened...
@Iain - Can you look into my spreadsheet? i don't know what i did but now pi chart is not at it's place and I can't see column R. :(
Mod
You dragged column R down to like 1 pixel... the solution was to highlight column Q, hit Ctrl-C to copy, highlight columns Q thru S with shift-click, right click and Paste Special -> Column Widths Only to make column R big enough to manipulate, then adjust the column widths until the graph fits in it's spot again... i also went ahead and hid column Q... there's not much point in seeing it, since it's purely a helper column for other formulas...
Sir Anni wrote: "No, he asked to join in the sign up thread after christmas and as the draft already happened..."Well, that's still before the start of the competition, but since no one knew about it, it's the same as him joining 'late', I guess.
I thought he signed up earlier, and was overlooked during the draft announcement (since Blood Eagles had one/two less member than the rest). My bad.
I noticed earlier today that the series tracker I asked for has been added. I don't know who did it so thank you whoever it was!!!! 😂😂
Could someone take a look at my spreadsheet? What should I put in columms that don't apply to my book?
Slytherpuff wrote: "Could someone take a look at my spreadsheet? What should I put in columms that don't apply to my book?"Leave them blank.
Mod
Timelord Iain (Eeyawn) wrote: "Soo's already hit the 10k page milestone, in 12 days... that took me, Choko, and Julia 24-26 days, last year, I think... altho Julia's on her way to being faster than last year, as well, with 7500 ..."that's impressive!
Tome Raiders seems to be the team this year. others have 1-2 members who are reading a lot as of now but Tome Raiders has been a team effort so far..
I hit a milestone? Cool! Eh, I have time to read like I did last year but I know that's going to change over the year. So I'll get what I can get in now cause it'll be a slower rate later.
LitRPG (mostly audios) have become my go to reading filler between other books. I have a nice little list of them to try out. =) It's going pretty well for now. I try to vary the story styles to keep it interesting. Even with the audio penalty, most of those books are 300 pages & doable in a day-ish.
Mod
Yea... until I reminded Karishma she was supposed to be focusing on her accounting studies :(
Definite team effort, tho... I've liked how close the competition has been, so far... we'll see if that continues since House of Chains picked up an extra team member... or once all the Jaghuts start participating (they've had the lowest participation for awhile now, despite equal point gains to the rest of the teams)
Mod
That's what happened with Julia once she finished reading/re-reading the entire Harry Potter series, last week...
Timelord Iain (Eeyawn) wrote: "Yea... until I reminded Karishma she was supposed to be focusing on her accounting studies :(Definite team effort, tho... I've liked how close the competition has been, so far... we'll see if that continues since House of Chains picked up an extra team member... or once all the Jaghuts start participating (they've had the lowest participation for awhile now, despite equal point gains to the rest of the teams) r..."
Soo is keeping us afloat.. :D
but we have four people who hit 1K+ last year, so I guess we still have 10 months and hope for us to pick up speed. :D
See? I'm totally a reading ninja! =)LoL
Great for a nice strong push for the start. Haha
I think Julia will totally kick my butt later. =)
Timelord Iain (Eeyawn) wrote: "Em Lost In Books wrote: "Timelord Iain (Eeyawn) wrote: "Soo's already hit the 10k page milestone, in 12 days... that took me, Choko, and Julia 24-26 days, last year, I think... altho Julia's on her..."Eek! Not accounting. That was the old course - no more accounting thank you very much.
And I'm very grateful for the reminder Iain. And it's not like I could have continued with 400 pages per day for the whole year. Especially with my classes now going on properly.
Mod
I think comparing my scores & Yanique's is interesting... we're 3rd & 4th at the moment with very similar scores... both read about 5500 pages... mine are mostly audio BRs... hers are mostly non-audio non-BRs... that 25% non-audio bonus to page points and Challenge points evens out to the BR bonus... similar to how differently Soo & Julia were earning their similar points, early on... the competition is so much more flexible this year...
It's always going to take a lot of effort to overcome a non-audio BR-only reader, but for middle-ground participants, there should be a lot more variation this year, I think...
Mod
Maybe it's just the time of the day I do most of my updates, but I feel like I never have the delay issues that others do... can anyone else with extra SPARKLINE graphs comment?... the ones we added for book size or series progress / etc...
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...
FIXED... in the future, if you notice you did something wrong, hit the undo button... it's the circular back arrow in the top-left... it's also usually in the Edit menu, or you can hit Ctrl-Z...
The more advanced way I fixed this, was I clicked on the "Last edited XX minutes ago text and looked for an old version of your sheet... then I clicked the 3 dots for more actions, and made a copy of that older version to My Drive"... then I added 4 rows you were missing (blank) and copied the missing rows from my copy... the only reason I did it this way, is because this sheet has so many tabs, and just reverting to an old version might delete any books people have added in the past 3hrs...
NOTE: I figured this out after telling Karishma about reverting to old versions... DON'T use that feature on this sheet, guys... my bad...