Monday, May 18, 2009

GTasks in GCal

Google Tasks have been integrated with Google Calendar (finally! Expected this to be the first step than following its integration with Gmail). Features are awesome.

  • Once a Task is added to GTasks with a due date, it becomes a day's event in GCalendar.
  • One can create a Tasks from Calendar (only in All Day and Month views only).
  • Using Sort option in Actions of Tasks, one can finish in the order of due date
Things expected in future:
  • Assigning Priorities to Tasks (Its available in standalone GTasks app).
  • Adding Time aspect to the due date. Currently, its only at the Date level and not at Date & Time level
  • Default Calendar Notifications to get applicable to the Task (as in a Calendar event).
Access Calendar events through SMS:

Similar to SMS events usage in Google SMS Channels, one can create an event, know which is the next event for the day, total agenda for the day, next day's schedule - all through sms! Number: 48368 (GVENT). Its currently available only for US citizens. How to create using SMS? They give an example (Source):

"Send a message with something like "Shopping with Sarah at Monterey Market 5pm Saturday," Google Calendar can figure out what you mean and pop the new event into your calendar."
Horoscope Calendar:

 I personally liked the Horoscope Public Calendar. So, if one is interested, just click on the links below and get the respective zodiac sign's calendar added to your list of calendars (Source)

"For some cosmic direction, get your daily horoscope directly in Google Calendar. Just click the icon showing your sign in the upper-left corner of the day to read your overview, courtesy of tarot.com.
To subscribe to your horoscope calendar, click the appropriate link in the following table:

Horoscope Calendars
Aries Libra
Taurus Scorpio
Gemini Sagittarius
Cancer Capricorn
Leo Aquarius
Virgo Pisces
 "

GTasks in GCalSocialTwist Tell-a-Friend
Bookmark and Share

Thursday, May 14, 2009

Google Contacts

This thought had been there for quite a while that there should be a Birthday field in GContacts. And when we enter it, it should automatically create an event in GCal [or give a choice whether we want to create or not] with Recurring type, Repeating Annually and stuff like that. Who doesnt have! Even a simple 14 field contacts manager in a Sony Ericsson mobile phone has it [including setting a custom ringtone for each user! :)] which at the end of adding a birthday prompts whether we want to add reminder to the calendar. This reminder in SE automatically reminds every year!

Well, GContacts has come out as a separate service from Google. It does contain the Birthday field, an Anniversary too, plus Other option [good news! :)]. Though integration with GCal is yet a feature to look at [bad news:(]. Now, one can maintain quite good amount of data here. It is better managed than Gmail Contacts. Though some fields here are duplicated from GProfile. The service is available even in GApps [after admin enables it. Steps given here].

Hoping a day comes when we will have to enter our information only once, and it will get reflected in all possible places.

Google ContactsSocialTwist Tell-a-Friend
Bookmark and Share

Wednesday, May 13, 2009

Sharing Content

RSS feeds is the most common way of sharing content on web. Almost all the blogs and relevant websites have this enabled. With RSS feed agregators, one can subscribe and be upto date.

With the popularization of Socializing websites, one wants to share what one reads or likes with his/her friends on social networks (like facebook, stumble, digg, tweet, etc.) or email it to them. Thats when the concept of sharing using button came up and became popular.

One can give these options to the readers as text (using FeedBurner), or as button (using Tell-A-Friend or Add-this). They add themselves up at the bottom of each post (in blogs) or can be placed according to one's own wish.

These utilities give added features of multiple ways of subscribing, sharing and analysing the traffic/crowd that is visiting the site.

Sharing ContentSocialTwist Tell-a-Friend
Bookmark and Share

Saturday, May 2, 2009

Print Odd and Even pages in Excel

In Microsoft Word, we have an option of printing Even and Odd pages which helps in saving paper by printing on both sides. But the same option does not exist in Excel.

One can add the following VBScript in Macros of the Excel workboook and print Odd or Even pages.
---------------------------------------------------------------------------------
Sub printalterantepages()
    Dim Totalpages As Long
    Dim StartPage As Long
    Dim Page As Integer

    StartPage = 1  '1 = Odd and 2 = Even

    'Or use the InputBox suggestion from Gord Dibben
    'StartPage = InputBox("Enter 1 for Odd, 2 for Even")

    Totalpages = Application.ExecuteExcel4Macro("GET.DOCUMENT(50)")
    For Page = StartPage To Totalpages Step 2
        ActiveSheet.PrintOut from:=Page, To:=Page, _
                             Copies:=1, Collate:=True
    Next
End Sub
------------------------------------------------------------------------------------------------
As stated in the code, one has to change the StartPage value from 1 to 2 to print Odd and then Even pages.

Print Odd and Even pages in ExcelSocialTwist Tell-a-Friend
Bookmark and Share
Blog Widget by LinkWithin
 
Clicky Web Analytics