I found a text file with the complete King James Version of the Bible. I wrote a few macros and dumped it all into an Excel workbook. Each book is on a separate worksheet, and each verse is in a separate cell.
It has a handy hyperlink table of contents so you can jump to any book. I also wrote some summary formulas to calculate the number of characters in each book, and the average number of characters per verse. Then I added a word count feature: Enter a word and it displays the number of occurrences in each book.
Why? I just wanted to play around with Excel and its just good to see whats possible when you put your mind to it.
If you want the spreadsheet, drop me an email and I'll arrange for you.
No comments:
Post a Comment