Searching for Louw-Nida Domains

Page 1 of 1 (7 items)
This post has 6 Replies | 0 Followers

Posts 150
Ryan Robinson | Forum Activity | Posted: Sat, Mar 24 2018 8:46 AM

I don't know if this can be done. So, I would appreciate if anyone can help me figure out if it is possible. 

So, I want to see what are the highest occurring domains in 1 Corinthians 1:10-4:21. However, I don't want to find the highest occurring subdomains. 

I know how to find the highest occurring subdomain (92.24). I want to know if it's 92 or 1 or 12 and so on. 

If someone could help me here, that would be awesome! 

Thanks!

Posts 18107
Forum MVP
Keep Smiling 4 Jesus :) | Forum Activity | Replied: Sat, Mar 24 2018 2:46 PM

Ryan Robinson:
I know how to find the highest occurring subdomain (92.24). I want to know if it's 92 or 1 or 12 and so on. 

Dreaming of Concordance export that would include sub-domain counts as shown on screen: (would allow spreadsheet to group domains for summarization)

Louw-Nida sub-domain count in 1 Corinthians 1:10-4:21 is 1330. Screen shot shows domain 92 having count of 288, which is 21.7 %. Domain 89 has count of 186, which is 14 %.

Sense shows a lot of quality and wisdom

Keep Smiling Smile

Posts 13383
Forum MVP
Mark Barnes | Forum Activity | Replied: Sat, Mar 24 2018 3:23 PM

I’m not at my desk at the moment, but I think you get LN numbers in Analysis export to Excel. If so, what you want should be doable. 

Posts 150
Ryan Robinson | Forum Activity | Replied: Sun, Mar 25 2018 12:29 PM

Yeah. You do. But again, it would be something like 92.x, not just 92. 

I am not savvy enough on Excel to figure out just the higher level domain with that exported. If you can tell me how to do that, I would be thankful. 

Posts 2377
Beloved | Forum Activity | Replied: Sun, Mar 25 2018 2:54 PM

Ryan Robinson:

Yeah. You do. But again, it would be something like 92.x, not just 92. 

I am not savvy enough on Excel to figure out just the higher level domain with that exported. If you can tell me how to do that, I would be thankful. 

If you already know how to extract the data for export to Excel you are familiar with the hard part, working with the data in Excel is fairly straightforward. First, present the data in the format you desire. Here's what I did.

You will notice that in my example the domains are already in finished format, sorry about that. Next, select the entire column that has Louw Nida followed by the sub-domain; don't select the column heading. On the Home tab note Find & Select at your far right; select this. From the drop-down list select Replace. In the dialogue box, enter Louw Nida. Then select Find All; then Replace All. The result you will be left with are all the sub-domain numbers.

Now you will select all of the sub-domain numbers. Once you have accomplished this your home free. Select Decrease Decimal in the Number field and the result is what you are after. I hope you find this helpful. Should you accidentally select the corner of the cell and replace all the data in the cells to agree with the first cell CTRL-Z will put the data right. 

Meanwhile, Jesus kept on growing wiser and more mature, and in favor with God and his fellow man.

International Standard Version. (2011). (Lk 2:52). Yorba Linda, CA: ISV Foundation.

Posts 18107
Forum MVP
Keep Smiling 4 Jesus :) | Forum Activity | Replied: Sun, Mar 25 2018 5:41 PM

Ryan Robinson:
I am not savvy enough on Excel to figure out just the higher level domain with that exported.

Export Louw-Nida search to Excel file:

Open with LibreOffice (or Excel) followed by inserting a column for Domain

Formula extracts Domain number from string "Louw Nida ##.###" where the number of Domain starts in position 11

=MID(G2,11,FIND(".",G2)-11)

Used FIND since some Domains are single digits while others are two. When Domain has single digit, then FIND returns 12 (so calculates length of one for text copy). When Domain has two digits, then FIND returns 13 (so length to copy is two characters).

Copied formula to rest of column followed by adding another column with value of 1 so could insert a Pivot Table to sum Count by Domain

Sorted Pivot Table Count in Descending Order. Added Calculation to show % Used

Domain 92 has 314 Greek words in passage 1 Corinthians 1:10-4:21

Keep Smiling Smile

Posts 2377
Beloved | Forum Activity | Replied: Sun, Mar 25 2018 8:53 PM

KS4J, Your work not surprisingly supercedes mine. After some effort I was able to duplicate your results in Excel. Thanks for your input. I've learned a lot as usual. 

Meanwhile, Jesus kept on growing wiser and more mature, and in favor with God and his fellow man.

International Standard Version. (2011). (Lk 2:52). Yorba Linda, CA: ISV Foundation.

Page 1 of 1 (7 items) | RSS