Archives by Month

Support this Site!

You may have noticed that there's very little third-party advertising on this site. I'd like to keep it that way. Here's how you can help:

  • Buy my books. They're available at great prices on Amazon.com.
  • Check out my training videos on Lynda.com. It's a great source for "all you can eat" training.
  • Donate a few dollars. It'll help cover my hosting costs and give you a chance to tell me what you want to see covered here.
  • Comment on blog posts. You can help get a discussion going that can benefit others, making the site more valuable for everyone.
July 1st, 2010

Welcome to Maria's Guides!

Welcome to Maria’s Guides, a blog-based Web site built and maintained to offer support and additional material to readers and viewers of published work by Maria Langer.

The topics you’ll see covered here include Mac OS, Microsoft Office products, blogging tools such as WordPress, and social networking services such as Twitter and Facebook.

There’s a lot of material here — content has been archived since 2004. You can access all content through navigation bar links:

  • The horizontal navigation bar near the top of the page links to information about Maria’s recently published work.
  • The vertical navigation bar links to articles about specific topics. These articles are in reverse chronological order with the most recently posted at the top.

You can also use the Search box to search for specific information.

Your comments are always welcome. Use the comments link for any page or post to comment about its contents.

July 28th, 2010

Creating a Time-Lapse Calculator with Excel

A quick way to perform movie-making calculations.

One of my hobbies is photography and I dabble occasionally with time-lapse. In time-lapse photography, you set up a camera on a tripod to take a photo at a set interval, like every 15 seconds, over a long period of time, like hours. When you’re finished, you take the resulting images and compile them into a movie using each photo as a movie frame. The length of your movie is dependent on the number of shots and the number of frames per second (fps) at which they are compiled.

I wanted to be able to easily calculate various values for a time-lapse movie project based on certain values I provide, which I call “assumptions.” For example, how many seconds between shots if I want 1200 shots over 3-1/2 hours? How long would a movie be if I took shots over 10 hours with 15 seconds between shots and compiled them at 30 fps?

This is basic math, but with a twist. I wanted to be able to solve for any one of three source photo values given the other two values:

  • Time period, in hours
  • Seconds between shots
  • Number of shots

Given that information, I also wanted to be able to solve for either of two resulting movie values:

  • Frames per second
  • Movie length, in seconds

Time-Lapse CalculatorThe resulting Time-Lapse Calculator shown here does the job.

The formulas I put in the green cells are shown below. The IF function tests to see if cells are empty and uses the test result to determine whether it needs to perform and display a calculation. For example, in cell D6, it checks to see if B6 is empty; if it is, it calculates the result based on B7 and B8. Because the last two formulas require data from either cell B8 or D8, they also test to see which one contains data. The result is a nestled IF statement.


D6=IF(B6="",B8*B7/60/60,"")
D7=IF(B7="",60/(B8/B6/60),"")
D8=IF(B8="",B6*60*60/B7,"")

D11=IF(B11="",IF(B8<>"",B8,D8)/B12,"")
D12=IF(B12="",IF(B8<>"",B8,D8)/B11,"")

You can download a password-protected copy of the worksheet here. (The password is not available for distribution.)

After completing this worksheet and beginning to write about it, I realized that it’s not everything I envisioned. What I really wanted was to calculate one of the following based on the other three:

  • Time period, in hours
  • Seconds between shots
  • Frames per second
  • Movie length, in seconds

I’ll likely work on this in the future. If I finish it, it’ll appear here on Maria’s Guides.

Want to learn more about Excel?

Check out my most recent Excel books and video training materials:

And be sure to use the Excel link in the sidebar to track down other Excel articles like this one on Maria’s Guides.

July 28th, 2010

Safari 5.0.1 Now Available

Information from Software Update.

New in this update:

  • Safari Extensions
  • Customize Safari with features created by third-party developers
  • Find extensions in the Safari Extensions Gallery, accessible from the Safari menu and extensions.apple.com

This update also contains improvements to stability, accessibility and security, including the following:

  • More accurate Top Hit results in the Address Field
  • More accurate timing for CSS animations
  • Better stability when using the Safari Reader keyboard shortcut
  • Better stability when scrolling through MobileMe Mail
  • Fixes display of multipage articles from www.rollingstone.com in Safari Reader
  • Fixes an issue that prevented Google Wave and other websites using JavaScript encryption libraries from working correctly on 32-bit systems
  • Fixes an issue that prevented Safari from launching on Leopard systems with network home directories
  • Fixes an issue that could cause borders on YouTube thumbnails to disappear when hovering over the thumbnail image
  • Fixes an issue that could cause Flash content to overlap with other content on www.facebook.com, www.crateandbarrel.com, and other sites when using Flash 10.1
  • Fixes an issue that prevented boarding passes from www.aa.com from printing correctly
  • Fixes an issue that could cause DNS prefetching requests to overburden certain routers
  • Fixes an issue that could cause VoiceOver to misidentify elements of webpages

For detailed information on the security content of this update, visit http://support.apple.com/kb/HT1222

July 18th, 2010

How to Hide Farmville (and other Annoying Games) from Your Facebook News Feed

This should make Facebook a little more bearable for people who use it for business.

I just got back on Facebook. It was a tough decision. What helped make it tolerable to go back to Facebook was my discovery that I could hide posts related to Farmville, Mafia Wars, and other time-sucking games I really couldn’t care less about.

It’s easy:

  1. In your News Feed window, when you see a post about a game you don’t care about, point to it. A Hide button appears.
    Hide Button
  2. Click Hide.
  3. The item disappears and is replaced with a series of buttons like the ones shown here. Click the button to hide the game.
    Click Hide
  4. A note like the one shown here appears. Ignore it and it will go away.
    It's Gone

From that point on, you won’t get any posts related to that game.

June 23rd, 2010

iTunes 9.2 Now Available

Information from Software Update.

iTunes 9.2 comes with several new features and improvements, including:

  • Sync with iPhone 4 to enjoy your favorite music, movies, TV shows, books and more on-the-go
  • Sync and read books with iPhone or iPod touch with iOS 4 and iBooks 1.1
  • Organize and sync PDF documents as books. Read PDFs with iBooks 1.1 on iPad and any iPhone or iPod touch with iOS 4
  • Organize your apps on your iOS 4 home screens into folders using iTunes
  • Faster back-ups while syncing an iPhone or iPod touch with iOS 4
  • Album artwork improvements make artwork appear more quickly when exploring your library

For information on the security content of this update, visit: http://support.apple.com/kb/HT1222

June 21st, 2010

Five Retweet Abuses

Sure, it’s easy to retweet someone else’s tweet. But are you overdoing it?

Twitter logoI’ve been on twitter for more than three years now and have sent more than 22,000 tweets into the Twitterverse. These are a mix of the usual inane comments, bits of wisdom, meal reports, witty remarks (or my attempts at witty remarks), links to interesting content, and retweets of other people’s tweets.

It’s the retweeting habit of Twitter users that I want to address here.

A retweet, in case you’re not familiar with the term, is a tweet that someone else wrote that is echoed to the Twitterverse. Retweets come in two flavors:

  • Old-style retweets include the letters RT or via followed by the originator’s Twitter name. For example:
    Old Style RT
    or
    Old-style Retweet
  • Official Twitter retweets appear to come from the originator, but they were retweeted by someone you follow. Thus, they wind up in your timeline from the account of the originator, even if you don’t follow that person. Here’s an example:
    Retweet

I could go into a lecture on which method is better (official retweet, in case you’re wondering), but I’ll save that for another post. Right now, I’m more concerned with how much people retweet and what they are retweeting.

This is where I get into some hot water with some Twitter friends. You see, what prompted this post was the complete retweet abuse I’m seeing on Twitter among a handful of people I follow. I don’t mean to point fingers, so I won’t mention any Twitter names. But if you’re one of the people repeatedly committing one of the following abuses, you know who you are.

  • Retweeting more than you tweet. If you consistently retweet other people’s content more than you create your own original tweets, take a moment to consider why you are on Twitter. Is it your purpose to simply echo the words and links of the people you follow? There are Twitter bots that can do that automatically and they’re only slightly more annoying. Why should anyone follow you if nearly everything you tweet has its source elsewhere? (And if the rest of your tweets are from Foursquare, do yourself a favor and just drop out of Twitter now, before someone has to kill you.)
  • Retweeting content that just isn’t interesting to the majority of your followers — or many people on the planet. You may think the latest Latin language release of the Open Source project, thingamabobwhatchamacallit widget plugin, is the most fascinating thing on the planet. But do you really think your followers agree? And if they did, don’t you think they’d be actively following the same sources of information about that project that you are? Retweeting stuff that few people care about only raises the noise to signal ratio on Twitter. And who likes noise? A corollary to this is retweeting local area content when you have only a few local followers. Your 724 non-local followers don’t really care that the corner antique clothing store is having a big sale on Tuesday. Or that your next door neighbor’s cat has gone missing. Or that there’s a fire/flood/tornado/locust warning for your county. If we wanted local area information on Twitter, we’d follow the same kinds of local information sources you follow — but for our areas.
  • Retweeting other people’s references to your Twitter account. Okay, so @yourbiggestfan tickled your fancy by tweeting about how much he liked your latest book/blog post/tweet/haircut. Do you know how dorky and self-centered you look by retweeting his gushy tweet? Isn’t Twitter narcissistic enough by giving you an opportunity to brag about yourself? Do you really think it’s necessary to retweet the nice things other people say about you, too? Ick.
  • Retweeting the tweets and retweets of others in a special interest group where everyone follows everyone else. This is especially annoying when you use the old fashioned RT or via method of retweeting. It means that everyone who follows everyone else has to read the same tweet six or seven times. Consider the world of Ninja Yoga Masters, which may only have 20 outspoken master members sharing the same few hundred followers. When each of the masters retweets a fellow master’s comment with an old-fashioned RT, we all have to read that comment again. And again. And again. Do you know how annoying that is? Especially when the retweets appear one after the other in our timelines? It’s like the retweeting crew is singing a chorus.
  • Retweeting improperly. Someone came up with some words of wisdom or a good one-liner or a link good enough for you to retweet. But instead of doing it properly by using the official Twitter retweet tool (which is now supported by just about all Twitter client software), you paraphrase to shorten or maybe leave out the source. Not very nice, is that? There’s no reason to incorrectly retweet someone else’s tweet. Click the damn Retweet link or button; Twitter does the rest for you, leaving the original in all its glory and properly crediting the source. This helps other people find and possibly follow that source if they find the retweeted content is interesting.

Now I’m not saying that my tweets are perfect. They’re not. There are too many of them to all be good. Indeed, I’ve committed all of these abuses at least once in the past 3+ years. But the growth of Twitter has made abuse like this unacceptable. It’s causing people like me to limit who they follow and to drop Twitter friends because of their annoying retweeting behavior.

What do you think about the retweeting situation on Twitter? Do you have any pet peeves I neglected to include in my list? Don’t be shy! Share them with us. Use the Comments link or form for this post to let us know.

And do me a favor: retweet this post to spread the word. Twitter would be a much better place without so many retweets.

Get more from your software.Want to Learn More about Using Twitter?
Learn online at Lynda.com. Recently revised and expanded, my Twitter course includes more than three hours of video training material that’ll help you get more out of Twitter. Check it out. If you’re not a Lynda.com subscriber, be sure to visit to try some of the free videos. I think you’ll be hooked.