Maria’s Guides

Keep track of the latest content on the companion Web site for Mac OS X: Visual QuickStart Guide.

If you want to keep track of what’s new on my Mac OS X VQS book’s companion Web site but can’t remember to stop in regularly and don’t want to subscribe to the RSS feed, let this widget keep track for you.

Simply install the widget on your Mac and open it on your Dashboard. From that point on, each time you open the Dashboard (while connected to the Internet), the widget is automatically refreshed and will display a list of the most recent articles. See an article title that interests you? Click it to open the corresponding page in your Web browser.

You can also click links to:

• Learn more about the book on Peachpit Press’s Web site
• Buy the book at a discount from Amazon.com
• Visit my personal site and blog

And clicking the book cover in the image takes you to the book’s companion Web site.

Download

You can download the most recent version of the widget here:

Download Mac OS VQS Widget 0.1

Installation Instructions

1. If necessary, double-click the downloaded ZIP file icon to extract its contents.
2. Double-click the MacOSVQS.wdgt file icon.
3. When prompted to install the widget, click Yes.
4. When prompted to keep the widget, click Keep.

For best results, keep the widget open on your Dashboard. Then checking for new content is as easy as opening the Dashboard.

Version History

March 28, 2007
Version 0.1
First version of this widget.

Feedback?

Use the Comments link for this post to let me know what you think about this. It’s my first widget effort and I’d love to get some feedback. (Be gentle with me, please.)

You can also use the Comments link to ask questions about the widget. I will provide all support for it on this post.

• How To Run AppleTV on a Mac mini
  From the MAKE Magazine blog.
  (tags: apple hacks howto Mac MAKE TV AppleTV hack)
• Browser Wars Poll
  Browser Wars #8. What’s your favorite browser these days? A poll on MacOSXHints.com
  (tags: poll browser)

Use your Dashboard to keep track of new content.

The idea has been brewing for a long while. After all, there are a ton of widgets out there that seem to monitor just one RSS feed. Why not cook up one to monitor my feed? So I can offer another way for Mac users to keep track of new content on the Mac OS X: Visual QuickStart Guide book companion Web site?

I did some research. Apple’s Web site has a lot of good reference material for creating widgets. And it’s not as tough as you might think. These documents are extremely helpful:

• Developing Dashboard Widgets
• Dashboard Tutorial
• Dashboard Tutorial (980K PDF)
• Dashboard Sample Code

But what was most helpful to me was the article I found on Make Magazine’s Web site: “Make an RSS Widget” by Jake McKenzie. It concentrates on the kind of widget I wanted to create.

After fiddling around a bit with his code, I had a workable version of my very own widget: MacOSVQS 0.1.

The widget is pretty simple. It presents clickable links with the titles of the most recent posts on the Mac OS VQS Companion Web site I maintain to support my Mac OS books. That site has articles of interest to Mac OS users, as well as information about software updates for Mac OS.

Of course, since this is my very first widget and my knowledge of CSS and JavaScript are limited, I have no idea what some of the code does. I need to go through it and understand it to make more modifications. Now it just looks like Jake’s widget with different window dressing and different content — although I did manage to change the dimensions of the widget to make room for my bigger title area.

I’ll be updating the widget periodically, so keep checking in. You can always download the latest version of the widget from this site.

Comments? I’d love to read them. Use the Comments link for this post.

A how-to for Excel users.

My Visual QuickStart Guide books for Excel — from the edition for Excel 95 for Windows through the edition for Excel X for Macintosh — have always included an Excel function reference. In an effort to make pages available for other content, however, we’ve cut that appendix from the Excel 2007 edition of the book. I don’t feel badly about the cut, since this information is readily available in Excel Help and on the Web.

Here’s how you can find a function reference for your version of Excel and print it for your own hard-copy reference guide.

In Excel 2007 for Windows

1. Click the Help button in the upper-right corner of the Excel window to display the Excel Help window.
2. Enter function list in the search box and press Enter.
3. Among the search results that appear, you should see an item titled “List of worksheet functions (by category).” Click its link.
   
4. A help document titled “List of worksheet functions (by category) appears in the help window. It includes a complete list with brief descriptions of all Excel 2007 functions. You can read through this document and click links within it to learn more about specific functions.
   
5. To print the reference sheet, click the Print button in the Excel Help window’s toolbar. Use the Print dialog that appears to set printing options and click the Print button.

Note that you may need a connection to the Internet to access the Function List from within Excel Help. And remember that you can always resize the Excel Help window to better read what’s inside it.

Get this Information Online

This reference information is also available online for some versions of Excel. Click this one of these links:

• Excel 2007 List of Worksheet Functions (by category) - Microsoft has added dozens of new functions to Excel 2007.
• Excel 2003 List of Worksheet functions (by category) - These functions also apply to Excel 2000 (for Windows), Excel 2001 (for Macintosh), Excel 2002 (for Windows), Excel X (for Macintosh), and Excel 2004 (for Macintosh).

These pages contain clickable links to details about specific functions. They can also be printed from within your Web browser; use the Print command.

A Mac OS X Widget to track AdSense Revenue.

One of the things that bugs me about AdSense is that checking my AdSense reports is a multistep process:

1. Launch my Web browser.
2. Go to the AdSense home page.
3. Enter login information. (My browser won’t remember it because I have an AdSense account and an AdWords account.)
4. Click to log in.
5. Select the report period.

Okay, so that’t not so much work. But wouldn’t it be nicer to just press a key and have yesterday’s, today’s, and the current month’s AdSense Revenue magically appear?

That’s basically what the RevenuSense widget does. Once installed and configured with your AdSense account’s e-mail address and password, it automatically queries Google for basic revenue information. Just leave the widget open on your Dashboard and press F12. The AdSense revenue information appears with all your other open widgets.

Additional configuration options include update frequency and currency conversions, so you can fine-tune how the display works.

I think this is a great tool for any Mac user with an AdSense account — especially bloggers, who often depend on AdSense revenue to pay for their blogging habits.

From Miraz, not me.

Miraz Jordan, my co-author on WordPress 2: Visual QuickStart Guide, has taken the plunge and bought an Apple TV. She writes a little about her experience here.

Do any of you have an Apple TV? Please use the Comments link to share your thoughts.

As for me — there isn’t an Apple TV in my future. I don’t watch enough television to make it worthwhile.