IN EXCEL To format excel number in lakh(L) and thousand(K) only -: [<100000] 0.000,_)"K";#\.00,_)"L" To format excel number in lakh(L) and Crore(Cr) only -: [<10000000] #\.00,_)"L";#\.0000,_)"Cr" Video link --: https://youtu.be/sTtXI6r-f4A IN GOOGLE SHEET To write number according to Indian place value system [$₹][>9999999]##\,##\,##\,##0.00;[$₹][>99999]##\,##\,##0.00;[$₹]##,##0.00
Uttar Pradesh House Tax Calculation-: House Tax is calculated on Carpet area Carpet area = Covered area - 20% of Covered area Covered area is written on नक्शा given by MDA For Residential-: eg-: House Super area = 2200 sqft Note-: There is 20% difference between super area & covered area so, covered area = 2200 - 20% of 2200 covered area = 1760 sqft ~1800 sqft ( approx.) Note-: Carpet area is 20% less than Covered area so, Carpet area = 1800 - 20% of 1800 Carpet area = 1440 sqft Case 1: If you are living in that house, then 25% की छूट 27,000 - 25% of 27,000 =20,250 House tax of 1 year = 15% of 20,250 = 3038 Rs per year Case 2: If house is given on rent then there is no discount of 25% = 27,000 + 25 % of 27,000 = 33,750 House tax of 1 year = 15 % of 33,750 ...
HOW TO CALCULATE ELECTRICITY BILL Total electricity bill = F.C ( Fixed charge ) + E.C ( Electricity charge ) + E.D ( Electricity duty ) All F.C , E.C and E.D are written on bill downloaded through uppcl website. FOR, NON LIFELINE DOMESTIC CONSUMER - : 1) Fixed charge = 120 Rs / kw eg-: If Mr. X has 4KW connection in his house , then his fixed charge become = 120*4 => 480 Rs If 3 tenants are living in that house then 480 Rs get divided equally among 3 tenants so it become 480/3 => 160 Rs so each tenants have to pay 160 Rs as a fixed charge 2) Electricity charge ( 0 to 150 ) Unit ------> 5.5 Rs ( 151 to 30...
Comments
Post a Comment