+ Reply to Thread
Results 1 to 4 of 4

track work attendance (absent/tardiness) rolling 30 day point system

  1. #1
    Registered User
    Join Date
    03-25-2016
    Location
    Milton FL
    MS-Off Ver
    2003
    Posts
    3

    track work attendance (absent/tardiness) rolling 30 day point system

    I need some help with editing this form.
    -I need help making 15 employee slots just like N.Davidson.
    -I also need to see if you can make it so if a employee does not receive and point for 30 constitutive days he receives a + point or it adds a point back to his negative.
    -Also make it that a Call In (CI) receives no points and if employee comes to work for 15 days then he will get the point that was earned to him for the 30 days.

    So basically I need it to
    Add a point to the employee if he comes to work and not late for 30 constitutive days.
    Take off a point if employee has a unexcused absence
    Employee can earn up to +5 points (PTO Days)
    Also if employee calls in sick then we will add a new CA tag but if employee comes to work for 15 consecutive days after the CA then his points will continue from the day that he called in sick. Example
    Employee 30 days is June 30 he has came to work for every day but had to call in sick on June 3 he gets a CI on that day, but employee comes back to work on June 6 and works consecutively till June 27 now the employee is eligible for a point on June 30th if attendance is good till then.
    You can make it so each day has a P for present if that has to be a option to make this work

    http://www.megafileupload.com/f66k/A...Sheet_(2).xlsx
    Last edited by KuikViper; 05-13-2016 at 08:28 AM.

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

    Re: Help with point system for work

    Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

    Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

    To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

    (This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)




    Attach your attach your file directly to the forum.
    Ben Van Johnson

  3. #3
    Forum Guru Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Help with point system for work

    What would you suggest as a thread title?
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  4. #4
    Registered User
    Join Date
    03-25-2016
    Location
    Milton FL
    MS-Off Ver
    2003
    Posts
    3

    Re: Help with point system for work

    Sorry I thought that gave a good description of what i needed.. Could you give me a suggestion on a better one?

+ 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: 19
    Last Post: 05-12-2016, 12:24 AM
  2. Keeping track of attendance point system
    By okracerx in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-30-2013, 11:08 PM
  3. Point System HELP!
    By mfoley9723 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-14-2013, 03:47 PM
  4. USER FORMS NOT WORK AT SYSTEM 32 Bits AND SYSTEM 64Bits
    By Flash_Azul in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-16-2011, 08:02 PM
  5. USER FORMS NOT WORK AT SYSTEM 32 Bits AND SYSTEM 64Bits
    By Flash_Azul in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-09-2011, 03:16 AM
  6. Football prediction point system
    By lapot in forum Excel General
    Replies: 9
    Last Post: 08-19-2011, 12:11 PM
  7. Creating a accumaltive point system
    By ausindo in forum Excel General
    Replies: 3
    Last Post: 08-30-2010, 08:07 PM

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