+ Reply to Thread
Results 1 to 2 of 2

Attendance Spreadsheet and point system

  1. #1
    Registered User
    Join Date
    03-21-2017
    Location
    Bloomsburg, PA
    MS-Off Ver
    2010
    Posts
    1

    Attendance Spreadsheet and point system

    I need help building a spreadsheet that will keep track of employee attendance points with the following criteria:

    1 Point for Tardy 6 mins or greater
    1 Point for completed more than 4 hours
    2 Points for completed less than 4 hours
    3 Points for Call Off
    9 Points for No Call/No show

    Employees are rewarded 1 point back when they went a whole month without getting a single point.

    I just want a separate tab with Employee Names, Employee ID Numbers, and their total points as column headers.

    If someone could build a sample spreadsheet for me it would be greatly appreciated

  2. #2
    Valued Forum Contributor
    Join Date
    01-19-2012
    Location
    Barrington, IL
    MS-Off Ver
    Excel 2007/2010
    Posts
    1,211

    Re: Attendance Spreadsheet and point system

    I would suggest doing some searching around on here for similar projects, and using those as a framework to build as much as you can yourself. If you get stuck on a particular part, create a thread asking for help with that part.


    To be frank, this is an Excel Help forum, not so much a build-me-an-application-from-scratch-for-free-please forum
    You should hit F5, because chances are I've edited this post at least 5 times.
    Example of Array Formulas
    Quote Originally Posted by Jacc View Post
    Sorry, your description makes no sense. I just made some formula that looks interesting cause I had nothing else to do.
    Click the * below on any post that helped you.

+ 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. Attendance Point System Spreadsheet with Rolling 1-year Points Reversal
    By mfoley9723 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-04-2018, 04:46 PM
  2. Replies: 10
    Last Post: 07-20-2018, 09:55 PM
  3. Replies: 19
    Last Post: 05-12-2016, 12:24 AM
  4. Replies: 10
    Last Post: 03-17-2016, 05:34 AM
  5. Point System Attendance - Pivot Table Assistance
    By nikakims in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-14-2014, 07:43 PM
  6. create an attendance point system with yearly reversal
    By Ed Terry in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 02-12-2014, 08:04 PM
  7. Keeping track of attendance point system
    By okracerx in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-30-2013, 11:08 PM

Tags for this Thread

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