Suggest me some features to compare online spreadsheets

Google’s release of Google Spreadsheet yesterday has generated lot of sudden attention on online web applications especially those which are proving to be direct competitor to Microsoft Office applications.

In addition to Google’s Spreadsheet I came to know about a couple of other great products like Zohosheet, iRows, NumSum from Techcrunch’s article yesterday which are also targeting similar user base. So I thought of comparing all these online spreadsheets to get an idea about their pros and cons. (Nice weekend project right?)

So guys let me know your favorite features which you would expect from a spreadsheet program so that I can base my comparison on them. Also let me know if I have missed any other online spreadsheets.

Here are the links to the programs which I am going to compare

I will publish my results as soon as I finish them so stay tuned and don’t forget to leave your favorite features in the comments.

Posted in Google/Yahoo | Tagged , , , , , , , , | 18 Comments

Microsoft Office Killer in Making

I first speculated that Google has been creating a Microsoft Office Killer when they acquired Writely around 3 months back. But the recent limited public beta testing of Google Spreadsheets really proves that fact that they are in fact building a Microsoft Office Killer.

Some might argue that this is just hype and Web applications cannot compete with native Windows desktop applications. But I somehow feel that Microsoft Office has become more complex these days and may be only 15-20 % of the people really need those complex features but for others the Web counterparts may be enough. Apart from the simplicity the other huge factor is cost. Most of the people would be comfortable in viewing a couple of ads on their web applications rather than spending a fortune in buying their Desktop counterparts. Added to all these is that the document could be stored in Google’s Server itself which prevents you from frequent backup pain.

So here is a list of products from Google competing directly with Microsoft Office Applications

  • Word – Writely
  • Outlook – Gmail
  • Calendaring (Outlook feature) – GCal
  • Excel – Google Spreadsheets
  • Frontpage – Google Pages
  • PowerPoint – I am 99.99% sure that Google is currently creating a PowerPoint killer. It’s just a matter of time before it gets released.

Apart from the main Office applications here are other applications for which Google has a competing product.

  • Picture Manager – Picasa
  • MSN Messenger – Google Talk, Hello Messenger
  • Windows Search – Google Desktop Search
  • Internet Explorer – Google Tool bar and Google’s support for Firefox.
  • Visio – SketchUP, a recent acquisition of Google

I think in the next couple of years (around the release of vista) there could be some stiff competition to gain the market share and as always it is we the users who are going to get benefited as a result of competition. Eagerly waiting to watch Microsoft’s next move. What do u say guys?

Links:

Posted in Google/Yahoo | Tagged , , , , , , , | 14 Comments

The Free iPod Book 2.0

The iPod specialists at iLounge have just released the Free iPod Book 2.0, an eBook chocked full of tips, tricks, and customizations for your iPod. It’s totally free and is available as two versions – Printable and wide screen and can be downloaded from iLounge.

It is a 194 page book with over 110 tips and tricks and is full of incredible iPod and iTunes information. If you are an iPod junkie like me, then you’ll definitely want to check this out.

Download it from iLounge

Posted in Apple/Mac/iDevices | Tagged , | Leave a comment

Firefox 1.5.0.4 crashes (too often)

I updated to Firefox 1.5.0.4 only to find that it is very unstable in my system. It is crashing almost every 20 minutes and has already crashed a couple of times. It just reminds me the problems that I had with Firefox 1.0.4 almost a year back and I think the same bug has creped in again. May be it is getting replicated in all versions that end with xxx.0.4 😉

I am just wondering whether it is happening only to me or even others are also facing the same problem. But anyway this has made me to use IE after a very long time and I am composing this post in IE after a very long time.

Posted in Web Programming | Tagged , , | 8 Comments

What is your Level of web knowledge?

Well I am going to flirt with an Internet Meme which is getting spread around. It all started when Emil wrote Levels of CSS knowledge. This inspired Roger to write Levels of HTML knowledge and that got followed by Levels of Javascript knowledge, the levels of Accessibility knowledge etc.

Instead of leaving a comment on each blog separately I decided to write about my level of knowledge here. So here it goes

Apart from letting you know where you are standing, these posts are really fun to read. So what is your Level of web Knowledge?

Posted in Web Programming | Tagged , , , , | Leave a comment

Google’s New Layout

I fired up Google this morning to search for something and then noticed that there was some change in the Google’s Layout. The different tabs which leads to different services like web, Image, group, news etc was on the left and the Google’s Search box has gone a little bit high.

I immediately checked my colleagues system and the Google’s homepage was displaying as usual. So then only I realized that Google has selected my ip to do some kind of testing to their new UI. So I immediately took a snapshot of it. Here are some of those screen shots.

This is Google’s web search page. Note the position of the different tabs, they are in the left.
Google's New Layout

This is the Google’s Image search page and see the position of tabs. I somehow felt that they are placed in a very awkward manner. (May be someone at Google is using their 20% free time to learn CSS positioning)

Google's New Layout

And for records I was using Firefox on Windows XP while talking these screen shots. Does anyone else noticed this new layout apart from me?

Posted in Google/Yahoo | Tagged , , , | 5 Comments

Yet another iPod manager

In my last post I wrote about SharePod and also a small step by step guide to copy your files from iPod to computer. But there was one small drawback, it works only in Windows.
And in the comments someone suggested YamiPod. Even this has almost all the features of SharePod and more over it works in Mac as well as in Linux. So if you didn’t like SharePod and/or you are not in Windows then you can try YamiPod.

I am yet to try in and will publish my thoughts on it after using it. Meanwhile if any of you are using it then do share your thoughts on YamiPod.

Posted in Apple/Mac/iDevices | Tagged , , | 2 Comments

Copy files from iPod to any computer without iTunes

At last I have found a way to copy audio or video files from iPod to any computer. You don’t need to install anything in the computer and also you don’t need to tamper your iPod firmware which may make your warranty void. You can run the program from your iPod itself, which gives you the freedom to transfer files from any computer to your iPod and also vice versa. And before we precede just a line of caution.

Note: Don’t use this program to copy copywrited files. Use this program only for backing up your non copy-writed files.

First things first. You need to download a program called Share pod. You can download the program from its download page. After downloading extract the files from the zip file into a separate directory in your iPod. In order to do this you may have to enable disk mode for your iPod in your iTunes.

Now just double click the ‘SharePod.exe’ file to start the program.
11.GIF

The program will start and then will list the songs and play lists in your iPod. Now select the files that you want to copy to the computer and then click the ‘To PC’ button which is present in the top left corner.

21.GIF

A dialog box will appear. Specify the directory where you want the files to be copied and also select the template to name your file based on artist, album etc. After filling in the dialog box click the transfer button.

31.GIF

The files you have selected will be transferred to your system and once it is done a dialog box will appear confirming the transfer.

4.GIF

That’s it. Your files are now copied to your computer. The program will also generate and import XML file which you can use to import the copied files into your iTunes.

5.GIF

In the similar way you can use this program to transfer files from your computer into iPod without using iTunes at all. But if you are going to do this, then you should disable automatic sync in your iTunes, otherwise the next time you start iTunes it will override all your copied files.

As I have said before (here and here) I was not very happy with iTunes and now SharePod has come to my rescue and now I can separate my iPod from iTunes. If you are still wondering why to use Sharepod instead of iTunes, here is the list of advantages of SharePod

  • Ability to copy music back form iPod to computer
  • Very fast and small in size
  • Requires less memory
  • No installation
  • The program can be carried in iPod itself

etc.

In spite of all these advantages, SharePod has some disadvantages too.

  • Works only in Windows
  • No support for podcast. (And because of this I have to still use iTunes for my podcasts)

Hope this is useful and do let me know what you feel about the program.

This article is part of an ongoing series of posts under the title

Posted in Apple/Mac/iDevices | Tagged , , | 39 Comments

Google Search syntax dissected

Here is my compilation of some of Google’s advanced query syntax which you can use to get results quickly.

Basic Boolean

Whenever you search for more than one keyword at a time, Google will search for all of them. If you search for

XML Java "web Services"
Google will search for all the words. If you want to specify that either word is acceptable, you put an OR between each item

XML OR Java OR "Web Services"
If you want to have definitely one term and one of two or more other terms, you group them with parentheses, like this

XML (Java OR "Web Services")
This query searches for the word “Java” or phrase “Web Services” along with the word “XML.” A stand-in for OR borrowed from the computer programming realm is the | (pipe) character, as in

XML (Java | "Web Services")
If you want to specify that a query item must not appear in your results, use a -.(minus sign or dash).

XML Java -"Web Services"
This will search for pages that contain both the words “XML” and “Java” but not the phrase “Web Services.”

Operators

In addition to the basic AND, OR, and quoted strings, Google offers some rather extensive special syntaxes for honing your searches. Google being a full-text search engine, it indexes entire web pages instead of just titles and descriptions. Additional commands, called special syntaxes, let Google users search specific parts of web pages or specific types of information. Specifying that your query words must appear only in the title or URL of a returned web page is a great way to have your results get very specific without making your keywords themselves too specific.

Here are some of the common keywords that you can add to your query in Google

intitle, allintitle

Restricts your search to the titles of web pages. The variation, allintitle: finds pages wherein all the words specified make up the title of the web page. It’s probably best to avoid the allintitle: variation, because it doesn’t mix well with some of the other syntaxes.

Eg: intitle:"george bush"
allintitle:"money supply" economics

inurl, allinurl

Restricts your search to the URLs of web pages. This syntax tends to work well for finding search and help pages, because they tend to be rather regular in composition. An allinurl: variation finds all the words listed in a URL but doesn’t mix well with some other special syntaxes.

Eg: inurl:help
allinurl:search help

intext, allintext

Searches only body text (i.e., ignores link text, URLs, and titles). There’s an allintext: variation, but again, this doesn’t play well with others. While its uses are limited, it’s perfect for finding query words that might be too common in URLs or link titles.

Eg: intext:"yahoo.com"
allintext:html

inanchor

Searches for text in a page’s link anchors. A link anchor is the descriptive text of a link. For example, the link anchor in the HTML code O’Reilly and Associates is “O’Reilly and Associates.”

Eg: inanchor:"tom peters"

site

Allows you to narrow your search by either a site or a top-level domain. AltaVista, for example, has two syntaxes for this function (host: and domain:), but Google has only the one.

Eg: site:loc.gov
site:thomas.loc.gov
site:edu
site:nc.us
You can also use site: operator to exclude certain domains from a search

Eg: google -site:google.com
This is particularly useful for ego searches. You can find out all those sites which mention your name expect your site.

Eg: bill gates -site:microsoft.com -site:wikipedia.org

link

Returns a list of pages linking to the specified URL. Enter link:www.google.com and you’ll be returned a list of pages that link to Google. Don’t worry about including the http:// bit; you don’t need it, and, indeed, Google appears to ignore it even if you do put it in. link: works just as well with “deep” URLs-http://www.raelity.org/apps/blosxom/ for instance-as with top-level URLs such as raelity.org.

Eg: link:www.google.com

cache

Finds a copy of the page that Google indexed even if that page is no longer available at its original URL or has since changed its content completely. This is particularly useful for pages that change often. If Google returns a result that appears to have little to do with your query, you’re almost sure to find what you’re looking for in the latest cached version of the page at Google.

Eg: cache:www.yahoo.com

filetype

Searches the suffixes or filename extensions. These are usually, but not necessarily, different file types. I like to make this distinction, because searching for filetype:htm and filetype:html will give you different result counts, even though they’re the same file type. You can even search for different page generators, such as ASP, PHP, CGI, and so forth-presuming the site isn’t hiding them behind redirection and proxying. Google indexes several different Microsoft formats, including: PowerPoint (PPT), Excel (XLS), and Word (DOC).

Eg: homeschooling filetype:pdf
"leading economic indicators" filetype:ppt

related

Finds pages that are related to the specified page. Not all pages are related to other pages. This is a good way to find categories of pages; a search for related:google.com would return a variety of search engines, including HotBot, Yahoo!, and Northern Light.

Eg: related:www.yahoo.com
related:www.cnn.com

info

Provides a page of links to more information about a specified URL. Information includes a link to the URL’s cache, a list of pages that link to that URL, pages that are related to that URL, and pages that contain that URL. Note that this information is dependent on whether Google has indexed that URL or not. If Google hasn’t indexed that URL, information will obviously be more limited.

Eg: info:www.oreilly.com
info:www.nytimes.com/technology

define

Will get the definition of the term that you have entered. This syntax can be used to get the definitions of words, phrases, and acronyms

Eg: define:dreaming
This query will get you the definition of the word dreaming

numrange

If you want to search for a range of numbers then you can use two dots (without spaces) to represent a range of numbers

Eg: inventions 1850..1899
This query will get you all the inventions between 1850 and 1899

safesearch

If you include safesearch: in your query, Google will exclude adult-content.

Eg: safesearch:breasts
This will search for information on breasts without returning adult or pornographic sites.

stocks

If you start your query with stocks:, Google will interpret the rest of the query terms as NYSE, NASDAQ, AMEX, or mutual fund stock ticker symbols, and will open a page showing stock information for the symbols you specify.

Eg: stocks:goog
This will show information about Google’s stock. Specify ticker symbols not company names. If you enter an invalid ticker symbol, you’ll be told so and given a link to a page where you can look up a valid ticker symbol.

The Special Syntaxes

Currency Conversion

Google makes it easy to calculate money conversions from one form of currency to another.

Eg: $5 in yenThe above query will let you know that five dollars is worth about 566.599846 yen.

If you’re not sure of the name of a currency, use nationality instead.

Eg: 25 Australian money in Italian money
This may sound awkward but it does the job.

Eg: $5 in indian money
This will let you know that 5 US dollars is worth about 224.477976 Indian rupees

You can even convert units in this fashion.

Eg: $2.85 per gallon in British money per literThis query will tell you that it is about 42 pence per liter and provides an international basis for discussing gas prices at the pump.

Check Airfares

When you google for the names of two major cities, Google automatically offers to search for flights.

Eg: Denver Fort Lauderdale
In the form labeled “Flights from Denver, CO to Fort Lauderdale, FL”, enter a departure and return date and choose whether to search using Expedia, Hotwire or Orbitz. Do not use quotation marks in your initial search. Denver “Fort Lauderdale” will not bring up the flight search form.

Find Song Lyrics

If you are looking for the title or lyrics of a song then you can use Google search phrases and wildcards to find them.

Eg: "Friday I am in love" lyrics
Or use the wildcard operator to get lyrics with certain words in them, like this

"Friday * love" lyrics

This compilation is just a tip of the iceberg of the features available in Google’s search syntax. If you come across any other special syntax, then do let me know so that I can add it.

Update: Some of the latest additions to Google Search Syntax can be found here.

Update 2: You can also get the current time of any city using Google Search query.

Posted in Google/Yahoo | Tagged , , , | 205 Comments

First aid advice on your iPod

Here is another use of your ipod (or any other mp3 player for that matter). You can refer you iPod for first aid tips incase of a mishap.

St. John ambulance service has some handy first aid advice which you can download to your iPod. This could be useful in an emergency, but its best if you give it a listen before you need it. They also have written First aid advice. All the audio files are available in 3 different file formats (mp3, AAC, Real) and can be downloaded from their online advice page.

If you are lazy to download these files manually, then you can also download them automatically using their podcast feed. All you have to do is just to subscribe to their podcast feed using iTunes (or using your favorite podcast reader).

Sussex ambulance service is also hosting some first aid advice files in their community page.

Hope you never get to use these advice but anyways do listen to them atleast once because just in case…

This article is part of an ongoing series of posts under the title ‘iPod Tips and Tricks‘. Here is the list of article in the series

Posted in Apple/Mac/iDevices | Tagged , | 1 Comment