Is it poor design on the part of Sheets that it breaks? For example, I know in Excel, if I put in conditional formatting on a range of cells, and then a column or row gets deleted, it automatically updates the conditional formatting to follow the range of cells. (I.e., if I assign conditional formatting to F1, delete the E column, meaning that the F column is now the new E column, it will automatically update my formatting to apply to E1, since the F column shifted over. Sorry if what Iâm trying to say is unclear. I hope that is understood. )
Iâll experiment with Sheets a little today and see if I can do something about that. I wouldnât really want to implement conditional formatting if itâs that easily breakable, but I suppose we can always just put some kind of warning/explanation on how to add that in if it breaks. But frankly, highlighting a cell isnât really difficult to begin with, so in that case, I might rather just put in a brief explanation on how to do that, rather than complicating things a bit more (not that conditional formatting is really that much more difficult, but highlighting cells wouldnât ever break).
I kinda hesitated for this reason also, but frankly, words seem to still get added without people being sure, and then they forget to discuss it later or mark it in some way, so the hope is that if they have it in their head in advance that they should mark it and there is an âofficialâ way to do so, maybe itâll cut down on that? Iâm not sure, but I figure itâs worth a shot, so thatâs why I didnât disagree strongly with the change, despite it being different to how things have been done up till now.
I might just be a bit slow on the uptake this morning, but Iâm not quite sure what this change is achieving.
Are you talking about if somebody has already duplicated the sheet, then decides afterwards that they want to change the color of the headers, then they donât have to go back to each individual tab and change that? Iâve no problems adding it in, I donât think, but I am not totally sure if I understand what problem this is solving.
Also, speaking from the âthings need to matchâ quirk I have, does changing the heading color in this way also make the stripes change colors to match the header? Iâve not experimented much with changing the colors around on the header/alternating stripes purely because the default blue I use is the one thatâs easiest on my eyes, personally. I have a difficult time discerning some text-background color combos, such as black on some shades of red (or the reverse), so I tried to pick one that I hope should be fairly neutral for most folks (while being aware that things such as different types of color-blindness make it impossible for a one-size-fits-all experience) and that I could still read without squinting.
It might be the complexity of the conditional formatting using a custom function. Iâd have to try the same in Excel to see whether it breaks in the same situation.
I agree. I figured see if the idea sounds usable (having highlighting automatic based on certain user actions, such as putting in a page number without an English translation, or putting âunsureâ somewhere in the note field), and if so, then see if the implementation works.
The alternative is spending the time and effort to get a working implementation, then the response is people saying, âNo, thatâs a bad idea.â
You might be surprisedâŚ
Note that Iâm not saying we shouldnât rely on users to change background colors. But the idea of having users add uncertain entries at all is to lower the barrier to entry, and manually setting colors adds a different to the barrier of entry. Itâs not the end of the world, but one of the main things I do at work is find ways to reduce the steps co-workers have to do, so thatâs my constant mindset!
I donât mind either way.
I didnât realize before that alternating colors come with a header color as well. That overrides what I was suggesting, as I was unaware of it.
Here's what I was typing before I realized this.
Letâs say you create a sheet with 10 chapters (for a ten chapter volume). Then you decide, since the book cover is primarily purple, you want your headers to be purple rather than blue from the template.
How many places to you need to change the color from blue to purple?
Without utilizing a theme color, itâs ten places.
I donât think itâs a bad idea, but I definitely think that unless we can get it working in a way that it doesnât break by simply deleting or adding columns, both of which are likely to happen in any given club, it shouldnât be implemented. Fewer steps is always better, and the less that users have to play around with is always great too, but only if it works fairly painlessly.
Between both of us playing around with it, I suspect that we will find a workable solution though!
I doubt you are the only one who does it. Iâve just personally not done so because:
A) The aforementioned color issues (also just learned that white on orange isnât a great color combo for me )
B) Iâve only made vocab sheets for 2 clubs, so havenât experimented much.
(and I realize itâs a wiki, but I donât want to change the first entry, because I donât know)
one of the (more challenging for me) responsibilities is to include a section on the homepage with links of âwhere to buyâ (preferably for paper copies, ebooks and audiobooks)
preferably all for the same version of the book (some people {needed to} do complicated comparisons between versionsâŚgaack!)âŚ
One thing Iâd like to see in this âhow toâ is a quick list of shopping resources for a book club âhostâ to check for availability (eg Bookwalker, Amazon? ). I also donât know whether those are country of browser specific. VPN stuff is too technical for me, but I was always able to buy from one of the several links that book club hosts had put in that home thread.
(these are times when copyright ownership being registered nation by nation is really annoying, although I think the DMCA digital millennium copyright act tried to address the global nature of the internet)
I think it gives a pretty good starting place for looking for versions of the book.
Where you looking for the information somewhere else (aka did you think youâd find the info in a specific place but it wasnât there?) or do you think this need to be expanded?
It might be worth adding a list of the most common vendors to a section outside of the template, either as part of its own FAQ dropdown (âWhere can books be purchased?â/âWhere can I direct others to purchase the book for the club?â or something to that effect), or as part of the âWhat are the responsibilities?â dropdown or somewhere else.
As it stands, if somebody is looking for that information, they have to go down to the templates to find it, which may not be the most intuitive thing in the world, since in theory one would only go to the templates once they are ready to copy and paste. Iâm currently on mobile WK at the moment, or I would add the section myself, but I can always do so later when I hop on my PC.
I agree, it would make a good FAQ. It is definitely a question that comes up a lot on the forums, and something I struggled with when I started reading. Perhaps still struggling with in the digital realm. (sidebarâcan you use a kindle to read Japanese ebooks? Probably need to buy one soon)
Yes, you can use a Kindle. Itâs primarily what I use for my ebook reading; it works quite well. You do need to be signed into your Amazon JP account, of course, and it doesnât allow you to mix and match with your English account, so that part is a touch annoying, but I just use my phone for my English ebooks anyhow, so itâs not been too much of a bother for me.
Alright Iâm sacrificing sleep but weâre almost there! Hereâs a list of what I altered.
Changes
Added lines denoting the start and end of the template so that itâs easier to find when copying and pasting from the raw text.
Added post title example
Changed âMain info and Quick Linksâ into a table format (I think this cuts down on some wordiness and makes it easy to quickly find the exact info you need)
Edited the text in both my original Home Template and this template under âVocabulary Sheetâ to match
Turned spoiler rules into a numbered list. Tweaked wording in rule 3 in my original Home Post template to improve clarity, and ensured the spoiler rules in both templates match.
Labeled the bullets after the spoiler policy âPosting Adviceâ
Took âinclude if applicableâ out of Live Readings section. Added an instruction at the top of the templates section to remove all sections that arenât applicable.
Changed some highlighting formatting to match Home Thread template, added some highlights to a few lines that need to be altered between the template and an actual post
Added section for proper nouns (I find these very helpful to have readily on hand when reading)
Added discussion questions as an optional section with examples
Turned âUseful Infoâ into âAdditional Elementsâ
Updated polling options
A few things that Iâd like to discussâ
I quite like the bullet points in âPosting Adviceâ. I do think though that the Discussion Guidelines section in general is a bit of a wall of text to have every single week though. Perhaps we hide the whole section under a details tag in the weekly posts, and put it unhidden in the home post?
Also, I know there was quite a bit of discussion about poll options earlier in this thread that I kind of ignored since I didnât have the time to post the template. But Iâve gone back and read it, and I think the key takeaways were:
Add an option for people reading along after the club has finished.
Make the poll options a bit more clear while avoiding being overly wordy.
I think the options I posted hit these goals but Iâm open for feedback.
Disclaimer: I have not fully proofread because Iâm exhausted. Iâll go back over it tomorrow or this weekend but Iâm sure you fine folks will probably beat me to it.
Yeah, it might not be a bad idea, to save some space. I worry that if it isnât visible right away, it wonât get read, but frankly, itâs long enough that the people who arenât likely to read it, wonât read it anyway due to the length, so thereâs probably no fixing that. I mostly included the bit about searching, for example, because it gives me something to copy and paste instead of having to type it when it comes up, not because I expect it to be adhered to without a little pushing.
I also think that youâve met the criterion, but frankly, I didnât have any issues with the way the polls were phrased before (I really didnât think they were all that ambiguous. ), so one of the folks who had concerns about the old polls would be better poised to give you feedback on that.
I especially like the âMain Infoâ table you added to the top of the post by the way. I wanted a better way to organize that information, but I was blanking on a way to do so at the time I wrote it (also pretty exhausted at that point, myself. ). ăç˛ăć§ďź
In my opinion, âavoiding being overly wordyâ is not exactly being met here or maybe your mileage just varies
Plus, I know I sound like a broken record, but I need to get to this again: I would be quite confused with your options because I wouldnât know what to tick if I was not reading ahead but still already finished this weekâs section
(In case you wonder how this can happen: either by updating the reading status throughout the week, or by reading the weekâs assignment during the week but before filling in the club poll)
Another thing is that you might want to point people to adjusting the weekly poll depending on whether itâs the first week or not, as the poll options may or may not make more or less sense depending on the week, and to avoid funny poll options like can be seen in the current VN reading clubâs first week poll.
Hereâs an example of what my polls usually look like:
As you can see, the two lower options change because they only make sense in the context of first and non-first week, respectively. Maybe it would be worthwhile noting this somewhere?
A few more changes after feedback and sleeping on it:
Ch ch ch ch ch ch chaaaanges!
Wrote a sentence synopsis of Discussion Guidelines and hid text walls behind details tags. Added the full Discussion Guidelines section to the Home Thread template without the details tags.
Changed âAdditional Elementsâ to âAdditional Sectionsâ for consistent wording
Removed WIP tags from Weekly Thread and Vocab Sheet templates (not to say we shouldnât keep working them, but I feel theyâre getting to be in pretty good shape!)
Removed highlighting from vocab sheet template (since itâs not really a copy/paste template)
Changed poll options to Nicoleâs, but kept the âIâm reading this book after the club has finishedâ
After giving it some thought Iâm happy with the poll options that existâtheyâre really not as ambiguous as I thought. They felt a little strangely worded because I had never considered that some people update the polls as they read (which is totally fine). Also to quote myself:
The purpose of this whole exercise isnât to change a system that for the most part works great, itâs just to make it easier for people who want to get involved.
I would like to consider adding this poll option though:
Iâve read this book before but Iâm here for discussion
I know a lot of engaged members are great about joining discussion and answering questions about books theyâve read before outside of the book club, and itâs fun to see whoâs following along. Itâs kind of the opposite of âIâm reading this book after the club has finishedâ.
I would definitely appreciate this. Perhaps the FAQ should be titled âWhere can club members purchase Japanese books?â and go underneath the Natively question.
Also in the vocab sheet, would you mind coloring the word âredâ red and âyellowâ yellow? Nitpicky but I kind of like how that looks.
Oftentimes, thereâs a note included underneath the poll (and this is my bad for not including it in the template because I spaced it) that says something along the lines of:
If youâve already read this book but are still going to join the discussion, please select âI have read this part.â
It keeps the poll a little cleaner and still involves those who join purely for discussion and answering questions.
Thanks for the reminder! Iâll get this done today, and I like that phrasing, so Iâll nick it.
Sure thing!
Edit:
Change List
Added the line I mentioned below the poll. If you would still rather a separate poll option, feel free to change that! I have zero investment in the way the polls are phrased as it stands
Bolded some text in the Vocabulary Template description
Updated the Vocabulary Template with the recommended font color changes
Added the âWhere can club members purchase Japanese books?â FAQ. I put in the most common vendors, but of course, if anybody else has others they wish to add, feel free. I divided it into physical/digital vendors and added some extra information regarding ordering from Amazon to try and prevent some issues that Iâve seen crop up with the links
(Sorry for the consecutive post, but I want this one to ping people. )
Do we think this is ready to be pinned again now that we have the templates all up in a functional order?
Oh, other than I do have one question remaining on the vocab sheet; does it let yâall make a copy of it to be saved to your own drives if itâs not currently available to be edited?
The last thing is the schedule. The template is good but I wanted to add some extra info. Hereâs (basically) what I originally wrote before we changed to the template format. Iâd like to include all the info here but I probably want to reword/reorganize it a bit when I get back to a computer on Monday:
Creating a Schedule
Making a schedule can be mildly time consuming, and the schedule does not need to be fully determined at the time of the home thread post. In fact, it is typical to get feedback from participants before finalizing a schedule.
Some things to keep in mind when making a schedule:
Natural breaks between weeks. Ideally these are chapter or at least large paragraph breaks. If breaks are not clean, be sure to annotate this on the schedule.
End phrases. If weeks donât stop at clean chapter breaks, add a column to the schedule with the last few words from that weekâs section.
Alternate versions. Include page numbers for alternate versions. Ask club members who own other versions to help with this.
Week-to-week consistency. Try not to have wild fluctuations in workload from week-to-week.
Club consistency. Try to make the pace consistent with previous club picks. Take expected difficulty into account when determining pages per week.
Ramp up time. For many bookclubs, it may be worthwhile to start out at a slower pace to give people the chance to adjust to a new style. This can help prevent some people from leaving the club after just a week or two of trying.
Special considerations (e.g. holiday breaks, shuffling or omitting short stories from a collection, etc.)
Remember to link each week in the schedule table when that weekâs thread gets posted!
I am sorry, but when reading this I am still very confused regarding the absence of a clear separation between the thing that means âleading a group of readers who want to read a given bookâ and the thing that means âmaintaining an overarching thing that will repeatedly produce the opportunity to do the aforementionedâ.
The OP starts by briefly touching upon both these things, but then neither clearly explains what those two things are, nor does it split the FAQ into those two groups. That would be the minimal requirement for me to get it pinned, because as it is right now, I donât want to point anybody to it because Iâm afraid that it will cause more confusion (and also fear!) than benefit.
I have to admit, the distinction seems quite clear to me, after reading the first FAQ⌠I hesitate to add any more arbitrarily defined terms (ala âreading clubâ vs âbook clubâ) because it just introduces more jargon for people to learn, which makes things more cloudy, imo. (While before I was mostly ambivalent, my position has shifted after I thought on it more.)
The former definition you list is just the basic definition for what a book club is, so it shouldnât require being defined specifically in the thread, imo. If one is in the Book Club section of a forum, one presumably knows what a book club is.
Maybe tweaking the wording a bit for the first FAQ would solve your concerns?
Something like:
âThese stand for Absolute Beginner Book Club, Beginner Book Club, Intermediate Book Club, and Advanced Book Club. Each is an organizational club for the purposes of grouping potential books to read by approximate difficulty, with those books being voted on by each group. After this voting is complete, a book club is formed for the selected book using templates similar to the ones provided below. When the reading for that book is about to end, members return to their respective organizational club to vote for the next book selection.â
Does that split the definition well enough for you? This should make it clear that the book club we are providing guidance for is for individual books, and the other clubs are strictly for organizational purposes.
I do agree that the bottom question, which touches on how to run the organizational threads, should probably just be given its own section of the FAQ, away from all the other questions that pertain specifically to running the actual book club threads because it could possibly lead to the two being incorrectly conflated.
)
Iâve not experimented much with changing the colors around on the header/alternating stripes purely because the default blue I use is the one thatâs easiest on my eyes, personally. I have a difficult time discerning some text-background color combos, such as black on some shades of red (or the reverse), so I tried to pick one that I hope should be fairly neutral for most folks (while being aware that things such as different types of color-blindness make it impossible for a one-size-fits-all experience) and that I could still read without squinting.
(Iâll let someone else add it though.)
I mostly included the bit about searching, for example, because it gives me something to copy and paste instead of having to type it when it comes up, not because I expect it to be adhered to without a little pushing. 
or maybe your mileage just varies 
