90 rolling attendance tracker

I have two things I am trying to accomplish with this attendance log for my company. I need to be able to track out employees attendance and calculate their attendance occurences when they miss. I have gotten the worksheet to calculate using the IF forumale however am now constricted by the length of the formula. I am hoping that I can get help with shortening this down or an easier to accomplish what I am trying to do.

In Column E the sheet looks through columns F through CQ to see if an employee has any of the following AU, LEU, LEU1, TU, NCNS, or LLU. Each of these have different meanings however some of them share the same occurence value. What I want to do if go into the Columns of F through CQ and place any of the characters in and then column E will sum up their 90 day ocurrence value. AU = 1, LEU = .33, LEU1= 1, TU = .33, NCNS = 3, & LLU = .33

Currently this formula looks something along the lines of this

=IF(F5="LEU",0.33)+IF(G5="LEU",0.33)

I believe this could be shortened out to combine Reasons like AU, LEU1 & LEU, TU, LLU.

Secondly I need this workbook to be updated to maintain 90 days. With what I currently Have I try to delete the oldest date and insert the newest but the Formula seems to break everytime and cannot figure out how to keep this intact so I can simply add the current date and remove the oldest.

Rather it would be easier to maintain just the first sheet for the year and 90 days and have Column E look at todays date and sum all the occurence values for todays date plus the prior 90 days.

Any help would be appreciated.