Category: Uncategorized

  • How to do an easy Random Drawing using Excel

    How to do an easy Random Drawing using Excel

    Random-Drawing-Cover-Beartoons

    As I wrapped up the Christopher Hart Cartoon Faces Book Giveaway, I thought I share with my readers a tutorial on “How to do an easy Random Drawing using Excel.”  If ever you don’t want to print out entry chits and draw by hand, these five easy steps will make things less time consuming for you.

    STEP 1:

    Random-Drawing-Step-1-Beartoons

    • In Column A, type in or import all the names of the people who are part of the drawing.
    • In cell B1 type in the formula =RAND()   This will generate a random number in B1 between 0 and 1.
    • Copy the formula in B1 and paste it down the rest of the column so each name has a random number next to it.

    STEP 2:

    Random-Drawing-Step-2-Beartoons

    • In excel, hit CTRL-A (PC) or Highlight all the cells with data in it in Columns A and B.
    • Click on the DATA tab and then the SORT button.  This will pull up a new dialogue box.
    • Choose Sort by Column B and it doesn’t matter if you choose smallest to largest or largest to smallest.  Select OK.
    • What this does is the same thing as having physical entries that you mix up by hand.  You have randomly assigned each person a number and that number sorted mixes up all the entries.

    STEP 3:

    Random-Drawing-Step-3-Beartoons

    • Go to www.random.org/integers/
    • Since I want to have only one winner I put “1” where it says “Generate X random integers”
    • Value set is 1 to 37 because I have a total of 37 rows.  If I had a header in row one such as “NAME” and “RANDOM NUMBER” this would have pushed my data from rows 1-37 to rows 2-38.  So be sure to only include the rows of the data and not the headers.
    • Select Get Numbers.

    STEP 4:

    Random-Drawing-Step-4-Beartoons

    • Your number has been generated and the results show up here.  In my case the result was number 25.

    STEP 5:

    Random-Drawing-Step-5-Beartoons

    • Return to excel and scroll down to the 25th row.
    • That is your winner.

    Hope this helps as you do drawings on your own.  Please let me know if you have any questions.

     

     

  • Urine Mouthwash

    Urine Mouthwash

    Bearman Cartoons Urine Mouthwash in Ancient Rome

    Yes friends urine luck, as I tell you the history of Urine Mouthwash.  Well back before the days of Listerine and Scope, people needed something powerful enough to cure the breath of a dragon.  Already used as a way to clean laundry someone must have said, “If it cleans my sheets, it has to do wonders on my teeth and breath”.

    But Ancient Romans being Romans didn’t just want their own fluids.  No they wanted to import the stuff from as far away as Portugal.  In fact it became such a profitable and popular item that Nero did what all governments like to do….he taxed it.

    I am sure you can find practitioners of the practice today still but I wasn’t adding that to my research.  You can find out for yourself.  haha

  • Australian Taxi Cab Drivers

    Bearman Cartoons Australian Cab Drivers and Apple MapsToday’s cartoon is an ode to the wonderful men and women who drive the taxis all around Australia.  I am sure most of them are very competent.  So why the heck did you send the others to us?  It was if someone had installed Apple Maps (notorious for getting people lost) in their brains.   We walked most of the time but in our trip we probably took 6 cab rides.  Here were the facts:

    • 4 out of 6 drivers had no idea where we were asking them to go (even with cross streets mentioned)
    • 3 of those 4 even had GPS
    • Only one tried to use it unsuccessfully
    • 3 of the 4 lost drivers were in Sydney

    And it wasn’t as if we were going to some obscure place.   But in Sydney, where we had most of the issues, it wasn’t limited to cab drivers.   Walking one day without my map, I got a little disoriented on Sydneys spoke and wheel system of streets.  I asked a cop how to get back to my hotel.  He pointed in a direction that I knew was wrong even when I told him what street it was on.

    Actual Cab Conversation:

    Us:  We would like to go to Nick’s Seafood

    Driver: (blank stare)

    Us: In Cockle Bay Wharf?

    Driver: (bigger blank stare)

    Us:  Darling Harbour??

    Driver: (puzzled look)

    Us:  Here on the map!

    Driver: OK

    Us (after many minutes of driving): I think you are on the wrong side of the Bay.   The restaurant is on the other side

    Driver finally uses GPS.  Puts in a restaurant none of us ever mentioned and started off.

    Us: That isn’t the restaurant.  And I think we are driving in a big circle.

    Finally the driver stopped about 1/4 mile from where we were going and pretty much gave up.  Thankfully we were only charged half the meter rate.

    Now to be fare, all of our tour bus drivers and the drivers as part of our transfer shuttles never got lost for a minute.  This actually was the opposite of our experience in London several years ago.  The cab drivers knew every little pub and alley everywhere.  The guy who brought us from the airport got lost.

     

  • Editorial Cartoon: Mad Libs Creator Dies

    Editorial Cartoon: Mad Libs Creator Leonard Stern Dies

    Today’s editorial cartoon is a salute to one Leonard Stern, creator of the world famous Mad Libs, who passed away last week.  For anyone that grew up in the 70’s and 80’s, it was because of Leonard that long family car trips were bearable (and allowed my father not to have to “pull over this car” because we were acting up again).

    Mad Libs led the way for those activity books with the orange pen that the answer appeared when you colored in the book.  I can’t remember what they called them.

    So I created a Mad Lib of my own below.  Fill in the words and hit “Go Mad”, then copy and paste your story in the comments section.

    Mad:)Glibs - free online Mad Libs
    A Bloggers Tale
     

    VERB ENDING IN -ING
    NOUN
    VERB ENDING IN -ING
    TYPE OF BUILDING
    VERB PAST TENSE
    NOUN
    NAME OF A CITY

  • Bearman Cartoon: Bristol Palin’s Speaking Fees

    Bearman Cartoon on Bristol Palin and her Speaking Engagements

    I am a firm believer in allowing private family members of public figures to be removed from public scrutiny.  That is UNTIL they themselves decide to become a public figure.   It was announced last week that Bristol Palin (daughter of former Vice Presidential candidate Sarah Palin) is going on the speakers tour to talk about “don’t screw up and have a kid like I did as a teenager”. 

    Reports are that she will get between $15-30,000 per speech.  That really busts my chops.  Why weren’t my parents more popular?  My life could be so much easier.

    This is the last week of the Charity Challenge. Click link for how you can help at no cost to you.

  • Google Reader

    So in my quest to revamp my life, I started using Google Reader last week.  That way I don’t have to click on each and every one of my blog roll links to see if you have updated your site.  It has been a real time saver and probably delayed the inevitable carpal tunnel.

    Anyone else use it?

    If so I have two questions:

    1.  I have subscribed to others but with an RSS feed how do I determine  how many people (and better which people) have subscribed to me?

    2.  I know you can separately subscribe to someones comments separate than the post, but is there a way to set up google reader so I see the post and the comments all together?

    Inquirering minds want to know.

  • Pixar/Disneys UP web short

    Personally I think UP should be considered for as a Best Picture nominee for this year. To promote the DVD release, someone at Disney did a very non-Disney looking web animation. When Shady Oaks drivers, George and AJ, come to pick up the old man, he flew his entire house away using helium balloons.

    Here’s what happened next….


    Hat tip to Drawn

  • Bearman Cartoon: PAYing Respects

    As the masses gather at the Staples Center in Los Angeles to pay their final respects to Michael Jackson, I couldn’t help but think about what typically happens there. While I know there are going to be those outside trying to cash in on the MJ lovers, I wondered if inside the Staples Center it would be business as usual with concession stands open and them selling official programs. Sad state of affairs if so.

    This was the background of the latest editorial cartoon.

    7 7 09 Bearman Cartoon Michael Jackson Staple copy

    Follow me via TWITTER updates. or you can…


    Tweet This Blog Post!    Add to Digg

    Add to FacebookAdd to DiggAdd to Del.icio.usAdd to StumbleuponAdd to RedditAdd to BlinklistAdd to TwitterAdd to TechnoratiAdd to FurlAdd to Newsvine

  • Hello world!

    Welcome to my own little world on the internet.  I am a self proclaimed hack cartoonist.  Sometime my gags are better than my drawing and sometimes my drawing is better than my gags.

    I plan on using this blog mainly as a repository for the editorial cartoons I create for The Cincinnati Beacon (www.cincinnatibeacon.com) along with my Flickr account.  I will periodically update the site with things that strike me as funny/interesting as well.

    Click on the Flickr link on the right to see some of the editorial cartoons, I have done in the past 2 years.

    Let me know if you link to this site and I’ll reciprocate (assuming I like what you have to say)