Sunday, December 8, 2013

Conversion / Convert Chart for Square Feet to Square Metres

sq.ft           sq.m
1                     0.09
1.25                0.12
1.50                0.14
1.75                0.16
2                     0.19
2.25                0.21
2.50                0.23
2.75                0.26
3                     0.28
3.25                0.30
3.50                0.33
3.75                0.35
4                     0.37
4.25                0.39

*Formula :- 1 sq.ft = 0.0929 Sq.m 

Click here to Download Conversion Table:- Sky kish

Sky kish

Tuesday, December 3, 2013

EXCEL FORMULAS :-

EXCEL SOME EXAMPLE FORMULAS
Ctrl + ; Date
Ctrl + Shift ; Time

Cases Formula 
UPPER   CASE      :-  =UPPER(A2)           SKYKISH
LOWER CASE      :-  =LOWER(A2)          skykish
UPPER CASE        :-  =PROPER(A2)         Skykish

Combine first and last names 

A                    B
First Name    Last Name
Nancy           Davolio
Andrew         Fuller
Formula Description (Result)
=A2&" "&B2 Combines the names above, separated by a space (Nancy Davolio)
=B3&", "&A3 Combines the names above, separated by a comma (Fuller, Andrew)
=CONCATENATE(A2," ",B2) Combines the names above, separated by a space (Nancy Davolio

Compare one cell to another cell
Data
BD122
BD123
BD123
Formula Description (Result)
=EXACT(A2,A3) Compare contents of A2 and A3 (FALSE)
=EXACT(A3,A4) Compare contents of A3 and A4 (TRUE

Check if a cell has any text in it

Data
Davolio
123
Formula Description
=ISTEXT(A2) Checks to see if cell A2 has text (TRUE)
=ISTEXT(A3) Checks to see if cell A3 has text (FALSE)

Convert measurements 

A)  Data
6
Formula Description (Result)
=CONVERT(A2,"C","F") Convert 6 degrees Celsius to Fahrenheit (42.8)
=CONVERT(A2,"tsp","tbs") Convert 6 teaspoons to tablespoons (2)
=CONVERT(A2,"gal","l") Convert 6 gallons to liters (22.71741274)
=CONVERT(A2,"mi","km") Convert 6 miles to kilometers (9.656064)
=CONVERT(A2,"km","mi") Convert 6 kilometers to miles (3.728227153)
=CONVERT(A2,"in","ft") Convert 6 inches to feet (0.5)
=CONVERT(A2,"cm","in") Convert 6 centimeters to inches (2.362204724)

B)  Data

Formula Description (Result)
=CONVERT(1.0, "lbm", "kg") Converts 1 pound mass to kilograms (0.453592)
=CONVERT(68, "F", "C") Converts 68 degrees Fahrenheit to Celsius (20)
=CONVERT(2.5, "ft", "sec") Data types are not the same so an error is returned (#N/A)
=CONVERT(CONVERT(100,"ft","m"),"ft","m") Converts 100 square feet into square meters (9.290304).

Convert between time units

Data
6
Formula Description (Result)
=CONVERT(A2,"day","hr") Convert 6 days to hours (144)
=CONVERT(A2,"hr","mn") Convert 6 hours to minutes (360)
=CONVERT(A2,"yr", "day") Convert 6 years to days (2191.5)

Count all of the cells in a range

Data Data Data Data
15,000 28,500    55,000 87,000
9,000 13.700  63,800 23,000
8,000 1000 19,000 99,900
Formula Description (Result)
=ROWS(A1:D4) * COLUMNS(A1:D4) The total number of cells in the range (16)

Count numbers greater than or less than a number

Salesperson      Invoice
Buchanan      15,000
Buchanan        9,000
Suyama                8,000
Suyama              20,000
Buchanan        5,000
Dodsworth      22,500
Formula Description (Result)
=COUNTIF(B2:B7,">9000") Numbers above 9000 (3)
=COUNTIF(B2:B7,"<=9000") Numbers less than or equal to 9000 (3)
=SUMPRODUCT((B2:B7>=9000)*(B2:B7<=22500)) The SUMPRODUCT function counts the number of cells in the range B2:B7 that contain numbers    greater than or equal to 9000 and less than or equal to 22500 (4).

Calculate the factorial of a number

Data
6
Formula Description (Result)
=FACT(A2) Factorial of 6, or 6*5*4*3*2*1 (720)
=FACT(3) Factorial of 3, or 3*2*1 (6)
=FACT(A2+4)  Factorial of 10 (3628800)

Raise a number to a power
A B
Formula Description (Result)
=POWER(5,2)  Calculates five squared (25)
=5^3  Calculates five cubed (125)



Accountancy & Commerce Practice Notes :-

Click here to Download Part I   :-  Sky kish
Click here to Download Part II :-  Sky kish
ONLINE ANSWER GETING :-

Wikipedia                                 :- Skykish
Business Dictionary             :- Skykish
Opposite word Finder         :- Skykish
CREATE AN EMPLOYEE SALARY SHEET WITH USING FORMULAS:~

IDNAMEDEPTDESBASIC DAHRAGROLOANPFDEDUNET SAL
1SKYACCCLR1000050006000210009001200210018900
2KISHCOM JM250001250015000525008763000387648624
3SHILFORDGM200001000012000420008752400327538725
4LORDREVGM300001500018000630006003600420058800
5GODMARSM250001250015000525006503000365048850
6WATERLANAM1500075009000315009801800278028720
7RAINLEGJM200001000012000420004522400285239148
8SNOWHRMD350001750021000735003604200456068940
9GREENCOM ACC1500075009000315005401800234029160
10YELOWRILTYST5000250030001050085060014509050
11PINKAUDTYST56002800336011760850672152210238


NOTE :-
FORMULAS :
DA=BASIC*50/100
HRA=BASIC*60/100
GROSS=BASIC+DA+HRA
PF=BASIC*12/100
DEDUCTION=PF+LOAN
NET SALARY=GROSS-DEDUCTION


                                                                                                                     Prepared by /-          
                                                                                                                          Sky kish               

Monday, December 2, 2013

Mutation Podi Babtu Hakku Dakalathi Tippani Book Formate:-

 
Click here to Download Formate :- Sky kish
 Sky kish
INCOME TAX SLABS FOR THE PERIOD OF 2013-14 :-

Income Tax Slabs and Rates  Assessment Year 2013-14 (Financial Year 2012-13)

  1. Individual resident below 60 years of age (i.e. born on or after 1st April 1953) or any NRI / HUF / AOP / BOI / AJP * Income-tax:Calculate Tax Liability for AY 2013-14.

        
Income Slabs                                           
i. Where the total income does not exceed Rs. 2,00,000/-.                                
ii. Where the total income exceeds Rs. 2,00,000/- but does not exceed Rs. 5,00,000/-.   
iii. Where the total income exceeds Rs. 5,00,000/- but does not exceed Rs. 10,00,000/-.   
iv. Where the total income exceeds Rs. 10,00,000/-.    
       
           

Income Tax Rate
i. NIL
ii. 10% of amount by which the total income exceeds Rs. 2,00,000/-
iii. Rs. 30,000/- + 20% of the amount by which the total income exceeds Rs. 5,00,000/-
iv. Rs. 130,000/- + 30% of the amount by which the total income - exceeds Rs. 10,00,000/-.

Surcharge: Nil 
Education Cess: 3% of the Income Tax.
*Abbreviations used: NRI - Non Resident Individual; HUF - Hindu Undivided Family; AOP - Association of Persons; BOI - Body of Individuals; AJP - Artificial Judicial Person




2. Individual resident who is of the age of 60 years or more but below the age of 80 years at any time during the previous year (i.e. born on or after 1st April 1933 but before 1st April 1953) Income-tax:Calculate Tax Liability for AY 2013-14. 



Income Slabs                                                   
i. Where the total income does not exceed Rs. 2,50,000/-.                               
ii. Where the total income exceeds Rs. 2,50,000/- but does not exceed Rs. 5,00,000/-   
iii. Where the total income exceeds Rs. 5,00,000/- but does not exceed Rs. 10,00,000/-   
iv. Where the total income exceeds Rs. 10,00,000/-   
            

Income Tax Rate
i. NIL
ii. 10% of the amount by which the total income exceeds Rs. 2,50,000/-.
iii. Rs. 25,000/- + 20% of the amount by which the total income exceeds Rs. 5,00,000/-.
iv. Rs. 125,000/- + 30% of the amount by which the total income exceeds Rs. 10,00,000/-.

Surcharge: Nil
Education Cess: 3% of the Income Tax.
Individual resident who is of the age of 80 years or more at any time during the previous year (i.e. born before 1st April 1933)




3. Individual resident who is of the age of 60 years or more but below the age of 80 years at any time during the previous year (i.e. born on or after 1st April 1933 but before 1st April 1953) Income-tax:Calculate Tax Liability for AY 2013-14. 


 Income Slabs                                                       
i.    Where the total income does not exceed Rs. 5,00,000/-.                                   
ii.    Where the total income exceeds Rs. 5,00,000/- but does not exceed Rs. 10,00,000/-   
iii.    Where the total income exceeds Rs. 10,00,000/-           
           
Income Tax Rate
 

i. NIL
ii. 20% of the amount by which the total income exceeds Rs. 5,00,000/-.
iii. Rs. 100,000/- + 30% of the amount by which the total income exceeds Rs. 10,00,000/-.
Surcharge: Nil
Education Cess: 3% of the Income Tax.


4. Co-operative Society Income-tax:Calculate Tax Liability for AY 2013-14 
Income Slabs                                                       
i. Where the total income does not exceed Rs. 10,000/-.                               
ii. Where the total income exceeds Rs. 10,000/- but does not exceed Rs. 20,000/-.           
iii. Where the total income exceeds Rs. 20,000/-         
                  
Income Tax Rate
i. 10% of the income.
ii. Rs. 1,000/- + 20% of income in excess of Rs. 10,000/-.
iii. Rs. 3.000/- + 30% of the amount by which the total income exceeds Rs. 20,000/-.
Surcharge: Nil

Education Cess: 3% of the Income-tax.



Firm :-
Income-tax: 30% of total income.Calculate Tax Liability for AY 2013-14
Surcharge: Nil
Education Cess: 3% of the Income Tax.

Local Authority :-
Income-tax: 30% of total income.Calculate Tax Liability for AY 2013-14
Surcharge: Nil
Education Cess: 3% of the Income Tax.

Domestic Company :-
Income-tax: 30% of total income.Calculate Tax Liability for AY 2013-14
Surcharge: The amount of income tax as computed in accordance with above rates, and after being reduced by the amount of tax rebate shall be increased by a surcharge at the rate of 5% of such income tax, provided that the total income exceeds Rs. 1 crore. Education Cess: 3% of the total of Income Tax and Surcharge.

Company other than a Domestic Company :-
Income-tax:-   @ 50% of on so much of the total income as consist of (a) royalties received from Government or an Indian concern in pursuance of an agreement made by it with the Government or the Indian concern after the 31st day of March, 1961 but before the 1st day of April, 1976; or (b) fees for rendering technical services received from Government or an Indian concern in pursuance of an agreement made by it with the Government or the Indian concern after the 29th day of February, 1964 but before the 1st day of April, 1976, and where such agreement has, in either case, been approved by the Central Government.
@ 40% of the balance
Surcharge:- The amount of income tax as computed in accordance with above rates, and after being reduced by the amount of tax rebate shall be increased by a surcharge at the rate of 2% of such income tax, provided that the total income exceeds Rs. 1 crore. Education Cess: 3% of the total of Income Tax and Surcharge.

Disclaimer:- All efforts are made to keep the content of this site correct and up-to-date. But, this site does not make any claim regarding the information provided on its pages as correct and up-to-date. The contents of this site cannot be treated or interpreted as a statement of law. In case, any loss or damage is caused to any person due to his/her treating or interpreting the contents of this site or any part thereof as correct, complete and up-to-date statement of law out of ignorance or otherwise, this site will not be liable in any manner whatsoever for such loss or damage.    


Click here to On-line Calculate Your Income Tax :- Sky kish

Sky kish