Desktop Application


Go Back   CiteHR Home > Human Resource Section > Forms, Formats & Questionnaires





 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 26-07-2008, 06:21 PM
tinaignu's Avatar
Join Date: May 2008
Location: Mumbai, Malad
Posts: 33
Default Emp Muster in Exl Format

What all information is necessary to be filled in the employee Muster file so that every information is available on just opening an excel sheet

These i think would be necessary

First Name
Second Name
Surname
Gender
Date of Birth
Age
Education
Previous employers
Date of Joining
Date of Confirmation
Date of leaving
Increment of the employee sub titles Salary Date Designation
PF. No,
ESIC No,
Pan No

If there is any other information that i will have to gather in order to make the muster file pls help me
__________________
Thanks
Tina Ignatius
Sponsors
  #2 (permalink)  
Old 28-07-2008, 04:08 PM
aravind karanth's Avatar
Join Date: Dec 2007
Location: Bangalore
Posts: 62
Default

hi.....

Atached is the Master Data format whcih may be useful to you....
(some cells contains formula which needs to taken care)

have a nice day...

regards
Aravind

Attached Files
File Type: xls MASTER DATA-citeHR1.xls (18.5 KB, 1332 views)
  #3 (permalink)  
Old 29-07-2008, 05:26 PM
tinaignu's Avatar
Join Date: May 2008
Location: Mumbai, Malad
Posts: 33
Default

Dear Aravind,

Went thru the excel and was really helpful and would like to know what kind of functions can be used in a master file is auto filter the best way of filtering employees who have left the company
Or there is way we can pull those employees currently employeed with us into another worksheet in the same excel book
__________________
Thanks
Tina Ignatius
  #4 (permalink)  
Old 30-07-2008, 02:06 PM
aravind karanth's Avatar
Join Date: Dec 2007
Location: Bangalore
Posts: 62
Default

Dear Tina... It can be done either way as both options can be used according to our conveience. i am using alternative work sheet for maintaing left employees details.further options in this is not explored by me till now.

regards
Aravind
  #5 (permalink)  
Old 02-08-2008, 11:08 AM
deepakluhari's Avatar
Join Date: Mar 2008
Location: Uttaranchal
Posts: 27
Default

Master data format sent by arvind is complete package to this work easily.
so gyes take care of this format.

thanks to all contributiong on this site
  #6 (permalink)  
Old 02-08-2008, 12:07 PM
dushyant_patel77's Avatar
Join Date: Jun 2008
Posts: 17
Default

thank you
  #7 (permalink)  
Old 04-08-2008, 03:18 PM
zafariqbal's Avatar
Join Date: Oct 2006
Location: Karachi
Posts: 499
Default

Good to see the attached file.
__________________
Zafar Iqbal
Karachi
Pakistan
Cell: +092-333-2346067
_______________________________________
Think, Think, Realize and Act Wisely.
Share Knowledge because knowledge grows when shared.

Think Green. Save every tree.
---------------------------------
Please don't print this message unless you really need to.
Let us together make a conscious effort to stop Global Warming.
  #8 (permalink)  
Old 04-08-2008, 05:53 PM
satishnbhandari's Avatar
Join Date: Mar 2008
Location: Goa
Posts: 18
Default

Nice usefull format..

Thanks
satish
Quote:
Originally Posted by aravind karanth View Post
hi.....

Atached is the Master Data format whcih may be useful to you....
(some cells contains formula which needs to taken care)

have a nice day...

regards
Aravind
  #9 (permalink)  
Old 04-08-2008, 06:00 PM
nneetukashyap@gmail.com's Avatar
Join Date: Aug 2008
Location: Ghaziabad
Posts: 52
Thumbs up many many thanx U

DEar arvind.thanking you realy it is so helpful to making our work ...excellent
__________________
With Warm Regards--

Neetu Kashyap TC

While Live "Alive"
  #10 (permalink)  
Old 06-08-2008, 10:01 AM
aravind karanth's Avatar
Join Date: Dec 2007
Location: Bangalore
Posts: 62
Default

Thanks to all....

Nice to see most of you found it very useful & easy to use...

kind regards
Aravind

   Post New Thread  Reply

Similar Topics

Downloads

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Thread Tags
emp, exl, format, muster

All trademarks and copyrights held by respective owners. Member comments & attachments are owned by the poster.
Privacy Policy | Disclaimer | Terms Of Service