Thursday, 17 December 2015

Warning of Dynamic Data type not Supported

         In order to avoid the Dynamic Data type not Supported, we got to modify the supportDynamic.txt file, with the corresponding Component.

The File needs to be modified is :

C:\Studio\plugins\org.talend.core.tis_5.5.1.r118616.jar\resources\supportDynamic.txt file.

Putting SICK LEAVE ...................Like Such



  • I am better today but still not 100%.  I will take a sick day today and be back online on Friday.



  • I am a bit under the weather. I am taking a sick day.



  • I just came back from vacation with lot of body pains and I am generally exhausted. I will take a sick day today. 



  • I am not feeling well. Hence taking a day off today.



  • Am still down with sunstroke as I still feel dizzy however fever is gone now, and am making speedy recovery.Looking forward to come back to work super charged.I really appreciate your support, that helps a lot.



  • I woke up with a severe back ache. I will rest up during the day. Sorry for the inconvenience.



  • I got a stomach bug over the weekend. I need to take a sick day today.



  • I am taking off today. I am suffering from cold and fever.



  • I have high fever with body pains and I will not be able to come in today.



  • Not feeling better even today.



  • Caught severe fever and stomachache over the night. Not in a position to turnup to the office.

Knowing About HEART BEAT


         Your heart rate, or pulse, is the number of times your heart beats per minute.

The best places to find your pulse are the:

wrists
inside of your elbow
side of your neck
top of the foot

                  To get the most accurate reading, put your finger over your pulse and count the number of beats in 60 seconds

                   Your resting heart rate is the heart pumping the lowest amount of blood you need because you’re not exercising. If you’re sitting or lying and you’re calm, relaxed and aren’t ill, your heart rate is normally between 60 (beats per minute) and 100 (beats per minute),

                    A slow heart rate can be a sign that you're healthy and fit.
                    An athlete's heart muscle is in better shape, so it doesn't have to work as hard to keep up a steady beat.

How Other Factors Affect Heart Rate

Air temperature: When temperatures (and the humidity) soar, the heart pumps a little more blood, so your pulse rate may increase, but usually no more than five to 10 beats a minute.
Body position: Resting, sitting or standing, your pulse is usually the same. Sometimes as you stand for the first 15 to 20 seconds, your pulse may go up a little bit, but after a couple of minutes it should settle down.
Emotions: If you’re stressed, anxious or “extraordinarily happy or sad” your emotions can raise your pulse.
Body size: Body size usually doesn’t usually change pulse. If you’re very obese, you might see a higher resting pulse than normal, but usually not more than 100.
Medication use: Meds that block your adrenaline (beta blockers) tend to slow your pulse, while too much thyroid medication or too high of a dosage will raise it.

Heart Beat Vs BloodPressure

Sometimes your heart rate and your blood pressure go hand in hand.
 For example, when you exercise, or get angry or scared, they both go up.

But they're not always linked. If your heart rate is normal, your blood pressure may not be. It could be too high or too low, and you may not realize it.

Even if your heart rate seems fine, get your blood pressure checked regularly.

SUMMARY :

  • Normal Heart Beat Should be between 60-90 beats per minute.
  • But for Athelets it would be 40 beats per minute.
  • we can hold our Wrist with thumb and count the Pulses for 20 seconds with a timer set.Then Multiple with 3 for the count you get, which results the Heart beats per minute of yours.





Getting DATE & TIME separate from Datetime DATA

Getting Date from Datetime DATA

TalendDate.formatDate("dd-MM-yyyy", row1.myDate)

Getting Time from Datetime DATA

TalendDate.formatDate("HH:mi:ss", row1.myDate)

For Testing in Talend:

TalendDate.formatDate("dd-MM-yyyy", TalendDate.parseDate("dd-MM-yyyy HH:mi:ss",row1.myString))

Wednesday, 16 December 2015

APPS for TELUGU STORIES for CHILDREN

ANAGANAGA-- Consists of Janapada,Panchatantra, Betala Stories.
                               Elder people can read the stories to their children at bed time.

TELUGU SLATE---Older people can make their children to learn Telugu Language easily by this.

TELUGU FOR KIDS-- Consists of Telugu Grammer,Stories,English Rhymes, Poems etc.

Tuesday, 15 December 2015

About TASTE BUDS

Taste Buds count  in Humans( < 50 years)  : 10000

Taste Buds count  in Older People ( >55 years)  : 5000

Taste Buds gradually reducing when people reach the age of 50+.

People can't recoginize  the Tastes of Sweetness and  Saltness becoz of this after passing the age 50.

But, Good thing is can recognize the Bitterness and Sour.

Thursday, 10 December 2015

Need to Work on PDF?

1)URL :   ilovepdf.com

Once you go to the above URL, you can find so many converters like below

EXCEL TO PDF
MERGE PDF
SPLIT PDF
COMPRESS PDF
WORD TO PDF
JPG TO PDF
PDF TO JPG
POWERPOINT TO PDF
PAGE NUMBERS
WATERMARK
UNLOCK PDF
ROTATE PDF

Click on the necessary one and convert it to PDF by supplying the SOURCE FILE.


Some other sites which also provides similar activities.

2)http://www.pdfforge.org/
3)http://smallpdf.com
4)www.paperjet.com

Thursday, 3 December 2015

TRICKS Every Windows & Mac user should know

Only screenshot the part of the screen you want.                                          

If you only need to screenshot part of the screen, there's a simple way to do it for both Windows and Macs.
For Mac: "Command," plus "Shift," plus "4" brings up the tool. Then you just drag the area you want.

For Windows: Just go to "Start" and then look for "Snipping Tool."                                                            



Repeat your last command in Excel

If you press the F4 button in Excel it repeats the last command. Here's an example given on Reddit: "If you select a cell and highlight it yellow, you can then highlight any other selected cell(s) yellow by pressing F4."

                                                     Make a copy of a file by just dragging it

                                                                       All you have to do to make a copy of a file on a Mac is hold the "Alt" key ("Control" if you are using a PC) and then click and drag the file. This will make a copy that you can drop anywhere you want by un-clicking.


Reverse search an image in Chrome

In Google Chrome, if you press "S" while you right click on an image it will do a reverse Google search. That means you'll be able to see where that photo is and where it potentially originated.

                                                          Pause YouTube with one click, or skip backwards and forwards 10 seconds

                                                                            Most people know you can hit the spacebar to pause a YouTube video, but sometimes this causes it to scroll down the page if you haven't already clicked on the video. If you press "K," this will play (or pause) the video every time.

Hitting the "J" key will cause you to go backward 10 seconds, while hitting the "L" key will make you go forward 10 seconds.

Move your window to any side of the screen, or to the next monitor

If you click the "Windows" key, plus one of the arrows (right, left, up, down), your current window will move to that side of the screen. Similarly, "Windows," plus "Shift," plus one of the arrows will move your window into whatever monitor is that way (right, for example).

Unfortunately, this only works for Windows machines.

                                                                       Clear your cache in seconds

                                                                                             Quickly clear your cache by pressing "Control," plus "Shift," plus "R." This will also refresh your page.

Get back that tab you accidentally closed

If you want to get back a tab you closed, just press "Control" (or "Command" on Mac), plus "Shift," plus "T," and it will magically reappear.





                                    


Wednesday, 2 December 2015

What happens when you accidentally transfer money to wrong bank account ?

Only “Account number” matters for online transfer

Let me give you shock of your life now.
Do you also think that if you transfer money to someone by adding their name, accounts number and IFSC code and if one of those does not match the transaction should fail and you should get back your money in your account. Right ?
But its far from reality ! . As per RBI guidelines, at the end of the day only bank account number should matter and name of the account holder and IFSC code are additional information which should be ideally checked by bank on their end, but there is no rule like that.
If you mess up with the account number, the transaction can go through you the money will be transferred. Its totally a bank choice and a “suggestion” from RBI to banks that they should ideally match Name and IFSC code before the transaction, but its not mandatory.

Responsibility lies with the remitter and not beneficiary
As per RBI directions, the final and sole responsibility of cross checking the account number, Name of the account holder, amount and every other detail lies with the remitter (the person who is sending money) and not the beneficiary (who is getting the money) . You can check numerous times before clicking the final button and after that no one else is responsible for your loss or transaction.
You as customer can not blame the bank to not check details at their end. There are thousands of cases where while typing the account number, one last digit got interchanged with another digit and the person did not realise this and their money is then at stake and in most of the cases , they never got it back. (You can learn more about NEFT and RTGS here)
If the account number does not exist, then surely the money will come back to you, because there is no valid destination to send the money. But if the account number exists and its active, then there are high chances that the transaction will go through .

What you should do if you have accidentally transferred money to wrong bank account ?

If you have made a mistake of transferring the money to a strangers account, then you should follow these steps mentioned below
The first step is to make sure you inform your bank the moment you realise that unintended money transfer has taken from from your end. The bank will then contact the beneficiary account holder and try to explain the situation to them. They will ask the account holder to give them permission to reverse back the transaction. In most of the cases, I have read on internet that the recipient of the money have agreed for the reversal (We have good people in this world, despite widespread belief that world is evil) .

 Precautions you should always take while transferring money Online ?

Precaution is better than cure, I personally believe that we are ourself responsible for any money transfer done online. Nothing stops us from taking extra precautions while transferring money online.
Lets see few things you can do ..
Trick #1 – Use CTRL-F to verify your account number
Most of the times, we are typing an account number which we have got in our emails, we look at the number (few digits at times) and then type it in other window when we are adding the beneficiary. What I personally do is once I have typed the account number (you cant copy paste the account numbers in all the bank website, as its disabled) . In that case you can just copy your account number from email, and type CTRL-F and paste the number there and you can visually see if it matches with what you just typed.
Trick #2 – Transfer Rs 1 first and test the transaction incase of big amounts
If you are transferring a big amount to someone, you can go one step ahead and first transfer Rs 1 and then confirm with the beneficiary if they have got it, and then on confirmation, you can trasfer the full amount. But I suggest to use it only in extreme situations when you really want to make sure if the account is genuine or not. At times, you might come across someone who gives you their account number and you are aware that they are careless by nature, and might have made some mistake while sharing account number, In that case you can take this extreme precautionary step ! .
Trick #3 – Verify the account number from right to left
Generally we are programmed to read left to right and we also match the account number that way, truly speaking, it might happen that we sometimes get fooled by our own confidence (4 zero , might look like 5 zero) .. So its better to also cross check the account number digit by digit from right to left. I personally cross check an account number digit by digit 2-3 times because I transfer any money online. I have never faced any issue of wrongly sending money to strangers account or sending excess money by mistake (One excess Zero in 10,000 and it becomes 1 lac) ..

Spend 1 extra minute to save your self big trouble

I hope you are clear by now that its your mistake if you transfer money to someone else account and you cant held someone else responsible for your mistake. Hence its always better to add the beneficiary account with precaution. Always cross check the account number 2-3 times.

When exactly does PPF account mature ? Answer is not 15 yrs !

When does a PPF account mature ? If you thought that its 15 yrs from the date you started your PPF account, then you are wrong ? Yes – there is a myth around this topic and most of the people do not know how does it actually work.
Its extremely simple to find out when exactly your PPF account matures, and let me show you how to calculate it!

How is PPF maturity date calculated for PPF account ?

The maturity period for PPF account is 15 years from the close of the financial year in which the initial subscription was made. Its that simple. So if you open your PPF account on 4th Nov 2014, this date lies in the financial year 2014-2015 , then the financial year ends on 31st Mar, 2015 . So the 15 yrs will be calculated from this date (31st Mar, 2015) and the lock in year would be 2015+15 = 2030 . So the exact date would be 1st Apr, 2030 in this case.
Note that PPF maturity always happens on 1st Apr , and not any random date of a year. Most of the people just add 15 yrs to the date of opening of PPF account to find out the maturity date.
So technically your PPF account can mature in 16 yrs in best case, suppose you open your PPF account in the first week of Apr, then your 15 yrs will be calculated from the next year (financial year ends on 31st Mar of the next year).

Hidden EPF Rules which will blow your mind

1: You can also nominate someone for your EPF

Do you know that there is also “nomination” facility in EPF? The nominee will be contacted at the time of death of the person and handed over the money from the provided fund. However if nomination is not present (which you should check), it can rise to all sort of issues while claiming money.
There is a form called Form 2 which has to be filled to change or update the nomination. Please contact your company finance department or directly send the form to EPFO department.

2.One can get pension under EPF


Do you know that there is something called EPS (Employee Pension Scheme) in provident fund? The EPF part is actually for your provided fund and EPS is for your pension.
The 12% contribution made by you from your salary goes into your EPF fully, but the 12% contribution which your employer makes, out of that 8.33% actually goes in EPS (subject to maximum of Rs 1250) and the rest goes into EPF. So understand it this way, a part of your employer contribution actually makes up your pension corpus. But there are some caveats to this.
  • One is liable for pension only if one has completed the age of 58.
  • One is liable for pension only if he has completed 10 yrs of service (in case of more than one companies, the EPF should have been transferred, not withdrawn)
  • The minimum Pension per month is Rs 1,000
  • The maximum Pension per month is subject to maximum of Rs 3,250 per month.
  • Lifelong pension is available to the member and upon his death members of the family are entitled for the pension.

3.No interest is given on EPS (pension part)


You must be thinking that you regularly get compound interest each year on your contribution + employer contribution. But it does not work like that. The compound interest is provided only on EPF part. The EPS part (8.33% out of 12% contribution from your employer or Rs 1250 whatever is minimum) does not get any interest. At the time of PF withdrawal, you get both EPF and EPS.

4: You might not get 100% of your Provident Fund money

Imagine your contribution + employer contribution has been total Rs 3,50,000 till date. Out of this 3,50,000 , suppose 2,50,000 has gone in EPF , and rest 1,00,000 has gone in EPS (for pension) . Now if you quit your job in 6th year of employment and opt for withdrawal of your Provided Fund money (EPF + EPS actually) , then do you think you will get total 3,50,000 . NO !
That’s because you always get 100% of your EPF part, but for EPS there is separate rule . There is something called Table ‘D’ , under which its mentioned how much you get at the time of exit from your job, there is a slab for each completed year and you get n times of your last drawn salary (depending on the completed year of service) subject to maximum to Rs 15,000 per month.
So if your salary in this case was Rs 30,000 per month, still you will be given only 15,000 * 6.40 = Rs 96,000.

Note that the table D is up to 9 yrs only, because if 10 yrs are crossed, then you are liable for pension.

5: You can invest more in Provident Fund, its called VPF

You can always invest more than 12% of your basic salary in Employee Provident Fund which is called VPF (Voluntary Provident Fund). In this case the excess amount will be invested in PF and you will keep on getting the interest, but the employer is not supposed to match your contribution. He will just invest up to maximum of 12% of your basic, not more than that.

6: Withdrawing of EPF amount at job change is illegal

Almost everyone thinks that withdrawing of your Employee Provident Fund amount after a job switch is totally fine and allowed, however as per the EPF Rules, it’s illegal.
You can only withdraw your Employee provident fund money, only if you have no job at the time of withdrawing your money and if 2 months have passed. Only transfer is allowed in case you get a new job and you switch to it. While there are no cases where EPF office tracks these things and takes up this matter, still just for your information you should know that if you got a new job and took it and then you are applying for withdrawal, it’s illegal as per law.
However in case of EPS, if the service period is less than 10 years, you’ve option to either withdraw your corpus or get it transferred by obtaining a ‘Scheme Certificate’. Once, the service period crosses 10 years, the withdrawal option ceases. Just for your information, you can withdraw your EPF money without the help of past employer signature by attesting your withdrawal form by a bank manager or some gazette officer. I hope you are clear about EPF withdrawal rules.

7: One can opt out of EPF if he wants

Yes!. I know this might be a surprising fact for many , but if one’s basic salary per month is more than Rs 15,000, he has an option to opt out of PF and not be part of it. In which case he will get all his salary in hand (without anything deducted every month).
But the sad part is that one has to opt out of Provident Fund in the start of his job. If a person has been part of EPF even once in his life, then he can’t opt out of it. So if you have already had EPF in your life. This option is not for you, but if you are new to job and your PF account number still does not exist, you can tell your employer that you don’t want to be part of Employee provident fund . You will have to fill up form 11 for this.

8: Your EPF gives you some life insurance too

A lot of people might not know that in case a company is not providing group life insurance cover to its employees, in that case the employee is given a small life cover through EPF. This is because there is something called Employees’ Deposit Linked Insurance (EDLI) scheme and your organization has to contribute 0.5% of your monthly basic pay, capped at Rs 15,000, as premium for your life cover.
However companies which already have life insurance benefits to employees as part of the company, are exempted from this EDLI scheme. The bad part of this EDLI scheme is that the life cover under this option is very low and that’s maximum amount of Rs. 60,000. While this is peanuts for most of the people in big cities. For employees in small scale industries and small cities, this amount of Rs 60,000 will still count something.

9: You can use EPF money can be withdrawn at special occasions

So now you know that EPF withdrawal is not permitted if you are still working. But there are occasionswhen Employee provident fund withdrawal is allowed.
While you cannot withdraw it fully, you can withdraw a partial amount. Following is a list of events when you can withdraw the Provident Fund amount and the conditions you need to fulfill
1. Marriage or education of self, children or siblings
– You should have completed a minimum of seven years of service.
– The maximum amount you can draw is 50% of your contribution
– You can avail of it three times in your working life.
– You will have to submit the wedding invite or a certified copy of the fee payable.
2. Medical treatment for Self or family (spouse, children, dependent parents)
– For major surgical operations or for TB, leprosy, paralysis, cancer, mental or heart ailments
– The maximum amount you can draw is 6 times your salary
– You must show proof of hospitalization for one month or more with leave certificate for that period from your employer.
3. Repay a housing loan for a house in the name of self, spouse or owned jointly
– You should have completed at least 10 years of service.
– You are eligible to withdraw an amount that is up to 36 times your wages.
4. Alterations/repairs to an existing home for house in the name of self, spouse or jointly
– You need a minimum service of five years (10 years for repairs) after the house was built/bought.
– You can draw up to 12 times the wages, only once.
5. Construction or purchase of house or flat/site or plot for self or spouse or joint ownership
– You should have completed at least five years of service.
– The maximum amount you can avail of is 36 times your wages. To buy a site or plot, the amount is 24 times your salary.
– Can be avail of it just once during the entire service.

10: You can file an RTI application for EPF issues

Did you know that you can file an RTI applicable to get any kind of information regarding your EPF. You can file it if you are facing issues like no clarity about EPF balance, no action taken for your EPF withdrawal or transfer. To find out information about other issues on Provident Fund. I have done a detailed post on how to file an RTI for your EPF issue.
UPDATES
  • In the recent budget 2015, the govt has made it clear that now an employee can choose between EPF and NPS. The employer will have to give this option.
  • Now the new system of UAN is in place for EPF, which has made a lot of things more simpler

Conclusion on EPF rules

The overall Employee provident fund rules are too complicated and very old. A common man does not know all these EPF rules, but knowing these minimum 10 EPF rules will help him in his financial life.



Tuesday, 24 November 2015

Think/Listen About Failures/Losses/Wrongs/Bads

                                                Every body likes Music. Hence we tend to listen good songs.
If the SONG is very good we listen it more than once. If it is a chartbuster we tend to listen it more oftenly.

                                                If we take out time say for 10 min. on a jolly free SUNDAY and think about the FAILURES of ourselves, If possible RECORD them in a MOBILE  by talking to your own.
                                               
                                                 You might know the answer to that FAILURE, HOW to make it to SUCCESS. But if you don't know then GOOGLE it or ASK your COLLEAGUE/PARENTS/WELL WISHERS in order to figure out the ANSWER.

                                                  Once you got the ANSWER,AGAIN tell it yourself and RECORD it in your MOBILE. Listen the SOLUTION like a CHARTBUSTER song Everyday, till you get the confidence that you never make it FAIL again.

                                                  

Thursday, 19 November 2015

ROUTINES not ADDING UP while exporting the TALEND JOB

1)Close the TALEND job

2)Right Click on the job in the Repository and open Setup routine dependencies and add all used routines here.

That would resolve the issue.

****TALEND "WSDL" ERRORS **** ESB component **** WEB SERVICE Request ERRORS ******

-->While using CreateOrUpdate FAMILY,
ERROR :  Unable to find field '2424739' in Family 'MI_XXXXXXX'.
SOL)Should make the ISKEY to TRUE for the corresponding KEY Columns.


-->While using CreateOrUpdate FAMILY,
ERROR : 20 Entity(s) were located in the following Family: 'MI_RISK'  with the following key values: 
SOL)Since the ISKEY to TURE is SET for the wrong KEY columns it is locating multiple ENTITY keys.

ERROR : CreateMI_RIResponse xmlns="http://meridium.com/"><MI_RIReturn><ResubmitRequest>false</ResubmitRequest><HasErrors>true</HasErrors><Records /><Messages><Message><Level>4</Level><MessageText>The value for the field MI_RI_KEY_N cannot be empty.
 Request consists of MI_RI_KEY_N value. But Response shows as NULL value.
CreateMI_RI
SOL)The fields ORDER in the WSDL and the XMLMap are different.


ERROR :The value(s) (10) were not found in the pick list for the field (Prob).
SOL)Correct PickList values needs to be passed by checking in the corresponding data.


ERROR :org.apache.cxf.phase.PhaseInterceptorChain - Interceptor for {http://meridium.com/}MI_RISKMATRService#{http://meridium.com/}LocateMI_RISKMATR has thrown exception, unwinding now
org.apache.cxf.interceptor.Fault: Response was of unexpected text/html ContentType.  Incoming portion of HTML stream: <!DOCTYPE html>
SOL)userid,password,Datasource are passed as NULL for the ESB component


ERROR :Exception in component tFileCopy_4
java.lang.RuntimeException: The source File "\\c\\BLRAPMCO.dat" does not exist or is not a file.
SOL)Username of APMCONTAINER is changed.
Username should be added in corresponding machine.
and corresponding  machine name should be added in corresponding server.


ERROR:Exception in component tAPMCSAPInput_1
java.lang.RuntimeException: Extraction failed because:ABORTED
SOL)Check Tablename from talend job.
  Add the table name in the corresponding user's authorozation profile.
 
  

java.lang.OutOfMemoryError: GC overhead limit exceeded TALEND ERROR



1)SELECT  the TALEND JOB from the JOB CONDUCTOR in TAC.
2)Go to JVM PARAMETERS  shown below and add the JVM parameter as below.




Wednesday, 4 November 2015

A Blind Man's Family Walk

                         
   I was waiting for a train i.e scheduled at 9 pm. The train about to come in 10 minutes. I have seen a Blind couple(both Husband & Wife are blind), wife carrying a baby in her hand passing by a distance of 10 metres to me.The husband was walking carrying a stick, hitting it on the ground he is knowing the path and walking. His wife was holding his shirt and was following him.
                             
                                                  My heart was trembling by seeing those couple. At any point of time, they will fall on the ground as the path has steps in front. But, it didn't happen. They were walking safely. Along with me, all the passengers who were waiting on the platform have become spectators.
                     
                                I felt so ashamed because of not helping  them to reach out of the railway station.
All the people, whom the blind couple were passing within a handful touch distance also were moving to left or right and giving them a way to pass them and not  helping them by taking the blind man's hand and  help them for a certain distance.

                                   I was hanging over there by collecting my thoughts over the blind couple once they  are out of my eyesight.

                                  First Thought :

  •  Is the path(From  A to C where B is passing Railway Station)  well known to them?
  • How come  the person married to a Blind woman knowing he was also Blind?
  • How come the couple carrying a child with them?
  • How are they surviving on daily basis?
                              Second Thought :
  • Can we call our PROBLEMS a PROBLEM we face in our(WE ARE NOT BLIND) life, when we think of how the BLIND couple life goes on daily?

Monday, 2 November 2015

Creating FILTERS for Multiple WORDS in GMAIL



By using KEYWORD "OR" between the WORDS, we can accomplish this.

Below the Example :

"nse.co.in"" OR "cpc.gov.in" OR "nsdl.co.in" OR "incometaxindiaefiling.gov.in" OR "epfoservices.in"



Friday, 30 October 2015

Stuck Vs Struck


STUCK  :
  • Stuck is when you cant move/move on from anywhere, 
  • Stuck is like "stuck in something". 
  • Stuck = caught or fixed or baffled 
Eg : "His Car was STUCK in the mud" 


STRUCK  :

Struck is something that happpens suddenly. 
Struck = affected by something overwhelming 

Eg :  Struck is being hit by something "struck by lightening", "struck by a car", etc.
  • "He was STRUCK by lightening"

Wednesday, 28 October 2015

Making Constant Value for a particular Cell

A1 cell Value = 60000
B1 cell Value =  1
B2 cell Value  = 2

C1 cell value = A1*B1


In order to make a cell value as CONSTANT you got use $ as below.

For a cell named A1,
$A$1 should be used.

For C1 cell value = A1*B1

C1=  $A$1*B1.



Friday, 16 October 2015

Land Measurements : 1 Gajam = 1 Sq Yard = 9 sq feet

1 cent = 435.600142084 sq.feet (ft2)

1 cent = 6.05 Ankana / 48 Sq.Yards/ 48 gajams

100 cents = 1 acre

1 foot = 12 inch = 30.48 cm

1 Gajam = 1 Sq Yard = 9 sq feet

100 gajams =100Sq.yard = 900 Sq.ft

Thursday, 15 October 2015

Highest dividend paying stocks in India (Updated as on October'2015)


Getting the content inside the Parenthesis in a whole String, using split() Input : (AMITABH) BACCHAN output : AMITABH

In order to get the content inside the Parenthesis of a whole String,  we can use the below code.


public class HelloWorld {
  public static void main(String[] args) {
    String str = "jhjh  (Environment) ab- ghty";
    System.out.println((str.split("\\(")[1]).split("\\)")[0]);
  }

}

In Talend you can use the below code :

(!(Relational.ISNULL(row2.Consequence)) && !(row2.Consequence.toString().isEmpty())) ? (row2.Consequence.split("\\(")[1]).split("\\)")[0] : null;

String  : (AMITABH) BACCHAN

Output : AMITABH


Solution of Notice of Defective Return under section 139(9)

Common cases when notice for defective return is sent:

– when you have filled up details of taxes paid, but have not provided income details, the Income Tax Department deems it defective.

– A notice for defective return is sent when tax deducted has been claimed as a refund, but no income details are provided in the return.

– The Department sends you a notice for defective return under Section 139(9), when you haven’t paid your taxes in full.

– when you are required to maintain balance sheet and profit and loss statement, but haven’t attached them with your income tax return, the tax return is declared defective.

– When total presumptive income under Section 44AD is less than 8% of gross turnover or recepits, ITR-4 has to be filed. A notice is sent when the filing is made on ITR-4S instead of ITR-4.

– the name mentioned on the income tax return does not match with the name on the PAN card.


when you haven’t paid your taxes in full.

You have to pay the remaining tax i.e showing up under field AMOUNT PAYABLE

1)Go to https://onlineservices.tin.egov-nsdl.com/etaxnew/tdsnontds.jsp
2)CHALLAN NO./ITNS 280 (payment of Income tax & Corporation Tax)
3)Fill the necessary details and pay the SELF ASSESSMENT TAX.
4) Get the Challan related details accordingly.

Downloading the Returns you filed in XML Format :

1)Go to https://incometaxindiaefiling.gov.in/e-Filing/UserLogin/LoginHome.html
2)Click on View Returns/Forms or Go to My Account Menu-->Click on Efiles Returns/Forms
3)Click on Ack. No of the corresponding Assessment Year.
4) In Download/Status Description you will have XML & ITR/FORM options.
5)Click on XML option and downlaod it.

Download the ITR TAX UTILITY following the below steps.

1)Go to https://incometaxindiaefiling.gov.in/e-Filing/Services/DownloadItrLink.html
2) For the Specific ITR1/ITR2/ITR2A.... which ever you got to file download the corresponding JAVA utility.
3)Once you download, Unzip it and click on ITR.bat
4)Now you can import the XML file (which is containing DEFECTS), by clicking on OPEN option.
5)You got to give the Login credentials of E-filing if asked.
6)Once the importing is done successfully, you can view all the data i.e filed by you earlier.
7)In the IT tab, add the Challan details that you have paid (Amount Payable )
8)In PART A - GENERAL tab,under Filing Status section, you got to fill the corresponding details.
    a)Return filed* ----- "18"-In Response to a notice u/s 139(9) where the original return filed was a defective retun
   b)Whether original or revised return?  -----Original
   c)Notice Number ----- Your  Communication Reference No----- (Eg : CPC/0000/B5/1000000001)
   d)If revised/defective/Modified, then enter Receipt No  ------ This is your Efiling                Acknowledgement No.
   e)Date of filing Original Return(DD/MM/YYYY)------Give the corresponding one
   f)If filed, in response to a notice u/s 139(9)/142(1)/148/153A/153C enter date of such notice --- --Please enter the date of the notice you recieved in your gmail/any email id.
  g)Residential Status*  ------RES-Resident
 h)Are you governed by Portugese Civil Code as per section 5A?(If "YES" please fill schedule 5A)*----- --No

9)After filling the above 2 tabs, click on Re-Calculate button.
10)Go to Part B- TTI tab, check Amount Payable.  It should be ZERO now.
11)Now Click on SAVE button so that it will be saved as XML format.
12)So, Now the Rectified XML is generated.

13)Now login to  https://incometaxindiaefiling.gov.in/e-Filing/UserLogin/LoginHome.html
14)Go to e-File Menu-->click on e-File in response to Notice u/s 139(9)
    Enter the Necessary details along with Acknowledgement no.
Upload the Rectified XMl i.e prepared above.
It will ask the same data which is provided in 8th Step.
So, give all the details.

15) That's it. you are done.

Thumbnail Previews Not Showing in Windows 8 Explorer?

First Option :


Option 2 :



Wednesday, 14 October 2015

Top 10 companies that pay more than 25% dividend



1.ITC

2.PAGE INDUSTRIES

3.P&G Hygiene

4.ASIAN PAINTS

5.Dabur India

6.GlaxoSmithKline Consumer Healthcare

7.Supreme Industries

8.HDFC

9.GRUH

10.PIDILITE INDUSTRIES





Sunday, 11 October 2015

White/Yellow water coming out from Left EAR continuously

Symptoms : 1) Pain in Left Ear
                    2)White water comes out from Left Ear.
                    3)Yellow water comes out from Left Ear.
                    4)Ear beat comes like heart beat from Left Ear.
                   

Occurs Because of
                         1)Pouring Hydrogen Peroxide in Left ear for removing Wax.
                         2)H202 might have caused a burning sesation in  the Left Ear drum slightly when you are pouring it.
                         3)Used Earbuds forcibly for removing Wax.
                         4)Small tiny hole might have formed in the Ear drum thru which the water is coming out.


Remedy.
------------

1) IPOD-CV tablets  1 tablet at morning and 1 tablet  at night. (For 5 days)
2)OTOCIN EAR drops 2 drops  at morning, 2 drops at evening and 2 drops at night.
3)INTRIZ PLUS 1 tablet at morning and 1 tablet  at night. (For 5 days)
4)Anac-R  (Optional) one tablet at Lunch.

Note  : If you feel more pain while using Ear drops, Please stop using it.

These are not my own Prescriptions. I have got this Prescription from a ENT Doctor for the specific Symptom I faced. So I am posting it accordingly. If you are using the above remedies, Please check whether the symptoms I mentioned above are been facing by you too. At your own risk only you got use this medicines.

1)IPOD-CV tablets
Cefpodoxime & Pottasium Clavulanate Tablets
6 tablets--Rs.234
This medication is used to treat a wide variety of bacterial infections. This medication is known as a cephalosporin antibiotic. It works by stopping the growth of bacteria.
This antibiotic treats only bacterial infections. It will not work for viral infections (e.g., common cold, flu). Unnecessary use or misuse of any antibiotic can lead to its decreased effectiveness.

2)OTOCIN EAR DROPS
Otocin Ear Drops is an antifungal medication commonly used in the treatment of fungal infections of both humans and animals such as vaginal yeast infections, oral thrush, and ringworm. It is also used to treat athlete's foot and jock itch.
Price-Rs.36


3)INTRIZ PLUS tablets
(levocetirizine HCI phenylephrine ambroxol paracetamol)
It is prescribed for maintenance of blood pressure and is used locally as a nasal or ophthalmic vasoconstrictor. contraindications Narrow-angle glaucoma, concomitant administration of monoamine oxidase inhibitors, or known hypersensitivity to this drug prohibits its use.
C-Off (Phenylephrine 10mg + Levocetrizine 2.5mg + Paracetamol 500mg + Caffeine 30mg Tablets)
Benefits:
•Phenylephrine relieves Nasal congestion
•Levocetirizine is more potent at suppressing weal & flare
•Paracetamol brings down associated fever & pain
•Caffeine elevates dull mood
Ambroxol: is a clinically proven systemically active mucolytic agent.The breakdown of acid mucopolysaccharide fibers makes the sputum thinner and less viscous and therefore more easily removed by coughing. Although sputum volume eventually decreases, its viscosity remains low for as long as treatment is maintained.
Usage:
•Rhinitis
•Sinusitis
•High Fever
•Common Cold Flu.
10 Tablets-- Rs.60


4)Anac-R
aceclofenac paracetamol rabeprazole combination
10 tablets -- Rs.120





 

Monday, 7 September 2015

How to earn maximum interest from PPF account?

If you want to earn maximum interest on your PPF account then invest money once in the year but before 5th April. In this way, you can earn interest throughout the year because the money you have invested will be the lowest balance for every month hence you can get maximum interest. If you don’t have onetime money and you want to add the money every month then invest it before 5th day of every month. 

Analysis:

§  When you invest Rs. 60,000 once a year but before 5th Apr, for 8.7% Interest Rate, then you get the interest Rs. 5,220 and the final amount will be Rs. 65,220.

Which soap do you use? Toilet soap or bathing bars?


Toilet soap is the soap used as a toiletry and the toiletry means - an object or cosmetic used in making up, dressing, etc. Due to the word toiletry, we misunderstood the concept of toilet soap. Cambridge dictionary defines the toilet soap as “a sweet-smelling soap that is intended for washing the body”.

Soap is used to clean the body and it is catagorised as toilet soap and bathing bar. The distinction (toilet soap and bathing bar) is made on the basis on amount of fatty material used to manufacture the soap. The thing to note is higher fatty material soap has better cleaning ability. Toilet soap contains more fatty material than bathing bar, so they soften the skin than bathing bar.

Total Fatty Matter (TFM) :
The soaps are rated in terms of Total Fatty Matter (TFM) contents. Good TFM soap has a good cleaning and nourishing property. TFM is a measure (in %) for identifying the amount of fatty matter present in soap i.e. more the fatty material present in soap, it is good for skin. In ideal saponification process, the ratio of fats to bases is 5:1. If we consider 5:1 ratio then TFM value of soap is 83.3% (but observed max value of TFM is 80%).


According to Bureau of Indian Standards (BIS), there are two types of soap - toilet soap and bathing bar. TFM content in bathing bar should be less than 60% but not less than 40%, while toilet soaps are categorized in three sub-categories depending on their TFM content. The TFM content of Grade I toilet soap should be 76% or above. TFM content of Grade II toilet soap should be less than 76% but not less than 70%. TFM content of Grade III toilet soap should be less than 70% but not less than 60%.

Summary :
*Toilet soap High amount of fatty material and TFM ranging from 60-80%
Bathing bar Less amount of fatty material and TFM ranging from 40-60%

  TFM % in 3 Grades.
---------------------------------------------
Grades                TFM%
---------------------------------------------
GRADE 1       76% or above

GRADE 2      > 70%   and < 76%

GRADE 3      >60% and <70%






Thursday, 20 August 2015

Know Your EPF Account BALANCE.

By using the below link you can view your EPF Balance.

http://epfindia.com/site_en/KYEPFB.php

Employee PF Account Number :   ?

There are 3 Text Boxes.
In which you got to  fill the FIRST & 3RD one.
The 2nd Text Box is not a mandatory one.


Eg: TN/12345/54321 is your PF Account No.

Then give 12345  in the First Text Box.

54321 in the last Text Box.

Note :  Make sure you select the  STATE & ESTABLISHMENT CODE correctly.

Friday, 14 August 2015

Centralized Data Across COUNTRIES

                                        COUNTRY X....The Problems that are faced in COUNTRY X and remedies they have for them, If we get that data centralized then other countries can use it and implement it accordingly.

                                       We have the Passport related information containing in a database i.e used to verify the identity of the citizen.But it is more secured and can't be viewed by all the people.

                                        MOSQUITOES are common in most of the countries.
                                        UNEMPLOYMENT is common in most of the countries.
                                        DISEASES are common in most of the countries.

                                       If we have Centralized solutions related data for the above kind of common things of all the countries, then other countries can utilize the soloutions and can become developed countries.

get it

 http://hinekv1.ddns.net:8008/get.php?username=Varga_Florentina1tv&password=j5MgWBs18t&type=m3u_plus&output=mpegts http://www.lo...