+ Reply to Thread
Results 1 to 9 of 9

Attendance Tracker Where Points Drop Off

  1. #1
    Registered User
    Join Date
    04-15-2015
    Location
    minneapolis, mn
    MS-Off Ver
    2010
    Posts
    36

    Attendance Tracker Where Points Drop Off

    I have an attendance tracker right now where it's dated 1/1/15 through 12/31/15. Each box, for each employee, has a drop-down that allows you to select one of 3 incidents - LA, LE or CI for Late, Left Early and Called In - if there was an incident.

    The way the point system at work works is that if you're late or leave early you get 1 point, if you call in you get 2 and if you go a pay cycle without any incidents (la, le, ci) you get 2 points back.

    Is there a way to define days (pay days) and state that if an employee doesn't have an incident during this time period after their last incident, 2 points are deducted from the overall total? I've got the points to add up correctly, I just can't figure out how to remove them after a certain time.

    If there IS a way to do this, is there a way to make it so that if the points equal 10 at any time during the calendar year, the background color changes red or some color?

  2. #2
    Forum Contributor LokeshKumar's Avatar
    Join Date
    03-31-2015
    Location
    India
    MS-Off Ver
    All, mostly 2010 now..
    Posts
    471

    Re: Attendance Tracker Where Points Drop Off

    Hi,
    Could you please upload the sample file with the required result......
    Lokesh Kumar
    Stay Hungry.. Stay Foolish..
    _________________________________________________________
    Please Click STAR to Add Reputation if my/someone's answer helped!

  3. #3
    Registered User
    Join Date
    04-15-2015
    Location
    minneapolis, mn
    MS-Off Ver
    2010
    Posts
    36

    Re: Attendance Tracker Where Points Drop Off

    Sorry! I thought I did! I actually found the spreadsheet elsewhere and have modified it a bit.

    I've attached it now and just can't figure out how to make it so that after a payday, points drop off.

    Thanks for your help!



    attendancetracker.xlsx

  4. #4
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2013
    Posts
    8,550

    Re: Attendance Tracker Where Points Drop Off

    Where you want the result and how you required to result and what is your expected result in this case
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

  5. #5
    Registered User
    Join Date
    04-15-2015
    Location
    minneapolis, mn
    MS-Off Ver
    2010
    Posts
    36

    Re: Attendance Tracker Where Points Drop Off

    On the 1st tab, where it shows the 12 Mos Points, I want that number to be able to fluctuate -- right now you can see the points that have been assigned thus far. I'm trying to be able to specify days so that if a person doesn't get any points during that time, 2 points are deducted from their overall total. They're also allowed to bank up to 5 points (meaning the 12 Mos Points number could go as low as -5).

    Can I specify ranges of days and if a point is accrued during that time, 2 points are taken off?

  6. #6
    Registered User
    Join Date
    04-15-2015
    Location
    minneapolis, mn
    MS-Off Ver
    2010
    Posts
    36

    Re: Attendance Tracker Where Points Drop Off

    If need be, I don't mind there being an extra box that takes the 12 Mos Points and calculates something else to show the points after points are awarded back for "good behavior".

  7. #7
    Registered User
    Join Date
    04-15-2015
    Location
    minneapolis, mn
    MS-Off Ver
    2010
    Posts
    36

    Re: Attendance Tracker Where Points Drop Off

    Any thoughts? I can't figure out how to either specify days and if no points are earned during that time 2 are taken off or have a counter start from the beginning to define timeframes and if no points are gained then 2 points are taken off? Something just so that if they don't miss a day or aren't late or leave early within a pay period, 2 points are removed from their total points.
    Last edited by kwood41799; 04-20-2015 at 02:04 PM.

  8. #8
    Registered User
    Join Date
    04-15-2015
    Location
    minneapolis, mn
    MS-Off Ver
    2010
    Posts
    36

    Re: Attendance Tracker Where Points Drop Off

    I found some examples on how to take points off after 90 days but I need it different than that.

    Anyone know of any formulas that can be used for what I'm looking to do?

  9. #9
    Registered User
    Join Date
    04-15-2015
    Location
    minneapolis, mn
    MS-Off Ver
    2010
    Posts
    36

    Re: Attendance Tracker Where Points Drop Off

    Anyone have any ideas? I still can't figure out how to take off numbers from a certain date range / time period.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 10
    Last Post: 03-17-2016, 05:34 AM
  2. Need Help - AutoCalculate Attendance Points for employee attendance records
    By switzd0d in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-17-2015, 03:00 PM
  3. Replies: 1
    Last Post: 10-24-2014, 09:57 PM
  4. Formula to look back 90 days and drop point on attendance tracker
    By tmorr24 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-22-2014, 01:27 AM
  5. Attendance Tracker with drop downs
    By DentonHTHS in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-08-2008, 08:55 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1