creating a formula/macro to create a score

Alright, I have to do a mathamatical formula at work on a daily basis. It's easy to do after a while but I have to email several people at my job with the calculated formula making it frustrating when I have to do it over and over.
I work in a nursing home and for each patient I have to calculate something called an ADL score. The end number ranges from 4 to 18 and it's pulled from 4 categories.... Bed Mobility, Transfer, Toileting, and Eating. Each number from the ADL score tells the nurse how dependant the resident is for help in those categories and how many people it takes to help them.

Self Performance is ranged between 0-4 and 8, 0 being totally independant and 4 being totally dependant and 8 meaning the Activity did not occur

Support refers to the ammount of PHYSICAL help that was given to that resident for each of the 4 categories
0=No help (independant)
1=Staff has to set up the equipment needed for that category
2=One person physically assissted the resident
3=Two people physically assissted the resident
8=Activity did not occur

Taking all of that in, here's how you calculate the resident's ADL Score

Self Performance
0 or 1
2
3, 4, 8
3, 4, 8

Support
Any Number
Any Number
0, 1, or 2
3, or 8

Total Score
1
3
4
5


Can Anyone help me make a formula in Microsoft Excel that calculates that for me so I don't have to do it for 90 resident's every day on paper???