Attendance Points Calculation

[cjroper111]

Hello,

I welcome the opportunity to correspond with persons with Excel experience.

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.

[AliGW]

For the points, you would set up a lookup table.

It is far better to keep your data together in one workbook. There is no need for it to be subdivided by month. You would need the list of employees on one sheet and attendance records on another.