Create Visual Filters by Frequency (Greek) - Excel Sheet

Page 1 of 1 (19 items)
This post has 18 Replies | 4 Followers

Posts 8
David Norman Wagner | Forum Activity | Posted: Thu, Jul 2 2015 10:46 PM

I love Logos' Visual Filter tool and wanted to highlight Greek words according to frequency to help my vocabulary. 9-10x (185 lemmas) in Orange for Memorizing Currently, 5-8x (631) in Yellow for Memorizing Next, and 1-4x (3552) for Memorizing in the very distant, possibly non-existent future. Logos Word List can't do this kind of sorting by frequency so I made an Excel sheet that creates these list and formats them to make Visual Filters (see picture). 

I thought I'd post here in case anybody else was interested. This sheet seems to be working fine, but I still consider it Beta and consequently liable to inaccuracies and bugs. It uses a User Defined Function (ConcatRange-props to whoever originally made this function) so it'll warn you when it opens up that it contains Macros and will ask for permission to run. 

Hope somebody else can get some use out of this. It has helped tremendously with my reading, as I can size up a passage at merely a glance and focus on the words that need work while passing over words that would usually cause frustration. For 1st year students, make a list of the first 312 words (50+) and be encouraged by how much of the page gets highlighted!

This is my first post in the forums so if I'm not supposed to share files or should move this let me know. 

Visual Filter Builder by Frequency (Greek) - Excel Document Macros Enabled

Posts 8858
Forum MVP
Bruce Dunning | Forum Activity | Replied: Fri, Jul 3 2015 8:09 AM

Welcome to the forums David. What an excellent first post. Thanks so much for sharing. I've not had time to try this yet but I look forward to doing so at some point. I hope this is the first of many such posts and that you can become an active part of our community.

Using adventure and community to challenge young people to continually say "yes" to God

Posts 8
David Norman Wagner | Forum Activity | Replied: Fri, Jul 3 2015 10:23 AM

Appreciate the welcome Bruce. Let me know what you think.

As a side note, I recently discovered the ability to share documents on documents.logos.com. I have put up most of my filters that I use (They are all applied to UBS4, but to use them in other resources just open up the Visual Filter document and change the resource) 

---------------------------Description of my Shared Visual Filters----------------------------------------

Verb Tenses 

Present (Red), Imperfect (Orange) Aorist (Blue) Perfect (Purple) Future (Brown) PluPerfect (Yellow). There are boxes around Indicative, Imperative, Subjunctive, and Optative Moods, leaving Participles and Infinitives unboxed to help me think through how they relate to the main verbs. 

Lemmas 20+ (642) Blue

Lemmas 9-19 (593) Orange

Lemmas 5-8 (631) Yellow

Lemmas 1-4 (3552) Green

I have a three stage plan for Greek vocabulary acquisition. There are about 5400 words in the New Testament and if you memorize a third of them, 1800 words down to 5 occurrences, you know 95% of the 138,000 words that occur in the NT and will be able to recognize a lot of the 3600 words that constitute the frequency group of 1-4 by roots of words. The aim here is sight reading.

These 1800 words can easily be divided into roughly three groupings of 600 lemmas each - 20+ (642 words), 9-19 (593), 5-8 (631), and 1-4 (3552). Then if you are concentrating on a smaller grouping within one of those categories, just use the Visual Filter Creator to create a new list (e.g. I'm on 8-9 so I created a separate filter for those 185 words to concentrate on them more specifically). Also, I have removed Proper Nouns (from LN) from these lists. 

Filters with LXX or AF in the title

There are also copies of these four filters for the LXX (Septuagint), and the AF (Apostalic Fathers) to continue concentrating on NT vocab while your in those resources and also identify sections that you have a lot of the vocabulary for already. Logos' morphologies and/or accents for the lemmas are not the same for the LXX and the AF though so there will be inconsistencies applying these filters (e.g., αυτος, πορευω, αποθνησκω, επι are words I found in 20+ that had to be re-added in the filter because of accents differences)

Words Occurring < 10 in NT and > 10 in LXX

The idea for this one was from a friend in Seminary who wanted to find out how many words that occur less than 10 times in the NT that also occur more than 10 times in the LXX. This way as he'd learning below 10 in the NT he can concentrate on those that will get him the most mileage in the LXX. Out of the 14355 lemmas that occur in the LXX (from Lexham LXX using Swete. Wish I could use Rahlf's, but Logos won't produce the list!) there are 3166 that occur 10 times or more. Out of that 3166, 1203 occur less than 10 times in the NT and are included in this filters. 

-

Posts 8
David Norman Wagner | Forum Activity | Replied: Fri, Jul 3 2015 10:44 AM

UBS4 with all Vocabulary Helps on, and NA27 with parsing helps. 

Posts 15805
Forum MVP
Keep Smiling 4 Jesus :) | Forum Activity | Replied: Fri, Jul 3 2015 11:34 AM

David Norman Wagner:

Verb Tenses 

Present (Red), Imperfect (Orange) Aorist (Blue) Perfect (Purple) Future (Brown) PluPerfect (Yellow). There are boxes around Indicative, Imperative, Subjunctive, and Optative Moods, leaving Participles and Infinitives unboxed to help me think through how they relate to the main verbs. 

Logos wiki describes another set of Logos Greek Morphology visual filters => https://wiki.logos.com/Extended_Tips_for_Highlighting_and_Visual_Filters#Examples_of_visual_filters

Nominative case has yellow highlight. Verbs have Moods, Tenses, and Singular/Plural.  Participle has an image above with two curved lines (reminder participle has noun and verbal aspects). Prepositions have green underline.

Appears "eth" verbal ending in the Authorized Version corresponds with present tense.

Thread => LOUW NIDA VS BIBLE SENSE LEXICON shows some discourse visual filters with Louw-Nida tagging.

Keep Smiling Smile

Posts 8
David Norman Wagner | Forum Activity | Replied: Fri, Jul 3 2015 11:56 AM

Yes, those are helpful! I have followed and read a lot of your posts regarding visual filters and they are part of the inspiration for my own. So, thank you very much! Mark Barnes had a number of posts as well, along with his Greek and Hebrew Hapax lists that he has posted, that helped me tremendously. I can't find out how to message him, but if you are able to I hope he sees this and knows I own thanks to him as well! (And, of course the whole Logos Forum community, I have read and been helped so much here)

Posts 8
David Norman Wagner | Forum Activity | Replied: Mon, Jul 20 2015 8:15 AM

Uploaded minor update 7/20/15 - Default frequency selection is now "From" "To" for clarity. A few other changes. Same link in original post should download new file.

Posts 1557
John Kight | Forum Activity | Replied: Mon, Jul 20 2015 9:43 AM

Thanks David! Yes

For book reviews and more visit sojotheo.com 

Posts 8858
Forum MVP
Bruce Dunning | Forum Activity | Replied: Mon, Jul 20 2015 10:24 AM

David Norman Wagner:
As a side note, I recently discovered the ability to share documents on documents.logos.com. I have put up most of my filters that I use (They are all applied to UBS4, but to use them in other resources just open up the Visual Filter document and change the resource) 

Thanks David. Note, I could not get this link to work for me today. I'm not sure what the issue might be.

Using adventure and community to challenge young people to continually say "yes" to God

Posts 8
David Norman Wagner | Forum Activity | Replied: Mon, Jul 20 2015 10:43 AM

Bruce, sorry it looks like I didn't put the full link in. It should be: https://documents.logos.com/allusers

You can also manage your own documents to share if you leave off "allusers"

Posts 8858
Forum MVP
Bruce Dunning | Forum Activity | Replied: Mon, Jul 20 2015 12:46 PM

David Norman Wagner:
Bruce, sorry it looks like I didn't put the full link in. It should be: https://documents.logos.com/allusers

That links works better. Thanks again for sharing.

Using adventure and community to challenge young people to continually say "yes" to God

Posts 3
Curt Nordhielm | Forum Activity | Replied: Fri, Oct 9 2015 11:59 AM

David,

I clicked on the link to see your spreadsheet, but the link was broken. Any ideas as where to go.

Thanks

Posts 21731
Forum MVP
Graham Criddle | Forum Activity | Replied: Fri, Oct 9 2015 12:06 PM

Curt Nordhielm:

I clicked on the link to see your spreadsheet, but the link was broken. Any ideas as where to go.

Hi Curt - and welcome to the forums

Ive just tried the link and it worked fine.

What error message do you get, what browser are you using on which platform?

Graham

Posts 99
Zak Metz | Forum Activity | Replied: Tue, Feb 23 2016 6:36 AM

Friends, I'm studying Greek and would love to get this working. I downloaded the spreadsheet and I've created the visual filter, but I cannot get the expected results in the Bible. Could someone help? Here's a screen shot with what I'm doing.

https://www.dropbox.com/s/uvtfv0gey5nvizd/Screenshot%202016-02-23%2008.34.07.png?dl=0

Sorry I can't figure out the trick to get the screenshot to embed.

Posts 15805
Forum MVP
Keep Smiling 4 Jesus :) | Forum Activity | Replied: Tue, Feb 23 2016 6:49 AM

Zak Metz:
Sorry I can't figure out the trick to get the screenshot to embed.

Suggest using the paperclip in the forum editor to insert image file.

Keep Smiling Smile

Posts 99
Zak Metz | Forum Activity | Replied: Tue, Feb 23 2016 6:59 AM

It worked! Thanks Smiling.

Posts 8
David Norman Wagner | Forum Activity | Replied: Tue, Feb 23 2016 8:14 AM

Hey Zak,

I can look into this further when I have access to my computer. For now could you try changing the Visual Filter from "Bible" to "Morph". In the Visual Filter window it is at the top right corner listing "Basic", "Bible", and "Morph."

 Let me know if that helps. 

Posts 99
Zak Metz | Forum Activity | Replied: Tue, Feb 23 2016 9:41 AM

That was it! Thanks David.

Posts 8
David Norman Wagner | Forum Activity | Replied: Tue, Feb 23 2016 5:53 PM

No problem, glad you're trying it out. Let me know if you have any questions. 

I'm glad Logos has come out with the Reader's Interlinear feature, but still like the absence of interlinear glosses and just the color as the visual cue that I'm either responsible for a word or not. It also is very helpful in getting a feel for a books vocabulary. I'm in an Exegesis of James class right now and the number of green words (1-4 occurrences) lights up James like a Christmas tree!

Page 1 of 1 (19 items) | RSS