S.Chandrasekar
Hr-manager, Trainer, Writer
Priyankakaw
Hr Manager
+1 Other

Cite.Co is a repository of information and resources created by industry seniors and experts sharing their real world insights. Join Network
Hi Members
Here i felt in suituation were have to submit the Attendence stating in percentage(%) which inculdes Noof days prsent, abscent, leaves they have taken,weekly offs etc.
It will be very helpfull for me if any body could send me the formula to solve it
Warm regards
Deeplika

From India, Hyderabad
Based on your query, I think I can help you out in Attendance MIS.
In the Excel sheet design a format like this with the formula,
for every employee /ID.

Name Month Working Days Present leave % Attdance % Absence
----- ------ ------------- ----- ----- ------------ -----------

RAM --August--- 31-- 29-- 2 ---=29/31*100 ---- =2/31*100
RAM --Sep ----- 30---30-- 0 --- =30/30*100 ---- =0

Generally a company with Mon-Frid working has 22 working days in a month
Generally a company with Mon-Sat working has 26 working days in a month
Always add Sundays/National Holidays/Decalred Holidays/Allowable SL,CL,EL as days present.
Any number of days going beyond the quota allowed, just mark as Loss of pay and mark absent. You can further depict a graph or chart for every employee and also a chart for total attendance report picture for company as whole.

For total attendance monthwise,

Date Total strength Present absent % Present % Absent
---- ------------- ------ ----- -------- --------
4-Aug~~ 164 ~~158~~ 6 ~~=158/164*100 ~~ =6/164*100
5-Aug ~~167 ~~164 ~~ 3 ~~and so on

As and when new joinees come, daily strength will increase and when they resign strength will go down accordingly. For any doubts, please reply me.

Hope the formula is simple.

Regards,
Chandru

From India, Madras
quote=S.Chandrasekar;526452]Based on your query, I think I can help you out in Attendance MIS.
In the Excel sheet design a format like this with the formula,
for every employee /ID.

Name Month Working Days Present leave % Attdance % Absence
----- ------ ------------- ----- ----- ------------ -----------

RAM --August--- 31-- 29-- 2 ---=29/31*100 ---- =2/31*100
RAM --Sep ----- 30---30-- 0 --- =30/30*100 ---- =0

Generally a company with Mon-Frid working has 22 working days in a month
Generally a company with Mon-Sat working has 26 working days in a month
Always add Sundays/National Holidays/Decalred Holidays/Allowable SL,CL,EL as days present.
Any number of days going beyond the quota allowed, just mark as Loss of pay and mark absent. You can further depict a graph or chart for every employee and also a chart for total attendance report picture for company as whole.

For total attendance monthwise,

Date Total strength Present absent % Present % Absent
---- ------------- ------ ----- -------- --------
4-Aug~~ 164 ~~158~~ 6 ~~=158/164*100 ~~ =6/164*100
5-Aug ~~167 ~~164 ~~ 3 ~~and so on

As and when new joinees come, daily strength will increase and when they resign strength will go down accordingly. For any doubts, please reply me.

Hope the formula is simple.

Regards,
Chandru[/quote]

Thanx chandru that was very informative post.

From India, Mumbai
Dear Frds,
Pls suggest me ........ that if a employeee is working some where and recently has joined our orgnisation he already have the ESI card and number ..... than what we have to do wheather we have to apply for new card and number or old card and number will work here.....
Quick reply will be helpfull and appreiciated
Thanks

From India, Patiala
Dear Suraj,
In case of ESI / PF it is transferable like if the new recruit is joining and is still under ESI / and has PF account in both the cases, his earlier ESI & PF account number can be transfered. But you need to issue him the new ESI card as company name will be changed the ESI card number will remain same and the location and number of hospitals falling in that location will get change accordingly.
In case of any query please revert.
thanks
Priyanka

From India, Delhi
HI
In ESI form-1 of Employee declaration, on the right hand side fill in the Item no-12. This asks for Previous employer details and your Previous ESI Insurance No.
If you want that old No to be transferred then forget not to fill this. I have seen that many employees are just ignoring it as 'headache' as they would have misplaced.
Regards,
Chandru

From India, Madras
This discussion thread is closed. If you want to continue this discussion or have a follow up question, please post it on the network.
Add the url of this thread if you want to cite this discussion.






About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service



All rights reserved @ 2020 Cite.Co™