Writing custom formulaes for excel using VBA

No comments : at 10:27 PM Labels: , , ,

It will be easy to if we are able to add our own formulaes in excel. The following steps explains how to add a formulae using VBA (Excel Macros).
First open the visual basic editor ( In excel 2003 it is available from Tools>Macros>visual basic editor. In excel 2007 it should be enabled  from the excel options menu, then invoke using Alt+F11 or from the developer ribbon)


Enabling of Visual Basic Editor in Exel 2007

In the visual basic editor, add a new module

Type the function as shown in the screen shot. 
This function will be vailable as a formulae in excel sheet.
In the example shown above, the formulae MyAverage1 is defined which will calculate the average of three numbers.


In this example the MyAverage2 is made which will calculate the average for a range of cells.


If it is necessary to create a library of formulaes, then save the exec as an excel addin. The put the addin in the "C:\Documents and Settings\\Application Data\Microsoft\AddIns" folder. Now select the addin from Tools>addins menu for execl 2003 or Exec options>addins menu for excel 2003
The example file can be downloaded from here.

Read More

Use download manager on firefox.

No comments : at 9:30 PM Labels: , , ,

W4APBTHK5T3E One of the nice features of the firefox browser is that we can install lot of plugins which come with cool features. These plugins are called as addons. For knowing more about addons and for browsing from 100s of firefox addons, go to tools menu in firefox and then select addons. In the addons window click the link in the left bottom called "Get Extensions".

DownloadThemAll is one of the addon which which will replace the download manager. Is a good download manager which has all the features of a full fledged download manager. It will work work with the same network settings as that of the firefox browser. So if you have configured proxy on browser, you need not have to configure it for the download manager separately. Only drawback of this is that, it does not downloads torrents.

Snap Shot of DownloadThenAll!

This will of great use for those who uses linux in which there will be problems installing right software packages and lack of user friendliness. These addons can be used on almost all OS where firefox is available. I'm using this as download manager on my Ubuntu amd64.

Read More

Malayalam Internet Radio

1 comment : at 5:57 PM Labels: , ,

Here are some of the internet radios available for Malayalam. These links can be played using media pla players which suppports streaming media playback (Most of the players supports streaming)

Radio Joy Alukas ==> http://radiojoyalukkas.com/rdja.asx
Marconi Malyalam FM ==> http://marconimalayalam.com:8000/;stream
SPace For Radio FM ==> http://www.spaceforradio.com/spaceforradio.asx
World to world Radio FM ==> mms://wm8.spacialnet.com/wordtoworldradio
Masti FM ==> http://stream.mastitunes.com/listen
Desi Radio FM ==> http://www.desi-radio.com/desiradio.wpl
Mallu Radio ==> http://77.89.128.83:8001/
Kerala Radio ==> http://radio.hostonnet.com:8000/
RadioGrapes FM ==> http://www.radiograpes.com/radiograpes.asx
Mallu Tribe ==> http://74.54.55.146/~mallutri/mtradio.m3u
Malayali Radio ==> mms://wm6.spacialnet.com/malayaliradioDC136129
RadioTeenTaal - Paris ==> http://91.121.155.39:8128
Radio mirchi 98.3 FM ==> http://87.98.216.140:80
SBS FM - Hindi ==> http://www.radiosbsfm.nl/Files/Pages/Home/RadioSBSFM.asx
Radio XL - UK ==> http://www.vtuner.com/vTunerweb/mms/m3u13219.m3u
ApnaRadio - USA ==> http://www.apnaradio.com/live/media24/ApnaRadio.asx
DesiSoundz - India ==> http://desisoundz.com:8000
BombayBeats FM ==> http://www.1.fm/player/energybbfm32k.asx
Radio mska ==> http://www.radiomaska.com/listen128.asx
Deccan Radio Online ==> http://69.162.119.226:8300/
Bombay Beats FM ==> http://bb.1.fm/bbfm32k
Houston ki Jaan US FM ==> mms://nyc04.egihosting.com/237296
Apana Radio Punjabi FM ==> http://www.apnaradio.com/live/media64/ApnaRadio.asx
Radio Mirchi Mumbai FM ==> mms://wm7.spacialnet.com/fbcl75137
Radio Brisvaani Brisbane FM ==> mms://energy15.egihosting.com/874213
DhoomFM NewJersey FM ==> http://www.mainstreamnetwork.com/listen/dynamicasx.asp?station=dhoom-fm
Taal FM Port Louis Mauritius FM ==> http://mbc.intnet.mu/TaalFm.asx
Masala 101 FM - Canada FM ==> mms://masala.gnxnetwork.com/masala
Malayali FM ==> http://keralaradio.in/media/KeralaRadio.asx





Firefox playing radio using Totem Gstream Pligin

Totem player playing dumdumradio


All of these channels comes with player. So if you are not able to play this on windows, then you can download the players from the corresponding Websites. In linux these will be played by Totem Movie Player(Others players cah also play) provided you have the codecs installed. In Ubuntu, if you are having an internet connection then the these codecs will be automatically installed.
Mallus who are outside Kerala can enjoy malayalam songs and programs with the help of these internet radio stations.

Read More
Subscribe to: Posts ( Atom )