How can I create a point system for attendance, tardies, absents, etc.?

**amytr1122** · 12-27-2012, 05:19 PM

I need to create a spreadsheet that will record tardies, excused call-ins and unexcused call-ins for employees.

For example, one tardy = 0.5 points, one excused call in = 1 point, and one unexcused call in = 3 points.

I plan to record these figures monthly. If I enter that Amy was tardy 7 times with one unexcused call-in that month, I want Excel to show that she has accumulated 6.5 points [(0.5 x 7) + 3].

I have attached an example spreadsheet. I'm new to excel so any help is appreciated!! Thank you!

ABSENT.xlsx

**Melvinrobb** · 12-27-2012, 06:16 PM

The attached file should work.
I gave two possible solutions. I suggest using the 2nd solution, as it is more intuitive, and easier to change if needed.

**swhitesell** · 12-27-2012, 06:16 PM

Here's an example of what you want. You will need to change the total formula each time you add a new month.

ABSENT.xlsx

**Moo the Dog** · 12-27-2012, 06:29 PM

And yet another possibility...

- Moo

**amytr1122** · 12-27-2012, 06:35 PM

Thank you everyone for your responses! You guys helped a bunch.

**Moo the Dog** · 12-27-2012, 08:36 PM

You're welcome! Glad to help.

- Moo

**amytr1122** · 12-31-2012, 04:47 PM

I have a few more questions!!

How do I come up with a rolling system to add and deduct the points as their attendance changes?
The goal of each employee is to have the least amount of points as possible, because he/she will be penalized once they receive a certain amount of points.
Let's say that Jane was hired in October. She has accumulated 10 points by December from tardies, call-ins, etc. By the end of January, she has perfect attendance; she is awarded half a point to be taken off toward her 10, giving her 9.5. In February, there is a day she does not show up, so now her total goes up to 12.5 (3 pointed added because of NCNS-no show no call). In March and April, she has perfect attendance, so now her total is 11.5. (half a point allowed for each month with perfect attendance)

By rolling, I mean a formula that will calculate continuously over month after month, year after year.

THANK YOU!!!!!

**aewilliamson** · 03-15-2013, 10:43 AM

Originally Posted by amytr1122

I have a few more questions!!

How do I come up with a rolling system to add and deduct the points as their attendance changes?
The goal of each employee is to have the least amount of points as possible, because he/she will be penalized once they receive a certain amount of points.
Let's say that Jane was hired in October. She has accumulated 10 points by December from tardies, call-ins, etc. By the end of January, she has perfect attendance; she is awarded half a point to be taken off toward her 10, giving her 9.5. In February, there is a day she does not show up, so now her total goes up to 12.5 (3 pointed added because of NCNS-no show no call). In March and April, she has perfect attendance, so now her total is 11.5. (half a point allowed for each month with perfect attendance)

By rolling, I mean a formula that will calculate continuously over month after month, year after year.

THANK YOU!!!!!

Just curious, were you able to find a solution? I'm looking for the same thing, so would love to find out.

**fariken** · 02-12-2015, 02:46 AM

How to ctreate a template base on the range point & calculate the accumulative point from Jan until dec?

Example: the entire platform will be given 1 point if meeting the target from day 1 until 6 accumulatively. 5 points will be given if meeting the target until 7 to 18 days. There are no point if any day not meeting the target & later, the point system will reset to 0 again.

**cjroper111** · 07-20-2018, 08:58 PM

Question. How can you create an attendance sheet that will apply points based on reason (Ex: Tardy=0.5, Call In=1.0, No Call/No Show=2.0, Vacation=0.0; etc.) plus subtract points, if applied, if a person works a certain amount of days perfect attendance?

My thought process is to either do a continuous spreadsheet or separate based on month in different workbooks but maybe have a main workbook linked to the monthly workbooks with a listing of each employee's names with their total points.

I know this would work better in Access but I was wondering if Excel could be set up to do this?

Thanks.

**protonLeah** · 07-20-2018, 09:55 PM

cjroper111,
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.

How can I create a point system for attendance, tardies, absents, etc.?

LinkBack

Thread Tools

Rate This Thread

Display

How can I create a point system for attendance, tardies, absents, etc.?

Re: How can I create a point system for attendance, tardies, absents, etc.?

Re: How can I create a point system for attendance, tardies, absents, etc.?

Re: How can I create a point system for attendance, tardies, absents, etc.?

Re: How can I create a point system for attendance, tardies, absents, etc.?

Re: How can I create a point system for attendance, tardies, absents, etc.?

Linking pages? How to add/deduct points as criteria met?

Re: Linking pages? How to add/deduct points as criteria met?

Re: How can I create a point system for attendance, tardies, absents, etc.?

Re: How can I create a point system for attendance, tardies, absents, etc.?

Re: How can I create a point system for attendance, tardies, absents, etc.?

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions