Excel - refering cell data from one sheet to another

Sometimes we need to work on Excel sheet and its good to know some of the functions. When we need to create subtasks as multiple sheets and summary sheet. Summary sheet need to get the total from subtasks and provide grand total.
Copying the total into summary sheet would help, but what happens when we change some value in subtaks sheet, again the same value need to be copied. It is better to refer subtasks sheet value in the summary sheet. It is simple! Assume subtasks sheet names are "TAB1" & "TAB2", so in the summary sheet in the particular shell type

='Tab Name'!$ColumnName$RowNumber
example,
='TAB1'!$B$10
='TAB2'!$B$10

so whenever there is a change to subtasks this will be reflected immediately in summary sheet.

Distributed scalable open source

Now-a-days storing huge data remotely is common. "Anywhere" and "Anytime" is the main slogan against data. Store music/video/applications/exec/source, lots out there. When it comes to enterprise, this data need to be secure, highly available and cost effective. So building applications involves lots more steps, open source solutions are less. One interesting open source is Hadoop built on low hardware with simple replication solution.

related topics
Cloud computing
IBM article
Hadoop

Strange Windows XP: Windows explorer slows down to show mycomputer

For past one day whenever i open IE / Open Dialog box to open a file/save a file, explorer took almost 30secs to display folders. I could see "torch & folder animation :)", i never seen this before when i access local file.

After checking all the settings and playing around, i could figure out. There was a file sitting in my printer but printer had some problem with pooling. So i had to restart my system and printer, then everything works well.

Isn't it strange? i don't know what is the underlying logic behind printer issue affects viewing explorer.

Testing automation - Legacy system

We are in the process of moving from legacy system to UNIX system. Since it is production enterprise system, this need to be done by stages. So always need to keep legacy system running. This keeps us in supporting / testing both systems. We recently integrated Legacy system through SOCKET programming to test using ant script. Here is snippet,

<target name="legacytest">
    <telnet server="${legacy.host}" port="${legacy.port}"
 timeout="${legacy.timeout}" initialCR="yes">
 <read></read>
 <write>$NET:TYPE 6</write>
 <read>U#</read>
 <write>$NET:SET XON</write>
 <read>U#</read>
 <write>${legacy.login}</write>
 <read>UNITS</read>
   </telnet>
</target>

This does not come with standard ant installs, so commons-net-xxx.jar needs to be downloaded from this link and include under ant/lib directory.