Fantasy Buddy Reads discussion
Archive [General]
>
2019 Team Competition Tracker/Google Sheet Central
Virginie wrote: "If you want something else tracked instead, I can help you though :)Standalones, books above 600 pages (or under 250 = novellas), etc."
Ooooh that would be cool :) could you add novellas, tomes and standalones to my sheet? 😃
Angela Jr. wrote: "Virginie wrote: "If you want something else tracked instead, I can help you though :)Standalones, books above 600 pages (or under 250 = novellas), etc."
Ooooh that would be cool :) could you add ..."
Could you add standalones and novellas (below 200 pages ) for me ?
Timelord Iain (Eeyawn) wrote: "I'm thinking that tome statistic we came up with might be a great alternative for people that don't care for audiobooks...=" Tomes: "&COUNTIFS(O$15:O,1,E$15:E,">600") "
This idea would be perfect for me since I love to read large books but don't read audiobooks. Could someone please add this for me? Thanks :-)
Angela Jr, Kari, Hailee: Sure! Do you want this added on your monthly stats, or simply for all 2019 (in the first two line - take a look at my own scoresheet to get an idea)Will get started on this tomorrow :)
Virginie wrote: "Angela Jr, Kari, Hailee: Sure! Do you want this added on your monthly stats, or simply for all 2019 (in the first two line - take a look at my own scoresheet to get an idea)"For all 2019!
I'd like novellas and tomes for the whole year. And maybe you could do the series/standalone and audiobook/physical book things like you have them on your sheet? I hope that's not too complicated... Just leave it out if it's too much work.Thanks for doing all that for us 😊
Ok wow this is the first time I've seen your personal spreadsheet page Virginie and it is impressive!!I think it would be cool to track the tomes I read on a month by month basis (hopefully it'll motivate me to read even more of them) if its not to much work for you.
Thanks Virginie :-)
Hailee wrote: "Ok wow this is the first time I've seen your personal spreadsheet page Virginie and it is impressive!!I think it would be cool to track the tomes I read on a month by month basis (hopefully it'll..."
Thanks! I spent quite some time on my own scoresheet to test new formulas (Iain can attest to that :p) and I'm proud of the result :D
Modified your scoresheet, you now have a tomes tracker instead of a audiobook one! :)
@Kari: done! Standalones are (finished) books with the 'series' column empty, novellas are (finished) books with a page count between 1-200. The 'books' tracker includes novellas; tell me if you want that changed
@Angela Jr: Done! I took the liberty of removing Graphic Novels from your monthly stats since you don't seem to read any (according to this year's scoresheet) and used the space for the Standalone/Series books thingy :)
message 62:
by
Jenna, I'd be free if not for Temper & Edgewalker
(last edited Dec 13, 2018 04:41AM)
(new)
Mod
Oh, could you please add a tomes tracker for me as well, dearest empress?
@Jenna: By 'add one', do you mean a tome tracker for all 2019 (first two lines - not monthly stats)?
Mod
Ooooh...now that I look at your sheet again...maybe both? Your sheet is beautiful <3
Virginie I love your sheet - sorry for making more work for you, could you just copy your sheet to mine along with the standalones and novellas thing!Thanks love ❤️
message 67:
by
Jenna, I'd be free if not for Temper & Edgewalker
(last edited Dec 13, 2018 05:56AM)
(new)
Mod
There's also an Anon Badger just chilling on my sheet for some reason. Hello Anon Badger :)
Mod
Jenna wrote: "I just looked at my sheet and someone is changing things around! Exciting! Thanks so much Virginie <3 There's also an Anon Badger just chilling on my sheet for some reason. Hello Anon Badger :)"
Hehe, you witnessed the Excel Fairy working on your sheet!
I went and gave you the 'full' treatment, like for Angela Jr.
For the entire year, you have those stats:
- Novellas: page count between 1-250
- Books: page count between 251- 600
- Tomes: page count between 601 - infinity (:p)
- All books: all of the above + books entered through the form;
And you have the two little graph-bar thingy
- Series books / Standalones; a book is counted as standalone if you leave column C empty
- Audiobooks / 'Written' books
Mod
There's also an Anon Badger just chilling on my sheet for some reason. Hello An..."
Thank you so much Virginie!!
Mod
Mod
I know :) just wondered why someone other than me or Virginie was hanging out on my page :)
If at all possible I would love to have the stats for standalone vs series books rather than the graphic novels. If possible, could you do both monthly and yearly. Hope I'm not asking for too much.
Jenna wrote: "Timelord Iain (Eeyawn) wrote: "It just picks a random animal for people that aren't logged into a google account on their computer/device..."I know :) just wondered why someone other than me or V..."
Pretty sure it just shows whoever else is looking at the tracker, not specifically your tab of it. So, they might be looking at their own sheet.
Is the "Primer" tab just me or everyone?It shows books read but my sheet is empty?
Mod
I know :) just wondered why someone othe..."
I mean not in the corner of the screen, but when a cell is highlighted when someone clicks on it :)
Mod
Further along, past the totals sheets, you can find your personal sheet...
Virginie wrote: "Jenna wrote: "I just looked at my sheet and someone is changing things around! Exciting! Thanks so much Virginie <3 There's also an Anon Badger just chilling on my sheet for some reason. Hello An..."
Can I get this? If you're too busy don't worry about it and I can play with it myself tonight.
Mod
I know :) just wondered why someone othe..."
If at the top, yea it's sheetwide... but if one of your cells is highlighted, you can see a name if you hover over it, and those are on your sheet...
Ohhh! I learned something new! Thanks :)
Mod
@Kari, Slytherpuff, Diana: Sure, I'll make the changes requested. Will work on it tomorrow though; had my fill of Excel tinkering for the day ;)
Mod
Yea... I've been pretty lazy, myself... throw out ideas that people like, and *POOF*
Virginie wrote: "@Kari, Slytherpuff, Diana: Sure, I'll make the changes requested. Will work on it tomorrow though; had my fill of Excel tinkering for the day ;)"No worries. I'll just update it myself when I get on my laptop tonight. I'm just lazy :-)
Virginie wrote: "Hailee wrote: "Ok wow this is the first time I've seen your personal spreadsheet page Virginie and it is impressive!!I think it would be cool to track the tomes I read on a month by month basis
Thanks! I spent quite some time on my own scoresheet to test new formulas (Iain can attest to that :p) and I'm proud of the result :D
Modified your scoresheet, you now have a tomes tracker instead of a audiobook one! :)
That's brilliant. Thanks Virginie!
Virginie wrote: "@Angela Jr: Done! I took the liberty of removing Graphic Novels from your monthly stats since you don't seem to read any (according to this year's scoresheet) and used the space for the Standalone/..."Thank you so much ❤️
And you're right, I've only read 3 graphic novels my whole life 😂
Mod
I've read a couple dozen, if you count the webcomics that are successful enough to be printed in volumes, usually years later...
But ACTUAL graphic novels, it's basically just White Sands Volume 1... and it wasn't really worth continuing... just cause Sanderson's old novel draft inspired the story, doesn't mean it's worth it, sadly...
This year was the first time I ever read a graphic novel, I read the first two volumes of Saga. I might read a couple more volumes in 2019 but graphic novels aren't really my thing. They go by so quick I can't feel as invested in the characters as I do with a novel.
So I took a look at your sheet, Virginie, and man do I like it. I love your series vs standalones, audio vs print, and page points vs bonus points bar. I looked at adding it to mine but my laptop screen is too small to see the frozen sections correctly. If you could maybe update mine with that info (and also the tomes and novellas columns) I'll be forever in your debt.
Mod
Hello Gods and Goddess of excel!I would like to have that series vs standalone function on my sheet too. it looks super cool.
Also if not too much of a hassle can I have a publication year column and a corresponding graph to show it. something like GR shows us in publication stats but for this year only?
Bea wrote: "Oh, could you please add a tomes tracker for me as well, dearest empress?"Oops, almost missed this!
I replaced your monthly GN stat by Tomes (and you've got the stat for all 2019 right under your monthly stat, the line 'Total')
Slytherpuff wrote: "If at all possible I would love to have the stats for standalone vs series books rather than the graphic novels. If possible, could you do both monthly and yearly. Hope I'm not asking for too much."Done! In your monthly stats, you now have 'Standalones' - simply leave the column C (series) empty to have a book added to that; your yearly stat is right under (the line 'Total')
Karishma wrote: "Virginie I love your sheet - sorry for making more work for you, could you just copy your sheet to mine along with the standalones and novellas thing!Thanks love ❤️"
Mmmh. Directly copying my sheet is probably a bad idea; I heavily modified some formulas to suit my reading habits (and am too lazy to either explain them or reverse the processus to get a 'normal' scoresheet).
Instead, take a look at Angela Jr's scoresheet. I think that one got pretty much everything you asked. I can work on getting you a 'coloring' similar to my sheet after, if you want :D
Diana Stormblessed wrote: "So I took a look at your sheet, Virginie, and man do I like it. I love your series vs standalones, audio vs print, and page points vs bonus points bar. I looked at adding it to mine but my laptop s..."So... What? I'll own your soul? That's a better bargain than the 6 min that guy from Succubus Blues got, but still...
(kidding)
Will work on it soon(ish) :D
Manju wrote: "Hello Gods and Goddess of excel!I would like to have that series vs standalone function on my sheet too. it looks super cool.
Also if not too much of a hassle can I have a publication year colum..."
Series vs Standalones: Yup, will add it! Though to do so, I have to remove the monthly GN tracker to make some space; I'm assuming you're OK with that. Tell me if you're not, and I'll work something out :)
Publication year: Yeah, that's easy to make :)
Timelord Iain (Eeyawn) wrote: "Virginie was just an idea machine... the day AFTER she duplicated the template 50x and released the spreadsheet to the group..."Says the guy that gave ideas to everyone! :p
Virginie wrote: "Manju wrote: "Hello Gods and Goddess of excel!I would like to have that series vs standalone function on my sheet too. it looks super cool.
Also if not too much of a hassle can I have a publicat..."
I don't have any plans to read GN right now. :)
Thank you for adding the statistic
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...
I'm thinking that tome statistic we came up with might be a great alternative for people that don't care for audiobooks...
=" Tomes: "&COUNTIFS(O$15:O,1,E$15:E,">600")