Attendance Point Tracker

[vgarcia620]

I found an attendance point tracker that I have tried to edit to work towards our company point system...

There's some default formulas from the people who worked on it last, however I am wanting to change it to:

NCNS (2 pt)
ABS (1 pt)
Tardy after 5 minutes (0.25 pt)
Tardy after 240 minutes (0.5 pt)
Early Out (0.5 pt)

How can can I make this calculate that instead of the default values? I've attached the spreadsheet so you can look at it to see what I'm talking about.

[CAntosh]

Try entering the formula below in E2 of your "Occurrences" sheet, then fill down through the rows. You'll also need to fix your "ABS" entry on "Sheet 1", because it actually says "ABS " (with a space at the end) which throws off the vlookup.

=IFERROR(IF(TRIM($C2)="TAR",IF($D2>240,0.5,IF($D2 > 5,0.25,0)),VLOOKUP(TRIM($C2),Sheet1!$A$1:$B$5,2,FALSE)),"")

Let me know if that captures what you're after...

[vgarcia620]

Thanks Cantosh,

Actually sheet 1 is just for my reference it has nothing to do with any of the data the spreadsheet captures...

I put this formula in but it didn't do anything.

[CAntosh]

It didn't do anything at all? Here's a formula that doesn't relate to Sheet1. Put this one in E2 on the "Occurrences" sheet and fill down:

=IFERROR(IF(TRIM($C2)="TAR",IF($D2>240,0.5,IF($D2>5,0.25,0)),IF($C2="ABS",1,IF($C2="NCNS",2,IF($C2="Early Out",0.5,0)))),"")

[vgarcia620]

That worked great!

Thanks so much!!!