Archive for the ‘Computer’ Category

Well well,, First the challenge for Search Engine from Microsoft and now the challenge for Google Earth. Wait a minute catch is, its not Microsift this time,, So who is it????

ISRO(Indian Space Research Organization), yes yes who heard right. Our very own ISRO. ISRO launched Bhuvan aka Google Earth killer, a satellite-based 3D mapping application.

Bhuvan uses the data recorded by Indian satellites.

Bhuvan’s edge over Google Earth

Google Earth’s                                    Bhuvan
Zoom levels up to 200 mt                  Bhuvan Zoom levels up to 10 mt.
Single layer information                      ISRO’s Bhuvan Multi-layer information. 
Images upgraded every 4 years       Bhuvan Images upgraded every year. 
No alternate viewing options            Options of viewing on different dates. 
Uses international satellites               ISRO’s Bhuvan Uses Indian satellites.

You will need to download a Plug in to use Bhuvan and create an account. So all you there explore this new tool and post comments.

Ok,Bing is here today… Fully launched Bing is on to roll from today 3rd June 2009. So I just of giving it a shot. Well a nice and asthetic home page to start with.

Nicely layed out page with option on left of the search box, some suggestive searches below. Also one features you all will notice are the small hotspot areas scattered on the screen with text/information available as soon as you hover mouse.

To start with I search the keyword ‘vijvipin’. No no I am not posseive with my name it was just to try the power of BING,, and BINGO 🙂 here is come… loads on my blogs and all my other presence on Internet world. Great Stuff!!.. Suggestive search is integrated same as most of the search engine are doing these days.

Ok now one more feature is: As soon as you hover your mouse on the searched results it opens a box with a brief of information from the real page. Well thats a neat feature.
 
On the image search, I am a little disappointed as it could not search as many as the Google can. I again looked for the term “vijvipin” and “vipin vij”.  
  
So here are some Tips from my side to get more from BING…

Use the Fully Loaded BING..
The are chances that you seeing a localized version of Bing (if using outside North America) that may be missing some features. For instance, the Indian version of Bing.com doesn’t have search history and the image on the Bing home page here is not interactive as in the US version.

To explore the full version of Bing, go to this page and set English – US as your default region. You can now enjoy all the Bing features from anywhere.

All for those stock predators 🙂
For all you who start the day with looking at stocks, if you search for a company stock, Bing will automatically create a web slice for that company which you may then add to IE 8 and track the performance directly from the favorites bar. You need Internet Explorer 8 to try this feature.

Pages with a particular file type:
Bing supports a unique “contains” search operator that lets you find web pages that contain links to particular file types.

One of the interesting feature is .. they (people at BING) change there main background on daily basis, so it will be interesting to see the new image on each day. On this front Google seems a bit boring…though it has speed benefits..

As Microsoft Internet explorer is widely used web browser, now Microsoft will give preinstalled Bing toolbar in IE, so i think the users of Bing will increase with time.

So, enjoy new searches.. and put your comments on this.

Keyboard Shortcuts: We all know and agree to be really fast with your computer one must know some of the very basic keyborad shortcuts of some of the very hugely used applications:

So here is the gift for you dear:

Windows

  • Create application shortcuts. To create a keyboard shortcut to any application, right-click on the application’s shortcut icon (such as those on your desktop), and enter a keyboard combination, such as Ctrl-Alt-W for MS Word.
  • Toggle between apps. Alt-Tab until you land on the app you want, then let both keys up. Or hold down the Windows key and press Tab to cycle through taskbar buttons to get to your app, then press Enter. Adding the Shift key to either method cycles in reverse.
  • Go to the desktop. Windows key-D.
  • Context menu. Instead of right-clicking to get a context menu, press Shift-F10. Then scroll up or down the menu with the arrow keys.
  • Shut down. To quickly shut down your computer, press Windows key and then U. Once there you can also type S for Standby mode, U to shut down, or R to restart.
  • Most common. You know these, but for true noobs, some common application shortcuts: Ctrl-O for open, Ctrl-S for Save, Ctrl-N for New, Ctrl-W to close a window, Ctrl-C to copy, Ctrl-V to paste, Ctrl-X to cut. Ctrl-Z to undo, Ctrl-Y to redo. To see the clipboard’s contents in MS Office, press Ctrl-C twice. Ctrl-Home to move to the top of a document, Ctrl-End to move to the bottom.
  • Menu bar. Pressing Alt gets you to the menu bar, and you can scroll around using the arrow keys. Alt plus the underlined letter of each menu option takes you to that option. Or just memorize the keyboard shortcut for that option for even faster keyboarding.
  • Windows Explorer. Windows-E goes to My Computer. Then use the following.
  • Display subfolders. NUM LOCK + Asterick Sign(*).
  • Display contents. NUM LOCK + PLUS Sign(+).
  • Collapse selection. NUM LOCK + Minus Sign(-).
  • Highlight text. In a document, use Ctrl-Shift plus arrow keys to highlight blocks of text quickly. Ctrl-A to highlight everything at once.
  • Permanent delete. Shift-Delete will delete an item permanently without sending to the Recycle bin.

Also Check my previous article on the short cuts for Visual Studio 2005 IDE Short Cuts

Soon I shall be publishing Shortcuts on applications like outlook, word and Google (how can I forget this :). So keep reading.

Please post your comments and please feel free to extend the knowledge.

Macros are very powerful tool in Excel. One can create all logic and funda in them and use them repeatedly. But when it comes to distributing a macro, its a real pain. Recently I came across that same problem when one of my colleague asked me to create a function to spell the amount in words, also he wanted the this funtion could be distributed easily to other clients also. Working on the problem I came across Excel Add in.

An Excel Add-In is a file (usually with an .xla or .xll extension) that Excel can load when it starts up. This is a very convieneint and Infact meant for the purpose of distribution.

How to create: Open an Excel file, Press ALT + 11, this will open a VBA window as shown here

Excel Add In (.xla file)

Excel Add In (.xla file)

Put your code in the function and save it.  File>Save as \ Microsoft Excel Add-in (*.xla). Once saved and re-opened the Workbook will be hidden and can only be seen in the “Project Explorer” via the Visual Basic Editor. It is NOT hidden in the same way as the Personal.xls as this can be seen (and made visible) via Windows>Unhide.

Once completed users can easily install your Add-in like below

  • Save a copy to C:\WINDOWS\Application Data\Microsoft\AddIns\ . If not any location, just take note of it for step 4.
  • Open any Workbook.
  • On the Tools menu, point to Add-Ins and click Browse. Locate your add-in from where you saved it, select it and then click OK.
  • Ensure your add-in is in the Add-ins available: box and it is checked.
    Now click OK and the add-in is installed.

Yes You have done it. Voilla, Add In is installed and will be available to any excel you open now. You can use the function written in xla files (shown as above) like any other microsoft build in function.

Enjoy the Excel Power!!!! Please do write in case any addtions, suggestions and comments, these matters a lot to me 🙂

Previously I wrote about the Grid Computing. Yes now a different kind is here: Cloud Computing. So what is it?

Well Cloud computing is a computing paradigm in which tasks are assigned to a combination of connections, software and services accessed over a network. This network of servers and connections is collectively known as “the cloud.” The common theme stresses reliance on the Internet for satisfying the computing needs of users, without them needing knowledge of, expertise with, or control over the technology infrastructure that supports them. Computing at the scale of the cloud allows users to access supercomputer-level power. Using a thin client or other access point, like an iPhone, BlackBerry or laptop, users can reach into the cloud for resources as they need them. Google Apps, Maps and Gmail are all based in the cloud. Other companies have already created Web-based operating systems that collect online applications into Flash-based graphic user interfaces (GUIs).

Hi, Previously I wrote about Pivot table, this time lets explore VLookup as this is also one of the very powerful and handy feature of Excel.

First lets understand why we make VLookup. A lot of people use Excel as a database, may be due to reasons like business requirement or unknown to the power RDBMS. Although excel can work as a database, some of the tasks that would be very easy in a database program are fairly complex in Excel. One of these tasks is matching two lists based on a common field; this can be easily accomplished using Excel VLOOKUP. In RDBMS, this concept is more like Primary key that is used to establish relation between two tables. You will find the function VLOOKUP to be extremely useful so check out an example of when and how to use this function below.

In this example, the lookup table is on a sheet named EmpMaster.

Create a Lookup Table:

Lookup formulas can work vertically, looking for values down a column, or they can work horizontally, looking for values across a row. In this example, the information will be stored vertically, with values down a column.

1. Enter the headings in the first row as show in the picture aside. pivot-empmaster
2. The first column should contain the unique key values on which you will base the lookup. In this example, you can find the salary for a specific Ecode.

VLOOKUP Function Arguments:

The VLOOKUP function has four arguments:

Emp Master worksheet

Emp Master worksheet

1. lookup_value: What value do you want to look up? In this example, the Ecode is in cell A7, and you want to find its Emp Name.
2. table_array: Where is the lookup table? If you use an absolute reference ($A$2:$C$5), instead of a relative reference (A2:C5), it will be easier to copy to formula to other cells. Or, name the lookup table, and refer to it by name.
3. col_index_num: Which column has the value you want returned? In this example, the Emp names are in the second column of the lookup table.
4. [range_lookup]: Do you want an exact match? Is an approximate match okay?
If you use TRUE as the last argument, or omit the last argument, an approximate match can be returned. This example has FALSE as the last argument, so if the Ecode is not found, the result will be #N/A. (Note: Excel is rather forgiving, and will accept 0 instead of FALSE, and 1 instead of TRUE.)

Create a VLookup formula:

Once you have created the lookup table, you can create other formulas in the workbook, and pull information from the Employee list. For example, to prepare Deptartment, you can enter a Ecode, and formulas will get the Emp Name or salary from the Employee table.

In this example, the Depot is created on a sheet named Dept. The VLOOKUP formula should find an exact match for the Ecode, and return the Emp name.

1. Select the Dept sheet
2. Enter Ecode A15 in cell A7
3. In cell B7, start the VLOOKUP formula:
=VLOOKUP(
4. Click on cell A7 to enter its reference.
5. Type a comma, to end the first argument
6. Select the EmpMaster sheet
7. Select cells A2:C5 (the Employee list)
8. Press the F4 key, to change the cell references to absolute. The formula should now look like this:
=VLOOKUP(A7,EmpMaster!$A$2:$C$5
9. Type a comma to end the second argument.
10. Type a 2, which is the column in the lookup table that contains the Emp name.
11. Type a comma to end the third argument.
12. Type FALSE, to specify that an exact match for the Ecode is found, and add the closing bracket.
13. The formula should now look like this:
=VLOOKUP(A7,EmpMaster!$A$2:$C$5,2,FALSE)
14. Press the Enter key to complete the formula. The Emp Name will be displayed.

Note: To return the salary(see picture below), create a VLOOKUP formula that refers to column 3 of the lookup table. For example, enter the following formula in cell C7:
=VLOOKUP(A7,EmpMaster!$A$2:$C$5,3,FALSE)

Emp Salary

Emp Salary

Now, you can select the B7 in Dept worksheet and drag it down and the VLookup formula will be copied. Now just fill the ECodes, the name and the salary will come automatically. and you are done.. voilla…

Yes yes you have just learned VLookup. Please put your comments, knowledge, suggestions, questions on this topic and any more interesting feature of Excel. Remember to Share!!!! Enjoy

Intel inside, celeron, Pentium family, dual core….. are we happy now. No, bound by the human nature we aren’t. We are bound by our DNA not to be satisfied and keep evolving things. Yes enter the world of  Multi Core Processor.

A multi-core processor is an integrated circuit (IC) to which two or more processors have been attached for enhanced performance, reduced power consumption, and more efficient simultaneous processing of multiple tasks.

A multi-processor system is different from a Dual core processor. In the former there are two separate CPUs with their own resources. In the later, resources are shared and the cores reside on the same chip. A multi-processor system is faster than a system with a dual core processor, while a dual core system is faster than a single-core system, all else being equal.

Multi-core processing is a growing industry trend as single core processors rapidly reach the physical limits of possible complexity and speed. Companies that have produced or are working on multi-core products include AMD, ARM, Broadcom, Intel, and VIA.

Technology, Technology and more Technology. Are we driving Technology or are we driven by Technology. Ha ha,, What difference it makes as long as we are benefiting from it. I think some day day we wont require any machines, computers, mobiles or any other gadgets of that sort. Our future generations will be Mutants in such a way that all these technologies will be part of us. What ur say, cast ur Poll…