Creating a Greek parsing guide for excel

My use of Greek is severely limited by my slowness at parsing.  Recently I’ve taken to parsing every word, and writing down its location so that I can easily see what’s going on (highlighting in different colours helps), and in this way I’ve been able to actually use the Greek for exegesis.

To speed up the process I’ve created an excel sheet which converts Bibleworks into a printout where every word is parsed (instead of just the one my mouse is hovering over). Biblworks probably has a way of doing this, but if so, I can’t find it.

Since I don’t know how to post an existing excel sheet, here’s a description of how to make the sheet yourself:

Compiling a parsing guide to the Greek NT

Need Bibleworks

Excel

Copy and paste the Greek text you want to study from BibleWorks (BGT) into word.  Find and replace every space with a paragraph break (use the find and replace function and find “ “ and replace with “^p”) to make a column.  Copy and paste this into an Excel sheet starting in A1.

Repeat the above step but with the BibleWorks morphology text (BGM) and insert into B1.

You should have two columns of the Greek text, one with just the Greek, the other with the Greek followed by @ followed by various letters and numbers.

Copy and paste the following formula into C1:

=IF(ISNUMBER(SEARCH(“@”,B1)),SEARCH(“@”,B1),””)

Copy and paste the following formula into D1:

=IF(C1=””,””,LEFT(B1,C1-1))

Copy and paste the following formula into E1:

=IF(C1=””,””,IF(EXACT(MID(B1,C1+1,1),”n”),”noun”,IF(EXACT(MID(B1,C1+1,1),”r”),”pronoun”,IF(EXACT(MID(B1,C1+1,1),”d”),”article”,IF(EXACT(MID(B1,C1+1,1),”v”),”verb”,IF(EXACT(MID(B1,C1+1,1),”a”),”adjective”,IF(EXACT(MID(B1,C1+1,1),”b”),”adverb”,IF(EXACT(MID(B1,C1+1,1),”c”),”conjunction”,IF(EXACT(MID(B1,C1+1,1),”p”),”preposition”,IF(EXACT(MID(B1,C1+1,1),”p”),”preposition”,IF(EXACT(MID(B1,C1+1,1),”x”),”particle”,IF(EXACT(MID(B1,C1+1,1),”t”),”indeclinable noun”,IF(EXACT(MID(B1,C1+1,1),”i”),”interjection”, IF(EXACT(MID(B1,C1+1,1),”z”),”unknown lemma”,”Error, unrecognised initial letter”))))))))))))))

Copy and paste the following formula into F1:

=IF(C1=””,””,IF(EXACT(MID(B1,C1+2,1),”a”),”accusative”,IF(EXACT(MID(B1,C1+1,2),”cc”),”coordinate”,IF(EXACT(MID(B1,C1+1,2),”ac”),”cardinal number”,IF(EXACT(MID(B1,C1+1,2),”nd”),”dative”,IF(EXACT(MID(B1,C1+1,2),”rd”),”demonstrative”,IF(EXACT(MID(B1,C1+1,2),”dd”),”dative”,IF(EXACT(MID(B1,C1+1,2),”vd”),”imperative”,IF(EXACT(MID(B1,C1+1,2),”pd”),”dative”,IF(EXACT(MID(B1,C1+2,1),”e”),”reciprocal”,IF(EXACT(MID(B1,C1+1,2),”ri”),”indefinite”,IF(EXACT(MID(B1,C1+1,2),”vi”),”indicative”,IF(EXACT(MID(B1,C1+1,2),”ai”),”indefinite”,IF(EXACT(MID(B1,C1+2,1),”m”),”numeral”,IF(EXACT(MID(B1,C1+1,2),”nn”),”nominative”,IF(EXACT(MID(B1,C1+1,2),”dn”),”nominative”,IF(EXACT(MID(B1,C1+1,2),”vn”),”infinitive”,IF(EXACT(MID(B1,C1+1,2),”an”),”normal”,IF(EXACT(MID(B1,C1+1,2),”vo”),”optative”,IF(EXACT(MID(B1,C1+1,2),”ao”),”ordinal number”,IF(EXACT(MID(B1,C1+1,2),”rp”),”personal”,IF(EXACT(MID(B1,C1+1,2),”vp”),”participle”,IF(EXACT(MID(B1,C1+1,2),”pp”),”indeterminate”,IF(EXACT(MID(B1,C1+2,1),”q”),”interogative”,IF(EXACT(MID(B1,C1+2,1),”r”),”relative”,IF(EXACT(MID(B1,C1+1,2),”vs”),”subjunctive”,IF(EXACT(MID(B1,C1+1,2),”as”),”possessive”,IF(EXACT(MID(B1,C1+1,2),”cs”),”subordinate”,IF(EXACT(MID(B1,C1+2,1),”t”),”intensive”,IF(EXACT(MID(B1,C1+2,1),”v”),”vocative”,IF(EXACT(MID(B1,C1+2,1),”x”),”reflexive”,IF(EXACT(MID(B1,C1+2,1),”g”),”genitive”,IF(EXACT(MID(B1,C1+2,1),””),””,”Error, letter not recognised”)))))))))))))))))))))))))))))))))

Copy and paste the following formula into G1:

=IF(C1=””,””,IF(EXACT(MID(B1,C1+3,1),”a”),IF(EXACT(MID(B1,C1+1,1),”v”),”aorist”,”accusative”),IF(EXACT(MID(B1,C1+3,1),”d”),”dative”,IF(EXACT(MID(B1,C1+3,1),”f”),IF(EXACT(MID(B1,C1+1,1),”v”),”future”,”feminine”),IF(EXACT(MID(B1,C1+3,1),”g”),”genitive”,IF(EXACT(MID(B1,C1+3,1),”i”),”imperfect”,IF(EXACT(MID(B1,C1+3,1),”m”),”masculine”,IF(EXACT(MID(B1,C1+3,1),”n”),IF(EXACT(MID(B1,C1+1,1),”n”),”neuter”,IF(EXACT(MID(B1,C1+1,1),”d”),”neuter”,”nominative”)),IF(EXACT(MID(B1,C1+3,1),”p”),”present”,IF(EXACT(MID(B1,C1+3,1),”v”),”vocative”,IF(EXACT(MID(B1,C1+3,1),”x”),”perfect”,IF(EXACT(MID(B1,C1+3,1),”y”),”pluperfect”,IF(EXACT(MID(B1,C1+3,1),”z”),”future perfect”,IF(EXACT(MID(B1,C1+3,1),””),””,”error”))))))))))))))

Copy and paste the following formula into H1:

=IF(C1=””,””,IF(EXACT(MID(B1,C1+4,1),”a”),”active”,IF(EXACT(MID(B1,C1+4,1),”e”),”middle/passive”,IF(EXACT(MID(B1,C1+4,1),”f”),”feminine”,IF(EXACT(MID(B1,C1+4,1),”m”),IF(EXACT(MID(B1,C1+1,1),”v”),”middle”,”masculine”),IF(EXACT(MID(B1,C1+4,1),”n”),”neuter”,IF(EXACT(MID(B1,C1+4,1),”p”),IF(EXACT(MID(B1,C1+1,1),”v”),”passive”,”plural”),IF(EXACT(MID(B1,C1+4,1),”s”),”singular”,IF(EXACT(MID(B1,C1+4,1),””),””,”error”)))))))))

Copy and paste the following formula into I1:

=IF(C1=””,””,IF(EXACT(MID(B1,C1+5,1),”1″),”1st person”,IF(EXACT(MID(B1,C1+5,1),”2″),”2nd person “,IF(EXACT(MID(B1,C1+5,1),”3″),”3rd person”,IF(EXACT(MID(B1,C1+5,1),”a”),”accusative”,IF(EXACT(MID(B1,C1+5,1),”c”),”common noun”,IF(EXACT(MID(B1,C1+5,1),”d”),”dative”,IF(EXACT(MID(B1,C1+5,1),”g”),”genitive”,IF(EXACT(MID(B1,C1+5,1),”n”),”nominative”,IF(EXACT(MID(B1,C1+5,1),”p”),IF(EXACT(MID(B1,C1+1,1),”n”),”proper name”,”plural”),IF(EXACT(MID(B1,C1+5,1),”s”),”singular”,IF(EXACT(MID(B1,C1+5,1),”v”),”vocative”,IF(EXACT(MID(B1,C1+5,1),””),””,”error”)))))))))))))

Copy and paste the following formula into J1:

=IF(C1=””,””,IF(EXACT(MID(B1,C1+6,1),”c”),”comparative”,IF(EXACT(MID(B1,C1+6,1),”f”),”feminine”,IF(EXACT(MID(B1,C1+6,1),”m”),”masculine”,IF(EXACT(MID(B1,C1+6,1),”n”),IF(EXACT(MID(B1,C1+1,1),”v”),”neuter”,””),IF(EXACT(MID(B1,C1+6,1),”p”),”plural”,IF(EXACT(MID(B1,C1+6,1),”s”),IF(EXACT(MID(B1,C1+1,1),”v”),”singular”,”superlative”),IF(EXACT(MID(B1,C1+6,1),””),””,”error”))))))))

Copy and paste the following formula into K1:

=IF(C1=””,””,IF(EXACT(MID(B1,C1+7,1),”p”),”plural”,IF(EXACT(MID(B1,C1+7,1),”s”),”singular”,IF(EXACT(MID(B1,C1+7,1),””),””,”error”))))

Select the formulaes  in C1-K1 and copy them down the excel sheet.

Hide columns B and C.

What you should see

You should have the Greek text down the first column

The lexical form in the second column.

The parsing of the word in the format of the Bibleworks morphology.

(Note that non-comparative/superlative adjectives and non-proper nouns are not recorded in the excel programme, instead a blank space is present).

If you seen an error message it is most likely to be a word which can be parsed in multiple ways.

Some words may be ambiguous out of context, but in the context are unambiguous (as perceived by Bibleworks).  There is no indication of the existence of alternative ways of parsing the words.

If there are any problems, do let me know (even if you can fix them yourself!)

Josh – jvb116 [at] gmail.com

Advertisements
This entry was posted in Uncategorized and tagged , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s