Project status - a new way of looking at it

I have added a couple of calculated columns to a table I save after every decision when reading in Hebrew and writing in English. It tells me the last chapter and verse that I changed and when and the percentages of what I have read that is in my database and the percentage of the whole that I have in my data. So I won't forget where I am.

As I developed the calculation I noticed that I had not finished what I thought I had. About a dozen verses had been shortchanged. I had the complete text but I had failed to update the interlinear and it showed immediately. Where I was expecting 100.00, 99.xx showed up. But completion is a relative thing, isn't it. In this game, every new decision I make runs the risk of overturning a prior decision and having a ripple effect throughout the work.

My pace of reading will increase. Already it is more than double what it was. But no one should be in a hurry in this exercise. If one rushes, one misses the enjoyment of the new relationships among the words.

This is normally sorted by date in descending order. Some additional fields might be desirable, so I formatted a special query to see the whole in Tanach order. The table shows which verse I last changed and when. Over the last month, I have changed something in every book.

Of the two last columns, the first percentage is by word. This answers the question: How many of the words that I have, have I read and glossed in English. The second percentage is by chapter. This answers the question: How may of the chapters of the whole Bible have I in the data base.

If I keep going, I will finish. Nine books are completed out of 39. The 24 books of the Hebrew Bible are 39 books to the English. There are 2 of Samuel, 2 of Kings, 2 of Chronicles, 2 for Ezra-Nehemiah, and 12 for the minor prophets (for the English). That's a difference of 15 in the two ways of reckoning the contents of the 'Old' Testament.

Three of these are partially in the data, Job, Habakkuk and Malachi. Maybe I should go with those shorter prophetic books to see what I learn next. And the rest are barely begun, but at least one word of one chapter of each. Therefore at least one verse of one chapter of each.

Book	Ch/Vs	Changed	% words in db	% all chapters
Genesis	24:38	2015.06.22	10.46	6.00
Exodus	25:18	2015.07.14	1.41	7.50
Leviticus	1:14	2015.07.08	21.93	7.41
Numbers	6:7	2015.07.14	4.24	2.78
Deuteronomy	1:1	2015.07.14	31.19	2.94
Joshua	1:4	2015.07.14	.10	4.17
Judges	1:1	2015.07.15	.16	4.76
1 Samuel	17:34	2015.06.17	46.86	9.68
2 Samuel	1:1	2015.07.15	.06	4.17
1 Kings	1:1	2015.07.15	.05	4.55
2 Kings	1:1	2015.07.15	.11	4.00
Isaiah	66:12	2015.07.06	14.48	6.06
Jeremiah	1:1	2015.07.15	.06	1.92
Ezekiel	1:1	2015.07.15	.08	2.08
Joel	1:1	2015.07.15	1.25	25.00
Obadiah	1:1	2015.07.10	100.00	100.00
Jonah	3:10	2015.06.23	100.00	100.00
Micah	1:1	2015.07.15	.82	14.29
Habakkuk	3:19	2015.06.28	1.04	33.33
Zephaniah	3:12	2015.06.17	100.00	100.00
Haggai	1:1	2015.07.15	1.54	50.00
Zechariah	14:5	2015.07.15	.18	7.14
Malachi	1:1	2015.06.19	11.48	33.33
Job	9:9	2015.07.14	26.23	38.10
Psalms	94:1	2015.07.12	100.00	100.00
Proverbs	8:21	2015.07.15	11.33	6.45
Song	6:11	2015.07.13	100.00	100.00
Ruth	3:3	2015.06.17	100.00	100.00
Lamentations	3:40	2015.07.15	100.00	100.00
Qohelet	9:18	2015.07.15	100.00	100.00
Esther	8:9	2015.06.28	.13	20.00
Daniel	1:1	2015.07.15	.21	7.14
Ezra	1:1	2015.07.15	.22	10.00
Nehemiah	1:1	2015.07.15	.92	7.69
1 Chronicles	5:6	2015.07.14	.17	3.45
2 Chronicles	1:1	2015.06.20	1.32	2.78

I am currently working on Proverbs 8. I heard a modern motet recently at evensong and I wondered how they developed the words from this chapter as they claimed...