Hi group< Please give me a format for Leave Tracker.its urgent need.
Thanks Looking in to my Query. Regards chandrabhan Singh +919911255330 On Sat, Feb 27, 2010 at 1:45 AM, Prabhat Kumar m...@ff@rPur/Delhi < cs4...@gmail.com> wrote: > Dear sir, > > I have a new Challenge to Maintain Leave Records of Employee in my > Company.First of all i want to share some information about > Leave Policy. > > All employee who's Tenure is 6 Months or more is Eligible to take 9 Annual > Leave & Apart from Week offs Employee can Take 1 casual Leave each > month.Over all 18 Al in a Year & 12 CL. > > But In case of CL:-if Employee is not able to take his/her casual Leaves > within 3 Months. his/her CL will expire.we can't carry forward his leave in > Next Month. > > In case of AL:-After every 6 months Employee can Take 9 Als > if Employee is not able to take his/her Als with in 2 Year > Including Current Year then his Al will Expire. > > Please Find Attached Leave Tracker for Reference. > > > > > > Happy holi for u & ur Family & for Lovely group. > > > Regards > chandrabhan Singh > +919711535271 > > > wrote: > > Dear Chandrabhan, >> >> If this is not late, I would expect you to send a dummy test file and let >> me give a try on this. While sending the test file, be specific what you >> want as an outcome. If possible, try to provide the snapshot of the >> expected result as well. >> >> -- >> Thanks & Regards, >> >> DILIP KUMAR PANDEY >> MBA-HR,B.Com(Hons),BCA >> Mobile: +91 9810929744 >> dilipan...@gmail.com >> dilipan...@yahoo.com >> New Delhi - 62, India >> >> >> On 2/8/10, chandrabhan singh <cs4...@gmail.com> wrote: >>> >>> Dear Andy, >>> >>> Please do a favor for me could you make this on excel Sheet with VB >>> programming.one sheet would be data base & second Sheet would >>> be Snapshot where i can select Team Leader's name by Validation >>> & it will calculate Absent ism & Shrinkage(%) of that Team Leader Itself. >>> >>> >>> >>> >>> On Sun, Feb 7, 2010 at 2:57 PM, Aindril De <aind...@gmail.com> wrote: >>> >>>> Hi Chandhrabhan, >>>> >>>> Your query might be a little misplaced as it is a forum mainly for Excel >>>> users. However I am attaching a few links as pointers that might help you >>>> to >>>> easily resolve your query. >>>> >>>> http://support.microsoft.com/kb/308459 >>>> http://office.microsoft.com/en-us/access/HA010345961033.aspx >>>> http://www.dbtoolsplus.com/ >>>> >>>> The last link profides some freeware tools to generate reports directly >>>> from Access to HTML. >>>> >>>> Regards, >>>> Andy >>>> >>>> >>>> On Sun, Feb 7, 2010 at 11:25 AM, chandrabhan singh >>>> <cs4...@gmail.com>wrote: >>>> >>>>> Hi Group, >>>>> >>>>> Please Help me.i have to created a data base name Attendance Tracker.In >>>>> which i have to Mention >>>>> Emp. code of Team Leaders,Name,Service Level,Count of Roster ed >>>>> Agent's.After getting save these >>>>> field.what i want next day when i filled count of Present Agent >>>>> Status.Program will automatically calculate >>>>> Absent ism & Shrinkage(%) of Each Team Leaders Apart from which i want >>>>> to show report in >>>>> HTML or Front page but i don't know how to write a connection >>>>> code.Please find attached file along with >>>>> mail attendance tracker.Please Cross Check these code.Plz help me. >>>>> >>>>> >>>>> Thanks&Regards >>>>> c...@ndr@b...@n Singh >>>>> 9911255330 >>>>> >>>>> -- >>>>> >>>>> ---------------------------------------------------------------------------------- >>>>> Some important links for excel users: >>>>> 1. Follow us on TWITTER for tips tricks and links : >>>>> http://twitter.com/exceldailytip >>>>> 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at >>>>> http://www.excelitems.com >>>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>>>> >>>>> >>>>> To post to this group, send email to excel-macros@googlegroups.com >>>>> If you find any spam message in the group, please send an email to: >>>>> Ayush Jain @ jainayus...@gmail.com >>>>> <><><><><><><><><><><><><><><><><><><><><><> >>>>> HELP US GROW !! >>>>> >>>>> We reach over 6,700 subscribers worldwide and receive many nice notes >>>>> about the learning and support from the group.Let friends and co-workers >>>>> know they can subscribe to group at >>>>> http://groups.google.com/group/excel-macros/subscribe >>>>> >>>> >>>> -- >>>> >>>> ---------------------------------------------------------------------------------- >>>> Some important links for excel users: >>>> 1. Follow us on TWITTER for tips tricks and links : >>>> http://twitter.com/exceldailytip >>>> 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at >>>> http://www.excelitems.com >>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>>> >>>> >>>> To post to this group, send email to excel-macros@googlegroups.com >>>> If you find any spam message in the group, please send an email to: >>>> Ayush Jain @ jainayus...@gmail.com >>>> <><><><><><><><><><><><><><><><><><><><><><> >>>> HELP US GROW !! >>>> >>>> We reach over 6,700 subscribers worldwide and receive many nice notes >>>> about the learning and support from the group.Let friends and co-workers >>>> know they can subscribe to group at >>>> http://groups.google.com/group/excel-macros/subscribe >>>> >>>> >>> >>> >>> >>> -- >>> With Regards >>> chandrabhan Singh >>> +919711535271 >>> >>> >>> -- >>> >>> ---------------------------------------------------------------------------------- >>> Some important links for excel users: >>> 1. Follow us on TWITTER for tips tricks and links : >>> http://twitter.com/exceldailytip >>> 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at >>> http://www.excelitems.com >>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>> >>> >>> To post to this group, send email to excel-macros@googlegroups.com >>> If you find any spam message in the group, please send an email to: >>> Ayush Jain @ jainayus...@gmail.com >>> <><><><><><><><><><><><><><><><><><><><><><> >>> HELP US GROW !! >>> >>> We reach over 6,700 subscribers worldwide and receive many nice notes >>> about the learning and support from the group.Let friends and co-workers >>> know they can subscribe to group at >>> http://groups.google.com/group/excel-macros/subscribe >>> >> >> >> >> > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
