Closed Thread
Results 1 to 7 of 7

Attendance Point System Spreadsheet with Rolling 1-year Points Reversal

  1. #1
    Registered User
    Join Date
    03-13-2013
    Location
    kentucky
    MS-Off Ver
    Excel 2003
    Posts
    2

    Attendance Point System Spreadsheet with Rolling 1-year Points Reversal

    I have a point system at work where if your late 1 point. Gone the entire day 2 points. After 20 points your gone. Points come off a year later from the day it was assigned per the previous year. Does anyone have a spreadsheet already configured where each day the employee's total point are auto tabulated, where it goes back 365 days from the current date and reverses them back, with a new year to date total. Sounds complicated but I think anyone that has a point system that reverses points back on a rolling one year basis knows what I'm looking for.

  2. #2
    Registered User
    Join Date
    01-02-2013
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Attendance Point System Spreadsheet with Rolling 1-year Points Reversal

    Did you ever find what you were looking for as I would be interested in such a sheet as well?

  3. #3
    Registered User
    Join Date
    02-12-2014
    Location
    Atlanta, Georgia
    MS-Off Ver
    Excel 2007
    Posts
    1

    Re: Attendance Point System Spreadsheet with Rolling 1-year Points Reversal

    I am looking for the exact spreadsheet. Were you able to find the spreadsheet? If so, please let me know.

    thanks

  4. #4
    Registered User
    Join Date
    10-20-2014
    Location
    wisconsin
    MS-Off Ver
    2010
    Posts
    1

    Re: Attendance Point System Spreadsheet with Rolling 1-year Points Reversal

    Has anyone found something like this yet??

  5. #5
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,079

    Re: Attendance Point System Spreadsheet with Rolling 1-year Points Reversal

    bobbi garrick,
    Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

    If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

    Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
    Ben Van Johnson

  6. #6
    Registered User
    Join Date
    01-02-2013
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Attendance Point System Spreadsheet with Rolling 1-year Points Reversal

    Update: I never found a sheet to do this.

  7. #7
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2016
    Posts
    10,196

    Re: Attendance Point System Spreadsheet with Rolling 1-year Points Reversal

    Treetom,

    Bummer after five years you could not find what you need. If you have a question about this particular need, please post a thread of your own.
    HTH
    Regards, Jeff

Closed Thread

Thread Information

Users Browsing this Thread

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

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