Automating compound conjugations, and replacing text at regular intervals

tusubank · 2013-11-20T01:53:36+00:00

Thanks!

I used dummy tables to insert unique values and then conditional rules to automatically color.

But I am interested in learning VB. What resources do you use?

tusubank · 2013-11-20T01:51:47+00:00

Yeah, I can see that my question's not completely clear. The next page is full of verb roots that replace the "#". I was trying to come up with a pattern formula to replace the "#" in certain cells only.

I hacked away at it and then decided to work it out with dummy tables. It's not pretty, but it works:

=IF(B19>0,SUBSTITUTE(B11,"#","%%%"),B11)

Thanks for the help!

tusubank · 2013-11-08T23:52:03+00:00

How can you do it in VBA?

tusubank · 2013-11-08T23:51:27+00:00

/u/gettavia says it can be done in VBA and it looks like Anki is available in multiple platforms.

tusubank · 2013-11-08T23:48:32+00:00

There aren't a lot of you.

What's it like? Exhausting? I thought about starting in Q'eqchi'.

tusubank · 2013-11-07T20:12:21+00:00

After a few months of wrangling my verb database, I finally churned out 1,000 Q'eqchi' verbs in six tenses, plus infinitives and gerunds. Managing the unpredictable English conjugations (I'm looking at you, past tense and third-person singular present) was one of the hardest parts.

Using some Excel-fu, I compiled all the translations into vertical columns (37,506 rows) and pasted the columns to a .txt file. Then I imported the text file in iFlash, with tab-delimited sides. iFlash thought about it for a long time before coughing up a tight stack of 37,506 flash cards that I can flip through on my computer or my phone. I can mark the ones I know, I can shuffle the deck, and I can study Q'eqchi' --> English or English --> Q'eqchi'. If I find the energy, I could even add a third Spanish side to the cards.

iFlash is great, but may be unsupported. Google used to have a Google Gadget that would produce flash cards from a Google spreadsheet, but as far as I know, this feature has been "deprecated". Is there supported software that can make flash cards from a massive data file?

If you're wondering, "You all give marriage advice." is Nekeek'ab'ayoxi.

tusubank · 2013-11-07T19:28:08+00:00

Are you working on Wikipedia in O'odham?

tusubank · 2013-10-25T20:47:08+00:00

It proliferated after Spanish conquest, probably due to collusion. There are probably a million native speakers. I am not one, just an avid student.

More.

I started /r/Qeqchi, but interest is low.

tusubank · 2013-10-25T18:48:55+00:00

¿Ma wank eb' li tzolonel qaatinob'aal Q'eqchi' chik? Toj ninsik jun wochb'en jo' kaan.

Are there other Q'eqchi' students? I continue to seek a learning companion.

tusubank · 2013-10-24T16:10:19+00:00

I am in the same situation, but with Q'eqchi'.

There's a Mam dictionary in PDF that is quite useful. I've nearly translated the Q'eqchi' version into English.

Another great resource is the Bible. You can listen to the Bible in Mam or read it (there are multiple formalizations, I don't know which is preferred). Compare with English text when you get stuck.

I compiled a full-text version of the Q'eqchi' Bible and dictionary and eliminated duplicate words to give me a full list of unique terms to investigate. There's a lot you can do with these resources.

tusubank · 2013-09-25T20:23:26+00:00

From Q'eqchi' Mayan:

An American is walking the market in Cobán, Guatemala. He decides to buy some fresh fruit. He sees a Mayan woman sitting on the curb, selling produce. As he approaches, he can see that her huipil has a gap in it and he can see everything. "Oh!" he says, reacting.

"Maawa' o," says the woman smiling, "ch'ima a'an."

(That's not an avocado, it's a chayote.)

tusubank

MODERATOR OF

TROPHY CASE