Open Access. Powered by Scholars. Published by Universities.®

Arts and Humanities Commons

Open Access. Powered by Scholars. Published by Universities.®

MS Excel

Biblical Studies

Publication Year

Articles 1 - 12 of 12

Full-Text Articles in Arts and Humanities

Hebrew Bible (Tanakh) For Data Analysis, Keith L. Yoder Dec 2018

Hebrew Bible (Tanakh) For Data Analysis, Keith L. Yoder

Keith L. Yoder

This experimental database contains the entire Hebrew Bible (Tanach) in a form suitable for Data Analysis. Details will be added later.


Details For Acronyms And Word/Letter Counts In The Tanakh: Daniel, Ezra-Nehemiah, And 1-2 Chronicles, Keith L. Yoder Dec 2018

Details For Acronyms And Word/Letter Counts In The Tanakh: Daniel, Ezra-Nehemiah, And 1-2 Chronicles, Keith L. Yoder

Keith L. Yoder

This Excel table provides a convenient tool for searching for acronyms (horizontal acrostics) in the Tanakh. It  contains a verse-by-verse compilation of orthographic word counts, consonantal letter counts, first letters of each Hebrew word in traditional right-to-left sequence, and last letters of each Hebrew word in left-to-right sequence. Each verse-record is tagged by book name and chapter/verse reference, and each column-field may be searched and manipulated with Excel Auto-Filter. The characters in the Hebrew letter fields are separated by spaces, and searches may be done using Hebrew Unicode consonants. For example, a search for a Tetragrammaton acronym may be done …


Acronyms And Word/Letter Counts In The Tanakh: The Twelve (Minor) Prophets, Keith L. Yoder Dec 2017

Acronyms And Word/Letter Counts In The Tanakh: The Twelve (Minor) Prophets, Keith L. Yoder

Keith L. Yoder

This Excel table provides a convenient tool for searching for acronyms (horizontal acrostics) in the Tanakh. It contains a verse-by-verse compilation of orthographic word counts, consonantal letter counts, first letters of each Hebrew word in traditional right-to-left sequence, and last letters of each Hebrew word in left-to-right sequence. Each verse-record is tagged by book name and chapter/verse reference, and each column-field may be searched and manipulated with Excel Auto-Filter. The characters in the Hebrew letter fields are separated by spaces, and searches may be done using Hebrew Unicode consonants. For example, a search for a Tetragrammaton acronym may be done …


Acronyms And Word/Letter Counts In The Tanakh: The Five Megillot, Keith L. Yoder Dec 2017

Acronyms And Word/Letter Counts In The Tanakh: The Five Megillot, Keith L. Yoder

Keith L. Yoder

This Excel table provides a convenient tool for searching for acronyms (horizontal acrostics) in the Tanakh. It contains a verse-by-verse compilation of orthographic word counts, consonantal letter counts, first letters of each Hebrew word in traditional right-to-left sequence, and last letters of each Hebrew word in left-to-right sequence. Each verse-record is tagged by book name and chapter/verse reference, and each column-field may be searched and manipulated with Excel Auto-Filter. The characters in the Hebrew letter fields are separated by spaces, and searches may be done using Hebrew Unicode consonants. For example, a search for a Tetragrammaton acronym may be done …


Acronyms And Word/Letter Counts In The Tanakh: The Five Books Of Moses, Keith L. Yoder Dec 2017

Acronyms And Word/Letter Counts In The Tanakh: The Five Books Of Moses, Keith L. Yoder

Keith L. Yoder

This Excel table provides a convenient tool for searching for acronyms (horizontal acrostics) in the Tanakh. It contains a verse-by-verse compilation of orthographic word counts, consonantal letter counts, first letters of each Hebrew word in traditional right-to-left sequence, and last letters of each Hebrew word in left-to-right sequence. Each verse-record is tagged by book name and chapter/verse reference, and each column-field may be searched and manipulated with Excel Auto-Filter. The characters in the Hebrew letter fields are separated by spaces, and searches may be done using Hebrew Unicode consonants. For example, a search for a Tetragrammaton acronym may be done …


Acronyms And Word/Letter Counts In The Tanakh: The Former Prophets - Joshua, Judges, Samuel, And Kings, Keith L. Yoder Dec 2017

Acronyms And Word/Letter Counts In The Tanakh: The Former Prophets - Joshua, Judges, Samuel, And Kings, Keith L. Yoder

Keith L. Yoder

This Excel table provides a convenient tool for searching for acronyms (horizontal acrostics) in the Tanakh. It contains a verse-by-verse compilation of orthographic word counts, consonantal letter counts, first letters of each Hebrew word in traditional right-to-left sequence, and last letters of each Hebrew word in left-to-right sequence. Each verse-record is tagged by book name and chapter/verse reference, and each column-field may be searched and manipulated with Excel Auto-Filter. The characters in the Hebrew letter fields are separated by spaces, and searches may be done using Hebrew Unicode consonants. For example, a search for a Tetragrammaton acronym may be done …


20,000 Sequences Of Psalm 119 Randomly Shuffled Primary Torah Gender Terms, Keith L. Yoder Dec 2017

20,000 Sequences Of Psalm 119 Randomly Shuffled Primary Torah Gender Terms, Keith L. Yoder

Keith L. Yoder

This is the third of three Excel tables which have been prepared to support my experiment at the end of the essay by Samuel Zinner, "Psalm 119’s Eight Key Torah Terms’ Hidden Gender-Based Distribution Patterns". As explained below, this file contains a VBA module with the code used to generate the random trials used in this experiment. Many computers may throw up a security alert to prevent downloading and/or opening of this file, so the VBA code in that module is also posted on this page at https://works.bepress.com/klyoder/41/.

The first file contains the first table described in the summary of …


Acronyms And Word/Letter Counts In The Tanakh: Isaiah, Jeremiah, And Ezekiel, Keith L. Yoder Dec 2017

Acronyms And Word/Letter Counts In The Tanakh: Isaiah, Jeremiah, And Ezekiel, Keith L. Yoder

Keith L. Yoder

This Excel table provides a convenient tool for searching for acronyms (horizontal acrostics) in the Tanakh. It contains a verse-by-verse compilation of orthographic word counts, consonantal letter counts, first letters of each Hebrew word in traditional right-to-left sequence, and last letters of each Hebrew word in left-to-right sequence. Each verse-record is tagged by book name and chapter/verse reference, and each column-field may be searched and manipulated with Excel Auto-Filter. The characters in the Hebrew letter fields are separated by spaces, and searches may be done using Hebrew Unicode consonants. For example, a search for a Tetragrammaton acronym may be done …


Acronyms And Word/Letter Counts In The Tanakh: Psalms, Proverbs, And Job, Keith L. Yoder Dec 2017

Acronyms And Word/Letter Counts In The Tanakh: Psalms, Proverbs, And Job, Keith L. Yoder

Keith L. Yoder

This Excel table provides a convenient tool for searching for acronyms (horizontal acrostics) in the Tanakh. It contains a verse-by-verse compilation of orthographic word counts, consonantal letter counts, first letters of each Hebrew word in traditional right-to-left sequence, and last letters of each Hebrew word in left-to-right sequence. Each verse-record is tagged by book name and chapter/verse reference, and each column-field may be searched and manipulated with Excel Auto-Filter. The characters in the Hebrew letter fields are separated by spaces, and searches may be done using Hebrew Unicode consonants. For example, a search for a Tetragrammaton acronym may be done …


100,000 Sequences Of Psalm 119 Randomly Shuffled Primary Torah Gender Terms (179), Keith L. Yoder Dec 2017

100,000 Sequences Of Psalm 119 Randomly Shuffled Primary Torah Gender Terms (179), Keith L. Yoder

Keith L. Yoder

Update of 8 Oct 2019:

The uploaded file is a revised Excel table of 100,000 random sample runs distributing 89 "masculine" and 90 "feminine" Torah terms into the 22 strophes of Psalm 119, as part of my experiment at the end of the essay by Samuel Zinner, "Psalm 119’s Eight Key Torah Terms’ Hidden Gender-Based Distribution Patterns".. The rest of the text below will be revised later.

Keith Yoder

The first file contains the first table described in the summary of that experiment, a table of 1,000 randomly generated sequences of 179 gender terms, 90 (f)eminine and 89 (m)asculine, over …


100,000 Sequences Of Psalm 119 Randomly Shuffled Primary Torah Gender Terms (180), Keith L. Yoder Dec 2017

100,000 Sequences Of Psalm 119 Randomly Shuffled Primary Torah Gender Terms (180), Keith L. Yoder

Keith L. Yoder

Update of 8 Oct 2019:

The uploaded file is the second revised Excel table of 100,000 random sample runs distributing 90 "masculine" and 90 "feminine" Torah terms into the 22 strophes of Psalm 119, as part of my experiment at the end of the essay by Samuel Zinner, "Psalm 119’s Eight Key Torah Terms’ Hidden Gender-Based Distribution Patterns".. The rest of the text below will be revised later.

Keith Yoder

This is the second of three Excel tables which have been prepared to support my experiment at the end of the essay by Samuel Zinner, "Psalm 119’s Eight Key Torah …


Greek New Testament For Data Analysis, Keith L. Yoder Dec 2016

Greek New Testament For Data Analysis, Keith L. Yoder

Keith L. Yoder

Updated: 18 December 2017
This Excel data file (compatible with Excel 2007 and later versions) is an extract of my working Greek New Testament database which I use for statistical and data analysis. It originated in the early 2000's from UBS3 data files in beta code I obtained from CCAT, and has since been evolving through countless changes and corrections. A flat-file table display such as Excel 2007+ is the best format suitable for Autofilter and VBA applications, without involving a more complex XML format. The file itself may be opened with Excel 2007 or later versions, or with the …