Archive for May, 2010

How to Create and Publish a Dynamic Chart from Google Docs

Today I was experimenting with Google Docs and discovered something really cool that I want to share. I created the chart below titled “Cash Contributed to Partnership” from a simple spreadsheet. The chart is not a static image. The data in the chart is linked to the spreadsheet stored in my Google Docs account. When I change the numbers on the spreadsheet, the chart in this blog post updates automatically.

(disclaimer – the data in the chart is entirely fictional and any similarity to a real-life situtation is purely coincidental – also, this chart may not show in RSS feed readers, so please view this post on my blog website)

This is how I created and published the chart:

1.  I created a new spreadsheet in Google Docs, and entered the data shown below.

2. On the top menu, I clicked on insert, then gadget. In the finance category, I selected the “pile” chart that shows stacks of $100 bills of varying sizes based on the values in the spreadsheet.

3. The box you see below appeared. I selected the data range (which must include both the names and amounts) and entered a gadget title and chart header. Then, I clicked on the little arrow in the top right corner and clicked on Publish Gadget.

4. The box below then appeared with a script code that can be inserted into an HTML page. I copied the code below and pasted it into the top of this blog post.

I noticed that when I changed the values in the spreadsheet, it did not change the chart in my blog post immediately. Sometimes, it took a couple of minutes.

Do you have any questions or ideas to share? Please leave a comment below.

Why It Took Me Months to Start Blogging

First, let me describe my background in regards to web design so you know where I’m coming from. I built my first web page in the year 2000 using Yahoo Geocities’ WYSIWYG site builder.  It was simple.  I just typed out some text and dragged it where I wanted it, and put pictures where I wanted them on the page.  It was fun and sparked an interest to learn more about web design. Shortly after that, I took a web page design class in college.  The course almost entirely focused on html code.  I enjoyed the course and felt proud to finally be a sophisticated “hard coder” creating web pages with Notepad.  I created several websites by just writing html code and CSS, including the website for my company, a Las Vegas CPA Firm. However, I soon discovered that creating a website this way has its problems.  For example, changing a navigation bar for all pages in the website required me to cut and paste new code to all of the twenty-or-so html documents that comprised each page of the website. My eyes were opened to a better way of managing a website at the AICPA Technology Conference in June 2009.  One of the speakers demonstrated how he used a content management system (CMS) to pull content from other sources on the Internet and automatically create html code.  Another session of the conference was entirely about “blogging, podcasting, and social networking” which covered how a blog can benefit a professional.  I left the conference with the resolve that I wanted to learn to use a CMS and become a blogger! It was a long journey from June to November 2009, when I posted my first article on my blog.  Why did it take so long?  Consider that I did all of the following:
  1. I carefully observed several other CPA bloggers and picked out things I liked and didn’t like from their blogs.
  2. I researched several CMSs and blogging platforms, including Joomla, Drupal, Blogger, and WordPress.  I finally settled on using self-hosted WordPress so I could have total control over my blog and customize it as much as I like.
  3. I purchased my domain and web hosting after a few hours of researching several web hosting services.
  4. I installed WordPress on my web server.
  5. Among more than one thousand themes (or general designs) on the wordpress.org website, I had to choose my favorite.  I then had to further customize my design so my blog wouldn’t look exactly like other blogs using the same theme.
  6. I installed several plugins and widgets (programs for backup, security, and sections of my blog, such as the Twitter and Google Reader feeds on the right sidebar).
  7. I started an account with Feedburner to create an RSS feed.
  8. I opened an account with Google Analytics and configured it to work with my blog, which I have discovered to be a great resource to see statistics of the traffic to my site.
  9. I also opened an account with Google Webmaster Tools to observe how Google indexes my blog.
  10. I created an “about me” page and a disclaimer (every blog should have one!)
  11. At this point, I started writing blog posts.  Every blog post has to catch the reader’s attention, be informative, and be entertaining.  I wouldn’t write anything I wouldn’t want to read myself!  It’s not easy.
This might all sound overwhelming to someone who has never created a website.  If you’re in this category, I have some good news.  It doesn’t have to take months to start blogging.  In fact, I created a simple blog using Blogger and finished it in about an hour.   This blog (dustinwheelercpa.com) took me so long because I created it the hard way, and I’ve learned a lot in the process.

Five Useful RSS Feeds I Follow That Are Not News or Blogs

I previously wrote a blog post about how I have been using RSS feeds to stay current on the news.  The majority of the feeds that I subscribe to are news and blogs, but there are a few that don’t fall under either of these categories that I have found to be useful.
  1. Tweets of a few individuals. I follow about 200 people on Twitter and I can’t log in to Twitter enough times to keep up with every single tweet of the people I follow every day.  However, there are those among the Twitter users I follow who share great information and I don’t want to miss any of their tweets.  It’s easy to add a Twitter timeline to Google Reader (which I use to read RSS feeds).  Copy the Twitter user’s URL (for example, http://twitter.com/whe97007), click on the “add a subscription” button and paste the URL in the box that appears.
  2. Twitter searches for certain words and hashtags. Using Twitter Advanced Search, I created RSS feeds for tweets from Las Vegas, Nevada, that include the words CPA, accountant, tax, or QuickBooks.  I have found a few interesting people to follow and some potential business opportunities.  For example, a tweet saying “next year I think I’ll have to invest in a good tax accountant” caught my attention and I contacted that Twitter user.  The only drawback to subscribing to these feeds is that I have to sift through a lot of unimportant tweets like “I just got my tax refund so now I can buy that HDTV!”
  3. LinkedIn Network Updates. LinkedIn is a great site for professional networking, but I don’t visit it daily.  I use RSS as a more efficient way to see what my connections are up to.  Occasionally, I notice that one of my connections connects to someone I know, who I then connect to as well.  You can get RSS feeds within the LinkedIn account settings.
  4. Notifications for new downloads. For example, I subscribe to the RSS feed of the CPA Technology Advisor to know when a new podcast is available for download.
  5. YouTube channels. In particular, I enjoy the YouTube channel for K2 Enterprises, which provides technology tips for CPAs.  Thanks to RSS, I am alerted when a new video is available to view.
If you have any ideas for using RSS feeds, please share them by leaving a comment in the box below.