Month: March 2009

Calculate age in Excel

I was fiddling my friends computer and found an excel file with age calculation function in it. So i searched through the net and found this article :
source : http://www.fontstuff.com/excel/exltut01.htm

Working Out a Person’s Age in Excel

How Excel Works with Dates

Excel considers dates as numbers. Each date is assigned a unique serial number. For example, the 27th September 1999 was date serial 36430. Fortunately, you don’t need to know this but the fact that all dates have numerical values can be very useful. Windows uses the 1900 date system in which 1st January 1900 is date serial 1, 2nd January 1900 is date serial 2 and so on.

Checking the serial number of a dateWhen you type a date into a cell, Excel shows you a date but is thinking of a number. 

To find out the serial number of a date, select the cell containing the date then go to Format > Cells. Go to the Number tab and click General in the Category list. The date’s serial number will appear in the Sample box on the right.

You can make use of these numbers in all sorts of ways. You can add a number to a date to give a date that number of days later (or subtract a number to get a date before), you can take one date from another to find out how many days in between. There are lots of ready-made date functions too.

Working Out a Person’s Age

A person’s age is the amount of time since they were born (I know you know that but the computer doesn’t, and we have to start thinking like the computer). So, all we have to do is put today’s date in one cell and the person’s date of birth in another cell, then take their date of birth away from today and you get their age – right? Well, sort of… you get a number. Because you took a date serial from another date serial you get the number of days in between*[note]. It looks like this…

Age shown as a number of daysIn this example the formula in cell A3 is:

=A1-A2

 

 

We need to convert this number of days into a number of years. Most years have 365 days but every fourth year has 366 days. So the average number of years is 365.25. Let’s modify our formula…

Age shown as a number of yearsIn this example the formula in cell A3 is:

=(A1-A2)/365.25

 

 

Note the brackets around the first part of the formula. Brackets mean “Work out this bit first…”. I’ve used them here to stop Excel trying to divide A2 by 365.25 before taking it away from A1. Excel formulas work do any multiplying and dividing before it does adding and subtracting, but anything in brackets gets done first.

Now we can see a number of years, but it’s still not quite right. We are getting an accurate result but we don’t really want to see the fraction. As a last refinement we’ll wrap the whole thing inside an INT() function to give us a whole number (an integer). This is better than changing the number of decimal places displayed, which would risk some numbers being rounded up and giving an incorrect result. Here’s the finished result…

Age shown as whole yearsIn this example the formula in cell A3 is:

=INT((A1-A2)/365.25)

 

 

*Note: In fact, to start with, you get another date. Confused? Don’t be… Excel is trying to help but has misunderstood what we need. In date calculations, the result cell gets automatically formatted the same way as the first cell in the formula. Because the first cell was formatted as a date Excel showed you the result as a date, although you wanted to see a number. Just reformat the cell manually by going to Format > Cells > General


Inserting Today’s Date Automatically

You can save yourself the effort of entering today’s date manually. Excel has a function, TODAY(), that creates the current date. All you need to do is place this function into the age calculation formula in place of the reference of the cell that had today’s date in it…

Age calculation using the TODAY() functionIn this example the formula in cell A2 is:

=INT((TODAY()-A1)/365.25)

 

 

How accurate do you need to be?

This formula yields pretty accurate results but it isn’t infallible. Dividing by the average number of days in a year works for most people most of the time, but sometimes it gets it wrong. Supposing the person in question is a child, who hasn’t yet lived through a 366 day year, you should be dividing by 365 and not 365.25. So how can we get an exact, guaranteed correct figure? Read on…


Using Nested IF Statements to Tell It Like It Is!

Supposing it’s August and you need to know old someone is…

  • The person was born in 1975. How old are they? You can’t say.
  • The person was born in August 1975. How old are they? You still can’t say.
  • A person was born on 23rd August 1975. How old are they? At last! You have enough information. You can say for certain.

In order to calculate someone’s age precisely you need to know the year in which they were born, and whether or not hey have had their birthday.

If the have had their birthday you subtract their birth year from the current year. If they have not yet had their birthday you subtract their birth year from the current year, and then subtract 1. Easy! We do it all the time without thinking about it. But explaining the rules to Excel is a bit more complicated. Here goes…

=IF(MONTH(TODAY())>MONTH(A1),YEAR(TODAY())-YEAR(A1),
 IF(AND(MONTH(TODAY())=MONTH(A1),DAY(TODAY())>=DAY(A1)),
 YEAR(TODAY())-YEAR(A1),(YEAR(TODAY())-YEAR(A1))-1))

I’ve written this calculation on three lines for clarity but you should write is as a single expression without spaces. It assumes that cell A1 contains the person’s date of birth. Here’s what it says…

  • IF(MONTH(TODAY())>MONTH(A1)
    If this month is later than the month of the persons birthday…
  • YEAR(TODAY())-YEAR(A1)
    …subtract the year in which they were born from this year because they must have had their birthday.

But what if we haven’t passed the month in which they were born. We might be in that month, or we might not have reached it yet. Let’s find out…

  • IF(AND(MONTH(TODAY())=MONTH(A1),DAY(TODAY())>=DAY(A1))
    If we are currently in the month of the person’s birthday and it is either their birthday today or we have passed it…
  • YEAR(TODAY())-YEAR(A1)
    …subtract the year in which they were born from this year because they must have had their birthday.

But what if this isn’t the month in which they were born. We know we haven’t passed their birthday so…

  • (YEAR(TODAY())-YEAR(A1))-1
    …subtract the year in which they were born from this year then subtract 1, because they haven’t had their birthday yet.

Phew!


About IF Statements

An IF statement contains three parts:

IF(Logical Test,Value If True,Value If False)

Logical Test: This is a question or circumstance than can be answered yes or no, or true or false.

Value If True: This is what the function should do if the answer to the test is yes or true.

Value If False: This is what the function should do if the answer to the test is no or false.

In other words, you ask a question. If the answer is yes you do one thing. If the answer is no you do something else. What the IF statement does could be to display a number or piece of text, or it can do a calculation (which is what is does in the example I’ve used here).

But what if you don’t have a simple yes/no question. The solution is a nested IF statement. Instead of inserting a number, piece of text or calculation, the value if true or value if false part (or both parts) can be IF statements themselves. They normally need a bit of working out (!) because they have to use the same logical process as Excel does. If it doesn’t work first time, try writing it a different way. And try “translating” it into English as I did above.

A nested IF statement says something like…

“If the answer is yes, do this. If the answer is no do this or this (depending on…”

And if you think the Age Calculator is complicated, consider the fact that Excel can handle up to seven (count them!) nested IF statements in a single calculation.

Advertisements

Kinza and Pen Drive Virus Removal

I saw a small .bat file Kinza Virus Remover in my friends PC. Download from here:

http://www.ziddu.com/download/6321132/kinzaremoval.zip.html

Some details could be found here :
source : http://www.troublefixers.com/remove-kinza-virus-with-free-kinza-removal-tool/

Remove Kinza Virus With Free Kinza Removal Tool

Trouble:

There are hell lot of virus which infects Windows and makes your computer respond slowly to each action. One such virus is Kinza.exe virus. It comes normally through virus infected pen drives and Internet.

virus-in-pen-drive

What does Kinza.exe Virus do ?

Firstly it makes your computer too slow in doing anything, restricts to use Task Manager, Regedit, Command Prompt, msconfig and Group Policy etc. All these windows tool like task manager or command prompt or regedit flashes for a second when user try to launch them and then nothing happens.

All these tools opens for few seconds and then close themselves, most common example would be command prompt flashes for a second when tried to be launched. Kinza virus also disable folder options in windows and remove folder options from windows explorer. It creates a lot of exe and boot.vbs files which got executed on system startup.

Let’s see how to remove kinza virus from your infected computer system.

Fix:

In order to remove kinza virus, you will need to download the Kinza Virus Removal Patch and run it in the Windows’s safe mode.

Note: Make sure to turn off system restore before using kinza removal tool.

How to Use Kinza Removal Tool

( Download Link to kinza removal tool is given at the bottom )

1. Restart your computer in safe mode, for this you will need to press F8 at the time of Windows  boot to enter in Windows Safe Mode.

2. Run Kinza Removal Tool to delete kinza virus from your system.

3. Delete temp files and Internet temp file.

Download Kinza Removal Tool

And then ….

source : http://www.troublefixers.com/remove-your-pen-drive-and-autorun-viruses-with-smart-virus-remover/

Remove your pen drive and autorun viruses with smart virus remover

window.google_render_ad(); Trouble:

We receive a majority of virus problems which are due to virus which spread through pen drives, cd’s and other portable devices like mp3 players, ipod etc.

smart-virus-remover

Today, we have come up with a free tool called smart virus removal by Muhammad Abdullah. This small tool will let you remove a group of viruses from your system including the following list of viruses.

  • Virus.Win32.Agent.aw.a
  • Virus.Win32.AutoIt.a.a
  • Virus.Win32.AutoRun.abt.a
  • im.worm.win32.sohanad.bm.a
  • im.worm.win32.sohanad.t.a
  • Trojan.Win32.Agent.abt.aTrojan-Downloader.Win32.AutoIt.aa.a
  • Trojan-Downloader.Win32.AutoIt.q.a
  • Trojan-PSW.Win32.OnLineGames.mgw.com.a
  • Trojan-PSW.Win32.OnLineGames.pno.a.com
  • Virus.Win32.AutoRun.ajn.com

Let’s see how can you use smart virus remover tool to eliminate any on these mentioned viruses from your computer or pen drive.

window.google_render_ad();
window.google_render_ad();Fix:

Smart Virus Remover is simple tool which gives you four main options for virus removal, which includes:

  • Delete Autorun.inf files
  • Restore Windows to default settings
  • Remove Virus  from a Folder
  • Remove Virus from USB

If your windows drive does not open mouse double click, you can also easily delete those autorun.inf files which stops a drive being opened on mouse double click, this utility will be most help full in such a kind of associations.

We hope this tool which will help delete autorun.inf viruses from your computer and also on other portable drives, Smart virus removal tool was quit forum like History, EULA,Disclaimer, Newer Version Check .

Download Smart Virus Remover

Boost Windows Portable App

source: BOOST WINDOWS 2009+Portable VERSION(MUST HAVE!!)

[Image]

With Boost Windows 2009, you can complete the system optimization in a few “Next” clicks. Your Windows will be fine-tuned to a perfect status – like it was just completely reinstalled with all updates, fast, reliable, and safe.
You may also know, your Windows system is not running at its perfect state. The reason may be verbose services, unnecessary install files, huge amount of temporary files and disk cache size, etc. All these will cause Windows slow and unstable, you will often see program crash, downloading become slower and slower.
With Boost Windows 2009 running regularly, you can keep Windows clear and stable, never have pain to reinstall Windows time to time. From our tests, Boost Windows 2009 can boost Windows system for 30% to 50%, including boot and shutdown, program running performance, game FPS, etc.

Features:
* Speed up CPU cache
* Speed up Internet Dial-up speed
* Speed up disk speed
* Speed up system startup and shutdown
* Improve stability
* Improve Game experience
* Wipe unnecessary junk files
* Repair bad registry
* and much more!

[Image]

http://rapidshare.com/files/191389009/BoostWindows2009__PORTABLE.rar

Install and play N-Gage games on N96, N78 & N82.

Install and play N-Gage games on N96, N78 & N82.
Hi,I just read a post saying that you cannot hack N96
http://www.ipmart-forum.com/showthread.php?t=312411
But you can actually install the cracked N-Gage games without having to actually hacking the phone, it wasnt the easiest of tasks but collecting infromation from from the ipmart’s forums and put em together to install and play:
1- Get a certificate from
http://www.ipmart-forum.com/showthread.php?t=268715
thanks to jomafi for his efforts
2- Follow this thread to unsign the games from binpda’s signature and sign em under your certificate as under:
http://www.ipmart-forum.com/showthread.php?t=313744
(Thanks wajiman, you completed the hardest step). these files are still cracked but now hold the user’s correspondent certificate
3- Install the original n-gage latest version 1.10.1345
http://www.ipmart-forum.com/showthread.php?t=306772
and download the Patch/UnPatch file (thanks Deltafox)
4- Copy the selfsigned .n-gage files to N96 (through PC Suite for example). After installation (Browse through File Manager and run the file) all the games appear as Trial (correct so far)4- Patch N-Gage through the Patch/UnPatch file, the games are now full version. Some games will still ask you to register or keep using as trial even after this patch. If you select trial you will be able to fully play the game. The games I tried: Simes 2 Pets, Space Impact and Poker (pocker installed fully, no trial).
5- important: you cannot install games while having the patched version, simply un-patch it using the same file; install the game(s) you want to add and then re-patch it6- If you downloaded a BINPDA release that has the game in a exe file, run the release without having your phone plugged in and the application will allow you to extract the .n-gage file to your computer, then you can proceed through point 2Voila!Thanks to all the people mentioned above and most of all BINPDA for their efforts, keep up the great work. Help keep up Ipmart guys n gals,PS: As it is indicated below, these steps can be also applicable to the othe unhacked mobiles such as N78 & N82, but I only verified it against my N96. People, please provide your feedback if you try it against the other phone models.
by rnicolas
Source 🙂
http://www.ipmart-forum.com/showthread.php?p=2443619#post2443619