Fantasy Buddy Reads discussion
Archive [General]
>
2018 Team Competition Tracker/Google Sheet Central
message 151:
by
Sha
(new)
Jan 13, 2018 08:49PM
Is there a formula for rounding up an average?
reply
|
flag
Mod
Mod
Iain wrote: "Sorry... I made the changes to my sheet cause I liked them and to ease readability as I'll be reading so many books... and then tried to explain how to copy them if anybody was so inclined... the o..."Thanks Iain - I certainlly didn't mind. The min max formula with the stars thing was a function I certainly dind't know, so I thought it was pretty cool. (I'm using it).
Rob wrote: "Hacen wrote: "Can mine go back to normal? I don't need all the extra stuff."No problem.
Dammit Iain, stop being all creative and stuff :)
I put everyone back to the original (except Iain and I..."
I would love mine to be all pretty like that too!!! Can you make it so?
Rob wrote: "Choko - done!"It is beautiful!!! Thank you so much, you are amazing!!!!
Iain wrote: "Most of the people I think are behind on tallies are in House of Chains... I see you meant Laura, since she's in most of the Buddy Reads I do... and doesn't Saar have some points?... I'm not sure a..."@Iain: no points yet, but there will be soon enough. January is a bad reading month for me, but I'm catching up. Still need to finish 1 book from 2017.
Mod
Mod
Mod
Choko wrote: "Rob wrote: "Choko - done!"It is beautiful!!! Thank you so much, you are amazing!!!!"
Wow, this spreadsheet is like Bentley among the spreadsheets. Your warren is strong Rob.
Iain wrote: "@Saar: Not trying to make you feel bad... just thought I'd seen you in some Buddy Reads... I've been talking everywhere lately, so it blurs..."@Iain: no problem at all :) It's not always easy to catch up.
Iain wrote: "Sorry... I made the changes to my sheet cause I liked them and to ease readability as I'll be reading so many books... and then tried to explain how to copy them if anybody was so inclined... the o..."I took a look at your sheet and I think the details and the features you have included are very cool. Unfortunately I have too little time to even think of implementing something like that.
Like your additions Iain and I think I gone steal some of them :) And thank you again for all the efford Rob, even if you have undone it by now ;)Edit: Uhm... someone locked my sheet? And it wasn't me :D
Edit2: After a short moment of panic I realized it is locked for me! I normally don't use my googleaccount (with the the much to long emailadress :D) on my computer. But as I knew now, I am fine :)
Mod
@Iain: your tracker looks super awesome. :D
Hi Rob or Iain! Could I possibly have Iain's changes too? :)Iain, what's the last column for? Buddy read page counts. Sorry if you've already explained. Like Margret, I found most of this thread to be foreign xD
Mod
Iain wrote: "That was just me precounting planned reads... its pretty redundant now that we can safely fill in the page count on unread books, and I've stopped trying to keep my list 100% chronological"Ahh right I'm with you :)
Mod
I worked a lot with Google Sheets in my previous job as the multinational company I used to work with used a Google Enterprise account.I just thought to give a heads up: documents with a lot of tabs as ours have now, have a tendency to lag and freeze and sometimes data is lost. Especially with so many people making changes at once. The more formulas we have, the worse will get.
This is only the beginning of the year and we plan to add even more people to the challenge, so more tabs will be needed.
We should keep this document basic and standard for all. The tabs at the basic format and the scorecard and the team sheet offers more than enough information necessary for the challenge.
For the people that want bells and whistles, you can make a copy of your tab for personal use and add all the bell and whistles you want there, as this will not increase latency on the main file.
You just need to go to your tab, click on FILE and MAKE A COPY. We can even create a new thread for Excel/Sheets formulas questions that are not related to this challenge, if you want. Like that we can keep this thread for the Challenge Sheet requests only.
We are trying to make this as user friendly as possible, but this thread is kind of getting scary for people that don't work with spreadsheets often.
Just my opinion.
Thank you for setting up this sheet, Rob. It is really helpful. :)
Mod
I know 21 people are reading Gardens of the Moon, now, tho... and 7 read Blood Song...
(view spoiler)
It had it's limitations... I had to add wildcards, since some people include series name in parentheses... so books like Legend by Gemmell would throw up a ton of false positives... figuring out how to make another formula that told you which people read the book would probably been even laggier... or referencing ratings...
I was basically trying to make a lot of Rob's pipe dream ideas a reality... since I caught that spreadsheet addiction Rob was talking about yesterday... but really, it's time better spent reading... so I'm going to stop for now...
Mod
Iain, no worries. I know how addictive spreadsheets can be. I get caught up on this kind of situation often enough. :)
Mod
Iain just out of curiosity I'd love to see the query you came up with. could you send it to my Gmail. :)miche yes I noticed the performance declining the last day or so was going to call a halt on sheet mods. maybe I'll save a copy at the end of the year and apply some data then for everyone to see.
Rob wrote: "Imiche yes I noticed the performance declining the last day or so was going to call a halt on sheet mods. maybe I'll save a copy at the end of the year and apply some data then for everyone to see. "Great idea, Rob!
Miche wrote: "Rob wrote: "Imiche yes I noticed the performance declining the last day or so was going to call a halt on sheet mods. maybe I'll save a copy at the end of the year and apply some data then for ever..."Actually, there's even a part of me that wants to remove the scoreboard pages and do a big reveal at the end of the year. I don't want to discourage participation if a particular team falls to far behind or another gets too far ahead
The mods need the info for aligning new participants and making sure the teams are balanced though .The statistics part of it is needed.
We were planning to keep the scoreboard at Goodreads, so this part was always planned to be open knowledge.
My team is the one behind and so far we aren't discouraged. We are encouraging each other and having fun in the process. :)
Miche wrote: "The mods need the info for aligning new participants and making sure the teams are balanced though .The statistics part of it is needed.
We were planning to keep the scoreboard at Goodreads, so..."
Awesome sauce :)
Mod
Mod
My vote on the complexity of the spreadsheet is bouncing off of what Miche said, and keeping it basic for functionality. If someone wants to make it complicated, they can just use an independent spreadsheet for their own amusement and update both.
Niki Hawkes wrote: "What Miche said. Team Tome Raiders is totally going to Tortoise your Hares at some point down the road, but we need to know what we're aiming for lol. Info for new adds is also prudent. My vote o..."
Aye, aye cap'n
Mod
You put your rating in the # column, and the formula in the RATING column turns it into stars... looking at Rob's sheet, maybe I should have put a rounding function into the stars column, since at the moment it rounds all decimals down, it seems...
Mod
@Rob: A few of the sheet links need updated on the scorecard page since we replaced some sheets with new urls: Siobhan, Choko, yours, and maybe a few others, I dunno...
Also, the contributor column in that table that subtracts a member is inaccurate, since you just hand typed names in, I guess... since you created the Team Scoreboard, I think you can use 'Team Scoreboard'!A3/C3/E3/G3 to get the accurate top contributor for each team, instead...
Iain wrote: "@Siobhan: I bit the bullet and copied your sheet into the "pretty one" since nobody else did...@Rob: A few of the sheet links need updated on the scorecard page since we replaced some sheets with..."
Yep - the team sums now run from the team scoreboard page. Easier that way.
Iain wrote: "@Siobhan: I bit the bullet and copied your sheet into the "pretty one" since nobody else did...@Rob: A few of the sheet links need updated on the scorecard page since we replaced some sheets with..."
Thanks very much Iain :) :) I like the idea of seeing my ratings there too. I made myself a little challenge column but that was as much as I could achieve on my phone! XD
Mod
I have more rated books on my spreadsheet at the moment than I do on here for 2018...
I've actually changed my sheet again since people copied it... adopted a lot of the header color scheme from Lundos, and moved my links into a column... I might delete my pre-count column eventually, like I did from other people's sheets since they weren't using it, to keep the sheet clean...
You even put my ratings in for me, bless ya! Thanks so much :)I might pop some links and mess with heading colours when I'm on a computer.
Mod
Iain wrote: "That and renamed the headers for people... I've seen some people misunderstanding how those columns work, so I put some accurate examples in... you put the number in the right column and the stars ..."Yeah I figured from your sheet xD
Mod
Niki Hawkes wrote: "You all are making them so complex and interesting, I'm impressed. While I'm over here like: "... I made mine pink." ^_^"Pink is awesome though! XD I want colourful now! Haha
Mod
Damn slumps been messing with my progress hopefully Legend will get me up and going and then I'll read gardens of the moon sometime later and then dragon reborn and then I will catch up because I'm seriously behind hahaha
Mod
I also made mine colorful! I added my challenges and star rating tracker as well. Simpler than Iain's but still fun and custom for me.
Ahdam wrote: "Damn slumps been messing with my progress hopefully Legend will get me up and going and then I'll read gardens of the moon sometime later and then dragon reborn and then I will catch up because I'm..."Long year Ahdam. We will all have our slumps. Luckily your on the best team. 😁
Fantasy Buddy Reads
Books mentioned in this topic
Gardens of the Moon (other topics)Tower Lord (other topics)
White Sand, Volume 2 (other topics)
Dead Until Dark (other topics)
The Warrior's Apprentice (other topics)
More...
