Sunday, May 31, 2009

Building brand value at workplace

Recently read an article from Delhi Times Ascent. Very inspiring and true

There are often times when an employee may wonder, how do i stand out in a team? And experts say that by simply completing tasks assigned on time or working hard for longer hours, may not necessarily be the answer. They say it takes more than just one's work and job profile to be outstanding. This is where the role of crafting your own "USP"(Unique Selling Proposition) comes into the picture.

Crafting your USP:

According to experts, the first thing to do while brand-building is to identify the qualities and characteristics that give you an edge over the rest. Understand your strengths/abilities and use it towards your advantage at the workplace. Maintaining good relations with people whom you deal with will also add to your brand value. Self-branding is no easy task. It comprises of identifying your best personality traits and displaying it from time to time through enhanced performance and higher productivity. This will not only get you noticed but will also give you an edge over your colleagues.

Build your brand:
- Be a great team-mate and a supportive colleague.
- Be passionate about your job and make others know that you are excellent in your particular task/job.
- Finish the tasks assigned to you on time with exceptional quality.
- Be proactive and discuss your views on improving things with your senior officials.
- Bring in innovations into your project/tasks to make it more efficient.

Sunday, May 17, 2009

Comparing Excel Files

While testing any reporting application, one comes under situations when he/she have to compare two excel files. If the excel sheets are small, its easier to compare them manually but as long the sheets becomes large, you need some automated way to compare those.
Earlier, i used to export those files as csv and then comparing them using perl scripts but it was an overhead to exporting and then comparing so i thought of doing something within the excel sheets itself. After googling, i found that it can be done by using Excel Macros. I did try that, but found that you need to open those excel files in Microsoft Excel and then apply the macro, which again i didn't like as it require to open MS Excel. I was interested to have a program which i can run from command prompt. Finally i got my solution. I converted the above macro as a standalone vb script program and used it from command prompt.
The great benefit with this script is that i can take control of displaying the diff results (currently, i am highlighting the rows in the excel sheet itself.)

to run this program, open command prompt and run following command:

C:\> cscript /nologo ExcelCompare.vbs <ExcelFile1> <ExcelFile2>

Following is the program:

Run a Visual Basic Script Program from a command prompt

A Visual Basic script program can be run from a DOS prompt. cscript command can be used for this purpose.

C:\>cscript <pathToVBScriptFile>

by default cscript command displays the Microsoft Header but this can be avoided by providing /nologo argument.

Microsoft (R) Windows Script Host Version 5.6
Copyright (C) Microsoft Corporation 1996-2001. All rights reserved.

C:\>cscript /nologo <pathToVBScriptFile>

User can also take control to take input and display the output on the console. For that user had to use following options in the VB Script.

dim input
dim output
dim name

set output = wscript.stdout
set input = wscript.stdin

output.write "Enter Your Name : "
name = input.readline

output.writeline "Your Name is " & name