To take the hard work out of planning, we turned to Google Apps Script, which lets you write short programs that automatically perform simple actions within a spreadsheet. For example, our Movie Night script figures out which movies are playing close by and invites everyone to vote on what they’d most like to see.

Google Apps Script has been available to Google Apps customers since January, and today we’re excited to bring it to everyone who uses Google spreadsheets. Apps Script can be helpful for all kinds of things, from customized party invites to sending out holiday letters — in fact Apps Script can be especially helpful for those repetitive, time consuming tasks.

To help you find useful scripts, we’ve also launched a public gallery where you can check out our Movie Night script and browse other available scripts. If you’re feeling adventurous, try your hand at writing your own script and submit it to the gallery for others to use. To see the gallery or install a script in your spreadsheet, click on “Insert” and select “Script.”

Check out the Google Docs blog for more information about Apps Script, and to learn about writing your own scripts, visit the Google Apps Developer Blog.

Posted by Evin Levey, Product Manager, Google Apps

Possibly Related posts

• No related posts.

In Google Reader Play, items are presented one at a time, and each item is big and full-screen. After you’ve read an item, just click the next arrow to move to the next one, or click any item on the filmstrip below to fast-forward. Of course, you can click the title or image of any item to go to the original version. And since so much of the good stuff online is visual, we automatically enlarge images and auto-play videos full-screen.

Reader Play adapts to your tastes — as you browse, you can let us know which stuff you enjoy by clicking the “like” button, and we’ll use that info to show you more items we think you’ll like. If you want, you can also choose categories, and we’ll personalize your stream to only show you stuff from those categories. And you don’t even need a Google account to use Reader Play. Of course, if you want to star, like, or share items, we’ll ask you to sign in to your Google account. Since Reader and Reader Play share the same infrastructure, any actions you take in one will be reflected in the other.

You might be wondering where we find all the awesome stuff in Reader Play. It uses the same technology as the Recommended Items feed in Reader to identify and aggregate the most interesting items on the web. If you sign in, Reader Play will also be personalized with items that people you’re following have shared in Google Reader, and items similar to ones you’ve previously liked, starred, or shared.

Since Reader Play is an experiment, it’s launching in Google Labs for now. To be clear, Reader Play isn’t intended to replace Google Reader: both Google Reader and Reader Play are about finding and reading interesting stuff online. In essense, Reader Play is a different view of Reader. It’s designed to be a fun and easy way to browse interesting items, while Reader is a highly customizable way to organize your feeds, keep track of what you’ve read, and much more. In Reader, you can switch to this view by clicking “View in Reader Play” from the feed settings menu.

Try Reader Play today and let us know what you think. Send us feedback in our forum or on Twitter, and check out our help article for more info.

Possibly Related posts

• No related posts.

Well now that the good news is out, I can lift the curtain and explain the many factors and variables that we’ve had to take into account to put this whole feature together:

• Bike trails: Our maps contain over twelve thousand of miles of biking trails. First, we had to figure out where trails are, so we worked with the Rails-to-Trails Conservancy to get much of our trail data. Once we had trails mapped out, the next task was to incorporate them into our routing algorithm. The algorithm is weighted to strongly prefer routing on these trails rather than roads open to automobile traffic, so your directions will try to put you onto a trail as long as it won’t take you totally out of your way. On our bicycling layer (found under the ‘More’ button), these trails show up in dark green.

• Bike lanes: For more than 150 cities in the US, we know which streets have dedicated bicycle lanes. These are also prioritized when coming up with a routing suggestion. On the bicycling layer, you’ll see these roads indicated in bright green.

• Recommended routes: For many cities we also information on streets that have been designated as good for cyclists, so we them into account in our algorithm. These roads are indicated with dashed green lines on our bicycling layer.

• Uphill slopes: l don’t know anyone who enjoys biking up a hill, especially when you’re trying to get somewhere you need to be. Going uphill is worse than simply being much slower; it’s also exhausting and can take a toll on the rest of your ride. Our biking directions are based on a physical model of the amount of power your body has to exert given the slope of the road you’re biking on. Assuming typical values for mass and for wind resistance, we compute the effort you’ll require and the speed you’ll achieve while going uphill. We take this speed into account when determining the time estimate for your journey, and we also try hard to avoid routes that will require an unreasonable degree of exertion. Sometimes the model will determine that it’s far more efficient to make you ride several extra blocks than to have to deal with a massive hill. My teammates in San Francisco were relieved to see that this does indeed work!

• Downhill slopes: Many cyclists will tell you that going downhill is annoying for a different reason: you may have to ride your brakes all the way down. All else equal, we try to avoid routes that require a lot of braking. Of course, in some cities, including my hometown of Seattle, this isn’t always possible! And if you feel like you need a big workout and want to climb some hills, or if you just love that wind-in-your-hair feeling of a long downhill (you better be wearing a helmet and staying safe!), you can always turn on the terrain layer to check out the hilliness of an area for yourself.

• Busy roads: Cyclists often tend to prefer to stay off of fast roads, and not even cross them unless it’s necessary. This is roughly the inverse of driving directions, where you want to stay on arterials and freeways, so we had to rework a lot of those fundamental calculations when coming up with our biking directions algorithm.

• Busy intersections: We try to avoid making you cross busy streets with a lot of car traffic and long wait times.

Even having figured out how to account for all these variables and cost-estimates in our algorithm, the biking direction feature would not have been possible without our new base map data which allowed us the flexibility to easily incorporate bike trail data, a fundamental part of this feature. It also allowed us to readily incorporate feedback directly from our users, and we welcome all your feedback and suggestions via the “Report a problem” tool — after all, biking directions are still in beta and we’re continuing to work on adding more data about bike trails, bike lanes, and preferred roads. Both of these updates were made in October, at which time we promised that that biking directions were in the works, and now five months later: here they are!

Possibly Related posts

• No related posts.

We’ve found that when businesses begin to experience the benefits of cloud computing, they want more. We’re often asked when we’ll offer a wider variety of business applications — from accounting and project management to travel planning and human resources management. But we certainly can’t and won’t do it all, and there are hundreds of business applications for which we have no particular expertise.

In recent years, many talented software providers have embraced the cloud and delivered a diverse set of features capable of powering almost any business. But too often, customers who adopt applications from multiple vendors end up with a fractured experience, where each particular application exists in its own silo. Users are often forced to create and remember multiple passwords, cut and paste data between applications, and jump between multiple interfaces just to complete a simple task.

Today, we’re making it easier for these users and software providers to do business in the cloud with a new online store for integrated business applications. The Google Apps Marketplace allows Google Apps customers to easily discover, deploy and manage cloud applications that integrate with Google Apps. More than 50 companies are now selling applications across a range of businesses, including:

Possibly Related posts

• No related posts.

Today, we’re happy to announce three new features in Calendar Labs. To try them out, just go to the Labs tab under Calendar Settings.

1. Event flair by Dave Marmaros
Want a little airplane icon next to information about your upcoming flight? Or stars next to meetings with your boss? This experiment lets you choose from forty different icons and add one to each Calendar event. Even better, if you invite people to your events, they’ll be able to see the icon you added too. After you enable this feature, click on an event and look for the “Event flair” gadget to activate.

2. Gentle reminders by Sorin Mocanu
If you keep Google Calendar open all day long, you probably end up seeing quite a few reminders every day. Browser alerts are okay, but I tried to find a way for Calendar notifications to integrate smoothly with everything else.

Turn on “Gentle Reminders,” and when you get a notification, the title of your Calendar window or tab will start blinking and the event details will stay in Calendar.

If you’re using this lab in a supported browser (currently Google Chrome for Windows and Google Chrome beta for Linux), you’ll also have the option to get your reminders in the next generation of floating desktop notifications:

After you enable this feature, you can configure notification options on the Settings page.

3. Automatically declining events by Lucia Fedorova and Miguel García
Have you ever checked your calendar and noticed that someone scheduled a really important meeting during your vacation or at a time when you’re not available? Now there’s a way to automatically decline events when you’re not around. Turn on “Automatically declining events,” block off times when you’re unavailable, and event invitations during this period will get automatically declined.

Possibly Related posts

• No related posts.

Let me show you how the editing feature works.

When you find a place that is in a wrong location, click on the marker and get an infowindow open as what you did before.

Posted by Jie Shao, Software Engineer

Possibly Related posts

• No related posts.

My little sister recently setup her Gmail account to retrieve messages from her school address, so she can check all of her email accounts in one place. She no longer has to constantly log in to two email programs, and she likes using Gmail’s powerful interface for all her mail.

However, sometimes she knows an email has already been sent to her school address, and she just can’t wait for the next scheduled fetch to have it show up in her Gmail inbox. As any big brother would, I tried to solve this issue for her and millions of Gmail users.

Turn on “Refresh POP accounts” from the Labs tab under Settings, and the refresh link at the top of your inbox will not only update your inbox with your new Gmail messages, it will also fetch messages from any other accounts which you have set up.

Try it out, and let us know if you have any feedback.

Possibly Related posts

• No related posts.

Head to your Labs settings and enable the “Refresh POP accounts” lab, then hit “Save changes” at the bottom or top of the page. From then on, you’ll see a “Refresh” link to the right of your inbox buttons. Hit it and Gmail will poll any email accounts you’ve set it up to fetch from. Want to get started importing your other mail accounts into Gmail? Check out Gina’s guide.

Possibly Related posts

• No related posts.

MacRumors forum member Shenaniganz08 salvaged an iPhone 3G from eBay, sanding, buffing and polishing it back from the brink of a life in a case, which would be dumb, because cases are dumb. (I mean, not really, but that’s kind of the premise of this whole process, right? Anyway.) Here’s what you need:

• Sandpaper 320(or 500),800,1000,1500,2000,2500,3000 grit
• 3M Rubbing compound
• Machine Polisher ( Power Drill or small buffer)
• Microfibers
• Sticky tack and or tape

What's great about this is that you don't need to buy almost anything. Half the stuff you need—the microfibers, the polishing disc and the rubbing compound—is included in a $15 3M headlight restoration kit , and you can use just about any crappy household drill for the buffing stage.

In any case, the results are stunning, and the documentation meticulous, so if you’ve got a few hours, a few bucks and an iPhone that looks like a piece of shitty sea glass, why not? [Macrumors via Gadget Lab]

Possibly Related posts

• No related posts.

Photo by jimmihomeschoolmom.

We’re almost out of the so-cold-your-breath-fogs-the-windshield weather in most of the US but this trick works for everything from windshields to swim goggles. Over at the how-to site wikiHow they’ve shared a guide to using a cut potato to keep your windows fog-free.

1. Cut a raw potato in half. Be sure to use a clean potato, so wash it first if it is coated in soil. This is a good opportunity to use up an old potato that has started to sprout and is past its best.
2. Rub the cut part of one half potato on the window. This will clean it and leave a layer that will prevent fog from forming on the window.
3. Use the other half if needed. You can also cut off dirtied slices and keep using the existing half if wished.
4. Leave to dry without touching.

We thought it sounded too cheap and easy to actually work so we grabbed a potato and went and rubbed a raw slice on the shower door, window, and mirror in the bathroom. After a few minutes of steamy hot water the surfaces did in fact remain fog free. How well it lasts over time and how it compares to a $7 bottle of anti-fog spray from your local sporting goods store is open for debate.

Have a clever use to share? Let’s hear about it in the comments.

Possibly Related posts

• No related posts.

With stars, you can simply click the star marker on any search result or map and the next time you perform a search, that item will appear in a special list right at the top of your results when relevant. That means if you star the official websites for your favorite football teams, you might see those results right at the top of your next search for [nfl]. Here’s what the new “Starred results” feature looks like:

The great thing about stars is that you don’t have to keep track of them. You don’t even have to remember whether or not you starred something. Simply perform a search and you’ll rediscover your starred items right when you need them. Stars sync with your Google Bookmarks and the Google Toolbar, so you can always see your list of starred items in one place and easily organize them. Even beyond the results page, while browsing the web you can quickly click the star icon in Toolbar to create a bookmark, and those pages will start showing up in the new stars feature.

Stars in search replace SearchWiki. In our testing, we learned that people really liked the idea of marking a website for future reference, but they didn’t like changing the order of Google’s organic search results. With stars, we’ve created a lightweight and flexible way for people to mark and rediscover web content. For people who like annotations, we have Sidewiki, a more powerful way for people to contribute and discover helpful information next to pages across the Internet. All your existing SearchWiki edits will be preserved with your Google Account. You can learn more on our help center.

Stars in search are rolling out in the next couple days and will be available globally for all signed-in users.

Posted by Cedric Dupont, Product Manager and Matthew Watson, Software Engineer

Possibly Related posts

• No related posts.

To get this solution, you’ll need to add its source:

http://www.cmdshft.ipwn.me/apt/

…to Cydia. Then do a search for Push Doctor to locate the package, install, and confirm. From weblog Addictive Tips:

Once the package is installed, you’re done. It won’t show up as any app on your springboard or under the Settings app. What this package does is simply adding the valid, unique certificates for your hacktivated iPhone. Try any application with push notification support to ensure working of the package.

You can use Push Doctor on any unlocked iPhone running firmware 3.1.3 or 3.1.2.

Possibly Related posts

• No related posts.

Narrated by actress and philanthropist Isabella Rossellini, the Google Earth tour introduces you to the work of the new Pew Marine Fellows: Daniel J. Conley, Omar Defeo, Beth Fulton, Peter Mumby, and Ben Sullivan.

The prestigious fellowship is awarded each year to five outstanding global leaders or teams for working tirelessly to preserve and protect the world’s oceans and marine species. For the next three years, these marine scientists will work on their original, research-based marine conservation project.

Each Pew Marine Fellow will communicate his or her results widely, so check back for more information about the program and the fellows at www.pewmarinefellows.org, or you can learn more about the fellows now by viewing the Google Earth tour on the 2010 Pew Marine Fellows website today!

Possibly Related posts

• No related posts.

If you want total control over your proxy experience, you can always run a home proxy. We showed you how to set one up last month with our guide to bypassing heavy-handed firewalls. While you’re tinkering away with your home network it’s also worth setting up a SSH SOCKS proxy to encrypt and secure all your remote traffic too.

If you don’t want to leave your computer on all the time or be limited by the speed of your home internet connection however, you can use a Google account to set up a proxy server that runs off the Google Apps Engine and allows you to browse via proxy independent of your home network and without having to trust a sketchy third-party proxy. You’ll be running your own proxy server through the Apps Engine, free for you to tweak. They’ve put together a detailed guide at Digital Inspiration, check out the video below:

For step by step instructions, including lots of screen shots, visit the link below. Have your own way for circumventing firewalls and browsing on your own terms Let’s hear about it in the comments.

Possibly Related posts

• No related posts.

Everything is more fun with a friend! We’ve just added a feature to Webmaster Tools Site Verification to make it easier to share verified ownership of your websites.

In the past, if more than one person needed to be a verified owner of a website, they each had to go through the meta tag or HTML file verification process. That works fine for some situations, but for others it can be challenging. For example, what if you have twenty people who need to be verified owners of your site? Adding twenty meta tags or HTML files could be pretty time consuming. Our new verification delegation feature makes adding new verified owners a snap.

Once you’re a verified owner of a website, you can view the Verification Details page (linked from Webmaster Tools or the Verification home page). That page will show you information about the site as well as a list of any other verified owners. At the bottom of the list of owners, you’ll now see a button labeled “Add a user…”. Click that, enter the user’s email address, and that person will instantly become a verified owner for the site! You can remove that ownership at any time by clicking the “Unverify” link next to the person’s email address on the Details page.

There are a few important things to keep in mind as you use this feature. First, each site must always have at least one owner who has verified directly (via meta tag or HTML file). If all of the directly verified owners become unverified, the delegated owners may also become unverified. Second, you can only delegate ownership to people with Google Accounts. Finally, remember that anyone you delegate ownership to will have exactly the same access you have. They can delegate to more people, submit URL Removal requests and manage Sitelinks in Webmaster Tools, etc. Only delegate ownership to people you trust!

We hope this makes things a little easier for those of you who need more than one person to be a verified owner of your site. As always, please visit the Webmaster Help Forum if you have any questions.

Sean Harding, Software Engineer

Possibly Related posts

• No related posts.

How does it work? When the language of the webpage you’re viewing is different from your preferred language setting, Chrome will display a prompt asking if you’d like the page to be translated for you using Google Translate.

Here’s a demo of the translation feature by Jay Civelli, one of the engineers who developed it:

For more on how automatic translation in Chrome works, read on in our Help Center article. We hope that the development of online translation tools like this one will help make all the world’s information universally accessible in an easy, frictionless way – imagine reading a diversity of foreign language news sources in your mother tongue, or easily conducting online commerce across borders and languages.

With today’s beta release, we’re also excited to introduce new features that will give you even greater choice and control over your privacy as you browse the web. We realize that many users have questions about privacy in browsers, so we’ve produced a short video to help users better understand privacy in the browser:

In addition to Chrome’s existing incognito mode – a handy way to browse the web without leaving traces of website visits on your computer or downloads in your browser history – you can now manage your privacy settings in the new “Privacy” section of Chrome’s Options dialog. From these settings, you can control how browser cookies, images, JavaScript, plug-ins, and pop-ups are handled on a site-by-site basis. For example, you can set up cookie rules to allow cookies specifically only for sites that you trust, and block cookies from untrusted sites.

You can read more about these features, or watch videos explaining how your privacy is handled in Chrome’s various features including search and suggestions, browser cookies, Safe Browsing technology, and automatic security updates.

Try out all these new features for yourself in today’s beta release. For those of you already on the beta channel, you’ll soon be updated automatically. And for those of you on the stable channel, we’ll be making Chrome’s new translation and privacy features available to you in the coming weeks. Till our next update, auf Wiedersehen!

Posted by Wieland Holfelder, Engineering Director, Google Munich

Possibly Related posts

• No related posts.

One of the lesser-known features of Gmail is its ability to help with multitasking. Frequently, I find that I need to find an old message while I’m composing an email. When this happens, I click on the “new window” icon to pop my compose area into its own window:

There's only one problem — it's been slow! Today, we're rolling out a change that will fix this (reload your account to make sure you get this change). Now, popping out a window is much, much faster. No more "Loading…" progress bar.

There are a number of places you can pop up new windows in Gmail.

• In chat, there’s the little upward arrow in the title bar:

  

• When writing a message, hold the "Shift" key while you click on the Compose Mail, Reply, Reply All or Forward links and you'll get a new window for your new message. (Holding the "Shift" key while typing the keyboard shortcut — in other words typing "C" "R" or "F" — has the same effect.)
• When you’re reading your mail, hold the “Shift” key while you click on a message to open the conversation in a new window. (Same holds true for the “Shift” key and the “o” or “Enter” shortcuts.)
• If you’re reading an email and want to save it for later, you can click the “New window” link in the upper-right hand corner of the conversation view:

  

Keep in mind that the popped out window does not outlive the closing of the original Gmail window, although we’re working on a way to make that better. Unfortunately, we weren’t able to make this work in Internet Explorer, so to see the speed-up, you’ll need to be using Mozilla Firefox, Apple’s Safari, or Google Chrome.

Possibly Related posts

• No related posts.

Posted by Jessica Wong and Jason Morrison, Search Quality Team

Possibly Related posts

• No related posts.

More than ever before, people are sharing and storing their photos online. But until recently, you had to edit your photos using client software on your computer. Today, we’re excited to announce that Google has acquired Picnik, one of the first sites to bring photo editing to the cloud. Using Picnik, you can crop, do touch-ups and add cool effects to your photos, all without leaving your web browser.

We’re not announcing any significant changes to Picnik today, though we’ll be working hard on integration and new features. As well, we’d like to continue supporting all existing Picnik partners so that users will continue to be able to add their photos from other photo sharing sites, make edits in the cloud and then save and share to all relevant networks.

We’re very impressed with the Picnik team and the product they’ve created, and we’re excited to welcome them to Google. We’re looking forward to collaborating closely with them to improve the online photo editing experience on the web. In the meantime, we encourage you to head to Picnik, import some of your photos from Picasa Web Albums, Flickr or Facebook and try your hand at photo editing in the cloud!

Posted by Brian Axe, Product Management Director

Possibly Related posts

• No related posts.

You can choose to see results nearby either your default location or a custom location, and you can narrow down to results at the city, region or state level. Try these examples:

[things to do on st. patrick's day] – In the Minneapolis region
[food blogs] – Near you
[farmers market] – Near the city of Ithaca
[dmv] – In the same state as Tucson

The new “Nearby” search option is available now on the google.com domain in English.

Posted by Jackie Bavaro, Product Manager

Possibly Related posts

• No related posts.