Hi All
Every one says that it very nice steps. May i know that How it is good and useful to all. if you calculate the amount on 14500 pm - Employee Contribution 1.75% = Rs. 254 and Employers @4.75% = Rs. 689 total amount will pay =254+689= Rs. 943 very month it means =943*12=Rs. 11316 per annu.
If you see point view on facility ESIC not provide good service for the same. for example if you go for any treatment. you will wait for 1 hours to 2 hours after they forward you to another Dr. or another Department then you will go for Dispensary to take your medicane it will take 1 to 2 hours in q.
One question to all of you How many employee take benefits from ESIC?
As per my view only 25 %. I was covered ESIC around 2 years but i have not go for any treatment in between the period.
if you invest such amount at Mediclaim you can get more and good facility comparison to ESIC. you will invest only around 3000 per annu.
I am not a client of Medicalim company but i am employee of PVT Ltd. co. as HR- Executive.
as per my view it is not good for us. What is your views please reply to us.
From India, New Delhi
3Every one says that it very nice steps. May i know that How it is good and useful to all. if you calculate the amount on 14500 pm - Employee Contribution 1.75% = Rs. 254 and Employers @4.75% = Rs. 689 total amount will pay =254+689= Rs. 943 very month it means =943*12=Rs. 11316 per annu.
If you see point view on facility ESIC not provide good service for the same. for example if you go for any treatment. you will wait for 1 hours to 2 hours after they forward you to another Dr. or another Department then you will go for Dispensary to take your medicane it will take 1 to 2 hours in q.
One question to all of you How many employee take benefits from ESIC?
As per my view only 25 %. I was covered ESIC around 2 years but i have not go for any treatment in between the period.
if you invest such amount at Mediclaim you can get more and good facility comparison to ESIC. you will invest only around 3000 per annu.
I am not a client of Medicalim company but i am employee of PVT Ltd. co. as HR- Executive.
as per my view it is not good for us. What is your views please reply to us.
From India, New Delhi
Dear all,
thanks for your compliments..
First of all let me clear one thing that I am not professional Adv Excel programer .I am a amateur creator of Adv Excel .Basically I m B.E(Electrical Engg) working with R.P.G Groups.I created all the excel sheet in my leaisure Time to mitigate our routine jobwork..
My all Programs are Userfriendly(You can Put your Comapny name-Logo)in any sheet there is no indication about it's creator in any sheet(Except Main sheet) and all Sheets are free. If you see it in detail you will find that I have no given any password for formula.You can see all logic in taskbar..All data entry cells have no password.
I have protected sheet for Password due to two reason..
(1) To take extreme work from Excel there is a logic formulas for that and It should be hide otherwise unauthorised entries in coloums will ruin Logic of Programs and It might not give proper results
(2) there are linking from cells to cells or Sheets to sheets so to protect the linking We should not Add-Delete row or coloum in any sheet ..if someone enter new row or coloum there is a chance to damage logic formulas(Because User doesn't know where I have put logical formulas)..that's why I gave protection to sheet for preventing unauthorised adding-deleting.
(3) In simple Example if i have declare file name"XYZ" for the cell A1:A200 and if some one add new row or copy past previous row than in this situation logic doesn't work because I have declare cell 1 to200 and new row 201 is not declered in my logic so Program doesnt work or give guarbage value??
(4) here You can not copy-past-Adding-Deleting new row/coloum because of Formulas.
If Sheet is not Password Protected and If some one unfortunely enter data in Logic cell and if formula is delete than it is very hard to find out the fault...Thats why I gave password to avoid unwanted entry in formula cell..
Most of Professional crator Put Their Password and give Demo version to user If User like that program than He has to buy Full version from them But if you notice that My all programs are not Demo version..All are full version but for giving password the reason I explain above only...Not to take any charge or monopoly..
I have also got some mail regarding round figure of amount in programs,Some of our Friends need round figures of data...So I have make necessary correction and again put on my website..If anybody need such type of correction please download from site..
I think i have give better clarification regarding password...
If anybody want to sharp their knowledge of EXCEL, I have put 200 Books/Materials for EXCEl PROGRAMING,MACRO,VBA... on above site and it's Totally Free.
From India, New Delhi
thanks for your compliments..
First of all let me clear one thing that I am not professional Adv Excel programer .I am a amateur creator of Adv Excel .Basically I m B.E(Electrical Engg) working with R.P.G Groups.I created all the excel sheet in my leaisure Time to mitigate our routine jobwork..
My all Programs are Userfriendly(You can Put your Comapny name-Logo)in any sheet there is no indication about it's creator in any sheet(Except Main sheet) and all Sheets are free. If you see it in detail you will find that I have no given any password for formula.You can see all logic in taskbar..All data entry cells have no password.
I have protected sheet for Password due to two reason..
(1) To take extreme work from Excel there is a logic formulas for that and It should be hide otherwise unauthorised entries in coloums will ruin Logic of Programs and It might not give proper results
(2) there are linking from cells to cells or Sheets to sheets so to protect the linking We should not Add-Delete row or coloum in any sheet ..if someone enter new row or coloum there is a chance to damage logic formulas(Because User doesn't know where I have put logical formulas)..that's why I gave protection to sheet for preventing unauthorised adding-deleting.
(3) In simple Example if i have declare file name"XYZ" for the cell A1:A200 and if some one add new row or copy past previous row than in this situation logic doesn't work because I have declare cell 1 to200 and new row 201 is not declered in my logic so Program doesnt work or give guarbage value??
(4) here You can not copy-past-Adding-Deleting new row/coloum because of Formulas.
If Sheet is not Password Protected and If some one unfortunely enter data in Logic cell and if formula is delete than it is very hard to find out the fault...Thats why I gave password to avoid unwanted entry in formula cell..
Most of Professional crator Put Their Password and give Demo version to user If User like that program than He has to buy Full version from them But if you notice that My all programs are not Demo version..All are full version but for giving password the reason I explain above only...Not to take any charge or monopoly..
I have also got some mail regarding round figure of amount in programs,Some of our Friends need round figures of data...So I have make necessary correction and again put on my website..If anybody need such type of correction please download from site..
I think i have give better clarification regarding password...
If anybody want to sharp their knowledge of EXCEL, I have put 200 Books/Materials for EXCEl PROGRAMING,MACRO,VBA... on above site and it's Totally Free.
From India, New Delhi
Hi
Thanks that is really useful, could you also please give the details of taxable and non taxable part of the salary structure as i have to make a salary break up for senior position level and would like to give in that form so that he can get maximum benefit for tax.
pl advise
Ruby
From India, Delhi
Thanks that is really useful, could you also please give the details of taxable and non taxable part of the salary structure as i have to make a salary break up for senior position level and would like to give in that form so that he can get maximum benefit for tax.
pl advise
Ruby
From India, Delhi
Mr.jigu u have protected your sheet,if i have to use this then how i ll unprotect it,i dont know the password,,,,,,,pls reply
From India, Nagpur
From India, Nagpur
Please find revised Program.
In this you will change or delete category of Salary Structure as per your requiremnts..
You can also hide or formate data as per your requirement..
This is more usefriendly program compare to previous one.
@ premierindia
Request to read all instruction / Direction given in program-"May I help You Sheet"..This will guide you how to enter data in program.
From India, New Delhi
In this you will change or delete category of Salary Structure as per your requiremnts..
You can also hide or formate data as per your requirement..
This is more usefriendly program compare to previous one.
@ premierindia
Request to read all instruction / Direction given in program-"May I help You Sheet"..This will guide you how to enter data in program.
From India, New Delhi
hello sanjeev,
can you pls advice if employers contribution towards PF is 12 % of basic +DA or 12 % of basic only .I other words if basic pay is Rs4000/ and DA is Rs3000, employer needs to contribute 12% of Rs4000/ or 12 % of Rs6500 ceiling considering basic + DA
thanks raghuvir
From India, Madras
can you pls advice if employers contribution towards PF is 12 % of basic +DA or 12 % of basic only .I other words if basic pay is Rs4000/ and DA is Rs3000, employer needs to contribute 12% of Rs4000/ or 12 % of Rs6500 ceiling considering basic + DA
thanks raghuvir
From India, Madras
hello CVH, Can you pls confirm again that HRA is tax free and does not fall under income tax, is there a ceiling in Rs or % of basic for HRA . thanks raghuvir
From India, Madras
From India, Madras
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.
Salary Structure Calculator.xls