Tuesday, 21 February, 2006

1. By . Comment posted 21-Feb-2006 @01:29pm:

   What is your point?
2. By . Comment posted 21-Feb-2006 @01:36pm:

   That's really cool. I think I may have suggested this at one point when there was a "Bible" thread - you can keep the royalties.
3. By Toad. Comment posted 21-Feb-2006 @01:40pm:

   I ran a virus scan on it before I extracted it. It turns out that there are several dangerous memes in it. No thanks.
4. By . Comment posted 21-Feb-2006 @01:42pm:

   You know, Robert, now that you mention it I vaguely recall that you did indeed suggest it. Tell you what, you can have all the royalties it generates.
5. By concertinist. Comment posted 21-Feb-2006 @01:56pm:

   If I remember my science fiction right, isn't this how the universe ends?
6. By from a previously parallel universe. Comment posted 21-Feb-2006 @01:58pm:

   concertinist:
   If I remember my science fiction right, isn't this how the universe ends?
   
   Depends. You guys aren't using Yahweh over there, are you?
7. By Maven. Comment posted 21-Feb-2006 @01:59pm:

   The universe ends when the monks in remote Tibet get the billion names of God using an IBM mainframe. I hadn't thought about that story in years! Thanks, concertinist
8. By Birdie. Comment posted 21-Feb-2006 @02:01pm:

   Oh, man...that would be like me volunteering to work a corsage weekend just for fun. Yikes!
9. By jnetter. Comment posted 21-Feb-2006 @02:02pm:

   You might want to make your count function case insensitive.
10. By . Comment posted 21-Feb-2006 @02:10pm:

    concertinist, from a previously parallel universe, and Maven: Arthur C. Clarke, The Nine Billion Names of God
11. By . Comment posted 21-Feb-2006 @02:36pm:

    Oh yeah, that word cound should be case insensitive. Fixed!
12. By . Comment posted 21-Feb-2006 @02:45pm:

    Do you have an Amiga version?
13. By . Comment posted 21-Feb-2006 @02:54pm:

    Proof that God can even work through Atheists to do his (spreadsheet) bidding. You are a prophet of the 21st century.
14. By . Comment posted 21-Feb-2006 @03:26pm:

    Very good, but you have a typo on the tab for Ecclesiastes where it is spelled as "Esslesiastes"!
15. By . Comment posted 21-Feb-2006 @03:29pm:

    I downloaded the file but it wouldn't open.
16. By dan. Comment posted 21-Feb-2006 @03:36pm:

    The word count feature doesn't work using OpenOffice, but using Excel it's fun to type in expletives to find out how many times they occur.
17. By . Comment posted 21-Feb-2006 @04:13pm:

    You have too much time on your hands. You should get out more.
18. By meg_mac. Comment posted 21-Feb-2006 @04:20pm:

    xorg...compilations take time dude!!!
19. By . Comment posted 21-Feb-2006 @04:53pm:

    Typo corrected.
20. By . Comment posted 21-Feb-2006 @05:04pm:

    I should get out more? I sayeth unto you:
    
    Proverbs 4:7 - Wisdom is the principal thing; therefore get wisdom: and with all thy getting get understanding.
21. By . Comment posted 21-Feb-2006 @05:07pm:

    And furthermore:
    
    Nahum 3:1 - Woe to the bloody city! it is all full of lies and robbery; the prey departeth not;
22. By . Comment posted 21-Feb-2006 @05:17pm:

    Looks like the random verse selector function is working...
23. By . Comment posted 21-Feb-2006 @05:21pm:

    Random verse selector! Good idea.
24. By . Comment posted 21-Feb-2006 @05:29pm:

    THats nothing new.
25. By . Comment posted 21-Feb-2006 @06:52pm:

    Now all you have to do is figure out how to make all the words that Jesus said red font.
26. By . Comment posted 21-Feb-2006 @07:11pm:

    Thanks for the idea, 12. The random verse selector is now implemented. To use it, you must enable macros when you open the workbook.
27. By wally the duck. Comment posted 21-Feb-2006 @07:56pm:

    You're sick, J, sick.
    
    What's next, putting the dictionary in alphabetical order?
28. By . Comment posted 21-Feb-2006 @08:06pm:

    Sick?? Me? Sick? It's just textual data, Wally. It goes to show that I can be entertained by just about anything.
    
    Hmmmm... alphabetizing the dictionary. I'll put it on my to-do list.
29. By Indigo Kid. Comment posted 21-Feb-2006 @08:37pm:

    Christianity is for JW like cigarrettes used to be for me: addictive and abused and something I wanted to quit but couldn't...
    
    Bet you can't go for two weeks without an 'how wierd is Christianity' topic/post.
30. By Mean Jean II. Comment posted 21-Feb-2006 @08:48pm:

    Now, why on earth would anybody quit doing something they enjoyed just because YOU don't like it?
31. By . Comment posted 21-Feb-2006 @10:03pm:

    John...very nice....
    another suggestion...tried to do it myself but had too many beers...besides....you could do it better anyway....
    On the stats sheet...if you click on a hyperlink to a sheet....capture the sheet name that you're going to...look up what was entered in G2...and highlight all the entries that match that text.
32. By sen. Comment posted 21-Feb-2006 @10:21pm:

    You know I have never had a single one of you excel files work on OpenOffice. I wonder why?
    
    How about all seven of the Narnia books?
    I can supply the text if you can tweak the macros to work on OO
33. By . Comment posted 21-Feb-2006 @10:43pm:

    Enhancement(s) for next version: ability to restrict random verse selection to specific book? chapter? keyword? phrase?
    Could prove to be helpful or come in handy for some of these topics...
    
    (hey, I'm just trying to help you re-hone your macro-writing skills! ;-))
34. By FFSteve. Comment posted 21-Feb-2006 @10:52pm:

    Wow,
    I just learned more about the bible than all the times I went to Church as a kid. I was trying out your word count and found out Jesus was a late edition to the Bible. He didn't show up until Matthew. Oh, I see he is only part of the new testament. Is that the difference between the new and old testament; after Jesus was born?
35. By . Comment posted 22-Feb-2006 @12:30am:

    Yes, that's the difference.
36. By . Comment posted 22-Feb-2006 @05:25am:

    You know I have never had a single one of you excel files work on OpenOffice. I wonder why?
    
    It's easy. The spreadsheet in Open Office is not perfectly compatible with Excel.
37. By Starwing. Comment posted 22-Feb-2006 @10:13am:

    Good work John,
    And if you want to calculate the numbers of words...
    In H5 you insert this formula:
    =COUNTA(INDIRECT("'"&C5;&"'!B2:B"&D5;))+SUMPRODUCT(LEN(TRIM(INDIRECT("'"&C5;&"'!B2:B"&D5;)))-LEN(SUBSTITUTE(TRIM(INDIRECT("'"&C5;&"'!B2:B"&D5;));" ";"")))

Original content © 2009, John Walkenbach