BIBLION: "A small book, a scroll, a written document. A sheet on which something has been written." 
DAWG: Digital-Analog Weekly Grouping.

Biblion Dawg is a simple spreadsheet with supporting audio files, arranging the Bible into a 52-session reading & listening plan. Berean Standard Bible is the default text, given how much audio is available. 

(Trust me, he can hear. Otherwise they'll fall off his head.)

Note: This is a pet project to help me read the Bible in a year. The preset sessions have not yet been fully worked through and may be tweaked based on experience and feedback. It's possible the AI-generated formulas for counts can be improved upon.

---

Setup ►

1. Fetch Project
2. Fetch Audio
3. Store Audio

Spreadsheet ►

1. SESSION
2. Overview (Books)
3. Deck (Chapters)
4. Bible (Verses)
5. Timelines

Preset Sessions ►

1. Word & Time
2. Book Categories
3. Groupings
4. Session Map (1-52)
   
5. Timelines 

Extras ►

1. Bibles & Topics
2. Switch Audio

---

Setup ►

1. Fetch Project

Download & extract biblion-dawg.zip (note the empty folders for audio files):

Biblion-Dawg.xlsx is the main project spreadsheet. Open in LibreOffice Calc or Microsoft Excel. 

The SESSION folder stores Playlist ► m3u files, including music-backed alternatives (104 total).

2. Fetch Audio

Audio files used are available at OpenBible.com, split into book or chapter mp3 files:

Recommended (Chapters)

These are needed to use the listening plan. Bob Souer is an excellent narrator, by all accounts and metrics. Download the full zip files:

• New Testament: BSB_00_Souer_NT.zip - 260 files - 921MB  
• Old Testament: BSB_00_Souer_OT.zip - 929 files - 4.2G

Index page: https://openbible.com/audio/souer/

Optional (Music and Books)

Download the mp3 files individually (manual or script). The zips contain chapter files, in my experience.

• Music-backed New Testament chapters, read by Jordan Scott Gilbert (1.6 GB):
  • https://openbible.com/audio/gilbert_music/
  • Linked to in Deck (Chapters) sheet

• Full Old & New Testament in book length files, read by Bob Souer (6.0 GB):
  • https://openbible.com/audio/souer_books/
  • Linked to in Overview (Books) sheet

3. Store Audio

Put downloaded mp3 files in the AUDIO folders:

---

Spreadsheet ►

Section 1 gives an overview of basic SESSION sheet use. The other sheets are covered in more detail later.

1. SESSION

Select Session dropdown (1-52):

Track overall progress in top-middle:

With selected session stats below:

Playlist ►

Follow hyperlink Playlist ► to open all session chapters in default audio player:

Or choose an option in Next Chapter section in bottom-middle:

Play ►

Click Play ► for the next chapter in session:

Display ►

Jumps to the start of chapter text in Bible (Verses) sheet:

Timelines ► 

Links to row in Timelines sheet:

Deck ► 

Links to Deck (Chapters), Progress column P (dropdown 0/1):

Notes: 

• In all sheets, count formulas are kept in the first data row for reference. All other rows are static numbers.
• Hidden columns are used by hyperlinks.

2. Overview (Books)

Full list of 66 books:

Play ▸ hyperlinks are for the optional book mp3 files.

3. Deck (Chapters)

Full list of 1189 chapters:

With optional music-backed New Testament in columns T - X:

The Speed column is purely advisory and will not impact play directly - set manually in audio player.

4. Bible (Verses) 

Berean Standard Bible translation by default, one verse per row (31102):

See Extras for 13 more Bible translations.

5. Timelines

Source is OpenBible's "Bible Book Outlines - docx" (231 KB):

Converted to csv using AI-generated Python scripts. Imported and word counts calculated in cell:

---

Preset Sessions ►

The 52 preset sessions follow a fairly straight-forward parallel reading of Old and New Testaments with Wisdom Literature handled separately.

1. Word & Time

Words to read and time to listen:

	Old Testament (OT)	New Testament (NT)	Total
Books	39	27	66
Chapters	929	260	1,189
Verses	23,145	7,957	31,102
Words (BSB Bible)	554,819 (76%)	171,897 (24%)	726,716
Time (Bob Souer)	52:23:49	16:50:16	69:14:05
Time (Jordan Gilbert)	(use Souer OT)	18:05:45	70:29:34

Giving an average session of 1 hour 20 minutes (~14,000 words).

2. Book Categories

Books are divided into ten categories, five in each Old and New Testaments:

Cat#	Category	Books	Chapters	Verses	Words	Sessions
1	Pentateuch (Law)	5	187	5,852	140,274	10
2	Historical Books	12	249	7,018	184,256	13.2
3	Wisdom Literature	5	243	4,785	78,951	5.6
4	Major Prophets	5	183	4,440	123,441	8.8
5	Minor Prophets	12	67	1,050	27,897	2
6	Gospels	4	89	3,779	78,364	5.6
7	Historical	1	28	1,007	22,468	1.6
8	Pauline Epistles	13	87	2,033	43,131	3.1
9	General Epistles	8	34	734	16,633	1.2
10	Apocalyptic	1	22	404	11,301	0.8
	TOTAL	66	1,189	31,102	726,716	52

3. Groupings

Each session includes chapters from three groupings (A, B, C):

	A - Old Testament	B - Wisdom Literature	C - New Testament
Categories	1, 2, 4, 5	3	6-10
Books	34	5	27
Words	475,868 (65%)	78,951 (11%)	171,897 (24%)
Sessions	34.1	5.6	12.3
Words / Session	9151	1518	3306

Books are read in the order below. Underlined books (33) are under 30 minutes long (< 5200 words) so covered in a single session. 

A - Old Testament 

Narrative Backbone (Genesis – Esther)

Section	Books in Order
The Pentateuch (Torah)	Genesis → Exodus → Leviticus → Numbers → Deuteronomy
Conquest and Early Israel	Joshua → Judges → Ruth
United & Divided Monarchy	1–2 Samuel → 1–2 Kings
Parallel Retelling	1–2 Chronicles
Return from Exile	Ezra → Nehemiah → Esther

The Prophets (Grouped by Historical Period)

Period	Books in Order
Pre-exile (During the Kings)	Isaiah → Jeremiah → Lamentations → Hosea → Joel → Amos → Obadiah → Jonah → Micah → Nahum → Habakkuk → Zephaniah
During Babylonian Exile	Ezekiel → Daniel
Post-exile (Return & Rebuilding)	Haggai → Zechariah → Malachi

B - Wisdom Literature

Sequence	Books/Sections
Deep suffering	Psalms 1-72 → Job → Proverbs 1-9
Deep cynicism	Psalms 73-106 → Ecclesiastes → Proverbs 10-21
Joy & love	Psalms 107-150 → Song of Solomon → Proverbs 22-31

Note: Ecclesiastes and Song of Solomon span multiple sessions.

C - New Testament

Section	Books in Order
Gospels	Mark (shortest and earliest) Matthew Luke (expands on Mark) John (very different style)
History	Acts
Paul’s Letters (~written order)	1 Thessalonians → 2 Thessalonians → Galatians → 1 Corinthians → 2 Corinthians → Romans → Colossians → Philemon → Ephesians → Philippians → 1 Timothy → Titus → 2 Timothy
General Epistles	Hebrews (author unknown) → James → 1–2 Peter → Jude → 1–3 John
Apocalypse	Revelation

4. Session Map

Full chapter list with word counts was processed by AI-generated Python script to output an initial reading plan with a 14000 word target across the 3 groupings. MAP sheet is a static visual reference:

Deck (Chapters) Session Column O also has the 1-52 session assignments. Any changes to MAP need manually applying to Deck sheet as well. The playlist files will also need updating:

5. Timelines

Finally, the session chapter assignments were tweaked to fit timeline headings where possible:

See all session stats and progress in SESSION sheet below main menu:

---

Extras ►

1. Bibles & Topics

BiblesTopics.xlsx - optional download (18.5 MB). Currently a merging of two OpenBible.com spreadsheets:

Bibles (14)

Bible source texts imported from "14-in-1 Bible Database - xlsx" (15.8 MB):

Each translation has the same number of verse rows (31102). Copy the selected translation column into Bible (Verses) sheet in Biblion-Dawg.xlsx to use as primary text:

• BSB - Berean Standard Bible
• KJV - King James Bible: Pure Cambridge Edition
• ASV - American Standard Version
• AKJV - American King James Version
• CPDV - Catholic Public Domain Version
• DBT - Darby Bible Translation
• DRB - Douay-Rheims Bible
• ERV - English Revised Version
• JPS/WEY - JPS Tanakh 1917 OT / Weymouth NT
• NHEB - New Heart English Bible (Public Domain 2008-2021)
• SLT - Smith's Literal Translation
• WBT - Webster Bible Translation
• WEB - World English Bible
• YLT - Young's Literal Translation 

Topics

Topics with verse cross-references. Imported from "Topical Index - xlsx" (9.8 MB):

Sources: Torrey’s, Nave’s, OpenBible.info, BibleHub.com.

I counted 117,242 verse references across 46,592 topics and subtopics:

• Nave’s Topical Bible:
  • 3,146 Top
  • 22,155 Nav
• Torrey’s Topical Textbook:
  • 21,291 TTT 

2. Switch Audio

I've not yet tested but it should be possible to switch the audio file links to other sources. The playlist files will need updating/re-creating separately. Possible alternatives:

OpenBible.com

• King James Version (KJV)
• Majority Standard Bible

AudioTreasure.com

• WEB – World English Bible
  • David Williams OT: WEB_OT_Audio.zip - 900 MB
  • David Williams NT: WEB_NT_Audio.zip - 300 MB

• KJV – King James Bible (Pure Cambridge Edition compatible)
  • Rev Dan Wagner OT: KJV_OT_Audio_TB.zip - 900 MB
  • Rev Dan Wagner NT: KJV_NT_Audio_TB.zip - 270 MB

---

Credits & Acknowledgments

No affiliation with any links shared. Many thanks for the awesome content!
I'm reading along with a New American Standard Bible (1995).

OpenBible.com

(Open Bible by Bible Hub) - see OpenBible.com Terms. 

All source data and audio files (xlsx, docx, mp3). A few more resources worth checking out:

• Timeline charts:
  • https://openbible.com/timelinecharts.htm
• Translation tables: 
  • https://bereanbible.com/bsb_tables.xlsx (55.5MB) 
• Full HTML Software package to play with offline (it's big).

Bob Souer

Old and New Testament audio

Grok paragraph: "Widely regarded as an exceptional narrator with decades of experience voicing Scripture (notably the complete NKJV Bible for Thomas Nelson). His clear, authoritative yet warm delivery and precise diction bring the Berean Standard Bible's literal-yet-readable style to life with clarity and spiritual resonance."

Jordan Scott Gilbert

Music-backed New Testament audio

Grok paragraph: "An award-winning Broadway producer, director, and singer with a rich, theatrical voice. His natural rhythm and emotional depth make him especially effective for music-backed audio, where orchestral scores blend seamlessly with his expressive yet reverent delivery, creating an immersive experience while preserving the text's clarity and dignity."

Orville James Nave

Top Nav = Nave’s Topical Bible (1896)

Grok paragraph: "Orville James Nave (1841–1917), a U.S. Army chaplain and Methodist theologian who served during the Civil War era, compiled Nave's Topical Bible over fourteen years of meticulous study (with assistance from his wife Anna). This public domain resource features over 20,000 topics with more than 100,000 Scripture references—widely regarded as the most detailed and scholarly topical index ever produced."

Reuben Archer Torrey

TTT = Torrey’s Topical Textbook (1897)

Grok paragraph: "Reuben Archer Torrey (1856–1928), an American evangelist, pastor, and educator who succeeded Dwight L. Moody at the Moody Bible Institute, authored Torrey's Topical Textbook as a practical Scripture reference tool. Organized around 628 main topics with over 20,000 verse references, this preacher-oriented public domain work is designed for efficient sermon preparation and teaching—providing a streamlined, application-focused alternative to broader topical indexes."

Cursor/Grok AI

(https://cursor.com/  - https://grok.com)

Used to create Python (.py) scripts:

• File metadata for size and length of mp3s
• Csv to playlist m3u files
• Chapter wordcounts to basic session map

Advised on:

• Session planning - books, categories and chapter groupings.
• Spreadsheet formulas - hyperlinks, stats and progress.

Aseprite

MS Paint on steroids, in my experience. Used for all image editing:
https://www.aseprite.org/ - $19.99, worth it.

A small book, a scroll, a written document.
A sheet on which something has been written. - BibleStudyTools.com