Create Visual Filters by Frequency (Greek) - Excel Sheet
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
Comments
-
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
0 -
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.
-
0 -
UBS4 with all Vocabulary Helps on, and NA27 with parsing helps.
0 -
David Norman Wagner said:
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 [:)]
0 -
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)
0 -
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.
0 -
-
David Norman Wagner said:
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
0 -
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"
0 -
David Norman Wagner said:
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
0 -
David,
I clicked on the link to see your spreadsheet, but the link was broken. Any ideas as where to go.
Thanks
0 -
Curt Nordhielm said:
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
0 -
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.
0 -
Zak Metz said:
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 [:)]
0 -
It worked! Thanks Smiling.
0 -
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.
0 -
That was it! Thanks David.
0 -
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!
0
