I don't mind sharing with you. I will get it over to you tomorrow while at work. Remember I have the attendance tracking system (on the daily mgt tab) set for our policy so you will have to change formulas to get it to prompt you when it's time to give warnings according to your company's policies. I have personally helped some with that so I don't mind!
It seems that a lot of people are having a need for a tracking system. I was wondering if anyone was successful with changes the formulas to fit their attendance system and having any success with it? Just wondering!
Heather
[/quote]
Hi Heather,
Thanks again for your tracking sheet. For your requested feedback: I'm not trying to convert your formulae per se. I'm using it more as a validation of my own efforts. I'm tacking a leave tracking "thing" onto my current in-house payroll system and I wanted a reality check. I like your exhaustive list of Leave Codes and that you keep the policy and discipline form right there.
My only real criticism (which is completely unfair since you're not in California) is that your sheet doesn't cover the possibility of California's rule for Pregnancy Disability colliding with the Federal rules (they don't run concurrently). More importantly, how do you update your sheets when the rules change in the middle of the year? Do you chase down your line managers and update their sheets individually? Or do you come up with a new version and swap them out?
As I indicated, I created this spreadsheet based on the needs, policies and processes of my current company. I have created several tracking systems for different companies; each of which was entirely different but it served the company's interests. Your ability to customize this spreadsheet to your company’s needs is defined by your creativity and your own computer skills. Excel is a wonderful tool, with many possibilities to track just about anything - as long as you know how to do it!<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />
It would be very easy to add the CA regs to this by creating a few new columns or changing the meaning of an existing system to represent the PDL and CFRA. It would be very important to really educate the user of the difference between the federal and state regs and how to track them. It is easily accomplished because the state regs run concurrently with the fed regs but the state regs don't run concurrently between themselves. So if the EE has a pregnancy which qualifies as a disability (16 weeks) and if the EE qualifies thereafter for the bonding (another 12 weeks), then I would track that FMLA under the state regs because they will be entitled to more than what would be permitted under the federal. You would have to add or change an existing calculation tab to represent the PDL and CRFA in the general calculation area (which is the red and green areas). Then you would have to add a few new columns in the FMLA Calculation area (where it shows if it's active or expired) and change the value to represent the allotted amount of time/leave. Again, if the EE’s pregnancy qualifies as a disability, I would use that PDL symbol (for the up to 16 weeks) and if the EE is going to be bonding with the child after delivery, then I would use the CFRA symbol for the (additional) 12 weeks.
As far as if the regs change mid-year, I don’t anticipate that happening seeing that they have just changed this year from the original FMLA of 1993; but should I be wrong, it would be up to your discretion on how you would manage that change. I would create a new version that had a row that reflects the values from the previous year or previous increment of time, which would be calculated into the equations for the new tracking system. If you noticed the two green fields at the top of the “2009” tab on the spreadsheet, then you will see that this spreadsheet already has this capability added into it already for FMLA from the previous year of 2008. If you enter an “f” into the first column and then enter any number into the next cell, you will see those numbers captured into the total FMLA for the 2009 tracking system. Remember you can create anything to match your needs with a little creativity and a lot of computer skills.
Comments
I would appreciate you sending it to me as well.
Thanks so much for sharing,
sharon.hackney@foxsys.com
Sharon
Heather,
I am new to this site and I am very interested in an FMLA tracking spreadsheet. Can you also send it to me?
kcoxgreene@qcmp.com
Thank you so much!
I know you are getting numerous requests for this but do you mind sending the spreadsheet to me as well? Thank you!
leerb@owensboro.org
Hello Everyone,
I don't mind sharing with you. I will get it over to you tomorrow while at work. Remember I have the attendance tracking system (on the daily mgt tab) set for our policy so you will have to change formulas to get it to prompt you when it's time to give warnings according to your company's policies. I have personally helped some with that so I don't mind!
Thanks,
Heather
Heather-
Can I be added to the long list of people who would like to get a copy of your tracking system? you can email it to me at jbierman@csgmail.com
Thanks so much for your assistance!
Julie
Our company complies with FMLA. May I see a copy of your tracking system? Thanks so much! gi_janearng@hotmail.com
Can I be adde to the list of people who will like to receive the FMLA tracking template. Please send it to my email juan.araya@deltaapparel.com
Thanks,
Juan.
Hey,
It seems that a lot of people are having a need for a tracking system. I was wondering if anyone was successful with changes the formulas to fit their attendance system and having any success with it? Just wondering!
Heather
[/quote]
Hi Heather,
Thanks again for your tracking sheet. For your requested feedback: I'm not trying to convert your formulae per se. I'm using it more as a validation of my own efforts. I'm tacking a leave tracking "thing" onto my current in-house payroll system and I wanted a reality check. I like your exhaustive list of Leave Codes and that you keep the policy and discipline form right there.
My only real criticism (which is completely unfair since you're not in California) is that your sheet doesn't cover the possibility of California's rule for Pregnancy Disability colliding with the Federal rules (they don't run concurrently). More importantly, how do you update your sheets when the rules change in the middle of the year? Do you chase down your line managers and update their sheets individually? Or do you come up with a new version and swap them out?
Anyhow, thanks again,
Rich
Heather,
I would really lie a copy of this also, if possible,
thanks so much,
Michelle
medwards@phi.org
I hate to jump on the band wagon but I would also appreciate a copy of your FMLA tracking program.
paul.blas@deq.idaho.gov
Thanks,
Paul
Hi Heather,
Can I jump on the bandwagon too? gbednar129@gmail.com
Thanks!
Hi Heather,
Would you please send me a copy of your tracking system? My e-mail address is donna.stevens@matesichdistributing.com. Thanks.
As I indicated, I created this spreadsheet based on the needs, policies and processes of my current company. I have created several tracking systems for different companies; each of which was entirely different but it served the company's interests. Your ability to customize this spreadsheet to your company’s needs is defined by your creativity and your own computer skills. Excel is a wonderful tool, with many possibilities to track just about anything - as long as you know how to do it!<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />
It would be very easy to add the CA regs to this by creating a few new columns or changing the meaning of an existing system to represent the PDL and CFRA. It would be very important to really educate the user of the difference between the federal and state regs and how to track them. It is easily accomplished because the state regs run concurrently with the fed regs but the state regs don't run concurrently between themselves. So if the EE has a pregnancy which qualifies as a disability (16 weeks) and if the EE qualifies thereafter for the bonding (another 12 weeks), then I would track that FMLA under the state regs because they will be entitled to more than what would be permitted under the federal. You would have to add or change an existing calculation tab to represent the PDL and CRFA in the general calculation area (which is the red and green areas). Then you would have to add a few new columns in the FMLA Calculation area (where it shows if it's active or expired) and change the value to represent the allotted amount of time/leave. Again, if the EE’s pregnancy qualifies as a disability, I would use that PDL symbol (for the up to 16 weeks) and if the EE is going to be bonding with the child after delivery, then I would use the CFRA symbol for the (additional) 12 weeks.
As far as if the regs change mid-year, I don’t anticipate that happening seeing that they have just changed this year from the original FMLA of 1993; but should I be wrong, it would be up to your discretion on how you would manage that change. I would create a new version that had a row that reflects the values from the previous year or previous increment of time, which would be calculated into the equations for the new tracking system. If you noticed the two green fields at the top of the “2009” tab on the spreadsheet, then you will see that this spreadsheet already has this capability added into it already for FMLA from the previous year of 2008. If you enter an “f” into the first column and then enter any number into the next cell, you will see those numbers captured into the total FMLA for the 2009 tracking system. Remember you can create anything to match your needs with a little creativity and a lot of computer skills.
Glad to assist!
Heather
Heather,
Looks like you have really got a lot of fans, here! Could you please send me a copy? jirwin@monmouth.com
I will be eternally grateful! Thanks.
Joanne
Could you please send me a copy of the template. Thanks. bcaudill@gswiring.com
Heather,
Can I please have a copy of your excel FMLA tracking system?
Thanks!
Hi Heather - Can you please forward your excel tracking systemto me also. My email is Marie.Shapiro@gmacm.com
Thanks
Marie
Hi Heather,
Can I please have a copy of your excel FMLA tracking system? Thank you so much for your time. (mhon_7@yahoo.com).
Heather - can I add my name to the list also. linda.willey@foa.cc
Thank you so much!
Hello Bike 1,
I'm unable to send it to you because I don't have an email address.
Thanks,
Heather
Heather,
Can you also send me the template - pstringer@gladneyagency.com
Thanks!
Hi Heather!
I was wondering if you wouldn't mind sharing this with me, as well? wendy@fremontcounseling.com
Thanks much!
Wendy
I would very much appreciate receiving this template as well. My email address is vcarr@gsiws.com
thank you - Vicki
Hi Heather,
Can you please email me the tracking file? aeshoo@ceniehoff.com
Thank you very much,
Angie
Please send me the calendar and template also
Thank you in advance
countyhr@clarendoncountygov.org
Please send me the FMLA Tracking Template, thank you kindly[:)]
lfeller@horizonhealthcare.org
Please resend to countyhr@clarendoncountygov.org
or lplemon1044@yahoo.com
Thanks so much!
Can you send the template to me as well. My email is nalawdsm@umdnj.edu
Thank you