Pages

Monday, 4 February 2013

Age Calculation

Method-1 :

You can calculate a persons age based on their birthday and todays date.
The calculation uses the DATEDIF() function.
The DATEDIF() is not documented in Excel 5, 7 or 97, but it is in 2000.
(Makes you wonder what else Microsoft forgot to tell us!)
Birth date : 1-Jan-60
Years lived : 53  =DATEDIF(C8,TODAY(),"y")
and the months : 1  =DATEDIF(C8,TODAY(),"ym")
and the days : 3  =DATEDIF(C8,TODAY(),"md")
You can put this all together in one calculation, which creates a text version.
Age is 53 Years, 1 Months and 3 Days
 ="Age is "&DATEDIF(C8,TODAY(),"y")&" Years, "&DATEDIF(C8,TODAY(),"ym")&" Months and "&DATEDIF(C8,TODAY(),"md")&" Days"

Method-2 :

This method gives you an age which may potentially have decimal places representing the months.
If the age is 20.5, the .5 represents 6 months.
Birth date : 1-Jan-60
Age is : 53.10  =(TODAY()-C23)/365.25


AutoSum Shortcut Key

Instead of using the AutoSum button from the toolbar,
you can press Alt and = to achieve the same result.
Try it here :
Move to a blank cell in the Total row or column, then press Alt and =.
or
Select a row, column or all cells and then press Alt and =.
Jan Feb Mar Total
North 10 50 90  
South 20 60 100  
East 30 70 200  
West 40 80 300  
Total        


Saturday, 5 January 2013

What Is Textile Fiber?

1- The fundamental component used in making textile yarns and fabrics.
2- Fibres are fine substances with a high ratio of length to thickness.
3- It is defined as one of the delicate, hair portions of the tissues of a plant or animal or other substances that are very small in diameter in relation to there length. A fiber is a material which is several hundred times as long as its thick.

OR

Textile fiber has some characteristics which differ between fiber to Textile fiber. Textile fiber can be spun into a yarn or made into a fabric by various methods including weaving, knitting, braiding, felting, and twisting. The essential requirements for fibers to be spun into yarn include a length of at least 5 millimeters, flexibility, cohesiveness, and sufficient strength. Other important properties include elasticity, fineness, uniformity, durability, and luster.
.
.


Thursday, 3 January 2013

What Is Textile ??

There are many words to explain “TEXTILE”, here are some short and sensible sentences to explain it.

• Anything that can be originated or generated from fiber is
called textile.
• In narrow sense fiber to fabric production is textile.
• In greater sense fiber to clothing/garment is textile.
.
.