Actually, it could be solved with some scripting. I’m not well versed in gscript, though, so I am no help
Not silly at all…and people shouldn’t really be playing with the formatting…also just realized trying to add a row the background fill is every other row so adding a row screws that up… ugh… resetting the background colors fixes it but then the page color/numbering is completely gone… someone has been modifying the spreadsheet look, maybe unintentionally … for now reset all the cells (ch 3) to white…but best I can do at the moment…someone will need to also go back and color code the pages again… I can maybe do it later but can’t at the moment…
EDIT…started to add color coding but ch3 is long!! haha and don’t know if I made a mess of things but up to page 40/35 is done (assuming I picked the right colors)
Well, of course we could write a script that updates the index numbers automatically after an edit.
What I was aiming at was the fact that this script cannot be able (with the Google API alone) to distinguish a “good” editing (where we want the index numbers to be updated) from a “bad” one (where we want the index numbers to be untouched so that we can use them to recover the correct order).
That’s because the edit operations don’t reveal the intent of the user; this can only be done through a tailored set of commands (like what is done in EventSourcing, for example).
I finished coloring the page numbers on ch.3. I don’t quite understand what you all are saying in the last few posts, but I wonder if I did something wrong when I copied the whole chapter 3 into the new spreadsheet. Sorry if I did!
Would it help if I added some conditional formatting to take care of the page coloring?
yeah but it would probably get inadvertantly messed up when someone inserts a row/etc…, unless it was scripted (whatever google uses for VB) on the back end and that is probably a lot of work
though more power to you if you are so willing
whoever messed it up, probably didn’t do it intentionally. (unless they did…then shame shame shame lol…I might be onry but I don’t think anyone in the clubs is intentionally malicious.) …not a big deal…I doubt copying the whole thing over did that, it seems like it might have been part of whoever added the filter/sort thing…in any case…not a big deal… thanks for finishing off the color coding…
Nice thing about conditional formatting is it can be applied to a column, so any row added, their cell within the column will have the conditional formatting.
oh i realize that but no matter what someone does…a smarter idiot will somehow always surface…
haha that’s all I meant
We start the mega chapter but there are actually slightly fewer pages to read this week than last.
I don’t think you did anything wrong - it’s just that the old spreadsheet has different formatting from the new thank you for all your work populating the new one!
Hi all, I’m considering jumping in on this (term has just finished so suddenly I have more time!). My grammar is at nearly-N4 level - I’m just finishing Genki II. If anyone reading is at a similar level, I’d be really grateful if you could tell me how manageable you’re finding it! Or if you are more advanced and know that this is way out of reach, that would be helpful too.
I am working through Bunpro at a slow pace. I’m half way through N4. I started with the head start schedule and I’m finding it manageable.
I think it would help if you also had a bit of reading experience with other books - I’ve also been doing a couple from the ABBC.
I’m around N4 level too, and it’s manageable! There are a lot of long sentences, and sometimes it can be confusing to follow along with the story – but the threads and vocab sheet help a lot There are chapter summaries that I find helpful to confirm my understanding. And reading the ebook version takes away some of the difficulty reading a book without furigana.
Thank you! I’ve been reading Doggy Detectives with the absolute beginner club, and it’s been going great, so I wanted to try something more difficult. I think I’ll give it a go!
Thank you! The vocab sheets are incredibly helpful aren’t they - I wouldn’t have imagined they would make such a difference. I’ve got an ebook, that’s a good point about the furigana.
Yes, that’s one of my other books. And I struggled with it at first. So if you’re ok with it, I’m sure you’ll be fine.
Main issue is volume as it’s more reading each day so I’d jump in soon!
That’s pretty much right where I am. I’m starting the final chapter of genki II this weekend. I’ve had only minor trouble with the grammar. It’s been pretty manageable overall. You may have some trouble with the vocabulary though. Having the extra time before starting to begin the Anki deck has been huge for my comprehension. But, if you can manage to catch up, you should be able to start preparing for future chapters.
Heads up to anyone who stumbled through audiobook.jp, I realised I accidentally signed up for a subscription rather than a one off purchase when I got charged again today
So if you couldn’t read everything on the site like me, you might want to check!
Thanks for the info! I was afraid this might happen, but I didn’t see anywhere to control such option, so I was on a “wait and see” with the one-month point coming up in a few days.
Upon looking at it today, I found that I can view subscriptions here (when logged in):
Sure enough, I was signed up for the ¥1,100/month plan. There was a button next to it that I just now clicked and unsubscribed. (Green button = not subscribed; white button = subscribed.)
Edit: You can view your credit card informaiton here:
If you cannot remove your card, it means you have an active subscription. That’s what had me confused back when I signed up, that I couldn’t remove my credit card information. Now that I canceled the subscription, I was able to remove my credit card information.
Oh gosh, I’ll feel terrible if loads of people end up getting charged extra for this.
I hope you’re able to find another book to make the second month worth it at least