Thursday, May 26, 2016

First post revisited - Google Sheets

This post is a repost of my first blog entry about Google Sheets.

I didn't realize until today that I have been working on this blog for 5 years.

January 31, 2011

On January 31, 2011 I published my first post this blog:

Excel is the spreadsheet application included in the Microsoft Office suite of programs (which includes Word, PowerPoint, and other applications. It was originally released for Mac in 1985 and for Windows in 1987.

Google Docs is comparable to Microsoft Office – except that it is an online application. Docs has applications for documents, spreadsheets, presentations, drawings, and forms. Google Spreadsheet is not quite as full-featured as a software-based application, but still has a large collection of functions and basic charting capabilities. By the way, did I mention that it is FREE?

May 26, 2016

An interesting phenomenon of blogs is that a certain percentage of information changes over time. Sites may no longer work, information may be outdated, or readers may be interested in different topics. However, in the case of Google Sheets, although the app itself has continually improved through the work of Google, the app is still applicable to us today.

I utilize Sheets everyday to track my writing progress. I recently wrote about how to create a Google Form, and the data from the form is transferred to a Sheets file. Although I still use Excel as the main repository for my writing progress (because of the ability to create charts and better data handling) Google Forms and Sheets have helped me improve my process.

Tuesday, May 24, 2016

Another Set of Mental Jogging Prompts

More brainstorming prompts from the book Mental Jogging by Reid J. Daitzman.

In previous posts I reviewed the book Mental Jogging by Reid J. Daitzman, and later share some more games from the book to stimulate the imagination.

Eleven Mental Jogging prompts

The  book consists of 365 prompts to stimulate your creativity. Below are ten prompts. These are great to think about while commuting and at parties.
  1. Six or more places never to put grass seed.
  2. Seven or more reasons not to smell a rose.
  3. Seven or more things to think about while descending on a parachute.
  4. Six or more ways to produce electricity.
  5. Seven or more day dreams everybody has. (Possible answers below.)
  6. Seven or more important news events of your parents' lifetime.
  7. Eight or more non-sport uses of a football.
  8. Six or more college majors that least interest(ed) you.
  9. Eight or more routes from New Orleans, Louisiana to Mexico City, Mexico
  10. Nine or more uses of dust.
  11. Seven or more uses of bamboo.

Possible answers for Seven or more day dreams everybody has: The book lists 75 possible answers for this prompt.
  • 1. Getting into first choice of colleges.
  • 11. Being valuable.
  • 21. Becoming involved in a grandiose scandal.
  • 31. Having a famous face.
  • 41. Lavish clothes in abundance.
  • 51. Real jewels for every occasion.
  • 61. Printing your own money.
  • 71. Being able to fly.

Mental Calesthenics
Mental Jogging also includes twelve mental calisthenics (one for each month) that are more complex mental tasks.  The one below is from February.
Sit in a comfortable position in an area of distractions and noises. Take three deep breaths and exhale through your nostrils. Close your eyes and image a BLACK SQUARE, BLACK RECTANGLE,  BLACK CIRCLE, BLACK OVAL, and BLACK RECTANGLE. Repeat the exercise, this time make the shapes another color of your choice. Arrange the BLACK shapes alphabetically, from left to right. Make them disappear one at a time. Open your eyes. 

Note: don't close your eyes if driving.

If you are looking for ways to increase your speed of thinking or the volume of ideas as solutions or creative approaches, I encourage to buy Mental Jogging and try some of these exercises. 

Sunday, May 22, 2016

Best Seller in a Weekend - Webinar Review

Best Seller in a Weekend is the business of Alicia Dunams. This post is a review of a webinar I attended.

Alicia Dunams

The best description of Alicia's business is from her own website:
Alicia Dunams motivates thousands of entrepreneurs around the world to play big to produce the business results and life they want. She’s coached hundreds of entrepreneurs worldwide to write, publish and market their book during her acclaimed live Bestseller in a Weekend program.

I came across Alicia's website while searching for creating a book quickly. I signed up for her mailing list, and subsequently received an offer to attend a webinar: Best Seller in a Weekend. This type of service is targeted towards individuals who want to establish themselves as experts within their fields by writing a non-fiction (how to) book.

Webinar Summary

You can view the full slick deck from the webinar via the SlideShare presentation below.

These are the highlights from my notes
1. Amazon search results - how the algorithm works
  • How you publish (CreateSpace, Kindle, and Amazon's own publishing companies receive a high prioritization).
  • Higher sales translates into better ranking within a specific category.
  • The number of legitimate reviews for a book indicates interest in the book.
  • A book title (and subtitle) based on specific keywords enhances visibility.

2. Alicia's basic process
  • Identify 6 concepts related to the topic.
  • Develop 20 questions for each concept (a total of 120 questions)
  • Get a friend to ask you these questions while recording.
  • Transcribe the recorded question and answer session.
  • The resulting transcript forms the bulk of content for the book. Two hours of recording roughly translates into 20,000 words which is the equivalent of a 100-page book (5x8 dimensions).

3. Establish yourself as an expert
Use this template to establish yourself as an expert:
  • My name is ____.
  • I help ____ be/do/have (insert your target audience)
  • _____ (your expertise)
  • so that _____ (results).

You can use this same information to pitch your book:
  • My name is _____.
  • I'm the author of ____ (title)
  • which teaches how to
  • _____ (subtitle).

4. Create a title and subtitle
  • The title of the book should be a noun.
  • The subtitle of the book should be a verb.
  • The words "teaches (how to)" should silently connect the title and subtitle.
  • Example: Straight A Student (teaches how to) Get better grades today
  • Example (Actual book): Blog a book (teaches how to) Write, Publish, and Promote Your Work One Post at a Time

5. Establish bestseller status
A strategy to achieving bestseller status is to select a super niche category for your book. The next step is to use social media to coordinate the follow:
  • Set up a book-buy blitz where as many individuals as possible buy your book within a limited time (24 or 48 hours).
  • Enlist the help of friends, associates, and bloggers to help promote your book.
  • Arrange for bulk purchases through civic clubs and chamber of commerce groups.
  • Generate interest through pre-orders.
  • Key point: Start promoting while writing via social media (posts, tweets, photos).

Slideshare Presentation

Thursday, May 19, 2016

Hero's Journey

Hero's Journey Story Structure using The Tale of Peter Rabbit as an example.

 In 1949 Joseph Campbell published a book titled The Hero's Journey. In the book Campbell describes a parallel structure found in all myths that transcends time and culture. While this portion of the book is helpful as a story tool, the book is heavily influenced by the psychoanalytic theories of Sigmund Freud.

In the 1980s Christopher Vogler, a script consultant working for Walt Disney Pictures, published a memo in which he described the various structural elements of the the hero's journey, but without the psychoanalytic elements. Vogler later expanded the memo into The Writer's Journey: Mythic Structure for Writers.

The concept of the hero's journey is that every hero - the protagonist or main character of the story - goes through a variety of stages in a journey, starting with leaving home and concluding with returning home as a changed individual.

The steps of the journey

  • Ordinary world - the main character in the world as it was before the ensuing adventure began.
  • Call to adventure - The main character is presented with a problem, challenge, or adventure.
  • Refusing the call - The protagonist is reluctant to accept the call to adventure. People are naturally averse to change, and the character must decide to remain in the ordinary world or begin a journey of adventure.
  • Meeting with the mentor - Someone in the main character’s life is older and wiser. This mentor advises the character in the decision to leave the ordinary world, and often offers tools, wisdom, and strategies to the character.
  • Crossing the threshold - The main character fully enters the special world of the story. This is usually the beginning of action in a story. In a movie, crossing the threshold typically occurs after 30 minutes. Once the main character crosses into the special world, he cannot return easily to the ordinary word.
  • Tests, allies, and enemies - The main character encounters a series of tests in preparation for future battles and to build stamina - whether physical or emotional. The hero also meet allies who will assist as the story proceeds, but the hero also encounters a variety of enemies who assist the antagonist of the story.
  • Approach the inmost cave - The protagonist and allies enter what appears potentially to be the end of the story. It is a place of danger.
  • Central ordeal - This is the low point of the story, and it appears that all may be lost. Yet, the main character returns to life, physically or symbolically, and reinvigorates the hero.
  • Reward - Also referred to as “seizing the sword,” the hero now claims the reward he fought for in the previous steps. Often, a tool or strategy of some importance is obtained which will contribute to a success conclusion of the story.
  • Road back - Most antagonists do not want the protagonist to keep the reward and take action to thwart the success of the main character. The most dramatic and intense scenes of a story occur in this step.
  • Resurrection - All of the action during the road back culminate in a final scene of life or death. Either the protagonist will defeat the antagonist, or the opposite will occur.
  • Return with elixir - Having survived the final battle, the main character can now return to the ordinary world, but now with new experience, reward, or love interest.

The Tale of Peter Rabbit

As noted in previous posts, the Tale of Peter Rabbit is a simple story that clearly illustrates the various steps of story structure. For this post, Peter's tale is organized according to the elements of the hero's journey.

  • Ordinary world - Peter and his siblings lived with their mother in a sandbank underneath the root of a very big fir tree.
  • Call to adventure - Mrs. Rabbit said, "Run along and don't get into any mischief." In this situation, Peter call to adventure is the mischief of which his mother admonished her rabbits to avoid.
  • Refusal of the call - Peter's siblings obeyed, but Peter was "naughty."
  • Meeting with the mentor - Mrs. Rabbit further warned the warren: "Don't go into Mr. McGregor's garden; your father had an accident there and was put in a pie by Mrs. McGregor." In this story, Mrs. Rabbit serves as the role of mentor by providing a specific and meaningful consequence of visiting the garden.
  • Crossing the threshold - Peter went directly to the garden.
  • Test, Allies, and Enemies - Peter encountered Mr. McGregory - his archenemy. Peter ran away, but couldn't find the way out. In the course of his adventure he was encouraged by the sparrows.
  • Approach the inmost cave - Peter was closer to getting caught as he ran away from Mr. McGregor.
  • Central Ordeal - Peter was even closer to getting caught with seemingly no way out and hid in a watering can. He  drew attention to himself by sneezing.
  • Reward - Peter slipped through the window, narrowly escaping.
  • Road Back - While still wandering around in the garden, Peter finally spotted the gate, although the path was obstructed by Mr. McGregor.
  • Resurrection - Peter ran for his life towards the gate. He squeezed under it and was out of danger.
  • Return with Elixir - Peter made it safely home. The elixir was knowledge gained from his experience. In a later story Peter's cousin Benjamin Bunny wanted to visit the garden, but Peter was very resistant.

I like the hero's journey model. It has more structure than the three-act structure, but a manageable number of steps.

Tuesday, May 17, 2016

Dale Carnegie's Secrets of Success

The link in this post displays a list of tips from How to Win Friends & Influence People and How to Stop Worrying & Start Living.

I recently reviewed How to Stop Worrying & Start Living by Dale Carnegie. In an earlier post on paradigm changing books, I included How to Win Friends & Influence People.

Today's post features a link to a PDF document on the Dale Carnegie corporate website. The PDF contains all of the tips from both books.

The categories of tips are:
  • Become a friendlier person
  • Win people to your way of thinking
  • Be a leader
  • Fundamental principles for overcoming worry
  • Basic techniques in analyzing worry
  • Break the worry habit before it breaks you
  • Cultivate a mental attitude that will bring you peace and happiness
  • The perfect way to conquer worry
  • Don't worry about criticism
  • Prevent fatigue and worry and keep your energy and spirits high

Link to Secrets of Success

You can download the PDF and print the pages. If you don't have have to read the books - which are excellent and should be read by all - at least familiarize yourself with these essential points.

Thursday, May 12, 2016

Presentation Rehab Tip 6 - Arrive Early

When presenting, arrive early to setup, test connections, and make sure everything is ready.

I have attended a variety of professional concert events including the rock group KISS, contemporary Christian artist Amy Grant, the legendary island man Jimmy Buffet, Seventies crooner Neil Diamond, and numerous classical concerts. For all of these events and many others, I never saw the band or orchestra doing a sound check while we were trying to find our seats. Instead of waiting until just before show time to make final tweaks and adjustments, professional musicians have learned that it is more beneficial to arrive early before the audience arrives.

You, as a presenter, can apply the same practice to your presentation. A number of technical gremlins can cause delays and problems. Being present early enough to check and correct audio, visual, and computer connections will mean you are ready to present when your audience arrives. Additionally, by working through the technical and setup details in advance, you can utilize the time just before your presentation to find a place to mentally prepare or spend time speaking with audience members.

Beyond the preparation to ensure that all of the logistics, presentation slides, and technical adjustments have been made, it simply looks professional to be prepared and ready. In Britain, at least when I was a there as a child, the trains run on time. If a train is scheduled to leave at 8:03AM, you'd better be on the train by 8:02AM or you may miss it. This is sensible as there is a network of trains waiting to move in to the station and there are other trains people have to transfer to along the way.

As much as possible, I try to start presentations or conference calls on time – i.e., at the announced start time. Will some people be late? Yes. But some will be there early. It is professional to start on time. The likelihood of this occurring is enhanced when you arrive early enough to test your presentation, Internet connections, and other logistics.

Tuesday, May 10, 2016

App Review for Writing on Your Phone

This post review different apps for writing on the iPhone. Apps discussed are Notes, Microsoft Word, Apple Pages, and Google Docs.

Recently I came across an e-book written by Andrew Mayne, a television personality and author.  In How to Write a Novella in 24 Hours, Mayne offers general writing advice on a several different topics. In one of the chapters, Mayne discussed how he uses his smart phone to write.

Writing Tools

Prior to the advent of computers there were really three ways to produce words that would eventually result in a book. If you had a generous budget you could dictate your writing and pay someone to transcribe it. If you were lucky enough to have a typewriter, you could type your pages. Finally, if you didn't have a budget or a typewriter, you could simply write words on paper. Computers have largely eliminated these problems, but still have one characteristic in common: you still need to carry a tool with you.

This is often my situation. Sometimes I write using my laptop and sometimes using my iPad with Bluetooth keyboard. However, after reading Mayne's article, I decided to experiment with typing on my phone.

The advantage of using phone to create content is that it is immediately available all the time. Who is without a phone for too long? You can now write a few sentences when waiting in line. You can write between other activities. With a dictation feature, you can even dictate a few sentences into the writing app of your choice.


For my Writing 365 project, where I am writing 1,000 words per day during 2016, I have been using Microsoft Word for Mac and Apple Pages for iPad and Mac. At the same time, I have used Google Docs to create outlines for various documents.

Since I already have the apps for Word, Pages, and Docs on my iPhone, I decided to determine which would be best. I decided to use the classic speech, The Gettysburg Address, by Abraham Lincoln.

Microsoft Word for iOS

I first opened Word for iPhone, pasted the text of the speech and viewed the result. The default when both creating documents and opening existing documents is to display the text as a full page, and you have to scroll to view full paragraphs. There is a button to toggle between page view and text view, but because the default is the page view, this requires an extra step. The Word app also requires a Microsoft account to edit documents.

Apple Pages for iOS

Apple Pages provides the same basic app across platforms. While there is considerable additional functionality on the Mac, the iOS versions are still fairly powerful. Pages works well on the iPad, but has the same problem as Word on the iPhone. Unlike Word, I could not find a toggle button to switch between text and page views.

Google Docs

Google Docs defaults to the text view, with a toggle button to switch to page view. This is perfect for the iPhone. Since all three apps provide for basic formatting, including paragraph styles, Google Docs provides the best scenario: text view which is perfect for iPhone and basic formatting capabilities.


Notes provides basic text entry, but only offers limited style or formatting options (apparently with no way to modify the styles).