employee attendance tracking sheet

I've got an employee attendance tracker spreadsheet that awards 1 point for every 25 days worked, then 1 point after that for every 20 days worked, then another 1 point for 20 days after that, and again 2 more times til the employee has reached 5 points. If that employee is absent and it's an unexcused absence, then that employee loses 1 point, or .5 depending on the type of leave. I've run out of ideas on how to do this and was hoping someone could help.

For more insight, can you help me with the sample excel file.

I just uploaded an excel file for you to look at. This spreadsheet template I'm using was the only one that I liked that Excel had available for templates. I've been working on this for several months periodically trying to understand the advanced formulas in this template. Each time I got a formula to work, I was asked to add to it by HR dept. This spreadsheet is super cool and it would help HR dept if I could get it to work. Being able to count 25 work days after any previous unexcused leave, adding 1 point, then another point after 20 days & so on would be helpful. The end result is to get a total of 5 points. They lose 1 point or .5 points when one of their leaves is unexcused based on the type of leave.